units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,440 rows where DES_TP = 3 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
MNG_AGENCY 300
- San Diego, City of 204
- Los Angeles, City of 116
- San Francisco, City and County of 79
- San Luis Obispo, City of 25
- Long Beach, City of 25
- Glendale, City of 24
- Davis, City of 23
- Santa Clarita, City of 18
- Sacramento, City of 18
- San Jose, City of 17
- Vacaville, City of 17
- Oakland, City of 16
- Thousand Oaks, City of 16
- Fullerton, City of 15
- Santa Cruz, City of 14
- San Bernardino, City of 14
- San Marcos, City of 14
- Tiburon, Town of 13
- Carlsbad, City of 12
- Poway, City of 12
- Mission Viejo, City of 11
- Oceanside, City of 10
- Fresno, City of 9
- Riverside, City of 9
- Irvine, City of 9
- Roseville, City of 9
- South San Francisco, City of 8
- Escondido, City of 8
- Chico, City of 8
- Santa Barbara, City of 7
- Newport Beach, City of 7
- San Ramon, City of 7
- Chula Vista, City of 7
- Walnut Creek, City of 7
- Fairfield, City of 7
- Whittier, City of 7
- Novato, City of 7
- Eureka, City of 7
- Santa Ana, City of 6
- Richmond, City of 6
- Encinitas, City of 6
- Redondo Beach, City of 6
- Los Angeles - Department of Water and Power, City of 6
- Calabasas, City of 6
- Rohnert Park, City of 6
- Concord, City of 6
- Redding, City of 6
- Daly City, City of 6
- Moreno Valley, City of 5
- Salinas, City of 5
- Ventura, City of 5
- Burbank, City of 5
- Petaluma, City of 5
- Rancho Palos Verdes, City of 5
- La Verne, City of 5
- West Covina, City of 5
- Murrieta, City of 5
- Fremont, City of 5
- Stockton, City of 5
- Gilroy, City of 5
- Gonzales, City of 5
- Marysville, City of 5
- Galt, City of 5
- South Lake Tahoe, City of 5
- Seal Beach, City of 4
- Monterey, City of 4
- Yorba Linda, City of 4
- Chino Hills, City of 4
- Visalia, City of 4
- San Leandro, City of 4
- Belmont, City of 4
- Lake Forest, City of 4
- Oakley, City of 4
- El Segundo, City of 4
- Benicia, City of 4
- Napa, City of 4
- Bellflower, City of 4
- Los Gatos, Town of 4
- Clovis, City of 4
- Manhattan Beach, City of 4
- Modesto, City of 4
- Los Banos, City of 4
- Ripon, City of 4
- Calexico, City of 4
- San Gabriel, City of 4
- Culver City, City of 3
- Santa Rosa, City of 3
- Pleasanton, City of 3
- Turlock, City of 3
- Anaheim, City of 3
- Glendora, City of 3
- Yucaipa, City of 3
- San Juan Capistrano, City of 3
- El Centro, City of 3
- San Mateo, City of 3
- Norco, City of 3
- Ontario, City of 3
- Pomona, City of 3
- Exeter, City of 3
- Porterville, City of 3
- Azusa, City of 3
- Tulare, City of 3
- Fontana, City of 3
- Alameda, City of 3
- Palmdale, City of 3
- El Monte, City of 3
- Livermore, City of 3
- Needles, City of 3
- Torrance, City of 3
- South Pasadena, City of 3
- La Mirada, City of 3
- Rio Vista, City of 3
- Duarte, City of 3
- San Clemente, City of 3
- Temecula, City of 3
- Healdsburg, City of 3
- Saint Helena, City of 3
- San Bruno, City of 3
- Vallejo, City of 3
- Woodland, City of 3
- Piedmont, City of 3
- Arcata, City of 3
- Yreka, City of 3
- Claremont, City of 2
- Victorville, City of 2
- Garden Grove, City of 2
- Corona, City of 2
- El Cajon, City of 2
- Downey, City of 2
- Oxnard, City of 2
- Redlands, City of 2
- Coronado, City of 2
- Scotts Valley, City of 2
- Capitola, City of 2
- Seaside, City of 2
- Costa Mesa, City of 2
- Paso Robles, City of 2
- Rosemead, City of 2
- Dana Point, City of 2
- Alhambra, City of 2
- Brawley, City of 2
- Dublin, City of 2
- Goleta, City of 2
- Loma Linda, City of 2
- Cupertino, City of 2
- Hollister, City of 2
- Santa Fe Springs, City of 2
- Barstow, City of 2
- Cerritos, City of 2
- Sanger, City of 2
- Brea, City of 2
- San Dimas, City of 2
- Reedley, City of 2
- Montebello, City of 2
- Rolling Hills Estates, City of 2
- Albany, City of 2
- Gardena, City of 2
- Pasadena, City of 2
- Arcadia, City of 2
- Sierra Madre, City of 2
- Monrovia, City of 2
- Agoura Hills, City of 2
- Shasta Lake, City of 2
- La Canada Flintridge, City of 2
- Berkeley, City of 2
- Hanford, City of 2
- Antioch, City of 2
- Brentwood, City of 2
- Pinole, City of 2
- Union City, City of 2
- Lemoore, City of 2
- Orinda, City of 2
- Tracy, City of 2
- Millbrae, City of 2
- Sunnyvale, City of 2
- Pismo Beach, City of 2
- Live Oak, City of 2
- Yuba City, City of 2
- Delano, City of 2
- King City, City of 2
- Manteca, City of 2
- Red Bluff, City of 2
- Lathrop, City of 2
- Laguna Niguel, City of 2
- West Sacramento, City of 2
- Folsom, City of 2
- Wheatland, City of 2
- Rocklin, City of 2
- Willits, City of 2
- South El Monte, City of 2
- La Quinta, City of 2
- Yountville, Town of 2
- Stanton, City of 2
- Ukiah, City of 2
- Oakdale, City of 1
- Patterson, City of 1
- Lancaster, City of 1
- Santa Maria, City of 1
- Lompoc, City of 1
- Riverbank, City of 1
- National City, City of 1
- Solvang, City of 1
- Huntington Park, City of 1
- Ojai, City of 1
- Huntington Beach, City of 1
- Monterey Park, City of 1
- Lindsay, City of 1
- Hemet, City of 1
- Vista, City of 1
- Palo Alto, City of 1
- Colton, City of 1
- Moorpark, City of 1
- Pacific Grove, City of 1
- Santa Monica, City of 1
- Lake Elsinore, City of 1
- San Pablo, City of 1
- Rancho Cucamonga, City of 1
- Beverly Hills, City of 1
- Palm Desert, City of 1
- Marina, City of 1
- Livingston, City of 1
- Indio, City of 1
- Menlo Park, City of 1
- Bell Gardens, City of 1
- Mill Valley, City of 1
- Placentia, City of 1
- Highland, City of 1
- Lakewood, City of 1
- Yucca Valley, Town of 1
- Fountain Valley, City of 1
- Compton, City of 1
- Inglewood, City of 1
- Tustin, City of 1
- Paramount, City of 1
- Hermosa Beach, City of 1
- Carson, City of 1
- Orange, City of 1
- Walnut, City of 1
- Avalon, City of 1
- Windsor, Town of 1
- Bell, City of 1
- Blythe, City of 1
- San Rafael, City of 1
- Cotati, City of 1
- Pico Rivera, City of 1
- Newark, City of 1
- Pittsburg, City of 1
- El Cerrito, City of 1
- Santa Clara, City of 1
- Pacifica, City of 1
- Cloverdale, City of 1
- Loomis, Town of 1
- Morgan Hill, City of 1
- Milpitas, City of 1
- Corte Madera, Town of 1
- American Canyon, City of 1
- San Anselmo, City of 1
- Half Moon Bay, City of 1
- Belvedere, City of 1
- Sausalito, City of 1
- Campbell, City of 1
- Larkspur, City of 1
- Mountain View, City of 1
- Madera, City of 1
- Atwater, City of 1
- Merced, City of 1
- Lawndale, City of 1
- Lodi, City of 1
- Colusa, City of 1
- Oroville, City of 1
- Ceres, City of 1
- Port Hueneme, City of 1
- Cathedral City, City of 1
- Lincoln, City of 1
- Arroyo Grande, City of 1
- Clayton, City of 1
- Desert Hot Springs, City of 1
- Rio Dell, City of 1
- Corning, City of 1
- Grover Beach, City of 1
- Los Angeles Department of Recreation and Parks, City of 1
- Rancho Cordova, City of 1
- Blue Lake, City of 1
- Crescent City, City of 1
- Williams, City of 1
- Ridgecrest, City of 1
- Calistoga, City of 1
- Point Arena, City of 1
- Emeryville, City of 1
- Suisun City, City of 1
- La Puente, City of 1
- Beaumont, City of 1
- Hughson, City of 1
- Fairfax, Town of 1
- Atherton, Town of 1
- Malibu, City of 1
- Elk Grove, City of 1
- Colma, City of 1
- Fort Jones, City of 1
- Bradbury, City of 1
ACCESS_TYP 4
- Open Access 1,210
- Restricted Access 166
- No Public Access 40
- Unknown Access 6
MNG_AG_TYP 1
- City Agency · 1,422 ✖
DES_TP 1
- Local Recreation Area · 1,422 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
232 | 232 | 231 | {"type": "Polygon", "coordinates": [[[-115.55924, 32.80381], [-115.55717, 32.80381], [-115.55717, 32.80208], [-115.5575, 32.80209], [-115.5578, 32.80221], [-115.5592, 32.8022], [-115.55924, 32.80381]]]} | Open Access 1 | 627 | Fraizer Field | 19039 | 1093 | El Centro, City of 94 | City 2 | City Agency 2 | http://www.cityofelcentro.org/parkandrec/index.asp | City 2 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | Imperial 20 | 8.576 | Fraizer Field | 0 | Local Recreation Area 3 | 4 | |
240 | 240 | 239 | {"type": "Polygon", "coordinates": [[[-117.08384, 33.16747], [-117.08271, 33.16759], [-117.08326, 33.16655], [-117.08332, 33.16648], [-117.08345, 33.1664], [-117.08359, 33.16635], [-117.08368, 33.16634], [-117.08367, 33.16648], [-117.08368, 33.16662], [-117.08384, 33.16747]]]} | Open Access 1 | 645 | City of Escondido Open Space | 17312 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 2.034 | City of Escondido OS | 0 | Local Recreation Area 3 | 4 | |
277 | 277 | 276 | {"type": "Polygon", "coordinates": [[[-117.5615, 33.93786], [-117.56124, 33.93819], [-117.56111, 33.93847], [-117.56107, 33.93871], [-117.56106, 33.93932], [-117.55877, 33.93932], [-117.55877, 33.93876], [-117.55864, 33.93875], [-117.55864, 33.9379], [-117.55991, 33.93791], [-117.55992, 33.93787], [-117.5615, 33.93786]]]} | Open Access 1 | 47359 | Community Center Park | 31082 | 1395 | Norco, City of 114 | City 2 | City Agency 2 | http://www.norco.ca.us/depts/parks/default.asp | City 2 | 1395 | Norco, City of 111 | City 2 | City Agency 2 | http://www.norco.ca.us/depts/parks/facilities/parks/communitycenter.asp | Riverside 10 | 8.953 | Community Ctr. Park | 0 | Local Recreation Area 3 | 4 |
278 | 278 | 277 | {"type": "Polygon", "coordinates": [[[-120.66515, 35.26662], [-120.66466, 35.26653], [-120.66436, 35.26666], [-120.66427, 35.26653], [-120.66393, 35.26612], [-120.66379, 35.266], [-120.66357, 35.26587], [-120.66337, 35.26579], [-120.66315, 35.26574], [-120.66292, 35.26572], [-120.66252, 35.26572], [-120.66262, 35.26536], [-120.66261, 35.26497], [-120.66004, 35.26496], [-120.66011, 35.26356], [-120.65886, 35.26356], [-120.65883, 35.26352], [-120.65904, 35.26352], [-120.65905, 35.26351], [-120.659, 35.26347], [-120.6588, 35.26341], [-120.65852, 35.26335], [-120.65797, 35.26314], [-120.65777, 35.26304], [-120.65767, 35.26291], [-120.6573, 35.26264], [-120.65721, 35.26255], [-120.65717, 35.2625], [-120.65683, 35.26235], [-120.65661, 35.26231], [-120.6564, 35.26215], [-120.65633, 35.26207], [-120.65617, 35.26197], [-120.65608, 35.26186], [-120.65599, 35.26184], [-120.65583, 35.26163], [-120.65493, 35.26108], [-120.6544, 35.25768], [-120.65583, 35.25766], [-120.65584, 35.2577], [-120.65524, 35.25788], [-120.65526, 35.25821], [-120.65719, 35.26012], [-120.65825, 35.26135], [-120.65927, 35.26221], [-120.66054, 35.2628], [-120.66113, 35.26331], [-120.66475, 35.2634], [-120.66476, 35.26499], [-120.66513, 35.265], [-120.66515, 35.26662]], [[-120.66016, 35.26352], [-120.66016, 35.2635], [-120.66011, 35.26351], [-120.66012, 35.26352], [-120.66016, 35.26352]]]} | Open Access 1 | 946 | South Hills Open Space | 25656 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 58.628 | South Hills OS | 0 | Local Recreation Area 3 | 4 | |
282 | 282 | 281 | {"type": "Polygon", "coordinates": [[[-117.89382, 33.88608], [-117.89375, 33.8862], [-117.89366, 33.88628], [-117.89357, 33.88634], [-117.89345, 33.88638], [-117.89184, 33.88657], [-117.89171, 33.88659], [-117.89162, 33.88663], [-117.89142, 33.88677], [-117.89085, 33.88747], [-117.89075, 33.88764], [-117.89069, 33.88781], [-117.89029, 33.88783], [-117.89023, 33.8878], [-117.8901, 33.88716], [-117.89051, 33.88706], [-117.89064, 33.88674], [-117.89088, 33.88669], [-117.89106, 33.88662], [-117.89167, 33.88626], [-117.89176, 33.88622], [-117.89298, 33.88609], [-117.89312, 33.88604], [-117.89324, 33.88597], [-117.89338, 33.88584], [-117.89382, 33.88608]]]} | Open Access 1 | 756 | Fullerton Creek Greenbelt | 19143 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 4.418 | Fullerton Creek Greenbelt | 0 | Local Recreation Area 3 | 4 | |
285 | 285 | 284 | {"type": "MultiPolygon", "coordinates": [[[[-119.69069, 34.44329], [-119.69064, 34.4434], [-119.69065, 34.44355], [-119.69068, 34.44362], [-119.69097, 34.44402], [-119.69099, 34.44413], [-119.69098, 34.44422], [-119.69094, 34.4443], [-119.69087, 34.44436], [-119.69029, 34.44464], [-119.69015, 34.44481], [-119.69015, 34.44384], [-119.68972, 34.44402], [-119.68956, 34.44406], [-119.68939, 34.44408], [-119.68783, 34.44396], [-119.68772, 34.44393], [-119.6876, 34.44389], [-119.68726, 34.44363], [-119.68703, 34.44354], [-119.68683, 34.4435], [-119.68629, 34.44347], [-119.68596, 34.4434], [-119.68596, 34.44324], [-119.68632, 34.44331], [-119.6869, 34.44334], [-119.6871, 34.44338], [-119.6873, 34.44346], [-119.68745, 34.44355], [-119.68767, 34.44372], [-119.68782, 34.44378], [-119.68937, 34.44392], [-119.68964, 34.44387], [-119.69015, 34.44364], [-119.69013, 34.44286], [-119.69069, 34.44329]]], [[[-119.69482, 34.44571], [-119.69452, 34.44628], [-119.69438, 34.44643], [-119.69253, 34.44663], [-119.69154, 34.4466], [-119.69056, 34.44614], [-119.69014, 34.44596], [-119.69015, 34.44498], [-119.69037, 34.44471], [-119.69094, 34.44446], [-119.69102, 34.4444], [-119.69109, 34.44429], [-119.69113, 34.44416], [-119.6911, 34.444], [-119.6908, 34.44353], [-119.69078, 34.44345], [-119.6908, 34.44337], [-119.69144, 34.44386], [-119.69193, 34.44417], [-119.69239, 34.44438], [-119.6932, 34.44461], [-119.69391, 34.4449], [-119.69482, 34.44571]]]]} | Unknown Access 4 | 777 | Sheffield Reservoir | 25382 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 26.245 | Sheffield Reservoir | 0 | Local Recreation Area 3 | 4 | |
294 | 294 | 293 | {"type": "Polygon", "coordinates": [[[-118.36564, 34.02332], [-118.36557, 34.02447], [-118.36551, 34.02475], [-118.36542, 34.02503], [-118.36317, 34.02482], [-118.36308, 34.02548], [-118.3629, 34.02546], [-118.36318, 34.02338], [-118.36465, 34.02338], [-118.36466, 34.02331], [-118.36564, 34.02332]]]} | Open Access 1 | 788 | Baldwin Hills Recreation Center | 15776 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 10.253 | Baldwin Hills Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
313 | 313 | 312 | {"type": "Polygon", "coordinates": [[[-119.13591, 36.29543], [-119.13588, 36.29709], [-119.13271, 36.29702], [-119.1327, 36.29541], [-119.13591, 36.29543]]]} | Open Access 1 | 1084 | Exeter City Athletic Park | 18774 | 1103 | Exeter, City of 129 | City 2 | City Agency 2 | http://www.cityofexeter.com/ | City 2 | 1103 | Exeter, City of 126 | City 2 | City Agency 2 | Tulare 29 | 12.899 | Exeter City Athletic Park | 0 | Local Recreation Area 3 | 4 | |
354 | 354 | 353 | {"type": "Polygon", "coordinates": [[[-117.36947, 33.17694], [-117.36912, 33.17714], [-117.36883, 33.1768], [-117.3692, 33.17658], [-117.36947, 33.17694]]]} | Open Access 1 | 976 | Buccaneer Beach Access | 16467 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | San Diego 4 | 0.466 | Buccaneer Beach Access | 0 | Local Recreation Area 3 | 4 | |
371 | 371 | 370 | {"type": "Polygon", "coordinates": [[[-119.131, 36.29982], [-119.13097, 36.30053], [-119.1279, 36.30049], [-119.12801, 36.2971], [-119.13018, 36.29713], [-119.13005, 36.29768], [-119.13003, 36.29832], [-119.13033, 36.29892], [-119.13082, 36.29961], [-119.131, 36.29982]]]} | Open Access 1 | 1081 | Dobson Field | 18175 | 1103 | Exeter, City of 129 | City 2 | City Agency 2 | http://www.cityofexeter.com/ | City 2 | 1103 | Exeter, City of 126 | City 2 | City Agency 2 | Tulare 29 | 20.718 | Dobson Field | 0 | Local Recreation Area 3 | 4 | |
416 | 416 | 415 | {"type": "Polygon", "coordinates": [[[-117.31368, 34.12421], [-117.31368, 34.12495], [-117.31262, 34.12495], [-117.31262, 34.1242], [-117.31368, 34.12421]]]} | Open Access 1 | 1286 | Gutierrez Field | 19573 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 1.988 | Gutierrez Field | 0 | Local Recreation Area 3 | 4 | |
462 | 462 | 461 | {"type": "Polygon", "coordinates": [[[-119.82186, 36.78834], [-119.81967, 36.78838], [-119.81975, 36.78668], [-119.82184, 36.78661], [-119.82186, 36.78834]]]} | Open Access 1 | 1856 | Quigley Playground | 24064 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 8.955 | Quigley Playground | 0 | Local Recreation Area 3 | 4 | |
466 | 466 | 465 | {"type": "Polygon", "coordinates": [[[-119.77435, 36.73962], [-119.77432, 36.74122], [-119.7726, 36.74123], [-119.77267, 36.73961], [-119.77435, 36.73962]]]} | Open Access 1 | 922 | Holmes Playground | 20056 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 6.725 | Holmes Playground | 0 | Local Recreation Area 3 | 4 | |
508 | 508 | 507 | {"type": "Polygon", "coordinates": [[[-119.77465, 36.75361], [-119.77461, 36.75365], [-119.77404, 36.75398], [-119.77404, 36.75406], [-119.7726, 36.75407], [-119.7726, 36.75242], [-119.77465, 36.75241], [-119.77465, 36.75361]]]} | Open Access 1 | 2073 | Romain Playground | 24586 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 7.876 | Romain Playground | 0 | Local Recreation Area 3 | 4 | |
559 | 559 | 558 | {"type": "Polygon", "coordinates": [[[-117.14812, 33.12447], [-117.14555, 33.12477], [-117.14553, 33.12381], [-117.1481, 33.12381], [-117.14812, 33.12447]]]} | Open Access 1 | 1866 | City of San Marcos Open Space | 17333 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 5.376 | City of San Marcos OS | 0 | Local Recreation Area 3 | 4 | |
568 | 568 | 567 | {"type": "Polygon", "coordinates": [[[-118.08621, 33.93879], [-118.08597, 33.93885], [-118.08499, 33.93885], [-118.08498, 33.93814], [-118.08454, 33.938], [-118.08408, 33.93774], [-118.08394, 33.93726], [-118.08284, 33.93741], [-118.08267, 33.93673], [-118.08267, 33.93658], [-118.08466, 33.93659], [-118.08465, 33.93544], [-118.08619, 33.93545], [-118.08621, 33.93879]]]} | Open Access 1 | 3354 | Lake Center Athletic Park | 20879 | 1321 | Santa Fe Springs, City of 211 | City 2 | City Agency 2 | http://www.santafesprings.org/cityhall/community_serv/parks/default.asp | City 2 | 1321 | Santa Fe Springs, City of 207 | City 2 | City Agency 2 | Los Angeles 6 | 17.226 | Lake Ctr. Athletic Park | 0 | Local Recreation Area 3 | 4 | |
574 | 574 | 573 | {"type": "Polygon", "coordinates": [[[-117.03531, 32.69994], [-117.03497, 32.70006], [-117.03488, 32.70023], [-117.03519, 32.70101], [-117.03496, 32.70097], [-117.03328, 32.701], [-117.03352, 32.70069], [-117.03386, 32.70047], [-117.03445, 32.70026], [-117.03443, 32.69981], [-117.03449, 32.69954], [-117.03449, 32.69929], [-117.03457, 32.69943], [-117.03467, 32.69969], [-117.03485, 32.69976], [-117.03517, 32.69966], [-117.03531, 32.69994]]]} | Open Access 1 | 1914 | South Bay Terraces Open Space | 25638 | 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 | 3.533 | South Bay Terraces OS | 0 | Local Recreation Area 3 | 4 | |
604 | 604 | 603 | {"type": "Polygon", "coordinates": [[[-117.28533, 33.07516], [-117.2853, 33.07521], [-117.28527, 33.07522], [-117.28497, 33.07519], [-117.28477, 33.07514], [-117.28457, 33.07503], [-117.28437, 33.07495], [-117.28396, 33.07485], [-117.28367, 33.07484], [-117.28329, 33.07488], [-117.28306, 33.07494], [-117.28302, 33.07497], [-117.28297, 33.07497], [-117.2828, 33.07505], [-117.28249, 33.07525], [-117.28238, 33.07536], [-117.28222, 33.07554], [-117.28212, 33.07569], [-117.28206, 33.07584], [-117.28172, 33.07682], [-117.28167, 33.07691], [-117.28158, 33.07705], [-117.28148, 33.07716], [-117.2814, 33.07724], [-117.28127, 33.07733], [-117.2805, 33.07234], [-117.28049, 33.07122], [-117.2805, 33.07054], [-117.28494, 33.07056], [-117.28494, 33.07238], [-117.28533, 33.07516]]]} | Open Access 1 | 2084 | Indian Head Canyon | 20201 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 55.677 | Indian Head Canyon | 0 | Local Recreation Area 3 | 4 | |
627 | 627 | 626 | {"type": "Polygon", "coordinates": [[[-118.08436, 34.05755], [-118.08246, 34.05754], [-118.08245, 34.0555], [-118.08435, 34.05549], [-118.08436, 34.05755]]]} | Open Access 1 | 2445 | Jess Gonzales Sports Park | 20403 | 1284 | Rosemead, City of 130 | City 2 | City Agency 2 | http://www.cityofrosemead.org/index.aspx?page=74 | City 2 | 1284 | Rosemead, City of 127 | City 2 | City Agency 2 | Los Angeles 6 | 9.869 | Jess Gonzales Sports Park | 0 | Local Recreation Area 3 | 4 | |
671 | 671 | 670 | {"type": "Polygon", "coordinates": [[[-117.24681, 33.89806], [-117.24567, 33.89807], [-117.24568, 33.89692], [-117.24567, 33.89565], [-117.24678, 33.89563], [-117.24681, 33.89806]]]} | Open Access 1 | 5102 | March Field Park | 21792 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 6.91 | March Field Park | 0 | Local Recreation Area 3 | 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]);