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 |
---|---|---|---|---|---|---|
21 | 21 | 21 | 0.7598807215690613 | 3.8374195098876953 | 6.2138991355896 | 12.39924430847168 |
22 | 22 | 22 | -5.522578239440918 | 2.3901689052581787 | 9.391881942749023 | 15.079909324645996 |
23 | 23 | 23 | 88.02178955078125 | 92.64285278320312 | 20.73871421813965 | 26.623544692993164 |
24 | 24 | 24 | 22.345020294189453 | 28.603527069091797 | 41.23809814453125 | 44.22843551635742 |
25 | 25 | 25 | 50.44890213012695 | 50.645660400390625 | 25.789533615112305 | 26.242584228515625 |
26 | 26 | 26 | -79.59435272216797 | -72.74616241455078 | 20.912395477294922 | 26.928415298461914 |
27 | 27 | 27 | 15.716072082519531 | 19.618885040283203 | 42.55921173095703 | 45.28453063964844 |
28 | 28 | 28 | -79.98928833007812 | -79.98639678955078 | 15.794175148010254 | 15.796210289001465 |
29 | 29 | 29 | -62.867340087890625 | -62.791648864746094 | 17.88198471069336 | 17.92914581298828 |
30 | 30 | 30 | 23.16564178466797 | 32.71953582763672 | 51.23516082763672 | 56.15680694580078 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE "idx_countries_geometry" USING rtree(pkid, xmin, xmax, ymin, ymax);