units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
381 rows where DES_TP = 8 sorted by MNG_AGENCY descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_WEB, LAYER, 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_TYP 7 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13158 | 13158 | 13157 | {"type": "Polygon", "coordinates": [[[-122.52495, 38.06971], [-122.52293, 38.06978], [-122.52096, 38.07133], [-122.51104, 38.06343], [-122.5006, 38.06098], [-122.49657, 38.06008], [-122.49222, 38.05907], [-122.49669, 38.05127], [-122.498, 38.04907], [-122.49841, 38.04941], [-122.49892, 38.04861], [-122.49891, 38.04859], [-122.49831, 38.04855], [-122.49847, 38.04828], [-122.49848, 38.04785], [-122.50668, 38.04784], [-122.50668, 38.04742], [-122.50731, 38.04741], [-122.50732, 38.0474], [-122.50668, 38.04689], [-122.50851, 38.04693], [-122.50972, 38.04814], [-122.51013, 38.04801], [-122.51102, 38.04913], [-122.51148, 38.05001], [-122.51052, 38.05012], [-122.51044, 38.05017], [-122.5105, 38.05049], [-122.50943, 38.05062], [-122.50805, 38.05113], [-122.50669, 38.0522], [-122.50669, 38.05222], [-122.5098, 38.05469], [-122.51448, 38.06081], [-122.51476, 38.06197], [-122.51638, 38.06325], [-122.51678, 38.06343], [-122.51743, 38.06392], [-122.51755, 38.06389], [-122.51761, 38.06395], [-122.5176, 38.06404], [-122.51799, 38.06436], [-122.51829, 38.06465], [-122.51843, 38.0647], [-122.51859, 38.06467], [-122.52495, 38.06971]]]} | No Public Access 3 | 35102 | Hamilton Wetlands | 19625 | 200 | California State Coastal Conservancy 859 | State 5 | State Agency 5 | http://www.scc.ca.gov/ | Other State 5 | 200 | California State Coastal Conservancy 837 | State 5 | State Agency 5 | Marin 23 | 632.955 | Hamilton Wetlands | 0 | State Conservation Area 8 | 2 | |
9250 | 9250 | 9249 | {"type": "MultiPolygon", "coordinates": [[[[-116.44947, 33.88499], [-116.44723, 33.88499], [-116.44529, 33.88496], [-116.4457, 33.88489], [-116.44596, 33.88482], [-116.44707, 33.88443], [-116.44732, 33.88435], [-116.44773, 33.88427], [-116.44824, 33.8842], [-116.44946, 33.88418], [-116.44947, 33.88499]]], [[[-116.46255, 33.8886], [-116.46251, 33.89218], [-116.45813, 33.89218], [-116.45819, 33.88861], [-116.46255, 33.8886]]], [[[-116.47988, 33.89224], [-116.47985, 33.89496], [-116.47554, 33.89498], [-116.47555, 33.89223], [-116.47988, 33.89224]]]]} | No Public Access 3 | 15404 | 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 | 75.092 | Edom Hill-Willow Hole Preserve | 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 | |
11282 | 11282 | 11281 | {"type": "Polygon", "coordinates": [[[-121.41367, 38.23999], [-121.41393, 38.24073], [-121.41403, 38.24115], [-121.41401, 38.24182], [-121.41387, 38.2422], [-121.41372, 38.24252], [-121.41349, 38.24273], [-121.4134, 38.24305], [-121.41338, 38.24337], [-121.41318, 38.24429], [-121.41301, 38.24479], [-121.41253, 38.2454], [-121.41205, 38.2458], [-121.41183, 38.24594], [-121.41149, 38.2461], [-121.41107, 38.24659], [-121.41077, 38.24686], [-121.41051, 38.24724], [-121.41014, 38.24789], [-121.40986, 38.24824], [-121.4098, 38.24835], [-121.40967, 38.24845], [-121.40943, 38.24856], [-121.40929, 38.24867], [-121.40924, 38.24878], [-121.40917, 38.24913], [-121.40828, 38.25009], [-121.40789, 38.25041], [-121.40766, 38.25056], [-121.40722, 38.25103], [-121.40677, 38.25159], [-121.40616, 38.25214], [-121.40585, 38.25266], [-121.40583, 38.25277], [-121.40585, 38.25291], [-121.40612, 38.25307], [-121.40671, 38.25329], [-121.4067, 38.25337], [-121.4064, 38.25349], [-121.40605, 38.25368], [-121.40588, 38.2538], [-121.4057, 38.25401], [-121.40567, 38.25411], [-121.40595, 38.25412], [-121.40522, 38.25423], [-121.40433, 38.25417], [-121.4041, 38.25411], [-121.40216, 38.2541], [-121.40127, 38.25383], [-121.40146, 38.25112], [-121.40144, 38.25103], [-121.40136, 38.25096], [-121.40126, 38.25093], [-121.39906, 38.25089], [-121.39863, 38.25068], [-121.3983, 38.25048], [-121.39765, 38.24996], [-121.39734, 38.24974], [-121.39617, 38.24779], [-121.39663, 38.24661], [-121.39638, 38.24624], [-121.39618, 38.246], [-121.39563, 38.24543], [-121.39533, 38.24509], [-121.39504, 38.24486], [-121.39474, 38.24467], [-121.39269, 38.24467], [-121.39251, 38.2447], [-121.39178, 38.24494], [-121.39059, 38.24485], [-121.39026, 38.24475], [-121.38955, 38.24426], [-121.38627, 38.24134], [-121.38819, 38.24132], [-121.3925, 38.24131], [-121.39949, 38.24126], [-121.39985, 38.24123], [-121.40024, 38.24113], [-121.40047, 38.24103], [-121.40227, 38.24019], [-121.40258, 38.24009], [-121.40298, 38.24003], [-121.41367, 38.23999]]]} | No Public Access 3 | 21821 | Grizzly Slough | 30567 | 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 | Sacramento 41 | 487.047 | Grizzly Slough | 0 | State Conservation Area 8 | 2 | |
13162 | 13162 | 13161 | {"type": "Polygon", "coordinates": [[[-121.69523, 37.99864], [-121.69516, 37.99875], [-121.69492, 37.99898], [-121.69489, 37.99899], [-121.69479, 37.99908], [-121.6946, 37.99933], [-121.69451, 37.99949], [-121.69412, 38.00034], [-121.69357, 38.00137], [-121.69349, 38.00155], [-121.69341, 38.00178], [-121.69332, 38.00199], [-121.69256, 38.00334], [-121.69235, 38.00375], [-121.69214, 38.00408], [-121.69172, 38.00498], [-121.69157, 38.0052], [-121.6915, 38.00533], [-121.69134, 38.00615], [-121.6913, 38.00678], [-121.69131, 38.00698], [-121.69117, 38.00802], [-121.69114, 38.00835], [-121.69102, 38.00912], [-121.691, 38.00933], [-121.69101, 38.01008], [-121.69106, 38.01024], [-121.69104, 38.01035], [-121.69121, 38.01057], [-121.69102, 38.01082], [-121.69092, 38.01111], [-121.6909, 38.01129], [-121.69083, 38.01153], [-121.69057, 38.01169], [-121.69041, 38.01184], [-121.69042, 38.01202], [-121.69037, 38.01241], [-121.68974, 38.01329], [-121.68931, 38.01338], [-121.68885, 38.01329], [-121.68808, 38.0132], [-121.68616, 38.01353], [-121.68476, 38.01351], [-121.68233, 38.012], [-121.6797, 38.01151], [-121.6779, 38.01073], [-121.67466, 38.01191], [-121.67439, 38.01196], [-121.67438, 38.01228], [-121.66372, 38.01239], [-121.66372, 38.01234], [-121.66361, 38.01228], [-121.66332, 38.01219], [-121.66305, 38.01222], [-121.66269, 38.0124], [-121.66098, 38.01241], [-121.66075, 38.01191], [-121.66066, 38.01164], [-121.6605, 38.0114], [-121.65932, 38.0089], [-121.65922, 38.00863], [-121.65914, 38.00835], [-121.65911, 38.00795], [-121.65919, 37.99845], [-121.66012, 37.99845], [-121.66014, 37.99791], [-121.66013, 37.9979], [-121.6592, 37.9979], [-121.65925, 37.99124], [-121.66028, 37.99208], [-121.66047, 37.99221], [-121.66068, 37.99233], [-121.6609, 37.99243], [-121.66357, 37.99352], [-121.66415, 37.99377], [-121.67363, 37.99756], [-121.67366, 37.99754], [-121.67405, 37.99767], [-121.67431, 37.99772], [-121.67459, 37.99775], [-121.6759, 37.99776], [-121.67585, 37.99946], [-121.67687, 38.0005], [-121.67805, 38.00051], [-121.67798, 38.00067], [-121.67805, 38.00087], [-121.67806, 38.00179], [-121.67966, 38.00179], [-121.67966, 38.00051], [-121.68253, 38.00051], [-121.68379, 38.0001], [-121.68381, 37.99788], [-121.68397, 37.99792], [-121.6859, 37.99855], [-121.6862, 37.99862], [-121.68641, 37.99865], [-121.68662, 37.99866], [-121.69523, 37.99864]]]} | No Public Access 3 | 35110 | Dutch Slough | 18320 | 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 | Contra Costa 12 | 1185.171 | Dutch Slough | 0 | State Conservation Area 8 | 2 | |
1551 | 1551 | 1550 | {"type": "Polygon", "coordinates": [[[-117.15937, 33.4648], [-117.15693, 33.46596], [-117.15546, 33.46627], [-117.1551, 33.46876], [-117.15582, 33.4699], [-117.15547, 33.4701], [-117.15359, 33.47159], [-117.15293, 33.47188], [-117.14835, 33.47303], [-117.14752, 33.4732], [-117.14553, 33.47346], [-117.1454, 33.4735], [-117.1452, 33.47361], [-117.14441, 33.47424], [-117.14428, 33.4744], [-117.14423, 33.47451], [-117.14422, 33.47465], [-117.14428, 33.47512], [-117.14445, 33.47524], [-117.14434, 33.47534], [-117.14243, 33.47398], [-117.14117, 33.47457], [-117.1392, 33.47439], [-117.13887, 33.4735], [-117.14494, 33.46886], [-117.14521, 33.46914], [-117.14523, 33.46914], [-117.14519, 33.46582], [-117.15408, 33.46502], [-117.15937, 33.4648]]]} | No Public Access 3 | 11546 | Santa Margarita Ecological Reserve | 33343 | 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 | 221 | San Diego State University 378 | State 5 | State Agency 5 | https://fsp.sdsu.edu/about-us/ | Riverside 10 | 243.178 | Santa Margarita ER | 1962 | State Conservation Area 8 | 2 |
2398 | 2398 | 2397 | {"type": "MultiPolygon", "coordinates": [[[[-117.21972, 33.42999], [-117.21971, 33.43008], [-117.21941, 33.43087], [-117.21888, 33.43101], [-117.21852, 33.43096], [-117.21805, 33.43108], [-117.21795, 33.43113], [-117.21774, 33.43153], [-117.21722, 33.43152], [-117.21407, 33.43154], [-117.21414, 33.42781], [-117.21857, 33.4278], [-117.21851, 33.42935], [-117.21925, 33.42978], [-117.21965, 33.42988], [-117.2197, 33.42993], [-117.21972, 33.42999]]], [[[-117.20291, 33.42795], [-117.20281, 33.43006], [-117.19914, 33.43009], [-117.199, 33.43159], [-117.19592, 33.4316], [-117.19604, 33.42917], [-117.19685, 33.429], [-117.19721, 33.42851], [-117.19932, 33.42801], [-117.20077, 33.42797], [-117.20291, 33.42795]]]]} | Restricted Access 2 | 7255 | Santa Margarita Ecological Reserve | 33342 | 3065 | San Diego State University Foundation 524 | Non Profit 6 | Non Profit - Other 22 | http://www.foundation.sdsu.edu/index.html | Non Governmental Organization 10 | 221 | San Diego State University 378 | State 5 | State Agency 5 | https://fsp.sdsu.edu/about-us/ | San Diego 4 | 88.83 | Santa Margarita ER | 1962 | State Conservation Area 8 | 2 |
5847 | 5847 | 5846 | {"type": "MultiPolygon", "coordinates": [[[[-117.16733, 33.46176], [-117.16524, 33.46316], [-117.16477, 33.46349], [-117.16432, 33.46385], [-117.1639, 33.46423], [-117.16319, 33.46492], [-117.16317, 33.46482], [-117.16297, 33.46465], [-117.16293, 33.46136], [-117.1584, 33.46141], [-117.1583, 33.458], [-117.16286, 33.458], [-117.16294, 33.46135], [-117.16732, 33.46153], [-117.16733, 33.46176]]], [[[-117.17572, 33.43595], [-117.17572, 33.43673], [-117.17535, 33.43751], [-117.17514, 33.43806], [-117.17463, 33.43969], [-117.17358, 33.44319], [-117.1625, 33.4434], [-117.16239, 33.43974], [-117.17142, 33.43963], [-117.17137, 33.43602], [-117.17572, 33.43595]]], [[[-117.17577, 33.44315], [-117.17438, 33.44318], [-117.17551, 33.43984], [-117.17574, 33.43904], [-117.17577, 33.44315]]], [[[-117.1801, 33.45033], [-117.17584, 33.45044], [-117.1758, 33.44675], [-117.18006, 33.44666], [-117.1801, 33.45033]]], [[[-117.20651, 33.43216], [-117.20649, 33.43578], [-117.19766, 33.43577], [-117.1976, 33.43937], [-117.19315, 33.43935], [-117.1932, 33.43576], [-117.18876, 33.43575], [-117.18441, 33.43581], [-117.18444, 33.43223], [-117.18882, 33.43217], [-117.20651, 33.43216]]]]} | Restricted Access 2 | 21992 | Santa Margarita Ecological Reserve | 33342 | 3065 | San Diego State University Foundation 524 | Non Profit 6 | Non Profit - Other 22 | http://www.foundation.sdsu.edu/index.html | Non Governmental Organization 10 | 221 | San Diego State University 378 | State 5 | State Agency 5 | https://fsp.sdsu.edu/about-us/ | Riverside 10 | 493.628 | Santa Margarita ER | 1962 | State Conservation Area 8 | 2 |
6676 | 6676 | 6675 | {"type": "Polygon", "coordinates": [[[-117.1779, 33.42839], [-117.1779, 33.43232], [-117.17339, 33.43239], [-117.17327, 33.42847], [-117.1779, 33.42839]]]} | Restricted Access 2 | 5517 | Santa Margarita Ecological Reserve | 33342 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 221 | San Diego State University 378 | State 5 | State Agency 5 | https://fsp.sdsu.edu/about-us/ | San Diego 4 | 45.762 | Santa Margarita ER | 1962 | State Conservation Area 8 | 2 |
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 |
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 |
15568 | 15568 | 15567 | {"type": "MultiPolygon", "coordinates": [[[[-117.15855, 33.46486], [-117.15421, 33.46507], [-117.14524, 33.46588], [-117.14538, 33.46928], [-117.14494, 33.46886], [-117.14213, 33.46585], [-117.13783, 33.46151], [-117.1408, 33.46153], [-117.14069, 33.45434], [-117.13656, 33.45432], [-117.13646, 33.45406], [-117.13637, 33.45348], [-117.1363, 33.45254], [-117.13632, 33.44932], [-117.13637, 33.4487], [-117.13646, 33.448], [-117.13653, 33.44776], [-117.13676, 33.44716], [-117.15344, 33.4472], [-117.15396, 33.4616], [-117.1584, 33.46141], [-117.15855, 33.46486]]], [[[-117.20649, 33.43578], [-117.20644, 33.44303], [-117.19756, 33.44297], [-117.1975, 33.44657], [-117.19305, 33.44653], [-117.19309, 33.44294], [-117.18865, 33.44291], [-117.18876, 33.43575], [-117.19321, 33.43576], [-117.19316, 33.43934], [-117.19759, 33.43937], [-117.19765, 33.43577], [-117.20649, 33.43578]]]]} | Restricted Access 2 | 5509 | Santa Margarita Ecological Reserve | 33342 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 221 | San Diego State University 378 | State 5 | State Agency 5 | https://fsp.sdsu.edu/about-us/ | Riverside 10 | 1078.683 | Santa Margarita ER | 1962 | State Conservation Area 8 | 2 |
4914 | 4914 | 4913 | {"type": "Polygon", "coordinates": [[[-118.75013, 34.21604], [-118.74396, 34.21753], [-118.74395, 34.21755], [-118.74379, 34.21759], [-118.71671, 34.22411], [-118.70271, 34.20235], [-118.70369, 34.20128], [-118.7043, 34.2001], [-118.70453, 34.198], [-118.70277, 34.19497], [-118.70015, 34.19575], [-118.69796, 34.19647], [-118.69598, 34.19654], [-118.69504, 34.19617], [-118.69462, 34.19603], [-118.6924, 34.19678], [-118.69155, 34.19742], [-118.6875, 34.19926], [-118.68622, 34.19868], [-118.68537, 34.19882], [-118.68444, 34.1987], [-118.68384, 34.19834], [-118.68315, 34.19807], [-118.68191, 34.19798], [-118.68059, 34.19866], [-118.66803, 34.19964], [-118.66808, 34.19518], [-118.66804, 34.19517], [-118.66818, 34.18989], [-118.66816, 34.17549], [-118.66818, 34.16821], [-118.67781, 34.16834], [-118.67953, 34.16838], [-118.67961, 34.16836], [-118.68853, 34.16848], [-118.69167, 34.16853], [-118.69454, 34.1686], [-118.70339, 34.16862], [-118.70344, 34.16872], [-118.70689, 34.16866], [-118.71199, 34.16864], [-118.71639, 34.16834], [-118.71664, 34.16909], [-118.71647, 34.17044], [-118.7164, 34.17137], [-118.71474, 34.17481], [-118.71619, 34.17737], [-118.71689, 34.18046], [-118.71936, 34.18209], [-118.71891, 34.18415], [-118.71927, 34.18714], [-118.71886, 34.18763], [-118.71899, 34.18926], [-118.72, 34.19074], [-118.71961, 34.19119], [-118.71982, 34.19311], [-118.72145, 34.19322], [-118.72327, 34.196], [-118.72439, 34.19621], [-118.73201, 34.20859], [-118.74178, 34.21116], [-118.75013, 34.21604]]]} | Open Access 1 | 1662 | Upper Las Virgenes Open Space Preserve / Ahmanson | 12211 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 215 | Santa Monica Mountains Conservancy 303 | State 5 | State Agency 5 | http://lamountains.com/parks.asp?parkid=28 | Ventura 8 | 5428.251 | Upper Las Virgenes OSP / Ahmanson | 0 | State Conservation Area 8 | 2 |
16989 | 16989 | 16988 | {"type": "MultiPolygon", "coordinates": [[[[-118.24817, 34.20535], [-118.24767, 34.20624], [-118.24586, 34.20637], [-118.2459, 34.20514], [-118.24538, 34.20455], [-118.24565, 34.20442], [-118.24571, 34.20417], [-118.24564, 34.20403], [-118.24551, 34.2039], [-118.24523, 34.20385], [-118.245, 34.204], [-118.24487, 34.20413], [-118.24481, 34.20439], [-118.24438, 34.20428], [-118.24386, 34.20402], [-118.24355, 34.20394], [-118.24336, 34.20394], [-118.24314, 34.20397], [-118.24319, 34.20385], [-118.24253, 34.2035], [-118.24252, 34.20351], [-118.24248, 34.20408], [-118.24226, 34.20452], [-118.24248, 34.20461], [-118.2411, 34.20563], [-118.24024, 34.20545], [-118.24009, 34.20508], [-118.24007, 34.20509], [-118.24007, 34.20525], [-118.23984, 34.20498], [-118.23991, 34.20485], [-118.23992, 34.20471], [-118.24008, 34.2047], [-118.24008, 34.20387], [-118.24018, 34.20393], [-118.24028, 34.20383], [-118.24026, 34.20378], [-118.24029, 34.20374], [-118.24023, 34.20369], [-118.24015, 34.20372], [-118.24008, 34.20369], [-118.24008, 34.20062], [-118.24325, 34.20208], [-118.24704, 34.20387], [-118.24787, 34.20494], [-118.24817, 34.20535]]], [[[-118.26037, 34.20738], [-118.25859, 34.20909], [-118.25859, 34.20911], [-118.25624, 34.20958], [-118.25496, 34.21022], [-118.25491, 34.2074], [-118.25297, 34.2074], [-118.25294, 34.20649], [-118.25089, 34.20648], [-118.25087, 34.20558], [-118.24896, 34.2056], [-118.24846, 34.20493], [-118.24738, 34.20356], [-118.2411, 34.20061], [-118.24896, 34.20059], [-118.2488, 34.2008], [-118.24881, 34.20105], [-118.25288, 34.20103], [-118.25289, 34.20102], [-118.25288, 34.20015], [-118.25753, 34.2001], [-118.25754, 34.20736], [-118.26037, 34.20738]]], [[[-118.26158, 34.20739], [-118.26147, 34.20755], [-118.25902, 34.20889], [-118.26058, 34.20738], [-118.26158, 34.20739]]]]} | Open Access 1 | 6851 | Verdugo Mountains Open Space Preserve | 12213 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 215 | Santa Monica Mountains Conservancy 303 | State 5 | State Agency 5 | http://www.lamountains.com/parks.asp?parkid=627 | Los Angeles 6 | 250.369 | Verdugo Mtns. OSP | 0 | State Conservation Area 8 | 2 |
820 | 820 | 819 | {"type": "Polygon", "coordinates": [[[-122.46024, 38.4015], [-122.45904, 38.40373], [-122.45593, 38.40443], [-122.45662, 38.40573], [-122.45384, 38.40685], [-122.45383, 38.40697], [-122.45093, 38.40569], [-122.45012, 38.40836], [-122.44677, 38.40831], [-122.44613, 38.40284], [-122.44659, 38.40275], [-122.44716, 38.40269], [-122.44742, 38.40261], [-122.44761, 38.40251], [-122.44766, 38.40247], [-122.44768, 38.40235], [-122.44764, 38.4023], [-122.44757, 38.40227], [-122.44797, 38.40183], [-122.44828, 38.40157], [-122.46024, 38.4015]]]} | Open Access 1 | 4582 | Bumpy Camp Nature Preserve | 16503 | 223 | Napa Valley College 268 | State 5 | State Agency 5 | http://www.napavalley.edu/ | Other State 5 | 223 | Napa Valley College 263 | State 5 | State Agency 5 | Napa 11 | 148.027 | Bumpy Camp Nature Preserve | 0 | State Conservation Area 8 | 2 | |
655 | 655 | 654 | {"type": "Polygon", "coordinates": [[[-122.60188, 38.34223], [-122.60099, 38.34219], [-122.59824, 38.34219], [-122.59784, 38.34221], [-122.59674, 38.34238], [-122.59579, 38.34284], [-122.59514, 38.34423], [-122.59427, 38.34493], [-122.59333, 38.34522], [-122.59334, 38.34582], [-122.59113, 38.34633], [-122.5913, 38.34768], [-122.59135, 38.34828], [-122.5912, 38.3487], [-122.59122, 38.34925], [-122.59128, 38.34926], [-122.5913, 38.34965], [-122.59261, 38.35027], [-122.59275, 38.35752], [-122.58592, 38.35768], [-122.58582, 38.35554], [-122.5836, 38.35559], [-122.58354, 38.34758], [-122.58768, 38.34758], [-122.58754, 38.34322], [-122.5927, 38.34315], [-122.59271, 38.33808], [-122.59176, 38.33786], [-122.59079, 38.33744], [-122.58972, 38.33705], [-122.58885, 38.33685], [-122.588, 38.3368], [-122.58729, 38.33644], [-122.5869, 38.33609], [-122.58626, 38.33575], [-122.58571, 38.33561], [-122.58518, 38.33551], [-122.58545, 38.33521], [-122.58614, 38.33528], [-122.58697, 38.33561], [-122.58767, 38.33622], [-122.58824, 38.33643], [-122.58911, 38.33648], [-122.58974, 38.33662], [-122.5905, 38.33687], [-122.59169, 38.33743], [-122.5927, 38.33768], [-122.59271, 38.33767], [-122.59272, 38.33589], [-122.60179, 38.33588], [-122.60186, 38.34013], [-122.60188, 38.34223]], [[-122.5906, 38.3493], [-122.59059, 38.34928], [-122.59046, 38.34931], [-122.59053, 38.34931], [-122.5906, 38.3493]]]} | Restricted Access 2 | 3269 | Fairfield Osborn Preserve | 18798 | 211 | California State University Sonoma 232 | State 5 | State Agency 5 | http://www.sonoma.edu/ | Other State 5 | 211 | California State University Sonoma 228 | State 5 | State Agency 5 | Sonoma 16 | 414.364 | Fairfield Osborn Preserve | 2004 | State Conservation Area 8 | 2 | |
3108 | 3108 | 3107 | {"type": "MultiPolygon", "coordinates": [[[[-121.46234, 38.2686], [-121.46231, 38.26876], [-121.46161, 38.26911], [-121.46002, 38.26922], [-121.45923, 38.26938], [-121.45839, 38.2697], [-121.45775, 38.26965], [-121.45753, 38.26953], [-121.45774, 38.2673], [-121.45781, 38.26714], [-121.4579, 38.2664], [-121.45801, 38.26606], [-121.4583, 38.26581], [-121.45862, 38.26576], [-121.45932, 38.26588], [-121.46083, 38.2659], [-121.46118, 38.26624], [-121.46112, 38.26713], [-121.46132, 38.26782], [-121.46167, 38.26823], [-121.46211, 38.2684], [-121.46234, 38.2686]]], [[[-121.68459, 38.14478], [-121.68456, 38.14487], [-121.68445, 38.14505], [-121.68418, 38.14541], [-121.68404, 38.14611], [-121.68393, 38.14638], [-121.68387, 38.14656], [-121.68386, 38.14674], [-121.68389, 38.14684], [-121.6838, 38.14733], [-121.68366, 38.14777], [-121.68363, 38.148], [-121.68355, 38.14839], [-121.68327, 38.14912], [-121.68318, 38.14929], [-121.68312, 38.1493], [-121.68345, 38.14644], [-121.68406, 38.14476], [-121.68459, 38.14478]]]]} | Restricted Access 2 | 25288 | Cosumnes River Preserve | 17678 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Sacramento 41 | 35.364 | Cosumnes River Preserve | 0 | State Conservation Area 8 | 2 | ||
11278 | 11278 | 11277 | {"type": "MultiPolygon", "coordinates": [[[[-121.47063, 38.2699], [-121.4706, 38.27064], [-121.45934, 38.27057], [-121.45744, 38.27053], [-121.45753, 38.26953], [-121.45775, 38.26965], [-121.45839, 38.2697], [-121.45923, 38.26938], [-121.46002, 38.26922], [-121.46161, 38.26911], [-121.46231, 38.26876], [-121.46234, 38.2686], [-121.46211, 38.2684], [-121.46167, 38.26823], [-121.46132, 38.26782], [-121.46112, 38.26713], [-121.46118, 38.26625], [-121.46083, 38.2659], [-121.45932, 38.26588], [-121.45862, 38.26576], [-121.45831, 38.26581], [-121.45801, 38.26607], [-121.4579, 38.2664], [-121.45781, 38.26714], [-121.45774, 38.2673], [-121.45767, 38.2673], [-121.45787, 38.26584], [-121.45678, 38.26697], [-121.4556, 38.26691], [-121.45491, 38.26671], [-121.45329, 38.26679], [-121.45334, 38.26641], [-121.45342, 38.2664], [-121.45386, 38.26294], [-121.45446, 38.25887], [-121.45447, 38.25847], [-121.45468, 38.2569], [-121.45524, 38.25732], [-121.45555, 38.2575], [-121.45556, 38.25748], [-121.45578, 38.25759], [-121.45787, 38.25723], [-121.45864, 38.25732], [-121.45909, 38.25763], [-121.45934, 38.25812], [-121.45982, 38.25857], [-121.46072, 38.25902], [-121.46149, 38.25921], [-121.46136, 38.26017], [-121.46129, 38.2603], [-121.46105, 38.26172], [-121.46263, 38.26384], [-121.46222, 38.26635], [-121.46232, 38.26641], [-121.46232, 38.26645], [-121.46266, 38.26659], [-121.46431, 38.26748], [-121.46447, 38.26828], [-121.46365, 38.26984], [-121.47063, 38.2699]]], [[[-121.50963, 38.2458], [-121.50927, 38.24638], [-121.50921, 38.24636], [-121.50864, 38.24741], [-121.50384, 38.24617], [-121.5037, 38.24612], [-121.50353, 38.24609], [-121.50271, 38.24588], [-121.50332, 38.25019], [-121.50249, 38.25022], [-121.50189, 38.25041], [-121.50176, 38.25041], [-121.50146, 38.25033], [-121.50137, 38.25027], [-121.50135, 38.2503], [-121.5013, 38.25028], [-121.50021, 38.25049], [-121.50021, 38.25051], [-121.5007, 38.25092], [-121.50104, 38.25101], [-121.50058, 38.25107], [-121.50044, 38.25101], [-121.50033, 38.25084], [-121.50004, 38.2507], [-121.49992, 38.25044], [-121.49966, 38.25014], [-121.49947, 38.24987], [-121.49933, 38.24952], [-121.49916, 38.24938], [-121.49894, 38.24893], [-121.4988, 38.24871], [-121.49867, 38.24842], [-121.49845, 38.24755], [-121.49846, 38.24721], [-121.4984, 38.24683], [-121.49827, 38.24643], [-121.49813, 38.2461], [-121.49781, 38.24554], [-121.49768, 38.24512], [-121.49757, 38.24494], [-121.49745, 38.24449], [-121.49737, 38.24423], [-121.49733, 38.24387], [-121.49726, 38.24348], [-121.49726, 38.24268], [-121.49731, 38.24198], [-121.49738, 38.24147], [-121.49733, 38.24066], [-121.49736, 38.24046], [-121.49739, 38.2404], [-121.49744, 38.24035], [-121.49751, 38.24033], [-121.49763, 38.24034], [-121.49767, 38.2403], [-121.49771, 38.24021], [-121.49806, 38.24029], [-121.498, 38.24057], [-121.49802, 38.2411], [-121.49806, 38.24127], [-121.49818, 38.24151], [-121.49846, 38.24191], [-121.49871, 38.24222], [-121.49906, 38.24253], [-121.49937, 38.24273], [-121.49966, 38.24285], [-121.50023, 38.24302], [-121.5084, 38.24517], [-121.50877, 38.24532], [-121.50886, 38.24538], [-121.50905, 38.24565], [-121.50963, 38.2458]]]]} | Restricted Access 2 | 21796 | Cosumnes River Preserve | 17678 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Sacramento 41 | 329.27 | Cosumnes River Preserve | 0 | State Conservation Area 8 | 2 | ||
11209 | 11209 | 11208 | {"type": "MultiPolygon", "coordinates": [[[[-122.12348, 40.17101], [-122.10649, 40.17085], [-122.08771, 40.17078], [-122.07364, 40.17066], [-122.06924, 40.16662], [-122.0518, 40.15108], [-122.05107, 40.15026], [-122.05077, 40.15003], [-122.05066, 40.14987], [-122.05036, 40.14957], [-122.04226, 40.14263], [-122.03385, 40.14261], [-122.01491, 40.14243], [-122.01424, 40.15688], [-121.99527, 40.15697], [-121.99525, 40.15697], [-121.99568, 40.14267], [-121.9503, 40.14391], [-121.93706, 40.14345], [-121.9309, 40.14319], [-121.86075, 40.14298], [-121.86107, 40.1284], [-121.86114, 40.12481], [-121.86586, 40.12484], [-121.86594, 40.12125], [-121.87068, 40.12127], [-121.87078, 40.11768], [-121.87554, 40.11768], [-121.87565, 40.11409], [-121.87245, 40.11408], [-121.87246, 40.11406], [-121.8725, 40.11267], [-121.87307, 40.11149], [-121.87339, 40.11048], [-121.88056, 40.11046], [-121.88522, 40.11047], [-121.88535, 40.10687], [-121.89003, 40.10686], [-121.89015, 40.10325], [-121.89952, 40.10325], [-121.89965, 40.09963], [-121.90434, 40.09963], [-121.90447, 40.09602], [-121.91853, 40.09602], [-121.91867, 40.0924], [-121.9286, 40.09225], [-121.92873, 40.08874], [-121.93898, 40.08853], [-121.94827, 40.08837], [-121.94807, 40.08484], [-121.94817, 40.08139], [-121.95763, 40.08126], [-121.96236, 40.08116], [-121.96256, 40.07767], [-121.96743, 40.07768], [-121.96749, 40.07412], [-121.97778, 40.07406], [-121.9778, 40.07032], [-121.98617, 40.07021], [-121.98626, 40.06655], [-121.9909, 40.06654], [-121.99086, 40.05929], [-122.01503, 40.05905], [-122.01493, 40.05535], [-122.03035, 40.05533], [-122.03036, 40.05532], [-122.03035, 40.05488], [-122.03135, 40.05496], [-122.03254, 40.055], [-122.03321, 40.05506], [-122.03343, 40.05505], [-122.03412, 40.05516], [-122.03456, 40.05527], [-122.03849, 40.05522], [-122.03855, 40.05894], [-122.05253, 40.05871], [-122.05258, 40.0624], [-122.07144, 40.06219], [-122.07142, 40.06352], [-122.07143, 40.06353], [-122.0872, 40.06346], [-122.08715, 40.06719], [-122.08721, 40.07257], [-122.08715, 40.07645], [-122.08709, 40.08904], [-122.08842, 40.08904], [-122.08944, 40.08909], [-122.09028, 40.08909], [-122.08715, 40.09122], [-122.0872, 40.09864], [-122.07605, 40.09863], [-122.07597, 40.09876], [-122.07598, 40.09877], [-122.07851, 40.09877], [-122.08041, 40.10105], [-122.08045, 40.10164], [-122.08072, 40.10327], [-122.081, 40.10432], [-122.08126, 40.10515], [-122.08134, 40.10608], [-122.08087, 40.10685], [-122.08057, 40.1076], [-122.08053, 40.10799], [-122.08108, 40.10981], [-122.08071, 40.1101], [-122.08046, 40.11077], [-122.08036, 40.11196], [-122.08058, 40.11326], [-122.06826, 40.11322], [-122.06291, 40.10752], [-122.06261, 40.10768], [-122.06769, 40.11283], [-122.09369, 40.14002], [-122.08995, 40.1421], [-122.08994, 40.14212], [-122.09072, 40.14286], [-122.0929, 40.14504], [-122.10678, 40.15947], [-122.11045, 40.15741], [-122.12348, 40.17101]]], [[[-122.13427, 40.16059], [-122.13335, 40.16119], [-122.12524, 40.16506], [-122.12055, 40.16769], [-122.10943, 40.15604], [-122.11687, 40.15178], [-122.1132, 40.14796], [-122.12017, 40.1479], [-122.12066, 40.14926], [-122.12061, 40.14922], [-122.12072, 40.14958], [-122.12095, 40.15023], [-122.12157, 40.15063], [-122.12248, 40.15109], [-122.12324, 40.15114], [-122.12415, 40.15059], [-122.12535, 40.1509], [-122.12654, 40.15098], [-122.1274, 40.15145], [-122.12754, 40.15169], [-122.12897, 40.1534], [-122.12907, 40.15355], [-122.12913, 40.15378], [-122.12913, 40.15407], [-122.12917, 40.15424], [-122.12927, 40.15448], [-122.12936, 40.15464], [-122.1295, 40.1548], [-122.12959, 40.15497], [-122.12964, 40.15516], [-122.12967, 40.15538], [-122.12964, 40.15557], [-122.12958, 40.15567], [-122.12943, 40.15614], [-122.12936, 40.15652], [-122.12933, 40.15683], [-122.12936, 40.15713], [-122.12944, 40.15743], [-122.12955, 40.15767], [-122.12971, 40.15793], [-122.12992, 40.15816], [-122.13013, 40.15832], [-122.13029, 40.15842], [-122.13054, 40.15851], [-122.13068, 40.15852], [-122.13088, 40.15851], [-122.1313, 40.15838], [-122.13155, 40.15833], [-122.13176, 40.15832], [-122.13288, 40.15959], [-122.13427, 40.16059]]]]} | Restricted Access 2 | 21518 | Gray Davis Dye Creek Preserve | 19452 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | Tehama 18 | 37918.76 | Gray Davis Dye Creek Preserve | 0 | State Conservation Area 8 | 2 | ||
1331 | 1331 | 1330 | {"type": "Polygon", "coordinates": [[[-117.30505, 33.972], [-117.30065, 33.97196], [-117.30065, 33.97556], [-117.29645, 33.97552], [-117.2965, 33.96463], [-117.30083, 33.96465], [-117.30087, 33.96815], [-117.30505, 33.96813], [-117.30505, 33.972]]]} | No Public Access 3 | 47644 | Box Springs Reserve | 31388 | 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 | http://www.ucnrs.org/reserves/box-springs-reserve.html | Riverside 10 | 159.828 | Box Springs 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]);