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

Bo Guo bo.guo at gisticinc.com
Wed Jan 16 08:53:28 PST 2019


When I set the tolerance to 0.0000001 and it went through.  Is this a 
good number to use generally?


On 1/16/19 9:14 AM, Sandro Santilli wrote:
> On Tue, Jan 15, 2019 at 09:48:30AM -0700, Bo Guo wrote:
>>      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 suggest you try with a smaller tolerance for a start. Variations to
> tolerance can help in both directions too. Also try to converting to
> TopoGeometry in chunks rather than all at once, so you can take the
> chance to clean up small faces between runs.
> PS: toTopoGeom _does_ split existing edges
> --strk;
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users

More information about the postgis-users mailing list