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
| Package | s2-postgis |
|---|---|
| Version | 0.0.2 |
| Repository | Unspecified |
| Extension type | SQL only |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | Yes |
| Stars | 21 |
| Latest commit | 2018-02-12 |
| Latest release | 2017-10-06 |
| Catalogue updated | 2026-08-30 |
| plpython3u | PL/Python3U untrusted procedural language |
| pg_s2 | Adds an S2 CellID type, hierarchy and covering functions, distance helpers, casts, operators, and a B-tree operator class. |
| qdgc | Encode, decode, navigate, and fill Extended Quarter Degree Grid Cell codes in pure SQL. |
| pgs2 | Postgres extension for S2 spherical geometry |
| pgpyml | Run scikit-learn machine-learning models inside PostgreSQL through PL/Python functions and triggers. |
| plpython3t | A SQL-only wrapper that registers PostgreSQL PL/Python 3 handlers as a trusted procedural language named plpython3t. |
| panda_post | Python Pandas data in Postgres |
| verisql | Audit-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_forwarding | Forward PostgreSQL planner and executor data to embedded Python callbacks |
| rppd | Trigger-based PostgreSQL event dispatcher that sends row changes over gRPC to a clustered Rust/Python execution service. |
| audit_stream | Postgres 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. |