[gdal-dev] Re: OGR2OGR and SQL Spatial

[Eli Adam]

Fred,

      You may need to use -f with the Code from this page:
http://gdal.org/ogr/ogr_formats.html  (-f MSSQLSpatial)

HTH, Eli

On Wed, Nov 16, 2011 at 4:21 PM, Fred Jones <fredjonze at gmail.com> wrote:
> 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
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
>