#PostGIS 3.6.0beta1 released
#PostGIS 3.6.0beta1 released
Discover PostGIS Functions with ST_Letters
#PostGIS is full of superpower. Get to know the ST_Letters function that allows you to visualize the results of PostGIS functions with letters. You will like it!
Find some SQL examples, introduction, #QGIS project and video at https://talks.osgeo.org/foss4g-europe-2025/talk/PNYWM8/
It was fun preparing & presenting this feature at #FOSS4GE2025.
#FOSSGIS #FOSS4G #OSGeo #FOSS4GE
Hm. I normally use https://github.com/pgautoupgrade/docker-pgautoupgrade whenever I need to deploy a #postgres container because I can just increase the version in my #Ansible playbooks to perform an upgrade.
Now I need #postgis for #dawarich and there doesn't seem to be such a convenient fork to ease future upgrades.
Am I missing something? Do I really want to bother future-me with manual upgrades that may include dumping, updating and restoring? Or would I just add these steps to my playbook?
Call for Papers extended!
Still in holiday mode? So are we!
New deadline: **8 August 2025**
PostgreSQL, PostGIS, R, GeoServer, QGIS… whatever your geo-thing is — we want to hear about it!
Talks, lightning talks, workshops
In English, French or Dutch
10 years of #FOSS4GBE!
Submit: [https://shorturl.at/0Pgie]
Questions? info@foss4g.be
We hope you enjoyed the workshop about #PostgreSQL #PostGIS at #FOSS4GE2025 with @Enock4seth and me.
You find the workshop material at https://github.com/astroidex/foss4g-europe-2025-workshop-manage-your-geospatial-data-with-postgresql-postgis-astrid-emde/tree/main
Enjoy the #FOSS4GE conference and feel free to contact me for further discussion.
#FOSS4GE2025 starts today's with several workshops. Together with @Enock4seth we want to inspire people using #osgeo Software. Hope you like @osgeolive #postgis #qgis #mapbender #foss4ge #osgeo #fossgis
Im Juli macht die @FOSS_Acasdemy Sommerpause. Ab August geht's weiter mit vielen spannenden Open-Source-GIS-Schulungen!
Sichern Sie sich jetzt einen der noch verbleibenden Plätze.
Die FOSS Academy bietet Kurse rund um #Mapbender #QGIS #MapServer #PostGIS #GeoServer #ALKIS 5-tägiger Kompaktkurs & mehr.
Bis zu 6 Wochen vor Schulungsbeginn erhalten Sie 10% Frühbucherrabatt!
Jetzt anmelden!
#FOSSGIS #GIS #GEOSPATIAL #FOSS4G #OSGeo #QGIS
29: Happy Birthday PostgreSQL! https://geoobserver.de/2025/07/08/29-happy-birthday-postgresql/ #PostgreSQL #gistribe #gischat #fossgis #foss4g #OSGeo #spatial #geospatial #opensource #PostGIS #qgis #switch2qgis #gis #geo #geoObserver pls RT @postgresql @planetpostgres
Criei um repositório em português, para quem quiser experimentar um #HelloWorld
para publicar mapas com #OGCAPI Features, Tiles e Maps #pygeoapi #postgis #geopackage #DGT https://github.com/byteroad/ola-ogcapi
Part 1 of our #CircularArcs crowdfunding is fully funded – 112K CHF raised!
We’re very close to securing Part 2 too – just 13K CHF to go to bring full arc support into #QGIS!
We've extended the campaign until the end of July!
Join in https://buff.ly/lO4z17a
J'ai fait une app pour trouver un fast-food près de chez soi.
https://carte.lacasa.fr/
L'app n'a rien de fou en elle même, ce qui était intéressant c'est de découvrir Martin (https://martin.maplibre.org/), qui permets de générer des tuiles vectorielles
La partie intéressante, le code source et les explications, sont sur Git : https://framagit.org/glacasa/cartes
A l'heure où l'on parle de souveraineté sur l'ensemble des services numériques, l'information géographique a atteint un niveau de maturité incroyable.
La gestion des données spatiales de référence de Finlande bascule sur des technologies open source et libres. #QGIS et #postgresql #postgis au moins au menu.
L'ouverture des formats de données, l'intéropérabilité, la mutualisation sur les outils avec les autorités publiques sont mises en avant :
BDay: 13 Jahre #geoObserver! https://geoobserver.de/2025/06/25/bday-13-jahre-geoobserver/ #gistribe #gischat #fossgis #foss4g #OSGeo #spatial #geospatial #opensource #PostGIS #PostgreSQL #mapping #DataViz #mapserver #opendata #osm #openstreetmap #geoserver #qgis #switch2qgis #gdal #geos #gis #geo #geoObserver pls RT
MDS in geo: An example with Mapillary: Two articles by Michaël Galien on @geotribu showcase how to leverage a Modern Data Stack (#MDS) for processing geospatial data from #Mapillary. The workflow features #dbt, Apache #Airflow, #PostGIS, #SQL, and #Python, highlighting a robust...
https://spatialists.ch/posts/2025/06/09-mds-in-geo-an-example-with-mapillary/ #GIS #GISchat #geospatial #SwissGIS
Im Juli machen wir Sommerpause.
Ab August gibt es dann wieder spannende Kurse rund um #Mapbender #QGIS #MapServer #PostGIS #GeoServer #ALKIS & mehr.
Sichern Sie sich jetzt schon Plätze! Bis zu 6 Wochen vor Schulungsbeginn erhalten Sie 10% Frühbucherrabatt!
Jetzt anmelden!
https://www.foss-academy.com
#PostGIS 3.5.3 released
#RStats #PostgreSQL #PostGIS question!
Is there a sensible -- no, *ideal* -- way to store spatiotemporal raster/NetCDFs in a PostgreSQL database? Ideally one which can still be easily queried in R.
My default approach of just converting them into dataframes and pushing everything to a database a) seems very inefficient, and b) *definitely* takes up more space than we have available in the database.
I think we could technically ask for more space, and insert indices to make using that data faster, but...seems like the wrong direction and not worth the effort.
WhereGroup Shorts feierten Premiere!
Über 550 Teilnehmende erlebten spannende #PostgreSQL & #PostGIS Impulse – von Einsteiger bis Profi.
Danke für das tolle Feedback und an unser Team!
Alle Vorträge jetzt im Archiv: https://wheregroup.com/shorts/archiv/
Am 9.10.2025 geht’s weiter mit #QGIS & #OpenSource #Geodaten.
Save the date!
ALKIS-NAS-Daten mit Open-Source-Software nutzen
Online-Schulung der @foss_academy rund um ALKIS & die PostNAS-Suite.
Es sind noch Plätze frei!
Online-Schulung an 4 Vormittagen
jeweils von 9:00 bis 12:00 Uhr
19.-22.08.2025
https://foss-academy.com/alkis-nas-daten-mit-open-source-software-nutzen/
#FOSSGIS #WebGIS #GDI #GEOSPATIAL #OSGeo #FOSS4G @WhereGroup_com #QGIS #PostGIS #MapServer #PostgreSQl #Mapbender