units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where ACCESS_TYP = 1, MNG_AGENCY = 864 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
DES_TP 2
MNG_AG_TYP 1
- City Agency · 5 ✖
MNG_AGENCY 1
- Fort Bragg, City of · 5 ✖
ACCESS_TYP 1
- Open Access · 5 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8290 | 8290 | 8289 | {"type": "Polygon", "coordinates": [[[-123.81691, 39.44486], [-123.81691, 39.44495], [-123.81682, 39.44505], [-123.8167, 39.44512], [-123.81643, 39.44514], [-123.81629, 39.44522], [-123.81621, 39.44518], [-123.81615, 39.44522], [-123.81615, 39.44529], [-123.81603, 39.44532], [-123.81582, 39.44532], [-123.81562, 39.44537], [-123.81547, 39.44547], [-123.81522, 39.44569], [-123.81502, 39.44595], [-123.81492, 39.44597], [-123.8148, 39.44605], [-123.81475, 39.44615], [-123.81477, 39.44629], [-123.81473, 39.44649], [-123.81461, 39.44674], [-123.8146, 39.44697], [-123.81469, 39.44717], [-123.81462, 39.44726], [-123.8146, 39.44739], [-123.81469, 39.44747], [-123.81473, 39.44759], [-123.81487, 39.44773], [-123.81482, 39.44789], [-123.81478, 39.44796], [-123.8147, 39.44803], [-123.81458, 39.44803], [-123.81444, 39.44808], [-123.81423, 39.4481], [-123.81411, 39.44813], [-123.814, 39.44824], [-123.8139, 39.44828], [-123.81379, 39.44836], [-123.8137, 39.44859], [-123.81368, 39.44874], [-123.81363, 39.44887], [-123.81364, 39.44896], [-123.81367, 39.44904], [-123.81366, 39.44912], [-123.81368, 39.44929], [-123.81379, 39.44944], [-123.81375, 39.44953], [-123.81355, 39.44965], [-123.81349, 39.44975], [-123.81359, 39.44987], [-123.81367, 39.44994], [-123.8137, 39.45], [-123.81368, 39.45008], [-123.81357, 39.45018], [-123.81355, 39.45026], [-123.81358, 39.45036], [-123.81377, 39.45049], [-123.81407, 39.45056], [-123.81414, 39.45061], [-123.81418, 39.45068], [-123.81418, 39.45081], [-123.81424, 39.45096], [-123.81446, 39.45108], [-123.81455, 39.45116], [-123.81462, 39.45125], [-123.8146, 39.45136], [-123.8144, 39.45147], [-123.81433, 39.45141], [-123.81427, 39.45144], [-123.81429, 39.45153], [-123.81414, 39.4516], [-123.81409, 39.45166], [-123.81409, 39.4518], [-123.81196, 39.45181], [-123.81194, 39.45136], [-123.81215, 39.45107], [-123.81219, 39.45059], [-123.81295, 39.44915], [-123.81293, 39.44884], [-123.81314, 39.4482], [-123.81399, 39.44758], [-123.81393, 39.44708], [-123.81383, 39.4469], [-123.81373, 39.44625], [-123.81385, 39.44518], [-123.81357, 39.44448], [-123.81249, 39.44354], [-123.81338, 39.44314], [-123.81371, 39.44333], [-123.81397, 39.44352], [-123.81408, 39.44355], [-123.81429, 39.44356], [-123.81447, 39.44347], [-123.81447, 39.4435], [-123.81449, 39.44352], [-123.81451, 39.44356], [-123.81455, 39.44356], [-123.81467, 39.44363], [-123.81474, 39.44359], [-123.81474, 39.44358], [-123.81472, 39.44354], [-123.81463, 39.44349], [-123.81456, 39.44342], [-123.81461, 39.44341], [-123.81487, 39.44345], [-123.81494, 39.44351], [-123.81493, 39.44356], [-123.81496, 39.4436], [-123.81495, 39.44366], [-123.81489, 39.44378], [-123.81478, 39.44383], [-123.81477, 39.44376], [-123.81474, 39.44374], [-123.81466, 39.44379], [-123.81465, 39.44383], [-123.81466, 39.44388], [-123.81474, 39.44387], [-123.81471, 39.44393], [-123.8147, 39.44407], [-123.81476, 39.4442], [-123.81483, 39.44429], [-123.81497, 39.44432], [-123.81509, 39.4443], [-123.81515, 39.44426], [-123.81519, 39.44428], [-123.81535, 39.44425], [-123.81537, 39.4442], [-123.81539, 39.4442], [-123.81553, 39.44426], [-123.81568, 39.44453], [-123.81582, 39.44458], [-123.81582, 39.44461], [-123.81588, 39.44461], [-123.81592, 39.44459], [-123.81609, 39.44455], [-123.81624, 39.44458], [-123.81635, 39.44464], [-123.81641, 39.44472], [-123.81659, 39.44483], [-123.8167, 39.44485], [-123.81673, 39.44491], [-123.81683, 39.44491], [-123.81683, 39.44485], [-123.81691, 39.44486]], [[-123.81462, 39.44378], [-123.81463, 39.4437], [-123.81446, 39.44367], [-123.81443, 39.44362], [-123.81437, 39.44363], [-123.81436, 39.4437], [-123.81436, 39.44374], [-123.81442, 39.44381], [-123.81455, 39.44384], [-123.8146, 39.44381], [-123.81462, 39.44378]], [[-123.81474, 39.44418], [-123.81468, 39.44415], [-123.81461, 39.44417], [-123.81461, 39.44425], [-123.81471, 39.44428], [-123.81475, 39.44422], [-123.81474, 39.44418]], [[-123.81479, 39.44368], [-123.81483, 39.44371], [-123.81489, 39.4437], [-123.81491, 39.44367], [-123.81487, 39.44362], [-123.81484, 39.44361], [-123.8148, 39.44362], [-123.81478, 39.44365], [-123.81479, 39.44368]], [[-123.81529, 39.44441], [-123.81527, 39.44435], [-123.81523, 39.44434], [-123.81514, 39.44437], [-123.81513, 39.44444], [-123.81517, 39.44447], [-123.81525, 39.44447], [-123.8153, 39.44444], [-123.81529, 39.44441]]]} | Open Access 1 | 47780 | Fort Bragg Coastal Park | 19005 | 1412 | Fort Bragg, City of 889 | City 2 | City Agency 2 | http://city.fortbragg.com/ | City 2 | 1412 | Fort Bragg, City of 864 | City 2 | City Agency 2 | http://www.parks.ca.gov/?page_id=26445 | Mendocino 24 | 29.199 | Fort Bragg Coastal Park | 2015 | Local Park 2 | 4 |
| 12219 | 12219 | 12218 | {"type": "Polygon", "coordinates": [[[-123.79557, 39.44475], [-123.79553, 39.44475], [-123.79546, 39.44488], [-123.79492, 39.44513], [-123.79494, 39.4454], [-123.79333, 39.4454], [-123.79327, 39.4443], [-123.79328, 39.44402], [-123.79347, 39.44402], [-123.79348, 39.44405], [-123.79384, 39.44405], [-123.79385, 39.4441], [-123.79413, 39.44409], [-123.79414, 39.44415], [-123.79491, 39.44414], [-123.79491, 39.44408], [-123.79531, 39.44407], [-123.79532, 39.4442], [-123.79557, 39.4442], [-123.79557, 39.44475]]]} | Open Access 1 | 25413 | Otis R. Johnson Wilderness Park | 23267 | 1412 | Fort Bragg, City of 889 | City 2 | City Agency 2 | http://city.fortbragg.com/ | City 2 | 1412 | Fort Bragg, City of 864 | City 2 | City Agency 2 | Mendocino 24 | 6.276 | Otis R. Johnson Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
| 12220 | 12220 | 12219 | {"type": "MultiPolygon", "coordinates": [[[[-123.80138, 39.44472], [-123.80137, 39.44512], [-123.80131, 39.44513], [-123.80131, 39.4454], [-123.80084, 39.44539], [-123.80084, 39.44471], [-123.80138, 39.44472]]], [[[-123.80198, 39.44513], [-123.80197, 39.44541], [-123.80171, 39.4454], [-123.80171, 39.44513], [-123.80144, 39.44513], [-123.80145, 39.44472], [-123.80197, 39.4447], [-123.80198, 39.44513]]]]} | Open Access 1 | 25414 | Harold O. Bainbridge Park | 19685 | 1412 | Fort Bragg, City of 889 | City 2 | City Agency 2 | http://city.fortbragg.com/ | City 2 | 1412 | Fort Bragg, City of 864 | City 2 | City Agency 2 | Mendocino 24 | 1.529 | Harold O. Bainbridge Park | 0 | Local Park 2 | 4 | |
| 12221 | 12221 | 12220 | {"type": "Polygon", "coordinates": [[[-123.8191, 39.42406], [-123.81909, 39.42415], [-123.81893, 39.42425], [-123.81872, 39.42428], [-123.81865, 39.4243], [-123.81859, 39.42437], [-123.81815, 39.42445], [-123.81804, 39.42444], [-123.81784, 39.4245], [-123.81769, 39.42453], [-123.81763, 39.42458], [-123.81766, 39.42462], [-123.81776, 39.42466], [-123.81791, 39.4247], [-123.81796, 39.42476], [-123.81784, 39.42487], [-123.81778, 39.42491], [-123.81778, 39.42498], [-123.81787, 39.425], [-123.81843, 39.42501], [-123.81859, 39.42505], [-123.81867, 39.4251], [-123.81867, 39.4252], [-123.81863, 39.42524], [-123.81859, 39.42534], [-123.81869, 39.4254], [-123.81873, 39.42543], [-123.81872, 39.42554], [-123.81858, 39.42558], [-123.81845, 39.42558], [-123.81836, 39.42564], [-123.81825, 39.42568], [-123.818, 39.42566], [-123.81781, 39.42571], [-123.81759, 39.42574], [-123.81739, 39.42574], [-123.81708, 39.42565], [-123.81693, 39.42566], [-123.81683, 39.42573], [-123.81688, 39.42583], [-123.81693, 39.4259], [-123.81692, 39.42594], [-123.81694, 39.426], [-123.81702, 39.4261], [-123.81702, 39.42617], [-123.81682, 39.42619], [-123.81648, 39.4262], [-123.81624, 39.42612], [-123.81598, 39.4259], [-123.81585, 39.42588], [-123.81572, 39.42575], [-123.81561, 39.42571], [-123.81526, 39.42571], [-123.81508, 39.42569], [-123.81481, 39.42574], [-123.81443, 39.42568], [-123.81427, 39.42561], [-123.81416, 39.42557], [-123.81401, 39.42557], [-123.8136, 39.42561], [-123.81329, 39.42567], [-123.81307, 39.4257], [-123.81265, 39.42581], [-123.81222, 39.42598], [-123.81195, 39.42604], [-123.81182, 39.42609], [-123.81142, 39.42611], [-123.81126, 39.42614], [-123.811, 39.42621], [-123.81078, 39.42622], [-123.81061, 39.42619], [-123.81044, 39.4262], [-123.81031, 39.42626], [-123.81023, 39.42634], [-123.81011, 39.42645], [-123.80997, 39.42666], [-123.80988, 39.42686], [-123.80966, 39.4271], [-123.80958, 39.42728], [-123.80946, 39.42733], [-123.80925, 39.42729], [-123.80904, 39.42722], [-123.8088, 39.42716], [-123.80879, 39.42618], [-123.80895, 39.42616], [-123.80933, 39.42618], [-123.80933, 39.4259], [-123.80964, 39.4259], [-123.80961, 39.42563], [-123.81037, 39.42562], [-123.81036, 39.42539], [-123.81174, 39.42535], [-123.81176, 39.42507], [-123.81213, 39.42505], [-123.81692, 39.42499], [-123.81695, 39.42417], [-123.81694, 39.42355], [-123.81732, 39.42362], [-123.81752, 39.4237], [-123.81777, 39.42374], [-123.8182, 39.42378], [-123.81838, 39.42384], [-123.81855, 39.42385], [-123.81877, 39.4238], [-123.81886, 39.42387], [-123.81893, 39.42394], [-123.81902, 39.42398], [-123.8191, 39.42406]]]} | Open Access 1 | 25415 | Pomo Bluffs Park | 23879 | 1412 | Fort Bragg, City of 889 | City 2 | City Agency 2 | http://city.fortbragg.com/ | City 2 | 1412 | Fort Bragg, City of 864 | City 2 | City Agency 2 | Mendocino 24 | 23.606 | Pomo Bluffs Park | 0 | Local Park 2 | 4 | |
| 14709 | 14709 | 14708 | {"type": "Polygon", "coordinates": [[[-123.82065, 39.43943], [-123.82054, 39.43949], [-123.8202, 39.43954], [-123.82012, 39.43957], [-123.82005, 39.43957], [-123.81986, 39.4395], [-123.8198, 39.43952], [-123.8198, 39.43954], [-123.81996, 39.43969], [-123.82003, 39.43977], [-123.82003, 39.43985], [-123.81998, 39.43993], [-123.81991, 39.43997], [-123.81985, 39.43996], [-123.81953, 39.43983], [-123.81931, 39.4398], [-123.81913, 39.43966], [-123.81903, 39.43955], [-123.81895, 39.43944], [-123.81884, 39.43944], [-123.81878, 39.43946], [-123.81865, 39.43942], [-123.81859, 39.4393], [-123.81853, 39.43927], [-123.81843, 39.43926], [-123.81836, 39.43927], [-123.81822, 39.43922], [-123.81812, 39.43922], [-123.81805, 39.43919], [-123.8179, 39.43899], [-123.8178, 39.43892], [-123.81772, 39.4389], [-123.81764, 39.43891], [-123.81753, 39.43886], [-123.81735, 39.43874], [-123.81722, 39.43856], [-123.8172, 39.4385], [-123.81725, 39.43842], [-123.81708, 39.43826], [-123.81698, 39.43819], [-123.81688, 39.43815], [-123.81665, 39.4381], [-123.81623, 39.43825], [-123.81606, 39.43835], [-123.81592, 39.43849], [-123.81419, 39.43822], [-123.81378, 39.43907], [-123.81432, 39.43956], [-123.81405, 39.43974], [-123.81316, 39.43896], [-123.81355, 39.43816], [-123.81386, 39.43816], [-123.81396, 39.43788], [-123.81548, 39.43811], [-123.81643, 39.43705], [-123.81567, 39.43617], [-123.81547, 39.43543], [-123.8145, 39.43429], [-123.81259, 39.43195], [-123.81318, 39.43202], [-123.81308, 39.43192], [-123.81239, 39.43183], [-123.81208, 39.43194], [-123.81181, 39.43208], [-123.8115, 39.43226], [-123.81127, 39.43247], [-123.81097, 39.43258], [-123.81057, 39.43238], [-123.81039, 39.43141], [-123.80997, 39.43125], [-123.80874, 39.43113], [-123.80812, 39.43079], [-123.80806, 39.43084], [-123.80747, 39.43051], [-123.80658, 39.43007], [-123.80659, 39.42993], [-123.80676, 39.42983], [-123.8074, 39.43015], [-123.80837, 39.43067], [-123.80841, 39.43063], [-123.80864, 39.43075], [-123.80949, 39.43075], [-123.80937, 39.43069], [-123.80878, 39.43007], [-123.80862, 39.43003], [-123.80818, 39.4296], [-123.80788, 39.42954], [-123.80738, 39.42895], [-123.80733, 39.42894], [-123.80686, 39.42832], [-123.8069, 39.428], [-123.80775, 39.42797], [-123.8083, 39.428], [-123.80883, 39.42813], [-123.80899, 39.42821], [-123.80897, 39.42797], [-123.80888, 39.4278], [-123.81, 39.42797], [-123.81051, 39.42807], [-123.81057, 39.42814], [-123.81052, 39.42824], [-123.81048, 39.42828], [-123.81028, 39.42826], [-123.81022, 39.4282], [-123.81013, 39.42817], [-123.8096, 39.4281], [-123.80948, 39.42811], [-123.80937, 39.42822], [-123.8093, 39.42837], [-123.80927, 39.42873], [-123.80931, 39.42899], [-123.80953, 39.4295], [-123.80966, 39.42973], [-123.80992, 39.43004], [-123.81012, 39.43025], [-123.81053, 39.43052], [-123.81065, 39.43057], [-123.81085, 39.43057], [-123.81098, 39.43052], [-123.81113, 39.4305], [-123.81156, 39.43062], [-123.8118, 39.43063], [-123.81196, 39.4306], [-123.81216, 39.43049], [-123.81243, 39.43053], [-123.81243, 39.43061], [-123.81253, 39.43075], [-123.81284, 39.43089], [-123.81315, 39.43102], [-123.81341, 39.4311], [-123.81365, 39.43111], [-123.81383, 39.43111], [-123.81385, 39.43106], [-123.81385, 39.43085], [-123.81389, 39.43078], [-123.81396, 39.43074], [-123.81402, 39.43072], [-123.8142, 39.4307], [-123.81438, 39.43075], [-123.81446, 39.43075], [-123.81453, 39.43072], [-123.81461, 39.43062], [-123.81479, 39.43058], [-123.81491, 39.43053], [-123.81506, 39.43055], [-123.81524, 39.43047], [-123.81537, 39.43048], [-123.8154, 39.43051], [-123.81541, 39.43063], [-123.81546, 39.43065], [-123.81551, 39.43065], [-123.81558, 39.43062], [-123.81568, 39.4306], [-123.81578, 39.43062], [-123.81585, 39.43066], [-123.8159, 39.43071], [-123.81594, 39.43084], [-123.81601, 39.43091], [-123.81602, 39.43095], [-123.816, 39.43101], [-123.816, 39.4311], [-123.81603, 39.43119], [-123.8161, 39.43127], [-123.81615, 39.43142], [-123.81619, 39.43148], [-123.81633, 39.43156], [-123.81642, 39.43158], [-123.81667, 39.43159], [-123.81671, 39.43165], [-123.81671, 39.4317], [-123.81667, 39.43184], [-123.81648, 39.43194], [-123.81645, 39.432], [-123.81648, 39.43204], [-123.81655, 39.43206], [-123.81663, 39.43205], [-123.81677, 39.43198], [-123.81683, 39.43198], [-123.81688, 39.43201], [-123.8169, 39.43207], [-123.81686, 39.43222], [-123.81685, 39.4324], [-123.81681, 39.43245], [-123.81676, 39.43247], [-123.81668, 39.43247], [-123.81659, 39.43251], [-123.8166, 39.43256], [-123.81672, 39.43273], [-123.81676, 39.43287], [-123.81693, 39.43304], [-123.81695, 39.43315], [-123.817, 39.43319], [-123.81726, 39.43332], [-123.81736, 39.43343], [-123.81749, 39.43366], [-123.81759, 39.43376], [-123.81782, 39.43411], [-123.81786, 39.43422], [-123.81784, 39.43428], [-123.81785, 39.43435], [-123.81792, 39.43441], [-123.81793, 39.43449], [-123.81785, 39.43457], [-123.8178, 39.43465], [-123.81781, 39.43469], [-123.81789, 39.43476], [-123.81792, 39.43484], [-123.81789, 39.43492], [-123.81784, 39.43499], [-123.81783, 39.43505], [-123.81793, 39.43514], [-123.81794, 39.43521], [-123.81792, 39.43532], [-123.81792, 39.43538], [-123.81799, 39.43552], [-123.81797, 39.43574], [-123.81804, 39.43583], [-123.81816, 39.4359], [-123.81826, 39.43601], [-123.81823, 39.4361], [-123.81823, 39.4362], [-123.81819, 39.43629], [-123.81811, 39.43637], [-123.81809, 39.43646], [-123.81815, 39.43652], [-123.81848, 39.43652], [-123.81848, 39.43646], [-123.81846, 39.4364], [-123.8185, 39.43623], [-123.81851, 39.43606], [-123.81854, 39.43599], [-123.81861, 39.43594], [-123.81878, 39.43594], [-123.81886, 39.43603], [-123.81894, 39.43604], [-123.81905, 39.43601], [-123.81908, 39.43596], [-123.81918, 39.43593], [-123.81925, 39.43598], [-123.81925, 39.43607], [-123.81941, 39.43623], [-123.81943, 39.43628], [-123.81944, 39.43643], [-123.81947, 39.43654], [-123.81953, 39.4366], [-123.81957, 39.43666], [-123.81964, 39.43671], [-123.81981, 39.43694], [-123.81989, 39.4371], [-123.81988, 39.43716], [-123.81979, 39.43721], [-123.8197, 39.43721], [-123.8196, 39.43719], [-123.81938, 39.43718], [-123.81921, 39.43713], [-123.81891, 39.43709], [-123.81885, 39.43717], [-123.81884, 39.43723], [-123.819, 39.43739], [-123.81906, 39.43744], [-123.81925, 39.43773], [-123.81931, 39.4378], [-123.81942, 39.43802], [-123.81934, 39.43812], [-123.81932, 39.43821], [-123.81939, 39.43829], [-123.81948, 39.43833], [-123.81955, 39.43838], [-123.81954, 39.43846], [-123.81957, 39.43852], [-123.82028, 39.43912], [-123.82057, 39.43934], [-123.82065, 39.43943]]]} | Open Access 1 | 45043 | Noyo Headlands Park | 30748 | 1412 | Fort Bragg, City of 889 | City 2 | City Agency 2 | http://city.fortbragg.com/ | City 2 | 1412 | Fort Bragg, City of 864 | City 2 | City Agency 2 | Mendocino 24 | 93.406 | Noyo Headlands Park | 2015 | Local Park 2 | 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]);