Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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 ?

share|improve this question
add comment

2 Answers 2

up vote 3 down vote accepted

It's binary data, you need to use the STAsText() method to return it as a string that contains the lat/longs, as in:

SELECT [OBJECTID]
  ,[TRACT_ID]
  ,[TRACT_NAME]
  ,[SHAPE].STAsText()
FROM [City].[dbo].[TRACTS]

To go the other way, use the STAsBinary() method.

share|improve this answer
    
Fine! Thats what i needed. Can i go in reverse. I mean is it possible to convert set of lat/longs back to binary format? –  user1899 Feb 6 '12 at 14:59
    
@user1899 - Yes, see my edit. –  Chad Cooper Feb 6 '12 at 15:12
add comment

In which format [is] geographic data stored in geometry data 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 GEOMETRY and GEOGRAPHY types are encoded in a special binary format which is specified in "[MS-SSCLRT]: Microsoft SQL Server CLR Types Serialization Formats".

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.