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 7,531
- Recreation/Parks District 939
- State Agency 933
- County Agency 904
- Non Profit - Land Trust 449
- Federal Agency 391
- Open Space District 383
- County Agency - Parks 191
- Water District 178
- Home Owners Association 163
- Community Services District 162
- Non Profit - Conservation 124
- Flood District 90
- Irrigation District 35
- Non Profit - Other 35
- School District 33
- Cemetery District 31
- County Agency - Other 25
- Port/Harbor District 24
- Special District - Other 14
- Commercial 11
- Joint Powers Authority 7
- Sanitation District 6
- 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 375
- California Department of Fish and Wildlife 357
- Los Angeles, City of 352
- California Department of Parks and Recreation 323
- Mountains Recreation and Conservation Authority 314
- Sacramento, City of 189
- San Jose, City of 169
- San Francisco, City and County of 152
- East Bay Regional Park District 145
- Los Angeles, County of 127
- Ventura, City of 123
- Long Beach, City of 117
- Roseville, City of 105
- San Diego, County of 96
- Santa Barbara, County of 90
- Oakland, City of 90
- United States Bureau of Land Management 86
- Consumnes Community Services District 86
- United States Forest Service 82
- Napa, City of 77
- United States Fish and Wildlife Service 72
- California State Lands Commission 72
- Orange, County of 72
- United States National Park Service 69
- Hayward Area Recreation and Park District 67
- Irvine, City of 66
- Valley-Wide Recreation and Park District 59
- Tracy, City of 59
- Poway, City of 58
- Davis, City of 58
- …
DES_TP >30
- Local Park 6,485
- Local Recreation Area 1,630
- Local Other or Unknown 1,083
- Private Conservation 474
- Local Conservation Area 392
- State Conservation Area 332
- Private Recreation or Education 206
- State Park 181
- State Resource Management Area 119
- State Recreation Area 115
- National Forest 71
- National Wildlife Refuge 66
- Local Historic or Cultural Area 61
- State Historic or Cultural Area 57
- State Other or Unknown 56
- Private Other or Unknown 51
- Recreation Management Area 49
- National Public Lands 45
- National Monument or Landmark 34
- National Recreation Area 32
- National Park 22
- Federal Other or Unknown 18
- Local Resource Management Area 17
- Resource Management Area 16
- Conservation Area 12
- Private Agricultural 10
- Area of Critical Environmental Concern 7
- Wilderness Area 5
- Historic or Cultural Area 4
- Private Historic or Cultural 4
- …
ACCESS_TYP 4
- Open Access 10,641
- Restricted Access 967
- No Public Access 766
- Unknown Access 318
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4377 | 4377 | 4376 | {"type": "Polygon", "coordinates": [[[-117.95103, 33.89252], [-117.95065, 33.89253], [-117.95003, 33.89257], [-117.94996, 33.89212], [-117.94981, 33.89213], [-117.94979, 33.89207], [-117.94994, 33.892], [-117.9499, 33.89172], [-117.95102, 33.89171], [-117.95103, 33.89252]]]} | Open Access 1 | 10296 | Roger Chaffee Park | 24558 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 2.259 | Roger Chaffee Park | 0 | Local Park 2 | 4 | |
4378 | 4378 | 4377 | {"type": "Polygon", "coordinates": [[[-118.65346, 34.21206], [-118.65173, 34.219], [-118.64897, 34.21904], [-118.64896, 34.21858], [-118.64916, 34.21842], [-118.64976, 34.2184], [-118.64975, 34.21784], [-118.64905, 34.21741], [-118.64856, 34.21792], [-118.64784, 34.21837], [-118.64645, 34.21837], [-118.64623, 34.21795], [-118.6464, 34.21788], [-118.64656, 34.21756], [-118.64663, 34.21755], [-118.64706, 34.21707], [-118.64738, 34.21705], [-118.64738, 34.21682], [-118.64756, 34.21681], [-118.64773, 34.2169], [-118.64804, 34.21662], [-118.64808, 34.2164], [-118.64825, 34.21624], [-118.64878, 34.21602], [-118.64887, 34.21596], [-118.6492, 34.21589], [-118.64935, 34.2158], [-118.64992, 34.21557], [-118.65014, 34.21553], [-118.65056, 34.21603], [-118.65076, 34.21602], [-118.65077, 34.21559], [-118.65114, 34.21515], [-118.65132, 34.21516], [-118.65164, 34.21498], [-118.65158, 34.21475], [-118.65164, 34.21473], [-118.65172, 34.21499], [-118.65221, 34.21499], [-118.65213, 34.2146], [-118.6521, 34.21422], [-118.65196, 34.21423], [-118.65201, 34.21395], [-118.65194, 34.21388], [-118.65168, 34.21378], [-118.65179, 34.21318], [-118.65268, 34.21278], [-118.65296, 34.21211], [-118.6527, 34.21155], [-118.65243, 34.2114], [-118.65196, 34.21078], [-118.65202, 34.21078], [-118.65346, 34.21206]]]} | Open Access 1 | 10379 | Roscoe-Valley Circle Park | 24603 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 44.379 | Roscoe-Valley Circle Park | 0 | Local Park 2 | 4 | |
4379 | 4379 | 4378 | {"type": "Polygon", "coordinates": [[[-122.75772, 38.44893], [-122.7573, 38.44893], [-122.75729, 38.44902], [-122.75694, 38.44937], [-122.75684, 38.44945], [-122.75679, 38.44945], [-122.75677, 38.44897], [-122.75653, 38.44897], [-122.75653, 38.44894], [-122.75665, 38.44883], [-122.75672, 38.44873], [-122.75676, 38.44856], [-122.75672, 38.44824], [-122.75672, 38.44809], [-122.75668, 38.44793], [-122.75733, 38.44794], [-122.75737, 38.44818], [-122.75768, 38.44869], [-122.75771, 38.44882], [-122.75772, 38.44893]]]} | Open Access 1 | 10413 | Dutch Flohr Park | 18318 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 2.388 | Dutch Flohr Park | 0 | Local Park 2 | 4 | |
4380 | 4380 | 4379 | {"type": "Polygon", "coordinates": [[[-118.17688, 33.84102], [-118.17654, 33.8412], [-118.17644, 33.84116], [-118.17644, 33.84082], [-118.17673, 33.84082], [-118.17688, 33.84102]]]} | Open Access 1 | 45939 | Orange Park | 29014 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.301 | Orange Park | 0 | Local Park 2 | 4 | |
4381 | 4381 | 4380 | {"type": "Polygon", "coordinates": [[[-118.16393, 34.16098], [-118.16379, 34.16061], [-118.16342, 34.15865], [-118.16335, 34.15813], [-118.16386, 34.15794], [-118.16423, 34.15776], [-118.16566, 34.15687], [-118.16598, 34.15672], [-118.16632, 34.15661], [-118.16677, 34.15651], [-118.16715, 34.15641], [-118.16734, 34.15642], [-118.16744, 34.15645], [-118.16752, 34.15651], [-118.1676, 34.15659], [-118.16774, 34.15703], [-118.16775, 34.1572], [-118.16774, 34.15747], [-118.16767, 34.15782], [-118.16758, 34.15807], [-118.16741, 34.1584], [-118.16725, 34.15863], [-118.16712, 34.15877], [-118.16692, 34.15898], [-118.16652, 34.15927], [-118.16623, 34.15943], [-118.16566, 34.15966], [-118.16538, 34.15979], [-118.1652, 34.15989], [-118.16452, 34.16034], [-118.1643, 34.16053], [-118.16407, 34.1608], [-118.16393, 34.16098]]]} | Open Access 1 | 45943 | Brookside Park Area H | 29050 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | Los Angeles 6 | 27.409 | Brookside Park Area H | None 390 | |||
4382 | 4382 | 4381 | {"type": "Polygon", "coordinates": [[[-118.08827, 34.15937], [-118.08808, 34.159], [-118.08793, 34.15862], [-118.08911, 34.15861], [-118.08915, 34.15862], [-118.08915, 34.15932], [-118.08913, 34.15934], [-118.0891, 34.15936], [-118.08827, 34.15937]]]} | Open Access 1 | 45944 | Eaton Sunnyslope Park | 29051 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://www.cityofpasadena.net/PublicWorks/Eaton_Sunnyslope_Park/ | Los Angeles 6 | 2.002 | Eaton Sunnyslope Park | 0 | Local Park 2 | 4 |
4383 | 4383 | 4382 | {"type": "Polygon", "coordinates": [[[-118.08786, 34.15841], [-118.08776, 34.15803], [-118.08769, 34.15766], [-118.08912, 34.15764], [-118.08917, 34.15766], [-118.08916, 34.15835], [-118.08914, 34.15838], [-118.08786, 34.15841]]]} | Open Access 1 | 45945 | Gwinn Park | 29052 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://www.cityofpasadena.net/PublicWorks/Gwinn_Park/ | Los Angeles 6 | 2.633 | Gwinn Park | 0 | Local Park 2 | 4 |
4384 | 4384 | 4383 | {"type": "Polygon", "coordinates": [[[-117.17555, 32.6822], [-117.17543, 32.68228], [-117.1751, 32.68236], [-117.17534, 32.6821], [-117.17555, 32.6822]]]} | Open Access 1 | 45960 | Vista Del Barco Park | 29077 | 1069 | Coronado, City of 105 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | http://www.welcometocoronado.com/coronado-living/coronado-parks/ | San Diego 4 | 0.128 | Vista Del Barco Park | 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 |
4386 | 4386 | 4385 | {"type": "Polygon", "coordinates": [[[-117.35693, 33.17681], [-117.35685, 33.17689], [-117.3562, 33.17729], [-117.35652, 33.17766], [-117.35629, 33.17779], [-117.35659, 33.17815], [-117.3568, 33.1783], [-117.3563, 33.1786], [-117.35517, 33.17726], [-117.3566, 33.1764], [-117.35693, 33.17681]]]} | Restricted Access 2 | 45967 | South Oceanside School Park | 31598 | 2100 | Oceanside Unified School District 756 | Special District 4 | School District 14 | http://www.oside.k12.ca.us/ | Special District 4 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#48 | San Diego 4 | 4.254 | South Oceanside School Park | 0 | Local Park 2 | 4 |
4387 | 4387 | 4386 | {"type": "Polygon", "coordinates": [[[-117.17078, 33.14419], [-117.17069, 33.14454], [-117.16617, 33.14341], [-117.16616, 33.14322], [-117.16611, 33.14305], [-117.17078, 33.14419]]]} | Open Access 1 | 45969 | Buelow Park | 29118 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/153/1081 | San Diego 4 | 4.241 | Buelow Park | 0 | Local Park 2 | 4 |
4388 | 4388 | 4387 | {"type": "Polygon", "coordinates": [[[-117.24404, 33.20205], [-117.24397, 33.20207], [-117.2439, 33.20204], [-117.24364, 33.20165], [-117.24364, 33.20161], [-117.24366, 33.20157], [-117.24371, 33.20155], [-117.24404, 33.20205]]]} | Open Access 1 | 45980 | Soroptimist Park | 29147 | 1369 | Vista, City of 159 | City 2 | City Agency 2 | http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm | City 2 | 1369 | Vista, City of 155 | City 2 | City Agency 2 | http://www.ebidboard.com/docs/1504/280065/COVParkLandscapeMaintenance.pdf | San Diego 4 | 0.158 | Soroptimist Park | 0 | Local Park 2 | 4 |
4389 | 4389 | 4388 | {"type": "Polygon", "coordinates": [[[-117.06741, 32.94582], [-117.06611, 32.94579], [-117.06614, 32.94569], [-117.06613, 32.94558], [-117.06599, 32.94508], [-117.066, 32.94497], [-117.06604, 32.94487], [-117.0661, 32.94481], [-117.06617, 32.94477], [-117.06647, 32.94467], [-117.06665, 32.94462], [-117.06687, 32.94461], [-117.06698, 32.94458], [-117.06741, 32.94582]]]} | Open Access 1 | 45987 | The Pond | 29156 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 3.291 | The Pond | None 391 | |||
4390 | 4390 | 4389 | {"type": "Polygon", "coordinates": [[[-117.036, 32.97054], [-117.03563, 32.97054], [-117.03563, 32.9703], [-117.036, 32.9703], [-117.036, 32.97054]]]} | Open Access 1 | 45989 | Veteran's Park | 29158 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/538/Veterans-Park | San Diego 4 | 0.229 | Veteran's Park | 0 | Local Park 2 | 4 |
4391 | 4391 | 4390 | {"type": "Polygon", "coordinates": [[[-116.36536, 33.23412], [-116.36466, 33.23413], [-116.3643, 33.23433], [-116.36296, 33.23237], [-116.3634, 33.23211], [-116.36371, 33.23196], [-116.36404, 33.23184], [-116.36438, 33.23175], [-116.36473, 33.23167], [-116.36508, 33.23163], [-116.36526, 33.23161], [-116.3653, 33.23163], [-116.36533, 33.23167], [-116.36536, 33.23412]]]} | Open Access 1 | 45996 | Borrego Springs Park Site Dedication | 29191 | 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 | 11.154 | Borrego Springs Park Site Dedication | None 392 | |||
4392 | 4392 | 4391 | {"type": "Polygon", "coordinates": [[[-117.00165, 32.68355], [-117.0004, 32.68385], [-117.00037, 32.6838], [-117.0005, 32.68375], [-117.00074, 32.68356], [-117.00061, 32.68345], [-117.00052, 32.68333], [-117.00036, 32.6829], [-116.99999, 32.68213], [-116.9997, 32.68168], [-117.00012, 32.68136], [-117.00066, 32.68121], [-117.00114, 32.68245], [-117.00116, 32.68249], [-117.00127, 32.68246], [-117.00165, 32.68355]]]} | Open Access 1 | 46008 | Eastview County Park | 29272 | 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/Eastview.html | San Diego 4 | 6.275 | Eastview County Park | 0 | Local Park 2 | 4 |
4393 | 4393 | 4392 | {"type": "Polygon", "coordinates": [[[-120.83931, 38.1912], [-120.83922, 38.19286], [-120.83482, 38.19289], [-120.83569, 38.19181], [-120.83506, 38.19149], [-120.8353, 38.19115], [-120.83468, 38.19085], [-120.83452, 38.18937], [-120.83931, 38.1912]]]} | Open Access 1 | 48599 | Valley Springs Memorial Park | 33311 | 2431 | Jenny Lind Veterans Memorial District 757 | Special District 4 | Recreation/Parks District 4 | https://jlvmd.specialdistrict.org/ | Special District 4 | 2431 | Jenny Lind Veterans Memorial District 742 | Special District 4 | Recreation/Parks District 4 | Calaveras 53 | 25.966 | Valley Springs Memorial Park | 0 | Local Park 2 | 4 | |
4394 | 4394 | 4393 | {"type": "Polygon", "coordinates": [[[-118.23041, 34.19871], [-118.23092, 34.19917], [-118.23092, 34.19922], [-118.23089, 34.19923], [-118.23031, 34.19921], [-118.23026, 34.19919], [-118.23025, 34.19914], [-118.23034, 34.19874], [-118.23037, 34.19871], [-118.23041, 34.19871]]]} | Restricted Access 2 | 46024 | Sparr Heights Community Center | 29349 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/departments/community-services-parks/parks-facilities-historic-sites/sparr-heights-community-center | Los Angeles 6 | 0.504 | Sparr Heights Community Ctr. | 0 | Local Recreation Area 3 | 4 |
4395 | 4395 | 4394 | {"type": "Polygon", "coordinates": [[[-118.60789, 37.41288], [-118.60787, 37.41414], [-118.60753, 37.41449], [-118.60753, 37.41492], [-118.60774, 37.41516], [-118.60339, 37.41611], [-118.59577, 37.41603], [-118.59579, 37.41253], [-118.59971, 37.41251], [-118.60257, 37.41244], [-118.60451, 37.41246], [-118.60454, 37.41298], [-118.60497, 37.413], [-118.60497, 37.41273], [-118.60737, 37.41274], [-118.60738, 37.41284], [-118.60789, 37.41288]]]} | No Public Access 3 | 48600 | Round Valley Wildlife Area | 33312 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Inyo 43 | 97.218 | Round Valley Wildlife Area | 1993 | State Conservation Area 8 | 2 | |
4396 | 4396 | 4395 | {"type": "Polygon", "coordinates": [[[-118.25959, 34.15416], [-118.25912, 34.15417], [-118.25912, 34.15385], [-118.25959, 34.15384], [-118.25959, 34.15416]]]} | Open Access 1 | 46027 | Doran Gardens Mini Park | 29352 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 0.377 | Doran Gardens MP | 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]);