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 ACRES 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9977 | 9977 | 9976 | {"type": "Polygon", "coordinates": [[[-121.86436, 37.32449], [-121.86277, 37.32544], [-121.86265, 37.32553], [-121.86248, 37.32557], [-121.86223, 37.32554], [-121.86213, 37.32557], [-121.86205, 37.32555], [-121.86197, 37.32556], [-121.86167, 37.32565], [-121.86132, 37.32587], [-121.86139, 37.32606], [-121.86101, 37.32624], [-121.861, 37.32635], [-121.86093, 37.32652], [-121.861, 37.32662], [-121.86057, 37.3271], [-121.8609, 37.32761], [-121.86112, 37.32772], [-121.85953, 37.32881], [-121.85297, 37.32221], [-121.85254, 37.32176], [-121.85209, 37.32147], [-121.85155, 37.32086], [-121.85073, 37.32013], [-121.8527, 37.31876], [-121.85442, 37.31764], [-121.85452, 37.31752], [-121.85459, 37.31753], [-121.85456, 37.31756], [-121.85453, 37.3178], [-121.85598, 37.31917], [-121.85403, 37.31875], [-121.85358, 37.31878], [-121.85292, 37.3191], [-121.85295, 37.3193], [-121.85337, 37.31946], [-121.85374, 37.31951], [-121.85506, 37.31936], [-121.85577, 37.31971], [-121.85625, 37.31956], [-121.85664, 37.31937], [-121.85688, 37.31921], [-121.85731, 37.31911], [-121.85852, 37.3184], [-121.86171, 37.32174], [-121.86436, 37.32449]], [[-121.85952, 37.32512], [-121.85951, 37.32513], [-121.85957, 37.32527], [-121.85957, 37.32523], [-121.85952, 37.32512]]]} | Open Access 1 | 17167 | Kelley Park | 20576 | 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 | 164.316 | Kelley Park | 1962 | 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 | |
12510 | 12510 | 12509 | {"type": "Polygon", "coordinates": [[[-121.85504, 37.31493], [-121.85362, 37.31586], [-121.85394, 37.31607], [-121.8543, 37.31623], [-121.85453, 37.31642], [-121.85461, 37.31658], [-121.85444, 37.31664], [-121.85458, 37.31695], [-121.8546, 37.31739], [-121.85467, 37.31745], [-121.85459, 37.31752], [-121.85452, 37.31752], [-121.85442, 37.31764], [-121.8527, 37.31876], [-121.85175, 37.31941], [-121.85185, 37.31915], [-121.85188, 37.31865], [-121.85183, 37.31831], [-121.8516, 37.31773], [-121.85171, 37.31746], [-121.85158, 37.31703], [-121.8514, 37.31667], [-121.85079, 37.31652], [-121.84976, 37.31696], [-121.84901, 37.31766], [-121.84836, 37.31805], [-121.84693, 37.31777], [-121.84644, 37.3174], [-121.84633, 37.31727], [-121.84665, 37.31706], [-121.8465, 37.3166], [-121.84646, 37.3159], [-121.84642, 37.31575], [-121.8461, 37.31501], [-121.8459, 37.3143], [-121.84574, 37.31409], [-121.84536, 37.31386], [-121.84385, 37.31327], [-121.84309, 37.31261], [-121.84276, 37.31197], [-121.8424, 37.31155], [-121.84415, 37.31039], [-121.84419, 37.3105], [-121.84432, 37.31042], [-121.84442, 37.31062], [-121.8444, 37.31099], [-121.84452, 37.31122], [-121.8447, 37.31142], [-121.84459, 37.31149], [-121.84417, 37.31191], [-121.84409, 37.31207], [-121.84407, 37.3122], [-121.84411, 37.31234], [-121.84419, 37.31246], [-121.84436, 37.31257], [-121.84497, 37.31281], [-121.8452, 37.31294], [-121.8453, 37.31303], [-121.84533, 37.31299], [-121.84563, 37.31308], [-121.84574, 37.31317], [-121.8458, 37.31315], [-121.84602, 37.31327], [-121.8461, 37.31328], [-121.8462, 37.31332], [-121.84658, 37.31343], [-121.84692, 37.31356], [-121.84697, 37.31357], [-121.84766, 37.31475], [-121.84764, 37.31497], [-121.84771, 37.31508], [-121.84776, 37.31542], [-121.84775, 37.31559], [-121.84777, 37.31566], [-121.84775, 37.31568], [-121.84776, 37.31575], [-121.84775, 37.31581], [-121.84778, 37.31594], [-121.8479, 37.3161], [-121.84815, 37.31621], [-121.84838, 37.31626], [-121.84864, 37.31629], [-121.84892, 37.31627], [-121.84912, 37.31622], [-121.84939, 37.31605], [-121.84985, 37.31584], [-121.85022, 37.3156], [-121.85106, 37.31535], [-121.85176, 37.3151], [-121.85212, 37.31495], [-121.85244, 37.31494], [-121.85297, 37.31454], [-121.85402, 37.31395], [-121.85504, 37.31493]]]} | Open Access 1 | 28340 | Coyote Creek Park | 17738 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 65.935 | Coyote Creek Park | 0 | Local Park 2 | 4 | |
9838 | 9838 | 9837 | {"type": "Polygon", "coordinates": [[[-121.88306, 37.23598], [-121.88282, 37.23622], [-121.88261, 37.23649], [-121.88268, 37.23667], [-121.88284, 37.23692], [-121.88238, 37.23705], [-121.88186, 37.23728], [-121.88159, 37.23744], [-121.88065, 37.23811], [-121.88052, 37.23825], [-121.88041, 37.23841], [-121.88029, 37.23876], [-121.88017, 37.23895], [-121.87981, 37.23938], [-121.8797, 37.23947], [-121.87956, 37.23956], [-121.87916, 37.23973], [-121.8789, 37.23953], [-121.8787, 37.23941], [-121.87844, 37.23928], [-121.87819, 37.23919], [-121.87803, 37.23948], [-121.87701, 37.23919], [-121.87697, 37.23916], [-121.87698, 37.23895], [-121.87695, 37.23881], [-121.87697, 37.23875], [-121.87716, 37.2386], [-121.87729, 37.23847], [-121.87755, 37.23816], [-121.87764, 37.23799], [-121.87767, 37.23781], [-121.87767, 37.23731], [-121.87801, 37.23725], [-121.87825, 37.23724], [-121.87836, 37.23668], [-121.87836, 37.23665], [-121.87764, 37.2361], [-121.87779, 37.23596], [-121.87789, 37.23578], [-121.87792, 37.23569], [-121.87794, 37.2355], [-121.87785, 37.23515], [-121.87784, 37.23498], [-121.87781, 37.23481], [-121.87774, 37.23464], [-121.87758, 37.23438], [-121.87755, 37.23428], [-121.87754, 37.23412], [-121.87765, 37.23381], [-121.87775, 37.23361], [-121.87786, 37.2335], [-121.87805, 37.23337], [-121.87812, 37.23327], [-121.87816, 37.23317], [-121.87816, 37.23309], [-121.87814, 37.23294], [-121.87815, 37.23285], [-121.87814, 37.2328], [-121.88021, 37.23293], [-121.88005, 37.23334], [-121.88034, 37.23378], [-121.88057, 37.23417], [-121.88125, 37.23452], [-121.88183, 37.23457], [-121.882, 37.23454], [-121.88218, 37.23447], [-121.88226, 37.23446], [-121.88239, 37.23454], [-121.88269, 37.23456], [-121.88271, 37.23468], [-121.88251, 37.23471], [-121.88232, 37.23482], [-121.8822, 37.235], [-121.88204, 37.23511], [-121.88195, 37.23532], [-121.882, 37.2354], [-121.88232, 37.23541], [-121.88233, 37.2355], [-121.88228, 37.23562], [-121.88237, 37.23576], [-121.88253, 37.23578], [-121.88281, 37.23578], [-121.883, 37.2359], [-121.88306, 37.23598]]]} | Open Access 1 | 16817 | Guadalupe Oak Grove | 19555 | 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 | 57.826 | Guadalupe Oak Grove | 1984 | Local Park 2 | 4 | |
10602 | 10602 | 10601 | {"type": "MultiPolygon", "coordinates": [[[[-121.84854, 37.33749], [-121.84887, 37.3379], [-121.8491, 37.33822], [-121.84929, 37.33856], [-121.84935, 37.33868], [-121.84938, 37.33879], [-121.84943, 37.33902], [-121.84944, 37.33937], [-121.84938, 37.33971], [-121.84926, 37.34004], [-121.84918, 37.3402], [-121.84898, 37.3405], [-121.84872, 37.34077], [-121.84858, 37.3409], [-121.84842, 37.34101], [-121.84743, 37.3415], [-121.84717, 37.34166], [-121.84693, 37.34183], [-121.84657, 37.34214], [-121.84646, 37.34227], [-121.84626, 37.34255], [-121.84616, 37.3426], [-121.84605, 37.34258], [-121.84574, 37.34232], [-121.84535, 37.34196], [-121.84525, 37.34201], [-121.84372, 37.34042], [-121.84377, 37.34038], [-121.84366, 37.34027], [-121.84406, 37.34001], [-121.84375, 37.33969], [-121.84555, 37.33847], [-121.84561, 37.33847], [-121.84567, 37.33849], [-121.84612, 37.33894], [-121.84625, 37.33898], [-121.84637, 37.33895], [-121.84854, 37.33749]]], [[[-121.84725, 37.33818], [-121.84633, 37.33882], [-121.84629, 37.33883], [-121.84623, 37.33882], [-121.84617, 37.33879], [-121.84582, 37.33842], [-121.84579, 37.33838], [-121.8458, 37.33834], [-121.84582, 37.3383], [-121.84638, 37.3379], [-121.84671, 37.33763], [-121.84725, 37.33818]]]]} | Open Access 1 | 18900 | Emma Prusch Farm Park | 18630 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 41.775 | Emma Prusch Farm Park | 1983 | Local Park 2 | 4 | |
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 |
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 | |
6077 | 6077 | 6076 | {"type": "Polygon", "coordinates": [[[-121.8399, 37.21622], [-121.83961, 37.2161], [-121.83965, 37.21605], [-121.83964, 37.21604], [-121.83923, 37.21594], [-121.83739, 37.21489], [-121.8362, 37.2147], [-121.83507, 37.21412], [-121.83433, 37.21407], [-121.83417, 37.21402], [-121.83305, 37.2138], [-121.83255, 37.21372], [-121.83138, 37.2133], [-121.82978, 37.2127], [-121.82883, 37.21165], [-121.82736, 37.2108], [-121.82611, 37.20976], [-121.8254, 37.2092], [-121.82373, 37.20715], [-121.82398, 37.20696], [-121.82419, 37.20722], [-121.82437, 37.20754], [-121.82451, 37.20773], [-121.82494, 37.20819], [-121.82558, 37.20884], [-121.82608, 37.20927], [-121.82631, 37.20944], [-121.82672, 37.2098], [-121.82767, 37.21065], [-121.82801, 37.21094], [-121.82817, 37.21104], [-121.82868, 37.21128], [-121.82899, 37.21148], [-121.82918, 37.21165], [-121.82933, 37.21183], [-121.82946, 37.21201], [-121.82962, 37.21219], [-121.82977, 37.21233], [-121.83008, 37.21252], [-121.83038, 37.21265], [-121.83067, 37.21273], [-121.83097, 37.21279], [-121.83133, 37.2128], [-121.83159, 37.21279], [-121.8319, 37.21274], [-121.83377, 37.21223], [-121.83403, 37.21219], [-121.83436, 37.21218], [-121.83476, 37.21223], [-121.83528, 37.2124], [-121.8356, 37.21254], [-121.83579, 37.21265], [-121.8358, 37.21271], [-121.83708, 37.21396], [-121.83744, 37.21429], [-121.83795, 37.2146], [-121.8395, 37.21541], [-121.83982, 37.21556], [-121.8399, 37.21622]]]} | Open Access 1 | 860 | Singer Park | 25518 | 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.405 | Singer Park | 1984 | Local Park 2 | 4 | |
10395 | 10395 | 10394 | {"type": "Polygon", "coordinates": [[[-121.85742, 37.36514], [-121.85473, 37.36697], [-121.85203, 37.36421], [-121.85465, 37.36245], [-121.85472, 37.36244], [-121.85742, 37.36514]]]} | Open Access 1 | 18374 | Overfelt Botanical Gardens | 23270 | 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 | 29.813 | Overfelt Botanical Gardens | 1977 | Local Park 2 | 4 | |
2382 | 2382 | 2381 | {"type": "Polygon", "coordinates": [[[-121.8149, 37.23239], [-121.81368, 37.23281], [-121.81369, 37.23392], [-121.81364, 37.23398], [-121.81363, 37.23404], [-121.81363, 37.23446], [-121.81364, 37.23453], [-121.81369, 37.23461], [-121.8137, 37.23499], [-121.81156, 37.23502], [-121.81124, 37.23471], [-121.81128, 37.23466], [-121.81129, 37.2346], [-121.81124, 37.23451], [-121.81121, 37.23433], [-121.81117, 37.23422], [-121.81106, 37.23396], [-121.81063, 37.23325], [-121.81059, 37.23314], [-121.81053, 37.23282], [-121.81054, 37.23278], [-121.81058, 37.23275], [-121.81076, 37.23272], [-121.81096, 37.23267], [-121.8111, 37.2326], [-121.81125, 37.23251], [-121.8124, 37.23151], [-121.81267, 37.2317], [-121.81292, 37.23149], [-121.81306, 37.23141], [-121.81359, 37.23123], [-121.81376, 37.23155], [-121.8142, 37.23141], [-121.8143, 37.23152], [-121.81449, 37.23165], [-121.8149, 37.23239]]]} | Open Access 1 | 17211 | La Colina Park and Garden | 20748 | 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 | 23.837 | La Colina Park and Garden | 1982 | Local Park 2 | 4 | |
9833 | 9833 | 9832 | {"type": "MultiPolygon", "coordinates": [[[[-121.90925, 37.34333], [-121.90916, 37.3434], [-121.90913, 37.34339], [-121.90887, 37.3436], [-121.90847, 37.34388], [-121.9075, 37.34298], [-121.90857, 37.34223], [-121.90949, 37.34309], [-121.90948, 37.34314], [-121.90925, 37.34331], [-121.90925, 37.34333]]], [[[-121.9128, 37.35228], [-121.91234, 37.35264], [-121.91191, 37.3534], [-121.9114, 37.35387], [-121.91081, 37.35295], [-121.90954, 37.35053], [-121.90947, 37.35042], [-121.91082, 37.34945], [-121.91086, 37.34946], [-121.91123, 37.34978], [-121.91112, 37.34984], [-121.91122, 37.34994], [-121.91167, 37.3509], [-121.91219, 37.35054], [-121.91252, 37.35098], [-121.91199, 37.35129], [-121.91255, 37.35174], [-121.9128, 37.35228]]]]} | Restricted Access 2 | 16812 | Guadalupe Gardens | 19544 | 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 | 21.614 | Guadalupe Gardens | 0 | Local Park 2 | 4 | |
2107 | 2107 | 2106 | {"type": "Polygon", "coordinates": [[[-121.823, 37.2655], [-121.82273, 37.26566], [-121.82189, 37.26626], [-121.82172, 37.26633], [-121.82156, 37.26635], [-121.82143, 37.26634], [-121.82131, 37.2663], [-121.82003, 37.26559], [-121.8195, 37.26514], [-121.81947, 37.26509], [-121.81945, 37.26503], [-121.81942, 37.26502], [-121.81945, 37.26287], [-121.82135, 37.26289], [-121.82136, 37.26338], [-121.82176, 37.26351], [-121.82177, 37.26403], [-121.82155, 37.2643], [-121.82156, 37.26434], [-121.823, 37.2655]]]} | Open Access 1 | 15890 | Edenvale Garden | 18431 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 18.978 | Edenvale Garden | 1991 | Local Park 2 | 4 | |
9367 | 9367 | 9366 | {"type": "Polygon", "coordinates": [[[-121.86823, 37.33704], [-121.86811, 37.33728], [-121.868, 37.3374], [-121.86712, 37.338], [-121.86682, 37.3377], [-121.86706, 37.33752], [-121.86621, 37.33482], [-121.86543, 37.33468], [-121.86602, 37.33164], [-121.86772, 37.33066], [-121.86705, 37.33189], [-121.86683, 37.33212], [-121.86732, 37.33319], [-121.86711, 37.33392], [-121.86694, 37.33478], [-121.86697, 37.33548], [-121.86703, 37.33577], [-121.8674, 37.33676], [-121.86823, 37.33704]]]} | Open Access 1 | 15647 | Selma Olinder Park | 25292 | 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.112 | Selma Olinder Park | 0 | Local Park 2 | 4 | |
1803 | 1803 | 1802 | {"type": "Polygon", "coordinates": [[[-121.84745, 37.20134], [-121.84565, 37.20254], [-121.84563, 37.20249], [-121.84558, 37.20245], [-121.84551, 37.20245], [-121.84545, 37.20247], [-121.84542, 37.20251], [-121.84541, 37.20256], [-121.84544, 37.2026], [-121.84551, 37.20264], [-121.8452, 37.20285], [-121.84461, 37.20322], [-121.8433, 37.20177], [-121.84341, 37.20185], [-121.84347, 37.20186], [-121.84352, 37.20184], [-121.84355, 37.2018], [-121.84354, 37.20175], [-121.84342, 37.20169], [-121.84517, 37.20043], [-121.84539, 37.20021], [-121.84556, 37.19995], [-121.84566, 37.20001], [-121.84567, 37.20007], [-121.84573, 37.20011], [-121.84578, 37.20011], [-121.84589, 37.20008], [-121.84634, 37.20012], [-121.8466, 37.20018], [-121.84684, 37.20031], [-121.8472, 37.20066], [-121.84718, 37.20071], [-121.8472, 37.20078], [-121.84745, 37.20134]]]} | Open Access 1 | 13649 | Cathedral Oaks Park | 16975 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 16.969 | Cathedral Oaks Park | 0 | Local Park 2 | 4 | |
9893 | 9893 | 9892 | {"type": "Polygon", "coordinates": [[[-121.82711, 37.33885], [-121.82645, 37.33931], [-121.82597, 37.33976], [-121.82509, 37.34035], [-121.82503, 37.34034], [-121.82348, 37.33884], [-121.8235, 37.33878], [-121.82558, 37.33734], [-121.82566, 37.33737], [-121.82711, 37.33885]]]} | Open Access 1 | 16962 | Hillview Park | 19994 | 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 | 13.613 | Hillview Park | 1978 | Local Park 2 | 4 | |
1234 | 1234 | 1233 | {"type": "Polygon", "coordinates": [[[-121.76559, 37.31506], [-121.76531, 37.31511], [-121.76518, 37.31495], [-121.76504, 37.31485], [-121.76486, 37.31479], [-121.76467, 37.31476], [-121.76446, 37.31478], [-121.7643, 37.31483], [-121.76414, 37.31492], [-121.76403, 37.31502], [-121.76217, 37.31363], [-121.76214, 37.31352], [-121.76158, 37.31311], [-121.7645, 37.31267], [-121.76473, 37.31364], [-121.76477, 37.31367], [-121.76483, 37.31368], [-121.76526, 37.31361], [-121.76559, 37.31506]]]} | Open Access 1 | 8930 | Fowler Creek Community Park | 19029 | 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 | 12.449 | Fowler Creek Community Park | 2004 | Local Park 2 | 4 | |
606 | 606 | 605 | {"type": "Polygon", "coordinates": [[[-121.86951, 37.33581], [-121.86875, 37.33619], [-121.86867, 37.33624], [-121.86862, 37.3363], [-121.86823, 37.33704], [-121.8674, 37.33676], [-121.86703, 37.33577], [-121.86697, 37.33548], [-121.86694, 37.33478], [-121.86711, 37.33392], [-121.86791, 37.33383], [-121.86822, 37.33441], [-121.8684, 37.33465], [-121.86852, 37.33479], [-121.86892, 37.33513], [-121.86918, 37.33538], [-121.86951, 37.33581]]]} | Open Access 1 | 2110 | William Street Park | 27559 | 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 | 11.685 | William Street Park | 0 | Local Park 2 | 4 | |
1450 | 1450 | 1449 | {"type": "Polygon", "coordinates": [[[-121.79984, 37.29776], [-121.79995, 37.29788], [-121.80108, 37.29865], [-121.80193, 37.29927], [-121.80227, 37.29957], [-121.80229, 37.29962], [-121.80228, 37.29968], [-121.80223, 37.29972], [-121.80217, 37.29974], [-121.80167, 37.29976], [-121.80127, 37.29971], [-121.80083, 37.29959], [-121.80041, 37.29941], [-121.80028, 37.29934], [-121.79935, 37.29865], [-121.79849, 37.29807], [-121.7982, 37.29794], [-121.79762, 37.29775], [-121.79726, 37.2977], [-121.79688, 37.29768], [-121.79618, 37.29772], [-121.79586, 37.29771], [-121.79542, 37.29766], [-121.79511, 37.29759], [-121.79493, 37.29754], [-121.79489, 37.2975], [-121.79488, 37.29746], [-121.79492, 37.29733], [-121.79496, 37.2973], [-121.79501, 37.29728], [-121.79528, 37.29728], [-121.79537, 37.29731], [-121.79733, 37.29722], [-121.79798, 37.29744], [-121.79841, 37.29762], [-121.79914, 37.29778], [-121.79984, 37.29776]]]} | Open Access 1 | 9709 | Silver Creek Linear Park | 25483 | 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 | 11.638 | Silver Creek Linear Park | 1997 | Local Park 2 | 4 | |
3974 | 3974 | 3973 | {"type": "Polygon", "coordinates": [[[-121.80056, 37.25232], [-121.79928, 37.25154], [-121.79891, 37.25141], [-121.79868, 37.25121], [-121.79825, 37.25096], [-121.79925, 37.25094], [-121.79923, 37.24979], [-121.80095, 37.24977], [-121.80099, 37.24979], [-121.80102, 37.25092], [-121.80104, 37.25108], [-121.80112, 37.25129], [-121.80121, 37.25143], [-121.80131, 37.25154], [-121.80132, 37.25157], [-121.80065, 37.25231], [-121.80061, 37.25233], [-121.80056, 37.25232]]]} | Open Access 1 | 38006 | RMAC Park | 24473 | 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.55 | RMAC Park | 0 | 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 |
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]);