[OSM-dev] How to keep a geographic local part of OSM updated with minutely diffs?

[Frederik Ramm]

Hi,

On 11/30/2015 03:29 PM, tb wrote:
> Now i'm interested in keeping just a region like a city or a small state 
> updated the same way (on a much smaller system). 

...

> But unfortunately the other tables used by osm2pgsql 
> (planet_osm_nodes, ...ways, ...rels) getting bigger by time.

Option 1:

Use bounding box option with osm2pgsql import, and run the cleanup
queries documented here:

http://wiki.openstreetmap.org/wiki/User:Stephankn/knowledgebase#Cleanup_of_ways_outside_the_bounding_box

Option 2:

Instead of applying diffs to the database directly, do this:

* download worldwide diffs
* apply them to an extract (file containing only your regional data)
with osmosis
* have osmosis cut out your polygon of interest from the resulting
updated file (since applying diffs will have added stuff outside your
region)
* have osmosis compare a diff between your previous local extract and
the new, updated local extract
* update your database with that diff

The three osmosis steps can be done in one if you're adventurous.

Bye
Frederik

-- 
Frederik Ramm  ##  eMail frederik at remote.org  ##  N49°00'09" E008°23'33"