[gdal-dev] Ogr2ogr

[Luca Sigfrido Percich]

Hi Fred,

first of all check if there is an EPSG entry for your coordinate system.
Googlin' "Montana State Plane NAD 27 EPSG" pointed me to the several
pages, among with, for example:

http://www.eye4software.com/resources/stateplane/

which states:

2500 NAD83 / Montana 32100

So the EPSG code you're looking for is seems to be 32100. Assuming you
want to reproject to Lon/Lat WGS84 (EPSG 4326), you need to use the
-s_srs and -t_srs parameters:

ogr2ogr -s_srs EPSG:32100 -t_srs EPSG:4326 -f "MSSQL:..." input.csv



Sig


Il giorno mar, 15/11/2011 alle 21.59 -0700, Fred Jones ha scritto:
> I'm new to OGR and am having difficulty creating a command. I have GDAL v1.8. 
> 
> I have x/y points in Montana State Plane NAD 27 central in a SQL 2008 database. I'm trying to use the SQLSpatial driver to grab the x/y from SQL, project the points to either geometry or geography, and direct the output to a SQL spatial database as a new table. Al that I've managed to do so far is copy the table...don't know the syntax to do the initial projection. I have examples to do something like this from original long/lat, but not state plane.
> 
> Any help is appreciated.
> 
> Thx
> 
> Fred_______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev