#postgis — Public Fediverse posts

#PostGIS 3.7.0alpha1 released

https://postgis.net/2026/07/PostGIS-3.7.0alpha1/

#PostGIS 3.7.0alpha1 released

https://postgis.net/2026/07/PostGIS-3.7.0alpha1/

CVE-2026-1207 is a Django SQL injection flaw (CVSS 8.3) in PostGIS raster lookups. Canada's CCCS says it is exploited in the wild. Patch now.

#Django #SQLInjection #CVE20261207 #PostGIS #InfoSec

https://securityonline.info/django-sql-injection-cve-2026-1207/?utm_source=mastodon&utm_medium=jetpack_social

CVE-2026-1207 is a Django SQL injection flaw (CVSS 8.3) in PostGIS raster lookups. Canada's CCCS says it is exploited in the wild. Patch now.

#Django #SQLInjection #CVE20261207 #PostGIS #InfoSec

https://securityonline.info/django-sql-injection-cve-2026-1207/?utm_source=mastodon&utm_medium=jetpack_social

@ioster @harmonia_amanda Pourquoi uniquement #Paris ?

On a désormais le nuage de points LIDAR HD de l'IGN qui permet d'avoir la précision suffisante pour calculer les altitudes et une pente moyenne pour chaque tronçon de rue.

À ma connaissance ça n'a jamais été fait de façon ouverte en opendata, mais ce n'est pas si compliqué à faire avec des softs #SIG #OpenSource ( #PostGIS par exemple ). Il faut prévoir un peu de traitement et de volume de données par contre.

@ioster @harmonia_amanda Pourquoi uniquement #Paris ?

On a désormais le nuage de points LIDAR HD de l'IGN qui permet d'avoir la précision suffisante pour calculer les altitudes et une pente moyenne pour chaque tronçon de rue.

À ma connaissance ça n'a jamais été fait de façon ouverte en opendata, mais ce n'est pas si compliqué à faire avec des softs #SIG #OpenSource ( #PostGIS par exemple ). Il faut prévoir un peu de traitement et de volume de données par contre.

⏳ Deadline extended! The #FOSS4G NA team is looking for talks to fill key gaps in the program for key areas, including:

- The business of open source
- Community
- Resilience
- Core tools like #QGIS & #PostGIS

🔥 Submit now—spots are filling fast.

https://www.foss4gna.org/news-2026/call-for-proposals-extended-for-talks-and-lightning-talks

⏳ Deadline extended! The #FOSS4G NA team is looking for talks to fill key gaps in the program for key areas, including:

- The business of open source
- Community
- Resilience
- Core tools like #QGIS & #PostGIS

🔥 Submit now—spots are filling fast.

https://www.foss4gna.org/news-2026/call-for-proposals-extended-for-talks-and-lightning-talks

Is there anybody in my timeline using #owntracks recorder? I have the problem that my instance is extremely slow. Any Alternative using the geoJSON capabilities of #PostGIS instead of the plain files?

Is there anybody in my timeline using #owntracks recorder? I have the problem that my instance is extremely slow. Any Alternative using the geoJSON capabilities of #PostGIS instead of the plain files?

#PostGIS Tiger Geocoder 2025.1 released

https://postgis.net/2026/06/PostGIS-Tiger-Geocoder-2025.1/

#PostGIS Tiger Geocoder 2025.1 released

https://postgis.net/2026/06/PostGIS-Tiger-Geocoder-2025.1/

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 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

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

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

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

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.

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.

#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

#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

#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

#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

#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

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

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

【個人開発】近所のリチウムイオン電池の回収拠点を探すアプリを自分用に開発した【React/Supabase/PostGIS】
https://qiita.com/tarpan_75/items/8a068a7fb4d5895b2382?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

#qiita #PostGIS #Firebase #React #vite #Supabase

Is this possible using PostGIS?

It feels like it should be an obvious use-case, but the right approach isn't clear to me after reading the docs.

Imagine having one set of paths (actually bike rides) and another set of segments (parts of rides where I time myself).

