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 SUID_NMA
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9131 | 9131 | 9130 | {"type": "Polygon", "coordinates": [[[-122.05436, 37.68017], [-122.05423, 37.68062], [-122.05412, 37.68067], [-122.05414, 37.68057], [-122.0539, 37.68045], [-122.0531, 37.68083], [-122.05273, 37.68038], [-122.05255, 37.6796], [-122.05317, 37.67967], [-122.05318, 37.67971], [-122.05436, 37.68017]]]} | Open Access 1 | 15161 | Fairview Park | 18818 | 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.054 | Fairview 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 | |
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 | |
9356 | 9356 | 9355 | {"type": "Polygon", "coordinates": [[[-122.0973, 37.61101], [-122.09726, 37.61092], [-122.09716, 37.61088], [-122.09704, 37.61091], [-122.09652, 37.61092], [-122.09602, 37.61097], [-122.09595, 37.61094], [-122.09593, 37.61088], [-122.09592, 37.61088], [-122.09586, 37.61068], [-122.0958, 37.61058], [-122.09566, 37.61041], [-122.09563, 37.61034], [-122.09562, 37.61025], [-122.09565, 37.61011], [-122.09578, 37.60993], [-122.09582, 37.60984], [-122.09587, 37.60952], [-122.09592, 37.6095], [-122.09706, 37.60948], [-122.09712, 37.60944], [-122.09715, 37.60937], [-122.09712, 37.6093], [-122.09705, 37.60926], [-122.09699, 37.60925], [-122.09692, 37.60926], [-122.09687, 37.60929], [-122.09683, 37.60935], [-122.09677, 37.60937], [-122.09676, 37.60909], [-122.09728, 37.60909], [-122.0973, 37.61101]]]} | Open Access 1 | 15629 | Gordon E. Oliver Eden Shores Park | 19408 | 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.594 | Gordon E. Oliver Eden Shores Park | 0 | Local Park 2 | 4 | |
9822 | 9822 | 9821 | {"type": "Polygon", "coordinates": [[[-122.04626, 37.71955], [-122.0462, 37.72191], [-122.0393, 37.71982], [-122.03924, 37.71959], [-122.03905, 37.71948], [-122.03897, 37.71939], [-122.03888, 37.71914], [-122.0387, 37.71893], [-122.03828, 37.71899], [-122.03802, 37.71831], [-122.038, 37.71809], [-122.03802, 37.71793], [-122.03811, 37.71769], [-122.03832, 37.71738], [-122.0384, 37.7174], [-122.0385, 37.71725], [-122.0389, 37.71735], [-122.03988, 37.71744], [-122.04163, 37.71802], [-122.04248, 37.71844], [-122.04626, 37.71955]]]} | Open Access 1 | 16780 | Greenridge Park | 19483 | 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 | 45.887 | Greenridge 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 |
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 | |
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 | |
9305 | 9305 | 9304 | {"type": "Polygon", "coordinates": [[[-122.12445, 37.69399], [-122.12425, 37.69399], [-122.12416, 37.69402], [-122.12319, 37.69335], [-122.12328, 37.69327], [-122.12338, 37.69313], [-122.12363, 37.69319], [-122.12373, 37.69323], [-122.12373, 37.69341], [-122.12384, 37.69341], [-122.12385, 37.69364], [-122.12407, 37.69364], [-122.12415, 37.6937], [-122.12445, 37.69371], [-122.12445, 37.69399]]]} | Open Access 1 | 15510 | Hesperian Park | 19883 | 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.934 | Hesperian Park | 0 | Local Park 2 | 4 | |
9156 | 9156 | 9155 | {"type": "Polygon", "coordinates": [[[-122.12275, 37.71119], [-122.12138, 37.71191], [-122.12132, 37.71201], [-122.12132, 37.71212], [-122.12152, 37.71278], [-122.12137, 37.7128], [-122.12105, 37.71205], [-122.12101, 37.71185], [-122.12098, 37.71155], [-122.12107, 37.71113], [-122.12151, 37.71046], [-122.12275, 37.71119]]]} | Open Access 1 | 15194 | Hillcrest Knolls Park | 19966 | 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.813 | Hillcrest Knolls Park | 0 | Local Park 2 | 4 | |
9365 | 9365 | 9364 | {"type": "Polygon", "coordinates": [[[-122.01903, 37.65238], [-122.0182, 37.65246], [-122.01762, 37.65137], [-122.0177, 37.65132], [-122.01782, 37.65088], [-122.01797, 37.65081], [-122.01824, 37.65078], [-122.01828, 37.65093], [-122.01836, 37.65112], [-122.01892, 37.65202], [-122.01899, 37.65217], [-122.01903, 37.65238]]]} | Open Access 1 | 15642 | Jalquin Vista Park | 20339 | 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.154 | Jalquin Vista 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 | |
6738 | 6738 | 6737 | {"type": "Polygon", "coordinates": [[[-122.12342, 37.66871], [-122.12086, 37.66972], [-122.11967, 37.66783], [-122.12192, 37.66679], [-122.12342, 37.66871]]]} | Open Access 1 | 5071 | Kennedy Park | 20602 | 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.44 | Kennedy Park | 1949 | Local Park 2 | 4 | |
7967 | 7967 | 7966 | {"type": "Polygon", "coordinates": [[[-122.10386, 37.66497], [-122.10343, 37.66497], [-122.10343, 37.66475], [-122.10385, 37.66475], [-122.10386, 37.66497]]]} | Open Access 1 | 15632 | La Placita Mini Park | 20788 | 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.229 | La Placita MP | 0 | Local Park 2 | 4 | |
9357 | 9357 | 9356 | {"type": "Polygon", "coordinates": [[[-122.05144, 37.68537], [-122.05131, 37.68541], [-122.05103, 37.68483], [-122.05054, 37.68497], [-122.05009, 37.68402], [-122.04984, 37.68345], [-122.04983, 37.68337], [-122.04959, 37.68288], [-122.05066, 37.68269], [-122.05091, 37.68321], [-122.05088, 37.68323], [-122.05132, 37.6842], [-122.05094, 37.68432], [-122.05144, 37.68537]]]} | Open Access 1 | 15633 | Lakeridge Park | 20970 | 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.378 | Lakeridge Park | 0 | Local Park 2 | 4 | |
8972 | 8972 | 8971 | {"type": "Polygon", "coordinates": [[[-122.08382, 37.67039], [-122.083, 37.67089], [-122.0822, 37.67], [-122.08301, 37.66953], [-122.08382, 37.67039]]]} | Open Access 1 | 14834 | Library Park | 21224 | 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.683 | Library Park | 0 | Local Park 2 | 4 | |
8983 | 8983 | 8982 | {"type": "Polygon", "coordinates": [[[-122.10851, 37.65793], [-122.10708, 37.65845], [-122.10676, 37.65794], [-122.10824, 37.65731], [-122.10851, 37.65793]]]} | Open Access 1 | 14831 | Longwood Park | 21458 | 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.405 | Longwood Park | 0 | Local Park 2 | 4 | |
9307 | 9307 | 9306 | {"type": "Polygon", "coordinates": [[[-122.12224, 37.67045], [-122.12184, 37.67061], [-122.12193, 37.67077], [-122.12152, 37.67079], [-122.12086, 37.66972], [-122.12161, 37.66942], [-122.12205, 37.67013], [-122.1221, 37.67012], [-122.12222, 37.67031], [-122.12217, 37.67034], [-122.12224, 37.67045]]]} | Open Access 1 | 15513 | Mc Conaghy Park | 21985 | 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.46 | Mc Conaghy Park | 0 | Local Park 2 | 4 | |
8989 | 8989 | 8988 | {"type": "Polygon", "coordinates": [[[-122.1144, 37.68599], [-122.11396, 37.68623], [-122.11369, 37.68633], [-122.11347, 37.68631], [-122.11314, 37.6862], [-122.1129, 37.68607], [-122.11285, 37.685], [-122.11298, 37.68492], [-122.11301, 37.68483], [-122.11289, 37.68469], [-122.11285, 37.68395], [-122.11419, 37.68388], [-122.1144, 37.68599]]]} | Open Access 1 | 14840 | Meek Park | 22104 | 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 | 7.907 | Meek 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]);