How and where are openstreetmap data stored?

This could look like quite a basic question but I can't find a clear answer on the Internet... I was simply wondering what DBMS was used to store OSM data. By entering such a question on Google, you get so many informations on how to extract data and import them into various DBMS, but no basic information (just for curious guys) about the way data are stored. I recently read about NoSQL that was based on Key-Value pairs, which reminded me the way OSM data are tagged. Is OSM on NoSQL? Or PostgreSQL? Or any other DBMS? Many thanks for your answers.

development server database

asked 24 Sep '15, 19:55

wiltomap
111●5●6●12
accept rate: 0%

edited 24 Sep '15, 20:04

aseerel4c26 ♦
32.6k●18●248●554

2 Answers:

active answers oldest answers newest answers popular answers

OSM started out on MySQL but has changed to PostgreSQL (not PostGIS) in 2009 and that's what we still use.

permanent link

answered 24 Sep '15, 20:01

Frederik Ramm ♦
82.5k●92●720●1273
accept rate: 23%

edited 24 Sep '15, 20:10

Note that PostGIS is often used in derived databases, like rendering and geocoding.

(25 Sep '15, 11:24) Vincent de P... ♦

See https://wiki.openstreetmap.org/wiki/Database and see https://wiki.openstreetmap.org/wiki/Develop "for curious guys". :-)

permanent link

answered 24 Sep '15, 20:07

aseerel4c26 ♦
32.6k●18●248●554
accept rate: 18%

edited 24 Sep '15, 20:27

Many thanks to the both of you! I'm gonna have a closer look at it.

(24 Sep '15, 20:45) wiltomap

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

learn more about Markdown

Question tags:

server ×123
database ×118
development ×113

question asked: 24 Sep '15, 19:55

question was seen: 6,832 times

last updated: 25 Sep '15, 11:24

How and where are openstreetmap data stored?

Follow this question

Related questions