[OSM-talk] osm2pgsql diff application with filtered OSM data

[Paul Norman]

On 2018-11-11 7:53 AM, Nick Whitelegg wrote:
>
>
> After thinking about this, I realised that I don't really want to 
> update _all_ the data that often. The only thing I need to update on a 
> weekly basis is the footpaths (I'm not so bothered if say the roads, 
> or the pubs are a year out of date - as long as newly mapped footpaths 
> appear quickly). So what I'm now doing is just doing an osmosis 
> extract of paths weekly, deleting all data in the DB which I class as 
> a 'path' and repopulating in amend mode.
>

This will leave your site down between the delete and import of new data.

It's also going to be fragile, because using append mode with a file 
that isn't a diff isn't supported, and if the area has a lot of 
footpaths, it'll be slower, since append has to do more work.

If you match the SQL delete and osmosis filtering carefully you 
shouldn't get too many errors, but you've probably got some to do with 
updates and changing object types.

As long as you're aware of these problems and it works for your needs, 
I'd say to go for it.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk/attachments/20181113/1cf7890d/attachment.html>