units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by AGNCY_NAME
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Butte, County of 53
- Rivers and Lands Conservancy 28
- Eureka, City of 25
- Mountains Recreation and Conservation Authority 21
- Whittier, City of 18
- Aliso Viejo, City of 17
- Beaumont, City of 15
- California Department of Fish and Wildlife 11
- Stanton, City of 11
- Suisun City, City of 11
- North Highland Recreation and Park District 11
- Ukiah, City of 10
- Miraleste Recreation and Park District 10
- East Bay Regional Park District 9
- San Gabriel, City of 9
- Tuolumne Park and Recreation District 9
- California Wildlife Conservation Board 9
- Orangevale Recreation and Park District 9
- Fair Oaks Recreation and Park District 9
- South Lake Tahoe, City of 9
- Manhattan Beach, City of 8
- Yountville, Town of 8
- La Selva Beach Recreation District 8
- Emeryville, City of 8
- Fulton - El Camino 8
- Ojai Valley Land Conservancy 8
- Valley-Wide Recreation and Park District 7
- Arcadia, City of 7
- Mountain House Community Services District 7
- San Diego River Park Foundation 7
- …
DES_TP >30
- Local Park 467
- Local Recreation Area 140
- Local Other or Unknown 115
- Private Recreation or Education 105
- Private Conservation 85
- Private Other or Unknown 30
- Local Historic or Cultural Area 28
- Local Conservation Area 26
- State Conservation Area 15
- State Other or Unknown 10
- National Monument or Landmark 5
- Local Resource Management Area 4
- Private Historic or Cultural 4
- Private Agricultural 3
- State Park 2
- State Recreation Area 2
- State Resource Management Area 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
- …
MNG_AG_TYP 29
- City Agency 395
- Recreation/Parks District 139
- Home Owners Association 96
- County Agency 87
- Non Profit - Land Trust 65
- Water District 52
- State Agency 43
- Community Services District 40
- Non Profit - Conservation 38
- Open Space District 31
- Cemetery District 26
- Non Profit - Other 25
- School District 18
- Irrigation District 15
- Special District - Other 14
- Commercial 7
- Flood District 6
- Non Profit - Cemetery District 5
- Conservation District 5
- Transportation Agency 5
- Port/Harbor District 4
- Joint Powers Authority 4
- Mitigation Bank 4
- County Agency - Other 3
- Sanitation District 3
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- Home Owners Associatin 1
- Fire District 1
ACCESS_TYP 4
- Open Access 760
- Restricted Access 263
- No Public Access 78
- Unknown Access 36
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3935 | 3935 | 3934 | {"type": "Polygon", "coordinates": [[[-121.55275, 37.77019], [-121.55274, 37.77025], [-121.55235, 37.77066], [-121.55227, 37.77066], [-121.55182, 37.77042], [-121.55178, 37.77039], [-121.55175, 37.77033], [-121.55176, 37.77027], [-121.55198, 37.76992], [-121.55207, 37.76988], [-121.55216, 37.76989], [-121.55236, 37.76998], [-121.55275, 37.77019]]]} | Open Access 1 | 36264 | Mountain House Community Services District 1 | 22541 | 2288 | Mountain House Community Services District 703 | Special District 4 | Community Services District 19 | http://www.mhcsd.com/ | Special District 4 | 2288 | Mountain House Community Services District 690 | Special District 4 | Community Services District 17 | San Joaquin 39 | 1.157 | Mtn. House Community Services District 1 | None 340 | |||
13697 | 13697 | 13696 | {"type": "Polygon", "coordinates": [[[-121.54269, 37.77951], [-121.54239, 37.77979], [-121.54129, 37.78063], [-121.54098, 37.7809], [-121.54067, 37.78125], [-121.54041, 37.78162], [-121.54029, 37.78184], [-121.54019, 37.78207], [-121.54009, 37.78238], [-121.53981, 37.78232], [-121.53955, 37.78222], [-121.5394, 37.78212], [-121.53922, 37.78194], [-121.5391, 37.78173], [-121.53907, 37.78158], [-121.53905, 37.78027], [-121.54016, 37.78026], [-121.54045, 37.78019], [-121.54065, 37.78012], [-121.54091, 37.77996], [-121.54105, 37.77983], [-121.54116, 37.77968], [-121.54127, 37.77944], [-121.5413, 37.77927], [-121.54131, 37.77913], [-121.54187, 37.77914], [-121.54212, 37.77917], [-121.54236, 37.77923], [-121.54259, 37.77931], [-121.54252, 37.77943], [-121.54269, 37.77951]]]} | Open Access 1 | 36071 | Central Community Park | 17047 | 2288 | Mountain House Community Services District 703 | Special District 4 | Community Services District 19 | http://www.mhcsd.com/ | Special District 4 | 2288 | Mountain House Community Services District 690 | Special District 4 | Community Services District 17 | San Joaquin 39 | 11.502 | Central Community Park | 0 | Local Park 2 | 4 | |
13698 | 13698 | 13697 | {"type": "Polygon", "coordinates": [[[-121.54891, 37.78322], [-121.54785, 37.78323], [-121.54781, 37.78321], [-121.54778, 37.78141], [-121.5478, 37.78137], [-121.54888, 37.78136], [-121.54891, 37.78322]]]} | Open Access 1 | 36073 | Altamont Park | 15425 | 2288 | Mountain House Community Services District 703 | Special District 4 | Community Services District 19 | http://www.mhcsd.com/ | Special District 4 | 2288 | Mountain House Community Services District 690 | Special District 4 | Community Services District 17 | San Joaquin 39 | 4.979 | Altamont Park | 0 | Local Park 2 | 4 | |
13699 | 13699 | 13698 | {"type": "Polygon", "coordinates": [[[-121.55203, 37.79064], [-121.55179, 37.79085], [-121.55153, 37.79103], [-121.55126, 37.79118], [-121.55104, 37.79126], [-121.551, 37.79124], [-121.55085, 37.79101], [-121.5507, 37.79083], [-121.55043, 37.79056], [-121.55, 37.79025], [-121.54963, 37.79004], [-121.54936, 37.78992], [-121.54934, 37.78988], [-121.54957, 37.78958], [-121.54988, 37.78928], [-121.55203, 37.79064]]]} | Open Access 1 | 36074 | Questa Park | 24063 | 2288 | Mountain House Community Services District 703 | Special District 4 | Community Services District 19 | http://www.mhcsd.com/ | Special District 4 | 2288 | Mountain House Community Services District 690 | Special District 4 | Community Services District 17 | San Joaquin 39 | 5.022 | Questa Park | 0 | Local Park 2 | 4 | |
13702 | 13702 | 13701 | {"type": "MultiPolygon", "coordinates": [[[[-121.54538, 37.7804], [-121.54522, 37.78077], [-121.54524, 37.78079], [-121.54511, 37.78096], [-121.54496, 37.78111], [-121.54445, 37.78147], [-121.5442, 37.78172], [-121.54399, 37.78174], [-121.54378, 37.78179], [-121.54358, 37.78186], [-121.54335, 37.782], [-121.54319, 37.78214], [-121.54268, 37.78271], [-121.54248, 37.78288], [-121.54232, 37.783], [-121.54207, 37.78313], [-121.54189, 37.78321], [-121.54162, 37.7833], [-121.54142, 37.78335], [-121.54117, 37.78339], [-121.54092, 37.78341], [-121.54045, 37.7834], [-121.54044, 37.78309], [-121.54045, 37.78287], [-121.54053, 37.78244], [-121.5406, 37.78223], [-121.54071, 37.78197], [-121.54095, 37.78158], [-121.54121, 37.78126], [-121.54147, 37.78101], [-121.54267, 37.78008], [-121.54287, 37.7799], [-121.54308, 37.77969], [-121.54322, 37.77977], [-121.54332, 37.77966], [-121.54384, 37.77993], [-121.54424, 37.7801], [-121.54466, 37.78023], [-121.54525, 37.78035], [-121.54525, 37.78038], [-121.54538, 37.7804]]], [[[-121.55082, 37.77568], [-121.5508, 37.77572], [-121.55042, 37.77588], [-121.54959, 37.7761], [-121.54925, 37.77623], [-121.54795, 37.77699], [-121.54712, 37.77733], [-121.54664, 37.7776], [-121.54659, 37.77765], [-121.54656, 37.77771], [-121.54653, 37.77772], [-121.54635, 37.77802], [-121.54566, 37.77907], [-121.54558, 37.77922], [-121.54553, 37.77934], [-121.54551, 37.77948], [-121.54545, 37.78007], [-121.54505, 37.78001], [-121.54465, 37.77991], [-121.54427, 37.77978], [-121.54387, 37.77959], [-121.54418, 37.77927], [-121.54454, 37.77906], [-121.54477, 37.77879], [-121.54512, 37.77825], [-121.54541, 37.77784], [-121.54584, 37.77709], [-121.54597, 37.77694], [-121.54606, 37.77685], [-121.54623, 37.77674], [-121.54624, 37.77671], [-121.54636, 37.7767], [-121.54646, 37.77666], [-121.54677, 37.77658], [-121.54739, 37.77635], [-121.5476, 37.77624], [-121.54827, 37.77579], [-121.54842, 37.77571], [-121.54848, 37.77564], [-121.54852, 37.77564], [-121.54913, 37.77537], [-121.54914, 37.77534], [-121.54924, 37.77533], [-121.5494, 37.77527], [-121.54989, 37.77516], [-121.55013, 37.77506], [-121.55016, 37.77506], [-121.55049, 37.77533], [-121.55071, 37.77555], [-121.55082, 37.77568]]], [[[-121.55684, 37.77112], [-121.55681, 37.77206], [-121.55634, 37.77206], [-121.55638, 37.77199], [-121.55637, 37.77193], [-121.55633, 37.77189], [-121.55628, 37.77186], [-121.55622, 37.77185], [-121.55615, 37.77185], [-121.55609, 37.77188], [-121.55606, 37.77191], [-121.55604, 37.77197], [-121.55608, 37.77211], [-121.55606, 37.77224], [-121.55606, 37.77268], [-121.55603, 37.77272], [-121.55599, 37.77273], [-121.55505, 37.77275], [-121.55425, 37.77283], [-121.55372, 37.77293], [-121.55325, 37.77304], [-121.55291, 37.77318], [-121.5527, 37.77332], [-121.55248, 37.77354], [-121.5518, 37.7748], [-121.5516, 37.77509], [-121.5514, 37.7753], [-121.55106, 37.77557], [-121.55102, 37.77557], [-121.55099, 37.77556], [-121.55072, 37.77528], [-121.55031, 37.77493], [-121.55057, 37.77464], [-121.5509, 37.77422], [-121.55103, 37.774], [-121.55135, 37.7734], [-121.55155, 37.77314], [-121.55179, 37.77294], [-121.55312, 37.77197], [-121.55328, 37.77189], [-121.55344, 37.77184], [-121.55364, 37.77182], [-121.55416, 37.77181], [-121.5544, 37.77177], [-121.55461, 37.77171], [-121.55481, 37.77163], [-121.55499, 37.77154], [-121.55535, 37.77128], [-121.55551, 37.77118], [-121.55584, 37.77102], [-121.55598, 37.77098], [-121.55621, 37.77094], [-121.55681, 37.77096], [-121.55681, 37.77111], [-121.55684, 37.77112]]]]} | Open Access 1 | 36077 | Creek Park | 17765 | 2288 | Mountain House Community Services District 703 | Special District 4 | Community Services District 19 | http://www.mhcsd.com/ | Special District 4 | 2288 | Mountain House Community Services District 690 | Special District 4 | Community Services District 17 | San Joaquin 39 | 59.432 | Creek Park | 0 | Local Park 2 | 4 | |
14158 | 14158 | 14157 | {"type": "Polygon", "coordinates": [[[-121.53855, 37.77282], [-121.53771, 37.77281], [-121.53764, 37.77277], [-121.53753, 37.77256], [-121.53745, 37.77235], [-121.5374, 37.77211], [-121.53738, 37.77185], [-121.53738, 37.77167], [-121.53743, 37.77143], [-121.5375, 37.77122], [-121.53764, 37.77095], [-121.53769, 37.77091], [-121.53774, 37.7709], [-121.53855, 37.77089], [-121.53855, 37.77282]]]} | Open Access 1 | 43053 | Wickland Park | 27485 | 2288 | Mountain House Community Services District 703 | Special District 4 | Community Services District 19 | http://www.mhcsd.com/ | Special District 4 | 2288 | Mountain House Community Services District 690 | Special District 4 | Community Services District 17 | San Joaquin 39 | 4.978 | Wickland Park | 0 | Local Park 2 | 4 | |
14160 | 14160 | 14159 | {"type": "Polygon", "coordinates": [[[-121.55037, 37.77462], [-121.55012, 37.77487], [-121.54992, 37.77499], [-121.54977, 37.77504], [-121.54919, 37.77515], [-121.54891, 37.77485], [-121.54863, 37.77459], [-121.54832, 37.77436], [-121.54794, 37.77413], [-121.54792, 37.7741], [-121.54832, 37.77332], [-121.55037, 37.77462]]]} | Open Access 1 | 43054 | Bethany Park | 16046 | 2288 | Mountain House Community Services District 703 | Special District 4 | Community Services District 19 | http://www.mhcsd.com/ | Special District 4 | 2288 | Mountain House Community Services District 690 | Special District 4 | Community Services District 17 | San Joaquin 39 | 4.975 | Bethany Park | 0 | Local Park 2 | 4 | |
3938 | 3938 | 3937 | {"type": "Polygon", "coordinates": [[[-121.71403, 39.41319], [-121.71349, 39.41331], [-121.71325, 39.41265], [-121.71379, 39.41253], [-121.71403, 39.41319]]]} | Open Access 1 | 36308 | Biggs Family Park | 16098 | 1031 | Biggs, City of 704 | City 2 | City Agency 2 | http://www.biggs-ca.gov/public-works/parks.htm | City 2 | 1031 | Biggs, City of 691 | City 2 | City Agency 2 | Butte 42 | 0.918 | Biggs Family Park | 0 | Local Park 2 | 4 | |
3939 | 3939 | 3938 | {"type": "Polygon", "coordinates": [[[-121.62744, 39.74865], [-121.62744, 39.74881], [-121.62673, 39.74875], [-121.62673, 39.74859], [-121.62744, 39.74865]]]} | Open Access 1 | 36311 | Butte holding 14 | 16557 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.271 | Butte holding 14 | 0 | Local Other or Unknown 14 | 4 | |
3999 | 3999 | 3998 | {"type": "Polygon", "coordinates": [[[-121.80809, 39.64191], [-121.80809, 39.64239], [-121.80736, 39.6424], [-121.80735, 39.64235], [-121.80731, 39.6423], [-121.80725, 39.64227], [-121.80719, 39.64226], [-121.80719, 39.64192], [-121.80809, 39.64191]]]} | Open Access 1 | 43009 | Butte holding 28 | 16572 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.985 | Butte holding 28 | 0 | Local Other or Unknown 14 | 4 | |
4000 | 4000 | 3999 | {"type": "Polygon", "coordinates": [[[-121.7975, 39.63935], [-121.79716, 39.63942], [-121.797, 39.63897], [-121.79721, 39.63893], [-121.79729, 39.63902], [-121.7975, 39.63935]]]} | Open Access 1 | 43010 | Butte holding 29 | 16573 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.324 | Butte holding 29 | 0 | Local Other or Unknown 14 | 4 | |
4001 | 4001 | 4000 | {"type": "Polygon", "coordinates": [[[-121.50716, 39.77435], [-121.50641, 39.77428], [-121.50606, 39.77367], [-121.50686, 39.77374], [-121.50716, 39.77435]]]} | Open Access 1 | 43011 | Butte holding 24 | 16568 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 1.051 | Butte holding 24 | 0 | Local Other or Unknown 14 | 4 | |
4002 | 4002 | 4001 | {"type": "Polygon", "coordinates": [[[-121.27835, 39.52723], [-121.27753, 39.52727], [-121.27742, 39.52663], [-121.27778, 39.52662], [-121.27814, 39.52652], [-121.27835, 39.52723]]]} | Open Access 1 | 43012 | Butte holding 25 | 16569 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 1.222 | Butte holding 25 | 0 | Local Other or Unknown 14 | 4 | |
4003 | 4003 | 4002 | {"type": "Polygon", "coordinates": [[[-121.74737, 39.49534], [-121.74694, 39.49534], [-121.74694, 39.49496], [-121.74736, 39.49496], [-121.74737, 39.49534]]]} | Open Access 1 | 43013 | Butte holding 23 | 16567 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.385 | Butte holding 23 | 0 | Local Other or Unknown 14 | 4 | |
5122 | 5122 | 5121 | {"type": "Polygon", "coordinates": [[[-121.80588, 39.70418], [-121.80579, 39.70421], [-121.80148, 39.69811], [-121.80159, 39.69805], [-121.80588, 39.70418]]]} | Open Access 1 | 35946 | Butte holding 48 | 16592 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 1.819 | Butte holding 48 | 0 | Local Other or Unknown 14 | 4 | |
5123 | 5123 | 5122 | {"type": "Polygon", "coordinates": [[[-121.1614, 39.53296], [-121.16104, 39.53302], [-121.16102, 39.53249], [-121.16138, 39.53242], [-121.1614, 39.53296]]]} | Open Access 1 | 35947 | Butte holding 53 | 16598 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.464 | Butte holding 53 | 0 | Local Other or Unknown 14 | 4 | |
12435 | 12435 | 12434 | {"type": "Polygon", "coordinates": [[[-121.86522, 39.77272], [-121.86522, 39.77272], [-121.86339, 39.77381], [-121.86334, 39.77367], [-121.86511, 39.77261], [-121.86522, 39.77272]]]} | Open Access 1 | 36273 | Butte holding 3 | 16574 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.736 | Butte holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13198 | 13198 | 13197 | {"type": "Polygon", "coordinates": [[[-121.48678, 39.51389], [-121.48532, 39.5139], [-121.48532, 39.51387], [-121.48603, 39.51387], [-121.48603, 39.51308], [-121.48676, 39.51308], [-121.48678, 39.51389]]]} | Open Access 1 | 36274 | Butte holding 1 | 16552 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 1.474 | Butte holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13388 | 13388 | 13387 | {"type": "Polygon", "coordinates": [[[-121.53269, 39.46596], [-121.53184, 39.46602], [-121.5318, 39.46567], [-121.53264, 39.4656], [-121.53269, 39.46596]]]} | Open Access 1 | 36275 | Butte holding 2 | 16563 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.717 | Butte holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13578 | 13578 | 13577 | {"type": "Polygon", "coordinates": [[[-121.16103, 39.53302], [-121.16075, 39.53306], [-121.16074, 39.53253], [-121.16102, 39.53249], [-121.16103, 39.53302]]]} | Open Access 1 | 35944 | Butte holding 46 | 16590 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.356 | Butte holding 46 | 0 | Local Other or Unknown 14 | 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]);