units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
149 rows where ACCESS_TYP = 2 and MNG_AG_TYP = 5 sorted by LABEL_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID, YR_EST, GAP_STS
DES_TP 30
- State Conservation Area 108
- State Resource Management Area 7
- State Park 4
- State Recreation Area 4
- None 1
- State Other or Unknown 1
- National Wildlife Refuge 1
- State Historic or Cultural Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AGENCY 9
- California Department of Fish and Wildlife 71
- University of California 47
- California Department of Parks and Recreation 11
- San Diego State University 6
- California State Coastal Conservancy 4
- California State Lands Commission 3
- Other State 3
- California Department of Water Resources 3
- California State University Sonoma 1
MNG_AG_TYP 1
- State Agency · 149 ✖
ACCESS_TYP 1
- Restricted Access · 149 ✖
Link | rowid | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME ▲ | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6470 | 6470 | 6469 | {"type": "Polygon", "coordinates": [[[-122.06987, 36.9535], [-122.06981, 36.95358], [-122.06949, 36.9538], [-122.06941, 36.95398], [-122.06942, 36.95419], [-122.06937, 36.95429], [-122.06901, 36.95456], [-122.06885, 36.95465], [-122.06873, 36.95472], [-122.06864, 36.95469], [-122.06863, 36.95464], [-122.06886, 36.95406], [-122.06891, 36.95388], [-122.06883, 36.95375], [-122.06855, 36.95346], [-122.06841, 36.95338], [-122.06811, 36.95332], [-122.06804, 36.9533], [-122.06796, 36.95323], [-122.06787, 36.95299], [-122.06775, 36.95281], [-122.06759, 36.95271], [-122.06748, 36.95283], [-122.0673, 36.9535], [-122.06718, 36.95371], [-122.06691, 36.95396], [-122.06662, 36.95409], [-122.06652, 36.95425], [-122.06651, 36.95458], [-122.06646, 36.95465], [-122.06596, 36.95498], [-122.06572, 36.95531], [-122.06541, 36.95567], [-122.06527, 36.9558], [-122.06529, 36.95758], [-122.06435, 36.95765], [-122.06252, 36.95783], [-122.06252, 36.95702], [-122.06409, 36.95687], [-122.06393, 36.95661], [-122.06374, 36.95665], [-122.06365, 36.95663], [-122.06346, 36.95664], [-122.06323, 36.9566], [-122.06311, 36.95649], [-122.063, 36.95647], [-122.06279, 36.95648], [-122.06252, 36.9564], [-122.06252, 36.95528], [-122.06283, 36.95494], [-122.06305, 36.95465], [-122.06253, 36.95452], [-122.06255, 36.94931], [-122.06258, 36.9493], [-122.06257, 36.94913], [-122.06265, 36.94914], [-122.06284, 36.9491], [-122.06294, 36.94905], [-122.06297, 36.94899], [-122.06304, 36.94897], [-122.06311, 36.94898], [-122.06313, 36.94902], [-122.06319, 36.9491], [-122.06346, 36.94912], [-122.06352, 36.94905], [-122.06363, 36.94907], [-122.06369, 36.94913], [-122.06379, 36.94913], [-122.06386, 36.94901], [-122.06397, 36.94895], [-122.06405, 36.94886], [-122.06413, 36.94885], [-122.06417, 36.94886], [-122.06427, 36.94894], [-122.06438, 36.94918], [-122.06449, 36.94936], [-122.06451, 36.94945], [-122.06458, 36.94958], [-122.06463, 36.94959], [-122.06467, 36.94957], [-122.06473, 36.94967], [-122.06484, 36.9498], [-122.06485, 36.94984], [-122.06494, 36.9499], [-122.06502, 36.94993], [-122.06509, 36.94994], [-122.06527, 36.94991], [-122.06535, 36.94993], [-122.06539, 36.94995], [-122.0654, 36.94999], [-122.06542, 36.95011], [-122.06543, 36.95141], [-122.0643, 36.95145], [-122.06423, 36.95149], [-122.06419, 36.95157], [-122.06396, 36.95157], [-122.06383, 36.95151], [-122.06371, 36.9515], [-122.0636, 36.95158], [-122.06358, 36.95203], [-122.06371, 36.9521], [-122.06386, 36.95212], [-122.06403, 36.95223], [-122.06409, 36.95232], [-122.06414, 36.95248], [-122.0641, 36.95272], [-122.06406, 36.95279], [-122.06397, 36.95289], [-122.06379, 36.95299], [-122.06356, 36.95303], [-122.06343, 36.95316], [-122.06344, 36.95323], [-122.06341, 36.9534], [-122.06328, 36.95465], [-122.06329, 36.95469], [-122.06335, 36.95477], [-122.06348, 36.95486], [-122.06387, 36.95499], [-122.06439, 36.9552], [-122.06458, 36.95526], [-122.0647, 36.95528], [-122.06483, 36.95523], [-122.06483, 36.95522], [-122.06471, 36.95513], [-122.06466, 36.95499], [-122.0647, 36.95483], [-122.06476, 36.95477], [-122.06499, 36.9547], [-122.06515, 36.95472], [-122.06516, 36.95456], [-122.06519, 36.9545], [-122.06528, 36.95442], [-122.06534, 36.95441], [-122.06539, 36.95463], [-122.06548, 36.95464], [-122.06553, 36.95459], [-122.06564, 36.95458], [-122.06576, 36.9546], [-122.06599, 36.95469], [-122.06607, 36.95464], [-122.06612, 36.95458], [-122.06611, 36.95448], [-122.06589, 36.95435], [-122.06581, 36.95426], [-122.06579, 36.95411], [-122.06583, 36.954], [-122.0661, 36.95379], [-122.06624, 36.95376], [-122.06639, 36.95369], [-122.0665, 36.9536], [-122.06661, 36.95347], [-122.06663, 36.95328], [-122.0666, 36.95316], [-122.06665, 36.95305], [-122.06671, 36.95299], [-122.06669, 36.95278], [-122.06659, 36.95269], [-122.06619, 36.95268], [-122.06601, 36.95256], [-122.06587, 36.95234], [-122.06581, 36.95213], [-122.06577, 36.95205], [-122.0656, 36.95205], [-122.06559, 36.95199], [-122.06559, 36.95186], [-122.06556, 36.95181], [-122.0655, 36.95178], [-122.0655, 36.95052], [-122.06563, 36.95049], [-122.06624, 36.94994], [-122.06635, 36.94985], [-122.06654, 36.94976], [-122.06661, 36.94967], [-122.06662, 36.94961], [-122.06661, 36.94952], [-122.06649, 36.94938], [-122.0663, 36.94924], [-122.06616, 36.94904], [-122.06604, 36.94882], [-122.06589, 36.94877], [-122.06593, 36.94865], [-122.06599, 36.94859], [-122.06601, 36.94849], [-122.06584, 36.94835], [-122.0657, 36.94827], [-122.06557, 36.9483], [-122.06538, 36.94829], [-122.06547, 36.94823], [-122.06588, 36.94807], [-122.06593, 36.94806], [-122.066, 36.94808], [-122.06611, 36.94822], [-122.06617, 36.9484], [-122.06628, 36.94853], [-122.0663, 36.9486], [-122.06635, 36.9486], [-122.0664, 36.94864], [-122.0664, 36.94868], [-122.06645, 36.94873], [-122.06657, 36.94869], [-122.06662, 36.94873], [-122.0667, 36.94871], [-122.06683, 36.94873], [-122.06703, 36.94882], [-122.06728, 36.9489], [-122.06744, 36.94888], [-122.06746, 36.94882], [-122.06749, 36.94881], [-122.06748, 36.94873], [-122.0676, 36.94904], [-122.06791, 36.94952], [-122.06793, 36.9497], [-122.06792, 36.95008], [-122.06804, 36.95042], [-122.06804, 36.95054], [-122.06795, 36.95066], [-122.06777, 36.9507], [-122.0677, 36.95086], [-122.06779, 36.95095], [-122.06811, 36.95111], [-122.0681, 36.95118], [-122.06805, 36.95125], [-122.06788, 36.95128], [-122.06777, 36.95138], [-122.06771, 36.95153], [-122.06771, 36.95165], [-122.06803, 36.95196], [-122.06811, 36.95216], [-122.06816, 36.95233], [-122.0683, 36.95252], [-122.06871, 36.95279], [-122.06896, 36.953], [-122.06919, 36.95329], [-122.06937, 36.95338], [-122.06947, 36.95339], [-122.06979, 36.95341], [-122.06987, 36.9535]]]} | Restricted Access 2 | 2005 | Younger Lagoon Reserve | 27791 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | Santa Cruz 5 | 69.92 | Younger Lagoon Reserve | 0 | State Conservation Area 8 | 2 | |
5846 | 5846 | 5845 | {"type": "Polygon", "coordinates": [[[-123.25549, 38.89635], [-123.24599, 38.90389], [-123.24056, 38.90437], [-123.24061, 38.90254], [-123.2406, 38.89715], [-123.24069, 38.8935], [-123.24608, 38.89273], [-123.24609, 38.89637], [-123.25549, 38.89635]]]} | Restricted Access 2 | 21623 | Yorkville Ecological Reserve | 27781 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Mendocino 24 | 226.535 | Yorkville ER | 0 | State Conservation Area 8 | 2 | |
1947 | 1947 | 1946 | {"type": "MultiPolygon", "coordinates": [[[[-118.98159, 36.05067], [-118.98137, 36.05079], [-118.9727, 36.05085], [-118.9718, 36.05081], [-118.97127, 36.05076], [-118.9708, 36.0507], [-118.97091, 36.0439], [-118.98041, 36.04394], [-118.98036, 36.04846], [-118.98039, 36.04883], [-118.98043, 36.04901], [-118.98052, 36.04928], [-118.98064, 36.04953], [-118.98074, 36.0497], [-118.98091, 36.04994], [-118.98105, 36.05009], [-118.98123, 36.05026], [-118.98148, 36.05046], [-118.98159, 36.05067]]], [[[-118.98205, 36.04396], [-118.98203, 36.04531], [-118.98196, 36.05048], [-118.98172, 36.05031], [-118.98148, 36.05012], [-118.98129, 36.04993], [-118.9811, 36.0497], [-118.98094, 36.04945], [-118.98084, 36.04924], [-118.98075, 36.04901], [-118.98068, 36.04874], [-118.98065, 36.04846], [-118.9807, 36.04394], [-118.98205, 36.04396]]]]} | Restricted Access 2 | 29177 | Yaudanchi Ecological Reserve | 27765 | 220 | California Department of Health Services 459 | State 5 | State Agency 5 | http://www.dhcs.ca.gov/Pages/default.aspx | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Tulare 29 | 184.306 | Yaudanchi ER | 0 | State Conservation Area 8 | 2 | |
9238 | 9238 | 9237 | {"type": "Polygon", "coordinates": [[[-117.00635, 34.01893], [-117.00623, 34.03414], [-116.99983, 34.03445], [-116.99983, 34.03355], [-116.99977, 34.0335], [-116.99545, 34.03333], [-116.99546, 34.02975], [-116.99022, 34.02962], [-116.99015, 34.03315], [-116.98469, 34.03296], [-116.98051, 34.03284], [-116.98041, 34.0259], [-116.99028, 34.02608], [-116.99036, 34.02243], [-116.98606, 34.02232], [-116.98628, 34.01867], [-116.99042, 34.0188], [-116.99038, 34.0183], [-116.98998, 34.01603], [-116.99139, 34.0165], [-116.9918, 34.01637], [-116.99214, 34.0163], [-116.99253, 34.01631], [-116.993, 34.01627], [-116.99345, 34.01602], [-116.99383, 34.0157], [-116.9941, 34.0157], [-116.99454, 34.01566], [-116.99512, 34.01572], [-116.99546, 34.01578], [-116.99573, 34.01569], [-116.99713, 34.01637], [-116.99777, 34.01644], [-116.99863, 34.01623], [-116.99915, 34.01625], [-116.99969, 34.01638], [-116.99977, 34.01645], [-117.00026, 34.0165], [-117.00066, 34.01657], [-117.00137, 34.01608], [-117.00196, 34.01594], [-117.00204, 34.01569], [-117.00213, 34.01554], [-117.00221, 34.01516], [-117.00269, 34.01519], [-117.00242, 34.01682], [-117.00105, 34.01837], [-117.00129, 34.01856], [-117.00108, 34.01901], [-117.00635, 34.01893]], [[-117.00051, 34.01841], [-117.00053, 34.01822], [-117.00036, 34.01817], [-117.00013, 34.01807], [-116.99983, 34.0183], [-116.99985, 34.01898], [-116.99982, 34.01899], [-116.99982, 34.01902], [-117.00049, 34.019], [-117.00078, 34.01867], [-117.00057, 34.01852], [-117.00051, 34.01841]]]} | Restricted Access 2 | 15366 | Wildwood Canyon | 27517 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | San Bernardino 22 | 843.596 | Wildwood Canyon | 2002 | None 764 | ||
15547 | 15547 | 15546 | {"type": "Polygon", "coordinates": [[[-121.27537, 37.70038], [-121.27531, 37.70044], [-121.27489, 37.70053], [-121.27446, 37.70105], [-121.27439, 37.70129], [-121.27435, 37.70153], [-121.2743, 37.70169], [-121.273, 37.70334], [-121.27198, 37.7052], [-121.27185, 37.7052], [-121.27169, 37.70515], [-121.27161, 37.70499], [-121.27158, 37.70481], [-121.27177, 37.70237], [-121.27183, 37.70201], [-121.27198, 37.70166], [-121.2722, 37.70141], [-121.27359, 37.70014], [-121.27383, 37.69976], [-121.27395, 37.69929], [-121.27448, 37.69948], [-121.27471, 37.6995], [-121.27537, 37.70038]]]} | Restricted Access 2 | 47089 | Vernalis Ecological Reserve | 30745 | 219 | Central Valley Flood Protection Board 1027 | State 5 | State Agency 5 | http://www.cvfpb.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Joaquin 39 | 20.58 | Vernalis ER | 0 | State Conservation Area 8 | 2 | |
15623 | 15623 | 15622 | {"type": "Polygon", "coordinates": [[[-121.29449, 37.72472], [-121.29433, 37.72471], [-121.29406, 37.72428], [-121.29376, 37.72401], [-121.29354, 37.72385], [-121.29301, 37.72354], [-121.29294, 37.72351], [-121.29126, 37.72249], [-121.28998, 37.72168], [-121.28968, 37.72146], [-121.28924, 37.72108], [-121.28872, 37.72048], [-121.28854, 37.72023], [-121.28848, 37.72019], [-121.28717, 37.71812], [-121.28686, 37.7176], [-121.28641, 37.71691], [-121.28628, 37.71675], [-121.28622, 37.71664], [-121.28543, 37.71582], [-121.28517, 37.71557], [-121.28473, 37.7152], [-121.28422, 37.71487], [-121.28388, 37.71467], [-121.28362, 37.71453], [-121.28322, 37.71436], [-121.283, 37.71428], [-121.28293, 37.71428], [-121.27995, 37.7131], [-121.27947, 37.71298], [-121.27924, 37.71294], [-121.27904, 37.71294], [-121.27878, 37.71297], [-121.27865, 37.713], [-121.27841, 37.71308], [-121.27805, 37.71335], [-121.27785, 37.7136], [-121.27772, 37.71386], [-121.27765, 37.71416], [-121.27766, 37.71423], [-121.27765, 37.71431], [-121.27772, 37.71523], [-121.27783, 37.71571], [-121.27793, 37.71595], [-121.27834, 37.71713], [-121.27837, 37.71751], [-121.27832, 37.71789], [-121.27802, 37.71862], [-121.27763, 37.7186], [-121.27807, 37.71782], [-121.27814, 37.7176], [-121.27816, 37.71745], [-121.27813, 37.71723], [-121.27805, 37.71704], [-121.27769, 37.7157], [-121.27711, 37.71451], [-121.27706, 37.71433], [-121.27698, 37.71398], [-121.27689, 37.71345], [-121.27685, 37.7131], [-121.27682, 37.71257], [-121.27684, 37.71168], [-121.27691, 37.71101], [-121.2769, 37.71084], [-121.27692, 37.71071], [-121.27697, 37.71052], [-121.27714, 37.71025], [-121.2773, 37.71009], [-121.2775, 37.70995], [-121.27756, 37.70991], [-121.27785, 37.70981], [-121.27859, 37.7098], [-121.27868, 37.7098], [-121.27885, 37.70987], [-121.27892, 37.7099], [-121.27903, 37.71001], [-121.2792, 37.71038], [-121.27935, 37.71067], [-121.27959, 37.71105], [-121.27979, 37.71133], [-121.28001, 37.71158], [-121.2804, 37.712], [-121.28091, 37.71249], [-121.28118, 37.71266], [-121.28148, 37.71297], [-121.28185, 37.71329], [-121.28311, 37.71408], [-121.28375, 37.7143], [-121.28538, 37.71474], [-121.28608, 37.71482], [-121.2868, 37.71493], [-121.28859, 37.71547], [-121.28973, 37.716], [-121.28997, 37.71619], [-121.2902, 37.71644], [-121.29036, 37.71668], [-121.29047, 37.71691], [-121.29054, 37.71709], [-121.29058, 37.71727], [-121.29068, 37.7181], [-121.29089, 37.71938], [-121.29113, 37.72023], [-121.29134, 37.72079], [-121.29167, 37.72147], [-121.29219, 37.72227], [-121.29316, 37.72324], [-121.29363, 37.72374], [-121.29449, 37.72472]]]} | Restricted Access 2 | 24421 | Vernalis Ecological Reserve | 30745 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Joaquin 39 | 92.761 | Vernalis ER | 0 | State Conservation Area 8 | 2 | |
8391 | 8391 | 8390 | {"type": "Polygon", "coordinates": [[[-119.00082, 37.62582], [-119.00081, 37.6306], [-118.99984, 37.63154], [-118.99949, 37.63197], [-118.99927, 37.63229], [-118.99906, 37.63264], [-118.99879, 37.63316], [-118.99607, 37.63312], [-118.99605, 37.63429], [-118.99278, 37.63466], [-118.99276, 37.63471], [-118.99276, 37.63445], [-118.9919, 37.63432], [-118.99152, 37.63428], [-118.99137, 37.63399], [-118.9914, 37.63239], [-118.99193, 37.63238], [-118.99191, 37.63111], [-118.99183, 37.6311], [-118.99179, 37.62805], [-118.99295, 37.62728], [-118.9931, 37.6272], [-118.99327, 37.62714], [-118.99345, 37.6271], [-118.99363, 37.62709], [-118.99368, 37.62779], [-118.99456, 37.62775], [-118.99527, 37.62808], [-118.99528, 37.62709], [-118.99548, 37.62703], [-118.99567, 37.62695], [-118.9959, 37.62679], [-118.99599, 37.62669], [-118.99605, 37.62658], [-118.99609, 37.62646], [-118.9961, 37.62634], [-118.99601, 37.62589], [-119.00082, 37.62582]]]} | Restricted Access 2 | 48488 | Valentine Eastern Sierra Reserve - Valentine Camp | 33199 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | https://ucnrs.org/reserves/valentine-camp-reserve/ | Mono 32 | 149.894 | Valentine Eastern Sierra Reserve - Valentine Camp | None 704 | ||
6190 | 6190 | 6189 | {"type": "Polygon", "coordinates": [[[-119.70992, 34.46417], [-119.70991, 34.46472], [-119.70956, 34.46473], [-119.70965, 34.46495], [-119.70989, 34.46535], [-119.70981, 34.46588], [-119.7094, 34.46606], [-119.70917, 34.46612], [-119.70901, 34.46629], [-119.70864, 34.46641], [-119.70706, 34.4664], [-119.70705, 34.46633], [-119.70692, 34.46627], [-119.70661, 34.46602], [-119.70648, 34.46582], [-119.70629, 34.46566], [-119.70606, 34.46556], [-119.70574, 34.46546], [-119.70572, 34.46839], [-119.70153, 34.46838], [-119.7015, 34.47222], [-119.69721, 34.4722], [-119.69734, 34.46472], [-119.70858, 34.46473], [-119.70858, 34.46476], [-119.70865, 34.46494], [-119.70912, 34.46495], [-119.70925, 34.46472], [-119.70939, 34.46472], [-119.70941, 34.46447], [-119.70973, 34.4642], [-119.70992, 34.46417]]]} | Restricted Access 2 | 1555 | UC Reserve System land | 26639 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | Santa Barbara 7 | 133.642 | UC Reserve System land | None 499 | |||
8999 | 8999 | 8998 | {"type": "Polygon", "coordinates": [[[-116.70159, 33.88765], [-116.70159, 33.88807], [-116.69746, 33.88804], [-116.69744, 33.89518], [-116.68886, 33.89519], [-116.68875, 33.888], [-116.68638, 33.88798], [-116.68652, 33.88782], [-116.68635, 33.88771], [-116.68882, 33.8877], [-116.68884, 33.888], [-116.69731, 33.88804], [-116.69732, 33.88767], [-116.70159, 33.88765]]]} | Restricted Access 2 | 14873 | UC Oasis de Los Osos | 26638 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | Riverside 10 | 163.171 | UC Oasis de Los Osos | None 748 | |||
6367 | 6367 | 6366 | {"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 | 1750 | UC Agricultural Research Station | 26634 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | Napa 11 | 40.126 | UC Agricultural Research Station | None 517 | |||
631 | 631 | 630 | {"type": "Polygon", "coordinates": [[[-122.25462, 39.99416], [-122.2544, 40.00129], [-122.25096, 40.00128], [-122.24748, 40.00133], [-122.24757, 39.99403], [-122.24456, 39.99402], [-122.23507, 39.99405], [-122.23535, 39.98688], [-122.23987, 39.98679], [-122.2466, 39.98672], [-122.25062, 39.98668], [-122.25422, 39.9867], [-122.25416, 39.99039], [-122.25416, 39.99414], [-122.25462, 39.99416]]]} | Restricted Access 2 | 4792 | Thomes Creek Ecological Reserve | 26310 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Tehama 18 | 442.371 | Thomes Creek ER | 0 | State Conservation Area 8 | 2 | |
7537 | 7537 | 7536 | {"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 | 9392 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Sonoma 16 | 2.51 | Theiller Sebastopol Meadowfoam ER | 0 | State Conservation Area 8 | 2 | |
15616 | 15616 | 15615 | {"type": "Polygon", "coordinates": [[[-124.27423, 40.69404], [-124.27417, 40.69605], [-124.27373, 40.69604], [-124.27351, 40.69725], [-124.27255, 40.69751], [-124.27151, 40.6975], [-124.27042, 40.69722], [-124.26953, 40.69696], [-124.26924, 40.69754], [-124.26451, 40.6969], [-124.26455, 40.69402], [-124.26422, 40.69401], [-124.26428, 40.68722], [-124.26498, 40.68723], [-124.26503, 40.68727], [-124.26536, 40.68771], [-124.27049, 40.69025], [-124.27134, 40.69119], [-124.27308, 40.69196], [-124.27268, 40.69352], [-124.27363, 40.69412], [-124.27423, 40.69404]]]} | Restricted Access 2 | 21618 | Table Bluff Ecological Reserve | 26161 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Humboldt 45 | 164.236 | Table Bluff ER | 0 | State Conservation Area 8 | 2 | |
5751 | 5751 | 5750 | {"type": "MultiPolygon", "coordinates": [[[[-115.64839, 34.81949], [-115.63082, 34.81943], [-115.6308, 34.80941], [-115.62627, 34.80938], [-115.62642, 34.80577], [-115.64835, 34.80584], [-115.64839, 34.81949]]], [[[-115.66529, 34.77683], [-115.66528, 34.78407], [-115.6483, 34.78406], [-115.64827, 34.78408], [-115.6483, 34.79132], [-115.63077, 34.79127], [-115.63075, 34.79129], [-115.63077, 34.77678], [-115.66529, 34.77683]]], [[[-115.68285, 34.81958], [-115.66525, 34.81956], [-115.66531, 34.80578], [-115.68279, 34.80584], [-115.68285, 34.81958]]]]} | Restricted Access 2 | 3199 | Sweeney Granite Mountains Desert Research Center | 26101 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | San Bernardino 22 | 2193.744 | Sweeney Granite Mtns. Desert Research Ctr. | None 463 | |||
16966 | 16966 | 16965 | {"type": "MultiPolygon", "coordinates": [[[[-118.65894, 34.09067], [-118.6584, 34.09088], [-118.65818, 34.09092], [-118.65805, 34.09092], [-118.65778, 34.09087], [-118.65727, 34.09065], [-118.65706, 34.09061], [-118.65686, 34.09061], [-118.65631, 34.09068], [-118.65619, 34.09069], [-118.65602, 34.09066], [-118.65581, 34.09059], [-118.65522, 34.0903], [-118.65493, 34.09022], [-118.65474, 34.09019], [-118.65398, 34.09017], [-118.65376, 34.09019], [-118.65358, 34.09024], [-118.65348, 34.0903], [-118.65336, 34.09041], [-118.65325, 34.09056], [-118.65313, 34.09096], [-118.65309, 34.09104], [-118.65302, 34.09112], [-118.65289, 34.09121], [-118.65253, 34.09139], [-118.65237, 34.09152], [-118.65231, 34.09163], [-118.65228, 34.09173], [-118.6523, 34.09208], [-118.65228, 34.09218], [-118.6522, 34.09232], [-118.65216, 34.09236], [-118.65194, 34.09254], [-118.65177, 34.09262], [-118.65153, 34.0927], [-118.65116, 34.09274], [-118.651, 34.09278], [-118.65087, 34.09284], [-118.65059, 34.09306], [-118.65049, 34.0931], [-118.65019, 34.09315], [-118.65005, 34.0932], [-118.64986, 34.09335], [-118.6498, 34.09344], [-118.64966, 34.09372], [-118.64958, 34.0938], [-118.64949, 34.09385], [-118.64932, 34.09388], [-118.64917, 34.09385], [-118.6481, 34.0933], [-118.64793, 34.09325], [-118.64769, 34.09324], [-118.64753, 34.09328], [-118.64741, 34.09334], [-118.64725, 34.09346], [-118.64716, 34.09363], [-118.647, 34.09414], [-118.64698, 34.09424], [-118.64699, 34.09442], [-118.64705, 34.0946], [-118.64709, 34.09469], [-118.6472, 34.09482], [-118.64737, 34.09494], [-118.64751, 34.09501], [-118.64769, 34.09506], [-118.64891, 34.09528], [-118.64914, 34.09531], [-118.64954, 34.09531], [-118.64983, 34.09529], [-118.65032, 34.0952], [-118.6507, 34.09509], [-118.6512, 34.09488], [-118.65135, 34.09484], [-118.65157, 34.09483], [-118.65182, 34.09487], [-118.65203, 34.09496], [-118.65221, 34.0951], [-118.6523, 34.09521], [-118.65235, 34.09529], [-118.65242, 34.09551], [-118.65242, 34.09562], [-118.6524, 34.09574], [-118.65233, 34.09591], [-118.65219, 34.09613], [-118.65214, 34.09627], [-118.65017, 34.09629], [-118.6502, 34.09996], [-118.64111, 34.09994], [-118.64112, 34.09636], [-118.64115, 34.09468], [-118.64116, 34.09265], [-118.65012, 34.09267], [-118.65009, 34.08891], [-118.65894, 34.08891], [-118.65894, 34.09067]]], [[[-118.65894, 34.0962], [-118.65234, 34.09626], [-118.65238, 34.09618], [-118.65252, 34.09596], [-118.65257, 34.09584], [-118.65261, 34.09566], [-118.65261, 34.09546], [-118.65252, 34.0952], [-118.65238, 34.09502], [-118.65227, 34.09491], [-118.65214, 34.09483], [-118.65199, 34.09475], [-118.65187, 34.09471], [-118.6517, 34.09468], [-118.65139, 34.09467], [-118.65111, 34.09473], [-118.65049, 34.09497], [-118.65006, 34.09507], [-118.64959, 34.09513], [-118.64924, 34.09513], [-118.64891, 34.09511], [-118.64773, 34.0949], [-118.64752, 34.09482], [-118.64734, 34.0947], [-118.64723, 34.09454], [-118.64718, 34.09439], [-118.64719, 34.09421], [-118.64735, 34.09366], [-118.6474, 34.09357], [-118.64754, 34.09346], [-118.64774, 34.09341], [-118.64789, 34.09341], [-118.64802, 34.09346], [-118.64909, 34.09401], [-118.64925, 34.09404], [-118.6494, 34.09404], [-118.64962, 34.09397], [-118.64979, 34.09385], [-118.64987, 34.09374], [-118.64998, 34.09349], [-118.65001, 34.09345], [-118.65013, 34.09336], [-118.65023, 34.09332], [-118.65051, 34.09327], [-118.65067, 34.09321], [-118.65103, 34.09295], [-118.6511, 34.09292], [-118.65154, 34.09286], [-118.65179, 34.09279], [-118.65206, 34.09266], [-118.6523, 34.09248], [-118.65242, 34.09233], [-118.65248, 34.09218], [-118.65249, 34.09207], [-118.65247, 34.09175], [-118.65252, 34.09164], [-118.65259, 34.09155], [-118.65303, 34.09132], [-118.65319, 34.09121], [-118.65326, 34.09111], [-118.65333, 34.09099], [-118.65344, 34.09062], [-118.65351, 34.09051], [-118.6536, 34.09044], [-118.65375, 34.09037], [-118.65387, 34.09034], [-118.65469, 34.09035], [-118.65484, 34.09037], [-118.65503, 34.09041], [-118.65517, 34.09046], [-118.65573, 34.09074], [-118.65601, 34.09083], [-118.65612, 34.09085], [-118.65639, 34.09085], [-118.65684, 34.09079], [-118.65706, 34.09078], [-118.65719, 34.09081], [-118.65763, 34.091], [-118.65785, 34.09106], [-118.65802, 34.09108], [-118.65815, 34.09108], [-118.65839, 34.09105], [-118.6584, 34.09173], [-118.65894, 34.09173], [-118.65894, 34.0962]]]]} | Restricted Access 2 | 6444 | Stunt Ranch Santa Monica Mountains Reserve | 25938 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | Los Angeles 6 | 319.623 | Stunt Ranch Santa Monica Mtns. Reserve | 0 | State Conservation Area 8 | 2 | |
12259 | 12259 | 12258 | {"type": "MultiPolygon", "coordinates": [[[[-121.79497, 36.91818], [-121.79476, 36.92157], [-121.79287, 36.92142], [-121.792, 36.92038], [-121.79156, 36.91989], [-121.79092, 36.91958], [-121.79044, 36.91919], [-121.79006, 36.91924], [-121.78959, 36.9184], [-121.7892, 36.91777], [-121.79015, 36.91691], [-121.79042, 36.91742], [-121.79241, 36.9166], [-121.79251, 36.91675], [-121.79276, 36.91731], [-121.79314, 36.91807], [-121.79321, 36.91828], [-121.79323, 36.91864], [-121.79447, 36.91813], [-121.79497, 36.91818]]], [[[-121.79513, 36.91547], [-121.79504, 36.91694], [-121.79469, 36.91689], [-121.79447, 36.91679], [-121.79439, 36.91659], [-121.79438, 36.91643], [-121.79442, 36.91627], [-121.79454, 36.9161], [-121.79471, 36.91597], [-121.79464, 36.91567], [-121.79513, 36.91547]]]]} | Restricted Access 2 | 25824 | Struve Slough - California Coastal Conservancy | 25932 | 200 | California State Coastal Conservancy 859 | State 5 | State Agency 5 | http://www.scc.ca.gov/ | Other State 5 | 200 | California State Coastal Conservancy 837 | State 5 | State Agency 5 | Santa Cruz 5 | 40.585 | Struve Slough - California Coastal Conservancy | None 1069 | |||
6242 | 6242 | 6241 | {"type": "Polygon", "coordinates": [[[-121.84899, 39.81202], [-121.84437, 39.81198], [-121.84436, 39.81917], [-121.8255, 39.81921], [-121.82538, 39.80767], [-121.82985, 39.80628], [-121.83413, 39.80354], [-121.83631, 39.80463], [-121.83719, 39.80419], [-121.83706, 39.80519], [-121.83795, 39.80893], [-121.83893, 39.80972], [-121.84017, 39.80853], [-121.84017, 39.80608], [-121.84448, 39.7992], [-121.84818, 39.79909], [-121.84876, 39.79968], [-121.84899, 39.81202]]]} | Restricted Access 2 | 23359 | Stone Ridge Ecological Reserve | 25876 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Stone-Corral-ER | Butte 42 | 749.235 | Stone Ridge ER | 0 | State Conservation Area 8 | 2 |
4306 | 4306 | 4305 | {"type": "Polygon", "coordinates": [[[-121.47627, 38.28439], [-121.47627, 38.28439], [-121.47626, 38.29098], [-121.47106, 38.28433], [-121.47627, 38.28439]]]} | Restricted Access 2 | 45350 | Stone Lakes | 25872 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Sacramento 41 | 41.206 | Stone Lakes | None 380 | ||||
3803 | 3803 | 3802 | {"type": "MultiPolygon", "coordinates": [[[[-122.10658, 38.5004], [-122.09761, 38.50035], [-122.09774, 38.50434], [-122.09775, 38.50723], [-122.09305, 38.50723], [-122.093, 38.50397], [-122.09232, 38.49092], [-122.09697, 38.4909], [-122.09687, 38.4893], [-122.09688, 38.48804], [-122.0969, 38.48794], [-122.09688, 38.4865], [-122.09693, 38.48236], [-122.10164, 38.48238], [-122.10165, 38.48207], [-122.10631, 38.48211], [-122.10633, 38.48923], [-122.1065, 38.49317], [-122.10655, 38.49628], [-122.10658, 38.5004]]], [[[-122.1064, 38.50769], [-122.10633, 38.50813], [-122.10619, 38.50846], [-122.1061, 38.5086], [-122.10598, 38.5087], [-122.10582, 38.50877], [-122.10572, 38.50879], [-122.10561, 38.50879], [-122.10518, 38.50894], [-122.10504, 38.50897], [-122.10464, 38.50918], [-122.10452, 38.50932], [-122.10427, 38.5095], [-122.1042, 38.50947], [-122.10212, 38.50969], [-122.10231, 38.50753], [-122.10582, 38.50758], [-122.1064, 38.50769]]]]} | Restricted Access 2 | 35111 | Stebbins Cold Canyon Reserve | 25816 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | Solano 26 | 606.446 | Stebbins Cold Canyon Reserve | 0 | State Conservation Area 8 | 2 | |
14013 | 14013 | 14012 | {"type": "Polygon", "coordinates": [[[-122.11169, 38.50773], [-122.1107, 38.50895], [-122.1103, 38.50914], [-122.10997, 38.50935], [-122.1099, 38.50952], [-122.10976, 38.50999], [-122.10965, 38.51017], [-122.10949, 38.51031], [-122.109, 38.51048], [-122.10868, 38.51068], [-122.1084, 38.51095], [-122.10723, 38.51093], [-122.10585, 38.51011], [-122.10579, 38.51048], [-122.10427, 38.5095], [-122.10452, 38.50932], [-122.10464, 38.50918], [-122.10504, 38.50897], [-122.10518, 38.50894], [-122.10561, 38.50879], [-122.10572, 38.50879], [-122.10582, 38.50877], [-122.10598, 38.5087], [-122.1061, 38.50861], [-122.10619, 38.50846], [-122.10633, 38.50813], [-122.10639, 38.50768], [-122.10648, 38.50743], [-122.11132, 38.5074], [-122.11134, 38.50684], [-122.11148, 38.50691], [-122.11169, 38.50773]]]} | Restricted Access 2 | 37025 | Stebbins Cold Canyon Reserve | 25816 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | Napa 11 | 38.968 | Stebbins Cold Canyon Reserve | 0 | State Conservation Area 8 | 2 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);