units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
253 rows where MNG_AGENCY = 32 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
DES_TP >30
ACCESS_TYP 2
- Open Access 227
- Restricted Access 6
MNG_AG_TYP 1
- City Agency 233
MNG_AGENCY 1
- San Jose, City of · 233 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6365 | 6365 | 6364 | {"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.87229, 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 | 1900 | Vinci Park | 27130 | 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.295 | Vinci Park | 1972 | 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 | |
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 | |
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 |
588 | 588 | 587 | {"type": "Polygon", "coordinates": [[[-121.8244, 37.32448], [-121.82588, 37.32597], [-121.82589, 37.32601], [-121.82586, 37.32606], [-121.82416, 37.3272], [-121.82262, 37.32574], [-121.82324, 37.32527], [-121.8244, 37.32448]]]} | Open Access 1 | 1999 | Welch | 27336 | 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.064 | Welch | 1995 | None 59 | ||
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 | |
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 | |
5730 | 5730 | 5729 | {"type": "Polygon", "coordinates": [[[-121.91133, 37.3038], [-121.91123, 37.3038], [-121.91097, 37.30388], [-121.90824, 37.30512], [-121.90819, 37.30509], [-121.90757, 37.30397], [-121.90756, 37.30393], [-121.90758, 37.30385], [-121.90764, 37.3038], [-121.90819, 37.30361], [-121.90826, 37.30356], [-121.9083, 37.30351], [-121.90832, 37.30346], [-121.9083, 37.30333], [-121.9083, 37.30327], [-121.90832, 37.30322], [-121.90839, 37.30317], [-121.90993, 37.30256], [-121.91003, 37.30249], [-121.91012, 37.30238], [-121.91112, 37.30232], [-121.91131, 37.30232], [-121.91133, 37.3038]]]} | Open Access 1 | 2258 | Bramhall | 16328 | 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 | 14.619 | Bramhall | 1980 | None 461 | ||
620 | 620 | 619 | {"type": "Polygon", "coordinates": [[[-121.90776, 37.25402], [-121.90738, 37.25423], [-121.90704, 37.25406], [-121.90677, 37.2541], [-121.90671, 37.25396], [-121.90666, 37.2539], [-121.90622, 37.2536], [-121.90607, 37.25347], [-121.90602, 37.25341], [-121.90597, 37.25326], [-121.906, 37.2529], [-121.90599, 37.25284], [-121.90585, 37.25248], [-121.90672, 37.25225], [-121.90776, 37.25402]]]} | Open Access 1 | 2365 | Branham Park | 16332 | 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 | 4.919 | Branham Park | 1973 | Local Park 2 | 4 | |
4967 | 4967 | 4966 | {"type": "Polygon", "coordinates": [[[-121.88224, 37.39685], [-121.88204, 37.397], [-121.88141, 37.39766], [-121.88009, 37.39609], [-121.88041, 37.39576], [-121.88042, 37.39564], [-121.88018, 37.39546], [-121.88032, 37.3953], [-121.88029, 37.39525], [-121.87767, 37.39281], [-121.87784, 37.39266], [-121.87913, 37.39397], [-121.87945, 37.3942], [-121.88113, 37.39579], [-121.88123, 37.39593], [-121.88224, 37.39685]]]} | Open Access 1 | 3680 | Brooktree park | 16434 | 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 | 7.135 | Brooktree park | 1981 | None 412 | ||
665 | 665 | 664 | {"type": "Polygon", "coordinates": [[[-121.91687, 37.25892], [-121.91694, 37.25895], [-121.9176, 37.25989], [-121.9176, 37.25993], [-121.91518, 37.26101], [-121.91514, 37.26101], [-121.91509, 37.26099], [-121.91444, 37.26006], [-121.91444, 37.26002], [-121.91445, 37.25999], [-121.91687, 37.25892]]]} | Open Access 1 | 5056 | Butcher | 16545 | 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.116 | Butcher | 1981 | None 63 | ||
1009 | 1009 | 1008 | {"type": "Polygon", "coordinates": [[[-121.85208, 37.24596], [-121.85169, 37.24702], [-121.85135, 37.24693], [-121.85055, 37.24676], [-121.8482, 37.24621], [-121.84858, 37.24515], [-121.85208, 37.24596]]]} | Open Access 1 | 5500 | Cahalan | 16655 | 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.757 | Cahalan | 1978 | None 91 | ||
751 | 751 | 750 | {"type": "Polygon", "coordinates": [[[-122.02681, 37.30115], [-122.02645, 37.30262], [-122.02649, 37.30263], [-122.02622, 37.30302], [-122.02611, 37.30314], [-122.02528, 37.30385], [-122.02406, 37.30433], [-122.02399, 37.30413], [-122.02384, 37.30385], [-122.0238, 37.30366], [-122.02375, 37.30168], [-122.0238, 37.30147], [-122.02381, 37.30133], [-122.02383, 37.30129], [-122.02389, 37.30126], [-122.02608, 37.30126], [-122.02635, 37.30123], [-122.02668, 37.30115], [-122.02681, 37.30115]]]} | Open Access 1 | 5576 | Calabazas | 16668 | 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 | 16.77 | Calabazas | 1978 | None 69 | ||
870 | 870 | 869 | {"type": "Polygon", "coordinates": [[[-121.81872, 37.23996], [-121.81869, 37.24127], [-121.8181, 37.24107], [-121.81777, 37.241], [-121.81742, 37.24099], [-121.81736, 37.24095], [-121.81724, 37.24045], [-121.81706, 37.23993], [-121.81872, 37.23996]]]} | Open Access 1 | 5610 | Calero Park | 16680 | 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 | 4.064 | Calero Park | 1980 | Local Park 2 | 4 | |
7270 | 7270 | 7269 | {"type": "Polygon", "coordinates": [[[-121.93454, 37.26366], [-121.93454, 37.26383], [-121.93449, 37.26388], [-121.93447, 37.26395], [-121.93446, 37.2643], [-121.93449, 37.26439], [-121.93448, 37.26468], [-121.9316, 37.2647], [-121.9316, 37.26461], [-121.93187, 37.26459], [-121.93183, 37.26378], [-121.93196, 37.2638], [-121.93212, 37.26384], [-121.93211, 37.26389], [-121.93241, 37.26393], [-121.93261, 37.26393], [-121.93285, 37.26391], [-121.93302, 37.26387], [-121.93309, 37.26392], [-121.9331, 37.26427], [-121.93378, 37.26427], [-121.93379, 37.26407], [-121.93376, 37.26406], [-121.93375, 37.26376], [-121.93367, 37.26376], [-121.93365, 37.26359], [-121.93396, 37.26359], [-121.93396, 37.26373], [-121.93439, 37.26372], [-121.9344, 37.26367], [-121.93454, 37.26366]]]} | Open Access 1 | 6499 | Camden Park Center | 16755 | 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.013 | Camden Park Ctr. | 1961 | Local Recreation Area 3 | 4 | |
7650 | 7650 | 7649 | {"type": "Polygon", "coordinates": [[[-121.87874, 37.2851], [-121.87862, 37.28552], [-121.8768, 37.28518], [-121.8769, 37.28484], [-121.87693, 37.2848], [-121.87693, 37.28476], [-121.87874, 37.2851]]]} | Open Access 1 | 7472 | Canoas Park | 16806 | 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.987 | Canoas Park | 1989 | Local Park 2 | 4 | |
1317 | 1317 | 1316 | {"type": "Polygon", "coordinates": [[[-121.83341, 37.35039], [-121.83478, 37.35184], [-121.8348, 37.35189], [-121.83476, 37.35193], [-121.83441, 37.35211], [-121.83384, 37.35234], [-121.83324, 37.3525], [-121.83257, 37.35262], [-121.83141, 37.35137], [-121.83268, 37.35051], [-121.83287, 37.35071], [-121.83341, 37.35039]]]} | Open Access 1 | 7581 | Capitol | 16836 | 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.601 | Capitol | 1967 | None 114 | ||
7736 | 7736 | 7735 | {"type": "Polygon", "coordinates": [[[-121.83615, 37.21266], [-121.83601, 37.21253], [-121.83574, 37.21238], [-121.83546, 37.21225], [-121.83482, 37.21202], [-121.83481, 37.21199], [-121.83493, 37.21118], [-121.83495, 37.21093], [-121.8355, 37.21093], [-121.83549, 37.21084], [-121.83582, 37.21077], [-121.83615, 37.21266]]]} | Open Access 1 | 8250 | Carrabelle Park | 16907 | 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.683 | Carrabelle Park | 1991 | 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 |
1397 | 1397 | 1396 | {"type": "MultiPolygon", "coordinates": [[[[-121.79422, 37.23369], [-121.79422, 37.23411], [-121.79394, 37.2341], [-121.79396, 37.23297], [-121.7941, 37.23298], [-121.79415, 37.23301], [-121.79415, 37.2334], [-121.79412, 37.23355], [-121.79415, 37.23363], [-121.79422, 37.23369]]], [[[-121.79425, 37.23083], [-121.79424, 37.23137], [-121.79415, 37.23143], [-121.79411, 37.23151], [-121.79411, 37.23157], [-121.79414, 37.2317], [-121.79414, 37.23196], [-121.79409, 37.23208], [-121.7941, 37.23215], [-121.79413, 37.2322], [-121.79422, 37.23227], [-121.79422, 37.23281], [-121.79396, 37.23281], [-121.79398, 37.23083], [-121.79425, 37.23083]]], [[[-121.79425, 37.23012], [-121.79425, 37.23066], [-121.79397, 37.23067], [-121.79398, 37.23012], [-121.79425, 37.23012]]]]} | Open Access 1 | 8689 | Albertson Parkway | 15341 | 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.047 | Albertson Parkway | 1998 | Local Recreation Area 3 | 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]);