I'm trying to write a query in Postgis which will return all rows where a dynamically changing longitude/latitude point resides within the geometric polygon of that row (in the geom column). This is the query I'm trying to use:
SELECT * FROM "geospatial-data" WHERE ST_Contains( "geospatial-data".geom, ST_Transform( ST_GeomFromText('POINT(-90.56210 38.60369)', 4326), 4269 ))=trueI'm basing this query off of an older post here: http://codemagician.wordpress.com/2009/09/12/point-in-polygon-in-postgis/
I'm not getting any errors but I can't understand what I'm doing wrong. How should I write/modify the query in order to query for a point-in-polygon?
أكثر...
SELECT * FROM "geospatial-data" WHERE ST_Contains( "geospatial-data".geom, ST_Transform( ST_GeomFromText('POINT(-90.56210 38.60369)', 4326), 4269 ))=trueI'm basing this query off of an older post here: http://codemagician.wordpress.com/2009/09/12/point-in-polygon-in-postgis/
I'm not getting any errors but I can't understand what I'm doing wrong. How should I write/modify the query in order to query for a point-in-polygon?
أكثر...