units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
175 rows where DES_TP = 2 and MNG_AGENCY = 32 sorted by SUID_NMA
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3984 | 3984 | 3983 | {"type": "Polygon", "coordinates": [[[-121.9386, 37.25096], [-121.93856, 37.25096], [-121.93856, 37.25137], [-121.93859, 37.25138], [-121.93859, 37.25139], [-121.93853, 37.2516], [-121.93848, 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 | 38019 | Carolyn Norris Park | 16888 | 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.303 | Carolyn Norris Park | 0 | Local Park 2 | 4 | |
7736 | 7736 | 7735 | {"type": "Polygon", "coordinates": [[[-121.83615, 37.21266], [-121.83601, 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.8355, 37.21093], [-121.83549, 37.21084], [-121.83582, 37.21077], [-121.83615, 37.21266]]]} | Open Access 1 | 8250 | Carrabelle Park | 16907 | 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.683 | Carrabelle Park | 1991 | 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 | |
8587 | 8587 | 8586 | {"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 | 13653 | Chris Hotts Park | 17222 | 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.878 | Chris Hotts Park | 1998 | Local Park 2 | 4 | |
8588 | 8588 | 8587 | {"type": "Polygon", "coordinates": [[[-121.81932, 37.25991], [-121.81815, 37.25992], [-121.81815, 37.25986], [-121.81821, 37.25982], [-121.81824, 37.25976], [-121.81822, 37.25971], [-121.81813, 37.25964], [-121.81812, 37.2596], [-121.81812, 37.25948], [-121.81819, 37.25924], [-121.81822, 37.25905], [-121.81826, 37.25902], [-121.81831, 37.25901], [-121.81906, 37.25906], [-121.8192, 37.25906], [-121.81928, 37.25909], [-121.81932, 37.25913], [-121.81933, 37.25918], [-121.81932, 37.25991]]]} | Open Access 1 | 13655 | Chynoweth Park | 17252 | 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.45 | Chynoweth Park | 2001 | Local Park 2 | 4 | |
8021 | 8021 | 8020 | {"type": "Polygon", "coordinates": [[[-121.84022, 37.38534], [-121.84024, 37.38539], [-121.84022, 37.38543], [-121.84008, 37.38557], [-121.84, 37.3856], [-121.83995, 37.38565], [-121.83994, 37.3857], [-121.83996, 37.38576], [-121.83942, 37.38602], [-121.83934, 37.38599], [-121.83924, 37.386], [-121.83918, 37.38607], [-121.83918, 37.38613], [-121.83862, 37.38641], [-121.83773, 37.38527], [-121.83772, 37.38523], [-121.83774, 37.38519], [-121.83777, 37.38517], [-121.83922, 37.38454], [-121.83928, 37.38456], [-121.8394, 37.38472], [-121.83956, 37.38486], [-121.84022, 37.38534]]]} | Open Access 1 | 11354 | Cimarron Park | 17256 | 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.24 | Cimarron Park | 1981 | Local Park 2 | 4 | |
1231 | 1231 | 1230 | {"type": "Polygon", "coordinates": [[[-121.77596, 37.3123], [-121.77617, 37.31248], [-121.77619, 37.31251], [-121.77616, 37.31256], [-121.77565, 37.31284], [-121.77558, 37.31283], [-121.77541, 37.31269], [-121.77596, 37.3123]]]} | Open Access 1 | 8894 | Classico Park | 17392 | 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.476 | Classico Park | 2004 | Local Park 2 | 4 | |
8542 | 8542 | 8541 | {"type": "MultiPolygon", "coordinates": [[[[-121.90847, 37.34424], [-121.90854, 37.34426], [-121.90928, 37.34492], [-121.9093, 37.34496], [-121.9093, 37.34499], [-121.90788, 37.34598], [-121.9071, 37.34525], [-121.90708, 37.3452], [-121.90843, 37.34425], [-121.90847, 37.34424]]], [[[-121.91054, 37.34412], [-121.90959, 37.34479], [-121.90952, 37.34481], [-121.90945, 37.34479], [-121.90871, 37.34414], [-121.90869, 37.34409], [-121.90872, 37.34405], [-121.90972, 37.34339], [-121.90975, 37.34339], [-121.91054, 37.34412]]]]} | Open Access 1 | 13459 | Columbus Park | 17551 | 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.017 | Columbus 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 | |
1415 | 1415 | 1414 | {"type": "MultiPolygon", "coordinates": [[[[-121.76776, 37.31275], [-121.76743, 37.31279], [-121.76713, 37.31286], [-121.76708, 37.31283], [-121.767, 37.31282], [-121.76693, 37.31285], [-121.7669, 37.31289], [-121.76658, 37.31288], [-121.76657, 37.31284], [-121.76616, 37.31274], [-121.76601, 37.31272], [-121.76564, 37.31277], [-121.76555, 37.31276], [-121.76549, 37.3128], [-121.76473, 37.31291], [-121.76467, 37.31266], [-121.76469, 37.31264], [-121.76589, 37.31246], [-121.76603, 37.31245], [-121.76628, 37.31247], [-121.76657, 37.31256], [-121.76671, 37.31258], [-121.76687, 37.31258], [-121.76765, 37.31251], [-121.76772, 37.31256], [-121.76776, 37.31275]]], [[[-121.7705, 37.31315], [-121.77014, 37.31317], [-121.7698, 37.31322], [-121.76982, 37.31314], [-121.76981, 37.31309], [-121.76976, 37.31305], [-121.76967, 37.31304], [-121.76963, 37.31294], [-121.76915, 37.31273], [-121.76885, 37.31278], [-121.76885, 37.31271], [-121.7688, 37.31267], [-121.76871, 37.31265], [-121.76864, 37.31269], [-121.76856, 37.31265], [-121.76795, 37.31274], [-121.76789, 37.31251], [-121.76794, 37.31247], [-121.76849, 37.31238], [-121.76881, 37.31239], [-121.76901, 37.31242], [-121.77002, 37.31283], [-121.77043, 37.31294], [-121.77046, 37.31297], [-121.7705, 37.31315]]], [[[-121.77291, 37.31277], [-121.77227, 37.31303], [-121.772, 37.3131], [-121.77172, 37.31314], [-121.77141, 37.31318], [-121.77116, 37.31318], [-121.77068, 37.31313], [-121.77067, 37.31308], [-121.77069, 37.31303], [-121.77075, 37.31301], [-121.77124, 37.31305], [-121.77155, 37.31304], [-121.77186, 37.31299], [-121.77225, 37.31288], [-121.7728, 37.31265], [-121.77284, 37.31266], [-121.77291, 37.31277]]], [[[-121.77537, 37.31301], [-121.77534, 37.31303], [-121.77515, 37.31287], [-121.77488, 37.31272], [-121.77459, 37.3126], [-121.77444, 37.31256], [-121.77412, 37.31252], [-121.77381, 37.31251], [-121.7735, 37.31255], [-121.7732, 37.31263], [-121.77317, 37.31255], [-121.77319, 37.31252], [-121.77324, 37.31249], [-121.7736, 37.31241], [-121.77378, 37.3124], [-121.77414, 37.3124], [-121.77449, 37.31245], [-121.77474, 37.31252], [-121.7749, 37.31259], [-121.7752, 37.31276], [-121.7754, 37.31291], [-121.77541, 37.31297], [-121.77537, 37.31301]]]]} | Open Access 1 | 8906 | Cortona Park | 17666 | 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.315 | Cortona Park | 2004 | Local Park 2 | 4 | |
4945 | 4945 | 4944 | {"type": "Polygon", "coordinates": [[[-121.82496, 37.25694], [-121.82382, 37.25694], [-121.82381, 37.25558], [-121.82382, 37.25555], [-121.82386, 37.25554], [-121.82483, 37.25553], [-121.82487, 37.25555], [-121.82489, 37.25654], [-121.82491, 37.2566], [-121.82496, 37.25666], [-121.82496, 37.25694]]]} | Open Access 1 | 14658 | Coy Park | 17732 | 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.743 | Coy Park | 1992 | Local Park 2 | 4 | |
12510 | 12510 | 12509 | {"type": "Polygon", "coordinates": [[[-121.85504, 37.31493], [-121.85362, 37.31586], [-121.85394, 37.31607], [-121.8543, 37.31623], [-121.85453, 37.31642], [-121.85461, 37.31658], [-121.85444, 37.31664], [-121.85458, 37.31695], [-121.8546, 37.31739], [-121.85467, 37.31745], [-121.85459, 37.31752], [-121.85452, 37.31752], [-121.85442, 37.31764], [-121.8527, 37.31876], [-121.85175, 37.31941], [-121.85185, 37.31915], [-121.85188, 37.31865], [-121.85183, 37.31831], [-121.8516, 37.31773], [-121.85171, 37.31746], [-121.85158, 37.31703], [-121.8514, 37.31667], [-121.85079, 37.31652], [-121.84976, 37.31696], [-121.84901, 37.31766], [-121.84836, 37.31805], [-121.84693, 37.31777], [-121.84644, 37.3174], [-121.84633, 37.31727], [-121.84665, 37.31706], [-121.8465, 37.3166], [-121.84646, 37.3159], [-121.84642, 37.31575], [-121.8461, 37.31501], [-121.8459, 37.3143], [-121.84574, 37.31409], [-121.84536, 37.31386], [-121.84385, 37.31327], [-121.84309, 37.31261], [-121.84276, 37.31197], [-121.8424, 37.31155], [-121.84415, 37.31039], [-121.84419, 37.3105], [-121.84432, 37.31042], [-121.84442, 37.31062], [-121.8444, 37.31099], [-121.84452, 37.31122], [-121.8447, 37.31142], [-121.84459, 37.31149], [-121.84417, 37.31191], [-121.84409, 37.31207], [-121.84407, 37.3122], [-121.84411, 37.31234], [-121.84419, 37.31246], [-121.84436, 37.31257], [-121.84497, 37.31281], [-121.8452, 37.31294], [-121.8453, 37.31303], [-121.84533, 37.31299], [-121.84563, 37.31308], [-121.84574, 37.31317], [-121.8458, 37.31315], [-121.84602, 37.31327], [-121.8461, 37.31328], [-121.8462, 37.31332], [-121.84658, 37.31343], [-121.84692, 37.31356], [-121.84697, 37.31357], [-121.84766, 37.31475], [-121.84764, 37.31497], [-121.84771, 37.31508], [-121.84776, 37.31542], [-121.84775, 37.31559], [-121.84777, 37.31566], [-121.84775, 37.31568], [-121.84776, 37.31575], [-121.84775, 37.31581], [-121.84778, 37.31594], [-121.8479, 37.3161], [-121.84815, 37.31621], [-121.84838, 37.31626], [-121.84864, 37.31629], [-121.84892, 37.31627], [-121.84912, 37.31622], [-121.84939, 37.31605], [-121.84985, 37.31584], [-121.85022, 37.3156], [-121.85106, 37.31535], [-121.85176, 37.3151], [-121.85212, 37.31495], [-121.85244, 37.31494], [-121.85297, 37.31454], [-121.85402, 37.31395], [-121.85504, 37.31493]]]} | Open Access 1 | 28340 | Coyote Creek Park | 17738 | 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 | 65.935 | Coyote Creek Park | 0 | 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 | |
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 | |
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 | |
10602 | 10602 | 10601 | {"type": "MultiPolygon", "coordinates": [[[[-121.84854, 37.33749], [-121.84887, 37.3379], [-121.8491, 37.33822], [-121.84929, 37.33856], [-121.84935, 37.33868], [-121.84938, 37.33879], [-121.84943, 37.33902], [-121.84944, 37.33937], [-121.84938, 37.33971], [-121.84926, 37.34004], [-121.84918, 37.3402], [-121.84898, 37.3405], [-121.84872, 37.34077], [-121.84858, 37.3409], [-121.84842, 37.34101], [-121.84743, 37.3415], [-121.84717, 37.34166], [-121.84693, 37.34183], [-121.84657, 37.34214], [-121.84646, 37.34227], [-121.84626, 37.34255], [-121.84616, 37.3426], [-121.84605, 37.34258], [-121.84574, 37.34232], [-121.84535, 37.34196], [-121.84525, 37.34201], [-121.84372, 37.34042], [-121.84377, 37.34038], [-121.84366, 37.34027], [-121.84406, 37.34001], [-121.84375, 37.33969], [-121.84555, 37.33847], [-121.84561, 37.33847], [-121.84567, 37.33849], [-121.84612, 37.33894], [-121.84625, 37.33898], [-121.84637, 37.33895], [-121.84854, 37.33749]]], [[[-121.84725, 37.33818], [-121.84633, 37.33882], [-121.84629, 37.33883], [-121.84623, 37.33882], [-121.84617, 37.33879], [-121.84582, 37.33842], [-121.84579, 37.33838], [-121.8458, 37.33834], [-121.84582, 37.3383], [-121.84638, 37.3379], [-121.84671, 37.33763], [-121.84725, 37.33818]]]]} | Open Access 1 | 18900 | Emma Prusch Farm Park | 18630 | 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 | 41.775 | Emma Prusch Farm Park | 1983 | Local Park 2 | 4 | |
9593 | 9593 | 9592 | {"type": "Polygon", "coordinates": [[[-121.86656, 37.26253], [-121.86634, 37.26259], [-121.86631, 37.26264], [-121.86612, 37.26268], [-121.86603, 37.26264], [-121.86578, 37.26271], [-121.86579, 37.26276], [-121.86552, 37.26284], [-121.86549, 37.26281], [-121.8655, 37.26279], [-121.8654, 37.26259], [-121.86514, 37.26266], [-121.86515, 37.2627], [-121.86503, 37.26273], [-121.86503, 37.26276], [-121.86487, 37.26281], [-121.86469, 37.26241], [-121.86488, 37.26235], [-121.8649, 37.26233], [-121.86488, 37.26229], [-121.86547, 37.26213], [-121.86548, 37.26206], [-121.86552, 37.26198], [-121.86559, 37.262], [-121.86566, 37.26197], [-121.86566, 37.26231], [-121.86643, 37.26232], [-121.86647, 37.26245], [-121.86656, 37.26253]]]} | Open Access 1 | 16134 | Erikson Park | 18694 | 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.868 | Erikson Park | 1997 | Local Park 2 | 4 | |
7207 | 7207 | 7206 | {"type": "Polygon", "coordinates": [[[-121.77436, 37.31377], [-121.77415, 37.31422], [-121.77351, 37.31402], [-121.77373, 37.31357], [-121.77436, 37.31377]]]} | Open Access 1 | 9025 | Evergreen Village Park | 18768 | 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.806 | Evergreen Village Park | 2004 | Local Park 2 | 4 | |
1232 | 1232 | 1231 | {"type": "MultiPolygon", "coordinates": [[[[-121.76247, 37.30719], [-121.76237, 37.30725], [-121.76225, 37.30735], [-121.76221, 37.30737], [-121.76214, 37.30736], [-121.76213, 37.30711], [-121.76208, 37.30692], [-121.76217, 37.30689], [-121.76213, 37.30674], [-121.76204, 37.30675], [-121.76196, 37.30638], [-121.76204, 37.30636], [-121.762, 37.3062], [-121.76192, 37.30621], [-121.76183, 37.30585], [-121.76192, 37.30582], [-121.76188, 37.30567], [-121.76179, 37.30568], [-121.76168, 37.30523], [-121.76197, 37.3051], [-121.76208, 37.30559], [-121.76204, 37.30563], [-121.76203, 37.30569], [-121.76206, 37.30574], [-121.76214, 37.30577], [-121.76228, 37.30637], [-121.76224, 37.30642], [-121.76223, 37.30647], [-121.76227, 37.30652], [-121.76231, 37.30655], [-121.76247, 37.30719]]], [[[-121.76232, 37.30871], [-121.76223, 37.30854], [-121.76217, 37.30835], [-121.76199, 37.30829], [-121.76201, 37.30822], [-121.76201, 37.30816], [-121.76199, 37.30809], [-121.76194, 37.30803], [-121.76208, 37.30793], [-121.76204, 37.30773], [-121.76208, 37.3075], [-121.76212, 37.30756], [-121.76209, 37.30773], [-121.76209, 37.30788], [-121.76222, 37.30838], [-121.76227, 37.30851], [-121.76236, 37.30865], [-121.76236, 37.30869], [-121.76232, 37.30871]]], [[[-121.76263, 37.3073], [-121.76256, 37.30759], [-121.76243, 37.30762], [-121.7625, 37.30796], [-121.76237, 37.30797], [-121.76232, 37.30794], [-121.76229, 37.30783], [-121.76229, 37.30773], [-121.76232, 37.30763], [-121.76236, 37.30753], [-121.76243, 37.30744], [-121.76252, 37.30736], [-121.76263, 37.3073]]], [[[-121.76283, 37.30873], [-121.76266, 37.30866], [-121.7625, 37.3085], [-121.76244, 37.30841], [-121.76241, 37.30832], [-121.76241, 37.30828], [-121.76243, 37.30824], [-121.76246, 37.30822], [-121.76255, 37.3082], [-121.76263, 37.30853], [-121.76278, 37.30852], [-121.76283, 37.30873]]], [[[-121.76371, 37.31256], [-121.76358, 37.31258], [-121.76361, 37.3127], [-121.76353, 37.31271], [-121.76263, 37.30883], [-121.76275, 37.30888], [-121.76289, 37.30892], [-121.76314, 37.30895], [-121.76314, 37.30904], [-121.76312, 37.30915], [-121.76296, 37.30932], [-121.76302, 37.30961], [-121.76299, 37.30965], [-121.76298, 37.3097], [-121.76301, 37.30974], [-121.76306, 37.30977], [-121.76319, 37.31034], [-121.76316, 37.31038], [-121.76316, 37.31043], [-121.76318, 37.31047], [-121.76323, 37.3105], [-121.76336, 37.31106], [-121.76333, 37.3111], [-121.76333, 37.31116], [-121.76336, 37.3112], [-121.7634, 37.31123], [-121.76353, 37.3118], [-121.7635, 37.31184], [-121.76349, 37.31188], [-121.76352, 37.31193], [-121.76357, 37.31196], [-121.76371, 37.31256]]]]} | Open Access 1 | 8918 | Falls Creek Linear Park | 18837 | 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.266 | Falls Creek Linear Park | 2004 | 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]);