[OSM-dev] OSM Database schema

Frederik Ramm frederik at remote.org
Fri Jan 10 14:22:56 UTC 2020


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  ##  N49°00'09" E008°23'33"



More information about the dev mailing list