units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
64 rows where ACCESS_TYP = 2, DES_TP = 8 and MNG_AGENCY = 25
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- State Agency 47
MNG_AGENCY 1
- California Department of Fish and Wildlife · 47 ✖
DES_TP 1
- State Conservation Area · 47 ✖
ACCESS_TYP 1
- Restricted Access · 47 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6242 | 6242 | 6241 | {"type": "Polygon", "coordinates": [[[-121.84899, 39.81202], [-121.84437, 39.81198], [-121.84436, 39.81917], [-121.8255, 39.81921], [-121.82538, 39.80767], [-121.82985, 39.80628], [-121.83413, 39.80354], [-121.83631, 39.80463], [-121.83719, 39.80419], [-121.83706, 39.80519], [-121.83795, 39.80893], [-121.83893, 39.80972], [-121.84017, 39.80853], [-121.84017, 39.80608], [-121.84448, 39.7992], [-121.84818, 39.79909], [-121.84876, 39.79968], [-121.84899, 39.81202]]]} | Restricted Access 2 | 23359 | Stone Ridge Ecological Reserve | 25876 | 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 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Stone-Corral-ER | Butte 42 | 749.235 | Stone Ridge ER | 0 | State Conservation Area 8 | 2 |
6316 | 6316 | 6315 | {"type": "MultiPolygon", "coordinates": [[[[-118.8669, 36.28058], [-118.85857, 36.28042], [-118.85009, 36.28028], [-118.85005, 36.26722], [-118.86682, 36.26716], [-118.8669, 36.28058]]], [[[-118.87852, 36.33542], [-118.8742, 36.3354], [-118.87424, 36.34262], [-118.86989, 36.34266], [-118.85062, 36.34313], [-118.85055, 36.32735], [-118.86987, 36.32809], [-118.87846, 36.32824], [-118.87852, 36.33542]]]]} | Restricted Access 2 | 1493 | Blue Ridge Ecological Reserve | 16186 | 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 | Tulare 29 | 1499.176 | Blue Ridge ER | 0 | State Conservation Area 8 | 2 | |
7537 | 7537 | 7536 | {"type": "Polygon", "coordinates": [[[-122.76295, 38.34753], [-122.76209, 38.34714], [-122.76092, 38.34616], [-122.76059, 38.34615], [-122.76022, 38.34574], [-122.76118, 38.34575], [-122.76295, 38.34753]]]} | Restricted Access 2 | 9392 | Theiller Sebastopol Meadowfoam Ecological Reserve | 26298 | 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 | Sonoma 16 | 2.51 | Theiller Sebastopol Meadowfoam ER | 0 | State Conservation Area 8 | 2 | |
7770 | 7770 | 7769 | {"type": "MultiPolygon", "coordinates": [[[[-117.23873, 32.9777], [-117.23873, 32.97825], [-117.23589, 32.97824], [-117.23589, 32.97769], [-117.23873, 32.9777]]], [[[-117.25998, 32.96757], [-117.25996, 32.96761], [-117.25982, 32.96761], [-117.25966, 32.96764], [-117.25895, 32.96787], [-117.25875, 32.96792], [-117.25836, 32.96797], [-117.25808, 32.96798], [-117.25597, 32.96796], [-117.25596, 32.96753], [-117.24944, 32.96745], [-117.24862, 32.96463], [-117.24826, 32.96383], [-117.25164, 32.96386], [-117.25164, 32.96252], [-117.25179, 32.96252], [-117.25257, 32.96267], [-117.2527, 32.96273], [-117.25298, 32.96294], [-117.25311, 32.96301], [-117.2535, 32.96312], [-117.25362, 32.96313], [-117.25382, 32.96311], [-117.25466, 32.96292], [-117.25492, 32.96291], [-117.25509, 32.96295], [-117.25578, 32.96322], [-117.25651, 32.96401], [-117.25644, 32.96406], [-117.25671, 32.96465], [-117.25696, 32.96493], [-117.2575, 32.96525], [-117.25778, 32.9656], [-117.25788, 32.9657], [-117.25801, 32.96577], [-117.25819, 32.96584], [-117.25856, 32.9661], [-117.25869, 32.96652], [-117.259, 32.96693], [-117.25942, 32.96726], [-117.25998, 32.96757]]]]} | Restricted Access 2 | 29610 | San Dieguito Lagoon Ecological Reserve | 24866 | 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 | 102.535 | San Dieguito Lagoon ER | 0 | State Conservation Area 8 | 2 | |
8089 | 8089 | 8088 | {"type": "Polygon", "coordinates": [[[-116.86683, 32.75854], [-116.86219, 32.75853], [-116.86189, 32.75146], [-116.86663, 32.75147], [-116.86683, 32.75854]]]} | Restricted Access 2 | 5008 | McGinty Mountain Ecological Reserve | 22036 | 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 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/McGinty-Mountain-ER | San Diego 4 | 85.161 | McGinty Mtn. ER | 1993 | State Conservation Area 8 | 2 |
9875 | 9875 | 9874 | {"type": "Polygon", "coordinates": [[[-116.92472, 33.30781], [-116.9243, 33.30807], [-116.92002, 33.31102], [-116.91534, 33.31417], [-116.90798, 33.31919], [-116.9001, 33.31615], [-116.90138, 33.31462], [-116.90169, 33.31428], [-116.90255, 33.31327], [-116.90259, 33.31326], [-116.91226, 33.30202], [-116.91289, 33.3024], [-116.9132, 33.30251], [-116.91339, 33.30251], [-116.91357, 33.30246], [-116.9137, 33.3024], [-116.91383, 33.30228], [-116.91391, 33.30216], [-116.91394, 33.30203], [-116.91395, 33.30125], [-116.9139, 33.30096], [-116.91366, 33.30042], [-116.91412, 33.29992], [-116.91452, 33.30019], [-116.91469, 33.30037], [-116.91483, 33.30054], [-116.91525, 33.30125], [-116.91538, 33.3014], [-116.91555, 33.3015], [-116.9157, 33.30152], [-116.9158, 33.30151], [-116.91599, 33.30144], [-116.91708, 33.3031], [-116.91724, 33.30377], [-116.91759, 33.30506], [-116.91361, 33.30706], [-116.91334, 33.3069], [-116.91329, 33.30691], [-116.91257, 33.30685], [-116.91224, 33.30687], [-116.91212, 33.30722], [-116.91201, 33.30831], [-116.91242, 33.30841], [-116.91292, 33.30861], [-116.9133, 33.30875], [-116.91369, 33.30885], [-116.91378, 33.30859], [-116.91457, 33.30832], [-116.91452, 33.30776], [-116.91453, 33.30775], [-116.91491, 33.30756], [-116.91526, 33.30744], [-116.91529, 33.30745], [-116.91544, 33.30741], [-116.91603, 33.30748], [-116.9163, 33.30723], [-116.91691, 33.30711], [-116.91724, 33.30707], [-116.91734, 33.30676], [-116.91757, 33.30649], [-116.91778, 33.30638], [-116.91768, 33.30626], [-116.91788, 33.30613], [-116.91827, 33.30753], [-116.92101, 33.30709], [-116.92362, 33.30718], [-116.92413, 33.30746], [-116.92472, 33.30781]], [[-116.91622, 33.30369], [-116.91648, 33.30389], [-116.91698, 33.30386], [-116.91698, 33.30384], [-116.91676, 33.30355], [-116.91605, 33.30315], [-116.9151, 33.30326], [-116.91509, 33.30331], [-116.91454, 33.30336], [-116.91429, 33.30327], [-116.91332, 33.30301], [-116.913, 33.3028], [-116.91252, 33.30272], [-116.91272, 33.30309], [-116.91295, 33.30328], [-116.91303, 33.30345], [-116.91315, 33.304], [-116.91341, 33.30416], [-116.91438, 33.30421], [-116.91487, 33.3042], [-116.91539, 33.3041], [-116.91542, 33.3038], [-116.91602, 33.30367], [-116.91622, 33.30369]]]} | Restricted Access 2 | 5341 | Plaisted Creek Ecological Reserve | 23767 | 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 | 463.609 | Plaisted Creek ER | 0 | State Conservation Area 8 | 2 | |
10083 | 10083 | 10082 | {"type": "MultiPolygon", "coordinates": [[[[-117.27291, 33.00739], [-117.26287, 33.00739], [-117.26203, 33.00689], [-117.26063, 33.00632], [-117.26066, 33.00626], [-117.26003, 33.00589], [-117.25972, 33.00557], [-117.25947, 33.00491], [-117.25957, 33.00483], [-117.25923, 33.00381], [-117.2588, 33.00344], [-117.25859, 33.00253], [-117.2588, 33.00172], [-117.25872, 33.00139], [-117.25829, 33.0005], [-117.25825, 33.0003], [-117.25846, 33.0003], [-117.2604, 33.00252], [-117.26197, 33.00312], [-117.26213, 33.00334], [-117.26214, 33.00387], [-117.26433, 33.00388], [-117.26433, 33.00262], [-117.26471, 33.00262], [-117.26472, 33.00248], [-117.26513, 33.00249], [-117.26513, 33.00208], [-117.26657, 33.00209], [-117.26659, 33.00211], [-117.2669, 33.00284], [-117.26699, 33.00292], [-117.26713, 33.00294], [-117.26724, 33.00291], [-117.2673, 33.00286], [-117.2678, 33.00198], [-117.26806, 33.00198], [-117.26818, 33.00279], [-117.26812, 33.00299], [-117.26835, 33.00318], [-117.26842, 33.0035], [-117.2686, 33.00363], [-117.26861, 33.00391], [-117.27039, 33.00393], [-117.2704, 33.00381], [-117.27061, 33.00383], [-117.27072, 33.00382], [-117.27089, 33.00376], [-117.27131, 33.00356], [-117.27158, 33.00354], [-117.27197, 33.00355], [-117.2721, 33.00359], [-117.27221, 33.0036], [-117.27223, 33.00361], [-117.2724, 33.00364], [-117.27248, 33.0037], [-117.27258, 33.0037], [-117.27269, 33.00406], [-117.27274, 33.00414], [-117.27287, 33.00423], [-117.27291, 33.00739]], [[-117.26716, 33.00301], [-117.26673, 33.00297], [-117.26688, 33.0036], [-117.26733, 33.00348], [-117.26726, 33.00297], [-117.26716, 33.00301]]], [[[-117.25116, 33.00742], [-117.25114, 33.00903], [-117.25115, 33.01098], [-117.24055, 33.01098], [-117.23939, 33.00941], [-117.2428, 33.00937], [-117.2428, 33.0092], [-117.24294, 33.00923], [-117.24295, 33.00922], [-117.24295, 33.00892], [-117.2428, 33.00883], [-117.24281, 33.00747], [-117.24445, 33.00745], [-117.24444, 33.00563], [-117.24552, 33.00564], [-117.24553, 33.00744], [-117.25116, 33.00742]]], [[[-117.27505, 33.0139], [-117.275, 33.01393], [-117.27475, 33.01377], [-117.27434, 33.01359], [-117.27395, 33.01348], [-117.27374, 33.01345], [-117.27352, 33.01343], [-117.27351, 33.01315], [-117.27319, 33.01314], [-117.27309, 33.01322], [-117.27307, 33.01326], [-117.27304, 33.01336], [-117.27305, 33.01344], [-117.27284, 33.01347], [-117.27256, 33.01347], [-117.27231, 33.01344], [-117.272, 33.01337], [-117.27171, 33.01326], [-117.27134, 33.01306], [-117.27104, 33.01279], [-117.27096, 33.01269], [-117.27083, 33.01249], [-117.27404, 33.01107], [-117.27469, 33.01223], [-117.27472, 33.01331], [-117.27505, 33.0139]]], [[[-117.25907, 33.01465], [-117.25889, 33.01488], [-117.25873, 33.01505], [-117.25836, 33.01536], [-117.25815, 33.0155], [-117.25784, 33.01568], [-117.25757, 33.0158], [-117.25711, 33.01597], [-117.25673, 33.01617], [-117.25651, 33.01633], [-117.25568, 33.01708], [-117.25569, 33.01468], [-117.25907, 33.01465]]], [[[-117.24895, 33.02066], [-117.24723, 33.0218], [-117.24698, 33.0218], [-117.24696, 33.02001], [-117.24894, 33.02002], [-117.24895, 33.02066]]]]} | Restricted Access 2 | 1714 | San Elijo Lagoon Ecological Reserve | 24877 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/San-Elijo-Lagoon-ER | San Diego 4 | 268.615 | San Elijo Lagoon ER | 1983 | State Conservation Area 8 | 2 |
10233 | 10233 | 10232 | {"type": "MultiPolygon", "coordinates": [[[[-117.11031, 32.77957], [-117.11031, 32.77985], [-117.11022, 32.77985], [-117.10974, 32.77983], [-117.1093, 32.77979], [-117.10739, 32.77953], [-117.10841, 32.77919], [-117.10972, 32.77926], [-117.11031, 32.77957]]], [[[-117.11031, 32.78139], [-117.10939, 32.78129], [-117.10874, 32.78124], [-117.1081, 32.78124], [-117.10775, 32.78126], [-117.10736, 32.78131], [-117.10694, 32.78141], [-117.10659, 32.78152], [-117.10623, 32.78166], [-117.1059, 32.78182], [-117.10555, 32.78203], [-117.10524, 32.78226], [-117.10493, 32.78253], [-117.10466, 32.78283], [-117.10441, 32.78318], [-117.10419, 32.78357], [-117.10401, 32.78361], [-117.10399, 32.78228], [-117.104, 32.78071], [-117.10652, 32.77982], [-117.10701, 32.77966], [-117.10938, 32.77999], [-117.10979, 32.78019], [-117.11029, 32.78049], [-117.11027, 32.78101], [-117.11031, 32.78139]]]]} | Restricted Access 2 | 12831 | San Diego River Ecological Reserve | 24863 | 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 | 30.386 | San Diego River ER | 0 | State Conservation Area 8 | 2 | |
10237 | 10237 | 10236 | {"type": "MultiPolygon", "coordinates": [[[[-117.16249, 32.94601], [-117.16193, 32.94655], [-117.16192, 32.94675], [-117.1617, 32.94675], [-117.16137, 32.94705], [-117.16098, 32.94731], [-117.16097, 32.94751], [-117.16067, 32.94766], [-117.15867, 32.94845], [-117.15687, 32.94843], [-117.15688, 32.94911], [-117.1564, 32.9493], [-117.15598, 32.9494], [-117.15555, 32.94946], [-117.15305, 32.94959], [-117.15308, 32.94837], [-117.16054, 32.94596], [-117.16236, 32.94606], [-117.16249, 32.94601]]], [[[-117.16302, 32.94555], [-117.16283, 32.94568], [-117.16267, 32.94582], [-117.16234, 32.94595], [-117.16052, 32.94585], [-117.15309, 32.94825], [-117.1531, 32.94812], [-117.15431, 32.94641], [-117.15674, 32.94598], [-117.15711, 32.94613], [-117.15848, 32.94538], [-117.16225, 32.94328], [-117.163, 32.94474], [-117.16302, 32.94555]]], [[[-117.16592, 32.94474], [-117.16478, 32.94513], [-117.16443, 32.94477], [-117.16477, 32.9446], [-117.16552, 32.94434], [-117.16592, 32.94474]]], [[[-117.16772, 32.94614], [-117.16715, 32.94642], [-117.16635, 32.94573], [-117.16514, 32.94549], [-117.16488, 32.94522], [-117.16604, 32.94483], [-117.16641, 32.94543], [-117.16748, 32.94568], [-117.16772, 32.94614]]], [[[-117.17456, 32.92332], [-117.17351, 32.92332], [-117.17166, 32.92388], [-117.17167, 32.92357], [-117.17186, 32.92346], [-117.17186, 32.92294], [-117.17158, 32.92262], [-117.17207, 32.92214], [-117.17286, 32.92209], [-117.1733, 32.92236], [-117.1735, 32.92254], [-117.17329, 32.92266], [-117.17329, 32.92268], [-117.17456, 32.92332]]]]} | Restricted Access 2 | 13076 | Del Mar Mesa -- Lopez Ridge Ecological Reserve | 18031 | 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 | 84.095 | Del Mar Mesa -- Lopez Ridge ER | 0 | State Conservation Area 8 | 2 | |
10259 | 10259 | 10258 | {"type": "Polygon", "coordinates": [[[-119.85959, 34.42432], [-119.85958, 34.4251], [-119.85929, 34.42511], [-119.8593, 34.42523], [-119.85958, 34.42524], [-119.85956, 34.4273], [-119.85783, 34.42735], [-119.85758, 34.42861], [-119.85608, 34.42866], [-119.85706, 34.43053], [-119.85707, 34.43059], [-119.85041, 34.43096], [-119.85038, 34.42968], [-119.84781, 34.42968], [-119.84772, 34.42807], [-119.85208, 34.42791], [-119.85201, 34.4263], [-119.8449, 34.42644], [-119.83962, 34.42311], [-119.8383, 34.41926], [-119.83522, 34.41979], [-119.83523, 34.41728], [-119.83572, 34.41704], [-119.83597, 34.41681], [-119.83596, 34.41656], [-119.83624, 34.41644], [-119.83795, 34.41587], [-119.83861, 34.41589], [-119.83919, 34.41603], [-119.83978, 34.41639], [-119.8403, 34.41663], [-119.84059, 34.41665], [-119.84147, 34.41655], [-119.84202, 34.41676], [-119.84225, 34.41702], [-119.84254, 34.41719], [-119.84261, 34.41773], [-119.84345, 34.41803], [-119.84388, 34.41787], [-119.84649, 34.41887], [-119.84724, 34.4191], [-119.84777, 34.41943], [-119.84846, 34.41967], [-119.84932, 34.42002], [-119.8494, 34.42008], [-119.84978, 34.42043], [-119.85006, 34.42077], [-119.85049, 34.42106], [-119.85071, 34.4211], [-119.85103, 34.42129], [-119.85145, 34.42146], [-119.85197, 34.42172], [-119.85228, 34.42193], [-119.85231, 34.42208], [-119.85241, 34.42211], [-119.8514, 34.42425], [-119.8514, 34.42427], [-119.85959, 34.42432]]]} | Restricted Access 2 | 16626 | Goleta Slough Ecological Reserve | 19383 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Goleta-Slough-ER | Santa Barbara 7 | 382.363 | Goleta Slough ER | 1983 | State Conservation Area 8 | 2 |
10589 | 10589 | 10588 | {"type": "MultiPolygon", "coordinates": [[[[-121.34073, 39.24328], [-121.34035, 39.24548], [-121.33977, 39.24567], [-121.33914, 39.24568], [-121.33829, 39.24545], [-121.33746, 39.24554], [-121.33646, 39.24403], [-121.33727, 39.24356], [-121.33727, 39.24354], [-121.33569, 39.24244], [-121.33518, 39.24282], [-121.33362, 39.24192], [-121.33193, 39.2432], [-121.33329, 39.24391], [-121.33352, 39.24409], [-121.33381, 39.24428], [-121.334, 39.24437], [-121.33421, 39.24445], [-121.33368, 39.24449], [-121.32452, 39.24449], [-121.32429, 39.23737], [-121.33372, 39.23727], [-121.33371, 39.23987], [-121.33823, 39.23977], [-121.33832, 39.24334], [-121.34073, 39.24328]]], [[[-121.34343, 39.25134], [-121.33819, 39.25143], [-121.33831, 39.25094], [-121.33829, 39.25071], [-121.33774, 39.24915], [-121.33754, 39.24865], [-121.33754, 39.24853], [-121.33763, 39.24828], [-121.33784, 39.2481], [-121.33791, 39.24802], [-121.33808, 39.24791], [-121.33847, 39.24772], [-121.33868, 39.24759], [-121.33896, 39.24774], [-121.33883, 39.24963], [-121.34077, 39.25029], [-121.34343, 39.25028], [-121.34343, 39.25134]]]]} | Restricted Access 2 | 18865 | Daugherty Hill Wildlife Area | 17935 | 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 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Daugherty-Hill-WA | Yuba 25 | 226.328 | Daugherty Hill Wildlife Area | 1991 | State Conservation Area 8 | 2 |
10777 | 10777 | 10776 | {"type": "Polygon", "coordinates": [[[-121.86483, 36.60512], [-121.86235, 36.60664], [-121.86185, 36.60613], [-121.86192, 36.60536], [-121.86232, 36.60488], [-121.86287, 36.60459], [-121.86434, 36.60427], [-121.86483, 36.60512]]]} | Restricted Access 2 | 23364 | Del Monte Dunes Ecological Reserve | 18040 | 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 | Monterey 14 | 9.592 | Del Monte Dunes ER | 0 | State Conservation Area 8 | 2 | |
10876 | 10876 | 10875 | {"type": "MultiPolygon", "coordinates": [[[[-119.80682, 38.86625], [-119.79722, 38.85963], [-119.8053, 38.85961], [-119.79472, 38.85244], [-119.79749, 38.85241], [-119.7975, 38.84901], [-119.8067, 38.849], [-119.8068, 38.85962], [-119.80682, 38.86625]]], [[[-119.81138, 38.86695], [-119.81131, 38.86934], [-119.80784, 38.86695], [-119.81138, 38.86695], [-119.81138, 38.86695]]], [[[-119.82541, 38.8742], [-119.82076, 38.8742], [-119.82075, 38.86696], [-119.82536, 38.86696], [-119.82541, 38.8742]]]]} | Restricted Access 2 | 20781 | Fay Canyon Wildlife Area | 18856 | 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 | Alpine 51 | 356.586 | Fay Canyon Wildlife Area | 0 | State Conservation Area 8 | 2 | |
11131 | 11131 | 11130 | {"type": "MultiPolygon", "coordinates": [[[[-122.30503, 38.22931], [-122.30469, 38.23036], [-122.30378, 38.23118], [-122.30335, 38.23186], [-122.30369, 38.2322], [-122.30335, 38.23229], [-122.29938, 38.23475], [-122.29743, 38.23418], [-122.29593, 38.23482], [-122.29444, 38.23613], [-122.29395, 38.23827], [-122.29305, 38.23889], [-122.29236, 38.23958], [-122.2919, 38.24023], [-122.29152, 38.2409], [-122.29155, 38.24092], [-122.29089, 38.24314], [-122.28887, 38.24275], [-122.28867, 38.24399], [-122.28669, 38.24356], [-122.28632, 38.24342], [-122.28642, 38.24321], [-122.28692, 38.24129], [-122.28711, 38.24095], [-122.28751, 38.23983], [-122.28757, 38.23953], [-122.28764, 38.2394], [-122.28829, 38.23706], [-122.28852, 38.23453], [-122.28901, 38.23328], [-122.28943, 38.23294], [-122.28971, 38.23273], [-122.29017, 38.23246], [-122.29309, 38.23251], [-122.29719, 38.23161], [-122.29783, 38.23116], [-122.29871, 38.23073], [-122.29969, 38.23028], [-122.30054, 38.22959], [-122.30145, 38.22904], [-122.30223, 38.22832], [-122.30402, 38.22748], [-122.30428, 38.22782], [-122.30495, 38.22887], [-122.30503, 38.22931]]], [[[-122.35787, 38.21482], [-122.3576, 38.21731], [-122.3573, 38.21728], [-122.3572, 38.21747], [-122.3571, 38.21757], [-122.35685, 38.21801], [-122.35672, 38.21812], [-122.35619, 38.21935], [-122.35321, 38.22072], [-122.35254, 38.22061], [-122.35251, 38.21998], [-122.3523, 38.21996], [-122.3523, 38.21899], [-122.35271, 38.21898], [-122.3527, 38.21403], [-122.35787, 38.21482]]]]} | Restricted Access 2 | 47978 | Napa-Sonoma Marshes Wildlife Area | 22626 | 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 | Napa 11 | 293.512 | Napa-Sonoma Marshes Wildlife Area | 1953 | State Conservation Area 8 | 2 | |
11552 | 11552 | 11551 | {"type": "Polygon", "coordinates": [[[-116.66912, 32.98862], [-116.65988, 32.98873], [-116.65991, 32.98773], [-116.66058, 32.98745], [-116.66904, 32.98739], [-116.66912, 32.98862]]]} | Restricted Access 2 | 23593 | Boulder Creek Ecological Reserve | 16294 | 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 | 29.218 | Boulder Creek ER | 0 | State Conservation Area 8 | 2 | |
14572 | 14572 | 14571 | {"type": "Polygon", "coordinates": [[[-121.99785, 38.15685], [-121.99598, 38.1576], [-121.99716, 38.15927], [-121.99666, 38.15949], [-121.9971, 38.16029], [-121.99485, 38.16124], [-121.99394, 38.16074], [-121.99091, 38.16057], [-121.99045, 38.16043], [-121.98978, 38.16007], [-121.98937, 38.15959], [-121.98931, 38.15916], [-121.98953, 38.15829], [-121.98946, 38.15811], [-121.98786, 38.15733], [-121.98772, 38.15722], [-121.9876, 38.15658], [-121.98653, 38.1545], [-121.9901, 38.15315], [-121.99235, 38.15279], [-121.99506, 38.1517], [-121.99785, 38.15685]]]} | Restricted Access 2 | 47518 | Grizzly Island Wildlife Area | 19524 | 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/Grizzly-Island-WA | Solano 26 | 161.374 | Grizzly Island Wildlife Area | 1931 | State Conservation Area 8 | 2 |
15520 | 15520 | 15519 | {"type": "Polygon", "coordinates": [[[-121.84233, 38.27135], [-121.84227, 38.27465], [-121.84193, 38.27468], [-121.842, 38.27648], [-121.84228, 38.27646], [-121.84225, 38.2783], [-121.83652, 38.27835], [-121.83656, 38.27647], [-121.83789, 38.27642], [-121.83783, 38.27469], [-121.83544, 38.27473], [-121.83532, 38.27836], [-121.82374, 38.27819], [-121.82374, 38.27777], [-121.82992, 38.27111], [-121.83175, 38.27111], [-121.83725, 38.27124], [-121.83731, 38.2729], [-121.8386, 38.27297], [-121.83861, 38.27296], [-121.83864, 38.27127], [-121.84233, 38.27135]], [[-121.83313, 38.27467], [-121.83319, 38.27276], [-121.83263, 38.27277], [-121.83262, 38.27469], [-121.83313, 38.27467]], [[-121.84011, 38.27472], [-121.84005, 38.27652], [-121.84099, 38.27645], [-121.84107, 38.27469], [-121.84011, 38.27472]]]} | Restricted Access 2 | 18016 | Calhoun Cut Ecological Reserve | 16682 | 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 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Calhoun-Cut-ER | Solano 26 | 238.5 | Calhoun Cut ER | 1993 | State Conservation Area 8 | 2 |
15547 | 15547 | 15546 | {"type": "Polygon", "coordinates": [[[-121.27537, 37.70038], [-121.27531, 37.70044], [-121.27489, 37.70053], [-121.27446, 37.70105], [-121.27439, 37.70129], [-121.27435, 37.70153], [-121.2743, 37.70169], [-121.273, 37.70334], [-121.27198, 37.7052], [-121.27185, 37.7052], [-121.27169, 37.70515], [-121.27161, 37.70499], [-121.27158, 37.70481], [-121.27177, 37.70237], [-121.27183, 37.70201], [-121.27198, 37.70166], [-121.2722, 37.70141], [-121.27359, 37.70014], [-121.27383, 37.69976], [-121.27395, 37.69929], [-121.27448, 37.69948], [-121.27471, 37.6995], [-121.27537, 37.70038]]]} | Restricted Access 2 | 47089 | Vernalis Ecological Reserve | 30745 | 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 | San Joaquin 39 | 20.58 | Vernalis ER | 0 | State Conservation Area 8 | 2 | |
15549 | 15549 | 15548 | {"type": "Polygon", "coordinates": [[[-121.08092, 35.57253], [-121.07853, 35.58086], [-121.07824, 35.58086], [-121.07506, 35.56806], [-121.07741, 35.56778], [-121.07727, 35.56735], [-121.0795, 35.5668], [-121.08092, 35.57253]]]} | Restricted Access 2 | 605 | Cambria Pines Ecological Reserve | 30728 | 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 Luis Obispo 1 | 111.579 | Cambria Pines ER | 0 | State Conservation Area 8 | 2 | |
15555 | 15555 | 15554 | {"type": "MultiPolygon", "coordinates": [[[[-120.44666, 34.69049], [-120.44599, 34.6928], [-120.44179, 34.69993], [-120.44221, 34.70011], [-120.44051, 34.70302], [-120.43901, 34.70566], [-120.43884, 34.7059], [-120.43834, 34.70647], [-120.43697, 34.70782], [-120.43665, 34.70819], [-120.43644, 34.7085], [-120.43632, 34.70873], [-120.43625, 34.7089], [-120.43577, 34.71103], [-120.43555, 34.71163], [-120.43456, 34.71414], [-120.43409, 34.71499], [-120.43347, 34.71492], [-120.42998, 34.71716], [-120.42643, 34.71445], [-120.42585, 34.71417], [-120.42373, 34.71525], [-120.42209, 34.714], [-120.42184, 34.71369], [-120.42185, 34.71336], [-120.42234, 34.71287], [-120.42496, 34.70971], [-120.42635, 34.70842], [-120.42861, 34.70579], [-120.42881, 34.70523], [-120.42941, 34.70419], [-120.42963, 34.70315], [-120.42993, 34.70052], [-120.42935, 34.70052], [-120.42821, 34.70082], [-120.42705, 34.70149], [-120.42766, 34.70301], [-120.42895, 34.70453], [-120.42817, 34.70594], [-120.42714, 34.70695], [-120.42626, 34.7081], [-120.42475, 34.70958], [-120.42261, 34.71216], [-120.42178, 34.71306], [-120.41957, 34.71232], [-120.41641, 34.71162], [-120.41406, 34.70959], [-120.41384, 34.70936], [-120.41205, 34.7107], [-120.41139, 34.7106], [-120.40911, 34.70982], [-120.40478, 34.70877], [-120.40445, 34.70852], [-120.4027, 34.70918], [-120.40179, 34.70895], [-120.40122, 34.7086], [-120.3997, 34.70877], [-120.39969, 34.70911], [-120.39997, 34.70927], [-120.40064, 34.70921], [-120.40088, 34.71063], [-120.4001, 34.7119], [-120.39811, 34.71114], [-120.39825, 34.71039], [-120.39771, 34.71027], [-120.3974, 34.71115], [-120.39676, 34.71108], [-120.39605, 34.70871], [-120.3955, 34.70861], [-120.39385, 34.71047], [-120.39361, 34.71029], [-120.39295, 34.7102], [-120.39281, 34.70974], [-120.39268, 34.70971], [-120.39921, 34.70039], [-120.43003, 34.70038], [-120.43012, 34.70027], [-120.43016, 34.70025], [-120.43048, 34.70038], [-120.43519, 34.70038], [-120.43624, 34.69548], [-120.43806, 34.69578], [-120.43833, 34.69468], [-120.43833, 34.69467], [-120.43649, 34.69435], [-120.43697, 34.69238], [-120.43748, 34.69245], [-120.43807, 34.69246], [-120.43863, 34.69239], [-120.43915, 34.69227], [-120.43949, 34.69214], [-120.43982, 34.69198], [-120.44241, 34.69053], [-120.44275, 34.69038], [-120.4431, 34.69025], [-120.44345, 34.69014], [-120.44382, 34.69005], [-120.44422, 34.68999], [-120.44464, 34.68996], [-120.44666, 34.69049]], [[-120.43518, 34.70137], [-120.43519, 34.70139], [-120.43656, 34.70141], [-120.43659, 34.70058], [-120.43537, 34.70054], [-120.43518, 34.70137]]], [[[-120.48739, 34.70934], [-120.47823, 34.72468], [-120.48366, 34.72688], [-120.48189, 34.72966], [-120.48087, 34.73478], [-120.48019, 34.73463], [-120.47936, 34.73638], [-120.48036, 34.7383], [-120.48031, 34.73845], [-120.47709, 34.74368], [-120.47699, 34.74439], [-120.47691, 34.74825], [-120.46399, 34.74798], [-120.46386, 34.74919], [-120.45136, 34.74237], [-120.46777, 34.74207], [-120.4677, 34.73925], [-120.46961, 34.73923], [-120.47067, 34.73803], [-120.4716, 34.73873], [-120.47293, 34.73788], [-120.4731, 34.73738], [-120.47372, 34.73712], [-120.47347, 34.73658], [-120.47287, 34.73584], [-120.47292, 34.73543], [-120.4725, 34.73463], [-120.4727, 34.73312], [-120.47243, 34.73252], [-120.47241, 34.73251], [-120.47232, 34.73259], [-120.47256, 34.73317], [-120.4722, 34.73383], [-120.47221, 34.7344], [-120.47136, 34.73594], [-120.47037, 34.73578], [-120.47029, 34.73534], [-120.46971, 34.73497], [-120.46882, 34.73378], [-120.46791, 34.73378], [-120.46519, 34.73135], [-120.46413, 34.7303], [-120.46363, 34.72975], [-120.46294, 34.72998], [-120.46178, 34.72976], [-120.46083, 34.72898], [-120.46133, 34.72887], [-120.46163, 34.72834], [-120.4613, 34.72816], [-120.46002, 34.72806], [-120.45941, 34.72676], [-120.46154, 34.72681], [-120.46218, 34.72674], [-120.46219, 34.72673], [-120.46179, 34.72627], [-120.45935, 34.72501], [-120.4592, 34.72477], [-120.4588, 34.72469], [-120.45769, 34.72489], [-120.4546, 34.72414], [-120.45094, 34.72236], [-120.4503, 34.72236], [-120.44433, 34.71965], [-120.44343, 34.7197], [-120.44121, 34.72073], [-120.43986, 34.72023], [-120.43769, 34.71774], [-120.43838, 34.71628], [-120.43731, 34.71613], [-120.43646, 34.71623], [-120.43412, 34.71535], [-120.43474, 34.71421], [-120.43492, 34.7138], [-120.43577, 34.71166], [-120.4385, 34.71162], [-120.44897, 34.71142], [-120.44901, 34.7196], [-120.45212, 34.71959], [-120.45213, 34.72053], [-120.45291, 34.72052], [-120.4529, 34.71958], [-120.46254, 34.71952], [-120.46253, 34.71717], [-120.46266, 34.71697], [-120.46278, 34.71662], [-120.46279, 34.716], [-120.47431, 34.71629], [-120.47473, 34.71427], [-120.47496, 34.71345], [-120.47507, 34.71357], [-120.47531, 34.71376], [-120.47816, 34.71171], [-120.47609, 34.70972], [-120.47591, 34.70957], [-120.47613, 34.70849], [-120.47588, 34.70846], [-120.47549, 34.70801], [-120.47518, 34.70783], [-120.4744, 34.70771], [-120.47319, 34.70767], [-120.47246, 34.70665], [-120.4723, 34.70648], [-120.47114, 34.70572], [-120.4712, 34.70564], [-120.47073, 34.70533], [-120.4706, 34.70517], [-120.47319, 34.70283], [-120.47376, 34.70323], [-120.47466, 34.70377], [-120.47561, 34.70424], [-120.4765, 34.7046], [-120.48044, 34.70569], [-120.48474, 34.70703], [-120.4852, 34.7072], [-120.48562, 34.70742], [-120.48601, 34.70767], [-120.4862, 34.7078], [-120.48654, 34.7081], [-120.48684, 34.70843], [-120.4871, 34.70879], [-120.48722, 34.70898], [-120.48739, 34.70934]]], [[[-120.45279, 34.70126], [-120.44911, 34.70123], [-120.44898, 34.70828], [-120.43672, 34.70842], [-120.43708, 34.70796], [-120.43806, 34.70702], [-120.43879, 34.70625], [-120.4392, 34.70572], [-120.44031, 34.70376], [-120.44065, 34.70311], [-120.44239, 34.70015], [-120.44254, 34.70022], [-120.44256, 34.7002], [-120.44259, 34.7002], [-120.44665, 34.69339], [-120.44692, 34.69309], [-120.44839, 34.6916], [-120.44931, 34.6917], [-120.4495, 34.69174], [-120.45045, 34.69235], [-120.45068, 34.69269], [-120.45086, 34.69303], [-120.45101, 34.69339], [-120.45112, 34.69376], [-120.45118, 34.69414], [-120.45119, 34.69433], [-120.45119, 34.6947], [-120.45114, 34.69507], [-120.45111, 34.69525], [-120.45072, 34.69657], [-120.45069, 34.69666], [-120.4497, 34.69646], [-120.44945, 34.69756], [-120.45035, 34.69775], [-120.45024, 34.69814], [-120.45017, 34.6985], [-120.45016, 34.69869], [-120.45019, 34.69906], [-120.45029, 34.69944], [-120.45037, 34.69963], [-120.45057, 34.69999], [-120.45085, 34.70032], [-120.45118, 34.70061], [-120.45136, 34.70074], [-120.45177, 34.70096], [-120.45199, 34.70105], [-120.45226, 34.70114], [-120.45279, 34.70126]]], [[[-120.44768, 34.6887], [-120.4464, 34.68942], [-120.44618, 34.68969], [-120.44509, 34.68962], [-120.44442, 34.68967], [-120.44441, 34.68969], [-120.44395, 34.68975], [-120.44354, 34.68983], [-120.44316, 34.68993], [-120.44279, 34.69006], [-120.44242, 34.69021], [-120.44206, 34.69039], [-120.43961, 34.69176], [-120.43953, 34.69049], [-120.43741, 34.69045], [-120.43781, 34.68872], [-120.44768, 34.6887]]], [[[-120.46315, 34.70386], [-120.46266, 34.7038], [-120.46218, 34.7037], [-120.46172, 34.70357], [-120.46127, 34.70339], [-120.46094, 34.70323], [-120.4606, 34.70303], [-120.45939, 34.70217], [-120.45902, 34.70192], [-120.45843, 34.70162], [-120.45779, 34.70138], [-120.45735, 34.70126], [-120.45712, 34.70122], [-120.45645, 34.70112], [-120.45579, 34.70109], [-120.45343, 34.70106], [-120.45304, 34.70104], [-120.4526, 34.70098], [-120.4521, 34.70084], [-120.45171, 34.70067], [-120.45137, 34.70044], [-120.45106, 34.70018], [-120.45093, 34.70003], [-120.45082, 34.69988], [-120.45063, 34.69955], [-120.45056, 34.69938], [-120.45051, 34.69921], [-120.45045, 34.69886], [-120.45045, 34.69852], [-120.45048, 34.69835], [-120.45056, 34.69802], [-120.45128, 34.69568], [-120.45138, 34.6953], [-120.45142, 34.6951], [-120.45147, 34.69471], [-120.45147, 34.69432], [-120.45145, 34.69412], [-120.45139, 34.69372], [-120.45128, 34.69333], [-120.45112, 34.69295], [-120.45093, 34.69259], [-120.45078, 34.69236], [-120.45084, 34.69231], [-120.45071, 34.69206], [-120.44986, 34.69129], [-120.44987, 34.69127], [-120.4499, 34.69127], [-120.45006, 34.69067], [-120.45004, 34.69], [-120.44982, 34.68905], [-120.44972, 34.68871], [-120.45852, 34.68876], [-120.45811, 34.69125], [-120.45807, 34.69156], [-120.45806, 34.69186], [-120.45807, 34.69214], [-120.45811, 34.6924], [-120.45835, 34.69304], [-120.45859, 34.69357], [-120.4588, 34.69387], [-120.45945, 34.69455], [-120.45968, 34.69476], [-120.46004, 34.69501], [-120.46063, 34.69533], [-120.46168, 34.69583], [-120.46295, 34.69639], [-120.46317, 34.70172], [-120.46314, 34.70314], [-120.46315, 34.70386]]], [[[-120.46303, 34.68879], [-120.46296, 34.69569], [-120.46296, 34.69569], [-120.46269, 34.69555], [-120.46147, 34.69513], [-120.46077, 34.6948], [-120.46032, 34.69452], [-120.45976, 34.69403], [-120.45956, 34.69383], [-120.45942, 34.69364], [-120.45929, 34.69343], [-120.45911, 34.69308], [-120.45915, 34.69279], [-120.459, 34.69259], [-120.45891, 34.69238], [-120.45882, 34.69198], [-120.45881, 34.6916], [-120.4589, 34.69083], [-120.45905, 34.69005], [-120.45927, 34.68876], [-120.46303, 34.68879]]], [[[-120.5038, 34.68903], [-120.50208, 34.69053], [-120.49417, 34.70347], [-120.49187, 34.70681], [-120.49184, 34.7068], [-120.49183, 34.70682], [-120.48949, 34.70587], [-120.4878, 34.7087], [-120.48778, 34.70868], [-120.48776, 34.70871], [-120.48762, 34.70849], [-120.48731, 34.70807], [-120.48714, 34.70788], [-120.48676, 34.70753], [-120.48656, 34.70737], [-120.48613, 34.70708], [-120.48566, 34.70683], [-120.48517, 34.70661], [-120.48491, 34.70652], [-120.47735, 34.70418], [-120.47703, 34.70407], [-120.47702, 34.70404], [-120.47618, 34.70378], [-120.47529, 34.7034], [-120.47482, 34.70316], [-120.47401, 34.70269], [-120.47209, 34.70136], [-120.47261, 34.70117], [-120.47294, 34.70048], [-120.47309, 34.69951], [-120.47303, 34.69916], [-120.4728, 34.69889], [-120.47244, 34.69864], [-120.47322, 34.69831], [-120.47368, 34.69771], [-120.47376, 34.69728], [-120.47365, 34.69599], [-120.47358, 34.69559], [-120.47314, 34.69529], [-120.47271, 34.69518], [-120.47285, 34.69444], [-120.47332, 34.6945], [-120.47361, 34.69431], [-120.47407, 34.69453], [-120.47453, 34.69435], [-120.4745, 34.69358], [-120.47513, 34.69356], [-120.47543, 34.69344], [-120.47554, 34.69311], [-120.47532, 34.69283], [-120.47497, 34.69278], [-120.47461, 34.69288], [-120.47425, 34.69284], [-120.47364, 34.69267], [-120.47386, 34.69241], [-120.47396, 34.69237], [-120.4752, 34.69148], [-120.47591, 34.69118], [-120.47641, 34.69123], [-120.47683, 34.68887], [-120.47686, 34.68887], [-120.47687, 34.68886], [-120.5038, 34.68903]]]]} | Restricted Access 2 | 1123 | 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 | 5175.151 | Burton Mesa ER | 2004 | 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]);