units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,989 rows where DES_TP = 3 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, LAYER, MNG_AG_LEV
MNG_AGENCY >30
- San Diego, City of 211
- Los Angeles, City of 116
- San Francisco, City and County of 80
- Mountains Recreation and Conservation Authority 58
- Los Angeles, County of 31
- Conejo Open Space Conservation Agency 29
- East Bay Regional Park District 28
- Las Virgenes Municipal Water District 28
- San Luis Obispo, City of 26
- Long Beach, City of 25
- Glendale, City of 24
- Davis, City of 23
- Santa Barbara, County of 19
- Santa Clarita, City of 18
- Sacramento, City of 18
- San Jose, City of 17
- Vacaville, City of 17
- Oakland, City of 16
- Thousand Oaks, City of 16
- Fullerton, City of 15
- Los Angeles - Department of Parks and Recreation, County of 15
- Santa Cruz, City of 14
- Conejo Recreation and Park District 14
- San Bernardino, City of 14
- San Marcos, City of 14
- East Bay Municipal Utility District 13
- Tiburon, Town of 13
- Carlsbad, City of 12
- Poway, City of 12
- Sunrise Recreation and Park District 12
- …
MNG_AG_TYP 17
- City Agency 1,440
- Recreation/Parks District 164
- County Agency 117
- Open Space District 88
- Water District 69
- County Agency - Parks 37
- Irrigation District 23
- Community Services District 14
- Flood District 12
- Port/Harbor District 5
- School District 5
- County Agency - Other 4
- Special District - Other 4
- Sanitation District 3
- Cemetery District 2
- Conservation District 1
- Transportation Agency 1
ACCESS_TYP 4
- Open Access 1,640
- Restricted Access 220
- No Public Access 113
- Unknown Access 16
DES_TP 1
- Local Recreation Area · 1,989 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6712 | 6712 | 6711 | {"type": "Polygon", "coordinates": [[[-124.20362, 41.75891], [-124.20165, 41.7589], [-124.20165, 41.75859], [-124.20151, 41.75858], [-124.20151, 41.75823], [-124.20236, 41.75823], [-124.20182, 41.75767], [-124.20212, 41.75756], [-124.20212, 41.75755], [-124.20205, 41.75746], [-124.2025, 41.7572], [-124.20347, 41.75822], [-124.20349, 41.75824], [-124.20362, 41.75824], [-124.20362, 41.75891]]]} | Open Access 1 | 48412 | Pyke Field | 32981 | 347 | Del Norte County Parks, County of 672 | County 3 | County Agency - Parks 7 | http://www.dnco.org/ | County 3 | 347 | Del Norte County Parks, County of 661 | County 3 | County Agency - Parks 7 | Del Norte 50 | 5.186 | Pyke Field | 0 | Local Recreation Area 3 | 4 | |
4341 | 4341 | 4340 | {"type": "Polygon", "coordinates": [[[-124.20238, 41.75231], [-124.20192, 41.75256], [-124.20167, 41.7523], [-124.20213, 41.75206], [-124.20238, 41.75231]]]} | Open Access 1 | 48410 | Crescent City Skate Park | 32976 | 1427 | Crescent City, City of 749 | City 2 | City Agency 2 | http://www.crescentcity.org/ | City 2 | 1427 | Crescent City, City of 735 | City 2 | City Agency 2 | Del Norte 50 | 0.406 | Crescent City Skate Park | 0 | Local Recreation Area 3 | 4 | |
14354 | 14354 | 14353 | {"type": "Polygon", "coordinates": [[[-124.18682, 40.79059], [-124.18671, 40.79055], [-124.18664, 40.79056], [-124.18658, 40.79059], [-124.18654, 40.79065], [-124.18535, 40.79064], [-124.18537, 40.79058], [-124.18584, 40.79058], [-124.18586, 40.79003], [-124.1868, 40.79004], [-124.18682, 40.79059]]]} | Open Access 1 | 47015 | Del Norte Street Picnic Area | 30651 | 1419 | Eureka, City of 715 | City 2 | City Agency 2 | http://www.ci.eureka.ca.gov/depts/pnr/default.asp | City 2 | 1419 | Eureka, City of 698 | City 2 | City Agency 2 | Humboldt 45 | 1.378 | Del Norte Street Picnic Area | 0 | Local Recreation Area 3 | 4 | |
12069 | 12069 | 12068 | {"type": "Polygon", "coordinates": [[[-124.174, 40.78401], [-124.174, 40.78456], [-124.17298, 40.78455], [-124.17297, 40.78439], [-124.17198, 40.78439], [-124.17198, 40.78413], [-124.17249, 40.78413], [-124.1725, 40.78384], [-124.17297, 40.78384], [-124.17298, 40.78375], [-124.17379, 40.78376], [-124.17379, 40.784], [-124.174, 40.78401]]]} | Open Access 1 | 24769 | 20-30 Park and Playground | 15177 | 1419 | Eureka, City of 715 | City 2 | City Agency 2 | http://www.ci.eureka.ca.gov/depts/pnr/default.asp | City 2 | 1419 | Eureka, City of 698 | City 2 | City Agency 2 | Humboldt 45 | 2.7 | 20-30 Park and Playground | 0 | Local Recreation Area 3 | 4 | |
15717 | 15717 | 15716 | {"type": "Polygon", "coordinates": [[[-124.17331, 40.75172], [-124.17326, 40.75674], [-124.17267, 40.75675], [-124.17266, 40.7579], [-124.17325, 40.75835], [-124.17324, 40.75892], [-124.17209, 40.75892], [-124.17205, 40.76027], [-124.17127, 40.76027], [-124.17159, 40.76112], [-124.16968, 40.76111], [-124.1685, 40.76167], [-124.16946, 40.76364], [-124.16944, 40.76582], [-124.16925, 40.76559], [-124.16887, 40.76544], [-124.16855, 40.76528], [-124.16829, 40.76502], [-124.16822, 40.76453], [-124.16798, 40.764], [-124.16737, 40.76321], [-124.16702, 40.76273], [-124.16641, 40.76243], [-124.16475, 40.76231], [-124.16432, 40.76181], [-124.16548, 40.76078], [-124.1655, 40.76034], [-124.16627, 40.76005], [-124.16657, 40.75991], [-124.16768, 40.75926], [-124.16845, 40.75729], [-124.16943, 40.7565], [-124.16946, 40.75534], [-124.169, 40.75533], [-124.16901, 40.75473], [-124.1685, 40.75433], [-124.16853, 40.75169], [-124.16961, 40.7517], [-124.17004, 40.75223], [-124.17059, 40.75375], [-124.17132, 40.75336], [-124.17215, 40.75248], [-124.17233, 40.75171], [-124.17331, 40.75172]]]} | Restricted Access 2 | 47013 | Eureka Municipal Golf Course | 33119 | 1419 | Eureka, City of 715 | City 2 | City Agency 2 | http://www.ci.eureka.ca.gov/depts/pnr/default.asp | City 2 | 1419 | Eureka, City of 698 | City 2 | City Agency 2 | Humboldt 45 | 118.464 | Eureka Municipal GC | 0 | Local Recreation Area 3 | 4 | |
14352 | 14352 | 14351 | {"type": "Polygon", "coordinates": [[[-124.15928, 40.79354], [-124.15863, 40.79363], [-124.15865, 40.79265], [-124.15906, 40.79265], [-124.15928, 40.79354]]]} | Open Access 1 | 47012 | John Ryan Youth Center | 30646 | 1419 | Eureka, City of 715 | City 2 | City Agency 2 | http://www.ci.eureka.ca.gov/depts/pnr/default.asp | City 2 | 1419 | Eureka, City of 698 | City 2 | City Agency 2 | Humboldt 45 | 1.163 | John Ryan Youth Ctr. | 0 | Local Recreation Area 3 | 4 | |
4046 | 4046 | 4045 | {"type": "Polygon", "coordinates": [[[-124.15715, 40.8062], [-124.15676, 40.8063], [-124.1567, 40.80581], [-124.15684, 40.80579], [-124.15682, 40.80563], [-124.15701, 40.80564], [-124.15705, 40.8057], [-124.15695, 40.80574], [-124.15699, 40.80581], [-124.1569, 40.80584], [-124.15691, 40.80588], [-124.15681, 40.80592], [-124.15687, 40.80605], [-124.15711, 40.80612], [-124.15715, 40.8062]]]} | Open Access 1 | 47006 | Clara May Berry Park & Playground | 30640 | 1419 | Eureka, City of 715 | City 2 | City Agency 2 | http://www.ci.eureka.ca.gov/depts/pnr/default.asp | City 2 | 1419 | Eureka, City of 698 | City 2 | City Agency 2 | Humboldt 45 | 0.321 | Clara May Berry Park & Playground | 0 | Local Recreation Area 3 | 4 | |
5570 | 5570 | 5569 | {"type": "Polygon", "coordinates": [[[-124.14435, 40.77531], [-124.14434, 40.77623], [-124.14315, 40.77622], [-124.14316, 40.77549], [-124.14339, 40.7753], [-124.14435, 40.77531]]]} | Open Access 1 | 44165 | Hartman Ball Field | 19712 | 1419 | Eureka, City of 715 | City 2 | City Agency 2 | http://www.ci.eureka.ca.gov/depts/pnr/default.asp | City 2 | 1419 | Eureka, City of 698 | City 2 | City Agency 2 | Humboldt 45 | 2.468 | Hartman Ball Field | 0 | Local Recreation Area 3 | 4 | |
14203 | 14203 | 14202 | {"type": "Polygon", "coordinates": [[[-124.14339, 40.7753], [-124.14316, 40.77549], [-124.14219, 40.77549], [-124.1422, 40.77463], [-124.14338, 40.77464], [-124.14339, 40.7753]]]} | Open Access 1 | 44164 | Kennedy Ball Field | 20599 | 1419 | Eureka, City of 715 | City 2 | City Agency 2 | http://www.ci.eureka.ca.gov/depts/pnr/default.asp | City 2 | 1419 | Eureka, City of 698 | City 2 | City Agency 2 | Humboldt 45 | 2.307 | Kennedy Ball Field | 0 | Local Recreation Area 3 | 4 | |
3459 | 3459 | 3458 | {"type": "Polygon", "coordinates": [[[-124.10794, 40.50115], [-124.10684, 40.50146], [-124.10667, 40.50143], [-124.10657, 40.50108], [-124.10649, 40.50061], [-124.10638, 40.4999], [-124.10749, 40.49987], [-124.10765, 40.50033], [-124.10794, 40.50115]]]} | Open Access 1 | 25412 | Firemans Park and Picnic Area | 18912 | 1435 | Rio Dell, City of 642 | City 2 | City Agency 2 | http://www.riodellcity.com/ | City 2 | 1435 | Rio Dell, City of 632 | City 2 | City Agency 2 | Humboldt 45 | 4.191 | Firemans Park and Picnic Area | 0 | Local Recreation Area 3 | 4 | |
12200 | 12200 | 12199 | {"type": "Polygon", "coordinates": [[[-124.085, 40.86763], [-124.08467, 40.8685], [-124.08346, 40.86823], [-124.08341, 40.86778], [-124.08344, 40.86712], [-124.08346, 40.86703], [-124.08349, 40.86697], [-124.08355, 40.86692], [-124.08369, 40.86686], [-124.08378, 40.86684], [-124.08416, 40.86688], [-124.08404, 40.86725], [-124.08456, 40.86735], [-124.08463, 40.86739], [-124.08493, 40.86744], [-124.085, 40.86763]]]} | Open Access 1 | 25400 | Arcata Ball Park | 15568 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 4.152 | Arcata Ball Park | 0 | Local Recreation Area 3 | 4 | |
14370 | 14370 | 14369 | {"type": "Polygon", "coordinates": [[[-124.08449, 40.87943], [-124.0841, 40.87955], [-124.08362, 40.87974], [-124.08387, 40.87914], [-124.08395, 40.87899], [-124.08409, 40.87906], [-124.08449, 40.87943]]]} | Open Access 1 | 47026 | Arcata Skateboard Park | 30675 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 0.656 | Arcata Skateboard Park | 0 | Local Recreation Area 3 | 4 | |
3996 | 3996 | 3995 | {"type": "Polygon", "coordinates": [[[-124.06854, 40.86404], [-124.0684, 40.86405], [-124.06846, 40.86466], [-124.06734, 40.86467], [-124.06703, 40.86377], [-124.06672, 40.86309], [-124.06685, 40.86302], [-124.06697, 40.86297], [-124.06725, 40.86295], [-124.06737, 40.86291], [-124.06748, 40.86283], [-124.06753, 40.86276], [-124.06754, 40.86269], [-124.06804, 40.86252], [-124.06795, 40.8623], [-124.0683, 40.86229], [-124.06839, 40.86331], [-124.06844, 40.86361], [-124.06854, 40.86404]]]} | Unknown Access 4 | 46793 | Arcata Ridge Trail | 30248 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 6.431 | Arcata Ridge Trail | 0 | Local Recreation Area 3 | 4 | |
12588 | 12588 | 12587 | {"type": "Polygon", "coordinates": [[[-123.99351, 40.88039], [-123.99291, 40.88117], [-123.99172, 40.88062], [-123.99228, 40.87997], [-123.99351, 40.88039]]]} | Open Access 1 | 29310 | Gymkhana Field | 19579 | 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 | 2.642 | Gymkhana Field | 0 | Local Recreation Area 3 | 4 | |
14417 | 14417 | 14416 | {"type": "Polygon", "coordinates": [[[-123.9855, 40.88189], [-123.98541, 40.88195], [-123.98525, 40.88184], [-123.98534, 40.88177], [-123.9855, 40.88189]]]} | Open Access 1 | 47033 | City of Blue Lake Tot Lot | 30684 | 1443 | Blue Lake, City of 716 | City 2 | City Agency 2 | http://bluelake.ca.gov/ | City 2 | 1443 | Blue Lake, City of 699 | City 2 | City Agency 2 | Humboldt 45 | 0.047 | City of Blue Lake Tot Lot | 0 | Local Recreation Area 3 | 4 | |
11412 | 11412 | 11411 | {"type": "Polygon", "coordinates": [[[-123.69388, 38.91003], [-123.69342, 38.91022], [-123.69342, 38.91022], [-123.69342, 38.90992], [-123.69374, 38.90991], [-123.69388, 38.91003]]]} | Open Access 1 | 48101 | Fisherman's Playground | 32606 | 1697 | Point Arena, City of 781 | City 2 | City Agency 2 | http://www.cityofpointarena.com/ | City 2 | 1697 | Point Arena, City of 761 | City 2 | City Agency 2 | https://pointarena.ca.gov/government/departments/parks-streets/ | Mendocino 24 | 0.214 | Fisherman's Playground | 0 | Local Recreation Area 3 | 4 |
6814 | 6814 | 6813 | {"type": "Polygon", "coordinates": [[[-123.46324, 38.71823], [-123.46307, 38.71844], [-123.46268, 38.71853], [-123.462, 38.7182], [-123.46154, 38.718], [-123.46092, 38.71756], [-123.46035, 38.71794], [-123.46014, 38.71771], [-123.46062, 38.71733], [-123.46034, 38.71712], [-123.46072, 38.7168], [-123.4604, 38.71654], [-123.45998, 38.71683], [-123.45938, 38.71635], [-123.459, 38.71634], [-123.45842, 38.71686], [-123.45836, 38.71741], [-123.45924, 38.71795], [-123.45973, 38.71755], [-123.46009, 38.71788], [-123.45959, 38.71821], [-123.46124, 38.71936], [-123.46154, 38.71944], [-123.46112, 38.71959], [-123.45775, 38.71717], [-123.45965, 38.71544], [-123.45979, 38.71563], [-123.46029, 38.71609], [-123.46042, 38.71632], [-123.46077, 38.71656], [-123.46122, 38.71694], [-123.46083, 38.71715], [-123.46083, 38.71716], [-123.46142, 38.7175], [-123.46185, 38.7175], [-123.4625, 38.71806], [-123.46311, 38.71809], [-123.46324, 38.71823]]]} | Open Access 1 | 5386 | Sea Ranch Trail Access | 25235 | 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 | 10.372 | Sea Ranch Trail Access | 0 | Local Recreation Area 3 | 4 | |
15682 | 15682 | 15681 | {"type": "Polygon", "coordinates": [[[-123.38922, 39.4385], [-123.38888, 39.43888], [-123.38872, 39.43884], [-123.38836, 39.43885], [-123.38793, 39.43897], [-123.38765, 39.43907], [-123.38741, 39.43928], [-123.3873, 39.43956], [-123.38734, 39.43987], [-123.38754, 39.44014], [-123.3877, 39.44026], [-123.38802, 39.44001], [-123.38807, 39.44006], [-123.38775, 39.44032], [-123.38797, 39.44061], [-123.38759, 39.44096], [-123.38761, 39.44128], [-123.388, 39.44131], [-123.38802, 39.44139], [-123.38764, 39.44141], [-123.38763, 39.44142], [-123.38805, 39.44196], [-123.38808, 39.44209], [-123.38806, 39.44218], [-123.38809, 39.44229], [-123.38805, 39.44246], [-123.38806, 39.44262], [-123.38813, 39.44281], [-123.38816, 39.443], [-123.38838, 39.4434], [-123.38842, 39.44351], [-123.38827, 39.44357], [-123.38818, 39.44362], [-123.38805, 39.44375], [-123.38801, 39.44384], [-123.38798, 39.44392], [-123.38797, 39.44401], [-123.38799, 39.44409], [-123.38807, 39.44428], [-123.38809, 39.44438], [-123.38809, 39.44442], [-123.38806, 39.44446], [-123.38801, 39.44448], [-123.38793, 39.44447], [-123.38781, 39.44443], [-123.3876, 39.4443], [-123.38732, 39.44418], [-123.387, 39.44412], [-123.38674, 39.44413], [-123.38657, 39.44407], [-123.38611, 39.44381], [-123.38579, 39.44378], [-123.3855, 39.44386], [-123.38525, 39.44339], [-123.38602, 39.44232], [-123.38594, 39.44214], [-123.38582, 39.44212], [-123.38557, 39.4422], [-123.38542, 39.44243], [-123.38505, 39.44211], [-123.38493, 39.44192], [-123.38475, 39.44172], [-123.38457, 39.4416], [-123.38464, 39.44139], [-123.38474, 39.44121], [-123.38494, 39.44057], [-123.38514, 39.44025], [-123.38521, 39.44002], [-123.38521, 39.4397], [-123.38511, 39.43937], [-123.38498, 39.43905], [-123.3848, 39.43878], [-123.38465, 39.43848], [-123.3844, 39.43812], [-123.38446, 39.43793], [-123.38447, 39.43772], [-123.3842, 39.43699], [-123.38417, 39.43681], [-123.38423, 39.43652], [-123.3843, 39.43642], [-123.38476, 39.43627], [-123.38491, 39.43655], [-123.38532, 39.43638], [-123.3854, 39.43642], [-123.38569, 39.43623], [-123.38586, 39.43656], [-123.3856, 39.43664], [-123.38568, 39.43687], [-123.38579, 39.43704], [-123.38617, 39.43738], [-123.38637, 39.4375], [-123.3867, 39.43775], [-123.38694, 39.43788], [-123.38732, 39.43814], [-123.3875, 39.43829], [-123.38771, 39.43839], [-123.38824, 39.43852], [-123.38922, 39.4385]]]} | Restricted Access 2 | 48511 | Brooktrails Disc Golf Course | 33223 | 2208 | Brooktrails Community Services District 424 | Special District 4 | Community Services District 19 | http://www.btcsd.org/ | Special District 4 | 2208 | Brooktrails Community Services District 418 | Special District 4 | Community Services District 17 | Mendocino 24 | 47.2 | Brooktrails Disc GC | 0 | Local Recreation Area 3 | 4 | |
16645 | 16645 | 16644 | {"type": "Polygon", "coordinates": [[[-123.3547, 39.40371], [-123.35279, 39.4039], [-123.35274, 39.40339], [-123.35458, 39.40316], [-123.3547, 39.40371]]]} | Open Access 1 | 24767 | Recreation Grove Park | 24214 | 1414 | Willits, City of 578 | City 2 | City Agency 2 | http://thecityofwillits.com/ | City 2 | 1414 | Willits, City of 570 | City 2 | City Agency 2 | Mendocino 24 | 2.396 | Rec. Grove Park | 0 | Local Recreation Area 3 | 4 | |
16634 | 16634 | 16633 | {"type": "Polygon", "coordinates": [[[-123.34684, 39.41037], [-123.34686, 39.41121], [-123.34678, 39.41256], [-123.34499, 39.41259], [-123.34487, 39.4126], [-123.34315, 39.41263], [-123.33993, 39.41271], [-123.34008, 39.41228], [-123.34024, 39.41212], [-123.34031, 39.41196], [-123.34043, 39.41173], [-123.34068, 39.41103], [-123.34075, 39.41079], [-123.34109, 39.41031], [-123.34122, 39.41007], [-123.34143, 39.40964], [-123.3433, 39.40961], [-123.34332, 39.40999], [-123.34333, 39.41], [-123.3441, 39.40997], [-123.34411, 39.40959], [-123.34629, 39.40955], [-123.34634, 39.41037], [-123.34684, 39.41037]]]} | Open Access 1 | 24552 | Recreation Grove | 24213 | 1414 | Willits, City of 578 | City 2 | City Agency 2 | http://thecityofwillits.com/ | City 2 | 1414 | Willits, City of 570 | City 2 | City Agency 2 | Mendocino 24 | 42.421 | Rec. Grove | 0 | Local Recreation Area 3 | 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]);