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)
DES_TP 209
- Private Conservation 210
- Local Recreation Area 106
- Local Other or Unknown 94
- Local Conservation Area 77
- Local Park 75
- State Resource Management Area 64
- Private Other or Unknown 25
- State Conservation Area 22
- Private Recreation or Education 21
- State Other or Unknown 17
- 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
MNG_AGENCY 186
- California Department of Fish and Wildlife 79
- East Bay Regional Park District 47
- Los Angeles, City of 32
- The Nature Conservancy 32
- Peninsula Open Space Trust 23
- Natomas Basin Conservancy 22
- Rivers and Lands Conservancy 22
- The Environmental Trust 21
- Las Virgenes Municipal Water District 21
- Torrance, City of 19
- Midpeninsula Regional Open Space District 19
- San Diego, City of 18
- Santa Clara Valley Open Space Authority 18
- United States Fish and Wildlife Service 16
- Mountains Restoration Trust 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
- Escondido, City of 10
- Riverside County Habitat Conservation Agency 10
- Mountains Recreation and Conservation Authority 9
- Santa Rosa, City of 9
- California Department of General Services 8
- 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 216
- City Agency 201
- State Agency 135
- Recreation/Parks District 106
- Flood District 58
- Water District 49
- Non Profit - Conservation 46
- 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 · 949 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6778 | 6778 | 6777 | {"type": "Polygon", "coordinates": [[[-122.25654, 38.2078], [-122.25633, 38.20788], [-122.2563, 38.20749], [-122.2564, 38.20753], [-122.25652, 38.20754], [-122.25654, 38.2078]]]} | No Public Access 3 | 5258 | Dept Of Transportation/Paul Kenny | 18103 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | Napa 11 | 0.163 | Dept Of Transportation/Paul Kenny | None 551 | |||
12482 | 12482 | 12481 | {"type": "Polygon", "coordinates": [[[-117.99345, 34.51866], [-117.9926, 34.51867], [-117.9926, 34.51859], [-117.99345, 34.51858], [-117.99345, 34.51866]]]} | No Public Access 3 | 12451 | Littlerock Creek Irrigation District Open Space | 21360 | 2061 | Littlerock Creek Irrigation District 659 | Special District 4 | Irrigation District 17 | http://www.lrcid.com/ | Special District 4 | 2061 | Littlerock Creek Irrigation District 646 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 0.173 | Littlerock Creek Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
1138 | 1138 | 1137 | {"type": "Polygon", "coordinates": [[[-118.17117, 33.79377], [-118.1707, 33.79377], [-118.1707, 33.79348], [-118.17072, 33.79348], [-118.17117, 33.79377]]]} | No Public Access 3 | 6684 | Chittick Field | 29944 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.181 | Chittick Field | 2014 | Local Recreation Area 3 | 4 | |
12774 | 12774 | 12773 | {"type": "Polygon", "coordinates": [[[-118.36219, 33.85184], [-118.36169, 33.85181], [-118.36169, 33.85167], [-118.36213, 33.85167], [-118.36219, 33.85184]]]} | No Public Access 3 | 35837 | Entradero Swale 4 | 29148 | 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.181 | Entradero Swale 4 | None 1121 | |||
8153 | 8153 | 8152 | {"type": "Polygon", "coordinates": [[[-118.08451, 34.18147], [-118.08446, 34.18154], [-118.08433, 34.18161], [-118.08405, 34.18134], [-118.08424, 34.18129], [-118.08446, 34.18139], [-118.08451, 34.18147]]]} | No Public Access 3 | 12344 | Kinneloa Irrigation District Open Space | 20674 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 0.194 | Kinneloa Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
4536 | 4536 | 4535 | {"type": "Polygon", "coordinates": [[[-117.1276, 32.76738], [-117.12717, 32.76784], [-117.12705, 32.76778], [-117.12742, 32.76738], [-117.1276, 32.76738]]]} | No Public Access 3 | 19905 | 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.196 | 0 | Local Other or Unknown 14 | 4 | ||
9003 | 9003 | 9002 | {"type": "Polygon", "coordinates": [[[-117.98817, 34.54292], [-117.98816, 34.54299], [-117.98697, 34.54299], [-117.98701, 34.54293], [-117.98817, 34.54292]]]} | No Public Access 3 | 12439 | Littlerock Creek Irrigation District Open Space | 21360 | 2061 | Littlerock Creek Irrigation District 659 | Special District 4 | Irrigation District 17 | http://www.lrcid.com/ | Special District 4 | 2061 | Littlerock Creek Irrigation District 646 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 0.2 | Littlerock Creek Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
25 | 25 | 24 | {"type": "Polygon", "coordinates": [[[-122.27747, 38.29885], [-122.27706, 38.29891], [-122.27702, 38.29871], [-122.27743, 38.29865], [-122.27747, 38.29885]]]} | No Public Access 3 | 64 | Real Estate Services Division | 24211 | 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.203 | Real Estate Services Division | None 6 | |||
12271 | 12271 | 12270 | {"type": "Polygon", "coordinates": [[[-118.2914, 33.95801], [-118.2914, 33.95822], [-118.291, 33.95822], [-118.29101, 33.95801], [-118.2914, 33.95801]]]} | No Public Access 3 | 46878 | Community Build Youth Center Expansion | 30356 | 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.207 | Community Build Youth Ctr. Expansion | None 1070 | |||
7312 | 7312 | 7311 | {"type": "Polygon", "coordinates": [[[-122.27901, 38.29895], [-122.27868, 38.299], [-122.27861, 38.29876], [-122.27894, 38.2987], [-122.27901, 38.29895]]]} | No Public Access 3 | 6623 | 575 Third St | 15206 | 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.21 | 575 Third St | None 604 | |||
16957 | 16957 | 16956 | {"type": "Polygon", "coordinates": [[[-118.77416, 34.04757], [-118.77403, 34.04762], [-118.77363, 34.04741], [-118.7737, 34.04729], [-118.77414, 34.04746], [-118.77416, 34.04757]]]} | No Public Access 3 | 12504 | 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.213 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
7447 | 7447 | 7446 | {"type": "MultiPolygon", "coordinates": [[[[-118.22877, 34.08683], [-118.22866, 34.08675], [-118.22875, 34.08668], [-118.22875, 34.08668], [-118.22877, 34.08683]]], [[[-118.22915, 34.08683], [-118.22891, 34.08704], [-118.22889, 34.08693], [-118.22882, 34.08688], [-118.22879, 34.08664], [-118.22885, 34.08659], [-118.22915, 34.08683]]]]} | No Public Access 3 | 6921 | Steelhead Park | 25823 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.219 | Steelhead Park | 0 | Local Park 2 | 4 | |
8209 | 8209 | 8208 | {"type": "Polygon", "coordinates": [[[-118.34266, 34.12073], [-118.34239, 34.12092], [-118.34236, 34.12088], [-118.34217, 34.12072], [-118.3424, 34.12055], [-118.34256, 34.12064], [-118.34266, 34.12073]]]} | No Public Access 3 | 12464 | 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.23 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
4749 | 4749 | 4748 | {"type": "Polygon", "coordinates": [[[-118.25828, 33.88611], [-118.25795, 33.88612], [-118.25789, 33.88584], [-118.25805, 33.88581], [-118.25821, 33.88581], [-118.25828, 33.88611]]]} | No Public Access 3 | 46441 | Unnamed site - Carson, City of | 29713 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 1400 | Los Angeles - Department of Water and Power, City of 278 | City 2 | City Agency 2 | Los Angeles 6 | 0.248 | 0 | Local Other or Unknown 14 | 4 | ||
8207 | 8207 | 8206 | {"type": "Polygon", "coordinates": [[[-118.34724, 34.11998], [-118.34703, 34.11998], [-118.34699, 34.11995], [-118.34697, 34.11996], [-118.34677, 34.11971], [-118.34724, 34.1197], [-118.34724, 34.11998]]]} | No Public Access 3 | 12461 | 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.25 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
3427 | 3427 | 3426 | {"type": "Polygon", "coordinates": [[[-122.01238, 36.97053], [-122.01187, 36.97081], [-122.01185, 36.97079], [-122.01191, 36.97056], [-122.01223, 36.97036], [-122.01238, 36.97053]]]} | No Public Access 3 | 25174 | South Branciforte | 32313 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Santa Cruz 5 | 0.251 | South Branciforte | 0 | State Resource Management Area 55 | 3 | |
2461 | 2461 | 2460 | {"type": "Polygon", "coordinates": [[[-118.34315, 34.12036], [-118.34289, 34.12054], [-118.34274, 34.1204], [-118.34265, 34.12036], [-118.34296, 34.12013], [-118.34315, 34.12036]]]} | No Public Access 3 | 12465 | 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.255 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
5505 | 5505 | 5504 | {"type": "MultiPolygon", "coordinates": [[[[-118.66773, 34.17325], [-118.66736, 34.17323], [-118.66731, 34.17311], [-118.66769, 34.17301], [-118.66773, 34.17316], [-118.66773, 34.17325]]], [[[-118.70599, 34.16395], [-118.70581, 34.16401], [-118.70578, 34.16393], [-118.70589, 34.16376], [-118.70595, 34.16381], [-118.70594, 34.16384], [-118.70599, 34.16395]]]]} | No Public Access 3 | 12408 | 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.26 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
15805 | 15805 | 15804 | {"type": "Polygon", "coordinates": [[[-118.77383, 34.04565], [-118.77371, 34.04579], [-118.77369, 34.04597], [-118.77341, 34.04599], [-118.77339, 34.04567], [-118.77383, 34.04565]]]} | No Public Access 3 | 12523 | 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.266 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
4535 | 4535 | 4534 | {"type": "Polygon", "coordinates": [[[-117.23982, 32.87111], [-117.23981, 32.87152], [-117.23927, 32.87152], [-117.23951, 32.87136], [-117.23982, 32.87111]]]} | No Public Access 3 | 19896 | 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.273 | 0 | Local Other or Unknown 14 | 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]);