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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/gdal-dev _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
