Is there a way to transform geographic data in SQL Server 2008 R2?
Specifically, I want to take Lat/Long data and convert it to a State Plane coordinate system.
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.Sign up to join this community
Here's some sample Sql that does projection if you have the Sql Server Tools installed:
-- Project point and linestring using Albers Equal Area projection declare @albers Projection set @albers = Projection::AlbersEqualArea(0, 0, 0, 60) select @albers.Project('POINT (45 30)').ToString() select @albers.Unproject(@albers.Project('LINESTRING (10 0, 10 10)')).ToString() select @albers.ToString()
Have used this method
SELECT * FROM sys.spatial_reference_systems WHERE spatial_reference_id IN(4269,4326);
Have you considered SQLCLR? SQLCLR allows managed code to be hosted by, and run in the Microsoft SQL Server environment. In simplest terms, you can create your own user defined function, stored procedure...etc in .NET, register it with the database, and call like any other SQL function.