Hi,
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 : [email protected]
> 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
> [email protected]
> https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/postgis-users
