I want to know, In which format the Geographic data stored in geometry data type of SQLServer 2008.it looks like a long string,like 0xE6100010466DFEOA4089663524....... for one polygon. My second question is How can i get set of google latitudes/longitudes from this data format ?
In which format [is] geographic data stored in
geometrydata type of SQL Server 2008. It looks like a long string, like
0xE6100010466DFEOA4089663524…for one polygon.
These values are essentially BLOBs (binary large objects): Values of the
GEOGRAPHY types are encoded in a special binary format which is specified in "[MS-SSCLRT]: Microsoft SQL Server CLR Types Serialization Formats". (SQL Server 2008 only used version 1 of that format, version 2 was introduced with SQL Server 2012.)
How can I get set of Google latitudes/longitudes from this data format?
This has already been adressed by a previous answer: Call the
.STAsText() method on a
GEOMETRY-typed value to get a WKT representation of the geometry. Depending on the projection / coordinate system used by your geometries, this will make lat/long coordinate pairs visible in a plain text format.