idx_countries_geometry
Data license: ODbL · Data source: timezone-boundary-builder · About: simonw/timezones-api
255 rows sorted by rowid descending
This data as json, CSV (advanced)
Link | rowid ▲ | pkid | xmin | xmax | ymin | ymax |
---|---|---|---|---|---|---|
245 | 245 | 245 | -64.77400207519531 | -64.27073669433594 | 18.33466148376465 | 18.746244430541992 |
244 | 244 | 244 | -73.39115142822266 | -59.81559371948242 | 0.6493154764175415 | 15.702948570251465 |
243 | 243 | 243 | -61.459835052490234 | -61.123924255371094 | 12.585148811340332 | 13.380765914916992 |
242 | 242 | 242 | 12.452713966369629 | 12.454035758972168 | 41.90275192260742 | 41.90391540527344 |
241 | 241 | 241 | 55.97583770751953 | 73.14864349365234 | 37.18514633178711 | 45.558719635009766 |
240 | 240 | 240 | -75.23286437988281 | -75.0949478149414 | 19.891141891479492 | 19.97158432006836 |
239 | 239 | 239 | -179.1435089111328 | 179.7809600830078 | 18.906116485595703 | 71.41250610351562 |
238 | 238 | 238 | -58.439361572265625 | -53.110836029052734 | -34.97340393066406 | -30.096866607666016 |
237 | 237 | 237 | -177.3896026611328 | 166.65235900878906 | -0.3887672424316406 | 28.21531867980957 |
236 | 236 | 236 | 22.13283920288086 | 40.159549713134766 | 44.38104248046875 | 52.36894989013672 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE "idx_countries_geometry" USING rtree(pkid, xmin, xmax, ymin, ymax);