units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,524 rows where MNG_AG_TYP = 2 sorted by AGNCY_NAME descending
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 533
- Los Angeles, City of 491
- San Jose, City of 253
- San Francisco, City and County of 240
- Sacramento, City of 220
- Ventura, City of 151
- Long Beach, City of 148
- Roseville, City of 130
- Oakland, City of 122
- Irvine, City of 101
- Fresno, City of 95
- Modesto, City of 85
- Santa Rosa, City of 83
- Stockton, City of 81
- Napa, City of 81
- Huntington Beach, City of 76
- Torrance, City of 73
- Tracy, City of 73
- Santa Cruz, City of 72
- Chula Vista, City of 70
- Brentwood, City of 68
- Poway, City of 67
- San Luis Obispo, City of 66
- Newport Beach, City of 65
- Davis, City of 65
- Santa Barbara, City of 64
- Clovis, City of 62
- Glendale, City of 61
- Riverside, City of 61
- Bakersfield, City of 61
- …
DES_TP >30
- Local Park 7,486
- Local Recreation Area 1,440
- Local Other or Unknown 663
- Local Conservation Area 143
- Local Historic or Cultural Area 37
- Local Resource Management Area 6
- National Monument or Landmark 5
- None 1
- None 1
- National Forest 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 9,925
- Restricted Access 363
- No Public Access 207
- Unknown Access 29
MNG_AG_TYP 1
- City Agency · 10,524 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16909 | 16909 | 16908 | {"type": "Polygon", "coordinates": [[[-118.77815, 34.14346], [-118.77784, 34.14376], [-118.77784, 34.14381], [-118.77752, 34.14415], [-118.77741, 34.14423], [-118.77726, 34.14428], [-118.77716, 34.14429], [-118.77696, 34.14427], [-118.77668, 34.14417], [-118.77653, 34.1441], [-118.7765, 34.14407], [-118.77656, 34.14399], [-118.77656, 34.14391], [-118.7765, 34.14383], [-118.7764, 34.1438], [-118.77667, 34.14384], [-118.7767, 34.14377], [-118.77664, 34.14368], [-118.77673, 34.14333], [-118.77709, 34.14327], [-118.77735, 34.14256], [-118.77759, 34.14262], [-118.77779, 34.14302], [-118.77815, 34.14346]]]} | Open Access 1 | 46240 | Agoura Hills Recreation and Event Center | 29519 | 3364 | Joni and Friends 1181 | Non Profit 6 | Non Profit - Other 22 | http://www.joniandfriends.org/ | Non Governmental Organization 10 | 1000 | Agoura Hills, City of 316 | City 2 | City Agency 2 | http://www.ci.agoura-hills.ca.us/government/departments/community-services-parks-recreation/parks-facilities/agoura-hills-recreation-center | Los Angeles 6 | 3.899 | Agoura Hills Rec. and Event Ctr. | 0 | Local Recreation Area 3 | 4 |
16223 | 16223 | 16222 | {"type": "Polygon", "coordinates": [[[-117.02305, 32.58558], [-117.01876, 32.58555], [-117.01875, 32.58376], [-117.0148, 32.58373], [-117.01465, 32.58363], [-117.01447, 32.58354], [-117.01433, 32.57606], [-117.02242, 32.57628], [-117.0226, 32.57717], [-117.02239, 32.57718], [-117.02228, 32.57717], [-117.02221, 32.57699], [-117.02213, 32.57694], [-117.02176, 32.5769], [-117.02167, 32.57671], [-117.02153, 32.5766], [-117.02143, 32.57654], [-117.02118, 32.57659], [-117.02096, 32.57669], [-117.02085, 32.57684], [-117.02075, 32.57687], [-117.02063, 32.57685], [-117.02049, 32.57678], [-117.02041, 32.57685], [-117.02001, 32.57685], [-117.01955, 32.57696], [-117.01934, 32.57699], [-117.01923, 32.57693], [-117.01911, 32.57693], [-117.01877, 32.57699], [-117.01863, 32.57698], [-117.01838, 32.57678], [-117.01823, 32.57676], [-117.01815, 32.57677], [-117.01807, 32.57664], [-117.01786, 32.57655], [-117.01771, 32.57645], [-117.01764, 32.57652], [-117.01738, 32.57666], [-117.01729, 32.57688], [-117.01729, 32.57695], [-117.01734, 32.57704], [-117.01734, 32.57712], [-117.01724, 32.57724], [-117.01741, 32.57755], [-117.01742, 32.57766], [-117.01757, 32.57781], [-117.01759, 32.5779], [-117.01753, 32.57802], [-117.01754, 32.57808], [-117.01758, 32.57815], [-117.01753, 32.5783], [-117.01751, 32.57859], [-117.01752, 32.57881], [-117.01758, 32.579], [-117.01765, 32.57912], [-117.01759, 32.57929], [-117.0176, 32.57938], [-117.01768, 32.57961], [-117.01774, 32.57987], [-117.01776, 32.58027], [-117.01773, 32.58054], [-117.01774, 32.5806], [-117.01785, 32.58072], [-117.01788, 32.58097], [-117.01792, 32.58102], [-117.01836, 32.58133], [-117.01845, 32.58134], [-117.01871, 32.58129], [-117.01878, 32.58128], [-117.01886, 32.58129], [-117.01895, 32.58138], [-117.019, 32.58147], [-117.01903, 32.58159], [-117.01898, 32.58167], [-117.01891, 32.58169], [-117.01868, 32.58167], [-117.01861, 32.5817], [-117.01852, 32.58188], [-117.01845, 32.58196], [-117.0184, 32.58238], [-117.01849, 32.58265], [-117.01846, 32.58281], [-117.0184, 32.58286], [-117.01873, 32.58324], [-117.0189, 32.58348], [-117.01924, 32.58413], [-117.01932, 32.58433], [-117.01953, 32.58434], [-117.01997, 32.58424], [-117.02013, 32.58427], [-117.02021, 32.58425], [-117.02029, 32.58418], [-117.02055, 32.58382], [-117.02049, 32.58355], [-117.02039, 32.58323], [-117.02075, 32.58311], [-117.02081, 32.58306], [-117.02092, 32.58288], [-117.02094, 32.58281], [-117.02117, 32.58292], [-117.02149, 32.58274], [-117.0214, 32.58198], [-117.0211, 32.58161], [-117.02126, 32.58163], [-117.02136, 32.58158], [-117.02176, 32.58159], [-117.02191, 32.58155], [-117.0221, 32.58145], [-117.02217, 32.58145], [-117.02223, 32.58147], [-117.02224, 32.58151], [-117.0222, 32.58163], [-117.02222, 32.58164], [-117.02267, 32.5816], [-117.023, 32.58154], [-117.02305, 32.58379], [-117.02305, 32.58558]]]} | Open Access 1 | 44861 | Hidden Trails Open Space | 31665 | 6075 | Western Pacific Housing 1167 | Private 7 | Commercial 20 | Private 14 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 106.609 | Hidden Trails OS | 0 | Local Recreation Area 3 | 4 | ||
15695 | 15695 | 15694 | {"type": "Polygon", "coordinates": [[[-114.6039, 34.84393], [-114.60287, 34.84392], [-114.60287, 34.84339], [-114.6039, 34.84339], [-114.6039, 34.84393]]]} | Restricted Access 2 | 49074 | River's Edge Golf Course | 33774 | 2442 | Needles Unified School District 1161 | Special District 4 | School District 14 | https://www.needlesusd.org/ | Special District 4 | 1220 | Needles, City of 276 | City 2 | City Agency 2 | http://cityofneedles.com/services/rivers-edge-golf-course/ | San Bernardino 22 | 1.368 | River's Edge GC | 0 | Local Recreation Area 3 | 4 |
15396 | 15396 | 15395 | {"type": "Polygon", "coordinates": [[[-117.27642, 33.10482], [-117.27601, 33.10477], [-117.2759, 33.10472], [-117.27538, 33.10439], [-117.27531, 33.10432], [-117.27516, 33.104], [-117.27491, 33.10395], [-117.27475, 33.10394], [-117.27475, 33.10338], [-117.27481, 33.10333], [-117.27618, 33.1033], [-117.27625, 33.1034], [-117.27624, 33.10399], [-117.27633, 33.10406], [-117.27642, 33.10482]]]} | Restricted Access 2 | 46650 | Aviara Oaks Middle School Park | 31948 | 2399 | Carlsbad Unified School District 1157 | Special District 4 | School District 14 | http://www.carlsbadusd.k12.ca.us/ | Special District 4 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 4.374 | Aviara Oaks Middle School Park | 0 | Local Park 2 | 4 | |
15418 | 15418 | 15417 | {"type": "Polygon", "coordinates": [[[-117.33206, 33.16323], [-117.33174, 33.16369], [-117.33078, 33.16284], [-117.33123, 33.16249], [-117.33206, 33.16323]]]} | Restricted Access 2 | 46651 | Carlsbad High School Tennis Courts | 32247 | 2399 | Carlsbad Unified School District 1157 | Special District 4 | School District 14 | http://www.carlsbadusd.k12.ca.us/ | Special District 4 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 1.727 | Carlsbad High School Tennis Courts | 0 | Local Recreation Area 3 | 4 | |
15420 | 15420 | 15419 | {"type": "Polygon", "coordinates": [[[-117.2429, 33.08001], [-117.24288, 33.08032], [-117.24286, 33.08034], [-117.24286, 33.08075], [-117.24204, 33.08076], [-117.24201, 33.07859], [-117.24207, 33.07859], [-117.24218, 33.07904], [-117.24283, 33.07906], [-117.24279, 33.07988], [-117.2429, 33.08001]]]} | Restricted Access 2 | 46658 | Levante School Park | 29992 | 2399 | Carlsbad Unified School District 1157 | Special District 4 | School District 14 | http://www.carlsbadusd.k12.ca.us/ | Special District 4 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 3.673 | Levante School Park | 0 | Local Park 2 | 4 | |
15358 | 15358 | 15357 | {"type": "Polygon", "coordinates": [[[-118.08395, 34.01292], [-118.0835, 34.01349], [-118.08385, 34.01371], [-118.08368, 34.0139], [-118.08365, 34.01392], [-118.08362, 34.01391], [-118.08245, 34.01323], [-118.08312, 34.01244], [-118.08395, 34.01292]]]} | Restricted Access 2 | 46547 | Pio Pico Playground | 31638 | 2369 | El Rancho Unified School District 1156 | Special District 4 | School District 14 | http://www.erusd.org/ | Special District 4 | 1250 | Pico Rivera, City of 367 | City 2 | City Agency 2 | Los Angeles 6 | 2.817 | Pio Pico Playground | 0 | Local Recreation Area 3 | 4 | |
15342 | 15342 | 15341 | {"type": "Polygon", "coordinates": [[[-118.15776, 33.90102], [-118.15612, 33.90103], [-118.15579, 33.90087], [-118.15578, 33.89949], [-118.15753, 33.8995], [-118.15754, 33.89955], [-118.15769, 33.89956], [-118.15768, 33.89972], [-118.15775, 33.89973], [-118.15776, 33.90102]]]} | Restricted Access 2 | 46525 | Paramount Park | 29813 | 2397 | Paramount Unified School District 1155 | Special District 4 | School District 14 | http://www.paramount.k12.ca.us/ | Special District 4 | 1245 | Paramount, City of 281 | City 2 | City Agency 2 | Los Angeles 6 | 7.536 | Paramount Park | 0 | Local Park 2 | 4 | |
15330 | 15330 | 15329 | {"type": "Polygon", "coordinates": [[[-118.2036, 34.20436], [-118.2036, 34.20462], [-118.20323, 34.20462], [-118.20323, 34.20436], [-118.2036, 34.20436]]]} | Restricted Access 2 | 46505 | Skate Park | 31585 | 2395 | La Canada Unified School District 1154 | Special District 4 | School District 14 | http://lcusd.net/site/default.aspx?PageID=1 | Special District 4 | 1154 | La Canada Flintridge, City of 330 | City 2 | City Agency 2 | http://www.lcf.ca.gov/parks/skate | Los Angeles 6 | 0.246 | Skate Park | 0 | Local Recreation Area 3 | 4 |
15325 | 15325 | 15324 | {"type": "Polygon", "coordinates": [[[-117.85818, 34.19361], [-117.85655, 34.19631], [-117.85599, 34.19646], [-117.85577, 34.1973], [-117.85578, 34.19593], [-117.85608, 34.19586], [-117.85744, 34.1936], [-117.85818, 34.19361]]]} | No Public Access 3 | 48970 | Unnamed Site - Pasadena Department of Water and Power | 33667 | 1720 | Pasadena Department of Water and Power 1153 | City 2 | City Agency 2 | https://ww5.cityofpasadena.net/water-and-power/ | City 2 | 1720 | Pasadena Department of Water and Power 1099 | City 2 | City Agency 2 | Los Angeles 6 | 5.621 | 0 | Local Other or Unknown 14 | 4 | ||
15319 | 15319 | 15318 | {"type": "Polygon", "coordinates": [[[-117.99491, 34.13454], [-117.99491, 34.13492], [-117.99485, 34.13497], [-117.99432, 34.13496], [-117.99491, 34.13454]]]} | Open Access 1 | 46482 | Evergreen Plaza Park | 29759 | 2394 | Metro Gold Line Foothill Extension Construction Authority 1152 | Special District 4 | Transportation Agency 32 | http://www.foothillgoldline.org/about-us/construction-authority/ | Special District 4 | 1209 | Monrovia, City of 309 | City 2 | City Agency 2 | Los Angeles 6 | 0.318 | Evergreen Plaza Park | 2015 | Local Park 2 | 4 | |
15305 | 15305 | 15304 | {"type": "Polygon", "coordinates": [[[-118.10762, 34.09685], [-118.10762, 34.09685], [-118.10657, 34.09656], [-118.10761, 34.09622], [-118.10765, 34.09626], [-118.10762, 34.09685]]]} | Open Access 1 | 46474 | Plaza Park | 29747 | 3358 | Archdiocese of Los Angeles 1151 | Non Profit 6 | Non Profit - Other 22 | http://www.la-archdiocese.org/Pages/default.aspx | Non Governmental Organization 10 | 1301 | San Gabriel, City of 725 | City 2 | City Agency 2 | Los Angeles 6 | 0.869 | Plaza Park | 0 | Local Park 2 | 4 | |
15299 | 15299 | 15298 | {"type": "Polygon", "coordinates": [[[-117.97481, 34.14373], [-117.9748, 34.14592], [-117.97453, 34.14593], [-117.97453, 34.14687], [-117.9745, 34.14687], [-117.9745, 34.1459], [-117.97473, 34.14589], [-117.97476, 34.14586], [-117.97476, 34.14373], [-117.97481, 34.14373]]]} | Open Access 1 | 46437 | Lemon Trail | 29710 | 1712 | Bradbury, City of 1150 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | Los Angeles 6 | 0.341 | Lemon Trail | 0 | Local Recreation Area 3 | 4 | |
15300 | 15300 | 15299 | {"type": "Polygon", "coordinates": [[[-117.96999, 34.14575], [-117.9696, 34.14575], [-117.96915, 34.14556], [-117.96899, 34.14555], [-117.96898, 34.14547], [-117.96986, 34.1455], [-117.96996, 34.14548], [-117.96999, 34.14575]]]} | Open Access 1 | 46439 | Civic Center Park | 32522 | 1712 | Bradbury, City of 1150 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | Los Angeles 6 | 0.468 | Civic Ctr. Park | 0 | Local Park 2 | 4 | |
15301 | 15301 | 15300 | {"type": "Polygon", "coordinates": [[[-117.97472, 34.14357], [-117.97464, 34.14362], [-117.96441, 34.1437], [-117.96441, 34.14354], [-117.97458, 34.14347], [-117.97472, 34.14357]]]} | Open Access 1 | 46438 | Royal Oaks Trail North | 29711 | 1712 | Bradbury, City of 1150 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | Los Angeles 6 | 4.034 | Royal Oaks Trail North | None 1352 | |||
15260 | 15260 | 15259 | {"type": "MultiPolygon", "coordinates": [[[[-118.41144, 34.06053], [-118.41139, 34.0606], [-118.41083, 34.06087], [-118.41086, 34.06092], [-118.41072, 34.06099], [-118.41068, 34.06094], [-118.40952, 34.06146], [-118.40927, 34.06126], [-118.40916, 34.06114], [-118.40908, 34.061], [-118.40903, 34.06085], [-118.40902, 34.0607], [-118.40902, 34.06015], [-118.40961, 34.05987], [-118.40985, 34.05982], [-118.40998, 34.05983], [-118.41003, 34.05986], [-118.4101, 34.05989], [-118.41017, 34.05998], [-118.41025, 34.05995], [-118.4103, 34.06003], [-118.41097, 34.05971], [-118.4114, 34.06031], [-118.41144, 34.06044], [-118.41144, 34.06053]]], [[[-118.41243, 34.06254], [-118.41205, 34.06271], [-118.41213, 34.06284], [-118.41212, 34.06285], [-118.41172, 34.06272], [-118.41123, 34.06236], [-118.411, 34.06223], [-118.41066, 34.0618], [-118.41142, 34.06141], [-118.41159, 34.06162], [-118.41191, 34.06147], [-118.41232, 34.06203], [-118.41217, 34.06212], [-118.41226, 34.06224], [-118.41224, 34.06227], [-118.41243, 34.06254]]]]} | Restricted Access 2 | 46326 | Beverly Hills High School Park | 31849 | 2366 | Beverly Hills Unified School District 1146 | Special District 4 | School District 14 | http://www.bhusd.org/ | Special District 4 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 10.447 | Beverly Hills High School Park | 0 | Local Park 2 | 4 | |
15263 | 15263 | 15262 | {"type": "Polygon", "coordinates": [[[-118.38356, 34.06628], [-118.38312, 34.0663], [-118.3831, 34.06602], [-118.38268, 34.06603], [-118.38267, 34.06594], [-118.38262, 34.06594], [-118.3826, 34.06506], [-118.38346, 34.06506], [-118.38351, 34.06508], [-118.38356, 34.06628]]]} | Restricted Access 2 | 46327 | Horace Mann Elementary School Park | 31881 | 2366 | Beverly Hills Unified School District 1146 | Special District 4 | School District 14 | http://www.bhusd.org/ | Special District 4 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 2.532 | Horace Mann Elementary School Park | 0 | Local Park 2 | 4 | |
15264 | 15264 | 15263 | {"type": "Polygon", "coordinates": [[[-118.39479, 34.06229], [-118.39479, 34.06361], [-118.39394, 34.06362], [-118.39394, 34.06229], [-118.39479, 34.06229]]]} | Restricted Access 2 | 46328 | Beverly Vista Elementary School Park | 31882 | 2366 | Beverly Hills Unified School District 1146 | Special District 4 | School District 14 | http://www.bhusd.org/ | Special District 4 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 2.838 | Beverly Vista Elementary School Park | 0 | Local Park 2 | 4 | |
15265 | 15265 | 15264 | {"type": "MultiPolygon", "coordinates": [[[[-118.40382, 34.07823], [-118.40328, 34.0785], [-118.40298, 34.07798], [-118.40351, 34.07775], [-118.40382, 34.07823]]], [[[-118.40519, 34.07988], [-118.404, 34.08055], [-118.40365, 34.08016], [-118.40422, 34.07986], [-118.40483, 34.07951], [-118.40519, 34.07988]]]]} | Restricted Access 2 | 46329 | Hawthorne Elementary School Park | 31883 | 2366 | Beverly Hills Unified School District 1146 | Special District 4 | School District 14 | http://www.bhusd.org/ | Special District 4 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 2.583 | Hawthorne Elementary School Park | 0 | Local Park 2 | 4 | |
15266 | 15266 | 15265 | {"type": "Polygon", "coordinates": [[[-118.41726, 34.06839], [-118.41627, 34.06893], [-118.41611, 34.06874], [-118.41596, 34.06861], [-118.41582, 34.06852], [-118.41542, 34.06833], [-118.41525, 34.0682], [-118.41505, 34.068], [-118.41489, 34.06775], [-118.41483, 34.06759], [-118.41478, 34.06733], [-118.41477, 34.06722], [-118.41588, 34.06722], [-118.41602, 34.06756], [-118.41573, 34.06766], [-118.41586, 34.06795], [-118.41595, 34.06793], [-118.416, 34.06794], [-118.41609, 34.06801], [-118.41588, 34.0681], [-118.41597, 34.06833], [-118.41609, 34.0683], [-118.41627, 34.0687], [-118.41651, 34.06863], [-118.41669, 34.06851], [-118.41654, 34.06811], [-118.41696, 34.06797], [-118.41726, 34.06839]]]} | Restricted Access 2 | 46330 | El Rodeo Elementary School Park | 31884 | 2366 | Beverly Hills Unified School District 1146 | Special District 4 | School District 14 | http://www.bhusd.org/ | Special District 4 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 3.998 | El Rodeo Elementary School 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]);