[postgis-users] PointCloud to Delaunay Triangles

[Nicolas Ribot]

Hi,

You may use a subquery to solve your issue:

select st_collect(geom)
from (select pc_explode(pa)::geometry as geom from tablename where cloud_id
= 994) as t;

Nicolas

On 5 August 2015 at 13:59, Jonathan Moules <J.Moules at hrwallingford.com>
wrote:

> Hi List,
>
> I have a pointcloud, and I want to turn it into a TIN (so I guess
> ST_DelaunayTriangles), and then measure the length of the sides of the
> triangles.
>
>
>
> Does anyone have any suggestions on how to do this, ideally in a
> performant fashion?
>
>
>
>
>
> I've tried a few things, but I'm currently struggling to just turn the
> points into the TIN. The following fails with the error "set-valued
> function called in context that cannot accept a set" – alas googling
> doesn't find anything that explains clearly what the error means. I'm
> guessing it doesn't want to use an aggregation function (st_union and
> st_accum also fail), but it's not clear why.
>
>
>
> SELECT
>
>             st_collect(pc_explode((pa))::geometry)
>
> from
>
>             TABLENAME where cloud_id = 994
>
>
>
> Any thoughts welcome.
>
>
>
> Thanks,
>
> Jonathan
>
> ------------------------------
>
> *HR Wallingford and its subsidiaries* uses faxes and emails for
> confidential and legally privileged business communications. They do not of
> themselves create legal commitments. Disclosure to parties other than
> addressees requires our specific consent. We are not liable for
> unauthorised disclosures nor reliance upon them.
> If you have received this message in error please advise us immediately
> and destroy all copies of it.
>
> HR Wallingford Limited
> Howbery Park, Wallingford, Oxfordshire, OX10 8BA, United Kingdom
> Registered in England No. 02562099
>
> ------------------------------
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150805/031e6cde/attachment.html>