select open change scope Open full search

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

Extensions / Geospatial

earthdistance

calculate great-circle distances on the surface of the Earth

pgext.cloud · Website · Documentation · License text · Control file

Overview

Packageearthdistance
Version1.2
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPostgreSQL contrib
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
Latest commit2026-05-14
Latest release2026-05-14
Catalogue updated2026-07-29

Related extensions

Requires

cubedata type for multidimensional cubes

See also

postgisPostGIS geometry and geography spatial types and functions
q3cq3c sky indexing plugin
pg_spherespherical objects with useful functions, operators and index support
pointclouddata type for lidar point clouds
h3H3 bindings for PostgreSQL
pg_geohashHandle geohash based functionality for spatial coordinates
pg_eviltransformCoordinate transforms for BD09/GCJ02 via PostGIS ST_Transform
qdgcEncode, decode, navigate, and fill Extended Quarter Degree Grid Cell codes in pure SQL.
pgroutingpgRouting Extension
pg_polylineFast Google Encoded Polyline encoding & decoding for postgres