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

Christopher Swingley cswingle at swingleydev.com
Mon Feb 2 10:43:05 PST 2015


Joseph,

On Mon, Feb 2, 2015 at 9:31 AM, Joseph Spenner <joseph85750 at yahoo.com> wrote:
> select ST_Asgeojson( geom ) from table where
> ST_Intersects(ST_GeomFromGeoJSON('$state'), geom)=TRUE and
> ST_Area(ST_Intersection(ST_GeomFromGeoJSON('$state'), geom))>1

Any chance your polygons are still lat/lon projections (wgs84 / nad83)
and not something projected?

Beyond that, I'm afraid I don't have any suggestions.

Cheers,

Chris
-- 
Christopher Swingley
Fairbanks, Alaska
http://swingleydev.com/
cswingle at swingleydev.com


More information about the postgis-users mailing list