まとめ SQL Server Geometry SELECT * FROM JPN71 TAB WHERE TAB.Shape.STIntersects( geometry::STGeomFromText('POINT(135 35)', 4612) ) = 1 PostgreSQL ST_Geometry —SDEスキーマに関数— SELECT * FROM sde.jpn71 TAB WHERE sde.st_intersects( TAB.Shape , sde.st_point(135, 35, 300002 ) ) ; PostgreSQL PostGIS —PostGIS Publicに関数— SELECT * FROM jpn71PG TAB WHERE st_intersects( TAB.Shape , ST_GeomFromEWKT('SRID=4612;POINT(1
![空間データ検索クエリ比較](https://cdn-ak-scissors.b.st-hatena.com/image/square/8d71ff5111e05619a10d29bb40d7aebaa75c8fbc/height=288;version=1;width=512/https%3A%2F%2Fs0.wp.com%2Fi%2Fblank.jpg)