units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
194 rows where ACCESS_TYP = 1 and MNG_AG_TYP = 17 sorted by MNG_AG_ID
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Consumnes Community Services District 83
- El Dorado Hills Community Service District 25
- Jurupa Community Services District 10
- Cameron Park Community Services District 8
- Mountain House Community Services District 7
- Tamalpais Community Services District 4
- McKinleyville Community Services District 3
- Brooktrails Community Services District 2
- Twain Harte Community Services District 2
- Groveland Community Services District 2
- Manila Community Services District 2
- Indian Valley Community Services District 2
- Aromona Community Services District 2
- Helendale Community Services District 2
- Pajaro Community Services District 2
- Salton Community Services District 2
- Templeton Community Services District 2
- Discovery Bay Community Service District 1
- Scotia Community Services District 1
- Cambria Community Services District 1
- Golden Hills Community Service District 1
- Happy Camp Community Services District 1
- McCloud Community Services District 1
- Lake Shastina Community Services District 1
- Concord Landscaping and Lighting Maintenance District No. 3 1
- Tomales Village Community Services District 1
- Bolinas Community Public Utility District 1
- Bel Marin Keys Community Services District 1
- Mountain Gate Community Special District 1
- Willow Creek Community Services District 1
- …
DES_TP 11
- Local Park 153
- Local Recreation Area 12
- Local Conservation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 1
- Community Services District · 174 ✖
ACCESS_TYP 1
- Open Access · 174 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
11754 | 11754 | 11753 | {"type": "Polygon", "coordinates": [[[-121.43863, 38.43772], [-121.43838, 38.43792], [-121.43823, 38.43809], [-121.43811, 38.43825], [-121.43804, 38.43825], [-121.43772, 38.43819], [-121.43758, 38.43818], [-121.43758, 38.43792], [-121.4376, 38.43791], [-121.4376, 38.43763], [-121.43807, 38.43763], [-121.43828, 38.43757], [-121.43842, 38.4375], [-121.43863, 38.43772]]]} | Open Access 1 | 24047 | Rose Park | 24615 | 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.188 | Rose 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 | |
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 | |
11757 | 11757 | 11756 | {"type": "Polygon", "coordinates": [[[-121.42936, 38.43427], [-121.42939, 38.43439], [-121.4294, 38.4345], [-121.42939, 38.43453], [-121.42935, 38.43456], [-121.42833, 38.43455], [-121.42829, 38.43454], [-121.42826, 38.43451], [-121.42826, 38.43426], [-121.42828, 38.43405], [-121.42867, 38.43409], [-121.42881, 38.43413], [-121.42894, 38.43423], [-121.42903, 38.43435], [-121.42936, 38.43427]]]} | Open Access 1 | 24050 | Davis Park | 17953 | 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 | 0.996 | Davis Park | 0 | Local Park 2 | 4 | |
11758 | 11758 | 11757 | {"type": "Polygon", "coordinates": [[[-121.42469, 38.4338], [-121.42405, 38.4338], [-121.42403, 38.43382], [-121.42397, 38.43381], [-121.42389, 38.43382], [-121.42386, 38.4338], [-121.42355, 38.4338], [-121.42354, 38.43312], [-121.42461, 38.43311], [-121.42466, 38.43313], [-121.42468, 38.43315], [-121.42469, 38.4338]]]} | Open Access 1 | 24051 | Herburger Park | 19831 | 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.877 | Herburger Park | 0 | Local Park 2 | 4 | |
11759 | 11759 | 11758 | {"type": "Polygon", "coordinates": [[[-121.43856, 38.4322], [-121.43773, 38.43316], [-121.43751, 38.43309], [-121.4383, 38.43218], [-121.43841, 38.43218], [-121.43856, 38.4322]]]} | Open Access 1 | 24052 | Betschart Park | 16049 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 0.634 | Betschart 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 | |
11761 | 11761 | 11760 | {"type": "Polygon", "coordinates": [[[-121.45444, 38.42969], [-121.45442, 38.43075], [-121.45442, 38.43083], [-121.45439, 38.43086], [-121.45317, 38.43087], [-121.45288, 38.43085], [-121.45288, 38.42967], [-121.45444, 38.42969]]]} | Open Access 1 | 24054 | Fite Park | 18926 | 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.401 | Fite Park | 0 | Local Park 2 | 4 | |
11762 | 11762 | 11761 | {"type": "Polygon", "coordinates": [[[-121.47927, 38.41762], [-121.47932, 38.41763], [-121.47945, 38.41771], [-121.4797, 38.41789], [-121.47992, 38.41809], [-121.47993, 38.41812], [-121.47992, 38.41815], [-121.4796, 38.41836], [-121.4777, 38.41986], [-121.47762, 38.41985], [-121.47711, 38.41945], [-121.4771, 38.41941], [-121.47712, 38.41938], [-121.4789, 38.41797], [-121.47907, 38.41781], [-121.47922, 38.41764], [-121.47927, 38.41762]]]} | Open Access 1 | 24066 | King Park | 20657 | 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.184 | King Park | 0 | Local Park 2 | 4 | |
11763 | 11763 | 11762 | {"type": "Polygon", "coordinates": [[[-121.44323, 38.42694], [-121.4431, 38.4271], [-121.4431, 38.42723], [-121.44297, 38.42724], [-121.44289, 38.42729], [-121.44285, 38.42739], [-121.44255, 38.42773], [-121.44244, 38.4278], [-121.44241, 38.42789], [-121.44201, 38.42836], [-121.44191, 38.4284], [-121.44188, 38.42844], [-121.44188, 38.42849], [-121.44144, 38.42899], [-121.44137, 38.429], [-121.44132, 38.42904], [-121.4413, 38.42909], [-121.4413, 38.42914], [-121.44064, 38.42988], [-121.44064, 38.43019], [-121.44049, 38.43016], [-121.44029, 38.43008], [-121.44017, 38.43007], [-121.44021, 38.42985], [-121.44019, 38.42961], [-121.4401, 38.42937], [-121.44001, 38.42922], [-121.44017, 38.4291], [-121.44111, 38.42818], [-121.44118, 38.4281], [-121.44123, 38.42797], [-121.44124, 38.42781], [-121.44122, 38.42771], [-121.44118, 38.42762], [-121.44103, 38.42746], [-121.44092, 38.42739], [-121.4408, 38.42734], [-121.44101, 38.42695], [-121.44323, 38.42694]]]} | Open Access 1 | 24055 | Wackman Park | 27204 | 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 | 9.073 | Wackman Park | 0 | Local Park 2 | 4 | |
11764 | 11764 | 11763 | {"type": "Polygon", "coordinates": [[[-121.42263, 38.43032], [-121.42199, 38.43036], [-121.4183, 38.43038], [-121.41825, 38.43037], [-121.41823, 38.43034], [-121.41821, 38.43031], [-121.41821, 38.43007], [-121.41818, 38.42964], [-121.41818, 38.42808], [-121.41822, 38.42804], [-121.41827, 38.42803], [-121.42137, 38.428], [-121.42168, 38.42804], [-121.4226, 38.4283], [-121.42263, 38.43032]]]} | Open Access 1 | 24056 | Laguna Community Park | 20849 | 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 | 24.556 | Laguna Community Park | 0 | Local Park 2 | 4 | |
11765 | 11765 | 11764 | {"type": "Polygon", "coordinates": [[[-121.43624, 38.42824], [-121.43613, 38.42847], [-121.43607, 38.42869], [-121.43432, 38.42814], [-121.43436, 38.42786], [-121.43441, 38.42782], [-121.43443, 38.42777], [-121.43441, 38.42771], [-121.43437, 38.42767], [-121.43431, 38.42739], [-121.4343, 38.42709], [-121.43435, 38.42705], [-121.43437, 38.427], [-121.43435, 38.42695], [-121.43431, 38.42691], [-121.43437, 38.42684], [-121.43486, 38.42685], [-121.43489, 38.42692], [-121.43498, 38.42697], [-121.43509, 38.42698], [-121.43543, 38.42709], [-121.4356, 38.42712], [-121.43582, 38.42713], [-121.43586, 38.42715], [-121.43588, 38.42718], [-121.43594, 38.42742], [-121.43602, 38.42757], [-121.43611, 38.4277], [-121.43638, 38.42801], [-121.43638, 38.42805], [-121.43624, 38.42824]]]} | Open Access 1 | 24057 | Case Park | 16942 | 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.076 | Case Park | 0 | Local Park 2 | 4 | |
11766 | 11766 | 11765 | {"type": "Polygon", "coordinates": [[[-121.40978, 38.42718], [-121.40877, 38.42737], [-121.40846, 38.42737], [-121.40744, 38.42639], [-121.40714, 38.42634], [-121.40819, 38.42567], [-121.40978, 38.42718]]]} | Open Access 1 | 24058 | Zimbelman Park | 27865 | 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.892 | Zimbelman Park | 0 | Local Park 2 | 4 | |
11767 | 11767 | 11766 | {"type": "Polygon", "coordinates": [[[-121.47885, 38.42529], [-121.47888, 38.42535], [-121.47879, 38.42573], [-121.47878, 38.42593], [-121.47875, 38.42596], [-121.47771, 38.42597], [-121.47764, 38.42594], [-121.47763, 38.42552], [-121.47762, 38.42534], [-121.47765, 38.42528], [-121.47798, 38.42524], [-121.47824, 38.42522], [-121.47848, 38.42524], [-121.47885, 38.42529]]]} | Open Access 1 | 24059 | Lawson Park | 21119 | 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.044 | Lawson Park | 0 | Local Park 2 | 4 | |
11768 | 11768 | 11767 | {"type": "Polygon", "coordinates": [[[-121.47146, 38.42428], [-121.47146, 38.42521], [-121.47145, 38.42523], [-121.4714, 38.42526], [-121.47051, 38.42526], [-121.47037, 38.42524], [-121.47026, 38.42512], [-121.47016, 38.42508], [-121.47003, 38.42509], [-121.46997, 38.42512], [-121.46992, 38.42517], [-121.46876, 38.42428], [-121.46953, 38.42428], [-121.46972, 38.42433], [-121.46978, 38.42433], [-121.46983, 38.4243], [-121.46987, 38.42426], [-121.46987, 38.42421], [-121.46974, 38.42321], [-121.4698, 38.42317], [-121.46983, 38.42311], [-121.4698, 38.42306], [-121.46975, 38.42302], [-121.46971, 38.42271], [-121.46985, 38.42271], [-121.46985, 38.42276], [-121.46982, 38.42277], [-121.46983, 38.42286], [-121.46994, 38.42291], [-121.47009, 38.42293], [-121.47023, 38.42291], [-121.47035, 38.42286], [-121.47035, 38.42278], [-121.47033, 38.42276], [-121.47034, 38.42271], [-121.47048, 38.42271], [-121.47044, 38.42302], [-121.47038, 38.42306], [-121.47037, 38.4231], [-121.47038, 38.42317], [-121.47045, 38.42321], [-121.4703, 38.42421], [-121.47031, 38.42427], [-121.47037, 38.42432], [-121.47043, 38.42433], [-121.47063, 38.42428], [-121.47146, 38.42428]]]} | Open Access 1 | 24060 | Town Square Park | 26495 | 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.653 | Town Square 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 | |
11770 | 11770 | 11769 | {"type": "Polygon", "coordinates": [[[-121.33921, 38.42094], [-121.33921, 38.42132], [-121.33772, 38.42183], [-121.33772, 38.4211], [-121.3381, 38.4211], [-121.3382, 38.42113], [-121.33828, 38.42112], [-121.33835, 38.42109], [-121.33839, 38.42105], [-121.33841, 38.42099], [-121.3384, 38.42094], [-121.33921, 38.42094]]]} | Open Access 1 | 24062 | Fleming Park | 18945 | 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.992 | Fleming Park | 0 | Local Park 2 | 4 | |
11771 | 11771 | 11770 | {"type": "Polygon", "coordinates": [[[-121.48326, 38.42133], [-121.48259, 38.42144], [-121.48254, 38.42137], [-121.48225, 38.42115], [-121.48194, 38.42097], [-121.48157, 38.42093], [-121.48161, 38.42058], [-121.4816, 38.42011], [-121.48167, 38.42007], [-121.48196, 38.42004], [-121.48254, 38.41994], [-121.48293, 38.41993], [-121.48298, 38.41994], [-121.483, 38.41997], [-121.48303, 38.42014], [-121.48326, 38.42133]]]} | Open Access 1 | 24064 | Hawkins Park | 19748 | 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.455 | Hawkins 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]);