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

[Ben Madin]

For two cents, a quick but inaccurate solution might be to shrink your
polygon slightly by using st_buffer() with a negative radius?

Ben

On 22 January 2015 at 16:50, toni hernández <toni at sigte.udg.edu> wrote:

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



-- 

Ben Madin
BVMS PhD, MANZCVS

t : +61 8 6102 5535
m : +61 448 887 220
e : ben at ausvet.com.au

AusVet Animal Health Services
Western Australia

www.ausvet.com.au
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150123/4c867446/attachment.html>