superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
84 rows where MNG_AGENCY = 253 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14069 | 14069 | 14068 | {"type": "Polygon", "coordinates": [[[-122.08221, 37.69769], [-122.08102, 37.69769], [-122.08099, 37.69634], [-122.08217, 37.69632], [-122.08221, 37.69769]]]} | Open Access 1 | Adobe Park | http://www.haywardrec.org/facilities/facility/details/Adobe-Park-116 | 31505 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 3.893 | Adobe Park | |
1439 | 1439 | 1438 | {"type": "Polygon", "coordinates": [[[-122.08989, 37.61048], [-122.08987, 37.61053], [-122.08977, 37.61052], [-122.08967, 37.61056], [-122.08963, 37.61061], [-122.08961, 37.61069], [-122.08957, 37.61073], [-122.08562, 37.61228], [-122.08557, 37.61229], [-122.08553, 37.61227], [-122.0855, 37.61225], [-122.08428, 37.61025], [-122.08437, 37.6101], [-122.08512, 37.60981], [-122.0861, 37.60938], [-122.08619, 37.60938], [-122.08648, 37.60926], [-122.08681, 37.60932], [-122.08724, 37.60918], [-122.08742, 37.60915], [-122.08761, 37.60915], [-122.08791, 37.60919], [-122.08818, 37.60928], [-122.08836, 37.60916], [-122.08989, 37.61048]]]} | Open Access 1 | Alden E. Oliver Sports Park | 15344 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 25.025 | Alden E. Oliver Sports Park | ||
1634 | 1634 | 1633 | {"type": "Polygon", "coordinates": [[[-122.10782, 37.69342], [-122.10723, 37.69384], [-122.107, 37.69365], [-122.10684, 37.69376], [-122.1067, 37.69364], [-122.10697, 37.69343], [-122.10661, 37.69311], [-122.10689, 37.6929], [-122.10694, 37.69288], [-122.10694, 37.69286], [-122.10699, 37.69283], [-122.10782, 37.69342]]]} | Open Access 1 | Ashland Park | 15654 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 1.491 | Ashland Park | ||
1826 | 1826 | 1825 | {"type": "Polygon", "coordinates": [[[-122.05682, 37.70364], [-122.0564, 37.70375], [-122.05514, 37.70372], [-122.05489, 37.70318], [-122.05456, 37.70286], [-122.05383, 37.70232], [-122.05378, 37.70221], [-122.05378, 37.70212], [-122.05386, 37.70191], [-122.05575, 37.70138], [-122.05582, 37.70159], [-122.05567, 37.70185], [-122.05613, 37.70198], [-122.05682, 37.70364]]]} | Open Access 1 | Bay Trees Park | 15882 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 10.113 | Bay Trees Park | ||
1876 | 1876 | 1875 | {"type": "Polygon", "coordinates": [[[-122.06106, 37.63806], [-122.06102, 37.63812], [-122.06103, 37.63819], [-122.06072, 37.63834], [-122.06026, 37.63776], [-122.06057, 37.6376], [-122.06066, 37.63766], [-122.06077, 37.63765], [-122.06106, 37.63806]]]} | Open Access 1 | Bechtel Mini Park | 15943 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 0.774 | Bechtel MP | ||
1990 | 1990 | 1989 | {"type": "Polygon", "coordinates": [[[-122.04353, 37.6184], [-122.04178, 37.61966], [-122.04028, 37.61836], [-122.04197, 37.61708], [-122.04353, 37.6184]]]} | Open Access 1 | Bidwell Park | 16069 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 10.154 | Bidwell Park | ||
2028 | 2028 | 2027 | {"type": "Polygon", "coordinates": [[[-122.09878, 37.65729], [-122.09825, 37.6575], [-122.09773, 37.65671], [-122.09751, 37.65644], [-122.09709, 37.65605], [-122.09672, 37.65574], [-122.09648, 37.65547], [-122.09632, 37.6551], [-122.09726, 37.65473], [-122.09878, 37.65729]]]} | Open Access 1 | Birchfield Park | 16118 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 5.571 | Birchfield Park | ||
318 | 318 | 317 | {"type": "Polygon", "coordinates": [[[-122.10346, 37.63089], [-122.10346, 37.63092], [-122.10342, 37.63095], [-122.10209, 37.63146], [-122.10118, 37.63149], [-122.10113, 37.62978], [-122.10242, 37.62927], [-122.10248, 37.6293], [-122.10346, 37.63089]]]} | Restricted Access 2 | Brenkwitz School Park | 31949 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 8.676 | Brenkwitz School Park | ||
2586 | 2586 | 2585 | {"type": "MultiPolygon", "coordinates": [[[[-122.09848, 37.6662], [-122.09842, 37.66627], [-122.09778, 37.66645], [-122.09657, 37.66695], [-122.09658, 37.66685], [-122.09655, 37.66675], [-122.09646, 37.66666], [-122.09633, 37.66659], [-122.09627, 37.66653], [-122.09624, 37.66646], [-122.09624, 37.66632], [-122.09623, 37.66623], [-122.09615, 37.66613], [-122.09604, 37.66606], [-122.0961, 37.66601], [-122.09614, 37.66592], [-122.09613, 37.66585], [-122.09609, 37.66577], [-122.09603, 37.66572], [-122.09593, 37.66568], [-122.09583, 37.66567], [-122.09573, 37.6657], [-122.09569, 37.66565], [-122.09552, 37.66571], [-122.09542, 37.66556], [-122.09598, 37.66533], [-122.09605, 37.66536], [-122.09734, 37.66483], [-122.09751, 37.6647], [-122.09754, 37.6647], [-122.09759, 37.66472], [-122.09774, 37.66485], [-122.09775, 37.66489], [-122.09774, 37.66494], [-122.09781, 37.66499], [-122.09787, 37.66498], [-122.09791, 37.665], [-122.09798, 37.66507], [-122.09797, 37.66513], [-122.09803, 37.66519], [-122.09809, 37.66518], [-122.09813, 37.6652], [-122.09832, 37.66536], [-122.0984, 37.66548], [-122.09846, 37.6656], [-122.09848, 37.66577], [-122.09848, 37.6662]]], [[[-122.09979, 37.66635], [-122.09965, 37.66634], [-122.09922, 37.66653], [-122.09922, 37.66654], [-122.09962, 37.6669], [-122.09929, 37.66705], [-122.09921, 37.66703], [-122.09892, 37.66677], [-122.09883, 37.66665], [-122.09877, 37.66653], [-122.09875, 37.66646], [-122.09873, 37.66624], [-122.09873, 37.66586], [-122.09872, 37.66572], [-122.09864, 37.66551], [-122.09851, 37.66533], [-122.09853, 37.66528], [-122.09855, 37.66527], [-122.09979, 37.66635]]]]} | Open Access 1 | Cannery Park | 16803 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 11.105 | Cannery Park | ||
2605 | 2605 | 2604 | {"type": "Polygon", "coordinates": [[[-122.03644, 37.65092], [-122.03581, 37.65096], [-122.03481, 37.65153], [-122.03382, 37.65111], [-122.03393, 37.65094], [-122.03406, 37.65079], [-122.03463, 37.65028], [-122.03484, 37.65004], [-122.03481, 37.65], [-122.03496, 37.64975], [-122.035, 37.64973], [-122.03514, 37.64979], [-122.03553, 37.65008], [-122.03596, 37.65036], [-122.03605, 37.65047], [-122.03598, 37.65055], [-122.03644, 37.65092]]]} | Open Access 1 | Canyon View Park | 16828 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 5.422 | Canyon View Park | ||
2631 | 2631 | 2630 | {"type": "Polygon", "coordinates": [[[-122.08308, 37.68418], [-122.08272, 37.68452], [-122.08234, 37.68439], [-122.08172, 37.68431], [-122.08168, 37.68382], [-122.0816, 37.68341], [-122.08094, 37.68258], [-122.0823, 37.68258], [-122.08273, 37.68373], [-122.08287, 37.68398], [-122.08308, 37.68418]]]} | Open Access 1 | Carlos Bee Park | 16860 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 5.137 | Carlos Bee Park | ||
13994 | 13994 | 13993 | {"type": "Polygon", "coordinates": [[[-122.07255, 37.69448], [-122.07245, 37.69479], [-122.07246, 37.69486], [-122.07249, 37.69495], [-122.07248, 37.69502], [-122.07212, 37.6949], [-122.07227, 37.69459], [-122.07203, 37.6945], [-122.07231, 37.69399], [-122.0723, 37.69396], [-122.07227, 37.69395], [-122.07223, 37.69381], [-122.07182, 37.69362], [-122.07168, 37.69362], [-122.07161, 37.69348], [-122.0716, 37.69294], [-122.07155, 37.69271], [-122.0719, 37.6927], [-122.0719, 37.69293], [-122.07177, 37.69295], [-122.07182, 37.69357], [-122.07188, 37.69362], [-122.07198, 37.69362], [-122.07226, 37.69375], [-122.07231, 37.69386], [-122.0724, 37.69394], [-122.07245, 37.69423], [-122.07255, 37.69448]]]} | Open Access 1 | Castro Valley Creek Park | 31450 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 1.313 | Castro Valley Creek Park | ||
14075 | 14075 | 14074 | {"type": "Polygon", "coordinates": [[[-122.09024, 37.7077], [-122.09056, 37.70869], [-122.09056, 37.70876], [-122.09053, 37.70884], [-122.09047, 37.7089], [-122.09041, 37.70893], [-122.08948, 37.7092], [-122.08932, 37.70928], [-122.08916, 37.70941], [-122.08905, 37.70954], [-122.08872, 37.71015], [-122.08861, 37.7102], [-122.08829, 37.71021], [-122.08815, 37.70889], [-122.088, 37.70839], [-122.08802, 37.70711], [-122.08886, 37.70713], [-122.08903, 37.70785], [-122.09024, 37.7077]]]} | Open Access 1 | Castro Valley Park and Community Center | 31506 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 11.138 | Castro Valley Park and Community Ctr. | ||
2753 | 2753 | 2752 | {"type": "Polygon", "coordinates": [[[-122.0975, 37.66354], [-122.09714, 37.66357], [-122.09618, 37.66266], [-122.09563, 37.66224], [-122.09518, 37.66185], [-122.0948, 37.66148], [-122.0965, 37.6607], [-122.09689, 37.66105], [-122.0972, 37.66164], [-122.09739, 37.66218], [-122.09747, 37.66261], [-122.09753, 37.66314], [-122.0975, 37.66354]]]} | Open Access 1 | Centennial Park | 17031 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 9.49 | Centennial Park | ||
2880 | 2880 | 2879 | {"type": "Polygon", "coordinates": [[[-122.10726, 37.67622], [-122.10552, 37.67683], [-122.10512, 37.67609], [-122.10694, 37.67552], [-122.10726, 37.67622]]]} | Open Access 1 | Cherryland Park | 17174 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 3.634 | Cherryland Park | ||
12804 | 12804 | 12803 | {"type": "Polygon", "coordinates": [[[-122.09567, 37.62037], [-122.09565, 37.62062], [-122.09561, 37.62089], [-122.09467, 37.62085], [-122.09433, 37.62076], [-122.09392, 37.62056], [-122.09321, 37.62], [-122.09278, 37.61977], [-122.09277, 37.61937], [-122.09283, 37.61933], [-122.09307, 37.61934], [-122.09332, 37.61941], [-122.09398, 37.6198], [-122.09428, 37.62011], [-122.0945, 37.62021], [-122.09478, 37.62027], [-122.09558, 37.62033], [-122.09567, 37.62037]]]} | Open Access 1 | Christian Penke Park | 31451 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 4.375 | Christian Penke Park | ||
3091 | 3091 | 3090 | {"type": "Polygon", "coordinates": [[[-122.04506, 37.65547], [-122.04503, 37.65551], [-122.04411, 37.65578], [-122.04333, 37.65598], [-122.04326, 37.65535], [-122.04327, 37.65533], [-122.04349, 37.65521], [-122.04358, 37.65514], [-122.04367, 37.65502], [-122.04374, 37.65486], [-122.04377, 37.65484], [-122.044, 37.65483], [-122.04414, 37.65481], [-122.04427, 37.65477], [-122.0445, 37.65467], [-122.04456, 37.65475], [-122.04463, 37.65513], [-122.04497, 37.65514], [-122.04499, 37.65533], [-122.04506, 37.65547]]]} | Open Access 1 | College Heights Park | 17504 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 3.294 | College Heights Park | ||
320 | 320 | 319 | {"type": "Polygon", "coordinates": [[[-122.11964, 37.68374], [-122.11923, 37.684], [-122.11911, 37.68404], [-122.1168, 37.6842], [-122.11595, 37.68321], [-122.11627, 37.683], [-122.11617, 37.68289], [-122.11753, 37.6819], [-122.11964, 37.68374]]]} | Restricted Access 2 | Colonial Acres School Park | 31951 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 11.664 | Colonial Acres School Park | ||
3480 | 3480 | 3479 | {"type": "Polygon", "coordinates": [[[-122.08302, 37.67721], [-122.08212, 37.6778], [-122.08184, 37.67751], [-122.0828, 37.6769], [-122.08302, 37.67721]]]} | Open Access 1 | De Anza Park | 17969 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 1.03 | De Anza Park | ||
2777 | 2777 | 2776 | {"type": "Polygon", "coordinates": [[[-122.06028, 37.72143], [-122.05949, 37.7214], [-122.05929, 37.72149], [-122.05929, 37.72141], [-122.05922, 37.72128], [-122.05923, 37.72117], [-122.05937, 37.72113], [-122.05955, 37.72111], [-122.06008, 37.72111], [-122.06028, 37.72109], [-122.06028, 37.72143]]]} | Open Access 1 | Deerview Park | 18011 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 0.764 | Deerview Park |
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]);