We are integrating with a system that will send us OSM maps with its road segment data every two weeks. The total size of these OSM files is around 100GB, meaning we will receive full maps each time.

We have found a way to generate update OSM files for the storage system where these maps will be stored (PostgreSQL + PostGIS).

osmosis --read-pbf file=old_file.osm.pbf --read-pbf file=new_file.osm.pbf --write-pbf file=update_file.osm.pbf

However, the main challenge is that we need to track changes in road segment characteristics with each update. Since we plan to extract up-to-date data for specific time periods in the future, we need to somehow capture what data was changed and at what moment in time.

Has anyone already faced this issue or perhaps found existing tools that could help with this?

We are integrating with a system that will send us OSM maps with its road segment data every two weeks. The total size of these OSM files is around 100GB, meaning we will receive full maps each time.

We have found a way to generate update OSM files for the storage system where these maps will be stored (PostgreSQL + PostGIS).

osmosis --read-pbf file=old_file.osm.pbf --read-pbf file=new_file.osm.pbf --write-pbf file=update_file.osm.pbf

However, the main challenge is that we need to track changes in road segment characteristics with each update. Since we plan to extract up-to-date data for specific time periods in the future, we need to somehow capture what data was changed and at what moment in time.

Has anyone already faced this issue or perhaps found existing tools that could help with this?

• database
• postgresql
• postgis
• openstreetmap
• osm.pbf

Share Improve this question Follow asked Feb 11 at 12:32 AliaksandrAliaksandr 2399 bronze badges

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

You can download all changesets from planet.osm.. The file https://planet.openstreetmap./planet/changesets-latest.osm.bz2 is updated once a week, then you can filter the changeset using the osmium-tool, e.g. https://github/osmcode/osmium-tool/blob/master/man/osmium-changeset-filter.md