SQL Azure Database. How to query Shape File Coordinates against Latitude and Longitude

Question

I have some data against number of people with Latitude and Longitude for each row I have downloaded a JSON file of data point data consisting of the following CREATE TABLE staging].DistrictDataPointJSON_ST ON [PRIMARY] GO And I think the big on here is the Coordinates column ![66364-geometrydata.jpg][1] [1]: /api/attachments/66364-geometrydata.jpg?platform=QnA What I apparently should be able to do at this point is figure out where Latitude and Longitude are and assign an area to it using the coordinates. But I don't know how to use the Coordinates and Latitude and Longitude together. Im assuming I need to assign spatial data to something but I dont even know if I can just use the coordinates are they are here. Any help would be really great to put me on the right track with this

Answer 1

Hi anonymous user，

The following functions may be useful to you:
Spatial Types - geometry (Transact-SQL)
OGC Methods on Geometry Instances

If you have any question, please feel free to let me know.

Regards
Echo

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.