units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9,376 rows where DES_TP = 2
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Consumnes Community Services District 84
- Los Angeles, City of 57
- East Bay Regional Park District 54
- San Diego, City of 46
- Tracy, City of 39
- Long Beach, City of 35
- El Dorado, County of 33
- Folsom, City of 31
- Cordova Recreation and Park District 30
- Southgate Recreation and Park District 29
- San Ramon, City of 26
- Los Angeles, County of 25
- Stockton, City of 25
- San Jose, City of 22
- Valley-Wide Recreation and Park District 22
- Arcata, City of 22
- Murrieta, City of 21
- Temecula, City of 21
- Roseville, City of 21
- Sunrise Recreation and Park District 20
- Mountains Recreation and Conservation Authority 19
- Manteca, City of 19
- Chino Hills, City of 17
- Oakley, City of 17
- San Diego, County of 16
- Orange, County of 16
- San Jacinto, City of 16
- Los Angeles - Department of Parks and Recreation, County of 16
- Yorba Linda, City of 15
- Los Banos, City of 15
- …
COUNTY >30 ✖
- Los Angeles 364
- Sacramento 277
- Orange 192
- Riverside 179
- Contra Costa 112
- San Joaquin 112
- San Diego 108
- San Bernardino 90
- Santa Clara 76
- El Dorado 61
- Alameda 56
- Placer 56
- Humboldt 42
- Fresno 40
- San Luis Obispo 35
- Imperial 34
- Merced 33
- Ventura 29
- Sonoma 28
- Monterey 25
- Yolo 25
- Kern 25
- Marin 24
- Stanislaus 21
- Napa 17
- San Mateo 15
- Lake 14
- Mendocino 13
- Tulare 13
- Solano 12
- …
MNG_AG_TYP 14
- City Agency 1,521
- Recreation/Parks District 282
- County Agency 192
- Community Services District 128
- County Agency - Parks 55
- Open Space District 19
- School District 12
- Flood District 10
- Water District 10
- Special District - Other 9
- Port/Harbor District 5
- County Agency - Other 2
- Irrigation District 1
- Joint Powers Authority 1
ACCESS_TYP 4
- Open Access 2,102
- Restricted Access 111
- No Public Access 30
- Unknown Access 4
DES_TP 1
- Local Park · 2,247 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11564 | 11564 | 11563 | {"type": "Polygon", "coordinates": [[[-122.63916, 38.26806], [-122.63779, 38.26959], [-122.63739, 38.26937], [-122.63732, 38.26941], [-122.63645, 38.26893], [-122.63786, 38.26737], [-122.63811, 38.26751], [-122.63814, 38.26749], [-122.63916, 38.26806]]]} | Open Access 1 | 23646 | Leghorns Park | 21140 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 7.207 | Leghorns Park | 0 | Local Park 2 | 4 | |
11565 | 11565 | 11564 | {"type": "Polygon", "coordinates": [[[-123.4408, 38.6977], [-123.4407, 38.69783], [-123.44058, 38.69816], [-123.43903, 38.69953], [-123.43871, 38.70002], [-123.43817, 38.6997], [-123.43849, 38.6991], [-123.43785, 38.69878], [-123.43721, 38.69906], [-123.43721, 38.69908], [-123.43743, 38.69925], [-123.43732, 38.69934], [-123.43704, 38.69916], [-123.4365, 38.6996], [-123.4365, 38.69961], [-123.43704, 38.69997], [-123.43865, 38.70061], [-123.43862, 38.70064], [-123.43836, 38.70116], [-123.43828, 38.70128], [-123.43822, 38.70128], [-123.43816, 38.70126], [-123.43765, 38.70074], [-123.4373, 38.70043], [-123.43652, 38.7001], [-123.43583, 38.69956], [-123.43667, 38.69873], [-123.4386, 38.69695], [-123.4389, 38.6966], [-123.43925, 38.69631], [-123.43926, 38.69636], [-123.44016, 38.69725], [-123.4408, 38.6977]]]} | Open Access 1 | 23647 | Pebble Beach | 23550 | 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 | 20.416 | Pebble Beach | 0 | Local Park 2 | 4 | |
11566 | 11566 | 11565 | {"type": "Polygon", "coordinates": [[[-123.4743, 38.7297], [-123.47379, 38.7302], [-123.47355, 38.72996], [-123.47404, 38.72949], [-123.4743, 38.7297]]]} | Open Access 1 | 23648 | Shell Beach | 25387 | 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 | 0.556 | Shell Beach | 0 | Local Park 2 | 4 | |
11567 | 11567 | 11566 | {"type": "Polygon", "coordinates": [[[-123.45916, 38.71589], [-123.45775, 38.71717], [-123.45715, 38.71765], [-123.45648, 38.71675], [-123.45595, 38.71631], [-123.4566, 38.71574], [-123.45706, 38.71605], [-123.45742, 38.71585], [-123.45649, 38.71505], [-123.45634, 38.71501], [-123.45631, 38.71486], [-123.45642, 38.71479], [-123.4566, 38.71486], [-123.45662, 38.71497], [-123.45735, 38.71555], [-123.45756, 38.71542], [-123.45757, 38.71526], [-123.45657, 38.71442], [-123.45616, 38.71442], [-123.4556, 38.71483], [-123.45522, 38.71454], [-123.45545, 38.71434], [-123.45545, 38.71433], [-123.45328, 38.71253], [-123.45404, 38.7124], [-123.45461, 38.71221], [-123.45484, 38.71259], [-123.4547, 38.7131], [-123.45507, 38.71341], [-123.45618, 38.71372], [-123.45651, 38.71397], [-123.4573, 38.71397], [-123.45798, 38.71439], [-123.4584, 38.7147], [-123.45916, 38.71589]], [[-123.45789, 38.71568], [-123.45723, 38.71618], [-123.45748, 38.71643], [-123.45818, 38.71591], [-123.45841, 38.71567], [-123.4585, 38.71535], [-123.45848, 38.71506], [-123.45832, 38.71477], [-123.45776, 38.71433], [-123.45729, 38.71411], [-123.45699, 38.71407], [-123.45684, 38.71429], [-123.45715, 38.71446], [-123.45723, 38.71441], [-123.45741, 38.71443], [-123.45782, 38.71475], [-123.45794, 38.71492], [-123.458, 38.71515], [-123.458, 38.71542], [-123.45789, 38.71568]]]} | Open Access 1 | 23649 | Stengel Beach | 25827 | 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 | 17.102 | Stengel Beach | 0 | Local Park 2 | 4 | |
11568 | 11568 | 11567 | {"type": "Polygon", "coordinates": [[[-122.30822, 37.83781], [-122.30821, 37.83825], [-122.30811, 37.83834], [-122.30805, 37.83835], [-122.30808, 37.83859], [-122.30688, 37.8386], [-122.30689, 37.83838], [-122.30765, 37.83835], [-122.30752, 37.83805], [-122.30775, 37.83797], [-122.30777, 37.83792], [-122.30772, 37.83783], [-122.30779, 37.8378], [-122.30749, 37.83723], [-122.30818, 37.83723], [-122.30819, 37.83736], [-122.30811, 37.83749], [-122.30811, 37.8378], [-122.30822, 37.83781]]]} | Open Access 1 | 23663 | Davenport Park | 17939 | 1098 | Emeryville, City of 790 | City 2 | City Agency 2 | http://www.ci.emeryville.ca.us/158/City-Parks | City 2 | 1098 | Emeryville, City of 769 | City 2 | City Agency 2 | Alameda 17 | 2.102 | Davenport Park | 0 | Local Park 2 | 4 | |
11570 | 11570 | 11569 | {"type": "Polygon", "coordinates": [[[-122.06028, 37.72143], [-122.05949, 37.7214], [-122.05929, 37.72149], [-122.05929, 37.72141], [-122.05922, 37.72128], [-122.05923, 37.72117], [-122.05937, 37.72113], [-122.05955, 37.72111], [-122.06008, 37.72111], [-122.06028, 37.72109], [-122.06028, 37.72143]]]} | Open Access 1 | 23665 | Deerview Park | 18011 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 0.765 | Deerview Park | 0 | Local Park 2 | 4 | |
11571 | 11571 | 11570 | {"type": "Polygon", "coordinates": [[[-118.08661, 34.0972], [-118.0861, 34.09721], [-118.0861, 34.09691], [-118.08661, 34.09691], [-118.08661, 34.0972]]]} | Restricted Access 2 | 24526 | Roosevelt Park | 31646 | 2393 | San Gabriel Unified School District 706 | Special District 4 | School District 14 | http://www.sgusd.k12.ca.us/ | Special District 4 | 1301 | San Gabriel, City of 725 | City 2 | City Agency 2 | Los Angeles 6 | 0.381 | Roosevelt Park | 0 | Local Park 2 | 4 | |
11574 | 11574 | 11573 | {"type": "Polygon", "coordinates": [[[-122.13867, 37.66915], [-122.13747, 37.66972], [-122.13761, 37.66993], [-122.13728, 37.66988], [-122.137, 37.66991], [-122.13688, 37.66873], [-122.13674, 37.66695], [-122.13846, 37.66685], [-122.13867, 37.66915]]]} | Open Access 1 | 23668 | Del Rey Park | 31452 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/Facilities/Facility/Details/Del-Rey-Park-42 | Alameda 17 | 11.244 | Del Rey Park | 0 | Local Park 2 | 4 |
11577 | 11577 | 11576 | {"type": "Polygon", "coordinates": [[[-122.24488, 37.77056], [-122.2443, 37.77142], [-122.24359, 37.77111], [-122.24418, 37.77026], [-122.24488, 37.77056]]]} | Open Access 1 | 23672 | McKinley Park | 22046 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 1.901 | McKinley Park | 0 | Local Park 2 | 4 | |
11583 | 11583 | 11582 | {"type": "Polygon", "coordinates": [[[-122.32581, 37.5118], [-122.32578, 37.51184], [-122.32538, 37.51186], [-122.32483, 37.51233], [-122.32428, 37.51192], [-122.32438, 37.51176], [-122.32446, 37.51159], [-122.32451, 37.51155], [-122.32453, 37.51161], [-122.32581, 37.5118]]]} | Open Access 1 | 23677 | Ralston Ranch Park | 24106 | 1025 | Belmont, City of 198 | City 2 | City Agency 2 | http://www.belmont.gov/city-hall/park-and-recreation | City 2 | 1025 | Belmont, City of 194 | City 2 | City Agency 2 | San Mateo 15 | 1.214 | Ralston Ranch Park | 0 | Local Park 2 | 4 | |
11585 | 11585 | 11584 | {"type": "Polygon", "coordinates": [[[-122.28657, 37.52479], [-122.2865, 37.52492], [-122.28644, 37.52499], [-122.28615, 37.52518], [-122.28601, 37.5249], [-122.28575, 37.52478], [-122.28541, 37.52485], [-122.28597, 37.5244], [-122.28606, 37.52445], [-122.28619, 37.52448], [-122.28629, 37.52454], [-122.28638, 37.52461], [-122.28643, 37.5247], [-122.28657, 37.52479]]]} | Open Access 1 | 23680 | Darvey Glen Park | 17931 | 1025 | Belmont, City of 198 | City 2 | City Agency 2 | http://www.belmont.gov/city-hall/park-and-recreation | City 2 | 1025 | Belmont, City of 194 | City 2 | City Agency 2 | San Mateo 15 | 0.935 | Darvey Glen Park | 0 | Local Park 2 | 4 | |
11586 | 11586 | 11585 | {"type": "Polygon", "coordinates": [[[-122.48853, 37.58277], [-122.48701, 37.58454], [-122.48674, 37.58438], [-122.48648, 37.58417], [-122.48626, 37.58395], [-122.48597, 37.5836], [-122.48578, 37.58345], [-122.48697, 37.58208], [-122.48761, 37.58223], [-122.48809, 37.58168], [-122.48813, 37.58169], [-122.48776, 37.58215], [-122.48853, 37.58277]]]} | Open Access 1 | 23681 | Sanchez Park | 25008 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 8.902 | Sanchez Park | 0 | Local Park 2 | 4 | |
11589 | 11589 | 11588 | {"type": "Polygon", "coordinates": [[[-121.91992, 37.77604], [-121.91982, 37.77629], [-121.91977, 37.7766], [-121.91977, 37.77685], [-121.91983, 37.77709], [-121.91991, 37.77733], [-121.91989, 37.77736], [-121.91774, 37.77781], [-121.91718, 37.77795], [-121.91808, 37.77551], [-121.9186, 37.77565], [-121.91992, 37.77604]]]} | Open Access 1 | 23706 | Valley View Park | 26807 | 1313 | San Ramon, City of 70 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 10.024 | Valley View Park | 0 | Local Park 2 | 4 | |
11591 | 11591 | 11590 | {"type": "Polygon", "coordinates": [[[-121.75666, 37.95965], [-121.75655, 37.96002], [-121.756, 37.95991], [-121.755, 37.95968], [-121.75496, 37.95966], [-121.75495, 37.95962], [-121.75503, 37.95947], [-121.75529, 37.95908], [-121.75666, 37.95965]]]} | Open Access 1 | 23694 | Heidorn Park | 19792 | 1007 | Antioch, City of 350 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | Contra Costa 12 | 2.013 | Heidorn Park | 0 | Local Park 2 | 4 | |
11592 | 11592 | 11591 | {"type": "Polygon", "coordinates": [[[-121.72108, 37.94512], [-121.72097, 37.94543], [-121.72086, 37.94556], [-121.7208, 37.9457], [-121.72078, 37.9459], [-121.72077, 37.94628], [-121.72073, 37.94643], [-121.72069, 37.94645], [-121.72067, 37.94649], [-121.72069, 37.94652], [-121.72068, 37.94658], [-121.71946, 37.94658], [-121.71946, 37.94628], [-121.71953, 37.94627], [-121.71959, 37.94624], [-121.71962, 37.9462], [-121.71964, 37.94614], [-121.71963, 37.94544], [-121.71958, 37.94537], [-121.71953, 37.94534], [-121.71946, 37.94533], [-121.71946, 37.94531], [-121.71996, 37.94531], [-121.72028, 37.94528], [-121.72066, 37.94522], [-121.72108, 37.94512]]]} | Open Access 1 | 23695 | King Park | 20656 | 1034 | Brentwood, City of 351 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | Contra Costa 12 | 3.946 | King Park | 0 | Local Park 2 | 4 | |
11594 | 11594 | 11593 | {"type": "Polygon", "coordinates": [[[-121.15872, 38.6682], [-121.15835, 38.66856], [-121.15794, 38.6684], [-121.15817, 38.66803], [-121.15848, 38.66816], [-121.15859, 38.66812], [-121.15865, 38.66817], [-121.15872, 38.6682]]]} | Open Access 1 | 23933 | The Shores Mini-Park | 26293 | 1108 | Folsom, City of 565 | City 2 | City Agency 2 | http://www.folsom.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1108 | Folsom, City of 557 | City 2 | City Agency 2 | Sacramento 41 | 0.529 | The Shores Mini-Park | 0 | Local Park 2 | 4 | |
11595 | 11595 | 11594 | {"type": "Polygon", "coordinates": [[[-121.68708, 37.93859], [-121.68708, 37.93885], [-121.687, 37.93889], [-121.687, 37.93911], [-121.68708, 37.93908], [-121.68708, 37.93924], [-121.687, 37.93929], [-121.687, 37.9395], [-121.68708, 37.93947], [-121.68708, 37.93981], [-121.68705, 37.93986], [-121.68697, 37.93989], [-121.68496, 37.9399], [-121.68473, 37.93992], [-121.68441, 37.93996], [-121.68393, 37.93997], [-121.68394, 37.93831], [-121.6842, 37.93831], [-121.68421, 37.93859], [-121.68669, 37.93859], [-121.68689, 37.93859], [-121.68689, 37.93832], [-121.68694, 37.93832], [-121.68702, 37.93834], [-121.68702, 37.93858], [-121.68708, 37.93859]]]} | Open Access 1 | 23697 | Heron Park | 19878 | 1034 | Brentwood, City of 351 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | Contra Costa 12 | 10.18 | Heron Park | 0 | Local Park 2 | 4 | |
11596 | 11596 | 11595 | {"type": "Polygon", "coordinates": [[[-121.70958, 37.92667], [-121.70943, 37.92742], [-121.70766, 37.92741], [-121.70765, 37.92742], [-121.70622, 37.92743], [-121.70621, 37.92742], [-121.70653, 37.92713], [-121.70685, 37.92711], [-121.70703, 37.92706], [-121.70715, 37.92701], [-121.70725, 37.927], [-121.70725, 37.92699], [-121.7072, 37.92693], [-121.70717, 37.92696], [-121.70703, 37.92703], [-121.70685, 37.92709], [-121.70651, 37.92711], [-121.70618, 37.92741], [-121.70575, 37.9271], [-121.7054, 37.92676], [-121.70524, 37.92649], [-121.7051, 37.92615], [-121.70504, 37.92587], [-121.70503, 37.92565], [-121.70515, 37.92561], [-121.70876, 37.9256], [-121.70877, 37.92589], [-121.70958, 37.92667]], [[-121.70698, 37.92638], [-121.70699, 37.92637], [-121.70694, 37.92629], [-121.7069, 37.92631], [-121.70698, 37.92638]], [[-121.70697, 37.92661], [-121.707, 37.92659], [-121.70699, 37.92658], [-121.70695, 37.9266], [-121.70696, 37.92662], [-121.70697, 37.92661]], [[-121.70701, 37.92656], [-121.70701, 37.92657], [-121.70703, 37.92656], [-121.70703, 37.92653], [-121.70701, 37.92653], [-121.70701, 37.92656]], [[-121.70735, 37.92718], [-121.70737, 37.92716], [-121.70731, 37.9271], [-121.70731, 37.92714], [-121.70735, 37.92718]], [[-121.70738, 37.92722], [-121.7074, 37.92721], [-121.70737, 37.92718], [-121.70736, 37.92719], [-121.70738, 37.92722]], [[-121.70765, 37.92738], [-121.70766, 37.92738], [-121.70767, 37.92737], [-121.70761, 37.92732], [-121.70765, 37.92738]]]} | Open Access 1 | 23700 | Veteran's Park | 27016 | 1034 | Brentwood, City of 351 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://gis.brentwoodca.gov/parksfinder/ | Contra Costa 12 | 16.849 | Veteran's Park | 0 | Local Park 2 | 4 |
11597 | 11597 | 11596 | {"type": "Polygon", "coordinates": [[[-121.74099, 37.92084], [-121.74088, 37.92104], [-121.73758, 37.92103], [-121.73758, 37.92009], [-121.73789, 37.92015], [-121.7388, 37.91986], [-121.73899, 37.91952], [-121.73935, 37.91955], [-121.73955, 37.91953], [-121.73976, 37.91948], [-121.73999, 37.91936], [-121.74004, 37.91935], [-121.7403, 37.91955], [-121.74008, 37.91975], [-121.74047, 37.92002], [-121.74069, 37.92022], [-121.74085, 37.92045], [-121.74099, 37.92069], [-121.74099, 37.92084]]]} | Open Access 1 | 23702 | Oak Meadow Park | 22987 | 1034 | Brentwood, City of 351 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | Contra Costa 12 | 9.679 | Oak Meadow Park | 0 | Local Park 2 | 4 | |
11598 | 11598 | 11597 | {"type": "Polygon", "coordinates": [[[-121.70317, 37.91843], [-121.70474, 37.91843], [-121.70478, 37.91844], [-121.70481, 37.91848], [-121.7048, 37.91967], [-121.70475, 37.9197], [-121.70317, 37.9197], [-121.70313, 37.91968], [-121.70311, 37.91965], [-121.70311, 37.91848], [-121.70312, 37.91845], [-121.70317, 37.91843]]]} | Open Access 1 | 23703 | Orchard Park | 23189 | 1034 | Brentwood, City of 351 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | Contra Costa 12 | 5.171 | Orchard 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]);