[postgis-users] Finding object that cover multiple polygons

Clifford Snow clifford at snowandsnow.us
Fri Oct 28 15:38:35 PDT 2016

I am working with some parcel data and building outlines. I'd like to
associate an outline to a parcel if it is located mostly in the parcel.
Buildings completely within the parcel can easily be found with
st_contains. How do I find buildings if they are just over the parcel
boundary. For example, in the first screenshot [1] the outline is just over
the boundary. I'd like to be able to run a query that would find those that
are just over. In a second example, this building [2] sits in the middle of
two parcels. I can safely ignore it.

[1] https://www.dropbox.com/s/5xdx404ip4g7ycm/just_over.png?dl=0
[2] https://www.dropbox.com/s/wah2bcg6tz6jw4n/middle.png?dl=0


OpenStreetMap: Maps with a human touch
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20161028/0790f2ac/attachment.html>

More information about the postgis-users mailing list