units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
74 rows where DES_TP = 2 and MNG_AGENCY = 253 sorted by map
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- Hayward Area Recreation and Park District · 54 ✖
DES_TP 1
- Local Park · 54 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2052 | 2052 | 2051 | {"type": "Polygon", "coordinates": [[[-122.05604, 37.67111], [-122.05571, 37.6729], [-122.05568, 37.67326], [-122.05563, 37.67337], [-122.05549, 37.67348], [-122.05533, 37.67354], [-122.05428, 37.67355], [-122.05406, 37.67328], [-122.0545, 37.67093], [-122.05604, 37.67111]]]} | Restricted Access 2 | 15627 | East Avenue School Park | 31952 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 9.509 | East Avenue School Park | 0 | Local Park 2 | 4 | |
1983 | 1983 | 1982 | {"type": "Polygon", "coordinates": [[[-122.05682, 37.70364], [-122.05641, 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 | 15157 | Bay Trees Park | 15882 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 10.11 | Bay Trees Park | 0 | Local Park 2 | 4 | |
7835 | 7835 | 7834 | {"type": "Polygon", "coordinates": [[[-122.05746, 37.62338], [-122.05725, 37.62354], [-122.05718, 37.62354], [-122.05709, 37.62357], [-122.05704, 37.62365], [-122.0566, 37.62401], [-122.05605, 37.62357], [-122.0562, 37.62344], [-122.0556, 37.62297], [-122.05627, 37.62243], [-122.05718, 37.62315], [-122.05716, 37.62319], [-122.05736, 37.62334], [-122.05739, 37.62332], [-122.05746, 37.62338]]]} | Open Access 1 | 47703 | Silver Star Veterans Park | 31448 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 3.309 | Silver Star Veterans Park | 0 | Local Park 2 | 4 | |
5287 | 5287 | 5286 | {"type": "Polygon", "coordinates": [[[-122.05946, 37.69439], [-122.05885, 37.69507], [-122.05883, 37.69556], [-122.05837, 37.69604], [-122.0583, 37.69656], [-122.05816, 37.69676], [-122.05724, 37.69663], [-122.0572, 37.69677], [-122.05723, 37.69694], [-122.05723, 37.69719], [-122.05716, 37.69742], [-122.05696, 37.69785], [-122.0571, 37.69796], [-122.05793, 37.698], [-122.05779, 37.69844], [-122.05769, 37.69896], [-122.05722, 37.6991], [-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.0541, 37.70148], [-122.05419, 37.70111], [-122.05497, 37.70103], [-122.05533, 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.69811], [-122.05662, 37.69776], [-122.05681, 37.69721], [-122.05677, 37.69689], [-122.05636, 37.69651], [-122.05587, 37.69632], [-122.05596, 37.69539], [-122.05657, 37.69468], [-122.05841, 37.69457], [-122.05946, 37.69439]]]} | Open Access 1 | 15159 | Earl Warren Park | 18355 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 31.448 | Earl Warren Park | 0 | Local Park 2 | 4 | |
11570 | 11570 | 11569 | {"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 | 23665 | Deerview Park | 18011 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 0.765 | Deerview Park | 0 | Local Park 2 | 4 | |
7966 | 7966 | 7965 | {"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 | 15619 | Bechtel Mini Park | 15943 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 0.774 | Bechtel MP | 0 | Local Park 2 | 4 | |
6743 | 6743 | 6742 | {"type": "Polygon", "coordinates": [[[-122.06367, 37.67916], [-122.06302, 37.67937], [-122.06319, 37.67989], [-122.06191, 37.6806], [-122.06121, 37.68082], [-122.06083, 37.68007], [-122.06126, 37.67992], [-122.06086, 37.67911], [-122.0635, 37.67828], [-122.06367, 37.67916]]]} | Open Access 1 | 5083 | San Felipe Park | 24884 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 9.766 | San Felipe Park | 1965 | Local Park 2 | 4 | |
7808 | 7808 | 7807 | {"type": "Polygon", "coordinates": [[[-122.0655, 37.67733], [-122.06488, 37.67742], [-122.06498, 37.67783], [-122.06458, 37.67789], [-122.06446, 37.67744], [-122.06407, 37.6775], [-122.06404, 37.67737], [-122.06336, 37.67748], [-122.06331, 37.67739], [-122.0627, 37.67759], [-122.06249, 37.67715], [-122.06307, 37.67685], [-122.06254, 37.67654], [-122.06226, 37.67652], [-122.06223, 37.67661], [-122.06162, 37.67652], [-122.06173, 37.67596], [-122.06198, 37.67596], [-122.06258, 37.67576], [-122.06269, 37.67574], [-122.06267, 37.67587], [-122.06301, 37.67588], [-122.06307, 37.6756], [-122.0631, 37.6756], [-122.06306, 37.67588], [-122.0634, 37.67589], [-122.06339, 37.67602], [-122.06462, 37.6759], [-122.06448, 37.67664], [-122.06455, 37.67667], [-122.06479, 37.67682], [-122.06493, 37.67683], [-122.06502, 37.67689], [-122.06518, 37.6769], [-122.06539, 37.67687], [-122.0655, 37.67733]]]} | Open Access 1 | 47701 | Sulphur Creek Nature Center | 31437 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 10.148 | Sulphur Creek Nature Ctr. | 0 | Local Park 2 | 4 | |
8970 | 8970 | 8969 | {"type": "Polygon", "coordinates": [[[-122.06748, 37.63151], [-122.06477, 37.63297], [-122.06456, 37.63267], [-122.06425, 37.63239], [-122.06369, 37.63203], [-122.06369, 37.63199], [-122.064, 37.63169], [-122.06417, 37.63162], [-122.06715, 37.63077], [-122.06748, 37.63151]]]} | Open Access 1 | 14800 | Tennyson Park | 26245 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 9.408 | Tennyson Park | 0 | Local Park 2 | 4 | |
1101 | 1101 | 1100 | {"type": "Polygon", "coordinates": [[[-122.06832, 37.64878], [-122.0678, 37.64887], [-122.06776, 37.64853], [-122.06779, 37.64844], [-122.06798, 37.64835], [-122.06832, 37.64878]]]} | Open Access 1 | 15630 | Haymont Mini Park | 19758 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 0.431 | Haymont MP | 0 | Local Park 2 | 4 | |
8991 | 8991 | 8990 | {"type": "Polygon", "coordinates": [[[-122.06921, 37.65745], [-122.06885, 37.6576], [-122.06789, 37.65718], [-122.06765, 37.65698], [-122.06747, 37.65668], [-122.06699, 37.65618], [-122.06735, 37.65594], [-122.06776, 37.65649], [-122.06823, 37.65633], [-122.06921, 37.65745]]]} | Open Access 1 | 14843 | Spring Grove Park | 25738 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 3.192 | Spring Grove Park | 0 | Local Park 2 | 4 | |
8996 | 8996 | 8995 | {"type": "Polygon", "coordinates": [[[-122.07014, 37.61978], [-122.07006, 37.6198], [-122.0699, 37.61981], [-122.06971, 37.61985], [-122.0694, 37.62003], [-122.06922, 37.62008], [-122.06915, 37.62004], [-122.06907, 37.61961], [-122.0691, 37.61951], [-122.06908, 37.61944], [-122.06915, 37.61935], [-122.06914, 37.61919], [-122.07005, 37.61909], [-122.07014, 37.61978]]]} | Open Access 1 | 14860 | Stratford Village Park | 25907 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 1.858 | Stratford Village Park | 0 | Local Park 2 | 4 | |
7836 | 7836 | 7835 | {"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.07228, 37.69459], [-122.07203, 37.6945], [-122.07231, 37.69398], [-122.0723, 37.69395], [-122.07227, 37.69395], [-122.07224, 37.69382], [-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.69294], [-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 | 47704 | Castro Valley Creek Park | 31450 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 1.308 | Castro Valley Creek Park | 0 | Local Park 2 | 4 | |
8973 | 8973 | 8972 | {"type": "Polygon", "coordinates": [[[-122.07395, 37.64394], [-122.07177, 37.64429], [-122.07183, 37.64455], [-122.07079, 37.64457], [-122.07077, 37.64395], [-122.0707, 37.64384], [-122.0703, 37.64384], [-122.07028, 37.6426], [-122.07241, 37.64248], [-122.07395, 37.64394]]]} | Open Access 1 | 14803 | Sorensdale Park | 25624 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 12.217 | Sorensdale Park | 0 | Local Park 2 | 4 | |
8986 | 8986 | 8985 | {"type": "Polygon", "coordinates": [[[-122.07515, 37.62535], [-122.07338, 37.62536], [-122.07346, 37.62481], [-122.07338, 37.62446], [-122.07398, 37.62436], [-122.07422, 37.62446], [-122.07438, 37.6245], [-122.07509, 37.62453], [-122.07515, 37.62535]]]} | Open Access 1 | 14863 | Ruus Park | 24757 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 3.683 | Ruus Park | 0 | Local Park 2 | 4 | |
8981 | 8981 | 8980 | {"type": "Polygon", "coordinates": [[[-122.07821, 37.66585], [-122.07598, 37.66704], [-122.07552, 37.6665], [-122.07478, 37.66669], [-122.07467, 37.66655], [-122.07456, 37.66664], [-122.07423, 37.6668], [-122.07324, 37.66702], [-122.07297, 37.66724], [-122.07264, 37.66742], [-122.0717, 37.66742], [-122.07084, 37.66729], [-122.07057, 37.66714], [-122.07018, 37.66682], [-122.06975, 37.66721], [-122.06905, 37.66739], [-122.0688, 37.66757], [-122.06862, 37.66721], [-122.06814, 37.66732], [-122.06781, 37.66705], [-122.06729, 37.66701], [-122.06656, 37.66653], [-122.0659, 37.66675], [-122.06533, 37.66616], [-122.06483, 37.66625], [-122.06417, 37.66601], [-122.06394, 37.66589], [-122.0633, 37.66532], [-122.06317, 37.66527], [-122.06277, 37.66676], [-122.06177, 37.66641], [-122.06171, 37.66696], [-122.06142, 37.66692], [-122.06132, 37.66731], [-122.06117, 37.66728], [-122.06117, 37.66724], [-122.06031, 37.66709], [-122.0603, 37.66684], [-122.06025, 37.6667], [-122.06013, 37.66655], [-122.05996, 37.66644], [-122.05903, 37.6662], [-122.05869, 37.66614], [-122.05827, 37.6661], [-122.06242, 37.66396], [-122.0625, 37.66365], [-122.06254, 37.66365], [-122.06249, 37.66387], [-122.0631, 37.66427], [-122.06467, 37.66516], [-122.0651, 37.66556], [-122.06586, 37.66569], [-122.06636, 37.66583], [-122.06716, 37.66639], [-122.06799, 37.66656], [-122.06844, 37.66657], [-122.06918, 37.6667], [-122.0703, 37.6663], [-122.07089, 37.66705], [-122.07174, 37.66711], [-122.07231, 37.66708], [-122.07266, 37.66714], [-122.07333, 37.66685], [-122.07388, 37.66639], [-122.07487, 37.66592], [-122.07627, 37.6649], [-122.0763, 37.66492], [-122.07708, 37.66452], [-122.07821, 37.66585]]]} | Open Access 1 | 14825 | Hayward Memorial Park | 19759 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 48.356 | Hayward Memorial Park | 0 | Local Park 2 | 4 | |
6459 | 6459 | 6458 | {"type": "Polygon", "coordinates": [[[-122.07934, 37.6359], [-122.07868, 37.63596], [-122.07811, 37.63594], [-122.07765, 37.63578], [-122.07731, 37.63541], [-122.07665, 37.63442], [-122.07597, 37.63349], [-122.07584, 37.63306], [-122.07927, 37.63317], [-122.07934, 37.6359]]]} | Open Access 1 | 1996 | Weekes Park | 27330 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 17.561 | Weekes Park | 0 | Local Park 2 | 4 | |
9000 | 9000 | 8999 | {"type": "Polygon", "coordinates": [[[-122.08163, 37.67964], [-122.08077, 37.67994], [-122.08034, 37.67899], [-122.08115, 37.67873], [-122.08163, 37.67964]]]} | Open Access 1 | 14874 | Japanese Gardens | 20362 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 2.2 | Japanese Gardens | 0 | Local Park 2 | 4 | |
1518 | 1518 | 1517 | {"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 | 47719 | Adobe Park | 31505 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/facilities/facility/details/Adobe-Park-116 | Alameda 17 | 3.894 | Adobe Park | 0 | Local Park 2 | 4 |
1920 | 1920 | 1919 | {"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 | 14886 | De Anza Park | 17969 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 1.03 | De Anza Park | 0 | Local Park 2 | 4 |
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]);