units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where ACCESS_TYP = 2, AGNCY_NAME = 1 and MNG_AG_TYP = 5
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, MNG_AG_ID, PARK_URL, COUNTY, LABEL_NAME, YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3589 | 3589 | 3588 | {"type": "Polygon", "coordinates": [[[-121.4409, 38.26568], [-121.4405, 38.26654], [-121.43893, 38.26623], [-121.43872, 38.26566], [-121.43905, 38.26515], [-121.43899, 38.26457], [-121.44061, 38.26555], [-121.4409, 38.26568]]]} | Restricted Access 2 | 29176 | Cosumnes River Ecological Reserve | 17675 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Cosumnes-River-ER | Sacramento 41 | 5.742 | Cosumnes River ER | 2003 | State Conservation Area 8 | 2 |
3591 | 3591 | 3590 | {"type": "Polygon", "coordinates": [[[-124.14742, 40.69347], [-124.14559, 40.69346], [-124.14538, 40.69323], [-124.14529, 40.69315], [-124.1453, 40.6929], [-124.14528, 40.69266], [-124.14516, 40.69246], [-124.14439, 40.69244], [-124.14425, 40.69237], [-124.14377, 40.69258], [-124.14337, 40.6929], [-124.14227, 40.69323], [-124.14201, 40.69328], [-124.14184, 40.69325], [-124.14175, 40.69317], [-124.14175, 40.69315], [-124.1408, 40.6924], [-124.14079, 40.6925], [-124.14074, 40.69274], [-124.14083, 40.69303], [-124.14104, 40.69323], [-124.14057, 40.69342], [-124.14053, 40.69198], [-124.13941, 40.69246], [-124.1312, 40.69009], [-124.13037, 40.68982], [-124.1215, 40.68448], [-124.12146, 40.68269], [-124.11355, 40.68077], [-124.10809, 40.6787], [-124.10786, 40.6787], [-124.10721, 40.67735], [-124.0988, 40.67462], [-124.09604, 40.67387], [-124.09406, 40.67463], [-124.09347, 40.67584], [-124.08834, 40.67698], [-124.08359, 40.67528], [-124.08359, 40.67524], [-124.07786, 40.67485], [-124.07651, 40.67401], [-124.07441, 40.67364], [-124.07124, 40.6721], [-124.06831, 40.6679], [-124.06471, 40.66617], [-124.0647, 40.66617], [-124.0647, 40.6662], [-124.06468, 40.66621], [-124.06319, 40.6653], [-124.05956, 40.66442], [-124.05778, 40.66229], [-124.05384, 40.65824], [-124.05365, 40.65509], [-124.05002, 40.6541], [-124.04946, 40.65278], [-124.04812, 40.65258], [-124.0477, 40.65187], [-124.04497, 40.65101], [-124.04491, 40.6495], [-124.04189, 40.64952], [-124.04106, 40.64851], [-124.04073, 40.64823], [-124.03978, 40.648], [-124.03632, 40.64835], [-124.02927, 40.64745], [-124.03058, 40.63728], [-124.02908, 40.63553], [-124.02749, 40.63464], [-124.02498, 40.63367], [-124.02012, 40.63067], [-124.02289, 40.62734], [-124.02636, 40.62391], [-124.02952, 40.6237], [-124.03035, 40.62414], [-124.0314, 40.62386], [-124.03149, 40.62163], [-124.03431, 40.62178], [-124.0349, 40.62231], [-124.03653, 40.62122], [-124.03747, 40.6213], [-124.03813, 40.6188], [-124.04011, 40.61761], [-124.04263, 40.61339], [-124.04458, 40.61226], [-124.04459, 40.6127], [-124.0446, 40.61271], [-124.05363, 40.61225], [-124.05809, 40.6085], [-124.05947, 40.60912], [-124.06172, 40.60889], [-124.06364, 40.60903], [-124.06361, 40.60599], [-124.06804, 40.60592], [-124.06818, 40.60858], [-124.06892, 40.60908], [-124.06935, 40.61206], [-124.07123, 40.61266], [-124.07203, 40.6147], [-124.07427, 40.6156], [-124.07464, 40.61645], [-124.07765, 40.61879], [-124.08288, 40.61806], [-124.08893, 40.61992], [-124.09223, 40.62186], [-124.09333, 40.62235], [-124.09552, 40.62446], [-124.09889, 40.62474], [-124.10109, 40.62456], [-124.10608, 40.62589], [-124.11182, 40.62545], [-124.11188, 40.6276], [-124.11191, 40.62761], [-124.11131, 40.64262], [-124.10174, 40.64225], [-124.10166, 40.64898], [-124.10191, 40.65658], [-124.10231, 40.66392], [-124.10343, 40.67117], [-124.10615, 40.6712], [-124.10602, 40.67272], [-124.1088, 40.67387], [-124.11149, 40.67583], [-124.11218, 40.67742], [-124.11561, 40.67875], [-124.11596, 40.67875], [-124.11815, 40.67964], [-124.1214, 40.68025], [-124.12141, 40.68024], [-124.12138, 40.67879], [-124.13117, 40.68583], [-124.13949, 40.68965], [-124.14155, 40.68971], [-124.14739, 40.69182], [-124.14742, 40.69347]], [[-124.09275, 40.67312], [-124.09494, 40.67244], [-124.09639, 40.67249], [-124.0964, 40.67248], [-124.08994, 40.66756], [-124.08528, 40.66692], [-124.08296, 40.66327], [-124.08295, 40.66294], [-124.08063, 40.65854], [-124.07603, 40.65701], [-124.06997, 40.65189], [-124.06773, 40.64819], [-124.06452, 40.64798], [-124.06454, 40.64939], [-124.064, 40.64939], [-124.05629, 40.64394], [-124.04659, 40.64056], [-124.04485, 40.63975], [-124.04491, 40.64863], [-124.05539, 40.65476], [-124.05584, 40.65772], [-124.06019, 40.66206], [-124.06478, 40.66376], [-124.06478, 40.66394], [-124.06676, 40.66461], [-124.07068, 40.66745], [-124.07235, 40.67098], [-124.07617, 40.67265], [-124.07829, 40.67329], [-124.0835, 40.67367], [-124.08351, 40.67365], [-124.08626, 40.67453], [-124.08786, 40.67522], [-124.09141, 40.67419], [-124.09275, 40.67312]]]} | Restricted Access 2 | 29210 | Headwaters Forest Reserve | 29960 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | http://www.blm.gov/ca/st/en/prog/nlcs/Headwaters_ForestReserve.html | Humboldt 45 | 7609.194 | Headwaters Forest Reserve | 0 | State Conservation Area 8 | 2 |
6676 | 6676 | 6675 | {"type": "Polygon", "coordinates": [[[-117.1779, 33.42839], [-117.1779, 33.43232], [-117.17339, 33.43239], [-117.17327, 33.42847], [-117.1779, 33.42839]]]} | Restricted Access 2 | 5517 | Santa Margarita Ecological Reserve | 33342 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 221 | San Diego State University 378 | State 5 | State Agency 5 | https://fsp.sdsu.edu/about-us/ | San Diego 4 | 45.762 | Santa Margarita ER | 1962 | State Conservation Area 8 | 2 |
8388 | 8388 | 8387 | {"type": "MultiPolygon", "coordinates": [[[[-122.15612, 38.5114], [-122.15602, 38.51461], [-122.13849, 38.5146], [-122.13848, 38.51219], [-122.13854, 38.50977], [-122.13865, 38.50359], [-122.15197, 38.50368], [-122.15222, 38.50001], [-122.15555, 38.49999], [-122.1556, 38.50362], [-122.15219, 38.50368], [-122.15195, 38.5111], [-122.15604, 38.51137], [-122.15612, 38.5114]]], [[[-122.14395, 38.48911], [-122.13942, 38.48915], [-122.13932, 38.48613], [-122.13918, 38.48221], [-122.14358, 38.48228], [-122.14395, 38.48911]]], [[[-122.15728, 38.48585], [-122.15276, 38.48591], [-122.15247, 38.48241], [-122.15699, 38.48233], [-122.15728, 38.48585]]]]} | Restricted Access 2 | 48483 | Quail Ridge Reserve | 33192 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 217 | University of California 51 | State 5 | State Agency 5 | https://ucnrs.org/reserves/quail-ridge-reserve/ | Napa 11 | 529.199 | Quail Ridge Reserve | 0 | State Conservation Area 8 | 2 |
15052 | 15052 | 15051 | {"type": "MultiPolygon", "coordinates": [[[[-117.25255, 33.80464], [-117.24993, 33.80461], [-117.24825, 33.80463], [-117.24827, 33.80108], [-117.25252, 33.80114], [-117.25255, 33.80464]]], [[[-117.26585, 33.81556], [-117.26585, 33.81919], [-117.26149, 33.81923], [-117.26146, 33.81559], [-117.26585, 33.81556]]]]} | Restricted Access 2 | 48493 | Motte Rimrock Reserve | 22519 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 217 | University of California 51 | State 5 | State Agency 5 | https://ucnrs.org/reserves/motte-rimrock-reserve/ | Riverside 10 | 78.529 | Motte Rimrock Reserve | 0 | State Conservation Area 8 | 2 |
15568 | 15568 | 15567 | {"type": "MultiPolygon", "coordinates": [[[[-117.15855, 33.46486], [-117.15421, 33.46507], [-117.14524, 33.46588], [-117.14538, 33.46928], [-117.14494, 33.46886], [-117.14213, 33.46585], [-117.13783, 33.46151], [-117.1408, 33.46153], [-117.14069, 33.45434], [-117.13656, 33.45432], [-117.13646, 33.45406], [-117.13637, 33.45348], [-117.1363, 33.45254], [-117.13632, 33.44932], [-117.13637, 33.4487], [-117.13646, 33.448], [-117.13653, 33.44776], [-117.13676, 33.44716], [-117.15344, 33.4472], [-117.15396, 33.4616], [-117.1584, 33.46141], [-117.15855, 33.46486]]], [[[-117.20649, 33.43578], [-117.20644, 33.44303], [-117.19756, 33.44297], [-117.1975, 33.44657], [-117.19305, 33.44653], [-117.19309, 33.44294], [-117.18865, 33.44291], [-117.18876, 33.43575], [-117.19321, 33.43576], [-117.19316, 33.43934], [-117.19759, 33.43937], [-117.19765, 33.43577], [-117.20649, 33.43578]]]]} | Restricted Access 2 | 5509 | Santa Margarita Ecological Reserve | 33342 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 221 | San Diego State University 378 | State 5 | State Agency 5 | https://fsp.sdsu.edu/about-us/ | Riverside 10 | 1078.683 | Santa Margarita ER | 1962 | State Conservation Area 8 | 2 |
17022 | 17022 | 17021 | {"type": "MultiPolygon", "coordinates": [[[[-116.40803, 33.64523], [-116.40752, 33.64498], [-116.40687, 33.64489], [-116.40588, 33.64508], [-116.4053, 33.64525], [-116.40449, 33.64555], [-116.40394, 33.6458], [-116.4029, 33.64641], [-116.40229, 33.64686], [-116.40157, 33.64752], [-116.4009, 33.6483], [-116.40084, 33.64835], [-116.40076, 33.64839], [-116.40066, 33.6484], [-116.40056, 33.6484], [-116.40048, 33.64837], [-116.40035, 33.64827], [-116.40031, 33.64818], [-116.40025, 33.64798], [-116.40024, 33.6478], [-116.40025, 33.64766], [-116.40054, 33.64699], [-116.40065, 33.64665], [-116.40069, 33.64634], [-116.40065, 33.64598], [-116.40049, 33.6456], [-116.40027, 33.64528], [-116.40017, 33.64506], [-116.40012, 33.6448], [-116.40015, 33.6442], [-116.40009, 33.64385], [-116.39958, 33.64264], [-116.39953, 33.64231], [-116.39959, 33.64215], [-116.40001, 33.64162], [-116.40802, 33.64163], [-116.40803, 33.64523]]], [[[-116.40803, 33.65617], [-116.40416, 33.65614], [-116.40417, 33.65585], [-116.40408, 33.65555], [-116.40397, 33.65536], [-116.40356, 33.65498], [-116.403, 33.65478], [-116.40261, 33.65473], [-116.40228, 33.65461], [-116.40206, 33.65437], [-116.40192, 33.65398], [-116.40166, 33.65355], [-116.40141, 33.65332], [-116.40112, 33.65316], [-116.39953, 33.65236], [-116.39873, 33.65193], [-116.39908, 33.65194], [-116.3994, 33.65192], [-116.39966, 33.65198], [-116.40008, 33.65225], [-116.40059, 33.65242], [-116.40116, 33.65244], [-116.4017, 33.6523], [-116.40211, 33.65204], [-116.4024, 33.65172], [-116.40261, 33.65142], [-116.4029, 33.65108], [-116.40327, 33.65081], [-116.40387, 33.65054], [-116.40486, 33.65031], [-116.40539, 33.65005], [-116.40557, 33.64991], [-116.40585, 33.64964], [-116.40803, 33.64731], [-116.40803, 33.65617]]], [[[-116.4011, 33.65615], [-116.3989, 33.65614], [-116.39873, 33.65597], [-116.3985, 33.65578], [-116.39806, 33.65556], [-116.39771, 33.65546], [-116.39743, 33.65542], [-116.39702, 33.65544], [-116.3964, 33.65556], [-116.39624, 33.65554], [-116.39612, 33.6555], [-116.39603, 33.65542], [-116.39599, 33.65536], [-116.39595, 33.65526], [-116.39595, 33.65517], [-116.39598, 33.65507], [-116.39602, 33.655], [-116.39617, 33.6549], [-116.39758, 33.65464], [-116.39777, 33.65465], [-116.39792, 33.6547], [-116.39802, 33.65477], [-116.39846, 33.65519], [-116.39873, 33.65538], [-116.39901, 33.65553], [-116.39926, 33.65563], [-116.39952, 33.65571], [-116.40064, 33.65588], [-116.40079, 33.65593], [-116.40095, 33.65602], [-116.4011, 33.65615]]], [[[-116.40726, 33.64624], [-116.40716, 33.64645], [-116.40467, 33.64911], [-116.4046, 33.64917], [-116.40449, 33.64924], [-116.40436, 33.64929], [-116.40376, 33.64942], [-116.40322, 33.64957], [-116.40291, 33.6497], [-116.40257, 33.64988], [-116.40202, 33.65027], [-116.40175, 33.65052], [-116.40122, 33.65122], [-116.40112, 33.65131], [-116.40089, 33.65135], [-116.40055, 33.65116], [-116.40016, 33.65092], [-116.39978, 33.65081], [-116.39951, 33.65079], [-116.39897, 33.65084], [-116.3987, 33.65076], [-116.39844, 33.65051], [-116.398, 33.65023], [-116.39748, 33.65009], [-116.39702, 33.64999], [-116.39662, 33.6497], [-116.39613, 33.64926], [-116.39579, 33.64908], [-116.39549, 33.64899], [-116.39517, 33.64897], [-116.39476, 33.64902], [-116.39418, 33.6493], [-116.39383, 33.64972], [-116.39372, 33.65028], [-116.3939, 33.65079], [-116.39427, 33.65115], [-116.39486, 33.65139], [-116.39579, 33.65136], [-116.39594, 33.6514], [-116.39786, 33.6527], [-116.3986, 33.65317], [-116.39906, 33.65342], [-116.40051, 33.65413], [-116.40059, 33.65419], [-116.40064, 33.65425], [-116.40084, 33.65479], [-116.39996, 33.65467], [-116.39978, 33.65462], [-116.39953, 33.65451], [-116.39935, 33.65437], [-116.39894, 33.65398], [-116.39864, 33.65378], [-116.3983, 33.65363], [-116.39805, 33.65357], [-116.39776, 33.65354], [-116.39741, 33.65355], [-116.39581, 33.65384], [-116.39552, 33.65394], [-116.3952, 33.65414], [-116.39487, 33.65447], [-116.39469, 33.65483], [-116.39463, 33.65525], [-116.39471, 33.65565], [-116.39502, 33.65613], [-116.39091, 33.65612], [-116.39092, 33.64161], [-116.39843, 33.64162], [-116.39827, 33.64197], [-116.39821, 33.64242], [-116.39826, 33.64279], [-116.39882, 33.64412], [-116.39881, 33.64486], [-116.39888, 33.64529], [-116.39901, 33.64562], [-116.39913, 33.64583], [-116.39935, 33.64617], [-116.39934, 33.64654], [-116.39912, 33.647], [-116.39893, 33.64764], [-116.399, 33.64834], [-116.39926, 33.64887], [-116.39944, 33.64907], [-116.39965, 33.64922], [-116.40005, 33.64941], [-116.40036, 33.64948], [-116.40091, 33.64949], [-116.4014, 33.64935], [-116.40168, 33.6492], [-116.40188, 33.64903], [-116.40255, 33.64826], [-116.40295, 33.64787], [-116.40322, 33.64764], [-116.40355, 33.64739], [-116.40393, 33.64713], [-116.40438, 33.64687], [-116.40511, 33.64652], [-116.40614, 33.64616], [-116.40697, 33.64599], [-116.40723, 33.64614], [-116.40726, 33.64624]]], [[[-116.44282, 33.61252], [-116.4428, 33.62707], [-116.42542, 33.62707], [-116.42545, 33.61257], [-116.4141, 33.61259], [-116.4137, 33.61297], [-116.41358, 33.61368], [-116.41385, 33.61464], [-116.41414, 33.61494], [-116.41447, 33.61553], [-116.41419, 33.61644], [-116.41333, 33.61764], [-116.41293, 33.6179], [-116.41255, 33.61823], [-116.41224, 33.61859], [-116.41198, 33.619], [-116.41189, 33.61918], [-116.41178, 33.61947], [-116.40803, 33.61947], [-116.40802, 33.61982], [-116.3996, 33.61983], [-116.39962, 33.62712], [-116.39092, 33.62711], [-116.39092, 33.61261], [-116.37352, 33.61264], [-116.37349, 33.62716], [-116.35621, 33.62715], [-116.35622, 33.64165], [-116.33884, 33.64167], [-116.33885, 33.65616], [-116.35622, 33.65615], [-116.35623, 33.67065], [-116.3649, 33.67069], [-116.36487, 33.67777], [-116.36491, 33.68484], [-116.35629, 33.68488], [-116.35624, 33.67773], [-116.35623, 33.67067], [-116.35622, 33.67066], [-116.33891, 33.67071], [-116.33891, 33.68484], [-116.32154, 33.68488], [-116.32147, 33.67068], [-116.3389, 33.6707], [-116.33884, 33.65617], [-116.32146, 33.65617], [-116.32147, 33.64164], [-116.33883, 33.64166], [-116.33883, 33.62716], [-116.32146, 33.62714], [-116.32145, 33.61265], [-116.30367, 33.61267], [-116.3039, 33.60748], [-116.304, 33.60178], [-116.30381, 33.59829], [-116.31957, 33.59817], [-116.31959, 33.58374], [-116.33687, 33.58365], [-116.3369, 33.59809], [-116.32146, 33.59818], [-116.32147, 33.61264], [-116.33882, 33.61264], [-116.33888, 33.5981], [-116.35413, 33.59812], [-116.35409, 33.58354], [-116.37145, 33.58348], [-116.37146, 33.59803], [-116.35619, 33.59813], [-116.3562, 33.61262], [-116.37351, 33.61264], [-116.37354, 33.5981], [-116.38867, 33.5981], [-116.38887, 33.58345], [-116.41488, 33.58375], [-116.41486, 33.59806], [-116.41487, 33.59807], [-116.41669, 33.59806], [-116.41664, 33.6053], [-116.42543, 33.60531], [-116.42546, 33.61257], [-116.44282, 33.61252]], [[-116.3562, 33.61264], [-116.33882, 33.61265], [-116.33883, 33.62715], [-116.3562, 33.62714], [-116.3562, 33.61264]], [[-116.40823, 33.5981], [-116.40822, 33.59808], [-116.39093, 33.5981], [-116.39092, 33.6126], [-116.40813, 33.6126], [-116.40823, 33.5981]], [[-116.41663, 33.60531], [-116.41662, 33.6053], [-116.41229, 33.60529], [-116.41232, 33.60895], [-116.41533, 33.60898], [-116.41579, 33.6086], [-116.41617, 33.60841], [-116.41657, 33.60829], [-116.41662, 33.60716], [-116.41663, 33.60531]]]]} | Restricted Access 2 | 48464 | Boyd Deep Canyon Desert Research Center | 33174 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 217 | University of California 51 | State 5 | State Agency 5 | https://ucnrs.org/reserves/boyd-deep-canyon-desert-research-center/ | Riverside 10 | 10434.306 | Boyd Deep Canyon Desert Research Ctr. | 0 | None 1424 |
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]);