units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
64 rows where ACCESS_TYP = 2 and MNG_AG_TYP = 4 sorted by AGNCY_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, COUNTY, YR_EST, GAP_STS
MNG_AGENCY 20
- East Bay Regional Park District 19
- Sonoma County Agricultural Preservation and Open Space District 8
- Hayward Area Recreation and Park District 7
- Monterey Peninsula Regional Park District 4
- Santa Clara Valley Open Space Authority 4
- Conejo Recreation and Park District 3
- Livermore Area Recreation and Park District 3
- Rancho Simi Recreation and Park District 2
- Southgate Recreation and Park District 2
- Midpeninsula Regional Open Space District 2
- Napa County Regional Park and Open Space District 1
- Valley-Wide Recreation and Park District 1
- Coalinga-Huron Recreation and Park District 1
- Desert Recreation District 1
- Greater Vallejo Recreation and Park District 1
- Mendocino Coast Recreation and Park District 1
- North County Recreation and Park District 1
- Arcade Creek Recreation and Park District 1
- Tuolumne Park and Recreation District 1
- San Dimas-La Verne Recreational Facilities Authority 1
DES_TP 20
- Local Park 18
- Local Conservation Area 16
- Local Recreation Area 9
- Local Other or Unknown 4
- Local Resource Management Area 2
- Local Historic or Cultural 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
PARK_URL 7 ✖
- http://www.ebparks.org/parks/eastshore 2
- http://www.chrpd.org/summer-camp.html 1
- http://www.gvrd.org/?page=Glen_Cove_School_Park 1
- http://www.openspaceauthority.org 1
- http://www.sonomaopenspace.org/Content/?p=10096/preview.html 1
- https://www.thefirstteecoachellavalley.org/locations/the-golf-center-at-palm-desert/ 1
- https://www.tuolumnerecreation.com/TPRD_facilities.html 1
MNG_AG_TYP 1
- Recreation/Parks District · 64 ✖
ACCESS_TYP 1
- Restricted Access · 64 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3734 | 3734 | 3733 | {"type": "MultiPolygon", "coordinates": [[[[-122.31785, 37.90207], [-122.31749, 37.90263], [-122.3175, 37.90285], [-122.31661, 37.90177], [-122.31604, 37.90104], [-122.31593, 37.90086], [-122.31581, 37.90061], [-122.31574, 37.90032], [-122.31575, 37.90024], [-122.31577, 37.90016], [-122.31585, 37.90005], [-122.31596, 37.89998], [-122.31612, 37.89993], [-122.31785, 37.90207]]], [[[-122.31976, 37.90599], [-122.31923, 37.906], [-122.3171, 37.90343], [-122.31757, 37.90318], [-122.31802, 37.90409], [-122.31829, 37.90458], [-122.31976, 37.90599]]]]} | Restricted Access 2 | 113 | McLaughlin Eastshore State Park | 29198 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/eastshore | Contra Costa 12 | 7.835 | McLaughlin Eastshore SP | None 312 | ||
12466 | 12466 | 12465 | {"type": "Polygon", "coordinates": [[[-122.31807, 37.82977], [-122.3145, 37.83558], [-122.31384, 37.83676], [-122.31367, 37.83701], [-122.30448, 37.837], [-122.30448, 37.83642], [-122.30311, 37.83642], [-122.3031, 37.83648], [-122.30259, 37.83653], [-122.3021, 37.83672], [-122.30152, 37.83669], [-122.30051, 37.83676], [-122.29922, 37.83705], [-122.29895, 37.83704], [-122.29802, 37.83651], [-122.29744, 37.83499], [-122.29694, 37.83457], [-122.29688, 37.8339], [-122.29615, 37.83373], [-122.29546, 37.83375], [-122.29554, 37.83363], [-122.29611, 37.83345], [-122.29659, 37.83311], [-122.29672, 37.8329], [-122.29619, 37.83224], [-122.29627, 37.83193], [-122.29587, 37.83155], [-122.29613, 37.83127], [-122.29629, 37.83082], [-122.29615, 37.83062], [-122.29632, 37.83055], [-122.29641, 37.83044], [-122.29629, 37.83016], [-122.29573, 37.82964], [-122.29595, 37.82963], [-122.29654, 37.82997], [-122.29727, 37.83023], [-122.29786, 37.83006], [-122.29816, 37.83018], [-122.2983, 37.82971], [-122.2982, 37.82942], [-122.29796, 37.82915], [-122.29825, 37.82843], [-122.29849, 37.82846], [-122.29865, 37.82825], [-122.29901, 37.82821], [-122.29925, 37.8278], [-122.30112, 37.82678], [-122.3011, 37.82645], [-122.30548, 37.82556], [-122.30748, 37.82592], [-122.30868, 37.82589], [-122.31807, 37.82977]]]} | Restricted Access 2 | 28130 | McLaughlin Eastshore State Park | 29198 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/eastshore | Alameda 17 | 456.308 | McLaughlin Eastshore SP | None 1084 | ||
12606 | 12606 | 12605 | {"type": "MultiPolygon", "coordinates": [[[[-122.31376, 37.89702], [-122.31276, 37.89724], [-122.3125, 37.89694], [-122.31163, 37.89607], [-122.31036, 37.89455], [-122.31003, 37.89409], [-122.30983, 37.89374], [-122.30966, 37.89338], [-122.30945, 37.89281], [-122.30928, 37.89225], [-122.30916, 37.89226], [-122.30913, 37.89207], [-122.30909, 37.89161], [-122.3091, 37.89106], [-122.30915, 37.89066], [-122.3093, 37.8898], [-122.30997, 37.89189], [-122.31013, 37.89227], [-122.31036, 37.89272], [-122.31064, 37.89313], [-122.31376, 37.89702]]], [[[-122.32444, 37.89221], [-122.32262, 37.89493], [-122.32102, 37.89532], [-122.32101, 37.89498], [-122.31872, 37.89504], [-122.31871, 37.89587], [-122.31644, 37.89642], [-122.31394, 37.89698], [-122.31081, 37.89309], [-122.31056, 37.89272], [-122.31042, 37.89247], [-122.31022, 37.89207], [-122.31011, 37.89177], [-122.30943, 37.88963], [-122.30934, 37.88963], [-122.30949, 37.88875], [-122.30955, 37.8886], [-122.30959, 37.88857], [-122.30966, 37.88854], [-122.30979, 37.88855], [-122.30993, 37.88863], [-122.31022, 37.88909], [-122.31037, 37.88923], [-122.31047, 37.88963], [-122.31333, 37.88964], [-122.31334, 37.88985], [-122.312, 37.88997], [-122.31197, 37.89022], [-122.31394, 37.8917], [-122.31624, 37.89169], [-122.31634, 37.8909], [-122.31763, 37.89086], [-122.31991, 37.88993], [-122.32312, 37.8899], [-122.32356, 37.8913], [-122.32409, 37.89131], [-122.32444, 37.89221]]]]} | Restricted Access 2 | 29272 | Albany State Marine Reserve | 30562 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 181.83 | Albany State Marine Reserve | 1985 | None 1092 | ||
12997 | 12997 | 12996 | {"type": "Polygon", "coordinates": [[[-122.3031, 37.83648], [-122.3031, 37.837], [-122.30105, 37.837], [-122.2977, 37.83767], [-122.29768, 37.83765], [-122.29741, 37.8377], [-122.29731, 37.83767], [-122.2972, 37.83753], [-122.29701, 37.83713], [-122.29573, 37.83491], [-122.29545, 37.83431], [-122.29554, 37.83429], [-122.29554, 37.83428], [-122.2955, 37.83419], [-122.29541, 37.83422], [-122.29463, 37.83251], [-122.29457, 37.8323], [-122.29463, 37.83228], [-122.29454, 37.83192], [-122.29448, 37.83192], [-122.29442, 37.83131], [-122.29443, 37.83091], [-122.29455, 37.82968], [-122.29459, 37.82943], [-122.29471, 37.82908], [-122.29486, 37.82876], [-122.29532, 37.82895], [-122.2954, 37.82883], [-122.29539, 37.82882], [-122.29494, 37.82864], [-122.29515, 37.82836], [-122.29537, 37.82813], [-122.29566, 37.82789], [-122.29604, 37.82765], [-122.2964, 37.82748], [-122.29679, 37.82734], [-122.29713, 37.82725], [-122.3011, 37.82645], [-122.30112, 37.82678], [-122.29925, 37.8278], [-122.29901, 37.82821], [-122.29865, 37.82825], [-122.29849, 37.82846], [-122.29825, 37.82844], [-122.29796, 37.82915], [-122.2982, 37.82942], [-122.2983, 37.82971], [-122.29816, 37.83018], [-122.29786, 37.83006], [-122.29727, 37.83023], [-122.29654, 37.82997], [-122.29596, 37.82963], [-122.29574, 37.82964], [-122.29629, 37.83016], [-122.29641, 37.83044], [-122.29632, 37.83055], [-122.29616, 37.83062], [-122.29629, 37.83081], [-122.29613, 37.83127], [-122.29587, 37.83155], [-122.29628, 37.83193], [-122.29619, 37.83224], [-122.29672, 37.8329], [-122.29659, 37.83311], [-122.29611, 37.83345], [-122.29554, 37.83363], [-122.29547, 37.83374], [-122.29615, 37.83373], [-122.29688, 37.8339], [-122.29694, 37.83457], [-122.29744, 37.83499], [-122.29802, 37.83651], [-122.29895, 37.83704], [-122.29922, 37.83705], [-122.30051, 37.83676], [-122.30152, 37.83669], [-122.3021, 37.83672], [-122.30259, 37.83653], [-122.3031, 37.83648]]]} | Restricted Access 2 | 46940 | Emeryville Crescent State Marine Reserve | 30564 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 58.981 | Emeryville Crescent State Marine Reserve | 1985 | None 1127 | ||
16836 | 16836 | 16835 | {"type": "Polygon", "coordinates": [[[-121.88013, 38.03876], [-121.8799, 38.03947], [-121.87888, 38.03985], [-121.87938, 38.04057], [-121.87831, 38.04152], [-121.87674, 38.04095], [-121.8754, 38.04202], [-121.87585, 38.04277], [-121.87563, 38.04308], [-121.87538, 38.04357], [-121.87321, 38.04374], [-121.87163, 38.04436], [-121.86986, 38.04524], [-121.86868, 38.04556], [-121.86677, 38.04663], [-121.86586, 38.04647], [-121.86463, 38.04548], [-121.86456, 38.04549], [-121.86457, 38.04022], [-121.869, 38.04023], [-121.86901, 38.03651], [-121.86606, 38.03563], [-121.85991, 38.03561], [-121.85989, 38.04021], [-121.8644, 38.04022], [-121.86438, 38.04552], [-121.8629, 38.0458], [-121.86169, 38.04609], [-121.86089, 38.04681], [-121.86099, 38.04761], [-121.86205, 38.04829], [-121.86179, 38.04832], [-121.86114, 38.04802], [-121.86065, 38.04767], [-121.86064, 38.04741], [-121.86029, 38.04715], [-121.85877, 38.04615], [-121.85643, 38.04435], [-121.85513, 38.04328], [-121.85323, 38.04205], [-121.85256, 38.04052], [-121.85138, 38.03899], [-121.85147, 38.03731], [-121.85092, 38.03582], [-121.85024, 38.03499], [-121.85207, 38.03389], [-121.85368, 38.03368], [-121.85526, 38.03272], [-121.85876, 38.03221], [-121.8607, 38.03229], [-121.86306, 38.03258], [-121.86702, 38.03277], [-121.86921, 38.03335], [-121.87099, 38.03432], [-121.87408, 38.03568], [-121.87734, 38.03749], [-121.87896, 38.03836], [-121.88013, 38.03876]]]} | Restricted Access 2 | 3883 | Browns Island Regional Shoreline | 16445 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 600.69 | Browns Island Reg. Shoreline | 0 | Local Park 2 | 4 | |
15409 | 15409 | 15408 | {"type": "Polygon", "coordinates": [[[-121.74686, 37.21397], [-121.74675, 37.21408], [-121.74406, 37.21175], [-121.74273, 37.21269], [-121.74273, 37.2127], [-121.74574, 37.2153], [-121.74476, 37.21633], [-121.74487, 37.21644], [-121.74242, 37.21804], [-121.73356, 37.21042], [-121.73299, 37.2099], [-121.73292, 37.20993], [-121.72971, 37.20676], [-121.73058, 37.20587], [-121.73123, 37.20514], [-121.73217, 37.20435], [-121.73262, 37.20404], [-121.73268, 37.20403], [-121.73275, 37.20405], [-121.73301, 37.20386], [-121.733, 37.2038], [-121.73303, 37.20375], [-121.73596, 37.20169], [-121.73672, 37.20173], [-121.74017, 37.2049], [-121.74035, 37.2051], [-121.74145, 37.20611], [-121.74142, 37.20618], [-121.74165, 37.20638], [-121.74173, 37.20637], [-121.7461, 37.21033], [-121.74654, 37.21065], [-121.74691, 37.21362], [-121.74686, 37.21397]]]} | Restricted Access 2 | 49043 | Northern Coyote Valley Conservation Area | 33748 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | Santa Clara 19 | 326.66 | Northern Coyote Valley Conservation Area | 0 | Local Conservation Area 4 | 2 | |
11153 | 11153 | 11152 | {"type": "Polygon", "coordinates": [[[-121.10356, 35.5738], [-121.10179, 35.57384], [-121.10119, 35.57384], [-121.10054, 35.57387], [-121.09924, 35.57387], [-121.09902, 35.57318], [-121.09914, 35.57271], [-121.10097, 35.57256], [-121.10236, 35.57248], [-121.10249, 35.57245], [-121.1025, 35.57244], [-121.10277, 35.57241], [-121.10277, 35.57237], [-121.10292, 35.57236], [-121.10293, 35.5724], [-121.10319, 35.57293], [-121.10356, 35.5738]]]} | Restricted Access 2 | 48691 | Camp Yeager | 33430 | 2021 | Coalinga-Huron Recreation and Park District 275 | Special District 4 | Recreation/Parks District 4 | http://www.chrpd.org/ | Special District 4 | 2021 | Coalinga-Huron Recreation and Park District 270 | Special District 4 | Recreation/Parks District 4 | http://www.chrpd.org/summer-camp.html | San Luis Obispo 1 | 13.378 | Camp Yeager | None 974 | ||
4981 | 4981 | 4980 | {"type": "Polygon", "coordinates": [[[-118.86601, 34.24605], [-118.86522, 34.24588], [-118.86449, 34.24562], [-118.8641, 34.24534], [-118.86386, 34.24503], [-118.86363, 34.24453], [-118.86337, 34.24383], [-118.8629, 34.24116], [-118.86291, 34.24008], [-118.86269, 34.23963], [-118.8625, 34.23963], [-118.86212, 34.24004], [-118.86184, 34.24115], [-118.86166, 34.24164], [-118.86142, 34.24204], [-118.86109, 34.2424], [-118.86029, 34.24304], [-118.86001, 34.24322], [-118.85893, 34.24344], [-118.85787, 34.24342], [-118.85677, 34.24345], [-118.85552, 34.24377], [-118.85491, 34.24409], [-118.85445, 34.24414], [-118.85382, 34.24395], [-118.85335, 34.24361], [-118.85305, 34.24322], [-118.85238, 34.24315], [-118.85209, 34.24331], [-118.85209, 34.24376], [-118.85198, 34.24435], [-118.85229, 34.24447], [-118.85308, 34.24441], [-118.85356, 34.24447], [-118.85435, 34.2448], [-118.85472, 34.24505], [-118.85521, 34.24539], [-118.85582, 34.24601], [-118.85907, 34.24557], [-118.85908, 34.24601], [-118.86183, 34.24698], [-118.86183, 34.24704], [-118.86135, 34.24737], [-118.86071, 34.24737], [-118.85901, 34.24664], [-118.8566, 34.247], [-118.85424, 34.2469], [-118.85211, 34.24762], [-118.85042, 34.2476], [-118.85039, 34.24535], [-118.84855, 34.24563], [-118.84856, 34.24296], [-118.8512, 34.24133], [-118.85202, 34.24224], [-118.85363, 34.24125], [-118.85364, 34.24123], [-118.85345, 34.24102], [-118.85321, 34.24082], [-118.85298, 34.24071], [-118.85281, 34.24069], [-118.85264, 34.24058], [-118.85238, 34.24061], [-118.85271, 34.24038], [-118.85426, 34.23944], [-118.85592, 34.24026], [-118.85688, 34.23975], [-118.85678, 34.23961], [-118.85682, 34.23954], [-118.8567, 34.23937], [-118.85687, 34.23921], [-118.85732, 34.23972], [-118.85764, 34.23997], [-118.86057, 34.23827], [-118.86071, 34.23809], [-118.86598, 34.23806], [-118.86601, 34.24605]]]} | Restricted Access 2 | 17732 | McCrea Open Space | 22014 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 226.171 | McCrea OS | 0 | Local Recreation Area 3 | 4 | |
10163 | 10163 | 10162 | {"type": "MultiPolygon", "coordinates": [[[[-118.85683, 34.23954], [-118.8568, 34.23959], [-118.8567, 34.23938], [-118.8567, 34.23937], [-118.85683, 34.23954]]], [[[-118.85689, 34.23975], [-118.85688, 34.23975], [-118.85685, 34.23971], [-118.85689, 34.23975], [-118.85689, 34.23975]]], [[[-118.85275, 34.24064], [-118.85264, 34.24059], [-118.85237, 34.24061], [-118.85243, 34.24058], [-118.85242, 34.2406], [-118.85264, 34.24058], [-118.85275, 34.24064]]], [[[-118.85339, 34.24098], [-118.85317, 34.24081], [-118.85289, 34.2407], [-118.85298, 34.24071], [-118.85321, 34.24082], [-118.85339, 34.24098]]], [[[-118.8536, 34.2412], [-118.85343, 34.24101], [-118.85343, 34.24101], [-118.85345, 34.24102], [-118.8536, 34.2412]]], [[[-118.84856, 34.24296], [-118.84855, 34.24427], [-118.84855, 34.24422], [-118.84856, 34.24296]]], [[[-118.86424, 34.24569], [-118.86392, 34.24579], [-118.86363, 34.24573], [-118.86183, 34.24504], [-118.85908, 34.24514], [-118.85907, 34.24557], [-118.85582, 34.24601], [-118.85521, 34.24539], [-118.85472, 34.24505], [-118.85435, 34.2448], [-118.85356, 34.24447], [-118.85308, 34.24441], [-118.85229, 34.24447], [-118.85197, 34.24434], [-118.85209, 34.24376], [-118.85209, 34.2433], [-118.85238, 34.24315], [-118.85305, 34.24322], [-118.85335, 34.24361], [-118.85382, 34.24395], [-118.85445, 34.24414], [-118.85491, 34.24409], [-118.85552, 34.24377], [-118.85678, 34.24345], [-118.85787, 34.24342], [-118.85893, 34.24344], [-118.86001, 34.24322], [-118.86029, 34.24304], [-118.86109, 34.2424], [-118.86142, 34.24204], [-118.86166, 34.24164], [-118.86184, 34.24115], [-118.86212, 34.24004], [-118.86244, 34.23969], [-118.86267, 34.23997], [-118.86275, 34.24039], [-118.86274, 34.24099], [-118.86322, 34.24375], [-118.86361, 34.24494], [-118.86381, 34.24529], [-118.86424, 34.24569]]], [[[-118.85901, 34.24664], [-118.8583, 34.24676], [-118.8579, 34.24681], [-118.85901, 34.24664]]], [[[-118.85211, 34.24762], [-118.8504, 34.24762], [-118.85039, 34.24535], [-118.84855, 34.24563], [-118.85039, 34.24535], [-118.85042, 34.2476], [-118.85211, 34.24762]]]]} | Restricted Access 2 | 17736 | McCrea Ranch | 22015 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 63.673 | McCrea Ranch | 0 | Local Other or Unknown 14 | 4 | |
10318 | 10318 | 10317 | {"type": "Polygon", "coordinates": [[[-118.84593, 34.21504], [-118.84583, 34.21528], [-118.84571, 34.2153], [-118.84568, 34.21533], [-118.84565, 34.2154], [-118.84567, 34.21546], [-118.84574, 34.21555], [-118.84592, 34.2167], [-118.84593, 34.21685], [-118.84592, 34.21695], [-118.8459, 34.21703], [-118.84587, 34.21707], [-118.8458, 34.21709], [-118.84297, 34.21682], [-118.84289, 34.21681], [-118.84283, 34.21676], [-118.84283, 34.21639], [-118.84281, 34.21609], [-118.84273, 34.21571], [-118.84263, 34.21539], [-118.84293, 34.21527], [-118.84298, 34.21532], [-118.84309, 34.21537], [-118.84316, 34.21537], [-118.84329, 34.21535], [-118.84358, 34.21536], [-118.84363, 34.21538], [-118.84371, 34.21546], [-118.84383, 34.21548], [-118.84391, 34.21544], [-118.84393, 34.2154], [-118.84394, 34.21536], [-118.84393, 34.2153], [-118.84428, 34.21507], [-118.84495, 34.21509], [-118.84593, 34.21504]]]} | Restricted Access 2 | 18210 | Oakbrook Neighborhood Park | 23018 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 13.483 | Oakbrook Neighborhood Park | 0 | Local Park 2 | 4 | |
3757 | 3757 | 3756 | {"type": "Polygon", "coordinates": [[[-122.27111, 38.04044], [-122.26883, 38.04296], [-122.26793, 38.04407], [-122.26606, 38.04552], [-122.26345, 38.04303], [-122.26441, 38.04222], [-122.26428, 38.04211], [-122.26434, 38.04207], [-122.26434, 38.04205], [-122.26428, 38.042], [-122.26421, 38.04204], [-122.26333, 38.04124], [-122.26342, 38.04109], [-122.26365, 38.0408], [-122.26384, 38.04059], [-122.26413, 38.04034], [-122.26445, 38.04011], [-122.2648, 38.03991], [-122.26517, 38.03974], [-122.26694, 38.04149], [-122.27043, 38.0391], [-122.27111, 38.04044]]]} | Restricted Access 2 | 466 | San Pablo Bay Regional Shoreline | 24966 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 57.631 | San Pablo Bay Reg. Shoreline | 1976 | Local Park 2 | 4 | |
4298 | 4298 | 4297 | {"type": "MultiPolygon", "coordinates": [[[[-121.97565, 37.70051], [-121.97562, 37.70061], [-121.97543, 37.70073], [-121.97507, 37.70044], [-121.97405, 37.69985], [-121.97434, 37.69948], [-121.9747, 37.69968], [-121.975, 37.69989], [-121.97538, 37.70022], [-121.97565, 37.70051]]], [[[-121.98765, 37.73258], [-121.98688, 37.73201], [-121.97964, 37.7298], [-121.9786, 37.72967], [-121.97859, 37.72783], [-121.97863, 37.72405], [-121.9862, 37.72382], [-121.98624, 37.72657], [-121.98763, 37.72776], [-121.98761, 37.73085], [-121.98765, 37.73258]]]]} | Restricted Access 2 | 45337 | Dublin Hills Regional Park | 18292 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 142.3 | Dublin Hills RP | 0 | Local Park 2 | 4 | |
4940 | 4940 | 4939 | {"type": "Polygon", "coordinates": [[[-122.02404, 37.66917], [-122.02383, 37.66911], [-122.02395, 37.66891], [-122.02396, 37.66892], [-122.02404, 37.66917]]]} | Restricted Access 2 | 10715 | Chabot - Garin Trail Corridor | 17108 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 0.064 | Chabot - Garin Trail Corridor | 0 | Local Conservation Area 4 | 2 | |
5761 | 5761 | 5760 | {"type": "Polygon", "coordinates": [[[-121.73224, 38.009], [-121.72985, 38.00901], [-121.72986, 38.02204], [-121.72942, 38.0223], [-121.72882, 38.02348], [-121.72786, 38.02508], [-121.7259, 38.02528], [-121.72399, 38.02519], [-121.72168, 38.02469], [-121.71852, 38.02368], [-121.71627, 38.02245], [-121.71439, 38.02186], [-121.71255, 38.02172], [-121.71147, 38.0212], [-121.71065, 38.0207], [-121.71014, 38.02044], [-121.7097, 38.02031], [-121.70885, 38.02016], [-121.70831, 38.02019], [-121.70788, 38.02032], [-121.70758, 38.02052], [-121.70735, 38.02087], [-121.70732, 38.02113], [-121.70732, 38.02145], [-121.7073, 38.02177], [-121.70713, 38.02207], [-121.70633, 38.02281], [-121.70546, 38.02315], [-121.70491, 38.02345], [-121.70413, 38.02397], [-121.70358, 38.02428], [-121.7029, 38.0245], [-121.70128, 38.02488], [-121.70062, 38.02507], [-121.69988, 38.02523], [-121.69909, 38.02534], [-121.69737, 38.02549], [-121.69672, 38.02563], [-121.69574, 38.02579], [-121.69543, 38.02581], [-121.69518, 38.02575], [-121.69395, 38.02506], [-121.69341, 38.02479], [-121.69274, 38.02442], [-121.69138, 38.02371], [-121.691, 38.02343], [-121.6908, 38.02323], [-121.69073, 38.02304], [-121.69056, 38.0221], [-121.69029, 38.02141], [-121.69007, 38.02108], [-121.68936, 38.02036], [-121.68882, 38.01995], [-121.68778, 38.0189], [-121.68732, 38.01838], [-121.68656, 38.01785], [-121.68638, 38.01768], [-121.68615, 38.01752], [-121.686, 38.01726], [-121.68594, 38.01701], [-121.68601, 38.01673], [-121.68602, 38.01649], [-121.68611, 38.01619], [-121.68619, 38.01602], [-121.68605, 38.01575], [-121.68589, 38.0156], [-121.6857, 38.01556], [-121.68534, 38.01561], [-121.68498, 38.01572], [-121.68549, 38.01535], [-121.68564, 38.01515], [-121.68575, 38.0148], [-121.68573, 38.0146], [-121.68567, 38.01441], [-121.68554, 38.01418], [-121.68499, 38.01365], [-121.68476, 38.01351], [-121.68616, 38.01353], [-121.68808, 38.0132], [-121.68885, 38.01329], [-121.68932, 38.01338], [-121.68975, 38.01329], [-121.69037, 38.01241], [-121.69042, 38.01202], [-121.69041, 38.01184], [-121.69057, 38.01169], [-121.69083, 38.01152], [-121.6909, 38.01129], [-121.69092, 38.01111], [-121.69102, 38.01082], [-121.69121, 38.01057], [-121.69104, 38.01036], [-121.69106, 38.01024], [-121.69101, 38.01008], [-121.691, 38.00933], [-121.69102, 38.00912], [-121.69114, 38.00835], [-121.69117, 38.00802], [-121.69131, 38.00698], [-121.6913, 38.00678], [-121.69134, 38.00615], [-121.69148, 38.00539], [-121.69171, 38.00536], [-121.69505, 38.00708], [-121.6968, 38.00734], [-121.69696, 38.00638], [-121.71159, 38.00658], [-121.71157, 38.00843], [-121.72312, 38.00845], [-121.72313, 38.00872], [-121.73224, 38.00873], [-121.73224, 38.009]]]} | Restricted Access 2 | 532 | Big Break Regional Shoreline | 31520 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 1604.429 | Big Break Reg. Shoreline | 2005 | Local Park 2 | 4 | |
6579 | 6579 | 6578 | {"type": "Polygon", "coordinates": [[[-122.00373, 37.76975], [-122.00325, 37.76996], [-122.00269, 37.77028], [-122.00215, 37.77041], [-122.00191, 37.77061], [-122.00165, 37.77101], [-122.00127, 37.77147], [-122.00085, 37.77183], [-122.00119, 37.77061], [-122.00129, 37.7703], [-122.00161, 37.77011], [-122.00179, 37.76986], [-122.0018, 37.76926], [-122.00185, 37.7692], [-122.00178, 37.76841], [-122.00137, 37.76813], [-122.00051, 37.76805], [-121.99997, 37.76845], [-121.99925, 37.76789], [-121.99863, 37.76767], [-121.9985, 37.76746], [-121.99807, 37.76732], [-121.99787, 37.76713], [-121.99794, 37.76655], [-121.99769, 37.76609], [-121.99777, 37.76583], [-121.99772, 37.76579], [-121.99705, 37.76618], [-121.99718, 37.76706], [-121.99692, 37.76774], [-121.99579, 37.76749], [-121.99604, 37.76691], [-121.99592, 37.76624], [-121.99563, 37.76595], [-121.99481, 37.76636], [-121.99461, 37.76817], [-121.9942, 37.76856], [-121.99265, 37.76609], [-121.99661, 37.76551], [-121.99928, 37.76518], [-122.00373, 37.76975]]]} | Restricted Access 2 | 5342 | Calaveras Ridge Trail - land bank | 16671 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 43.362 | Calaveras Ridge Trail - land bank | None 529 | |||
7544 | 7544 | 7543 | {"type": "Polygon", "coordinates": [[[-122.26096, 37.96074], [-122.26068, 37.96086], [-122.2605, 37.96097], [-122.26032, 37.96109], [-122.26017, 37.96122], [-122.26003, 37.96137], [-122.25992, 37.96152], [-122.25947, 37.96216], [-122.25935, 37.96227], [-122.25923, 37.96234], [-122.25911, 37.96238], [-122.25547, 37.96311], [-122.25517, 37.9632], [-122.25478, 37.96335], [-122.25275, 37.95999], [-122.25186, 37.96017], [-122.24908, 37.95619], [-122.24757, 37.95482], [-122.25188, 37.95185], [-122.26096, 37.96074]]]} | Restricted Access 2 | 47610 | Bay Area Ridge Trail Land Bank | 31342 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 166.102 | Bay Area Ridge Trail Land Bank | 0 | Local Resource Management Area 83 | 3 | |
9716 | 9716 | 9715 | {"type": "Polygon", "coordinates": [[[-122.04308, 37.68652], [-122.04287, 37.68656], [-122.04248, 37.68602], [-122.04086, 37.68619], [-122.04068, 37.68582], [-122.04091, 37.68578], [-122.04109, 37.68544], [-122.041, 37.68517], [-122.04087, 37.68423], [-122.04073, 37.68369], [-122.04069, 37.68286], [-122.04054, 37.682], [-122.04028, 37.68125], [-122.03894, 37.68066], [-122.03881, 37.68017], [-122.03817, 37.68023], [-122.03824, 37.67969], [-122.03637, 37.68023], [-122.03604, 37.67954], [-122.03614, 37.67873], [-122.03264, 37.67776], [-122.03309, 37.67686], [-122.0338, 37.67677], [-122.0343, 37.67623], [-122.03509, 37.67612], [-122.03518, 37.67667], [-122.03535, 37.67714], [-122.03573, 37.67764], [-122.03624, 37.67795], [-122.03704, 37.67824], [-122.03739, 37.67839], [-122.03772, 37.67857], [-122.03834, 37.67893], [-122.03878, 37.67871], [-122.03935, 37.679], [-122.04008, 37.67865], [-122.04036, 37.67781], [-122.04075, 37.6793], [-122.04214, 37.68386], [-122.04308, 37.68652]]]} | Restricted Access 2 | 16446 | Five Canyons trail corridor | 18933 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 50.693 | Five Canyons trail corridor | None 839 | |||
10369 | 10369 | 10368 | {"type": "Polygon", "coordinates": [[[-121.73098, 38.00441], [-121.73064, 38.0048], [-121.73007, 38.00476], [-121.73001, 38.00463], [-121.72957, 38.00478], [-121.72957, 38.00463], [-121.72949, 38.00435], [-121.72888, 38.00407], [-121.72775, 38.00355], [-121.72714, 38.00337], [-121.72646, 38.00321], [-121.72603, 38.00306], [-121.72553, 38.00283], [-121.72515, 38.00269], [-121.72473, 38.00262], [-121.72411, 38.00265], [-121.7237, 38.00275], [-121.72337, 38.00287], [-121.72318, 38.0029], [-121.7232, 38.00179], [-121.73098, 38.00441]]]} | Restricted Access 2 | 18303 | Oakley (Legless Lizard) Land Bank | 23030 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 7.851 | Oakley (Legless Lizard) Land Bank | 0 | Local Resource Management Area 83 | 3 | |
12354 | 12354 | 12353 | {"type": "Polygon", "coordinates": [[[-121.96963, 38.04103], [-121.96963, 38.04434], [-121.96849, 38.0443], [-121.96622, 38.04318], [-121.96629, 38.04287], [-121.96269, 38.04202], [-121.96268, 38.03926], [-121.96963, 38.04103]]]} | Restricted Access 2 | 26080 | Bay Point Regional Shoreline | 31519 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 50.558 | Bay Point Reg. Shoreline | 1996 | Local Park 2 | 4 | |
12672 | 12672 | 12671 | {"type": "Polygon", "coordinates": [[[-122.1579, 38.02489], [-122.15653, 38.0249], [-122.15653, 38.02492], [-122.15716, 38.02516], [-122.14088, 38.02769], [-122.14074, 38.02715], [-122.13972, 38.02728], [-122.13935, 38.02633], [-122.13962, 38.02572], [-122.14132, 38.02522], [-122.1414, 38.02511], [-122.14103, 38.02493], [-122.14094, 38.02472], [-122.14094, 38.02428], [-122.1414, 38.0241], [-122.14146, 38.02396], [-122.1419, 38.02371], [-122.1421, 38.023], [-122.14233, 38.0228], [-122.14331, 38.0225], [-122.14464, 38.02239], [-122.14591, 38.02221], [-122.14632, 38.02195], [-122.1516, 38.02283], [-122.15255, 38.0231], [-122.1543, 38.02374], [-122.15431, 38.02375], [-122.15437, 38.02376], [-122.15483, 38.02393], [-122.15722, 38.02463], [-122.1579, 38.02489]]]} | Restricted Access 2 | 29625 | Martinez Regional Shoreline | 21927 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 140.251 | Martinez Reg. Shoreline | 1979 | Local Park 2 | 4 |
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]);