idx_timezones_geometry
Data license: ODbL · Data source: timezone-boundary-builder · About: simonw/timezones-api
445 rows sorted by xmin descending
This data as json, CSV (advanced)
Link | rowid | pkid | xmin ▲ | xmax | ymin | ymax |
---|---|---|---|---|---|---|
199 | 199 | 199 | 158.32656860351562 | 159.34027099609375 | -55.322818756103516 | -54.156166076660156 |
407 | 407 | 407 | 157.9847412109375 | 172.3057403564453 | -23.22175407409668 | -17.686859130859375 |
421 | 421 | 421 | 157.5 | 172.5 | -68.125 | 90.0 |
394 | 394 | 394 | 155.31903076171875 | 170.39646911621094 | -13.242431640625 | -4.812790870666504 |
243 | 243 | 243 | 155.21524047851562 | 174.5188751220703 | 50.685630798339844 | 64.93746948242188 |
411 | 411 | 411 | 154.0394287109375 | 160.9193572998047 | 0.8232828974723816 | 8.34865665435791 |
384 | 384 | 384 | 154.0 | 159.69349670410156 | -7.097516059875488 | -2.9059085845947266 |
307 | 307 | 307 | 148.73854064941406 | 149.3985137939453 | -20.57000160217285 | -19.82209014892578 |
253 | 253 | 253 | 144.72862243652344 | 163.49569702148438 | 58.63752746582031 | 66.33914184570312 |
414 | 414 | 414 | 144.6732177734375 | 146.2734375 | 13.909537315368652 | 20.75454330444336 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE "idx_timezones_geometry" USING rtree(pkid, xmin, xmax, ymin, ymax);