PostGIS Tiger Geocoder 2025.1

The PostGIS development team is pleased to provide postgis_tiger_geocoder extension. This is the very first release since the break from the PostGIS core. This version requires PostgreSQL 16 and above and should work with any supported PostGIS version. PostGIS 3.6 series is the last series to include postgis_tiger_geocoder. PostGIS 3.7 will be shipped without postgis_tiger_geocoder. Moving forward postgis_tiger_geocoder has its own dedicated repo at OSGeo Gitea postgis_tiger_geocoder under the PostGIS org. The versioning model has also changed to be versioned based on the year of the Census US Tiger dataset that is current at time of it’s release.

PostGIS
PostGIS Tiger Geocoder 2025.1

The PostGIS development team is pleased to provide postgis_tiger_geocoder extension. This is the very first release since the break from the PostGIS core. This version requires PostgreSQL 16 and above and should work with any supported PostGIS version. PostGIS 3.6 series is the last series to include postgis_tiger_geocoder. PostGIS 3.7 will be shipped without postgis_tiger_geocoder. Moving forward postgis_tiger_geocoder has its own dedicated repo at OSGeo Gitea postgis_tiger_geocoder under the PostGIS org. The versioning model has also changed to be versioned based on the year of the Census US Tiger dataset that is current at time of it’s release.

PostGIS
I have an pdf vector picture I'd like to upload georeferenced to #postgis. Converting to tif/png is possible but gets unreadable (and still way bigger). I want that as picture, not as way etc (because it should keep it's look). Anything I did miss, or "just ignore the file size and upload as raster"? #gis
I spent about 30 minutes figuring out how to manage #PostGIS database migrations using a #RubyOnRails app with activerecord-postgis-adapter and the connecting to it via #QGIS: https://youtube.com/live/6vr9mwKsgJw?feature=share
PostGIS Migrations with Rails (Live Mapping Session)

YouTube

I finally published the FitPub Helm chart on Artifact Hub! 🎉

Huge thanks to @McPringle for @fitpub - I'm genuinely inspired by the project.

Tested it locally today, and I'm planning to deploy on Infomaniak KaaS. My goal is to make self-hosting FitPub simpler, so I packed in plenty of quick-start commands and solid docs.

That's why I was quiet on Codeberg this weekend 😅

https://github.com/oliinykdm/fitpub-helm

#FitPub #Helm #Kubernetes #FOSS #SelfHosted #Fediverse #DevOps #ActivityPub #SpringBoot #postgis

GitHub - oliinykdm/fitpub-helm: (Unofficial WIP) Helm chart for Fitpub — federated fitness tracking platform https://codeberg.org/fitpub/fitpub

(Unofficial WIP) Helm chart for Fitpub — federated fitness tracking platform https://codeberg.org/fitpub/fitpub - oliinykdm/fitpub-helm

GitHub

Fid you know you can follow #PostGIS issue tracker on the Fediverse via RSS parrot ? Here it is: https://rss-parrot.net/u/trac.osgeo.org.postgis.report.16

I mention because there's an intense activity as @komzpa squashes every but with the help of another kind of parrot.

Parrots everywhere ! 🦜

Don't let #AI set you down, use it for the good while the free ride lasts.

Of course any additional humans eyes on the activity is welcome, we all known how sneaky can an #LLM be.

RSS Parrot

Home of RSS Parrot, a free Fediverse service that lets you turn Mastodon into an RSS or Atom feed reader.

#osm2pgsql version 2.3.0 released:

- improved expire functionality
- style testing util for #lua import scripts
- new id cache function
- more geometry processing functions
- various cleanup and bug fixes

#openstreetmap #postgis #postgres #gischat #osm

https://osm2pgsql.org/news/2026/06/10/release-2.3.0.html

Release 2.3.0 - News - osm2pgsql

OpenStreetMap data to PostgreSQL/PostGIS converter

💡🧩FOSS4G Observatory Spotlight: GeoTools

GeoTools 35.0 is out! GeoTools is an open source Java library that provides standards-compliant methods for geospatial data in GIS applications.

👉 https://geotoolsnews.blogspot.com/2026/06/geotools-350-released.html

In our FOSS4G Observatory graph, GeoTools appears as an important hub, connecting projects such as @postgis , @geoserver and @gdal while supporting the implementation of #OGC standards.

#OSGeo #gdal #postgis #mapserver #geospatial #GIS #FOSS4G

Saving objects (e.g. lines + markers) from a webmap e.g. #leafleat in a database e.g. #postgis, is there an obvious useable solution I missed, do I just hold it wrong or is that left as an exercise to the reader? #gis #WebGis