units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
143 rows where DES_TP = 4 and MNG_AG_TYP = 2 sorted by YR_EST descending
This data as json, copyable, CSV (advanced)
Suggested facets: COUNTY
MNG_AGENCY >30
- San Diego, City of 9
- Burbank, City of 7
- Chico, City of 7
- Watsonville, City of 5
- Glendora, City of 5
- Redlands, City of 5
- Los Angeles, City of 4
- Palo Alto, City of 4
- Gilroy, City of 4
- Carlsbad, City of 3
- La Verne, City of 3
- Roseville, City of 3
- Sacramento, City of 3
- Arcata, City of 3
- Claremont, City of 2
- Santa Cruz, City of 2
- Santa Barbara, City of 2
- Glendale, City of 2
- Fullerton, City of 2
- Riverside, City of 2
- Rolling Hills Estates, City of 2
- Rancho Palos Verdes, City of 2
- Long Beach, City of 2
- Sierra Madre, City of 2
- Murrieta, City of 2
- Sebastopol, City of 2
- Oakdale, City of 1
- Lancaster, City of 1
- San Francisco, City and County of 1
- San Luis Obispo, City of 1
- …
ACCESS_TYP 4
MNG_AG_TYP 1
- City Agency · 143 ✖
DES_TP 1
- Local Conservation Area · 143 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16941 | 16941 | 16940 | {"type": "Polygon", "coordinates": [[[-121.01989, 39.27479], [-121.01983, 39.27487], [-121.01977, 39.2748], [-121.01976, 39.27463], [-121.01928, 39.27479], [-121.01908, 39.27487], [-121.01905, 39.27479], [-121.01644, 39.27477], [-121.01641, 39.27463], [-121.01629, 39.27443], [-121.01618, 39.27431], [-121.01604, 39.27421], [-121.0159, 39.27409], [-121.01579, 39.27395], [-121.01571, 39.2738], [-121.01567, 39.27364], [-121.01565, 39.27347], [-121.01567, 39.27331], [-121.01572, 39.27315], [-121.01586, 39.27292], [-121.01592, 39.27286], [-121.01615, 39.27267], [-121.01627, 39.27252], [-121.01636, 39.27236], [-121.01645, 39.27214], [-121.01657, 39.272], [-121.01673, 39.27189], [-121.01706, 39.27177], [-121.01731, 39.27163], [-121.01746, 39.27151], [-121.01763, 39.2713], [-121.01985, 39.27119], [-121.01989, 39.27479]]]} | Open Access 1 | 49010 | Sugarloaf Mountain Open Space Preserve | 33706 | 1425 | Nevada City, City of 991 | City 2 | City Agency 2 | http://www.nevadacityca.gov/content/parks-recreation | City 2 | 1425 | Nevada City, City of 955 | City 2 | City Agency 2 | https://www.bylt.org/trail/sugarloaf-mountain-trail/ | Nevada 30 | 29.943 | Sugarloaf Mtn. OSP | 2011 | Local Conservation Area 4 | 2 |
7299 | 7299 | 7298 | {"type": "Polygon", "coordinates": [[[-118.12099, 33.76215], [-118.12095, 33.76218], [-118.12089, 33.76215], [-118.12066, 33.76192], [-118.12055, 33.76183], [-118.11972, 33.76246], [-118.11976, 33.76251], [-118.11952, 33.76268], [-118.11947, 33.76265], [-118.119, 33.76301], [-118.11851, 33.76256], [-118.11853, 33.76255], [-118.11855, 33.76248], [-118.11859, 33.76245], [-118.11855, 33.7624], [-118.11988, 33.76165], [-118.1201, 33.76161], [-118.12043, 33.76165], [-118.12047, 33.76164], [-118.12057, 33.76171], [-118.12056, 33.76177], [-118.12099, 33.76215]]]} | Open Access 1 | 6583 | Jack Dunster Marine Biological Reserve | 20302 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 3.22 | Jack Dunster Marine Biological Reserve | 2004 | Local Conservation Area 4 | 2 | |
8947 | 8947 | 8946 | {"type": "Polygon", "coordinates": [[[-122.15409, 37.85875], [-122.15382, 37.85912], [-122.15332, 37.8589], [-122.15259, 37.85923], [-122.15174, 37.85981], [-122.15113, 37.86013], [-122.15036, 37.86072], [-122.15004, 37.86052], [-122.14988, 37.86078], [-122.14943, 37.86126], [-122.14924, 37.86109], [-122.14906, 37.86095], [-122.14886, 37.86083], [-122.14741, 37.86019], [-122.147, 37.85999], [-122.14641, 37.85974], [-122.14369, 37.85838], [-122.14335, 37.85825], [-122.14317, 37.85821], [-122.14295, 37.85818], [-122.14268, 37.85816], [-122.1426, 37.85264], [-122.14422, 37.85365], [-122.14541, 37.85435], [-122.14541, 37.85462], [-122.14521, 37.85491], [-122.14526, 37.85503], [-122.14528, 37.85512], [-122.14538, 37.85516], [-122.14542, 37.85521], [-122.14572, 37.85545], [-122.14665, 37.85597], [-122.14686, 37.8567], [-122.14772, 37.85662], [-122.14768, 37.85637], [-122.14785, 37.85571], [-122.14886, 37.85549], [-122.1493, 37.85542], [-122.15037, 37.85557], [-122.15096, 37.85579], [-122.15188, 37.85642], [-122.15363, 37.85749], [-122.15347, 37.85824], [-122.15354, 37.85835], [-122.15365, 37.85847], [-122.15409, 37.85875]]]} | Open Access 1 | 44957 | Mulholland Open Space Preserve | 22595 | 1235 | Orinda, City of 392 | City 2 | City Agency 2 | http://www.cityoforinda.org/index.asp?Type=B_BASIC&SEC={DF30AA31-A638-4650-A63E-8E4033089DBE} | City 2 | 1235 | Orinda, City of 386 | City 2 | City Agency 2 | Contra Costa 12 | 113.073 | Mulholland OSP | 1991 | Local Conservation Area 4 | 2 | |
15638 | 15638 | 15637 | {"type": "Polygon", "coordinates": [[[-117.02536, 33.01762], [-117.0241, 33.01851], [-117.02409, 33.01859], [-117.02226, 33.01869], [-117.02223, 33.01607], [-117.02353, 33.01605], [-117.02405, 33.01608], [-117.02415, 33.01631], [-117.02426, 33.01652], [-117.02438, 33.01672], [-117.02457, 33.01696], [-117.0249, 33.01729], [-117.02514, 33.01748], [-117.02536, 33.01762]]]} | Restricted Access 2 | 45140 | Blue Sky Ecological Reserve | 29221 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 15.494 | Blue Sky ER | 1991 | Local Conservation Area 4 | 2 | |
4932 | 4932 | 4931 | {"type": "Polygon", "coordinates": [[[-117.25556, 33.02003], [-117.25123, 33.02002], [-117.25123, 33.0188], [-117.25221, 33.01809], [-117.2555, 33.01812], [-117.25556, 33.02003]]]} | Open Access 1 | 730 | San Elijo Lagoon Ecological Reserve | 24879 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 20.255 | San Elijo Lagoon ER | 1983 | Local Conservation Area 4 | 2 | |
9987 | 9987 | 9986 | {"type": "MultiPolygon", "coordinates": [[[[-122.18066, 37.38892], [-122.1723, 37.39048], [-122.17088, 37.3901], [-122.16933, 37.39028], [-122.17039, 37.38577], [-122.17089, 37.38599], [-122.17123, 37.38611], [-122.17368, 37.38683], [-122.17413, 37.38691], [-122.17612, 37.38712], [-122.17645, 37.38713], [-122.17716, 37.38704], [-122.17843, 37.38682], [-122.17869, 37.38674], [-122.18066, 37.38892]]], [[[-122.19585, 37.37295], [-122.19488, 37.37474], [-122.19337, 37.37928], [-122.1929, 37.37985], [-122.19134, 37.37966], [-122.19009, 37.37923], [-122.18963, 37.379], [-122.18935, 37.37883], [-122.18893, 37.37861], [-122.18882, 37.37856], [-122.18849, 37.37847], [-122.18694, 37.37945], [-122.18633, 37.37986], [-122.18633, 37.37988], [-122.18759, 37.38062], [-122.18585, 37.3829], [-122.18536, 37.38246], [-122.18519, 37.38234], [-122.18488, 37.38219], [-122.18474, 37.38206], [-122.18467, 37.3819], [-122.18464, 37.38154], [-122.18456, 37.38135], [-122.18442, 37.38117], [-122.18423, 37.38104], [-122.18399, 37.38095], [-122.18378, 37.38092], [-122.18356, 37.3809], [-122.18262, 37.38091], [-122.18244, 37.38094], [-122.1822, 37.38102], [-122.18205, 37.3811], [-122.18192, 37.3812], [-122.18178, 37.38138], [-122.18172, 37.38151], [-122.18147, 37.38258], [-122.18116, 37.38325], [-122.18109, 37.38347], [-122.18096, 37.38427], [-122.1809, 37.38445], [-122.18075, 37.38471], [-122.1805, 37.38505], [-122.18026, 37.3853], [-122.18008, 37.38544], [-122.17967, 37.3857], [-122.17886, 37.38644], [-122.17859, 37.38662], [-122.17846, 37.38667], [-122.17713, 37.3869], [-122.17665, 37.38697], [-122.17645, 37.38698], [-122.17625, 37.38697], [-122.17415, 37.38675], [-122.17388, 37.3867], [-122.17361, 37.38664], [-122.17131, 37.38596], [-122.17099, 37.38584], [-122.17051, 37.38564], [-122.17182, 37.37974], [-122.17235, 37.37987], [-122.17349, 37.38141], [-122.17451, 37.38173], [-122.17551, 37.38101], [-122.17651, 37.37943], [-122.17791, 37.37798], [-122.17633, 37.37702], [-122.17632, 37.37597], [-122.178, 37.37698], [-122.17878, 37.37696], [-122.18074, 37.37494], [-122.17973, 37.37432], [-122.17976, 37.37388], [-122.17957, 37.37382], [-122.17936, 37.37354], [-122.17861, 37.37286], [-122.17862, 37.37267], [-122.17857, 37.37249], [-122.17852, 37.37237], [-122.17829, 37.37201], [-122.17866, 37.37149], [-122.17768, 37.37094], [-122.17768, 37.37067], [-122.17716, 37.37065], [-122.17655, 37.37056], [-122.1766, 37.37034], [-122.17566, 37.36981], [-122.17561, 37.36965], [-122.17757, 37.36969], [-122.17773, 37.36904], [-122.17655, 37.36839], [-122.17787, 37.36834], [-122.17847, 37.36744], [-122.17931, 37.36763], [-122.17994, 37.36759], [-122.18039, 37.36775], [-122.18086, 37.36775], [-122.18133, 37.36761], [-122.18155, 37.3674], [-122.18172, 37.36694], [-122.18209, 37.36668], [-122.18307, 37.36647], [-122.1833, 37.36619], [-122.18362, 37.36568], [-122.18581, 37.36661], [-122.18401, 37.36823], [-122.18401, 37.36824], [-122.18958, 37.37147], [-122.19, 37.37155], [-122.19129, 37.37156], [-122.19157, 37.37158], [-122.19525, 37.37274], [-122.19585, 37.37295]]]]} | Open Access 1 | 17184 | Enid Pearson-Arastradero Preserve | 33226 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/gov/depts/csd/parks/preserves/arastradero/ | Santa Clara 19 | 657.833 | Enid Pearson-Arastradero Preserve | 1981 | Local Conservation Area 4 | 2 |
1433 | 1433 | 1432 | {"type": "Polygon", "coordinates": [[[-122.17854, 37.34566], [-122.17621, 37.35241], [-122.17291, 37.35273], [-122.17289, 37.35278], [-122.17225, 37.35279], [-122.17206, 37.34613], [-122.17207, 37.34577], [-122.17854, 37.34566]]]} | Open Access 1 | 47698 | Foothills Open Space Preserve | 31434 | 2079 | Midpeninsula Regional Open Space District 366 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 86.854 | Foothills OSP | 1975 | Local Conservation Area 4 | 2 | |
6730 | 6730 | 6729 | {"type": "Polygon", "coordinates": [[[-122.1629, 37.36432], [-122.16229, 37.3647], [-122.16191, 37.36476], [-122.16185, 37.36454], [-122.16027, 37.36435], [-122.16046, 37.36512], [-122.15953, 37.36527], [-122.15962, 37.36576], [-122.15884, 37.36605], [-122.15821, 37.36623], [-122.15804, 37.36625], [-122.15788, 37.36621], [-122.15731, 37.36594], [-122.15714, 37.36581], [-122.15695, 37.36561], [-122.15689, 37.36552], [-122.15686, 37.36542], [-122.15684, 37.36518], [-122.15681, 37.36505], [-122.15673, 37.3649], [-122.15666, 37.36479], [-122.15564, 37.36365], [-122.15552, 37.36353], [-122.1553, 37.36338], [-122.15454, 37.36294], [-122.15444, 37.36285], [-122.15435, 37.36275], [-122.15391, 37.36215], [-122.1548, 37.36189], [-122.15486, 37.3613], [-122.15455, 37.36088], [-122.15433, 37.36066], [-122.15462, 37.35983], [-122.15468, 37.3598], [-122.15598, 37.36056], [-122.15779, 37.36015], [-122.15749, 37.35841], [-122.1567, 37.35775], [-122.15615, 37.35772], [-122.15574, 37.35834], [-122.15479, 37.35873], [-122.15459, 37.35836], [-122.15412, 37.35852], [-122.15396, 37.35773], [-122.15471, 37.35722], [-122.1545, 37.35675], [-122.15406, 37.3564], [-122.15371, 37.35589], [-122.15195, 37.35513], [-122.15199, 37.35454], [-122.15207, 37.35431], [-122.15222, 37.35412], [-122.15234, 37.35377], [-122.15211, 37.35335], [-122.15238, 37.35351], [-122.15435, 37.35486], [-122.15491, 37.3554], [-122.1555, 37.35525], [-122.15595, 37.35548], [-122.15607, 37.35557], [-122.15665, 37.3561], [-122.15686, 37.35627], [-122.1573, 37.35678], [-122.15757, 37.35701], [-122.15821, 37.35746], [-122.15835, 37.35753], [-122.15881, 37.35765], [-122.15879, 37.35799], [-122.15874, 37.35816], [-122.15869, 37.35844], [-122.15867, 37.35892], [-122.1587, 37.35929], [-122.15866, 37.35963], [-122.15841, 37.36001], [-122.15833, 37.36025], [-122.15816, 37.36059], [-122.15812, 37.36084], [-122.1582, 37.36124], [-122.15844, 37.36166], [-122.15871, 37.36199], [-122.15885, 37.362], [-122.15894, 37.36236], [-122.15932, 37.36231], [-122.15937, 37.36237], [-122.15941, 37.36238], [-122.15954, 37.3627], [-122.16023, 37.36295], [-122.16124, 37.36311], [-122.16158, 37.36318], [-122.16226, 37.36325], [-122.16236, 37.36364], [-122.1629, 37.36432]]]} | No Public Access 3 | 5074 | Byrne Reserve | 16619 | 1187 | Los Altos Hills, Town of 842 | City 2 | City Agency 2 | http://www.losaltoshills.ca.gov/parks-and-recreation/parks-and-recreation | City 2 | 1187 | Los Altos Hills, Town of 819 | City 2 | City Agency 2 | Santa Clara 19 | 100.121 | Byrne Reserve | 1968 | Local Conservation Area 4 | 2 | |
1834 | 1834 | 1833 | {"type": "Polygon", "coordinates": [[[-122.29139, 37.56829], [-122.29135, 37.56831], [-122.2913, 37.56829], [-122.29123, 37.56825], [-122.29109, 37.56813], [-122.29095, 37.56795], [-122.29089, 37.56778], [-122.29092, 37.56774], [-122.29111, 37.5678], [-122.29127, 37.56788], [-122.2914, 37.568], [-122.29143, 37.56813], [-122.29141, 37.56827], [-122.29139, 37.56829]]]} | Open Access 1 | 14019 | Marina Lagoon Wildlife Island | 21829 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 0.388 | Marina Lagoon Wildlife Island | 1962 | Local Conservation Area 4 | 2 | |
16734 | 16734 | 16733 | {"type": "Polygon", "coordinates": [[[-122.39604, 37.5774], [-122.39547, 37.57779], [-122.39467, 37.57823], [-122.39425, 37.57863], [-122.39392, 37.57904], [-122.39327, 37.57947], [-122.39302, 37.5797], [-122.39259, 37.58019], [-122.39222, 37.58053], [-122.39203, 37.58068], [-122.39169, 37.58041], [-122.39132, 37.5807], [-122.39099, 37.58083], [-122.39091, 37.58081], [-122.39083, 37.58083], [-122.39078, 37.58086], [-122.39073, 37.58097], [-122.39067, 37.58104], [-122.39001, 37.58148], [-122.38957, 37.58188], [-122.38948, 37.58193], [-122.38931, 37.58196], [-122.38924, 37.58199], [-122.38921, 37.58205], [-122.38922, 37.58213], [-122.38876, 37.58268], [-122.38875, 37.58267], [-122.38797, 37.583], [-122.3879, 37.58342], [-122.3883, 37.58366], [-122.38849, 37.58382], [-122.38828, 37.58392], [-122.38809, 37.58392], [-122.38797, 37.58386], [-122.38776, 37.5838], [-122.38763, 37.58383], [-122.38742, 37.58377], [-122.38695, 37.58374], [-122.38686, 37.58367], [-122.38677, 37.58264], [-122.38679, 37.58255], [-122.38696, 37.58248], [-122.38704, 37.58238], [-122.38714, 37.5824], [-122.38725, 37.58252], [-122.38768, 37.58236], [-122.38778, 37.58224], [-122.38793, 37.58213], [-122.3879, 37.58187], [-122.38808, 37.58173], [-122.38817, 37.58148], [-122.38833, 37.58143], [-122.38837, 37.58122], [-122.38848, 37.58117], [-122.38854, 37.58101], [-122.38875, 37.58082], [-122.38907, 37.58075], [-122.38941, 37.5806], [-122.38959, 37.58047], [-122.38996, 37.58048], [-122.39024, 37.58041], [-122.39026, 37.58031], [-122.39052, 37.58003], [-122.39058, 37.5799], [-122.39068, 37.5798], [-122.39073, 37.57963], [-122.39083, 37.5796], [-122.38978, 37.5788], [-122.38987, 37.57874], [-122.38998, 37.57862], [-122.39006, 37.57864], [-122.39122, 37.57818], [-122.39194, 37.57892], [-122.39205, 37.57887], [-122.39214, 37.5787], [-122.39217, 37.57861], [-122.39227, 37.57854], [-122.39234, 37.57845], [-122.39243, 37.57848], [-122.39256, 37.57844], [-122.3927, 37.57855], [-122.39311, 37.57835], [-122.39321, 37.5782], [-122.39334, 37.57812], [-122.39341, 37.57805], [-122.3938, 37.57788], [-122.39394, 37.5779], [-122.39421, 37.57779], [-122.39454, 37.57775], [-122.39483, 37.57768], [-122.39489, 37.57762], [-122.39502, 37.57762], [-122.3951, 37.57756], [-122.39535, 37.57748], [-122.39578, 37.57722], [-122.39604, 37.5774]]]} | Open Access 1 | 17912 | Mills Canyon Wildlife Area | 22254 | 1039 | Burlingame, City of 390 | City 2 | City Agency 2 | http://www.burlingame.org/index.aspx?page=33 | City 2 | 1039 | Burlingame, City of 384 | City 2 | City Agency 2 | San Mateo 15 | 31.113 | Mills Canyon Wildlife Area | 1961 | Local Conservation Area 4 | 2 | |
3277 | 3277 | 3276 | {"type": "Polygon", "coordinates": [[[-122.1276, 37.47289], [-122.1263, 37.47477], [-122.12365, 37.4757], [-122.12364, 37.4744], [-122.12355, 37.47442], [-122.12354, 37.47435], [-122.12325, 37.47442], [-122.12322, 37.47422], [-122.1232, 37.47247], [-122.1217, 37.47234], [-122.12044, 37.47011], [-122.11894, 37.46936], [-122.1178, 37.46885], [-122.1166, 37.46744], [-122.11616, 37.46674], [-122.11562, 37.46613], [-122.11646, 37.46595], [-122.11693, 37.46561], [-122.11769, 37.46539], [-122.11935, 37.4644], [-122.12374, 37.46164], [-122.12382, 37.46146], [-122.12483, 37.46429], [-122.12594, 37.46698], [-122.1276, 37.47289]]]} | Open Access 1 | 23137 | Baylands Preserve | 8356 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/gov/depts/csd/parks/preserves/baylands.asp | San Mateo 15 | 193.549 | Baylands Preserve | 1944 | Local Conservation Area 4 | 2 |
10365 | 10365 | 10364 | {"type": "Polygon", "coordinates": [[[-122.12408, 37.46084], [-122.12374, 37.46164], [-122.11935, 37.4644], [-122.11769, 37.46539], [-122.11693, 37.46561], [-122.11658, 37.46587], [-122.11625, 37.46581], [-122.11519, 37.46611], [-122.11576, 37.46572], [-122.11475, 37.46553], [-122.11433, 37.46476], [-122.11345, 37.46405], [-122.11261, 37.46368], [-122.1113, 37.46352], [-122.1105, 37.46337], [-122.10985, 37.46312], [-122.10952, 37.4632], [-122.10928, 37.46328], [-122.10889, 37.46296], [-122.10834, 37.46278], [-122.10812, 37.46256], [-122.10757, 37.46235], [-122.10736, 37.46233], [-122.10725, 37.46222], [-122.10685, 37.46171], [-122.10649, 37.46131], [-122.10608, 37.46135], [-122.10527, 37.46138], [-122.10402, 37.46218], [-122.10226, 37.4632], [-122.1018, 37.4633], [-122.10126, 37.46319], [-122.10098, 37.46294], [-122.10071, 37.46253], [-122.10066, 37.46145], [-122.10107, 37.45993], [-122.10165, 37.4583], [-122.10191, 37.45772], [-122.1019, 37.45759], [-122.10245, 37.45725], [-122.10271, 37.4567], [-122.10332, 37.4562], [-122.10383, 37.45594], [-122.10514, 37.45586], [-122.10573, 37.45593], [-122.10622, 37.45633], [-122.10628, 37.45633], [-122.10637, 37.45661], [-122.10494, 37.45838], [-122.10546, 37.4587], [-122.1055, 37.45818], [-122.10592, 37.45767], [-122.10678, 37.45759], [-122.10727, 37.457], [-122.10743, 37.45668], [-122.10806, 37.4566], [-122.10853, 37.45619], [-122.10906, 37.45529], [-122.10904, 37.45416], [-122.10883, 37.45339], [-122.10839, 37.45256], [-122.10764, 37.45168], [-122.10639, 37.45119], [-122.10575, 37.45124], [-122.10522, 37.45126], [-122.10521, 37.45158], [-122.10548, 37.45141], [-122.10699, 37.4515], [-122.10783, 37.45239], [-122.10745, 37.45215], [-122.10749, 37.45244], [-122.10764, 37.45269], [-122.10772, 37.45296], [-122.10755, 37.45305], [-122.10702, 37.45306], [-122.10701, 37.45308], [-122.10706, 37.45312], [-122.10693, 37.45311], [-122.10652, 37.45334], [-122.10653, 37.45361], [-122.10665, 37.4543], [-122.10687, 37.45471], [-122.10684, 37.45506], [-122.10633, 37.45524], [-122.10503, 37.45524], [-122.10483, 37.45521], [-122.10412, 37.4552], [-122.10391, 37.45536], [-122.1036, 37.45537], [-122.10316, 37.45548], [-122.10295, 37.4556], [-122.1024, 37.45547], [-122.10235, 37.45543], [-122.10225, 37.45545], [-122.10223, 37.45564], [-122.10214, 37.456], [-122.10156, 37.45642], [-122.10132, 37.45653], [-122.10114, 37.45629], [-122.10093, 37.45616], [-122.10067, 37.45634], [-122.10041, 37.45604], [-122.09929, 37.45514], [-122.0981, 37.45412], [-122.09636, 37.45391], [-122.09434, 37.4535], [-122.09258, 37.45305], [-122.09196, 37.45269], [-122.091, 37.45188], [-122.09012, 37.45011], [-122.09029, 37.44924], [-122.09122, 37.44893], [-122.09042, 37.44854], [-122.0905, 37.44753], [-122.09066, 37.44711], [-122.09103, 37.44667], [-122.09223, 37.4464], [-122.09357, 37.44607], [-122.09397, 37.44552], [-122.09425, 37.44469], [-122.09396, 37.44398], [-122.09305, 37.44337], [-122.09255, 37.4428], [-122.0925, 37.44239], [-122.09285, 37.44131], [-122.09333, 37.44089], [-122.09553, 37.44083], [-122.09715, 37.43923], [-122.09918, 37.43701], [-122.09965, 37.4364], [-122.09969, 37.436], [-122.0998, 37.43564], [-122.0998, 37.4355], [-122.10018, 37.43557], [-122.10019, 37.43556], [-122.10006, 37.4354], [-122.1001, 37.43531], [-122.10106, 37.43533], [-122.10258, 37.43481], [-122.10378, 37.43414], [-122.10433, 37.43342], [-122.10499, 37.43275], [-122.1057, 37.43256], [-122.10844, 37.4359], [-122.10958, 37.43713], [-122.11012, 37.43778], [-122.11126, 37.43851], [-122.11217, 37.43924], [-122.11304, 37.44003], [-122.11302, 37.44005], [-122.11359, 37.44054], [-122.11739, 37.44412], [-122.11749, 37.44449], [-122.11804, 37.44586], [-122.11777, 37.44584], [-122.11711, 37.44585], [-122.11748, 37.44685], [-122.11766, 37.44682], [-122.11759, 37.44731], [-122.11715, 37.44736], [-122.1175, 37.44882], [-122.11718, 37.44923], [-122.11654, 37.44865], [-122.11557, 37.44926], [-122.11545, 37.44916], [-122.11483, 37.44924], [-122.11448, 37.44933], [-122.11407, 37.4498], [-122.11383, 37.45016], [-122.11381, 37.45016], [-122.1138, 37.45022], [-122.10998, 37.45019], [-122.10969, 37.45038], [-122.10901, 37.45087], [-122.10828, 37.45134], [-122.10992, 37.45311], [-122.11009, 37.45376], [-122.1101, 37.45553], [-122.11017, 37.45576], [-122.11022, 37.45576], [-122.11214, 37.45712], [-122.11216, 37.45795], [-122.11225, 37.45803], [-122.11196, 37.45831], [-122.11299, 37.45945], [-122.11389, 37.46038], [-122.11464, 37.46157], [-122.11564, 37.46253], [-122.1163, 37.46273], [-122.11742, 37.46398], [-122.11792, 37.46396], [-122.11832, 37.46354], [-122.11764, 37.46218], [-122.11629, 37.46125], [-122.11517, 37.45988], [-122.11526, 37.45802], [-122.11581, 37.45719], [-122.11601, 37.45604], [-122.11685, 37.45317], [-122.11807, 37.45279], [-122.11917, 37.45274], [-122.12014, 37.45298], [-122.12098, 37.45357], [-122.12209, 37.45477], [-122.12256, 37.45551], [-122.123, 37.45633], [-122.12307, 37.45771], [-122.12408, 37.46084]]]} | Open Access 1 | 18298 | Baylands Preserve | 8356 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/gov/depts/csd/parks/preserves/baylands.asp | Santa Clara 19 | 1311.915 | Baylands Preserve | 1944 | Local Conservation Area 4 | 2 |
4 | 4 | 3 | {"type": "Polygon", "coordinates": [[[-120.8183, 37.79059], [-120.81762, 37.7907], [-120.81665, 37.79072], [-120.81597, 37.7907], [-120.81518, 37.79071], [-120.81444, 37.7908], [-120.81354, 37.79068], [-120.81324, 37.79069], [-120.81119, 37.79087], [-120.81012, 37.79017], [-120.80995, 37.78962], [-120.81, 37.78839], [-120.80928, 37.78757], [-120.80991, 37.78733], [-120.81064, 37.78764], [-120.8111, 37.78789], [-120.81169, 37.78776], [-120.81268, 37.78774], [-120.81358, 37.7878], [-120.81565, 37.78787], [-120.81602, 37.78793], [-120.81796, 37.78801], [-120.8183, 37.79059]]]} | Restricted Access 2 | 24 | Stanley Wakefield Wilderness Area | 25790 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | Stanislaus 2 | 57.379 | Stanley Wakefield Wilderness Area | 0 | Local Conservation Area 4 | 2 | |
418 | 418 | 417 | {"type": "MultiPolygon", "coordinates": [[[[-121.7791, 36.92112], [-121.77861, 36.92097], [-121.77814, 36.92117], [-121.77746, 36.9222], [-121.7769, 36.92436], [-121.77687, 36.92456], [-121.77667, 36.92366], [-121.77666, 36.92365], [-121.77613, 36.92561], [-121.77599, 36.92621], [-121.77601, 36.92699], [-121.77567, 36.92723], [-121.77534, 36.92621], [-121.77526, 36.92569], [-121.7753, 36.92516], [-121.77549, 36.92432], [-121.77552, 36.9241], [-121.77553, 36.92388], [-121.776, 36.92394], [-121.77606, 36.92283], [-121.77616, 36.92252], [-121.77623, 36.9219], [-121.77645, 36.92201], [-121.77717, 36.9225], [-121.77833, 36.91963], [-121.7791, 36.92112]]], [[[-121.77899, 36.91916], [-121.77866, 36.91936], [-121.77838, 36.91931], [-121.77842, 36.91897], [-121.77824, 36.91893], [-121.77848, 36.91836], [-121.77891, 36.91869], [-121.77899, 36.91916]]]]} | Open Access 1 | 1666 | Upper Struve Slough | 28147 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 15.625 | Upper Struve Slough | 0 | Local Conservation Area 4 | 2 | |
770 | 770 | 769 | {"type": "MultiPolygon", "coordinates": [[[[-119.5289, 34.39581], [-119.52824, 34.3972], [-119.52811, 34.3971], [-119.52714, 34.39789], [-119.52649, 34.39736], [-119.52855, 34.39567], [-119.5289, 34.39581]]], [[[-119.52817, 34.39735], [-119.52805, 34.39762], [-119.52771, 34.39836], [-119.52732, 34.39804], [-119.52817, 34.39735]]]]} | Restricted Access 2 | 4493 | Carpinteria Salt Marsh Reserve | 16899 | 1047 | Carpinteria, City of 72 | City 2 | City Agency 2 | http://www.carpinteria.ca.us/parks_rec/index.shtml | City 2 | 1047 | Carpinteria, City of 70 | City 2 | City Agency 2 | Santa Barbara 7 | 5.768 | Carpinteria Salt Marsh Reserve | 0 | Local Conservation Area 4 | 2 | |
923 | 923 | 922 | {"type": "Polygon", "coordinates": [[[-118.33718, 33.76768], [-118.33635, 33.76814], [-118.33599, 33.76854], [-118.33549, 33.76865], [-118.33479, 33.76891], [-118.33421, 33.76885], [-118.33391, 33.76892], [-118.33374, 33.76913], [-118.33223, 33.76984], [-118.33131, 33.77004], [-118.3307, 33.77005], [-118.33069, 33.76988], [-118.32983, 33.76993], [-118.32914, 33.77014], [-118.32746, 33.77059], [-118.32699, 33.77124], [-118.32727, 33.77181], [-118.3271, 33.77189], [-118.32733, 33.77234], [-118.32698, 33.77247], [-118.32693, 33.77225], [-118.32676, 33.77186], [-118.32654, 33.77151], [-118.32637, 33.77132], [-118.32611, 33.77107], [-118.3259, 33.77091], [-118.32492, 33.77026], [-118.32701, 33.77025], [-118.32756, 33.76972], [-118.32885, 33.7694], [-118.33031, 33.76865], [-118.33101, 33.76955], [-118.33165, 33.76962], [-118.333, 33.76871], [-118.33343, 33.7675], [-118.33564, 33.76652], [-118.33578, 33.76691], [-118.33655, 33.7668], [-118.33718, 33.76768]]]} | Open Access 1 | 5878 | George F Canyon Nature Park and Preserve | 19263 | 1283 | Rolling Hills Estates, City of 270 | City 2 | City Agency 2 | http://www.ci.rolling-hills-estates.ca.us/index.aspx?page=109 | City 2 | 1283 | Rolling Hills Estates, City of 265 | City 2 | City Agency 2 | Los Angeles 6 | 33.273 | George F Canyon Nature Park and Preserve | 0 | Local Conservation Area 4 | 2 | |
964 | 964 | 963 | {"type": "Polygon", "coordinates": [[[-118.37563, 33.82957], [-118.3743, 33.83077], [-118.37429, 33.8313], [-118.37368, 33.83139], [-118.37311, 33.82856], [-118.37351, 33.82804], [-118.37387, 33.82825], [-118.37421, 33.82848], [-118.37563, 33.82957]]]} | Open Access 1 | 6056 | Hopkins Wilderness Park | 20088 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 10.984 | Hopkins Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
1011 | 1011 | 1010 | {"type": "Polygon", "coordinates": [[[-117.76393, 34.14161], [-117.76342, 34.1421], [-117.76331, 34.14232], [-117.76331, 34.14243], [-117.76337, 34.14267], [-117.76337, 34.14304], [-117.76345, 34.1432], [-117.76345, 34.14348], [-117.76025, 34.14346], [-117.75906, 34.14347], [-117.75905, 34.14352], [-117.75879, 34.14355], [-117.75874, 34.14353], [-117.75869, 34.14324], [-117.75976, 34.14314], [-117.76228, 34.14231], [-117.76283, 34.14222], [-117.76319, 34.14186], [-117.76344, 34.14188], [-117.7638, 34.14152], [-117.76393, 34.14161]]]} | Open Access 1 | 6791 | Golden Hills Wilderness Park | 19365 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 9.525 | Golden Hills Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
1048 | 1048 | 1047 | {"type": "Polygon", "coordinates": [[[-118.51707, 34.12476], [-118.51169, 34.12287], [-118.50522, 34.11808], [-118.50208, 34.11085], [-118.50114, 34.10951], [-118.50141, 34.10932], [-118.50238, 34.11073], [-118.5055, 34.11792], [-118.50867, 34.12028], [-118.50994, 34.11967], [-118.51004, 34.12128], [-118.51187, 34.12264], [-118.51704, 34.12445], [-118.51707, 34.12476]]]} | Open Access 1 | 6371 | Westridge-Canyonback Wilderness Park of LA | 27417 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 20.346 | Westridge-Canyonback Wilderness Park of LA | 0 | Local Conservation Area 4 | 2 | |
1122 | 1122 | 1121 | {"type": "Polygon", "coordinates": [[[-118.29627, 34.19919], [-118.29609, 34.19935], [-118.29614, 34.19953], [-118.29511, 34.19897], [-118.2953, 34.19878], [-118.29525, 34.19874], [-118.29588, 34.19813], [-118.29595, 34.19818], [-118.29627, 34.19919]]]} | Open Access 1 | 7138 | City of Burbank Open Space Mountain Reserve | 744 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | Los Angeles 6 | 2.037 | City of Burbank OS Mtn. Reserve | 0 | Local Conservation Area 4 | 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]);