units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
95 rows where MNG_AGENCY = 14 sorted by LABEL_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6531 | 6531 | 6530 | {"type": "MultiPolygon", "coordinates": [[[[-119.77984, 36.87156], [-119.77966, 36.87362], [-119.77899, 36.87362], [-119.77909, 36.87304], [-119.77923, 36.8718], [-119.77984, 36.87156]]], [[[-119.77985, 36.8713], [-119.77924, 36.87154], [-119.77958, 36.86783], [-119.77973, 36.86805], [-119.77993, 36.8686], [-119.77999, 36.86929], [-119.77985, 36.8713]]], [[[-119.79146, 36.87061], [-119.78963, 36.87074], [-119.78963, 36.87116], [-119.78948, 36.87117], [-119.78764, 36.8717], [-119.78655, 36.87182], [-119.78507, 36.87095], [-119.78472, 36.87079], [-119.78321, 36.87199], [-119.78336, 36.8725], [-119.78317, 36.87293], [-119.78262, 36.87323], [-119.78149, 36.87337], [-119.78108, 36.87363], [-119.77986, 36.87363], [-119.78006, 36.87141], [-119.78019, 36.86928], [-119.78012, 36.86857], [-119.77992, 36.868], [-119.77961, 36.86751], [-119.77973, 36.86629], [-119.77997, 36.86552], [-119.78036, 36.86468], [-119.78061, 36.86427], [-119.7828, 36.86076], [-119.78288, 36.86073], [-119.78347, 36.86095], [-119.78398, 36.86117], [-119.78432, 36.86127], [-119.78469, 36.86134], [-119.78481, 36.86134], [-119.78498, 36.86136], [-119.78531, 36.86136], [-119.78674, 36.86118], [-119.78719, 36.86116], [-119.78817, 36.86119], [-119.78935, 36.86117], [-119.79014, 36.86126], [-119.79103, 36.86126], [-119.7911, 36.86129], [-119.79113, 36.86134], [-119.79118, 36.86235], [-119.79119, 36.8629], [-119.7914, 36.86729], [-119.79136, 36.87004], [-119.79125, 36.87043], [-119.7913, 36.87054], [-119.79146, 36.87061]]]]} | Open Access 1 | 2849 | Woodward Regional Park | 3935 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/government/departmentdirectory/parksandrecreation/parksandfacilities/regional+parks/woodwardpark.htm | Fresno 9 | 290.772 | Woodward RP | 0 | Local Park 2 | 4 |
9423 | 9423 | 9422 | {"type": "Polygon", "coordinates": [[[-119.83984, 36.79196], [-119.83983, 36.79363], [-119.83765, 36.79364], [-119.83767, 36.79198], [-119.83984, 36.79196]]]} | Open Access 1 | 15755 | Wilson Park | 27610 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 8.872 | Wilson Park | 0 | Local Park 2 | 4 | |
542 | 542 | 541 | {"type": "Polygon", "coordinates": [[[-119.72964, 36.73869], [-119.72964, 36.73915], [-119.72751, 36.73913], [-119.72751, 36.7387], [-119.72964, 36.73869]]]} | Open Access 1 | 2756 | Willow-Balch Park | 27572 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 2.327 | Willow-Balch Park | 0 | Local Park 2 | 4 | |
7281 | 7281 | 7280 | {"type": "Polygon", "coordinates": [[[-119.85946, 36.77405], [-119.85882, 36.77405], [-119.85878, 36.77397], [-119.85869, 36.77392], [-119.85806, 36.77392], [-119.858, 36.77393], [-119.85794, 36.77396], [-119.85791, 36.774], [-119.85789, 36.77406], [-119.85725, 36.77406], [-119.85727, 36.77397], [-119.85732, 36.7739], [-119.85734, 36.77374], [-119.85734, 36.77366], [-119.85729, 36.77359], [-119.85721, 36.77327], [-119.8572, 36.77314], [-119.85724, 36.77311], [-119.85724, 36.77327], [-119.85731, 36.77351], [-119.85762, 36.77351], [-119.8577, 36.77345], [-119.85786, 36.77349], [-119.85801, 36.77349], [-119.85816, 36.77344], [-119.85816, 36.77322], [-119.85813, 36.77319], [-119.85816, 36.77314], [-119.85817, 36.77309], [-119.85814, 36.77303], [-119.85809, 36.77299], [-119.85809, 36.77244], [-119.85794, 36.77232], [-119.85794, 36.77225], [-119.85788, 36.77218], [-119.85788, 36.77204], [-119.85791, 36.77202], [-119.85823, 36.77202], [-119.85828, 36.77199], [-119.85837, 36.77199], [-119.85837, 36.77221], [-119.85829, 36.77217], [-119.85819, 36.77217], [-119.85811, 36.77222], [-119.85809, 36.7723], [-119.8581, 36.77235], [-119.85815, 36.77239], [-119.85821, 36.77242], [-119.85829, 36.77242], [-119.85829, 36.77297], [-119.85841, 36.77306], [-119.85841, 36.77313], [-119.85845, 36.77319], [-119.85841, 36.77322], [-119.85842, 36.77343], [-119.85857, 36.77348], [-119.85865, 36.77348], [-119.85888, 36.77338], [-119.85903, 36.77338], [-119.85911, 36.7735], [-119.85946, 36.7735], [-119.85943, 36.77359], [-119.85939, 36.77365], [-119.85938, 36.77374], [-119.8594, 36.77391], [-119.85945, 36.77397], [-119.85946, 36.77405]]]} | Open Access 1 | 48940 | Westwood Park | 33656 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 3.656 | Westwood Park | 0 | Local Park 2 | 4 | |
538 | 538 | 537 | {"type": "Polygon", "coordinates": [[[-119.74277, 36.8014], [-119.74277, 36.80312], [-119.74078, 36.80312], [-119.74079, 36.8014], [-119.74277, 36.8014]]]} | Open Access 1 | 2652 | Vinland Park | 27143 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 8.364 | Vinland Park | 0 | Local Park 2 | 4 | |
145 | 145 | 144 | {"type": "Polygon", "coordinates": [[[-119.86216, 36.76989], [-119.86214, 36.77167], [-119.86209, 36.77171], [-119.86059, 36.77173], [-119.86058, 36.77176], [-119.86044, 36.77177], [-119.85782, 36.77178], [-119.85781, 36.76991], [-119.86216, 36.76989]]]} | Open Access 1 | 365 | Victoria West Community Park | 27084 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 19.669 | Victoria West Community Park | 0 | Local Park 2 | 4 | |
635 | 635 | 634 | {"type": "Polygon", "coordinates": [[[-119.77627, 36.79171], [-119.77626, 36.7921], [-119.77622, 36.79217], [-119.77614, 36.79222], [-119.77607, 36.79223], [-119.77477, 36.79223], [-119.77479, 36.79156], [-119.7761, 36.79158], [-119.77621, 36.79162], [-119.77627, 36.79171]]]} | Open Access 1 | 2573 | University Park | 26686 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 2.376 | University Park | 0 | Local Park 2 | 4 | |
5973 | 5973 | 5972 | {"type": "Polygon", "coordinates": [[[-119.79755, 36.72125], [-119.79751, 36.72155], [-119.79706, 36.72174], [-119.79668, 36.72196], [-119.79665, 36.72195], [-119.79658, 36.72188], [-119.79655, 36.7218], [-119.79655, 36.72146], [-119.79697, 36.72146], [-119.79702, 36.72143], [-119.79706, 36.72138], [-119.79706, 36.72125], [-119.79755, 36.72125]]]} | Open Access 1 | 47326 | Tupman Pocket Park | 31033 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 0.96 | Tupman PP | 0 | Local Park 2 | 4 | |
6516 | 6516 | 6515 | {"type": "Polygon", "coordinates": [[[-119.79424, 36.75293], [-119.794, 36.75293], [-119.79398, 36.75284], [-119.79363, 36.75283], [-119.7936, 36.75262], [-119.7929, 36.75264], [-119.7929, 36.75233], [-119.79402, 36.75232], [-119.79402, 36.75259], [-119.79421, 36.75258], [-119.79424, 36.75293]]]} | Open Access 1 | 2496 | Ted C Wills Park & Community Center | 26212 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 1.226 | Ted C Wills Park & Community Ctr. | 0 | Local Recreation Area 3 | 4 | |
6496 | 6496 | 6495 | {"type": "Polygon", "coordinates": [[[-119.71618, 36.7287], [-119.71617, 36.72952], [-119.71405, 36.72952], [-119.71405, 36.7287], [-119.71618, 36.7287]]]} | Open Access 1 | 2368 | Sunnyside Park | 26010 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 4.266 | Sunnyside Park | 0 | Local Park 2 | 4 | |
6366 | 6366 | 6365 | {"type": "MultiPolygon", "coordinates": [[[[-119.78683, 36.85228], [-119.78498, 36.85367], [-119.7841, 36.85433], [-119.78406, 36.85412], [-119.78674, 36.85212], [-119.78683, 36.85228]]], [[[-119.78372, 36.85461], [-119.76849, 36.86602], [-119.76817, 36.86623], [-119.76778, 36.86623], [-119.76811, 36.86606], [-119.76841, 36.86586], [-119.78372, 36.85438], [-119.78372, 36.85461]]], [[[-119.76748, 36.86652], [-119.76705, 36.86663], [-119.7667, 36.86669], [-119.76634, 36.86671], [-119.7659, 36.86671], [-119.7659, 36.86654], [-119.76748, 36.86652]]], [[[-119.76569, 36.86671], [-119.75699, 36.86679], [-119.75698, 36.86662], [-119.76569, 36.86654], [-119.76569, 36.86671]]], [[[-119.75657, 36.86679], [-119.74799, 36.86687], [-119.74799, 36.86678], [-119.74786, 36.86677], [-119.74786, 36.86671], [-119.75512, 36.86667], [-119.75657, 36.86663], [-119.75657, 36.86679]]], [[[-119.74761, 36.86687], [-119.74389, 36.8669], [-119.7389, 36.86694], [-119.7389, 36.86679], [-119.74183, 36.86677], [-119.74187, 36.86679], [-119.74761, 36.86677], [-119.74761, 36.86687]]], [[[-119.73869, 36.86694], [-119.73431, 36.86698], [-119.73431, 36.86683], [-119.73869, 36.8668], [-119.73869, 36.86694]]]]} | Open Access 1 | 1743 | Sugar Pine Trail | 25944 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 21.648 | Sugar Pine Trail | 0 | Local Recreation Area 3 | 4 | |
524 | 524 | 523 | {"type": "Polygon", "coordinates": [[[-119.89185, 36.82504], [-119.89184, 36.82616], [-119.88975, 36.82617], [-119.88977, 36.82508], [-119.89185, 36.82504]]]} | Open Access 1 | 2261 | Stallion Park | 25780 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 5.628 | Stallion Park | 0 | Local Park 2 | 4 | |
530 | 530 | 529 | {"type": "Polygon", "coordinates": [[[-119.80634, 36.85317], [-119.80522, 36.8539], [-119.80515, 36.85384], [-119.80519, 36.85369], [-119.8057, 36.85332], [-119.80577, 36.85314], [-119.80578, 36.85299], [-119.80575, 36.85279], [-119.80586, 36.8528], [-119.80601, 36.85278], [-119.80606, 36.85298], [-119.80629, 36.85309], [-119.80634, 36.85317]]]} | Open Access 1 | 1748 | Spano Park | 25714 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 0.962 | Spano Park | 0 | Local Park 2 | 4 | |
11833 | 11833 | 11832 | {"type": "Polygon", "coordinates": [[[-119.7477, 36.86655], [-119.74555, 36.86657], [-119.74555, 36.86479], [-119.7477, 36.86477], [-119.7477, 36.86655]]]} | Open Access 1 | 24159 | Selma Layne Park | 25291 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 9.348 | Selma Layne Park | 0 | Local Park 2 | 4 | |
5935 | 5935 | 5934 | {"type": "Polygon", "coordinates": [[[-119.79717, 36.7505], [-119.79716, 36.75054], [-119.79712, 36.75055], [-119.79669, 36.7507], [-119.79669, 36.75072], [-119.79608, 36.75095], [-119.79521, 36.75121], [-119.79516, 36.7512], [-119.79512, 36.75115], [-119.79511, 36.75056], [-119.79515, 36.75052], [-119.79644, 36.75054], [-119.79717, 36.7505]]]} | Open Access 1 | 47314 | San Pablo Pocket Park | 31021 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 1.9 | San Pablo PP | 0 | Local Park 2 | 4 | |
5758 | 5758 | 5757 | {"type": "Polygon", "coordinates": [[[-119.85482, 36.82922], [-119.85479, 36.82931], [-119.85447, 36.82937], [-119.85418, 36.8294], [-119.85409, 36.82933], [-119.85409, 36.82866], [-119.85415, 36.82861], [-119.8542, 36.82861], [-119.85428, 36.82864], [-119.85453, 36.82893], [-119.85482, 36.82922]]]} | Open Access 1 | 47300 | Safety Pocket Park | 31007 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 0.894 | Safety PP | 0 | Local Park 2 | 4 | |
517 | 517 | 516 | {"type": "Polygon", "coordinates": [[[-119.77001, 36.80122], [-119.76779, 36.80122], [-119.76779, 36.79947], [-119.76789, 36.79945], [-119.76789, 36.79825], [-119.76891, 36.79825], [-119.76891, 36.79772], [-119.77, 36.79772], [-119.77001, 36.80122]]]} | Open Access 1 | 2141 | Rotary Park West | 24703 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 17.219 | Rotary Park West | 0 | Local Park 2 | 4 | |
174 | 174 | 173 | {"type": "Polygon", "coordinates": [[[-119.75401, 36.83145], [-119.75399, 36.83147], [-119.7525, 36.83155], [-119.75249, 36.83068], [-119.75238, 36.83067], [-119.75238, 36.83038], [-119.75399, 36.83038], [-119.754, 36.83039], [-119.75401, 36.83145]]]} | Open Access 1 | 473 | Rotary Park East | 24702 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 4.268 | Rotary Park East | 0 | Local Park 2 | 4 | |
508 | 508 | 507 | {"type": "Polygon", "coordinates": [[[-119.77465, 36.75361], [-119.77461, 36.75365], [-119.77404, 36.75398], [-119.77404, 36.75406], [-119.7726, 36.75407], [-119.7726, 36.75242], [-119.77465, 36.75241], [-119.77465, 36.75361]]]} | Open Access 1 | 2073 | Romain Playground | 24586 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 7.876 | Romain Playground | 0 | Local Recreation Area 3 | 4 | |
501 | 501 | 500 | {"type": "Polygon", "coordinates": [[[-119.82816, 36.75561], [-119.82654, 36.75563], [-119.82655, 36.75724], [-119.82652, 36.75731], [-119.82644, 36.75736], [-119.82178, 36.75742], [-119.81757, 36.7535], [-119.81589, 36.75199], [-119.81569, 36.75175], [-119.81557, 36.75157], [-119.81551, 36.75137], [-119.81553, 36.75121], [-119.81561, 36.75107], [-119.8158, 36.75094], [-119.8159, 36.75082], [-119.81596, 36.75072], [-119.816, 36.75057], [-119.81604, 36.7505], [-119.81612, 36.75045], [-119.81624, 36.75042], [-119.81624, 36.75039], [-119.82394, 36.75033], [-119.82395, 36.75035], [-119.82412, 36.75037], [-119.8243, 36.75041], [-119.82446, 36.75049], [-119.82463, 36.75061], [-119.82561, 36.75163], [-119.82719, 36.7537], [-119.82734, 36.75394], [-119.82816, 36.75561]]]} | Open Access 1 | 2033 | Roeding Park | 24557 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 144.652 | Roeding Park | 0 | 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]);