superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
53 rows where MNG_AG_ID = 342 and MNG_AG_LEV = 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
785 | 785 | 784 | {"type": "Polygon", "coordinates": [[[-121.80809, 39.64191], [-121.80809, 39.64239], [-121.80736, 39.6424], [-121.80735, 39.64235], [-121.80731, 39.6423], [-121.80725, 39.64227], [-121.80719, 39.64226], [-121.80719, 39.64192], [-121.80809, 39.64191]]]} | Open Access 1 | Butte holding 28 | 16572 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.984 | Butte holding 28 | ||
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 | ||
967 | 967 | 966 | {"type": "Polygon", "coordinates": [[[-121.86522, 39.77272], [-121.86522, 39.77272], [-121.86339, 39.77381], [-121.86334, 39.77367], [-121.86511, 39.77261], [-121.86522, 39.77272]]]} | Open Access 1 | Butte holding 3 | 16574 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.735 | Butte holding 3 | ||
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 | ||
1207 | 1207 | 1206 | {"type": "Polygon", "coordinates": [[[-121.60688, 39.75782], [-121.60673, 39.75845], [-121.60495, 39.75845], [-121.60495, 39.75769], [-121.60668, 39.75769], [-121.6067, 39.75776], [-121.60688, 39.75782]]]} | Open Access 1 | Butte holding 32 | 16576 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 3.325 | Butte holding 32 | ||
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 | ||
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 | ||
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 | ||
1656 | 1656 | 1655 | {"type": "Polygon", "coordinates": [[[-121.57928, 39.81699], [-121.57902, 39.81678], [-121.57879, 39.8165], [-121.5787, 39.81607], [-121.57872, 39.81466], [-121.57854, 39.81417], [-121.57834, 39.81346], [-121.57847, 39.81298], [-121.5786, 39.81301], [-121.57885, 39.81322], [-121.57904, 39.81347], [-121.57916, 39.81374], [-121.57928, 39.81699]]]} | Open Access 1 | Butte holding 20 | 16564 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 4.825 | Butte holding 20 | ||
1706 | 1706 | 1705 | {"type": "Polygon", "coordinates": [[[-121.34664, 39.51201], [-121.34628, 39.51201], [-121.34628, 39.51175], [-121.34509, 39.51164], [-121.3449, 39.51155], [-121.34449, 39.51144], [-121.34658, 39.51124], [-121.34664, 39.51201]]]} | Open Access 1 | Butte holding 37 | 16581 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 1.798 | Butte holding 37 | ||
1707 | 1707 | 1706 | {"type": "Polygon", "coordinates": [[[-121.79652, 39.68185], [-121.79642, 39.68188], [-121.79607, 39.67968], [-121.79558, 39.67785], [-121.79577, 39.67784], [-121.79652, 39.68185]]]} | Open Access 1 | Butte holding 38 | 16582 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.857 | Butte holding 38 | ||
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 | ||
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 | ||
1781 | 1781 | 1780 | {"type": "Polygon", "coordinates": [[[-121.74737, 39.49534], [-121.74694, 39.49534], [-121.74694, 39.49496], [-121.74736, 39.49496], [-121.74737, 39.49534]]]} | Open Access 1 | Butte holding 23 | 16567 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.385 | Butte holding 23 | ||
1806 | 1806 | 1805 | {"type": "Polygon", "coordinates": [[[-121.50716, 39.77435], [-121.50641, 39.77428], [-121.50606, 39.77367], [-121.50686, 39.77374], [-121.50716, 39.77435]]]} | Open Access 1 | Butte holding 24 | 16568 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 1.05 | Butte holding 24 | ||
1847 | 1847 | 1846 | {"type": "Polygon", "coordinates": [[[-121.27835, 39.52723], [-121.27753, 39.52727], [-121.27742, 39.52663], [-121.27778, 39.52662], [-121.27814, 39.52652], [-121.27835, 39.52723]]]} | Open Access 1 | Butte holding 25 | 16569 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 1.222 | Butte holding 25 | ||
2378 | 2378 | 2377 | {"type": "MultiPolygon", "coordinates": [[[[-121.40352, 39.65905], [-121.40352, 39.65905], [-121.40349, 39.65919], [-121.40349, 39.65905], [-121.40352, 39.65905]]], [[[-121.40431, 39.65967], [-121.40422, 39.65977], [-121.40412, 39.65995], [-121.40401, 39.66005], [-121.40382, 39.66013], [-121.40349, 39.66018], [-121.40349, 39.65949], [-121.40359, 39.6594], [-121.40367, 39.65929], [-121.40372, 39.65918], [-121.40374, 39.65905], [-121.40413, 39.65905], [-121.40431, 39.65967]]]]} | Open Access 1 | Butte holding 26 | 16570 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 1.61 | Butte holding 26 | ||
2379 | 2379 | 2378 | {"type": "Polygon", "coordinates": [[[-121.81039, 39.64905], [-121.80925, 39.64906], [-121.80917, 39.64889], [-121.81039, 39.64889], [-121.81039, 39.64905]]]} | Open Access 1 | Butte holding 27 | 16571 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.457 | Butte holding 27 | ||
2394 | 2394 | 2393 | {"type": "Polygon", "coordinates": [[[-121.48678, 39.51389], [-121.48532, 39.5139], [-121.48532, 39.51387], [-121.48603, 39.51386], [-121.48603, 39.51308], [-121.48676, 39.51308], [-121.48678, 39.51389]]]} | Open Access 1 | Butte holding 1 | 16552 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 1.477 | Butte holding 1 | ||
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 |
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]);