units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
94 rows where MNG_AGENCY = 559 sorted by UNIT_ID
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11737 | 11737 | 11736 | {"type": "Polygon", "coordinates": [[[-121.3624, 38.41993], [-121.3624, 38.42089], [-121.36205, 38.4209], [-121.36201, 38.42086], [-121.36188, 38.42039], [-121.36186, 38.4202], [-121.36186, 38.41995], [-121.3624, 38.41993]]]} | Open Access 1 | 24063 | Van Doren Park | 26826 | 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.115 | Van Doren 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 | |
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 | |
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 | |
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 | |
11774 | 11774 | 11773 | {"type": "Polygon", "coordinates": [[[-121.46162, 38.4168], [-121.46166, 38.41685], [-121.46163, 38.41703], [-121.46162, 38.41741], [-121.46157, 38.41765], [-121.46147, 38.41786], [-121.46135, 38.41804], [-121.46118, 38.41822], [-121.46097, 38.41838], [-121.46074, 38.41851], [-121.46048, 38.41861], [-121.46027, 38.41866], [-121.46002, 38.4187], [-121.45976, 38.41871], [-121.45951, 38.41869], [-121.45897, 38.41858], [-121.45894, 38.41855], [-121.45893, 38.41852], [-121.45904, 38.41828], [-121.45913, 38.41812], [-121.4593, 38.41788], [-121.45943, 38.41774], [-121.45963, 38.41755], [-121.46006, 38.41721], [-121.46046, 38.41699], [-121.46093, 38.41684], [-121.46124, 38.41679], [-121.46148, 38.41679], [-121.46162, 38.4168]]]} | Open Access 1 | 24068 | Lawrence Park | 21118 | 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 | 7.927 | Lawrence Park | 0 | Local Park 2 | 4 | |
11775 | 11775 | 11774 | {"type": "Polygon", "coordinates": [[[-121.34151, 38.41629], [-121.34151, 38.4166], [-121.34146, 38.41658], [-121.34098, 38.41669], [-121.34063, 38.41672], [-121.34057, 38.41663], [-121.33983, 38.41663], [-121.33987, 38.41659], [-121.33987, 38.41538], [-121.33983, 38.4153], [-121.33988, 38.41526], [-121.33991, 38.41495], [-121.33991, 38.41465], [-121.3402, 38.41468], [-121.34047, 38.41469], [-121.34048, 38.4147], [-121.3415, 38.4147], [-121.3415, 38.41628], [-121.34151, 38.41629]]]} | Open Access 1 | 24069 | Simpson Park | 25514 | 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 | 7.628 | Simpson Park | 0 | Local Park 2 | 4 | |
11776 | 11776 | 11775 | {"type": "Polygon", "coordinates": [[[-121.36833, 38.41587], [-121.36808, 38.41626], [-121.36736, 38.41626], [-121.36722, 38.41588], [-121.36764, 38.41547], [-121.3682, 38.41581], [-121.36833, 38.41587]]]} | Open Access 1 | 24071 | Mendoza Park | 22154 | 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.364 | Mendoza 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 | |
11778 | 11778 | 11777 | {"type": "Polygon", "coordinates": [[[-121.42763, 38.41422], [-121.42743, 38.41456], [-121.42741, 38.41474], [-121.42732, 38.41471], [-121.42724, 38.41472], [-121.42716, 38.41476], [-121.42712, 38.41482], [-121.42713, 38.41493], [-121.42708, 38.41526], [-121.42705, 38.41563], [-121.42704, 38.41567], [-121.427, 38.41574], [-121.42699, 38.41579], [-121.42702, 38.41586], [-121.42712, 38.4159], [-121.42708, 38.41619], [-121.42669, 38.41619], [-121.42633, 38.41581], [-121.42629, 38.41569], [-121.42628, 38.41527], [-121.42626, 38.41517], [-121.4262, 38.41506], [-121.4266, 38.41497], [-121.42657, 38.41454], [-121.42665, 38.41457], [-121.42673, 38.41458], [-121.4268, 38.41455], [-121.42683, 38.4145], [-121.42683, 38.41443], [-121.42679, 38.41438], [-121.42683, 38.41434], [-121.42683, 38.41404], [-121.4268, 38.41378], [-121.42675, 38.41374], [-121.42678, 38.4137], [-121.42678, 38.41363], [-121.42675, 38.41358], [-121.42668, 38.41355], [-121.4267, 38.4135], [-121.42661, 38.41323], [-121.42593, 38.41348], [-121.42574, 38.4133], [-121.42548, 38.41314], [-121.42546, 38.41311], [-121.42552, 38.41286], [-121.42553, 38.4127], [-121.42549, 38.41251], [-121.42542, 38.41231], [-121.42543, 38.41226], [-121.42548, 38.41222], [-121.42658, 38.41189], [-121.42709, 38.41179], [-121.42714, 38.41179], [-121.42718, 38.41182], [-121.42726, 38.41198], [-121.42734, 38.41209], [-121.42745, 38.41219], [-121.42757, 38.41226], [-121.42739, 38.4125], [-121.42752, 38.41257], [-121.42751, 38.41259], [-121.42756, 38.41309], [-121.42708, 38.41313], [-121.42707, 38.41343], [-121.42712, 38.41346], [-121.42711, 38.41352], [-121.42715, 38.4136], [-121.4272, 38.41398], [-121.42718, 38.41409], [-121.42721, 38.41415], [-121.42729, 38.4142], [-121.42763, 38.41422]]]} | Open Access 1 | 24074 | Lichtenberger Park | 21225 | 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.408 | Lichtenberger Park | 0 | Local Park 2 | 4 | |
11780 | 11780 | 11779 | {"type": "Polygon", "coordinates": [[[-121.454, 38.41388], [-121.45295, 38.41505], [-121.45241, 38.41476], [-121.45197, 38.41476], [-121.45191, 38.41444], [-121.45191, 38.4144], [-121.45195, 38.41438], [-121.45216, 38.41432], [-121.45239, 38.41424], [-121.4526, 38.41413], [-121.45277, 38.41401], [-121.45294, 38.41387], [-121.45305, 38.41374], [-121.45314, 38.41361], [-121.45323, 38.41342], [-121.45326, 38.41339], [-121.45331, 38.41339], [-121.45362, 38.41345], [-121.45387, 38.41348], [-121.45396, 38.41351], [-121.454, 38.41388]]]} | Open Access 1 | 24075 | Womack Park | 27675 | 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.991 | Womack 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 | |
11783 | 11783 | 11782 | {"type": "Polygon", "coordinates": [[[-121.35083, 38.4122], [-121.34976, 38.41217], [-121.34973, 38.41215], [-121.34971, 38.41212], [-121.34971, 38.4118], [-121.34974, 38.41174], [-121.34975, 38.41169], [-121.34969, 38.41161], [-121.34958, 38.41157], [-121.34904, 38.41157], [-121.34861, 38.41154], [-121.34825, 38.41148], [-121.34784, 38.41136], [-121.34765, 38.41128], [-121.34798, 38.41092], [-121.34779, 38.41085], [-121.34771, 38.41086], [-121.34763, 38.41085], [-121.34767, 38.41081], [-121.34776, 38.4108], [-121.34783, 38.41077], [-121.34821, 38.41037], [-121.34832, 38.41021], [-121.34874, 38.4095], [-121.34881, 38.40942], [-121.34892, 38.40934], [-121.3492, 38.40919], [-121.34933, 38.40915], [-121.3508, 38.40913], [-121.35083, 38.4122]]]} | Open Access 1 | 24077 | Strong Park | 25929 | 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 | 16.281 | Strong Park | 0 | Local Park 2 | 4 | |
11784 | 11784 | 11783 | {"type": "Polygon", "coordinates": [[[-121.46737, 38.41069], [-121.46711, 38.411], [-121.46714, 38.41105], [-121.46708, 38.4111], [-121.46704, 38.41118], [-121.46677, 38.4115], [-121.46666, 38.41164], [-121.46649, 38.41191], [-121.46641, 38.41199], [-121.46639, 38.41203], [-121.46641, 38.4121], [-121.46647, 38.41215], [-121.46655, 38.41218], [-121.46632, 38.41249], [-121.46603, 38.41238], [-121.46601, 38.4124], [-121.46576, 38.41234], [-121.4654, 38.41229], [-121.46506, 38.41229], [-121.46445, 38.41235], [-121.4642, 38.41234], [-121.46363, 38.41227], [-121.46295, 38.41227], [-121.46279, 38.41039], [-121.46315, 38.41028], [-121.4637, 38.41003], [-121.46402, 38.40995], [-121.46416, 38.40992], [-121.46448, 38.40991], [-121.46474, 38.40994], [-121.46641, 38.41032], [-121.46696, 38.4105], [-121.46737, 38.41069]]]} | Open Access 1 | 24078 | Johnson Park | 20480 | 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 | 20.881 | Johnson Park | 0 | Local Park 2 | 4 | |
11785 | 11785 | 11784 | {"type": "Polygon", "coordinates": [[[-121.36093, 38.40781], [-121.36092, 38.40783], [-121.36087, 38.40785], [-121.36024, 38.40785], [-121.36023, 38.4072], [-121.36073, 38.4072], [-121.36073, 38.40729], [-121.36076, 38.40741], [-121.3609, 38.40767], [-121.36093, 38.40781]]]} | Open Access 1 | 24080 | Russell Park | 24740 | 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.931 | Russell Park | 0 | Local Park 2 | 4 | |
11786 | 11786 | 11785 | {"type": "Polygon", "coordinates": [[[-121.42691, 38.40652], [-121.42691, 38.40547], [-121.42896, 38.40547], [-121.42901, 38.40551], [-121.4291, 38.40578], [-121.42935, 38.4063], [-121.42934, 38.40634], [-121.42929, 38.40637], [-121.42894, 38.40644], [-121.42859, 38.40648], [-121.42806, 38.40651], [-121.42691, 38.40652]]]} | Open Access 1 | 24081 | Willard Park | 27534 | 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.521 | Willard Park | 0 | Local Park 2 | 4 | |
11787 | 11787 | 11786 | {"type": "Polygon", "coordinates": [[[-121.43175, 38.40455], [-121.43186, 38.4043], [-121.43191, 38.40429], [-121.43203, 38.40432], [-121.43219, 38.40438], [-121.43238, 38.40453], [-121.43252, 38.40471], [-121.43257, 38.40485], [-121.43258, 38.40499], [-121.43257, 38.4051], [-121.43253, 38.4052], [-121.43246, 38.40533], [-121.43235, 38.40544], [-121.43222, 38.40554], [-121.43206, 38.40561], [-121.43193, 38.40565], [-121.43188, 38.40564], [-121.43185, 38.40562], [-121.43176, 38.40541], [-121.43173, 38.40526], [-121.43172, 38.40475], [-121.43175, 38.40455]]]} | Open Access 1 | 24082 | Kramer Park | 20723 | 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.105 | Kramer Park | 0 | Local Park 2 | 4 | |
2988 | 2988 | 2987 | {"type": "Polygon", "coordinates": [[[-121.43784, 38.40364], [-121.43781, 38.40446], [-121.43684, 38.40452], [-121.43668, 38.40452], [-121.43664, 38.40449], [-121.43665, 38.4038], [-121.43784, 38.40364]]]} | Open Access 1 | 24083 | Keema Park | 20570 | 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.195 | Keema Park | 0 | Local Park 2 | 4 | |
11788 | 11788 | 11787 | {"type": "Polygon", "coordinates": [[[-121.34956, 38.40229], [-121.34956, 38.40229], [-121.34941, 38.40396], [-121.34939, 38.40367], [-121.34934, 38.40354], [-121.34925, 38.4034], [-121.34915, 38.40328], [-121.34904, 38.40318], [-121.34866, 38.40295], [-121.34848, 38.40278], [-121.3484, 38.40268], [-121.34832, 38.40255], [-121.34825, 38.40231], [-121.34827, 38.40227], [-121.34832, 38.40226], [-121.34882, 38.40229], [-121.34956, 38.40229]]]} | Open Access 1 | 24084 | Gates Park | 19233 | 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.445 | Gates Park | 0 | Local Park 2 | 4 | |
11789 | 11789 | 11788 | {"type": "Polygon", "coordinates": [[[-121.47335, 38.40363], [-121.47346, 38.40347], [-121.47351, 38.40335], [-121.47354, 38.4032], [-121.47352, 38.40304], [-121.47347, 38.40289], [-121.47337, 38.40274], [-121.47329, 38.40265], [-121.47313, 38.40253], [-121.47297, 38.40245], [-121.47273, 38.40239], [-121.47252, 38.40237], [-121.47233, 38.40238], [-121.47214, 38.40243], [-121.47195, 38.40251], [-121.4718, 38.4026], [-121.47167, 38.40273], [-121.47127, 38.40251], [-121.47125, 38.40247], [-121.47125, 38.40245], [-121.47145, 38.40227], [-121.47169, 38.40212], [-121.47196, 38.40202], [-121.47225, 38.40196], [-121.47252, 38.40194], [-121.47285, 38.40197], [-121.47314, 38.40204], [-121.4734, 38.40215], [-121.47367, 38.40233], [-121.47381, 38.40247], [-121.47391, 38.4026], [-121.47397, 38.40271], [-121.47404, 38.40288], [-121.47407, 38.40303], [-121.47409, 38.40322], [-121.47406, 38.40339], [-121.47401, 38.40356], [-121.47394, 38.4037], [-121.47382, 38.40385], [-121.47375, 38.40385], [-121.47335, 38.40363]]]} | Open Access 1 | 24085 | Houde Park | 20106 | 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.214 | Houde 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]);