units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 1, DES_TP = 3 and LABEL_NAME = "Powder Canyon OS"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 3 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7018 | 7018 | 7017 | {"type": "MultiPolygon", "coordinates": [[[[-117.92563, 33.95386], [-117.92551, 33.95393], [-117.92534, 33.95397], [-117.92519, 33.95397], [-117.92506, 33.95395], [-117.92502, 33.95392], [-117.925, 33.95387], [-117.92501, 33.95383], [-117.92529, 33.95348], [-117.92549, 33.95359], [-117.92554, 33.95377], [-117.92563, 33.95386]]], [[[-117.92633, 33.95169], [-117.92624, 33.9518], [-117.92622, 33.9518], [-117.92621, 33.95185], [-117.92598, 33.95214], [-117.92521, 33.95305], [-117.923, 33.95593], [-117.92265, 33.95634], [-117.9225, 33.95639], [-117.92154, 33.95636], [-117.92414, 33.95009], [-117.92426, 33.95043], [-117.92458, 33.95062], [-117.9247, 33.95081], [-117.925, 33.95102], [-117.92517, 33.95146], [-117.92545, 33.95147], [-117.9257, 33.9516], [-117.92585, 33.95156], [-117.92597, 33.95157], [-117.92633, 33.95169]]]]} | Open Access 1 | 6496 | Powder Canyon Open Space | 7479 | 2091 | Native Habitat Preservation Authority 848 | Special District 4 | Special District - Other 26 | http://www.habitatauthority.org/ | Special District 4 | 2091 | Native Habitat Preservation Authority 826 | Special District 4 | Special District - Other 24 | http://www.lamountains.com/parks.asp?parkid=45 | Los Angeles 6 | 27.946 | Powder Canyon OS | 0 | Local Recreation Area 3 | 4 |
| 16253 | 16253 | 16252 | {"type": "MultiPolygon", "coordinates": [[[[-117.93078, 33.97203], [-117.93077, 33.97211], [-117.93065, 33.97208], [-117.91639, 33.96877], [-117.91761, 33.96581], [-117.9179, 33.96553], [-117.9181, 33.96538], [-117.91832, 33.96526], [-117.91894, 33.96501], [-117.91907, 33.96493], [-117.91917, 33.96484], [-117.92028, 33.9637], [-117.92039, 33.96359], [-117.92056, 33.9635], [-117.92084, 33.96343], [-117.92272, 33.96345], [-117.92291, 33.96344], [-117.92309, 33.96339], [-117.92319, 33.96335], [-117.92335, 33.96325], [-117.92361, 33.96305], [-117.92371, 33.96299], [-117.92384, 33.96295], [-117.92399, 33.96292], [-117.92446, 33.96288], [-117.92497, 33.96278], [-117.92591, 33.96251], [-117.9265, 33.96237], [-117.92651, 33.96242], [-117.9266, 33.96244], [-117.92665, 33.96247], [-117.92667, 33.96252], [-117.92667, 33.9626], [-117.92663, 33.96273], [-117.92663, 33.96283], [-117.92666, 33.96295], [-117.92672, 33.96305], [-117.9268, 33.96314], [-117.9269, 33.96321], [-117.92716, 33.96334], [-117.92726, 33.96343], [-117.92732, 33.96352], [-117.92733, 33.9636], [-117.92738, 33.96371], [-117.92775, 33.96428], [-117.92781, 33.96442], [-117.92794, 33.9651], [-117.92802, 33.96526], [-117.92833, 33.96569], [-117.92905, 33.96753], [-117.9292, 33.96775], [-117.92956, 33.96811], [-117.92967, 33.96827], [-117.92973, 33.96849], [-117.92991, 33.97], [-117.92997, 33.97023], [-117.93011, 33.97053], [-117.93066, 33.97139], [-117.93072, 33.97153], [-117.93076, 33.97171], [-117.93078, 33.97203]]], [[[-117.92709, 33.96025], [-117.92697, 33.96039], [-117.92683, 33.96052], [-117.92627, 33.96084], [-117.92598, 33.96106], [-117.92589, 33.96116], [-117.92577, 33.9613], [-117.92564, 33.96136], [-117.92514, 33.96145], [-117.92483, 33.96145], [-117.92446, 33.96139], [-117.92407, 33.96125], [-117.92394, 33.96124], [-117.92385, 33.96128], [-117.92363, 33.96144], [-117.92354, 33.96147], [-117.92343, 33.96147], [-117.92295, 33.96129], [-117.92284, 33.9613], [-117.92352, 33.96284], [-117.92356, 33.96288], [-117.92351, 33.96291], [-117.92319, 33.96316], [-117.923, 33.96325], [-117.92289, 33.96328], [-117.92272, 33.96329], [-117.92111, 33.96326], [-117.92082, 33.96327], [-117.92074, 33.96328], [-117.92027, 33.96305], [-117.9202, 33.96305], [-117.92015, 33.96308], [-117.92013, 33.96312], [-117.92012, 33.9632], [-117.91917, 33.96207], [-117.92073, 33.95833], [-117.92102, 33.95814], [-117.92147, 33.95782], [-117.92172, 33.95764], [-117.92198, 33.95741], [-117.92198, 33.95745], [-117.92202, 33.95743], [-117.9225, 33.95699], [-117.92295, 33.95651], [-117.92335, 33.95602], [-117.9249, 33.95402], [-117.92495, 33.95402], [-117.92508, 33.95406], [-117.92518, 33.95408], [-117.92543, 33.95407], [-117.92554, 33.95404], [-117.92571, 33.95396], [-117.92587, 33.95382], [-117.92596, 33.95378], [-117.92615, 33.95372], [-117.9266, 33.95373], [-117.92662, 33.95374], [-117.92659, 33.95381], [-117.92634, 33.95393], [-117.92604, 33.95377], [-117.92584, 33.95413], [-117.92577, 33.95414], [-117.92576, 33.95463], [-117.9256, 33.95488], [-117.92543, 33.95505], [-117.9253, 33.95537], [-117.92513, 33.95595], [-117.92444, 33.95676], [-117.92442, 33.95721], [-117.924, 33.95738], [-117.92365, 33.95739], [-117.92323, 33.95802], [-117.92368, 33.9582], [-117.92407, 33.95873], [-117.92449, 33.95883], [-117.92487, 33.95901], [-117.92398, 33.95981], [-117.92393, 33.9599], [-117.92394, 33.95991], [-117.92406, 33.95993], [-117.92473, 33.95991], [-117.92519, 33.95994], [-117.92543, 33.95998], [-117.92583, 33.96006], [-117.92635, 33.96022], [-117.92651, 33.96026], [-117.92669, 33.96027], [-117.92709, 33.96025]], [[-117.92345, 33.95938], [-117.92348, 33.9594], [-117.92359, 33.95934], [-117.92342, 33.95888], [-117.92282, 33.9586], [-117.92249, 33.95908], [-117.92219, 33.95827], [-117.92206, 33.958], [-117.92205, 33.958], [-117.92162, 33.95923], [-117.9219, 33.95972], [-117.92204, 33.95967], [-117.92258, 33.9593], [-117.92272, 33.95924], [-117.92283, 33.95921], [-117.92303, 33.9592], [-117.92314, 33.95922], [-117.92331, 33.95928], [-117.92345, 33.95938]]], [[[-117.92264, 33.95635], [-117.92221, 33.9568], [-117.92185, 33.95713], [-117.92146, 33.95746], [-117.92093, 33.95785], [-117.92154, 33.95636], [-117.92223, 33.95637], [-117.9225, 33.95639], [-117.92264, 33.95635]]], [[[-117.95545, 33.97052], [-117.95545, 33.97066], [-117.95508, 33.97098], [-117.95459, 33.97243], [-117.95445, 33.97245], [-117.95431, 33.97249], [-117.95383, 33.97271], [-117.95371, 33.97274], [-117.95358, 33.97274], [-117.95305, 33.9726], [-117.9528, 33.97257], [-117.95253, 33.97256], [-117.95227, 33.97258], [-117.95129, 33.97269], [-117.95125, 33.97281], [-117.95128, 33.97304], [-117.95108, 33.97295], [-117.95083, 33.9726], [-117.95077, 33.97255], [-117.95068, 33.9725], [-117.95016, 33.97243], [-117.94984, 33.97234], [-117.94971, 33.97234], [-117.94956, 33.97236], [-117.94944, 33.97239], [-117.94926, 33.97248], [-117.94889, 33.97285], [-117.94835, 33.97321], [-117.94832, 33.97325], [-117.9483, 33.97331], [-117.94835, 33.97345], [-117.94841, 33.97386], [-117.94838, 33.9739], [-117.94833, 33.9739], [-117.94806, 33.97378], [-117.94773, 33.97379], [-117.94763, 33.97378], [-117.94747, 33.97371], [-117.94732, 33.97362], [-117.94688, 33.9732], [-117.94678, 33.97314], [-117.94668, 33.97311], [-117.94632, 33.9731], [-117.9461, 33.97313], [-117.94528, 33.97307], [-117.94456, 33.97308], [-117.94442, 33.97313], [-117.94433, 33.97319], [-117.94426, 33.97327], [-117.94422, 33.97336], [-117.9441, 33.97385], [-117.94404, 33.97398], [-117.94397, 33.97406], [-117.94388, 33.97411], [-117.94332, 33.97426], [-117.94326, 33.97431], [-117.94321, 33.97441], [-117.94288, 33.97444], [-117.94276, 33.97451], [-117.9427, 33.97457], [-117.94268, 33.97486], [-117.93096, 33.97215], [-117.93098, 33.97198], [-117.93098, 33.97181], [-117.93095, 33.97163], [-117.93089, 33.97143], [-117.9308, 33.97124], [-117.93024, 33.97037], [-117.93014, 33.97013], [-117.92993, 33.96847], [-117.92987, 33.96827], [-117.92978, 33.9681], [-117.92938, 33.96768], [-117.92929, 33.96757], [-117.92922, 33.96744], [-117.92852, 33.96566], [-117.92816, 33.96511], [-117.92812, 33.96499], [-117.928, 33.96441], [-117.92794, 33.96424], [-117.92754, 33.96361], [-117.9275, 33.96347], [-117.92746, 33.96338], [-117.92733, 33.96325], [-117.927, 33.96308], [-117.92691, 33.963], [-117.92684, 33.96288], [-117.92682, 33.96273], [-117.92695, 33.96238], [-117.92698, 33.96234], [-117.92705, 33.96229], [-117.92755, 33.9622], [-117.92772, 33.96215], [-117.92782, 33.96215], [-117.92787, 33.96217], [-117.92793, 33.96225], [-117.92793, 33.96246], [-117.92794, 33.96256], [-117.92798, 33.9627], [-117.92805, 33.9628], [-117.92864, 33.96351], [-117.9289, 33.9637], [-117.92926, 33.96387], [-117.92942, 33.96402], [-117.92952, 33.9642], [-117.92962, 33.96455], [-117.92974, 33.96479], [-117.92994, 33.96504], [-117.93016, 33.96522], [-117.93047, 33.96539], [-117.93072, 33.96547], [-117.9316, 33.96563], [-117.93182, 33.96564], [-117.93222, 33.96559], [-117.93246, 33.96552], [-117.93276, 33.96539], [-117.93319, 33.96545], [-117.93332, 33.96572], [-117.9334, 33.96606], [-117.93338, 33.96648], [-117.93346, 33.96663], [-117.93359, 33.96666], [-117.93375, 33.96666], [-117.93384, 33.96664], [-117.93398, 33.96658], [-117.93409, 33.9665], [-117.93417, 33.96641], [-117.93422, 33.96629], [-117.93431, 33.96583], [-117.93434, 33.96585], [-117.93439, 33.96585], [-117.93432, 33.96629], [-117.93424, 33.96648], [-117.93407, 33.96664], [-117.93392, 33.96671], [-117.93377, 33.96674], [-117.93349, 33.96714], [-117.93366, 33.96745], [-117.9332, 33.96805], [-117.93344, 33.96811], [-117.93353, 33.96815], [-117.9336, 33.9682], [-117.93367, 33.96817], [-117.93382, 33.96816], [-117.93403, 33.96799], [-117.93426, 33.96777], [-117.93439, 33.96794], [-117.9346, 33.96807], [-117.93456, 33.96848], [-117.93525, 33.96874], [-117.93522, 33.96899], [-117.93533, 33.96911], [-117.93553, 33.96927], [-117.93593, 33.96902], [-117.9361, 33.96904], [-117.93634, 33.96931], [-117.93625, 33.96947], [-117.9362, 33.96954], [-117.93594, 33.96977], [-117.93583, 33.96991], [-117.93576, 33.97011], [-117.93575, 33.97025], [-117.93576, 33.97029], [-117.93601, 33.97027], [-117.93603, 33.97012], [-117.93607, 33.97002], [-117.93613, 33.96993], [-117.93633, 33.96974], [-117.93654, 33.96989], [-117.93684, 33.96991], [-117.93701, 33.96977], [-117.93701, 33.96946], [-117.93696, 33.96924], [-117.93704, 33.96917], [-117.937, 33.96914], [-117.93691, 33.96916], [-117.93671, 33.9689], [-117.93671, 33.96873], [-117.93667, 33.96857], [-117.93648, 33.96794], [-117.93646, 33.96778], [-117.9364, 33.96611], [-117.93636, 33.96596], [-117.93629, 33.9658], [-117.93616, 33.9656], [-117.93608, 33.96551], [-117.93622, 33.96541], [-117.93732, 33.96575], [-117.93736, 33.9659], [-117.93743, 33.96601], [-117.93753, 33.96611], [-117.93764, 33.96615], [-117.93779, 33.96615], [-117.93789, 33.96611], [-117.93796, 33.96606], [-117.93802, 33.96598], [-117.93805, 33.96579], [-117.93809, 33.96575], [-117.93824, 33.9658], [-117.93845, 33.96583], [-117.93859, 33.96589], [-117.93889, 33.96611], [-117.93915, 33.96632], [-117.93971, 33.96686], [-117.93977, 33.96694], [-117.93983, 33.96704], [-117.93986, 33.96715], [-117.93986, 33.96732], [-117.93981, 33.96751], [-117.93981, 33.9676], [-117.93985, 33.96771], [-117.93992, 33.96783], [-117.93992, 33.96792], [-117.93994, 33.96796], [-117.93998, 33.96798], [-117.94005, 33.96799], [-117.94009, 33.96797], [-117.94012, 33.96793], [-117.94011, 33.96787], [-117.94001, 33.96774], [-117.94014, 33.96781], [-117.94021, 33.96793], [-117.94047, 33.9682], [-117.94093, 33.96817], [-117.94094, 33.96825], [-117.94175, 33.96821], [-117.94175, 33.96812], [-117.942, 33.96811], [-117.94232, 33.96834], [-117.94246, 33.9684], [-117.94255, 33.96834], [-117.94264, 33.96831], [-117.94272, 33.96847], [-117.94264, 33.96851], [-117.94273, 33.96863], [-117.94279, 33.96879], [-117.94283, 33.96884], [-117.94293, 33.96893], [-117.94312, 33.96901], [-117.94316, 33.96905], [-117.9432, 33.96911], [-117.94326, 33.96916], [-117.94337, 33.9692], [-117.94344, 33.9692], [-117.94353, 33.96917], [-117.9436, 33.96911], [-117.94365, 33.96903], [-117.94364, 33.96893], [-117.94353, 33.96876], [-117.94348, 33.96858], [-117.94348, 33.96852], [-117.9435, 33.96847], [-117.94359, 33.96842], [-117.94385, 33.96836], [-117.94392, 33.96831], [-117.94395, 33.96826], [-117.94474, 33.96921], [-117.94484, 33.96921], [-117.94483, 33.96938], [-117.9449, 33.96957], [-117.94495, 33.96963], [-117.94502, 33.9697], [-117.94514, 33.96976], [-117.94518, 33.96967], [-117.94525, 33.96943], [-117.94523, 33.96926], [-117.94518, 33.96919], [-117.94494, 33.96922], [-117.94497, 33.96883], [-117.945, 33.96874], [-117.94523, 33.96838], [-117.9453, 33.96831], [-117.94537, 33.96826], [-117.94576, 33.96805], [-117.94589, 33.96794], [-117.94673, 33.96779], [-117.9471, 33.96782], [-117.94738, 33.96776], [-117.94777, 33.96755], [-117.94787, 33.9674], [-117.94877, 33.96714], [-117.94887, 33.96701], [-117.94905, 33.96697], [-117.94923, 33.96677], [-117.94938, 33.96676], [-117.94971, 33.9666], [-117.95017, 33.96672], [-117.94997, 33.96748], [-117.95078, 33.96818], [-117.95029, 33.96925], [-117.95102, 33.96949], [-117.95125, 33.9691], [-117.95194, 33.96936], [-117.95221, 33.96887], [-117.95198, 33.96811], [-117.95328, 33.9682], [-117.9533, 33.96885], [-117.95304, 33.96924], [-117.95297, 33.97024], [-117.95346, 33.97027], [-117.95375, 33.96966], [-117.9543, 33.96954], [-117.9542, 33.96782], [-117.95476, 33.96837], [-117.95468, 33.96855], [-117.95503, 33.97003], [-117.95504, 33.97004], [-117.95528, 33.96997], [-117.95531, 33.97011], [-117.95526, 33.97025], [-117.95531, 33.97028], [-117.95545, 33.97052]], [[-117.94332, 33.97353], [-117.94333, 33.97352], [-117.9432, 33.973], [-117.9425, 33.97312], [-117.94263, 33.97365], [-117.94332, 33.97353]], [[-117.95035, 33.97225], [-117.95067, 33.97237], [-117.95096, 33.97195], [-117.95039, 33.97182], [-117.95005, 33.97156], [-117.94961, 33.97164], [-117.94961, 33.97216], [-117.94994, 33.97209], [-117.95003, 33.97225], [-117.95014, 33.97239], [-117.95035, 33.97225]]], [[[-117.95197, 33.97404], [-117.94961, 33.97464], [-117.94961, 33.97646], [-117.94272, 33.97487], [-117.94275, 33.97456], [-117.94278, 33.97454], [-117.9429, 33.97446], [-117.94321, 33.97444], [-117.94326, 33.9744], [-117.9433, 33.97432], [-117.94334, 33.97429], [-117.94387, 33.97415], [-117.94396, 33.97411], [-117.94403, 33.97405], [-117.94414, 33.97386], [-117.94426, 33.97334], [-117.94431, 33.97325], [-117.94441, 33.97317], [-117.94451, 33.97313], [-117.9446, 33.97311], [-117.94481, 33.97312], [-117.94529, 33.9731], [-117.94611, 33.97317], [-117.94632, 33.97313], [-117.94665, 33.97314], [-117.94683, 33.97321], [-117.94727, 33.97362], [-117.94734, 33.97368], [-117.9475, 33.97377], [-117.94764, 33.97381], [-117.94776, 33.97383], [-117.94806, 33.97381], [-117.94832, 33.97392], [-117.94838, 33.97393], [-117.94844, 33.97389], [-117.94844, 33.97385], [-117.94839, 33.97344], [-117.94834, 33.97333], [-117.94835, 33.97327], [-117.94892, 33.97287], [-117.94929, 33.97251], [-117.94949, 33.97241], [-117.94966, 33.97237], [-117.94986, 33.97238], [-117.95015, 33.97247], [-117.95061, 33.97252], [-117.95072, 33.97255], [-117.9508, 33.97262], [-117.95105, 33.97296], [-117.95113, 33.97302], [-117.95128, 33.97308], [-117.95131, 33.9733], [-117.95143, 33.97327], [-117.95148, 33.97338], [-117.95178, 33.97366], [-117.95184, 33.9737], [-117.95193, 33.97372], [-117.95197, 33.97404]]], [[[-117.95209, 33.9735], [-117.95191, 33.97354], [-117.95192, 33.97368], [-117.95185, 33.97367], [-117.95152, 33.97337], [-117.95147, 33.97325], [-117.9519, 33.97311], [-117.95209, 33.9735]]]]} | Open Access 1 | 46390 | Powder Canyon Open Space | 29673 | 2332 | Puente Hills Habitat Preservation Authority 849 | Special District 4 | Conservation District 31 | http://www.habitatauthority.org | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 690.972 | Powder Canyon OS | 0 | Local Recreation Area 3 | 4 | |
| 16262 | 16262 | 16261 | {"type": "Polygon", "coordinates": [[[-117.93705, 33.96918], [-117.93697, 33.96925], [-117.93701, 33.96946], [-117.93701, 33.96978], [-117.93684, 33.96991], [-117.93654, 33.96989], [-117.93623, 33.96967], [-117.93635, 33.96954], [-117.93648, 33.96933], [-117.9366, 33.96936], [-117.93669, 33.96909], [-117.93671, 33.9689], [-117.9369, 33.96915], [-117.937, 33.96914], [-117.93705, 33.96918]]]} | Open Access 1 | 46395 | Powder Canyon Open Space | 29673 | 2392 | La Habra Heights County Water District 1168 | Special District 4 | Water District 13 | http://www.lhhcwd.com/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 1.12 | Powder Canyon OS | 0 | Local Recreation Area 3 | 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]);