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

[Stephan Knauss]

Hi, 

I think the way described here also helps you to clean up your database from time to time

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

Stephan 


On November 30, 2015 9:29:09 PM GMT+07:00, tb <osm at qayx.net> wrote:
>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
>
>
>_______________________________________________
>dev mailing list
>dev at openstreetmap.org
>https://lists.openstreetmap.org/listinfo/dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20151201/6047c5ee/attachment.html>