idx_countries_geometry
Data license: ODbL · Data source: timezone-boundary-builder · About: simonw/timezones-api
255 rows sorted by ymax descending
This data as json, CSV (advanced)
Link | rowid | pkid | xmin | xmax | ymin | ymax ▲ |
---|---|---|---|---|---|---|
93 | 93 | 93 | -73.05724334716797 | -11.376818656921387 | 59.79262924194336 | 83.63410186767578 |
40 | 40 | 40 | -141.00555419921875 | -52.616600036621094 | 41.6690788269043 | 83.11652374267578 |
192 | 192 | 192 | -180.0 | 180.00001525878906 | 41.19268035888672 | 81.85871124267578 |
170 | 170 | 170 | -9.11742115020752 | 33.6403923034668 | -54.46249771118164 | 80.77008819580078 |
239 | 239 | 239 | -179.1435089111328 | 179.7809600830078 | 18.906116485595703 | 71.41250610351562 |
75 | 75 | 75 | 20.62316131591797 | 31.569528579711914 | 59.81121826171875 | 70.0753173828125 |
216 | 216 | 216 | 11.10816478729248 | 24.163414001464844 | 55.34267807006836 | 69.03636169433594 |
111 | 111 | 111 | -24.53990936279297 | -13.502917289733887 | 63.39671325683594 | 66.56415557861328 |
79 | 79 | 79 | -7.6441545486450195 | -6.275786876678467 | 61.39410400390625 | 62.39891815185547 |
82 | 82 | 82 | -13.691314697265625 | 1.771169662475586 | 49.90960693359375 | 60.84789276123047 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE "idx_countries_geometry" USING rtree(pkid, xmin, xmax, ymin, ymax);