How to keep a local modified database in sync with osm database

I imported a planet pbf into my local PostgreSQL database and need to do some private update (creation, modification and deletion) because of my business needs. However, I want to keep the local database in sync with osm official database periodically. It can be weekly, even monthly. Is there any best way to do that?

asked 04 Jul '18, 07:39

Hanson
26●1●1●3
accept rate: 0%

edited 04 Jul '18, 07:44

Please clarify how you want to proceed in these cases:

An object you deleted locally has been modified in OSM?
An object you created locally has meanwhile also been created in OSM?
An object you modified locally has been modified in a different way in OSM?

(04 Jul '18, 07:57) Frederik Ramm ♦

@Frederik Ramm ♦ Thank you for your reminder. It will include these cases:

An object deleted locally has been modified in OSM
An object created locally but does not exist in OSM
An object modified locally has been modified in a different way in OSM
An object created locally and its id maybe conflict with another new object in OSM, but they are different completely

(04 Jul '18, 10:17) Hanson

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

import ×196
postgresql ×165
database ×118
merge ×41

question asked: 04 Jul '18, 07:39

question was seen: 1,355 times

last updated: 04 Jul '18, 10:19

How to keep a local modified database in sync with osm database

Follow this question

Related questions