units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
381 rows where DES_TP = 8 sorted by UNIT_ID descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID, MNG_AG_LEV
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_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
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 |
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 |
8348 | 8348 | 8347 | {"type": "MultiPolygon", "coordinates": [[[[-122.41094, 38.85388], [-122.4109, 38.86064], [-122.41064, 38.86043], [-122.41045, 38.86031], [-122.40971, 38.85998], [-122.40952, 38.85988], [-122.40712, 38.85804], [-122.40687, 38.85789], [-122.40358, 38.85648], [-122.40329, 38.85638], [-122.40383, 38.85581], [-122.40383, 38.8558], [-122.40339, 38.85564], [-122.40303, 38.85564], [-122.40277, 38.85567], [-122.40247, 38.85568], [-122.402, 38.85586], [-122.40174, 38.85591], [-122.4014, 38.85577], [-122.40121, 38.85547], [-122.40099, 38.85506], [-122.40086, 38.85472], [-122.40053, 38.85448], [-122.40009, 38.85431], [-122.39986, 38.85425], [-122.39967, 38.85404], [-122.39955, 38.85379], [-122.41094, 38.85388]]], [[[-122.41361, 38.86493], [-122.4059, 38.8649], [-122.40599, 38.86091], [-122.40127, 38.86083], [-122.40125, 38.86271], [-122.39731, 38.86263], [-122.4032, 38.85648], [-122.40351, 38.85657], [-122.40679, 38.85797], [-122.40702, 38.85812], [-122.40943, 38.85996], [-122.40964, 38.86008], [-122.41038, 38.86041], [-122.41067, 38.8606], [-122.4109, 38.86083], [-122.4109, 38.86098], [-122.411, 38.86098], [-122.41104, 38.86105], [-122.41215, 38.86347], [-122.41234, 38.86382], [-122.4126, 38.86414], [-122.4128, 38.86433], [-122.41303, 38.86451], [-122.41361, 38.86493]]], [[[-122.42422, 38.87573], [-122.42408, 38.87585], [-122.41522, 38.87548], [-122.41522, 38.87045], [-122.4174, 38.87051], [-122.41776, 38.87075], [-122.41802, 38.87089], [-122.42, 38.87169], [-122.42023, 38.87181], [-122.42044, 38.87195], [-122.42062, 38.87211], [-122.42078, 38.87229], [-122.42091, 38.87248], [-122.421, 38.87268], [-122.4216, 38.87421], [-122.42178, 38.87453], [-122.42203, 38.87482], [-122.42235, 38.87507], [-122.42259, 38.87521], [-122.42284, 38.87532], [-122.42311, 38.87541], [-122.42422, 38.87573]]], [[[-122.44673, 38.8798], [-122.44346, 38.87981], [-122.44345, 38.87995], [-122.44277, 38.87981], [-122.43966, 38.8804], [-122.43894, 38.88033], [-122.43696, 38.87922], [-122.43486, 38.87902], [-122.43409, 38.87868], [-122.43283, 38.8773], [-122.43267, 38.87716], [-122.43248, 38.87704], [-122.43216, 38.8769], [-122.43193, 38.87684], [-122.4317, 38.8768], [-122.43146, 38.87678], [-122.43125, 38.87679], [-122.43105, 38.87682], [-122.42927, 38.87726], [-122.42901, 38.87732], [-122.4288, 38.87734], [-122.42857, 38.87735], [-122.42823, 38.87731], [-122.42801, 38.87725], [-122.42771, 38.87711], [-122.4265, 38.87633], [-122.42616, 38.87617], [-122.42316, 38.87531], [-122.42289, 38.87522], [-122.42264, 38.8751], [-122.42241, 38.87497], [-122.42222, 38.87482], [-122.42204, 38.87465], [-122.42183, 38.87437], [-122.42173, 38.87417], [-122.42109, 38.87254], [-122.42092, 38.87226], [-122.42069, 38.872], [-122.4204, 38.87177], [-122.42007, 38.87159], [-122.41823, 38.87085], [-122.41796, 38.87073], [-122.41771, 38.87058], [-122.41748, 38.87042], [-122.41727, 38.87024], [-122.4171, 38.87004], [-122.41688, 38.86972], [-122.41623, 38.86846], [-122.41606, 38.86816], [-122.41431, 38.86544], [-122.4141, 38.86519], [-122.41381, 38.86493], [-122.41291, 38.86426], [-122.41262, 38.86397], [-122.41247, 38.86376], [-122.41228, 38.86343], [-122.41116, 38.86099], [-122.41549, 38.86112], [-122.41551, 38.85757], [-122.42008, 38.85771], [-122.42945, 38.85792], [-122.42944, 38.87069], [-122.43174, 38.87069], [-122.4321, 38.87105], [-122.43243, 38.87134], [-122.43274, 38.87195], [-122.43308, 38.87236], [-122.4334, 38.87257], [-122.43375, 38.87276], [-122.43413, 38.87264], [-122.43498, 38.87277], [-122.4339, 38.87337], [-122.4331, 38.87389], [-122.4331, 38.87391], [-122.43337, 38.87416], [-122.43348, 38.87422], [-122.4335, 38.8744], [-122.43748, 38.87427], [-122.43935, 38.87519], [-122.44673, 38.8798]]]]} | Restricted Access 2 | 48476 | 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/ | Lake 40 | 1035.449 | McLaughlin Natural Reserve | 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 |
8345 | 8345 | 8344 | {"type": "Polygon", "coordinates": [[[-123.76615, 39.28535], [-123.76613, 39.28619], [-123.76623, 39.28837], [-123.76622, 39.29088], [-123.76353, 39.28996], [-123.76354, 39.28536], [-123.76125, 39.28534], [-123.76132, 39.28339], [-123.76129, 39.28146], [-123.7637, 39.2815], [-123.76605, 39.28153], [-123.76615, 39.28535]]]} | Restricted Access 2 | 48474 | Hans Jenny Pygmy Forest Reserve | 33185 | 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/hans-jenny-pygmy-forest-reserve/ | Mendocino 24 | 75.697 | Hans Jenny Pygmy Forest Reserve | 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 |
7756 | 7756 | 7755 | {"type": "Polygon", "coordinates": [[[-117.04819, 33.46996], [-117.04601, 33.46999], [-117.04383, 33.47], [-117.04258, 33.47004], [-117.03519, 33.47001], [-117.03512, 33.46655], [-117.03512, 33.46296], [-117.04814, 33.46288], [-117.04819, 33.46996]], [[-117.04266, 33.46696], [-117.04265, 33.46697], [-117.04274, 33.46733], [-117.04314, 33.46728], [-117.04307, 33.46691], [-117.04266, 33.46696]]]} | Restricted Access 2 | 48472 | Emerson Oaks Reserve | 33183 | 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/emerson-oaks-reserve/ | Riverside 10 | 234.781 | Emerson Oaks Reserve | 0 | State Conservation Area 8 | 2 |
7602 | 7602 | 7601 | {"type": "Polygon", "coordinates": [[[-117.09082, 32.89483], [-117.08881, 32.89783], [-117.0865, 32.89848], [-117.08509, 32.89881], [-117.08278, 32.89949], [-117.08164, 32.89815], [-117.07952, 32.89829], [-117.07915, 32.89934], [-117.08029, 32.90022], [-117.07721, 32.90112], [-117.07883, 32.90284], [-117.07721, 32.90339], [-117.07527, 32.90178], [-117.07426, 32.90045], [-117.07239, 32.89842], [-117.07523, 32.89837], [-117.07522, 32.89663], [-117.08409, 32.89651], [-117.08416, 32.89467], [-117.08629, 32.8947], [-117.08637, 32.89287], [-117.08828, 32.89286], [-117.0883, 32.89111], [-117.09079, 32.89112], [-117.09082, 32.89483]]]} | Restricted Access 2 | 48471 | Elliott Chaparral Reserve | 33182 | 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/elliott-chaparral-reserve/ | San Diego 4 | 183.016 | Elliott Chaparral Reserve | 0 | State Conservation Area 8 | 2 |
11529 | 11529 | 11528 | {"type": "MultiPolygon", "coordinates": [[[[-118.64078, 37.50286], [-118.6391, 37.50286], [-118.63785, 37.50235], [-118.637, 37.50228], [-118.63677, 37.50201], [-118.63603, 37.50216], [-118.63607, 37.49933], [-118.63603, 37.49932], [-118.63601, 37.50215], [-118.63398, 37.50327], [-118.63386, 37.50338], [-118.63381, 37.50347], [-118.6338, 37.50357], [-118.63384, 37.50371], [-118.63394, 37.50383], [-118.63397, 37.50392], [-118.63398, 37.50453], [-118.63395, 37.50469], [-118.63387, 37.50489], [-118.63383, 37.505], [-118.63382, 37.50545], [-118.63376, 37.50545], [-118.63374, 37.49934], [-118.63378, 37.49576], [-118.63149, 37.49576], [-118.6315, 37.49396], [-118.6338, 37.49396], [-118.63383, 37.49216], [-118.64077, 37.49217], [-118.64077, 37.49928], [-118.64076, 37.50283], [-118.64078, 37.50286]]], [[[-118.63498, 37.50563], [-118.63496, 37.50642], [-118.63375, 37.50642], [-118.63375, 37.50562], [-118.63498, 37.50563]]], [[[-118.636, 37.50234], [-118.63598, 37.50626], [-118.63517, 37.50626], [-118.63517, 37.50546], [-118.63403, 37.50545], [-118.63404, 37.50501], [-118.63417, 37.50467], [-118.63419, 37.5045], [-118.63418, 37.50387], [-118.63414, 37.50378], [-118.63403, 37.50364], [-118.63401, 37.50354], [-118.63403, 37.50347], [-118.6341, 37.50341], [-118.636, 37.50234]]]]} | No Public Access 3 | 48236 | Round Valley Wildlife Area | 33312 | 212 | California Wildlife Conservation Board 766 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Mono 32 | 203.625 | Round Valley Wildlife Area | 1993 | State Conservation Area 8 | 2 | |
11524 | 11524 | 11523 | {"type": "MultiPolygon", "coordinates": [[[[-121.80139, 36.83624], [-121.80041, 36.83633], [-121.80027, 36.83636], [-121.80012, 36.83642], [-121.79995, 36.83655], [-121.79971, 36.83688], [-121.7995, 36.83724], [-121.79925, 36.83777], [-121.79919, 36.83784], [-121.7991, 36.83789], [-121.799, 36.83791], [-121.7982, 36.83791], [-121.79819, 36.83709], [-121.79848, 36.83654], [-121.79868, 36.83586], [-121.79866, 36.83518], [-121.79844, 36.8349], [-121.79817, 36.83491], [-121.79813, 36.83074], [-121.79879, 36.83073], [-121.79899, 36.83093], [-121.79913, 36.83112], [-121.80064, 36.83479], [-121.80093, 36.83538], [-121.80139, 36.83624]]], [[[-121.80217, 36.83804], [-121.80217, 36.83804], [-121.79919, 36.83804], [-121.7993, 36.83798], [-121.7994, 36.83788], [-121.79964, 36.83739], [-121.7998, 36.8371], [-121.80005, 36.83671], [-121.80016, 36.8366], [-121.80029, 36.83654], [-121.80043, 36.8365], [-121.80148, 36.83639], [-121.8017, 36.83677], [-121.80189, 36.83717], [-121.80204, 36.83758], [-121.80217, 36.83804]]]]} | No Public Access 3 | 48235 | McClusky Slough | 32792 | 212 | California Wildlife Conservation Board 766 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Monterey 14 | 38.897 | McClusky Slough | 1996 | 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]);