<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif;" dir="ltr">
<p style="margin-bottom: 0in; font-family: -webkit-standard;">Hi</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;"><br>
</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;">We have one issue/problem and that is how to handle Tolerance/SnapTo in a good way when working in degrees.</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;"><br>
</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;">We work on maps that covers all of Norway so we use degrees https://epsg.io/4258 . We also use Postgis Topology, which means that we just have add new lines both for surface and line layers and let
Postgis Topology take care generating the surfaces so this samples I just focus on lines.</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;"><br>
</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;">A description and some code pieces to illustrate the problem:</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;"><br>
</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;"><b>A: Layers in meter </b></p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;"><br>
</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;">First we show that this works well when working in meter. I create a Postgis Topology layer with layer_precision 10 meter using https://epsg.io/25833. Then we add 4 horizontal lines and 4 vertical
lines using a precision with 2 meter. Postgis Topology handles this nicely and we end with total of 4 lines and not 8 lines as we added, because every second line snaps to the line added before because the distance between the lines are less 2 meter which
use as precision we used when adding new lines.</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;"><br>
</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;">The sample code :<a href="https://github.com/NibioOpenSource/pgtopo_update_sql/blob/develop/src/test/sql/snapto/snapto_code_example_meter.sql" id="LPlnk90327" class="OWAAutoLink" previewremoved="true">https://github.com/NibioOpenSource/pgtopo_update_sql/blob/develop/src/test/sql/snapto/snapto_code_example_meter.sql</a></p>
<br>
<p style="margin-bottom: 0in; font-family: -webkit-standard;"><br>
</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;">A image of the result :<a href="https://github.com/NibioOpenSource/pgtopo_update_sql/blob/develop/src/test/sql/snapto/snapto_code_example_meter.png" id="LPlnk302956" class="OWAAutoLink" previewremoved="true">https://github.com/NibioOpenSource/pgtopo_update_sql/blob/develop/src/test/sql/snapto/snapto_code_example_meter.png</a></p>
<p></p>
<p></p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;"><br>
</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;">The green lines are the lines we added, the red lines are the lines that are stored in the edge table.</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;"><br>
</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;"><b>Layers in degrees :</b></p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;"><br>
</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;">But when we are using degrees things starts be more difficult. The reason why we are using degrees is to get a accurate transformations to local UTM zones which are different depending on where in
Norway you are.</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;"><br>
</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;">So the problem is how to use tolerances so we get a behavior equal to the test using meter.</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;"><br>
</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;">We can we define the layer in Postgis Topology with quite big value because this is just max value as it seems. So we can adjust the tolerance parameter as we add lines but the problem is that we
need to adjust this parameter depending on where we are and what orientation the line has. For vertical lines we need a bigger tolerance than for horizontal lines in Norway. This makes it quite complicated to handle adding new lines.</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;"><br>
</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;">The sample code :<a href="https://github.com/NibioOpenSource/pgtopo_update_sql/blob/develop/src/test/sql/snapto/snapto_code_example_degrees.sql" id="LPlnk421152" class="OWAAutoLink" previewremoved="true">https://github.com/NibioOpenSource/pgtopo_update_sql/blob/develop/src/test/sql/snapto/snapto_code_example_degrees.sql</a></p>
<br>
<p style="margin-bottom: 0in; font-family: -webkit-standard;"><br>
</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;">A image of the result :<a href="https://github.com/NibioOpenSource/pgtopo_update_sql/blob/develop/src/test/sql/snapto/snapto_code_example_degrees.png" id="LPlnk419200" class="OWAAutoLink" previewremoved="true">https://github.com/NibioOpenSource/pgtopo_update_sql/blob/develop/src/test/sql/snapto/snapto_code_example_degrees.png</a></p>
<p></p>
<p></p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;"><br>
</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;"><br>
</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;">The green lines are the lines we added, the red lines are the lines that are stored in the edge table.</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;"><br>
</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;">It real life it's impossible to do it this because water, farm land are not built up by horizontal and vertical lines only. Since we use Postgis Topology we could split a line in the different line
parts and based on the angle select the best tolerance value but that is complicated and means extra computing. Another problem is that edges then will be broken up into unnecessary small pieces.</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;"><br>
</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;">Any ideas on how to handle this in a better way ?</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;"><br>
</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;">Can “PostGIS Geography Type” help us here ?</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;"><br>
</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;">Thanks Lars</p>
<p style="margin-bottom: 0in; font-family: -webkit-standard;"><br>
</p>
</div>
</body>
</html>