superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
64 rows where MNG_AGENCY = 167
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5275 | 5275 | 5274 | {"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.66536, 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 | Howatt/Clayton Ranch | 20123 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 786.11 | Howatt/Clayton Ranch | ||
5545 | 5545 | 5544 | {"type": "Polygon", "coordinates": [[[-121.6994, 38.55535], [-121.69905, 38.55552], [-121.69886, 38.55568], [-121.69873, 38.55586], [-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 | John Barovetto Park | 20429 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 8.393 | John Barovetto Park | ||
5830 | 5830 | 5829 | {"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.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.5604], [-121.70531, 38.56034], [-121.70536, 38.56029], [-121.70552, 38.5597], [-121.70551, 38.55965], [-121.70555, 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 | La Playa Park | 20791 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 4.878 | La Playa Park | ||
6275 | 6275 | 6274 | {"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 | Little League Park | 21347 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 4.446 | Little League Park | ||
6490 | 6490 | 6489 | {"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.70938, 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.55573], [-121.71068, 38.55591], [-121.71064, 38.55609], [-121.71063, 38.55628], [-121.71094, 38.55653], [-121.71137, 38.55652], [-121.71232, 38.55654], [-121.71234, 38.55626], [-121.7125, 38.55627]]]} | Open Access 1 | Mace Ranch Park | 21627 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 21.242 | Mace Ranch Park | ||
7456 | 7456 | 7455 | {"type": "Polygon", "coordinates": [[[-121.7202, 38.56537], [-121.72018, 38.56551], [-121.71987, 38.56636], [-121.71943, 38.56627], [-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.71972, 38.56504], [-121.71977, 38.56507], [-121.71982, 38.56507], [-121.71993, 38.56533], [-121.7202, 38.56537]]]} | Open Access 1 | Robert Arneson Park | 24483 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 4.956 | Robert Arneson Park | ||
7489 | 7489 | 7488 | {"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.74859, 38.57314], [-121.74857, 38.57315], [-121.74759, 38.5733], [-121.74751, 38.57329], [-121.7475, 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 | Northstar Park | 22893 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 29.251 | Northstar Park | ||
7494 | 7494 | 7493 | {"type": "Polygon", "coordinates": [[[-121.75072, 38.57381], [-121.75068, 38.57385], [-121.75067, 38.57395], [-121.75049, 38.57408], [-121.75035, 38.57409], [-121.75034, 38.57399], [-121.7503, 38.57395], [-121.75016, 38.57394], [-121.75011, 38.57395], [-121.75011, 38.57366], [-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 | Northstar Pocket Park | 22894 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 0.476 | Northstar PP | ||
7553 | 7553 | 7552 | {"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 | Oak Grove Park | 22971 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 2.504 | Oak Grove Park | ||
7646 | 7646 | 7645 | {"type": "Polygon", "coordinates": [[[-121.73978, 38.57539], [-121.73963, 38.58321], [-121.73048, 38.58431], [-121.73066, 38.57532], [-121.73477, 38.57535], [-121.73479, 38.5755], [-121.73504, 38.57549], [-121.73505, 38.57536], [-121.73978, 38.57539]]]} | Open Access 1 | Old Landfill | 23088 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 183.272 | Old Landfill | ||
7827 | 7827 | 7826 | {"type": "Polygon", "coordinates": [[[-121.76656, 38.5479], [-121.76567, 38.54789], [-121.76517, 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 | Oxford Circle Park | 23280 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 3.344 | Oxford Circle Park | ||
8180 | 8180 | 8179 | {"type": "Polygon", "coordinates": [[[-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], [-121.68853, 38.55079], [-121.68853, 38.55083], [-121.68849, 38.55095], [-121.68911, 38.55116]]]} | Open Access 1 | Pioneer Park | 23719 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 5.811 | Pioneer Park | ||
8229 | 8229 | 8228 | {"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.5436], [-121.72565, 38.54392], [-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.54306], [-121.72543, 38.54285], [-121.72591, 38.54281], [-121.72604, 38.54396], [-121.72639, 38.54517]]]]} | Open Access 1 | Playfields Park | 23775 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 17.394 | Playfields Park | ||
8433 | 8433 | 8432 | {"type": "MultiPolygon", "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]]], [[[-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 | Putah Creek Park | 24034 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 3.217 | Putah Creek Park | ||
8599 | 8599 | 8598 | {"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 | Redwood Park | 24248 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 3.337 | Redwood Park | ||
9274 | 9274 | 9273 | {"type": "Polygon", "coordinates": [[[-121.72868, 38.56856], [-121.72865, 38.56863], [-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.72696, 38.56786], [-121.72699, 38.56783], [-121.72707, 38.56785], [-121.72761, 38.5677], [-121.7278, 38.56799], [-121.72806, 38.56823], [-121.72833, 38.56841], [-121.72868, 38.56856]]]} | Open Access 1 | Sandy Motley Park | 25026 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 5.251 | Sandy Motley Park | ||
9568 | 9568 | 9567 | {"type": "Polygon", "coordinates": [[[-121.77368, 38.55052], [-121.77361, 38.5506], [-121.77359, 38.55067], [-121.77363, 38.55084], [-121.77361, 38.55167], [-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 | Westwood Park | 27440 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 6.002 | Westwood Park | ||
9735 | 9735 | 9734 | {"type": "Polygon", "coordinates": [[[-121.71743, 38.56174], [-121.71741, 38.56177], [-121.71737, 38.56179], [-121.71547, 38.56196], [-121.71531, 38.56018], [-121.71556, 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 | Slide Hill Park | 25557 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 12.027 | Slide Hill Park | ||
9799 | 9799 | 9798 | {"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 | South Fork Preserve | 25651 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 191.284 | South Fork Preserve | ||
10181 | 10181 | 10180 | {"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 | Sycamore Park | 26133 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 5.731 | Sycamore Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);