units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
28 rows where DES_TP = 3 and MNG_AGENCY = 87 sorted by AGNCY_LEV
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- East Bay Regional Park District · 8 ✖
DES_TP 1
- Local Recreation Area · 8 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16857 | 16857 | 16856 | {"type": "Polygon", "coordinates": [[[-122.16525, 37.78676], [-122.16506, 37.78688], [-122.16491, 37.78714], [-122.16476, 37.78733], [-122.16457, 37.78752], [-122.16421, 37.78766], [-122.16373, 37.78763], [-122.16354, 37.78767], [-122.1629, 37.78754], [-122.16274, 37.78736], [-122.16258, 37.78761], [-122.16245, 37.78776], [-122.16234, 37.78786], [-122.16203, 37.78835], [-122.16177, 37.78857], [-122.16157, 37.78861], [-122.16137, 37.78923], [-122.16043, 37.78943], [-122.16001, 37.78928], [-122.15824, 37.78893], [-122.15759, 37.78815], [-122.15745, 37.78804], [-122.15629, 37.78755], [-122.15559, 37.78706], [-122.15504, 37.78605], [-122.15448, 37.78564], [-122.15416, 37.78575], [-122.15443, 37.78605], [-122.15217, 37.78722], [-122.15125, 37.78633], [-122.15082, 37.7865], [-122.1481, 37.78385], [-122.14729, 37.78418], [-122.14632, 37.78324], [-122.14717, 37.78258], [-122.14639, 37.78191], [-122.14535, 37.7826], [-122.1441, 37.78144], [-122.14443, 37.78126], [-122.14444, 37.78011], [-122.14421, 37.77962], [-122.14389, 37.77932], [-122.14361, 37.7788], [-122.14269, 37.77805], [-122.14293, 37.77764], [-122.14312, 37.77694], [-122.14214, 37.77641], [-122.14156, 37.77587], [-122.14158, 37.77572], [-122.14071, 37.77463], [-122.14364, 37.77317], [-122.14385, 37.77327], [-122.1436, 37.77386], [-122.14447, 37.77466], [-122.14494, 37.7756], [-122.14548, 37.77601], [-122.14569, 37.77594], [-122.14746, 37.77701], [-122.14792, 37.77762], [-122.14793, 37.77761], [-122.14774, 37.77684], [-122.14723, 37.7765], [-122.14726, 37.77641], [-122.14726, 37.77617], [-122.14639, 37.77551], [-122.14603, 37.77537], [-122.14643, 37.77506], [-122.14682, 37.77504], [-122.14742, 37.77574], [-122.15095, 37.77612], [-122.15046, 37.77682], [-122.15219, 37.77819], [-122.15346, 37.77871], [-122.15343, 37.77878], [-122.15164, 37.78013], [-122.15253, 37.78086], [-122.15355, 37.78118], [-122.15398, 37.78099], [-122.15464, 37.78148], [-122.1556, 37.78194], [-122.1555, 37.78278], [-122.15631, 37.78297], [-122.15682, 37.78317], [-122.15727, 37.78351], [-122.1581, 37.78461], [-122.15869, 37.784], [-122.1589, 37.78419], [-122.15953, 37.78446], [-122.16022, 37.78487], [-122.16076, 37.78526], [-122.16109, 37.78562], [-122.16157, 37.78596], [-122.16184, 37.7862], [-122.16259, 37.78645], [-122.16331, 37.78679], [-122.16337, 37.78696], [-122.1634, 37.78749], [-122.16382, 37.78749], [-122.16415, 37.78742], [-122.16454, 37.78728], [-122.16467, 37.78702], [-122.16473, 37.78683], [-122.16519, 37.78661], [-122.16525, 37.78676]]]} | Open Access 1 | 17344 | Leona Heights Regional Open Space | 3282 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/leona | Alameda 17 | 297.093 | Leona Heights Reg. OS | 1986 | Local Recreation Area 3 | 4 |
16858 | 16858 | 16857 | {"type": "MultiPolygon", "coordinates": [[[[-121.98493, 37.5708], [-121.98481, 37.57087], [-121.98262, 37.57146], [-121.98203, 37.57131], [-121.98023, 37.57119], [-121.97789, 37.57078], [-121.9779, 37.5707], [-121.97775, 37.57068], [-121.97773, 37.57078], [-121.977, 37.57083], [-121.97696, 37.57073], [-121.98405, 37.56827], [-121.98493, 37.5708]]], [[[-121.99743, 37.56696], [-121.99723, 37.57285], [-121.99477, 37.57234], [-121.99378, 37.57157], [-121.99365, 37.57126], [-121.99304, 37.57095], [-121.99247, 37.57058], [-121.99015, 37.56877], [-121.99037, 37.56856], [-121.99004, 37.56832], [-121.99026, 37.56812], [-121.99056, 37.56788], [-121.99081, 37.56771], [-121.99114, 37.56752], [-121.9911, 37.56747], [-121.99154, 37.56722], [-121.99207, 37.56699], [-121.99205, 37.56693], [-121.99208, 37.56692], [-121.99227, 37.56709], [-121.99486, 37.56652], [-121.99505, 37.56755], [-121.99743, 37.56696]]], [[[-121.99115, 37.57124], [-121.991, 37.57166], [-121.99084, 37.57163], [-121.99073, 37.57183], [-121.99048, 37.5721], [-121.99009, 37.57282], [-121.98985, 37.57304], [-121.98934, 37.57292], [-121.98923, 37.57292], [-121.98838, 37.57274], [-121.98724, 37.5731], [-121.98639, 37.57303], [-121.98538, 37.57299], [-121.9853, 37.57301], [-121.98483, 37.5721], [-121.98514, 37.57196], [-121.98552, 37.57177], [-121.98587, 37.57157], [-121.98621, 37.57134], [-121.98653, 37.5711], [-121.98856, 37.56942], [-121.99115, 37.57124]]], [[[-122.01114, 37.57138], [-122.00593, 37.5763], [-122.00588, 37.57674], [-122.00424, 37.57807], [-122.003, 37.57733], [-122.00399, 37.57753], [-122.00402, 37.57742], [-122.00241, 37.57709], [-122.00243, 37.57698], [-122.00088, 37.57663], [-122.00167, 37.57417], [-122.00486, 37.57485], [-122.00562, 37.57243], [-122.00581, 37.57271], [-122.00605, 37.57247], [-122.00876, 37.57006], [-122.01114, 37.57138]]]]} | Open Access 1 | 46968 | Quarry Lakes Regional Recreation Area | 30594 | 2000 | Alameda County Flood Control and Water Conservation District 771 | Special District 4 | Flood District 8 | http://acfloodcontrol.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 204.467 | Quarry Lakes Reg. Rec. Area | 2001 | Local Recreation Area 3 | 4 | |
16860 | 16860 | 16859 | {"type": "MultiPolygon", "coordinates": [[[[-121.60916, 37.93276], [-121.60904, 37.93276], [-121.60902, 37.93271], [-121.6081, 37.93272], [-121.60864, 37.93598], [-121.60795, 37.93658], [-121.60834, 37.93867], [-121.60825, 37.93905], [-121.59819, 37.93913], [-121.5981, 37.93466], [-121.59229, 37.93078], [-121.59228, 37.92974], [-121.60063, 37.92967], [-121.60064, 37.92938], [-121.60198, 37.92936], [-121.60206, 37.92927], [-121.60211, 37.91785], [-121.60386, 37.91775], [-121.60391, 37.91959], [-121.6042, 37.92372], [-121.60742, 37.92337], [-121.6077, 37.92498], [-121.60431, 37.92535], [-121.60458, 37.92936], [-121.60442, 37.92964], [-121.60866, 37.92961], [-121.60872, 37.92983], [-121.60916, 37.93276]]], [[[-121.6409, 37.95462], [-121.64089, 37.96179], [-121.63483, 37.96181], [-121.63484, 37.9688], [-121.63566, 37.96881], [-121.6353, 37.96884], [-121.62825, 37.96876], [-121.62721, 37.96876], [-121.62716, 37.9654], [-121.62013, 37.96544], [-121.61998, 37.95458], [-121.62267, 37.95456], [-121.64086, 37.95454], [-121.64086, 37.95461], [-121.6409, 37.95462]]], [[[-121.63638, 37.96886], [-121.63635, 37.97242], [-121.62718, 37.97244], [-121.62709, 37.96887], [-121.62825, 37.96887], [-121.6353, 37.96895], [-121.63638, 37.96886]]]]} | No Public Access 3 | 46995 | Delta Access Regional Recreation Area | 30632 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 986.689 | Delta Access Reg. Rec. Area | 0 | Local Recreation Area 3 | 4 | |
16861 | 16861 | 16860 | {"type": "Polygon", "coordinates": [[[-122.23423, 37.84806], [-122.23387, 37.84811], [-122.23133, 37.84855], [-122.23093, 37.84854], [-122.23092, 37.84849], [-122.23072, 37.84844], [-122.23046, 37.84833], [-122.22978, 37.84732], [-122.22937, 37.84681], [-122.2272, 37.84436], [-122.22702, 37.84396], [-122.22653, 37.84358], [-122.22626, 37.84324], [-122.22763, 37.84318], [-122.22763, 37.84316], [-122.22741, 37.843], [-122.22768, 37.84299], [-122.2279, 37.84337], [-122.22902, 37.8442], [-122.22949, 37.84395], [-122.23023, 37.84486], [-122.23105, 37.84504], [-122.23144, 37.84543], [-122.23117, 37.8456], [-122.23142, 37.84586], [-122.23376, 37.84711], [-122.2341, 37.84738], [-122.23415, 37.84776], [-122.23423, 37.84806]]]} | Open Access 1 | 1433 | Temescal Regional Recreation Area | 26233 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 38.546 | Temescal Reg. Rec. Area | 1936 | Local Recreation Area 3 | 4 | |
16864 | 16864 | 16863 | {"type": "MultiPolygon", "coordinates": [[[[-122.0584, 37.72949], [-122.05756, 37.72994], [-122.05711, 37.7304], [-122.05695, 37.73082], [-122.05697, 37.73149], [-122.05711, 37.73173], [-122.05651, 37.73213], [-122.05596, 37.73273], [-122.05588, 37.73327], [-122.05611, 37.73362], [-122.05153, 37.73277], [-122.05151, 37.73254], [-122.05146, 37.73241], [-122.05134, 37.73217], [-122.05116, 37.7319], [-122.05095, 37.73149], [-122.05095, 37.73138], [-122.05102, 37.7312], [-122.05116, 37.73105], [-122.05124, 37.73094], [-122.05128, 37.73076], [-122.05127, 37.73027], [-122.05131, 37.73012], [-122.05149, 37.72987], [-122.05164, 37.72972], [-122.05182, 37.72958], [-122.05206, 37.72933], [-122.05215, 37.72921], [-122.0523, 37.72893], [-122.05227, 37.72871], [-122.05216, 37.72828], [-122.05215, 37.72812], [-122.05216, 37.728], [-122.05221, 37.72786], [-122.05227, 37.72782], [-122.05224, 37.72773], [-122.05227, 37.72757], [-122.0524, 37.72727], [-122.05243, 37.72712], [-122.05243, 37.72684], [-122.0524, 37.72669], [-122.05217, 37.7262], [-122.05208, 37.72588], [-122.05206, 37.72575], [-122.05208, 37.72561], [-122.05206, 37.72545], [-122.05209, 37.72517], [-122.05208, 37.72489], [-122.05203, 37.72443], [-122.05198, 37.72426], [-122.05193, 37.72387], [-122.05192, 37.72366], [-122.05198, 37.72344], [-122.05206, 37.72332], [-122.05218, 37.72325], [-122.05227, 37.72307], [-122.0524, 37.72291], [-122.05276, 37.72232], [-122.05309, 37.72159], [-122.05344, 37.72061], [-122.05363, 37.7199], [-122.05385, 37.71914], [-122.05391, 37.71901], [-122.05395, 37.71878], [-122.05393, 37.71867], [-122.05395, 37.71855], [-122.05396, 37.71836], [-122.05412, 37.71801], [-122.05428, 37.71772], [-122.05428, 37.71748], [-122.05426, 37.71736], [-122.05404, 37.71695], [-122.05396, 37.71684], [-122.05388, 37.71659], [-122.05385, 37.71647], [-122.05385, 37.71618], [-122.0559, 37.71652], [-122.05547, 37.71699], [-122.05608, 37.71786], [-122.05547, 37.71815], [-122.05684, 37.72014], [-122.05642, 37.72051], [-122.05628, 37.722], [-122.05645, 37.72212], [-122.05645, 37.72222], [-122.05726, 37.72286], [-122.0576, 37.72411], [-122.05735, 37.7244], [-122.05726, 37.72432], [-122.0571, 37.7242], [-122.05681, 37.72404], [-122.05663, 37.72398], [-122.05648, 37.72397], [-122.05634, 37.72394], [-122.05602, 37.72396], [-122.05596, 37.72399], [-122.05581, 37.72398], [-122.05544, 37.72452], [-122.0554, 37.72496], [-122.05572, 37.72534], [-122.05606, 37.72545], [-122.0574, 37.72649], [-122.05731, 37.72704], [-122.05716, 37.72713], [-122.05728, 37.72726], [-122.05726, 37.72737], [-122.057, 37.72753], [-122.05702, 37.72767], [-122.05825, 37.72891], [-122.05833, 37.72907], [-122.0584, 37.72949]]], [[[-122.06542, 37.72054], [-122.0654, 37.72096], [-122.06534, 37.72128], [-122.06506, 37.7223], [-122.06455, 37.72316], [-122.06456, 37.72317], [-122.06447, 37.72443], [-122.06427, 37.72563], [-122.06277, 37.73329], [-122.06164, 37.73527], [-122.0615, 37.73677], [-122.06103, 37.73876], [-122.05812, 37.7351], [-122.05844, 37.73494], [-122.05835, 37.7345], [-122.05929, 37.73498], [-122.06011, 37.73458], [-122.06077, 37.73415], [-122.06095, 37.7338], [-122.06111, 37.73371], [-122.06191, 37.73334], [-122.06174, 37.73312], [-122.06178, 37.73309], [-122.06135, 37.73234], [-122.06151, 37.73229], [-122.06155, 37.7318], [-122.0608, 37.73048], [-122.06077, 37.73048], [-122.06075, 37.73045], [-122.06043, 37.7305], [-122.0599, 37.73053], [-122.05982, 37.73028], [-122.0598, 37.7301], [-122.06009, 37.72989], [-122.06059, 37.72963], [-122.06069, 37.72943], [-122.06054, 37.72924], [-122.06042, 37.72903], [-122.06065, 37.72872], [-122.0608, 37.72861], [-122.06144, 37.72907], [-122.06173, 37.72895], [-122.06234, 37.72862], [-122.06262, 37.72843], [-122.06281, 37.72824], [-122.06289, 37.72811], [-122.06293, 37.72799], [-122.06291, 37.72798], [-122.06282, 37.72807], [-122.06241, 37.7268], [-122.06174, 37.72609], [-122.06212, 37.72514], [-122.06172, 37.72455], [-122.06176, 37.72453], [-122.06176, 37.72451], [-122.0612, 37.72441], [-122.06174, 37.72444], [-122.06265, 37.724], [-122.06262, 37.72394], [-122.06222, 37.72347], [-122.06226, 37.72343], [-122.06218, 37.72332], [-122.06246, 37.72329], [-122.06268, 37.72312], [-122.06267, 37.72327], [-122.06431, 37.72316], [-122.06484, 37.7208], [-122.06484, 37.72078], [-122.06479, 37.72078], [-122.06487, 37.72049], [-122.06491, 37.72049], [-122.06492, 37.72052], [-122.06542, 37.72054]]]]} | Open Access 1 | 15150 | Cull Canyon Regional Recreation Area | 3247 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/cull_canyon | Alameda 17 | 245.944 | Cull Canyon Reg. Rec. Area | 1964 | Local Recreation Area 3 | 4 |
16865 | 16865 | 16864 | {"type": "Polygon", "coordinates": [[[-122.05729, 37.69054], [-122.05732, 37.69085], [-122.05729, 37.69148], [-122.05633, 37.69209], [-122.05634, 37.6921], [-122.05717, 37.69218], [-122.05717, 37.69221], [-122.05697, 37.6922], [-122.05678, 37.69223], [-122.05659, 37.69231], [-122.05652, 37.6924], [-122.05651, 37.69247], [-122.05681, 37.69276], [-122.05683, 37.69285], [-122.054, 37.69283], [-122.05267, 37.69268], [-122.05186, 37.69251], [-122.05066, 37.6925], [-122.04958, 37.69254], [-122.04867, 37.69261], [-122.04792, 37.69283], [-122.04737, 37.69305], [-122.04695, 37.69323], [-122.04462, 37.69495], [-122.04445, 37.69518], [-122.0443, 37.69495], [-122.04441, 37.69486], [-122.0444, 37.69484], [-122.04436, 37.69484], [-122.04435, 37.69471], [-122.04447, 37.69457], [-122.04474, 37.69442], [-122.04516, 37.69407], [-122.04494, 37.69362], [-122.04498, 37.69344], [-122.04451, 37.69339], [-122.0444, 37.69311], [-122.04449, 37.69281], [-122.04454, 37.69281], [-122.04455, 37.6928], [-122.04437, 37.69253], [-122.04448, 37.69232], [-122.04501, 37.69184], [-122.0468, 37.69227], [-122.04681, 37.69226], [-122.04649, 37.69079], [-122.04436, 37.68999], [-122.0459, 37.68885], [-122.04634, 37.68978], [-122.04766, 37.69015], [-122.04857, 37.69003], [-122.04902, 37.69009], [-122.04925, 37.69005], [-122.04971, 37.68979], [-122.0496, 37.68951], [-122.05131, 37.68901], [-122.05114, 37.68863], [-122.05124, 37.68858], [-122.05202, 37.69024], [-122.0525, 37.69017], [-122.05276, 37.68967], [-122.05267, 37.6895], [-122.05299, 37.6894], [-122.05313, 37.68929], [-122.05364, 37.68902], [-122.05376, 37.68926], [-122.05485, 37.68961], [-122.05486, 37.6896], [-122.05485, 37.68952], [-122.05486, 37.68945], [-122.05493, 37.68947], [-122.05512, 37.68946], [-122.05515, 37.6897], [-122.05513, 37.6897], [-122.05511, 37.68989], [-122.0562, 37.68985], [-122.05698, 37.69056], [-122.05729, 37.69054]]]} | Open Access 1 | 49046 | Don Castro Regional Recreation Area | 18199 | 2000 | Alameda County Flood Control and Water Conservation District 771 | Special District 4 | Flood District 8 | http://acfloodcontrol.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | https://www.ebparks.org/parks/don_castro/ | Alameda 17 | 91.383 | Don Castro Reg. Rec. Area | 1969 | Local Recreation Area 3 | 4 |
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 | |
16638 | 16638 | 16637 | {"type": "MultiPolygon", "coordinates": [[[[-121.68009, 37.56802], [-121.68007, 37.57196], [-121.67069, 37.57206], [-121.67068, 37.57153], [-121.67092, 37.56801], [-121.68009, 37.56802]]], [[[-121.75246, 37.62111], [-121.7509, 37.62112], [-121.74958, 37.62186], [-121.74837, 37.62184], [-121.74806, 37.62246], [-121.74691, 37.62312], [-121.74699, 37.62353], [-121.74526, 37.62599], [-121.74283, 37.62803], [-121.74131, 37.62789], [-121.74099, 37.62211], [-121.73255, 37.62201], [-121.72876, 37.61978], [-121.72583, 37.61775], [-121.72459, 37.61429], [-121.72235, 37.60768], [-121.72202, 37.60661], [-121.71757, 37.60609], [-121.71465, 37.60075], [-121.70746, 37.60051], [-121.70274, 37.60031], [-121.69821, 37.60029], [-121.6969, 37.60016], [-121.69481, 37.60002], [-121.68929, 37.59975], [-121.68806, 37.60524], [-121.68772, 37.60502], [-121.68755, 37.60487], [-121.68735, 37.60465], [-121.68719, 37.60441], [-121.6871, 37.60422], [-121.68703, 37.60403], [-121.68698, 37.60376], [-121.68698, 37.60355], [-121.687, 37.60335], [-121.68705, 37.60315], [-121.68712, 37.60296], [-121.68722, 37.60277], [-121.68734, 37.60259], [-121.68749, 37.60242], [-121.68852, 37.60137], [-121.68868, 37.60116], [-121.68882, 37.60093], [-121.68895, 37.60057], [-121.68905, 37.59996], [-121.68916, 37.59976], [-121.68915, 37.59974], [-121.68908, 37.59974], [-121.68907, 37.59964], [-121.68913, 37.5994], [-121.68924, 37.59917], [-121.68967, 37.59852], [-121.68977, 37.5983], [-121.68982, 37.59812], [-121.68983, 37.59793], [-121.68982, 37.59774], [-121.68977, 37.59756], [-121.68966, 37.59734], [-121.68921, 37.59661], [-121.69368, 37.59664], [-121.69366, 37.59323], [-121.68823, 37.59339], [-121.68825, 37.59314], [-121.68843, 37.59202], [-121.68842, 37.59178], [-121.68836, 37.59155], [-121.68825, 37.59133], [-121.68805, 37.59109], [-121.68789, 37.59095], [-121.68733, 37.59055], [-121.68714, 37.59037], [-121.68705, 37.59023], [-121.68698, 37.59009], [-121.68694, 37.58997], [-121.68691, 37.5898], [-121.68693, 37.58959], [-121.68763, 37.58629], [-121.68796, 37.58607], [-121.68796, 37.58606], [-121.68035, 37.58639], [-121.68036, 37.56411], [-121.6895, 37.56405], [-121.68904, 37.56571], [-121.68899, 37.56577], [-121.69498, 37.56996], [-121.70798, 37.57891], [-121.71095, 37.58324], [-121.71589, 37.5859], [-121.71967, 37.58835], [-121.72581, 37.59067], [-121.73422, 37.59831], [-121.7459, 37.60902], [-121.74736, 37.61049], [-121.74896, 37.61319], [-121.74962, 37.61621], [-121.74793, 37.61702], [-121.74793, 37.61704], [-121.74834, 37.61757], [-121.74891, 37.61788], [-121.75182, 37.61916], [-121.7518, 37.6192], [-121.7515, 37.62024], [-121.75246, 37.62111]], [[-121.74972, 37.62053], [-121.75031, 37.61969], [-121.74918, 37.6192], [-121.7486, 37.62004], [-121.74972, 37.62053]]]]} | Open Access 1 | 47527 | Lake Del Valle State Recreation Area | 31232 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.parks.ca.gov/?page_id=537 | Alameda 17 | 3851.412 | Lake Del Valle SRA | 1967 | 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]);