units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
167 rows where MNG_AGENCY = 87 sorted by YR_EST
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, COUNTY, GAP_STS
DES_TP 25
- Local Park 76
- Local Conservation Area 40
- Local Recreation Area 28
- 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
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
- Open Access 101
- No Public Access 47
- Restricted Access 19
MNG_AG_TYP 1
MNG_AGENCY 1
- East Bay Regional Park District · 167 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
576 | 576 | 575 | {"type": "Polygon", "coordinates": [[[-122.14526, 37.74311], [-122.14524, 37.74315], [-122.14492, 37.74341], [-122.14434, 37.74398], [-122.14423, 37.74406], [-122.1437, 37.7433], [-122.14342, 37.74306], [-122.14482, 37.7425], [-122.14526, 37.74311]]]} | Open Access 1 | 3448 | Poaks Headquarters | 23819 | 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 | 3.419 | Poaks Headquarters | None 57 | |||
2356 | 2356 | 2355 | {"type": "Polygon", "coordinates": [[[-121.7508, 38.02106], [-121.7506, 38.02106], [-121.75061, 38.02096], [-121.75065, 38.02095], [-121.75065, 38.01964], [-121.75066, 38.01963], [-121.75067, 38.01953], [-121.75076, 38.01953], [-121.75075, 38.02095], [-121.7508, 38.02096], [-121.7508, 38.02106]]]} | Open Access 1 | 17112 | Antioch Bridge Fishing Pier | 15522 | 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 | 0.397 | Antioch Bridge Fishing Pier | None 198 | |||
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 | ||
4182 | 4182 | 4181 | {"type": "Polygon", "coordinates": [[[-122.33713, 37.91103], [-122.3302, 37.90951], [-122.33019, 37.90937], [-122.32739, 37.90874], [-122.32609, 37.90838], [-122.32557, 37.9082], [-122.32557, 37.90811], [-122.32475, 37.9078], [-122.32454, 37.90774], [-122.32432, 37.90764], [-122.32317, 37.90701], [-122.32242, 37.90652], [-122.32205, 37.90627], [-122.32145, 37.90584], [-122.32094, 37.9054], [-122.32039, 37.90483], [-122.32022, 37.90468], [-122.31956, 37.90396], [-122.3163, 37.8999], [-122.31655, 37.89982], [-122.31658, 37.89984], [-122.31926, 37.90317], [-122.32457, 37.90051], [-122.32268, 37.89818], [-122.32347, 37.89776], [-122.32425, 37.89827], [-122.32452, 37.89851], [-122.32468, 37.89872], [-122.32478, 37.89891], [-122.32485, 37.89914], [-122.32487, 37.89938], [-122.32522, 37.89938], [-122.32522, 37.9011], [-122.32128, 37.90308], [-122.31988, 37.9038], [-122.3203, 37.90434], [-122.32088, 37.90498], [-122.32125, 37.90533], [-122.32159, 37.90561], [-122.32212, 37.90606], [-122.32235, 37.90632], [-122.3228, 37.9066], [-122.32313, 37.90684], [-122.3235, 37.90705], [-122.32458, 37.9076], [-122.32579, 37.90809], [-122.32594, 37.90814], [-122.3261, 37.90816], [-122.32745, 37.90855], [-122.3325, 37.90968], [-122.33251, 37.90967], [-122.33251, 37.90946], [-122.33711, 37.91047], [-122.33713, 37.91103]]]} | Open Access 1 | 3447 | Point Isabel | 23851 | 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 | 37.437 | Point Isabel | None 363 | |||
5856 | 5856 | 5855 | {"type": "Polygon", "coordinates": [[[-122.24593, 38.05452], [-122.24554, 38.05454], [-122.24552, 38.05423], [-122.24559, 38.05422], [-122.24557, 38.05413], [-122.24515, 38.05393], [-122.24465, 38.05396], [-122.24446, 38.05402], [-122.24428, 38.05419], [-122.24387, 38.05422], [-122.24323, 38.05398], [-122.24247, 38.05407], [-122.24266, 38.05471], [-122.24243, 38.05478], [-122.24254, 38.05538], [-122.24273, 38.05569], [-122.24261, 38.05587], [-122.24169, 38.05597], [-122.24148, 38.05639], [-122.23999, 38.05634], [-122.23998, 38.05584], [-122.24021, 38.05586], [-122.24054, 38.05585], [-122.24087, 38.05578], [-122.24117, 38.05566], [-122.24143, 38.0555], [-122.24155, 38.0554], [-122.24226, 38.05455], [-122.24195, 38.0544], [-122.24182, 38.05437], [-122.24148, 38.05361], [-122.24141, 38.05342], [-122.24136, 38.05321], [-122.24134, 38.05301], [-122.24135, 38.0528], [-122.24141, 38.05251], [-122.24376, 38.05319], [-122.24396, 38.05373], [-122.24385, 38.05392], [-122.24393, 38.05396], [-122.24423, 38.05395], [-122.24431, 38.05384], [-122.24459, 38.05375], [-122.24532, 38.05371], [-122.24583, 38.05396], [-122.24584, 38.05419], [-122.24593, 38.05421], [-122.24593, 38.05452]]]} | Open Access 1 | 242 | Rodeo Grounds | 24549 | 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 | 14.364 | Rodeo Grounds | None 469 | |||
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 | |||
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 | |||
10067 | 10067 | 10066 | {"type": "MultiPolygon", "coordinates": [[[[-122.2745, 38.03467], [-122.27444, 38.03503], [-122.27436, 38.03534], [-122.27424, 38.03563], [-122.27403, 38.03599], [-122.27382, 38.03626], [-122.27358, 38.03652], [-122.2733, 38.03675], [-122.27299, 38.03695], [-122.27266, 38.03714], [-122.27231, 38.03729], [-122.27194, 38.03741], [-122.27098, 38.0377], [-122.26857, 38.0384], [-122.26853, 38.03822], [-122.27101, 38.03749], [-122.27095, 38.03738], [-122.27083, 38.03724], [-122.27148, 38.03713], [-122.27143, 38.03692], [-122.2718, 38.03686], [-122.27171, 38.0365], [-122.27241, 38.03638], [-122.27232, 38.03602], [-122.27286, 38.03593], [-122.27279, 38.03563], [-122.27333, 38.03554], [-122.27318, 38.03496], [-122.27392, 38.03485], [-122.27386, 38.03459], [-122.27435, 38.03452], [-122.2745, 38.03467]]], [[[-122.27573, 38.03587], [-122.27551, 38.03742], [-122.27477, 38.0383], [-122.27289, 38.03741], [-122.27234, 38.03763], [-122.27226, 38.0376], [-122.27246, 38.03753], [-122.27285, 38.03737], [-122.27321, 38.03717], [-122.27354, 38.03694], [-122.27385, 38.03669], [-122.27411, 38.03641], [-122.27434, 38.03611], [-122.27453, 38.0358], [-122.27461, 38.03563], [-122.27475, 38.0352], [-122.27481, 38.03496], [-122.27573, 38.03587]]]]} | Open Access 1 | 17424 | Lone Tree Point | 21444 | 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 | 21.13 | Lone Tree Point | None 869 | |||
11330 | 11330 | 11329 | {"type": "Polygon", "coordinates": [[[-122.04279, 37.68931], [-122.04192, 37.68952], [-122.04197, 37.68984], [-122.0417, 37.68988], [-122.04139, 37.69003], [-122.04079, 37.69022], [-122.04109, 37.68972], [-122.04062, 37.6896], [-122.04169, 37.68901], [-122.04204, 37.68905], [-122.04279, 37.68931]]]} | Open Access 1 | 22054 | Palomares Ridge | 23369 | 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 | 2.611 | Palomares Ridge | None 996 | |||
12425 | 12425 | 12424 | {"type": "Polygon", "coordinates": [[[-121.78716, 37.9022], [-121.78714, 37.90506], [-121.78662, 37.90505], [-121.78557, 37.90565], [-121.78226, 37.90482], [-121.78227, 37.90345], [-121.76905, 37.90344], [-121.76913, 37.89641], [-121.76972, 37.89669], [-121.76993, 37.89677], [-121.77015, 37.89683], [-121.77181, 37.89707], [-121.77214, 37.8971], [-121.77244, 37.8971], [-121.77273, 37.89708], [-121.77303, 37.89703], [-121.77331, 37.89696], [-121.77378, 37.8968], [-121.77421, 37.89671], [-121.77465, 37.89669], [-121.77509, 37.89674], [-121.7753, 37.8968], [-121.78181, 37.89908], [-121.78224, 37.89927], [-121.78336, 37.89983], [-121.7837, 37.90003], [-121.78607, 37.90182], [-121.78627, 37.90193], [-121.78648, 37.90203], [-121.78671, 37.9021], [-121.78716, 37.9022]]]} | No Public Access 3 | 27031 | Deer Valley | 18002 | 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 | 242.118 | Deer Valley | None 1078 | |||
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 | ||
12728 | 12728 | 12727 | {"type": "Polygon", "coordinates": [[[-122.18401, 37.84685], [-122.17947, 37.84688], [-122.17946, 37.85048], [-122.17489, 37.85051], [-122.1749, 37.84692], [-122.17435, 37.84691], [-122.17419, 37.8454], [-122.17415, 37.84419], [-122.17411, 37.84379], [-122.17363, 37.84333], [-122.17333, 37.84267], [-122.17289, 37.84198], [-122.17044, 37.84099], [-122.17043, 37.83987], [-122.17502, 37.8398], [-122.17621, 37.83749], [-122.17795, 37.83805], [-122.17809, 37.8378], [-122.17909, 37.83812], [-122.17949, 37.83827], [-122.1795, 37.83974], [-122.18065, 37.83972], [-122.18068, 37.84008], [-122.18243, 37.84034], [-122.1829, 37.84031], [-122.18397, 37.8404], [-122.18401, 37.84685]]]} | No Public Access 3 | 29754 | Sibley | 25436 | 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 | 241.744 | Sibley | None 1115 | |||
16592 | 16592 | 16591 | {"type": "Polygon", "coordinates": [[[-122.32764, 37.88931], [-122.32767, 37.88943], [-122.3277, 37.88994], [-122.32777, 37.89025], [-122.32775, 37.89047], [-122.32776, 37.8908], [-122.32755, 37.89163], [-122.32748, 37.89129], [-122.3275, 37.89097], [-122.32745, 37.89074], [-122.32717, 37.89084], [-122.32691, 37.89087], [-122.3265, 37.89088], [-122.326, 37.89082], [-122.32568, 37.8908], [-122.32561, 37.89111], [-122.32559, 37.89174], [-122.32566, 37.89202], [-122.32592, 37.89206], [-122.32599, 37.89234], [-122.32573, 37.89251], [-122.32444, 37.89221], [-122.32409, 37.89132], [-122.32356, 37.89131], [-122.32311, 37.8899], [-122.31991, 37.88993], [-122.31763, 37.89086], [-122.31635, 37.8909], [-122.31625, 37.89169], [-122.31393, 37.8917], [-122.31197, 37.89022], [-122.312, 37.88997], [-122.31333, 37.88985], [-122.31333, 37.88964], [-122.31592, 37.88964], [-122.31593, 37.88793], [-122.31595, 37.88794], [-122.31602, 37.88795], [-122.31709, 37.88922], [-122.31722, 37.88925], [-122.32312, 37.8891], [-122.32321, 37.88893], [-122.32315, 37.88872], [-122.32319, 37.88833], [-122.32341, 37.88824], [-122.32374, 37.88809], [-122.32431, 37.88803], [-122.32463, 37.88788], [-122.32501, 37.88804], [-122.3254, 37.88804], [-122.32577, 37.88823], [-122.32585, 37.88825], [-122.32584, 37.88827], [-122.32619, 37.88847], [-122.32661, 37.88861], [-122.32695, 37.88868], [-122.32718, 37.88871], [-122.32763, 37.88855], [-122.32756, 37.88886], [-122.32764, 37.88931]]]} | Open Access 1 | 29694 | McLaughlin Eastshore State Park | 29199 | 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 | 71.308 | McLaughlin Eastshore SP | None 1414 | ||
3269 | 3269 | 3268 | {"type": "Polygon", "coordinates": [[[-122.0528, 37.99715], [-122.05267, 37.99768], [-122.05079, 37.99735], [-122.05079, 37.99734], [-122.05051, 37.99729], [-122.05017, 37.99725], [-122.05016, 37.99724], [-122.04978, 37.99725], [-122.04887, 37.99733], [-122.04817, 37.99731], [-122.04823, 37.9969], [-122.04863, 37.99694], [-122.04888, 37.99693], [-122.04913, 37.99691], [-122.04957, 37.9968], [-122.04985, 37.99676], [-122.04986, 37.99675], [-122.05003, 37.99674], [-122.0501, 37.99681], [-122.05025, 37.99683], [-122.05029, 37.99673], [-122.05066, 37.99677], [-122.0528, 37.99715]]]} | Open Access 1 | 29407 | Delta/DeAnza Trail | 18077 | 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 | 5.445 | Delta/DeAnza Trail | 0 | Local Recreation Area 3 | 4 | |
3486 | 3486 | 3485 | {"type": "Polygon", "coordinates": [[[-122.04254, 37.69324], [-122.04258, 37.69353], [-122.04254, 37.69359], [-122.04245, 37.69363], [-122.04168, 37.69356], [-122.04021, 37.69367], [-122.04031, 37.69501], [-122.0398, 37.6962], [-122.03857, 37.69573], [-122.03373, 37.69642], [-122.03244, 37.69557], [-122.0294, 37.69336], [-122.02923, 37.6932], [-122.02911, 37.69298], [-122.02965, 37.69307], [-122.03009, 37.6934], [-122.03051, 37.69331], [-122.03084, 37.69344], [-122.03097, 37.69365], [-122.03108, 37.69367], [-122.03129, 37.69369], [-122.03163, 37.69355], [-122.03186, 37.69322], [-122.03235, 37.69309], [-122.03281, 37.69308], [-122.03302, 37.69322], [-122.03334, 37.69316], [-122.03333, 37.69293], [-122.03356, 37.69289], [-122.03402, 37.69255], [-122.03407, 37.69237], [-122.03435, 37.69371], [-122.04, 37.69298], [-122.04254, 37.69324]]]} | No Public Access 3 | 46879 | Chabot - Garin Trail Corridor | 30360 | 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 | 63.522 | Chabot - Garin Trail Corridor | 0 | Local Conservation Area 4 | 2 | |
3558 | 3558 | 3557 | {"type": "Polygon", "coordinates": [[[-122.34141, 37.899], [-122.33912, 37.89903], [-122.33911, 37.89846], [-122.3414, 37.89842], [-122.34141, 37.899]]]} | No Public Access 3 | 15364 | Brooks Island Regional Preserve | 31524 | 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 | 3.177 | Brooks Island RPr | 0 | Local Conservation Area 4 | 2 | |
3624 | 3624 | 3623 | {"type": "Polygon", "coordinates": [[[-121.70748, 37.99957], [-121.7053, 37.99809], [-121.70531, 37.9979], [-121.70746, 37.99794], [-121.70748, 37.99957]]]} | Open Access 1 | 29411 | BB Delta Shoreline Trail | 15905 | 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 | 4.739 | BB Delta Shoreline Trail | 0 | Local Recreation Area 3 | 4 | |
3646 | 3646 | 3645 | {"type": "Polygon", "coordinates": [[[-122.09719, 37.88699], [-122.0967, 37.88654], [-122.09593, 37.88668], [-122.09517, 37.88629], [-122.09471, 37.88637], [-122.09407, 37.88659], [-122.09356, 37.88625], [-122.09322, 37.88618], [-122.0933, 37.88612], [-122.0934, 37.8861], [-122.09615, 37.88602], [-122.09669, 37.88602], [-122.09723, 37.88606], [-122.09727, 37.88609], [-122.09728, 37.88613], [-122.09719, 37.88664], [-122.09719, 37.88699]]]} | Open Access 1 | 29549 | Lafayette/Moraga Trail | 20836 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 4.276 | Lafayette/Moraga Trail | 0 | Local Recreation Area 3 | 4 | |
3733 | 3733 | 3732 | {"type": "MultiPolygon", "coordinates": [[[[-122.03357, 37.90414], [-122.03346, 37.90426], [-122.03345, 37.904], [-122.0335, 37.90405], [-122.03357, 37.90414]]], [[[-122.04019, 37.90842], [-122.03957, 37.90859], [-122.03754, 37.90726], [-122.03826, 37.90623], [-122.03875, 37.90662], [-122.03905, 37.9069], [-122.03939, 37.90741], [-122.03961, 37.90803], [-122.04019, 37.90842]]]]} | Open Access 1 | 31016 | Briones to Mount Diablo Trail | 33752 | 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 | 5.904 | Briones to Mount Diablo Trail | 0 | Local Recreation Area 3 | 4 | |
4034 | 4034 | 4033 | {"type": "Polygon", "coordinates": [[[-121.91611, 37.5378], [-121.91556, 37.53803], [-121.91495, 37.53842], [-121.91451, 37.53888], [-121.91415, 37.53911], [-121.91397, 37.53932], [-121.91364, 37.53952], [-121.91302, 37.53939], [-121.91255, 37.53955], [-121.91174, 37.53993], [-121.91138, 37.54002], [-121.90953, 37.54067], [-121.90916, 37.54088], [-121.90818, 37.54109], [-121.90735, 37.54153], [-121.90688, 37.54203], [-121.90661, 37.54204], [-121.90612, 37.5403], [-121.90456, 37.5375], [-121.90418, 37.53666], [-121.90346, 37.53544], [-121.89974, 37.52963], [-121.89885, 37.5284], [-121.89859, 37.52788], [-121.8989, 37.52754], [-121.8994, 37.52728], [-121.90004, 37.52698], [-121.90089, 37.52646], [-121.90117, 37.52558], [-121.90143, 37.52518], [-121.90186, 37.52478], [-121.90249, 37.5246], [-121.90397, 37.52429], [-121.90517, 37.52427], [-121.9059, 37.52461], [-121.90612, 37.52479], [-121.90738, 37.52603], [-121.90881, 37.52554], [-121.90905, 37.52543], [-121.91005, 37.52485], [-121.91163, 37.52391], [-121.9122, 37.52617], [-121.91243, 37.52617], [-121.91252, 37.52614], [-121.91258, 37.52614], [-121.91266, 37.52619], [-121.91269, 37.52626], [-121.91271, 37.52705], [-121.91275, 37.52708], [-121.913, 37.52708], [-121.913, 37.52723], [-121.91273, 37.52724], [-121.91262, 37.5274], [-121.91263, 37.52745], [-121.91233, 37.52727], [-121.91199, 37.52714], [-121.91133, 37.52703], [-121.91108, 37.52705], [-121.91012, 37.52766], [-121.90997, 37.52829], [-121.91015, 37.52879], [-121.9104, 37.52907], [-121.91043, 37.52907], [-121.91051, 37.52939], [-121.91046, 37.52995], [-121.91009, 37.53017], [-121.90941, 37.53032], [-121.90902, 37.53037], [-121.90894, 37.53044], [-121.90888, 37.5306], [-121.90889, 37.53065], [-121.90906, 37.53091], [-121.90922, 37.53108], [-121.90935, 37.53128], [-121.91138, 37.53258], [-121.91098, 37.53266], [-121.91084, 37.53271], [-121.91022, 37.53305], [-121.91019, 37.53309], [-121.91019, 37.53315], [-121.91021, 37.53319], [-121.9103, 37.53326], [-121.91041, 37.53328], [-121.91051, 37.53332], [-121.91079, 37.53351], [-121.91131, 37.53334], [-121.91171, 37.53472], [-121.91254, 37.53694], [-121.91321, 37.53668], [-121.91405, 37.53642], [-121.91406, 37.5364], [-121.91547, 37.53595], [-121.91611, 37.5378]]]} | No Public Access 3 | 46970 | Mission Peak Regional Preserve | 30597 | 235 | Desert and Mountain Conservation Authority 713 | State 5 | State Agency 5 | http://www.dmca.ca.gov/ | Other State 5 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 374.957 | Mission Peak RPr | 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]);