[pgpointcloud] garbage after pdal pipeline import
Tom van Tilburg
tom.van.tilburg at gmail.com
Mon Sep 28 03:01:43 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 pdal 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/pgpointcloud/attachments/20150928/43a31232/attachment.html>
More information about the pgpointcloud
mailing list