units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
94 rows where MNG_AGENCY = 559 sorted by map
This data as json, copyable, CSV (advanced)
DES_TP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- Consumnes Community Services District · 74 ✖
ACCESS_TYP 1
- Open Access 74
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11753 | 11753 | 11752 | {"type": "Polygon", "coordinates": [[[-121.37143, 38.44052], [-121.36803, 38.44054], [-121.36802, 38.43895], [-121.36868, 38.43893], [-121.36868, 38.4382], [-121.37135, 38.43818], [-121.3714, 38.43819], [-121.37143, 38.43822], [-121.37144, 38.43825], [-121.37142, 38.43839], [-121.37143, 38.44052]]]} | Open Access 1 | 24046 | Rau Park | 24197 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 17.845 | Rau Park | 0 | Local Park 2 | 4 | |
11750 | 11750 | 11749 | {"type": "Polygon", "coordinates": [[[-121.3732, 38.44851], [-121.37316, 38.44858], [-121.37318, 38.44904], [-121.37268, 38.44903], [-121.37246, 38.44899], [-121.37241, 38.44896], [-121.37244, 38.44875], [-121.37243, 38.44837], [-121.37309, 38.44836], [-121.37309, 38.44841], [-121.37312, 38.44846], [-121.3732, 38.44851]]]} | Open Access 1 | 24043 | Gage Park | 19170 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 1.148 | Gage Park | 0 | Local Park 2 | 4 | |
3559 | 3559 | 3558 | {"type": "Polygon", "coordinates": [[[-121.37535, 38.41303], [-121.37525, 38.41306], [-121.37525, 38.41445], [-121.37472, 38.41457], [-121.37452, 38.41458], [-121.37452, 38.41431], [-121.37455, 38.4143], [-121.37454, 38.41261], [-121.37525, 38.41261], [-121.37525, 38.41292], [-121.37535, 38.41296], [-121.37535, 38.41303]]]} | Open Access 1 | 28336 | Beeman Park | 15953 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 3.279 | Beeman Park | 0 | Local Park 2 | 4 | |
12506 | 12506 | 12505 | {"type": "Polygon", "coordinates": [[[-121.37654, 38.40796], [-121.37501, 38.40797], [-121.37499, 38.40782], [-121.37335, 38.40783], [-121.37335, 38.40729], [-121.37456, 38.40729], [-121.37505, 38.40699], [-121.37573, 38.407], [-121.37574, 38.40698], [-121.37585, 38.40696], [-121.37625, 38.40696], [-121.37626, 38.40753], [-121.37654, 38.40774], [-121.37654, 38.40796]]]} | Open Access 1 | 28338 | Baker Park | 15767 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 5.454 | Baker Park | 0 | Local Park 2 | 4 | |
11752 | 11752 | 11751 | {"type": "Polygon", "coordinates": [[[-121.37676, 38.44496], [-121.37635, 38.44544], [-121.37599, 38.44529], [-121.37572, 38.44522], [-121.37544, 38.44519], [-121.37541, 38.44517], [-121.37539, 38.44514], [-121.3754, 38.44476], [-121.376, 38.44477], [-121.37675, 38.4449], [-121.37676, 38.44496]]]} | Open Access 1 | 24045 | Hrepich Park | 20128 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 1.488 | Hrepich Park | 0 | Local Park 2 | 4 | |
11769 | 11769 | 11768 | {"type": "Polygon", "coordinates": [[[-121.37703, 38.42161], [-121.377, 38.42169], [-121.37703, 38.42178], [-121.37703, 38.42262], [-121.37624, 38.42262], [-121.37623, 38.42127], [-121.37672, 38.42127], [-121.37672, 38.42145], [-121.37703, 38.42161]]]} | Open Access 1 | 24061 | Castello Park | 16948 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 2.382 | Castello Park | 0 | Local Park 2 | 4 | |
11756 | 11756 | 11755 | {"type": "Polygon", "coordinates": [[[-121.37829, 38.43358], [-121.37803, 38.43438], [-121.37725, 38.4342], [-121.37708, 38.43413], [-121.37698, 38.43406], [-121.3769, 38.43397], [-121.37684, 38.43389], [-121.37674, 38.43366], [-121.37659, 38.4335], [-121.37687, 38.43332], [-121.37689, 38.43317], [-121.37718, 38.43323], [-121.37788, 38.43349], [-121.37829, 38.43358]]]} | Open Access 1 | 24049 | Mix Park | 22333 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 2.924 | Mix Park | 0 | Local Park 2 | 4 | |
12551 | 12551 | 12550 | {"type": "Polygon", "coordinates": [[[-121.38042, 38.39718], [-121.37979, 38.39739], [-121.3716, 38.39746], [-121.37156, 38.38687], [-121.37157, 38.38683], [-121.37159, 38.3868], [-121.37166, 38.38678], [-121.37171, 38.3868], [-121.37191, 38.387], [-121.3731, 38.38823], [-121.37592, 38.39121], [-121.37624, 38.39157], [-121.37632, 38.39172], [-121.37658, 38.39199], [-121.37933, 38.39571], [-121.37925, 38.39598], [-121.37939, 38.39617], [-121.37984, 38.3964], [-121.38042, 38.39718]]]} | Open Access 1 | 29054 | Elk Grove Park | 18562 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 123.144 | Elk Grove Park | 0 | Local Park 2 | 4 | |
14483 | 14483 | 14482 | {"type": "Polygon", "coordinates": [[[-121.38091, 38.42364], [-121.38089, 38.42712], [-121.37995, 38.42794], [-121.37993, 38.42791], [-121.37994, 38.42787], [-121.3803, 38.42755], [-121.3804, 38.42743], [-121.38049, 38.42726], [-121.38053, 38.42709], [-121.38051, 38.42689], [-121.38048, 38.42677], [-121.38042, 38.42667], [-121.38027, 38.42648], [-121.38006, 38.42633], [-121.37988, 38.42625], [-121.37968, 38.4262], [-121.37949, 38.42618], [-121.3793, 38.42618], [-121.37851, 38.42554], [-121.37825, 38.42573], [-121.37824, 38.42591], [-121.3782, 38.42596], [-121.37803, 38.42594], [-121.37783, 38.42625], [-121.37768, 38.42655], [-121.37773, 38.42659], [-121.37769, 38.42664], [-121.37769, 38.4267], [-121.37759, 38.42673], [-121.37744, 38.42733], [-121.3774, 38.42733], [-121.37733, 38.4273], [-121.37726, 38.42724], [-121.37723, 38.42717], [-121.37722, 38.4271], [-121.37764, 38.42617], [-121.37768, 38.42597], [-121.37768, 38.42575], [-121.37763, 38.42553], [-121.37751, 38.42529], [-121.37735, 38.42508], [-121.37717, 38.42493], [-121.37687, 38.42474], [-121.37671, 38.42466], [-121.37645, 38.42456], [-121.37621, 38.42452], [-121.37592, 38.42451], [-121.37563, 38.42454], [-121.37539, 38.4246], [-121.37511, 38.42472], [-121.37481, 38.42451], [-121.37455, 38.42455], [-121.37367, 38.42449], [-121.37368, 38.42362], [-121.3741, 38.42362], [-121.37519, 38.4237], [-121.37598, 38.4237], [-121.3767, 38.42365], [-121.3783, 38.42363], [-121.38091, 38.42364]]]} | Open Access 1 | 47138 | Underwood Park | 30815 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/646/Underwood-Park | Sacramento 41 | 30.458 | Underwood Park | 0 | Local Park 2 | 4 |
12554 | 12554 | 12553 | {"type": "Polygon", "coordinates": [[[-121.38127, 38.44688], [-121.38109, 38.44689], [-121.38072, 38.44681], [-121.38046, 38.44671], [-121.38028, 38.44651], [-121.3786, 38.44655], [-121.37749, 38.44354], [-121.37773, 38.44368], [-121.37803, 38.44394], [-121.37839, 38.44387], [-121.3793, 38.44356], [-121.37947, 38.44357], [-121.37965, 38.44373], [-121.37987, 38.44385], [-121.38036, 38.44409], [-121.38083, 38.44426], [-121.38085, 38.44425], [-121.38085, 38.44392], [-121.38115, 38.44405], [-121.38143, 38.44426], [-121.38162, 38.44448], [-121.38176, 38.44473], [-121.38183, 38.44504], [-121.38182, 38.44521], [-121.38178, 38.4454], [-121.38169, 38.44562], [-121.38141, 38.446], [-121.3813, 38.44623], [-121.38126, 38.44636], [-121.38123, 38.44655], [-121.38124, 38.44674], [-121.38127, 38.44688]]]} | Open Access 1 | 29057 | Jones Park | 20487 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 22.684 | Jones Park | 0 | Local Park 2 | 4 | |
11772 | 11772 | 11771 | {"type": "Polygon", "coordinates": [[[-121.38669, 38.41831], [-121.38668, 38.41952], [-121.38566, 38.41969], [-121.38543, 38.4197], [-121.38524, 38.41969], [-121.3854, 38.41902], [-121.3854, 38.41831], [-121.38669, 38.41831]]]} | Open Access 1 | 24065 | Feickert Park | 18864 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 4.177 | Feickert Park | 0 | Local Park 2 | 4 | |
12555 | 12555 | 12554 | {"type": "Polygon", "coordinates": [[[-121.38958, 38.44284], [-121.38952, 38.44286], [-121.38879, 38.44286], [-121.38879, 38.44208], [-121.38952, 38.44207], [-121.38957, 38.44209], [-121.38959, 38.44213], [-121.38959, 38.4428], [-121.38958, 38.44284]]]} | Open Access 1 | 29058 | Karamanos Park | 20552 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 1.499 | Karamanos Park | 0 | Local Park 2 | 4 | |
11755 | 11755 | 11754 | {"type": "Polygon", "coordinates": [[[-121.3936, 38.43618], [-121.39359, 38.43719], [-121.39325, 38.4371], [-121.39304, 38.4371], [-121.39283, 38.43713], [-121.39241, 38.43713], [-121.39262, 38.43683], [-121.39273, 38.43665], [-121.3928, 38.43643], [-121.39284, 38.43623], [-121.39287, 38.43619], [-121.3936, 38.43618]]]} | Open Access 1 | 24048 | Lombardi Park | 21412 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 2.047 | Lombardi Park | 0 | Local Park 2 | 4 | |
12547 | 12547 | 12546 | {"type": "Polygon", "coordinates": [[[-121.3967, 38.41621], [-121.3967, 38.4165], [-121.39663, 38.41653], [-121.39659, 38.4166], [-121.3966, 38.41664], [-121.39664, 38.41669], [-121.39661, 38.41672], [-121.3966, 38.41708], [-121.39662, 38.41712], [-121.39653, 38.41715], [-121.39646, 38.41702], [-121.39609, 38.41661], [-121.3958, 38.41635], [-121.39532, 38.41598], [-121.39514, 38.4158], [-121.39498, 38.4156], [-121.39551, 38.41544], [-121.3958, 38.41544], [-121.39586, 38.41553], [-121.39603, 38.4157], [-121.3962, 38.41581], [-121.3962, 38.4162], [-121.3967, 38.41621]]]} | Open Access 1 | 29051 | Colton Park | 17545 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 2.681 | Colton Park | 0 | Local Park 2 | 4 | |
11781 | 11781 | 11780 | {"type": "Polygon", "coordinates": [[[-121.40107, 38.41322], [-121.401, 38.41339], [-121.40095, 38.41356], [-121.39933, 38.41331], [-121.39933, 38.41265], [-121.39966, 38.41265], [-121.39971, 38.41282], [-121.39981, 38.41296], [-121.39995, 38.41307], [-121.40013, 38.41315], [-121.40034, 38.4132], [-121.40068, 38.4132], [-121.40084, 38.41325], [-121.40091, 38.41324], [-121.40099, 38.41319], [-121.40107, 38.41322]]]} | Open Access 1 | 24076 | Oneto Park | 23144 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 1.613 | Oneto Park | 0 | Local Park 2 | 4 | |
12552 | 12552 | 12551 | {"type": "Polygon", "coordinates": [[[-121.40167, 38.45148], [-121.40135, 38.45173], [-121.40124, 38.45177], [-121.40111, 38.45176], [-121.40101, 38.45171], [-121.40065, 38.45143], [-121.4006, 38.45134], [-121.4006, 38.45127], [-121.40065, 38.45118], [-121.40095, 38.45093], [-121.4011, 38.45103], [-121.40167, 38.45148]]]} | Open Access 1 | 29055 | Fales Park | 18830 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 1.212 | Fales Park | 0 | Local Park 2 | 4 | |
14479 | 14479 | 14478 | {"type": "Polygon", "coordinates": [[[-121.40288, 38.397], [-121.40292, 38.39684], [-121.40298, 38.39674], [-121.40307, 38.39665], [-121.40318, 38.39659], [-121.40331, 38.39654], [-121.40351, 38.39651], [-121.40372, 38.39654], [-121.40385, 38.39659], [-121.40396, 38.39666], [-121.40408, 38.39679], [-121.40412, 38.3969], [-121.40414, 38.39701], [-121.4041, 38.39717], [-121.40404, 38.39727], [-121.40395, 38.39736], [-121.40384, 38.39743], [-121.40371, 38.39747], [-121.40351, 38.3975], [-121.4033, 38.39747], [-121.40317, 38.39742], [-121.40306, 38.39735], [-121.40294, 38.39722], [-121.4029, 38.39711], [-121.40288, 38.397]]]} | Open Access 1 | 47134 | Island Park | 30811 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/631/Island-Park | Sacramento 41 | 2.307 | Island Park | 0 | Local Park 2 | 4 |
11777 | 11777 | 11776 | {"type": "Polygon", "coordinates": [[[-121.40535, 38.41585], [-121.40535, 38.41622], [-121.40223, 38.41622], [-121.40224, 38.4159], [-121.4025, 38.41584], [-121.40265, 38.41583], [-121.4027, 38.4158], [-121.40275, 38.41575], [-121.40276, 38.41569], [-121.40271, 38.41559], [-121.40271, 38.4155], [-121.40278, 38.41525], [-121.40281, 38.41522], [-121.40285, 38.41521], [-121.40388, 38.41538], [-121.40414, 38.4154], [-121.40455, 38.41538], [-121.40518, 38.41525], [-121.40524, 38.41525], [-121.40528, 38.41528], [-121.4053, 38.4154], [-121.4053, 38.41562], [-121.40527, 38.41571], [-121.40527, 38.41575], [-121.40529, 38.41581], [-121.40535, 38.41585]]]} | Open Access 1 | 24072 | Miwok Park | 22331 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 6.04 | Miwok Park | 0 | Local Park 2 | 4 | |
11760 | 11760 | 11759 | {"type": "Polygon", "coordinates": [[[-121.40841, 38.42928], [-121.40823, 38.42936], [-121.40818, 38.42942], [-121.40814, 38.42949], [-121.40814, 38.42959], [-121.40833, 38.42983], [-121.40831, 38.43019], [-121.408, 38.43026], [-121.40767, 38.4304], [-121.40752, 38.4305], [-121.40738, 38.43061], [-121.40717, 38.43085], [-121.40692, 38.43073], [-121.40672, 38.43065], [-121.40651, 38.43059], [-121.40622, 38.43053], [-121.40622, 38.43039], [-121.40629, 38.43032], [-121.40632, 38.43021], [-121.40647, 38.43004], [-121.40665, 38.42992], [-121.40813, 38.42927], [-121.40824, 38.42925], [-121.40832, 38.42921], [-121.40841, 38.42928]]]} | Open Access 1 | 24053 | Guttridge Park | 19575 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 4.174 | Guttridge Park | 0 | Local Park 2 | 4 | |
12565 | 12565 | 12564 | {"type": "Polygon", "coordinates": [[[-121.40872, 38.43284], [-121.40871, 38.43409], [-121.40753, 38.43393], [-121.40724, 38.43386], [-121.40699, 38.43377], [-121.40678, 38.43365], [-121.40658, 38.43351], [-121.40647, 38.4334], [-121.40713, 38.43241], [-121.4074, 38.43258], [-121.40771, 38.4327], [-121.40795, 38.43275], [-121.40872, 38.43284]]]} | Open Access 1 | 29069 | Pinkerton Park | 23696 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 6.013 | Pinkerton 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]);