I need to convert Sql Server geometry datatype to latitude /Longitude
I have just imported a shapefile to my table (geometry)
This query does not work:-
select geom.Lat as [Latitude], geom.Long as [Longitude] from dbo.special
Error I get is:
Could not find property or field 'Lat' for type 'Microsoft.SqlServer.Types.SqlGeometry' in assembly 'Microsoft.SqlServer.Types'.
This query returns Latitude and longitude but the format doesnot seem to match google maps:-
select U.name, Centroid.STY as Longitude, Centroid.STX as Latidude from ( select geom.STCentroid() as Centroid, NAME from dbo.special)
SELECT ST_X (ST_Transform (geom, 4326)), ST_Y (ST_Transform (geom, 4326)) FROM special
'ST_Transform' is not a recognized built-in function name.