units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by PARK_URL
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
MNG_AG_TYP >30
- City Agency 9,392
- County Agency 1,131
- Recreation/Parks District 1,113
- State Agency 1,112
- Non Profit - Land Trust 568
- Federal Agency 498
- Open Space District 405
- Water District 232
- County Agency - Parks 228
- Community Services District 195
- Home Owners Association 192
- Non Profit - Conservation 146
- Flood District 100
- Irrigation District 47
- Non Profit - Other 45
- Cemetery District 44
- School District 38
- Port/Harbor District 33
- County Agency - Other 30
- Commercial 15
- Special District - Other 15
- Sanitation District 9
- Joint Powers Authority 9
- Other 6
- Non Profit - Cemetery District 5
- Conservation District 5
- Transportation Agency 5
- Mitigation Bank 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
DES_TP >30
- Local Park 8,317
- Local Recreation Area 1,872
- Local Other or Unknown 1,159
- Private Conservation 597
- Local Conservation Area 459
- State Conservation Area 375
- Private Recreation or Education 255
- State Park 208
- State Resource Management Area 154
- State Recreation Area 141
- National Forest 97
- Local Historic or Cultural Area 90
- National Wildlife Refuge 73
- National Public Lands 71
- State Other or Unknown 69
- State Historic or Cultural Area 63
- Recreation Management Area 56
- Private Other or Unknown 51
- National Recreation Area 38
- National Monument or Landmark 38
- National Park 26
- Resource Management Area 24
- Local Resource Management Area 23
- Federal Other or Unknown 23
- Conservation Area 14
- Private Agricultural 12
- Area of Critical Environmental Concern 7
- Wilderness Area 6
- Historic or Cultural Area 5
- Private Historic or Cultural 4
- …
ACCESS_TYP 4
- Open Access 13,188
- Restricted Access 1,145
- No Public Access 924
- Unknown Access 374
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1690 | 1690 | 1689 | {"type": "Polygon", "coordinates": [[[-117.7695, 33.643], [-117.76969, 33.64291], [-117.76988, 33.64273], [-117.76992, 33.64272], [-117.77034, 33.64285], [-117.77072, 33.64291], [-117.77074, 33.64293], [-117.77074, 33.643], [-117.77069, 33.64363], [-117.77064, 33.64366], [-117.77029, 33.6436], [-117.76995, 33.64358], [-117.76969, 33.64352], [-117.76952, 33.64344], [-117.76934, 33.6433], [-117.76928, 33.64323], [-117.76922, 33.64313], [-117.76924, 33.64307], [-117.7694, 33.64301], [-117.76944, 33.64307], [-117.7695, 33.64305], [-117.76951, 33.64304], [-117.7695, 33.643]]]} | Restricted Access 2 | 12733 | Valley View Park | 26809 | 6019 | Quail Hill Community Association 408 | Private 7 | Home Owners Association 16 | http://www.quailhillhoa.org/ | Private 14 | 6019 | Quail Hill Community Association 402 | Private 7 | Home Owners Association 15 | Orange 3 | 2.461 | Valley View Park | 0 | Private Recreation or Education 65 | 4 | |
1691 | 1691 | 1690 | {"type": "Polygon", "coordinates": [[[-118.80576, 34.14426], [-118.8047, 34.14528], [-118.80453, 34.14521], [-118.80449, 34.14517], [-118.80449, 34.14512], [-118.80453, 34.14505], [-118.80458, 34.14491], [-118.8046, 34.14475], [-118.80459, 34.14458], [-118.80453, 34.14442], [-118.80447, 34.14433], [-118.80433, 34.14417], [-118.80363, 34.14356], [-118.80351, 34.14348], [-118.80339, 34.14343], [-118.8035, 34.1432], [-118.80331, 34.14264], [-118.80264, 34.14255], [-118.80005, 34.14275], [-118.79893, 34.14304], [-118.79865, 34.14331], [-118.7987, 34.14355], [-118.7982, 34.14363], [-118.79819, 34.14374], [-118.79827, 34.14399], [-118.79828, 34.1443], [-118.79819, 34.14431], [-118.7982, 34.14496], [-118.79803, 34.14496], [-118.79803, 34.14247], [-118.7992, 34.14145], [-118.80462, 34.14143], [-118.8045, 34.14253], [-118.8046, 34.14314], [-118.80376, 34.14324], [-118.80375, 34.14354], [-118.80397, 34.14383], [-118.80444, 34.14425], [-118.80498, 34.14465], [-118.80511, 34.14463], [-118.80562, 34.14413], [-118.80567, 34.14419], [-118.80576, 34.14426]]]} | Open Access 1 | 12745 | Westlake Village City Parkland | 27404 | 1377 | Westlake Village, City of 321 | City 2 | City Agency 2 | http://www.wlv.org/index.aspx?nid=194 | City 2 | 1377 | Westlake Village, City of 318 | City 2 | City Agency 2 | Los Angeles 6 | 24.679 | Westlake Village City Parkland | 2018 | Local Park 2 | 4 | |
1692 | 1692 | 1691 | {"type": "Polygon", "coordinates": [[[-117.78759, 33.68347], [-117.78758, 33.6835], [-117.78705, 33.68403], [-117.78624, 33.68348], [-117.78675, 33.68297], [-117.78688, 33.68301], [-117.78707, 33.68309], [-117.78757, 33.68342], [-117.78759, 33.68347]]]} | Restricted Access 2 | 12755 | Wildwood Park | 27526 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 1.939 | Wildwood Park | 0 | Private Recreation or Education 65 | 4 | |
1693 | 1693 | 1692 | {"type": "Polygon", "coordinates": [[[-122.49248, 37.63035], [-122.49247, 37.63053], [-122.49221, 37.63053], [-122.49218, 37.63034], [-122.49248, 37.63035]]]} | Open Access 1 | 14655 | Palmetto Mini Park | 23354 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 0.124 | Palmetto MP | 0 | Local Park 2 | 4 | |
1694 | 1694 | 1693 | {"type": "Polygon", "coordinates": [[[-117.78468, 33.69615], [-117.78458, 33.69625], [-117.78392, 33.6958], [-117.78367, 33.69605], [-117.78377, 33.69614], [-117.78375, 33.69616], [-117.78362, 33.6961], [-117.78338, 33.69634], [-117.78339, 33.69637], [-117.78313, 33.69662], [-117.78299, 33.6966], [-117.78294, 33.69647], [-117.7828, 33.6963], [-117.783, 33.69609], [-117.78292, 33.69602], [-117.78319, 33.69576], [-117.7832, 33.69571], [-117.78345, 33.69547], [-117.78334, 33.69537], [-117.78217, 33.69454], [-117.78198, 33.69449], [-117.78203, 33.69437], [-117.78209, 33.6943], [-117.78234, 33.69449], [-117.78233, 33.69452], [-117.78397, 33.69566], [-117.78408, 33.6956], [-117.7841, 33.69562], [-117.78403, 33.69572], [-117.78457, 33.6961], [-117.78463, 33.69609], [-117.78468, 33.69615]]]} | Open Access 1 | 12756 | Willows Park | 27594 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 2.596 | Willows Park | 0 | Local Park 2 | 4 | |
1696 | 1696 | 1695 | {"type": "Polygon", "coordinates": [[[-117.19226, 34.07018], [-117.19224, 34.07362], [-117.19126, 34.07361], [-117.19128, 34.07017], [-117.19226, 34.07018]]]} | Open Access 1 | 14716 | Texonia Park | 26274 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 8.528 | Texonia Park | 0 | Local Park 2 | 4 | |
1697 | 1697 | 1696 | {"type": "Polygon", "coordinates": [[[-122.04168, 37.53797], [-122.04001, 37.53932], [-122.03814, 37.53786], [-122.0383, 37.53775], [-122.03857, 37.53796], [-122.0392, 37.5381], [-122.03926, 37.53805], [-122.03939, 37.53805], [-122.03948, 37.538], [-122.03952, 37.53789], [-122.03956, 37.53785], [-122.04084, 37.53698], [-122.04089, 37.53697], [-122.04093, 37.53698], [-122.04107, 37.53716], [-122.0413, 37.53755], [-122.04141, 37.5377], [-122.04154, 37.53784], [-122.04168, 37.53797]]]} | Open Access 1 | 12774 | Mayhews Landing Park | 21977 | 1221 | Newark, City of 377 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | Alameda 17 | 8.356 | Mayhews Landing Park | 1973 | Local Park 2 | 4 | |
1698 | 1698 | 1697 | {"type": "Polygon", "coordinates": [[[-123.01441, 38.79804], [-123.01401, 38.79805], [-123.01398, 38.79765], [-123.01439, 38.79761], [-123.01441, 38.79804]]]} | Open Access 1 | 6968 | Tarman Park | 26190 | 1059 | Cloverdale, City of 410 | City 2 | City Agency 2 | http://www.cloverdale.net/index.aspx?nid=152 | City 2 | 1059 | Cloverdale, City of 404 | City 2 | City Agency 2 | Sonoma 16 | 0.409 | Tarman Park | 0 | Local Park 2 | 4 | |
1699 | 1699 | 1698 | {"type": "Polygon", "coordinates": [[[-122.08071, 37.59307], [-122.0796, 37.59322], [-122.07977, 37.59352], [-122.07935, 37.59373], [-122.07905, 37.59335], [-122.07908, 37.5932], [-122.07915, 37.59302], [-122.07949, 37.59264], [-122.08002, 37.5929], [-122.08024, 37.59296], [-122.08035, 37.59295], [-122.08046, 37.59291], [-122.08056, 37.59281], [-122.0806, 37.59269], [-122.08068, 37.59269], [-122.08071, 37.59307]]]} | Restricted Access 2 | 48918 | Liberty Park | 33640 | 6135 | Liberty Park Homeowners Association 411 | Private 7 | Home Owners Association 16 | https://libertyparkportal.com/ | Private 14 | 6135 | Liberty Park Homeowners Association 405 | Private 7 | Home Owners Association 15 | Alameda 17 | 1.864 | Liberty Park | 0 | Private Recreation or Education 65 | 4 | |
1700 | 1700 | 1699 | {"type": "Polygon", "coordinates": [[[-121.99256, 37.57229], [-121.99231, 37.57249], [-121.99224, 37.57281], [-121.99201, 37.5728], [-121.99171, 37.57283], [-121.99148, 37.5729], [-121.99125, 37.57302], [-121.991, 37.57276], [-121.99062, 37.57267], [-121.99116, 37.57122], [-121.99222, 37.57203], [-121.99212, 37.57212], [-121.99219, 37.57219], [-121.99231, 37.5721], [-121.99256, 37.57229]]]} | Open Access 1 | 12826 | Rancho Arroyo Park | 24127 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 4.47 | Rancho Arroyo Park | 0 | Local Park 2 | 4 | |
1701 | 1701 | 1700 | {"type": "Polygon", "coordinates": [[[-120.76629, 37.64793], [-120.76479, 37.64805], [-120.76487, 37.64844], [-120.76469, 37.64846], [-120.76456, 37.6479], [-120.76485, 37.64783], [-120.76507, 37.64773], [-120.76531, 37.64747], [-120.76603, 37.64714], [-120.76619, 37.64741], [-120.76629, 37.64793]]]} | Open Access 1 | 48919 | Goldmine Park | 33641 | 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 | 2.185 | Goldmine Park | 0 | Local Park 2 | 4 | |
1702 | 1702 | 1701 | {"type": "MultiPolygon", "coordinates": [[[[-118.10957, 33.99118], [-118.10841, 33.99393], [-118.10812, 33.99414], [-118.10776, 33.99428], [-118.10723, 33.99468], [-118.1056, 33.99616], [-118.1049, 33.99713], [-118.10463, 33.99726], [-118.10446, 33.99744], [-118.10439, 33.99781], [-118.104, 33.99834], [-118.10373, 33.99899], [-118.1034, 33.99955], [-118.09727, 34.00134], [-118.09715, 34.00171], [-118.09154, 33.99932], [-118.09273, 33.99735], [-118.09448, 33.99594], [-118.09703, 33.99726], [-118.09734, 33.99688], [-118.09773, 33.99673], [-118.09793, 33.99653], [-118.10047, 33.99561], [-118.10232, 33.9928], [-118.10204, 33.99241], [-118.10691, 33.99146], [-118.10957, 33.99118]]], [[[-118.10991, 33.9911], [-118.1069, 33.99141], [-118.102, 33.99238], [-118.10139, 33.99156], [-118.10665, 33.98858], [-118.10706, 33.9888], [-118.10745, 33.98908], [-118.10935, 33.99074], [-118.10962, 33.99093], [-118.10991, 33.9911]]]]} | No Public Access 3 | 6693 | Rio Hondo & Bike Trail | 24380 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 234.812 | Rio Hondo & Bike Trail | 0 | Local Recreation Area 3 | 4 | |
1703 | 1703 | 1702 | {"type": "MultiPolygon", "coordinates": [[[[-118.0454, 33.98641], [-118.0454, 33.98717], [-118.04443, 33.98717], [-118.04443, 33.9864], [-118.0454, 33.98641]]], [[[-118.04592, 33.9864], [-118.04592, 33.98717], [-118.04548, 33.98716], [-118.04548, 33.9864], [-118.04592, 33.9864]]], [[[-118.04752, 33.98641], [-118.04752, 33.98724], [-118.04609, 33.98725], [-118.0461, 33.98641], [-118.04752, 33.98641]]]]} | Open Access 1 | 6540 | Founders Memorial Park | 19019 | 1380 | Whittier, City of 291 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 5.781 | Founders Memorial Park | 0 | Local Park 2 | 4 | |
1704 | 1704 | 1703 | {"type": "MultiPolygon", "coordinates": [[[[-118.05718, 33.99178], [-118.05479, 33.99178], [-118.05477, 33.99], [-118.05543, 33.99001], [-118.05718, 33.99178]]], [[[-118.05829, 33.99261], [-118.05747, 33.99178], [-118.05572, 33.99], [-118.05744, 33.98999], [-118.05804, 33.99178], [-118.05829, 33.99261]]]]} | Open Access 1 | 6541 | Palm Park | 23346 | 1380 | Whittier, City of 291 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 12.607 | Palm Park | 0 | Local Park 2 | 4 | |
1705 | 1705 | 1704 | {"type": "Polygon", "coordinates": [[[-118.06777, 33.99672], [-118.06723, 33.99773], [-118.06591, 33.99683], [-118.06669, 33.996], [-118.06777, 33.99672]]]} | Open Access 1 | 6543 | Guirado Park | 19564 | 2125 | Rose Hills Memorial Park Association 412 | Special District 4 | Cemetery District 11 | http://www.rosehills.com/ | Special District 4 | 2125 | Rose Hills Memorial Park Association 406 | Special District 4 | Cemetery District 11 | Los Angeles 6 | 4.169 | Guirado Park | 0 | Local Park 2 | 4 | |
1706 | 1706 | 1705 | {"type": "Polygon", "coordinates": [[[-122.43198, 37.78028], [-122.43163, 37.78033], [-122.43159, 37.78009], [-122.43193, 37.78005], [-122.43198, 37.78028]]]} | Open Access 1 | 6538 | Fillmore & Turk St. Mini Park | 18898 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.203 | Fillmore & Turk St. MP | 0 | Local Park 2 | 4 | |
1707 | 1707 | 1706 | {"type": "Polygon", "coordinates": [[[-122.42707, 37.78105], [-122.42623, 37.78115], [-122.42616, 37.78084], [-122.42539, 37.78093], [-122.42538, 37.78094], [-122.42545, 37.78125], [-122.42402, 37.78144], [-122.42387, 37.78069], [-122.42692, 37.7803], [-122.42707, 37.78105]]]} | Open Access 1 | 6549 | Margaret S Hayward Playground | 21802 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 5.03 | Margaret S Hayward Playground | 0 | Local Recreation Area 3 | 4 | |
1708 | 1708 | 1707 | {"type": "Polygon", "coordinates": [[[-117.93744, 33.98131], [-117.93677, 33.98161], [-117.93629, 33.98086], [-117.93696, 33.98056], [-117.93744, 33.98131]]]} | No Public Access 3 | 6551 | Roland Area County Water District Land | 24569 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 1.632 | Roland Area County Water District Land | None 136 | |||
1709 | 1709 | 1708 | {"type": "Polygon", "coordinates": [[[-117.75671, 34.13628], [-117.7567, 34.1363], [-117.75036, 34.13633], [-117.75034, 34.13665], [-117.75035, 34.13666], [-117.75656, 34.13663], [-117.75559, 34.13883], [-117.75547, 34.13901], [-117.75533, 34.13918], [-117.75515, 34.13932], [-117.75367, 34.14035], [-117.75356, 34.14041], [-117.75326, 34.14053], [-117.75215, 34.14084], [-117.75214, 34.14092], [-117.75193, 34.14107], [-117.75169, 34.1413], [-117.75165, 34.14129], [-117.75133, 34.14113], [-117.75127, 34.14107], [-117.75121, 34.14102], [-117.7511, 34.141], [-117.7511, 34.14067], [-117.75024, 34.14008], [-117.75024, 34.13986], [-117.74992, 34.13986], [-117.74843, 34.13883], [-117.74818, 34.13785], [-117.7485, 34.13662], [-117.75064, 34.13454], [-117.75064, 34.13451], [-117.75208, 34.13314], [-117.75433, 34.13264], [-117.75616, 34.13503], [-117.75671, 34.13628]]]} | No Public Access 3 | 12846 | Live Oak Reservoir | 21375 | 2078 | Metropolitan Water District of Southern California 413 | Special District 4 | Water District 13 | http://www.mwdh2o.com/ | Special District 4 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 112.516 | Live Oak Reservoir | 0 | Local Recreation Area 3 | 4 | |
1710 | 1710 | 1709 | {"type": "Polygon", "coordinates": [[[-117.81403, 33.78168], [-117.81385, 33.78162], [-117.81382, 33.78165], [-117.81354, 33.78152], [-117.81321, 33.78128], [-117.81304, 33.78111], [-117.81288, 33.78085], [-117.81279, 33.78062], [-117.81401, 33.78061], [-117.81403, 33.78168]]]} | Open Access 1 | 12933 | La Veta Park | 20814 | 1233 | Orange, City of 306 | City 2 | City Agency 2 | http://www.cityoforange.org/ | City 2 | 1233 | Orange, City of 302 | City 2 | City Agency 2 | Orange 3 | 2.295 | La Veta 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]);