devALPO 2026

President of OSGeo Suomi ry will open the devALPO

Our sponsor will speak

OSGeo Community Sprint was organized in Riga (Latvia) in September 2025 as part of the Big Data from Space 2025 (BiDS) event. I participated the sprint for 3 days and I will tell generally about the results of the sprint and about my own feelings.

Mitä Oskarissa on tapahtunut viime aikoina ja mitä on tiedossa lähitulevaisuudessa.

We've added FlatGeobuf read support to hakunapi. The implementation supports full OGC API Features compliance including CQL2 filtering, with configuration as simple as pointing to a .fgb file - local or remote.

Key practical benefits include excellent local file performance via memory-mapped I/O and spatial indexing, plus HTTP range request support for querying remote files directly from object storage. Schema discovery is automatic, and hakunapi's streaming architecture keeps memory overhead minimal.

For read-heavy workloads with infrequent updates, this offers a leaner, faster alternative to popular solutions with significantly lower runtime overhead. It's suited for publishing authoritative datasets where operational simplicity and performance matter.

Managing Finland's topographic data requires more than just a simple database. In this talk, we'll explore how National Land Survey of Finland leveraged PostgreSQL and PostGIS to build a robust database system enabling hundreds of simultaneous editors, intelligent conflict management, automatic elevation updates, and a complete history for every topographic feature.

Local LLM development with Ollama, Qwen3-Code:30B and Visual Studio Code.

Closing devALPO