<div dir="ltr">Thanks I undesrtand.<div>Infact</div><div><br></div><div>SELECT st_contains(b,a)  return true.</div><div><br></div><div><br></div><div>I still don't understand why</div><div><br></div><div>

<div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial">SELECT  <span style="font-size:12.8px">st_intersection(a,b) return a line</span></div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><span style="font-size:12.8px">and </span></div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><span style="font-size:12.8px"><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">SELECT st_intersection(a,c) return a point</span></span></div>

and</div><div>

<div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;font-size:12.8px;background-color:rgb(255,255,255)"><span style="font-size:12.8px"><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">SELECT st_intersection(b,c) return a point</span></span></div><br class="gmail-Apple-interchange-newline">

<br></div><div><br></div><div>SELECT ST_AsText (c)<br></div><div><br></div><div>return</div><div><br></div><div>"LINESTRING(<b>9.18334214253396 45.4443310195606,9.18284350788197 45.4441804010334,9.18274220788201 45.4441483010334,9.18274220788201 45.4441483010334,9.18271080788202 45.4441388010335,9.18271080788202 45.4441388010335</b>,9.18267210788205 45.4442348010335,9.18267210788205 45.4442348010335,9.18256900788209 45.4442025010335,9.18256930788208 45.4442020010335,9.1817161078824 45.4439402010335,9.1817161078824 45.4439402010335,9.18096850788267 45.4437069010336,9.18096850788267 45.4437069010336,9.18075270788275 45.4436465010336,9.18075270788275 45.4436465010336,9.18046820788286 45.4435903010337,9.18046820788286 45.4435903010337,9.18017890788296 45.4435440010337,9.18017890788296 45.4435440010337,9.17996920788304 45.4435166010337,9.17996920788304 45.4435166010337,9.17973530788314 45.4435053010337,9.17973530788314 45.4435053010337,9.17950020788323 45.4435044010337,9.17950020788323 45.4435044010337,9.17913950788338 45.4435149010338,9.17913950788338 45.4435149010338,9.17903360788343 45.4435180010338,9.17903360788343 45.4435180010338,9.17900690788344 45.4435188010338,9.17900690788344 45.4435188010338,9.17898210788345 45.4435200010338,9.17898210788345 45.4435200010338,9.17890050788348 45.4435241010338,9.17890050788348 45.4435241010338,9.17876780788353 45.4435307010338,9.17847140788366 45.4435455010338,9.17875697558416 45.4435312419178)"<br></div><div><br></div><div>The first 6 point are the same that make b geometry</div><div><br></div><div>

<span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">>> st_makepoint(9.18334214253396,</span><wbr style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">45.4443310195606),</span><br style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">>> st_makepoint(9.18284350788197,</span><wbr style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">45.4441804010334),</span><br style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">>> st_makepoint(9.18274220788201,</span><wbr style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">45.4441483010334),</span><br style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">>> st_makepoint(9.18274220788201,</span><wbr style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">45.4441483010334),</span><br style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">>> st_makepoint(9.18271080788202,</span><wbr style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">45.4441388010335),</span><br style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">>> st_makepoint(9.18271080788202,</span><wbr style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">45.4441388010335)</span>

<br></div><div class="gmail_extra"><br></div><div class="gmail_extra">

<div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial">The first 2 point are the same that make a geometry</div>

<span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">>> st_makepoint(9.18284350788197,</span><wbr style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">45.4441804010334),</span><br style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">>> st_makepoint(9.18334214253396,</span><wbr style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">45.4443310195606)</span>

<br class="gmail-Apple-interchange-newline">

