I have a problem with the poligonization.
I have a table that contains the my borderstones. The second table defines the next and previous point. It is important because these are attribute datas.
//the "allaspont" mean the borderstone_id
After that I created a VIEW, ther resoult:
CREATE OR REPLACE VIEW view_linestring AS SELECT w.id, w.szama, ST_SetSRID(ST_MakeLine((select ST_AsText(geom) from borderstone where id = c.allaspont) , (select ST_AsText(geom) from hatarko2 where id = c.kovetkezo)),23700) as geom FROM hatarko2 w, direction c WHERE w.id = c.id;
I created a queries which retrive a polygon but it has no id so the qgis can not handle.
SELECT ST_Polygonize(geom) As geom FROM (SELECT * FROM public.view_linestringeov) As foo;
I need two create one polygon which is the border of my territories. Any idea?