<HTML><HEAD></HEAD>
<BODY dir=ltr>
<DIV dir=ltr>
<DIV style="FONT-FAMILY: 'Arial Narrow'; COLOR: #00002b; FONT-SIZE: 12pt">
<DIV>Hi</DIV>
<DIV> </DIV>
<DIV>I am running geometry at srid –1.</DIV>
<DIV> </DIV>
<DIV>I have an interesting anomaly when identifying or rejecting a st_length2d
linestring.</DIV>
<DIV> </DIV>
<DIV>I have a linestring with it’s own row and id, and a length of
1.50812109467324e-008 (according to postgis).</DIV>
<DIV> </DIV>
<DIV>However when I attempt to exempt all linestrings shorter that 0.02 this
very short linestring is included as being longer than .02.</DIV>
<DIV> </DIV>
<DIV>I checked the geometry on QGIS and it shows as being much shorter than its
immediate neighbours(lengths of 0.0625000012910668) that <U>are</U>
rejected as being shorter that 0.02.(perhaps a nervous drafter or an anomaly in
the transition from dxf)</DIV>
<DIV> </DIV>
<DIV>Actually, it still gets included even when I use st_length greater than
1.6. But it is finally rejected when using 1.7 as a minimum length.</DIV>
<DIV> </DIV>
<DIV>It’s almost like postgis is calculating the numerals and ignoring the
e-008.</DIV>
<DIV> </DIV>
<DIV>Is there another explanation for this(I hope)??</DIV>
<DIV> </DIV>
<DIV>Bob</DIV></DIV></DIV></BODY></HTML>