Instead of giving my money and data to abusive companies like Strava, I want to match my rides against the segments to track my best times as well as progression.

Thus, I need to efficiently match subsegments of the rides to the segment database.

What is the most efficient way to leverage PostGIS to do this? If I can make this work, I want to turn this into a Fediverse service.

#postgres #postgresql #postgis

Is this possible using PostGIS?

It feels like it should be an obvious use-case, but the right approach isn't clear to me after reading the docs.

Imagine having one set of paths (actually bike rides) and another set of segments (parts of rides where I time myself).

Instead of giving my money and data to abusive companies like Strava, I want to match my rides against the segments to track my best times as well as progression.

Thus, I need to efficiently match subsegments of the rides to the segment database.

What is the most efficient way to leverage PostGIS to do this? If I can make this work, I want to turn this into a Fediverse service.

#postgres #postgresql #postgis

Using GeoJSON with PostGIS

Learn how to import export and query GeoJSON data in PostGIS spatial databases.
https://geojason.com/postgis-geojson-guide
#geojson #postgis

Using GeoJSON with PostGIS

Learn how to import export and query GeoJSON data in PostGIS spatial databases.
https://geojason.com/postgis-geojson-guide
#geojson #postgis

Функции управления цифровыми активами автомобильных дорог. Часть 2 – маппинг

Здравствуйте, уважаемые читатели Хабра! В первой части мы рассказали, как решили задачу сегментации полигона дороги в PostGIS. А теперь рассмотрим сопоставление сегментов двух разных версий дороги для сохранения учёта историчности привязанных к ним событий. Интересно? Читать!

https://habr.com/ru/articles/1042618/

#postgresql #postgis #сопоставление #mapping #полигон #дорога #геосервис #информационные_системы #умный_город #smart_city

Функции управления цифровыми активами автомобильных дорог. Часть 1 – сегментация

Здравствуйте, уважаемые читатели Хабра! В данной статье расскажем, как мы смогли автоматизировать процесс разбиения дорог в PostGIS, тем самым снизив нагрузку на специалистов и в разы увеличив скорость обработки полигонов. Интересно? Читать!

https://habr.com/ru/articles/1040940/

#postgresql #postgis #сегментация #полигон #дорога #геосервис #информационные_системы #умный_город #smart_city #инновацииит

Fijn! Voor de eerste keer in/sinds mijn revalidatie lekker een avondje zitten nerden met geodata: uitgezocht hoe makkelijk het is om met ogr2ogr stukken BAG en BGT rechtstreeks vanuit de #PDOK OGC-API's in een geopackage weg te schrijven (spoiler: het is reuze makkelijk).
Kwam door een vraag op het forum van het Gemeentelijk GeoBeraad, die ging over FME en Oracle. Wat zoeken mensen toch steeds in die Noord-Amerikaanse propietary software? Doe gewoon #OSGeo dingen, zoals #ogr2ogr en #PostGIS...

Fijn! Voor de eerste keer in/sinds mijn revalidatie lekker een avondje zitten nerden met geodata: uitgezocht hoe makkelijk het is om met ogr2ogr stukken BAG en BGT rechtstreeks vanuit de #PDOK OGC-API's in een geopackage weg te schrijven (spoiler: het is reuze makkelijk).
Kwam door een vraag op het forum van het Gemeentelijk GeoBeraad, die ging over FME en Oracle. Wat zoeken mensen toch steeds in die Noord-Amerikaanse propietary software? Doe gewoon #OSGeo dingen, zoals #ogr2ogr en #PostGIS...

confused about #postgis ST_NPoints with polygons, because a triangle apparently has 4 points.

SELECT ST_NPoints(ST_GeomFromText('POLYGON ((0 0, 0 1, 1 0, 0 0 ))'));

From a technical point it makes sense, but it is also quite unintuitive, because normal people on the street would definitely say a triangle has 3 points ...

#gischat #gistribe #osgeo #foss4g

confused about #postgis ST_NPoints with polygons, because a triangle apparently has 4 points.

SELECT ST_NPoints(ST_GeomFromText('POLYGON ((0 0, 0 1, 1 0, 0 0 ))'));

