units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
90 rows where COUNTY = 12 and MNG_AGENCY = 87 sorted by AGNCY_LEV
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL, YR_EST, GAP_STS
DES_TP 14
- Local Park 41
- Local Conservation Area 22
- Local Recreation Area 15
- Local Resource Management Area 2
- 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 49
- No Public Access 28
- Restricted Access 13
MNG_AG_TYP 1
MNG_AGENCY 1
- East Bay Regional Park District · 90 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16336 | 16336 | 16335 | {"type": "Polygon", "coordinates": [[[-121.83759, 37.97592], [-121.83299, 37.97585], [-121.82581, 37.9799], [-121.82385, 37.97979], [-121.82383, 37.97965], [-121.82147, 37.97953], [-121.82006, 37.97971], [-121.81763, 37.97959], [-121.8175, 37.97959], [-121.81684, 37.97977], [-121.81672, 37.97978], [-121.8147, 37.97943], [-121.81469, 37.97946], [-121.8142, 37.97938], [-121.81292, 37.97929], [-121.8128, 37.97929], [-121.81268, 37.97931], [-121.81191, 37.97964], [-121.81095, 37.9796], [-121.81049, 37.9796], [-121.80944, 37.97821], [-121.81013, 37.97849], [-121.81346, 37.97593], [-121.81438, 37.97557], [-121.81433, 37.96849], [-121.80559, 37.96849], [-121.80559, 37.9677], [-121.80563, 37.96767], [-121.80647, 37.96768], [-121.80719, 37.96766], [-121.80791, 37.96758], [-121.80861, 37.96745], [-121.80929, 37.96725], [-121.80994, 37.967], [-121.81055, 37.9667], [-121.81094, 37.96647], [-121.81179, 37.96593], [-121.81205, 37.96578], [-121.81225, 37.9657], [-121.81245, 37.96564], [-121.81288, 37.96556], [-121.82247, 37.96552], [-121.82255, 37.96573], [-121.82385, 37.96572], [-121.82386, 37.9656], [-121.83352, 37.96573], [-121.83382, 37.96588], [-121.83445, 37.96601], [-121.8375, 37.96763], [-121.83762, 37.96865], [-121.83759, 37.97592]]]} | Open Access 1 | 14204 | Contra Loma Regional Park | 13801 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/contra_loma | Contra Costa 12 | 767.487 | Contra Loma RP | 1968 | Local Park 2 | 4 |
3203 | 3203 | 3202 | {"type": "Polygon", "coordinates": [[[-122.15189, 37.91237], [-122.15162, 37.91242], [-122.15115, 37.91259], [-122.15097, 37.913], [-122.15058, 37.91318], [-122.15014, 37.91354], [-122.1495, 37.91367], [-122.14907, 37.91339], [-122.14839, 37.91364], [-122.14788, 37.91391], [-122.14793, 37.91422], [-122.1477, 37.91444], [-122.14739, 37.91458], [-122.14679, 37.91461], [-122.14637, 37.91474], [-122.14607, 37.91492], [-122.14574, 37.91484], [-122.14505, 37.91498], [-122.14476, 37.91524], [-122.14401, 37.91523], [-122.1438, 37.91536], [-122.14336, 37.9154], [-122.14278, 37.91562], [-122.14237, 37.91589], [-122.1417, 37.91597], [-122.1417, 37.91351], [-122.13655, 37.91349], [-122.13657, 37.90943], [-122.14171, 37.90944], [-122.14171, 37.91003], [-122.14183, 37.91005], [-122.14188, 37.91008], [-122.14208, 37.91044], [-122.14219, 37.91046], [-122.14263, 37.9103], [-122.14271, 37.9103], [-122.14277, 37.91035], [-122.14278, 37.91038], [-122.1428, 37.91066], [-122.14282, 37.9107], [-122.14287, 37.91074], [-122.14342, 37.91092], [-122.14367, 37.91114], [-122.14374, 37.91058], [-122.14364, 37.91038], [-122.14382, 37.91024], [-122.14401, 37.9098], [-122.14393, 37.90959], [-122.14401, 37.90944], [-122.14776, 37.90945], [-122.14659, 37.91025], [-122.14671, 37.91112], [-122.15189, 37.91113], [-122.15189, 37.91237]]]} | Open Access 1 | 28121 | Briones Regional Park | 3221 | 1163 | Lafayette, City of 236 | City 2 | City Agency 2 | http://www.ci.lafayette.ca.us/index.aspx?page=87 | City 2 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/briones | Contra Costa 12 | 146.367 | Briones RP | 1967 | Local Park 2 | 4 |
12624 | 12624 | 12623 | {"type": "Polygon", "coordinates": [[[-122.14874, 38.01489], [-122.14448, 38.01717], [-122.14388, 38.01674], [-122.14368, 38.01665], [-122.14379, 38.01658], [-122.14387, 38.0165], [-122.14414, 38.01615], [-122.14423, 38.016], [-122.14448, 38.01577], [-122.14462, 38.01569], [-122.1447, 38.01566], [-122.14493, 38.01567], [-122.14506, 38.01563], [-122.14511, 38.01555], [-122.14512, 38.01547], [-122.14508, 38.01538], [-122.14498, 38.0153], [-122.14481, 38.01521], [-122.14468, 38.01518], [-122.14455, 38.01519], [-122.14443, 38.01523], [-122.14428, 38.01537], [-122.14422, 38.0154], [-122.14374, 38.01547], [-122.14341, 38.01509], [-122.14283, 38.01544], [-122.14233, 38.01485], [-122.14243, 38.01478], [-122.14192, 38.01423], [-122.14269, 38.01377], [-122.14641, 38.01012], [-122.14872, 38.01014], [-122.14874, 38.01489]]]} | Open Access 1 | 29405 | Carquinez Strait Regional Shoreline | 6373 | 1198 | Martinez, City of 355 | City 2 | City Agency 2 | http://www.cityofmartinez.org/depts/recreation/parks/default.asp | City 2 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/carquinez | Contra Costa 12 | 68.537 | Carquinez Strait Reg. Shoreline | 1981 | Local Park 2 | 4 |
16703 | 16703 | 16702 | {"type": "MultiPolygon", "coordinates": [[[[-122.29767, 38.01516], [-122.2931, 38.01523], [-122.2931, 38.01523], [-122.2931, 38.01518], [-122.29362, 38.0145], [-122.29404, 38.01407], [-122.29503, 38.0131], [-122.29544, 38.01336], [-122.2963, 38.01406], [-122.29643, 38.01415], [-122.29638, 38.01422], [-122.29686, 38.01452], [-122.29767, 38.01516]]], [[[-122.30218, 38.01147], [-122.29948, 38.01538], [-122.297, 38.01385], [-122.29697, 38.01379], [-122.29699, 38.01375], [-122.29693, 38.01372], [-122.29685, 38.01377], [-122.29674, 38.01374], [-122.29559, 38.01283], [-122.29553, 38.01272], [-122.29605, 38.01224], [-122.2961, 38.01224], [-122.29559, 38.01272], [-122.29579, 38.01296], [-122.29666, 38.01364], [-122.29689, 38.01362], [-122.29698, 38.01357], [-122.29724, 38.01318], [-122.29733, 38.01309], [-122.29725, 38.01291], [-122.29726, 38.01286], [-122.2972, 38.01267], [-122.29715, 38.01244], [-122.29712, 38.0124], [-122.29679, 38.01224], [-122.29647, 38.01228], [-122.29633, 38.01239], [-122.29631, 38.01239], [-122.29626, 38.01236], [-122.29626, 38.01234], [-122.29634, 38.01225], [-122.29619, 38.01214], [-122.29612, 38.01217], [-122.29606, 38.01213], [-122.29662, 38.01164], [-122.30218, 38.01147]]]]} | Open Access 1 | 46985 | San Pablo Bay Regional Shoreline | 24965 | 1252 | Pinole, City of 357 | City 2 | City Agency 2 | http://www.ci.pinole.ca.us/recreation/parks.html | City 2 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 43.391 | San Pablo Bay Reg. Shoreline | 0 | Local Park 2 | 4 | |
16843 | 16843 | 16842 | {"type": "Polygon", "coordinates": [[[-122.14658, 37.99988], [-122.14497, 38.0021], [-122.14423, 38.00587], [-122.14311, 38.00586], [-122.13961, 38.00744], [-122.13941, 38.00652], [-122.13934, 38.00538], [-122.13895, 38.00276], [-122.13895, 38.00127], [-122.13854, 38.00037], [-122.13812, 37.99829], [-122.13646, 37.99808], [-122.13547, 37.99708], [-122.13581, 37.99686], [-122.13595, 37.99664], [-122.1362, 37.99662], [-122.14184, 37.99588], [-122.14143, 37.99374], [-122.14094, 37.9933], [-122.14187, 37.99354], [-122.14257, 37.99596], [-122.1445, 37.99725], [-122.14453, 37.99733], [-122.14372, 37.99756], [-122.14298, 37.99779], [-122.14298, 37.9978], [-122.1445, 37.99934], [-122.14484, 37.99915], [-122.14531, 37.99942], [-122.14573, 37.99933], [-122.14658, 37.99988]]]} | Open Access 1 | 29556 | Carquinez Strait Regional Shoreline | 6373 | 1198 | Martinez, City of 355 | City 2 | City Agency 2 | http://www.cityofmartinez.org/depts/recreation/parks/default.asp | City 2 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/carquinez | Contra Costa 12 | 160.333 | Carquinez Strait Reg. Shoreline | 1981 | Local Park 2 | 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 | |
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 | |||
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 | |
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 | |
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 | |
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 | |
3773 | 3773 | 3772 | {"type": "Polygon", "coordinates": [[[-121.84132, 37.74732], [-121.84129, 37.7523], [-121.8324, 37.75239], [-121.83241, 37.75942], [-121.82329, 37.75956], [-121.82326, 37.75633], [-121.82328, 37.75238], [-121.8206, 37.75236], [-121.84132, 37.74732]]]} | No Public Access 3 | 35010 | Doolan Canyon Regional Preserve | 33749 | 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 | 283.15 | Doolan Canyon RPr | 2010 | Local Conservation Area 4 | 2 | |
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 | |||
4299 | 4299 | 4298 | {"type": "Polygon", "coordinates": [[[-121.7518, 38.01968], [-121.75091, 38.01969], [-121.7509, 38.01962], [-121.75076, 38.01962], [-121.75075, 38.01954], [-121.75067, 38.01953], [-121.75068, 38.01915], [-121.75068, 38.01845], [-121.75062, 38.01784], [-121.75069, 38.01749], [-121.75069, 38.01643], [-121.75071, 38.01657], [-121.7508, 38.01673], [-121.7509, 38.01684], [-121.75104, 38.01693], [-121.75122, 38.01701], [-121.75137, 38.01703], [-121.75179, 38.01704], [-121.7518, 38.01968]]]} | Open Access 1 | 45338 | Antioch / Oakley Regional Shoreline | 15521 | 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.375 | Antioch / Oakley Reg. Shoreline | 0 | Local Park 2 | 4 | |
5607 | 5607 | 5606 | {"type": "Polygon", "coordinates": [[[-121.99805, 37.90236], [-121.99346, 37.90195], [-121.99291, 37.90125], [-121.99278, 37.90102], [-121.9927, 37.90078], [-121.9926, 37.9006], [-121.99246, 37.90043], [-121.99237, 37.90036], [-121.99218, 37.90024], [-121.99085, 37.89958], [-121.99095, 37.89942], [-121.99097, 37.89941], [-121.99251, 37.89731], [-121.99359, 37.8979], [-121.99572, 37.89966], [-121.99752, 37.89939], [-121.99805, 37.90236]]]} | No Public Access 3 | 46993 | Diablo Foothills Regional Park | 30631 | 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 | 46.446 | Diablo Foothills RP | 0 | Local Park 2 | 4 | |
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 | |
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 | |||
5883 | 5883 | 5882 | {"type": "Polygon", "coordinates": [[[-121.79615, 37.84596], [-121.79612, 37.85312], [-121.78698, 37.85311], [-121.78682, 37.86267], [-121.7869, 37.86771], [-121.76938, 37.8679], [-121.75848, 37.8682], [-121.75124, 37.86778], [-121.74761, 37.8678], [-121.74759, 37.86706], [-121.74713, 37.86697], [-121.74651, 37.86696], [-121.74643, 37.8669], [-121.74623, 37.86694], [-121.74596, 37.86696], [-121.74577, 37.86703], [-121.74561, 37.86711], [-121.74553, 37.8671], [-121.7452, 37.867], [-121.74488, 37.86694], [-121.7445, 37.86682], [-121.74398, 37.8668], [-121.7439, 37.86682], [-121.74331, 37.86684], [-121.74332, 37.86446], [-121.74207, 37.86445], [-121.74225, 37.85418], [-121.74225, 37.85306], [-121.75089, 37.85318], [-121.76983, 37.85308], [-121.769, 37.84586], [-121.77327, 37.84574], [-121.78699, 37.84591], [-121.7916, 37.84595], [-121.79615, 37.84596]]]} | Open Access 1 | 280 | Round Valley Regional Park | 3309 | 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 | http://www.ebparks.org/parks/round_valley | Contra Costa 12 | 2043.438 | Round Valley RP | 1988 | Local Park 2 | 4 |
6043 | 6043 | 6042 | {"type": "Polygon", "coordinates": [[[-122.26792, 37.96302], [-122.26857, 37.96816], [-122.26709, 37.974], [-122.26116, 37.97362], [-122.25988, 37.97196], [-122.25803, 37.97045], [-122.25843, 37.97011], [-122.25925, 37.97024], [-122.25905, 37.9699], [-122.25909, 37.96979], [-122.25944, 37.96981], [-122.25945, 37.9698], [-122.25937, 37.96937], [-122.25917, 37.9691], [-122.25945, 37.96877], [-122.26023, 37.96872], [-122.26042, 37.96845], [-122.26044, 37.96786], [-122.25934, 37.96664], [-122.25928, 37.96632], [-122.25876, 37.96567], [-122.25836, 37.96559], [-122.25836, 37.96533], [-122.25857, 37.96513], [-122.25858, 37.96488], [-122.25837, 37.9646], [-122.25816, 37.9646], [-122.25802, 37.96456], [-122.25792, 37.96466], [-122.25781, 37.96453], [-122.25605, 37.96454], [-122.25633, 37.96429], [-122.25636, 37.96409], [-122.25628, 37.96388], [-122.2557, 37.96378], [-122.25569, 37.96356], [-122.25557, 37.96322], [-122.25763, 37.96279], [-122.25906, 37.96256], [-122.25948, 37.96236], [-122.25958, 37.96227], [-122.26003, 37.96162], [-122.26043, 37.96117], [-122.26075, 37.96101], [-122.2628, 37.96024], [-122.2637, 37.95959], [-122.26792, 37.96302]]]} | Open Access 1 | 945 | Sobrante Ridge Regional Preserve | 3319 | 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 | http://www.ebparks.org/parks/sobrante_ridge | Contra Costa 12 | 276.758 | Sobrante Ridge RPr | 1988 | 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]);