idx_timezones_geometry
Data license: ODbL · Data source: timezone-boundary-builder · About: simonw/timezones-api
445 rows
This data as json, CSV (advanced)
Link | rowid ▼ | pkid | xmin | xmax | ymin | ymax |
---|---|---|---|---|---|---|
10 | 10 | 10 | 11.004820823669434 | 18.643611907958984 | -5.149089813232422 | 3.7130560874938965 |
11 | 11 | 11 | 29.000715255737305 | 30.849849700927734 | -4.469315052032471 | -2.3096799850463867 |
12 | 12 | 12 | 24.6499080657959 | 37.115352630615234 | 21.72499656677246 | 31.833087921142578 |
13 | 13 | 13 | -13.428204536437988 | -0.9984288811683655 | 27.62725257873535 | 36.002140045166016 |
14 | 14 | 14 | -5.421949863433838 | -2.418717622756958 | 35.170963287353516 | 36.05052947998047 |
15 | 15 | 15 | -15.5680513381958 | -7.6379218101501465 | 7.190604209899902 | 12.675631523132324 |
16 | 16 | 16 | -17.74987030029297 | -11.345948219299316 | 12.240265846252441 | 16.691972732543945 |
17 | 17 | 17 | 29.326976776123047 | 40.65841293334961 | -11.76125431060791 | -0.9854809045791626 |
18 | 18 | 18 | 41.77131271362305 | 43.65790557861328 | 10.914953231811523 | 12.792309761047363 |
19 | 19 | 19 | 8.382217407226562 | 16.19110107421875 | 1.651748776435852 | 13.083333015441895 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE "idx_timezones_geometry" USING rtree(pkid, xmin, xmax, ymin, ymax);