home / timezones

timezones

Custom SQL query returning 1 row

select tzid
from
    timezones
where
    within(GeomFromText('POINT(' || :longitude || ' ' || :latitude || ')'), timezones.Geometry)
    and rowid in (
        SELECT pkid FROM idx_timezones_Geometry
        where xmin < :longitude
        and xmax > :longitude
        and ymin < :latitude
        and ymax > :latitude
    )

Query parameters

This data as .json, .jsono

tzid
America/Los_Angeles
Powered by Datasette · Query took 11.386ms · Data license: ODbL · Data source: timezone-boundary-builder