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?

closed as too broad by nmtoken, mgri, JGH, user2856, whyzar Dec 11 '17 at 5:48

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • 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