[gdal-dev] Re: OGR2OGR and SQL Spatial

[Fred Jones]

Hi Sig,

This is the command I have so far. When I execute it, I just get the help
returned, no error and no table created:

ogr2ogr -overwrite -s_srs EPSG:32100 -t_srs EPSG:4326 -f
"MSSQL:server=ELMER;database=CENSUS_2010;trusted_connection=yes"
"MSSQL:server=ELMER;database=HT_2010_10;tables=temp_sublocs_btc;trusted_connection=yes"

What am I doing wrong?

Thx,
- Hide quoted text -

On Wed, Nov 16, 2011 at 1:32 AM, Luca Sigfrido Percich <sigfrido at tiscali.it>
wrote:

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20111116/b89a08fe/attachment.html