[pgpointcloud] update attribute

[Oscar Martinez Rubi]

Hi Howard,

Thanks for the message. It would be, indeed, a nice feature to be added. 
However, being the data compressed, that means 
unpack(&uncompress),change,repack(&compress), so I wonder if in 
scenarios with many updates it would be better to use uncompressed data 
where at least the uncompress and compress are not done. That would also 
make the life easier on any (to-be-added) function that would allow to 
do that.

As you suggested another option is to directly try  row-per-point.

Anyway what I will do is try some approaches to see if I come up with 
something useful, if that is the case I let you know ;-)

Thanks again!

O.

On 05-11-13 21:27, Howard Butler wrote:
> On Nov 5, 2013, at 11:51 AM, Oscar Martinez Rubi <O.MartinezRubi at tudelft.nl> wrote:
>
>> Hi,
>>
>> Is there any recommendation on how to proceed when need to update some attribute (for example Intensity) in some points of a block?
>>
>> I mean, I can unpack the block, change the values, repack the block, and replace old block by new block...but it does not seem very elegant to me.
> Elegance costs. If you want fully updateable points, why not simply use one point per row instead of bothering at all with this stuff at all? pgpointcloud probably could stand some more convenience functions to make updating attributes possible, but behind the scenes it's going to be doing exactly as you describe. While the cost to properly index every attribute (and every point too if you wanted spatial indexes) is probably too much for most folks to take on when storing point cloud data, it would be a nice feature for pgpointcloud to have.
>
> Howard
>
>
> _______________________________________________
> pgpointcloud mailing list
> pgpointcloud at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/pgpointcloud