superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
126 rows where ACCESS_TYP = 2 and MNG_AG_TYP = 5 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_ID, AGNCY_WEB, YR_EST
MNG_AGENCY 9
- California Department of Fish and Wildlife 67
- University of California 39
- California Department of Parks and Recreation 11
- California State Coastal Conservancy 3
- Other State 2
- California State Lands Commission 1
- California State University Sonoma 1
- San Diego State University 1
- California Department of Water Resources 1
MNG_AG_TYP 1
- State Agency · 126 ✖
ACCESS_TYP 1
- Restricted Access · 126 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2905 | 2905 | 2904 | {"type": "Polygon", "coordinates": [[[-117.69973, 33.97316], [-117.6997, 33.97405], [-117.6991, 33.97403], [-117.6991, 33.97334], [-117.69894, 33.97306], [-117.69971, 33.97306], [-117.69971, 33.97315], [-117.69973, 33.97316]]]} | Restricted Access 2 | Chino Fish & Wildlife Base | 17207 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 1.585 | Chino Fish & Wildlife Base | ||
8802 | 8802 | 8801 | {"type": "Polygon", "coordinates": [[[-122.76295, 38.34753], [-122.76209, 38.34714], [-122.76092, 38.34616], [-122.76059, 38.34615], [-122.76022, 38.34574], [-122.76118, 38.34575], [-122.76295, 38.34753]]]} | Restricted Access 2 | Theiller Sebastopol Meadowfoam Ecological Reserve | 26298 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 2.51 | Theiller Sebastopol Meadowfoam ER | ||
9876 | 9876 | 9875 | {"type": "Polygon", "coordinates": [[[-118.76991, 36.21538], [-118.76991, 36.21538], [-118.76726, 36.21538], [-118.76735, 36.21517], [-118.76842, 36.21452], [-118.76948, 36.21436], [-118.76989, 36.21437], [-118.76991, 36.21538]]]} | Restricted Access 2 | Springville Ecological Reserve | 25751 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 4.946 | Springville ER | ||
3212 | 3212 | 3211 | {"type": "Polygon", "coordinates": [[[-121.4409, 38.26568], [-121.4405, 38.26654], [-121.43893, 38.26623], [-121.43872, 38.26566], [-121.43905, 38.26515], [-121.43899, 38.26457], [-121.44061, 38.26555], [-121.4409, 38.26568]]]} | Restricted Access 2 | Cosumnes River Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Cosumnes-River-ER | 17675 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 5.743 | Cosumnes River ER | 2003 |
8436 | 8436 | 8435 | {"type": "Polygon", "coordinates": [[[-122.1072, 38.49368], [-122.10672, 38.49336], [-122.10649, 38.49316], [-122.10637, 38.49012], [-122.10659, 38.49004], [-122.10674, 38.48989], [-122.10698, 38.4896], [-122.10718, 38.48928], [-122.1072, 38.49368]]]} | Restricted Access 2 | Quail Ridge | 24047 | 217 | University of California 51 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 6.615 | Quail Ridge | 1991 | |
9225 | 9225 | 9224 | {"type": "Polygon", "coordinates": [[[-122.26206, 37.57356], [-122.25329, 37.58145], [-122.25329, 37.58145], [-122.25315, 37.58126], [-122.26174, 37.57345], [-122.26206, 37.57356]]]} | Restricted Access 2 | San Mateo Fishing Pier | 24951 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 7.588 | San Mateo Fishing Pier | ||
3506 | 3506 | 3505 | {"type": "Polygon", "coordinates": [[[-121.86483, 36.60512], [-121.86235, 36.60664], [-121.86185, 36.60613], [-121.86192, 36.60536], [-121.86232, 36.60488], [-121.86288, 36.60459], [-121.86434, 36.60427], [-121.86483, 36.60512]]]} | Restricted Access 2 | Del Monte Dunes Ecological Reserve | 18040 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 9.591 | Del Monte Dunes ER | ||
14535 | 14535 | 14534 | {"type": "Polygon", "coordinates": [[[-119.87533, 36.85429], [-119.87123, 36.85253], [-119.87062, 36.85148], [-119.87396, 36.85227], [-119.87533, 36.85429]]]} | Restricted Access 2 | San Joaquin River Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/San-Joaquin-River-ER | 24913 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 10.873 | San Joaquin River ER | 1990 |
15315 | 15315 | 15314 | {"type": "Polygon", "coordinates": [[[-121.80689, 38.88866], [-121.8054, 38.89105], [-121.80515, 38.89074], [-121.80516, 38.89056], [-121.8047, 38.88988], [-121.80428, 38.88934], [-121.80363, 38.88908], [-121.80241, 38.88865], [-121.80166, 38.88837], [-121.8014, 38.88823], [-121.80146, 38.88809], [-121.80169, 38.88805], [-121.80187, 38.888], [-121.80312, 38.88824], [-121.80392, 38.88848], [-121.80462, 38.88863], [-121.80528, 38.88858], [-121.80616, 38.88858], [-121.80689, 38.88866]]]} | Restricted Access 2 | Collins Eddy Wildlife Area | 17521 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 12.401 | Collins Eddy Wildlife Area | ||
7807 | 7807 | 7806 | {"type": "Polygon", "coordinates": [[[-117.23496, 33.27233], [-117.23496, 33.27267], [-117.23179, 33.27604], [-117.23077, 33.27536], [-117.2336, 33.27235], [-117.23496, 33.27233]]]} | Restricted Access 2 | San Luis Rey River Ecological Reserve | 24942 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 14.152 | San Luis Rey River ER | ||
13880 | 13880 | 13879 | {"type": "Polygon", "coordinates": [[[-117.23111, 32.79319], [-117.23107, 32.79326], [-117.23078, 32.7932], [-117.2303, 32.79353], [-117.2303, 32.79356], [-117.23015, 32.79366], [-117.23009, 32.79379], [-117.23005, 32.79383], [-117.23004, 32.79417], [-117.23009, 32.79439], [-117.2301, 32.79484], [-117.23047, 32.79495], [-117.23076, 32.79592], [-117.23007, 32.79609], [-117.2299, 32.79556], [-117.22808, 32.79595], [-117.22756, 32.79426], [-117.22918, 32.79378], [-117.2293, 32.79327], [-117.23017, 32.79269], [-117.23073, 32.79196], [-117.23111, 32.79319]]]} | Restricted Access 2 | Kendall Frost Mission Bay Marsh Reserve | https://ucnrs.org/reserves/kendall-frost-mission-bay-marsh-reserve/ | 33187 | 217 | University of California 51 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 16.568 | Kendall Frost Mission Bay Marsh Reserve | |
14514 | 14514 | 14513 | {"type": "Polygon", "coordinates": [[[-117.10664, 33.07422], [-117.10657, 33.07428], [-117.10628, 33.07556], [-117.10504, 33.07516], [-117.1052, 33.07405], [-117.10423, 33.07384], [-117.10423, 33.07312], [-117.10319, 33.072], [-117.10339, 33.07188], [-117.10339, 33.07186], [-117.10243, 33.0711], [-117.10269, 33.07041], [-117.10371, 33.07007], [-117.10564, 33.07143], [-117.10596, 33.07398], [-117.10664, 33.07422]]]} | Restricted Access 2 | Lake Hodges Ecological Reserve | 20894 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 24.619 | Lake Hodges ER | ||
14523 | 14523 | 14522 | {"type": "Polygon", "coordinates": [[[-121.73917, 36.77633], [-121.73883, 36.77674], [-121.73878, 36.77671], [-121.73767, 36.77747], [-121.73567, 36.77625], [-121.7328, 36.77533], [-121.73114, 36.774], [-121.73155, 36.77394], [-121.73199, 36.77418], [-121.73246, 36.77422], [-121.73301, 36.77408], [-121.73332, 36.77373], [-121.73363, 36.7736], [-121.73394, 36.77357], [-121.73432, 36.77363], [-121.73454, 36.77375], [-121.73491, 36.77431], [-121.73498, 36.77446], [-121.7349, 36.77465], [-121.73521, 36.77482], [-121.73553, 36.77494], [-121.73565, 36.775], [-121.73578, 36.77509], [-121.73598, 36.77528], [-121.73613, 36.77533], [-121.7363, 36.77531], [-121.73711, 36.77488], [-121.73721, 36.77486], [-121.73732, 36.77487], [-121.7374, 36.77491], [-121.73745, 36.77496], [-121.73808, 36.77615], [-121.73816, 36.77625], [-121.73825, 36.77634], [-121.73838, 36.77641], [-121.73853, 36.77646], [-121.73864, 36.77653], [-121.73866, 36.77653], [-121.73805, 36.77568], [-121.7391, 36.77612], [-121.73917, 36.77633]]]} | Restricted Access 2 | Moro Cojo Ecological Reserve | 22492 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 26.623 | Moro Cojo ER | ||
9144 | 9144 | 9143 | {"type": "Polygon", "coordinates": [[[-118.41528, 37.50655], [-118.41424, 37.51016], [-118.41131, 37.5101], [-118.41137, 37.5067], [-118.41304, 37.50674], [-118.41305, 37.5065], [-118.41528, 37.50655]]]} | Restricted Access 2 | Fish Slough Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Fish-Slough-ER | 18918 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 29.183 | Fish Slough ER | 1970 |
8104 | 8104 | 8103 | {"type": "Polygon", "coordinates": [[[-116.66912, 32.98862], [-116.65988, 32.98873], [-116.65991, 32.98773], [-116.66058, 32.98745], [-116.66904, 32.98739], [-116.66912, 32.98862]]]} | Restricted Access 2 | Boulder Creek Ecological Reserve | 16294 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 29.21 | Boulder Creek ER | ||
9133 | 9133 | 9132 | {"type": "Polygon", "coordinates": [[[-121.74412, 36.87571], [-121.74366, 36.87559], [-121.74329, 36.87545], [-121.74227, 36.87498], [-121.74082, 36.8726], [-121.74226, 36.87023], [-121.7427, 36.87029], [-121.74329, 36.87006], [-121.74404, 36.87042], [-121.74411, 36.87185], [-121.74417, 36.87202], [-121.74408, 36.87317], [-121.74393, 36.87357], [-121.74369, 36.87428], [-121.74359, 36.87435], [-121.74351, 36.87447], [-121.74349, 36.87456], [-121.7435, 36.87468], [-121.74363, 36.87499], [-121.74412, 36.87566], [-121.74412, 36.87571]]]} | Restricted Access 2 | Elkhorn Slough Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Elkhorn-Slough-ER | 18581 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 29.593 | Elkhorn Slough ER | 1980 |
14527 | 14527 | 14526 | {"type": "MultiPolygon", "coordinates": [[[[-117.11031, 32.78139], [-117.10939, 32.78129], [-117.10874, 32.78124], [-117.1081, 32.78124], [-117.10775, 32.78126], [-117.10736, 32.78131], [-117.10694, 32.78141], [-117.10659, 32.78152], [-117.10623, 32.78166], [-117.1059, 32.78182], [-117.10555, 32.78203], [-117.10524, 32.78226], [-117.10493, 32.78253], [-117.10466, 32.78283], [-117.10441, 32.78318], [-117.10419, 32.78357], [-117.10401, 32.78361], [-117.10399, 32.78228], [-117.104, 32.78071], [-117.10652, 32.77982], [-117.10701, 32.77966], [-117.10938, 32.77999], [-117.10979, 32.78019], [-117.11029, 32.78049], [-117.11027, 32.78101], [-117.11031, 32.78139]]], [[[-117.11031, 32.77957], [-117.11031, 32.77985], [-117.11022, 32.77985], [-117.10974, 32.77983], [-117.1093, 32.77979], [-117.10739, 32.77953], [-117.10841, 32.77919], [-117.10972, 32.77926], [-117.11031, 32.77957]]]]} | Restricted Access 2 | San Diego River Ecological Reserve | 24863 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 30.385 | San Diego River ER | ||
11211 | 11211 | 11210 | {"type": "Polygon", "coordinates": [[[-116.77797, 33.80726], [-116.77791, 33.81103], [-116.77358, 33.81102], [-116.77357, 33.80908], [-116.77582, 33.80892], [-116.77583, 33.80728], [-116.77797, 33.80726]]]} | Restricted Access 2 | James San Jacinto Mountains Reserve | https://ucnrs.org/reserves/james-san-jacinto-mountains-reserve/ | 33184 | 217 | University of California 51 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 31.73 | James San Jacinto Mtns. Reserve | |
4926 | 4926 | 4925 | {"type": "Polygon", "coordinates": [[[-122.93426, 38.43681], [-122.93107, 38.43684], [-122.92903, 38.43689], [-122.92899, 38.4368], [-122.92897, 38.4367], [-122.92903, 38.43623], [-122.92908, 38.43609], [-122.92928, 38.43568], [-122.92964, 38.43476], [-122.92971, 38.43447], [-122.92971, 38.43416], [-122.92954, 38.43343], [-122.92954, 38.43324], [-122.93106, 38.43321], [-122.93269, 38.43323], [-122.93272, 38.43595], [-122.93425, 38.43597], [-122.93426, 38.43681]]]} | Restricted Access 2 | Harrison Grade Ecological Reserve | 19698 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 31.813 | Harrison Grade ER | ||
10538 | 10538 | 10537 | {"type": "MultiPolygon", "coordinates": [[[[-122.40288, 38.42006], [-122.39982, 38.42256], [-122.39819, 38.42129], [-122.40153, 38.41858], [-122.40288, 38.42006]]], [[[-122.4118, 38.42984], [-122.41092, 38.43057], [-122.41011, 38.43121], [-122.40947, 38.43071], [-122.40833, 38.42986], [-122.4072, 38.42896], [-122.40913, 38.42735], [-122.4118, 38.42984]]]]} | Restricted Access 2 | UC Agricultural Research Station | 26634 | 217 | University of California 51 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 40.124 | UC Agricultural Research Station |
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]);