ogr2ogr does not set osm_id for all multipolygons

Question

I used ogr2ogr to convert from osm data (pbf) to spatialite :

ogr2ogr -progress -f SQLite -dsco spatialite=yes france.simple.spatialite france-latest.osm.pbf

then, a large part of the imported data misses osm_id

spatialite> select count(*) from multipolygons;
42287946
spatialite> select count(*) from multipolygons where osm_id is null;
42153385

any ideas why, and how to fix this ?

Answer 1

You are only inspecting osm_id field. It seems you didn't inspect your multipolygons table.

On a local use case, I do :

ogrinfo -so france.simple.spatialite multipolygons

It returns

FID Column = OGC_FID
Geometry Column = GEOMETRY
osm_id: String (0.0)
osm_way_id: String (0.0)
name: String (0.0)
type: String (0.0)
...

So the identifiers are not only located on the osm_id but also in an osm_way_id.

Try :

select count(*) from multipolygons where osm_id is null AND osm_way_id is null;

It should return 0 records.

So, there is no need for fix.