pg_geohash

pig build pkg pg_geohash;		# build rpm/deb

pig repo add pgsql -u   # add both repo and update cache

pig install pg_geohash;		# install via package name, for the active PG version

pig install pg_geohash -v 18;   # install for PG 18
pig install pg_geohash -v 17;   # install for PG 17
pig install pg_geohash -v 16;   # install for PG 16
pig install pg_geohash -v 15;   # install for PG 15
pig install pg_geohash -v 14;   # install for PG 14

CREATE EXTENSION pg_geohash;

SELECT LAT_LON_TO_GEOHASH_WITH_LEN(latitude, longitude, 5) AS geohash;

SELECT LAT_LON_TO_GEOHASH(latitude, longitude) AS geohash;

SELECT GEOHASH_TO_LAT_LON('dp3w7') AS lat_lon;

SELECT LAT_LON_TO_GEOHASH_WITH_LEN(latitude, longitude, 5) AS geohash,
       COUNT(*)
FROM crimes
GROUP BY 1
ORDER BY 2 DESC
LIMIT 10;

SELECT location,
       GEOHASH_TO_LAT_LON(LAT_LON_TO_GEOHASH(latitude, longitude))
FROM crimes
LIMIT 5;