superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
122 rows where MNG_AGENCY = 56 sorted by map
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
8171 | 8171 | 8170 | {"type": "Polygon", "coordinates": [[[-122.17517, 37.79591], [-122.17479, 37.79667], [-122.17463, 37.79685], [-122.17459, 37.79689], [-122.17386, 37.79706], [-122.1738, 37.79704], [-122.1739, 37.7965], [-122.17369, 37.796], [-122.17347, 37.79585], [-122.17326, 37.79579], [-122.17315, 37.79564], [-122.1737, 37.79569], [-122.17396, 37.79587], [-122.17462, 37.79574], [-122.17488, 37.79576], [-122.17517, 37.79591]]]} | Open Access 1 | Pinto Park | 23708 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 3.421 | Pinto Park | 1961 | |
3967 | 3967 | 3966 | {"type": "Polygon", "coordinates": [[[-122.17538, 37.74328], [-122.17464, 37.74363], [-122.17402, 37.74281], [-122.17476, 37.74246], [-122.17538, 37.74328]]]} | Open Access 1 | Elmhurst Plaza | 18598 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 2.01 | Elmhurst Plaza | ||
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 | ||
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 | ||
9752 | 9752 | 9751 | {"type": "Polygon", "coordinates": [[[-122.17764, 37.72612], [-122.17735, 37.72742], [-122.17733, 37.72744], [-122.17726, 37.72744], [-122.17601, 37.72728], [-122.17597, 37.72726], [-122.17595, 37.72722], [-122.1762, 37.72594], [-122.17764, 37.72612]]]} | Open Access 1 | Sobrante Park | 25587 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 4.682 | Sobrante 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 | ||
6789 | 6789 | 6788 | {"type": "Polygon", "coordinates": [[[-122.18259, 37.79131], [-122.18261, 37.79144], [-122.18259, 37.79225], [-122.18252, 37.79255], [-122.18163, 37.79162], [-122.1816, 37.79123], [-122.18178, 37.79125], [-122.18199, 37.79117], [-122.18227, 37.79112], [-122.18259, 37.79131]]]} | Open Access 1 | Mc Crea Park | 21986 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 2.147 | Mc Crea Park | ||
3140 | 3140 | 3139 | {"type": "Polygon", "coordinates": [[[-122.18437, 37.77273], [-122.18343, 37.77353], [-122.18268, 37.77286], [-122.18334, 37.77241], [-122.18287, 37.77195], [-122.18325, 37.77171], [-122.18437, 37.77273]]]} | Open Access 1 | Concordia Park | 17577 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 3.5 | Concordia Park | ||
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 | ||
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. | |
4302 | 4302 | 4301 | {"type": "Polygon", "coordinates": [[[-122.19178, 37.73593], [-122.19137, 37.73616], [-122.19116, 37.73688], [-122.19077, 37.73841], [-122.18827, 37.73776], [-122.18881, 37.73569], [-122.19025, 37.736], [-122.19032, 37.73605], [-122.19074, 37.7357], [-122.19104, 37.73566], [-122.19126, 37.73533], [-122.19178, 37.73593]]]} | Open Access 1 | Ira Jenkins Park | 20226 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 15.164 | Ira Jenkins 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 | ||
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 | |
4742 | 4742 | 4741 | {"type": "Polygon", "coordinates": [[[-122.19545, 37.76061], [-122.19446, 37.76127], [-122.19282, 37.75967], [-122.1938, 37.759], [-122.19545, 37.76061]]]} | Open Access 1 | Greenman Field | 19482 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 6.433 | Greenman Field | ||
3087 | 3087 | 3086 | {"type": "Polygon", "coordinates": [[[-122.19938, 37.75713], [-122.19924, 37.75722], [-122.19918, 37.75734], [-122.19815, 37.75822], [-122.19753, 37.7576], [-122.19759, 37.75714], [-122.19761, 37.75711], [-122.1977, 37.75643], [-122.19856, 37.7565], [-122.19859, 37.75649], [-122.19874, 37.7565], [-122.19938, 37.75713]]]} | Open Access 1 | Coliseum Gardens Park | 17499 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 4.999 | Coliseum Gardens 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 | ||
6773 | 6773 | 6772 | {"type": "Polygon", "coordinates": [[[-122.20043, 37.78154], [-122.19989, 37.78191], [-122.19929, 37.78137], [-122.19982, 37.781], [-122.20043, 37.78154]]]} | Open Access 1 | Maxwell Park | 21971 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.249 | Maxwell Park | 2000 | |
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. | |
810 | 810 | 809 | {"type": "Polygon", "coordinates": [[[-122.20157, 37.81532], [-122.20142, 37.81555], [-122.2014, 37.81575], [-122.20146, 37.8158], [-122.20146, 37.81584], [-122.20097, 37.8158], [-122.20056, 37.81601], [-122.20054, 37.81613], [-122.20019, 37.81597], [-122.19966, 37.8158], [-122.19955, 37.81598], [-122.19941, 37.81587], [-122.19921, 37.81575], [-122.19877, 37.81564], [-122.19877, 37.81557], [-122.1987, 37.81546], [-122.19863, 37.81541], [-122.19703, 37.81651], [-122.19701, 37.81655], [-122.19704, 37.81659], [-122.19676, 37.81653], [-122.19667, 37.81649], [-122.19723, 37.81594], [-122.19699, 37.81577], [-122.19615, 37.81538], [-122.19595, 37.81551], [-122.1959, 37.81548], [-122.19574, 37.81536], [-122.19547, 37.81505], [-122.19536, 37.81498], [-122.19527, 37.81494], [-122.19439, 37.81472], [-122.19421, 37.81495], [-122.19414, 37.8151], [-122.19397, 37.81504], [-122.19377, 37.815], [-122.19359, 37.81499], [-122.1933, 37.81499], [-122.19336, 37.81473], [-122.19313, 37.81468], [-122.19285, 37.81469], [-122.19258, 37.81467], [-122.19247, 37.8149], [-122.19183, 37.81483], [-122.1918, 37.81498], [-122.19231, 37.81504], [-122.19168, 37.81531], [-122.19109, 37.81532], [-122.19078, 37.81542], [-122.19056, 37.81561], [-122.19054, 37.81622], [-122.19, 37.81646], [-122.18994, 37.81683], [-122.18964, 37.81712], [-122.1895, 37.81732], [-122.18933, 37.81746], [-122.189, 37.81788], [-122.18886, 37.81809], [-122.18858, 37.81855], [-122.18853, 37.81871], [-122.18854, 37.81883], [-122.18857, 37.81893], [-122.18885, 37.81928], [-122.18889, 37.81942], [-122.18871, 37.8198], [-122.18861, 37.81985], [-122.18856, 37.81986], [-122.18761, 37.81989], [-122.18747, 37.82002], [-122.18749, 37.8204], [-122.18742, 37.82057], [-122.18705, 37.82107], [-122.18682, 37.82133], [-122.18687, 37.82208], [-122.18559, 37.82072], [-122.1854, 37.8207], [-122.18543, 37.82053], [-122.18443, 37.82041], [-122.18438, 37.82057], [-122.18359, 37.82048], [-122.1812, 37.81931], [-122.18035, 37.81815], [-122.1784, 37.81671], [-122.17548, 37.81459], [-122.17433, 37.81083], [-122.17322, 37.81037], [-122.17377, 37.80952], [-122.17445, 37.80979], [-122.17561, 37.80792], [-122.17558, 37.80776], [-122.1756, 37.80762], [-122.17565, 37.80748], [-122.17579, 37.80731], [-122.17599, 37.80718], [-122.17624, 37.80711], [-122.1765, 37.8071], [-122.1767, 37.80713], [-122.17777, 37.80667], [-122.1785, 37.80577], [-122.1785, 37.80568], [-122.17851, 37.80554], [-122.17856, 37.8054], [-122.17865, 37.80528], [-122.17883, 37.80513], [-122.17898, 37.80506], [-122.17912, 37.80502], [-122.17916, 37.80498], [-122.178, 37.8037], [-122.1784, 37.80395], [-122.17912, 37.80431], [-122.17949, 37.80507], [-122.1796, 37.80546], [-122.17974, 37.80607], [-122.17954, 37.80716], [-122.18001, 37.80727], [-122.18037, 37.8078], [-122.18048, 37.80862], [-122.18085, 37.80901], [-122.18212, 37.80963], [-122.18494, 37.80969], [-122.18573, 37.80942], [-122.18698, 37.8093], [-122.18763, 37.80938], [-122.18781, 37.80945], [-122.18775, 37.80956], [-122.18776, 37.80958], [-122.1883, 37.80978], [-122.18855, 37.80984], [-122.18874, 37.80988], [-122.18897, 37.80989], [-122.1892, 37.80988], [-122.19067, 37.80971], [-122.19101, 37.80972], [-122.1913, 37.80979], [-122.19153, 37.80987], [-122.19242, 37.81032], [-122.19284, 37.81049], [-122.19327, 37.81061], [-122.1945, 37.81086], [-122.19414, 37.81112], [-122.19378, 37.8117], [-122.19425, 37.8119], [-122.19397, 37.81239], [-122.19457, 37.81263], [-122.1939, 37.81371], [-122.1939, 37.81373], [-122.19462, 37.81392], [-122.195, 37.81392], [-122.19517, 37.81398], [-122.19545, 37.814], [-122.19569, 37.81406], [-122.19589, 37.81394], [-122.19595, 37.81396], [-122.19629, 37.81394], [-122.19665, 37.81407], [-122.19701, 37.81431], [-122.1973, 37.81459], [-122.19757, 37.81475], [-122.19785, 37.81479], [-122.19773, 37.81487], [-122.19782, 37.81496], [-122.19828, 37.81491], [-122.19837, 37.81497], [-122.1986, 37.81499], [-122.19877, 37.81504], [-122.19887, 37.81514], [-122.19901, 37.81517], [-122.19903, 37.8152], [-122.20076, 37.81408], [-122.20117, 37.81462], [-122.20156, 37.81525], [-122.20157, 37.81532]], [[-122.18547, 37.81936], [-122.18548, 37.81934], [-122.18537, 37.81927], [-122.1853, 37.81917], [-122.18527, 37.81909], [-122.18525, 37.81893], [-122.18522, 37.81884], [-122.18518, 37.81875], [-122.1851, 37.81868], [-122.18501, 37.81863], [-122.1849, 37.8186], [-122.18467, 37.81859], [-122.18446, 37.81861], [-122.18429, 37.81865], [-122.18418, 37.81871], [-122.1841, 37.81879], [-122.18405, 37.8189], [-122.18405, 37.81898], [-122.18407, 37.81907], [-122.18411, 37.81915], [-122.18429, 37.8194], [-122.1843, 37.81945], [-122.1843, 37.8195], [-122.18424, 37.81956], [-122.18416, 37.8196], [-122.18408, 37.8196], [-122.18395, 37.81957], [-122.18382, 37.81951], [-122.18312, 37.81911], [-122.18302, 37.819], [-122.18276, 37.8186], [-122.18265, 37.81849], [-122.18253, 37.81842], [-122.18225, 37.81827], [-122.18203, 37.81818], [-122.18183, 37.81813], [-122.18141, 37.81804], [-122.18122, 37.81797], [-122.18109, 37.8179], [-122.18092, 37.81777], [-122.18077, 37.81763], [-122.18066, 37.81749], [-122.18059, 37.81761], [-122.18067, 37.81771], [-122.18085, 37.81788], [-122.18101, 37.81799], [-122.18116, 37.81808], [-122.18136, 37.81815], [-122.18177, 37.81823], [-122.18199, 37.8183], [-122.18227, 37.81842], [-122.18254, 37.81857], [-122.18267, 37.81869], [-122.18289, 37.81906], [-122.18301, 37.81918], [-122.1831, 37.81925], [-122.18375, 37.81961], [-122.18389, 37.81967], [-122.18407, 37.81971], [-122.1842, 37.81971], [-122.18433, 37.81966], [-122.18442, 37.81956], [-122.18445, 37.81948], [-122.18443, 37.81938], [-122.18423, 37.81907], [-122.18419, 37.81893], [-122.18422, 37.81885], [-122.18427, 37.81879], [-122.18434, 37.81875], [-122.18445, 37.81873], [-122.18461, 37.81871], [-122.1848, 37.81871], [-122.18491, 37.81872], [-122.18499, 37.81875], [-122.18504, 37.8188], [-122.18508, 37.81888], [-122.18513, 37.81914], [-122.18521, 37.81929], [-122.18535, 37.81941], [-122.18547, 37.81936]]]} | Open Access 1 | Joaquin Miller Park | http://www2.oaklandnet.com/Government/o/opr/s/Parks/JoaquinMiller/ | 7825 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 439.074 | Joaquin Miller Park | 1917 |
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]);