[postgis-users] Possible for ST_Intersects to not include the perimeter?
joseph85750 at yahoo.com
Thu Jan 22 08:07:47 PST 2015
Thanks for all the replies! Actually, I must have done something wrong yesterday because my query I came up with works:
select ST_Asgeojson( geom ) from polys where ST_Intersects(ST_GeomFromGeoJSON('$jsonPoly'), geom)=TRUE and ST_Touches(ST_GeomFromGeoJSON('$jsonPoly'), geom)=FALSE
I must have had a TRUE/FALSE and/or AND/OR wrong.
I went through several tests, and all scenarios where the polys lie in various places with respect to each other, and every test past.
Toni: The ST_Relate looks interesting, too. I'll have to check that out.
Thanks again for the quick replies!
If life gives you lemons, keep them-- because hey.. free lemons.
"~heart~ Sticker" fixer: http://microflush.org/stuff/stickers/heartFix.html
From: toni hernández <toni at sigte.udg.edu>
To: Joseph Spenner <joseph85750 at yahoo.com>; PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Sent: Thursday, January 22, 2015 1:50 AM
Subject: Re: [postgis-users] Possible for ST_Intersects to not include the perimeter?
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
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.
Regards, Joseph Spenner
postgis-users mailing list
postgis-users at lists.osgeo.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users