idx_timezones_geometry
Data license: ODbL · Data source: timezone-boundary-builder · About: simonw/timezones-api
445 rows sorted by xmin
This data as json, CSV (advanced)
Link | rowid | pkid | xmin ▼ | xmax | ymin | ymax |
---|---|---|---|---|---|---|
53 | 53 | 53 | -162.0 | -141.0 | 54.3347282409668 | 71.60482788085938 |
398 | 398 | 398 | -160.6099853515625 | -149.99252319335938 | -11.646001815795898 | 4.900000095367432 |
442 | 442 | 442 | -157.5 | -142.5 | -86.0 | 90.0 |
415 | 415 | 415 | -154.93606567382812 | -136.08299255371094 | -28.099023818969727 | -13.89067554473877 |
441 | 441 | 441 | -142.5 | -127.5 | -86.0 | 90.0 |
194 | 194 | 194 | -141.008544921875 | -137.5 | 58.72036361694336 | 60.35251235961914 |
95 | 95 | 95 | -141.0027618408203 | -137.9996337890625 | 59.999629974365234 | 69.84588623046875 |
402 | 402 | 402 | -140.92526245117188 | -138.21067810058594 | -10.754411697387695 | -7.65921688079834 |
191 | 191 | 191 | -139.06134033203125 | -116.44244384765625 | 48.22455596923828 | 60.001930236816406 |
127 | 127 | 127 | -138.26869201660156 | -132.36978149414062 | 56.86304473876953 | 59.79804229736328 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE "idx_timezones_geometry" USING rtree(pkid, xmin, xmax, ymin, ymax);