[Qgis-user] PostGIS Topology

Sandro Santilli strk at kbt.io
Fri Jan 20 02:37:02 PST 2017


On Fri, Jan 20, 2017 at 02:14:38PM +0400, Irakli Ugulava wrote:

> Please give me the simple way, how to convert existing polygon Shapefile
> into PostGIS topology Layer.

1. Load the shapefile into a table
2. Create a topology
3. Add a TopoGeometry column to the table
4. Update the table setting the new column with toTopoGeom

It may be a good contribution to provide an SQL function to do
all of the steps from 2 to 4, or someone even suggested to
extend the loader (shp2pgsql) to do all the 4 steps at once.

Are you up to give any of these two ideas some legs ?

--strk;



More information about the Qgis-user mailing list