units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 8,429
- State Agency 1,050
- Recreation/Parks District 1,035
- County Agency 1,013
- Non Profit - Land Trust 540
- Federal Agency 444
- Open Space District 393
- Water District 221
- County Agency - Parks 213
- Community Services District 190
- Home Owners Association 187
- Non Profit - Conservation 139
- Flood District 98
- Non Profit - Other 43
- Irrigation District 39
- School District 37
- Cemetery District 33
- County Agency - Other 28
- Port/Harbor District 28
- Special District - Other 15
- Commercial 14
- Sanitation District 7
- Joint Powers Authority 7
- Other 6
- Non Profit - Cemetery District 5
- Conservation District 5
- Transportation Agency 5
- Mitigation Bank 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- San Diego, City of 443
- California Department of Fish and Wildlife 405
- Los Angeles, City of 385
- California Department of Parks and Recreation 353
- Mountains Recreation and Conservation Authority 319
- Sacramento, City of 208
- San Jose, City of 192
- San Francisco, City and County of 164
- East Bay Regional Park District 162
- Los Angeles, County of 139
- Ventura, City of 132
- Roseville, City of 127
- Long Beach, City of 123
- Oakland, City of 102
- San Diego, County of 102
- United States Bureau of Land Management 98
- United States Forest Service 98
- Santa Barbara, County of 96
- Consumnes Community Services District 94
- California State Lands Commission 81
- Napa, City of 80
- Orange, County of 79
- United States Fish and Wildlife Service 77
- United States National Park Service 73
- Irvine, City of 73
- Hayward Area Recreation and Park District 68
- Tracy, City of 65
- Modesto, City of 65
- Valley-Wide Recreation and Park District 64
- Davis, City of 64
- …
DES_TP >30
- Local Park 7,334
- Local Recreation Area 1,776
- Local Other or Unknown 1,155
- Private Conservation 566
- Local Conservation Area 428
- State Conservation Area 354
- Private Recreation or Education 246
- State Park 192
- State Resource Management Area 147
- State Recreation Area 132
- National Forest 85
- Local Historic or Cultural Area 73
- National Wildlife Refuge 70
- State Other or Unknown 67
- State Historic or Cultural Area 61
- National Public Lands 55
- Recreation Management Area 52
- Private Other or Unknown 51
- National Monument or Landmark 37
- National Recreation Area 34
- National Park 22
- Resource Management Area 22
- Local Resource Management Area 21
- Federal Other or Unknown 21
- Conservation Area 12
- Private Agricultural 12
- Area of Critical Environmental Concern 7
- Wilderness Area 5
- Historic or Cultural Area 5
- Private Historic or Cultural 4
- …
ACCESS_TYP 4
- Open Access 11,896
- Restricted Access 1,094
- No Public Access 878
- Unknown Access 368
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2833 | 2833 | 2832 | {"type": "Polygon", "coordinates": [[[-122.49452, 38.30454], [-122.49377, 38.3048], [-122.49335, 38.30407], [-122.49301, 38.3042], [-122.49262, 38.30344], [-122.49253, 38.30334], [-122.49242, 38.30326], [-122.49212, 38.30312], [-122.49197, 38.3031], [-122.49146, 38.30305], [-122.49093, 38.30295], [-122.49061, 38.30299], [-122.49053, 38.30297], [-122.4902, 38.30247], [-122.49055, 38.30267], [-122.49065, 38.30255], [-122.49072, 38.30255], [-122.49081, 38.3025], [-122.4909, 38.30271], [-122.49136, 38.30275], [-122.49157, 38.3027], [-122.49165, 38.30276], [-122.49171, 38.30277], [-122.49178, 38.30275], [-122.49209, 38.30285], [-122.49216, 38.30262], [-122.49206, 38.30244], [-122.49196, 38.30232], [-122.4919, 38.30221], [-122.49236, 38.30204], [-122.49326, 38.30174], [-122.49452, 38.30454]]]} | Open Access 1 | 22048 | Ernie Smith Community Park | 18699 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 10.405 | Ernie Smith Community Park | 0 | Local Park 2 | 4 | |
2834 | 2834 | 2833 | {"type": "Polygon", "coordinates": [[[-122.83007, 38.55231], [-122.83006, 38.55266], [-122.82913, 38.55265], [-122.8291, 38.55237], [-122.82898, 38.55231], [-122.82906, 38.55227], [-122.82899, 38.55218], [-122.82891, 38.55212], [-122.82894, 38.55204], [-122.82893, 38.55172], [-122.82995, 38.55172], [-122.82993, 38.55229], [-122.83007, 38.55231]]]} | Open Access 1 | 22050 | Sutton Park | 26089 | 1382 | Windsor, Town of 331 | City 2 | City Agency 2 | http://www.ci.windsor.ca.us/index.aspx?nid=171 | City 2 | 1382 | Windsor, Town of 328 | City 2 | City Agency 2 | Sonoma 16 | 2.175 | Sutton Park | 0 | Local Park 2 | 4 | |
2835 | 2835 | 2834 | {"type": "Polygon", "coordinates": [[[-122.6038, 38.12679], [-122.6033, 38.12757], [-122.60324, 38.12769], [-122.6032, 38.12782], [-122.60318, 38.12803], [-122.60321, 38.12819], [-122.60328, 38.12836], [-122.60342, 38.12858], [-122.60268, 38.12874], [-122.60278, 38.12763], [-122.60304, 38.12714], [-122.60324, 38.12665], [-122.6038, 38.12679]]]} | Open Access 1 | 22051 | Novato Lands 012 | 22922 | 1226 | Novato, City of 444 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | Marin 23 | 2.492 | Novato Lands 012 | None 236 | |||
2836 | 2836 | 2835 | {"type": "Polygon", "coordinates": [[[-117.21384, 32.72823], [-117.21312, 32.72832], [-117.20895, 32.72874], [-117.20604, 32.72901], [-117.20516, 32.72907], [-117.20513, 32.7292], [-117.20489, 32.72922], [-117.20399, 32.72923], [-117.19926, 32.72923], [-117.19849, 32.72878], [-117.1987, 32.72875], [-117.199, 32.72867], [-117.19923, 32.72864], [-117.19928, 32.72856], [-117.19939, 32.72853], [-117.19967, 32.72863], [-117.19994, 32.72869], [-117.20437, 32.72869], [-117.20737, 32.72857], [-117.20898, 32.72845], [-117.21342, 32.72796], [-117.21356, 32.72797], [-117.21373, 32.72805], [-117.21384, 32.72817], [-117.21384, 32.72823]]]} | Open Access 1 | 4 | Spanish Landing Park | 25712 | 2133 | San Diego Unified Port District 186 | Special District 4 | Port/Harbor District 15 | http://www.portofsandiego.org/ | Special District 4 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | https://www.portofsandiego.org/spanish-landing-park.html | San Diego 4 | 16.066 | Spanish Landing Park | 0 | Local Park 2 | 4 |
2837 | 2837 | 2836 | {"type": "Polygon", "coordinates": [[[-117.2474, 32.75459], [-117.24739, 32.75484], [-117.24661, 32.75496], [-117.24628, 32.75506], [-117.23979, 32.75584], [-117.2352, 32.75631], [-117.23602, 32.75535], [-117.23671, 32.75479], [-117.23711, 32.75456], [-117.24002, 32.75307], [-117.24079, 32.75264], [-117.24111, 32.75238], [-117.24153, 32.752], [-117.24208, 32.75143], [-117.24236, 32.75155], [-117.24326, 32.75207], [-117.24425, 32.75223], [-117.2449, 32.75257], [-117.24493, 32.7527], [-117.24492, 32.75295], [-117.24495, 32.75313], [-117.24529, 32.75309], [-117.24534, 32.75326], [-117.24542, 32.7534], [-117.2455, 32.75351], [-117.24543, 32.75352], [-117.24526, 32.75374], [-117.24531, 32.75376], [-117.24579, 32.75419], [-117.24596, 32.75431], [-117.24592, 32.75436], [-117.24592, 32.75438], [-117.24619, 32.75434], [-117.2462, 32.75437], [-117.24625, 32.75436], [-117.24628, 32.75454], [-117.24654, 32.75461], [-117.24668, 32.75462], [-117.2469, 32.75459], [-117.24721, 32.75461], [-117.2474, 32.75459]]]} | Open Access 1 | 46755 | Ocean Beach Athletic Area - Robb Field | 30206 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 68.208 | Ocean Beach Athletic Area - Robb Field | 0 | Local Recreation Area 3 | 4 | |
2838 | 2838 | 2837 | {"type": "Polygon", "coordinates": [[[-121.93421, 36.60999], [-121.93184, 36.60975], [-121.932, 36.60951], [-121.93212, 36.60925], [-121.93222, 36.60897], [-121.93226, 36.6088], [-121.93229, 36.60854], [-121.93229, 36.60833], [-121.93227, 36.60812], [-121.93222, 36.60787], [-121.93214, 36.60765], [-121.93203, 36.60742], [-121.9319, 36.60721], [-121.93327, 36.60681], [-121.93327, 36.60718], [-121.9333, 36.60759], [-121.9334, 36.60812], [-121.9335, 36.60851], [-121.93372, 36.60916], [-121.93395, 36.60967], [-121.93405, 36.60983], [-121.93421, 36.60999]]]} | Open Access 1 | 65 | Rip Van Winkle Open Space | 24395 | 3016 | Del Monte Forest Foundation 559 | Non Profit 6 | Non Profit - Conservation 12 | http://www.delmonteforestfoundation.org/ | Non Governmental Organization 10 | 3016 | Del Monte Forest Foundation 552 | Non Profit 6 | Non Profit - Conservation 12 | Monterey 14 | 9.948 | Rip Van Winkle OS | 0 | Private Recreation or Education 65 | 4 | |
2839 | 2839 | 2838 | {"type": "Polygon", "coordinates": [[[-117.15582, 32.75554], [-117.15554, 32.75574], [-117.15531, 32.75552], [-117.15538, 32.75542], [-117.15582, 32.75543], [-117.15582, 32.75554]]]} | Open Access 1 | 68 | Uptown Open Space | 26740 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.27 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
2840 | 2840 | 2839 | {"type": "Polygon", "coordinates": [[[-117.19326, 32.96674], [-117.19257, 32.96698], [-117.19225, 32.96707], [-117.1915, 32.96711], [-117.19085, 32.96726], [-117.18994, 32.96739], [-117.18968, 32.96693], [-117.19283, 32.96625], [-117.19304, 32.96653], [-117.19313, 32.9666], [-117.19326, 32.96674]]]} | Open Access 1 | 46742 | Solana Ranch Neighborhood Park | 30192 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 4.961 | Solana Ranch Neighborhood Park | 0 | Local Park 2 | 4 | |
2841 | 2841 | 2840 | {"type": "Polygon", "coordinates": [[[-117.25994, 32.80298], [-117.25981, 32.80306], [-117.25952, 32.80239], [-117.25945, 32.80228], [-117.25935, 32.80219], [-117.25919, 32.80211], [-117.2593, 32.80184], [-117.25941, 32.80193], [-117.25954, 32.80211], [-117.25969, 32.80243], [-117.2598, 32.80281], [-117.25994, 32.80298]]]} | Open Access 1 | 46743 | Palisades South Neighborhood Park | 30193 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.502 | Palisades South Neighborhood Park | 0 | Local Park 2 | 4 | |
2842 | 2842 | 2841 | {"type": "Polygon", "coordinates": [[[-117.10063, 32.90516], [-117.10062, 32.90527], [-117.10055, 32.90555], [-117.10002, 32.90543], [-117.09972, 32.90538], [-117.09858, 32.90527], [-117.09844, 32.90524], [-117.09823, 32.90515], [-117.09819, 32.90512], [-117.09818, 32.90508], [-117.09819, 32.90505], [-117.0983, 32.90494], [-117.09838, 32.905], [-117.09885, 32.9048], [-117.09917, 32.90479], [-117.09953, 32.90481], [-117.0999, 32.90489], [-117.10032, 32.905], [-117.10056, 32.90509], [-117.10063, 32.90516]]]} | Open Access 1 | 46756 | Hoyt Neighborhood Park | 30207 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 2.842 | Hoyt Neighborhood Park | 0 | Local Park 2 | 4 | |
2843 | 2843 | 2842 | {"type": "Polygon", "coordinates": [[[-117.20575, 32.9544], [-117.2055, 32.95463], [-117.20523, 32.95435], [-117.20525, 32.95431], [-117.20544, 32.95418], [-117.20575, 32.9544]]]} | Open Access 1 | 46757 | Pearlman Mini-Park | 30208 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.3 | Pearlman Mini-Park | 0 | Local Park 2 | 4 | |
2844 | 2844 | 2843 | {"type": "Polygon", "coordinates": [[[-120.45376, 36.85645], [-120.45339, 36.8567], [-120.45287, 36.85616], [-120.45324, 36.85591], [-120.45376, 36.85645]]]} | Open Access 1 | 18764 | Library Park | 21218 | 1107 | Firebaugh, City of 523 | City 2 | City Agency 2 | http://www.ci.firebaugh.ca.us/ | City 2 | 1107 | Firebaugh, City of 516 | City 2 | City Agency 2 | Fresno 9 | 0.808 | Library Park | 0 | Local Park 2 | 4 | |
2845 | 2845 | 2844 | {"type": "Polygon", "coordinates": [[[-117.14968, 32.92475], [-117.14966, 32.92527], [-117.14827, 32.92531], [-117.14824, 32.92448], [-117.14822, 32.92432], [-117.14812, 32.92408], [-117.14815, 32.92402], [-117.14838, 32.92394], [-117.1486, 32.92391], [-117.14951, 32.9239], [-117.14954, 32.9245], [-117.14957, 32.92454], [-117.14953, 32.92457], [-117.14951, 32.92464], [-117.14954, 32.92472], [-117.14959, 32.92474], [-117.14968, 32.92475]]]} | Open Access 1 | 18765 | Sandburg Neighborhood Park | 30128 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 4.777 | Sandburg Neighborhood Park | 0 | Local Park 2 | 4 | |
2846 | 2846 | 2845 | {"type": "Polygon", "coordinates": [[[-117.96866, 33.72804], [-117.96726, 33.72806], [-117.96726, 33.72727], [-117.96728, 33.72725], [-117.96733, 33.72724], [-117.96809, 33.72724], [-117.96817, 33.72723], [-117.96827, 33.72716], [-117.96866, 33.72715], [-117.96866, 33.72804]]]} | Open Access 1 | 22116 | Vista View Park | 27193 | 1111 | Fountain Valley, City of 273 | City 2 | City Agency 2 | http://www.fountainvalley.org/visitors/parks/ | City 2 | 1111 | Fountain Valley, City of 268 | City 2 | City Agency 2 | Orange 3 | 2.989 | Vista View Park | 0 | Local Park 2 | 4 | |
2847 | 2847 | 2846 | {"type": "Polygon", "coordinates": [[[-120.96349, 37.6595], [-120.96212, 37.6595], [-120.9621, 37.65929], [-120.96209, 37.65818], [-120.96214, 37.65817], [-120.96241, 37.65818], [-120.96348, 37.65818], [-120.96349, 37.6595]]]} | Open Access 1 | 18809 | Rose Avenue Park | 24605 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 4.439 | Rose Avenue Park | 0 | Local Park 2 | 4 | |
2848 | 2848 | 2847 | {"type": "MultiPolygon", "coordinates": [[[[-120.97023, 37.62482], [-120.97022, 37.62563], [-120.96975, 37.62563], [-120.96974, 37.62527], [-120.96906, 37.62527], [-120.96906, 37.62492], [-120.96944, 37.62487], [-120.96964, 37.62479], [-120.9698, 37.62476], [-120.96997, 37.62477], [-120.97023, 37.62482]]], [[[-120.97081, 37.62564], [-120.97036, 37.62563], [-120.97037, 37.62486], [-120.97081, 37.62495], [-120.97081, 37.62564]]]]} | Open Access 1 | 18777 | Orville Wright Park / George Rogers Park | 23230 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 2.467 | Orville Wright Park / George Rogers Park | 0 | Local Park 2 | 4 | |
2849 | 2849 | 2848 | {"type": "Polygon", "coordinates": [[[-120.98416, 37.60551], [-120.98131, 37.60551], [-120.98113, 37.60552], [-120.98079, 37.60558], [-120.9807, 37.60561], [-120.98048, 37.60564], [-120.98042, 37.6051], [-120.98416, 37.60508], [-120.98416, 37.60551]]]} | Open Access 1 | 18780 | Parklawn Park | 23444 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 3.907 | Parklawn Park | 0 | Local Park 2 | 4 | |
2850 | 2850 | 2849 | {"type": "Polygon", "coordinates": [[[-117.13628, 33.53783], [-117.1363, 33.53802], [-117.13629, 33.53814], [-117.13615, 33.53855], [-117.13606, 33.53872], [-117.13577, 33.53862], [-117.13556, 33.53846], [-117.13547, 33.53844], [-117.13542, 33.53845], [-117.13535, 33.53849], [-117.13532, 33.53853], [-117.13532, 33.53858], [-117.13521, 33.53864], [-117.13517, 33.53863], [-117.1351, 33.53885], [-117.13473, 33.53879], [-117.13436, 33.53867], [-117.13439, 33.5383], [-117.13445, 33.53824], [-117.13628, 33.53783]]]} | Open Access 1 | 22139 | Nicholas Road Park | 22746 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 2.913 | Nicholas Road Park | 0 | Local Park 2 | 4 | |
2851 | 2851 | 2850 | {"type": "Polygon", "coordinates": [[[-117.13417, 33.5384], [-117.13414, 33.53866], [-117.13392, 33.5387], [-117.13353, 33.53869], [-117.13336, 33.53866], [-117.1325, 33.5387], [-117.13407, 33.53834], [-117.13417, 33.5384]]]} | Open Access 1 | 22140 | Voorburg Park | 27197 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 0.728 | Voorburg Park | 0 | Local Park 2 | 4 | |
2852 | 2852 | 2851 | {"type": "Polygon", "coordinates": [[[-121.00528, 37.66562], [-121.00415, 37.6656], [-121.00414, 37.66569], [-121.00317, 37.66566], [-121.00316, 37.66396], [-121.00527, 37.66401], [-121.00528, 37.66562]]]} | Open Access 1 | 18802 | Roosevelt Park | 24598 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 8.445 | Roosevelt 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]);