Hi list, the question is in the ens of the Mail.
I have a problem with adjacent polygons when converting them to lines,
as I would like to only have one line in the boundaries between the former polygons. Now it could be up to 5.
I’ve been thinking of:
1. Creating a thin buffer around the line strings with the featureId from the line strings as a new table.
2. Then I should break the line strings to line segments into a new Table where the line segments gets the
featureIdfrom the line string.
3. Create a column (edited) in the new line-segment Table with a default value of 0
4. Then delete from the line segments table all segments that are within the buffer, but not the line segments
thathave the same featureId as the current buffer and edited value must be 0 to be deleted.
5. The line segments that are not deleted in the current buffer shall be updated (edited = 1).
6. Do step 4 and 5 until the all objects in the buffered table are executed.
I’ve come this far:
DELETE FROM "LineSegments" USING buffered as h WHERE
ST_Contains(h.the_geom, " LineSegments".the_geom) AND
"LineSegments".edited = 0 AND
NOT h.fid=" LineSegments".fid;
But how can I set the edited vale = 1 on the objects (line segments) that are not deleted (in the current buffer) at
thesame time so it won’t be deleted in the next run with an adjacent buffer?
Kind regards,
Paul