units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
109 rows where ACCESS_TYP = 2 and DES_TP = 8 sorted by AGNCY_TYP
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_LEV, AGNCY_WEB, MNG_AG_ID, YR_EST
MNG_AGENCY 7
MNG_AG_TYP 2
DES_TP 1
- State Conservation Area · 109 ✖
ACCESS_TYP 1
- Restricted Access · 109 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3589 | 3589 | 3588 | {"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 | 29176 | Cosumnes River Ecological Reserve | 17675 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Cosumnes-River-ER | Sacramento 41 | 5.742 | Cosumnes River ER | 2003 | State Conservation Area 8 | 2 |
3591 | 3591 | 3590 | {"type": "Polygon", "coordinates": [[[-124.14742, 40.69347], [-124.14559, 40.69346], [-124.14538, 40.69323], [-124.14529, 40.69315], [-124.1453, 40.6929], [-124.14528, 40.69266], [-124.14516, 40.69246], [-124.14439, 40.69244], [-124.14425, 40.69237], [-124.14377, 40.69258], [-124.14337, 40.6929], [-124.14227, 40.69323], [-124.14201, 40.69328], [-124.14184, 40.69325], [-124.14175, 40.69317], [-124.14175, 40.69315], [-124.1408, 40.6924], [-124.14079, 40.6925], [-124.14074, 40.69274], [-124.14083, 40.69303], [-124.14104, 40.69323], [-124.14057, 40.69342], [-124.14053, 40.69198], [-124.13941, 40.69246], [-124.1312, 40.69009], [-124.13037, 40.68982], [-124.1215, 40.68448], [-124.12146, 40.68269], [-124.11355, 40.68077], [-124.10809, 40.6787], [-124.10786, 40.6787], [-124.10721, 40.67735], [-124.0988, 40.67462], [-124.09604, 40.67387], [-124.09406, 40.67463], [-124.09347, 40.67584], [-124.08834, 40.67698], [-124.08359, 40.67528], [-124.08359, 40.67524], [-124.07786, 40.67485], [-124.07651, 40.67401], [-124.07441, 40.67364], [-124.07124, 40.6721], [-124.06831, 40.6679], [-124.06471, 40.66617], [-124.0647, 40.66617], [-124.0647, 40.6662], [-124.06468, 40.66621], [-124.06319, 40.6653], [-124.05956, 40.66442], [-124.05778, 40.66229], [-124.05384, 40.65824], [-124.05365, 40.65509], [-124.05002, 40.6541], [-124.04946, 40.65278], [-124.04812, 40.65258], [-124.0477, 40.65187], [-124.04497, 40.65101], [-124.04491, 40.6495], [-124.04189, 40.64952], [-124.04106, 40.64851], [-124.04073, 40.64823], [-124.03978, 40.648], [-124.03632, 40.64835], [-124.02927, 40.64745], [-124.03058, 40.63728], [-124.02908, 40.63553], [-124.02749, 40.63464], [-124.02498, 40.63367], [-124.02012, 40.63067], [-124.02289, 40.62734], [-124.02636, 40.62391], [-124.02952, 40.6237], [-124.03035, 40.62414], [-124.0314, 40.62386], [-124.03149, 40.62163], [-124.03431, 40.62178], [-124.0349, 40.62231], [-124.03653, 40.62122], [-124.03747, 40.6213], [-124.03813, 40.6188], [-124.04011, 40.61761], [-124.04263, 40.61339], [-124.04458, 40.61226], [-124.04459, 40.6127], [-124.0446, 40.61271], [-124.05363, 40.61225], [-124.05809, 40.6085], [-124.05947, 40.60912], [-124.06172, 40.60889], [-124.06364, 40.60903], [-124.06361, 40.60599], [-124.06804, 40.60592], [-124.06818, 40.60858], [-124.06892, 40.60908], [-124.06935, 40.61206], [-124.07123, 40.61266], [-124.07203, 40.6147], [-124.07427, 40.6156], [-124.07464, 40.61645], [-124.07765, 40.61879], [-124.08288, 40.61806], [-124.08893, 40.61992], [-124.09223, 40.62186], [-124.09333, 40.62235], [-124.09552, 40.62446], [-124.09889, 40.62474], [-124.10109, 40.62456], [-124.10608, 40.62589], [-124.11182, 40.62545], [-124.11188, 40.6276], [-124.11191, 40.62761], [-124.11131, 40.64262], [-124.10174, 40.64225], [-124.10166, 40.64898], [-124.10191, 40.65658], [-124.10231, 40.66392], [-124.10343, 40.67117], [-124.10615, 40.6712], [-124.10602, 40.67272], [-124.1088, 40.67387], [-124.11149, 40.67583], [-124.11218, 40.67742], [-124.11561, 40.67875], [-124.11596, 40.67875], [-124.11815, 40.67964], [-124.1214, 40.68025], [-124.12141, 40.68024], [-124.12138, 40.67879], [-124.13117, 40.68583], [-124.13949, 40.68965], [-124.14155, 40.68971], [-124.14739, 40.69182], [-124.14742, 40.69347]], [[-124.09275, 40.67312], [-124.09494, 40.67244], [-124.09639, 40.67249], [-124.0964, 40.67248], [-124.08994, 40.66756], [-124.08528, 40.66692], [-124.08296, 40.66327], [-124.08295, 40.66294], [-124.08063, 40.65854], [-124.07603, 40.65701], [-124.06997, 40.65189], [-124.06773, 40.64819], [-124.06452, 40.64798], [-124.06454, 40.64939], [-124.064, 40.64939], [-124.05629, 40.64394], [-124.04659, 40.64056], [-124.04485, 40.63975], [-124.04491, 40.64863], [-124.05539, 40.65476], [-124.05584, 40.65772], [-124.06019, 40.66206], [-124.06478, 40.66376], [-124.06478, 40.66394], [-124.06676, 40.66461], [-124.07068, 40.66745], [-124.07235, 40.67098], [-124.07617, 40.67265], [-124.07829, 40.67329], [-124.0835, 40.67367], [-124.08351, 40.67365], [-124.08626, 40.67453], [-124.08786, 40.67522], [-124.09141, 40.67419], [-124.09275, 40.67312]]]} | Restricted Access 2 | 29210 | Headwaters Forest Reserve | 29960 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | http://www.blm.gov/ca/st/en/prog/nlcs/Headwaters_ForestReserve.html | Humboldt 45 | 7609.194 | Headwaters Forest Reserve | 0 | State Conservation Area 8 | 2 |
6676 | 6676 | 6675 | {"type": "Polygon", "coordinates": [[[-117.1779, 33.42839], [-117.1779, 33.43232], [-117.17339, 33.43239], [-117.17327, 33.42847], [-117.1779, 33.42839]]]} | Restricted Access 2 | 5517 | Santa Margarita Ecological Reserve | 33342 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 221 | San Diego State University 378 | State 5 | State Agency 5 | https://fsp.sdsu.edu/about-us/ | San Diego 4 | 45.762 | Santa Margarita ER | 1962 | State Conservation Area 8 | 2 |
8388 | 8388 | 8387 | {"type": "MultiPolygon", "coordinates": [[[[-122.15612, 38.5114], [-122.15602, 38.51461], [-122.13849, 38.5146], [-122.13848, 38.51219], [-122.13854, 38.50977], [-122.13865, 38.50359], [-122.15197, 38.50368], [-122.15222, 38.50001], [-122.15555, 38.49999], [-122.1556, 38.50362], [-122.15219, 38.50368], [-122.15195, 38.5111], [-122.15604, 38.51137], [-122.15612, 38.5114]]], [[[-122.14395, 38.48911], [-122.13942, 38.48915], [-122.13932, 38.48613], [-122.13918, 38.48221], [-122.14358, 38.48228], [-122.14395, 38.48911]]], [[[-122.15728, 38.48585], [-122.15276, 38.48591], [-122.15247, 38.48241], [-122.15699, 38.48233], [-122.15728, 38.48585]]]]} | Restricted Access 2 | 48483 | Quail Ridge Reserve | 33192 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 217 | University of California 51 | State 5 | State Agency 5 | https://ucnrs.org/reserves/quail-ridge-reserve/ | Napa 11 | 529.199 | Quail Ridge Reserve | 0 | State Conservation Area 8 | 2 |
15052 | 15052 | 15051 | {"type": "MultiPolygon", "coordinates": [[[[-117.25255, 33.80464], [-117.24993, 33.80461], [-117.24825, 33.80463], [-117.24827, 33.80108], [-117.25252, 33.80114], [-117.25255, 33.80464]]], [[[-117.26585, 33.81556], [-117.26585, 33.81919], [-117.26149, 33.81923], [-117.26146, 33.81559], [-117.26585, 33.81556]]]]} | Restricted Access 2 | 48493 | Motte Rimrock Reserve | 22519 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 217 | University of California 51 | State 5 | State Agency 5 | https://ucnrs.org/reserves/motte-rimrock-reserve/ | Riverside 10 | 78.529 | Motte Rimrock Reserve | 0 | State Conservation Area 8 | 2 |
15568 | 15568 | 15567 | {"type": "MultiPolygon", "coordinates": [[[[-117.15855, 33.46486], [-117.15421, 33.46507], [-117.14524, 33.46588], [-117.14538, 33.46928], [-117.14494, 33.46886], [-117.14213, 33.46585], [-117.13783, 33.46151], [-117.1408, 33.46153], [-117.14069, 33.45434], [-117.13656, 33.45432], [-117.13646, 33.45406], [-117.13637, 33.45348], [-117.1363, 33.45254], [-117.13632, 33.44932], [-117.13637, 33.4487], [-117.13646, 33.448], [-117.13653, 33.44776], [-117.13676, 33.44716], [-117.15344, 33.4472], [-117.15396, 33.4616], [-117.1584, 33.46141], [-117.15855, 33.46486]]], [[[-117.20649, 33.43578], [-117.20644, 33.44303], [-117.19756, 33.44297], [-117.1975, 33.44657], [-117.19305, 33.44653], [-117.19309, 33.44294], [-117.18865, 33.44291], [-117.18876, 33.43575], [-117.19321, 33.43576], [-117.19316, 33.43934], [-117.19759, 33.43937], [-117.19765, 33.43577], [-117.20649, 33.43578]]]]} | Restricted Access 2 | 5509 | Santa Margarita Ecological Reserve | 33342 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 221 | San Diego State University 378 | State 5 | State Agency 5 | https://fsp.sdsu.edu/about-us/ | Riverside 10 | 1078.683 | Santa Margarita ER | 1962 | State Conservation Area 8 | 2 |
10259 | 10259 | 10258 | {"type": "Polygon", "coordinates": [[[-119.85959, 34.42432], [-119.85958, 34.4251], [-119.85929, 34.42511], [-119.8593, 34.42523], [-119.85958, 34.42524], [-119.85956, 34.4273], [-119.85783, 34.42735], [-119.85758, 34.42861], [-119.85608, 34.42866], [-119.85706, 34.43053], [-119.85707, 34.43059], [-119.85041, 34.43096], [-119.85038, 34.42968], [-119.84781, 34.42968], [-119.84772, 34.42807], [-119.85208, 34.42791], [-119.85201, 34.4263], [-119.8449, 34.42644], [-119.83962, 34.42311], [-119.8383, 34.41926], [-119.83522, 34.41979], [-119.83523, 34.41728], [-119.83572, 34.41704], [-119.83597, 34.41681], [-119.83596, 34.41656], [-119.83624, 34.41644], [-119.83795, 34.41587], [-119.83861, 34.41589], [-119.83919, 34.41603], [-119.83978, 34.41639], [-119.8403, 34.41663], [-119.84059, 34.41665], [-119.84147, 34.41655], [-119.84202, 34.41676], [-119.84225, 34.41702], [-119.84254, 34.41719], [-119.84261, 34.41773], [-119.84345, 34.41803], [-119.84388, 34.41787], [-119.84649, 34.41887], [-119.84724, 34.4191], [-119.84777, 34.41943], [-119.84846, 34.41967], [-119.84932, 34.42002], [-119.8494, 34.42008], [-119.84978, 34.42043], [-119.85006, 34.42077], [-119.85049, 34.42106], [-119.85071, 34.4211], [-119.85103, 34.42129], [-119.85145, 34.42146], [-119.85197, 34.42172], [-119.85228, 34.42193], [-119.85231, 34.42208], [-119.85241, 34.42211], [-119.8514, 34.42425], [-119.8514, 34.42427], [-119.85959, 34.42432]]]} | Restricted Access 2 | 16626 | Goleta Slough Ecological Reserve | 19383 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Goleta-Slough-ER | Santa Barbara 7 | 382.363 | Goleta Slough ER | 1983 | State Conservation Area 8 | 2 |
15634 | 15634 | 15633 | {"type": "Polygon", "coordinates": [[[-118.41528, 37.50655], [-118.41424, 37.51016], [-118.41131, 37.5101], [-118.41137, 37.5067], [-118.41305, 37.50674], [-118.41305, 37.5065], [-118.41528, 37.50655]]]} | Restricted Access 2 | 29431 | Fish Slough Ecological Reserve | 18918 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Fish-Slough-ER | Mono 32 | 29.181 | Fish Slough ER | 1970 | State Conservation Area 8 | 2 |
10083 | 10083 | 10082 | {"type": "MultiPolygon", "coordinates": [[[[-117.27291, 33.00739], [-117.26287, 33.00739], [-117.26203, 33.00689], [-117.26063, 33.00632], [-117.26066, 33.00626], [-117.26003, 33.00589], [-117.25972, 33.00557], [-117.25947, 33.00491], [-117.25957, 33.00483], [-117.25923, 33.00381], [-117.2588, 33.00344], [-117.25859, 33.00253], [-117.2588, 33.00172], [-117.25872, 33.00139], [-117.25829, 33.0005], [-117.25825, 33.0003], [-117.25846, 33.0003], [-117.2604, 33.00252], [-117.26197, 33.00312], [-117.26213, 33.00334], [-117.26214, 33.00387], [-117.26433, 33.00388], [-117.26433, 33.00262], [-117.26471, 33.00262], [-117.26472, 33.00248], [-117.26513, 33.00249], [-117.26513, 33.00208], [-117.26657, 33.00209], [-117.26659, 33.00211], [-117.2669, 33.00284], [-117.26699, 33.00292], [-117.26713, 33.00294], [-117.26724, 33.00291], [-117.2673, 33.00286], [-117.2678, 33.00198], [-117.26806, 33.00198], [-117.26818, 33.00279], [-117.26812, 33.00299], [-117.26835, 33.00318], [-117.26842, 33.0035], [-117.2686, 33.00363], [-117.26861, 33.00391], [-117.27039, 33.00393], [-117.2704, 33.00381], [-117.27061, 33.00383], [-117.27072, 33.00382], [-117.27089, 33.00376], [-117.27131, 33.00356], [-117.27158, 33.00354], [-117.27197, 33.00355], [-117.2721, 33.00359], [-117.27221, 33.0036], [-117.27223, 33.00361], [-117.2724, 33.00364], [-117.27248, 33.0037], [-117.27258, 33.0037], [-117.27269, 33.00406], [-117.27274, 33.00414], [-117.27287, 33.00423], [-117.27291, 33.00739]], [[-117.26716, 33.00301], [-117.26673, 33.00297], [-117.26688, 33.0036], [-117.26733, 33.00348], [-117.26726, 33.00297], [-117.26716, 33.00301]]], [[[-117.25116, 33.00742], [-117.25114, 33.00903], [-117.25115, 33.01098], [-117.24055, 33.01098], [-117.23939, 33.00941], [-117.2428, 33.00937], [-117.2428, 33.0092], [-117.24294, 33.00923], [-117.24295, 33.00922], [-117.24295, 33.00892], [-117.2428, 33.00883], [-117.24281, 33.00747], [-117.24445, 33.00745], [-117.24444, 33.00563], [-117.24552, 33.00564], [-117.24553, 33.00744], [-117.25116, 33.00742]]], [[[-117.27505, 33.0139], [-117.275, 33.01393], [-117.27475, 33.01377], [-117.27434, 33.01359], [-117.27395, 33.01348], [-117.27374, 33.01345], [-117.27352, 33.01343], [-117.27351, 33.01315], [-117.27319, 33.01314], [-117.27309, 33.01322], [-117.27307, 33.01326], [-117.27304, 33.01336], [-117.27305, 33.01344], [-117.27284, 33.01347], [-117.27256, 33.01347], [-117.27231, 33.01344], [-117.272, 33.01337], [-117.27171, 33.01326], [-117.27134, 33.01306], [-117.27104, 33.01279], [-117.27096, 33.01269], [-117.27083, 33.01249], [-117.27404, 33.01107], [-117.27469, 33.01223], [-117.27472, 33.01331], [-117.27505, 33.0139]]], [[[-117.25907, 33.01465], [-117.25889, 33.01488], [-117.25873, 33.01505], [-117.25836, 33.01536], [-117.25815, 33.0155], [-117.25784, 33.01568], [-117.25757, 33.0158], [-117.25711, 33.01597], [-117.25673, 33.01617], [-117.25651, 33.01633], [-117.25568, 33.01708], [-117.25569, 33.01468], [-117.25907, 33.01465]]], [[[-117.24895, 33.02066], [-117.24723, 33.0218], [-117.24698, 33.0218], [-117.24696, 33.02001], [-117.24894, 33.02002], [-117.24895, 33.02066]]]]} | Restricted Access 2 | 1714 | San Elijo Lagoon Ecological Reserve | 24877 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/San-Elijo-Lagoon-ER | San Diego 4 | 268.615 | San Elijo Lagoon ER | 1983 | State Conservation Area 8 | 2 |
402 | 402 | 401 | {"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 | 1556 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Tulare 29 | 4.947 | Springville ER | 0 | State Conservation Area 8 | 2 | |
467 | 467 | 466 | {"type": "Polygon", "coordinates": [[[-122.16678, 41.6422], [-122.16586, 41.64234], [-122.15522, 41.64335], [-122.15336, 41.64329], [-122.15338, 41.6426], [-122.15402, 41.64246], [-122.15464, 41.64228], [-122.15675, 41.64146], [-122.15726, 41.64123], [-122.15778, 41.64105], [-122.15814, 41.64095], [-122.15861, 41.64084], [-122.15908, 41.64077], [-122.15956, 41.64072], [-122.16013, 41.64069], [-122.16071, 41.64071], [-122.16118, 41.64076], [-122.16164, 41.64083], [-122.16305, 41.64119], [-122.16522, 41.64179], [-122.16586, 41.64201], [-122.16678, 41.6422]]]} | Restricted Access 2 | 921 | Grass Lake Wildlife Area | 19448 | 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 | Siskiyou 28 | 44.169 | Grass Lake Wildlife Area | 0 | State Conservation Area 8 | 2 | |
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 | |
655 | 655 | 654 | {"type": "Polygon", "coordinates": [[[-122.60188, 38.34223], [-122.60099, 38.34219], [-122.59824, 38.34219], [-122.59784, 38.34221], [-122.59674, 38.34238], [-122.59579, 38.34284], [-122.59514, 38.34423], [-122.59427, 38.34493], [-122.59333, 38.34522], [-122.59334, 38.34582], [-122.59113, 38.34633], [-122.5913, 38.34768], [-122.59135, 38.34828], [-122.5912, 38.3487], [-122.59122, 38.34925], [-122.59128, 38.34926], [-122.5913, 38.34965], [-122.59261, 38.35027], [-122.59275, 38.35752], [-122.58592, 38.35768], [-122.58582, 38.35554], [-122.5836, 38.35559], [-122.58354, 38.34758], [-122.58768, 38.34758], [-122.58754, 38.34322], [-122.5927, 38.34315], [-122.59271, 38.33808], [-122.59176, 38.33786], [-122.59079, 38.33744], [-122.58972, 38.33705], [-122.58885, 38.33685], [-122.588, 38.3368], [-122.58729, 38.33644], [-122.5869, 38.33609], [-122.58626, 38.33575], [-122.58571, 38.33561], [-122.58518, 38.33551], [-122.58545, 38.33521], [-122.58614, 38.33528], [-122.58697, 38.33561], [-122.58767, 38.33622], [-122.58824, 38.33643], [-122.58911, 38.33648], [-122.58974, 38.33662], [-122.5905, 38.33687], [-122.59169, 38.33743], [-122.5927, 38.33768], [-122.59271, 38.33767], [-122.59272, 38.33589], [-122.60179, 38.33588], [-122.60186, 38.34013], [-122.60188, 38.34223]], [[-122.5906, 38.3493], [-122.59059, 38.34928], [-122.59046, 38.34931], [-122.59053, 38.34931], [-122.5906, 38.3493]]]} | Restricted Access 2 | 3269 | Fairfield Osborn Preserve | 18798 | 211 | California State University Sonoma 232 | State 5 | State Agency 5 | http://www.sonoma.edu/ | Other State 5 | 211 | California State University Sonoma 228 | State 5 | State Agency 5 | Sonoma 16 | 414.364 | Fairfield Osborn Preserve | 2004 | State Conservation Area 8 | 2 | |
1522 | 1522 | 1521 | {"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 | 12834 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Diego 4 | 14.153 | San Luis Rey River 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 | |
2637 | 2637 | 2636 | {"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.43446], [-122.92971, 38.43416], [-122.92954, 38.43343], [-122.92954, 38.43324], [-122.93106, 38.43321], [-122.93269, 38.43323], [-122.93271, 38.43595], [-122.93425, 38.43597], [-122.93426, 38.43681]]]} | Restricted Access 2 | 3289 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Sonoma 16 | 31.802 | Harrison Grade ER | 0 | State Conservation Area 8 | 2 | |
2782 | 2782 | 2781 | {"type": "Polygon", "coordinates": [[[-123.95018, 40.54432], [-123.95, 40.54774], [-123.95168, 40.56229], [-123.94988, 40.57504], [-123.93142, 40.57538], [-123.91977, 40.57531], [-123.91927, 40.56181], [-123.91363, 40.56177], [-123.91412, 40.55814], [-123.91933, 40.55809], [-123.91986, 40.5472], [-123.92568, 40.54733], [-123.92481, 40.53266], [-123.92997, 40.53268], [-123.94513, 40.53325], [-123.94448, 40.54416], [-123.95018, 40.54432]]]} | Restricted Access 2 | 21606 | Owl Creek Ecological Reserve | 23278 | 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 | 2772.208 | Owl Creek ER | 0 | State Conservation Area 8 | 2 | |
2891 | 2891 | 2890 | {"type": "Polygon", "coordinates": [[[-122.27421, 40.4766], [-122.26995, 40.47661], [-122.27039, 40.47569], [-122.26864, 40.47525], [-122.26863, 40.47425], [-122.26907, 40.47419], [-122.26994, 40.47387], [-122.27012, 40.47395], [-122.27418, 40.4704], [-122.27421, 40.4766]]]} | Restricted Access 2 | 18920 | Clover Creek Ecological Reserve | 17434 | 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 | Shasta 27 | 46.643 | Clover Creek ER | 0 | State Conservation Area 8 | 2 | |
3108 | 3108 | 3107 | {"type": "MultiPolygon", "coordinates": [[[[-121.46234, 38.2686], [-121.46231, 38.26876], [-121.46161, 38.26911], [-121.46002, 38.26922], [-121.45923, 38.26938], [-121.45839, 38.2697], [-121.45775, 38.26965], [-121.45753, 38.26953], [-121.45774, 38.2673], [-121.45781, 38.26714], [-121.4579, 38.2664], [-121.45801, 38.26606], [-121.4583, 38.26581], [-121.45862, 38.26576], [-121.45932, 38.26588], [-121.46083, 38.2659], [-121.46118, 38.26624], [-121.46112, 38.26713], [-121.46132, 38.26782], [-121.46167, 38.26823], [-121.46211, 38.2684], [-121.46234, 38.2686]]], [[[-121.68459, 38.14478], [-121.68456, 38.14487], [-121.68445, 38.14505], [-121.68418, 38.14541], [-121.68404, 38.14611], [-121.68393, 38.14638], [-121.68387, 38.14656], [-121.68386, 38.14674], [-121.68389, 38.14684], [-121.6838, 38.14733], [-121.68366, 38.14777], [-121.68363, 38.148], [-121.68355, 38.14839], [-121.68327, 38.14912], [-121.68318, 38.14929], [-121.68312, 38.1493], [-121.68345, 38.14644], [-121.68406, 38.14476], [-121.68459, 38.14478]]]]} | Restricted Access 2 | 25288 | Cosumnes River Preserve | 17678 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Sacramento 41 | 35.364 | Cosumnes River Preserve | 0 | State Conservation Area 8 | 2 | ||
3143 | 3143 | 3142 | {"type": "Polygon", "coordinates": [[[-123.31692, 41.78208], [-123.31238, 41.78212], [-123.31239, 41.78306], [-123.31239, 41.78456], [-123.31192, 41.78442], [-123.31147, 41.78461], [-123.31048, 41.78493], [-123.30981, 41.7853], [-123.30965, 41.78553], [-123.30965, 41.78579], [-123.30984, 41.78586], [-123.31041, 41.78733], [-123.31076, 41.7877], [-123.31092, 41.78773], [-123.31167, 41.78838], [-123.3121, 41.7889], [-123.31224, 41.78911], [-123.3121, 41.79128], [-123.30773, 41.79128], [-123.30674, 41.7913], [-123.30302, 41.79125], [-123.30307, 41.78826], [-123.30306, 41.78463], [-123.30294, 41.78141], [-123.30779, 41.78136], [-123.30782, 41.78299], [-123.31011, 41.78297], [-123.31011, 41.78135], [-123.31238, 41.78128], [-123.31236, 41.77967], [-123.31684, 41.77957], [-123.31692, 41.78208]]]} | Restricted Access 2 | 21593 | China Point Ecological Reserve | 17203 | 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 | Siskiyou 28 | 209.418 | China Point ER | 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]);