units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
21 rows where ACCESS_TYP = 1 and AGNCY_NAME = 419
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 21 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1747 | 1747 | 1746 | {"type": "Polygon", "coordinates": [[[-122.05546, 37.35874], [-122.05515, 37.35873], [-122.05448, 37.35863], [-122.0527, 37.35862], [-122.0527, 37.35752], [-122.05534, 37.35707], [-122.0554, 37.35735], [-122.05545, 37.35777], [-122.05546, 37.35874]]]} | Open Access 1 | 15055 | De Anza Park | 17968 | 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 | 9.039 | De Anza Park | 1956 | Local Park 2 | 4 | |
1959 | 1959 | 1958 | {"type": "Polygon", "coordinates": [[[-122.05845, 37.34912], [-122.05782, 37.34913], [-122.05737, 37.34959], [-122.0565, 37.34975], [-122.0565, 37.35032], [-122.05523, 37.35032], [-122.05518, 37.35031], [-122.05515, 37.35027], [-122.05515, 37.35022], [-122.05614, 37.35022], [-122.05615, 37.34851], [-122.05845, 37.34851], [-122.05845, 37.34912]]]} | Open Access 1 | 15061 | San Antonio Park | 24833 | 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 | 6.132 | San Antonio Park | 1983 | Local Park 2 | 4 | |
2430 | 2430 | 2429 | {"type": "Polygon", "coordinates": [[[-122.0394, 37.36418], [-122.03933, 37.36451], [-122.03932, 37.36533], [-122.03931, 37.36549], [-122.03922, 37.36571], [-122.03902, 37.36602], [-122.03894, 37.36619], [-122.0389, 37.36637], [-122.03888, 37.36663], [-122.03885, 37.36671], [-122.0387, 37.36671], [-122.03877, 37.36659], [-122.0387, 37.36649], [-122.03744, 37.36649], [-122.03725, 37.36638], [-122.03725, 37.36616], [-122.03711, 37.36609], [-122.03694, 37.36611], [-122.03692, 37.36449], [-122.03729, 37.36455], [-122.0373, 37.36454], [-122.03724, 37.36381], [-122.03701, 37.36361], [-122.03704, 37.3623], [-122.03858, 37.3623], [-122.03927, 37.36227], [-122.03927, 37.36335], [-122.03921, 37.36371], [-122.03907, 37.36409], [-122.03866, 37.36483], [-122.03899, 37.36496], [-122.03938, 37.36417], [-122.0394, 37.36418]]]} | Open Access 1 | 17298 | Las Palmas | 21058 | 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 | 21.499 | Las Palmas | 1965 | None 203 | ||
2732 | 2732 | 2731 | {"type": "Polygon", "coordinates": [[[-122.02779, 37.34303], [-122.02552, 37.34304], [-122.02544, 37.343], [-122.02535, 37.34299], [-122.02399, 37.34299], [-122.02391, 37.343], [-122.0238, 37.34305], [-122.02333, 37.34305], [-122.02333, 37.34134], [-122.02391, 37.3413], [-122.02779, 37.3413], [-122.02779, 37.34303]]]} | Open Access 1 | 18370 | Ortega Park | 23227 | 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 | 18.602 | Ortega Park | 1965 | Local Park 2 | 4 | |
3850 | 3850 | 3849 | {"type": "Polygon", "coordinates": [[[-122.04312, 37.34474], [-122.04168, 37.34475], [-122.04162, 37.34471], [-122.04161, 37.34172], [-122.04311, 37.34172], [-122.04312, 37.34474]]]} | Open Access 1 | 630 | Serra Park | 25315 | 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 | 11.044 | Serra Park | 1961 | Local Park 2 | 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 | |
6440 | 6440 | 6439 | {"type": "Polygon", "coordinates": [[[-122.04258, 37.37722], [-122.04247, 37.3776], [-122.04219, 37.37841], [-122.03848, 37.37762], [-122.0389, 37.37638], [-122.03953, 37.37651], [-122.03959, 37.37659], [-122.04258, 37.37722]]]} | Open Access 1 | 1970 | Washington Park | 27282 | 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 | 11.552 | Washington Park | 1945 | Local Park 2 | 4 | |
8057 | 8057 | 8056 | {"type": "MultiPolygon", "coordinates": [[[[-122.02706, 37.35718], [-122.02573, 37.35689], [-122.02573, 37.35683], [-122.02594, 37.35668], [-122.02591, 37.3566], [-122.02541, 37.35623], [-122.02527, 37.3563], [-122.02507, 37.35626], [-122.02488, 37.35607], [-122.02463, 37.35617], [-122.02461, 37.35623], [-122.02459, 37.3566], [-122.02424, 37.35662], [-122.02413, 37.3567], [-122.02403, 37.35669], [-122.0246, 37.35502], [-122.02464, 37.355], [-122.02469, 37.355], [-122.0275, 37.3556], [-122.02755, 37.35563], [-122.02756, 37.35569], [-122.02706, 37.35718]]], [[[-122.02713, 37.35787], [-122.02745, 37.35832], [-122.02753, 37.35849], [-122.02761, 37.35875], [-122.02762, 37.35884], [-122.0276, 37.35888], [-122.02754, 37.35892], [-122.02722, 37.35899], [-122.02692, 37.35907], [-122.02664, 37.35918], [-122.02638, 37.35931], [-122.02602, 37.35955], [-122.02581, 37.35973], [-122.02559, 37.35996], [-122.02551, 37.35997], [-122.02544, 37.35995], [-122.02431, 37.35901], [-122.02454, 37.35876], [-122.02474, 37.35877], [-122.02487, 37.35867], [-122.02505, 37.35883], [-122.02502, 37.35889], [-122.0251, 37.35896], [-122.02528, 37.35883], [-122.02521, 37.35875], [-122.02532, 37.35868], [-122.02527, 37.35861], [-122.02542, 37.35851], [-122.02551, 37.35857], [-122.0256, 37.35853], [-122.02567, 37.35855], [-122.02582, 37.3584], [-122.02573, 37.35831], [-122.02653, 37.35777], [-122.02687, 37.35806], [-122.02713, 37.35787]]]]} | Open Access 1 | 11831 | Heritage Park | 19857 | 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 | 18.818 | Heritage Park | 0 | Local Park 2 | 4 | |
8538 | 8538 | 8537 | {"type": "Polygon", "coordinates": [[[-122.02209, 37.39289], [-122.02121, 37.39553], [-122.02121, 37.39564], [-122.02125, 37.39572], [-122.02114, 37.39605], [-122.01914, 37.39562], [-122.01932, 37.3955], [-122.01936, 37.39536], [-122.0193, 37.39526], [-122.01933, 37.39512], [-122.01922, 37.39508], [-122.01936, 37.39468], [-122.02007, 37.39483], [-122.02037, 37.39391], [-122.02043, 37.3939], [-122.02074, 37.39298], [-122.02073, 37.39296], [-122.02023, 37.39286], [-122.02009, 37.39284], [-122.02004, 37.39286], [-122.01987, 37.39279], [-122.01983, 37.39272], [-122.01984, 37.39261], [-122.01991, 37.39243], [-122.02209, 37.39289]]]} | Open Access 1 | 13433 | Columbia Park | 17546 | 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 | 12.727 | Columbia Park | 1985 | Local Park 2 | 4 | |
9083 | 9083 | 9082 | {"type": "Polygon", "coordinates": [[[-122.04399, 37.39128], [-122.04368, 37.39222], [-122.04187, 37.39184], [-122.04218, 37.39091], [-122.04399, 37.39128]]]} | Open Access 1 | 15041 | Encinal Park | 18641 | 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 | 4.42 | Encinal Park | 1987 | Local Park 2 | 4 | |
9085 | 9085 | 9084 | {"type": "Polygon", "coordinates": [[[-122.02539, 37.39972], [-122.02523, 37.4002], [-122.02479, 37.40011], [-122.0247, 37.40036], [-122.02449, 37.40026], [-122.02416, 37.40008], [-122.02425, 37.39977], [-122.02218, 37.39932], [-122.02225, 37.39912], [-122.02471, 37.39965], [-122.02474, 37.39958], [-122.02539, 37.39972]]]} | Open Access 1 | 15044 | Orchard Gardens Park | 23187 | 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 | 2.597 | Orchard Gardens Park | 1955 | Local Park 2 | 4 | |
9089 | 9089 | 9088 | {"type": "Polygon", "coordinates": [[[-122.0267, 37.38263], [-122.02664, 37.38263], [-122.02657, 37.38284], [-122.02544, 37.3826], [-122.02543, 37.38261], [-122.02505, 37.38253], [-122.0251, 37.38238], [-122.02548, 37.38245], [-122.02551, 37.38233], [-122.02514, 37.38225], [-122.02519, 37.38212], [-122.02557, 37.38219], [-122.0256, 37.38206], [-122.02523, 37.38198], [-122.02528, 37.38185], [-122.02566, 37.38192], [-122.02578, 37.38154], [-122.02541, 37.38145], [-122.02554, 37.38109], [-122.0256, 37.38107], [-122.02651, 37.38125], [-122.02676, 37.38127], [-122.02702, 37.38126], [-122.0271, 37.3813], [-122.02711, 37.38136], [-122.0267, 37.38263]]]} | Open Access 1 | 15050 | Martin Murphy Jr. Park | 21922 | 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 | 5.413 | Martin Murphy Jr. Park | 1964 | Local Park 2 | 4 | |
9090 | 9090 | 9089 | {"type": "Polygon", "coordinates": [[[-122.03847, 37.37063], [-122.03889, 37.37071], [-122.03904, 37.37077], [-122.03911, 37.37084], [-122.03916, 37.37091], [-122.03923, 37.37111], [-122.03922, 37.37115], [-122.03918, 37.37118], [-122.03881, 37.37126], [-122.03784, 37.37171], [-122.03757, 37.37178], [-122.03729, 37.3718], [-122.03711, 37.37179], [-122.0364, 37.37164], [-122.03635, 37.37161], [-122.03635, 37.37158], [-122.03678, 37.37032], [-122.03682, 37.37029], [-122.03687, 37.37028], [-122.0375, 37.37042], [-122.03739, 37.37074], [-122.03752, 37.37084], [-122.03831, 37.37101], [-122.03833, 37.37101], [-122.03847, 37.37091], [-122.03849, 37.37077], [-122.03847, 37.37063]]]} | Open Access 1 | 15052 | Civic Center Park | 17365 | 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 | 5.83 | Civic Ctr. Park | 1961 | Local Park 2 | 4 | |
9092 | 9092 | 9091 | {"type": "Polygon", "coordinates": [[[-122.02106, 37.36325], [-122.02073, 37.36357], [-122.02061, 37.36384], [-122.02016, 37.36515], [-122.01939, 37.36508], [-122.01942, 37.36502], [-122.01941, 37.36495], [-122.01936, 37.3649], [-122.01929, 37.36489], [-122.01996, 37.36297], [-122.02056, 37.36311], [-122.02056, 37.36314], [-122.02106, 37.36325]]]} | Open Access 1 | 15067 | Braly Park | 16327 | 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 | 4.773 | Braly Park | 1965 | Local Park 2 | 4 | |
9093 | 9093 | 9092 | {"type": "Polygon", "coordinates": [[[-122.0192, 37.34862], [-122.01805, 37.34863], [-122.01804, 37.34683], [-122.01919, 37.34683], [-122.0192, 37.34862]]]} | Open Access 1 | 15070 | Panama Park | 23385 | 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 | 5.019 | Panama Park | 1984 | Local Park 2 | 4 | |
9094 | 9094 | 9093 | {"type": "Polygon", "coordinates": [[[-122.00808, 37.34344], [-122.0081, 37.34408], [-122.00808, 37.34412], [-122.00791, 37.34412], [-122.00786, 37.34408], [-122.00753, 37.34409], [-122.00748, 37.34407], [-122.00745, 37.34403], [-122.00689, 37.34404], [-122.0069, 37.34454], [-122.00687, 37.34455], [-122.00688, 37.34494], [-122.00692, 37.34495], [-122.00693, 37.34533], [-122.006, 37.34538], [-122.00561, 37.34535], [-122.00554, 37.34532], [-122.00553, 37.34529], [-122.00544, 37.34271], [-122.00722, 37.34267], [-122.00723, 37.34298], [-122.0072, 37.34308], [-122.00722, 37.34345], [-122.00808, 37.34344]]]} | Open Access 1 | 15072 | Raynor Park | 24208 | 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 | 11.562 | Raynor Park | 1961 | Local Park 2 | 4 | |
9637 | 9637 | 9636 | {"type": "Polygon", "coordinates": [[[-122.01566, 37.38483], [-122.01565, 37.38485], [-122.01571, 37.38511], [-122.01572, 37.38539], [-122.01555, 37.38683], [-122.01548, 37.38711], [-122.01538, 37.38742], [-122.0132, 37.38696], [-122.01425, 37.38382], [-122.01464, 37.38392], [-122.01486, 37.38402], [-122.01507, 37.38414], [-122.01525, 37.38428], [-122.0154, 37.38444], [-122.01553, 37.38461], [-122.01566, 37.38483]]]} | Open Access 1 | 16266 | Fair Oaks Park | 18786 | 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 | 14.844 | Fair Oaks Park | 1956 | Local Park 2 | 4 | |
10019 | 10019 | 10018 | {"type": "Polygon", "coordinates": [[[-122.00293, 37.39667], [-122.00246, 37.3967], [-122.00231, 37.3969], [-122.00237, 37.39776], [-122.00214, 37.39785], [-122.00216, 37.39818], [-122.00119, 37.39819], [-122.00119, 37.39838], [-121.99922, 37.39844], [-121.99917, 37.3984], [-121.9992, 37.39835], [-121.99922, 37.39676], [-121.9993, 37.3965], [-122.00293, 37.39646], [-122.00293, 37.39667]]]} | Open Access 1 | 17276 | Lakewood Park | 20990 | 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 | 14.133 | Lakewood Park | 1962 | Local Park 2 | 4 | |
10576 | 10576 | 10575 | {"type": "Polygon", "coordinates": [[[-122.00712, 37.36303], [-122.00523, 37.36304], [-122.00516, 37.36302], [-122.00514, 37.36298], [-122.00514, 37.36131], [-122.00708, 37.3613], [-122.00712, 37.36303]]]} | Open Access 1 | 18832 | Ponderosa | 23884 | 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 | 8.269 | Ponderosa | 1965 | None 928 | ||
13970 | 13970 | 13969 | {"type": "Polygon", "coordinates": [[[-122.04145, 37.38351], [-122.0413, 37.38395], [-122.04108, 37.38384], [-122.0407, 37.38374], [-122.04064, 37.38368], [-122.04074, 37.38335], [-122.04145, 37.38351]]]} | Open Access 1 | 36637 | Sunnyvale holding 1 | 26015 | 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 | 0.711 | Sunnyvale holding 1 | 1987 | Local Other or Unknown 14 | 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]);