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 LABEL_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID, PARK_URL, COUNTY, YR_EST, GAP_STS
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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4470 | 4470 | 4469 | {"type": "Polygon", "coordinates": [[[-116.37329, 33.19965], [-116.36458, 33.19964], [-116.36453, 33.19257], [-116.37324, 33.19257], [-116.37329, 33.19965]]]} | Restricted Access 2 | 1194 | Unnamed site - Borrego Water District | 28622 | 2008 | Borrego Water District 764 | Special District 4 | Water District 13 | http://www.borregowd.org/ | Special District 4 | 2008 | Borrego Water District 745 | Special District 4 | Water District 13 | San Diego 4 | 157.534 | 0 | Local Other or Unknown 14 | 4 | ||
4471 | 4471 | 4470 | {"type": "Polygon", "coordinates": [[[-116.62024, 32.8546], [-116.62023, 32.85532], [-116.61829, 32.85533], [-116.61829, 32.85491], [-116.618, 32.85491], [-116.61799, 32.85435], [-116.61875, 32.85434], [-116.61914, 32.85341], [-116.61924, 32.85343], [-116.6193, 32.85399], [-116.61991, 32.8542], [-116.6198, 32.85446], [-116.62024, 32.8546]]]} | Restricted Access 2 | 1199 | Unnamed site - Nonprofit Organization - Unknown | 28649 | 3048 | Nonprofit Organization - Unknown 765 | Non Profit 6 | Non Profit - Other 22 | Non Governmental Organization 10 | 3048 | Nonprofit Organization - Unknown 746 | Non Profit 6 | Non Profit - Other 20 | San Diego 4 | 6.306 | 0 | Private Other or Unknown 399 | 4 | |||
4472 | 4472 | 4471 | {"type": "Polygon", "coordinates": [[[-116.31558, 33.3251], [-116.31551, 33.33963], [-116.29816, 33.3395], [-116.29841, 33.32503], [-116.31558, 33.3251]]]} | Restricted Access 2 | 1208 | Unnamed site - Nonprofit Organization - Unknown | 28649 | 3048 | Nonprofit Organization - Unknown 765 | Non Profit 6 | Non Profit - Other 22 | Non Governmental Organization 10 | 3048 | Nonprofit Organization - Unknown 746 | Non Profit 6 | Non Profit - Other 20 | San Diego 4 | 638.799 | 0 | Private Other or Unknown 399 | 4 | |||
4519 | 4519 | 4518 | {"type": "Polygon", "coordinates": [[[-117.6523, 33.73705], [-117.6424, 33.73701], [-117.64238, 33.73346], [-117.64935, 33.7315], [-117.65064, 33.73322], [-117.652, 33.73296], [-117.65104, 33.73389], [-117.6515, 33.73494], [-117.6523, 33.73705]]]} | Restricted Access 2 | 12713 | Unnamed site - Orange County Department of Education, County of | 28651 | 313 | Orange County Department of Education, County of 770 | County 3 | County Agency - Other 9 | http://www.ocde.us/ | County 3 | 313 | Orange County Department of Education, County of 751 | County 3 | County Agency - Other 8 | Orange 3 | 105.765 | 0 | Local Other or Unknown 14 | 4 | ||
4565 | 4565 | 4564 | {"type": "Polygon", "coordinates": [[[-115.25908, 33.44142], [-115.25691, 33.44141], [-115.25692, 33.44321], [-115.24776, 33.44322], [-115.24775, 33.43597], [-115.2538, 33.43597], [-115.25908, 33.44142]]]} | Restricted Access 2 | 35204 | Unnamed site - Riverside Land Conservancy | 28657 | 3059 | Rivers and Lands Conservancy 773 | Non Profit 6 | Non Profit - Land Trust 10 | https://riversandlands.org/ | Non Governmental Organization 10 | 3059 | Rivers and Lands Conservancy 754 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 162.476 | 0 | Private Other or Unknown 399 | 4 | ||
4591 | 4591 | 4590 | {"type": "Polygon", "coordinates": [[[-115.2538, 33.43596], [-115.24775, 33.43597], [-115.24775, 33.43111], [-115.25054, 33.43293], [-115.25106, 33.4333], [-115.25155, 33.43373], [-115.2538, 33.43596]]]} | Restricted Access 2 | 35485 | Unnamed site - Riverside Land Conservancy | 28657 | 3059 | Rivers and Lands Conservancy 773 | Non Profit 6 | Non Profit - Land Trust 10 | https://riversandlands.org/ | Non Governmental Organization 10 | 3059 | Rivers and Lands Conservancy 754 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 41.317 | 0 | Private Other or Unknown 399 | 4 | ||
4594 | 4594 | 4593 | {"type": "Polygon", "coordinates": [[[-117.34544, 33.91468], [-117.34509, 33.91482], [-117.34481, 33.91495], [-117.34443, 33.91447], [-117.3444, 33.91406], [-117.34438, 33.91401], [-117.34438, 33.91173], [-117.34444, 33.9118], [-117.34479, 33.91339], [-117.34492, 33.91372], [-117.34544, 33.91468]]]} | Restricted Access 2 | 35501 | Unnamed site - Riverside Land Conservancy | 28657 | 3059 | Rivers and Lands Conservancy 773 | Non Profit 6 | Non Profit - Land Trust 10 | https://riversandlands.org/ | Non Governmental Organization 10 | 3059 | Rivers and Lands Conservancy 754 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 3.461 | 0 | Private Other or Unknown 399 | 4 | ||
4595 | 4595 | 4594 | {"type": "Polygon", "coordinates": [[[-117.34438, 33.91173], [-117.34438, 33.91401], [-117.3442, 33.91372], [-117.34412, 33.91332], [-117.34414, 33.91296], [-117.34378, 33.91232], [-117.3426, 33.91104], [-117.34229, 33.91079], [-117.34089, 33.91024], [-117.34062, 33.9102], [-117.34003, 33.91028], [-117.34003, 33.9097], [-117.3405, 33.90992], [-117.34147, 33.90992], [-117.34322, 33.91072], [-117.34323, 33.91092], [-117.34382, 33.91091], [-117.34438, 33.91173]]]} | Restricted Access 2 | 35502 | Unnamed site - Riverside Land Conservancy | 28657 | 3059 | Rivers and Lands Conservancy 773 | Non Profit 6 | Non Profit - Land Trust 10 | https://riversandlands.org/ | Non Governmental Organization 10 | 3059 | Rivers and Lands Conservancy 754 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 8.55 | 0 | Private Other or Unknown 399 | 4 | ||
4679 | 4679 | 4678 | {"type": "Polygon", "coordinates": [[[-121.3533, 38.45594], [-121.35327, 38.45595], [-121.35327, 38.45636], [-121.35226, 38.45636], [-121.35227, 38.45624], [-121.3523, 38.45613], [-121.35236, 38.456], [-121.35243, 38.45591], [-121.35251, 38.45582], [-121.35281, 38.45567], [-121.35311, 38.4556], [-121.35318, 38.45561], [-121.35321, 38.45564], [-121.3533, 38.45594]]]} | Restricted Access 2 | 43001 | Unnamed site - Sacramento, County of | 28659 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 1.452 | 0 | Local Other or Unknown 14 | 4 | ||
4692 | 4692 | 4691 | {"type": "Polygon", "coordinates": [[[-118.35865, 34.26614], [-118.35827, 34.26807], [-118.35695, 34.26791], [-118.35657, 34.2683], [-118.35593, 34.26829], [-118.35637, 34.26785], [-118.35636, 34.26783], [-118.35538, 34.26771], [-118.35584, 34.26829], [-118.35539, 34.26829], [-118.35538, 34.2683], [-118.3577, 34.27107], [-118.35758, 34.2717], [-118.35674, 34.27179], [-118.3562, 34.272], [-118.35591, 34.27203], [-118.35491, 34.27184], [-118.35328, 34.27158], [-118.35331, 34.27145], [-118.35321, 34.27142], [-118.35327, 34.27106], [-118.35311, 34.27121], [-118.35307, 34.27142], [-118.35297, 34.27141], [-118.35294, 34.27154], [-118.35225, 34.27148], [-118.3521, 34.27136], [-118.35132, 34.27105], [-118.35025, 34.27136], [-118.35001, 34.27136], [-118.34913, 34.27125], [-118.34883, 34.27106], [-118.34638, 34.27079], [-118.3461, 34.27079], [-118.34579, 34.27083], [-118.34487, 34.27088], [-118.34383, 34.27067], [-118.34275, 34.27038], [-118.34297, 34.2702], [-118.34461, 34.26985], [-118.34448, 34.26941], [-118.34405, 34.26957], [-118.34268, 34.26987], [-118.34194, 34.26956], [-118.34228, 34.26782], [-118.33932, 34.26743], [-118.33933, 34.26732], [-118.33824, 34.26717], [-118.33809, 34.26706], [-118.33774, 34.26708], [-118.33774, 34.2671], [-118.33771, 34.26708], [-118.33752, 34.26709], [-118.33678, 34.26627], [-118.33684, 34.26622], [-118.33636, 34.26564], [-118.33801, 34.26554], [-118.33802, 34.26556], [-118.33921, 34.26572], [-118.3404, 34.26577], [-118.34054, 34.26507], [-118.34096, 34.26513], [-118.34096, 34.26515], [-118.34167, 34.26525], [-118.34171, 34.26509], [-118.34256, 34.26511], [-118.34257, 34.26507], [-118.34282, 34.26507], [-118.34299, 34.26424], [-118.34363, 34.26427], [-118.34414, 34.26432], [-118.34481, 34.26442], [-118.34531, 34.26452], [-118.34609, 34.26472], [-118.3483, 34.26542], [-118.34897, 34.26558], [-118.34944, 34.26565], [-118.35413, 34.26605], [-118.35603, 34.26619], [-118.35857, 34.26622], [-118.35865, 34.26614]]]} | Restricted Access 2 | 45521 | Unnamed - Los Angeles County Flood Control District | 30959 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | http://dpw.lacounty.gov/wrd/Projects/BTWMA/index.cfm | Los Angeles 6 | 242.496 | 0 | Local Other or Unknown 14 | 4 | |
4694 | 4694 | 4693 | {"type": "Polygon", "coordinates": [[[-117.90308, 34.64234], [-117.90298, 34.64592], [-117.89442, 34.64592], [-117.89406, 34.64594], [-117.89415, 34.64234], [-117.89864, 34.64232], [-117.90308, 34.64234]]]} | Restricted Access 2 | 45942 | Unnamed site - Los Angeles, County of | 29046 | 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 | Los Angeles 6 | 80.519 | 0 | Local Other or Unknown 14 | 4 | ||
4758 | 4758 | 4757 | {"type": "Polygon", "coordinates": [[[-123.96182, 40.47601], [-123.96157, 40.47625], [-123.96067, 40.47662], [-123.95893, 40.478], [-123.95764, 40.47896], [-123.95666, 40.48], [-123.95668, 40.4767], [-123.95728, 40.4765], [-123.95804, 40.47633], [-123.9587, 40.47616], [-123.95966, 40.47599], [-123.96182, 40.47601]]]} | Restricted Access 2 | 46661 | Unnamed site - Humboldt, County of | 29996 | 348 | Humboldt, County of 552 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | Humboldt 45 | 19.487 | 0 | Local Other or Unknown 14 | 4 | ||
4765 | 4765 | 4764 | {"type": "Polygon", "coordinates": [[[-118.64125, 34.08303], [-118.64124, 34.08543], [-118.6369, 34.08542], [-118.6382, 34.08423], [-118.63902, 34.08386], [-118.63915, 34.08375], [-118.6392, 34.08385], [-118.63947, 34.08386], [-118.63997, 34.08356], [-118.64125, 34.08303]]]} | Restricted Access 2 | 46840 | Unnamed site - National Park Service | 31224 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 15.693 | 0 | Federal Other or Unknown 87 | 4 | ||
4781 | 4781 | 4780 | {"type": "Polygon", "coordinates": [[[-117.09427, 33.49075], [-117.09413, 33.4908], [-117.09236, 33.48975], [-117.09204, 33.48957], [-117.09188, 33.48943], [-117.09177, 33.48927], [-117.0916, 33.48886], [-117.09146, 33.48864], [-117.09201, 33.48839], [-117.09211, 33.48855], [-117.09206, 33.4891], [-117.09194, 33.48924], [-117.09198, 33.4893], [-117.09222, 33.48943], [-117.09228, 33.48942], [-117.09233, 33.48948], [-117.09239, 33.48951], [-117.09237, 33.48959], [-117.09326, 33.49009], [-117.09336, 33.49005], [-117.09339, 33.49009], [-117.09345, 33.49012], [-117.09356, 33.49012], [-117.09361, 33.4902], [-117.09398, 33.49024], [-117.09411, 33.49022], [-117.09427, 33.49075]]]} | Restricted Access 2 | 47164 | Unknown Park - Paseo del Sol Master Association | 31757 | 6110 | Paseo del Sol Master Association 780 | Private 7 | Home Owners Association 16 | http://www.twmc.com/paseodelsol/ | Private 14 | 6110 | Paseo del Sol Master Association 760 | Private 7 | Home Owners Association 15 | Riverside 10 | 2.526 | 0 | Private Recreation or Education 65 | 4 | ||
4782 | 4782 | 4781 | {"type": "MultiPolygon", "coordinates": [[[[-118.31523, 34.27262], [-118.31155, 34.27525], [-118.31209, 34.27614], [-118.31019, 34.27715], [-118.31018, 34.27759], [-118.30864, 34.278], [-118.30827, 34.27922], [-118.30683, 34.28], [-118.30504, 34.28028], [-118.30418, 34.27659], [-118.3067, 34.27613], [-118.30776, 34.27606], [-118.30797, 34.27532], [-118.30739, 34.27455], [-118.3079, 34.27436], [-118.30845, 34.27422], [-118.30878, 34.27411], [-118.30893, 34.27404], [-118.30921, 34.27384], [-118.30958, 34.27409], [-118.31025, 34.27505], [-118.31221, 34.27344], [-118.31465, 34.27267], [-118.31408, 34.27288], [-118.31389, 34.27298], [-118.31396, 34.27307], [-118.31454, 34.27284], [-118.31523, 34.27262]], [[-118.30988, 34.27535], [-118.30988, 34.27534], [-118.30953, 34.27504], [-118.30924, 34.27461], [-118.30928, 34.27454], [-118.30927, 34.27453], [-118.30885, 34.27447], [-118.3087, 34.27429], [-118.30803, 34.27437], [-118.30782, 34.27443], [-118.30784, 34.27447], [-118.30799, 34.27441], [-118.3086, 34.27434], [-118.30861, 34.27438], [-118.30817, 34.27444], [-118.30816, 34.27446], [-118.30908, 34.27567], [-118.30988, 34.27535]]], [[[-118.31018, 34.27763], [-118.31014, 34.27952], [-118.30543, 34.28199], [-118.30505, 34.28031], [-118.30684, 34.28003], [-118.30831, 34.27923], [-118.30868, 34.27803], [-118.31018, 34.27763]]], [[[-118.31695, 34.27216], [-118.31632, 34.27264], [-118.31581, 34.27301], [-118.3158, 34.27253], [-118.31583, 34.27253], [-118.31587, 34.27248], [-118.31656, 34.27226], [-118.31695, 34.27216]]]]} | Restricted Access 2 | 47252 | Unnamed site - Los Angeles, City of | 30961 | 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 | 88.776 | 0 | Local Other or Unknown 14 | 4 | ||
4793 | 4793 | 4792 | {"type": "MultiPolygon", "coordinates": [[[[-121.29204, 38.27768], [-121.29158, 38.27785], [-121.29136, 38.27788], [-121.29122, 38.27786], [-121.29102, 38.27778], [-121.29092, 38.27771], [-121.29083, 38.27761], [-121.29072, 38.27737], [-121.29065, 38.27731], [-121.29057, 38.27728], [-121.29048, 38.27726], [-121.29034, 38.27729], [-121.29026, 38.27734], [-121.2902, 38.27744], [-121.29019, 38.27802], [-121.29016, 38.27812], [-121.2901, 38.27821], [-121.28997, 38.27832], [-121.28986, 38.27837], [-121.28977, 38.27838], [-121.28944, 38.27834], [-121.28902, 38.27938], [-121.28899, 38.27942], [-121.28886, 38.27952], [-121.28876, 38.27956], [-121.28864, 38.27957], [-121.28848, 38.27966], [-121.28881, 38.28013], [-121.28882, 38.28017], [-121.28881, 38.2802], [-121.28838, 38.28045], [-121.28808, 38.28066], [-121.28721, 38.28136], [-121.28673, 38.28166], [-121.28621, 38.28191], [-121.28512, 38.28234], [-121.28459, 38.28251], [-121.28411, 38.28262], [-121.28339, 38.28269], [-121.28279, 38.28271], [-121.28274, 38.2827], [-121.28271, 38.28266], [-121.28269, 38.28233], [-121.28313, 38.28232], [-121.28319, 38.28229], [-121.28327, 38.28233], [-121.28337, 38.28234], [-121.28349, 38.28231], [-121.28387, 38.28225], [-121.28423, 38.28218], [-121.28475, 38.28203], [-121.28583, 38.28161], [-121.28631, 38.28139], [-121.28676, 38.28112], [-121.28698, 38.28096], [-121.28717, 38.28078], [-121.28725, 38.28073], [-121.2873, 38.28066], [-121.2873, 38.2806], [-121.28728, 38.28055], [-121.28734, 38.28052], [-121.2876, 38.2799], [-121.28755, 38.27979], [-121.28758, 38.27975], [-121.28758, 38.2797], [-121.28771, 38.27969], [-121.28792, 38.27918], [-121.28802, 38.27903], [-121.28816, 38.2787], [-121.28869, 38.27764], [-121.28882, 38.27746], [-121.28898, 38.27728], [-121.28916, 38.27713], [-121.28948, 38.27693], [-121.28976, 38.27682], [-121.29042, 38.2766], [-121.29066, 38.27659], [-121.2909, 38.27663], [-121.29111, 38.27672], [-121.29122, 38.27681], [-121.29131, 38.2769], [-121.29135, 38.27695], [-121.29127, 38.27699], [-121.29147, 38.27745], [-121.29155, 38.27749], [-121.29169, 38.27751], [-121.29178, 38.2775], [-121.2919, 38.27744], [-121.29204, 38.27768]]], [[[-121.30035, 38.27651], [-121.30032, 38.27682], [-121.30028, 38.277], [-121.3002, 38.27717], [-121.29942, 38.27706], [-121.2968, 38.27706], [-121.29631, 38.27711], [-121.29594, 38.27721], [-121.29553, 38.27735], [-121.29535, 38.27739], [-121.29517, 38.27739], [-121.29498, 38.27738], [-121.29385, 38.27719], [-121.29363, 38.27718], [-121.29348, 38.2772], [-121.29334, 38.27725], [-121.29323, 38.27732], [-121.29301, 38.2775], [-121.29284, 38.27761], [-121.29264, 38.2777], [-121.29243, 38.27777], [-121.29213, 38.27722], [-121.29247, 38.27708], [-121.29274, 38.27684], [-121.29348, 38.27665], [-121.29354, 38.27669], [-121.29365, 38.2767], [-121.29379, 38.27663], [-121.29424, 38.27653], [-121.29443, 38.27653], [-121.29453, 38.27646], [-121.29458, 38.27648], [-121.29523, 38.27628], [-121.29553, 38.27621], [-121.29583, 38.27618], [-121.2963, 38.27617], [-121.29753, 38.27624], [-121.29758, 38.2763], [-121.29766, 38.27632], [-121.29784, 38.2763], [-121.29934, 38.27638], [-121.29947, 38.27642], [-121.29958, 38.2764], [-121.29964, 38.27635], [-121.30035, 38.27651]]], [[[-121.30096, 38.27735], [-121.30038, 38.27726], [-121.30051, 38.27695], [-121.30056, 38.27663], [-121.30091, 38.27661], [-121.30095, 38.27685], [-121.30096, 38.27735]]]]} | Restricted Access 2 | 48279 | Unnamed Site - Galt, City of | 32849 | 1407 | Galt, City of 623 | City 2 | City Agency 2 | http://www.ci.galt.ca.us/index.aspx?page=71 | City 2 | 1407 | Galt, City of 612 | City 2 | City Agency 2 | Sacramento 41 | 35.606 | 0 | Local Other or Unknown 14 | 4 | ||
4797 | 4797 | 4796 | {"type": "MultiPolygon", "coordinates": [[[[-117.23584, 34.05241], [-117.23549, 34.05282], [-117.23539, 34.05282], [-117.23539, 34.05228], [-117.23553, 34.05229], [-117.23564, 34.05231], [-117.23584, 34.05241]]], [[[-117.23799, 34.05321], [-117.23708, 34.05429], [-117.23702, 34.0543], [-117.23669, 34.0541], [-117.23668, 34.05405], [-117.23759, 34.05298], [-117.23765, 34.05297], [-117.23798, 34.05316], [-117.23799, 34.05321]]], [[[-117.23727, 34.04704], [-117.23727, 34.04741], [-117.23683, 34.04741], [-117.23684, 34.04703], [-117.23704, 34.04703], [-117.23706, 34.04698], [-117.23707, 34.04703], [-117.23727, 34.04704]]], [[[-117.23878, 34.0544], [-117.23852, 34.05439], [-117.23842, 34.05435], [-117.2383, 34.05429], [-117.23867, 34.05386], [-117.23878, 34.05386], [-117.23878, 34.0544]]]]} | Restricted Access 2 | 48470 | Unnamed Park - Mission Trails HOA | 33179 | 7032 | Mission Trails HOA 783 | Private 7 | Home Owners Association 16 | https://www.facebook.com/pg/missiontrailshoa/about/?ref=page_internal | Private 14 | 7032 | Mission Trails HOA 763 | Private 7 | Home Owners Association 15 | San Bernardino 22 | 2.938 | None 403 | ||||
4808 | 4808 | 4807 | {"type": "MultiPolygon", "coordinates": [[[[-115.78321, 33.44046], [-115.77392, 33.44108], [-115.77379, 33.43758], [-115.78294, 33.4371], [-115.78321, 33.44046]]], [[[-116.06984, 33.53319], [-116.06976, 33.54008], [-116.06173, 33.54013], [-116.06184, 33.5332], [-116.06984, 33.53319]]], [[[-116.07016, 33.54381], [-116.06187, 33.54384], [-116.0618, 33.54029], [-116.07006, 33.54025], [-116.07016, 33.54381]]], [[[-116.07025, 33.52194], [-116.07021, 33.52554], [-116.06587, 33.52555], [-116.06592, 33.52195], [-116.07025, 33.52194]]], [[[-116.07884, 33.54003], [-116.07005, 33.54008], [-116.07018, 33.5293], [-116.07878, 33.52922], [-116.07884, 33.54003]]], [[[-116.08351, 33.52921], [-116.07898, 33.52923], [-116.07896, 33.52627], [-116.08048, 33.52731], [-116.0814, 33.52791], [-116.08233, 33.5285], [-116.08351, 33.52921]]], [[[-116.0877, 33.56202], [-116.08765, 33.56926], [-116.0833, 33.56925], [-116.08334, 33.56386], [-116.08121, 33.56385], [-116.08123, 33.56203], [-116.0877, 33.56202]]], [[[-116.08997, 33.5328], [-116.08539, 33.53282], [-116.08537, 33.53101], [-116.08323, 33.53101], [-116.08341, 33.52924], [-116.08353, 33.52924], [-116.08618, 33.53071], [-116.08938, 33.5324], [-116.08966, 33.53257], [-116.08997, 33.5328]]], [[[-116.08549, 33.5593], [-116.08548, 33.5602], [-116.08328, 33.56019], [-116.08328, 33.55931], [-116.08549, 33.5593]]], [[[-116.10722, 33.56925], [-116.09547, 33.56926], [-116.09556, 33.55473], [-116.09612, 33.55585], [-116.09672, 33.5569], [-116.09739, 33.55791], [-116.09787, 33.55857], [-116.09832, 33.55915], [-116.09885, 33.55978], [-116.10621, 33.56821], [-116.10722, 33.56925]]]]} | Restricted Access 2 | 48605 | Unnamed Site - Coachella Valley Association of Governments | 33314 | 2018 | Coachella Valley Association of Governments 788 | Special District 4 | Metropolitan Planning Organization 27 | http://www.cvag.org/ | Special District 4 | 2018 | Coachella Valley Association of Governments 767 | Special District 4 | Metropolitan Planning Organization 25 | http://www.cvag.org | Riverside 10 | 909.041 | 0 | Local Other or Unknown 14 | 4 | |
5686 | 5686 | 5685 | {"type": "MultiPolygon", "coordinates": [[[[-118.3146, 34.27718], [-118.31015, 34.27952], [-118.31012, 34.28089], [-118.30824, 34.28088], [-118.30823, 34.28248], [-118.29952, 34.28253], [-118.29956, 34.27885], [-118.29706, 34.27885], [-118.29722, 34.27856], [-118.29724, 34.27849], [-118.29738, 34.2783], [-118.29747, 34.27821], [-118.29783, 34.27791], [-118.29786, 34.27793], [-118.29789, 34.27792], [-118.29821, 34.27767], [-118.29855, 34.27746], [-118.30008, 34.27668], [-118.3003, 34.2766], [-118.30082, 34.27644], [-118.30124, 34.27638], [-118.30148, 34.27636], [-118.30179, 34.27635], [-118.30215, 34.27638], [-118.30253, 34.27644], [-118.30288, 34.27652], [-118.30345, 34.27671], [-118.30377, 34.27657], [-118.30377, 34.27655], [-118.30284, 34.27626], [-118.30232, 34.27616], [-118.30186, 34.27612], [-118.30133, 34.27613], [-118.30082, 34.2762], [-118.30049, 34.27628], [-118.3001, 34.27642], [-118.29959, 34.27575], [-118.29954, 34.27574], [-118.29962, 34.27549], [-118.29968, 34.27539], [-118.29981, 34.27528], [-118.3, 34.27521], [-118.30057, 34.27519], [-118.30046, 34.27535], [-118.30057, 34.27547], [-118.3008, 34.2755], [-118.3011, 34.27538], [-118.30106, 34.27524], [-118.30099, 34.27511], [-118.30108, 34.27507], [-118.3012, 34.27498], [-118.30129, 34.27487], [-118.30137, 34.27475], [-118.30153, 34.27463], [-118.30177, 34.27453], [-118.30201, 34.27451], [-118.30222, 34.27422], [-118.30235, 34.27419], [-118.30258, 34.27423], [-118.30327, 34.27406], [-118.30329, 34.27402], [-118.30407, 34.27408], [-118.30494, 34.27453], [-118.30407, 34.27497], [-118.30424, 34.27605], [-118.30424, 34.27608], [-118.30407, 34.27612], [-118.30544, 34.28198], [-118.31014, 34.27952], [-118.31018, 34.27715], [-118.31201, 34.27618], [-118.3146, 34.27718]]], [[[-118.29958, 34.27524], [-118.29947, 34.27538], [-118.2994, 34.27551], [-118.29898, 34.27524], [-118.29958, 34.27524]]], [[[-118.30022, 34.27503], [-118.29996, 34.27505], [-118.29981, 34.2751], [-118.29971, 34.27515], [-118.29971, 34.27511], [-118.30005, 34.27499], [-118.30022, 34.27503]]]]} | Restricted Access 2 | 47237 | Unnamed site - Los Angeles - Department of Water and Power, City of | 30960 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 1400 | Los Angeles - Department of Water and Power, City of 278 | City 2 | City Agency 2 | Los Angeles 6 | 138.829 | 0 | Local Other or Unknown 14 | 4 | ||
5693 | 5693 | 5692 | {"type": "Polygon", "coordinates": [[[-116.9052, 33.74329], [-116.90501, 33.7433], [-116.905, 33.74348], [-116.90478, 33.74342], [-116.90427, 33.74342], [-116.90426, 33.74343], [-116.90381, 33.74341], [-116.9038, 33.74359], [-116.90363, 33.74359], [-116.90363, 33.74341], [-116.9023, 33.74342], [-116.90203, 33.74347], [-116.90203, 33.74298], [-116.90225, 33.74307], [-116.90248, 33.74307], [-116.90266, 33.74299], [-116.90283, 33.74306], [-116.90306, 33.74306], [-116.90324, 33.74299], [-116.90342, 33.74306], [-116.90364, 33.74306], [-116.90383, 33.74298], [-116.90401, 33.74306], [-116.90423, 33.74306], [-116.90442, 33.74298], [-116.90459, 33.74306], [-116.90482, 33.74305], [-116.905, 33.74298], [-116.905, 33.74326], [-116.9052, 33.74326], [-116.9052, 33.74329]]]} | Restricted Access 2 | 48937 | Unknown park - Briarcliff Homeowners Association | 33654 | 6137 | Briarcliff Homeowners Association 813 | Private 7 | Home Owners Association 16 | https://www.briarcliff.org/ | Private 14 | 6137 | Briarcliff Homeowners Association 792 | Private 7 | Home Owners Association 15 | Riverside 10 | 3.003 | 0 | Private Recreation or Education 65 | 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]);