pointcloud_postgis

integration for pointcloud LIDAR data and PostGIS geometry data

Overview

Package	Version	Category	License	Language
`pointcloud`	`1.2.5`	GIS	BSD-3-Clause	C

ID	Extension	Bin	Lib	Load	Create	Trust	Reloc	Schema
1520	`pointcloud`	No	Yes	No	Yes	No	No	-
1521	`pointcloud_postgis`	No	Yes	No	Yes	Yes	No	-

Related	`postgis` `pointcloud` `postgis_raster` `pgh_raster` `ogr_fdw` `pgrouting` `q3c` `h3`

Version

Type	Repo	Version	PG Ver	Package	Deps
EXT	PGDG	`1.2.5`	1817161514	`pointcloud`	`postgis`, `pointcloud`
RPM	PGDG	`1.2.5`	1817161514	`pointcloud_$v`	-
DEB	PGDG	`1.2.5`	1817161514	`postgresql-$v-pointcloud`	-

OS / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5
el8.aarch64	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5
el9.x86_64	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5
el9.aarch64	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5
el10.x86_64	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5
el10.aarch64	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5
d12.x86_64	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5
d12.aarch64	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5
d13.x86_64	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5
d13.aarch64	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5
u22.x86_64	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5
u22.aarch64	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5
u24.x86_64	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5
u24.aarch64	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5
u26.x86_64	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5
u26.aarch64	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5	PGDG 1.2.5	PGDG 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:

Install

pig install pointcloud;          # Install for current active PG version

pig

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

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

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.

pointcloud_postgis

Overview

Version

Install

Usage

Was this page helpful?