superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
77 rows where ACCESS_TYP = 1, MNG_AGENCY = 253 and MNG_AG_TYP = 4 sorted by YR_EST
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
3279 | 3279 | 3278 | {"type": "Polygon", "coordinates": [[[-122.03982, 37.62532], [-122.03904, 37.62569], [-122.03862, 37.62582], [-122.03843, 37.62596], [-122.03811, 37.62529], [-122.03914, 37.62488], [-122.03936, 37.62482], [-122.03964, 37.62485], [-122.03982, 37.62532]]]} | Open Access 1 | Fairway Greens Park | 18823 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2.548 | Fairway Greens 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 | ||
3783 | 3783 | 3782 | {"type": "Polygon", "coordinates": [[[-122.05946, 37.69439], [-122.05885, 37.69507], [-122.05883, 37.69556], [-122.05837, 37.69603], [-122.0583, 37.69656], [-122.05816, 37.69676], [-122.05723, 37.69663], [-122.0572, 37.69677], [-122.05723, 37.69694], [-122.05723, 37.69719], [-122.05716, 37.69742], [-122.05697, 37.69785], [-122.0571, 37.69796], [-122.05793, 37.698], [-122.05779, 37.69844], [-122.05769, 37.69896], [-122.05722, 37.69911], [-122.0572, 37.69932], [-122.05738, 37.6997], [-122.05682, 37.69978], [-122.0567, 37.70057], [-122.05573, 37.70103], [-122.05575, 37.70138], [-122.05386, 37.70191], [-122.05409, 37.70148], [-122.05419, 37.70111], [-122.05497, 37.70103], [-122.05532, 37.70088], [-122.05541, 37.70078], [-122.05512, 37.7002], [-122.05508, 37.69964], [-122.05485, 37.69902], [-122.05494, 37.69854], [-122.05526, 37.69825], [-122.05619, 37.6981], [-122.05662, 37.69776], [-122.05681, 37.69721], [-122.05677, 37.69688], [-122.05636, 37.69651], [-122.05587, 37.69632], [-122.05596, 37.69539], [-122.05657, 37.69468], [-122.0584, 37.69457], [-122.05946, 37.69439]]]} | Open Access 1 | Earl Warren Park | 18355 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 31.474 | Earl Warren Park | ||
3844 | 3844 | 3843 | {"type": "Polygon", "coordinates": [[[-122.11882, 37.69374], [-122.1188, 37.69506], [-122.11701, 37.69506], [-122.117, 37.6955], [-122.11632, 37.69548], [-122.11631, 37.6952], [-122.11528, 37.69519], [-122.11529, 37.6942], [-122.11632, 37.69421], [-122.11633, 37.69398], [-122.11716, 37.69399], [-122.11718, 37.69373], [-122.11882, 37.69374]]]} | Open Access 1 | Edendale Park | 18430 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 10.685 | Edendale Park | ||
3876 | 3876 | 3875 | {"type": "Polygon", "coordinates": [[[-122.08654, 37.6351], [-122.08475, 37.63514], [-122.08474, 37.63456], [-122.08469, 37.63432], [-122.08496, 37.63427], [-122.08515, 37.63417], [-122.08532, 37.63415], [-122.08538, 37.63412], [-122.0854, 37.63406], [-122.08573, 37.63402], [-122.08623, 37.63465], [-122.08654, 37.6351]]]} | Open Access 1 | Eldridge Park | 18554 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 3.445 | Eldridge Park | ||
4139 | 4139 | 4138 | {"type": "Polygon", "coordinates": [[[-122.12555, 37.70411], [-122.12363, 37.70561], [-122.12363, 37.70562], [-122.12383, 37.70583], [-122.12339, 37.70622], [-122.12336, 37.70621], [-122.12346, 37.7058], [-122.12372, 37.70538], [-122.12391, 37.70519], [-122.12547, 37.70402], [-122.12555, 37.70411]]]} | Open Access 1 | Fairmont Linear Park | 18804 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 1.132 | Fairmont Linear Park | ||
4143 | 4143 | 4142 | {"type": "Polygon", "coordinates": [[[-122.11417, 37.70787], [-122.11417, 37.70787], [-122.11329, 37.70866], [-122.11332, 37.70842], [-122.11328, 37.70824], [-122.1132, 37.70811], [-122.11301, 37.70804], [-122.11304, 37.70766], [-122.11417, 37.70787]]]} | Open Access 1 | Fairmont Terrace Park | 18809 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 1.269 | Fairmont Terrace 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]);