I wish to ask for some advice when it comes to building nested spatial expressions in PostgreSQL. I end up with the same kind of problem many times when it comes to select more than one type of geometry.

The case I am working with now is related to it, is this:

I need to find parcels that lay within a buffer zone around a numbers of waters and streams selected by their ID. Waters are polygons, Rivers are lines.

I try to find a way how to write a ST_DWithin the polygons and the lines in one query to find parcels within the buffer.

Is this a reasonable way to approach the problem or should I work with this kind of queries in a different way?

  • If you post the query you're trying (even if it doesn't work,) it will make your explanation of your approach much clearer. – RoperMaps Dec 10 '17 at 18:25