strk,
Here is how it break up the topo geom conversion (l_tolerance is 0.0000001)
LOOP
WITH foo AS (SELECT grd_id FROM azgiv.roadcenterlines
WHERE grd_topo_geom IS NULL
LIMIT l_batch_size)
UPDATE azgiv.roadcenterlines
SET grd_topo_geom =
topology.totopogeom(grd_geom, 'azgiv_topo', l_topo_layer_id, l_tolerance)
FROM foo
WHERE foo.grd_id = roadcenterlines.grd_id;
GET DIAGNOSTICS l_rowcount = ROW_COUNT;
EXIT WHEN l_rowcount < l_batch_size;
END LOOP;
I ran into the following message:
ERROR: SQL/MM Spatial exception - point not on edge CONTEXT:
PL/pgSQL function totopogeom(geometry,topogeometry,double precision)
line 112 at FOR over SELECT rows PL/pgSQL function
totopogeom(geometry,character varying,integer,double precision) line
88 at assignment
Please let me know if I am going in the right direction
Bo
On 1/16/19 10:03 AM, Sandro Santilli wrote:
On Wed, Jan 16, 2019 at 09:53:28AM -0700, Bo Guo wrote:
strk,
When I set the tolerance to 0.0000001 and it went through. Is this a good
number to use generally?
The smaller tolerance, the better, generally, I'd think.
But learn how to spot small faces and edges, to clean them up, and how
to load in chunks.
--strk;
_______________________________________________
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
