pg_sphere

球面对象函数、运算符与索引支持

概览

扩展包名	版本	分类	许可证	语言
`pgsphere`	`1.5.2`	TYPE	BSD-3-Clause	C

ID	扩展名	Bin	Lib	Load	Create	Trust	Reloc	模式
3650	`pg_sphere`	否	是	否	是	否	是	-

相关扩展	`q3c` `postgis` `earthdistance` `pointcloud` `h3` `pgrouting` `mobilitydb` `ogr_fdw` `pg_geohash` `qdgc`

版本

类型	仓库	版本	PG 大版本	包名	依赖
EXT	MIXED	`1.5.2`	1817161514	`pgsphere`	-
RPM	PIGSTY	`1.5.2`	1817161514	`pgsphere_$v`	-
DEB	PGDG	`1.5.2`	1817161514	`postgresql-$v-pgsphere`	-

OS / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PIGSTY 1.5.2 el8.x86_64.pg18 : pgsphere_18 pgsphere_18-1.5.2-1PIGSTY.el8.x86_64.rpm PIGSTY · 1.5.2 · 125.2KiB	PIGSTY 1.5.2 el8.x86_64.pg17 : pgsphere_17 pgsphere_17-1.5.2-1PIGSTY.el8.x86_64.rpm PIGSTY · 1.5.2 · 125.2KiB	PIGSTY 1.5.2 el8.x86_64.pg16 : pgsphere_16 pgsphere_16-1.5.2-1PIGSTY.el8.x86_64.rpm PIGSTY · 1.5.2 · 125.3KiB	PIGSTY 1.5.2 el8.x86_64.pg15 : pgsphere_15 pgsphere_15-1.5.2-1PIGSTY.el8.x86_64.rpm PIGSTY · 1.5.2 · 127.2KiB	PIGSTY 1.5.2 el8.x86_64.pg14 : pgsphere_14 pgsphere_14-1.5.2-1PIGSTY.el8.x86_64.rpm PIGSTY · 1.5.2 · 127.1KiB
el8.aarch64	PIGSTY 1.5.2 el8.aarch64.pg18 : pgsphere_18 pgsphere_18-1.5.2-1PIGSTY.el8.aarch64.rpm PIGSTY · 1.5.2 · 122.2KiB	PIGSTY 1.5.2 el8.aarch64.pg17 : pgsphere_17 pgsphere_17-1.5.2-1PIGSTY.el8.aarch64.rpm PIGSTY · 1.5.2 · 122.2KiB	PIGSTY 1.5.2 el8.aarch64.pg16 : pgsphere_16 pgsphere_16-1.5.2-1PIGSTY.el8.aarch64.rpm PIGSTY · 1.5.2 · 122.2KiB	PIGSTY 1.5.2 el8.aarch64.pg15 : pgsphere_15 pgsphere_15-1.5.2-1PIGSTY.el8.aarch64.rpm PIGSTY · 1.5.2 · 124.1KiB	PIGSTY 1.5.2 el8.aarch64.pg14 : pgsphere_14 pgsphere_14-1.5.2-1PIGSTY.el8.aarch64.rpm PIGSTY · 1.5.2 · 124.1KiB
el9.x86_64	PIGSTY 1.5.2 el9.x86_64.pg18 : pgsphere_18 pgsphere_18-1.5.2-1PIGSTY.el9.x86_64.rpm PIGSTY · 1.5.2 · 118.2KiB	PIGSTY 1.5.2 el9.x86_64.pg17 : pgsphere_17 pgsphere_17-1.5.2-1PIGSTY.el9.x86_64.rpm PIGSTY · 1.5.2 · 118.2KiB	PIGSTY 1.5.2 el9.x86_64.pg16 : pgsphere_16 pgsphere_16-1.5.2-1PIGSTY.el9.x86_64.rpm PIGSTY · 1.5.2 · 118.2KiB	PIGSTY 1.5.2 el9.x86_64.pg15 : pgsphere_15 pgsphere_15-1.5.2-1PIGSTY.el9.x86_64.rpm PIGSTY · 1.5.2 · 114.7KiB	PIGSTY 1.5.2 el9.x86_64.pg14 : pgsphere_14 pgsphere_14-1.5.2-1PIGSTY.el9.x86_64.rpm PIGSTY · 1.5.2 · 114.6KiB
el9.aarch64	PIGSTY 1.5.2 el9.aarch64.pg18 : pgsphere_18 pgsphere_18-1.5.2-1PIGSTY.el9.aarch64.rpm PIGSTY · 1.5.2 · 116.7KiB	PIGSTY 1.5.2 el9.aarch64.pg17 : pgsphere_17 pgsphere_17-1.5.2-1PIGSTY.el9.aarch64.rpm PIGSTY · 1.5.2 · 116.7KiB	PIGSTY 1.5.2 el9.aarch64.pg16 : pgsphere_16 pgsphere_16-1.5.2-1PIGSTY.el9.aarch64.rpm PIGSTY · 1.5.2 · 116.7KiB	PIGSTY 1.5.2 el9.aarch64.pg15 : pgsphere_15 pgsphere_15-1.5.2-1PIGSTY.el9.aarch64.rpm PIGSTY · 1.5.2 · 114.8KiB	PIGSTY 1.5.2 el9.aarch64.pg14 : pgsphere_14 pgsphere_14-1.5.2-1PIGSTY.el9.aarch64.rpm PIGSTY · 1.5.2 · 114.8KiB
el10.x86_64	PIGSTY 1.5.2 el10.x86_64.pg18 : pgsphere_18 pgsphere_18-1.5.2-1PIGSTY.el10.x86_64.rpm PIGSTY · 1.5.2 · 119.3KiB	PIGSTY 1.5.2 el10.x86_64.pg17 : pgsphere_17 pgsphere_17-1.5.2-1PIGSTY.el10.x86_64.rpm PIGSTY · 1.5.2 · 119.3KiB	PIGSTY 1.5.2 el10.x86_64.pg16 : pgsphere_16 pgsphere_16-1.5.2-1PIGSTY.el10.x86_64.rpm PIGSTY · 1.5.2 · 119.3KiB	PIGSTY 1.5.2 el10.x86_64.pg15 : pgsphere_15 pgsphere_15-1.5.2-1PIGSTY.el10.x86_64.rpm PIGSTY · 1.5.2 · 114.5KiB	PIGSTY 1.5.2 el10.x86_64.pg14 : pgsphere_14 pgsphere_14-1.5.2-1PIGSTY.el10.x86_64.rpm PIGSTY · 1.5.2 · 114.5KiB
el10.aarch64	PIGSTY 1.5.2 el10.aarch64.pg18 : pgsphere_18 pgsphere_18-1.5.2-1PIGSTY.el10.aarch64.rpm PIGSTY · 1.5.2 · 119.5KiB	PIGSTY 1.5.2 el10.aarch64.pg17 : pgsphere_17 pgsphere_17-1.5.2-1PIGSTY.el10.aarch64.rpm PIGSTY · 1.5.2 · 119.6KiB	PIGSTY 1.5.2 el10.aarch64.pg16 : pgsphere_16 pgsphere_16-1.5.2-1PIGSTY.el10.aarch64.rpm PIGSTY · 1.5.2 · 119.5KiB	PIGSTY 1.5.2 el10.aarch64.pg15 : pgsphere_15 pgsphere_15-1.5.2-1PIGSTY.el10.aarch64.rpm PIGSTY · 1.5.2 · 116.8KiB	PIGSTY 1.5.2 el10.aarch64.pg14 : pgsphere_14 pgsphere_14-1.5.2-1PIGSTY.el10.aarch64.rpm PIGSTY · 1.5.2 · 116.7KiB
d12.x86_64	PGDG 1.5.2 d12.x86_64.pg18 : postgresql-18-pgsphere postgresql-18-pgsphere_1.5.2-1.pgdg12+1_amd64.deb PGDG · 1.5.2 · 405.0KiB	PGDG 1.5.2 d12.x86_64.pg17 : postgresql-17-pgsphere postgresql-17-pgsphere_1.5.2-1.pgdg12+1_amd64.deb PGDG · 1.5.2 · 404.8KiB	PGDG 1.5.2 d12.x86_64.pg16 : postgresql-16-pgsphere postgresql-16-pgsphere_1.5.2-1.pgdg12+1_amd64.deb PGDG · 1.5.2 · 404.8KiB	PGDG 1.5.2 d12.x86_64.pg15 : postgresql-15-pgsphere postgresql-15-pgsphere_1.5.2-1.pgdg12+1_amd64.deb PGDG · 1.5.2 · 405.9KiB	PGDG 1.5.2 d12.x86_64.pg14 : postgresql-14-pgsphere postgresql-14-pgsphere_1.5.2-1.pgdg12+1_amd64.deb PGDG · 1.5.2 · 406.0KiB
d12.aarch64	PGDG 1.5.2 d12.aarch64.pg18 : postgresql-18-pgsphere postgresql-18-pgsphere_1.5.2-1.pgdg12+1_arm64.deb PGDG · 1.5.2 · 400.2KiB	PGDG 1.5.2 d12.aarch64.pg17 : postgresql-17-pgsphere postgresql-17-pgsphere_1.5.2-1.pgdg12+1_arm64.deb PGDG · 1.5.2 · 400.1KiB	PGDG 1.5.2 d12.aarch64.pg16 : postgresql-16-pgsphere postgresql-16-pgsphere_1.5.2-1.pgdg12+1_arm64.deb PGDG · 1.5.2 · 400.2KiB	PGDG 1.5.2 d12.aarch64.pg15 : postgresql-15-pgsphere postgresql-15-pgsphere_1.5.2-1.pgdg12+1_arm64.deb PGDG · 1.5.2 · 401.2KiB	PGDG 1.5.2 d12.aarch64.pg14 : postgresql-14-pgsphere postgresql-14-pgsphere_1.5.2-1.pgdg12+1_arm64.deb PGDG · 1.5.2 · 400.9KiB
d13.x86_64	PGDG 1.5.2 d13.x86_64.pg18 : postgresql-18-pgsphere postgresql-18-pgsphere_1.5.2-1.pgdg13+1_amd64.deb PGDG · 1.5.2 · 405.1KiB	PGDG 1.5.2 d13.x86_64.pg17 : postgresql-17-pgsphere postgresql-17-pgsphere_1.5.2-1.pgdg13+1_amd64.deb PGDG · 1.5.2 · 405.5KiB	PGDG 1.5.2 d13.x86_64.pg16 : postgresql-16-pgsphere postgresql-16-pgsphere_1.5.2-1.pgdg13+1_amd64.deb PGDG · 1.5.2 · 405.4KiB	PGDG 1.5.2 d13.x86_64.pg15 : postgresql-15-pgsphere postgresql-15-pgsphere_1.5.2-1.pgdg13+1_amd64.deb PGDG · 1.5.2 · 406.2KiB	PGDG 1.5.2 d13.x86_64.pg14 : postgresql-14-pgsphere postgresql-14-pgsphere_1.5.2-1.pgdg13+1_amd64.deb PGDG · 1.5.2 · 406.3KiB
d13.aarch64	PGDG 1.5.2 d13.aarch64.pg18 : postgresql-18-pgsphere postgresql-18-pgsphere_1.5.2-1.pgdg13+1_arm64.deb PGDG · 1.5.2 · 402.7KiB	PGDG 1.5.2 d13.aarch64.pg17 : postgresql-17-pgsphere postgresql-17-pgsphere_1.5.2-1.pgdg13+1_arm64.deb PGDG · 1.5.2 · 402.5KiB	PGDG 1.5.2 d13.aarch64.pg16 : postgresql-16-pgsphere postgresql-16-pgsphere_1.5.2-1.pgdg13+1_arm64.deb PGDG · 1.5.2 · 402.6KiB	PGDG 1.5.2 d13.aarch64.pg15 : postgresql-15-pgsphere postgresql-15-pgsphere_1.5.2-1.pgdg13+1_arm64.deb PGDG · 1.5.2 · 403.3KiB	PGDG 1.5.2 d13.aarch64.pg14 : postgresql-14-pgsphere postgresql-14-pgsphere_1.5.2-1.pgdg13+1_arm64.deb PGDG · 1.5.2 · 403.9KiB
u22.x86_64	PGDG 1.5.2 u22.x86_64.pg18 : postgresql-18-pgsphere postgresql-18-pgsphere_1.5.2-1.pgdg22.04+1_amd64.deb PGDG · 1.5.2 · 413.8KiB	PGDG 1.5.2 u22.x86_64.pg17 : postgresql-17-pgsphere postgresql-17-pgsphere_1.5.2-1.pgdg22.04+1_amd64.deb PGDG · 1.5.2 · 434.0KiB	PGDG 1.5.2 u22.x86_64.pg16 : postgresql-16-pgsphere postgresql-16-pgsphere_1.5.2-1.pgdg22.04+1_amd64.deb PGDG · 1.5.2 · 433.6KiB	PGDG 1.5.2 u22.x86_64.pg15 : postgresql-15-pgsphere postgresql-15-pgsphere_1.5.2-1.pgdg22.04+1_amd64.deb PGDG · 1.5.2 · 434.2KiB	PGDG 1.5.2 u22.x86_64.pg14 : postgresql-14-pgsphere postgresql-14-pgsphere_1.5.2-1.pgdg22.04+1_amd64.deb PGDG · 1.5.2 · 433.6KiB
u22.aarch64	PGDG 1.5.2 u22.aarch64.pg18 : postgresql-18-pgsphere postgresql-18-pgsphere_1.5.2-1.pgdg22.04+1_arm64.deb PGDG · 1.5.2 · 407.4KiB	PGDG 1.5.2 u22.aarch64.pg17 : postgresql-17-pgsphere postgresql-17-pgsphere_1.5.2-1.pgdg22.04+1_arm64.deb PGDG · 1.5.2 · 427.1KiB	PGDG 1.5.2 u22.aarch64.pg16 : postgresql-16-pgsphere postgresql-16-pgsphere_1.5.2-1.pgdg22.04+1_arm64.deb PGDG · 1.5.2 · 427.1KiB	PGDG 1.5.2 u22.aarch64.pg15 : postgresql-15-pgsphere postgresql-15-pgsphere_1.5.2-1.pgdg22.04+1_arm64.deb PGDG · 1.5.2 · 428.2KiB	PGDG 1.5.2 u22.aarch64.pg14 : postgresql-14-pgsphere postgresql-14-pgsphere_1.5.2-1.pgdg22.04+1_arm64.deb PGDG · 1.5.2 · 428.1KiB
u24.x86_64	PGDG 1.5.2 u24.x86_64.pg18 : postgresql-18-pgsphere postgresql-18-pgsphere_1.5.2-1.pgdg24.04+1_amd64.deb PGDG · 1.5.2 · 406.4KiB	PGDG 1.5.2 u24.x86_64.pg17 : postgresql-17-pgsphere postgresql-17-pgsphere_1.5.2-1.pgdg24.04+1_amd64.deb PGDG · 1.5.2 · 406.3KiB	PGDG 1.5.2 u24.x86_64.pg16 : postgresql-16-pgsphere postgresql-16-pgsphere_1.5.2-1.pgdg24.04+1_amd64.deb PGDG · 1.5.2 · 406.4KiB	PGDG 1.5.2 u24.x86_64.pg15 : postgresql-15-pgsphere postgresql-15-pgsphere_1.5.2-1.pgdg24.04+1_amd64.deb PGDG · 1.5.2 · 404.9KiB	PGDG 1.5.2 u24.x86_64.pg14 : postgresql-14-pgsphere postgresql-14-pgsphere_1.5.2-1.pgdg24.04+1_amd64.deb PGDG · 1.5.2 · 405.1KiB
u24.aarch64	PGDG 1.5.2 u24.aarch64.pg18 : postgresql-18-pgsphere postgresql-18-pgsphere_1.5.2-1.pgdg24.04+1_arm64.deb PGDG · 1.5.2 · 401.2KiB	PGDG 1.5.2 u24.aarch64.pg17 : postgresql-17-pgsphere postgresql-17-pgsphere_1.5.2-1.pgdg24.04+1_arm64.deb PGDG · 1.5.2 · 401.0KiB	PGDG 1.5.2 u24.aarch64.pg16 : postgresql-16-pgsphere postgresql-16-pgsphere_1.5.2-1.pgdg24.04+1_arm64.deb PGDG · 1.5.2 · 401.0KiB	PGDG 1.5.2 u24.aarch64.pg15 : postgresql-15-pgsphere postgresql-15-pgsphere_1.5.2-1.pgdg24.04+1_arm64.deb PGDG · 1.5.2 · 402.1KiB	PGDG 1.5.2 u24.aarch64.pg14 : postgresql-14-pgsphere postgresql-14-pgsphere_1.5.2-1.pgdg24.04+1_arm64.deb PGDG · 1.5.2 · 402.0KiB
u26.x86_64	PGDG 1.5.2 u26.x86_64.pg18 : postgresql-18-pgsphere postgresql-18-pgsphere_1.5.2-1.pgdg26.04+1_amd64.deb PGDG · 1.5.2 · 404.0KiB	PGDG 1.5.2 u26.x86_64.pg17 : postgresql-17-pgsphere postgresql-17-pgsphere_1.5.2-1.pgdg26.04+1_amd64.deb PGDG · 1.5.2 · 404.0KiB	PGDG 1.5.2 u26.x86_64.pg16 : postgresql-16-pgsphere postgresql-16-pgsphere_1.5.2-1.pgdg26.04+1_amd64.deb PGDG · 1.5.2 · 405.0KiB	PGDG 1.5.2 u26.x86_64.pg15 : postgresql-15-pgsphere postgresql-15-pgsphere_1.5.2-1.pgdg26.04+1_amd64.deb PGDG · 1.5.2 · 402.5KiB	PGDG 1.5.2 u26.x86_64.pg14 : postgresql-14-pgsphere postgresql-14-pgsphere_1.5.2-1.pgdg26.04+1_amd64.deb PGDG · 1.5.2 · 402.4KiB
u26.aarch64	PGDG 1.5.2 u26.aarch64.pg18 : postgresql-18-pgsphere postgresql-18-pgsphere_1.5.2-1.pgdg26.04+1_arm64.deb PGDG · 1.5.2 · 400.2KiB	PGDG 1.5.2 u26.aarch64.pg17 : postgresql-17-pgsphere postgresql-17-pgsphere_1.5.2-1.pgdg26.04+1_arm64.deb PGDG · 1.5.2 · 400.1KiB	PGDG 1.5.2 u26.aarch64.pg16 : postgresql-16-pgsphere postgresql-16-pgsphere_1.5.2-1.pgdg26.04+1_arm64.deb PGDG · 1.5.2 · 400.3KiB	PGDG 1.5.2 u26.aarch64.pg15 : postgresql-15-pgsphere postgresql-15-pgsphere_1.5.2-1.pgdg26.04+1_arm64.deb PGDG · 1.5.2 · 399.2KiB	PGDG 1.5.2 u26.aarch64.pg14 : postgresql-14-pgsphere postgresql-14-pgsphere_1.5.2-1.pgdg26.04+1_arm64.deb PGDG · 1.5.2 · 399.7KiB

