PostGIS topology full story

MONTICOLO Julien Julien.MONTICOLO at strasbourg.eu
Mon Feb 10 04:25:12 PST 2025


Hello M. Valanzano,

From what I know about PostGIS topology :

> who developed it and when this development started
> which have been the mayor releases and improvements during the years

- If you look the Postgis Git repository :
  - https://git.osgeo.org/gitea/postgis/postgis/src/commit/2b5868ca90c2eac99cb53d5242ace55f01499b23/topology/README
  - https://git.osgeo.org/gitea/postgis/postgis/commits/branch/master/topology?page=19

A lot of work is / was done by Sandro Santilli (https://git.osgeo.org/gitea/strk)
He works currently for NIBIO - Norwegian Institute of Bioeconomy Research and they develop web services to edit features with PostGIS Topology :
https://gitlab.com/nibioopensource

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

- So for users, Norway at least to manage their National Land Resource Map.
- And here are the slides of a presentation at FOSS4G in 2015 "What happens when you put 1 billion points into Postgis Topology?"
   https://fr.slideshare.net/slideshow/foss4-g-topologyjuly162015/50657508

Best regards,
Julien Monticolo

-----------------------------------------------------------------------
Ce message est établi à usage exclusif de son destinataire.
Toute utilisation ou diffusion, partielle ou totale, doit être
préalablement autorisée.

Tout message électronique est susceptible d'altération et son intégrité
ne peut être assurée. L'expéditeur décline toute responsabilité au titre
de ce message s'il a été modifié ou falsifié.

Si vous n'êtes pas destinataire de ce message, merci de le détruire et
d'avertir l'expéditeur.

Ville et Eurométropole de Strasbourg
-----------------------------------------------------------------------


More information about the postgis-users mailing list