superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
253 rows where MNG_AGENCY = 32 and MNG_AG_TYP = 2 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
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 | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
2147 | 2147 | 2146 | {"type": "Polygon", "coordinates": [[[-121.8579, 37.34324], [-121.8574, 37.34356], [-121.85695, 37.3431], [-121.85708, 37.34304], [-121.8573, 37.34296], [-121.85745, 37.34288], [-121.8575, 37.34287], [-121.85754, 37.34289], [-121.8579, 37.34324]]]} | Open Access 1 | Bonita Park | 16263 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.825 | Bonita Park | ||
2203 | 2203 | 2202 | {"type": "Polygon", "coordinates": [[[-121.91133, 37.3038], [-121.91123, 37.3038], [-121.91097, 37.30388], [-121.90824, 37.30511], [-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 | Bramhall | 16328 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 14.618 | Bramhall | 1980 | |
2207 | 2207 | 2206 | {"type": "Polygon", "coordinates": [[[-121.90776, 37.25402], [-121.90738, 37.25423], [-121.90704, 37.25406], [-121.90677, 37.2541], [-121.90671, 37.25396], [-121.90667, 37.2539], [-121.90622, 37.2536], [-121.90607, 37.25347], [-121.90602, 37.25341], [-121.90597, 37.25326], [-121.90599, 37.25284], [-121.90585, 37.25248], [-121.90672, 37.25225], [-121.90776, 37.25402]]]} | Open Access 1 | Branham Park | 16332 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 4.925 | Branham Park | 1973 | |
2255 | 2255 | 2254 | {"type": "Polygon", "coordinates": [[[-121.8035, 37.30682], [-121.80348, 37.30687], [-121.80342, 37.30691], [-121.80274, 37.30716], [-121.80239, 37.30728], [-121.80198, 37.30736], [-121.80174, 37.30745], [-121.80173, 37.30741], [-121.8018, 37.3073], [-121.80176, 37.30725], [-121.80189, 37.30719], [-121.80193, 37.30712], [-121.80193, 37.30707], [-121.80181, 37.30689], [-121.80211, 37.30675], [-121.80218, 37.30659], [-121.80224, 37.3065], [-121.80199, 37.30552], [-121.80308, 37.30536], [-121.80312, 37.30539], [-121.8035, 37.30682]]]} | Open Access 1 | Brigadoon Park | 16387 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 5.431 | Brigadoon Park | ||
2256 | 2256 | 2255 | {"type": "Polygon", "coordinates": [[[-121.8079, 37.3073], [-121.80762, 37.30745], [-121.80746, 37.30774], [-121.80743, 37.30773], [-121.80751, 37.30753], [-121.80727, 37.30715], [-121.80759, 37.30702], [-121.80764, 37.30702], [-121.80768, 37.30704], [-121.8079, 37.3073]]]} | Open Access 1 | Brigadoon Tot Lot | 16388 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.455 | Brigadoon Tot Lot | 1996 | |
2291 | 2291 | 2290 | {"type": "Polygon", "coordinates": [[[-121.88224, 37.39685], [-121.88204, 37.397], [-121.88141, 37.39766], [-121.88009, 37.39609], [-121.88041, 37.39576], [-121.88041, 37.39563], [-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 | Brooktree park | 16434 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 7.137 | Brooktree park | 1981 |
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]);