[postgis-users] ST_CreateTopoGeo

paul.malm at lfv.se paul.malm at lfv.se
Tue Feb 25 04:10:07 PST 2020


Hi,
I'm running this command:
SELECT topology.ST_CreateTopoGeo('topo1',ST_Collect("geom")) from "countries_first";

and are getting this message:
ERROR: Corrupted topology: adjacent edges 71 and -72 bind different face (36 and 0) CONTEXT: SQL-sats: "SELECT topology.ST_AddEdgeModFace(atopology, snode_id, enode_id, rec.geom)" PL/pgSQL-funktion topology.st_createtopogeo(character varying,geometry) row 151 at PERFORM SQL state: XX000

I've tried running ST_Makevalid on "countries_first" (polygon layer) before executing ST_CreateTopoGeo
Is there anyone who has a clue on what is wrong?

Thanks,
Paul
    [2_LFV_engelsk_96]

   Paul Malm

   Operations AIM

   Direct  +46 (0)8 797 70 23  Mobile: +46 (0)708 601115
   paul.malm at lfv.se

   Mail & Visit: Löjtnantsgatan 25, 115 50 Stockholm, Sweden

   Unit phone: +46 (0)8 797 70 20
   www.lfv.se<http://www.lfv.se/>

   Please consider the enviroment before printing this e-mail message.



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200225/cd74efdf/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 4612 bytes
Desc: image001.jpg
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200225/cd74efdf/attachment.jpg>


More information about the postgis-users mailing list