superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
122 rows where MNG_AGENCY = 56 and MNG_AG_TYP = 2 sorted by YR_EST
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
149 | 149 | 148 | {"type": "Polygon", "coordinates": [[[-122.17361, 37.75533], [-122.17331, 37.75544], [-122.17312, 37.7551], [-122.1734, 37.755], [-122.17361, 37.75533]]]} | Open Access 1 | 85th Avenue Mini Park | 15217 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.29 | 85th Avenue MP | ||
150 | 150 | 149 | {"type": "Polygon", "coordinates": [[[-122.17152, 37.75333], [-122.17114, 37.7535], [-122.17092, 37.75318], [-122.1713, 37.75301], [-122.17152, 37.75333]]]} | Open Access 1 | 88th Avenue Mini Park | 15218 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.384 | 88th Avenue MP | ||
408 | 408 | 407 | {"type": "Polygon", "coordinates": [[[-122.26214, 37.81105], [-122.26189, 37.81169], [-122.26104, 37.81169], [-122.2609, 37.81082], [-122.26151, 37.81091], [-122.26214, 37.81105]]]} | Open Access 1 | Adams Park | 15262 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.952 | Adams Park | ||
461 | 461 | 460 | {"type": "Polygon", "coordinates": [[[-122.19359, 37.76393], [-122.19346, 37.76401], [-122.1932, 37.76376], [-122.19333, 37.76367], [-122.19359, 37.76393]]]} | Open Access 1 | Tomas Melero-Smith Park | https://localwiki.org/oakland/Tomas_Melero-Smith_Park | 33501 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.138 | Tomas Melero-Smith Park | |
557 | 557 | 556 | {"type": "Polygon", "coordinates": [[[-122.18787, 37.79778], [-122.18784, 37.7984], [-122.18755, 37.79839], [-122.18753, 37.79873], [-122.18703, 37.7987], [-122.18697, 37.79866], [-122.18687, 37.79848], [-122.18679, 37.79843], [-122.18663, 37.79838], [-122.18627, 37.79833], [-122.18608, 37.79825], [-122.18738, 37.79737], [-122.18754, 37.79737], [-122.18753, 37.79777], [-122.18787, 37.79778]]]} | Open Access 1 | Redwoods Heights Recreation Center | http://www2.oaklandnet.com/Government/o/opr/s/facility/OAK029394 | 30896 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 3.105 | Redwoods Heights Rec. Ctr. | |
696 | 696 | 695 | {"type": "Polygon", "coordinates": [[[-122.22826, 37.7939], [-122.22801, 37.79472], [-122.22759, 37.79463], [-122.22784, 37.79382], [-122.22826, 37.7939]]]} | Open Access 1 | Manzanita Recreation Center | http://www2.oaklandnet.com/Government/o/opr/s/facility/OAK029390 | 30894 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.877 | Manzanita Rec. Ctr. | |
811 | 811 | 810 | {"type": "MultiPolygon", "coordinates": [[[[-122.13402, 37.75711], [-122.12435, 37.76179], [-122.12421, 37.76133], [-122.12405, 37.76104], [-122.12383, 37.76078], [-122.12335, 37.76038], [-122.12319, 37.76017], [-122.12311, 37.75997], [-122.12299, 37.75943], [-122.12292, 37.75926], [-122.12284, 37.75912], [-122.12141, 37.75745], [-122.12744, 37.75461], [-122.12803, 37.75513], [-122.12848, 37.75534], [-122.12896, 37.7558], [-122.12962, 37.75615], [-122.13172, 37.75659], [-122.13288, 37.75663], [-122.13341, 37.75675], [-122.1337, 37.75697], [-122.13402, 37.75711]]], [[[-122.15115, 37.75063], [-122.15104, 37.75107], [-122.15113, 37.75178], [-122.1511, 37.75202], [-122.15073, 37.75275], [-122.15074, 37.7532], [-122.15065, 37.75332], [-122.15021, 37.75313], [-122.14924, 37.75358], [-122.14907, 37.75375], [-122.14902, 37.75387], [-122.14852, 37.75405], [-122.14613, 37.75529], [-122.14571, 37.75555], [-122.14554, 37.75569], [-122.14538, 37.75609], [-122.14457, 37.75636], [-122.14429, 37.75661], [-122.14334, 37.75708], [-122.14136, 37.75741], [-122.1412, 37.75742], [-122.14103, 37.75739], [-122.14042, 37.75708], [-122.14029, 37.75704], [-122.14006, 37.75701], [-122.13985, 37.75704], [-122.13959, 37.75673], [-122.13912, 37.75639], [-122.13928, 37.75624], [-122.13935, 37.75609], [-122.13935, 37.75594], [-122.13926, 37.7557], [-122.13928, 37.75565], [-122.13938, 37.75557], [-122.1394, 37.75551], [-122.13935, 37.75542], [-122.1392, 37.75543], [-122.13914, 37.75547], [-122.13912, 37.75552], [-122.13911, 37.7556], [-122.13924, 37.75594], [-122.13925, 37.75605], [-122.13923, 37.75612], [-122.13919, 37.75619], [-122.13902, 37.75635], [-122.13862, 37.75609], [-122.13864, 37.75602], [-122.13859, 37.75595], [-122.13853, 37.75593], [-122.13841, 37.75592], [-122.13812, 37.75573], [-122.13812, 37.75569], [-122.1382, 37.75556], [-122.13824, 37.75542], [-122.13823, 37.75529], [-122.13816, 37.75516], [-122.13808, 37.75521], [-122.13813, 37.75536], [-122.13813, 37.75543], [-122.1381, 37.75552], [-122.13804, 37.75562], [-122.13793, 37.75571], [-122.13771, 37.75584], [-122.13732, 37.75598], [-122.13713, 37.75607], [-122.13698, 37.75617], [-122.13678, 37.75633], [-122.13627, 37.7566], [-122.1362, 37.7566], [-122.13574, 37.75632], [-122.13565, 37.75636], [-122.13565, 37.75638], [-122.13614, 37.75667], [-122.13628, 37.75674], [-122.13644, 37.75678], [-122.13622, 37.75754], [-122.13541, 37.75738], [-122.1347, 37.75712], [-122.13426, 37.75701], [-122.13383, 37.75684], [-122.13351, 37.7566], [-122.13291, 37.75647], [-122.13175, 37.75643], [-122.12971, 37.756], [-122.1291, 37.75567], [-122.12862, 37.75521], [-122.12817, 37.755], [-122.12763, 37.75453], [-122.14076, 37.74836], [-122.14246, 37.74759], [-122.14321, 37.74882], [-122.14864, 37.7457], [-122.14872, 37.74591], [-122.14899, 37.74624], [-122.14935, 37.74735], [-122.14996, 37.74799], [-122.15044, 37.74889], [-122.1505, 37.74919], [-122.15047, 37.74959], [-122.15085, 37.75023], [-122.1511, 37.75044], [-122.15115, 37.75063]]], [[[-122.139, 37.75637], [-122.13868, 37.75663], [-122.1386, 37.75666], [-122.13774, 37.75653], [-122.1376, 37.75655], [-122.13738, 37.75666], [-122.13722, 37.7567], [-122.13687, 37.75668], [-122.1365, 37.7567], [-122.13645, 37.75669], [-122.13642, 37.75666], [-122.13643, 37.75662], [-122.13684, 37.7564], [-122.1372, 37.75614], [-122.13737, 37.75606], [-122.13776, 37.75591], [-122.138, 37.75579], [-122.13805, 37.7558], [-122.13833, 37.75598], [-122.13836, 37.75601], [-122.13838, 37.75609], [-122.13842, 37.75613], [-122.13852, 37.75614], [-122.1386, 37.75611], [-122.139, 37.75637]]], [[[-122.13982, 37.75705], [-122.13965, 37.75716], [-122.13948, 37.75738], [-122.13933, 37.7575], [-122.13916, 37.75758], [-122.13875, 37.75767], [-122.13866, 37.75773], [-122.13845, 37.75789], [-122.13834, 37.75788], [-122.13803, 37.7577], [-122.138, 37.75768], [-122.13801, 37.75764], [-122.13803, 37.75762], [-122.13827, 37.75758], [-122.13836, 37.75754], [-122.13844, 37.75747], [-122.13849, 37.75736], [-122.1385, 37.75707], [-122.13857, 37.75689], [-122.13868, 37.75675], [-122.1391, 37.75642], [-122.13956, 37.75675], [-122.13982, 37.75705]]]]} | Open Access 1 | Knowland Park/Oakland Zoo | http://www.saveknowland.org/about/ | 7828 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 457.765 | Knowland Park/Oakland Zoo | |
1226 | 1226 | 1225 | {"type": "Polygon", "coordinates": [[[-122.20445, 37.78919], [-122.20338, 37.78987], [-122.203, 37.78953], [-122.20326, 37.78933], [-122.20319, 37.78923], [-122.2033, 37.78914], [-122.20373, 37.78848], [-122.20445, 37.78919]]]} | Open Access 1 | Allendale Park | 15380 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 2.222 | Allendale Park | ||
1342 | 1342 | 1341 | {"type": "Polygon", "coordinates": [[[-122.22256, 37.7762], [-122.22252, 37.77649], [-122.22235, 37.77642], [-122.22253, 37.77619], [-122.22256, 37.7762]]]} | Open Access 1 | 35th Avenue Plaza | 15195 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.074 | 35th Avenue Plaza | ||
1368 | 1368 | 1367 | {"type": "Polygon", "coordinates": [[[-122.27275, 37.81463], [-122.27269, 37.81501], [-122.27229, 37.81496], [-122.27236, 37.81458], [-122.27275, 37.81463]]]} | Open Access 1 | 25th St. Mini Park | 15188 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.375 | 25th St. MP | ||
1619 | 1619 | 1618 | {"type": "Polygon", "coordinates": [[[-122.17762, 37.76178], [-122.17531, 37.76327], [-122.17401, 37.76158], [-122.17408, 37.76156], [-122.17414, 37.76151], [-122.17415, 37.76144], [-122.17413, 37.76139], [-122.17405, 37.76133], [-122.17392, 37.76131], [-122.17367, 37.76098], [-122.17577, 37.75997], [-122.17762, 37.76178]]]} | Open Access 1 | Arroyo Viejo Park | 15635 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 16.301 | Arroyo Viejo Park | ||
1645 | 1645 | 1644 | {"type": "Polygon", "coordinates": [[[-122.25489, 37.79992], [-122.25459, 37.80007], [-122.25445, 37.80018], [-122.25432, 37.80033], [-122.25428, 37.80035], [-122.25424, 37.80034], [-122.25395, 37.80025], [-122.25392, 37.80021], [-122.25392, 37.80017], [-122.25439, 37.79946], [-122.25489, 37.7999], [-122.25489, 37.79992]]]} | Open Access 1 | Athol Plaza Park | 15669 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.009 | Athol Plaza Park | ||
1683 | 1683 | 1682 | {"type": "Polygon", "coordinates": [[[-122.19271, 37.80049], [-122.19223, 37.80069], [-122.19223, 37.80074], [-122.19163, 37.80082], [-122.19163, 37.8007], [-122.19166, 37.80061], [-122.19171, 37.80053], [-122.19181, 37.80044], [-122.19203, 37.80032], [-122.19249, 37.80017], [-122.19271, 37.80049]]]} | Open Access 1 | Avenue Terrance Park | 15726 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.925 | Avenue Terrance Park | ||
1859 | 1859 | 1858 | {"type": "MultiPolygon", "coordinates": [[[[-122.1954, 37.82229], [-122.19539, 37.82275], [-122.19527, 37.82277], [-122.19515, 37.82276], [-122.19508, 37.82279], [-122.19504, 37.82282], [-122.19503, 37.82287], [-122.19507, 37.82295], [-122.19491, 37.82308], [-122.19499, 37.82334], [-122.19473, 37.82344], [-122.19435, 37.82312], [-122.19461, 37.82274], [-122.19468, 37.82212], [-122.1954, 37.82229]]], [[[-122.19681, 37.82266], [-122.19664, 37.82301], [-122.19628, 37.82287], [-122.19606, 37.82281], [-122.19577, 37.82276], [-122.19543, 37.82274], [-122.19543, 37.82229], [-122.19653, 37.82252], [-122.19681, 37.82266]]]]} | Open Access 1 | Beaconsfield Canyon | 15914 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 3.074 | Beaconsfield Canyon | ||
1882 | 1882 | 1881 | {"type": "Polygon", "coordinates": [[[-122.22879, 37.80296], [-122.22874, 37.80319], [-122.22866, 37.80321], [-122.22861, 37.80339], [-122.22866, 37.80346], [-122.22861, 37.80361], [-122.22813, 37.80352], [-122.22803, 37.80397], [-122.22751, 37.80389], [-122.22783, 37.80276], [-122.22879, 37.80296]]]} | Open Access 1 | Beaumont Park | 15940 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 2.167 | Beaumont Park | ||
1899 | 1899 | 1898 | {"type": "Polygon", "coordinates": [[[-122.2734, 37.81151], [-122.27319, 37.81157], [-122.27305, 37.81166], [-122.27319, 37.81109], [-122.27321, 37.81107], [-122.27324, 37.81107], [-122.27326, 37.81109], [-122.2734, 37.81151]]]} | Open Access 1 | Begin Plaza Park | 15954 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.248 | Begin Plaza Park | ||
1905 | 1905 | 1904 | {"type": "Polygon", "coordinates": [[[-122.23869, 37.79974], [-122.23813, 37.80013], [-122.23755, 37.79959], [-122.23809, 37.79919], [-122.23869, 37.79974]]]} | Open Access 1 | Bella Vista Park | 15981 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.284 | Bella Vista Park | ||
1922 | 1922 | 1921 | {"type": "Polygon", "coordinates": [[[-122.17895, 37.73253], [-122.17879, 37.73284], [-122.17879, 37.73286], [-122.17869, 37.73296], [-122.17862, 37.73298], [-122.17826, 37.73236], [-122.17857, 37.73236], [-122.17895, 37.73253]]]} | Open Access 1 | Carney Park | 16886 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.559 | Carney Park | ||
2277 | 2277 | 2276 | {"type": "Polygon", "coordinates": [[[-122.2066, 37.78294], [-122.20591, 37.78344], [-122.20537, 37.78298], [-122.20506, 37.78319], [-122.20435, 37.78257], [-122.20519, 37.78169], [-122.2066, 37.78294]]]} | Open Access 1 | BROOKDALE PARK | 16420 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 4.552 | BROOKDALE PARK | ||
2288 | 2288 | 2287 | {"type": "Polygon", "coordinates": [[[-122.21848, 37.77884], [-122.21773, 37.77981], [-122.21745, 37.77956], [-122.21813, 37.77872], [-122.21826, 37.77849], [-122.21752, 37.77811], [-122.2176, 37.778], [-122.21846, 37.77842], [-122.21848, 37.77884]]]} | Open Access 1 | Cesar Chavez Park | 17097 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.525 | Cesar Chavez 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]);