superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9,670 rows where ACCESS_TYP = 1 and MNG_AG_TYP = 2 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
MNG_AGENCY 464
- Los Angeles, City of 431
- San Diego, City of 408
- San Jose, City of 247
- San Francisco, City and County of 238
- Sacramento, City of 214
- Ventura, City of 149
- Long Beach, City of 135
- Oakland, City of 122
- Roseville, City of 117
- Irvine, City of 97
- Fresno, City of 91
- Modesto, City of 78
- Stockton, City of 77
- Huntington Beach, City of 76
- Tracy, City of 73
- Santa Rosa, City of 72
- Brentwood, City of 68
- Chula Vista, City of 67
- Santa Cruz, City of 65
- Newport Beach, City of 65
- Poway, City of 64
- San Luis Obispo, City of 61
- Davis, City of 61
- Clovis, City of 61
- Anaheim, City of 59
- Bakersfield, City of 59
- Manteca, City of 59
- Riverside, City of 57
- Fremont, City of 56
- Napa, City of 55
- Encinitas, City of 54
- Redding, City of 54
- Glendale, City of 51
- Santa Barbara, City of 50
- Murrieta, City of 50
- Torrance, City of 49
- Santa Clarita, City of 48
- Berkeley, City of 48
- Folsom, City of 48
- Mission Viejo, City of 47
- Novato, City of 47
- Rocklin, City of 47
- Fullerton, City of 46
- Vacaville, City of 46
- Salinas, City of 44
- Richmond, City of 43
- Pleasanton, City of 43
- San Ramon, City of 43
- Corona, City of 42
- Chino Hills, City of 42
- Visalia, City of 42
- Temecula, City of 42
- Santa Ana, City of 41
- Oxnard, City of 41
- Redlands, City of 41
- San Bernardino, City of 40
- Los Banos, City of 40
- Oceanside, City of 39
- Petaluma, City of 39
- Chico, City of 39
- Redwood City, City of 37
- Arcata, City of 37
- Moreno Valley, City of 36
- San Mateo, City of 36
- Seaside, City of 35
- Palo Alto, City of 35
- Fontana, City of 35
- Watsonville, City of 34
- Santa Maria, City of 34
- Livermore, City of 34
- Antioch, City of 34
- San Rafael, City of 34
- Union City, City of 34
- Santa Clara, City of 34
- San Jacinto, City of 33
- Merced, City of 33
- Patterson, City of 32
- Monterey, City of 32
- Turlock, City of 32
- Rancho Cucamonga, City of 32
- Redondo Beach, City of 32
- California City, City of 32
- Costa Mesa, City of 31
- West Sacramento, City of 31
- Carlsbad, City of 30
- Santa Monica, City of 30
- Chino, City of 30
- Yorba Linda, City of 29
- Fairfield, City of 29
- Lake Forest, City of 29
- Oakley, City of 29
- Pasadena, City of 29
- Mountain View, City of 29
- Tiburon, Town of 29
- Laguna Niguel, City of 29
- Alameda, City of 28
- Whittier, City of 28
- Concord, City of 28
- Pomona, City of 27
- San Marcos, City of 27
- Daly City, City of 27
- Lompoc, City of 26
- Palmdale, City of 26
- Lodi, City of 26
- Burbank, City of 25
- Azusa, City of 25
- Benicia, City of 25
- Woodland, City of 25
- Claremont, City of 24
- South San Francisco, City of 24
- San Juan Capistrano, City of 24
- Westminster, City of 24
- Eureka, City of 24
- Rancho Palos Verdes, City of 23
- Rohnert Park, City of 23
- San Clemente, City of 23
- Morgan Hill, City of 23
- Yuba City, City of 23
- Calexico, City of 23
- Ontario, City of 22
- San Leandro, City of 22
- Cupertino, City of 22
- La Habra, City of 22
- Pittsburg, City of 22
- Oakdale, City of 21
- Dana Point, City of 21
- Cerritos, City of 21
- Mill Valley, City of 21
- Fountain Valley, City of 21
- Hermosa Beach, City of 21
- La Verne, City of 21
- Sunnyvale, City of 21
- Foster City, City of 21
- Lincoln, City of 21
- Victorville, City of 20
- Orange, City of 20
- San Bruno, City of 20
- Ripon, City of 20
- Galt, City of 20
- Culver City, City of 19
- Dublin, City of 19
- Moorpark, City of 19
- Greenfield, City of 19
- Walnut Creek, City of 19
- Cypress, City of 19
- South Pasadena, City of 19
- West Covina, City of 19
- Pacifica, City of 19
- Milpitas, City of 19
- Sausalito, City of 19
- Vista, City of 18
- Loma Linda, City of 18
- Sanger, City of 18
- Sonoma, City of 18
- Gilroy, City of 18
- Thousand Oaks, City of 18
- Garden Grove, City of 17
- Coronado, City of 17
- Laguna Beach, City of 17
- Lake Elsinore, City of 17
- Belmont, City of 17
- San Dimas, City of 17
- Diamond Bar, City of 17
- Atwater, City of 17
- Aliso Viejo, City of 17
- Escondido, City of 16
- Norco, City of 16
- Tulare, City of 16
- Pacific Grove, City of 16
- Beverly Hills, City of 16
- Placentia, City of 16
- Tustin, City of 16
- El Segundo, City of 16
- Carson, City of 16
- Windsor, Town of 16
- Pismo Beach, City of 16
- Bellflower, City of 16
- Larkspur, City of 16
- La Quinta, City of 16
- Riverbank, City of 15
- El Centro, City of 15
- Scotts Valley, City of 15
- Brawley, City of 15
- Arcadia, City of 15
- Hanford, City of 15
- Millbrae, City of 15
- Los Gatos, Town of 15
- Oroville, City of 15
- Perris, City of 15
- Beaumont, City of 15
- La Mesa, City of 14
- El Cajon, City of 14
- Glendora, City of 14
- Monterey Park, City of 14
- Hollister, City of 14
- Menlo Park, City of 14
- Rolling Hills Estates, City of 14
- Compton, City of 14
- Palos Verdes Estates, City of 14
- Martinez, City of 14
- Newark, City of 14
- American Canyon, City of 14
- San Carlos, City of 14
- Ceres, City of 14
- Marysville, City of 14
- Canyon Lake, City of 14
- Seal Beach, City of 13
- Lancaster, City of 13
- Yucaipa, City of 13
- Paso Robles, City of 13
- Upland, City of 13
- Laguna Hills, City of 13
- Brea, City of 13
- Norwalk, City of 13
- Lakewood, City of 13
- Calabasas, City of 13
- Duarte, City of 13
- El Cerrito, City of 13
- Saratoga, City of 13
- Mammoth Lakes, Town of 13
- Downey, City of 12
- Rosemead, City of 12
- Porterville, City of 12
- Colton, City of 12
- Santa Fe Springs, City of 12
- Reedley, City of 12
- Montebello, City of 12
- Inglewood, City of 12
- Walnut, City of 12
- Pinole, City of 12
- Madera, City of 12
- Manhattan Beach, City of 12
- Morro Bay, City of 12
- Santee, City of 11
- Capitola, City of 11
- Exeter, City of 11
- Hemet, City of 11
- El Monte, City of 11
- Paramount, City of 11
- Monrovia, City of 11
- La Mirada, City of 11
- San Anselmo, City of 11
- Guadalupe, City of 11
- Lathrop, City of 11
- Palm Springs, City of 11
- Stanton, City of 11
- Suisun City, City of 11
- Auburn, City of 11
- Imperial, City of 10
- Montclair, City of 10
- Coachella, City of 10
- Rialto, City of 10
- Dinuba, City of 10
- Buena Park, City of 10
- Goleta, City of 10
- Escalon, City of 10
- Marina, City of 10
- Indio, City of 10
- Yucca Valley, Town of 10
- Hawthorne, City of 10
- Signal Hill, City of 10
- Healdsburg, City of 10
- Saint Helena, City of 10
- Los Angeles Department of Recreation and Parks, City of 10
- Ukiah, City of 10
- Ojai, City of 9
- Alhambra, City of 9
- Santa Paula, City of 9
- Covina, City of 9
- Kerman, City of 9
- Barstow, City of 9
- Bell Gardens, City of 9
- Los Alamitos, City of 9
- Sierra Madre, City of 9
- Agoura Hills, City of 9
- Burlingame, City of 9
- Corte Madera, Town of 9
- Gonzales, City of 9
- Colusa, City of 9
- Newman, City of 9
- Vallejo, City of 9
- Arroyo Grande, City of 9
- Del Mar, City of 8
- Woodlake, City of 8
- Palm Desert, City of 8
- Livingston, City of 8
- Kingsburg, City of 8
- Gardena, City of 8
- Rio Vista, City of 8
- West Hollywood, City of 8
- Pico Rivera, City of 8
- Delano, City of 8
- Soledad, 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
- Carpinteria, City of 7
- Solvang, City of 7
- Grand Terrace, City of 7
- San Pablo, City of 7
- San Fernando, City of 7
- Highland, City of 7
- Lynwood, City of 7
- Albany, City of 7
- Westlake Village, City of 7
- Shasta Lake, City of 7
- La Canada Flintridge, City of 7
- Hercules, City of 7
- Cotati, City of 7
- Cloverdale, City of 7
- Half Moon Bay, City of 7
- Los Altos, City of 7
- Lomita, City of 7
- Danville, Town of 7
- King City, City of 7
- Piedmont, City of 7
- Sebastopol, City of 7
- Clayton, City of 7
- Desert Hot Springs, City of 7
- Menifee, City of 7
- South Lake Tahoe, City of 7
- National City, City of 6
- Huntington Park, City of 6
- Selma, City of 6
- Needles, City of 6
- Los Angeles - Department of Water and Power, City of 6
- Avalon, City of 6
- Bell, City of 6
- Blythe, City of 6
- Banning, City of 6
- Dixon, City of 6
- Live Oak, City of 6
- Campbell, City of 6
- Placerville, City of 6
- Carmel-by-the-Sea, City of 6
- Wheatland, City of 6
- Winters, City of 6
- Port Hueneme, City of 6
- Lemon Grove, City of 6
- Williams, City of 6
- Waterford, City of 5
- Farmersville, City of 5
- Baldwin Park, City of 5
- Adelanto, City of 5
- Maywood, City of 5
- Lemoore, City of 5
- Loomis, Town of 5
- Gustine, City of 5
- Orland, City of 5
- Imperial Beach, City of 5
- East Palo Alto, City of 5
- Corning, City of 5
- Grass Valley, 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
- Corcoran, City of 4
- Orinda, City of 4
- Parlier, City of 4
- Commerce, City of 4
- Arvin, 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
- Rio Dell, City of 4
- Calipatria, City of 4
- Tulelake, City of 4
- Moraga, Town of 4
- San Gabriel, City of 4
- Irwindale, City of 4
- Crescent City, City of 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
- Solana Beach, City of 3
- Dos Palos, City of 3
- Lafayette, City of 3
- Mendota, City of 3
- Tehachapi, City of 3
- Shafter, City of 3
- Belvedere, City of 3
- Lawndale, City of 3
- Wildomar, City of 3
- Artesia, City of 3
- Weed, City of 3
- Lakeport, City of 3
- Brisbane, City of 3
- Blue Lake, City of 3
- Calistoga, City of 3
- Orange Cove, City of 3
- Chowchilla, City of 3
- Ross, Town of 3
- Hawaiian Gardens, City of 3
- Willows, City of 3
- Nevada City, City of 3
- Angels Camp, City of 3
- Bradbury, City of 3
- San Joaquin, City of 2
- Pleasant Hill, City of 2
- Temple City, City of 2
- Sand City, City of 2
- Fowler, City of 2
- South El Monte, City of 2
- Anderson, City of 2
- Sutter Creek, City of 2
- Sonora, City of 2
- Calimesa, City of 2
- Trinidad, City of 2
- Avenal, City of 2
- Alturas, City of 2
- Coalinga, City of 2
- La Puente, City of 2
- Del Rey Oaks, City of 2
- San Juan Bautista, City of 2
- Big Bear Lake, City of 2
- Isleton, City of 2
- McFarland, City of 2
- Clearlake, City of 2
- Jackson, City of 2
- Tehama, City of 2
- Hesperia, City of 2
- San Marino, City of 1
- Maricopa, City of 1
- Plymouth, City of 1
- Rancho Cordova, City of 1
- Biggs, City of 1
- Paradise, City of 1
- Hidden Hills, City of 1
- Amador City, City of 1
- Wasco, 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
- Atherton, Town of 1
- Elk Grove, City of 1
- Hillsborough, Town of 1
- Laguna Woods, City of 1
- Etna, City of 1
- Ferndale, City of 1
- Colfax, City of 1
- Portola, City of 1
- Bishop, City of 1
- Loyalton, City of 1
- Westmorland, City of 1
- Dunsmuir, City of 1
- Fort Jones, City of 1
MNG_AG_TYP 1
- City Agency · 9,670 ✖
ACCESS_TYP 1
- Open Access · 9,670 ✖
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME ▼ | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10280 | 10280 | 10279 | {"type": "Polygon", "coordinates": [[[-117.28319, 33.04494], [-117.28317, 33.045], [-117.28306, 33.045], [-117.28307, 33.04496], [-117.28303, 33.04494], [-117.28299, 33.04494], [-117.28295, 33.04496], [-117.28294, 33.045], [-117.2829, 33.04497], [-117.28291, 33.04454], [-117.28293, 33.04452], [-117.28296, 33.04453], [-117.28319, 33.04492], [-117.28319, 33.04494]]]} | Open Access 1 | Unknown park - Encinitas, City of | 28635 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 0.21 | |||
10305 | 10305 | 10304 | {"type": "Polygon", "coordinates": [[[-122.29703, 38.32248], [-122.29673, 38.32253], [-122.29668, 38.3225], [-122.29665, 38.32238], [-122.29698, 38.32231], [-122.29703, 38.32248]]]} | Open Access 1 | Unknown park - Napa, City of | 28648 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 0.139 | |||
11699 | 11699 | 11698 | {"type": "Polygon", "coordinates": [[[-121.94894, 37.95659], [-121.94812, 37.95676], [-121.94769, 37.95718], [-121.94595, 37.95732], [-121.94556, 37.95747], [-121.94522, 37.95733], [-121.94478, 37.95735], [-121.94426, 37.95733], [-121.94353, 37.95711], [-121.94302, 37.957], [-121.94253, 37.95683], [-121.94236, 37.95692], [-121.94229, 37.95689], [-121.94223, 37.9569], [-121.94208, 37.95672], [-121.94172, 37.95664], [-121.94141, 37.95649], [-121.94116, 37.95642], [-121.94053, 37.95602], [-121.9399, 37.9559], [-121.94005, 37.95573], [-121.94022, 37.9556], [-121.94045, 37.95581], [-121.94064, 37.95573], [-121.9428, 37.95516], [-121.94301, 37.95513], [-121.94349, 37.95516], [-121.94377, 37.95516], [-121.94406, 37.95513], [-121.94503, 37.95483], [-121.94529, 37.95473], [-121.94551, 37.95461], [-121.94551, 37.95459], [-121.9453, 37.95439], [-121.94545, 37.95428], [-121.94565, 37.95443], [-121.94581, 37.95462], [-121.94617, 37.9549], [-121.94641, 37.95496], [-121.94663, 37.95505], [-121.94703, 37.95524], [-121.94707, 37.9552], [-121.94792, 37.95578], [-121.9482, 37.95594], [-121.94845, 37.95617], [-121.9486, 37.95614], [-121.94868, 37.95609], [-121.9488, 37.9563], [-121.94894, 37.95659]]]} | Open Access 1 | Unnamed site - Concord, City of | 30380 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 35.165 | |||
12088 | 12088 | 12087 | {"type": "MultiPolygon", "coordinates": [[[[-124.10601, 40.49914], [-124.10572, 40.49916], [-124.10573, 40.49867], [-124.10555, 40.49848], [-124.10587, 40.49829], [-124.10601, 40.49914]]], [[[-124.10652, 40.49814], [-124.10615, 40.49811], [-124.10585, 40.49742], [-124.10585, 40.49742], [-124.10652, 40.49814]]]]} | Open Access 1 | Unknown park - Rio Dell, City of | http://www.riodellcity.com/planning-pdf/Rio%20Dell%20Zoning%20Map.pdf | 30546 | 1435 | Rio Dell, City of 632 | City 2 | City Agency 2 | http://www.riodellcity.com/ | City 2 | 0.75 | ||
12107 | 12107 | 12106 | {"type": "Polygon", "coordinates": [[[-124.10655, 40.50715], [-124.10654, 40.50718], [-124.10649, 40.5072], [-124.10591, 40.5071], [-124.10587, 40.50708], [-124.10587, 40.50705], [-124.10588, 40.50702], [-124.10605, 40.50694], [-124.10617, 40.50686], [-124.1063, 40.50671], [-124.10635, 40.50669], [-124.1064, 40.50673], [-124.10649, 40.50701], [-124.10655, 40.50715]]]} | Open Access 1 | Unnamed site - Rio Dell, City of | 30560 | 1435 | Rio Dell, City of 632 | City 2 | City Agency 2 | http://www.riodellcity.com/ | City 2 | 0.418 | |||
13517 | 13517 | 13516 | {"type": "Polygon", "coordinates": [[[-122.49889, 37.96947], [-122.49879, 37.96966], [-122.49802, 37.97002], [-122.49766, 37.97016], [-122.49731, 37.97028], [-122.49713, 37.97033], [-122.49695, 37.97036], [-122.49659, 37.97038], [-122.49622, 37.97037], [-122.49578, 37.9703], [-122.49568, 37.97019], [-122.49615, 37.96878], [-122.4984, 37.96946], [-122.49886, 37.96944], [-122.49889, 37.96947]]]} | Open Access 1 | Unnamed site - San Rafael, City of | 32671 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 7.23 | |||
14037 | 14037 | 14036 | {"type": "Polygon", "coordinates": [[[-118.86173, 34.28582], [-118.86002, 34.28619], [-118.85448, 34.28618], [-118.85629, 34.28478], [-118.85712, 34.28437], [-118.85736, 34.28427], [-118.85765, 34.28419], [-118.85807, 34.28414], [-118.85838, 34.28414], [-118.85869, 34.28418], [-118.85895, 34.28424], [-118.85927, 34.28436], [-118.85956, 34.28452], [-118.85984, 34.28474], [-118.85998, 34.28489], [-118.86011, 34.28504], [-118.86013, 34.28504], [-118.86021, 34.28521], [-118.86035, 34.28538], [-118.86048, 34.2855], [-118.86063, 34.28561], [-118.86086, 34.28572], [-118.86114, 34.2858], [-118.86143, 34.28584], [-118.86173, 34.28582]]]} | Open Access 1 | Unnamed site - Moorpark, City of | 33324 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 21.957 | |||
14114 | 14114 | 14113 | {"type": "Polygon", "coordinates": [[[-120.63297, 36.97684], [-120.63292, 36.97688], [-120.63232, 36.97688], [-120.63228, 36.97685], [-120.63228, 36.97652], [-120.63297, 36.97652], [-120.63297, 36.97684]]]} | Open Access 1 | Unknown park - Dos Palos, City of | 33657 | 1460 | Dos Palos, City of 190 | City 2 | City Agency 2 | City 2 | 0.607 | ||||
14272 | 14272 | 14271 | {"type": "MultiPolygon", "coordinates": [[[[-122.57219, 38.57658], [-122.57184, 38.57719], [-122.57089, 38.57682], [-122.57116, 38.57631], [-122.57219, 38.57658]]], [[[-122.59131, 38.58052], [-122.59118, 38.58071], [-122.59058, 38.58066], [-122.59033, 38.5805], [-122.59051, 38.58045], [-122.59131, 38.58052]]], [[[-122.59352, 38.58594], [-122.59328, 38.58619], [-122.59306, 38.58597], [-122.59325, 38.58577], [-122.59352, 38.58594]]]]} | Open Access 1 | Unnamed site - Calistoga, City of | 28631 | 1042 | Calistoga, City of 755 | City 2 | City Agency 2 | http://www.ci.calistoga.ca.us/ | City 2 | 2.194 | |||
14274 | 14274 | 14273 | {"type": "Polygon", "coordinates": [[[-120.18846, 36.61384], [-120.18812, 36.61416], [-120.18658, 36.61417], [-120.18447, 36.61277], [-120.18626, 36.61114], [-120.18632, 36.61119], [-120.18564, 36.61182], [-120.18563, 36.61183], [-120.18846, 36.61384]]]} | Open Access 1 | Unknown park - San Joaquin, City of | 28660 | 1302 | San Joaquin, City of 225 | City 2 | City Agency 2 | http://www.cityofsanjoaquin.org/ | City 2 | 11.13 | |||
14275 | 14275 | 14274 | {"type": "MultiPolygon", "coordinates": [[[[-120.65368, 35.25981], [-120.65355, 35.25973], [-120.65336, 35.25938], [-120.65327, 35.25852], [-120.65304, 35.25837], [-120.65297, 35.25826], [-120.65294, 35.25809], [-120.653, 35.2577], [-120.65339, 35.25769], [-120.65368, 35.25981]]], [[[-120.65374, 35.27663], [-120.65364, 35.27676], [-120.65352, 35.27662], [-120.65365, 35.27654], [-120.65374, 35.27663]]], [[[-120.68305, 35.25007], [-120.68298, 35.25011], [-120.68277, 35.25009], [-120.68274, 35.25012], [-120.68269, 35.25007], [-120.68285, 35.24982], [-120.68305, 35.25007]]]]} | Open Access 1 | Unnamed site - San Luis Obispo, City of | 28661 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1.835 | |||
14280 | 14280 | 14279 | {"type": "MultiPolygon", "coordinates": [[[[-122.27703, 38.31682], [-122.27674, 38.3171], [-122.27646, 38.31702], [-122.27594, 38.31695], [-122.27565, 38.31688], [-122.27558, 38.31653], [-122.27581, 38.31638], [-122.27597, 38.3162], [-122.27656, 38.31622], [-122.27679, 38.31615], [-122.27678, 38.31633], [-122.27683, 38.31652], [-122.27691, 38.31667], [-122.27703, 38.31682]]], [[[-122.27749, 38.30276], [-122.27737, 38.30283], [-122.27718, 38.30304], [-122.27707, 38.30306], [-122.27701, 38.30305], [-122.27692, 38.30298], [-122.27666, 38.3027], [-122.27686, 38.3028], [-122.27707, 38.30284], [-122.27729, 38.30283], [-122.27735, 38.30281], [-122.27736, 38.30279], [-122.27749, 38.30276]]], [[[-122.28082, 38.28098], [-122.27751, 38.28071], [-122.27753, 38.28051], [-122.28081, 38.28064], [-122.28082, 38.28098]]], [[[-122.28563, 38.32175], [-122.28561, 38.32179], [-122.28539, 38.32195], [-122.28528, 38.32197], [-122.28528, 38.32154], [-122.28548, 38.3215], [-122.28563, 38.3217], [-122.28563, 38.32175]]], [[[-122.28633, 38.32236], [-122.2863, 38.32236], [-122.28528, 38.32252], [-122.28528, 38.3224], [-122.28534, 38.32223], [-122.28539, 38.32215], [-122.28547, 38.32206], [-122.28558, 38.32197], [-122.28568, 38.32191], [-122.28575, 38.3219], [-122.2858, 38.3219], [-122.28614, 38.32221], [-122.28633, 38.32236]]], [[[-122.28707, 38.32222], [-122.28659, 38.32231], [-122.28628, 38.32208], [-122.2861, 38.32192], [-122.28591, 38.32174], [-122.2857, 38.32146], [-122.28679, 38.32126], [-122.28707, 38.32222]]], [[[-122.28917, 38.3009], [-122.28907, 38.30095], [-122.28902, 38.30095], [-122.28885, 38.30075], [-122.28901, 38.30069], [-122.28917, 38.3009]]], [[[-122.28966, 38.30079], [-122.28933, 38.30084], [-122.28919, 38.30061], [-122.28952, 38.30046], [-122.28962, 38.30044], [-122.28966, 38.30079]]], [[[-122.2977, 38.32825], [-122.2972, 38.3285], [-122.29663, 38.32864], [-122.29655, 38.32859], [-122.29758, 38.3281], [-122.2977, 38.32825]]], [[[-122.31677, 38.29327], [-122.31482, 38.29396], [-122.31422, 38.29403], [-122.31412, 38.29363], [-122.31425, 38.29329], [-122.31436, 38.29316], [-122.31439, 38.29308], [-122.3144, 38.29298], [-122.31651, 38.29297], [-122.31651, 38.29326], [-122.31677, 38.29327]]], [[[-122.31969, 38.31537], [-122.31968, 38.3154], [-122.31965, 38.31542], [-122.31947, 38.31545], [-122.31931, 38.31498], [-122.31956, 38.3152], [-122.31969, 38.31537]]], [[[-122.34106, 38.30681], [-122.341, 38.30679], [-122.34093, 38.30667], [-122.34086, 38.30658], [-122.34045, 38.3062], [-122.34007, 38.30593], [-122.33968, 38.30568], [-122.33914, 38.3054], [-122.3391, 38.30534], [-122.33912, 38.30527], [-122.33923, 38.30535], [-122.33938, 38.3054], [-122.33952, 38.30542], [-122.33961, 38.30547], [-122.33966, 38.30552], [-122.3398, 38.30569], [-122.33993, 38.3058], [-122.34011, 38.30586], [-122.34049, 38.30593], [-122.34063, 38.30599], [-122.34068, 38.30605], [-122.34073, 38.30625], [-122.3408, 38.30635], [-122.34083, 38.30638], [-122.34091, 38.30639], [-122.34105, 38.30635], [-122.34106, 38.30681]]], [[[-122.34618, 38.30909], [-122.34597, 38.30934], [-122.34614, 38.30944], [-122.34597, 38.30955], [-122.34589, 38.30957], [-122.34581, 38.30954], [-122.34512, 38.30898], [-122.34519, 38.30876], [-122.34544, 38.30879], [-122.34534, 38.30903], [-122.34535, 38.30905], [-122.34568, 38.30906], [-122.34612, 38.30899], [-122.34618, 38.30909]]], [[[-122.3487, 38.31069], [-122.34864, 38.31088], [-122.34806, 38.31077], [-122.34714, 38.31048], [-122.34688, 38.31036], [-122.34665, 38.31022], [-122.34613, 38.30976], [-122.3461, 38.30972], [-122.34611, 38.30968], [-122.34617, 38.30961], [-122.34625, 38.30956], [-122.34634, 38.30965], [-122.34665, 38.30968], [-122.34674, 38.30993], [-122.34686, 38.31013], [-122.34725, 38.31024], [-122.3475, 38.31039], [-122.34763, 38.31031], [-122.34789, 38.31052], [-122.34805, 38.31036], [-122.34821, 38.31049], [-122.34838, 38.31044], [-122.34859, 38.31072], [-122.3487, 38.31069]]]]} | Open Access 1 | Unnamed site - Napa, City of | 28646 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 16.577 | |||
14282 | 14282 | 14281 | {"type": "MultiPolygon", "coordinates": [[[[-121.77531, 36.91167], [-121.77503, 36.91227], [-121.77428, 36.91196], [-121.77397, 36.91189], [-121.77363, 36.91186], [-121.77326, 36.91191], [-121.77314, 36.91171], [-121.77244, 36.91195], [-121.77201, 36.91199], [-121.77149, 36.91185], [-121.77153, 36.91119], [-121.77249, 36.91129], [-121.77282, 36.9112], [-121.77299, 36.91105], [-121.77342, 36.91099], [-121.77355, 36.91109], [-121.77531, 36.91167]]], [[[-121.78001, 36.90996], [-121.7796, 36.90977], [-121.77934, 36.90977], [-121.77882, 36.90995], [-121.77805, 36.91048], [-121.77599, 36.91021], [-121.77576, 36.91069], [-121.7756, 36.91016], [-121.77561, 36.91007], [-121.77568, 36.90995], [-121.77575, 36.90988], [-121.7759, 36.90981], [-121.7764, 36.90969], [-121.77693, 36.90981], [-121.77743, 36.90968], [-121.77756, 36.90959], [-121.77779, 36.90933], [-121.77802, 36.90919], [-121.77858, 36.90875], [-121.77882, 36.90864], [-121.77931, 36.90851], [-121.77936, 36.90846], [-121.77938, 36.90841], [-121.77938, 36.90832], [-121.78001, 36.90996]]], [[[-121.79104, 37.01528], [-121.79097, 37.01543], [-121.791, 37.01553], [-121.7909, 37.01571], [-121.79074, 37.01585], [-121.79048, 37.01595], [-121.78976, 37.01601], [-121.78875, 37.01642], [-121.78822, 37.01683], [-121.78806, 37.01702], [-121.78779, 37.01739], [-121.78779, 37.01786], [-121.78794, 37.01826], [-121.78733, 37.0187], [-121.78722, 37.01887], [-121.78726, 37.019], [-121.78736, 37.01911], [-121.78433, 37.01909], [-121.78606, 37.01588], [-121.78619, 37.01552], [-121.7865, 37.01535], [-121.78714, 37.01517], [-121.78795, 37.01487], [-121.78952, 37.01435], [-121.79104, 37.01528]], [[-121.79089, 37.01556], [-121.79088, 37.01554], [-121.7903, 37.01553], [-121.79029, 37.01554], [-121.79045, 37.01588], [-121.79068, 37.01579], [-121.79083, 37.01566], [-121.79089, 37.01556]]], [[[-121.80347, 37.04255], [-121.80296, 37.04373], [-121.80276, 37.04499], [-121.80264, 37.04534], [-121.80233, 37.04573], [-121.80235, 37.04659], [-121.80223, 37.04686], [-121.80224, 37.047], [-121.80228, 37.04703], [-121.80228, 37.04715], [-121.80279, 37.04754], [-121.80017, 37.04746], [-121.79151, 37.04743], [-121.79167, 37.0407], [-121.797, 37.04075], [-121.80045, 37.04074], [-121.80194, 37.04076], [-121.80282, 37.04139], [-121.80342, 37.04205], [-121.80347, 37.04255]]]]} | Open Access 1 | Unnamed site - Watsonville, City of | 28675 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 233.758 | |||
14295 | 14295 | 14294 | {"type": "Polygon", "coordinates": [[[-120.14075, 34.59592], [-120.13946, 34.5959], [-120.13946, 34.5959], [-120.13963, 34.59555], [-120.14075, 34.59592]]]} | Open Access 1 | Unknown park - Solvang, City of | 28669 | 1337 | Solvang, City of 79 | City 2 | City Agency 2 | http://www.cityofsolvang.com/index.php/departments/parks-a-recreation | City 2 | 0.581 | |||
14296 | 14296 | 14295 | {"type": "Polygon", "coordinates": [[[-120.14651, 34.6035], [-120.14643, 34.60387], [-120.14512, 34.60449], [-120.14492, 34.60438], [-120.14466, 34.6043], [-120.14438, 34.6043], [-120.14381, 34.60437], [-120.14377, 34.60436], [-120.14373, 34.60432], [-120.14374, 34.6041], [-120.14379, 34.60395], [-120.14434, 34.60404], [-120.14512, 34.60379], [-120.14578, 34.60373], [-120.14651, 34.6035]]]} | Open Access 1 | Unnamed site - Solvang, City of | 28670 | 1337 | Solvang, City of 79 | City 2 | City Agency 2 | http://www.cityofsolvang.com/index.php/departments/parks-a-recreation | City 2 | 3.005 | |||
14303 | 14303 | 14302 | {"type": "MultiPolygon", "coordinates": [[[[-117.14137, 33.15374], [-117.14114, 33.15399], [-117.1411, 33.154], [-117.14106, 33.154], [-117.14103, 33.15398], [-117.14101, 33.15395], [-117.14087, 33.15347], [-117.14094, 33.15346], [-117.14137, 33.15374]]], [[[-117.18544, 33.1626], [-117.18544, 33.16267], [-117.18537, 33.16299], [-117.18467, 33.1629], [-117.18466, 33.16288], [-117.18471, 33.16253], [-117.18544, 33.1626]]]]} | Open Access 1 | Unknown park - San Marcos, City of | 28686 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1.074 | |||
14305 | 14305 | 14304 | {"type": "Polygon", "coordinates": [[[-122.58206, 38.57942], [-122.58194, 38.57963], [-122.58178, 38.57951], [-122.58195, 38.57934], [-122.58206, 38.57942]]]} | Open Access 1 | Unknown park - Calistoga, City of | 28689 | 1042 | Calistoga, City of 755 | City 2 | City Agency 2 | http://www.ci.calistoga.ca.us/ | City 2 | 0.098 | |||
14309 | 14309 | 14308 | {"type": "Polygon", "coordinates": [[[-122.38148, 37.73182], [-122.38123, 37.73211], [-122.38122, 37.73223], [-122.38105, 37.73214], [-122.38098, 37.73216], [-122.38071, 37.73205], [-122.38067, 37.73203], [-122.38065, 37.73199], [-122.38066, 37.73194], [-122.38081, 37.73176], [-122.38103, 37.73152], [-122.38108, 37.7315], [-122.38114, 37.7315], [-122.38118, 37.73152], [-122.38134, 37.73167], [-122.38138, 37.73177], [-122.38148, 37.73182]]]} | Open Access 1 | Unnamed site - San Francisco, City of | 28697 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.817 | |||
14312 | 14312 | 14311 | {"type": "MultiPolygon", "coordinates": [[[[-117.05883, 32.72129], [-117.05851, 32.72137], [-117.05826, 32.72054], [-117.05856, 32.72042], [-117.05883, 32.72129]]], [[[-117.06249, 32.75242], [-117.06211, 32.75251], [-117.06106, 32.75279], [-117.06087, 32.75234], [-117.0624, 32.75219], [-117.06249, 32.75242]]], [[[-117.06411, 32.71928], [-117.06404, 32.71934], [-117.06249, 32.71803], [-117.0625, 32.71793], [-117.06411, 32.71928]]], [[[-117.20364, 32.79871], [-117.20168, 32.7987], [-117.2017, 32.79679], [-117.2017, 32.79679], [-117.20364, 32.79871]]]]} | Open Access 1 | Unnamed site - San Diego, City of | 28704 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 7.375 | |||
14313 | 14313 | 14312 | {"type": "Polygon", "coordinates": [[[-121.79106, 37.67722], [-121.79029, 37.67754], [-121.78871, 37.6778], [-121.78807, 37.67784], [-121.78741, 37.67737], [-121.78811, 37.67727], [-121.78838, 37.67755], [-121.789, 37.67751], [-121.78842, 37.67665], [-121.78831, 37.67628], [-121.78917, 37.67597], [-121.78992, 37.67604], [-121.79005, 37.67635], [-121.79039, 37.67668], [-121.79075, 37.67693], [-121.79106, 37.67722]]]} | Open Access 1 | Unknown park - Livermore, City of | 28714 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 8.298 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);