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 |
---|---|---|---|---|---|---|
20 | 20 | 20 | -17.319026947021484 | -8.666251182556152 | 20.667251586914062 | 27.670625686645508 |
21 | 21 | 21 | -13.500340461730957 | -10.271682739257812 | 6.754999160766602 | 9.99997329711914 |
22 | 22 | 22 | 19.998645782470703 | 29.373889923095703 | -26.907007217407227 | -17.778135299682617 |
23 | 23 | 23 | 25.23729705810547 | 33.06835174560547 | -22.424110412597656 | -15.609701156616211 |
24 | 24 | 24 | -5.5 | 38.28989791870117 | -86.0 | -22.12502670288086 |
25 | 25 | 25 | 23.44777488708496 | 35.948997497558594 | 3.4889795780181885 | 12.23638916015625 |
26 | 26 | 26 | 29.57343292236328 | 35.000308990478516 | -1.4823180437088013 | 4.234077453613281 |
27 | 27 | 27 | 21.814504623413086 | 39.0576286315918 | 8.685277938842773 | 22.224918365478516 |
28 | 28 | 28 | 28.861692428588867 | 30.89907455444336 | -2.8397583961486816 | -1.0474079847335815 |
29 | 29 | 29 | 12.039073944091797 | 24.412389755249023 | -8.131037712097168 | 5.150627136230469 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE "idx_timezones_geometry" USING rtree(pkid, xmin, xmax, ymin, ymax);