[GIS] Conversion of X, Y values to different coordinate system

coordinate systemsql-server-spatial

Is there a way to convert coordinate X, Y values in SQL Server from one type of coordinate system to another using SQL Transaction? Like NAD83 State Planes to WGS 1984. My objective is to use a single ArcGIS web map to analyze and show X, Y values that has different type of coordinate system. I plan to convert or transform first the coordinate values to a common type of coordinate system like WGS 1984 before saving them to geodatabase.

Best Answer

It would be easier to add lat/long fields to sql, then bring them into ArcMap as an X,Y Event projecting them as the state plane they are. Then Calculate Geometry as Decimal Degrees for the new Lat/Long fields.

Another option is just bring in ID, X, Y fields, as an X,Y, define as STateplane, then set Dataframe to 4326 (WGS-84) export the points out using dataframe projection, then bring them back into arcmap, use add X,Y tool, then bring into sql, join, and update.

Related Solutions

[GIS] Transform Data with Microsoft Spatial SQL

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()

Measure Units in QGIS – Changing Unit of Measure from Degrees to Meters in QGIS

You have to change the Coordinate Reference System of the project; QGIS won't do that when you load a shape file.

Go to: settings->Project Properties->Coordinate Reference System (CRS) and search for your projection.

Although WGS84 and NAD83 both refer to datums not projections. If you want to project your TIGER data, I would be inclined to use either a UTM zone, or a US-wide projection if you're dealing with large areas.

Best Answer

Related Solutions

[GIS] Transform Data with Microsoft Spatial SQL

Measure Units in QGIS – Changing Unit of Measure from Degrees to Meters in QGIS

Related Question