superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
122 rows where MNG_AGENCY = 56 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15409 | 15409 | 15408 | {"type": "Polygon", "coordinates": [[[-122.16491, 37.77529], [-122.16447, 37.77551], [-122.1645, 37.77559], [-122.16468, 37.77579], [-122.16447, 37.77591], [-122.16436, 37.77599], [-122.16272, 37.77515], [-122.1625, 37.77506], [-122.16265, 37.775], [-122.16271, 37.77502], [-122.16281, 37.775], [-122.16286, 37.77496], [-122.16291, 37.77487], [-122.16354, 37.77509], [-122.16371, 37.77485], [-122.16385, 37.77477], [-122.16392, 37.77482], [-122.16437, 37.77463], [-122.16491, 37.77529]]]} | Open Access 1 | Burckhalter Recreation Area | 16515 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 3.581 | Burckhalter Rec. Area | ||
13921 | 13921 | 13920 | {"type": "Polygon", "coordinates": [[[-122.27085, 37.79746], [-122.27066, 37.79776], [-122.27058, 37.79782], [-122.27046, 37.79786], [-122.27036, 37.79786], [-122.2702, 37.79782], [-122.26962, 37.79759], [-122.26993, 37.79709], [-122.27085, 37.79746]]]} | Open Access 1 | Chinese Garden Park | 32515 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.324 | Chinese Garden Park | ||
13890 | 13890 | 13889 | {"type": "Polygon", "coordinates": [[[-122.21593, 37.75709], [-122.21587, 37.75719], [-122.21495, 37.7577], [-122.21461, 37.75735], [-122.21469, 37.75729], [-122.21468, 37.75727], [-122.21417, 37.75663], [-122.21362, 37.75602], [-122.21439, 37.75561], [-122.21469, 37.75547], [-122.21492, 37.75552], [-122.21507, 37.75558], [-122.21511, 37.75569], [-122.21512, 37.75585], [-122.2152, 37.756], [-122.21541, 37.7561], [-122.21548, 37.75637], [-122.2157, 37.75655], [-122.21576, 37.75666], [-122.21556, 37.75671], [-122.2156, 37.75688], [-122.21593, 37.75709]]]} | Open Access 1 | Soccer Field | 33200 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 6.249 | Soccer Field | ||
13151 | 13151 | 13150 | {"type": "Polygon", "coordinates": [[[-122.2005, 37.76573], [-122.19965, 37.76633], [-122.19929, 37.766], [-122.20001, 37.7655], [-122.2005, 37.76573]]]} | Open Access 1 | Rainbow Recreation Center | http://www2.oaklandnet.com/Government/o/opr/s/facility/OAK029393 | 30895 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.111 | Rainbow Rec. Ctr. | |
12564 | 12564 | 12563 | {"type": "Polygon", "coordinates": [[[-122.25379, 37.79435], [-122.25304, 37.79487], [-122.25235, 37.79427], [-122.2531, 37.79373], [-122.25379, 37.79435]]]} | Open Access 1 | Clinton Park | 32504 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.997 | Clinton Park | ||
12408 | 12408 | 12407 | {"type": "Polygon", "coordinates": [[[-122.25867, 37.81866], [-122.25819, 37.81906], [-122.25812, 37.81906], [-122.25805, 37.81891], [-122.25791, 37.81879], [-122.25839, 37.81849], [-122.25867, 37.81866]]]} | Open Access 1 | Oak Park | 32421 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.492 | Oak Park | ||
12407 | 12407 | 12406 | {"type": "Polygon", "coordinates": [[[-122.30253, 37.80789], [-122.30246, 37.8081], [-122.3024, 37.80817], [-122.30212, 37.80803], [-122.30219, 37.80782], [-122.30253, 37.80789]]]} | Open Access 1 | Bertha Port Park | 32420 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.218 | Bertha Port Park | ||
12398 | 12398 | 12397 | {"type": "Polygon", "coordinates": [[[-122.33381, 37.80525], [-122.33311, 37.80588], [-122.33301, 37.80592], [-122.33294, 37.80586], [-122.3326, 37.80603], [-122.33238, 37.80574], [-122.33271, 37.80549], [-122.33265, 37.80541], [-122.33289, 37.80523], [-122.33297, 37.80522], [-122.33381, 37.80525]]]} | Open Access 1 | Port View Park | 32419 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.431 | Port View Park | ||
12366 | 12366 | 12365 | {"type": "Polygon", "coordinates": [[[-122.26122, 37.83814], [-122.26105, 37.83823], [-122.26092, 37.83834], [-122.26066, 37.83815], [-122.26104, 37.83796], [-122.26109, 37.83798], [-122.26122, 37.83814]]]} | Open Access 1 | Redondo Park | 32418 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.25 | Redondo Park | ||
12364 | 12364 | 12363 | {"type": "Polygon", "coordinates": [[[-122.2686, 37.84295], [-122.26834, 37.843], [-122.26827, 37.84298], [-122.26793, 37.84302], [-122.26779, 37.84237], [-122.26814, 37.84232], [-122.2682, 37.84224], [-122.26821, 37.84225], [-122.26845, 37.84222], [-122.2686, 37.84295]]]} | Open Access 1 | Dover Street Park | https://www.oaklandca.gov/services/find-a-parks-and-recreation-location | 32417 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.139 | Dover Street Park | |
11365 | 11365 | 11364 | {"type": "Polygon", "coordinates": [[[-122.22078, 37.79608], [-122.22051, 37.79683], [-122.22041, 37.79693], [-122.22031, 37.7974], [-122.22024, 37.79743], [-122.22009, 37.79765], [-122.21975, 37.79758], [-122.21968, 37.79721], [-122.21964, 37.79663], [-122.21998, 37.79527], [-122.22062, 37.79541], [-122.2205, 37.79586], [-122.22061, 37.79602], [-122.22078, 37.79608]]]} | Open Access 1 | Wood Park | 27677 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 4.198 | Wood Park | ||
11285 | 11285 | 11284 | {"type": "Polygon", "coordinates": [[[-122.29695, 37.81202], [-122.29654, 37.81255], [-122.29589, 37.81221], [-122.29631, 37.8117], [-122.29695, 37.81202]]]} | Open Access 1 | Willow Mini Park | 27580 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.135 | Willow MP | ||
10977 | 10977 | 10976 | {"type": "Polygon", "coordinates": [[[-122.29076, 37.80888], [-122.29052, 37.80959], [-122.28941, 37.8093], [-122.28911, 37.80883], [-122.28908, 37.8086], [-122.28911, 37.80855], [-122.29076, 37.80888]]]} | Open Access 1 | Wade Johnson Park | 27206 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 2.538 | Wade Johnson Park | ||
10782 | 10782 | 10781 | {"type": "Polygon", "coordinates": [[[-122.16384, 37.74928], [-122.16303, 37.74965], [-122.162, 37.74825], [-122.1628, 37.74788], [-122.16384, 37.74928]]]} | Open Access 1 | Verdese Carter Park | 26987 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 3.659 | Verdese Carter Park | ||
10661 | 10661 | 10660 | {"type": "Polygon", "coordinates": [[[-122.24847, 37.78886], [-122.24842, 37.78889], [-122.24833, 37.78889], [-122.24828, 37.78891], [-122.24824, 37.78895], [-122.24822, 37.78904], [-122.24818, 37.78906], [-122.24776, 37.78869], [-122.24771, 37.78863], [-122.24765, 37.78857], [-122.24765, 37.78854], [-122.24769, 37.78853], [-122.24778, 37.78857], [-122.24847, 37.78886]]]} | Open Access 1 | Vantage Point Park | 26835 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.344 | Vantage Point Park | ||
10559 | 10559 | 10558 | {"type": "Polygon", "coordinates": [[[-122.24302, 37.7783], [-122.24243, 37.77844], [-122.24214, 37.77811], [-122.24164, 37.77775], [-122.24135, 37.7775], [-122.24112, 37.77728], [-122.24103, 37.77711], [-122.24097, 37.77684], [-122.24088, 37.77608], [-122.24078, 37.7759], [-122.24068, 37.77574], [-122.24051, 37.77558], [-122.24033, 37.77544], [-122.24011, 37.77533], [-122.24009, 37.7752], [-122.24014, 37.77518], [-122.24056, 37.77518], [-122.24113, 37.77573], [-122.24171, 37.77601], [-122.24177, 37.77608], [-122.24185, 37.77621], [-122.24188, 37.77644], [-122.24189, 37.77673], [-122.24292, 37.77808], [-122.24302, 37.7783]]]} | Open Access 1 | Union Point Park | 26659 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 6.707 | Union Point Park | ||
10558 | 10558 | 10557 | {"type": "Polygon", "coordinates": [[[-122.28292, 37.82599], [-122.2825, 37.82589], [-122.28278, 37.82555], [-122.28278, 37.82555], [-122.28292, 37.82599]]]} | Open Access 1 | Union Plaza | 26658 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.211 | Union Plaza | ||
10233 | 10233 | 10232 | {"type": "Polygon", "coordinates": [[[-122.18525, 37.75116], [-122.18468, 37.75144], [-122.18392, 37.75049], [-122.18413, 37.75039], [-122.18421, 37.75049], [-122.18452, 37.75036], [-122.18479, 37.75073], [-122.1849, 37.75069], [-122.18525, 37.75116]]]} | Open Access 1 | Tassafaronga Park | 26193 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.614 | Tassafaronga Park | ||
10045 | 10045 | 10044 | {"type": "Polygon", "coordinates": [[[-122.19977, 37.82048], [-122.19936, 37.82094], [-122.19938, 37.82098], [-122.19928, 37.82103], [-122.19889, 37.82132], [-122.19882, 37.82144], [-122.19875, 37.82171], [-122.19871, 37.82178], [-122.19864, 37.82183], [-122.19856, 37.82187], [-122.19847, 37.82189], [-122.19843, 37.82188], [-122.19842, 37.82184], [-122.19854, 37.82149], [-122.19859, 37.8214], [-122.19871, 37.82126], [-122.19894, 37.8211], [-122.19907, 37.82097], [-122.19915, 37.82085], [-122.19933, 37.82044], [-122.19942, 37.82031], [-122.19945, 37.82028], [-122.19977, 37.82048]]]} | Open Access 1 | Sulfur Springs Park | 25947 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.102 | Sulfur Springs Park | ||
10000 | 10000 | 9999 | {"type": "Polygon", "coordinates": [[[-122.17595, 37.73669], [-122.1741, 37.73813], [-122.17386, 37.73782], [-122.1751, 37.73686], [-122.17502, 37.73674], [-122.17482, 37.73661], [-122.17463, 37.73664], [-122.17449, 37.73644], [-122.17449, 37.73639], [-122.1747, 37.73626], [-122.1752, 37.73597], [-122.17568, 37.73635], [-122.17561, 37.73642], [-122.17595, 37.73669]]]} | Open Access 1 | Stonehurst Park | 25890 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 3.475 | Stonehurst 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]);