units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
79 rows where ACCESS_TYP = 3 and MNG_AGENCY = 25 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, GAP_STS
DES_TP 4
LAYER 2 ✖
MNG_AG_TYP 1
- State Agency 79
MNG_AGENCY 1
- California Department of Fish and Wildlife · 79 ✖
ACCESS_TYP 1
- No Public Access · 79 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3427 | 3427 | 3426 | {"type": "Polygon", "coordinates": [[[-122.01238, 36.97053], [-122.01187, 36.97081], [-122.01185, 36.97079], [-122.01191, 36.97056], [-122.01223, 36.97036], [-122.01238, 36.97053]]]} | No Public Access 3 | 25174 | South Branciforte | 32313 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Santa Cruz 5 | 0.251 | South Branciforte | 0 | State Resource Management Area 55 | 3 | |
6173 | 6173 | 6172 | {"type": "Polygon", "coordinates": [[[-122.64262, 37.8994], [-122.64213, 37.8998], [-122.64167, 37.8996], [-122.64213, 37.89912], [-122.64242, 37.8992], [-122.64262, 37.8994]]]} | No Public Access 3 | 1204 | Stinson Beach | 32319 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Marin 23 | 0.833 | Stinson Beach | 0 | State Resource Management Area 55 | 3 | |
14340 | 14340 | 14339 | {"type": "Polygon", "coordinates": [[[-121.94459, 36.97664], [-121.94396, 36.97675], [-121.94326, 36.97677], [-121.94325, 36.9766], [-121.94341, 36.97632], [-121.94317, 36.97587], [-121.94331, 36.97591], [-121.94353, 36.97635], [-121.9438, 36.97644], [-121.94437, 36.97649], [-121.94459, 36.97664]]]} | No Public Access 3 | 44373 | Escalona Gulch | 32161 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Santa Cruz 5 | 1.02 | Escalona Gulch | 0 | State Resource Management Area 55 | 3 | |
545 | 545 | 544 | {"type": "Polygon", "coordinates": [[[-122.31307, 41.2763], [-122.31264, 41.2763], [-122.31266, 41.2752], [-122.31307, 41.2752], [-122.31307, 41.2763]]]} | No Public Access 3 | 1814 | Lower Box Canyon | 32208 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Siskiyou 28 | 1.061 | Lower Box Canyon | 0 | State Resource Management Area 55 | 3 | |
12266 | 12266 | 12265 | {"type": "Polygon", "coordinates": [[[-121.38053, 41.88124], [-121.37932, 41.88126], [-121.37932, 41.87996], [-121.38052, 41.87996], [-121.38053, 41.88124]]]} | No Public Access 3 | 25910 | Newell Creek Cabin Site | 32244 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Modoc 56 | 3.56 | Newell Creek Cabin Site | 0 | State Resource Management Area 55 | 3 | |
4842 | 4842 | 4841 | {"type": "Polygon", "coordinates": [[[-122.70265, 38.97554], [-122.70213, 38.97651], [-122.7016, 38.97676], [-122.7006, 38.97679], [-122.70085, 38.97617], [-122.70146, 38.9756], [-122.70265, 38.97554]]]} | No Public Access 3 | 2140 | Monitor Island | 32231 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Lake 40 | 3.761 | Monitor Island | 0 | State Resource Management Area 55 | 3 | |
5245 | 5245 | 5244 | {"type": "Polygon", "coordinates": [[[-122.52297, 41.8958], [-122.52259, 41.89608], [-122.52198, 41.89642], [-122.5213, 41.89687], [-122.52065, 41.89629], [-122.52078, 41.89611], [-122.52229, 41.89521], [-122.52297, 41.8958]]]} | No Public Access 3 | 1341 | Klamathon Station | 32197 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Siskiyou 28 | 4.018 | Klamathon Station | 0 | State Resource Management Area 55 | 3 | |
3485 | 3485 | 3484 | {"type": "Polygon", "coordinates": [[[-123.05209, 38.33746], [-123.05198, 38.33754], [-123.05179, 38.33741], [-123.05131, 38.33782], [-123.05136, 38.33837], [-123.04991, 38.33944], [-123.04926, 38.33873], [-123.05025, 38.33836], [-123.05118, 38.33786], [-123.05131, 38.33741], [-123.05145, 38.33698], [-123.05209, 38.33746]]]} | No Public Access 3 | 25904 | Bodega Bay Monarch Butterfly | 32057 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Sonoma 16 | 4.076 | Bodega Bay Monarch Butterfly | 0 | State Resource Management Area 55 | 3 | |
7673 | 7673 | 7672 | {"type": "Polygon", "coordinates": [[[-120.99914, 40.31163], [-120.99859, 40.31171], [-120.99851, 40.31129], [-120.99668, 40.31149], [-120.9969, 40.31103], [-120.99705, 40.31094], [-120.99856, 40.31086], [-120.99813, 40.31023], [-120.99861, 40.31003], [-120.99911, 40.31023], [-120.99914, 40.31163]]]} | No Public Access 3 | 7584 | Mountain Meadows | 32238 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Lassen 54 | 4.353 | Mtn. Meadows | 0 | State Resource Management Area 55 | 3 | |
10020 | 10020 | 10019 | {"type": "Polygon", "coordinates": [[[-120.28166, 37.25478], [-120.28099, 37.25642], [-120.27927, 37.25501], [-120.27926, 37.25459], [-120.27982, 37.25436], [-120.27995, 37.25478], [-120.2801, 37.25503], [-120.28032, 37.25511], [-120.28065, 37.25511], [-120.28166, 37.25478]]]} | No Public Access 3 | 17278 | Le Grand | 32200 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Merced 37 | 4.88 | Le Grand | 0 | State Resource Management Area 55 | 3 | |
12567 | 12567 | 12566 | {"type": "Polygon", "coordinates": [[[-116.80776, 34.25506], [-116.80546, 34.25503], [-116.80552, 34.25267], [-116.80555, 34.25223], [-116.80581, 34.25222], [-116.80587, 34.25399], [-116.8077, 34.25401], [-116.80776, 34.25506]]]} | No Public Access 3 | 29074 | Shay Meadow | 32307 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Bernardino 22 | 7.409 | Shay Meadow | 0 | State Resource Management Area 55 | 3 | |
6527 | 6527 | 6526 | {"type": "Polygon", "coordinates": [[[-121.21611, 38.65634], [-121.21517, 38.65635], [-121.2144, 38.65533], [-121.21395, 38.65428], [-121.21608, 38.65427], [-121.21611, 38.65634]]]} | No Public Access 3 | 2848 | Phoenix Field Ecological Reserve | 32261 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Sacramento 41 | 8.007 | Phoenix Field ER | 0 | State Conservation Area 8 | 2 | |
228 | 228 | 227 | {"type": "Polygon", "coordinates": [[[-122.33028, 41.31414], [-122.32908, 41.31415], [-122.32909, 41.31022], [-122.32966, 41.31067], [-122.33018, 41.31094], [-122.33021, 41.31196], [-122.33028, 41.31197], [-122.33028, 41.31414]]]} | No Public Access 3 | 621 | Elsa Rupp Natural Area | 32160 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Siskiyou 28 | 9.475 | Elsa Rupp Natural Area | None 26 | |||
14660 | 14660 | 14659 | {"type": "Polygon", "coordinates": [[[-116.10145, 34.19582], [-116.10145, 34.19703], [-116.09814, 34.19705], [-116.09814, 34.19584], [-116.10145, 34.19582]]]} | No Public Access 3 | 44923 | Twentynine Palms - Valle Vista Road | 32334 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Bernardino 22 | 10.115 | Twentynine Palms - Valle Vista Road | 0 | State Resource Management Area 55 | 3 | |
13181 | 13181 | 13180 | {"type": "Polygon", "coordinates": [[[-122.92622, 38.21025], [-122.92607, 38.2121], [-122.9261, 38.21451], [-122.92537, 38.21453], [-122.92543, 38.21398], [-122.9252, 38.21396], [-122.92534, 38.21304], [-122.92489, 38.21275], [-122.92481, 38.21267], [-122.92468, 38.21246], [-122.92464, 38.21237], [-122.92459, 38.21217], [-122.92434, 38.21196], [-122.92414, 38.21165], [-122.92392, 38.21134], [-122.92379, 38.21121], [-122.92373, 38.21108], [-122.92373, 38.21095], [-122.92376, 38.21086], [-122.92383, 38.21078], [-122.92388, 38.21074], [-122.924, 38.21071], [-122.92413, 38.2107], [-122.92483, 38.21075], [-122.92503, 38.21072], [-122.92521, 38.21068], [-122.92534, 38.21057], [-122.9254, 38.2105], [-122.92561, 38.21012], [-122.92562, 38.21043], [-122.92581, 38.21043], [-122.92581, 38.21025], [-122.92622, 38.21025]]]} | No Public Access 3 | 35164 | Walker Creek Marsh | 32346 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Marin 23 | 13.468 | Walker Creek Marsh | 0 | State Resource Management Area 55 | 3 | |
3147 | 3147 | 3146 | {"type": "MultiPolygon", "coordinates": [[[[-120.81642, 38.5584], [-120.8161, 38.55859], [-120.81609, 38.55862], [-120.81611, 38.55839], [-120.81642, 38.5584]]], [[[-120.82405, 38.55808], [-120.82414, 38.55836], [-120.82417, 38.55862], [-120.82414, 38.55901], [-120.82407, 38.55919], [-120.82377, 38.55954], [-120.82358, 38.55964], [-120.82332, 38.55973], [-120.82311, 38.55974], [-120.82289, 38.55977], [-120.82264, 38.55976], [-120.82233, 38.5597], [-120.82197, 38.55968], [-120.82166, 38.55965], [-120.82129, 38.55955], [-120.82089, 38.55941], [-120.8206, 38.55925], [-120.82011, 38.55885], [-120.81942, 38.55845], [-120.81877, 38.55822], [-120.81842, 38.55813], [-120.81821, 38.55806], [-120.82405, 38.55808]]]]} | No Public Access 3 | 21619 | Upper Cosumnes River | 32342 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Amador 52 | 15.616 | Upper Cosumnes River | 0 | State Resource Management Area 55 | 3 | |
10291 | 10291 | 10290 | {"type": "Polygon", "coordinates": [[[-121.32414, 38.16873], [-121.32419, 38.16888], [-121.3242, 38.16903], [-121.32407, 38.16947], [-121.32391, 38.16971], [-121.32379, 38.16982], [-121.32359, 38.16992], [-121.32342, 38.16995], [-121.32332, 38.16994], [-121.32316, 38.16995], [-121.3231, 38.17], [-121.32285, 38.17029], [-121.32276, 38.17044], [-121.32275, 38.17058], [-121.32279, 38.17069], [-121.32322, 38.17134], [-121.32325, 38.17142], [-121.32323, 38.17154], [-121.32317, 38.17165], [-121.32301, 38.1718], [-121.32293, 38.17185], [-121.32273, 38.17193], [-121.32219, 38.17208], [-121.32157, 38.17221], [-121.32149, 38.17221], [-121.32132, 38.17227], [-121.321, 38.17242], [-121.32093, 38.17249], [-121.32064, 38.17281], [-121.32037, 38.17315], [-121.32031, 38.17332], [-121.3203, 38.17346], [-121.32031, 38.17362], [-121.3204, 38.17381], [-121.32051, 38.17395], [-121.32084, 38.17416], [-121.32115, 38.17431], [-121.3212, 38.17437], [-121.32119, 38.17444], [-121.321, 38.17452], [-121.32034, 38.17474], [-121.32021, 38.17476], [-121.32008, 38.17476], [-121.31994, 38.17473], [-121.31948, 38.17456], [-121.31929, 38.17442], [-121.31919, 38.17419], [-121.31922, 38.17414], [-121.31932, 38.17405], [-121.3194, 38.17407], [-121.31944, 38.17418], [-121.31956, 38.17418], [-121.3197, 38.17405], [-121.3198, 38.17387], [-121.31977, 38.17379], [-121.31972, 38.17372], [-121.31963, 38.17368], [-121.31953, 38.17369], [-121.31937, 38.17375], [-121.31924, 38.17373], [-121.31916, 38.17369], [-121.31911, 38.17365], [-121.31899, 38.17308], [-121.31922, 38.1731], [-121.31946, 38.17269], [-121.32024, 38.17242], [-121.32033, 38.17241], [-121.3206, 38.1725], [-121.32075, 38.17234], [-121.321, 38.17241], [-121.32131, 38.17205], [-121.32184, 38.17185], [-121.3227, 38.17159], [-121.32277, 38.17145], [-121.3227, 38.17127], [-121.32253, 38.17112], [-121.32241, 38.17081], [-121.3224, 38.17059], [-121.32249, 38.17038], [-121.32264, 38.17018], [-121.32286, 38.17], [-121.32309, 38.16986], [-121.32336, 38.16973], [-121.32344, 38.16953], [-121.32338, 38.16949], [-121.32249, 38.16966], [-121.32201, 38.16966], [-121.32149, 38.1697], [-121.32108, 38.16967], [-121.32088, 38.16929], [-121.32072, 38.16927], [-121.32054, 38.16927], [-121.32008, 38.16898], [-121.31985, 38.16888], [-121.31981, 38.1688], [-121.31971, 38.16885], [-121.31956, 38.1688], [-121.31923, 38.16878], [-121.31877, 38.16894], [-121.31816, 38.16903], [-121.31734, 38.16903], [-121.31667, 38.16922], [-121.31617, 38.16947], [-121.31573, 38.16964], [-121.31536, 38.1698], [-121.31491, 38.16981], [-121.31437, 38.16958], [-121.31441, 38.16952], [-121.31472, 38.16966], [-121.31492, 38.16972], [-121.31507, 38.16975], [-121.31545, 38.16967], [-121.31564, 38.1696], [-121.31622, 38.16927], [-121.31636, 38.16916], [-121.31652, 38.169], [-121.31696, 38.16867], [-121.3173, 38.16855], [-121.31772, 38.16846], [-121.3179, 38.16843], [-121.31823, 38.16843], [-121.31837, 38.16844], [-121.31866, 38.1685], [-121.31879, 38.16862], [-121.31906, 38.16862], [-121.31944, 38.16861], [-121.3197, 38.16857], [-121.31994, 38.16851], [-121.32027, 38.16837], [-121.32037, 38.16836], [-121.32044, 38.16837], [-121.32054, 38.16842], [-121.3206, 38.16848], [-121.32064, 38.16853], [-121.32069, 38.16867], [-121.32069, 38.16884], [-121.32062, 38.16915], [-121.32079, 38.16925], [-121.32098, 38.16933], [-121.32187, 38.16946], [-121.32214, 38.16945], [-121.32247, 38.16941], [-121.32293, 38.16928], [-121.32321, 38.16915], [-121.32351, 38.16893], [-121.32385, 38.16874], [-121.32399, 38.16869], [-121.32414, 38.16873]]]} | No Public Access 3 | 18085 | Mokelumne River | 32229 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Joaquin 39 | 18.457 | Mokelumne River | 0 | State Resource Management Area 55 | 3 | |
5484 | 5484 | 5483 | {"type": "Polygon", "coordinates": [[[-121.45171, 37.99673], [-121.45157, 37.99753], [-121.45125, 37.99803], [-121.44772, 37.99697], [-121.449, 37.99516], [-121.45045, 37.99469], [-121.45112, 37.99482], [-121.4517, 37.99592], [-121.45175, 37.99649], [-121.45171, 37.99673]]]} | No Public Access 3 | 18030 | Acker Island | 32009 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Joaquin 39 | 20.966 | Acker Island | 0 | State Resource Management Area 55 | 3 | |
3489 | 3489 | 3488 | {"type": "Polygon", "coordinates": [[[-121.97758, 37.42901], [-121.97746, 37.43245], [-121.97438, 37.4325], [-121.97433, 37.42904], [-121.97758, 37.42901]]]} | No Public Access 3 | 25900 | San Francisco Bay | 32293 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Santa Clara 19 | 26.519 | San Francisco Bay | 1980 | State Resource Management Area 55 | 3 | |
15621 | 15621 | 15620 | {"type": "MultiPolygon", "coordinates": [[[[-120.61073, 39.50453], [-120.61064, 39.50618], [-120.60842, 39.50617], [-120.6085, 39.50449], [-120.61073, 39.50453]]], [[[-120.61327, 39.51192], [-120.61072, 39.51188], [-120.61068, 39.50845], [-120.6132, 39.50845], [-120.61323, 39.51019], [-120.61327, 39.51192]]]]} | No Public Access 3 | 21576 | Macklin Creek Ecological Reserve | 32211 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Nevada 30 | 29.458 | Macklin Creek ER | 0 | State Conservation Area 8 | 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]);