CODEWITHSUNDEEP
databasepostgresqlpostgisopenstreetmaposm.pbf
Aliaksandr
Aliaksandr

Reputation: 23

Handling Road Segment Changes and Historical Data Tracking in OSM Integrations

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?

Upvotes: 0

Views: 31

Answers (1)

Timothy Dalton
Timothy Dalton

Reputation: 1390

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

Upvotes: 0

Related Questions