更新时间:2023-11-28 21:59:10
如果您的Polygon在SQL中存储为STGeometry或STGeography对象,您可以使用STIntersects功能。
https://docs.microsoft.com/en-us/sql/t-sql/spatial-geography/stintersects-geography-data-type?view=sql-server-2017
I have saved my polygon and now want to check whether the lat,long lies inside the polygon using sql query. Do anyone know how to do this in sql?
Please reply
Thanks
If your Polygon is stored as an STGeometry or STGeography object in SQL, you can use the STIntersects function. https://docs.microsoft.com/en-us/sql/t-sql/spatial-geography/stintersects-geography-data-type?view=sql-server-2017