idx_CPAD_2020a_Units_geometry
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by pkid
This data as json, copyable, CSV (advanced)
Link | rowid | pkid ▼ | xmin | xmax | ymin | ymax |
---|---|---|---|---|---|---|
20 | 20 | 20 | -121.14743041992188 | -121.14692687988281 | 37.47763442993164 | 37.478233337402344 |
21 | 21 | 21 | -119.79975891113281 | -119.79767608642578 | 36.71886444091797 | 36.719635009765625 |
22 | 22 | 22 | -117.27259063720703 | -117.17402648925781 | 33.87310791015625 | 33.98114013671875 |
23 | 23 | 23 | -118.1557388305664 | -118.1546630859375 | 34.02478790283203 | 34.025821685791016 |
24 | 24 | 24 | -122.2774887084961 | -122.27701568603516 | 38.298648834228516 | 38.298912048339844 |
25 | 25 | 25 | -117.08358764648438 | -117.07964324951172 | 32.74993133544922 | 32.753082275390625 |
26 | 26 | 26 | -118.4001235961914 | -118.39863586425781 | 33.99211120605469 | 33.9927978515625 |
27 | 27 | 27 | -117.89558410644531 | -117.89359283447266 | 33.75160598754883 | 33.75333023071289 |
28 | 28 | 28 | -117.08212280273438 | -117.0816421508789 | 32.83601379394531 | 32.83637237548828 |
29 | 29 | 29 | -117.28087615966797 | -117.2790298461914 | 32.8428955078125 | 32.844242095947266 |
30 | 30 | 30 | -120.44007873535156 | -120.42984008789062 | 34.64359664916992 | 34.660640716552734 |
31 | 31 | 31 | -121.14591217041016 | -121.14385223388672 | 37.46989822387695 | 37.47106170654297 |
32 | 32 | 32 | -121.14985656738281 | -121.1493911743164 | 37.464561462402344 | 37.46625518798828 |
33 | 33 | 33 | -117.18415832519531 | -117.17721557617188 | 32.74551773071289 | 32.74806213378906 |
34 | 34 | 34 | -117.10770416259766 | -117.05542755126953 | 32.89786148071289 | 32.93086624145508 |
35 | 35 | 35 | -117.05462646484375 | -117.05225372314453 | 32.80617141723633 | 32.807708740234375 |
36 | 36 | 36 | -122.32795715332031 | -122.32256317138672 | 37.917564392089844 | 37.919925689697266 |
37 | 37 | 37 | -121.12983703613281 | -121.12913513183594 | 37.479698181152344 | 37.48015213012695 |
38 | 38 | 38 | -122.41699981689453 | -122.41009521484375 | 37.74205780029297 | 37.744178771972656 |
39 | 39 | 39 | -120.65350341796875 | -120.65314483642578 | 35.262542724609375 | 35.26286697387695 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE "idx_CPAD_2020a_Units_geometry" USING rtree(pkid, xmin, xmax, ymin, ymax);