superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
122 rows where ACCESS_TYP = 1 and MNG_AGENCY = 56 sorted by YR_EST descending
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 ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
9242 | 9242 | 9241 | {"type": "Polygon", "coordinates": [[[-122.22637, 37.78087], [-122.226, 37.78126], [-122.22441, 37.78073], [-122.22462, 37.78033], [-122.22637, 37.78087]]]} | Open Access 1 | Sanborn Park | 25005 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1.968 | Sanborn Park | 2000 | |
2821 | 2821 | 2820 | {"type": "Polygon", "coordinates": [[[-122.24204, 37.85062], [-122.23985, 37.85093], [-122.23982, 37.85109], [-122.2391, 37.85125], [-122.23883, 37.8512], [-122.23693, 37.85067], [-122.23681, 37.85044], [-122.23681, 37.85023], [-122.23658, 37.84995], [-122.23623, 37.84978], [-122.23624, 37.84932], [-122.23667, 37.84953], [-122.23731, 37.84991], [-122.23785, 37.85015], [-122.23846, 37.85028], [-122.23905, 37.85035], [-122.24001, 37.85032], [-122.2408, 37.85019], [-122.24128, 37.85007], [-122.24168, 37.84993], [-122.24196, 37.84972], [-122.24204, 37.85062]]]} | Open Access 1 | Chabot Park | 17109 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 10.308 | Chabot Park | 1961 | |
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 | |
5943 | 5943 | 5942 | {"type": "Polygon", "coordinates": [[[-122.26211, 37.81037], [-122.26187, 37.81046], [-122.26141, 37.8104], [-122.26121, 37.81003], [-122.26124, 37.80951], [-122.26139, 37.80882], [-122.26145, 37.80722], [-122.26125, 37.80701], [-122.26115, 37.80678], [-122.26059, 37.80677], [-122.26018, 37.80656], [-122.26, 37.80604], [-122.25945, 37.80556], [-122.25897, 37.80479], [-122.25862, 37.80467], [-122.25787, 37.80485], [-122.2566, 37.80538], [-122.25631, 37.8057], [-122.25625, 37.80655], [-122.25573, 37.80703], [-122.25541, 37.80719], [-122.25475, 37.80716], [-122.254, 37.80703], [-122.25305, 37.80712], [-122.25224, 37.80751], [-122.25146, 37.8081], [-122.25109, 37.80815], [-122.24995, 37.80847], [-122.24972, 37.80838], [-122.24972, 37.80785], [-122.24999, 37.80721], [-122.2503, 37.80668], [-122.25074, 37.80566], [-122.2511, 37.80499], [-122.25117, 37.80494], [-122.2534, 37.80418], [-122.25372, 37.80369], [-122.2539, 37.80321], [-122.25472, 37.80211], [-122.25473, 37.80206], [-122.25483, 37.80191], [-122.25473, 37.80158], [-122.25473, 37.80085], [-122.25507, 37.80057], [-122.25551, 37.80043], [-122.25654, 37.80053], [-122.25712, 37.80039], [-122.25836, 37.79968], [-122.25882, 37.7992], [-122.25917, 37.79895], [-122.26125, 37.79996], [-122.26139, 37.80021], [-122.26151, 37.80087], [-122.2613, 37.80222], [-122.26104, 37.80261], [-122.2605, 37.80382], [-122.26049, 37.8045], [-122.26147, 37.80527], [-122.26245, 37.80641], [-122.2628, 37.80726], [-122.2628, 37.80815], [-122.2626, 37.8087], [-122.26228, 37.81014], [-122.26211, 37.81037]]]} | Open Access 1 | Lake Merritt | 20953 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 141.453 | Lake Merritt | 1957 | |
5962 | 5962 | 5961 | {"type": "Polygon", "coordinates": [[[-122.26242, 37.8014], [-122.26237, 37.80162], [-122.26208, 37.80217], [-122.26155, 37.80288], [-122.26109, 37.80373], [-122.26084, 37.80396], [-122.26089, 37.8044], [-122.26189, 37.80504], [-122.26215, 37.80532], [-122.26263, 37.80595], [-122.26307, 37.80667], [-122.26317, 37.80719], [-122.26324, 37.80769], [-122.26311, 37.80829], [-122.26227, 37.81082], [-122.26051, 37.81049], [-122.26017, 37.81039], [-122.25939, 37.80971], [-122.2588, 37.80938], [-122.25734, 37.80894], [-122.25617, 37.80888], [-122.25636, 37.80844], [-122.25619, 37.8078], [-122.25601, 37.80743], [-122.25554, 37.80755], [-122.25504, 37.80764], [-122.2537, 37.80773], [-122.25297, 37.80784], [-122.25262, 37.80813], [-122.25253, 37.80863], [-122.25103, 37.8085], [-122.25052, 37.80855], [-122.25007, 37.80874], [-122.24979, 37.80872], [-122.24946, 37.80849], [-122.24937, 37.80821], [-122.24938, 37.80814], [-122.24951, 37.80799], [-122.24951, 37.80786], [-122.24948, 37.80768], [-122.24986, 37.80679], [-122.25044, 37.80568], [-122.25084, 37.80475], [-122.25116, 37.80442], [-122.25141, 37.80432], [-122.25202, 37.80423], [-122.2524, 37.80414], [-122.25305, 37.804], [-122.25335, 37.8038], [-122.25347, 37.80355], [-122.25355, 37.80325], [-122.25378, 37.80283], [-122.25414, 37.80248], [-122.25431, 37.80217], [-122.25447, 37.80169], [-122.25438, 37.80077], [-122.25461, 37.80048], [-122.25462, 37.80041], [-122.25474, 37.80032], [-122.25512, 37.80013], [-122.25557, 37.80006], [-122.25664, 37.79994], [-122.25722, 37.79985], [-122.25777, 37.79968], [-122.25819, 37.79935], [-122.25824, 37.7993], [-122.25824, 37.79923], [-122.25858, 37.79896], [-122.25888, 37.79866], [-122.25918, 37.79855], [-122.26011, 37.79887], [-122.26116, 37.79921], [-122.26165, 37.79967], [-122.26184, 37.79996], [-122.26198, 37.80044], [-122.26215, 37.80084], [-122.26242, 37.8014]], [[-122.26145, 37.80722], [-122.26139, 37.80882], [-122.26124, 37.80951], [-122.26121, 37.81003], [-122.26141, 37.8104], [-122.26188, 37.81046], [-122.26211, 37.81037], [-122.26228, 37.81014], [-122.2626, 37.8087], [-122.2628, 37.80815], [-122.2628, 37.80726], [-122.26245, 37.80641], [-122.26148, 37.80527], [-122.26049, 37.80451], [-122.26049, 37.80382], [-122.26104, 37.80261], [-122.2613, 37.80222], [-122.26151, 37.80087], [-122.26139, 37.80021], [-122.26124, 37.79995], [-122.25917, 37.79895], [-122.25882, 37.7992], [-122.25836, 37.79968], [-122.25712, 37.80039], [-122.25654, 37.80053], [-122.25551, 37.80043], [-122.25507, 37.80057], [-122.25473, 37.80084], [-122.25473, 37.80158], [-122.25484, 37.8019], [-122.25473, 37.80206], [-122.25472, 37.8021], [-122.2539, 37.8032], [-122.25372, 37.80369], [-122.2534, 37.80419], [-122.25118, 37.80494], [-122.2511, 37.80499], [-122.25074, 37.80566], [-122.2503, 37.80668], [-122.24999, 37.80721], [-122.24972, 37.80785], [-122.24972, 37.80836], [-122.24995, 37.80847], [-122.25109, 37.80815], [-122.25146, 37.8081], [-122.25224, 37.80751], [-122.25305, 37.80712], [-122.254, 37.80703], [-122.25475, 37.80716], [-122.25542, 37.80718], [-122.25573, 37.80702], [-122.25625, 37.80655], [-122.25631, 37.8057], [-122.2566, 37.80538], [-122.25787, 37.80485], [-122.25862, 37.80467], [-122.25897, 37.80479], [-122.25945, 37.80556], [-122.26, 37.80604], [-122.26019, 37.80656], [-122.26059, 37.80677], [-122.26115, 37.80678], [-122.26125, 37.80701], [-122.26145, 37.80722]]]} | Open Access 1 | Lakeside Park | 20979 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 89.393 | Lakeside Park | 1957 | |
7460 | 7460 | 7459 | {"type": "Polygon", "coordinates": [[[-122.22695, 37.84735], [-122.22693, 37.8474], [-122.2263, 37.84745], [-122.22594, 37.8475], [-122.22559, 37.84757], [-122.22508, 37.84772], [-122.22455, 37.84792], [-122.22289, 37.84789], [-122.22304, 37.84852], [-122.22278, 37.84872], [-122.22254, 37.84894], [-122.22236, 37.84914], [-122.22218, 37.8494], [-122.22203, 37.84966], [-122.22192, 37.84994], [-122.22185, 37.85023], [-122.22181, 37.85052], [-122.22181, 37.85076], [-122.22184, 37.851], [-122.22189, 37.85124], [-122.22195, 37.85143], [-122.22203, 37.8516], [-122.22225, 37.85154], [-122.22247, 37.85196], [-122.22251, 37.85207], [-122.22256, 37.85232], [-122.22256, 37.85257], [-122.2213, 37.85272], [-122.22104, 37.85291], [-122.21964, 37.85377], [-122.21947, 37.85385], [-122.21927, 37.85392], [-122.21896, 37.85398], [-122.21833, 37.85401], [-122.21821, 37.85398], [-122.21813, 37.85399], [-122.21807, 37.85401], [-122.21802, 37.85406], [-122.21801, 37.85412], [-122.21803, 37.85417], [-122.21736, 37.85418], [-122.21723, 37.85416], [-122.21682, 37.85452], [-122.2165, 37.85461], [-122.21619, 37.85474], [-122.2159, 37.85488], [-122.21563, 37.85504], [-122.21537, 37.85522], [-122.21472, 37.85574], [-122.21456, 37.85528], [-122.21446, 37.85531], [-122.21412, 37.85495], [-122.21413, 37.85407], [-122.2154, 37.85398], [-122.2153, 37.85298], [-122.21486, 37.85316], [-122.21472, 37.85311], [-122.21478, 37.85298], [-122.21527, 37.85273], [-122.21523, 37.85236], [-122.21392, 37.85227], [-122.21355, 37.8522], [-122.21365, 37.85158], [-122.21364, 37.85136], [-122.21335, 37.85137], [-122.2137, 37.84989], [-122.21409, 37.84967], [-122.21409, 37.84966], [-122.21408, 37.84965], [-122.2126, 37.85015], [-122.21271, 37.85002], [-122.21287, 37.84975], [-122.21318, 37.84947], [-122.21941, 37.84738], [-122.22455, 37.84748], [-122.22457, 37.84736], [-122.22594, 37.84738], [-122.22695, 37.84735]]]} | Open Access 1 | North Oakland Sports Center | 22835 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 124.213 | North Oakland Sports Ctr. | 1949 | |
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 |
7232 | 7232 | 7231 | {"type": "Polygon", "coordinates": [[[-122.26189, 37.82383], [-122.26156, 37.82507], [-122.26052, 37.82483], [-122.25985, 37.82466], [-122.25897, 37.82438], [-122.25893, 37.82436], [-122.25891, 37.82431], [-122.25892, 37.82427], [-122.25984, 37.82279], [-122.26038, 37.82299], [-122.2614, 37.82321], [-122.2614, 37.8233], [-122.26143, 37.82338], [-122.26189, 37.82383]]]} | Open Access 1 | Mosswood Park | 22516 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 10.31 | Mosswood Park | 1912 | |
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 | |
3521 | 3521 | 3520 | {"type": "Polygon", "coordinates": [[[-122.28859, 37.81185], [-122.28813, 37.81311], [-122.28611, 37.81266], [-122.28528, 37.8123], [-122.28569, 37.81119], [-122.28859, 37.81185]]]} | Open Access 1 | DeFremery Park | 18017 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 9.427 | DeFremery Park | 1910 | |
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 |
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]);