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

[toni hernández]

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 at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150122/3bcdf4c6/attachment.html>