'Re: [postgis-users] Doubt about toTopoGeom tolerance'

[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Doubt about toTopoGeom tolerance
From:       Alexandre Silva <amsilva () infoportugal ! impresa ! pt>
Date:       2020-07-02 11:47:19
Message-ID: AM6PR03MB37997F1899B84CCAC9E6CD20EA6D0 () AM6PR03MB3799 ! eurprd03 ! prod ! outlook ! com
[Download RAW message or body]

Hi,

That's exactly what i'm trying to do.

If you can provide that query it would be very helpful.
By the way your blog post about qgis forms using pyqgis also helped me a lot.

Obrigado pela ajuda,
Alexandre Silva

________________________________
De: postgis-users <postgis-users-bounces@lists.osgeo.org> em nome de Alexandre Neto \
                <senhor.neto@gmail.com>
Enviado: 1 de julho de 2020 20:21
Para: PostGIS Users Discussion <postgis-users@lists.osgeo.org>
Assunto: Re: [postgis-users] Doubt about toTopoGeom tolerance

Ah, now I get what you want.

You want to fix undershoots and overshoots, right?

No, just topology snapping won't work, because it only snaps to vertexes. Notice that \
the nearby edge also needs a vertex added in the closest point to the end of line. \
Otherwise you will always have a topological error there even if it's 0.000001 m.

I think I have a query for that somewhere. Some time ago I was planning to do a blog \
post about it, but it never came out.

Let me see if I can find it.

Alexandre Neto

A quarta, 1/07/2020, 17:05, Alexandre Silva \
<amsilva@infoportugal.impresa.pt<mailto:amsilva@infoportugal.impresa.pt>> escreveu: \
Hi,

Sorry, i didn't explain myself clearly. I have a node (that is the end of an edge) \
that is less than 0.1m from another edge. If i use a tolerance of 0.2m it doesn't \
snap but if i use 0.5m it snaps to a node of that edge. Shouldn't it snap to the \
closest point on that edge, which is within the tolerance?

Thanks,
Alexandre Silva

________________________________
De: postgis-users <postgis-users-bounces@lists.osgeo.org<mailto:postgis-users-bounces@lists.osgeo.org>> \
                em nome de Alexandre Neto \
                <senhor.neto@gmail.com<mailto:senhor.neto@gmail.com>>
Enviado: 1 de julho de 2020 16:42
Para: PostGIS Users Discussion \
                <postgis-users@lists.osgeo.org<mailto:postgis-users@lists.osgeo.org>>
Assunto: Re: [postgis-users] Doubt about toTopoGeom tolerance

Hi,

I am not sure I understood your affirmation. wanting to snap to the nearest edge, its \
the same as using a very large tolerance.

Alexandre Neto

On Wed, Jul 1, 2020 at 3:47 PM Alexandre Silva \
<amsilva@infoportugal.impresa.pt<mailto:amsilva@infoportugal.impresa.pt>> wrote: Hi,

Thank you for your response.

I tried the solution you provided and the result was the same, however after \
increasing the tolerance the geometry did indeed snap to a nearby node. I thought \
that the snap was to the closest point on a nearby edge but it seems that it only \
snaps to nodes within the tolerance. What's the best way to snap a geometry to the \
closest point on a nearby edge? I cannot increase the tolerance as it would be error \
prone (to make the snap on one specific geometry I had to increase it from 0.1m to \
0.5m).

Thank you for your assistance,
Alexandre Silva

________________________________
De: postgis-users <postgis-users-bounces@lists.osgeo.org<mailto:postgis-users-bounces@lists.osgeo.org>> \
                em nome de Alexandre Neto \
                <senhor.neto@gmail.com<mailto:senhor.neto@gmail.com>>
Enviado: 29 de junho de 2020 23:49
Para: PostGIS Users Discussion \
                <postgis-users@lists.osgeo.org<mailto:postgis-users@lists.osgeo.org>>
Assunto: Re: [postgis-users] Doubt about toTopoGeom tolerance

Hi,

I have looked into the documentation, and it seems that there are two form of using \
toTopoGeom: 1. One to add new topogeometry an existing topology layer, and another to \
change an element. This is what you seem to be using. 2. The second form, with less \
arguments, is used ADD changes to existing topoGeometries. But, it says you may want \
to use clearTopoGeom(topo) to create a totally new shape.

My gut feeling is that since you already have the topogeometry in the topology, when \
you try to add it again, it will snap to the old geometry any way. My first try would \
be something like:

UPDATE lines_table
SET topo = topology.toTopoGeom(geom, clearTopoGeom(topo), 0.1)
WHERE id = 1263;

http://postgis.net/docs/manual-dev/toTopoGeom.html<https://eur01.safelinks.protection. \
outlook.com/?url=http%3A%2F%2Fpostgis.net%2Fdocs%2Fmanual-dev%2FtoTopoGeom.html&data=0 \
2%7C01%7Camsilva%40infoportugal.impresa.pt%7C4c3acf23e699491deb3008d81df4007f%7Cd227b2 \
e71c404f63b5132f3665c334e6%7C0%7C0%7C637292281107807008&sdata=Kg%2FOHhNj0IiufJkulowq2%2B2dTxKndSTP%2FFJInNJ3GXo%3D&reserved=0>

Good luck,

Alexandre Neto

On Mon, Jun 29, 2020 at 5:53 PM Alexandre Silva \
<amsilva@infoportugal.impresa.pt<mailto:amsilva@infoportugal.impresa.pt>> wrote: Hi,

I have trying using the topology to correct some data with marginal errors and in \
some particular cases i'd like to use a higher snap tolerance than the defined in the \
topology. The topology has a tolerance of 0.01m (using a metric projection) and some \
lines need an higher tolerance of 0.1m to be fixed. Here's the code i used to create \
the topology and to fix the particular cases:

SELECT topology.CreateTopology('a_topology', 3763, 0.01, true);

UPDATE lines_table
SET topo = topology.toTopoGeom(geom, 'a_topology', 1, 0.1)
WHERE id = 1263;

Even though the line is closer than 0.1m to another line, it isn't snapped. Am i \
thinking wrong here? Shouldn't the line be snapped? Which of the tolerances prevails? \
If this is the expected behaviour is there a better way to do what i'm trying to do?

Thanks in advance,

Alexandre Silva

[http://newsletter.impresapublishing.pt/i/barra_ip.jpg]
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org<mailto:postgis-users@lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/postgis-users<https://eur01.safelinks.protect \
ion.outlook.com/?url=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fpostgis-user \
s&data=02%7C01%7Camsilva%40infoportugal.impresa.pt%7C4c3acf23e699491deb3008d81df4007f% \
7Cd227b2e71c404f63b5132f3665c334e6%7C0%7C0%7C637292281107807008&sdata=BdSJgTiQ1HmpF8FDDH1hYvLZKwtNmzO3tZ2W068NZp4%3D&reserved=0>
 _______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org<mailto:postgis-users@lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/postgis-users<https://eur01.safelinks.protect \
ion.outlook.com/?url=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fpostgis-user \
s&data=02%7C01%7Camsilva%40infoportugal.impresa.pt%7C4c3acf23e699491deb3008d81df4007f% \
7Cd227b2e71c404f63b5132f3665c334e6%7C0%7C0%7C637292281107816999&sdata=fvDPMXFRcWZHIAO6ArpuyI%2B8wA7lEHSypbBx98Rj2qo%3D&reserved=0>
 _______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org<mailto:postgis-users@lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/postgis-users<https://eur01.safelinks.protect \
ion.outlook.com/?url=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fpostgis-user \
s&data=02%7C01%7Camsilva%40infoportugal.impresa.pt%7C4c3acf23e699491deb3008d81df4007f% \
7Cd227b2e71c404f63b5132f3665c334e6%7C0%7C0%7C637292281107816999&sdata=fvDPMXFRcWZHIAO6ArpuyI%2B8wA7lEHSypbBx98Rj2qo%3D&reserved=0>

[Attachment #3 (text/html)]

<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 style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; \
color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"> Hi,</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; \
color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"> <br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; \
color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"> That's exactly what i'm \
trying to do.</div> <div style="font-family: Calibri, Arial, Helvetica, sans-serif; \
font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"> <br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; \
color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"> If you can provide that \
query it would be very helpful. <br> </div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; \
color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"> By the way your blog \
post about qgis forms using pyqgis also helped me a lot.</div> <div \
style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: \
rgb(0, 0, 0); background-color: rgb(255, 255, 255);"> <br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; \
color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"> Obrigado pela \
ajuda,</div> <div style="font-family: Calibri, Arial, Helvetica, sans-serif; \
font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"> \
Alexandre Silva<br> </div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; \
color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"> <br>
</div>
<div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size: 11pt;" data-ogsc="" \
face="Calibri, sans-serif" color="#000000"><b>De:</b> postgis-users \
&lt;postgis-users-bounces@lists.osgeo.org&gt; em nome de Alexandre Neto \
&lt;senhor.neto@gmail.com&gt;<br> <b>Enviado:</b> 1 de julho de 2020 20:21<br>
<b>Para:</b> PostGIS Users Discussion &lt;postgis-users@lists.osgeo.org&gt;<br>
<b>Assunto:</b> Re: [postgis-users] Doubt about toTopoGeom tolerance</font>
<div>&nbsp;</div>
</div>
<div>
<div dir="auto">Ah, now I get what you want.
<div dir="auto"><br>
</div>
<div dir="auto">You want to fix undershoots and overshoots, right?</div>
<div dir="auto"><br>
</div>
<div dir="auto">No, just topology snapping won't work, because it only snaps to \
vertexes. Notice that the nearby edge also needs a vertex added in the closest point \
to the end of line. Otherwise you will always have a topological error there even if \
it's 0.000001  m.</div>
<div dir="auto"><br>
</div>
<div dir="auto">I think I have a query for that somewhere. Some time ago I was \
planning to do a blog post about it, but it never came out.</div> <div \
dir="auto"><br> </div>
<div dir="auto">Let me see if I can find it.</div>
<div dir="auto"><br>
</div>
<div dir="auto">Alexandre Neto</div>
</div>
<br>
<div class="x_gmail_quote">
<div dir="ltr" class="x_gmail_attr">A quarta, 1/07/2020, 17:05, Alexandre Silva \
&lt;<a href="mailto:amsilva@infoportugal.impresa.pt" rel="noreferrer noreferrer" \
target="_blank">amsilva@infoportugal.impresa.pt</a>&gt; escreveu:<br> </div>
<blockquote class="x_gmail_quote" style="margin:0 0 0 .8ex; border-left:1px #ccc \
solid; padding-left:1ex"> <div dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; \
color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"> Hi,</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; \
color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"> <br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; \
color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"> Sorry, i didn't explain \
myself clearly. I have a node (that is the end of an edge) that is less than 0.1m \
from another edge. If i use a tolerance of 0.2m it doesn't snap but if i use 0.5m it \
snaps to a node of that edge. <br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; \
color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"> Shouldn't it snap to the \
closest point on that edge, which is within the tolerance?</div> <div \
style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: \
rgb(0, 0, 0); background-color: rgb(255, 255, 255);"> <br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; \
color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"> Thanks,</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; \
color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"> Alexandre Silva<br>
</div>
<div>
<div id="x_m_-8514144916576301718m_-7788271071884546637m_-2850716158552805838Signature">
 <div></div>
</div>
</div>
<div>
<div id="x_m_-8514144916576301718m_-7788271071884546637m_-2850716158552805838appendonsend">
 </div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; \
color: rgb(0, 0, 0);"> <br>
</div>
<hr style="display:inline-block; width:98%">
<div id="x_m_-8514144916576301718m_-7788271071884546637m_-2850716158552805838divRplyFwdMsg" \
dir="ltr"> <font style="font-size: 11pt;" data-ogsc="" face="Calibri, sans-serif" \
color="#000000"><b>De:</b> postgis-users &lt;<a \
href="mailto:postgis-users-bounces@lists.osgeo.org" rel="noreferrer noreferrer \
noreferrer" target="_blank">postgis-users-bounces@lists.osgeo.org</a>&gt;  em nome de \
Alexandre Neto &lt;<a href="mailto:senhor.neto@gmail.com" rel="noreferrer noreferrer \
noreferrer" target="_blank">senhor.neto@gmail.com</a>&gt;<br> <b>Enviado:</b> 1 de \
julho de 2020 16:42<br> <b>Para:</b> PostGIS Users Discussion &lt;<a \
href="mailto:postgis-users@lists.osgeo.org" rel="noreferrer noreferrer noreferrer" \
target="_blank">postgis-users@lists.osgeo.org</a>&gt;<br> <b>Assunto:</b> Re: \
[postgis-users] Doubt about toTopoGeom tolerance</font> <div>&nbsp;</div>
</div>
<div>
<div dir="ltr">Hi,
<div><br>
</div>
<div>I am not sure I understood your affirmation. wanting to snap to the nearest \
edge, its the same as using a very large tolerance.</div> <div><br>
</div>
<div>Alexandre Neto</div>
</div>
<br>
<div>
<div dir="ltr">On Wed, Jul 1, 2020 at 3:47 PM Alexandre Silva &lt;<a \
href="mailto:amsilva@infoportugal.impresa.pt" rel="noreferrer noreferrer noreferrer" \
target="_blank">amsilva@infoportugal.impresa.pt</a>&gt; wrote:<br> </div>
<blockquote style="margin:0px 0px 0px 0.8ex; border-left:1px solid rgb(204,204,204); \
padding-left:1ex"> <div dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; \
color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"> Hi,</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; \
color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"> <br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; \
color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"> Thank you for your \
response.</div> <div style="font-family: Calibri, Arial, Helvetica, sans-serif; \
font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"> <br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; \
color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"> I tried the solution you \
provided and the result was the same, however after increasing the tolerance the \
geometry did indeed snap to a nearby node.</div> <div style="font-family: Calibri, \
Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: \
rgb(255, 255, 255);"> I thought that the snap was to the closest point on a nearby \
edge but it seems that it only snaps to nodes within the tolerance. What's the best \
way to snap a geometry to the closest point on a nearby edge? I cannot increase the \
tolerance as it would be error  prone (to make the snap on one specific geometry I \
had to increase it from 0.1m to 0.5m).</div> <div style="font-family: Calibri, Arial, \
Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: \
rgb(255, 255, 255);"> <br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; \
color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"> Thank you for your \
assistance,</div> <div style="font-family: Calibri, Arial, Helvetica, sans-serif; \
font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"> \
Alexandre Silva<br> </div>
<div>
<div id="x_m_-8514144916576301718m_-7788271071884546637m_-2850716158552805838x_gmail-m_2133870196473710605Signature">
 <div>
<div id="x_m_-8514144916576301718m_-7788271071884546637m_-2850716158552805838x_gmail-m_2133870196473710605divtagdefaultwrapper" \
dir="ltr" style="font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, \
255, 255); font-family: Calibri, Arial, Helvetica, sans-serif;"> <p \
style="margin-top:0px; margin-bottom:0px"><span \
id="x_m_-8514144916576301718m_-7788271071884546637m_-2850716158552805838x_gmail-m_2133870196473710605ms-rterangepaste-start"></span></p>
 <table style="color: rgb(33, 33, 33); font-size: 15px; width: 430px;" width="430">
<tbody>
<tr>
<td><br>
</td>
<td><br>
</td>
<td><br>
</td>
<td><br>
</td>
</tr>
</tbody>
</table>
<br>
<p style="margin-top:0px; margin-bottom:0px"></p>
</div>
</div>
</div>
</div>
<div>
<div id="x_m_-8514144916576301718m_-7788271071884546637m_-2850716158552805838x_gmail-m_2133870196473710605appendonsend">
 </div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; \
color: rgb(0, 0, 0);"> <br>
</div>
<hr style="display:inline-block; width:98%">
<div id="x_m_-8514144916576301718m_-7788271071884546637m_-2850716158552805838x_gmail-m_2133870196473710605divRplyFwdMsg" \
dir="ltr"> <font style="font-size: 11pt;" data-ogsc="" face="Calibri, sans-serif" \
color="#000000"><b>De:</b> postgis-users &lt;<a \
href="mailto:postgis-users-bounces@lists.osgeo.org" rel="noreferrer noreferrer \
noreferrer" target="_blank">postgis-users-bounces@lists.osgeo.org</a>&gt;  em nome de \
Alexandre Neto &lt;<a href="mailto:senhor.neto@gmail.com" rel="noreferrer noreferrer \
noreferrer" target="_blank">senhor.neto@gmail.com</a>&gt;<br> <b>Enviado:</b> 29 de \
junho de 2020 23:49<br> <b>Para:</b> PostGIS Users Discussion &lt;<a \
href="mailto:postgis-users@lists.osgeo.org" rel="noreferrer noreferrer noreferrer" \
target="_blank">postgis-users@lists.osgeo.org</a>&gt;<br> <b>Assunto:</b> Re: \
[postgis-users] Doubt about toTopoGeom tolerance</font> <div>&nbsp;</div>
</div>
<div>
<div dir="ltr">Hi,
<div><br>
</div>
<div>I have looked into the documentation, and it seems that there are two form of \
using toTopoGeom:</div> <div>1. One to add new topogeometry an existing topology \
layer, and another to change an element. This is what&nbsp;you seem to be \
using.</div> <div>2. The second form, with less arguments, is used ADD changes to \
existing topoGeometries. But, it says you may want to use clearTopoGeom(topo) to \
create a totally new shape.</div> <div><br>
</div>
<div>My gut feeling is that since you already have the topogeometry in the topology, \
when you try to add it again, it will snap to the old geometry any way.&nbsp;</div> \
<div>My first try would be something like:</div> <div><br>
</div>
<div><span style="color: rgb(0, 0, 0); font-family: Calibri, Arial, Helvetica, \
sans-serif; font-size: 16px;">UPDATE lines_table<br> </span><span style="color: \
rgb(0, 0, 0); font-family: Calibri, Arial, Helvetica, sans-serif; font-size: \
16px;"></span> <div style="color: rgb(0, 0, 0); font-family: Calibri, Arial, \
Helvetica, sans-serif; font-size: 16px;"> SET topo = topology.toTopoGeom(geom, \
clearTopoGeom(topo), 0.1)<br> </div>
<div style="color: rgb(0, 0, 0); font-family: Calibri, Arial, Helvetica, sans-serif; \
font-size: 16px;"> WHERE id = 1263;</div>
</div>
<div><br>
</div>
<div><a href="https://eur01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fpostgis \
.net%2Fdocs%2Fmanual-dev%2FtoTopoGeom.html&amp;data=02%7C01%7Camsilva%40infoportugal.i \
mpresa.pt%7C4c3acf23e699491deb3008d81df4007f%7Cd227b2e71c404f63b5132f3665c334e6%7C0%7C \
0%7C637292281107807008&amp;sdata=Kg%2FOHhNj0IiufJkulowq2%2B2dTxKndSTP%2FFJInNJ3GXo%3D&amp;reserved=0" \
originalsrc="http://postgis.net/docs/manual-dev/toTopoGeom.html" \
shash="UhqV8In9DWvWoqK8qSFaIQW4Sxw9P&#43;5BJaiBomP1nzZYoukhSE6EXp9l1bJYzWEQL/ZBYMxcrQP \
2wwBmcl/TnFUoZR&#43;ePPp62tejiySnj/x4OTjy8MbOJhjKB2mES9LzR&#43;sEhYvwinidRc6E9DXE8Pdo2SeSy9TvHZPXA2kiNiM=" \
rel="noreferrer noreferrer \
noreferrer">http://postgis.net/docs/manual-dev/toTopoGeom.html</a><br> </div>
<div><br>
</div>
<div>Good luck,</div>
<div><br>
</div>
<div>Alexandre Neto</div>
</div>
<br>
<div>
<div dir="ltr">On Mon, Jun 29, 2020 at 5:53 PM Alexandre Silva &lt;<a \
href="mailto:amsilva@infoportugal.impresa.pt" rel="noreferrer noreferrer noreferrer" \
target="_blank">amsilva@infoportugal.impresa.pt</a>&gt; wrote:<br> </div>
<blockquote style="margin:0px 0px 0px 0.8ex; border-left:1px solid rgb(204,204,204); \
padding-left:1ex"> <div dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; \
color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"> Hi,</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; \
color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"> <br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; \
color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"> I have trying using the \
topology to correct some data with marginal errors and in some particular cases i'd \
like to use a higher snap tolerance than the defined in the topology.</div> <div \
style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: \
rgb(0, 0, 0); background-color: rgb(255, 255, 255);"> The topology has a tolerance of \
0.01m (using a metric projection) and some lines need an higher tolerance of 0.1m to \
be fixed. Here's the code i used to create the topology and to fix the particular \
cases:</div> <div style="font-family: Calibri, Arial, Helvetica, sans-serif; \
font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"> <br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; \
color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"> SELECT \
topology.CreateTopology('a_topology', 3763, 0.01, true); <br> </div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; \
color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"> <span><br>
</span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; \
color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"> <span>UPDATE \
lines_table<br> </span>
<div>SET topo = topology.toTopoGeom(geom, 'a_topology', 1, 0.1)<span><br>
</span></div>
<div><span>WHERE id = 1263;</span></div>
<div><span><br>
</span></div>
<div><span>Even though the line is closer than 0.1m to another line, it isn't \
snapped. Am i thinking wrong here? Shouldn't the line be snapped? Which of the \
tolerances prevails?</span></div> <div><span>If this is the expected behaviour is \
there a better way to do what i'm trying to do?</span></div> <div><span></span><br>
</div>
</div>
<div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; \
color: rgb(0, 0, 0);"> Thanks in advance,<br>
</div>
<div id="x_m_-8514144916576301718m_-7788271071884546637m_-2850716158552805838x_gmail-m_2133870196473710605x_gmail-m_5023270528477521244Signature">
 <div>
<div id="x_m_-8514144916576301718m_-7788271071884546637m_-2850716158552805838x_gmail-m_2133870196473710605x_gmail-m_5023270528477521244divtagdefaultwrapper" \
dir="ltr" style="font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, \
255, 255); font-family: Calibri, Arial, Helvetica, sans-serif;"> <p \
style="margin-top:0px; margin-bottom:0px"><span \
id="x_m_-8514144916576301718m_-7788271071884546637m_-2850716158552805838x_gmail-m_2133870196473710605x_gmail-m_5023270528477521244ms-rterangepaste-start"></span></p>
 <table style="color: rgb(33, 33, 33); font-size: 15px; width: 430px;" width="430">
<tbody>
<tr>
<td>Alexandre Silva<br>
</td>
<td><br>
</td>
<td><br>
</td>
<td><br>
</td>
</tr>
</tbody>
</table>
<br>
<p style="margin-top:0px; margin-bottom:0px"></p>
</div>
</div>
</div>
</div>
<img src="http://newsletter.impresapublishing.pt/i/barra_ip.jpg"> </div>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" rel="noreferrer noreferrer noreferrer" \
target="_blank">postgis-users@lists.osgeo.org</a><br> <a \
href="https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.osgeo.or \
g%2Fmailman%2Flistinfo%2Fpostgis-users&amp;data=02%7C01%7Camsilva%40infoportugal.impre \
sa.pt%7C4c3acf23e699491deb3008d81df4007f%7Cd227b2e71c404f63b5132f3665c334e6%7C0%7C0%7C \
637292281107807008&amp;sdata=BdSJgTiQ1HmpF8FDDH1hYvLZKwtNmzO3tZ2W068NZp4%3D&amp;reserved=0" \
originalsrc="https://lists.osgeo.org/mailman/listinfo/postgis-users" \
shash="j3NUAJs5mUKWzLpWCTvULeZ0LS3SfR64QprFiC2yPy6xtbKnV7YS6e5DgSOhY42M3qm3caZsPTwFaF8 \
L/4Pho6dbuH8QxoDxfKZU3oBgQxpcAEEYr8jbrhDlIZDZ4D3TXB8yTHV6YvIVKZ0Fj3r8UMUgJ2q5cDw2/Swx6LxkiJU=" \
rel="noreferrer noreferrer noreferrer noreferrer" \
target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote>
 </div>
</div>
</div>
</div>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" rel="noreferrer noreferrer noreferrer" \
target="_blank">postgis-users@lists.osgeo.org</a><br> <a \
href="https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.osgeo.or \
g%2Fmailman%2Flistinfo%2Fpostgis-users&amp;data=02%7C01%7Camsilva%40infoportugal.impre \
sa.pt%7C4c3acf23e699491deb3008d81df4007f%7Cd227b2e71c404f63b5132f3665c334e6%7C0%7C0%7C \
637292281107816999&amp;sdata=fvDPMXFRcWZHIAO6ArpuyI%2B8wA7lEHSypbBx98Rj2qo%3D&amp;reserved=0" \
originalsrc="https://lists.osgeo.org/mailman/listinfo/postgis-users" \
shash="boKekidosx815tCdEKWKcfa9i18gdhTri120l4j7ZxBFhqHis6aVVGY//OKzqL2tWfiZf4hMv8Ll1it \
wpoYnB9/yyiEMG532ItsWjsUWfJoImz6eRBhJrnkLkWLq/YaZAVypxsmgjQmwiFvVxGK55f/veBFkKYkZIDBCJvM6sno=" \
rel="noreferrer noreferrer noreferrer noreferrer" \
target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote>
 </div>
</div>
</div>
</div>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" rel="noreferrer noreferrer noreferrer" \
target="_blank">postgis-users@lists.osgeo.org</a><br> <a \
href="https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.osgeo.or \
g%2Fmailman%2Flistinfo%2Fpostgis-users&amp;data=02%7C01%7Camsilva%40infoportugal.impre \
sa.pt%7C4c3acf23e699491deb3008d81df4007f%7Cd227b2e71c404f63b5132f3665c334e6%7C0%7C0%7C \
637292281107816999&amp;sdata=fvDPMXFRcWZHIAO6ArpuyI%2B8wA7lEHSypbBx98Rj2qo%3D&amp;reserved=0" \
originalsrc="https://lists.osgeo.org/mailman/listinfo/postgis-users" \
shash="boKekidosx815tCdEKWKcfa9i18gdhTri120l4j7ZxBFhqHis6aVVGY//OKzqL2tWfiZf4hMv8Ll1it \
wpoYnB9/yyiEMG532ItsWjsUWfJoImz6eRBhJrnkLkWLq/YaZAVypxsmgjQmwiFvVxGK55f/veBFkKYkZIDBCJvM6sno=" \
rel="noreferrer noreferrer noreferrer noreferrer" \
target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote>
 </div>
</div>
</div>
</body>
</html>

[Attachment #4 (unknown)]

_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users

[prev in list] [next in list] [prev in thread] [next in thread] 