units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
84 rows where MNG_AGENCY = 253 sorted by ACCESS_TYP 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
2719 | 2719 | 2718 | {"type": "Polygon", "coordinates": [[[-122.15145, 37.62482], [-122.1508, 37.62499], [-122.14973, 37.62515], [-122.14837, 37.62508], [-122.14707, 37.62481], [-122.14004, 37.62225], [-122.13959, 37.62203], [-122.13915, 37.62174], [-122.14433, 37.62003], [-122.14478, 37.62002], [-122.14935, 37.61837], [-122.15103, 37.61782], [-122.15106, 37.61893], [-122.15087, 37.61931], [-122.15075, 37.62021], [-122.15092, 37.62129], [-122.15132, 37.6246], [-122.15145, 37.62482]]]} | Restricted Access 2 | 18348 | Oliver Property | 23136 | 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 | 118.291 | Oliver Property | 1977 | Local Other or Unknown 14 | 4 | |
8997 | 8997 | 8996 | {"type": "MultiPolygon", "coordinates": [[[[-122.04337, 37.62404], [-122.0433, 37.62429], [-122.04202, 37.62518], [-122.04029, 37.62378], [-122.04286, 37.62379], [-122.0431, 37.62411], [-122.04331, 37.62396], [-122.04337, 37.62404]]], [[[-122.05058, 37.62653], [-122.04861, 37.62811], [-122.04838, 37.62793], [-122.0453, 37.62798], [-122.04225, 37.62538], [-122.04346, 37.62451], [-122.04355, 37.62461], [-122.04366, 37.6246], [-122.04449, 37.62538], [-122.04567, 37.62544], [-122.0457, 37.62672], [-122.04602, 37.62698], [-122.04659, 37.62714], [-122.04745, 37.62728], [-122.04796, 37.62732], [-122.04819, 37.62714], [-122.04814, 37.62684], [-122.04827, 37.62667], [-122.04822, 37.62471], [-122.04919, 37.62473], [-122.05058, 37.62653]]]]} | Restricted Access 2 | 14851 | Mission Hills Golf Course | 33042 | 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 | 37.311 | Mission Hills GC | 0 | Local Recreation Area 3 | 4 | |
9350 | 9350 | 9349 | {"type": "Polygon", "coordinates": [[[-122.10242, 37.62927], [-122.10248, 37.6293], [-122.10346, 37.63089], [-122.10346, 37.63092], [-122.10342, 37.63095], [-122.10209, 37.63146], [-122.10118, 37.63149], [-122.10113, 37.62978], [-122.10242, 37.62927]]]} | Restricted Access 2 | 15620 | Brenkwitz School Park | 31949 | 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 | 8.677 | Brenkwitz School Park | 0 | Local Park 2 | 4 | |
9354 | 9354 | 9353 | {"type": "Polygon", "coordinates": [[[-122.11964, 37.68374], [-122.11922, 37.684], [-122.11911, 37.68404], [-122.1168, 37.6842], [-122.11595, 37.68321], [-122.11628, 37.683], [-122.11617, 37.68289], [-122.11753, 37.6819], [-122.11964, 37.68374]]]} | Restricted Access 2 | 15626 | Colonial Acres School Park | 31951 | 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 | 11.662 | Colonial Acres School Park | 0 | Local Park 2 | 4 | |
9355 | 9355 | 9354 | {"type": "Polygon", "coordinates": [[[-122.02752, 37.6138], [-122.02891, 37.61502], [-122.02891, 37.61505], [-122.02889, 37.61508], [-122.02832, 37.61549], [-122.02815, 37.61565], [-122.02808, 37.61564], [-122.02768, 37.6154], [-122.0275, 37.61532], [-122.02734, 37.61528], [-122.02669, 37.61518], [-122.0265, 37.6151], [-122.02633, 37.61497], [-122.02598, 37.61449], [-122.02752, 37.6138]]]} | Restricted Access 2 | 15628 | El Rancho Verde School Park | 31953 | 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 | 6.904 | El Rancho Verde School Park | 0 | Local Park 2 | 4 | |
15683 | 15683 | 15682 | {"type": "Polygon", "coordinates": [[[-122.14345, 37.66316], [-122.13933, 37.66252], [-122.13712, 37.66264], [-122.13435, 37.66282], [-122.13439, 37.66455], [-122.1343, 37.66465], [-122.13378, 37.66475], [-122.12773, 37.66512], [-122.12783, 37.6672], [-122.12333, 37.66749], [-122.1227, 37.66755], [-122.12201, 37.66675], [-122.1221, 37.6666], [-122.129, 37.66341], [-122.12923, 37.66336], [-122.12948, 37.66336], [-122.13113, 37.6636], [-122.1313, 37.66355], [-122.13151, 37.66338], [-122.13249, 37.66174], [-122.13262, 37.66163], [-122.13565, 37.66029], [-122.139, 37.65856], [-122.14345, 37.66316]]]} | Restricted Access 2 | 14871 | Skywest Golf Course | 33043 | 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 | 116.758 | Skywest GC | 0 | Local Recreation Area 3 | 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 | |
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 |
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]);