Finding all areas that intersect with a point and vice-versa - PostGIS

Posted by ForeignerBR on Stack Overflow See other posts from Stack Overflow or by ForeignerBR
Published on 2011-11-17T09:48:11Z Indexed on 2011/11/17 9:50 UTC
Read the original article Hit count: 239

Filed under:
|
|
|

I'm developing a project using PostGIS to hold spatial data where I have records that hold geometry point data and records that hold geometry area data. To solve my problem I'm looking for two queries that can take geographic shapes rather than geometric shapes as parameters.

For query A I need it to return all points that intersect with a given area.

For query B I need it to return all areas that intersect with a given point.

© Stack Overflow or respective owner

Related posts about postgresql

Related posts about gis