units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
122 rows where MNG_AGENCY = 56 sorted by DES_TP descending
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
9997 | 9997 | 9996 | {"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.123, 37.75943], [-122.12292, 37.75926], [-122.12284, 37.75912], [-122.12141, 37.75745], [-122.12744, 37.75461], [-122.12804, 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.14923, 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.13934, 37.75542], [-122.1392, 37.75543], [-122.13914, 37.75547], [-122.13911, 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.13817, 37.75516], [-122.13808, 37.7552], [-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.75637], [-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.74883], [-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.74918], [-122.15047, 37.74959], [-122.15085, 37.75023], [-122.1511, 37.75044], [-122.15115, 37.75063]]], [[[-122.139, 37.75637], [-122.13867, 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.75615], [-122.1386, 37.75611], [-122.139, 37.75637]]], [[[-122.13982, 37.75705], [-122.13965, 37.75716], [-122.13948, 37.75738], [-122.13933, 37.75751], [-122.13916, 37.75758], [-122.13876, 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.1385, 37.75736], [-122.1385, 37.75707], [-122.13857, 37.75689], [-122.13868, 37.75675], [-122.1391, 37.75642], [-122.13957, 37.75675], [-122.13982, 37.75705]]]]} | Open Access 1 | 17197 | Knowland Park/Oakland Zoo | 7828 | 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://www.saveknowland.org/about/ | Alameda 17 | 457.743 | Knowland Park/Oakland Zoo | None 863 | ||
9994 | 9994 | 9993 | {"type": "MultiPolygon", "coordinates": [[[[-122.15632, 37.76164], [-122.15604, 37.76171], [-122.15582, 37.76174], [-122.15555, 37.76175], [-122.1553, 37.76172], [-122.15499, 37.76164], [-122.15312, 37.7609], [-122.15291, 37.76085], [-122.15267, 37.76083], [-122.15245, 37.76083], [-122.15219, 37.76087], [-122.15215, 37.76087], [-122.15201, 37.7607], [-122.15191, 37.76063], [-122.151, 37.76013], [-122.15124, 37.75994], [-122.15083, 37.75943], [-122.15125, 37.75924], [-122.15165, 37.75889], [-122.15154, 37.75872], [-122.15187, 37.75857], [-122.15263, 37.75841], [-122.15291, 37.75828], [-122.15302, 37.7582], [-122.15309, 37.7581], [-122.15312, 37.75799], [-122.1531, 37.75788], [-122.15303, 37.75777], [-122.1529, 37.75765], [-122.15276, 37.75758], [-122.15258, 37.75753], [-122.15245, 37.75751], [-122.15295, 37.75729], [-122.15632, 37.76164]]], [[[-122.15929, 37.76543], [-122.15602, 37.767], [-122.15434, 37.76458], [-122.15292, 37.76529], [-122.15179, 37.76304], [-122.15353, 37.76241], [-122.15335, 37.76208], [-122.15317, 37.7617], [-122.15312, 37.76151], [-122.15309, 37.76124], [-122.15304, 37.76118], [-122.15298, 37.76115], [-122.15308, 37.76118], [-122.15481, 37.76187], [-122.15516, 37.76197], [-122.15549, 37.76202], [-122.15586, 37.76202], [-122.15619, 37.76197], [-122.1565, 37.76187], [-122.15922, 37.76537], [-122.15924, 37.76537], [-122.15929, 37.76543]]]]} | Open Access 1 | 17194 | Kings Estate | 20660 | 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 | 77.474 | Kings Estate | None 861 | |||
8513 | 8513 | 8512 | {"type": "Polygon", "coordinates": [[[-122.2066, 37.78294], [-122.20591, 37.78344], [-122.20537, 37.78298], [-122.20506, 37.78319], [-122.20435, 37.78257], [-122.20519, 37.78169], [-122.2066, 37.78294]]]} | Open Access 1 | 13363 | BROOKDALE PARK | 16420 | 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.55 | BROOKDALE PARK | None 713 | |||
8500 | 8500 | 8499 | {"type": "MultiPolygon", "coordinates": [[[[-122.26828, 37.82304], [-122.26803, 37.82378], [-122.2678, 37.82373], [-122.26765, 37.82361], [-122.26722, 37.82337], [-122.26718, 37.82326], [-122.26743, 37.82313], [-122.26754, 37.82287], [-122.26828, 37.82304]]], [[[-122.26978, 37.82379], [-122.26952, 37.8249], [-122.26929, 37.82574], [-122.26889, 37.82573], [-122.26877, 37.82583], [-122.26874, 37.82598], [-122.26863, 37.82624], [-122.26834, 37.82621], [-122.26843, 37.82585], [-122.26847, 37.82562], [-122.26845, 37.82533], [-122.26847, 37.8252], [-122.26902, 37.82323], [-122.2697, 37.82339], [-122.26961, 37.82374], [-122.26978, 37.82379]]]]} | Open Access 1 | 13311 | Grove Shafter | 19535 | 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 | 7.028 | Grove Shafter | None 711 | |||
8489 | 8489 | 8488 | {"type": "Polygon", "coordinates": [[[-122.2501, 37.80035], [-122.24956, 37.80053], [-122.24965, 37.8007], [-122.24926, 37.80087], [-122.24894, 37.80105], [-122.24884, 37.80108], [-122.24865, 37.80111], [-122.2485, 37.80048], [-122.24885, 37.80041], [-122.24923, 37.80031], [-122.25006, 37.80024], [-122.2501, 37.80035]]]} | Open Access 1 | 13299 | F. M. SMITH PARK | 18780 | 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.691 | F. M. SMITH PARK | None 710 | |||
1226 | 1226 | 1225 | {"type": "Polygon", "coordinates": [[[-122.2621, 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.26049, 37.80382], [-122.26049, 37.80451], [-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.2621, 37.81037]]]} | Open Access 1 | 8847 | Lake Merritt | 20953 | 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 | 141.432 | Lake Merritt | 1957 | None 107 | ||
1556 | 1556 | 1555 | {"type": "Polygon", "coordinates": [[[-122.28429, 37.8453], [-122.28401, 37.84534], [-122.28346, 37.84522], [-122.28281, 37.8452], [-122.28279, 37.84516], [-122.28227, 37.84523], [-122.28208, 37.84463], [-122.284, 37.8444], [-122.28429, 37.8453]]]} | Open Access 1 | 13055 | Golden Gate Recreation Center | 19360 | 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.496 | Golden Gate Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
1786 | 1786 | 1785 | {"type": "MultiPolygon", "coordinates": [[[[-122.1954, 37.82229], [-122.19539, 37.82275], [-122.19527, 37.82277], [-122.19515, 37.82276], [-122.19508, 37.82279], [-122.19504, 37.82282], [-122.19503, 37.82287], [-122.19507, 37.82295], [-122.19491, 37.82308], [-122.19499, 37.82334], [-122.19473, 37.82344], [-122.19435, 37.82312], [-122.19461, 37.82274], [-122.19468, 37.82212], [-122.1954, 37.82229]]], [[[-122.19681, 37.82266], [-122.19664, 37.82301], [-122.19627, 37.82287], [-122.19606, 37.82281], [-122.19577, 37.82276], [-122.19543, 37.82274], [-122.19543, 37.82229], [-122.19653, 37.82252], [-122.19681, 37.82266]]]]} | Open Access 1 | 13396 | Beaconsfield Canyon | 15914 | 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.073 | Beaconsfield Canyon | 0 | Local Recreation Area 3 | 4 | |
3074 | 3074 | 3073 | {"type": "Polygon", "coordinates": [[[-122.21426, 37.79561], [-122.21378, 37.79679], [-122.21206, 37.79603], [-122.21209, 37.79595], [-122.21209, 37.79585], [-122.21199, 37.79538], [-122.21201, 37.79535], [-122.21252, 37.79484], [-122.21426, 37.79561]]]} | Open Access 1 | 24940 | Curt Flood Field | 17862 | 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.219 | Curt Flood Field | 0 | Local Recreation Area 3 | 4 | |
3293 | 3293 | 3292 | {"type": "MultiPolygon", "coordinates": [[[[-122.20851, 37.74554], [-122.20724, 37.74625], [-122.2072, 37.7462], [-122.20847, 37.7455], [-122.20851, 37.74554]]], [[[-122.21207, 37.75744], [-122.21203, 37.75781], [-122.20778, 37.75305], [-122.2081, 37.75293], [-122.20955, 37.75294], [-122.2107, 37.75286], [-122.21104, 37.75277], [-122.21142, 37.75331], [-122.2107, 37.75372], [-122.2105, 37.75392], [-122.21047, 37.75401], [-122.21048, 37.7541], [-122.21149, 37.75663], [-122.2116, 37.75682], [-122.21193, 37.75727], [-122.21207, 37.75744]]], [[[-122.20975, 37.74657], [-122.2097, 37.74657], [-122.20952, 37.74636], [-122.20955, 37.74634], [-122.20975, 37.74657]]], [[[-122.21108, 37.75075], [-122.21078, 37.75094], [-122.21058, 37.75037], [-122.21072, 37.75029], [-122.21108, 37.75075]]]]} | Open Access 1 | 29553 | Oakport Field | 23034 | 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.514 | Oakport Field | 0 | Local Recreation Area 3 | 4 | |
3569 | 3569 | 3568 | {"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 | 13339 | Manzanita Recreation Center | 30894 | 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/OAK029390 | Alameda 17 | 0.877 | Manzanita Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
6708 | 6708 | 6707 | {"type": "Polygon", "coordinates": [[[-122.26514, 37.84588], [-122.26212, 37.84635], [-122.2619, 37.84545], [-122.26325, 37.84525], [-122.26317, 37.84488], [-122.26367, 37.84481], [-122.26377, 37.84516], [-122.26393, 37.84514], [-122.26385, 37.84478], [-122.26406, 37.84475], [-122.26411, 37.84511], [-122.26424, 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 | 5003 | Bushrod Recreation Center | 16540 | 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 | 7.761 | Bushrod Rec. Ctr. | 1910 | Local Recreation Area 3 | 4 | |
8392 | 8392 | 8391 | {"type": "Polygon", "coordinates": [[[-122.21593, 37.75709], [-122.21587, 37.75719], [-122.21495, 37.7577], [-122.21461, 37.75735], [-122.21469, 37.75729], [-122.21469, 37.75727], [-122.21417, 37.75663], [-122.21362, 37.75602], [-122.21439, 37.75561], [-122.21469, 37.75547], [-122.21492, 37.75552], [-122.21507, 37.75559], [-122.21511, 37.75569], [-122.21512, 37.75585], [-122.2152, 37.756], [-122.21541, 37.7561], [-122.21548, 37.75637], [-122.2157, 37.75655], [-122.21576, 37.75666], [-122.21556, 37.75671], [-122.2156, 37.75689], [-122.21593, 37.75709]]]} | Open Access 1 | 48489 | Soccer Field | 33200 | 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.246 | Soccer Field | 0 | Local Recreation Area 3 | 4 | |
8515 | 8515 | 8514 | {"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 | 13371 | Greenman Field | 19482 | 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.434 | Greenman Field | 0 | Local Recreation Area 3 | 4 | |
9319 | 9319 | 9318 | {"type": "MultiPolygon", "coordinates": [[[[-122.28913, 37.82196], [-122.28906, 37.82294], [-122.28882, 37.82299], [-122.2889, 37.82189], [-122.28913, 37.82196]]], [[[-122.28921, 37.82079], [-122.28921, 37.82079], [-122.28915, 37.82174], [-122.28891, 37.82168], [-122.28898, 37.82067], [-122.28921, 37.82079]]], [[[-122.28951, 37.81702], [-122.28944, 37.81762], [-122.28935, 37.81811], [-122.28937, 37.8183], [-122.28931, 37.81936], [-122.28923, 37.82062], [-122.28899, 37.82052], [-122.28913, 37.81859], [-122.28913, 37.81829], [-122.2891, 37.81778], [-122.28911, 37.81751], [-122.28914, 37.81724], [-122.28921, 37.81692], [-122.28951, 37.81702]]], [[[-122.29162, 37.81096], [-122.29125, 37.81197], [-122.29074, 37.81317], [-122.29043, 37.814], [-122.28959, 37.81672], [-122.28929, 37.81662], [-122.28942, 37.8162], [-122.29032, 37.81368], [-122.29051, 37.81305], [-122.29074, 37.81178], [-122.29084, 37.81149], [-122.29106, 37.81095], [-122.29126, 37.81089], [-122.29162, 37.81096]]], [[[-122.293, 37.80588], [-122.29304, 37.80616], [-122.29304, 37.80645], [-122.29302, 37.80674], [-122.29298, 37.80697], [-122.29247, 37.80844], [-122.29191, 37.80995], [-122.29198, 37.80998], [-122.29189, 37.81038], [-122.29176, 37.81079], [-122.29141, 37.8107], [-122.29191, 37.80929], [-122.29243, 37.80791], [-122.29257, 37.80746], [-122.29263, 37.80713], [-122.29264, 37.807], [-122.29257, 37.80698], [-122.29257, 37.80687], [-122.29262, 37.80674], [-122.29262, 37.80671], [-122.29256, 37.8067], [-122.29257, 37.80624], [-122.2925, 37.8061], [-122.29242, 37.80605], [-122.2922, 37.80594], [-122.29197, 37.80587], [-122.29204, 37.80566], [-122.293, 37.80588]]]]} | Open Access 1 | 15535 | Mandela Parkway | 21738 | 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 | 12.47 | Mandela Parkway | 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 | |
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 | |
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 |
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 |
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]);