CINXE.COM

<!DOCTYPE html> <html lang="en" dir="ltr"> <head data-locale="en" data-preferred-editor="id" data-preferred-languages="[]"> <meta http-equiv="X-UA-Compatible" content="IE=edge" /> <meta name="viewport" content="width=device-width, initial-scale=1"> <script src="/assets/es6-cc19e63b7a2e5f3f8c46ccc37c11ad86296fc884065d87953d54ce1ea036b383.js"></script> <script src="/assets/turbo-130bc04eb27728ef810e643ee13c633b1f3d40f94e3008b768da944d51362570.js" type="module"></script> <script src="/assets/application-e0a1093982b9a7dd5a32355c3cec5a3a1d2ced91de2496a4e0986539a6793e37.js"></script> <script src="/assets/i18n/en-d5230800fcd121573166ba17d5bd19a3c85ef44bf73681078ab732a3b8848a69.js"></script> <link rel="stylesheet" href="/assets/screen-ltr-b9104c2ca372ecae9016145b60d2ab6b12a6870c75b3a543ddc1ea195943cbfd.css" media="screen" /> <link rel="stylesheet" href="/assets/print-ltr-2b3d6571f8a48820d650d5ce29f567269af78d5158f89ecab755db8c5d3d62db.css" media="print" /> <link rel="stylesheet" href="/assets/leaflet-all-7224da9b323ba8c997b953386cd9f33bfe5f0860fab29e9e4c12b71f369b9dc9.css" media="screen, print" /> <link rel="icon" type="image/x-icon" href="/assets/favicon-042c50e8224a5c999369ec96f5367cb5b14db4671f1485caeec1277481073093.ico" /> <link rel="apple-touch-icon" type="image/png" href="/assets/apple-touch-icon-57x57-0af2b52ac2b1a8cb0aba42f17aa901bfdedb9174bd978f838e3b3e1dd8602f52.png" sizes="57x57" /> <link rel="apple-touch-icon" type="image/png" href="/assets/apple-touch-icon-60x60-cff74c9066d8e7fd08b29407712edbae5613cc9a4c03ee0398a89502a6a41d1f.png" sizes="60x60" /> <link rel="apple-touch-icon" type="image/png" href="/assets/apple-touch-icon-72x72-63c6fdf3ddf65feebac1c0441bf6a378d1e4bde7107f598ae86733c402895eae.png" sizes="72x72" /> <link rel="apple-touch-icon" type="image/png" href="/assets/apple-touch-icon-76x76-1740d6e7a59521693c496dd8fbe1caf3d5ad302017cb0f5073b6914b4f5b7544.png" sizes="76x76" /> <link rel="apple-touch-icon" type="image/png" href="/assets/apple-touch-icon-114x114-20ba9df1a8f9b341040d661b7942b7b10288b9b4c4ce0663e10018958dc7f4a8.png" sizes="114x114" /> <link rel="apple-touch-icon" type="image/png" href="/assets/apple-touch-icon-120x120-c304991e604d1be82639709b96fb87f7b6b6688cc0d04d5f6141604259299648.png" sizes="120x120" /> <link rel="apple-touch-icon" type="image/png" href="/assets/apple-touch-icon-144x144-fbf20bdf9d2f7c1fe8eb85d7869a9bda285be88c93a39438150f5eb5955758ce.png" sizes="144x144" /> <link rel="apple-touch-icon" type="image/png" href="/assets/apple-touch-icon-152x152-af45dc979e972cab863517b2cb33a3dcf3e04e02a2eb2734c6f93edc21fa395d.png" sizes="152x152" /> <link rel="apple-touch-icon" type="image/png" href="/assets/apple-touch-icon-180x180-ea6361d7ae5b3f08c6290652ad703fa239364cc09c84873044f3299845f24652.png" sizes="180x180" /> <link rel="icon" type="image/png" href="/assets/favicon-32x32-99b88fcadeef736889823c8a886b89d8cada9d4423a49a27de29bacc0a6bebd1.png" sizes="32x32" /> <link rel="icon" type="image/png" href="/assets/favicon-194x194-79d3fb0152c735866e64b1d7535d504483cd13c2fad0131a6142bd9629d30de2.png" sizes="194x194" /> <link rel="icon" type="image/png" href="/assets/favicon-96x96-6ffbc38962fddb870f9577b76430a0ee4db5fb4eca485f850cd45436d7f3eb87.png" sizes="96x96" /> <link rel="icon" type="image/png" href="/assets/android-chrome-192x192-f970b9be3965dfda6ea9481b305c39b2ec794e296f802235e30d4671f0f896e1.png" sizes="192x192" /> <link rel="icon" type="image/png" href="/assets/favicon-16x16-474476c1b2381628a81361a9e2bf04b936d21f77c59e84b48c6c69ea376fb6cf.png" sizes="16x16" /> <link rel="mask-icon" href="/assets/tab-icon-3e700a12d38a1bba06d674ed663824232025cd6b0ca5c439c846740a7468b302.svg" color="#7ebc6f"> <link rel="manifest" href="/assets/manifest-b2cc1407226d3e16e6149425747239c259fbe44b41bff3aca36ca6d9e56a6e18.json"> <meta name="msapplication-config" content="/assets/browserconfig-c59184dc0264731151cbf50ae58f7fa8ae5153138013f125203e1193800f862f.xml"> <meta name="msapplication-TileColor" content="#00a300"> <meta name="msapplication-TileImage" content="/assets/mstile-144x144-02723f6f7cb2c18e6f8041c93f80982decb52b24a7e447477bc2ce3136d75806.png"> <meta name="theme-color" content="#ffffff"> <meta name="turbo-refresh-method" content="morph"> <meta name="turbo-refresh-scroll" content="preserve"> <link href="https://www.openstreetmap.org/diary/" rel="canonical" /> <link rel="search" type="application/opensearchdescription+xml" title="OpenStreetMap Search" href="/assets/osm-42b7b3fbcee2193e455a773db6cd3d34a2f48ca94547fed54901dd9d8307b02b.xml"> <meta name="description" content="OpenStreetMap is the free wiki world map."> <meta property="og:site_name" content="OpenStreetMap"> <meta property="og:title" content="Users' Diaries"> <meta property="og:type" content="website"> <meta property="og:url" content="https://www.openstreetmap.org/diary"> <meta property="og:description" content="OpenStreetMap is a map of the world, created by people like you and free to use under an open license."> <meta property="og:image" content="https://www.openstreetmap.org/assets/osm_logo_256-ed028f90468224a272961c380ecee0cfb73b8048b34f4b4b204b7f0d1097875d.png"> <meta property="og:image:alt" content="OpenStreetMap logo"> <meta name="robots" content="noindex"> <link rel="alternate" type="application/rss+xml" title="RSS" href="https://www.openstreetmap.org/diary/rss" /> <meta name="csrf-param" content="authenticity_token" /> <meta name="csrf-token" content="a-i9-l6OShz5SLMgdbwxyND1jKpnJNIWbqFCU0VAcE7XTpD9ZjZuZCise3HIbIUmPJCFupuoLqMYQfVwBUu1vw" /> <meta name="csp-nonce" content="kUVAGLkoTyCxg1baQK6g/9nbCDZPxbGL" /> <title>Users' Diaries | OpenStreetMap</title> </head> <body class="diary_entries diary_entries-index"> <header class="d-flex bg-body text-nowrap closed z-3"> <h1 class="d-flex m-0 fw-semibold"> <a href="/" class="icon-link gap-1 text-body-emphasis text-decoration-none geolink"> <img alt="OpenStreetMap logo" src="/assets/osm_logo-4b074077c29e100f40ee64f5177886e36b570d4cc3ab10c7b263003d09642e3f.svg" width="30" height="30" /> OpenStreetMap </a> </h1> <a href="#" id="menu-icon"></a> <nav class='primary'> <div id="edit_tab" class="btn-group"> <a class="btn btn-outline-primary geolink editlink" id="editanchor" data-editor="id" href="/edit">Edit</a> <button class='btn btn-outline-primary dropdown-toggle dropdown-toggle-split flex-grow-0' type='button' data-bs-toggle='dropdown'></button> <ul class='dropdown-menu'> <li> <a data-editor="id" class="geolink editlink dropdown-item" href="/edit?editor=id">Edit with iD (in-browser editor)</a> </li> <li> <a data-editor="remote" class="geolink editlink dropdown-item" href="/edit?editor=remote">Edit with Remote Control (JOSM, Potlatch, Merkaartor)</a> </li> </ul> </div> </nav> <nav class='secondary d-flex gap-2 align-items-center'> <ul class='nav flex-nowrap'> <li class="compact-hide nav-item"> <a class="nav-link text-secondary" href="/history">History</a> </li> <li class="compact-hide nav-item"> <a class="nav-link text-secondary" href="/export">Export</a> </li> <li class="compact-hide nav-item"> <a class="nav-link text-secondary" href="/traces">GPS Traces</a> </li> <li class="compact-hide nav-item"> <a class="nav-link text-secondary-emphasis" href="/diary">User Diaries</a> </li> <li class="compact-hide nav-item"> <a class="nav-link text-secondary" href="/communities">Communities</a> </li> <li class="compact-hide nav-item"> <a class="nav-link text-secondary" href="/copyright">Copyright</a> </li> <li class="compact-hide nav-item"> <a class="nav-link text-secondary" href="/help">Help</a> </li> <li class="compact-hide nav-item"> <a class="nav-link text-secondary" href="/about">About</a> </li> <li id="compact-secondary-nav" class="dropdown nav-item"> <button class="dropdown-toggle nav-link btn btn-outline-secondary border-0 bg-body text-secondary" type="button" data-bs-toggle="dropdown">More</button> <ul class="dropdown-menu"> <li><a class="dropdown-item" href="/history">History</a></li> <li><a class="dropdown-item" href="/export">Export</a></li> <li><a class="dropdown-item" href="/traces">GPS Traces</a></li> <li><a class="dropdown-item" href="/diary">User Diaries</a></li> <li><a class="dropdown-item" href="/communities">Communities</a></li> <li><a class="dropdown-item" href="/copyright">Copyright</a></li> <li><a class="dropdown-item" href="/help">Help</a></li> <li><a class="dropdown-item" href="/about">About</a></li> </ul> </li> </ul> <div class="d-inline-flex btn-group login-menu" role=""> <a class="geolink btn btn-outline-secondary" href="/login?referer=%2Fdiary">Log In</a> <a class="btn btn-outline-secondary" href="/user/new">Sign Up</a> </div> </nav> </header> <div id="content" class=""> <div class="content-heading bg-body-secondary border-bottom border-secondary-subtle"> <div class="content-inner "> <div class="row"> <div class="col"> <h1>Users' Diaries</h1> <nav class="secondary-actions"> <ul class="clearfix"> <li><a href="/diary/rss"><img class="align-text-bottom" src="/assets/RSS-3e2f4eddf1fa4751b43493728dbc559c766daf848ccbda961627ca36e39dfe88.png" width="16" height="16" /></a></li> </ul> </nav> </div> </div> </div> </div> <div class="content-body"> <div class="content-inner"> <turbo-frame id="pagination" target="_top" data-turbo="false"> <h4>Recent diary entries</h4> <article class='diary_post border-top border-secondary-subtle py-3 user_115612'> <div class='mb-3'> <div class="row"> <div class="col-auto"> <img class="user_thumbnail border border-secondary-subtle bg-body" alt="" width="43" height="50" src="https://www.openstreetmap.org/rails/active_storage/representations/redirect/eyJfcmFpbHMiOnsiZGF0YSI6MzQwOSwicHVyIjoiYmxvYl9pZCJ9fQ==--d34284cf06f51c1a180926fe34f5d96a00aa538a/eyJfcmFpbHMiOnsiZGF0YSI6eyJmb3JtYXQiOiJqcGciLCJyZXNpemVfdG9fbGltaXQiOls1MCw1MF19LCJwdXIiOiJ2YXJpYXRpb24ifX0=--dea07cf4fabdae9c56d9008d879a5332bbf580ce/tyr.jpg" /> </div> <div class="col"> <h2><a href="/user/tyr_asd/diary/405686">iD development update n2</a></h2> </div> </div> <small class='text-body-secondary'> Posted by <a href="/user/tyr_asd">tyr_asd</a> on 27 November 2024 in <a href="/diary/en">English</a>. </small> </div> <div class="richtext text-break" xml:lang="en" lang="en"> <h3 id="my-talk-at-state-of-the-map-2024">My Talk at State of the Map 2024</h3> <p><strong>(How the iD Editor still can to do better in the long term)</strong></p> <p>This September, I presented some ideas for the future of OSM’s iD editor at the State of the Map conference in Nairobi. Now, the video recording of the talk <a href="https://2024.stateofthemap.org/sessions/3D9RGU/" rel="nofollow noopener noreferrer">is online</a>. To summarize the talk’s content: I identified two core challenges faced by the iD editor which need to be addressed in the upcoming years:</p> <h5 id="data-complexity">1. Data Complexity</h5> <p>Naturally, OSM’s data got more complex over time – as an example, a <em>simple</em> school might have typically been mapped as a single POI node in OSM a couple of years ago, while nowadays the state of the art is to model it using multiple map features that are nested within each other. While this allows to represent the reality in a high level of detail, the added complexity needs to be accommodated for by the tooling, especially in an editor tailored for beginner mappers like iD. For a deep dive into this topic, see also <a href="https://2024.stateofthemap.org/sessions/98JMSV/" rel="nofollow noopener noreferrer">Sarah Hoffmann’s talk</a> at the same conference.</p> <p><img src="https://wiki.openstreetmap.org/w/images/8/86/Amenity_school_usage_example_single_school_-_Proposal.svg" alt="schematic mapping of a "school" consisting of different features representing objects like the school ground, school building, playgrounds, access paths, entrances, etc."></p> <h5 id="map-maintenance">2. Map Maintenance</h5> <p>Another important point for the development of iD is that at least in some regions of the world, the mapping is moving away from mapping objects for the very first time on a blank map canvas. Instead, it becomes more any more important to efficiently keep the map up to date and perform <em>map maintenance</em> tasks. This insight is by the way definitely not new, as it was already discussed at State of the Map US 2013 <a href="https://2013.stateofthemap.us/sunday.html#schedule/sunday/from-wiki-gardening-to-map-gardening-analyzing-contribution-patterns-in-openstreetmap" rel="nofollow noopener noreferrer">by Alan McConchie</a>. One of the proposed ways to address this topic could be to more prominently support the <a href="https://wiki.openstreetmap.org/wiki/Key:check_date" rel="nofollow noopener noreferrer">last check date</a> tag in the editor.</p> <p><img src="https://wiki.openstreetmap.org/w/images/0/08/Id-mockup-check_date.png" alt="mockup of a user interface element in the iD editor, which prominently displays the last check date of a map feature"></p> <p>This is all still at an early stage, and a lot is still to be figured out. So, any form of feedback is very welcome. Please get involved.</p> <h3 id="object-lifecycle-mapping">Object lifecycle mapping</h3> <p>One of the above mentioned ideas to make iD fit for the mapping tasks of the future is to make it more intuitive to change the <a href="https://wiki.openstreetmap.org/wiki/Lifecycle" rel="nofollow noopener noreferrer">lifecycle status</a> of an object: For example when marking a feature that was under construction as completed, or when tagging a POI as temporarily or permanently closed. Mattia, who has already completed a <a href="https://www.openstreetmap.org/user/Juicio/diary/404174" rel="nofollow noopener noreferrer">Google Summer of Code project</a> around the iD editor, has recently started to work on this as part of a university training course for his master studies in computer science.</p> <p>In a preliminary analysis, we have already identified that the current state of which tagging schemas are used to map the lifecycle statuses of different kinds of map features is not very consistent in all cases. This means that we will definitely spend some time to figure out a good way to make the implementation as compliant as possible with how these statuses are currently mapped: As a first step, there will be a discussion thread in the community forum to discuss the involved details. Stay tuned to hear more about this from Mattia and me in the near future!</p> <p>PS: If you are also interested to tackle a particular feature of the iD editor, for example in form of a university thesis, don’t hesitate to contact <a href="mailto:martin@raifer.tech" rel="nofollow noopener noreferrer">us</a>!</p> <h3 id="upcoming">Upcoming</h3> <ul> <li>An update of iD in form of version 2.31 is coming soon. The most notable improvements of this release include a bugfix for the flickering while switching background imagery layers, as well a <a href="https://github.com/openstreetmap/iD/pull/10452" rel="nofollow noopener noreferrer">reworked unit test</a> setup which hugely improves the developer experience: Instead of waiting around for minutes to see if your changes comply with iD’s test suite, you now typically get the results within seconds. Thanks Kyle for this very valuable contribution!</li> <li>The next online community chats are happening at the following dates, feel free to join if you like! <ul> <li><a href="https://osmcal.org/event/3296/" rel="nofollow noopener noreferrer">December 4, 3pm UTC</a></li> <li><a href="https://osmcal.org/event/3297/" rel="nofollow noopener noreferrer">January 8, 3pm UTC</a></li> </ul> </li> </ul> </div> <nav class='secondary-actions'> <ul class='clearfix'> <li><a href="/user/tyr_asd/diary/405686#newcomment">Comment on this entry</a></li> <li><a href="/message/new/tyr_asd?message%5Btitle%5D=Re%3A+iD+development+update+n2">Send a message to the author</a></li> <li> <a href="/user/tyr_asd/diary/405686#comments">No comments</a> </li> </ul> </nav> </article> <article class='diary_post border-top border-secondary-subtle py-3 user_21317938'> <div class='mb-3'> <div class="row"> <div class="col-auto"> <img class="user_thumbnail border border-secondary-subtle bg-body" alt="" width="50" height="50" src="https://www.gravatar.com/avatar/1d9c7876fdecdf44b3af806344ae043a.jpg?s=50&d=https%3A%2F%2Fwww.openstreetmap.org%2Fassets%2Favatar_large-54d681ddaf47c4181b05dbfae378dc0201b393bbad3ff0e68143c3d5f3880ace.png" /> </div> <div class="col"> <h2><a href="/user/coteyka/diary/405684">:D</a></h2> </div> </div> <small class='text-body-secondary'> Posted by <a href="/user/coteyka">coteyka</a> on 27 November 2024 in <a href="/diary/ru">Russian (Русский)</a>. </small> </div> <div class="richtext text-break" xml:lang="ru" lang="ru"> <h2 id="httpswikiopenstreetmaporgwikirukeyroadmarking-----">Перевел <a href="https://wiki.openstreetmap.org/wiki/RU:Key:road_marking" rel="nofollow noopener noreferrer">статью</a> из вики ОСМ на русский.</h2> <p>Первая переведенная мною статься, надеюсь идея HD разметки дорог будет развиваться дальше.</p> </div> <nav class='secondary-actions'> <ul class='clearfix'> <li><a href="/user/coteyka/diary/405684#newcomment">Comment on this entry</a></li> <li><a href="/message/new/coteyka?message%5Btitle%5D=Re%3A+%3AD">Send a message to the author</a></li> <li> <a href="/user/coteyka/diary/405684#comments">No comments</a> </li> </ul> </nav> </article> <article class='diary_post border-top border-secondary-subtle py-3 user_22225475'> <div class='mb-3'> <div class="row"> <div class="col-auto"> <img class="user_thumbnail border border-secondary-subtle bg-body" alt="" width="50" height="50" src="/assets/avatar-c143fe593788b7de19f84df0a6ffd4433400bf343af670feface7cbfb13e67e6.svg" /> </div> <div class="col"> <h2><a href="/user/MNR%20Solutions%20Noida/diary/405683">staffing solutions</a></h2> </div> </div> <small class='text-body-secondary'> Posted by <a href="/user/MNR%20Solutions%20Noida">MNR Solutions Noida</a> on 27 November 2024 in <a href="/diary/en">English</a>. </small> </div> <div class="richtext text-break" xml:lang="en" lang="en"> <p><a href="https://mnrsolutions.in/staffing-solutions/" rel="nofollow noopener noreferrer">https://mnrsolutions.in/staffing-solutions/</a>: Finding the Right Talent for Every Role We offer a wide range of staffing solutions, including:</p> <p>Temporary Staffing</p> <p>Permanent Placement</p> <p>Contract-to-Hire</p> <p>Executive Search</p> </div> <nav class='secondary-actions'> <ul class='clearfix'> <li><a href="/user/MNR%20Solutions%20Noida/diary/405683#newcomment">Comment on this entry</a></li> <li><a href="/message/new/MNR%20Solutions%20Noida?message%5Btitle%5D=Re%3A+staffing+solutions">Send a message to the author</a></li> <li> <a href="/user/MNR%20Solutions%20Noida/diary/405683#comments">No comments</a> </li> </ul> </nav> </article> <article class='diary_post border-top border-secondary-subtle py-3 user_486606'> <div class='mb-3'> <div class="row"> <div class="col-auto"> <img class="user_thumbnail border border-secondary-subtle bg-body" alt="" width="50" height="50" src="/assets/avatar-c143fe593788b7de19f84df0a6ffd4433400bf343af670feface7cbfb13e67e6.svg" /> </div> <div class="col"> <h2><a href="/user/Barro/diary/405682">Pyöräpysäköintipaikkojen kartoituskauden 2024 tuloksia</a></h2> </div> </div> <small class='text-body-secondary'> Posted by <a href="/user/Barro">Barro</a> on 26 November 2024 in <a href="/diary/fi">Finnish (Suomi)</a>. </small> </div> <div class="richtext text-break" xml:lang="fi" lang="fi"> <p>Nyt sää alkaa olla sen verran kylmä, ja välillä luminen, että voidaan todeta, että on aika siirtää pyöräpysäköintipaikkojen kartoitus talvilevolle ja jatkaa urakkaa isommassa määrin sitten, kun pakkaset ovat taas väistyneet.</p> <p>Kauden 2024 projektina itselläni oli seuraavanlaisia asioita läpikäytävänä omalta <a href="https://barro.gitlab.io/osm-diary-files/kartoituskauden-2024-tuloksia/kartta-alue.html" rel="nofollow noopener noreferrer">tarkastelualueeltani</a>:</p> <ul> <li>Käydään määräpuutteelliset pyöräpysäköintialueet läpi ja täydennetään niihin olennaisimmat tiedot.</li> <li>Tarkistetaan pyöräpysäköintialueet, joihin ei ole koskettu sitten vuoden 2018 alun jälkeen, että onko mikään merkittävästi muuttunut.</li> <li>Käydään juna-asemien pyöräpysäköintimahdollisuudet läpi.</li> <li>Aloitetaan koulujen ja päiväkotien pyöräpysäköintimahdollisuuksien läpikäynti. Tästä tuli kirjoitettua <a href="https://www.openstreetmap.org/user/Barro/diary/405617" rel="nofollow noopener noreferrer">Päiväkotien ja koulujen pyöräpysäköintitilanne</a> -artikkelissa vähän pidemmälti.</li> </ul> <p>Näissä projekteissa huomiona se, että kun merkitsen pyöräpysäköintimahdollisuuksia kartalle, en ota huomioon kiekonväännintelineiden olemassaoloa. Paitsi jos kyseinen pysäköintialue on jonkun muun lisäämä kartalle. Tähän syynä se, että kyseiset telineet on huonompi vaihtoehto pyörän pysäköinnin suhteen kuin kiinnittää pyörä aitaan tai tolppaan. Ja eivät toimi suunnitellusti isolle osalle pyörätyypeistä, jotka ei osu siihen yhteen platoniseen ideaaliipyörätyyppiin, jolle kyseinen telinemalli on mitoitettu.</p> <h1 id="huomiota-kiinnittneit-asioita">Huomiota kiinnittäneitä asioita</h1> <p>Kartoituskauden aikana jotkut asiat kiinnitti huomiota positiivisessa määrin.</p> <figure id="#kaisantunnelin-pyöräparkki"> <a href="https://barro.gitlab.io/osm-diary-files/kartoituskauden-2024-tuloksia/kaisantunnelin-pyöräparkki.webp" rel="nofollow noopener noreferrer"><img src="https://barro.gitlab.io/osm-diary-files/kartoituskauden-2024-tuloksia/kaisantunnelin-pyöräparkki.webp" alt="Kaksikerrostelineitä kolmessa rivissä." title="Kaksikerrostelineitä kolmessa rivissä." width="840" height="273"></a> <figcaption> <a href="#kaisantunnelin-pyöräparkki" rel="nofollow noopener noreferrer">Kuva 1</a>: Satoja kaksikerrostelineitä Kaisantunnelin pyörätallissa. </figcaption> </figure> <p>Kaksikerrostelineitä (esimerkki <a href="#kaisantunnelin-pyöräparkki" rel="nofollow noopener noreferrer">kuvassa 1</a>) on lähdetty hankkimaan juna-asemille oikein urakalla. Näissä on samat ongelmat käytön suhteen kuin kiekonväännintelineissä, mutta niiden määrät tulee kuitenkin kirjattua kartalle. Helsingin kaupunki on lisäksi saanut valtiolta avustusta juna-asemien pyöräpysäköinnin parantamiseksi, joka on toteutettu isoilta osin näitä kaksikerrostelineitä, runkolukittavia pyörätelineitä ja laatikkopyörille suunnattuja telineitä käyttäen.</p> <figure id="laatikkopyöräteline"> <a href="https://barro.gitlab.io/osm-diary-files/kartoituskauden-2024-tuloksia/laatikkopyöräteline.webp" rel="nofollow noopener noreferrer"><img src="https://barro.gitlab.io/osm-diary-files/kartoituskauden-2024-tuloksia/laatikkopyöräteline.webp" alt="Laatikkopyörille tarkoitettu teline tavallisemmille pyörille suunnattujen telineiden vieressä." title="Laatikkopyörille tarkoitettu teline tavallisemmille pyörille suunnattujen telineiden vieressä." width="840" height="345"></a> <figcaption> <a href="#laatikkopyöräteline" rel="nofollow noopener noreferrer">Kuva 2</a>: Laatikkopyörille tarkoitettu pyöräteline Huopalahden juna-asemalla. </figcaption> </figure> <p>Rahtipyörille suunnattuja telinetyyppejä on alkanut löytymään muutamilta juna-asemilta. Esimerkki tällaisesta on Huopalahden asemalta <a href="#laatikkopyöräteline" rel="nofollow noopener noreferrer">kuvassa 2</a>, jossa tyypillisempien runkolukittavien telineiden lisäksi löytyy myös tällainen laatikkopyörille tarkoitettu teline.</p> <figure id="katettu-kiekonväännin"> <a href="https://barro.gitlab.io/osm-diary-files/kartoituskauden-2024-tuloksia/katettu-kiekonväännin.webp" rel="nofollow noopener noreferrer"><img src="https://barro.gitlab.io/osm-diary-files/kartoituskauden-2024-tuloksia/katettu-kiekonväännin.webp" alt="Viisipaikkainen kiekonväänninpyöräteline katoksen alla päiväkodin piha-aidan ulkopuolella. Katoksessa tilaa myös lastenvaunuille." title="Viisipaikkainen kiekonväänninpyöräteline katoksen alla päiväkodin piha-aidan ulkopuolella. Katoksessa tilaa myös lastenvaunuille." width="840" height="427"></a> <figcaption> <a href="#katettu-kiekonväännin" rel="nofollow noopener noreferrer">Kuva 3</a>: Katettu kiekonväännintyyppinen pyöräteline päiväkodin vieressä. </figcaption> </figure> <p>Päiväkotien, koulujen ja muiden oppilaitosten pyöräpysäköinnistä tuli tehtyä vähän isompi urakka. Siinä tuli todettua, että erityisesti <a href="https://www.openstreetmap.org/user/Barro/diary/405617" rel="nofollow noopener noreferrer">päiväkotien pyöräpysäköintitilanne on huono</a>. <a href="#katettu-kiekonväännin" rel="nofollow noopener noreferrer">Kuvassa 3</a> on esimerkki yhdentyyppisestä heikohkonpuoleisesta telineratkaisusta päiväkodin edustalla.</p> <h1 id="pyrpyskintimrien-kehitys">Pyöräpysäköintimäärien kehitys</h1> <p>Pyöräpysäköintimäärien kehitys OpenStreetMapin datassa on ollut vuoden 2024 kartoituskaudella ollut voimakkaan nousujohteista. Talven jäljiltä kun lähdin käymään paikkamääräpuutteisia pyöräpysäköintialueita läpi, niin tämä antoi hyvän pohjan viimevuotisen datan päälle täydentämiselle (<a href="#puuttuu-määrät" rel="nofollow noopener noreferrer">kuva 4</a>).</p> <figure id="puuttuu-määrät"> <a href="https://barro.gitlab.io/osm-diary-files/kartoituskauden-2024-tuloksia/puuttuu-määrät-20210101-20241125.webp" rel="nofollow noopener noreferrer"><img src="https://barro.gitlab.io/osm-diary-files/kartoituskauden-2024-tuloksia/puuttuu-määrät-20210101-20241125.webp" alt="Kuvaaja, josta näkyy paikkamääräpuutteisten pyöräpysäköintialueiden lukumäärä ajan saatossa tarkastelualueella." title="Kuvaaja, josta näkyy paikkamääräpuutteisten pyöräpysäköintialueiden lukumäärä ajan saatossa tarkastelualueella." width="840" height="403"></a> <figcaption> <a href="#puuttuu-määrät" rel="nofollow noopener noreferrer">Kuva 4</a>: Paikkamääräpuutteellisten pyöräpysäköintialueiden määrä OpenStreetMapin tietokannassa vuodesta 2021 lähtien tarkastelualueella. </figcaption> </figure> <p><a href="#puuttuu-määrät" rel="nofollow noopener noreferrer">Kuvan 4</a> kuvaajasta näkyy, että OpenStreetMapin dataan on tullut talven mittaan muiden kartoittajien ansiosta pyöräparkkeja tasaista tahtia, joita sitten lämmenneiden säiden myötä sai täydennettyä tiedoiltaan kattavammaksi.</p> <figure id="pyöräparkit-määrät"> <a href="https://barro.gitlab.io/osm-diary-files/kartoituskauden-2024-tuloksia/pyöräparkit-määrät-20210101-20241125.webp" rel="nofollow noopener noreferrer"><img src="https://barro.gitlab.io/osm-diary-files/kartoituskauden-2024-tuloksia/pyöräparkit-määrät-20210101-20241125.webp" alt="5 yleisimmän pyöräpysäköintipaikkatyypin paikkojen määrän kehitys ajan saatossa tarkastelualueella." title="5 yleisimmän pyöräpysäköintipaikkatyypin paikkojen määrän kehitys ajan saatossa tarkastelualueella." width="840" height="403"></a> <figcaption> <a href="#pyöräparkit-määrät" rel="nofollow noopener noreferrer">Kuva 5</a>: Pyöräpysäköintipaikkojen kehitys telinetyypeittäin vuodesta 2021 OpenStreetMapin tietokannassa tarkastelualueella. </figcaption> </figure> <p><a href="#pyöräparkit-määrät" rel="nofollow noopener noreferrer">Kuvassa 5</a> näkyy kehitys sen suhteen, että miten <a href="https://wiki.openstreetmap.org/wiki/Key:bicycle_parking" rel="nofollow noopener noreferrer">eri tyyyppisten pyöräpysäköintipaikkojen määrä on kehittynyt ajan myötä</a>. Epäilen, että <a href="https://wiki.openstreetmap.org/wiki/Tag:bicycle_parking%3Dsafe_loops" rel="nofollow noopener noreferrer"><em>safe_loops</em></a>-tunnisteella olevat runkolukituksen tarjoavat kiekonväännintyyppiset pyörätelineet ovat merkittävästi yleistyneet datassa. Todennäköisesti datan keräämisen ja keräämisen laadun paranemisen seurauksena. <a href="https://wiki.openstreetmap.org/wiki/File:Bicis_a_l%27estaci%C3%B3_de_Leiden.JPG" rel="nofollow noopener noreferrer"><em>two-tier</em></a>-tunnisteella olevat kaksikerroksiset kiekonväännintyyppiset pyörätelineet ovat pääasiassa lisääntyneet sen takia, että niitä on alkanut ilmestymään merkittäviä määriä juna-asemille.</p> <h1 id="loppupohdintoja">Loppupohdintoja</h1> <p>Runkolukittavia telineitä alkaa olla sellainen määrä pääkaupunkiseudulla OpenStreetMapin tietokannassa, että olen voinut omilla reissuillani jo muutamaan otteeseen hyödyntää aikaisemmin tehtyjä kartoituksia. Eli ainakin omassa käytössäni tästä tehdystä työstä alkaa hiljalleen olla yllättävää hyötyä. Pitää vain toivoa, että pääkaupunkiseudun julkiset ja yksityiset toimijat alkaa korvaamaan olemassaolevia heikkolaatuisia telineitään monikäyttöisemmillä runkolukittavilla telineillä. Jotta jossain vaiheessa voisi vain mennä pyörällä uusiin paikkoihin ilman, että tarvitsee turvautua OpenStreetMapin dataan löytääkseen pätevän paikan pyörällensä.</p> </div> <nav class='secondary-actions'> <ul class='clearfix'> <li><a href="/user/Barro/diary/405682#newcomment">Comment on this entry</a></li> <li><a href="/message/new/Barro?message%5Btitle%5D=Re%3A+Py%C3%B6r%C3%A4pys%C3%A4k%C3%B6intipaikkojen+kartoituskauden+2024+tuloksia">Send a message to the author</a></li> <li> <a href="/user/Barro/diary/405682#comments">No comments</a> </li> </ul> </nav> </article> <article class='diary_post border-top border-secondary-subtle py-3 user_526776'> <div class='mb-3'> <div class="row"> <div class="col-auto"> <img class="user_thumbnail border border-secondary-subtle bg-body" alt="" width="50" height="50" src="/assets/avatar-c143fe593788b7de19f84df0a6ffd4433400bf343af670feface7cbfb13e67e6.svg" /> </div> <div class="col"> <h2><a href="/user/Graeme%20Herbert/diary/405681">Big River and A Slow Boat To Belém </a></h2> </div> </div> <small class='text-body-secondary'> Posted by <a href="/user/Graeme%20Herbert">Graeme Herbert</a> on 26 November 2024 in <a href="/diary/en">English</a>. </small> </div> <div class="richtext text-break" xml:lang="en" lang="en"> <h1 id="tabatinga-to-manaus-3">Tabatinga To Manaus 3</h1> <p>By day 3 on the Manaus boat I was beginning to doubt that we might get there the next day. It seemed the boat was moving too slowly, we were tracking the route and there was a lot of river still before Manaus.</p> <p>What we didn’t know is that the boat stops less on the second half of the journey, I guess because many of the places further downstream have their own services to Manaus. It did stop briefly in the river a couple of times just to let people off onto a smaller boat that was waiting.</p> <p>The main event of the third day was a fairly thorough police check of the boat. I was fast asleep in my hammock when It happened, men had to line up on one side of the deck, women on the other. All baggage was also lined up in the middle so they could pass the sniffer dog by everything. We were stopped about an hour for this, it’s quite a routine thing on public transport here, I was told.</p> <p>By day 4 people had been asking the crew when we were like to arrive and It all seemed good with the estimates for arrival in the evening. I really didn’t want to arrive in Manaus in the middle of the night. I enjoyed the experience of the first hammock boat but four days is long enough to go without a decent night”s sleep.</p> <p>After what seemed like an eternal circuit on the approach to the city we finally docked on the Río Negro. An atmospheric walk up from the port to a hotel with a proper bed and a nearby bar with good live music and cold beer. I felt I deserved It.</p> </div> Location: <a href="/#map=14/-3.132060216003923/-59.996337890625"><abbr class="geo" title="-3.1321; -59.9963">Betânia, Manaus, Região Geográfica Imediata de Manaus, Região Geográfica Intermediária de Manaus, Amazonas, North Region, 69000-000, Brazil</abbr></a> <nav class='secondary-actions'> <ul class='clearfix'> <li><a href="/user/Graeme%20Herbert/diary/405681#newcomment">Comment on this entry</a></li> <li><a href="/message/new/Graeme%20Herbert?message%5Btitle%5D=Re%3A+Big+River+and+A+Slow+Boat+To+Bel%C3%A9m+">Send a message to the author</a></li> <li> <a href="/user/Graeme%20Herbert/diary/405681#comments">No comments</a> </li> </ul> </nav> </article> <article class='diary_post border-top border-secondary-subtle py-3 user_13330486'> <div class='mb-3'> <div class="row"> <div class="col-auto"> <img class="user_thumbnail border border-secondary-subtle bg-body" alt="" width="50" height="50" src="https://www.openstreetmap.org/rails/active_storage/representations/redirect/eyJfcmFpbHMiOnsiZGF0YSI6MzQwOTI1MDIsInB1ciI6ImJsb2JfaWQifX0=--4c533b1548b4997fe907d7775fea7f24fce6d352/eyJfcmFpbHMiOnsiZGF0YSI6eyJmb3JtYXQiOiJwbmciLCJyZXNpemVfdG9fbGltaXQiOls1MCw1MF19LCJwdXIiOiJ2YXJpYXRpb24ifX0=--69b5827195f9b93bf8f2c405f6a463393e56b9e5/raquel_pq.png" /> </div> <div class="col"> <h2><a href="/user/Raquel%20Dezid%C3%A9rio%20Souto/diary/405675">Oficina OpenStreetMap e uMap para a JGEOTEC 2024 - Rio de Janeiro - Brasil </a></h2> </div> </div> <small class='text-body-secondary'> Posted by <a href="/user/Raquel%20Dezid%C3%A9rio%20Souto">Raquel Dezidério Souto</a> on 25 November 2024 in <a href="/diary/pt-BR">Brazilian Portuguese (Português do Brasil)</a>. </small> </div> <div class="richtext text-break" xml:lang="pt-BR" lang="pt-BR"> <h3 id="ividesorg-promoveu-oficina-de-mapeamento-colaborativo-com-openstreetmap-e-criao-de-mapa-web-com-umap">IVIDES.org promoveu oficina de mapeamento colaborativo com OpenStreetMap e criação de mapa Web com uMap</h3> <p>A oficina foi ministrada pela Dra. Raquel Dezidério Souto, presidenta do <strong>IVIDES.org</strong>, instituto virtual de pesquisa que, há 18 anos, tem se dedicado a disseminar conhecimento livre e trocar informações sobre temáticas relacionadas ao desenvolvimento sustentável (na visão de I. Sachs). A oficina faz parte da programação da VII Jornada de Geotecnologias do Estado do Rio de Janeiro - VII JGEOTEC e contou com recursos do IVIDES DATA e parceria com o Laboratório GeoCart-UFRJ.</p> <p>Esta atividade corresponde à última, das <strong>17 oficinas celebradas pelo IVIDES.org, somente em 2024</strong>, em cooperação com muitos atores importantes no Brasil, em países da América do Norte (como o México, neste ano) e países da África lusófona (como Moçambique, neste ano), de universidades federais, grupos YouthMappers (orientação para a criação de novos grupos e treinamento de grupos já existentes).</p> <p>No vídeo, em português, são apresentados:</p> <ul> <li> <p>Conceitos iniciais sobre mapeamento colaborativo, de modo geral;</p> </li> <li> <p>OpenStreetMap - modelo de dados, editores, APPs, plugins para QGIS;</p> </li> <li> <p>uMap - detalhamento da configuração geral do mapa e configurações específicas para camadas; dicas de design para favorecer o carregamento do mapa; treinamento com dados do Censo Demográfico do Brasil de 2022, demonstração sobre importação de dados para gerar camada estática; e criação de camada dinâmica, a partir de consulta com Overpass Turbo.</p> </li> </ul> <p><strong>Vídeo gravado da Live</strong></p> <p><a href="https://www.youtube.com/live/5w21smhYN1k" rel="nofollow noopener noreferrer">https://www.youtube.com/live/5w21smhYN1k</a></p> <p><a href="https://drive.google.com/drive/folders/1SxBtnyymkRgxJivOgyZtJUyJsKzDtxZ9?usp=sharing" rel="nofollow noopener noreferrer">Material para treinamento</a></p> <p>Para entrar em contato, favor enviar mensagem para: <a href="mailto:ivides@ivides.org" rel="nofollow noopener noreferrer">ivides@ivides.org</a></p> <hr> <p>IVIDES.org® é uma marca registrada.</p> <p>IVIDES DATA é uma empresa de pequeno porte, sediada no Rio de Janeiro, de consultoria em tecnologia da informação.</p> <p>GeoCart - Laboratório de Cartografia da Universidade Federal do Rio de Janeiro (Brasil).</p> <hr> <p><img src="https://ivides.org/wp-content/uploads/2023/09/logo_ivides_reg_md-300x263.png" alt="IVIDES_logo"></p> </div> Location: <a href="/#map=14/-22.855929240558694/-43.23094367980958"><abbr class="geo" title="-22.8559; -43.2309">Cidade Universitária, Rio de Janeiro, Região Geográfica Imediata do Rio de Janeiro, Região Metropolitana do Rio de Janeiro, Região Geográfica Intermediária do Rio de Janeiro, Rio de Janeiro, Região Sudeste, Brasil</abbr></a> <nav class='secondary-actions'> <ul class='clearfix'> <li><a href="/user/Raquel%20Dezid%C3%A9rio%20Souto/diary/405675#newcomment">Comment on this entry</a></li> <li><a href="/message/new/Raquel%20Dezid%C3%A9rio%20Souto?message%5Btitle%5D=Re%3A+Oficina+OpenStreetMap+e+uMap+para+a+JGEOTEC+2024+-+Rio+de+Janeiro+-+Brasil+">Send a message to the author</a></li> <li> <a href="/user/Raquel%20Dezid%C3%A9rio%20Souto/diary/405675#comments">No comments</a> </li> </ul> </nav> </article> <article class='diary_post border-top border-secondary-subtle py-3 user_526776'> <div class='mb-3'> <div class="row"> <div class="col-auto"> <img class="user_thumbnail border border-secondary-subtle bg-body" alt="" width="50" height="50" src="/assets/avatar-c143fe593788b7de19f84df0a6ffd4433400bf343af670feface7cbfb13e67e6.svg" /> </div> <div class="col"> <h2><a href="/user/Graeme%20Herbert/diary/405673">Big River and A Slow Boat To Belém </a></h2> </div> </div> <small class='text-body-secondary'> Posted by <a href="/user/Graeme%20Herbert">Graeme Herbert</a> on 25 November 2024 in <a href="/diary/en">English</a>. </small> </div> <div class="richtext text-break" xml:lang="en" lang="en"> <h1 id="tabatinga-to-manaus-2">Tabatinga To Manaus 2</h1> <p>Sleeping solidly is not that simple, the boat can stop at any time of night, and it turns out the range of comfortable sleeping positions in a hammock is not that big. But it doesn’t matter, the only schedule on board revolves around meal times, there’s nothing else to prevent anyone from resting when they feel like it. It can also be surprisingly cold on the open boat at night. I came prepared with a thin blanket and it’s not unusual to feel the need for a cover during the night. The first night there was also a distraction, a spectacular lightning display in the distance.</p> <p>Day 2 started with our early breakfast, a ham roll and a cup of ridiculously sweet coffee. If there is one thing I really dislike in Brazil it is this custom where the people who make the coffee decide how much sugar the person who drinks the coffee is going to want. It’s always a lot, obviously there is a major sugar cane surplus. I managed to get some progress done on my diary entries and then it was river watching as a big rain storm moved in whilst the boat was ar one of the stops. In 20 minutes water was pouring down all the slopes towards the port. A small creek under a wooden bridge transformed into a torrent. All water still welcome in tbe Amazon, looking at the banks of the river I reckon there is room in the river for 8-10 metres more of water.</p> <p>Bit by but you get to know other passengers, all watching the river from the best viewpoint next to the bar with no beer. Colombia, Perú, New Zealand, the US , and Italy were all represented in addition to the Brazilian locals.</p> </div> Location: <a href="/#map=14/-2.468298979301348/-65.38925170898439"><abbr class="geo" title="-2.4683; -65.3893">Juruá, Região Geográfica Imediata de Tefé, Região Geográfica Intermediária de Tefé, Amazonas, North Region, Brazil</abbr></a> <nav class='secondary-actions'> <ul class='clearfix'> <li><a href="/user/Graeme%20Herbert/diary/405673#newcomment">Comment on this entry</a></li> <li><a href="/message/new/Graeme%20Herbert?message%5Btitle%5D=Re%3A+Big+River+and+A+Slow+Boat+To+Bel%C3%A9m+">Send a message to the author</a></li> <li> <a href="/user/Graeme%20Herbert/diary/405673#comments">No comments</a> </li> </ul> </nav> </article> <article class='diary_post border-top border-secondary-subtle py-3 user_3818858'> <div class='mb-3'> <div class="row"> <div class="col-auto"> <img class="user_thumbnail border border-secondary-subtle bg-body" alt="" width="50" height="50" src="https://www.openstreetmap.org/rails/active_storage/representations/redirect/eyJfcmFpbHMiOnsiZGF0YSI6MzM1MzAyLCJwdXIiOiJibG9iX2lkIn19--39cbb6253f3949e3e0ab725e86a81eafd22cea48/eyJfcmFpbHMiOnsiZGF0YSI6eyJmb3JtYXQiOiJqcGciLCJyZXNpemVfdG9fbGltaXQiOls1MCw1MF19LCJwdXIiOiJ2YXJpYXRpb24ifX0=--dea07cf4fabdae9c56d9008d879a5332bbf580ce/Pieter2Cropped.jpg" /> </div> <div class="col"> <h2><a href="/user/Pieter%20Vander%20Vennet/diary/405672">Press attention for the surveillance camera walk</a></h2> </div> </div> <small class='text-body-secondary'> Posted by <a href="/user/Pieter%20Vander%20Vennet">Pieter Vander Vennet</a> on 25 November 2024 in <a href="/diary/en">English</a>. Last updated on 26 November 2024. </small> </div> <div class="richtext text-break" xml:lang="en" lang="en"> <p>In the past weekend, I did (two) walks in Ghent where we used <a href="https://mapcomplete.org/surveillance" rel="nofollow noopener noreferrer">https://mapcomplete.org/surveillance</a> to spot surveillance cameras. The press was interested as well, resulting in some interviews and articles!</p> <p>Those are in Dutch of course.</p> <p>The local TV did a decent job: <a href="https://avs.be/nieuws/openstreetmap-vrijwilligers-brengen-cameras-in-gent-in-kaart" rel="nofollow noopener noreferrer">https://avs.be/nieuws/openstreetmap-vrijwilligers-brengen-cameras-in-gent-in-kaart</a></p> <p>The newspaper article: <a href="https://www.hln.be/gent/vrijwilligers-trekken-door-gentse-straten-om-alle-cameras-in-kaart-te-brengen-een-half-miljoen-hangen-er-in-dit-land-maar-niemand-weet-exact-waar~a8b9341c/" rel="nofollow noopener noreferrer">https://www.hln.be/gent/vrijwilligers-trekken-door-gentse-straten-om-alle-cameras-in-kaart-te-brengen-een-half-miljoen-hangen-er-in-dit-land-maar-niemand-weet-exact-waar~a8b9341c/</a> which isn’t to bad as well (paywalled, without paywall: <a href="https://archive.ph/4GUZQ" rel="nofollow noopener noreferrer">https://archive.ph/4GUZQ</a>)</p> <p>And on VTM: <a href="https://www.vtmgo.be/vtmgo/afspelen/e9e73a3b-b932-400a-91b9-af78622cbbaf" rel="nofollow noopener noreferrer">https://www.vtmgo.be/vtmgo/afspelen/e9e73a3b-b932-400a-91b9-af78622cbbaf</a> (starting at 20:30, account required; I wasn’t able to rip it)</p> <p>(If you don’t want to create an account, you can also find them <a href="https://pietervdvn.duckdns.org/sharing/6dmSbV2AV" rel="nofollow noopener noreferrer">on my NAS</a>)</p> </div> Location: <a href="/#map=14/51.0490943200061/3.7287855148315434"><abbr class="geo" title="51.0491; 3.7288">9000, Ghent, Gent, East Flanders, Flanders, Belgium</abbr></a> <nav class='secondary-actions'> <ul class='clearfix'> <li><a href="/user/Pieter%20Vander%20Vennet/diary/405672#newcomment">Comment on this entry</a></li> <li><a href="/message/new/Pieter%20Vander%20Vennet?message%5Btitle%5D=Re%3A+Press+attention+for+the+surveillance+camera+walk">Send a message to the author</a></li> <li> <a href="/user/Pieter%20Vander%20Vennet/diary/405672#comments">No comments</a> </li> </ul> </nav> </article> <article class='diary_post border-top border-secondary-subtle py-3 user_15215305'> <div class='mb-3'> <div class="row"> <div class="col-auto"> <img class="user_thumbnail border border-secondary-subtle bg-body" alt="" width="50" height="50" src="https://www.openstreetmap.org/rails/active_storage/representations/redirect/eyJfcmFpbHMiOnsiZGF0YSI6MzI5NjUwMjMsInB1ciI6ImJsb2JfaWQifX0=--3e95d50f123d0046fbd13fe537d38d67aeb3e7e2/eyJfcmFpbHMiOnsiZGF0YSI6eyJmb3JtYXQiOiJwbmciLCJyZXNpemVfdG9fbGltaXQiOls1MCw1MF19LCJwdXIiOiJ2YXJpYXRpb24ifX0=--69b5827195f9b93bf8f2c405f6a463393e56b9e5/DALL%C2%B7E%202023-10-14%2020.29.20%20-%20Cartoon-style%20image%20of%20a%20radiant%20orange%20crab%20joyfully%20standing%20on%20a%20map.%20The%20map%20is%20spread%20out%20on%20a%20rustic%20dark%20wood%20table,%20giving%20off%20a%20homey%20and%20com.png" /> </div> <div class="col"> <h2><a href="/user/NorthCrab/diary/405668">OpenStreetMap NextGen Development Diary #21 — User Diaries</a></h2> </div> </div> <small class='text-body-secondary'> Posted by <a href="/user/NorthCrab">NorthCrab</a> on 25 November 2024 in <a href="/diary/en">English</a>. </small> </div> <div class="richtext text-break" xml:lang="en" lang="en"> <p>A new week, a new OpenStreetMap-NG development update. This week, we announce the release of two significant features: an overhaul of the User Diaries and the implementation of client-side password hashing.</p> <p>🔖 You can read other development diaries here:<br> <a href="https://www.openstreetmap.org/user/NorthCrab/diary/" rel="nofollow noopener noreferrer">https://www.openstreetmap.org/user/NorthCrab/diary/</a></p> <p>⭐ This project is open-source — <a href="https://github.com/openstreetmap-ng/openstreetmap-ng?tab=readme-ov-file#-contributing" rel="nofollow noopener noreferrer"><strong>join us today</strong></a>:<br> <a href="https://github.com/openstreetmap-ng/openstreetmap-ng" rel="nofollow noopener noreferrer">https://github.com/openstreetmap-ng/openstreetmap-ng</a></p> <p><a href="https://github.com/openstreetmap-ng/openstreetmap-ng" rel="nofollow noopener noreferrer"><img src="https://shields.monicz.dev/github/stars/openstreetmap-ng/openstreetmap-ng?style=social" alt="GitHub Stars"></a></p> <p>🛈 This initiative is not affiliated with the OpenStreetMap Foundation.</p> <hr> <h3 id="video-summary"><strong>Video Summary</strong></h3> <p>Join me for a guided tour of the new functionalities. In this week’s video, I compare OpenStreetMap-NG’s approach with the current implementation, highlighting key improvements in navigation, performance, and user experience.</p> <p><strong>⬇ Click the image below to play</strong></p> <p><a href="https://peertube.monicz.dev/w/3PTAV1rsrb7iJUdSBbUM3n" rel="nofollow noopener noreferrer"><img src="https://img.monicz.dev/-Sabe3fKiVQ" alt="Video thumbnail"></a></p> <p><em>or click here: <a href="https://peertube.monicz.dev/w/3PTAV1rsrb7iJUdSBbUM3n" rel="nofollow noopener noreferrer">https://peertube.monicz.dev/w/3PTAV1rsrb7iJUdSBbUM3n</a></em></p> <hr> <h3 id="user-diaries-interface">User Diaries Interface</h3> <p>The User Diaries section has undergone a significant redesign to improve navigation and usability. Key enhancements include:</p> <ul> <li><strong>Sidebar Navigation:</strong> A new sidebar allows users to quickly access and keep track of articles, eliminating the need for excessive scrolling.</li> <li><strong>Faster Page Loads:</strong> Lazy image loading has been implemented, resulting in User Diary pages loading up to 5 times faster compared to the OSM-Ruby implementation.</li> <li><strong>Localized Date Formatting:</strong> Website dates and times are now displayed in the user’s local format, ensuring a consistent experience for our global community.</li> <li><strong>Comment Indicators:</strong> Articles with active discussions are now easily identifiable through the addition of comment indicators.</li> <li><strong>Improved Editing Tools:</strong> The diary editing interface has been streamlined, with the ability to remove location data with a single click, providing a more intuitive user experience.</li> </ul> <p><a href="https://peertube.monicz.dev/w/3PTAV1rsrb7iJUdSBbUM3n?start=26s" rel="nofollow noopener noreferrer"><strong>▶️ Watch video segment</strong></a></p> <h3 id="client-side-password-hashing">Client-Side Password Hashing</h3> <p>We have implemented hybrid client-side password hashing, adding an extra layer of protection for user accounts while making the server even more lightweight to run.</p> <ul> <li><strong>Hybrid Approach:</strong> Passwords are now hashed twice, first on the client-side using PBKDF2, followed by a second hashing on the server-side with Argon2 (the same algorithm as currently). While the total amount of work required increases, the server shares this work with the client, making it more scalable for the future.</li> <li><strong>Accidental Leak Prevention:</strong> Client-side hashing ensures that even if a password is accidentally logged, it will never be exposed in clear text, safeguarding sensitive user data.</li> <li><strong>Domain-Bound Hashes:</strong> Each password hash is uniquely tied to the specific OSM-NG domain, preventing password correlation across different deployments, such as production and testing environments.</li> </ul> <p><a href="https://peertube.monicz.dev/w/3PTAV1rsrb7iJUdSBbUM3n?start=11m36s" rel="nofollow noopener noreferrer"><strong>▶️ Watch video segment</strong></a></p> <hr> <h3 id="sponsors"><strong>Sponsors</strong></h3> <p>This update was sponsored by 16 amazing people.<br> 8 donors on <a href="https://liberapay.com/Zaczero" rel="nofollow noopener noreferrer"><strong>Liberapay</strong></a>, and 8 on <a href="https://github.com/sponsors/Zaczero" rel="nofollow noopener noreferrer"><strong>GitHub Sponsors</strong></a>.</p> <p>Thank you, community! We are now closer than ever to the first public release of OpenStreetMap-NG. Right on track with ETA end of 2024. — NC 🦀</p> <ul> <li><a href="https://liberapay.com/~1847430/" rel="nofollow noopener noreferrer"><strong>~1847430</strong></a></li> <li><a href="https://liberapay.com/gileri/" rel="nofollow noopener noreferrer"><strong>gileri (Eric G.)</strong></a></li> <li><a href="https://github.com/mutipg" rel="nofollow noopener noreferrer"><strong>mutipg</strong></a></li> <li><a href="https://github.com/RedAuburn" rel="nofollow noopener noreferrer"><strong>RedAuburn (Harry Bond)</strong></a></li> <li><a href="https://liberapay.com/~1819511/" rel="nofollow noopener noreferrer"><strong>~1819511</strong></a></li> <li><a href="https://github.com/AurimasF" rel="nofollow noopener noreferrer"><strong>AurimasF (Aurimas Fišeras)</strong></a></li> <li><a href="https://liberapay.com/starsep/" rel="nofollow noopener noreferrer"><strong>starsep</strong></a></li> <li><a href="https://github.com/gander" rel="nofollow noopener noreferrer"><strong>gander (Adam Gąsowski)</strong></a></li> <li><a href="https://github.com/owiecc" rel="nofollow noopener noreferrer"><strong>owiecc (Szymon Bęczkowski)</strong></a></li> <li><a href="https://github.com/kkalata" rel="nofollow noopener noreferrer"><strong>kkalata (Kamil Kalata)</strong></a></li> <li><a href="https://github.com/okainov" rel="nofollow noopener noreferrer"><strong>okainov (Oleg Kainov)</strong></a></li> <li><a href="https://github.com/sunsurfr" rel="nofollow noopener noreferrer"><strong>sunsurfr</strong></a></li> </ul> </div> <nav class='secondary-actions'> <ul class='clearfix'> <li><a href="/user/NorthCrab/diary/405668#newcomment">Comment on this entry</a></li> <li><a href="/message/new/NorthCrab?message%5Btitle%5D=Re%3A+OpenStreetMap+NextGen+Development+Diary+%2321+%E2%80%94+User+Diaries">Send a message to the author</a></li> <li> <a href="/user/NorthCrab/diary/405668#comments">No comments</a> </li> </ul> </nav> </article> <article class='diary_post border-top border-secondary-subtle py-3 user_526776'> <div class='mb-3'> <div class="row"> <div class="col-auto"> <img class="user_thumbnail border border-secondary-subtle bg-body" alt="" width="50" height="50" src="/assets/avatar-c143fe593788b7de19f84df0a6ffd4433400bf343af670feface7cbfb13e67e6.svg" /> </div> <div class="col"> <h2><a href="/user/Graeme%20Herbert/diary/405665">Big River and A Slow Boat To Belém </a></h2> </div> </div> <small class='text-body-secondary'> Posted by <a href="/user/Graeme%20Herbert">Graeme Herbert</a> on 24 November 2024 in <a href="/diary/en">English</a>. </small> </div> <div class="richtext text-break" xml:lang="en" lang="en"> <h1 id="the-second-boat--tabatinga-to-manaus">The Second Boat -Tabatinga To Manaus</h1> <p>Departure day from Tabatinga and the start of the real adventure. Be here at 8, they told us when we bought the tickets, so here we were not much after that time, but once the people waiting for the fast boat had left there was just a handful of us. I didn’t mind, the early arrivals get the best hammock space and 4 days is a long time to spend in the wrong spot.</p> <p>Orderly lines of baggage were formed as people took a seat to wait. Then mysterious queues started forming, the first to exchange the paper ticket for a wristband. The second was for a police photo and passport check, if you don’t do this you don’t get on the boat I was told. More people arrived and by scheduled departure time at 12 the two queues were still being processed. Finally the doors opened and off we went up to the top deck of the F/B Diamante. Picking a spot near a window we tested our hammocks for size, it turned out that I was almost touching the floor until I knotted both ends. No need for the extra rope here.</p> <p>We left in the end a couple of hours late, but our deck was nowhere near full and the space we had chosen seemed good for views and air. There was something missing on the boat though. Searching for a celebratory beer to mark the start of the hammock days we found a snack bar at the top of the boat that had no beer. Suddenly 4 days seemed like a very long time.</p> <p>Then there were the meal times that would be challenging even for northern Europeans, breakfast at 6:30, lunch starting at 10:30 and dinner at 5pm. But we had our sleeping and resting position set, spaces up front and at the back for river watching and life was good. We had managed to get 2 Brazilian SIM cards the day before, but we discovered that these would really only work well when the boat stopped somewhere.</p> <p>Dinner time came around and we had a chance to sample the unexciting cuisine on board. Stewed beef with some beans and rice set the tone for the coming days. But it’s included in the ticket price, it’s edible and there will be time ahead for better meals. And then before dark another fabulous river sunset behind us to match the one we saw coming down from Iquitos.</p> <p>On this kind of voyage you start to test the reality against what you had imagined it might be like. I had thought that I wouldn”t worry about when I slept because I could lie awake at night listening to the sounds of the forest. No. The sound you hear day and night is the boat’s engine. Then there is the doubt about how much you can see from the boat when it is sailing down the middle of such a big river. The reality here is that you do see quite a bit, the boat rarely steers the middle course, at least in the upper Amazon. There are numerous islands and sandbanks so much of the time you are not even seeing the full width of the river. And in the stops you see the local towns.</p> <p>You dont’t see a lot of wildlife, fleeting glimpses of the Amazonian pink dolphins as they surface for a second or two and a selection of river birds. Thankfully there was also a very limited presence of unwanted wildlife, mosquitoes are only a potential problem when the boat stops, out on the river with the breeze they are virtually absent. In short I never felt bored or that time dragged. Obviously finger typing this diary on a tablet also takes a while.</p> </div> Location: <a href="/#map=14/-3.408441675670024/-68.50799560546876"><abbr class="geo" title="-3.4084; -68.5080">Amaturá, Região Geográfica Imediata de Tabatinga, Região Geográfica Intermediária de Tefé, Amazonas, North Region, 69620-000, Brazil</abbr></a> <nav class='secondary-actions'> <ul class='clearfix'> <li><a href="/user/Graeme%20Herbert/diary/405665#newcomment">Comment on this entry</a></li> <li><a href="/message/new/Graeme%20Herbert?message%5Btitle%5D=Re%3A+Big+River+and+A+Slow+Boat+To+Bel%C3%A9m+">Send a message to the author</a></li> <li> <a href="/user/Graeme%20Herbert/diary/405665#comments">No comments</a> </li> </ul> </nav> </article> <article class='diary_post border-top border-secondary-subtle py-3 user_526776'> <div class='mb-3'> <div class="row"> <div class="col-auto"> <img class="user_thumbnail border border-secondary-subtle bg-body" alt="" width="50" height="50" src="/assets/avatar-c143fe593788b7de19f84df0a6ffd4433400bf343af670feface7cbfb13e67e6.svg" /> </div> <div class="col"> <h2><a href="/user/Graeme%20Herbert/diary/405664">Big River and A Slow Boat To Belém </a></h2> </div> </div> <small class='text-body-secondary'> Posted by <a href="/user/Graeme%20Herbert">Graeme Herbert</a> on 24 November 2024 in <a href="/diary/en">English</a>. </small> </div> <div class="richtext text-break" xml:lang="en" lang="en"> <h1 id="the-triple-frontier-3">The Triple Frontier 3</h1> <p>Monday was a list of things to do, the last day before departure for Manaus. Priority number one was to move from a hostel too far away from the crossing into Tabatinga to one that was almost on the frontier, a pillar 10 metres away from our rooms marked the boundary. A brief stop for breakfast and down to Tabatinga port to buy our boat tickets, again checking out hammocks on the way.</p> <p>On the way back, boat tickets bought, we found the hammocks we would need as a bed for much of the following two weeks. I didn’t want to go for the cheapest, I was looking for one that hopefully wouldn”t break and leave me sleeping on the deck. This time, unlike my previous attempt so many years before, it felt like the hammock and boat experience was really going to happen. I won’t pretend I didn’t feel nervous. We also bought cutlery, bowls and cups for the journey. Back in Leticia it was down to the market looking for rope, useful to either extend the hammock if needed or to secure luggage. A decent dinner in Leticia was needed, we didn’t have high hopes about the food we would be eating for the next four days. Writing in hindsight we were right about that.</p> </div> Location: <a href="/#map=14/-4.218782583457551/-69.93332147598268"><abbr class="geo" title="-4.2188; -69.9333">Barrio Colombia, Leticia, Amazonas, RAP Amazonía, 910001, Colombia</abbr></a> <nav class='secondary-actions'> <ul class='clearfix'> <li><a href="/user/Graeme%20Herbert/diary/405664#newcomment">Comment on this entry</a></li> <li><a href="/message/new/Graeme%20Herbert?message%5Btitle%5D=Re%3A+Big+River+and+A+Slow+Boat+To+Bel%C3%A9m+">Send a message to the author</a></li> <li> <a href="/user/Graeme%20Herbert/diary/405664#comments">No comments</a> </li> </ul> </nav> </article> <article class='diary_post border-top border-secondary-subtle py-3 user_526776'> <div class='mb-3'> <div class="row"> <div class="col-auto"> <img class="user_thumbnail border border-secondary-subtle bg-body" alt="" width="50" height="50" src="/assets/avatar-c143fe593788b7de19f84df0a6ffd4433400bf343af670feface7cbfb13e67e6.svg" /> </div> <div class="col"> <h2><a href="/user/Graeme%20Herbert/diary/405663">Big River and A Slow Boat To Belém </a></h2> </div> </div> <small class='text-body-secondary'> Posted by <a href="/user/Graeme%20Herbert">Graeme Herbert</a> on 24 November 2024 in <a href="/diary/en">English</a>. </small> </div> <div class="richtext text-break" xml:lang="en" lang="en"> <h1 id="the-triple-frontier-2">The Triple Frontier 2</h1> <p>Day two in Leticia began with another visit to Tabatinga. It was Sunday and the boat ticket office wasn’t going to be open, but we did need to get our Brazilian entry stamp in our passports, we weren’t going to get on the next boat without that. Remote land borders can often be more difficult to cross than arriving at international airports, but we had no problems here - a couple of questions about the purpose of our visit and it was done.</p> <p>With the rest of the day free we went back to Leticia and got on a boat to Santa Rosa for the last time on Peruvian territory on this journey. Johnattan was carrying a small drone, and we wanted to do a bit of drone and street level mapping of the island. All of the main points of interest on Santa Rosa are concentrated on a single road, so we mapped our way up from the clutch of restaurants facing Leticia to a midpoint in the village and decided that the heat merited a refreshment stop in a friendly and spacious bar restaurant.</p> <p>This restaurant became the base for an attempt at drone mapping Santa Rosa, but there was an unexpected problem. Both Tabatinga and Leticia have airports, and as Johnattan attempted to get the drone to fly at a decent height we realized that the drone exclusion area for these airports covered almost all of Santa Rosa.It was not going to happen, so we sat down for lunch - an Amazon river fish ceviche - and then finished our ground level mapping of the main street. Before the trip I had looked at Santa Rosa as a possible place to stay and decided there just wasn’t much there. But in fact it’s not a bad option if what you like is a quiet laid-back atmosphere with a backpacker traveller feel to it.There’s a handful of places to stay and enough bars and restaurants in support. And most of them are now mapped!</p> <p>We headed out quite early for dinner in Leticia, the objective being a slightly fancier and more touristy restaurant we had seen. its pretty quiet on the triple frontier in mid-November, most places don’t stay open very late. But the rain came again, hard and fast - we had no choice but to take refuge for an hour in a nearby bar. Dinner for me was more river fish, <a href="https://en.m.wikipedia.org/wiki/Tambaqui" rel="nofollow noopener noreferrer">gamitana</a> this time - taking the chance to try things I may never see again. A walk back to the hostel and a relatively early night, the next day was going to be busy.</p> </div> Location: <a href="/#map=14/-4.226142204609106/-69.95784759521486"><abbr class="geo" title="-4.2261; -69.9578">Mario Rivera, Yavari, Province of Mariscal Ramón Castilla, Loreto, Peru</abbr></a> <nav class='secondary-actions'> <ul class='clearfix'> <li><a href="/user/Graeme%20Herbert/diary/405663#newcomment">Comment on this entry</a></li> <li><a href="/message/new/Graeme%20Herbert?message%5Btitle%5D=Re%3A+Big+River+and+A+Slow+Boat+To+Bel%C3%A9m+">Send a message to the author</a></li> <li> <a href="/user/Graeme%20Herbert/diary/405663#comments">No comments</a> </li> </ul> </nav> </article> <article class='diary_post border-top border-secondary-subtle py-3 user_526776'> <div class='mb-3'> <div class="row"> <div class="col-auto"> <img class="user_thumbnail border border-secondary-subtle bg-body" alt="" width="50" height="50" src="/assets/avatar-c143fe593788b7de19f84df0a6ffd4433400bf343af670feface7cbfb13e67e6.svg" /> </div> <div class="col"> <h2><a href="/user/Graeme%20Herbert/diary/405662">Big River and A Slow Boat To Belém </a></h2> </div> </div> <small class='text-body-secondary'> Posted by <a href="/user/Graeme%20Herbert">Graeme Herbert</a> on 24 November 2024 in <a href="/diary/en">English</a>. </small> </div> <div class="richtext text-break" xml:lang="en" lang="en"> <h1 id="the-triple-frontier">The Triple Frontier</h1> <p>With an eye on our (OSM powered) maps the first surprise on arrival at Santa Rosa was that we were being dropped off on what appeared on the map to be a separate island. Our moto taxi driver explained the reason for this, the drought that had affected so much of Amazonia had also changed the endpoint for a ferry that had been unable to run a few weeks before our arrival. In reality the two islands shown on the map are currently one, with a dip on the muddy track being the only indicator.</p> <p>The triple frontier is a curious place, there are no formal border control posts, you have to go on arrival from Iquitos to the immigration office in Santa Rosa to get the Peruvian exit stamp, a pre-condition for subsequently getting entry into Colombia or Brazil. We were almost the first ones there at the office and the exit process took about 5 minutes. Then it was down to the boats that take you across to Leticia (in Colombia) or neighbouring Tabatinga (in Brazil). It’s a short crossing, I had read a couple of months earlier that in the worst moments of the drought people were able to cross on foot. That’s no longer the case, but the creek taking us in to Leticia had barely enough water to permit incoming and outgoing boats to get past each other.</p> <p>Although we were landing in Colombia there are still no border formalities, only if you try to go somewhere else in the country outside of Leticia. So we had arrived in Peru, had our hostal accommodation in Colombia, and would be leaving from Brazil. Leticia has much more facilities than Santa Rosa or Tabatinga, it seemed like the best place of the three to stay.</p> <p>The walk to the hostel was longer than we had expected, and with the sun out and carrying all our stuff it was the first time I really felt the Amazonian heat. But we had a relaxing start to the day, on the assumption from our research that we weren’t going to be leaving on the next boat from Tabatinga for at least a couple of days. A tasting of Colombian beers (Poker won first prize from the jury), a walk around the centre and lunch in the market watching the torrential downpour outside that would help restore the river and carry us to Belem. Then with the last of the rain we took a walk into Brazil, Tabatinga adjoins Leticia and there is an arch welcoming you to Brazil but again no further controls.</p> <p>It’s still quite fascinating to see how things change when you cross even an open border like this. We walked through Tabatinga heading for the port and checking out places that sold hammocks, the main essential purchase for our no frills boat to Manaus. Down in the port they confirmed that there was a boat on the day we had expected, but we would have to return to buy the tickets because we still had no Brazilian money. We would have two more full days on the triple frontier. There would of course have to be some time for mapping.</p> </div> Location: <a href="/#map=14/-4.214401018819472/-69.94308471679689"><abbr class="geo" title="-4.2144; -69.9431">Leticia, Amazonas, RAP Amazonía, 910001, Colombia</abbr></a> <nav class='secondary-actions'> <ul class='clearfix'> <li><a href="/user/Graeme%20Herbert/diary/405662#newcomment">Comment on this entry</a></li> <li><a href="/message/new/Graeme%20Herbert?message%5Btitle%5D=Re%3A+Big+River+and+A+Slow+Boat+To+Bel%C3%A9m+">Send a message to the author</a></li> <li> <a href="/user/Graeme%20Herbert/diary/405662#comments">No comments</a> </li> </ul> </nav> </article> <article class='diary_post border-top border-secondary-subtle py-3 user_526776'> <div class='mb-3'> <div class="row"> <div class="col-auto"> <img class="user_thumbnail border border-secondary-subtle bg-body" alt="" width="50" height="50" src="/assets/avatar-c143fe593788b7de19f84df0a6ffd4433400bf343af670feface7cbfb13e67e6.svg" /> </div> <div class="col"> <h2><a href="/user/Graeme%20Herbert/diary/405661">Big River and A Slow Boat To Belém </a></h2> </div> </div> <small class='text-body-secondary'> Posted by <a href="/user/Graeme%20Herbert">Graeme Herbert</a> on 24 November 2024 in <a href="/diary/en">English</a>. </small> </div> <div class="richtext text-break" xml:lang="en" lang="en"> <h1 id="the-first-boat---iquitos-to-the-triple-frontier">The First Boat - Iquitos To The Triple Frontier</h1> <p>The boat from Iquitos was to be our sole concession to relative comfort on the river, foreigners have to pay a higher price for the ferry than locals, but the benefit was to be on the upper deck with more space, and an outside area at the back. There are faster boats doing this stretch of the river, but you are stuck inside the boat the whole time with very limited views of the river. Ours was the middle option between the three day slow boat and the fast service, and finally we were on our way down the Amazon.</p> <p>Leaving in mid-afternoon we had about 3 hours of daylight left for river watching. The first proper sunset I had seen in Peru lit up the river before dark. And then we had a glorious full moon ahead of the boat, meaning that we had some visibility all night long. The ferry is quite modern and relatively fast, we even had a TV showing Peru playing Chile in a World Cup qualifier.</p> <p>I slept on and off, partly because of trying to sleep stretched out on seats that weren’t uncomfortable but which were not designed for sleeping. Some of that time I spent watching the moonlt silhouette of the forest as we made our way down river. All those months of thinking and planning the adventure, and here we were. We were expecting an 18 hour journey, but in the end it was nearer to 15. Early morning and we were almost at Santa Rosa, the Peruvian river island on the triple frontier.</p> </div> Location: <a href="/#map=14/-4.0059409402053925/-71.03073120117189"><abbr class="geo" title="-4.0059; -71.0307">San Pablo, Province of Mariscal Ramón Castilla, Loreto, Peru</abbr></a> <nav class='secondary-actions'> <ul class='clearfix'> <li><a href="/user/Graeme%20Herbert/diary/405661#newcomment">Comment on this entry</a></li> <li><a href="/message/new/Graeme%20Herbert?message%5Btitle%5D=Re%3A+Big+River+and+A+Slow+Boat+To+Bel%C3%A9m+">Send a message to the author</a></li> <li> <a href="/user/Graeme%20Herbert/diary/405661#comments">No comments</a> </li> </ul> </nav> </article> <article class='diary_post border-top border-secondary-subtle py-3 user_526776'> <div class='mb-3'> <div class="row"> <div class="col-auto"> <img class="user_thumbnail border border-secondary-subtle bg-body" alt="" width="50" height="50" src="/assets/avatar-c143fe593788b7de19f84df0a6ffd4433400bf343af670feface7cbfb13e67e6.svg" /> </div> <div class="col"> <h2><a href="/user/Graeme%20Herbert/diary/405660">Big River and A Slow Boat To Belém </a></h2> </div> </div> <small class='text-body-secondary'> Posted by <a href="/user/Graeme%20Herbert">Graeme Herbert</a> on 24 November 2024 in <a href="/diary/en">English</a>. </small> </div> <div class="richtext text-break" xml:lang="en" lang="en"> <h1 id="iquitos">Iquitos</h1> <p>One more plane, and then the real Amazon journey begins. I think I read somewhere that Iquitos is the largest city in the world that has no road connection to other parts of the country It belongs to. So a plane was the only alternative to seven days on the Rio Ucayali.The plan was to get to Iquitos and leave as soon as we could get a boat, with roughly two weeks left before arrival in Belem at the beginning of December for FOSS4G. and SOTM LATAM. In the end it was to be an overnight stay, there was a ferry leaving the next day for the Triple Frontier shared by Peru, Colombia and Brazil.</p> <p>With the ticket bought for the first leg we could relax and explore some of the city. Iquitos is bigger, and busier, than Pucallpa but the tuk tuk style transport still dominates. The days of the rubber boom, and associated exploitation of local people,are long gone. But some of the buildings from that time survive, We explored a museum telling some of that story and with a selection of some of the earliest maps made of Peruvian Amazonia. And of course we did our own small mapping contribution, adding some points of interest for the central area to OSM. Some of those were added whilst having a beer on the balcony of a metal building designed by Mr Eiffel himself and overlooking the main square - mapping is hot work in Amazonia.</p> </div> Location: <a href="/#map=14/-3.7349923091429593/-73.21289062500001"><abbr class="geo" title="-3.7350; -73.2129">Progreso, Belén, Province of Maynas, Loreto, 16001, Peru</abbr></a> <nav class='secondary-actions'> <ul class='clearfix'> <li><a href="/user/Graeme%20Herbert/diary/405660#newcomment">Comment on this entry</a></li> <li><a href="/message/new/Graeme%20Herbert?message%5Btitle%5D=Re%3A+Big+River+and+A+Slow+Boat+To+Bel%C3%A9m+">Send a message to the author</a></li> <li> <a href="/user/Graeme%20Herbert/diary/405660#comments">No comments</a> </li> </ul> </nav> </article> <article class='diary_post border-top border-secondary-subtle py-3 user_3233492'> <div class='mb-3'> <div class="row"> <div class="col-auto"> <img class="user_thumbnail border border-secondary-subtle bg-body" alt="" width="50" height="50" src="https://www.openstreetmap.org/rails/active_storage/representations/redirect/eyJfcmFpbHMiOnsiZGF0YSI6MzMyNDU5MDQsInB1ciI6ImJsb2JfaWQifX0=--1e9063d608d754ca1b472f71d410beb8e431a310/eyJfcmFpbHMiOnsiZGF0YSI6eyJmb3JtYXQiOiJwbmciLCJyZXNpemVfdG9fbGltaXQiOls1MCw1MF19LCJwdXIiOiJ2YXJpYXRpb24ifX0=--69b5827195f9b93bf8f2c405f6a463393e56b9e5/Lincoln%20County%20outline.png" /> </div> <div class="col"> <h2><a href="/user/caseywittmier/diary/405656">97498</a></h2> </div> </div> <small class='text-body-secondary'> Posted by <a href="/user/caseywittmier">caseywittmier</a> on 24 November 2024 in <a href="/diary/en">English</a>. </small> </div> <div class="richtext text-break" xml:lang="en" lang="en"> <p>January 7, 2024, marked my first OpenStreetMap edit in years, and the beginning of a journey that I was not aware I was embarking upon.</p> <p>After about a month of mostly adding driveways and doing minor road corrections around Oregon’s Lincoln County, my home county, I started a systematic review process for United States Forest Service roads in the Siuslaw National Forest. From early February to early June, I reviewed, added, and standardized the tagging of 1,055 such roads, and corrected the alignment of 963 of those. This amounts to a little over 1,145 miles of road geometry manually corrected. There are still many USFS roads left in the SNF to review, as my target review area was south of Neskowin Creek to north of the Siuslaw River. I intend to get to those eventually, but I decided to pause this and move on to features more local to myself.</p> <p>I noticed that accurate address data is virtually non-existent in Lincoln County. Google Maps has good address coverage, but is littered with duplicates, errors in data and placement (sometimes quite significant), and the occasional missing address. Bing Maps suffers from much of the same. The county’s own assessor map only has address data for taxlots, not for individual structures, and some of this data is incorrect (a 5### address near the middle of the 4000 block, just to name one example that I can recall). No one seems to have consistently reliable structure-level address data, aside from the state of Oregon address geocode service, which only offers lookup of a single address, not any kind of bulk data request or export, and also has occasional placement errors. I wanted to change that.</p> <p>I exported taxlot address data from the county map and online property search tool, made corrections and filled in gaps with my own research, and put this data into a spreadsheet. I was able to use a function to automatically query and collect the coordinates returned by the aforementioned geocode service for each address, and then convert this into a shapefile. I used Oregon Transportation Network data to verify and correct the address data and placement relative to roads, then used county taxlot polygons, open building footprint data, and imagery such as Bing and NAIP to correct placement errors. After all this, as a final quality check, I randomly selected and verified various addresses around the county, and used my personal knowledge to review what I knew as well. Through open street level imagery providers like Bing, as well as physical visits to areas like campground and mobile home parks, I was able to manually add over 6,000 sub-addresses, with no help from the state geocode service, as it does not return sub-addresses. I also developed a workflow to identify both new and removed addresses from the county assessor map. At this time, it is likely that I possess the most accurate address point data for Lincoln County. I feel that it is important to put this data somewhere where it can be both helpful and easy to access.</p> <p>I had originally considered going through the OSM import process for the address data, but what stopped me from doing this was the aforementioned building footprint data. I noted during the address placement review that every building footprint dataset covering Lincoln County is full of all kinds of errors, and I also noticed that OSM is severely lacking in building footprints locally. What better way to ensure the data I am contributing is free from error than by manually verifying every single addition? Why not add and correct building footprints at the same time? Though incredibly time consuming, doing it this way has produced valuable results.</p> <p>Starting on June 15, I began the work of adding these addresses and building footprints, and making fixes to other OSM data along the way. Today, November 23, 2024, I have added every address in the 97498 ZIP code to OSM, except for maybe 5 that were already present. This amounts to about 2,350 addresses. I am not sure of an easy way to pull this kind of information, so I will roughly estimate having added 1,800 buildings, and modified 700 pre-existing buildings.</p> <p>I intend to continue this level of work north through Seal Rock. As of now, that means 6,546 addresses and probably 5,000 or so buildings waiting for me to add. I have been monitoring the area for other active users, but find none outside of the rare editor making spot edits as they travel through or remotely participating in MapRoulette challenges. I doubt I will be committed to this level of work throughout the rest of the county, and will probably move towards an import of the rest of the address data when that time comes.</p> <p>I doubt anyone will read this screed, but if you have, I hope that means you are interested in helping out. Maybe it means you want the address point data. Send me a message either way.</p> </div> <nav class='secondary-actions'> <ul class='clearfix'> <li><a href="/user/caseywittmier/diary/405656#newcomment">Comment on this entry</a></li> <li><a href="/message/new/caseywittmier?message%5Btitle%5D=Re%3A+97498">Send a message to the author</a></li> <li> <a href="/user/caseywittmier/diary/405656#comments">No comments</a> </li> </ul> </nav> </article> <article class='diary_post border-top border-secondary-subtle py-3 user_1803854'> <div class='mb-3'> <div class="row"> <div class="col-auto"> <img class="user_thumbnail border border-secondary-subtle bg-body" alt="" width="46" height="50" src="https://www.openstreetmap.org/rails/active_storage/representations/redirect/eyJfcmFpbHMiOnsiZGF0YSI6MTMyOTc4NTgsInB1ciI6ImJsb2JfaWQifX0=--0cd8d83acbedcda6c3d4d5e438a142c95024a80a/eyJfcmFpbHMiOnsiZGF0YSI6eyJmb3JtYXQiOiJqcGciLCJyZXNpemVfdG9fbGltaXQiOls1MCw1MF19LCJwdXIiOiJ2YXJpYXRpb24ifX0=--dea07cf4fabdae9c56d9008d879a5332bbf580ce/plan9bunnywhite.jpg" /> </div> <div class="col"> <h2><a href="/user/Enock4seth/diary/405655">Reasons to currently STOP using Bing imagery as only reference on OpenStreetMap in Accra, Ghana</a></h2> </div> </div> <small class='text-body-secondary'> Posted by <a href="/user/Enock4seth">Enock4seth</a> on 23 November 2024 in <a href="/diary/en">English</a>. </small> </div> <div class="richtext text-break" xml:lang="en" lang="en"> <p>TL;DR</p> <blockquote> <p>Bing imagery in <a href="https://www.openstreetmap.org/relation/1991849" rel="nofollow noopener noreferrer">Greater Accra Region</a> is very very old but it continues to be used as the primary reference for adding new data into OpenStreetMap. Esri World Imagery however seems more recent in and better aligned thank Bing.</p> </blockquote> <p>This diary is a comparison of seleted locations in Accra with new developments that can be clearly seen in Esri World Imagery but not in Bing; one of the reasons not to use Bing as primary reference for adding new data into OpenStreetMap in Accra.</p> <p>Bing imagery also have some interesting imagery offsets and mosaic problems such as the photo below and around this <a href="https://www.openstreetmap.org/node/6013003388" rel="nofollow noopener noreferrer">node</a>. <img src="https://wiki.openstreetmap.org/w/images/2/2b/Bing_vs_Esri_in_Accra%2C_Ghana.jpg" alt="Bing vs Esri in Accra, Ghana south of Kotoka Internation Airport"></p> <blockquote> <p><a href="https://www.openstreetmap.org/node/6005414057#map=19/5.587357/-0.174172" rel="nofollow noopener noreferrer">Location on OSM</a></p> </blockquote> <blockquote> <p><a href="https://wiki.openstreetmap.org/wiki/Bing_Maps" rel="nofollow noopener noreferrer">©Bing aerial imagery</a> (left) and <a href="https://wiki.openstreetmap.org/wiki/Esri" rel="nofollow noopener noreferrer">©Esri World Imagery</a> (right).</p> </blockquote> <p>I have been mapping landuse areas in Greater Accra Region recently (deleting, adding and replacing multiple overlapping ways by remote mappers, same as that of <a href="https://www.openstreetmap.org/user/Enock4seth/diary/404120" rel="nofollow noopener noreferrer">Kumasi</a>) which revealed these changes. Most of my observations in relation to the recentness of publicly available imagery in OSM concludes Esri World Imagery is the most recent and seems to have a good alignment with existing known data and GPS traces.</p> <p>Here are two locations in the region that have seen rapid developments recently of which little or no traces can be seen in Bing imagery.</p> <h4 id="the-bank-square">The Bank Square</h4> <p><img src="https://wiki.openstreetmap.org/w/images/thumb/8/85/Bing_vs_Esri%2C_The_Bank_Square%2C_Accra.jpg/1280px-Bing_vs_Esri%2C_The_Bank_Square%2C_Accra.jpg" alt="The Bank Square, Accra, Ghana"></p> <blockquote> <p><a href="https://www.openstreetmap.org/#map=18/5.560848/-0.200160" rel="nofollow noopener noreferrer">Location on OSM</a></p> </blockquote> <blockquote> <p><a href="https://wiki.openstreetmap.org/wiki/Bing_Maps" rel="nofollow noopener noreferrer">©Bing aerial imagery</a> (left) and <a href="https://wiki.openstreetmap.org/wiki/Esri" rel="nofollow noopener noreferrer">©Esri World Imagery</a> (right). Screenshot taken in JOSM</p> </blockquote> <h4 id="jamestown-fishing-harbour">Jamestown Fishing Harbour</h4> <p><img src="https://wiki.openstreetmap.org/w/images/thumb/c/c2/Bing_vs_Esri%2C_Jamestown_Fishing_Harbour.jpg/612px-Bing_vs_Esri%2C_Jamestown_Fishing_Harbour.jpg" alt="Jamestown Fishing Harbour"></p> <blockquote> <p><a href="https://www.openstreetmap.org/#map=19/5.534138/-0.209059" rel="nofollow noopener noreferrer">Loation on OSM</a></p> </blockquote> <blockquote> <p><a href="https://wiki.openstreetmap.org/wiki/Bing_Maps" rel="nofollow noopener noreferrer">©Bing aerial imagery</a> (above) and <a href="https://wiki.openstreetmap.org/wiki/Esri" rel="nofollow noopener noreferrer">©Esri World Imagery</a> (below). Screenshot taken in JOSM</p> </blockquote> <h4 id="conclusion">Conclusion</h4> <ul> <li>Tracing and aligning features in OpenStreetMap to Bing in Accra at present will be completely useless.</li> <li>Compare imagery sources to see which is most recent and use a combination of both instead, in the case of Accra, Esri World Imagery at the moment is most recent and better aligned to existing data.</li> <li>Watch out for offsets and imagery mosaic issues</li> </ul> <h4 id="some-other-locations-that-can-be-compared">Some other locations that can be compared:</h4> <ul> <li>Junction Mall ==> <a href="https://www.openstreetmap.org/#map=17/5.614245/-0.070107" rel="nofollow noopener noreferrer">https://www.openstreetmap.org/#map=17/5.614245/-0.070107</a></li> <li>Flower Interchange ==> <a href="https://www.openstreetmap.org/#map=18/5.629172/-0.153586" rel="nofollow noopener noreferrer">https://www.openstreetmap.org/#map=18/5.629172/-0.153586</a></li> <li>Obetsebi Lamptey Interchange ==> <a href="https://www.openstreetmap.org/#map=18/5.561502/-0.228774" rel="nofollow noopener noreferrer">https://www.openstreetmap.org/#map=18/5.561502/-0.228774</a></li> <li>Football field ==> <a href="https://www.openstreetmap.org/#map=18/5.875589/0.382003" rel="nofollow noopener noreferrer">https://www.openstreetmap.org/#map=18/5.875589/0.382003</a></li> <li>New roads ==> <a href="https://www.openstreetmap.org/#map=19/5.661584/-0.077230" rel="nofollow noopener noreferrer">https://www.openstreetmap.org/#map=19/5.661584/-0.077230</a></li> </ul> </div> Location: <a href="/#map=14/5.555346937080737/-0.2078705451108154"><abbr class="geo" title="5.5553; -0.2079">West Ridge, Accra, Korle-Klottey Municipal District, Greater Accra Region, GA-222-2148, Ghana</abbr></a> <nav class='secondary-actions'> <ul class='clearfix'> <li><a href="/user/Enock4seth/diary/405655#newcomment">Comment on this entry</a></li> <li><a href="/message/new/Enock4seth?message%5Btitle%5D=Re%3A+Reasons+to+currently+STOP+using+Bing+imagery+as+only+reference+on+OpenStreetMap+in+Accra%2C+Ghana">Send a message to the author</a></li> <li> <a href="/user/Enock4seth/diary/405655#comments">No comments</a> </li> </ul> </nav> </article> <article class='diary_post border-top border-secondary-subtle py-3 user_208368'> <div class='mb-3'> <div class="row"> <div class="col-auto"> <img class="user_thumbnail border border-secondary-subtle bg-body" alt="" width="50" height="50" src="https://www.openstreetmap.org/rails/active_storage/representations/redirect/eyJfcmFpbHMiOnsiZGF0YSI6MTYxNDUwNDQsInB1ciI6ImJsb2JfaWQifX0=--35c76ffa2f18a96493128ac484fc6712dff5fa60/eyJfcmFpbHMiOnsiZGF0YSI6eyJmb3JtYXQiOiJqcGciLCJyZXNpemVfdG9fbGltaXQiOls1MCw1MF19LCJwdXIiOiJ2YXJpYXRpb24ifX0=--dea07cf4fabdae9c56d9008d879a5332bbf580ce/astrid.jpg" /> </div> <div class="col"> <h2><a href="/user/aselnigu/diary/405654">Aktualisierung von osm2pgsql mithilfe von Vagrant und Ansible.</a></h2> </div> </div> <small class='text-body-secondary'> Posted by <a href="/user/aselnigu">aselnigu</a> on 23 November 2024 in <a href="/diary/de">German (Deutsch)</a>. Last updated on 24 November 2024. </small> </div> <div class="richtext text-break" xml:lang="de" lang="de"> <h2 id="ausgangszustand">Ausgangszustand</h2> <p>Wir haben via der nachfolgenden Aufrufe</p> <ul> <li>eine Vagrant Maschine mit dem Test-Import vom Hackathon in Karlsruhe aus dem Snapshot wiederhergestellt,</li> <li>den Branch mit dem neuen Playbook geladen</li> <li>das Datum in der virtuellen Maschine auf den aktuellen Stand gesetzt</li> <li>Datenbank Updates in der virtuellen Maschine getestet</li> <li>und die Aktualisierung der Datenbank gestoppt und deaktiviert.</li> </ul> <pre><code>amaschine@amaschine-hp-laptop:~/openstreetmap/osm-server/ansible_openstreetmap.de$ git branch backport * master amaschine@amaschine-hp-laptop:~/openstreetmap/osm-server/ansible_openstreetmap.de$ vagrant snapshot restore bookworm afterimportanddoc [fog][WARNING] Unrecognized arguments: libvirt_ip_command ==> bookworm: Restoring the snapshot 'afterimportanddoc'... amaschine@amaschine-hp-laptop:~/openstreetmap/osm-server/ansible_openstreetmap.de$ date Sa 23. Nov 15:39:14 CET 2024 amaschine@amaschine-hp-laptop:~/openstreetmap/osm-server/ansible_openstreetmap.de$ git checkout backport M Vagrantfile M private Zu Zweig »backport« gewechselt amaschine@amaschine-hp-laptop:~/openstreetmap/osm-server/ansible_openstreetmap.de$ git branch * backport master amaschine@amaschine-hp-laptop:~/openstreetmap/osm-server/ansible_openstreetmap.de$ vagrant ssh bookworm [fog][WARNING] Unrecognized arguments: libvirt_ip_command Linux bookworm 6.1.0-26-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.112-1 (2024-09-30) x86_64 The programs included with the Debian GNU/Linux system are free software; the exact distribution terms for each program are described in the individual files in /usr/share/doc/*/copyright. Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent permitted by applicable law. Last login: Mon Oct 28 08:49:50 2024 from 192.168.121.1 vagrant@bookworm:~$ sudo date --set "23 Nov 2024 15:43:00" Sat Nov 23 15:43:00 UTC 2024 vagrant@bookworm:~$ date Sat Nov 23 15:43:20 UTC 2024 vagrant@bookworm:~$ sudo journalctl -u updatedb -f Nov 23 15:46:48 bookworm osm2pgsql-replication[6836]: 2024-11-23 15:46:48 [INFO]: Using replication service 'http://download.geofabrik.de/europe/monaco-updates'. Current sequence 4249 (2024-11-22 21:20:41+00:00). Nov 23 15:46:49 bookworm osm2pgsql-replication[6836]: 2024-11-23 15:46:49 [INFO]: Database already up-to-date. Nov 23 15:46:49 bookworm systemd[1]: updatedb.service: Deactivated successfully. Nov 23 15:47:39 bookworm systemd[1]: updatedb.service: Scheduled restart job, restart counter is at 41. Nov 23 15:47:39 bookworm systemd[1]: Stopped updatedb.service - render database update. Nov 23 15:47:39 bookworm systemd[1]: Starting updatedb.service - render database update... Nov 23 15:47:39 bookworm systemd[1]: Started updatedb.service - render database update. Nov 23 15:47:39 bookworm osm2pgsql-replication[6842]: 2024-11-23 15:47:39 [INFO]: Using replication service 'http://download.geofabrik.de/europe/monaco-updates'. Current sequence 4249 (2024-11-22 21:20:41+00:00). Nov 23 15:47:39 bookworm osm2pgsql-replication[6842]: 2024-11-23 15:47:39 [INFO]: Database already up-to-date. Nov 23 15:47:39 bookworm systemd[1]: updatedb.service: Deactivated successfully. Nov 23 15:48:29 bookworm systemd[1]: updatedb.service: Scheduled restart job, restart counter is at 42. Nov 23 15:48:29 bookworm systemd[1]: Stopped updatedb.service - render database update. Nov 23 15:48:29 bookworm systemd[1]: Starting updatedb.service - render database update... Nov 23 15:48:29 bookworm systemd[1]: Started updatedb.service - render database update. Nov 23 15:48:30 bookworm osm2pgsql-replication[6852]: 2024-11-23 15:48:30 [INFO]: Using replication service 'http://download.geofabrik.de/europe/monaco-updates'. Current sequence 4249 (2024-11-22 21:20:41+00:00). Nov 23 15:48:30 bookworm osm2pgsql-replication[6852]: 2024-11-23 15:48:30 [INFO]: Database already up-to-date. Nov 23 15:48:30 bookworm systemd[1]: updatedb.service: Deactivated successfully. vagrant@bookworm:~$ sudo systemctl stop updatedb vagrant@bookworm:~$ sudo systemctl disable updatedb Removed "/etc/systemd/system/multi-user.target.wants/updatedb.service". vagrant@bookworm:~$ sudo systemctl status updatedb ○ updatedb.service - render database update Loaded: loaded (/etc/systemd/system/updatedb.service; disabled; preset: enabled) Active: inactive (dead) Nov 23 15:48:30 bookworm osm2pgsql-replication[6852]: 2024-11-23 15:48:30 [INFO]: Database already up-to-date. Nov 23 15:48:30 bookworm systemd[1]: updatedb.service: Deactivated successfully. Nov 23 15:49:20 bookworm systemd[1]: updatedb.service: Scheduled restart job, restart counter is at 43. Nov 23 15:49:20 bookworm systemd[1]: Stopped updatedb.service - render database update. Nov 23 15:49:20 bookworm systemd[1]: Starting updatedb.service - render database update... Nov 23 15:49:20 bookworm systemd[1]: Started updatedb.service - render database update. Nov 23 15:49:20 bookworm osm2pgsql-replication[6858]: 2024-11-23 15:49:20 [INFO]: Using replication service 'http://download.geofabrik.de/europe/monaco-> Nov 23 15:49:20 bookworm osm2pgsql-replication[6858]: 2024-11-23 15:49:20 [INFO]: Database already up-to-date. Nov 23 15:49:20 bookworm systemd[1]: updatedb.service: Deactivated successfully. Nov 23 15:49:37 bookworm systemd[1]: Stopped updatedb.service - render database update </code></pre> <p><code>osm2pgsql --version</code> zeigt die Version 1.8.0 an:</p> <pre><code>vagrant@bookworm:~$ osm2pgsql --version 2024-11-23 15:54:00 osm2pgsql version 1.8.0 Build: None Compiled using the following library versions: Libosmium 2.19.0 Proj [API 6] 9.1.1 Lua 5.3.6 </code></pre> <h2 id="ausfhren-des-ansible-playbook-mit-den-nderungen-fr-osm2pgsql-version-200">Ausführen des Ansible Playbook mit den Änderungen für osm2pgsql version 2.0.0</h2> <pre><code>amaschine@amaschine-hp-laptop:~/openstreetmap/osm-server/ansible_openstreetmap.de$ ansible-playbook -v -i vagrant.ini site.yml -u vagrant </code></pre> <p>Das Log in Auszügen:</p> <pre><code>Using /home/astrid/openstreetmap/osm-server/ansible_openstreetmap.de/ansible.cfg as config file PLAY [all] ********************************************************************* ... TASK [tile : Ensure backports repository is enabled] *************************** changed: [vagrant] => changed=true repo: deb http://deb.debian.org/debian bookworm-backports main sources_added: - /etc/apt/sources.list.d/deb_debian_org_debian.list sources_removed: [] state: present TASK [tile : Update apt cache] ************************************************* ok: [vagrant] => changed=false cache_update_time: 1732377360 cache_updated: false TASK [tile : Install osm2pgsql from backports] ********************************* changed: [vagrant] => changed=true cache_update_time: 1732377360 cache_updated: false stderr: '' stderr_lines: <omitted> stdout: |- Reading package lists... Building dependency tree... Reading state information... The following packages will be upgraded: osm2pgsql 1 upgraded, 0 newly installed, 0 to remove and 117 not upgraded. Need to get 655 kB of archives. After this operation, 376 kB of additional disk space will be used. Get:1 https://deb.debian.org/debian bookworm-backports/main amd64 osm2pgsql amd64 2.0.0+ds-1~bpo12+1 [655 kB] apt-listchanges: Reading changelogs... Fetched 655 kB in 1s (1042 kB/s) (Reading database ... (Reading database ... 5%(Reading database ... 10%(Reading database ... 15%(Reading database ... 20%(Reading database ... 25%(Reading database ... 30%(Reading database ... 35%(Reading database ... 40%(Reading database ... 45%(Reading database ... 50%(Reading database ... 55%(Reading database ... 60%(Reading database ... 65%(Reading database ... 70%(Reading database ... 75%(Reading database ... 80%(Reading database ... 85%(Reading database ... 90%(Reading database ... 95%(Reading database ... 100%(Reading database ... 118746 files and directories currently installed.) Preparing to unpack .../osm2pgsql_2.0.0+ds-1~bpo12+1_amd64.deb ... Unpacking osm2pgsql (2.0.0+ds-1~bpo12+1) over (1.8.0+ds-1) ... Setting up osm2pgsql (2.0.0+ds-1~bpo12+1) ... Processing triggers for man-db (2.11.2-2) ... stdout_lines: <omitted> TASK [tile : Install pyosmium with apt] **************************************** ok: [vagrant] => changed=false cache_update_time: 1732377360 cache_updated: false TASK [tile : install required packages with apt] ******************************* ok: [vagrant] => changed=false cache_update_time: 1732377360 cache_updated: false TASK [tile : import script] **************************************************** changed: [vagrant] => changed=true checksum: 2935b0eb1ce39c8352e5a285d7bf71549353a30e dest: /usr/local/sbin/import-osm2pgsql gid: 0 group: root md5sum: 3ac058ba5347d0f7a045b93a31d61144 mode: '0755' owner: root size: 2940 src: /home/vagrant/.ansible/tmp/ansible-tmp-1732373896.116979-30985-21719873806536/source state: file uid: 0 TASK [tile : Make sure destination dir for flatnode file, planet and bin dir exist] *** ok: [vagrant] => (item=/srv/tile/flatnode) => changed=false ansible_loop_var: item gid: 996 group: tile item: /srv/tile/flatnode mode: '0755' owner: tile path: /srv/tile size: 4096 state: directory uid: 999 ok: [vagrant] => (item=/srv/tile/planet.osm.pbf) => changed=false ansible_loop_var: item gid: 996 group: tile item: /srv/tile/planet.osm.pbf mode: '0755' owner: tile path: /srv/tile size: 4096 state: directory uid: 999 ok: [vagrant] => (item=/srv/tile/bin/expire-tiles-single.py) => changed=false ansible_loop_var: item gid: 0 group: root item: /srv/tile/bin/expire-tiles-single.py mode: '0755' owner: root path: /srv/tile/bin size: 4096 state: directory uid: 0 TASK [tile : render database updates from minutely] **************************** changed: [vagrant] => changed=true checksum: d4ae42b13fa9a9b865fe2637c0c7cdc318abd03a dest: /etc/systemd/system/updatedb.service gid: 0 group: root md5sum: d675df77f3f79a342c70e634357583b0 mode: '0644' owner: root size: 460 src: /home/vagrant/.ansible/tmp/ansible-tmp-1732373897.8073187-30998-33336710338320/source state: file uid: 0 TASK [tile : german style] ***************************************************** changed: [vagrant] => changed=true after: b653267dc3ebf137a0aa1e5ca049f63005188b47 before: 49aac58bcad0f5022eb74c9852d61ffd400bc017 remote_url_changed: false TASK [tile : Dependencies for style and localization functions for OpenStreetMap] *** ok: [vagrant] => changed=false cache_update_time: 1732377360 cache_updated: false TASK [tile : node carto for style transformation] ****************************** ok: [vagrant] => changed=false cmd: npm install --global carto delta: null end: null msg: Did not run command since '/usr/local/bin/carto' exists rc: 0 start: null stderr: '' stderr_lines: <omitted> stdout: skipped, since /usr/local/bin/carto exists stdout_lines: <omitted> TASK [tile : generate mapnik xml] ********************************************** changed: [vagrant] => changed=true cmd: make; git checkout project.mml delta: '0:00:36.533775' end: '2024-11-23 15:56:58.982713' msg: '' rc: 0 start: '2024-11-23 15:56:22.448938' stderr: |- Warning: style/landcover.mss:630:4 line-offset is unstable. It may change in the future. Warning: style/landcover.mss:633:6 line-offset is unstable. It may change in the future. Warning: style/water-features.mss:112:6 line-offset is unstable. It may change in the future. .... Warning: style/admin.mss:18:6 Styles do not match layer selector #admin-low-zoom. Updated 0 paths from the index stderr_lines: <omitted> stdout: |- carto -a 3.0.15 project.mml > /tmp/tmp.wyCh5drKdz mv /tmp/tmp.wyCh5drKdz osm-de.xml sed -e 's/localized_[a-z_]\+/name_hrb/g' project.mml >project-hrb.mml carto -a 3.0.15 project-hrb.mml > /tmp/tmp.wyCh5drKdz mv /tmp/tmp.wyCh5drKdz osm-hrb.xml stdout_lines: <omitted> TASK [tile : Localization functions for OpenStreetMap] ************************* changed: [vagrant] => changed=true after: d06b251bd6882d9ff9bc4e028cc593c8d02a3bb7 before: 8e3004b72f07b1cdb4b4c4a1d50c1dd765194448 remote_url_changed: false TASK [tile : clear outdated .deb packages of osml10n] ************************** changed: [vagrant] => changed=true cmd: rm -f /srv/tile/sources/osml10n*.deb /srv/tile/sources/osml10n/*.deb delta: '0:00:00.006004' end: '2024-11-23 15:57:01.335680' msg: '' rc: 0 start: '2024-11-23 15:57:01.329676' stderr: '' stderr_lines: <omitted> stdout: '' stdout_lines: <omitted> TASK [tile : Build osml10n debian packages] ************************************ changed: [vagrant] => (item=/srv/tile/sources/osml10n) => changed=true ansible_loop_var: item cmd: make deb delta: '0:00:03.223523' end: '2024-11-23 15:57:04.879868' item: /srv/tile/sources/osml10n msg: '' rc: 0 start: '2024-11-23 15:57:01.656345' stderr: |2- dpkg-source --before-build . fakeroot debian/rules clean debian/rules build fakeroot debian/rules binary dpkg-genbuildinfo --build=binary -O../osml10n_1.2.0_amd64.buildinfo dpkg-genchanges --build=binary -O../osml10n_1.2.0_amd64.changes dpkg-source --after-build . stderr_lines: <omitted> stdout: |- dpkg-buildpackage -b -uc dpkg-buildpackage: info: source package osml10n dpkg-buildpackage: info: source version 1.2.0 dpkg-buildpackage: info: source distribution unstable dpkg-buildpackage: info: source changed by Sven Geggus <sven-debian@geggus.net> dpkg-buildpackage: info: host architecture amd64 make[1]: Entering directory '/srv/tile/sources/osml10n' dh clean dh_auto_clean make -j1 clean make[2]: Entering directory '/srv/tile/sources/osml10n' echo "there is nothing to clean" there is nothing to clean make[2]: Leaving directory '/srv/tile/sources/osml10n' dh_clean make[1]: Leaving directory '/srv/tile/sources/osml10n' make[1]: Entering directory '/srv/tile/sources/osml10n' make[1]: 'build' is up to date. make[1]: Leaving directory '/srv/tile/sources/osml10n' make[1]: Entering directory '/srv/tile/sources/osml10n' dh binary dh_update_autotools_config dh_autoreconf dh_auto_configure dh_auto_build make -j1 "INSTALL=install --strip-program=true" make[2]: Entering directory '/srv/tile/sources/osml10n' make[2]: 'build' is up to date. make[2]: Leaving directory '/srv/tile/sources/osml10n' debian/rules override_dh_auto_test make[2]: Entering directory '/srv/tile/sources/osml10n' /bin/true make[2]: Leaving directory '/srv/tile/sources/osml10n' create-stamp debian/debhelper-build-stamp dh_testroot dh_prep dh_installdirs debian/rules override_dh_auto_install make[2]: Entering directory '/srv/tile/sources/osml10n' dh_auto_install -- prefix=/usr make -j1 install DESTDIR=/srv/tile/sources/osml10n/debian/osml10n AM_UPDATE_INFO_DIR=no "INSTALL=install --strip-program=true" prefix=/usr make[3]: Entering directory '/srv/tile/sources/osml10n' mkdir -p /srv/tile/sources/osml10n/debian/osml10n/usr/share/lua/5.3 cp -a lua_osml10/osml10n /srv/tile/sources/osml10n/debian/osml10n/usr/share/lua/5.3/ chmod -R go+rX /srv/tile/sources/osml10n/debian/osml10n/usr/share/lua/5.3/osml10n make[3]: Leaving directory '/srv/tile/sources/osml10n' make[2]: Leaving directory '/srv/tile/sources/osml10n' dh_installdocs dh_installchangelogs dh_perl dh_link dh_strip_nondeterminism dh_compress dh_fixperms dh_missing dh_installdeb dh_gencontrol dh_md5sums dh_builddeb dpkg-deb: building package 'osml10n' in '../osml10n_1.2.0_all.deb'. make[1]: Leaving directory '/srv/tile/sources/osml10n' dpkg-genchanges: info: binary-only upload (no source code included) dpkg-buildpackage: info: binary-only upload (no source included) stdout_lines: <omitted> changed: [vagrant] => (item=/srv/tile/sources/osml10n/lua_unac) => changed=true ansible_loop_var: item cmd: make deb delta: '0:00:04.232802' end: '2024-11-23 15:57:09.371837' item: /srv/tile/sources/osml10n/lua_unac msg: '' rc: 0 start: '2024-11-23 15:57:05.139035' stderr: |2- dpkg-source --before-build . fakeroot debian/rules clean debian/rules build fakeroot debian/rules binary dpkg-gencontrol: warning: package lua-unaccent: substitution variable ${shlibs:Depends} unused, but is defined dpkg-gencontrol: warning: package lua-unaccent: substitution variable ${shlibs:Depends} unused, but is defined dpkg-genbuildinfo --build=binary -O../lua-unaccent_1.8-1_amd64.buildinfo dpkg-genchanges --build=binary -O../lua-unaccent_1.8-1_amd64.changes dpkg-source --after-build . stderr_lines: <omitted> stdout: |- dpkg-buildpackage -b -uc dpkg-buildpackage: info: source package lua-unaccent dpkg-buildpackage: info: source version 1.8-1 dpkg-buildpackage: info: source distribution unstable dpkg-buildpackage: info: source changed by Sven Geggus <sven-debian@geggus.net> dpkg-buildpackage: info: host architecture amd64 make[1]: Entering directory '/srv/tile/sources/osml10n/lua_unac' dh clean dh_auto_clean make -j1 clean make[2]: Entering directory '/srv/tile/sources/osml10n/lua_unac' rm -f unaccent.so make[2]: Leaving directory '/srv/tile/sources/osml10n/lua_unac' dh_clean make[1]: Leaving directory '/srv/tile/sources/osml10n/lua_unac' make[1]: Entering directory '/srv/tile/sources/osml10n/lua_unac' dh build dh_update_autotools_config dh_autoreconf dh_auto_configure dh_auto_build make -j1 "INSTALL=install --strip-program=true" make[2]: Entering directory '/srv/tile/sources/osml10n/lua_unac' gcc -Wall -shared -fPIC -o unaccent.so -I/usr/include/lua5.3 -llua5.3 -Wl,--no-as-needed -lunac lua_unac.c make[2]: Leaving directory '/srv/tile/sources/osml10n/lua_unac' dh_auto_test create-stamp debian/debhelper-build-stamp make[1]: Leaving directory '/srv/tile/sources/osml10n/lua_unac' make[1]: Entering directory '/srv/tile/sources/osml10n/lua_unac' dh binary dh_testroot dh_prep dh_installdirs dh_auto_install --destdir=debian/lua-unaccent/ make -j1 install DESTDIR=/srv/tile/sources/osml10n/lua_unac/debian/lua-unaccent AM_UPDATE_INFO_DIR=no "INSTALL=install --strip-program=true" make[2]: Entering directory '/srv/tile/sources/osml10n/lua_unac' install -m 644 unaccent.so /srv/tile/sources/osml10n/lua_unac/debian/lua-unaccent/usr/lib/x86_64-linux-gnu/lua/5.3/ make[2]: Leaving directory '/srv/tile/sources/osml10n/lua_unac' dh_installdocs dh_installchangelogs dh_perl dh_link dh_strip_nondeterminism dh_compress dh_fixperms dh_missing dh_strip dh_makeshlibs dh_shlibdeps dh_installdeb dh_gencontrol dh_md5sums dh_builddeb dpkg-deb: building package 'lua-unaccent' in '../lua-unaccent_1.8-1_amd64.deb'. dpkg-deb: building package 'lua-unaccent-dbgsym' in '../lua-unaccent-dbgsym_1.8-1_amd64.deb'. make[1]: Leaving directory '/srv/tile/sources/osml10n/lua_unac' dpkg-genchanges: info: binary-only upload (no source code included) dpkg-buildpackage: info: binary-only upload (no source included) stdout_lines: <omitted> ... TASK [tile : Set up virtualenv] ************************************************ changed: [vagrant] => changed=true cmd: - /srv/tile/venv/bin/pip3 - install - /srv/tile/sources/osml10n/ name: - /srv/tile/sources/osml10n/ requirements: null state: present stderr: '' stderr_lines: <omitted> stdout: |- Processing /srv/tile/sources/osml10n Installing build dependencies: started Installing build dependencies: finished with status 'done' Getting requirements to build wheel: started Getting requirements to build wheel: finished with status 'done' Preparing metadata (pyproject.toml): started Preparing metadata (pyproject.toml): finished with status 'done' Requirement already satisfied: setuptools in /srv/tile/venv/lib/python3.11/site-packages (from osml10n==1.2.0) (66.1.1) Requirement already satisfied: scipy in /srv/tile/venv/lib/python3.11/site-packages (from osml10n==1.2.0) (1.13.1) Requirement already satisfied: scikit-learn in /srv/tile/venv/lib/python3.11/site-packages (from osml10n==1.2.0) (1.3.2) Requirement already satisfied: pykakasi==2.2.1 in /srv/tile/venv/lib/python3.11/site-packages (from osml10n==1.2.0) (2.2.1) Requirement already satisfied: tltk==1.8.0 in /srv/tile/venv/lib/python3.11/site-packages (from osml10n==1.2.0) (1.8) Requirement already satisfied: pinyin_jyutping_sentence==1.3 in /srv/tile/venv/lib/python3.11/site-packages (from osml10n==1.2.0) (1.3) Requirement already satisfied: pyicu in /usr/lib/python3/dist-packages (from osml10n==1.2.0) (2.10.2) Requirement already satisfied: shapely in /srv/tile/venv/lib/python3.11/site-packages (from osml10n==1.2.0) (2.0.6) Requirement already satisfied: sdnotify in /srv/tile/venv/lib/python3.11/site-packages (from osml10n==1.2.0) (0.3.2) Requirement already satisfied: requests in /usr/lib/python3/dist-packages (from osml10n==1.2.0) (2.28.1) Requirement already satisfied: pandas in /srv/tile/venv/lib/python3.11/site-packages (from osml10n==1.2.0) (2.2.3) Requirement already satisfied: jieba in /srv/tile/venv/lib/python3.11/site-packages (from pinyin_jyutping_sentence==1.3->osml10n==1.2.0) (0.42.1) Requirement already satisfied: jaconv in /srv/tile/venv/lib/python3.11/site-packages (from pykakasi==2.2.1->osml10n==1.2.0) (0.4.0) Requirement already satisfied: deprecated in /srv/tile/venv/lib/python3.11/site-packages (from pykakasi==2.2.1->osml10n==1.2.0) (1.2.14) Requirement already satisfied: nltk in /srv/tile/venv/lib/python3.11/site-packages (from tltk==1.8.0->osml10n==1.2.0) (3.9.1) Requirement already satisfied: sklearn-crfsuite in /srv/tile/venv/lib/python3.11/site-packages (from tltk==1.8.0->osml10n==1.2.0) (0.5.0) Requirement already satisfied: gensim in /srv/tile/venv/lib/python3.11/site-packages (from tltk==1.8.0->osml10n==1.2.0) (4.3.3) Requirement already satisfied: numpy>=1.23.2 in /usr/lib/python3/dist-packages (from pandas->osml10n==1.2.0) (1.24.2) Requirement already satisfied: python-dateutil>=2.8.2 in /srv/tile/venv/lib/python3.11/site-packages (from pandas->osml10n==1.2.0) (2.9.0.post0) Requirement already satisfied: pytz>=2020.1 in /srv/tile/venv/lib/python3.11/site-packages (from pandas->osml10n==1.2.0) (2024.2) Requirement already satisfied: tzdata>=2022.7 in /srv/tile/venv/lib/python3.11/site-packages (from pandas->osml10n==1.2.0) (2024.2) Requirement already satisfied: joblib>=1.1.1 in /srv/tile/venv/lib/python3.11/site-packages (from scikit-learn->osml10n==1.2.0) (1.4.2) Requirement already satisfied: threadpoolctl>=2.0.0 in /srv/tile/venv/lib/python3.11/site-packages (from scikit-learn->osml10n==1.2.0) (3.5.0) Requirement already satisfied: six>=1.5 in /usr/lib/python3/dist-packages (from python-dateutil>=2.8.2->pandas->osml10n==1.2.0) (1.16.0) Requirement already satisfied: wrapt<2,>=1.10 in /srv/tile/venv/lib/python3.11/site-packages (from deprecated->pykakasi==2.2.1->osml10n==1.2.0) (1.16.0) Requirement already satisfied: smart-open>=1.8.1 in /srv/tile/venv/lib/python3.11/site-packages (from gensim->tltk==1.8.0->osml10n==1.2.0) (7.0.5) Requirement already satisfied: click in /srv/tile/venv/lib/python3.11/site-packages (from nltk->tltk==1.8.0->osml10n==1.2.0) (8.1.7) Requirement already satisfied: regex>=2021.8.3 in /srv/tile/venv/lib/python3.11/site-packages (from nltk->tltk==1.8.0->osml10n==1.2.0) (2024.9.11) Requirement already satisfied: tqdm in /srv/tile/venv/lib/python3.11/site-packages (from nltk->tltk==1.8.0->osml10n==1.2.0) (4.66.5) Requirement already satisfied: python-crfsuite>=0.9.7 in /srv/tile/venv/lib/python3.11/site-packages (from sklearn-crfsuite->tltk==1.8.0->osml10n==1.2.0) (0.9.11) Requirement already satisfied: tabulate>=0.4.2 in /srv/tile/venv/lib/python3.11/site-packages (from sklearn-crfsuite->tltk==1.8.0->osml10n==1.2.0) (0.9.0) Building wheels for collected packages: osml10n Building wheel for osml10n (pyproject.toml): started Building wheel for osml10n (pyproject.toml): finished with status 'done' Created wheel for osml10n: filename=osml10n-1.2.0-py3-none-any.whl size=460510 sha256=17a7516b4a7471019c093c6815dcba1cbf3288ad8adb831eb8bd5a16af5e0af0 Stored in directory: /tmp/pip-ephem-wheel-cache-4lx_a458/wheels/58/59/6b/e33f37490a677616eceeaca7209a8dd775b4ee853e7f6b790b Successfully built osml10n Installing collected packages: osml10n Attempting uninstall: osml10n Found existing installation: osml10n 1.2.0 Uninstalling osml10n-1.2.0: Successfully uninstalled osml10n-1.2.0 Successfully installed osml10n-1.2.0 stdout_lines: <omitted> version: null virtualenv: /srv/tile/venv TASK [tile : Copy osml10n service] ********************************************* changed: [vagrant] => changed=true cmd: make systemd-service PYTARGET=/srv/tile/venv delta: '0:00:00.010277' end: '2024-11-23 15:57:32.324989' msg: '' rc: 0 start: '2024-11-23 15:57:32.314712' stderr: '' stderr_lines: <omitted> stdout: sed -e "s;%PYTARGET%;/srv/tile/venv;g" transcription-daemon/geo-transcript-srv.service.template >/etc/systemd/system/osml10n.service stdout_lines: <omitted> ... PLAY RECAP ********************************************************************* dummy : ok=0 changed=0 unreachable=1 failed=0 skipped=0 rescued=0 ignored=0 vagrant : ok=127 changed=21 unreachable=0 failed=0 skipped=29 rescued=0 ignored=0 </code></pre> <p><code>osm2pgsql --version</code> zeigt nun die Version 2.0.0 an:</p> <pre><code>vagrant@bookworm:~$ osm2pgsql --version osm2pgsql version 2.0.0 Build: None Compiled using the following library versions: Libosmium 2.19.0 Proj 9.1.1 Lua 5.3.6 </code></pre> <h2 id="neu-import-der-daten">Neu-Import der Daten</h2> <p>Nach einem Neustart haben wir die Daten neu eingelesen. Dabei wird die Datenbank neu angelegt (kein append).</p> <pre><code>vagrant@bookworm:~$ sudo reboot vagrant@bookworm:~$ sudo /usr/local/sbin/import-osm2pgsql Redirecting output to ‘wget-log.1’. 2024-11-23 15:26:56 osm2pgsql version 2.0.0 2024-11-23 15:26:56 WARNING: RAM cache is disabled. This will likely slow down processing a lot. 2024-11-23 15:26:56 Database version: 15.8 (Debian 15.8-0+deb12u1) 2024-11-23 15:26:56 PostGIS version: 3.3 2024-11-23 15:26:56 Initializing properties table '"public"."osm2pgsql_properties"'. 2024-11-23 15:26:56 Storing properties to table '"public"."osm2pgsql_properties"'. 2024-11-23 15:26:57 WARNING: You should use the syntax 'object:get_bbox()' (with the colon, not a point) to call functions on the OSM object. 2024-11-23 15:27:01 Reading input files done in 4s. 2024-11-23 15:27:01 Processed 30936 nodes in 2s - 15k/s 2024-11-23 15:27:01 Processed 4973 ways in 1s - 5k/s 2024-11-23 15:27:01 Processed 291 relations in 1s - 291/s 2024-11-23 15:27:01 No marked nodes or ways (Skipping stage 2). 2024-11-23 15:27:01 Clustering table 'planet_osm_hstore_point' by geometry... 2024-11-23 15:27:01 Creating index on table 'planet_osm_hstore_point' ("way")... 2024-11-23 15:27:01 Creating id index on table 'planet_osm_hstore_point'... 2024-11-23 15:27:01 Analyzing table 'planet_osm_hstore_point'... 2024-11-23 15:27:01 Clustering table 'planet_osm_hstore_line' by geometry... 2024-11-23 15:27:01 Creating index on table 'planet_osm_hstore_line' ("way")... 2024-11-23 15:27:01 Creating id index on table 'planet_osm_hstore_line'... 2024-11-23 15:27:01 Analyzing table 'planet_osm_hstore_line'... 2024-11-23 15:27:02 Clustering table 'planet_osm_hstore_roads' by geometry... 2024-11-23 15:27:02 Creating index on table 'planet_osm_hstore_roads' ("way")... 2024-11-23 15:27:02 Creating id index on table 'planet_osm_hstore_roads'... 2024-11-23 15:27:02 Analyzing table 'planet_osm_hstore_roads'... 2024-11-23 15:27:02 Clustering table 'planet_osm_hstore_polygon' by geometry... 2024-11-23 15:27:02 Creating index on table 'planet_osm_hstore_polygon' ("way")... 2024-11-23 15:27:03 Creating id index on table 'planet_osm_hstore_polygon'... 2024-11-23 15:27:03 Analyzing table 'planet_osm_hstore_polygon'... 2024-11-23 15:27:03 No indexes to create on table 'planet_osm_hstore_route'. 2024-11-23 15:27:03 Creating id index on table 'planet_osm_hstore_route'... 2024-11-23 15:27:03 Analyzing table 'planet_osm_hstore_route'... 2024-11-23 15:27:03 Done postprocessing on table 'planet_osm_nodes' in 0s 2024-11-23 15:27:03 Building index on table 'planet_osm_ways' 2024-11-23 15:27:04 Done postprocessing on table 'planet_osm_ways' in 0s 2024-11-23 15:27:04 Building index on table 'planet_osm_rels' 2024-11-23 15:27:05 Done postprocessing on table 'planet_osm_rels' in 1s 2024-11-23 15:27:05 All postprocessing on table 'planet_osm_hstore_point' done in 0s. 2024-11-23 15:27:05 All postprocessing on table 'planet_osm_hstore_line' done in 0s. 2024-11-23 15:27:05 All postprocessing on table 'planet_osm_hstore_roads' done in 0s. 2024-11-23 15:27:05 All postprocessing on table 'planet_osm_hstore_polygon' done in 0s. 2024-11-23 15:27:05 All postprocessing on table 'planet_osm_hstore_route' done in 0s. 2024-11-23 15:27:05 Storing properties to table '"public"."osm2pgsql_properties"'. 2024-11-23 15:27:05 osm2pgsql took 9s overall. CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX using database: osm CREATE VIEW GRANT CREATE VIEW GRANT CREATE VIEW GRANT CREATE VIEW GRANT CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION 2024-11-23 15:27:12 [INFO]: Initialised updates for service 'https://planet.openstreetmap.org/replication/minute'. 2024-11-23 15:27:12 [INFO]: Starting at sequence 6356693 (2024-11-21T07:51:46Z). Using replication service 'https://planet.openstreetmap.org/replication/minute', which is at sequence 6359947 ( 2024-11-23T15:26:25Z ) Replication server's most recent data is 48 second(s) old Local database is 3254 sequences behind the server, i.e. 2 day(s) 7 hour(s) 34 minute(s) 39 second(s) Local database's most recent data is 2 day(s) 7 hour(s) 35 minute(s) 27 second(s) old INFO:root:Starting load of external data into database INFO:root:Checking table simplified_water_polygons INFO:root: Download complete (23896068 bytes) INFO:root: Decompressing file INFO:root: Importing into database INFO:root: Import complete INFO:root:Checking table water_polygons INFO:root: Download complete (871221776 bytes) INFO:root: Decompressing file INFO:root: Importing into database INFO:root: Import complete INFO:root:Checking table icesheet_polygons INFO:root: Download complete (52714660 bytes) INFO:root: Decompressing file INFO:root: Importing into database INFO:root: Import complete INFO:root:Checking table icesheet_outlines INFO:root: Download complete (53595955 bytes) INFO:root: Decompressing file INFO:root: Importing into database INFO:root: Import complete INFO:root:Checking table ne_110m_admin_0_boundary_lines_land INFO:root: Table ne_110m_admin_0_boundary_lines_land did not require updating Redirecting output to ‘wget-log’. Archive: carto-fonts.zip inflating: HanaMinA.ttf inflating: HanaMinB.ttf inflating: NotoEmoji-Bold.ttf inflating: NotoEmoji-Regular.ttf inflating: NotoSansAdlamUnjoined-Bold.ttf inflating: NotoSansAdlamUnjoined-Regular.ttf inflating: NotoSansArabicUI-Bold.ttf inflating: NotoSansArabicUI-Regular.ttf inflating: NotoSansArmenian-Bold.ttf inflating: NotoSansArmenian-Regular.ttf inflating: NotoSansBalinese-Bold.ttf inflating: NotoSansBalinese-Regular.ttf inflating: NotoSansBamum-Bold.ttf inflating: NotoSansBamum-Regular.ttf inflating: NotoSansBatak-Regular.ttf inflating: NotoSansBengaliUI-Bold.ttf inflating: NotoSansBengaliUI-Regular.ttf inflating: NotoSans-Bold.ttf inflating: NotoSansBuginese-Regular.ttf inflating: NotoSansBuhid-Regular.ttf inflating: NotoSansCanadianAboriginal-Bold.ttf inflating: NotoSansCanadianAboriginal-Regular.ttf inflating: NotoSansChakma-Regular.ttf inflating: NotoSansCham-Bold.ttf inflating: NotoSansCham-Regular.ttf inflating: NotoSansCherokee-Bold.ttf inflating: NotoSansCherokee-Regular.ttf inflating: NotoSansCJKjp-Bold.otf inflating: NotoSansCJKjp-Regular.otf inflating: NotoSansCoptic-Regular.ttf inflating: NotoSansDevanagariUI-Bold.ttf inflating: NotoSansDevanagariUI-Regular.ttf inflating: NotoSansEthiopic-Bold.ttf inflating: NotoSansEthiopic-Regular.ttf inflating: NotoSansGeorgian-Bold.ttf inflating: NotoSansGeorgian-Regular.ttf inflating: NotoSansGujaratiUI-Bold.ttf inflating: NotoSansGujaratiUI-Regular.ttf inflating: NotoSansGurmukhiUI-Bold.ttf inflating: NotoSansGurmukhiUI-Regular.ttf inflating: NotoSansHanunoo-Regular.ttf inflating: NotoSansHebrew-Bold.ttf inflating: NotoSansHebrew-Regular.ttf inflating: NotoSans-Italic.ttf inflating: NotoSansJavanese-Bold.ttf inflating: NotoSansJavanese-Regular.ttf inflating: NotoSansKannadaUI-Bold.ttf inflating: NotoSansKannadaUI-Regular.ttf inflating: NotoSansKayahLi-Bold.ttf inflating: NotoSansKayahLi-Regular.ttf inflating: NotoSansKhmerUI-Bold.ttf inflating: NotoSansKhmerUI-Regular.ttf inflating: NotoSansLaoUI-Bold.ttf inflating: NotoSansLaoUI-Regular.ttf inflating: NotoSansLepcha-Regular.ttf inflating: NotoSansLimbu-Regular.ttf inflating: NotoSansLisu-Bold.ttf inflating: NotoSansLisu-Regular.ttf inflating: NotoSansMalayalamUI-Bold.ttf inflating: NotoSansMalayalamUI-Regular.ttf inflating: NotoSansMandaic-Regular.ttf inflating: NotoSansMongolian-Regular.ttf inflating: NotoSansMyanmarUI-Bold.ttf inflating: NotoSansMyanmarUI-Regular.ttf inflating: NotoSansNewTaiLue-Regular.ttf inflating: NotoSansNKo-Regular.ttf inflating: NotoSansOlChiki-Bold.ttf inflating: NotoSansOlChiki-Regular.ttf inflating: NotoSansOriyaUI-Bold.ttf inflating: NotoSansOriyaUI-Regular.ttf inflating: NotoSansOsage-Regular.ttf inflating: NotoSansOsmanya-Regular.ttf inflating: NotoSans-Regular.ttf inflating: NotoSansSamaritan-Regular.ttf inflating: NotoSansSaurashtra-Regular.ttf inflating: NotoSansShavian-Regular.ttf inflating: NotoSansSinhalaUI-Bold.ttf inflating: NotoSansSinhalaUI-Regular.ttf inflating: NotoSansSundanese-Bold.ttf inflating: NotoSansSundanese-Regular.ttf inflating: NotoSansSymbols2-Regular.ttf inflating: NotoSansSymbols-Bold.ttf inflating: NotoSansSymbols-Regular.ttf inflating: NotoSansSyriac-Black.ttf inflating: NotoSansSyriac-Regular.ttf inflating: NotoSansTagalog-Regular.ttf inflating: NotoSansTagbanwa-Regular.ttf inflating: NotoSansTaiLe-Regular.ttf inflating: NotoSansTaiTham-Bold.ttf inflating: NotoSansTaiTham-Regular.ttf inflating: NotoSansTaiViet-Regular.ttf inflating: NotoSansTamilUI-Bold.ttf inflating: NotoSansTamilUI-Regular.ttf inflating: NotoSansTeluguUI-Bold.ttf inflating: NotoSansTeluguUI-Regular.ttf inflating: NotoSansThaana-Bold.ttf inflating: NotoSansThaana-Regular.ttf inflating: NotoSansThaiUI-Bold.ttf inflating: NotoSansThaiUI-Regular.ttf inflating: NotoSansTifinagh-Regular.ttf inflating: NotoSansVai-Regular.ttf inflating: NotoSansYi-Regular.ttf inflating: NotoSerifTibetan-Bold.ttf inflating: NotoSerifTibetan-Regular.ttf Created symlink /etc/systemd/system/multi-user.target.wants/updatedb.service → /etc/systemd/system/updatedb.service. </code></pre> <pre><code>vagrant@bookworm:~$ sudo journalctl -u updatedb -f Nov 23 19:22:54 bookworm osm2pgsql-replication[7785]: 2024-11-23 19:22:54 Done postprocessing on table 'planet_osm_nodes' in 0s Nov 23 19:22:54 bookworm osm2pgsql-replication[7785]: 2024-11-23 19:22:54 Done postprocessing on table 'planet_osm_ways' in 0s Nov 23 19:22:54 bookworm osm2pgsql-replication[7785]: 2024-11-23 19:22:54 Done postprocessing on table 'planet_osm_rels' in 0s Nov 23 19:22:54 bookworm osm2pgsql-replication[7785]: 2024-11-23 19:22:54 All postprocessing on table 'planet_osm_hstore_point' done in 0s. Nov 23 19:22:54 bookworm osm2pgsql-replication[7785]: 2024-11-23 19:22:54 All postprocessing on table 'planet_osm_hstore_line' done in 0s. Nov 23 19:22:54 bookworm osm2pgsql-replication[7785]: 2024-11-23 19:22:54 All postprocessing on table 'planet_osm_hstore_roads' done in 0s. Nov 23 19:22:54 bookworm osm2pgsql-replication[7785]: 2024-11-23 19:22:54 All postprocessing on table 'planet_osm_hstore_polygon' done in 0s. Nov 23 19:22:54 bookworm osm2pgsql-replication[7785]: 2024-11-23 19:22:54 All postprocessing on table 'planet_osm_hstore_route' done in 0s. Nov 23 19:22:54 bookworm osm2pgsql-replication[7785]: 2024-11-23 19:22:54 Storing properties to table '"public"."osm2pgsql_properties"'. Nov 23 19:22:54 bookworm osm2pgsql-replication[7785]: 2024-11-23 19:22:54 osm2pgsql took 6s overall. Nov 23 19:23:00 bookworm osm2pgsql-replication[4791]: 2024-11-23 19:23:00 [INFO]: Data imported until 2024-11-21T13:06:41Z. Backlog remaining: 2 day(s) 6 hour(s) 16 minute(s) 19 second(s) Nov 23 19:23:19 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:19 osm2pgsql version 2.0.0 Nov 23 19:23:19 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:19 Database version: 15.8 (Debian 15.8-0+deb12u1) Nov 23 19:23:19 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:19 PostGIS version: 3.3 Nov 23 19:23:19 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:19 Loading properties from table '"public"."osm2pgsql_properties"'. Nov 23 19:23:19 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:19 Not using flat node file (same as on import). Nov 23 19:23:19 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:19 Using output 'flex' (same as on import). Nov 23 19:23:19 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:19 Using style file '/srv/tile/sources/osml10n/openstreetmap-carto-hstore-only-l10n.lua' (same as on import). Nov 23 19:23:19 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:19 Storing properties to table '"public"."osm2pgsql_properties"'. Nov 23 19:23:19 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:19 Storing properties to table '"public"."osm2pgsql_properties"'. Nov 23 19:23:19 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:19 WARNING: You should use the syntax 'object:get_bbox()' (with the colon, not a point) to call functions on the OSM object. Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: [408B blob data] Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 Processed 75007 nodes in 1s - 75k/s Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 Processed 13579 ways in 3s - 5k/s Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 Processed 365 relations in 2s - 182/s Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 Going over 20 pending ways Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 Processing 20 pending ways took 0s at a rate of 0.00/s Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 Going over 13 pending relations Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 Processing 13 pending relations took 0s at a rate of 0.00/s Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 Skipping stage 1c for nodes (no marked nodes). Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 Skipping stage 1c for ways (no marked ways). Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 No marked nodes or ways (Skipping stage 2). Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 Done postprocessing on table 'planet_osm_nodes' in 0s Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 Done postprocessing on table 'planet_osm_ways' in 0s Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 Done postprocessing on table 'planet_osm_rels' in 0s Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 All postprocessing on table 'planet_osm_hstore_point' done in 0s. Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 All postprocessing on table 'planet_osm_hstore_line' done in 0s. Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 All postprocessing on table 'planet_osm_hstore_roads' done in 0s. Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 All postprocessing on table 'planet_osm_hstore_polygon' done in 0s. Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 All postprocessing on table 'planet_osm_hstore_route' done in 0s. Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 Storing properties to table '"public"."osm2pgsql_properties"'. Nov 23 19:23:25 bookworm osm2pgsql-replication[7888]: 2024-11-23 19:23:25 osm2pgsql took 6s overall. Nov 23 19:23:32 bookworm osm2pgsql-replication[4791]: 2024-11-23 19:23:32 [INFO]: Data imported until 2024-11-21T13:38:15Z. Backlog remaining: 2 day(s) 5 hour(s) 45 minute(s) 17 second(s) Nov 23 19:23:55 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:23:55 osm2pgsql version 2.0.0 Nov 23 19:23:55 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:23:55 Database version: 15.8 (Debian 15.8-0+deb12u1) Nov 23 19:23:55 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:23:55 PostGIS version: 3.3 Nov 23 19:23:55 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:23:55 Loading properties from table '"public"."osm2pgsql_properties"'. Nov 23 19:23:55 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:23:55 Not using flat node file (same as on import). Nov 23 19:23:55 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:23:55 Using output 'flex' (same as on import). Nov 23 19:23:55 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:23:55 Using style file '/srv/tile/sources/osml10n/openstreetmap-carto-hstore-only-l10n.lua' (same as on import). Nov 23 19:23:55 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:23:55 Storing properties to table '"public"."osm2pgsql_properties"'. Nov 23 19:23:55 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:23:55 Storing properties to table '"public"."osm2pgsql_properties"'. Nov 23 19:23:55 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:23:55 WARNING: You should use the syntax 'object:get_bbox()' (with the colon, not a point) to call functions on the OSM object. Nov 23 19:24:01 bookworm osm2pgsql-replication[8007]: [537B blob data] Nov 23 19:24:01 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:01 Processed 79789 nodes in 2s - 40k/s Nov 23 19:24:01 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:01 Processed 13820 ways in 3s - 5k/s Nov 23 19:24:01 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:01 Processed 365 relations in 1s - 365/s Nov 23 19:24:01 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:01 Going over 32 pending ways Nov 23 19:24:01 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:01 Processing 32 pending ways took 0s at a rate of 0.00/s Nov 23 19:24:01 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:01 Going over 32 pending relations Nov 23 19:24:02 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:02 Processing 32 pending relations took 0s at a rate of 0.00/s Nov 23 19:24:02 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:02 Skipping stage 1c for nodes (no marked nodes). Nov 23 19:24:02 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:02 Skipping stage 1c for ways (no marked ways). Nov 23 19:24:02 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:02 No marked nodes or ways (Skipping stage 2). Nov 23 19:24:02 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:02 Done postprocessing on table 'planet_osm_nodes' in 0s Nov 23 19:24:02 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:02 Done postprocessing on table 'planet_osm_ways' in 0s Nov 23 19:24:02 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:02 Done postprocessing on table 'planet_osm_rels' in 0s Nov 23 19:24:02 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:02 All postprocessing on table 'planet_osm_hstore_point' done in 0s. Nov 23 19:24:02 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:02 All postprocessing on table 'planet_osm_hstore_line' done in 0s. Nov 23 19:24:02 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:02 All postprocessing on table 'planet_osm_hstore_roads' done in 0s. Nov 23 19:24:02 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:02 All postprocessing on table 'planet_osm_hstore_polygon' done in 0s. Nov 23 19:24:02 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:02 All postprocessing on table 'planet_osm_hstore_route' done in 0s. Nov 23 19:24:02 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:02 Storing properties to table '"public"."osm2pgsql_properties"'. Nov 23 19:24:02 bookworm osm2pgsql-replication[8007]: 2024-11-23 19:24:02 osm2pgsql took 6s overall. Nov 23 19:24:07 bookworm osm2pgsql-replication[4791]: 2024-11-23 19:24:07 [INFO]: Data imported until 2024-11-21T14:18:45Z. Backlog remaining: 2 day(s) 5 hour(s) 5 minute(s) 22 second(s) Nov 23 19:24:28 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:28 osm2pgsql version 2.0.0 Nov 23 19:24:28 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:28 Database version: 15.8 (Debian 15.8-0+deb12u1) Nov 23 19:24:28 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:28 PostGIS version: 3.3 Nov 23 19:24:28 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:28 Loading properties from table '"public"."osm2pgsql_properties"'. Nov 23 19:24:28 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:28 Not using flat node file (same as on import). Nov 23 19:24:28 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:28 Using output 'flex' (same as on import). Nov 23 19:24:28 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:28 Using style file '/srv/tile/sources/osml10n/openstreetmap-carto-hstore-only-l10n.lua' (same as on import). Nov 23 19:24:28 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:28 Storing properties to table '"public"."osm2pgsql_properties"'. Nov 23 19:24:28 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:28 Storing properties to table '"public"."osm2pgsql_properties"'. Nov 23 19:24:28 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:28 WARNING: You should use the syntax 'object:get_bbox()' (with the colon, not a point) to call functions on the OSM object. Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: [468B blob data] Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 Processed 89837 nodes in 2s - 45k/s Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 Processed 13210 ways in 3s - 4k/s Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 Processed 303 relations in 2s - 152/s Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 Going over 78 pending ways Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 Processing 78 pending ways took 0s at a rate of 0.00/s Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 Going over 28 pending relations Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 Processing 28 pending relations took 0s at a rate of 0.00/s Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 Skipping stage 1c for nodes (no marked nodes). Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 Skipping stage 1c for ways (no marked ways). Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 No marked nodes or ways (Skipping stage 2). Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 Done postprocessing on table 'planet_osm_nodes' in 0s Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 Done postprocessing on table 'planet_osm_ways' in 0s Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 Done postprocessing on table 'planet_osm_rels' in 0s Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 All postprocessing on table 'planet_osm_hstore_point' done in 0s. Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 All postprocessing on table 'planet_osm_hstore_line' done in 0s. Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 All postprocessing on table 'planet_osm_hstore_roads' done in 0s. Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 All postprocessing on table 'planet_osm_hstore_polygon' done in 0s. Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 All postprocessing on table 'planet_osm_hstore_route' done in 0s. Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 Storing properties to table '"public"."osm2pgsql_properties"'. Nov 23 19:24:35 bookworm osm2pgsql-replication[8110]: 2024-11-23 19:24:35 osm2pgsql took 6s overall. Nov 23 19:24:45 bookworm osm2pgsql-replication[4791]: 2024-11-23 19:24:45 [INFO]: Data imported until 2024-11-21T14:51:13Z. Backlog remaining: 2 day(s) 4 hour(s) 33 minute(s) 32 second(s) .... Nov 24 08:40:32 bookworm systemd[1]: updatedb.service: Consumed 1.415s CPU time. Nov 24 08:41:22 bookworm systemd[1]: updatedb.service: Scheduled restart job, restart counter is at 496. Nov 24 08:41:22 bookworm systemd[1]: Stopped updatedb.service - render database update. Nov 24 08:41:22 bookworm systemd[1]: updatedb.service: Consumed 1.415s CPU time. Nov 24 08:41:22 bookworm systemd[1]: Starting updatedb.service - render database update... Nov 24 08:41:22 bookworm systemd[1]: Started updatedb.service - render database update. Nov 24 08:41:22 bookworm osm2pgsql-replication[120519]: 2024-11-24 08:41:22 [INFO]: Using replication service 'https://planet.openstreetmap.org/replication/minute'. Nov 24 08:41:24 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:24 osm2pgsql version 2.0.0 Nov 24 08:41:24 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:24 Database version: 15.10 (Debian 15.10-0+deb12u1) Nov 24 08:41:24 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:24 PostGIS version: 3.3 Nov 24 08:41:24 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:24 Loading properties from table '"public"."osm2pgsql_properties"'. Nov 24 08:41:24 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:24 Not using flat node file (same as on import). Nov 24 08:41:24 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:24 Using output 'flex' (same as on import). Nov 24 08:41:24 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:24 Using style file '/srv/tile/sources/osml10n/openstreetmap-carto-hstore-only-l10n.lua' (same as on import). Nov 24 08:41:24 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:24 Storing properties to table '"public"."osm2pgsql_properties"'. Nov 24 08:41:24 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:24 Storing properties to table '"public"."osm2pgsql_properties"'. Nov 24 08:41:24 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:24 WARNING: You should use the syntax 'object:get_bbox()' (with the colon, not a point) to call functions on the OSM object. Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: [144B blob data] Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 Processed 765 nodes in 0s - 765/s Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 Processed 171 ways in 0s - 171/s Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 Processed 9 relations in 1s - 9/s Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 Going over 2 pending ways Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 Processing 2 pending ways took 0s at a rate of 0.00/s Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 Going over 2 pending relations Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 Processing 2 pending relations took 0s at a rate of 0.00/s Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 Skipping stage 1c for nodes (no marked nodes). Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 Skipping stage 1c for ways (no marked ways). Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 No marked nodes or ways (Skipping stage 2). Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 Done postprocessing on table 'planet_osm_nodes' in 0s Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 Done postprocessing on table 'planet_osm_ways' in 0s Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 Done postprocessing on table 'planet_osm_rels' in 0s Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 All postprocessing on table 'planet_osm_hstore_point' done in 0s. Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 All postprocessing on table 'planet_osm_hstore_line' done in 0s. Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 All postprocessing on table 'planet_osm_hstore_roads' done in 0s. Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 All postprocessing on table 'planet_osm_hstore_polygon' done in 0s. Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 All postprocessing on table 'planet_osm_hstore_route' done in 0s. Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 Storing properties to table '"public"."osm2pgsql_properties"'. Nov 24 08:41:25 bookworm osm2pgsql-replication[120525]: 2024-11-24 08:41:25 osm2pgsql took 0s overall. Nov 24 08:41:25 bookworm osm2pgsql-replication[120519]: 2024-11-24 08:41:25 [INFO]: Data imported until 2024-11-24T08:40:44Z. Backlog remaining: 41 second(s) Nov 24 08:41:26 bookworm systemd[1]: updatedb.service: Deactivated successfully. Nov 24 08:41:26 bookworm systemd[1]: updatedb.service: Consumed 1.409s CPU time. Nov 24 08:42:16 bookworm systemd[1]: updatedb.service: Scheduled restart job, restart counter is at 497. Nov 24 08:42:16 bookworm systemd[1]: Stopped updatedb.service - render database update. Nov 24 08:42:16 bookworm systemd[1]: updatedb.service: Consumed 1.409s CPU time. Nov 24 08:42:16 bookworm systemd[1]: Starting updatedb.service - render database update... Nov 24 08:42:16 bookworm systemd[1]: Started updatedb.service - render database update. Nov 24 08:42:16 bookworm osm2pgsql-replication[120565]: 2024-11-24 08:42:16 [INFO]: Using replication service 'https://planet.openstreetmap.org/replication/minute'. Nov 24 08:42:17 bookworm osm2pgsql-replication[120565]: 2024-11-24 08:42:17 [INFO]: Database already up-to-date. Nov 24 08:42:17 bookworm systemd[1]: updatedb.service: Deactivated successfully. ... </code></pre> <p>OpenStreetMap Carto German Version v5.9.0-de0 und Localization functions for Openstreetmap (osml10n) Version v1.2.1 sind korrekte Version:</p> <p><img src="https://codeberg.org/astrid/vollweltkost_tilemaker/attachments/0764ba0b-a37c-4bce-a285-ca3388eeec05" alt=""></p> </div> <nav class='secondary-actions'> <ul class='clearfix'> <li><a href="/user/aselnigu/diary/405654#newcomment">Comment on this entry</a></li> <li><a href="/message/new/aselnigu?message%5Btitle%5D=Re%3A+Aktualisierung+von+osm2pgsql+mithilfe+von+Vagrant+und+Ansible.">Send a message to the author</a></li> <li> <a href="/user/aselnigu/diary/405654#comments">No comments</a> </li> </ul> </nav> </article> <article class='diary_post border-top border-secondary-subtle py-3 user_22213333'> <div class='mb-3'> <div class="row"> <div class="col-auto"> <img class="user_thumbnail border border-secondary-subtle bg-body" alt="" width="50" height="50" src="https://www.openstreetmap.org/rails/active_storage/representations/redirect/eyJfcmFpbHMiOnsiZGF0YSI6MzQzNTI5NzksInB1ciI6ImJsb2JfaWQifX0=--a03927ace5bab4bd0b0a4e4f6c85912a312e2226/eyJfcmFpbHMiOnsiZGF0YSI6eyJmb3JtYXQiOiJqcGciLCJyZXNpemVfdG9fbGltaXQiOls1MCw1MF19LCJwdXIiOiJ2YXJpYXRpb24ifX0=--dea07cf4fabdae9c56d9008d879a5332bbf580ce/Picsart_24-02-02_07-15-35-497.jpg" /> </div> <div class="col"> <h2><a href="/user/a8j/diary/405653">a8j</a></h2> </div> </div> <small class='text-body-secondary'> Posted by <a href="/user/a8j">a8j</a> on 23 November 2024 in <a href="/diary/ar">Arabic (العربية)</a>. </small> </div> <div class="richtext text-break" xml:lang="ar" lang="ar"> <h1 id="instagram">instagram</h1> <p><a href="https://www.instagram.com/a8j" rel="nofollow noopener noreferrer">www.instagram.com/a8j</a></p> </div> <nav class='secondary-actions'> <ul class='clearfix'> <li><a href="/user/a8j/diary/405653#newcomment">Comment on this entry</a></li> <li><a href="/message/new/a8j?message%5Btitle%5D=Re%3A+a8j">Send a message to the author</a></li> <li> <a href="/user/a8j/diary/405653#comments">No comments</a> </li> </ul> </nav> </article> <article class='diary_post border-top border-secondary-subtle py-3 user_22213333'> <div class='mb-3'> <div class="row"> <div class="col-auto"> <img class="user_thumbnail border border-secondary-subtle bg-body" alt="" width="50" height="50" src="https://www.openstreetmap.org/rails/active_storage/representations/redirect/eyJfcmFpbHMiOnsiZGF0YSI6MzQzNTI5NzksInB1ciI6ImJsb2JfaWQifX0=--a03927ace5bab4bd0b0a4e4f6c85912a312e2226/eyJfcmFpbHMiOnsiZGF0YSI6eyJmb3JtYXQiOiJqcGciLCJyZXNpemVfdG9fbGltaXQiOls1MCw1MF19LCJwdXIiOiJ2YXJpYXRpb24ifX0=--dea07cf4fabdae9c56d9008d879a5332bbf580ce/Picsart_24-02-02_07-15-35-497.jpg" /> </div> <div class="col"> <h2><a href="/user/a8j/diary/405652">حسين حيدر</a></h2> </div> </div> <small class='text-body-secondary'> Posted by <a href="/user/a8j">a8j</a> on 23 November 2024 in <a href="/diary/ar">Arabic (العربية)</a>. </small> </div> <div class="richtext text-break" xml:lang="ar" lang="ar"> <h1 id="section">مرشد محلي</h1> <ol> <li>عراقي من مدينة طوزخورماتو</li> </ol> </div> <nav class='secondary-actions'> <ul class='clearfix'> <li><a href="/user/a8j/diary/405652#newcomment">Comment on this entry</a></li> <li><a href="/message/new/a8j?message%5Btitle%5D=Re%3A+%D8%AD%D8%B3%D9%8A%D9%86+%D8%AD%D9%8A%D8%AF%D8%B1">Send a message to the author</a></li> <li> <a href="/user/a8j/diary/405652#comments">No comments</a> </li> </ul> </nav> </article> <nav> <ul class="pagination"> <li class="page-item d-flex disabled"> <span class="page-link icon-link text-center"> <svg width="10" height="15" viewBox="-10 0 10 15" class="flex-shrink-0 d-none d-sm-block"><path d="M-2,2 l-5.5,5.5 l5.5,5.5" fill="none" stroke="currentColor" stroke-width="1.5" /></svg> Newer Entries </span> </li> <li class="page-item d-flex"> <a class="page-link icon-link text-center" data-turbo="true" data-turbo-frame="pagination" data-turbo-action="advance" href="/diary?before=405652"> Older Entries <svg width="10" height="15" class="flex-shrink-0 d-none d-sm-block"><path d="M2,2 l5.5,5.5 l-5.5,5.5" fill="none" stroke="currentColor" stroke-width="1.5" /></svg> </a> </li> </ul> </nav> </turbo-frame> </div> </div> </div> <noscript><p><img src="https://matomo.openstreetmap.org/matomo.php?idsite=1" class="matomo" alt="" /></p></noscript> </body> </html>