[OSM-dev] OSM Database schema

[Lorenzo Stucchi]

Thank you Pascal. This is can be more precise than just I looking at the visualisation [1].

But, for example, what is the “timestamp” in the “node" table? And what is the “redactions” table? Or, why in the “way_nodes” table there is “version", but also it is just a link to the “nodes” table that contains also the “version” attribute.

For this reason, I was trying to look to an explanation of this schema if it exists.

Thanks,
Stucchi Lorenzo

[1] https://wiki.openstreetmap.org/w/images/5/58/OSM_DB_Schema_2016-12-13.svg

Il giorno 4 gen 2020, alle ore 09:36, Pascal Neis <pascal at neis-one.org<mailto:pascal at neis-one.org>> ha scritto:

Maybe this is what you are searching for?
https://github.com/openstreetmap/openstreetmap-website/blob/master/db/structure.sql



Am 04.01.20 um 09:21 schrieb Lorenzo Stucchi:
Hi Stefan,
Thank you for your links, but I was searching for more detailed information. I knew how OpenStreetMap works, and I'm contributing by years.
I know how the basic database schema works and for this reason I wrote here to understood if someone has more detailed explanation of all the table that I sent in the first mail. My idea was to explain this table, but some names are not so clear. The general description of the database in different paper is base on the response of the API, but this is not the real structure of the database, so, for this reason, I was searching for this more detailed description.
Thanks,
Stucchi Lorenzo
Il giorno 3 gen 2020, alle ore 21:13, Stefan Keller <sfkeller at gmail.com> ha scritto:

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
_______________________________________________
dev mailing list
dev at openstreetmap.org
https://lists.openstreetmap.org/listinfo/dev


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20200104/25e72380/attachment-0001.htm>