units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
969 rows where ACCESS_TYP = 3
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- California Department of Fish and Wildlife 74
- East Bay Regional Park District 47
- The Nature Conservancy 31
- Los Angeles, City of 28
- Las Virgenes Municipal Water District 27
- Peninsula Open Space Trust 22
- Natomas Basin Conservancy 22
- Rivers and Lands Conservancy 22
- Torrance, City of 20
- The Environmental Trust 20
- Mountains Restoration Trust 20
- Midpeninsula Regional Open Space District 19
- San Diego, City of 18
- Santa Clara Valley Open Space Authority 18
- Fresno Metropolitan Flood Control District 16
- United States Fish and Wildlife Service 15
- California Department of Parks and Recreation 15
- Endangered Habitats Conservancy 13
- San Diego, County of 13
- Santa Clara County Parks and Recreation Dept., County of 13
- American River Conservancy 13
- Save Mount Diablo 13
- Littlerock Creek Irrigation District 13
- Los Angeles County Flood Control District 12
- Kinneloa Irrigation District 12
- Napa, City of 12
- California Department of Water Resources 11
- Sonoma Land Trust 10
- Sonoma County Agricultural Preservation and Open Space District 10
- Riverside County Habitat Conservation Agency 10
- …
DES_TP >30
- Private Conservation 201
- Local Recreation Area 108
- Local Other or Unknown 87
- Local Conservation Area 75
- Local Park 71
- State Resource Management Area 60
- Private Recreation or Education 25
- Private Other or Unknown 25
- State Conservation Area 19
- State Other or Unknown 19
- National Wildlife Refuge 14
- Local Resource Management Area 7
- State Park 5
- Private Agricultural 5
- Federal Other or Unknown 3
- State Historic or Cultural Area 3
- National Public Lands 2
- Conservation Area 2
- National Monument or Landmark 2
- Resource Management Area 2
- State Recreation Area 1
- Recreation Management Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 20
- Non Profit - Land Trust 209
- City Agency 187
- State Agency 127
- Recreation/Parks District 105
- Flood District 57
- Water District 55
- Non Profit - Conservation 48
- Federal Agency 29
- Irrigation District 27
- County Agency 24
- Open Space District 22
- County Agency - Parks 18
- County Agency - Other 2
- 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 · 917 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1702 | 1702 | 1701 | {"type": "MultiPolygon", "coordinates": [[[[-118.10957, 33.99118], [-118.10841, 33.99393], [-118.10812, 33.99414], [-118.10776, 33.99428], [-118.10723, 33.99468], [-118.1056, 33.99616], [-118.1049, 33.99713], [-118.10463, 33.99726], [-118.10446, 33.99744], [-118.10439, 33.99781], [-118.104, 33.99834], [-118.10373, 33.99899], [-118.1034, 33.99955], [-118.09727, 34.00134], [-118.09715, 34.00171], [-118.09154, 33.99932], [-118.09273, 33.99735], [-118.09448, 33.99594], [-118.09703, 33.99726], [-118.09734, 33.99688], [-118.09773, 33.99673], [-118.09793, 33.99653], [-118.10047, 33.99561], [-118.10232, 33.9928], [-118.10204, 33.99241], [-118.10691, 33.99146], [-118.10957, 33.99118]]], [[[-118.10991, 33.9911], [-118.1069, 33.99141], [-118.102, 33.99238], [-118.10139, 33.99156], [-118.10665, 33.98858], [-118.10706, 33.9888], [-118.10745, 33.98908], [-118.10935, 33.99074], [-118.10962, 33.99093], [-118.10991, 33.9911]]]]} | No Public Access 3 | 6693 | Rio Hondo & Bike Trail | 24380 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 234.812 | Rio Hondo & Bike Trail | 0 | Local Recreation Area 3 | 4 | |
1708 | 1708 | 1707 | {"type": "Polygon", "coordinates": [[[-117.93744, 33.98131], [-117.93677, 33.98161], [-117.93629, 33.98086], [-117.93696, 33.98056], [-117.93744, 33.98131]]]} | No Public Access 3 | 6551 | Roland Area County Water District Land | 24569 | 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 | 1.632 | Roland Area County Water District Land | None 136 | |||
1709 | 1709 | 1708 | {"type": "Polygon", "coordinates": [[[-117.75671, 34.13628], [-117.7567, 34.1363], [-117.75036, 34.13633], [-117.75034, 34.13665], [-117.75035, 34.13666], [-117.75656, 34.13663], [-117.75559, 34.13883], [-117.75547, 34.13901], [-117.75533, 34.13918], [-117.75515, 34.13932], [-117.75367, 34.14035], [-117.75356, 34.14041], [-117.75326, 34.14053], [-117.75215, 34.14084], [-117.75214, 34.14092], [-117.75193, 34.14107], [-117.75169, 34.1413], [-117.75165, 34.14129], [-117.75133, 34.14113], [-117.75127, 34.14107], [-117.75121, 34.14102], [-117.7511, 34.141], [-117.7511, 34.14067], [-117.75024, 34.14008], [-117.75024, 34.13986], [-117.74992, 34.13986], [-117.74843, 34.13883], [-117.74818, 34.13785], [-117.7485, 34.13662], [-117.75064, 34.13454], [-117.75064, 34.13451], [-117.75208, 34.13314], [-117.75433, 34.13264], [-117.75616, 34.13503], [-117.75671, 34.13628]]]} | No Public Access 3 | 12846 | Live Oak Reservoir | 21375 | 2078 | Metropolitan Water District of Southern California 413 | Special District 4 | Water District 13 | http://www.mwdh2o.com/ | Special District 4 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 112.516 | Live Oak Reservoir | 0 | Local Recreation Area 3 | 4 | |
1753 | 1753 | 1752 | {"type": "Polygon", "coordinates": [[[-122.49925, 38.63647], [-122.49421, 38.63642], [-122.49417, 38.63271], [-122.48533, 38.63279], [-122.48527, 38.62564], [-122.47606, 38.62561], [-122.4761, 38.62202], [-122.48526, 38.62206], [-122.48527, 38.62563], [-122.48765, 38.62558], [-122.48985, 38.62546], [-122.49439, 38.62527], [-122.49434, 38.62156], [-122.49886, 38.62131], [-122.49897, 38.62494], [-122.49908, 38.62919], [-122.49915, 38.63266], [-122.49925, 38.63647]]]} | No Public Access 3 | 13101 | Cleary Reserve | 17417 | 3011 | California Biological Field Studies Association 420 | Non Profit 6 | Non Profit - Conservation 12 | Non Governmental Organization 10 | 3011 | California Biological Field Studies Association 414 | Non Profit 6 | Non Profit - Conservation 12 | Napa 11 | 406.373 | Cleary Reserve | 0 | Private Conservation 16 | 2 | ||
1759 | 1759 | 1758 | {"type": "Polygon", "coordinates": [[[-117.93234, 33.9866], [-117.93168, 33.98689], [-117.93158, 33.98688], [-117.93166, 33.98615], [-117.93219, 33.9861], [-117.93223, 33.98635], [-117.93234, 33.9866]]]} | No Public Access 3 | 6552 | Roland Area County Water District Land | 24569 | 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 | 1.052 | Roland Area County Water District Land | None 137 | |||
1760 | 1760 | 1759 | {"type": "Polygon", "coordinates": [[[-117.91753, 33.96603], [-117.91639, 33.96877], [-117.91516, 33.96861], [-117.91523, 33.96842], [-117.91541, 33.96808], [-117.91555, 33.96763], [-117.91605, 33.96696], [-117.91648, 33.9667], [-117.91691, 33.96636], [-117.91753, 33.96603]]]} | No Public Access 3 | 6553 | Roland Area County Water District Land | 24569 | 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 | 6.905 | Roland Area County Water District Land | None 138 | |||
1761 | 1761 | 1760 | {"type": "Polygon", "coordinates": [[[-117.92305, 33.97679], [-117.92297, 33.97736], [-117.92178, 33.97689], [-117.92181, 33.97667], [-117.92244, 33.97672], [-117.92249, 33.97669], [-117.92258, 33.97673], [-117.92265, 33.97671], [-117.92276, 33.97676], [-117.92305, 33.97679]]]} | No Public Access 3 | 6554 | Roland Area County Water District Land | 24569 | 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 | 1.271 | Roland Area County Water District Land | None 139 | |||
1762 | 1762 | 1761 | {"type": "Polygon", "coordinates": [[[-117.90135, 33.9591], [-117.90114, 33.95933], [-117.90097, 33.95918], [-117.90029, 33.95921], [-117.90038, 33.95914], [-117.90053, 33.95907], [-117.89969, 33.95857], [-117.89885, 33.95773], [-117.89826, 33.95783], [-117.89766, 33.95753], [-117.89771, 33.95684], [-117.89761, 33.9564], [-117.89643, 33.95562], [-117.89634, 33.95554], [-117.89624, 33.95542], [-117.89618, 33.95531], [-117.89616, 33.9552], [-117.89626, 33.95518], [-117.89661, 33.95555], [-117.89745, 33.95579], [-117.89819, 33.95616], [-117.89868, 33.95697], [-117.89953, 33.95806], [-117.90094, 33.959], [-117.90126, 33.95894], [-117.90135, 33.9591]]]} | No Public Access 3 | 6555 | Roland Area County Water District Land | 24569 | 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 | 7.601 | Roland Area County Water District Land | None 140 | |||
1949 | 1949 | 1948 | {"type": "Polygon", "coordinates": [[[-119.3411, 35.24915], [-119.33804, 35.25071], [-119.33274, 35.25344], [-119.32347, 35.25337], [-119.32342, 35.24243], [-119.33225, 35.24252], [-119.3322, 35.23881], [-119.34107, 35.23889], [-119.3411, 35.24915]]]} | No Public Access 3 | 16653 | Elk Hills | 32158 | 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 | Kern 36 | 517.552 | Elk Hills | 0 | State Resource Management Area 55 | 3 | |
1956 | 1956 | 1955 | {"type": "Polygon", "coordinates": [[[-117.8303, 35.57191], [-117.83026, 35.57926], [-117.82582, 35.57925], [-117.82581, 35.58284], [-117.82577, 35.58649], [-117.82128, 35.58644], [-117.82132, 35.58281], [-117.82141, 35.57924], [-117.82581, 35.57924], [-117.82587, 35.57561], [-117.82586, 35.5756], [-117.82143, 35.57557], [-117.82145, 35.57191], [-117.8303, 35.57191]]]} | No Public Access 3 | 16665 | Indian Wells Valley | 32190 | 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 | Kern 36 | 201.555 | Indian Wells Valley | 0 | State Resource Management Area 55 | 3 | |
1979 | 1979 | 1978 | {"type": "Polygon", "coordinates": [[[-121.70451, 36.82285], [-121.70093, 36.8239], [-121.69807, 36.82554], [-121.69697, 36.82531], [-121.69577, 36.82573], [-121.69365, 36.82737], [-121.69189, 36.82775], [-121.68673, 36.82948], [-121.6852, 36.83049], [-121.68253, 36.83133], [-121.68196, 36.83058], [-121.68169, 36.82951], [-121.68138, 36.82887], [-121.68016, 36.82835], [-121.67991, 36.82691], [-121.67861, 36.8239], [-121.67901, 36.82359], [-121.67927, 36.82261], [-121.68059, 36.82235], [-121.67966, 36.82096], [-121.6798, 36.82083], [-121.68079, 36.82232], [-121.69006, 36.82054], [-121.70297, 36.81805], [-121.70451, 36.82285]]]} | No Public Access 3 | 15151 | Elkhorn Slough / Long Valley - ESF | 18577 | 3019 | Elkhorn Slough Foundation 464 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.elkhornslough.org | Non Governmental Organization 10 | 3019 | Elkhorn Slough Foundation 457 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 428.023 | Elkhorn Slough / Long Valley - ESF | 0 | Private Conservation 16 | 2 | |
2014 | 2014 | 2013 | {"type": "MultiPolygon", "coordinates": [[[[-118.65797, 34.15108], [-118.65776, 34.15113], [-118.65762, 34.15114], [-118.65756, 34.15098], [-118.65791, 34.15089], [-118.65797, 34.15108]]], [[[-118.65916, 34.15322], [-118.65899, 34.15369], [-118.65869, 34.15384], [-118.65822, 34.15383], [-118.65821, 34.15311], [-118.6587, 34.15288], [-118.65916, 34.15322]]]]} | No Public Access 3 | 12419 | 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 | 1.898 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
2063 | 2063 | 2062 | {"type": "Polygon", "coordinates": [[[-121.72757, 37.22352], [-121.71451, 37.23235], [-121.71451, 37.23236], [-121.7172, 37.23464], [-121.70907, 37.23466], [-121.70896, 37.22768], [-121.68349, 37.20613], [-121.66781, 37.20618], [-121.67335, 37.20336], [-121.6791, 37.20242], [-121.67911, 37.20067], [-121.69238, 37.20067], [-121.70295, 37.20346], [-121.70715, 37.20748], [-121.71486, 37.20753], [-121.71586, 37.20847], [-121.71755, 37.20724], [-121.71888, 37.2083], [-121.72001, 37.20859], [-121.72022, 37.20878], [-121.71982, 37.20964], [-121.71971, 37.21025], [-121.71956, 37.2107], [-121.71982, 37.21106], [-121.71977, 37.21154], [-121.71979, 37.21168], [-121.71983, 37.21181], [-121.7199, 37.21193], [-121.71999, 37.21205], [-121.72039, 37.21246], [-121.72062, 37.21273], [-121.72078, 37.21297], [-121.72108, 37.21354], [-121.72124, 37.21377], [-121.72235, 37.2151], [-121.72259, 37.21534], [-121.72293, 37.21561], [-121.7233, 37.21586], [-121.72358, 37.216], [-121.72322, 37.21628], [-121.72303, 37.21652], [-121.72234, 37.21764], [-121.72235, 37.21797], [-121.72757, 37.22352]]]} | No Public Access 3 | 47761 | Coyote Ridge Open Space Preserve | 31566 | 2142 | Santa Clara Valley Open Space Authority 475 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Special District 4 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Santa Clara 19 | 1829.785 | Coyote Ridge OSP | 2015 | Local Conservation Area 4 | 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 | |
2095 | 2095 | 2094 | {"type": "Polygon", "coordinates": [[[-121.70681, 38.27679], [-121.69559, 38.279], [-121.69594, 38.27864], [-121.69605, 38.27822], [-121.69594, 38.27776], [-121.69591, 38.27776], [-121.69526, 38.27319], [-121.69496, 38.27168], [-121.6945, 38.26631], [-121.69503, 38.266], [-121.69541, 38.26585], [-121.69632, 38.26585], [-121.69693, 38.26661], [-121.69714, 38.2671], [-121.69799, 38.2678], [-121.69895, 38.26831], [-121.69965, 38.26846], [-121.69988, 38.26865], [-121.70056, 38.26926], [-121.70453, 38.27349], [-121.70503, 38.27408], [-121.70574, 38.27512], [-121.70586, 38.27551], [-121.70622, 38.27614], [-121.70681, 38.27679]]]} | No Public Access 3 | 15834 | DWR Mitigation | 18327 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | Solano 26 | 213.26 | DWR Mitigation | 0 | State Other or Unknown 104 | 4 | |
2231 | 2231 | 2230 | {"type": "Polygon", "coordinates": [[[-122.61347, 38.57103], [-122.60977, 38.57104], [-122.60939, 38.57019], [-122.60879, 38.56687], [-122.61337, 38.56677], [-122.61347, 38.57103]]]} | No Public Access 3 | 47877 | Willer Donation | 31822 | 3035 | Land Trust of Napa County 140 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.napalandtrust.org/ | Non Governmental Organization 10 | 3035 | Land Trust of Napa County 137 | Non Profit 6 | Non Profit - Land Trust 10 | Napa 11 | 42.637 | Willer Donation | 2010 | Private Conservation 16 | 2 | |
2234 | 2234 | 2233 | {"type": "Polygon", "coordinates": [[[-122.29825, 38.2744], [-122.29823, 38.27446], [-122.29817, 38.2745], [-122.29809, 38.27452], [-122.29236, 38.27449], [-122.29235, 38.2745], [-122.29237, 38.27463], [-122.28394, 38.27458], [-122.2846, 38.27391], [-122.2848, 38.27382], [-122.28533, 38.27354], [-122.28611, 38.27308], [-122.28657, 38.27278], [-122.28722, 38.27197], [-122.28745, 38.27119], [-122.28741, 38.27072], [-122.28736, 38.27048], [-122.28684, 38.26916], [-122.28654, 38.26744], [-122.29799, 38.26741], [-122.29799, 38.26749], [-122.29805, 38.2675], [-122.29798, 38.26871], [-122.29796, 38.27054], [-122.29799, 38.27137], [-122.29805, 38.27227], [-122.29825, 38.2744]]]} | No Public Access 3 | 16671 | Ghisleta - South Wetlands | 19283 | 311 | Napa, County of 498 | County 3 | County Agency 3 | http://www.napaoutdoors.org/ | County 3 | 311 | Napa, County of 489 | County 3 | County Agency 3 | Napa 11 | 196.863 | Ghisleta - South Wetlands | 0 | Local Conservation Area 4 | 2 | |
2236 | 2236 | 2235 | {"type": "Polygon", "coordinates": [[[-118.34876, 33.79283], [-118.34853, 33.79307], [-118.3421, 33.78766], [-118.34362, 33.78659], [-118.34783, 33.79015], [-118.34783, 33.79205], [-118.34876, 33.79283]]]} | No Public Access 3 | 5918 | South Coast Park/former Palos Verdes Landfill site | 29032 | 2139 | Sanitation Districts of Los Angeles County 290 | Special District 4 | Sanitation District 18 | http://www.lacsd.org/ | Special District 4 | 2139 | Sanitation Districts of Los Angeles County 490 | Special District 4 | Sanitation District 19 | http://www.lacsd.org/solidwaste/swfacilities/landfills/palos_verdes/ | Los Angeles 6 | 30.5 | South Coast Park/former Palos Verdes Landfill site | None 184 | ||
2280 | 2280 | 2279 | {"type": "Polygon", "coordinates": [[[-120.79412, 35.2179], [-120.78887, 35.21784], [-120.7889, 35.21415], [-120.79407, 35.21418], [-120.79412, 35.2179]]]} | No Public Access 3 | 16850 | Hibberd | 19893 | 3032 | Land Conservancy of San Luis Obispo County 506 | Non Profit 6 | Non Profit - Land Trust 10 | http://lcslo.org/ | Non Governmental Organization 10 | 3032 | Land Conservancy of San Luis Obispo County 498 | Non Profit 6 | Non Profit - Land Trust 10 | San Luis Obispo 1 | 48.246 | Hibberd | 0 | Private Conservation 16 | 2 | |
2283 | 2283 | 2282 | {"type": "Polygon", "coordinates": [[[-121.96736, 38.30157], [-121.96735, 38.30183], [-121.96664, 38.30199], [-121.96611, 38.30257], [-121.96381, 38.307], [-121.96352, 38.30736], [-121.96535, 38.3109], [-121.96492, 38.31134], [-121.96492, 38.31136], [-121.96449, 38.31183], [-121.96352, 38.31397], [-121.96367, 38.31471], [-121.96344, 38.31549], [-121.96158, 38.31549], [-121.95215, 38.31541], [-121.95186, 38.31079], [-121.95186, 38.31055], [-121.95185, 38.31054], [-121.95137, 38.30158], [-121.96736, 38.30157]]]} | No Public Access 3 | 18229 | Noonan Reservoir | 22785 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 428.883 | Noonan Reservoir | 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]);