[OSM-dev] How to keep a geographic local part of OSM updated with minutely diffs?
tb
osm at qayx.net
Mon Nov 30 14:29:09 UTC 2015
Hi,
i'm running a local database of the OpenStreetMap data, and this
database is permanently updated by using osmosis and osm2pgsql (minutely
diffs).
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). The region i'm
interested in is defined as a polygon in a separate table, and i keep
the content of all the mapnik tables (planet_osm_point, ...line,
...polygon, ...roads) to this region by using a trigger - no problem so
far. But unfortunately the other tables used by osm2pgsql
(planet_osm_nodes, ...ways, ...rels) getting bigger by time.
Complete reload of the region every night is something i don't like - so
far.
I wonder if someone has a system like this up and running, and how this
works.
Is this possible in general by using osm2pgsql?
Any help or suggestions gratefully accepted!
-tb
More information about the dev
mailing list