units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
381 rows where DES_TP = 8 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, LAYER, MNG_AG_ID
MNG_AGENCY 12
- California Department of Fish and Wildlife 303
- University of California 38
- California Department of Parks and Recreation 21
- San Diego State University 7
- Other State 2
- Santa Monica Mountains Conservancy 2
- California Department of Water Resources 2
- Coachella Valley Mountains Conservancy 2
- The Nature Conservancy 1
- California State University Sonoma 1
- Napa Valley College 1
- California State Coastal Conservancy 1
AGNCY_TYP 7 ✖
AGNCY_LEV 6 ✖
- State 356
- Federal 17
- Non Profit 4
- City 2
- County 1
- Special District 1
ACCESS_TYP 3
- Open Access 250
- Restricted Access 109
- No Public Access 22
MNG_AG_TYP 2
DES_TP 1
- State Conservation Area · 381 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
213 | 213 | 212 | {"type": "Polygon", "coordinates": [[[-121.44057, 41.00434], [-121.44008, 41.00444], [-121.44004, 41.00437], [-121.43945, 41.00437], [-121.43934, 41.00404], [-121.43939, 41.00396], [-121.44023, 41.00367], [-121.44032, 41.00373], [-121.44038, 41.00381], [-121.44057, 41.00434]]]} | Open Access 1 | 663 | Fall River Mills Ecological Reserve | 32163 | 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/Fall-River-Mills-ER | Shasta 27 | 1.448 | Fall River Mills ER | 1998 | State Conservation Area 8 | 2 |
12282 | 12282 | 12281 | {"type": "Polygon", "coordinates": [[[-120.19869, 39.31522], [-120.19868, 39.31633], [-120.19754, 39.31634], [-120.19813, 39.31576], [-120.19869, 39.31522]]]} | Open Access 1 | 25911 | Truckee River Wildlife Area | 12543 | 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/Truckee-River-WA | Placer 35 | 1.505 | Truckee River Wildlife Area | 1996 | 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 | |
2855 | 2855 | 2854 | {"type": "MultiPolygon", "coordinates": [[[[-123.82187, 39.36052], [-123.82181, 39.36061], [-123.82169, 39.36065], [-123.82162, 39.36078], [-123.82155, 39.36082], [-123.82145, 39.36074], [-123.82141, 39.36068], [-123.82133, 39.36064], [-123.82131, 39.36057], [-123.82132, 39.36051], [-123.82158, 39.36028], [-123.82186, 39.36045], [-123.82179, 39.36046], [-123.82177, 39.36048], [-123.82183, 39.36049], [-123.82187, 39.36052]]], [[[-123.8228, 39.36144], [-123.82276, 39.36146], [-123.82269, 39.36143], [-123.82259, 39.36148], [-123.82258, 39.36155], [-123.82252, 39.36153], [-123.82241, 39.36153], [-123.8221, 39.3613], [-123.82218, 39.36104], [-123.82217, 39.36096], [-123.82219, 39.36093], [-123.82217, 39.36088], [-123.82209, 39.36082], [-123.82276, 39.36083], [-123.8228, 39.36144]]], [[[-123.8239, 39.36142], [-123.82384, 39.36148], [-123.82388, 39.36153], [-123.82388, 39.36156], [-123.82384, 39.36163], [-123.82363, 39.3617], [-123.82356, 39.36169], [-123.82352, 39.36164], [-123.82328, 39.36152], [-123.82323, 39.36141], [-123.82319, 39.36134], [-123.8234, 39.36118], [-123.82373, 39.36127], [-123.82371, 39.36132], [-123.8239, 39.36142]]], [[[-123.82509, 39.36092], [-123.825, 39.36098], [-123.82499, 39.36102], [-123.82493, 39.36101], [-123.82473, 39.36109], [-123.82458, 39.36104], [-123.8245, 39.36097], [-123.82444, 39.36087], [-123.82437, 39.36085], [-123.82435, 39.36088], [-123.82436, 39.36092], [-123.82433, 39.36095], [-123.82424, 39.36095], [-123.82419, 39.36096], [-123.82414, 39.3609], [-123.8241, 39.36079], [-123.8241, 39.36073], [-123.82405, 39.36071], [-123.82401, 39.36072], [-123.82397, 39.36082], [-123.82387, 39.36069], [-123.82396, 39.36045], [-123.824, 39.36045], [-123.82406, 39.36037], [-123.82415, 39.36036], [-123.82422, 39.36032], [-123.82435, 39.36035], [-123.82449, 39.36041], [-123.82471, 39.36049], [-123.82476, 39.36057], [-123.8249, 39.3606], [-123.82495, 39.36063], [-123.825, 39.3607], [-123.82501, 39.36074], [-123.82508, 39.36083], [-123.8251, 39.36086], [-123.82509, 39.36092]]]]} | Open Access 1 | 22153 | Caspar Headlands State Natural Reserve | 1468 | 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 | http://www.parks.ca.gov/?page_id=444 | Mendocino 24 | 3.22 | Caspar Headlands SNR | 1972 | 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 | |
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 |
6527 | 6527 | 6526 | {"type": "Polygon", "coordinates": [[[-121.21611, 38.65634], [-121.21517, 38.65635], [-121.2144, 38.65533], [-121.21395, 38.65428], [-121.21608, 38.65427], [-121.21611, 38.65634]]]} | No Public Access 3 | 2848 | Phoenix Field Ecological Reserve | 32261 | 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 | Sacramento 41 | 8.007 | Phoenix Field ER | 0 | State Conservation Area 8 | 2 | |
9251 | 9251 | 9250 | {"type": "Polygon", "coordinates": [[[-116.47394, 33.88857], [-116.47122, 33.88857], [-116.47122, 33.88785], [-116.47129, 33.88596], [-116.47394, 33.88857]]]} | No Public Access 3 | 15407 | Edom Hill-Willow Hole Preserve | 18453 | 214 | Coachella Valley Mountains Conservancy 767 | State 5 | State Agency 5 | http://www.cvmc.ca.gov/ | Other State 5 | 214 | Coachella Valley Mountains Conservancy 748 | State 5 | State Agency 5 | Riverside 10 | 9.085 | Edom Hill-Willow Hole Preserve | 0 | State Conservation Area 8 | 2 | |
10777 | 10777 | 10776 | {"type": "Polygon", "coordinates": [[[-121.86483, 36.60512], [-121.86235, 36.60664], [-121.86185, 36.60613], [-121.86192, 36.60536], [-121.86232, 36.60488], [-121.86287, 36.60459], [-121.86434, 36.60427], [-121.86483, 36.60512]]]} | Restricted Access 2 | 23364 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Monterey 14 | 9.592 | Del Monte Dunes ER | 0 | State Conservation Area 8 | 2 | |
7043 | 7043 | 7042 | {"type": "Polygon", "coordinates": [[[-120.45049, 34.69233], [-120.44937, 34.69162], [-120.44841, 34.69135], [-120.44665, 34.69339], [-120.44259, 34.70021], [-120.44243, 34.70013], [-120.44787, 34.69066], [-120.44845, 34.69086], [-120.44961, 34.69143], [-120.45049, 34.69233]]]} | Open Access 1 | 29179 | Burton Mesa Ecological Reserve | 32070 | 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/Burton-Mesa-ER | Santa Barbara 7 | 10.747 | Burton Mesa ER | 2004 | State Conservation Area 8 | 2 |
15628 | 15628 | 15627 | {"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 | 28125 | San Joaquin River Ecological Reserve | 24913 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/San-Joaquin-River-ER | Fresno 9 | 10.874 | San Joaquin River ER | 1990 | State Conservation Area 8 | 2 |
15631 | 15631 | 15630 | {"type": "MultiPolygon", "coordinates": [[[[-118.42515, 33.98022], [-118.42488, 33.98042], [-118.42427, 33.98031], [-118.42454, 33.98011], [-118.42515, 33.98022]]], [[[-118.42921, 33.98035], [-118.42898, 33.98059], [-118.42873, 33.9809], [-118.42783, 33.98073], [-118.42828, 33.9807], [-118.42866, 33.98064], [-118.42887, 33.98056], [-118.42921, 33.98035]]], [[[-118.42901, 33.97746], [-118.42859, 33.97776], [-118.42826, 33.97724], [-118.42875, 33.97693], [-118.42887, 33.97722], [-118.42901, 33.97746]]], [[[-118.43285, 33.97662], [-118.43006, 33.98007], [-118.43, 33.9803], [-118.43002, 33.9806], [-118.4301, 33.98081], [-118.43018, 33.98095], [-118.43027, 33.98105], [-118.43049, 33.98123], [-118.43191, 33.9815], [-118.43208, 33.98162], [-118.43187, 33.98175], [-118.42892, 33.98119], [-118.43269, 33.97653], [-118.43285, 33.97662]], [[-118.43028, 33.98119], [-118.43029, 33.98117], [-118.43018, 33.98107], [-118.43009, 33.98096], [-118.42999, 33.98077], [-118.42993, 33.98058], [-118.42991, 33.98041], [-118.42992, 33.98028], [-118.42991, 33.98027], [-118.42941, 33.98086], [-118.42931, 33.981], [-118.43028, 33.98119]]], [[[-118.4323, 33.97539], [-118.42949, 33.97712], [-118.42928, 33.97727], [-118.42915, 33.97702], [-118.42904, 33.97676], [-118.42915, 33.97666], [-118.43197, 33.97484], [-118.4323, 33.97539]]]]} | Restricted Access 2 | 44627 | Ballona Wetlands Ecological Reserve | 15789 | 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 | Los Angeles 6 | 11.92 | Ballona Wetlands ER | 0 | State Conservation Area 8 | 2 | |
3672 | 3672 | 3671 | {"type": "MultiPolygon", "coordinates": [[[[-120.44871, 34.6888], [-120.44792, 34.69026], [-120.4478, 34.69035], [-120.44763, 34.69033], [-120.44725, 34.69018], [-120.44662, 34.68998], [-120.44669, 34.6899], [-120.44679, 34.6897], [-120.44724, 34.68935], [-120.44815, 34.68888], [-120.44871, 34.6888]]], [[[-120.4499, 34.69128], [-120.44987, 34.69127], [-120.44986, 34.69126], [-120.44856, 34.69068], [-120.44826, 34.69059], [-120.44812, 34.69043], [-120.44817, 34.69018], [-120.44916, 34.6887], [-120.44971, 34.68869], [-120.44982, 34.68905], [-120.45004, 34.69], [-120.45006, 34.69067], [-120.4499, 34.69128]]]]} | Restricted Access 2 | 29691 | Burton Mesa Ecological Reserve | 16533 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Burton-Mesa-ER | Santa Barbara 7 | 11.989 | Burton Mesa ER | 2004 | State Conservation Area 8 | 2 |
16757 | 16757 | 16756 | {"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 | 25313 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Sutter 47 | 12.4 | Collins Eddy Wildlife Area | 0 | State Conservation Area 8 | 2 | |
16787 | 16787 | 16786 | {"type": "Polygon", "coordinates": [[[-121.58877, 39.1692], [-121.58617, 39.16924], [-121.5864, 39.16725], [-121.58707, 39.16749], [-121.58709, 39.16749], [-121.58741, 39.16502], [-121.58877, 39.1692]]]} | Restricted Access 2 | 47980 | Feather River Wildlife Area | 18861 | 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 | Yuba 25 | 12.64 | Feather River Wildlife Area | 1991 | State Conservation Area 8 | 2 | |
15563 | 15563 | 15562 | {"type": "Polygon", "coordinates": [[[-122.7187, 38.86399], [-122.71867, 38.86334], [-122.71873, 38.86325], [-122.72002, 38.86389], [-122.72002, 38.86471], [-122.72031, 38.86555], [-122.72055, 38.8663], [-122.72092, 38.86613], [-122.72154, 38.86716], [-122.71933, 38.86718], [-122.71936, 38.86682], [-122.71935, 38.86664], [-122.7193, 38.86639], [-122.71919, 38.86608], [-122.7188, 38.86524], [-122.7187, 38.86399]]]} | Open Access 1 | 1765 | Loch Lomond Vernal Pool Ecological Reserve | 32205 | 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/Loch-Lomond-Vernal-Pool-ER | Lake 40 | 12.758 | Loch Lomond Vernal Pool ER | 1993 | State Conservation Area 8 | 2 |
16636 | 16636 | 16635 | {"type": "Polygon", "coordinates": [[[-122.33856, 37.11035], [-122.33842, 37.11027], [-122.33829, 37.11015], [-122.33822, 37.11001], [-122.33818, 37.10986], [-122.33812, 37.10977], [-122.33795, 37.10972], [-122.33753, 37.10966], [-122.33731, 37.10959], [-122.33719, 37.10952], [-122.33713, 37.10945], [-122.33709, 37.10936], [-122.33703, 37.10909], [-122.33698, 37.10903], [-122.33693, 37.10899], [-122.33687, 37.10897], [-122.33681, 37.10897], [-122.33638, 37.1091], [-122.336, 37.10913], [-122.33587, 37.1091], [-122.3357, 37.109], [-122.33561, 37.10887], [-122.33558, 37.10855], [-122.33552, 37.10836], [-122.33547, 37.1083], [-122.33535, 37.10824], [-122.33523, 37.10814], [-122.33516, 37.108], [-122.33511, 37.10786], [-122.335, 37.10776], [-122.33493, 37.10762], [-122.33492, 37.10754], [-122.33493, 37.10748], [-122.33503, 37.1074], [-122.33507, 37.10726], [-122.33514, 37.10714], [-122.33521, 37.10712], [-122.33551, 37.10712], [-122.33589, 37.1073], [-122.33595, 37.10736], [-122.33591, 37.1076], [-122.33591, 37.10764], [-122.33594, 37.10767], [-122.33599, 37.10765], [-122.336, 37.10757], [-122.33606, 37.10756], [-122.3362, 37.10763], [-122.33633, 37.1076], [-122.33638, 37.10761], [-122.33641, 37.10764], [-122.33641, 37.10771], [-122.33644, 37.10773], [-122.3365, 37.10773], [-122.3366, 37.10769], [-122.3367, 37.10769], [-122.33682, 37.10772], [-122.33689, 37.1078], [-122.33696, 37.10781], [-122.33701, 37.10778], [-122.33703, 37.10772], [-122.33695, 37.10757], [-122.33694, 37.10743], [-122.33698, 37.10738], [-122.33705, 37.10736], [-122.33712, 37.10739], [-122.33712, 37.10746], [-122.33715, 37.10749], [-122.33721, 37.1075], [-122.3373, 37.10748], [-122.33739, 37.1075], [-122.33749, 37.10755], [-122.33758, 37.10767], [-122.33773, 37.10772], [-122.33777, 37.10777], [-122.3378, 37.10785], [-122.33779, 37.10796], [-122.33781, 37.108], [-122.33793, 37.10811], [-122.33805, 37.10818], [-122.33804, 37.10848], [-122.33801, 37.1085], [-122.33791, 37.10852], [-122.33783, 37.10852], [-122.33774, 37.10848], [-122.33767, 37.10851], [-122.3376, 37.10859], [-122.33753, 37.10873], [-122.33752, 37.10882], [-122.33755, 37.10888], [-122.33766, 37.10892], [-122.33782, 37.10892], [-122.33819, 37.10877], [-122.33829, 37.10875], [-122.33834, 37.10875], [-122.33847, 37.10885], [-122.33865, 37.10895], [-122.33887, 37.10913], [-122.33902, 37.10919], [-122.33916, 37.10927], [-122.33923, 37.10933], [-122.33926, 37.10938], [-122.33925, 37.10941], [-122.33922, 37.10942], [-122.33919, 37.10941], [-122.33916, 37.10935], [-122.33911, 37.10933], [-122.33906, 37.10933], [-122.33894, 37.10937], [-122.33879, 37.10931], [-122.33858, 37.10928], [-122.33848, 37.10923], [-122.33843, 37.10924], [-122.33844, 37.10927], [-122.33852, 37.10929], [-122.33857, 37.10934], [-122.33861, 37.10942], [-122.33861, 37.10949], [-122.33858, 37.10954], [-122.33852, 37.10959], [-122.33839, 37.10964], [-122.33833, 37.10968], [-122.33829, 37.10974], [-122.33828, 37.10981], [-122.3383, 37.10986], [-122.33836, 37.10991], [-122.33841, 37.10992], [-122.33848, 37.1099], [-122.33852, 37.10992], [-122.33855, 37.11003], [-122.33858, 37.11023], [-122.33858, 37.11033], [-122.33856, 37.11035]]]} | No Public Access 3 | 16759 | Año Nuevo State Reserve | 27968 | 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 Mateo 15 | 12.773 | Año Nuevo SR | 2008 | 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 | |
8346 | 8346 | 8345 | {"type": "Polygon", "coordinates": [[[-117.23111, 32.79319], [-117.23107, 32.79326], [-117.23079, 32.7932], [-117.23029, 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 | 48475 | Kendall Frost Mission Bay Marsh Reserve | 33187 | 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/kendall-frost-mission-bay-marsh-reserve/ | San Diego 4 | 16.556 | Kendall Frost Mission Bay Marsh Reserve | 0 | State Conservation Area 8 | 2 |
5955 | 5955 | 5954 | {"type": "Polygon", "coordinates": [[[-120.98655, 37.40316], [-120.98645, 37.4037], [-120.9858, 37.40327], [-120.98326, 37.4014], [-120.98204, 37.40081], [-120.98154, 37.40063], [-120.98443, 37.39949], [-120.98456, 37.39989], [-120.98467, 37.40012], [-120.98472, 37.40027], [-120.98493, 37.40061], [-120.98501, 37.40078], [-120.98513, 37.40095], [-120.98522, 37.40114], [-120.98557, 37.40154], [-120.98567, 37.40168], [-120.98599, 37.40248], [-120.98621, 37.40281], [-120.98643, 37.40306], [-120.98655, 37.40316]]]} | Open Access 1 | 518 | West Hilmar Wildlife Area | 30516 | 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/West-Hilmar-WA | Stanislaus 2 | 16.656 | West Hilmar Wildlife Area | 1994 | 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]);