units_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 rowid descending
This data as json, copyable, CSV (advanced)
DES_TP 9
- Local Park 99
- Local Recreation Area 16
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 1
- City Agency 122
MNG_AGENCY 1
- Oakland, City of · 122 ✖
ACCESS_TYP 1
- Open Access · 122 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17010 | 17010 | 17009 | {"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.21832, 37.85401], [-122.2182, 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.85462], [-122.21619, 37.85474], [-122.2159, 37.85488], [-122.21563, 37.85504], [-122.21537, 37.85522], [-122.21472, 37.85574], [-122.21456, 37.85527], [-122.21446, 37.85531], [-122.21412, 37.85495], [-122.21413, 37.85407], [-122.2154, 37.85398], [-122.2153, 37.85297], [-122.21486, 37.85316], [-122.21472, 37.85311], [-122.21478, 37.85298], [-122.21527, 37.85273], [-122.21523, 37.85235], [-122.21392, 37.85227], [-122.21355, 37.8522], [-122.21365, 37.85158], [-122.21364, 37.85135], [-122.21335, 37.85137], [-122.2137, 37.84989], [-122.21409, 37.84967], [-122.21409, 37.84965], [-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.22456, 37.84748], [-122.22457, 37.84736], [-122.22594, 37.84738], [-122.22695, 37.84735]]]} | Open Access 1 | 13243 | North Oakland Sports Center | 22835 | 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 | 124.166 | North Oakland Sports Ctr. | 1949 | Local Recreation Area 3 | 4 | |
16975 | 16975 | 16974 | {"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.18752, 37.79777], [-122.18787, 37.79778]]]} | Open Access 1 | 13397 | Redwoods Heights Recreation Center | 30896 | 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/facility/OAK029394 | Alameda 17 | 3.1 | Redwoods Heights Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
16800 | 16800 | 16799 | {"type": "Polygon", "coordinates": [[[-122.14328, 37.74591], [-122.14195, 37.74665], [-122.14191, 37.74665], [-122.14189, 37.74663], [-122.14177, 37.74666], [-122.14117, 37.74669], [-122.14076, 37.74681], [-122.14056, 37.74657], [-122.1402, 37.74669], [-122.13981, 37.7464], [-122.13983, 37.74622], [-122.13977, 37.74603], [-122.13919, 37.7457], [-122.13899, 37.7455], [-122.13879, 37.74543], [-122.13889, 37.74485], [-122.13872, 37.74464], [-122.14026, 37.7439], [-122.14034, 37.74468], [-122.14109, 37.74459], [-122.14156, 37.74496], [-122.14192, 37.74504], [-122.14328, 37.74591]]]} | Open Access 1 | 13456 | Hellman Recreation Area | 19807 | 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 | 16.576 | Hellman Rec. Area | 0 | Local Recreation Area 3 | 4 | |
16799 | 16799 | 16798 | {"type": "Polygon", "coordinates": [[[-122.16491, 37.77529], [-122.16447, 37.77552], [-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.77501], [-122.16286, 37.77496], [-122.16291, 37.77487], [-122.16355, 37.77509], [-122.16371, 37.77485], [-122.16385, 37.77477], [-122.16391, 37.77482], [-122.16437, 37.77463], [-122.16491, 37.77529]]]} | Open Access 1 | 13403 | Burckhalter Recreation Area | 16515 | 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.577 | Burckhalter Rec. Area | 0 | Local Recreation Area 3 | 4 | |
15790 | 15790 | 15789 | {"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 | 13369 | Rainbow Recreation Center | 30895 | 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/facility/OAK029393 | Alameda 17 | 1.112 | Rainbow Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
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 | |
12101 | 12101 | 12100 | {"type": "MultiPolygon", "coordinates": [[[[-122.16513, 37.74516], [-122.16423, 37.74558], [-122.16392, 37.74518], [-122.16494, 37.74491], [-122.16513, 37.74516]]], [[[-122.16709, 37.74587], [-122.1662, 37.74629], [-122.16514, 37.74486], [-122.16614, 37.74459], [-122.16709, 37.74587]]]]} | Open Access 1 | 24936 | Lyons Field Park | 21613 | 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 | 4.902 | Lyons Field Park | 0 | Local Recreation Area 3 | 4 | |
11578 | 11578 | 11577 | {"type": "Polygon", "coordinates": [[[-122.23738, 37.80443], [-122.23717, 37.80502], [-122.23656, 37.80494], [-122.23636, 37.80518], [-122.23581, 37.80496], [-122.23493, 37.80445], [-122.23412, 37.80402], [-122.23408, 37.80398], [-122.23407, 37.80393], [-122.23411, 37.80388], [-122.23466, 37.80346], [-122.2367, 37.80324], [-122.23676, 37.80354], [-122.23703, 37.80351], [-122.23711, 37.80391], [-122.23696, 37.80399], [-122.2369, 37.8041], [-122.23738, 37.80443]]]} | Open Access 1 | 23673 | Live Oak Memorial Pool | 21365 | 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.465 | Live Oak Memorial Pool | 0 | Local Recreation Area 3 | 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 | |
10036 | 10036 | 10035 | {"type": "MultiPolygon", "coordinates": [[[[-122.18013, 37.79253], [-122.17981, 37.79282], [-122.17941, 37.79279], [-122.17596, 37.79357], [-122.17505, 37.79408], [-122.17472, 37.7943], [-122.17463, 37.79429], [-122.17444, 37.79448], [-122.17406, 37.79414], [-122.17365, 37.79442], [-122.17228, 37.79476], [-122.17134, 37.79479], [-122.17133, 37.79481], [-122.17097, 37.79478], [-122.1707, 37.79471], [-122.17047, 37.79458], [-122.16974, 37.79398], [-122.16928, 37.79357], [-122.16892, 37.79327], [-122.16822, 37.79263], [-122.16806, 37.79245], [-122.16796, 37.79227], [-122.16789, 37.79209], [-122.16785, 37.79193], [-122.16784, 37.79176], [-122.16788, 37.7915], [-122.1681, 37.79098], [-122.17057, 37.79323], [-122.17175, 37.79353], [-122.17287, 37.79283], [-122.17292, 37.79166], [-122.17197, 37.79052], [-122.1688, 37.789], [-122.16813, 37.78913], [-122.16792, 37.78846], [-122.1679, 37.7883], [-122.16789, 37.78771], [-122.16786, 37.78757], [-122.16779, 37.78745], [-122.16763, 37.78728], [-122.16745, 37.78717], [-122.16661, 37.78691], [-122.16664, 37.78689], [-122.16745, 37.78714], [-122.16765, 37.78725], [-122.16781, 37.78742], [-122.16789, 37.78757], [-122.16793, 37.7877], [-122.16793, 37.78828], [-122.16795, 37.78845], [-122.16815, 37.78906], [-122.16956, 37.78877], [-122.17252, 37.7902], [-122.17358, 37.7915], [-122.17354, 37.79269], [-122.17582, 37.79224], [-122.17829, 37.79228], [-122.17945, 37.7917], [-122.17983, 37.79067], [-122.17986, 37.79081], [-122.17985, 37.79099], [-122.1798, 37.79112], [-122.17962, 37.79149], [-122.17959, 37.79159], [-122.17959, 37.79173], [-122.17963, 37.79187], [-122.17977, 37.7921], [-122.17989, 37.79227], [-122.18013, 37.79253]]], [[[-122.18087, 37.79024], [-122.18056, 37.79112], [-122.18056, 37.79116], [-122.18038, 37.79125], [-122.18018, 37.79137], [-122.18001, 37.79153], [-122.17988, 37.79169], [-122.17983, 37.7917], [-122.17981, 37.79169], [-122.17979, 37.79165], [-122.17981, 37.79154], [-122.18001, 37.79114], [-122.18007, 37.79092], [-122.18007, 37.79081], [-122.18005, 37.79069], [-122.18, 37.79058], [-122.17993, 37.79047], [-122.18087, 37.79024]]], [[[-122.18103, 37.79328], [-122.181, 37.79329], [-122.18025, 37.79236], [-122.18009, 37.79219], [-122.17992, 37.79194], [-122.17993, 37.79188], [-122.18013, 37.79163], [-122.18023, 37.79153], [-122.18043, 37.79138], [-122.18065, 37.79128], [-122.18067, 37.79142], [-122.18056, 37.79157], [-122.18058, 37.79199], [-122.18072, 37.79227], [-122.18082, 37.79273], [-122.18103, 37.79328]]], [[[-122.18276, 37.79282], [-122.18229, 37.79322], [-122.182, 37.79305], [-122.18164, 37.79261], [-122.18123, 37.79228], [-122.18113, 37.79187], [-122.18118, 37.79149], [-122.18115, 37.79094], [-122.18123, 37.79041], [-122.18155, 37.79042], [-122.18156, 37.791], [-122.18163, 37.79162], [-122.18276, 37.79282]]]]} | Open Access 1 | 17341 | Leona Heights | 21171 | 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 | 56.739 | Leona Heights | None 864 |
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]);