units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2,391 rows where LAYER = 4 sorted by DES_TP
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Mountains Recreation and Conservation Authority 272
- East Bay Regional Park District 130
- Consumnes Community Services District 92
- Hayward Area Recreation and Park District 84
- Valley-Wide Recreation and Park District 58
- Rancho Simi Recreation and Park District 52
- Yuba County Water Agency 50
- Midpeninsula Regional Open Space District 49
- Conejo Recreation and Park District 45
- Conejo Open Space Conservation Agency 43
- Southgate Recreation and Park District 41
- Marin County Open Space District 40
- Sunrise Recreation and Park District 39
- Cordova Recreation and Park District 38
- Greater Vallejo Recreation and Park District 33
- Pleasant Valley Recreation and Park District 29
- Fresno Metropolitan Flood Control District 29
- Las Virgenes Municipal Water District 28
- North of the River Recreation and Park District 27
- El Dorado Hills Community Service District 25
- Monterey Peninsula Regional Park District 24
- Los Angeles County Flood Control District 23
- Olivehurst Public Utility District 23
- Santa Clara Valley Open Space Authority 22
- Natomas Basin Conservancy 22
- Sonoma County Agricultural Preservation and Open Space District 21
- Santa Barbara Flood Control and Water Conserv. District 19
- Whittier, City of 18
- Jurupa Area Recreation and Park District 18
- San Ramon, City of 17
- …
DES_TP >30
- Local Park 1,121
- Local Recreation Area 402
- Local Other or Unknown 286
- Local Conservation Area 210
- Local Historic or Cultural Area 57
- Local Resource Management Area 10
- National Monument or Landmark 2
- State Conservation Area 1
- State Park 1
- None 1
- National Recreation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- National Wildlife Refuge 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 23
- Recreation/Parks District 1,089
- Open Space District 338
- Water District 233
- Community Services District 195
- City Agency 159
- Flood District 105
- Cemetery District 61
- Irrigation District 49
- School District 37
- Port/Harbor District 30
- Special District - Other 15
- County Agency - Parks 12
- Sanitation District 9
- Joint Powers Authority 9
- County Agency 7
- Non Profit - Land Trust 5
- Conservation District 5
- Transportation Agency 5
- State Agency 2
- Non Profit - Conservation 2
- Metropolitan Planning Organization 2
- Airport District 1
- Fire District 1
ACCESS_TYP 4
- Open Access 1,644
- No Public Access 262
- Restricted Access 255
- Unknown Access 210
AGNCY_LEV 2 ✖
- Special District 2,363
- Joint 8
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
487 | 487 | 486 | {"type": "Polygon", "coordinates": [[[-119.05827, 34.22788], [-119.05689, 34.22789], [-119.05662, 34.22786], [-119.05661, 34.22533], [-119.05785, 34.22532], [-119.05785, 34.22557], [-119.05784, 34.22566], [-119.05788, 34.22578], [-119.05795, 34.22584], [-119.05803, 34.22588], [-119.05815, 34.2259], [-119.05826, 34.22588], [-119.05827, 34.22788]]]} | Open Access 1 | 1684 | Valle Lindo Park | 26770 | 2113 | Pleasant Valley Recreation and Park District 149 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 10.069 | Valle Lindo Park | 0 | Local Park 2 | 4 | |
491 | 491 | 490 | {"type": "Polygon", "coordinates": [[[-119.00089, 34.23254], [-119.0007, 34.23357], [-118.99913, 34.23337], [-118.99889, 34.23332], [-118.99884, 34.23328], [-118.99892, 34.23277], [-118.99894, 34.23232], [-119.00089, 34.23254]]]} | Open Access 1 | 1963 | Woodcreek Park | 27704 | 2113 | Pleasant Valley Recreation and Park District 149 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 4.956 | Woodcreek Park | 0 | Local Park 2 | 4 | |
496 | 496 | 495 | {"type": "Polygon", "coordinates": [[[-117.16142, 32.70441], [-117.16105, 32.7048], [-117.16002, 32.70409], [-117.15894, 32.70438], [-117.15841, 32.70444], [-117.15826, 32.70436], [-117.15952, 32.70313], [-117.16011, 32.70349], [-117.16142, 32.70441]]]} | Open Access 1 | 47480 | San Diego Bayfront Park | 31202 | 2133 | San Diego Unified Port District 186 | Special District 4 | Port/Harbor District 15 | http://www.portofsandiego.org/ | Special District 4 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | https://www.portofsandiego.org/san-diego-bayfront-park.html | San Diego 4 | 5.152 | San Diego Bayfront Park | 0 | Local Park 2 | 4 |
503 | 503 | 502 | {"type": "Polygon", "coordinates": [[[-118.97368, 34.20139], [-118.97368, 34.20163], [-118.97362, 34.20181], [-118.97355, 34.20201], [-118.97325, 34.20261], [-118.9732, 34.20278], [-118.97311, 34.20316], [-118.97299, 34.20341], [-118.97275, 34.20377], [-118.97187, 34.20442], [-118.97113, 34.20556], [-118.96893, 34.20529], [-118.97135, 34.20156], [-118.97201, 34.20157], [-118.97264, 34.20153], [-118.97368, 34.20139]]]} | Open Access 1 | 48367 | Camarillo Grove Park | 32933 | 2113 | Pleasant Valley Recreation and Park District 149 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/parks/park_list/camarillo_grove_park.asp | Ventura 8 | 25.264 | Camarillo Grove Park | 0 | Local Park 2 | 4 |
515 | 515 | 514 | {"type": "Polygon", "coordinates": [[[-118.67368, 34.2754], [-118.67345, 34.2754], [-118.67293, 34.27548], [-118.67292, 34.27601], [-118.67213, 34.2753], [-118.67207, 34.27515], [-118.67207, 34.27372], [-118.67302, 34.27372], [-118.67356, 34.27375], [-118.67356, 34.27402], [-118.67368, 34.27412], [-118.67368, 34.2754]]]} | Open Access 1 | 1716 | Verde Park | 26986 | 2118 | Rancho Simi Recreation and Park District 80 | Special District 4 | Recreation/Parks District 4 | http://www.rsrpd.org/ | Special District 4 | 2118 | Rancho Simi Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 7.268 | Verde Park | 0 | Local Park 2 | 4 | |
540 | 540 | 539 | {"type": "Polygon", "coordinates": [[[-118.8993, 34.1842], [-118.89897, 34.18424], [-118.89814, 34.18437], [-118.89767, 34.18434], [-118.89715, 34.18448], [-118.89638, 34.18443], [-118.89611, 34.18408], [-118.89593, 34.18404], [-118.89683, 34.18341], [-118.8969, 34.18346], [-118.89768, 34.18368], [-118.89819, 34.18346], [-118.89872, 34.18292], [-118.89889, 34.18303], [-118.89887, 34.18356], [-118.8993, 34.1842]]]} | Open Access 1 | 1801 | Walnut Grove Park | 27233 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 6.623 | Walnut Grove Park | 0 | Local Park 2 | 4 | |
544 | 544 | 543 | {"type": "Polygon", "coordinates": [[[-119.01467, 34.22283], [-119.01414, 34.22287], [-119.01409, 34.22258], [-119.01399, 34.22232], [-119.0138, 34.22197], [-119.0135, 34.22159], [-119.01349, 34.22154], [-119.01351, 34.2215], [-119.01392, 34.22133], [-119.01404, 34.2213], [-119.01415, 34.22121], [-119.01463, 34.22119], [-119.01467, 34.22283]]]} | Open Access 1 | 1813 | Calleguas Creek Park | 16738 | 2113 | Pleasant Valley Recreation and Park District 149 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 3.236 | Calleguas Creek Park | 0 | Local Park 2 | 4 | |
547 | 547 | 546 | {"type": "Polygon", "coordinates": [[[-118.85957, 34.20397], [-118.85928, 34.20419], [-118.85956, 34.20468], [-118.85943, 34.20577], [-118.85902, 34.20577], [-118.85882, 34.2057], [-118.85753, 34.20575], [-118.85776, 34.20423], [-118.85881, 34.20412], [-118.85882, 34.20405], [-118.85957, 34.20397]]]} | Open Access 1 | 1822 | Waverly Park | 27320 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 7.419 | Waverly Park | 0 | Local Park 2 | 4 | |
558 | 558 | 557 | {"type": "Polygon", "coordinates": [[[-117.10871, 33.60376], [-117.10807, 33.60376], [-117.10803, 33.6038], [-117.10795, 33.60373], [-117.108, 33.60362], [-117.10791, 33.60312], [-117.10865, 33.60308], [-117.10871, 33.60312], [-117.10871, 33.60376]]]} | Open Access 1 | 48385 | Primrose Park | 32949 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/primrose-park | Riverside 10 | 1.259 | Primrose Park | 0 | Local Park 2 | 4 |
592 | 592 | 591 | {"type": "Polygon", "coordinates": [[[-121.94024, 38.01658], [-121.93978, 38.01658], [-121.93977, 38.01672], [-121.93947, 38.01673], [-121.9395, 38.01832], [-121.93948, 38.01832], [-121.93914, 38.01842], [-121.93876, 38.01847], [-121.93842, 38.01836], [-121.93821, 38.01832], [-121.93821, 38.01825], [-121.93793, 38.01815], [-121.9373, 38.01768], [-121.93773, 38.01605], [-121.94023, 38.01603], [-121.94024, 38.01658]]]} | Open Access 1 | 2015 | Ambrose Park | 15445 | 2001 | Ambrose Recreation and Park District 217 | Special District 4 | Recreation/Parks District 4 | http://www.ambroserec.org/ | Special District 4 | 2001 | Ambrose Recreation and Park District 213 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 11.746 | Ambrose Park | 0 | Local Park 2 | 4 | |
783 | 783 | 782 | {"type": "Polygon", "coordinates": [[[-122.09551, 37.63544], [-122.09549, 37.63615], [-122.0955, 37.63682], [-122.09501, 37.63684], [-122.09505, 37.63746], [-122.09413, 37.63754], [-122.0942, 37.63815], [-122.09387, 37.63819], [-122.09387, 37.63901], [-122.09249, 37.63911], [-122.09222, 37.63912], [-122.0919, 37.63901], [-122.09449, 37.63532], [-122.09496, 37.63539], [-122.09551, 37.63544]]]} | Open Access 1 | 5069 | Southgate Park | 25689 | 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 | 14.46 | Southgate Park | 1965 | Local Park 2 | 4 | |
800 | 800 | 799 | {"type": "Polygon", "coordinates": [[[-116.73692, 33.70731], [-116.73692, 33.70798], [-116.73675, 33.71539], [-116.73248, 33.71537], [-116.73258, 33.70742], [-116.73272, 33.70733], [-116.73692, 33.70731]]]} | Open Access 1 | 5190 | McCall Memorial Park | 21990 | 2123 | Riverside County Regional Park and Open Space District 262 | Special District 4 | Recreation/Parks District 4 | http://www.riversidecountyparks.org/ | Special District 4 | 2123 | Riverside County Regional Park and Open Space District 258 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 88.363 | McCall Memorial Park | 0 | Local Park 2 | 4 | |
818 | 818 | 817 | {"type": "Polygon", "coordinates": [[[-117.1878, 34.44347], [-117.18605, 34.44348], [-117.18605, 34.44269], [-117.18779, 34.44268], [-117.1878, 34.44347]]]} | Open Access 1 | 5287 | Mendel Park | 22148 | 2200 | Apple Valley Recreation and Park District 267 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 3.478 | Mendel Park | 0 | Local Park 2 | 4 | ||
872 | 872 | 871 | {"type": "Polygon", "coordinates": [[[-120.34928, 36.13978], [-120.34751, 36.13979], [-120.34749, 36.13797], [-120.34786, 36.13796], [-120.34785, 36.13675], [-120.34924, 36.13666], [-120.34928, 36.13978]]]} | Open Access 1 | 5613 | Olsen Park | 23139 | 2021 | Coalinga-Huron Recreation and Park District 275 | Special District 4 | Recreation/Parks District 4 | http://www.chrpd.org/ | Special District 4 | 2021 | Coalinga-Huron Recreation and Park District 270 | Special District 4 | Recreation/Parks District 4 | Fresno 9 | 12.316 | Olsen Park | 0 | Local Park 2 | 4 | |
910 | 910 | 909 | {"type": "Polygon", "coordinates": [[[-117.21458, 34.53082], [-117.21419, 34.53082], [-117.21418, 34.53128], [-117.21261, 34.53128], [-117.2126, 34.53013], [-117.21265, 34.53009], [-117.21457, 34.53009], [-117.21458, 34.53082]]]} | Open Access 1 | 5810 | Thunderbird Park | 26338 | 2200 | Apple Valley Recreation and Park District 267 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 5.461 | Thunderbird Park | 0 | Local Park 2 | 4 | ||
914 | 914 | 913 | {"type": "Polygon", "coordinates": [[[-116.21951, 33.73621], [-116.21842, 33.7359], [-116.21755, 33.73558], [-116.21752, 33.73455], [-116.21811, 33.73476], [-116.21947, 33.73475], [-116.21951, 33.73621]]]} | Open Access 1 | 5922 | North Jackson Park | 22825 | 2216 | Desert Recreation District 286 | Special District 4 | Recreation/Parks District 4 | http://www.myrecreationdistrict.com | Special District 4 | 2216 | Desert Recreation District 282 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 5.877 | North Jackson Park | 0 | Local Park 2 | 4 | |
938 | 938 | 937 | {"type": "MultiPolygon", "coordinates": [[[[-118.69792, 34.10714], [-118.69353, 34.10711], [-118.68501, 34.10711], [-118.68487, 34.09988], [-118.69337, 34.09987], [-118.69287, 34.10126], [-118.69282, 34.10153], [-118.69283, 34.10168], [-118.69285, 34.10183], [-118.69297, 34.10211], [-118.69307, 34.10225], [-118.69318, 34.10237], [-118.69338, 34.10253], [-118.69352, 34.10262], [-118.69383, 34.10273], [-118.69404, 34.10277], [-118.69426, 34.10279], [-118.69447, 34.10278], [-118.69662, 34.10254], [-118.69692, 34.10254], [-118.69721, 34.10256], [-118.69791, 34.10269], [-118.69792, 34.10714]]], [[[-118.71106, 34.10003], [-118.711, 34.10008], [-118.711, 34.1006], [-118.71099, 34.10061], [-118.71099, 34.10066], [-118.711, 34.10067], [-118.71101, 34.10229], [-118.70867, 34.10291], [-118.70755, 34.10261], [-118.70751, 34.10269], [-118.70732, 34.10264], [-118.70735, 34.10256], [-118.70735, 34.10227], [-118.70701, 34.10227], [-118.70646, 34.10285], [-118.70647, 34.10286], [-118.70927, 34.1046], [-118.70848, 34.10476], [-118.70774, 34.10486], [-118.70724, 34.10489], [-118.70674, 34.10489], [-118.706, 34.10485], [-118.70526, 34.10476], [-118.70453, 34.1046], [-118.70406, 34.10447], [-118.70337, 34.10423], [-118.70141, 34.10334], [-118.70104, 34.10319], [-118.70066, 34.10306], [-118.70008, 34.10291], [-118.69741, 34.10236], [-118.69709, 34.10233], [-118.69661, 34.10232], [-118.69444, 34.10256], [-118.69422, 34.10257], [-118.69401, 34.10254], [-118.69371, 34.10245], [-118.69353, 34.10235], [-118.69339, 34.10223], [-118.69327, 34.1021], [-118.69318, 34.10195], [-118.69312, 34.10179], [-118.6931, 34.10163], [-118.6931, 34.10146], [-118.69314, 34.1013], [-118.69364, 34.09988], [-118.70399, 34.09987], [-118.7067, 34.09985], [-118.71106, 34.0999], [-118.71106, 34.10003]]], [[[-118.70669, 34.09625], [-118.7023, 34.09625], [-118.70229, 34.09806], [-118.70011, 34.09807], [-118.7001, 34.09625], [-118.70228, 34.09625], [-118.70228, 34.09551], [-118.70342, 34.09546], [-118.70406, 34.09465], [-118.70491, 34.09451], [-118.70605, 34.09381], [-118.70636, 34.09308], [-118.70669, 34.09361], [-118.70669, 34.09625]]], [[[-118.70669, 34.09336], [-118.70649, 34.09304], [-118.70669, 34.09297], [-118.70669, 34.09329], [-118.70669, 34.09336]]]]} | Open Access 1 | 6489 | King Gillette Ranch | 7140 | 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 | http://www.lamountains.com/parks.asp?parkid=670 | Los Angeles 6 | 383.837 | King Gillette Ranch | 0 | Local Park 2 | 4 |
944 | 944 | 943 | {"type": "Polygon", "coordinates": [[[-118.31116, 33.76052], [-118.31051, 33.76273], [-118.30904, 33.76256], [-118.30904, 33.76051], [-118.31116, 33.76052]]]} | Open Access 1 | 5973 | Eastview Park | 18401 | 2139 | Sanitation Districts of Los Angeles County 290 | Special District 4 | Sanitation District 18 | http://www.lacsd.org/ | Special District 4 | 1265 | Rancho Palos Verdes, City of 283 | City 2 | City Agency 2 | Los Angeles 6 | 9.81 | Eastview Park | 0 | Local Park 2 | 4 | |
957 | 957 | 956 | {"type": "Polygon", "coordinates": [[[-119.86245, 34.41488], [-119.86245, 34.41514], [-119.86157, 34.41513], [-119.86153, 34.41509], [-119.86147, 34.41507], [-119.86127, 34.41513], [-119.86127, 34.41487], [-119.86245, 34.41488]]]} | Open Access 1 | 6027 | Childrens Park | 17198 | 2049 | Isla Vista Recreation and Park District 174 | Special District 4 | Recreation/Parks District 4 | http://www.ivparks.org/ | Special District 4 | 2049 | Isla Vista Recreation and Park District 170 | Special District 4 | Recreation/Parks District 4 | Santa Barbara 7 | 0.744 | Childrens Park | 0 | Local Park 2 | 4 | |
980 | 980 | 979 | {"type": "MultiPolygon", "coordinates": [[[[-117.10428, 32.62561], [-117.10272, 32.62605], [-117.10268, 32.62598], [-117.10278, 32.62597], [-117.10427, 32.62555], [-117.10428, 32.62561]]], [[[-117.10838, 32.62958], [-117.10777, 32.62978], [-117.10679, 32.62795], [-117.10655, 32.62786], [-117.10661, 32.62779], [-117.10544, 32.62575], [-117.10444, 32.6258], [-117.10439, 32.62564], [-117.10433, 32.62565], [-117.10431, 32.62554], [-117.1058, 32.62514], [-117.10838, 32.62958]]]]} | Open Access 1 | 5495 | Bayside Park | 15899 | 2133 | San Diego Unified Port District 186 | Special District 4 | Port/Harbor District 15 | http://www.portofsandiego.org/ | Special District 4 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | https://www.portofsandiego.org/chula-vista-bayside-park.html | San Diego 4 | 9.299 | Bayside 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]);