units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,454 rows where AGNCY_LEV = 3 sorted by YR_EST
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_TYP, MNG_AG_ID, PARK_URL, YR_EST
DES_TP 150
- Local Park 798
- Local Other or Unknown 221
- Local Recreation Area 146
- Local Conservation Area 114
- Local Historic or Cultural Area 21
- Local Resource Management Area 8
- National Forest 2
- National Monument or Landmark 2
- None 1
- State Conservation Area 1
- None 1
- None 1
- None 1
- None 1
- National Recreation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AGENCY 85
- Los Angeles, County of 155
- Santa Barbara, County of 117
- San Diego, County of 117
- Orange, County of 91
- Los Angeles - Department of Parks and Recreation, County of 60
- Lake, County of 56
- Sacramento, County of 55
- Butte, County of 53
- Santa Cruz, County of 51
- Sonoma County Regional Parks Dept., County of 49
- Kern, County of 47
- Monterey, County of 46
- El Dorado, County of 42
- Santa Clara County Parks and Recreation Dept., County of 41
- Riverside, County of 38
- Marin County Parks Department, County of 33
- San Luis Obispo, County of 31
- Placer, County of 28
- San Mateo County Parks and Recreation Dept., County of 24
- Ventura, County of 24
- Stanislaus, County of 24
- San Joaquin, County of 21
- Yolo, County of 18
- Fresno, County of 17
- San Bernardino, County of 17
- Merced, County of 16
- Tulare, County of 15
- San Francisco - Public Utilities Commission, City and County of 14
- Humboldt, County of 12
- Contra Costa County Public Works Dept., County of 11
- Mono, County of 7
- Tehama, County of 7
- Mendocino, County of 7
- Mariposa, County of 6
- Del Norte County Parks, County of 6
- Lassen, County of 6
- Imperial, County of 5
- Napa, County of 5
- Modoc, County of 5
- San Benito, County of 4
- Kings, County of 4
- Yuba, County of 4
- Plumas, County of 4
- East Bay Regional Park District 3
- Contra Costa, County of 3
- Mountains Recreation and Conservation Authority 2
- California Department of Transportation 2
- Long Beach, City of 2
- Santa Clarita, City of 2
- Half Moon Bay, City of 2
- Consumnes Community Services District 2
- Siskiyou, County of 2
- Midpeninsula Regional Open Space District 2
- Tuolumne, County of 2
- Valley Center Water District 2
- Glenn, County of 2
- Amador, County of 2
- Trinity, County of 2
- Sutter, County of 2
- Calaveras, County of 2
- San Diego, City of 1
- San Francisco, City and County of 1
- California Department of Fish and Wildlife 1
- Santa Maria, City of 1
- United States Fish and Wildlife Service 1
- Save the Redwoods League 1
- Valley-Wide Recreation and Park District 1
- Contra Costa Department of Conservation and Development, County of 1
- Cerritos, City of 1
- Desert Recreation District 1
- Torrance, City of 1
- Yolo County Parks, County of 1
- National Audubon Society 1
- Yuima Municipal Water District 1
- Shasta, County of 1
- Humboldt - Public Works Department, County of 1
- Los Angeles Department of Public Works, County of 1
- Orange County Department of Education, County of 1
- Los Angeles County Department of Beaches and Harbors, County of 1
- San Bernardino County Flood Control District 1
- Madera, County of 1
- Marin, County of 1
- Solano, County of 1
- Sierra, County of 1
- Nevada, County of 1
MNG_AG_TYP 13
ACCESS_TYP 4
- Open Access 1,290
- Restricted Access 78
- No Public Access 49
- Unknown Access 37
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12 | 12 | 11 | {"type": "Polygon", "coordinates": [[[-120.70087, 35.73565], [-120.70026, 35.73762], [-120.70033, 35.73765], [-120.69995, 35.73853], [-120.69975, 35.73891], [-120.69913, 35.73992], [-120.6988, 35.73992], [-120.70087, 35.73565]]]} | Open Access 1 | 48 | Rios Caledonia Adobe | 24392 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 3.26 | Rios Caledonia Adobe | None 5 | |||
227 | 227 | 226 | {"type": "MultiPolygon", "coordinates": [[[[-119.78248, 37.95765], [-119.78191, 37.95774], [-119.78114, 37.95783], [-119.78088, 37.95784], [-119.78032, 37.95783], [-119.7788, 37.95773], [-119.77779, 37.95769], [-119.77739, 37.95773], [-119.77684, 37.95775], [-119.77654, 37.95778], [-119.77451, 37.95853], [-119.77303, 37.95905], [-119.77224, 37.95938], [-119.77154, 37.95973], [-119.77095, 37.9601], [-119.77031, 37.9606], [-119.76965, 37.96095], [-119.76909, 37.96116], [-119.76827, 37.96156], [-119.76719, 37.96184], [-119.7603, 37.9612], [-119.76012, 37.96098], [-119.75864, 37.96028], [-119.75808, 37.95992], [-119.75757, 37.95963], [-119.75713, 37.95931], [-119.75672, 37.95906], [-119.75653, 37.95869], [-119.75582, 37.9585], [-119.75505, 37.95834], [-119.75446, 37.95813], [-119.75295, 37.95779], [-119.75197, 37.9575], [-119.75103, 37.95729], [-119.75009, 37.95703], [-119.74941, 37.95675], [-119.74898, 37.95664], [-119.74817, 37.95632], [-119.74784, 37.95604], [-119.74696, 37.95583], [-119.74646, 37.95572], [-119.74605, 37.95559], [-119.74406, 37.95515], [-119.74327, 37.95488], [-119.74253, 37.95468], [-119.74158, 37.95439], [-119.741, 37.95434], [-119.74041, 37.95435], [-119.73979, 37.95428], [-119.73889, 37.95439], [-119.73595, 37.95427], [-119.73595, 37.95391], [-119.74675, 37.95382], [-119.75448, 37.95395], [-119.75458, 37.9576], [-119.7592, 37.9576], [-119.75913, 37.95395], [-119.77308, 37.95392], [-119.77303, 37.95029], [-119.77768, 37.95032], [-119.77759, 37.94668], [-119.78225, 37.94672], [-119.78248, 37.95765]]], [[[-119.81885, 37.92147], [-119.81426, 37.92147], [-119.81426, 37.91421], [-119.81878, 37.91418], [-119.81885, 37.92147]]], [[[-119.84421, 37.96202], [-119.83931, 37.96193], [-119.83906, 37.95843], [-119.83448, 37.95825], [-119.83392, 37.95451], [-119.8388, 37.9546], [-119.83854, 37.95078], [-119.84372, 37.95079], [-119.84421, 37.96202]]], [[[-119.86036, 37.88501], [-119.84605, 37.88385], [-119.84611, 37.88774], [-119.84145, 37.8879], [-119.8413, 37.88039], [-119.84594, 37.88019], [-119.84585, 37.87654], [-119.8589, 37.87761], [-119.86025, 37.87771], [-119.86036, 37.88501]]], [[[-119.87668, 37.9827], [-119.8765, 37.98991], [-119.86682, 37.9901], [-119.86222, 37.99016], [-119.86254, 37.98852], [-119.86222, 37.98852], [-119.86315, 37.98805], [-119.86371, 37.98559], [-119.8637, 37.98558], [-119.86245, 37.98563], [-119.86245, 37.98296], [-119.86269, 37.97934], [-119.87214, 37.97921], [-119.87188, 37.98279], [-119.87668, 37.9827]]], [[[-120.12683, 37.81255], [-120.12681, 37.81333], [-120.1246, 37.81356], [-120.12358, 37.81349], [-120.11945, 37.81378], [-120.11816, 37.81402], [-120.11734, 37.8142], [-120.11595, 37.81463], [-120.11594, 37.81464], [-120.11624, 37.81517], [-120.11584, 37.81586], [-120.11552, 37.81623], [-120.11491, 37.81666], [-120.11067, 37.81676], [-120.11065, 37.81743], [-120.11024, 37.81743], [-120.10924, 37.81763], [-120.10873, 37.8177], [-120.10829, 37.8179], [-120.10831, 37.81866], [-120.10829, 37.8197], [-120.10723, 37.82005], [-120.1037, 37.82007], [-120.10369, 37.81959], [-120.10472, 37.81846], [-120.10506, 37.81819], [-120.1054, 37.81807], [-120.10557, 37.81803], [-120.10586, 37.81803], [-120.1062, 37.81811], [-120.10644, 37.81813], [-120.10674, 37.81812], [-120.10696, 37.81798], [-120.10817, 37.81751], [-120.10876, 37.81735], [-120.10895, 37.81728], [-120.10901, 37.8174], [-120.10927, 37.81734], [-120.11024, 37.81679], [-120.11052, 37.81661], [-120.11262, 37.81588], [-120.11356, 37.81545], [-120.11529, 37.81429], [-120.11538, 37.81417], [-120.11563, 37.814], [-120.11601, 37.81388], [-120.11636, 37.81372], [-120.11735, 37.81337], [-120.11953, 37.81312], [-120.11978, 37.81308], [-120.12037, 37.81291], [-120.12111, 37.81278], [-120.12197, 37.81273], [-120.12525, 37.81259], [-120.12683, 37.81255]]], [[[-120.15014, 37.82682], [-120.14782, 37.8271], [-120.1454, 37.82736], [-120.14411, 37.82748], [-120.14069, 37.82782], [-120.14069, 37.8275], [-120.14087, 37.82751], [-120.14154, 37.82747], [-120.14256, 37.82735], [-120.14749, 37.82689], [-120.15012, 37.8266], [-120.15014, 37.82682]]], [[[-120.17722, 37.83941], [-120.17684, 37.83942], [-120.17605, 37.83901], [-120.17507, 37.83868], [-120.17411, 37.83848], [-120.1733, 37.838], [-120.17323, 37.83688], [-120.17309, 37.83604], [-120.17225, 37.83522], [-120.17193, 37.83439], [-120.17183, 37.83408], [-120.17074, 37.83358], [-120.16942, 37.83328], [-120.16895, 37.83314], [-120.16896, 37.83286], [-120.16925, 37.83291], [-120.1695, 37.83301], [-120.17039, 37.8333], [-120.17157, 37.83356], [-120.17167, 37.83361], [-120.17194, 37.83378], [-120.17211, 37.83399], [-120.17217, 37.83412], [-120.17232, 37.83485], [-120.17239, 37.83502], [-120.17254, 37.83522], [-120.17265, 37.8353], [-120.17336, 37.83597], [-120.17353, 37.83621], [-120.17361, 37.83641], [-120.17364, 37.83654], [-120.17364, 37.83669], [-120.17363, 37.83682], [-120.1736, 37.83691], [-120.17348, 37.83711], [-120.17344, 37.83721], [-120.17342, 37.83728], [-120.17342, 37.83748], [-120.17347, 37.83769], [-120.17355, 37.83783], [-120.17365, 37.83795], [-120.17383, 37.83808], [-120.174, 37.83817], [-120.17484, 37.83834], [-120.17573, 37.83867], [-120.17664, 37.83898], [-120.17692, 37.83914], [-120.17702, 37.83922], [-120.17714, 37.83932], [-120.17722, 37.83941]]], [[[-120.21037, 37.81981], [-120.21034, 37.82012], [-120.20255, 37.82157], [-120.19985, 37.82195], [-120.20219, 37.82485], [-120.20173, 37.82485], [-120.19999, 37.82285], [-120.19998, 37.82287], [-120.20014, 37.82339], [-120.19922, 37.82363], [-120.19953, 37.82399], [-120.19979, 37.82441], [-120.19949, 37.82455], [-120.19901, 37.82447], [-120.1989, 37.82469], [-120.19872, 37.82419], [-120.19882, 37.82368], [-120.19704, 37.82292], [-120.19707, 37.82238], [-120.19657, 37.82229], [-120.19657, 37.82204], [-120.19702, 37.822], [-120.19706, 37.82181], [-120.19861, 37.82166], [-120.19862, 37.82143], [-120.19929, 37.82133], [-120.19937, 37.82165], [-120.20096, 37.82146], [-120.20257, 37.82125], [-120.21037, 37.81981]]], [[[-120.23699, 37.83811], [-120.23636, 37.83847], [-120.23608, 37.8386], [-120.23537, 37.83888], [-120.23469, 37.83909], [-120.23434, 37.83922], [-120.23383, 37.83927], [-120.23374, 37.83925], [-120.23328, 37.83907], [-120.23304, 37.83907], [-120.23286, 37.83912], [-120.23268, 37.83924], [-120.23261, 37.83941], [-120.23255, 37.83967], [-120.23246, 37.83986], [-120.23224, 37.84007], [-120.23213, 37.84013], [-120.23194, 37.84021], [-120.23166, 37.84027], [-120.23156, 37.84027], [-120.23105, 37.84017], [-120.23096, 37.84017], [-120.22998, 37.84046], [-120.22998, 37.84048], [-120.23026, 37.84045], [-120.23022, 37.84099], [-120.22955, 37.84118], [-120.22949, 37.84054], [-120.22896, 37.8407], [-120.22882, 37.84046], [-120.23099, 37.83988], [-120.2312, 37.8399], [-120.23165, 37.83998], [-120.23177, 37.83997], [-120.23195, 37.83991], [-120.23209, 37.83981], [-120.23222, 37.83965], [-120.23224, 37.83945], [-120.23229, 37.83927], [-120.23234, 37.83917], [-120.23247, 37.83901], [-120.23267, 37.83887], [-120.23287, 37.8388], [-120.23299, 37.83877], [-120.23322, 37.83877], [-120.23339, 37.8388], [-120.23347, 37.83882], [-120.23368, 37.83889], [-120.23389, 37.83899], [-120.23397, 37.83901], [-120.234, 37.83907], [-120.23407, 37.83908], [-120.23421, 37.83906], [-120.23433, 37.83903], [-120.23489, 37.83882], [-120.23488, 37.83876], [-120.23597, 37.83833], [-120.23649, 37.83806], [-120.23698, 37.83775], [-120.23699, 37.83811]]], [[[-120.25749, 37.82776], [-120.25721, 37.82808], [-120.25681, 37.82809], [-120.25739, 37.8276], [-120.25749, 37.82776]]], [[[-120.25981, 37.82614], [-120.25924, 37.82696], [-120.25895, 37.82759], [-120.25751, 37.8276], [-120.25747, 37.82751], [-120.25777, 37.82709], [-120.25796, 37.82686], [-120.25825, 37.82645], [-120.25831, 37.8264], [-120.2584, 37.8264], [-120.25848, 37.82636], [-120.2586, 37.82624], [-120.25895, 37.82598], [-120.25981, 37.82614]]], [[[-120.27489, 37.80614], [-120.27406, 37.80726], [-120.27256, 37.80864], [-120.27257, 37.80912], [-120.27216, 37.80916], [-120.2715, 37.81021], [-120.27171, 37.81044], [-120.27472, 37.81163], [-120.27473, 37.81233], [-120.27386, 37.81281], [-120.27232, 37.81374], [-120.2716, 37.81391], [-120.27119, 37.81346], [-120.27105, 37.81333], [-120.27042, 37.81346], [-120.27022, 37.81348], [-120.26932, 37.81365], [-120.26926, 37.81112], [-120.26928, 37.81], [-120.26467, 37.80999], [-120.26435, 37.80997], [-120.26431, 37.80629], [-120.25979, 37.80623], [-120.25979, 37.80548], [-120.25939, 37.80563], [-120.2594, 37.80488], [-120.25964, 37.80477], [-120.25985, 37.8047], [-120.26049, 37.80443], [-120.25943, 37.8026], [-120.26025, 37.80172], [-120.26005, 37.80147], [-120.25993, 37.80124], [-120.25972, 37.80109], [-120.25927, 37.80096], [-120.25927, 37.80071], [-120.25986, 37.80084], [-120.26014, 37.80102], [-120.26031, 37.80124], [-120.26036, 37.8014], [-120.26047, 37.80152], [-120.26189, 37.80062], [-120.26363, 37.7995], [-120.26411, 37.79928], [-120.2642, 37.79922], [-120.26428, 37.80258], [-120.26921, 37.8027], [-120.26922, 37.80246], [-120.26917, 37.79958], [-120.26919, 37.79941], [-120.26982, 37.79945], [-120.26988, 37.80024], [-120.2715, 37.80102], [-120.27278, 37.80276], [-120.27408, 37.80432], [-120.27439, 37.80542], [-120.27489, 37.80614]], [[-120.25998, 37.8061], [-120.26, 37.8061], [-120.26034, 37.80525], [-120.25998, 37.8054], [-120.25998, 37.8061]]], [[[-120.26282, 37.8227], [-120.26236, 37.82261], [-120.26216, 37.82238], [-120.26206, 37.82225], [-120.2619, 37.8221], [-120.26175, 37.82193], [-120.26165, 37.82169], [-120.26165, 37.82162], [-120.26165, 37.82151], [-120.26181, 37.82087], [-120.26215, 37.82087], [-120.26198, 37.82158], [-120.26197, 37.82165], [-120.26198, 37.8217], [-120.26202, 37.8218], [-120.26209, 37.82189], [-120.26227, 37.82206], [-120.26282, 37.8227]]], [[[-120.31147, 37.8132], [-120.31114, 37.81342], [-120.30983, 37.8125], [-120.30943, 37.81245], [-120.30958, 37.81274], [-120.30982, 37.81308], [-120.31022, 37.81349], [-120.31047, 37.81372], [-120.31049, 37.81378], [-120.30985, 37.81322], [-120.30863, 37.81205], [-120.30854, 37.8119], [-120.30841, 37.81145], [-120.30776, 37.81102], [-120.30699, 37.8104], [-120.30573, 37.81221], [-120.30627, 37.8124], [-120.30678, 37.81266], [-120.3072, 37.81318], [-120.30727, 37.81353], [-120.30655, 37.81343], [-120.30653, 37.81291], [-120.30142, 37.81283], [-120.29999, 37.81283], [-120.29887, 37.81286], [-120.29624, 37.8129], [-120.29586, 37.8126], [-120.2954, 37.81227], [-120.29312, 37.81041], [-120.29215, 37.80964], [-120.29207, 37.8097], [-120.29201, 37.80912], [-120.28667, 37.80904], [-120.28715, 37.81262], [-120.27683, 37.81248], [-120.27681, 37.80891], [-120.28132, 37.80898], [-120.28171, 37.80897], [-120.28172, 37.80895], [-120.28146, 37.80542], [-120.27675, 37.80535], [-120.27671, 37.80178], [-120.27701, 37.8018], [-120.28035, 37.80181], [-120.28129, 37.80185], [-120.28129, 37.801], [-120.28142, 37.80089], [-120.28156, 37.80081], [-120.28134, 37.80051], [-120.28269, 37.80025], [-120.2831, 37.80016], [-120.28244, 37.79947], [-120.28142, 37.79968], [-120.28114, 37.79831], [-120.28522, 37.79834], [-120.29614, 37.79847], [-120.29652, 37.79846], [-120.297, 37.79848], [-120.29725, 37.80562], [-120.30179, 37.80569], [-120.30176, 37.8074], [-120.30751, 37.80732], [-120.30856, 37.80739], [-120.30862, 37.8106], [-120.30975, 37.81069], [-120.31111, 37.81148], [-120.31147, 37.8132]], [[-120.29232, 37.80261], [-120.2914, 37.80229], [-120.29121, 37.80238], [-120.29098, 37.80252], [-120.29194, 37.80319], [-120.29254, 37.80279], [-120.29232, 37.80261]]], [[[-120.32796, 37.80551], [-120.3276, 37.80556], [-120.32758, 37.80528], [-120.32794, 37.80525], [-120.32796, 37.80551]]], [[[-120.4079, 37.79822], [-120.40753, 37.79825], [-120.40687, 37.79827], [-120.40677, 37.79754], [-120.40774, 37.79766], [-120.40778, 37.79759], [-120.40783, 37.79723], [-120.40781, 37.79697], [-120.40774, 37.79667], [-120.40756, 37.79638], [-120.40741, 37.7962], [-120.40723, 37.79605], [-120.40707, 37.79593], [-120.40743, 37.7959], [-120.40755, 37.79597], [-120.40772, 37.79613], [-120.40792, 37.79639], [-120.40803, 37.7966], [-120.40808, 37.79666], [-120.40816, 37.79688], [-120.40819, 37.79704], [-120.40821, 37.79736], [-120.40821, 37.79744], [-120.40817, 37.79766], [-120.4081, 37.79787], [-120.4079, 37.79822]]], [[[-120.5453, 37.8063], [-120.54393, 37.8097], [-120.54171, 37.80978], [-120.54178, 37.80813], [-120.53933, 37.80807], [-120.53929, 37.80704], [-120.5418, 37.80706], [-120.54182, 37.80634], [-120.5453, 37.8063]]], [[[-120.60815, 37.79881], [-120.60113, 37.80196], [-120.60157, 37.8032], [-120.59639, 37.8047], [-120.59213, 37.80472], [-120.59216, 37.80257], [-120.60009, 37.79989], [-120.60088, 37.80139], [-120.60752, 37.79831], [-120.60815, 37.79881]]]]} | Restricted Access 2 | 616 | Hetch Hetchy Water and Power | 19888 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | Tuolumne 21 | 2706.955 | Hetch Hetchy Water and Power | None 25 | |||
284 | 284 | 283 | {"type": "Polygon", "coordinates": [[[-116.4753, 32.60867], [-116.47487, 32.60888], [-116.47435, 32.60914], [-116.47431, 32.60887], [-116.47465, 32.60861], [-116.47505, 32.60838], [-116.4753, 32.60867]]]} | Open Access 1 | 766 | Campo Stone Store | 29229 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://ohp.parks.ca.gov/ListedResources/Detail/411 | San Diego 4 | 0.82 | Campo Stone Store | None 31 | ||
436 | 436 | 435 | {"type": "MultiPolygon", "coordinates": [[[[-122.50735, 38.11473], [-122.50721, 38.11477], [-122.50708, 38.11492], [-122.50687, 38.11486], [-122.50673, 38.11475], [-122.50645, 38.11496], [-122.50608, 38.11467], [-122.50597, 38.11454], [-122.5062, 38.11444], [-122.50605, 38.11434], [-122.50643, 38.1142], [-122.50655, 38.11334], [-122.50673, 38.11403], [-122.50667, 38.11408], [-122.50674, 38.11407], [-122.50688, 38.11442], [-122.5068, 38.1145], [-122.50682, 38.11454], [-122.50703, 38.11464], [-122.50716, 38.11469], [-122.50735, 38.11473]]], [[[-122.50745, 38.11324], [-122.50722, 38.11345], [-122.50723, 38.11346], [-122.50737, 38.11346], [-122.50737, 38.11352], [-122.50703, 38.11382], [-122.50688, 38.11383], [-122.50682, 38.11385], [-122.50685, 38.11358], [-122.50677, 38.11331], [-122.50745, 38.11324]]]]} | Open Access 1 | 840 | Black Point Boat Launch | 16137 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 2.255 | Black Point Boat Launch | None 45 | |||
565 | 565 | 564 | {"type": "Polygon", "coordinates": [[[-121.91485, 37.97467], [-121.91485, 37.97489], [-121.91456, 37.9751], [-121.91431, 37.97535], [-121.9141, 37.97553], [-121.91345, 37.97542], [-121.91287, 37.97544], [-121.91255, 37.97534], [-121.91197, 37.97514], [-121.91169, 37.9751], [-121.9116, 37.97515], [-121.91148, 37.97518], [-121.91136, 37.97514], [-121.91103, 37.97515], [-121.9109, 37.97496], [-121.91122, 37.97496], [-121.91189, 37.97489], [-121.91232, 37.9749], [-121.91233, 37.97492], [-121.91345, 37.97494], [-121.91408, 37.97484], [-121.91485, 37.97467]]]} | No Public Access 3 | 47528 | Alaimo | 31233 | 379 | Contra Costa Department of Conservation and Development, County of 209 | County 3 | County Agency - Other 9 | http://www.cccounty.us/dcd | County 3 | 379 | Contra Costa Department of Conservation and Development, County of 205 | County 3 | County Agency - Other 8 | Contra Costa 12 | 3.763 | Alaimo | None 56 | |||
862 | 862 | 861 | {"type": "MultiPolygon", "coordinates": [[[[-122.44333, 37.73556], [-122.44313, 37.73558], [-122.44241, 37.73578], [-122.44241, 37.73539], [-122.44331, 37.73537], [-122.44333, 37.73556]]], [[[-122.44368, 37.73938], [-122.44259, 37.73944], [-122.44255, 37.73931], [-122.44256, 37.73921], [-122.44259, 37.73912], [-122.44267, 37.73868], [-122.44269, 37.73845], [-122.44264, 37.73816], [-122.44246, 37.73767], [-122.44246, 37.73757], [-122.44249, 37.73744], [-122.44257, 37.73728], [-122.44269, 37.73716], [-122.44346, 37.73669], [-122.44358, 37.7381], [-122.44349, 37.73818], [-122.44344, 37.73829], [-122.44338, 37.73885], [-122.44341, 37.73894], [-122.44347, 37.73903], [-122.44356, 37.73911], [-122.44367, 37.73917], [-122.44368, 37.73938]]], [[[-122.44373, 37.73995], [-122.44352, 37.73987], [-122.44296, 37.73975], [-122.44281, 37.73967], [-122.44271, 37.7396], [-122.4437, 37.73954], [-122.44373, 37.73995]]], [[[-122.44456, 37.74017], [-122.44413, 37.74021], [-122.44402, 37.74012], [-122.44397, 37.7396], [-122.44443, 37.73996], [-122.44456, 37.74017]]], [[[-122.44606, 37.74084], [-122.44535, 37.74089], [-122.44491, 37.74082], [-122.44474, 37.74076], [-122.44454, 37.74065], [-122.44437, 37.7405], [-122.44425, 37.74033], [-122.44464, 37.7403], [-122.4448, 37.74057], [-122.4449, 37.74061], [-122.44511, 37.74067], [-122.44576, 37.74076], [-122.44606, 37.74084]]], [[[-122.44842, 37.74265], [-122.44711, 37.74253], [-122.44681, 37.74245], [-122.44656, 37.74233], [-122.44641, 37.74222], [-122.4463, 37.74206], [-122.44626, 37.74193], [-122.44622, 37.7415], [-122.44617, 37.74137], [-122.44609, 37.74122], [-122.44609, 37.74118], [-122.4462, 37.74109], [-122.44632, 37.74106], [-122.44643, 37.74117], [-122.44652, 37.74132], [-122.44657, 37.74144], [-122.4466, 37.74158], [-122.44659, 37.74176], [-122.44665, 37.74191], [-122.44677, 37.74209], [-122.44687, 37.74219], [-122.44699, 37.74227], [-122.44714, 37.74234], [-122.4473, 37.74235], [-122.44731, 37.74229], [-122.44768, 37.74232], [-122.44765, 37.7425], [-122.44842, 37.74257], [-122.44842, 37.74265]]], [[[-122.44946, 37.74283], [-122.44941, 37.7429], [-122.44925, 37.74282], [-122.44905, 37.74275], [-122.44863, 37.74267], [-122.44863, 37.74259], [-122.44905, 37.74267], [-122.44926, 37.74274], [-122.44946, 37.74283]]], [[[-122.45165, 37.74524], [-122.45158, 37.74527], [-122.45152, 37.74525], [-122.45075, 37.74432], [-122.45075, 37.74419], [-122.45081, 37.74427], [-122.45083, 37.74426], [-122.45083, 37.74424], [-122.45093, 37.74441], [-122.45165, 37.74524]]]]} | Open Access 1 | 5544 | Reservoir Lands (Glen Park) | 24301 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | San Francisco 13 | 10.112 | Reservoir Lands (Glen Park) | None 79 | |||
1088 | 1088 | 1087 | {"type": "Polygon", "coordinates": [[[-118.66774, 34.09258], [-118.6677, 34.09531], [-118.66548, 34.0953], [-118.66549, 34.09463], [-118.66547, 34.09257], [-118.66774, 34.09258]]]} | Open Access 1 | 6487 | Cold Creek Canyon | 29017 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 15.438 | Cold Creek Canyon | None 99 | |||
1400 | 1400 | 1399 | {"type": "Polygon", "coordinates": [[[-119.87288, 34.43682], [-119.8723, 34.43682], [-119.87211, 34.43667], [-119.872, 34.43654], [-119.87193, 34.43639], [-119.8719, 34.43628], [-119.87195, 34.43605], [-119.87205, 34.43605], [-119.87221, 34.43614], [-119.87248, 34.4365], [-119.87277, 34.43651], [-119.87288, 34.43682]]]} | Open Access 1 | 16492 | Glen Annie at Del Norte | 19314 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 0.987 | Glen Annie at Del Norte | None 119 | |||
1584 | 1584 | 1583 | {"type": "Polygon", "coordinates": [[[-117.09349, 33.56898], [-117.0926, 33.57066], [-117.08388, 33.57076], [-117.08394, 33.56909], [-117.09349, 33.56898]]]} | Unknown Access 4 | 12140 | French Valley Conservation Area, Expansion 1 | 19108 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 38.849 | French Valley Conservation Area, Expansion 1 | None 128 | |||
1614 | 1614 | 1613 | {"type": "Polygon", "coordinates": [[[-118.65024, 34.1181], [-118.65024, 34.11939], [-118.6502, 34.12172], [-118.64565, 34.1217], [-118.64568, 34.1181], [-118.65024, 34.1181]]]} | Open Access 1 | 12332 | Secret Valley | 32667 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 41.753 | Secret Valley | None 129 | |||
2071 | 2071 | 2070 | {"type": "MultiPolygon", "coordinates": [[[[-119.89262, 34.43884], [-119.89269, 34.43916], [-119.89271, 34.4395], [-119.8927, 34.43963], [-119.89265, 34.43988], [-119.89261, 34.4399], [-119.89232, 34.4398], [-119.89214, 34.43966], [-119.89204, 34.43955], [-119.89163, 34.43896], [-119.89154, 34.43885], [-119.89133, 34.43865], [-119.89101, 34.43845], [-119.89073, 34.43834], [-119.89043, 34.43827], [-119.89028, 34.43826], [-119.88921, 34.43829], [-119.88894, 34.43834], [-119.88879, 34.4384], [-119.88854, 34.43802], [-119.88821, 34.43768], [-119.88786, 34.43766], [-119.88737, 34.43779], [-119.8877, 34.43814], [-119.88789, 34.4383], [-119.88793, 34.43836], [-119.888, 34.43839], [-119.8881, 34.4384], [-119.88817, 34.43844], [-119.88764, 34.43883], [-119.88746, 34.43904], [-119.88774, 34.43919], [-119.88766, 34.43931], [-119.88757, 34.43951], [-119.88754, 34.43952], [-119.88704, 34.43953], [-119.88708, 34.4393], [-119.88708, 34.43889], [-119.8874, 34.43825], [-119.88673, 34.43805], [-119.88627, 34.43734], [-119.88582, 34.43694], [-119.88519, 34.43694], [-119.88516, 34.43552], [-119.88529, 34.43552], [-119.88647, 34.43593], [-119.88718, 34.43652], [-119.89012, 34.43693], [-119.89012, 34.43702], [-119.88961, 34.437], [-119.88989, 34.43746], [-119.89066, 34.43751], [-119.89169, 34.43778], [-119.89209, 34.4381], [-119.8921, 34.43842], [-119.89218, 34.43853], [-119.8923, 34.43889], [-119.89262, 34.43884]]], [[[-119.88793, 34.44143], [-119.88788, 34.44135], [-119.88786, 34.44123], [-119.88781, 34.44124], [-119.88781, 34.44143], [-119.88746, 34.44144], [-119.88744, 34.44058], [-119.88687, 34.44047], [-119.88701, 34.43969], [-119.88749, 34.43967], [-119.88754, 34.4397], [-119.88757, 34.43995], [-119.88763, 34.44013], [-119.88767, 34.44021], [-119.88793, 34.44059], [-119.88803, 34.44081], [-119.88807, 34.44093], [-119.88815, 34.4414], [-119.88811, 34.44143], [-119.88793, 34.44143]]]]} | Open Access 1 | 15735 | Evergreen Acres | 18765 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 28.758 | Evergreen Acres | None 163 | |||
2408 | 2408 | 2407 | {"type": "Polygon", "coordinates": [[[-121.0023, 37.25798], [-121.00198, 37.25807], [-121.00186, 37.25773], [-121.00217, 37.25766], [-121.0023, 37.25798]]]} | Open Access 1 | 17242 | Library | 21216 | 308 | Merced, County of 476 | County 3 | County Agency 3 | http://www.co.merced.ca.us/index.aspx?NID=757 | County 3 | 308 | Merced, County of 469 | County 3 | County Agency 3 | Merced 37 | 0.28 | Library | None 201 | |||
2535 | 2535 | 2534 | {"type": "Polygon", "coordinates": [[[-119.88382, 34.43947], [-119.88316, 34.43948], [-119.88316, 34.43906], [-119.88317, 34.43903], [-119.8832, 34.43902], [-119.88379, 34.43902], [-119.88381, 34.43905], [-119.88382, 34.43947]]]} | Open Access 1 | 17758 | Bella Vista III | 15978 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 0.76 | Bella Vista III | None 208 | |||
2752 | 2752 | 2751 | {"type": "Polygon", "coordinates": [[[-121.26584, 38.41176], [-121.26406, 38.41179], [-121.26392, 38.41155], [-121.26373, 38.41107], [-121.26365, 38.41082], [-121.2645, 38.41003], [-121.26465, 38.41], [-121.26491, 38.41005], [-121.26516, 38.4102], [-121.26531, 38.41033], [-121.2654, 38.41046], [-121.26549, 38.41072], [-121.26554, 38.41094], [-121.26582, 38.41152], [-121.26584, 38.41165], [-121.26584, 38.41176]]]} | Unknown Access 4 | 21481 | Green Rd Subdivision Map | 19466 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 6.621 | Green Rd Subdivision Map | None 230 | |||
2827 | 2827 | 2826 | {"type": "Polygon", "coordinates": [[[-123.35157, 38.74579], [-123.34595, 38.75146], [-123.34467, 38.75147], [-123.34463, 38.75104], [-123.34467, 38.75081], [-123.34467, 38.75048], [-123.3446, 38.74979], [-123.34462, 38.74965], [-123.34469, 38.74948], [-123.3448, 38.74935], [-123.34489, 38.74928], [-123.34501, 38.74924], [-123.34538, 38.74919], [-123.34563, 38.74912], [-123.34655, 38.74867], [-123.34697, 38.74845], [-123.34716, 38.74831], [-123.34759, 38.74796], [-123.34798, 38.74758], [-123.34816, 38.74738], [-123.34831, 38.74715], [-123.34849, 38.74679], [-123.34856, 38.74646], [-123.34856, 38.74625], [-123.34862, 38.74602], [-123.34891, 38.74524], [-123.34929, 38.74454], [-123.34942, 38.74438], [-123.34971, 38.74414], [-123.34987, 38.74391], [-123.34991, 38.74379], [-123.34994, 38.74357], [-123.34999, 38.74332], [-123.35017, 38.74288], [-123.35041, 38.74316], [-123.35054, 38.74344], [-123.35061, 38.74351], [-123.35068, 38.74355], [-123.35115, 38.74372], [-123.35137, 38.74388], [-123.35177, 38.74439], [-123.35189, 38.7446], [-123.35193, 38.74474], [-123.3519, 38.74493], [-123.35179, 38.74512], [-123.35157, 38.74535], [-123.35157, 38.74579]]]} | Open Access 1 | 950 | Soda Springs | 25589 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 43.51 | Soda Springs | None 234 | |||
2870 | 2870 | 2869 | {"type": "Polygon", "coordinates": [[[-121.26253, 38.63482], [-121.26223, 38.63496], [-121.26189, 38.63458], [-121.26213, 38.63445], [-121.26232, 38.63458], [-121.26253, 38.63482]]]} | Open Access 1 | 22211 | County Of Sacramento | 17713 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 0.387 | County Of Sacramento | None 238 | |||
2871 | 2871 | 2870 | {"type": "Polygon", "coordinates": [[[-121.35463, 38.5704], [-121.35403, 38.57048], [-121.35403, 38.57049], [-121.35418, 38.57064], [-121.35335, 38.57103], [-121.35193, 38.56789], [-121.3508, 38.56544], [-121.35129, 38.5652], [-121.35141, 38.56534], [-121.35162, 38.56568], [-121.35254, 38.56755], [-121.35262, 38.56769], [-121.35291, 38.56809], [-121.35322, 38.56887], [-121.35369, 38.5699], [-121.35378, 38.57004], [-121.354, 38.57024], [-121.35417, 38.57033], [-121.3544, 38.5704], [-121.35463, 38.5704]]]} | Open Access 1 | 22213 | County Of Sacramento | 17713 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 10.921 | County Of Sacramento | None 239 | |||
2876 | 2876 | 2875 | {"type": "Polygon", "coordinates": [[[-121.25202, 38.40904], [-121.25157, 38.40901], [-121.25157, 38.40891], [-121.25154, 38.40884], [-121.25164, 38.40866], [-121.25175, 38.40863], [-121.25192, 38.40869], [-121.25202, 38.40883], [-121.25202, 38.40904]]]} | Unknown Access 4 | 22243 | Schnabel Tentative Parcel Map | 25185 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 0.366 | Schnabel Tentative Parcel Map | None 240 | |||
2877 | 2877 | 2876 | {"type": "Polygon", "coordinates": [[[-121.2872, 38.42303], [-121.28685, 38.42315], [-121.28643, 38.42337], [-121.28619, 38.42353], [-121.2858, 38.42385], [-121.28542, 38.42359], [-121.28471, 38.42421], [-121.28261, 38.42406], [-121.28154, 38.42496], [-121.28143, 38.42489], [-121.28175, 38.42462], [-121.28187, 38.42447], [-121.28205, 38.42431], [-121.28253, 38.42403], [-121.28272, 38.42397], [-121.28303, 38.42393], [-121.28323, 38.42385], [-121.28393, 38.42367], [-121.28429, 38.4236], [-121.28452, 38.42349], [-121.28487, 38.42338], [-121.28505, 38.42325], [-121.28543, 38.42302], [-121.286, 38.42263], [-121.28628, 38.42252], [-121.28663, 38.42231], [-121.2872, 38.42303]]]} | Restricted Access 2 | 22244 | Preston Hanford | 23996 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 6.909 | Preston Hanford | None 241 | |||
3103 | 3103 | 3102 | {"type": "Polygon", "coordinates": [[[-121.19386, 38.68632], [-121.1938, 38.68658], [-121.19368, 38.68675], [-121.19349, 38.68696], [-121.19364, 38.68726], [-121.19279, 38.68725], [-121.19296, 38.68688], [-121.19322, 38.68659], [-121.19337, 38.68648], [-121.19386, 38.68632]]]} | Open Access 1 | 21437 | Hennemen | 19819 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 1.241 | Hennemen | None 252 |
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]);