<br></div><div class="gmail_extra"><br></div><div class="gmail_extra"><br></div><div class="gmail_extra">thanks</div><div class="gmail_extra">f</div><div class="gmail_extra"><br></div><div class="gmail_extra"><br></div><div class="gmail_extra"><br></div><div class="gmail_extra"><br></div><div class="gmail_extra"><br></div><div class="gmail_extra"><br><div class="gmail_quote">2018-05-28 21:22 GMT+02:00 Paul Ramsey <span dir="ltr"><<a href="mailto:pramsey@cleverelephant.ca" target="_blank">pramsey@cleverelephant.ca</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Also knowing that the end points of a line string are considered the<br>
boundary of the linestring, not the interior...<br>
<div class="HOEnZb"><div class="h5"><br>
On Mon, May 28, 2018 at 12:21 PM, Paul Ramsey <<a href="mailto:pramsey@cleverelephant.ca">pramsey@cleverelephant.ca</a>> wrote:<br>
> Does knowing that an overlaps test is only true if the interiors of<br>
> both objects interact, but there is no full containment relationship<br>
> help you understand a little?<br>
><br>
> On Mon, May 28, 2018 at 8:03 AM, franco base <<a href="mailto:frenk.calza@gmail.com">frenk.calza@gmail.com</a>> wrote:<br>
>> Hi all,<br>
>><br>
>><br>
>> question 1)<br>
>> why ST_Overlaps doesn't work with geometry a and b?<br>
>> The first 2 point of the 2 line (bold) are the same.<br>
>> ST_Intersection works<br>
>><br>
>> question 2)<br>
>> if I extend line b it becomes c<br>
>> (sorry i write text geometry because I have a lot of point coord),<br>
>> ST_Overlaps return false and also<br>
>> ST_Intersection return a point (length =0)<br>
>><br>
>> What's happen?<br>
>><br>
>> "POSTGIS="2.2.1 r14555" GEOS="3.5.0-CAPI-1.9.0 r4084" PROJ="Rel. 4.9.2, 08<br>
>> September 2015" GDAL="GDAL 1.11.3, released 2015/09/16" LIBXML="2.9.3"<br>
>> LIBJSON="0.11.99" TOPOLOGY RASTER"<br>
>><br>
>><br>
>> WITH geom AS<br>
>> (<br>
>> SELECT<br>
>> st_setsrid(st_makeline(<br>
>> st_makepoint(9.18284350788197,<wbr>45.4441804010334),<br>
>> st_makepoint(9.18334214253396,<wbr>45.4443310195606)<br>
>> ),4326) a,<br>
>><br>
>> st_setsrid(st_makeline(ARRAY[<br>
>> st_makepoint(9.18334214253396,<wbr>45.4443310195606),<br>
>> st_makepoint(9.18284350788197,<wbr>45.4441804010334),<br>
>> st_makepoint(9.18274220788201,<wbr>45.4441483010334),<br>
>> st_makepoint(9.18274220788201,<wbr>45.4441483010334),<br>
>> st_makepoint(9.18271080788202,<wbr>45.4441388010335),<br>
>> st_makepoint(9.18271080788202,<wbr>45.4441388010335) ]),4326) b,<br>
>><br>
>> '<wbr>0102000020E610000027000000E852<wbr>7405DF5D224039CEBED6DFB846402A<wbr>470DAA9D5D22403CFB43E7DAB84640<wbr>73E7FC62905D22409DC1FDD9D9B846<wbr>4073E7FC62905D22409DC1FDD9D9B8<wbr>464040F560458C5D224065A94C8AD9<wbr>B8464040F560458C5D224065A94C8A<wbr>D9B84640577DD232875D224085179B<wbr>AFDCB84640577DD232875D22408517<wbr>9BAFDCB84640C43B5CAF795D2240BB<wbr>5EA7A0DBB84640BB366DB9795D2240<wbr>D5A0759CDBB84640CB05C9E4095D22<wbr>40CC685208D3B84640CB05C9E4095D<wbr>2240CC685208D3B8464088EC7DE7A7<wbr>5C224074794263CBB8464088EC7DE7<wbr>A75C224074794263CBB84640280A72<wbr>9E8B5C224050769668C9B84640280A<wbr>729E8B5C224050769668C9B8464031<wbr>A63554665C224097E12591C7B84640<wbr>31A63554665C224097E12591C7B846<wbr>409A92E968405C22406A63C10CC6B8<wbr>46409A92E968405C22406A63C10CC6<wbr>B84640164A8CEC245C22402356E826<wbr>C5B84640164A8CEC245C22402356E8<wbr>26C5B84640D4962A44065C22406FC5<wbr>1DC8C4B84640D4962A44065C22406F<wbr>C51DC8C4B84640A5F78473E75B2240<wbr>380991C0C4B84640A5F78473E75B22<wbr>40380991C0C4B84640B08F6F2CB85B<wbr>2240449DA518C5B84640B08F6F2CB8<wbr>5B2240449DA518C5B84640087D054B<wbr>AA5B224050D0A632C5B84640087D05<wbr>4BAA5B224050D0A632C5B84640213C<wbr>1ECBA65B2240F2CC5C39C5B8464021<wbr>3C1ECBA65B2240F2CC5C39C5B84640<wbr>6BDBF78AA35B2240F0C76D43C5B846<wbr>406BDBF78AA35B2240F0C76D43C5B8<wbr>4640D731EDD8985B2240C676D265C5<wbr>B84640D731EDD8985B2240C676D265<wbr>C5B84640EFDF4074875B224027DB2F<wbr>9DC5B846404443B89A605B2240369D<wbr>5619C6B84640B521C808865B224047<wbr>65B9A1C5B84640'::geometry<br>
>> as c<br>
>> )<br>
>><br>
>><br>
>> SELECT<br>
>> ---- question 1<br>
>> st_overlaps(a,b),<br>
>> st_length(st_intersection(a,b)<wbr>::geography)::int,<br>
>> ---- question 2<br>
>> st_overlaps(a,c),<br>
>> st_length(st_intersection(a,c)<wbr>::geography)::int<br>
>><br>
>> FROM geom<br>
>><br>
>><br>
>> return<br>
>><br>
>> f;42;f;0<br>
>><br>
>><br>
>><br>
>> thanks<br>
>> ft<br>
>><br>
>><br>
>><br>
>><br>
>><br>
>><br>
>><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>
______________________________<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></div></div></blockquote></div><br></div></div>