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_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_WEB, LAYER
DES_TP 2
AGNCY_TYP 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
12546 | 12546 | 12545 | {"type": "Polygon", "coordinates": [[[-121.45616, 38.42344], [-121.45539, 38.4233], [-121.45467, 38.4233], [-121.45467, 38.42339], [-121.45391, 38.42326], [-121.45311, 38.42314], [-121.45307, 38.42312], [-121.45306, 38.42308], [-121.45318, 38.4224], [-121.4532, 38.42195], [-121.45324, 38.42191], [-121.45503, 38.4219], [-121.45509, 38.42193], [-121.45522, 38.42193], [-121.45525, 38.42191], [-121.45602, 38.4222], [-121.45616, 38.42344]]]} | Open Access 1 | 29050 | Zehnder Park | 27857 | 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.459 | Zehnder Park | 0 | Local Park 2 | 4 | |
12559 | 12559 | 12558 | {"type": "Polygon", "coordinates": [[[-121.35043, 38.41776], [-121.34967, 38.41781], [-121.34936, 38.41779], [-121.34944, 38.41754], [-121.34946, 38.41741], [-121.34947, 38.4172], [-121.34946, 38.41706], [-121.34934, 38.41649], [-121.34933, 38.4163], [-121.35026, 38.4163], [-121.35043, 38.41776]]]} | Open Access 1 | 29062 | Wright Park | 27759 | 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.348 | Wright 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 | |
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 | |
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 | |
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 | |
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 |
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 | |
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 | |
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 |
12566 | 12566 | 12565 | {"type": "Polygon", "coordinates": [[[-121.44068, 38.38442], [-121.44068, 38.38618], [-121.43872, 38.38619], [-121.43867, 38.38613], [-121.43874, 38.38606], [-121.43872, 38.38599], [-121.43868, 38.38595], [-121.43856, 38.38589], [-121.43844, 38.38577], [-121.43872, 38.38561], [-121.43878, 38.38497], [-121.43899, 38.38496], [-121.43965, 38.38488], [-121.43981, 38.38482], [-121.43996, 38.38474], [-121.44015, 38.38459], [-121.44027, 38.38451], [-121.4405, 38.38444], [-121.44068, 38.38442]]]} | Open Access 1 | 29070 | Stephenson Park | 25832 | 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.751 | Stephenson Park | 0 | Local Park 2 | 4 | |
11791 | 11791 | 11790 | {"type": "Polygon", "coordinates": [[[-121.36685, 38.40006], [-121.36645, 38.40006], [-121.36639, 38.40002], [-121.36631, 38.40001], [-121.36571, 38.40001], [-121.36567, 38.39997], [-121.36567, 38.39945], [-121.36572, 38.39943], [-121.36602, 38.39942], [-121.36619, 38.39942], [-121.36635, 38.39945], [-121.36642, 38.39943], [-121.36647, 38.39939], [-121.36685, 38.39939], [-121.36685, 38.40006]]]} | Open Access 1 | 24087 | Smedberg Park | 25564 | 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.725 | Smedberg 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 | |
12504 | 12504 | 12503 | {"type": "Polygon", "coordinates": [[[-121.42725, 38.38731], [-121.42685, 38.38738], [-121.42634, 38.38715], [-121.42628, 38.3868], [-121.42631, 38.38663], [-121.42635, 38.3866], [-121.42638, 38.3866], [-121.42673, 38.38667], [-121.42716, 38.38672], [-121.42718, 38.38676], [-121.42719, 38.38706], [-121.42725, 38.38725], [-121.42725, 38.38731]]]} | Open Access 1 | 28335 | Schauer Park | 25180 | 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.345 | Schauer 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 | |
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 | |
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 |
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 | |
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 |
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]);