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 |
---|---|---|---|---|---|---|
52 | 52 | 52 | -180.0 | 180.0 | 51.02286911010742 | 53.299015045166016 |
211 | 211 | 211 | -180.0 | 180.0 | 61.6077995300293 | 71.80525970458984 |
201 | 201 | 201 | -180.0 | 180.0 | -90.0 | -65.0 |
390 | 390 | 390 | -180.0 | 180.0 | -21.943429946899414 | -12.26138687133789 |
391 | 391 | 391 | -180.0 | 180.0 | -10.993939399719238 | -5.436960220336914 |
420 | 420 | 420 | 172.5 | 180.0 | -70.0 | 90.0 |
383 | 383 | 383 | -179.0591583251953 | 179.36436462402344 | -52.82136917114258 | -29.03032684326172 |
416 | 416 | 416 | 169.32070922851562 | 177.0491180419922 | -2.8763580322265625 | 3.5995004177093506 |
243 | 243 | 243 | 155.21524047851562 | 174.5188751220703 | 50.685630798339844 | 64.93746948242188 |
421 | 421 | 421 | 157.5 | 172.5 | -68.125 | 90.0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE "idx_timezones_geometry" USING rtree(pkid, xmin, xmax, ymin, ymax);