<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=""><div class="">Hi,</div><div class=""><br class=""></div><div class="">Best wishes to all !</div><div class=""><br class=""></div><div class="">I am new to this list.</div><div class=""><br class=""></div><div class="">Lorenzo, I will be very interested in reading the result of your work.</div><div class=""><br class=""></div><div class="">Is it still true that in the OSM database, areas are not represented as such? That would mean, for instance, that a pedestrian zone, let’s say a big square in a city, cannot be made to be crossed diagonally when used in a route planner. Am I right?</div><div class=""><br class=""></div><div class="">That would mean, Dear Lorenzo, that you are 🤣 a designated volunteer for the database overhaul project ! See Area datatype on “<a href="https://wiki.openstreetmap.org/wiki/Top_Ten_Tasks" class="">https://wiki.openstreetmap.org/wiki/Top_Ten_Tasks</a>”.</div><div class=""><br class=""></div><div class="">Just kidding. Still, I wouldn’t mind to be involved in this, especially if some programs could be written in the most beautiful programming language ever, Haskell of course. What you can do with this beast is just awesome.</div><div class=""><br class=""></div><div class="">Hope I didn’t disturb too much. Put it on the account of the enthusiasm of the youth! 😂 Thanks for reading.</div><div class=""><br class=""></div><div class="">JMF</div><div class=""><br class=""></div><br class=""><div class="">
<div style="color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant-ligatures: normal; font-variant-position: normal; font-variant-caps: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant-ligatures: normal; font-variant-position: normal; font-variant-caps: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant-ligatures: normal; font-variant-position: normal; font-variant-caps: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; border-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-stroke-width: 0px;"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant-ligatures: normal; font-variant-position: normal; font-variant-caps: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; border-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-stroke-width: 0px;"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-position: normal; font-variant-caps: normal; font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; border-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-stroke-width: 0px;"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class="">Jean Marie Falisse</div><div class="">Berensheide, 3</div><div class="">B 1170 Watermael-Boitsfort</div><div class="">Belgique</div><div class="">+32 2 673 32 22</div><div class="">+32 479 509899</div><div class=""><a href="mailto:jmfalisse@acm.org" class="">jmfalisse@acm.org</a></div><div class=""><a href="http://member.acm.org/~jmfalisse" class="">http://member.acm.org/~jmfalisse</a></div></div></span></div></span></div></span></div></div>
</div>
<div><br class=""><blockquote type="cite" class=""><div class="">Le 4 janv. 2020 à 11:40, mmd <<a href="mailto:mmd.osm@gmail.com" class="">mmd.osm@gmail.com</a>> a écrit :</div><br class="Apple-interchange-newline"><div class=""><div class="">On 2020-01-04 09:59, Lorenzo Stucchi wrote:<br class=""><blockquote type="cite" class="">Thank you Pascal. This is can be more precise than just I looking at the<br class="">visualisation [1].<br class=""></blockquote><br class="">I'm not aware of a comprehensive data model internals documentation<br class="">beyond the actual source code in<br class=""><a href="https://github.com/openstreetmap/openstreetmap-website" class="">https://github.com/openstreetmap/openstreetmap-website</a>, in particular<br class="">the app/*/api directory<br class=""><br class=""><blockquote type="cite" class=""><br class="">But, for example, what is the “timestamp” in the “node" table? <br class=""></blockquote><br class="">It refers to the current time in UTC when the node create/update/delete<br class="">operation was executed. Please see<br class=""><a href="https://github.com/openstreetmap/openstreetmap-website/blob/master/app/models/node.rb#L243" class="">https://github.com/openstreetmap/openstreetmap-website/blob/master/app/models/node.rb#L243</a><br class=""><br class=""><br class=""><blockquote type="cite" class="">And what is the “redactions” table? <br class=""></blockquote><br class="">It contains a list of reasons why an object has been redacted, see<br class="">https://www.openstreetmap.org/redactions - the actual objects (such as<br class="">nodes, ways, relations) refer to this redaction table via the redaction_id.<br class=""><br class=""><blockquote type="cite" class="">Or, why in the “way_nodes” table there is<br class="">“version", but also it is just a link to the “nodes” table that contains<br class="">also the “version” attribute.<br class=""></blockquote><br class="">Basically there are two different sets of tables: the current_* ones,<br class="">and the historic ones. "way_nodes" belongs to the historic set of<br class="">tables, and you need the version attribute to know that a node was part<br class="">of say version 2 of way 12345. On the other hand, the current_way_nodes<br class="">table has no version attribute, as it assumes that it refers to the<br class="">latest version of an object.<br class=""><br class=""><blockquote type="cite" class=""><br class="">For this reason, I was trying to look to an explanation of this schema<br class="">if it exists.<br class=""></blockquote><br class="">I think one good way to find out more about those different tables is to<br class="">install a local version of the Rails port and do some edits via<br class="">iD/JOSM/Potlatch. The Rails port is quite verbose and lists every single<br class="">database operation on the console.<br class=""><br class=""><br class="">-- <br class=""><br class=""><br class="">_______________________________________________<br class="">dev mailing list<br class="">dev@openstreetmap.org<br class="">https://lists.openstreetmap.org/listinfo/dev<br class=""></div></div></blockquote></div><br class=""></body></html>