最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

database - Handling Road Segment Changes and Historical Data Tracking in OSM Integrations - Stack Overflow

programmeradmin1浏览0评论

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?

Share Improve this question asked Feb 11 at 12:32 AliaksandrAliaksandr 239 bronze badges
Add a comment  | 

1 Answer 1

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

发布评论

评论列表(0)

  1. 暂无评论