units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

64 rows where ACCESS_TYP = 2, AGNCY_TYP = 5 and MNG_AGENCY = 25

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_NAME, AGNCY_WEB, LAYER, COUNTY, YR_EST

MNG_AG_TYP 1

MNG_AGENCY 1

  • California Department of Fish and Wildlife · 64 ✖

ACCESS_TYP 1

  • Restricted Access · 64 ✖
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
402 402 401 {"type": "Polygon", "coordinates": [[[-118.76991, 36.21538], [-118.76991, 36.21538], [-118.76726, 36.21538], [-118.76735, 36.21517], [-118.76842, 36.21452], [-118.76948, 36.21436], [-118.76989, 36.21437], [-118.76991, 36.21538]]]} Restricted Access 2 1556 Springville Ecological Reserve 25751 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 4.947 Springville ER 0 State Conservation Area 8 2
467 467 466 {"type": "Polygon", "coordinates": [[[-122.16678, 41.6422], [-122.16586, 41.64234], [-122.15522, 41.64335], [-122.15336, 41.64329], [-122.15338, 41.6426], [-122.15402, 41.64246], [-122.15464, 41.64228], [-122.15675, 41.64146], [-122.15726, 41.64123], [-122.15778, 41.64105], [-122.15814, 41.64095], [-122.15861, 41.64084], [-122.15908, 41.64077], [-122.15956, 41.64072], [-122.16013, 41.64069], [-122.16071, 41.64071], [-122.16118, 41.64076], [-122.16164, 41.64083], [-122.16305, 41.64119], [-122.16522, 41.64179], [-122.16586, 41.64201], [-122.16678, 41.6422]]]} Restricted Access 2 921 Grass Lake Wildlife Area 19448 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   Siskiyou 28 44.169 Grass Lake Wildlife Area 0 State Conservation Area 8 2
631 631 630 {"type": "Polygon", "coordinates": [[[-122.25462, 39.99416], [-122.2544, 40.00129], [-122.25096, 40.00128], [-122.24748, 40.00133], [-122.24757, 39.99403], [-122.24456, 39.99402], [-122.23507, 39.99405], [-122.23535, 39.98688], [-122.23987, 39.98679], [-122.2466, 39.98672], [-122.25062, 39.98668], [-122.25422, 39.9867], [-122.25416, 39.99039], [-122.25416, 39.99414], [-122.25462, 39.99416]]]} Restricted Access 2 4792 Thomes Creek Ecological Reserve 26310 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   Tehama 18 442.371 Thomes Creek ER 0 State Conservation Area 8 2
1522 1522 1521 {"type": "Polygon", "coordinates": [[[-117.23496, 33.27233], [-117.23496, 33.27267], [-117.23179, 33.27604], [-117.23077, 33.27536], [-117.2336, 33.27235], [-117.23496, 33.27233]]]} Restricted Access 2 12834 San Luis Rey River Ecological Reserve 24942 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 14.153 San Luis Rey River ER 0 State Conservation Area 8 2
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
2637 2637 2636 {"type": "Polygon", "coordinates": [[[-122.93426, 38.43681], [-122.93107, 38.43684], [-122.92903, 38.43689], [-122.92899, 38.4368], [-122.92897, 38.4367], [-122.92903, 38.43623], [-122.92908, 38.43609], [-122.92928, 38.43568], [-122.92964, 38.43476], [-122.92971, 38.43446], [-122.92971, 38.43416], [-122.92954, 38.43343], [-122.92954, 38.43324], [-122.93106, 38.43321], [-122.93269, 38.43323], [-122.93271, 38.43595], [-122.93425, 38.43597], [-122.93426, 38.43681]]]} Restricted Access 2 3289 Harrison Grade Ecological Reserve 19698 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 31.802 Harrison Grade ER 0 State Conservation Area 8 2
2782 2782 2781 {"type": "Polygon", "coordinates": [[[-123.95018, 40.54432], [-123.95, 40.54774], [-123.95168, 40.56229], [-123.94988, 40.57504], [-123.93142, 40.57538], [-123.91977, 40.57531], [-123.91927, 40.56181], [-123.91363, 40.56177], [-123.91412, 40.55814], [-123.91933, 40.55809], [-123.91986, 40.5472], [-123.92568, 40.54733], [-123.92481, 40.53266], [-123.92997, 40.53268], [-123.94513, 40.53325], [-123.94448, 40.54416], [-123.95018, 40.54432]]]} Restricted Access 2 21606 Owl Creek Ecological Reserve 23278 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   Humboldt 45 2772.208 Owl Creek ER 0 State Conservation Area 8 2
2891 2891 2890 {"type": "Polygon", "coordinates": [[[-122.27421, 40.4766], [-122.26995, 40.47661], [-122.27039, 40.47569], [-122.26864, 40.47525], [-122.26863, 40.47425], [-122.26907, 40.47419], [-122.26994, 40.47387], [-122.27012, 40.47395], [-122.27418, 40.4704], [-122.27421, 40.4766]]]} Restricted Access 2 18920 Clover Creek Ecological Reserve 17434 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   Shasta 27 46.643 Clover Creek ER 0 State Conservation Area 8 2
3143 3143 3142 {"type": "Polygon", "coordinates": [[[-123.31692, 41.78208], [-123.31238, 41.78212], [-123.31239, 41.78306], [-123.31239, 41.78456], [-123.31192, 41.78442], [-123.31147, 41.78461], [-123.31048, 41.78493], [-123.30981, 41.7853], [-123.30965, 41.78553], [-123.30965, 41.78579], [-123.30984, 41.78586], [-123.31041, 41.78733], [-123.31076, 41.7877], [-123.31092, 41.78773], [-123.31167, 41.78838], [-123.3121, 41.7889], [-123.31224, 41.78911], [-123.3121, 41.79128], [-123.30773, 41.79128], [-123.30674, 41.7913], [-123.30302, 41.79125], [-123.30307, 41.78826], [-123.30306, 41.78463], [-123.30294, 41.78141], [-123.30779, 41.78136], [-123.30782, 41.78299], [-123.31011, 41.78297], [-123.31011, 41.78135], [-123.31238, 41.78128], [-123.31236, 41.77967], [-123.31684, 41.77957], [-123.31692, 41.78208]]]} Restricted Access 2 21593 China Point Ecological Reserve 17203 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   Siskiyou 28 209.418 China Point ER 0 State Conservation Area 8 2
3285 3285 3284 {"type": "Polygon", "coordinates": [[[-120.0828, 38.3461], [-120.08263, 38.35322], [-120.08006, 38.35324], [-120.0736, 38.35313], [-120.07364, 38.35139], [-120.07808, 38.35147], [-120.07829, 38.34769], [-120.07828, 38.34768], [-120.07372, 38.34762], [-120.07376, 38.346], [-120.0828, 38.3461]]]} Restricted Access 2 23368 Sands Meadow 25024 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   Tuolumne 21 114.054 Sands Meadow 0 State Resource Management Area 55 3
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
4070 4070 4069 {"type": "Polygon", "coordinates": [[[-122.26206, 37.57356], [-122.25329, 37.58145], [-122.25329, 37.58145], [-122.25315, 37.58126], [-122.26174, 37.57345], [-122.26206, 37.57356]]]} Restricted Access 2 44448 San Mateo Fishing Pier 24951 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 Mateo 15 7.589 San Mateo Fishing Pier 0 State Recreation Area 39 4
4262 4262 4261 {"type": "Polygon", "coordinates": [[[-121.62968, 39.20461], [-121.62981, 39.20619], [-121.62965, 39.20795], [-121.62916, 39.20791], [-121.62904, 39.20973], [-121.62892, 39.21023], [-121.6284, 39.21125], [-121.62609, 39.21031], [-121.62113, 39.20758], [-121.62141, 39.20654], [-121.62161, 39.20636], [-121.62186, 39.20629], [-121.62207, 39.20629], [-121.62247, 39.20646], [-121.62262, 39.20647], [-121.62275, 39.20645], [-121.62321, 39.20669], [-121.62321, 39.2069], [-121.62365, 39.20717], [-121.62403, 39.2072], [-121.62491, 39.20722], [-121.62613, 39.20712], [-121.62637, 39.20707], [-121.62787, 39.20585], [-121.62845, 39.2055], [-121.6291, 39.20513], [-121.62953, 39.20457], [-121.62968, 39.20461]]]} Restricted Access 2 47979 Feather River Wildlife Area 18861 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   Sutter 47 61.666 Feather River Wildlife Area 1991 State Conservation Area 8 2
5599 5599 5598 {"type": "Polygon", "coordinates": [[[-121.47811, 37.34772], [-121.47387, 37.3477], [-121.46884, 37.34757], [-121.46895, 37.33318], [-121.46053, 37.33314], [-121.46052, 37.33308], [-121.4511, 37.33303], [-121.4422, 37.33311], [-121.44212, 37.3367], [-121.43286, 37.33679], [-121.43288, 37.33629], [-121.43285, 37.33628], [-121.43278, 37.33294], [-121.4237, 37.33291], [-121.42378, 37.32944], [-121.44188, 37.3294], [-121.44189, 37.32584], [-121.43282, 37.32592], [-121.43304, 37.31848], [-121.43306, 37.30399], [-121.44215, 37.30401], [-121.45398, 37.30406], [-121.46945, 37.3042], [-121.46948, 37.31146], [-121.47544, 37.3115], [-121.47528, 37.327], [-121.47514, 37.32718], [-121.4748, 37.3277], [-121.47471, 37.3279], [-121.4747, 37.32801], [-121.47473, 37.32924], [-121.47478, 37.3295], [-121.47473, 37.32951], [-121.47529, 37.33069], [-121.47621, 37.33255], [-121.47625, 37.33392], [-121.47643, 37.33555], [-121.47612, 37.3369], [-121.47647, 37.33844], [-121.477, 37.33945], [-121.47769, 37.3407], [-121.47786, 37.34295], [-121.47808, 37.34527], [-121.47767, 37.34679], [-121.47766, 37.34708], [-121.47811, 37.34772]]]} Restricted Access 2 20680 San Antonio Valley 24836 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5   Santa Clara 19 3259.009 San Antonio Valley 0 State Resource Management Area 55 3
5616 5616 5615 {"type": "Polygon", "coordinates": [[[-121.98643, 41.98971], [-121.98471, 41.98982], [-121.98397, 41.98981], [-121.98405, 41.98862], [-121.98362, 41.98838], [-121.98299, 41.98775], [-121.98219, 41.98654], [-121.98206, 41.9848], [-121.98209, 41.98398], [-121.98344, 41.98364], [-121.98392, 41.98368], [-121.98459, 41.98424], [-121.98537, 41.98492], [-121.98567, 41.98547], [-121.98574, 41.9857], [-121.98581, 41.98656], [-121.98605, 41.98813], [-121.98625, 41.98891], [-121.98643, 41.98971]]]} Restricted Access 2 2421 Mud Lake Wildlife Area 22583 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   Siskiyou 28 40.351 Mud Lake Wildlife Area 0 State Conservation Area 8 2
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
5846 5846 5845 {"type": "Polygon", "coordinates": [[[-123.25549, 38.89635], [-123.24599, 38.90389], [-123.24056, 38.90437], [-123.24061, 38.90254], [-123.2406, 38.89715], [-123.24069, 38.8935], [-123.24608, 38.89273], [-123.24609, 38.89637], [-123.25549, 38.89635]]]} Restricted Access 2 21623 Yorkville Ecological Reserve 27781 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   Mendocino 24 226.535 Yorkville ER 0 State Conservation Area 8 2
6188 6188 6187 {"type": "Polygon", "coordinates": [[[-118.81911, 36.36224], [-118.81837, 36.36643], [-118.81325, 36.3665], [-118.81331, 36.3666], [-118.81367, 36.3667], [-118.8139, 36.36703], [-118.80688, 36.3671], [-118.80404, 36.36685], [-118.80466, 36.36608], [-118.80756, 36.36631], [-118.81069, 36.36259], [-118.8113, 36.36337], [-118.81146, 36.36387], [-118.81161, 36.36413], [-118.81196, 36.36425], [-118.81237, 36.36429], [-118.81278, 36.36423], [-118.81313, 36.36425], [-118.81339, 36.3643], [-118.8143, 36.36459], [-118.81486, 36.36464], [-118.81543, 36.36452], [-118.81601, 36.36424], [-118.81643, 36.3637], [-118.81693, 36.36319], [-118.81792, 36.36255], [-118.81911, 36.36224]]]} Restricted Access 2 1503 Kaweah Ecological Reserve 20561 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 83.672 Kaweah ER 0 State Conservation Area 8 2
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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);