<html><head><style>body{font-family:Helvetica,Arial;font-size:13px}</style></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">(a) you’ll want to use pc_get to actually get the coordinate value and confirm the precision, you might just be seeing a text output artifact as the json is written out</div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">(b) you’ll want to check the pointcloud_formats entry for this pcid and see what the specified precision actually is</div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">(c) looks like you’re storing far more precision than you actually need, if you reduced it appropriately, per what you see in those results (lots of 0’s after the 6th digit) you’ll save lots of space probably</div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">P.</div> <div id="bloop_sign_1416268147267236864" class="bloop_sign">
        <title></title>
     
     
        <div>
            <br>
        </div>
        -- <br>
        Paul Ramsey<br>
        http://cleverelephant.ca<div>http://postgis.net
</div>
<script type="application/ld+json">
{
  "@context": "http://schema.org",
  "@type": "em",
  "name": "John Doe",
  "jobTitle": "Graduate research assistant",
  "affiliation": "University of Dreams",
  "additionalName": "Johnny",
  "url": "http://www.example.com",
  "address": {
    "@type": "PostalAddress",
    "streetAddress": "1234 Peach Drive",
    "addressLocality": "Wonderland",
    "addressRegion": "Georgia"
  }
}
</script>
     
</div> <br><p style="color:#000;">On November 17, 2014 at 3:46:40 PM, Ashley Mort (<a href="mailto:ashley_c_mort@raytheon.com">ashley_c_mort@raytheon.com</a>) wrote:</p> <blockquote type="cite" class="clean_bq"><span><div><div></div><div>Can someone please help me figure out why I am losing coordinate  
<br>precision when I use pdal's pgpoingcloud.writer to write into my  
<br>Postgres DB?
<br>
<br>I have a .las file in epsg:4326 and when I put it though my pdal  
<br>pipeline, I seem to lose precision (-122.1831470 will become -112.183)  
<br>when I query for it.
<br>
<br>Below is a sample point from my .las file, the output I get from  
<br>querying postgres, and the pipeline file that I used.  Can anyone point  
<br>out what I'm doing wrong?  Thanks!
<br>
<br>
<br>postgres@ubuntu:/home/stack/Downloads$ pdal info st2-helens.las -p 5
<br>{
<br>     "X": "-122.18314700000002",
<br>     "Y": "46.238651000000004",
<br>     "Z": "1161.8700000000001",
<br>     "Intensity": "0",
<br>     "ReturnNumber": "0",
<br>     "NumberOfReturns": "0",
<br>     "ScanDirectionFlag": "0",
<br>     "EdgeOfFlightLine": "0",
<br>     "Classification": "2",
<br>     "ScanAngleRank": "0",
<br>     "UserData": "0",
<br>     "PointSourceId": "20",
<br>     "Time": "0",
<br>     "Red": "205",
<br>     "Green": "205",
<br>     "Blue": "185"
<br>}
<br>
<br>lidarimport=# select PC_AsText(PC_Explode(pa)) from sthelens4326 limit 10;
<br>                                          pc_astext
<br>  {"pcid":3,"pt":[-122.211,46.1886,1874.3,0,0,0,0,0,1,0,0,12,0,242,242,238,1.1605
<br>3e+007,0]}
<br>  {"pcid":3,"pt":[-122.211,46.1886,1874.3,0,0,0,0,0,2,0,0,21,0,242,242,238,7.4041
<br>5e+006,0]}
<br>
<br><?xml version="1.0" encoding="UTF-8"?>
<br><Pipeline version="1.0">
<br>   <Writer type="drivers.pgpointcloud.writer">
<br>     <Option name="connection">dbname='lidar' user='postgres'  
<br>password='password'</Option>
<br>     <Option name="table">StHelens4326</Option>
<br>     <Option name="srid">4326</Option>
<br>     <Filter type="filters.chipper">
<br>       <Option name="capacity">400</Option>
<br>       <Filter type="filters.cache">
<br>         <Reader type="drivers.las.reader">
<br>           <Option name="filename">st2-helens.las</Option>
<br>           <Option name="spatialreference">EPSG:4326</Option>
<br>         </Reader>
<br>       </Filter>
<br>     </Filter>
<br>   </Writer>
<br></Pipeline>
<br>
<br>--  
<br>Ashley Mort
<br>Sr. Software Engineer
<br>Raytheon - Intelligence and Information Systems
<br>972-205-5165 (office)
<br>814-571-3039 (cell)
<br>
<br>_______________________________________________
<br>pdal mailing list
<br>pdal@lists.osgeo.org
<br>http://lists.osgeo.org/mailman/listinfo/pdal
<br></div></div></span></blockquote></body></html>