idx_timezones_geometry
Data license: ODbL · Data source: timezone-boundary-builder · About: simonw/timezones-api
445 rows sorted by xmax descending
This data as json, CSV (advanced)
Link | rowid | pkid | xmin | xmax ▲ | ymin | ymax |
---|---|---|---|---|---|---|
401 | 401 | 401 | 160.5911102294922 | 172.37400817871094 | 4.369698524475098 | 14.924073219299316 |
407 | 407 | 407 | 157.9847412109375 | 172.3057403564453 | -23.22175407409668 | -17.686859130859375 |
388 | 388 | 388 | 166.3355255126953 | 170.4499969482422 | -20.462743759155273 | -12.871377944946289 |
394 | 394 | 394 | 155.31903076171875 | 170.39646911621094 | -13.242431640625 | -4.812790870666504 |
406 | 406 | 406 | 167.6856689453125 | 168.2261505126953 | -29.337072372436523 | -28.793659210205078 |
400 | 400 | 400 | 165.6999969482422 | 168.0128173828125 | 8.34999942779541 | 9.700000762939453 |
404 | 404 | 404 | 166.7099609375 | 167.1597442626953 | -0.753000020980835 | -0.30299997329711914 |
418 | 418 | 418 | 166.38291931152344 | 166.86962890625 | 19.068490982055664 | 19.525232315063477 |
253 | 253 | 253 | 144.72862243652344 | 163.49569702148438 | 58.63752746582031 | 66.33914184570312 |
399 | 399 | 399 | 162.6971893310547 | 163.23748779296875 | 5.057352542877197 | 5.575953006744385 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE "idx_timezones_geometry" USING rtree(pkid, xmin, xmax, ymin, ymax);