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)
MNG_AGENCY 12
- California Department of Fish and Wildlife 287
- University of California 37
- California Department of Parks and Recreation 19
- San Diego State University 7
- Other State 2
- Santa Monica Mountains Conservancy 2
- California Department of Water Resources 2
- The Nature Conservancy 1
- California State University Sonoma 1
- Napa Valley College 1
- Coachella Valley Mountains Conservancy 1
- California State Coastal Conservancy 1
ACCESS_TYP 3
- Open Access 244
- Restricted Access 98
- No Public Access 19
MNG_AG_TYP 2
MNG_AG_LEV 2 ✖
- State 360
- Non Profit 1
DES_TP 1
- State Conservation Area · 361 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16557 | 16557 | 16556 | {"type": "Polygon", "coordinates": [[[-122.2306, 40.38874], [-122.22987, 40.38907], [-122.22946, 40.38917], [-122.22924, 40.3892], [-122.22906, 40.38924], [-122.22887, 40.38924], [-122.22864, 40.38928], [-122.22825, 40.38928], [-122.22806, 40.38936], [-122.22743, 40.38935], [-122.22724, 40.38932], [-122.22611, 40.38921], [-122.22589, 40.38912], [-122.2257, 40.38901], [-122.22555, 40.38888], [-122.22542, 40.38868], [-122.22521, 40.38819], [-122.22507, 40.38776], [-122.23041, 40.38739], [-122.2306, 40.38874]]]} | Open Access 1 | 7678 | Mouth of Cottonwood Creek Wildlife Area | 30477 | 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/Mouth-of-Cottonwood-Creek-WA | Tehama 18 | 19.746 | Mouth of Cottonwood Creek Wildlife Area | 1982 | State Conservation Area 8 | 2 |
6554 | 6554 | 6553 | {"type": "Polygon", "coordinates": [[[-121.58605, 38.59505], [-121.57671, 38.5975], [-121.57669, 38.59709], [-121.57651, 38.59671], [-121.58026, 38.59567], [-121.58339, 38.59485], [-121.58581, 38.59418], [-121.58605, 38.59505]]]} | Open Access 1 | 3275 | Sacramento Bypass Wildlife Area | 30493 | 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/Sacramento-Bypass-WA | Yolo 33 | 19.773 | Sacramento Bypass Wildlife Area | 1988 | State Conservation Area 8 | 2 |
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 | |
5060 | 5060 | 5059 | {"type": "Polygon", "coordinates": [[[-122.5038, 38.11388], [-122.50155, 38.11561], [-122.50104, 38.11583], [-122.49865, 38.11461], [-122.50105, 38.1126], [-122.50133, 38.11229], [-122.5038, 38.11388]]]} | Open Access 1 | 25328 | Petaluma Marsh Wildlife Area | 30485 | 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/Petaluma-Marsh-WA | Sonoma 16 | 21.886 | Petaluma Marsh Wildlife Area | 1979 | State Conservation Area 8 | 2 |
2225 | 2225 | 2224 | {"type": "MultiPolygon", "coordinates": [[[[-121.63488, 36.12197], [-121.63295, 36.12197], [-121.6328, 36.12189], [-121.63274, 36.12187], [-121.63134, 36.12101], [-121.63133, 36.11973], [-121.63116, 36.1198], [-121.63081, 36.12004], [-121.6306, 36.12014], [-121.63054, 36.11998], [-121.63051, 36.11981], [-121.63027, 36.11826], [-121.63128, 36.11827], [-121.63131, 36.11695], [-121.63182, 36.11695], [-121.63177, 36.11708], [-121.63184, 36.11719], [-121.63185, 36.11725], [-121.63189, 36.1173], [-121.63193, 36.11745], [-121.63205, 36.11756], [-121.63222, 36.1178], [-121.63231, 36.11787], [-121.6326, 36.11799], [-121.63271, 36.11813], [-121.63281, 36.11833], [-121.63286, 36.1185], [-121.63288, 36.1187], [-121.63285, 36.11919], [-121.63285, 36.11988], [-121.63293, 36.12014], [-121.63304, 36.12033], [-121.63314, 36.12044], [-121.63326, 36.12064], [-121.6333, 36.12097], [-121.63345, 36.12113], [-121.63361, 36.12125], [-121.63367, 36.12127], [-121.63377, 36.12133], [-121.63381, 36.12139], [-121.6342, 36.12164], [-121.63488, 36.12197]]], [[[-121.63247, 36.12198], [-121.63134, 36.12198], [-121.63134, 36.12131], [-121.63246, 36.12197], [-121.63247, 36.12198]]]]} | Open Access 1 | 16614 | John Little State Reserve | 1582 | 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=568 | Monterey 14 | 23.093 | John Little SR | 1953 | State Conservation Area 8 | 2 |
15618 | 15618 | 15617 | {"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.07187], [-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 | 23594 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Diego 4 | 24.606 | Lake Hodges ER | 0 | State Conservation Area 8 | 2 | |
11472 | 11472 | 11471 | {"type": "Polygon", "coordinates": [[[-121.0343, 37.08628], [-121.03425, 37.08903], [-121.02759, 37.08656], [-121.02759, 37.08625], [-121.0343, 37.08628]]]} | Open Access 1 | 29207 | O'Neill Forebay Wildlife Area | 30483 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Merced 37 | 25.025 | O'Neill Forebay Wildlife Area | 1974 | State Conservation Area 8 | 2 | |
10567 | 10567 | 10566 | {"type": "MultiPolygon", "coordinates": [[[[-122.894, 39.1212], [-122.89308, 39.12185], [-122.89194, 39.12219], [-122.89128, 39.1222], [-122.89021, 39.12184], [-122.88849, 39.12032], [-122.88977, 39.12034], [-122.88992, 39.12051], [-122.89027, 39.12077], [-122.89092, 39.12103], [-122.89157, 39.1211], [-122.89231, 39.12097], [-122.89397, 39.12022], [-122.894, 39.1212]]], [[[-122.89329, 39.12034], [-122.89301, 39.12048], [-122.89198, 39.12092], [-122.89106, 39.12094], [-122.89006, 39.12042], [-122.89, 39.12032], [-122.89329, 39.12034]]], [[[-122.89936, 39.11659], [-122.89935, 39.11744], [-122.89898, 39.11734], [-122.89857, 39.11771], [-122.89813, 39.11829], [-122.89772, 39.11866], [-122.897, 39.11895], [-122.89675, 39.11917], [-122.89663, 39.11936], [-122.89628, 39.11934], [-122.89625, 39.1193], [-122.89611, 39.11918], [-122.89711, 39.1183], [-122.8978, 39.11752], [-122.89827, 39.1171], [-122.89936, 39.11659]]], [[[-122.90101, 39.12068], [-122.8989, 39.11997], [-122.8971, 39.11987], [-122.8968, 39.12012], [-122.89684, 39.11999], [-122.89671, 39.11994], [-122.89671, 39.11955], [-122.89736, 39.1196], [-122.89888, 39.1199], [-122.89976, 39.12005], [-122.90037, 39.12009], [-122.90048, 39.11993], [-122.90044, 39.11981], [-122.90052, 39.1195], [-122.901, 39.11915], [-122.90101, 39.12068]]], [[[-122.90099, 39.11847], [-122.90099, 39.11871], [-122.89992, 39.11855], [-122.89967, 39.11832], [-122.89955, 39.11808], [-122.90099, 39.11847]]]]} | Open Access 1 | 18818 | Clear Lake Wildlife Area | 30426 | 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/Clear-Lake-WA | Lake 40 | 26.063 | Clear Lake Wildlife Area | 2004 | State Conservation Area 8 | 2 |
15608 | 15608 | 15607 | {"type": "Polygon", "coordinates": [[[-121.73917, 36.77633], [-121.73883, 36.77674], [-121.73879, 36.7767], [-121.73768, 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.73489, 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.77647], [-121.73865, 36.77654], [-121.73867, 36.77653], [-121.73805, 36.77568], [-121.7391, 36.77612], [-121.73917, 36.77633]]]} | Restricted Access 2 | 17998 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Monterey 14 | 26.613 | Moro Cojo ER | 0 | State Conservation Area 8 | 2 | |
11250 | 11250 | 11249 | {"type": "Polygon", "coordinates": [[[-124.03457, 41.5002], [-124.03347, 41.50137], [-124.03228, 41.50308], [-124.03218, 41.50354], [-124.032, 41.50523], [-124.03178, 41.50607], [-124.03145, 41.50667], [-124.03084, 41.50734], [-124.02997, 41.50822], [-124.02922, 41.50901], [-124.02868, 41.5098], [-124.02808, 41.51081], [-124.02789, 41.51051], [-124.02779, 41.50915], [-124.02794, 41.50887], [-124.02829, 41.50848], [-124.02972, 41.50711], [-124.03017, 41.50643], [-124.03052, 41.5057], [-124.03061, 41.50508], [-124.03064, 41.50441], [-124.03086, 41.50372], [-124.03209, 41.50204], [-124.03318, 41.50091], [-124.03382, 41.50047], [-124.03457, 41.5002]]]} | Open Access 1 | 21620 | Waukell Creek Wildlife Area | 30515 | 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/Waukell-Creek-WA | Del Norte 50 | 26.779 | Waukell Creek Wildlife Area | 1993 | State Conservation Area 8 | 2 |
16765 | 16765 | 16764 | {"type": "Polygon", "coordinates": [[[-121.67267, 38.23526], [-121.67199, 38.23538], [-121.67109, 38.23548], [-121.66964, 38.23586], [-121.66748, 38.23658], [-121.66657, 38.23705], [-121.66669, 38.23662], [-121.66671, 38.23622], [-121.66645, 38.23594], [-121.66624, 38.23551], [-121.66629, 38.23528], [-121.66642, 38.23505], [-121.66671, 38.23485], [-121.6682, 38.23457], [-121.66951, 38.23415], [-121.67, 38.2338], [-121.67045, 38.23344], [-121.67149, 38.233], [-121.67267, 38.23526]]]} | Open Access 1 | 23602 | Miner Slough Wildlife Area | 30473 | 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/Miner-Slough-WA | Solano 26 | 27.122 | Miner Slough Wildlife Area | 1981 | 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 |
11552 | 11552 | 11551 | {"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 | 23593 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Diego 4 | 29.218 | Boulder Creek ER | 0 | State Conservation Area 8 | 2 | |
15621 | 15621 | 15620 | {"type": "MultiPolygon", "coordinates": [[[[-120.61073, 39.50453], [-120.61064, 39.50618], [-120.60842, 39.50617], [-120.6085, 39.50449], [-120.61073, 39.50453]]], [[[-120.61327, 39.51192], [-120.61072, 39.51188], [-120.61068, 39.50845], [-120.6132, 39.50845], [-120.61323, 39.51019], [-120.61327, 39.51192]]]]} | No Public Access 3 | 21576 | Macklin Creek Ecological Reserve | 32211 | 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 | Nevada 30 | 29.458 | Macklin Creek ER | 0 | State Conservation Area 8 | 2 | |
15575 | 15575 | 15574 | {"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.87201], [-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 | 44940 | Elkhorn Slough Ecological Reserve | 18581 | 3019 | Elkhorn Slough Foundation 464 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.elkhornslough.org | Non Governmental Organization 10 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Elkhorn-Slough-ER | Monterey 14 | 29.594 | Elkhorn Slough ER | 1980 | State Conservation Area 8 | 2 |
10233 | 10233 | 10232 | {"type": "MultiPolygon", "coordinates": [[[[-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]]], [[[-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]]]]} | Restricted Access 2 | 12831 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Diego 4 | 30.386 | San Diego River ER | 0 | State Conservation Area 8 | 2 | |
8349 | 8349 | 8348 | {"type": "Polygon", "coordinates": [[[-116.77797, 33.80726], [-116.77791, 33.81103], [-116.77358, 33.81102], [-116.77357, 33.80908], [-116.77583, 33.80892], [-116.77583, 33.80728], [-116.77797, 33.80726]]]} | Restricted Access 2 | 48473 | James San Jacinto Mountains Reserve | 33184 | 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/james-san-jacinto-mountains-reserve/ | Riverside 10 | 31.718 | James San Jacinto Mtns. Reserve | 0 | State Conservation Area 8 | 2 |
16769 | 16769 | 16768 | {"type": "Polygon", "coordinates": [[[-121.6699, 38.75847], [-121.66966, 38.75881], [-121.66912, 38.75884], [-121.66862, 38.75893], [-121.66828, 38.75904], [-121.66762, 38.75929], [-121.66717, 38.75941], [-121.66663, 38.75977], [-121.66617, 38.76013], [-121.66562, 38.76095], [-121.66491, 38.76228], [-121.66442, 38.76366], [-121.66425, 38.76403], [-121.66402, 38.76472], [-121.66378, 38.76462], [-121.66219, 38.76267], [-121.66228, 38.76192], [-121.66316, 38.76128], [-121.66353, 38.76093], [-121.66406, 38.76012], [-121.66489, 38.75876], [-121.66542, 38.75906], [-121.66683, 38.75878], [-121.66814, 38.7585], [-121.66873, 38.75845], [-121.6694, 38.75842], [-121.66985, 38.75842], [-121.6699, 38.75847]]]} | Open Access 1 | 29012 | Fremont Weir Wildlife Area | 30441 | 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 | Sutter 47 | 31.784 | Fremont Weir Wildlife Area | 1981 | 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 | |
10810 | 10810 | 10809 | {"type": "Polygon", "coordinates": [[[-121.71529, 38.10019], [-121.71529, 38.10019], [-121.71017, 38.10389], [-121.71003, 38.1021], [-121.71, 38.10142], [-121.70992, 38.10079], [-121.70982, 38.09949], [-121.70988, 38.0985], [-121.71529, 38.10019]]]} | Open Access 1 | 23598 | Decker Island Wildlife Area | 30432 | 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/Decker-Island-WA | Solano 26 | 35.275 | Decker Island Wildlife Area | 1988 | 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]);