Hello Darafei and Frederik,
OK - thanks for that. What I will do therefore, to avoid unwanted data, is to generate a filtered planet extract and import that into the DB, and then generate another filtered extract and find the diff between the two. Advantage of that is that I'll only need to do the first filtering run on the server, and subsequent runs on my local machine (assuming the resulting diff is small enough to upload from my local machine to the server). Thanks, Nick ________________________________ From: Darafei "Komяpa" Praliaskouski <m...@komzpa.net> Sent: 08 November 2018 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 minutely osc, as per day database grows by a small country otherwise. чт, 8 нояб. 2018 г. в 17:37, Nick Whitelegg <nick.whitel...@solent.ac.uk<mailto:nick.whitel...@solent.ac.uk>>: ... 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 application with filtered OSM data Hi, Looking towards overhauling the import system I use for my Freemap site (free-map.org.uk<http://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. 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 features and selected POIs. I'd like to move towards a system which applies diffs from geofabrik instead, and applies them regularly (daily or weekly) with osm2pgsql. 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 are in my database? Thanks, Nick _______________________________________________ talk mailing list talk@openstreetmap.org<mailto:talk@openstreetmap.org> https://lists.openstreetmap.org/listinfo/talk -- Darafei Praliaskouski Support me: http://patreon.com/komzpa
_______________________________________________ talk mailing list talk@openstreetmap.org https://lists.openstreetmap.org/listinfo/talk