From a technical point it makes sense, but it is also quite unintuitive, because normal people on the street would definitely say a triangle has 3 points ...

#gischat #gistribe #osgeo #foss4g

5 Datenstände im Team, weil die letzte Version „irgendwo liegt"? 😖

💡 Eine Open-Source-GDI löst genau das: zentrale Datenhaltung, klare Zuständigkeiten, standardisierte Dienste.

👀 5 Praxis-Vorträge – kostenlos & online:
• PostGIS als Datenfundament
• WMS/WFS mit MapServer & QGIS Server
• QGIS, Mapbender & QField
• Datensouveränität ohne Vendor Lock-in
• Q&A nach jedem Vortrag

Jetzt anmelden: 👇 https://us06web.zoom.us/webinar/register/WN_m4463lkzQbqT1taHtTJd6A#/registration

#GIS #OpenSource #GDI #PostGIS #WebGIS

5 Datenstände im Team, weil die letzte Version „irgendwo liegt"? 😖

💡 Eine Open-Source-GDI löst genau das: zentrale Datenhaltung, klare Zuständigkeiten, standardisierte Dienste.

👀 5 Praxis-Vorträge – kostenlos & online:
• PostGIS als Datenfundament
• WMS/WFS mit MapServer & QGIS Server
• QGIS, Mapbender & QField
• Datensouveränität ohne Vendor Lock-in
• Q&A nach jedem Vortrag

Jetzt anmelden: 👇 https://us06web.zoom.us/webinar/register/WN_m4463lkzQbqT1taHtTJd6A#/registration

#GIS #OpenSource #GDI #PostGIS #WebGIS

5 Datenstände im Team, weil die letzte Version „irgendwo liegt"? 😖

💡 Eine Open-Source-GDI löst genau das: zentrale Datenhaltung, klare Zuständigkeiten, standardisierte Dienste.

👀 5 Praxis-Vorträge – kostenlos & online:
• PostGIS als Datenfundament
• WMS/WFS mit MapServer & QGIS Server
• QGIS, Mapbender & QField
• Datensouveränität ohne Vendor Lock-in
• Q&A nach jedem Vortrag

Jetzt anmelden: 👇 https://us06web.zoom.us/webinar/register/WN_m4463lkzQbqT1taHtTJd6A#/registration

#GIS #OpenSource #GDI #PostGIS #WebGIS

5 Datenstände im Team, weil die letzte Version „irgendwo liegt"? 😖

💡 Eine Open-Source-GDI löst genau das: zentrale Datenhaltung, klare Zuständigkeiten, standardisierte Dienste.

👀 5 Praxis-Vorträge – kostenlos & online:
• PostGIS als Datenfundament
• WMS/WFS mit MapServer & QGIS Server
• QGIS, Mapbender & QField
• Datensouveränität ohne Vendor Lock-in
• Q&A nach jedem Vortrag

Jetzt anmelden: 👇 https://us06web.zoom.us/webinar/register/WN_m4463lkzQbqT1taHtTJd6A#/registration

#GIS #OpenSource #GDI #PostGIS #WebGIS

5 Datenstände im Team, weil die letzte Version „irgendwo liegt"? 😖

💡 Eine Open-Source-GDI löst genau das: zentrale Datenhaltung, klare Zuständigkeiten, standardisierte Dienste.

👀 5 Praxis-Vorträge – kostenlos & online:
• PostGIS als Datenfundament
• WMS/WFS mit MapServer & QGIS Server
• QGIS, Mapbender & QField
• Datensouveränität ohne Vendor Lock-in
• Q&A nach jedem Vortrag

Jetzt anmelden: 👇 https://us06web.zoom.us/webinar/register/WN_m4463lkzQbqT1taHtTJd6A#/registration

#GIS #OpenSource #GDI #PostGIS #WebGIS

Fuzzifying PostGIS: Jesper Fjellin proposes extending #PostGIS with #fuzzy geometries as first-class data types, enabling locations to belong to a region to a degree rather than simply being part of it or not. This would offer opportunities for better dealing with...
https://spatialists.ch/posts/2026/05/05-fuzzifying-postgis/ #GIS #GISchat #geospatial #SwissGIS

