I have only roads data from US, Canada and Mexico in my DB imported using osm2pgsql. As it is mentioned in the osmupdate wiki page here
Since I want to keep my db size as small as possible. will it be a good idea to do the following on a weekly basis 1 - Download the osm.pbf file 2 - convert to o5m (this step is for osm filter) 3 - filter for only road data 4 - import using osm2pgsql in slim mode using --drop Any feedback will be highly appreciated asked 03 Aug '17, 17:28 aitizazk |
I'm not sure why you don't simply change your default.style file to only import road data, the main issue that even with that your database will grow due to edits outside of the area you imported (there are however a couple of ways to work around that). answered 03 Aug '17, 19:08 SimonPoole ♦ Can you guide me regarding the work around?
(04 Aug '17, 10:46)
aitizazk
One possible workaround is to use https://github.com/zverik/regional from Zverik . That's really simple to use (just call it with the parameters you need to trim the update file down). There's an example of its use described at https://wiki.openstreetmap.org/wiki/User:SomeoneElse/Ubuntu_1604_tileserver_load#Updating_your_database_as_people_edit_OpenStreetMap .
(04 Aug '17, 11:55)
SomeoneElse ♦
|