My kid got a new project: find fire stations. Google Maps is not really helpful here, obviously. And searching in the OpenStreetMap web interface is also a lot of work. But Overpass Turbo is able to find all the places.
Continue reading "Find fire stations in OpenStreetMap using Overpass Turbo"
As reference for me: find benches with missing access tag in JOSM when editing OpenStreetMap:
amenity=bench -access=* inview
As reference for me: find buildings with missing tags in JOSM when editing OpenStreetMap:
This posting is mainly a reference for myself, because I was looking for this specific issue a couple times.
OpenStreetMap (OSM) is a map of the world, created by anyone who wants to contribute. It so happens that data might be missing (just go and add it, if you see that something is not on the map). It also happens that someone adds too much data.
In my case someone added "Wikidata" entries to each and every footpath.The OSM folks in Berlin made a great effort to find the etymology of names, and add them to Wikidata. And then link the street names to the Wikidata entries. That's nice and very useful, but it's enough to do that for streets. Not for every path, including the underground parking.
I raised this in the Berlin Telegram channel, and we agreed that it's best to keep the etymology tags to the main streets. Now I had to find all the entries which were tagged with a Wikidata entry, and update most of them.
Continue reading "Search objects based on a specific criteria (Key:name:etymology) in JOSM"
In 2019 I was in Cuba for a conference that took place there.
During the preparation of the trip it occured to me that internet access in the country is on the one hand slow and not well developed. On the other hand, that mobile internet access via roaming is obscenely expensive. It was foreseeable that I would have to do without mobile internet for a week, and consequently without online navigation. Preparations are in order.
Continue reading "Traveling in Cuba (offline)"
2019 war ich auf Kuba, für eine Konferenz welche dort stattgefunden hat.
Bei der Vorbereitung der Reise stellte sich heraus dass der Internetzugang im Land einerseits langsam ist, und nicht gut ausgebaut. Und andererseits dass der mobile Internetzugang über Roaming obszön teuer ist. Es war also abzusehen dass ich eine Woche ohne mobiles Internet auskommen muss, und demzufolge auch ohne online Navigation. Vorbereitungen waren notwendig.
Continue reading "Unterwegs auf Kuba (offline)"
OpenStreetMap is an awesome project. Contributors constantly improve a online map and add new data, fix items in the map which did change in the real world, or improve the data for a number of projects (1, 2, 3, 4, 5, 6, List) building on top of the map. Being outside a lot, I figured that I can contribute as well. It's just a question of how to transport the data from "out there" back to the laptop in my office. After probing around and trying a few tools, I came up with 3 different ways, depending on the situation and amount of changes.
Continue reading "How I improve OpenStreetMap"
What happens, if you ask the Chinese PostgreSQL community for a Meetup-like event, one or two speakers? You end up getting a full day conference ;-)
On September 12, Saturday, a full day PostgreSQL conference will take place at the Pivotal office in Beijing. If you want to attend, please sign up here.
The full address is: 17/F, South Block, Tower C, Raycom Info Tech Park, NO.2, Kexueyuan South Road, Beijing 100190, China.
Continue reading "PostgreSQL Day in Beijing"