2

Is there any built in function in SQL Server 2008 R2 which can transform the cordinates from 102100 to 4269 coordinate system something equivalent to ST_Transform from postgres. If there is algorithm to transform coordinates then that can also help or the Javascript library then that could also help.

  • Please have a look at: gis.stackexchange.com/questions/19917/… – Devdatta Tengshe Jan 21 '14 at 11:18
  • If you want to do this in JavaScript, you could look intoProj4js – Devdatta Tengshe Jan 21 '14 at 11:20
  • @DevdattaTengshe conversion between 4326 to 4269 is not working using Proj4js.Is there any other library or algorithm ...?? – Gunner Jan 21 '14 at 12:16
  • @DevdattaTengshe I have converted geographic coordinates which is 4326 as input and I have tried converting to 4269 but the values did not change and even I tried 102100 coordinates that also did not change the value.So there is problem in conversion of any projection to 4269. – Gunner Jan 21 '14 at 13:39
  • 1
    @whuber I am referring Proj4js Javascript api to convert coordinates.I tried these -43.81347656248869,51.17934297927967 coordinates as x,y which is in 4326 and i got output same as input for 4269. – Gunner Jan 21 '14 at 17:44
2

There is no standard spatial function within SQL Server to do this. You will need to use SQL Server Spatial Tools or if you are geodetically inclined, create your own function.

The proj4js JavaScript library can, one trick is to ensure your projections are defined. Also ensure you are including a version of the proj4js library that supports your projections, or you will need to do it manually by defining that projections parameters.

Here is some kind of psuedo code that should work:

var source = new Proj4js.Proj('EPSG:4326');
var destination = new Proj4js.Proj('EPSG:4629');

var point = new Proj4js.Point(-43.81347656248869,51.17934297927967);
Proj4js.transform(source, destination, point);

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.