units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
687 rows where AGNCY_TYP = 3 and DES_TP = 2 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, County of 83
- San Diego, County of 61
- Los Angeles - Department of Parks and Recreation, County of 40
- El Dorado, County of 40
- Santa Barbara, County of 39
- Orange, County of 39
- Kern, County of 36
- Santa Cruz, County of 32
- Stanislaus, County of 22
- San Luis Obispo, County of 20
- Placer, County of 19
- Riverside, County of 18
- San Joaquin, County of 18
- Monterey, County of 17
- Lake, County of 17
- Ventura, County of 15
- San Bernardino, County of 12
- Merced, County of 12
- Yolo, County of 12
- Fresno, County of 11
- Tulare, County of 10
- Humboldt, County of 10
- Sacramento, County of 6
- Tehama, County of 6
- Mendocino, County of 6
- Lassen, County of 6
- Mariposa, County of 5
- Mono, County of 5
- Imperial, County of 4
- Yuba, County of 4
- …
MNG_AG_TYP 6
ACCESS_TYP 4
DES_TP 1
- Local Park · 667 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14361 | 14361 | 14360 | {"type": "Polygon", "coordinates": [[[-118.06988, 33.99872], [-118.06952, 33.9999], [-118.06946, 33.99989], [-118.06895, 34.00172], [-118.06907, 33.9998], [-118.06853, 33.99908], [-118.06839, 33.99832], [-118.06841, 33.99817], [-118.06988, 33.99872]]]} | Open Access 1 | 44426 | Amigo Park | 32468 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 4.805 | Amigo Park | 0 | Local Park 2 | 4 | |
7691 | 7691 | 7690 | {"type": "Polygon", "coordinates": [[[-119.82469, 34.45032], [-119.82467, 34.45037], [-119.8243, 34.45031], [-119.82425, 34.45076], [-119.82391, 34.45073], [-119.8239, 34.45101], [-119.82372, 34.451], [-119.82373, 34.45072], [-119.82337, 34.45073], [-119.8231, 34.45076], [-119.8231, 34.45046], [-119.82295, 34.45043], [-119.82295, 34.45038], [-119.8231, 34.45033], [-119.8231, 34.45002], [-119.82389, 34.45001], [-119.8239, 34.44994], [-119.82433, 34.44998], [-119.82431, 34.45025], [-119.82469, 34.45032]]]} | Open Access 1 | 7682 | Andamar Park | 15472 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 2.445 | Andamar Park | 0 | Local Park 2 | 4 | |
8423 | 8423 | 8422 | {"type": "Polygon", "coordinates": [[[-121.96911, 36.99374], [-121.96911, 36.9956], [-121.96692, 36.99562], [-121.96309, 36.99562], [-121.96246, 36.9956], [-121.96244, 36.99562], [-121.95684, 36.99562], [-121.95676, 36.99559], [-121.95674, 36.99553], [-121.95703, 36.99446], [-121.95713, 36.99403], [-121.96285, 36.99402], [-121.96285, 36.99302], [-121.96101, 36.99209], [-121.9608, 36.99165], [-121.9608, 36.99137], [-121.96112, 36.99083], [-121.96101, 36.99058], [-121.96049, 36.99024], [-121.96035, 36.98998], [-121.96042, 36.9898], [-121.96029, 36.98928], [-121.96046, 36.98905], [-121.96139, 36.98912], [-121.9614, 36.98894], [-121.962, 36.98898], [-121.96253, 36.98888], [-121.96344, 36.98837], [-121.9639, 36.98815], [-121.96463, 36.98842], [-121.96478, 36.9936], [-121.96911, 36.99374]]]} | Open Access 1 | 13052 | Anna Jean Cummings Park | 15503 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 95.411 | Anna Jean Cummings Park | 0 | Local Park 2 | 4 | |
10265 | 10265 | 10264 | {"type": "Polygon", "coordinates": [[[-118.20365, 34.7434], [-118.20188, 34.74388], [-118.19751, 34.74446], [-118.19744, 34.74052], [-118.20145, 34.74049], [-118.20357, 34.74045], [-118.20356, 34.74107], [-118.20365, 34.7434]]]} | Open Access 1 | 17972 | Apollo Community Regional Park | 32457 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov | Los Angeles 6 | 54.281 | Apollo Community RP | 0 | Local Park 2 | 4 |
12418 | 12418 | 12417 | {"type": "Polygon", "coordinates": [[[-120.99014, 38.99939], [-120.99012, 39.00034], [-120.98886, 38.99995], [-120.98888, 38.99938], [-120.99014, 38.99939]]]} | Open Access 1 | 27024 | Applegate Park | 15541 | 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.294 | Applegate Park | 0 | Local Park 2 | 4 | |
8578 | 8578 | 8577 | {"type": "MultiPolygon", "coordinates": [[[[-121.9012, 36.97535], [-121.90104, 36.97554], [-121.9009, 36.97565], [-121.90022, 36.97565], [-121.9, 36.97562], [-121.89997, 36.97558], [-121.89973, 36.97546], [-121.89978, 36.97517], [-121.90053, 36.97515], [-121.90119, 36.97534], [-121.9012, 36.97535]]], [[[-121.90391, 36.97622], [-121.90364, 36.97625], [-121.90357, 36.9762], [-121.90345, 36.97617], [-121.90284, 36.97609], [-121.9025, 36.97598], [-121.90204, 36.97598], [-121.90206, 36.97594], [-121.90199, 36.97591], [-121.90206, 36.97533], [-121.90205, 36.97559], [-121.90211, 36.97585], [-121.90219, 36.97584], [-121.90231, 36.97592], [-121.90246, 36.97591], [-121.9026, 36.97592], [-121.90263, 36.97583], [-121.90276, 36.97582], [-121.9032, 36.97591], [-121.90382, 36.97612], [-121.90391, 36.97622]]], [[[-121.90494, 36.97742], [-121.90501, 36.97777], [-121.90491, 36.97835], [-121.90452, 36.97864], [-121.90473, 36.97891], [-121.90466, 36.97907], [-121.90448, 36.97926], [-121.90426, 36.97969], [-121.90428, 36.98012], [-121.90472, 36.9802], [-121.90476, 36.98033], [-121.90457, 36.98062], [-121.90442, 36.98093], [-121.90434, 36.98123], [-121.90412, 36.98134], [-121.90415, 36.98094], [-121.90432, 36.98034], [-121.9041, 36.98031], [-121.90404, 36.98008], [-121.90367, 36.97979], [-121.9036, 36.97965], [-121.90358, 36.97936], [-121.90366, 36.97924], [-121.90361, 36.979], [-121.90385, 36.97865], [-121.90359, 36.97852], [-121.90359, 36.97849], [-121.90346, 36.9784], [-121.90303, 36.97822], [-121.90278, 36.97807], [-121.90277, 36.97809], [-121.90296, 36.97834], [-121.90299, 36.97854], [-121.90288, 36.97856], [-121.90286, 36.97847], [-121.90276, 36.97827], [-121.90259, 36.97804], [-121.9025, 36.97783], [-121.9025, 36.97762], [-121.90257, 36.97739], [-121.90268, 36.97731], [-121.90277, 36.97721], [-121.90309, 36.97701], [-121.9038, 36.97673], [-121.90381, 36.97671], [-121.90375, 36.97664], [-121.90393, 36.97654], [-121.90398, 36.97662], [-121.90399, 36.97708], [-121.90452, 36.97704], [-121.90494, 36.97742]]]]} | Open Access 1 | 13614 | Aptos Village Park | 15547 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 14.362 | Aptos Village Park | 0 | Local Park 2 | 4 | |
14411 | 14411 | 14410 | {"type": "MultiPolygon", "coordinates": [[[[-118.0383, 34.1366], [-118.03704, 34.13795], [-118.03693, 34.1379], [-118.03673, 34.1381], [-118.03674, 34.13812], [-118.03683, 34.13817], [-118.03527, 34.13986], [-118.0351, 34.13987], [-118.03504, 34.13992], [-118.0316, 34.13997], [-118.03151, 34.13565], [-118.03198, 34.13576], [-118.03227, 34.13601], [-118.03259, 34.13624], [-118.03292, 34.13634], [-118.03343, 34.13635], [-118.03405, 34.13627], [-118.0349, 34.13614], [-118.03571, 34.13614], [-118.03624, 34.13619], [-118.03681, 34.13613], [-118.03775, 34.13635], [-118.0383, 34.1366]]], [[[-118.04112, 34.13356], [-118.04112, 34.13356], [-118.04099, 34.1337], [-118.04109, 34.13358], [-118.04112, 34.13356]]]]} | Open Access 1 | 44522 | Arcadia Community Regional Park | 15565 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 50.673 | Arcadia Community RP | 0 | Local Park 2 | 4 | |
8900 | 8900 | 8899 | {"type": "Polygon", "coordinates": [[[-119.87867, 34.42332], [-119.87847, 34.42368], [-119.87808, 34.42365], [-119.87803, 34.42368], [-119.87799, 34.42375], [-119.878, 34.42402], [-119.87795, 34.42403], [-119.87793, 34.42372], [-119.87812, 34.42327], [-119.87829, 34.42335], [-119.87847, 34.42349], [-119.87865, 34.42326], [-119.87867, 34.42332]]]} | Open Access 1 | 14564 | Armstrong Mini Park | 15594 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 0.463 | Armstrong MP | 0 | Local Park 2 | 4 | |
13926 | 13926 | 13925 | {"type": "Polygon", "coordinates": [[[-121.64339, 36.88847], [-121.64319, 36.88849], [-121.64313, 36.88847], [-121.6431, 36.88843], [-121.64306, 36.88816], [-121.64333, 36.88813], [-121.64339, 36.88847]]]} | Open Access 1 | 36553 | Aromas Community Park | 28587 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 0.23 | Aromas Community Park | 0 | Local Park 2 | 4 | |
9300 | 9300 | 9299 | {"type": "Polygon", "coordinates": [[[-119.74515, 34.40323], [-119.74476, 34.40436], [-119.74399, 34.40382], [-119.7439, 34.40379], [-119.74377, 34.4038], [-119.74365, 34.40385], [-119.74357, 34.40392], [-119.74349, 34.4035], [-119.74345, 34.40311], [-119.74339, 34.40313], [-119.74343, 34.40351], [-119.74352, 34.40399], [-119.74332, 34.40425], [-119.74318, 34.40435], [-119.74305, 34.40439], [-119.74231, 34.40436], [-119.74274, 34.40423], [-119.74327, 34.40268], [-119.74515, 34.40323]]]} | Open Access 1 | 15495 | Arroyo Burro Beach County Park | 15610 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 5.986 | Arroyo Burro Beach County Park | 0 | Local Park 2 | 4 | |
14293 | 14293 | 14292 | {"type": "Polygon", "coordinates": [[[-124.23254, 40.26773], [-124.2322, 40.26879], [-124.2322, 40.26882], [-124.23085, 40.26907], [-124.23083, 40.26963], [-124.22952, 40.26963], [-124.22932, 40.26935], [-124.22906, 40.2691], [-124.22878, 40.26892], [-124.22853, 40.2688], [-124.22824, 40.26872], [-124.22783, 40.26872], [-124.22766, 40.26887], [-124.22753, 40.26908], [-124.22742, 40.2694], [-124.22737, 40.26964], [-124.22653, 40.26964], [-124.22663, 40.26911], [-124.22669, 40.2689], [-124.22677, 40.26883], [-124.22695, 40.26874], [-124.22713, 40.26859], [-124.22729, 40.26842], [-124.22743, 40.26818], [-124.22764, 40.26797], [-124.22769, 40.2677], [-124.22769, 40.26741], [-124.22774, 40.26713], [-124.22776, 40.26676], [-124.22796, 40.2665], [-124.22833, 40.26628], [-124.22869, 40.2662], [-124.23016, 40.26621], [-124.23062, 40.26624], [-124.23162, 40.26643], [-124.23196, 40.26648], [-124.2323, 40.26669], [-124.23243, 40.2669], [-124.23252, 40.26726], [-124.23254, 40.26773]]]} | Open Access 1 | 44227 | Arthur W. Way Park | 15641 | 348 | Humboldt, County of 552 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | Humboldt 45 | 33.368 | Arthur W. Way Park | 0 | Local Park 2 | 4 | |
996 | 996 | 995 | {"type": "Polygon", "coordinates": [[[-118.28068, 33.91874], [-118.2806, 33.91875], [-118.2806, 33.91994], [-118.27843, 33.91994], [-118.27849, 33.9166], [-118.27855, 33.91656], [-118.2806, 33.91655], [-118.28067, 33.91661], [-118.28068, 33.91874]]]} | Open Access 1 | 6206 | Athens Park | 15666 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 18.724 | Athens Park | 0 | Local Park 2 | 4 | |
24 | 24 | 23 | {"type": "Polygon", "coordinates": [[[-118.15573, 34.02499], [-118.1555, 34.02576], [-118.15546, 34.0258], [-118.15538, 34.02582], [-118.15475, 34.02568], [-118.15469, 34.02564], [-118.15468, 34.02558], [-118.1549, 34.02485], [-118.15494, 34.02481], [-118.15501, 34.02479], [-118.15565, 34.02492], [-118.1557, 34.02495], [-118.15573, 34.02499]]]} | Open Access 1 | 62 | Atlantic Avenue Park | 15674 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 1.951 | Atlantic Avenue 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 |
14297 | 14297 | 14296 | {"type": "Polygon", "coordinates": [[[-122.64942, 38.96071], [-122.6494, 38.96072], [-122.64938, 38.96077], [-122.64933, 38.9608], [-122.6478, 38.96099], [-122.64748, 38.96099], [-122.64546, 38.96091], [-122.64543, 38.96088], [-122.64543, 38.96079], [-122.6454, 38.96078], [-122.64541, 38.95935], [-122.64913, 38.95936], [-122.64916, 38.95938], [-122.64919, 38.95955], [-122.64921, 38.95956], [-122.64942, 38.96071]]]} | Open Access 1 | 44232 | Austin Park | 15713 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 14.576 | Austin Park | 0 | Local Park 2 | 4 | |
13498 | 13498 | 13497 | {"type": "Polygon", "coordinates": [[[-117.99482, 34.0355], [-117.99427, 34.03605], [-117.99393, 34.03583], [-117.99375, 34.036], [-117.99242, 34.03508], [-117.99314, 34.03435], [-117.99482, 34.0355]]]} | Open Access 1 | 45698 | Avenue Park | 28597 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Avenue_Park | Los Angeles 6 | 4.957 | Avenue Park | 0 | Local Park 2 | 4 |
2313 | 2313 | 2312 | {"type": "Polygon", "coordinates": [[[-120.73725, 35.17986], [-120.73672, 35.18012], [-120.7367, 35.1801], [-120.73618, 35.18036], [-120.73607, 35.1802], [-120.73594, 35.18024], [-120.73585, 35.1803], [-120.73577, 35.18031], [-120.73612, 35.17952], [-120.73725, 35.17986]]]} | Open Access 1 | 16972 | Avila Park | 15732 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 1.514 | Avila Park | 0 | Local Park 2 | 4 | |
11926 | 11926 | 11925 | {"type": "Polygon", "coordinates": [[[-117.98939, 34.03587], [-117.98835, 34.03691], [-117.98681, 34.03585], [-117.98694, 34.0357], [-117.98631, 34.03527], [-117.98645, 34.03513], [-117.98709, 34.03556], [-117.98778, 34.03487], [-117.98818, 34.03514], [-117.9886, 34.03472], [-117.98924, 34.03517], [-117.98891, 34.03551], [-117.98916, 34.03568], [-117.98915, 34.0357], [-117.98939, 34.03587]]]} | Open Access 1 | 24531 | Avocado Heights Park | 32469 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 8.15 | Avocado Heights Park | 0 | Local Park 2 | 4 | |
6986 | 6986 | 6985 | {"type": "Polygon", "coordinates": [[[-119.42108, 36.77855], [-119.42081, 36.78005], [-119.41857, 36.78242], [-119.41777, 36.78378], [-119.41743, 36.78552], [-119.41756, 36.78608], [-119.41728, 36.7867], [-119.41689, 36.78775], [-119.4136, 36.79017], [-119.41289, 36.79018], [-119.41291, 36.78956], [-119.41265, 36.78957], [-119.41264, 36.78953], [-119.41163, 36.78953], [-119.41163, 36.79007], [-119.41169, 36.79008], [-119.41169, 36.7902], [-119.41163, 36.79021], [-119.41163, 36.79075], [-119.41051, 36.79098], [-119.40972, 36.79183], [-119.4092, 36.79286], [-119.40806, 36.79282], [-119.40253, 36.79276], [-119.4029, 36.79203], [-119.40398, 36.79025], [-119.40444, 36.79042], [-119.40455, 36.79042], [-119.40454, 36.79034], [-119.4045, 36.79033], [-119.40438, 36.79018], [-119.40409, 36.79007], [-119.40466, 36.78911], [-119.40589, 36.7856], [-119.40683, 36.7856], [-119.40682, 36.78531], [-119.40608, 36.7853], [-119.40697, 36.78457], [-119.40753, 36.78396], [-119.40776, 36.78365], [-119.4092, 36.78367], [-119.40889, 36.78446], [-119.40818, 36.78559], [-119.40818, 36.78561], [-119.41158, 36.78567], [-119.41163, 36.78947], [-119.41293, 36.78906], [-119.41329, 36.78548], [-119.41363, 36.78401], [-119.41156, 36.78247], [-119.41151, 36.78205], [-119.41573, 36.78208], [-119.41818, 36.77991], [-119.41917, 36.78014], [-119.42026, 36.77852], [-119.42108, 36.77855]]]} | Open Access 1 | 5909 | Avocado Lake Park | 3936 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51947 | Fresno 9 | 225.777 | Avocado Lake Park | 0 | Local Park 2 | 4 |
3771 | 3771 | 3770 | {"type": "Polygon", "coordinates": [[[-117.40597, 34.07031], [-117.40479, 34.07031], [-117.40478, 34.06832], [-117.40534, 34.06832], [-117.40596, 34.06828], [-117.40597, 34.07031]]]} | Open Access 1 | 475 | Ayala Park | 15735 | 318 | San Bernardino, County of 368 | County 3 | County Agency 3 | http://cms.sbcounty.gov/parks/Home.aspx | County 3 | 2321 | Valley Center Water District 672 | Special District 4 | Water District 13 | San Bernardino 22 | 6.002 | Ayala 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]);