[postgis-users] totopogeom resulting in SQL/MM Spatial exception

christophe vergon christophevergon-girtec at orange.fr
Tue Jan 15 10:04:10 PST 2019



It's better for you to use topogeo_addlinestring() function, it will split existing edges or faces.


Totopogeom() don't split. It casts a geometry type in a topogeometry.


Bonne soirée.





> Message du 15/01/19 17:4
> De : "Bo Guo" 
> A : postgis-users at lists.osgeo.org
> Copie à : 
> Objet : [postgis-users] totopogeom resulting in SQL/MM Spatial exception
> Hello there, I am doing a straight update to create topology geom in a table of line geometries:     UPDATE azgiv.roadcenterlines SET grd_topo_geom = topology.totopogeom(grd_geom, 'azgiv_topo', l_topo_layer_id, l_tolerance); I am getting the following error similar to below:     ERROR: SQL/MM Spatial exception - geometry crosses edge 566760 CONTEXT: PL/pgSQL function totopogeom(geometry,topogeometry,double precision) Wonder if someone could shed some light as to what I need to look for? I am using the following base version:     PostgreSQL 9.6.11 on x86_64-pc-linux-gnu (Ubuntu 9.6.11-1.pgdg16.04+1), compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.10) 5.4.0 20160609, 64-bit I am using the following Postgis version:     POSTGIS="2.4.4 r16526" PGSQL="96" GEOS="3.5.0-CAPI-1.9.0 r4084" PROJ="Rel. 4.9.2, 08 September 2015" GDAL="GDAL 1.11.3, released 2015/09/16" LIBXML="2.9.3" LIBJSON="0.11.99" LIBPROTOBUF="1.2.1" (core procs from "2.4.0 r15853" need upgrade) TOPOLOGY (topology procs from "2.5.1 r17027" need upgrade) RASTER (raster procs from "2.4.0 r15853" need upgrade) TIA Bo _______________________________________________ postgis-users mailing list postgis-users at lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190115/f927eaee/attachment.html>

More information about the postgis-users mailing list