[gdal-dev] Shapefile to SQL Server

Mike Colbert mcolbert at unicon-intl.com
Mon Apr 18 07:38:16 PDT 2016


Thank you, this fixed it.

Here is the working command:

String[] cmd = {
"-overwrite",
"-f", "MSSQLSpatial",
"MSSQL:Server=xxx;Database=xxx;Uid=xxx;Pwd=xxx",
"C:\\Users\\mcolbert\\Downloads\\UGRB_Ozone_NAA\\UGRB_Ozone_NAA.shp",
"-lco", "GEOM_TYPE=geography",
"-lco", "GEOM_NAME=geog",
"-nln", "CM_SHAPE",
"--debug", "ON"
,"-t_srs", "EPSG:4269"
,"-s_srs", "EPSG:26912"
};
ogr2ogr.main(cmd);


Mike


From: gdal-dev [mailto:gdal-dev-bounces at lists.osgeo.org] On Behalf Of Bo Victor Thomsen
Sent: Saturday, April 16, 2016 2:29 AM
To: gdal-dev at lists.osgeo.org
Subject: Re: [gdal-dev] Shapefile to SQL Server

I know, what the abbreviation "EPSG" stands for !

And I can't count the number of times I made this particular spelling mistake !!

And four times in a row in one mail !!!

At least it's weekend...


Regards Bo Victor

Den 15/04/16 kl. 20:16 skrev Jukka Rahkonen:

Bo Victor Thomsen <bo.victor.thomsen <at> gmail.com> writes:







    The shape file in the zip is not in projection espg:4269. It's in

    utm zone 12N. Replace the "-a_srs", "ESPG:4269" with "-t_srs",

    "ESPG:4269" and "-s_srs", "ESPG: code_for_UTM_12N"

    This causes ogr2ogr to reproject you data to the correct projection



And it is written "EPSG" as in European Petroleum Survey Group.



-Jukka Rahkonen-





_______________________________________________

gdal-dev mailing list

gdal-dev at lists.osgeo.org<mailto:gdal-dev at lists.osgeo.org>

http://lists.osgeo.org/mailman/listinfo/gdal-dev

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20160418/1b4da831/attachment.html>


More information about the gdal-dev mailing list