units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
76 rows where AGNCY_NAME = 257 and DES_TP = 2
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_ID, PARK_URL, YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
783 | 783 | 782 | {"type": "Polygon", "coordinates": [[[-122.09551, 37.63544], [-122.09549, 37.63615], [-122.0955, 37.63682], [-122.09501, 37.63684], [-122.09505, 37.63746], [-122.09413, 37.63754], [-122.0942, 37.63815], [-122.09387, 37.63819], [-122.09387, 37.63901], [-122.09249, 37.63911], [-122.09222, 37.63912], [-122.0919, 37.63901], [-122.09449, 37.63532], [-122.09496, 37.63539], [-122.09551, 37.63544]]]} | Open Access 1 | 5069 | Southgate Park | 25689 | 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 | 14.46 | Southgate Park | 1965 | 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 | |
1434 | 1434 | 1433 | {"type": "Polygon", "coordinates": [[[-122.0272, 37.65621], [-122.02609, 37.65763], [-122.02388, 37.65638], [-122.02421, 37.65615], [-122.02448, 37.65581], [-122.02462, 37.65538], [-122.02478, 37.655], [-122.02503, 37.65468], [-122.02527, 37.65453], [-122.0272, 37.65621]]]} | Open Access 1 | 47699 | J.A. Lewis Park | 31435 | 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.57 | J.A. Lewis Park | 0 | Local Park 2 | 4 | |
1435 | 1435 | 1434 | {"type": "Polygon", "coordinates": [[[-122.13981, 37.67822], [-122.13977, 37.67831], [-122.13782, 37.6791], [-122.13753, 37.67864], [-122.13699, 37.67886], [-122.13613, 37.67751], [-122.13869, 37.67647], [-122.13981, 37.67822]]]} | Open Access 1 | 47700 | Mervin Morris Park | 31436 | 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 | 13.34 | Mervin Morris Park | 0 | Local Park 2 | 4 | |
1451 | 1451 | 1450 | {"type": "Polygon", "coordinates": [[[-122.09749, 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.09749, 37.66354]]]} | Open Access 1 | 9747 | Centennial Park | 17031 | 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.492 | Centennial Park | 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 |
1911 | 1911 | 1910 | {"type": "Polygon", "coordinates": [[[-122.11063, 37.64003], [-122.10917, 37.64003], [-122.10914, 37.63892], [-122.1106, 37.63889], [-122.11063, 37.64003]]]} | Open Access 1 | 14788 | Rancho Arroyo Park | 24128 | 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.995 | Rancho Arroyo Park | 0 | Local Park 2 | 4 | |
1912 | 1912 | 1911 | {"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.65003], [-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.65054], [-122.03644, 37.65092]]]} | Open Access 1 | 14813 | Canyon View Park | 16828 | 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 | 5.42 | Canyon View Park | 0 | Local Park 2 | 4 | |
1913 | 1913 | 1912 | {"type": "Polygon", "coordinates": [[[-122.10025, 37.63972], [-122.09932, 37.64006], [-122.09902, 37.63977], [-122.09843, 37.63943], [-122.09845, 37.63939], [-122.09852, 37.63939], [-122.09978, 37.63889], [-122.10025, 37.63972]]]} | Open Access 1 | 14791 | Gansberger Park | 19186 | 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.664 | Gansberger Park | 0 | Local Park 2 | 4 | |
1914 | 1914 | 1913 | {"type": "Polygon", "coordinates": [[[-122.05238, 37.63238], [-122.05203, 37.63263], [-122.05126, 37.63194], [-122.05159, 37.63169], [-122.05238, 37.63238]]]} | Open Access 1 | 14805 | Valle Vista Park | 26774 | 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.045 | Valle Vista Park | 0 | Local Park 2 | 4 | |
1916 | 1916 | 1915 | {"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 | 14853 | Fairway Greens Park | 18823 | 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.548 | Fairway Greens 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 | |
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 | |
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 | |
2256 | 2256 | 2255 | {"type": "Polygon", "coordinates": [[[-122.10116, 37.6315], [-122.09735, 37.63159], [-122.09693, 37.63095], [-122.10101, 37.62939], [-122.10116, 37.6315]]]} | Open Access 1 | 18099 | Mt. Eden Park | 22577 | 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 | 13.739 | Mt. Eden Park | 0 | Local Park 2 | 4 | |
3610 | 3610 | 3609 | {"type": "Polygon", "coordinates": [[[-122.14555, 37.66548], [-122.14449, 37.66584], [-122.14439, 37.66644], [-122.14233, 37.66724], [-122.14201, 37.66706], [-122.14184, 37.66295], [-122.14345, 37.66316], [-122.14555, 37.66548]]]} | Open Access 1 | 441 | San Lorenzo Community Park | 24925 | 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 | 23.787 | San Lorenzo Community Park | 0 | Local Park 2 | 4 | |
5221 | 5221 | 5220 | {"type": "Polygon", "coordinates": [[[-121.98774, 37.69927], [-121.987, 37.69915], [-121.98436, 37.69881], [-121.98245, 37.69859], [-121.98161, 37.69845], [-121.98091, 37.69828], [-121.98042, 37.69813], [-121.97989, 37.69799], [-121.97915, 37.69786], [-121.97787, 37.69781], [-121.97662, 37.69763], [-121.97536, 37.69737], [-121.97291, 37.69698], [-121.97296, 37.6967], [-121.97308, 37.69667], [-121.97325, 37.69658], [-121.97334, 37.69638], [-121.97349, 37.69634], [-121.97353, 37.69606], [-121.97363, 37.69594], [-121.97374, 37.69576], [-121.97373, 37.69571], [-121.97376, 37.69562], [-121.97371, 37.69553], [-121.97377, 37.69509], [-121.97355, 37.69429], [-121.97839, 37.69432], [-121.97841, 37.69486], [-121.98072, 37.69488], [-121.98068, 37.69509], [-121.98129, 37.6962], [-121.98162, 37.69661], [-121.98198, 37.697], [-121.98199, 37.69713], [-121.98773, 37.69755], [-121.98774, 37.69927]]]} | Open Access 1 | 289 | Rowell Ranch Rodeo Park | 24705 | 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 | 83.074 | Rowell Ranch Rodeo 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 | |
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 | |
6735 | 6735 | 6734 | {"type": "Polygon", "coordinates": [[[-122.0458, 37.66526], [-122.04582, 37.66577], [-122.04507, 37.66859], [-122.04475, 37.66865], [-122.04361, 37.66881], [-122.0429, 37.66542], [-122.0458, 37.66526]]]} | Open Access 1 | 5067 | East Avenue Park | 18360 | 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 | 18.312 | East Avenue Park | 1961 | 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]);