tzf

pg_tzf : Fast lookup timezone name by GPS coordinates

Overview

Packages

Source

pig build pkg pg_tzf;		# build rpm/deb

Install

Make sure PGDG and PIGSTY repo available:

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

Install this extension with pig:

pig install pg_tzf;		# install via package name, for the active PG version
pig install tzf;		# install by extension name, for the current active PG version

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

Create this extension with:

CREATE EXTENSION tzf;

Usage

Sources: README, v0.3.0 release

tzf is a PostgreSQL extension for fast timezone lookup from longitude and latitude coordinates. The pgext catalog maps package pg_tzf to extension tzf and tracks version 0.3.0 for PostgreSQL 14-18.

Create the extension

CREATE EXTENSION tzf;

The upstream project packages one build artifact per PostgreSQL major version.

Functions

Coordinate lookup:

SELECT tzf_tzname(116.3883, 39.9289) AS timezone;

Batch coordinate lookup:

SELECT unnest(
  tzf_tzname_batch(
    ARRAY[-74.0060, -118.2437, 139.6917],
    ARRAY[40.7128, 34.0522, 35.6895]
  )
) AS timezones;

Point lookup:

SELECT tzf_tzname_point(point(-74.0060, 40.7128)) AS timezone;

Batch point lookup:

SELECT unnest(
  tzf_tzname_batch_points(
    ARRAY[
      point(-74.0060, 40.7128),
      point(-118.2437, 34.0522),
      point(139.6917, 35.6895)
    ]
  )
) AS timezones;

Notes

• Upstream README documents support for PostgreSQL 14 through 18 builds.
• Pre-built release tarballs contain tzf.so, tzf.control, and tzf--<version>.sql.
• The current README still points to a complete schema in sql/tzf.sql and includes benchmark figures for the four lookup functions above.
• Upstream v0.3.0 adds city-json powered tests for timezone lookup queries and dependency updates; the SQL API remains the four lookup functions above.