data-konzept

'GeoJSON is commonly used format for representing various geo-objects such as lines, polygons, etc. SQL Server 2016 enables you to parse GeoJson format using OPENJSON function. GeoJSON format is described here. In this post we will see how you can parse various types of GeoJSON objects and extract their coordinates. GeoJSON types that will be described here are:

• Line strings
• Polygons
• ​Multi polygons

Goal of this post is not only to show how to parse GeoJSON, but also to see how you can parse some real-world nested JSON structures.'...

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2015/10/02/parsing-geojson-format-in-sql-server-2016/