Andreas, Segfaulting is a serious issue. Can you tell the version of GDAL you used?
On Wed, Sep 7, 2011 at 8:35 PM, Andreas Neumann <[email protected]> wrote: > HI Jukka, > > Thank you for your thoughts. Yes, perhaps I should use update instead of > append. > > I actually found out what the problem is: > > Tables or views that do not have an entry in public.geometry_columns (the > postgis metadata table) cause the segmentation fault. Once the entry is > there, it converts fine. > > Perhaps ogr2ogr could issue a warning or error message in this case instead > of segfaulting. It would be nicer. > > Thanks again, > Andreas > > > On Wed, 7 Sep 2011 14:52:31 +0000 (UTC), Jukka Rahkonen wrote: > >> Andreas Neumann <a.neumann <at> carto.net> writes: >> >> >>> Hi, >>> >>> I am converting several tables from Postgis to SpatiaLite using >>> ogr2ogr. >>> >>> Here is my command: >>> >>> ----------- >>> ogr2ogr -append -lco LAUNDER=yes -lco SPATIAL_INDEX=yes -nln >>> av_grenzpunkte -f SQLite uster.sqlite PG:"dbname='mydb' host='myserver' >>> port='5432' user='username' password='pw' schemas=av_user >>> tables=grenzpunkte(the_geom)" >>> ---------- >>> >> >> Hi, >> >> I have used these options: >> >> -dsco SPATIALITE=yes >> -lco SPATIAL_INDEX=no >> and for polygon layers >> -nlt MULTIPOLYGON (Spatialite do not want polygons and multipolygons >> on the same >> layer, so let them be all multipolygons). Same with mixed lines/multilines >> if >> you may have those. >> >> -update is needed when adding new layers. Are you adding to an existing >> table >> because you have -append? >> >> Ogr2ogr does not create totally valid Spatialite databases. Therefore >> I skip the >> SPATIAL_INDEX because conversion is faster without. After ogr2ogr >> process I am >> cleaning the resulting database by copying the tables into a fresh >> Spatialite >> database with OpenLite tool >> http://www.gaia-gis.it/**OpenLite/<http://www.gaia-gis.it/OpenLite/> >> >> -Jukka Rahkonen- >> >> ______________________________**_________________ >> gdal-dev mailing list >> [email protected] >> http://lists.osgeo.org/**mailman/listinfo/gdal-dev<http://lists.osgeo.org/mailman/listinfo/gdal-dev> >> > > -- > -- > Andreas Neumann > Böschacherstrasse 10A > 8624 Grüt (Gossau ZH) > Switzerland > ______________________________**_________________ > gdal-dev mailing list > [email protected] > http://lists.osgeo.org/**mailman/listinfo/gdal-dev<http://lists.osgeo.org/mailman/listinfo/gdal-dev> > -- Best regards, Chaitanya kumar CH. +91-9494447584 17.2416N 80.1426E
_______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
