Determine if geolocation falls within map boundary

Question

Hi

I have a table of geolocation points and I want to determine if each of those points fall within an entire map boundary. That is made up of geolocation points in geoJson kind of format. to form a polygon or multi-polygon, quite a large one eg.

 [ 151.068607, -33.986343 ], [ 151.068443, -33.986268 ], [ 151.068282, -33.986215 ], [ 151.068132, -33.986154 ].... etc). up to like 1000's of points

How can I in SQL Server covert this and use spatial queries to dermine if a geolocation point is within a given polygon (ie. map boundary?

Thanks

Warren

Answer 1

Hi Warren,

>>How can I in SQL Server covert this and use spatial queries to dermine if a geolocation point is within a given polygon (ie. map boundary?

Based on my researching,  you could try to Load GeoJSON data into SQL Server table, and then see if the point falls within the boundary.

In addition, please refer to Import JSON documents into SQL Server and Create, Construct, and Query geography Instances.

Hope this could help you.

Best Regards,

Amelia Gu

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].