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 map
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL, COUNTY, LABEL_NAME
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- East Bay Regional Park District · 28 ✖
DES_TP 1
- Local Recreation Area · 28 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 |
12726 | 12726 | 12725 | {"type": "MultiPolygon", "coordinates": [[[[-121.93312, 37.96917], [-121.93309, 37.9762], [-121.92397, 37.97636], [-121.92389, 37.98339], [-121.91481, 37.9835], [-121.91485, 37.97467], [-121.91541, 37.97455], [-121.91619, 37.97432], [-121.91638, 37.97432], [-121.91684, 37.97403], [-121.917, 37.97372], [-121.91739, 37.97344], [-121.91795, 37.97331], [-121.91823, 37.97315], [-121.91876, 37.97249], [-121.91908, 37.97226], [-121.91945, 37.97219], [-121.91991, 37.97201], [-121.92004, 37.97193], [-121.92076, 37.97121], [-121.92124, 37.97103], [-121.92209, 37.97065], [-121.92264, 37.97037], [-121.92271, 37.9702], [-121.9229, 37.97006], [-121.92356, 37.96996], [-121.92384, 37.9698], [-121.9245, 37.96925], [-121.93312, 37.96917]]], [[[-121.92264, 37.96928], [-121.922, 37.96996], [-121.92175, 37.97005], [-121.92152, 37.97027], [-121.92122, 37.97042], [-121.9205, 37.9709], [-121.91988, 37.97127], [-121.91761, 37.97247], [-121.91709, 37.97284], [-121.91631, 37.97367], [-121.91588, 37.97391], [-121.91493, 37.9742], [-121.91489, 37.96938], [-121.92264, 37.96928]]]]} | No Public Access 3 | 29753 | CNWS to Black Diamond | 17451 | 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 | 449.119 | CNWS to Black Diamond | 0 | Local Recreation Area 3 | 4 | |
10105 | 10105 | 10104 | {"type": "MultiPolygon", "coordinates": [[[[-121.97369, 37.93539], [-121.97365, 37.93544], [-121.96855, 37.93551], [-121.96867, 37.93545], [-121.97369, 37.93539]]], [[[-121.96826, 37.93546], [-121.96797, 37.93555], [-121.96726, 37.9357], [-121.96694, 37.93579], [-121.96664, 37.93591], [-121.96636, 37.93605], [-121.9661, 37.93622], [-121.96586, 37.93641], [-121.96569, 37.93657], [-121.96412, 37.93819], [-121.96404, 37.93818], [-121.96563, 37.93653], [-121.96585, 37.93633], [-121.9661, 37.93614], [-121.96637, 37.93598], [-121.96666, 37.93583], [-121.96696, 37.93572], [-121.96728, 37.93563], [-121.96782, 37.93553], [-121.96807, 37.93546], [-121.96826, 37.93546]]], [[[-121.96407, 37.93824], [-121.96335, 37.93918], [-121.96327, 37.9393], [-121.96312, 37.9396], [-121.96305, 37.93961], [-121.96316, 37.93934], [-121.96329, 37.93915], [-121.96399, 37.93823], [-121.96407, 37.93824]]], [[[-121.963, 37.93975], [-121.96304, 37.93978], [-121.96305, 37.93982], [-121.96283, 37.94043], [-121.96271, 37.94113], [-121.96265, 37.94118], [-121.96266, 37.94099], [-121.96275, 37.9405], [-121.96283, 37.9402], [-121.963, 37.93975]]], [[[-121.967, 37.94522], [-121.96692, 37.94523], [-121.96688, 37.94515], [-121.96663, 37.94479], [-121.96609, 37.94436], [-121.96423, 37.94346], [-121.96463, 37.94293], [-121.96447, 37.94288], [-121.96422, 37.94261], [-121.9641, 37.94241], [-121.96396, 37.94225], [-121.96369, 37.94199], [-121.96305, 37.94148], [-121.96287, 37.94147], [-121.9629, 37.94142], [-121.96307, 37.94142], [-121.96377, 37.94198], [-121.96401, 37.94221], [-121.96416, 37.94238], [-121.96429, 37.94259], [-121.96452, 37.94283], [-121.96475, 37.9429], [-121.96435, 37.94345], [-121.96617, 37.94432], [-121.96669, 37.94476], [-121.96695, 37.94513], [-121.967, 37.94522]]], [[[-121.96761, 37.94557], [-121.96754, 37.94563], [-121.96714, 37.94565], [-121.96699, 37.94536], [-121.96707, 37.94535], [-121.9672, 37.94559], [-121.96761, 37.94557]]], [[[-122.08253, 37.97602], [-122.08247, 37.97608], [-122.08181, 37.97609], [-122.08181, 37.97604], [-122.08253, 37.97602]]], [[[-122.08523, 37.97718], [-122.08516, 37.97722], [-122.08511, 37.97722], [-122.08497, 37.97714], [-122.08485, 37.9771], [-122.08446, 37.97706], [-122.08405, 37.97641], [-122.08396, 37.97618], [-122.08386, 37.97606], [-122.08269, 37.97608], [-122.08276, 37.97602], [-122.08396, 37.976], [-122.08396, 37.97605], [-122.08403, 37.97614], [-122.08409, 37.97627], [-122.08413, 37.97639], [-122.08447, 37.97693], [-122.08458, 37.977], [-122.08484, 37.97704], [-122.08507, 37.97712], [-122.08514, 37.97711], [-122.08523, 37.97718]]]]} | Open Access 1 | 49044 | California Riding and Hiking Trail | 33750 | 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 | https://www.ebparks.org/parks/trails/california/default.htm | Contra Costa 12 | 3.625 | California Riding and Hiking Trail | 1982 | 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 | |
218 | 218 | 217 | {"type": "MultiPolygon", "coordinates": [[[[-122.00283, 37.56787], [-122.00528, 37.56886], [-122.00536, 37.56876], [-122.00637, 37.56915], [-122.00646, 37.56905], [-122.00694, 37.56924], [-122.00841, 37.57037], [-122.00605, 37.57247], [-122.00581, 37.57272], [-122.00563, 37.57245], [-122.00561, 37.57245], [-122.00486, 37.57485], [-122.00167, 37.57418], [-122.00088, 37.57663], [-122.00033, 37.5765], [-121.99656, 37.57363], [-121.99685, 37.57277], [-121.99721, 37.57285], [-121.99723, 37.57284], [-121.99743, 37.56696], [-121.99852, 37.56669], [-121.99871, 37.5667], [-121.9987, 37.56677], [-121.99916, 37.56686], [-121.99961, 37.56698], [-122.00112, 37.56756], [-122.0012, 37.56746], [-122.00224, 37.56786], [-122.00235, 37.56771], [-122.00283, 37.56787]]], [[[-122.00227, 37.57706], [-122.00224, 37.57716], [-122.00227, 37.57718], [-122.00203, 37.57784], [-122.0005, 37.57666], [-122.00227, 37.57706]]], [[[-122.01347, 37.57268], [-122.01183, 37.57446], [-122.01014, 37.57619], [-122.00994, 37.57635], [-122.00973, 37.57651], [-122.00895, 37.57696], [-122.00821, 37.57742], [-122.00796, 37.57759], [-122.0077, 37.57782], [-122.00748, 37.57808], [-122.0073, 37.57835], [-122.00718, 37.57862], [-122.00706, 37.5786], [-122.00686, 37.57917], [-122.00811, 37.57947], [-122.00818, 37.57956], [-122.00772, 37.58092], [-122.00605, 37.58056], [-122.00568, 37.58164], [-122.00418, 37.58051], [-122.00216, 37.57896], [-122.00209, 37.57889], [-122.00203, 37.5788], [-122.00198, 37.57866], [-122.002, 37.57851], [-122.00244, 37.57734], [-122.00248, 37.57728], [-122.00258, 37.57724], [-122.003, 37.57733], [-122.00424, 37.57807], [-122.00588, 37.57674], [-122.00592, 37.57631], [-122.01114, 37.57138], [-122.01347, 37.57268]]]]} | Open Access 1 | 586 | Quarry Lakes Regional Recreation Area | 30594 | 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 | 254.616 | Quarry Lakes Reg. Rec. Area | 2001 | Local Recreation Area 3 | 4 | |
3733 | 3733 | 3732 | {"type": "MultiPolygon", "coordinates": [[[[-122.03357, 37.90414], [-122.03346, 37.90426], [-122.03345, 37.904], [-122.0335, 37.90405], [-122.03357, 37.90414]]], [[[-122.04019, 37.90842], [-122.03957, 37.90859], [-122.03754, 37.90726], [-122.03826, 37.90623], [-122.03875, 37.90662], [-122.03905, 37.9069], [-122.03939, 37.90741], [-122.03961, 37.90803], [-122.04019, 37.90842]]]]} | Open Access 1 | 31016 | Briones to Mount Diablo Trail | 33752 | 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 | 5.904 | Briones to Mount Diablo Trail | 0 | 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 |
12621 | 12621 | 12620 | {"type": "MultiPolygon", "coordinates": [[[[-122.10336, 37.88915], [-122.10325, 37.88929], [-122.09952, 37.88684], [-122.09906, 37.88657], [-122.09871, 37.8864], [-122.09832, 37.88626], [-122.09812, 37.88621], [-122.09789, 37.88617], [-122.09798, 37.88599], [-122.09846, 37.88612], [-122.09878, 37.88625], [-122.09907, 37.88638], [-122.09965, 37.88671], [-122.10336, 37.88915]]], [[[-122.1019, 37.86205], [-122.09983, 37.86557], [-122.09945, 37.86633], [-122.09932, 37.86665], [-122.0991, 37.8673], [-122.09905, 37.86718], [-122.09902, 37.86708], [-122.09902, 37.86693], [-122.09904, 37.86683], [-122.09942, 37.86591], [-122.09959, 37.86561], [-122.10171, 37.86198], [-122.1019, 37.86205]]], [[[-122.10312, 37.8574], [-122.10291, 37.8578], [-122.10264, 37.85858], [-122.10249, 37.85922], [-122.10222, 37.86073], [-122.10215, 37.86103], [-122.10202, 37.8614], [-122.10184, 37.86175], [-122.10186, 37.86166], [-122.10186, 37.86153], [-122.10177, 37.86092], [-122.10174, 37.86061], [-122.10175, 37.86053], [-122.1018, 37.86052], [-122.10189, 37.85867], [-122.10206, 37.85862], [-122.1022, 37.85863], [-122.10237, 37.85834], [-122.10243, 37.85804], [-122.10203, 37.85798], [-122.10216, 37.85747], [-122.10262, 37.85738], [-122.10272, 37.85714], [-122.10312, 37.8574]]], [[[-122.11101, 37.89088], [-122.11069, 37.89095], [-122.11037, 37.89099], [-122.11005, 37.89101], [-122.10971, 37.89099], [-122.10651, 37.89056], [-122.10567, 37.89038], [-122.10492, 37.89015], [-122.10424, 37.88986], [-122.10384, 37.88965], [-122.10339, 37.88938], [-122.10349, 37.88924], [-122.10392, 37.88949], [-122.10446, 37.88977], [-122.10501, 37.89], [-122.1057, 37.89022], [-122.1066, 37.8904], [-122.10953, 37.89081], [-122.10981, 37.89083], [-122.1101, 37.89084], [-122.1104, 37.89082], [-122.11069, 37.89078], [-122.11099, 37.89072], [-122.11101, 37.89088]]]]} | Open Access 1 | 29414 | Lafayette/Moraga Trail | 20836 | 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 | 14.096 | Lafayette/Moraga Trail | 0 | Local Recreation Area 3 | 4 | |
3624 | 3624 | 3623 | {"type": "Polygon", "coordinates": [[[-121.70748, 37.99957], [-121.7053, 37.99809], [-121.70531, 37.9979], [-121.70746, 37.99794], [-121.70748, 37.99957]]]} | Open Access 1 | 29411 | BB Delta Shoreline Trail | 15905 | 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 | 4.739 | BB Delta Shoreline Trail | 0 | Local Recreation Area 3 | 4 | |
9237 | 9237 | 9236 | {"type": "Polygon", "coordinates": [[[-121.71401, 38.0024], [-121.71401, 38.00331], [-121.71393, 38.00334], [-121.7134, 38.00283], [-121.71283, 38.00253], [-121.71206, 38.00177], [-121.71201, 38.00107], [-121.71333, 38.00191], [-121.71401, 38.0024]]]} | Open Access 1 | 15373 | Big Break Regional Trail | 16075 | 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 | 4.138 | Big Break Reg. Trail | 0 | Local Recreation Area 3 | 4 | |
6007 | 6007 | 6006 | {"type": "Polygon", "coordinates": [[[-121.85372, 37.67067], [-121.84528, 37.67162], [-121.84527, 37.67159], [-121.83346, 37.67283], [-121.83347, 37.66804], [-121.83003, 37.6675], [-121.83007, 37.66576], [-121.83764, 37.66573], [-121.84017, 37.66573], [-121.84066, 37.66594], [-121.84179, 37.66599], [-121.84221, 37.66575], [-121.84532, 37.66574], [-121.84531, 37.66757], [-121.84781, 37.6683], [-121.84917, 37.6683], [-121.85004, 37.66837], [-121.85104, 37.66906], [-121.85107, 37.66961], [-121.85181, 37.66963], [-121.8524, 37.66936], [-121.85336, 37.66841], [-121.85372, 37.67067]]]} | Open Access 1 | 690 | Shadow Cliffs Regional Recreation Area | 3312 | 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/shadow_cliffs | Alameda 17 | 253.728 | Shadow Cliffs Reg. Rec. Area | 1971 | Local Recreation Area 3 | 4 |
13126 | 13126 | 13125 | {"type": "Polygon", "coordinates": [[[-121.97561, 37.57073], [-121.97355, 37.57142], [-121.97349, 37.57127], [-121.97245, 37.57159], [-121.97094, 37.57232], [-121.97064, 37.57203], [-121.97072, 37.57045], [-121.97094, 37.5703], [-121.97132, 37.57017], [-121.97167, 37.57028], [-121.97219, 37.57057], [-121.97251, 37.57061], [-121.97248, 37.57023], [-121.97265, 37.56971], [-121.97407, 37.56935], [-121.97486, 37.57004], [-121.97518, 37.57025], [-121.97535, 37.57038], [-121.97561, 37.57073]]]} | No Public Access 3 | 46965 | Quarry Lakes Regional Recreation Area | 30596 | 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 | 17.733 | Quarry Lakes Reg. Rec. Area | 2001 | Local Recreation Area 3 | 4 | |
9475 | 9475 | 9474 | {"type": "Polygon", "coordinates": [[[-121.99706, 37.85874], [-121.99272, 37.85889], [-121.99271, 37.85879], [-121.99179, 37.85882], [-121.99177, 37.85859], [-121.99113, 37.85861], [-121.99114, 37.85894], [-121.98799, 37.85902], [-121.98802, 37.85534], [-121.98347, 37.85552], [-121.9834, 37.85198], [-121.98093, 37.85206], [-121.98203, 37.84983], [-121.98481, 37.84974], [-121.98472, 37.84989], [-121.98475, 37.85233], [-121.98792, 37.85218], [-121.98792, 37.85182], [-121.99283, 37.85166], [-121.99236, 37.85244], [-121.99237, 37.8527], [-121.99281, 37.85361], [-121.99269, 37.85461], [-121.9942, 37.85475], [-121.99566, 37.85534], [-121.99601, 37.85511], [-121.997, 37.85504], [-121.99706, 37.85874]]]} | Open Access 1 | 17309 | Las Trampas/Diablo Regional Trail | 21069 | 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 | 174.441 | Las Trampas/Diablo Reg. Trail | 1976 | Local Recreation Area 3 | 4 | |
11508 | 11508 | 11507 | {"type": "Polygon", "coordinates": [[[-122.00857, 37.57719], [-122.00838, 37.57734], [-122.00814, 37.57765], [-122.00798, 37.57795], [-122.00791, 37.57818], [-122.00786, 37.57854], [-122.00788, 37.57885], [-122.00793, 37.5791], [-122.0079, 37.57918], [-122.00795, 37.57921], [-122.00802, 37.57938], [-122.00812, 37.57947], [-122.00685, 37.57917], [-122.00706, 37.57859], [-122.00718, 37.57861], [-122.00735, 37.57827], [-122.0076, 37.57793], [-122.00781, 37.57772], [-122.008, 37.57756], [-122.00857, 37.57719]]]} | Open Access 1 | 29555 | Quarry Lakes Regional Recreation Area | 30594 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 2.872 | Quarry Lakes Reg. Rec. Area | 2001 | Local Recreation Area 3 | 4 | |
16665 | 16665 | 16664 | {"type": "Polygon", "coordinates": [[[-122.0161, 37.83947], [-122.01592, 37.83969], [-122.01594, 37.83971], [-122.01576, 37.83994], [-122.01475, 37.84015], [-122.01362, 37.84097], [-122.01307, 37.84201], [-122.01332, 37.84594], [-122.01281, 37.84602], [-122.01282, 37.84625], [-122.01252, 37.84626], [-122.01243, 37.84633], [-122.01035, 37.84636], [-122.01015, 37.84633], [-122.01004, 37.84636], [-122.00938, 37.84638], [-122.00738, 37.8457], [-122.00703, 37.84551], [-122.00622, 37.84524], [-122.00475, 37.84479], [-122.00478, 37.84468], [-122.00627, 37.84515], [-122.00735, 37.84552], [-122.00735, 37.84562], [-122.00938, 37.8463], [-122.01245, 37.84625], [-122.0128, 37.84594], [-122.0125, 37.84132], [-122.01337, 37.83979], [-122.01386, 37.83993], [-122.01417, 37.83899], [-122.0151, 37.83896], [-122.01558, 37.83916], [-122.0161, 37.83947]]]} | No Public Access 3 | 15340 | Las Trampas/Diablo Regional Trail | 21068 | 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 | 16.575 | Las Trampas/Diablo Reg. Trail | 0 | Local Recreation Area 3 | 4 | |
3269 | 3269 | 3268 | {"type": "Polygon", "coordinates": [[[-122.0528, 37.99715], [-122.05267, 37.99768], [-122.05079, 37.99735], [-122.05079, 37.99734], [-122.05051, 37.99729], [-122.05017, 37.99725], [-122.05016, 37.99724], [-122.04978, 37.99725], [-122.04887, 37.99733], [-122.04817, 37.99731], [-122.04823, 37.9969], [-122.04863, 37.99694], [-122.04888, 37.99693], [-122.04913, 37.99691], [-122.04957, 37.9968], [-122.04985, 37.99676], [-122.04986, 37.99675], [-122.05003, 37.99674], [-122.0501, 37.99681], [-122.05025, 37.99683], [-122.05029, 37.99673], [-122.05066, 37.99677], [-122.0528, 37.99715]]]} | Open Access 1 | 29407 | Delta/DeAnza Trail | 18077 | 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 | 5.445 | Delta/DeAnza Trail | 0 | 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 |
16852 | 16852 | 16851 | {"type": "Polygon", "coordinates": [[[-122.06054, 37.71153], [-122.06043, 37.71157], [-122.0603, 37.71167], [-122.06017, 37.71178], [-122.06019, 37.71182], [-122.06007, 37.71189], [-122.06019, 37.7124], [-122.06032, 37.71239], [-122.06038, 37.71255], [-122.06024, 37.71258], [-122.06036, 37.71312], [-122.06053, 37.71317], [-122.0601, 37.71443], [-122.0581, 37.71415], [-122.05794, 37.71437], [-122.0578, 37.71435], [-122.0574, 37.71481], [-122.05788, 37.71593], [-122.05643, 37.71632], [-122.05602, 37.7164], [-122.0559, 37.71652], [-122.05385, 37.71618], [-122.05385, 37.71614], [-122.05389, 37.716], [-122.05378, 37.71565], [-122.05375, 37.71565], [-122.05376, 37.71549], [-122.05383, 37.71522], [-122.05398, 37.71503], [-122.0545, 37.71473], [-122.05467, 37.7146], [-122.0548, 37.71446], [-122.05495, 37.7143], [-122.05504, 37.71406], [-122.05507, 37.71391], [-122.05507, 37.71358], [-122.05504, 37.71326], [-122.05504, 37.71298], [-122.05499, 37.71279], [-122.05499, 37.71255], [-122.05496, 37.71232], [-122.05497, 37.71216], [-122.05505, 37.71182], [-122.05508, 37.71139], [-122.05507, 37.71111], [-122.05478, 37.71026], [-122.05465, 37.70995], [-122.05453, 37.70953], [-122.05449, 37.70925], [-122.05449, 37.70908], [-122.05454, 37.70883], [-122.05467, 37.70849], [-122.05467, 37.70834], [-122.0548, 37.70793], [-122.05491, 37.70744], [-122.05486, 37.70718], [-122.05481, 37.70703], [-122.05475, 37.70686], [-122.05466, 37.70675], [-122.0545, 37.70637], [-122.05446, 37.70615], [-122.05441, 37.70602], [-122.05441, 37.70586], [-122.05443, 37.70571], [-122.05453, 37.70544], [-122.05472, 37.7052], [-122.05496, 37.70468], [-122.05515, 37.70402], [-122.05517, 37.70387], [-122.05687, 37.70404], [-122.05721, 37.7049], [-122.05741, 37.7059], [-122.05671, 37.70631], [-122.05715, 37.70716], [-122.0571, 37.70749], [-122.05861, 37.70765], [-122.05855, 37.7082], [-122.05813, 37.70821], [-122.05771, 37.70818], [-122.05763, 37.70871], [-122.0579, 37.70874], [-122.05791, 37.70878], [-122.05803, 37.7088], [-122.05824, 37.70892], [-122.05839, 37.70898], [-122.05855, 37.70912], [-122.05853, 37.70915], [-122.05849, 37.70913], [-122.0584, 37.70923], [-122.05843, 37.70926], [-122.05789, 37.70988], [-122.05846, 37.71022], [-122.05884, 37.7105], [-122.05906, 37.71074], [-122.05911, 37.71084], [-122.05922, 37.71098], [-122.05924, 37.7111], [-122.05982, 37.71124], [-122.05994, 37.71115], [-122.06051, 37.71121], [-122.06054, 37.71153]]]} | Open Access 1 | 43107 | Cull Canyon Regional Recreation Area | 3247 | 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 | http://www.ebparks.org/parks/cull_canyon | Alameda 17 | 109.685 | Cull Canyon Reg. Rec. Area | 1964 | Local Recreation Area 3 | 4 |
3646 | 3646 | 3645 | {"type": "Polygon", "coordinates": [[[-122.09719, 37.88699], [-122.0967, 37.88654], [-122.09593, 37.88668], [-122.09517, 37.88629], [-122.09471, 37.88637], [-122.09407, 37.88659], [-122.09356, 37.88625], [-122.09322, 37.88618], [-122.0933, 37.88612], [-122.0934, 37.8861], [-122.09615, 37.88602], [-122.09669, 37.88602], [-122.09723, 37.88606], [-122.09727, 37.88609], [-122.09728, 37.88613], [-122.09719, 37.88664], [-122.09719, 37.88699]]]} | Open Access 1 | 29549 | Lafayette/Moraga Trail | 20836 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 4.276 | Lafayette/Moraga Trail | 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]);