[GIS] SQL Server Convert GeoJson format into SQL geometry/spatial data

geojsongeospatial-pdfjavascriptjsonsql server

I'm using javascript and Openlayers 3 and to draw shapes or geometry in osm map. The data is in geojson format and i want to store it in SQL server 2008 R2 using SQL geometry or spatial data types. Is there a way to convert GeoJSON Format into SQL geometry?

Best Answer

There is no built-in support in SQL Server 2008. If you want to do it in DB layer then you should use some CLR assembly that parses JSON (Json4sql, JsonSelect, etc.) In SQL Server 2016 you have OPENJSON function that can parse GeoJSON text.

Related Solutions

[GIS] When to store geometries using SQL-server geometry datatypes or ArcSDE

So geometries can now either be stored in SQL-Server or ArcSDE.

The two are not mutually exclusive. ArcSDE always requires an RDBMS to store data so you're not storing your data "in ArcSDE" or "in SQL Server." If you're using SQL Server, your data will always be stored in tables in a database in a SQL Server instance.

How your data is stored is up to you. ArcSDE works with data stored as Microsoft's geometry (and geography) types. This is the most versatile option as you get access to your geometries with raw SQL but you can also used advanced functionality only available through Esri's Geodatabase. The alternative to using Microsoft's spatial types is to use Esri's SDE binary type which is not readily usable with raw SQL. Check out this help topic for more info: Feature classes in a geodatabase in SQL Server

[GIS] How to load spatial data into ArcGIS Javascript API application from SQL Server 2008

Write a WCF service that returns a JSONP response. WCF service should return a data in following format:

[
{
    "feature": {
        "attributes": {
            "objectid": 1,
            "fdate": 932428800000,
            "resolution": 3,
            "gnis_id": null,
            "gnis_name": null,
            "lengthkm": 0.024,
            "reachcode": "11070101001016",
            "flowdir": 1,
            "wbareacomid": null,
            "ftype": 558,
            "fcode": 55800,
            "enabled": 1
        },
        "geometry": {
            "paths": [
                [
                    [
                        -95.9899452281111,
                        38.1345878074741
                    ],
                    [
                        -95.9898896947778,
                        38.1344644074744
                    ],
                    [
                        -95.9899164947778,
                        38.1343866074744
                    ]
                ]
            ]
        }
    }
}
]

Best Answer

Related Solutions

[GIS] When to store geometries using SQL-server geometry datatypes or ArcSDE

[GIS] How to load spatial data into ArcGIS Javascript API application from SQL Server 2008

Related Question