[OSM-dev] OSM Database schema

[Lorenzo Stucchi]

Dear all,

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.

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.

Thanks to everyone that will help, or just make a suggestion about it.

Best,
Lorenzo

[1] https://wiki.openstreetmap.org/wiki/User:LorenzoStucchi/Description_DatabaseSchema


Il giorno 4 gen 2020, alle ore 23:01, Martin Koppenhoefer <dieterdreist at gmail.com<mailto:dieterdreist at gmail.com>> ha scritto:



sent from a phone

On 4. Jan 2020, at 17:28, Jean Marie Falisse <fa003029 at skynet.be<mailto:fa003029 at skynet.be>> wrote:

Is it still true that in the OSM database, areas are not represented as such?


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.


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?


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.

Cheers Martin
_______________________________________________
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/20200109/20d20adb/attachment.htm>