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
- East Bay Regional Park District 39
- California Department of Fish and Wildlife 18
- Natomas Basin Conservancy 16
- The Nature Conservancy 15
- Torrance, City of 15
- Fresno Metropolitan Flood Control District 15
- United States Fish and Wildlife Service 13
- Midpeninsula Regional Open Space District 13
- Mountains Restoration Trust 11
- Save Mount Diablo 11
- Santa Clara Valley Open Space Authority 10
- Endangered Habitats Conservancy 8
- California Department of Parks and Recreation 7
- Peninsula Open Space Trust 7
- Santa Clara County Parks and Recreation Dept., County of 7
- Rocklin, City of 7
- Littlerock Creek Irrigation District 7
- San Diego, County of 5
- Riverside County Habitat Conservation Agency 5
- California Department of Water Resources 4
- Center for Natural Lands Management 3
- Napa County Regional Park and Open Space District 3
- Land Trust of Santa Cruz County 3
- Marin Audubon Society 3
- Las Virgenes Municipal Water District 3
- Napa, City of 3
- United States Bureau of Land Management 2
- San Diego, City of 2
- Los Angeles, County of 2
- Mountains Recreation and Conservation Authority 2
- …
DES_TP >30
- Private Conservation 64
- Local Conservation Area 42
- Local Recreation Area 38
- Local Park 30
- Local Other or Unknown 20
- State Resource Management Area 15
- Private Recreation or Education 13
- National Wildlife Refuge 11
- State Conservation Area 7
- Local Resource Management Area 5
- State Other or Unknown 3
- Private Other or Unknown 3
- Conservation Area 2
- State Park 2
- National Monument or Landmark 2
- State Historic or Cultural Area 2
- Private Agricultural 2
- National Public Lands 1
- State Recreation Area 1
- Recreation Management Area 1
- Resource Management Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 15
- Recreation/Parks District 66
- City Agency 55
- Non Profit - Land Trust 54
- State Agency 35
- Flood District 35
- Non Profit - Conservation 27
- Federal Agency 19
- County Agency 9
- Water District 9
- Irrigation District 9
- Open Space District 8
- County Agency - Parks 7
- County Agency - Other 1
- Home Owners Association 1
- Commercial 1
ACCESS_TYP 1
- No Public Access · 336 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11539 | 11539 | 11538 | {"type": "Polygon", "coordinates": [[[-116.89741, 32.80669], [-116.89677, 32.80745], [-116.89737, 32.80782], [-116.89656, 32.80874], [-116.8966, 32.80905], [-116.89615, 32.80913], [-116.89571, 32.80924], [-116.89504, 32.80952], [-116.894, 32.80809], [-116.89443, 32.80579], [-116.89458, 32.80576], [-116.89741, 32.80669]]]} | No Public Access 3 | 46831 | Sarjay/La Cresta Property | 30299 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 21.548 | Sarjay/La Cresta Property | 0 | Private Conservation 16 | 2 | |
11540 | 11540 | 11539 | {"type": "Polygon", "coordinates": [[[-116.88944, 32.80854], [-116.88892, 32.80921], [-116.88842, 32.809], [-116.8881, 32.80881], [-116.88819, 32.80758], [-116.88937, 32.8079], [-116.88944, 32.80854]]]} | No Public Access 3 | 46832 | Saxena/La Cresta Property | 30300 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 4.044 | Saxena/La Cresta Property | 0 | Private Conservation 16 | 2 | |
11541 | 11541 | 11540 | {"type": "Polygon", "coordinates": [[[-116.88975, 32.80209], [-116.88488, 32.80571], [-116.88212, 32.80795], [-116.88059, 32.80794], [-116.88059, 32.80435], [-116.88489, 32.80431], [-116.88492, 32.80091], [-116.87626, 32.80088], [-116.87625, 32.79348], [-116.8719, 32.79355], [-116.87185, 32.7905], [-116.86734, 32.79039], [-116.86564, 32.79011], [-116.86281, 32.79004], [-116.86273, 32.78651], [-116.85814, 32.78609], [-116.8582, 32.78275], [-116.86725, 32.78347], [-116.86725, 32.78691], [-116.87625, 32.78778], [-116.8847, 32.78775], [-116.88471, 32.78835], [-116.88466, 32.80066], [-116.88467, 32.80066], [-116.88552, 32.79991], [-116.88576, 32.79977], [-116.88578, 32.79976], [-116.88582, 32.79981], [-116.88587, 32.79984], [-116.88598, 32.79984], [-116.88607, 32.79978], [-116.88609, 32.79973], [-116.88609, 32.79967], [-116.88613, 32.79963], [-116.88632, 32.79956], [-116.88653, 32.79952], [-116.88688, 32.79951], [-116.88723, 32.79957], [-116.88744, 32.79964], [-116.88765, 32.79975], [-116.88855, 32.80046], [-116.88872, 32.80056], [-116.8889, 32.80061], [-116.88896, 32.80068], [-116.88895, 32.80074], [-116.88882, 32.80092], [-116.88881, 32.801], [-116.88883, 32.80115], [-116.88889, 32.80129], [-116.88902, 32.80148], [-116.88925, 32.80165], [-116.88975, 32.80209]]]} | No Public Access 3 | 46833 | South Crest Properties | 30301 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 586.423 | South Crest Properties | 0 | Private Conservation 16 | 2 | |
11544 | 11544 | 11543 | {"type": "Polygon", "coordinates": [[[-117.19588, 33.05838], [-117.19584, 33.06309], [-117.19526, 33.06178], [-117.19482, 33.0613], [-117.19421, 33.06309], [-117.1936, 33.06368], [-117.19386, 33.06453], [-117.19343, 33.06485], [-117.19359, 33.06456], [-117.19334, 33.06393], [-117.19279, 33.06361], [-117.19236, 33.06362], [-117.19211, 33.06312], [-117.19045, 33.06383], [-117.18724, 33.06429], [-117.18724, 33.06097], [-117.19095, 33.0591], [-117.19135, 33.05875], [-117.19134, 33.05841], [-117.19588, 33.05838]]]} | No Public Access 3 | 46822 | Bridges Property | 30290 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 96.326 | Bridges Property | 0 | Private Conservation 16 | 2 | |
11545 | 11545 | 11544 | {"type": "Polygon", "coordinates": [[[-116.83922, 32.83545], [-116.83782, 32.83791], [-116.83786, 32.83795], [-116.83772, 32.83808], [-116.83739, 32.83845], [-116.83729, 32.83853], [-116.83713, 32.8386], [-116.83711, 32.83786], [-116.83671, 32.83746], [-116.82396, 32.83749], [-116.82414, 32.83012], [-116.83656, 32.83029], [-116.83668, 32.83206], [-116.83671, 32.83431], [-116.83922, 32.83545]]]} | No Public Access 3 | 46823 | Gibson Property | 30291 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 251.399 | Gibson Property | 0 | Private Conservation 16 | 2 | |
11546 | 11546 | 11545 | {"type": "Polygon", "coordinates": [[[-116.89021, 32.80935], [-116.89021, 32.80935], [-116.88892, 32.80921], [-116.88944, 32.80854], [-116.89012, 32.80849], [-116.89021, 32.80935]]]} | No Public Access 3 | 46824 | Guyot/La Cresta Property | 30292 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 1.954 | Guyot/La Cresta Property | 0 | Private Conservation 16 | 2 | |
11547 | 11547 | 11546 | {"type": "Polygon", "coordinates": [[[-116.90449, 32.86918], [-116.90258, 32.86929], [-116.90321, 32.8702], [-116.90357, 32.87149], [-116.90313, 32.87153], [-116.90277, 32.87162], [-116.90228, 32.87168], [-116.89941, 32.871], [-116.89778, 32.87065], [-116.89597, 32.87065], [-116.89596, 32.86588], [-116.89775, 32.86452], [-116.89789, 32.8644], [-116.89813, 32.86414], [-116.89845, 32.86372], [-116.89896, 32.86285], [-116.90128, 32.86311], [-116.90141, 32.86392], [-116.90299, 32.86415], [-116.90314, 32.86538], [-116.90379, 32.8653], [-116.90449, 32.86918]]]} | No Public Access 3 | 46825 | Hanson Property | 30293 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 141.528 | Hanson Property | 0 | Private Conservation 16 | 2 | |
11550 | 11550 | 11549 | {"type": "Polygon", "coordinates": [[[-122.15107, 37.66265], [-122.14971, 37.66346], [-122.14945, 37.66398], [-122.1474, 37.66495], [-122.14554, 37.66547], [-122.14345, 37.66316], [-122.139, 37.65856], [-122.13938, 37.65851], [-122.13948, 37.6586], [-122.13969, 37.65847], [-122.14042, 37.65838], [-122.14166, 37.65981], [-122.14167, 37.65974], [-122.14402, 37.65974], [-122.14683, 37.65976], [-122.15107, 37.66265]]]} | No Public Access 3 | 23596 | San Francisco Bay | 32293 | 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 | Alameda 17 | 87.824 | San Francisco Bay | 1980 | State Resource Management Area 55 | 3 | |
11551 | 11551 | 11550 | {"type": "MultiPolygon", "coordinates": [[[[-120.48135, 37.664], [-120.48132, 37.6642], [-120.48125, 37.66437], [-120.4811, 37.66452], [-120.48045, 37.66487], [-120.48026, 37.66491], [-120.48014, 37.66503], [-120.48008, 37.66532], [-120.48024, 37.66591], [-120.48028, 37.66614], [-120.4798, 37.66635], [-120.47901, 37.66496], [-120.4796, 37.66459], [-120.48005, 37.664], [-120.48135, 37.664]]], [[[-120.4855, 37.66112], [-120.48408, 37.66265], [-120.48188, 37.66423], [-120.48187, 37.66342], [-120.48365, 37.66179], [-120.48456, 37.66139], [-120.4855, 37.66112]]], [[[-120.49114, 37.6524], [-120.49083, 37.65283], [-120.48841, 37.65436], [-120.48773, 37.65488], [-120.48736, 37.65553], [-120.48638, 37.65828], [-120.48687, 37.65881], [-120.48684, 37.65947], [-120.48661, 37.65996], [-120.48558, 37.66106], [-120.48505, 37.66093], [-120.48574, 37.65927], [-120.48583, 37.65912], [-120.48578, 37.65798], [-120.48685, 37.65542], [-120.48765, 37.65458], [-120.48824, 37.6535], [-120.48889, 37.65314], [-120.48929, 37.65245], [-120.49114, 37.6524]]]]} | No Public Access 3 | 23600 | Basso Bridge | 32041 | 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 | Stanislaus 2 | 31.439 | Basso Bridge | 0 | State Resource Management Area 55 | 3 | |
11553 | 11553 | 11552 | {"type": "MultiPolygon", "coordinates": [[[[-116.27983, 35.49216], [-116.27707, 35.49572], [-116.27495, 35.49496], [-116.2776, 35.49119], [-116.27983, 35.49216]]], [[[-116.28733, 35.48445], [-116.28702, 35.48523], [-116.28511, 35.48486], [-116.28546, 35.48401], [-116.28733, 35.48445]]]]} | No Public Access 3 | 23604 | Mountain Sheep Watering Area | 32241 | 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 | San Bernardino 22 | 29.9 | Mtn. Sheep Watering Area | 0 | State Resource Management Area 55 | 3 | |
11554 | 11554 | 11553 | {"type": "MultiPolygon", "coordinates": [[[[-120.46637, 37.67093], [-120.46627, 37.67096], [-120.4649, 37.67043], [-120.46452, 37.67036], [-120.46422, 37.67034], [-120.46391, 37.67037], [-120.46374, 37.67043], [-120.46357, 37.67055], [-120.46341, 37.67063], [-120.46314, 37.67068], [-120.46213, 37.67076], [-120.46214, 37.67027], [-120.46115, 37.67021], [-120.46377, 37.66765], [-120.46387, 37.66767], [-120.46572, 37.66924], [-120.46572, 37.67028], [-120.46573, 37.67039], [-120.46637, 37.67093]]], [[[-120.47, 37.67073], [-120.4698, 37.67089], [-120.46926, 37.67122], [-120.46909, 37.67148], [-120.46782, 37.67211], [-120.4673, 37.67142], [-120.46658, 37.67102], [-120.46658, 37.67092], [-120.46631, 37.67072], [-120.46592, 37.67012], [-120.46593, 37.6699], [-120.46681, 37.66927], [-120.46608, 37.66859], [-120.46725, 37.6686], [-120.4673, 37.67023], [-120.4681, 37.6702], [-120.46898, 37.67032], [-120.47, 37.67073]]]]} | No Public Access 3 | 23601 | Tuolumne River Restoration Center | 32331 | 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 | Stanislaus 2 | 33.932 | Tuolumne River Restoration Ctr. | 0 | State Resource Management Area 55 | 3 | |
11558 | 11558 | 11557 | {"type": "MultiPolygon", "coordinates": [[[[-116.9417, 32.65977], [-116.94153, 32.66001], [-116.94146, 32.66001], [-116.94134, 32.6601], [-116.94109, 32.66002], [-116.94043, 32.66015], [-116.94013, 32.66023], [-116.93992, 32.66038], [-116.93985, 32.66099], [-116.93993, 32.66109], [-116.9397, 32.66127], [-116.93967, 32.66141], [-116.9396, 32.6615], [-116.93959, 32.66161], [-116.93963, 32.66169], [-116.93962, 32.66217], [-116.93965, 32.66241], [-116.93987, 32.66274], [-116.94009, 32.66304], [-116.94024, 32.66334], [-116.94034, 32.66367], [-116.94033, 32.66399], [-116.94054, 32.66419], [-116.9404, 32.66434], [-116.94029, 32.66436], [-116.94008, 32.66444], [-116.94005, 32.66456], [-116.94009, 32.66474], [-116.94001, 32.66501], [-116.93996, 32.66512], [-116.93976, 32.66522], [-116.9396, 32.66538], [-116.93934, 32.66555], [-116.93931, 32.66565], [-116.93918, 32.66573], [-116.93914, 32.66578], [-116.93875, 32.66581], [-116.93873, 32.6657], [-116.93858, 32.66549], [-116.93836, 32.66534], [-116.938, 32.66531], [-116.93731, 32.66566], [-116.93724, 32.66576], [-116.93717, 32.66597], [-116.93703, 32.66611], [-116.9369, 32.66631], [-116.93668, 32.66655], [-116.93668, 32.66669], [-116.93654, 32.66682], [-116.93654, 32.66609], [-116.93437, 32.66605], [-116.93437, 32.66514], [-116.93657, 32.66518], [-116.93658, 32.65806], [-116.93693, 32.65833], [-116.93729, 32.65869], [-116.93758, 32.65884], [-116.93762, 32.65906], [-116.93794, 32.6591], [-116.93841, 32.65947], [-116.93842, 32.65946], [-116.93836, 32.65931], [-116.93804, 32.65879], [-116.93796, 32.6586], [-116.93774, 32.65835], [-116.93772, 32.658], [-116.93753, 32.65766], [-116.93762, 32.65749], [-116.93789, 32.65742], [-116.93831, 32.65764], [-116.93832, 32.65762], [-116.93807, 32.65723], [-116.9378, 32.65714], [-116.93724, 32.65649], [-116.93706, 32.65639], [-116.93678, 32.65633], [-116.93682, 32.65603], [-116.93777, 32.65605], [-116.9417, 32.65977]]], [[[-116.95166, 32.66641], [-116.95161, 32.66692], [-116.95163, 32.66696], [-116.9516, 32.66703], [-116.95159, 32.66721], [-116.94962, 32.66719], [-116.94953, 32.67814], [-116.93649, 32.67798], [-116.93651, 32.67515], [-116.93667, 32.67515], [-116.93683, 32.67519], [-116.93694, 32.6752], [-116.937, 32.6752], [-116.93708, 32.67517], [-116.937, 32.67534], [-116.93703, 32.67544], [-116.93686, 32.67577], [-116.93682, 32.67622], [-116.93675, 32.6765], [-116.93679, 32.67697], [-116.93684, 32.67708], [-116.93688, 32.67715], [-116.93696, 32.67721], [-116.93752, 32.67753], [-116.93754, 32.67758], [-116.93807, 32.6779], [-116.93872, 32.67798], [-116.93913, 32.67797], [-116.93933, 32.678], [-116.9401, 32.67801], [-116.94019, 32.67798], [-116.94054, 32.6777], [-116.94082, 32.67743], [-116.94095, 32.67737], [-116.94108, 32.67716], [-116.94113, 32.67717], [-116.9413, 32.67694], [-116.94143, 32.67692], [-116.94154, 32.67667], [-116.94162, 32.67667], [-116.94173, 32.67639], [-116.94186, 32.67643], [-116.94196, 32.67616], [-116.94206, 32.67615], [-116.94218, 32.6761], [-116.94226, 32.67602], [-116.94231, 32.67586], [-116.94232, 32.67553], [-116.94247, 32.67554], [-116.94248, 32.67527], [-116.94261, 32.67524], [-116.94262, 32.67502], [-116.9427, 32.67497], [-116.9427, 32.6743], [-116.94259, 32.67397], [-116.9425, 32.67384], [-116.94237, 32.67376], [-116.9422, 32.67371], [-116.94199, 32.67373], [-116.94189, 32.67371], [-116.94183, 32.67364], [-116.94184, 32.67335], [-116.94216, 32.67292], [-116.94273, 32.67265], [-116.94281, 32.67271], [-116.94307, 32.67268], [-116.9431, 32.6727], [-116.94321, 32.67272], [-116.94386, 32.67371], [-116.94389, 32.67392], [-116.94388, 32.67401], [-116.94378, 32.67405], [-116.94361, 32.67418], [-116.94352, 32.67448], [-116.94349, 32.67461], [-116.94354, 32.67466], [-116.94361, 32.67464], [-116.94367, 32.67484], [-116.9436, 32.67485], [-116.94359, 32.67486], [-116.94364, 32.67493], [-116.94377, 32.67508], [-116.94364, 32.67528], [-116.94367, 32.67533], [-116.94377, 32.67536], [-116.94392, 32.67554], [-116.94405, 32.67567], [-116.94417, 32.67587], [-116.9444, 32.67615], [-116.94486, 32.67639], [-116.94499, 32.6764], [-116.94518, 32.67651], [-116.94561, 32.67672], [-116.94595, 32.67672], [-116.94643, 32.67668], [-116.94681, 32.67689], [-116.94765, 32.67679], [-116.94767, 32.67675], [-116.94821, 32.67687], [-116.94836, 32.67646], [-116.94841, 32.67642], [-116.94863, 32.67585], [-116.9488, 32.6756], [-116.94889, 32.6755], [-116.94905, 32.67487], [-116.94904, 32.67475], [-116.94922, 32.67465], [-116.94934, 32.67443], [-116.94939, 32.67418], [-116.94922, 32.67339], [-116.94905, 32.67322], [-116.94902, 32.6731], [-116.94906, 32.67297], [-116.94905, 32.67283], [-116.94899, 32.67268], [-116.94892, 32.67261], [-116.94877, 32.67259], [-116.94868, 32.67261], [-116.94839, 32.67254], [-116.94823, 32.67256], [-116.94812, 32.67262], [-116.94805, 32.67271], [-116.94797, 32.67256], [-116.94782, 32.67248], [-116.94781, 32.67244], [-116.94765, 32.67235], [-116.94762, 32.67222], [-116.94757, 32.67219], [-116.9474, 32.67187], [-116.9473, 32.67183], [-116.94711, 32.67171], [-116.94694, 32.67167], [-116.94687, 32.67167], [-116.94685, 32.67147], [-116.94674, 32.6711], [-116.94672, 32.67073], [-116.94623, 32.66956], [-116.94603, 32.66927], [-116.94582, 32.669], [-116.94544, 32.66843], [-116.94568, 32.66829], [-116.946, 32.66758], [-116.94619, 32.66724], [-116.94636, 32.66705], [-116.9466, 32.66689], [-116.94664, 32.66679], [-116.94665, 32.66668], [-116.94654, 32.66642], [-116.94644, 32.66624], [-116.94634, 32.66615], [-116.94631, 32.66601], [-116.94627, 32.6659], [-116.94631, 32.66543], [-116.94648, 32.66474], [-116.94674, 32.66383], [-116.94672, 32.66346], [-116.94657, 32.66294], [-116.94649, 32.66275], [-116.94638, 32.66256], [-116.94624, 32.66246], [-116.9466, 32.66252], [-116.94774, 32.66266], [-116.94797, 32.66272], [-116.94821, 32.6627], [-116.94838, 32.66276], [-116.94856, 32.66278], [-116.94865, 32.6629], [-116.94881, 32.66299], [-116.9488, 32.66337], [-116.94888, 32.66345], [-116.94893, 32.66362], [-116.94902, 32.66379], [-116.94918, 32.6639], [-116.94948, 32.66429], [-116.94966, 32.66433], [-116.94978, 32.66455], [-116.9497, 32.66458], [-116.94975, 32.66464], [-116.94956, 32.66493], [-116.94962, 32.66499], [-116.94996, 32.66495], [-116.94998, 32.665], [-116.95009, 32.66509], [-116.95012, 32.66529], [-116.95016, 32.66532], [-116.95016, 32.66563], [-116.95029, 32.66579], [-116.95029, 32.66615], [-116.95016, 32.66624], [-116.95023, 32.66633], [-116.95041, 32.66644], [-116.95078, 32.66678], [-116.95134, 32.66642], [-116.95136, 32.66638], [-116.95139, 32.66638], [-116.95153, 32.66627], [-116.95166, 32.66641]]]]} | No Public Access 3 | 46837 | Rolling Hills Ranch | 30306 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | San Diego 4 | 221.546 | Rolling Hills Ranch | 0 | Local Other or Unknown 14 | 4 | |
11572 | 11572 | 11571 | {"type": "Polygon", "coordinates": [[[-121.56715, 38.72188], [-121.55823, 38.72189], [-121.5582, 38.71449], [-121.56014, 38.7145], [-121.56708, 38.71449], [-121.56715, 38.72188]]]} | No Public Access 3 | 29738 | Elsie | 18605 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sacramento 41 | 156.937 | Elsie | None 1031 | |||
11877 | 11877 | 11876 | {"type": "MultiPolygon", "coordinates": [[[[-122.45576, 37.89472], [-122.45293, 37.89479], [-122.45231, 37.89416], [-122.45169, 37.89423], [-122.45168, 37.8937], [-122.45266, 37.89369], [-122.45295, 37.89409], [-122.45345, 37.89438], [-122.45452, 37.89417], [-122.45468, 37.89396], [-122.45574, 37.89393], [-122.45576, 37.89472]]], [[[-122.46017, 37.89527], [-122.45946, 37.89587], [-122.45918, 37.89564], [-122.45968, 37.895], [-122.46017, 37.89527]]], [[[-122.47661, 37.90785], [-122.47475, 37.90788], [-122.47215, 37.90788], [-122.47196, 37.90748], [-122.47638, 37.90741], [-122.47651, 37.90744], [-122.47659, 37.90755], [-122.47658, 37.90778], [-122.47661, 37.90785]]], [[[-122.47665, 37.97435], [-122.47648, 37.97451], [-122.4762, 37.97431], [-122.47636, 37.97414], [-122.47665, 37.97435]]], [[[-122.48836, 37.96425], [-122.48582, 37.96425], [-122.48578, 37.96063], [-122.48826, 37.96059], [-122.48836, 37.96425]]], [[[-122.48789, 37.95198], [-122.48589, 37.9507], [-122.48589, 37.94931], [-122.48702, 37.94931], [-122.48789, 37.95198]]], [[[-122.49986, 37.93227], [-122.49757, 37.93231], [-122.49748, 37.92869], [-122.49976, 37.92865], [-122.49986, 37.93227]]], [[[-122.50282, 37.93222], [-122.50215, 37.93224], [-122.50213, 37.93158], [-122.50221, 37.93178], [-122.50282, 37.93222]]]]} | No Public Access 3 | 46843 | San Francisco Bay Tidelands | 30614 | 3091 | The Nature Conservancy 63 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | Marin 23 | 61.304 | San Francisco Bay Tidelands | 0 | Private Conservation 16 | 2 | |
11903 | 11903 | 11902 | {"type": "MultiPolygon", "coordinates": [[[[-122.05085, 37.05644], [-122.05084, 37.05733], [-122.04901, 37.05733], [-122.04897, 37.05736], [-122.04879, 37.06192], [-122.04841, 37.06194], [-122.04831, 37.0649], [-122.03933, 37.06479], [-122.03939, 37.06108], [-122.03927, 37.05717], [-122.03822, 37.05718], [-122.03822, 37.05714], [-122.03851, 37.05688], [-122.03864, 37.05684], [-122.03868, 37.0568], [-122.03877, 37.05676], [-122.03877, 37.05661], [-122.03881, 37.05626], [-122.03929, 37.05618], [-122.03905, 37.05517], [-122.03927, 37.05525], [-122.0397, 37.05552], [-122.03989, 37.05556], [-122.04046, 37.05535], [-122.0407, 37.05529], [-122.0407, 37.05547], [-122.04089, 37.05547], [-122.04147, 37.0555], [-122.04149, 37.0557], [-122.0416, 37.05598], [-122.04186, 37.05626], [-122.0423, 37.05642], [-122.0428, 37.05651], [-122.04274, 37.05736], [-122.04391, 37.05736], [-122.0439, 37.05695], [-122.04479, 37.05698], [-122.04531, 37.05695], [-122.04597, 37.05683], [-122.04613, 37.0566], [-122.04639, 37.05643], [-122.0468, 37.05648], [-122.04764, 37.05607], [-122.04805, 37.05603], [-122.04834, 37.0559], [-122.0488, 37.05587], [-122.04881, 37.05643], [-122.05085, 37.05644]]], [[[-122.03892, 37.05561], [-122.03883, 37.05579], [-122.03871, 37.05573], [-122.03881, 37.05558], [-122.03879, 37.05551], [-122.03892, 37.05561]]], [[[-122.05593, 37.06624], [-122.05087, 37.06611], [-122.05087, 37.06593], [-122.05587, 37.06596], [-122.05593, 37.06624]]], [[[-122.05764, 37.06629], [-122.05619, 37.06625], [-122.05616, 37.0661], [-122.05761, 37.06611], [-122.05764, 37.06629]]]]} | No Public Access 3 | 24438 | Randall Morgan Sandhills | 30479 | 3036 | Land Trust of Santa Cruz County 121 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.landtrustsantacruz.org/ | Non Governmental Organization 10 | 3036 | Land Trust of Santa Cruz County 118 | Non Profit 6 | Non Profit - Land Trust 10 | Santa Cruz 5 | 203.811 | Randall Morgan Sandhills | 0 | Private Conservation 16 | 2 | |
11905 | 11905 | 11904 | {"type": "Polygon", "coordinates": [[[-122.57517, 38.37016], [-122.57515, 38.37071], [-122.57458, 38.37071], [-122.57457, 38.37015], [-122.57517, 38.37016]]]} | No Public Access 3 | 24493 | Bunnell Vernal Pool | 28171 | 3091 | The Nature Conservancy 63 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | Sonoma 16 | 0.779 | Bunnell Vernal Pool | 0 | Private Conservation 16 | 2 | |
11975 | 11975 | 11974 | {"type": "Polygon", "coordinates": [[[-122.21029, 37.33464], [-122.21012, 37.33619], [-122.20954, 37.33542], [-122.20931, 37.3353], [-122.20907, 37.33507], [-122.20787, 37.33496], [-122.20832, 37.3339], [-122.20853, 37.33408], [-122.20943, 37.33451], [-122.21029, 37.33464]]]} | No Public Access 3 | 35055 | Coal Creek Open Space Preserve | 31502 | 2079 | Midpeninsula Regional Open Space District 366 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org/preserves/pr_coal_creek.asp | San Mateo 15 | 5.246 | Coal Creek OSP | 0 | Local Conservation Area 4 | 2 |
12161 | 12161 | 12160 | {"type": "MultiPolygon", "coordinates": [[[[-116.89905, 32.95333], [-116.89, 32.95344], [-116.88151, 32.95355], [-116.8816, 32.96148], [-116.88116, 32.9615], [-116.88115, 32.96152], [-116.885, 32.9652], [-116.88908, 32.96899], [-116.88886, 32.96915], [-116.88806, 32.96953], [-116.88748, 32.96988], [-116.88714, 32.97015], [-116.88637, 32.97047], [-116.88496, 32.97038], [-116.88394, 32.97102], [-116.88384, 32.97134], [-116.88348, 32.97175], [-116.88356, 32.97201], [-116.88313, 32.97251], [-116.88289, 32.97259], [-116.88262, 32.97308], [-116.88259, 32.97326], [-116.88268, 32.9735], [-116.8831, 32.97377], [-116.88302, 32.97416], [-116.883, 32.9744], [-116.88309, 32.97464], [-116.88333, 32.97482], [-116.88365, 32.97502], [-116.88396, 32.9752], [-116.8848, 32.97528], [-116.88502, 32.97532], [-116.88523, 32.97541], [-116.8854, 32.97555], [-116.88529, 32.97581], [-116.88538, 32.97593], [-116.88558, 32.97612], [-116.88559, 32.97621], [-116.88546, 32.97641], [-116.88497, 32.9773], [-116.88513, 32.97767], [-116.88546, 32.97779], [-116.88569, 32.97807], [-116.88589, 32.97851], [-116.88585, 32.97869], [-116.88572, 32.97887], [-116.88574, 32.97923], [-116.88615, 32.98011], [-116.88646, 32.98026], [-116.88664, 32.98061], [-116.88691, 32.98074], [-116.88704, 32.98091], [-116.8871, 32.98113], [-116.88712, 32.98177], [-116.88739, 32.98276], [-116.88724, 32.98301], [-116.88737, 32.98363], [-116.88727, 32.98413], [-116.88743, 32.98493], [-116.88738, 32.98527], [-116.88734, 32.98618], [-116.88744, 32.98643], [-116.88739, 32.98664], [-116.88719, 32.98685], [-116.88719, 32.98709], [-116.88736, 32.98767], [-116.88731, 32.98807], [-116.8875, 32.98843], [-116.88729, 32.98881], [-116.88741, 32.98924], [-116.88717, 32.98984], [-116.88666, 32.99058], [-116.88661, 32.99098], [-116.88658, 32.99111], [-116.88666, 32.99133], [-116.88665, 32.9917], [-116.88654, 32.99221], [-116.88662, 32.99234], [-116.8864, 32.9939], [-116.87774, 32.99394], [-116.87771, 32.99394], [-116.8777, 32.99389], [-116.87565, 32.99388], [-116.87531, 32.98531], [-116.86673, 32.98548], [-116.86689, 32.99385], [-116.85049, 32.99367], [-116.85066, 32.99357], [-116.85055, 32.99344], [-116.85028, 32.99359], [-116.85006, 32.99368], [-116.8499, 32.99368], [-116.84983, 32.99285], [-116.84955, 32.98892], [-116.8484, 32.98898], [-116.84841, 32.98896], [-116.84841, 32.98895], [-116.84131, 32.98865], [-116.84128, 32.97835], [-116.84039, 32.96417], [-116.84829, 32.96324], [-116.84847, 32.94951], [-116.85033, 32.95109], [-116.85343, 32.95285], [-116.8537, 32.95281], [-116.85377, 32.95285], [-116.85671, 32.95243], [-116.85752, 32.95367], [-116.85831, 32.95552], [-116.85917, 32.95623], [-116.85986, 32.95615], [-116.86132, 32.95637], [-116.86287, 32.95522], [-116.86398, 32.95328], [-116.8659, 32.95241], [-116.86586, 32.95523], [-116.8735, 32.95511], [-116.87459, 32.95514], [-116.88011, 32.94845], [-116.87784, 32.94618], [-116.88568, 32.94618], [-116.88564, 32.94202], [-116.88949, 32.94174], [-116.89438, 32.94175], [-116.8944, 32.94591], [-116.89892, 32.94576], [-116.89905, 32.95333]], [[-116.85013, 32.98801], [-116.85065, 32.98657], [-116.84949, 32.98657], [-116.84954, 32.98837], [-116.84974, 32.98835], [-116.84991, 32.98827], [-116.85005, 32.98815], [-116.85013, 32.98801]]], [[[-116.90039, 32.98023], [-116.89618, 32.98029], [-116.89653, 32.98476], [-116.89236, 32.98489], [-116.89283, 32.98927], [-116.89317, 32.99393], [-116.88879, 32.99392], [-116.88686, 32.9939], [-116.88696, 32.99365], [-116.88691, 32.99352], [-116.88678, 32.9933], [-116.88692, 32.99229], [-116.88684, 32.99216], [-116.88694, 32.99173], [-116.88695, 32.9913], [-116.88688, 32.9911], [-116.88694, 32.99065], [-116.88743, 32.98995], [-116.88772, 32.98926], [-116.8876, 32.98884], [-116.88782, 32.98844], [-116.88761, 32.98803], [-116.88766, 32.98766], [-116.88748, 32.98706], [-116.88748, 32.98694], [-116.88767, 32.98674], [-116.88774, 32.98642], [-116.88764, 32.98615], [-116.88768, 32.98529], [-116.88772, 32.98492], [-116.88757, 32.98413], [-116.88767, 32.98363], [-116.88754, 32.98305], [-116.8877, 32.98279], [-116.88741, 32.98174], [-116.88739, 32.98111], [-116.88732, 32.98082], [-116.88711, 32.98055], [-116.88687, 32.98044], [-116.88669, 32.98009], [-116.88639, 32.97994], [-116.88603, 32.97917], [-116.88601, 32.97894], [-116.88614, 32.97878], [-116.88619, 32.97848], [-116.88595, 32.97795], [-116.88565, 32.97759], [-116.88537, 32.97748], [-116.88529, 32.97731], [-116.88572, 32.97653], [-116.88585, 32.97632], [-116.88591, 32.97618], [-116.88589, 32.97611], [-116.88568, 32.97589], [-116.88562, 32.97577], [-116.88574, 32.97564], [-116.88576, 32.97544], [-116.88552, 32.97514], [-116.88519, 32.97496], [-116.88454, 32.97497], [-116.88416, 32.97491], [-116.88367, 32.97459], [-116.88342, 32.97445], [-116.88331, 32.97435], [-116.88341, 32.97379], [-116.88335, 32.97365], [-116.88297, 32.97336], [-116.88293, 32.97329], [-116.88292, 32.97323], [-116.88293, 32.97317], [-116.88313, 32.97282], [-116.88333, 32.97276], [-116.8839, 32.97204], [-116.88384, 32.97183], [-116.88416, 32.9715], [-116.88425, 32.97121], [-116.88509, 32.97067], [-116.88647, 32.97077], [-116.88707, 32.97049], [-116.88737, 32.97033], [-116.88772, 32.97009], [-116.88829, 32.96974], [-116.88913, 32.96933], [-116.88931, 32.9692], [-116.89119, 32.97093], [-116.89186, 32.97159], [-116.89141, 32.97351], [-116.89084, 32.97584], [-116.9001, 32.97586], [-116.90039, 32.98023]]]]} | No Public Access 3 | 25240 | Canada de San Vicente | 32091 | 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 | San Diego 4 | 4998.226 | Canada de San Vicente | 0 | State Resource Management Area 55 | 3 | |
12217 | 12217 | 12216 | {"type": "Polygon", "coordinates": [[[-115.28714, 35.38373], [-115.28272, 35.3837], [-115.28272, 35.38188], [-115.28714, 35.38193], [-115.28714, 35.38373]]]} | No Public Access 3 | 35701 | Unnamed site - Riverside Land Conservancy | 28658 | 3059 | Rivers and Lands Conservancy 773 | Non Profit 6 | Non Profit - Land Trust 10 | https://riversandlands.org/ | Non Governmental Organization 10 | 3059 | Rivers and Lands Conservancy 754 | Non Profit 6 | Non Profit - Land Trust 10 | San Bernardino 22 | 19.95 | 0 | Private Other or Unknown 399 | 4 | ||
12239 | 12239 | 12238 | {"type": "MultiPolygon", "coordinates": [[[[-121.81481, 37.18545], [-121.81443, 37.18597], [-121.81411, 37.18586], [-121.81364, 37.18607], [-121.81328, 37.18597], [-121.81248, 37.18616], [-121.8121, 37.18634], [-121.81191, 37.1867], [-121.81129, 37.18674], [-121.81119, 37.18707], [-121.81007, 37.18754], [-121.80967, 37.18793], [-121.80876, 37.18806], [-121.80828, 37.18817], [-121.80768, 37.1887], [-121.80721, 37.18917], [-121.80733, 37.18936], [-121.80713, 37.18941], [-121.80652, 37.18941], [-121.80585, 37.18957], [-121.80484, 37.18906], [-121.80459, 37.1887], [-121.80433, 37.18869], [-121.80389, 37.18904], [-121.80401, 37.18967], [-121.8038, 37.18975], [-121.80308, 37.18935], [-121.80225, 37.18942], [-121.80234, 37.18906], [-121.80212, 37.18882], [-121.80163, 37.18877], [-121.80144, 37.18892], [-121.80106, 37.18913], [-121.80106, 37.18872], [-121.80086, 37.18855], [-121.79987, 37.1886], [-121.79945, 37.18855], [-121.79942, 37.18814], [-121.79966, 37.18806], [-121.79993, 37.18815], [-121.80072, 37.18789], [-121.80062, 37.18771], [-121.80016, 37.1876], [-121.80011, 37.18752], [-121.80048, 37.18729], [-121.80037, 37.18708], [-121.80011, 37.18699], [-121.79949, 37.18707], [-121.79953, 37.1867], [-121.79952, 37.18669], [-121.79918, 37.18667], [-121.79884, 37.18685], [-121.79882, 37.18684], [-121.79892, 37.1866], [-121.7987, 37.18623], [-121.7983, 37.18624], [-121.79766, 37.18685], [-121.79754, 37.18628], [-121.79722, 37.18623], [-121.79694, 37.18653], [-121.7968, 37.18633], [-121.79705, 37.18608], [-121.79691, 37.18585], [-121.79713, 37.18572], [-121.79689, 37.18547], [-121.79672, 37.18544], [-121.79659, 37.18535], [-121.79644, 37.18517], [-121.79633, 37.18496], [-121.79629, 37.18479], [-121.79617, 37.18353], [-121.79606, 37.18286], [-121.79494, 37.17798], [-121.7893, 37.17799], [-121.78787, 37.17503], [-121.79735, 37.17316], [-121.79728, 37.1727], [-121.79721, 37.17205], [-121.79887, 37.17199], [-121.80285, 37.17191], [-121.81129, 37.17604], [-121.81128, 37.17607], [-121.81161, 37.1763], [-121.81395, 37.17834], [-121.81422, 37.17843], [-121.81424, 37.17881], [-121.8145, 37.17904], [-121.8143, 37.17932], [-121.8142, 37.17969], [-121.81354, 37.18042], [-121.81255, 37.18117], [-121.81253, 37.1814], [-121.81326, 37.18189], [-121.81377, 37.18342], [-121.81418, 37.18413], [-121.81453, 37.18459], [-121.81481, 37.18545]], [[-121.8138, 37.18355], [-121.81379, 37.18354], [-121.81252, 37.1835], [-121.81247, 37.1844], [-121.81375, 37.18444], [-121.8138, 37.18355]]], [[[-121.81966, 37.19051], [-121.81954, 37.19058], [-121.81966, 37.19073], [-121.81628, 37.19243], [-121.81628, 37.19244], [-121.81771, 37.19348], [-121.81621, 37.19407], [-121.81534, 37.19382], [-121.81409, 37.197], [-121.81255, 37.19662], [-121.80925, 37.19534], [-121.80926, 37.1953], [-121.80483, 37.19356], [-121.80121, 37.19199], [-121.80043, 37.19164], [-121.79993, 37.19139], [-121.79978, 37.1913], [-121.79948, 37.19106], [-121.79815, 37.18987], [-121.79774, 37.18931], [-121.79705, 37.18819], [-121.79685, 37.18793], [-121.79667, 37.18773], [-121.79643, 37.18752], [-121.79622, 37.18738], [-121.79626, 37.18738], [-121.79728, 37.187], [-121.79742, 37.18696], [-121.79746, 37.18705], [-121.79766, 37.18713], [-121.79822, 37.18683], [-121.79849, 37.18655], [-121.79858, 37.18709], [-121.79917, 37.18697], [-121.79927, 37.18717], [-121.79974, 37.18734], [-121.79993, 37.18781], [-121.79945, 37.18779], [-121.79906, 37.18801], [-121.79921, 37.18869], [-121.79971, 37.18887], [-121.80075, 37.18882], [-121.80068, 37.18913], [-121.80092, 37.18935], [-121.80182, 37.18906], [-121.80197, 37.18946], [-121.80237, 37.18968], [-121.80289, 37.18959], [-121.80373, 37.19001], [-121.80437, 37.18981], [-121.80451, 37.18921], [-121.80487, 37.18956], [-121.80581, 37.18993], [-121.80753, 37.18959], [-121.80818, 37.18894], [-121.80837, 37.18891], [-121.80875, 37.18857], [-121.8102, 37.18806], [-121.81041, 37.1878], [-121.81085, 37.18764], [-121.81182, 37.18708], [-121.81219, 37.18702], [-121.81246, 37.18655], [-121.81315, 37.18646], [-121.8134, 37.18627], [-121.81369, 37.18628], [-121.81411, 37.1862], [-121.81436, 37.18625], [-121.81461, 37.18613], [-121.81494, 37.18576], [-121.81511, 37.18541], [-121.81503, 37.1848], [-121.81446, 37.18409], [-121.81444, 37.18399], [-121.81554, 37.18375], [-121.81547, 37.18401], [-121.81584, 37.18451], [-121.81613, 37.1848], [-121.81612, 37.18486], [-121.81578, 37.18507], [-121.8158, 37.1853], [-121.81578, 37.18554], [-121.81565, 37.18646], [-121.81576, 37.18744], [-121.81583, 37.18771], [-121.81582, 37.18783], [-121.81578, 37.18791], [-121.81534, 37.18815], [-121.81486, 37.18815], [-121.81462, 37.18823], [-121.81441, 37.18879], [-121.81477, 37.18888], [-121.81561, 37.18868], [-121.81639, 37.19007], [-121.81727, 37.18963], [-121.81845, 37.1891], [-121.81883, 37.18887], [-121.81959, 37.1894], [-121.81897, 37.18971], [-121.819, 37.18985], [-121.81911, 37.18992], [-121.81966, 37.19051]]]]} | No Public Access 3 | 25443 | Calero County Park | 16679 | 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 | 963.38 | Calero County Park | 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]);