idx_countries_geometry
Data license: ODbL · Data source: timezone-boundary-builder · About: simonw/timezones-api
255 rows sorted by xmax
This data as json, CSV (advanced)
Link | rowid | pkid | xmin | xmax ▼ | ymin | ymax |
---|---|---|---|---|---|---|
249 | 249 | 249 | -178.1857452392578 | -176.12559509277344 | -14.31943130493164 | -13.208916664123535 |
228 | 228 | 228 | -176.2193145751953 | -173.9142303466797 | -22.33880043029785 | -15.559502601623535 |
251 | 251 | 251 | -172.78260803222656 | -171.4376678466797 | -14.05282974243164 | -13.462822914123535 |
168 | 168 | 168 | -169.95045471191406 | -169.7828826904297 | -19.14275550842285 | -18.964040756225586 |
11 | 11 | 11 | -171.08656311035156 | -168.1604461669922 | -14.532893180847168 | -11.051363945007324 |
50 | 50 | 50 | -165.8245391845703 | -157.3127899169922 | -21.93889808654785 | -8.946709632873535 |
189 | 189 | 189 | -154.53700256347656 | -134.94297790527344 | -27.64120864868164 | -7.950127124786377 |
177 | 177 | 177 | -130.75308227539062 | -124.7780532836914 | -25.07708168029785 | -23.924407958984375 |
45 | 45 | 45 | -109.23424530029297 | -109.21034240722656 | 10.281559944152832 | 10.311022758483887 |
94 | 94 | 94 | -92.24624633789062 | -88.22090911865234 | 13.728902816772461 | 17.816020965576172 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE "idx_countries_geometry" USING rtree(pkid, xmin, xmax, ymin, ymax);