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

Bo Guo bo.guo at gisticinc.com
Tue Jan 15 08:48:30 PST 2019

Hello there,

I am doing a straight update to create topology geom in a table of line 

     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 

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)



More information about the postgis-users mailing list