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