units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
25 rows where ACCESS_TYP = 1 and DES_TP = 105 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15818 | 15818 | 15817 | {"type": "MultiPolygon", "coordinates": [[[[-115.8564, 33.23466], [-115.83922, 33.23474], [-115.8392, 33.25007], [-115.83917, 33.25073], [-115.8218, 33.25074], [-115.82184, 33.25008], [-115.82192, 33.23468], [-115.82191, 33.23467], [-115.80462, 33.2347], [-115.80458, 33.25007], [-115.80456, 33.25072], [-115.78727, 33.25067], [-115.78736, 33.23738], [-115.78738, 33.23471], [-115.78737, 33.2347], [-115.77008, 33.23472], [-115.76999, 33.25005], [-115.77001, 33.25062], [-115.76328, 33.25008], [-115.7622, 33.25009], [-115.75249, 33.24929], [-115.75251, 33.23475], [-115.77003, 33.23472], [-115.77007, 33.22016], [-115.77006, 33.22015], [-115.75238, 33.22027], [-115.75247, 33.23475], [-115.73553, 33.23461], [-115.73556, 33.24916], [-115.7356, 33.24917], [-115.7356, 33.2492], [-115.73557, 33.2492], [-115.73555, 33.24917], [-115.71817, 33.24918], [-115.71822, 33.23462], [-115.71831, 33.23462], [-115.7183, 33.2346], [-115.70107, 33.23466], [-115.70103, 33.24915], [-115.70101, 33.24913], [-115.68368, 33.24913], [-115.68367, 33.24914], [-115.6317, 33.24918], [-115.6143, 33.24922], [-115.61437, 33.23472], [-115.63179, 33.23461], [-115.63179, 33.22008], [-115.64885, 33.22008], [-115.6489, 33.20566], [-115.66648, 33.20559], [-115.66654, 33.19099], [-115.68368, 33.19101], [-115.68363, 33.17653], [-115.70082, 33.17656], [-115.70087, 33.16204], [-115.71818, 33.16202], [-115.71809, 33.14748], [-115.73536, 33.14745], [-115.73534, 33.13307], [-115.7524, 33.13311], [-115.7524, 33.14741], [-115.7701, 33.14745], [-115.7701, 33.162], [-115.75236, 33.16202], [-115.75242, 33.14742], [-115.73537, 33.14745], [-115.73539, 33.16205], [-115.75229, 33.16202], [-115.75237, 33.17654], [-115.77015, 33.17658], [-115.78742, 33.17649], [-115.78743, 33.17653], [-115.80478, 33.17657], [-115.80467, 33.19122], [-115.80468, 33.19124], [-115.82194, 33.19111], [-115.82196, 33.1766], [-115.8307, 33.17664], [-115.83059, 33.19111], [-115.82195, 33.19112], [-115.82199, 33.20566], [-115.80463, 33.20569], [-115.80464, 33.20571], [-115.80465, 33.22014], [-115.82195, 33.22016], [-115.82193, 33.23468], [-115.83922, 33.23474], [-115.83921, 33.22019], [-115.85231, 33.22013], [-115.85232, 33.22091], [-115.85639, 33.22091], [-115.8564, 33.23466]], [[-115.73548, 33.22015], [-115.73547, 33.22009], [-115.71827, 33.22006], [-115.71832, 33.23459], [-115.73024, 33.23461], [-115.73552, 33.23461], [-115.73548, 33.22015]], [[-115.75235, 33.20576], [-115.73544, 33.20556], [-115.73548, 33.22009], [-115.75082, 33.22017], [-115.75236, 33.22024], [-115.75235, 33.20576]], [[-115.78738, 33.20571], [-115.77831, 33.20569], [-115.77008, 33.20569], [-115.77008, 33.22015], [-115.78733, 33.22013], [-115.78737, 33.22011], [-115.78738, 33.20571]], [[-115.80464, 33.22015], [-115.80463, 33.22014], [-115.78734, 33.22013], [-115.78738, 33.22809], [-115.78738, 33.23467], [-115.80462, 33.23469], [-115.80464, 33.22015]]], [[[-115.62281, 33.16931], [-115.62279, 33.17662], [-115.61455, 33.17663], [-115.61452, 33.1693], [-115.62281, 33.16931]]], [[[-115.70083, 33.14743], [-115.70077, 33.14744], [-115.70075, 33.16204], [-115.68359, 33.16203], [-115.68356, 33.15473], [-115.69221, 33.15473], [-115.69218, 33.14743], [-115.70076, 33.14743], [-115.70083, 33.14742], [-115.70083, 33.14743]]], [[[-115.71823, 33.07505], [-115.71813, 33.08228], [-115.71817, 33.08229], [-115.71817, 33.0823], [-115.70951, 33.08221], [-115.7096, 33.07496], [-115.70094, 33.07502], [-115.70091, 33.075], [-115.70091, 33.07496], [-115.69903, 33.07352], [-115.69907, 33.06708], [-115.70701, 33.06709], [-115.70702, 33.06715], [-115.70759, 33.06715], [-115.7076, 33.0671], [-115.7122, 33.06709], [-115.71229, 33.06315], [-115.71442, 33.06316], [-115.71437, 33.06709], [-115.71655, 33.06707], [-115.71639, 33.07448], [-115.71644, 33.0746], [-115.71657, 33.07471], [-115.71771, 33.07473], [-115.71792, 33.0749], [-115.71796, 33.07504], [-115.71823, 33.07505]]]]} | Open Access 1 | 12849 | Sonny Bono Salton Sea National Wildlife Refuge | 13989 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | http://www.fws.gov/refuge/sonny_bono_salton_sea/ | Imperial 20 | 31831.176 | Sonny Bono Salton Sea NWR | 1930 | National Wildlife Refuge 105 | 2 |
15825 | 15825 | 15824 | {"type": "MultiPolygon", "coordinates": [[[[-121.47105, 38.35012], [-121.46407, 38.35017], [-121.46402, 38.34546], [-121.46413, 38.34545], [-121.46394, 38.33939], [-121.46876, 38.33911], [-121.47105, 38.35012]]], [[[-121.50976, 38.36471], [-121.50932, 38.36497], [-121.50925, 38.36406], [-121.50915, 38.36315], [-121.50902, 38.36224], [-121.50827, 38.35776], [-121.50809, 38.35774], [-121.50777, 38.35581], [-121.50794, 38.35579], [-121.50791, 38.35561], [-121.50801, 38.35559], [-121.50705, 38.34985], [-121.50695, 38.34984], [-121.50694, 38.34981], [-121.50132, 38.34978], [-121.50101, 38.34974], [-121.50054, 38.34973], [-121.50024, 38.34969], [-121.49774, 38.34967], [-121.49781, 38.34858], [-121.49885, 38.34766], [-121.49929, 38.34611], [-121.49096, 38.34607], [-121.49092, 38.34239], [-121.4909, 38.34231], [-121.49076, 38.32093], [-121.49636, 38.32096], [-121.49638, 38.32055], [-121.5012, 38.32057], [-121.50242, 38.32787], [-121.50369, 38.32788], [-121.50491, 38.3352], [-121.50497, 38.33521], [-121.50872, 38.3577], [-121.50867, 38.35771], [-121.50944, 38.36211], [-121.50967, 38.36368], [-121.50976, 38.36471]]], [[[-121.50109, 38.35764], [-121.50084, 38.36476], [-121.49622, 38.36469], [-121.49609, 38.37119], [-121.49574, 38.37128], [-121.49544, 38.37129], [-121.48983, 38.37282], [-121.48916, 38.37298], [-121.48893, 38.36986], [-121.48853, 38.36862], [-121.48864, 38.36598], [-121.48843, 38.36472], [-121.4885, 38.36472], [-121.48871, 38.36596], [-121.48899, 38.36595], [-121.4888, 38.36472], [-121.48899, 38.36186], [-121.49096, 38.35817], [-121.49308, 38.35702], [-121.50107, 38.35702], [-121.50106, 38.35763], [-121.50109, 38.35764]]], [[[-121.50184, 38.41602], [-121.50166, 38.41632], [-121.50152, 38.41663], [-121.50144, 38.41695], [-121.5014, 38.41728], [-121.50142, 38.42955], [-121.50134, 38.42957], [-121.50133, 38.43045], [-121.50142, 38.43046], [-121.50142, 38.43053], [-121.48891, 38.43054], [-121.48947, 38.429], [-121.48964, 38.42828], [-121.48955, 38.42756], [-121.48888, 38.42657], [-121.48787, 38.4259], [-121.48769, 38.42587], [-121.48733, 38.42418], [-121.4871, 38.42222], [-121.48676, 38.42107], [-121.4859, 38.41689], [-121.4858, 38.41654], [-121.48563, 38.41606], [-121.48585, 38.41604], [-121.50086, 38.41604], [-121.50184, 38.41602]]]]} | Open Access 1 | 21636 | Stone Lakes National Wildlife Refuge | 1758 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | http://www.fws.gov/refuge/stone_lakes/ | Sacramento 41 | 1878.711 | Stone Lakes NWR | 1994 | National Wildlife Refuge 105 | 2 |
4910 | 4910 | 4909 | {"type": "Polygon", "coordinates": [[[-117.13228, 32.56776], [-117.13217, 32.56937], [-117.13174, 32.56937], [-117.13173, 32.57243], [-117.12308, 32.56944], [-117.12304, 32.55906], [-117.11955, 32.55926], [-117.11939, 32.5588], [-117.11906, 32.55886], [-117.11901, 32.55896], [-117.11807, 32.55921], [-117.11722, 32.55957], [-117.11465, 32.56035], [-117.11384, 32.56071], [-117.11289, 32.56123], [-117.11206, 32.56156], [-117.11172, 32.56152], [-117.11134, 32.56162], [-117.10939, 32.5624], [-117.10922, 32.56282], [-117.10876, 32.56301], [-117.10818, 32.56346], [-117.10553, 32.56354], [-117.10494, 32.56358], [-117.10443, 32.56434], [-117.10149, 32.56431], [-117.10149, 32.55833], [-117.10571, 32.55838], [-117.10572, 32.55859], [-117.10605, 32.5586], [-117.10606, 32.55859], [-117.10604, 32.5583], [-117.10149, 32.55829], [-117.10152, 32.55462], [-117.11015, 32.55456], [-117.12304, 32.55456], [-117.12638, 32.55743], [-117.12678, 32.55824], [-117.12732, 32.55824], [-117.12738, 32.56717], [-117.13228, 32.56776]]]} | Open Access 1 | 45346 | Tijuana Slough National Wildlife Refuge | 13994 | 198 | United States Department of Defense 61 | Federal 1 | Federal Agency 1 | http://www.defense.gov/ | US Military/Defense 11 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | http://www.fws.gov/refuge/tijuana_slough/ | San Diego 4 | 584.665 | Tijuana Slough NWR | 1980 | National Wildlife Refuge 105 | 2 |
15804 | 15804 | 15803 | {"type": "MultiPolygon", "coordinates": [[[[-117.10142, 32.55462], [-117.10138, 32.5582], [-117.09924, 32.55818], [-117.0993, 32.55461], [-117.10142, 32.55462]]], [[[-117.10586, 32.54181], [-117.10585, 32.54365], [-117.10459, 32.54365], [-117.10459, 32.54111], [-117.10586, 32.54181]]], [[[-117.13321, 32.56657], [-117.13226, 32.5666], [-117.13218, 32.56774], [-117.12738, 32.56717], [-117.12732, 32.55825], [-117.12678, 32.55824], [-117.12638, 32.55743], [-117.12304, 32.55456], [-117.11016, 32.55456], [-117.10589, 32.55459], [-117.10583, 32.55097], [-117.11231, 32.55096], [-117.12731, 32.55086], [-117.12753, 32.55153], [-117.12776, 32.55207], [-117.12745, 32.55293], [-117.12925, 32.55449], [-117.1289, 32.5545], [-117.12906, 32.55473], [-117.12955, 32.55565], [-117.13039, 32.55693], [-117.13096, 32.55787], [-117.13129, 32.55893], [-117.13196, 32.56128], [-117.1322, 32.56237], [-117.13249, 32.5632], [-117.13295, 32.56483], [-117.13321, 32.56643], [-117.13321, 32.56657]]], [[[-117.12647, 32.57061], [-117.1259, 32.57209], [-117.12579, 32.57249], [-117.12572, 32.57282], [-117.12569, 32.57312], [-117.12567, 32.57345], [-117.12568, 32.57552], [-117.12529, 32.57552], [-117.12527, 32.57409], [-117.124, 32.57408], [-117.12399, 32.57387], [-117.12388, 32.57374], [-117.12357, 32.57366], [-117.12307, 32.57371], [-117.12309, 32.56944], [-117.12647, 32.57061]]], [[[-117.13172, 32.57243], [-117.13172, 32.57332], [-117.13165, 32.57329], [-117.13164, 32.5733], [-117.13161, 32.57584], [-117.13082, 32.57585], [-117.13081, 32.57655], [-117.12764, 32.57652], [-117.12758, 32.57648], [-117.12757, 32.57631], [-117.12755, 32.5763], [-117.12754, 32.57554], [-117.12584, 32.57552], [-117.12584, 32.57344], [-117.12585, 32.57311], [-117.12589, 32.57279], [-117.12597, 32.57241], [-117.12606, 32.57211], [-117.12662, 32.57067], [-117.13172, 32.57243]]], [[[-117.13208, 32.56937], [-117.13197, 32.57103], [-117.13174, 32.57103], [-117.13174, 32.56937], [-117.13208, 32.56937]]]]} | Open Access 1 | 440 | Tijuana Slough National Wildlife Refuge | 13994 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | http://www.fws.gov/refuge/tijuana_slough/ | San Diego 4 | 496.871 | Tijuana Slough NWR | 1980 | National Wildlife Refuge 105 | 2 |
15822 | 15822 | 15821 | {"type": "MultiPolygon", "coordinates": [[[[-121.58451, 41.92463], [-121.58447, 41.92823], [-121.5844, 41.93209], [-121.57486, 41.93186], [-121.57486, 41.93527], [-121.57696, 41.93534], [-121.57957, 41.93537], [-121.57908, 41.95013], [-121.5673, 41.95005], [-121.56729, 41.94741], [-121.56482, 41.94743], [-121.5644, 41.94746], [-121.55436, 41.94721], [-121.54447, 41.94735], [-121.54205, 41.94736], [-121.53455, 41.94727], [-121.51559, 41.94316], [-121.50716, 41.9411], [-121.50715, 41.94111], [-121.50704, 41.94726], [-121.50684, 41.95001], [-121.50342, 41.95001], [-121.50333, 41.94452], [-121.50318, 41.94031], [-121.4993, 41.93927], [-121.49594, 41.93845], [-121.49111, 41.93731], [-121.48762, 41.93642], [-121.47658, 41.93339], [-121.46179, 41.92945], [-121.45722, 41.92654], [-121.4572, 41.92173], [-121.45726, 41.89272], [-121.45722, 41.837], [-121.46272, 41.83784], [-121.47292, 41.83502], [-121.47492, 41.83413], [-121.47549, 41.83378], [-121.47657, 41.83333], [-121.47775, 41.83412], [-121.49491, 41.83409], [-121.49495, 41.83208], [-121.49793, 41.83142], [-121.49689, 41.82934], [-121.4992, 41.82829], [-121.50099, 41.82522], [-121.50332, 41.82563], [-121.50666, 41.82558], [-121.50844, 41.82826], [-121.51169, 41.82761], [-121.51433, 41.82911], [-121.51437, 41.83442], [-121.51907, 41.83442], [-121.51914, 41.8341], [-121.5197, 41.83224], [-121.51928, 41.83124], [-121.51941, 41.83078], [-121.51984, 41.83044], [-121.5206, 41.83014], [-121.52149, 41.82971], [-121.52171, 41.82914], [-121.52114, 41.82834], [-121.52111, 41.8277], [-121.52149, 41.8262], [-121.52269, 41.82413], [-121.52363, 41.82112], [-121.52419, 41.82007], [-121.52484, 41.81919], [-121.52533, 41.81882], [-121.52698, 41.81787], [-121.52781, 41.81732], [-121.52815, 41.81705], [-121.52889, 41.81605], [-121.52923, 41.81514], [-121.52954, 41.81409], [-121.52976, 41.81347], [-121.53041, 41.81284], [-121.53108, 41.81266], [-121.53151, 41.81282], [-121.53233, 41.81357], [-121.5337, 41.81569], [-121.53375, 41.81571], [-121.53554, 41.81671], [-121.53708, 41.81694], [-121.53988, 41.81779], [-121.54106, 41.81697], [-121.54205, 41.8173], [-121.54235, 41.81798], [-121.54001, 41.81963], [-121.53975, 41.82073], [-121.54001, 41.82164], [-121.53976, 41.82232], [-121.54113, 41.8233], [-121.54119, 41.82378], [-121.54181, 41.82425], [-121.54188, 41.82493], [-121.5422, 41.82571], [-121.54289, 41.82596], [-121.54423, 41.82549], [-121.54712, 41.82637], [-121.5492, 41.82643], [-121.54923, 41.82844], [-121.5496, 41.82915], [-121.55095, 41.82937], [-121.55289, 41.82887], [-121.5529, 41.8342], [-121.56907, 41.8339], [-121.56907, 41.84843], [-121.56894, 41.8619], [-121.56628, 41.86207], [-121.56618, 41.86405], [-121.56606, 41.87656], [-121.56572, 41.89308], [-121.56581, 41.90277], [-121.56593, 41.90493], [-121.56584, 41.90624], [-121.56583, 41.90754], [-121.566, 41.91102], [-121.56518, 41.91321], [-121.56553, 41.91648], [-121.56664, 41.91898], [-121.56709, 41.92089], [-121.56704, 41.92089], [-121.56703, 41.92091], [-121.56745, 41.92106], [-121.56763, 41.92345], [-121.56674, 41.92622], [-121.56675, 41.92623], [-121.567, 41.92624], [-121.56705, 41.92771], [-121.56666, 41.92771], [-121.56676, 41.92865], [-121.56679, 41.9296], [-121.56695, 41.93022], [-121.56713, 41.93148], [-121.57012, 41.93158], [-121.57486, 41.93185], [-121.57488, 41.92466], [-121.58451, 41.92463]], [[-121.54382, 41.9438], [-121.54383, 41.94381], [-121.54425, 41.94375], [-121.54383, 41.94375], [-121.54382, 41.9438]], [[-121.56422, 41.92194], [-121.56369, 41.91479], [-121.5543, 41.91489], [-121.55431, 41.91841], [-121.55188, 41.91848], [-121.55192, 41.92198], [-121.54465, 41.922], [-121.54446, 41.93656], [-121.54447, 41.94374], [-121.55435, 41.9436], [-121.55896, 41.94421], [-121.56525, 41.94402], [-121.56537, 41.92525], [-121.56419, 41.9252], [-121.56422, 41.92194]], [[-121.56369, 41.91478], [-121.5637, 41.91478], [-121.56372, 41.91457], [-121.56276, 41.91458], [-121.56369, 41.91478]]], [[[-121.56949, 41.96451], [-121.56905, 41.96909], [-121.56786, 41.97058], [-121.56595, 41.97129], [-121.56615, 41.97153], [-121.56695, 41.97341], [-121.56459, 41.97681], [-121.56571, 41.96445], [-121.56949, 41.96451]]], [[[-121.57519, 41.91361], [-121.57506, 41.91719], [-121.57031, 41.9172], [-121.57038, 41.9137], [-121.57519, 41.91361]]], [[[-121.58547, 41.87683], [-121.58531, 41.88405], [-121.58034, 41.88404], [-121.58037, 41.88776], [-121.57544, 41.88774], [-121.57528, 41.89134], [-121.57046, 41.89127], [-121.57051, 41.87657], [-121.58547, 41.87683]]], [[[-121.59314, 41.9793], [-121.59302, 41.98658], [-121.58361, 41.98643], [-121.5837, 41.97938], [-121.57378, 41.97919], [-121.5742, 41.97185], [-121.57479, 41.96457], [-121.58424, 41.96472], [-121.5841, 41.96846], [-121.58874, 41.96838], [-121.5885, 41.97933], [-121.59314, 41.9793]]]]} | Open Access 1 | 9396 | Tule Lake National Wildlife Refuge | 13996 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | http://www.fws.gov/refuge/tule_lake/ | Siskiyou 28 | 28415.878 | Tule Lake NWR | 1928 | National Wildlife Refuge 105 | 2 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);