home / timezones

Find time zone by lat/lon

Custom SQL query returning 1 row (hide)

select tzid
from
  timezones
where
  within(
    MakePoint(cast(:longitude as float), cast(:latitude as float)),
    timezones.Geometry
  ) = 1
  and rowid in (
    select
      rowid
    from
      SpatialIndex
    where
      f_table_name = 'timezones'
      and search_frame = MakePoint(cast(:longitude as float), cast(:latitude as float))
  )

Query parameters

This data as json, CSV

tzid
America/Los_Angeles
Powered by Datasette · Queries took 6.598ms