units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
253 rows where MNG_AGENCY = 32 sorted by DES_TP
This data as json, copyable, CSV (advanced)
DES_TP >30
ACCESS_TYP 2
- Open Access 207
- Restricted Access 6
MNG_AG_TYP 1
- City Agency 213
MNG_AGENCY 1
- San Jose, City of · 213 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2567 | 2567 | 2566 | {"type": "Polygon", "coordinates": [[[-121.81491, 37.31728], [-121.81229, 37.31735], [-121.81162, 37.31721], [-121.81136, 37.31723], [-121.80948, 37.31751], [-121.80948, 37.31745], [-121.80962, 37.31726], [-121.80962, 37.31714], [-121.81091, 37.31695], [-121.81093, 37.31699], [-121.812, 37.31683], [-121.81359, 37.31577], [-121.81397, 37.31591], [-121.81396, 37.31597], [-121.81399, 37.31612], [-121.81404, 37.31626], [-121.81417, 37.31643], [-121.81442, 37.31671], [-121.81474, 37.31702], [-121.81491, 37.31728]]]} | Open Access 1 | 17850 | Meadowfair Park | 22085 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 8.727 | Meadowfair Park | 1999 | Local Park 2 | 4 | |
2698 | 2698 | 2697 | {"type": "Polygon", "coordinates": [[[-121.88152, 37.40723], [-121.88065, 37.40766], [-121.87982, 37.40658], [-121.88092, 37.40605], [-121.88122, 37.40607], [-121.88121, 37.40631], [-121.88124, 37.40663], [-121.88134, 37.40694], [-121.88142, 37.40709], [-121.88152, 37.40723]]]} | Open Access 1 | 18272 | Northwod Park | 22898 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 3.74 | Northwod Park | 1988 | Local Park 2 | 4 | |
3177 | 3177 | 3176 | {"type": "Polygon", "coordinates": [[[-121.85221, 37.26366], [-121.85167, 37.2637], [-121.85132, 37.26394], [-121.85132, 37.26373], [-121.8511, 37.26358], [-121.85036, 37.26427], [-121.84899, 37.26287], [-121.84939, 37.26237], [-121.84996, 37.26184], [-121.85001, 37.26183], [-121.85049, 37.26213], [-121.85077, 37.26228], [-121.85097, 37.26241], [-121.85184, 37.26308], [-121.85201, 37.26325], [-121.85208, 37.26334], [-121.85216, 37.2635], [-121.85221, 37.26366]]]} | Open Access 1 | 1912 | Vista Park | 27185 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 9.593 | Vista Park | 1984 | Local Park 2 | 4 | |
3576 | 3576 | 3575 | {"type": "Polygon", "coordinates": [[[-121.90732, 37.34314], [-121.90825, 37.34399], [-121.90826, 37.34403], [-121.90825, 37.34406], [-121.90731, 37.34471], [-121.90726, 37.34472], [-121.90722, 37.3447], [-121.90628, 37.34386], [-121.90732, 37.34314]]]} | Open Access 1 | 29147 | Heritage Rose Garden | 19864 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 3.935 | Heritage Rose Garden | 0 | Local Park 2 | 4 | |
3596 | 3596 | 3595 | {"type": "Polygon", "coordinates": [[[-121.86792, 37.27888], [-121.86754, 37.27898], [-121.86734, 37.2785], [-121.86775, 37.27841], [-121.86792, 37.27888]]]} | Open Access 1 | 38007 | Parkside Glen Park | 23449 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.502 | Parkside Glen Park | 0 | Local Park 2 | 4 | |
3599 | 3599 | 3598 | {"type": "Polygon", "coordinates": [[[-121.81856, 37.37389], [-121.81827, 37.37437], [-121.81801, 37.37427], [-121.81798, 37.37424], [-121.81797, 37.37419], [-121.81809, 37.374], [-121.81822, 37.37388], [-121.81829, 37.37378], [-121.81856, 37.37389]]]} | Open Access 1 | 38026 | Fleming Park | 18944 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.446 | Fleming Park | 0 | Local Park 2 | 4 | |
3600 | 3600 | 3599 | {"type": "Polygon", "coordinates": [[[-121.83447, 37.31838], [-121.83426, 37.31852], [-121.8342, 37.31862], [-121.83363, 37.31857], [-121.83358, 37.31855], [-121.83357, 37.31851], [-121.83364, 37.3179], [-121.83367, 37.31779], [-121.83375, 37.31764], [-121.83447, 37.31838]]]} | Open Access 1 | 38027 | Nisich Park | 22769 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 1.226 | Nisich Park | 0 | Local Park 2 | 4 | |
3668 | 3668 | 3667 | {"type": "Polygon", "coordinates": [[[-121.85409, 37.22428], [-121.85408, 37.22431], [-121.85404, 37.22435], [-121.85328, 37.22419], [-121.85329, 37.224], [-121.85332, 37.22396], [-121.85338, 37.22393], [-121.85355, 37.22387], [-121.85363, 37.22387], [-121.85381, 37.22392], [-121.85397, 37.22392], [-121.854, 37.22395], [-121.85404, 37.22418], [-121.85409, 37.22428]]]} | Open Access 1 | 13730 | Pfeiffer Park | 23637 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.664 | Pfeiffer Park | 2001 | Local Park 2 | 4 | |
3782 | 3782 | 3781 | {"type": "Polygon", "coordinates": [[[-121.82966, 37.34595], [-121.82886, 37.34644], [-121.82778, 37.34531], [-121.82759, 37.34513], [-121.82758, 37.34508], [-121.82831, 37.34458], [-121.8284, 37.34466], [-121.82778, 37.34509], [-121.82856, 37.34592], [-121.82921, 37.3455], [-121.82966, 37.34595]]]} | Open Access 1 | 8685 | Sylvia Cassell Park | 31405 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/Facilities/Facility/Details/Sylvia-Cassell-Park-61 | Santa Clara 19 | 2.04 | Sylvia Cassell Park | 1991 | Local Park 2 | 4 |
3836 | 3836 | 3835 | {"type": "Polygon", "coordinates": [[[-121.79521, 37.26427], [-121.79424, 37.26476], [-121.79239, 37.26413], [-121.79167, 37.2636], [-121.7931, 37.26341], [-121.79449, 37.26319], [-121.79503, 37.26315], [-121.79521, 37.26427]]]} | Open Access 1 | 45387 | Shady Oaks Park | 27915 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/Facilities/Facility/Details/Shady-Oaks-Park-157 | Santa Clara 19 | 8.29 | Shady Oaks Park | 0 | Local Park 2 | 4 |
3837 | 3837 | 3836 | {"type": "Polygon", "coordinates": [[[-121.81525, 37.30826], [-121.81558, 37.30859], [-121.81559, 37.30863], [-121.81499, 37.30902], [-121.81463, 37.30865], [-121.81525, 37.30826]]]} | Open Access 1 | 45391 | West Evergreen Park | 27916 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/Facilities?clear=True | Santa Clara 19 | 0.9 | West Evergreen Park | 0 | Local Park 2 | 4 |
3972 | 3972 | 3971 | {"type": "Polygon", "coordinates": [[[-121.79739, 37.24527], [-121.79676, 37.24527], [-121.79675, 37.24494], [-121.79681, 37.24492], [-121.79681, 37.24487], [-121.79675, 37.24487], [-121.79673, 37.2445], [-121.79688, 37.24449], [-121.79687, 37.24443], [-121.79682, 37.24427], [-121.79614, 37.24386], [-121.79566, 37.24437], [-121.79468, 37.24377], [-121.794, 37.24379], [-121.79391, 37.24089], [-121.79399, 37.24085], [-121.79408, 37.24088], [-121.79423, 37.24107], [-121.79431, 37.24129], [-121.79433, 37.24143], [-121.79439, 37.24301], [-121.79443, 37.24317], [-121.79455, 37.24339], [-121.79467, 37.24352], [-121.79482, 37.24362], [-121.79498, 37.24371], [-121.79517, 37.24377], [-121.79545, 37.2438], [-121.79596, 37.24376], [-121.79613, 37.24376], [-121.79639, 37.24382], [-121.79661, 37.24393], [-121.79674, 37.24403], [-121.79688, 37.24421], [-121.79694, 37.24434], [-121.79701, 37.2446], [-121.79708, 37.24479], [-121.79732, 37.24518], [-121.79739, 37.24527]]]} | Open Access 1 | 38004 | Raleigh Park | 24095 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 5.429 | Raleigh Park | 0 | Local Park 2 | 4 | |
3974 | 3974 | 3973 | {"type": "Polygon", "coordinates": [[[-121.80056, 37.25232], [-121.79928, 37.25154], [-121.79891, 37.25141], [-121.79868, 37.25121], [-121.79825, 37.25096], [-121.79925, 37.25094], [-121.79923, 37.24979], [-121.80095, 37.24977], [-121.80099, 37.24979], [-121.80102, 37.25092], [-121.80104, 37.25108], [-121.80112, 37.25129], [-121.80121, 37.25143], [-121.80131, 37.25154], [-121.80132, 37.25157], [-121.80065, 37.25231], [-121.80061, 37.25233], [-121.80056, 37.25232]]]} | Open Access 1 | 38006 | RMAC Park | 24473 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 10.55 | RMAC Park | 0 | Local Park 2 | 4 | |
3983 | 3983 | 3982 | {"type": "Polygon", "coordinates": [[[-121.9098, 37.3363], [-121.90931, 37.33668], [-121.90907, 37.33646], [-121.90955, 37.33609], [-121.9098, 37.3363]]]} | Open Access 1 | 38018 | Theodore Lenzen Park | 26299 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.472 | Theodore Lenzen Park | 0 | Local Park 2 | 4 | |
3984 | 3984 | 3983 | {"type": "Polygon", "coordinates": [[[-121.9386, 37.25096], [-121.93856, 37.25096], [-121.93856, 37.25137], [-121.93859, 37.25138], [-121.93859, 37.25139], [-121.93853, 37.2516], [-121.93848, 37.25158], [-121.93834, 37.25157], [-121.93822, 37.25152], [-121.93802, 37.25154], [-121.93796, 37.25148], [-121.93794, 37.25145], [-121.93794, 37.25078], [-121.93797, 37.25073], [-121.93804, 37.2507], [-121.9386, 37.2507], [-121.9386, 37.25096]]]} | Open Access 1 | 38019 | Carolyn Norris Park | 16888 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 1.303 | Carolyn Norris Park | 0 | Local Park 2 | 4 | |
3985 | 3985 | 3984 | {"type": "Polygon", "coordinates": [[[-121.76724, 37.2524], [-121.7669, 37.25268], [-121.76631, 37.25222], [-121.76687, 37.25176], [-121.76697, 37.25184], [-121.76685, 37.25194], [-121.76681, 37.25199], [-121.76679, 37.25208], [-121.76681, 37.25215], [-121.76686, 37.2522], [-121.76704, 37.25234], [-121.76714, 37.25238], [-121.76724, 37.2524]]]} | Open Access 1 | 38020 | Piercy Park | 23663 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.784 | Piercy Park | 0 | Local Park 2 | 4 | |
3986 | 3986 | 3985 | {"type": "Polygon", "coordinates": [[[-121.8579, 37.34324], [-121.8574, 37.34356], [-121.85695, 37.3431], [-121.85708, 37.34304], [-121.8573, 37.34296], [-121.85745, 37.34288], [-121.8575, 37.34287], [-121.85754, 37.34289], [-121.8579, 37.34324]]]} | Open Access 1 | 38021 | Bonita Park | 16263 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.825 | Bonita Park | 0 | Local Park 2 | 4 | |
4091 | 4091 | 4090 | {"type": "Polygon", "coordinates": [[[-121.82987, 37.29701], [-121.82983, 37.29708], [-121.82949, 37.29702], [-121.82873, 37.29701], [-121.82859, 37.29678], [-121.82926, 37.29636], [-121.82917, 37.29644], [-121.82911, 37.29655], [-121.82913, 37.29667], [-121.82917, 37.29674], [-121.82927, 37.29681], [-121.82953, 37.29688], [-121.82987, 37.29701]]]} | Open Access 1 | 44532 | Lone Bluff Park | 21436 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.778 | Lone Bluff Park | 0 | Local Park 2 | 4 | |
4314 | 4314 | 4313 | {"type": "Polygon", "coordinates": [[[-121.89634, 37.32873], [-121.89614, 37.32883], [-121.89583, 37.32829], [-121.8955, 37.32782], [-121.89562, 37.32786], [-121.89574, 37.32795], [-121.89634, 37.32873]]]} | Open Access 1 | 45398 | Delmas Dog Park | 27904 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/Facilities/Facility/Details/Dog-Parks-140 | Santa Clara 19 | 0.426 | Delmas Dog Park | 0 | Local Park 2 | 4 |
4945 | 4945 | 4944 | {"type": "Polygon", "coordinates": [[[-121.82496, 37.25694], [-121.82382, 37.25694], [-121.82381, 37.25558], [-121.82382, 37.25555], [-121.82386, 37.25554], [-121.82483, 37.25553], [-121.82487, 37.25555], [-121.82489, 37.25654], [-121.82491, 37.2566], [-121.82496, 37.25666], [-121.82496, 37.25694]]]} | Open Access 1 | 14658 | Coy Park | 17732 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 3.743 | Coy Park | 1992 | 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]);