<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>strk,</p>
<p>Here is how it break up the topo geom conversion (l_tolerance is
0.0000001)</p>
<p><tt> LOOP</tt><tt><br>
</tt><tt> WITH foo AS (SELECT grd_id FROM
azgiv.roadcenterlines</tt><tt><br>
</tt><tt> WHERE </tt><tt>grd_topo_geom
IS NULL</tt><tt><br>
</tt><tt> LIMIT l_batch_size)</tt><tt><br>
</tt><tt> UPDATE azgiv.roadcenterlines</tt><tt><br>
</tt><tt> SET grd_topo_geom =
topology.totopogeom(grd_geom, 'azgiv_topo', l_topo_layer_id,
l_tolerance)</tt><tt><br>
</tt><tt> FROM foo</tt><tt><br>
</tt><tt> WHERE foo.grd_id =
roadcenterlines.grd_id;</tt><tt><br>
</tt><tt><br>
</tt><tt> GET DIAGNOSTICS l_rowcount = ROW_COUNT;</tt><tt><br>
</tt><tt><br>
</tt><tt> EXIT WHEN l_rowcount < l_batch_size;</tt><tt><br>
</tt><tt><br>
</tt><tt> END LOOP;</tt><br>
</p>
<div class="moz-cite-prefix">I ran into the following message:</div>
<blockquote>
<div class="moz-cite-prefix"><tt>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</tt></div>
</blockquote>
<div class="moz-cite-prefix">Please let me know if I am going in the
right direction</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">Bo<br>
</div>
<div class="moz-cite-prefix">On 1/16/19 10:03 AM, Sandro Santilli
wrote:<br>
</div>
<blockquote type="cite" cite="mid:20190116170327.GB15434@liz">
<pre class="moz-quote-pre" wrap="">On Wed, Jan 16, 2019 at 09:53:28AM -0700, Bo Guo wrote:
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">strk,
When I set the tolerance to 0.0000001 and it went through. Is this a good
number to use generally?
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
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
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<div class="moz-signature"><br>
</div>
</body>
</html>