idx_timezones_geometry
Data license: ODbL · Data source: timezone-boundary-builder · About: simonw/timezones-api
445 rows sorted by ymin descending
This data as json, CSV (advanced)
Link | rowid | pkid | xmin | xmax | ymin ▲ | ymax |
---|---|---|---|---|---|---|
95 | 95 | 95 | -141.0027618408203 | -137.9996337890625 | 59.999629974365234 | 69.84588623046875 |
192 | 192 | 192 | -138.0 | -123.81024932861328 | 59.99853515625 | 69.4796371459961 |
195 | 195 | 195 | -120.00137329101562 | -102.00061798095703 | 59.998252868652344 | 79.12998962402344 |
158 | 158 | 158 | -69.10763549804688 | -10.028874397277832 | 59.515380859375 | 83.87517547607422 |
329 | 329 | 329 | 20.16356658935547 | 31.58670997619629 | 59.472652435302734 | 70.09230041503906 |
342 | 342 | 342 | 19.08319854736328 | 21.345645904541016 | 59.45415115356445 | 60.876651763916016 |
246 | 246 | 246 | 131.58509826660156 | 140.87545776367188 | 58.83452606201172 | 66.2085952758789 |
194 | 194 | 194 | -141.008544921875 | -137.5 | 58.72036361694336 | 60.35251235961914 |
253 | 253 | 253 | 144.72862243652344 | 163.49569702148438 | 58.63752746582031 | 66.33914184570312 |
103 | 103 | 103 | -127.81828308105469 | -120.00122833251953 | 58.0 | 60.0020751953125 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE "idx_timezones_geometry" USING rtree(pkid, xmin, xmax, ymin, ymax);