pointcloud_postgis

integration for pointcloud LIDAR data and PostGIS geometry data

BSD-3-Clause

PGDG

pointcloud : integration for pointcloud LIDAR data and PostGIS geometry data

Overview

ID	Extension	Package	Version	Category	License	Language
1521	pointcloud_postgis	pointcloud	`1.2.5`	GIS	BSD-3-Clause	C

Attribute	Has Binary	Has Library	Need Load	Has DDL	Relocatable	Trusted
--s-dt-	No	Yes	No	Yes	no	yes

Relationships
Requires	postgis pointcloud
See Also	postgis_raster pgh_raster ogr_fdw pgrouting q3c h3
Siblings	pointcloud

Packages

Type	Repo	Version	PG Major Compatibility	Package Pattern	Dependencies
EXT	PGDG	`1.2.5`	18 17 16 15 14	`pointcloud`	`postgis`, `pointcloud`
RPM	PGDG	`1.2.5`	18 17 16 15 14	`pointcloud_$v`	-
DEB	PGDG	`1.2.5`	18 17 16 15 14	`postgresql-$v-pointcloud`	-

Linux / 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

Source

Repository

github.com/pgpointcloud/pointcloud

Source Tarball

pointcloud-1.2.5.tar.gz

Install

Make sure PGDG repo available:

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

Install this extension with pig:

pig install pointcloud;		# install via package name, for the active PG version
pig install pointcloud_postgis;		# install by extension name, for the current active PG version

pig install pointcloud_postgis -v 18;   # install for PG 18
pig install pointcloud_postgis -v 17;   # install for PG 17
pig install pointcloud_postgis -v 16;   # install for PG 16
pig install pointcloud_postgis -v 15;   # install for PG 15
pig install pointcloud_postgis -v 14;   # install for PG 14

Create this extension with:

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.