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 DES_TP
This data as json, copyable, CSV (advanced)
DES_TP 7
- Local Recreation Area 23
- Local Park 17
- Local Conservation Area 1
- Local Other or Unknown 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 |
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 |
14535 | 14535 | 14534 | {"type": "Polygon", "coordinates": [[[-121.73123, 38.54961], [-121.73123, 38.54972], [-121.73057, 38.5497], [-121.73057, 38.54959], [-121.73123, 38.54961]]]} | Open Access 1 | 47203 | N Street Mini-Park | 30908 | 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/40/2926?npage=3 | Yolo 33 | 0.176 | N Street Mini-Park | 0 | Local Park 2 | 4 |
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 |
14538 | 14538 | 14537 | {"type": "Polygon", "coordinates": [[[-121.69931, 38.55911], [-121.69852, 38.55911], [-121.69853, 38.55865], [-121.6989, 38.55856], [-121.6991, 38.55855], [-121.69916, 38.55857], [-121.69919, 38.55862], [-121.69919, 38.55889], [-121.69918, 38.55896], [-121.69918, 38.55901], [-121.69924, 38.55908], [-121.69931, 38.55911]]]} | Open Access 1 | 47206 | Mace Ranch Mini Park | 30912 | 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/38/2926?npage=3 | Yolo 33 | 0.836 | Mace Ranch MP | 0 | Local Park 2 | 4 |
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 | |
17066 | 17066 | 17065 | {"type": "Polygon", "coordinates": [[[-121.75072, 38.57381], [-121.75068, 38.57385], [-121.75067, 38.57395], [-121.75049, 38.57408], [-121.75035, 38.57409], [-121.75035, 38.57399], [-121.7503, 38.57395], [-121.75016, 38.57394], [-121.75011, 38.57395], [-121.75011, 38.57366], [-121.75016, 38.57367], [-121.75028, 38.57367], [-121.75032, 38.57366], [-121.75035, 38.57362], [-121.75065, 38.57367], [-121.75065, 38.57373], [-121.75072, 38.57381]]]} | Open Access 1 | 20971 | Northstar Pocket Park | 22894 | 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.474 | Northstar PP | 0 | Local Park 2 | 4 | |
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 | |
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 | |
4100 | 4100 | 4099 | {"type": "Polygon", "coordinates": [[[-121.72825, 38.55745], [-121.72788, 38.55754], [-121.72781, 38.55741], [-121.7282, 38.5573], [-121.72825, 38.55739], [-121.72825, 38.55745]]]} | Open Access 1 | 47218 | Pole Line/Snyder Greenbelt | 30925 | 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.145 | Pole Line/Snyder 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]);