pointcloud_postgis

integration for pointcloud LIDAR data and PostGIS geometry data
Repository
pgpointcloud/pointcloud
https://github.com/pgpointcloud/pointcloud
Source
pointcloud-1.2.5.tar.gz
pointcloud-1.2.5.tar.gz

Overview

PackageVersionCategoryLicenseLanguage
pointcloud1.2.5GISBSD 3-ClauseC
IDExtensionBinLibLoadCreateTrustRelocSchema
1520pointcloudNoYesNoYesNoNo-
1521pointcloud_postgisNoYesNoYesYesNo-
Relatedpostgis pointcloud postgis_raster postgis_topology postgis_sfcgal postgis_tiger_geocoder address_standardizer address_standardizer_data_us pgrouting h3

Version

TypeRepoVersionPG VerPackageDeps
EXTPGDG1.2.51817161514pointcloudpostgis, pointcloud
RPMPGDG1.2.51817161514pointcloud_$v-
DEBPGDG1.2.51817161514postgresql-$v-pointcloud-
OS / PGPG18PG17PG16PG15PG14
el8.x86_64PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5
el8.aarch64PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5
el9.x86_64PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5
el9.aarch64PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5
el10.x86_64PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5
el10.aarch64PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5
d12.x86_64PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5
d12.aarch64PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5
d13.x86_64PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5
d13.aarch64PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5
u22.x86_64PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5
u22.aarch64PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5
u24.x86_64PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5
u24.aarch64PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5

Install

You can install pointcloud directly. First, make sure the PGDG repository is added and enabled:

pig repo add pgdg -u          # Add PGDG repo and update cache

Install the extension using pig or apt/yum/dnf:

pig install pointcloud;          # Install for current active PG version

pig ext install -y pointcloud -v 18  # PG 18
pig ext install -y pointcloud -v 17  # PG 17
pig ext install -y pointcloud -v 16  # PG 16
pig ext install -y pointcloud -v 15  # PG 15
pig ext install -y pointcloud -v 14  # PG 14

dnf install -y pointcloud_18       # PG 18
dnf install -y pointcloud_17       # PG 17
dnf install -y pointcloud_16       # PG 16
dnf install -y pointcloud_15       # PG 15
dnf install -y pointcloud_14       # PG 14

apt install -y postgresql-18-pointcloud   # PG 18
apt install -y postgresql-17-pointcloud   # PG 17
apt install -y postgresql-16-pointcloud   # PG 16
apt install -y postgresql-15-pointcloud   # PG 15
apt install -y postgresql-14-pointcloud   # PG 14

Create Extension:

CREATE EXTENSION pointcloud_postgis CASCADE;  -- requires: postgis, pointcloud

Usage

pointcloud_postgis: PostGIS integration for pgPointcloud

pointcloud_postgis is a bridge extension that integrates the pgPointcloud extension with PostGIS. It enables conversion between pointcloud geometry types and PostGIS geometry types.

CREATE EXTENSION pointcloud_postgis;

This extension requires both pointcloud and postgis to be installed. It adds functions to convert between pcpoint/pcpatch types and PostGIS geometry types, enabling spatial queries on point cloud data using PostGIS operators and functions.


Last Modified 2026-03-12: add pg extension catalog (95749bf)