Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
Do you have the Sql Server Spatial Tools installed? – Kirk Kuykendall May 19 '11 at 15:53

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()
share|improve this answer
That definitely looks helpful but it doesn't look like the supported projections listed will provide similar results to the state plane system. – Seth P. May 19 '11 at 17:23
What's the SRID of the state plane system you're using? – Kirk Kuykendall May 19 '11 at 17:44
The SRID is 2228 – Seth P. May 19 '11 at 18:08
I've never used it, but the readme with the sql tools says it supports lambert, and this page indicates 2228 is based on lambert, and lists the parameters. So I think you'd be able to do a lambert projection and plug in those parameters. – Kirk Kuykendall May 19 '11 at 18:45

Have used this method

SELECT * FROM sys.spatial_reference_systems WHERE spatial_reference_id IN(4269,4326);

share|improve this answer

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.

share|improve this answer
Essentially that is what the sql spatial tools are. – Kirk Kuykendall May 20 '11 at 13:24

Your Answer


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.