units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
94 rows where MNG_AGENCY = 559 and MNG_AG_TYP = 17
This data as json, copyable, CSV (advanced)
DES_TP 2
MNG_AG_TYP 1
- Community Services District · 74 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 |
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]);