units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
72 rows where DES_TP = 55 and MNG_AGENCY = 25 sorted by COUNTY
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, LAYER, YR_EST
ACCESS_TYP 3
MNG_AG_TYP 1
- State Agency 72
MNG_AGENCY 1
- California Department of Fish and Wildlife · 72 ✖
DES_TP 1
- State Resource Management Area · 72 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14333 | 14333 | 14332 | {"type": "MultiPolygon", "coordinates": [[[[-119.95169, 35.34039], [-119.95158, 35.34385], [-119.94704, 35.34383], [-119.947, 35.3511], [-119.93381, 35.35103], [-119.93382, 35.34373], [-119.94283, 35.34379], [-119.94285, 35.34034], [-119.95169, 35.34039]]], [[[-119.96505, 35.33683], [-119.96502, 35.344], [-119.96043, 35.34409], [-119.96043, 35.3477], [-119.9559, 35.34767], [-119.95603, 35.34409], [-119.96042, 35.34409], [-119.96057, 35.33683], [-119.96505, 35.33683]]], [[[-119.98747, 35.33683], [-119.98735, 35.34411], [-119.96942, 35.34398], [-119.96961, 35.33682], [-119.98747, 35.33683]]], [[[-120.11221, 35.42515], [-120.11212, 35.43976], [-120.07625, 35.43965], [-120.07684, 35.425], [-120.05856, 35.4248], [-120.05869, 35.41023], [-120.04079, 35.41018], [-120.04076, 35.39937], [-120.03647, 35.39935], [-120.03645, 35.40289], [-120.03174, 35.40286], [-120.03178, 35.39558], [-120.02291, 35.39551], [-120.02283, 35.39752], [-120.01828, 35.39748], [-120.0183, 35.39549], [-120.01409, 35.39544], [-120.0141, 35.39176], [-120.01834, 35.39181], [-120.0183, 35.39548], [-120.01842, 35.39548], [-120.01843, 35.38431], [-120.01407, 35.3843], [-120.01398, 35.40633], [-120.02291, 35.40637], [-120.02291, 35.41006], [-120.01397, 35.4101], [-120.01396, 35.40745], [-119.98714, 35.40745], [-119.98723, 35.39547], [-119.98728, 35.38073], [-119.98721, 35.36616], [-120.00498, 35.36619], [-120.00533, 35.3516], [-120.03916, 35.35179], [-120.03919, 35.35942], [-120.03263, 35.35936], [-120.03223, 35.35888], [-120.03236, 35.35539], [-120.03276, 35.35491], [-120.03265, 35.35331], [-120.02691, 35.35331], [-120.02685, 35.35475], [-120.02724, 35.35502], [-120.02737, 35.38091], [-120.02717, 35.38092], [-120.02729, 35.3881], [-120.03183, 35.38814], [-120.03182, 35.38883], [-120.03183, 35.38884], [-120.03414, 35.38879], [-120.03698, 35.38817], [-120.04584, 35.38823], [-120.04587, 35.39171], [-120.04986, 35.39171], [-120.0499, 35.39568], [-120.0588, 35.39569], [-120.05897, 35.38872], [-120.06823, 35.38878], [-120.06818, 35.3957], [-120.08401, 35.39576], [-120.084, 35.40312], [-120.09426, 35.40318], [-120.09436, 35.42495], [-120.11221, 35.42515]], [[-120.00951, 35.36991], [-120.00952, 35.3699], [-120.00951, 35.36985], [-120.00509, 35.36985], [-120.00507, 35.36913], [-120.00505, 35.36913], [-120.00507, 35.3699], [-120.00951, 35.36991]], [[-120.01411, 35.38086], [-120.01412, 35.38085], [-120.0141, 35.38006], [-120.01409, 35.38085], [-120.01411, 35.38086]]], [[[-120.04067, 35.38442], [-120.03626, 35.3844], [-120.03623, 35.38094], [-120.04065, 35.38097], [-120.04067, 35.38442]]], [[[-120.09453, 35.35203], [-120.09446, 35.35604], [-120.09433, 35.35941], [-120.0943, 35.36646], [-120.08626, 35.36648], [-120.07741, 35.36647], [-120.07697, 35.36631], [-120.07702, 35.35933], [-120.07701, 35.35682], [-120.07617, 35.35678], [-120.07177, 35.35231], [-120.07016, 35.35227], [-120.07016, 35.35184], [-120.06997, 35.34965], [-120.06845, 35.34954], [-120.06851, 35.34831], [-120.0667, 35.34825], [-120.06668, 35.34663], [-120.06482, 35.34664], [-120.06478, 35.34488], [-120.0647, 35.3448], [-120.05734, 35.3449], [-120.05727, 35.34647], [-120.0543, 35.34645], [-120.05427, 35.34491], [-120.05033, 35.34496], [-120.0502, 35.34824], [-120.04715, 35.3482], [-120.04698, 35.3597], [-120.04063, 35.3597], [-120.04082, 35.33879], [-120.04089, 35.33879], [-120.05021, 35.34175], [-120.05287, 35.34161], [-120.0528, 35.33703], [-120.07704, 35.33706], [-120.07698, 35.35187], [-120.09453, 35.35203]]], [[[-120.09423, 35.37925], [-120.09423, 35.38101], [-120.09421, 35.38124], [-120.08206, 35.38118], [-120.08205, 35.38115], [-120.07786, 35.38119], [-120.0779, 35.37486], [-120.07979, 35.37486], [-120.08205, 35.37552], [-120.08204, 35.36856], [-120.08214, 35.3686], [-120.08215, 35.37614], [-120.09141, 35.37927], [-120.09423, 35.37925]]]]} | No Public Access 3 | 44336 | California Valley | 32084 | 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 | 12379.201 | California Valley | 0 | State Resource Management Area 55 | 3 | |
11551 | 11551 | 11550 | {"type": "MultiPolygon", "coordinates": [[[[-120.48135, 37.664], [-120.48132, 37.6642], [-120.48125, 37.66437], [-120.4811, 37.66452], [-120.48045, 37.66487], [-120.48026, 37.66491], [-120.48014, 37.66503], [-120.48008, 37.66532], [-120.48024, 37.66591], [-120.48028, 37.66614], [-120.4798, 37.66635], [-120.47901, 37.66496], [-120.4796, 37.66459], [-120.48005, 37.664], [-120.48135, 37.664]]], [[[-120.4855, 37.66112], [-120.48408, 37.66265], [-120.48188, 37.66423], [-120.48187, 37.66342], [-120.48365, 37.66179], [-120.48456, 37.66139], [-120.4855, 37.66112]]], [[[-120.49114, 37.6524], [-120.49083, 37.65283], [-120.48841, 37.65436], [-120.48773, 37.65488], [-120.48736, 37.65553], [-120.48638, 37.65828], [-120.48687, 37.65881], [-120.48684, 37.65947], [-120.48661, 37.65996], [-120.48558, 37.66106], [-120.48505, 37.66093], [-120.48574, 37.65927], [-120.48583, 37.65912], [-120.48578, 37.65798], [-120.48685, 37.65542], [-120.48765, 37.65458], [-120.48824, 37.6535], [-120.48889, 37.65314], [-120.48929, 37.65245], [-120.49114, 37.6524]]]]} | No Public Access 3 | 23600 | Basso Bridge | 32041 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Stanislaus 2 | 31.439 | Basso Bridge | 0 | State Resource Management Area 55 | 3 | |
11554 | 11554 | 11553 | {"type": "MultiPolygon", "coordinates": [[[[-120.46637, 37.67093], [-120.46627, 37.67096], [-120.4649, 37.67043], [-120.46452, 37.67036], [-120.46422, 37.67034], [-120.46391, 37.67037], [-120.46374, 37.67043], [-120.46357, 37.67055], [-120.46341, 37.67063], [-120.46314, 37.67068], [-120.46213, 37.67076], [-120.46214, 37.67027], [-120.46115, 37.67021], [-120.46377, 37.66765], [-120.46387, 37.66767], [-120.46572, 37.66924], [-120.46572, 37.67028], [-120.46573, 37.67039], [-120.46637, 37.67093]]], [[[-120.47, 37.67073], [-120.4698, 37.67089], [-120.46926, 37.67122], [-120.46909, 37.67148], [-120.46782, 37.67211], [-120.4673, 37.67142], [-120.46658, 37.67102], [-120.46658, 37.67092], [-120.46631, 37.67072], [-120.46592, 37.67012], [-120.46593, 37.6699], [-120.46681, 37.66927], [-120.46608, 37.66859], [-120.46725, 37.6686], [-120.4673, 37.67023], [-120.4681, 37.6702], [-120.46898, 37.67032], [-120.47, 37.67073]]]]} | No Public Access 3 | 23601 | Tuolumne River Restoration Center | 32331 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Stanislaus 2 | 33.932 | Tuolumne River Restoration Ctr. | 0 | State Resource Management Area 55 | 3 | |
3675 | 3675 | 3674 | {"type": "Polygon", "coordinates": [[[-117.5972, 33.67495], [-117.59564, 33.67532], [-117.59561, 33.6788], [-117.59438, 33.67879], [-117.59174, 33.67873], [-117.59136, 33.67839], [-117.59108, 33.67825], [-117.58996, 33.67822], [-117.58984, 33.67353], [-117.58986, 33.67178], [-117.59522, 33.6718], [-117.59706, 33.67178], [-117.59708, 33.6737], [-117.59716, 33.67436], [-117.5972, 33.67495]]]} | No Public Access 3 | 44353 | Trabuco Canyon | 32328 | 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 | Orange 3 | 112.275 | Trabuco Canyon | 0 | State Resource Management Area 55 | 3 | |
3678 | 3678 | 3677 | {"type": "Polygon", "coordinates": [[[-117.17431, 33.05469], [-117.17231, 33.05468], [-117.17229, 33.05456], [-117.17224, 33.05445], [-117.17216, 33.05434], [-117.17206, 33.05426], [-117.17194, 33.05419], [-117.17181, 33.05416], [-117.17142, 33.05413], [-117.17121, 33.05407], [-117.17104, 33.05396], [-117.17068, 33.05363], [-117.17054, 33.05374], [-117.17047, 33.05382], [-117.1704, 33.05399], [-117.17038, 33.05408], [-117.1704, 33.05417], [-117.17059, 33.05467], [-117.17004, 33.05467], [-117.16999, 33.05106], [-117.172, 33.05106], [-117.17202, 33.0523], [-117.17429, 33.0523], [-117.17431, 33.05469]]]} | No Public Access 3 | 44356 | Escondido Creek | 32162 | 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.504 | Escondido Creek | 0 | State Resource Management Area 55 | 3 | |
6243 | 6243 | 6242 | {"type": "Polygon", "coordinates": [[[-116.96211, 32.96295], [-116.95351, 32.96324], [-116.95342, 32.95961], [-116.94888, 32.95974], [-116.94878, 32.95602], [-116.94045, 32.9561], [-116.94043, 32.95977], [-116.93185, 32.95964], [-116.93185, 32.95601], [-116.92761, 32.95596], [-116.92763, 32.95203], [-116.93186, 32.95198], [-116.93182, 32.94121], [-116.92765, 32.94122], [-116.92248, 32.94033], [-116.9225, 32.94032], [-116.92218, 32.93627], [-116.92764, 32.93755], [-116.92764, 32.93401], [-116.93615, 32.93378], [-116.93618, 32.93562], [-116.94046, 32.93556], [-116.94047, 32.93366], [-116.9447, 32.93354], [-116.94886, 32.93352], [-116.94892, 32.94093], [-116.95334, 32.9409], [-116.9534, 32.94251], [-116.95366, 32.94251], [-116.95404, 32.94257], [-116.95419, 32.94253], [-116.95424, 32.9425], [-116.95433, 32.94237], [-116.95436, 32.94199], [-116.95436, 32.94189], [-116.95434, 32.94179], [-116.95417, 32.94158], [-116.95413, 32.94147], [-116.95414, 32.94141], [-116.95421, 32.94125], [-116.9543, 32.94118], [-116.95462, 32.94098], [-116.95478, 32.94093], [-116.9549, 32.9409], [-116.95518, 32.94089], [-116.95541, 32.94094], [-116.95553, 32.94095], [-116.95568, 32.94125], [-116.95518, 32.94132], [-116.95504, 32.94139], [-116.95494, 32.94146], [-116.95486, 32.94158], [-116.95481, 32.94169], [-116.95481, 32.94184], [-116.95484, 32.94192], [-116.95488, 32.94211], [-116.95483, 32.94232], [-116.95478, 32.94241], [-116.9547, 32.94251], [-116.95461, 32.94259], [-116.95445, 32.94268], [-116.95429, 32.94272], [-116.95411, 32.94274], [-116.95366, 32.94268], [-116.95324, 32.94271], [-116.95308, 32.94269], [-116.95286, 32.94263], [-116.9527, 32.94263], [-116.95253, 32.94268], [-116.9524, 32.94276], [-116.9513, 32.94378], [-116.95115, 32.94389], [-116.95109, 32.94392], [-116.95165, 32.94469], [-116.94886, 32.94473], [-116.94889, 32.95222], [-116.95298, 32.9522], [-116.95323, 32.95222], [-116.95318, 32.94851], [-116.95783, 32.94845], [-116.95798, 32.95947], [-116.96207, 32.95939], [-116.96211, 32.96295]]]} | No Public Access 3 | 1316 | San Vicente Highlands | 32296 | 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 | 1545.08 | San Vicente Highlands | 0 | State Resource Management Area 55 | 3 | |
12161 | 12161 | 12160 | {"type": "MultiPolygon", "coordinates": [[[[-116.89905, 32.95333], [-116.89, 32.95344], [-116.88151, 32.95355], [-116.8816, 32.96148], [-116.88116, 32.9615], [-116.88115, 32.96152], [-116.885, 32.9652], [-116.88908, 32.96899], [-116.88886, 32.96915], [-116.88806, 32.96953], [-116.88748, 32.96988], [-116.88714, 32.97015], [-116.88637, 32.97047], [-116.88496, 32.97038], [-116.88394, 32.97102], [-116.88384, 32.97134], [-116.88348, 32.97175], [-116.88356, 32.97201], [-116.88313, 32.97251], [-116.88289, 32.97259], [-116.88262, 32.97308], [-116.88259, 32.97326], [-116.88268, 32.9735], [-116.8831, 32.97377], [-116.88302, 32.97416], [-116.883, 32.9744], [-116.88309, 32.97464], [-116.88333, 32.97482], [-116.88365, 32.97502], [-116.88396, 32.9752], [-116.8848, 32.97528], [-116.88502, 32.97532], [-116.88523, 32.97541], [-116.8854, 32.97555], [-116.88529, 32.97581], [-116.88538, 32.97593], [-116.88558, 32.97612], [-116.88559, 32.97621], [-116.88546, 32.97641], [-116.88497, 32.9773], [-116.88513, 32.97767], [-116.88546, 32.97779], [-116.88569, 32.97807], [-116.88589, 32.97851], [-116.88585, 32.97869], [-116.88572, 32.97887], [-116.88574, 32.97923], [-116.88615, 32.98011], [-116.88646, 32.98026], [-116.88664, 32.98061], [-116.88691, 32.98074], [-116.88704, 32.98091], [-116.8871, 32.98113], [-116.88712, 32.98177], [-116.88739, 32.98276], [-116.88724, 32.98301], [-116.88737, 32.98363], [-116.88727, 32.98413], [-116.88743, 32.98493], [-116.88738, 32.98527], [-116.88734, 32.98618], [-116.88744, 32.98643], [-116.88739, 32.98664], [-116.88719, 32.98685], [-116.88719, 32.98709], [-116.88736, 32.98767], [-116.88731, 32.98807], [-116.8875, 32.98843], [-116.88729, 32.98881], [-116.88741, 32.98924], [-116.88717, 32.98984], [-116.88666, 32.99058], [-116.88661, 32.99098], [-116.88658, 32.99111], [-116.88666, 32.99133], [-116.88665, 32.9917], [-116.88654, 32.99221], [-116.88662, 32.99234], [-116.8864, 32.9939], [-116.87774, 32.99394], [-116.87771, 32.99394], [-116.8777, 32.99389], [-116.87565, 32.99388], [-116.87531, 32.98531], [-116.86673, 32.98548], [-116.86689, 32.99385], [-116.85049, 32.99367], [-116.85066, 32.99357], [-116.85055, 32.99344], [-116.85028, 32.99359], [-116.85006, 32.99368], [-116.8499, 32.99368], [-116.84983, 32.99285], [-116.84955, 32.98892], [-116.8484, 32.98898], [-116.84841, 32.98896], [-116.84841, 32.98895], [-116.84131, 32.98865], [-116.84128, 32.97835], [-116.84039, 32.96417], [-116.84829, 32.96324], [-116.84847, 32.94951], [-116.85033, 32.95109], [-116.85343, 32.95285], [-116.8537, 32.95281], [-116.85377, 32.95285], [-116.85671, 32.95243], [-116.85752, 32.95367], [-116.85831, 32.95552], [-116.85917, 32.95623], [-116.85986, 32.95615], [-116.86132, 32.95637], [-116.86287, 32.95522], [-116.86398, 32.95328], [-116.8659, 32.95241], [-116.86586, 32.95523], [-116.8735, 32.95511], [-116.87459, 32.95514], [-116.88011, 32.94845], [-116.87784, 32.94618], [-116.88568, 32.94618], [-116.88564, 32.94202], [-116.88949, 32.94174], [-116.89438, 32.94175], [-116.8944, 32.94591], [-116.89892, 32.94576], [-116.89905, 32.95333]], [[-116.85013, 32.98801], [-116.85065, 32.98657], [-116.84949, 32.98657], [-116.84954, 32.98837], [-116.84974, 32.98835], [-116.84991, 32.98827], [-116.85005, 32.98815], [-116.85013, 32.98801]]], [[[-116.90039, 32.98023], [-116.89618, 32.98029], [-116.89653, 32.98476], [-116.89236, 32.98489], [-116.89283, 32.98927], [-116.89317, 32.99393], [-116.88879, 32.99392], [-116.88686, 32.9939], [-116.88696, 32.99365], [-116.88691, 32.99352], [-116.88678, 32.9933], [-116.88692, 32.99229], [-116.88684, 32.99216], [-116.88694, 32.99173], [-116.88695, 32.9913], [-116.88688, 32.9911], [-116.88694, 32.99065], [-116.88743, 32.98995], [-116.88772, 32.98926], [-116.8876, 32.98884], [-116.88782, 32.98844], [-116.88761, 32.98803], [-116.88766, 32.98766], [-116.88748, 32.98706], [-116.88748, 32.98694], [-116.88767, 32.98674], [-116.88774, 32.98642], [-116.88764, 32.98615], [-116.88768, 32.98529], [-116.88772, 32.98492], [-116.88757, 32.98413], [-116.88767, 32.98363], [-116.88754, 32.98305], [-116.8877, 32.98279], [-116.88741, 32.98174], [-116.88739, 32.98111], [-116.88732, 32.98082], [-116.88711, 32.98055], [-116.88687, 32.98044], [-116.88669, 32.98009], [-116.88639, 32.97994], [-116.88603, 32.97917], [-116.88601, 32.97894], [-116.88614, 32.97878], [-116.88619, 32.97848], [-116.88595, 32.97795], [-116.88565, 32.97759], [-116.88537, 32.97748], [-116.88529, 32.97731], [-116.88572, 32.97653], [-116.88585, 32.97632], [-116.88591, 32.97618], [-116.88589, 32.97611], [-116.88568, 32.97589], [-116.88562, 32.97577], [-116.88574, 32.97564], [-116.88576, 32.97544], [-116.88552, 32.97514], [-116.88519, 32.97496], [-116.88454, 32.97497], [-116.88416, 32.97491], [-116.88367, 32.97459], [-116.88342, 32.97445], [-116.88331, 32.97435], [-116.88341, 32.97379], [-116.88335, 32.97365], [-116.88297, 32.97336], [-116.88293, 32.97329], [-116.88292, 32.97323], [-116.88293, 32.97317], [-116.88313, 32.97282], [-116.88333, 32.97276], [-116.8839, 32.97204], [-116.88384, 32.97183], [-116.88416, 32.9715], [-116.88425, 32.97121], [-116.88509, 32.97067], [-116.88647, 32.97077], [-116.88707, 32.97049], [-116.88737, 32.97033], [-116.88772, 32.97009], [-116.88829, 32.96974], [-116.88913, 32.96933], [-116.88931, 32.9692], [-116.89119, 32.97093], [-116.89186, 32.97159], [-116.89141, 32.97351], [-116.89084, 32.97584], [-116.9001, 32.97586], [-116.90039, 32.98023]]]]} | No Public Access 3 | 25240 | Canada de San Vicente | 32091 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Diego 4 | 4998.226 | Canada de San Vicente | 0 | State Resource Management Area 55 | 3 | |
3427 | 3427 | 3426 | {"type": "Polygon", "coordinates": [[[-122.01238, 36.97053], [-122.01187, 36.97081], [-122.01185, 36.97079], [-122.01191, 36.97056], [-122.01223, 36.97036], [-122.01238, 36.97053]]]} | No Public Access 3 | 25174 | South Branciforte | 32313 | 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 Cruz 5 | 0.251 | South Branciforte | 0 | State Resource Management Area 55 | 3 | |
14340 | 14340 | 14339 | {"type": "Polygon", "coordinates": [[[-121.94459, 36.97664], [-121.94396, 36.97675], [-121.94326, 36.97677], [-121.94325, 36.9766], [-121.94341, 36.97632], [-121.94317, 36.97587], [-121.94331, 36.97591], [-121.94353, 36.97635], [-121.9438, 36.97644], [-121.94437, 36.97649], [-121.94459, 36.97664]]]} | No Public Access 3 | 44373 | Escalona Gulch | 32161 | 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 Cruz 5 | 1.02 | Escalona Gulch | 0 | State Resource Management Area 55 | 3 | |
1362 | 1362 | 1361 | {"type": "MultiPolygon", "coordinates": [[[[-120.54592, 36.6911], [-120.53904, 36.69108], [-120.53903, 36.68751], [-120.53931, 36.68748], [-120.53932, 36.67661], [-120.53965, 36.67662], [-120.54592, 36.6911]]], [[[-120.54644, 36.69054], [-120.54632, 36.69071], [-120.54625, 36.69074], [-120.54003, 36.67662], [-120.54028, 36.67664], [-120.54644, 36.69054]]]]} | No Public Access 3 | 8074 | Pilobos | 32263 | 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 | Fresno 9 | 134.36 | Pilobos | 0 | State Resource Management Area 55 | 3 | |
7132 | 7132 | 7131 | {"type": "MultiPolygon", "coordinates": [[[[-119.41323, 36.78389], [-119.41298, 36.78429], [-119.41297, 36.78478], [-119.41308, 36.78757], [-119.41299, 36.78847], [-119.41167, 36.78916], [-119.4116, 36.78454], [-119.40887, 36.78451], [-119.40928, 36.78346], [-119.41097, 36.78354], [-119.411, 36.7831], [-119.41, 36.78308], [-119.41079, 36.78223], [-119.41154, 36.78298], [-119.41323, 36.78389]]], [[[-119.41291, 36.78956], [-119.41289, 36.7902], [-119.41169, 36.79021], [-119.41169, 36.79009], [-119.41163, 36.79008], [-119.41163, 36.78953], [-119.41265, 36.78953], [-119.41266, 36.78957], [-119.41291, 36.78956]]]]} | Open Access 1 | 6750 | Avocado Lake | 32030 | 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 | Fresno 9 | 29.362 | Avocado Lake | 0 | State Resource Management Area 55 | 3 | |
1581 | 1581 | 1580 | {"type": "Polygon", "coordinates": [[[-115.54599, 33.539], [-115.53693, 33.53898], [-115.53689, 33.53374], [-115.53922, 33.53373], [-115.53931, 33.53565], [-115.54152, 33.53564], [-115.54145, 33.53741], [-115.54597, 33.53769], [-115.54599, 33.539]]]} | No Public Access 3 | 12128 | Chuckwalla Bench | 32115 | 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 | Riverside 10 | 66.962 | Chuckwalla Bench | 0 | State Resource Management Area 55 | 3 | |
6386 | 6386 | 6385 | {"type": "Polygon", "coordinates": [[[-117.52541, 33.96645], [-117.52323, 33.96645], [-117.52323, 33.96816], [-117.52308, 33.96816], [-117.52307, 33.96821], [-117.52205, 33.96822], [-117.52205, 33.96841], [-117.5211, 33.96915], [-117.52048, 33.96989], [-117.51961, 33.97059], [-117.51875, 33.97187], [-117.51691, 33.97319], [-117.5158, 33.97365], [-117.5131, 33.97522], [-117.50998, 33.9752], [-117.50918, 33.97488], [-117.50687, 33.9741], [-117.50585, 33.97403], [-117.50479, 33.97394], [-117.50361, 33.97318], [-117.50246, 33.97302], [-117.50143, 33.97293], [-117.5014, 33.97181], [-117.49279, 33.97184], [-117.49277, 33.9709], [-117.49061, 33.97092], [-117.49058, 33.97001], [-117.48845, 33.97007], [-117.4863, 33.96896], [-117.48462, 33.96846], [-117.48335, 33.96843], [-117.48115, 33.9678], [-117.47973, 33.96718], [-117.47972, 33.96719], [-117.47972, 33.96789], [-117.47848, 33.96747], [-117.47631, 33.96659], [-117.47327, 33.96741], [-117.47088, 33.96761], [-117.47004, 33.96751], [-117.47017, 33.96736], [-117.47022, 33.96727], [-117.47026, 33.96712], [-117.47026, 33.96701], [-117.47023, 33.96686], [-117.47019, 33.96676], [-117.47012, 33.96667], [-117.46994, 33.96654], [-117.46977, 33.96648], [-117.46961, 33.96645], [-117.46958, 33.96655], [-117.46789, 33.96629], [-117.46628, 33.96524], [-117.46603, 33.96324], [-117.46598, 33.96295], [-117.46585, 33.9625], [-117.46578, 33.96229], [-117.46557, 33.96188], [-117.46536, 33.96155], [-117.46522, 33.96136], [-117.4649, 33.961], [-117.46467, 33.96077], [-117.46428, 33.96046], [-117.46388, 33.9602], [-117.46301, 33.95955], [-117.46411, 33.95939], [-117.46456, 33.95971], [-117.46482, 33.96024], [-117.46666, 33.96053], [-117.46667, 33.96066], [-117.46709, 33.96066], [-117.46883, 33.96132], [-117.46884, 33.96162], [-117.47095, 33.96164], [-117.47638, 33.96163], [-117.47641, 33.96253], [-117.4789, 33.96253], [-117.47887, 33.96481], [-117.47972, 33.96482], [-117.47977, 33.96254], [-117.48076, 33.96254], [-117.48077, 33.96164], [-117.48403, 33.96166], [-117.48405, 33.96075], [-117.48731, 33.96077], [-117.48732, 33.9605], [-117.49316, 33.96053], [-117.49311, 33.96121], [-117.49543, 33.96154], [-117.49849, 33.96316], [-117.49981, 33.96326], [-117.50044, 33.96291], [-117.50023, 33.96235], [-117.50322, 33.96165], [-117.50579, 33.96291], [-117.50662, 33.9634], [-117.51029, 33.96284], [-117.51273, 33.96201], [-117.51499, 33.96194], [-117.51499, 33.96243], [-117.51546, 33.96243], [-117.51546, 33.9628], [-117.51574, 33.96299], [-117.51821, 33.9628], [-117.52417, 33.95936], [-117.5254, 33.9605], [-117.52537, 33.96097], [-117.5254, 33.96098], [-117.52541, 33.96645]]]} | No Public Access 3 | 1798 | Hidden Valley | 32185 | 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 | Riverside 10 | 1299.756 | Hidden Valley | 0 | State Resource Management Area 55 | 3 | |
3437 | 3437 | 3436 | {"type": "Polygon", "coordinates": [[[-122.4138, 38.46446], [-122.41344, 38.465], [-122.41272, 38.46514], [-122.41239, 38.46481], [-122.41285, 38.46468], [-122.41297, 38.46463], [-122.41332, 38.46455], [-122.41347, 38.4645], [-122.41361, 38.46442], [-122.41379, 38.46439], [-122.4138, 38.46446]]]} | Open Access 1 | 25245 | Rutherford Crossroad | 32278 | 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 | 1.213 | Rutherford Crossroad | 0 | State Resource Management Area 55 | 3 | |
7851 | 7851 | 7850 | {"type": "MultiPolygon", "coordinates": [[[[-121.57273, 38.07421], [-121.57253, 38.07435], [-121.57244, 38.07427], [-121.57223, 38.07429], [-121.57214, 38.07419], [-121.57213, 38.07406], [-121.57249, 38.07387], [-121.57253, 38.07388], [-121.57262, 38.07395], [-121.57264, 38.07407], [-121.57273, 38.07421]]], [[[-121.57438, 38.07592], [-121.57429, 38.07601], [-121.57417, 38.07588], [-121.57403, 38.07576], [-121.57388, 38.07574], [-121.57358, 38.07553], [-121.5735, 38.07527], [-121.57326, 38.07524], [-121.57305, 38.07491], [-121.57279, 38.07465], [-121.57278, 38.07453], [-121.57287, 38.07443], [-121.57307, 38.07457], [-121.57321, 38.07458], [-121.57405, 38.07536], [-121.57438, 38.07592]]], [[[-121.5776, 38.08607], [-121.57741, 38.08554], [-121.57727, 38.08444], [-121.57724, 38.08389], [-121.57733, 38.08337], [-121.57746, 38.08346], [-121.57745, 38.08396], [-121.57751, 38.08425], [-121.57749, 38.08464], [-121.57767, 38.08584], [-121.5776, 38.08607]]], [[[-121.57808, 38.09104], [-121.57799, 38.0911], [-121.57781, 38.09088], [-121.57774, 38.09021], [-121.57763, 38.08983], [-121.57766, 38.08935], [-121.57761, 38.08865], [-121.57766, 38.08817], [-121.57755, 38.08796], [-121.57762, 38.08776], [-121.57762, 38.08727], [-121.57778, 38.08728], [-121.5779, 38.08878], [-121.57799, 38.08899], [-121.57792, 38.08934], [-121.57801, 38.09071], [-121.57808, 38.09104]]], [[[-121.5899, 38.09453], [-121.58989, 38.09486], [-121.58973, 38.09589], [-121.58939, 38.09622], [-121.58897, 38.09627], [-121.58864, 38.09617], [-121.5882, 38.09595], [-121.58705, 38.09577], [-121.58672, 38.09542], [-121.5857, 38.09527], [-121.58549, 38.09529], [-121.5826, 38.09443], [-121.58233, 38.0945], [-121.58061, 38.0937], [-121.5785, 38.09293], [-121.57835, 38.09278], [-121.57802, 38.09168], [-121.57889, 38.09293], [-121.58011, 38.09339], [-121.58218, 38.09401], [-121.5847, 38.09464], [-121.58617, 38.09473], [-121.58716, 38.09455], [-121.58773, 38.09456], [-121.58796, 38.09455], [-121.58959, 38.09436], [-121.5899, 38.09453]]], [[[-121.58178, 38.067], [-121.58179, 38.06761], [-121.58168, 38.06822], [-121.58147, 38.06895], [-121.58134, 38.06923], [-121.58111, 38.06951], [-121.58092, 38.07014], [-121.58068, 38.07034], [-121.5807, 38.0705], [-121.58002, 38.07111], [-121.57961, 38.07125], [-121.57935, 38.07124], [-121.57895, 38.07133], [-121.57878, 38.07131], [-121.57977, 38.07038], [-121.58039, 38.06964], [-121.58106, 38.06862], [-121.58131, 38.06808], [-121.58154, 38.06701], [-121.58167, 38.06694], [-121.58178, 38.067]]], [[[-121.58216, 38.06424], [-121.58197, 38.06453], [-121.58194, 38.06504], [-121.58186, 38.06539], [-121.58186, 38.06572], [-121.58162, 38.06595], [-121.58088, 38.06523], [-121.5808, 38.06488], [-121.58107, 38.06439], [-121.58149, 38.06412], [-121.58177, 38.06416], [-121.58203, 38.064], [-121.58216, 38.06424]]], [[[-121.58724, 38.06295], [-121.58641, 38.06282], [-121.5862, 38.06263], [-121.58612, 38.06264], [-121.58593, 38.06269], [-121.58564, 38.06267], [-121.5855, 38.06257], [-121.58538, 38.06255], [-121.58526, 38.06259], [-121.58495, 38.06247], [-121.58475, 38.06254], [-121.58437, 38.06242], [-121.5838, 38.06256], [-121.5832, 38.06266], [-121.58304, 38.06266], [-121.583, 38.06258], [-121.58369, 38.06141], [-121.58387, 38.06134], [-121.584, 38.06137], [-121.58409, 38.06148], [-121.58386, 38.06187], [-121.58387, 38.06202], [-121.58411, 38.06218], [-121.5868, 38.06258], [-121.58724, 38.06295]]], [[[-121.58557, 38.06172], [-121.58514, 38.06154], [-121.58469, 38.06158], [-121.58427, 38.06144], [-121.58419, 38.06133], [-121.58425, 38.0612], [-121.58448, 38.06115], [-121.58557, 38.06172]]], [[[-121.5937, 38.09764], [-121.59334, 38.09764], [-121.59302, 38.09752], [-121.59249, 38.09739], [-121.59246, 38.09726], [-121.59215, 38.09717], [-121.59195, 38.09728], [-121.59174, 38.09705], [-121.59098, 38.09702], [-121.58999, 38.09624], [-121.59005, 38.09541], [-121.59035, 38.09481], [-121.59079, 38.09482], [-121.59117, 38.09494], [-121.59227, 38.09627], [-121.59301, 38.09713], [-121.59357, 38.09738], [-121.5937, 38.09764]]], [[[-121.59882, 38.09928], [-121.59864, 38.0994], [-121.59785, 38.09918], [-121.59713, 38.09895], [-121.59651, 38.09881], [-121.59572, 38.09849], [-121.59553, 38.09836], [-121.5955, 38.09825], [-121.59563, 38.0982], [-121.5962, 38.09836], [-121.59638, 38.09834], [-121.59678, 38.09862], [-121.59782, 38.09883], [-121.59841, 38.09912], [-121.59882, 38.09928]]], [[[-121.60053, 38.06151], [-121.60033, 38.06195], [-121.59998, 38.06206], [-121.5999, 38.0622], [-121.59966, 38.06226], [-121.59936, 38.06251], [-121.59926, 38.06268], [-121.59881, 38.0628], [-121.59961, 38.06179], [-121.60053, 38.06151]]], [[[-121.60806, 38.10138], [-121.6076, 38.10145], [-121.6076, 38.10145], [-121.6076, 38.10136], [-121.60769, 38.10132], [-121.60799, 38.10131], [-121.60806, 38.10138]]], [[[-121.60989, 38.10147], [-121.60957, 38.10149], [-121.60948, 38.10153], [-121.60904, 38.10138], [-121.60954, 38.1012], [-121.60985, 38.10125], [-121.60989, 38.10147]]], [[[-121.61126, 38.10095], [-121.61118, 38.10103], [-121.61072, 38.10119], [-121.61034, 38.10105], [-121.61055, 38.101], [-121.61079, 38.10096], [-121.6111, 38.10089], [-121.61126, 38.10095]]], [[[-121.61288, 38.10063], [-121.61276, 38.10092], [-121.61258, 38.10097], [-121.61249, 38.10087], [-121.61244, 38.10086], [-121.61225, 38.10101], [-121.6121, 38.10104], [-121.61193, 38.10084], [-121.61276, 38.10061], [-121.61288, 38.10063]]], [[[-121.61412, 38.05742], [-121.61397, 38.05759], [-121.61272, 38.05775], [-121.61286, 38.0574], [-121.61328, 38.05654], [-121.61343, 38.05648], [-121.61406, 38.05653], [-121.61412, 38.05742]]], [[[-121.6205, 38.09959], [-121.62046, 38.0999], [-121.61987, 38.10008], [-121.61956, 38.10013], [-121.61933, 38.10004], [-121.61886, 38.10014], [-121.61853, 38.10014], [-121.61841, 38.10008], [-121.61852, 38.0998], [-121.61873, 38.09978], [-121.61907, 38.0998], [-121.61931, 38.09967], [-121.61975, 38.09977], [-121.6205, 38.09959]]], [[[-121.62497, 38.09715], [-121.62482, 38.09769], [-121.62474, 38.09803], [-121.62483, 38.0982], [-121.6246, 38.09836], [-121.62459, 38.09865], [-121.62321, 38.09932], [-121.62282, 38.09933], [-121.62237, 38.09928], [-121.62166, 38.09943], [-121.62152, 38.09938], [-121.62153, 38.09927], [-121.62194, 38.099], [-121.62268, 38.09874], [-121.62306, 38.09863], [-121.62323, 38.09835], [-121.62345, 38.09826], [-121.62439, 38.09766], [-121.62476, 38.09683], [-121.62497, 38.09715]]], [[[-121.63477, 38.05192], [-121.63425, 38.05267], [-121.63414, 38.05269], [-121.63404, 38.0526], [-121.63363, 38.05174], [-121.63254, 38.05089], [-121.63383, 38.05123], [-121.63477, 38.05192]]], [[[-121.64211, 38.05522], [-121.64206, 38.05532], [-121.64172, 38.05532], [-121.63999, 38.05462], [-121.64104, 38.05475], [-121.64211, 38.05522]]], [[[-121.64638, 38.05643], [-121.64622, 38.05645], [-121.6449, 38.05611], [-121.64421, 38.05608], [-121.6435, 38.05581], [-121.64417, 38.05576], [-121.6463, 38.0563], [-121.64638, 38.05637], [-121.64638, 38.05643]]], [[[-121.6496, 38.08237], [-121.64928, 38.08334], [-121.64906, 38.08307], [-121.64874, 38.08293], [-121.64839, 38.08296], [-121.64827, 38.08307], [-121.64771, 38.08367], [-121.64738, 38.0839], [-121.6474, 38.08406], [-121.64715, 38.08433], [-121.64701, 38.0844], [-121.64696, 38.08439], [-121.6469, 38.0842], [-121.64661, 38.08429], [-121.64646, 38.08427], [-121.64648, 38.08417], [-121.64733, 38.08321], [-121.64755, 38.08155], [-121.64778, 38.08123], [-121.64821, 38.08098], [-121.64874, 38.08099], [-121.64903, 38.08103], [-121.64928, 38.08161], [-121.64952, 38.08176], [-121.64942, 38.08191], [-121.6494, 38.082], [-121.6496, 38.08237]]], [[[-121.64859, 38.0804], [-121.64859, 38.0805], [-121.64857, 38.08055], [-121.64759, 38.08076], [-121.64748, 38.08075], [-121.64745, 38.0807], [-121.64756, 38.08053], [-121.64753, 38.08039], [-121.64756, 38.08025], [-121.64755, 38.0801], [-121.64745, 38.08006], [-121.64751, 38.07993], [-121.64761, 38.07919], [-121.64752, 38.07828], [-121.64754, 38.07763], [-121.6476, 38.07735], [-121.64775, 38.07733], [-121.64787, 38.07751], [-121.64782, 38.07778], [-121.648, 38.07848], [-121.64804, 38.07893], [-121.64825, 38.07938], [-121.64831, 38.07955], [-121.64827, 38.07993], [-121.64847, 38.08027], [-121.64859, 38.0804]]], [[[-121.64883, 38.0836], [-121.64827, 38.08394], [-121.64802, 38.08402], [-121.64784, 38.08399], [-121.64783, 38.08394], [-121.64854, 38.08321], [-121.6488, 38.08333], [-121.64883, 38.0836]]], [[[-121.64865, 38.05664], [-121.64863, 38.05681], [-121.64842, 38.05729], [-121.64813, 38.05684], [-121.64821, 38.05657], [-121.64836, 38.05648], [-121.64865, 38.05664]]]]} | No Public Access 3 | 9357 | Delta Islands | 32148 | 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 | Contra Costa 12 | 88.012 | Delta Islands | 0 | State Resource Management Area 55 | 3 | |
3485 | 3485 | 3484 | {"type": "Polygon", "coordinates": [[[-123.05209, 38.33746], [-123.05198, 38.33754], [-123.05179, 38.33741], [-123.05131, 38.33782], [-123.05136, 38.33837], [-123.04991, 38.33944], [-123.04926, 38.33873], [-123.05025, 38.33836], [-123.05118, 38.33786], [-123.05131, 38.33741], [-123.05145, 38.33698], [-123.05209, 38.33746]]]} | No Public Access 3 | 25904 | Bodega Bay Monarch Butterfly | 32057 | 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 | 4.076 | Bodega Bay Monarch Butterfly | 0 | State Resource Management Area 55 | 3 | |
3296 | 3296 | 3295 | {"type": "Polygon", "coordinates": [[[-121.61412, 37.7845], [-121.61412, 37.78579], [-121.61407, 37.78736], [-121.60506, 37.78748], [-121.605, 37.78452], [-121.6051, 37.78452], [-121.60511, 37.78451], [-121.61412, 37.7845]]]} | No Public Access 3 | 23599 | Christensen Road Burrowing Owl Site | 32113 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Alameda 17 | 63.899 | Christensen Road Burrowing Owl Site | 0 | State Resource Management Area 55 | 3 | |
7843 | 7843 | 7842 | {"type": "Polygon", "coordinates": [[[-121.614, 37.79798], [-121.61399, 37.79871], [-121.61178, 37.80234], [-121.60506, 37.80232], [-121.60511, 37.79512], [-121.60597, 37.79516], [-121.60635, 37.79514], [-121.60669, 37.7951], [-121.60709, 37.79511], [-121.6071, 37.79502], [-121.61204, 37.79505], [-121.614, 37.79798]]]} | No Public Access 3 | 9433 | Byron Conservation Bank | 32076 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Alameda 17 | 139.979 | Byron Conservation Bank | 0 | State Resource Management Area 55 | 3 | |
11550 | 11550 | 11549 | {"type": "Polygon", "coordinates": [[[-122.15107, 37.66265], [-122.14971, 37.66346], [-122.14945, 37.66398], [-122.1474, 37.66495], [-122.14554, 37.66547], [-122.14345, 37.66316], [-122.139, 37.65856], [-122.13938, 37.65851], [-122.13948, 37.6586], [-122.13969, 37.65847], [-122.14042, 37.65838], [-122.14166, 37.65981], [-122.14167, 37.65974], [-122.14402, 37.65974], [-122.14683, 37.65976], [-122.15107, 37.66265]]]} | No Public Access 3 | 23596 | San Francisco Bay | 32293 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Alameda 17 | 87.824 | San Francisco Bay | 1980 | State Resource Management Area 55 | 3 | |
2481 | 2481 | 2480 | {"type": "Polygon", "coordinates": [[[-122.19661, 40.26979], [-122.19658, 40.27249], [-122.19162, 40.27297], [-122.18953, 40.27326], [-122.19087, 40.26973], [-122.19661, 40.26979]]]} | No Public Access 3 | 17478 | Bend Ferry Road | 32047 | 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 | 45.388 | Bend Ferry Road | 0 | State Resource Management Area 55 | 3 |
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]);