superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
67 rows where ACCESS_TYP = 2, MNG_AGENCY = 25 and MNG_AG_TYP = 5
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- State Agency · 57 ✖
MNG_AGENCY 1
- California Department of Fish and Wildlife · 57 ✖
ACCESS_TYP 1
- Restricted Access · 57 ✖
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4126 | 4126 | 4125 | {"type": "Polygon", "coordinates": [[[-122.30005, 38.21733], [-122.29786, 38.2191], [-122.29705, 38.21926], [-122.29663, 38.21923], [-122.29576, 38.21935], [-122.29529, 38.21959], [-122.29466, 38.22005], [-122.29392, 38.22075], [-122.29379, 38.22124], [-122.29359, 38.22167], [-122.29323, 38.22183], [-122.29285, 38.22212], [-122.29235, 38.22232], [-122.29131, 38.22232], [-122.29048, 38.22242], [-122.28823, 38.2225], [-122.28801, 38.22246], [-122.28774, 38.22238], [-122.28757, 38.22238], [-122.2874, 38.22243], [-122.28719, 38.22261], [-122.28703, 38.2227], [-122.28635, 38.22298], [-122.28606, 38.22219], [-122.28631, 38.22122], [-122.28629, 38.22031], [-122.28566, 38.21838], [-122.28633, 38.21432], [-122.28543, 38.2135], [-122.28617, 38.2119], [-122.29992, 38.21178], [-122.30005, 38.21733]]]} | Restricted Access 2 | Fagan Marsh Ecological Reserve | 18782 | 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 | 305.999 | Fagan Marsh ER | ||
4195 | 4195 | 4194 | {"type": "MultiPolygon", "coordinates": [[[[-119.80682, 38.86625], [-119.79722, 38.85963], [-119.80528, 38.8596], [-119.79472, 38.85244], [-119.79749, 38.8524], [-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.80784, 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 | 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 | 356.755 | Fay Canyon Wildlife Area | ||
4926 | 4926 | 4925 | {"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.43447], [-122.92971, 38.43416], [-122.92954, 38.43343], [-122.92954, 38.43324], [-122.93106, 38.43321], [-122.93269, 38.43323], [-122.93272, 38.43595], [-122.93425, 38.43597], [-122.93426, 38.43681]]]} | Restricted Access 2 | 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 | 31.813 | Harrison Grade ER | ||
6281 | 6281 | 6280 | {"type": "Polygon", "coordinates": [[[-123.6721, 39.95973], [-123.67226, 39.96331], [-123.67206, 39.97058], [-123.66728, 39.97069], [-123.66757, 39.97778], [-123.66307, 39.9778], [-123.663, 39.97427], [-123.65839, 39.97425], [-123.65822, 39.97069], [-123.6582, 39.96352], [-123.66285, 39.96333], [-123.66745, 39.96334], [-123.66745, 39.95984], [-123.6721, 39.95973]]]} | Restricted Access 2 | Little Butte Ecological Reserve | 21334 | 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 | 391.123 | Little Butte ER | ||
7265 | 7265 | 7264 | {"type": "Polygon", "coordinates": [[[-121.98643, 41.98971], [-121.98471, 41.98982], [-121.98397, 41.98981], [-121.98404, 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.98569], [-121.98581, 41.98656], [-121.98605, 41.98813], [-121.98625, 41.98891], [-121.98643, 41.98971]]]} | Restricted Access 2 | 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 | 40.353 | Mud Lake Wildlife Area | ||
7706 | 7706 | 7705 | {"type": "Polygon", "coordinates": [[[-121.47811, 37.34772], [-121.47387, 37.3477], [-121.46884, 37.34757], [-121.46894, 37.33318], [-121.46053, 37.33314], [-121.46051, 37.33308], [-121.4511, 37.33303], [-121.44221, 37.33311], [-121.44212, 37.3367], [-121.43286, 37.33679], [-121.43288, 37.3363], [-121.43285, 37.33628], [-121.43277, 37.33294], [-121.4237, 37.33291], [-121.42378, 37.32944], [-121.44188, 37.3294], [-121.44188, 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.46949, 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.32952], [-121.47529, 37.33069], [-121.47621, 37.33255], [-121.47626, 37.33392], [-121.47643, 37.33555], [-121.47612, 37.33691], [-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 | 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 | 3259.446 | San Antonio Valley | ||
7807 | 7807 | 7806 | {"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 | 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 | 14.152 | San Luis Rey River ER | ||
7815 | 7815 | 7814 | {"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.56182], [-123.91363, 40.56177], [-123.91412, 40.55814], [-123.91933, 40.55808], [-123.91986, 40.5472], [-123.92567, 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 | 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 | 2772.402 | Owl Creek ER | ||
8061 | 8061 | 8060 | {"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.04722, 33.70695], [-118.04722, 33.70697], [-118.0473, 33.70706], [-118.04645, 33.70713], [-118.0451, 33.7068], [-118.04429, 33.70664], [-118.04277, 33.7066], [-118.04261, 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.70085], [-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.68918], [-118.02053, 33.68916], [-118.02115, 33.68815], [-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.02405, 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.03222, 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 | Bolsa Chica Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Bolsa-Chica-ER | 16245 | 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 | 1223.858 | Bolsa Chica ER | 1993 |
8104 | 8104 | 8103 | {"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 | 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 | 29.21 | Boulder Creek ER | ||
8434 | 8434 | 8433 | {"type": "MultiPolygon", "coordinates": [[[[-119.39379, 35.43488], [-119.39371, 35.44209], [-119.37609, 35.44202], [-119.3762, 35.43124], [-119.38496, 35.43125], [-119.38494, 35.43487], [-119.39379, 35.43488]]], [[[-119.41258, 35.45679], [-119.41249, 35.47134], [-119.40359, 35.47126], [-119.40357, 35.46033], [-119.40141, 35.46031], [-119.40139, 35.45941], [-119.39919, 35.45941], [-119.39919, 35.4585], [-119.40141, 35.45853], [-119.40142, 35.45941], [-119.40356, 35.45942], [-119.40356, 35.45673], [-119.39418, 35.45671], [-119.38581, 35.45664], [-119.38587, 35.45269], [-119.38589, 35.44222], [-119.40357, 35.44228], [-119.40356, 35.45301], [-119.40357, 35.45672], [-119.41258, 35.45679]]], [[[-119.39918, 35.4603], [-119.39916, 35.46398], [-119.39024, 35.46394], [-119.39027, 35.46027], [-119.39918, 35.4603]]]]} | Restricted Access 2 | Buttonwillow Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Buttonwillow-ER | 16613 | 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 | 1446.216 | Buttonwillow ER | 2000 |
8693 | 8693 | 8692 | {"type": "Polygon", "coordinates": [[[-121.84233, 38.27135], [-121.84227, 38.27465], [-121.84193, 38.27469], [-121.842, 38.27647], [-121.84228, 38.27646], [-121.84225, 38.2783], [-121.83652, 38.27835], [-121.83656, 38.27647], [-121.83789, 38.27642], [-121.83782, 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.83859, 38.27297], [-121.83861, 38.27296], [-121.83864, 38.27127], [-121.84233, 38.27135]], [[-121.83312, 38.27467], [-121.83319, 38.27276], [-121.83264, 38.27277], [-121.83262, 38.27468], [-121.83312, 38.27467]], [[-121.84012, 38.27472], [-121.84005, 38.27652], [-121.84099, 38.27645], [-121.84107, 38.27469], [-121.84012, 38.27472]]]} | Restricted Access 2 | Calhoun Cut Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Calhoun-Cut-ER | 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 | 238.665 | Calhoun Cut ER | 1993 |
8802 | 8802 | 8801 | {"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 | 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 | 2.51 | Theiller Sebastopol Meadowfoam ER | ||
9109 | 9109 | 9108 | {"type": "MultiPolygon", "coordinates": [[[[-120.78423, 35.35484], [-120.78407, 35.35512], [-120.78188, 35.35428], [-120.78066, 35.35491], [-120.77891, 35.35838], [-120.77894, 35.35915], [-120.77833, 35.35929], [-120.77818, 35.35951], [-120.77779, 35.35943], [-120.77771, 35.35931], [-120.77747, 35.35929], [-120.77729, 35.35952], [-120.77685, 35.35978], [-120.77648, 35.35961], [-120.77572, 35.35942], [-120.77514, 35.35971], [-120.77472, 35.35951], [-120.77383, 35.36014], [-120.77382, 35.36038], [-120.77367, 35.36051], [-120.77325, 35.35995], [-120.77254, 35.36024], [-120.77179, 35.36037], [-120.77135, 35.3605], [-120.7713, 35.36079], [-120.77098, 35.36083], [-120.77068, 35.3607], [-120.7699, 35.35921], [-120.76874, 35.3547], [-120.76848, 35.35451], [-120.76868, 35.35423], [-120.76534, 35.35444], [-120.76491, 35.3543], [-120.7642, 35.35361], [-120.76483, 35.35339], [-120.76831, 35.35102], [-120.77096, 35.34875], [-120.77352, 35.35089], [-120.77408, 35.35133], [-120.77452, 35.35163], [-120.77497, 35.35191], [-120.77544, 35.35217], [-120.77592, 35.3524], [-120.77676, 35.35275], [-120.77892, 35.35352], [-120.78125, 35.35414], [-120.78179, 35.35416], [-120.78423, 35.35484]]], [[[-120.78839, 35.35056], [-120.7849, 35.35448], [-120.78471, 35.35418], [-120.78437, 35.35413], [-120.7843, 35.35428], [-120.78204, 35.35366], [-120.78173, 35.35352], [-120.77937, 35.35286], [-120.77904, 35.35288], [-120.77819, 35.35262], [-120.77625, 35.35182], [-120.77603, 35.35178], [-120.77528, 35.3514], [-120.77307, 35.34976], [-120.77275, 35.34935], [-120.77231, 35.34912], [-120.76626, 35.34409], [-120.77364, 35.33965], [-120.7789, 35.34466], [-120.78354, 35.34942], [-120.78839, 35.35056]]]]} | Restricted Access 2 | Chorro Creek Ecological Reserve | 17221 | 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 | 583.147 | Chorro Creek ER | ||
9132 | 9132 | 9131 | {"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 | 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 | 46.653 | Clover Creek ER | ||
9133 | 9133 | 9132 | {"type": "Polygon", "coordinates": [[[-121.74412, 36.87571], [-121.74366, 36.87559], [-121.74329, 36.87545], [-121.74227, 36.87498], [-121.74082, 36.8726], [-121.74226, 36.87023], [-121.7427, 36.87029], [-121.74329, 36.87006], [-121.74404, 36.87042], [-121.74411, 36.87185], [-121.74417, 36.87202], [-121.74408, 36.87317], [-121.74393, 36.87357], [-121.74369, 36.87428], [-121.74359, 36.87435], [-121.74351, 36.87447], [-121.74349, 36.87456], [-121.7435, 36.87468], [-121.74363, 36.87499], [-121.74412, 36.87566], [-121.74412, 36.87571]]]} | Restricted Access 2 | Elkhorn Slough Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Elkhorn-Slough-ER | 18581 | 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 | 29.593 | Elkhorn Slough ER | 1980 |
9144 | 9144 | 9143 | {"type": "Polygon", "coordinates": [[[-118.41528, 37.50655], [-118.41424, 37.51016], [-118.41131, 37.5101], [-118.41137, 37.5067], [-118.41304, 37.50674], [-118.41305, 37.5065], [-118.41528, 37.50655]]]} | Restricted Access 2 | Fish Slough Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Fish-Slough-ER | 18918 | 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 | 29.183 | Fish Slough ER | 1970 |
9225 | 9225 | 9224 | {"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 | 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 | 7.588 | San Mateo Fishing Pier | ||
9272 | 9272 | 9271 | {"type": "Polygon", "coordinates": [[[-120.0828, 38.3461], [-120.08263, 38.35322], [-120.08006, 38.35323], [-120.0736, 38.35313], [-120.07364, 38.35139], [-120.07808, 38.35146], [-120.07829, 38.34769], [-120.07827, 38.34768], [-120.07372, 38.34762], [-120.07376, 38.346], [-120.0828, 38.3461]]]} | Restricted Access 2 | 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 | 114.081 | Sands Meadow | ||
9565 | 9565 | 9564 | {"type": "Polygon", "coordinates": [[[-121.58424, 41.96472], [-121.57479, 41.96457], [-121.57534, 41.95011], [-121.58397, 41.95017], [-121.58424, 41.96472]]]} | Restricted Access 2 | Sheepy Ridge Wildlife Area | 25381 | 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 | 298.655 | Sheepy Ridge Wildlife Area |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);