units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,203 rows where ACCESS_TYP = 2 sorted by DES_TP
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_LEV, MNG_AG_ID, PARK_URL, YR_EST
MNG_AGENCY 403
- California Department of Fish and Wildlife 71
- University of California 47
- United States Fish and Wildlife Service 41
- Woodbridge Village Association 31
- Home Owners Association - Unknown Name 27
- Sacramento, County of 23
- Los Angeles, City of 20
- Whittier, City of 20
- East Bay Regional Park District 19
- Rancho Santa Margarita Landscape and Recreation Corporation 18
- Sempervirens Fund 16
- Los Angeles Unified School District 16
- San Ramon, City of 15
- Los Angeles, County of 14
- The Nature Conservancy 14
- Land Trust of Napa County 14
- Big Sur Land Trust 14
- United States Bureau of Land Management 12
- California Department of Parks and Recreation 11
- San Diego, City of 10
- San Francisco - Public Utilities Commission, City and County of 10
- Sonoma Land Trust 9
- Long Beach, City of 9
- United States National Park Service 8
- Arcadia, City of 8
- Sonoma County Agricultural Preservation and Open Space District 8
- Manhattan Beach, City of 8
- Santa Cruz, City of 7
- Hayward Area Recreation and Park District 7
- Amerige Heights Community Association 7
- Los Angeles - Department of Parks and Recreation, County of 7
- Modesto, City of 7
- San Jose, City of 6
- Carlsbad, City of 6
- United States Army Corps of Engineers 6
- Hollister, City of 6
- Pasadena, City of 6
- United States Bureau of Reclamation 6
- San Diego State University 6
- Santa Ana, City of 5
- Center for Natural Lands Management 5
- Fullerton, City of 5
- Orange, County of 5
- Vacaville, City of 5
- San Bernardino, City of 5
- Beverly Hills, City of 5
- Solano Land Trust 5
- Lawndale, City of 5
- Truckee Donner Land Trust 5
- San Gabriel, City of 5
- Rivers and Lands Conservancy 5
- Monterey Peninsula Regional Park District 4
- Glendora, City of 4
- Sequoia Riverlands Trust 4
- Land Trust of Santa Cruz County 4
- El Segundo, City of 4
- Stockton, City of 4
- Mountain View, City of 4
- Santa Clara Valley Open Space Authority 4
- Conejo Open Space Conservation Agency 4
- Santa Clara Valley Habitat Agency 4
- Roseville, City of 4
- South El Monte, City of 4
- Save Mount Diablo 4
- National Audubon Society 4
- Paseo Westpark Maintenance Association 4
- Deerfield Community Association 4
- Nellie Gail Ranch Owners Association 4
- Azusa Unified School District 4
- San Diego River Park Foundation 4
- Santa Clara Valley Water District 4
- California State Coastal Conservancy 4
- Westpark Maintenance District 4
- Sierra Bonita Community Association 4
- Town Center Association 4
- Conejo Recreation and Park District 3
- Watsonville, City of 3
- San Luis Obispo, City of 3
- California State Lands Commission 3
- Oceanside, City of 3
- San Diego, County of 3
- Pomona, City of 3
- Other State 3
- Burbank, City of 3
- Palmdale, City of 3
- Cerritos, City of 3
- The Wildlands Conservancy 3
- Needles, City of 3
- Torrance, City of 3
- South Pasadena, City of 3
- Peninsula Open Space Trust 3
- Livermore Area Recreation and Park District 3
- Quail Hill Community Association 3
- East Bay Municipal Utility District 3
- American Canyon, City of 3
- California Department of Water Resources 3
- Conejo Valley Unified School District 3
- United States Coast Guard 3
- Mountains Restoration Trust 3
- Sacramento, City of 3
- The Conservation Fund - California 3
- Private Landowner 3
- Watershed Conservation Authority 3
- East Highlands Ranch MHOA 3
- Northpark Square Maintenance Association 3
- Turtle Rock Broadmoor Community Association 3
- Oakdale, City of 2
- Santa Cruz, County of 2
- San Luis Obispo, County of 2
- Fresno, City of 2
- San Francisco, City and County of 2
- Santa Barbara, City of 2
- Mountains Recreation and Conservation Authority 2
- Santa Rosa, City of 2
- Encinitas, City of 2
- Save the Redwoods League 2
- Garden Grove, City of 2
- Rancho Simi Recreation and Park District 2
- Santa Lucia Conservancy 2
- Sonoma County Water Agency 2
- Bear Yuba Land Trust 2
- Glendale, City of 2
- Coronado, City of 2
- Ventura, City of 2
- Seaside, City of 2
- Dublin, City of 2
- Davis, City of 2
- Walnut Creek, City of 2
- Lake Elsinore, City of 2
- Summerly Homes 2
- Riverside, City of 2
- Ventura, County of 2
- LandPaths 2
- Bell Gardens, City of 2
- Brea, City of 2
- El Monte, City of 2
- Land Trust for Santa Barbara County 2
- Other Federal 2
- Gardena, City of 2
- Sierra Madre, City of 2
- Fallbrook Land Conservancy 2
- Santa Catalina Island Conservancy 2
- Oak Creek Village Maintenance Association 2
- Gilroy, City of 2
- Sunnyvale, City of 2
- Corte Madera, Town of 2
- Napa, City of 2
- Santa Clara County Parks and Recreation Dept., County of 2
- California City, City of 2
- Southgate Recreation and Park District 2
- United States Department of Defense 2
- Los Angeles Neighborhood Land Trust 2
- Lake County Land Trust 2
- American River Conservancy 2
- Midpeninsula Regional Open Space District 2
- Truckee Tahoe Airport District 2
- Broadmoor Campus View Community Association 2
- San Gabriel Unified School District 2
- Nonprofit Organization - Unknown 2
- Culver City Unified School District 2
- Big League Dreams 2
- Woodbridge Owners Association 2
- Northpark Maintenance Association 2
- Los Nietos School District 2
- Windwood Homeowners Association 2
- Los Cerritos Wetland Authority 2
- Johnson Ranch Community Association 2
- Elk Grove, City of 2
- South Lake Tahoe, City of 2
- Nevada Irrigation District 2
- Woodbury Community Association 2
- Park Paseo Homeowners Association 2
- American Golf 2
- Lancaster, City of 1
- Moreno Valley, City of 1
- Richmond, City of 1
- Monterey, County of 1
- Pleasanton, City of 1
- Santa Maria, City of 1
- United States Forest Service 1
- Santa Barbara Flood Control and Water Conserv. District 1
- National City, City of 1
- Salinas, City of 1
- Yorba Linda, City of 1
- Carpinteria, City of 1
- El Cajon, City of 1
- Downey, City of 1
- Huntington Park, City of 1
- Escondido, City of 1
- El Centro, City of 1
- Tulare, County of 1
- San Mateo, City of 1
- John Muir Land Trust 1
- Napa County Regional Park and Open Space District 1
- Costa Mesa, City of 1
- Chula Vista, City of 1
- Ontario, City of 1
- Poway, City of 1
- Monterey Park, City of 1
- Buena Park, City of 1
- Porterville, City of 1
- Azusa, City of 1
- Marin County Parks Department, County of 1
- Visalia, City of 1
- Alhambra, City of 1
- Valley-Wide Recreation and Park District 1
- Palo Alto, City of 1
- Riverside, County of 1
- Pacific Grove, City of 1
- San Leandro, City of 1
- Sonoma County Regional Parks Dept., County of 1
- Cupertino, City of 1
- Belmont, City of 1
- Fairfield, City of 1
- Placer, County of 1
- Palm Desert, City of 1
- Indio, City of 1
- Mill Valley, City of 1
- California State University Sonoma 1
- Lake Forest, City of 1
- Lafayette, City of 1
- San Dimas, City of 1
- Redondo Beach, City of 1
- Bakersfield, City of 1
- Montebello, City of 1
- Livermore, City of 1
- Lynwood, City of 1
- Coalinga-Huron Recreation and Park District 1
- Compton, City of 1
- Friends of the Desert Mountains 1
- Los Angeles - Department of Water and Power, City of 1
- Paramount, City of 1
- Desert Recreation District 1
- Los Angeles County Flood Control District 1
- Palos Verdes Estates, City of 1
- Hermosa Beach, City of 1
- Fresno, County of 1
- Hawthorne, City of 1
- La Verne, City of 1
- Monrovia, City of 1
- Rohnert Park, City of 1
- Walnut, City of 1
- Petco Park Owner 1
- Santa Clarita, City of 1
- La Mirada, City of 1
- Duarte, City of 1
- Murrieta, City of 1
- La Canada Flintridge, City of 1
- Greater Vallejo Recreation and Park District 1
- Blythe, City of 1
- Antioch, City of 1
- San Rafael, City of 1
- Martinez, City of 1
- Pico Rivera, City of 1
- Healdsburg, City of 1
- Arroyos and Foothills Conservancy 1
- Lemoore, City of 1
- Fremont, City of 1
- Concord, City of 1
- Harvard Square Maintenance Association 1
- Kern, County of 1
- Liberty Park Homeowners Association 1
- Milpitas, City of 1
- Brooktrails Community Services District 1
- Thousand Oaks, City of 1
- Contra Costa County Public Works Dept., County of 1
- Delano, City of 1
- King City, City of 1
- Tiburon, Town of 1
- Manteca, City of 1
- Mendocino Land Trust 1
- California Academy of Sciences 1
- Vallejo, City of 1
- Ripon, City of 1
- Marysville, City of 1
- West Sacramento, City of 1
- Humboldt, County of 1
- Tuleyome 1
- Rocklin, City of 1
- Sacramento Regional County Sanitation District 1
- San Lorenzo Valley Water District 1
- Lincoln, City of 1
- La Quinta, City of 1
- Friends of the Dunes 1
- North Star Historic Conservancy 1
- Galt, City of 1
- McKinleyville Community Services District 1
- Merced Irrigation District 1
- Turtle Rock Ridge Association 1
- Parkside Community Association 1
- Wagon Wheel Canyon Community Association 1
- L F Maintenance Corporation 1
- Serrano Park Community Association 1
- Trailwood Maintenance Association 1
- Eureka, City of 1
- Shasta, County of 1
- Feather River Land Trust 1
- Los Ranchos Community Association 1
- Santa Barbara Trust for Historic Preservation 1
- Cascade Ranch Historic Farm 1
- Grass Valley, City of 1
- Mendocino Coast Recreation and Park District 1
- North County Recreation and Park District 1
- Arcade Creek Recreation and Park District 1
- Tuolumne Park and Recreation District 1
- Palos Verdes Peninsula Land Conservancy 1
- Borrego Water District 1
- Orange County Department of Education, County of 1
- Paseo del Sol Master Association 1
- Mission Trails HOA 1
- Coachella Valley Association of Governments 1
- Briarcliff Homeowners Association 1
- Harlan Ranch Community Association 1
- Kingsburg Historical Society 1
- Westridge Homeowners Association 1
- San Diego Audubon Society 1
- Audubon Canyon Ranch 1
- Anza-Borrego Foundation 1
- Del Webb 1
- Los Angeles - Community Redevelopment Agency, City of 1
- Lincoln Village Home Association 1
- Calleguas Municipal Water District 1
- Santa Clara Unified School District 1
- Bay Club 1
- San Bernardino County Flood Control District 1
- Marcella Renaissance Owners Association 1
- North Fork Association 1
- Portola Valley Ranch Home Owners Association 1
- Lakeshore Homes Association 1
- Sun City Lincoln Hills Community Association 1
- Coachella Valley Water District 1
- Lake Tahoe Park Association 1
- Comstock South LLC 1
- Hilltop LLC 1
- Bixby Village Home Owner Association 1
- La Verne Heritage Foundation 1
- Norwalk La Mirada Unified School District 1
- Whittier Union High School District 1
- Whittier City School District 1
- Trust for Hidden Villa 1
- Stanford University 1
- Park Place Homeowners Association 1
- Friends of the Tuolumne 1
- Novato Sanitary District 1
- Western Riverside County Regional Conservation Authority 1
- Malibu, City of 1
- Silver Dollar BMX 1
- Sacramento Valley Conservancy 1
- Redondo Beach Unified School District 1
- Vista Unified School District 1
- Rice Ranch Ventures LLC 1
- Summit at Turtle Ridge Community Association 1
- Murrieta Valley PONY Baseball, Inc 1
- GraniteRock 1
- Kelsey Lane Maintenance Association 1
- Woodside-Irvine Homeowners Association 1
- Village Park Community Association 1
- Colony Club Community Association 1
- Greentree Homes Association 1
- Turtle Rock Glen Community Association 1
- Palm Gardens Community Association 1
- Jasmine Creek Community Association 1
- Briosa Owners Association 1
- Culverdale Community Association 1
- Canyon Creek Homeowners Association 1
- Meadowood Community Association 1
- Laguna Village Owners Association Inc 1
- Newport Ridge North Maintenance Association 1
- Crestwood Estates Homeowners Association 1
- Moulton Ranch III Homeowners Association 1
- University Community Association 1
- Lake Mission Viejo Association 1
- Vista Community Association 1
- Golden Rain Foundation of Laguna Woods 1
- Eastbluff Homeowners Community Association 1
- Lido Isle Community Association 1
- Crystal Cove Community Association 1
- Heritage Park Community Association 1
- Lake Forest Drive Association 1
- Broadmoor Sea View Community Association 1
- Canyon Estates Homeowners Association 1
- Pinecrest Community Association 1
- Bonita Canyon Maintenance Association 1
- Newport Coast Community Association 1
- Painted Trails Community Association 1
- Sun Ridge Community Association 1
- Shady Canyon Community Association 1
- Green Valley Homeowners Recreation Association 1
- Arroyo Maintenance Corporation 1
- Laguna Niguel Rolling Hills Community Association 1
- Yucaipa Valley Water District 1
- River Partners 1
- Paloma del Sol Homeowners Association 1
- Los Angeles Golf Club 1
- Marin Agricultural Land Trust 1
- Arcadia Unified School District 1
- William S. Hart Union High School District 1
- Downey Unified School District 1
- JC Resorts 1
- San Dimas-La Verne Recreational Facilities Authority 1
- Winchester Owners Association 1
- CZ Master Association 1
- National Trust for Historic Preservation 1
DES_TP 154
- Local Recreation Area 220
- Local Park 210
- Private Recreation or Education 194
- Private Conservation 154
- State Conservation Area 109
- Local Conservation Area 47
- National Wildlife Refuge 36
- Local Other or Unknown 31
- National Public Lands 9
- Recreation Management Area 9
- State Resource Management Area 7
- Private Other or Unknown 7
- Federal Other or Unknown 6
- Conservation Area 5
- State Park 4
- National Park 4
- State Recreation Area 4
- Local Resource Management Area 4
- Private Agricultural 4
- Local Historic or Cultural Area 3
- National Recreation Area 2
- Resource Management Area 2
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- Wilderness Area 1
- None 1
- National Monument or Landmark 1
- State Other or Unknown 1
- State Historic or Cultural Area 1
- None 1
- None 1
- None 1
- Research or Educational Area 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
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- Area of Critical Environmental Concern 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
- 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
- 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
- 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
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 25
- City Agency 363
- Home Owners Association 202
- State Agency 149
- Non Profit - Land Trust 139
- Federal Agency 81
- Recreation/Parks District 64
- County Agency 59
- School District 38
- Non Profit - Conservation 20
- Water District 14
- County Agency - Other 12
- County Agency - Parks 11
- Commercial 9
- Non Profit - Other 8
- Open Space District 7
- Joint Powers Authority 6
- Community Services District 4
- Flood District 3
- Irrigation District 3
- Other 3
- Conservation District 3
- Sanitation District 2
- Metropolitan Planning Organization 1
- Home Owners Associatin 1
- Non Profit - Education 1
AGNCY_TYP 25 ✖
- City Agency 260
- Home Owners Association 202
- School District 156
- State Agency 145
- Non Profit - Land Trust 140
- Federal Agency 90
- County Agency 63
- Recreation/Parks District 56
- Non Profit - Conservation 19
- Water District 16
- County Agency - Other 12
- Non Profit - Other 8
- Open Space District 6
- Joint Powers Authority 6
- Community Services District 4
- County Agency - Parks 3
- Flood District 3
- Irrigation District 3
- Conservation District 3
- Sanitation District 2
- Commercial 2
- Other 1
- Metropolitan Planning Organization 1
- Home Owners Associatin 1
- Non Profit - Education 1
ACCESS_TYP 1
- Restricted Access · 1,203 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3760 | 3760 | 3759 | {"type": "Polygon", "coordinates": [[[-122.95962, 40.7165], [-122.95894, 40.72369], [-122.9584, 40.7272], [-122.95072, 40.72738], [-122.95056, 40.72704], [-122.94975, 40.72649], [-122.94961, 40.72632], [-122.94959, 40.72551], [-122.94491, 40.7255], [-122.94491, 40.72367], [-122.94258, 40.72366], [-122.94259, 40.72273], [-122.94025, 40.72272], [-122.94025, 40.72217], [-122.93902, 40.7227], [-122.939, 40.72267], [-122.93668, 40.72369], [-122.93688, 40.71878], [-122.93878, 40.71586], [-122.93907, 40.71613], [-122.94039, 40.71613], [-122.94432, 40.7162], [-122.95236, 40.71632], [-122.95962, 40.7165]]]} | Restricted Access 2 | 34904 | BLM | 16163 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | Trinity 46 | 463.82 | BLM | 1963 | National Public Lands 1 | 3 | |
3763 | 3763 | 3762 | {"type": "Polygon", "coordinates": [[[-117.39664, 35.73738], [-117.39548, 35.74101], [-117.39454, 35.74102], [-117.39455, 35.74394], [-117.39429, 35.74463], [-117.39234, 35.74464], [-117.39228, 35.74751], [-117.39124, 35.74826], [-117.39002, 35.74841], [-117.38789, 35.74939], [-117.38787, 35.74825], [-117.38344, 35.74826], [-117.38344, 35.75187], [-117.37899, 35.75187], [-117.37899, 35.74464], [-117.38353, 35.74464], [-117.38353, 35.74102], [-117.38788, 35.74101], [-117.38788, 35.73739], [-117.39664, 35.73738]]]} | Restricted Access 2 | 34925 | BLM | 16163 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | San Bernardino 22 | 334.438 | BLM | 1963 | National Public Lands 1 | 3 | |
4144 | 4144 | 4143 | {"type": "Polygon", "coordinates": [[[-122.46384, 39.38383], [-122.45881, 39.38384], [-122.4585, 39.38043], [-122.46379, 39.38038], [-122.46384, 39.38383]]]} | Restricted Access 2 | 47499 | BLM | 16163 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | Colusa 49 | 41.777 | BLM | 1963 | National Public Lands 1 | 3 | |
5580 | 5580 | 5579 | {"type": "Polygon", "coordinates": [[[-121.95567, 37.92322], [-121.95099, 37.92324], [-121.9509, 37.91961], [-121.95562, 37.91959], [-121.95567, 37.92322]]]} | Restricted Access 2 | 29557 | BLM | 16163 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | Contra Costa 12 | 41.201 | BLM | 1963 | National Public Lands 1 | 3 | |
11182 | 11182 | 11181 | {"type": "MultiPolygon", "coordinates": [[[[-122.1646, 39.75799], [-122.16445, 39.7616], [-122.16182, 39.76157], [-122.15957, 39.76157], [-122.15966, 39.75983], [-122.15944, 39.75788], [-122.16324, 39.75792], [-122.1646, 39.75799]]], [[[-122.22022, 39.77673], [-122.22017, 39.78034], [-122.21557, 39.78029], [-122.21553, 39.77668], [-122.22022, 39.77673]]], [[[-122.32796, 39.39913], [-122.3233, 39.39915], [-122.32318, 39.39219], [-122.32786, 39.39215], [-122.32796, 39.39913]]], [[[-122.44682, 39.49066], [-122.44201, 39.49066], [-122.44196, 39.48701], [-122.44676, 39.48701], [-122.44682, 39.49066]]], [[[-122.47449, 39.41647], [-122.47428, 39.42005], [-122.47423, 39.43573], [-122.47424, 39.44169], [-122.46972, 39.44165], [-122.46954, 39.44148], [-122.4696, 39.43437], [-122.46016, 39.43508], [-122.45966, 39.42802], [-122.45902, 39.42438], [-122.45382, 39.42443], [-122.45339, 39.42079], [-122.4591, 39.42054], [-122.45911, 39.41686], [-122.4591, 39.41685], [-122.45347, 39.41699], [-122.45338, 39.40587], [-122.45331, 39.40583], [-122.45328, 39.4024], [-122.45183, 39.4023], [-122.45182, 39.40231], [-122.44821, 39.40234], [-122.44808, 39.39874], [-122.44355, 39.39869], [-122.44372, 39.39139], [-122.44692, 39.39142], [-122.44725, 39.38407], [-122.4473, 39.38406], [-122.4472, 39.38393], [-122.45099, 39.38399], [-122.45882, 39.38397], [-122.45881, 39.38384], [-122.46383, 39.38383], [-122.46406, 39.40553], [-122.46415, 39.40913], [-122.46969, 39.40894], [-122.46969, 39.40931], [-122.4697, 39.40944], [-122.4697, 39.41637], [-122.47423, 39.41644], [-122.47424, 39.41646], [-122.47449, 39.41647]]], [[[-122.47411, 39.44842], [-122.47408, 39.44843], [-122.47409, 39.44854], [-122.47395, 39.44888], [-122.4739, 39.45054], [-122.4696, 39.45055], [-122.46956, 39.44879], [-122.46954, 39.44511], [-122.47411, 39.44517], [-122.47411, 39.44842]]], [[[-122.47452, 39.39851], [-122.47451, 39.40208], [-122.4701, 39.40204], [-122.46977, 39.40208], [-122.46984, 39.39842], [-122.47014, 39.39845], [-122.47452, 39.39851]]], [[[-122.49255, 39.43829], [-122.49251, 39.44913], [-122.48796, 39.44909], [-122.48801, 39.4461], [-122.48818, 39.4461], [-122.48821, 39.43911], [-122.48969, 39.4385], [-122.49057, 39.43796], [-122.49208, 39.43782], [-122.49248, 39.43757], [-122.49248, 39.43828], [-122.49255, 39.43829]]], [[[-122.49248, 39.43738], [-122.49205, 39.43768], [-122.49185, 39.43768], [-122.49049, 39.4378], [-122.48954, 39.43838], [-122.48895, 39.43868], [-122.48827, 39.43892], [-122.4884, 39.43469], [-122.49247, 39.43476], [-122.49248, 39.43738]]], [[[-122.49535, 39.52955], [-122.49043, 39.52997], [-122.48854, 39.5234], [-122.49324, 39.5231], [-122.49535, 39.52955]]], [[[-122.50277, 39.57036], [-122.50165, 39.5704], [-122.50164, 39.57042], [-122.49808, 39.57047], [-122.49799, 39.56647], [-122.50263, 39.56654], [-122.50277, 39.57036]]], [[[-122.5029, 39.58858], [-122.49833, 39.5886], [-122.4983, 39.58502], [-122.50284, 39.58495], [-122.5029, 39.58858]]], [[[-122.50742, 39.57752], [-122.50741, 39.58113], [-122.50291, 39.58118], [-122.50279, 39.57764], [-122.50742, 39.57752]]], [[[-122.51816, 39.43183], [-122.51808, 39.43541], [-122.51028, 39.43512], [-122.51031, 39.42805], [-122.51419, 39.42803], [-122.51423, 39.43163], [-122.51816, 39.43183]]], [[[-122.51655, 39.60657], [-122.5119, 39.6066], [-122.51172, 39.60295], [-122.51645, 39.60292], [-122.51655, 39.60657]]], [[[-122.51977, 39.41379], [-122.51972, 39.421], [-122.51571, 39.42085], [-122.51572, 39.41366], [-122.51977, 39.41379]]], [[[-122.51987, 39.39939], [-122.5158, 39.39919], [-122.51584, 39.39176], [-122.51982, 39.39197], [-122.51987, 39.39939]]], [[[-122.5628, 39.51771], [-122.55827, 39.5177], [-122.55822, 39.51056], [-122.56266, 39.51055], [-122.5628, 39.51771]]], [[[-122.56321, 39.55891], [-122.5632, 39.56262], [-122.55855, 39.5626], [-122.55856, 39.55893], [-122.56321, 39.55891]]], [[[-122.56775, 39.55532], [-122.56306, 39.55536], [-122.56303, 39.55173], [-122.56771, 39.55169], [-122.56775, 39.55532]]], [[[-122.58225, 39.53707], [-122.58223, 39.53753], [-122.58221, 39.5407], [-122.57748, 39.54075], [-122.57751, 39.53712], [-122.57266, 39.53719], [-122.57282, 39.53705], [-122.5728, 39.5366], [-122.57274, 39.5364], [-122.57262, 39.53617], [-122.57282, 39.53601], [-122.57294, 39.53585], [-122.57298, 39.53577], [-122.5768, 39.53609], [-122.58162, 39.53613], [-122.58224, 39.53706], [-122.58225, 39.53707]]], [[[-122.57746, 39.54441], [-122.57744, 39.54796], [-122.5727, 39.548], [-122.57273, 39.54439], [-122.57746, 39.54441]]], [[[-122.59174, 39.71995], [-122.58962, 39.71997], [-122.58981, 39.72721], [-122.58736, 39.72723], [-122.58776, 39.74186], [-122.58786, 39.75022], [-122.58801, 39.7561], [-122.57835, 39.75612], [-122.5779, 39.74174], [-122.5735, 39.74169], [-122.57363, 39.73446], [-122.57837, 39.73452], [-122.57833, 39.73094], [-122.57369, 39.73089], [-122.57369, 39.72982], [-122.57362, 39.72364], [-122.5783, 39.72366], [-122.57828, 39.71992], [-122.58276, 39.71993], [-122.58281, 39.71263], [-122.58324, 39.71262], [-122.58347, 39.70429], [-122.58806, 39.70369], [-122.58849, 39.68822], [-122.5901, 39.68813], [-122.59012, 39.69564], [-122.58999, 39.70345], [-122.58989, 39.7126], [-122.5899, 39.71261], [-122.59154, 39.71261], [-122.59174, 39.71995]]], [[[-122.5874, 39.59871], [-122.58738, 39.60237], [-122.58257, 39.60241], [-122.5825, 39.59877], [-122.5874, 39.59871]]], [[[-122.58919, 39.62838], [-122.58286, 39.62841], [-122.58281, 39.62486], [-122.5879, 39.62486], [-122.58915, 39.62483], [-122.58919, 39.62838]]], [[[-122.5901, 39.66765], [-122.58977, 39.66765], [-122.58976, 39.66766], [-122.58984, 39.67119], [-122.58988, 39.6712], [-122.58986, 39.67448], [-122.5899, 39.67454], [-122.58993, 39.67481], [-122.59002, 39.67481], [-122.58996, 39.67484], [-122.58999, 39.67829], [-122.58996, 39.6783], [-122.59006, 39.68178], [-122.59008, 39.68513], [-122.58855, 39.6854], [-122.58835, 39.66767], [-122.58999, 39.66759], [-122.5901, 39.66765]]], [[[-122.61522, 39.53729], [-122.6152, 39.54066], [-122.61027, 39.54064], [-122.61038, 39.53729], [-122.61522, 39.53729]]]]} | Restricted Access 2 | 21454 | BLM | 16163 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | Glenn 55 | 4738.203 | BLM | 1963 | National Public Lands 1 | 3 | |
13036 | 13036 | 13035 | {"type": "MultiPolygon", "coordinates": [[[[-120.89266, 38.89126], [-120.89257, 38.89479], [-120.89056, 38.89479], [-120.89053, 38.89645], [-120.89055, 38.8965], [-120.89052, 38.89651], [-120.89051, 38.89665], [-120.89026, 38.89606], [-120.88994, 38.89557], [-120.8897, 38.89539], [-120.8902, 38.89507], [-120.8902, 38.89505], [-120.88701, 38.89192], [-120.8863, 38.89232], [-120.88538, 38.89288], [-120.88669, 38.89416], [-120.88634, 38.89408], [-120.88574, 38.89398], [-120.88504, 38.89384], [-120.88368, 38.89339], [-120.88316, 38.89325], [-120.88272, 38.89324], [-120.88239, 38.89325], [-120.88173, 38.89342], [-120.88175, 38.89109], [-120.88161, 38.88749], [-120.88598, 38.88758], [-120.88601, 38.88811], [-120.88448, 38.8884], [-120.88543, 38.89022], [-120.88525, 38.89116], [-120.88723, 38.89118], [-120.8875, 38.89026], [-120.89055, 38.89032], [-120.89056, 38.89124], [-120.89266, 38.89126]]], [[[-120.89052, 38.89708], [-120.8905, 38.89832], [-120.88629, 38.89826], [-120.88628, 38.8948], [-120.88172, 38.89471], [-120.88173, 38.89359], [-120.88261, 38.89353], [-120.88289, 38.89353], [-120.88321, 38.89357], [-120.88468, 38.89404], [-120.88557, 38.89425], [-120.88708, 38.89452], [-120.88862, 38.89603], [-120.88939, 38.89557], [-120.88966, 38.89576], [-120.89001, 38.89629], [-120.89025, 38.8967], [-120.89052, 38.89708]]], [[[-120.90802, 38.89769], [-120.90801, 38.8995], [-120.90421, 38.90102], [-120.90182, 38.89809], [-120.89949, 38.89818], [-120.89948, 38.89819], [-120.90211, 38.9014], [-120.90057, 38.90137], [-120.89993, 38.90132], [-120.89957, 38.90128], [-120.8991, 38.90119], [-120.89758, 38.90074], [-120.89596, 38.90018], [-120.89767, 38.90006], [-120.89943, 38.89996], [-120.89948, 38.89911], [-120.89947, 38.89808], [-120.90172, 38.89795], [-120.90373, 38.89788], [-120.90802, 38.89769]]], [[[-120.908, 38.89979], [-120.90797, 38.90135], [-120.90794, 38.90478], [-120.90656, 38.90475], [-120.90316, 38.90188], [-120.90172, 38.90292], [-120.90342, 38.90439], [-120.90344, 38.90474], [-120.90345, 38.90756], [-120.90024, 38.90617], [-120.89942, 38.90698], [-120.89945, 38.90553], [-120.89607, 38.90576], [-120.89515, 38.90581], [-120.89522, 38.90208], [-120.89524, 38.90015], [-120.89592, 38.90046], [-120.89747, 38.90106], [-120.89842, 38.90136], [-120.89937, 38.90157], [-120.90043, 38.90171], [-120.90143, 38.90177], [-120.90226, 38.90178], [-120.90291, 38.90174], [-120.90321, 38.90174], [-120.90373, 38.90161], [-120.90439, 38.90138], [-120.90532, 38.90099], [-120.90561, 38.90082], [-120.908, 38.89979]]]]} | Restricted Access 2 | 34872 | BLM | 16163 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | El Dorado 34 | 313.299 | BLM | 1963 | National Public Lands 1 | 3 | |
13037 | 13037 | 13036 | {"type": "MultiPolygon", "coordinates": [[[[-120.91216, 38.91541], [-120.91209, 38.91725], [-120.90299, 38.9179], [-120.90314, 38.91614], [-120.91216, 38.91541]]], [[[-120.91554, 38.91278], [-120.91489, 38.9134], [-120.91489, 38.91518], [-120.91293, 38.91536], [-120.9126, 38.91537], [-120.91264, 38.91385], [-120.91256, 38.91389], [-120.90898, 38.91085], [-120.908, 38.91025], [-120.90805, 38.90805], [-120.91228, 38.90808], [-120.9148, 38.90807], [-120.91488, 38.91165], [-120.91488, 38.91253], [-120.9149, 38.91254], [-120.91511, 38.91239], [-120.91554, 38.91278]]]]} | Restricted Access 2 | 34873 | BLM | 16163 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | El Dorado 34 | 121.211 | BLM | 1963 | National Public Lands 1 | 3 | |
13054 | 13054 | 13053 | {"type": "Polygon", "coordinates": [[[-122.17843, 39.75789], [-122.17369, 39.75785], [-122.17368, 39.75452], [-122.17834, 39.75457], [-122.17843, 39.75789]]]} | Restricted Access 2 | 34910 | BLM | 16163 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | Glenn 55 | 36.703 | BLM | 1963 | National Public Lands 1 | 3 | |
13056 | 13056 | 13055 | {"type": "Polygon", "coordinates": [[[-116.45767, 33.96133], [-116.44054, 33.96104], [-116.44043, 33.94685], [-116.44884, 33.94684], [-116.44926, 33.95001], [-116.45349, 33.95007], [-116.45355, 33.94677], [-116.45738, 33.94676], [-116.45767, 33.96133]]]} | Restricted Access 2 | 34913 | BLM | 16163 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | Riverside 10 | 583.754 | BLM | 1963 | National Public Lands 1 | 3 | |
347 | 347 | 346 | {"type": "Polygon", "coordinates": [[[-117.85051, 34.14864], [-117.85051, 34.14999], [-117.84989, 34.15], [-117.84989, 34.15052], [-117.84633, 34.15052], [-117.84629, 34.15049], [-117.84629, 34.14964], [-117.84651, 34.14929], [-117.84697, 34.14876], [-117.84774, 34.14876], [-117.84775, 34.14814], [-117.84839, 34.14815], [-117.84839, 34.14865], [-117.85051, 34.14864]]]} | Restricted Access 2 | 953 | George Manooshian Park | 29754 | 2312 | Glendora Unified School District 141 | Special District 4 | School District 14 | http://www.glendora.k12.ca.us/ | Special District 4 | 1120 | Glendora, City of 74 | City 2 | City Agency 2 | Los Angeles 6 | 18.865 | George Manooshian Park | 0 | Local Park 2 | 4 | |
672 | 672 | 671 | {"type": "Polygon", "coordinates": [[[-122.10311, 37.87618], [-122.10304, 37.87629], [-122.10157, 37.87704], [-122.10079, 37.87704], [-122.10071, 37.87693], [-122.10056, 37.87677], [-122.09956, 37.8759], [-122.09896, 37.87548], [-122.09889, 37.87537], [-122.09866, 37.87468], [-122.09864, 37.87453], [-122.10311, 37.87618]]]} | Restricted Access 2 | 5104 | 711 St. Mary's Road Park | 15210 | 1163 | Lafayette, City of 236 | City 2 | City Agency 2 | http://www.ci.lafayette.ca.us/index.aspx?page=87 | City 2 | 1163 | Lafayette, City of 232 | City 2 | City Agency 2 | Contra Costa 12 | 11.502 | 711 St. Mary's Road Park | 1983 | Local Park 2 | 4 | |
824 | 824 | 823 | {"type": "Polygon", "coordinates": [[[-118.29688, 34.18375], [-118.2965, 34.18411], [-118.29645, 34.18412], [-118.29561, 34.18351], [-118.2956, 34.18348], [-118.296, 34.18308], [-118.29685, 34.1837], [-118.29688, 34.18375]]]} | Restricted Access 2 | 5370 | Miller Park | 29568 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://www.burbankca.gov/departments/parks-and-recreation/parks-facilities/miller-park | Los Angeles 6 | 1.599 | Miller Park | 0 | Local Park 2 | 4 |
1030 | 1030 | 1029 | {"type": "Polygon", "coordinates": [[[-118.04152, 33.87135], [-118.04149, 33.87145], [-118.04152, 33.87159], [-118.04153, 33.87191], [-118.04149, 33.87195], [-118.04002, 33.87196], [-118.03998, 33.87195], [-118.03997, 33.87192], [-118.04, 33.87181], [-118.03999, 33.87176], [-118.03996, 33.87172], [-118.0399, 33.87171], [-118.03989, 33.87119], [-118.04023, 33.87119], [-118.04045, 33.87115], [-118.04068, 33.87106], [-118.04094, 33.87089], [-118.04112, 33.87082], [-118.04125, 33.8708], [-118.04146, 33.8708], [-118.0415, 33.87082], [-118.04152, 33.87135]]]} | Restricted Access 2 | 5646 | Friendship Park | 19120 | 1051 | Cerritos, City of 225 | City 2 | City Agency 2 | http://www.ci.cerritos.ca.us/ | City 2 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | Los Angeles 6 | 3.848 | Friendship Park | 0 | Local Park 2 | 4 | |
2052 | 2052 | 2051 | {"type": "Polygon", "coordinates": [[[-122.05604, 37.67111], [-122.05571, 37.6729], [-122.05568, 37.67326], [-122.05563, 37.67337], [-122.05549, 37.67348], [-122.05533, 37.67354], [-122.05428, 37.67355], [-122.05406, 37.67328], [-122.0545, 37.67093], [-122.05604, 37.67111]]]} | Restricted Access 2 | 15627 | East Avenue School Park | 31952 | 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 | 9.509 | East Avenue School Park | 0 | Local Park 2 | 4 | |
2098 | 2098 | 2097 | {"type": "Polygon", "coordinates": [[[-121.89542, 37.75272], [-121.89511, 37.75373], [-121.89391, 37.75351], [-121.89423, 37.75248], [-121.89542, 37.75272]]]} | Restricted Access 2 | 47568 | Live Oak School Park | 31293 | 2309 | San Ramon Valley Unified School District 478 | Special District 4 | School District 14 | http://www.srvusd.net/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 3.116 | Live Oak School Park | 0 | Local Park 2 | 4 | |
2216 | 2216 | 2215 | {"type": "Polygon", "coordinates": [[[-121.90955, 37.75216], [-121.90924, 37.75257], [-121.90894, 37.75304], [-121.90858, 37.75288], [-121.90819, 37.75274], [-121.90782, 37.75266], [-121.90741, 37.75261], [-121.90741, 37.7522], [-121.90735, 37.75209], [-121.90718, 37.752], [-121.90702, 37.75197], [-121.90676, 37.75208], [-121.9058, 37.75097], [-121.9068, 37.75041], [-121.90754, 37.75103], [-121.90769, 37.7511], [-121.90786, 37.75114], [-121.90802, 37.75114], [-121.90823, 37.75111], [-121.90845, 37.75099], [-121.90955, 37.75216]]]} | Restricted Access 2 | 47570 | Windemere Ranch School Park | 31295 | 2309 | San Ramon Valley Unified School District 478 | Special District 4 | School District 14 | http://www.srvusd.net/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 11.225 | Windemere Ranch School Park | 0 | Local Park 2 | 4 | |
2245 | 2245 | 2244 | {"type": "Polygon", "coordinates": [[[-118.84354, 34.17707], [-118.84327, 34.17764], [-118.84313, 34.17791], [-118.84297, 34.17808], [-118.84271, 34.178], [-118.84174, 34.17697], [-118.84123, 34.17723], [-118.84141, 34.17751], [-118.84091, 34.17775], [-118.84047, 34.17714], [-118.84173, 34.17649], [-118.84228, 34.17687], [-118.84243, 34.17692], [-118.84354, 34.17707]]]} | Restricted Access 2 | 18017 | Beyer Park | 31603 | 2026 | Conejo Valley Unified School District 501 | Special District 4 | School District 14 | http://www.conejo.k12.ca.us/ | Special District 4 | 2026 | Conejo Valley Unified School District 493 | Special District 4 | School District 21 | Ventura 8 | 5.138 | Beyer Park | 0 | Local Park 2 | 4 | |
2754 | 2754 | 2753 | {"type": "Polygon", "coordinates": [[[-117.24499, 32.80093], [-117.24419, 32.8011], [-117.24283, 32.80145], [-117.24267, 32.80102], [-117.24251, 32.80051], [-117.24472, 32.80004], [-117.24499, 32.80093]]]} | Restricted Access 2 | 18441 | Pacific Beach Community Park | 33345 | 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 | 5.466 | Pacific Beach Community Park | 0 | Local Park 2 | 4 | |
2799 | 2799 | 2798 | {"type": "MultiPolygon", "coordinates": [[[[-117.05969, 32.76384], [-117.05963, 32.76392], [-117.05829, 32.76395], [-117.05834, 32.7639], [-117.05835, 32.76382], [-117.05963, 32.76378], [-117.05966, 32.76379], [-117.05969, 32.76384]]], [[[-117.06115, 32.76232], [-117.06114, 32.76248], [-117.06111, 32.76257], [-117.06106, 32.76264], [-117.06009, 32.76351], [-117.06004, 32.76235], [-117.06115, 32.76232]]]]} | Restricted Access 2 | 18582 | Clay Neighborhood Park | 31592 | 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 | 2.413 | Clay Neighborhood Park | 0 | Local Park 2 | 4 | |
2946 | 2946 | 2945 | {"type": "Polygon", "coordinates": [[[-118.43139, 34.07349], [-118.43133, 34.0739], [-118.43131, 34.07413], [-118.43128, 34.07416], [-118.43123, 34.07417], [-118.4312, 34.07415], [-118.43081, 34.0738], [-118.4306, 34.07366], [-118.4303, 34.07352], [-118.42983, 34.0734], [-118.42965, 34.0733], [-118.4295, 34.07319], [-118.42916, 34.07276], [-118.42892, 34.07255], [-118.42767, 34.07171], [-118.42764, 34.07166], [-118.42764, 34.0716], [-118.4278, 34.0712], [-118.42784, 34.07119], [-118.42921, 34.07171], [-118.42952, 34.07187], [-118.42979, 34.07208], [-118.43009, 34.07242], [-118.43027, 34.0726], [-118.43138, 34.07347], [-118.43139, 34.07349]]]} | Restricted Access 2 | 1906 | Holmby Park | 32999 | 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 | 8.535 | Holmby 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]);