units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
54 rows where ACCESS_TYP = 2, AGNCY_NAME = 25, MNG_AGENCY = 25 and MNG_AG_TYP = 5
This data as json, copyable, CSV (advanced)
Suggested facets: COUNTY, GAP_STS
DES_TP 4
MNG_AG_TYP 1
- State Agency · 54 ✖
MNG_AGENCY 1
- California Department of Fish and Wildlife · 54 ✖
ACCESS_TYP 1
- Restricted Access · 54 ✖
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 | |
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 | |
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 | |
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 | |
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 |
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]);