|
Hello Team, I am trying to import the history file (OSH) from Geofabrik web site as shown below https://download.geofabrik.de/europe/great-britain.html [great-britain.osh.pbf, a file that contains the full OSM history for this region for processing with e.g. osmium. This file was last modified 3 days ago. File size: 1.5 GB; MD5 sum: eb54225a2019051736dde7b84d7dda3d] I can successfully convert the OSH file to OSM file using the OSMIUM Utility Every time the extract for Great Britain fails with the error message when using OSM2PGSQL to import the OSM data into the PostGreSQL database. I have tried a couple of times (with different files) and get same issue. WARNING: Node 5156175847 (version 2d) has an invalid location and has been ignored. This is not expected to happen with recent planet files, so please check that your input is correct. Processing: Node(133658k 38.4k/s) Way(25181k 21.20k/s) Relation(13110 126.06/s)node cache: stored: 133658930(100.00%), storage efficiency: 50.00% (dense blocks: 0, sparse nodes: 133658930), hit rate: 99.85% Osm2pgsql failed due to ERROR: Missing ref on relation member The history extracts for other regions like Australia / New Zealand / San Francisco etc all work perfectly fine without any issues and this is only for Great Britain. Can you please help me with the issue ? Is this something to do with the extract data contents ? |
|
osm2pgsql is not suitable for importing history files into PostGIS. In fact, there is no software that does this in a full-featured way. It is a difficult issue because many different historical versions of an object have to be created - often more versions than the object has. You may have processed other history files without errors, this does not mean that the results will make sense. The only software that comes near importing a history file into PostGIS is https://github.com/MaZderMind/osm-history-renderer/tree/master/importer but it is old and unmaintained. |
