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.
-- Project point and linestring using Lambert Conformal Conic projection
declare @lambert Projection
set @lambert = Projection::LambertConformalConic(0, 0, 0, 0)
select @lambert.Project('POINT (45 30)').ToString()
select @lambert.Unproject(@lambert.Project('LINESTRING (10 0, 10 10)')).ToString()
select @lambert.ToString()
--
XY going in=(521387.001,204215.954) Need LatLon coming out.
Any ideas welcome.
