units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
49 rows where ACCESS_TYP = 3 and AGNCY_LEV = 3 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID, MNG_AG_LEV, PARK_URL, COUNTY, YR_EST
MNG_AGENCY 17
- San Diego, County of 13
- Santa Clara County Parks and Recreation Dept., County of 13
- Los Angeles, County of 5
- Napa, County of 3
- Monterey, County of 2
- Sonoma County Regional Parks Dept., County of 2
- Santa Barbara, County of 1
- San Mateo County Parks and Recreation Dept., County of 1
- East Bay Regional Park District 1
- Marin County Parks Department, County of 1
- Contra Costa Department of Conservation and Development, County of 1
- Los Angeles - Department of Parks and Recreation, County of 1
- Contra Costa County Public Works Dept., County of 1
- Midpeninsula Regional Open Space District 1
- Humboldt - Public Works Department, County of 1
- San Bernardino County Flood Control District 1
- Solano, County of 1
DES_TP 16
- Local Conservation Area 11
- Local Park 9
- Local Other or Unknown 8
- Local Resource Management Area 6
- Local Recreation Area 4
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 5
ACCESS_TYP 1
- No Public Access · 49 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4574 | 4574 | 4573 | {"type": "Polygon", "coordinates": [[[-120.41847, 34.87892], [-120.41847, 34.87914], [-120.41845, 34.87917], [-120.41794, 34.87923], [-120.41794, 34.87885], [-120.418, 34.87884], [-120.41807, 34.8788], [-120.41847, 34.87892]]]} | No Public Access 3 | 35227 | Unnamed site - Santa Barbara, County of | 28691 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 0.465 | 0 | Local Other or Unknown 14 | 4 | ||
8309 | 8309 | 8308 | {"type": "Polygon", "coordinates": [[[-118.60165, 34.05301], [-118.60165, 34.05347], [-118.60118, 34.05348], [-118.60118, 34.05301], [-118.60165, 34.05301]]]} | No Public Access 3 | 12776 | Los Angeles County Open Space | 21480 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 0.548 | Los Angeles County OS | 0 | Local Recreation Area 3 | 4 | |
15074 | 15074 | 15073 | {"type": "Polygon", "coordinates": [[[-118.11482, 34.19575], [-118.11463, 34.19638], [-118.11441, 34.19634], [-118.11429, 34.1954], [-118.11451, 34.19531], [-118.11449, 34.19545], [-118.11455, 34.19559], [-118.11466, 34.19569], [-118.11471, 34.19569], [-118.11482, 34.19575]]]} | No Public Access 3 | 45853 | Casa Del Caballero | 28900 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 0.819 | Casa Del Caballero | None 1306 | |||
4613 | 4613 | 4612 | {"type": "Polygon", "coordinates": [[[-118.63997, 34.08326], [-118.63997, 34.08356], [-118.63947, 34.08386], [-118.6392, 34.08385], [-118.63897, 34.08343], [-118.63935, 34.08326], [-118.63997, 34.08326]]]} | No Public Access 3 | 35763 | Unnamed site - Los Angeles County Waterworks | 30320 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 1.128 | 0 | Local Other or Unknown 14 | 4 | ||
3807 | 3807 | 3806 | {"type": "Polygon", "coordinates": [[[-122.056, 37.23144], [-122.05442, 37.23139], [-122.05437, 37.23056], [-122.0559, 37.23113], [-122.056, 37.23144]]]} | No Public Access 3 | 35126 | Sanborn County Park | 32833 | 326 | Santa Clara County Parks and Recreation Dept., County of 472 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | Santa Clara 19 | 2.136 | Sanborn County Park | 0 | Local Park 2 | 4 | |
565 | 565 | 564 | {"type": "Polygon", "coordinates": [[[-121.91485, 37.97467], [-121.91485, 37.97489], [-121.91456, 37.9751], [-121.91431, 37.97535], [-121.9141, 37.97553], [-121.91345, 37.97542], [-121.91287, 37.97544], [-121.91255, 37.97534], [-121.91197, 37.97514], [-121.91169, 37.9751], [-121.9116, 37.97515], [-121.91148, 37.97518], [-121.91136, 37.97514], [-121.91103, 37.97515], [-121.9109, 37.97496], [-121.91122, 37.97496], [-121.91189, 37.97489], [-121.91232, 37.9749], [-121.91233, 37.97492], [-121.91345, 37.97494], [-121.91408, 37.97484], [-121.91485, 37.97467]]]} | No Public Access 3 | 47528 | Alaimo | 31233 | 379 | Contra Costa Department of Conservation and Development, County of 209 | County 3 | County Agency - Other 9 | http://www.cccounty.us/dcd | County 3 | 379 | Contra Costa Department of Conservation and Development, County of 205 | County 3 | County Agency - Other 8 | Contra Costa 12 | 3.763 | Alaimo | None 56 | |||
9975 | 9975 | 9974 | {"type": "Polygon", "coordinates": [[[-122.11034, 37.25814], [-122.1099, 37.25831], [-122.10963, 37.25848], [-122.10956, 37.25855], [-122.10952, 37.25863], [-122.10951, 37.25873], [-122.10953, 37.25882], [-122.10846, 37.25883], [-122.10844, 37.25755], [-122.11032, 37.25756], [-122.11034, 37.25814]]]} | No Public Access 3 | 47967 | Saratoga Gap Open Space Preserve | 31468 | 373 | Santa Clara, County of 941 | County 3 | County Agency 3 | http://www.sccgov.org/sites/scc/Pages/default.aspx | County 3 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org/preserves/pr_saratoga_gap.asp | Santa Clara 19 | 4.827 | Saratoga Gap OSP | 2006 | Local Conservation Area 4 | 2 |
3686 | 3686 | 3685 | {"type": "MultiPolygon", "coordinates": [[[[-122.99454, 38.50132], [-122.9944, 38.50144], [-122.99344, 38.50067], [-122.99358, 38.50056], [-122.99371, 38.50033], [-122.99373, 38.50023], [-122.99371, 38.50022], [-122.99364, 38.50027], [-122.99335, 38.50004], [-122.99363, 38.49983], [-122.99398, 38.50045], [-122.99405, 38.50043], [-122.99454, 38.50132]]], [[[-122.99558, 38.50043], [-122.99523, 38.50073], [-122.99427, 38.50011], [-122.99378, 38.49925], [-122.99395, 38.49913], [-122.99426, 38.49941], [-122.9944, 38.49964], [-122.99464, 38.4997], [-122.99558, 38.49982], [-122.99558, 38.50043]]], [[[-122.99512, 38.50083], [-122.99466, 38.50122], [-122.99406, 38.50014], [-122.99415, 38.50021], [-122.99512, 38.50083]]]]} | No Public Access 3 | 29797 | Guerneville River Park | 19563 | 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 | 5.24 | Guerneville River Park | 0 | Local Park 2 | 4 | |
4300 | 4300 | 4299 | {"type": "Polygon", "coordinates": [[[-118.65766, 34.07478], [-118.65661, 34.07478], [-118.65657, 34.07158], [-118.65675, 34.0718], [-118.65699, 34.072], [-118.65748, 34.07234], [-118.65765, 34.0724], [-118.65766, 34.07478]]]} | No Public Access 3 | 48151 | Saddle Peak | 32682 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 7.314 | Saddle Peak | None 378 | |||
12744 | 12744 | 12743 | {"type": "Polygon", "coordinates": [[[-121.564, 37.08207], [-121.56143, 37.08298], [-121.56076, 37.08176], [-121.56333, 37.08085], [-121.564, 37.08207]]]} | No Public Access 3 | 29776 | Church and New Land Bank | 17248 | 326 | Santa Clara County Parks and Recreation Dept., County of 472 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | Santa Clara 19 | 9.122 | Church and New Land Bank | 0 | Local Resource Management Area 83 | 3 | |
4640 | 4640 | 4639 | {"type": "Polygon", "coordinates": [[[-121.76878, 36.88577], [-121.76854, 36.88632], [-121.76869, 36.88648], [-121.76648, 36.88819], [-121.76471, 36.88798], [-121.7647, 36.88784], [-121.76557, 36.88755], [-121.76873, 36.88508], [-121.76878, 36.88577]]]} | No Public Access 3 | 36489 | Unnamed site - Monterey, County of | 28701 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 10.195 | 0 | Local Other or Unknown 14 | 4 | ||
12743 | 12743 | 12742 | {"type": "Polygon", "coordinates": [[[-121.94151, 37.1288], [-121.93859, 37.12829], [-121.93843, 37.12655], [-121.93901, 37.12707], [-121.94033, 37.12712], [-121.94141, 37.12687], [-121.94151, 37.1288]]]} | No Public Access 3 | 29775 | Summit Road Land Bank | 25971 | 326 | Santa Clara County Parks and Recreation Dept., County of 472 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | Santa Clara 19 | 10.935 | Summit Road Land Bank | 0 | Local Resource Management Area 83 | 3 | |
12746 | 12746 | 12745 | {"type": "MultiPolygon", "coordinates": [[[[-121.73507, 37.03376], [-121.7349, 37.03377], [-121.73489, 37.03349], [-121.73506, 37.03349], [-121.73507, 37.03376]]], [[[-121.73712, 37.03757], [-121.73521, 37.03757], [-121.73515, 37.03406], [-121.73703, 37.03405], [-121.73712, 37.03757]]]]} | No Public Access 3 | 29777 | LaPoint Land Bank | 21018 | 326 | Santa Clara County Parks and Recreation Dept., County of 472 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | Santa Clara 19 | 16.403 | LaPoint Land Bank | 0 | Local Resource Management Area 83 | 3 | |
14553 | 14553 | 14552 | {"type": "Polygon", "coordinates": [[[-117.142, 33.36266], [-117.14183, 33.36576], [-117.13969, 33.36579], [-117.13986, 33.36259], [-117.142, 33.36266]]]} | No Public Access 3 | 45226 | Pala Mesa Mitigation Property | 29252 | 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 | 17.191 | Pala Mesa Mitigation Property | 0 | Local Other or Unknown 14 | 4 | |
15149 | 15149 | 15148 | {"type": "Polygon", "coordinates": [[[-117.22985, 33.12069], [-117.22559, 33.1207], [-117.22559, 33.12034], [-117.22632, 33.12033], [-117.2275, 33.11994], [-117.22846, 33.11978], [-117.22826, 33.11881], [-117.22822, 33.11871], [-117.2277, 33.11842], [-117.22665, 33.11804], [-117.22645, 33.11788], [-117.2261, 33.1179], [-117.22608, 33.1176], [-117.22604, 33.11748], [-117.22594, 33.11732], [-117.22574, 33.11714], [-117.22573, 33.11712], [-117.22574, 33.11708], [-117.22579, 33.11704], [-117.22666, 33.11703], [-117.22668, 33.11773], [-117.22982, 33.11772], [-117.22985, 33.12069]]]} | No Public Access 3 | 45992 | Diamond Trail | 29166 | 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.sandiegocounty.gov/content/dam/sdc/dpw/WATERSHED_PROTECTION_PROGRAM/Pacific%20Watersheds.pdf | San Diego 4 | 19.749 | Diamond Trail | 0 | Local Recreation Area 3 | 4 |
4918 | 4918 | 4917 | {"type": "Polygon", "coordinates": [[[-116.70363, 32.61525], [-116.70362, 32.61622], [-116.69898, 32.61612], [-116.69901, 32.6143], [-116.70262, 32.61442], [-116.70298, 32.61427], [-116.70332, 32.61396], [-116.70321, 32.61425], [-116.70363, 32.61525]]]} | No Public Access 3 | 5150 | MSCP Open Space Preserve Land | 22571 | 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 | 21.27 | MSCP OSP Land | 0 | Local Conservation Area 4 | 2 | |
13163 | 13163 | 13162 | {"type": "Polygon", "coordinates": [[[-122.00274, 37.90517], [-122.00231, 37.90516], [-122.00213, 37.90513], [-122.00195, 37.90508], [-122.0017, 37.90499], [-121.99863, 37.90492], [-121.9986, 37.90475], [-121.99682, 37.90477], [-121.99628, 37.90372], [-121.994, 37.90374], [-121.99403, 37.90335], [-121.99401, 37.90309], [-121.99395, 37.90283], [-121.99387, 37.90259], [-121.99375, 37.90235], [-121.9936, 37.90213], [-121.99346, 37.90195], [-121.99811, 37.90237], [-121.99812, 37.90236], [-121.99811, 37.90229], [-122.00015, 37.90249], [-122.0002, 37.90249], [-122.0002, 37.90255], [-122.00096, 37.90262], [-122.00103, 37.90334], [-122.00094, 37.90336], [-122.00101, 37.90354], [-122.00107, 37.90407], [-122.00116, 37.90431], [-122.00123, 37.90442], [-122.00141, 37.90462], [-122.00151, 37.90471], [-122.00176, 37.90486], [-122.0019, 37.90492], [-122.00219, 37.905], [-122.00235, 37.90503], [-122.00268, 37.90503], [-122.00274, 37.90517]]]} | No Public Access 3 | 35113 | Mount Diablo Gateway | 28139 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 38.137 | Mount Diablo Gateway | None 1142 | |||
15248 | 15248 | 15247 | {"type": "MultiPolygon", "coordinates": [[[[-117.82076, 34.50651], [-117.81973, 34.50699], [-117.81803, 34.50778], [-117.81802, 34.50641], [-117.81848, 34.50646], [-117.81894, 34.50649], [-117.82076, 34.50651]]], [[[-117.82283, 34.50772], [-117.82137, 34.5084], [-117.82128, 34.50829], [-117.82054, 34.50863], [-117.82054, 34.50864], [-117.82062, 34.50875], [-117.81915, 34.50943], [-117.81813, 34.50793], [-117.82116, 34.50651], [-117.82201, 34.50652], [-117.82283, 34.50772]]], [[[-117.82395, 34.50937], [-117.82028, 34.51109], [-117.81925, 34.50958], [-117.82071, 34.5089], [-117.8208, 34.50901], [-117.82121, 34.50882], [-117.82154, 34.50867], [-117.82147, 34.50855], [-117.82293, 34.50787], [-117.82395, 34.50937]]], [[[-117.82134, 34.50864], [-117.82087, 34.50885], [-117.82074, 34.50866], [-117.82121, 34.50845], [-117.82134, 34.50864]]], [[[-117.82342, 34.50815], [-117.82232, 34.50652], [-117.82232, 34.50652], [-117.82341, 34.50648], [-117.82342, 34.50815]]]]} | No Public Access 3 | 46291 | Shady Bend Park | 29584 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 42.987 | Shady Bend Park | 0 | Local Park 2 | 4 | |
13119 | 13119 | 13118 | {"type": "Polygon", "coordinates": [[[-117.03429, 34.05023], [-117.03428, 34.05205], [-117.02584, 34.05208], [-117.02582, 34.0496], [-117.0264, 34.04972], [-117.02709, 34.04997], [-117.0277, 34.04982], [-117.02836, 34.04976], [-117.02879, 34.04956], [-117.02917, 34.04944], [-117.02963, 34.04933], [-117.03007, 34.04927], [-117.03008, 34.04906], [-117.03226, 34.04903], [-117.03227, 34.05024], [-117.03429, 34.05023]]]} | No Public Access 3 | 35036 | Bryant St Detention Basin | 16460 | 318 | San Bernardino, County of 368 | County 3 | County Agency 3 | http://cms.sbcounty.gov/parks/Home.aspx | County 3 | 2131 | San Bernardino County Flood Control District 865 | Special District 4 | Flood District 9 | San Bernardino 22 | 51.946 | Bryant St Detention Basin | 0 | None 1138 | ||
4227 | 4227 | 4226 | {"type": "Polygon", "coordinates": [[[-122.40045, 37.34619], [-122.40067, 37.34684], [-122.40105, 37.3505], [-122.40014, 37.35661], [-122.39968, 37.35684], [-122.39925, 37.35665], [-122.39846, 37.35659], [-122.39805, 37.35668], [-122.39805, 37.35669], [-122.3983, 37.35727], [-122.39762, 37.35724], [-122.39754, 37.35599], [-122.39872, 37.35471], [-122.39938, 37.35358], [-122.39954, 37.35151], [-122.39785, 37.34917], [-122.39775, 37.34869], [-122.39816, 37.34885], [-122.39834, 37.34887], [-122.39847, 37.34885], [-122.39858, 37.3488], [-122.39867, 37.34873], [-122.39873, 37.34864], [-122.39876, 37.34851], [-122.39872, 37.34735], [-122.39877, 37.34718], [-122.3989, 37.34698], [-122.39893, 37.34689], [-122.39889, 37.34672], [-122.39882, 37.34654], [-122.39848, 37.34602], [-122.39837, 37.34593], [-122.39824, 37.34586], [-122.39809, 37.34583], [-122.39794, 37.34583], [-122.39832, 37.34564], [-122.40045, 37.34619]]]} | No Public Access 3 | 47809 | Tunitas Creek Beach | 31691 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | San Mateo 15 | 51.984 | Tunitas Creek Beach | 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]);