units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
358 rows where LAYER = 5 and MNG_AG_TYP = 5 sorted by MNG_AG_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, GAP_STS
DES_TP >30
- State Resource Management Area 88
- State Conservation Area 81
- State Other or Unknown 54
- State Recreation Area 22
- State Park 15
- National Monument or Landmark 2
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- National Wildlife Refuge 1
- None 1
- None 1
- State Historic or Cultural Area 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 20
- California State Lands Commission 86
- University of California 52
- Other State 43
- California Department of Fish and Wildlife 32
- California Department of Transportation 27
- California Department of Parks and Recreation 23
- California Department of Water Resources 20
- Santa Monica Mountains Conservancy 18
- California Department of General Services 14
- California Department of Forestry and Fire Protection 10
- California Wildlife Conservation Board 9
- California State Coastal Conservancy 7
- Coachella Valley Mountains Conservancy 5
- California Department of Veterans Affairs 2
- Napa Valley College 2
- San Diego State University 2
- California State University 2
- California Tahoe Conservancy 2
- California State University Sonoma 1
- California State University Long Beach 1
ACCESS_TYP 4
- Open Access 218
- Restricted Access 67
- No Public Access 45
- Unknown Access 28
MNG_AG_TYP 1
- State Agency · 358 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7378 | 7378 | 7377 | {"type": "Polygon", "coordinates": [[[-118.69926, 34.03173], [-118.69898, 34.03182], [-118.69884, 34.03153], [-118.69917, 34.03149], [-118.69926, 34.03173]]]} | Open Access 1 | 6778 | Amarillo Beach - Coastal Conservancy | 15439 | 200 | California State Coastal Conservancy 859 | State 5 | State Agency 5 | http://www.scc.ca.gov/ | Other State 5 | 200 | California State Coastal Conservancy 837 | State 5 | State Agency 5 | Los Angeles 6 | 0.228 | Amarillo Beach - Coastal Conservancy | None 613 | |||
10502 | 10502 | 10501 | {"type": "MultiPolygon", "coordinates": [[[[-122.50494, 38.0833], [-122.50283, 38.08438], [-122.50242, 38.08446], [-122.5019, 38.08401], [-122.50167, 38.08357], [-122.50164, 38.08318], [-122.50338, 38.08236], [-122.50428, 38.08204], [-122.50477, 38.08284], [-122.50494, 38.0833]]], [[[-122.50616, 38.07765], [-122.50607, 38.07778], [-122.50376, 38.07881], [-122.50225, 38.07899], [-122.50211, 38.07872], [-122.50208, 38.07744], [-122.50246, 38.07689], [-122.50263, 38.07687], [-122.50616, 38.07765]]], [[[-122.52681, 38.07788], [-122.52681, 38.07802], [-122.5259, 38.07858], [-122.52583, 38.07857], [-122.52545, 38.07827], [-122.52507, 38.07734], [-122.52478, 38.07693], [-122.52426, 38.07651], [-122.52464, 38.07376], [-122.52473, 38.07379], [-122.52522, 38.07418], [-122.52528, 38.07479], [-122.52516, 38.07509], [-122.52516, 38.07557], [-122.52588, 38.07617], [-122.52643, 38.07731], [-122.52681, 38.07788]]], [[[-122.52959, 38.08051], [-122.52804, 38.08099], [-122.52751, 38.08086], [-122.52649, 38.08112], [-122.52605, 38.08132], [-122.52594, 38.08124], [-122.52613, 38.08116], [-122.52704, 38.08059], [-122.52732, 38.08038], [-122.52755, 38.08015], [-122.52815, 38.07944], [-122.52834, 38.07928], [-122.52856, 38.07915], [-122.52894, 38.07901], [-122.52959, 38.08051]]]]} | Restricted Access 2 | 18623 | Bel Marin Keys #5 | 15962 | 200 | California State Coastal Conservancy 859 | State 5 | State Agency 5 | http://www.scc.ca.gov/ | Other State 5 | 200 | California State Coastal Conservancy 837 | State 5 | State Agency 5 | Marin 23 | 43.415 | Bel Marin Keys #5 | 2001 | None 918 | ||
12259 | 12259 | 12258 | {"type": "MultiPolygon", "coordinates": [[[[-121.79497, 36.91818], [-121.79476, 36.92157], [-121.79287, 36.92142], [-121.792, 36.92038], [-121.79156, 36.91989], [-121.79092, 36.91958], [-121.79044, 36.91919], [-121.79006, 36.91924], [-121.78959, 36.9184], [-121.7892, 36.91777], [-121.79015, 36.91691], [-121.79042, 36.91742], [-121.79241, 36.9166], [-121.79251, 36.91675], [-121.79276, 36.91731], [-121.79314, 36.91807], [-121.79321, 36.91828], [-121.79323, 36.91864], [-121.79447, 36.91813], [-121.79497, 36.91818]]], [[[-121.79513, 36.91547], [-121.79504, 36.91694], [-121.79469, 36.91689], [-121.79447, 36.91679], [-121.79439, 36.91659], [-121.79438, 36.91643], [-121.79442, 36.91627], [-121.79454, 36.9161], [-121.79471, 36.91597], [-121.79464, 36.91567], [-121.79513, 36.91547]]]]} | Restricted Access 2 | 25824 | Struve Slough - California Coastal Conservancy | 25932 | 200 | California State Coastal Conservancy 859 | State 5 | State Agency 5 | http://www.scc.ca.gov/ | Other State 5 | 200 | California State Coastal Conservancy 837 | State 5 | State Agency 5 | Santa Cruz 5 | 40.585 | Struve Slough - California Coastal Conservancy | None 1069 | |||
13158 | 13158 | 13157 | {"type": "Polygon", "coordinates": [[[-122.52495, 38.06971], [-122.52293, 38.06978], [-122.52096, 38.07133], [-122.51104, 38.06343], [-122.5006, 38.06098], [-122.49657, 38.06008], [-122.49222, 38.05907], [-122.49669, 38.05127], [-122.498, 38.04907], [-122.49841, 38.04941], [-122.49892, 38.04861], [-122.49891, 38.04859], [-122.49831, 38.04855], [-122.49847, 38.04828], [-122.49848, 38.04785], [-122.50668, 38.04784], [-122.50668, 38.04742], [-122.50731, 38.04741], [-122.50732, 38.0474], [-122.50668, 38.04689], [-122.50851, 38.04693], [-122.50972, 38.04814], [-122.51013, 38.04801], [-122.51102, 38.04913], [-122.51148, 38.05001], [-122.51052, 38.05012], [-122.51044, 38.05017], [-122.5105, 38.05049], [-122.50943, 38.05062], [-122.50805, 38.05113], [-122.50669, 38.0522], [-122.50669, 38.05222], [-122.5098, 38.05469], [-122.51448, 38.06081], [-122.51476, 38.06197], [-122.51638, 38.06325], [-122.51678, 38.06343], [-122.51743, 38.06392], [-122.51755, 38.06389], [-122.51761, 38.06395], [-122.5176, 38.06404], [-122.51799, 38.06436], [-122.51829, 38.06465], [-122.51843, 38.0647], [-122.51859, 38.06467], [-122.52495, 38.06971]]]} | No Public Access 3 | 35102 | Hamilton Wetlands | 19625 | 200 | California State Coastal Conservancy 859 | State 5 | State Agency 5 | http://www.scc.ca.gov/ | Other State 5 | 200 | California State Coastal Conservancy 837 | State 5 | State Agency 5 | Marin 23 | 632.955 | Hamilton Wetlands | 0 | State Conservation Area 8 | 2 | |
14357 | 14357 | 14356 | {"type": "Polygon", "coordinates": [[[-122.43472, 37.4203], [-122.43469, 37.42037], [-122.43446, 37.42083], [-122.4341, 37.42131], [-122.43399, 37.42142], [-122.43373, 37.42132], [-122.43314, 37.42182], [-122.4328, 37.42151], [-122.43328, 37.42138], [-122.43363, 37.42038], [-122.43351, 37.42016], [-122.43273, 37.42015], [-122.43193, 37.4206], [-122.43157, 37.42064], [-122.4316, 37.42016], [-122.43222, 37.41984], [-122.43246, 37.41933], [-122.4324, 37.4191], [-122.43212, 37.41903], [-122.43205, 37.41889], [-122.43246, 37.4187], [-122.43311, 37.41865], [-122.43355, 37.41836], [-122.43396, 37.41759], [-122.43381, 37.41744], [-122.43364, 37.4172], [-122.43392, 37.41715], [-122.43398, 37.41754], [-122.43396, 37.41759], [-122.43422, 37.41784], [-122.43428, 37.41792], [-122.43425, 37.41801], [-122.43421, 37.41821], [-122.43421, 37.41834], [-122.4343, 37.41853], [-122.43449, 37.41873], [-122.43489, 37.41893], [-122.43496, 37.419], [-122.43499, 37.41907], [-122.43499, 37.41928], [-122.43492, 37.41953], [-122.43465, 37.42005], [-122.43472, 37.4203]]]} | Restricted Access 2 | 44407 | Cowell-Purisima Coastal Trail | 17731 | 200 | California State Coastal Conservancy 859 | State 5 | State Agency 5 | http://www.scc.ca.gov/ | Other State 5 | 200 | California State Coastal Conservancy 837 | State 5 | State Agency 5 | San Mateo 15 | 15.245 | Cowell-Purisima Coastal Trail | None 1214 | |||
14369 | 14369 | 14368 | {"type": "MultiPolygon", "coordinates": [[[[-122.42996, 37.41136], [-122.42941, 37.41135], [-122.42937, 37.41116], [-122.42893, 37.41087], [-122.42819, 37.41085], [-122.42789, 37.41056], [-122.42791, 37.41017], [-122.42718, 37.41014], [-122.42617, 37.40985], [-122.42582, 37.40872], [-122.42589, 37.40859], [-122.42582, 37.40836], [-122.42623, 37.40784], [-122.4262, 37.40764], [-122.4264, 37.40705], [-122.4267, 37.40688], [-122.42689, 37.40654], [-122.4268, 37.40604], [-122.4269, 37.40577], [-122.42664, 37.40523], [-122.42528, 37.4053], [-122.4245, 37.4051], [-122.42447, 37.40466], [-122.42525, 37.4048], [-122.42538, 37.40464], [-122.42552, 37.40455], [-122.42566, 37.40402], [-122.426, 37.40391], [-122.42604, 37.40394], [-122.42609, 37.40394], [-122.42633, 37.40416], [-122.42642, 37.40419], [-122.42664, 37.40432], [-122.42679, 37.40443], [-122.42707, 37.40506], [-122.42712, 37.40543], [-122.42708, 37.40562], [-122.4271, 37.40626], [-122.42699, 37.40673], [-122.42698, 37.40732], [-122.42699, 37.40821], [-122.42697, 37.40864], [-122.42714, 37.40912], [-122.42734, 37.40922], [-122.42734, 37.40927], [-122.42739, 37.40949], [-122.42767, 37.40992], [-122.42785, 37.41013], [-122.42791, 37.41012], [-122.42805, 37.41012], [-122.42824, 37.41006], [-122.42835, 37.41006], [-122.42853, 37.41002], [-122.42862, 37.41007], [-122.42869, 37.41009], [-122.4288, 37.41034], [-122.42902, 37.41057], [-122.42916, 37.41075], [-122.42989, 37.41135], [-122.42996, 37.41136]]], [[[-122.43364, 37.4172], [-122.43347, 37.41724], [-122.43296, 37.41702], [-122.43321, 37.41639], [-122.43332, 37.41629], [-122.43321, 37.41576], [-122.4326, 37.41522], [-122.43172, 37.41547], [-122.43157, 37.41522], [-122.43105, 37.41573], [-122.43053, 37.4145], [-122.43129, 37.41447], [-122.43132, 37.41415], [-122.43158, 37.41413], [-122.43159, 37.41411], [-122.43133, 37.41355], [-122.43123, 37.41331], [-122.43099, 37.41256], [-122.43059, 37.41173], [-122.43031, 37.41161], [-122.43016, 37.41141], [-122.43025, 37.41143], [-122.43046, 37.41155], [-122.43058, 37.41169], [-122.43072, 37.41173], [-122.43082, 37.41179], [-122.4309, 37.41177], [-122.43097, 37.41179], [-122.43105, 37.41171], [-122.43119, 37.41194], [-122.4311, 37.41206], [-122.43109, 37.41211], [-122.4311, 37.41216], [-122.43117, 37.41223], [-122.43127, 37.41218], [-122.43133, 37.41243], [-122.43152, 37.41293], [-122.43188, 37.41341], [-122.43189, 37.41355], [-122.43216, 37.41416], [-122.43242, 37.41444], [-122.43287, 37.415], [-122.43319, 37.41532], [-122.43343, 37.4155], [-122.43354, 37.41553], [-122.43371, 37.4163], [-122.4337, 37.41645], [-122.4336, 37.41676], [-122.43358, 37.41708], [-122.43364, 37.4172]]]]} | Restricted Access 2 | 44457 | Cowell-Purisima Coastal Trail | 17731 | 200 | California State Coastal Conservancy 859 | State 5 | State Agency 5 | http://www.scc.ca.gov/ | Other State 5 | 200 | California State Coastal Conservancy 837 | State 5 | State Agency 5 | San Mateo 15 | 26.92 | Cowell-Purisima Coastal Trail | None 1218 | |||
16080 | 16080 | 16079 | {"type": "MultiPolygon", "coordinates": [[[[-118.74218, 34.04546], [-118.74197, 34.04576], [-118.74191, 34.04574], [-118.74197, 34.04547], [-118.74218, 34.04546]]], [[[-118.74463, 34.04567], [-118.74456, 34.04578], [-118.74452, 34.04592], [-118.74452, 34.04607], [-118.74454, 34.04612], [-118.74453, 34.04621], [-118.74451, 34.04623], [-118.7442, 34.04609], [-118.74426, 34.04604], [-118.74431, 34.04596], [-118.74438, 34.04561], [-118.7444, 34.04558], [-118.74447, 34.04554], [-118.74456, 34.04555], [-118.7446, 34.04557], [-118.74463, 34.04561], [-118.74463, 34.04567]]], [[[-118.74446, 34.04548], [-118.74437, 34.04551], [-118.74431, 34.04557], [-118.74421, 34.04596], [-118.74415, 34.04602], [-118.744, 34.04611], [-118.74395, 34.04613], [-118.74382, 34.04613], [-118.74345, 34.04593], [-118.74332, 34.04589], [-118.7432, 34.04589], [-118.74306, 34.04594], [-118.74297, 34.046], [-118.7429, 34.0461], [-118.74286, 34.04628], [-118.74282, 34.04633], [-118.74271, 34.04643], [-118.7427, 34.04644], [-118.74262, 34.04637], [-118.74267, 34.04631], [-118.74269, 34.04624], [-118.74268, 34.04615], [-118.74263, 34.04607], [-118.74263, 34.04597], [-118.74314, 34.04563], [-118.74343, 34.04562], [-118.74352, 34.04555], [-118.74354, 34.04547], [-118.74446, 34.04548]]], [[[-118.74095, 34.04695], [-118.74058, 34.04695], [-118.7406, 34.04596], [-118.74094, 34.04595], [-118.74092, 34.04601], [-118.74087, 34.04606], [-118.7408, 34.04609], [-118.74073, 34.04616], [-118.7407, 34.04627], [-118.74072, 34.04634], [-118.74077, 34.0464], [-118.74093, 34.04649], [-118.74099, 34.04655], [-118.741, 34.04664], [-118.74095, 34.04695]]], [[[-118.74489, 34.04699], [-118.74421, 34.047], [-118.74418, 34.04693], [-118.74419, 34.04683], [-118.74424, 34.04677], [-118.74431, 34.04674], [-118.74452, 34.0467], [-118.74459, 34.04665], [-118.74464, 34.04659], [-118.74465, 34.04655], [-118.74464, 34.04615], [-118.74461, 34.04604], [-118.7446, 34.04592], [-118.74489, 34.04592], [-118.74489, 34.04699]]], [[[-118.74346, 34.0455], [-118.74339, 34.04555], [-118.74312, 34.04556], [-118.74261, 34.04588], [-118.74257, 34.04592], [-118.74254, 34.04599], [-118.74254, 34.04608], [-118.7426, 34.04618], [-118.74261, 34.04625], [-118.74259, 34.04629], [-118.7423, 34.04651], [-118.74226, 34.04658], [-118.74224, 34.04664], [-118.74196, 34.04662], [-118.74199, 34.04687], [-118.74227, 34.04678], [-118.74228, 34.04679], [-118.74268, 34.04737], [-118.74268, 34.0474], [-118.74264, 34.04745], [-118.7426, 34.04747], [-118.74241, 34.04748], [-118.74225, 34.04756], [-118.74218, 34.04762], [-118.74213, 34.04771], [-118.74211, 34.0478], [-118.74212, 34.04788], [-118.7417, 34.04787], [-118.74169, 34.04767], [-118.74183, 34.04726], [-118.74181, 34.04714], [-118.74169, 34.04699], [-118.74163, 34.04687], [-118.74163, 34.04678], [-118.74174, 34.04608], [-118.74176, 34.04603], [-118.7418, 34.04598], [-118.74191, 34.04594], [-118.74197, 34.04589], [-118.74206, 34.04576], [-118.74231, 34.04585], [-118.74259, 34.04547], [-118.74346, 34.04547], [-118.74346, 34.0455]]], [[[-118.74099, 34.0474], [-118.741, 34.04747], [-118.74087, 34.04795], [-118.74084, 34.04833], [-118.7406, 34.04833], [-118.74059, 34.04728], [-118.74092, 34.04728], [-118.74099, 34.0474]]], [[[-118.74165, 34.04709], [-118.74169, 34.04713], [-118.74173, 34.04724], [-118.7416, 34.04767], [-118.7416, 34.04789], [-118.74158, 34.04794], [-118.74126, 34.04789], [-118.74115, 34.04844], [-118.74095, 34.04847], [-118.74093, 34.04843], [-118.74093, 34.04837], [-118.74094, 34.04799], [-118.74108, 34.04745], [-118.74107, 34.04738], [-118.74099, 34.04728], [-118.74098, 34.04723], [-118.74109, 34.04662], [-118.74107, 34.04655], [-118.74103, 34.04648], [-118.74093, 34.0464], [-118.74085, 34.04638], [-118.74079, 34.0463], [-118.7408, 34.0462], [-118.74085, 34.04614], [-118.74093, 34.0461], [-118.74098, 34.04605], [-118.74124, 34.04611], [-118.74126, 34.04601], [-118.74165, 34.04606], [-118.74153, 34.04679], [-118.74155, 34.04693], [-118.74159, 34.04702], [-118.74165, 34.04709]]], [[[-118.7413, 34.0486], [-118.74115, 34.04892], [-118.74113, 34.04894], [-118.74108, 34.04894], [-118.74106, 34.04892], [-118.74106, 34.04889], [-118.74109, 34.04882], [-118.74109, 34.04872], [-118.74102, 34.0486], [-118.7413, 34.0486]]], [[[-118.74489, 34.04905], [-118.74445, 34.04905], [-118.74445, 34.04894], [-118.7444, 34.04878], [-118.74434, 34.04869], [-118.74427, 34.04861], [-118.74422, 34.04853], [-118.74421, 34.04845], [-118.74422, 34.04832], [-118.74427, 34.04818], [-118.74433, 34.04809], [-118.74436, 34.048], [-118.74436, 34.04789], [-118.74434, 34.04783], [-118.74435, 34.04777], [-118.74439, 34.04771], [-118.74451, 34.04763], [-118.74454, 34.04759], [-118.74456, 34.04752], [-118.74452, 34.0474], [-118.74446, 34.04735], [-118.74439, 34.04731], [-118.7443, 34.04717], [-118.74489, 34.04717], [-118.74489, 34.04905]]], [[[-118.74456, 34.04655], [-118.74451, 34.04662], [-118.74428, 34.04667], [-118.74419, 34.04672], [-118.7441, 34.04682], [-118.74409, 34.04692], [-118.74411, 34.04698], [-118.74427, 34.04729], [-118.74434, 34.04737], [-118.74443, 34.04743], [-118.74443, 34.04746], [-118.74424, 34.04755], [-118.74403, 34.04763], [-118.74397, 34.04767], [-118.74354, 34.04807], [-118.74347, 34.04815], [-118.7433, 34.0485], [-118.74327, 34.0486], [-118.74326, 34.04875], [-118.74332, 34.04905], [-118.74272, 34.04905], [-118.74274, 34.04896], [-118.74273, 34.04889], [-118.7427, 34.04883], [-118.74261, 34.04872], [-118.7426, 34.04861], [-118.74263, 34.04853], [-118.74278, 34.04841], [-118.74284, 34.04831], [-118.74287, 34.04821], [-118.74289, 34.04804], [-118.74292, 34.04795], [-118.74301, 34.04781], [-118.7431, 34.04772], [-118.74314, 34.0477], [-118.74343, 34.04786], [-118.74384, 34.04743], [-118.74384, 34.04733], [-118.74352, 34.04734], [-118.74349, 34.04663], [-118.74353, 34.04654], [-118.74362, 34.04646], [-118.74369, 34.04644], [-118.74383, 34.04643], [-118.74408, 34.04649], [-118.74418, 34.04649], [-118.74428, 34.04646], [-118.74451, 34.04633], [-118.74455, 34.04633], [-118.74456, 34.04655]]], [[[-118.74441, 34.04761], [-118.74432, 34.04768], [-118.74426, 34.04776], [-118.74425, 34.04782], [-118.74428, 34.04796], [-118.74426, 34.04805], [-118.74417, 34.04819], [-118.74412, 34.04838], [-118.74413, 34.0485], [-118.74415, 34.04858], [-118.7443, 34.04877], [-118.74435, 34.04888], [-118.74436, 34.04905], [-118.74341, 34.04905], [-118.74335, 34.04875], [-118.74335, 34.04866], [-118.74337, 34.04857], [-118.74344, 34.0484], [-118.74358, 34.04814], [-118.74402, 34.04772], [-118.74437, 34.04757], [-118.74441, 34.04758], [-118.74441, 34.04761]]], [[[-118.74405, 34.04641], [-118.74385, 34.04636], [-118.74369, 34.04636], [-118.74354, 34.04643], [-118.74347, 34.04649], [-118.74343, 34.04656], [-118.74341, 34.04665], [-118.74343, 34.04734], [-118.74342, 34.04741], [-118.74334, 34.04754], [-118.74326, 34.04759], [-118.74308, 34.04764], [-118.74295, 34.04774], [-118.74283, 34.04797], [-118.74277, 34.04828], [-118.74272, 34.04835], [-118.74259, 34.04846], [-118.74254, 34.04854], [-118.74251, 34.04862], [-118.74252, 34.04868], [-118.74254, 34.04876], [-118.74264, 34.04889], [-118.74265, 34.04896], [-118.74263, 34.04905], [-118.74151, 34.04905], [-118.74163, 34.049], [-118.74168, 34.04896], [-118.74173, 34.0489], [-118.74175, 34.04882], [-118.74174, 34.0487], [-118.74184, 34.04824], [-118.74191, 34.04817], [-118.74208, 34.04812], [-118.74218, 34.04804], [-118.74222, 34.04794], [-118.7422, 34.04776], [-118.74227, 34.04765], [-118.7424, 34.04756], [-118.74266, 34.04752], [-118.74277, 34.04745], [-118.7428, 34.0474], [-118.74282, 34.04734], [-118.74282, 34.04727], [-118.74266, 34.04683], [-118.74266, 34.04668], [-118.74272, 34.04653], [-118.74293, 34.04632], [-118.74297, 34.04621], [-118.74298, 34.04613], [-118.74304, 34.04605], [-118.74316, 34.04597], [-118.74334, 34.04596], [-118.74344, 34.046], [-118.74377, 34.04618], [-118.74387, 34.04621], [-118.74402, 34.04619], [-118.74405, 34.04641]]]]} | Open Access 1 | 7211 | El Nido Open Space Lots | 18520 | 200 | California State Coastal Conservancy 859 | State 5 | State Agency 5 | http://www.scc.ca.gov/ | Other State 5 | 200 | California State Coastal Conservancy 837 | State 5 | State Agency 5 | Los Angeles 6 | 27.385 | El Nido OS Lots | 0 | State Recreation Area 39 | 4 | |
1947 | 1947 | 1946 | {"type": "MultiPolygon", "coordinates": [[[[-118.98159, 36.05067], [-118.98137, 36.05079], [-118.9727, 36.05085], [-118.9718, 36.05081], [-118.97127, 36.05076], [-118.9708, 36.0507], [-118.97091, 36.0439], [-118.98041, 36.04394], [-118.98036, 36.04846], [-118.98039, 36.04883], [-118.98043, 36.04901], [-118.98052, 36.04928], [-118.98064, 36.04953], [-118.98074, 36.0497], [-118.98091, 36.04994], [-118.98105, 36.05009], [-118.98123, 36.05026], [-118.98148, 36.05046], [-118.98159, 36.05067]]], [[[-118.98205, 36.04396], [-118.98203, 36.04531], [-118.98196, 36.05048], [-118.98172, 36.05031], [-118.98148, 36.05012], [-118.98129, 36.04993], [-118.9811, 36.0497], [-118.98094, 36.04945], [-118.98084, 36.04924], [-118.98075, 36.04901], [-118.98068, 36.04874], [-118.98065, 36.04846], [-118.9807, 36.04394], [-118.98205, 36.04396]]]]} | Restricted Access 2 | 29177 | Yaudanchi Ecological Reserve | 27765 | 220 | California Department of Health Services 459 | State 5 | State Agency 5 | http://www.dhcs.ca.gov/Pages/default.aspx | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Tulare 29 | 184.306 | Yaudanchi ER | 0 | State Conservation Area 8 | 2 | |
3538 | 3538 | 3537 | {"type": "MultiPolygon", "coordinates": [[[[-115.82568, 35.02937], [-115.82568, 35.04387], [-115.80655, 35.04385], [-115.80654, 35.02936], [-115.82568, 35.02937]]], [[[-115.82562, 35.11652], [-115.8256, 35.13105], [-115.80662, 35.13104], [-115.80661, 35.11652], [-115.82562, 35.11652]]]]} | Open Access 1 | 28126 | Kelso Peak & Old Dad Mountains Wildlife Area | 30459 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Bernardino 22 | 1383.587 | Kelso Peak & Old Dad Mtns. Wildlife Area | 1989 | State Conservation Area 8 | 2 | |
3672 | 3672 | 3671 | {"type": "MultiPolygon", "coordinates": [[[[-120.44871, 34.6888], [-120.44792, 34.69026], [-120.4478, 34.69035], [-120.44763, 34.69033], [-120.44725, 34.69018], [-120.44662, 34.68998], [-120.44669, 34.6899], [-120.44679, 34.6897], [-120.44724, 34.68935], [-120.44815, 34.68888], [-120.44871, 34.6888]]], [[[-120.4499, 34.69128], [-120.44987, 34.69127], [-120.44986, 34.69126], [-120.44856, 34.69068], [-120.44826, 34.69059], [-120.44812, 34.69043], [-120.44817, 34.69018], [-120.44916, 34.6887], [-120.44971, 34.68869], [-120.44982, 34.68905], [-120.45004, 34.69], [-120.45006, 34.69067], [-120.4499, 34.69128]]]]} | Restricted Access 2 | 29691 | Burton Mesa Ecological Reserve | 16533 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Burton-Mesa-ER | Santa Barbara 7 | 11.989 | Burton Mesa ER | 2004 | State Conservation Area 8 | 2 |
5060 | 5060 | 5059 | {"type": "Polygon", "coordinates": [[[-122.5038, 38.11388], [-122.50155, 38.11561], [-122.50104, 38.11583], [-122.49865, 38.11461], [-122.50105, 38.1126], [-122.50133, 38.11229], [-122.5038, 38.11388]]]} | Open Access 1 | 25328 | Petaluma Marsh Wildlife Area | 30485 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Petaluma-Marsh-WA | Sonoma 16 | 21.886 | Petaluma Marsh Wildlife Area | 1979 | State Conservation Area 8 | 2 |
5105 | 5105 | 5104 | {"type": "Polygon", "coordinates": [[[-123.68414, 40.48042], [-123.67906, 40.48126], [-123.66993, 40.48271], [-123.67004, 40.47815], [-123.6746, 40.47741], [-123.67492, 40.47444], [-123.67959, 40.47359], [-123.67921, 40.47671], [-123.68403, 40.47602], [-123.68414, 40.48042]]]} | No Public Access 3 | 48240 | McClellan Mountain Peatland | 32798 | 212 | California Wildlife Conservation Board 766 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Humboldt 45 | 180.409 | McClellan Mtn. Peatland | 2017 | State Resource Management Area 55 | 3 | |
5757 | 5757 | 5756 | {"type": "Polygon", "coordinates": [[[-118.06308, 33.71148], [-118.0591, 33.71135], [-118.05909, 33.71137], [-118.05916, 33.71145], [-118.0591, 33.71145], [-118.0529, 33.70379], [-118.05255, 33.70376], [-118.05209, 33.70383], [-118.05126, 33.7045], [-118.05053, 33.70499], [-118.04992, 33.70528], [-118.04939, 33.70559], [-118.04839, 33.70627], [-118.04758, 33.70679], [-118.04721, 33.70696], [-118.0473, 33.70706], [-118.04645, 33.70713], [-118.0451, 33.7068], [-118.04429, 33.70664], [-118.04277, 33.7066], [-118.04262, 33.70639], [-118.03926, 33.70783], [-118.03874, 33.70808], [-118.03248, 33.7108], [-118.03236, 33.71026], [-118.0385, 33.70771], [-118.03856, 33.70759], [-118.04008, 33.70696], [-118.04008, 33.70694], [-118.03929, 33.70619], [-118.0362, 33.70457], [-118.0348, 33.70349], [-118.0343, 33.70285], [-118.03222, 33.70268], [-118.03233, 33.70084], [-118.03007, 33.70098], [-118.02774, 33.69924], [-118.02442, 33.69685], [-118.02392, 33.69652], [-118.02288, 33.69605], [-118.02167, 33.69532], [-118.02083, 33.69486], [-118.02092, 33.69004], [-118.0209, 33.68917], [-118.02053, 33.68916], [-118.02115, 33.68814], [-118.02114, 33.68806], [-118.02204, 33.68651], [-118.02221, 33.68641], [-118.02252, 33.68592], [-118.02297, 33.68566], [-118.02347, 33.68548], [-118.02404, 33.68539], [-118.02475, 33.68495], [-118.02488, 33.68482], [-118.02499, 33.68461], [-118.02516, 33.68437], [-118.02565, 33.68424], [-118.02733, 33.68355], [-118.02777, 33.68348], [-118.02863, 33.68372], [-118.03085, 33.6841], [-118.03152, 33.68436], [-118.03221, 33.68471], [-118.03276, 33.68458], [-118.03308, 33.68442], [-118.03319, 33.6839], [-118.0338, 33.68341], [-118.03355, 33.68309], [-118.03361, 33.68286], [-118.03424, 33.68245], [-118.03919, 33.68737], [-118.04395, 33.69223], [-118.04773, 33.69635], [-118.05291, 33.70154], [-118.05401, 33.7027], [-118.05549, 33.70404], [-118.05874, 33.70712], [-118.06037, 33.70878], [-118.06086, 33.70921], [-118.06308, 33.71148]]]} | Restricted Access 2 | 6996 | Bolsa Chica Ecological Reserve | 16245 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Bolsa-Chica-ER | Orange 3 | 1223.82 | Bolsa Chica ER | 1993 | State Conservation Area 8 | 2 |
10300 | 10300 | 10299 | {"type": "MultiPolygon", "coordinates": [[[[-121.4166, 38.10697], [-121.41658, 38.1071], [-121.41658, 38.10718], [-121.41654, 38.10727], [-121.41649, 38.10733], [-121.41352, 38.10959], [-121.41345, 38.10966], [-121.41329, 38.10986], [-121.41314, 38.11017], [-121.41309, 38.11051], [-121.41306, 38.11086], [-121.41306, 38.11273], [-121.4087, 38.11268], [-121.40772, 38.11169], [-121.40755, 38.11144], [-121.40704, 38.11054], [-121.4067, 38.10979], [-121.40642, 38.10903], [-121.40587, 38.10707], [-121.40594, 38.10707], [-121.40595, 38.10705], [-121.40489, 38.10294], [-121.40478, 38.10258], [-121.40463, 38.10222], [-121.40436, 38.10165], [-121.40422, 38.10143], [-121.40227, 38.09786], [-121.40312, 38.09787], [-121.40313, 38.09785], [-121.39776, 38.08767], [-121.397, 38.0879], [-121.39652, 38.08705], [-121.39262, 38.07974], [-121.39268, 38.07974], [-121.39269, 38.07973], [-121.38884, 38.07259], [-121.3888, 38.07249], [-121.39186, 38.07252], [-121.3994, 38.08706], [-121.39951, 38.08723], [-121.40038, 38.08724], [-121.40049, 38.08911], [-121.40077, 38.08961], [-121.40106, 38.08989], [-121.40622, 38.09266], [-121.4081, 38.09343], [-121.4109, 38.09764], [-121.41118, 38.09784], [-121.41096, 38.10704], [-121.4166, 38.10697]]], [[[-121.41306, 38.11303], [-121.41305, 38.11558], [-121.41259, 38.11557], [-121.41024, 38.11559], [-121.41021, 38.11516], [-121.41017, 38.11488], [-121.40998, 38.11424], [-121.40988, 38.11397], [-121.40975, 38.11371], [-121.40954, 38.11337], [-121.40928, 38.11299], [-121.41306, 38.11303]]], [[[-121.41954, 38.13786], [-121.41724, 38.13786], [-121.41381, 38.134], [-121.41345, 38.13357], [-121.41305, 38.13303], [-121.41269, 38.1325], [-121.41236, 38.13193], [-121.41207, 38.13136], [-121.41199, 38.13117], [-121.41174, 38.13059], [-121.41161, 38.13019], [-121.41143, 38.12959], [-121.41134, 38.12919], [-121.41119, 38.12818], [-121.41067, 38.11808], [-121.41051, 38.1175], [-121.41039, 38.11622], [-121.41253, 38.11621], [-121.41249, 38.11736], [-121.413, 38.12793], [-121.41305, 38.12846], [-121.41325, 38.12934], [-121.41348, 38.13003], [-121.41361, 38.13037], [-121.41393, 38.13104], [-121.41411, 38.13136], [-121.4144, 38.13185], [-121.41496, 38.13262], [-121.41954, 38.13786]]], [[[-121.43961, 38.17362], [-121.43921, 38.1738], [-121.43875, 38.17394], [-121.43762, 38.17416], [-121.43724, 38.17421], [-121.42996, 38.16576], [-121.42836, 38.15916], [-121.42882, 38.15905], [-121.43334, 38.15876], [-121.43961, 38.17362]]], [[[-121.45601, 38.21503], [-121.45591, 38.21504], [-121.45589, 38.22256], [-121.456, 38.22258], [-121.45597, 38.22528], [-121.45553, 38.2253], [-121.45514, 38.22529], [-121.45282, 38.2253], [-121.45344, 38.22359], [-121.45349, 38.21124], [-121.45356, 38.20516], [-121.45353, 38.2049], [-121.45288, 38.20489], [-121.45287, 38.20464], [-121.4535, 38.20463], [-121.45599, 38.2047], [-121.45593, 38.21086], [-121.45601, 38.21503]]]]} | Open Access 1 | 18119 | White Slough Wildlife Area | 30521 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Joaquin 39 | 914.831 | White Slough Wildlife Area | 1980 | State Conservation Area 8 | 2 | |
11162 | 11162 | 11161 | {"type": "MultiPolygon", "coordinates": [[[[-115.53127, 34.60212], [-115.5309, 34.61659], [-115.51352, 34.61654], [-115.51389, 34.60204], [-115.53127, 34.60212]]], [[[-115.58217, 34.64587], [-115.58175, 34.66045], [-115.56427, 34.6604], [-115.56455, 34.64577], [-115.58217, 34.64587]]], [[[-115.63218, 34.68946], [-115.6319, 34.70238], [-115.63172, 34.70237], [-115.63169, 34.70379], [-115.61469, 34.70377], [-115.61508, 34.6895], [-115.63218, 34.68946]]], [[[-115.63449, 34.60251], [-115.63407, 34.61698], [-115.61711, 34.617], [-115.6175, 34.60247], [-115.63449, 34.60251]]]]} | Open Access 1 | 25322 | Marble Mountains Wildlife Area | 30470 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Bernardino 22 | 2511.213 | Marble Mtns. Wildlife Area | 1989 | State Conservation Area 8 | 2 | |
11176 | 11176 | 11175 | {"type": "MultiPolygon", "coordinates": [[[[-122.28776, 38.1555], [-122.28693, 38.16063], [-122.28682, 38.16141], [-122.26686, 38.16148], [-122.26672, 38.16113], [-122.26472, 38.16077], [-122.26477, 38.15542], [-122.27349, 38.15548], [-122.28776, 38.1555]]], [[[-122.32898, 38.1936], [-122.3289, 38.19408], [-122.32869, 38.19458], [-122.32562, 38.20049], [-122.3254, 38.2006], [-122.32482, 38.20049], [-122.3228, 38.19815], [-122.32253, 38.19809], [-122.32103, 38.19646], [-122.31788, 38.19266], [-122.31725, 38.19211], [-122.31698, 38.19165], [-122.31684, 38.1911], [-122.31683, 38.19062], [-122.31693, 38.19011], [-122.31695, 38.18973], [-122.31722, 38.18931], [-122.31728, 38.18808], [-122.31719, 38.18758], [-122.31732, 38.18662], [-122.31822, 38.18643], [-122.31895, 38.18637], [-122.31981, 38.18601], [-122.32251, 38.18536], [-122.32282, 38.18534], [-122.32565, 38.18704], [-122.32593, 38.18714], [-122.32734, 38.19124], [-122.32772, 38.19219], [-122.32898, 38.1936]]]]} | Open Access 1 | 25326 | Napa-Sonoma Marshes Wildlife Area | 30478 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Napa-Sonoma-Marshes-WA | Napa 11 | 590.74 | Napa-Sonoma Marshes Wildlife Area | 1953 | State Conservation Area 8 | 2 |
11524 | 11524 | 11523 | {"type": "MultiPolygon", "coordinates": [[[[-121.80139, 36.83624], [-121.80041, 36.83633], [-121.80027, 36.83636], [-121.80012, 36.83642], [-121.79995, 36.83655], [-121.79971, 36.83688], [-121.7995, 36.83724], [-121.79925, 36.83777], [-121.79919, 36.83784], [-121.7991, 36.83789], [-121.799, 36.83791], [-121.7982, 36.83791], [-121.79819, 36.83709], [-121.79848, 36.83654], [-121.79868, 36.83586], [-121.79866, 36.83518], [-121.79844, 36.8349], [-121.79817, 36.83491], [-121.79813, 36.83074], [-121.79879, 36.83073], [-121.79899, 36.83093], [-121.79913, 36.83112], [-121.80064, 36.83479], [-121.80093, 36.83538], [-121.80139, 36.83624]]], [[[-121.80217, 36.83804], [-121.80217, 36.83804], [-121.79919, 36.83804], [-121.7993, 36.83798], [-121.7994, 36.83788], [-121.79964, 36.83739], [-121.7998, 36.8371], [-121.80005, 36.83671], [-121.80016, 36.8366], [-121.80029, 36.83654], [-121.80043, 36.8365], [-121.80148, 36.83639], [-121.8017, 36.83677], [-121.80189, 36.83717], [-121.80204, 36.83758], [-121.80217, 36.83804]]]]} | No Public Access 3 | 48235 | McClusky Slough | 32792 | 212 | California Wildlife Conservation Board 766 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Monterey 14 | 38.897 | McClusky Slough | 1996 | State Conservation Area 8 | 2 | |
11529 | 11529 | 11528 | {"type": "MultiPolygon", "coordinates": [[[[-118.64078, 37.50286], [-118.6391, 37.50286], [-118.63785, 37.50235], [-118.637, 37.50228], [-118.63677, 37.50201], [-118.63603, 37.50216], [-118.63607, 37.49933], [-118.63603, 37.49932], [-118.63601, 37.50215], [-118.63398, 37.50327], [-118.63386, 37.50338], [-118.63381, 37.50347], [-118.6338, 37.50357], [-118.63384, 37.50371], [-118.63394, 37.50383], [-118.63397, 37.50392], [-118.63398, 37.50453], [-118.63395, 37.50469], [-118.63387, 37.50489], [-118.63383, 37.505], [-118.63382, 37.50545], [-118.63376, 37.50545], [-118.63374, 37.49934], [-118.63378, 37.49576], [-118.63149, 37.49576], [-118.6315, 37.49396], [-118.6338, 37.49396], [-118.63383, 37.49216], [-118.64077, 37.49217], [-118.64077, 37.49928], [-118.64076, 37.50283], [-118.64078, 37.50286]]], [[[-118.63498, 37.50563], [-118.63496, 37.50642], [-118.63375, 37.50642], [-118.63375, 37.50562], [-118.63498, 37.50563]]], [[[-118.636, 37.50234], [-118.63598, 37.50626], [-118.63517, 37.50626], [-118.63517, 37.50546], [-118.63403, 37.50545], [-118.63404, 37.50501], [-118.63417, 37.50467], [-118.63419, 37.5045], [-118.63418, 37.50387], [-118.63414, 37.50378], [-118.63403, 37.50364], [-118.63401, 37.50354], [-118.63403, 37.50347], [-118.6341, 37.50341], [-118.636, 37.50234]]]]} | No Public Access 3 | 48236 | Round Valley Wildlife Area | 33312 | 212 | California Wildlife Conservation Board 766 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Mono 32 | 203.625 | Round Valley Wildlife Area | 1993 | State Conservation Area 8 | 2 | |
12264 | 12264 | 12263 | {"type": "Polygon", "coordinates": [[[-122.34065, 38.43479], [-122.33607, 38.43482], [-122.3342, 38.43477], [-122.33024, 38.43188], [-122.31255, 38.42754], [-122.31252, 38.42674], [-122.30773, 38.42655], [-122.30763, 38.4229], [-122.30341, 38.42274], [-122.30339, 38.41911], [-122.30753, 38.41926], [-122.31223, 38.4194], [-122.31238, 38.42307], [-122.31712, 38.42325], [-122.31731, 38.42695], [-122.32649, 38.42714], [-122.3313, 38.42785], [-122.3314, 38.43135], [-122.33603, 38.4315], [-122.33604, 38.43157], [-122.33849, 38.43177], [-122.34057, 38.43186], [-122.34065, 38.43479]]]} | Open Access 1 | 25818 | Rector Reservoir Wildlife Area | 30490 | 206 | California Department of Veterans Affairs 170 | State 5 | State Agency 5 | http://www.cdva.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Napa 11 | 349.564 | Rector Reservoir Wildlife Area | 1998 | State Conservation Area 8 | 2 | |
12455 | 12455 | 12454 | {"type": "Polygon", "coordinates": [[[-121.59051, 38.59963], [-121.58988, 38.60014], [-121.58947, 38.59987], [-121.58912, 38.5999], [-121.58023, 38.60232], [-121.58004, 38.6021], [-121.57981, 38.60196], [-121.57968, 38.60192], [-121.57948, 38.60191], [-121.57928, 38.60195], [-121.57829, 38.60222], [-121.57384, 38.60305], [-121.57343, 38.6031], [-121.57201, 38.60346], [-121.57135, 38.60364], [-121.56337, 38.60595], [-121.56091, 38.60671], [-121.56062, 38.60684], [-121.56037, 38.60693], [-121.5601, 38.60707], [-121.5599, 38.60722], [-121.55559, 38.60276], [-121.55593, 38.60259], [-121.57225, 38.59792], [-121.57589, 38.59754], [-121.5765, 38.5974], [-121.5765, 38.59739], [-121.57618, 38.5968], [-121.57651, 38.59671], [-121.57669, 38.59709], [-121.5767, 38.59749], [-121.57672, 38.5975], [-121.58604, 38.59505], [-121.58605, 38.59504], [-121.58581, 38.59418], [-121.587, 38.59388], [-121.58722, 38.59473], [-121.59051, 38.59963]]]} | Open Access 1 | 28097 | Sacramento Bypass Wildlife Area | 30493 | 219 | Central Valley Flood Protection Board 1027 | State 5 | State Agency 5 | http://www.cvfpb.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Sacramento-Bypass-WA | Yolo 33 | 412.675 | Sacramento Bypass Wildlife Area | 1988 | State Conservation Area 8 | 2 |
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]);