units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
65 rows where MNG_AGENCY = 167 and MNG_AG_TYP = 2 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: GAP_STS
DES_TP 7
- Local Park 37
- Local Recreation Area 23
- Local Conservation Area 1
- Local Other or Unknown 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency · 65 ✖
MNG_AGENCY 1
- Davis, City of · 65 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4098 | 4098 | 4097 | {"type": "Polygon", "coordinates": [[[-121.78125, 38.55388], [-121.78121, 38.55395], [-121.77637, 38.55395], [-121.77637, 38.55388], [-121.78125, 38.55388]]]} | Open Access 1 | 47210 | Arroyo Greenbelt | 30916 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 0.808 | Arroyo Greenbelt | 0 | Local Recreation Area 3 | 4 | |
10958 | 10958 | 10957 | {"type": "Polygon", "coordinates": [[[-121.77799, 38.55534], [-121.77775, 38.55534], [-121.77774, 38.55503], [-121.77687, 38.55503], [-121.77686, 38.55534], [-121.77574, 38.55534], [-121.77573, 38.55531], [-121.77329, 38.55532], [-121.77308, 38.55532], [-121.77276, 38.55536], [-121.7727, 38.55533], [-121.77255, 38.55504], [-121.77236, 38.55479], [-121.77216, 38.55461], [-121.77188, 38.55442], [-121.77241, 38.55385], [-121.77637, 38.55388], [-121.77637, 38.55495], [-121.77781, 38.55495], [-121.77799, 38.55509], [-121.77799, 38.55534]]]} | Open Access 1 | 21017 | Arroyo Park | 15614 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 15.084 | Arroyo Park | 0 | Local Park 2 | 4 | |
14556 | 14556 | 14555 | {"type": "MultiPolygon", "coordinates": [[[[-121.77075, 38.55383], [-121.77074, 38.55405], [-121.77071, 38.55409], [-121.77067, 38.5541], [-121.76873, 38.5541], [-121.76862, 38.55409], [-121.7685, 38.55412], [-121.76845, 38.5542], [-121.76847, 38.55431], [-121.76851, 38.55518], [-121.76855, 38.55629], [-121.76853, 38.55638], [-121.76855, 38.55643], [-121.76861, 38.5565], [-121.76861, 38.55709], [-121.76856, 38.55714], [-121.76855, 38.55719], [-121.76858, 38.55728], [-121.76861, 38.55788], [-121.76865, 38.55821], [-121.7687, 38.55839], [-121.76879, 38.55855], [-121.76892, 38.5587], [-121.7691, 38.55884], [-121.76891, 38.55909], [-121.76924, 38.55924], [-121.76964, 38.55934], [-121.76986, 38.55934], [-121.76985, 38.56071], [-121.76971, 38.5607], [-121.76972, 38.55948], [-121.76959, 38.55948], [-121.76915, 38.55935], [-121.76866, 38.55917], [-121.76853, 38.55857], [-121.76845, 38.55795], [-121.76842, 38.55753], [-121.76837, 38.55611], [-121.76739, 38.5561], [-121.76739, 38.55605], [-121.76837, 38.55605], [-121.76828, 38.5538], [-121.77075, 38.55383]]], [[[-121.77241, 38.55385], [-121.77188, 38.55442], [-121.77167, 38.55431], [-121.77144, 38.55422], [-121.771, 38.55411], [-121.77096, 38.55409], [-121.77094, 38.55405], [-121.77096, 38.55383], [-121.77241, 38.55385]]], [[[-121.77882, 38.55686], [-121.7788, 38.55693], [-121.77857, 38.55693], [-121.77837, 38.55718], [-121.77841, 38.55743], [-121.77847, 38.55748], [-121.77845, 38.55757], [-121.77834, 38.55757], [-121.77827, 38.55786], [-121.77831, 38.55814], [-121.77842, 38.55818], [-121.7784, 38.55827], [-121.77818, 38.55823], [-121.77794, 38.55841], [-121.7778, 38.5587], [-121.7779, 38.55876], [-121.77786, 38.55884], [-121.77779, 38.55883], [-121.77762, 38.55912], [-121.77748, 38.55939], [-121.77711, 38.55934], [-121.77712, 38.55902], [-121.77752, 38.55848], [-121.77749, 38.55822], [-121.77754, 38.55822], [-121.77758, 38.55819], [-121.77761, 38.5581], [-121.77772, 38.55809], [-121.7778, 38.55781], [-121.77784, 38.55755], [-121.77773, 38.55749], [-121.77777, 38.5574], [-121.77789, 38.5574], [-121.7781, 38.55715], [-121.77812, 38.55687], [-121.77802, 38.55682], [-121.77805, 38.55671], [-121.77817, 38.5567], [-121.77822, 38.55642], [-121.77801, 38.55635], [-121.77796, 38.55606], [-121.77775, 38.55602], [-121.77777, 38.55595], [-121.77789, 38.55592], [-121.7779, 38.55557], [-121.77836, 38.55557], [-121.77836, 38.55602], [-121.77848, 38.5561], [-121.77841, 38.55612], [-121.77839, 38.55616], [-121.77839, 38.55626], [-121.77843, 38.55631], [-121.77847, 38.55659], [-121.77855, 38.55679], [-121.77882, 38.55686]]], [[[-121.7834, 38.55407], [-121.78332, 38.55407], [-121.7833, 38.554], [-121.78325, 38.55398], [-121.78319, 38.55398], [-121.78305, 38.55404], [-121.78293, 38.55406], [-121.7828, 38.55405], [-121.78253, 38.55396], [-121.78237, 38.55394], [-121.78211, 38.55394], [-121.78203, 38.55396], [-121.78191, 38.55404], [-121.78184, 38.55411], [-121.78183, 38.55418], [-121.78184, 38.55478], [-121.78181, 38.555], [-121.78184, 38.55529], [-121.78183, 38.55568], [-121.78186, 38.55583], [-121.78188, 38.55605], [-121.78185, 38.55655], [-121.78186, 38.5566], [-121.78183, 38.55739], [-121.782, 38.55761], [-121.78217, 38.55793], [-121.78216, 38.55801], [-121.78224, 38.55808], [-121.78231, 38.55808], [-121.78244, 38.55814], [-121.78254, 38.55822], [-121.78262, 38.55833], [-121.78263, 38.55838], [-121.78261, 38.55844], [-121.78249, 38.55861], [-121.78251, 38.55877], [-121.78257, 38.55886], [-121.78258, 38.55911], [-121.7826, 38.55919], [-121.78281, 38.55964], [-121.78288, 38.55983], [-121.78293, 38.5601], [-121.78297, 38.56021], [-121.78296, 38.56095], [-121.78286, 38.56095], [-121.78286, 38.56021], [-121.78231, 38.55974], [-121.78214, 38.55975], [-121.78238, 38.55921], [-121.78196, 38.5592], [-121.78192, 38.55887], [-121.78188, 38.55877], [-121.78219, 38.55859], [-121.78195, 38.55837], [-121.78188, 38.55806], [-121.7818, 38.55803], [-121.7818, 38.55794], [-121.78186, 38.55791], [-121.78186, 38.55761], [-121.78171, 38.55761], [-121.78166, 38.55731], [-121.7814, 38.55725], [-121.78143, 38.55717], [-121.78168, 38.55712], [-121.78168, 38.55639], [-121.78149, 38.55634], [-121.78149, 38.55629], [-121.78162, 38.55625], [-121.78168, 38.55598], [-121.78169, 38.55388], [-121.78155, 38.55387], [-121.78163, 38.55371], [-121.78205, 38.5538], [-121.78245, 38.55385], [-121.7827, 38.55387], [-121.7834, 38.55387], [-121.7834, 38.55407]]]]} | Open Access 1 | 47211 | Aspen Greenbelt | 30917 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 15.944 | Aspen Greenbelt | 0 | Local Recreation Area 3 | 4 | |
4099 | 4099 | 4098 | {"type": "Polygon", "coordinates": [[[-121.71938, 38.54626], [-121.71797, 38.54658], [-121.71751, 38.54664], [-121.71526, 38.54715], [-121.71524, 38.54707], [-121.71633, 38.54682], [-121.71628, 38.5467], [-121.71624, 38.54667], [-121.71627, 38.54659], [-121.71764, 38.54644], [-121.71754, 38.54613], [-121.71761, 38.54612], [-121.71773, 38.54643], [-121.71792, 38.54641], [-121.71932, 38.54609], [-121.71938, 38.54626]]]} | Open Access 1 | 47212 | Benbow Greenbelt | 30918 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 1.845 | Benbow Greenbelt | 0 | Local Recreation Area 3 | 4 | |
10920 | 10920 | 10919 | {"type": "Polygon", "coordinates": [[[-121.73627, 38.55082], [-121.73586, 38.55084], [-121.73586, 38.54976], [-121.73598, 38.55013], [-121.73622, 38.55068], [-121.73627, 38.55082]]]} | Open Access 1 | 21006 | Cedar Park | 16997 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 0.504 | Cedar Park | 0 | Local Park 2 | 4 | |
5113 | 5113 | 5112 | {"type": "Polygon", "coordinates": [[[-121.74523, 38.54626], [-121.74471, 38.54656], [-121.74447, 38.5466], [-121.7438, 38.54423], [-121.74462, 38.54409], [-121.74523, 38.54626]]]} | Open Access 1 | 21023 | Central Park | 17052 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 4.734 | Central Park | 0 | Local Park 2 | 4 | |
10931 | 10931 | 10930 | {"type": "Polygon", "coordinates": [[[-121.7307, 38.55559], [-121.73068, 38.55666], [-121.73065, 38.557], [-121.72907, 38.55708], [-121.72892, 38.55553], [-121.7307, 38.55559]]]} | Open Access 1 | 20953 | Chestnut Park | 17181 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 5.973 | Chestnut Park | 0 | Local Park 2 | 4 | |
10950 | 10950 | 10949 | {"type": "Polygon", "coordinates": [[[-121.66761, 38.50903], [-121.66749, 38.51313], [-121.66497, 38.51297], [-121.66318, 38.51277], [-121.66045, 38.51271], [-121.65954, 38.51294], [-121.65672, 38.51276], [-121.65346, 38.5129], [-121.65108, 38.51278], [-121.64908, 38.51319], [-121.64908, 38.51269], [-121.64902, 38.50869], [-121.64915, 38.50598], [-121.6492, 38.50439], [-121.65837, 38.50448], [-121.65825, 38.50894], [-121.66761, 38.50903]]]} | Open Access 1 | 20991 | City of Davis | 17307 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 272.095 | City of Davis | None 956 | |||
16980 | 16980 | 16979 | {"type": "Polygon", "coordinates": [[[-121.74766, 38.54637], [-121.74766, 38.54705], [-121.74714, 38.54705], [-121.74712, 38.54786], [-121.74715, 38.54787], [-121.74714, 38.54863], [-121.74764, 38.54864], [-121.74764, 38.54923], [-121.74653, 38.54925], [-121.74642, 38.54856], [-121.74605, 38.54859], [-121.74588, 38.54762], [-121.74559, 38.54661], [-121.7456, 38.54661], [-121.74561, 38.54647], [-121.74565, 38.54641], [-121.74597, 38.54636], [-121.74766, 38.54637]]]} | Open Access 1 | 21021 | Civic Center Park | 17355 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 9.582 | Civic Ctr. Park | 0 | Local Park 2 | 4 | |
10891 | 10891 | 10890 | {"type": "Polygon", "coordinates": [[[-121.75127, 38.54762], [-121.75021, 38.54761], [-121.75021, 38.54761], [-121.75024, 38.54751], [-121.75032, 38.54742], [-121.7507, 38.5472], [-121.75085, 38.54718], [-121.75111, 38.54725], [-121.75118, 38.5473], [-121.75124, 38.54744], [-121.75127, 38.54762]]]} | Open Access 1 | 21022 | College Park | 17507 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 0.816 | College Park | 0 | Local Park 2 | 4 | |
13770 | 13770 | 13769 | {"type": "Polygon", "coordinates": [[[-121.74826, 38.55606], [-121.74817, 38.56059], [-121.74496, 38.56056], [-121.74498, 38.56001], [-121.74496, 38.55976], [-121.74492, 38.55951], [-121.74484, 38.55926], [-121.74473, 38.55902], [-121.74464, 38.55887], [-121.74379, 38.55764], [-121.74366, 38.55735], [-121.74354, 38.55702], [-121.74445, 38.55683], [-121.74457, 38.55718], [-121.74466, 38.55735], [-121.74535, 38.55842], [-121.74712, 38.55844], [-121.74716, 38.55673], [-121.74702, 38.55631], [-121.74826, 38.55606]]]} | Open Access 1 | 36310 | Community Park | 30904 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://cityofdavis.org/Home/Components/FacilityDirectory/FacilityDirectory/26/2926?npage=2 | Yolo 33 | 26.954 | Community Park | 0 | Local Park 2 | 4 |
14549 | 14549 | 14548 | {"type": "MultiPolygon", "coordinates": [[[[-121.75068, 38.56327], [-121.74874, 38.56403], [-121.74888, 38.56429], [-121.74926, 38.56487], [-121.74864, 38.56511], [-121.74843, 38.56443], [-121.74833, 38.56436], [-121.74835, 38.56432], [-121.74836, 38.56425], [-121.74824, 38.56384], [-121.7482, 38.5638], [-121.74813, 38.56374], [-121.74819, 38.56366], [-121.74786, 38.56264], [-121.74784, 38.5626], [-121.74778, 38.56254], [-121.74767, 38.5625], [-121.74759, 38.5625], [-121.74742, 38.562], [-121.74753, 38.56198], [-121.74755, 38.56087], [-121.74821, 38.56088], [-121.74819, 38.56208], [-121.74821, 38.56226], [-121.74826, 38.56243], [-121.74831, 38.56256], [-121.74843, 38.56271], [-121.74857, 38.56284], [-121.74874, 38.56295], [-121.74897, 38.56304], [-121.74918, 38.5631], [-121.74943, 38.56312], [-121.74964, 38.56311], [-121.74988, 38.56306], [-121.75007, 38.56299], [-121.75038, 38.56283], [-121.75052, 38.56308], [-121.75068, 38.56327]]], [[[-121.74943, 38.56881], [-121.74936, 38.56883], [-121.74918, 38.56826], [-121.74902, 38.56829], [-121.74901, 38.56826], [-121.74916, 38.56822], [-121.74897, 38.56763], [-121.74882, 38.56765], [-121.74881, 38.56762], [-121.74896, 38.56758], [-121.74878, 38.56699], [-121.74862, 38.56702], [-121.74861, 38.56699], [-121.74876, 38.56695], [-121.74869, 38.56673], [-121.74874, 38.56664], [-121.74943, 38.56881]]], [[[-121.7583, 38.56405], [-121.75829, 38.56457], [-121.75666, 38.56456], [-121.75632, 38.56482], [-121.75632, 38.56495], [-121.75638, 38.56501], [-121.75673, 38.56501], [-121.75671, 38.56506], [-121.75639, 38.56506], [-121.75631, 38.56511], [-121.7563, 38.56569], [-121.75637, 38.56575], [-121.75672, 38.56575], [-121.75672, 38.5658], [-121.75637, 38.5658], [-121.7563, 38.56585], [-121.75629, 38.56646], [-121.75636, 38.56652], [-121.75671, 38.56652], [-121.75671, 38.56657], [-121.75636, 38.56657], [-121.75629, 38.56662], [-121.75628, 38.56721], [-121.75635, 38.56727], [-121.7567, 38.56727], [-121.7567, 38.56732], [-121.75635, 38.56732], [-121.75628, 38.56737], [-121.75627, 38.568], [-121.7559, 38.568], [-121.75567, 38.56797], [-121.75536, 38.56788], [-121.7556, 38.56769], [-121.75576, 38.56749], [-121.75584, 38.56735], [-121.75587, 38.56723], [-121.75589, 38.56698], [-121.75587, 38.56683], [-121.75581, 38.56669], [-121.75553, 38.56623], [-121.75593, 38.56607], [-121.75598, 38.56602], [-121.75598, 38.56596], [-121.75588, 38.5658], [-121.75581, 38.56578], [-121.75581, 38.5657], [-121.75573, 38.56563], [-121.75576, 38.56556], [-121.75562, 38.56534], [-121.75594, 38.5652], [-121.75599, 38.56516], [-121.75599, 38.5651], [-121.75589, 38.56494], [-121.75581, 38.56492], [-121.7558, 38.56484], [-121.75572, 38.56477], [-121.75576, 38.5647], [-121.75561, 38.56448], [-121.75579, 38.56441], [-121.75584, 38.56436], [-121.75584, 38.56429], [-121.75574, 38.56414], [-121.75565, 38.56412], [-121.75563, 38.56403], [-121.75556, 38.56398], [-121.75559, 38.56391], [-121.75531, 38.56348], [-121.75522, 38.56346], [-121.75521, 38.56338], [-121.75513, 38.56332], [-121.75517, 38.56325], [-121.75507, 38.5631], [-121.75501, 38.56306], [-121.75493, 38.56307], [-121.75455, 38.56322], [-121.7544, 38.56299], [-121.75434, 38.56297], [-121.75434, 38.56289], [-121.75429, 38.56284], [-121.75424, 38.56281], [-121.75426, 38.56276], [-121.75416, 38.5626], [-121.75409, 38.56256], [-121.75402, 38.56257], [-121.75306, 38.56294], [-121.75251, 38.56271], [-121.75243, 38.56271], [-121.75236, 38.56275], [-121.75223, 38.56296], [-121.75205, 38.5629], [-121.75189, 38.56289], [-121.75175, 38.56289], [-121.75159, 38.56292], [-121.75136, 38.56303], [-121.75108, 38.56328], [-121.75102, 38.5633], [-121.75098, 38.56329], [-121.7509, 38.56322], [-121.75074, 38.56304], [-121.75064, 38.56289], [-121.75056, 38.56273], [-121.75109, 38.56273], [-121.75344, 38.56243], [-121.75417, 38.56239], [-121.75472, 38.56248], [-121.75476, 38.56245], [-121.75477, 38.56218], [-121.75488, 38.5618], [-121.75509, 38.56187], [-121.75529, 38.56197], [-121.75508, 38.56223], [-121.75508, 38.56255], [-121.75589, 38.56382], [-121.75601, 38.56385], [-121.75627, 38.56375], [-121.75629, 38.56365], [-121.7564, 38.56363], [-121.75645, 38.56358], [-121.75646, 38.56353], [-121.75651, 38.56352], [-121.75661, 38.56346], [-121.75671, 38.56355], [-121.75663, 38.56372], [-121.75653, 38.56372], [-121.75644, 38.56377], [-121.75642, 38.56383], [-121.75643, 38.56388], [-121.7561, 38.564], [-121.75606, 38.56409], [-121.75617, 38.56426], [-121.758, 38.56428], [-121.7583, 38.56405]]]]} | Open Access 1 | 47209 | Covell Greenbelt | 30915 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 22.201 | Covell Greenbelt | 0 | Local Recreation Area 3 | 4 | |
10932 | 10932 | 10931 | {"type": "Polygon", "coordinates": [[[-121.7502, 38.56635], [-121.74882, 38.56689], [-121.74845, 38.56575], [-121.74862, 38.56571], [-121.74873, 38.56563], [-121.7488, 38.56567], [-121.74882, 38.56566], [-121.74864, 38.56511], [-121.74926, 38.56487], [-121.7502, 38.56635]]]} | Open Access 1 | 20957 | Covell Park | 17723 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 4.726 | Covell Park | 0 | Local Park 2 | 4 | |
15720 | 15720 | 15719 | {"type": "Polygon", "coordinates": [[[-121.78192, 38.58316], [-121.7819, 38.58498], [-121.77782, 38.58494], [-121.77757, 38.58543], [-121.77653, 38.58543], [-121.77641, 38.59019], [-121.77351, 38.59018], [-121.77377, 38.58982], [-121.77414, 38.58934], [-121.77443, 38.58886], [-121.77478, 38.58821], [-121.77493, 38.58764], [-121.77499, 38.58733], [-121.77501, 38.58716], [-121.77501, 38.58649], [-121.77494, 38.5859], [-121.77483, 38.58458], [-121.77476, 38.58417], [-121.7724, 38.58485], [-121.77241, 38.58459], [-121.77222, 38.58458], [-121.77139, 38.58485], [-121.77148, 38.58517], [-121.7713, 38.5857], [-121.77016, 38.58608], [-121.7696, 38.58629], [-121.76877, 38.58668], [-121.769, 38.58699], [-121.76926, 38.58707], [-121.77016, 38.58729], [-121.77066, 38.58738], [-121.77094, 38.58749], [-121.77105, 38.58755], [-121.77148, 38.58782], [-121.77204, 38.58828], [-121.77228, 38.58854], [-121.77233, 38.5887], [-121.77233, 38.58884], [-121.77192, 38.58894], [-121.77101, 38.58876], [-121.76934, 38.58902], [-121.76875, 38.58875], [-121.76853, 38.58862], [-121.76833, 38.58848], [-121.76824, 38.5884], [-121.76808, 38.58823], [-121.76794, 38.58804], [-121.76783, 38.58785], [-121.76772, 38.5876], [-121.7677, 38.58744], [-121.76761, 38.58499], [-121.76762, 38.58292], [-121.76904, 38.58293], [-121.76904, 38.58251], [-121.76765, 38.5825], [-121.76803, 38.57833], [-121.76812, 38.57619], [-121.76813, 38.57567], [-121.77666, 38.57575], [-121.7766, 38.5831], [-121.78192, 38.58316]]]} | Restricted Access 2 | 47226 | Davis Municipal Golf Course | 33121 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 264.528 | Davis Municipal GC | 0 | Local Recreation Area 3 | 4 | |
10933 | 10933 | 10932 | {"type": "Polygon", "coordinates": [[[-121.64543, 38.58948], [-121.63841, 38.58953], [-121.63129, 38.58946], [-121.63131, 38.58253], [-121.63156, 38.58084], [-121.63183, 38.58003], [-121.63258, 38.57849], [-121.63329, 38.57731], [-121.63423, 38.5762], [-121.6349, 38.57544], [-121.63534, 38.57532], [-121.63556, 38.57529], [-121.63601, 38.57532], [-121.63644, 38.57548], [-121.63674, 38.57566], [-121.63742, 38.57615], [-121.63776, 38.57626], [-121.63805, 38.5764], [-121.63835, 38.57647], [-121.63858, 38.57649], [-121.63928, 38.57661], [-121.64007, 38.57663], [-121.64366, 38.57663], [-121.64405, 38.57668], [-121.64434, 38.57677], [-121.64464, 38.57694], [-121.64491, 38.57715], [-121.64512, 38.57745], [-121.64521, 38.57777], [-121.64497, 38.58825], [-121.64504, 38.5886], [-121.64513, 38.58894], [-121.64543, 38.58948]]]} | Restricted Access 2 | 20958 | Davis Wetland Demonstration | 17955 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 419.626 | Davis Wetland Demonstration | None 954 | |||
10934 | 10934 | 10933 | {"type": "Polygon", "coordinates": [[[-121.7412, 38.54418], [-121.74079, 38.54425], [-121.74073, 38.54406], [-121.74114, 38.54399], [-121.7412, 38.54418]]]} | Open Access 1 | 20959 | E Street Plaza | 18332 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 0.202 | E Street Plaza | 0 | Local Park 2 | 4 | |
14557 | 14557 | 14556 | {"type": "MultiPolygon", "coordinates": [[[[-121.67936, 38.55228], [-121.67935, 38.55268], [-121.67861, 38.55267], [-121.67861, 38.55228], [-121.67936, 38.55228]]], [[[-121.68049, 38.55046], [-121.67988, 38.55046], [-121.67975, 38.55089], [-121.67968, 38.5512], [-121.67963, 38.55122], [-121.6796, 38.55125], [-121.67959, 38.55136], [-121.67939, 38.55176], [-121.67938, 38.55214], [-121.67882, 38.55214], [-121.67889, 38.55184], [-121.67889, 38.55147], [-121.67894, 38.55142], [-121.67894, 38.55132], [-121.67898, 38.55132], [-121.67926, 38.5508], [-121.67926, 38.55044], [-121.68017, 38.55004], [-121.68025, 38.55008], [-121.68042, 38.55032], [-121.68049, 38.55046]]], [[[-121.68048, 38.5497], [-121.67992, 38.54995], [-121.67961, 38.54948], [-121.67922, 38.54964], [-121.67915, 38.54952], [-121.67911, 38.54952], [-121.67909, 38.54909], [-121.68024, 38.5491], [-121.68034, 38.54941], [-121.68048, 38.5497]]]]} | Open Access 1 | 47213 | Ell Macero Estates Greenbelt | 30919 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 5.466 | Ell Macero Estates Greenbelt | 0 | Local Recreation Area 3 | 4 | |
14545 | 14545 | 14544 | {"type": "Polygon", "coordinates": [[[-121.77383, 38.5573], [-121.77383, 38.5575], [-121.77378, 38.55751], [-121.77378, 38.55777], [-121.77381, 38.5578], [-121.77377, 38.55785], [-121.77376, 38.5579], [-121.77378, 38.55798], [-121.77378, 38.55834], [-121.77376, 38.55843], [-121.77378, 38.55849], [-121.77383, 38.55853], [-121.77381, 38.55855], [-121.77381, 38.55887], [-121.77283, 38.55887], [-121.77251, 38.55901], [-121.77232, 38.5588], [-121.77195, 38.55846], [-121.77355, 38.55846], [-121.77355, 38.55826], [-121.77347, 38.55821], [-121.77349, 38.55818], [-121.77349, 38.55809], [-121.77344, 38.55804], [-121.77348, 38.558], [-121.77348, 38.55781], [-121.77352, 38.5578], [-121.77352, 38.55758], [-121.77346, 38.55755], [-121.77347, 38.55744], [-121.77345, 38.5574], [-121.7735, 38.55737], [-121.7735, 38.55689], [-121.77342, 38.55684], [-121.77345, 38.55677], [-121.77343, 38.55668], [-121.77344, 38.55607], [-121.77346, 38.55599], [-121.77343, 38.55592], [-121.77335, 38.55587], [-121.77338, 38.55582], [-121.77336, 38.55558], [-121.77376, 38.55558], [-121.77376, 38.55582], [-121.77378, 38.55584], [-121.77376, 38.55588], [-121.77376, 38.55597], [-121.7738, 38.55602], [-121.77378, 38.55604], [-121.77378, 38.55646], [-121.77381, 38.55649], [-121.77378, 38.55653], [-121.77378, 38.55663], [-121.77381, 38.55667], [-121.77378, 38.55669], [-121.77378, 38.55689], [-121.7738, 38.5569], [-121.7738, 38.55709], [-121.77383, 38.55712], [-121.77381, 38.55715], [-121.7738, 38.55725], [-121.77383, 38.5573]]]} | Open Access 1 | 47214 | Evergreen Greenbelt | 30920 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 3.898 | Evergreen Greenbelt | 0 | Local Recreation Area 3 | 4 | |
14558 | 14558 | 14557 | {"type": "MultiPolygon", "coordinates": [[[[-121.72669, 38.56278], [-121.72667, 38.56291], [-121.72632, 38.56289], [-121.72565, 38.56301], [-121.72563, 38.56296], [-121.7253, 38.56302], [-121.72533, 38.56293], [-121.72544, 38.56287], [-121.72669, 38.56278]]], [[[-121.72959, 38.56262], [-121.72958, 38.56286], [-121.72931, 38.56289], [-121.72924, 38.56275], [-121.7289, 38.56277], [-121.72891, 38.56301], [-121.72896, 38.56304], [-121.72892, 38.5631], [-121.72886, 38.56312], [-121.72879, 38.56311], [-121.72887, 38.56285], [-121.72886, 38.56284], [-121.72852, 38.56279], [-121.72818, 38.56285], [-121.72823, 38.56306], [-121.72805, 38.56309], [-121.72801, 38.56286], [-121.72773, 38.56289], [-121.72772, 38.56291], [-121.72728, 38.56297], [-121.72724, 38.56275], [-121.72959, 38.56262]]], [[[-121.72895, 38.56364], [-121.72894, 38.56369], [-121.72889, 38.56364], [-121.72862, 38.56361], [-121.72849, 38.56345], [-121.72826, 38.56353], [-121.72806, 38.56365], [-121.72799, 38.564], [-121.72791, 38.564], [-121.72792, 38.56373], [-121.72752, 38.56372], [-121.72749, 38.56397], [-121.72721, 38.56401], [-121.72714, 38.5638], [-121.72688, 38.56385], [-121.72655, 38.56395], [-121.72642, 38.56395], [-121.72641, 38.56389], [-121.72618, 38.56389], [-121.72609, 38.56405], [-121.72601, 38.56395], [-121.72597, 38.56383], [-121.726, 38.56361], [-121.72663, 38.56357], [-121.72666, 38.56376], [-121.72701, 38.56373], [-121.72696, 38.56336], [-121.727, 38.56335], [-121.72704, 38.56335], [-121.72704, 38.56362], [-121.72797, 38.56366], [-121.72801, 38.56354], [-121.72817, 38.56351], [-121.72822, 38.56336], [-121.72817, 38.56318], [-121.72837, 38.56315], [-121.72833, 38.56339], [-121.7286, 38.56343], [-121.72883, 38.56354], [-121.72895, 38.56364]]], [[[-121.72799, 38.56491], [-121.72791, 38.56495], [-121.72795, 38.56517], [-121.72763, 38.5652], [-121.72759, 38.56492], [-121.72764, 38.56487], [-121.72775, 38.56492], [-121.72794, 38.56491], [-121.72797, 38.5649], [-121.72795, 38.56457], [-121.72777, 38.56443], [-121.7276, 38.56442], [-121.72724, 38.56452], [-121.72723, 38.56454], [-121.72731, 38.56473], [-121.72737, 38.56475], [-121.72733, 38.5648], [-121.72727, 38.56483], [-121.72726, 38.56483], [-121.72718, 38.56462], [-121.72685, 38.56469], [-121.72691, 38.56489], [-121.72686, 38.56487], [-121.72683, 38.56484], [-121.7268, 38.56457], [-121.72712, 38.56452], [-121.72715, 38.56449], [-121.72712, 38.56439], [-121.72761, 38.56433], [-121.72761, 38.56434], [-121.72797, 38.56444], [-121.72799, 38.56491]]], [[[-121.72667, 38.56458], [-121.7264, 38.5646], [-121.7264, 38.5649], [-121.7263, 38.56485], [-121.72635, 38.56478], [-121.72635, 38.5646], [-121.72594, 38.56459], [-121.72593, 38.56479], [-121.72608, 38.56492], [-121.72608, 38.565], [-121.72597, 38.56504], [-121.72595, 38.56529], [-121.7259, 38.56529], [-121.72565, 38.56447], [-121.72562, 38.56446], [-121.72569, 38.56442], [-121.72581, 38.56442], [-121.72581, 38.56447], [-121.72604, 38.56448], [-121.72608, 38.56421], [-121.72612, 38.56422], [-121.7261, 38.5645], [-121.72657, 38.56454], [-121.72664, 38.56445], [-121.72667, 38.56458]]]]} | Open Access 1 | 47215 | Green Meadows Greenbelt | 30921 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 4.217 | Green Meadows Greenbelt | 0 | Local Recreation Area 3 | 4 | |
439 | 439 | 438 | {"type": "Polygon", "coordinates": [[[-121.7605, 38.56573], [-121.7605, 38.56632], [-121.75984, 38.56631], [-121.75985, 38.56573], [-121.7605, 38.56573]]]} | Open Access 1 | 21013 | Hacienda Park | 19586 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 0.923 | Hacienda Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);