In my recent QGIS project I need to split polygons (table/layer "pol") by both closed and non-closed linestrings (table/layer "lin").
I've tried the following SQL queries.
CREATE VIEW split_pol ASSELECT g.path[1] as gid, g.geom::geometry(polygon, 31492) as geom FROM (SELECT (ST_Dump(ST_Split(pol.geom, lin.geom))).* FROM pol, lin) as g;CREATE VIEW split_pol ASSELECT row_number() over() as gid, (ST_Dump(ST_Split(pol.geom, lin.geom)) as geomFROM pol, lin;Unfortunately I don't get proper results. In my example ST_Split should create six polygons (view/layer "split_pol").
Does anybody know how to use ST_Split with QGIS/PostGIS?
أكثر...
I've tried the following SQL queries.
CREATE VIEW split_pol ASSELECT g.path[1] as gid, g.geom::geometry(polygon, 31492) as geom FROM (SELECT (ST_Dump(ST_Split(pol.geom, lin.geom))).* FROM pol, lin) as g;CREATE VIEW split_pol ASSELECT row_number() over() as gid, (ST_Dump(ST_Split(pol.geom, lin.geom)) as geomFROM pol, lin;Unfortunately I don't get proper results. In my example ST_Split should create six polygons (view/layer "split_pol").
أكثر...