units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
175 rows where DES_TP = 2, MNG_AGENCY = 32 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
- Open Access 154
- Restricted Access 1
MNG_AG_TYP 1
- City Agency · 155 ✖
MNG_AGENCY 1
- San Jose, City of · 155 ✖
DES_TP 1
- Local Park · 155 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1427 | 1427 | 1426 | {"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 | 9084 | Pocket Park No. 18 | 23827 | 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.285 | PP No. 18 | 2004 | Local Park 2 | 4 | |
1432 | 1432 | 1431 | {"type": "Polygon", "coordinates": [[[-121.88594, 37.31445], [-121.88536, 37.31483], [-121.88518, 37.31455], [-121.88449, 37.31485], [-121.88433, 37.31463], [-121.88552, 37.31397], [-121.88594, 37.31445]]]} | Open Access 1 | 48980 | Tamien Park | 33676 | 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 | https://www.mercurynews.com/2017/06/21/tamien-park-opens-after-22-years-of-planning/ | Santa Clara 19 | 1.588 | Tamien Park | 2017 | Local Park 2 | 4 |
1450 | 1450 | 1449 | {"type": "Polygon", "coordinates": [[[-121.79984, 37.29776], [-121.79995, 37.29788], [-121.80108, 37.29865], [-121.80193, 37.29927], [-121.80227, 37.29957], [-121.80229, 37.29962], [-121.80228, 37.29968], [-121.80223, 37.29972], [-121.80217, 37.29974], [-121.80167, 37.29976], [-121.80127, 37.29971], [-121.80083, 37.29959], [-121.80041, 37.29941], [-121.80028, 37.29934], [-121.79935, 37.29865], [-121.79849, 37.29807], [-121.7982, 37.29794], [-121.79762, 37.29775], [-121.79726, 37.2977], [-121.79688, 37.29768], [-121.79618, 37.29772], [-121.79586, 37.29771], [-121.79542, 37.29766], [-121.79511, 37.29759], [-121.79493, 37.29754], [-121.79489, 37.2975], [-121.79488, 37.29746], [-121.79492, 37.29733], [-121.79496, 37.2973], [-121.79501, 37.29728], [-121.79528, 37.29728], [-121.79537, 37.29731], [-121.79733, 37.29722], [-121.79798, 37.29744], [-121.79841, 37.29762], [-121.79914, 37.29778], [-121.79984, 37.29776]]]} | Open Access 1 | 9709 | Silver Creek Linear Park | 25483 | 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 | 11.638 | Silver Creek Linear Park | 1997 | 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 | |
1790 | 1790 | 1789 | {"type": "Polygon", "coordinates": [[[-121.83645, 37.24059], [-121.83612, 37.24066], [-121.83588, 37.24074], [-121.83565, 37.24083], [-121.83516, 37.24109], [-121.83514, 37.23933], [-121.83481, 37.2392], [-121.83482, 37.23916], [-121.83514, 37.23922], [-121.83514, 37.23927], [-121.83645, 37.24059]]]} | Open Access 1 | 13489 | Comanche Park | 17557 | 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 | 2.783 | Comanche Park | 1982 | Local Park 2 | 4 | |
1803 | 1803 | 1802 | {"type": "Polygon", "coordinates": [[[-121.84745, 37.20134], [-121.84565, 37.20254], [-121.84563, 37.20249], [-121.84558, 37.20245], [-121.84551, 37.20245], [-121.84545, 37.20247], [-121.84542, 37.20251], [-121.84541, 37.20256], [-121.84544, 37.2026], [-121.84551, 37.20264], [-121.8452, 37.20285], [-121.84461, 37.20322], [-121.8433, 37.20177], [-121.84341, 37.20185], [-121.84347, 37.20186], [-121.84352, 37.20184], [-121.84355, 37.2018], [-121.84354, 37.20175], [-121.84342, 37.20169], [-121.84517, 37.20043], [-121.84539, 37.20021], [-121.84556, 37.19995], [-121.84566, 37.20001], [-121.84567, 37.20007], [-121.84573, 37.20011], [-121.84578, 37.20011], [-121.84589, 37.20008], [-121.84634, 37.20012], [-121.8466, 37.20018], [-121.84684, 37.20031], [-121.8472, 37.20066], [-121.84718, 37.20071], [-121.8472, 37.20078], [-121.84745, 37.20134]]]} | Open Access 1 | 13649 | Cathedral Oaks Park | 16975 | 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 | 16.969 | Cathedral Oaks Park | 0 | Local Park 2 | 4 | |
1804 | 1804 | 1803 | {"type": "Polygon", "coordinates": [[[-121.84341, 37.36447], [-121.84319, 37.36462], [-121.84225, 37.36365], [-121.84266, 37.36339], [-121.84316, 37.36423], [-121.84341, 37.36447]]]} | Open Access 1 | 13651 | Children of the Rainbow Park | 17197 | 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.1 | Children of the Rainbow Park | 1989 | Local Park 2 | 4 | |
1805 | 1805 | 1804 | {"type": "Polygon", "coordinates": [[[-121.88006, 37.33079], [-121.87965, 37.33098], [-121.87955, 37.33084], [-121.87991, 37.33067], [-121.87982, 37.33052], [-121.87985, 37.33051], [-121.88006, 37.33079]]]} | Open Access 1 | 13703 | O'Donnell Garden Park | 22946 | 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.201 | O'Donnell Garden Park | 1940 | Local Park 2 | 4 | |
1806 | 1806 | 1805 | {"type": "MultiPolygon", "coordinates": [[[[-121.83002, 37.34971], [-121.82992, 37.34978], [-121.82949, 37.34934], [-121.82959, 37.34928], [-121.83002, 37.34971]]], [[[-121.83066, 37.3502], [-121.83045, 37.35034], [-121.83004, 37.34991], [-121.83014, 37.34984], [-121.83034, 37.35006], [-121.83045, 37.34999], [-121.83066, 37.3502]]]]} | Open Access 1 | 13706 | Our Park | 23268 | 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.437 | Our Park | 1971 | Local Park 2 | 4 | |
1807 | 1807 | 1806 | {"type": "Polygon", "coordinates": [[[-121.90114, 37.3155], [-121.90116, 37.31561], [-121.90116, 37.31572], [-121.90114, 37.31582], [-121.9011, 37.31592], [-121.90019, 37.31569], [-121.90017, 37.31567], [-121.90019, 37.31565], [-121.90111, 37.31549], [-121.90114, 37.3155]]]} | Open Access 1 | 13708 | Palm Haven Plaza | 23339 | 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.563 | Palm Haven Plaza | 1990 | Local Park 2 | 4 | |
1810 | 1810 | 1809 | {"type": "Polygon", "coordinates": [[[-121.91563, 37.36258], [-121.91482, 37.36298], [-121.91447, 37.36254], [-121.91522, 37.36207], [-121.91563, 37.36258]]]} | Open Access 1 | 13739 | Rosemary Gardens Park | 24619 | 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.306 | Rosemary Gardens Park | 1972 | Local Park 2 | 4 | |
1811 | 1811 | 1810 | {"type": "Polygon", "coordinates": [[[-121.87893, 37.28067], [-121.87888, 37.28071], [-121.87872, 37.28064], [-121.87863, 37.28065], [-121.87791, 37.28092], [-121.87784, 37.28092], [-121.87762, 37.28056], [-121.87756, 37.28043], [-121.87735, 37.28009], [-121.87731, 37.27998], [-121.87714, 37.27971], [-121.87707, 37.27964], [-121.87688, 37.27961], [-121.87685, 37.27954], [-121.87753, 37.27925], [-121.87773, 37.27952], [-121.87841, 37.28024], [-121.87893, 37.28067]]]} | Open Access 1 | 13741 | Rubino Park | 24723 | 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.22 | Rubino Park | 2000 | Local Park 2 | 4 | |
1812 | 1812 | 1811 | {"type": "Polygon", "coordinates": [[[-121.89561, 37.25718], [-121.89547, 37.25727], [-121.89533, 37.25733], [-121.89499, 37.25756], [-121.89484, 37.2574], [-121.89484, 37.25737], [-121.89487, 37.25734], [-121.89544, 37.25705], [-121.89551, 37.25706], [-121.89561, 37.25718]]]} | Open Access 1 | 13746 | Scottsdale Park | 25216 | 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.386 | Scottsdale Park | 1997 | Local Park 2 | 4 | |
1813 | 1813 | 1812 | {"type": "Polygon", "coordinates": [[[-121.85647, 37.27809], [-121.85646, 37.2782], [-121.85641, 37.2783], [-121.85628, 37.27849], [-121.8561, 37.27863], [-121.85589, 37.27872], [-121.85573, 37.27876], [-121.85558, 37.27877], [-121.8545, 37.27877], [-121.85445, 37.27874], [-121.85445, 37.27809], [-121.85647, 37.27809]]]} | Open Access 1 | 13748 | Waterford Park | 27300 | 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 | 2.997 | Waterford Park | 2003 | Local Park 2 | 4 | |
1818 | 1818 | 1817 | {"type": "Polygon", "coordinates": [[[-121.8839, 37.2883], [-121.88362, 37.28834], [-121.88342, 37.28845], [-121.8832, 37.28805], [-121.88353, 37.28762], [-121.88367, 37.28739], [-121.8837, 37.28739], [-121.88371, 37.28755], [-121.88377, 37.2877], [-121.88391, 37.28787], [-121.88388, 37.28808], [-121.8839, 37.2883]]]} | Open Access 1 | 15657 | Roy Avenue Park | 24709 | 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.016 | Roy Avenue Park | 1954 | Local Park 2 | 4 | |
1999 | 1999 | 1998 | {"type": "Polygon", "coordinates": [[[-121.82582, 37.2727], [-121.82555, 37.27295], [-121.82555, 37.27309], [-121.82505, 37.2734], [-121.82524, 37.2741], [-121.82307, 37.27331], [-121.82274, 37.2722], [-121.82283, 37.27213], [-121.82287, 37.27199], [-121.82297, 37.27176], [-121.823, 37.27172], [-121.82304, 37.27172], [-121.82351, 37.27185], [-121.82582, 37.2727]]]} | Open Access 1 | 15311 | Danna Rock Park | 17921 | 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 | 9.56 | Danna Rock Park | 1985 | Local Park 2 | 4 | |
2107 | 2107 | 2106 | {"type": "Polygon", "coordinates": [[[-121.823, 37.2655], [-121.82273, 37.26566], [-121.82189, 37.26626], [-121.82172, 37.26633], [-121.82156, 37.26635], [-121.82143, 37.26634], [-121.82131, 37.2663], [-121.82003, 37.26559], [-121.8195, 37.26514], [-121.81947, 37.26509], [-121.81945, 37.26503], [-121.81942, 37.26502], [-121.81945, 37.26287], [-121.82135, 37.26289], [-121.82136, 37.26338], [-121.82176, 37.26351], [-121.82177, 37.26403], [-121.82155, 37.2643], [-121.82156, 37.26434], [-121.823, 37.2655]]]} | Open Access 1 | 15890 | Edenvale Garden | 18431 | 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 | 18.978 | Edenvale Garden | 1991 | Local Park 2 | 4 | |
2304 | 2304 | 2303 | {"type": "Polygon", "coordinates": [[[-121.81025, 37.29897], [-121.80953, 37.29949], [-121.80862, 37.29863], [-121.80923, 37.29804], [-121.81025, 37.29897]]]} | Open Access 1 | 16998 | Dovehill Park | 18251 | 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 | 2.74 | Dovehill Park | 2000 | Local Park 2 | 4 | |
2382 | 2382 | 2381 | {"type": "Polygon", "coordinates": [[[-121.8149, 37.23239], [-121.81368, 37.23281], [-121.81369, 37.23392], [-121.81364, 37.23398], [-121.81363, 37.23404], [-121.81363, 37.23446], [-121.81364, 37.23453], [-121.81369, 37.23461], [-121.8137, 37.23499], [-121.81156, 37.23502], [-121.81124, 37.23471], [-121.81128, 37.23466], [-121.81129, 37.2346], [-121.81124, 37.23451], [-121.81121, 37.23433], [-121.81117, 37.23422], [-121.81106, 37.23396], [-121.81063, 37.23325], [-121.81059, 37.23314], [-121.81053, 37.23282], [-121.81054, 37.23278], [-121.81058, 37.23275], [-121.81076, 37.23272], [-121.81096, 37.23267], [-121.8111, 37.2326], [-121.81125, 37.23251], [-121.8124, 37.23151], [-121.81267, 37.2317], [-121.81292, 37.23149], [-121.81306, 37.23141], [-121.81359, 37.23123], [-121.81376, 37.23155], [-121.8142, 37.23141], [-121.8143, 37.23152], [-121.81449, 37.23165], [-121.8149, 37.23239]]]} | Open Access 1 | 17211 | La Colina Park and Garden | 20748 | 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 | 23.837 | La Colina Park and Garden | 1982 | Local Park 2 | 4 | |
2548 | 2548 | 2547 | {"type": "Polygon", "coordinates": [[[-121.8958, 37.33096], [-121.89562, 37.33105], [-121.89566, 37.3311], [-121.89464, 37.33158], [-121.89428, 37.33112], [-121.89503, 37.33075], [-121.8948, 37.33045], [-121.89469, 37.33046], [-121.89439, 37.33005], [-121.8946, 37.32996], [-121.89524, 37.33065], [-121.89524, 37.33066], [-121.89578, 37.33083], [-121.89576, 37.33089], [-121.8958, 37.33096]]]} | Open Access 1 | 17797 | McEnery Park | 22028 | 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 | 2.284 | McEnery Park | 1990 | 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]);