Tagged Questions
9
votes
2answers
242 views
How do I perform a 3 parameter geotransformation and projection in Sql Server 2012?
I have a table with latitude longitude (NAD27) columns in it. I compute two other columns, X and Y, representing Web Mercator (WGS84) location.
Currently I'm using a Arcmap to do this, by applying ...
2
votes
0answers
332 views
Use MS SQL Server to convert MGRS to Lat Long
Below is the SQL for converting Military Grid Reference System (MGRS) to decimal Latitude and Longitude. It is very accurate, but not perfect. If you can make it work 100%, it is yours, but PLEASE ...
4
votes
1answer
1k views
Transforming geometry coordinates from SRID 4326 to SRID 3011
In SQLServer geometry field, I want to change the coordinates of geometry from one spatial reference system to another spatial reference system (from SRID 4326 to SRID 3011) by using ST_Transform. But ...
2
votes
3answers
624 views
How can I transform some KML data to Sql Server 2008 using FME?
I've just downloaded FME 14 day trial. I'm trying to see how easy/hard it is to transform some KML data (a simple neighbourhood shape) into my Sql Server 2008 database using FME.
I sorta don't even ...
1
vote
0answers
289 views
How to transform Lambert to WGS84 in SQL Server?
Need to create a SQL view of calculated Lat/Lon values from an existing SQL view of County Coords.
Loaded up SQL Server Spatial Tools and registerd CLR types. Lambert generated a resource error.
-- ...
2
votes
3answers
919 views
Transform Data with Microsoft Spatial SQL
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.
