units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,394 rows where AGNCY_LEV = 2 sorted by AGNCY_ID
This data as json, copyable, CSV (advanced)
Suggested facets: COUNTY, YR_EST
DES_TP 775
- Local Park 7,352
- Local Recreation Area 1,414
- Local Other or Unknown 661
- Local Conservation Area 149
- Local Historic or Cultural Area 38
- Local Resource Management Area 6
- National Monument or Landmark 5
- State Conservation Area 2
- None 1
- None 1
- National Forest 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
- National Recreation 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
- National Wildlife Refuge 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
- State Historic or Cultural 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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_AGENCY 510
- San Diego, City of 525
- Los Angeles, City of 485
- San Jose, City of 253
- San Francisco, City and County of 238
- Sacramento, City of 220
- Ventura, City of 151
- Long Beach, City of 144
- Roseville, City of 130
- Oakland, City of 122
- Irvine, City of 98
- Fresno, City of 90
- Modesto, City of 85
- Santa Rosa, City of 82
- Stockton, City of 81
- Napa, City of 81
- Huntington Beach, City of 76
- Tracy, City of 73
- Santa Cruz, City of 72
- Torrance, City of 72
- Chula Vista, City of 70
- Brentwood, City of 68
- Poway, City of 67
- Davis, City of 65
- San Luis Obispo, City of 64
- Santa Barbara, City of 64
- Newport Beach, City of 64
- Glendale, City of 61
- Bakersfield, City of 61
- Manteca, City of 61
- Riverside, City of 60
- Clovis, City of 60
- Anaheim, City of 59
- Fullerton, City of 58
- Fremont, City of 58
- Redding, City of 57
- Rocklin, City of 56
- Vacaville, City of 55
- Encinitas, City of 54
- Murrieta, City of 51
- Redlands, City of 49
- Berkeley, City of 48
- Folsom, City of 48
- Mission Viejo, City of 47
- Novato, City of 47
- Salinas, City of 45
- Richmond, City of 44
- Pleasanton, City of 44
- Oceanside, City of 44
- Santa Clarita, City of 44
- San Ramon, City of 43
- Petaluma, City of 43
- Visalia, City of 43
- Chico, City of 43
- Watsonville, City of 42
- Corona, City of 42
- Chino Hills, City of 42
- San Bernardino, City of 42
- Temecula, City of 42
- Santa Ana, City of 41
- Oxnard, City of 41
- Los Banos, City of 40
- Arcata, City of 40
- Moreno Valley, City of 39
- San Marcos, City of 38
- Redwood City, City of 38
- San Mateo, City of 37
- Seaside, City of 37
- Redondo Beach, City of 37
- Carlsbad, City of 36
- Palo Alto, City of 36
- Antioch, City of 36
- Santa Maria, City of 35
- Fontana, City of 35
- Livermore, City of 35
- San Rafael, City of 35
- Escondido, City of 34
- Pasadena, City of 34
- Union City, City of 34
- Santa Clara, City of 34
- Merced, City of 34
- California City, City of 34
- Burbank, City of 33
- Mountain View, City of 33
- Patterson, City of 32
- Turlock, City of 32
- Costa Mesa, City of 32
- Rancho Cucamonga, City of 32
- Fairfield, City of 32
- West Sacramento, City of 32
- Monterey, City of 31
- San Jacinto, City of 31
- Lake Forest, City of 31
- Pomona, City of 30
- Santa Monica, City of 30
- Oakley, City of 30
- Chino, City of 30
- Whittier, City of 30
- Tiburon, Town of 30
- Yorba Linda, City of 29
- Concord, City of 29
- Laguna Niguel, City of 29
- Alameda, City of 28
- Lodi, City of 27
- Lompoc, City of 26
- Palmdale, City of 26
- Daly City, City of 26
- Woodland, City of 26
- Azusa, City of 25
- Benicia, City of 25
- Eureka, City of 25
- Claremont, City of 24
- South San Francisco, City of 24
- San Juan Capistrano, City of 24
- Westminster, City of 24
- Rancho Palos Verdes, City of 24
- La Verne, City of 24
- Rohnert Park, City of 24
- Oakdale, City of 23
- Ontario, City of 23
- San Leandro, City of 23
- Cupertino, City of 23
- Cerritos, City of 23
- Morgan Hill, City of 23
- Sunnyvale, City of 23
- Yuba City, City of 23
- Calexico, City of 23
- Dana Point, City of 22
- La Habra, City of 22
- Mill Valley, City of 22
- Hermosa Beach, City of 22
- Pittsburg, City of 22
- Lincoln, City of 22
- Dublin, City of 21
- Walnut Creek, City of 21
- Fountain Valley, City of 21
- South Pasadena, City of 21
- Gilroy, City of 21
- Foster City, City of 21
- Ripon, City of 21
- Galt, City of 21
- Victorville, City of 20
- Orange, City of 20
- West Covina, City of 20
- San Clemente, City of 20
- Milpitas, City of 20
- San Bruno, City of 20
- Culver City, City of 19
- Garden Grove, City of 19
- Coronado, City of 19
- Moorpark, City of 19
- Greenfield, City of 19
- Cypress, City of 19
- El Segundo, City of 19
- Pacifica, City of 19
- Thousand Oaks, City of 19
- American Canyon, City of 19
- Sausalito, City of 19
- Vista, City of 18
- Loma Linda, City of 18
- Belmont, City of 18
- Sanger, City of 18
- San Dimas, City of 18
- Palos Verdes Estates, City of 18
- Diamond Bar, City of 18
- Sonoma, City of 18
- El Cajon, City of 17
- Glendora, City of 17
- Pacific Grove, City of 17
- Laguna Beach, City of 17
- Lake Elsinore, City of 17
- Walnut, City of 17
- Windsor, Town of 17
- Atwater, City of 17
- Vallejo, City of 17
- Marysville, City of 17
- Aliso Viejo, City of 17
- Mountains Recreation and Conservation Authority 16
- Riverbank, City of 16
- Scotts Valley, City of 16
- Norco, City of 16
- Tulare, City of 16
- Beverly Hills, City of 16
- Placentia, City of 16
- Tustin, City of 16
- Arcadia, City of 16
- Carson, City of 16
- Martinez, City of 16
- Pismo Beach, City of 16
- Larkspur, City of 16
- La Quinta, City of 16
- Brawley, City of 15
- Compton, City of 15
- Los Angeles - Department of Water and Power, City of 15
- Sierra Madre, City of 15
- Hanford, City of 15
- Millbrae, City of 15
- Saint Helena, City of 15
- Los Gatos, Town of 15
- Oroville, City of 15
- Perris, City of 15
- Beaumont, City of 15
- Lancaster, City of 14
- La Mesa, City of 14
- El Centro, City of 14
- Monterey Park, City of 14
- Hollister, City of 14
- Menlo Park, City of 14
- Brea, City of 14
- Norwalk, City of 14
- Rolling Hills Estates, City of 14
- Calabasas, City of 14
- Newark, City of 14
- San Carlos, City of 14
- Ceres, City of 14
- Saratoga, City of 14
- Canyon Lake, City of 14
- Seal Beach, City of 13
- Yucaipa, City of 13
- Paso Robles, City of 13
- Porterville, City of 13
- Upland, City of 13
- Laguna Hills, City of 13
- El Monte, City of 13
- Montebello, City of 13
- Lakewood, City of 13
- El Cerrito, City of 13
- Mammoth Lakes, Town of 13
- Downey, City of 12
- Colton, City of 12
- Santa Fe Springs, City of 12
- Reedley, City of 12
- Inglewood, City of 12
- La Mirada, City of 12
- Duarte, City of 12
- Pinole, City of 12
- Madera, City of 12
- Guadalupe, City of 12
- Lathrop, City of 12
- Morro Bay, City of 12
- Santee, City of 11
- Capitola, City of 11
- Exeter, City of 11
- Buena Park, City of 11
- Hemet, City of 11
- Marina, City of 11
- Indio, City of 11
- Bell Gardens, City of 11
- Hawthorne, City of 11
- Monrovia, City of 11
- Healdsburg, City of 11
- Corte Madera, Town of 11
- San Anselmo, City of 11
- Soledad, City of 11
- Manhattan Beach, City of 11
- Palm Springs, City of 11
- Stanton, City of 11
- Suisun City, City of 11
- Auburn, City of 11
- Los Angeles, County of 10
- Imperial, City of 10
- Montclair, City of 10
- Carpinteria, City of 10
- Coachella, City of 10
- East Bay Regional Park District 10
- Rialto, City of 10
- Dinuba, City of 10
- Rosemead, City of 10
- Alhambra, City of 10
- Goleta, City of 10
- Escalon, City of 10
- Yucca Valley, Town of 10
- Paramount, City of 10
- Gardena, City of 10
- Signal Hill, City of 10
- Bellflower, City of 10
- Los Angeles Department of Recreation and Parks, City of 10
- Ukiah, City of 10
- Ojai, City of 9
- Santa Paula, City of 9
- Covina, City of 9
- Kerman, City of 9
- Barstow, City of 9
- Palm Desert, City of 9
- Los Alamitos, City of 9
- Agoura Hills, City of 9
- Rio Vista, City of 9
- Burlingame, City of 9
- Delano, City of 9
- Gonzales, City of 9
- Colusa, City of 9
- Newman, City of 9
- Sebastopol, City of 9
- Arroyo Grande, City of 9
- South Lake Tahoe, City of 9
- Del Mar, City of 8
- Woodlake, City of 8
- Livingston, City of 8
- Kingsburg, City of 8
- Lynwood, City of 8
- Hercules, City of 8
- Red Bluff, City of 8
- Cathedral City, City of 8
- Fillmore, City of 8
- Grover Beach, City of 8
- South Gate, City of 8
- Yreka, City of 8
- Yountville, Town of 8
- Emeryville, City of 8
- National City, City of 7
- Solvang, City of 7
- Grand Terrace, City of 7
- San Pablo, City of 7
- Highland, City of 7
- Albany, City of 7
- Shasta Lake, City of 7
- La Canada Flintridge, City of 7
- Blythe, City of 7
- Cotati, City of 7
- Pico Rivera, City of 7
- Cloverdale, City of 7
- Los Altos, City of 7
- Lomita, City of 7
- Danville, Town of 7
- Piedmont, City of 7
- Wheatland, City of 7
- Clayton, City of 7
- Huntington Park, City of 6
- San Fernando, City of 6
- Selma, City of 6
- Needles, City of 6
- Westlake Village, City of 6
- West Hollywood, City of 6
- Bell, City of 6
- Banning, City of 6
- Lemoore, City of 6
- Dixon, City of 6
- Live Oak, City of 6
- Half Moon Bay, City of 6
- Campbell, City of 6
- King City, City of 6
- Placerville, City of 6
- Carmel-by-the-Sea, City of 6
- Winters, City of 6
- Port Hueneme, City of 6
- Lemon Grove, City of 6
- East Palo Alto, City of 6
- Desert Hot Springs, City of 6
- Menifee, City of 6
- Williams, City of 6
- Calistoga, City of 6
- Waterford, City of 5
- Farmersville, City of 5
- Baldwin Park, City of 5
- Adelanto, City of 5
- Maywood, City of 5
- Avalon, City of 5
- Loomis, Town of 5
- Commerce, City of 5
- Conejo Open Space Conservation Agency 5
- Gustine, City of 5
- Orland, City of 5
- South El Monte, City of 5
- Imperial Beach, City of 5
- Rio Dell, City of 5
- Corning, City of 5
- Grass Valley, City of 5
- San Gabriel, City of 5
- Ridgecrest, City of 5
- Point Arena, City of 5
- Fort Bragg, City of 5
- Buellton, City of 4
- Lindsay, City of 4
- Holtville, City of 4
- Lafayette, City of 4
- Corcoran, City of 4
- Orinda, City of 4
- Parlier, City of 4
- Arvin, City of 4
- Lawndale, City of 4
- Gridley, City of 4
- Cudahy, City of 4
- Firebaugh, City of 4
- Atascadero, City of 4
- Willits, City of 4
- Rancho Mirage, City of 4
- Ione, City of 4
- La Palma, City of 4
- Brisbane, City of 4
- Calipatria, City of 4
- Tulelake, City of 4
- Moraga, Town of 4
- Irwindale, City of 4
- Crescent City, City of 4
- Irvine Ranch Conservancy 4
- Hughson, City of 4
- Fairfax, Town of 4
- Malibu, City of 4
- Colma, City of 4
- Fortuna, City of 4
- Susanville, City of 4
- San Diego, County of 3
- Solana Beach, City of 3
- Dos Palos, City of 3
- Mendota, City of 3
- Desert Recreation District 3
- Rolling Hills, City of 3
- Tehachapi, City of 3
- Shafter, City of 3
- Belvedere, City of 3
- Santa Clara County Parks and Recreation Dept., County of 3
- San Francisco Parks Alliance 3
- Artesia, City of 3
- Weed, City of 3
- Lakeport, City of 3
- Blue Lake, City of 3
- Orange Cove, City of 3
- Private Landowner 3
- Chowchilla, City of 3
- Ross, Town of 3
- Hawaiian Gardens, City of 3
- Elk Grove, City of 3
- Isleton, City of 3
- Willows, City of 3
- Nevada City, City of 3
- Angels Camp, City of 3
- Bradbury, City of 3
- California Department of Fish and Wildlife 2
- Orange, County of 2
- San Diego Unified Port District 2
- San Joaquin, City of 2
- Pleasant Hill, City of 2
- Temple City, City of 2
- Auburn Area Recreation and Park District 2
- Sand City, City of 2
- Wildomar, City of 2
- Fowler, City of 2
- Anderson, City of 2
- Sutter Creek, City of 2
- Sonora, City of 2
- Calimesa, City of 2
- Trinidad, City of 2
- Los Angeles Department of Public Works, County of 2
- Avenal, City of 2
- MJM Management Group 2
- Alturas, City of 2
- Coalinga, City of 2
- La Puente, City of 2
- Big League Dreams 2
- Del Rey Oaks, City of 2
- Los Angeles - Community Redevelopment Agency, City of 2
- San Juan Bautista, City of 2
- Big Bear Lake, City of 2
- McFarland, City of 2
- Clearlake, City of 2
- Jackson, City of 2
- Tehama, City of 2
- Hesperia, City of 2
- American Golf 2
- California Department of Parks and Recreation 1
- Rancho Simi Recreation and Park District 1
- Land Trust of Santa Cruz County 1
- Pleasant Valley Recreation and Park District 1
- Marin County Parks Department, County of 1
- Valley-Wide Recreation and Park District 1
- California Department of Transportation 1
- Santa Monica Mountains Conservancy 1
- San Marino, City of 1
- Santa Clara Valley Open Space Authority 1
- Maricopa, City of 1
- Plymouth, City of 1
- National Audubon Society 1
- Boys and Girls Clubs of South County 1
- Redlands Conservancy 1
- Inyo, County of 1
- Rancho Cordova, City of 1
- Biggs, City of 1
- Paradise, City of 1
- Trust for Public Land 1
- Palos Verdes Peninsula Land Conservancy 1
- Hidden Hills, City of 1
- Amador City, City of 1
- Wasco, City of 1
- San Francisco, City and County of, Redevelopment Agency 1
- Dorris, City of 1
- La Habra Heights, City of 1
- Los Altos Hills, Town of 1
- The Old Mill Foundation 1
- San Diego Zoo Global 1
- Bay Club 1
- La Verne Heritage Foundation 1
- Atherton, Town of 1
- Silver Dollar BMX 1
- Hillsborough, Town of 1
- Laguna Woods, City of 1
- Central Valley Community Sports Foundation 1
- Etna, City of 1
- Ferndale, City of 1
- Colfax, City of 1
- Portola, City of 1
- Concord Landscaping and Lighting Maintenance District No. 3 1
- Bishop, City of 1
- Lao Family Community Development, Inc. 1
- Loyalton, City of 1
- Los Angeles Golf Club 1
- Westmorland, City of 1
- Dunsmuir, City of 1
- Fort Jones, City of 1
- YMCA of Southeast - Rio Vista 1
- Pasadena Department of Water and Power 1
- JC Resorts 1
MNG_AG_TYP 14
- City Agency 10,292
- Open Space District 21
- Recreation/Parks District 19
- County Agency 16
- Non Profit - Other 11
- Commercial 9
- Non Profit - Conservation 7
- State Agency 5
- County Agency - Parks 4
- Other 3
- County Agency - Other 2
- Non Profit - Land Trust 2
- Port/Harbor District 2
- Community Services District 1
ACCESS_TYP 4
- Open Access 9,898
- Restricted Access 260
- No Public Access 207
- Unknown Access 29
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1114 | 1114 | 1113 | {"type": "Polygon", "coordinates": [[[-118.7559, 34.15989], [-118.75536, 34.16003], [-118.75504, 34.16018], [-118.75477, 34.15985], [-118.7547, 34.15989], [-118.75465, 34.15985], [-118.7547, 34.15977], [-118.75426, 34.15923], [-118.75461, 34.15907], [-118.7549, 34.15895], [-118.75544, 34.15881], [-118.75565, 34.15878], [-118.75568, 34.1588], [-118.7559, 34.15989]]]} | Open Access 1 | 7086 | Sumac Park | 25952 | 1000 | Agoura Hills, City of 319 | City 2 | City Agency 2 | http://www.ci.agoura-hills.ca.us/government/departments/community-services-parks-recreation/parks-facilities | City 2 | 1000 | Agoura Hills, City of 316 | City 2 | City Agency 2 | Los Angeles 6 | 3.565 | Sumac Park | 0 | Local Park 2 | 4 | |
1244 | 1244 | 1243 | {"type": "Polygon", "coordinates": [[[-118.75782, 34.14997], [-118.75728, 34.1502], [-118.75717, 34.15022], [-118.75588, 34.15073], [-118.75575, 34.15081], [-118.75566, 34.15093], [-118.75562, 34.15105], [-118.75565, 34.15116], [-118.75578, 34.15144], [-118.7558, 34.15161], [-118.75578, 34.15167], [-118.75575, 34.15168], [-118.75537, 34.15161], [-118.75497, 34.15156], [-118.75442, 34.15158], [-118.7544, 34.15156], [-118.7543, 34.15109], [-118.75429, 34.15092], [-118.7543, 34.15034], [-118.75437, 34.15019], [-118.75443, 34.15012], [-118.75454, 34.15006], [-118.75517, 34.14985], [-118.75535, 34.14977], [-118.75551, 34.14964], [-118.75559, 34.14954], [-118.75564, 34.14946], [-118.75571, 34.14928], [-118.75696, 34.14927], [-118.75696, 34.14847], [-118.75721, 34.14848], [-118.7572, 34.14881], [-118.75728, 34.14907], [-118.75782, 34.14997]]]} | Open Access 1 | 7084 | Chumash Park | 17244 | 1000 | Agoura Hills, City of 319 | City 2 | City Agency 2 | http://www.ci.agoura-hills.ca.us/government/departments/community-services-parks-recreation/parks-facilities | City 2 | 1000 | Agoura Hills, City of 316 | City 2 | City Agency 2 | Los Angeles 6 | 12.237 | Chumash Park | 0 | Local Park 2 | 4 | |
1249 | 1249 | 1248 | {"type": "Polygon", "coordinates": [[[-118.74028, 34.14602], [-118.74025, 34.14701], [-118.74023, 34.14701], [-118.74007, 34.14713], [-118.73888, 34.14804], [-118.73793, 34.1474], [-118.7382, 34.14683], [-118.73883, 34.14538], [-118.73887, 34.14538], [-118.73978, 34.14564], [-118.7397, 34.14577], [-118.7399, 34.14588], [-118.74001, 34.14577], [-118.74025, 34.14595], [-118.74028, 34.14602]]]} | Open Access 1 | 7089 | Old Agoura Park | 23080 | 1000 | Agoura Hills, City of 319 | City 2 | City Agency 2 | http://www.ci.agoura-hills.ca.us/government/departments/community-services-parks-recreation/parks-facilities | City 2 | 1000 | Agoura Hills, City of 316 | City 2 | City Agency 2 | Los Angeles 6 | 9.855 | Old Agoura Park | 0 | Local Park 2 | 4 | |
1773 | 1773 | 1772 | {"type": "Polygon", "coordinates": [[[-118.77475, 34.15589], [-118.77452, 34.15647], [-118.77348, 34.15621], [-118.77348, 34.15481], [-118.77451, 34.15481], [-118.77453, 34.15483], [-118.77453, 34.15544], [-118.77457, 34.15559], [-118.77464, 34.15574], [-118.77475, 34.15589]]]} | Open Access 1 | 7087 | Morrison Park | 22498 | 1000 | Agoura Hills, City of 319 | City 2 | City Agency 2 | http://www.ci.agoura-hills.ca.us/government/departments/community-services-parks-recreation/parks-facilities | City 2 | 1000 | Agoura Hills, City of 316 | City 2 | City Agency 2 | Los Angeles 6 | 4.326 | Morrison Park | 0 | Local Park 2 | 4 | |
7521 | 7521 | 7520 | {"type": "Polygon", "coordinates": [[[-118.7838, 34.15183], [-118.78372, 34.15187], [-118.78361, 34.15191], [-118.78334, 34.15197], [-118.78238, 34.15198], [-118.7814, 34.15192], [-118.78138, 34.15189], [-118.78139, 34.15118], [-118.7818, 34.15118], [-118.78182, 34.1511], [-118.78186, 34.15112], [-118.78195, 34.15111], [-118.78196, 34.15119], [-118.78237, 34.15119], [-118.78238, 34.15108], [-118.78286, 34.15109], [-118.78296, 34.15118], [-118.78313, 34.15125], [-118.78332, 34.15125], [-118.78343, 34.15121], [-118.78362, 34.15156], [-118.7838, 34.15183]]]} | Open Access 1 | 7090 | Reyes Adobe Park | 24309 | 1000 | Agoura Hills, City of 319 | City 2 | City Agency 2 | http://www.ci.agoura-hills.ca.us/government/departments/community-services-parks-recreation/parks-facilities | City 2 | 1000 | Agoura Hills, City of 316 | City 2 | City Agency 2 | Los Angeles 6 | 4.476 | Reyes Adobe Park | 0 | Local Park 2 | 4 | |
7527 | 7527 | 7526 | {"type": "Polygon", "coordinates": [[[-118.77622, 34.15274], [-118.77577, 34.15299], [-118.77544, 34.15314], [-118.77519, 34.15322], [-118.77464, 34.15337], [-118.7746, 34.15336], [-118.77421, 34.15251], [-118.77414, 34.15225], [-118.77411, 34.15199], [-118.77412, 34.15095], [-118.77415, 34.15094], [-118.77455, 34.1509], [-118.77534, 34.1507], [-118.77562, 34.15066], [-118.77562, 34.15092], [-118.77566, 34.15128], [-118.77569, 34.15133], [-118.77565, 34.15137], [-118.77562, 34.15141], [-118.77562, 34.15146], [-118.77564, 34.15151], [-118.77557, 34.15157], [-118.77557, 34.15183], [-118.77622, 34.15274]]]} | Open Access 1 | 7091 | Forest Cove Park | 29023 | 1000 | Agoura Hills, City of 319 | City 2 | City Agency 2 | http://www.ci.agoura-hills.ca.us/government/departments/community-services-parks-recreation/parks-facilities | City 2 | 1000 | Agoura Hills, City of 316 | City 2 | City Agency 2 | Los Angeles 6 | 9.579 | Forest Cove Park | 0 | Local Park 2 | 4 | |
7532 | 7532 | 7531 | {"type": "Polygon", "coordinates": [[[-118.78099, 34.1609], [-118.78027, 34.16187], [-118.78099, 34.16417], [-118.7801, 34.16517], [-118.77827, 34.16492], [-118.77762, 34.1641], [-118.778, 34.16254], [-118.77969, 34.15982], [-118.77969, 34.1598], [-118.77867, 34.15972], [-118.77867, 34.15968], [-118.77935, 34.15968], [-118.77986, 34.15963], [-118.77994, 34.15966], [-118.78006, 34.16036], [-118.7801, 34.16048], [-118.78021, 34.16064], [-118.78038, 34.16078], [-118.78054, 34.16084], [-118.78099, 34.1609]]]} | Open Access 1 | 7109 | Agoura Hills City Parkland | 15289 | 1000 | Agoura Hills, City of 319 | City 2 | City Agency 2 | http://www.ci.agoura-hills.ca.us/government/departments/community-services-parks-recreation/parks-facilities | City 2 | 1000 | Agoura Hills, City of 316 | City 2 | City Agency 2 | Los Angeles 6 | 28.668 | Agoura Hills City Parkland | 0 | Local Park 2 | 4 | |
7534 | 7534 | 7533 | {"type": "Polygon", "coordinates": [[[-118.78014, 34.14754], [-118.78008, 34.14761], [-118.78006, 34.14768], [-118.77994, 34.14767], [-118.77967, 34.14771], [-118.77895, 34.14786], [-118.77864, 34.1479], [-118.77715, 34.14789], [-118.77638, 34.14778], [-118.77611, 34.14778], [-118.77413, 34.14793], [-118.77413, 34.14783], [-118.77432, 34.14788], [-118.77524, 34.14781], [-118.77589, 34.14763], [-118.77771, 34.1475], [-118.77817, 34.14749], [-118.77833, 34.14745], [-118.77934, 34.14745], [-118.78014, 34.14754]]]} | No Public Access 3 | 7112 | Agoura Hills City Parkland | 15288 | 1000 | Agoura Hills, City of 319 | City 2 | City Agency 2 | http://www.ci.agoura-hills.ca.us/government/departments/community-services-parks-recreation/parks-facilities | City 2 | 1000 | Agoura Hills, City of 316 | City 2 | City Agency 2 | Los Angeles 6 | 3.654 | Agoura Hills City Parkland | 0 | Local Park 2 | 4 | |
16074 | 16074 | 16073 | {"type": "MultiPolygon", "coordinates": [[[[-118.7612, 34.15938], [-118.76095, 34.15967], [-118.76079, 34.15964], [-118.76019, 34.15956], [-118.76026, 34.15926], [-118.7602, 34.15894], [-118.75993, 34.15859], [-118.75947, 34.15828], [-118.7594, 34.1581], [-118.75933, 34.15771], [-118.75928, 34.15754], [-118.75913, 34.15724], [-118.7587, 34.1572], [-118.75815, 34.1572], [-118.75822, 34.15701], [-118.75818, 34.15698], [-118.75808, 34.15683], [-118.75806, 34.15666], [-118.75818, 34.15629], [-118.75888, 34.1563], [-118.75976, 34.15687], [-118.76107, 34.15873], [-118.7612, 34.15938]]], [[[-118.76954, 34.16551], [-118.76926, 34.16565], [-118.76899, 34.16554], [-118.76889, 34.16553], [-118.76868, 34.16556], [-118.76863, 34.16555], [-118.76848, 34.16557], [-118.76841, 34.16556], [-118.76817, 34.16586], [-118.76799, 34.16599], [-118.76781, 34.166], [-118.76685, 34.16618], [-118.76644, 34.16634], [-118.76606, 34.16631], [-118.76585, 34.1662], [-118.76521, 34.16592], [-118.76502, 34.16579], [-118.76443, 34.1657], [-118.76439, 34.16573], [-118.76408, 34.16558], [-118.76362, 34.16544], [-118.76321, 34.16525], [-118.76316, 34.16528], [-118.76309, 34.16546], [-118.76269, 34.16613], [-118.76236, 34.1664], [-118.76182, 34.16606], [-118.76212, 34.1658], [-118.76224, 34.16563], [-118.76245, 34.16527], [-118.76213, 34.16503], [-118.7621, 34.16502], [-118.7621, 34.16483], [-118.76209, 34.16468], [-118.76203, 34.16451], [-118.76189, 34.16429], [-118.7618, 34.16419], [-118.7613, 34.16381], [-118.76117, 34.16368], [-118.76108, 34.16358], [-118.76096, 34.16339], [-118.76085, 34.16318], [-118.7608, 34.16301], [-118.76076, 34.16283], [-118.76075, 34.16253], [-118.76082, 34.16216], [-118.76084, 34.16194], [-118.76082, 34.1617], [-118.76075, 34.16127], [-118.76061, 34.16085], [-118.76039, 34.16045], [-118.76026, 34.16029], [-118.7602, 34.16015], [-118.76017, 34.16006], [-118.76017, 34.15992], [-118.76019, 34.15978], [-118.76026, 34.15975], [-118.76079, 34.15982], [-118.76089, 34.15984], [-118.76091, 34.16037], [-118.76164, 34.16078], [-118.76173, 34.16089], [-118.76171, 34.16096], [-118.76177, 34.16102], [-118.76175, 34.16138], [-118.76183, 34.16158], [-118.7618, 34.16167], [-118.76162, 34.16197], [-118.76155, 34.16235], [-118.762, 34.16281], [-118.76257, 34.16261], [-118.76264, 34.16269], [-118.7627, 34.16271], [-118.7627, 34.16275], [-118.76321, 34.16279], [-118.76362, 34.16247], [-118.76366, 34.16279], [-118.76312, 34.16302], [-118.76311, 34.1631], [-118.76282, 34.16307], [-118.76254, 34.16309], [-118.76234, 34.16317], [-118.76219, 34.16331], [-118.76217, 34.16347], [-118.76232, 34.16356], [-118.76289, 34.1642], [-118.76304, 34.16427], [-118.76319, 34.16427], [-118.76332, 34.16425], [-118.76346, 34.16436], [-118.76389, 34.16474], [-118.76401, 34.16478], [-118.76428, 34.16508], [-118.76446, 34.16516], [-118.76463, 34.1652], [-118.76483, 34.1652], [-118.76513, 34.16517], [-118.76531, 34.16522], [-118.76542, 34.1653], [-118.7657, 34.16522], [-118.76613, 34.16548], [-118.76666, 34.16553], [-118.76692, 34.16544], [-118.76727, 34.16553], [-118.76754, 34.16553], [-118.76782, 34.16535], [-118.76801, 34.1651], [-118.76808, 34.16483], [-118.76809, 34.16455], [-118.76838, 34.16452], [-118.7687, 34.16432], [-118.7687, 34.16437], [-118.7688, 34.1644], [-118.76873, 34.16468], [-118.76869, 34.16477], [-118.76876, 34.16491], [-118.76893, 34.16506], [-118.7692, 34.16504], [-118.76954, 34.16551]]], [[[-118.76255, 34.1681], [-118.76176, 34.16809], [-118.76187, 34.16771], [-118.76174, 34.16744], [-118.7613, 34.16689], [-118.76124, 34.16679], [-118.76124, 34.16673], [-118.76128, 34.16655], [-118.76166, 34.16619], [-118.76187, 34.1663], [-118.76221, 34.16652], [-118.76196, 34.16673], [-118.76251, 34.16755], [-118.76248, 34.16781], [-118.76255, 34.1681]]]]} | Open Access 1 | 7085 | Medea Creek Open Space | 32643 | 1000 | Agoura Hills, City of 319 | City 2 | City Agency 2 | http://www.ci.agoura-hills.ca.us/government/departments/community-services-parks-recreation/parks-facilities | City 2 | 2118 | Rancho Simi Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 42.16 | Medea Creek OS | 0 | Local Recreation Area 3 | 4 | |
16095 | 16095 | 16094 | {"type": "Polygon", "coordinates": [[[-118.74322, 34.13739], [-118.74273, 34.13773], [-118.7424, 34.13775], [-118.74194, 34.1385], [-118.74154, 34.13874], [-118.74103, 34.13875], [-118.74075, 34.13873], [-118.74055, 34.13832], [-118.74076, 34.13825], [-118.741, 34.13822], [-118.74111, 34.13819], [-118.74123, 34.13814], [-118.74132, 34.13807], [-118.74156, 34.13795], [-118.74167, 34.13786], [-118.74175, 34.1379], [-118.74179, 34.13782], [-118.74184, 34.13753], [-118.74189, 34.13743], [-118.74195, 34.13733], [-118.74201, 34.13727], [-118.74209, 34.13723], [-118.74285, 34.13708], [-118.74295, 34.13708], [-118.74305, 34.13713], [-118.74322, 34.13739]]]} | Open Access 1 | 12512 | Agoura Hills Open Space | 29518 | 1000 | Agoura Hills, City of 319 | City 2 | City Agency 2 | http://www.ci.agoura-hills.ca.us/government/departments/community-services-parks-recreation/parks-facilities | City 2 | 1000 | Agoura Hills, City of 316 | City 2 | City Agency 2 | Los Angeles 6 | 4.255 | Agoura Hills OS | 0 | Local Recreation Area 3 | 4 | |
480 | 480 | 479 | {"type": "Polygon", "coordinates": [[[-122.25181, 37.74294], [-122.25094, 37.74333], [-122.2502, 37.74331], [-122.2502, 37.74256], [-122.25026, 37.74211], [-122.25158, 37.74235], [-122.25161, 37.74252], [-122.25168, 37.74271], [-122.25181, 37.74294]]]} | Open Access 1 | 1631 | Tillman Park | 26365 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 3.586 | Tillman Park | 0 | Local Park 2 | 4 | |
1754 | 1754 | 1753 | {"type": "Polygon", "coordinates": [[[-122.26219, 37.76826], [-122.26215, 37.76912], [-122.26062, 37.76844], [-122.26111, 37.76773], [-122.26212, 37.76817], [-122.26217, 37.76821], [-122.26219, 37.76826]]]} | Open Access 1 | 13146 | Franklin Park | 19060 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 2.958 | Franklin Park | 0 | Local Park 2 | 4 | |
1964 | 1964 | 1963 | {"type": "Polygon", "coordinates": [[[-122.23324, 37.73433], [-122.23167, 37.73513], [-122.2312, 37.73448], [-122.23129, 37.73391], [-122.23247, 37.73335], [-122.23324, 37.73433]]]} | Open Access 1 | 15110 | Godfrey Park | 19352 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 4.982 | Godfrey Park | 0 | Local Park 2 | 4 | |
1965 | 1965 | 1964 | {"type": "Polygon", "coordinates": [[[-122.23947, 37.7313], [-122.23907, 37.73176], [-122.2378, 37.73113], [-122.23824, 37.73064], [-122.23947, 37.7313]]]} | Open Access 1 | 15113 | Doc Harrington Park | 18177 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 2.094 | Doc Harrington Park | 0 | Local Park 2 | 4 | |
1968 | 1968 | 1967 | {"type": "Polygon", "coordinates": [[[-122.24109, 37.75354], [-122.2401, 37.75443], [-122.23818, 37.75321], [-122.2392, 37.7522], [-122.24109, 37.75354]]]} | Open Access 1 | 15123 | Krusi Park | 20727 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 7.492 | Krusi Park | 2000 | Local Park 2 | 4 | |
1969 | 1969 | 1968 | {"type": "Polygon", "coordinates": [[[-122.23152, 37.75852], [-122.2309, 37.75909], [-122.22784, 37.75697], [-122.22846, 37.75639], [-122.23152, 37.75852]]]} | Open Access 1 | 15126 | Lincoln Park | 21260 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 7.412 | Lincoln Park | 0 | Local Park 2 | 4 | |
3429 | 3429 | 3428 | {"type": "Polygon", "coordinates": [[[-122.28869, 37.78989], [-122.28434, 37.79], [-122.28434, 37.78999], [-122.2844, 37.78926], [-122.28472, 37.78911], [-122.28521, 37.78928], [-122.28707, 37.78929], [-122.28729, 37.78923], [-122.28753, 37.78908], [-122.28867, 37.78906], [-122.28869, 37.78989]]]} | Open Access 1 | 48739 | Estuary Park | 33465 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | https://www.alamedaca.gov/Departments/Recreation-Parks/Estuary-Park | Alameda 17 | 7.72 | Estuary Park | 2017 | Local Park 2 | 4 |
4062 | 4062 | 4061 | {"type": "Polygon", "coordinates": [[[-122.30734, 37.78918], [-122.30729, 37.7897], [-122.30701, 37.78969], [-122.30686, 37.78973], [-122.30677, 37.78959], [-122.3068, 37.78922], [-122.30689, 37.78916], [-122.30734, 37.78918]]]} | Open Access 1 | 47050 | City View Skate Park | 30700 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 0.667 | City View Skate Park | 0 | Local Recreation Area 3 | 4 | |
4101 | 4101 | 4100 | {"type": "Polygon", "coordinates": [[[-122.2971, 37.78993], [-122.29707, 37.79023], [-122.29505, 37.79057], [-122.29505, 37.78997], [-122.29569, 37.79], [-122.29571, 37.78985], [-122.2971, 37.78993]]]} | Open Access 1 | 47052 | Main Street Dog Park | 30702 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 2.363 | Main Street Dog Park | 0 | Local Park 2 | 4 | |
4104 | 4104 | 4103 | {"type": "Polygon", "coordinates": [[[-122.28814, 37.78267], [-122.28814, 37.78306], [-122.28666, 37.78304], [-122.28669, 37.78184], [-122.28791, 37.78185], [-122.28808, 37.78232], [-122.28799, 37.78241], [-122.28798, 37.78247], [-122.28798, 37.78253], [-122.28804, 37.78262], [-122.28814, 37.78267]]]} | Open Access 1 | 47045 | Bayport Park | 30695 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 4.003 | Bayport 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]);