[pgpointcloud] stuck getting data into pgpointcloud

[Rémi Cura]

WITH filtered_patch AS ( -- filter patch so they only contain points with
relevant class
SELECT
*PC_FilterEquals(your_patch_column, 'Class', your_class_value)as f_patch*


*FROM your_patch_table)*

*SELECT point*
*FROM *filtered_patch, pc_explode(f_patch) AS point
...

Cheers,
Rémi-C

2016-07-25 4:33 GMT+02:00 Adam Steer <Adam.Steer at anu.edu.au>:

> Hi Rémi
>
> >
> > Are you sure you use pc_patch(your set of points) before inserting
> anything?
> > It does not look to be the cas ein your sql example.
>
> For my manual example, no. This would explain the wrong wkb size!
>
> However, in the PDAL pipeline I just followed what examples I can find and
> assume PDAL handles conversion to patches.
>
> As mentioned, If I don’t pre set a PCID, I can ingest data. The invented
> schema has all the (16) data fields in my .LAS files, but you need to read
> the schema to figure out where everything gets put.
>
> I wonder, if I pre-determine the PCID in the PDAL pipeline -  should I use
> the ‘SQL before’ option in PDAL’s pipeline to convert points to patches? I
> haven’t tried to test this yet.
>
> …now on to the next part! how to select points by classification from
> postgis-pointcloud. I better work on my SQL skills (among others)
>
> Thanks again
> Adam
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgpointcloud/attachments/20160725/aaa6d9bc/attachment.html>