units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where ACCESS_TYP = 1, COUNTY = 17 and LAYER = 5
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2230 | 2230 | 2229 | {"type": "Polygon", "coordinates": [[[-122.24161, 37.87448], [-122.24145, 37.87464], [-122.24127, 37.87475], [-122.24114, 37.87493], [-122.24111, 37.87512], [-122.24092, 37.87526], [-122.24065, 37.87538], [-122.24047, 37.87566], [-122.24018, 37.87587], [-122.23966, 37.8759], [-122.23923, 37.87598], [-122.23904, 37.87594], [-122.23883, 37.87578], [-122.23877, 37.87566], [-122.23862, 37.87565], [-122.23832, 37.87568], [-122.23798, 37.87544], [-122.23732, 37.87513], [-122.23676, 37.87512], [-122.2366, 37.87502], [-122.23663, 37.87463], [-122.23526, 37.87337], [-122.2356, 37.87318], [-122.23585, 37.87323], [-122.2367, 37.87277], [-122.23926, 37.87339], [-122.23954, 37.87339], [-122.2396, 37.87354], [-122.23954, 37.87373], [-122.23993, 37.87403], [-122.23976, 37.87413], [-122.23956, 37.87434], [-122.2395, 37.87432], [-122.23953, 37.8746], [-122.23982, 37.87455], [-122.23995, 37.87444], [-122.24027, 37.87459], [-122.24058, 37.87447], [-122.24075, 37.87429], [-122.24072, 37.87405], [-122.24082, 37.87385], [-122.24138, 37.87419], [-122.24161, 37.87448]]]} | Open Access 1 | 47876 | University of California Botanical Garden at Berkeley | 31820 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | https://botanicalgarden.berkeley.edu | Alameda 17 | 25.411 | University of California Botanical Garden at Berkeley | 1890 | None 183 | |
11576 | 11576 | 11575 | {"type": "Polygon", "coordinates": [[[-122.21582, 37.7497], [-122.2122, 37.75089], [-122.21219, 37.7509], [-122.21281, 37.75156], [-122.21461, 37.75149], [-122.21142, 37.75331], [-122.21104, 37.75277], [-122.21118, 37.75272], [-122.21131, 37.75252], [-122.21132, 37.75241], [-122.21105, 37.75174], [-122.21078, 37.75094], [-122.21108, 37.75075], [-122.21072, 37.75029], [-122.2115, 37.74985], [-122.21127, 37.74958], [-122.21182, 37.74903], [-122.21102, 37.74812], [-122.21109, 37.74794], [-122.2099, 37.74658], [-122.20975, 37.74657], [-122.20956, 37.74634], [-122.20952, 37.74636], [-122.20871, 37.74544], [-122.20851, 37.74554], [-122.20847, 37.7455], [-122.20866, 37.74539], [-122.20866, 37.74538], [-122.20713, 37.74363], [-122.20579, 37.74437], [-122.20566, 37.74422], [-122.20795, 37.74294], [-122.20849, 37.74357], [-122.2085, 37.74356], [-122.20844, 37.74313], [-122.21245, 37.74313], [-122.21582, 37.7497]]]} | Open Access 1 | 23671 | Oakport Field | 23035 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 92.032 | Oakport Field | 0 | Local Recreation Area 3 | 4 | |
16637 | 16637 | 16636 | {"type": "MultiPolygon", "coordinates": [[[[-121.6018, 37.77079], [-121.6016, 37.7709], [-121.6017, 37.77103], [-121.60165, 37.77111], [-121.60124, 37.77134], [-121.60016, 37.77006], [-121.59993, 37.77018], [-121.59993, 37.7702], [-121.59964, 37.77018], [-121.59927, 37.76974], [-121.59735, 37.76827], [-121.59695, 37.76759], [-121.59719, 37.7675], [-121.59663, 37.76656], [-121.59596, 37.76614], [-121.59463, 37.76585], [-121.59207, 37.76563], [-121.59112, 37.76607], [-121.58904, 37.76611], [-121.58717, 37.76575], [-121.58681, 37.76559], [-121.58681, 37.76467], [-121.58781, 37.76485], [-121.5894, 37.76458], [-121.59113, 37.76442], [-121.59191, 37.76463], [-121.59338, 37.7648], [-121.59532, 37.76491], [-121.5958, 37.76482], [-121.59643, 37.76467], [-121.59739, 37.76562], [-121.59775, 37.76603], [-121.59787, 37.76632], [-121.59829, 37.76715], [-121.59988, 37.76843], [-121.59999, 37.76877], [-121.6009, 37.76915], [-121.60179, 37.77022], [-121.60165, 37.77021], [-121.6011, 37.76955], [-121.60066, 37.7698], [-121.6014, 37.77067], [-121.6016, 37.77056], [-121.6018, 37.77079]]], [[[-121.59573, 37.77952], [-121.59572, 37.77952], [-121.59572, 37.77897], [-121.59573, 37.77952], [-121.59573, 37.77952]]], [[[-121.60204, 37.77488], [-121.60181, 37.77513], [-121.60163, 37.77504], [-121.60129, 37.77493], [-121.60111, 37.77484], [-121.60042, 37.77435], [-121.60022, 37.77416], [-121.60011, 37.77401], [-121.60001, 37.77382], [-121.59996, 37.77365], [-121.59994, 37.77348], [-121.60032, 37.77348], [-121.60035, 37.77367], [-121.60042, 37.77382], [-121.60051, 37.77396], [-121.60066, 37.77411], [-121.60139, 37.77463], [-121.60151, 37.77468], [-121.6018, 37.77477], [-121.60204, 37.77488]]], [[[-121.60231, 37.7746], [-121.60208, 37.77484], [-121.60183, 37.77472], [-121.60155, 37.77464], [-121.60143, 37.77458], [-121.60073, 37.77409], [-121.60061, 37.77398], [-121.60051, 37.77385], [-121.60045, 37.77374], [-121.60041, 37.77359], [-121.60039, 37.77348], [-121.60077, 37.77347], [-121.60079, 37.77358], [-121.60084, 37.7737], [-121.60092, 37.7738], [-121.601, 37.77387], [-121.60166, 37.77434], [-121.602, 37.77445], [-121.60231, 37.7746]]], [[[-121.61603, 37.78175], [-121.61152, 37.78256], [-121.61121, 37.78259], [-121.6109, 37.78258], [-121.61043, 37.78251], [-121.61014, 37.78242], [-121.60993, 37.78233], [-121.60973, 37.78223], [-121.6095, 37.78206], [-121.60934, 37.78193], [-121.60915, 37.78172], [-121.60871, 37.78194], [-121.60856, 37.78176], [-121.60839, 37.7816], [-121.6082, 37.78145], [-121.60799, 37.78132], [-121.60776, 37.78121], [-121.60752, 37.78111], [-121.6071, 37.781], [-121.60749, 37.7798], [-121.60776, 37.77986], [-121.60815, 37.77998], [-121.60853, 37.78013], [-121.60889, 37.78031], [-121.60922, 37.78052], [-121.60953, 37.78076], [-121.6098, 37.78101], [-121.61011, 37.78138], [-121.61026, 37.7815], [-121.61054, 37.78166], [-121.61082, 37.78174], [-121.61108, 37.78176], [-121.61133, 37.78175], [-121.61581, 37.78095], [-121.61591, 37.78132], [-121.61142, 37.78212], [-121.61113, 37.78215], [-121.61083, 37.78213], [-121.6106, 37.78209], [-121.61037, 37.78202], [-121.61016, 37.78193], [-121.60997, 37.78182], [-121.60976, 37.78165], [-121.60941, 37.78125], [-121.60917, 37.78102], [-121.6089, 37.78081], [-121.60861, 37.78063], [-121.60829, 37.78047], [-121.60796, 37.78033], [-121.60761, 37.78023], [-121.60737, 37.78018], [-121.60736, 37.78023], [-121.6077, 37.78031], [-121.60804, 37.78043], [-121.60836, 37.78057], [-121.60867, 37.78073], [-121.60895, 37.78092], [-121.6092, 37.78113], [-121.60943, 37.78136], [-121.60967, 37.78164], [-121.60988, 37.78182], [-121.61002, 37.78192], [-121.61023, 37.78203], [-121.61058, 37.78214], [-121.61082, 37.78219], [-121.611, 37.7822], [-121.61119, 37.7822], [-121.61143, 37.78218], [-121.61593, 37.78138], [-121.61603, 37.78175]]], [[[-121.62669, 37.79963], [-121.62326, 37.80046], [-121.62325, 37.79685], [-121.6249, 37.79641], [-121.62495, 37.79498], [-121.62316, 37.79494], [-121.62272, 37.79347], [-121.62236, 37.79279], [-121.62177, 37.79182], [-121.62225, 37.79148], [-121.62225, 37.79146], [-121.6206, 37.79018], [-121.61985, 37.79022], [-121.61946, 37.78912], [-121.62051, 37.78855], [-121.62077, 37.78761], [-121.6195, 37.78761], [-121.61919, 37.78767], [-121.61884, 37.7877], [-121.61412, 37.78769], [-121.61412, 37.78749], [-121.61804, 37.78748], [-121.61805, 37.78757], [-121.61875, 37.78757], [-121.61911, 37.78754], [-121.61941, 37.78748], [-121.62129, 37.78747], [-121.62183, 37.7867], [-121.62197, 37.78646], [-121.62205, 37.78629], [-121.62213, 37.78603], [-121.62219, 37.78568], [-121.62219, 37.7855], [-121.62217, 37.78523], [-121.62211, 37.78497], [-121.62202, 37.78471], [-121.62199, 37.78464], [-121.62197, 37.78464], [-121.62191, 37.78454], [-121.62184, 37.78448], [-121.62175, 37.78441], [-121.62155, 37.78432], [-121.62153, 37.78426], [-121.62154, 37.7842], [-121.62158, 37.78416], [-121.62221, 37.78382], [-121.62256, 37.78376], [-121.62357, 37.78322], [-121.62362, 37.78308], [-121.62371, 37.78295], [-121.62412, 37.78263], [-121.62437, 37.78237], [-121.62561, 37.7807], [-121.62458, 37.78241], [-121.62433, 37.78268], [-121.62416, 37.78282], [-121.62387, 37.78303], [-121.62374, 37.78317], [-121.62369, 37.78327], [-121.62366, 37.78337], [-121.62366, 37.78377], [-121.62361, 37.78394], [-121.62356, 37.78405], [-121.62347, 37.78416], [-121.62325, 37.78433], [-121.62325, 37.79019], [-121.62348, 37.79046], [-121.62458, 37.79081], [-121.62588, 37.79146], [-121.6266, 37.7931], [-121.62652, 37.79347], [-121.62659, 37.79445], [-121.6265, 37.79594], [-121.62669, 37.79963]]], [[[-121.61957, 37.78467], [-121.61837, 37.78582], [-121.61701, 37.78492], [-121.61713, 37.78486], [-121.61722, 37.78477], [-121.61727, 37.78467], [-121.61729, 37.78456], [-121.61727, 37.78447], [-121.61723, 37.78439], [-121.61703, 37.78422], [-121.61696, 37.78413], [-121.61693, 37.78402], [-121.61694, 37.78391], [-121.61699, 37.78381], [-121.61713, 37.78363], [-121.61725, 37.78352], [-121.61735, 37.78348], [-121.61746, 37.78346], [-121.61758, 37.78346], [-121.61769, 37.78348], [-121.61782, 37.78354], [-121.61784, 37.78353], [-121.61957, 37.78467]]], [[[-121.61763, 37.78338], [-121.61742, 37.78338], [-121.61722, 37.78344], [-121.61753, 37.78305], [-121.61752, 37.78315], [-121.61754, 37.78323], [-121.61763, 37.78338]]], [[[-121.61984, 37.78441], [-121.61961, 37.78463], [-121.61788, 37.78349], [-121.61788, 37.78347], [-121.61771, 37.78337], [-121.61764, 37.78329], [-121.6176, 37.78318], [-121.6176, 37.78308], [-121.61764, 37.78297], [-121.61764, 37.78296], [-121.61984, 37.78441]]], [[[-121.62721, 37.77509], [-121.62634, 37.77735], [-121.62672, 37.77768], [-121.62683, 37.77782], [-121.62693, 37.77799], [-121.627, 37.77816], [-121.62704, 37.77834], [-121.62705, 37.77853], [-121.62702, 37.77871], [-121.62695, 37.77891], [-121.62684, 37.7791], [-121.62606, 37.78009], [-121.6266, 37.77936], [-121.62471, 37.77907], [-121.62273, 37.77716], [-121.62172, 37.77782], [-121.6195, 37.77862], [-121.6195, 37.77848], [-121.62184, 37.7776], [-121.624, 37.77617], [-121.62661, 37.77494], [-121.62721, 37.77509]]], [[[-121.62089, 37.78492], [-121.62026, 37.78515], [-121.61997, 37.78466], [-121.62059, 37.78442], [-121.62089, 37.78492]]]]} | Open Access 1 | 303 | Bethany Reservoir State Recreation Area | 30568 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=562 | Alameda 17 | 228.958 | Bethany Reservoir SRA | 1974 | State Recreation Area 39 | 4 |
16675 | 16675 | 16674 | {"type": "Polygon", "coordinates": [[[-121.62661, 37.77936], [-121.62437, 37.78237], [-121.62412, 37.78263], [-121.62371, 37.78295], [-121.62362, 37.78308], [-121.62357, 37.78322], [-121.62256, 37.78376], [-121.62221, 37.78382], [-121.62158, 37.78416], [-121.62154, 37.7842], [-121.62153, 37.78426], [-121.62155, 37.78432], [-121.62175, 37.78441], [-121.62184, 37.78448], [-121.62197, 37.78463], [-121.62198, 37.78463], [-121.62202, 37.78472], [-121.62211, 37.78497], [-121.62217, 37.78523], [-121.62219, 37.7855], [-121.62219, 37.78568], [-121.62213, 37.78603], [-121.62205, 37.78629], [-121.62197, 37.78646], [-121.62183, 37.7867], [-121.62129, 37.78747], [-121.61941, 37.78748], [-121.61911, 37.78754], [-121.61875, 37.78757], [-121.61804, 37.78757], [-121.61803, 37.78748], [-121.61412, 37.78749], [-121.6141, 37.7845], [-121.60509, 37.78458], [-121.60511, 37.78259], [-121.60156, 37.78034], [-121.59571, 37.78053], [-121.59572, 37.77962], [-121.59561, 37.77963], [-121.59541, 37.77971], [-121.59524, 37.77983], [-121.59512, 37.77997], [-121.59503, 37.78013], [-121.59501, 37.78031], [-121.59504, 37.78147], [-121.59503, 37.78164], [-121.59498, 37.78184], [-121.5949, 37.78199], [-121.59481, 37.78214], [-121.59469, 37.78227], [-121.59446, 37.78244], [-121.5942, 37.78257], [-121.59249, 37.78314], [-121.59233, 37.78317], [-121.59214, 37.78318], [-121.59198, 37.78317], [-121.59182, 37.78313], [-121.59188, 37.78306], [-121.59214, 37.7831], [-121.59242, 37.78307], [-121.5942, 37.78248], [-121.5944, 37.78237], [-121.59461, 37.78221], [-121.59474, 37.78206], [-121.59486, 37.78185], [-121.59491, 37.7817], [-121.59493, 37.78155], [-121.5949, 37.78031], [-121.59494, 37.78009], [-121.59506, 37.77989], [-121.59524, 37.77972], [-121.59547, 37.77959], [-121.59573, 37.77951], [-121.59576, 37.77325], [-121.59932, 37.77328], [-121.5994, 37.77282], [-121.59971, 37.77252], [-121.60045, 37.7723], [-121.60083, 37.77124], [-121.6, 37.77021], [-121.59992, 37.77019], [-121.60016, 37.77006], [-121.60125, 37.77133], [-121.60165, 37.77111], [-121.6017, 37.77103], [-121.6016, 37.7709], [-121.60179, 37.77078], [-121.6016, 37.77056], [-121.6014, 37.77067], [-121.60065, 37.76979], [-121.6011, 37.76954], [-121.60165, 37.77021], [-121.60179, 37.77022], [-121.60186, 37.77029], [-121.6024, 37.77032], [-121.60311, 37.76923], [-121.60396, 37.76878], [-121.60445, 37.76939], [-121.6043, 37.7707], [-121.6037, 37.77174], [-121.60508, 37.77335], [-121.60699, 37.77189], [-121.60914, 37.77271], [-121.60939, 37.77393], [-121.61051, 37.77428], [-121.61106, 37.77586], [-121.61496, 37.77604], [-121.61591, 37.77654], [-121.61531, 37.77849], [-121.61778, 37.77972], [-121.61951, 37.77969], [-121.6195, 37.77862], [-121.62172, 37.77782], [-121.62273, 37.77715], [-121.62471, 37.77906], [-121.62661, 37.77936]], [[-121.60196, 37.77484], [-121.6018, 37.77477], [-121.60151, 37.77468], [-121.60139, 37.77463], [-121.60066, 37.77411], [-121.60051, 37.77396], [-121.60042, 37.77382], [-121.60035, 37.77367], [-121.60032, 37.77348], [-121.59994, 37.77349], [-121.59996, 37.77365], [-121.60001, 37.77382], [-121.60011, 37.77401], [-121.60022, 37.77416], [-121.60042, 37.77435], [-121.60111, 37.77484], [-121.60132, 37.77494], [-121.6016, 37.77503], [-121.60181, 37.77512], [-121.60203, 37.77489], [-121.60196, 37.77484]], [[-121.60204, 37.77482], [-121.60208, 37.77484], [-121.6023, 37.7746], [-121.602, 37.77445], [-121.60166, 37.77434], [-121.601, 37.77387], [-121.60092, 37.7738], [-121.60084, 37.7737], [-121.60079, 37.77359], [-121.60077, 37.77347], [-121.6004, 37.77348], [-121.60041, 37.77362], [-121.60048, 37.7738], [-121.60057, 37.77393], [-121.60071, 37.77407], [-121.60143, 37.77458], [-121.60155, 37.77464], [-121.60183, 37.77472], [-121.60204, 37.77482]], [[-121.60915, 37.78172], [-121.60929, 37.78188], [-121.6095, 37.78206], [-121.60973, 37.78223], [-121.61, 37.78236], [-121.61028, 37.78247], [-121.61051, 37.78253], [-121.61074, 37.78257], [-121.61105, 37.78259], [-121.61137, 37.78258], [-121.6116, 37.78254], [-121.61603, 37.78175], [-121.61592, 37.78138], [-121.61143, 37.78218], [-121.61106, 37.7822], [-121.6107, 37.78217], [-121.61052, 37.78213], [-121.61029, 37.78205], [-121.61013, 37.78198], [-121.60993, 37.78186], [-121.60971, 37.78168], [-121.60936, 37.78128], [-121.60912, 37.78106], [-121.60886, 37.78085], [-121.60857, 37.78067], [-121.60826, 37.78052], [-121.60793, 37.78038], [-121.60759, 37.78028], [-121.60735, 37.78023], [-121.60711, 37.781], [-121.60736, 37.78106], [-121.6076, 37.78114], [-121.60799, 37.78132], [-121.6082, 37.78145], [-121.60839, 37.7816], [-121.60856, 37.78176], [-121.60871, 37.78193], [-121.60915, 37.78172]], [[-121.60737, 37.78016], [-121.60738, 37.78017], [-121.60773, 37.78026], [-121.60807, 37.78038], [-121.60829, 37.78047], [-121.60861, 37.78063], [-121.6089, 37.78081], [-121.60917, 37.78102], [-121.60941, 37.78125], [-121.60976, 37.78165], [-121.60997, 37.78182], [-121.61016, 37.78193], [-121.61037, 37.78202], [-121.6106, 37.78209], [-121.61083, 37.78213], [-121.61113, 37.78215], [-121.61142, 37.78212], [-121.61591, 37.78132], [-121.6158, 37.78095], [-121.61133, 37.78175], [-121.61112, 37.78176], [-121.6109, 37.78175], [-121.61058, 37.78167], [-121.61029, 37.78152], [-121.61011, 37.78138], [-121.60971, 37.78093], [-121.60943, 37.78068], [-121.609, 37.78038], [-121.60853, 37.78013], [-121.60802, 37.77994], [-121.60749, 37.7798], [-121.60737, 37.78016]], [[-121.61836, 37.78581], [-121.61956, 37.78467], [-121.61784, 37.78353], [-121.61783, 37.78354], [-121.61769, 37.78348], [-121.61756, 37.78345], [-121.61742, 37.78346], [-121.6173, 37.7835], [-121.61722, 37.78355], [-121.61714, 37.78362], [-121.61698, 37.78382], [-121.61693, 37.78393], [-121.61693, 37.78403], [-121.61697, 37.78414], [-121.61704, 37.78423], [-121.61722, 37.78438], [-121.61727, 37.78446], [-121.61729, 37.78455], [-121.61728, 37.78465], [-121.61723, 37.78476], [-121.61715, 37.78484], [-121.61702, 37.78492], [-121.61836, 37.78581]], [[-121.6176, 37.78338], [-121.61761, 37.78336], [-121.61754, 37.78323], [-121.61751, 37.78308], [-121.61724, 37.78342], [-121.61725, 37.78343], [-121.61745, 37.78338], [-121.6176, 37.78338]], [[-121.61789, 37.78348], [-121.61789, 37.78349], [-121.61961, 37.78463], [-121.61983, 37.78442], [-121.61764, 37.78297], [-121.61761, 37.78303], [-121.61759, 37.78311], [-121.6176, 37.7832], [-121.61762, 37.78326], [-121.61772, 37.78337], [-121.61789, 37.78348]], [[-121.6206, 37.78443], [-121.61997, 37.78466], [-121.62026, 37.78515], [-121.62088, 37.78492], [-121.6206, 37.78443]]]} | Open Access 1 | 47068 | Bethany Reservoir State Recreation Area | 1434 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=562 | Alameda 17 | 613.14 | Bethany Reservoir SRA | 1974 | State Recreation Area 39 | 4 |
16849 | 16849 | 16848 | {"type": "Polygon", "coordinates": [[[-122.22677, 37.74529], [-122.22677, 37.74709], [-122.22609, 37.74994], [-122.22601, 37.75017], [-122.22572, 37.75132], [-122.22566, 37.75177], [-122.22545, 37.75267], [-122.22531, 37.75314], [-122.22505, 37.75449], [-122.22486, 37.75528], [-122.2248, 37.75564], [-122.2247, 37.75639], [-122.22455, 37.75706], [-122.22248, 37.75871], [-122.22223, 37.75832], [-122.22166, 37.75833], [-122.22103, 37.75878], [-122.22074, 37.7592], [-122.22071, 37.75919], [-122.22033, 37.75962], [-122.21971, 37.75996], [-122.21902, 37.7605], [-122.21838, 37.76026], [-122.21785, 37.76069], [-122.21784, 37.7607], [-122.21792, 37.76078], [-122.21759, 37.76102], [-122.21696, 37.76048], [-122.21551, 37.7613], [-122.21541, 37.76183], [-122.21436, 37.76065], [-122.21461, 37.7605], [-122.21503, 37.76094], [-122.21591, 37.76038], [-122.21612, 37.75946], [-122.21613, 37.75933], [-122.21602, 37.75906], [-122.21555, 37.75849], [-122.21631, 37.75808], [-122.21615, 37.75803], [-122.21598, 37.75794], [-122.21586, 37.75784], [-122.21578, 37.75771], [-122.21573, 37.75759], [-122.21573, 37.75745], [-122.2158, 37.7573], [-122.21593, 37.75709], [-122.2156, 37.75689], [-122.21556, 37.75671], [-122.21574, 37.75666], [-122.21575, 37.75665], [-122.21566, 37.75652], [-122.21548, 37.75637], [-122.21538, 37.75608], [-122.2152, 37.75601], [-122.21512, 37.75585], [-122.21512, 37.75571], [-122.21507, 37.75558], [-122.21482, 37.75549], [-122.21469, 37.75547], [-122.21439, 37.75561], [-122.21415, 37.75521], [-122.21399, 37.75508], [-122.21384, 37.75499], [-122.21366, 37.75497], [-122.21267, 37.75507], [-122.21142, 37.75331], [-122.21458, 37.75151], [-122.21457, 37.75149], [-122.21281, 37.75156], [-122.21218, 37.75089], [-122.21582, 37.74969], [-122.21245, 37.74314], [-122.20845, 37.74313], [-122.20851, 37.74359], [-122.20795, 37.74294], [-122.20567, 37.74422], [-122.2058, 37.74436], [-122.20712, 37.74363], [-122.20867, 37.74539], [-122.20847, 37.74549], [-122.20697, 37.74377], [-122.20563, 37.74446], [-122.20519, 37.74396], [-122.20737, 37.74276], [-122.20738, 37.74274], [-122.20115, 37.73543], [-122.19921, 37.73326], [-122.1991, 37.73315], [-122.19893, 37.73302], [-122.19882, 37.73296], [-122.19848, 37.73284], [-122.19872, 37.73229], [-122.19878, 37.73218], [-122.19951, 37.73252], [-122.19985, 37.73273], [-122.20736, 37.74128], [-122.20738, 37.74128], [-122.20863, 37.74277], [-122.20917, 37.74243], [-122.20877, 37.74227], [-122.20879, 37.7421], [-122.20873, 37.74177], [-122.20858, 37.74152], [-122.20858, 37.74137], [-122.20865, 37.74108], [-122.20861, 37.74103], [-122.20889, 37.74085], [-122.20916, 37.74064], [-122.20926, 37.74065], [-122.20945, 37.74037], [-122.20973, 37.73942], [-122.20971, 37.73868], [-122.20943, 37.738], [-122.20916, 37.7374], [-122.21013, 37.73678], [-122.20976, 37.73583], [-122.20941, 37.73503], [-122.20881, 37.73357], [-122.20865, 37.7332], [-122.20832, 37.7325], [-122.20812, 37.73219], [-122.20787, 37.73192], [-122.20757, 37.73165], [-122.20732, 37.73101], [-122.20668, 37.73075], [-122.20755, 37.72954], [-122.2101, 37.73094], [-122.21055, 37.73137], [-122.21105, 37.73215], [-122.21278, 37.73589], [-122.21298, 37.73637], [-122.21308, 37.73651], [-122.21952, 37.74448], [-122.21972, 37.74462], [-122.22007, 37.74481], [-122.22046, 37.74502], [-122.22075, 37.74515], [-122.22148, 37.74539], [-122.22197, 37.7454], [-122.22656, 37.74528], [-122.22677, 37.74529]]]} | Open Access 1 | 29417 | MLK Regional Shoreline | 3285 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/martinlking | Alameda 17 | 604.945 | MLK Reg. Shoreline | 1976 | 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]);