idx_countries_geometry
Data license: ODbL · Data source: timezone-boundary-builder · About: simonw/timezones-api
255 rows
This data as json, CSV (advanced)
Link | rowid ▼ | pkid | xmin | xmax | ymin | ymax |
---|---|---|---|---|---|---|
11 | 11 | 11 | -171.08656311035156 | -168.1604461669922 | -14.532893180847168 | -11.051363945007324 |
12 | 12 | 12 | -180.0 | 180.00001525878906 | -90.0 | -60.51620101928711 |
13 | 13 | 13 | 123.57504272460938 | 123.59776306152344 | -12.43857192993164 | -12.426607131958008 |
14 | 14 | 14 | 39.72827911376953 | 77.5852279663086 | -49.72161865234375 | -11.550630569458008 |
15 | 15 | 15 | -61.894161224365234 | -61.6675910949707 | 16.989242553710938 | 17.727689743041992 |
16 | 16 | 16 | 112.91944122314453 | 159.10646057128906 | -54.75042724609375 | -9.240166664123535 |
17 | 17 | 17 | 9.521154403686523 | 17.148338317871094 | 46.37864303588867 | 49.00978088378906 |
18 | 18 | 18 | 44.77455139160156 | 50.6257438659668 | 38.392642974853516 | 41.89044189453125 |
19 | 19 | 19 | 28.98689079284668 | 30.83396339416504 | -4.463344097137451 | -2.3030624389648438 |
20 | 20 | 20 | 2.5217995643615723 | 6.374526023864746 | 49.495216369628906 | 51.496238708496094 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE "idx_countries_geometry" USING rtree(pkid, xmin, xmax, ymin, ymax);