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_URL
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL, ACRES, YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
209 | 209 | 208 | {"type": "Polygon", "coordinates": [[[-121.89428, 37.23794], [-121.89425, 37.23798], [-121.89372, 37.23825], [-121.89364, 37.23832], [-121.89355, 37.23842], [-121.89352, 37.23843], [-121.89349, 37.23841], [-121.89266, 37.23738], [-121.8926, 37.23734], [-121.89286, 37.2372], [-121.8927, 37.23699], [-121.89264, 37.23682], [-121.89285, 37.23678], [-121.89293, 37.23697], [-121.89334, 37.23689], [-121.89324, 37.23638], [-121.89339, 37.23647], [-121.89347, 37.23656], [-121.89357, 37.23685], [-121.89349, 37.23689], [-121.89352, 37.23696], [-121.89427, 37.23791], [-121.89428, 37.23794]]]} | Open Access 1 | Almaden Winery Park | 15391 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 3.616 | Almaden Winery Park | 1998 | |
743 | 743 | 742 | {"type": "Polygon", "coordinates": [[[-121.76995, 37.32073], [-121.76992, 37.32078], [-121.76987, 37.3208], [-121.76953, 37.32076], [-121.76868, 37.31766], [-121.76873, 37.31765], [-121.76879, 37.31791], [-121.76891, 37.31796], [-121.76892, 37.31801], [-121.76897, 37.31805], [-121.76902, 37.31823], [-121.76906, 37.31824], [-121.76911, 37.31845], [-121.76908, 37.31848], [-121.76906, 37.31852], [-121.76908, 37.31857], [-121.76911, 37.31861], [-121.76909, 37.31888], [-121.7692, 37.31889], [-121.76921, 37.31913], [-121.76928, 37.31919], [-121.76927, 37.31925], [-121.7693, 37.3193], [-121.76921, 37.31936], [-121.76936, 37.3199], [-121.76944, 37.31997], [-121.76944, 37.32001], [-121.76947, 37.32005], [-121.76953, 37.32009], [-121.7695, 37.32033], [-121.76958, 37.32035], [-121.76957, 37.32067], [-121.76995, 37.32073]]]} | Open Access 1 | Pocket Park No. 10 | 23821 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.014 | PP No. 10 | 2004 | |
744 | 744 | 743 | {"type": "Polygon", "coordinates": [[[-121.76494, 37.31564], [-121.7648, 37.3157], [-121.76466, 37.31572], [-121.7645, 37.3157], [-121.76436, 37.31564], [-121.76425, 37.31555], [-121.76419, 37.31544], [-121.76418, 37.31531], [-121.76422, 37.31518], [-121.76429, 37.3151], [-121.76435, 37.31505], [-121.76445, 37.315], [-121.76457, 37.31497], [-121.76477, 37.31498], [-121.76496, 37.31506], [-121.76504, 37.31513], [-121.76508, 37.31519], [-121.76511, 37.31526], [-121.76512, 37.31535], [-121.76511, 37.31543], [-121.76506, 37.31552], [-121.76494, 37.31564]]]} | Open Access 1 | Pocket Park No. 11 | 23822 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.328 | PP No. 11 | 2004 | |
745 | 745 | 744 | {"type": "MultiPolygon", "coordinates": [[[[-121.77933, 37.31566], [-121.7791, 37.31572], [-121.77901, 37.31526], [-121.77923, 37.31547], [-121.77933, 37.31563], [-121.77933, 37.31566]]], [[[-121.77976, 37.31553], [-121.77956, 37.31557], [-121.77951, 37.31556], [-121.77939, 37.31537], [-121.77917, 37.31515], [-121.77914, 37.3151], [-121.77915, 37.31507], [-121.77918, 37.31505], [-121.77928, 37.31503], [-121.77938, 37.31536], [-121.77966, 37.31535], [-121.77962, 37.31542], [-121.77963, 37.31547], [-121.77968, 37.31551], [-121.77976, 37.31553]]]]} | Open Access 1 | Pocket Park No. 14 | 23823 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.348 | PP No. 14 | 2004 | |
857 | 857 | 856 | {"type": "Polygon", "coordinates": [[[-121.96948, 37.42504], [-121.96911, 37.42631], [-121.96897, 37.42625], [-121.96621, 37.4255], [-121.96617, 37.42548], [-121.96616, 37.42544], [-121.96616, 37.42534], [-121.96673, 37.42526], [-121.9667, 37.42508], [-121.96711, 37.42501], [-121.96723, 37.42536], [-121.96863, 37.42514], [-121.96837, 37.42417], [-121.96898, 37.42432], [-121.96891, 37.42472], [-121.96948, 37.42504]]]} | Open Access 1 | Alviso Park | 15432 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 6.598 | Alviso Park | 1968 | |
1331 | 1331 | 1330 | {"type": "MultiPolygon", "coordinates": [[[[-121.8745, 37.24237], [-121.87114, 37.24308], [-121.86974, 37.24299], [-121.86921, 37.24284], [-121.86916, 37.24032], [-121.86917, 37.23982], [-121.87002, 37.23903], [-121.8703, 37.23842], [-121.86993, 37.23811], [-121.8704, 37.23743], [-121.87043, 37.23726], [-121.87031, 37.23705], [-121.87024, 37.23673], [-121.87044, 37.2367], [-121.87153, 37.2368], [-121.87286, 37.23664], [-121.87313, 37.23707], [-121.87327, 37.23783], [-121.87198, 37.23837], [-121.87207, 37.23927], [-121.87209, 37.23928], [-121.87353, 37.23875], [-121.87432, 37.24069], [-121.87452, 37.2413], [-121.87459, 37.24175], [-121.87458, 37.24219], [-121.8745, 37.24237]]], [[[-121.87421, 37.24683], [-121.87403, 37.248], [-121.87327, 37.24819], [-121.87217, 37.24946], [-121.87134, 37.24941], [-121.87124, 37.25039], [-121.86991, 37.25028], [-121.87066, 37.24708], [-121.87073, 37.2471], [-121.87233, 37.24556], [-121.87239, 37.24556], [-121.87276, 37.24568], [-121.87286, 37.24589], [-121.87288, 37.24654], [-121.873, 37.24659], [-121.87334, 37.24645], [-121.8734, 37.24649], [-121.87345, 37.24659], [-121.87352, 37.2466], [-121.87359, 37.24666], [-121.87362, 37.24675], [-121.8737, 37.24681], [-121.87388, 37.24683], [-121.87403, 37.24682], [-121.87421, 37.24683]]]]} | Open Access 1 | Almaden Lake | 15389 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 86.243 | Almaden Lake | 1998 | |
1345 | 1345 | 1344 | {"type": "Polygon", "coordinates": [[[-121.88633, 37.22152], [-121.88568, 37.22198], [-121.88558, 37.22216], [-121.88551, 37.22238], [-121.8854, 37.22289], [-121.88452, 37.22279], [-121.88376, 37.2233], [-121.88316, 37.22275], [-121.88258, 37.22217], [-121.88238, 37.22195], [-121.88235, 37.22188], [-121.88237, 37.2218], [-121.88241, 37.22175], [-121.88503, 37.22048], [-121.88537, 37.22034], [-121.88542, 37.22035], [-121.88546, 37.22038], [-121.88562, 37.22067], [-121.88576, 37.22113], [-121.88574, 37.22124], [-121.88577, 37.2213], [-121.88581, 37.22133], [-121.88586, 37.22134], [-121.88593, 37.22134], [-121.88598, 37.2213], [-121.88633, 37.22152]]]} | Open Access 1 | Almaden Meadows | 15390 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 14.897 | Almaden Meadows | 1987 | |
1369 | 1369 | 1368 | {"type": "Polygon", "coordinates": [[[-121.86306, 37.37599], [-121.86238, 37.37595], [-121.86229, 37.3748], [-121.86297, 37.37489], [-121.86306, 37.37599]]]} | Open Access 1 | Berryessa Community Garden | 16035 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.84 | Berryessa Community Garden | ||
1391 | 1391 | 1390 | {"type": "Polygon", "coordinates": [[[-121.79774, 37.31556], [-121.79746, 37.31561], [-121.79725, 37.31561], [-121.79713, 37.31564], [-121.79701, 37.31563], [-121.7968, 37.31557], [-121.79672, 37.31551], [-121.7966, 37.31539], [-121.79659, 37.31526], [-121.7967, 37.31504], [-121.79674, 37.315], [-121.79682, 37.31496], [-121.79681, 37.31491], [-121.79679, 37.31489], [-121.79665, 37.31485], [-121.79646, 37.31485], [-121.79638, 37.31484], [-121.79623, 37.31479], [-121.79599, 37.31458], [-121.79592, 37.31449], [-121.79585, 37.31445], [-121.79573, 37.31442], [-121.79558, 37.31434], [-121.7955, 37.31427], [-121.79544, 37.31418], [-121.79539, 37.31414], [-121.79533, 37.31412], [-121.79512, 37.3141], [-121.79508, 37.31409], [-121.79505, 37.31404], [-121.79506, 37.31394], [-121.79502, 37.31388], [-121.79496, 37.31382], [-121.7948, 37.31374], [-121.79475, 37.31367], [-121.79543, 37.31358], [-121.79546, 37.31378], [-121.79614, 37.31418], [-121.79694, 37.31401], [-121.79722, 37.31397], [-121.79711, 37.31413], [-121.79706, 37.31424], [-121.79703, 37.31441], [-121.79705, 37.31456], [-121.79709, 37.31465], [-121.79742, 37.31517], [-121.79763, 37.31546], [-121.79774, 37.31556]]]} | Open Access 1 | Aborn Park | 15237 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 4.604 | Aborn Park | 2000 | |
1437 | 1437 | 1436 | {"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.23219], [-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 | Albertson Parkway | 15341 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 2.047 | Albertson Parkway | 1998 | |
1612 | 1612 | 1611 | {"type": "MultiPolygon", "coordinates": [[[[-121.76711, 37.31382], [-121.76553, 37.31405], [-121.7655, 37.31394], [-121.76629, 37.31381], [-121.76631, 37.31384], [-121.76709, 37.31372], [-121.76708, 37.31377], [-121.76711, 37.31382]]], [[[-121.76796, 37.3137], [-121.76734, 37.31379], [-121.76734, 37.31373], [-121.76731, 37.31368], [-121.76793, 37.31359], [-121.76793, 37.31365], [-121.76796, 37.3137]]], [[[-121.7688, 37.31357], [-121.76819, 37.31366], [-121.76819, 37.31361], [-121.76816, 37.31355], [-121.76879, 37.31346], [-121.76878, 37.31352], [-121.7688, 37.31357]]], [[[-121.76968, 37.31344], [-121.76903, 37.31354], [-121.76903, 37.31348], [-121.76901, 37.31343], [-121.76966, 37.31333], [-121.76968, 37.31344]]]]} | Open Access 1 | Pocket Park No. 15 | 23824 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.923 | PP No. 15 | 2004 | |
1613 | 1613 | 1612 | {"type": "Polygon", "coordinates": [[[-121.76143, 37.31313], [-121.76078, 37.31323], [-121.76083, 37.31318], [-121.7608, 37.31299], [-121.76085, 37.31282], [-121.76091, 37.31279], [-121.76098, 37.31279], [-121.76143, 37.31313]]]} | Open Access 1 | Pocket Park No. 16 | 23825 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.383 | PP No. 16 | 1994 | |
1614 | 1614 | 1613 | {"type": "MultiPolygon", "coordinates": [[[[-121.75909, 37.31125], [-121.75908, 37.31129], [-121.75903, 37.31135], [-121.75894, 37.31143], [-121.75879, 37.3115], [-121.75881, 37.31139], [-121.7588, 37.31118], [-121.7587, 37.3111], [-121.75843, 37.31101], [-121.758, 37.31101], [-121.75767, 37.31106], [-121.75771, 37.31101], [-121.75779, 37.31097], [-121.75801, 37.31095], [-121.75802, 37.31091], [-121.75822, 37.3109], [-121.75847, 37.31091], [-121.75859, 37.31093], [-121.75879, 37.31101], [-121.75901, 37.31116], [-121.75909, 37.31125]]], [[[-121.75906, 37.31205], [-121.75896, 37.31207], [-121.75881, 37.3116], [-121.75887, 37.31158], [-121.75906, 37.31205]]], [[[-121.75984, 37.31269], [-121.75981, 37.31281], [-121.75957, 37.31279], [-121.75949, 37.31283], [-121.75915, 37.31287], [-121.75902, 37.31229], [-121.75903, 37.31224], [-121.75907, 37.31221], [-121.75914, 37.31219], [-121.75928, 37.31242], [-121.75946, 37.31246], [-121.75954, 37.31264], [-121.75984, 37.31269]]]]} | Open Access 1 | Pocket Park No. 17 | 23826 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.194 | PP No. 17 | 2004 | |
1615 | 1615 | 1614 | {"type": "Polygon", "coordinates": [[[-121.75911, 37.31065], [-121.75911, 37.31077], [-121.75894, 37.31093], [-121.75867, 37.31081], [-121.75863, 37.31078], [-121.7587, 37.31058], [-121.75902, 37.3106], [-121.75911, 37.31065]]]} | Open Access 1 | Pocket Park No. 18 | 23827 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.285 | PP No. 18 | 2004 | |
1624 | 1624 | 1623 | {"type": "Polygon", "coordinates": [[[-121.92157, 37.31987], [-121.92107, 37.31987], [-121.92107, 37.31975], [-121.92153, 37.31975], [-121.92157, 37.31977], [-121.92157, 37.31987]]]} | Open Access 1 | Buena Vista Park | 16493 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.147 | Buena Vista Park | 2004 | |
1680 | 1680 | 1679 | {"type": "Polygon", "coordinates": [[[-121.77072, 37.22196], [-121.77013, 37.22259], [-121.76976, 37.22234], [-121.76988, 37.22226], [-121.76994, 37.22218], [-121.77006, 37.22183], [-121.77011, 37.22179], [-121.77017, 37.22179], [-121.77036, 37.22183], [-121.77072, 37.22196]]]} | Open Access 1 | Avenida Espana Park | 15723 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.924 | Avenida Espana Park | 1997 | |
1705 | 1705 | 1704 | {"type": "Polygon", "coordinates": [[[-121.75759, 37.30772], [-121.75723, 37.3079], [-121.7574, 37.30815], [-121.75736, 37.30818], [-121.7573, 37.30817], [-121.75713, 37.30796], [-121.75708, 37.30783], [-121.75703, 37.30764], [-121.75707, 37.30757], [-121.75706, 37.3075], [-121.75701, 37.30746], [-121.75694, 37.30744], [-121.75688, 37.30733], [-121.75718, 37.30743], [-121.7573, 37.30749], [-121.75744, 37.30758], [-121.75759, 37.30772]]]} | Open Access 1 | Pocket Park No. 19 | 23828 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.523 | PP No. 19 | 2004 | |
1716 | 1716 | 1715 | {"type": "Polygon", "coordinates": [[[-121.88597, 37.3528], [-121.88435, 37.35358], [-121.88288, 37.35164], [-121.8845, 37.35086], [-121.88597, 37.3528]]]} | Open Access 1 | Backesto | 15753 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 10.459 | Backesto | 1981 | |
1750 | 1750 | 1749 | {"type": "Polygon", "coordinates": [[[-121.87741, 37.32001], [-121.87733, 37.32006], [-121.8769, 37.31949], [-121.8769, 37.31949], [-121.87741, 37.32001]]]} | Open Access 1 | Caldwallder Park | 16674 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.082 | Caldwallder Park | ||
1755 | 1755 | 1754 | {"type": "MultiPolygon", "coordinates": [[[[-121.81736, 37.31364], [-121.8153, 37.31502], [-121.81397, 37.31591], [-121.81404, 37.31557], [-121.81408, 37.31554], [-121.81431, 37.31549], [-121.81447, 37.31539], [-121.81459, 37.31525], [-121.81465, 37.31511], [-121.81476, 37.31501], [-121.81492, 37.31494], [-121.81519, 37.31489], [-121.81535, 37.31481], [-121.81609, 37.31431], [-121.81679, 37.31386], [-121.81692, 37.31374], [-121.81701, 37.31356], [-121.81708, 37.31349], [-121.81717, 37.31348], [-121.81725, 37.31354], [-121.81727, 37.31354], [-121.81736, 37.31364]]], [[[-121.8212, 37.31105], [-121.8176, 37.31346], [-121.8174, 37.31329], [-121.81739, 37.31326], [-121.81741, 37.31321], [-121.81755, 37.31312], [-121.81769, 37.31306], [-121.81803, 37.31296], [-121.8182, 37.31289], [-121.81946, 37.31205], [-121.81964, 37.31188], [-121.81983, 37.3116], [-121.82001, 37.31145], [-121.8202, 37.31136], [-121.82077, 37.31116], [-121.82105, 37.311], [-121.82113, 37.311], [-121.8212, 37.31105]]]]} | Open Access 1 | Barberry Pathway | 15808 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 3.881 | Barberry Pathway |
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]);