[pdal] pdal pipeline giving garbage in postgres

Tom van Tilburg tom.van.tilburg at gmail.com
Mon Sep 28 03:02:34 PDT 2015


I'm trying to get a las file in postgres with pdal, but end up with totally
wrong data as a result. Not sure where the problem lies, I did the same
procedure a year ago without problems, but in the meantime both pdal and
pgpointcloud have been updated. Hope someone can either confirm this or
point out the mistake I made
(posting this at the pgpointcloud list as well)

Here's the setting:
* pdal 1.0.1 (git-version: Release)
* pgpointcloud 1.1.0
* running on ubuntu linux
* small las file showing correct output in lastools

This is what I do:
- pdal info test.las --pgpointcloudschema schema.xml
- load the schema into the table pointcloud_formats
- pdal pipeline pipeline.xml
- SELECT PC_Summary(pa) FROM pointclouds.test

The resulting x and y values are totally out of bounds:
{"pcid":5, "npts":599, "srid":28992,
"compr":"none","dims":[{"pos":0,"name":"X","size":8,"type":"double","stats":{"min":1.39067e-309,"max":2.78134e-309,"avg":2.62811e-309}},{"pos":1,"name":"Y","size":8,"type":"double","stats":{"min":2.44838e+77,"max":2.448
(...)"

Pipeline file:
```
<?xml version="1.0" encoding="utf-8"?>
<Pipeline version="1.0">
    <Writer type="writers.pgpointcloud">
        <Option name="connection">host='localhost' dbname='mydb' user='me'
        password='secret'</Option>
        <Option name="schema">pointclouds</Option>
        <Option name="table">test</Option>
        <Option name="overwrite">false</Option>
        <Option name="srid">28992</Option>
        <Option name="pcid">5</Option>
        <Filter type="filters.chipper">
            <Option name="capacity">600</Option>
               <Reader type="readers.las">
                    <Option
                    name="filename">/tmp/test.las</Option>
                    <Option name="spatialreference">EPSG:28992</Option>
               </Reader>
        </Filter>
    </Writer>
</Pipeline>
```
Las file:
http://research.geodan.nl/sites/demos/test.pdal


Best,
 Tom
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pdal/attachments/20150928/0e5fada2/attachment.html>


More information about the pdal mailing list