current community

your communities

more stack exchange communities

Stack Exchange
tour help
Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
up vote 1 down vote favorite
1

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.

share|improve this question
    
Please have a look at: gis.stackexchange.com/questions/19917/… –  Devdatta Tengshe Jan 21 at 11:18
    
If you want to do this in JavaScript, you could look intoProj4js –  Devdatta Tengshe Jan 21 at 11:20
    
@DevdattaTengshe conversion between 4326 to 4269 is not working using Proj4js.Is there any other library or algorithm ...?? –  Gunner Jan 21 at 12:16
    
What have you tried? What do you mean when you said that it's not working? –  Devdatta Tengshe Jan 21 at 13:35
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 at 17:44

1 Answer 1

up vote 1 down vote accepted

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);
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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