Is it possible to calculate the spaces between the roads using a select statement in a PostGIS/PostgreSQL Database?
I tried using some combinations of the predefined functions as ST_Intersects & ST_Difference but did not succeed yet.
Asked
Active
Viewed 153 times
0
-
Could you be more precise? What do you mean by spaces? Areas? – Vladimir Oct 24 '12 at 03:57
-
When you say 'spaces', do you mean a) the closest the roads ever come to each other b) the furthest the roads are away from each other c) some measure of average distance between the two roads or d) the area of the space formed from a polygon composed by having each road as two sides of the polygon and an additional one or two sides to complete it? – Jayden Oct 24 '12 at 04:00
-
d) the polygons trapped between street network – Marwa Hack Oct 25 '12 at 16:27
-
Please post the SQL that you have tried, as en edit to the question. – John Powell Mar 01 '18 at 11:26
1 Answers
0
Depending on the interpretation of spaces, the answer can be found in How can I create polygons of the area surrounded by roads / lines? about creating polygons from areas enclosed by roads.
