superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
122 rows where MNG_AGENCY = 56 sorted by LABEL_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
2375 | 2375 | 2374 | {"type": "Polygon", "coordinates": [[[-122.26514, 37.84588], [-122.26212, 37.84635], [-122.2619, 37.84545], [-122.26324, 37.84525], [-122.26317, 37.84488], [-122.26367, 37.84481], [-122.26376, 37.84516], [-122.26392, 37.84514], [-122.26385, 37.84478], [-122.26406, 37.84475], [-122.26411, 37.8451], [-122.26423, 37.8451], [-122.2642, 37.84473], [-122.26447, 37.84468], [-122.26453, 37.84505], [-122.26502, 37.84498], [-122.26514, 37.84588]]]} | Open Access 1 | Bushrod Recreation Center | 16540 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 7.777 | Bushrod Rec. Ctr. | 1910 | |
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 | ||
2784 | 2784 | 2783 | {"type": "Polygon", "coordinates": [[[-122.2254, 37.79572], [-122.22489, 37.79726], [-122.2254, 37.79739], [-122.22534, 37.79752], [-122.22512, 37.79788], [-122.22476, 37.79824], [-122.22455, 37.79614], [-122.22445, 37.7959], [-122.22414, 37.79575], [-122.22369, 37.79573], [-122.22272, 37.79592], [-122.22233, 37.79614], [-122.22223, 37.79637], [-122.22215, 37.79767], [-122.2213, 37.79752], [-122.22212, 37.79528], [-122.22285, 37.79546], [-122.22296, 37.79513], [-122.2254, 37.79572]]]} | Open Access 1 | Central Reservoir Park | 17073 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 9.134 | Central Reservoir 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]);