units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
99 rows where ACCESS_TYP = 1, DES_TP = 2 and MNG_AGENCY = 56 sorted by rowid descending
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 99 ✖
Link | rowid ▲ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14804 | 14804 | 14803 | {"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 | 47998 | Bertha Port Park | 32420 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.218 | Bertha Port Park | 0 | Local Park 2 | 4 | |
14644 | 14644 | 14643 | {"type": "Polygon", "coordinates": [[[-122.25431, 37.80143], [-122.25437, 37.80161], [-122.25436, 37.80178], [-122.25413, 37.80225], [-122.25409, 37.80231], [-122.254, 37.80238], [-122.25392, 37.80242], [-122.2538, 37.80244], [-122.2537, 37.80244], [-122.2536, 37.80242], [-122.25338, 37.8023], [-122.25319, 37.80214], [-122.25379, 37.80196], [-122.25365, 37.80159], [-122.25431, 37.80143]]]} | Open Access 1 | 44892 | Pine Knoll Park | 23681 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 1.509 | Pine Knoll Park | 0 | Local Park 2 | 4 | |
13080 | 13080 | 13079 | {"type": "Polygon", "coordinates": [[[-122.17595, 37.73669], [-122.1741, 37.73813], [-122.17386, 37.73782], [-122.17511, 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.73641], [-122.17595, 37.73669]]]} | Open Access 1 | 45011 | Stonehurst Park | 25890 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 3.471 | Stonehurst Park | 0 | Local Park 2 | 4 | |
12591 | 12591 | 12590 | {"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 | 48775 | Tomas Melero-Smith Park | 33501 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | https://localwiki.org/oakland/Tomas_Melero-Smith_Park | Alameda 17 | 0.138 | Tomas Melero-Smith Park | 0 | Local Park 2 | 4 |
12240 | 12240 | 12239 | {"type": "Polygon", "coordinates": [[[-122.2692, 37.78832], [-122.26784, 37.7905], [-122.26673, 37.79006], [-122.26651, 37.79041], [-122.26597, 37.79022], [-122.26578, 37.79011], [-122.26541, 37.79026], [-122.26406, 37.79116], [-122.26366, 37.7911], [-122.26364, 37.79113], [-122.2627, 37.79097], [-122.26272, 37.79082], [-122.26329, 37.79083], [-122.26769, 37.78754], [-122.26822, 37.78774], [-122.2692, 37.78832]]]} | Open Access 1 | 25444 | Estuary Park | 18732 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 20.666 | Estuary Park | 0 | Local Park 2 | 4 | |
12102 | 12102 | 12101 | {"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 | 24941 | Athol Plaza Park | 15669 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 1.009 | Athol Plaza Park | 0 | Local Park 2 | 4 | |
11305 | 11305 | 11304 | {"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.26088, 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.25602, 37.80742], [-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.25203, 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.25462, 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.25859, 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.26187, 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.26147, 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.79996], [-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.80321], [-122.25372, 37.80369], [-122.2534, 37.80419], [-122.25117, 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.80837], [-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.80719], [-122.25573, 37.80703], [-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.26018, 37.80656], [-122.26059, 37.80677], [-122.26115, 37.80678], [-122.26125, 37.80701], [-122.26145, 37.80722]]]} | Open Access 1 | 21997 | Lakeside Park | 20979 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 89.363 | Lakeside Park | 1957 | Local Park 2 | 4 | |
11169 | 11169 | 11168 | {"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 | 47999 | Oak Park | 32421 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.493 | Oak Park | 0 | Local Park 2 | 4 | |
11168 | 11168 | 11167 | {"type": "Polygon", "coordinates": [[[-122.33381, 37.80525], [-122.33311, 37.80588], [-122.33301, 37.80592], [-122.33295, 37.80585], [-122.3326, 37.80603], [-122.33238, 37.80574], [-122.33272, 37.80548], [-122.33265, 37.80541], [-122.33289, 37.80523], [-122.33297, 37.80522], [-122.33381, 37.80525]]]} | Open Access 1 | 47997 | Port View Park | 32419 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 1.429 | Port View Park | 0 | Local Park 2 | 4 | |
11167 | 11167 | 11166 | {"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 | 47996 | Redondo Park | 32418 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.25 | Redondo Park | 0 | Local Park 2 | 4 | |
11166 | 11166 | 11165 | {"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.84226], [-122.26845, 37.84222], [-122.2686, 37.84295]]]} | Open Access 1 | 47995 | Dover Street Park | 32417 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | https://www.oaklandca.gov/services/find-a-parks-and-recreation-location | Alameda 17 | 1.139 | Dover Street Park | 0 | Local Park 2 | 4 |
10604 | 10604 | 10603 | {"type": "Polygon", "coordinates": [[[-122.29549, 37.81605], [-122.29454, 37.81724], [-122.29214, 37.81603], [-122.29309, 37.81485], [-122.29549, 37.81605]]]} | Open Access 1 | 18955 | Raimondi Park | 24081 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 9.66 | Raimondi Park | 0 | Local Park 2 | 4 | |
9932 | 9932 | 9931 | {"type": "Polygon", "coordinates": [[[-122.20157, 37.81532], [-122.20142, 37.81555], [-122.2014, 37.81576], [-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.19965, 37.8158], [-122.19955, 37.81598], [-122.19942, 37.81587], [-122.19921, 37.81575], [-122.19877, 37.81564], [-122.19877, 37.81557], [-122.1987, 37.81546], [-122.19863, 37.8154], [-122.19703, 37.81651], [-122.19701, 37.81655], [-122.19704, 37.81659], [-122.19676, 37.81653], [-122.19667, 37.81649], [-122.19724, 37.81594], [-122.19699, 37.81577], [-122.19615, 37.81537], [-122.19595, 37.81551], [-122.1959, 37.81548], [-122.19575, 37.81537], [-122.19547, 37.81505], [-122.19536, 37.81498], [-122.19526, 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.81472], [-122.19312, 37.81468], [-122.19285, 37.81469], [-122.19258, 37.81466], [-122.19247, 37.8149], [-122.19182, 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.81745], [-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.18558, 37.82072], [-122.1854, 37.8207], [-122.18543, 37.82053], [-122.18442, 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.8098], [-122.17561, 37.80792], [-122.17558, 37.80775], [-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.17851, 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.17913, 37.80502], [-122.17917, 37.80497], [-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.18084, 37.80901], [-122.18212, 37.80963], [-122.18494, 37.80969], [-122.18573, 37.80942], [-122.18697, 37.8093], [-122.18763, 37.80938], [-122.18781, 37.80945], [-122.18775, 37.80957], [-122.18775, 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.19377, 37.81171], [-122.19425, 37.8119], [-122.19396, 37.81239], [-122.19457, 37.81263], [-122.1939, 37.81371], [-122.1939, 37.81373], [-122.19462, 37.81392], [-122.195, 37.81392], [-122.19516, 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.19772, 37.81488], [-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.81526], [-122.20157, 37.81532]], [[-122.18548, 37.81936], [-122.18548, 37.81934], [-122.18537, 37.81927], [-122.1853, 37.81917], [-122.18527, 37.81909], [-122.18525, 37.81892], [-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.18065, 37.81748], [-122.18059, 37.81761], [-122.18067, 37.81771], [-122.18085, 37.81788], [-122.18101, 37.818], [-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.1839, 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.18492, 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.81942], [-122.18548, 37.81936]]]} | Open Access 1 | 17088 | Joaquin Miller Park | 7825 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/s/Parks/JoaquinMiller/ | Alameda 17 | 438.978 | Joaquin Miller Park | 1917 | Local Park 2 | 4 |
9755 | 9755 | 9754 | {"type": "Polygon", "coordinates": [[[-122.24086, 37.86105], [-122.2407, 37.86115], [-122.24054, 37.86122], [-122.23942, 37.86156], [-122.23912, 37.86183], [-122.2385, 37.86195], [-122.2379, 37.86217], [-122.23746, 37.86261], [-122.23669, 37.86293], [-122.23628, 37.86296], [-122.23574, 37.86316], [-122.23532, 37.86319], [-122.23511, 37.86136], [-122.23714, 37.86126], [-122.23726, 37.86127], [-122.23739, 37.86124], [-122.24086, 37.86105]]]} | Open Access 1 | 16597 | Garber Park | 19189 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 13.847 | Garber Park | 0 | Local Park 2 | 4 | |
9394 | 9394 | 9393 | {"type": "MultiPolygon", "coordinates": [[[[-122.21418, 37.81309], [-122.21399, 37.81324], [-122.21383, 37.81341], [-122.21296, 37.81468], [-122.21287, 37.81488], [-122.21282, 37.81505], [-122.21279, 37.81524], [-122.21276, 37.81568], [-122.21271, 37.81589], [-122.21264, 37.81615], [-122.21255, 37.81635], [-122.21242, 37.8166], [-122.21216, 37.81697], [-122.21188, 37.81727], [-122.21156, 37.81754], [-122.21134, 37.81732], [-122.21021, 37.8181], [-122.21042, 37.81832], [-122.20899, 37.81931], [-122.20864, 37.8196], [-122.20844, 37.8198], [-122.20824, 37.82005], [-122.20783, 37.82076], [-122.20752, 37.82065], [-122.20748, 37.82071], [-122.20708, 37.82061], [-122.20721, 37.82062], [-122.20724, 37.82059], [-122.2066, 37.81988], [-122.20655, 37.81977], [-122.20656, 37.81968], [-122.20664, 37.81949], [-122.20665, 37.81934], [-122.2074, 37.81931], [-122.20747, 37.81913], [-122.20759, 37.81904], [-122.20763, 37.81894], [-122.2074, 37.81888], [-122.20735, 37.81874], [-122.20698, 37.81872], [-122.20695, 37.81862], [-122.20657, 37.81849], [-122.20619, 37.81822], [-122.20582, 37.81817], [-122.20518, 37.81767], [-122.20512, 37.81752], [-122.20472, 37.81736], [-122.20425, 37.81689], [-122.20411, 37.81684], [-122.20401, 37.81675], [-122.20367, 37.8167], [-122.2035, 37.81649], [-122.2037, 37.81627], [-122.20461, 37.81657], [-122.20479, 37.81665], [-122.20494, 37.81677], [-122.20511, 37.81692], [-122.20541, 37.81728], [-122.20586, 37.81761], [-122.20601, 37.81766], [-122.20628, 37.81764], [-122.20626, 37.81779], [-122.20644, 37.8179], [-122.20652, 37.81792], [-122.2067, 37.8179], [-122.20684, 37.81792], [-122.20729, 37.81814], [-122.21117, 37.8155], [-122.21113, 37.8148], [-122.2109, 37.81458], [-122.2105, 37.81486], [-122.21011, 37.81458], [-122.20948, 37.81371], [-122.20937, 37.8135], [-122.20949, 37.81337], [-122.20984, 37.81349], [-122.20991, 37.81338], [-122.21032, 37.81354], [-122.21028, 37.81361], [-122.21029, 37.81362], [-122.21061, 37.81374], [-122.21072, 37.81377], [-122.21091, 37.81377], [-122.21113, 37.81371], [-122.2114, 37.8137], [-122.21165, 37.81365], [-122.21181, 37.81358], [-122.21196, 37.81346], [-122.21202, 37.81339], [-122.21205, 37.81331], [-122.21206, 37.81323], [-122.21203, 37.81315], [-122.2119, 37.81299], [-122.21187, 37.81289], [-122.21226, 37.81285], [-122.21266, 37.8127], [-122.21266, 37.81226], [-122.21289, 37.81238], [-122.2131, 37.81212], [-122.21365, 37.81239], [-122.21398, 37.81251], [-122.21379, 37.81288], [-122.21397, 37.81301], [-122.21403, 37.81298], [-122.21418, 37.81309]]], [[[-122.21615, 37.8102], [-122.21597, 37.81029], [-122.21571, 37.81014], [-122.21562, 37.81013], [-122.21555, 37.81019], [-122.21534, 37.81058], [-122.21499, 37.81103], [-122.21478, 37.81126], [-122.21455, 37.81134], [-122.21436, 37.81156], [-122.21424, 37.81174], [-122.2144, 37.81205], [-122.2142, 37.81215], [-122.21411, 37.81217], [-122.21403, 37.81225], [-122.21399, 37.81236], [-122.21374, 37.81227], [-122.21319, 37.812], [-122.21359, 37.81151], [-122.21352, 37.8107], [-122.21438, 37.81005], [-122.21447, 37.81011], [-122.21466, 37.80997], [-122.21458, 37.80989], [-122.21471, 37.8098], [-122.21499, 37.80946], [-122.21512, 37.8092], [-122.21515, 37.80906], [-122.21527, 37.80907], [-122.21528, 37.80895], [-122.21517, 37.80894], [-122.2152, 37.80871], [-122.21533, 37.80871], [-122.21534, 37.80861], [-122.21522, 37.8086], [-122.21532, 37.80794], [-122.21544, 37.80794], [-122.21549, 37.80762], [-122.21546, 37.80761], [-122.21574, 37.80753], [-122.21592, 37.80763], [-122.21611, 37.80767], [-122.21615, 37.80805], [-122.21614, 37.80818], [-122.21605, 37.80838], [-122.21605, 37.80855], [-122.21595, 37.80889], [-122.21601, 37.80917], [-122.216, 37.80924], [-122.2159, 37.80948], [-122.21589, 37.80955], [-122.21593, 37.80968], [-122.21603, 37.80983], [-122.21615, 37.8102]]], [[[-122.21679, 37.804], [-122.2167, 37.80414], [-122.21665, 37.80427], [-122.21669, 37.80442], [-122.21656, 37.80466], [-122.21669, 37.80483], [-122.21644, 37.80488], [-122.21632, 37.80495], [-122.21649, 37.80502], [-122.21633, 37.80543], [-122.21638, 37.80566], [-122.21638, 37.80575], [-122.21591, 37.80605], [-122.21592, 37.80644], [-122.21605, 37.80683], [-122.2162, 37.80705], [-122.21621, 37.8072], [-122.21619, 37.80727], [-122.21605, 37.80744], [-122.21606, 37.80752], [-122.21596, 37.80749], [-122.21584, 37.80742], [-122.21578, 37.80736], [-122.21537, 37.80669], [-122.21432, 37.80652], [-122.21493, 37.80498], [-122.21446, 37.80489], [-122.2151, 37.80326], [-122.21637, 37.80358], [-122.21649, 37.80358], [-122.21672, 37.80373], [-122.2167, 37.80387], [-122.21679, 37.804]]]]} | Open Access 1 | 15702 | Dimond Canyon Park | 18154 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 78.65 | Dimond Canyon Park | 0 | Local Park 2 | 4 | |
9374 | 9374 | 9373 | {"type": "Polygon", "coordinates": [[[-122.29722, 37.80377], [-122.29719, 37.80383], [-122.29678, 37.80373], [-122.2968, 37.80366], [-122.29722, 37.80377]]]} | Open Access 1 | 15671 | Cresent Park | 17799 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.075 | Cresent Park | 0 | Local Park 2 | 4 | |
9353 | 9353 | 9352 | {"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 | 15617 | 25th St. Mini Park | 15188 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.375 | 25th St. MP | 0 | Local Park 2 | 4 | |
9347 | 9347 | 9346 | {"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 | 15616 | Union Point Park | 26659 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 6.705 | Union Point Park | 0 | Local Park 2 | 4 | |
9346 | 9346 | 9345 | {"type": "Polygon", "coordinates": [[[-122.24828, 37.81065], [-122.24821, 37.81073], [-122.24813, 37.81081], [-122.24789, 37.81123], [-122.24786, 37.81123], [-122.2478, 37.81119], [-122.2476, 37.81094], [-122.24755, 37.81081], [-122.24751, 37.81058], [-122.24749, 37.81051], [-122.24738, 37.81039], [-122.24747, 37.81042], [-122.24776, 37.81058], [-122.24792, 37.81064], [-122.24804, 37.81067], [-122.24828, 37.81065]]]} | Open Access 1 | 15615 | Splash Pad Park | 25726 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.705 | Splash Pad Park | 0 | Local Park 2 | 4 | |
9328 | 9328 | 9327 | {"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 | 15552 | Mc Crea Park | 21986 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 2.147 | Mc Crea Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);