Hi! I am interested in downloading the whole database at real-time, both for backup and rendering. How can I do so? Thanks!

Download PostgreSQL backend database shown in image: Component Overview

asked 07 Dec '16, 05:25

Wetitpig0's gravatar image

Wetitpig0
292151827
accept rate: 10%

edited 07 Dec '16, 06:35


You will have to download the planet file from planet.openstreetmap.org and import it into a database on your side. Once you have done this, you can download daily, hourly, or even minutely updates from OpenStreetMap and apply them to your database to remain current. Most people choose osm2pgsql for importing the data into a PostGIS database which is very good for rendering, but it is a lossy process that does not capture all information from the source data. If you would like to capture all information from OSM then you would be looking at producing an "APIDB" style database with the osmosis utility but that, in turn, is less suitable for rendering.

permanent link

answered 07 Dec '16, 08:25

Frederik%20Ramm's gravatar image

Frederik Ramm ♦
70.9k836431106
accept rate: 24%

So it cannot be directly downloaded. We must rely on planet.osm?

(07 Dec '16, 09:01) Wetitpig0
2

Can you explain what you mean by "So it cannot be directly downloaded"? Downloading from planet.osm (or a mirror) is a download of the OpenStreetMap data. What happens to it next depends on what you want to do with it - some data is almost always lost as it is moved into a database designed to support whatever the user wants to do with it (rendering, searching, something else).

(07 Dec '16, 10:36) SomeoneElse ♦
3

No, you cannot directly download the OSM database that is being used on the live system, for a number of reasons - not only technical (too much impact on running system, requirement of exact same PostGIS version on receiving side etc.), but also administrative (not everything in the OSM database is public).

(07 Dec '16, 12:14) Frederik Ramm ♦
Your answer
toggle preview

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:

×280
×240
×195
×91
×24

question asked: 07 Dec '16, 05:25

question was seen: 1,610 times

last updated: 07 Dec '16, 12:14

powered by OSQA