Stefan F. Keller

Hi Ads. You could add Bluesky to your "Get social" slide in your latest talk 😉

Habe die Slides für meine beiden Vorträge auf den Kieler Linux Tagen online gestellt:

andreas.scherbaum.la/writings/

Backups mit Restic und resticprofile

Füge Geokoordinaten zu deinen Adressen in PostgreSQL hinzu

#Backup #Restic #PostgreSQL #PostGIS #OSM #OpenStreetMap #Kiel #Kielux #Linux

New blog post on @mapterhorn.com - terrain for web mapping

protomaps.com/blog/mapterh...

TIL that #Mapycom is more than just a renderer on top of #OpenStreetMap. They actually import buildings from #Overture, which #OSM doesn't consider reliable enough for automatic imports.

From what I've seen, the results are mixed in Greece, with many buildings that don't exist in reality.

... or see also EveryDoor every-door.app

See also OSMyBiz osmybiz.osm.ch

OpenStreetMap OpenStreetMap is a map of the world, created by people like you and free to use under an open license.

Ever wondered why your company or favorite shop isn’t shown on many maps?
Because the marketing guy can’t think beyond google.
The good news: you can easily fix it yourself:
1. Create an #openstreetmap ( #OSM) account;
2. Improve the map at openstreetmap.org or (easier to start): mapcomplete.org

A montage of maps overlaid with the text "Celebrating the 21st anniversary of OpenStreetMap with a new post"

A montage of maps overlaid with the text "looking back on Stamen and OpenStreetMap through the years"

This month #OpenStreetMap turns 21!

To mark the occasion, we dug into our archives to finish part 3 of Stamen's personal history of OSM, covering the years 2016 to the present. Check it out on our blog, including links to part 1 and 2 of the series:

stamen.com/part-3-our-b...

know.bi contributions to Apache Hop (July 4–11):
🔸 #Google Sheets proxy support
🔸 #Databricks support begins
🔸 Metrics + #Git doc updates
🔸 #XML Join improvements

@hop.apache.org
#apachehop #opensource #etl #databs #datasky

State of the Map 2025 – Manila The global OpenStreetMap conference. 2025 in Manila & online.

There's still to get your ticket for State of the Map 2025! @sotm

2025.stateofthemap.org/tickets/
#sotm2025 #OpenStreetMap

NACIS.ORG The North American Cartographic Information Society (NACIS) is an enjoyable society of map enthusiasts. We have yearly meetings, an online discussion forum, and we work on a variety of projects and pu...

🎉 NACIS 2025 Registration is Open! 🎉
Head over to nacis.org/annual-meeting/current-meeting to register at the member or student rate.
Not a member yet? You can join or register as a non-member too!
🕓Early-bird deadline: October 4
🏨Don’t forget to book your hotel too. Our room block fills up fast.

This is way cool. @tjukanov might remember my brainworm about this exact kind of routing

Der Hitze aus dem Weg gehen - «Vampir Modus»: An dieser Navigation hätte Dracula viel Freude Welcher Weg schützt mich vor Hitze? Eine neue Fussgänger-Navigation, der «Vampir-Modus», kennt die schattigsten Routen.

Der Hitze aus dem Weg gehen – "Vampir Modus" - eine neue Fussgänger-Navigation der Fachhochschule OST berechnet die schattigsten Routen.
www.srf.ch/wissen/mobil... #Routing #UrbanHeat #OpenStreetMap @openstreetmap.bsky.social @srfmeteo.bsky.social

The coolest way to find shade paths: Vampire routing on routing.osm.ch Climate change and increasing urbanization are causing more and more heat, which is particularly noticeable these days. Locals and tourists are therefore looking for ways to avoid direct sunlight. Of ...

"The coolest way to find shaded paths: Vampire routing on routing.osm.ch" sosm.ch/the-coolest-...
#Routing #UrbanHeat #OpenData #OSMinside #OpenStreetMap

Erfreuliche Nachrichten gleich zu Beginn des neuen Jahres: Wir dürfen das Hosting von SOSM unterstützen respektive sponsoren. 🙌💯 SO… was? Was ist SOSM? 🤔 Das ist ein Projekt von Freiwilligen, die gemeinsam eine freie Karte der gesamten Welt erstellen: www.osm.ch. 🌍 #sosm #karte #nine

🗞️ Apache Hop Weekly – May 16–23
A week of improved UX, error handling & key upgrades!

🔧 Highlights:
🔹 Cleaner UI for file actions
🔹 Better error handling
🔹 Janino & JGit upgrades
🔹 Apache Hop 2.14.0 is out!

Thanks to all contributors! 🙌
#apachehop #datasky #databs

Beyond Materialized Views: Using DuckDB for In-Process Columnar Caching In this post we will talk about using DuckDB as the operational analytics store for the control plane of Striim Developer — a serverless…

Instead of materialized views, we built in-process DuckDB caching in the control plane of Striim Developer — improving query performance 5–10x with zero added infra.

PostgreSQL for OLTP, DuckDB for Operational OLAP. But I won't call it HTAP 🤐

medium.com/striim/beyon...

GitHub - woodpeck/postpass-ops: operational issues about the Postpass instance run on postpass.geofabrik.de operational issues about the Postpass instance run on postpass.geofabrik.de - woodpeck/postpass-ops

This is actually really exciting news for the right kind of map/OSINT nerd: You can now use Overpass Turbo to query OpenStreetMap data with PostGIS SQL instead of the arcane, limited Overpass Query Language. Or use curl if you prefer. github.com/woodpeck/pos...

What It Takes to Be PostgreSQL Compatible Many systems and tools, including CedarDB, claim to be “PostgreSQL compatible”, but what does that actually mean? In this article, we explain why PostgresSQL compatibility has several layers, what is ...

Many database systems claim to be compatible with PostgreSQL. But what does that really mean?

Find out in our latest blog post and learn more about what it takes to become PostgreSQL compatible.

cedardb.com/blog/postgre...

PostgreSQL JSONB - Powerful Storage for Semi-Structured Data Object-oriented or relational? Why not both? Let's look on PostgreSQL JSONB column type and how it can help you to deliver your applications faster. We dived into how it's stored, when and why it can ...

Wow excellent article en JSONB www.architecture-weekly.com/p/postgresql... by @oskardudycz.bsky.social

Day 14 of the #30DayMapChallenge - World Map
Here is a map of the World's forests.

Morgen Do. 5. Dezember 2024 referiere ich in Zürich zum Thema

"AI/ML-Driven Query #Optimization Using Balsa and LEON".

Nach dem Talk gibt es eine #AskusAnything zur Multi-Model Datenbank #PostgreSQL. Vortrag DE Folien EN. Eintritt frei.

Anmeldung: www.swisspug.org#meetup_2024-12

#Database #AI

#OpenStreetMap inside

Kue AI: Assistant for QGIS User Manual (November 2024) Kue is an AI assistant built directly into QGIS. Kue can style and label your layers, run geoprocessing, and more.

What better first Bluesky post than to show the latest update to Kue, our AI GIS assistant.

Kue can run geoprocessing, filter for data in layers and PostGIS databases, select features by attribute, and style your data

Read more about Kue here: buntinglabs.com/blog/kue-ai-... #gischat