idx_timezones_geometry
Data license: ODbL · Data source: timezone-boundary-builder · About: simonw/timezones-api
445 rows sorted by xmax
This data as json, CSV (advanced)
Link | rowid | pkid | xmin | xmax ▼ | ymin | ymax |
---|---|---|---|---|---|---|
415 | 415 | 415 | -154.93606567382812 | -136.08299255371094 | -28.099023818969727 | -13.89067554473877 |
393 | 393 | 393 | -136.96630859375 | -134.2447967529297 | -23.575626373291016 | -21.09316635131836 |
127 | 127 | 127 | -138.26869201660156 | -132.36978149414062 | 56.86304473876953 | 59.79804229736328 |
145 | 145 | 145 | -131.67401123046875 | -131.29388427734375 | 54.97902297973633 | 55.300968170166016 |
178 | 178 | 178 | -136.79244995117188 | -129.9741668701172 | 54.5472526550293 | 58.00135040283203 |
441 | 441 | 441 | -142.5 | -127.5 | -86.0 | 90.0 |
410 | 410 | 410 | -130.9746856689453 | -124.55182647705078 | -25.280208587646484 | -23.70697784423828 |
192 | 192 | 192 | -138.0 | -123.81024932861328 | 59.99853515625 | 69.4796371459961 |
103 | 103 | 103 | -127.81828308105469 | -120.00122833251953 | 58.0 | 60.0020751953125 |
96 | 96 | 96 | -124.94481658935547 | -120.00118255615234 | 53.79685592651367 | 58.0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE "idx_timezones_geometry" USING rtree(pkid, xmin, xmax, ymin, ymax);