Convert Geometry data into a Geography data in MS SQL Server

標籤：

DECLARE @geog GEOGRAPHY;DECLARE @geom GEOMETRY;SET @geom = GEOMETRY::STGeomFromText(‘POLYGON ((-99.213546752929688 19.448402404785156, -99.2157974243164 19.449802398681641, -99.2127456665039 19.450002670288086, -99.213546752929688 19.448402404785156))‘, 4326); SET @geom = @geom.MakeValid() --Force to valid geometrySET @geom = @geom.STUnion(@geom.STStartPoint()); --Forces the correct the geometry ring orientationSET @geog = GEOGRAPHY::STGeomFromText(@geom.STAsText(),4326) SELECT @geog.STArea();

　

參考：　http://blogs.msdn.com/b/edkatibah/archive/2008/08/19/working-with-invalid-data-and-the-sql-server-2008-geography-data-type-part-1b.aspx

Convert Geometry data into a Geography data in MS SQL Server