units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
65 rows where LAYER = 2 and MNG_AGENCY = 167 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
10935 | 10935 | 10934 | {"type": "Polygon", "coordinates": [[[-121.67546, 38.55795], [-121.67529, 38.56745], [-121.65712, 38.56762], [-121.65699, 38.57488], [-121.64781, 38.57492], [-121.63857, 38.57489], [-121.63885, 38.56638], [-121.66534, 38.56043], [-121.66535, 38.5608], [-121.66612, 38.5608], [-121.66614, 38.5602], [-121.66638, 38.56014], [-121.6664, 38.55998], [-121.67546, 38.55795]]]} | No Public Access 3 | 20963 | Howatt/Clayton Ranch | 20123 | 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 | 786.039 | Howatt/Clayton Ranch | 0 | Local Other or Unknown 14 | 4 | |
3053 | 3053 | 3052 | {"type": "Polygon", "coordinates": [[[-121.6994, 38.55535], [-121.69905, 38.55552], [-121.69885, 38.55568], [-121.69872, 38.55587], [-121.69905, 38.55598], [-121.699, 38.55612], [-121.69899, 38.55625], [-121.69911, 38.55765], [-121.69911, 38.5578], [-121.69908, 38.55781], [-121.69908, 38.55786], [-121.69905, 38.55789], [-121.69867, 38.55794], [-121.69827, 38.55803], [-121.69796, 38.55813], [-121.69769, 38.55824], [-121.69773, 38.55537], [-121.6994, 38.55535]]]} | Open Access 1 | 20964 | John Barovetto Park | 20429 | 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 | 8.389 | John Barovetto Park | 0 | Local Park 2 | 4 | |
10937 | 10937 | 10936 | {"type": "Polygon", "coordinates": [[[-121.70625, 38.56117], [-121.70584, 38.5615], [-121.70564, 38.56159], [-121.7054, 38.56162], [-121.70517, 38.56161], [-121.70505, 38.5615], [-121.70508, 38.56146], [-121.70508, 38.56137], [-121.70504, 38.56131], [-121.705, 38.5613], [-121.70454, 38.56129], [-121.70447, 38.56125], [-121.70446, 38.56116], [-121.70454, 38.56043], [-121.70457, 38.56039], [-121.70461, 38.56038], [-121.70492, 38.5604], [-121.705, 38.56043], [-121.70504, 38.56049], [-121.70509, 38.56052], [-121.70525, 38.56054], [-121.70531, 38.56052], [-121.70533, 38.56049], [-121.70535, 38.56039], [-121.70531, 38.56034], [-121.70536, 38.56029], [-121.70552, 38.5597], [-121.70551, 38.55965], [-121.70556, 38.55964], [-121.70559, 38.55961], [-121.7056, 38.55951], [-121.7058, 38.55952], [-121.70594, 38.55976], [-121.70611, 38.56009], [-121.70586, 38.5602], [-121.70582, 38.56025], [-121.70582, 38.56032], [-121.70587, 38.5604], [-121.70608, 38.56093], [-121.70625, 38.56117]]]} | Open Access 1 | 20965 | La Playa Park | 20791 | 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.871 | La Playa Park | 0 | Local Park 2 | 4 | |
10938 | 10938 | 10937 | {"type": "Polygon", "coordinates": [[[-121.74467, 38.5606], [-121.74332, 38.56059], [-121.74294, 38.55937], [-121.74458, 38.55939], [-121.74465, 38.55962], [-121.74468, 38.55985], [-121.74467, 38.5606]]]} | Open Access 1 | 20966 | Little League Park | 21347 | 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.447 | Little League Park | 0 | Local Park 2 | 4 | |
10939 | 10939 | 10938 | {"type": "Polygon", "coordinates": [[[-121.7125, 38.55627], [-121.71249, 38.55712], [-121.71176, 38.55711], [-121.71159, 38.55713], [-121.7114, 38.55717], [-121.71121, 38.55725], [-121.71103, 38.55735], [-121.71088, 38.5575], [-121.71077, 38.55763], [-121.70966, 38.55707], [-121.70906, 38.55765], [-121.70724, 38.55854], [-121.70701, 38.55843], [-121.70733, 38.55668], [-121.70886, 38.55584], [-121.70871, 38.55491], [-121.70929, 38.55485], [-121.70937, 38.55528], [-121.71093, 38.55512], [-121.71103, 38.55531], [-121.71099, 38.55542], [-121.71122, 38.55563], [-121.71114, 38.55571], [-121.71107, 38.55582], [-121.71074, 38.55572], [-121.71068, 38.55591], [-121.71064, 38.55609], [-121.71063, 38.55628], [-121.71094, 38.55653], [-121.71137, 38.55652], [-121.71233, 38.55654], [-121.71234, 38.55626], [-121.7125, 38.55627]]]} | Open Access 1 | 20967 | Mace Ranch Park | 21627 | 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 | 21.219 | Mace Ranch Park | 0 | Local Park 2 | 4 | |
10940 | 10940 | 10939 | {"type": "Polygon", "coordinates": [[[-121.75437, 38.57126], [-121.75434, 38.57201], [-121.75417, 38.57211], [-121.75416, 38.57206], [-121.75411, 38.572], [-121.75405, 38.57196], [-121.75397, 38.57194], [-121.75099, 38.57192], [-121.75088, 38.572], [-121.75088, 38.57225], [-121.75078, 38.57229], [-121.75072, 38.57235], [-121.75037, 38.57235], [-121.75027, 38.57243], [-121.75027, 38.57253], [-121.74977, 38.57253], [-121.74938, 38.57259], [-121.74924, 38.57303], [-121.74858, 38.57314], [-121.74857, 38.57315], [-121.74759, 38.5733], [-121.74751, 38.57329], [-121.74751, 38.57327], [-121.74742, 38.57323], [-121.74736, 38.57317], [-121.74733, 38.57311], [-121.74697, 38.57196], [-121.74677, 38.57078], [-121.74671, 38.57055], [-121.74978, 38.56995], [-121.75015, 38.57109], [-121.75437, 38.57126]]]} | Open Access 1 | 20970 | Northstar Park | 22893 | 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 | 29.24 | Northstar 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 | |
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 | |
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 |
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]);