units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
29 rows where ACCESS_TYP = 4, AGNCY_LEV = 5 and GAP_STS = 4
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, MNG_AG_LEV, COUNTY
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3742 | 3742 | 3741 | {"type": "Polygon", "coordinates": [[[-117.25665, 33.25608], [-117.25376, 33.25609], [-117.24955, 33.25549], [-117.24981, 33.25449], [-117.25017, 33.25456], [-117.25354, 33.25499], [-117.25356, 33.25494], [-117.25383, 33.25496], [-117.25409, 33.25496], [-117.25448, 33.25494], [-117.25623, 33.25464], [-117.25665, 33.25608]]]} | Unknown Access 4 | 44862 | Zwierstra Mitigation Site | 27873 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 19.59 | Zwierstra Mitigation Site | 0 | State Other or Unknown 104 | 4 | |
4229 | 4229 | 4228 | {"type": "Polygon", "coordinates": [[[-117.00555, 32.56025], [-117.00555, 32.56116], [-117.00126, 32.56109], [-117.00126, 32.56018], [-117.00555, 32.56025]]]} | Unknown Access 4 | 45096 | Anderprizes Mitigation Site | 15474 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 10.024 | Anderprizes Mitigation Site | 0 | State Other or Unknown 104 | 4 | |
4233 | 4233 | 4232 | {"type": "Polygon", "coordinates": [[[-117.22555, 33.28986], [-117.2256, 33.29089], [-117.22556, 33.29117], [-117.22548, 33.29133], [-117.22538, 33.29147], [-117.22471, 33.29228], [-117.22418, 33.2926], [-117.22348, 33.29335], [-117.2233, 33.29351], [-117.22309, 33.29367], [-117.22289, 33.29379], [-117.22184, 33.29299], [-117.22186, 33.28931], [-117.22508, 33.28931], [-117.22501, 33.28939], [-117.22555, 33.28986]]]} | Unknown Access 4 | 45102 | Tabata Mitigation Site | 26160 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 32.975 | Tabata Mitigation Site | 0 | State Other or Unknown 104 | 4 | |
4260 | 4260 | 4259 | {"type": "Polygon", "coordinates": [[[-117.16445, 32.95224], [-117.16113, 32.95233], [-117.16099, 32.94848], [-117.16432, 32.94852], [-117.16445, 32.95224]]]} | Unknown Access 4 | 45284 | Zamudio TransNet Environmental Mitigation | 27854 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 32.329 | Zamudio TransNet Environmental Mitigation | 0 | State Other or Unknown 104 | 4 | |
4283 | 4283 | 4282 | {"type": "Polygon", "coordinates": [[[-117.19602, 33.3082], [-117.19539, 33.30858], [-117.19476, 33.3096], [-117.19489, 33.31006], [-117.19121, 33.31078], [-117.17733, 33.31358], [-117.1753, 33.3124], [-117.17474, 33.31238], [-117.17432, 33.31214], [-117.17484, 33.31196], [-117.17505, 33.31183], [-117.17532, 33.31156], [-117.17668, 33.31087], [-117.17692, 33.31068], [-117.17745, 33.31006], [-117.17764, 33.30976], [-117.17793, 33.30857], [-117.17885, 33.30794], [-117.17982, 33.30805], [-117.18065, 33.30842], [-117.18136, 33.30852], [-117.18243, 33.30861], [-117.1832, 33.30892], [-117.1835, 33.30895], [-117.18388, 33.30881], [-117.18464, 33.30826], [-117.18566, 33.30798], [-117.18604, 33.30812], [-117.1866, 33.30897], [-117.18759, 33.30877], [-117.1893, 33.30835], [-117.19086, 33.30808], [-117.19144, 33.30817], [-117.19185, 33.3085], [-117.19288, 33.30906], [-117.19314, 33.30909], [-117.19384, 33.30888], [-117.19458, 33.30843], [-117.19495, 33.30838], [-117.1953, 33.3083], [-117.19548, 33.30822], [-117.19602, 33.3082]]]} | Unknown Access 4 | 45285 | Vessels Mitigation Site | 27006 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 159.815 | Vessels Mitigation Site | 0 | State Other or Unknown 104 | 4 | |
4478 | 4478 | 4477 | {"type": "Polygon", "coordinates": [[[-116.49292, 33.88852], [-116.49291, 33.8894], [-116.48878, 33.88856], [-116.49198, 33.88852], [-116.49292, 33.88852]]]} | Unknown Access 4 | 3751 | Unnamed site - California Wildlife Conservation Board | 28678 | 212 | California Wildlife Conservation Board 766 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 212 | California Wildlife Conservation Board 747 | State 5 | State Agency 5 | Riverside 10 | 4.66 | 0 | State Other or Unknown 104 | 4 | ||
4479 | 4479 | 4478 | {"type": "Polygon", "coordinates": [[[-116.49291, 33.88957], [-116.4929, 33.89588], [-116.48423, 33.89587], [-116.48427, 33.8886], [-116.48805, 33.88856], [-116.49291, 33.88957]]]} | Unknown Access 4 | 3752 | Unnamed site - California Wildlife Conservation Board | 28678 | 212 | California Wildlife Conservation Board 766 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 212 | California Wildlife Conservation Board 747 | State 5 | State Agency 5 | Riverside 10 | 154.196 | 0 | State Other or Unknown 104 | 4 | ||
4482 | 4482 | 4481 | {"type": "Polygon", "coordinates": [[[-118.82809, 34.1109], [-118.82374, 34.11089], [-118.82373, 34.10731], [-118.82808, 34.10728], [-118.82809, 34.1109]]]} | Unknown Access 4 | 4333 | Unnamed site - Santa Monica Mountains Conservancy | 29513 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 39.614 | 0 | Local Other or Unknown 14 | 4 | ||
4486 | 4486 | 4485 | {"type": "Polygon", "coordinates": [[[-116.24853, 33.84567], [-116.24851, 33.84812], [-116.24644, 33.84703], [-116.24644, 33.84565], [-116.24853, 33.84567]]]} | Unknown Access 4 | 4473 | Unnamed site - California Wildlife Conservation Board | 28678 | 212 | California Wildlife Conservation Board 766 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 212 | California Wildlife Conservation Board 747 | State 5 | State Agency 5 | Riverside 10 | 10.124 | 0 | State Other or Unknown 104 | 4 | ||
4504 | 4504 | 4503 | {"type": "MultiPolygon", "coordinates": [[[[-118.27189, 34.25899], [-118.2716, 34.25922], [-118.2716, 34.25779], [-118.27178, 34.25778], [-118.27189, 34.25756], [-118.27189, 34.25899]]], [[[-118.27237, 34.25554], [-118.27236, 34.25643], [-118.27206, 34.25642], [-118.27207, 34.25578], [-118.27217, 34.25566], [-118.27237, 34.25554]]], [[[-118.27285, 34.2587], [-118.27285, 34.25987], [-118.27263, 34.25987], [-118.27263, 34.25887], [-118.27285, 34.2587]]], [[[-118.27406, 34.25636], [-118.27354, 34.2563], [-118.27351, 34.25638], [-118.27362, 34.25645], [-118.27348, 34.25653], [-118.27348, 34.25563], [-118.27335, 34.25554], [-118.27335, 34.25468], [-118.27359, 34.25468], [-118.27359, 34.25569], [-118.27369, 34.25576], [-118.27406, 34.25565], [-118.27406, 34.25636]]]]} | Unknown Access 4 | 6855 | Unnamed site - Santa Monica Mountains Conservancy | 29513 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 3.721 | 0 | Local Other or Unknown 14 | 4 | ||
4511 | 4511 | 4510 | {"type": "Polygon", "coordinates": [[[-118.75427, 34.16206], [-118.7528, 34.16289], [-118.75305, 34.16324], [-118.75218, 34.16381], [-118.75052, 34.1638], [-118.75016, 34.1634], [-118.74922, 34.16397], [-118.74932, 34.16485], [-118.74577, 34.16484], [-118.74578, 34.15444], [-118.75019, 34.15445], [-118.75017, 34.15687], [-118.75077, 34.15683], [-118.75171, 34.15863], [-118.75245, 34.15924], [-118.75258, 34.15956], [-118.75315, 34.16008], [-118.75269, 34.16057], [-118.75282, 34.16118], [-118.75304, 34.16161], [-118.75416, 34.1616], [-118.75427, 34.16206]]]} | Unknown Access 4 | 7093 | Unnamed site - Santa Monica Mountains Conservancy | 29513 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 154.044 | 0 | Local Other or Unknown 14 | 4 | ||
4704 | 4704 | 4703 | {"type": "Polygon", "coordinates": [[[-118.40005, 34.74273], [-118.39563, 34.7428], [-118.39551, 34.74099], [-118.39993, 34.74092], [-118.40005, 34.74273]]]} | Unknown Access 4 | 46152 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 235 | Desert and Mountain Conservation Authority 713 | State 5 | State Agency 5 | http://www.dmca.ca.gov/ | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 20.153 | 0 | Local Other or Unknown 14 | 4 | ||
4716 | 4716 | 4715 | {"type": "Polygon", "coordinates": [[[-118.40496, 34.77529], [-118.39615, 34.77542], [-118.39603, 34.76097], [-118.39596, 34.75394], [-118.3961, 34.75369], [-118.4048, 34.75357], [-118.40496, 34.77529]]]} | Unknown Access 4 | 46228 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 235 | Desert and Mountain Conservation Authority 713 | State 5 | State Agency 5 | http://www.dmca.ca.gov/ | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 480.911 | 0 | Local Other or Unknown 14 | 4 | ||
4761 | 4761 | 4760 | {"type": "Polygon", "coordinates": [[[-118.63806, 34.24154], [-118.63783, 34.24155], [-118.63783, 34.24148], [-118.63804, 34.24148], [-118.63806, 34.24154]]]} | Unknown Access 4 | 46669 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Ventura 8 | 0.038 | 0 | Local Other or Unknown 14 | 4 | ||
13226 | 13226 | 13225 | {"type": "Polygon", "coordinates": [[[-117.23056, 33.28559], [-117.23055, 33.28926], [-117.23037, 33.28927], [-117.23036, 33.28955], [-117.22971, 33.28951], [-117.22837, 33.28938], [-117.22838, 33.28563], [-117.23056, 33.28559]]]} | Unknown Access 4 | 45245 | Lueng/Lowe TransNet Environmental Mitigation | 21587 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 21.401 | Lueng/Lowe TransNet Environmental Mitigation | 0 | State Other or Unknown 104 | 4 | |
14573 | 14573 | 14572 | {"type": "Polygon", "coordinates": [[[-117.24569, 32.9638], [-117.24306, 32.96378], [-117.24305, 32.96017], [-117.24531, 32.9602], [-117.24558, 32.96169], [-117.24569, 32.9638]]]} | Unknown Access 4 | 44878 | Dean Family Trust TransNet Environmental Mitigation | 17977 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 23.121 | Dean Family Trust TransNet Environmental Mitigation | 0 | State Other or Unknown 104 | 4 | |
14621 | 14621 | 14620 | {"type": "Polygon", "coordinates": [[[-117.2959, 33.08404], [-117.29591, 33.08449], [-117.29589, 33.08457], [-117.29581, 33.08472], [-117.29571, 33.08486], [-117.29559, 33.08498], [-117.29544, 33.08509], [-117.29545, 33.08513], [-117.29301, 33.08641], [-117.29248, 33.08662], [-117.29177, 33.08681], [-117.2917, 33.08409], [-117.2959, 33.08404]]]} | Unknown Access 4 | 44854 | Ayoub Mitigation Site | 15736 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 20.055 | Ayoub Mitigation Site | 0 | State Other or Unknown 104 | 4 | |
14639 | 14639 | 14638 | {"type": "MultiPolygon", "coordinates": [[[[-117.30789, 33.14718], [-117.30772, 33.14736], [-117.30771, 33.14776], [-117.30743, 33.14776], [-117.30737, 33.14766], [-117.30705, 33.14753], [-117.30696, 33.14783], [-117.30706, 33.148], [-117.30683, 33.14848], [-117.30683, 33.14853], [-117.30595, 33.14884], [-117.30597, 33.14857], [-117.30597, 33.1483], [-117.30577, 33.14828], [-117.30574, 33.14806], [-117.30489, 33.14809], [-117.3046, 33.14818], [-117.30433, 33.14833], [-117.30412, 33.14849], [-117.30391, 33.14872], [-117.30376, 33.14923], [-117.30349, 33.14922], [-117.3037, 33.14814], [-117.30373, 33.14817], [-117.3073, 33.14696], [-117.30741, 33.14684], [-117.30789, 33.14718]]], [[[-117.3193, 33.14321], [-117.31899, 33.14379], [-117.31831, 33.14345], [-117.3183, 33.14347], [-117.31839, 33.14363], [-117.31815, 33.14354], [-117.31788, 33.14349], [-117.31604, 33.14329], [-117.31607, 33.14321], [-117.31607, 33.1432], [-117.31432, 33.143], [-117.31446, 33.14269], [-117.31497, 33.14275], [-117.31528, 33.14261], [-117.31575, 33.14215], [-117.31581, 33.14205], [-117.31585, 33.14202], [-117.31617, 33.14201], [-117.31631, 33.14205], [-117.31636, 33.14211], [-117.31637, 33.14234], [-117.3164, 33.14236], [-117.3166, 33.14232], [-117.31679, 33.1423], [-117.31684, 33.14228], [-117.31686, 33.14225], [-117.31696, 33.14196], [-117.317, 33.14192], [-117.31707, 33.1419], [-117.31748, 33.14197], [-117.31758, 33.14202], [-117.31763, 33.14209], [-117.31765, 33.14216], [-117.31757, 33.14238], [-117.31757, 33.14241], [-117.31791, 33.14259], [-117.31795, 33.1426], [-117.31799, 33.14258], [-117.31807, 33.14237], [-117.31814, 33.14231], [-117.31823, 33.14231], [-117.31849, 33.14237], [-117.31855, 33.1424], [-117.31858, 33.14246], [-117.31862, 33.14272], [-117.31852, 33.14303], [-117.31853, 33.14311], [-117.31855, 33.14318], [-117.31855, 33.14322], [-117.31857, 33.14324], [-117.31866, 33.14328], [-117.3188, 33.14331], [-117.319, 33.14317], [-117.31919, 33.14308], [-117.31925, 33.14311], [-117.31927, 33.14319], [-117.3193, 33.14321]]]]} | Unknown Access 4 | 44880 | Hallmark Transnet Environmental Mitigation | 19611 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 19.35 | Hallmark Transnet Environmental Mitigation | 0 | State Other or Unknown 104 | 4 | |
14640 | 14640 | 14639 | {"type": "Polygon", "coordinates": [[[-117.23926, 33.28549], [-117.23926, 33.28909], [-117.23491, 33.28917], [-117.23491, 33.28905], [-117.2349, 33.28905], [-117.23474, 33.28918], [-117.23415, 33.29054], [-117.23405, 33.29043], [-117.23392, 33.29033], [-117.23377, 33.29024], [-117.23361, 33.29018], [-117.23148, 33.28969], [-117.23111, 33.28962], [-117.23055, 33.28956], [-117.23055, 33.28559], [-117.22838, 33.28563], [-117.22837, 33.28929], [-117.22772, 33.2893], [-117.22737, 33.28923], [-117.2265, 33.28895], [-117.22601, 33.28878], [-117.22595, 33.28872], [-117.22575, 33.28868], [-117.22571, 33.28792], [-117.22516, 33.28706], [-117.22519, 33.28669], [-117.22535, 33.28629], [-117.22535, 33.28602], [-117.22514, 33.28568], [-117.22551, 33.28334], [-117.22564, 33.28297], [-117.22601, 33.28228], [-117.22622, 33.28194], [-117.22668, 33.2815], [-117.22671, 33.28162], [-117.22676, 33.28169], [-117.22686, 33.28177], [-117.2269, 33.28184], [-117.22711, 33.28231], [-117.22773, 33.2829], [-117.22847, 33.28203], [-117.22846, 33.28202], [-117.22816, 33.28203], [-117.22708, 33.28113], [-117.22784, 33.28019], [-117.22798, 33.28008], [-117.22965, 33.279], [-117.22998, 33.27881], [-117.2345, 33.27683], [-117.23471, 33.27672], [-117.23494, 33.27658], [-117.23493, 33.28186], [-117.23731, 33.28182], [-117.23731, 33.2832], [-117.23567, 33.28324], [-117.23567, 33.2855], [-117.23923, 33.28544], [-117.23923, 33.28549], [-117.23926, 33.28549]]]} | Unknown Access 4 | 44885 | Groves Property TransNet Mitigation | 19537 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 281.423 | Groves Property TransNet Mitigation | 0 | State Other or Unknown 104 | 4 | |
14734 | 14734 | 14733 | {"type": "Polygon", "coordinates": [[[-117.1954, 33.31432], [-117.19505, 33.31429], [-117.19404, 33.31474], [-117.19356, 33.31463], [-117.1905, 33.31328], [-117.18794, 33.31349], [-117.18526, 33.31418], [-117.1771, 33.31479], [-117.17421, 33.31628], [-117.17383, 33.31428], [-117.19121, 33.31078], [-117.19489, 33.31006], [-117.19536, 33.30995], [-117.1954, 33.31432]]]} | Unknown Access 4 | 45101 | Morrison Mitigation Site | 22497 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 123.583 | Morrison Mitigation Site | 0 | State Other or Unknown 104 | 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]);