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 |
---|---|---|---|---|---|---|
0 | 0 | 0 | -8.60146713256836 | -2.4948837757110596 | 4.162120819091797 | 10.74019718170166 |
1 | 1 | 1 | -3.2607860565185547 | 1.27329421043396 | 4.539252281188965 | 11.174856185913086 |
2 | 2 | 2 | 32.997581481933594 | 47.98238754272461 | 3.3974475860595703 | 14.894339561462402 |
3 | 3 | 3 | -8.66890811920166 | 11.997337341308594 | 18.9681453704834 | 37.296207427978516 |
4 | 4 | 4 | 36.43336486816406 | 43.300174713134766 | 12.354820251464844 | 18.070993423461914 |
5 | 5 | 5 | -12.240283012390137 | 4.267383098602295 | 10.147810935974121 | 25.001087188720703 |
6 | 6 | 6 | 14.414844512939453 | 27.466550827026367 | 2.2256088256835938 | 11.00139045715332 |
7 | 7 | 7 | -17.02237892150879 | -13.797776222229004 | 13.055832862854004 | 13.825315475463867 |
8 | 8 | 8 | -16.897502899169922 | -13.634876251220703 | 10.651421546936035 | 12.686238288879395 |
9 | 9 | 9 | 32.67185592651367 | 35.9185791015625 | -17.12960433959961 | -9.36829948425293 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE "idx_timezones_geometry" USING rtree(pkid, xmin, xmax, ymin, ymax);