units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
167 rows where MNG_AGENCY = 87 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, 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
LAYER 7 ✖
ACCESS_TYP 3
- Open Access 101
- No Public Access 47
- Restricted Access 19
COUNTY 2 ✖
- Contra Costa 90
- Alameda 77
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 | |||
7780 | 7780 | 7779 | {"type": "Polygon", "coordinates": [[[-122.06926, 37.5506], [-122.06909, 37.55129], [-122.06477, 37.55292], [-122.06216, 37.55437], [-122.06194, 37.55408], [-122.06177, 37.5539], [-122.06443, 37.5524], [-122.06926, 37.5506]]]} | Open Access 1 | 8648 | Coyote Hills | 17741 | 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 | 11.543 | Coyote Hills | 1967 | None 647 | ||
9474 | 9474 | 9473 | {"type": "MultiPolygon", "coordinates": [[[[-122.30915, 37.84566], [-122.30817, 37.84588], [-122.30821, 37.8476], [-122.30107, 37.84921], [-122.30081, 37.84913], [-122.30112, 37.84812], [-122.30117, 37.84744], [-122.30225, 37.84718], [-122.30225, 37.84437], [-122.29844, 37.84436], [-122.29811, 37.84292], [-122.29818, 37.84243], [-122.29797, 37.84227], [-122.29795, 37.84217], [-122.29789, 37.8416], [-122.29789, 37.84144], [-122.29792, 37.84125], [-122.29802, 37.84093], [-122.29939, 37.84074], [-122.30721, 37.84074], [-122.30856, 37.84072], [-122.30857, 37.84074], [-122.30914, 37.84075], [-122.30915, 37.84566]]], [[[-122.31153, 37.86418], [-122.31141, 37.86454], [-122.31122, 37.86464], [-122.31104, 37.86465], [-122.3106, 37.86471], [-122.30591, 37.86568], [-122.30577, 37.86572], [-122.30563, 37.86572], [-122.30537, 37.86541], [-122.30393, 37.86453], [-122.30218, 37.85889], [-122.3003, 37.85163], [-122.30027, 37.85145], [-122.30027, 37.85121], [-122.30025, 37.85105], [-122.30068, 37.84959], [-122.30208, 37.84924], [-122.30822, 37.84786], [-122.30848, 37.85877], [-122.31153, 37.86418]]], [[[-122.31316, 37.8691], [-122.30903, 37.86998], [-122.30548, 37.87079], [-122.30529, 37.87011], [-122.30499, 37.86879], [-122.30499, 37.86853], [-122.30507, 37.86831], [-122.30574, 37.86731], [-122.30583, 37.86703], [-122.30579, 37.8668], [-122.30572, 37.8666], [-122.30575, 37.86651], [-122.30584, 37.86647], [-122.31099, 37.86543], [-122.3112, 37.8655], [-122.31316, 37.8691]]], [[[-122.31846, 37.87579], [-122.31005, 37.87748], [-122.30873, 37.87383], [-122.30661, 37.87435], [-122.30561, 37.87119], [-122.31326, 37.86954], [-122.31446, 37.87081], [-122.31516, 37.87171], [-122.31566, 37.87224], [-122.31846, 37.87579]]], [[[-122.33944, 37.89058], [-122.32869, 37.8935], [-122.32262, 37.89493], [-122.32444, 37.89221], [-122.32573, 37.89251], [-122.32599, 37.89234], [-122.32592, 37.89206], [-122.32566, 37.89202], [-122.32559, 37.89173], [-122.32561, 37.89111], [-122.32568, 37.8908], [-122.326, 37.89082], [-122.3265, 37.89088], [-122.32691, 37.89087], [-122.32717, 37.89084], [-122.32745, 37.89074], [-122.3275, 37.89097], [-122.32748, 37.89129], [-122.32754, 37.89159], [-122.32756, 37.8916], [-122.32776, 37.8908], [-122.32775, 37.89047], [-122.32777, 37.89024], [-122.3277, 37.88994], [-122.32767, 37.88943], [-122.32756, 37.88886], [-122.32763, 37.88856], [-122.32718, 37.88871], [-122.32695, 37.88868], [-122.32661, 37.88861], [-122.32619, 37.88847], [-122.3258, 37.88824], [-122.3254, 37.88804], [-122.32501, 37.88804], [-122.32463, 37.88788], [-122.32431, 37.88803], [-122.32374, 37.88809], [-122.32341, 37.88824], [-122.32319, 37.88832], [-122.32315, 37.88872], [-122.32321, 37.88893], [-122.32312, 37.8891], [-122.31722, 37.88925], [-122.3171, 37.88922], [-122.31602, 37.88795], [-122.31595, 37.88794], [-122.31593, 37.88793], [-122.31594, 37.88071], [-122.31252, 37.88139], [-122.31236, 37.88109], [-122.31217, 37.88081], [-122.31211, 37.88068], [-122.31185, 37.88037], [-122.31159, 37.88009], [-122.3108, 37.8791], [-122.31005, 37.87812], [-122.3099, 37.8779], [-122.30983, 37.87775], [-122.31024, 37.87767], [-122.31046, 37.87778], [-122.31051, 37.87772], [-122.31053, 37.87761], [-122.31588, 37.87656], [-122.31865, 37.87593], [-122.32167, 37.87952], [-122.32559, 37.88405], [-122.33014, 37.88463], [-122.3307, 37.88919], [-122.33944, 37.89058]]]]} | Open Access 1 | 15869 | 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 | 1084.173 | McLaughlin Eastshore SP | 0 | None 785 | |
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 | ||
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 | ||
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 | |||
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 | ||
13066 | 13066 | 13065 | {"type": "Polygon", "coordinates": [[[-121.74145, 37.61399], [-121.74132, 37.61413], [-121.74116, 37.61418], [-121.74067, 37.61426], [-121.74045, 37.61437], [-121.74047, 37.61426], [-121.74145, 37.61399]]]} | Open Access 1 | 34939 | Lake Del Valle SRA | 1594 | 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.parks.ca.gov/?page_id=537 | Alameda 17 | 0.204 | Lake Del Valle SRA | 2000 | None 1132 | |
13170 | 13170 | 13169 | {"type": "Polygon", "coordinates": [[[-122.09445, 37.88338], [-122.09175, 37.88567], [-122.0913, 37.88555], [-122.09123, 37.88545], [-122.09074, 37.885], [-122.09061, 37.88469], [-122.09012, 37.88429], [-122.08996, 37.88405], [-122.08948, 37.88366], [-122.08937, 37.88343], [-122.08893, 37.8827], [-122.089, 37.88222], [-122.08811, 37.88178], [-122.08768, 37.88189], [-122.08729, 37.88168], [-122.08773, 37.88148], [-122.08918, 37.88023], [-122.08956, 37.87957], [-122.0896, 37.88149], [-122.09214, 37.88146], [-122.09219, 37.88258], [-122.09319, 37.88257], [-122.09445, 37.88338]]]} | Restricted Access 2 | 35144 | Briones/Las Trampas Trail - land bank | 16397 | 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 | 38.086 | Briones/Las Trampas Trail - land bank | 2008 | None 1144 | ||
16547 | 16547 | 16546 | {"type": "MultiPolygon", "coordinates": [[[[-122.32, 37.89774], [-122.31954, 37.89799], [-122.31891, 37.89855], [-122.31905, 37.89825], [-122.31963, 37.89787], [-122.32, 37.89774]]], [[[-122.32553, 37.89867], [-122.3253, 37.89925], [-122.32527, 37.89971], [-122.32522, 37.89971], [-122.32521, 37.89938], [-122.32487, 37.89938], [-122.32487, 37.89924], [-122.32464, 37.89867], [-122.32456, 37.89855], [-122.3243, 37.8983], [-122.32386, 37.89801], [-122.32482, 37.89704], [-122.32226, 37.89542], [-122.32129, 37.89638], [-122.32156, 37.89656], [-122.32103, 37.89709], [-122.32103, 37.89664], [-122.32117, 37.8962], [-122.32142, 37.89597], [-122.32151, 37.89571], [-122.32216, 37.8953], [-122.32275, 37.89529], [-122.32298, 37.89561], [-122.32319, 37.89586], [-122.32496, 37.89698], [-122.32459, 37.89744], [-122.32537, 37.89797], [-122.32535, 37.89834], [-122.32553, 37.89867]]], [[[-122.3261, 37.90816], [-122.32595, 37.90814], [-122.32579, 37.90809], [-122.32458, 37.9076], [-122.3235, 37.90705], [-122.32313, 37.90684], [-122.3228, 37.9066], [-122.32235, 37.90632], [-122.32211, 37.90606], [-122.32159, 37.90561], [-122.32125, 37.90533], [-122.32088, 37.90498], [-122.3203, 37.90434], [-122.31987, 37.90381], [-122.32522, 37.90109], [-122.32523, 37.90161], [-122.32526, 37.90164], [-122.32525, 37.90223], [-122.32528, 37.90303], [-122.32537, 37.9072], [-122.3261, 37.90816]]], [[[-122.3256, 37.90938], [-122.32441, 37.90871], [-122.32387, 37.90873], [-122.32346, 37.90851], [-122.32331, 37.90864], [-122.32054, 37.90518], [-122.32029, 37.90492], [-122.31957, 37.90397], [-122.32022, 37.90468], [-122.32039, 37.90483], [-122.32094, 37.9054], [-122.32145, 37.90584], [-122.32205, 37.90627], [-122.32317, 37.90701], [-122.32432, 37.90764], [-122.32454, 37.90774], [-122.32475, 37.9078], [-122.32557, 37.90811], [-122.3256, 37.90938]]]]} | Open Access 1 | 35120 | 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 | Contra Costa 12 | 69.746 | McLaughlin Eastshore SP | 0 | None 1413 | |
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 |
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]);