[postgis-users] Possible for ST_Intersects to not include the perimeter?

Joseph Spenner joseph85750 at yahoo.com
Wed Jan 21 13:22:26 PST 2015


I have a polygon as an input, and I'm trying to find all polygons which share points, but not the perimiter points themselves.  Is this possible?
Real application:  I have NWS polygons describing Thunderstorm Warnings, which are made up of counties within the state.  Some of those counties might be on the edge of the state.  I want to query my database to show me all Warnings which are in a supplied state.  However, if I query the adjacent state which borders the counties from the first state, I get those Warnings because they share the same parimeter points.
Is there a way to construct a query which will not return anything if the only points in common are the perimeter values themselves?
I tried a few variations on ST_Intersects/ST_Covers/ST_Contains/ST_Overlaps, supplying various AND/OR and TRUE/FALSE combinatins, but I can't seem to get the right combo to accomplish my task.
Any help would be great.
Thanks!
Regards,Joseph Spenner


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150121/9e0b48a7/attachment.html>


More information about the postgis-users mailing list