Re: [gdal-dev] Shapefile to SQL Server

2016-04-18 Thread Mike Colbert
uot;, "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

Re: [gdal-dev] Shapefile to SQL Server

2016-04-15 Thread Bo Victor Thomsen
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 gmail.com>

Re: [gdal-dev] Shapefile to SQL Server

2016-04-15 Thread Jukka Rahkonen
Bo Victor Thomsen 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 c

Re: [gdal-dev] Shapefile to SQL Server

2016-04-15 Thread Bo Victor Thomsen
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 Bo Victor Thomsen Den 15/04/16 kl. 17:06 skr

Re: [gdal-dev] Shapefile to SQL Server

2016-04-15 Thread Tamas Szekeres
Hi, Looks like you have invalid latitude values in the shapefile. Try creating geometry type instead of geography. Best regards, Tamas 2016-04-15 17:06 GMT+02:00 Mike Colbert : > Hi, > > > > I have a Java web app with a SQL Server database and I would like to add > support for importing shap

[gdal-dev] Shapefile to SQL Server

2016-04-15 Thread Mike Colbert
Hi, I have a Java web app with a SQL Server database and I would like to add support for importing shapefiles. The shapes will then be used to determine if geographic locations we have defined in our system are within the areas defined by the shapes. I've gone down the path of using ogr2ogr f