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_AGENCY >30
- California Department of Parks and Recreation 238
- California Department of Fish and Wildlife 231
- San Diego, City of 147
- Sacramento, City of 145
- Los Angeles, City of 119
- Mountains Recreation and Conservation Authority 115
- East Bay Regional Park District 114
- Ventura, City of 104
- Roseville, City of 97
- Consumnes Community Services District 86
- Los Angeles, County of 65
- California State Lands Commission 64
- United States Fish and Wildlife Service 62
- Long Beach, City of 61
- United States Bureau of Land Management 56
- Davis, City of 56
- Irvine, City of 45
- Butte, County of 45
- Poway, City of 43
- United States Forest Service 42
- Tracy, City of 42
- Orange, County of 41
- Folsom, City of 40
- Lake, County of 39
- Murrieta, City of 39
- Rocklin, City of 39
- San Ramon, City of 38
- Sacramento, County of 38
- Midpeninsula Regional Open Space District 38
- Stockton, City of 37
- …
DES_TP >30
- Local Park 2,762
- Local Recreation Area 964
- Local Other or Unknown 703
- Private Conservation 235
- State Conservation Area 219
- Local Conservation Area 212
- Private Recreation or Education 141
- State Park 139
- State Resource Management Area 88
- State Recreation Area 77
- National Wildlife Refuge 55
- State Historic or Cultural Area 41
- National Forest 40
- National Public Lands 39
- Recreation Management Area 22
- National Monument or Landmark 20
- State Other or Unknown 17
- National Recreation Area 13
- National Park 12
- Local Historic or Cultural Area 12
- Federal Other or Unknown 11
- Local Resource Management Area 10
- Conservation Area 9
- Private Other or Unknown 9
- Private Agricultural 8
- Resource Management Area 4
- Historic or Cultural Area 3
- Area of Critical Environmental Concern 2
- Wilderness Area 1
- State Wilderness 1
- …
MNG_AG_TYP 29
- City Agency 3,421
- State Agency 613
- Recreation/Parks District 547
- County Agency 468
- Federal Agency 226
- Non Profit - Land Trust 198
- Open Space District 161
- Community Services District 146
- Home Owners Association 112
- Water District 108
- County Agency - Parks 100
- Non Profit - Conservation 81
- Flood District 51
- Irrigation District 24
- School District 22
- Non Profit - Other 17
- County Agency - Other 11
- Special District - Other 11
- Port/Harbor District 7
- Commercial 7
- Other 5
- Transportation Agency 5
- Conservation District 4
- Cemetery District 3
- Joint Powers Authority 3
- Sanitation District 2
- Mitigation Bank 2
- Non Profit - Education 2
- Fire District 1
ACCESS_TYP 4
- Open Access 5,202
- Restricted Access 606
- No Public Access 380
- Unknown Access 170
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10711 | 10711 | 10710 | {"type": "Polygon", "coordinates": [[[-117.22146, 33.82254], [-117.22143, 33.82281], [-117.22083, 33.82283], [-117.22084, 33.82245], [-117.21981, 33.8224], [-117.21975, 33.82263], [-117.21946, 33.82262], [-117.21943, 33.82277], [-117.21756, 33.82281], [-117.21749, 33.82274], [-117.21749, 33.81948], [-117.21758, 33.8194], [-117.21784, 33.81938], [-117.21788, 33.81979], [-117.21803, 33.81998], [-117.22078, 33.82232], [-117.22109, 33.82246], [-117.22146, 33.82254]]]} | Open Access 1 | 19869 | Paragon Park | 23409 | 1388 | Perris, City of 563 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | Riverside 10 | 15.394 | Paragon Park | 0 | Local Park 2 | 4 | |
10712 | 10712 | 10711 | {"type": "Polygon", "coordinates": [[[-117.2226, 33.80668], [-117.2226, 33.80688], [-117.22237, 33.80757], [-117.22235, 33.80829], [-117.22118, 33.80829], [-117.22116, 33.80616], [-117.22126, 33.80614], [-117.22129, 33.80604], [-117.22131, 33.80534], [-117.22174, 33.80533], [-117.22166, 33.8049], [-117.22196, 33.80489], [-117.22201, 33.80552], [-117.22209, 33.80563], [-117.22225, 33.80566], [-117.22231, 33.80668], [-117.2226, 33.80668]]]} | Open Access 1 | 19870 | Copper Creek Park | 17628 | 1388 | Perris, City of 563 | City 2 | City Agency 2 | http://cityofperris.org/residents/parks.html | City 2 | 1388 | Perris, City of 555 | City 2 | City Agency 2 | Riverside 10 | 8.861 | Copper Creek Park | 0 | Local Park 2 | 4 | |
10713 | 10713 | 10712 | {"type": "Polygon", "coordinates": [[[-117.39344, 33.69094], [-117.39311, 33.69099], [-117.39309, 33.69136], [-117.39312, 33.69339], [-117.39168, 33.69308], [-117.39162, 33.69302], [-117.39148, 33.69276], [-117.39126, 33.69278], [-117.39021, 33.69283], [-117.39021, 33.69131], [-117.3903, 33.69123], [-117.39046, 33.69122], [-117.39065, 33.69119], [-117.39135, 33.69095], [-117.39212, 33.69088], [-117.39237, 33.69083], [-117.39261, 33.69074], [-117.39301, 33.69048], [-117.39325, 33.6904], [-117.39331, 33.69043], [-117.39339, 33.69069], [-117.39344, 33.69094]]]} | Restricted Access 2 | 19872 | Summer Lake Park | 31649 | 2326 | Elsinore Unified School District 954 | Special District 4 | School District 14 | http://www.leusd.k12.ca.us/ | Special District 4 | 1389 | Lake Elsinore, City of 183 | City 2 | City Agency 2 | Riverside 10 | 15.756 | Summer Lake Park | 0 | Local Park 2 | 4 | |
10714 | 10714 | 10713 | {"type": "Polygon", "coordinates": [[[-117.39701, 33.69228], [-117.3969, 33.6926], [-117.39659, 33.69245], [-117.39638, 33.69233], [-117.39615, 33.69215], [-117.39512, 33.69124], [-117.39571, 33.69106], [-117.39701, 33.69228]]]} | Open Access 1 | 19873 | Oak Tree Park | 23011 | 1389 | Lake Elsinore, City of 187 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=202 | City 2 | 1389 | Lake Elsinore, City of 183 | City 2 | City Agency 2 | Riverside 10 | 2.484 | Oak Tree Park | 0 | Local Park 2 | 4 | |
10715 | 10715 | 10714 | {"type": "Polygon", "coordinates": [[[-117.37796, 33.68413], [-117.377, 33.68522], [-117.37602, 33.68457], [-117.37627, 33.68425], [-117.3764, 33.68423], [-117.37651, 33.68416], [-117.37655, 33.68405], [-117.37676, 33.68385], [-117.37693, 33.68398], [-117.37718, 33.6839], [-117.37729, 33.68369], [-117.37796, 33.68413]]]} | Restricted Access 2 | 19874 | Machado Park | 31594 | 2326 | Elsinore Unified School District 954 | Special District 4 | School District 14 | http://www.leusd.k12.ca.us/ | Special District 4 | 1389 | Lake Elsinore, City of 183 | City 2 | City Agency 2 | http://www.lake-elsinore.org/city-hall/city-departments/community-services/parks/machado-park#ad-image-0 | Riverside 10 | 3.781 | Machado Park | 0 | Local Park 2 | 4 |
10716 | 10716 | 10715 | {"type": "Polygon", "coordinates": [[[-117.28878, 33.68466], [-117.28861, 33.68481], [-117.28849, 33.68471], [-117.28839, 33.6848], [-117.28854, 33.68493], [-117.28848, 33.68499], [-117.28836, 33.68506], [-117.28824, 33.68511], [-117.28813, 33.68514], [-117.28798, 33.68515], [-117.28776, 33.68534], [-117.28775, 33.6855], [-117.2877, 33.68563], [-117.2876, 33.68575], [-117.28748, 33.68584], [-117.28733, 33.68572], [-117.28729, 33.68574], [-117.2866, 33.68518], [-117.28704, 33.68481], [-117.28736, 33.68435], [-117.28745, 33.68414], [-117.28754, 33.68409], [-117.28827, 33.68419], [-117.28827, 33.68423], [-117.28834, 33.68429], [-117.28838, 33.6843], [-117.28841, 33.68427], [-117.28868, 33.6845], [-117.28865, 33.68455], [-117.28878, 33.68466]]]} | Open Access 1 | 19878 | Tuscany Hills Park | 28283 | 1389 | Lake Elsinore, City of 187 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=202 | City 2 | 1389 | Lake Elsinore, City of 183 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=854 | Riverside 10 | 4.824 | Tuscany Hills Park | 0 | Local Park 2 | 4 |
10717 | 10717 | 10716 | {"type": "Polygon", "coordinates": [[[-117.16315, 32.99485], [-117.16297, 32.99529], [-117.16289, 32.99534], [-117.16284, 32.9953], [-117.16275, 32.99533], [-117.16269, 32.99528], [-117.16261, 32.99527], [-117.16256, 32.99529], [-117.16251, 32.99534], [-117.16245, 32.99535], [-117.16168, 32.99528], [-117.16105, 32.9951], [-117.16049, 32.99479], [-117.16037, 32.99469], [-117.16028, 32.99457], [-117.16055, 32.99446], [-117.16077, 32.99431], [-117.16315, 32.99485]]]} | Open Access 1 | 19881 | South Village Neighborhood Park | 30143 | 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.374 | South Village Neighborhood Park | 0 | Local Park 2 | 4 | |
10718 | 10718 | 10717 | {"type": "Polygon", "coordinates": [[[-117.23477, 32.93785], [-117.23476, 32.93799], [-117.23422, 32.93812], [-117.23383, 32.93828], [-117.23383, 32.93837], [-117.23388, 32.93848], [-117.23385, 32.93849], [-117.23368, 32.93829], [-117.23345, 32.93819], [-117.23341, 32.93822], [-117.23344, 32.93791], [-117.23348, 32.93788], [-117.23428, 32.93789], [-117.23477, 32.93785]]]} | Open Access 1 | 19887 | Carmel View Mini-Park | 30188 | 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.999 | Carmel View Mini-Park | 0 | Local Park 2 | 4 | |
10719 | 10719 | 10718 | {"type": "Polygon", "coordinates": [[[-117.21921, 32.94237], [-117.21921, 32.94288], [-117.2192, 32.94291], [-117.21879, 32.94304], [-117.21848, 32.94319], [-117.21804, 32.94352], [-117.21789, 32.94366], [-117.21774, 32.94385], [-117.2177, 32.94386], [-117.21765, 32.94383], [-117.21726, 32.94357], [-117.21699, 32.94343], [-117.2173, 32.94324], [-117.21789, 32.94294], [-117.2185, 32.94267], [-117.21885, 32.94251], [-117.21921, 32.94237]]]} | Open Access 1 | 19893 | Del Mar Trails Neighborhood Park | 30157 | 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 | 3.005 | Del Mar Trails Neighborhood Park | 0 | Local Park 2 | 4 | |
10720 | 10720 | 10719 | {"type": "Polygon", "coordinates": [[[-117.2458, 32.74505], [-117.24553, 32.74538], [-117.24519, 32.74518], [-117.2449, 32.74551], [-117.24457, 32.74531], [-117.24514, 32.74465], [-117.2458, 32.74505]]]} | Open Access 1 | 19909 | Ocean Beach Community Park | 30044 | 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 | 1.285 | Ocean Beach Community Park | 0 | Local Park 2 | 4 | |
10721 | 10721 | 10720 | {"type": "Polygon", "coordinates": [[[-117.08637, 32.74748], [-117.08588, 32.74812], [-117.08552, 32.74818], [-117.08531, 32.74818], [-117.0859, 32.74739], [-117.08612, 32.74746], [-117.08637, 32.74748]]]} | Open Access 1 | 19916 | Wightman Street Neighborhood Park | 30121 | 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.974 | Wightman Street Neighborhood Park | 0 | Local Park 2 | 4 | |
10722 | 10722 | 10721 | {"type": "Polygon", "coordinates": [[[-117.14353, 32.71085], [-117.14337, 32.71085], [-117.14337, 32.71057], [-117.14353, 32.71057], [-117.14353, 32.71085]]]} | Open Access 1 | 19927 | Sherman Mini-Park | 30102 | 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.117 | Sherman Mini-Park | 0 | Local Park 2 | 4 | |
10723 | 10723 | 10722 | {"type": "Polygon", "coordinates": [[[-117.14423, 32.70023], [-117.14395, 32.70053], [-117.14379, 32.70042], [-117.14379, 32.70021], [-117.14382, 32.70008], [-117.1439, 32.7], [-117.14423, 32.70023]]]} | Open Access 1 | 19928 | Chicano Park | 17188 | 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.351 | Chicano Park | 0 | Local Park 2 | 4 | |
10724 | 10724 | 10723 | {"type": "MultiPolygon", "coordinates": [[[[-117.11649, 32.70594], [-117.11649, 32.7063], [-117.11572, 32.70628], [-117.11532, 32.70631], [-117.11495, 32.70636], [-117.11458, 32.70643], [-117.11421, 32.70653], [-117.11385, 32.70665], [-117.11357, 32.70677], [-117.11306, 32.70703], [-117.11046, 32.70859], [-117.11008, 32.70877], [-117.10962, 32.70894], [-117.10841, 32.70544], [-117.10898, 32.70544], [-117.10905, 32.70531], [-117.10918, 32.70519], [-117.10936, 32.70513], [-117.10958, 32.70512], [-117.10958, 32.70489], [-117.11436, 32.70488], [-117.11437, 32.70556], [-117.11498, 32.70557], [-117.11548, 32.70616], [-117.11575, 32.70615], [-117.11601, 32.70611], [-117.11615, 32.70608], [-117.11649, 32.70594]]], [[[-117.11649, 32.70644], [-117.11649, 32.70802], [-117.11644, 32.70818], [-117.11643, 32.7084], [-117.11641, 32.71134], [-117.11635, 32.71139], [-117.11262, 32.71135], [-117.11043, 32.71131], [-117.10966, 32.70906], [-117.11006, 32.70892], [-117.11054, 32.7087], [-117.11314, 32.70714], [-117.1135, 32.70696], [-117.11387, 32.70679], [-117.1142, 32.70668], [-117.11451, 32.70659], [-117.1151, 32.70648], [-117.11575, 32.70643], [-117.11649, 32.70644]]]]} | Open Access 1 | 19929 | Mt Hope Cemetery | 22573 | 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 | 108.763 | Mt Hope Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
10725 | 10725 | 10724 | {"type": "Polygon", "coordinates": [[[-117.22285, 32.8178], [-117.22241, 32.81788], [-117.22193, 32.81697], [-117.22285, 32.8178], [-117.22285, 32.8178]]]} | Open Access 1 | 19900 | Clairemont Open Space | 17377 | 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.56 | Clairemont OS | 0 | Local Recreation Area 3 | 4 | |
10726 | 10726 | 10725 | {"type": "Polygon", "coordinates": [[[-117.0065, 32.80161], [-117.00639, 32.80178], [-117.00633, 32.8012], [-117.00624, 32.80076], [-117.00649, 32.80077], [-117.00651, 32.80139], [-117.00646, 32.80146], [-117.00644, 32.80152], [-117.00646, 32.80157], [-117.0065, 32.80161]]]} | Open Access 1 | 19904 | San Carlos Pocket Park | 24848 | 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.414 | San Carlos PP | 0 | Local Park 2 | 4 | |
10727 | 10727 | 10726 | {"type": "Polygon", "coordinates": [[[-117.12176, 33.51628], [-117.12161, 33.51668], [-117.12156, 33.51689], [-117.12153, 33.5171], [-117.12152, 33.51731], [-117.12153, 33.51752], [-117.12166, 33.51861], [-117.12166, 33.51883], [-117.1216, 33.51921], [-117.12154, 33.51939], [-117.12138, 33.51971], [-117.12105, 33.52013], [-117.12081, 33.52035], [-117.12045, 33.52058], [-117.12027, 33.51798], [-117.12028, 33.51762], [-117.12038, 33.51558], [-117.12172, 33.51621], [-117.12176, 33.51628]]]} | Open Access 1 | 19943 | Veterans Park | 27053 | 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 | 13.721 | Veterans Park | 0 | Local Park 2 | 4 | |
10728 | 10728 | 10727 | {"type": "Polygon", "coordinates": [[[-117.10272, 33.48405], [-117.10188, 33.48425], [-117.10114, 33.4824], [-117.10199, 33.48216], [-117.10272, 33.48405]]]} | Open Access 1 | 19944 | Paloma Del Sol | 23362 | 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 | 4.482 | Paloma Del Sol | None 939 | |||
10729 | 10729 | 10728 | {"type": "Polygon", "coordinates": [[[-117.1804, 33.56326], [-117.18038, 33.5638], [-117.17812, 33.56374], [-117.17802, 33.5637], [-117.17809, 33.56352], [-117.17634, 33.56183], [-117.17657, 33.56166], [-117.17692, 33.56134], [-117.17717, 33.56151], [-117.17741, 33.56171], [-117.1775, 33.56165], [-117.17861, 33.56269], [-117.1804, 33.56326]]]} | Open Access 1 | 19946 | Alta Murrieta Sports Park | 15418 | 1391 | Murrieta, City of 329 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | Riverside 10 | 9.771 | Alta Murrieta Sports Park | 0 | Local Recreation Area 3 | 4 | |
10730 | 10730 | 10729 | {"type": "Polygon", "coordinates": [[[-117.11883, 33.47183], [-117.11881, 33.47215], [-117.11854, 33.47215], [-117.11859, 33.47236], [-117.11831, 33.47245], [-117.11803, 33.47263], [-117.11786, 33.47257], [-117.11659, 33.47255], [-117.11712, 33.4707], [-117.11736, 33.47089], [-117.11786, 33.4712], [-117.11811, 33.47138], [-117.11835, 33.47165], [-117.11847, 33.47191], [-117.11877, 33.47183], [-117.11883, 33.47183]]]} | Open Access 1 | 19947 | Pala Community Park | 23324 | 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 | 6.204 | Pala Community 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]);