units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by YR_EST
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- California Department of Parks and Recreation 372
- California Department of Fish and Wildlife 298
- San Jose, City of 204
- San Diego, City of 136
- East Bay Regional Park District 136
- Mountains Recreation and Conservation Authority 111
- United States Bureau of Land Management 101
- Ventura, City of 101
- Los Angeles, City of 94
- United States Forest Service 93
- United States Fish and Wildlife Service 73
- Roseville, City of 65
- California State Lands Commission 57
- United States National Park Service 54
- Long Beach, City of 54
- Los Angeles, County of 53
- Butte, County of 45
- Midpeninsula Regional Open Space District 44
- Poway, City of 43
- Consumnes Community Services District 40
- Orange, County of 38
- Redwood City, City of 37
- Irvine, City of 36
- Rocklin, City of 35
- Santa Clara County Parks and Recreation Dept., County of 34
- San Diego, County of 33
- Palo Alto, City of 33
- Lake, County of 33
- San Mateo, City of 32
- Fremont, City of 32
- …
DES_TP >30
- Local Park 2,301
- Local Recreation Area 892
- Local Other or Unknown 696
- State Conservation Area 311
- Private Conservation 252
- Local Conservation Area 245
- State Park 208
- Private Recreation or Education 140
- State Recreation Area 98
- National Forest 93
- State Resource Management Area 73
- National Public Lands 72
- National Wildlife Refuge 72
- State Historic or Cultural Area 62
- National Monument or Landmark 38
- National Park 26
- Recreation Management Area 23
- State Other or Unknown 19
- National Recreation Area 17
- Local Resource Management Area 15
- Local Historic or Cultural Area 12
- Conservation Area 11
- Private Other or Unknown 8
- Private Agricultural 7
- Resource Management Area 6
- Federal Other or Unknown 6
- Historic or Cultural Area 4
- Area of Critical Environmental Concern 4
- Wilderness Area 2
- State Wilderness 2
- …
MNG_AG_TYP 28
- City Agency 3,009
- State Agency 790
- Recreation/Parks District 454
- County Agency 372
- Federal Agency 351
- Non Profit - Land Trust 211
- Open Space District 147
- County Agency - Parks 124
- Home Owners Association 111
- Water District 87
- Non Profit - Conservation 74
- Community Services District 71
- Flood District 21
- Non Profit - Other 16
- County Agency - Other 11
- Irrigation District 10
- Port/Harbor District 6
- School District 6
- Transportation Agency 5
- Commercial 4
- Special District - Other 4
- Cemetery District 3
- Sanitation District 3
- Joint Powers Authority 3
- Other 3
- Conservation District 3
- Mitigation Bank 2
- Non Profit - Education 1
ACCESS_TYP 4
- Open Access 4,860
- Restricted Access 577
- No Public Access 320
- Unknown Access 145
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12319 | 12319 | 12318 | {"type": "Polygon", "coordinates": [[[-119.2843, 36.30187], [-119.28423, 36.30209], [-119.2842, 36.30237], [-119.28416, 36.30246], [-119.28417, 36.30251], [-119.2842, 36.30256], [-119.28419, 36.30361], [-119.28293, 36.3036], [-119.28289, 36.30358], [-119.28287, 36.30355], [-119.28287, 36.30186], [-119.28288, 36.30184], [-119.28293, 36.30181], [-119.28367, 36.30182], [-119.28424, 36.30181], [-119.28429, 36.30183], [-119.2843, 36.30187]]]} | Open Access 1 | 25962 | Burke Park | 16522 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 5.879 | Burke Park | 0 | Local Park 2 | 4 | |
12320 | 12320 | 12319 | {"type": "Polygon", "coordinates": [[[-119.26942, 36.30909], [-119.26793, 36.30907], [-119.26794, 36.30806], [-119.26829, 36.30801], [-119.26875, 36.30791], [-119.26896, 36.30787], [-119.26921, 36.30785], [-119.26938, 36.30786], [-119.26941, 36.3079], [-119.26942, 36.30909]]]} | Open Access 1 | 25963 | Cherry Meadow Park | 17171 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 4.157 | Cherry Meadow Park | 0 | Local Park 2 | 4 | |
12321 | 12321 | 12320 | {"type": "Polygon", "coordinates": [[[-120.84144, 37.04562], [-120.84101, 37.04582], [-120.84084, 37.04572], [-120.84096, 37.04555], [-120.84092, 37.04526], [-120.84126, 37.04521], [-120.84129, 37.04531], [-120.84144, 37.04562]]]} | Open Access 1 | 25983 | Presidential Park | 23989 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 0.542 | Presidential Park | 0 | Local Park 2 | 4 | |
12322 | 12322 | 12321 | {"type": "Polygon", "coordinates": [[[-119.47502, 36.7331], [-119.47483, 36.73317], [-119.47481, 36.73326], [-119.47375, 36.73264], [-119.47308, 36.73291], [-119.4716, 36.73202], [-119.47134, 36.73246], [-119.47051, 36.73212], [-119.47043, 36.7321], [-119.47052, 36.73197], [-119.47095, 36.7312], [-119.47206, 36.73151], [-119.47297, 36.73185], [-119.47502, 36.7331]]]} | Open Access 1 | 25985 | Kings river Access Park | 20661 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 7.286 | Kings river Access Park | 0 | Local Recreation Area 3 | 4 | |
12323 | 12323 | 12322 | {"type": "Polygon", "coordinates": [[[-119.15477, 36.30086], [-119.15469, 36.30203], [-119.15456, 36.30314], [-119.15421, 36.30314], [-119.15375, 36.30313], [-119.15371, 36.30308], [-119.15387, 36.30084], [-119.15477, 36.30086]]]} | Open Access 1 | 25986 | Schroth Park | 25195 | 1103 | Exeter, City of 129 | City 2 | City Agency 2 | http://www.cityofexeter.com/ | City 2 | 1103 | Exeter, City of 126 | City 2 | City Agency 2 | Tulare 29 | 5.011 | Schroth Park | 0 | Local Park 2 | 4 | |
12324 | 12324 | 12323 | {"type": "Polygon", "coordinates": [[[-120.57279, 37.33992], [-120.57265, 37.3401], [-120.57267, 37.34039], [-120.57259, 37.3405], [-120.5726, 37.34095], [-120.57249, 37.34105], [-120.5724, 37.34106], [-120.57232, 37.34106], [-120.57227, 37.34104], [-120.57218, 37.34095], [-120.5721, 37.34093], [-120.57203, 37.34095], [-120.57198, 37.341], [-120.5719, 37.3409], [-120.57188, 37.34081], [-120.57192, 37.34054], [-120.57198, 37.34035], [-120.57211, 37.34018], [-120.57226, 37.34011], [-120.5726, 37.34], [-120.57277, 37.33991], [-120.57279, 37.33992]]]} | Open Access 1 | 25987 | Unamed Park | 26651 | 1014 | Atwater, City of 470 | City 2 | City Agency 2 | http://www.atwater.org/index.cfm?page=940884 | City 2 | 1014 | Atwater, City of 463 | City 2 | City Agency 2 | Merced 37 | 1.503 | Unamed Park | 0 | Local Park 2 | 4 | |
12325 | 12325 | 12324 | {"type": "MultiPolygon", "coordinates": [[[[-120.50386, 37.30145], [-120.50368, 37.30177], [-120.5034, 37.30167], [-120.50358, 37.30135], [-120.50386, 37.30145]]], [[[-120.50419, 37.30157], [-120.50401, 37.30189], [-120.50371, 37.30178], [-120.50389, 37.30146], [-120.50419, 37.30157]]]]} | Open Access 1 | 25988 | Dennis Chavez Park | 18088 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 0.543 | Dennis Chavez Park | 0 | Local Park 2 | 4 | |
12326 | 12326 | 12325 | {"type": "MultiPolygon", "coordinates": [[[[-121.04968, 37.68284], [-121.04964, 37.68286], [-121.04072, 37.68546], [-121.04071, 37.68514], [-121.04967, 37.68252], [-121.04968, 37.68284]]], [[[-121.04051, 37.68552], [-121.03338, 37.6876], [-121.03168, 37.68809], [-121.03168, 37.68777], [-121.0405, 37.6852], [-121.04051, 37.68552]]], [[[-121.03142, 37.68816], [-121.02727, 37.68937], [-121.02669, 37.68937], [-121.0267, 37.68922], [-121.03142, 37.68784], [-121.03142, 37.68816]]], [[[-121.02637, 37.68964], [-121.02317, 37.69057], [-121.02251, 37.69076], [-121.0225, 37.69044], [-121.02532, 37.68962], [-121.02637, 37.68964]]], [[[-121.02237, 37.69086], [-121.02159, 37.69113], [-121.02161, 37.69143], [-121.01974, 37.69157], [-121.01781, 37.69213], [-121.01771, 37.69184], [-121.02069, 37.69097], [-121.02069, 37.69137], [-121.02155, 37.69138], [-121.02155, 37.69109], [-121.02237, 37.69079], [-121.02237, 37.69086]]], [[[-121.01761, 37.69219], [-121.01578, 37.69273], [-121.01265, 37.69363], [-121.01264, 37.69331], [-121.01377, 37.69298], [-121.01751, 37.6919], [-121.01761, 37.69219]]], [[[-121.0124, 37.69371], [-121.00845, 37.69486], [-121.00832, 37.69457], [-121.0124, 37.69339], [-121.0124, 37.69371]]], [[[-121.00826, 37.69491], [-121.00639, 37.69546], [-121.00416, 37.6961], [-121.00417, 37.69578], [-121.00813, 37.69463], [-121.00826, 37.69491]]]]} | Open Access 1 | 25993 | Hetch Hetchy Trail | 19886 | 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 | 32.984 | Hetch Hetchy Trail | 0 | Local Recreation Area 3 | 4 | |
12327 | 12327 | 12326 | {"type": "Polygon", "coordinates": [[[-120.97845, 37.64795], [-120.97801, 37.64811], [-120.97726, 37.64835], [-120.97691, 37.64844], [-120.97608, 37.64861], [-120.97561, 37.64876], [-120.97552, 37.64875], [-120.97533, 37.64881], [-120.97529, 37.64887], [-120.97511, 37.64892], [-120.97493, 37.64895], [-120.9748, 37.649], [-120.97469, 37.64905], [-120.97097, 37.64905], [-120.97097, 37.64875], [-120.97212, 37.64848], [-120.97279, 37.64831], [-120.97417, 37.64831], [-120.97499, 37.64825], [-120.9759, 37.64803], [-120.97666, 37.64792], [-120.97692, 37.64786], [-120.97741, 37.64757], [-120.97766, 37.64736], [-120.97831, 37.64775], [-120.97845, 37.64795]]]} | Open Access 1 | 25994 | Pamela Monterosso Park | 23379 | 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 | 11.359 | Pamela Monterosso Park | 0 | Local Park 2 | 4 | |
12328 | 12328 | 12327 | {"type": "Polygon", "coordinates": [[[-120.98211, 37.58466], [-120.98089, 37.58466], [-120.98088, 37.58295], [-120.98094, 37.5829], [-120.98211, 37.5829], [-120.98211, 37.58466]]]} | Open Access 1 | 25995 | Sam Ryno Park | 24818 | 1050 | Ceres, City of 514 | City 2 | City Agency 2 | http://www.ci.ceres.ca.us/ | City 2 | 1050 | Ceres, City of 507 | City 2 | City Agency 2 | Stanislaus 2 | 5.229 | Sam Ryno Park | 0 | Local Park 2 | 4 | |
12330 | 12330 | 12329 | {"type": "Polygon", "coordinates": [[[-120.88136, 37.53461], [-120.88115, 37.53479], [-120.88095, 37.53489], [-120.88068, 37.53495], [-120.88041, 37.53495], [-120.88049, 37.53372], [-120.88047, 37.5333], [-120.88062, 37.5336], [-120.88084, 37.53392], [-120.88105, 37.53417], [-120.88134, 37.53445], [-120.88133, 37.53453], [-120.88136, 37.53461]]]} | Open Access 1 | 25997 | Brad Bates Park | 16322 | 1358 | Turlock, City of 42 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | Stanislaus 2 | 1.958 | Brad Bates Park | 0 | Local Park 2 | 4 | |
12331 | 12331 | 12330 | {"type": "Polygon", "coordinates": [[[-120.87596, 37.53289], [-120.87589, 37.53495], [-120.87568, 37.53495], [-120.87543, 37.53491], [-120.8752, 37.53482], [-120.87494, 37.53462], [-120.87492, 37.53459], [-120.87493, 37.5345], [-120.87492, 37.53443], [-120.87532, 37.534], [-120.87558, 37.53365], [-120.8758, 37.53328], [-120.87596, 37.53289]]]} | Open Access 1 | 26000 | Curt Andre Park | 32560 | 1358 | Turlock, City of 42 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | Stanislaus 2 | 2.568 | Curt Andre Park | 0 | Local Park 2 | 4 | |
12332 | 12332 | 12331 | {"type": "Polygon", "coordinates": [[[-121.09587, 38.20221], [-121.09573, 38.20244], [-121.09539, 38.20279], [-121.09495, 38.2033], [-121.09441, 38.20379], [-121.09392, 38.20414], [-121.09368, 38.20446], [-121.09316, 38.20486], [-121.09294, 38.20498], [-121.09139, 38.2034], [-121.09121, 38.20317], [-121.09066, 38.20236], [-121.09587, 38.20221]]]} | Open Access 1 | 26005 | Stillman Magee Park | 25851 | 322 | San Joaquin, County of 479 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | San Joaquin 39 | 18.43 | Stillman Magee Park | 0 | Local Park 2 | 4 | |
12333 | 12333 | 12332 | {"type": "Polygon", "coordinates": [[[-121.27031, 37.97923], [-121.26981, 37.97935], [-121.26951, 37.97862], [-121.27001, 37.9785], [-121.27031, 37.97923]]]} | Open Access 1 | 26006 | West Jackson Park | 27364 | 322 | San Joaquin, County of 479 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | San Joaquin 39 | 0.966 | West Jackson Park | 0 | Local Park 2 | 4 | |
12334 | 12334 | 12333 | {"type": "Polygon", "coordinates": [[[-121.45588, 37.74477], [-121.45584, 37.74546], [-121.45541, 37.74547], [-121.45521, 37.74542], [-121.45537, 37.74509], [-121.45541, 37.74483], [-121.45574, 37.74485], [-121.45581, 37.74483], [-121.45588, 37.74477]]]} | Open Access 1 | 26010 | McCray Family Park | 22012 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 0.801 | McCray Family Park | 0 | Local Park 2 | 4 | |
12335 | 12335 | 12334 | {"type": "Polygon", "coordinates": [[[-121.43743, 37.71857], [-121.43736, 37.71857], [-121.43729, 37.71879], [-121.43722, 37.71879], [-121.43715, 37.71857], [-121.43708, 37.71857], [-121.43708, 37.71831], [-121.43742, 37.71831], [-121.43743, 37.71857]]]} | Open Access 1 | 26019 | Mount Oso Park | 22529 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 0.291 | Mount Oso Park | 0 | Local Park 2 | 4 | |
12336 | 12336 | 12335 | {"type": "Polygon", "coordinates": [[[-120.75895, 37.63772], [-120.75843, 37.63793], [-120.75843, 37.63794], [-120.7585, 37.63802], [-120.75795, 37.63835], [-120.75791, 37.63832], [-120.75693, 37.63834], [-120.75693, 37.63745], [-120.75566, 37.63745], [-120.75565, 37.63666], [-120.75722, 37.63673], [-120.75838, 37.63645], [-120.75895, 37.63772]]]} | Open Access 1 | 26024 | Waterford River Walk Park | 27302 | 1372 | Waterford, City of 57 | City 2 | City Agency 2 | http://www.cityofwaterford.org/departments/parks-and-recreation/ | City 2 | 1372 | Waterford, City of 55 | City 2 | City Agency 2 | Stanislaus 2 | 9.334 | Waterford River Walk Park | 0 | Local Park 2 | 4 | |
12337 | 12337 | 12336 | {"type": "Polygon", "coordinates": [[[-117.59297, 33.57935], [-117.5906, 33.57944], [-117.5906, 33.57936], [-117.59074, 33.57915], [-117.59088, 33.57867], [-117.59074, 33.57823], [-117.59043, 33.57819], [-117.59046, 33.57797], [-117.59054, 33.57797], [-117.59071, 33.57708], [-117.5908, 33.57684], [-117.59081, 33.57677], [-117.59081, 33.57616], [-117.59104, 33.57592], [-117.59114, 33.5757], [-117.59118, 33.57551], [-117.59118, 33.57539], [-117.59123, 33.57533], [-117.59151, 33.57526], [-117.592, 33.57655], [-117.59267, 33.57821], [-117.59284, 33.57878], [-117.59297, 33.57935]]]} | Open Access 1 | 26029 | Wagon Wheel Sports Park | 27211 | 2276 | Santa Margarita Water District 1018 | Special District 4 | Water District 13 | http://www.smwd.com/ | Special District 4 | 2276 | Santa Margarita Water District 980 | Special District 4 | Water District 13 | Orange 3 | 15.769 | Wagon Wheel Sports Park | 0 | Local Recreation Area 3 | 4 | |
12338 | 12338 | 12337 | {"type": "Polygon", "coordinates": [[[-117.42992, 34.05372], [-117.42991, 34.05376], [-117.42985, 34.0538], [-117.42973, 34.05386], [-117.42961, 34.05389], [-117.42948, 34.05391], [-117.42894, 34.05391], [-117.42898, 34.05387], [-117.42897, 34.05243], [-117.4289, 34.05238], [-117.42967, 34.05236], [-117.42973, 34.05241], [-117.42975, 34.05333], [-117.42981, 34.05354], [-117.42992, 34.05372]]]} | Open Access 1 | 26030 | Sycamore Hills Park | 26130 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 3.081 | Sycamore Hills Park | 0 | Local Park 2 | 4 | |
12339 | 12339 | 12338 | {"type": "Polygon", "coordinates": [[[-121.2776, 38.00211], [-121.27728, 38.00219], [-121.27736, 38.00241], [-121.27624, 38.0027], [-121.27615, 38.00266], [-121.27579, 38.00178], [-121.27575, 38.00165], [-121.27566, 38.00154], [-121.27553, 38.0015], [-121.2754, 38.00123], [-121.27549, 38.00119], [-121.27536, 38.00095], [-121.27694, 38.00044], [-121.27746, 38.00171], [-121.27749, 38.00185], [-121.2776, 38.00211]]]} | Open Access 1 | 26031 | SL Fong Park | 25550 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 7.461 | SL Fong 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]);