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

[Martin - PostGIS 기반의 고성능 실시간 벡터 타일 서버

Martin은 PostGIS 기반의 **고성능 실시간 벡터 타일 서버**로, GIS(지리정보시스템) 개발 시 발생하는 데이터 업데이트의 번거로움, 서버 자원의 한계, 파편화된 데이터 관리, 부수적인 설정의 피로도 문제를 해결합니다. Rust로 구현되어 **저수준 메모리 최적화**를 통해 고성능을 보장하며, DB(PostgreSQL)에서 실시간으로 데이터를 읽어와 타일 생성을 생략합니다. 또한 폰트, 아이콘, 스타일 파일 등 부수적인 에셋 관리를 자체적으로 처리하여 개발자의 부담을 줄입니다. 오픈소스 프로젝트로, **MapLibre와 연계**하여 사용 가능하며, GIS 시스템 구축 시 반복적인 삽질을 줄이는 유틸리티로 활용될 수 있습니다.

https://news.hada.io/topic?id=29358

#gis #postgis #vectortiles #rust #geospatial

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

#PostGIS Patch Releases

https://postgis.net/2026/04/PostGIS-Patch-Releases/

fun fact: you can map a value to a color in #postgres using [width_bucket](https://www.postgresql.org/docs/current/functions-math.html#id-1.5.8.9.6.2.2.33.1.1.1).

I used this to colorize the output of #postgis pgr_dijkstra. A road goes from green to blue the more costly it becomes.

#osm2pgsql got funding to reduce ressource usage 🎉
needed for keeping pace with the every growing amount of #openstreetmap data
#osm #postgis #postgresql

https://osm2pgsql.org/news/2026/04/25/ngi0-grant-for-osm2pgsql.html

I have polygons in #QGIS or #PostGIS, how do I get a "centerline" or the longest line that divides them in nicely balanced parts? The goal is to get lines that can be used for curved labeling.

All the polygons are either rectangles or "curvy pipes" like in the image.

I feel like I've been here many times and never found a good solution.