idx_countries_geometry
Data license: ODbL · Data source: timezone-boundary-builder · About: simonw/timezones-api
255 rows sorted by xmin
This data as json, CSV (advanced)
Link | rowid | pkid | xmin ▼ | xmax | ymin | ymax |
---|---|---|---|---|---|---|
11 | 11 | 11 | -171.08656311035156 | -168.1604461669922 | -14.532893180847168 | -11.051363945007324 |
168 | 168 | 168 | -169.95045471191406 | -169.7828826904297 | -19.14275550842285 | -18.964040756225586 |
50 | 50 | 50 | -165.8245391845703 | -157.3127899169922 | -21.93889808654785 | -8.946709632873535 |
189 | 189 | 189 | -154.53700256347656 | -134.94297790527344 | -27.64120864868164 | -7.950127124786377 |
40 | 40 | 40 | -141.00555419921875 | -52.616600036621094 | 41.6690788269043 | 83.11652374267578 |
177 | 177 | 177 | -130.75308227539062 | -124.7780532836914 | -25.07708168029785 | -23.924407958984375 |
147 | 147 | 147 | -118.36880493164062 | -86.7005844116211 | 14.546282768249512 | 32.71283721923828 |
42 | 42 | 42 | -109.45372772216797 | -66.4207992553711 | -55.91851043701172 | -17.506587982177734 |
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);