home.social

#postgis — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #postgis, aggregated by home.social.

  1. @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.

  2. @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.

  3. ⏳ Deadline extended! The 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 &

    🔥 Submit now—spots are filling fast.

    foss4gna.org/news-2026/call-fo

  4. ⏳ 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.

    foss4gna.org/news-2026/call-fo

  5. 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?

  6. 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?

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

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

  9. 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: youtube.com/live/6vr9mwKsgJw?f

  10. 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: youtube.com/live/6vr9mwKsgJw?f

  11. 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 😅

    github.com/oliinykdm/fitpub-he

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

  12. 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 😅

    github.com/oliinykdm/fitpub-he

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

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

    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.

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

    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.

  15. #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

    osm2pgsql.org/news/2026/06/10/

  16. #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

    osm2pgsql.org/news/2026/06/10/

  17. #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

    osm2pgsql.org/news/2026/06/10/

  18. #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

    osm2pgsql.org/news/2026/06/10/

  19. #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

    osm2pgsql.org/news/2026/06/10/

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

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

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

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

  24. Using GeoJSON with PostGIS

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

  25. Using GeoJSON with PostGIS

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

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

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

    habr.com/ru/articles/1042618/

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

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

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

    habr.com/ru/articles/1040940/

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

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

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

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

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

  32. 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: 👇 us06web.zoom.us/webinar/regist

    #GIS #OpenSource #GDI #PostGIS #WebGIS

  33. 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: 👇 us06web.zoom.us/webinar/regist

    #GIS #OpenSource #GDI #PostGIS #WebGIS

  34. 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: 👇 us06web.zoom.us/webinar/regist

    #GIS #OpenSource #GDI #PostGIS #WebGIS

  35. 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: 👇 us06web.zoom.us/webinar/regist

    #GIS #OpenSource #GDI #PostGIS #WebGIS

  36. 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: 👇 us06web.zoom.us/webinar/regist

    #GIS #OpenSource #GDI #PostGIS #WebGIS

  37. 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...
    spatialists.ch/posts/2026/05/0 #GIS #GISchat #geospatial #SwissGIS

  38. 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...
    spatialists.ch/posts/2026/05/0 #GIS #GISchat #geospatial #SwissGIS

  39. 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: 👇 us06web.zoom.us/webinar/regist

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

  40. 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: 👇 us06web.zoom.us/webinar/regist

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

  41. 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: 👇 us06web.zoom.us/webinar/regist

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

  42. 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: 👇 us06web.zoom.us/webinar/regist

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

  43. 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: 👇 us06web.zoom.us/webinar/regist

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