units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
65 rows where MNG_AGENCY = 167 sorted by MNG_AG_ID
This data as json, copyable, CSV (advanced)
DES_TP 4
- Local Park 23
- Local Recreation Area 20
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 45
MNG_AGENCY 1
- Davis, City of · 45 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10941 | 10941 | 10940 | {"type": "Polygon", "coordinates": [[[-121.73978, 38.57539], [-121.73963, 38.58321], [-121.73048, 38.58431], [-121.73066, 38.57532], [-121.73477, 38.57535], [-121.73478, 38.5755], [-121.73504, 38.5755], [-121.73505, 38.57536], [-121.73978, 38.57539]]]} | Open Access 1 | 20973 | Old Landfill | 23088 | 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 | 183.273 | Old Landfill | None 955 | |||
10942 | 10942 | 10941 | {"type": "Polygon", "coordinates": [[[-121.76656, 38.5479], [-121.76567, 38.54789], [-121.76516, 38.54781], [-121.76502, 38.54815], [-121.76448, 38.54798], [-121.76444, 38.54796], [-121.76443, 38.54793], [-121.76461, 38.54748], [-121.76465, 38.54747], [-121.76489, 38.54747], [-121.76495, 38.54745], [-121.765, 38.54741], [-121.76503, 38.54735], [-121.76504, 38.54722], [-121.76503, 38.54718], [-121.7657, 38.54695], [-121.7657, 38.54714], [-121.76625, 38.54714], [-121.76652, 38.54765], [-121.76645, 38.54771], [-121.76644, 38.54779], [-121.76646, 38.54782], [-121.76654, 38.54786], [-121.76656, 38.5479]]]} | Open Access 1 | 20974 | Oxford Circle Park | 23280 | 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.34 | Oxford Circle Park | 0 | Local Park 2 | 4 | |
10943 | 10943 | 10942 | {"type": "Polygon", "coordinates": [[[-121.71025, 38.54282], [-121.70863, 38.54241], [-121.70861, 38.54232], [-121.70916, 38.54214], [-121.71012, 38.54174], [-121.71025, 38.54282]]]} | Open Access 1 | 20976 | Putah Creek Park | 24034 | 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.137 | Putah Creek Park | 0 | Local Park 2 | 4 | |
10944 | 10944 | 10943 | {"type": "Polygon", "coordinates": [[[-121.7202, 38.56537], [-121.72018, 38.56551], [-121.71987, 38.56636], [-121.71943, 38.56628], [-121.71944, 38.56622], [-121.71942, 38.56618], [-121.71932, 38.56611], [-121.7192, 38.5661], [-121.7187, 38.566], [-121.71823, 38.56594], [-121.71818, 38.5659], [-121.71824, 38.56561], [-121.71829, 38.56551], [-121.71836, 38.56542], [-121.71878, 38.56499], [-121.71893, 38.56486], [-121.71917, 38.5647], [-121.71945, 38.56458], [-121.71967, 38.56492], [-121.71973, 38.56504], [-121.71977, 38.56507], [-121.71982, 38.56507], [-121.71993, 38.56533], [-121.7202, 38.56537]]]} | Open Access 1 | 20977 | Robert Arneson Park | 24483 | 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.955 | Robert Arneson Park | 0 | Local Park 2 | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |||
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 | |
10953 | 10953 | 10952 | {"type": "MultiPolygon", "coordinates": [[[[-121.72588, 38.54532], [-121.72557, 38.5454], [-121.72534, 38.54544], [-121.7251, 38.54544], [-121.72487, 38.54542], [-121.72228, 38.54473], [-121.72224, 38.54468], [-121.72223, 38.54461], [-121.72253, 38.54321], [-121.72517, 38.54297], [-121.72543, 38.54338], [-121.72553, 38.54359], [-121.72565, 38.54393], [-121.72572, 38.54426], [-121.72588, 38.54532]]], [[[-121.72639, 38.54517], [-121.72618, 38.54523], [-121.72601, 38.54414], [-121.72591, 38.54375], [-121.72582, 38.54352], [-121.72571, 38.54329], [-121.72558, 38.54307], [-121.72543, 38.54285], [-121.72591, 38.54281], [-121.72604, 38.54396], [-121.72639, 38.54517]]]]} | Open Access 1 | 21000 | Playfields Park | 23775 | 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 | 17.395 | Playfields Park | 0 | Local Recreation Area 3 | 4 | |
10956 | 10956 | 10955 | {"type": "Polygon", "coordinates": [[[-121.72913, 38.565], [-121.7291, 38.56585], [-121.72823, 38.56583], [-121.72798, 38.56584], [-121.72797, 38.56528], [-121.72791, 38.56495], [-121.72799, 38.56491], [-121.72856, 38.56489], [-121.72882, 38.56499], [-121.72913, 38.565]]]} | Open Access 1 | 21014 | Oak Grove Park | 22971 | 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.504 | Oak Grove 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 | |
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 | |
10959 | 10959 | 10958 | {"type": "Polygon", "coordinates": [[[-121.76107, 38.55363], [-121.75876, 38.55359], [-121.75878, 38.55228], [-121.75911, 38.5523], [-121.75908, 38.55291], [-121.75992, 38.55317], [-121.76087, 38.55311], [-121.76107, 38.55363]]]} | Open Access 1 | 21018 | Redwood Park | 24248 | 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.333 | Redwood Park | 0 | Local Park 2 | 4 | |
10960 | 10960 | 10959 | {"type": "Polygon", "coordinates": [[[-121.68826, 38.55066], [-121.68853, 38.55079], [-121.68853, 38.55083], [-121.68848, 38.55095], [-121.68911, 38.55116], [-121.68849, 38.55218], [-121.68848, 38.55221], [-121.6879, 38.55227], [-121.68724, 38.55227], [-121.68726, 38.55055], [-121.68782, 38.55057], [-121.68804, 38.5506], [-121.68826, 38.55066]]]} | Open Access 1 | 21019 | Pioneer Park | 23719 | 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.81 | Pioneer 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 | |
12073 | 12073 | 12072 | {"type": "Polygon", "coordinates": [[[-121.70231, 38.54387], [-121.7023, 38.54454], [-121.70208, 38.54454], [-121.70185, 38.54466], [-121.70176, 38.5446], [-121.70167, 38.54459], [-121.70168, 38.54386], [-121.70231, 38.54387]]]} | Open Access 1 | 24838 | Putah Creek Park | 24034 | 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.08 | Putah Creek Park | 0 | Local Park 2 | 4 | |
12272 | 12272 | 12271 | {"type": "Polygon", "coordinates": [[[-121.76712, 38.56828], [-121.76373, 38.56824], [-121.7627, 38.56837], [-121.76249, 38.56843], [-121.76224, 38.56857], [-121.76212, 38.56869], [-121.762, 38.56886], [-121.76195, 38.569], [-121.76192, 38.5692], [-121.76188, 38.56934], [-121.76181, 38.56948], [-121.76174, 38.56959], [-121.7616, 38.56974], [-121.7615, 38.56982], [-121.76121, 38.57002], [-121.76112, 38.57012], [-121.76101, 38.57027], [-121.76095, 38.57055], [-121.76092, 38.57094], [-121.76084, 38.57115], [-121.76074, 38.57134], [-121.76052, 38.57157], [-121.76031, 38.57171], [-121.75997, 38.57184], [-121.75982, 38.57187], [-121.7594, 38.57191], [-121.75829, 38.57191], [-121.75817, 38.57561], [-121.74807, 38.57546], [-121.74796, 38.57511], [-121.74857, 38.57513], [-121.74862, 38.5751], [-121.74876, 38.57483], [-121.74876, 38.57478], [-121.74887, 38.57483], [-121.74882, 38.57486], [-121.7487, 38.5751], [-121.74874, 38.57513], [-121.75685, 38.5752], [-121.757, 38.57519], [-121.75716, 38.57516], [-121.75735, 38.57508], [-121.75746, 38.57501], [-121.75744, 38.57494], [-121.75751, 38.5749], [-121.75752, 38.57483], [-121.75764, 38.57483], [-121.75767, 38.5748], [-121.75773, 38.57467], [-121.75776, 38.57454], [-121.75776, 38.57413], [-121.75766, 38.57409], [-121.75766, 38.57401], [-121.75777, 38.57397], [-121.75778, 38.57337], [-121.75775, 38.57334], [-121.75761, 38.57334], [-121.75761, 38.57331], [-121.75775, 38.57331], [-121.75779, 38.57328], [-121.7578, 38.57263], [-121.75771, 38.5726], [-121.75771, 38.57251], [-121.7578, 38.57248], [-121.75781, 38.57176], [-121.7578, 38.5717], [-121.75738, 38.5714], [-121.75753, 38.57137], [-121.7578, 38.57122], [-121.75795, 38.57111], [-121.75799, 38.57105], [-121.75812, 38.57093], [-121.75821, 38.57131], [-121.75832, 38.57148], [-121.75966, 38.57149], [-121.75995, 38.57142], [-121.76018, 38.57129], [-121.76019, 38.57116], [-121.76023, 38.57115], [-121.76027, 38.57112], [-121.76028, 38.57101], [-121.76041, 38.57101], [-121.76046, 38.57087], [-121.76048, 38.57042], [-121.76032, 38.57037], [-121.76032, 38.57029], [-121.76051, 38.57025], [-121.76058, 38.57011], [-121.76066, 38.56997], [-121.76077, 38.56984], [-121.76089, 38.56973], [-121.76089, 38.56964], [-121.76098, 38.56964], [-121.76103, 38.56963], [-121.76106, 38.5696], [-121.76107, 38.56953], [-121.76119, 38.56953], [-121.7613, 38.56941], [-121.76139, 38.56928], [-121.76142, 38.56919], [-121.76148, 38.5689], [-121.76133, 38.56886], [-121.76133, 38.56877], [-121.76155, 38.56873], [-121.76163, 38.5686], [-121.76173, 38.56847], [-121.76184, 38.56836], [-121.762, 38.56824], [-121.76199, 38.56822], [-121.7613, 38.56822], [-121.76131, 38.56779], [-121.76136, 38.56779], [-121.76137, 38.56727], [-121.76131, 38.56718], [-121.76143, 38.56718], [-121.76143, 38.56724], [-121.76149, 38.56724], [-121.76148, 38.56811], [-121.76157, 38.56818], [-121.76209, 38.56818], [-121.76241, 38.56805], [-121.76278, 38.56797], [-121.76288, 38.5679], [-121.76311, 38.56724], [-121.76266, 38.5658], [-121.76247, 38.56572], [-121.76247, 38.56494], [-121.76199, 38.5648], [-121.7616, 38.5648], [-121.76152, 38.56487], [-121.76151, 38.56562], [-121.76133, 38.56564], [-121.76134, 38.56519], [-121.76139, 38.56519], [-121.76139, 38.56475], [-121.76134, 38.56474], [-121.76134, 38.56452], [-121.76152, 38.56452], [-121.76152, 38.56431], [-121.76135, 38.5643], [-121.76135, 38.56364], [-121.76167, 38.56365], [-121.76171, 38.56433], [-121.76189, 38.56457], [-121.76219, 38.56471], [-121.76304, 38.56484], [-121.76317, 38.56479], [-121.76332, 38.56443], [-121.76342, 38.56445], [-121.7633, 38.56488], [-121.7633, 38.56526], [-121.76331, 38.56531], [-121.76336, 38.56535], [-121.76341, 38.56538], [-121.76371, 38.56538], [-121.76411, 38.56547], [-121.7642, 38.56579], [-121.76367, 38.56574], [-121.76337, 38.56578], [-121.7633, 38.56585], [-121.7636, 38.5671], [-121.76363, 38.56713], [-121.76369, 38.56714], [-121.7646, 38.56699], [-121.76465, 38.56709], [-121.76364, 38.56726], [-121.76361, 38.56728], [-121.76359, 38.56731], [-121.76358, 38.56734], [-121.76372, 38.56784], [-121.76374, 38.56786], [-121.76381, 38.56789], [-121.7643, 38.56785], [-121.76479, 38.56789], [-121.76602, 38.56792], [-121.76627, 38.56787], [-121.76661, 38.56773], [-121.76671, 38.56767], [-121.76677, 38.5676], [-121.7669, 38.56772], [-121.76702, 38.5679], [-121.76709, 38.56807], [-121.76712, 38.56828]]]} | Open Access 1 | 25887 | Northstar Perimeter Greenbelt | 30911 | 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 | 33.425 | Northstar Perimeter Greenbelt | 0 | Local Recreation Area 3 | 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]);