idx_countries_geometry
Data license: ODbL · Data source: timezone-boundary-builder · About: simonw/timezones-api
255 rows sorted by xmax descending
This data as json, CSV (advanced)
Link | rowid | pkid | xmin | xmax ▲ | ymin | ymax |
---|---|---|---|---|---|---|
192 | 192 | 192 | -180.0 | 180.00001525878906 | 41.19268035888672 | 81.85871124267578 |
12 | 12 | 12 | -180.0 | 180.00001525878906 | -90.0 | -60.51620101928711 |
76 | 76 | 76 | -180.0 | 180.00001525878906 | -21.71111488342285 | -12.475274085998535 |
232 | 232 | 232 | 176.12522888183594 | 179.90675354003906 | -9.420668601989746 | -5.677504062652588 |
239 | 239 | 239 | -179.1435089111328 | 179.7809600830078 | 18.906116485595703 | 71.41250610351562 |
173 | 173 | 173 | -177.95802307128906 | 178.8439483642578 | -52.60031509399414 | -8.54322624206543 |
124 | 124 | 124 | -174.5434112548828 | 176.85093688964844 | -11.461115837097168 | 4.723090648651123 |
148 | 148 | 148 | 165.28221130371094 | 172.02980041503906 | 4.573797702789307 | 14.610502243041992 |
163 | 163 | 163 | 163.61570739746094 | 171.34378051757812 | -22.670671463012695 | -19.623708724975586 |
248 | 248 | 248 | 166.52049255371094 | 169.89894104003906 | -20.25310707092285 | -13.064873695373535 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE "idx_countries_geometry" USING rtree(pkid, xmin, xmax, ymin, ymax);