[pdal] how to work around issue 225

[Steven M. Ottens]

Hi List,

I am trying to import the Dutch LIDAR data, a wopping 30104 LAZ files 
(459GB), into postgresql using PDAL. I'm using the setup as described in 
https://github.com/PDAL/PDAL/issues/270 and with the help of Howard I've 
managed to get data into the database at a reasonable pace.

However not all LAZ files have the same schema, so at some point during 
the import I'm receiving these kind of errors:
Caught PDAL exception: ERROR:  column pcid (1) and patch pcid (2) are 
not consistent

I am not reprojecting the data, the source and destination have the same 
projection. I noticed that the schema's of the LAZ files differ, 
depending on the actual location on the map. I've picked 3 LAZ files 
around the country to check the schema and they use the same UUIDs for 
the axis, but have a different offset. (see below)

Is there a way to make sure that PDAL looks for a compatible PCID in the 
pointcloud_formats table and if it doesn't exist create a new PCID?

I'm not looking forward to manually check all 30000 files for its schema 
and couple it with the correct PCID in the pipeline.xml

Kind regards,
Steven

north east:
drivers.las.reader.X                        0.01     200000 
int32_t         4
drivers.las.reader.Y                        0.01     500000 
int32_t         4
drivers.las.reader.Z                        0.01          0 
int32_t         4
X: UUID 2ee118d1-119e-4906-99c3-42934203f872
Y: UUID 87707eee-2f30-4979-9987-8ef747e30275
Z: UUID e74b5e41-95e6-4cf2-86ad-e3f5a996da5d

north west:
drivers.las.reader.X                        0.01     100000 
int32_t         4
drivers.las.reader.Y                        0.01     500000 
int32_t         4
drivers.las.reader.Z                        0.01          0 
int32_t         4
X: UUID 2ee118d1-119e-4906-99c3-42934203f872
Y: UUID 87707eee-2f30-4979-9987-8ef747e30275
Z: UUID e74b5e41-95e6-4cf2-86ad-e3f5a996da5d

south west:
drivers.las.reader.X                        0.01     100000 
int32_t         4
drivers.las.reader.Y                        0.01     400000 
int32_t         4
drivers.las.reader.Z                        0.01          0 
int32_t         4
X: UUID 2ee118d1-119e-4906-99c3-42934203f872
Y: UUID 87707eee-2f30-4979-9987-8ef747e30275
Z: UUID e74b5e41-95e6-4cf2-86ad-e3f5a996da5d