<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" dir="ltr">
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-top: 0px; margin-bottom: 0px;">
<br>
</p>
<div id="divtagdefaultwrapper" dir="ltr">
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">>From: postgis-users <postgis-users-bounces@lists.osgeo.org>
</span><span style="color: rgb(147, 26, 104); font-family: Monaco; font-size: 11px;">on</span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;"> behalf of Bo Guo <bo.guo@gisticinc.com></span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">>Sent: Wednesday, January 16, 2019 7:00 PM</span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">>To: postgis-users@lists.osgeo.org</span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">>Subject: Re: [postgis-users] totopogeom resulting
</span><span style="color: rgb(147, 26, 104); font-family: Monaco; font-size: 11px;">in</span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;"> SQL/MM Spatial exception</span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">></span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;"> </span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">>OK, I can understand the concept why this
</span><span style="color: rgb(147, 26, 104); font-family: Monaco; font-size: 11px;">is</span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;"> the case now. But if there</span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">></span><span style="color: rgb(147, 26, 104); font-family: Monaco; font-size: 11px;">is</span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">
</span><span style="color: rgb(147, 26, 104); font-family: Monaco; font-size: 11px;">any</span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;"> example
</span><span style="color: rgb(147, 26, 104); font-family: Monaco; font-size: 11px;">or</span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;"> reference article
</span><span style="color: rgb(147, 26, 104); font-family: Monaco; font-size: 11px;">on</span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;"> line that would be of great help.</span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">></span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">>Bo</span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">></span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">>On 1/16/19 10:37 AM, Sandro Santilli wrote:</span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">>> On Wed, Jan 16, 2019 at 10:26:12AM -0700, Bo Guo wrote:</span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">>>> strk,</span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">>>></span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">>>> Here
</span><span style="color: rgb(147, 26, 104); font-family: Monaco; font-size: 11px;">is</span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;"> how it break up the topo geom conversion (l_tolerance
</span><span style="color: rgb(147, 26, 104); font-family: Monaco; font-size: 11px;">is</span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;"> 0.0000001)</span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">>>></span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">>>></span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">
</span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">LOOP</span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">>>></span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">
</span><span style="color: rgb(147, 26, 104); font-family: Monaco; font-size: 11px;">WITH</span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;"> foo
</span><span style="color: rgb(147, 26, 104); font-family: Monaco; font-size: 11px;">AS</span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;"> (</span><span style="color: rgb(147, 26, 104); font-family: Monaco; font-size: 11px;">SELECT</span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">
grd_id </span><span style="color: rgb(147, 26, 104); font-family: Monaco; font-size: 11px;">FROM</span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;"> azgiv.roadcenterlines</span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">>>></span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">
</span><span style="color: rgb(147, 26, 104); font-family: Monaco; font-size: 11px;">WHERE</span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;"> grd_topo_geom
</span><span style="color: rgb(147, 26, 104); font-family: Monaco; font-size: 11px;">IS</span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">
</span><span style="color: rgb(83, 41, 210); font-family: Monaco; font-size: 11px;">NULL</span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">>>></span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">
</span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">LIMIT l_batch_size)</span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">>>></span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">
</span><span style="color: rgb(147, 26, 104); font-family: Monaco; font-size: 11px;">UPDATE</span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;"> azgiv.roadcenterlines</span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">>>></span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">
</span><span style="color: rgb(147, 26, 104); font-family: Monaco; font-size: 11px;">SET</span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;"> grd_topo_geom =</span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">>>> topology.totopogeom(grd_geom,
</span><span style="color: rgb(4, 51, 255); font-family: Monaco; font-size: 11px;">'azgiv_topo'</span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">, l_topo_layer_id, l_tolerance)</span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">>>></span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">
</span><span style="color: rgb(147, 26, 104); font-family: Monaco; font-size: 11px;">FROM</span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;"> foo</span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">>>></span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">
</span><span style="color: rgb(147, 26, 104); font-family: Monaco; font-size: 11px;">WHERE</span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;"> foo.grd_id = roadcenterlines.grd_id;</span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">>>></span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">>>></span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">
</span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">GET DIAGNOSTICS l_rowcount = ROW_COUNT;</span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">>>></span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">>>></span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">
</span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">EXIT WHEN l_rowcount < l_batch_size;</span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">>>></span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">>>></span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">
</span><span style="color: rgb(147, 26, 104); font-family: Monaco; font-size: 11px;">END</span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;"> LOOP;</span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">>> The goal of chunking was to get
</span><span style="color: rgb(147, 26, 104); font-family: Monaco; font-size: 11px;">partial</span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;"> results rather than an</span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">>> </span>
<span style="color: rgb(147, 26, 104); font-family: Monaco; font-size: 11px;">all</span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">-</span><span style="color: rgb(147, 26, 104); font-family: Monaco; font-size: 11px;">or</span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">-nothing
behavior. If you use that plpgsql loop you</span><span style="color: rgb(4, 51, 255); font-family: Monaco; font-size: 11px;">'ll want</span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(4, 51, 255); font-family: Monaco; font-size: 11px;">>> to catch exceptions and set those TopoGeometries to NULL instead.</span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(4, 51, 255); font-family: Monaco; font-size: 11px;">>> Then you'</span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">ll be able to see what the loop was able to
</span><span style="color: rgb(1, 25, 147); font-family: Monaco; font-size: 11px;">convert</span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">
</span><span style="color: rgb(147, 26, 104); font-family: Monaco; font-size: 11px;">and</span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">>> what </span>
<span style="color: rgb(147, 26, 104); font-family: Monaco; font-size: 11px;">not</span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">,
</span><span style="color: rgb(147, 26, 104); font-family: Monaco; font-size: 11px;">and</span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;"> get back to the still-to-be-converted geoms, maybe</span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">>> after cleaning up
</span><span style="color: rgb(147, 26, 104); font-family: Monaco; font-size: 11px;">some</span><span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;"> of what you got converted already.</span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">>></span><br>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
</blockquote>
<span style="color: rgb(0, 0, 0); font-family: Monaco; font-size: 11px;">>> </span>
<span style="color: rgb(79, 145, 146); font-family: Monaco; font-size: 11px;">--strk;</span>
<div style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt;">
<font color="#4f9192" face="Monaco"><span style="font-size:11px"><br>
</span></font></div>
<div>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt;">
<span style="font-size:12pt">Hi</span></p>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
This is not a article but a short description on how we last year at Nibio used Postgis Topology to clean up messy vector data with a lot of overlap/gap. The test we did contained about 1.3 mill polygons with a total of around 90 mill points. </p>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
The input was simple feature polygons that we converted into Postgis Topology and then we then did line smoothing and point reduction on the border lines . There is attached a picture where the red lines are input and the green ones are an example of output
at one stage.</p>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
The Postgis Topology worked quite good and better than other methods we tested. Yes we got some errors, but we also got very good help from Sandro and from examples on internet to resolve the problems we had, Thanks a lot. (When we where able to make a small
test cases that failed it was certainly easier fix/identify problem and get help).</p>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
So here is a short description :</p>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
1) First we dived the input in many (more than a hundred cells) small cells by using a content based grid function .</p>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
2) Then we ran parallel processes on the cells. In each parallel process we did the following :</p>
<ul style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt;">
<li>
<p style="margin-bottom:0in">Created a temporary topology layer with all the line strings from the polygons inside the cell.</p>
</li><li>
<p style="margin-bottom:0in">Then we cut the lines inside the cell so no lines was closer then one meter to the cell walls.</p>
</li><li>
<p style="margin-bottom:0in">Made a final result for each cell, where we snapped lines and smoothed them.</p>
</li><li>
<p style="margin-bottom:0in">Then we dumped this result into a master Postgis Topology table for all the cell.</p>
</li><li>
<p style="margin-bottom:0in">The lines parts in two the meter buffer zone on the cell border was just saved in a temporary table for later processing.</p>
</li></ul>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
3) When all the parallel processes was done we had a master table where no cell had any connecting lines to another cell, because all the lines made in phase two was cut one meter from each cell border.</p>
<ul style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt;">
<li>
<p style="margin-bottom:0in">When then started to connect the different cells using the border lines that was saved in the temporary table. The border lines had the original form and the point where line was inside cell had not been moved so it was possible
to match them together. This lines was also quite short since we did a intersection on them before the where put into the temp table.</p>
</li><li>
<p style="margin-bottom:0in">Then we connected the border lines with original lines and this was the more tricky part, but it seemed to work ok. This connection line part is the most unsure part of this operation.</p>
</li></ul>
<ul style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt;">
<li>
<p style="margin-bottom:0in">Then we simplified the border lines and restored the missing cell border line polygons.</p>
<div><br>
</div>
</li></ul>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
4) Then finally we create the simple feature polygons based on the Postgis Topology master polygon table where all cell now are connected.</p>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
This did actually work. As Sandro say the clue is to dived work into smaller pieces and do try catch. We will continue work more on this year hopefully.</p>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p style="margin-bottom: 0in;"><font size="3">I have added a example of some code below in this mail on how we loop and </font><font size="3">break
</font>line into s<font size="3">ingle pieces and added each part separately as a last try. If it failed a the lowest level we logged the failing piece to to a log table ,so we have total control of failing lines.</font></p>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
If we get the time we may try to put out the code on a repo, but some parts of the util code that we depend on is out on github.</p>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
A) This repo contains code used by a simple client to edit Postgis Topology, but this is also used to by the Simple Feature cleaner described above. Here we also good from help Sandro.</p>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
(Some of this code is not generic and need much more work it if should be used by others)</p>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<a href="https://github.com/NibioOpenSource/pgtopo_update_sql" id="LPlnk440858" class="OWAAutoLink" previewremoved="true">https://github.com/NibioOpenSource/pgtopo_update_sql</a></p>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
At <a href="https://www.slideshare.net/laopsahl/postgis-topology-presentationfoss4goslo01092016" id="LPlnk532555" class="OWAAutoLink" previewremoved="true">https://www.slideshare.net/laopsahl/postgis-topology-presentationfoss4goslo01092016</a></p>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
there is presentation about why we use Topology and how we use Postgis Topology at Nibio for online map editing.</p>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p style="margin-bottom: 0in; font-size: 12pt;">B) This contains code for content based grids to be able work big datasets</p>
<p style="margin-bottom: 0in; font-size: 12pt;"><a href="https://github.com/larsop/content_balanced_grid" id="LPlnk274153" class="OWAAutoLink" previewremoved="true">https://github.com/larsop/content_balanced_grid</a> .</p>
<p style="font-size: 12pt; margin-bottom: 0in;"><br>
</p>
<p style="margin-bottom: 0in; font-size: 12pt;">If you look at page 18-23 at http://www.slideshare.net/laopsahl/foss4-g-topologyjuly162015</p>
<p style="margin-bottom: 0in; font-size: 12pt;">you find some info about content based grids.</p>
<div><br>
</div>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
C) Repo with different extended Chaikin smooth line methods written in psql used to smooth lines <a href="https://github.com/larsop/chaikin" id="LPlnk533499" class="OWAAutoLink" style="font-size:12pt" previewremoved="true">https://github.com/larsop/chaikin</a> when
cleaning up messy polygons in the process above.</p>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
Example code </p>
<p style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#7f0055"><b>CREATE</b></font><font color="#000000"> </font><font color="#7f0055"><b>OR</b></font><font color="#000000"> </font><font color="#000080">REPLACE</font><font color="#000000"> FUNCTION</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">topo_ar5_forest.create_nocutline_edge_domain_obj_retry(</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">json_feature text,</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">border_topo_info topo_update.input_meta_info,</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000">server_json_feature text </font><font color="#7f0055"><b>default</b></font><font color="#000000"> </font><font color="#4000c8"><b>null</b></font><font color="#000000">)</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000">RETURNS </font><font color="#7f0055"><b>TABLE</b></font><font color="#000000">(id </font><font color="#4000c8"><b>integer</b></font><font color="#000000">) </font><font color="#7f0055"><b>AS</b></font><font color="#000000"> $$</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#7f0055"><font face="Monaco, monospace"><font style="font-size:11pt"><b>DECLARE</b></font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#408080"><font face="Monaco, monospace"><font style="font-size:11pt">-- holds dynamic sql to be able to use the same code for different</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">command_string text;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#408080"><font face="Monaco, monospace"><font style="font-size:11pt">-- holde the computed value for json input reday to use</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">json_input_structure topo_update.json_input_structure;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#408080"><font face="Monaco, monospace"><font style="font-size:11pt">-- holde the computed value for json input reday to use</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">json_input_structure_tmp topo_update.json_input_structure;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">counter </font><font color="#4000c8"><b>integer</b></font><font color="#000000">:=0;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">g Geometry;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">inGeom Geometry;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">tolerance </font><font color="#4000c8"><b>real</b></font><font color="#000000"> = 10;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">start_tolerance </font><font color="#4000c8"><b>integer</b></font><font color="#000000"> = 10;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">start_time </font><font color="#7f0055"><b>timestamp</b></font><font color="#000000"> </font><font color="#7f0055"><b>with</b></font><font color="#000000"> </font><font color="#7f0055"><b>time</b></font><font color="#000000"> </font><font color="#7f0055"><b>zone</b></font><font color="#000000">;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">done_time </font><font color="#7f0055"><b>timestamp</b></font><font color="#000000"> </font><font color="#7f0055"><b>with</b></font><font color="#000000"> </font><font color="#7f0055"><b>time</b></font><font color="#000000"> </font><font color="#7f0055"><b>zone</b></font><font color="#000000">;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">used_time </font><font color="#4000c8"><b>real</b></font><font color="#000000">;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">apoint geometry[] </font><font color="#7f0055"><b>DEFAULT</b></font><font color="#000000"> </font><font color="#0000ff">'{}'</font><font color="#000000">;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">spltt_line geometry;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">failed_to_insert </font><font color="#7f0055"><b>boolean</b></font><font color="#000000"> ;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">feat json;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000">rec </font><font color="#7f0055"><b>record</b></font><font color="#000000">;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#7f0055"><font face="Monaco, monospace"><font style="font-size:11pt"><b>BEGIN</b></font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">start_time := clock_timestamp();</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000">feat := json_feature::json;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000">json_input_structure.input_geo := ST_GeomFromGeoJSON(feat->></font><font color="#0000ff">'geometry'</font><font color="#000000">);</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt"></font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">start_tolerance = border_topo_info.snap_tolerance;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000"></font><font color="#7f0055"><b>BEGIN</b></font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000">RAISE NOTICE </font><font color="#0000ff">'work start with %, containing % points'</font><font color="#000000">, json_input_structure.input_geo, ST_NumPoints(json_input_structure.input_geo);</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000"></font><font color="#408080">--test remove reptead points</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">inGeom := ST_RemoveRepeatedPoints(json_input_structure.input_geo,(start_tolerance*3));</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">json_input_structure.input_geo := inGeom;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt"></font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000">IF ST_NumPoints(json_input_structure.input_geo) < 1000 </font><font color="#7f0055"><b>THEN</b></font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">perform topo_ar5_forest.create_nocutline_edge_domain_try_one( border_topo_info, json_input_structure);</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">ELSE</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000">RAISE NOTICE </font><font color="#0000ff">'work start, to big:% border_layer_id %, with a line containing % points'</font><font color="#000000">, start_time, border_topo_info.border_layer_id,
ST_NumPoints(json_input_structure.input_geo);</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt"></font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">json_input_structure_tmp := topo_update.handle_input_json_props(json_feature::json,server_json_feature::json,border_topo_info.srid);</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">inGeom := json_input_structure.input_geo;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt"></font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt"></font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">LOOP</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">counter := counter + 1000;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000"></font><font color="#408080">-- some computations</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000">IF counter > (ST_NPoints(inGeom)-1) </font><font color="#7f0055"><b>THEN</b></font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000">EXIT; </font><font color="#408080">-- exit loop</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">ELSE</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">apoint := array_append(apoint, ST_PointN(inGeom,counter));</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000"></font><font color="#408080">--ST_PointN(g,counter);</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000"></font><font color="#7f0055"><b>END</b></font><font color="#000000"> IF;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt"></font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000"></font><font color="#7f0055"><b>END</b></font><font color="#000000"> LOOP;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt"></font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">spltt_line := ST_Split(inGeom,ST_Multi(ST_Collect(apoint)));</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt"></font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000"></font><font color="#7f0055"><b>drop</b></font><font color="#000000"> </font><font color="#7f0055"><b>table</b></font><font color="#000000"> if </font><font color="#7f0055"><b>exists</b></font><font color="#000000"> line_list_tmp;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000"></font><font color="#7f0055"><b>create</b></font><font color="#000000"> temp </font><font color="#7f0055"><b>table</b></font><font color="#000000"> line_list_tmp </font><font color="#7f0055"><b>as</b></font><font color="#000000"> (</font><font color="#7f0055"><b>select</b></font><font color="#000000"> (ST_Dump(spltt_line)).geom </font><font color="#7f0055"><b>AS</b></font><font color="#000000"> line_part);</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt"></font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000"></font><font color="#000080">FOR</font><font color="#000000"> rec </font><font color="#7f0055"><b>IN</b></font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000"></font><font color="#7f0055"><b>SELECT</b></font><font color="#000000"> *</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000"></font><font color="#7f0055"><b>FROM</b></font><font color="#000000"> line_list_tmp</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">LOOP</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000">RAISE NOTICE </font><font color="#0000ff">'rec %'</font><font color="#000000">, ST_Length(rec.line_part);</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">json_input_structure_tmp.input_geo = rec.line_part;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">perform topo_ar5_forest.create_nocutline_edge_domain_try_one( border_topo_info, json_input_structure_tmp);</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000"></font><font color="#7f0055"><b>END</b></font><font color="#000000"> LOOP;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000"></font><font color="#7f0055"><b>END</b></font><font color="#000000"> IF;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">done_time := clock_timestamp();</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000">EXCEPTION WHEN OTHERS </font><font color="#7f0055"><b>THEN</b></font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000">RAISE NOTICE </font><font color="#0000ff">'failed ::::::1 %'</font><font color="#000000">, border_topo_info.border_layer_id;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">counter := 0;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">json_input_structure_tmp := topo_update.handle_input_json_props(json_feature::json,server_json_feature::json,border_topo_info.srid);</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">inGeom := json_input_structure.input_geo;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt"></font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt"></font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000"></font><font color="#000080">FOR</font><font color="#000000"> i </font><font color="#7f0055"><b>IN</b></font><font color="#000000"> 1..(ST_NPoints(inGeom)-1)</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">LOOP</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">border_topo_info.snap_tolerance := start_tolerance;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">counter:=counter+1;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">g := ST_MakeLine(ST_PointN(inGeom,i),ST_PointN(inGeom,i+1));</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">perform ST_setSrid(g,border_topo_info.srid);</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000"></font><font color="#7f0055"><b>BEGIN</b></font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt"></font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt"></font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">json_input_structure_tmp.input_geo = g;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">perform topo_ar5_forest.create_nocutline_edge_domain_try_one( border_topo_info, json_input_structure_tmp);</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt"></font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000"></font><font color="#408080">-- catch EXCEPTION</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000">EXCEPTION WHEN OTHERS </font><font color="#7f0055"><b>THEN</b></font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000">RAISE NOTICE </font><font color="#0000ff">'failed ::::::2 % num %, border_topo_info.snap_tolerance %'</font><font color="#000000">, border_topo_info.border_layer_id, i, border_topo_info.snap_tolerance;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">tolerance := border_topo_info.snap_tolerance;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">WHILE tolerance > 0 LOOP</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000">failed_to_insert := </font><font color="#4000c8"><b>false</b></font><font color="#000000">;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000">IF tolerance = 1 </font><font color="#7f0055"><b>THEN</b></font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">tolerance := 0.01;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">ELSE</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">tolerance := tolerance - 1;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000"></font><font color="#7f0055"><b>END</b></font><font color="#000000"> IF;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000">IF tolerance < 0 </font><font color="#7f0055"><b>THEN</b></font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">tolerance := 0;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000"></font><font color="#7f0055"><b>END</b></font><font color="#000000"> IF;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000"></font><font color="#7f0055"><b>BEGIN</b></font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">border_topo_info.snap_tolerance = tolerance ;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">perform topo_ar5_forest.create_nocutline_edge_domain_try_one( border_topo_info, json_input_structure_tmp);</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">exit;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000">EXCEPTION WHEN OTHERS </font><font color="#7f0055"><b>THEN</b></font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000">RAISE NOTICE </font><font color="#0000ff">'failed with with % : %'</font><font color="#000000">, ST_AsText(g), tolerance;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000">failed_to_insert := </font><font color="#4000c8"><b>true</b></font><font color="#000000">;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000"></font><font color="#7f0055"><b>END</b></font><font color="#000000">;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000"></font><font color="#7f0055"><b>END</b></font><font color="#000000"> LOOP;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000">IF failed_to_insert </font><font color="#7f0055"><b>THEN</b></font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">done_time := clock_timestamp();</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000">used_time := (EXTRACT(EPOCH </font><font color="#7f0055"><b>FROM</b></font><font color="#000000"> (done_time - start_time)));</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000">RAISE NOTICE </font><font color="#0000ff">'ERROR failed to use %, length: % tolerance : %'</font><font color="#000000">, ST_AsText(g), ST_length(g), tolerance;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000"></font><font color="#7f0055"><b>insert</b></font><font color="#000000"> </font><font color="#7f0055"><b>into</b></font><font color="#000000"> topo_ar5_forest.no_cut_line_failed(error_info,geo)</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000"></font><font color="#7f0055"><b>values</b></font><font color="#000000">(</font><font color="#0000ff">'Failed with exception time used '</font><font color="#000000"> || used_time::</font><font color="#7f0055"><b>varchar</b></font><font color="#000000"> || </font><font color="#0000ff">'
length '</font><font color="#000000"> || ST_length(g), g);</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000"></font><font color="#7f0055"><b>END</b></font><font color="#000000"> IF;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000"></font><font color="#7f0055"><b>END</b></font><font color="#000000">;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000"></font><font color="#7f0055"><b>END</b></font><font color="#000000"> LOOP;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt"></font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000"></font><font color="#7f0055"><b>END</b></font><font color="#000000">;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">done_time := clock_timestamp();</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000">used_time := (EXTRACT(EPOCH </font><font color="#7f0055"><b>FROM</b></font><font color="#000000"> (done_time - start_time)));</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000">IF used_time > 10 </font><font color="#7f0055"><b>THEN</b></font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000">RAISE NOTICE </font><font color="#0000ff">'very long single line % time with geo for % '</font><font color="#000000">, used_time, json_input_structure.input_geo;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000"></font><font color="#7f0055"><b>insert</b></font><font color="#000000"> </font><font color="#7f0055"><b>into</b></font><font color="#000000"> topo_ar5_forest.long_time_log1(execute_time,info,geo)</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000"></font><font color="#7f0055"><b>values</b></font><font color="#000000">(used_time,</font><font color="#0000ff">'long '</font><font color="#000000"> || used_time::</font><font color="#7f0055"><b>varchar</b></font><font color="#000000"> || </font><font color="#0000ff">'
num points '</font><font color="#000000"> || ST_NumPoints(json_input_structure.input_geo), json_input_structure.input_geo);</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#000000"></font><font color="#7f0055"><b>END</b></font><font color="#000000"> IF;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt"></font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">return;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font face="Monaco, monospace"><font style="font-size:11pt"><font color="#7f0055"><b>END</b></font><font color="#000000">;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<font color="#000000"><font face="Monaco, monospace"><font style="font-size:11pt">$$ LANGUAGE plpgsql;</font></font></font></p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
<br>
</p>
<p align="LEFT" style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin-bottom: 0in;">
Lars</p>
<blockquote style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, Helvetica, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 12pt; margin: 0px 0px 0px 40px; border: none; padding: 0px;">
<blockquote style="margin:0 0 0 40px; border:none; padding:0px">
<p style="margin-right:0px; margin-left:0px; font-stretch:normal; font-size:11px; line-height:normal; font-family:Monaco">
</p>
<p></p>
<div><br>
</div>
</blockquote>
</blockquote>
</div>
</div>
</div>
</body>
</html>