units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7,486 rows where DES_TP = 2 and MNG_AG_TYP = 2 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV
MNG_AGENCY 456
- 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
- Fresno, City of 83
- Modesto, City of 76
- Huntington Beach, City of 74
- Tracy, City of 69
- Santa Rosa, City of 68
- Stockton, City of 67
- Roseville, City of 67
- Brentwood, City of 63
- Chula Vista, City of 60
- Irvine, City of 59
- 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
- Fremont, City of 44
- Berkeley, City of 43
- Fullerton, City of 41
- Murrieta, City of 41
- Redding, City of 41
- 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
- Temecula, City 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
- 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
- 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
- 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
- Alameda, City of 25
- Lake Forest, City of 25
- Oakley, City of 25
- Arcata, City of 25
- Yorba Linda, City of 24
- Westminster, City of 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
- San Luis Obispo, City of 21
- Azusa, City of 21
- San Marcos, City of 21
- Palmdale, City of 21
- San Rafael, City of 21
- Woodland, City of 21
- 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
- Claremont, City of 19
- Encinitas, City of 19
- Greenfield, City of 19
- Cypress, City of 19
- Hermosa Beach, City of 19
- San Clemente, City of 19
- Milpitas, City of 19
- Oakdale, City of 18
- Dana Point, City of 18
- Lake Elsinore, City of 18
- Hollister, City of 18
- Fountain Valley, City of 18
- Benicia, City of 18
- Sunnyvale, City of 18
- Novato, City of 18
- Victorville, City of 17
- Coronado, City of 17
- Seaside, City of 17
- San Leandro, City of 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
- 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
- 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
- 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
- Pacifica, City of 14
- San Carlos, City of 14
- Atwater, City of 14
- Ripon, City of 14
- Perris, City of 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
- Lancaster, City of 12
- El Cajon, City of 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
- Lompoc, City of 11
- Glendora, City 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
- 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
- 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
- Suisun City, City of 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
- Soledad, City of 9
- Tiburon, Town of 9
- Palm Springs, City of 9
- South Gate, City of 9
- Seal Beach, City of 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
- 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
- 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
- Delano, City of 7
- Los Altos, City of 7
- Danville, Town of 7
- California City, City of 7
- Lawndale, City of 7
- Cathedral City, City of 7
- Arroyo Grande, City of 7
- Grover Beach, City of 7
- Menifee, City of 7
- Stanton, City of 7
- Emeryville, City of 7
- Ukiah, City of 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
- Westlake Village, City of 6
- Blythe, City of 6
- Cotati, City of 6
- Banning, City of 6
- Half Moon Bay, City of 6
- Lomita, City of 6
- King City, City of 6
- Lemon Grove, City of 6
- Sebastopol, City 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
- Yountville, Town of 6
- Waterford, City of 5
- Del Mar, City 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
- Orland, City of 5
- South El Monte, City of 5
- Imperial Beach, City of 5
- Yreka, City of 5
- Grass Valley, City of 5
- San Gabriel, City of 5
- Scotts Valley, City of 4
- Goleta, City of 4
- Holtville, City of 4
- Lafayette, City of 4
- Baldwin Park, City of 4
- Rio Vista, City of 4
- Corcoran, City 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
- Piedmont, City of 4
- Wheatland, City of 4
- Winters, City of 4
- Port Hueneme, City of 4
- Ione, City of 4
- Corning, City of 4
- Calipatria, City of 4
- Tulelake, City of 4
- Fort Bragg, City of 4
- Malibu, City of 4
- South Lake Tahoe, City of 4
- Susanville, City of 4
- Buellton, City of 3
- Lindsay, City of 3
- Solana Beach, City of 3
- Mendota, City of 3
- Rolling Hills, City of 3
- Lemoore, City of 3
- Shafter, City of 3
- Parlier, City of 3
- Live Oak, City of 3
- Firebaugh, City of 3
- Wildomar, City of 3
- Artesia, City of 3
- Rancho Mirage, City of 3
- Anderson, City of 3
- Weed, City of 3
- Lakeport, City of 3
- Irwindale, City of 3
- Crescent City, City of 3
- Williams, City of 3
- Ridgecrest, City of 3
- Orange Cove, City of 3
- Hughson, City of 3
- Hawaiian Gardens, City of 3
- Willows, City of 3
- Angels Camp, City of 3
- Solvang, City of 2
- Dos Palos, City of 2
- Los Angeles - Department of Water and Power, City of 2
- Tehachapi, City of 2
- Pleasant Hill, City of 2
- Loomis, Town of 2
- Temple City, City of 2
- Guadalupe, City of 2
- Oroville, City of 2
- Fowler, City of 2
- Mammoth Lakes, Town of 2
- Willits, City of 2
- La Palma, City of 2
- Sutter Creek, City of 2
- Sonora, City of 2
- Calimesa, City of 2
- Moraga, Town of 2
- Avenal, City of 2
- Alturas, City of 2
- Point Arena, City of 2
- Chowchilla, City of 2
- Del Rey Oaks, City of 2
- San Juan Bautista, City of 2
- Fairfax, Town of 2
- Ross, Town of 2
- Big Bear Lake, City of 2
- Isleton, City of 2
- Colma, City of 2
- McFarland, City of 2
- Nevada City, City of 2
- Clearlake, City of 2
- Jackson, City of 2
- Fortuna, City of 2
- Hesperia, City of 2
- San Joaquin, City of 1
- San Marino, City of 1
- Orinda, City of 1
- Belvedere, City of 1
- Maricopa, City of 1
- Gridley, City of 1
- Sand City, City of 1
- Plymouth, City of 1
- Brisbane, City of 1
- Biggs, City of 1
- Paradise, City of 1
- Blue Lake, City of 1
- Hidden Hills, City of 1
- Amador City, City of 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
- Dorris, City of 1
- La Habra Heights, City of 1
- Los Angeles - Community Redevelopment Agency, City of 1
- Hillsborough, Town of 1
- Laguna Woods, City of 1
- Etna, City of 1
- Ferndale, City of 1
- Tehama, City of 1
- Colfax, City of 1
- Portola, City of 1
- Bishop, City of 1
- Loyalton, City of 1
- Dunsmuir, City of 1
- Bradbury, City of 1
ACCESS_TYP 3
- Open Access 7,297
- Restricted Access 151
- No Public Access 38
MNG_AG_TYP 1
- City Agency · 7,486 ✖
DES_TP 1
- Local Park · 7,486 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4358 | 4358 | 4357 | {"type": "Polygon", "coordinates": [[[-118.2853, 33.94082], [-118.2853, 33.94114], [-118.28516, 33.94114], [-118.28516, 33.94082], [-118.2853, 33.94082]]]} | Open Access 1 | 45731 | 105th Street Pocket Park | 28734 | 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 | http://www.laparks.org/environmental/105th.htm | Los Angeles 6 | 0.111 | 105th Street PP | 0 | Local Park 2 | 4 |
7979 | 7979 | 7978 | {"type": "Polygon", "coordinates": [[[-122.46853, 37.78203], [-122.4677, 37.78207], [-122.46767, 37.78166], [-122.4685, 37.78162], [-122.46853, 37.78203]], [[-122.4682, 37.78188], [-122.46824, 37.78188], [-122.46824, 37.78181], [-122.46819, 37.7818], [-122.46818, 37.78172], [-122.46796, 37.78173], [-122.46798, 37.78197], [-122.4682, 37.78197], [-122.4682, 37.78188]]]} | Open Access 1 | 15960 | 10th Ave & Clement Mini Park | 15169 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.684 | 10th Ave & Clement MP | 0 | Local Park 2 | 4 | |
4223 | 4223 | 4222 | {"type": "Polygon", "coordinates": [[[-118.2713, 33.93401], [-118.2713, 33.93437], [-118.2712, 33.93437], [-118.2712, 33.93401], [-118.2713, 33.93401]]]} | Open Access 1 | 45017 | 111th Place Neighborhood Park | 27920 | 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 | http://www.laparks.org/environmental/pdf/111thPark.pdf | Los Angeles 6 | 0.09 | 111th Place Neighborhood Park | 0 | Local Park 2 | 4 |
8163 | 8163 | 8162 | {"type": "Polygon", "coordinates": [[[-118.34102, 33.92741], [-118.34102, 33.92741], [-118.34058, 33.92712], [-118.34101, 33.92713], [-118.34102, 33.92741]]]} | Open Access 1 | 46481 | 118th Street Mini Park | 29761 | 1130 | Hawthorne, City of 299 | City 2 | City Agency 2 | http://www.cityofhawthorne.com/ | City 2 | 1130 | Hawthorne, City of 295 | City 2 | City Agency 2 | Los Angeles 6 | 0.154 | 118th Street MP | 0 | Local Park 2 | 4 | |
4363 | 4363 | 4362 | {"type": "Polygon", "coordinates": [[[-118.32926, 33.98393], [-118.32926, 33.98408], [-118.32896, 33.98418], [-118.32863, 33.98434], [-118.32863, 33.98418], [-118.3287, 33.98418], [-118.32926, 33.98393]]]} | Open Access 1 | 45774 | 11th Avenue Park | 28781 | 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 | http://www.lanlt.org/parks-and-gardens.php#11th | Los Angeles 6 | 0.207 | 11th Avenue Park | 0 | Local Park 2 | 4 |
6336 | 6336 | 6335 | {"type": "Polygon", "coordinates": [[[-118.0693, 33.71722], [-118.06917, 33.71732], [-118.06861, 33.71687], [-118.06878, 33.71676], [-118.0693, 33.71722]]]} | Open Access 1 | 47442 | 11th Street Beach Park | 31159 | 1142 | Huntington Park, City of 85 | City 2 | City Agency 2 | http://www.hpca.gov/index.aspx?nid=14 | City 2 | 1142 | Huntington Park, City of 83 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/11th-street-beach-park.cfm | Orange 3 | 0.322 | 11th Street Beach Park | 0 | Local Park 2 | 4 |
3612 | 3612 | 3611 | {"type": "Polygon", "coordinates": [[[-120.4815, 37.29325], [-120.48128, 37.29362], [-120.48113, 37.29357], [-120.48134, 37.29319], [-120.4815, 37.29325]]]} | Open Access 1 | 47309 | 11th Street Neighborhood Park | 31016 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | https://www.cityofmerced.org/depts/parks_n_community_services/parks_n_facilities/parks/mini.asp | Merced 37 | 0.172 | 11th Street Neighborhood Park | 0 | Local Park 2 | 4 |
6511 | 6511 | 6510 | {"type": "Polygon", "coordinates": [[[-117.64341, 34.11057], [-117.64175, 34.11057], [-117.6417, 34.11053], [-117.6417, 34.11008], [-117.64338, 34.11007], [-117.64341, 34.11011], [-117.64341, 34.11057]]]} | Open Access 1 | 2522 | 13th Street Reservoir Park | 15171 | 1363 | Upland, City of 145 | City 2 | City Agency 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | City 2 | 1363 | Upland, City of 141 | City 2 | City Agency 2 | San Bernardino 22 | 2.129 | 13th Street Reservoir Park | 0 | Local Park 2 | 4 | |
12384 | 12384 | 12383 | {"type": "Polygon", "coordinates": [[[-120.61198, 35.11407], [-120.61192, 35.1148], [-120.60972, 35.11469], [-120.60972, 35.11439], [-120.60966, 35.11409], [-120.61027, 35.11394], [-120.61038, 35.11396], [-120.6107, 35.11398], [-120.61068, 35.114], [-120.61069, 35.11401], [-120.61198, 35.11407]]]} | Open Access 1 | 26521 | 16th Street Park | 15175 | 1452 | Grover Beach, City of 654 | City 2 | City Agency 2 | http://www.grover.org/index.aspx?nid=141 | City 2 | 1452 | Grover Beach, City of 643 | City 2 | City Agency 2 | San Luis Obispo 1 | 4.082 | 16th Street Park | 0 | Local Park 2 | 4 | |
1538 | 1538 | 1537 | {"type": "Polygon", "coordinates": [[[-119.7988, 36.28916], [-119.79442, 36.28915], [-119.79441, 36.289], [-119.79335, 36.289], [-119.79335, 36.28889], [-119.79441, 36.28841], [-119.79847, 36.28677], [-119.7987, 36.28683], [-119.79873, 36.28803], [-119.79881, 36.28828], [-119.7988, 36.28916]]]} | Open Access 1 | 11241 | 19th Avenue Park | 15176 | 1174 | Lemoore, City of 380 | City 2 | City Agency 2 | http://www.lemoore.com/parks/default.html | City 2 | 1174 | Lemoore, City of 375 | City 2 | City Agency 2 | Kings 44 | 18.284 | 19th Avenue Park | 0 | Local Park 2 | 4 | |
17044 | 17044 | 17043 | {"type": "Polygon", "coordinates": [[[-118.24477, 34.05427], [-118.24461, 34.05444], [-118.24459, 34.05443], [-118.24454, 34.05449], [-118.24455, 34.05451], [-118.24403, 34.05507], [-118.2432, 34.05453], [-118.24394, 34.05373], [-118.24477, 34.05427]]]} | Open Access 1 | 45773 | 1st and Broadway Civic Center Park | 29093 | 1716 | Los Angeles Department of Recreation and Parks, City of 660 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | Los Angeles 6 | 2.682 | 1st and Broadway Civic Ctr. Park | 0 | Local Park 2 | 4 | |
1829 | 1829 | 1828 | {"type": "MultiPolygon", "coordinates": [[[[-121.81612, 39.73135], [-121.81386, 39.73158], [-121.81325, 39.73086], [-121.81256, 39.72996], [-121.81236, 39.72969], [-121.81298, 39.72941], [-121.81278, 39.72916], [-121.81233, 39.72845], [-121.81238, 39.72843], [-121.81242, 39.72694], [-121.81242, 39.72644], [-121.81291, 39.72644], [-121.81431, 39.72746], [-121.81522, 39.72735], [-121.81532, 39.72743], [-121.81549, 39.72741], [-121.81549, 39.72792], [-121.81551, 39.72812], [-121.81561, 39.72812], [-121.81612, 39.73135]]], [[[-121.81639, 39.73299], [-121.81549, 39.73308], [-121.81469, 39.73241], [-121.81424, 39.73197], [-121.8139, 39.73162], [-121.81613, 39.7314], [-121.81639, 39.73299]]]]} | Open Access 1 | 15710 | 20th Street Park | 15178 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 37.854 | 20th Street Park | 0 | Local Park 2 | 4 | |
3653 | 3653 | 3652 | {"type": "Polygon", "coordinates": [[[-121.64347, 37.11265], [-121.64347, 37.11268], [-121.64305, 37.11279], [-121.64285, 37.11264], [-121.64329, 37.11251], [-121.64336, 37.1126], [-121.64341, 37.11259], [-121.64345, 37.11265], [-121.64347, 37.11265]]]} | Open Access 1 | 29875 | 21 Mile Park | 15179 | 1217 | Morgan Hill, City of 416 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | Santa Clara 19 | 0.221 | 21 Mile Park | 0 | Local Park 2 | 4 | |
2391 | 2391 | 2390 | {"type": "Polygon", "coordinates": [[[-118.20432, 33.79536], [-118.20431, 33.79659], [-118.20427, 33.79663], [-118.20404, 33.79662], [-118.20404, 33.79554], [-118.20398, 33.79553], [-118.20397, 33.79536], [-118.20432, 33.79536]]]} | Open Access 1 | 45873 | 21st to Hill Mini Park | 28944 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://longbeach.granicus.com/MediaPlayer.php?view_id=12&clip_id=4470 | Los Angeles 6 | 0.91 | 21st to Hill MP | 0 | Local Park 2 | 4 |
6891 | 6891 | 6890 | {"type": "Polygon", "coordinates": [[[-122.40867, 37.7532], [-122.4085, 37.75321], [-122.40848, 37.75292], [-122.40865, 37.75291], [-122.40867, 37.7532]]]} | Open Access 1 | 5720 | 24th & York Mini Park | 15185 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.119 | 24th & York MP | 0 | Local Park 2 | 4 | |
11068 | 11068 | 11067 | {"type": "MultiPolygon", "coordinates": [[[[-121.48235, 38.49361], [-121.48044, 38.49362], [-121.48044, 38.4925], [-121.48046, 38.49243], [-121.4805, 38.49238], [-121.48056, 38.49235], [-121.48062, 38.49233], [-121.48066, 38.49234], [-121.48097, 38.49259], [-121.48202, 38.49327], [-121.48222, 38.49346], [-121.48235, 38.49361]]], [[[-121.48082, 38.49178], [-121.48186, 38.49179], [-121.48203, 38.49183], [-121.48215, 38.49187], [-121.48238, 38.49202], [-121.48249, 38.49213], [-121.48255, 38.49223], [-121.48261, 38.49243], [-121.48261, 38.49309], [-121.48258, 38.49318], [-121.48252, 38.49327], [-121.48247, 38.4933], [-121.48241, 38.49329], [-121.48215, 38.49307], [-121.48118, 38.49244], [-121.48098, 38.49229], [-121.4808, 38.4921], [-121.48065, 38.49188], [-121.48065, 38.49185], [-121.48068, 38.49181], [-121.48082, 38.49178]]]]} | Open Access 1 | 21267 | 24th Street Bypass Park | 15186 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 7.38 | 24th Street Bypass Park | 0 | Local Park 2 | 4 | |
9353 | 9353 | 9352 | {"type": "Polygon", "coordinates": [[[-122.27275, 37.81463], [-122.27269, 37.81501], [-122.27229, 37.81496], [-122.27236, 37.81458], [-122.27275, 37.81463]]]} | Open Access 1 | 15617 | 25th St. Mini Park | 15188 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.375 | 25th St. MP | 0 | Local Park 2 | 4 | |
11985 | 11985 | 11984 | {"type": "Polygon", "coordinates": [[[-116.99002, 33.93689], [-116.98976, 33.93712], [-116.98957, 33.93735], [-116.98957, 33.93742], [-116.98948, 33.93746], [-116.98945, 33.9375], [-116.98944, 33.93755], [-116.98924, 33.93759], [-116.98896, 33.93807], [-116.98887, 33.93804], [-116.98867, 33.93792], [-116.98846, 33.93774], [-116.98828, 33.93752], [-116.98819, 33.93733], [-116.98814, 33.93718], [-116.98811, 33.93699], [-116.98811, 33.93607], [-116.98818, 33.93601], [-116.98847, 33.93606], [-116.9894, 33.93642], [-116.98969, 33.93659], [-116.98984, 33.93671], [-116.99002, 33.93689]]]} | Open Access 1 | 24636 | 3 Rings Ranch Community Park | 15191 | 1415 | Beaumont, City of 802 | City 2 | City Agency 2 | http://www.ci.beaumont.ca.us/index.aspx?nid=33 | City 2 | 1415 | Beaumont, City of 782 | City 2 | City Agency 2 | Riverside 10 | 6.021 | 3 Rings Ranch Community Park | 0 | Local Park 2 | 4 | |
505 | 505 | 504 | {"type": "Polygon", "coordinates": [[[-117.1296, 32.71069], [-117.1296, 32.71124], [-117.12944, 32.71124], [-117.12944, 32.71069], [-117.1296, 32.71069]]]} | Open Access 1 | 2045 | 30th Street Mini Park | 15192 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.23 | 30th Street MP | 0 | Local Park 2 | 4 | |
4151 | 4151 | 4150 | {"type": "Polygon", "coordinates": [[[-117.12552, 32.73807], [-117.12552, 32.73821], [-117.12512, 32.73821], [-117.12512, 32.73807], [-117.12552, 32.73807]]]} | Open Access 1 | 47523 | 32nd Street Mini Park | 31228 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.143 | 32nd Street MP | 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]);