units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
55 rows where ACCESS_TYP = 4 and MNG_AG_TYP = 13 sorted by map
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, COUNTY
MNG_AGENCY 7
DES_TP 3
- Local Other or Unknown 53
- None 1
- None 1
MNG_AG_TYP 1
- Water District · 55 ✖
ACCESS_TYP 1
- Unknown Access · 55 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4759 | 4759 | 4758 | {"type": "Polygon", "coordinates": [[[-116.89337, 32.86769], [-116.89335, 32.87083], [-116.89269, 32.87075], [-116.89171, 32.87067], [-116.89084, 32.87071], [-116.88852, 32.8713], [-116.88757, 32.87172], [-116.88715, 32.87197], [-116.88627, 32.87239], [-116.88579, 32.87264], [-116.88517, 32.87306], [-116.88341, 32.87378], [-116.88276, 32.87409], [-116.88211, 32.8745], [-116.88159, 32.87481], [-116.88042, 32.87556], [-116.87951, 32.87611], [-116.87854, 32.87675], [-116.87777, 32.87717], [-116.87882, 32.87389], [-116.88144, 32.87294], [-116.88354, 32.87188], [-116.88375, 32.87177], [-116.88407, 32.87153], [-116.88412, 32.87153], [-116.88423, 32.87144], [-116.88619, 32.86953], [-116.88642, 32.86932], [-116.88665, 32.86914], [-116.88691, 32.86897], [-116.88719, 32.86882], [-116.88743, 32.86871], [-116.88787, 32.86854], [-116.88831, 32.86843], [-116.89254, 32.868], [-116.89295, 32.86788], [-116.89337, 32.86769]]]} | Unknown Access 4 | 46690 | Unnamed site - Helix Water District | 30035 | 2046 | Helix Water District 777 | Special District 4 | Water District 13 | http://www.hwd.com | Special District 4 | 2046 | Helix Water District 757 | Special District 4 | Water District 13 | San Diego 4 | 97.198 | 0 | Local Other or Unknown 14 | 4 | ||
14807 | 14807 | 14806 | {"type": "Polygon", "coordinates": [[[-116.93609, 33.0511], [-116.92755, 33.05108], [-116.92754, 33.04241], [-116.93205, 33.04305], [-116.93259, 33.04035], [-116.92753, 33.03962], [-116.92753, 33.03643], [-116.93601, 33.03655], [-116.93601, 33.04036], [-116.93609, 33.0511]]]} | Unknown Access 4 | 45223 | Ramona Municipal Water District | 24117 | 2116 | Ramona Municipal Water District 872 | Special District 4 | Water District 13 | http://www.rmwd.org/ | Special District 4 | 2116 | Ramona Municipal Water District 850 | Special District 4 | Water District 13 | San Diego 4 | 283.724 | Ramona Municipal Water District | 0 | Local Other or Unknown 14 | 4 | |
14808 | 14808 | 14807 | {"type": "Polygon", "coordinates": [[[-117.00394, 33.01294], [-117.00388, 33.01486], [-117.00029, 33.01496], [-117.00055, 33.01283], [-117.00251, 33.0123], [-117.00285, 33.01294], [-117.00394, 33.01294]]]} | Unknown Access 4 | 45224 | Ramona Municipal Water District | 24117 | 2116 | Ramona Municipal Water District 872 | Special District 4 | Water District 13 | http://www.rmwd.org/ | Special District 4 | 2116 | Ramona Municipal Water District 850 | Special District 4 | Water District 13 | San Diego 4 | 19.711 | Ramona Municipal Water District | 0 | Local Other or Unknown 14 | 4 | |
1681 | 1681 | 1680 | {"type": "Polygon", "coordinates": [[[-117.56495, 33.66821], [-117.5606, 33.66822], [-117.56061, 33.67181], [-117.55625, 33.67183], [-117.55624, 33.66465], [-117.56493, 33.66461], [-117.56495, 33.66821]]]} | Unknown Access 4 | 12688 | Trabuco Canyon Water District lands | 26502 | 2166 | Trabuco Canyon Water District 406 | Special District 4 | Water District 13 | http://www.tcwd.ca.gov/ | Special District 4 | 2166 | Trabuco Canyon Water District 400 | Special District 4 | Water District 13 | Orange 3 | 119.276 | Trabuco Canyon Water District lands | None 135 | |||
4487 | 4487 | 4486 | {"type": "Polygon", "coordinates": [[[-117.65095, 33.91007], [-117.65019, 33.91006], [-117.64981, 33.90897], [-117.65009, 33.9089], [-117.65007, 33.90881], [-117.65045, 33.90848], [-117.65044, 33.90828], [-117.64965, 33.9076], [-117.64926, 33.90648], [-117.65093, 33.90642], [-117.65095, 33.91007]]]} | Unknown Access 4 | 4844 | Unnamed site - Orange County Water District | 28653 | 2105 | Orange County Water District 768 | Special District 4 | Water District 13 | http://www.ocwd.com/ | Special District 4 | 2105 | Orange County Water District 749 | Special District 4 | Water District 13 | Riverside 10 | 9.715 | 0 | Local Other or Unknown 14 | 4 | ||
10640 | 10640 | 10639 | {"type": "Polygon", "coordinates": [[[-120.11817, 34.66507], [-120.11816, 34.66546], [-120.11783, 34.66545], [-120.11784, 34.66507], [-120.11817, 34.66507]]]} | Unknown Access 4 | 18982 | Alamo Pintado Creek | 15319 | 2147 | Santa Ynez River Water Conservation District 953 | Special District 4 | Water District 13 | Special District 4 | 2147 | Santa Ynez River Water Conservation District 925 | Special District 4 | Water District 13 | Santa Barbara 7 | 0.321 | Alamo Pintado Creek | 0 | Local Other or Unknown 14 | 4 | ||
14123 | 14123 | 14122 | {"type": "Polygon", "coordinates": [[[-121.05725, 39.43932], [-121.05664, 39.43942], [-121.05651, 39.44297], [-121.05471, 39.44295], [-121.05477, 39.43885], [-121.05507, 39.43835], [-121.05725, 39.43932]]]} | Unknown Access 4 | 43015 | Yuba County Water Agency 46 | 27836 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 18.833 | Yuba County Water Agency 46 | 0 | Local Other or Unknown 14 | 4 | |
13390 | 13390 | 13389 | {"type": "Polygon", "coordinates": [[[-121.06653, 39.43703], [-121.06571, 39.43704], [-121.06567, 39.4357], [-121.0665, 39.43569], [-121.06653, 39.43703]]]} | Unknown Access 4 | 35493 | Yuba County Water Agency 12 | 27800 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 2.613 | Yuba County Water Agency 12 | 0 | Local Other or Unknown 14 | 4 | |
13474 | 13474 | 13473 | {"type": "Polygon", "coordinates": [[[-121.06719, 39.44088], [-121.067, 39.44107], [-121.06698, 39.44105], [-121.0669, 39.44097], [-121.06677, 39.44072], [-121.06674, 39.44058], [-121.06685, 39.44057], [-121.06683, 39.44046], [-121.06679, 39.44041], [-121.06673, 39.44036], [-121.06641, 39.44028], [-121.06619, 39.4402], [-121.06602, 39.4401], [-121.06586, 39.43999], [-121.06562, 39.43972], [-121.06549, 39.43952], [-121.06517, 39.43938], [-121.06562, 39.43937], [-121.06574, 39.43953], [-121.0658, 39.43964], [-121.06603, 39.43988], [-121.06615, 39.43997], [-121.0663, 39.44006], [-121.06684, 39.44022], [-121.06697, 39.44032], [-121.06703, 39.44041], [-121.06707, 39.44066], [-121.06712, 39.44077], [-121.06719, 39.44088]]]} | Unknown Access 4 | 35736 | Yuba County Water Agency 27 | 27816 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 1.231 | Yuba County Water Agency 27 | 0 | Local Other or Unknown 14 | 4 | |
3158 | 3158 | 3157 | {"type": "Polygon", "coordinates": [[[-121.08887, 38.32906], [-121.08872, 38.32997], [-121.0886, 38.33024], [-121.08831, 38.33059], [-121.08712, 38.33171], [-121.0868, 38.33162], [-121.08621, 38.33112], [-121.08608, 38.33088], [-121.08604, 38.33063], [-121.08614, 38.33054], [-121.08636, 38.33047], [-121.08658, 38.3303], [-121.08671, 38.33014], [-121.08694, 38.32905], [-121.08887, 38.32906]]]} | Unknown Access 4 | 21825 | Smud | 25577 | 2129 | Sacramento Municipal Utility District 591 | Special District 4 | Water District 13 | http://www.smud.org/ | Special District 4 | 2129 | Sacramento Municipal Utility District 581 | Special District 4 | Water District 13 | Sacramento 41 | 10.95 | Smud | None 258 | |||
14117 | 14117 | 14116 | {"type": "Polygon", "coordinates": [[[-121.16577, 39.37457], [-121.16513, 39.37558], [-121.16452, 39.37641], [-121.1639, 39.37703], [-121.16383, 39.37729], [-121.16389, 39.37774], [-121.16402, 39.37827], [-121.16399, 39.37875], [-121.16381, 39.3791], [-121.16377, 39.37947], [-121.1638, 39.37989], [-121.16386, 39.38032], [-121.16399, 39.38073], [-121.16413, 39.38139], [-121.1639, 39.3814], [-121.16378, 39.3809], [-121.16374, 39.38069], [-121.16358, 39.38027], [-121.16352, 39.37968], [-121.1635, 39.3792], [-121.16377, 39.37856], [-121.16377, 39.37819], [-121.16372, 39.37781], [-121.16355, 39.37726], [-121.1633, 39.37739], [-121.16275, 39.37757], [-121.16217, 39.37764], [-121.16158, 39.37759], [-121.16101, 39.37742], [-121.15901, 39.37666], [-121.15836, 39.37655], [-121.15853, 39.37624], [-121.15933, 39.37632], [-121.1612, 39.37703], [-121.16132, 39.37685], [-121.16196, 39.37706], [-121.16234, 39.37717], [-121.16282, 39.3772], [-121.16334, 39.37688], [-121.16362, 39.37662], [-121.16375, 39.37674], [-121.16393, 39.37657], [-121.16438, 39.376], [-121.16486, 39.37545], [-121.16529, 39.37484], [-121.16574, 39.37404], [-121.16577, 39.37457]]]} | Unknown Access 4 | 43014 | Yuba County Water Agency 45 | 27835 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 10.802 | Yuba County Water Agency 45 | 0 | Local Other or Unknown 14 | 4 | |
13468 | 13468 | 13467 | {"type": "Polygon", "coordinates": [[[-121.19416, 39.34305], [-121.18906, 39.34311], [-121.18673, 39.34309], [-121.18576, 39.34311], [-121.18597, 39.33911], [-121.19414, 39.3395], [-121.19416, 39.34305]]]} | Unknown Access 4 | 35708 | Yuba County Water Agency 26 | 27815 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 74.263 | Yuba County Water Agency 26 | 0 | Local Other or Unknown 14 | 4 | |
3879 | 3879 | 3878 | {"type": "Polygon", "coordinates": [[[-121.19451, 39.33672], [-121.19414, 39.33949], [-121.18597, 39.3391], [-121.18689, 39.33154], [-121.18707, 39.33029], [-121.18718, 39.3303], [-121.18742, 39.3303], [-121.18842, 39.3304], [-121.18881, 39.3304], [-121.18925, 39.33042], [-121.18963, 39.33042], [-121.19002, 39.33044], [-121.19016, 39.33043], [-121.18978, 39.3321], [-121.19067, 39.33218], [-121.19105, 39.33663], [-121.1914, 39.33671], [-121.19169, 39.33661], [-121.19204, 39.33663], [-121.19255, 39.33679], [-121.19303, 39.33702], [-121.19349, 39.33708], [-121.19377, 39.33714], [-121.19405, 39.33696], [-121.19418, 39.33677], [-121.19451, 39.33672]]]} | Unknown Access 4 | 35703 | Yuba County Water Agency 25 | 27814 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 108.796 | Yuba County Water Agency 25 | 0 | Local Other or Unknown 14 | 4 | |
13386 | 13386 | 13385 | {"type": "Polygon", "coordinates": [[[-121.19523, 39.33117], [-121.19468, 39.33535], [-121.19452, 39.33532], [-121.19433, 39.33535], [-121.19414, 39.33548], [-121.194, 39.33561], [-121.19383, 39.33565], [-121.19363, 39.3356], [-121.19371, 39.33544], [-121.19369, 39.3352], [-121.19358, 39.33483], [-121.19334, 39.33452], [-121.19295, 39.33364], [-121.19253, 39.33317], [-121.19246, 39.33298], [-121.19256, 39.33309], [-121.19277, 39.33325], [-121.19307, 39.33344], [-121.19345, 39.33359], [-121.19372, 39.33364], [-121.1939, 39.33361], [-121.19393, 39.33358], [-121.194, 39.33347], [-121.194, 39.33342], [-121.19397, 39.33326], [-121.1937, 39.33285], [-121.19363, 39.33258], [-121.19357, 39.33229], [-121.19356, 39.33191], [-121.19352, 39.33153], [-121.19355, 39.33136], [-121.19361, 39.33129], [-121.1938, 39.33122], [-121.19407, 39.33119], [-121.19452, 39.33108], [-121.19489, 39.33111], [-121.19523, 39.33117]]]} | Unknown Access 4 | 35483 | Yuba County Water Agency 11 | 27799 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 14.69 | Yuba County Water Agency 11 | 0 | Local Other or Unknown 14 | 4 | |
13471 | 13471 | 13470 | {"type": "Polygon", "coordinates": [[[-121.19527, 39.33087], [-121.19525, 39.331], [-121.19493, 39.33095], [-121.19451, 39.33091], [-121.19403, 39.33103], [-121.19375, 39.33106], [-121.19348, 39.33116], [-121.19335, 39.3313], [-121.19331, 39.33152], [-121.19335, 39.33192], [-121.19336, 39.3323], [-121.19349, 39.3329], [-121.19377, 39.33332], [-121.19379, 39.33342], [-121.19376, 39.33347], [-121.19354, 39.33343], [-121.19317, 39.3333], [-121.19292, 39.33314], [-121.19273, 39.33299], [-121.1926, 39.33284], [-121.19234, 39.3328], [-121.19228, 39.33282], [-121.19225, 39.33288], [-121.19225, 39.333], [-121.19234, 39.33325], [-121.19276, 39.33371], [-121.19314, 39.33458], [-121.19338, 39.33489], [-121.19348, 39.33521], [-121.19349, 39.33542], [-121.19339, 39.33563], [-121.19339, 39.33567], [-121.19341, 39.33571], [-121.19344, 39.33573], [-121.19385, 39.33582], [-121.19412, 39.33575], [-121.19442, 39.3355], [-121.19452, 39.33549], [-121.19466, 39.33552], [-121.19451, 39.33671], [-121.19418, 39.33677], [-121.19405, 39.33696], [-121.19377, 39.33714], [-121.19349, 39.33708], [-121.19303, 39.33702], [-121.19255, 39.33679], [-121.19204, 39.33663], [-121.19169, 39.33661], [-121.1914, 39.33671], [-121.19105, 39.33663], [-121.19067, 39.33218], [-121.19163, 39.33225], [-121.19187, 39.33099], [-121.19192, 39.33103], [-121.19198, 39.33104], [-121.19243, 39.33099], [-121.19268, 39.33086], [-121.193, 39.33073], [-121.19342, 39.33066], [-121.1939, 39.33064], [-121.19427, 39.33064], [-121.19476, 39.33074], [-121.19527, 39.33087]]]} | Unknown Access 4 | 35729 | Yuba County Water Agency 20 | 27809 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 35.226 | Yuba County Water Agency 20 | 0 | Local Other or Unknown 14 | 4 | |
13739 | 13739 | 13738 | {"type": "Polygon", "coordinates": [[[-121.19544, 39.32953], [-121.19529, 39.3307], [-121.19482, 39.33058], [-121.19431, 39.33048], [-121.1939, 39.33048], [-121.1934, 39.3305], [-121.19293, 39.33057], [-121.19258, 39.33071], [-121.19237, 39.33083], [-121.19196, 39.33088], [-121.19188, 39.33092], [-121.19197, 39.3303], [-121.19287, 39.3302], [-121.19318, 39.33019], [-121.19385, 39.33006], [-121.19449, 39.32991], [-121.19501, 39.32976], [-121.19525, 39.32965], [-121.19544, 39.32953]]]} | Unknown Access 4 | 36233 | Yuba County Water Agency 44 | 27834 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 4.515 | Yuba County Water Agency 44 | 0 | Local Other or Unknown 14 | 4 | |
3883 | 3883 | 3882 | {"type": "Polygon", "coordinates": [[[-121.26021, 39.48175], [-121.26013, 39.48186], [-121.25967, 39.48201], [-121.25908, 39.48231], [-121.25892, 39.48241], [-121.25892, 39.48267], [-121.25836, 39.48299], [-121.25892, 39.48344], [-121.25524, 39.48339], [-121.25431, 39.48275], [-121.25488, 39.48191], [-121.25549, 39.48189], [-121.25594, 39.48185], [-121.25652, 39.48175], [-121.256, 39.48003], [-121.25695, 39.47864], [-121.2589, 39.47905], [-121.25891, 39.48114], [-121.26003, 39.48142], [-121.26014, 39.48149], [-121.2602, 39.48164], [-121.26021, 39.48175]]]} | Unknown Access 4 | 35733 | Yuba County Water Agency 23 | 27812 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 35.822 | Yuba County Water Agency 23 | 0 | Local Other or Unknown 14 | 4 | |
13470 | 13470 | 13469 | {"type": "Polygon", "coordinates": [[[-121.2633, 39.4399], [-121.26298, 39.44032], [-121.26282, 39.44033], [-121.26271, 39.44023], [-121.26276, 39.43992], [-121.2633, 39.4399]]]} | Unknown Access 4 | 35728 | Yuba County Water Agency 21 | 27810 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 0.391 | Yuba County Water Agency 21 | 0 | Local Other or Unknown 14 | 4 | |
13385 | 13385 | 13384 | {"type": "Polygon", "coordinates": [[[-121.26373, 39.48345], [-121.26077, 39.48344], [-121.26057, 39.48328], [-121.25903, 39.48256], [-121.26008, 39.48202], [-121.26034, 39.4819], [-121.26043, 39.48155], [-121.26024, 39.48131], [-121.2599, 39.48119], [-121.25891, 39.48101], [-121.25891, 39.48036], [-121.26368, 39.48036], [-121.26373, 39.48345]]]} | Unknown Access 4 | 35481 | Yuba County Water Agency 1 | 27797 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 29.016 | Yuba County Water Agency 1 | 0 | Local Other or Unknown 14 | 4 | |
13475 | 13475 | 13474 | {"type": "Polygon", "coordinates": [[[-121.26491, 39.48036], [-121.25891, 39.48036], [-121.25891, 39.47936], [-121.25891, 39.47936], [-121.26491, 39.48036]]]} | Unknown Access 4 | 35738 | Yuba County Water Agency 16 | 27804 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 7.056 | Yuba County Water Agency 16 | 0 | Local Other or Unknown 14 | 4 |
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]);