<div>Hi Sig,</div>
<div> </div>
<div>This is the command I have so far. When I execute it, I just get the help returned, no error and no table created:<br> <br>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"<br>
<br>What am I doing wrong?</div>
<p>Thx,<br>- Hide quoted text -<br> <br>On Wed, Nov 16, 2011 at 1:32 AM, Luca Sigfrido Percich <<a href="mailto:sigfrido@tiscali.it">sigfrido@tiscali.it</a>> wrote:</p>
<p>Hi Fred,</p>
<p>first of all check if there is an EPSG entry for your coordinate system.<br>Googlin' "Montana State Plane NAD 27 EPSG" pointed me to the several<br>pages, among with, for example:</p>
<p><a href="http://www.eye4software.com/resources/stateplane/">http://www.eye4software.com/resources/stateplane/</a></p>
<p>which states:</p>
<p>2500 NAD83 / Montana 32100</p>
<p>So the EPSG code you're looking for is seems to be 32100. Assuming you<br>want to reproject to Lon/Lat WGS84 (EPSG 4326), you need to use the<br>-s_srs and -t_srs parameters:</p>
<p>ogr2ogr -s_srs EPSG:32100 -t_srs EPSG:4326 -f "MSSQL:..." input.csv</p>