NOTICE: is being shutdown on 1st March 2024. Please use the OpenStreetMap Community Forum

I have setup a local version of OSM database using osm2pgsql in slim mode. Now I have the following tables






I used the following command to migrate the database

osm2pgsql -c -d DATABASE_NAME --slim planet.osm.pbf

Every thing is working fine. now I want to update these regularly and stay up to date with latest changes.

-- Since I am using rails is there a way to update these tables programatically? I mean I can run a schedulized job and it will update it with latest changes without having to download entire osm files?

-- Secondly since I am only interested in US, Canada and Mexico is there a way to fetch only these countries data?


asked 25 Jul '17, 16:33

aitizazk's gravatar image

accept rate: 0%

If you've got a rendering server (which I'm assuming that you have) and are using mod_tile (which you may not be) then this wiki page might be useful. Even if you're not then you should be able to adapt the link to Zverik's "regional" scripts from there to cut down the updates that you apply to only North America.

permanent link

answered 25 Jul '17, 16:48

SomeoneElse's gravatar image

SomeoneElse ♦
accept rate: 16%

Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 25 Jul '17, 16:33

question was seen: 2,944 times

last updated: 26 Jul '17, 07:45

NOTICE: is being shutdown on 1st March 2024. Please use the OpenStreetMap Community Forum