构建

您可以使用 pig build 命令构建 pgsphere 扩展的 RPM 包：

BASH

pig build pkg pgsphere         # 构建 RPM 包

安装

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

BASH

pig repo add pgsql -u          # 添加仓库并更新缓存

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

安装

BASH

pig install pgsphere;          # 当前活跃 PG 版本安装

pig

BASH

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

dnf

BASH

dnf install -y pgsphere_18       # PG 18
dnf install -y pgsphere_17       # PG 17
dnf install -y pgsphere_16       # PG 16
dnf install -y pgsphere_15       # PG 15
dnf install -y pgsphere_14       # PG 14

apt

BASH

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

创建扩展：

SQL

CREATE EXTENSION pg_sphere;

用法

pg_sphere: PostgreSQL 的球面几何数据类型与运算

pg_sphere 扩展提供球面几何类型和运算，适用于天文学、地理空间以及其他涉及球面坐标的应用。

SQL

CREATE EXTENSION pg_sphere;

数据类型

球面点（spoint）：球面上的位置（经度、纬度，单位弧度）
球面圆（scircle）：由圆心和半径定义的圆形区域
球面线（sline）：大圆弧段
球面椭圆（sellipse）：球面上的椭圆区域
球面多边形（spoly）：球面上的多顶点形状
球面路径（spath）：连续点的序列
球面框（sbox）：球面上的边界框

核心运算

成员测试（点在多边形内、点在圆内等）
球面对象之间的重叠检测
周长和面积计算
使用欧拉角进行坐标变换的对象旋转
球面对象之间的距离计算

索引支持

GiST 索引：用于高效空间查询的 R 树实现
BRIN 索引：用于大型数据集的块范围索引

输入/输出

该扩展处理天文学和地理空间应用中常用的各种坐标格式的输入输出，包括度、弧度以及 HMS/DMS 记法。

SQL

-- 创建球面点（赤经，赤纬）
SELECT spoint '(10.25d, 45.5d)';

-- 创建球面圆（圆心，半径）
SELECT scircle '<(10.25d, 45.5d), 1d>';

-- 检查包含关系
SELECT spoint '(10.25d, 45.5d)' @ scircle '<(10d, 45d), 2d>';

意见反馈

这个页面对您有帮助吗？

感谢反馈！请告诉我们如何改进。

抱歉给您带来不便。请告诉我们如何改进。