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 sorted by rowid descending
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Community Services District · 74 ✖
MNG_AGENCY 1
- Consumnes Community Services District · 74 ✖
DES_TP 1
- Local Park 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12558 | 12558 | 12557 | {"type": "Polygon", "coordinates": [[[-121.34797, 38.40896], [-121.34738, 38.40896], [-121.34738, 38.4088], [-121.34746, 38.40848], [-121.34784, 38.40857], [-121.34786, 38.40856], [-121.34794, 38.4086], [-121.34803, 38.40859], [-121.34808, 38.40856], [-121.34811, 38.40852], [-121.3481, 38.4084], [-121.34813, 38.40832], [-121.34822, 38.40823], [-121.34835, 38.40813], [-121.34852, 38.40804], [-121.34876, 38.40797], [-121.34903, 38.40793], [-121.34909, 38.40796], [-121.34912, 38.40816], [-121.3491, 38.40839], [-121.34906, 38.40852], [-121.34895, 38.40866], [-121.34886, 38.40872], [-121.34847, 38.40891], [-121.34829, 38.40895], [-121.34797, 38.40896]]]} | Open Access 1 | 29061 | Lewis Park | 21195 | 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.509 | Lewis Park | 0 | Local Park 2 | 4 | |
12557 | 12557 | 12556 | {"type": "Polygon", "coordinates": [[[-121.44269, 38.39334], [-121.44264, 38.39338], [-121.44265, 38.39373], [-121.44084, 38.39374], [-121.44083, 38.39176], [-121.44165, 38.39176], [-121.44162, 38.39184], [-121.44162, 38.39189], [-121.44164, 38.39193], [-121.44168, 38.39197], [-121.44176, 38.392], [-121.4419, 38.39199], [-121.44213, 38.39203], [-121.44227, 38.39208], [-121.44245, 38.3922], [-121.44258, 38.39236], [-121.44263, 38.39248], [-121.44264, 38.39259], [-121.44265, 38.39315], [-121.44263, 38.39324], [-121.44264, 38.39329], [-121.44269, 38.39334]]]} | Open Access 1 | 29060 | Kunsting Park | 20733 | 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.769 | Kunsting Park | 0 | Local Park 2 | 4 | |
12556 | 12556 | 12555 | {"type": "Polygon", "coordinates": [[[-121.43803, 38.42032], [-121.43794, 38.42037], [-121.43769, 38.42036], [-121.43751, 38.42038], [-121.4375, 38.42006], [-121.4371, 38.41998], [-121.43663, 38.41994], [-121.43642, 38.41995], [-121.43581, 38.42006], [-121.43563, 38.42012], [-121.43548, 38.42022], [-121.43533, 38.42028], [-121.43515, 38.4203], [-121.43491, 38.42029], [-121.43484, 38.42028], [-121.4347, 38.42022], [-121.4345, 38.42043], [-121.43425, 38.42027], [-121.43403, 38.4202], [-121.43385, 38.42016], [-121.43364, 38.42016], [-121.43346, 38.42016], [-121.43329, 38.42021], [-121.43315, 38.42028], [-121.43287, 38.42047], [-121.43233, 38.42037], [-121.43175, 38.42043], [-121.43154, 38.42026], [-121.43138, 38.4202], [-121.4312, 38.42016], [-121.43097, 38.42015], [-121.43076, 38.42021], [-121.43059, 38.42029], [-121.43035, 38.42045], [-121.4302, 38.42051], [-121.43003, 38.42054], [-121.42967, 38.42052], [-121.42966, 38.42054], [-121.42958, 38.42054], [-121.4294, 38.42045], [-121.4292, 38.42039], [-121.42883, 38.42035], [-121.42849, 38.42035], [-121.42831, 38.42042], [-121.42809, 38.42], [-121.42801, 38.41988], [-121.42786, 38.4197], [-121.42768, 38.41953], [-121.42686, 38.41896], [-121.42711, 38.41878], [-121.42747, 38.41856], [-121.4279, 38.41839], [-121.42849, 38.41824], [-121.4291, 38.41813], [-121.42974, 38.41807], [-121.43013, 38.41805], [-121.43017, 38.41991], [-121.43513, 38.41988], [-121.43536, 38.41996], [-121.43557, 38.41972], [-121.43579, 38.41979], [-121.43594, 38.4198], [-121.43635, 38.41978], [-121.43667, 38.41969], [-121.43681, 38.41961], [-121.43704, 38.41981], [-121.4374, 38.41976], [-121.43789, 38.41975], [-121.43796, 38.41988], [-121.438, 38.42005], [-121.43803, 38.42032]]]} | Open Access 1 | 29059 | Kloss Park | 20691 | 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.638 | Kloss Park | 0 | Local Park 2 | 4 | |
12555 | 12555 | 12554 | {"type": "Polygon", "coordinates": [[[-121.38958, 38.44284], [-121.38952, 38.44286], [-121.38879, 38.44286], [-121.38879, 38.44208], [-121.38952, 38.44207], [-121.38957, 38.44209], [-121.38959, 38.44213], [-121.38959, 38.4428], [-121.38958, 38.44284]]]} | Open Access 1 | 29058 | Karamanos Park | 20552 | 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.499 | Karamanos Park | 0 | Local Park 2 | 4 | |
12554 | 12554 | 12553 | {"type": "Polygon", "coordinates": [[[-121.38127, 38.44688], [-121.38109, 38.44689], [-121.38072, 38.44681], [-121.38046, 38.44671], [-121.38028, 38.44651], [-121.3786, 38.44655], [-121.37749, 38.44354], [-121.37773, 38.44368], [-121.37803, 38.44394], [-121.37839, 38.44387], [-121.3793, 38.44356], [-121.37947, 38.44357], [-121.37965, 38.44373], [-121.37987, 38.44385], [-121.38036, 38.44409], [-121.38083, 38.44426], [-121.38085, 38.44425], [-121.38085, 38.44392], [-121.38115, 38.44405], [-121.38143, 38.44426], [-121.38162, 38.44448], [-121.38176, 38.44473], [-121.38183, 38.44504], [-121.38182, 38.44521], [-121.38178, 38.4454], [-121.38169, 38.44562], [-121.38141, 38.446], [-121.3813, 38.44623], [-121.38126, 38.44636], [-121.38123, 38.44655], [-121.38124, 38.44674], [-121.38127, 38.44688]]]} | Open Access 1 | 29057 | Jones Park | 20487 | 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 | 22.684 | Jones Park | 0 | Local Park 2 | 4 | |
12553 | 12553 | 12552 | {"type": "Polygon", "coordinates": [[[-121.41121, 38.41686], [-121.41113, 38.41689], [-121.41094, 38.41704], [-121.41074, 38.41722], [-121.40884, 38.41677], [-121.40884, 38.41614], [-121.40911, 38.41612], [-121.4092, 38.41608], [-121.40925, 38.41612], [-121.40933, 38.41614], [-121.4094, 38.41614], [-121.40949, 38.41611], [-121.40979, 38.41609], [-121.41012, 38.41609], [-121.41024, 38.41612], [-121.4103, 38.41611], [-121.41038, 38.41606], [-121.41041, 38.41602], [-121.41084, 38.41602], [-121.41121, 38.41686]]]} | Open Access 1 | 29056 | Foulks Park | 19017 | 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.879 | Foulks Park | 0 | Local Park 2 | 4 | |
12552 | 12552 | 12551 | {"type": "Polygon", "coordinates": [[[-121.40167, 38.45148], [-121.40135, 38.45173], [-121.40124, 38.45177], [-121.40111, 38.45176], [-121.40101, 38.45171], [-121.40065, 38.45143], [-121.4006, 38.45134], [-121.4006, 38.45127], [-121.40065, 38.45118], [-121.40095, 38.45093], [-121.4011, 38.45103], [-121.40167, 38.45148]]]} | Open Access 1 | 29055 | Fales Park | 18830 | 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.212 | Fales Park | 0 | Local Park 2 | 4 | |
12551 | 12551 | 12550 | {"type": "Polygon", "coordinates": [[[-121.38042, 38.39718], [-121.37979, 38.39739], [-121.3716, 38.39746], [-121.37156, 38.38687], [-121.37157, 38.38683], [-121.37159, 38.3868], [-121.37166, 38.38678], [-121.37171, 38.3868], [-121.37191, 38.387], [-121.3731, 38.38823], [-121.37592, 38.39121], [-121.37624, 38.39157], [-121.37632, 38.39172], [-121.37658, 38.39199], [-121.37933, 38.39571], [-121.37925, 38.39598], [-121.37939, 38.39617], [-121.37984, 38.3964], [-121.38042, 38.39718]]]} | Open Access 1 | 29054 | Elk Grove Park | 18562 | 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 | 123.144 | Elk Grove Park | 0 | Local Park 2 | 4 | |
12550 | 12550 | 12549 | {"type": "Polygon", "coordinates": [[[-121.44981, 38.40281], [-121.44976, 38.40285], [-121.44971, 38.40321], [-121.44966, 38.40335], [-121.44964, 38.40338], [-121.44958, 38.40339], [-121.44926, 38.40328], [-121.44895, 38.40314], [-121.44877, 38.40304], [-121.44846, 38.40281], [-121.44838, 38.40279], [-121.44865, 38.40261], [-121.44859, 38.40249], [-121.44886, 38.40233], [-121.44896, 38.40244], [-121.44915, 38.40258], [-121.44941, 38.40274], [-121.44981, 38.40281]]]} | Open Access 1 | 29053 | Ehrhardt Oaks Park | 18470 | 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.748 | Ehrhardt Oaks Park | 0 | Local Park 2 | 4 | |
12548 | 12548 | 12547 | {"type": "Polygon", "coordinates": [[[-121.3714, 38.4211], [-121.3709, 38.4211], [-121.37034, 38.42063], [-121.3714, 38.42063], [-121.3714, 38.4211]]]} | Open Access 1 | 29052 | Del Meyer Park | 18039 | 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.886 | Del Meyer 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
12503 | 12503 | 12502 | {"type": "Polygon", "coordinates": [[[-121.42224, 38.38493], [-121.42222, 38.38493], [-121.42218, 38.385], [-121.42212, 38.38501], [-121.4219, 38.38496], [-121.42171, 38.38494], [-121.41939, 38.38496], [-121.4194, 38.38474], [-121.41933, 38.38468], [-121.41937, 38.38463], [-121.41938, 38.38458], [-121.41934, 38.38451], [-121.4194, 38.38446], [-121.41941, 38.38419], [-121.41948, 38.38394], [-121.4195, 38.38328], [-121.42029, 38.38328], [-121.42064, 38.38324], [-121.42101, 38.38316], [-121.42108, 38.38317], [-121.42135, 38.38355], [-121.4216, 38.3838], [-121.42189, 38.38402], [-121.42257, 38.38444], [-121.42257, 38.38451], [-121.42224, 38.38493]]]} | Open Access 1 | 28334 | Machado Dairy Park | 21629 | 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.213 | Machado Dairy 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]);