Adds an S2 CellID type, hierarchy and covering functions, distance helpers, casts, operators, and a B-tree operator class.
pgext.cloud · Source code · Documentation · License text · Control file
| Package | pg_s2 |
|---|---|
| Version | 0.0.6 |
| PostgreSQL versions | 14 · 15 · 16 · 17 |
| Repository | Unspecified |
| Extension type | Standard |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | No |
| Stars | 0 |
| Latest commit | 2026-01-04 |
| Latest release | 2026-01-03 |
| Catalogue updated | 2026-08-30 |
| s2 | PL/Python functions for converting latitude/longitude to S2 cell IDs and tokens and navigating the S2 cell hierarchy |
| pgs2 | Postgres extension for S2 spherical geometry |
| qdgc | Encode, decode, navigate, and fill Extended Quarter Degree Grid Cell codes in pure SQL. |
| lostgis | LostGIS spatial helper functions and types |
| ast_postgis | Advanced spatial data types and spatial integrity constraints for PostGIS. |
| parray_gin | GIN index operator class and partial-match operators for text arrays |
| pg_geohash | Handle geohash based functionality for spatial coordinates |
| rostgis | Experimental PostGIS-compatible spatial extension written in Rust. |
| vasavgeom | Vague geometry handler - VASA |
| historical_geocoding | SQL toolkit for geocoding historical addresses by combining textual, temporal, and spatial evidence. |