units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,141 rows where MNG_AG_TYP = 5 sorted by UNIT_ID descending
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_ID, GAP_STS
DES_TP >30
- State Conservation Area 380
- State Park 207
- State Resource Management Area 159
- State Recreation Area 144
- State Other or Unknown 69
- State Historic or Cultural Area 62
- National Monument or Landmark 2
- National Wildlife Refuge 2
- State Wilderness 2
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- National Recreation 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
- …
MNG_AGENCY 20
- California Department of Fish and Wildlife 443
- California Department of Parks and Recreation 380
- California State Lands Commission 86
- University of California 58
- Other State 43
- California Department of Transportation 30
- California Department of Water Resources 20
- Santa Monica Mountains Conservancy 19
- California Department of General Services 14
- California Department of Forestry and Fire Protection 10
- California Wildlife Conservation Board 9
- San Diego State University 7
- California State Coastal Conservancy 7
- Coachella Valley Mountains Conservancy 5
- California Department of Veterans Affairs 2
- Napa Valley College 2
- California State University 2
- California Tahoe Conservancy 2
- California State University Sonoma 1
- California State University Long Beach 1
ACCESS_TYP 4
- Open Access 827
- Restricted Access 149
- No Public Access 137
- Unknown Access 28
MNG_AG_TYP 1
- State Agency · 1,141 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4832 | 4832 | 4831 | {"type": "Polygon", "coordinates": [[[-120.98197, 36.98324], [-120.98213, 36.97644], [-120.98853, 36.97639], [-120.98853, 36.97728], [-120.98854, 36.97729], [-120.99081, 36.97728], [-120.99083, 36.97637], [-120.99972, 36.9763], [-120.99974, 36.96892], [-121.00106, 36.96895], [-121.00407, 36.96895], [-121.00406, 36.96511], [-121.00864, 36.96512], [-121.00866, 36.96896], [-121.0127, 36.96898], [-121.01274, 36.98375], [-121.0096, 36.98369], [-121.00985, 36.99054], [-120.99991, 36.99067], [-120.99095, 36.99055], [-120.98203, 36.9904], [-120.98197, 36.98324]]]} | Open Access 1 | 49077 | Unnamed Site - California Department of Water Resources | 33776 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | Merced 37 | 1286.898 | 0 | State Other or Unknown 104 | 4 | ||
4827 | 4827 | 4826 | {"type": "Polygon", "coordinates": [[[-118.74074, 34.07084], [-118.73649, 34.07068], [-118.73648, 34.06711], [-118.74072, 34.06713], [-118.74074, 34.07084]]]} | Open Access 1 | 48969 | Unnamed site - California Department of Parks and Recreation | 30566 | 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 | Los Angeles 6 | 39.075 | 0 | State Other or Unknown 104 | 4 | ||
7258 | 7258 | 7257 | {"type": "Polygon", "coordinates": [[[-120.42474, 37.3656], [-120.42449, 37.36582], [-120.42442, 37.36581], [-120.42305, 37.36682], [-120.42243, 37.36627], [-120.42297, 37.36589], [-120.42245, 37.36543], [-120.4224, 37.36528], [-120.42241, 37.36525], [-120.42279, 37.36529], [-120.42327, 37.36541], [-120.42393, 37.3657], [-120.42422, 37.36575], [-120.42447, 37.3657], [-120.42474, 37.3656]]]} | Open Access 1 | 48927 | Carol Tomlinson-Keasey Quad | 33646 | 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://www.ucmerced.edu/catcams | Merced 37 | 3.774 | Carol Tomlinson-Keasey Quad | None 598 | ||
7253 | 7253 | 7252 | {"type": "Polygon", "coordinates": [[[-120.42797, 37.3633], [-120.42769, 37.36342], [-120.42686, 37.36405], [-120.426, 37.36465], [-120.42585, 37.36455], [-120.42573, 37.36444], [-120.42547, 37.36426], [-120.42491, 37.36408], [-120.42487, 37.36386], [-120.42505, 37.3635], [-120.42556, 37.36309], [-120.42571, 37.36304], [-120.42593, 37.36306], [-120.42633, 37.36292], [-120.42657, 37.36301], [-120.42688, 37.36309], [-120.42717, 37.36303], [-120.42733, 37.36312], [-120.42768, 37.36302], [-120.42786, 37.363], [-120.42794, 37.36314], [-120.42797, 37.3633]]]} | Open Access 1 | 48924 | Kelley Grove | 33645 | 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 | Merced 37 | 7.209 | Kelley Grove | None 597 | |||
11736 | 11736 | 11735 | {"type": "Polygon", "coordinates": [[[-122.39127, 37.75408], [-122.39097, 37.75409], [-122.39088, 37.75351], [-122.39085, 37.75347], [-122.39082, 37.75346], [-122.39076, 37.75345], [-122.39076, 37.7531], [-122.39079, 37.7531], [-122.39096, 37.75335], [-122.39112, 37.75365], [-122.39126, 37.75395], [-122.39127, 37.75408]]]} | Open Access 1 | 48729 | Progress Park | 33456 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | https://www.sfparksalliance.org/our-work/park-partners/progress-park | San Francisco 13 | 0.521 | Progress Park | None 1038 | ||
15551 | 15551 | 15550 | {"type": "Polygon", "coordinates": [[[-117.19604, 33.42917], [-117.19589, 33.43216], [-117.18882, 33.43217], [-117.18246, 33.43226], [-117.18253, 33.4283], [-117.19167, 33.42815], [-117.19556, 33.42806], [-117.19537, 33.42845], [-117.19525, 33.42932], [-117.19604, 33.42917]]]} | Restricted Access 2 | 48641 | Santa Margarita Ecological Reserve | 33342 | 221 | San Diego State University 1047 | State 5 | State Agency 5 | http://www.sdsu.edu/ | Other State 5 | 221 | San Diego State University 378 | State 5 | State Agency 5 | https://fsp.sdsu.edu/about-us/ | San Diego 4 | 135.503 | Santa Margarita ER | 1962 | State Conservation Area 8 | 2 |
15550 | 15550 | 15549 | {"type": "Polygon", "coordinates": [[[-117.20642, 33.44665], [-117.20637, 33.45054], [-117.16741, 33.4645], [-117.16732, 33.46153], [-117.16295, 33.46136], [-117.16297, 33.46465], [-117.15938, 33.4648], [-117.15931, 33.46482], [-117.15856, 33.46486], [-117.15839, 33.46141], [-117.15396, 33.46161], [-117.15344, 33.4472], [-117.15378, 33.43266], [-117.15812, 33.43261], [-117.15812, 33.43978], [-117.16239, 33.43974], [-117.16251, 33.4434], [-117.17577, 33.44314], [-117.17574, 33.43904], [-117.17588, 33.43855], [-117.17623, 33.43757], [-117.17573, 33.43756], [-117.17571, 33.43595], [-117.17137, 33.43602], [-117.17143, 33.43963], [-117.16663, 33.43969], [-117.16672, 33.43254], [-117.17132, 33.43242], [-117.18444, 33.43223], [-117.18442, 33.43581], [-117.18876, 33.43575], [-117.18865, 33.4429], [-117.1931, 33.44294], [-117.19305, 33.44652], [-117.20642, 33.44665]], [[-117.16286, 33.45801], [-117.1583, 33.458], [-117.1584, 33.46141], [-117.16293, 33.46135], [-117.16286, 33.45801]], [[-117.18006, 33.44667], [-117.18005, 33.44666], [-117.1758, 33.44675], [-117.17585, 33.45044], [-117.18009, 33.45033], [-117.18006, 33.44667]]]} | Restricted Access 2 | 48639 | Santa Margarita Ecological Reserve | 33342 | 221 | San Diego State University 1047 | State 5 | State Agency 5 | http://www.sdsu.edu/ | Other State 5 | 221 | San Diego State University 378 | State 5 | State Agency 5 | https://fsp.sdsu.edu/about-us/ | Riverside 10 | 2513.083 | Santa Margarita ER | 1962 | State Conservation Area 8 | 2 |
10645 | 10645 | 10644 | {"type": "MultiPolygon", "coordinates": [[[[-122.40304, 38.85665], [-122.39731, 38.86263], [-122.39714, 38.86295], [-122.39704, 38.8611], [-122.39687, 38.85728], [-122.39454, 38.85725], [-122.39218, 38.85724], [-122.39215, 38.8538], [-122.39568, 38.85382], [-122.39686, 38.8538], [-122.39835, 38.85371], [-122.39876, 38.85408], [-122.39926, 38.85447], [-122.39956, 38.85456], [-122.39985, 38.85463], [-122.40005, 38.85475], [-122.40023, 38.85493], [-122.40058, 38.85545], [-122.40104, 38.85604], [-122.40121, 38.85615], [-122.40151, 38.85641], [-122.40304, 38.85665]], [[-122.39929, 38.85638], [-122.39687, 38.85633], [-122.39687, 38.85727], [-122.39929, 38.85729], [-122.39929, 38.85638]]], [[[-122.39926, 38.85396], [-122.39926, 38.85396], [-122.39886, 38.85369], [-122.39924, 38.85364], [-122.39926, 38.85396]]]]} | Restricted Access 2 | 48638 | McLaughlin Natural Reserve | 33195 | 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/mclaughlin-natural-reserve/ | Napa 11 | 102.485 | McLaughlin Natural Reserve | 0 | State Conservation Area 8 | 2 |
10608 | 10608 | 10607 | {"type": "Polygon", "coordinates": [[[-121.91003, 37.06168], [-121.90971, 37.06155], [-121.90985, 37.0612], [-121.9102, 37.06125], [-121.91025, 37.06129], [-121.91025, 37.06133], [-121.91003, 37.06168]]]} | Open Access 1 | 48632 | The Forest of Nisene Marks State Park | 1767 | 3074 | Save the Redwoods League 52 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savetheredwoods.org | Non Governmental Organization 10 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | https://www.parks.ca.gov/nisene | Santa Cruz 5 | 0.399 | The Forest of Nisene Marks SP | 1963 | State Park 15 | 4 |
4395 | 4395 | 4394 | {"type": "Polygon", "coordinates": [[[-118.60789, 37.41288], [-118.60787, 37.41414], [-118.60753, 37.41449], [-118.60753, 37.41492], [-118.60774, 37.41516], [-118.60339, 37.41611], [-118.59577, 37.41603], [-118.59579, 37.41253], [-118.59971, 37.41251], [-118.60257, 37.41244], [-118.60451, 37.41246], [-118.60454, 37.41298], [-118.60497, 37.413], [-118.60497, 37.41273], [-118.60737, 37.41274], [-118.60738, 37.41284], [-118.60789, 37.41288]]]} | No Public Access 3 | 48600 | Round Valley Wildlife Area | 33312 | 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 | Inyo 43 | 97.218 | Round Valley Wildlife Area | 1993 | 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 |
15054 | 15054 | 15053 | {"type": "Polygon", "coordinates": [[[-115.21541, 34.6224], [-115.21541, 34.62603], [-115.21449, 34.62605], [-115.21449, 34.62784], [-115.2154, 34.62784], [-115.21539, 34.62965], [-115.2066, 34.62967], [-115.20653, 34.62435], [-115.20242, 34.62437], [-115.20241, 34.62618], [-115.19801, 34.62619], [-115.19803, 34.62256], [-115.20241, 34.62256], [-115.20243, 34.61893], [-115.20462, 34.61892], [-115.20462, 34.61711], [-115.20682, 34.61711], [-115.20682, 34.62255], [-115.21541, 34.6224]]]} | Restricted Access 2 | 48492 | Old Women Mountains | 33203 | 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/sweeney-granite-mountains-desert-center/ | San Bernardino 22 | 264.569 | Old Women Mtns. | None 1302 | ||
8480 | 8480 | 8479 | {"type": "MultiPolygon", "coordinates": [[[[-114.90774, 34.85644], [-114.90461, 34.85604], [-114.90346, 34.85573], [-114.90259, 34.85583], [-114.90153, 34.85572], [-114.90255, 34.85504], [-114.90224, 34.85472], [-114.90085, 34.85565], [-114.89158, 34.85468], [-114.89085, 34.85463], [-114.89015, 34.85461], [-114.89013, 34.85125], [-114.90774, 34.85117], [-114.90774, 34.85644]]], [[[-114.90778, 34.86591], [-114.89037, 34.86587], [-114.89049, 34.85865], [-114.89049, 34.85571], [-114.89099, 34.85574], [-114.89166, 34.85579], [-114.90775, 34.85743], [-114.90778, 34.86591]]]]} | Restricted Access 2 | 48491 | Sacramento Mountains Reserve | 33202 | 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/sweeney-granite-mountains-desert-center/ | San Bernardino 22 | 590.848 | Sacramento Mtns. Reserve | 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 | ||
8389 | 8389 | 8388 | {"type": "Polygon", "coordinates": [[[-120.07168, 34.71997], [-120.07116, 34.72294], [-120.07044, 34.72724], [-120.07061, 34.72952], [-120.06744, 34.73304], [-120.06454, 34.73454], [-120.06403, 34.7352], [-120.0639, 34.73638], [-120.06338, 34.73641], [-120.06128, 34.73743], [-120.06043, 34.73832], [-120.05876, 34.73977], [-120.05918, 34.74019], [-120.05876, 34.74069], [-120.05754, 34.74074], [-120.05767, 34.74133], [-120.05741, 34.74182], [-120.05694, 34.74215], [-120.05579, 34.74184], [-120.05479, 34.7421], [-120.05437, 34.74209], [-120.05409, 34.74195], [-120.05377, 34.74224], [-120.05311, 34.74221], [-120.05248, 34.74258], [-120.05181, 34.7423], [-120.05084, 34.74297], [-120.05063, 34.74247], [-120.04993, 34.74236], [-120.0495, 34.74214], [-120.04882, 34.74224], [-120.04804, 34.74193], [-120.04532, 34.7416], [-120.04488, 34.74191], [-120.04466, 34.74248], [-120.04347, 34.74275], [-120.04233, 34.74399], [-120.04122, 34.74374], [-120.04041, 34.74342], [-120.03734, 34.74286], [-120.03595, 34.74346], [-120.03475, 34.74333], [-120.0338, 34.74314], [-120.03333, 34.74318], [-120.0331, 34.74238], [-120.03203, 34.74303], [-120.0309, 34.7427], [-120.02981, 34.74277], [-120.02912, 34.74274], [-120.02895, 34.7428], [-120.01175, 34.72944], [-120.01243, 34.72814], [-120.01249, 34.72754], [-120.01815, 34.72315], [-120.01795, 34.72198], [-120.0186, 34.72167], [-120.02488, 34.72152], [-120.02728, 34.7197], [-120.02711, 34.71876], [-120.02707, 34.70455], [-120.02698, 34.692], [-120.0254, 34.69064], [-120.02565, 34.68607], [-120.02688, 34.68152], [-120.02766, 34.67966], [-120.02853, 34.67874], [-120.03882, 34.67878], [-120.05409, 34.67899], [-120.05409, 34.67964], [-120.05446, 34.68158], [-120.05421, 34.68614], [-120.05537, 34.68892], [-120.05506, 34.69087], [-120.05508, 34.69207], [-120.05526, 34.69616], [-120.05538, 34.69839], [-120.0554, 34.69948], [-120.0555, 34.70149], [-120.0556, 34.70419], [-120.05644, 34.70593], [-120.05739, 34.70763], [-120.05751, 34.70876], [-120.0577, 34.7094], [-120.05793, 34.70993], [-120.05914, 34.71214], [-120.06012, 34.7146], [-120.06087, 34.71465], [-120.06182, 34.71433], [-120.06438, 34.71557], [-120.06802, 34.71707], [-120.07168, 34.71997]]]} | Restricted Access 2 | 48485 | Sedgwick Reserve | 33196 | 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/sedgwick-reserve/ | Santa Barbara 7 | 5875.25 | Sedgwick Reserve | 0 | 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 |
8385 | 8385 | 8384 | {"type": "MultiPolygon", "coordinates": [[[[-122.15222, 38.50001], [-122.15198, 38.50368], [-122.13865, 38.50359], [-122.13859, 38.50726], [-122.1342, 38.50724], [-122.1342, 38.50355], [-122.13455, 38.49639], [-122.14288, 38.49632], [-122.14994, 38.49631], [-122.14963, 38.50002], [-122.15222, 38.50001]]], [[[-122.15956, 38.50659], [-122.1582, 38.51125], [-122.15616, 38.5108], [-122.15612, 38.5114], [-122.15604, 38.51137], [-122.15195, 38.51111], [-122.15219, 38.50368], [-122.15659, 38.50361], [-122.15654, 38.50303], [-122.15804, 38.50274], [-122.15956, 38.50659]]]]} | Restricted Access 2 | 48480 | Quail Ridge Reserve | 33192 | 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 | 217 | University of California 51 | State 5 | State Agency 5 | https://ucnrs.org/reserves/quail-ridge-reserve/ | Napa 11 | 453.877 | Quail Ridge Reserve | 0 | State Conservation Area 8 | 2 |
8373 | 8373 | 8372 | {"type": "Polygon", "coordinates": [[[-117.2527, 32.88267], [-117.25219, 32.88308], [-117.25093, 32.88102], [-117.25092, 32.8805], [-117.25072, 32.87991], [-117.2507, 32.8786], [-117.24819, 32.87836], [-117.2474, 32.87945], [-117.2474, 32.88002], [-117.2469, 32.88002], [-117.24693, 32.87969], [-117.2471, 32.87867], [-117.24607, 32.8791], [-117.24514, 32.87867], [-117.24523, 32.87852], [-117.2461, 32.87869], [-117.24655, 32.87781], [-117.24682, 32.87579], [-117.24672, 32.87495], [-117.24681, 32.87494], [-117.24723, 32.87426], [-117.2517, 32.8743], [-117.25132, 32.87552], [-117.2513, 32.87633], [-117.25175, 32.87822], [-117.25186, 32.8795], [-117.25195, 32.88019], [-117.25209, 32.88089], [-117.25248, 32.88219], [-117.2527, 32.88267]]]} | Restricted Access 2 | 48479 | Scripps Coastal Reserve | 33194 | 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/scripps-coastal-reserve/ | San Diego 4 | 67.619 | Scripps Coastal Reserve | 0 | State Conservation Area 8 | 2 |
8371 | 8371 | 8370 | {"type": "MultiPolygon", "coordinates": [[[[-122.15748, 38.50015], [-122.15662, 38.50017], [-122.15657, 38.49998], [-122.14963, 38.50003], [-122.14993, 38.49631], [-122.14288, 38.49632], [-122.13455, 38.49639], [-122.13487, 38.48919], [-122.14395, 38.4891], [-122.14339, 38.47882], [-122.15217, 38.47891], [-122.15301, 38.48902], [-122.15575, 38.489], [-122.1557, 38.48949], [-122.1565, 38.49304], [-122.15356, 38.49362], [-122.15265, 38.49472], [-122.15226, 38.49526], [-122.15259, 38.49544], [-122.15685, 38.49725], [-122.15748, 38.50015]]], [[[-122.13859, 38.50726], [-122.13854, 38.50977], [-122.13419, 38.50985], [-122.13303, 38.5099], [-122.13297, 38.51093], [-122.13174, 38.511], [-122.13168, 38.50969], [-122.12991, 38.50968], [-122.12984, 38.50811], [-122.12537, 38.50809], [-122.12531, 38.50369], [-122.1342, 38.50355], [-122.1342, 38.50724], [-122.13859, 38.50726]]], [[[-122.15778, 38.51362], [-122.15635, 38.51826], [-122.15607, 38.51897], [-122.1527, 38.5222], [-122.15104, 38.52161], [-122.14946, 38.52362], [-122.1502, 38.52413], [-122.14706, 38.52739], [-122.14703, 38.5291], [-122.14468, 38.52906], [-122.14475, 38.52426], [-122.14297, 38.51881], [-122.14261, 38.51823], [-122.1405, 38.51552], [-122.13719, 38.51439], [-122.13419, 38.51416], [-122.13417, 38.51231], [-122.13848, 38.51219], [-122.1385, 38.5146], [-122.15601, 38.51461], [-122.15608, 38.51253], [-122.15778, 38.51362]]]]} | Restricted Access 2 | 48478 | Quail Ridge Reserve | 33192 | 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/quail-ridge-reserve/ | Napa 11 | 1109.844 | Quail Ridge Reserve | 0 | State Conservation Area 8 | 2 |
8370 | 8370 | 8369 | {"type": "MultiPolygon", "coordinates": [[[[-120.42002, 37.37524], [-120.41992, 37.3795], [-120.41983, 37.38494], [-120.41625, 37.385], [-120.41623, 37.39018], [-120.41373, 37.39018], [-120.39562, 37.39007], [-120.39556, 37.40447], [-120.39315, 37.40448], [-120.39556, 37.40457], [-120.39543, 37.41772], [-120.38974, 37.41904], [-120.38701, 37.41965], [-120.3837, 37.42025], [-120.38097, 37.42078], [-120.37846, 37.42131], [-120.37718, 37.42142], [-120.37044, 37.42207], [-120.36706, 37.4239], [-120.35097, 37.40445], [-120.35124, 37.38997], [-120.35761, 37.38306], [-120.36048, 37.38003], [-120.36471, 37.3754], [-120.3782, 37.36093], [-120.39595, 37.36105], [-120.39596, 37.35653], [-120.39623, 37.35667], [-120.3965, 37.35679], [-120.39673, 37.35684], [-120.39759, 37.35683], [-120.39798, 37.35671], [-120.39825, 37.35659], [-120.39857, 37.35628], [-120.39895, 37.35596], [-120.39937, 37.35573], [-120.39985, 37.35569], [-120.40136, 37.35636], [-120.40201, 37.3567], [-120.40275, 37.35696], [-120.40408, 37.35734], [-120.40476, 37.35756], [-120.40478, 37.35755], [-120.40478, 37.36102], [-120.40743, 37.36363], [-120.40741, 37.37544], [-120.40743, 37.37618], [-120.41232, 37.37618], [-120.41482, 37.37475], [-120.42002, 37.37524]], [[-120.37764, 37.3754], [-120.37763, 37.37539], [-120.37636, 37.3754], [-120.37763, 37.37541], [-120.37764, 37.3754]]], [[[-120.39543, 37.41789], [-120.39542, 37.41908], [-120.39049, 37.41904], [-120.39228, 37.41862], [-120.39543, 37.41789]]]]} | Restricted Access 2 | 48477 | Merced Vernal Pools and Grassland Reserve | 33191 | 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/merced-vernal-pools-and-grassland-reserve/ | Merced 37 | 6559.831 | Merced Vernal Pools and Grassland 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]);