[OSM-dev] OSM Database schema

Stefan Keller sfkeller at gmail.com
Fri Jan 3 20:13:07 UTC 2020


Ciao Lorenzo

I assume you're interested in a software developers perspective.
For this I've found e.g. "An Introduction to OpenStreetMap" by Mele
Sax-Barnett 2014 [1].
This is a little outdated but seems to be a rather road online overview.
In order to be up-to-date replace following links there:
* ignore e.g. http://market.weogeo.com/  -  and replace with
https://osmaxx.hsr.ch/
* Replace TileMill -  with https://maputnik.github.io/
* Replace slide "The Future: Vector tiles"  - e.g. with
https://openmaptiles.org/

That's all incomplete and just scratching the surface.
So pls. read up first what OSM is and - before all - edit something in
OSM (e.g. building addresses or shops you know) in order to understand
how OSM works.

:Stefan

[1] http://pdxmele.com/intro-osm/OSM_intro_workshop.pdf

Am Fr., 3. Jan. 2020 um 16:36 Uhr schrieb Lorenzo Stucchi
<lorenzostucchi95 at outlook.it>:
>
> Dear all,
>
> For my master thesis, I will work with OpenStreetMap, and I would like to describe the database structure of OSM accurately.
>
> I found at this page [1] an image that describes the schema of the database, but elements in the table are not described. Instead, I found in this page [2] a description of the Node element, but there are not all the elements present in the image [1].
>
> Exist a page that describes all the database schema?
>
> Thank you very much,
> Stucchi Lorenzo
>
>
> [1] https://wiki.openstreetmap.org/wiki/Rails_port/Database_schema
> [2] https://wiki.openstreetmap.org/wiki/Node
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> https://lists.openstreetmap.org/listinfo/dev



More information about the dev mailing list