[pdal] readers.pgpointcloud

Mike Skaug mike.skaug at nsidc.org
Thu Dec 8 07:42:18 PST 2016


I'm working on a project where we are using pdal to ingest lidar data 
into a pgpointcloud enabled PostgreSQL database and then reading the 
data out into another format. At least that's the idea.

We set up a simple pipeline to write the data into the database:
{
     "pipeline":[
"/data/ILATM1B.002/2013.03.20/ILATM1B_20130320_141441.ATM4BT4.h5",
         {
             "type": "filters.chipper",
             "capacity": 500
         },
         {
             "type":"writers.pgpointcloud",
             "connection":"host='valkyrie-db' dbname='valkyrie' 
user='valkyrie' password='valkyrie'",
             "table":"patches"
         }
     ]
}

This reads a single file, chips it and writes it into the database. This 
works as expected.

However, this pipeline taken almost verbatim from the example: 
http://www.pdal.io/stages/readers.pgpointcloud.html, which is intended 
to read the data out of the database, fails:

{
     "pipeline":[
         {
             "type":"readers.pgpointcloud",
             "connection":"host='valkyrie-db' dbname='valkyrie' 
user='valkyrie' password='valkyrie'",
             "table":"patches",
             "column":"pa",
             "where":"PC_Explode(PC_Intersection(pa, 
'SRID=4326;POLYGON((-160.000 80.000, -20.000 80.00, -20.000 85.000, 
-160.000 85.000, -160.000 80.000))'::geometry))"
         },
         {
           "type":"writers.text",
           "filename":"output.txt"
         }
     ]
}

The error is `PDAL: JSON pipeline: Can't find file ' ' to open with 
'readers.pgpointcloud'.`

This seems to suggest that pdal is looking for an input file? Or might I 
get this error if it is not connecting to the database? (I assume that 
the database connection is fine because it is using the same 
`connection` option as the successful "writers.pgpointcloud" given above.)

Thanks for any suggestions.
--Mike


More information about the pdal mailing list