NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

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

You need to update the OSM file of a small geographical region every other week. Do not use osmupdate. Redownload the file from one of the OSM file services, e.g. geofabrik.de.

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's gravatar image

aitizazk
217710
accept rate: 0%

edited 03 Aug '17, 17:29


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).

permanent link

answered 03 Aug '17, 19:08

SimonPoole's gravatar image

SimonPoole ♦
44.7k13326701
accept rate: 18%

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 ♦

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×710
×263
×199
×8

question asked: 03 Aug '17, 17:28

question was seen: 1,972 times

last updated: 04 Aug '17, 11:55

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum