superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
132 rows where MNG_AGENCY = 87 sorted by ACRES
This data as json, copyable, CSV (advanced)
ACCESS_TYP 3
- Open Access 73
- No Public Access 41
- Restricted Access 18
MNG_AG_TYP 1
MNG_AGENCY 1
- East Bay Regional Park District · 132 ✖
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES ▼ | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2820 | 2820 | 2819 | {"type": "Polygon", "coordinates": [[[-122.02404, 37.66917], [-122.02383, 37.66911], [-122.02395, 37.66891], [-122.02396, 37.66892], [-122.02404, 37.66917]]]} | Restricted Access 2 | Chabot - Garin Trail Corridor | 17108 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 0.064 | Chabot - Garin Trail Corridor | ||
164 | 164 | 163 | {"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 | Lake Del Valle SRA | http://www.parks.ca.gov/?page_id=537 | 1594 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 0.204 | Lake Del Valle SRA | 2000 |
1514 | 1514 | 1513 | {"type": "Polygon", "coordinates": [[[-121.7508, 38.02106], [-121.75061, 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.02094], [-121.7508, 38.02096], [-121.7508, 38.02106]]]} | Open Access 1 | Antioch Bridge Fishing Pier | 15522 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 0.397 | Antioch Bridge Fishing Pier | ||
2263 | 2263 | 2262 | {"type": "Polygon", "coordinates": [[[-122.11236, 37.89111], [-122.11234, 37.89111], [-122.11224, 37.89126], [-122.11214, 37.89136], [-122.11187, 37.89147], [-122.11178, 37.89161], [-122.11167, 37.89192], [-122.11167, 37.89221], [-122.1114, 37.89225], [-122.11132, 37.89205], [-122.11155, 37.89177], [-122.11166, 37.89144], [-122.11195, 37.89118], [-122.1122, 37.89108], [-122.1122, 37.89103], [-122.11235, 37.89102], [-122.11236, 37.89111]]]} | Open Access 1 | Briones/Las Trampas Trail | 16396 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 0.767 | Briones/Las Trampas Trail | ||
12220 | 12220 | 12219 | {"type": "Polygon", "coordinates": [[[-122.16888, 37.8072], [-122.16832, 37.80721], [-122.16831, 37.80674], [-122.16805, 37.80673], [-122.16806, 37.80645], [-122.16886, 37.8061], [-122.16888, 37.8072]]]} | No Public Access 3 | Redwood Regional Park | 30634 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 1.526 | Redwood RP | 1939 | |
7467 | 7467 | 7466 | {"type": "Polygon", "coordinates": [[[-122.3732, 37.97143], [-122.37282, 37.97158], [-122.37227, 37.97224], [-122.37225, 37.97251], [-122.37217, 37.97255], [-122.37148, 37.97255], [-122.37238, 37.97143], [-122.3732, 37.97143]]]} | No Public Access 3 | North Richmond Wetlands | 22856 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 1.611 | North Richmond Wetlands | ||
7893 | 7893 | 7892 | {"type": "Polygon", "coordinates": [[[-122.04279, 37.68931], [-122.04193, 37.68951], [-122.04197, 37.68984], [-122.0417, 37.68988], [-122.04139, 37.69003], [-122.04079, 37.69022], [-122.04108, 37.68972], [-122.04062, 37.6896], [-122.04169, 37.68901], [-122.04204, 37.68905], [-122.04279, 37.68931]]]} | Open Access 1 | Palomares Ridge | 23369 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2.619 | Palomares Ridge | ||
14078 | 14078 | 14077 | {"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 | Brooks Island Regional Preserve | 31524 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 3.175 | Brooks Island RPr | ||
8263 | 8263 | 8262 | {"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.74331], [-122.14342, 37.74306], [-122.14482, 37.7425], [-122.14526, 37.74311]]]} | Open Access 1 | Poaks Headquarters | 23819 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 3.418 | Poaks Headquarters | ||
9232 | 9232 | 9231 | {"type": "MultiPolygon", "coordinates": [[[[-121.96304, 37.93978], [-121.96305, 37.93982], [-121.96283, 37.94044], [-121.96271, 37.94113], [-121.96265, 37.94118], [-121.96266, 37.94099], [-121.96275, 37.9405], [-121.96283, 37.9402], [-121.963, 37.93975], [-121.96304, 37.93978]]], [[[-121.967, 37.94522], [-121.96692, 37.94523], [-121.96688, 37.94515], [-121.96662, 37.94479], [-121.9661, 37.94436], [-121.96423, 37.94346], [-121.96462, 37.94293], [-121.96447, 37.94288], [-121.96422, 37.94261], [-121.9641, 37.94241], [-121.96396, 37.94225], [-121.96369, 37.94199], [-121.96305, 37.94148], [-121.96287, 37.94147], [-121.9629, 37.94142], [-121.96307, 37.94142], [-121.96377, 37.94198], [-121.96401, 37.94221], [-121.96416, 37.94238], [-121.96429, 37.94259], [-121.96452, 37.94283], [-121.96475, 37.9429], [-121.96435, 37.94345], [-121.96617, 37.94432], [-121.9667, 37.94476], [-121.96695, 37.94513], [-121.967, 37.94522]]], [[[-121.96407, 37.93824], [-121.96335, 37.93918], [-121.96327, 37.9393], [-121.96312, 37.9396], [-121.96305, 37.93961], [-121.96316, 37.93934], [-121.96329, 37.93915], [-121.96399, 37.93823], [-121.96407, 37.93824]]], [[[-121.96826, 37.93546], [-121.96797, 37.93555], [-121.96726, 37.9357], [-121.96694, 37.93579], [-121.96664, 37.93591], [-121.96636, 37.93605], [-121.9661, 37.93622], [-121.96586, 37.93641], [-121.96569, 37.93657], [-121.96412, 37.93819], [-121.96404, 37.93818], [-121.96563, 37.93653], [-121.96585, 37.93633], [-121.9661, 37.93614], [-121.96637, 37.93598], [-121.96666, 37.93584], [-121.96696, 37.93572], [-121.96728, 37.93563], [-121.96782, 37.93553], [-121.96807, 37.93546], [-121.96826, 37.93546]]], [[[-121.96761, 37.94557], [-121.96754, 37.94563], [-121.96714, 37.94565], [-121.96699, 37.94536], [-121.96707, 37.94535], [-121.9672, 37.94559], [-121.96761, 37.94557]]], [[[-121.97369, 37.93539], [-121.97365, 37.93544], [-121.96855, 37.93551], [-121.96867, 37.93545], [-121.97369, 37.93539]]], [[[-122.08253, 37.97602], [-122.08247, 37.97608], [-122.08181, 37.97609], [-122.08181, 37.97604], [-122.08253, 37.97602]]], [[[-122.08523, 37.97718], [-122.08516, 37.97722], [-122.08511, 37.97722], [-122.08497, 37.97715], [-122.08485, 37.9771], [-122.08446, 37.97706], [-122.08405, 37.97641], [-122.08396, 37.97618], [-122.08386, 37.97606], [-122.08269, 37.97608], [-122.08276, 37.97602], [-122.08396, 37.976], [-122.08396, 37.97605], [-122.08403, 37.97614], [-122.08409, 37.97627], [-122.08413, 37.97639], [-122.08447, 37.97693], [-122.08458, 37.977], [-122.08484, 37.97704], [-122.08507, 37.97712], [-122.08514, 37.97711], [-122.08523, 37.97718]]]]} | Open Access 1 | California Riding and Hiking Trail | https://www.ebparks.org/parks/trails/california/default.htm | 33750 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 3.641 | California Riding and Hiking Trail | 1982 |
15458 | 15458 | 15457 | {"type": "Polygon", "coordinates": [[[-121.71401, 38.0024], [-121.71401, 38.00331], [-121.71393, 38.00334], [-121.7134, 38.00283], [-121.71283, 38.00253], [-121.71206, 38.00177], [-121.71201, 38.00107], [-121.71333, 38.00191], [-121.71401, 38.0024]]]} | Open Access 1 | Big Break Regional Trail | 16075 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 4.138 | Big Break Reg. Trail | ||
1850 | 1850 | 1849 | {"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 | BB Delta Shoreline Trail | 15905 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 4.737 | BB Delta Shoreline Trail | ||
4988 | 4988 | 4987 | {"type": "MultiPolygon", "coordinates": [[[[-122.1451, 37.64851], [-122.1451, 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 | Hayward Shoreline | 19762 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 5.419 | Hayward Shoreline | 1977 | |
3553 | 3553 | 3552 | {"type": "Polygon", "coordinates": [[[-122.0528, 37.99715], [-122.05267, 37.99768], [-122.05079, 37.99735], [-122.05078, 37.99734], [-122.05051, 37.99729], [-122.05017, 37.99726], [-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.04984, 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 | Delta/DeAnza Trail | 18077 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 5.446 | Delta/DeAnza Trail | ||
14198 | 14198 | 14197 | {"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 | Briones to Mount Diablo Trail | 33752 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 5.904 | Briones to Mount Diablo Trail | ||
11203 | 11203 | 11202 | {"type": "Polygon", "coordinates": [[[-122.37623, 37.95851], [-122.37478, 37.95896], [-122.37475, 37.95894], [-122.37382, 37.95922], [-122.37381, 37.95841], [-122.37423, 37.95841], [-122.37437, 37.95838], [-122.37437, 37.95836], [-122.37421, 37.95812], [-122.37426, 37.95805], [-122.37534, 37.95758], [-122.3757, 37.95745], [-122.37611, 37.9574], [-122.3762, 37.95742], [-122.37623, 37.95851]]]} | Open Access 1 | Wildcat Creek Trail | 27503 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 6.211 | Wildcat Creek Trail | ||
3019 | 3019 | 3018 | {"type": "Polygon", "coordinates": [[[-122.22124, 37.86457], [-122.22068, 37.86515], [-122.21997, 37.86481], [-122.21728, 37.86206], [-122.21756, 37.8619], [-122.21817, 37.86235], [-122.21846, 37.86264], [-122.21903, 37.86314], [-122.21933, 37.86325], [-122.21963, 37.86351], [-122.22001, 37.86389], [-122.22037, 37.86416], [-122.22067, 37.86434], [-122.22124, 37.86457]]]} | Open Access 1 | Claremont Canyon Regional Preserve | 17381 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 6.336 | Claremont Canyon RPr | 1985 | |
1523 | 1523 | 1522 | {"type": "Polygon", "coordinates": [[[-121.7518, 38.01968], [-121.75091, 38.01969], [-121.7509, 38.01963], [-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 | Antioch / Oakley Regional Shoreline | 15521 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 7.376 | Antioch / Oakley Reg. Shoreline | ||
7604 | 7604 | 7603 | {"type": "Polygon", "coordinates": [[[-121.73098, 38.00441], [-121.73064, 38.0048], [-121.73007, 38.00476], [-121.73001, 38.00463], [-121.72957, 38.00478], [-121.72957, 38.00463], [-121.72949, 38.00436], [-121.72888, 38.00407], [-121.72775, 38.00355], [-121.72714, 38.00337], [-121.72646, 38.00321], [-121.72603, 38.00306], [-121.72553, 38.00283], [-121.72515, 38.00269], [-121.72473, 38.00262], [-121.72411, 38.00265], [-121.72371, 38.00275], [-121.72337, 38.00287], [-121.72318, 38.0029], [-121.7232, 38.00179], [-121.73098, 38.00441]]]} | Restricted Access 2 | Oakley (Legless Lizard) Land Bank | 23030 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 7.853 | Oakley (Legless Lizard) Land Bank | ||
11595 | 11595 | 11594 | {"type": "Polygon", "coordinates": [[[-122.12119, 37.99183], [-122.12094, 37.99183], [-122.12073, 37.99142], [-122.12067, 37.99123], [-122.12053, 37.99101], [-122.12036, 37.99083], [-122.11953, 37.99054], [-122.11898, 37.99054], [-122.11859, 37.9907], [-122.11802, 37.99083], [-122.11755, 37.99121], [-122.11756, 37.99136], [-122.11778, 37.99163], [-122.11775, 37.99168], [-122.11747, 37.99159], [-122.11728, 37.99155], [-122.11673, 37.99148], [-122.11634, 37.99146], [-122.11634, 37.99047], [-122.11127, 37.99041], [-122.11081, 37.9904], [-122.11079, 37.99035], [-122.10885, 37.99033], [-122.10834, 37.98908], [-122.10817, 37.98839], [-122.10786, 37.98789], [-122.10639, 37.98388], [-122.10672, 37.98297], [-122.10679, 37.98298], [-122.10647, 37.98388], [-122.10794, 37.98791], [-122.10823, 37.98838], [-122.10839, 37.98906], [-122.10889, 37.99027], [-122.11086, 37.99029], [-122.11089, 37.99035], [-122.11116, 37.99036], [-122.12051, 37.99046], [-122.12055, 37.99051], [-122.12119, 37.99183]]]} | Open Access 1 | CA State Riding & Hiking Trail | http://www.ebparks.org/Page161.aspx | 28138 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 8.269 | CA State Riding & Hiking Trail |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);