Fuzzifying PostGIS: Jesper Fjellin proposes extending #PostGIS with #fuzzy geometries as first-class data types, enabling locations to belong to a region to a degree rather than simply being part of it or not. This would offer opportunities for better dealing with...
https://spatialists.ch/posts/2026/05/05-fuzzifying-postgis/ #GIS #GISchat #geospatial #SwissGIS

Open-Source-GDI: Theorie & Praxis – kostenlos & online! 🌐

👀 Wie baut man eine GDI, die im Alltag wirklich funktioniert?

📑 5 Vorträge:
• Was ist eine GDI?
• PostGIS statt Dateisystem – Performance, Ordnung, Rechte
• Dienste mit MapServer & QGIS Server
• Desktop, Web & Mobil: QGIS, Mapbender & QField
• Datensouveränität ohne Vendor Lock-in

Kostenlos anmelden: 👇 https://us06web.zoom.us/webinar/register/WN_m4463lkzQbqT1taHtTJd6A#/registration

#GIS #OpenSource #GDI #PostGIS #WebGIS #DigitaleSouveränität

Open-Source-GDI: Theorie & Praxis – kostenlos & online! 🌐

👀 Wie baut man eine GDI, die im Alltag wirklich funktioniert?

📑 5 Vorträge:
• Was ist eine GDI?
• PostGIS statt Dateisystem – Performance, Ordnung, Rechte
• Dienste mit MapServer & QGIS Server
• Desktop, Web & Mobil: QGIS, Mapbender & QField
• Datensouveränität ohne Vendor Lock-in

Kostenlos anmelden: 👇 https://us06web.zoom.us/webinar/register/WN_m4463lkzQbqT1taHtTJd6A#/registration

#GIS #OpenSource #GDI #PostGIS #WebGIS #DigitaleSouveränität

Open-Source-GDI: Theorie & Praxis – kostenlos & online! 🌐

👀 Wie baut man eine GDI, die im Alltag wirklich funktioniert?

📑 5 Vorträge:
• Was ist eine GDI?
• PostGIS statt Dateisystem – Performance, Ordnung, Rechte
• Dienste mit MapServer & QGIS Server
• Desktop, Web & Mobil: QGIS, Mapbender & QField
• Datensouveränität ohne Vendor Lock-in

Kostenlos anmelden: 👇 https://us06web.zoom.us/webinar/register/WN_m4463lkzQbqT1taHtTJd6A#/registration

#GIS #OpenSource #GDI #PostGIS #WebGIS #DigitaleSouveränität

Open-Source-GDI: Theorie & Praxis – kostenlos & online! 🌐

👀 Wie baut man eine GDI, die im Alltag wirklich funktioniert?

📑 5 Vorträge:
• Was ist eine GDI?
• PostGIS statt Dateisystem – Performance, Ordnung, Rechte
• Dienste mit MapServer & QGIS Server
• Desktop, Web & Mobil: QGIS, Mapbender & QField
• Datensouveränität ohne Vendor Lock-in

Kostenlos anmelden: 👇 https://us06web.zoom.us/webinar/register/WN_m4463lkzQbqT1taHtTJd6A#/registration

#GIS #OpenSource #GDI #PostGIS #WebGIS #DigitaleSouveränität

Open-Source-GDI: Theorie & Praxis – kostenlos & online! 🌐

👀 Wie baut man eine GDI, die im Alltag wirklich funktioniert?

📑 5 Vorträge:
• Was ist eine GDI?
• PostGIS statt Dateisystem – Performance, Ordnung, Rechte
• Dienste mit MapServer & QGIS Server
• Desktop, Web & Mobil: QGIS, Mapbender & QField
• Datensouveränität ohne Vendor Lock-in

Kostenlos anmelden: 👇 https://us06web.zoom.us/webinar/register/WN_m4463lkzQbqT1taHtTJd6A#/registration

#GIS #OpenSource #GDI #PostGIS #WebGIS #DigitaleSouveränität