units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
94 rows where MNG_AGENCY = 559 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER
DES_TP 2
AGNCY_NAME 2 ✖
MNG_AG_TYP 1
MNG_AGENCY 1
- Consumnes Community Services District · 94 ✖
ACCESS_TYP 1
- Open Access 94
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12541 | 12541 | 12540 | {"type": "Polygon", "coordinates": [[[-121.36943, 38.44722], [-121.36911, 38.4473], [-121.36882, 38.44745], [-121.36862, 38.44752], [-121.36844, 38.44754], [-121.36794, 38.44755], [-121.36772, 38.44758], [-121.3677, 38.44537], [-121.36942, 38.44537], [-121.36943, 38.44722]]]} | Open Access 1 | 29045 | Amundson Park | 15463 | 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 | 8.564 | Amundson Park | 0 | Local Park 2 | 4 | |
12569 | 12569 | 12568 | {"type": "Polygon", "coordinates": [[[-121.43142, 38.3814], [-121.43141, 38.38145], [-121.42914, 38.38144], [-121.42914, 38.38116], [-121.42912, 38.38115], [-121.42916, 38.38111], [-121.42917, 38.38105], [-121.42914, 38.38095], [-121.42914, 38.38006], [-121.42917, 38.37995], [-121.42916, 38.3799], [-121.42912, 38.37986], [-121.42914, 38.37985], [-121.42914, 38.37947], [-121.43132, 38.37946], [-121.43138, 38.37948], [-121.4314, 38.37952], [-121.43142, 38.3814]]]} | Open Access 1 | 29078 | Backer Park | 15752 | 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 | 10.773 | Backer 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 | |
12542 | 12542 | 12541 | {"type": "Polygon", "coordinates": [[[-121.47122, 38.42207], [-121.47055, 38.42258], [-121.4703, 38.42258], [-121.4702, 38.42264], [-121.47006, 38.42265], [-121.46996, 38.42263], [-121.46986, 38.42258], [-121.46961, 38.42257], [-121.46898, 38.42208], [-121.46899, 38.42179], [-121.46917, 38.42177], [-121.46916, 38.42082], [-121.469, 38.42082], [-121.469, 38.42054], [-121.46908, 38.42052], [-121.46914, 38.42049], [-121.47034, 38.42048], [-121.47105, 38.4199], [-121.47111, 38.41993], [-121.47118, 38.41994], [-121.47118, 38.4208], [-121.47102, 38.42081], [-121.47103, 38.42176], [-121.47121, 38.42177], [-121.47122, 38.42207]]]} | Open Access 1 | 29046 | Bartholomew Park | 15841 | 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 | 10.241 | Bartholomew Park | 0 | Local Park 2 | 4 | |
14480 | 14480 | 14479 | {"type": "Polygon", "coordinates": [[[-121.42687, 38.39388], [-121.42259, 38.39408], [-121.42253, 38.39406], [-121.42251, 38.39403], [-121.42245, 38.39353], [-121.4222, 38.39047], [-121.42254, 38.39046], [-121.4225, 38.38985], [-121.42686, 38.38968], [-121.42687, 38.39388]]]} | Open Access 1 | 47135 | Bartholomew Sports Park | 30812 | 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/584/Bartholomew-Sports-Park | Sacramento 41 | 45.36 | Bartholomew Sports Park | 0 | Local Recreation Area 3 | 4 |
11773 | 11773 | 11772 | {"type": "Polygon", "coordinates": [[[-121.42449, 38.41889], [-121.42368, 38.41943], [-121.42327, 38.41898], [-121.42324, 38.41869], [-121.42353, 38.41864], [-121.42368, 38.41859], [-121.42398, 38.41845], [-121.42415, 38.4184], [-121.42426, 38.41839], [-121.4243, 38.41842], [-121.42445, 38.41877], [-121.4245, 38.41885], [-121.42449, 38.41889]]]} | Open Access 1 | 24067 | Batey Park | 15861 | 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.845 | Batey 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 | |
11796 | 11796 | 11795 | {"type": "Polygon", "coordinates": [[[-121.34845, 38.39049], [-121.3479, 38.39027], [-121.34783, 38.39028], [-121.34779, 38.39023], [-121.34774, 38.39021], [-121.34763, 38.39021], [-121.3476, 38.39016], [-121.34705, 38.38994], [-121.34715, 38.38984], [-121.34735, 38.38953], [-121.34739, 38.38951], [-121.34747, 38.38951], [-121.34868, 38.39], [-121.3487, 38.39004], [-121.3487, 38.39008], [-121.34845, 38.39049]]]} | Open Access 1 | 24092 | Berens Park | 16019 | 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.922 | Berens 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 | |
12543 | 12543 | 12542 | {"type": "Polygon", "coordinates": [[[-121.44049, 38.4306], [-121.44003, 38.4306], [-121.43918, 38.43156], [-121.43899, 38.43148], [-121.43873, 38.43143], [-121.43846, 38.43139], [-121.43708, 38.43138], [-121.43685, 38.43139], [-121.43668, 38.43144], [-121.43645, 38.43151], [-121.43619, 38.43155], [-121.43418, 38.43163], [-121.43414, 38.43161], [-121.43412, 38.43158], [-121.43412, 38.43063], [-121.43409, 38.43062], [-121.43409, 38.43039], [-121.4341, 38.43035], [-121.43413, 38.43034], [-121.43492, 38.43033], [-121.43493, 38.43062], [-121.43972, 38.4306], [-121.43973, 38.43003], [-121.43984, 38.43003], [-121.44029, 38.43008], [-121.44049, 38.43016], [-121.44049, 38.4306]]]} | Open Access 1 | 29047 | Betschart Park | 16049 | 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 | 13.204 | Betschart Park | 0 | Local Park 2 | 4 | |
12544 | 12544 | 12543 | {"type": "Polygon", "coordinates": [[[-121.44595, 38.39725], [-121.44596, 38.39751], [-121.44588, 38.39779], [-121.44581, 38.39779], [-121.44572, 38.39782], [-121.44567, 38.39788], [-121.44566, 38.39795], [-121.44533, 38.39799], [-121.445, 38.39799], [-121.44499, 38.39769], [-121.44494, 38.39755], [-121.44486, 38.39741], [-121.44485, 38.39738], [-121.44487, 38.39736], [-121.44495, 38.39732], [-121.44509, 38.39729], [-121.44595, 38.39725]]]} | Open Access 1 | 29048 | Bradford Park | 16325 | 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.547 | Bradford Park | 0 | Local Park 2 | 4 | |
14474 | 14474 | 14473 | {"type": "Polygon", "coordinates": [[[-121.40937, 38.39491], [-121.40933, 38.39492], [-121.40931, 38.39494], [-121.40931, 38.39518], [-121.40915, 38.39516], [-121.40907, 38.39518], [-121.40901, 38.39524], [-121.409, 38.39531], [-121.40903, 38.39538], [-121.40903, 38.39545], [-121.40856, 38.39544], [-121.40857, 38.39481], [-121.40908, 38.39481], [-121.40937, 38.39491]]]} | Open Access 1 | 47132 | Bridgeview Park | 30809 | 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/595/Bridgeview-Park | Sacramento 41 | 0.925 | Bridgeview Park | 0 | Local Park 2 | 4 |
4119 | 4119 | 4118 | {"type": "Polygon", "coordinates": [[[-121.44987, 38.38318], [-121.44957, 38.38321], [-121.44957, 38.38325], [-121.44874, 38.38344], [-121.44865, 38.38316], [-121.44852, 38.38313], [-121.44851, 38.38306], [-121.44844, 38.38301], [-121.44847, 38.38295], [-121.44837, 38.38269], [-121.44834, 38.38265], [-121.44897, 38.38231], [-121.44906, 38.38231], [-121.44938, 38.38266], [-121.44936, 38.38267], [-121.44938, 38.3827], [-121.44941, 38.38269], [-121.44987, 38.38318]]]} | Open Access 1 | 47127 | Buscher Park | 30804 | 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/566/Buscher-Park | Sacramento 41 | 2.298 | Buscher Park | 0 | Local Park 2 | 4 |
14477 | 14477 | 14476 | {"type": "MultiPolygon", "coordinates": [[[[-121.38001, 38.42816], [-121.37938, 38.42865], [-121.37942, 38.42872], [-121.37937, 38.42875], [-121.37935, 38.42879], [-121.37911, 38.42882], [-121.3788, 38.42929], [-121.37901, 38.4298], [-121.37887, 38.4299], [-121.37871, 38.43006], [-121.37863, 38.43019], [-121.37857, 38.43039], [-121.37809, 38.43057], [-121.3777, 38.43082], [-121.37771, 38.43096], [-121.37765, 38.43099], [-121.37762, 38.43106], [-121.37752, 38.43105], [-121.37721, 38.43117], [-121.37673, 38.43052], [-121.37715, 38.43014], [-121.37735, 38.43014], [-121.37763, 38.43007], [-121.3778, 38.43], [-121.37802, 38.42985], [-121.37813, 38.42973], [-121.37824, 38.42951], [-121.37828, 38.42936], [-121.37826, 38.42913], [-121.37862, 38.42897], [-121.37892, 38.42875], [-121.3789, 38.42863], [-121.37898, 38.4286], [-121.37902, 38.42855], [-121.37918, 38.42859], [-121.37977, 38.42801], [-121.38001, 38.42816]]], [[[-121.38539, 38.42712], [-121.38534, 38.43073], [-121.38522, 38.43073], [-121.38522, 38.43017], [-121.3849, 38.42994], [-121.38457, 38.42966], [-121.38434, 38.4295], [-121.3842, 38.42927], [-121.38387, 38.42925], [-121.38382, 38.4291], [-121.38373, 38.42893], [-121.38362, 38.4288], [-121.38347, 38.42868], [-121.38328, 38.42857], [-121.38271, 38.42832], [-121.38256, 38.42826], [-121.38238, 38.42822], [-121.38237, 38.42792], [-121.38168, 38.42783], [-121.3815, 38.42747], [-121.38116, 38.4276], [-121.38116, 38.42771], [-121.38108, 38.42771], [-121.38102, 38.42776], [-121.38085, 38.42771], [-121.38048, 38.42788], [-121.38022, 38.42812], [-121.37995, 38.42794], [-121.3809, 38.42712], [-121.38539, 38.42712]]]]} | Open Access 1 | 47133 | Camden Park Greenbelt | 30810 | 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/569/Camden-Park | Sacramento 41 | 23.178 | Camden Park Greenbelt | 0 | Local Recreation Area 3 | 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 | |
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 | |
12545 | 12545 | 12544 | {"type": "Polygon", "coordinates": [[[-121.45641, 38.41232], [-121.45637, 38.41233], [-121.45607, 38.41261], [-121.45601, 38.41264], [-121.45598, 38.41269], [-121.45598, 38.41275], [-121.45568, 38.41281], [-121.45527, 38.41284], [-121.4552, 38.41222], [-121.45618, 38.41213], [-121.45635, 38.41206], [-121.45638, 38.41206], [-121.45641, 38.41232]]]} | Open Access 1 | 29049 | Caterino Park | 16972 | 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.507 | Caterino 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 | |
4121 | 4121 | 4120 | {"type": "Polygon", "coordinates": [[[-121.41262, 38.4028], [-121.41282, 38.40283], [-121.41295, 38.40288], [-121.41306, 38.40295], [-121.41315, 38.40303], [-121.41321, 38.40313], [-121.41324, 38.4033], [-121.41322, 38.40341], [-121.41318, 38.40351], [-121.41305, 38.40365], [-121.41294, 38.40371], [-121.41282, 38.40376], [-121.41261, 38.40379], [-121.4124, 38.40376], [-121.41228, 38.40371], [-121.41217, 38.40364], [-121.41208, 38.40355], [-121.41202, 38.40345], [-121.41199, 38.40329], [-121.412, 38.40318], [-121.41205, 38.40308], [-121.41217, 38.40294], [-121.41228, 38.40287], [-121.41241, 38.40283], [-121.41262, 38.4028]]]} | Open Access 1 | 47129 | Constellation Park | 30806 | 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/586/Constellation-Park | Sacramento 41 | 2.307 | Constellation 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 |
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]);