'Re: [postgis-users] PointCloud to Delaunay Triangles'

[prev in list] [next in list] [prev in thread] [next in thread] 

List: postgis-users
Subject: Re: [postgis-users] PointCloud to Delaunay Triangles
From: Nicolas Ribot <nicolas.ribot () gmail ! com>
Date: 2015-08-05 15:47:34
Message-ID: CAGAwT=1Q1e2FWgOiRoGS8ScsrJBzBvupnO3AvNqbMtuGZoCsgQ () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]

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@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@lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>

[Attachment #5 (text/html)]

<div dir="ltr">Hi,<div><br></div><div>You may use a subquery to solve your \
issue:</div><div><br></div><div>select st_collect(geom)</div><div>from (select \
pc_explode(pa)::geometry as geom from tablename where cloud_id = 994) as \
t;</div><div><br></div><div>Nicolas</div></div><div class="gmail_extra"><br><div \
class="gmail_quote">On 5 August 2015 at 13:59, Jonathan Moules <span dir="ltr">&lt;<a \
href="mailto:J.Moules@hrwallingford.com" \
target="_blank">J.Moules@hrwallingford.com</a>&gt;</span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">

<div lang="EN-GB" link="blue" vlink="purple">
<div>
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&#39;ve \
tried a few things, but I&#39;m currently struggling to just turn the points into the \
TIN. The following fails with the error &quot;set-valued function called in context \
that cannot accept a set&quot; – alas googling doesn&#39;t find anything that \
explains clearly what the error means. I&#39;m guessing it doesn&#39;t want to use an \
aggregation function (st_union and st_accum also fail), but it&#39;s not clear \
why. \
 SELECT
 
 \
st_collect(pc_explode((pa))::geometry) from
 \
TABLENAME where cloud_id = 994 \
 Any \
thoughts welcome. \
 Thanks,
 Jonathan
 </div>
 
<hr>
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 


<hr>

</div>

<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" \
rel="noreferrer" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br></blockquote></div><br></div>

_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

[prev in list] [next in list] [prev in thread] [next in thread] 