idx_countries_geometry
Data license: ODbL · Data source: timezone-boundary-builder · About: simonw/timezones-api
255 rows
This data as json, CSV (advanced)
Link | rowid ▼ | pkid | xmin | xmax | ymin | ymax |
---|---|---|---|---|---|---|
1 | 1 | 1 | -70.06240844726562 | -69.87681579589844 | 12.417668342590332 | 12.632147789001465 |
2 | 2 | 2 | 60.48677062988281 | 74.89231872558594 | 29.3866024017334 | 38.47367477416992 |
3 | 3 | 3 | 11.669392585754395 | 24.061717987060547 | -18.03140640258789 | -4.3912034034729 |
4 | 4 | 4 | -63.428829193115234 | -62.9726448059082 | 18.16909408569336 | 18.601266860961914 |
5 | 5 | 5 | 19.272031784057617 | 21.036680221557617 | 39.63701248168945 | 42.65481948852539 |
6 | 6 | 6 | 19.51319122314453 | 21.096691131591797 | 59.90447998046875 | 60.48078155517578 |
7 | 7 | 7 | 1.4064561128616333 | 1.765090823173523 | 42.42867660522461 | 42.64936828613281 |
8 | 8 | 8 | 51.569339752197266 | 56.383644104003906 | 22.620943069458008 | 26.074792861938477 |
9 | 9 | 9 | -73.58804321289062 | -53.66154479980469 | -55.05201721191406 | -21.786937713623047 |
10 | 10 | 10 | 43.43628692626953 | 46.60261917114258 | 38.86370086669922 | 41.29045867919922 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE "idx_countries_geometry" USING rtree(pkid, xmin, xmax, ymin, ymax);