units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
101 rows where ACCESS_TYP = 1 and MNG_AGENCY = 87 sorted by AGNCY_LEV
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
DES_TP 15
- Local Park 46
- Local Recreation Area 24
- Local Conservation Area 19
- 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
ACCESS_TYP 1
- Open Access · 101 ✖
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 |
2090 | 2090 | 2089 | {"type": "Polygon", "coordinates": [[[-122.05671, 37.55736], [-122.0544, 37.55828], [-122.05314, 37.5588], [-122.04939, 37.56032], [-122.04849, 37.56072], [-122.04831, 37.56073], [-122.04627, 37.56161], [-122.04605, 37.56164], [-122.04542, 37.56193], [-122.04503, 37.56213], [-122.0441, 37.56252], [-122.0439, 37.56253], [-122.04307, 37.56293], [-122.04186, 37.56437], [-122.04173, 37.56445], [-122.04168, 37.56459], [-122.04131, 37.56503], [-122.0412, 37.56504], [-122.04107, 37.56502], [-122.04083, 37.56479], [-122.04047, 37.56459], [-122.0404, 37.56449], [-122.04033, 37.56428], [-122.04031, 37.56414], [-122.04031, 37.56402], [-122.04036, 37.56354], [-122.04036, 37.56327], [-122.0403, 37.56299], [-122.04025, 37.56288], [-122.04027, 37.56275], [-122.0403, 37.56263], [-122.04065, 37.56208], [-122.04081, 37.5619], [-122.04066, 37.56181], [-122.04149, 37.56063], [-122.04314, 37.55856], [-122.04394, 37.5578], [-122.04503, 37.55688], [-122.04532, 37.55689], [-122.04642, 37.55805], [-122.04676, 37.55788], [-122.04654, 37.55734], [-122.04642, 37.55712], [-122.04632, 37.55697], [-122.0459, 37.55665], [-122.04582, 37.55652], [-122.0458, 37.55642], [-122.0468, 37.55556], [-122.04925, 37.55413], [-122.05039, 37.55358], [-122.05071, 37.55347], [-122.0528, 37.5525], [-122.05356, 37.55289], [-122.05494, 37.55332], [-122.05588, 37.55343], [-122.05671, 37.55736]]]} | Open Access 1 | 17282 | Ardenwood Historic Farm | 3820 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/ardenwood | Alameda 17 | 202.709 | Ardenwood Historic Farm | 1985 | Local Historic or Cultural Area 19 | 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 |
11508 | 11508 | 11507 | {"type": "Polygon", "coordinates": [[[-122.00857, 37.57719], [-122.00838, 37.57734], [-122.00814, 37.57765], [-122.00798, 37.57795], [-122.00791, 37.57818], [-122.00786, 37.57854], [-122.00788, 37.57885], [-122.00793, 37.5791], [-122.0079, 37.57918], [-122.00795, 37.57921], [-122.00802, 37.57938], [-122.00812, 37.57947], [-122.00685, 37.57917], [-122.00706, 37.57859], [-122.00718, 37.57861], [-122.00735, 37.57827], [-122.0076, 37.57793], [-122.00781, 37.57772], [-122.008, 37.57756], [-122.00857, 37.57719]]]} | Open Access 1 | 29555 | Quarry Lakes Regional Recreation Area | 30594 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 2.872 | Quarry Lakes Reg. Rec. Area | 2001 | Local Recreation Area 3 | 4 | |
12619 | 12619 | 12618 | {"type": "Polygon", "coordinates": [[[-121.90962, 37.5042], [-121.90908, 37.50427], [-121.90891, 37.50432], [-121.90874, 37.5044], [-121.90856, 37.50454], [-121.90791, 37.50522], [-121.90852, 37.50826], [-121.90692, 37.50847], [-121.90647, 37.50889], [-121.90638, 37.50913], [-121.90662, 37.50945], [-121.90668, 37.50984], [-121.90655, 37.51047], [-121.90559, 37.51121], [-121.90509, 37.51143], [-121.90475, 37.51146], [-121.90409, 37.51164], [-121.90357, 37.51162], [-121.90283, 37.512], [-121.90193, 37.51238], [-121.90179, 37.51275], [-121.90132, 37.51305], [-121.90086, 37.51305], [-121.90053, 37.5134], [-121.8998, 37.51369], [-121.8995, 37.51384], [-121.89887, 37.51388], [-121.89793, 37.51408], [-121.89749, 37.51456], [-121.89724, 37.51509], [-121.89709, 37.5152], [-121.89675, 37.51533], [-121.89643, 37.51539], [-121.89623, 37.51557], [-121.8957, 37.51581], [-121.8952, 37.51621], [-121.89518, 37.51658], [-121.89505, 37.51675], [-121.89607, 37.51717], [-121.8973, 37.5191], [-121.89559, 37.51979], [-121.89411, 37.52032], [-121.8925, 37.5181], [-121.89141, 37.51714], [-121.89084, 37.5161], [-121.88835, 37.51567], [-121.88969, 37.51394], [-121.8902, 37.51374], [-121.8902, 37.51372], [-121.88923, 37.51314], [-121.8853, 37.51061], [-121.88081, 37.50774], [-121.88034, 37.507], [-121.87949, 37.50554], [-121.87889, 37.50392], [-121.87864, 37.50347], [-121.87699, 37.50033], [-121.90406, 37.49917], [-121.90419, 37.50092], [-121.90436, 37.50153], [-121.90334, 37.50181], [-121.90374, 37.5027], [-121.90413, 37.50285], [-121.90419, 37.50262], [-121.90474, 37.50247], [-121.90481, 37.50262], [-121.9051, 37.50314], [-121.90544, 37.50333], [-121.90595, 37.50335], [-121.9061, 37.50431], [-121.90775, 37.50405], [-121.9092, 37.50408], [-121.9096, 37.50404], [-121.90962, 37.5042]]]} | Open Access 1 | 29420 | Mission Peak Regional Preserve | 3844 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/mission | Alameda 17 | 897.286 | Mission Peak RPr | 1976 | Local Conservation Area 4 | 2 |
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 |
15136 | 15136 | 15135 | {"type": "Polygon", "coordinates": [[[-122.30225, 37.84721], [-122.30092, 37.84749], [-122.30086, 37.84731], [-122.30077, 37.84713], [-122.30066, 37.84697], [-122.30052, 37.84682], [-122.30027, 37.84663], [-122.29902, 37.84581], [-122.29886, 37.84568], [-122.29873, 37.84553], [-122.29859, 37.84527], [-122.29849, 37.84497], [-122.29858, 37.84494], [-122.29844, 37.84436], [-122.30225, 37.84436], [-122.30225, 37.84721]]]} | Open Access 1 | 46002 | Point Emery Park | 29208 | 1098 | Emeryville, City of 790 | City 2 | City Agency 2 | http://www.ci.emeryville.ca.us/158/City-Parks | City 2 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebarks.org | Alameda 17 | 20.687 | Point Emery Park | 0 | 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 |
16854 | 16854 | 16853 | {"type": "Polygon", "coordinates": [[[-122.27281, 37.7628], [-122.27158, 37.76221], [-122.25694, 37.75677], [-122.25495, 37.75605], [-122.25057, 37.75438], [-122.24678, 37.75296], [-122.24667, 37.75307], [-122.24506, 37.75247], [-122.23877, 37.75051], [-122.23679, 37.74987], [-122.23701, 37.74992], [-122.23762, 37.75012], [-122.23783, 37.75017], [-122.23803, 37.75025], [-122.23854, 37.75039], [-122.23935, 37.75064], [-122.23973, 37.7507], [-122.24, 37.75076], [-122.24037, 37.75089], [-122.24067, 37.75091], [-122.24082, 37.75098], [-122.24094, 37.75106], [-122.24105, 37.7511], [-122.24119, 37.75113], [-122.24164, 37.75117], [-122.24183, 37.75116], [-122.24206, 37.75119], [-122.24283, 37.75148], [-122.24307, 37.75153], [-122.24327, 37.75161], [-122.24361, 37.75182], [-122.2437, 37.75185], [-122.24381, 37.75184], [-122.24391, 37.75181], [-122.24418, 37.75168], [-122.24432, 37.75167], [-122.24451, 37.75168], [-122.24464, 37.7517], [-122.24488, 37.75178], [-122.24503, 37.75181], [-122.2454, 37.75182], [-122.2457, 37.75188], [-122.24598, 37.75199], [-122.24614, 37.75208], [-122.24629, 37.7521], [-122.24662, 37.75211], [-122.2469, 37.75216], [-122.24704, 37.75222], [-122.24723, 37.75234], [-122.24741, 37.75237], [-122.24766, 37.75238], [-122.24792, 37.75235], [-122.24807, 37.75235], [-122.24853, 37.75245], [-122.24874, 37.75252], [-122.24895, 37.75264], [-122.24904, 37.75272], [-122.24908, 37.75279], [-122.2491, 37.7529], [-122.24913, 37.75299], [-122.24923, 37.75305], [-122.24936, 37.75308], [-122.24943, 37.75314], [-122.24947, 37.75326], [-122.24946, 37.75338], [-122.24951, 37.75343], [-122.24968, 37.75354], [-122.24987, 37.75363], [-122.25, 37.75371], [-122.25018, 37.75377], [-122.25024, 37.75376], [-122.25038, 37.75371], [-122.25048, 37.7537], [-122.25076, 37.7538], [-122.25101, 37.75394], [-122.25115, 37.75405], [-122.25127, 37.7541], [-122.25173, 37.75415], [-122.25242, 37.75433], [-122.25361, 37.7547], [-122.25394, 37.75483], [-122.2543, 37.75502], [-122.25492, 37.75527], [-122.25505, 37.75532], [-122.25512, 37.75533], [-122.25525, 37.75541], [-122.25561, 37.75555], [-122.25599, 37.75577], [-122.2562, 37.75586], [-122.2567, 37.75613], [-122.2575, 37.75644], [-122.25802, 37.7566], [-122.25877, 37.75693], [-122.25908, 37.7571], [-122.25986, 37.75741], [-122.26011, 37.75749], [-122.26051, 37.7575], [-122.2609, 37.75757], [-122.26136, 37.7577], [-122.26176, 37.75789], [-122.26223, 37.75816], [-122.26272, 37.75841], [-122.26334, 37.75869], [-122.26407, 37.75895], [-122.26445, 37.75906], [-122.2647, 37.75907], [-122.2656, 37.75939], [-122.26631, 37.75957], [-122.26674, 37.7597], [-122.26892, 37.76054], [-122.27008, 37.76105], [-122.27047, 37.7612], [-122.27093, 37.76141], [-122.27142, 37.7617], [-122.27203, 37.76211], [-122.27224, 37.76233], [-122.27273, 37.76269], [-122.27281, 37.7628]]]} | Open Access 1 | 46017 | Crown Memorial Regional Shoreline | 1486 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/crown_beach | Alameda 17 | 47.607 | Crown Memorial Reg. Shoreline | 1967 | 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 | |
16850 | 16850 | 16849 | {"type": "MultiPolygon", "coordinates": [[[[-121.79156, 37.50476], [-121.79134, 37.51904], [-121.77329, 37.51942], [-121.77349, 37.50472], [-121.79132, 37.50475], [-121.79156, 37.50476]]], [[[-121.87405, 37.50648], [-121.87397, 37.51447], [-121.86949, 37.51447], [-121.86944, 37.51803], [-121.86487, 37.5181], [-121.86496, 37.52091], [-121.86052, 37.52093], [-121.84804, 37.52104], [-121.84802, 37.52104], [-121.84789, 37.52089], [-121.84764, 37.52114], [-121.84773, 37.52161], [-121.84789, 37.52188], [-121.84795, 37.52219], [-121.8479, 37.52282], [-121.84792, 37.52308], [-121.84791, 37.52344], [-121.84757, 37.52368], [-121.84771, 37.52423], [-121.84792, 37.52445], [-121.84807, 37.52452], [-121.84827, 37.5249], [-121.84836, 37.52516], [-121.84844, 37.52517], [-121.84862, 37.52509], [-121.849, 37.52561], [-121.84932, 37.52585], [-121.84964, 37.52624], [-121.84971, 37.52644], [-121.84984, 37.52663], [-121.85003, 37.52681], [-121.84991, 37.52694], [-121.85014, 37.52694], [-121.85003, 37.52711], [-121.85056, 37.5274], [-121.85086, 37.52788], [-121.85115, 37.52822], [-121.85145, 37.52836], [-121.85152, 37.52838], [-121.85173, 37.52861], [-121.85198, 37.52883], [-121.85229, 37.52915], [-121.85217, 37.5293], [-121.85244, 37.52935], [-121.8526, 37.52988], [-121.85281, 37.53021], [-121.85271, 37.5302], [-121.85276, 37.53032], [-121.85277, 37.53054], [-121.85263, 37.5307], [-121.85212, 37.53148], [-121.85209, 37.5316], [-121.85203, 37.53169], [-121.85168, 37.53269], [-121.85171, 37.5335], [-121.8519, 37.53405], [-121.85216, 37.53445], [-121.85237, 37.5348], [-121.85267, 37.53514], [-121.85287, 37.53547], [-121.85305, 37.53569], [-121.8528, 37.53564], [-121.85263, 37.53557], [-121.85226, 37.53555], [-121.85196, 37.53559], [-121.85142, 37.53574], [-121.85089, 37.53583], [-121.85049, 37.53588], [-121.85023, 37.5359], [-121.85, 37.53589], [-121.84978, 37.53595], [-121.8493, 37.53591], [-121.84871, 37.53615], [-121.84833, 37.53615], [-121.84796, 37.53606], [-121.84773, 37.53609], [-121.84735, 37.53629], [-121.84716, 37.53648], [-121.84685, 37.53674], [-121.84646, 37.53688], [-121.84617, 37.53694], [-121.84582, 37.53694], [-121.84552, 37.53705], [-121.84521, 37.53709], [-121.84463, 37.53699], [-121.84444, 37.53701], [-121.84434, 37.53704], [-121.84415, 37.53703], [-121.84384, 37.53693], [-121.84343, 37.5369], [-121.84339, 37.53685], [-121.84323, 37.53683], [-121.84325, 37.5352], [-121.83885, 37.5352], [-121.8389, 37.52886], [-121.83433, 37.52892], [-121.83432, 37.52138], [-121.83435, 37.51299], [-121.8282, 37.51317], [-121.82799, 37.51335], [-121.82789, 37.51329], [-121.82778, 37.51319], [-121.82478, 37.51328], [-121.82498, 37.50593], [-121.81606, 37.50569], [-121.81589, 37.50578], [-121.81578, 37.52129], [-121.80715, 37.52064], [-121.80686, 37.50545], [-121.81386, 37.50563], [-121.81415, 37.5054], [-121.81492, 37.50464], [-121.81576, 37.50409], [-121.81698, 37.5036], [-121.81907, 37.50437], [-121.81948, 37.50513], [-121.81977, 37.50495], [-121.81956, 37.50443], [-121.81987, 37.50434], [-121.82052, 37.5033], [-121.8222, 37.50333], [-121.82486, 37.50313], [-121.82524, 37.50319], [-121.82543, 37.50361], [-121.82565, 37.50399], [-121.82603, 37.50385], [-121.82641, 37.50342], [-121.82703, 37.50361], [-121.82791, 37.50396], [-121.82867, 37.50442], [-121.82899, 37.5048], [-121.83019, 37.50608], [-121.84289, 37.50646], [-121.85985, 37.50665], [-121.85999, 37.50648], [-121.86938, 37.50648], [-121.86939, 37.50649], [-121.87405, 37.50648]], [[-121.85612, 37.51725], [-121.85397, 37.51724], [-121.85395, 37.5181], [-121.85611, 37.51811], [-121.85612, 37.51725]]]]} | Open Access 1 | 29545 | Sunol Regional Wilderness | 10841 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/sunol | Alameda 17 | 2997.505 | Sunol Reg. Wilderness | 1962 | Local Conservation Area 4 | 2 |
218 | 218 | 217 | {"type": "MultiPolygon", "coordinates": [[[[-122.00283, 37.56787], [-122.00528, 37.56886], [-122.00536, 37.56876], [-122.00637, 37.56915], [-122.00646, 37.56905], [-122.00694, 37.56924], [-122.00841, 37.57037], [-122.00605, 37.57247], [-122.00581, 37.57272], [-122.00563, 37.57245], [-122.00561, 37.57245], [-122.00486, 37.57485], [-122.00167, 37.57418], [-122.00088, 37.57663], [-122.00033, 37.5765], [-121.99656, 37.57363], [-121.99685, 37.57277], [-121.99721, 37.57285], [-121.99723, 37.57284], [-121.99743, 37.56696], [-121.99852, 37.56669], [-121.99871, 37.5667], [-121.9987, 37.56677], [-121.99916, 37.56686], [-121.99961, 37.56698], [-122.00112, 37.56756], [-122.0012, 37.56746], [-122.00224, 37.56786], [-122.00235, 37.56771], [-122.00283, 37.56787]]], [[[-122.00227, 37.57706], [-122.00224, 37.57716], [-122.00227, 37.57718], [-122.00203, 37.57784], [-122.0005, 37.57666], [-122.00227, 37.57706]]], [[[-122.01347, 37.57268], [-122.01183, 37.57446], [-122.01014, 37.57619], [-122.00994, 37.57635], [-122.00973, 37.57651], [-122.00895, 37.57696], [-122.00821, 37.57742], [-122.00796, 37.57759], [-122.0077, 37.57782], [-122.00748, 37.57808], [-122.0073, 37.57835], [-122.00718, 37.57862], [-122.00706, 37.5786], [-122.00686, 37.57917], [-122.00811, 37.57947], [-122.00818, 37.57956], [-122.00772, 37.58092], [-122.00605, 37.58056], [-122.00568, 37.58164], [-122.00418, 37.58051], [-122.00216, 37.57896], [-122.00209, 37.57889], [-122.00203, 37.5788], [-122.00198, 37.57866], [-122.002, 37.57851], [-122.00244, 37.57734], [-122.00248, 37.57728], [-122.00258, 37.57724], [-122.003, 37.57733], [-122.00424, 37.57807], [-122.00588, 37.57674], [-122.00592, 37.57631], [-122.01114, 37.57138], [-122.01347, 37.57268]]]]} | Open Access 1 | 586 | Quarry Lakes Regional Recreation Area | 30594 | 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 | 254.616 | Quarry Lakes Reg. Rec. Area | 2001 | Local Recreation Area 3 | 4 | |
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 | |||
1218 | 1218 | 1217 | {"type": "MultiPolygon", "coordinates": [[[[-122.1451, 37.64851], [-122.14511, 37.64897], [-122.14509, 37.64903], [-122.14501, 37.64917], [-122.14486, 37.64934], [-122.14456, 37.64957], [-122.14429, 37.64973], [-122.14412, 37.64979], [-122.14409, 37.64745], [-122.14507, 37.64744], [-122.1451, 37.64851]]], [[[-122.14586, 37.6471], [-122.14517, 37.64711], [-122.14517, 37.64682], [-122.14586, 37.64682], [-122.14586, 37.6471]]]]} | Open Access 1 | 8671 | Hayward Shoreline | 19762 | 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 | 5.421 | Hayward Shoreline | 1977 | Local Park 2 | 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 | |
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 | |
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 |
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]);