[pdal] sql query pgpointcloud

Florent Poux fpoux at ulg.ac.be
Fri May 19 04:32:32 PDT 2017


Thanks Howard for the answer,

Yes, for now i store it temporarly as a view that I then use in the post 
SQL, but I was thinking maybe it is possible to do it directly the PDAL 
way :).

Florent
>> On May 18, 2017, at 9:42 AM, Florent Poux <fpoux at ulg.ac.be> wrote:
>>
>> Hey all,
>>
>> I am struggling with a sql query within pg.pointcloud writer that you may have a solution for.
>>
>> is there a way to store the pre sql query as a variable that will be used for the post sql query ?
>>
>> specifically, i want to store as pre sql the count or max from a table, and pass this parameter to condition a query in the post sql, is that possible ?
>>
>> Thank you !
> Florent,
>
> There's no *PDAL* way to do this, but could you stash your variable in some kind of temporary (are there bound-to-session variables?, maybe another table) for use by the post sql?
>
> This reminds me I've wanted to make the PointView metadata available to DB writers' post_sql methods as a variable. Very similar to what we did for the writers.las https://www.pdal.io/tutorial/las.html#metadata-example I could see how this might be useful to downstream consumers.
>
> Howard
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pdal/attachments/20170519/14a84f38/attachment.html>


More information about the pdal mailing list