[OSM-dev] OSM Database schema

Lorenzo Stucchi lorenzostucchi95 at outlook.it
Fri Jan 10 14:51:59 UTC 2020


Thanks for the reply.

Is this the formula [1] ?

Best,
Lorenzo

[1] https://github.com/openstreetmap/openstreetmap-website/blob/751e8ad32c864f50eae9e9359d74a11dc44de007/db/structure.sql#L160

Il giorno 10 gen 2020, alle ore 15:22, Frederik Ramm <frederik at remote.org<mailto:frederik at remote.org>> ha scritto:

Hi,

On 10.01.20 15:08, Lorenzo Stucchi wrote:
What does it mean the “timestamp” present in the table (“node", “way" and “relation")?

When the object was last changed.

What does it mean the “tile” element present in the “node" table?

An integer derived from the lat/lon of the node using a mathematical
formula.

What does it mean the “sequence_id” in the “way_nodes” table and “relation_member” table?

An integer used to store the ordering of the nodes/members (which node
is the first, the second, ... in the way).

Bye
Frederik

--
Frederik Ramm  ##  eMail frederik at remote.org<mailto:frederik at remote.org>  ##  N49°00'09" E008°23'33"

_______________________________________________
dev mailing list
dev at openstreetmap.org<mailto: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/20200110/f782facd/attachment.htm>


More information about the dev mailing list