pointcloud_postgis

将激光雷达点云与PostGIS几何类型相集成
仓库
pgpointcloud/pointcloud
https://github.com/pgpointcloud/pointcloud
源码
pointcloud-1.2.5.tar.gz
pointcloud-1.2.5.tar.gz

概览

扩展包名版本分类许可证语言
pointcloud1.2.5GISBSD-3-ClauseC
ID扩展名BinLibLoadCreateTrustReloc模式
1520pointcloud否是否是否否-
1521pointcloud_postgis否是否是是否-
相关扩展postgis pointcloud postgis_raster pgh_raster ogr_fdw pgrouting q3c h3

版本

类型仓库版本PG 大版本包名依赖
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
u26.x86_64PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5
u26.aarch64PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5PGDG 1.2.5

安装

您可以直接安装 pointcloud 扩展包的预置二进制包，首先确保 PGDG 仓库已经添加并启用：

BASH 
pig repo add pgdg -u          # 添加 PGDG 仓库并更新缓存

使用 pig 或者是 apt/yum/dnf 安装扩展：

安装
BASH 
pig install pointcloud;          # 当前活跃 PG 版本安装
pig
BASH 
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
BASH 
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
BASH 
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

创建扩展：

SQL 
CREATE EXTENSION pointcloud_postgis CASCADE;  -- 依赖: postgis, pointcloud

用法

pointcloud_postgis: pgPointcloud 的 PostGIS 集成

pointcloud_postgis 是将 pgPointcloud 扩展与 PostGIS 集成的桥接扩展。它实现了点云几何类型与 PostGIS 几何类型之间的转换。

SQL 
CREATE EXTENSION pointcloud_postgis;

该扩展需要同时安装 pointcloud 和 postgis。它添加了在 pcpoint/pcpatch 类型与 PostGIS geometry 类型之间转换的函数，使得可以使用 PostGIS 运算符和函数对点云数据进行空间查询。


最后修改 2026-08-12 · extension update 2026-08-12 (7a2fdbbd)