superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
64 rows where MNG_AGENCY = 167 and MNG_AG_TYP = 2 sorted by YR_EST
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
10373 | 10373 | 10372 | {"type": "Polygon", "coordinates": [[[-121.73051, 38.54687], [-121.73035, 38.5469], [-121.73008, 38.54679], [-121.72995, 38.54676], [-121.72953, 38.54675], [-121.72911, 38.54675], [-121.72907, 38.54672], [-121.72878, 38.54679], [-121.72877, 38.54684], [-121.72873, 38.5469], [-121.72861, 38.54694], [-121.72851, 38.54693], [-121.7284, 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.54689], [-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.72877, 38.54673], [-121.72905, 38.54664], [-121.72899, 38.5462], [-121.73041, 38.54597], [-121.73051, 38.54597], [-121.73051, 38.54687]]]} | Open Access 1 | Toad Hollow Dog Park | 26379 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 3.153 | Toad Hollow Dog Park | ||
11009 | 11009 | 11008 | {"type": "Polygon", "coordinates": [[[-121.72252, 38.53836], [-121.72229, 38.53842], [-121.72217, 38.53851], [-121.72191, 38.53846], [-121.7215, 38.53863], [-121.72147, 38.53866], [-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.72021, 38.54019], [-121.71995, 38.53992], [-121.71998, 38.53988], [-121.72008, 38.53995], [-121.72033, 38.54006], [-121.72034, 38.54005], [-121.72008, 38.5378], [-121.71962, 38.53783], [-121.71955, 38.53789], [-121.71949, 38.53787], [-121.71952, 38.53779], [-121.71937, 38.53751], [-121.71895, 38.53766], [-121.71887, 38.5376], [-121.71916, 38.53739], [-121.71983, 38.53713], [-121.71992, 38.53694], [-121.71944, 38.53607], [-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.72024, 38.53703], [-121.72053, 38.53762], [-121.72057, 38.53775], [-121.72061, 38.53804], [-121.72082, 38.53837], [-121.72106, 38.53856], [-121.72119, 38.53858], [-121.7215, 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.53811], [-121.72152, 38.53819], [-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 | Walnut Park | 27240 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 18.338 | Walnut Park | ||
11088 | 11088 | 11087 | {"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 | West Manor Park | 27367 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 2.884 | West Manor Park | ||
11170 | 11170 | 11169 | {"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 | Whaleback Park | 27447 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1.432 | Whaleback Park | ||
11275 | 11275 | 11274 | {"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.54664], [-121.70413, 38.54637], [-121.70448, 38.54638], [-121.70482, 38.54641], [-121.70547, 38.54642], [-121.70557, 38.5467], [-121.70677, 38.54671]]]} | Open Access 1 | Willow Creek Park | 27576 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 4.642 | Willow Creek Park | ||
12352 | 12352 | 12351 | {"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.55299], [-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 | Sunnyside Greenbelt | 30913 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1.794 | Sunnyside Greenbelt | ||
12353 | 12353 | 12352 | {"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 | Arroyo Greenbelt | 30916 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 0.805 | Arroyo Greenbelt |
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]);