units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
174 rows where ACCESS_TYP = 1, DES_TP = 2 and MNG_AGENCY = 32 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 174 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8615 | 8615 | 8614 | {"type": "Polygon", "coordinates": [[[-121.79774, 37.31556], [-121.79746, 37.31561], [-121.79725, 37.31561], [-121.79714, 37.31564], [-121.79702, 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.31464], [-121.79742, 37.31517], [-121.79763, 37.31546], [-121.79774, 37.31556]]]} | Open Access 1 | 13754 | Aborn Park | 15237 | 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.601 | Aborn Park | 2000 | Local Park 2 | 4 | |
14873 | 14873 | 14872 | {"type": "Polygon", "coordinates": [[[-121.89511, 37.33384], [-121.89479, 37.334], [-121.89467, 37.33357], [-121.89511, 37.33384], [-121.89511, 37.33384]]]} | Open Access 1 | 45394 | Almaden Entrance Triangle Park | 27910 | 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/prns | Santa Clara 19 | 0.191 | Almaden Entrance Triangle Park | 0 | Local Park 2 | 4 |
9638 | 9638 | 9637 | {"type": "Polygon", "coordinates": [[[-121.89357, 37.23685], [-121.89348, 37.23689], [-121.89352, 37.23696], [-121.89427, 37.23791], [-121.89428, 37.23794], [-121.89425, 37.23798], [-121.89373, 37.23825], [-121.89364, 37.23832], [-121.89355, 37.23842], [-121.89352, 37.23843], [-121.89349, 37.23841], [-121.89266, 37.23737], [-121.8926, 37.23734], [-121.89286, 37.2372], [-121.8927, 37.23699], [-121.89264, 37.23682], [-121.89285, 37.23678], [-121.89292, 37.23697], [-121.89335, 37.23688], [-121.89324, 37.23638], [-121.89339, 37.23647], [-121.89347, 37.23656], [-121.89357, 37.23685]]]} | Open Access 1 | 16281 | Almaden Winery Park | 15391 | 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.606 | Almaden Winery Park | 1998 | Local Park 2 | 4 | |
9422 | 9422 | 9421 | {"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.96674, 37.42526], [-121.9667, 37.42508], [-121.96711, 37.42501], [-121.96722, 37.42537], [-121.96863, 37.42514], [-121.96837, 37.42417], [-121.96898, 37.42432], [-121.96891, 37.42471], [-121.96948, 37.42504]]]} | Open Access 1 | 15752 | Alviso Park | 15432 | 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.581 | Alviso Park | 1968 | Local Park 2 | 4 | |
8579 | 8579 | 8578 | {"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 | 13626 | Avenida Espana Park | 15723 | 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 | 0.924 | Avenida Espana Park | 1997 | Local Park 2 | 4 | |
8580 | 8580 | 8579 | {"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.75943, 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 | 13628 | Basking Ridge Park | 15853 | 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.042 | Basking Ridge Park | 2005 | Local Park 2 | 4 | |
12515 | 12515 | 12514 | {"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 | 28350 | Bellevue Park | 15987 | 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.763 | Bellevue Park | 0 | Local Park 2 | 4 | |
8581 | 8581 | 8580 | {"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 | 13630 | Bernal Park | 16029 | 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.214 | Bernal Park | 1999 | Local Park 2 | 4 | |
8616 | 8616 | 8615 | {"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 | 13756 | Berryessa Community Garden | 16035 | 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.841 | Berryessa Community Garden | 0 | Local Park 2 | 4 | |
8572 | 8572 | 8571 | {"type": "Polygon", "coordinates": [[[-121.87488, 37.32302], [-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.32323], [-121.87488, 37.32302]]]} | Open Access 1 | 13632 | Bestor Art Park | 16043 | 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 | 0.719 | Bestor Art Park | 1940 | Local Park 2 | 4 | |
8582 | 8582 | 8581 | {"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 | 13634 | Biebrach Park | 16071 | 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.305 | Biebrach Park | 1978 | Local Park 2 | 4 | |
3986 | 3986 | 3985 | {"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 | 38021 | Bonita Park | 16263 | 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 | 0.825 | Bonita Park | 0 | Local Park 2 | 4 | |
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 | |
14199 | 14199 | 14198 | {"type": "Polygon", "coordinates": [[[-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.80194, 37.30712], [-121.80193, 37.30707], [-121.80181, 37.30689], [-121.80212, 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], [-121.80348, 37.30687], [-121.80342, 37.30691], [-121.80274, 37.30716]]]} | Open Access 1 | 44050 | Brigadoon Park | 16387 | 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.43 | Brigadoon Park | 0 | Local Park 2 | 4 | |
9368 | 9368 | 9367 | {"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 | 15649 | Buena Vista Park | 16493 | 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 | 0.148 | Buena Vista Park | 2004 | Local Park 2 | 4 | |
8584 | 8584 | 8583 | {"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.32904], [-121.90456, 37.32899], [-121.90449, 37.32896], [-121.90424, 37.32896], [-121.90419, 37.32828], [-121.90509, 37.32824], [-121.9051, 37.32842], [-121.90563, 37.3284], [-121.90573, 37.32842], [-121.90575, 37.3289]]]} | Open Access 1 | 13641 | Cahill Park | 16656 | 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.71 | Cahill Park | 2004 | Local Park 2 | 4 | |
1609 | 1609 | 1608 | {"type": "Polygon", "coordinates": [[[-121.87741, 37.32001], [-121.87733, 37.32006], [-121.8769, 37.31949], [-121.87741, 37.32001], [-121.87741, 37.32001]]]} | Open Access 1 | 13645 | Caldwallder Park | 16674 | 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 | 0.082 | Caldwallder Park | 0 | Local Park 2 | 4 | |
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 | |
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 | |
8574 | 8574 | 8573 | {"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 | 13647 | Canyon Creek Park | 16813 | 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.151 | Canyon Creek Park | 2005 | Local Park 2 | 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]);