superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
253 rows where MNG_AGENCY = 32 sorted by PARK_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL
ACCESS_TYP 2
- Open Access 247
- Restricted Access 6
MNG_AG_TYP 1
- City Agency 253
MNG_AGENCY 1
- San Jose, City of · 253 ✖
Link | rowid | id | map | ACCESS_TYP | PARK_NAME ▲ | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11513 | 11513 | 11512 | {"type": "Polygon", "coordinates": [[[-121.85116, 37.34628], [-121.85095, 37.34628], [-121.85075, 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.34582], [-121.85116, 37.34628]]]} | Open Access 1 | Zolezzi Park | 27868 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.717 | Zolezzi Park | 2007 | |
11322 | 11322 | 11321 | {"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.82492, 37.30819], [-121.82499, 37.30827]]]} | Open Access 1 | Windmill Springs Park | 27629 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 6.86 | Windmill Springs Park | 1983 | |
11264 | 11264 | 11263 | {"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 | William Street Park | 27559 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 11.685 | William Street Park | ||
11249 | 11249 | 11248 | {"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 | William H Cilker Park | 27545 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.574 | William H Cilker Park | 2004 | |
9619 | 9619 | 9618 | {"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 | Wilcox Park | 27493 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.954 | Wilcox Park | 1995 | |
11536 | 11536 | 11535 | {"type": "Polygon", "coordinates": [[[-121.81559, 37.30863], [-121.81499, 37.30902], [-121.81463, 37.30865], [-121.81525, 37.30826], [-121.81558, 37.30859], [-121.81559, 37.30863]]]} | Open Access 1 | West Evergreen Park | http://www.sanjoseca.gov/Facilities?clear=True | 27916 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.9 | West Evergreen Park | |
11090 | 11090 | 11089 | {"type": "Polygon", "coordinates": [[[-121.82589, 37.32601], [-121.82586, 37.32606], [-121.82416, 37.3272], [-121.82262, 37.32574], [-121.82324, 37.32527], [-121.8244, 37.32448], [-121.82588, 37.32597], [-121.82589, 37.32601]]]} | Open Access 1 | Welch | 27336 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 11.063 | Welch | 1995 | |
13489 | 13489 | 13488 | {"type": "Polygon", "coordinates": [[[-121.87834, 37.35953], [-121.87826, 37.35958], [-121.87794, 37.3593], [-121.87665, 37.36015], [-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.87641, 37.35762], [-121.87668, 37.35791], [-121.87834, 37.35953]]]} | Open Access 1 | Watson Park | https://www.sanjoseca.gov/Facilities/Facility/Details/126 | 30905 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 34.46 | Watson Park | 1976 |
11061 | 11061 | 11060 | {"type": "Polygon", "coordinates": [[[-121.85647, 37.27809], [-121.85645, 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 | Waterford Park | 27300 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 2.996 | Waterford Park | 2003 | |
9390 | 9390 | 9389 | {"type": "Polygon", "coordinates": [[[-121.898, 37.28754], [-121.89626, 37.28829], [-121.89596, 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 | Wallenburg Park | 27220 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 9.125 | Wallenburg Park | 1961 | |
10959 | 10959 | 10958 | {"type": "Polygon", "coordinates": [[[-121.85221, 37.26366], [-121.85167, 37.2637], [-121.85132, 37.26394], [-121.85132, 37.26373], [-121.85109, 37.26359], [-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 | Vista Park | 27185 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 9.596 | Vista Park | 1984 | |
10904 | 10904 | 10903 | {"type": "Polygon", "coordinates": [[[-121.87324, 37.38089], [-121.87302, 37.38111], [-121.8729, 37.38119], [-121.87276, 37.38125], [-121.87261, 37.3813], [-121.87246, 37.38132], [-121.8723, 37.38132], [-121.87214, 37.3813], [-121.87199, 37.38126], [-121.87182, 37.38118], [-121.87145, 37.38088], [-121.87135, 37.38077], [-121.87127, 37.38064], [-121.87123, 37.38044], [-121.87324, 37.38089]]]} | Open Access 1 | Vinci Park | 27130 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 2.294 | Vinci Park | 1972 | |
10879 | 10879 | 10878 | {"type": "Polygon", "coordinates": [[[-121.86197, 37.28707], [-121.86132, 37.28748], [-121.86081, 37.28697], [-121.86146, 37.28657], [-121.86197, 37.28707]]]} | Open Access 1 | Vieira Park | 27092 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.298 | Vieira Park | ||
10549 | 10549 | 10548 | {"type": "MultiPolygon", "coordinates": [[[[-121.82812, 37.30669], [-121.82394, 37.30932], [-121.82371, 37.30909], [-121.82499, 37.30827], [-121.82783, 37.3065], [-121.82788, 37.30649], [-121.82792, 37.3065], [-121.82812, 37.30669]]], [[[-121.83241, 37.30382], [-121.82836, 37.30653], [-121.82817, 37.30634], [-121.82816, 37.30629], [-121.82819, 37.30626], [-121.83201, 37.30371], [-121.83206, 37.3037], [-121.83227, 37.30378], [-121.83241, 37.30382]]]]} | Open Access 1 | Umbarger Pathway | 26650 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 7.563 | Umbarger Pathway | ||
10515 | 10515 | 10514 | {"type": "Polygon", "coordinates": [[[-121.86189, 37.28614], [-121.86177, 37.28619], [-121.8615, 37.28635], [-121.86099, 37.28584], [-121.86112, 37.28576], [-121.86125, 37.28585], [-121.8614, 37.28593], [-121.86154, 37.28599], [-121.86178, 37.28605], [-121.86189, 37.28614]]]} | Open Access 1 | Tuscany Hills Overlook Park | 26600 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.481 | Tuscany Hills Overlook Park | ||
10511 | 10511 | 10510 | {"type": "Polygon", "coordinates": [[[-121.8406, 37.32362], [-121.84058, 37.32366], [-121.84013, 37.32397], [-121.83978, 37.32364], [-121.83981, 37.32356], [-121.83978, 37.32348], [-121.84018, 37.32321], [-121.84058, 37.32358], [-121.8406, 37.32362]]]} | Open Access 1 | Turtle Rock Park | 26596 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.851 | Turtle Rock Park | 2003 | |
11528 | 11528 | 11527 | {"type": "Polygon", "coordinates": [[[-121.84501, 37.30972], [-121.84413, 37.31027], [-121.84415, 37.31039], [-121.8424, 37.31155], [-121.84227, 37.31143], [-121.84087, 37.31233], [-121.83874, 37.31013], [-121.83834, 37.31021], [-121.83826, 37.31018], [-121.83818, 37.30998], [-121.8405, 37.30851], [-121.84104, 37.30881], [-121.84172, 37.30836], [-121.84174, 37.30816], [-121.84192, 37.30821], [-121.84201, 37.30813], [-121.84264, 37.30823], [-121.84316, 37.30838], [-121.84336, 37.3085], [-121.8433, 37.30859], [-121.84323, 37.30876], [-121.84333, 37.30881], [-121.84336, 37.30881], [-121.84355, 37.30895], [-121.84378, 37.30875], [-121.84442, 37.30913], [-121.84501, 37.30972]]]} | Open Access 1 | Tully Community Ballfields | http://www.sanjoseca.gov/Facilities/Facility/Details/Tully-Community-Ballfields-97 | 27907 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 36.448 | Tully Community Ballfields | |
10430 | 10430 | 10429 | {"type": "Polygon", "coordinates": [[[-121.88534, 37.38069], [-121.88524, 37.38065], [-121.88509, 37.38061], [-121.88494, 37.38061], [-121.8848, 37.38064], [-121.88294, 37.38133], [-121.88279, 37.38142], [-121.88253, 37.38163], [-121.88249, 37.38165], [-121.88244, 37.38164], [-121.88235, 37.38158], [-121.88218, 37.38145], [-121.88207, 37.3813], [-121.88199, 37.3811], [-121.88199, 37.38091], [-121.88205, 37.38072], [-121.88212, 37.3806], [-121.88223, 37.38049], [-121.88239, 37.38038], [-121.88259, 37.38032], [-121.88273, 37.3803], [-121.88349, 37.38035], [-121.88366, 37.38035], [-121.88382, 37.38032], [-121.88397, 37.38027], [-121.88416, 37.38017], [-121.88451, 37.37982], [-121.88454, 37.37985], [-121.88454, 37.37988], [-121.88488, 37.3802], [-121.88521, 37.38053], [-121.88526, 37.38062], [-121.88534, 37.38069]]]} | Open Access 1 | Townsend Park | 26497 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 6.28 | Townsend Park | 1993 | |
10339 | 10339 | 10338 | {"type": "MultiPolygon", "coordinates": [[[[-121.87633, 37.26877], [-121.87629, 37.26882], [-121.87618, 37.26884], [-121.87574, 37.26885], [-121.87552, 37.26887], [-121.87461, 37.26909], [-121.87453, 37.26908], [-121.87449, 37.26904], [-121.87439, 37.26876], [-121.87434, 37.26866], [-121.87424, 37.26856], [-121.87417, 37.26852], [-121.87404, 37.26847], [-121.87423, 37.26803], [-121.87413, 37.26777], [-121.87434, 37.26772], [-121.87445, 37.26772], [-121.87451, 37.26768], [-121.87452, 37.26763], [-121.87484, 37.26755], [-121.87519, 37.2675], [-121.87526, 37.26756], [-121.87535, 37.26757], [-121.87541, 37.26755], [-121.87551, 37.26747], [-121.87592, 37.26738], [-121.87603, 37.26737], [-121.87607, 37.26738], [-121.87612, 37.26742], [-121.87614, 37.26746], [-121.87633, 37.26877]]], [[[-121.87705, 37.26835], [-121.87652, 37.26841], [-121.87646, 37.2684], [-121.87641, 37.26836], [-121.87625, 37.26729], [-121.87626, 37.26697], [-121.87624, 37.26684], [-121.87658, 37.26676], [-121.87676, 37.26781], [-121.87699, 37.26776], [-121.87705, 37.26835]]]]} | Open Access 1 | Thousand Oaks | 26323 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 8.809 | Thousand Oaks | 1985 | |
8796 | 8796 | 8795 | {"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 | Theodore Lenzen Park | 26299 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.472 | Theodore Lenzen Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);