locked
Finding in which polygon(from a multi polygon) each point falls RRS feed

  • Question

  • Hi 

    I have a table containing coordinates (X,Y or Lat,Long in NAD27), and another table containing a multipolygon with 12 different geographical zones / polygons.

    How can I determine in which zone each point falls ?

    Thanks

    Thursday, May 31, 2018 7:42 PM

All replies

  • Hi N KAXANI,

    You can download a set of polygon data representing time zones of the world from http://efele.net/maps/tz/world/

    Load this data into SQL Server, and then use STIntersects() to determine the polygon in which your point lies.

    Reference: How to get timezone (offset) for a given Geography point?

    Regards,

    Pirlo Zhang 


    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 MSDNFSF@microsoft.com.

    Friday, June 1, 2018 10:00 AM