units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
44 rows where MNG_AGENCY = 31 sorted by map
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2026 | 2026 | 2025 | {"type": "MultiPolygon", "coordinates": [[[[-121.86485, 37.65969], [-121.86436, 37.66029], [-121.86268, 37.65941], [-121.86144, 37.65906], [-121.86041, 37.65887], [-121.85917, 37.65829], [-121.85695, 37.65625], [-121.85736, 37.65603], [-121.85769, 37.656], [-121.85819, 37.6561], [-121.85944, 37.65643], [-121.85967, 37.65676], [-121.85967, 37.657], [-121.8596, 37.65735], [-121.85966, 37.6577], [-121.85988, 37.65806], [-121.86025, 37.6583], [-121.86059, 37.6584], [-121.86167, 37.65848], [-121.86245, 37.65865], [-121.86485, 37.65969]]], [[[-121.86892, 37.66161], [-121.86819, 37.66187], [-121.86792, 37.66173], [-121.86756, 37.66176], [-121.86727, 37.66196], [-121.8676, 37.6623], [-121.86806, 37.6625], [-121.86787, 37.66301], [-121.86671, 37.663], [-121.86685, 37.66151], [-121.86892, 37.66161]]]]} | Open Access 1 | 15472 | Kottinger Park | 20720 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 20.027 | Kottinger Park | 0 | Local Park 2 | 4 | |
6741 | 6741 | 6740 | {"type": "MultiPolygon", "coordinates": [[[[-121.87194, 37.64739], [-121.87184, 37.64769], [-121.87168, 37.64784], [-121.87161, 37.64812], [-121.87143, 37.64811], [-121.87124, 37.64811], [-121.87109, 37.64787], [-121.87092, 37.64767], [-121.87067, 37.64752], [-121.87044, 37.64734], [-121.86941, 37.64669], [-121.86909, 37.64642], [-121.86933, 37.64636], [-121.86961, 37.64634], [-121.87065, 37.64645], [-121.8706, 37.64677], [-121.87138, 37.64686], [-121.8716, 37.64691], [-121.8716, 37.64693], [-121.87176, 37.64705], [-121.87187, 37.64719], [-121.87194, 37.64739]]], [[[-121.87319, 37.65007], [-121.87297, 37.65046], [-121.87262, 37.65034], [-121.87256, 37.65055], [-121.87075, 37.64993], [-121.87068, 37.64995], [-121.87046, 37.65015], [-121.87027, 37.65039], [-121.8702, 37.65037], [-121.87017, 37.65033], [-121.87018, 37.6503], [-121.87068, 37.64963], [-121.87078, 37.64946], [-121.87091, 37.64906], [-121.87095, 37.64884], [-121.87097, 37.64865], [-121.87093, 37.64838], [-121.87098, 37.64834], [-121.87129, 37.64827], [-121.87147, 37.64827], [-121.87169, 37.64831], [-121.87189, 37.6484], [-121.87203, 37.6485], [-121.8721, 37.64859], [-121.87217, 37.64869], [-121.87225, 37.64898], [-121.87229, 37.64906], [-121.87236, 37.64915], [-121.87246, 37.64923], [-121.87259, 37.6493], [-121.87274, 37.64935], [-121.87285, 37.64937], [-121.87276, 37.64976], [-121.87314, 37.64979], [-121.87313, 37.64985], [-121.87307, 37.64992], [-121.87306, 37.64997], [-121.87311, 37.65004], [-121.87319, 37.65007]]]]} | Open Access 1 | 5080 | Mission Hills Park | 22300 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 13.718 | Mission Hills Park | 1999 | Local Park 2 | 4 | |
13757 | 13757 | 13756 | {"type": "Polygon", "coordinates": [[[-121.84934, 37.67753], [-121.84925, 37.67858], [-121.8483, 37.67911], [-121.84787, 37.67968], [-121.84777, 37.67993], [-121.84555, 37.67995], [-121.84497, 37.67734], [-121.84513, 37.67742], [-121.84562, 37.67737], [-121.84614, 37.67698], [-121.8464, 37.67694], [-121.84669, 37.67707], [-121.84666, 37.67735], [-121.84681, 37.67764], [-121.84772, 37.67721], [-121.84827, 37.67712], [-121.84934, 37.67753]]]} | Open Access 1 | 36272 | Pleasanton holding 3 | 23806 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 22.762 | Pleasanton holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13916 | 13916 | 13915 | {"type": "Polygon", "coordinates": [[[-121.85023, 37.68137], [-121.84817, 37.68139], [-121.84815, 37.67994], [-121.84777, 37.67993], [-121.84787, 37.67968], [-121.8483, 37.67911], [-121.84925, 37.67858], [-121.84933, 37.67753], [-121.84827, 37.67712], [-121.84772, 37.67721], [-121.8468, 37.67765], [-121.84666, 37.67735], [-121.84669, 37.67707], [-121.8464, 37.67694], [-121.84614, 37.67698], [-121.84562, 37.67737], [-121.84513, 37.67742], [-121.84497, 37.67734], [-121.84477, 37.67645], [-121.8468, 37.67577], [-121.85001, 37.67585], [-121.85023, 37.68137]]]} | Open Access 1 | 36529 | Pleasanton holding 4 | 23807 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 32.765 | Pleasanton holding 4 | 0 | Local Other or Unknown 14 | 4 | |
9231 | 9231 | 9230 | {"type": "Polygon", "coordinates": [[[-121.85036, 37.65762], [-121.84964, 37.65799], [-121.84955, 37.65798], [-121.84914, 37.65786], [-121.84905, 37.6582], [-121.84875, 37.65815], [-121.84864, 37.65811], [-121.84855, 37.65812], [-121.84834, 37.65768], [-121.84763, 37.65711], [-121.84817, 37.65719], [-121.8486, 37.65721], [-121.84898, 37.65717], [-121.84946, 37.65708], [-121.84975, 37.65705], [-121.84979, 37.65744], [-121.85021, 37.65742], [-121.85036, 37.65762]]]} | Open Access 1 | 15478 | Vintage Hills Park | 27146 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 3.86 | Vintage Hills Park | 0 | Local Park 2 | 4 | |
9289 | 9289 | 9288 | {"type": "Polygon", "coordinates": [[[-121.85656, 37.66294], [-121.85641, 37.66331], [-121.85608, 37.66315], [-121.85569, 37.66322], [-121.85554, 37.66342], [-121.8556, 37.66364], [-121.85545, 37.66393], [-121.85512, 37.66409], [-121.85492, 37.66412], [-121.8546, 37.66419], [-121.85432, 37.66405], [-121.85418, 37.66405], [-121.85397, 37.66408], [-121.85398, 37.6634], [-121.85656, 37.66294]]]} | Open Access 1 | 15475 | Tawny Park | 26198 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 3.542 | Tawny Park | 0 | Local Park 2 | 4 | |
11569 | 11569 | 11568 | {"type": "Polygon", "coordinates": [[[-121.85913, 37.66996], [-121.85864, 37.67006], [-121.85845, 37.66932], [-121.85888, 37.66925], [-121.85913, 37.66996]]]} | Open Access 1 | 23664 | BMX Facility | 16201 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 0.847 | BMX Facility | None 1030 | |||
8525 | 8525 | 8524 | {"type": "Polygon", "coordinates": [[[-121.85977, 37.69562], [-121.85969, 37.69728], [-121.85872, 37.6973], [-121.85841, 37.69714], [-121.85853, 37.69673], [-121.85848, 37.69604], [-121.85861, 37.69577], [-121.85907, 37.69559], [-121.85977, 37.69562]]]} | Open Access 1 | 15392 | Meadows Park | 22098 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 4.869 | Meadows Park | 0 | Local Park 2 | 4 | |
13781 | 13781 | 13780 | {"type": "Polygon", "coordinates": [[[-121.86242, 37.67993], [-121.86223, 37.67999], [-121.86182, 37.68021], [-121.86175, 37.68021], [-121.86156, 37.68003], [-121.8614, 37.67992], [-121.8612, 37.67984], [-121.86096, 37.67978], [-121.86097, 37.67923], [-121.86135, 37.67899], [-121.86162, 37.67876], [-121.86169, 37.67876], [-121.86172, 37.67878], [-121.86149, 37.67898], [-121.8621, 37.67943], [-121.86221, 37.67955], [-121.86234, 37.67986], [-121.86242, 37.67993]]]} | Open Access 1 | 36328 | Pleasanton holding 1 | 23804 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 2.66 | Pleasanton holding 1 | 0 | Local Other or Unknown 14 | 4 | |
9195 | 9195 | 9194 | {"type": "Polygon", "coordinates": [[[-121.86303, 37.69199], [-121.8629, 37.6922], [-121.8628, 37.6923], [-121.86266, 37.69239], [-121.86203, 37.69274], [-121.86193, 37.69277], [-121.86118, 37.69275], [-121.8612, 37.69125], [-121.86234, 37.69122], [-121.86232, 37.69131], [-121.86235, 37.69137], [-121.86245, 37.69143], [-121.86241, 37.69195], [-121.86303, 37.69199]]]} | Open Access 1 | 15262 | Amaral Park | 15436 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 4.917 | Amaral Park | 0 | Local Park 2 | 4 | |
9286 | 9286 | 9285 | {"type": "Polygon", "coordinates": [[[-121.86652, 37.65941], [-121.86612, 37.66004], [-121.86508, 37.65957], [-121.86553, 37.65894], [-121.86652, 37.65941]]]} | Open Access 1 | 15469 | McKinley Park | 22047 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 2.047 | McKinley Park | 0 | Local Park 2 | 4 | |
15703 | 15703 | 15702 | {"type": "Polygon", "coordinates": [[[-121.8681, 37.62662], [-121.86809, 37.62949], [-121.86746, 37.62949], [-121.86738, 37.62958], [-121.86719, 37.62974], [-121.86701, 37.62999], [-121.86704, 37.63011], [-121.86705, 37.63038], [-121.86702, 37.63046], [-121.86704, 37.63053], [-121.86733, 37.63117], [-121.86725, 37.63132], [-121.86735, 37.63136], [-121.86744, 37.63156], [-121.86696, 37.63156], [-121.86695, 37.63157], [-121.86761, 37.63321], [-121.86754, 37.63324], [-121.86752, 37.63323], [-121.86725, 37.63257], [-121.86693, 37.63267], [-121.86653, 37.63313], [-121.86542, 37.63362], [-121.86487, 37.63389], [-121.86502, 37.63417], [-121.86474, 37.63427], [-121.86444, 37.63433], [-121.86278, 37.63494], [-121.86129, 37.63491], [-121.86113, 37.63488], [-121.86098, 37.63481], [-121.86096, 37.63476], [-121.86101, 37.63462], [-121.86103, 37.6345], [-121.86102, 37.63427], [-121.86164, 37.63401], [-121.86159, 37.63348], [-121.86117, 37.63345], [-121.86142, 37.63313], [-121.86168, 37.63309], [-121.86172, 37.6331], [-121.86217, 37.63287], [-121.86227, 37.63264], [-121.86263, 37.63207], [-121.86196, 37.63105], [-121.86149, 37.6305], [-121.86094, 37.6296], [-121.8606, 37.62883], [-121.86034, 37.62882], [-121.8604, 37.62867], [-121.86042, 37.62853], [-121.86031, 37.62774], [-121.86034, 37.62758], [-121.86041, 37.6274], [-121.86028, 37.62735], [-121.8602, 37.6275], [-121.86012, 37.62748], [-121.85898, 37.62797], [-121.8579, 37.6265], [-121.85797, 37.62603], [-121.85819, 37.62589], [-121.85848, 37.62587], [-121.85881, 37.62594], [-121.85907, 37.62586], [-121.85927, 37.62573], [-121.86018, 37.62572], [-121.86054, 37.6257], [-121.86062, 37.62557], [-121.86053, 37.62523], [-121.86079, 37.62515], [-121.86085, 37.62494], [-121.86101, 37.62492], [-121.86109, 37.62488], [-121.86128, 37.62499], [-121.8615, 37.62527], [-121.86166, 37.62542], [-121.86172, 37.62559], [-121.86173, 37.62574], [-121.86216, 37.62596], [-121.86288, 37.6265], [-121.8632, 37.6266], [-121.86336, 37.62669], [-121.86347, 37.62673], [-121.86363, 37.62674], [-121.8637, 37.62672], [-121.86374, 37.62667], [-121.8637, 37.62657], [-121.86319, 37.62626], [-121.86305, 37.626], [-121.863, 37.62595], [-121.86294, 37.62586], [-121.86297, 37.62583], [-121.86306, 37.62567], [-121.86313, 37.62561], [-121.8633, 37.62559], [-121.86351, 37.62565], [-121.86358, 37.62564], [-121.86364, 37.62561], [-121.86368, 37.62557], [-121.86369, 37.6255], [-121.86372, 37.62542], [-121.86377, 37.62535], [-121.86395, 37.62528], [-121.86401, 37.62528], [-121.86409, 37.62533], [-121.86419, 37.62535], [-121.86429, 37.62545], [-121.86443, 37.62544], [-121.86454, 37.62545], [-121.86472, 37.62555], [-121.8648, 37.62584], [-121.86506, 37.62594], [-121.86516, 37.62602], [-121.86544, 37.62616], [-121.86554, 37.62628], [-121.86574, 37.62626], [-121.86579, 37.62627], [-121.86595, 37.62662], [-121.86594, 37.62664], [-121.86606, 37.6268], [-121.86624, 37.62694], [-121.86628, 37.627], [-121.86632, 37.62717], [-121.86635, 37.62719], [-121.86642, 37.6272], [-121.86662, 37.62711], [-121.8668, 37.62705], [-121.86686, 37.62702], [-121.86685, 37.62699], [-121.86696, 37.62693], [-121.86718, 37.62701], [-121.86712, 37.62739], [-121.86706, 37.62751], [-121.86716, 37.62766], [-121.86728, 37.62769], [-121.86727, 37.62785], [-121.86722, 37.62798], [-121.867, 37.62835], [-121.86685, 37.6285], [-121.86686, 37.62852], [-121.86691, 37.62854], [-121.86719, 37.6283], [-121.86731, 37.62823], [-121.86747, 37.62785], [-121.86763, 37.62771], [-121.86774, 37.62743], [-121.86791, 37.62731], [-121.868, 37.62701], [-121.86804, 37.62665], [-121.8681, 37.62662]], [[-121.86232, 37.63345], [-121.86167, 37.63343], [-121.8617, 37.63379], [-121.86179, 37.63397], [-121.8621, 37.63405], [-121.86235, 37.63398], [-121.86249, 37.6339], [-121.86248, 37.63351], [-121.86232, 37.63345]], [[-121.86638, 37.62876], [-121.86627, 37.62874], [-121.86603, 37.62888], [-121.86602, 37.62867], [-121.86589, 37.62847], [-121.86563, 37.62841], [-121.86526, 37.62842], [-121.86519, 37.62857], [-121.86521, 37.62865], [-121.86511, 37.62889], [-121.86535, 37.62917], [-121.86549, 37.6291], [-121.86562, 37.6291], [-121.86579, 37.62903], [-121.86584, 37.62932], [-121.866, 37.62918], [-121.86652, 37.62896], [-121.86638, 37.62876]]]} | Restricted Access 2 | 23675 | Callippe Preserve Golf Course | 33079 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 130.046 | Callippe Preserve GC | 0 | Local Recreation Area 3 | 4 | |
9211 | 9211 | 9210 | {"type": "Polygon", "coordinates": [[[-121.87206, 37.68809], [-121.87038, 37.68876], [-121.8697, 37.6881], [-121.87007, 37.68773], [-121.87022, 37.68738], [-121.87023, 37.68721], [-121.87084, 37.68715], [-121.87099, 37.68721], [-121.87112, 37.68723], [-121.87206, 37.68809]]]} | Open Access 1 | 15408 | Nielsen Park | 22755 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 5.222 | Nielsen Park | 0 | Local Park 2 | 4 | |
1993 | 1993 | 1992 | {"type": "Polygon", "coordinates": [[[-121.87403, 37.65996], [-121.87324, 37.66069], [-121.87298, 37.66051], [-121.87377, 37.65978], [-121.87403, 37.65996]]]} | Open Access 1 | 15277 | Lions Wayside Park | 21328 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 0.804 | Lions Wayside Park | 0 | Local Park 2 | 4 | |
9254 | 9254 | 9253 | {"type": "Polygon", "coordinates": [[[-121.87408, 37.67782], [-121.87375, 37.67788], [-121.8736, 37.6778], [-121.87339, 37.67784], [-121.87336, 37.67786], [-121.8733, 37.67785], [-121.87308, 37.67789], [-121.87306, 37.67792], [-121.873, 37.67797], [-121.87297, 37.67802], [-121.87264, 37.67807], [-121.87262, 37.67805], [-121.87226, 37.67811], [-121.87219, 37.67808], [-121.87212, 37.67808], [-121.87182, 37.67814], [-121.87169, 37.67823], [-121.87165, 37.67824], [-121.87145, 37.67841], [-121.87145, 37.67844], [-121.8714, 37.67848], [-121.87136, 37.67849], [-121.87116, 37.67866], [-121.87115, 37.6787], [-121.87087, 37.67893], [-121.86969, 37.67807], [-121.86968, 37.67804], [-121.86969, 37.678], [-121.87006, 37.6777], [-121.87021, 37.67763], [-121.87036, 37.67759], [-121.87076, 37.6776], [-121.87091, 37.67768], [-121.87137, 37.6777], [-121.87152, 37.67761], [-121.87223, 37.67763], [-121.87227, 37.67761], [-121.87233, 37.67764], [-121.87244, 37.67766], [-121.87247, 37.67768], [-121.87277, 37.67769], [-121.8728, 37.67767], [-121.87294, 37.67765], [-121.87301, 37.6776], [-121.87304, 37.67754], [-121.87306, 37.67717], [-121.87303, 37.6771], [-121.87297, 37.67705], [-121.87306, 37.67679], [-121.8733, 37.67682], [-121.87362, 37.67683], [-121.87368, 37.67684], [-121.87372, 37.67687], [-121.87408, 37.67782]]]} | Open Access 1 | 15410 | Orloff Park | 23205 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 7.69 | Orloff Park | 0 | Local Park 2 | 4 | |
9282 | 9282 | 9281 | {"type": "Polygon", "coordinates": [[[-121.87494, 37.65914], [-121.87422, 37.6598], [-121.87396, 37.65962], [-121.87468, 37.65896], [-121.87494, 37.65914]]]} | Open Access 1 | 15463 | Delucchi Park | 18079 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 0.731 | Delucchi Park | 0 | Local Park 2 | 4 | |
1991 | 1991 | 1990 | {"type": "Polygon", "coordinates": [[[-121.87537, 37.65526], [-121.87412, 37.65639], [-121.87282, 37.65549], [-121.87259, 37.65569], [-121.87194, 37.65524], [-121.87305, 37.65422], [-121.87363, 37.65459], [-121.87398, 37.65478], [-121.87442, 37.65495], [-121.87537, 37.65526]]]} | Open Access 1 | 15274 | Upper Pleasanton Field | 26734 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 8.259 | Upper Pleasanton Field | 0 | Local Recreation Area 3 | 4 | |
2013 | 2013 | 2012 | {"type": "Polygon", "coordinates": [[[-121.87635, 37.69208], [-121.87563, 37.69288], [-121.87564, 37.69337], [-121.87559, 37.69353], [-121.87547, 37.6937], [-121.8738, 37.69475], [-121.87393, 37.69503], [-121.87355, 37.69523], [-121.87289, 37.69542], [-121.87251, 37.69486], [-121.87209, 37.69482], [-121.87166, 37.69507], [-121.87158, 37.69525], [-121.87212, 37.69579], [-121.8716, 37.69617], [-121.87091, 37.69587], [-121.87017, 37.69592], [-121.87008, 37.6963], [-121.87007, 37.69656], [-121.8699, 37.69673], [-121.86981, 37.69706], [-121.86997, 37.69734], [-121.87024, 37.69742], [-121.8706, 37.69737], [-121.87081, 37.69744], [-121.8704, 37.69789], [-121.86975, 37.69748], [-121.86966, 37.69676], [-121.86936, 37.69661], [-121.86885, 37.69673], [-121.86857, 37.69682], [-121.86816, 37.69684], [-121.86819, 37.69652], [-121.86806, 37.6963], [-121.86778, 37.69616], [-121.86738, 37.69625], [-121.867, 37.69651], [-121.86656, 37.69662], [-121.86596, 37.69661], [-121.86596, 37.69631], [-121.86674, 37.69624], [-121.86765, 37.69602], [-121.86817, 37.69605], [-121.86848, 37.69651], [-121.86895, 37.69654], [-121.86933, 37.69626], [-121.86943, 37.69582], [-121.86989, 37.69563], [-121.87036, 37.69566], [-121.87064, 37.69553], [-121.87091, 37.6952], [-121.8713, 37.69503], [-121.87162, 37.69482], [-121.87294, 37.69437], [-121.87335, 37.69412], [-121.87374, 37.69442], [-121.87406, 37.69442], [-121.87426, 37.69434], [-121.8744, 37.69422], [-121.87446, 37.69411], [-121.87444, 37.69391], [-121.8743, 37.69371], [-121.8749, 37.69344], [-121.87482, 37.6932], [-121.87504, 37.69311], [-121.8755, 37.69271], [-121.8754, 37.69178], [-121.87586, 37.69186], [-121.87635, 37.69208]]]} | Open Access 1 | 15395 | Fairlands Park | 18801 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 15.577 | Fairlands Park | 0 | Local Park 2 | 4 | |
9452 | 9452 | 9451 | {"type": "Polygon", "coordinates": [[[-121.87721, 37.67438], [-121.87705, 37.6744], [-121.87693, 37.67448], [-121.87685, 37.67458], [-121.87492, 37.67454], [-121.87477, 37.67435], [-121.87417, 37.67454], [-121.87339, 37.67466], [-121.87279, 37.67287], [-121.87277, 37.67231], [-121.87485, 37.67227], [-121.87479, 37.67327], [-121.87616, 37.67387], [-121.87718, 37.67366], [-121.87721, 37.67438]]]} | Open Access 1 | 15809 | Amador Valley Community Park | 15435 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 14.984 | Amador Valley Community Park | 0 | Local Park 2 | 4 | |
9265 | 9265 | 9264 | {"type": "Polygon", "coordinates": [[[-121.87743, 37.66136], [-121.87705, 37.66208], [-121.87682, 37.66199], [-121.87683, 37.66197], [-121.87682, 37.66193], [-121.87705, 37.66136], [-121.87711, 37.66126], [-121.87743, 37.66136]]]} | Open Access 1 | 15455 | Veterans Plaza | 27060 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 0.595 | Veterans Plaza | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);