idx_countries_geometry
Data license: ODbL · Data source: timezone-boundary-builder · About: simonw/timezones-api
255 rows sorted by ymin descending
This data as json, CSV (advanced)
Link | rowid | pkid | xmin | xmax | ymin ▲ | ymax |
---|---|---|---|---|---|---|
111 | 111 | 111 | -24.53990936279297 | -13.502917289733887 | 63.39671325683594 | 66.56415557861328 |
79 | 79 | 79 | -7.6441545486450195 | -6.275786876678467 | 61.39410400390625 | 62.39891815185547 |
6 | 6 | 6 | 19.51319122314453 | 21.096691131591797 | 59.90447998046875 | 60.48078155517578 |
75 | 75 | 75 | 20.62316131591797 | 31.569528579711914 | 59.81121826171875 | 70.0753173828125 |
93 | 93 | 93 | -73.05724334716797 | -11.376818656921387 | 59.79262924194336 | 83.63410186767578 |
73 | 73 | 73 | 21.832366943359375 | 28.18647575378418 | 57.515811920166016 | 59.67089080810547 |
139 | 139 | 139 | 20.968597412109375 | 28.21727752685547 | 55.66698455810547 | 58.07514572143555 |
216 | 216 | 216 | 11.10816478729248 | 24.163414001464844 | 55.34267807006836 | 69.03636169433594 |
65 | 65 | 65 | 8.09400463104248 | 15.151379585266113 | 54.56858825683594 | 57.75116729736328 |
104 | 104 | 104 | -4.7901506423950195 | -4.311919689178467 | 54.05694580078125 | 54.41901397705078 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE "idx_countries_geometry" USING rtree(pkid, xmin, xmax, ymin, ymax);