units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,190 rows where DES_TP = 14 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_LEV, PARK_URL, COUNTY, LABEL_NAME, YR_EST
MNG_AGENCY 214
- Mountains Recreation and Conservation Authority 152
- Ventura, City of 106
- Butte, County of 52
- Yuba County Water Agency 48
- Roseville, City of 46
- Santa Barbara, County of 39
- Lake, County of 36
- Poway, City of 35
- Irvine, City of 29
- Los Angeles, City of 26
- California City, City of 25
- Encinitas, City of 21
- Orange, County of 21
- Napa, City of 21
- Monterey, County of 18
- Rocklin, City of 17
- Seaside, City of 16
- San Diego, City of 15
- Lompoc, City of 14
- Los Angeles County Flood Control District 13
- Santa Cruz, City of 12
- Santa Barbara Flood Control and Water Conserv. District 12
- Oroville, City of 12
- Los Angeles, County of 11
- Santa Barbara, City of 11
- Mammoth Lakes, Town of 11
- Auburn, City of 11
- Guadalupe, City of 10
- Santa Maria, City of 9
- Escondido, City of 9
- San Lorenzo Valley Water District 9
- La Selva Beach Recreation District 8
- Watsonville, City of 7
- Scotts Valley, City of 7
- Torrance, City of 7
- San Luis Obispo, City of 6
- Los Angeles - Department of Water and Power, City of 6
- Sacramento, County of 6
- San Francisco - Public Utilities Commission, City and County of 5
- Salinas, City of 5
- Anaheim, City of 5
- Ventura, County of 5
- Stockton, City of 5
- Santa Cruz, County of 4
- San Diego, County of 4
- San Marcos, City of 4
- Marina, City of 4
- Morgan Hill, City of 4
- Lincoln, City of 4
- Calistoga, City of 4
- Pleasanton, City of 3
- Marin County Open Space District 3
- Solvang, City of 3
- Tulare, County of 3
- Riverside, County of 3
- Moorpark, City of 3
- Woodlake, City of 3
- Reedley, City of 3
- Clovis, City of 3
- Gridley, City of 3
- Ripon, City of 3
- Scotts Valley Water District 3
- Natomas Basin Conservancy 3
- Rio Dell, City of 3
- Santa Clara Valley Water District 3
- Patterson, City of 2
- San Francisco, City and County of 2
- Monterey, City of 2
- Carpinteria, City of 2
- Vista, City of 2
- Livermore, City of 2
- Hayward Area Recreation and Park District 2
- Riverside County Regional Park and Open Space District 2
- Fountain Valley, City of 2
- Rancho Palos Verdes, City of 2
- Orange, City of 2
- Hanford, City of 2
- Sonoma, City of 2
- Imperial Irrigation District 2
- Pittsburg, City of 2
- Sonoma County Agricultural Preservation and Open Space District 2
- American Canyon, City of 2
- Merced, County of 2
- Modesto, City of 2
- Vallejo, City of 2
- Winters, City of 2
- Truckee Tahoe Airport District 2
- North County Recreation and Park District 2
- Stanton, City of 2
- Orange County Water District 2
- Westfield Recreation and Park District 2
- Ramona Municipal Water District 2
- Western Riverside County Regional Conservation Authority 2
- Fortuna, City of 2
- Oakdale, City of 1
- Seal Beach, City of 1
- Claremont, City of 1
- Conejo Recreation and Park District 1
- Fresno, City of 1
- Santa Ana, City of 1
- San Jose, City of 1
- Santee, City of 1
- Victorville, City of 1
- Monterey Peninsula Regional Park District 1
- Newport Beach, City of 1
- South San Francisco, City of 1
- Oceanside, City of 1
- Coachella, City of 1
- Oxnard, City of 1
- Redlands, City of 1
- Napa County Regional Park and Open Space District 1
- Paso Robles, City of 1
- Chula Vista, City of 1
- Dana Point, City of 1
- Petaluma, City of 1
- Vacaville, City of 1
- Visalia, City of 1
- Fontana, City of 1
- Davis, City of 1
- Goleta, City of 1
- Laguna Beach, City of 1
- San Leandro, City of 1
- Loma Linda, City of 1
- Sonoma County Regional Parks Dept., County of 1
- Dos Palos, City of 1
- Fairfield, City of 1
- Placer, County of 1
- San Jacinto, City of 1
- Cerritos, City of 1
- Mill Valley, City of 1
- San Joaquin, City of 1
- Sanger, City of 1
- Lake Forest, City of 1
- Marin Municipal Water District 1
- Tustin, City of 1
- Paramount, City of 1
- Whittier, City of 1
- Long Beach, City of 1
- Pasadena, City of 1
- South Pasadena, City of 1
- Tehachapi, City of 1
- Monrovia, City of 1
- Diamond Bar, City of 1
- Benicia, City of 1
- Imperial, County of 1
- Antioch, City of 1
- San Rafael, City of 1
- San Clemente, City of 1
- San Bernardino, County of 1
- Lemoore, City of 1
- Fremont, City of 1
- North of the River Recreation and Park District 1
- Burlingame, City of 1
- Concord, City of 1
- Redwood City, City of 1
- Redding, City of 1
- Metropolitan Water District of Southern California 1
- Sunnyvale, City of 1
- Parlier, City of 1
- Dixon, City of 1
- Corte Madera, Town of 1
- Foster City, City of 1
- Lomita, City of 1
- Atwater, City of 1
- Santa Clara Valley Open Space Authority 1
- Soledad, City of 1
- Red Bluff, City of 1
- Napa, County of 1
- Newman, City of 1
- Sacramento, City of 1
- Yolo, County of 1
- Woodland, City of 1
- Humboldt, County of 1
- Olivehurst Public Utility District 1
- Folsom, City of 1
- Riverside County Habitat Conservation Agency 1
- Tehama, County of 1
- Sacramento Regional County Sanitation District 1
- Soquel Creek Water District 1
- Calexico, City of 1
- Galt, City of 1
- Sacramento and San Joaquin Drainage District 1
- Brisbane, City of 1
- Coloma-Lotus 1
- Blue Lake, City of 1
- Trinidad, City of 1
- Fresno Metropolitan Flood Control District 1
- Williams, City of 1
- Ridgecrest, City of 1
- Borrego Water District 1
- Orange County Department of Education, County of 1
- Alameda County Flood Control and Water Conservation District 1
- Soledad-Mission Recreation District 1
- Helix Water District 1
- California Reclamation District 2140 1
- Point Arena, City of 1
- Georgetown Divide Recreation District 1
- Coalinga, City of 1
- Coachella Valley Association of Governments 1
- Watershed Conservation Authority 1
- Olivenhain Municipal Water District 1
- Coastside County Water District 1
- Marina County Water District 1
- Aptos Sanitation District 1
- Marin Public Works Dept/Flood Control 1
- Novato Sanitary District 1
- Santa Ynez River Water Conservation District 1
- Modesto Irrigation District 1
- Turlock Irrigation District 1
- Trinity, County of 1
- Marin, County of 1
- Solano, County of 1
- North County Transit District 1
- Pasadena Department of Water and Power 1
MNG_AG_TYP 15
- City Agency 663
- County Agency 214
- Open Space District 155
- Water District 78
- Flood District 32
- Recreation/Parks District 28
- County Agency - Other 6
- Irrigation District 4
- Sanitation District 3
- Community Services District 2
- County Agency - Parks 1
- Special District - Other 1
- Metropolitan Planning Organization 1
- Conservation District 1
- Transportation Agency 1
ACCESS_TYP 4
- Open Access 859
- Unknown Access 204
- No Public Access 96
- Restricted Access 31
DES_TP 1
- Local Other or Unknown · 1,190 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3770 | 3770 | 3769 | {"type": "Polygon", "coordinates": [[[-121.40978, 39.0321], [-121.40886, 39.03318], [-121.40825, 39.0338], [-121.40801, 39.03396], [-121.40738, 39.03562], [-121.40691, 39.03607], [-121.40665, 39.03623], [-121.40644, 39.03625], [-121.40543, 39.03614], [-121.40505, 39.03582], [-121.40453, 39.0351], [-121.40393, 39.0349], [-121.40344, 39.03488], [-121.40287, 39.03514], [-121.4026, 39.03562], [-121.40242, 39.03625], [-121.40184, 39.0353], [-121.40342, 39.03459], [-121.40368, 39.03458], [-121.40502, 39.03496], [-121.40768, 39.03386], [-121.40806, 39.03357], [-121.40923, 39.03229], [-121.40961, 39.0318], [-121.40978, 39.0321]]]} | Unknown Access 4 | 472 | Dry Creek | 18279 | 2127 | Sacramento and San Joaquin Drainage District 681 | Special District 4 | Flood District 8 | Special District 4 | 2127 | Sacramento and San Joaquin Drainage District 671 | Special District 4 | Flood District 9 | Yuba 25 | 15.587 | Dry Creek | 0 | Local Other or Unknown 14 | 4 | ||
4492 | 4492 | 4491 | {"type": "Polygon", "coordinates": [[[-118.35128, 33.78024], [-118.35122, 33.78036], [-118.35108, 33.78051], [-118.35086, 33.78065], [-118.35069, 33.7807], [-118.35057, 33.78035], [-118.35093, 33.78032], [-118.35092, 33.78], [-118.35108, 33.78], [-118.35119, 33.78003], [-118.35127, 33.78011], [-118.35128, 33.78024]]]} | Open Access 1 | 5914 | Unnamed site - Westfield Recreation and Park District | 28676 | 2180 | Westfield Recreation and Park District 769 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2180 | Westfield Recreation and Park District 750 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 0.653 | 0 | Local Other or Unknown 14 | 4 | |||
4493 | 4493 | 4492 | {"type": "Polygon", "coordinates": [[[-118.36086, 33.76832], [-118.3608, 33.76862], [-118.36056, 33.76861], [-118.36041, 33.76865], [-118.36031, 33.76842], [-118.36043, 33.76817], [-118.36086, 33.76832]]]} | Open Access 1 | 5915 | Unknown park - Westfield Recreation and Park District | 28677 | 2180 | Westfield Recreation and Park District 769 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2180 | Westfield Recreation and Park District 750 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 0.462 | 0 | Local Other or Unknown 14 | 4 | |||
4927 | 4927 | 4926 | {"type": "Polygon", "coordinates": [[[-120.57718, 34.95846], [-120.57722, 34.95871], [-120.57726, 34.95884], [-120.57749, 34.95931], [-120.57749, 34.95936], [-120.57745, 34.95938], [-120.57717, 34.95939], [-120.57718, 34.95846]]]} | Open Access 1 | 35362 | Guadalupe holding 1 | 19545 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 0.328 | Guadalupe holding 1 | 0 | Local Other or Unknown 14 | 4 | ||
4928 | 4928 | 4927 | {"type": "Polygon", "coordinates": [[[-120.58052, 34.96254], [-120.58034, 34.96267], [-120.57983, 34.9626], [-120.57981, 34.9625], [-120.58012, 34.96231], [-120.58041, 34.96249], [-120.58052, 34.96254]]]} | Open Access 1 | 35363 | Guadalupe holding 2 | 19547 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 0.371 | Guadalupe holding 2 | 0 | Local Other or Unknown 14 | 4 | ||
5141 | 5141 | 5140 | {"type": "Polygon", "coordinates": [[[-120.57892, 34.964], [-120.57887, 34.96401], [-120.57829, 34.96412], [-120.57829, 34.964], [-120.57892, 34.964]]]} | Open Access 1 | 35415 | Guadalupe holding 6 | 19551 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 0.1 | Guadalupe holding 6 | 0 | Local Other or Unknown 14 | 4 | ||
10640 | 10640 | 10639 | {"type": "Polygon", "coordinates": [[[-120.11817, 34.66507], [-120.11816, 34.66546], [-120.11783, 34.66545], [-120.11784, 34.66507], [-120.11817, 34.66507]]]} | Unknown Access 4 | 18982 | Alamo Pintado Creek | 15319 | 2147 | Santa Ynez River Water Conservation District 953 | Special District 4 | Water District 13 | Special District 4 | 2147 | Santa Ynez River Water Conservation District 925 | Special District 4 | Water District 13 | Santa Barbara 7 | 0.321 | Alamo Pintado Creek | 0 | Local Other or Unknown 14 | 4 | ||
13147 | 13147 | 13146 | {"type": "Polygon", "coordinates": [[[-120.58049, 34.96217], [-120.58041, 34.96249], [-120.58017, 34.96234], [-120.58038, 34.96212], [-120.58049, 34.96217]]]} | Open Access 1 | 35256 | Guadalupe holding 7 | 19552 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 0.158 | Guadalupe holding 7 | 0 | Local Other or Unknown 14 | 4 | ||
13233 | 13233 | 13232 | {"type": "Polygon", "coordinates": [[[-120.57104, 34.97032], [-120.57096, 34.97044], [-120.57051, 34.97024], [-120.57058, 34.97012], [-120.57104, 34.97032]]]} | Open Access 1 | 35277 | Guadalupe holding 10 | 19546 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 0.174 | Guadalupe holding 10 | 0 | Local Other or Unknown 14 | 4 | ||
13234 | 13234 | 13233 | {"type": "Polygon", "coordinates": [[[-120.57752, 34.96378], [-120.57752, 34.96399], [-120.57714, 34.96399], [-120.57714, 34.96377], [-120.57752, 34.96378]]]} | Unknown Access 4 | 35278 | Guadalupe holding 9 | 19554 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 0.206 | Guadalupe holding 9 | 0 | Local Other or Unknown 14 | 4 | ||
13237 | 13237 | 13236 | {"type": "Polygon", "coordinates": [[[-120.57643, 34.96381], [-120.57642, 34.96423], [-120.57588, 34.96423], [-120.57589, 34.96395], [-120.57624, 34.96395], [-120.57625, 34.96381], [-120.57643, 34.96381]]]} | Open Access 1 | 35281 | Guadalupe holding 8 | 19553 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 0.436 | Guadalupe holding 8 | 0 | Local Other or Unknown 14 | 4 | ||
13305 | 13305 | 13304 | {"type": "Polygon", "coordinates": [[[-120.5712, 34.97007], [-120.57104, 34.97032], [-120.57058, 34.97012], [-120.5709, 34.96963], [-120.57109, 34.96971], [-120.57094, 34.96996], [-120.5712, 34.97007]]]} | Open Access 1 | 35367 | Guadalupe holding 3 | 19548 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 0.514 | Guadalupe holding 3 | 0 | Local Other or Unknown 14 | 4 | ||
13306 | 13306 | 13305 | {"type": "Polygon", "coordinates": [[[-120.57089, 34.97056], [-120.57073, 34.9708], [-120.57028, 34.97061], [-120.57051, 34.97024], [-120.57088, 34.9704], [-120.57081, 34.97052], [-120.57089, 34.97056]]]} | Open Access 1 | 35368 | Guadalupe holding 4 | 19549 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 0.5 | Guadalupe holding 4 | 0 | Local Other or Unknown 14 | 4 | ||
13339 | 13339 | 13338 | {"type": "Polygon", "coordinates": [[[-120.58072, 34.9624], [-120.58052, 34.96254], [-120.58041, 34.96249], [-120.58049, 34.96217], [-120.58062, 34.96216], [-120.58072, 34.9624]]]} | Open Access 1 | 35417 | Guadalupe holding 5 | 19550 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 0.189 | Guadalupe holding 5 | 0 | Local Other or Unknown 14 | 4 | ||
15528 | 15528 | 15527 | {"type": "Polygon", "coordinates": [[[-120.63297, 36.97684], [-120.63292, 36.97688], [-120.63232, 36.97688], [-120.63228, 36.97685], [-120.63228, 36.97652], [-120.63297, 36.97652], [-120.63297, 36.97684]]]} | Open Access 1 | 48941 | Unknown park - Dos Palos, City of | 33657 | 1460 | Dos Palos, City of 194 | City 2 | City Agency 2 | City 2 | 1460 | Dos Palos, City of 190 | City 2 | City Agency 2 | Merced 37 | 0.607 | 0 | Local Other or Unknown 14 | 4 | |||
4548 | 4548 | 4547 | {"type": "Polygon", "coordinates": [[[-121.79158, 37.67939], [-121.79158, 37.67946], [-121.79149, 37.67979], [-121.79049, 37.6798], [-121.78952, 37.6799], [-121.78852, 37.67912], [-121.78813, 37.67868], [-121.78776, 37.6781], [-121.78856, 37.67806], [-121.78921, 37.67793], [-121.78982, 37.67789], [-121.79032, 37.67778], [-121.79055, 37.67842], [-121.79149, 37.67827], [-121.79153, 37.67865], [-121.79159, 37.67899], [-121.79158, 37.67939]]]} | Open Access 1 | 22291 | Unnamed site - Alameda County Flood Control and Water Conservation District | 28716 | 2000 | Alameda County Flood Control and Water Conservation District 771 | Special District 4 | Flood District 8 | http://acfloodcontrol.org/ | Special District 4 | 2000 | Alameda County Flood Control and Water Conservation District 752 | Special District 4 | Flood District 9 | Alameda 17 | 13.147 | 0 | Local Other or Unknown 14 | 4 | ||
13623 | 13623 | 13622 | {"type": "Polygon", "coordinates": [[[-123.9952, 40.88232], [-123.99346, 40.88304], [-123.99352, 40.88318], [-123.99339, 40.88307], [-123.99237, 40.8823], [-123.99232, 40.88233], [-123.99196, 40.88206], [-123.99202, 40.88201], [-123.99228, 40.88221], [-123.99325, 40.88144], [-123.9952, 40.88232]]]} | Open Access 1 | 36330 | Blue Lake holding 1 | 16178 | 1443 | Blue Lake, City of 716 | City 2 | City Agency 2 | http://bluelake.ca.gov/ | City 2 | 1443 | Blue Lake, City of 699 | City 2 | City Agency 2 | Humboldt 45 | 5.606 | Blue Lake holding 1 | 0 | Local Other or Unknown 14 | 4 | |
3475 | 3475 | 3474 | {"type": "Polygon", "coordinates": [[[-117.81584, 35.18562], [-117.81582, 35.18618], [-117.8141, 35.18621], [-117.81412, 35.18564], [-117.81584, 35.18562]]]} | Open Access 1 | 35797 | California City holding 16 | 16696 | 1041 | California City, City of 482 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1041 | California City, City of 474 | City 2 | City Agency 2 | Kern 36 | 2.424 | California City holding 16 | 0 | Local Other or Unknown 14 | 4 | |
3886 | 3886 | 3885 | {"type": "Polygon", "coordinates": [[[-117.82685, 35.25106], [-117.82674, 35.25113], [-117.82627, 35.25163], [-117.82615, 35.25189], [-117.8261, 35.25307], [-117.82591, 35.25347], [-117.82372, 35.25348], [-117.82367, 35.25201], [-117.82381, 35.25191], [-117.82507, 35.25133], [-117.82579, 35.25117], [-117.82685, 35.25106]]]} | Open Access 1 | 35754 | California City holding 22 | 16703 | 1041 | California City, City of 482 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1041 | California City, City of 474 | City 2 | City Agency 2 | Kern 36 | 12.685 | California City holding 22 | 0 | Local Other or Unknown 14 | 4 | |
13397 | 13397 | 13396 | {"type": "Polygon", "coordinates": [[[-117.65941, 35.24431], [-117.65836, 35.24432], [-117.65836, 35.24364], [-117.65828, 35.24315], [-117.65816, 35.24293], [-117.65919, 35.24387], [-117.65941, 35.24431]]]} | Open Access 1 | 35523 | California City holding 5 | 16709 | 1041 | California City, City of 482 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1041 | California City, City of 474 | City 2 | City Agency 2 | Kern 36 | 1.923 | California City holding 5 | 0 | Local Other or Unknown 14 | 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]);