Wednesday, May 27, 2015

Just a test drive for postgis:

SELECT esn_id from PSAP as "geospatial-data" WHERE ST_Contains("geospatial-data".geom,ST_GeomFromText('POINT(-90.56210 38.60369)'));

Yields:

"E29189002"


Total query runtime: 15 ms.

1 row retrieved.

No comments:

Post a Comment