units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
175 rows where DES_TP = 2 and MNG_AGENCY = 32 sorted by SUID_NMA descending
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
- Open Access 174
- Restricted Access 1
MNG_AG_TYP 1
- City Agency 175
MNG_AGENCY 1
- San Jose, City of · 175 ✖
DES_TP 1
- Local Park · 175 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1432 | 1432 | 1431 | {"type": "Polygon", "coordinates": [[[-121.88594, 37.31445], [-121.88536, 37.31483], [-121.88518, 37.31455], [-121.88449, 37.31485], [-121.88433, 37.31463], [-121.88552, 37.31397], [-121.88594, 37.31445]]]} | Open Access 1 | 48980 | Tamien Park | 33676 | 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 | https://www.mercurynews.com/2017/06/21/tamien-park-opens-after-22-years-of-planning/ | Santa Clara 19 | 1.588 | Tamien Park | 2017 | Local Park 2 | 4 |
7642 | 7642 | 7641 | {"type": "Polygon", "coordinates": [[[-121.91965, 37.40115], [-121.91878, 37.40193], [-121.91857, 37.40145], [-121.91833, 37.40099], [-121.91804, 37.40054], [-121.91838, 37.40024], [-121.9184, 37.40032], [-121.91845, 37.40039], [-121.91922, 37.40091], [-121.91923, 37.40098], [-121.91927, 37.40103], [-121.91937, 37.40106], [-121.91947, 37.40102], [-121.91965, 37.40115]]]} | Open Access 1 | 48967 | Iris Chang Park | 33665 | 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 | https://www.sanjoseca.gov/Home/Components/News/News/402/5103 | Santa Clara 19 | 2.664 | Iris Chang Park | 2019 | Local Park 2 | 4 |
7788 | 7788 | 7787 | {"type": "Polygon", "coordinates": [[[-121.79392, 37.23948], [-121.79391, 37.24008], [-121.79354, 37.23998], [-121.79354, 37.23956], [-121.79379, 37.23954], [-121.79392, 37.23948]]]} | Open Access 1 | 47665 | Miyuki Dog Park | 31406 | 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.44 | Miyuki Dog Park | 0 | 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 |
7787 | 7787 | 7786 | {"type": "Polygon", "coordinates": [[[-121.84487, 37.36184], [-121.84462, 37.362], [-121.8445, 37.36188], [-121.84451, 37.36186], [-121.84448, 37.36183], [-121.84446, 37.36184], [-121.84431, 37.36167], [-121.84456, 37.36152], [-121.84463, 37.36159], [-121.84462, 37.36161], [-121.84469, 37.36168], [-121.84471, 37.36167], [-121.84473, 37.3617], [-121.84472, 37.36172], [-121.84475, 37.36174], [-121.84477, 37.36174], [-121.84487, 37.36184]]]} | Open Access 1 | 47664 | Jackson Madden Park | 31404 | 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/187 | Santa Clara 19 | 0.311 | Jackson Madden Park | 0 | Local Park 2 | 4 |
6451 | 6451 | 6450 | {"type": "Polygon", "coordinates": [[[-121.87834, 37.35953], [-121.87826, 37.35958], [-121.87795, 37.35929], [-121.87664, 37.36016], [-121.87692, 37.36045], [-121.87668, 37.36061], [-121.87601, 37.36039], [-121.87538, 37.36015], [-121.8747, 37.35988], [-121.87397, 37.35955], [-121.87427, 37.35876], [-121.87405, 37.35604], [-121.87435, 37.35406], [-121.87456, 37.35424], [-121.87443, 37.35524], [-121.87498, 37.35558], [-121.87596, 37.35539], [-121.87636, 37.35567], [-121.87687, 37.35616], [-121.87698, 37.35629], [-121.87713, 37.35652], [-121.87749, 37.35687], [-121.877, 37.35719], [-121.8764, 37.35761], [-121.87668, 37.35791], [-121.87834, 37.35953]]]} | Open Access 1 | 1981 | Watson Park | 30905 | 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 | https://www.sanjoseca.gov/Facilities/Facility/Details/126 | Santa Clara 19 | 34.437 | Watson Park | 1976 | Local Park 2 | 4 |
14724 | 14724 | 14723 | {"type": "Polygon", "coordinates": [[[-121.87966, 37.30969], [-121.87878, 37.3098], [-121.87879, 37.30936], [-121.87874, 37.30887], [-121.87949, 37.30878], [-121.87966, 37.30969]]]} | Open Access 1 | 45074 | Roberto Antonio Balermino Park | 28091 | 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.812 | Roberto Antonio Balermino Park | 0 | Local Park 2 | 4 | |
14019 | 14019 | 14018 | {"type": "MultiPolygon", "coordinates": [[[[-121.89295, 37.31787], [-121.89295, 37.31797], [-121.89085, 37.31787], [-121.89085, 37.31778], [-121.89295, 37.31787]]], [[[-121.89597, 37.31798], [-121.89596, 37.31807], [-121.89363, 37.31799], [-121.89363, 37.31789], [-121.89597, 37.31798]]], [[[-121.89742, 37.31803], [-121.89731, 37.31856], [-121.8972, 37.31855], [-121.89721, 37.31839], [-121.89724, 37.31838], [-121.89727, 37.31802], [-121.89742, 37.31803]]]]} | Open Access 1 | 38010 | Fuller Park | 28012 | 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.195 | Fuller 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 |
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 |
14873 | 14873 | 14872 | {"type": "Polygon", "coordinates": [[[-121.89511, 37.33384], [-121.89479, 37.334], [-121.89467, 37.33357], [-121.89511, 37.33384], [-121.89511, 37.33384]]]} | Open Access 1 | 45394 | Almaden Entrance Triangle Park | 27910 | 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/prns | Santa Clara 19 | 0.191 | Almaden Entrance Triangle 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 |
8154 | 8154 | 8153 | {"type": "Polygon", "coordinates": [[[-121.85116, 37.34628], [-121.85095, 37.34628], [-121.85074, 37.34634], [-121.85008, 37.34674], [-121.85002, 37.34676], [-121.84993, 37.34675], [-121.84958, 37.34642], [-121.85074, 37.3457], [-121.85079, 37.34575], [-121.85071, 37.34581], [-121.85116, 37.34628]]]} | Open Access 1 | 13752 | Zolezzi Park | 27868 | 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.715 | Zolezzi Park | 2007 | Local Park 2 | 4 | |
612 | 612 | 611 | {"type": "Polygon", "coordinates": [[[-121.82499, 37.30827], [-121.82371, 37.30909], [-121.82343, 37.3088], [-121.82334, 37.30882], [-121.82205, 37.30749], [-121.82291, 37.30696], [-121.82374, 37.30779], [-121.82412, 37.30778], [-121.82438, 37.30764], [-121.82443, 37.30767], [-121.82455, 37.30771], [-121.82492, 37.3081], [-121.82494, 37.30814], [-121.82491, 37.30819], [-121.82499, 37.30827]]]} | Open Access 1 | 2196 | Windmill Springs Park | 27629 | 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 | 6.859 | Windmill Springs Park | 1983 | Local Park 2 | 4 | |
606 | 606 | 605 | {"type": "Polygon", "coordinates": [[[-121.86951, 37.33581], [-121.86875, 37.33619], [-121.86867, 37.33624], [-121.86862, 37.3363], [-121.86823, 37.33704], [-121.8674, 37.33676], [-121.86703, 37.33577], [-121.86697, 37.33548], [-121.86694, 37.33478], [-121.86711, 37.33392], [-121.86791, 37.33383], [-121.86822, 37.33441], [-121.8684, 37.33465], [-121.86852, 37.33479], [-121.86892, 37.33513], [-121.86918, 37.33538], [-121.86951, 37.33581]]]} | Open Access 1 | 2110 | William Street Park | 27559 | 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 | 11.685 | William Street Park | 0 | Local Park 2 | 4 | |
9373 | 9373 | 9372 | {"type": "Polygon", "coordinates": [[[-121.8662, 37.25613], [-121.86579, 37.25732], [-121.86566, 37.25762], [-121.86545, 37.25789], [-121.86519, 37.25816], [-121.8651, 37.25815], [-121.86508, 37.25811], [-121.86516, 37.25788], [-121.86534, 37.25761], [-121.86545, 37.25736], [-121.86584, 37.25611], [-121.8662, 37.25613]]]} | Open Access 1 | 15665 | William H Cilker Park | 27545 | 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.574 | William H Cilker Park | 2004 | Local Park 2 | 4 | |
8614 | 8614 | 8613 | {"type": "Polygon", "coordinates": [[[-121.90063, 37.29413], [-121.90029, 37.29436], [-121.89967, 37.29462], [-121.89962, 37.29459], [-121.89928, 37.29393], [-121.89931, 37.29388], [-121.89941, 37.29385], [-121.89995, 37.29371], [-121.90027, 37.2936], [-121.90063, 37.29413]]]} | Open Access 1 | 13750 | Wilcox Park | 27493 | 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.954 | Wilcox Park | 1995 | Local Park 2 | 4 | |
1813 | 1813 | 1812 | {"type": "Polygon", "coordinates": [[[-121.85647, 37.27809], [-121.85646, 37.2782], [-121.85641, 37.2783], [-121.85628, 37.27849], [-121.8561, 37.27863], [-121.85589, 37.27872], [-121.85573, 37.27876], [-121.85558, 37.27877], [-121.8545, 37.27877], [-121.85445, 37.27874], [-121.85445, 37.27809], [-121.85647, 37.27809]]]} | Open Access 1 | 13748 | Waterford Park | 27300 | 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 | 2.997 | Waterford Park | 2003 | Local Park 2 | 4 | |
578 | 578 | 577 | {"type": "Polygon", "coordinates": [[[-121.898, 37.28754], [-121.89626, 37.28829], [-121.89597, 37.28788], [-121.89477, 37.2884], [-121.89439, 37.28785], [-121.89402, 37.288], [-121.89388, 37.28779], [-121.89389, 37.28775], [-121.89394, 37.28772], [-121.89732, 37.28649], [-121.89751, 37.28681], [-121.898, 37.28754]]]} | Open Access 1 | 1926 | Wallenburg Park | 27220 | 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.119 | Wallenburg Park | 1961 | 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 |
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]);