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 descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14536 | 14536 | 14535 | {"type": "Polygon", "coordinates": [[[-121.70244, 38.54454], [-121.70243, 38.54488], [-121.7019, 38.54488], [-121.70188, 38.5448], [-121.70188, 38.54471], [-121.70185, 38.54466], [-121.70208, 38.54454], [-121.70244, 38.54454]]]} | Open Access 1 | 47204 | Woodbridge Park | 30909 | 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/80/2926?npage=7 | Yolo 33 | 0.435 | Woodbridge Park | 0 | Local Park 2 | 4 |
14763 | 14763 | 14762 | {"type": "MultiPolygon", "coordinates": [[[[-121.69816, 38.54261], [-121.69816, 38.54299], [-121.69704, 38.54306], [-121.69666, 38.54307], [-121.69633, 38.54309], [-121.69635, 38.54251], [-121.69684, 38.54242], [-121.69688, 38.54217], [-121.69684, 38.54211], [-121.69696, 38.54206], [-121.69699, 38.54202], [-121.69699, 38.54199], [-121.69694, 38.5419], [-121.69717, 38.54182], [-121.69714, 38.54141], [-121.69708, 38.54133], [-121.69735, 38.54138], [-121.6973, 38.54148], [-121.69736, 38.54181], [-121.69763, 38.54208], [-121.6978, 38.54243], [-121.6981, 38.54249], [-121.69811, 38.54257], [-121.69816, 38.54261]]], [[[-121.69744, 38.54052], [-121.6974, 38.54056], [-121.69741, 38.54092], [-121.6974, 38.54128], [-121.69724, 38.54124], [-121.69727, 38.54115], [-121.69731, 38.54086], [-121.69728, 38.54059], [-121.69723, 38.54049], [-121.69744, 38.54052]]]]} | Open Access 1 | 47225 | Willowbank Greenbelt | 30932 | 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.058 | Willowbank Greenbelt | 0 | Local Recreation Area 3 | 4 | |
10949 | 10949 | 10948 | {"type": "Polygon", "coordinates": [[[-121.70677, 38.54671], [-121.70675, 38.54698], [-121.7067, 38.54723], [-121.70665, 38.54741], [-121.70659, 38.54746], [-121.70654, 38.54746], [-121.70604, 38.54738], [-121.70546, 38.54733], [-121.70502, 38.54734], [-121.70456, 38.5474], [-121.70451, 38.54738], [-121.70447, 38.54734], [-121.70443, 38.54715], [-121.7044, 38.54689], [-121.70436, 38.54675], [-121.70431, 38.54665], [-121.70413, 38.54637], [-121.70448, 38.54638], [-121.70482, 38.54641], [-121.70547, 38.54642], [-121.70556, 38.5467], [-121.70677, 38.54671]]]} | Open Access 1 | 20989 | Willow Creek Park | 27576 | 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.64 | Willow Creek Park | 0 | Local Park 2 | 4 | |
14543 | 14543 | 14542 | {"type": "MultiPolygon", "coordinates": [[[[-121.70616, 38.54509], [-121.7061, 38.5451], [-121.70585, 38.54531], [-121.70559, 38.54531], [-121.70546, 38.54538], [-121.70536, 38.54562], [-121.70566, 38.54571], [-121.70566, 38.54576], [-121.70545, 38.54581], [-121.70547, 38.54642], [-121.70515, 38.54641], [-121.70515, 38.54616], [-121.70507, 38.5461], [-121.70509, 38.54605], [-121.70509, 38.54596], [-121.70507, 38.54592], [-121.70521, 38.54583], [-121.70522, 38.54558], [-121.70517, 38.54531], [-121.70511, 38.54526], [-121.70512, 38.54522], [-121.70512, 38.54513], [-121.70526, 38.54508], [-121.70535, 38.54483], [-121.70513, 38.54478], [-121.70487, 38.54479], [-121.7048, 38.54463], [-121.70458, 38.5445], [-121.70457, 38.54442], [-121.70469, 38.54424], [-121.70473, 38.54404], [-121.70467, 38.54378], [-121.70462, 38.54376], [-121.7046, 38.54363], [-121.70456, 38.54359], [-121.70459, 38.54355], [-121.70452, 38.54319], [-121.70511, 38.54307], [-121.70521, 38.54338], [-121.70526, 38.54341], [-121.70523, 38.54347], [-121.70525, 38.54357], [-121.70516, 38.54365], [-121.70524, 38.54391], [-121.70505, 38.54409], [-121.70504, 38.54419], [-121.70538, 38.54426], [-121.70538, 38.54432], [-121.70525, 38.54434], [-121.70506, 38.54444], [-121.70505, 38.54446], [-121.70517, 38.54458], [-121.70536, 38.54466], [-121.70559, 38.54468], [-121.70591, 38.54466], [-121.70604, 38.54491], [-121.70616, 38.54497], [-121.70616, 38.54509]]], [[[-121.70764, 38.54947], [-121.70707, 38.5496], [-121.70697, 38.54932], [-121.70709, 38.54923], [-121.70722, 38.54901], [-121.7072, 38.54886], [-121.70715, 38.54874], [-121.70701, 38.54839], [-121.70705, 38.54825], [-121.70704, 38.54812], [-121.70701, 38.548], [-121.70695, 38.54793], [-121.7068, 38.54782], [-121.70623, 38.54769], [-121.7058, 38.54762], [-121.70546, 38.54759], [-121.70512, 38.54759], [-121.70503, 38.5476], [-121.70499, 38.54764], [-121.70503, 38.54781], [-121.70496, 38.54794], [-121.70489, 38.54792], [-121.70495, 38.54781], [-121.7049, 38.54756], [-121.70527, 38.54753], [-121.70572, 38.54756], [-121.70625, 38.54764], [-121.70675, 38.54775], [-121.70711, 38.54782], [-121.70719, 38.54817], [-121.70727, 38.54837], [-121.70747, 38.54873], [-121.70763, 38.54914], [-121.70762, 38.5492], [-121.70757, 38.54925], [-121.70764, 38.54947]]], [[[-121.71191, 38.54653], [-121.71191, 38.54679], [-121.71163, 38.54678], [-121.71162, 38.54662], [-121.71018, 38.5466], [-121.70932, 38.54681], [-121.70884, 38.54688], [-121.7083, 38.54689], [-121.70763, 38.5468], [-121.70747, 38.5468], [-121.70703, 38.54691], [-121.70699, 38.54708], [-121.70694, 38.54706], [-121.70692, 38.54702], [-121.70694, 38.54676], [-121.70695, 38.54654], [-121.70697, 38.5465], [-121.70703, 38.54648], [-121.70703, 38.5467], [-121.70781, 38.54671], [-121.70793, 38.54664], [-121.70794, 38.54649], [-121.70804, 38.54649], [-121.70804, 38.54664], [-121.70816, 38.54671], [-121.70927, 38.54673], [-121.71004, 38.54653], [-121.71005, 38.54652], [-121.71162, 38.54654], [-121.71176, 38.54659], [-121.71183, 38.54658], [-121.71191, 38.54653]]]]} | Open Access 1 | 47208 | Willow Creek Greenbelt | 30914 | 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 | 7.485 | Willow Creek Greenbelt | 0 | Local Recreation Area 3 | 4 | |
8012 | 8012 | 8011 | {"type": "Polygon", "coordinates": [[[-121.71434, 38.56981], [-121.71412, 38.56993], [-121.71347, 38.56998], [-121.71348, 38.56937], [-121.71412, 38.56937], [-121.71419, 38.56958], [-121.71434, 38.56981]]]} | Open Access 1 | 20988 | Wildhorse Mini Park | 27515 | 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.015 | Wildhorse MP | 0 | Local Park 2 | 4 | |
14770 | 14770 | 14769 | {"type": "MultiPolygon", "coordinates": [[[[-121.72117, 38.56338], [-121.72114, 38.5641], [-121.72074, 38.56408], [-121.72027, 38.5641], [-121.72029, 38.56345], [-121.72048, 38.56343], [-121.72047, 38.56393], [-121.72097, 38.56394], [-121.721, 38.5634], [-121.72117, 38.56338]]], [[[-121.71872, 38.56464], [-121.71856, 38.56477], [-121.7185, 38.56478], [-121.71833, 38.56466], [-121.71812, 38.56446], [-121.71795, 38.56421], [-121.71787, 38.56403], [-121.71782, 38.56389], [-121.7178, 38.5638], [-121.71781, 38.56373], [-121.71784, 38.56367], [-121.71789, 38.56361], [-121.71797, 38.56356], [-121.71804, 38.56354], [-121.7181, 38.56388], [-121.71822, 38.56415], [-121.71832, 38.56429], [-121.71845, 38.56443], [-121.71872, 38.56464]]], [[[-121.71839, 38.56491], [-121.71838, 38.56495], [-121.7182, 38.56513], [-121.7179, 38.56491], [-121.71768, 38.56468], [-121.7175, 38.56444], [-121.71738, 38.5642], [-121.71729, 38.56395], [-121.71724, 38.56361], [-121.71742, 38.56362], [-121.71751, 38.56367], [-121.71757, 38.56371], [-121.71761, 38.5638], [-121.71766, 38.56397], [-121.71772, 38.56415], [-121.71786, 38.56439], [-121.71807, 38.56464], [-121.71837, 38.56489], [-121.71839, 38.56491]]], [[[-121.72107, 38.56484], [-121.72107, 38.56484], [-121.72106, 38.56528], [-121.72098, 38.56525], [-121.72098, 38.56483], [-121.72107, 38.56484]]], [[[-121.72224, 38.56479], [-121.72189, 38.56553], [-121.72173, 38.56548], [-121.72187, 38.56519], [-121.72177, 38.5651], [-121.72182, 38.565], [-121.72196, 38.56499], [-121.72209, 38.56472], [-121.72224, 38.56479]]], [[[-121.73055, 38.56875], [-121.73054, 38.5689], [-121.73016, 38.56889], [-121.73012, 38.56886], [-121.72977, 38.56885], [-121.72962, 38.56877], [-121.7294, 38.56877], [-121.72915, 38.56875], [-121.72889, 38.56871], [-121.72867, 38.56864], [-121.72865, 38.56862], [-121.72868, 38.56856], [-121.72844, 38.56846], [-121.72827, 38.56837], [-121.72797, 38.56816], [-121.72776, 38.56794], [-121.72761, 38.5677], [-121.72739, 38.56776], [-121.72725, 38.56746], [-121.72723, 38.56735], [-121.72707, 38.56718], [-121.72695, 38.56715], [-121.72689, 38.56709], [-121.72692, 38.56698], [-121.72672, 38.56676], [-121.7264, 38.56654], [-121.72631, 38.56655], [-121.72629, 38.56651], [-121.72619, 38.56645], [-121.72611, 38.56643], [-121.72609, 38.56636], [-121.72558, 38.56605], [-121.72561, 38.56602], [-121.72566, 38.56589], [-121.72565, 38.56585], [-121.7256, 38.56581], [-121.72565, 38.56575], [-121.72549, 38.5652], [-121.7255, 38.56517], [-121.72549, 38.56508], [-121.72546, 38.56504], [-121.7254, 38.56502], [-121.72542, 38.56497], [-121.72535, 38.56471], [-121.72387, 38.56491], [-121.72362, 38.5651], [-121.72332, 38.56491], [-121.72234, 38.56446], [-121.72257, 38.5641], [-121.72262, 38.5639], [-121.72255, 38.56336], [-121.72208, 38.5633], [-121.72289, 38.56323], [-121.72297, 38.56391], [-121.72294, 38.5641], [-121.72285, 38.5643], [-121.7235, 38.56456], [-121.72366, 38.5646], [-121.72382, 38.56462], [-121.72561, 38.56446], [-121.72551, 38.56408], [-121.72515, 38.56415], [-121.72514, 38.56408], [-121.72549, 38.56401], [-121.72533, 38.56343], [-121.72541, 38.56344], [-121.72547, 38.56372], [-121.72545, 38.56373], [-121.72557, 38.56415], [-121.7258, 38.56413], [-121.72581, 38.56415], [-121.72572, 38.56417], [-121.72569, 38.56442], [-121.72564, 38.56445], [-121.72609, 38.56592], [-121.72658, 38.56629], [-121.72692, 38.56611], [-121.7273, 38.56664], [-121.72712, 38.5667], [-121.72711, 38.56672], [-121.72755, 38.5672], [-121.72758, 38.56741], [-121.72765, 38.56763], [-121.72777, 38.56784], [-121.72794, 38.56805], [-121.72815, 38.56823], [-121.72837, 38.56837], [-121.72861, 38.56848], [-121.72885, 38.56856], [-121.72921, 38.56863], [-121.72959, 38.56864], [-121.72978, 38.56873], [-121.73055, 38.56875]]], [[[-121.72765, 38.57011], [-121.7267, 38.57063], [-121.72673, 38.57092], [-121.7264, 38.571], [-121.72656, 38.57079], [-121.72654, 38.57039], [-121.72688, 38.57045], [-121.72738, 38.57017], [-121.72751, 38.57004], [-121.72765, 38.57011]]]]} | Open Access 1 | 47224 | Wildhorse Greenbelt | 30931 | 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 | 11.975 | Wildhorse Greenbelt | 0 | Local Recreation Area 3 | 4 | |
10948 | 10948 | 10947 | {"type": "Polygon", "coordinates": [[[-121.79276, 38.55281], [-121.79186, 38.55291], [-121.7918, 38.55291], [-121.79176, 38.55286], [-121.79166, 38.55227], [-121.79266, 38.55227], [-121.79276, 38.55281]]]} | Open Access 1 | 20986 | Whaleback Park | 27447 | 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.432 | Whaleback Park | 0 | Local Park 2 | 4 | |
10952 | 10952 | 10951 | {"type": "Polygon", "coordinates": [[[-121.77368, 38.55052], [-121.77361, 38.5506], [-121.77359, 38.55067], [-121.77363, 38.55084], [-121.77361, 38.55168], [-121.77198, 38.55166], [-121.77196, 38.55161], [-121.77198, 38.55014], [-121.77364, 38.55016], [-121.77363, 38.55048], [-121.77368, 38.55052]]]} | Open Access 1 | 21020 | Westwood Park | 27440 | 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 | 6.003 | Westwood Park | 0 | Local Park 2 | 4 | |
3055 | 3055 | 3054 | {"type": "Polygon", "coordinates": [[[-121.78648, 38.54919], [-121.78648, 38.55007], [-121.78525, 38.55004], [-121.78525, 38.54902], [-121.78605, 38.54902], [-121.78606, 38.54919], [-121.78648, 38.54919]]]} | Open Access 1 | 20984 | West Manor Park | 27367 | 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 | 2.883 | West Manor Park | 0 | Local Park 2 | 4 | |
10961 | 10961 | 10960 | {"type": "Polygon", "coordinates": [[[-121.72252, 38.53836], [-121.72229, 38.53842], [-121.72217, 38.53851], [-121.72191, 38.53846], [-121.72149, 38.53863], [-121.72146, 38.53867], [-121.72177, 38.53885], [-121.72175, 38.53891], [-121.72144, 38.53896], [-121.72139, 38.53899], [-121.72137, 38.53903], [-121.72162, 38.54114], [-121.71833, 38.54138], [-121.71802, 38.54142], [-121.71789, 38.54033], [-121.71847, 38.54033], [-121.72021, 38.5402], [-121.72022, 38.54019], [-121.71995, 38.53992], [-121.71998, 38.53988], [-121.72008, 38.53995], [-121.72033, 38.54006], [-121.72035, 38.54005], [-121.72008, 38.5378], [-121.71962, 38.53783], [-121.71955, 38.5379], [-121.71949, 38.53787], [-121.71952, 38.53779], [-121.71938, 38.5375], [-121.71895, 38.53766], [-121.71887, 38.5376], [-121.71916, 38.53739], [-121.71984, 38.53713], [-121.71992, 38.53693], [-121.71944, 38.53606], [-121.71926, 38.53596], [-121.71955, 38.53578], [-121.71974, 38.5361], [-121.71983, 38.53613], [-121.72008, 38.53604], [-121.72011, 38.53609], [-121.71986, 38.53618], [-121.71982, 38.53626], [-121.72015, 38.53684], [-121.72023, 38.53686], [-121.7204, 38.53678], [-121.72042, 38.53682], [-121.72046, 38.53686], [-121.72023, 38.53703], [-121.72053, 38.53762], [-121.72057, 38.53775], [-121.7206, 38.53804], [-121.72082, 38.53837], [-121.72106, 38.53857], [-121.72119, 38.53858], [-121.72151, 38.53845], [-121.72135, 38.53818], [-121.72136, 38.53813], [-121.72135, 38.53809], [-121.72129, 38.53803], [-121.72176, 38.53792], [-121.72177, 38.53797], [-121.72154, 38.5381], [-121.72152, 38.53818], [-121.72161, 38.53828], [-121.72183, 38.53833], [-121.72207, 38.53832], [-121.72227, 38.53829], [-121.72251, 38.53829], [-121.72252, 38.53836]]]} | Open Access 1 | 21025 | Walnut Park | 27240 | 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 | 18.307 | Walnut Park | 0 | Local Park 2 | 4 | |
14765 | 14765 | 14764 | {"type": "Polygon", "coordinates": [[[-121.71815, 38.54367], [-121.71806, 38.5437], [-121.7178, 38.54394], [-121.71777, 38.544], [-121.71748, 38.54417], [-121.7174, 38.54417], [-121.71695, 38.54438], [-121.71693, 38.54442], [-121.71683, 38.54441], [-121.7168, 38.54437], [-121.71646, 38.54437], [-121.71611, 38.54441], [-121.71608, 38.54449], [-121.71599, 38.54449], [-121.71597, 38.54442], [-121.71597, 38.54423], [-121.71602, 38.54425], [-121.71609, 38.54424], [-121.71612, 38.54431], [-121.71647, 38.54429], [-121.71681, 38.54429], [-121.71685, 38.5442], [-121.71697, 38.54419], [-121.71703, 38.54425], [-121.71737, 38.54409], [-121.71736, 38.54404], [-121.71769, 38.54392], [-121.7177, 38.54381], [-121.71776, 38.5438], [-121.71781, 38.54378], [-121.71784, 38.54374], [-121.71785, 38.54369], [-121.7181, 38.5436], [-121.71815, 38.54367]]]} | Open Access 1 | 47223 | Village Park Greenbelt | 30930 | 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.685 | Village Park Greenbelt | 0 | Local Recreation Area 3 | 4 | |
13788 | 13788 | 13787 | {"type": "Polygon", "coordinates": [[[-121.71597, 38.54423], [-121.71597, 38.54442], [-121.71563, 38.54442], [-121.71562, 38.54448], [-121.71527, 38.54448], [-121.71528, 38.54408], [-121.71532, 38.54404], [-121.71581, 38.54387], [-121.71586, 38.54387], [-121.7159, 38.5439], [-121.71594, 38.54398], [-121.71593, 38.54403], [-121.7159, 38.5441], [-121.7159, 38.54415], [-121.71593, 38.5442], [-121.71597, 38.54423]]]} | Open Access 1 | 36348 | Village Park | 30901 | 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/66/2926?npage=6 | Yolo 33 | 0.792 | Village Park | 0 | Local Park 2 | 4 |
10947 | 10947 | 10946 | {"type": "Polygon", "coordinates": [[[-121.73051, 38.54687], [-121.73035, 38.5469], [-121.73008, 38.54678], [-121.72995, 38.54676], [-121.72953, 38.54675], [-121.72911, 38.54675], [-121.72907, 38.54672], [-121.72877, 38.54679], [-121.72877, 38.54684], [-121.72873, 38.5469], [-121.72861, 38.54694], [-121.72851, 38.54693], [-121.72841, 38.54688], [-121.72781, 38.54701], [-121.72765, 38.54694], [-121.72759, 38.54688], [-121.72764, 38.54646], [-121.72756, 38.54626], [-121.72771, 38.54622], [-121.72773, 38.54643], [-121.7277, 38.54667], [-121.72771, 38.54683], [-121.72777, 38.5469], [-121.72784, 38.54691], [-121.72798, 38.54689], [-121.72798, 38.54681], [-121.72837, 38.54675], [-121.72845, 38.54667], [-121.72854, 38.54665], [-121.72867, 38.54667], [-121.72876, 38.54673], [-121.72905, 38.54663], [-121.72899, 38.5462], [-121.73041, 38.54597], [-121.73051, 38.54597], [-121.73051, 38.54687]]]} | Open Access 1 | 20981 | Toad Hollow Dog Park | 26379 | 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.147 | Toad Hollow Dog Park | 0 | Local Park 2 | 4 | |
10957 | 10957 | 10956 | {"type": "Polygon", "coordinates": [[[-121.76742, 38.55516], [-121.76738, 38.55617], [-121.76502, 38.55612], [-121.76505, 38.55511], [-121.76742, 38.55516]]]} | Open Access 1 | 21016 | Sycamore Park | 26133 | 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.732 | Sycamore Park | 0 | Local Park 2 | 4 | |
14540 | 14540 | 14539 | {"type": "MultiPolygon", "coordinates": [[[[-121.71844, 38.55656], [-121.71844, 38.55688], [-121.71773, 38.55687], [-121.71774, 38.55665], [-121.71778, 38.5566], [-121.718, 38.5566], [-121.71814, 38.55665], [-121.71829, 38.55666], [-121.71836, 38.55663], [-121.71837, 38.55656], [-121.71844, 38.55656]]], [[[-121.71989, 38.55189], [-121.71986, 38.55299], [-121.71958, 38.55298], [-121.71944, 38.55326], [-121.71936, 38.55325], [-121.71937, 38.55286], [-121.71952, 38.55285], [-121.71954, 38.55227], [-121.71889, 38.55225], [-121.7189, 38.55211], [-121.71989, 38.55189]]]]} | Open Access 1 | 47207 | Sunnyside Greenbelt | 30913 | 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.786 | Sunnyside Greenbelt | 0 | Local Recreation Area 3 | 4 | |
14764 | 14764 | 14763 | {"type": "Polygon", "coordinates": [[[-121.7222, 38.54324], [-121.72218, 38.54335], [-121.72124, 38.54324], [-121.72109, 38.54328], [-121.72099, 38.54337], [-121.72096, 38.54345], [-121.72096, 38.54352], [-121.72116, 38.54456], [-121.72122, 38.54469], [-121.72143, 38.54507], [-121.72084, 38.54531], [-121.72087, 38.54526], [-121.72089, 38.54519], [-121.72095, 38.54523], [-121.72125, 38.5451], [-121.72084, 38.54437], [-121.72079, 38.54404], [-121.72084, 38.54384], [-121.72083, 38.54365], [-121.72077, 38.54343], [-121.72043, 38.54346], [-121.72034, 38.54365], [-121.72025, 38.54366], [-121.7202, 38.5436], [-121.7198, 38.54357], [-121.71943, 38.54366], [-121.71938, 38.54377], [-121.71928, 38.54377], [-121.71923, 38.5438], [-121.71919, 38.54384], [-121.71844, 38.54401], [-121.71836, 38.54399], [-121.71836, 38.54393], [-121.71826, 38.54373], [-121.7182, 38.54371], [-121.71796, 38.5438], [-121.71807, 38.5437], [-121.71814, 38.54368], [-121.7181, 38.5436], [-121.71832, 38.54361], [-121.71845, 38.54387], [-121.71866, 38.54387], [-121.71904, 38.54379], [-121.71923, 38.54372], [-121.71924, 38.54371], [-121.71912, 38.54346], [-121.71902, 38.54342], [-121.71901, 38.54334], [-121.71946, 38.5432], [-121.71957, 38.54309], [-121.71962, 38.54314], [-121.71952, 38.54327], [-121.71955, 38.54352], [-121.71996, 38.54343], [-121.72022, 38.5434], [-121.72035, 38.54333], [-121.72083, 38.54328], [-121.72076, 38.54262], [-121.72069, 38.54242], [-121.72056, 38.54222], [-121.72049, 38.54162], [-121.72051, 38.54161], [-121.72048, 38.54138], [-121.72063, 38.54138], [-121.7207, 38.54135], [-121.72103, 38.54133], [-121.72109, 38.54135], [-121.72114, 38.54162], [-121.72123, 38.54187], [-121.72101, 38.54195], [-121.72089, 38.5424], [-121.72095, 38.54288], [-121.721, 38.54299], [-121.72109, 38.54306], [-121.72122, 38.54311], [-121.7222, 38.54324]]]} | Open Access 1 | 47222 | Southfield Greenbelt | 30929 | 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.378 | Southfield Greenbelt | 0 | Local Recreation Area 3 | 4 | |
3054 | 3054 | 3053 | {"type": "Polygon", "coordinates": [[[-121.69518, 38.5114], [-121.69508, 38.51983], [-121.68851, 38.52006], [-121.68757, 38.51999], [-121.68564, 38.51973], [-121.6857, 38.51651], [-121.68589, 38.51119], [-121.68639, 38.51123], [-121.68693, 38.51131], [-121.68724, 38.5115], [-121.68756, 38.51155], [-121.68808, 38.51159], [-121.68842, 38.51159], [-121.68891, 38.51151], [-121.68969, 38.51144], [-121.69076, 38.51144], [-121.6912, 38.51148], [-121.69175, 38.51148], [-121.69368, 38.51133], [-121.69441, 38.51133], [-121.69518, 38.5114]]]} | Open Access 1 | 20980 | South Fork Preserve | 25651 | 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 | 191.285 | South Fork Preserve | 0 | Local Conservation Area 4 | 2 | |
10946 | 10946 | 10945 | {"type": "Polygon", "coordinates": [[[-121.71743, 38.56174], [-121.71741, 38.56177], [-121.71737, 38.56179], [-121.71547, 38.56196], [-121.71531, 38.56018], [-121.71557, 38.56015], [-121.7155, 38.55939], [-121.71732, 38.55928], [-121.71749, 38.56118], [-121.71748, 38.56135], [-121.71743, 38.56159], [-121.71743, 38.56174]]]} | Open Access 1 | 20979 | Slide Hill Park | 25557 | 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 | 12.025 | Slide Hill Park | 0 | Local Park 2 | 4 | |
14741 | 14741 | 14740 | {"type": "Polygon", "coordinates": [[[-121.76135, 38.56357], [-121.76135, 38.56364], [-121.76102, 38.56364], [-121.76096, 38.56373], [-121.7609, 38.56372], [-121.76083, 38.56373], [-121.76077, 38.56363], [-121.76045, 38.56363], [-121.76043, 38.56417], [-121.7601, 38.56417], [-121.76004, 38.56426], [-121.75998, 38.56425], [-121.75991, 38.56426], [-121.75985, 38.56417], [-121.75952, 38.56417], [-121.7595, 38.56461], [-121.75855, 38.56462], [-121.75855, 38.56425], [-121.75915, 38.56425], [-121.75925, 38.56421], [-121.7594, 38.5641], [-121.75953, 38.56406], [-121.76017, 38.56407], [-121.76021, 38.56405], [-121.76023, 38.56401], [-121.76024, 38.56333], [-121.76023, 38.5633], [-121.7602, 38.56328], [-121.76021, 38.56327], [-121.76021, 38.56317], [-121.76047, 38.56317], [-121.76047, 38.56356], [-121.76135, 38.56357]]]} | Open Access 1 | 47221 | Seville Greenbelt | 30928 | 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.852 | Seville Greenbelt | 0 | Local Recreation Area 3 | 4 | |
10945 | 10945 | 10944 | {"type": "Polygon", "coordinates": [[[-121.72868, 38.56856], [-121.72865, 38.56862], [-121.72737, 38.56958], [-121.72715, 38.56937], [-121.72692, 38.56907], [-121.72654, 38.56832], [-121.72653, 38.56822], [-121.72646, 38.56814], [-121.72675, 38.56798], [-121.72678, 38.56792], [-121.72686, 38.56792], [-121.72697, 38.56786], [-121.72699, 38.56783], [-121.72707, 38.56785], [-121.72761, 38.5677], [-121.7278, 38.56798], [-121.72806, 38.56823], [-121.72833, 38.56841], [-121.72868, 38.56856]]]} | Open Access 1 | 20978 | Sandy Motley Park | 25026 | 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.251 | Sandy Motley 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]);