idx_CPAD_2020a_Units_geometry
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows
This data as json, copyable, CSV (advanced)
| Link | rowid ▼ | pkid | xmin | xmax | ymin | ymax |
|---|---|---|---|---|---|---|
| 0 | 0 | 0 | -121.07810974121094 | -119.8092269897461 | 35.0338020324707 | 35.78573989868164 |
| 1 | 1 | 1 | -120.84978485107422 | -120.84784698486328 | 37.77094650268555 | 37.77309036254883 |
| 2 | 2 | 2 | -120.81796264648438 | -120.8070068359375 | 37.77714538574219 | 37.78801345825195 |
| 3 | 3 | 3 | -120.81831359863281 | -120.80926513671875 | 37.78732681274414 | 37.79087448120117 |
| 4 | 4 | 4 | -118.10747528076172 | -118.1051025390625 | 33.73909378051758 | 33.74043655395508 |
| 5 | 5 | 5 | -117.11090850830078 | -117.10682678222656 | 32.730613708496094 | 32.734039306640625 |
| 6 | 6 | 6 | -121.9388198852539 | -121.93820190429688 | 36.98869323730469 | 36.98905944824219 |
| 7 | 7 | 7 | -117.70487213134766 | -117.70381164550781 | 34.09651565551758 | 34.0977668762207 |
| 8 | 8 | 8 | -119.48323059082031 | -119.47735595703125 | 34.37523651123047 | 34.379783630371094 |
| 9 | 9 | 9 | -117.0960464477539 | -117.09234619140625 | 32.736961364746094 | 32.74291229248047 |
| 10 | 10 | 10 | -117.08431243896484 | -117.08256530761719 | 32.93151092529297 | 32.933982849121094 |
| 11 | 11 | 11 | -120.70087432861328 | -120.69879913330078 | 35.73564910888672 | 35.739925384521484 |
| 12 | 12 | 12 | -120.84861755371094 | -120.84812927246094 | 37.76467514038086 | 37.76505661010742 |
| 13 | 13 | 13 | -122.03123474121094 | -122.03104400634766 | 36.97380447387695 | 36.974090576171875 |
| 14 | 14 | 14 | -120.87738800048828 | -120.87608337402344 | 37.760501861572266 | 37.76176834106445 |
| 15 | 15 | 15 | -121.15169525146484 | -121.1502456665039 | 37.47358703613281 | 37.474849700927734 |
| 16 | 16 | 16 | -118.1225814819336 | -118.12163543701172 | 34.69047546386719 | 34.6927490234375 |
| 17 | 17 | 17 | -118.95326232910156 | -118.94920349121094 | 34.179222106933594 | 34.182655334472656 |
| 18 | 18 | 18 | -117.08917236328125 | -117.08769226074219 | 32.925289154052734 | 32.92626953125 |
| 19 | 19 | 19 | -121.7510986328125 | -121.74931335449219 | 36.906471252441406 | 36.90781021118164 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE "idx_CPAD_2020a_Units_geometry" USING rtree(pkid, xmin, xmax, ymin, ymax);