select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Geospatial

s2

PL/Python functions for converting latitude/longitude to S2 cell IDs and tokens and navigating the S2 cell hierarchy

pgext.cloud · Source code · Documentation · License text · Control file

Overview

Packages2-postgis
Version0.0.2
RepositoryUnspecified
Extension typeSQL only
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars21
Latest commit2018-02-12
Latest release2017-10-06
Catalogue updated2026-08-30

Related extensions

Requires

plpython3uPL/Python3U untrusted procedural language

See also

pg_s2Adds an S2 CellID type, hierarchy and covering functions, distance helpers, casts, operators, and a B-tree operator class.
qdgcEncode, decode, navigate, and fill Extended Quarter Degree Grid Cell codes in pure SQL.
pgs2Postgres extension for S2 spherical geometry
pgpymlRun scikit-learn machine-learning models inside PostgreSQL through PL/Python functions and triggers.
plpython3tA SQL-only wrapper that registers PostgreSQL PL/Python 3 handlers as a trusted procedural language named plpython3t.
panda_postPython Pandas data in Postgres
verisqlAudit-grade verification gateway for AI-generated SQL — catches silently wrong queries before they hit your dashboard, keeps tamper-evident audit trails, verifies migration equivalence. Zero LLM tokens for 90% of checks.
pg_py_plan_forwardingForward PostgreSQL planner and executor data to embedded Python callbacks
rppdTrigger-based PostgreSQL event dispatcher that sends row changes over gRPC to a clustered Rust/Python execution service.
audit_streamPostgres extension that emits audit-stream-py-compatible governance events on watched table CRUD via pg notify, plus a Python LISTEN bridge daemon. The database-tier governance producer for the Kinetic Gain Protocol Suite.