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

2018-11-13 Thread Nick Whitelegg
be a few out-of-Europe visitors at that time; but as my site is quite niche with limited visitors, I consider this acceptable downtime. Nick From: Paul Norman Sent: 13 November 2018 10:12:58 To: talk@openstreetmap.org Subject: Re: [OSM-talk] osm2pgsql diff a

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

2018-11-13 Thread 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

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

2018-11-11 Thread Nick Whitelegg
@openstreetmap.org Subject: Re: [OSM-talk] osm2pgsql diff application with filtered OSM data On 2018-11-08 6:34 AM, Nick Whitelegg wrote: At the moment I download full planet extracts about every 6 months. However, due to the limitations of my server, I filter out (with osmosis) a lot of stuff I

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

2018-11-11 Thread Nick Whitelegg
... append mode! From: Nick Whitelegg Sent: 11 November 2018 15:53:18 To: talk@openstreetmap.org Subject: Re: [OSM-talk] osm2pgsql diff application with filtered OSM data Thanks for all the replies. After thinking about this, I realised that I don't really

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

2018-11-08 Thread Paul Norman
On 2018-11-08 6:34 AM, Nick Whitelegg wrote: At the moment I download full planet extracts about every 6 months. However, due to the limitations of my server, I filter out (with osmosis) a lot of stuff I don't need so that I am basically left with roads, footpaths, natural features, water

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

2018-11-08 Thread Andy Townsend
On 08/11/2018 16:16, Darafei "Komяpa" Praliaskouski wrote: Usually people also clip minutely osc, as per day database grows by a small country otherwise. There's a worked example of that (in a slightly different context) at

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

2018-11-08 Thread Nick Whitelegg
8 16:16:48 To: Nick Whitelegg Cc: osm-talk Subject: Re: [OSM-talk] osm2pgsql diff application with filtered OSM data Hi Nick, osm2pgsql is tolerant to features absent in database. You can in theory even start with empty set of tables and just insert new diff data. Usually people also clip mi

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

2018-11-08 Thread Frederik Ramm
Hi, On 08.11.2018 15:34, Nick Whitelegg wrote: > My question is this; given that not everything in the diff will be in my > database (as I filter out what I don't need during the import process), > will osm2pgsql apply the diff successfully or will it complain that not > all features in the diff

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

2018-11-08 Thread Komяpa
: > > ... sorry, when I say "full planet extracts" I mean only England, Wales, > Scotland, Ireland (all) and Greece - not the entire planet. > > > Thanks, > > Nick > > -- > *From:* Nick Whitelegg > *Sent:* 08 November 2018 14:34:1

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

2018-11-08 Thread Nick Whitelegg
... sorry, when I say "full planet extracts" I mean only England, Wales, Scotland, Ireland (all) and Greece - not the entire planet. Thanks, Nick From: Nick Whitelegg Sent: 08 November 2018 14:34:17 To: osm-talk Subject: osm2pgsql diff a

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

2018-11-08 Thread Nick Whitelegg
Hi, Looking towards overhauling the import system I use for my Freemap site (free-map.org.uk) which is itself going to go through an overhaul in the near future by moving to Tangram and hopefully applying hill shading. At the moment I download full planet extracts about every 6 months.