units_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 UNIT_ID descending
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL
DES_TP >30
ACCESS_TYP 2
- Open Access 247
- Restricted Access 6
MNG_AG_TYP 1
- City Agency · 253 ✖
MNG_AGENCY 1
- San Jose, City of · 253 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
7642 | 7642 | 7641 | {"type": "Polygon", "coordinates": [[[-121.91965, 37.40115], [-121.91878, 37.40193], [-121.91857, 37.40145], [-121.91833, 37.40099], [-121.91804, 37.40054], [-121.91838, 37.40024], [-121.9184, 37.40032], [-121.91845, 37.40039], [-121.91922, 37.40091], [-121.91923, 37.40098], [-121.91927, 37.40103], [-121.91937, 37.40106], [-121.91947, 37.40102], [-121.91965, 37.40115]]]} | Open Access 1 | 48967 | Iris Chang Park | 33665 | 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.sanjoseca.gov/Home/Components/News/News/402/5103 | Santa Clara 19 | 2.664 | Iris Chang Park | 2019 | Local Park 2 | 4 |
3977 | 3977 | 3976 | {"type": "Polygon", "coordinates": [[[-121.85453, 37.34889], [-121.85442, 37.34894], [-121.85423, 37.34868], [-121.85434, 37.34863], [-121.85453, 37.34889]]]} | Open Access 1 | 48844 | San Antonio Tot Lot | 33564 | 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.sanjoseca.gov/Home/Components/FacilityDirectory/FacilityDirectory/2945/37 | Santa Clara 19 | 0.09 | San Antonio Tot Lot | 0 | Local Recreation Area 3 | 4 |
7788 | 7788 | 7787 | {"type": "Polygon", "coordinates": [[[-121.79392, 37.23948], [-121.79391, 37.24008], [-121.79354, 37.23998], [-121.79354, 37.23956], [-121.79379, 37.23954], [-121.79392, 37.23948]]]} | Open Access 1 | 47665 | Miyuki Dog Park | 31406 | 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.44 | Miyuki Dog Park | 0 | Local Park 2 | 4 | |
7787 | 7787 | 7786 | {"type": "Polygon", "coordinates": [[[-121.84487, 37.36184], [-121.84462, 37.362], [-121.8445, 37.36188], [-121.84451, 37.36186], [-121.84448, 37.36183], [-121.84446, 37.36184], [-121.84431, 37.36167], [-121.84456, 37.36152], [-121.84463, 37.36159], [-121.84462, 37.36161], [-121.84469, 37.36168], [-121.84471, 37.36167], [-121.84473, 37.3617], [-121.84472, 37.36172], [-121.84475, 37.36174], [-121.84477, 37.36174], [-121.84487, 37.36184]]]} | Open Access 1 | 47664 | Jackson Madden Park | 31404 | 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/Facilities/Facility/Details/187 | Santa Clara 19 | 0.311 | Jackson Madden Park | 0 | Local Park 2 | 4 |
7768 | 7768 | 7767 | {"type": "MultiPolygon", "coordinates": [[[[-121.91337, 37.21541], [-121.91338, 37.21573], [-121.9133, 37.21598], [-121.91283, 37.21682], [-121.91283, 37.21688], [-121.91264, 37.21704], [-121.91146, 37.21738], [-121.90988, 37.21769], [-121.90972, 37.21775], [-121.90935, 37.21795], [-121.9092, 37.21805], [-121.90907, 37.21818], [-121.90898, 37.21835], [-121.90896, 37.21847], [-121.90898, 37.2186], [-121.90906, 37.21877], [-121.90945, 37.21929], [-121.90958, 37.21953], [-121.90962, 37.21968], [-121.90963, 37.21981], [-121.9096, 37.21994], [-121.90954, 37.22007], [-121.90939, 37.22022], [-121.90915, 37.22038], [-121.9089, 37.22058], [-121.90879, 37.22068], [-121.90869, 37.22086], [-121.90861, 37.22116], [-121.90855, 37.22132], [-121.90845, 37.22147], [-121.90836, 37.22158], [-121.90828, 37.22164], [-121.90818, 37.22167], [-121.90742, 37.22181], [-121.90727, 37.22185], [-121.90707, 37.22197], [-121.90694, 37.22213], [-121.9059, 37.22399], [-121.90585, 37.22411], [-121.90583, 37.22424], [-121.90582, 37.22448], [-121.90585, 37.22464], [-121.90594, 37.22479], [-121.90618, 37.22508], [-121.90627, 37.22525], [-121.9061, 37.22548], [-121.90528, 37.22593], [-121.90453, 37.22627], [-121.90415, 37.22638], [-121.90407, 37.22636], [-121.90405, 37.22635], [-121.90398, 37.22619], [-121.90466, 37.22602], [-121.90536, 37.22565], [-121.90585, 37.22538], [-121.90604, 37.22522], [-121.90553, 37.22437], [-121.90571, 37.22391], [-121.90632, 37.22303], [-121.9067, 37.22208], [-121.90757, 37.22161], [-121.90795, 37.22168], [-121.90833, 37.22138], [-121.90835, 37.22089], [-121.90907, 37.22031], [-121.90929, 37.22022], [-121.90937, 37.21976], [-121.90935, 37.21926], [-121.90876, 37.21865], [-121.909, 37.21809], [-121.90978, 37.21752], [-121.91034, 37.21739], [-121.91117, 37.21728], [-121.91184, 37.21704], [-121.91219, 37.21698], [-121.91254, 37.21679], [-121.91282, 37.21654], [-121.91283, 37.21644], [-121.91298, 37.2163], [-121.9131, 37.21558], [-121.91301, 37.2153], [-121.91282, 37.2151], [-121.91245, 37.21453], [-121.9122, 37.21392], [-121.91196, 37.21364], [-121.91069, 37.2135], [-121.90989, 37.21358], [-121.9092, 37.21339], [-121.90897, 37.21268], [-121.90866, 37.21232], [-121.90677, 37.2109], [-121.9061, 37.21129], [-121.90478, 37.21127], [-121.90385, 37.21062], [-121.90349, 37.20986], [-121.90221, 37.2094], [-121.90166, 37.20902], [-121.9015, 37.20793], [-121.9001, 37.20744], [-121.89927, 37.20682], [-121.89887, 37.2068], [-121.89907, 37.20665], [-121.89937, 37.20666], [-121.90016, 37.20728], [-121.90167, 37.20782], [-121.90187, 37.20885], [-121.90237, 37.20926], [-121.90366, 37.20973], [-121.90406, 37.21051], [-121.90488, 37.2111], [-121.90598, 37.21111], [-121.90676, 37.21066], [-121.90786, 37.21151], [-121.90885, 37.21217], [-121.90914, 37.21254], [-121.90936, 37.21322], [-121.90988, 37.21339], [-121.91069, 37.21331], [-121.91168, 37.21341], [-121.91202, 37.21346], [-121.91215, 37.21359], [-121.91217, 37.21355], [-121.91233, 37.21362], [-121.91261, 37.21437], [-121.91282, 37.21463], [-121.91282, 37.2147], [-121.91293, 37.21478], [-121.91337, 37.21541]]], [[[-121.90434, 37.22877], [-121.90427, 37.22967], [-121.90399, 37.23037], [-121.90361, 37.23118], [-121.9034, 37.23133], [-121.903, 37.23149], [-121.90293, 37.23154], [-121.90288, 37.2316], [-121.90284, 37.23167], [-121.90247, 37.23206], [-121.90274, 37.23206], [-121.90244, 37.23221], [-121.90228, 37.23238], [-121.90199, 37.23246], [-121.90193, 37.23246], [-121.90181, 37.23258], [-121.90175, 37.23271], [-121.90145, 37.23298], [-121.90117, 37.23312], [-121.90061, 37.23332], [-121.89995, 37.23334], [-121.8996, 37.23363], [-121.89954, 37.23364], [-121.89906, 37.23292], [-121.89868, 37.23329], [-121.89862, 37.23324], [-121.89848, 37.23318], [-121.89819, 37.23314], [-121.8981, 37.23313], [-121.8977, 37.23324], [-121.89745, 37.23336], [-121.89727, 37.23352], [-121.89655, 37.23425], [-121.89588, 37.23481], [-121.89611, 37.23508], [-121.89399, 37.23616], [-121.89279, 37.23567], [-121.89162, 37.23626], [-121.89169, 37.23796], [-121.89026, 37.23961], [-121.88867, 37.23781], [-121.88855, 37.23792], [-121.88694, 37.23855], [-121.88682, 37.23805], [-121.88683, 37.23801], [-121.88721, 37.2379], [-121.88743, 37.2378], [-121.88829, 37.23734], [-121.88855, 37.23717], [-121.88878, 37.23697], [-121.88913, 37.23652], [-121.88928, 37.23634], [-121.88966, 37.236], [-121.88993, 37.23578], [-121.89016, 37.23563], [-121.89082, 37.23523], [-121.89207, 37.2345], [-121.89246, 37.23433], [-121.89322, 37.23409], [-121.89351, 37.23395], [-121.8939, 37.23371], [-121.89399, 37.23354], [-121.89424, 37.23322], [-121.89444, 37.23268], [-121.89467, 37.23234], [-121.89496, 37.23234], [-121.89496, 37.23239], [-121.89498, 37.23243], [-121.89504, 37.23247], [-121.8951, 37.23248], [-121.89591, 37.23249], [-121.89624, 37.23247], [-121.89643, 37.23243], [-121.89663, 37.23237], [-121.89681, 37.23229], [-121.89699, 37.23217], [-121.89703, 37.23216], [-121.89707, 37.23217], [-121.89718, 37.23225], [-121.89735, 37.23233], [-121.89759, 37.2324], [-121.89776, 37.23242], [-121.8979, 37.23242], [-121.89836, 37.23236], [-121.89857, 37.23234], [-121.89965, 37.23238], [-121.89986, 37.23237], [-121.90023, 37.23232], [-121.90057, 37.23223], [-121.90089, 37.23209], [-121.90121, 37.23189], [-121.90141, 37.23172], [-121.90164, 37.23146], [-121.90212, 37.23057], [-121.90235, 37.23023], [-121.90274, 37.22974], [-121.90284, 37.22956], [-121.90294, 37.22935], [-121.90303, 37.22892], [-121.90303, 37.2286], [-121.903, 37.22844], [-121.9027, 37.2274], [-121.90249, 37.22673], [-121.90316, 37.22625], [-121.90328, 37.22624], [-121.90336, 37.22628], [-121.90345, 37.22642], [-121.90356, 37.22669], [-121.9036, 37.22683], [-121.90358, 37.22749], [-121.90365, 37.22778], [-121.90374, 37.22778], [-121.90391, 37.22802], [-121.90401, 37.22851], [-121.90416, 37.22861], [-121.90434, 37.22877]]], [[[-121.88664, 37.23864], [-121.88642, 37.23872], [-121.88642, 37.23875], [-121.88623, 37.23882], [-121.88622, 37.23881], [-121.88605, 37.23887], [-121.88604, 37.23889], [-121.88582, 37.23898], [-121.88558, 37.23914], [-121.88569, 37.23945], [-121.88604, 37.24032], [-121.88343, 37.24172], [-121.88313, 37.24139], [-121.88231, 37.24182], [-121.88174, 37.24115], [-121.88165, 37.24123], [-121.88245, 37.24218], [-121.8805, 37.24322], [-121.88041, 37.24323], [-121.87886, 37.24438], [-121.87548, 37.24514], [-121.87551, 37.24536], [-121.87505, 37.24548], [-121.87496, 37.24525], [-121.87495, 37.24506], [-121.875, 37.24426], [-121.87512, 37.24341], [-121.87574, 37.2434], [-121.87692, 37.24332], [-121.87786, 37.24282], [-121.87904, 37.24232], [-121.87937, 37.24214], [-121.87967, 37.24193], [-121.88046, 37.24121], [-121.88073, 37.24103], [-121.88096, 37.2409], [-121.88179, 37.24049], [-121.88207, 37.24037], [-121.88342, 37.23991], [-121.88373, 37.23977], [-121.88403, 37.23961], [-121.8843, 37.23942], [-121.88458, 37.23917], [-121.88479, 37.23894], [-121.88504, 37.23861], [-121.88516, 37.23849], [-121.88541, 37.2383], [-121.88565, 37.23818], [-121.88606, 37.23807], [-121.88634, 37.23803], [-121.88646, 37.23805], [-121.88652, 37.2381], [-121.88664, 37.23864]]]]} | Open Access 1 | 47650 | Guadalupe Creek Parkchain | 31394 | 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 | 150.151 | Guadalupe Creek Parkchain | 1998 | None 644 | ||
14629 | 14629 | 14628 | {"type": "MultiPolygon", "coordinates": [[[[-121.82904, 37.20107], [-121.82877, 37.2012], [-121.82751, 37.20023], [-121.82682, 37.19987], [-121.82557, 37.19944], [-121.82524, 37.19927], [-121.82507, 37.19909], [-121.825, 37.19897], [-121.82495, 37.19878], [-121.82471, 37.19836], [-121.82465, 37.19815], [-121.82467, 37.19785], [-121.82498, 37.19687], [-121.82499, 37.19673], [-121.82496, 37.19662], [-121.82386, 37.19564], [-121.82358, 37.19548], [-121.82337, 37.19529], [-121.82317, 37.19495], [-121.82309, 37.19441], [-121.82296, 37.19408], [-121.82277, 37.19374], [-121.82226, 37.19327], [-121.82207, 37.19305], [-121.82174, 37.19289], [-121.82159, 37.19272], [-121.82138, 37.19261], [-121.82116, 37.19232], [-121.82071, 37.19225], [-121.82044, 37.1921], [-121.82001, 37.19168], [-121.81997, 37.19159], [-121.81989, 37.19128], [-121.81949, 37.19081], [-121.81966, 37.19073], [-121.82003, 37.19121], [-121.82009, 37.19144], [-121.82017, 37.19162], [-121.82053, 37.19205], [-121.82075, 37.19218], [-121.82125, 37.19225], [-121.8215, 37.19256], [-121.82172, 37.19268], [-121.82192, 37.19284], [-121.82209, 37.19291], [-121.82221, 37.19299], [-121.82235, 37.19317], [-121.82245, 37.19325], [-121.82258, 37.19334], [-121.82269, 37.19344], [-121.8228, 37.1935], [-121.82291, 37.19361], [-121.823, 37.19373], [-121.82307, 37.19386], [-121.82321, 37.19427], [-121.82326, 37.19436], [-121.82345, 37.19503], [-121.82354, 37.19517], [-121.82367, 37.19528], [-121.8241, 37.19549], [-121.8242, 37.19559], [-121.82477, 37.19604], [-121.82509, 37.19633], [-121.82522, 37.19655], [-121.82526, 37.19665], [-121.82529, 37.1969], [-121.82504, 37.19775], [-121.82499, 37.19822], [-121.82517, 37.19879], [-121.82523, 37.19892], [-121.82533, 37.19907], [-121.82545, 37.19917], [-121.82616, 37.19946], [-121.82675, 37.19964], [-121.82709, 37.19978], [-121.82793, 37.20026], [-121.8289, 37.20093], [-121.82904, 37.20107]]], [[[-121.83038, 37.20352], [-121.82933, 37.20334], [-121.82928, 37.20256], [-121.82924, 37.20229], [-121.82914, 37.20204], [-121.82907, 37.20192], [-121.8289, 37.2017], [-121.8288, 37.20161], [-121.82946, 37.20132], [-121.82968, 37.20117], [-121.83004, 37.20166], [-121.83016, 37.20192], [-121.83024, 37.20218], [-121.83029, 37.20245], [-121.83038, 37.20352]]], [[[-121.83272, 37.2123], [-121.83266, 37.2119], [-121.83266, 37.21175], [-121.83267, 37.21156], [-121.83276, 37.21106], [-121.83275, 37.21081], [-121.83269, 37.21065], [-121.8325, 37.21031], [-121.83238, 37.21003], [-121.83228, 37.20975], [-121.83218, 37.20929], [-121.83187, 37.20838], [-121.8318, 37.20806], [-121.83173, 37.20763], [-121.83168, 37.20747], [-121.83158, 37.20726], [-121.83143, 37.20703], [-121.83101, 37.20658], [-121.83005, 37.20539], [-121.82978, 37.20516], [-121.82957, 37.20491], [-121.82944, 37.20464], [-121.82941, 37.20453], [-121.82937, 37.20377], [-121.83041, 37.20395], [-121.83043, 37.20444], [-121.83051, 37.20457], [-121.83057, 37.20464], [-121.83092, 37.20491], [-121.83183, 37.20605], [-121.83232, 37.20659], [-121.8325, 37.20687], [-121.83263, 37.20714], [-121.83276, 37.20753], [-121.83286, 37.20809], [-121.83316, 37.20905], [-121.83329, 37.20959], [-121.83342, 37.20993], [-121.83361, 37.21028], [-121.83369, 37.21045], [-121.83375, 37.21069], [-121.83378, 37.21092], [-121.83378, 37.21108], [-121.83373, 37.21147], [-121.83374, 37.21174], [-121.83377, 37.21197], [-121.83376, 37.212], [-121.83371, 37.21203], [-121.83272, 37.2123]]]]} | Open Access 1 | 47646 | Alamitos Creek Parkchain | 31390 | 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 | 35.751 | Alamitos Creek Parkchain | None 1247 | |||
14931 | 14931 | 14930 | {"type": "Polygon", "coordinates": [[[-121.75976, 37.39602], [-121.75912, 37.398], [-121.75627, 37.39875], [-121.75572, 37.39901], [-121.75555, 37.39944], [-121.75639, 37.39982], [-121.75699, 37.39995], [-121.75731, 37.40053], [-121.75628, 37.40129], [-121.75528, 37.40133], [-121.75477, 37.40095], [-121.75403, 37.40063], [-121.75349, 37.40049], [-121.75232, 37.40038], [-121.75106, 37.40035], [-121.75078, 37.40043], [-121.75015, 37.40085], [-121.7496, 37.4008], [-121.74921, 37.40099], [-121.74866, 37.39979], [-121.74922, 37.39947], [-121.75051, 37.39905], [-121.75076, 37.39886], [-121.75117, 37.39869], [-121.75202, 37.39839], [-121.75266, 37.39804], [-121.75364, 37.3974], [-121.75448, 37.39709], [-121.75583, 37.39645], [-121.75631, 37.39557], [-121.75722, 37.3954], [-121.75846, 37.39567], [-121.75976, 37.39602]]]} | Restricted Access 2 | 45517 | Cherry Flat Reservoir | 28352 | 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 | 71.469 | Cherry Flat Reservoir | 0 | Local Recreation Area 3 | 4 | |
4314 | 4314 | 4313 | {"type": "Polygon", "coordinates": [[[-121.89634, 37.32873], [-121.89614, 37.32883], [-121.89583, 37.32829], [-121.8955, 37.32782], [-121.89562, 37.32786], [-121.89574, 37.32795], [-121.89634, 37.32873]]]} | Open Access 1 | 45398 | Delmas Dog Park | 27904 | 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/Facilities/Facility/Details/Dog-Parks-140 | Santa Clara 19 | 0.426 | Delmas Dog Park | 0 | Local Park 2 | 4 |
14874 | 14874 | 14873 | {"type": "Polygon", "coordinates": [[[-121.76653, 37.32462], [-121.76622, 37.32463], [-121.7658, 37.32469], [-121.76565, 37.3247], [-121.76481, 37.32488], [-121.76421, 37.32506], [-121.76403, 37.32513], [-121.76329, 37.32556], [-121.76262, 37.32607], [-121.76252, 37.32646], [-121.76246, 37.32656], [-121.76205, 37.32662], [-121.76177, 37.32663], [-121.76169, 37.32659], [-121.76162, 37.32652], [-121.76383, 37.32484], [-121.7644, 37.32461], [-121.76459, 37.32456], [-121.76462, 37.32455], [-121.76462, 37.32452], [-121.7647, 37.32452], [-121.7648, 37.32446], [-121.76566, 37.32419], [-121.76574, 37.32414], [-121.7658, 37.32405], [-121.76587, 37.32406], [-121.76638, 37.32397], [-121.76653, 37.32462]]]} | Open Access 1 | 45397 | Quimby Creek Parkchain | 27900 | 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.092 | Quimby Creek Parkchain | None 1281 | |||
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 |
4313 | 4313 | 4312 | {"type": "Polygon", "coordinates": [[[-121.84378, 37.30875], [-121.84355, 37.30896], [-121.84336, 37.30881], [-121.84333, 37.30882], [-121.84321, 37.30875], [-121.84336, 37.3085], [-121.84378, 37.30875]]]} | Open Access 1 | 45393 | La Raggione Tot Lot | 27912 | 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/Facilities?clear=True | Santa Clara 19 | 0.304 | La Raggione Tot Lot | 0 | Local Recreation Area 3 | 4 |
3838 | 3838 | 3837 | {"type": "Polygon", "coordinates": [[[-121.84501, 37.30972], [-121.84412, 37.31027], [-121.84415, 37.31039], [-121.8424, 37.31155], [-121.84228, 37.31143], [-121.84087, 37.31233], [-121.83873, 37.31012], [-121.83834, 37.31021], [-121.83826, 37.31018], [-121.83818, 37.30998], [-121.8405, 37.30851], [-121.84104, 37.30881], [-121.84173, 37.30836], [-121.84174, 37.30816], [-121.84192, 37.30821], [-121.84201, 37.30813], [-121.84264, 37.30823], [-121.84315, 37.30838], [-121.84336, 37.3085], [-121.8433, 37.30859], [-121.84322, 37.30876], [-121.84333, 37.30881], [-121.84336, 37.30881], [-121.84355, 37.30895], [-121.84378, 37.30875], [-121.84442, 37.30913], [-121.84501, 37.30972]]]} | Open Access 1 | 45392 | Tully Community Ballfields | 27907 | 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/Facilities/Facility/Details/Tully-Community-Ballfields-97 | Santa Clara 19 | 36.437 | Tully Community Ballfields | None 324 | ||
3837 | 3837 | 3836 | {"type": "Polygon", "coordinates": [[[-121.81525, 37.30826], [-121.81558, 37.30859], [-121.81559, 37.30863], [-121.81499, 37.30902], [-121.81463, 37.30865], [-121.81525, 37.30826]]]} | Open Access 1 | 45391 | West Evergreen Park | 27916 | 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/Facilities?clear=True | Santa Clara 19 | 0.9 | West Evergreen Park | 0 | Local Park 2 | 4 |
3836 | 3836 | 3835 | {"type": "Polygon", "coordinates": [[[-121.79521, 37.26427], [-121.79424, 37.26476], [-121.79239, 37.26413], [-121.79167, 37.2636], [-121.7931, 37.26341], [-121.79449, 37.26319], [-121.79503, 37.26315], [-121.79521, 37.26427]]]} | Open Access 1 | 45387 | Shady Oaks Park | 27915 | 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/Facilities/Facility/Details/Shady-Oaks-Park-157 | Santa Clara 19 | 8.29 | Shady Oaks Park | 0 | Local Park 2 | 4 |
14724 | 14724 | 14723 | {"type": "Polygon", "coordinates": [[[-121.87966, 37.30969], [-121.87878, 37.3098], [-121.87879, 37.30936], [-121.87874, 37.30887], [-121.87949, 37.30878], [-121.87966, 37.30969]]]} | Open Access 1 | 45074 | Roberto Antonio Balermino Park | 28091 | 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.812 | Roberto Antonio Balermino Park | 0 | Local Park 2 | 4 | |
14689 | 14689 | 14688 | {"type": "Polygon", "coordinates": [[[-121.90419, 37.32113], [-121.90292, 37.32118], [-121.90293, 37.32096], [-121.90295, 37.32087], [-121.9032, 37.32057], [-121.90365, 37.32053], [-121.90363, 37.32012], [-121.90411, 37.32011], [-121.90419, 37.32113]]]} | Open Access 1 | 45038 | Del Monte Park Phase I | 27992 | 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.218 | Del Monte Park Phase I | None 1258 | |||
4091 | 4091 | 4090 | {"type": "Polygon", "coordinates": [[[-121.82987, 37.29701], [-121.82983, 37.29708], [-121.82949, 37.29702], [-121.82873, 37.29701], [-121.82859, 37.29678], [-121.82926, 37.29636], [-121.82917, 37.29644], [-121.82911, 37.29655], [-121.82913, 37.29667], [-121.82917, 37.29674], [-121.82927, 37.29681], [-121.82953, 37.29688], [-121.82987, 37.29701]]]} | Open Access 1 | 44532 | Lone Bluff Park | 21436 | 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.778 | Lone Bluff Park | 0 | Local Park 2 | 4 | |
15722 | 15722 | 15721 | {"type": "MultiPolygon", "coordinates": [[[[-121.84169, 37.30182], [-121.83911, 37.30357], [-121.83871, 37.30382], [-121.83833, 37.30344], [-121.83831, 37.30296], [-121.83806, 37.30292], [-121.83779, 37.30277], [-121.83752, 37.30249], [-121.8374, 37.30207], [-121.83741, 37.30196], [-121.83729, 37.30113], [-121.83699, 37.30077], [-121.83589, 37.30148], [-121.8358, 37.30142], [-121.83548, 37.30163], [-121.83398, 37.30095], [-121.83407, 37.3009], [-121.83406, 37.30088], [-121.83211, 37.30009], [-121.83217, 37.30005], [-121.83217, 37.30003], [-121.83175, 37.29986], [-121.83029, 37.30027], [-121.82981, 37.29962], [-121.83097, 37.29885], [-121.83009, 37.29781], [-121.82955, 37.29738], [-121.82757, 37.2974], [-121.82788, 37.29723], [-121.82859, 37.29678], [-121.82873, 37.29701], [-121.82949, 37.29702], [-121.82982, 37.29708], [-121.82987, 37.29701], [-121.831, 37.29751], [-121.83177, 37.29795], [-121.83211, 37.29811], [-121.83197, 37.2982], [-121.83198, 37.29822], [-121.83336, 37.29877], [-121.83366, 37.29886], [-121.83382, 37.2989], [-121.83418, 37.29893], [-121.83467, 37.29894], [-121.83491, 37.299], [-121.83521, 37.2991], [-121.83609, 37.29952], [-121.83624, 37.29942], [-121.83658, 37.29959], [-121.83682, 37.29974], [-121.83696, 37.29986], [-121.83735, 37.30023], [-121.83742, 37.30032], [-121.83746, 37.30042], [-121.83759, 37.30085], [-121.83777, 37.30117], [-121.83788, 37.3013], [-121.8381, 37.30152], [-121.83813, 37.30151], [-121.8391, 37.30241], [-121.83971, 37.30198], [-121.84035, 37.30263], [-121.84164, 37.30177], [-121.84169, 37.30182]]], [[[-121.83787, 37.30585], [-121.83766, 37.30598], [-121.83727, 37.30607], [-121.83719, 37.30598], [-121.83702, 37.30585], [-121.83307, 37.30386], [-121.83283, 37.30376], [-121.83243, 37.3037], [-121.83224, 37.30364], [-121.83208, 37.30356], [-121.83177, 37.30334], [-121.83156, 37.30325], [-121.83128, 37.30319], [-121.83005, 37.30302], [-121.82979, 37.30301], [-121.82887, 37.30303], [-121.82859, 37.30301], [-121.82821, 37.30293], [-121.82785, 37.30279], [-121.82768, 37.30269], [-121.82739, 37.30247], [-121.8255, 37.30049], [-121.82542, 37.30008], [-121.82497, 37.29973], [-121.82488, 37.29961], [-121.82492, 37.29956], [-121.82525, 37.29935], [-121.82542, 37.29929], [-121.82676, 37.29993], [-121.82758, 37.3003], [-121.82775, 37.30036], [-121.82799, 37.30031], [-121.82818, 37.30014], [-121.82834, 37.30005], [-121.82847, 37.30002], [-121.82872, 37.3001], [-121.82878, 37.30022], [-121.82893, 37.30039], [-121.82935, 37.30013], [-121.83059, 37.30049], [-121.83103, 37.30066], [-121.83113, 37.30065], [-121.83152, 37.30055], [-121.83175, 37.30063], [-121.83194, 37.30079], [-121.83211, 37.30086], [-121.83237, 37.30103], [-121.83241, 37.30107], [-121.83274, 37.30124], [-121.83508, 37.3018], [-121.83518, 37.30185], [-121.8348, 37.30213], [-121.8348, 37.30214], [-121.83521, 37.30222], [-121.83573, 37.30238], [-121.83589, 37.30256], [-121.83608, 37.30264], [-121.83651, 37.30272], [-121.83668, 37.30284], [-121.83694, 37.3031], [-121.83725, 37.30361], [-121.83737, 37.30374], [-121.83755, 37.3038], [-121.83762, 37.30397], [-121.83759, 37.30421], [-121.83773, 37.30436], [-121.83783, 37.30461], [-121.83791, 37.30488], [-121.83789, 37.3051], [-121.83794, 37.30533], [-121.83793, 37.30565], [-121.83787, 37.30585]]]]} | Restricted Access 2 | 44531 | Los Lagos Golf Course | 21519 | 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 | 122.795 | Los Lagos GC | 0 | Local Recreation Area 3 | 4 | |
14419 | 14419 | 14418 | {"type": "Polygon", "coordinates": [[[-121.86861, 37.32876], [-121.86824, 37.32896], [-121.8683, 37.3293], [-121.86784, 37.32956], [-121.86752, 37.32953], [-121.86745, 37.32955], [-121.86733, 37.3296], [-121.86707, 37.32975], [-121.86612, 37.33033], [-121.86517, 37.33096], [-121.8641, 37.33176], [-121.86176, 37.3332], [-121.86128, 37.33275], [-121.86155, 37.33211], [-121.86466, 37.32991], [-121.86398, 37.32817], [-121.86392, 37.32808], [-121.86373, 37.3281], [-121.86348, 37.32808], [-121.86339, 37.32806], [-121.86324, 37.32814], [-121.86244, 37.32808], [-121.8616, 37.32794], [-121.86136, 37.32787], [-121.86175, 37.32769], [-121.8618, 37.3277], [-121.86212, 37.32756], [-121.86324, 37.32704], [-121.86358, 37.32687], [-121.86417, 37.32662], [-121.86475, 37.32634], [-121.8647, 37.32633], [-121.86558, 37.32598], [-121.86562, 37.32619], [-121.86614, 37.32637], [-121.86631, 37.32641], [-121.86749, 37.32758], [-121.86836, 37.32846], [-121.86861, 37.32876]]]} | Open Access 1 | 44529 | Coyote Creek Parkchain | 17739 | 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 | 48.973 | Coyote Creek Parkchain | 0 | None 1226 |
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]);