OpenStreetMap: Difference between revisions
→Backend
Altilunium (talk | contribs) |
Altilunium (talk | contribs) |
||
| (4 intermediate revisions by the same user not shown) | |||
Line 1:
{{Cquote|The project, born at University College London in July 2004, was founded by Steve Coast. In the beginning, UCL supported and hosted the main server infastructure.||| Mordechai (Muki) Haklay, Patrick Weber (2008) "[https://discovery.ucl.ac.uk/id/eprint/13849/1/13849.pdf OpenStreetMap : User-Generated Street Maps]" IEEE Pervasive Computing,
{{Cquote|Created in 2004 by a British academic, OSM is a sort of Wikipedia for maps, with volunteers contributing geographic information into a centralized database, which can then be accessed by anyone for free. <br><br>
Line 6:
== Backend ==
{{Cquote|Earlier this year, in April, John Krumm from Microsoft Research, the editor of IEEE Pervasive Computing commissioned me to write a paper about OpenStreetMap for the magazine. It went through the magazine peer review process, and it is part of a set of articles in the October-December issue of the magazine that are dedicated to aspects of user-generated content.|||Muki Haklay (2008) "[https://povesham.wordpress.com/2008/10/18/openstreetmap-user-generated-street-maps-ieee-pervasive-computing-paper/ OpenStreetMap: User-Generated Street Maps – IEEE Pervasive Computing paper]"}}
{{Cquote|At the heart of OSM's technical infrastructure lies the central database holding the live data, which is implemented in MySQL. The database schema is designed to support wiki behaviors, such as versioning and rollbacks, and keeps copies of modified or deleted features indefinitely.▼
▲{{Cquote|At the heart of OSM's technical infrastructure lies the central database holding the live data, which is implemented in MySQL. The database schema is designed to support wiki behaviors, such as versioning and rollbacks, and keeps copies of modified or deleted features indefinitely.<br><br>
All geographical entities are recorded as points (nodes), which contain the coordinates alongwith username and timestamp information. Linear and area features are defined by reference to a list of ordered nodes, called "ways". Area features aren't explicitly defined in the database schema. Rather, they're defined implicitly by the condition of a way that's closed (the first node of a way is the same as the last one) and explicit tagging conventions.||| Mordechai (Muki) Haklay, Patrick Weber (2008) "[https://discovery.ucl.ac.uk/id/eprint/13849/1/13849.pdf OpenStreetMap : User-Generated Street Maps]" Pervasive Computing IEEE CS 1536-1268/08}}▼
▲All geographical entities are recorded as points (nodes), which contain the coordinates
{{Cquote|OpenStreetMap is an interesting project because they actually started on MySQL and then they started having performance problems with MySQL. So they decided to consolidate on Postgres. So most of their editing stuff is just using raw Postgres and the tile server use [[PostGIS]].|||Regina Obe (September 8, 2023) "[https://pathtocituscon.transistor.fm/episodes/why-people-care-about-postgis-and-postgres-with-paul-ramsey-regina-obe/transcript Why people care about PostGIS and Postgres]" Path To Citus Con}}
| |||