units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where AGNCY_ID = 2122, DES_TP = 4, MNG_AGENCY = 562 and MNG_AG_TYP = 6
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
- Open Space District · 3 ✖
MNG_AGENCY 1
- Riverside County Habitat Conservation Agency · 3 ✖
DES_TP 1
- Local Conservation Area · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3009 | 3009 | 3008 | {"type": "MultiPolygon", "coordinates": [[[[-117.29594, 33.79782], [-117.29594, 33.80085], [-117.29157, 33.80089], [-117.29164, 33.79364], [-117.28317, 33.79374], [-117.28315, 33.79302], [-117.28403, 33.79299], [-117.28399, 33.79073], [-117.28315, 33.79073], [-117.28311, 33.7865], [-117.28724, 33.78647], [-117.28726, 33.78834], [-117.29198, 33.7881], [-117.29215, 33.78821], [-117.29222, 33.78829], [-117.29226, 33.7884], [-117.29225, 33.7885], [-117.2922, 33.78861], [-117.29208, 33.78873], [-117.29166, 33.78892], [-117.29154, 33.78899], [-117.29142, 33.78913], [-117.29137, 33.7893], [-117.2914, 33.78947], [-117.29146, 33.78959], [-117.29214, 33.79026], [-117.29221, 33.79037], [-117.29223, 33.79047], [-117.29222, 33.79053], [-117.29219, 33.79062], [-117.29199, 33.79082], [-117.29188, 33.79101], [-117.29159, 33.79206], [-117.29162, 33.79352], [-117.29165, 33.79364], [-117.29171, 33.79374], [-117.29371, 33.79621], [-117.29499, 33.7976], [-117.29507, 33.79767], [-117.29523, 33.79775], [-117.29538, 33.7978], [-117.29553, 33.79782], [-117.2958, 33.79783], [-117.29594, 33.79782]]], [[[-117.29584, 33.7976], [-117.29576, 33.79766], [-117.29549, 33.79765], [-117.29532, 33.7976], [-117.29514, 33.79749], [-117.29387, 33.79611], [-117.29231, 33.79418], [-117.29584, 33.79413], [-117.29584, 33.7976]]]]} | No Public Access 3 | 48555 | Steele Peak Reserve | 33270 | 2122 | Riverside County Habitat Conservation Agency 570 | Special District 4 | Open Space District 6 | http://www.skrplan.org/ | Special District 4 | 2122 | Riverside County Habitat Conservation Agency 562 | Special District 4 | Open Space District 6 | http://rchca.us/159/Reserves | Riverside 10 | 203.798 | Steele Peak Reserve | 0 | Local Conservation Area 4 | 2 |
14413 | 14413 | 14412 | {"type": "MultiPolygon", "coordinates": [[[[-117.01468, 33.61301], [-117.01468, 33.6203], [-117.01466, 33.62751], [-116.99656, 33.62778], [-116.99439, 33.62795], [-116.99448, 33.62781], [-116.9946, 33.62756], [-116.99465, 33.62737], [-116.99464, 33.62708], [-116.99459, 33.62689], [-116.99386, 33.62491], [-116.99383, 33.62481], [-116.9938, 33.62461], [-116.99381, 33.6244], [-116.99817, 33.62324], [-116.99656, 33.61769], [-116.9968, 33.61559], [-116.99153, 33.61569], [-116.99129, 33.61552], [-116.99092, 33.61534], [-116.99091, 33.61529], [-116.99196, 33.61464], [-116.99227, 33.61438], [-116.99699, 33.6139], [-116.99782, 33.61299], [-117.00298, 33.61305], [-117.00926, 33.61306], [-117.01468, 33.61301]]], [[[-117.01437, 33.64771], [-117.01434, 33.64944], [-117.00996, 33.64944], [-117.01001, 33.64582], [-117.01182, 33.64583], [-117.01153, 33.6471], [-117.01288, 33.64823], [-117.01355, 33.6477], [-117.01437, 33.64771]]], [[[-117.01432, 33.64401], [-117.0143, 33.64559], [-117.01421, 33.64567], [-117.01002, 33.64566], [-117.01099, 33.64443], [-117.01117, 33.64424], [-117.01134, 33.64401], [-117.01432, 33.64401]]], [[[-117.01051, 33.64473], [-117.01025, 33.64506], [-117.01002, 33.64535], [-117.01002, 33.64487], [-117.01026, 33.64482], [-117.01051, 33.64473]]], [[[-117.01092, 33.64401], [-117.0108, 33.64416], [-117.01057, 33.64434], [-117.01029, 33.64448], [-117.01003, 33.64456], [-117.01004, 33.644], [-117.01092, 33.64401]]], [[[-117.03173, 33.64194], [-117.01881, 33.64214], [-117.01888, 33.63846], [-117.03166, 33.63826], [-117.03173, 33.64194]]], [[[-117.06677, 33.64892], [-117.0496, 33.64918], [-117.04941, 33.64558], [-117.04073, 33.64562], [-117.04072, 33.64563], [-117.04076, 33.64922], [-117.03915, 33.64923], [-117.03912, 33.64744], [-117.03717, 33.64745], [-117.03718, 33.64924], [-117.03629, 33.64925], [-117.03625, 33.64564], [-117.04072, 33.64562], [-117.04068, 33.64201], [-117.03392, 33.64196], [-117.03385, 33.64013], [-117.03606, 33.64011], [-117.03606, 33.63935], [-117.03595, 33.63467], [-117.03158, 33.63458], [-117.03153, 33.63087], [-117.03586, 33.63098], [-117.03578, 33.62718], [-117.04011, 33.62717], [-117.04019, 33.61636], [-117.03158, 33.61638], [-117.03151, 33.62354], [-117.02771, 33.62366], [-117.02767, 33.61645], [-117.02333, 33.61652], [-117.02331, 33.61294], [-117.03161, 33.61285], [-117.04883, 33.61249], [-117.04876, 33.62767], [-117.04443, 33.62742], [-117.04448, 33.63119], [-117.03587, 33.63098], [-117.03595, 33.63465], [-117.04031, 33.63474], [-117.04041, 33.63839], [-117.04468, 33.63844], [-117.04469, 33.63843], [-117.04452, 33.63482], [-117.04731, 33.63487], [-117.0473, 33.63466], [-117.04735, 33.63451], [-117.04743, 33.63437], [-117.04756, 33.63426], [-117.04777, 33.63417], [-117.04795, 33.63414], [-117.04819, 33.63416], [-117.04836, 33.63423], [-117.04866, 33.63445], [-117.04875, 33.6345], [-117.04875, 33.6349], [-117.04925, 33.64206], [-117.05748, 33.642], [-117.05748, 33.64019], [-117.05618, 33.64021], [-117.05618, 33.63935], [-117.05645, 33.63934], [-117.05663, 33.63929], [-117.05676, 33.63922], [-117.05686, 33.63914], [-117.05695, 33.63905], [-117.05703, 33.6389], [-117.05706, 33.63877], [-117.05706, 33.63861], [-117.05701, 33.63844], [-117.0569, 33.6383], [-117.0568, 33.6382], [-117.05647, 33.63798], [-117.05631, 33.63783], [-117.05622, 33.63773], [-117.05611, 33.63754], [-117.05606, 33.63742], [-117.05601, 33.63722], [-117.05596, 33.63666], [-117.0559, 33.63645], [-117.0558, 33.63627], [-117.05557, 33.63592], [-117.05548, 33.63572], [-117.05541, 33.63553], [-117.05536, 33.63532], [-117.05533, 33.63512], [-117.05534, 33.63482], [-117.05911, 33.63477], [-117.05939, 33.63642], [-117.0594, 33.63672], [-117.05944, 33.63685], [-117.0595, 33.63693], [-117.0596, 33.63704], [-117.06185, 33.63871], [-117.06188, 33.64197], [-117.06628, 33.64193], [-117.06677, 33.64892]]], [[[-117.06473, 33.62745], [-117.06443, 33.62762], [-117.06414, 33.62786], [-117.06402, 33.628], [-117.06357, 33.62861], [-117.06349, 33.62862], [-117.06311, 33.62844], [-117.06285, 33.62835], [-117.06258, 33.62827], [-117.06231, 33.62821], [-117.06203, 33.62818], [-117.06175, 33.62816], [-117.06146, 33.62816], [-117.06118, 33.62819], [-117.0609, 33.62823], [-117.06063, 33.6283], [-117.06037, 33.62838], [-117.06011, 33.62848], [-117.05987, 33.6286], [-117.05964, 33.62874], [-117.05942, 33.62889], [-117.05922, 33.62906], [-117.05904, 33.62924], [-117.05888, 33.62944], [-117.05874, 33.62964], [-117.05854, 33.62999], [-117.05846, 33.63012], [-117.05824, 33.63035], [-117.05798, 33.63055], [-117.05783, 33.63063], [-117.05768, 33.6307], [-117.05745, 33.63077], [-117.05744, 33.62755], [-117.06473, 33.62745]]], [[[-117.06516, 33.62953], [-117.06509, 33.63151], [-117.06342, 33.63472], [-117.06182, 33.63474], [-117.06178, 33.63156], [-117.06189, 33.63153], [-117.06193, 33.63148], [-117.06194, 33.63143], [-117.06187, 33.63119], [-117.06187, 33.62848], [-117.06192, 33.62845], [-117.06224, 33.62848], [-117.06273, 33.6286], [-117.06297, 33.62869], [-117.06363, 33.62902], [-117.06405, 33.62919], [-117.06516, 33.62953]]], [[[-117.06626, 33.63983], [-117.06339, 33.6397], [-117.06394, 33.63964], [-117.06474, 33.63926], [-117.06483, 33.63921], [-117.06494, 33.63911], [-117.06499, 33.63903], [-117.06503, 33.6389], [-117.06497, 33.63636], [-117.0644, 33.6347], [-117.0662, 33.63468], [-117.06626, 33.63983]]], [[[-117.06615, 33.62953], [-117.06538, 33.62931], [-117.06418, 33.62893], [-117.06386, 33.6288], [-117.06383, 33.62872], [-117.06426, 33.62814], [-117.06437, 33.62802], [-117.06449, 33.62791], [-117.06476, 33.62772], [-117.06541, 33.62744], [-117.06613, 33.62743], [-117.06615, 33.62953]]]]} | Open Access 1 | 48556 | Southwestern Riverside County Multi-Species Reserve | 33272 | 2122 | Riverside County Habitat Conservation Agency 570 | Special District 4 | Open Space District 6 | http://www.skrplan.org/ | Special District 4 | 2122 | Riverside County Habitat Conservation Agency 562 | Special District 4 | Open Space District 6 | http://rchca.us/159/Reserves | Riverside 10 | 2338.328 | Southwestern Riverside County Multi-Species Reserve | 1992 | Local Conservation Area 4 | 2 |
16921 | 16921 | 16920 | {"type": "MultiPolygon", "coordinates": [[[[-117.41584, 33.75669], [-117.39854, 33.75659], [-117.39853, 33.75106], [-117.38985, 33.75097], [-117.38968, 33.74215], [-117.39853, 33.74208], [-117.41583, 33.74208], [-117.41584, 33.75669]]], [[[-117.43326, 33.76202], [-117.43315, 33.76725], [-117.43301, 33.76727], [-117.42967, 33.76517], [-117.42998, 33.7651], [-117.43025, 33.76497], [-117.43122, 33.76418], [-117.43106, 33.76401], [-117.43088, 33.76386], [-117.43068, 33.76373], [-117.43046, 33.76361], [-117.43007, 33.76346], [-117.4298, 33.7634], [-117.42946, 33.76335], [-117.42931, 33.76329], [-117.42921, 33.76322], [-117.42914, 33.76314], [-117.42909, 33.76304], [-117.42906, 33.76291], [-117.42645, 33.76276], [-117.4275, 33.76535], [-117.42702, 33.76538], [-117.42672, 33.76537], [-117.42632, 33.76532], [-117.42588, 33.76522], [-117.42574, 33.76554], [-117.42557, 33.76578], [-117.42542, 33.76593], [-117.42492, 33.76635], [-117.42484, 33.76647], [-117.42478, 33.76664], [-117.42478, 33.7668], [-117.42482, 33.76696], [-117.4249, 33.76711], [-117.42503, 33.76724], [-117.42519, 33.76733], [-117.42537, 33.7674], [-117.42488, 33.7685], [-117.42168, 33.76555], [-117.42108, 33.76601], [-117.42144, 33.76153], [-117.42394, 33.76226], [-117.42413, 33.76186], [-117.42434, 33.76152], [-117.42563, 33.75971], [-117.42569, 33.75959], [-117.42572, 33.75946], [-117.42574, 33.75933], [-117.42572, 33.75921], [-117.426, 33.75921], [-117.42628, 33.75925], [-117.42652, 33.75933], [-117.42669, 33.75943], [-117.42686, 33.75957], [-117.42701, 33.75978], [-117.42707, 33.75993], [-117.42716, 33.76028], [-117.42722, 33.76038], [-117.42729, 33.76045], [-117.42737, 33.7605], [-117.42749, 33.76055], [-117.42759, 33.76057], [-117.42772, 33.76056], [-117.42803, 33.7605], [-117.42832, 33.76041], [-117.42856, 33.7603], [-117.42892, 33.76009], [-117.42933, 33.75972], [-117.42952, 33.75962], [-117.42969, 33.75957], [-117.42986, 33.75956], [-117.43004, 33.75957], [-117.43017, 33.75961], [-117.43036, 33.7597], [-117.43051, 33.75983], [-117.43061, 33.75999], [-117.43066, 33.76017], [-117.43065, 33.76031], [-117.43061, 33.76045], [-117.43029, 33.76097], [-117.43326, 33.76202]]], [[[-117.41246, 33.77321], [-117.41141, 33.77613], [-117.40868, 33.77481], [-117.40752, 33.77567], [-117.40733, 33.77553], [-117.40716, 33.77545], [-117.4067, 33.77534], [-117.40652, 33.77527], [-117.40636, 33.77517], [-117.40604, 33.77488], [-117.40588, 33.77479], [-117.40562, 33.77471], [-117.40536, 33.77468], [-117.40521, 33.77465], [-117.40497, 33.77455], [-117.40484, 33.77445], [-117.40474, 33.77433], [-117.40466, 33.7742], [-117.40453, 33.77388], [-117.40445, 33.77376], [-117.40427, 33.77354], [-117.40428, 33.77342], [-117.40451, 33.77324], [-117.40466, 33.77307], [-117.40476, 33.77292], [-117.40485, 33.77272], [-117.40928, 33.77406], [-117.41067, 33.77234], [-117.4119, 33.773], [-117.41217, 33.77312], [-117.41246, 33.77321]]], [[[-117.45059, 33.77844], [-117.45055, 33.78566], [-117.44043, 33.78573], [-117.44042, 33.7785], [-117.45059, 33.77844]]], [[[-117.43312, 33.76867], [-117.43306, 33.77133], [-117.43181, 33.77135], [-117.43181, 33.77855], [-117.43183, 33.78291], [-117.42876, 33.78264], [-117.42755, 33.78493], [-117.42756, 33.78494], [-117.43184, 33.78482], [-117.43184, 33.7858], [-117.42977, 33.78582], [-117.42966, 33.79286], [-117.41752, 33.79286], [-117.41735, 33.79001], [-117.41903, 33.78993], [-117.41839, 33.78746], [-117.41653, 33.78574], [-117.41461, 33.78525], [-117.41461, 33.78416], [-117.41555, 33.78461], [-117.4158, 33.78459], [-117.4162, 33.7846], [-117.4166, 33.78466], [-117.41696, 33.78475], [-117.41733, 33.78489], [-117.41766, 33.78506], [-117.41819, 33.78544], [-117.41846, 33.78558], [-117.41893, 33.78573], [-117.41935, 33.78577], [-117.41966, 33.78576], [-117.42005, 33.78567], [-117.42153, 33.78506], [-117.42154, 33.78504], [-117.41945, 33.78181], [-117.42273, 33.78061], [-117.42019, 33.77844], [-117.41815, 33.77983], [-117.41798, 33.77969], [-117.41461, 33.77756], [-117.41461, 33.77542], [-117.41776, 33.77541], [-117.41776, 33.77261], [-117.41818, 33.77254], [-117.41837, 33.77252], [-117.41866, 33.77255], [-117.41892, 33.77265], [-117.41915, 33.7728], [-117.42002, 33.77366], [-117.42003, 33.77136], [-117.4234, 33.77135], [-117.4238, 33.76976], [-117.42541, 33.77031], [-117.42567, 33.77036], [-117.42592, 33.77038], [-117.42612, 33.77038], [-117.4264, 33.77036], [-117.42841, 33.76999], [-117.42856, 33.7699], [-117.42866, 33.76979], [-117.4287, 33.76965], [-117.42869, 33.7695], [-117.43312, 33.76867]], [[-117.4252, 33.78511], [-117.4248, 33.78515], [-117.42446, 33.78513], [-117.42422, 33.78507], [-117.42156, 33.78784], [-117.42279, 33.78849], [-117.42594, 33.78708], [-117.42565, 33.78628], [-117.4252, 33.78511]]], [[[-117.45051, 33.79286], [-117.45048, 33.80012], [-117.43234, 33.80008], [-117.43228, 33.79287], [-117.43174, 33.79286], [-117.43179, 33.78945], [-117.43608, 33.78941], [-117.43605, 33.79286], [-117.45051, 33.79286]]], [[[-117.45891, 33.80378], [-117.4589, 33.80739], [-117.45353, 33.80736], [-117.45354, 33.80558], [-117.45245, 33.80557], [-117.45246, 33.80374], [-117.45891, 33.80378]]], [[[-117.43658, 33.80366], [-117.43657, 33.80732], [-117.43442, 33.80731], [-117.43446, 33.80365], [-117.43658, 33.80366]]], [[[-117.49364, 33.80747], [-117.49354, 33.81462], [-117.48485, 33.81461], [-117.48478, 33.81924], [-117.46764, 33.80498], [-117.46768, 33.80166], [-117.47251, 33.80168], [-117.47254, 33.80022], [-117.47639, 33.80024], [-117.48505, 33.80022], [-117.48495, 33.80741], [-117.49364, 33.80747]]], [[[-117.48467, 33.82746], [-117.48464, 33.82912], [-117.48083, 33.82912], [-117.48154, 33.82875], [-117.4821, 33.82837], [-117.48229, 33.82828], [-117.48244, 33.82823], [-117.48261, 33.82821], [-117.48287, 33.82822], [-117.48296, 33.8282], [-117.4831, 33.82823], [-117.48335, 33.82823], [-117.48347, 33.82821], [-117.48363, 33.82815], [-117.48467, 33.82746]]], [[[-117.39731, 33.82543], [-117.3973, 33.82722], [-117.39511, 33.82722], [-117.39511, 33.82559], [-117.3957, 33.82559], [-117.39571, 33.82542], [-117.39731, 33.82543]]], [[[-117.4755, 33.82912], [-117.47149, 33.82912], [-117.47149, 33.829], [-117.47153, 33.82878], [-117.47157, 33.82866], [-117.47169, 33.82846], [-117.47185, 33.82828], [-117.47202, 33.82816], [-117.47221, 33.82805], [-117.47243, 33.82798], [-117.47265, 33.82794], [-117.47287, 33.82793], [-117.4744, 33.82797], [-117.47461, 33.82804], [-117.47477, 33.82811], [-117.47492, 33.82821], [-117.47504, 33.82832], [-117.47515, 33.82845], [-117.47527, 33.8288], [-117.47534, 33.82893], [-117.4755, 33.82912]]], [[[-117.48476, 33.82077], [-117.48467, 33.82722], [-117.48352, 33.82794], [-117.48331, 33.82801], [-117.48264, 33.82799], [-117.48218, 33.82808], [-117.48136, 33.82859], [-117.48071, 33.82893], [-117.48039, 33.82902], [-117.47995, 33.82912], [-117.47586, 33.82912], [-117.47566, 33.82894], [-117.47557, 33.82883], [-117.47552, 33.82873], [-117.47539, 33.82837], [-117.47522, 33.82816], [-117.47507, 33.82803], [-117.4749, 33.82792], [-117.47471, 33.82783], [-117.47441, 33.82775], [-117.47272, 33.82771], [-117.47258, 33.82773], [-117.47232, 33.82778], [-117.47208, 33.82786], [-117.47186, 33.82798], [-117.47166, 33.82813], [-117.47146, 33.82835], [-117.47132, 33.82859], [-117.47124, 33.82885], [-117.47122, 33.82912], [-117.46727, 33.82912], [-117.46739, 33.82186], [-117.46306, 33.82186], [-117.46302, 33.82549], [-117.45869, 33.8255], [-117.45867, 33.82639], [-117.45438, 33.8264], [-117.4544, 33.82369], [-117.45013, 33.82368], [-117.45016, 33.82186], [-117.44743, 33.82185], [-117.44744, 33.81991], [-117.44064, 33.81984], [-117.4405, 33.81459], [-117.45026, 33.81459], [-117.45027, 33.81096], [-117.46318, 33.81099], [-117.46318, 33.8146], [-117.4675, 33.8146], [-117.46762, 33.80652], [-117.48476, 33.82077]], [[-117.47116, 33.81737], [-117.47087, 33.81784], [-117.4716, 33.81816], [-117.47189, 33.8177], [-117.47116, 33.81737]]]]} | No Public Access 3 | 48549 | Lake Mathews - Estelle Mountain Reserve | 33268 | 2122 | Riverside County Habitat Conservation Agency 570 | Special District 4 | Open Space District 6 | http://www.skrplan.org/ | Special District 4 | 2122 | Riverside County Habitat Conservation Agency 562 | Special District 4 | Open Space District 6 | http://rchca.us/159/Reserves | Riverside 10 | 4385.749 | Lake Mathews - Estelle Mtn. Reserve | 1982 | Local Conservation Area 4 | 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]);