<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">
Hi all,
<div class=""><br class="">
</div>
<div class="">I have almost complete the explanation of the schema regarding the element (node, way and relation) I have just one last element to be understood.</div>
<div class=""><br class="">
</div>
<div class="">The “tile” in the node table. I found in the code a function called “<span class="pl-en">public</span>.tile_for_point” [1] and seems that should be the one that do this process. But I’m not able to understood which is the output of the function,
in particular what this part of code does:</div>
<div class=""><br class="">
</div>
<div class="">
<div><span class="Apple-tab-span" style="white-space:pre"></span>x :<span class="pl-k">=</span> (x | (x
<span class="pl-k"><<</span> <span class="pl-c1">8</span>)) & <span class="pl-c1">
16711935</span>; <span class="pl-c"><span class="pl-c">—</span> 0x00FF00FF</span></div>
<div><span class="pl-c"><br class="">
</span></div>
<div><span class="pl-c">Thanks for all the reply.</span></div>
<div><span class="pl-c"><br class="">
</span></div>
<div><span class="pl-c">Best,</span></div>
<div><span class="pl-c">Lorenzo</span></div>
<div><br class="">
</div>
<div>[1] <a href="https://github.com/openstreetmap/openstreetmap-website/blob/751e8ad32c864f50eae9e9359d74a11dc44de007/db/structure.sql#L160" class="">https://github.com/openstreetmap/openstreetmap-website/blob/751e8ad32c864f50eae9e9359d74a11dc44de007/db/structure.sql#L160</a></div>
<div><br class="">
<blockquote type="cite" class="">
<div class="">Il giorno 10 gen 2020, alle ore 15:51, Lorenzo Stucchi <<a href="mailto:lorenzostucchi95@outlook.it" class="">lorenzostucchi95@outlook.it</a>> ha scritto:</div>
<br class="Apple-interchange-newline">
<div class="">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">
Thanks for the reply.
<div class=""><br class="">
</div>
<div class="">Is this the formula [1] ?</div>
<div class=""><br class="">
</div>
<div class="">Best,</div>
<div class="">Lorenzo</div>
<div class=""><br class="">
</div>
<div class="">[1] <a href="https://github.com/openstreetmap/openstreetmap-website/blob/751e8ad32c864f50eae9e9359d74a11dc44de007/db/structure.sql#L160" class="">https://github.com/openstreetmap/openstreetmap-website/blob/751e8ad32c864f50eae9e9359d74a11dc44de007/db/structure.sql#L160</a> <br class="">
<div class=""><br class="">
<blockquote type="cite" class="">
<div class="">Il giorno 10 gen 2020, alle ore 15:22, Frederik Ramm <<a href="mailto:frederik@remote.org" class="">frederik@remote.org</a>> ha scritto:</div>
<br class="Apple-interchange-newline">
<div class="">
<div class="">Hi,<br class="">
<br class="">
On 10.01.20 15:08, Lorenzo Stucchi wrote:<br class="">
<blockquote type="cite" class="">What does it mean the “timestamp” present in the table (“node", “way" and “relation")?<br class="">
</blockquote>
<br class="">
When the object was last changed.<br class="">
<br class="">
<blockquote type="cite" class="">What does it mean the “tile” element present in the “node" table?<br class="">
</blockquote>
<br class="">
An integer derived from the lat/lon of the node using a mathematical<br class="">
formula.<br class="">
<br class="">
<blockquote type="cite" class="">What does it mean the “sequence_id” in the “way_nodes” table and “relation_member” table?<br class="">
</blockquote>
<br class="">
An integer used to store the ordering of the nodes/members (which node<br class="">
is the first, the second, ... in the way).<br class="">
<br class="">
Bye<br class="">
Frederik<br class="">
<br class="">
-- <br class="">
Frederik Ramm ## <a href="mailto:frederik@remote.org" class="">eMail frederik@remote.org</a> ## N49°00'09" E008°23'33"<br class="">
<br class="">
_______________________________________________<br class="">
dev mailing list<br class="">
<a href="mailto:dev@openstreetmap.org" class="">dev@openstreetmap.org</a><br class="">
<a href="https://lists.openstreetmap.org/listinfo/dev" class="">https://lists.openstreetmap.org/listinfo/dev</a><br class="">
</div>
</div>
</blockquote>
</div>
<br class="">
</div>
</div>
_______________________________________________<br class="">
dev mailing list<br class="">
<a href="mailto:dev@openstreetmap.org" class="">dev@openstreetmap.org</a><br class="">
https://lists.openstreetmap.org/listinfo/dev<br class="">
</div>
</blockquote>
</div>
<br class="">
</div>
</body>
</html>