idx_countries_geometry
Data license: ODbL · Data source: timezone-boundary-builder · About: simonw/timezones-api
255 rows sorted by ymax
This data as json, CSV (advanced)
Link | rowid | pkid | xmin | xmax | ymin | ymax ▼ |
---|---|---|---|---|---|---|
9 | 9 | 9 | -73.58804321289062 | -53.66154479980469 | -55.05201721191406 | -21.786937713623047 |
55 | 55 | 55 | 154.38851928710938 | 154.3913116455078 | -21.030046463012695 | -21.028738021850586 |
163 | 163 | 163 | 163.61570739746094 | 171.34378051757812 | -22.670671463012695 | -19.623708724975586 |
187 | 187 | 187 | -62.65036392211914 | -54.24528884887695 | -27.58684539794922 | -19.286727905273438 |
168 | 168 | 168 | -169.95045471191406 | -169.7828826904297 | -19.14275550842285 | -18.964040756225586 |
38 | 38 | 38 | 19.97834587097168 | 29.35007667541504 | -26.891794204711914 | -17.78180694580078 |
42 | 42 | 42 | -109.45372772216797 | -66.4207992553711 | -55.91851043701172 | -17.506587982177734 |
162 | 162 | 162 | 11.717620849609375 | 25.259780883789062 | -28.95937156677246 | -16.9510555267334 |
255 | 255 | 255 | 25.2193660736084 | 33.04277038574219 | -22.397342681884766 | -15.614806175231934 |
228 | 228 | 228 | -176.2193145751953 | -173.9142303466797 | -22.33880043029785 | -15.559502601623535 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE "idx_countries_geometry" USING rtree(pkid, xmin, xmax, ymin, ymax);