<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>strk,</p>
<p>I changed from 0.001 to 0.00001 and had the similar error. When
I leave out he tolerance value all together, I got the following
msg:</p>
<blockquote>
<p><tt>ERROR: SQL/MM Spatial exception - geometry crosses edge
571239
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
SQL state: XX000</tt></p>
</blockquote>
<div class="moz-cite-prefix">I will try to break the update into
multiple batches</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 9:14 AM, Sandro Santilli
wrote:<br>
</div>
<blockquote type="cite" cite="mid:20190116161452.GA5292@liz">
<pre class="moz-quote-pre" wrap="">On Tue, Jan 15, 2019 at 09:48:30AM -0700, Bo Guo wrote:
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap=""> 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?
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
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
<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>
Bo Guo, PhD, PE <br>
Gistic Research, Inc.<br>
2033 E Warner Rd. Ste 105 <br>
Tempe, AZ 85284 <br>
<a href="" "http:="" www.gisticinc.com"="">www.gisticinc.com</a> <br>
Tel: 480-656-9962
</div>
</body>
</html>