units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,490 rows where MNG_AG_LEV = 3 sorted by ACCESS_TYP
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, County of 174
- San Diego, County of 122
- Santa Barbara, County of 116
- Orange, County of 95
- Los Angeles - Department of Parks and Recreation, County of 65
- Lake, County of 56
- Sacramento, County of 56
- Santa Clara County Parks and Recreation Dept., County of 55
- Butte, County of 53
- Sonoma County Regional Parks Dept., County of 50
- Santa Cruz, County of 47
- Kern, County of 47
- Monterey, County of 45
- El Dorado, County of 44
- Riverside, County of 39
- Marin County Parks Department, County of 34
- Placer, County of 28
- San Luis Obispo, County of 27
- Ventura, County of 24
- Stanislaus, County of 24
- San Mateo County Parks and Recreation Dept., County of 23
- San Joaquin, County of 21
- San Bernardino, County of 20
- Yolo, County of 18
- Fresno, County of 17
- Merced, County of 16
- San Francisco - Public Utilities Commission, City and County of 14
- Humboldt, County of 12
- Tulare, County of 11
- Contra Costa County Public Works Dept., County of 11
- …
DES_TP >30
- Local Park 793
- Local Other or Unknown 221
- Local Recreation Area 158
- Local Conservation Area 117
- Local Historic or Cultural Area 21
- Local Resource Management Area 8
- National Recreation Area 3
- National Forest 2
- National Monument or Landmark 2
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 1,304
- Restricted Access 82
- No Public Access 47
- Unknown Access 37
MNG_AG_TYP 3
- County Agency 1,201
- County Agency - Parks 234
- County Agency - Other 35
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
269 | 269 | 268 | {"type": "Polygon", "coordinates": [[[-120.10404, 37.44406], [-120.10403, 37.44496], [-120.10267, 37.44507], [-120.10278, 37.44409], [-120.10404, 37.44406]]]} | Open Access 1 | 47348 | Catheys Valley Cemetery | 31064 | 307 | Mariposa, County of 110 | County 3 | County Agency 3 | https://www.mariposacounty.org/index.aspx?NID=207 | County 3 | 307 | Mariposa, County of 107 | County 3 | County Agency 3 | Mariposa 31 | 2.97 | Catheys Valley Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
273 | 273 | 272 | {"type": "Polygon", "coordinates": [[[-117.22664, 33.05068], [-117.22596, 33.05276], [-117.2242, 33.05232], [-117.22397, 33.05269], [-117.22342, 33.05309], [-117.22333, 33.0532], [-117.22327, 33.05335], [-117.22319, 33.05333], [-117.22285, 33.05437], [-117.2217, 33.05409], [-117.22056, 33.05378], [-117.21929, 33.05347], [-117.21921, 33.05335], [-117.2161, 33.05151], [-117.2152, 33.05153], [-117.21517, 33.05106], [-117.21518, 33.05083], [-117.21545, 33.0506], [-117.21594, 33.05075], [-117.21635, 33.05105], [-117.21679, 33.05145], [-117.21732, 33.05162], [-117.21818, 33.05212], [-117.21855, 33.05236], [-117.2191, 33.05245], [-117.21953, 33.05245], [-117.22, 33.05237], [-117.22063, 33.05218], [-117.22118, 33.05198], [-117.22176, 33.05197], [-117.22196, 33.05142], [-117.22206, 33.05144], [-117.22209, 33.05145], [-117.2219, 33.052], [-117.2221, 33.05204], [-117.22236, 33.0522], [-117.22247, 33.05237], [-117.22239, 33.05293], [-117.22239, 33.05312], [-117.22257, 33.05319], [-117.22287, 33.05307], [-117.22318, 33.05292], [-117.22333, 33.05278], [-117.22331, 33.05265], [-117.22347, 33.05211], [-117.22328, 33.0517], [-117.2231, 33.0515], [-117.22291, 33.05106], [-117.22291, 33.05094], [-117.22294, 33.05091], [-117.22296, 33.0508], [-117.22288, 33.05078], [-117.22291, 33.05061], [-117.22294, 33.0506], [-117.22293, 33.05044], [-117.22297, 33.0501], [-117.22301, 33.0501], [-117.22307, 33.05], [-117.22299, 33.04997], [-117.22302, 33.04982], [-117.22309, 33.04984], [-117.22316, 33.04971], [-117.22322, 33.04966], [-117.2235, 33.04936], [-117.22355, 33.04924], [-117.22352, 33.04914], [-117.22363, 33.049], [-117.22362, 33.04898], [-117.22385, 33.04877], [-117.2239, 33.04867], [-117.22389, 33.04866], [-117.22404, 33.04837], [-117.22402, 33.04835], [-117.22407, 33.04826], [-117.22407, 33.04819], [-117.22411, 33.04819], [-117.22416, 33.04806], [-117.2241, 33.04804], [-117.22416, 33.0479], [-117.2241, 33.04783], [-117.22609, 33.04832], [-117.22544, 33.05038], [-117.22664, 33.05068]]]} | Open Access 1 | 745 | Val Sereno Preserve | 26755 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 54.542 | Val Sereno Preserve | 0 | Local Conservation Area 4 | 2 | |
279 | 279 | 278 | {"type": "Polygon", "coordinates": [[[-118.22958, 34.6528], [-118.22758, 34.6528], [-118.22752, 34.65275], [-118.22746, 34.65017], [-118.22952, 34.65016], [-118.22958, 34.6528]]]} | Open Access 1 | 948 | George Lane Park | 19270 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 13.666 | George Lane Park | 0 | Local Park 2 | 4 | |
284 | 284 | 283 | {"type": "Polygon", "coordinates": [[[-116.4753, 32.60867], [-116.47487, 32.60888], [-116.47435, 32.60914], [-116.47431, 32.60887], [-116.47465, 32.60861], [-116.47505, 32.60838], [-116.4753, 32.60867]]]} | Open Access 1 | 766 | Campo Stone Store | 29229 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://ohp.parks.ca.gov/ListedResources/Detail/411 | San Diego 4 | 0.82 | Campo Stone Store | None 31 | ||
288 | 288 | 287 | {"type": "Polygon", "coordinates": [[[-121.1085, 35.56657], [-121.10785, 35.56657], [-121.10746, 35.56522], [-121.10769, 35.56517], [-121.10777, 35.5654], [-121.10792, 35.56539], [-121.10789, 35.56525], [-121.10824, 35.56519], [-121.1085, 35.56657]]]} | Open Access 1 | 772 | Shamel Park | 25354 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 2.347 | Shamel Park | 0 | Local Park 2 | 4 | |
314 | 314 | 313 | {"type": "Polygon", "coordinates": [[[-119.69311, 34.46023], [-119.69221, 34.46094], [-119.69162, 34.46037], [-119.6916, 34.46001], [-119.69199, 34.45915], [-119.69235, 34.45915], [-119.69311, 34.46023]]]} | Open Access 1 | 847 | Skofield Park | 25529 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 4.077 | Skofield Park | 0 | Local Park 2 | 4 | |
339 | 339 | 338 | {"type": "Polygon", "coordinates": [[[-121.95538, 36.98556], [-121.95509, 36.9857], [-121.95498, 36.98583], [-121.95502, 36.98592], [-121.95472, 36.98598], [-121.95477, 36.98571], [-121.9549, 36.98545], [-121.95538, 36.98556]]]} | Open Access 1 | 932 | Soquel Lions Park | 25623 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 0.38 | Soquel Lions Park | 0 | Local Park 2 | 4 | |
345 | 345 | 344 | {"type": "Polygon", "coordinates": [[[-119.5898, 34.42352], [-119.58906, 34.42428], [-119.5885, 34.42388], [-119.58922, 34.42315], [-119.5898, 34.42352]]]} | Open Access 1 | 1191 | Summerland Greenwell Preserve | 25961 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 1.774 | Summerland Greenwell Preserve | 0 | Local Conservation Area 4 | 2 | |
349 | 349 | 348 | {"type": "Polygon", "coordinates": [[[-117.81409, 33.75983], [-117.81374, 33.7598], [-117.81369, 33.75976], [-117.81367, 33.75975], [-117.81366, 33.75914], [-117.81378, 33.75944], [-117.81391, 33.75962], [-117.81409, 33.75983]]]} | Open Access 1 | 959 | Holderman Park | 20027 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 0.281 | Holderman Park | 0 | Local Park 2 | 4 | |
377 | 377 | 376 | {"type": "MultiPolygon", "coordinates": [[[[-122.63741, 38.12007], [-122.63652, 38.12048], [-122.63581, 38.12056], [-122.63427, 38.12059], [-122.63219, 38.12082], [-122.63072, 38.12113], [-122.63011, 38.12046], [-122.63011, 38.12018], [-122.63741, 38.12007]]], [[[-122.65936, 38.11021], [-122.65936, 38.11113], [-122.65811, 38.11088], [-122.65765, 38.11101], [-122.65744, 38.11116], [-122.65704, 38.11178], [-122.65712, 38.11228], [-122.65707, 38.11254], [-122.65714, 38.11312], [-122.65688, 38.11345], [-122.65636, 38.11364], [-122.65601, 38.11358], [-122.65542, 38.11317], [-122.65416, 38.11323], [-122.65372, 38.11339], [-122.65371, 38.11369], [-122.65377, 38.11389], [-122.65395, 38.11408], [-122.65437, 38.11443], [-122.65407, 38.11581], [-122.65247, 38.11544], [-122.65221, 38.11541], [-122.65197, 38.11541], [-122.65156, 38.11549], [-122.65117, 38.11566], [-122.65054, 38.11598], [-122.64716, 38.11789], [-122.64712, 38.11622], [-122.65079, 38.11475], [-122.6518, 38.11272], [-122.65291, 38.11126], [-122.65452, 38.11062], [-122.65452, 38.10997], [-122.65048, 38.10962], [-122.647, 38.11051], [-122.64693, 38.10718], [-122.65128, 38.10727], [-122.65565, 38.10662], [-122.65936, 38.11021]]]]} | Open Access 1 | 1118 | Stafford Lake County Park | 25774 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 151.667 | Stafford Lake County Park | 2000 | Local Park 2 | 4 | |
387 | 387 | 386 | {"type": "Polygon", "coordinates": [[[-119.84568, 34.44599], [-119.84615, 34.44647], [-119.84624, 34.44662], [-119.84629, 34.44677], [-119.8465, 34.44822], [-119.84663, 34.44933], [-119.84663, 34.44955], [-119.84655, 34.4499], [-119.84653, 34.45018], [-119.84655, 34.45047], [-119.84663, 34.45075], [-119.84662, 34.45079], [-119.8466, 34.45083], [-119.84655, 34.45087], [-119.84628, 34.45093], [-119.84609, 34.45095], [-119.8459, 34.45096], [-119.84512, 34.45092], [-119.84515, 34.45003], [-119.8452, 34.44961], [-119.84524, 34.44939], [-119.8453, 34.44915], [-119.84542, 34.44878], [-119.84574, 34.44803], [-119.84584, 34.44762], [-119.84586, 34.44739], [-119.84586, 34.44718], [-119.84584, 34.44697], [-119.8458, 34.44677], [-119.84565, 34.44636], [-119.84555, 34.44616], [-119.84545, 34.446], [-119.84553, 34.44596], [-119.8456, 34.44597], [-119.84565, 34.44601], [-119.84568, 34.44599]]]} | Open Access 1 | 1154 | Stow Grove Park | 25905 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 11.813 | Stow Grove Park | 0 | Local Park 2 | 4 | |
392 | 392 | 391 | {"type": "Polygon", "coordinates": [[[-117.64422, 33.55212], [-117.64418, 33.55263], [-117.64416, 33.55266], [-117.64412, 33.55267], [-117.64351, 33.55263], [-117.6435, 33.5526], [-117.64355, 33.55204], [-117.64422, 33.55212]]]} | Open Access 1 | 35760 | Orange holding 14 | 23161 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 0.99 | Orange holding 14 | 0 | Local Other or Unknown 14 | 4 | |
393 | 393 | 392 | {"type": "Polygon", "coordinates": [[[-117.63356, 33.5534], [-117.63355, 33.55342], [-117.63311, 33.55365], [-117.63308, 33.55364], [-117.63287, 33.55333], [-117.6327, 33.553], [-117.63271, 33.55298], [-117.63319, 33.55282], [-117.63322, 33.55283], [-117.63338, 33.55312], [-117.63356, 33.5534]]]} | Open Access 1 | 35761 | Orange holding 15 | 23162 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 1.023 | Orange holding 15 | 0 | Local Other or Unknown 14 | 4 | |
414 | 414 | 413 | {"type": "Polygon", "coordinates": [[[-121.99027, 36.96704], [-121.98919, 36.96912], [-121.98905, 36.9695], [-121.98804, 36.9695], [-121.98722, 36.96943], [-121.98774, 36.96794], [-121.98768, 36.96792], [-121.98777, 36.96788], [-121.98814, 36.96779], [-121.98895, 36.96735], [-121.98913, 36.96739], [-121.99027, 36.96704]]]} | Open Access 1 | 830 | Simpkins Swim Center | 25513 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 9.9 | Simpkins Swim Ctr. | 0 | Local Recreation Area 3 | 4 | |
423 | 423 | 422 | {"type": "Polygon", "coordinates": [[[-120.7087, 35.54967], [-120.70788, 35.55014], [-120.70681, 35.54963], [-120.7074, 35.54889], [-120.7087, 35.54967]]]} | Open Access 1 | 1306 | Templeton Community Park | 26237 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 2.932 | Templeton Community Park | 0 | Local Park 2 | 4 | |
425 | 425 | 424 | {"type": "MultiPolygon", "coordinates": [[[[-121.86668, 36.99615], [-121.86622, 36.99659], [-121.86588, 36.99638], [-121.86594, 36.99611], [-121.86598, 36.99604], [-121.86629, 36.99605], [-121.86668, 36.99615]]], [[[-121.86716, 36.99638], [-121.86716, 36.99639], [-121.86607, 36.99714], [-121.8662, 36.99674], [-121.86631, 36.99659], [-121.86672, 36.99621], [-121.86716, 36.99638]]]]} | Open Access 1 | 1674 | Valencia Hall Park | 26761 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 1.476 | Valencia Hall Park | 0 | Local Park 2 | 4 | |
430 | 430 | 429 | {"type": "Polygon", "coordinates": [[[-117.69087, 33.64713], [-117.69085, 33.64716], [-117.69051, 33.64729], [-117.68995, 33.64727], [-117.68923, 33.64768], [-117.68869, 33.64759], [-117.68877, 33.64738], [-117.68882, 33.64717], [-117.68975, 33.64643], [-117.69027, 33.64681], [-117.69087, 33.64713]]]} | Open Access 1 | 1728 | Heritage Hill Historic Site | 19835 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 3.228 | Heritage Hill Historic Site | 0 | Local Historic or Cultural Area 19 | 4 | |
431 | 431 | 430 | {"type": "Polygon", "coordinates": [[[-117.28428, 33.76243], [-117.28273, 33.76246], [-117.2827, 33.76182], [-117.28324, 33.76181], [-117.28324, 33.76162], [-117.28425, 33.76159], [-117.28428, 33.76243]]]} | Open Access 1 | 48878 | Goodhope Park | 33599 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 3.022 | Goodhope Park | 0 | Local Park 2 | 4 | |
433 | 433 | 432 | {"type": "Polygon", "coordinates": [[[-116.59781, 32.61496], [-116.59778, 32.61691], [-116.592, 32.61684], [-116.59195, 32.61847], [-116.58772, 32.61842], [-116.58772, 32.61307], [-116.59204, 32.61313], [-116.59203, 32.6113], [-116.59613, 32.61131], [-116.59619, 32.61494], [-116.59781, 32.61496]]]} | Open Access 1 | 836 | Potrero Park | 23926 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Potrero.html | San Diego 4 | 126.277 | Potrero Park | 0 | Local Park 2 | 4 |
436 | 436 | 435 | {"type": "MultiPolygon", "coordinates": [[[[-122.50735, 38.11473], [-122.50721, 38.11477], [-122.50708, 38.11492], [-122.50687, 38.11486], [-122.50673, 38.11475], [-122.50645, 38.11496], [-122.50608, 38.11467], [-122.50597, 38.11454], [-122.5062, 38.11444], [-122.50605, 38.11434], [-122.50643, 38.1142], [-122.50655, 38.11334], [-122.50673, 38.11403], [-122.50667, 38.11408], [-122.50674, 38.11407], [-122.50688, 38.11442], [-122.5068, 38.1145], [-122.50682, 38.11454], [-122.50703, 38.11464], [-122.50716, 38.11469], [-122.50735, 38.11473]]], [[[-122.50745, 38.11324], [-122.50722, 38.11345], [-122.50723, 38.11346], [-122.50737, 38.11346], [-122.50737, 38.11352], [-122.50703, 38.11382], [-122.50688, 38.11383], [-122.50682, 38.11385], [-122.50685, 38.11358], [-122.50677, 38.11331], [-122.50745, 38.11324]]]]} | Open Access 1 | 840 | Black Point Boat Launch | 16137 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 2.255 | Black Point Boat Launch | None 45 |
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]);