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 rowid descending
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
- Open Access 174
- Restricted Access 1
MNG_AG_TYP 1
- City Agency 175
MNG_AGENCY 1
- San Jose, City of · 175 ✖
DES_TP 1
- Local Park · 175 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17067 | 17067 | 17066 | {"type": "Polygon", "coordinates": [[[-121.76791, 37.22188], [-121.7678, 37.22199], [-121.76752, 37.22184], [-121.76754, 37.22178], [-121.76753, 37.22174], [-121.76718, 37.22154], [-121.76716, 37.22149], [-121.7669, 37.22132], [-121.76693, 37.22126], [-121.76691, 37.2212], [-121.76669, 37.22107], [-121.76666, 37.22107], [-121.76662, 37.22102], [-121.76656, 37.221], [-121.76657, 37.22092], [-121.7663, 37.22076], [-121.7664, 37.22065], [-121.76639, 37.2206], [-121.76615, 37.22045], [-121.76608, 37.22047], [-121.76604, 37.22044], [-121.766, 37.22042], [-121.76602, 37.22032], [-121.76575, 37.22015], [-121.76575, 37.22011], [-121.76572, 37.22006], [-121.76555, 37.21996], [-121.76557, 37.21992], [-121.76558, 37.21988], [-121.76554, 37.21981], [-121.76547, 37.21978], [-121.7655, 37.21972], [-121.76505, 37.21929], [-121.76511, 37.21924], [-121.76512, 37.21917], [-121.7651, 37.21912], [-121.76504, 37.21908], [-121.76508, 37.21899], [-121.76499, 37.2189], [-121.76516, 37.21858], [-121.7651, 37.21845], [-121.76515, 37.21837], [-121.76515, 37.21833], [-121.76513, 37.21829], [-121.76531, 37.21817], [-121.76532, 37.21813], [-121.7652, 37.218], [-121.76492, 37.21776], [-121.76511, 37.21764], [-121.76526, 37.21758], [-121.76544, 37.21754], [-121.7656, 37.21754], [-121.76578, 37.21757], [-121.76662, 37.21783], [-121.76665, 37.21786], [-121.76666, 37.2179], [-121.76663, 37.21795], [-121.76646, 37.2181], [-121.76624, 37.21789], [-121.76568, 37.21816], [-121.76524, 37.21843], [-121.76521, 37.21848], [-121.76521, 37.21852], [-121.76537, 37.21871], [-121.76527, 37.21878], [-121.76516, 37.21883], [-121.76513, 37.21888], [-121.76514, 37.21894], [-121.76518, 37.21899], [-121.76524, 37.21901], [-121.76524, 37.21916], [-121.76537, 37.21936], [-121.7656, 37.21952], [-121.76558, 37.2196], [-121.76562, 37.21966], [-121.76572, 37.21969], [-121.76568, 37.21978], [-121.76593, 37.21995], [-121.76587, 37.22002], [-121.76587, 37.22007], [-121.76613, 37.22022], [-121.76617, 37.22028], [-121.76656, 37.22048], [-121.76652, 37.22054], [-121.76653, 37.2206], [-121.76673, 37.22071], [-121.76668, 37.22075], [-121.76666, 37.22079], [-121.76666, 37.22084], [-121.76669, 37.22089], [-121.76676, 37.22092], [-121.7668, 37.22098], [-121.76706, 37.22114], [-121.76703, 37.22119], [-121.76704, 37.22125], [-121.76727, 37.22139], [-121.76732, 37.22146], [-121.76742, 37.22148], [-121.76741, 37.22151], [-121.76769, 37.22166], [-121.76767, 37.2217], [-121.76768, 37.22174], [-121.76791, 37.22188]]]} | Open Access 1 | 38003 | Pocket Park No. 22 | 23832 | 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.747 | PP No. 22 | 0 | Local Park 2 | 4 | |
17064 | 17064 | 17063 | {"type": "Polygon", "coordinates": [[[-121.76669, 37.22574], [-121.76663, 37.22596], [-121.76591, 37.22583], [-121.76587, 37.22585], [-121.76581, 37.22583], [-121.76573, 37.22582], [-121.76565, 37.22586], [-121.7653, 37.2258], [-121.76528, 37.22575], [-121.76496, 37.22569], [-121.76491, 37.22572], [-121.76483, 37.22569], [-121.76475, 37.22571], [-121.76399, 37.22558], [-121.76395, 37.22554], [-121.76389, 37.22553], [-121.76383, 37.22553], [-121.76377, 37.22556], [-121.76341, 37.22549], [-121.76336, 37.2254], [-121.76308, 37.22534], [-121.76301, 37.22529], [-121.76293, 37.22528], [-121.76287, 37.2253], [-121.76288, 37.22524], [-121.76284, 37.22519], [-121.7625, 37.22512], [-121.76196, 37.22487], [-121.76201, 37.22481], [-121.76254, 37.22507], [-121.76289, 37.22513], [-121.76293, 37.22519], [-121.76298, 37.22521], [-121.76305, 37.22522], [-121.76311, 37.2252], [-121.76347, 37.22527], [-121.76346, 37.22534], [-121.76349, 37.22538], [-121.76378, 37.22543], [-121.76383, 37.22542], [-121.76391, 37.22546], [-121.764, 37.22546], [-121.76438, 37.22554], [-121.76438, 37.2256], [-121.7647, 37.22566], [-121.76481, 37.2256], [-121.76486, 37.22562], [-121.76494, 37.22562], [-121.76496, 37.22566], [-121.76532, 37.22572], [-121.76535, 37.22577], [-121.76564, 37.22582], [-121.76579, 37.22574], [-121.76585, 37.22575], [-121.76591, 37.22574], [-121.76593, 37.22576], [-121.76628, 37.22582], [-121.76633, 37.22568], [-121.76669, 37.22574]]]} | Open Access 1 | 13735 | Pocket Park No. 23 | 23833 | 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.085 | PP No. 23 | 0 | Local Park 2 | 4 | |
17063 | 17063 | 17062 | {"type": "Polygon", "coordinates": [[[-121.76351, 37.30514], [-121.76338, 37.30509], [-121.76282, 37.30517], [-121.76274, 37.30486], [-121.76297, 37.30491], [-121.76349, 37.30511], [-121.76351, 37.30514]]]} | Open Access 1 | 13733 | Pocket Park No. 20 | 23830 | 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.259 | PP No. 20 | 1984 | Local Park 2 | 4 | |
17062 | 17062 | 17061 | {"type": "MultiPolygon", "coordinates": [[[[-121.76611, 37.32191], [-121.76591, 37.32205], [-121.76582, 37.32206], [-121.76254, 37.32081], [-121.7625, 37.32079], [-121.76248, 37.32075], [-121.76251, 37.32068], [-121.76255, 37.32069], [-121.76252, 37.32071], [-121.76252, 37.32075], [-121.76264, 37.3208], [-121.76275, 37.32081], [-121.76562, 37.32189], [-121.76566, 37.32193], [-121.76575, 37.32197], [-121.76579, 37.32197], [-121.76581, 37.32196], [-121.76581, 37.32191], [-121.76595, 37.32167], [-121.76592, 37.32153], [-121.76602, 37.32154], [-121.76611, 37.32191]]], [[[-121.76598, 37.32139], [-121.76582, 37.32138], [-121.76585, 37.32123], [-121.76577, 37.32089], [-121.7656, 37.32091], [-121.76564, 37.32082], [-121.76572, 37.32075], [-121.76571, 37.32068], [-121.76566, 37.32065], [-121.76561, 37.32064], [-121.76556, 37.32066], [-121.76552, 37.3207], [-121.76566, 37.32037], [-121.76558, 37.3201], [-121.76539, 37.32005], [-121.76543, 37.32002], [-121.76552, 37.31999], [-121.76554, 37.31993], [-121.76513, 37.3182], [-121.76416, 37.31835], [-121.76396, 37.31844], [-121.76385, 37.31855], [-121.7638, 37.31837], [-121.76521, 37.31816], [-121.76598, 37.32139]]]]} | Open Access 1 | 9194 | Pocket Park No. 9 | 23839 | 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.933 | PP No. 9 | 0 | Local Park 2 | 4 | |
16403 | 16403 | 16402 | {"type": "Polygon", "coordinates": [[[-121.7745, 37.32534], [-121.77408, 37.32537], [-121.77333, 37.32544], [-121.77339, 37.32537], [-121.77346, 37.32538], [-121.77353, 37.32535], [-121.77356, 37.32537], [-121.7743, 37.3253], [-121.77434, 37.32527], [-121.77441, 37.3253], [-121.77448, 37.32529], [-121.7745, 37.32534]]]} | Open Access 1 | 9115 | Pocket Park No. 21 | 23831 | 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.155 | PP No. 21 | 1994 | Local Park 2 | 4 | |
16326 | 16326 | 16325 | {"type": "MultiPolygon", "coordinates": [[[[-121.75865, 37.30849], [-121.75876, 37.3085], [-121.75884, 37.30857], [-121.75887, 37.30866], [-121.75882, 37.30875], [-121.75875, 37.30879], [-121.75842, 37.30886], [-121.75835, 37.30885], [-121.75829, 37.30881], [-121.75824, 37.30865], [-121.75827, 37.30859], [-121.75832, 37.30856], [-121.75865, 37.30849]]], [[[-121.76001, 37.3085], [-121.75964, 37.30868], [-121.75949, 37.30873], [-121.75899, 37.30867], [-121.75896, 37.30853], [-121.7595, 37.30831], [-121.75999, 37.30837], [-121.75999, 37.30843], [-121.76001, 37.3085]]], [[[-121.76171, 37.30805], [-121.76176, 37.30805], [-121.76182, 37.30807], [-121.76187, 37.30812], [-121.76189, 37.30817], [-121.76189, 37.30823], [-121.76187, 37.30827], [-121.76176, 37.30834], [-121.76032, 37.30856], [-121.76026, 37.30855], [-121.76019, 37.30853], [-121.76014, 37.3085], [-121.76011, 37.30844], [-121.76011, 37.30839], [-121.76013, 37.30834], [-121.76017, 37.3083], [-121.76024, 37.30827], [-121.76171, 37.30805]]]]} | Open Access 1 | 9105 | Pocket Park No. 2 | 23829 | 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.347 | PP No. 2 | 2004 | Local Park 2 | 4 | |
14873 | 14873 | 14872 | {"type": "Polygon", "coordinates": [[[-121.89511, 37.33384], [-121.89479, 37.334], [-121.89467, 37.33357], [-121.89511, 37.33384], [-121.89511, 37.33384]]]} | Open Access 1 | 45394 | Almaden Entrance Triangle Park | 27910 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/prns | Santa Clara 19 | 0.191 | Almaden Entrance Triangle Park | 0 | Local Park 2 | 4 |
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 | |
14418 | 14418 | 14417 | {"type": "MultiPolygon", "coordinates": [[[[-121.91174, 37.34327], [-121.91173, 37.34329], [-121.91145, 37.34349], [-121.91121, 37.34329], [-121.9111, 37.34338], [-121.91132, 37.34358], [-121.91074, 37.34398], [-121.9107, 37.34399], [-121.91066, 37.34397], [-121.90988, 37.34327], [-121.90986, 37.34322], [-121.90989, 37.34316], [-121.91078, 37.34262], [-121.91089, 37.34259], [-121.91099, 37.34263], [-121.91139, 37.34299], [-121.91174, 37.34327]]], [[[-121.9128, 37.34423], [-121.91279, 37.34426], [-121.91179, 37.34497], [-121.91088, 37.34414], [-121.91188, 37.34344], [-121.91191, 37.34343], [-121.91195, 37.34344], [-121.91237, 37.34383], [-121.91235, 37.34386], [-121.91245, 37.34395], [-121.91249, 37.34393], [-121.91279, 37.34421], [-121.9128, 37.34423]]], [[[-121.91161, 37.34509], [-121.9106, 37.3458], [-121.90973, 37.34504], [-121.90971, 37.34499], [-121.90974, 37.34494], [-121.9107, 37.34427], [-121.91161, 37.34509]]], [[[-121.91392, 37.34524], [-121.91289, 37.34598], [-121.91195, 37.34511], [-121.91294, 37.34441], [-121.91298, 37.3444], [-121.91301, 37.34441], [-121.91392, 37.34524]]], [[[-121.91176, 37.34524], [-121.91214, 37.34558], [-121.91215, 37.34564], [-121.91118, 37.34634], [-121.91075, 37.34595], [-121.91176, 37.34524]]], [[[-121.91129, 37.34644], [-121.91226, 37.34575], [-121.91234, 37.34577], [-121.91268, 37.34608], [-121.91266, 37.34614], [-121.91172, 37.3468], [-121.91167, 37.34679], [-121.91129, 37.34644]]], [[[-121.91044, 37.34596], [-121.90896, 37.34698], [-121.90804, 37.34612], [-121.90943, 37.34516], [-121.90949, 37.34515], [-121.90956, 37.34517], [-121.91044, 37.34596]]], [[[-121.91468, 37.34594], [-121.9143, 37.34621], [-121.91463, 37.34652], [-121.91399, 37.34697], [-121.91305, 37.34612], [-121.91408, 37.34539], [-121.91468, 37.34594]]], [[[-121.90582, 37.34668], [-121.90548, 37.34645], [-121.90684, 37.34536], [-121.90691, 37.34534], [-121.90745, 37.34584], [-121.90747, 37.34587], [-121.90744, 37.34591], [-121.90686, 37.34631], [-121.90679, 37.34639], [-121.90677, 37.34646], [-121.90677, 37.34656], [-121.9068, 37.34662], [-121.90713, 37.34695], [-121.90714, 37.34704], [-121.90718, 37.3471], [-121.90728, 37.34715], [-121.90738, 37.34714], [-121.90743, 37.34711], [-121.90747, 37.34706], [-121.90748, 37.34698], [-121.90745, 37.34693], [-121.9074, 37.3469], [-121.90726, 37.34686], [-121.90697, 37.34659], [-121.90694, 37.34653], [-121.90694, 37.34647], [-121.90699, 37.3464], [-121.90759, 37.346], [-121.90765, 37.34602], [-121.9088, 37.34709], [-121.90784, 37.34775], [-121.90762, 37.34757], [-121.90739, 37.34742], [-121.90714, 37.34728], [-121.90612, 37.34685], [-121.90582, 37.34668]]], [[[-121.91378, 37.34708], [-121.91366, 37.34716], [-121.91368, 37.34719], [-121.91303, 37.34764], [-121.913, 37.34762], [-121.91279, 37.34775], [-121.91274, 37.34776], [-121.9127, 37.34774], [-121.91189, 37.347], [-121.91188, 37.34696], [-121.91287, 37.34625], [-121.91378, 37.34708]]], [[[-121.91572, 37.34687], [-121.91546, 37.34704], [-121.9156, 37.34739], [-121.91536, 37.3477], [-121.91537, 37.34772], [-121.91506, 37.34794], [-121.9142, 37.34716], [-121.91421, 37.34714], [-121.91483, 37.34674], [-121.9151, 37.34654], [-121.91518, 37.34651], [-121.91527, 37.34652], [-121.91534, 37.34656], [-121.91537, 37.34654], [-121.91572, 37.34687]]], [[[-121.91153, 37.34696], [-121.90933, 37.34848], [-121.90929, 37.34848], [-121.90925, 37.34846], [-121.90893, 37.34814], [-121.90892, 37.3481], [-121.90894, 37.34806], [-121.90959, 37.34762], [-121.90949, 37.34752], [-121.90879, 37.34797], [-121.90873, 37.34795], [-121.90841, 37.34765], [-121.90842, 37.34762], [-121.90844, 37.34759], [-121.9106, 37.34611], [-121.91153, 37.34696]]], [[[-121.90885, 37.34879], [-121.90815, 37.34805], [-121.90799, 37.3479], [-121.90819, 37.34776], [-121.90827, 37.34776], [-121.90896, 37.3484], [-121.90909, 37.34855], [-121.90911, 37.3486], [-121.90885, 37.34879]]], [[[-121.91487, 37.34807], [-121.91384, 37.34878], [-121.91299, 37.34803], [-121.91298, 37.34799], [-121.91301, 37.34794], [-121.91399, 37.34727], [-121.91487, 37.34807]]], [[[-121.90953, 37.34914], [-121.90929, 37.34926], [-121.90919, 37.34916], [-121.90878, 37.34909], [-121.90926, 37.34876], [-121.90953, 37.34914]]], [[[-121.90982, 37.34953], [-121.90963, 37.34963], [-121.90942, 37.34941], [-121.90964, 37.34929], [-121.90982, 37.34953]]], [[[-121.91215, 37.34824], [-121.91182, 37.34846], [-121.91137, 37.34806], [-121.91125, 37.34816], [-121.91168, 37.34856], [-121.9114, 37.34875], [-121.91096, 37.34835], [-121.9107, 37.34853], [-121.9107, 37.34854], [-121.91114, 37.34895], [-121.91103, 37.34903], [-121.91057, 37.34862], [-121.91026, 37.34883], [-121.91026, 37.34884], [-121.91073, 37.34926], [-121.91013, 37.34969], [-121.9094, 37.34868], [-121.91169, 37.34711], [-121.91252, 37.34788], [-121.91253, 37.34793], [-121.9125, 37.34798], [-121.91215, 37.34822], [-121.91215, 37.34824]]], [[[-121.91442, 37.3496], [-121.91388, 37.34997], [-121.91358, 37.3497], [-121.91324, 37.34994], [-121.91295, 37.34967], [-121.91378, 37.3491], [-121.91381, 37.34909], [-121.91387, 37.3491], [-121.91442, 37.3496]]], [[[-121.91545, 37.35025], [-121.91399, 37.34893], [-121.91501, 37.34824], [-121.91509, 37.34826], [-121.91528, 37.34843], [-121.91539, 37.34891], [-121.91548, 37.34935], [-121.91553, 37.35006], [-121.91545, 37.35025]]]]} | Open Access 1 | 44528 | Guadalupe River Park and Gardens | 19559 | 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 | 66.55 | Guadalupe River Park and Gardens | 0 | Local Park 2 | 4 | |
14199 | 14199 | 14198 | {"type": "Polygon", "coordinates": [[[-121.80274, 37.30716], [-121.80239, 37.30728], [-121.80198, 37.30736], [-121.80174, 37.30745], [-121.80173, 37.30741], [-121.8018, 37.3073], [-121.80176, 37.30725], [-121.80189, 37.30719], [-121.80194, 37.30712], [-121.80193, 37.30707], [-121.80181, 37.30689], [-121.80212, 37.30675], [-121.80218, 37.30659], [-121.80224, 37.3065], [-121.80199, 37.30552], [-121.80308, 37.30536], [-121.80312, 37.30539], [-121.8035, 37.30682], [-121.80348, 37.30687], [-121.80342, 37.30691], [-121.80274, 37.30716]]]} | Open Access 1 | 44050 | Brigadoon Park | 16387 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 5.43 | Brigadoon Park | 0 | Local Park 2 | 4 | |
14030 | 14030 | 14029 | {"type": "Polygon", "coordinates": [[[-121.96308, 37.29872], [-121.96265, 37.29819], [-121.96239, 37.29789], [-121.96265, 37.2979], [-121.96266, 37.29797], [-121.9628, 37.29824], [-121.96308, 37.29872]]]} | Open Access 1 | 38028 | Gleason Park | 19311 | 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.215 | Gleason Park | 0 | Local Park 2 | 4 | |
14029 | 14029 | 14028 | {"type": "Polygon", "coordinates": [[[-121.88207, 37.25467], [-121.88187, 37.25473], [-121.88159, 37.25404], [-121.88169, 37.254], [-121.88176, 37.25392], [-121.88207, 37.25467]]]} | Open Access 1 | 38025 | Russo Park | 24747 | 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 | Russo Park | 0 | Local Park 2 | 4 | |
14028 | 14028 | 14027 | {"type": "Polygon", "coordinates": [[[-121.89024, 37.36141], [-121.88965, 37.36147], [-121.88895, 37.36154], [-121.89005, 37.36072], [-121.89015, 37.36081], [-121.89024, 37.36141]]]} | Open Access 1 | 38024 | Luna Park | 21595 | 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.178 | Luna Park | 0 | Local Park 2 | 4 | |
14027 | 14027 | 14026 | {"type": "Polygon", "coordinates": [[[-121.93192, 37.40428], [-121.93187, 37.40434], [-121.93178, 37.40435], [-121.92938, 37.40376], [-121.92932, 37.40372], [-121.92931, 37.40366], [-121.92942, 37.4035], [-121.92955, 37.40337], [-121.92971, 37.40326], [-121.9299, 37.40318], [-121.93015, 37.40311], [-121.93042, 37.40307], [-121.93068, 37.40308], [-121.93095, 37.40313], [-121.93119, 37.40321], [-121.93131, 37.40327], [-121.93152, 37.4034], [-121.9317, 37.40356], [-121.93182, 37.40372], [-121.93189, 37.40387], [-121.93193, 37.40412], [-121.93192, 37.40428]]]} | Open Access 1 | 38023 | River Oaks Park | 24414 | 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.994 | River Oaks Park | 0 | Local Park 2 | 4 | |
14026 | 14026 | 14025 | {"type": "Polygon", "coordinates": [[[-121.89165, 37.39019], [-121.89118, 37.39055], [-121.8907, 37.39015], [-121.89062, 37.39011], [-121.89063, 37.39005], [-121.89058, 37.39004], [-121.89058, 37.39001], [-121.89066, 37.38996], [-121.8907, 37.38986], [-121.891, 37.38967], [-121.89106, 37.38966], [-121.8911, 37.38967], [-121.89163, 37.39012], [-121.89165, 37.39015], [-121.89165, 37.39019]]]} | Open Access 1 | 38022 | Gran Paradiso Park | 19416 | 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.245 | Gran Paradiso Park | 0 | Local Park 2 | 4 | |
14021 | 14021 | 14020 | {"type": "Polygon", "coordinates": [[[-121.92579, 37.34618], [-121.92523, 37.34688], [-121.92464, 37.34658], [-121.92459, 37.34652], [-121.92451, 37.3465], [-121.92532, 37.34595], [-121.92579, 37.34618]]]} | Open Access 1 | 38012 | Newhall Park | 22725 | 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.428 | Newhall Park | 0 | Local Park 2 | 4 | |
14020 | 14020 | 14019 | {"type": "Polygon", "coordinates": [[[-121.91633, 37.30724], [-121.91633, 37.30735], [-121.91628, 37.30751], [-121.91606, 37.30781], [-121.91582, 37.30782], [-121.91582, 37.30733], [-121.91601, 37.30733], [-121.91602, 37.3072], [-121.91633, 37.30718], [-121.91633, 37.30724]]]} | Open Access 1 | 38011 | St. Elizabeth Park | 25765 | 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.581 | St. Elizabeth Park | 0 | Local Park 2 | 4 | |
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 | |
14018 | 14018 | 14017 | {"type": "Polygon", "coordinates": [[[-121.86189, 37.28614], [-121.86177, 37.28619], [-121.8615, 37.28635], [-121.86099, 37.28584], [-121.86112, 37.28576], [-121.86125, 37.28585], [-121.8614, 37.28593], [-121.86153, 37.28599], [-121.86178, 37.28605], [-121.86189, 37.28614]]]} | Open Access 1 | 38009 | Tuscany Hills Overlook Park | 26600 | 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.482 | Tuscany Hills Overlook Park | 0 | Local Park 2 | 4 | |
13065 | 13065 | 13064 | {"type": "Polygon", "coordinates": [[[-121.77292, 37.304], [-121.7721, 37.30412], [-121.77199, 37.30358], [-121.77225, 37.30356], [-121.77279, 37.30349], [-121.77279, 37.30353], [-121.77283, 37.3036], [-121.77292, 37.304]]]} | Open Access 1 | 34937 | Falls Creek Park | 18838 | 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.053 | Falls Creek Park | 0 | 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]);