units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
651 rows where DES_TP = 2 and MNG_AG_TYP = 3 sorted by AGNCY_ID descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, LAYER
MNG_AGENCY >30
- Los Angeles, County of 95
- San Diego, County of 68
- Orange, County of 43
- El Dorado, County of 42
- Santa Barbara, County of 40
- Kern, County of 37
- Santa Cruz, County of 33
- Stanislaus, County of 22
- San Luis Obispo, County of 20
- Riverside, County of 19
- Placer, County of 19
- Lake, County of 18
- San Joaquin, County of 18
- Monterey, County of 17
- Ventura, County of 15
- San Bernardino, County of 14
- Merced, County of 12
- Yolo, County of 12
- Tulare, County of 11
- Fresno, County of 11
- Humboldt, County of 10
- Sacramento, County of 7
- Tehama, County of 6
- Mendocino, County of 6
- Lassen, County of 6
- Mariposa, County of 5
- Mono, County of 5
- Imperial, County of 4
- Yuba, County of 4
- San Benito, County of 3
- …
ACCESS_TYP 4
MNG_AG_TYP 1
- County Agency · 651 ✖
DES_TP 1
- Local Park · 651 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16431 | 16431 | 16430 | {"type": "Polygon", "coordinates": [[[-117.83973, 34.08948], [-117.83939, 34.08989], [-117.83876, 34.08965], [-117.83843, 34.08942], [-117.83824, 34.08936], [-117.83808, 34.08936], [-117.83791, 34.08941], [-117.83777, 34.08951], [-117.8376, 34.08971], [-117.83744, 34.08977], [-117.83718, 34.0898], [-117.83699, 34.08985], [-117.83687, 34.08962], [-117.83699, 34.08957], [-117.83757, 34.08887], [-117.83804, 34.08872], [-117.83842, 34.08887], [-117.83904, 34.08915], [-117.83954, 34.08911], [-117.83973, 34.08948]]]} | Open Access 1 | 46301 | Walnut Creek Community Regional Park | 29589 | 3365 | Buddhist Compassion Relief Tzu Chi Foundation 1144 | Non Profit 6 | Non Profit - Other 22 | http://www.tzuchi.us/ | Non Governmental Organization 10 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Walnut_Creek_Community_Regional_Park | Los Angeles 6 | 4.239 | Walnut Creek Community RP | 0 | Local Park 2 | 4 |
7640 | 7640 | 7639 | {"type": "Polygon", "coordinates": [[[-119.49018, 34.38353], [-119.48938, 34.38524], [-119.48884, 34.38506], [-119.48848, 34.3849], [-119.48734, 34.38447], [-119.48698, 34.3843], [-119.48681, 34.38419], [-119.4865, 34.38393], [-119.48637, 34.38378], [-119.48607, 34.38336], [-119.48592, 34.38322], [-119.48576, 34.38309], [-119.48558, 34.38297], [-119.48538, 34.38288], [-119.48517, 34.38281], [-119.4849, 34.38276], [-119.48494, 34.3819], [-119.48505, 34.38194], [-119.48533, 34.38197], [-119.48547, 34.38191], [-119.48584, 34.38197], [-119.48585, 34.38181], [-119.48869, 34.38297], [-119.48873, 34.38294], [-119.49018, 34.38353]]]} | Open Access 1 | 48965 | Rincon Beach Park | 24367 | 3033 | Land Trust for Santa Barbara County 269 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sblandtrust.org | Non Governmental Organization 10 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 21.667 | Rincon Beach Park | 0 | Local Park 2 | 4 | |
16364 | 16364 | 16363 | {"type": "Polygon", "coordinates": [[[-117.78127, 33.86017], [-117.78126, 33.86048], [-117.78076, 33.86071], [-117.76229, 33.86967], [-117.76089, 33.87029], [-117.75995, 33.87067], [-117.7585, 33.8712], [-117.75664, 33.8718], [-117.75577, 33.87211], [-117.75492, 33.87244], [-117.75365, 33.87297], [-117.75361, 33.87262], [-117.75407, 33.87242], [-117.75549, 33.87185], [-117.75646, 33.87151], [-117.75743, 33.87119], [-117.75748, 33.87124], [-117.75843, 33.87093], [-117.75937, 33.87059], [-117.76077, 33.87004], [-117.76213, 33.86943], [-117.78035, 33.86059], [-117.78127, 33.86017]]]} | Open Access 1 | 47964 | Yorba Regional Park | 27778 | 2420 | Orange County Flood Control District 1171 | Special District 4 | Flood District 8 | http://www.ocflood.com/ | Special District 4 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://www.ocparks.com/parks/yorba | Orange 3 | 22.503 | Yorba RP | 0 | Local Park 2 | 4 |
14857 | 14857 | 14856 | {"type": "Polygon", "coordinates": [[[-121.08625, 38.64756], [-121.0853, 38.64768], [-121.08399, 38.64807], [-121.08396, 38.64803], [-121.08267, 38.64846], [-121.08267, 38.64852], [-121.08075, 38.64917], [-121.0807, 38.64913], [-121.07927, 38.64961], [-121.07927, 38.64966], [-121.07753, 38.65024], [-121.07718, 38.64974], [-121.07719, 38.64951], [-121.07722, 38.64951], [-121.07724, 38.64958], [-121.07732, 38.64965], [-121.0774, 38.64968], [-121.07752, 38.64967], [-121.07762, 38.64961], [-121.0777, 38.64945], [-121.07781, 38.64938], [-121.08033, 38.64854], [-121.08032, 38.64849], [-121.08225, 38.64784], [-121.08243, 38.64773], [-121.08592, 38.64685], [-121.08625, 38.64756]]]} | Open Access 1 | 45368 | Joerger Park | 20425 | 2347 | Rolling Hills Community Services District 1124 | Special District 4 | Community Services District 19 | http://www.rollinghillscsd.org/ | Special District 4 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 15.735 | Joerger Park | 0 | Local Park 2 | 4 | |
16404 | 16404 | 16403 | {"type": "Polygon", "coordinates": [[[-121.08592, 38.64685], [-121.08243, 38.64773], [-121.08195, 38.64613], [-121.08236, 38.64522], [-121.08242, 38.64513], [-121.08246, 38.64503], [-121.08248, 38.64492], [-121.08245, 38.64481], [-121.08238, 38.6447], [-121.0823, 38.64462], [-121.08219, 38.64456], [-121.08205, 38.64451], [-121.08166, 38.64447], [-121.08155, 38.64443], [-121.08147, 38.64435], [-121.08142, 38.64425], [-121.08143, 38.64415], [-121.08235, 38.64406], [-121.08221, 38.64382], [-121.0821, 38.64355], [-121.08204, 38.64328], [-121.08202, 38.64301], [-121.08159, 38.64275], [-121.0814, 38.64261], [-121.08119, 38.64242], [-121.08126, 38.6422], [-121.08129, 38.64215], [-121.08134, 38.64212], [-121.08142, 38.64213], [-121.08149, 38.64202], [-121.08144, 38.64198], [-121.08143, 38.64194], [-121.08155, 38.64165], [-121.08159, 38.64139], [-121.08157, 38.64112], [-121.08149, 38.64089], [-121.08134, 38.64065], [-121.08124, 38.64053], [-121.0811, 38.6404], [-121.08147, 38.64005], [-121.08104, 38.63977], [-121.08139, 38.63878], [-121.08121, 38.63834], [-121.08157, 38.63847], [-121.08194, 38.63828], [-121.08592, 38.64685]]]} | Open Access 1 | 35632 | Regional Park | 3446 | 2347 | Rolling Hills Community Services District 1124 | Special District 4 | Community Services District 19 | http://www.rollinghillscsd.org/ | Special District 4 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 49.449 | RP | 0 | Local Park 2 | 4 | |
13454 | 13454 | 13453 | {"type": "Polygon", "coordinates": [[[-116.39879, 33.82366], [-116.39697, 33.82366], [-116.39696, 33.82193], [-116.39701, 33.82189], [-116.39701, 33.82177], [-116.39697, 33.82173], [-116.39696, 33.8216], [-116.39701, 33.82156], [-116.39701, 33.82145], [-116.39697, 33.82139], [-116.39697, 33.82105], [-116.39702, 33.821], [-116.39702, 33.82089], [-116.39697, 33.82084], [-116.39697, 33.8205], [-116.39702, 33.82045], [-116.39701, 33.82032], [-116.39697, 33.82028], [-116.39698, 33.82013], [-116.39701, 33.8201], [-116.39879, 33.8201], [-116.39879, 33.82366]]]} | Restricted Access 2 | 35667 | Thousand Palms Community Park | 31650 | 2318 | Palm Springs Unified School District 1058 | Special District 4 | School District 14 | http://www.psusd.us/ | Special District 4 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 16.4 | Thousand Palms Community Park | 0 | Local Park 2 | 4 | |
14245 | 14245 | 14244 | {"type": "Polygon", "coordinates": [[[-118.03024, 34.15973], [-118.02975, 34.15977], [-118.0297, 34.1602], [-118.02916, 34.16008], [-118.02882, 34.16003], [-118.02852, 34.16], [-118.02806, 34.16001], [-118.02952, 34.15919], [-118.03012, 34.15918], [-118.03024, 34.15973]]]} | Restricted Access 2 | 44142 | Highland Oaks Park | 19930 | 2315 | Arcadia Unified School District 762 | Special District 4 | School District 14 | http://site.ausd.net/ | Special District 4 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 2.851 | Highland Oaks Park | 0 | Local Park 2 | 4 | |
3724 | 3724 | 3723 | {"type": "Polygon", "coordinates": [[[-118.20363, 36.80669], [-118.20289, 36.807], [-118.20237, 36.80627], [-118.20224, 36.80618], [-118.20303, 36.80585], [-118.20363, 36.80669]]]} | Open Access 1 | 44705 | Dehy Park | 18020 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 360 | Inyo, County of 662 | County 3 | County Agency 3 | Inyo 43 | 1.985 | Dehy Park | 0 | Local Park 2 | 4 | |
11924 | 11924 | 11923 | {"type": "Polygon", "coordinates": [[[-118.50387, 34.02695], [-118.50386, 34.02706], [-118.5038, 34.02717], [-118.50371, 34.02726], [-118.5036, 34.02732], [-118.50347, 34.02736], [-118.50337, 34.02737], [-118.50327, 34.02733], [-118.50321, 34.02727], [-118.50319, 34.02722], [-118.5032, 34.02716], [-118.50325, 34.02704], [-118.50335, 34.02693], [-118.50346, 34.02686], [-118.50361, 34.02682], [-118.50373, 34.02681], [-118.50382, 34.02686], [-118.50387, 34.02695]]]} | Open Access 1 | 24529 | Goose Egg Park | 19406 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 0.674 | Goose Egg Park | 0 | Local Park 2 | 4 | |
4433 | 4433 | 4432 | {"type": "MultiPolygon", "coordinates": [[[[-118.2896, 34.44511], [-118.28959, 34.44876], [-118.2854, 34.44869], [-118.28535, 34.44505], [-118.2896, 34.44511]]], [[[-118.29626, 34.44876], [-118.29406, 34.44876], [-118.29404, 34.44571], [-118.29402, 34.44509], [-118.29623, 34.44508], [-118.29626, 34.44876]]], [[[-118.32311, 34.4672], [-118.32304, 34.46725], [-118.32117, 34.46822], [-118.32115, 34.46719], [-118.32311, 34.4672]]]]} | Open Access 1 | 46400 | Agua Dulce Canyon Parkland | 29553 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 61.59 | Agua Dulce Canyon Parkland | 0 | Local Park 2 | 4 | |
5626 | 5626 | 5625 | {"type": "Polygon", "coordinates": [[[-118.41054, 34.22709], [-118.4103, 34.22778], [-118.40776, 34.22897], [-118.40741, 34.22916], [-118.40705, 34.2294], [-118.407, 34.22941], [-118.40696, 34.22939], [-118.404, 34.22662], [-118.40712, 34.22434], [-118.40755, 34.22467], [-118.40844, 34.22521], [-118.40886, 34.2255], [-118.41022, 34.22678], [-118.41054, 34.22709]]]} | Open Access 1 | 45413 | Sheldon-Arleta Park | 28186 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://www.laparks.org/dos/parks/facility/devonshireArletaPk.htm | Los Angeles 6 | 45.127 | Sheldon-Arleta Park | 2016 | Local Park 2 | 4 |
11927 | 11927 | 11926 | {"type": "Polygon", "coordinates": [[[-118.3351, 33.89621], [-118.33509, 33.89639], [-118.33509, 33.89752], [-118.33391, 33.89739], [-118.33393, 33.89724], [-118.33319, 33.89717], [-118.33315, 33.89718], [-118.33305, 33.89734], [-118.33158, 33.89734], [-118.33197, 33.89699], [-118.33221, 33.89672], [-118.33335, 33.89514], [-118.33409, 33.89545], [-118.33411, 33.89592], [-118.33482, 33.89592], [-118.33483, 33.8962], [-118.3351, 33.89621]]]} | Open Access 1 | 24532 | Bodger Park | 16222 | 1130 | Hawthorne, City of 299 | City 2 | City Agency 2 | http://www.cityofhawthorne.com/ | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 11.866 | Bodger Park | 0 | Local Park 2 | 4 | |
9945 | 9945 | 9944 | {"type": "Polygon", "coordinates": [[[-117.75367, 33.87309], [-117.7534, 33.8731], [-117.75323, 33.87313], [-117.75305, 33.87321], [-117.75276, 33.87329], [-117.75249, 33.8734], [-117.7522, 33.87353], [-117.75193, 33.87367], [-117.75157, 33.87392], [-117.75115, 33.87428], [-117.75095, 33.87452], [-117.7508, 33.87474], [-117.7507, 33.87478], [-117.74982, 33.87457], [-117.75063, 33.8741], [-117.75188, 33.87343], [-117.75274, 33.87301], [-117.75361, 33.87262], [-117.75367, 33.87309]]]} | Open Access 1 | 47963 | Yorba Regional Park | 27778 | 1006 | Anaheim, City of 59 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://www.ocparks.com/parks/yorba | Orange 3 | 3.53 | Yorba RP | 0 | Local Park 2 | 4 |
4385 | 4385 | 4384 | {"type": "Polygon", "coordinates": [[[-120.7612, 38.50487], [-120.76067, 38.50489], [-120.75991, 38.50481], [-120.75994, 38.50463], [-120.76073, 38.5047], [-120.76118, 38.50468], [-120.7612, 38.50487]]]} | Open Access 1 | 45570 | Fiddletown Park | 28396 | 372 | Amador, County of 755 | County 3 | County Agency 3 | http://www.co.amador.ca.us/ | County 3 | 372 | Amador, County of 741 | County 3 | County Agency 3 | http://www.touramador.com/parks | Amador 52 | 0.575 | Fiddletown Park | 0 | Local Park 2 | 4 |
14295 | 14295 | 14294 | {"type": "Polygon", "coordinates": [[[-121.61997, 37.90654], [-121.61837, 37.90657], [-121.61747, 37.90656], [-121.61748, 37.90592], [-121.61867, 37.90531], [-121.61898, 37.90506], [-121.61898, 37.90495], [-121.61947, 37.90532], [-121.61964, 37.90549], [-121.61976, 37.90565], [-121.61987, 37.90588], [-121.61992, 37.90603], [-121.61995, 37.90619], [-121.61997, 37.90654]]]} | Open Access 1 | 44229 | Slifer Park | 25558 | 369 | Contra Costa, County of 1106 | County 3 | County Agency 3 | http://www.co.contra-costa.ca.us/446/Parks-and-Recreation | County 3 | 369 | Contra Costa, County of 1060 | County 3 | County Agency 3 | Contra Costa 12 | 6.525 | Slifer Park | 0 | Local Park 2 | 4 | |
14953 | 14953 | 14952 | {"type": "Polygon", "coordinates": [[[-122.03078, 38.03015], [-122.03061, 38.03021], [-122.03036, 38.02969], [-122.03052, 38.02965], [-122.03078, 38.03015]]]} | Open Access 1 | 45559 | Big Oak Tree Park | 28387 | 369 | Contra Costa, County of 1106 | County 3 | County Agency 3 | http://www.co.contra-costa.ca.us/446/Parks-and-Recreation | County 3 | 369 | Contra Costa, County of 1060 | County 3 | County Agency 3 | http://www.contracosta.ca.gov/4398/Clyde | Contra Costa 12 | 0.241 | Big Oak Tree Park | 0 | Local Park 2 | 4 |
14961 | 14961 | 14960 | {"type": "Polygon", "coordinates": [[[-122.07002, 37.98678], [-122.06947, 37.98652], [-122.06924, 37.98637], [-122.06881, 37.98575], [-122.06874, 37.98561], [-122.06869, 37.98543], [-122.0683, 37.98352], [-122.06884, 37.98351], [-122.06919, 37.98462], [-122.06922, 37.98477], [-122.0692, 37.98517], [-122.06931, 37.98555], [-122.06955, 37.986], [-122.07001, 37.98661], [-122.07002, 37.98678]]]} | Open Access 1 | 45572 | Hayden Park | 28398 | 369 | Contra Costa, County of 1106 | County 3 | County Agency 3 | http://www.co.contra-costa.ca.us/446/Parks-and-Recreation | County 3 | 369 | Contra Costa, County of 1060 | County 3 | County Agency 3 | Contra Costa 12 | 4.478 | Hayden Park | 0 | Local Park 2 | 4 | |
3765 | 3765 | 3764 | {"type": "Polygon", "coordinates": [[[-120.42391, 37.95344], [-120.42385, 37.95358], [-120.42349, 37.95357], [-120.42294, 37.95347], [-120.42298, 37.95335], [-120.42353, 37.95346], [-120.42357, 37.95338], [-120.42391, 37.95344]]]} | Open Access 1 | 44974 | Jamestown Park | 20357 | 368 | Tuolumne, County of 680 | County 3 | County Agency 3 | http://www.tuolumnecounty.ca.gov/index.aspx?NID=448 | County 3 | 368 | Tuolumne, County of 670 | County 3 | County Agency 3 | Tuolumne 21 | 0.305 | Jamestown Park | 0 | Local Park 2 | 4 | |
14837 | 14837 | 14836 | {"type": "Polygon", "coordinates": [[[-120.40956, 38.04466], [-120.40948, 38.04466], [-120.409, 38.04374], [-120.40883, 38.04347], [-120.40869, 38.043], [-120.4079, 38.04234], [-120.40747, 38.04201], [-120.40725, 38.04153], [-120.40791, 38.04125], [-120.40799, 38.04128], [-120.40805, 38.04022], [-120.40801, 38.03973], [-120.4086, 38.03972], [-120.4092, 38.0398], [-120.40955, 38.04], [-120.40956, 38.04228], [-120.40952, 38.04272], [-120.40957, 38.0433], [-120.40956, 38.04466]]]} | Open Access 1 | 45360 | Columbia Pioneer Park | 17549 | 368 | Tuolumne, County of 680 | County 3 | County Agency 3 | http://www.tuolumnecounty.ca.gov/index.aspx?NID=448 | County 3 | 368 | Tuolumne, County of 670 | County 3 | County Agency 3 | Tuolumne 21 | 14.809 | Columbia Pioneer Park | 0 | Local Park 2 | 4 | |
3101 | 3101 | 3100 | {"type": "Polygon", "coordinates": [[[-122.54604, 39.88145], [-122.5458, 39.88281], [-122.54366, 39.88282], [-122.54397, 39.88098], [-122.54604, 39.88145]]]} | Open Access 1 | 48690 | Simpson-Finnell Park | 33429 | 367 | Tehama, County of 582 | County 3 | County Agency 3 | http://www.co.tehama.ca.us/dep-parks | County 3 | 367 | Tehama, County of 574 | County 3 | County Agency 3 | https://www.co.tehama.ca.us/simpson-finnell-park | Tehama 18 | 8.049 | Simpson-Finnell Park | 0 | 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]);