Questions tagged [pgpointcloud]

A PostgreSQL extension for storing point cloud (LIDAR) data.

Filter by
Sorted by
Tagged with
0
votes
0answers
23 views

Efficiently load pgpointcloud from PostGIS table values

Is it possible to efficiently load data into a pgpointcloud PCPatch table from an xyz type of table within the same database? The github read me says - “Usually you will only be creating tables for ...
2
votes
0answers
30 views

Point cloud query is very slow and not using parrallel scan or more memory

The following PostGIS query is running very slow (> 1 day for about 1 million records): UPDATE test.table1 SET area= ST_Area(PC_EnvelopeGeometry(pa)) WHERE area is null or area <> ...
2
votes
0answers
69 views

Parallel optimization for query over LiDAR dataset

I'm using PostGIS + pointcloud to store a huge dataset of LiDAR point (2M patches of 600points) I query this database to obtain the altimetic profile between two points. At the moment I have a huge ...