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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
2390 | 2390 | 2389 | {"type": "Polygon", "coordinates": [[[-121.9176, 37.25993], [-121.91518, 37.26101], [-121.91514, 37.26101], [-121.91508, 37.26099], [-121.91444, 37.26006], [-121.91444, 37.26002], [-121.91445, 37.25999], [-121.91687, 37.25892], [-121.91694, 37.25895], [-121.9176, 37.25989], [-121.9176, 37.25993]]]} | Open Access 1 | Butcher | 16545 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 8.116 | Butcher | 1981 | |
2474 | 2474 | 2473 | {"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 | Cahalan | 16655 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 9.756 | Cahalan | 1978 | |
2475 | 2475 | 2474 | {"type": "Polygon", "coordinates": [[[-121.90575, 37.3289], [-121.90546, 37.32891], [-121.9054, 37.32894], [-121.90536, 37.32899], [-121.90535, 37.32904], [-121.90539, 37.32905], [-121.90543, 37.32964], [-121.90462, 37.32968], [-121.90458, 37.32909], [-121.9046, 37.32908], [-121.9046, 37.32905], [-121.90456, 37.32899], [-121.90449, 37.32896], [-121.90424, 37.32896], [-121.90419, 37.32828], [-121.90509, 37.32824], [-121.90511, 37.32842], [-121.90563, 37.3284], [-121.90573, 37.32842], [-121.90575, 37.3289]]]} | Open Access 1 | Cahill Park | 16656 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 3.712 | Cahill Park | 2004 | |
2451 | 2451 | 2450 | {"type": "Polygon", "coordinates": [[[-122.02681, 37.30115], [-122.02645, 37.30261], [-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.02376, 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 | Calabazas | 16668 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 16.77 | Calabazas | 1978 | |
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 | ||
2494 | 2494 | 2493 | {"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 | Calero Park | 16680 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 4.064 | Calero Park | 1980 | |
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 | |
2589 | 2589 | 2588 | {"type": "Polygon", "coordinates": [[[-121.87874, 37.2851], [-121.87862, 37.28552], [-121.8768, 37.28518], [-121.87693, 37.28476], [-121.87874, 37.2851]]]} | Open Access 1 | Canoas Park | 16806 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.986 | Canoas Park | 1989 | |
2593 | 2593 | 2592 | {"type": "Polygon", "coordinates": [[[-121.76924, 37.29043], [-121.76917, 37.29049], [-121.7689, 37.29058], [-121.76865, 37.29073], [-121.76858, 37.29075], [-121.76849, 37.29075], [-121.76842, 37.29071], [-121.76826, 37.29055], [-121.76792, 37.29031], [-121.76785, 37.29021], [-121.76784, 37.29013], [-121.76786, 37.29009], [-121.76798, 37.2901], [-121.76798, 37.29014], [-121.76802, 37.29016], [-121.76855, 37.29025], [-121.76872, 37.29026], [-121.76892, 37.29023], [-121.76906, 37.29024], [-121.76914, 37.29027], [-121.76919, 37.29032], [-121.76923, 37.29038], [-121.76924, 37.29043]]]} | Open Access 1 | Canyon Creek Park | 16813 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.151 | Canyon Creek Park | 2005 | |
2592 | 2592 | 2591 | {"type": "Polygon", "coordinates": [[[-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], [-121.83478, 37.35184], [-121.8348, 37.35189]]]} | Open Access 1 | Capitol | 16836 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 10.602 | Capitol | 1967 | |
2643 | 2643 | 2642 | {"type": "Polygon", "coordinates": [[[-121.9386, 37.25096], [-121.93856, 37.25097], [-121.93856, 37.25136], [-121.93859, 37.25139], [-121.93853, 37.2516], [-121.93847, 37.25158], [-121.93834, 37.25157], [-121.93822, 37.25152], [-121.93802, 37.25154], [-121.93796, 37.25148], [-121.93794, 37.25145], [-121.93794, 37.25078], [-121.93797, 37.25073], [-121.93804, 37.2507], [-121.9386, 37.2507], [-121.9386, 37.25096]]]} | Open Access 1 | Carolyn Norris Park | 16888 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.303 | Carolyn Norris Park | ||
2659 | 2659 | 2658 | {"type": "Polygon", "coordinates": [[[-121.83615, 37.21266], [-121.836, 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.83549, 37.21093], [-121.83549, 37.21084], [-121.83582, 37.21077], [-121.83615, 37.21266]]]} | Open Access 1 | Carrabelle Park | 16907 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 3.684 | Carrabelle Park | 1991 | |
2701 | 2701 | 2700 | {"type": "Polygon", "coordinates": [[[-121.87631, 37.40276], [-121.87599, 37.40296], [-121.87594, 37.40287], [-121.87584, 37.40275], [-121.87572, 37.40268], [-121.87554, 37.4026], [-121.87545, 37.40254], [-121.87456, 37.40155], [-121.87443, 37.40145], [-121.87422, 37.40134], [-121.87408, 37.40129], [-121.87384, 37.40126], [-121.87369, 37.40126], [-121.87353, 37.40129], [-121.87331, 37.40137], [-121.87154, 37.40238], [-121.87135, 37.40245], [-121.87107, 37.40248], [-121.87083, 37.40256], [-121.87028, 37.40286], [-121.87021, 37.40285], [-121.86956, 37.40213], [-121.86942, 37.40207], [-121.86929, 37.40208], [-121.86659, 37.40363], [-121.86648, 37.40364], [-121.86643, 37.40363], [-121.86638, 37.40358], [-121.86565, 37.4026], [-121.86496, 37.4016], [-121.86511, 37.40159], [-121.86517, 37.40165], [-121.86521, 37.40166], [-121.86527, 37.40166], [-121.86534, 37.40161], [-121.86534, 37.40154], [-121.86538, 37.4015], [-121.86584, 37.40127], [-121.8659, 37.40127], [-121.86596, 37.40131], [-121.86627, 37.40174], [-121.86641, 37.40187], [-121.86649, 37.40191], [-121.86664, 37.40199], [-121.8668, 37.40203], [-121.86696, 37.40206], [-121.8672, 37.40205], [-121.86743, 37.402], [-121.86766, 37.40189], [-121.86873, 37.40129], [-121.86887, 37.40123], [-121.86914, 37.40118], [-121.86929, 37.40114], [-121.8699, 37.4008], [-121.86996, 37.40082], [-121.87035, 37.40125], [-121.87054, 37.40138], [-121.87068, 37.40144], [-121.87091, 37.4015], [-121.87108, 37.40151], [-121.87124, 37.4015], [-121.8714, 37.40146], [-121.87162, 37.40137], [-121.87371, 37.40016], [-121.87375, 37.40013], [-121.87377, 37.40008], [-121.87387, 37.40009], [-121.87423, 37.39987], [-121.87494, 37.40039], [-121.87514, 37.40056], [-121.87531, 37.40075], [-121.87546, 37.40095], [-121.8757, 37.40137], [-121.87631, 37.40276]]]} | Open Access 1 | Cataldi | 16968 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 32.699 | Cataldi | 1980 |
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]);