This question already has an answer here:

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.

marked as duplicate by PolyGeo May 17 '18 at 22:55

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • Could you be more precise? What do you mean by spaces? Areas? – Vladimir Oct 24 '12 at 3: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 4: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 1 '18 at 11:26

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.

We're looking for long answers that provide some explanation and context. Don't just give a one-line answer; explain why your answer is right, ideally with citations. Answers that don't include explanations may be removed.

Not the answer you're looking for? Browse other questions tagged or ask your own question.