Determine if geolocation falls within map boundary RRS feed

  • 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?



    Tuesday, October 22, 2019 9:12 AM

All replies