Re: [gdal-dev] Error using ogr2ogr to create SpatiaLite database

2010-03-28 Thread Simon O'Keefe
Thanks Even. By specifying -a_srs EPSG:4326, ogr2ogr no longer crashes, and I can now view the output SQLite file in SpatiaLite-GIS. Here is my new command: ogr2ogr -f SQLite C:\Data\db.sqlite C:\Data\states.shp -a_srs EPSG:4326 -dsco SPATIALITE=yes And thanks for creating a ticket and fixing th

Re: [gdal-dev] Error using ogr2ogr to create SpatiaLite database

2010-03-28 Thread Even Rouault
Simon, I also reproduce the problem. It is not platform related. There are various problems in the way the spatial_ref_sys is handled, that I'm currently fixing. The problem is that the SRS of the shapefile is not properly recognized and translated in the spatial_ref_sys table. You can workaro

[gdal-dev] Error using ogr2ogr to create SpatiaLite database

2010-03-28 Thread Simon O'Keefe
Hi, (I posted this issue to the FWTools mailing list a week ago, but have not yet received a response.) I'm attempting to create a new SQLite database from a SHP file using FWTools2.4.7 on Windows 7. The following command: ogr2ogr -f SQLite C:\Data\db.sqlite C:\Data\states.shp -dsco SPATIALITE=y