units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
94 rows where MNG_AGENCY = 559 sorted by PARK_URL descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER
DES_TP 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
14473 | 14473 | 14472 | {"type": "Polygon", "coordinates": [[[-121.40982, 38.39728], [-121.40982, 38.39787], [-121.40853, 38.39786], [-121.40854, 38.39727], [-121.40982, 38.39728]]]} | Open Access 1 | 47131 | Storybook Woods Park | 30808 | 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/639/Storybook-Woods-Park | Sacramento 41 | 1.816 | Storybook Woods 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 |
14481 | 14481 | 14480 | {"type": "Polygon", "coordinates": [[[-121.4142, 38.3979], [-121.41422, 38.39797], [-121.41419, 38.39807], [-121.41414, 38.39816], [-121.41406, 38.39824], [-121.41396, 38.39831], [-121.41384, 38.39835], [-121.41365, 38.39839], [-121.41344, 38.39836], [-121.41326, 38.39828], [-121.41313, 38.39816], [-121.41307, 38.39807], [-121.41304, 38.39796], [-121.41306, 38.3979], [-121.41333, 38.39793], [-121.41363, 38.39795], [-121.41394, 38.39793], [-121.4142, 38.3979]]]} | Open Access 1 | 47136 | Rose Garden Park | 30813 | 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/624/Rose-Garden-Park | Sacramento 41 | 0.996 | Rose Garden Park | 0 | Local Park 2 | 4 |
14482 | 14482 | 14481 | {"type": "Polygon", "coordinates": [[[-121.41372, 38.3969], [-121.413, 38.3969], [-121.41289, 38.39639], [-121.41285, 38.39595], [-121.41278, 38.39567], [-121.41277, 38.395], [-121.41268, 38.39489], [-121.41259, 38.39483], [-121.41242, 38.39477], [-121.4123, 38.39476], [-121.41288, 38.39476], [-121.41314, 38.39496], [-121.41369, 38.39496], [-121.4136, 38.39504], [-121.41353, 38.39518], [-121.41351, 38.39527], [-121.41351, 38.3956], [-121.41354, 38.39587], [-121.41372, 38.3969]]]} | Open Access 1 | 47137 | Promenade Park | 30814 | 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/621/Promenade-Park | Sacramento 41 | 3.631 | Promenade Park | 0 | Local Park 2 | 4 |
4120 | 4120 | 4119 | {"type": "Polygon", "coordinates": [[[-121.34852, 38.45076], [-121.34777, 38.45075], [-121.34771, 38.45079], [-121.34766, 38.45076], [-121.34759, 38.45076], [-121.3475, 38.4508], [-121.34748, 38.45083], [-121.34747, 38.45088], [-121.34728, 38.45088], [-121.34721, 38.45087], [-121.3474, 38.45018], [-121.34742, 38.45018], [-121.34742, 38.45023], [-121.34746, 38.45028], [-121.34757, 38.45031], [-121.34765, 38.45028], [-121.34774, 38.4502], [-121.34787, 38.45017], [-121.34809, 38.45015], [-121.34854, 38.45016], [-121.34857, 38.4502], [-121.34854, 38.45042], [-121.34852, 38.45076]]]} | Open Access 1 | 47128 | Jordan Family Park | 30805 | 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/604/Jordan-Family-Park | Sacramento 41 | 1.741 | Jordan Family 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 |
14484 | 14484 | 14483 | {"type": "Polygon", "coordinates": [[[-121.34161, 38.40181], [-121.34162, 38.40199], [-121.34165, 38.40214], [-121.34162, 38.40219], [-121.34122, 38.40229], [-121.34088, 38.40239], [-121.34038, 38.40259], [-121.34008, 38.40276], [-121.33979, 38.40294], [-121.33953, 38.40315], [-121.33926, 38.40339], [-121.33919, 38.40339], [-121.33885, 38.40322], [-121.33865, 38.40314], [-121.33833, 38.40307], [-121.33811, 38.40306], [-121.33791, 38.40307], [-121.33739, 38.40315], [-121.33738, 38.40318], [-121.33718, 38.40319], [-121.33692, 38.40319], [-121.33687, 38.40317], [-121.33685, 38.40314], [-121.33686, 38.40252], [-121.33696, 38.40237], [-121.33696, 38.40234], [-121.33693, 38.40229], [-121.33703, 38.40223], [-121.33703, 38.40179], [-121.34161, 38.40181]]]} | Open Access 1 | 47139 | Derr-Okamoto Park | 30816 | 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/590/Derr-Okamoto-Park | Sacramento 41 | 12.378 | Derr-Okamoto 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 |
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 |
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 |
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 |
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 | |
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 | |
3573 | 3573 | 3572 | {"type": "Polygon", "coordinates": [[[-121.47927, 38.41104], [-121.47989, 38.41113], [-121.48031, 38.41123], [-121.48033, 38.41127], [-121.48024, 38.4115], [-121.48019, 38.41184], [-121.48013, 38.41186], [-121.47927, 38.41181], [-121.4793, 38.41153], [-121.47923, 38.41133], [-121.47927, 38.41104]]]} | Open Access 1 | 29068 | Perez Park | 23609 | 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.695 | Perez Park | 0 | Local Park 2 | 4 | |
4113 | 4113 | 4112 | {"type": "Polygon", "coordinates": [[[-121.35944, 38.41534], [-121.35944, 38.41627], [-121.35395, 38.4163], [-121.35405, 38.41543], [-121.35476, 38.41527], [-121.35481, 38.41533], [-121.35488, 38.41536], [-121.35506, 38.41534], [-121.35521, 38.41534], [-121.35561, 38.41539], [-121.35677, 38.41575], [-121.35699, 38.4158], [-121.35723, 38.41581], [-121.35761, 38.41578], [-121.35793, 38.41569], [-121.35821, 38.41554], [-121.35845, 38.41534], [-121.35944, 38.41534]]]} | Open Access 1 | 47113 | Hill Park | 30784 | 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.163 | Hill Park | 0 | Local Park 2 | 4 | |
4122 | 4122 | 4121 | {"type": "Polygon", "coordinates": [[[-121.45166, 38.42828], [-121.45123, 38.42827], [-121.45104, 38.42799], [-121.45153, 38.428], [-121.45166, 38.42828]]]} | Open Access 1 | 47130 | Harris Ranch Park | 30807 | 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.311 | Harris Ranch Park | 0 | Local Park 2 | 4 | |
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 | |
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 | |
11751 | 11751 | 11750 | {"type": "Polygon", "coordinates": [[[-121.35789, 38.44863], [-121.35783, 38.44864], [-121.35668, 38.44864], [-121.35664, 38.4486], [-121.35664, 38.44812], [-121.35783, 38.44803], [-121.35789, 38.44863]]]} | Open Access 1 | 24044 | Perry Park | 23615 | 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.657 | Perry 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]);