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 |
---|---|---|---|---|---|---|
31 | 31 | 31 | -89.23652648925781 | -87.7830581665039 | 15.879650115966797 | 18.490758895874023 |
206 | 206 | 206 | -90.11479187011719 | -87.69319152832031 | 13.158635139465332 | 14.445374488830566 |
147 | 147 | 147 | -118.36880493164062 | -86.7005844116211 | 14.546282768249512 | 32.71283721923828 |
99 | 99 | 99 | -89.3637924194336 | -83.13043975830078 | 12.979775428771973 | 17.41864776611328 |
167 | 167 | 167 | -87.68582153320312 | -82.7256851196289 | 10.713479995727539 | 15.03097152709961 |
54 | 54 | 54 | -87.11766815185547 | -82.56283569335938 | 5.515081882476807 | 11.20993709564209 |
28 | 28 | 28 | -79.98928833007812 | -79.98639678955078 | 15.794175148010254 | 15.796210289001465 |
58 | 58 | 58 | -81.41654205322266 | -79.72663116455078 | 19.26386070251465 | 19.757631301879883 |
200 | 200 | 200 | -78.64041137695312 | -78.6368637084961 | 15.86208724975586 | 15.867297172546387 |
176 | 176 | 176 | -83.05325317382812 | -77.16326904296875 | 7.205715179443359 | 9.629292488098145 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE "idx_countries_geometry" USING rtree(pkid, xmin, xmax, ymin, ymax);