Hello,
I noticed while migrating some Shapefiles to MSSQL Spatial that there's a Geom column which is added. In which format it is encoded ? And does it countain all the spatial data required informations to restore and draw all the stored features ?
thank you
Best answer by david_r
If you look at the table definition in e.g. MS SQL Server Management Studio, you'll most proabably see that the column is of type "geometry", which is the native data type for geometry objects in SQL Server.
More info here:
If you're using an ArcGIS Geodatabase extension on top of SQL Server, things gets more complicated, see the bottom two paragraphs here:
+26The GEOM column is the default name for the geometry (point, line, area etc) that is stored in a spatial table.
The format it is stored in depends on the spatial database.
You can specify an alternative name for the column in the writer parameters.
If you look at the table definition in e.g. MS SQL Server Management Studio, you'll most proabably see that the column is of type "geometry", which is the native data type for geometry objects in SQL Server.
More info here:
If you're using an ArcGIS Geodatabase extension on top of SQL Server, things gets more complicated, see the bottom two paragraphs here:
If you look at the table definition in e.g. MS SQL Server Management Studio, you'll most proabably see that the column is of type "geometry", which is the native data type for geometry objects in SQL Server.
More info here:
If you're using an ArcGIS Geodatabase extension on top of SQL Server, things gets more complicated, see the bottom two paragraphs here:
Is it encoded in WKB in case of MSSQL ?
Is it encoded in WKB in case of MSSQL ?
But you can cast the geom column to OGC WKB if you need, e.g.
select geom.STAsBinary() from my_table