units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
33 rows where DES_TP = 2, MNG_AGENCY = 54 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency · 33 ✖
MNG_AGENCY 1
- Salinas, City of · 33 ✖
DES_TP 1
- Local Park · 33 ✖
ACCESS_TYP 1
- Open Access 33
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
139 | 139 | 138 | {"type": "Polygon", "coordinates": [[[-121.62037, 36.68583], [-121.61877, 36.68675], [-121.61779, 36.68563], [-121.61818, 36.68539], [-121.61827, 36.68538], [-121.61842, 36.6853], [-121.61842, 36.68528], [-121.61852, 36.68526], [-121.6186, 36.68529], [-121.61865, 36.68536], [-121.61874, 36.68537], [-121.61916, 36.68584], [-121.61999, 36.68539], [-121.62037, 36.68583]]]} | Open Access 1 | 442 | Sanborn Neighborhood Park | 25004 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 4.539 | Sanborn Neighborhood Park | 0 | Local Park 2 | 4 | |
188 | 188 | 187 | {"type": "Polygon", "coordinates": [[[-121.65097, 36.72554], [-121.65096, 36.72568], [-121.65085, 36.72602], [-121.6503, 36.72616], [-121.64992, 36.72621], [-121.64989, 36.7262], [-121.64984, 36.72593], [-121.64986, 36.72575], [-121.65001, 36.72574], [-121.65097, 36.72554]]]} | Open Access 1 | 603 | Santa Rita Park | 25125 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 1.227 | Santa Rita Park | 0 | Local Park 2 | 4 | |
263 | 263 | 262 | {"type": "Polygon", "coordinates": [[[-121.60427, 36.6889], [-121.60339, 36.68923], [-121.60329, 36.68903], [-121.60316, 36.68881], [-121.60301, 36.6886], [-121.60264, 36.68816], [-121.60264, 36.68811], [-121.60325, 36.68776], [-121.60427, 36.6889]]]} | Open Access 1 | 897 | Soberanes Park | 25586 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 2.722 | Soberanes Park | 0 | Local Park 2 | 4 | |
291 | 291 | 290 | {"type": "Polygon", "coordinates": [[[-121.65217, 36.69015], [-121.65159, 36.69783], [-121.64807, 36.6977], [-121.64676, 36.69741], [-121.64651, 36.69696], [-121.64646, 36.69678], [-121.64645, 36.6966], [-121.64683, 36.69195], [-121.6462, 36.69108], [-121.64785, 36.69036], [-121.64948, 36.69], [-121.6521, 36.69007], [-121.65215, 36.6901], [-121.65217, 36.69015]]]} | Open Access 1 | 790 | Sherwood Park | 25403 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 96.826 | Sherwood Park | 0 | Local Park 2 | 4 | |
832 | 832 | 831 | {"type": "Polygon", "coordinates": [[[-121.63752, 36.67956], [-121.63746, 36.67966], [-121.63621, 36.68089], [-121.63611, 36.68096], [-121.63597, 36.68103], [-121.6358, 36.68108], [-121.63508, 36.6812], [-121.63494, 36.68121], [-121.63422, 36.68115], [-121.63433, 36.68028], [-121.63237, 36.67947], [-121.63175, 36.67992], [-121.62945, 36.68037], [-121.62906, 36.68053], [-121.6288, 36.68027], [-121.6285, 36.68005], [-121.62853, 36.68001], [-121.62833, 36.67989], [-121.62875, 36.67962], [-121.62899, 36.67954], [-121.62933, 36.6792], [-121.6294, 36.67897], [-121.62938, 36.67876], [-121.62926, 36.67865], [-121.62909, 36.67845], [-121.62997, 36.67864], [-121.62997, 36.67868], [-121.63031, 36.67883], [-121.63081, 36.67887], [-121.6314, 36.67873], [-121.63142, 36.6787], [-121.63148, 36.67869], [-121.63156, 36.67813], [-121.63279, 36.6784], [-121.63486, 36.67951], [-121.63503, 36.67953], [-121.63501, 36.67958], [-121.63502, 36.67959], [-121.6353, 36.67964], [-121.63635, 36.67962], [-121.63752, 36.67956]]]} | Open Access 1 | 5409 | Cesar Chavez Community Park | 17092 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 27.823 | Cesar Chavez Community Park | 0 | Local Park 2 | 4 | |
1133 | 1133 | 1132 | {"type": "Polygon", "coordinates": [[[-121.6595, 36.67057], [-121.65909, 36.67063], [-121.659, 36.67022], [-121.65942, 36.67016], [-121.6595, 36.67057]]]} | Open Access 1 | 7220 | Clay Park | 17397 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 0.426 | Clay Park | 0 | Local Park 2 | 4 | |
1537 | 1537 | 1536 | {"type": "Polygon", "coordinates": [[[-121.61028, 36.70424], [-121.61018, 36.70453], [-121.60947, 36.70555], [-121.60894, 36.70532], [-121.60905, 36.70516], [-121.60966, 36.7045], [-121.6099, 36.70418], [-121.60995, 36.70416], [-121.61001, 36.70415], [-121.61028, 36.70424]]]} | Open Access 1 | 11239 | Creekbridge Neighborhood Park | 17766 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 1.816 | Creekbridge Neighborhood Park | 0 | Local Park 2 | 4 | |
2097 | 2097 | 2096 | {"type": "Polygon", "coordinates": [[[-121.66291, 36.69015], [-121.66181, 36.69081], [-121.66142, 36.69038], [-121.66121, 36.69018], [-121.66121, 36.69015], [-121.6614, 36.68998], [-121.66155, 36.68988], [-121.66171, 36.68979], [-121.662, 36.68969], [-121.66264, 36.68952], [-121.66291, 36.69015]]]} | Open Access 1 | 17310 | Laurelwood Park | 21107 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 2.965 | Laurelwood Park | 0 | Local Park 2 | 4 | |
2144 | 2144 | 2143 | {"type": "Polygon", "coordinates": [[[-121.60386, 36.69613], [-121.60384, 36.69617], [-121.60331, 36.69641], [-121.60294, 36.69588], [-121.6035, 36.69564], [-121.60386, 36.69613]]]} | Open Access 1 | 16008 | Frank Paul Park | 19052 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 0.954 | Frank Paul Park | 0 | Local Park 2 | 4 | |
2185 | 2185 | 2184 | {"type": "MultiPolygon", "coordinates": [[[[-121.64401, 36.71504], [-121.64376, 36.71505], [-121.64367, 36.71508], [-121.64363, 36.71504], [-121.64358, 36.71502], [-121.64348, 36.71502], [-121.64307, 36.71495], [-121.64395, 36.71501], [-121.64401, 36.71504]]], [[[-121.6477, 36.71315], [-121.64766, 36.71325], [-121.64736, 36.71317], [-121.64722, 36.71327], [-121.64687, 36.71315], [-121.64695, 36.71311], [-121.64699, 36.71305], [-121.64697, 36.71297], [-121.6469, 36.71292], [-121.64678, 36.71292], [-121.64636, 36.71277], [-121.64534, 36.71253], [-121.64479, 36.71243], [-121.64449, 36.71247], [-121.64427, 36.71265], [-121.64419, 36.71288], [-121.64422, 36.71238], [-121.64441, 36.71232], [-121.64509, 36.71243], [-121.64695, 36.71287], [-121.64766, 36.7131], [-121.64769, 36.71312], [-121.6477, 36.71315]]], [[[-121.65019, 36.71385], [-121.65015, 36.71397], [-121.64986, 36.7139], [-121.64982, 36.71385], [-121.64974, 36.71382], [-121.64966, 36.71382], [-121.64959, 36.71385], [-121.64923, 36.71377], [-121.64914, 36.7137], [-121.64884, 36.71364], [-121.6488, 36.7136], [-121.64874, 36.71357], [-121.64864, 36.71357], [-121.64831, 36.71342], [-121.64801, 36.71346], [-121.64782, 36.71338], [-121.64792, 36.71324], [-121.64797, 36.71322], [-121.64862, 36.71349], [-121.64912, 36.71365], [-121.64961, 36.71377], [-121.65019, 36.71385]]]]} | Open Access 1 | 16365 | Linear City Park | 30781 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 1.513 | Linear City Park | 0 | Local Park 2 | 4 | |
2249 | 2249 | 2248 | {"type": "Polygon", "coordinates": [[[-121.63963, 36.70341], [-121.63927, 36.704], [-121.63809, 36.70354], [-121.63834, 36.70311], [-121.63871, 36.70319], [-121.63875, 36.70324], [-121.6388, 36.70327], [-121.63887, 36.70327], [-121.63894, 36.70325], [-121.63963, 36.70341]]]} | Open Access 1 | 18077 | Natividad Park | 22664 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 1.809 | Natividad Park | 0 | Local Park 2 | 4 | |
2264 | 2264 | 2263 | {"type": "Polygon", "coordinates": [[[-121.62862, 36.71355], [-121.62822, 36.71371], [-121.62783, 36.71381], [-121.62801, 36.71296], [-121.62798, 36.71295], [-121.62804, 36.71268], [-121.62642, 36.71243], [-121.62639, 36.71236], [-121.6263, 36.71229], [-121.62629, 36.71227], [-121.62638, 36.71215], [-121.6265, 36.71194], [-121.62659, 36.71163], [-121.62844, 36.71192], [-121.62835, 36.71238], [-121.62839, 36.71258], [-121.62828, 36.71285], [-121.62862, 36.71355]]]} | Open Access 1 | 16746 | Harden Neighborhood Park | 19673 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 5.121 | Harden Neighborhood Park | 0 | Local Park 2 | 4 | |
2269 | 2269 | 2268 | {"type": "Polygon", "coordinates": [[[-121.67534, 36.66893], [-121.67465, 36.67012], [-121.6732, 36.66958], [-121.67441, 36.66858], [-121.67534, 36.66893]]]} | Open Access 1 | 16772 | Hartnell Park | 19713 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 4.223 | Hartnell Park | 0 | Local Park 2 | 4 | |
2420 | 2420 | 2419 | {"type": "Polygon", "coordinates": [[[-121.65771, 36.69962], [-121.65743, 36.69999], [-121.65723, 36.69997], [-121.65658, 36.70005], [-121.65635, 36.69887], [-121.65758, 36.69871], [-121.65771, 36.69962]]]} | Open Access 1 | 17301 | Laurel Park | 21101 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 3.488 | Laurel Park | 0 | Local Park 2 | 4 | |
2431 | 2431 | 2430 | {"type": "Polygon", "coordinates": [[[-121.63067, 36.68349], [-121.63015, 36.68362], [-121.62982, 36.68364], [-121.62891, 36.68323], [-121.62916, 36.68296], [-121.62944, 36.68275], [-121.6298, 36.68255], [-121.63, 36.68247], [-121.63014, 36.68243], [-121.63016, 36.68245], [-121.63038, 36.683], [-121.63039, 36.68312], [-121.63046, 36.68319], [-121.63057, 36.6832], [-121.63067, 36.68349]]]} | Open Access 1 | 17299 | Laurel Heights Park | 21095 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 2.965 | Laurel Heights Park | 0 | Local Park 2 | 4 | |
2532 | 2532 | 2531 | {"type": "Polygon", "coordinates": [[[-121.64403, 36.71378], [-121.64397, 36.71373], [-121.64282, 36.7136], [-121.64272, 36.71364], [-121.6426, 36.71362], [-121.64265, 36.71343], [-121.64273, 36.71297], [-121.64239, 36.71286], [-121.64241, 36.71261], [-121.64237, 36.71255], [-121.6423, 36.71251], [-121.64236, 36.71223], [-121.6433, 36.71223], [-121.64374, 36.71225], [-121.64398, 36.71238], [-121.64397, 36.71297], [-121.64403, 36.71378]]]} | Open Access 1 | 17745 | Mckinnon Park | 22052 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 5.066 | Mckinnon Park | 0 | Local Park 2 | 4 | |
2636 | 2636 | 2635 | {"type": "MultiPolygon", "coordinates": [[[[-121.61831, 36.69338], [-121.61761, 36.69403], [-121.61403, 36.69597], [-121.61392, 36.6958], [-121.61391, 36.69579], [-121.61567, 36.69485], [-121.6171, 36.69406], [-121.6173, 36.69392], [-121.61811, 36.69316], [-121.61831, 36.69338]]], [[[-121.61389, 36.69605], [-121.61398, 36.69617], [-121.61399, 36.69622], [-121.6138, 36.69664], [-121.61366, 36.69682], [-121.61354, 36.69691], [-121.61224, 36.69769], [-121.61221, 36.69772], [-121.61219, 36.69777], [-121.6122, 36.69782], [-121.61223, 36.69787], [-121.6123, 36.69794], [-121.61244, 36.69854], [-121.61242, 36.6986], [-121.61238, 36.69862], [-121.61191, 36.69877], [-121.61152, 36.69893], [-121.61115, 36.69912], [-121.6108, 36.69933], [-121.61052, 36.69953], [-121.61022, 36.69979], [-121.60994, 36.70006], [-121.60963, 36.70042], [-121.60958, 36.70045], [-121.60951, 36.70044], [-121.60933, 36.70036], [-121.60903, 36.70017], [-121.60877, 36.69998], [-121.6085, 36.69974], [-121.60807, 36.69925], [-121.60768, 36.69886], [-121.60741, 36.69864], [-121.60712, 36.69844], [-121.60678, 36.69815], [-121.60676, 36.69812], [-121.60678, 36.69805], [-121.60722, 36.69768], [-121.60742, 36.69757], [-121.60766, 36.69747], [-121.60782, 36.69743], [-121.60803, 36.69741], [-121.60909, 36.69738], [-121.60932, 36.69736], [-121.60954, 36.69732], [-121.6099, 36.69718], [-121.61026, 36.69698], [-121.61088, 36.69651], [-121.61103, 36.69634], [-121.61118, 36.69609], [-121.61144, 36.69619], [-121.61159, 36.69618], [-121.61213, 36.69674], [-121.61376, 36.69587], [-121.61389, 36.69605]]], [[[-121.60852, 36.70026], [-121.60793, 36.70025], [-121.60751, 36.70054], [-121.60689, 36.70069], [-121.6058, 36.70021], [-121.60548, 36.70024], [-121.60414, 36.70136], [-121.60335, 36.70226], [-121.60245, 36.70255], [-121.60136, 36.70126], [-121.60147, 36.70119], [-121.60192, 36.70118], [-121.60222, 36.70114], [-121.60278, 36.70129], [-121.60373, 36.70075], [-121.60391, 36.70048], [-121.60433, 36.70024], [-121.60516, 36.69869], [-121.60542, 36.69875], [-121.60555, 36.69875], [-121.60568, 36.69872], [-121.60581, 36.69868], [-121.60638, 36.69836], [-121.60646, 36.69837], [-121.60651, 36.69839], [-121.6068, 36.69865], [-121.60737, 36.69907], [-121.60763, 36.69932], [-121.60822, 36.7], [-121.60852, 36.70026]]]]} | Open Access 1 | 18074 | Natividad Creek Park | 22663 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 59.11 | Natividad Creek Park | 0 | Local Park 2 | 4 | |
2805 | 2805 | 2804 | {"type": "Polygon", "coordinates": [[[-121.65616, 36.72516], [-121.65615, 36.7258], [-121.65563, 36.7258], [-121.65567, 36.72576], [-121.65568, 36.72571], [-121.65567, 36.72566], [-121.65564, 36.72561], [-121.6556, 36.72559], [-121.65553, 36.72558], [-121.65543, 36.7256], [-121.65542, 36.72514], [-121.65612, 36.72513], [-121.65616, 36.72516]]]} | Open Access 1 | 938 | Soto Square Park | 25632 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 1.073 | Soto Square Park | 0 | Local Park 2 | 4 | |
2945 | 2945 | 2944 | {"type": "Polygon", "coordinates": [[[-121.59687, 36.69074], [-121.59638, 36.69086], [-121.59588, 36.69102], [-121.59556, 36.69116], [-121.59504, 36.69145], [-121.59498, 36.69144], [-121.59445, 36.69082], [-121.59625, 36.68982], [-121.59673, 36.69038], [-121.59687, 36.69074]]]} | Open Access 1 | 1901 | Williams Ranch Neighborhood Park | 27566 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 4.595 | Williams Ranch Neighborhood Park | 0 | Local Park 2 | 4 | |
5876 | 5876 | 5875 | {"type": "Polygon", "coordinates": [[[-121.66749, 36.67701], [-121.66553, 36.67727], [-121.6652, 36.67569], [-121.66716, 36.67543], [-121.66749, 36.67701]]]} | Open Access 1 | 261 | Salinas Central Park | 24797 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 7.777 | Salinas Central 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]);