superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
253 rows where MNG_AGENCY = 32 sorted by ACCESS_TYP descending
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
1794 | 1794 | 1793 | {"type": "Polygon", "coordinates": [[[-121.76046, 37.24318], [-121.76012, 37.24392], [-121.75974, 37.24411], [-121.75913, 37.24423], [-121.75839, 37.24428], [-121.75777, 37.24352], [-121.75822, 37.24308], [-121.75858, 37.24246], [-121.75914, 37.24231], [-121.75924, 37.24253], [-121.75931, 37.24262], [-121.75944, 37.24273], [-121.75959, 37.24281], [-121.75981, 37.24289], [-121.76005, 37.24291], [-121.76023, 37.24287], [-121.76046, 37.24318]]]} | Open Access 1 | Basking Ridge Park | 15853 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 8.042 | Basking Ridge Park | 2005 | |
1809 | 1809 | 1808 | {"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.93212, 37.26389], [-121.93241, 37.26393], [-121.93262, 37.26393], [-121.93285, 37.26391], [-121.93302, 37.26387], [-121.93309, 37.26392], [-121.9331, 37.26427], [-121.93377, 37.26427], [-121.93379, 37.26408], [-121.93376, 37.26406], [-121.93375, 37.26377], [-121.93367, 37.26376], [-121.93365, 37.26359], [-121.93396, 37.26359], [-121.93397, 37.26373], [-121.93438, 37.26372], [-121.9344, 37.26367], [-121.93454, 37.26366]]]} | Open Access 1 | Camden Park Center | 16755 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 5.024 | Camden Park Ctr. | 1961 | |
1934 | 1934 | 1933 | {"type": "Polygon", "coordinates": [[[-121.87386, 37.3113], [-121.87152, 37.31279], [-121.87136, 37.31263], [-121.87365, 37.31109], [-121.87386, 37.3113]]]} | Open Access 1 | Bellevue Park | 15987 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.763 | Bellevue Park | ||
1966 | 1966 | 1965 | {"type": "Polygon", "coordinates": [[[-121.89681, 37.35637], [-121.896, 37.35675], [-121.8946, 37.35487], [-121.89458, 37.35484], [-121.8946, 37.35479], [-121.89463, 37.35476], [-121.89528, 37.35445], [-121.89534, 37.35444], [-121.89539, 37.35446], [-121.89681, 37.35637]]]} | Open Access 1 | Bernal Park | 16029 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 5.214 | Bernal Park | 1999 | |
1971 | 1971 | 1970 | {"type": "Polygon", "coordinates": [[[-121.86762, 37.40876], [-121.8673, 37.40914], [-121.86705, 37.40917], [-121.86399, 37.40917], [-121.86362, 37.40915], [-121.86338, 37.40916], [-121.863, 37.40924], [-121.86265, 37.4094], [-121.86231, 37.40952], [-121.86218, 37.40956], [-121.86184, 37.4096], [-121.86169, 37.40964], [-121.86155, 37.40971], [-121.86142, 37.4098], [-121.86128, 37.40993], [-121.86122, 37.40996], [-121.86119, 37.41], [-121.86101, 37.41017], [-121.86085, 37.41039], [-121.86069, 37.4107], [-121.86053, 37.41085], [-121.86027, 37.41105], [-121.86008, 37.41115], [-121.85954, 37.41138], [-121.85917, 37.41151], [-121.85895, 37.41163], [-121.85883, 37.41174], [-121.85854, 37.41212], [-121.85838, 37.41242], [-121.85817, 37.41268], [-121.85801, 37.41296], [-121.85746, 37.41395], [-121.85741, 37.4141], [-121.85738, 37.41423], [-121.85732, 37.41436], [-121.85723, 37.41449], [-121.85708, 37.41462], [-121.85698, 37.41475], [-121.85678, 37.41508], [-121.85672, 37.41513], [-121.85655, 37.41521], [-121.85633, 37.4156], [-121.85611, 37.41527], [-121.85724, 37.4133], [-121.85729, 37.41313], [-121.8575, 37.41286], [-121.8579, 37.41214], [-121.85814, 37.41177], [-121.85844, 37.41143], [-121.85879, 37.41114], [-121.85895, 37.41104], [-121.8594, 37.41081], [-121.85915, 37.41044], [-121.85829, 37.40995], [-121.85823, 37.40999], [-121.85769, 37.40992], [-121.85757, 37.41], [-121.85719, 37.40977], [-121.85797, 37.40946], [-121.85839, 37.40936], [-121.8588, 37.40923], [-121.86014, 37.40863], [-121.86019, 37.40864], [-121.86022, 37.40866], [-121.8607, 37.40934], [-121.86073, 37.40944], [-121.86081, 37.40948], [-121.86088, 37.40948], [-121.86091, 37.40951], [-121.86099, 37.40945], [-121.86144, 37.40924], [-121.86179, 37.40915], [-121.86219, 37.4091], [-121.8623, 37.40906], [-121.86258, 37.40891], [-121.86276, 37.40884], [-121.86297, 37.40878], [-121.86331, 37.40874], [-121.86363, 37.40875], [-121.8642, 37.40879], [-121.86683, 37.40879], [-121.86725, 37.40881], [-121.86762, 37.40876]]]} | Open Access 1 | Berryessa Creek | 16036 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 25.19 | Berryessa Creek | 1979 | |
1978 | 1978 | 1977 | {"type": "Polygon", "coordinates": [[[-121.87497, 37.32314], [-121.87496, 37.32318], [-121.87417, 37.32356], [-121.87412, 37.32354], [-121.87388, 37.32322], [-121.87424, 37.32298], [-121.87443, 37.32322], [-121.87488, 37.32302], [-121.87497, 37.32314]]]} | Open Access 1 | Bestor Art Park | 16043 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.72 | Bestor Art Park | 1940 | |
1992 | 1992 | 1991 | {"type": "Polygon", "coordinates": [[[-121.89592, 37.31933], [-121.89588, 37.32002], [-121.89304, 37.31991], [-121.89309, 37.31912], [-121.89526, 37.3192], [-121.89525, 37.3194], [-121.89529, 37.31941], [-121.89538, 37.31938], [-121.89542, 37.31931], [-121.89592, 37.31933]]]} | Open Access 1 | Biebrach Park | 16071 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 5.305 | Biebrach Park | 1978 | |
2114 | 2114 | 2113 | {"type": "Polygon", "coordinates": [[[-121.78876, 37.32298], [-121.78872, 37.323], [-121.78845, 37.32299], [-121.7871, 37.323], [-121.78698, 37.32299], [-121.7869, 37.32302], [-121.78686, 37.32309], [-121.78652, 37.32309], [-121.78654, 37.32305], [-121.78649, 37.32159], [-121.78773, 37.32135], [-121.78863, 37.32122], [-121.78869, 37.32124], [-121.78871, 37.32127], [-121.78876, 37.32298]]]} | Open Access 1 | Boggini | 16227 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 8.783 | Boggini | 1981 | |
2141 | 2141 | 2140 | {"type": "Polygon", "coordinates": [[[-121.87643, 37.24514], [-121.87505, 37.24548], [-121.87496, 37.24522], [-121.87496, 37.24514], [-121.87531, 37.24513], [-121.876, 37.24502], [-121.87635, 37.24494], [-121.87643, 37.24514]]]} | Open Access 1 | Chris Hotts Park | 17222 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.878 | Chris Hotts Park | 1998 |
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]);