units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
969 rows where ACCESS_TYP = 3 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_NAME, AGNCY_LEV, AGNCY_WEB, MNG_AG_ID, PARK_URL, COUNTY, LABEL_NAME, YR_EST, GAP_STS
DES_TP 211
- Private Conservation 211
- Local Recreation Area 113
- Local Other or Unknown 96
- Local Park 77
- Local Conservation Area 77
- State Resource Management Area 64
- Private Recreation or Education 25
- Private Other or Unknown 25
- State Conservation Area 22
- State Other or Unknown 19
- National Wildlife Refuge 14
- Local Resource Management Area 8
- State Park 5
- Private Agricultural 5
- Resource Management Area 4
- Conservation Area 3
- Federal Other or Unknown 3
- State Historic or Cultural Area 3
- National Public Lands 2
- National Monument or Landmark 2
- None 1
- None 1
- State Recreation Area 1
- Recreation Management Area 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
- 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
- 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
- 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
- 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
- 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
- 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 186
- California Department of Fish and Wildlife 79
- East Bay Regional Park District 47
- Los Angeles, City of 36
- The Nature Conservancy 32
- Las Virgenes Municipal Water District 28
- Peninsula Open Space Trust 24
- Natomas Basin Conservancy 22
- Rivers and Lands Conservancy 22
- The Environmental Trust 21
- Torrance, City of 20
- Mountains Restoration Trust 20
- San Diego, City of 19
- Midpeninsula Regional Open Space District 19
- Santa Clara Valley Open Space Authority 18
- United States Fish and Wildlife Service 16
- Fresno Metropolitan Flood Control District 16
- California Department of Parks and Recreation 15
- Endangered Habitats Conservancy 14
- San Diego, County of 14
- Los Angeles County Flood Control District 13
- Kinneloa Irrigation District 13
- Santa Clara County Parks and Recreation Dept., County of 13
- American River Conservancy 13
- Save Mount Diablo 13
- Littlerock Creek Irrigation District 13
- Napa, City of 12
- Sonoma Land Trust 11
- Sonoma County Agricultural Preservation and Open Space District 11
- California Department of Water Resources 11
- California Department of General Services 10
- Escondido, City of 10
- Riverside County Habitat Conservation Agency 10
- Mountains Recreation and Conservation Authority 9
- Santa Rosa, City of 9
- Center for Natural Lands Management 8
- Elkhorn Slough Foundation 8
- Rocklin, City of 8
- Napa County Regional Park and Open Space District 7
- Marin Audubon Society 7
- Los Angeles - Department of Water and Power, City of 7
- Vallejo, City of 7
- Metropolitan Water District of Southern California 6
- East Bay Municipal Utility District 6
- Wilderness Land Trust 6
- Los Angeles, County of 5
- Land Trust of Santa Cruz County 5
- United States Army Corps of Engineers 5
- California Department of Transportation 5
- Saint Helena, City of 5
- United States Bureau of Land Management 4
- Petaluma, City of 4
- Vacaville, City of 4
- Big Sur Land Trust 4
- San Marcos, City of 4
- Other Federal 4
- Long Beach, City of 4
- Land Conservancy of San Luis Obispo County 4
- Pacific Forest Trust 4
- The Conservation Fund - California 4
- San Bernardino County Flood Control District 4
- Santa Barbara Flood Control and Water Conserv. District 3
- University of California 3
- Bear Yuba Land Trust 3
- John Muir Land Trust 3
- Rolling Hills, City of 3
- La Verne, City of 3
- Fallbrook Land Conservancy 3
- San Dieguito River Valley Land Conservancy 3
- Chico, City of 3
- Napa, County of 3
- Roseville, City of 3
- Placer Land Trust 3
- Monterey, County of 2
- Monterey Peninsula Regional Park District 2
- Save the Redwoods League 2
- Sequoia Riverlands Trust 2
- Poway, City of 2
- Land Trust of Napa County 2
- Sonoma County Regional Parks Dept., County of 2
- Rancho Palos Verdes, City of 2
- Palos Verdes Estates, City of 2
- Escondido Creek Conservancy 2
- California Department of Forestry and Fire Protection 2
- Solano Land Trust 2
- Redding, City of 2
- Conejo Open Space Conservation Agency 2
- United States Department of Defense 2
- Arcata, City of 2
- Sebastopol, City of 2
- National Audubon Society 2
- Mojave Desert Land Trust 2
- Valley Center Water District 2
- California Wildlife Conservation Board 2
- Coachella Valley Mountains Conservancy 2
- Audubon Canyon Ranch 2
- Olivenhain Municipal Water District 2
- San Diego County Water Authority 2
- California Tahoe Conservancy 2
- Ojai Valley Land Conservancy 2
- Santa Barbara, County of 1
- Watsonville, City of 1
- San Mateo County Parks and Recreation Dept., County of 1
- Santee, City of 1
- Marin County Open Space District 1
- California State Lands Commission 1
- Glendora, City of 1
- Oceanside, City of 1
- Chula Vista, City of 1
- Rosemead, City of 1
- Other State 1
- Marin County Parks Department, County of 1
- Davis, City of 1
- Santa Monica, City of 1
- Palmdale, City of 1
- Fairfield, City of 1
- Contra Costa Department of Conservation and Development, County of 1
- Norwalk, City of 1
- Bakersfield, City of 1
- Napa Valley College 1
- Irvine, City of 1
- Los Angeles - Department of Parks and Recreation, County of 1
- Friends of the Desert Mountains 1
- Paramount, City of 1
- Diamond Bar, City of 1
- West Covina, City of 1
- Agoura Hills, City of 1
- Windsor, Town of 1
- Hercules, City of 1
- La Canada Irrigation District 1
- United States Bureau of Reclamation 1
- Fremont, City of 1
- San Diego State University 1
- Livermore Area Recreation and Park District 1
- Redwood City, City of 1
- Gilroy, City of 1
- Pacifica, City of 1
- California Biological Field Studies Association 1
- Contra Costa County Public Works Dept., County of 1
- American Canyon, City of 1
- Soledad, City of 1
- Lodi, City of 1
- Sanitation Districts of Los Angeles County 1
- San Joaquin River Parkway and Conservation Trust 1
- United States Coast Guard 1
- Montecito Water District 1
- Lathrop, City of 1
- Santa Clara Valley Habitat Agency 1
- Sacramento, City of 1
- North Coast Water District 1
- Wheatland, City of 1
- South El Monte, City of 1
- Eastern Sierra Land Trust 1
- Land Trust of Santa Clara Valley 1
- Yuima Municipal Water District 1
- Kaweah Delta Water Conservation District 1
- Brisbane, City of 1
- Trinidad Coastal Land Trust 1
- Humboldt - Public Works Department, County of 1
- Calistoga, City of 1
- California State University 1
- California Reclamation District 2140 1
- Private Landowner 1
- Irvine Ranch Conservancy 1
- Forestville Park Development District 1
- Santa Clara Valley Water District 1
- Los Altos Hills, Town of 1
- Sequoia Audubon Society 1
- Anza-Borrego Foundation 1
- California State Coastal Conservancy 1
- Foss Lake Conservation LP 1
- Vallecitos Water District 1
- Coastside County Water District 1
- San Dieguito River Park Joint Powers Authority 1
- Contra Costa Water District 1
- Ag Land Trust 1
- Russian Riverkeeper 1
- California Farmland Trust 1
- Park Fort Washington Association 1
- California Rangeland Trust 1
- Solano, County of 1
- Living Landscape Initiative Partners 1
- Rainbow Municipal Water District 1
- Chevron Corporation 1
- Pasadena Department of Water and Power 1
- Otay Water District 1
- Madera Irrigation District 1
MNG_AG_TYP 20
- Non Profit - Land Trust 217
- City Agency 207
- State Agency 137
- Recreation/Parks District 106
- Flood District 58
- Water District 56
- Non Profit - Conservation 50
- Federal Agency 33
- Irrigation District 29
- County Agency 26
- Open Space District 22
- County Agency - Parks 18
- County Agency - Other 3
- Home Owners Association 1
- Commercial 1
- Sanitation District 1
- Non Profit - Other 1
- Joint Powers Authority 1
- Other 1
- Mitigation Bank 1
ACCESS_TYP 1
- No Public Access · 969 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9013 | 9013 | 9012 | {"type": "Polygon", "coordinates": [[[-118.65507, 34.12838], [-118.65499, 34.12848], [-118.65493, 34.12846], [-118.65501, 34.12835], [-118.65507, 34.12838]]]} | No Public Access 3 | 12414 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.022 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
9463 | 9463 | 9462 | {"type": "Polygon", "coordinates": [[[-118.7507, 34.16758], [-118.75065, 34.16768], [-118.75057, 34.16764], [-118.75062, 34.16755], [-118.7507, 34.16758]]]} | No Public Access 3 | 12424 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.027 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
5497 | 5497 | 5496 | {"type": "Polygon", "coordinates": [[[-118.39276, 34.11874], [-118.39267, 34.11881], [-118.3926, 34.11875], [-118.39271, 34.11867], [-118.39276, 34.11874]]]} | No Public Access 3 | 12821 | Los Angeles City Water Resource Parkland | 21477 | 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 | 0.028 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
1629 | 1629 | 1628 | {"type": "Polygon", "coordinates": [[[-118.63073, 34.13978], [-118.63062, 34.1398], [-118.63058, 34.13967], [-118.63066, 34.13966], [-118.63073, 34.13978]]]} | No Public Access 3 | 12421 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.034 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
4537 | 4537 | 4536 | {"type": "Polygon", "coordinates": [[[-117.10461, 32.76969], [-117.10445, 32.76969], [-117.10461, 32.76951], [-117.10461, 32.76969], [-117.10461, 32.76969]]]} | No Public Access 3 | 19907 | Unnamed site - San Diego, City of | 31719 | 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.035 | 0 | Local Other or Unknown 14 | 4 | ||
2539 | 2539 | 2538 | {"type": "Polygon", "coordinates": [[[-118.6218, 34.10061], [-118.62167, 34.10067], [-118.6216, 34.10059], [-118.62174, 34.10053], [-118.6218, 34.10061]]]} | No Public Access 3 | 12510 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 0.038 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
2800 | 2800 | 2799 | {"type": "Polygon", "coordinates": [[[-118.62165, 34.10163], [-118.62148, 34.10166], [-118.62143, 34.10159], [-118.62157, 34.10153], [-118.62165, 34.10163]]]} | No Public Access 3 | 12515 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 0.042 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
9404 | 9404 | 9403 | {"type": "Polygon", "coordinates": [[[-118.67423, 34.13343], [-118.67408, 34.13345], [-118.67407, 34.13332], [-118.67422, 34.13331], [-118.67423, 34.13343]]]} | No Public Access 3 | 12423 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.05 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
4092 | 4092 | 4091 | {"type": "Polygon", "coordinates": [[[-118.518, 34.05167], [-118.51753, 34.05174], [-118.51751, 34.0517], [-118.51798, 34.05163], [-118.518, 34.05167]]]} | No Public Access 3 | 47493 | Chautauqua Blvd Access to Will Rogers State Historic Preserve | 31212 | 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 | 0.053 | Chautauqua Blvd Access to Will Rogers SHPr | None 355 | |||
16958 | 16958 | 16957 | {"type": "Polygon", "coordinates": [[[-118.62162, 34.10069], [-118.62138, 34.1008], [-118.62131, 34.10072], [-118.62156, 34.10061], [-118.62162, 34.10069]]]} | No Public Access 3 | 12507 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 0.069 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
4625 | 4625 | 4624 | {"type": "Polygon", "coordinates": [[[-122.30619, 38.31262], [-122.30611, 38.31263], [-122.30598, 38.31222], [-122.30605, 38.3122], [-122.30619, 38.31262]]]} | No Public Access 3 | 36253 | Unnamed site - California Department of General Services | 28625 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | Napa 11 | 0.081 | 0 | State Other or Unknown 104 | 4 | ||
4231 | 4231 | 4230 | {"type": "Polygon", "coordinates": [[[-122.31412, 37.26649], [-122.31377, 37.26649], [-122.31369, 37.26638], [-122.31401, 37.26638], [-122.31412, 37.26649]]]} | No Public Access 3 | 29758 | Kraynick | 20724 | 3054 | Peninsula Open Space Trust 338 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.openspacetrust.org/ | Non Governmental Organization 10 | 3054 | Peninsula Open Space Trust 335 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 0.092 | Kraynick | 0 | Private Conservation 16 | 2 | |
2066 | 2066 | 2065 | {"type": "Polygon", "coordinates": [[[-118.67437, 34.13917], [-118.67424, 34.13936], [-118.67408, 34.13928], [-118.67422, 34.13909], [-118.67437, 34.13917]]]} | No Public Access 3 | 12422 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.103 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
2462 | 2462 | 2461 | {"type": "Polygon", "coordinates": [[[-118.35722, 34.10552], [-118.35702, 34.10564], [-118.35703, 34.10532], [-118.35722, 34.10533], [-118.35722, 34.10552]]]} | No Public Access 3 | 12466 | Los Angeles Department of Water and Power | 21482 | 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 | 0.129 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
4622 | 4622 | 4621 | {"type": "Polygon", "coordinates": [[[-122.57831, 38.57459], [-122.57825, 38.5747], [-122.57785, 38.57457], [-122.57792, 38.57445], [-122.57831, 38.57459]]]} | No Public Access 3 | 36169 | Unnamed site - California Department of General Services | 28625 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | Napa 11 | 0.134 | 0 | State Other or Unknown 104 | 4 | ||
9467 | 9467 | 9466 | {"type": "Polygon", "coordinates": [[[-118.79539, 34.10451], [-118.79505, 34.10457], [-118.79501, 34.10437], [-118.79516, 34.10434], [-118.79538, 34.10447], [-118.79539, 34.10451]]]} | No Public Access 3 | 12425 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.136 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
8361 | 8361 | 8360 | {"type": "MultiPolygon", "coordinates": [[[[-118.66634, 34.17078], [-118.66625, 34.17093], [-118.66609, 34.17094], [-118.66606, 34.17068], [-118.66634, 34.17078]]], [[[-118.741, 34.15444], [-118.74093, 34.15454], [-118.74084, 34.15445], [-118.74084, 34.15444], [-118.741, 34.15444]]]]} | No Public Access 3 | 12409 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.141 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
16970 | 16970 | 16969 | {"type": "Polygon", "coordinates": [[[-118.62222, 34.10346], [-118.62187, 34.10346], [-118.62175, 34.10335], [-118.62193, 34.10321], [-118.62222, 34.10346]]]} | No Public Access 3 | 12502 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 0.156 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
13528 | 13528 | 13527 | {"type": "Polygon", "coordinates": [[[-118.36681, 33.81599], [-118.36674, 33.81603], [-118.36641, 33.81553], [-118.36652, 33.81548], [-118.36669, 33.81573], [-118.36665, 33.81575], [-118.36681, 33.81599]]]} | No Public Access 3 | 35826 | Greenbelt SE Bindewald SE Calle Mayor | 29168 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.158 | Greenbelt SE Bindewald SE Calle Mayor | None 1164 | |||
1340 | 1340 | 1339 | {"type": "Polygon", "coordinates": [[[-118.38142, 34.10854], [-118.38114, 34.10871], [-118.38103, 34.10855], [-118.38131, 34.10838], [-118.38142, 34.10854]]]} | No Public Access 3 | 12809 | Los Angeles City Water Resource Parkland | 21477 | 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 | 0.163 | Los Angeles City Water Resource Parkland | 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]);