units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
167 rows where MNG_AGENCY = 87 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, COUNTY, GAP_STS
DES_TP 25
- Local Park 76
- Local Conservation Area 40
- Local Recreation Area 28
- Local Resource Management Area 2
- Local Historic or Cultural Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
AGNCY_WEB 19 ✖
- http://www.ebparks.org/ 123
- http://www.parks.ca.gov/ 10
- http://www.slc.ca.gov/ 10
- http://acfloodcontrol.org/ 4
- http://www.fremont.gov/316/Parks 3
- http://sfwater.org/ 2
- http://www.cityofmartinez.org/depts/recreation/parks/default.asp 2
- http://www.haywardrec.org/ 2
- http://alamedaca.gov/recreation 1
- http://www.ci.emeryville.ca.us/158/City-Parks 1
- http://www.ci.hayward.ca.us/ 1
- http://www.ci.lafayette.ca.us/index.aspx?page=87 1
- http://www.ci.pinole.ca.us/recreation/parks.html 1
- http://www.co.contra-costa.ca.us/227/Public-Works 1
- http://www.dmca.ca.gov/ 1
- http://www.portcosta.com/newsletter.htm 1
- http://www.portofoakland.com/ 1
- http://www.usace.army.mil/ 1
- http://www.usbr.gov/ 1
LAYER 7 ✖
ACCESS_TYP 3
- Open Access 101
- No Public Access 47
- Restricted Access 19
MNG_AG_TYP 1
MNG_AGENCY 1
- East Bay Regional Park District · 167 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11403 | 11403 | 11402 | {"type": "Polygon", "coordinates": [[[-122.26076, 37.8998], [-122.26076, 37.8998], [-122.2605, 37.89989], [-122.26062, 37.89973], [-122.26076, 37.8998]]]} | Open Access 1 | 23017 | Tilden Regional Park | 3324 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/tilden | Alameda 17 | 0.038 | Tilden RP | 1936 | Local Park 2 | 4 |
4940 | 4940 | 4939 | {"type": "Polygon", "coordinates": [[[-122.02404, 37.66917], [-122.02383, 37.66911], [-122.02395, 37.66891], [-122.02396, 37.66892], [-122.02404, 37.66917]]]} | Restricted Access 2 | 10715 | Chabot - Garin Trail Corridor | 17108 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 0.064 | Chabot - Garin Trail Corridor | 0 | Local Conservation Area 4 | 2 | |
13066 | 13066 | 13065 | {"type": "Polygon", "coordinates": [[[-121.74145, 37.61399], [-121.74132, 37.61413], [-121.74116, 37.61418], [-121.74067, 37.61426], [-121.74045, 37.61437], [-121.74047, 37.61426], [-121.74145, 37.61399]]]} | Open Access 1 | 34939 | Lake Del Valle SRA | 1594 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.parks.ca.gov/?page_id=537 | Alameda 17 | 0.204 | Lake Del Valle SRA | 2000 | None 1132 | |
6062 | 6062 | 6061 | {"type": "MultiPolygon", "coordinates": [[[[-122.20757, 37.85174], [-122.20746, 37.85172], [-122.20671, 37.85161], [-122.20702, 37.85157], [-122.20719, 37.85158], [-122.20729, 37.85161], [-122.20757, 37.85174]]], [[[-122.20889, 37.85194], [-122.20883, 37.85193], [-122.20798, 37.8518], [-122.20816, 37.85178], [-122.2088, 37.85167], [-122.20889, 37.85194]]]]} | Open Access 1 | 776 | Sibley Volcanic Regional Preserve | 3318 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/sibley | Alameda 17 | 0.39 | Sibley Volcanic RPr | 1936 | Local Conservation Area 4 | 2 |
2356 | 2356 | 2355 | {"type": "Polygon", "coordinates": [[[-121.7508, 38.02106], [-121.7506, 38.02106], [-121.75061, 38.02096], [-121.75065, 38.02095], [-121.75065, 38.01964], [-121.75066, 38.01963], [-121.75067, 38.01953], [-121.75076, 38.01953], [-121.75075, 38.02095], [-121.7508, 38.02096], [-121.7508, 38.02106]]]} | Open Access 1 | 17112 | Antioch Bridge Fishing Pier | 15522 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 0.397 | Antioch Bridge Fishing Pier | None 198 | |||
12616 | 12616 | 12615 | {"type": "Polygon", "coordinates": [[[-122.11236, 37.89111], [-122.11234, 37.89111], [-122.11224, 37.89126], [-122.11214, 37.89136], [-122.11187, 37.89146], [-122.11178, 37.89161], [-122.11167, 37.89192], [-122.11167, 37.89221], [-122.1114, 37.89225], [-122.11132, 37.89205], [-122.11155, 37.89177], [-122.11166, 37.89144], [-122.11195, 37.89118], [-122.1122, 37.89108], [-122.1122, 37.89103], [-122.11235, 37.89102], [-122.11236, 37.89111]]]} | Open Access 1 | 29415 | Briones/Las Trampas Trail | 16396 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 0.765 | Briones/Las Trampas Trail | 0 | Local Recreation Area 3 | 4 | |
16415 | 16415 | 16414 | {"type": "Polygon", "coordinates": [[[-122.16888, 37.8072], [-122.16832, 37.80721], [-122.16831, 37.80673], [-122.16805, 37.80673], [-122.16806, 37.80645], [-122.16886, 37.8061], [-122.16888, 37.8072]]]} | No Public Access 3 | 46996 | Redwood Regional Park | 30634 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 1.525 | Redwood RP | 1939 | Local Park 2 | 4 | |
13031 | 13031 | 13030 | {"type": "Polygon", "coordinates": [[[-122.13918, 37.62375], [-122.13543, 37.62377], [-122.13526, 37.62377], [-122.13581, 37.62359], [-122.13917, 37.62357], [-122.13918, 37.62375]]]} | Open Access 1 | 46961 | Hayward Regional Shoreline | 3268 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/hayward | Alameda 17 | 1.605 | Hayward Reg. Shoreline | 1980 | Local Park 2 | 4 |
14182 | 14182 | 14181 | {"type": "Polygon", "coordinates": [[[-122.3732, 37.97143], [-122.37282, 37.97158], [-122.37227, 37.97224], [-122.37225, 37.97251], [-122.37217, 37.97255], [-122.37148, 37.97255], [-122.37238, 37.97143], [-122.3732, 37.97143]]]} | No Public Access 3 | 43103 | North Richmond Wetlands | 22856 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 1.61 | North Richmond Wetlands | 0 | Local Conservation Area 4 | 2 | |
11330 | 11330 | 11329 | {"type": "Polygon", "coordinates": [[[-122.04279, 37.68931], [-122.04192, 37.68952], [-122.04197, 37.68984], [-122.0417, 37.68988], [-122.04139, 37.69003], [-122.04079, 37.69022], [-122.04109, 37.68972], [-122.04062, 37.6896], [-122.04169, 37.68901], [-122.04204, 37.68905], [-122.04279, 37.68931]]]} | Open Access 1 | 22054 | Palomares Ridge | 23369 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 2.611 | Palomares Ridge | None 996 | |||
13023 | 13023 | 13022 | {"type": "Polygon", "coordinates": [[[-122.1377, 37.6311], [-122.13721, 37.63171], [-122.13632, 37.63217], [-122.13453, 37.63218], [-122.1377, 37.6311]]]} | No Public Access 3 | 46960 | Hayward Regional Shoreline | 19761 | 1685 | Hayward, City of 1038 | City 2 | City Agency 2 | http://www.ci.hayward.ca.us/ | City 2 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/hayward | Alameda 17 | 2.662 | Hayward Reg. Shoreline | 1980 | Local Park 2 | 4 |
11508 | 11508 | 11507 | {"type": "Polygon", "coordinates": [[[-122.00857, 37.57719], [-122.00838, 37.57734], [-122.00814, 37.57765], [-122.00798, 37.57795], [-122.00791, 37.57818], [-122.00786, 37.57854], [-122.00788, 37.57885], [-122.00793, 37.5791], [-122.0079, 37.57918], [-122.00795, 37.57921], [-122.00802, 37.57938], [-122.00812, 37.57947], [-122.00685, 37.57917], [-122.00706, 37.57859], [-122.00718, 37.57861], [-122.00735, 37.57827], [-122.0076, 37.57793], [-122.00781, 37.57772], [-122.008, 37.57756], [-122.00857, 37.57719]]]} | Open Access 1 | 29555 | Quarry Lakes Regional Recreation Area | 30594 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 2.872 | Quarry Lakes Reg. Rec. Area | 2001 | Local Recreation Area 3 | 4 | |
3558 | 3558 | 3557 | {"type": "Polygon", "coordinates": [[[-122.34141, 37.899], [-122.33912, 37.89903], [-122.33911, 37.89846], [-122.3414, 37.89842], [-122.34141, 37.899]]]} | No Public Access 3 | 15364 | Brooks Island Regional Preserve | 31524 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 3.177 | Brooks Island RPr | 0 | Local Conservation Area 4 | 2 | |
576 | 576 | 575 | {"type": "Polygon", "coordinates": [[[-122.14526, 37.74311], [-122.14524, 37.74315], [-122.14492, 37.74341], [-122.14434, 37.74398], [-122.14423, 37.74406], [-122.1437, 37.7433], [-122.14342, 37.74306], [-122.14482, 37.7425], [-122.14526, 37.74311]]]} | Open Access 1 | 3448 | Poaks Headquarters | 23819 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 3.419 | Poaks Headquarters | None 57 | |||
10105 | 10105 | 10104 | {"type": "MultiPolygon", "coordinates": [[[[-121.97369, 37.93539], [-121.97365, 37.93544], [-121.96855, 37.93551], [-121.96867, 37.93545], [-121.97369, 37.93539]]], [[[-121.96826, 37.93546], [-121.96797, 37.93555], [-121.96726, 37.9357], [-121.96694, 37.93579], [-121.96664, 37.93591], [-121.96636, 37.93605], [-121.9661, 37.93622], [-121.96586, 37.93641], [-121.96569, 37.93657], [-121.96412, 37.93819], [-121.96404, 37.93818], [-121.96563, 37.93653], [-121.96585, 37.93633], [-121.9661, 37.93614], [-121.96637, 37.93598], [-121.96666, 37.93583], [-121.96696, 37.93572], [-121.96728, 37.93563], [-121.96782, 37.93553], [-121.96807, 37.93546], [-121.96826, 37.93546]]], [[[-121.96407, 37.93824], [-121.96335, 37.93918], [-121.96327, 37.9393], [-121.96312, 37.9396], [-121.96305, 37.93961], [-121.96316, 37.93934], [-121.96329, 37.93915], [-121.96399, 37.93823], [-121.96407, 37.93824]]], [[[-121.963, 37.93975], [-121.96304, 37.93978], [-121.96305, 37.93982], [-121.96283, 37.94043], [-121.96271, 37.94113], [-121.96265, 37.94118], [-121.96266, 37.94099], [-121.96275, 37.9405], [-121.96283, 37.9402], [-121.963, 37.93975]]], [[[-121.967, 37.94522], [-121.96692, 37.94523], [-121.96688, 37.94515], [-121.96663, 37.94479], [-121.96609, 37.94436], [-121.96423, 37.94346], [-121.96463, 37.94293], [-121.96447, 37.94288], [-121.96422, 37.94261], [-121.9641, 37.94241], [-121.96396, 37.94225], [-121.96369, 37.94199], [-121.96305, 37.94148], [-121.96287, 37.94147], [-121.9629, 37.94142], [-121.96307, 37.94142], [-121.96377, 37.94198], [-121.96401, 37.94221], [-121.96416, 37.94238], [-121.96429, 37.94259], [-121.96452, 37.94283], [-121.96475, 37.9429], [-121.96435, 37.94345], [-121.96617, 37.94432], [-121.96669, 37.94476], [-121.96695, 37.94513], [-121.967, 37.94522]]], [[[-121.96761, 37.94557], [-121.96754, 37.94563], [-121.96714, 37.94565], [-121.96699, 37.94536], [-121.96707, 37.94535], [-121.9672, 37.94559], [-121.96761, 37.94557]]], [[[-122.08253, 37.97602], [-122.08247, 37.97608], [-122.08181, 37.97609], [-122.08181, 37.97604], [-122.08253, 37.97602]]], [[[-122.08523, 37.97718], [-122.08516, 37.97722], [-122.08511, 37.97722], [-122.08497, 37.97714], [-122.08485, 37.9771], [-122.08446, 37.97706], [-122.08405, 37.97641], [-122.08396, 37.97618], [-122.08386, 37.97606], [-122.08269, 37.97608], [-122.08276, 37.97602], [-122.08396, 37.976], [-122.08396, 37.97605], [-122.08403, 37.97614], [-122.08409, 37.97627], [-122.08413, 37.97639], [-122.08447, 37.97693], [-122.08458, 37.977], [-122.08484, 37.97704], [-122.08507, 37.97712], [-122.08514, 37.97711], [-122.08523, 37.97718]]]]} | Open Access 1 | 49044 | California Riding and Hiking Trail | 33750 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | https://www.ebparks.org/parks/trails/california/default.htm | Contra Costa 12 | 3.625 | California Riding and Hiking Trail | 1982 | Local Recreation Area 3 | 4 |
9237 | 9237 | 9236 | {"type": "Polygon", "coordinates": [[[-121.71401, 38.0024], [-121.71401, 38.00331], [-121.71393, 38.00334], [-121.7134, 38.00283], [-121.71283, 38.00253], [-121.71206, 38.00177], [-121.71201, 38.00107], [-121.71333, 38.00191], [-121.71401, 38.0024]]]} | Open Access 1 | 15373 | Big Break Regional Trail | 16075 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 4.138 | Big Break Reg. Trail | 0 | Local Recreation Area 3 | 4 | |
3646 | 3646 | 3645 | {"type": "Polygon", "coordinates": [[[-122.09719, 37.88699], [-122.0967, 37.88654], [-122.09593, 37.88668], [-122.09517, 37.88629], [-122.09471, 37.88637], [-122.09407, 37.88659], [-122.09356, 37.88625], [-122.09322, 37.88618], [-122.0933, 37.88612], [-122.0934, 37.8861], [-122.09615, 37.88602], [-122.09669, 37.88602], [-122.09723, 37.88606], [-122.09727, 37.88609], [-122.09728, 37.88613], [-122.09719, 37.88664], [-122.09719, 37.88699]]]} | Open Access 1 | 29549 | Lafayette/Moraga Trail | 20836 | 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 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 4.276 | Lafayette/Moraga Trail | 0 | Local Recreation Area 3 | 4 | |
3624 | 3624 | 3623 | {"type": "Polygon", "coordinates": [[[-121.70748, 37.99957], [-121.7053, 37.99809], [-121.70531, 37.9979], [-121.70746, 37.99794], [-121.70748, 37.99957]]]} | Open Access 1 | 29411 | BB Delta Shoreline Trail | 15905 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 4.739 | BB Delta Shoreline Trail | 0 | Local Recreation Area 3 | 4 | |
12258 | 12258 | 12257 | {"type": "Polygon", "coordinates": [[[-122.29218, 38.01568], [-122.29031, 38.01802], [-122.28912, 38.01718], [-122.28922, 38.01688], [-122.28938, 38.0167], [-122.28977, 38.01698], [-122.29009, 38.01702], [-122.29019, 38.01671], [-122.2906, 38.0165], [-122.2905, 38.01637], [-122.29193, 38.01586], [-122.29218, 38.01568]]]} | Open Access 1 | 25796 | San Pablo Bay Regional Shoreline | 24965 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 5.337 | San Pablo Bay Reg. Shoreline | 0 | Local Park 2 | 4 | |
1218 | 1218 | 1217 | {"type": "MultiPolygon", "coordinates": [[[[-122.1451, 37.64851], [-122.14511, 37.64897], [-122.14509, 37.64903], [-122.14501, 37.64917], [-122.14486, 37.64934], [-122.14456, 37.64957], [-122.14429, 37.64973], [-122.14412, 37.64979], [-122.14409, 37.64745], [-122.14507, 37.64744], [-122.1451, 37.64851]]], [[[-122.14586, 37.6471], [-122.14517, 37.64711], [-122.14517, 37.64682], [-122.14586, 37.64682], [-122.14586, 37.6471]]]]} | Open Access 1 | 8671 | Hayward Shoreline | 19762 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 5.421 | Hayward Shoreline | 1977 | 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]);