units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
84 rows where MNG_AGENCY = 253 sorted by PARK_URL descending
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
7838 | 7838 | 7837 | {"type": "Polygon", "coordinates": [[[-122.11632, 37.69538], [-122.11631, 37.69594], [-122.11596, 37.69624], [-122.11544, 37.69587], [-122.11561, 37.69571], [-122.1157, 37.69577], [-122.11618, 37.69535], [-122.11623, 37.69538], [-122.11632, 37.69538]]]} | Open Access 1 | 47706 | Jack Holland Sr. Park | 31455 | 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/Jack-Holland-Sr-Park-129 | Alameda 17 | 1.0 | Jack Holland Sr. Park | 0 | Local Park 2 | 4 |
7837 | 7837 | 7836 | {"type": "Polygon", "coordinates": [[[-122.03138, 37.67539], [-122.03177, 37.67601], [-122.03184, 37.67616], [-122.03207, 37.67648], [-122.03214, 37.67663], [-122.03216, 37.67677], [-122.0321, 37.67712], [-122.0312, 37.67848], [-122.03059, 37.67809], [-122.03035, 37.67797], [-122.03, 37.67773], [-122.02986, 37.67762], [-122.02967, 37.67737], [-122.02951, 37.67703], [-122.02949, 37.67667], [-122.02955, 37.6764], [-122.02964, 37.67619], [-122.02975, 37.676], [-122.03016, 37.67566], [-122.03045, 37.67553], [-122.03072, 37.67544], [-122.03097, 37.6754], [-122.03138, 37.67539]]]} | Open Access 1 | 47705 | Five Canyons Park | 31454 | 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/Five-Canyons-Park-127 | Alameda 17 | 13.452 | Five Canyons Park | 0 | Local Park 2 | 4 |
11574 | 11574 | 11573 | {"type": "Polygon", "coordinates": [[[-122.13867, 37.66915], [-122.13747, 37.66972], [-122.13761, 37.66993], [-122.13728, 37.66988], [-122.137, 37.66991], [-122.13688, 37.66873], [-122.13674, 37.66695], [-122.13846, 37.66685], [-122.13867, 37.66915]]]} | Open Access 1 | 23668 | Del Rey Park | 31452 | 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/Del-Rey-Park-42 | Alameda 17 | 11.244 | Del Rey Park | 0 | Local Park 2 | 4 |
7823 | 7823 | 7822 | {"type": "Polygon", "coordinates": [[[-122.10017, 37.70619], [-122.09895, 37.70702], [-122.09936, 37.70782], [-122.09996, 37.70839], [-122.09962, 37.70842], [-122.0991, 37.70793], [-122.09862, 37.70791], [-122.09776, 37.70819], [-122.09758, 37.70803], [-122.09663, 37.70834], [-122.09654, 37.70826], [-122.09747, 37.70794], [-122.09748, 37.7079], [-122.09732, 37.70767], [-122.09679, 37.70718], [-122.09576, 37.70752], [-122.09571, 37.70748], [-122.09674, 37.70713], [-122.09579, 37.70625], [-122.09476, 37.70659], [-122.09461, 37.70645], [-122.09579, 37.70606], [-122.09484, 37.70517], [-122.09579, 37.70486], [-122.09591, 37.70496], [-122.09601, 37.70489], [-122.09606, 37.70451], [-122.09619, 37.7045], [-122.0963, 37.70448], [-122.09641, 37.70443], [-122.09652, 37.70436], [-122.09684, 37.70466], [-122.09724, 37.70491], [-122.09757, 37.70522], [-122.09777, 37.7051], [-122.09866, 37.70591], [-122.09903, 37.70567], [-122.09925, 37.70555], [-122.09963, 37.70589], [-122.09971, 37.70584], [-122.10017, 37.70619]]]} | Open Access 1 | 47707 | Valley View Park | 31456 | 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/605/Valley-View-Park---Former-EBMUD-Property | Alameda 17 | 24.129 | Valley View Park | 0 | Local Park 2 | 4 |
8998 | 8998 | 8997 | {"type": "Polygon", "coordinates": [[[-122.11531, 37.64788], [-122.11529, 37.64789], [-122.11531, 37.64852], [-122.11527, 37.64857], [-122.11472, 37.6486], [-122.11441, 37.64865], [-122.11416, 37.64823], [-122.11456, 37.64807], [-122.11465, 37.64777], [-122.11453, 37.64739], [-122.11475, 37.64721], [-122.11492, 37.64652], [-122.11526, 37.64651], [-122.11531, 37.64788]]]} | Open Access 1 | 14868 | Greenwood Park | 19491 | 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/147/Greenwood-Park | Alameda 17 | 3.46 | Greenwood Park | 0 | Local Park 2 | 4 |
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 | |
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 |
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]);