<div dir="ltr">Hi all,<div><br></div><div><br></div><div><i>question 1)</i></div><div>why <b>ST_Overlaps</b> doesn't work with geometry a and b?</div><div>The first 2 point of the 2 line (bold) are the same.</div><div><b>ST_Intersection</b> works</div><div><br></div><div><i>question 2) </i></div><div>if I extend line b it becomes c </div><div>(sorry i write text geometry because I have a lot of point coord),</div><div>

<b 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;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">ST_Overlaps</b>

return false and also </div><div>

<b 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;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">ST_Intersection</b> return a point (length =0)</div><div><br></div><div>What's happen?</div><div> </div><div>"POSTGIS="2.2.1 r14555" GEOS="3.5.0-CAPI-1.9.0 r4084" PROJ="Rel. 4.9.2, 08 September 2015" GDAL="GDAL 1.11.3, released 2015/09/16" LIBXML="2.9.3" LIBJSON="0.11.99" TOPOLOGY RASTER"<br></div><div><br></div><div><br></div><div><div>WITH geom AS</div><div>(</div><div>SELECT</div><div>st_setsrid(st_makeline( </div><div><b>st_makepoint(9.18284350788197,45.4441804010334), st_makepoint(9.18334214253396,45.4443310195606)</b></div><div><b>)</b>,4326) a,</div><div><br></div><div>st_setsrid(st_makeline(ARRAY[</div><div><b>st_makepoint(9.18334214253396,45.4443310195606), st_makepoint(9.18284350788197,45.4441804010334)</b>,</div><div>st_makepoint(9.18274220788201,45.4441483010334), st_makepoint(9.18274220788201,45.4441483010334),</div><div>st_makepoint(9.18271080788202,45.4441388010335), st_makepoint(9.18271080788202,45.4441388010335) ]),4326) b,</div><div><br></div><div><div>'0102000020E610000027000000E8527405DF5D224039CEBED6DFB846402A470DAA9D5D22403CFB43E7DAB8464073E7FC62905D22409DC1FDD9D9B8464073E7FC62905D22409DC1FDD9D9B8464040F560458C5D224065A94C8AD9B8464040F560458C5D224065A94C8AD9B84640577DD232875D224085179BAFDCB84640577DD232875D224085179BAFDCB84640C43B5CAF795D2240BB5EA7A0DBB84640BB366DB9795D2240D5A0759CDBB84640CB05C9E4095D2240CC685208D3B84640CB05C9E4095D2240CC685208D3B8464088EC7DE7A75C224074794263CBB8464088EC7DE7A75C224074794263CBB84640280A729E8B5C224050769668C9B84640280A729E8B5C224050769668C9B8464031A63554665C224097E12591C7B8464031A63554665C224097E12591C7B846409A92E968405C22406A63C10CC6B846409A92E968405C22406A63C10CC6B84640164A8CEC245C22402356E826C5B84640164A8CEC245C22402356E826C5B84640D4962A44065C22406FC51DC8C4B84640D4962A44065C22406FC51DC8C4B84640A5F78473E75B2240380991C0C4B84640A5F78473E75B2240380991C0C4B84640B08F6F2CB85B2240449DA518C5B84640B08F6F2CB85B2240449DA518C5B84640087D054BAA5B224050D0A632C5B84640087D054BAA5B224050D0A632C5B84640213C1ECBA65B2240F2CC5C39C5B84640213C1ECBA65B2240F2CC5C39C5B846406BDBF78AA35B2240F0C76D43C5B846406BDBF78AA35B2240F0C76D43C5B84640D731EDD8985B2240C676D265C5B84640D731EDD8985B2240C676D265C5B84640EFDF4074875B224027DB2F9DC5B846404443B89A605B2240369D5619C6B84640B521C808865B22404765B9A1C5B84640'::geometry as c</div></div><div>)</div><div><br></div><div><br></div><div>SELECT </div><div><i>---- question 1</i></div><div>st_overlaps(a,b),</div><div>st_length(st_intersection(a,b)::geography)::int,</div><div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;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">

<i><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;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">---- question 2</span><br></i></div><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;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial">st_overlaps(a,c),</div><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;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial">st_length(st_intersection(a,c)::geography)::int</div></div><div><br></div><div>FROM geom</div></div><div><br></div><div><br></div><div>return <br></div><div><br></div><div>f;42;f;0<br></div><div><br></div><div><br></div><div><br></div><div>thanks</div><div>ft</div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div></div>