units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9,376 rows where DES_TP = 2 sorted by UNIT_NAME descending
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 314
- San Diego, City of 281
- Sacramento, City of 192
- San Jose, City of 175
- San Francisco, City and County of 118
- Long Beach, City of 101
- Oakland, City of 99
- Los Angeles, County of 95
- Consumnes Community Services District 92
- Fresno, City of 83
- East Bay Regional Park District 76
- Modesto, City of 76
- Huntington Beach, City of 74
- Hayward Area Recreation and Park District 74
- Tracy, City of 69
- Santa Rosa, City of 68
- San Diego, County of 68
- Mountains Recreation and Conservation Authority 67
- Stockton, City of 67
- Roseville, City of 67
- Brentwood, City of 63
- Chula Vista, City of 60
- Irvine, City of 59
- Valley-Wide Recreation and Park District 57
- Bakersfield, City of 56
- Clovis, City of 54
- Manteca, City of 54
- Newport Beach, City of 50
- Anaheim, City of 49
- Riverside, City of 49
- …
MNG_AG_TYP 16
- City Agency 7,486
- Recreation/Parks District 704
- County Agency 651
- Community Services District 173
- County Agency - Parks 154
- Open Space District 75
- Water District 38
- School District 32
- Port/Harbor District 24
- Flood District 17
- Special District - Other 9
- County Agency - Other 7
- Cemetery District 3
- Irrigation District 1
- Sanitation District 1
- Joint Powers Authority 1
AGNCY_LEV 8 ✖
- City 7,352
- Special District 1,139
- County 798
- State 36
- Private 36
- Federal 8
- Non Profit 5
- Joint 2
ACCESS_TYP 4
- Open Access 9,084
- Restricted Access 210
- No Public Access 77
- Unknown Access 5
DES_TP 1
- Local Park · 9,376 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12876 | 12876 | 12875 | {"type": "Polygon", "coordinates": [[[-117.99859, 33.80404], [-117.99817, 33.80405], [-117.99816, 33.8035], [-117.99859, 33.80349], [-117.99859, 33.80404]]]} | Open Access 1 | 30339 | Zuniga Park | 27872 | 1342 | Stanton, City of 745 | City 2 | City Agency 2 | http://www.ci.stanton.ca.us/Departments/Parks-and-Recreation | City 2 | 1342 | Stanton, City of 731 | City 2 | City Agency 2 | Orange 3 | 0.588 | Zuniga Park | 0 | Local Park 2 | 4 | |
421 | 421 | 420 | {"type": "Polygon", "coordinates": [[[-119.34342, 36.20836], [-119.34235, 36.20852], [-119.34211, 36.20743], [-119.34318, 36.20728], [-119.34342, 36.20836]]]} | Open Access 1 | 1297 | Zumwalt Park | 27871 | 1398 | Tulare, City of 163 | City 2 | City Agency 2 | http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm | City 2 | 1398 | Tulare, City of 159 | City 2 | City Agency 2 | Tulare 29 | 2.969 | Zumwalt Park | 0 | Local Park 2 | 4 | |
14406 | 14406 | 14405 | {"type": "Polygon", "coordinates": [[[-121.14296, 37.7305], [-121.14279, 37.73057], [-121.14273, 37.73044], [-121.14271, 37.73031], [-121.14278, 37.73023], [-121.14295, 37.73023], [-121.14296, 37.7305]]]} | Open Access 1 | 44515 | Zumstein Park | 27870 | 1277 | Ripon, City of 534 | City 2 | City Agency 2 | http://www.cityofripon.org/ | City 2 | 1277 | Ripon, City of 527 | City 2 | City Agency 2 | San Joaquin 39 | 0.158 | Zumstein Park | 0 | Local Park 2 | 4 | |
6951 | 6951 | 6950 | {"type": "MultiPolygon", "coordinates": [[[[-118.81739, 34.01633], [-118.81698, 34.01691], [-118.81678, 34.01699], [-118.81673, 34.01699], [-118.81667, 34.01696], [-118.81668, 34.01687], [-118.81673, 34.01681], [-118.81739, 34.01633]]], [[[-118.84301, 34.02905], [-118.84223, 34.02992], [-118.8422, 34.02991], [-118.84178, 34.0296], [-118.83882, 34.02766], [-118.8382, 34.0272], [-118.83711, 34.02621], [-118.83632, 34.02562], [-118.83557, 34.02516], [-118.83435, 34.0245], [-118.83433, 34.02451], [-118.83416, 34.02442], [-118.83417, 34.02439], [-118.8339, 34.02424], [-118.83387, 34.02427], [-118.83353, 34.02407], [-118.83354, 34.02404], [-118.83323, 34.02387], [-118.8332, 34.02389], [-118.83303, 34.02379], [-118.83303, 34.02377], [-118.83133, 34.02282], [-118.83077, 34.02246], [-118.83024, 34.02206], [-118.82523, 34.01785], [-118.82464, 34.01743], [-118.82425, 34.0172], [-118.82385, 34.017], [-118.82354, 34.01686], [-118.82321, 34.01674], [-118.82273, 34.01659], [-118.82239, 34.0165], [-118.82204, 34.01642], [-118.82147, 34.01634], [-118.82064, 34.01628], [-118.82005, 34.0163], [-118.81958, 34.01634], [-118.81913, 34.01641], [-118.81799, 34.01664], [-118.81708, 34.01689], [-118.81756, 34.01621], [-118.81832, 34.01566], [-118.81848, 34.01551], [-118.81939, 34.01403], [-118.81945, 34.01385], [-118.81945, 34.0137], [-118.81941, 34.01357], [-118.81934, 34.01344], [-118.81896, 34.01299], [-118.81678, 34.01091], [-118.81723, 34.01059], [-118.81798, 34.01133], [-118.81932, 34.01229], [-118.81964, 34.01249], [-118.81986, 34.01262], [-118.81995, 34.01256], [-118.82003, 34.01262], [-118.82023, 34.01281], [-118.82052, 34.01312], [-118.82082, 34.01338], [-118.82163, 34.014], [-118.82296, 34.01508], [-118.82369, 34.01571], [-118.82442, 34.01629], [-118.82554, 34.01713], [-118.82587, 34.01735], [-118.82694, 34.01812], [-118.82722, 34.0183], [-118.82747, 34.01849], [-118.82771, 34.01864], [-118.82795, 34.01883], [-118.82824, 34.01901], [-118.82883, 34.01943], [-118.82889, 34.01949], [-118.83118, 34.02108], [-118.83231, 34.02194], [-118.83312, 34.02252], [-118.83367, 34.02288], [-118.83506, 34.0239], [-118.83519, 34.02399], [-118.83567, 34.02436], [-118.83684, 34.02511], [-118.83778, 34.02579], [-118.83951, 34.02691], [-118.84068, 34.02763], [-118.84102, 34.02786], [-118.84181, 34.02836], [-118.84271, 34.02889], [-118.84301, 34.02905]]]]} | Open Access 1 | 5854 | Zuma County Beach | 27869 | 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://beaches.lacounty.gov/wps/portal/dbh/home/detail/?current=true&urile=wcm:path:/dbh+content/dbh+site/home/home+detail/zuma+beach+1 | Los Angeles 6 | 97.148 | Zuma County Beach | 0 | Local Park 2 | 4 |
8154 | 8154 | 8153 | {"type": "Polygon", "coordinates": [[[-121.85116, 37.34628], [-121.85095, 37.34628], [-121.85074, 37.34634], [-121.85008, 37.34674], [-121.85002, 37.34676], [-121.84993, 37.34675], [-121.84958, 37.34642], [-121.85074, 37.3457], [-121.85079, 37.34575], [-121.85071, 37.34581], [-121.85116, 37.34628]]]} | Open Access 1 | 13752 | Zolezzi Park | 27868 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 1.715 | Zolezzi Park | 2007 | Local Park 2 | 4 | |
6469 | 6469 | 6468 | {"type": "Polygon", "coordinates": [[[-122.44202, 38.4864], [-122.44169, 38.48664], [-122.44097, 38.48604], [-122.44129, 38.48579], [-122.44202, 38.4864]]]} | Open Access 1 | 2363 | Zinfandel Park | 27866 | 1290 | Saint Helena, City of 422 | City 2 | City Agency 2 | http://cityofsthelena.org/parks-recreation | City 2 | 1290 | Saint Helena, City of 416 | City 2 | City Agency 2 | Napa 11 | 0.889 | Zinfandel Park | 0 | Local Park 2 | 4 | |
11766 | 11766 | 11765 | {"type": "Polygon", "coordinates": [[[-121.40978, 38.42718], [-121.40877, 38.42737], [-121.40846, 38.42737], [-121.40744, 38.42639], [-121.40714, 38.42634], [-121.40819, 38.42567], [-121.40978, 38.42718]]]} | Open Access 1 | 24058 | Zimbelman Park | 27865 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 4.892 | Zimbelman Park | 0 | Local Park 2 | 4 | |
14348 | 14348 | 14347 | {"type": "Polygon", "coordinates": [[[-118.70897, 34.15007], [-118.70896, 34.15454], [-118.70252, 34.15455], [-118.70249, 34.15313], [-118.69819, 34.15314], [-118.69761, 34.15316], [-118.69748, 34.15272], [-118.69743, 34.15242], [-118.69741, 34.15208], [-118.69743, 34.15178], [-118.69747, 34.15155], [-118.69789, 34.15166], [-118.6981, 34.15115], [-118.69763, 34.15101], [-118.69802, 34.15008], [-118.69819, 34.14996], [-118.69825, 34.14961], [-118.69841, 34.14944], [-118.69878, 34.14891], [-118.69851, 34.14829], [-118.699, 34.14777], [-118.6994, 34.14746], [-118.69953, 34.14721], [-118.69967, 34.14707], [-118.70143, 34.14568], [-118.70188, 34.14553], [-118.70215, 34.14535], [-118.70228, 34.14507], [-118.70303, 34.14461], [-118.70413, 34.14399], [-118.70442, 34.14388], [-118.70549, 34.14323], [-118.70552, 34.15008], [-118.70897, 34.15007]]]} | Open Access 1 | 44386 | Zev Yaroslavsky Las Virgenes Highlands Park | 27864 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 192.192 | Zev Yaroslavsky Las Virgenes Highlands Park | 0 | Local Park 2 | 4 | |
3750 | 3750 | 3749 | {"type": "Polygon", "coordinates": [[[-120.94386, 37.73879], [-120.94314, 37.73885], [-120.94287, 37.73891], [-120.94263, 37.73902], [-120.94225, 37.73926], [-120.94216, 37.7393], [-120.94209, 37.73937], [-120.94207, 37.73943], [-120.94207, 37.73949], [-120.94211, 37.73957], [-120.94271, 37.74155], [-120.94263, 37.74162], [-120.94258, 37.74163], [-120.94248, 37.74161], [-120.94226, 37.74155], [-120.94204, 37.74153], [-120.94254, 37.74144], [-120.94254, 37.74143], [-120.94211, 37.73997], [-120.94189, 37.73997], [-120.94169, 37.7393], [-120.94138, 37.7393], [-120.9411, 37.73836], [-120.94174, 37.73838], [-120.94238, 37.73837], [-120.94323, 37.73832], [-120.94379, 37.73826], [-120.94386, 37.73879]]]} | Open Access 1 | 310 | Zerillo Park | 27863 | 1278 | Riverbank, City of 41 | City 2 | City Agency 2 | http://www.riverbank.org/Depts/Recreation/default.aspx | City 2 | 1278 | Riverbank, City of 40 | City 2 | City Agency 2 | Stanislaus 2 | 5.721 | Zerillo Park | 0 | Local Park 2 | 4 | |
5775 | 5775 | 5774 | {"type": "Polygon", "coordinates": [[[-117.05795, 32.7466], [-117.05795, 32.74669], [-117.05759, 32.74659], [-117.05761, 32.74652], [-117.05777, 32.74658], [-117.05795, 32.7466]]]} | Open Access 1 | 5 | Zena Mini-Park | 27862 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.067 | Zena Mini-Park | 0 | Local Park 2 | 4 | |
9309 | 9309 | 9308 | {"type": "Polygon", "coordinates": [[[-118.52574, 34.28307], [-118.52532, 34.28336], [-118.5247, 34.28385], [-118.52397, 34.28304], [-118.52299, 34.28249], [-118.52309, 34.28228], [-118.52327, 34.28207], [-118.52344, 34.28194], [-118.52411, 34.28154], [-118.52433, 34.28135], [-118.52467, 34.28097], [-118.52474, 34.28095], [-118.52478, 34.28098], [-118.52495, 34.28132], [-118.5251, 34.28186], [-118.52519, 34.28208], [-118.52531, 34.28229], [-118.52559, 34.2827], [-118.52567, 34.28285], [-118.52574, 34.28307]]]} | Open Access 1 | 15517 | Zelzah Park | 27861 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 9.729 | Zelzah Park | 0 | Local Park 2 | 4 | |
2149 | 2149 | 2148 | {"type": "Polygon", "coordinates": [[[-122.46161, 37.87736], [-122.46118, 37.87759], [-122.46109, 37.87757], [-122.46043, 37.87756], [-122.46026, 37.87689], [-122.46161, 37.87736]]]} | Open Access 1 | 16016 | Zelinksy Park | 27860 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 1.209 | Zelinksy Park | 0 | Local Park 2 | 4 | |
7085 | 7085 | 7084 | {"type": "Polygon", "coordinates": [[[-118.33724, 33.911], [-118.33723, 33.91126], [-118.3372, 33.91128], [-118.33619, 33.91128], [-118.33619, 33.911], [-118.33724, 33.911]]]} | Open Access 1 | 6178 | Zela Davis Park | 27858 | 1130 | Hawthorne, City of 299 | City 2 | City Agency 2 | http://www.cityofhawthorne.com/ | City 2 | 1130 | Hawthorne, City of 295 | City 2 | City Agency 2 | Los Angeles 6 | 0.738 | Zela Davis Park | 0 | Local Park 2 | 4 | |
5465 | 5465 | 5464 | {"type": "Polygon", "coordinates": [[[-118.33727, 33.9101], [-118.33699, 33.91011], [-118.33698, 33.91027], [-118.3365, 33.91027], [-118.3365, 33.90959], [-118.33727, 33.90959], [-118.33727, 33.9101]]]} | Restricted Access 2 | 6273 | Zela Davis Elementary School Park | 31892 | 2044 | Hawthorne School District 808 | Special District 4 | School District 14 | http://www.hawthorne.k12.ca.us/ | Special District 4 | 1130 | Hawthorne, City of 295 | City 2 | City Agency 2 | Los Angeles 6 | 1.201 | Zela Davis Elementary School Park | 0 | Local Park 2 | 4 | |
12546 | 12546 | 12545 | {"type": "Polygon", "coordinates": [[[-121.45616, 38.42344], [-121.45539, 38.4233], [-121.45467, 38.4233], [-121.45467, 38.42339], [-121.45391, 38.42326], [-121.45311, 38.42314], [-121.45307, 38.42312], [-121.45306, 38.42308], [-121.45318, 38.4224], [-121.4532, 38.42195], [-121.45324, 38.42191], [-121.45503, 38.4219], [-121.45509, 38.42193], [-121.45522, 38.42193], [-121.45525, 38.42191], [-121.45602, 38.4222], [-121.45616, 38.42344]]]} | Open Access 1 | 29050 | Zehnder Park | 27857 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 9.459 | Zehnder Park | 0 | Local Park 2 | 4 | |
10835 | 10835 | 10834 | {"type": "Polygon", "coordinates": [[[-118.08808, 34.06303], [-118.08554, 34.0657], [-118.08544, 34.06568], [-118.08536, 34.06562], [-118.08532, 34.06557], [-118.08531, 34.06551], [-118.08529, 34.06486], [-118.08727, 34.06278], [-118.08747, 34.06278], [-118.08748, 34.0628], [-118.08808, 34.0628], [-118.08808, 34.06303]]]} | Open Access 1 | 20610 | Zapopan Park | 27856 | 1284 | Rosemead, City of 130 | City 2 | City Agency 2 | http://www.cityofrosemead.org/index.aspx?page=74 | City 2 | 1284 | Rosemead, City of 127 | City 2 | City Agency 2 | Los Angeles 6 | 6.761 | Zapopan Park | 0 | Local Park 2 | 4 | |
12054 | 12054 | 12053 | {"type": "Polygon", "coordinates": [[[-121.4498, 37.74505], [-121.44971, 37.74505], [-121.44874, 37.74425], [-121.44865, 37.74416], [-121.44859, 37.74406], [-121.44854, 37.74394], [-121.44853, 37.74383], [-121.44853, 37.74372], [-121.44856, 37.74363], [-121.44868, 37.74344], [-121.44885, 37.74332], [-121.44897, 37.74326], [-121.44914, 37.74321], [-121.44933, 37.7432], [-121.44948, 37.74321], [-121.44964, 37.74325], [-121.44981, 37.74334], [-121.44993, 37.74344], [-121.45002, 37.74356], [-121.45007, 37.74368], [-121.45009, 37.74379], [-121.45009, 37.74464], [-121.45005, 37.74477], [-121.45, 37.74486], [-121.44991, 37.74496], [-121.4498, 37.74505]]]} | Open Access 1 | 24748 | Zanussi Park | 27855 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 4.966 | Zanussi Park | 0 | Local Park 2 | 4 | |
4014 | 4014 | 4013 | {"type": "Polygon", "coordinates": [[[-118.01207, 34.07165], [-118.01152, 34.07275], [-118.01061, 34.07243], [-118.01092, 34.07179], [-118.01001, 34.07147], [-118.01024, 34.071], [-118.01027, 34.07098], [-118.01031, 34.07098], [-118.01204, 34.07159], [-118.01207, 34.07161], [-118.01207, 34.07165]]]} | Open Access 1 | 20679 | Zamora Park | 27852 | 1095 | El Monte, City of 240 | City 2 | City Agency 2 | http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx | City 2 | 1095 | El Monte, City of 236 | City 2 | City Agency 2 | Los Angeles 6 | 4.486 | Zamora Park | 0 | Local Park 2 | 4 | |
6154 | 6154 | 6153 | {"type": "Polygon", "coordinates": [[[-119.02223, 36.0768], [-119.02221, 36.07837], [-119.02222, 36.07915], [-119.02219, 36.07954], [-119.02219, 36.08023], [-119.02126, 36.08021], [-119.02101, 36.07981], [-119.02063, 36.07909], [-119.02029, 36.07837], [-119.01969, 36.07682], [-119.0201, 36.0768], [-119.02223, 36.0768]]]} | Open Access 1 | 1229 | Zalud Park | 27851 | 1260 | Porterville, City of 139 | City 2 | City Agency 2 | http://www.ci.porterville.ca.us/ | City 2 | 1260 | Porterville, City of 136 | City 2 | City Agency 2 | Tulare 29 | 15.304 | Zalud Park | 0 | Local Park 2 | 4 | |
3000 | 3000 | 2999 | {"type": "Polygon", "coordinates": [[[-117.92179, 34.11982], [-117.92177, 34.12163], [-117.92068, 34.12164], [-117.92067, 34.12153], [-117.91871, 34.12153], [-117.91861, 34.12146], [-117.91861, 34.1209], [-117.91868, 34.12085], [-117.91899, 34.12085], [-117.91926, 34.1209], [-117.91985, 34.1209], [-117.92004, 34.12087], [-117.92028, 34.12079], [-117.92041, 34.12076], [-117.92109, 34.12076], [-117.92125, 34.12079], [-117.92137, 34.12077], [-117.92143, 34.12071], [-117.92146, 34.12063], [-117.92143, 34.12048], [-117.92143, 34.1201], [-117.92146, 34.11993], [-117.92145, 34.11987], [-117.92141, 34.11982], [-117.92179, 34.11982]]]} | Open Access 1 | 20566 | Zacatecas Park | 27850 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | Los Angeles 6 | 6.772 | Zacatecas 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]);