SELECT geometry FROM spaces WHERE geometry ARE WITHIN OR OVERLAP polygons FROM OTHER table

Question

I've got two tables, one containing LINESTRINGs and one containing POLYGONEs.

I would like to select all the LINESTRINGs that are containing within the outer boundary of all the POLYGONs combined.

I'm running PostgreSQL 9.3 and PostGIS 2.1.

Is that possible from within the WHERE statement?

I've tried something like WHERE ST_Contains("geometry", (SELECT geometry FROM POLYGONs)), but that slows the query down very much. — Henrik, Commented Jan 21, 2015 at 13:10

Andy · Accepted Answer · 2015-01-21 13:10:36Z

3

Sure, using ST_Contains

SELECT lines.*
FROM lines, polygons
WHERE ST_Contains(polygons.geom, lines.geom)

answered Jan 21, 2015 at 13:10

Andy

3441 silver badge7 bronze badges

It worked with ST_Contains(polygons.geom, lines.geom). Thanx.
– Henrik
Commented Jan 21, 2015 at 13:13
Sorry, I got the order mixed up. Corrected now. Glad you got it working.
– Andy
Commented Jan 21, 2015 at 13:16

Add a comment |

1 Answer 1