[gdal-dev] Ogr2ogr, Mapinfo, Spatialite and mixed line geometrytypes

Jukka Rahkonen jukka.rahkonen at mmmtike.fi
Wed Jan 18 15:25:02 EST 2012


I received an Mapinfo TAB file which contains both linestings and
multilinestrings. Addind data into Spatialite as a new layer with the following
command fails

ogr2ogr -f SQLite -update -gt 2048 -t_srs epsg:3067 tab_test.sqlite l_jrata.TAB 

Error is 
ERROR 1: sqlite3_step() failed:
  SQL logic error or missing database
ERROR 1: ROLLBACK transaction failed: cannot rollback - no transaction
is active

ERROR 1: Terminating translation prematurely after failed
translation of layer l_jrata (use -skipfailures to skip errors) 

Conversion is successful if I set the geometrytype of the new layer into
multilinestring with the -nlt option. However, this is not necessary when having
a mixture of polygons and multipolygons. In that case the conversion succeeds
and the result is a Spatialite table of general geometry type.

Orginfo lists with this dataset that the geometrytype is Line String. Are there
other means for detecting the multilinestrings beforehand than list all features
with ogrinfo and pipe them through find/grep?

A small dataset is available here for testing


-Jukka Rahkonen-

More information about the gdal-dev mailing list