units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,394 rows where AGNCY_LEV = 2 sorted by AGNCY_ID descending
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 525
- Los Angeles, City of 485
- San Jose, City of 253
- San Francisco, City and County of 238
- Sacramento, City of 220
- Ventura, City of 151
- Long Beach, City of 144
- Roseville, City of 130
- Oakland, City of 122
- Irvine, City of 98
- Fresno, City of 90
- Modesto, City of 85
- Santa Rosa, City of 82
- Stockton, City of 81
- Napa, City of 81
- Huntington Beach, City of 76
- Tracy, City of 73
- Santa Cruz, City of 72
- Torrance, City of 72
- Chula Vista, City of 70
- Brentwood, City of 68
- Poway, City of 67
- Davis, City of 65
- San Luis Obispo, City of 64
- Santa Barbara, City of 64
- Newport Beach, City of 64
- Glendale, City of 61
- Bakersfield, City of 61
- Manteca, City of 61
- Riverside, City of 60
- …
DES_TP >30
- Local Park 7,352
- Local Recreation Area 1,414
- Local Other or Unknown 661
- Local Conservation Area 149
- Local Historic or Cultural Area 38
- Local Resource Management Area 6
- National Monument or Landmark 5
- State Conservation Area 2
- 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
- …
MNG_AG_TYP 14
- City Agency 10,292
- Open Space District 21
- Recreation/Parks District 19
- County Agency 16
- Non Profit - Other 11
- Commercial 9
- Non Profit - Conservation 7
- State Agency 5
- County Agency - Parks 4
- Other 3
- County Agency - Other 2
- Non Profit - Land Trust 2
- Port/Harbor District 2
- Community Services District 1
ACCESS_TYP 4
- Open Access 9,898
- Restricted Access 260
- No Public Access 207
- Unknown Access 29
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5576 | 5576 | 5575 | {"type": "Polygon", "coordinates": [[[-115.38799, 32.80773], [-115.38799, 32.80773], [-115.38527, 32.80861], [-115.38529, 32.80805], [-115.38575, 32.80776], [-115.38593, 32.80758], [-115.38606, 32.80752], [-115.38613, 32.80752], [-115.38626, 32.80747], [-115.38633, 32.80732], [-115.38658, 32.80735], [-115.38676, 32.80729], [-115.38696, 32.80727], [-115.3875, 32.80728], [-115.38775, 32.80735], [-115.38787, 32.80744], [-115.38799, 32.80773]]]} | Open Access 1 | 48782 | Earl Walker Park | 33508 | 2436 | Holtville Community Redevelopment Agency 810 | City 2 | City Agency 2 | City 2 | 1139 | Holtville, City of 209 | City 2 | City Agency 2 | http://www.holtville.ca.gov/section.php?id=61 | Imperial 20 | 4.792 | Earl Walker Park | 0 | Local Park 2 | 4 | |
5575 | 5575 | 5574 | {"type": "Polygon", "coordinates": [[[-122.36754, 37.72678], [-122.36734, 37.727], [-122.36723, 37.72694], [-122.36712, 37.72698], [-122.36703, 37.72705], [-122.36698, 37.72714], [-122.36697, 37.72723], [-122.36708, 37.7273], [-122.36688, 37.72752], [-122.36589, 37.72698], [-122.36647, 37.72634], [-122.36666, 37.72629], [-122.36754, 37.72678]]]} | Open Access 1 | 48781 | Hillpoint Park | 33507 | 2290 | San Francisco, City and County of, Redevelopment Agency 809 | City 2 | City Agency 2 | http://www.sfredevelopment.org/index.aspx?page=104 | City 2 | 2290 | San Francisco, City and County of, Redevelopment Agency 788 | City 2 | City Agency 2 | https://www.cmgsite.com/project/hunters-point-parks-hillside-central-park-hillpoint-park-and-innes-court-park/ | San Francisco 13 | 2.47 | Hillpoint Park | 2003 | Local Park 2 | 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 | ||
4238 | 4238 | 4237 | {"type": "Polygon", "coordinates": [[[-122.38933, 37.7711], [-122.38673, 37.77126], [-122.38667, 37.77089], [-122.38929, 37.77073], [-122.38933, 37.7711]]]} | Open Access 1 | 47889 | Mission Bay Commons | 31834 | 1719 | San Francisco - Office of Community Investment and Infrastructure, City and County of 737 | City 2 | City Agency 2 | https://sfocii.org/ | City 2 | 6121 | MJM Management Group 721 | Private 7 | Commercial 18 | https://missionbayparks.com/mission-bay-commons/ | San Francisco 13 | 2.353 | Mission Bay Commons | None 369 | ||
9772 | 9772 | 9771 | {"type": "MultiPolygon", "coordinates": [[[[-122.39652, 37.77142], [-122.39227, 37.77478], [-122.39203, 37.77458], [-122.39628, 37.77123], [-122.39652, 37.77142]]], [[[-122.39537, 37.77404], [-122.39525, 37.77413], [-122.39481, 37.77378], [-122.39299, 37.77522], [-122.39294, 37.77518], [-122.39286, 37.77525], [-122.39276, 37.77517], [-122.39479, 37.77357], [-122.39537, 37.77404]]], [[[-122.39716, 37.77193], [-122.39526, 37.77343], [-122.39526, 37.77344], [-122.3957, 37.77379], [-122.39558, 37.77388], [-122.39499, 37.77341], [-122.39701, 37.77181], [-122.39716, 37.77193]]], [[[-122.39942, 37.77078], [-122.39941, 37.77085], [-122.39774, 37.77216], [-122.39759, 37.77195], [-122.39745, 37.77171], [-122.39736, 37.77177], [-122.39722, 37.77165], [-122.3985, 37.77064], [-122.39833, 37.77], [-122.39673, 37.77126], [-122.39648, 37.77107], [-122.39809, 37.7698], [-122.39821, 37.76989], [-122.39852, 37.76986], [-122.3991, 37.77033], [-122.39914, 37.77056], [-122.39942, 37.77078]]]]} | Open Access 1 | 47888 | Mission Creek Park | 31833 | 1719 | San Francisco - Office of Community Investment and Infrastructure, City and County of 737 | City 2 | City Agency 2 | https://sfocii.org/ | City 2 | 6121 | MJM Management Group 721 | Private 7 | Commercial 18 | https://missionbayparks.com/mission-creek-park/ | San Francisco 13 | 12.578 | Mission Creek Park | None 845 | ||
4417 | 4417 | 4416 | {"type": "Polygon", "coordinates": [[[-118.17106, 34.00724], [-118.1709, 34.00756], [-118.17057, 34.00745], [-118.17073, 34.00713], [-118.17106, 34.00724]]]} | Open Access 1 | 46431 | Bandini Park | 15795 | 1718 | City of Commerce Redevelopment Agency 760 | City 2 | City Agency 2 | http://www.ci.commerce.ca.us/index.aspx?NID=376 | City 2 | 1064 | Commerce, City of 440 | City 2 | City Agency 2 | http://www.ci.commerce.ca.us/facilities/facility/details/Bandini-Park--Batres-Community-Center-1 | Los Angeles 6 | 0.313 | Bandini Park | 0 | Local Park 2 | 4 |
3553 | 3553 | 3552 | {"type": "Polygon", "coordinates": [[[-118.32226, 33.97102], [-118.3222, 33.97106], [-118.32211, 33.97108], [-118.322, 33.97105], [-118.32196, 33.97104], [-118.32192, 33.97096], [-118.32194, 33.97086], [-118.32203, 33.9708], [-118.32211, 33.97078], [-118.32221, 33.97079], [-118.32224, 33.97081], [-118.32227, 33.9709], [-118.32226, 33.97102]]]} | Open Access 1 | 7716 | Circle Park (5th Avenue) | 29160 | 1716 | Los Angeles Department of Recreation and Parks, City of 660 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | http://www.laparks.org/ | Los Angeles 6 | 0.212 | Circle Park (5th Avenue) | None 296 | ||
5697 | 5697 | 5696 | {"type": "Polygon", "coordinates": [[[-118.24283, 34.12002], [-118.2427, 34.12011], [-118.24249, 34.11991], [-118.24263, 34.11981], [-118.24283, 34.12002]]]} | Open Access 1 | 45736 | Drew Street Park | 29109 | 1716 | Los Angeles Department of Recreation and Parks, City of 660 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | Los Angeles 6 | 0.116 | Drew Street Park | 0 | Local Park 2 | 4 | |
6420 | 6420 | 6419 | {"type": "Polygon", "coordinates": [[[-118.34333, 34.10414], [-118.34241, 34.10414], [-118.34241, 34.10351], [-118.34332, 34.10352], [-118.34333, 34.10414]]]} | Open Access 1 | 1893 | Dorothy J. and Benjamin B. Smith Park | 29107 | 1716 | Los Angeles Department of Recreation and Parks, City of 660 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | Los Angeles 6 | 1.441 | Dorothy J. and Benjamin B. Smith Park | 0 | Local Park 2 | 4 | |
7636 | 7636 | 7635 | {"type": "Polygon", "coordinates": [[[-118.31351, 33.97087], [-118.3135, 33.97102], [-118.3134, 33.97108], [-118.31327, 33.97108], [-118.31322, 33.97104], [-118.31317, 33.97098], [-118.31318, 33.97087], [-118.31325, 33.9708], [-118.31334, 33.97077], [-118.31341, 33.97078], [-118.31346, 33.9708], [-118.31351, 33.97087]]]} | Open Access 1 | 7705 | Circle Park (Gramercy) | 29159 | 1716 | Los Angeles Department of Recreation and Parks, City of 660 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | http://www.laparks.org/ | Los Angeles 6 | 0.216 | Circle Park (Gramercy) | None 637 | ||
9483 | 9483 | 9482 | {"type": "MultiPolygon", "coordinates": [[[[-118.35436, 34.11245], [-118.35429, 34.11252], [-118.35299, 34.11466], [-118.35297, 34.11244], [-118.35436, 34.11245]]], [[[-118.35377, 34.11413], [-118.35376, 34.1142], [-118.35361, 34.11442], [-118.35356, 34.11455], [-118.35354, 34.11476], [-118.35355, 34.11511], [-118.3535, 34.11524], [-118.35333, 34.11552], [-118.35348, 34.11564], [-118.353, 34.11529], [-118.35299, 34.11526], [-118.35373, 34.11404], [-118.35377, 34.11413]]]]} | Open Access 1 | 47826 | Runyon Canyon Park | 31769 | 1716 | Los Angeles Department of Recreation and Parks, City of 660 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | Los Angeles 6 | 4.702 | Runyon Canyon Park | 0 | Local Park 2 | 4 | |
15042 | 15042 | 15041 | {"type": "Polygon", "coordinates": [[[-118.33513, 34.1361], [-118.33399, 34.13613], [-118.33065, 34.14103], [-118.32259, 34.13646], [-118.32257, 34.1343], [-118.32662, 34.13429], [-118.33423, 34.13423], [-118.33431, 34.13463], [-118.33462, 34.13512], [-118.33462, 34.13529], [-118.33478, 34.1354], [-118.33491, 34.13558], [-118.3349, 34.13582], [-118.33505, 34.13595], [-118.33513, 34.1361]]]} | Open Access 1 | 45704 | Cahuenga Peak Phase 1 | 29079 | 1716 | Los Angeles Department of Recreation and Parks, City of 660 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | http://www.laparks.org/ | Los Angeles 6 | 130.502 | Cahuenga Peak Phase 1 | None 1301 | ||
16895 | 16895 | 16894 | {"type": "Polygon", "coordinates": [[[-118.244, 33.99945], [-118.244, 34.00174], [-118.24354, 34.00179], [-118.24362, 33.99941], [-118.244, 33.99945]]]} | Open Access 1 | 10195 | Fred Roberts Recreation Center | 29143 | 1716 | Los Angeles Department of Recreation and Parks, City of 660 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | http://www.laparks.org/ | Los Angeles 6 | 2.495 | Fred Roberts Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
17044 | 17044 | 17043 | {"type": "Polygon", "coordinates": [[[-118.24477, 34.05427], [-118.24461, 34.05444], [-118.24459, 34.05443], [-118.24454, 34.05449], [-118.24455, 34.05451], [-118.24403, 34.05507], [-118.2432, 34.05453], [-118.24394, 34.05373], [-118.24477, 34.05427]]]} | Open Access 1 | 45773 | 1st and Broadway Civic Center Park | 29093 | 1716 | Los Angeles Department of Recreation and Parks, City of 660 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | Los Angeles 6 | 2.682 | 1st and Broadway Civic Ctr. Park | 0 | Local Park 2 | 4 | |
4301 | 4301 | 4300 | {"type": "Polygon", "coordinates": [[[-118.65948, 34.17172], [-118.6594, 34.17201], [-118.65917, 34.17207], [-118.65913, 34.1721], [-118.65863, 34.17207], [-118.65863, 34.17156], [-118.65948, 34.17172]]]} | Open Access 1 | 48152 | Hidden Hills Demonstration Gardens | 32688 | 1713 | Hidden Hills, City of 742 | City 2 | City Agency 2 | http://www.hiddenhillscity.org/ | City 2 | 1713 | Hidden Hills, City of 728 | City 2 | City Agency 2 | Los Angeles 6 | 0.895 | Hidden Hills Demonstration Gardens | 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 | |||
14605 | 14605 | 14604 | {"type": "MultiPolygon", "coordinates": [[[[-118.99513, 34.22522], [-118.99416, 34.22587], [-118.99396, 34.22605], [-118.99375, 34.22591], [-118.99349, 34.22579], [-118.99331, 34.22595], [-118.99269, 34.2257], [-118.99252, 34.22559], [-118.99243, 34.22558], [-118.99226, 34.2257], [-118.99199, 34.22553], [-118.99167, 34.2255], [-118.99095, 34.22567], [-118.99104, 34.22594], [-118.99101, 34.22595], [-118.9909, 34.22569], [-118.99066, 34.22576], [-118.99043, 34.22585], [-118.99, 34.22607], [-118.9896, 34.22634], [-118.98943, 34.2265], [-118.98911, 34.22683], [-118.98885, 34.22722], [-118.98877, 34.22744], [-118.98843, 34.22754], [-118.98849, 34.22787], [-118.98887, 34.22801], [-118.98902, 34.2282], [-118.98929, 34.22802], [-118.98931, 34.22804], [-118.98905, 34.22823], [-118.98924, 34.22838], [-118.98923, 34.22874], [-118.98912, 34.22905], [-118.98914, 34.22921], [-118.9893, 34.22938], [-118.9895, 34.22947], [-118.98983, 34.22948], [-118.99003, 34.22936], [-118.9921, 34.22992], [-118.99219, 34.22962], [-118.99222, 34.22963], [-118.99214, 34.22993], [-118.99272, 34.23009], [-118.99293, 34.23008], [-118.99093, 34.23081], [-118.9907, 34.23038], [-118.98808, 34.2303], [-118.988, 34.22995], [-118.98796, 34.22918], [-118.98793, 34.22897], [-118.98784, 34.22871], [-118.98762, 34.22825], [-118.9882, 34.22881], [-118.9887, 34.22844], [-118.98783, 34.22762], [-118.98744, 34.2279], [-118.98729, 34.22759], [-118.98807, 34.22714], [-118.98771, 34.22668], [-118.99037, 34.22519], [-118.991, 34.22491], [-118.99138, 34.22482], [-118.99334, 34.22503], [-118.9945, 34.22449], [-118.99463, 34.22466], [-118.99491, 34.22495], [-118.99513, 34.22522]]], [[[-118.99869, 34.2319], [-118.99551, 34.23195], [-118.99551, 34.23225], [-118.99501, 34.23226], [-118.99474, 34.23228], [-118.99444, 34.23234], [-118.99414, 34.23243], [-118.99398, 34.23211], [-118.99401, 34.2316], [-118.99351, 34.23109], [-118.99307, 34.23094], [-118.99266, 34.23108], [-118.99251, 34.23148], [-118.99273, 34.2318], [-118.99282, 34.2321], [-118.99313, 34.23256], [-118.99255, 34.23317], [-118.9928, 34.23352], [-118.99239, 34.23411], [-118.9921, 34.23297], [-118.99215, 34.23248], [-118.99151, 34.23088], [-118.99461, 34.22975], [-118.99494, 34.23038], [-118.99559, 34.2306], [-118.99549, 34.23078], [-118.99589, 34.23105], [-118.99579, 34.23124], [-118.996, 34.23123], [-118.99817, 34.23176], [-118.99866, 34.23174], [-118.99869, 34.2319]]], [[[-119.03767, 34.24169], [-119.03769, 34.24188], [-119.03766, 34.24206], [-119.03755, 34.24226], [-119.03741, 34.2424], [-119.03726, 34.24249], [-119.03712, 34.24254], [-119.03626, 34.24276], [-119.0357, 34.24116], [-119.03624, 34.24102], [-119.0361, 34.24063], [-119.03575, 34.24066], [-119.03573, 34.2406], [-119.03607, 34.24057], [-119.03608, 34.24056], [-119.03505, 34.23759], [-119.03521, 34.23755], [-119.03562, 34.23873], [-119.03601, 34.23864], [-119.03603, 34.23869], [-119.03564, 34.2388], [-119.03622, 34.24044], [-119.03662, 34.24035], [-119.03665, 34.24043], [-119.03625, 34.24054], [-119.03673, 34.24192], [-119.03767, 34.24169]]]]} | Open Access 1 | 48297 | Mission Verde Park | 32869 | 1708 | Camarillo, City of 1117 | City 2 | City Agency 2 | http://www.ci.camarillo.ca.us/ | City 2 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 57.518 | Mission Verde Park | 0 | Local Park 2 | 4 | |
3616 | 3616 | 3615 | {"type": "Polygon", "coordinates": [[[-117.19803, 33.68999], [-117.19798, 33.69004], [-117.19756, 33.69004], [-117.19729, 33.69001], [-117.19718, 33.69006], [-117.19712, 33.69012], [-117.19679, 33.68999], [-117.19679, 33.68896], [-117.19757, 33.68896], [-117.19795, 33.68893], [-117.198, 33.68896], [-117.19803, 33.68916], [-117.19803, 33.68999]]]} | Open Access 1 | 39101 | Lazy Creek Park | 21121 | 1707 | Menifee, City of 667 | City 2 | City Agency 2 | http://www.cityofmenifee.us/284/Community-Services | City 2 | 1707 | Menifee, City of 655 | City 2 | City Agency 2 | Riverside 10 | 3.416 | Lazy Creek 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]);