units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
253 rows where MNG_AGENCY = 32 sorted by DES_TP 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14874 | 14874 | 14873 | {"type": "Polygon", "coordinates": [[[-121.76653, 37.32462], [-121.76622, 37.32463], [-121.7658, 37.32469], [-121.76565, 37.3247], [-121.76481, 37.32488], [-121.76421, 37.32506], [-121.76403, 37.32513], [-121.76329, 37.32556], [-121.76262, 37.32607], [-121.76252, 37.32646], [-121.76246, 37.32656], [-121.76205, 37.32662], [-121.76177, 37.32663], [-121.76169, 37.32659], [-121.76162, 37.32652], [-121.76383, 37.32484], [-121.7644, 37.32461], [-121.76459, 37.32456], [-121.76462, 37.32455], [-121.76462, 37.32452], [-121.7647, 37.32452], [-121.7648, 37.32446], [-121.76566, 37.32419], [-121.76574, 37.32414], [-121.7658, 37.32405], [-121.76587, 37.32406], [-121.76638, 37.32397], [-121.76653, 37.32462]]]} | Open Access 1 | 45397 | Quimby Creek Parkchain | 27900 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 5.092 | Quimby Creek Parkchain | None 1281 | |||
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 | |||
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 | |||
14419 | 14419 | 14418 | {"type": "Polygon", "coordinates": [[[-121.86861, 37.32876], [-121.86824, 37.32896], [-121.8683, 37.3293], [-121.86784, 37.32956], [-121.86752, 37.32953], [-121.86745, 37.32955], [-121.86733, 37.3296], [-121.86707, 37.32975], [-121.86612, 37.33033], [-121.86517, 37.33096], [-121.8641, 37.33176], [-121.86176, 37.3332], [-121.86128, 37.33275], [-121.86155, 37.33211], [-121.86466, 37.32991], [-121.86398, 37.32817], [-121.86392, 37.32808], [-121.86373, 37.3281], [-121.86348, 37.32808], [-121.86339, 37.32806], [-121.86324, 37.32814], [-121.86244, 37.32808], [-121.8616, 37.32794], [-121.86136, 37.32787], [-121.86175, 37.32769], [-121.8618, 37.3277], [-121.86212, 37.32756], [-121.86324, 37.32704], [-121.86358, 37.32687], [-121.86417, 37.32662], [-121.86475, 37.32634], [-121.8647, 37.32633], [-121.86558, 37.32598], [-121.86562, 37.32619], [-121.86614, 37.32637], [-121.86631, 37.32641], [-121.86749, 37.32758], [-121.86836, 37.32846], [-121.86861, 37.32876]]]} | Open Access 1 | 44529 | Coyote Creek Parkchain | 17739 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 48.973 | Coyote Creek Parkchain | 0 | None 1226 | ||
14025 | 14025 | 14024 | {"type": "MultiPolygon", "coordinates": [[[[-121.82812, 37.30669], [-121.82394, 37.30932], [-121.82371, 37.30909], [-121.82499, 37.30827], [-121.82783, 37.3065], [-121.82788, 37.30649], [-121.82792, 37.3065], [-121.82812, 37.30669]]], [[[-121.83241, 37.30382], [-121.82836, 37.30653], [-121.82817, 37.30634], [-121.82816, 37.30629], [-121.82819, 37.30626], [-121.83201, 37.30371], [-121.83206, 37.3037], [-121.83227, 37.30378], [-121.83241, 37.30382]]]]} | Open Access 1 | 38016 | Umbarger Pathway | 26650 | 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 | 7.564 | Umbarger Pathway | None 1198 | |||
14024 | 14024 | 14023 | {"type": "MultiPolygon", "coordinates": [[[[-121.81736, 37.31364], [-121.8153, 37.31502], [-121.81397, 37.31591], [-121.81404, 37.31557], [-121.81408, 37.31554], [-121.81431, 37.31549], [-121.81447, 37.31539], [-121.81459, 37.31525], [-121.81465, 37.31511], [-121.81476, 37.31501], [-121.81491, 37.31494], [-121.8152, 37.31489], [-121.81535, 37.31481], [-121.81609, 37.31431], [-121.81679, 37.31386], [-121.81692, 37.31374], [-121.81701, 37.31356], [-121.81708, 37.31349], [-121.81717, 37.31348], [-121.81725, 37.31355], [-121.81727, 37.31354], [-121.81736, 37.31364]]], [[[-121.8212, 37.31105], [-121.8176, 37.31346], [-121.8174, 37.31329], [-121.81739, 37.31326], [-121.81741, 37.31321], [-121.81755, 37.31312], [-121.81769, 37.31306], [-121.81803, 37.31296], [-121.8182, 37.31289], [-121.81946, 37.31205], [-121.81964, 37.31189], [-121.81983, 37.3116], [-121.82001, 37.31145], [-121.8202, 37.31136], [-121.82077, 37.31116], [-121.82105, 37.311], [-121.82113, 37.311], [-121.8212, 37.31105]]]]} | Open Access 1 | 38015 | Barberry Pathway | 15808 | 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.881 | Barberry Pathway | None 1197 | |||
10636 | 10636 | 10635 | {"type": "Polygon", "coordinates": [[[-122.00954, 37.30075], [-122.00901, 37.30197], [-122.00665, 37.30109], [-122.0066, 37.30106], [-122.00659, 37.30103], [-122.00702, 37.29988], [-122.0071, 37.29985], [-122.00954, 37.30075]]]} | Open Access 1 | 18961 | Rainbow | 24083 | 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.476 | Rainbow | 1991 | None 935 | ||
10535 | 10535 | 10534 | {"type": "Polygon", "coordinates": [[[-121.88902, 37.33131], [-121.88912, 37.33132], [-121.88924, 37.33138], [-121.88939, 37.3315], [-121.88951, 37.33163], [-121.89039, 37.33279], [-121.89041, 37.33286], [-121.89041, 37.33293], [-121.89037, 37.333], [-121.89033, 37.33304], [-121.89023, 37.33308], [-121.89014, 37.33309], [-121.89003, 37.33307], [-121.88994, 37.33301], [-121.88886, 37.33158], [-121.88884, 37.33149], [-121.88886, 37.33142], [-121.88893, 37.33135], [-121.88902, 37.33131]]]} | Open Access 1 | 18747 | Plaza de Ceasr Chavez | 23778 | 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.432 | Plaza de Ceasr Chavez | 1988 | None 924 | ||
10529 | 10529 | 10528 | {"type": "Polygon", "coordinates": [[[-121.86047, 37.35798], [-121.86039, 37.35799], [-121.85985, 37.35783], [-121.85954, 37.35777], [-121.85736, 37.35764], [-121.85711, 37.35765], [-121.85691, 37.35767], [-121.85672, 37.35771], [-121.85651, 37.35778], [-121.85668, 37.35763], [-121.8588, 37.3562], [-121.85878, 37.35623], [-121.85879, 37.35626], [-121.86046, 37.35796], [-121.86047, 37.35798]]]} | Open Access 1 | 18733 | Plata Arroyo | 23771 | 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.812 | Plata Arroyo | 1980 | None 922 | ||
10481 | 10481 | 10480 | {"type": "Polygon", "coordinates": [[[-121.86155, 37.37723], [-121.86155, 37.37723], [-121.86087, 37.37798], [-121.86118, 37.37735], [-121.8611, 37.37702], [-121.86118, 37.37684], [-121.86155, 37.37723]]]} | Open Access 1 | 18595 | Penitencia Creek Park Chain | 23584 | 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.518 | Penitencia Creek Park Chain | None 916 | |||
10470 | 10470 | 10469 | {"type": "Polygon", "coordinates": [[[-121.84733, 37.27324], [-121.84675, 37.27339], [-121.84643, 37.27345], [-121.84637, 37.27315], [-121.84635, 37.27312], [-121.84639, 37.27307], [-121.8464, 37.27301], [-121.8463, 37.27244], [-121.84627, 37.27237], [-121.84622, 37.27233], [-121.84627, 37.27226], [-121.84614, 37.27172], [-121.84645, 37.27165], [-121.84671, 37.27216], [-121.84675, 37.27219], [-121.84673, 37.27225], [-121.84674, 37.27231], [-121.84701, 37.27285], [-121.84708, 37.27291], [-121.84717, 37.27294], [-121.84733, 37.27324]]]} | Open Access 1 | 18527 | Parkview I | 23454 | 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.402 | Parkview I | 1981 | None 915 | ||
10464 | 10464 | 10463 | {"type": "Polygon", "coordinates": [[[-121.84528, 37.26941], [-121.84461, 37.26964], [-121.84447, 37.26935], [-121.84449, 37.26921], [-121.84446, 37.26905], [-121.84426, 37.26864], [-121.84422, 37.26859], [-121.84416, 37.26856], [-121.84402, 37.26854], [-121.84402, 37.26825], [-121.84378, 37.26798], [-121.84367, 37.26792], [-121.8437, 37.26784], [-121.84418, 37.26809], [-121.8445, 37.26799], [-121.84464, 37.26824], [-121.84469, 37.26828], [-121.84477, 37.2683], [-121.84477, 37.26833], [-121.84502, 37.26884], [-121.84507, 37.26887], [-121.84505, 37.26892], [-121.84506, 37.26898], [-121.84528, 37.26941]]]} | Open Access 1 | 18534 | Parkview II | 23455 | 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.616 | Parkview II | 1981 | None 912 | ||
10297 | 10297 | 10296 | {"type": "Polygon", "coordinates": [[[-121.99956, 37.30345], [-121.99939, 37.30349], [-121.99906, 37.30343], [-121.99898, 37.30362], [-121.99877, 37.30357], [-121.99874, 37.30348], [-121.99883, 37.30339], [-121.99878, 37.30332], [-121.99868, 37.303], [-121.99851, 37.30304], [-121.99837, 37.30345], [-121.99781, 37.3033], [-121.99669, 37.30278], [-121.99678, 37.30246], [-121.99697, 37.30198], [-121.99716, 37.30158], [-121.99765, 37.30171], [-121.99763, 37.30174], [-121.99763, 37.30179], [-121.99768, 37.30186], [-121.99784, 37.3019], [-121.9982, 37.30207], [-121.99856, 37.3022], [-121.99897, 37.30232], [-121.99986, 37.30254], [-121.99988, 37.30259], [-121.99956, 37.30345]]]} | Open Access 1 | 18130 | Murdock | 22602 | 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.508 | Murdock | None 898 | |||
10276 | 10276 | 10275 | {"type": "Polygon", "coordinates": [[[-121.76401, 37.30512], [-121.76374, 37.30507], [-121.763, 37.30477], [-121.76282, 37.30474], [-121.76264, 37.30472], [-121.76246, 37.30474], [-121.76218, 37.30481], [-121.7617, 37.30508], [-121.76132, 37.30521], [-121.76002, 37.3054], [-121.75953, 37.30543], [-121.75927, 37.30523], [-121.75899, 37.30511], [-121.75879, 37.30507], [-121.75805, 37.30495], [-121.75789, 37.30495], [-121.75775, 37.30498], [-121.75767, 37.30502], [-121.7575, 37.30513], [-121.7574, 37.30517], [-121.7573, 37.30518], [-121.75721, 37.30513], [-121.75712, 37.30513], [-121.75706, 37.30517], [-121.75704, 37.30524], [-121.75706, 37.30528], [-121.75711, 37.30531], [-121.75708, 37.30536], [-121.75715, 37.30583], [-121.7572, 37.30588], [-121.75718, 37.30591], [-121.75717, 37.30595], [-121.7572, 37.30601], [-121.75725, 37.30604], [-121.75732, 37.30632], [-121.75735, 37.30655], [-121.75768, 37.30659], [-121.75768, 37.30661], [-121.75767, 37.30666], [-121.75733, 37.30662], [-121.7572, 37.30726], [-121.7569, 37.30716], [-121.75685, 37.3071], [-121.75687, 37.30695], [-121.75681, 37.3067], [-121.75713, 37.30656], [-121.75691, 37.3056], [-121.75691, 37.30546], [-121.75695, 37.30533], [-121.75663, 37.3052], [-121.75665, 37.30515], [-121.75673, 37.30505], [-121.75673, 37.305], [-121.7567, 37.30496], [-121.75664, 37.30492], [-121.7564, 37.30487], [-121.75552, 37.30484], [-121.75539, 37.30486], [-121.7553, 37.30481], [-121.75493, 37.30478], [-121.75474, 37.3039], [-121.75474, 37.30363], [-121.75477, 37.30348], [-121.75481, 37.30331], [-121.75505, 37.30271], [-121.75511, 37.30251], [-121.75513, 37.30235], [-121.75514, 37.30211], [-121.7551, 37.30129], [-121.75512, 37.30112], [-121.75524, 37.30079], [-121.75534, 37.30064], [-121.75563, 37.30032], [-121.75573, 37.30023], [-121.75598, 37.30008], [-121.75612, 37.30002], [-121.75641, 37.29992], [-121.75672, 37.29986], [-121.75723, 37.29981], [-121.75741, 37.29977], [-121.75775, 37.29967], [-121.75791, 37.29961], [-121.75821, 37.29946], [-121.75893, 37.29897], [-121.75918, 37.30004], [-121.75941, 37.30116], [-121.75991, 37.30195], [-121.76075, 37.30315], [-121.76107, 37.3037], [-121.76142, 37.30424], [-121.76366, 37.30353], [-121.76401, 37.30512]]]} | Open Access 1 | 18012 | Montgomery Hill | 22437 | 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 | 75.534 | Montgomery Hill | 2004 | None 896 | ||
10151 | 10151 | 10150 | {"type": "Polygon", "coordinates": [[[-121.86456, 37.33387], [-121.86435, 37.33498], [-121.86409, 37.33515], [-121.86367, 37.3373], [-121.86253, 37.3362], [-121.8631, 37.3358], [-121.86285, 37.33557], [-121.86285, 37.3355], [-121.86282, 37.33545], [-121.86253, 37.33517], [-121.8625, 37.33512], [-121.86251, 37.33507], [-121.86254, 37.335], [-121.86412, 37.33396], [-121.86417, 37.3339], [-121.8642, 37.33383], [-121.86456, 37.33387]]]} | Open Access 1 | 17689 | Martin | 21901 | 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.334 | Martin | 1984 | None 880 | ||
10134 | 10134 | 10133 | {"type": "Polygon", "coordinates": [[[-121.88597, 37.3528], [-121.88435, 37.35358], [-121.88288, 37.35164], [-121.8845, 37.35086], [-121.88597, 37.3528]]]} | Open Access 1 | 17640 | Backesto | 15753 | 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.459 | Backesto | 1981 | None 878 | ||
10081 | 10081 | 10080 | {"type": "Polygon", "coordinates": [[[-121.77292, 37.22793], [-121.77207, 37.22885], [-121.77167, 37.22865], [-121.77123, 37.22848], [-121.7711, 37.22847], [-121.77096, 37.22853], [-121.77057, 37.22894], [-121.77054, 37.229], [-121.77054, 37.22905], [-121.77058, 37.22915], [-121.77049, 37.22913], [-121.77014, 37.22952], [-121.77021, 37.22965], [-121.77016, 37.22969], [-121.77013, 37.22973], [-121.76994, 37.22971], [-121.7696, 37.23009], [-121.76967, 37.23023], [-121.76963, 37.23026], [-121.7696, 37.2303], [-121.76942, 37.2303], [-121.76906, 37.23067], [-121.76914, 37.2308], [-121.76908, 37.23087], [-121.76887, 37.23087], [-121.76852, 37.23124], [-121.7686, 37.23137], [-121.76856, 37.23141], [-121.76853, 37.23146], [-121.76835, 37.23143], [-121.768, 37.23181], [-121.76808, 37.23195], [-121.76802, 37.23199], [-121.76799, 37.23204], [-121.76781, 37.23201], [-121.76747, 37.23239], [-121.76753, 37.23253], [-121.76749, 37.23257], [-121.76746, 37.2326], [-121.76727, 37.23259], [-121.7666, 37.23333], [-121.76653, 37.2333], [-121.76691, 37.23289], [-121.76683, 37.23275], [-121.76688, 37.23271], [-121.76691, 37.23266], [-121.7671, 37.23268], [-121.76745, 37.23231], [-121.76737, 37.23217], [-121.76744, 37.23209], [-121.76763, 37.2321], [-121.76798, 37.23173], [-121.76791, 37.2316], [-121.76796, 37.23156], [-121.76798, 37.23151], [-121.76817, 37.23153], [-121.76818, 37.23152], [-121.76852, 37.23115], [-121.76844, 37.23102], [-121.76849, 37.23098], [-121.76852, 37.23093], [-121.76871, 37.23094], [-121.76906, 37.23057], [-121.76897, 37.23044], [-121.76905, 37.23036], [-121.76923, 37.23039], [-121.76957, 37.23001], [-121.76951, 37.22986], [-121.76958, 37.22979], [-121.76977, 37.2298], [-121.77007, 37.22948], [-121.77003, 37.2293], [-121.77009, 37.22926], [-121.77012, 37.22921], [-121.77031, 37.22923], [-121.77043, 37.22909], [-121.7704, 37.22899], [-121.77141, 37.2279], [-121.76971, 37.22689], [-121.7693, 37.22691], [-121.76927, 37.22684], [-121.7692, 37.22678], [-121.76911, 37.22674], [-121.76863, 37.22647], [-121.76915, 37.22458], [-121.77016, 37.22475], [-121.7698, 37.22608], [-121.77292, 37.22793]]]} | Open Access 1 | 17452 | Los Paseos | 21526 | 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 | 15.225 | Los Paseos | 1972 | None 875 | ||
10077 | 10077 | 10076 | {"type": "MultiPolygon", "coordinates": [[[[-121.80047, 37.19298], [-121.80035, 37.19309], [-121.80025, 37.19301], [-121.80005, 37.19293], [-121.79983, 37.1927], [-121.79966, 37.19248], [-121.79953, 37.19239], [-121.79901, 37.1917], [-121.79885, 37.19152], [-121.79844, 37.19072], [-121.79832, 37.19062], [-121.79805, 37.19043], [-121.79786, 37.19033], [-121.79778, 37.19032], [-121.79772, 37.19033], [-121.79757, 37.19042], [-121.79747, 37.19055], [-121.79727, 37.19077], [-121.79714, 37.19089], [-121.79689, 37.19092], [-121.7966, 37.19086], [-121.79647, 37.1908], [-121.79634, 37.19069], [-121.7962, 37.19055], [-121.79615, 37.19011], [-121.79606, 37.18995], [-121.79597, 37.18987], [-121.79581, 37.18976], [-121.79553, 37.18966], [-121.79489, 37.18947], [-121.79477, 37.18942], [-121.79465, 37.18934], [-121.79432, 37.18923], [-121.79427, 37.1891], [-121.79437, 37.18898], [-121.79455, 37.18889], [-121.7948, 37.18882], [-121.79489, 37.18874], [-121.79507, 37.18869], [-121.79515, 37.18867], [-121.79535, 37.18866], [-121.79548, 37.18855], [-121.79567, 37.18835], [-121.79572, 37.18824], [-121.79572, 37.18817], [-121.79563, 37.18796], [-121.79538, 37.18759], [-121.79558, 37.18754], [-121.79585, 37.18793], [-121.79594, 37.18813], [-121.79594, 37.1882], [-121.79588, 37.18832], [-121.79566, 37.18855], [-121.79549, 37.18867], [-121.7954, 37.1887], [-121.79513, 37.1887], [-121.79499, 37.18879], [-121.79477, 37.18886], [-121.79458, 37.18894], [-121.79453, 37.189], [-121.79452, 37.18915], [-121.79504, 37.18938], [-121.79533, 37.18947], [-121.79576, 37.18954], [-121.79611, 37.18976], [-121.79641, 37.19001], [-121.79645, 37.1901], [-121.79645, 37.19017], [-121.79631, 37.19032], [-121.79632, 37.19044], [-121.79634, 37.19048], [-121.7967, 37.19082], [-121.79692, 37.19083], [-121.79707, 37.1908], [-121.79714, 37.19077], [-121.79732, 37.19061], [-121.79749, 37.19033], [-121.79756, 37.19028], [-121.7976, 37.19023], [-121.79774, 37.1902], [-121.79785, 37.1902], [-121.79797, 37.19024], [-121.79812, 37.19032], [-121.79856, 37.19075], [-121.7987, 37.19092], [-121.79889, 37.19132], [-121.79951, 37.19214], [-121.79965, 37.19223], [-121.79981, 37.19244], [-121.80003, 37.19267], [-121.80023, 37.19276], [-121.80037, 37.19292], [-121.80044, 37.19295], [-121.80047, 37.19298]]], [[[-121.82366, 37.20708], [-121.82352, 37.20717], [-121.82341, 37.20719], [-121.82257, 37.20669], [-121.82208, 37.2067], [-121.82177, 37.20662], [-121.82147, 37.20614], [-121.82144, 37.20597], [-121.82138, 37.20592], [-121.82108, 37.20588], [-121.82041, 37.20547], [-121.81997, 37.20555], [-121.81972, 37.20554], [-121.81937, 37.20549], [-121.81927, 37.20546], [-121.8191, 37.20517], [-121.81882, 37.20497], [-121.81832, 37.20485], [-121.81807, 37.20465], [-121.81794, 37.20442], [-121.81755, 37.20417], [-121.81763, 37.20394], [-121.81761, 37.20389], [-121.81744, 37.2037], [-121.81715, 37.2035], [-121.81698, 37.20349], [-121.81675, 37.2033], [-121.81673, 37.20304], [-121.8165, 37.20275], [-121.816, 37.20266], [-121.81583, 37.20255], [-121.81526, 37.20244], [-121.81512, 37.20238], [-121.81509, 37.20233], [-121.81509, 37.20222], [-121.81506, 37.20207], [-121.81508, 37.20184], [-121.81508, 37.20175], [-121.81504, 37.20167], [-121.81495, 37.20161], [-121.81481, 37.20155], [-121.81458, 37.20149], [-121.81426, 37.20145], [-121.81394, 37.20139], [-121.81361, 37.2014], [-121.81325, 37.20149], [-121.8131, 37.20151], [-121.81298, 37.2015], [-121.81268, 37.2014], [-121.81256, 37.20139], [-121.81251, 37.20136], [-121.81239, 37.20124], [-121.8123, 37.20111], [-121.81222, 37.20088], [-121.81222, 37.20063], [-121.81219, 37.20051], [-121.81211, 37.20043], [-121.81181, 37.20023], [-121.81148, 37.20005], [-121.8114, 37.20003], [-121.81123, 37.20004], [-121.8109, 37.20019], [-121.81071, 37.20021], [-121.81054, 37.20021], [-121.81037, 37.20026], [-121.81026, 37.20027], [-121.81014, 37.20024], [-121.80999, 37.20017], [-121.80978, 37.20001], [-121.80956, 37.19992], [-121.80898, 37.19965], [-121.80883, 37.19953], [-121.80879, 37.19947], [-121.80878, 37.19943], [-121.80895, 37.1991], [-121.80908, 37.19893], [-121.80917, 37.19872], [-121.80917, 37.19866], [-121.80915, 37.19864], [-121.80899, 37.19862], [-121.80877, 37.19863], [-121.80812, 37.19841], [-121.80793, 37.1983], [-121.80759, 37.19789], [-121.8076, 37.19785], [-121.80776, 37.1976], [-121.80781, 37.19747], [-121.80781, 37.19737], [-121.80769, 37.19722], [-121.80751, 37.19716], [-121.80736, 37.19713], [-121.80713, 37.19717], [-121.80696, 37.19725], [-121.80686, 37.19738], [-121.80674, 37.19769], [-121.80662, 37.19791], [-121.80659, 37.19812], [-121.80659, 37.19821], [-121.80665, 37.19842], [-121.80663, 37.19845], [-121.80636, 37.19847], [-121.80624, 37.19846], [-121.80612, 37.19841], [-121.80526, 37.19789], [-121.80495, 37.19776], [-121.80475, 37.19774], [-121.80451, 37.19767], [-121.80443, 37.19763], [-121.80432, 37.19754], [-121.80429, 37.19748], [-121.80438, 37.1972], [-121.80451, 37.19697], [-121.80469, 37.19673], [-121.80474, 37.19659], [-121.80474, 37.19654], [-121.80476, 37.19653], [-121.80474, 37.19618], [-121.80471, 37.19611], [-121.8047, 37.196], [-121.80438, 37.19577], [-121.80413, 37.19554], [-121.80377, 37.19574], [-121.80332, 37.19552], [-121.80197, 37.19607], [-121.80189, 37.19603], [-121.80187, 37.196], [-121.80188, 37.19597], [-121.80187, 37.19592], [-121.80184, 37.19587], [-121.80168, 37.19547], [-121.80164, 37.19529], [-121.80155, 37.19512], [-121.80149, 37.19487], [-121.80147, 37.19472], [-121.8014, 37.19458], [-121.8014, 37.19449], [-121.8013, 37.19432], [-121.80129, 37.19422], [-121.80124, 37.1941], [-121.80122, 37.19389], [-121.80113, 37.19376], [-121.80111, 37.19367], [-121.80107, 37.19363], [-121.80092, 37.19357], [-121.80075, 37.19342], [-121.80049, 37.1931], [-121.80056, 37.19304], [-121.80102, 37.19343], [-121.80116, 37.19366], [-121.80134, 37.19387], [-121.80144, 37.19403], [-121.80153, 37.1942], [-121.80157, 37.19435], [-121.8016, 37.19451], [-121.80162, 37.19474], [-121.80176, 37.19522], [-121.80205, 37.19596], [-121.80332, 37.19543], [-121.80376, 37.19564], [-121.80414, 37.19543], [-121.8046, 37.19579], [-121.8048, 37.19596], [-121.80481, 37.1961], [-121.80484, 37.19617], [-121.80486, 37.19656], [-121.80484, 37.19657], [-121.80479, 37.19676], [-121.80461, 37.19701], [-121.80448, 37.19723], [-121.8044, 37.19749], [-121.8045, 37.19756], [-121.80456, 37.1976], [-121.80478, 37.19766], [-121.80498, 37.19768], [-121.80531, 37.19781], [-121.80617, 37.19834], [-121.80629, 37.19838], [-121.80653, 37.19838], [-121.80653, 37.19832], [-121.80649, 37.19822], [-121.80649, 37.19812], [-121.80652, 37.19789], [-121.80664, 37.19767], [-121.80677, 37.19735], [-121.80689, 37.19719], [-121.80709, 37.19709], [-121.80736, 37.19705], [-121.80754, 37.19708], [-121.80776, 37.19715], [-121.80791, 37.19735], [-121.80791, 37.19748], [-121.80786, 37.19763], [-121.8077, 37.19787], [-121.808, 37.19824], [-121.80817, 37.19834], [-121.80879, 37.19855], [-121.80899, 37.19854], [-121.80919, 37.19856], [-121.80923, 37.19858], [-121.80926, 37.19862], [-121.80928, 37.19868], [-121.80922, 37.19888], [-121.80917, 37.19897], [-121.80905, 37.19912], [-121.80889, 37.19943], [-121.8089, 37.19947], [-121.80903, 37.19958], [-121.80987, 37.19996], [-121.81005, 37.2001], [-121.8102, 37.20017], [-121.81031, 37.20019], [-121.81047, 37.20014], [-121.81087, 37.20011], [-121.81119, 37.19996], [-121.81141, 37.19995], [-121.81154, 37.19998], [-121.81187, 37.20017], [-121.81218, 37.20037], [-121.81228, 37.20047], [-121.81231, 37.20055], [-121.81233, 37.20062], [-121.81232, 37.20086], [-121.8124, 37.20108], [-121.81245, 37.20117], [-121.8126, 37.20131], [-121.81271, 37.20132], [-121.81301, 37.20142], [-121.8131, 37.20143], [-121.81321, 37.20142], [-121.81348, 37.20134], [-121.8136, 37.20132], [-121.81395, 37.20131], [-121.8143, 37.20138], [-121.8146, 37.20141], [-121.81485, 37.20147], [-121.81501, 37.20154], [-121.8151, 37.2016], [-121.81519, 37.20174], [-121.81519, 37.20185], [-121.81516, 37.20204], [-121.81519, 37.2022], [-121.81519, 37.20232], [-121.81526, 37.20236], [-121.81549, 37.20241], [-121.81587, 37.20247], [-121.81605, 37.20258], [-121.81656, 37.20267], [-121.81683, 37.20302], [-121.81685, 37.20327], [-121.81702, 37.20341], [-121.81719, 37.20341], [-121.81751, 37.20365], [-121.8177, 37.20385], [-121.81774, 37.20393], [-121.81767, 37.20414], [-121.81803, 37.20437], [-121.81815, 37.2046], [-121.81838, 37.20478], [-121.81887, 37.20489], [-121.81919, 37.20512], [-121.81935, 37.2054], [-121.81973, 37.20546], [-121.81996, 37.20547], [-121.82044, 37.20538], [-121.82112, 37.2058], [-121.82143, 37.20584], [-121.82155, 37.20593], [-121.82157, 37.20611], [-121.82185, 37.20655], [-121.82209, 37.20662], [-121.8226, 37.20661], [-121.82344, 37.2071], [-121.82366, 37.20708]]]]} | Open Access 1 | 17433 | Los Alamitos / Calero Creek Parkchain | 21470 | 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.912 | Los Alamitos / Calero Creek Parkchain | None 872 | |||
9852 | 9852 | 9851 | {"type": "Polygon", "coordinates": [[[-121.94125, 37.30332], [-121.94129, 37.30339], [-121.94138, 37.30343], [-121.94151, 37.30339], [-121.943, 37.30339], [-121.94305, 37.30341], [-121.94307, 37.30345], [-121.94307, 37.30376], [-121.94308, 37.30507], [-121.94307, 37.3051], [-121.94302, 37.30512], [-121.94091, 37.30513], [-121.94087, 37.30332], [-121.94125, 37.30332]]]} | Open Access 1 | 16855 | Hamann | 19612 | 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 | 9.248 | Hamann | 1995 | None 854 | ||
9830 | 9830 | 9829 | {"type": "Polygon", "coordinates": [[[-121.77734, 37.33532], [-121.7775, 37.33536], [-121.77767, 37.33537], [-121.78, 37.33491], [-121.78007, 37.33492], [-121.7801, 37.33494], [-121.78071, 37.3368], [-121.7808, 37.337], [-121.78079, 37.33705], [-121.7806, 37.33716], [-121.78053, 37.33722], [-121.78019, 37.33766], [-121.78011, 37.33774], [-121.7793, 37.33844], [-121.77925, 37.33845], [-121.77523, 37.33574], [-121.77734, 37.33532]]]} | Open Access 1 | 16792 | Groesbeck Hill | 19527 | 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 | 25.426 | Groesbeck Hill | 1992 | None 851 |
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]);