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 <[email protected]>: > 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 from Java to connect to SQL > Server and load the shapefile. However, I’m getting an error on a > particular file I will need to load. I’m wondering if I’m missing an > option on the command? Using a different shapefile, it seems to work. > > > > Here is the command and the error: > > > > 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", // > error on this one > > // > "C:\\Users\\mcolbert\\Downloads\\tl_2010_06_zcta510\\tl_2010_06_zcta510.shp", > // this one seems fine > > "-lco", "GEOM_TYPE=geography", > > "-lco", "GEOM_NAME=geog", > > "-nln", "CM_SHAPE", > > "--debug", "ON" > > // ,"-a_srs", "ESPG:4269" > > }; > > ogr2ogr.main(cmd); > > > > OGR: > OGROpen(C:\Users\mcolbert\Downloads\UGRB_Ozone_NAA\UGRB_Ozone_NAA.shp/00000000003FFE40) > succeeded as ESRI Shapefile. > > OGR_MSSQLSpatial: > EstablishSession(Connection:"Server=xxx;Database=xxx;Uid=xxx;Pwd=xxx") > > ODBC: SQLDriverConnect(DRIVER=SQL > Server;Server=xxx;Database=xxx;Uid=xxx;Pwd=xxx) > > OGR: > OGROpen(MSSQL:Server=xxx;Database=xxx;Uid=xxx;Pwd=xxx/000000000042C440) > succeeded as MSSQLSpatial. > > MSSQLSpatial: DeleteLayer(cm_shape) > > OGR_MSSQLSpatial: Using column ogr_fid as FID for table cm_shape. > > ERROR 1: INSERT command for new feature failed. [Microsoft][ODBC SQL > Server Driver][SQL Server]A .NET Framework error occurred during execution > of user-defined routine or aggregate "geography": > > > > System.FormatException: 24201: Latitude values must be between -90 and 90 > degrees. > > > > System.FormatException: > > > > at Microsoft.SqlServer.Types.GeographyValidator.ValidatePoint(Double x, > Double y, Nullable`1 z, Nullable`1 m) > > > > at Microsoft.SqlServer.Types.Validator.BeginFigure(Double x, Double y, > Nullable`1 z, Nullable`1 m) > > > > at Microsoft.SqlServer.Types.Forw > > Terminating translation prematurely after failed > > translation of layer UGRB_Ozone_NAA (use -skipfailures to skip errors) > > > > > > > > I’m assuming there is nothing unusual about the shapefile. The file is > available here: > > > http://deq.wyoming.gov/media/attachments/Air%20Quality/Winter%20Ozone/Nonattainment%20Information/2012_AQD_UGRB-Ozone-Nonattainment-Area-GIS-Shape-File.zip > > > > Any help is appreciated. > > > > Thanks, > > Mike > > > > > > > > > > > > _______________________________________________ > gdal-dev mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/gdal-dev >
_______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
