<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="">Dear all,</div>
<div class=""><br class="">
</div>
<div class="">After the discussion that I started about the database schema I tried to create a wiki page that explains it, I started the page on my user wiki-page [1]. I started with few tables, but some elements present in the tables are not so clear to me.</div>
<div class=""><br class="">
</div>
<div class="">So If you wanna try to contribute to that page, since a description of the database can be provided to everyone. I will continue to modify it ,trying to understand all the tables.</div>
<div class=""><br class="">
</div>
<div class="">Thanks to everyone that will help, or just make a suggestion about it.</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://wiki.openstreetmap.org/wiki/User:LorenzoStucchi/Description_DatabaseSchema" class="">https://wiki.openstreetmap.org/wiki/User:LorenzoStucchi/Description_DatabaseSchema</a></div>
<div class=""><br class="">
<div><br class="">
<blockquote type="cite" class="">
<div class="">Il giorno 4 gen 2020, alle ore 23:01, Martin Koppenhoefer <<a href="mailto:dieterdreist@gmail.com" class="">dieterdreist@gmail.com</a>> ha scritto:</div>
<br class="Apple-interchange-newline">
<div class="">
<div class=""><br class="">
<br class="">
sent from a phone<br class="">
<br class="">
<blockquote type="cite" class="">On 4. Jan 2020, at 17:28, Jean Marie Falisse <<a href="mailto:fa003029@skynet.be" class="">fa003029@skynet.be</a>> wrote:<br class="">
<br class="">
Is it still true that in the OSM database, areas are not represented as such?<br class="">
</blockquote>
<br class="">
<br class="">
areas can be represented as areas through multipolygon relations which are always areas or by help of an additional tag (area=yes/no), or through plausibility (tags and their combinations may imply an area or not). There isn’t a dedicated area object, maybe
this is what you meant. Areas are represented with ways, and tags or relations are required to define the ways as areas.<br class="">
<br class="">
<br class="">
<blockquote type="cite" class="">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?<br class="">
</blockquote>
<br class="">
<br class="">
typically routing engines operate on graphs, i.e. they do not route diagonally across areas, but this isn’t related to the question whether there is a dedicated datatype for areas or not.<br class="">
<br class="">
Cheers Martin <br class="">
_______________________________________________<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>
</div>
</blockquote>
</div>
<br class="">
</div>
</body>
</html>