units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
247 rows where ACCESS_TYP = 1 and MNG_AGENCY = 32 sorted by map
This data as json, copyable, CSV (advanced)
DES_TP >30
MNG_AG_TYP 1
- City Agency 227
MNG_AGENCY 1
- San Jose, City of · 227 ✖
ACCESS_TYP 1
- Open Access · 227 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9784 | 9784 | 9783 | {"type": "MultiPolygon", "coordinates": [[[[-121.87628, 37.23286], [-121.87578, 37.23287], [-121.87577, 37.23282], [-121.87321, 37.23281], [-121.87295, 37.23282], [-121.87269, 37.23294], [-121.87242, 37.23296], [-121.87191, 37.23295], [-121.87166, 37.23193], [-121.87209, 37.23197], [-121.87213, 37.23207], [-121.87223, 37.23213], [-121.87396, 37.23229], [-121.87403, 37.23228], [-121.8741, 37.23224], [-121.87414, 37.23219], [-121.87415, 37.23212], [-121.87449, 37.23215], [-121.87471, 37.23222], [-121.87509, 37.23205], [-121.87515, 37.23212], [-121.87526, 37.23215], [-121.87543, 37.23214], [-121.87642, 37.23214], [-121.87645, 37.23216], [-121.87647, 37.2322], [-121.87644, 37.23242], [-121.87639, 37.2326], [-121.87628, 37.23286]]], [[[-121.88411, 37.23228], [-121.8841, 37.23246], [-121.88396, 37.23247], [-121.88403, 37.23275], [-121.88391, 37.23278], [-121.88393, 37.23284], [-121.88365, 37.23288], [-121.88341, 37.23287], [-121.8828, 37.2328], [-121.88279, 37.23278], [-121.88254, 37.23274], [-121.88235, 37.23273], [-121.88202, 37.23279], [-121.88175, 37.23279], [-121.88169, 37.23282], [-121.88057, 37.23286], [-121.88021, 37.23293], [-121.87814, 37.2328], [-121.87794, 37.23275], [-121.87784, 37.23274], [-121.87694, 37.23278], [-121.87672, 37.23274], [-121.87668, 37.2327], [-121.87674, 37.23246], [-121.87678, 37.23222], [-121.87681, 37.23219], [-121.87688, 37.23217], [-121.87731, 37.23223], [-121.87869, 37.23224], [-121.87918, 37.23231], [-121.88066, 37.23232], [-121.88071, 37.2323], [-121.88072, 37.23226], [-121.88411, 37.23228]]]]} | Open Access 1 | 16731 | Golden Oaks | 19367 | 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 | 17.73 | Golden Oaks | 1989 | None 847 | ||
404 | 404 | 403 | {"type": "MultiPolygon", "coordinates": [[[[-121.87633, 37.26877], [-121.87629, 37.26882], [-121.87618, 37.26884], [-121.87574, 37.26885], [-121.87552, 37.26887], [-121.87461, 37.26909], [-121.87453, 37.26908], [-121.87449, 37.26904], [-121.87439, 37.26876], [-121.87434, 37.26866], [-121.87424, 37.26856], [-121.87417, 37.26852], [-121.87404, 37.26847], [-121.87423, 37.26803], [-121.87413, 37.26777], [-121.87434, 37.26772], [-121.87445, 37.26772], [-121.87451, 37.26768], [-121.87452, 37.26763], [-121.87484, 37.26755], [-121.87519, 37.2675], [-121.87526, 37.26756], [-121.87535, 37.26757], [-121.87541, 37.26755], [-121.8755, 37.26747], [-121.87592, 37.26738], [-121.87603, 37.26737], [-121.87607, 37.26738], [-121.87612, 37.26742], [-121.87614, 37.26746], [-121.87633, 37.26877]]], [[[-121.87705, 37.26835], [-121.87652, 37.26841], [-121.87646, 37.2684], [-121.87641, 37.26836], [-121.87625, 37.26729], [-121.87626, 37.26697], [-121.87624, 37.26684], [-121.87658, 37.26676], [-121.87676, 37.26782], [-121.87699, 37.26776], [-121.87705, 37.26835]]]]} | Open Access 1 | 1546 | Thousand Oaks | 26323 | 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.805 | Thousand Oaks | 1985 | None 42 | ||
444 | 444 | 443 | {"type": "MultiPolygon", "coordinates": [[[[-121.88809, 37.23293], [-121.88443, 37.23292], [-121.88436, 37.2328], [-121.88432, 37.23268], [-121.88428, 37.23249], [-121.88427, 37.23234], [-121.88429, 37.23231], [-121.88433, 37.2323], [-121.88805, 37.23232], [-121.88808, 37.23234], [-121.8881, 37.23237], [-121.88809, 37.23293]]], [[[-121.8943, 37.23234], [-121.89418, 37.23251], [-121.89397, 37.23297], [-121.89231, 37.23296], [-121.89231, 37.2329], [-121.89229, 37.23286], [-121.89224, 37.23284], [-121.89219, 37.23282], [-121.89201, 37.23288], [-121.89035, 37.23287], [-121.89019, 37.23282], [-121.8901, 37.23284], [-121.89006, 37.2329], [-121.89007, 37.23301], [-121.89006, 37.23351], [-121.89005, 37.23355], [-121.89, 37.23358], [-121.88853, 37.23362], [-121.88844, 37.23359], [-121.88836, 37.23354], [-121.88832, 37.2335], [-121.88829, 37.23342], [-121.88831, 37.2323], [-121.89136, 37.23232], [-121.89157, 37.23209], [-121.89176, 37.23215], [-121.89197, 37.23217], [-121.89217, 37.23213], [-121.89241, 37.23201], [-121.89241, 37.23233], [-121.8943, 37.23234]]]]} | Open Access 1 | 1383 | T.J. Martin | 26157 | 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 | 17.459 | T.J. Martin | 1984 | None 46 | ||
6121 | 6121 | 6120 | {"type": "MultiPolygon", "coordinates": [[[[-121.89071, 37.33999], [-121.88974, 37.33869], [-121.89053, 37.33832], [-121.89059, 37.33834], [-121.89151, 37.33957], [-121.89148, 37.33962], [-121.89071, 37.33999]], [[-121.891, 37.33929], [-121.891, 37.33928], [-121.89082, 37.33922], [-121.89078, 37.3393], [-121.89069, 37.33928], [-121.89076, 37.33909], [-121.89046, 37.33901], [-121.89038, 37.33919], [-121.89058, 37.33925], [-121.89053, 37.3394], [-121.89057, 37.33942], [-121.89052, 37.33957], [-121.8907, 37.33961], [-121.89068, 37.33968], [-121.89085, 37.33974], [-121.89087, 37.3397], [-121.89106, 37.33974], [-121.89119, 37.33943], [-121.89118, 37.33941], [-121.89097, 37.33936], [-121.891, 37.33929]]], [[[-121.89259, 37.33909], [-121.89183, 37.33945], [-121.89176, 37.33945], [-121.89084, 37.33823], [-121.89084, 37.33818], [-121.89086, 37.33815], [-121.89162, 37.33779], [-121.89259, 37.33909]]]]} | Open Access 1 | 1091 | St. James Park | 25766 | 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.283 | St. James 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 | |
5569 | 5569 | 5568 | {"type": "MultiPolygon", "coordinates": [[[[-121.90397, 37.34203], [-121.90269, 37.34294], [-121.90249, 37.34308], [-121.90226, 37.34254], [-121.90227, 37.34201], [-121.90224, 37.34179], [-121.90229, 37.3414], [-121.90234, 37.34138], [-121.90229, 37.34169], [-121.90264, 37.34146], [-121.90296, 37.34174], [-121.90337, 37.34147], [-121.90397, 37.34203]]], [[[-121.90391, 37.34388], [-121.90321, 37.34435], [-121.903, 37.34414], [-121.90284, 37.34392], [-121.90256, 37.34325], [-121.90293, 37.34299], [-121.90391, 37.34388]]], [[[-121.90512, 37.34306], [-121.90407, 37.34377], [-121.90308, 37.34288], [-121.90411, 37.34215], [-121.90512, 37.34306]]], [[[-121.90518, 37.34118], [-121.90413, 37.34192], [-121.90341, 37.34126], [-121.90339, 37.34122], [-121.9034, 37.34117], [-121.90344, 37.34114], [-121.90364, 37.34109], [-121.90415, 37.34099], [-121.90487, 37.3409], [-121.90518, 37.34118]]], [[[-121.90478, 37.34466], [-121.90413, 37.34511], [-121.9034, 37.34451], [-121.90409, 37.34404], [-121.90478, 37.34466]]], [[[-121.90598, 37.34384], [-121.90494, 37.34455], [-121.90425, 37.34393], [-121.9053, 37.34323], [-121.90598, 37.34384]]], [[[-121.90634, 37.34222], [-121.90528, 37.34296], [-121.90427, 37.34204], [-121.90532, 37.34131], [-121.90634, 37.34222]]], [[[-121.90587, 37.34564], [-121.90522, 37.34609], [-121.90516, 37.34604], [-121.90503, 37.34613], [-121.90482, 37.34598], [-121.90474, 37.34591], [-121.90467, 37.34581], [-121.90456, 37.34558], [-121.90447, 37.34544], [-121.90428, 37.34522], [-121.90492, 37.34478], [-121.90587, 37.34564]]], [[[-121.90612, 37.34396], [-121.90706, 37.34481], [-121.90708, 37.34484], [-121.90705, 37.34488], [-121.90603, 37.34554], [-121.90507, 37.34468], [-121.90612, 37.34396]]], [[[-121.90715, 37.34164], [-121.90652, 37.34209], [-121.90543, 37.34112], [-121.90579, 37.34087], [-121.90583, 37.34087], [-121.90621, 37.34121], [-121.90635, 37.34112], [-121.90668, 37.34142], [-121.90693, 37.34124], [-121.90707, 37.34137], [-121.90695, 37.34146], [-121.90715, 37.34164]]], [[[-121.90801, 37.34242], [-121.90751, 37.34279], [-121.90718, 37.34248], [-121.90703, 37.34257], [-121.9067, 37.34226], [-121.90721, 37.3419], [-121.90755, 37.34221], [-121.90768, 37.34212], [-121.90801, 37.34242]]]]} | Open Access 1 | 29145 | Guadalupe River Park | 19558 | 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 | 31.407 | Guadalupe River Park | 0 | 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 | |
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 | |
8608 | 8608 | 8607 | {"type": "MultiPolygon", "coordinates": [[[[-121.91295, 37.32069], [-121.91197, 37.32074], [-121.91197, 37.32068], [-121.91209, 37.32069], [-121.91213, 37.3206], [-121.91223, 37.3205], [-121.91235, 37.32046], [-121.91247, 37.32044], [-121.9126, 37.32046], [-121.91268, 37.3205], [-121.91275, 37.32056], [-121.91281, 37.32065], [-121.91294, 37.32064], [-121.91295, 37.32069]]], [[[-121.9129, 37.32142], [-121.91239, 37.32141], [-121.91205, 37.32142], [-121.91202, 37.32096], [-121.9129, 37.32092], [-121.9129, 37.32142]]]]} | Open Access 1 | 13701 | O'Connor Park | 22945 | 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.412 | O'Connor Park | 2003 | 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 | ||
8595 | 8595 | 8594 | {"type": "MultiPolygon", "coordinates": [[[[-121.92618, 37.33141], [-121.92528, 37.3321], [-121.92476, 37.33165], [-121.92456, 37.33181], [-121.92442, 37.33181], [-121.92369, 37.33118], [-121.92368, 37.33108], [-121.92405, 37.33081], [-121.92415, 37.33082], [-121.92427, 37.33089], [-121.9246, 37.33088], [-121.92479, 37.33103], [-121.92494, 37.33102], [-121.92533, 37.33071], [-121.92618, 37.33141]]], [[[-121.92624, 37.33214], [-121.92612, 37.33223], [-121.92576, 37.33193], [-121.92588, 37.33184], [-121.92624, 37.33214]]]]} | Open Access 1 | 13672 | Hester Park | 19884 | 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.694 | Hester Park | 1996 | Local Park 2 | 4 | |
206 | 206 | 205 | {"type": "MultiPolygon", "coordinates": [[[[-121.99722, 37.29824], [-121.99724, 37.29876], [-121.99723, 37.29911], [-121.99718, 37.29963], [-121.99712, 37.29992], [-121.997, 37.30027], [-121.9964, 37.30157], [-121.9961, 37.30227], [-121.99595, 37.30272], [-121.99534, 37.30257], [-121.99527, 37.30258], [-121.9952, 37.30263], [-121.99491, 37.30257], [-121.99598, 37.30099], [-121.99615, 37.30072], [-121.99637, 37.30026], [-121.99654, 37.2998], [-121.99664, 37.29932], [-121.99675, 37.29863], [-121.99676, 37.29847], [-121.99683, 37.29818], [-121.99722, 37.29824]]], [[[-121.9971, 37.29508], [-121.99705, 37.29557], [-121.99704, 37.29596], [-121.99705, 37.29647], [-121.99709, 37.29688], [-121.99697, 37.29747], [-121.99635, 37.29738], [-121.99677, 37.29505], [-121.9971, 37.29508]]]]} | Open Access 1 | 559 | Saratoga Creek Park | 25158 | 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 | 10.274 | Saratoga Creek Park | 1982 | Local Park 2 | 4 | |
8197 | 8197 | 8196 | {"type": "Polygon", "coordinates": [[[-121.75759, 37.30772], [-121.75723, 37.3079], [-121.7574, 37.30815], [-121.75736, 37.30818], [-121.7573, 37.30817], [-121.75713, 37.30796], [-121.75708, 37.30783], [-121.75703, 37.30764], [-121.75707, 37.30757], [-121.75706, 37.3075], [-121.75702, 37.30746], [-121.75694, 37.30744], [-121.75688, 37.30733], [-121.75718, 37.30743], [-121.7573, 37.30749], [-121.75744, 37.30758], [-121.75759, 37.30772]]]} | Open Access 1 | 9095 | Pocket Park No. 19 | 23828 | 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.52 | PP No. 19 | 2004 | Local Park 2 | 4 | |
7812 | 7812 | 7811 | {"type": "Polygon", "coordinates": [[[-121.75822, 37.31075], [-121.75822, 37.31063], [-121.75835, 37.31052], [-121.75835, 37.3102], [-121.75832, 37.3101], [-121.75788, 37.30937], [-121.75761, 37.30857], [-121.75794, 37.30839], [-121.7582, 37.30916], [-121.75845, 37.30964], [-121.75856, 37.31004], [-121.75856, 37.31025], [-121.75855, 37.31038], [-121.75849, 37.31059], [-121.75843, 37.31072], [-121.75837, 37.31075], [-121.75822, 37.31075]]]} | Open Access 1 | 8990 | Pocket Park No.1 | 23840 | 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.827 | PP No.1 | 2004 | Local Park 2 | 4 | |
1427 | 1427 | 1426 | {"type": "Polygon", "coordinates": [[[-121.75911, 37.31065], [-121.75911, 37.31077], [-121.75894, 37.31093], [-121.75867, 37.31081], [-121.75863, 37.31078], [-121.7587, 37.31058], [-121.75902, 37.3106], [-121.75911, 37.31065]]]} | Open Access 1 | 9084 | Pocket Park No. 18 | 23827 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.285 | PP No. 18 | 2004 | Local Park 2 | 4 | |
8580 | 8580 | 8579 | {"type": "Polygon", "coordinates": [[[-121.76046, 37.24318], [-121.76012, 37.24392], [-121.75974, 37.24411], [-121.75913, 37.24423], [-121.75839, 37.24428], [-121.75777, 37.24352], [-121.75822, 37.24308], [-121.75858, 37.24246], [-121.75914, 37.24231], [-121.75924, 37.24253], [-121.75931, 37.24262], [-121.75943, 37.24273], [-121.75959, 37.24281], [-121.75981, 37.24289], [-121.76005, 37.24291], [-121.76023, 37.24287], [-121.76046, 37.24318]]]} | Open Access 1 | 13628 | Basking Ridge Park | 15853 | 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.042 | Basking Ridge Park | 2005 | Local Park 2 | 4 | |
7822 | 7822 | 7821 | {"type": "Polygon", "coordinates": [[[-121.76143, 37.31313], [-121.76078, 37.31323], [-121.76083, 37.31318], [-121.7608, 37.31299], [-121.76085, 37.31282], [-121.76091, 37.31279], [-121.76098, 37.31279], [-121.76143, 37.31313]]]} | Open Access 1 | 9062 | Pocket Park No. 16 | 23825 | 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.382 | PP No. 16 | 1994 | Local Park 2 | 4 | |
7530 | 7530 | 7529 | {"type": "Polygon", "coordinates": [[[-121.76202, 37.3228], [-121.76181, 37.32286], [-121.76161, 37.32298], [-121.76142, 37.32279], [-121.76175, 37.32258], [-121.76187, 37.32271], [-121.76202, 37.3228]]]} | Open Access 1 | 9183 | Pocket Park No. 8 | 23838 | 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.273 | PP No. 8 | 0 | Local Park 2 | 4 | |
8637 | 8637 | 8636 | {"type": "Polygon", "coordinates": [[[-121.76254, 37.23459], [-121.76238, 37.23464], [-121.76214, 37.23468], [-121.76176, 37.23467], [-121.76139, 37.2346], [-121.76113, 37.23452], [-121.76089, 37.23442], [-121.76079, 37.23435], [-121.76074, 37.23429], [-121.76058, 37.23396], [-121.76026, 37.23346], [-121.76025, 37.23341], [-121.76027, 37.23335], [-121.76055, 37.23309], [-121.7607, 37.23289], [-121.76079, 37.2328], [-121.76216, 37.23362], [-121.76225, 37.23369], [-121.76233, 37.23382], [-121.7625, 37.23451], [-121.76254, 37.23459]]]} | Open Access 1 | 15659 | Metcalf Park | 11189 | 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/Metcalf-Park-155 | Santa Clara 19 | 6.208 | Metcalf Park | 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 |
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]);