Questions tagged [pgpointcloud]

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

Filter by
Sorted by
Tagged with
1
vote
0answers
50 views

Inserting xyz as pointcloud points

I'm trying to insert some xyz point data into a pc_point, I get the error ERROR: array dimensions do not match schema dimensions of pcid = 1 running SELECT PC_MakePoint(1, ARRAY[-127, 45, 124.0, 4....
0
votes
0answers
45 views

pgpointcloud repackaging point or x, y, z geometries to patch

I have a pointcloud in PostgreSQL/postgis imported via PDAL, everything is fine, I chipped it into groups of 600 points, no problems. I then manipulated the data, first exploding the patches and ...
0
votes
0answers
44 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
45 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
103 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 ...