units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
253 rows where MNG_AGENCY = 32 sorted by SUID_NMA 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 |
15679 | 15679 | 15678 | {"type": "Polygon", "coordinates": [[[-121.85663, 37.3456], [-121.85604, 37.34604], [-121.85601, 37.3461], [-121.85601, 37.34615], [-121.85607, 37.34627], [-121.85226, 37.34926], [-121.85206, 37.34901], [-121.85125, 37.34807], [-121.85017, 37.34696], [-121.85017, 37.34693], [-121.85019, 37.3469], [-121.85087, 37.34649], [-121.85104, 37.34645], [-121.85138, 37.34648], [-121.85155, 37.34647], [-121.85172, 37.34642], [-121.8519, 37.34631], [-121.85203, 37.34645], [-121.85208, 37.34643], [-121.85223, 37.34658], [-121.85228, 37.34656], [-121.8524, 37.34668], [-121.85248, 37.34669], [-121.85249, 37.34675], [-121.85254, 37.34679], [-121.8526, 37.34681], [-121.85264, 37.3468], [-121.85274, 37.34691], [-121.85282, 37.34687], [-121.85296, 37.34701], [-121.85302, 37.34702], [-121.85302, 37.34707], [-121.85305, 37.34711], [-121.85313, 37.34714], [-121.85312, 37.34721], [-121.85326, 37.34734], [-121.85346, 37.34721], [-121.85348, 37.34722], [-121.8538, 37.34703], [-121.85374, 37.34695], [-121.85377, 37.34692], [-121.85364, 37.34678], [-121.85372, 37.34673], [-121.85387, 37.34688], [-121.85508, 37.34613], [-121.8551, 37.34614], [-121.85528, 37.34603], [-121.85528, 37.34602], [-121.85468, 37.3454], [-121.85448, 37.34551], [-121.85444, 37.34546], [-121.85461, 37.34534], [-121.85417, 37.34488], [-121.85398, 37.34499], [-121.85399, 37.34488], [-121.85421, 37.34474], [-121.85383, 37.34435], [-121.85364, 37.34446], [-121.85358, 37.3444], [-121.85376, 37.34429], [-121.85373, 37.34425], [-121.85381, 37.34419], [-121.85356, 37.34394], [-121.85362, 37.3439], [-121.85362, 37.34389], [-121.85337, 37.34364], [-121.85335, 37.34364], [-121.85321, 37.3435], [-121.85323, 37.34348], [-121.85313, 37.34338], [-121.85427, 37.34267], [-121.85501, 37.3434], [-121.85521, 37.34357], [-121.85486, 37.34379], [-121.85486, 37.34381], [-121.85663, 37.3456]]]} | Restricted Access 2 | 13737 | Rancho del Pueblo Golf Course | 33035 | 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 | 30.551 | Rancho del Pueblo GC | 2001 | Local Recreation Area 3 | 4 | |
8946 | 8946 | 8945 | {"type": "Polygon", "coordinates": [[[-121.80491, 37.3407], [-121.80352, 37.34138], [-121.80049, 37.34294], [-121.79836, 37.34402], [-121.79822, 37.34393], [-121.798, 37.34404], [-121.79769, 37.34375], [-121.79714, 37.34404], [-121.79506, 37.34263], [-121.79851, 37.34136], [-121.79448, 37.33693], [-121.80043, 37.33576], [-121.80489, 37.34064], [-121.80487, 37.34066], [-121.80491, 37.3407]]]} | Restricted Access 2 | 9698 | Pleasant Hills Golf Course | 33029 | 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 | 113.282 | Pleasant Hills GC | 1972 | Local Recreation Area 3 | 4 | |
15673 | 15673 | 15672 | {"type": "MultiPolygon", "coordinates": [[[[-121.89541, 37.37943], [-121.89427, 37.37942], [-121.89269, 37.38197], [-121.8899, 37.37991], [-121.88744, 37.38246], [-121.88659, 37.38185], [-121.88541, 37.38076], [-121.88537, 37.38074], [-121.88537, 37.38072], [-121.88526, 37.38062], [-121.88521, 37.38053], [-121.88522, 37.38051], [-121.88453, 37.37987], [-121.88737, 37.37696], [-121.88571, 37.37551], [-121.88156, 37.37982], [-121.88142, 37.37967], [-121.88134, 37.37955], [-121.88131, 37.37944], [-121.88131, 37.37918], [-121.88142, 37.3789], [-121.88145, 37.37874], [-121.88145, 37.37859], [-121.88141, 37.37841], [-121.88133, 37.37826], [-121.88121, 37.37811], [-121.8811, 37.37802], [-121.88083, 37.37784], [-121.88082, 37.37781], [-121.88084, 37.37775], [-121.88072, 37.37768], [-121.8857, 37.3726], [-121.88699, 37.37171], [-121.88727, 37.37166], [-121.88755, 37.37144], [-121.8885, 37.37244], [-121.88866, 37.37235], [-121.88949, 37.37327], [-121.8897, 37.37398], [-121.88948, 37.37413], [-121.88976, 37.37467], [-121.89069, 37.37628], [-121.89054, 37.3768], [-121.89386, 37.37757], [-121.89432, 37.37694], [-121.8944, 37.37697], [-121.89454, 37.37694], [-121.89449, 37.37698], [-121.89447, 37.37703], [-121.89448, 37.37707], [-121.89453, 37.37712], [-121.8946, 37.37714], [-121.89468, 37.37713], [-121.89481, 37.37704], [-121.89517, 37.37697], [-121.89523, 37.37698], [-121.89525, 37.37701], [-121.89534, 37.37741], [-121.8954, 37.37782], [-121.89544, 37.3783], [-121.89545, 37.37859], [-121.89545, 37.37896], [-121.89541, 37.37943]]], [[[-121.89521, 37.37684], [-121.89516, 37.37689], [-121.89478, 37.37696], [-121.89463, 37.37692], [-121.8952, 37.37682], [-121.89521, 37.37684]]]]} | Restricted Access 2 | 9687 | San Jose Municipal Golf Course | 33028 | 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 | 169.542 | San Jose Municipal GC | 2000 | 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 | |
3782 | 3782 | 3781 | {"type": "Polygon", "coordinates": [[[-121.82966, 37.34595], [-121.82886, 37.34644], [-121.82778, 37.34531], [-121.82759, 37.34513], [-121.82758, 37.34508], [-121.82831, 37.34458], [-121.8284, 37.34466], [-121.82778, 37.34509], [-121.82856, 37.34592], [-121.82921, 37.3455], [-121.82966, 37.34595]]]} | Open Access 1 | 8685 | Sylvia Cassell Park | 31405 | 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/Sylvia-Cassell-Park-61 | Santa Clara 19 | 2.04 | Sylvia Cassell Park | 1991 | 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 | |||
6451 | 6451 | 6450 | {"type": "Polygon", "coordinates": [[[-121.87834, 37.35953], [-121.87826, 37.35958], [-121.87795, 37.35929], [-121.87664, 37.36016], [-121.87692, 37.36045], [-121.87668, 37.36061], [-121.87601, 37.36039], [-121.87538, 37.36015], [-121.8747, 37.35988], [-121.87397, 37.35955], [-121.87427, 37.35876], [-121.87405, 37.35604], [-121.87435, 37.35406], [-121.87456, 37.35424], [-121.87443, 37.35524], [-121.87498, 37.35558], [-121.87596, 37.35539], [-121.87636, 37.35567], [-121.87687, 37.35616], [-121.87698, 37.35629], [-121.87713, 37.35652], [-121.87749, 37.35687], [-121.877, 37.35719], [-121.8764, 37.35761], [-121.87668, 37.35791], [-121.87834, 37.35953]]]} | Open Access 1 | 1981 | Watson Park | 30905 | 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/Facilities/Facility/Details/126 | Santa Clara 19 | 34.437 | Watson Park | 1976 | Local Park 2 | 4 |
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 | |
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 | |
8611 | 8611 | 8610 | {"type": "Polygon", "coordinates": [[[-121.88516, 37.32837], [-121.88488, 37.32851], [-121.88432, 37.32772], [-121.88436, 37.3277], [-121.88516, 37.32837]]]} | Open Access 1 | 13722 | Parque de los Pobladores | 28077 | 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.411 | Parque de los Pobladores | 1940 | None 720 | ||
14019 | 14019 | 14018 | {"type": "MultiPolygon", "coordinates": [[[[-121.89295, 37.31787], [-121.89295, 37.31797], [-121.89085, 37.31787], [-121.89085, 37.31778], [-121.89295, 37.31787]]], [[[-121.89597, 37.31798], [-121.89596, 37.31807], [-121.89363, 37.31799], [-121.89363, 37.31789], [-121.89597, 37.31798]]], [[[-121.89742, 37.31803], [-121.89731, 37.31856], [-121.8972, 37.31855], [-121.89721, 37.31839], [-121.89724, 37.31838], [-121.89727, 37.31802], [-121.89742, 37.31803]]]]} | Open Access 1 | 38010 | Fuller Park | 28012 | 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.195 | Fuller 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 | |||
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 |
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 |
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]);