<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" id="owaParaStyle"></style>
</head>
<body fpstyle="1" ocsi="0">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">
<div><font face="Times New Roman" size="3">> </font><span style="font-family: 'Segoe UI', Helvetica, Arial, sans-serif; font-size: medium;">Would it be possible to specify a special geometry type using integer values instead of doubles?</span></div>
<div><font face="Times New Roman" size="3"><br>
</font></div>
<div><span style="font-family: 'Times New Roman'; font-size: medium;">Very intriguing. </span><font face="Times New Roman" size="3">Regarding integer geometry (a</font><span style="font-family: 'Times New Roman'; font-size: medium;">s long as we are spitballing),</span><span style="font-family: 'Times New Roman'; font-size: medium;"> </span><span style="font-family: 'Times New Roman'; font-size: medium;">what
about taking it a step further and essentially defining the geometry by something similar to ST_SnapToGrid-- a slightly more complicated approach, but may be more generic, and could use integers for the underlying approach.</span></div>
<div><span style="font-family: 'Times New Roman'; font-size: medium;"><br>
</span></div>
<div><font face="Times New Roman" size="3">All that said, AFAIU, the underlying library, GEOS, would still cast the values back to float to do geometry calculations, which may be just fine, as floating point calculations are often first class citizens on processors.
So (speaking not as a PostGIS developer...) the speed increases you are seeing may be the result of IO improvements-- sheer data volume reductions, not computational reductions.</font></div>
<div><font face="Times New Roman" size="3"><br>
</font></div>
<div><font face="Times New Roman" size="3">Anyway, very interesting.</font></div>
<div><font face="Times New Roman" size="3">Best,</font></div>
<div><font face="Times New Roman" size="3">Steve</font></div>
<div><font face="Times New Roman" size="3"><br>
</font></div>
<div><font face="Times New Roman" size="3">postscript:</font></div>
<div><span style="font-family: 'Times New Roman'; font-size: medium;"><br>
</span></div>
<div><span style="font-family: 'Times New Roman'; font-size: medium;">I wouldn't round to a foot with LiDAR-- your precision is irrelevant, but your relative accuracy may be in the sub-inch/centimeter range. Certainly would bin well to hundredths of a unit
however.</span></div>
<div><span style="font-family: 'Times New Roman'; font-size: medium;"><br>
</span></div>
</div>
</body>
</html>