Joseph,
With St_Relate (http://postgis.net/docs/ST_Relate.html) we can get all
kind of relations between geometries.
You can get boundary intersections, interior intersections, interior
intersections without boundary intersections.... all possibilities are
supported.
St_Relate uses the DE-91M model to define this relations between geometries.
To know more about DE-91M: http://en.wikipedia.org/wiki/DE-9IM
http://postgis.net/docs/using_postgis_dbmanagement.html#DE-9IM
On 21/01/2015 22:22, Joseph Spenner wrote:
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
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users