Jddjdjd

adventure

ini perjalanan yang panjang

Story

Lini masa sejak Januari hingga Agustus

Apalah

Casale Cima

Santa Cristina fraz. di Borgomanero (NO) 28021, Piemonte

24/08/2026, San Bartolomeo

E’ il santo patrono di Borgomanero e Santa Cristina, essendo che si festeggia il 24 luglio, non dovrebbe c’entrare niente, invece le pochissime attività e servizi pubblici sono chiusi anche oggi.

C’è da dire che ho apportato un po’ di modifiche alla mappa del territorio locale, oggi. Munita di mappali del Catasto di Novara, comune di Borgomanero, Foglio: 21 e Particelle: varie (es.: 191 - 193-194, etc.) ed in territorio di Gattico-Veruno, Foglio: 1, sono riuscita a ricollocare esattamente i confini dei nostri terreni, discendenti dei fratelli Valsesia Angelo Maria e Carlo, i quali avevano acquistato l’intera cascina, con tutto il territorio annesso, nel secolo scorso, dai conti Busti, a loro volta eredi dei nobili possidenti Morbio-Zapelono. Il conte Paolo Busti, a fine 1800, fece costruire le “case masserezze” per i fittavoli che lavoravano le terre, area denominata poi “La Moretta”. Casa mia era detta la Ca’ Nova, poiché era l’unica non annessa al casale vero e proprio, essendo infatti una casa indipendente con giardino, costruita intorno al 1960 e non risalente al 1700 come gli edifici adibiti ad abitazione e quelli usati come stalle e fienili del Casale Cima, originariamente chiamato Sopramonte, per il rilievo su cui si colloca.

Thanks to the work of several contributors, the usage of name:fur tag in OpenStreetMap is constantly increasing and there is now a pretty good coverage of Friuli region at place level (and even down to street-level in some parts of it). This tag represents a name in Friulian language, mainly spoken in north-east Italy.

This tag is visible today in a dedicated rendering (which I created) on mapefurlane.eu and in the various multi-lingual maps like the great Americana.

Apart from the maps, another interesting use of this data is to have lists of toponyms. For Friulian language, there is already a list provided by an official organization, but besides not being very detailed, it’s also quite static (PDF). So I wanted to have something better than that by leveraging all OSM data.

My main goal then was to create a searchable web page that could show the toponyms of Friuli historical region, not only in Friulian, but also in all recognized languages, i.e. Friulian, Italian, German and Slovenian. The list should be updated automatically from OSM data.

What is DuckDB

DuckDB is an open source in-process SQL OLAP database management system. It has a builtin spatial extension that can import PBF files which can be then queried using SQL syntax.

Using DuckDB with OpenStreetmap

Since I already had a daily pipeline (GitHub Action) to update Mape Furlane that used a PBF extract as input, integrating DuckDB there was immediate: just adding the single binary, loading the PBF and then all the data was available for querying.

From that I added a few SQL queries visible on https://github.com/andreadecorte/mapefurlane/tree/main/scripts/duckdb that generate 2 output files: 1. all places with name:fur tag and all the other name: tags (name:it, name:de, name:sl) 2. all places in the area without a name:fur tag with a Markdown output (to help increase the coverage)

… See full entry

Kurnus

Doom Scrolling through aerial images of Canada revealed this to me:

And for a millisecond I wondered how this could be mapped. Maybe tourism=attraction? 🤪

Letztens beim Doom-Scrolling über die OSM-Karte in Oschersleben einen langen grünen Strich gesehen und gedacht, “okay, lange Hecke oder was?”

Oder wieder Vandalismus a.k.a. FCK.PTN?

Beim Editieren habe ich dann gesehen, dass jemand den Anfang der Hecke wohl versehentlich weit weg verschoben hat. Ich konnte die Hecke dann reparieren: osm.org/way/301454013

Being a YouthMapper?

… See full entry

Willkommen im Outback-Lindlar!

Ab sofort ist das Outback-Lindlar (Klauserstraße 77 in 51789 Lindlar) auch auf OpenStreetMap präsent. Als gemütliches Themenrestaurant im Bergischen Land freuen wir uns über alle Gäste, Tourenfahrer und Biker, die bei uns einen Zwischenstopp einlegen.

Kommt vorbei auf gute Küche, erfrischende Drinks und eine tolle Atmosphäre. Schaut gerne rein!