PostGIS topology full story

[Lars Aksel Opsahl]

________________________________
From: Sandro Santilli <strk at kbt.io>
Sent: Monday, March 17, 2025 9:34 AM
To: Antonio Valanzano <anvalanz at gmail.com>
Cc: postgis-users at lists.osgeo.org <postgis-users at lists.osgeo.org>; Lars Aksel Opsahl <Lars.Opsahl at nibio.no>
Subject: Re: PostGIS topology full story


[2017]

The Norwegian Institute of Bioeconomy Research (NIBIO) started
contracting me to work on robustness, speed, correctness and new
features for PostGIS Topology.

The relationship is still ongoing as of 2025.

> - which are the users that are using the topology for working with tables
> with millions of rows (I am asking this because I have read, but I do not
> remember where, that PostGIS topology is very slow and appropriate only for
> small datasets).

Surely NIBIO is, I'm adding Lars in Cc so he can tell more.
Regione Toscana did (not sure anymore today)
US Census might be (reading this thread, anyone?)
LINZ - Land Information New Zealand might too (reading this thread anyone from there?)

Adding a "Use Cases" section for PostGIS Topology would be
great, maybe to be done with a separate thread ...

--strk;

  Libre GIS consultant/developer
  https://strk.kbt.io/services.html

Hi

About Topology, I also heard that rumor many years ago. Maybe my boss also saw that rumor because she told me that if I was able to push AR5 (7 million polygons and corresponding edges) into PostGIS Topology, NIBIO would start to test/use PostGIS Topology. This was around 10 years ago, and PostGIS Topology has become more and more important for NIBIO as time has gone on.
We have lately used PostGIS Topology to clean simple feature layers with around 80 million polygons, but it’s not straightforward, that’s true. So we need more work on performance, robustness, and ease of use. We also have a topology edit client that has been used to edit thousands of faces and edges used by municipalities all over Norway. Without the collaboration with the PostGIS team, especially Sandro, this would not have been possible.
Most work we do related to PostGIS Topology not found in PostGIS can be found here: https://gitlab.com/nibioopensource
Lars



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20250321/0b49b1e2/attachment.htm>