units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
812 rows where DES_TP = 2 and MNG_AG_LEV = 3 sorted by SUID_NMA descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, LAYER, YR_EST
MNG_AGENCY >30
- Los Angeles, County of 95
- San Diego, County of 68
- Los Angeles - Department of Parks and Recreation, County of 44
- Orange, County of 43
- El Dorado, County of 42
- Santa Barbara, County of 40
- Kern, County of 37
- Sonoma County Regional Parks Dept., County of 34
- Santa Cruz, County of 33
- Santa Clara County Parks and Recreation Dept., County of 32
- Stanislaus, County of 22
- Marin County Parks Department, County of 21
- San Luis Obispo, County of 20
- Riverside, County of 19
- Placer, County of 19
- San Mateo County Parks and Recreation Dept., County of 18
- Lake, County of 18
- San Joaquin, County of 18
- Monterey, County of 17
- Ventura, County of 15
- San Bernardino, County of 14
- Merced, County of 12
- Yolo, County of 12
- Tulare, County of 11
- Fresno, County of 11
- Humboldt, County of 10
- Sacramento, County of 7
- Contra Costa County Public Works Dept., County of 6
- Tehama, County of 6
- Mendocino, County of 6
- …
ACCESS_TYP 4
MNG_AG_TYP 3
DES_TP 1
- Local Park · 812 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16342 | 16342 | 16341 | {"type": "Polygon", "coordinates": [[[-122.52762, 38.20438], [-122.52325, 38.20854], [-122.52325, 38.20856], [-122.52512, 38.2094], [-122.51982, 38.21673], [-122.51958, 38.21647], [-122.51926, 38.21618], [-122.51815, 38.21741], [-122.51667, 38.21364], [-122.51098, 38.21317], [-122.50883, 38.2148], [-122.50824, 38.21367], [-122.50585, 38.21091], [-122.50337, 38.21308], [-122.50291, 38.21352], [-122.50207, 38.2126], [-122.50144, 38.21335], [-122.50422, 38.21553], [-122.50528, 38.21642], [-122.50179, 38.21996], [-122.50108, 38.21932], [-122.4997, 38.21796], [-122.49899, 38.21761], [-122.49727, 38.21635], [-122.49355, 38.21056], [-122.49168, 38.20981], [-122.49141, 38.20911], [-122.49104, 38.20866], [-122.49079, 38.20864], [-122.49065, 38.20851], [-122.48982, 38.20798], [-122.48954, 38.20759], [-122.48867, 38.20715], [-122.48661, 38.20644], [-122.48646, 38.20407], [-122.48661, 38.20199], [-122.48829, 38.20128], [-122.49001, 38.20127], [-122.49121, 38.20014], [-122.49131, 38.20017], [-122.49296, 38.20041], [-122.49345, 38.20052], [-122.49471, 38.20059], [-122.49535, 38.20044], [-122.49584, 38.19983], [-122.49615, 38.19923], [-122.49699, 38.19896], [-122.49788, 38.19934], [-122.50009, 38.19971], [-122.50075, 38.19966], [-122.50117, 38.19909], [-122.50102, 38.19718], [-122.49859, 38.19435], [-122.49774, 38.19403], [-122.49642, 38.19371], [-122.49675, 38.19327], [-122.49749, 38.19298], [-122.49792, 38.19256], [-122.4978, 38.1924], [-122.49726, 38.19196], [-122.49721, 38.19188], [-122.4972, 38.19182], [-122.49723, 38.19179], [-122.49721, 38.19176], [-122.49722, 38.19166], [-122.4979, 38.1917], [-122.49852, 38.19165], [-122.49856, 38.19169], [-122.49855, 38.19173], [-122.49868, 38.1918], [-122.49954, 38.19151], [-122.50035, 38.19151], [-122.50035, 38.19147], [-122.50063, 38.19144], [-122.50129, 38.1908], [-122.50154, 38.19038], [-122.50157, 38.1901], [-122.50168, 38.18995], [-122.50186, 38.18985], [-122.50224, 38.18976], [-122.50272, 38.18956], [-122.50343, 38.18921], [-122.50568, 38.18696], [-122.50996, 38.18359], [-122.51644, 38.18887], [-122.51587, 38.18959], [-122.51482, 38.19013], [-122.51436, 38.19038], [-122.51165, 38.19146], [-122.51164, 38.19148], [-122.51377, 38.19288], [-122.51577, 38.19418], [-122.51921, 38.19581], [-122.52091, 38.19654], [-122.5191, 38.19805], [-122.5242, 38.20139], [-122.52424, 38.20149], [-122.52762, 38.20438]]]} | Open Access 1 | 9819 | Tolay Lake Regional Park | 33777 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 1760.959 | Tolay Lake RP | 0 | Local Park 2 | 4 | |
10047 | 10047 | 10046 | {"type": "Polygon", "coordinates": [[[-120.81909, 39.02277], [-120.81495, 39.02381], [-120.81432, 39.02209], [-120.81557, 39.02184], [-120.81585, 39.02263], [-120.81674, 39.02246], [-120.81675, 39.02244], [-120.81647, 39.02165], [-120.81844, 39.02125], [-120.81899, 39.02269], [-120.81909, 39.02277]]]} | Open Access 1 | 49024 | Foresthill Leroy E. Botts Memorial Park | 33725 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | https://www.placer.ca.gov/6000/Foresthill-Leroy-E-Botts-Memorial-Park | Placer 35 | 15.352 | Foresthill Leroy E. Botts Memorial Park | 0 | Local Park 2 | 4 |
10043 | 10043 | 10042 | {"type": "Polygon", "coordinates": [[[-121.09452, 38.93839], [-121.09416, 38.93839], [-121.09416, 38.93785], [-121.09452, 38.93839], [-121.09452, 38.93839]]]} | Open Access 1 | 49023 | Auburn Plaza Park | 33724 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | https://www.placer.ca.gov/6005/Plaza-Park | Placer 35 | 0.231 | Auburn Plaza Park | 0 | Local Park 2 | 4 |
2689 | 2689 | 2688 | {"type": "Polygon", "coordinates": [[[-121.96932, 38.8863], [-121.9688, 38.88631], [-121.9688, 38.88594], [-121.96932, 38.88593], [-121.96932, 38.8863]]]} | Open Access 1 | 28059 | Dunnigan Park | 33723 | 332 | Yolo, County of 545 | County 3 | County Agency 3 | http://www.yolocounty.org/general-government/general-government-departments/parks | County 3 | 332 | Yolo, County of 538 | County 3 | County Agency 3 | Yolo 33 | 0.458 | Dunnigan Park | 0 | Local Park 2 | 4 | |
9402 | 9402 | 9401 | {"type": "Polygon", "coordinates": [[[-123.4405, 39.05938], [-123.44049, 39.05965], [-123.44041, 39.05975], [-123.44021, 39.05983], [-123.43997, 39.0601], [-123.43987, 39.06018], [-123.43962, 39.06044], [-123.4395, 39.06053], [-123.43949, 39.06058], [-123.4393, 39.06079], [-123.43906, 39.06087], [-123.43892, 39.06095], [-123.43876, 39.06095], [-123.43795, 39.06072], [-123.43766, 39.0607], [-123.4375, 39.06076], [-123.43727, 39.06098], [-123.43715, 39.06109], [-123.43686, 39.06123], [-123.43655, 39.06093], [-123.43605, 39.06052], [-123.43589, 39.0604], [-123.43528, 39.06002], [-123.43639, 39.05958], [-123.43805, 39.05866], [-123.4405, 39.05938]]]} | Open Access 1 | 49017 | Indian Creek County Park | 33715 | 352 | Mendocino, County of 620 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/ | County 3 | 352 | Mendocino, County of 609 | County 3 | County Agency 3 | https://www.mendocinocounty.org/government/cultural-services-agency/parks/indian-creek | Mendocino 24 | 17.437 | Indian Creek County Park | 1973 | Local Park 2 | 4 |
15380 | 15380 | 15379 | {"type": "Polygon", "coordinates": [[[-123.4074, 39.00408], [-123.40742, 39.00624], [-123.40739, 39.00777], [-123.40276, 39.00769], [-123.40285, 39.004], [-123.4074, 39.00408]]]} | Open Access 1 | 49011 | Faulkner Park | 33709 | 352 | Mendocino, County of 620 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/ | County 3 | 352 | Mendocino, County of 609 | County 3 | County Agency 3 | https://www.mendocinocounty.org/government/cultural-services-agency/parks/faulkner-park | Mendocino 24 | 40.36 | Faulkner Park | 1930 | Local Park 2 | 4 |
9247 | 9247 | 9246 | {"type": "Polygon", "coordinates": [[[-121.11612, 38.79796], [-121.116, 38.79929], [-121.11489, 38.79929], [-121.11488, 38.79914], [-121.11491, 38.79901], [-121.11497, 38.79887], [-121.11506, 38.79875], [-121.11524, 38.7986], [-121.11568, 38.79837], [-121.11582, 38.79828], [-121.11599, 38.79813], [-121.11612, 38.79796]]]} | Open Access 1 | 49009 | Sterling Pointe Park | 33705 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | Placer 35 | 2.222 | Sterling Pointe Park | 0 | Local Park 2 | 4 | |
4905 | 4905 | 4904 | {"type": "Polygon", "coordinates": [[[-118.93429, 34.23097], [-118.93156, 34.2316], [-118.93117, 34.23166], [-118.93075, 34.23168], [-118.93077, 34.2258], [-118.93428, 34.22579], [-118.93429, 34.23097]]]} | Open Access 1 | 49004 | Santa Rosa Valley Park | 33703 | 331 | Ventura, County of 202 | County 3 | County Agency 3 | http://www.ventura.org/general-services-agency/parks-department | County 3 | 331 | Ventura, County of 198 | County 3 | County Agency 3 | Ventura 8 | 49.627 | Santa Rosa Valley Park | 0 | Local Park 2 | 4 | |
4449 | 4449 | 4448 | {"type": "Polygon", "coordinates": [[[-121.17178, 38.78981], [-121.1705, 38.79009], [-121.17044, 38.79009], [-121.17038, 38.79007], [-121.17033, 38.79002], [-121.1699, 38.7888], [-121.17148, 38.78877], [-121.17178, 38.78981]]]} | Open Access 1 | 49000 | Franklin Community School Park | 33699 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | https://www.placer.ca.gov/6045/Franklin-Community-School-Park | Placer 35 | 4.349 | Franklin Community School Park | 0 | Local Park 2 | 4 |
6364 | 6364 | 6363 | {"type": "Polygon", "coordinates": [[[-120.91097, 37.55865], [-120.91094, 37.56187], [-120.91083, 37.56198], [-120.91056, 37.56195], [-120.9103, 37.56185], [-120.91004, 37.5617], [-120.91003, 37.56159], [-120.91014, 37.56136], [-120.9102, 37.56113], [-120.91018, 37.56085], [-120.91011, 37.56065], [-120.90964, 37.55999], [-120.90964, 37.55861], [-120.90972, 37.55856], [-120.91088, 37.55856], [-120.91097, 37.55865]]]} | Open Access 1 | 48893 | Bonita Ranch Park | 33610 | 329 | Stanislaus, County of 505 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | Stanislaus 2 | 8.735 | Bonita Ranch Park | 0 | Local Park 2 | 4 | |
4016 | 4016 | 4015 | {"type": "Polygon", "coordinates": [[[-117.16681, 34.26338], [-117.16664, 34.26378], [-117.16602, 34.26364], [-117.16582, 34.26364], [-117.16565, 34.26368], [-117.16544, 34.26397], [-117.1656, 34.26429], [-117.16547, 34.26476], [-117.16468, 34.26443], [-117.1646, 34.26442], [-117.16448, 34.26446], [-117.16438, 34.26446], [-117.16421, 34.26389], [-117.16432, 34.26385], [-117.16458, 34.26379], [-117.16488, 34.26381], [-117.16506, 34.26384], [-117.16535, 34.26381], [-117.16551, 34.26367], [-117.1656, 34.26353], [-117.16568, 34.26347], [-117.16605, 34.26342], [-117.16681, 34.26338]]]} | Open Access 1 | 48885 | MacKay Park | 33606 | 318 | San Bernardino, County of 368 | County 3 | County Agency 3 | http://cms.sbcounty.gov/parks/Home.aspx | County 3 | 318 | San Bernardino, County of 363 | County 3 | County Agency 3 | San Bernardino 22 | 3.154 | MacKay Park | 0 | Local Park 2 | 4 | |
6291 | 6291 | 6290 | {"type": "Polygon", "coordinates": [[[-121.24447, 38.2956], [-121.24433, 38.29571], [-121.24395, 38.2959], [-121.24332, 38.29626], [-121.24327, 38.29627], [-121.24321, 38.29625], [-121.24323, 38.29563], [-121.24327, 38.29546], [-121.24333, 38.29535], [-121.24343, 38.29529], [-121.24365, 38.29521], [-121.24382, 38.29521], [-121.24402, 38.29524], [-121.24425, 38.29534], [-121.24431, 38.29542], [-121.24444, 38.29556], [-121.24447, 38.2956]]]} | Open Access 1 | 48884 | Herald Park | 33605 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | https://regionalparks.saccounty.net/SpecialEventsReservations/Pages/HeraldPark.aspx | Sacramento 41 | 1.953 | Herald Park | 0 | Local Park 2 | 4 |
6290 | 6290 | 6289 | {"type": "Polygon", "coordinates": [[[-117.47088, 33.75654], [-117.47089, 33.75734], [-117.47087, 33.75752], [-117.47083, 33.75766], [-117.47078, 33.75779], [-117.47069, 33.75793], [-117.47059, 33.75805], [-117.47046, 33.75817], [-117.47029, 33.75828], [-117.47011, 33.75837], [-117.46993, 33.75843], [-117.46972, 33.75847], [-117.46952, 33.75849], [-117.46907, 33.75844], [-117.46903, 33.7584], [-117.469, 33.75799], [-117.46894, 33.75779], [-117.46891, 33.75762], [-117.46891, 33.75742], [-117.46893, 33.75725], [-117.46899, 33.75702], [-117.46946, 33.75622], [-117.47088, 33.75654]]]} | Open Access 1 | 48882 | Coral Canyon Park | 33603 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | https://rivcoccsd.org/new-page-2 | Riverside 10 | 9.031 | Coral Canyon Park | 0 | Local Park 2 | 4 |
6276 | 6276 | 6275 | {"type": "Polygon", "coordinates": [[[-117.51151, 33.77707], [-117.51138, 33.77733], [-117.51089, 33.77824], [-117.51044, 33.77898], [-117.50991, 33.77901], [-117.5099, 33.77885], [-117.50991, 33.77865], [-117.50988, 33.77857], [-117.50981, 33.7785], [-117.50971, 33.77848], [-117.50949, 33.77851], [-117.50935, 33.77852], [-117.50932, 33.77819], [-117.50853, 33.77823], [-117.51151, 33.77707]]]} | Open Access 1 | 48880 | Montecito Ranch Park | 33601 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 5.314 | Montecito Ranch Park | 0 | Local Park 2 | 4 | |
6266 | 6266 | 6265 | {"type": "Polygon", "coordinates": [[[-117.32215, 34.01575], [-117.32169, 34.01627], [-117.32155, 34.01645], [-117.32148, 34.01656], [-117.3214, 34.01675], [-117.32125, 34.01722], [-117.32099, 34.01872], [-117.32092, 34.01895], [-117.32079, 34.01927], [-117.32066, 34.01927], [-117.32063, 34.01926], [-117.32061, 34.01922], [-117.32022, 34.01922], [-117.32021, 34.01866], [-117.32021, 34.01575], [-117.32215, 34.01575]]]} | Open Access 1 | 48879 | Highgrove Community Park | 33600 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | https://rivcoccsd.org/new-page-2 | Riverside 10 | 9.518 | Highgrove Community Park | 0 | Local Park 2 | 4 |
431 | 431 | 430 | {"type": "Polygon", "coordinates": [[[-117.28428, 33.76243], [-117.28273, 33.76246], [-117.2827, 33.76182], [-117.28324, 33.76181], [-117.28324, 33.76162], [-117.28425, 33.76159], [-117.28428, 33.76243]]]} | Open Access 1 | 48878 | Goodhope Park | 33599 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 3.022 | Goodhope Park | 0 | Local Park 2 | 4 | |
4081 | 4081 | 4080 | {"type": "Polygon", "coordinates": [[[-117.12462, 33.54378], [-117.12448, 33.54508], [-117.12437, 33.54616], [-117.12388, 33.54512], [-117.12356, 33.54429], [-117.12362, 33.54435], [-117.12371, 33.54437], [-117.12389, 33.54459], [-117.12438, 33.54458], [-117.12447, 33.54378], [-117.12462, 33.54378]], [[-117.12427, 33.54564], [-117.12424, 33.54563], [-117.1242, 33.54564], [-117.12424, 33.54573], [-117.12426, 33.54572], [-117.12427, 33.54564]]]} | Open Access 1 | 48876 | Overlook Park | 33597 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 2.188 | Overlook Park | 0 | Local Park 2 | 4 | |
6259 | 6259 | 6258 | {"type": "Polygon", "coordinates": [[[-117.14043, 33.54708], [-117.14033, 33.54714], [-117.14015, 33.54747], [-117.14, 33.54759], [-117.1397, 33.54789], [-117.13919, 33.54827], [-117.13902, 33.54831], [-117.13885, 33.54827], [-117.13872, 33.54818], [-117.13868, 33.54811], [-117.13866, 33.54803], [-117.13865, 33.54803], [-117.13819, 33.54827], [-117.13775, 33.54854], [-117.1376, 33.54869], [-117.13734, 33.54913], [-117.13712, 33.54933], [-117.13684, 33.54927], [-117.13672, 33.54927], [-117.13643, 33.54949], [-117.13623, 33.54973], [-117.13611, 33.54969], [-117.13681, 33.54916], [-117.13676, 33.5491], [-117.13698, 33.54886], [-117.13707, 33.54872], [-117.13719, 33.54846], [-117.13729, 33.54833], [-117.13743, 33.54823], [-117.13791, 33.548], [-117.13812, 33.54786], [-117.13818, 33.54775], [-117.13821, 33.54764], [-117.1382, 33.54752], [-117.13815, 33.54746], [-117.13968, 33.54619], [-117.14015, 33.54657], [-117.13848, 33.54781], [-117.13848, 33.54782], [-117.13852, 33.54785], [-117.1402, 33.54661], [-117.14042, 33.54677], [-117.14043, 33.54708]]]} | Open Access 1 | 48875 | Guenther Willows Park | 33596 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 8.902 | Guenther Willows Park | 0 | Local Park 2 | 4 | |
14673 | 14673 | 14672 | {"type": "Polygon", "coordinates": [[[-117.12413, 33.54745], [-117.1241, 33.54807], [-117.12362, 33.54832], [-117.12356, 33.54832], [-117.1238, 33.54812], [-117.12375, 33.54797], [-117.1237, 33.54794], [-117.12368, 33.54781], [-117.12365, 33.54779], [-117.12366, 33.54745], [-117.12413, 33.54745]]]} | Open Access 1 | 48873 | Discovery Park | 33594 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 0.789 | Discovery Park | 0 | Local Park 2 | 4 | |
4206 | 4206 | 4205 | {"type": "Polygon", "coordinates": [[[-117.34495, 33.64111], [-117.34461, 33.64156], [-117.34354, 33.6409], [-117.34412, 33.64026], [-117.34444, 33.64045], [-117.34428, 33.64065], [-117.34495, 33.64111]]]} | Open Access 1 | 48872 | Perret Park | 33593 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 2.063 | Perret 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]);