units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
38 rows where ACCESS_TYP = 1, AGNCY_TYP = 2 and YR_EST = 2000
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, DES_TP
MNG_AG_TYP 1
- City Agency 38
ACCESS_TYP 1
- Open Access · 38 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
302 | 302 | 301 | {"type": "Polygon", "coordinates": [[[-122.73498, 38.41334], [-122.73206, 38.41414], [-122.732, 38.41029], [-122.73412, 38.41036], [-122.73414, 38.41144], [-122.73498, 38.41334]]]} | Open Access 1 | 1039 | Southwest Community Park | 25702 | 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 | 19.939 | Southwest Community Park | 2000 | Local Park 2 | 4 | |
656 | 656 | 655 | {"type": "Polygon", "coordinates": [[[-122.01041, 38.35673], [-122.00892, 38.35725], [-122.00846, 38.35701], [-122.00814, 38.35671], [-122.00769, 38.35685], [-122.0075, 38.35677], [-122.00736, 38.35667], [-122.00728, 38.35618], [-122.00767, 38.35609], [-122.00751, 38.35562], [-122.00947, 38.35527], [-122.01041, 38.35673]]]} | Open Access 1 | 3220 | Alamo Creek Park | 15317 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 9.429 | Alamo Creek Park | 2000 | Local Park 2 | 4 | |
714 | 714 | 713 | {"type": "Polygon", "coordinates": [[[-122.43637, 37.77699], [-122.43332, 37.77738], [-122.43298, 37.7757], [-122.43603, 37.77532], [-122.43637, 37.77699]]]} | Open Access 1 | 4091 | Alamo Square | 15322 | 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 | 12.698 | Alamo Square | 2000 | Local Park 2 | 4 | |
1474 | 1474 | 1473 | {"type": "Polygon", "coordinates": [[[-122.63904, 38.22399], [-122.63784, 38.22593], [-122.63747, 38.22579], [-122.63737, 38.22594], [-122.63689, 38.22572], [-122.63666, 38.22609], [-122.63629, 38.22594], [-122.63779, 38.2235], [-122.63904, 38.22399]]]} | Open Access 1 | 10057 | McNear Park | 22061 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 8.003 | McNear Park | 2000 | Local Park 2 | 4 | |
1682 | 1682 | 1681 | {"type": "Polygon", "coordinates": [[[-122.0369, 37.58934], [-122.03679, 37.58946], [-122.03652, 37.5893], [-122.0365, 37.58926], [-122.03659, 37.58916], [-122.0369, 37.58934]]]} | Open Access 1 | 12695 | Heritage Oak Park | 19838 | 1362 | Union City, City of 365 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | Alameda 17 | 0.139 | Heritage Oak Park | 2000 | Local Park 2 | 4 | |
1811 | 1811 | 1810 | {"type": "Polygon", "coordinates": [[[-121.87893, 37.28067], [-121.87888, 37.28071], [-121.87872, 37.28064], [-121.87863, 37.28065], [-121.87791, 37.28092], [-121.87784, 37.28092], [-121.87762, 37.28056], [-121.87756, 37.28043], [-121.87735, 37.28009], [-121.87731, 37.27998], [-121.87714, 37.27971], [-121.87707, 37.27964], [-121.87688, 37.27961], [-121.87685, 37.27954], [-121.87753, 37.27925], [-121.87773, 37.27952], [-121.87841, 37.28024], [-121.87893, 37.28067]]]} | Open Access 1 | 13741 | Rubino Park | 24723 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 3.22 | Rubino Park | 2000 | Local Park 2 | 4 | |
1854 | 1854 | 1853 | {"type": "Polygon", "coordinates": [[[-121.95191, 37.35045], [-121.95084, 37.35083], [-121.95041, 37.35006], [-121.95102, 37.34985], [-121.95123, 37.35023], [-121.95169, 37.35007], [-121.95191, 37.35045]]]} | Open Access 1 | 14157 | Fremont Park | 19101 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 1.878 | Fremont Park | 2000 | Local Park 2 | 4 | |
1865 | 1865 | 1864 | {"type": "Polygon", "coordinates": [[[-122.18669, 37.44885], [-122.18632, 37.44929], [-122.18592, 37.44908], [-122.18628, 37.44864], [-122.18669, 37.44885]]]} | Open Access 1 | 14291 | Fremont Park | 19099 | 1202 | Menlo Park, City of 221 | City 2 | City Agency 2 | http://www.menlopark.org/ | City 2 | 1202 | Menlo Park, City of 217 | City 2 | City Agency 2 | San Mateo 15 | 0.623 | Fremont Park | 2000 | Local Park 2 | 4 | |
1895 | 1895 | 1894 | {"type": "Polygon", "coordinates": [[[-122.08727, 37.3596], [-122.08625, 37.35958], [-122.08624, 37.35771], [-122.08618, 37.35747], [-122.08608, 37.35729], [-122.08627, 37.35728], [-122.08635, 37.35738], [-122.08663, 37.35765], [-122.08692, 37.35782], [-122.08728, 37.3587], [-122.08734, 37.35889], [-122.08737, 37.35908], [-122.08736, 37.35928], [-122.08733, 37.35944], [-122.08727, 37.3596]]]} | Open Access 1 | 14591 | Heritage Oaks Park | 19840 | 1186 | Los Altos, City of 451 | City 2 | City Agency 2 | http://www.losaltosca.gov/parksites | City 2 | 1186 | Los Altos, City of 445 | City 2 | City Agency 2 | Santa Clara 19 | 4.684 | Heritage Oaks Park | 2000 | Local Park 2 | 4 | |
1902 | 1902 | 1901 | {"type": "Polygon", "coordinates": [[[-122.4742, 37.72523], [-122.47387, 37.72523], [-122.4735, 37.72527], [-122.47349, 37.72487], [-122.47322, 37.72486], [-122.47322, 37.7248], [-122.47411, 37.72426], [-122.47414, 37.72425], [-122.47416, 37.72427], [-122.47426, 37.72486], [-122.4742, 37.72523]]]} | Open Access 1 | 16307 | Junipero Serra Playground | 20533 | 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 | 1.545 | Junipero Serra Playground | 2000 | Local Recreation Area 3 | 4 | |
1968 | 1968 | 1967 | {"type": "Polygon", "coordinates": [[[-122.24109, 37.75354], [-122.2401, 37.75443], [-122.23818, 37.75321], [-122.2392, 37.7522], [-122.24109, 37.75354]]]} | Open Access 1 | 15123 | Krusi Park | 20727 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 7.492 | Krusi Park | 2000 | Local Park 2 | 4 | |
1998 | 1998 | 1997 | {"type": "Polygon", "coordinates": [[[-122.38615, 37.66234], [-122.38604, 37.66244], [-122.38546, 37.66259], [-122.38531, 37.66261], [-122.38516, 37.6626], [-122.38494, 37.66254], [-122.3848, 37.66246], [-122.38461, 37.6623], [-122.38449, 37.66216], [-122.38418, 37.66178], [-122.38419, 37.66176], [-122.38414, 37.66171], [-122.384, 37.66158], [-122.38383, 37.66146], [-122.3836, 37.66136], [-122.38332, 37.66129], [-122.38303, 37.66126], [-122.38275, 37.66129], [-122.38275, 37.66088], [-122.38533, 37.66089], [-122.38529, 37.66104], [-122.38525, 37.66105], [-122.38525, 37.66108], [-122.38539, 37.6611], [-122.38535, 37.6613], [-122.38537, 37.6614], [-122.3854, 37.6615], [-122.38549, 37.6615], [-122.38569, 37.66183], [-122.38595, 37.66219], [-122.38615, 37.66234]]]} | Open Access 1 | 15308 | Oyster Point Park | 23285 | 1341 | South San Francisco, City of 60 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | San Mateo 15 | 7.052 | Oyster Point Park | 2000 | Local Park 2 | 4 | |
2304 | 2304 | 2303 | {"type": "Polygon", "coordinates": [[[-121.81025, 37.29897], [-121.80953, 37.29949], [-121.80862, 37.29863], [-121.80923, 37.29804], [-121.81025, 37.29897]]]} | Open Access 1 | 16998 | Dovehill Park | 18251 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 2.74 | Dovehill Park | 2000 | Local Park 2 | 4 | |
2319 | 2319 | 2318 | {"type": "Polygon", "coordinates": [[[-121.8135, 37.98299], [-121.81214, 37.983], [-121.81196, 37.98264], [-121.81202, 37.98261], [-121.81187, 37.9813], [-121.81171, 37.98016], [-121.81189, 37.98005], [-121.81216, 37.97992], [-121.81257, 37.97994], [-121.81243, 37.9803], [-121.81247, 37.98053], [-121.81247, 37.98149], [-121.81255, 37.98215], [-121.81265, 37.98236], [-121.81281, 37.98254], [-121.813, 37.98269], [-121.8135, 37.98299]]]} | Open Access 1 | 17009 | Antioch | 15520 | 1007 | Antioch, City of 350 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | Contra Costa 12 | 5.226 | Antioch | 2000 | None 195 | ||
5048 | 5048 | 5047 | {"type": "Polygon", "coordinates": [[[-122.22637, 37.78087], [-122.226, 37.78126], [-122.22441, 37.78073], [-122.22462, 37.78033], [-122.22637, 37.78087]]]} | Open Access 1 | 13353 | Sanborn Park | 25005 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 1.969 | Sanborn Park | 2000 | Local Park 2 | 4 | |
5427 | 5427 | 5426 | {"type": "MultiPolygon", "coordinates": [[[[-122.44577, 37.77293], [-122.44108, 37.77352], [-122.44092, 37.77277], [-122.44562, 37.77218], [-122.44577, 37.77293]]], [[[-122.51084, 37.77123], [-122.51082, 37.77125], [-122.46524, 37.77333], [-122.46492, 37.77336], [-122.45479, 37.77465], [-122.45476, 37.77464], [-122.45474, 37.77462], [-122.45417, 37.77186], [-122.446, 37.7729], [-122.44585, 37.77215], [-122.45402, 37.77111], [-122.454, 37.7709], [-122.45398, 37.77089], [-122.45365, 37.76926], [-122.45362, 37.76924], [-122.45359, 37.76908], [-122.45361, 37.76905], [-122.45324, 37.7672], [-122.45358, 37.76716], [-122.45359, 37.76715], [-122.45351, 37.76675], [-122.45315, 37.76677], [-122.45308, 37.76646], [-122.45319, 37.76644], [-122.45323, 37.76659], [-122.454, 37.76656], [-122.45401, 37.76655], [-122.45397, 37.76634], [-122.45449, 37.76628], [-122.45455, 37.76654], [-122.45478, 37.76653], [-122.45473, 37.76625], [-122.45677, 37.76598], [-122.45701, 37.76598], [-122.45721, 37.76599], [-122.45745, 37.76603], [-122.45764, 37.76608], [-122.45768, 37.76644], [-122.45788, 37.76644], [-122.45859, 37.76637], [-122.46049, 37.76628], [-122.51017, 37.76409], [-122.51021, 37.7641], [-122.51024, 37.76413], [-122.51025, 37.7645], [-122.51017, 37.76568], [-122.51018, 37.76647], [-122.51024, 37.76719], [-122.5103, 37.76771], [-122.51033, 37.76774], [-122.51042, 37.76819], [-122.51042, 37.76835], [-122.51047, 37.7686], [-122.51052, 37.76864], [-122.51063, 37.76917], [-122.51078, 37.77029], [-122.51076, 37.77035], [-122.5107, 37.77037], [-122.51069, 37.77049], [-122.51077, 37.77052], [-122.5108, 37.77056], [-122.51083, 37.77082], [-122.5108, 37.77092], [-122.51084, 37.77123]], [[-122.45534, 37.76755], [-122.45501, 37.76749], [-122.45487, 37.76756], [-122.45487, 37.76808], [-122.45516, 37.76805], [-122.45565, 37.76794], [-122.45563, 37.76789], [-122.45534, 37.76755]], [[-122.4691, 37.7719], [-122.46926, 37.772], [-122.46979, 37.77162], [-122.46885, 37.77083], [-122.46791, 37.77153], [-122.4686, 37.7722], [-122.4691, 37.7719]]]]} | Open Access 1 | 16720 | Golden Gate Park | 10900 | 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 | http://sfrecpark.org/parks-open-spaces/golden-gate-park-guide/ | San Francisco 13 | 1022.15 | Golden Gate Park | 2000 | Local Park 2 | 4 |
6205 | 6205 | 6204 | {"type": "Polygon", "coordinates": [[[-122.04485, 37.87597], [-122.04472, 37.87736], [-122.04387, 37.87733], [-122.04101, 37.87676], [-122.04099, 37.87593], [-122.04031, 37.87511], [-122.03931, 37.87563], [-122.03914, 37.87627], [-122.03425, 37.87555], [-122.03426, 37.86945], [-122.03267, 37.86947], [-122.03165, 37.8692], [-122.03108, 37.8697], [-122.03024, 37.86962], [-122.02981, 37.86905], [-122.03238, 37.86704], [-122.03531, 37.86692], [-122.036, 37.86506], [-122.03714, 37.86599], [-122.03803, 37.86832], [-122.0388, 37.86827], [-122.04027, 37.87005], [-122.04246, 37.87304], [-122.04417, 37.87519], [-122.04485, 37.87597]]]} | Open Access 1 | 1250 | Sugarloaf Recreation Area | 25946 | 1371 | Walnut Creek, City of 178 | City 2 | City Agency 2 | http://www.ci.walnut-creek.ca.us/citygov/depts/ps/openspace/default.asp | City 2 | 1371 | Walnut Creek, City of 174 | City 2 | City Agency 2 | Contra Costa 12 | 184.864 | Sugarloaf Rec. Area | 2000 | Local Recreation Area 3 | 4 | |
6223 | 6223 | 6222 | {"type": "Polygon", "coordinates": [[[-122.02393, 37.41818], [-122.02261, 37.42199], [-122.01785, 37.42047], [-122.01632, 37.41996], [-122.01276, 37.41951], [-122.00326, 37.41817], [-122.0043, 37.41496], [-122.01127, 37.41639], [-122.01183, 37.41645], [-122.01294, 37.41646], [-122.01332, 37.41649], [-122.01368, 37.41655], [-122.01896, 37.41767], [-122.01995, 37.41793], [-122.02262, 37.41849], [-122.02296, 37.41851], [-122.02329, 37.41847], [-122.02361, 37.41837], [-122.02378, 37.41828], [-122.02393, 37.41818]], [[-122.01837, 37.41896], [-122.01837, 37.41895], [-122.01249, 37.41771], [-122.01239, 37.41778], [-122.01053, 37.41738], [-122.01043, 37.4175], [-122.0103, 37.41774], [-122.01011, 37.41841], [-122.01012, 37.41851], [-122.01025, 37.41859], [-122.01292, 37.41903], [-122.0176, 37.42006], [-122.01825, 37.41932], [-122.01837, 37.41896]]]} | Open Access 1 | 1283 | Sunnyvale Baylands Park | 29307 | 1345 | Sunnyvale, City of 419 | City 2 | City Agency 2 | http://sunnyvale.ca.gov/Departments/CommunityServices/Parks.aspx | City 2 | 1345 | Sunnyvale, City of 413 | City 2 | City Agency 2 | Santa Clara 19 | 124.234 | Sunnyvale Baylands Park | 2000 | Local Park 2 | 4 | |
6498 | 6498 | 6497 | {"type": "Polygon", "coordinates": [[[-121.91244, 37.72476], [-121.91228, 37.72487], [-121.91216, 37.725], [-121.91208, 37.72511], [-121.91207, 37.72511], [-121.91204, 37.72515], [-121.91199, 37.72517], [-121.91154, 37.72512], [-121.91121, 37.72513], [-121.91087, 37.72517], [-121.90977, 37.72536], [-121.90971, 37.72531], [-121.90964, 37.72491], [-121.90963, 37.72473], [-121.90964, 37.72424], [-121.90969, 37.72396], [-121.90972, 37.72393], [-121.90977, 37.72391], [-121.91003, 37.72393], [-121.91017, 37.72391], [-121.91081, 37.72373], [-121.91134, 37.72367], [-121.91145, 37.72364], [-121.91155, 37.72359], [-121.91245, 37.72467], [-121.91246, 37.72471], [-121.91244, 37.72476]]]} | Open Access 1 | 2370 | Alamo Creek Park | 32907 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | https://www.dublin.ca.gov/Facilities/Facility/Details/Alamo-Creek-Park-2 | Alameda 17 | 8.535 | Alamo Creek Park | 2000 | Local Park 2 | 4 |
6771 | 6771 | 6770 | {"type": "Polygon", "coordinates": [[[-122.41405, 37.6856], [-122.41385, 37.68597], [-122.41335, 37.6858], [-122.41311, 37.68574], [-122.4128, 37.68572], [-122.41253, 37.68575], [-122.41221, 37.68585], [-122.41195, 37.68598], [-122.41174, 37.68617], [-122.41156, 37.6864], [-122.41138, 37.68639], [-122.41125, 37.68641], [-122.41108, 37.68647], [-122.41095, 37.68655], [-122.41057, 37.68658], [-122.409, 37.6869], [-122.40866, 37.68693], [-122.40836, 37.68692], [-122.4079, 37.68686], [-122.40301, 37.68482], [-122.40459, 37.68481], [-122.40461, 37.68524], [-122.40773, 37.68643], [-122.40809, 37.68653], [-122.40843, 37.68657], [-122.4087, 37.68658], [-122.40909, 37.68654], [-122.40928, 37.6865], [-122.41017, 37.68624], [-122.4102, 37.68629], [-122.41125, 37.68592], [-122.41151, 37.68581], [-122.41208, 37.6855], [-122.41232, 37.68542], [-122.41254, 37.68536], [-122.41288, 37.68533], [-122.41318, 37.68535], [-122.41357, 37.68543], [-122.41405, 37.6856]]]} | Open Access 1 | 5235 | Old Quarry Rd. | 23099 | 1035 | Brisbane, City of 686 | City 2 | City Agency 2 | http://www.ci.brisbane.ca.us/about-parks-and-recreation | City 2 | 1035 | Brisbane, City of 677 | City 2 | City Agency 2 | San Mateo 15 | 9.686 | Old Quarry Rd. | 2000 | None 550 |
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]);