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

[Nick Whitelegg]

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 <me at 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.whitelegg at solent.ac.uk<mailto:nick.whitelegg at 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 at openstreetmap.org<mailto:talk at openstreetmap.org>
https://lists.openstreetmap.org/listinfo/talk
--
Darafei Praliaskouski
Support me: http://patreon.com/komzpa
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk/attachments/20181108/10181e7f/attachment-0001.html>