units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
236 rows where MNG_AG_TYP = 7 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, PARK_URL, COUNTY, ACRES, LABEL_NAME, YR_EST, GAP_STS
UNIT_NAME 214 ✖
- Mount Madonna County Park 4
- Lexington Reservoir 3
- Los Gatos Creek Trail 3
- Penitencia Creek Park 3
- Calero County Park 2
- Coyote Creek Parkway 2
- Ernie Smith Community Park 2
- Frank G Bonelli Regional Park 2
- Kenneth Hahn State Recreation Area 2
- Los Gatos Creek Park 2
- Martial Cottle Park 2
- North Sonoma Mountain Regional Park and Open Space Preserve 2
- San Bruno Mountain State and County Park 2
- Sanborn County Park 2
- Spring Lake Regional Park 2
- Stevens Creek County Park 2
- Sunnyvale Baylands Park 2
- 72nd Street Equestrian Park 1
- Acton Park 1
- Adrian Rosall Park 1
- Agate Beach 1
- Albatross Road Rest Area 1
- Alder Park 1
- Almaden Quicksilver Park 1
- Altadena Triangle Park 1
- Alviso Marina 1
- Amigo Park 1
- Andersen 1
- Anderson Lake County Park 1
- Andy's Unity Park 1
- Apollo Community Regional Park 1
- Aramburu Wildlife Preserve 1
- Arnold Park 1
- Avocado Heights Park 1
- Belvedere Community Regional Park 1
- Bertsch Tract Park 1
- Big Rock Wash Wildlife Sanctuary 1
- Bill Blevins Park 1
- Black Point Boat Launch 1
- Black Point Nature Preserve 1
- Bolinas Park 1
- Bouverie Wildflower Preserve 1
- Butte Valley Wildflower Sanctuary 1
- Candy's Park 1
- Carolyn Rosas Park 1
- Castro Park 1
- Charles F. McGlashan Pathway 1
- Chesbro 1
- Chicken Ranch Beach 1
- Chitactac-Adams County Park 1
- Christmas Hill Park 1
- Church and New Land Bank 1
- Civic Center Lagoon Park 1
- Cloverdale River Park 1
- Compton Creek Walking Path 1
- Corte Los Sombras Park 1
- Corte Madera Bike Path 1
- Corte Madera Creek Path 1
- Coyote Canyon 1
- Coyote Highlands 1
- Coyote Lake-Harvey Bear Ranch County Park 1
- Coyote Point Recreation Area 1
- Crane Creek 1
- Creekside Park 1
- Crescenta Valley Community Regional Park 1
- Del Aire Park 1
- Del Valle Park 1
- Descanso Gardens 1
- Devil's Slide Trail 1
- Diamond Bar Golf Course 1
- Don Knabe Community Regional Park 1
- Doran Park 1
- Doran Regional Park 1
- Earvin 'Magic' Johnson Recreation Area 1
- East Rancho Dominguez Park 1
- Eaton Canyon Golf Course 1
- Eaton Canyon Natural Area and Nature Center 1
- Edgewood Park and Natural Preserve 1
- Edward R. Levin Park 1
- El Cariso Community Regional Park 1
- El Cariso Golf Course 1
- Eldrid Preserve 1
- Eugene A. Obregon Park 1
- Field Sports Park 1
- Fitzgerald Marine Reserve 1
- Flood Park 1
- Florence Keller Park 1
- Foothill Regional Park 1
- Forest Knolls Park 1
- Friendship Park 1
- Ganesha Park 1
- George Washington Carver Park 1
- Gloria Heer Park 1
- Greenbrae Redwoods County Park 1
- Gualala Point 1
- Guerneville River Park 1
- Healdsburg Beach 1
- Helen Putnam Park 1
- Helen Putnam Regional Park 1
- Hellyer County Park 1
- Highland Camrose Park 1
- Homestead Valley 1
- Hood Mountain Regional Park and Open Space Preserve 1
- Huddart Park 1
- Jackie Robinson Park 1
- Jesse Owens Community Regional Park 1
- John Anson Ford Amphitheatre and County Parkland 1
- John F. McInnis County Park 1
- Joseph D. Grant Park 1
- Junipero Serra Park 1
- Kamph Memorial Park 1
- Kellogg Beach 1
- Kenwood Plaza Park 1
- King Park 1
- Knollwood Golf Course 1
- Knollwood Pool 1
- La Mirada Community Regional Park 1
- LaPoint Land Bank 1
- Ladera Park 1
- Lagunitas Village Mini-Park 1
- Larson Park 1
- Lennox Community Garden 1
- Loma Alta Park 1
- Los Amigos Golf Course 1
- Los Angeles County Arboretum and Botanic Garden 1
- Maddux Ranch Regional Park 1
- Maggie Hathaway Golf Course 1
- Marshall Canyon Golf Course 1
- Mary M. Bethune Park 1
- Maxwell Farms Regional Park 1
- McNears Beach County Park 1
- Memorial Park 1
- Mill Valley/Sausalito Path 1
- Miller Park Boat Launch 1
- Mira Vista Park 1
- Mirada Surf Park 1
- Mission Pass Path 1
- Moms Beach 1
- Moody Gulch Land Bank 1
- Moran Goodman Park 1
- Moss Beach Park 1
- Motorcycle County Park 1
- Pacheco Path 1
- Pamela County Park 1
- Paradise Beach 1
- Park Learning Grove County Park 1
- Pathfinder Community Regional Park 1
- Pebble Beach 1
- Penitencia Creek Park Chain 1
- Pescadero Creek Park 1
- Pickens Canyon Park 1
- Pigeon Point County Park 1
- Pillar Point Bluff 1
- Pinnacle Gulch 1
- Placerita Canyon State Park 1
- Point St. George 1
- Pueblo Park 1
- Pyke Field 1
- Quarry Park 1
- Ragle Ranch 1
- Rimgrove Park 1
- Riverfront Regional Park 1
- Rocky Graham Park 1
- Rowland Heights Park 1
- Ruben F. Salazar Park 1
- Ruben Ingold Parkway 1
- Rush Creek Park 1
- Saddle Peak 1
- Sam McDonald Park 1
- San Bruno Mountain State Park 1
- San Pedro Valley Park 1
- Sanchez Adobe County Park 1
- Santa Fe Dam Recreation Area 1
- Santa Teresa County Park 1
- Sea Ranch Trail Access 1
- Seven Oaks Hill 1
- Shaw Park 1
- Shell Beach 1
- Shiloh Ranch Regional Park 1
- Silveira 1
- Soda Springs 1
- Sonoma Valley Regional Park 1
- Sorensen Park 1
- Spud Pt Marina 1
- Stafford Lake County Park 1
- Stengel Beach 1
- Stewart Ridge 1
- Stillwater Cove Regional Park 1
- Summit Road Land Bank 1
- Sunset Beach 1
- Taylor Mountain Regional Park and Open Space Preserve 1
- Tiburon Uplands Nature Preserve 1
- Tolay Lake Regional Park 1
- Treadwell 1
- Tulare Hill Land Bank 1
- Tunitas Creek Beach 1
- Unity 1
- Upper Stevens Creek County Park 1
- Upton County Beach 1
- Uvas Canyon County Park 1
- Uvas Reservoir 1
- Vasona Lake County Park 1
- Vasquez Rocks Natural Area and Nature Center 1
- Vermont Median 1
- Veterans Memorial Community Regional Park 1
- Victoria Community Regional Park 1
- Village Green 1
- Washington Playground 1
- Watson School/ Wayside Park 1
- West County Trail 1
- Westside Park 1
- Wild Wings Park 1
- Wohler Bridge Fishing Access 1
- Wunderlich Park 1
DES_TP 32
- Local Park 154
- Local Recreation Area 37
- Local Conservation Area 12
- Local Resource Management Area 5
- Local Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AGENCY 7
- Los Angeles - Department of Parks and Recreation, County of 65
- Santa Clara County Parks and Recreation Dept., County of 55
- Sonoma County Regional Parks Dept., County of 50
- Marin County Parks Department, County of 34
- San Mateo County Parks and Recreation Dept., County of 25
- Del Norte County Parks, County of 6
- Yolo County Parks, County of 1
ACCESS_TYP 4
- Open Access 206
- No Public Access 18
- Restricted Access 11
- Unknown Access 1
MNG_AG_TYP 1
- County Agency - Parks · 236 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11442 | 11442 | 11441 | {"type": "Polygon", "coordinates": [[[-118.36175, 33.93255], [-118.36175, 33.93272], [-118.36145, 33.93272], [-118.36146, 33.93255], [-118.36175, 33.93255]]]} | Open Access 1 | 48138 | Lennox Community Garden | 32666 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 0.127 | Lennox Community Garden | 0 | Local Park 2 | 4 | |
9554 | 9554 | 9553 | {"type": "Polygon", "coordinates": [[[-122.51744, 38.01193], [-122.51734, 38.01202], [-122.51708, 38.01218], [-122.51696, 38.01205], [-122.51738, 38.01189], [-122.51744, 38.01193]]]} | Open Access 1 | 16105 | Candy's Park | 16799 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 0.134 | Candy's Park | 0 | Local Park 2 | 4 | |
12451 | 12451 | 12450 | {"type": "Polygon", "coordinates": [[[-121.85893, 37.37941], [-121.85873, 37.3795], [-121.85851, 37.37957], [-121.8585, 37.37936], [-121.85856, 37.37933], [-121.85893, 37.37941]]]} | Open Access 1 | 28092 | Penitencia Creek Park | 23582 | 2143 | Santa Clara Valley Water District 483 | Special District 4 | Water District 13 | http://www.valleywater.org/ | Special District 4 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | Santa Clara 19 | 0.135 | Penitencia Creek Park | 1872 | Local Park 2 | 4 | |
11446 | 11446 | 11445 | {"type": "Polygon", "coordinates": [[[-118.49983, 34.28887], [-118.49978, 34.28895], [-118.49972, 34.28892], [-118.49959, 34.28878], [-118.49971, 34.28866], [-118.49975, 34.28864], [-118.49983, 34.28865], [-118.49987, 34.28867], [-118.49989, 34.28871], [-118.49989, 34.28876], [-118.49983, 34.28885], [-118.49983, 34.28887]]]} | Open Access 1 | 48139 | Knollwood Pool | 32669 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/knollwood-pool/ | Los Angeles 6 | 0.141 | Knollwood Pool | 0 | Local Recreation Area 3 | 4 |
4302 | 4302 | 4301 | {"type": "Polygon", "coordinates": [[[-118.1262, 34.18898], [-118.12621, 34.18904], [-118.12603, 34.18933], [-118.12602, 34.18935], [-118.12595, 34.18934], [-118.12593, 34.18924], [-118.12595, 34.18897], [-118.12609, 34.18896], [-118.1262, 34.18898]]]} | Open Access 1 | 48153 | Ganesha Park | 32689 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 0.181 | Ganesha Park | 0 | Local Park 2 | 4 | |
14869 | 14869 | 14868 | {"type": "Polygon", "coordinates": [[[-118.23121, 34.21905], [-118.23088, 34.21936], [-118.23059, 34.21958], [-118.23052, 34.21953], [-118.23111, 34.21899], [-118.23121, 34.21905]]]} | Open Access 1 | 45388 | Pickens Canyon Park | 32497 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Pickens_Canyon_Park | Los Angeles 6 | 0.22 | Pickens Canyon Park | 0 | Local Park 2 | 4 |
15076 | 15076 | 15075 | {"type": "Polygon", "coordinates": [[[-118.23107, 34.20894], [-118.23096, 34.20934], [-118.23094, 34.20936], [-118.2309, 34.20936], [-118.23081, 34.20922], [-118.23064, 34.20904], [-118.23064, 34.20902], [-118.23066, 34.209], [-118.23091, 34.20896], [-118.23103, 34.20892], [-118.23106, 34.20892], [-118.23107, 34.20894]]]} | Open Access 1 | 45856 | Mira Vista Park | 32494 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 0.249 | Mira Vista Park | 0 | Local Park 2 | 4 | |
14522 | 14522 | 14521 | {"type": "Polygon", "coordinates": [[[-122.52992, 37.94943], [-122.52988, 37.94956], [-122.52939, 37.94972], [-122.5293, 37.94972], [-122.52954, 37.94934], [-122.52992, 37.94943]]]} | Open Access 1 | 47185 | Corte Los Sombras Park | 31223 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 0.299 | Corte Los Sombras Park | 0 | Local Park 2 | 4 | |
5566 | 5566 | 5565 | {"type": "Polygon", "coordinates": [[[-122.21003, 37.47408], [-122.20952, 37.47417], [-122.20935, 37.47434], [-122.20898, 37.4741], [-122.20983, 37.47394], [-122.21003, 37.47408]]]} | Open Access 1 | 46891 | Friendship Park | 30388 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | San Mateo 15 | 0.407 | Friendship Park | 0 | Local Park 2 | 4 | |
15080 | 15080 | 15079 | {"type": "Polygon", "coordinates": [[[-118.29689, 33.82584], [-118.29682, 33.82596], [-118.29682, 33.82618], [-118.2968, 33.82621], [-118.2963, 33.82621], [-118.2963, 33.82584], [-118.29689, 33.82584]]]} | Open Access 1 | 45860 | Park Learning Grove County Park | 32495 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Park_Learning_Grove_County_Park | Los Angeles 6 | 0.488 | Park Learning Grove County Park | 0 | Local Park 2 | 4 |
9757 | 9757 | 9756 | {"type": "Polygon", "coordinates": [[[-118.13253, 34.18988], [-118.13208, 34.1899], [-118.13157, 34.19001], [-118.1315, 34.18999], [-118.13147, 34.18994], [-118.13148, 34.18975], [-118.13166, 34.18963], [-118.13189, 34.1897], [-118.13207, 34.18969], [-118.13216, 34.18976], [-118.13253, 34.18988]]]} | Open Access 1 | 47869 | Altadena Triangle Park | 32467 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/altadena-triangle-park/ | Los Angeles 6 | 0.524 | Altadena Triangle Park | 0 | Local Park 2 | 4 |
3988 | 3988 | 3987 | {"type": "Polygon", "coordinates": [[[-122.68946, 38.01406], [-122.68941, 38.01415], [-122.68914, 38.01432], [-122.68905, 38.01435], [-122.68897, 38.01436], [-122.6889, 38.01434], [-122.68874, 38.01421], [-122.68929, 38.01378], [-122.6893, 38.01384], [-122.68938, 38.01388], [-122.68944, 38.01394], [-122.68946, 38.01399], [-122.68946, 38.01406]]]} | Open Access 1 | 38044 | Forest Knolls Park | 18995 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 0.526 | Forest Knolls Park | 0 | Local Park 2 | 4 | |
11566 | 11566 | 11565 | {"type": "Polygon", "coordinates": [[[-123.4743, 38.7297], [-123.47379, 38.7302], [-123.47355, 38.72996], [-123.47404, 38.72949], [-123.4743, 38.7297]]]} | Open Access 1 | 23648 | Shell Beach | 25387 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 0.556 | Shell Beach | 0 | Local Park 2 | 4 | |
5567 | 5567 | 5566 | {"type": "Polygon", "coordinates": [[[-122.51225, 37.52751], [-122.51195, 37.52795], [-122.51135, 37.52763], [-122.512, 37.5274], [-122.51225, 37.52751]]]} | Open Access 1 | 46892 | Moss Beach Park | 30389 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | San Mateo 15 | 0.6 | Moss Beach Park | 0 | Local Park 2 | 4 | |
14035 | 14035 | 14034 | {"type": "MultiPolygon", "coordinates": [[[[-122.63982, 37.89789], [-122.63971, 37.89843], [-122.63938, 37.89841], [-122.63938, 37.89813], [-122.63955, 37.89814], [-122.63955, 37.89788], [-122.63982, 37.89789]]], [[[-122.64032, 37.89826], [-122.64022, 37.8985], [-122.6399, 37.89842], [-122.63995, 37.89817], [-122.64032, 37.89826]]]]} | Open Access 1 | 38042 | Village Green | 27111 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 0.621 | Village Green | 0 | Local Park 2 | 4 | |
2626 | 2626 | 2625 | {"type": "Polygon", "coordinates": [[[-122.51197, 38.34219], [-122.51196, 38.34225], [-122.51196, 38.34231], [-122.51135, 38.34242], [-122.51119, 38.34185], [-122.51136, 38.34182], [-122.51197, 38.34219]]]} | Open Access 1 | 18036 | Moran Goodman Park | 22470 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 0.652 | Moran Goodman Park | 1990 | Local Park 2 | 4 | |
2470 | 2470 | 2469 | {"type": "Polygon", "coordinates": [[[-121.93625, 37.29043], [-121.93574, 37.29058], [-121.93531, 37.29081], [-121.93489, 37.29119], [-121.93414, 37.29197], [-121.93402, 37.29191], [-121.93485, 37.29101], [-121.93558, 37.29054], [-121.93623, 37.29028], [-121.93625, 37.29043]]]} | Open Access 1 | 17438 | Los Gatos Creek Trail | 21517 | 326 | Santa Clara County Parks and Recreation Dept., County of 472 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | Santa Clara 19 | 0.826 | Los Gatos Creek Trail | 1966 | Local Recreation Area 3 | 4 | |
9586 | 9586 | 9585 | {"type": "Polygon", "coordinates": [[[-122.51646, 38.01272], [-122.51615, 38.01311], [-122.51571, 38.01298], [-122.51568, 38.01286], [-122.5156, 38.01274], [-122.51562, 38.0127], [-122.51608, 38.01244], [-122.51646, 38.01272]]]} | Open Access 1 | 16115 | Adrian Rosall Park | 15275 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 0.826 | Adrian Rosall Park | 0 | Local Park 2 | 4 | |
9588 | 9588 | 9587 | {"type": "Polygon", "coordinates": [[[-122.5151, 38.01577], [-122.51506, 38.01607], [-122.51496, 38.01608], [-122.51487, 38.01612], [-122.51466, 38.01636], [-122.51442, 38.01623], [-122.51419, 38.01606], [-122.5143, 38.01593], [-122.51453, 38.01595], [-122.51459, 38.01568], [-122.51475, 38.01559], [-122.51485, 38.01565], [-122.51505, 38.01543], [-122.51507, 38.01544], [-122.51488, 38.01566], [-122.5151, 38.01577]]]} | Open Access 1 | 16117 | Pueblo Park | 24026 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 0.899 | Pueblo Park | 0 | Local Park 2 | 4 | |
9345 | 9345 | 9344 | {"type": "Polygon", "coordinates": [[[-122.29842, 37.5564], [-122.2981, 37.55659], [-122.29806, 37.55653], [-122.29799, 37.55649], [-122.29791, 37.55648], [-122.29782, 37.55651], [-122.29745, 37.55611], [-122.2975, 37.55607], [-122.29753, 37.556], [-122.29751, 37.55594], [-122.29746, 37.55589], [-122.29777, 37.55571], [-122.29842, 37.5564]]]} | Open Access 1 | 15612 | Washington Playground | 27284 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | San Mateo 15 | 1.049 | Washington Playground | 1962 | 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]);