units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9,376 rows where DES_TP = 2 sorted by MNG_AG_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV
MNG_AGENCY 655
- Los Angeles, City of 314
- San Diego, City of 281
- Sacramento, City of 192
- San Jose, City of 175
- San Francisco, City and County of 118
- Long Beach, City of 101
- Oakland, City of 99
- Los Angeles, County of 95
- Consumnes Community Services District 92
- Fresno, City of 83
- East Bay Regional Park District 76
- Modesto, City of 76
- Huntington Beach, City of 74
- Hayward Area Recreation and Park District 74
- Tracy, City of 69
- Santa Rosa, City of 68
- San Diego, County of 68
- Mountains Recreation and Conservation Authority 67
- Stockton, City of 67
- Roseville, City of 67
- Brentwood, City of 63
- Chula Vista, City of 60
- Irvine, City of 59
- Valley-Wide Recreation and Park District 57
- Bakersfield, City of 56
- Clovis, City of 54
- Manteca, City of 54
- Newport Beach, City of 50
- Anaheim, City of 49
- Riverside, City of 49
- Napa, City of 46
- San Ramon, City of 45
- Los Angeles - Department of Parks and Recreation, County of 44
- Fremont, City of 44
- Orange, County of 43
- Berkeley, City of 43
- Rancho Simi Recreation and Park District 42
- El Dorado, County of 42
- Fullerton, City of 41
- Murrieta, City of 41
- Redding, City of 41
- Santa Barbara, County of 40
- Corona, City of 40
- Folsom, City of 40
- Santa Barbara, City of 39
- Santa Ana, City of 38
- Chino Hills, City of 38
- Visalia, City of 38
- Whittier, City of 38
- Davis, City of 37
- Cordova Recreation and Park District 37
- Temecula, City of 37
- Kern, County of 37
- Pleasanton, City of 36
- Oxnard, City of 36
- Rocklin, City of 36
- Richmond, City of 35
- Mission Viejo, City of 35
- Torrance, City of 35
- Santa Cruz, City of 34
- Vacaville, City of 34
- Sonoma County Regional Parks Dept., County of 34
- Southgate Recreation and Park District 34
- Santa Cruz, County of 33
- Salinas, City of 33
- Merced, City of 33
- Palo Alto, City of 32
- Chino, City of 32
- Santa Clarita, City of 32
- Antioch, City of 32
- Union City, City of 32
- Santa Clara, City of 32
- Santa Clara County Parks and Recreation Dept., County of 32
- Moreno Valley, City of 31
- Ventura, City of 31
- San Bernardino, City of 31
- Redwood City, City of 31
- Mountain View, City of 31
- Glendale, City of 30
- Costa Mesa, City of 30
- Petaluma, City of 30
- Fontana, City of 30
- Rancho Cucamonga, City of 30
- Watsonville, City of 29
- San Jacinto, City of 29
- Redondo Beach, City of 29
- Pasadena, City of 29
- Greater Vallejo Recreation and Park District 29
- Oceanside, City of 28
- Patterson, City of 27
- Pomona, City of 27
- Santa Monica, City of 27
- West Sacramento, City of 27
- Santa Maria, City of 26
- Turlock, City of 26
- Redlands, City of 26
- Laguna Niguel, City of 26
- Conejo Recreation and Park District 25
- Pleasant Valley Recreation and Park District 25
- Alameda, City of 25
- Lake Forest, City of 25
- Oakley, City of 25
- Arcata, City of 25
- Sunrise Recreation and Park District 25
- Yorba Linda, City of 24
- Westminster, City of 24
- North of the River Recreation and Park District 24
- Chico, City of 24
- Carlsbad, City of 23
- Fairfield, City of 23
- Livermore, City of 23
- Lodi, City of 23
- Los Banos, City of 23
- La Habra, City of 22
- Stanislaus, County of 22
- San Luis Obispo, City of 21
- Azusa, City of 21
- Marin County Parks Department, County of 21
- San Marcos, City of 21
- Palmdale, City of 21
- San Rafael, City of 21
- Woodland, City of 21
- San Luis Obispo, County of 20
- Monterey, City of 20
- San Juan Capistrano, City of 20
- Ontario, City of 20
- Burbank, City of 20
- Cupertino, City of 20
- Beverly Hills, City of 20
- Cerritos, City of 20
- Arcadia, City of 20
- Concord, City of 20
- Foster City, City of 20
- Yuba City, City of 20
- El Dorado Hills Community Service District 20
- Claremont, City of 19
- Encinitas, City of 19
- Riverside, County of 19
- Greenfield, City of 19
- Placer, County of 19
- Cypress, City of 19
- Hermosa Beach, City of 19
- San Clemente, City of 19
- Milpitas, City of 19
- Oakdale, City of 18
- San Mateo County Parks and Recreation Dept., County of 18
- Dana Point, City of 18
- Lake Elsinore, City of 18
- Hollister, City of 18
- Fountain Valley, City of 18
- Lake, County of 18
- Benicia, City of 18
- Sunnyvale, City of 18
- Novato, City of 18
- San Joaquin, County of 18
- Monterey, County of 17
- Victorville, City of 17
- Coronado, City of 17
- Seaside, City of 17
- San Leandro, City of 17
- San Diego Unified Port District 17
- Mill Valley, City of 17
- La Verne, City of 17
- Orange, City of 17
- Diamond Bar, City of 17
- Morgan Hill, City of 17
- Daly City, City of 17
- San Bruno, City of 17
- Calexico, City of 17
- Lincoln, City of 17
- Aliso Viejo, City of 17
- Garden Grove, City of 16
- Escondido, City of 16
- Dublin, City of 16
- Laguna Beach, City of 16
- Rohnert Park, City of 16
- Jurupa Area Recreation and Park District 16
- Pittsburg, City of 16
- Sausalito, City of 16
- Bellflower, City of 16
- Culver City, City of 15
- South San Francisco, City of 15
- Moorpark, City of 15
- Loma Linda, City of 15
- Ventura, County of 15
- Sanger, City of 15
- Rancho Palos Verdes, City of 15
- Carson, City of 15
- Sierra Madre, City of 15
- Windsor, Town of 15
- Manhattan Beach, City of 15
- Olivehurst Public Utility District 15
- Los Angeles Unified School District 15
- La Mesa, City of 14
- Walnut Creek, City of 14
- Belmont, City of 14
- Tustin, City of 14
- El Segundo, City of 14
- South Pasadena, City of 14
- West Covina, City of 14
- San Bernardino, County of 14
- Pacifica, City of 14
- San Carlos, City of 14
- Atwater, City of 14
- Ripon, City of 14
- Perris, City of 14
- Mission Oaks Recreation and Park District 14
- Galt, City of 14
- Beaumont, City of 14
- Riverbank, City of 13
- El Centro, City of 13
- Poway, City of 13
- Monterey Park, City of 13
- Upland, City of 13
- Vista, City of 13
- Brawley, City of 13
- Tulare, City of 13
- Pacific Grove, City of 13
- Menlo Park, City of 13
- Laguna Hills, City of 13
- Norwalk, City of 13
- Sonoma, City of 13
- Pismo Beach, City of 13
- American Canyon, City of 13
- Ceres, City of 13
- Saratoga, City of 13
- Canyon Lake, City of 13
- Eureka, City of 13
- Fresno Metropolitan Flood Control District 13
- Lancaster, City of 12
- El Cajon, City of 12
- Isla Vista Recreation and Park District 12
- Placentia, City of 12
- Lakewood, City of 12
- Compton, City of 12
- Hawthorne, City of 12
- Martinez, City of 12
- Millbrae, City of 12
- Gilroy, City of 12
- Larkspur, City of 12
- Merced, County of 12
- Yolo, County of 12
- Lompoc, City of 11
- Glendora, City of 11
- Tulare, County of 11
- San Mateo, City of 11
- Norco, City of 11
- Rosemead, City of 11
- Buena Park, City of 11
- Colton, City of 11
- Brea, City of 11
- San Dimas, City of 11
- Montebello, City of 11
- Inglewood, City of 11
- Fresno, County of 11
- Walnut, City of 11
- Newark, City of 11
- El Cerrito, City of 11
- Madera, City of 11
- Marysville, City of 11
- La Quinta, City of 11
- Morro Bay, City of 11
- Santee, City of 10
- Imperial, City of 10
- Downey, City of 10
- Yucaipa, City of 10
- Paso Robles, City of 10
- Dinuba, City of 10
- Hemet, City of 10
- Escalon, City of 10
- Santa Fe Springs, City of 10
- Indio, City of 10
- Bell Gardens, City of 10
- Apple Valley Recreation and Park District 10
- Paramount, City of 10
- Palos Verdes Estates, City of 10
- La Mirada, City of 10
- Duarte, City of 10
- Hanford, City of 10
- Los Gatos, Town of 10
- Humboldt, County of 10
- Carmichael Recreation and Park District 10
- Jurupa Community Services District 10
- Suisun City, City of 10
- North Highland Recreation and Park District 10
- Coachella, City of 9
- Rialto, City of 9
- Santa Paula, City of 9
- Covina, City of 9
- Kerman, City of 9
- El Monte, City of 9
- Rolling Hills Estates, City of 9
- Los Alamitos, City of 9
- Pinole, City of 9
- Signal Hill, City of 9
- Auburn Area Recreation and Park District 9
- Pleasant Hill Recreation and Park District 9
- Soledad, City of 9
- Tiburon, Town of 9
- Palm Springs, City of 9
- Hesperia Recreation and Park District 9
- South Gate, City of 9
- Seal Beach, City of 8
- Monterey Peninsula Regional Park District 8
- Ojai, City of 8
- Capitola, City of 8
- Exeter, City of 8
- Alhambra, City of 8
- Kingsburg, City of 8
- Lynwood, City of 8
- Yucca Valley, Town of 8
- Desert Recreation District 8
- Agoura Hills, City of 8
- Pico Rivera, City of 8
- Saint Helena, City of 8
- San Anselmo, City of 8
- Colusa, City of 8
- Newman, City of 8
- Lathrop, City of 8
- Fillmore, City of 8
- Fair Oaks Recreation and Park District 8
- Montclair, City of 7
- Porterville, City of 7
- Grand Terrace, City of 7
- Barstow, City of 7
- Palm Desert, City of 7
- Livingston, City of 7
- Reedley, City of 7
- Gardena, City of 7
- Monrovia, City of 7
- Calabasas, City of 7
- West Hollywood, City of 7
- Hercules, City of 7
- Healdsburg, City of 7
- Burlingame, City of 7
- Livermore Area Recreation and Park District 7
- Delano, City of 7
- Los Altos, City of 7
- Danville, Town of 7
- California City, City of 7
- Lawndale, City of 7
- Rio Linda Elverta Recreation and Park District 7
- Sacramento, County of 7
- Cathedral City, City of 7
- Arroyo Grande, City of 7
- Cameron Park Community Services District 7
- Big Bear Valley Recreation and Park District 7
- Grover Beach, City of 7
- Menifee, City of 7
- Stanton, City of 7
- Emeryville, City of 7
- Ukiah, City of 7
- Fulton - El Camino 7
- National City, City of 6
- Carpinteria, City of 6
- Huntington Park, City of 6
- San Fernando, City of 6
- Selma, City of 6
- Needles, City of 6
- Feather River Recreation and Park District 6
- Westlake Village, City of 6
- Blythe, City of 6
- Cotati, City of 6
- Banning, City of 6
- Contra Costa County Public Works Dept., County of 6
- Half Moon Bay, City of 6
- Lomita, City of 6
- King City, City of 6
- Tehama, County of 6
- Lemon Grove, City of 6
- Sebastopol, City of 6
- Mendocino, County of 6
- Clayton, City of 6
- East Palo Alto, City of 6
- Desert Hot Springs, City of 6
- Los Angeles Department of Recreation and Parks, City of 6
- Mountain House Community Services District 6
- Yountville, Town of 6
- Lassen, County of 6
- Waterford, City of 5
- Del Mar, City of 5
- Mariposa, County of 5
- Farmersville, City of 5
- Woodlake, City of 5
- San Pablo, City of 5
- Marina, City of 5
- Highland, City of 5
- Adelanto, City of 5
- Maywood, City of 5
- Albany, City of 5
- Shasta Lake, City of 5
- Avalon, City of 5
- La Canada Flintridge, City of 5
- Bell, City of 5
- Cloverdale, City of 5
- Dixon, City of 5
- Commerce, City of 5
- Campbell, City of 5
- Red Bluff, City of 5
- Gustine, City of 5
- Placerville, City of 5
- Carmel-by-the-Sea, City of 5
- Mono, County of 5
- Orland, City of 5
- South El Monte, City of 5
- Imperial Beach, City of 5
- Yreka, City of 5
- Boulder Creek Recreation and Park District 5
- Grass Valley, City of 5
- San Gabriel, City of 5
- Miraleste Recreation and Park District 5
- Orangevale Recreation and Park District 5
- Santa Barbara Flood Control and Water Conserv. District 4
- Scotts Valley, City of 4
- Goleta, City of 4
- Holtville, City of 4
- Lafayette, City of 4
- Baldwin Park, City of 4
- Coalinga-Huron Recreation and Park District 4
- Rio Vista, City of 4
- Corcoran, City of 4
- Imperial, County of 4
- Corte Madera, Town of 4
- Arvin, City of 4
- Gonzales, City of 4
- Cudahy, City of 4
- Vallejo, City of 4
- Atascadero, City of 4
- Yuba, County of 4
- Piedmont, City of 4
- Wheatland, City of 4
- Paradise Recreation and Park District 4
- Winters, City of 4
- Port Hueneme, City of 4
- Ione, City of 4
- Corning, City of 4
- Heber Public Utility District 4
- Tahoe City Public Utilities District 4
- Del Norte County Parks, County of 4
- Calipatria, City of 4
- Tulelake, City of 4
- Azusa Unified School District 4
- Tehachapi Valley Recreation and Parks District 4
- Tuolumne Park and Recreation District 4
- Fort Bragg, City of 4
- Arbuckle Parks and Recreation District 4
- Malibu, City of 4
- Arden Manor Recreation and Park District 4
- South Lake Tahoe, City of 4
- Susanville, City of 4
- Buellton, City of 3
- Napa County Regional Park and Open Space District 3
- Lindsay, City of 3
- Solana Beach, City of 3
- San Benito, County of 3
- Ambrose Recreation and Park District 3
- Mendota, City of 3
- Riverside County Regional Park and Open Space District 3
- Rolling Hills, City of 3
- Port of Los Angeles 3
- Kings, County of 3
- Lemoore, City of 3
- Shafter, City of 3
- Parlier, City of 3
- Live Oak, City of 3
- Shafter Recreation and Park District 3
- Wasco Recreation and Park District 3
- West Side Recreation and Park District 3
- Conejo Valley Unified School District 3
- Conejo Open Space Conservation Agency 3
- Firebaugh, City of 3
- Wildomar, City of 3
- Artesia, City of 3
- McFarland Recreation and Park District 3
- Truckee-Donner Recreation and Park District 3
- Rancho Mirage, City of 3
- Anderson, City of 3
- McKinleyville Community Services District 3
- Modoc, County of 3
- Weed, City of 3
- Strawberry Recreation District 3
- Lakeport, City of 3
- Tamalpais Community Services District 3
- North County Recreation and Park District 3
- Arcade Creek Recreation and Park District 3
- Irwindale, City of 3
- Crescent City, City of 3
- Williams, City of 3
- Ridgecrest, City of 3
- Georgetown Divide Recreation District 3
- Orange Cove, City of 3
- Hughson, City of 3
- Hawaiian Gardens, City of 3
- Willows, City of 3
- Valley Center Parks and Recreation 3
- Angels Camp, City of 3
- Russian River Recreation and Park District 3
- Contra Costa, County of 3
- Marin County Open Space District 2
- Solano Tri-City and County Cooperative Planning Group 2
- Solvang, City of 2
- Dos Palos, City of 2
- Los Angeles - Department of Water and Power, City of 2
- Tehachapi, City of 2
- Rossmore Community Services District 2
- Pleasant Hill, City of 2
- Loomis, Town of 2
- Temple City, City of 2
- Brooktrails Community Services District 2
- Guadalupe, City of 2
- Napa, County of 2
- Oroville, City of 2
- Port San Luis Harbor District 2
- Fowler, City of 2
- Twentynine Palms Park and Recreation District 2
- Mammoth Lakes, Town of 2
- Monte Rio Recreation and Park District 2
- Willits, City of 2
- Burney Co Water District 2
- North Tahoe Public Utilities District 2
- Joshua Tree Park and Recreation District 2
- La Palma, City of 2
- Sutter Creek, City of 2
- Sonora, City of 2
- Beaumont-Cherry Valley Recreation and Park District 2
- Plumas, County of 2
- Tuolumne, County of 2
- Valley Center Water District 2
- Calimesa, City of 2
- San Gabriel Unified School District 2
- Glenn, County of 2
- Moraga, Town of 2
- Avenal, City of 2
- Alturas, City of 2
- Helix Water District 2
- Point Arena, City of 2
- Chowchilla, City of 2
- San Francisco, Port of 2
- Santa Clara Valley Water District 2
- Del Rey Oaks, City of 2
- San Juan Bautista, City of 2
- Indian Valley Community Services District 2
- San Dieguito River Park Joint Powers Authority 2
- Fairfax, Town of 2
- Ross, Town of 2
- Marinwood Community Service District 2
- Los Nietos School District 2
- Big Bear Lake, City of 2
- Isleton, City of 2
- Colma, City of 2
- Helendale Community Services District 2
- McFarland, City of 2
- Arden Park Recreation and Park District 2
- Nevada City, City of 2
- Pajaro Community Services District 2
- Salton Community Services District 2
- Clearlake, City of 2
- Jackson, City of 2
- Fortuna, City of 2
- Weaverville - Douglas City Recreation District 2
- Hesperia, City of 2
- Templeton Community Services District 2
- Bear Mountain Recreation and Park District 2
- Calaveras, County of 2
- Tulare Veterans Memorial District 1
- Rim of the World Recreation and Park District 1
- San Joaquin, City of 1
- Discovery Bay Community Service District 1
- San Marino, City of 1
- Rancho Simi Open Space Conservation Agency 1
- Scotia Community Services District 1
- Orinda, City of 1
- Rose Hills Memorial Park Association 1
- Metropolitan Water District of Southern California 1
- Belvedere, City of 1
- South Bay Cities Sanitation District 1
- Bear Valley Springs Community Services District 1
- Maricopa, City of 1
- Gridley, City of 1
- Yolo County Parks, County of 1
- Sand City, City of 1
- Greenfield Public Recreation District 1
- Morongo Valley Community Services District 1
- Twain Harte Community Services District 1
- Groveland Community Services District 1
- Siskiyou, County of 1
- Manila Community Services District 1
- Mt. Shasta Recreation and Park District 1
- Plymouth, City of 1
- Inyo, County of 1
- Yuima Municipal Water District 1
- Brisbane, City of 1
- Biggs, City of 1
- Butte, County of 1
- Paradise, City of 1
- Blue Lake, City of 1
- Shasta, County of 1
- Hidden Hills, City of 1
- Amador City, City of 1
- Amador, County of 1
- Jenny Lind Veterans Memorial District 1
- Calistoga, City of 1
- Wasco, City of 1
- Coalinga, City of 1
- La Puente, City of 1
- Mount Shasta, City of 1
- San Francisco, City and County of, Redevelopment Agency 1
- Porterville Public Cemetery District 1
- Dorris, City of 1
- La Habra Heights, City of 1
- Los Angeles County Department of Beaches and Harbors, County of 1
- Los Angeles - Community Redevelopment Agency, City of 1
- Ramona Municipal Water District 1
- Rosamond Community Services District 1
- Los Alamos Community Services District 1
- Norwalk La Mirada Unified School District 1
- Whittier Union High School District 1
- Whittier City School District 1
- Golden Hills Community Service District 1
- Hillsborough, Town of 1
- Laguna Woods, City of 1
- Redondo Beach Unified School District 1
- Madera, County of 1
- Happy Camp Community Services District 1
- McCloud Community Services District 1
- Dunsmuir Recreation and Park District 1
- Etna, City of 1
- Ferndale, City of 1
- Tehama, City of 1
- Modesto Irrigation District 1
- Trinity, County of 1
- Colfax, City of 1
- Portola, City of 1
- Bishop, City of 1
- Loyalton, City of 1
- Central Plumas Recreation and Parks District 1
- Bolinas Community Public Utility District 1
- Bel Marin Keys Community Services District 1
- Willow Creek Community Services District 1
- San Andreas Recreation and Park District 1
- Carmel Valley Recreation Park District 1
- Home Garden Community Services District 1
- Arcadia Unified School District 1
- Sierra, County of 1
- Dunsmuir, City of 1
- Sutter, County of 1
- Sacramento Housing and Redevelopment Agency 1
- Malaga County Water District 1
- County Service Area 42 1
- Springville Memorial District 1
- Nevada, County of 1
- Western Gateway Recreation and Park District 1
- Downey Unified School District 1
- Bradbury, City of 1
- Padre Dam Municipal Water District 1
AGNCY_TYP 27 ✖
- City Agency 7,352
- County Agency 687
- Recreation/Parks District 670
- Community Services District 173
- School District 128
- County Agency - Parks 103
- Open Space District 51
- Water District 48
- State Agency 36
- Flood District 28
- Port/Harbor District 24
- Home Owners Association 11
- Commercial 11
- Utility 9
- Special District - Other 9
- Federal Agency 8
- County Agency - Other 8
- Other 4
- Cemetery District 3
- Non Profit - Conservation 2
- Sanitation District 2
- Non Profit - Other 2
- Joint Powers Authority 2
- Transportation Agency 2
- Non Profit - Land Trust 1
- Irrigation District 1
- Education 1
MNG_AG_TYP 16
- City Agency 7,486
- Recreation/Parks District 704
- County Agency 651
- Community Services District 173
- County Agency - Parks 154
- Open Space District 75
- Water District 38
- School District 32
- Port/Harbor District 24
- Flood District 17
- Special District - Other 9
- County Agency - Other 7
- Cemetery District 3
- Irrigation District 1
- Sanitation District 1
- Joint Powers Authority 1
ACCESS_TYP 4
- Open Access 9,084
- Restricted Access 210
- No Public Access 77
- Unknown Access 5
DES_TP 1
- Local Park · 9,376 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1826 | 1826 | 1825 | {"type": "Polygon", "coordinates": [[[-121.59683, 37.91452], [-121.59681, 37.91464], [-121.59673, 37.91472], [-121.59644, 37.91528], [-121.59643, 37.91542], [-121.59661, 37.91574], [-121.5967, 37.9161], [-121.59664, 37.91618], [-121.59635, 37.91627], [-121.596, 37.91633], [-121.59546, 37.91637], [-121.59503, 37.91646], [-121.59462, 37.91649], [-121.59405, 37.91522], [-121.59426, 37.91509], [-121.5945, 37.91486], [-121.59474, 37.91466], [-121.59492, 37.91418], [-121.59501, 37.9138], [-121.59505, 37.91347], [-121.59532, 37.91343], [-121.59553, 37.91343], [-121.59577, 37.91346], [-121.59603, 37.91361], [-121.59619, 37.91376], [-121.59653, 37.91426], [-121.59673, 37.91442], [-121.59683, 37.91452]]]} | Open Access 1 | 15707 | Cornell Park | 32842 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 13.522 | Cornell Park | 0 | Local Park 2 | 4 | |
1963 | 1963 | 1962 | {"type": "Polygon", "coordinates": [[[-122.3308, 37.99984], [-122.32883, 38.00027], [-122.32826, 37.99972], [-122.32874, 37.99941], [-122.32795, 37.99863], [-122.32906, 37.99841], [-122.32936, 37.9984], [-122.33043, 37.9986], [-122.33057, 37.99918], [-122.33065, 37.99944], [-122.33072, 37.9996], [-122.3308, 37.99984]]]} | Open Access 1 | 15093 | Montalvin Park | 22382 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 8.497 | Montalvin Park | 0 | Local Park 2 | 4 | |
3257 | 3257 | 3256 | {"type": "Polygon", "coordinates": [[[-122.27841, 37.90357], [-122.27835, 37.9037], [-122.2783, 37.90383], [-122.27824, 37.90357], [-122.27841, 37.90357]]]} | Open Access 1 | 48179 | Kensington Pocket Park | 32715 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 0.053 | Kensington PP | 0 | Local Park 2 | 4 | |
11466 | 11466 | 11465 | {"type": "Polygon", "coordinates": [[[-122.28132, 37.9134], [-122.28121, 37.91335], [-122.28073, 37.91357], [-122.28038, 37.91363], [-122.28006, 37.91364], [-122.28059, 37.91414], [-122.28032, 37.91429], [-122.28033, 37.91433], [-122.28017, 37.91443], [-122.28013, 37.91447], [-122.28011, 37.91455], [-122.27999, 37.91464], [-122.27974, 37.91375], [-122.27977, 37.91354], [-122.27953, 37.91348], [-122.27932, 37.91337], [-122.27914, 37.9133], [-122.27894, 37.91332], [-122.27856, 37.91344], [-122.27849, 37.9134], [-122.27855, 37.91313], [-122.27855, 37.91292], [-122.28025, 37.91174], [-122.28106, 37.91239], [-122.2812, 37.91267], [-122.28074, 37.91276], [-122.28074, 37.91278], [-122.28092, 37.91335], [-122.28129, 37.91318], [-122.28132, 37.9134]]]} | Open Access 1 | 48178 | Kensington Park | 32713 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 8.459 | Kensington Park | 0 | Local Park 2 | 4 | |
12092 | 12092 | 12091 | {"type": "Polygon", "coordinates": [[[-122.02017, 37.86622], [-122.02016, 37.86639], [-122.01993, 37.86641], [-122.01969, 37.86648], [-122.01952, 37.86657], [-122.01934, 37.86672], [-122.0192, 37.86692], [-122.01905, 37.86733], [-122.01897, 37.86749], [-122.01882, 37.86767], [-122.01862, 37.86783], [-122.01852, 37.86783], [-122.01826, 37.8676], [-122.01798, 37.86742], [-122.01815, 37.86697], [-122.01795, 37.86683], [-122.0179, 37.86666], [-122.01792, 37.86629], [-122.01939, 37.86633], [-122.01944, 37.86632], [-122.0195, 37.86629], [-122.01953, 37.86625], [-122.01954, 37.8662], [-122.02017, 37.86622]]]} | Open Access 1 | 24911 | Livorna Park | 21386 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 4.387 | Livorna Park | 0 | Local Park 2 | 4 | |
12094 | 12094 | 12093 | {"type": "Polygon", "coordinates": [[[-121.95664, 38.0308], [-121.95557, 38.03164], [-121.95456, 38.03083], [-121.95562, 38.03], [-121.95664, 38.0308]]]} | Open Access 1 | 24917 | Lynbrook Park | 21606 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 4.143 | Lynbrook Park | 0 | Local Park 2 | 4 | |
958 | 958 | 957 | {"type": "Polygon", "coordinates": [[[-119.92531, 36.72346], [-119.92527, 36.72786], [-119.91225, 36.72797], [-119.91225, 36.72353], [-119.92531, 36.72346]]]} | Open Access 1 | 6028 | Kearney Park | 20564 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 141.05 | Kearney Park | 0 | Local Park 2 | 4 | |
1092 | 1092 | 1091 | {"type": "MultiPolygon", "coordinates": [[[[-120.06057, 36.82127], [-120.05812, 36.82206], [-120.05808, 36.82217], [-120.05765, 36.82219], [-120.05656, 36.82261], [-120.05645, 36.82149], [-120.05648, 36.82129], [-120.05672, 36.82121], [-120.05673, 36.82153], [-120.05751, 36.82123], [-120.05809, 36.82109], [-120.0581, 36.82122], [-120.06056, 36.82068], [-120.06057, 36.82127]]], [[[-120.06297, 36.81983], [-120.06296, 36.82016], [-120.06068, 36.82113], [-120.06069, 36.82058], [-120.06297, 36.81983]]]]} | Open Access 1 | 6501 | Skaggs Bridge Park | 25525 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 10.968 | Skaggs Bridge Park | 0 | Local Park 2 | 4 | |
4154 | 4154 | 4153 | {"type": "Polygon", "coordinates": [[[-119.81577, 36.82816], [-119.81567, 36.82823], [-119.81543, 36.8286], [-119.81534, 36.82863], [-119.81459, 36.82867], [-119.81452, 36.82859], [-119.81441, 36.82857], [-119.81437, 36.82825], [-119.81437, 36.82794], [-119.81444, 36.82792], [-119.8145, 36.82788], [-119.81531, 36.82788], [-119.81536, 36.82792], [-119.81542, 36.82795], [-119.81549, 36.82795], [-119.81556, 36.82793], [-119.81577, 36.82816]]]} | Open Access 1 | 47541 | Tenaya Park | 31249 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | http://www.tenayapark.org/home | Fresno 9 | 2.209 | Tenaya Park | 0 | Local Park 2 | 4 |
5462 | 5462 | 5461 | {"type": "Polygon", "coordinates": [[[-120.5772, 36.23014], [-120.576, 36.23388], [-120.57199, 36.23385], [-120.57199, 36.23372], [-120.57111, 36.23372], [-120.57112, 36.2293], [-120.57146, 36.22934], [-120.57203, 36.22947], [-120.57274, 36.22952], [-120.57507, 36.22999], [-120.57554, 36.23005], [-120.57601, 36.23004], [-120.5772, 36.23014]]]} | Open Access 1 | 6270 | Los Gatos Creek County Park | 21515 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 55.581 | Los Gatos Creek County Park | 0 | Local Park 2 | 4 | |
6986 | 6986 | 6985 | {"type": "Polygon", "coordinates": [[[-119.42108, 36.77855], [-119.42081, 36.78005], [-119.41857, 36.78242], [-119.41777, 36.78378], [-119.41743, 36.78552], [-119.41756, 36.78608], [-119.41728, 36.7867], [-119.41689, 36.78775], [-119.4136, 36.79017], [-119.41289, 36.79018], [-119.41291, 36.78956], [-119.41265, 36.78957], [-119.41264, 36.78953], [-119.41163, 36.78953], [-119.41163, 36.79007], [-119.41169, 36.79008], [-119.41169, 36.7902], [-119.41163, 36.79021], [-119.41163, 36.79075], [-119.41051, 36.79098], [-119.40972, 36.79183], [-119.4092, 36.79286], [-119.40806, 36.79282], [-119.40253, 36.79276], [-119.4029, 36.79203], [-119.40398, 36.79025], [-119.40444, 36.79042], [-119.40455, 36.79042], [-119.40454, 36.79034], [-119.4045, 36.79033], [-119.40438, 36.79018], [-119.40409, 36.79007], [-119.40466, 36.78911], [-119.40589, 36.7856], [-119.40683, 36.7856], [-119.40682, 36.78531], [-119.40608, 36.7853], [-119.40697, 36.78457], [-119.40753, 36.78396], [-119.40776, 36.78365], [-119.4092, 36.78367], [-119.40889, 36.78446], [-119.40818, 36.78559], [-119.40818, 36.78561], [-119.41158, 36.78567], [-119.41163, 36.78947], [-119.41293, 36.78906], [-119.41329, 36.78548], [-119.41363, 36.78401], [-119.41156, 36.78247], [-119.41151, 36.78205], [-119.41573, 36.78208], [-119.41818, 36.77991], [-119.41917, 36.78014], [-119.42026, 36.77852], [-119.42108, 36.77855]]]} | Open Access 1 | 5909 | Avocado Lake Park | 3936 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51947 | Fresno 9 | 225.777 | Avocado Lake Park | 0 | Local Park 2 | 4 |
7097 | 7097 | 7096 | {"type": "Polygon", "coordinates": [[[-119.69078, 36.4277], [-119.69074, 36.4293], [-119.69071, 36.42972], [-119.68743, 36.42975], [-119.6875, 36.42902], [-119.68794, 36.42907], [-119.68852, 36.42919], [-119.68938, 36.42931], [-119.6907, 36.42946], [-119.69073, 36.42931], [-119.6894, 36.42913], [-119.68851, 36.42901], [-119.68797, 36.42891], [-119.68748, 36.4288], [-119.68631, 36.42839], [-119.68641, 36.4269], [-119.68728, 36.42697], [-119.68779, 36.42691], [-119.68874, 36.42707], [-119.68941, 36.42695], [-119.69078, 36.4277]]]} | Open Access 1 | 6148 | Laton-Kingston Park | 21081 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 24.247 | Laton-Kingston Park | 0 | Local Park 2 | 4 | |
7225 | 7225 | 7224 | {"type": "Polygon", "coordinates": [[[-120.3761, 36.7807], [-120.37597, 36.7808], [-120.37571, 36.78105], [-120.37517, 36.78076], [-120.37455, 36.7806], [-120.37395, 36.78049], [-120.37328, 36.78048], [-120.37283, 36.78069], [-120.37245, 36.78082], [-120.3733, 36.78465], [-120.37121, 36.78454], [-120.37122, 36.78516], [-120.37026, 36.78491], [-120.36982, 36.78438], [-120.36952, 36.78374], [-120.36934, 36.78279], [-120.36939, 36.7821], [-120.36868, 36.78201], [-120.36858, 36.78167], [-120.36872, 36.78118], [-120.36855, 36.78059], [-120.36844, 36.78032], [-120.3689, 36.77975], [-120.36951, 36.7788], [-120.37032, 36.77791], [-120.37101, 36.77764], [-120.37204, 36.77738], [-120.37287, 36.77708], [-120.37248, 36.77796], [-120.37307, 36.77821], [-120.37357, 36.77857], [-120.37421, 36.77948], [-120.3754, 36.78023], [-120.3761, 36.7807]]]} | Open Access 1 | 6388 | Mendota Pool Park | 22152 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 72.242 | Mendota Pool Park | 0 | Local Park 2 | 4 | |
9453 | 9453 | 9452 | {"type": "MultiPolygon", "coordinates": [[[[-119.38326, 36.8181], [-119.3831, 36.81856], [-119.38303, 36.81856], [-119.38264, 36.81984], [-119.38193, 36.81963], [-119.38133, 36.8194], [-119.38067, 36.81912], [-119.38007, 36.81881], [-119.38007, 36.81813], [-119.38326, 36.8181]]], [[[-119.38697, 36.81641], [-119.38629, 36.81792], [-119.38469, 36.81923], [-119.38468, 36.81946], [-119.38457, 36.81953], [-119.38444, 36.81959], [-119.38406, 36.81964], [-119.38379, 36.81979], [-119.38354, 36.81989], [-119.38327, 36.81994], [-119.38307, 36.81994], [-119.38345, 36.81865], [-119.3834, 36.81863], [-119.38358, 36.8181], [-119.38367, 36.81809], [-119.38365, 36.81762], [-119.38373, 36.81712], [-119.38422, 36.81613], [-119.38451, 36.81438], [-119.38454, 36.81437], [-119.38449, 36.81163], [-119.38529, 36.81486], [-119.38697, 36.81641]]]]} | Open Access 1 | 15812 | Winton Park | 27659 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 37.979 | Winton Park | 0 | Local Park 2 | 4 | |
12296 | 12296 | 12295 | {"type": "Polygon", "coordinates": [[[-119.50625, 36.72095], [-119.50623, 36.7228], [-119.50624, 36.72462], [-119.50195, 36.72458], [-119.50192, 36.72283], [-119.50197, 36.72277], [-119.50198, 36.7227], [-119.50194, 36.72262], [-119.50188, 36.72258], [-119.5018, 36.72256], [-119.50169, 36.72257], [-119.50161, 36.72263], [-119.50158, 36.72271], [-119.5016, 36.72279], [-119.50166, 36.72285], [-119.5017, 36.72766], [-119.50164, 36.72783], [-119.50148, 36.72797], [-119.50134, 36.72816], [-119.49746, 36.72813], [-119.49741, 36.72098], [-119.50625, 36.72095]]]} | Open Access 1 | 25952 | China Creek Park | 17202 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 113.797 | China Creek Park | 0 | Local Park 2 | 4 | |
12297 | 12297 | 12296 | {"type": "Polygon", "coordinates": [[[-119.36499, 36.82156], [-119.36484, 36.82167], [-119.36465, 36.82269], [-119.3645, 36.82277], [-119.36352, 36.82264], [-119.36305, 36.8226], [-119.36273, 36.82261], [-119.36239, 36.82267], [-119.36177, 36.82273], [-119.36155, 36.82272], [-119.36075, 36.8225], [-119.36008, 36.82242], [-119.35953, 36.82239], [-119.35875, 36.82224], [-119.35845, 36.82216], [-119.35795, 36.82194], [-119.35762, 36.82183], [-119.35627, 36.82122], [-119.35558, 36.82116], [-119.35494, 36.82132], [-119.35425, 36.82166], [-119.3521, 36.82457], [-119.35158, 36.82517], [-119.3513, 36.82527], [-119.3507, 36.82524], [-119.35047, 36.82532], [-119.35029, 36.82541], [-119.34938, 36.82674], [-119.3481, 36.82793], [-119.34605, 36.82777], [-119.34969, 36.8246], [-119.35288, 36.82118], [-119.35294, 36.8202], [-119.354, 36.81915], [-119.35626, 36.81834], [-119.35729, 36.81815], [-119.35755, 36.81813], [-119.36022, 36.81832], [-119.36486, 36.81775], [-119.36499, 36.82156]]]} | Open Access 1 | 25953 | Choinumni Park | 17214 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 140.591 | Choinumni Park | 0 | Local Park 2 | 4 | |
12299 | 12299 | 12298 | {"type": "Polygon", "coordinates": [[[-119.44789, 36.74967], [-119.44787, 36.75316], [-119.44786, 36.75324], [-119.44785, 36.75402], [-119.44543, 36.75484], [-119.44438, 36.75684], [-119.44384, 36.75753], [-119.44321, 36.75812], [-119.4432, 36.75928], [-119.44317, 36.76005], [-119.44202, 36.76162], [-119.44126, 36.76044], [-119.43947, 36.76041], [-119.43884, 36.75948], [-119.43886, 36.75681], [-119.43707, 36.75679], [-119.43755, 36.7563], [-119.43776, 36.7561], [-119.43831, 36.75579], [-119.43972, 36.75506], [-119.4399, 36.75496], [-119.44006, 36.75484], [-119.44026, 36.75466], [-119.44042, 36.75443], [-119.44053, 36.75416], [-119.4406, 36.75388], [-119.44062, 36.75264], [-119.44234, 36.75208], [-119.44351, 36.75166], [-119.44407, 36.75142], [-119.44732, 36.74965], [-119.44789, 36.74967]]]} | Open Access 1 | 25954 | Kings River Green Belt Park | 20662 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 136.461 | Kings River Green Belt Park | 0 | Local Park 2 | 4 | |
1333 | 1333 | 1332 | {"type": "Polygon", "coordinates": [[[-114.72616, 33.40354], [-114.72479, 33.40354], [-114.72438, 33.40263], [-114.72394, 33.40197], [-114.72359, 33.40161], [-114.72338, 33.40102], [-114.72304, 33.4002], [-114.72212, 33.39886], [-114.72184, 33.39858], [-114.72184, 33.39738], [-114.72616, 33.40354]]]} | Open Access 1 | 7580 | Palo Verde County Park | 23359 | 302 | Imperial, County of 348 | County 3 | County Agency 3 | http://www.icpds.com/?pid=1048 | County 3 | 302 | Imperial, County of 345 | County 3 | County Agency 3 | Imperial 20 | 13.919 | Palo Verde County Park | 0 | Local Park 2 | 4 | |
5232 | 5232 | 5231 | {"type": "Polygon", "coordinates": [[[-115.67682, 32.77663], [-115.67556, 32.77481], [-115.67435, 32.77444], [-115.67435, 32.77433], [-115.67607, 32.77424], [-115.67688, 32.77433], [-115.67741, 32.77427], [-115.68059, 32.77846], [-115.68065, 32.77892], [-115.68081, 32.77894], [-115.68079, 32.77953], [-115.68244, 32.77946], [-115.69028, 32.77921], [-115.69029, 32.78595], [-115.68677, 32.78484], [-115.68075, 32.78206], [-115.68075, 32.78136], [-115.68028, 32.78091], [-115.67977, 32.7807], [-115.67682, 32.77663]], [[-115.68079, 32.78028], [-115.68077, 32.78028], [-115.68076, 32.78078], [-115.68079, 32.78081], [-115.68079, 32.78028]]]} | Open Access 1 | 48074 | Sunbeam Lake Park | 32576 | 302 | Imperial, County of 348 | County 3 | County Agency 3 | http://www.icpds.com/?pid=1048 | County 3 | 302 | Imperial, County of 345 | County 3 | County Agency 3 | https://www.co.imperial.ca.us/publicwork/index.asp?fileinc=parksunbeam | Imperial 20 | 154.391 | Sunbeam Lake Park | 0 | Local Park 2 | 4 |
5233 | 5233 | 5232 | {"type": "Polygon", "coordinates": [[[-115.69473, 32.7933], [-115.69278, 32.7933], [-115.69278, 32.79285], [-115.69341, 32.79284], [-115.69339, 32.79247], [-115.69472, 32.79247], [-115.69473, 32.7933]]]} | Open Access 1 | 48075 | Robert Bates Memorial Park | 32577 | 302 | Imperial, County of 348 | County 3 | County Agency 3 | http://www.icpds.com/?pid=1048 | County 3 | 302 | Imperial, County of 345 | County 3 | County Agency 3 | http://www.seeleywaterdistrict.com/updates/robert-bates-memorial-park-upgrades | Imperial 20 | 3.525 | Robert Bates Memorial 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]);