superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
53 rows where MNG_AGENCY = 692 and MNG_AG_TYP = 3 sorted by ACRES
This data as json, copyable, CSV (advanced)
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES ▼ | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1551 | 1551 | 1550 | {"type": "Polygon", "coordinates": [[[-121.53081, 39.5272], [-121.53065, 39.5272], [-121.53066, 39.52703], [-121.53072, 39.5271], [-121.53081, 39.5272]]]} | Open Access 1 | Butte holding 35 | 16579 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.031 | Butte holding 35 | ||
2398 | 2398 | 2397 | {"type": "Polygon", "coordinates": [[[-121.86042, 39.7738], [-121.86037, 39.77383], [-121.86008, 39.77354], [-121.86013, 39.77351], [-121.86042, 39.7738]]]} | Open Access 1 | Butte holding 13 | 16556 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.054 | Butte holding 13 | ||
2403 | 2403 | 2402 | {"type": "Polygon", "coordinates": [[[-121.8607, 39.77408], [-121.86065, 39.77411], [-121.86037, 39.77383], [-121.86042, 39.7738], [-121.8607, 39.77408]]]} | Open Access 1 | Butte holding 18 | 16561 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.054 | Butte holding 18 | ||
1362 | 1362 | 1361 | {"type": "Polygon", "coordinates": [[[-121.85722, 39.77066], [-121.85717, 39.77069], [-121.8568, 39.77032], [-121.85685, 39.77029], [-121.85722, 39.77066]]]} | Open Access 1 | Butte holding 34 | 16578 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.07 | Butte holding 34 | ||
2419 | 2419 | 2418 | {"type": "Polygon", "coordinates": [[[-121.79187, 39.75561], [-121.79161, 39.75549], [-121.79176, 39.75526], [-121.7918, 39.75541], [-121.79187, 39.75561]]]} | Open Access 1 | Butte holding 50 | 16595 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.088 | Butte holding 50 | ||
1757 | 1757 | 1756 | {"type": "Polygon", "coordinates": [[[-121.58711, 39.81342], [-121.58621, 39.81385], [-121.58619, 39.81385], [-121.58633, 39.81373], [-121.58677, 39.81349], [-121.58711, 39.81342]]]} | Open Access 1 | Butte holding 21 | 16565 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.131 | Butte holding 21 | ||
2400 | 2400 | 2399 | {"type": "Polygon", "coordinates": [[[-121.62648, 39.76336], [-121.62653, 39.76339], [-121.62657, 39.76346], [-121.6266, 39.76354], [-121.62661, 39.76365], [-121.6266, 39.76373], [-121.62657, 39.76383], [-121.62646, 39.76397], [-121.62648, 39.76336]]]} | Open Access 1 | Butte holding 15 | 16558 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.139 | Butte holding 15 | ||
2409 | 2409 | 2408 | {"type": "Polygon", "coordinates": [[[-121.79721, 39.63893], [-121.797, 39.63897], [-121.79677, 39.63834], [-121.79719, 39.6389], [-121.79721, 39.63893]]]} | Open Access 1 | Butte holding 40 | 16585 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.167 | Butte holding 40 | ||
1772 | 1772 | 1771 | {"type": "Polygon", "coordinates": [[[-121.60388, 39.85695], [-121.60385, 39.85697], [-121.60383, 39.857], [-121.60382, 39.85735], [-121.60364, 39.85735], [-121.60365, 39.857], [-121.60362, 39.85695], [-121.60388, 39.85695]]]} | Open Access 1 | Butte holding 22 | 16566 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.177 | Butte holding 22 | ||
2412 | 2412 | 2411 | {"type": "Polygon", "coordinates": [[[-121.60142, 39.85063], [-121.60119, 39.85063], [-121.60122, 39.85058], [-121.60124, 39.85016], [-121.60141, 39.85016], [-121.6014, 39.85058], [-121.60142, 39.85063]]]} | Open Access 1 | Butte holding 43 | 16588 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.199 | Butte holding 43 | ||
2396 | 2396 | 2395 | {"type": "Polygon", "coordinates": [[[-121.80054, 39.64365], [-121.8001, 39.64376], [-121.80003, 39.64358], [-121.80048, 39.64347], [-121.80054, 39.64365]]]} | Open Access 1 | Butte holding 11 | 16554 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.215 | Butte holding 11 | ||
1309 | 1309 | 1308 | {"type": "Polygon", "coordinates": [[[-121.54043, 39.47302], [-121.54011, 39.47302], [-121.54015, 39.47297], [-121.54015, 39.47262], [-121.54037, 39.47262], [-121.54038, 39.47297], [-121.54043, 39.47302]]]} | Open Access 1 | Butte holding 33 | 16577 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.222 | Butte holding 33 | ||
2395 | 2395 | 2394 | {"type": "Polygon", "coordinates": [[[-121.53726, 39.64644], [-121.53646, 39.64655], [-121.53638, 39.64653], [-121.53648, 39.6463], [-121.53726, 39.64644]]]} | Open Access 1 | Butte holding 10 | 16553 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.247 | Butte holding 10 | ||
2399 | 2399 | 2398 | {"type": "Polygon", "coordinates": [[[-121.62744, 39.74865], [-121.62744, 39.74881], [-121.62673, 39.74875], [-121.62673, 39.74859], [-121.62744, 39.74865]]]} | Open Access 1 | Butte holding 14 | 16557 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.271 | Butte holding 14 | ||
975 | 975 | 974 | {"type": "Polygon", "coordinates": [[[-121.80908, 39.70888], [-121.80893, 39.70884], [-121.80835, 39.70799], [-121.80846, 39.70795], [-121.80908, 39.70888]]]} | Open Access 1 | Butte holding 31 | 16575 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.274 | Butte holding 31 | ||
2420 | 2420 | 2419 | {"type": "Polygon", "coordinates": [[[-121.57946, 39.50391], [-121.57904, 39.50395], [-121.57906, 39.50363], [-121.57941, 39.5036], [-121.57946, 39.50391]]]} | Open Access 1 | Butte holding 51 | 16596 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.284 | Butte holding 51 | ||
2428 | 2428 | 2427 | {"type": "Polygon", "coordinates": [[[-121.81614, 39.72758], [-121.81561, 39.72764], [-121.8156, 39.7274], [-121.81609, 39.72734], [-121.81614, 39.72758]]]} | Open Access 1 | Butte holding 9 | 16603 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.296 | Butte holding 9 | ||
798 | 798 | 797 | {"type": "Polygon", "coordinates": [[[-121.7975, 39.63935], [-121.79716, 39.63942], [-121.797, 39.63897], [-121.79721, 39.63893], [-121.79729, 39.63902], [-121.7975, 39.63935]]]} | Open Access 1 | Butte holding 29 | 16573 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.324 | Butte holding 29 | ||
2414 | 2414 | 2413 | {"type": "Polygon", "coordinates": [[[-121.16103, 39.53302], [-121.16075, 39.53306], [-121.16074, 39.53253], [-121.16102, 39.53249], [-121.16103, 39.53302]]]} | Open Access 1 | Butte holding 46 | 16590 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.356 | Butte holding 46 | ||
2404 | 2404 | 2403 | {"type": "Polygon", "coordinates": [[[-121.85077, 39.77573], [-121.85049, 39.77573], [-121.84981, 39.77506], [-121.84994, 39.77497], [-121.85039, 39.77543], [-121.85077, 39.77573]]]} | Open Access 1 | Butte holding 19 | 16562 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.384 | Butte holding 19 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);