Synchronizing GPS data in SQL Server

Question

I need help with synchronizing GPS data in three different formats.  (GPS lat, Long, Elev. in nvarchar), (Northing, Easting, Elevation in float) and (X, Y, Z  in real). I would like to have all data in a single format for analysis.

Answer 1

You really need to be more descriptive as to what help you need... do you want somebody to explain the difference between geographic, projected, and geocentric coordinate systems? Or how to CAST from a numeric value to a string? Or how to transform and reproject data between systems? Or how to place triggers in SQL Server to update related records whenever another record is inserted/updated? What "single format" do you want you data in? And what analysis do you want to do on it?!

---

twitter: @alastaira blog: http://alastaira.wordpress.com/