<div dir="ltr"><div>Yes thanks a lot I understand.<br></div>I did't see it first to write the question to the list.<br>:(<br></div><div class="gmail_extra"><br><div class="gmail_quote">2017-04-13 13:24 GMT+02:00 Olivier Leprêtre <span dir="ltr"><<a href="mailto:o.lepretre@gmail.com" target="_blank">o.lepretre@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div link="blue" vlink="purple" lang="FR"><div class="m_8297045088223226183WordSection1"><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d"><img id="m_8297045088223226183Image_x0020_1" src="cid:image001.png@01D2B459.38C1CE00" width="269" height="110"></span><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d"><u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d"><u></u> <u></u></span></p><div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0cm 0cm 0cm"><p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">De :</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> postgis-users [mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<wbr>lists.osgeo.org</a>] <b>De la part de</b> franco base<br><b>Envoyé :</b> jeudi 13 avril 2017 13:08<span class=""><br><b>À :</b> PostGIS Users Discussion<br><b>Objet :</b> Re: [postgis-users] st_distance meter/degree<u></u><u></u></span></span></p></div><p class="MsoNormal"><u></u> <u></u></p><div><div><div><p class="MsoNormal">Sorry.<u></u><u></u></p></div><div><div class="h5"><p class="MsoNormal">I don't see the <span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d" lang="EN-US">10-5at the end </span><u></u><u></u></p></div></div></div><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d" lang="EN-US">very sorry</span><u></u><u></u></p></div><div><div class="h5"><div><p class="MsoNormal"><u></u> <u></u></p><div><p class="MsoNormal">2017-04-13 13:05 GMT+02:00 Jorge Gustavo Rocha <<a href="mailto:jgr@di.uminho.pt" target="_blank">jgr@di.uminho.pt</a>>:<u></u><u></u></p><p class="MsoNormal">Hi Franco,<br><br>I did not understood your question.<br><br>Postgis calculates the distance/area according to the CRS unit. It the<br>CRS unit is degrees, the results is in degrees. If the CRS unit is<br>meter, the result is in meter.<br><br>For example, if you transform the geometry, like:<br>SELECT ST_Distance(ST_Transform(<wbr>geometry, 25829)) ...<br>the result will be in meter.<br><br>Regards,<br><br>Jorge<br><br>Às 11:54 de 13-04-2017, franco base escreveu:<br>> Thanks Jorge but it isn't the matter.<br>> I'd know why postgis have a different way to calculate the distance<br>> with the same sql query.<br>><br>> 2017-04-13 12:37 GMT+02:00 Jorge Gustavo Rocha <<a href="mailto:jgr@di.uminho.pt" target="_blank">jgr@di.uminho.pt</a><br>> <mailto:<a href="mailto:jgr@di.uminho.pt" target="_blank">jgr@di.uminho.pt</a>>>:<br>><br>> Hi Franco,<br>><br>> You can use the usual control statements IF THEN ELSE [1] to make it<br>> exactly like you want.<br>><br>> [1]<br>> <a href="https://www.postgresql.org/docs/current/static/plpgsql-control-structures.html" target="_blank">https://www.postgresql.org/<wbr>docs/current/static/plpgsql-<wbr>control-structures.html</a><br>> <<a href="https://www.postgresql.org/docs/current/static/plpgsql-control-structures.html" target="_blank">https://www.postgresql.org/<wbr>docs/current/static/plpgsql-<wbr>control-structures.html</a>><br>><br>> Regards,<br>><br>> Jorge<br>><br>> Às 10:57 de 13-04-2017, franco base escreveu:<br>> > Hi all.<br>> > Is it possible that st_distance between point return meter distance if<br>> > point are very close and degrees otherwise?<br>> ><br>> > SELECT ST_distance ( ST_SetSRID<br>> > (ST_MakePoint(45.<wbr>4553804010375,9.<wbr>11292550791171) ,4326), ST_SetSRID<br>> > (ST_MakePoint(45.<wbr>4553855607023,9.<wbr>11291318106981) ,4326))<br>> ><br>> > return 1.3 ( meter distance)<br>> ><br>> ><br>> > SELECT ST_distance ( ST_SetSRID<br>> > (ST_MakePoint(45.<wbr>4553804010375,9.<wbr>11292550791171) ,4326), ST_SetSRID<br>> > (ST_MakePoint(45.<wbr>4560699405679,9.1164832309759) ,4326))<br>> ><br>> > return 0.003 (degrees distance)<br>> ><br>> ><br>> > Thanks<br>> > fb<br>> ><br>> ><br>> ><br>> ><br>> ><br>> > ______________________________<wbr>_________________<br>> > postgis-users mailing list<br>> > <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a> <mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<wbr>osgeo.org</a>><br>> > <a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/postgis-users</a><br>> <<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/postgis-users</a><wbr>><br>> ><br>><br>> J. Gustavo<br>> --<br>> Jorge Gustavo Rocha<br>> Departamento de Informática<br>> Universidade do Minho<br>> 4710-057 Braga<br>> Tel: <a href="tel:%2B351%20253604480" target="_blank">+351 253604480</a> <<a href="tel:%2B351%20253604480" target="_blank">tel:%2B351%20253604480</a>><br>> Fax: <a href="tel:%2B351%20253604471" target="_blank">+351 253604471</a> <<a href="tel:%2B351%20253604471" target="_blank">tel:%2B351%20253604471</a>><br>> Móvel: <a href="tel:%2B351%20910333888" target="_blank">+351 910333888</a> <<a href="tel:%2B351%20910333888" target="_blank">tel:%2B351%20910333888</a>><br>> skype: nabocudnosor<br>> _____________________________<wbr>__________________<br>> postgis-users mailing list<br>> <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a> <mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<wbr>osgeo.org</a>><br>> <a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/postgis-users</a><br>> <<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/postgis-users</a><wbr>><u></u><u></u></p><div><div><p class="MsoNormal">><br>><br>><br>><br>> ______________________________<wbr>_________________<br>> postgis-users mailing list<br>> <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>> <a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/postgis-users</a><br>><br><br>J. Gustavo<br>--<br>Jorge Gustavo Rocha<br>Departamento de Informática<br>Universidade do Minho<br>4710-057 Braga<br>Tel: <a href="tel:%2B351%20253604480" target="_blank">+351 253604480</a><br>Fax: <a href="tel:%2B351%20253604471" target="_blank">+351 253604471</a><br>Móvel: <a href="tel:%2B351%20910333888" target="_blank">+351 910333888</a><br>skype: nabocudnosor<br>______________________________<wbr>_________________<br>postgis-users mailing list<br><a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/postgis-users</a><u></u><u></u></p></div></div></div><p class="MsoNormal"><u></u> <u></u></p></div></div></div></div><div id="m_8297045088223226183DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br><span class=""> <table style="border-top:1px solid #d3d4de">
<tbody><tr>
<td style="width:55px;padding-top:18px"><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif" style="width:46px;height:29px" width="46" height="29"></a></td>
<td style="width:470px;padding-top:17px;color:#41424e;font-size:13px;font-family:Arial,Helvetica,sans-serif;line-height:18px">Garanti sans virus. <a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" style="color:#4453ea" target="_blank">www.avast.com</a> </td>
</tr>
</tbody></table>
<a href="#m_8297045088223226183_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"> </a></span></div></div><br>______________________________<wbr>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/postgis-users</a><br></blockquote></div><br></div>