units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
13 rows where MNG_AG_TYP = 2 and UNIT_NAME = "Creekside Park"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3687 | 3687 | 3686 | {"type": "Polygon", "coordinates": [[[-122.36968, 40.5209], [-122.36968, 40.52095], [-122.36827, 40.52094], [-122.36701, 40.52065], [-122.36714, 40.52043], [-122.36721, 40.5204], [-122.36751, 40.52049], [-122.36768, 40.52053], [-122.36807, 40.52054], [-122.36807, 40.52084], [-122.36828, 40.52089], [-122.36968, 40.5209]]]} | Open Access 1 | 44422 | Creekside Park | 17778 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 0.88 | Creekside Park | 0 | Local Park 2 | 4 | |
5635 | 5635 | 5634 | {"type": "Polygon", "coordinates": [[[-122.66692, 38.43193], [-122.66671, 38.43182], [-122.66654, 38.43177], [-122.66633, 38.43194], [-122.66629, 38.43208], [-122.66588, 38.43202], [-122.66588, 38.432], [-122.66552, 38.43187], [-122.66457, 38.43138], [-122.66443, 38.43128], [-122.66431, 38.43116], [-122.66448, 38.43109], [-122.66447, 38.43084], [-122.66505, 38.43084], [-122.66505, 38.43086], [-122.66692, 38.43176], [-122.66692, 38.43193]]]} | Open Access 1 | 29790 | Creekside Park | 17780 | 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 | 3.518 | Creekside Park | 0 | Local Park 2 | 4 | |
6517 | 6517 | 6516 | {"type": "Polygon", "coordinates": [[[-121.71465, 37.92218], [-121.71415, 37.9226], [-121.714, 37.92308], [-121.71255, 37.92315], [-121.71247, 37.9229], [-121.71262, 37.92219], [-121.71315, 37.92159], [-121.71359, 37.92124], [-121.71414, 37.92094], [-121.71421, 37.92151], [-121.71441, 37.92186], [-121.71465, 37.92218]]]} | Open Access 1 | 2754 | Creekside Park | 17771 | 1034 | Brentwood, City of 351 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | Contra Costa 12 | 6.922 | Creekside Park | 0 | Local Park 2 | 4 | |
7523 | 7523 | 7522 | {"type": "MultiPolygon", "coordinates": [[[[-117.86715, 34.01984], [-117.86703, 34.01994], [-117.86627, 34.02028], [-117.86715, 34.01984], [-117.86715, 34.01984]]], [[[-117.86604, 34.02113], [-117.86601, 34.02133], [-117.86593, 34.02159], [-117.86592, 34.02183], [-117.86552, 34.0218], [-117.86541, 34.02137], [-117.86604, 34.02113]]], [[[-117.87012, 34.02608], [-117.86975, 34.02622], [-117.86972, 34.02607], [-117.86936, 34.0255], [-117.86913, 34.02532], [-117.86859, 34.02498], [-117.86845, 34.02495], [-117.86845, 34.02497], [-117.86853, 34.02498], [-117.86911, 34.02534], [-117.86934, 34.02552], [-117.86968, 34.02608], [-117.86971, 34.02621], [-117.86969, 34.02621], [-117.86965, 34.02618], [-117.86946, 34.02581], [-117.86935, 34.02565], [-117.86924, 34.02553], [-117.86898, 34.02531], [-117.86884, 34.02522], [-117.86866, 34.02513], [-117.86846, 34.02506], [-117.86815, 34.02498], [-117.8679, 34.02485], [-117.86781, 34.0248], [-117.86766, 34.02467], [-117.86746, 34.02444], [-117.86737, 34.02428], [-117.86641, 34.02209], [-117.86631, 34.02177], [-117.86628, 34.02151], [-117.8663, 34.02098], [-117.86625, 34.02076], [-117.8663, 34.02074], [-117.86621, 34.02052], [-117.86615, 34.02041], [-117.86616, 34.02035], [-117.86663, 34.02016], [-117.86701, 34.01998], [-117.86686, 34.02027], [-117.86681, 34.02041], [-117.86677, 34.02066], [-117.86678, 34.02086], [-117.86661, 34.0213], [-117.86658, 34.02149], [-117.86658, 34.02159], [-117.86661, 34.02173], [-117.86665, 34.02186], [-117.86673, 34.022], [-117.86684, 34.0226], [-117.86692, 34.02266], [-117.86709, 34.02265], [-117.86717, 34.02272], [-117.86717, 34.0228], [-117.86713, 34.02285], [-117.86709, 34.02297], [-117.86708, 34.02312], [-117.8671, 34.02321], [-117.86739, 34.02393], [-117.86781, 34.02431], [-117.86763, 34.02441], [-117.86761, 34.02445], [-117.86762, 34.02451], [-117.86776, 34.02465], [-117.8681, 34.02489], [-117.86833, 34.02494], [-117.86832, 34.02492], [-117.86812, 34.02488], [-117.86778, 34.02463], [-117.86764, 34.02448], [-117.86764, 34.02445], [-117.86766, 34.02443], [-117.86783, 34.02433], [-117.86783, 34.02429], [-117.86742, 34.02392], [-117.86711, 34.02312], [-117.86712, 34.02297], [-117.86715, 34.02288], [-117.8672, 34.0228], [-117.8672, 34.02273], [-117.86718, 34.02269], [-117.86711, 34.02264], [-117.86708, 34.02263], [-117.86696, 34.02264], [-117.86692, 34.02263], [-117.86688, 34.02259], [-117.86676, 34.02199], [-117.86668, 34.02186], [-117.86663, 34.02168], [-117.86661, 34.02154], [-117.86663, 34.02141], [-117.86666, 34.02127], [-117.86681, 34.02086], [-117.8668, 34.02066], [-117.86684, 34.02041], [-117.86705, 34.01996], [-117.86718, 34.01985], [-117.86757, 34.02064], [-117.86719, 34.02094], [-117.86715, 34.02114], [-117.86725, 34.02143], [-117.86718, 34.02156], [-117.86708, 34.02181], [-117.86707, 34.02204], [-117.86709, 34.02226], [-117.86714, 34.02237], [-117.86729, 34.02241], [-117.8676, 34.02241], [-117.86775, 34.02236], [-117.86787, 34.0226], [-117.86768, 34.02267], [-117.86755, 34.02303], [-117.8676, 34.02321], [-117.86755, 34.02324], [-117.86748, 34.02338], [-117.86748, 34.02348], [-117.86751, 34.02356], [-117.86759, 34.02369], [-117.8677, 34.02376], [-117.86796, 34.02382], [-117.86806, 34.02368], [-117.8681, 34.02355], [-117.86809, 34.02349], [-117.86803, 34.02342], [-117.86803, 34.02337], [-117.86806, 34.02332], [-117.86814, 34.02328], [-117.8682, 34.02328], [-117.86828, 34.02332], [-117.86856, 34.02329], [-117.86862, 34.02325], [-117.86864, 34.02322], [-117.86864, 34.02317], [-117.86836, 34.02248], [-117.86808, 34.02199], [-117.86803, 34.02196], [-117.86794, 34.02197], [-117.86778, 34.02203], [-117.86764, 34.02212], [-117.86756, 34.02212], [-117.8675, 34.02207], [-117.8675, 34.022], [-117.86753, 34.02196], [-117.86757, 34.02194], [-117.86778, 34.02193], [-117.8679, 34.02188], [-117.86794, 34.02185], [-117.86794, 34.02175], [-117.86777, 34.0214], [-117.86768, 34.0213], [-117.86758, 34.02123], [-117.86757, 34.0212], [-117.86757, 34.02117], [-117.8676, 34.02111], [-117.86763, 34.02109], [-117.86772, 34.02109], [-117.86778, 34.02114], [-117.8678, 34.02114], [-117.86803, 34.0216], [-117.86835, 34.02202], [-117.86869, 34.02249], [-117.86888, 34.02332], [-117.86873, 34.02328], [-117.86868, 34.02334], [-117.8686, 34.02338], [-117.86825, 34.02343], [-117.86822, 34.02346], [-117.86821, 34.02358], [-117.86815, 34.02372], [-117.86808, 34.02384], [-117.86807, 34.02391], [-117.86808, 34.02397], [-117.86813, 34.02404], [-117.86818, 34.02409], [-117.86824, 34.02412], [-117.86843, 34.02417], [-117.86891, 34.02355], [-117.86901, 34.02406], [-117.86906, 34.02514], [-117.86995, 34.02556], [-117.87012, 34.02608]]], [[[-117.87018, 34.02627], [-117.86985, 34.0264], [-117.86983, 34.0264], [-117.86984, 34.02638], [-117.87017, 34.02625], [-117.87018, 34.02627]]], [[[-117.88084, 34.0293], [-117.88082, 34.02933], [-117.88046, 34.02951], [-117.88028, 34.02958], [-117.88006, 34.02964], [-117.87962, 34.02972], [-117.8795, 34.02933], [-117.87903, 34.02946], [-117.87865, 34.02962], [-117.8782, 34.02969], [-117.8781, 34.0297], [-117.87764, 34.02963], [-117.8767, 34.02976], [-117.87682, 34.03014], [-117.87674, 34.03015], [-117.87664, 34.03021], [-117.87661, 34.03028], [-117.87661, 34.03038], [-117.87627, 34.03036], [-117.87621, 34.03104], [-117.87624, 34.03129], [-117.87618, 34.03148], [-117.87599, 34.03181], [-117.87592, 34.03204], [-117.87583, 34.03251], [-117.87584, 34.03309], [-117.87567, 34.03353], [-117.87554, 34.0338], [-117.87551, 34.03399], [-117.87558, 34.03419], [-117.87575, 34.03443], [-117.87591, 34.03512], [-117.87501, 34.03523], [-117.87496, 34.03519], [-117.87466, 34.03416], [-117.87463, 34.03397], [-117.87463, 34.03377], [-117.87465, 34.03361], [-117.87469, 34.03347], [-117.87479, 34.03323], [-117.87545, 34.03223], [-117.87553, 34.03208], [-117.87561, 34.03185], [-117.87566, 34.03154], [-117.87565, 34.03123], [-117.87557, 34.03093], [-117.87543, 34.03063], [-117.87523, 34.03037], [-117.87498, 34.03014], [-117.8748, 34.03002], [-117.87452, 34.02987], [-117.87416, 34.02975], [-117.87199, 34.02919], [-117.87162, 34.02904], [-117.87135, 34.02888], [-117.87111, 34.02869], [-117.87081, 34.02833], [-117.87052, 34.02778], [-117.8703, 34.02742], [-117.86985, 34.02656], [-117.86981, 34.02647], [-117.86981, 34.02642], [-117.86986, 34.02642], [-117.86993, 34.02652], [-117.87016, 34.02691], [-117.87034, 34.02726], [-117.87045, 34.0274], [-117.87047, 34.02738], [-117.87037, 34.02724], [-117.87019, 34.0269], [-117.86996, 34.02651], [-117.86988, 34.02642], [-117.87018, 34.0263], [-117.8702, 34.02632], [-117.87152, 34.0267], [-117.87138, 34.02698], [-117.87141, 34.02714], [-117.8716, 34.02729], [-117.87193, 34.02723], [-117.87199, 34.0274], [-117.87214, 34.02758], [-117.87186, 34.02799], [-117.872, 34.02817], [-117.87282, 34.02857], [-117.87311, 34.02863], [-117.87347, 34.02857], [-117.87368, 34.02857], [-117.87384, 34.0286], [-117.87437, 34.0289], [-117.87455, 34.02903], [-117.8755, 34.02935], [-117.87572, 34.02893], [-117.87578, 34.0289], [-117.87587, 34.02876], [-117.87656, 34.0281], [-117.87681, 34.02779], [-117.8769, 34.02764], [-117.87698, 34.02747], [-117.87705, 34.02724], [-117.87709, 34.02701], [-117.87713, 34.02691], [-117.87728, 34.0267], [-117.8773, 34.02668], [-117.87737, 34.02668], [-117.87877, 34.02742], [-117.87905, 34.02758], [-117.87948, 34.02788], [-117.87989, 34.02821], [-117.8802, 34.02852], [-117.88054, 34.02889], [-117.88084, 34.02926], [-117.88084, 34.0293]]]]} | Open Access 1 | 7061 | Creekside Park | 17781 | 1370 | Walnut, City of 317 | City 2 | City Agency 2 | http://www.ci.walnut.ca.us/general.asp?id=135 | City 2 | 1370 | Walnut, City of 314 | City 2 | City Agency 2 | Los Angeles 6 | 67.979 | Creekside Park | 0 | Local Park 2 | 4 | |
8877 | 8877 | 8876 | {"type": "Polygon", "coordinates": [[[-122.01681, 37.31623], [-122.0168, 37.31644], [-122.0164, 37.31668], [-122.01607, 37.31674], [-122.01577, 37.31726], [-122.01557, 37.31775], [-122.01363, 37.31777], [-122.01363, 37.31733], [-122.0137, 37.31732], [-122.01369, 37.31704], [-122.01379, 37.31703], [-122.01383, 37.31624], [-122.01498, 37.31627], [-122.01507, 37.31468], [-122.01624, 37.31472], [-122.0162, 37.31475], [-122.01625, 37.31503], [-122.01613, 37.31534], [-122.01612, 37.316], [-122.01639, 37.31618], [-122.01681, 37.31623]]]} | Open Access 1 | 14523 | Creekside Park | 17772 | 1076 | Cupertino, City of 195 | City 2 | City Agency 2 | http://www.cupertino.org/index.aspx?page=591 | City 2 | 1076 | Cupertino, City of 191 | City 2 | City Agency 2 | Santa Clara 19 | 12.968 | Creekside Park | 1990 | Local Park 2 | 4 | |
9194 | 9194 | 9193 | {"type": "Polygon", "coordinates": [[[-121.88586, 37.69157], [-121.88515, 37.69244], [-121.88287, 37.69077], [-121.88321, 37.69053], [-121.88397, 37.69108], [-121.88453, 37.69057], [-121.88586, 37.69157]]]} | Open Access 1 | 15260 | Creekside Park | 17777 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 5.719 | Creekside Park | 2000 | Local Park 2 | 4 | |
9570 | 9570 | 9569 | {"type": "Polygon", "coordinates": [[[-122.54218, 38.04659], [-122.5421, 38.04696], [-122.54177, 38.04686], [-122.54204, 38.04666], [-122.54174, 38.0464], [-122.54122, 38.04642], [-122.54096, 38.04662], [-122.53947, 38.04637], [-122.53912, 38.04636], [-122.53866, 38.04642], [-122.5385, 38.04642], [-122.53837, 38.04638], [-122.53808, 38.0462], [-122.53782, 38.04612], [-122.53723, 38.04602], [-122.53704, 38.04601], [-122.53691, 38.04603], [-122.5369, 38.04589], [-122.53793, 38.04594], [-122.53834, 38.04628], [-122.54119, 38.04606], [-122.54191, 38.04624], [-122.54218, 38.04659]]]} | Open Access 1 | 16101 | Creekside Park | 17775 | 1226 | Novato, City of 444 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | Marin 23 | 3.21 | Creekside Park | 2000 | Local Park 2 | 4 | |
10697 | 10697 | 10696 | {"type": "Polygon", "coordinates": [[[-117.06759, 34.00134], [-117.06759, 34.00144], [-117.0673, 34.0017], [-117.06653, 34.00192], [-117.06612, 34.00192], [-117.06612, 34.00134], [-117.06759, 34.00134]]]} | Open Access 1 | 19879 | Creekside Park | 17783 | 1390 | Calimesa, City of 682 | City 2 | City Agency 2 | http://www.cityofcalimesa.net/ | City 2 | 1390 | Calimesa, City of 673 | City 2 | City Agency 2 | Riverside 10 | 1.689 | Creekside Park | 0 | Local Park 2 | 4 | |
11990 | 11990 | 11989 | {"type": "Polygon", "coordinates": [[[-117.25891, 33.65896], [-117.25828, 33.65922], [-117.25818, 33.65929], [-117.25812, 33.65937], [-117.25807, 33.65947], [-117.25805, 33.65961], [-117.25807, 33.65969], [-117.25817, 33.6599], [-117.25822, 33.66004], [-117.25824, 33.66019], [-117.25822, 33.6603], [-117.25698, 33.66046], [-117.25687, 33.66], [-117.25677, 33.65982], [-117.25663, 33.65966], [-117.25664, 33.65958], [-117.25695, 33.65925], [-117.25726, 33.65885], [-117.25751, 33.65843], [-117.25768, 33.65805], [-117.25815, 33.65824], [-117.25849, 33.65852], [-117.25891, 33.65896]]]} | Open Access 1 | 24644 | Creekside Park | 17782 | 1389 | Lake Elsinore, City of 187 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=202 | City 2 | 1389 | Lake Elsinore, City of 183 | City 2 | City Agency 2 | Riverside 10 | 7.192 | Creekside Park | 0 | Local Park 2 | 4 | |
12532 | 12532 | 12531 | {"type": "Polygon", "coordinates": [[[-121.69134, 37.98202], [-121.69132, 37.98331], [-121.69018, 37.98331], [-121.68991, 37.9828], [-121.68981, 37.98246], [-121.68976, 37.98217], [-121.68971, 37.98206], [-121.69134, 37.98202]]]} | Open Access 1 | 29032 | Creekside Park | 17776 | 1229 | Oakley, City of 255 | City 2 | City Agency 2 | http://www.ci.oakley.ca.us/subpage.cfm?id=441408 | City 2 | 1229 | Oakley, City of 251 | City 2 | City Agency 2 | Contra Costa 12 | 4.337 | Creekside Park | 0 | Local Park 2 | 4 | |
12814 | 12814 | 12813 | {"type": "MultiPolygon", "coordinates": [[[[-117.68, 33.4774], [-117.67968, 33.47877], [-117.67924, 33.47862], [-117.67947, 33.47751], [-117.67952, 33.47734], [-117.68, 33.4774]]], [[[-117.68103, 33.47492], [-117.68036, 33.47591], [-117.68023, 33.47625], [-117.68017, 33.47633], [-117.67999, 33.47724], [-117.67954, 33.47718], [-117.67983, 33.47571], [-117.67937, 33.47553], [-117.67953, 33.47496], [-117.67961, 33.47464], [-117.68103, 33.47492]]]]} | Open Access 1 | 30257 | Creekside Park | 17773 | 1079 | Dana Point, City of 134 | City 2 | City Agency 2 | http://www.danapoint.org/index.aspx?page=170 | City 2 | 1079 | Dana Point, City of 131 | City 2 | City Agency 2 | Orange 3 | 6.647 | Creekside Park | 0 | Local Park 2 | 4 | |
13102 | 13102 | 13101 | {"type": "Polygon", "coordinates": [[[-121.92463, 37.77037], [-121.92461, 37.77057], [-121.92454, 37.77086], [-121.92429, 37.77082], [-121.92344, 37.77075], [-121.92226, 37.77054], [-121.92228, 37.77015], [-121.92218, 37.76978], [-121.92198, 37.76942], [-121.92295, 37.76955], [-121.9242, 37.76983], [-121.92429, 37.76993], [-121.92433, 37.77005], [-121.92454, 37.77001], [-121.92461, 37.77022], [-121.92463, 37.77037]]]} | Open Access 1 | 35020 | Creekside Park | 17779 | 1313 | San Ramon, City of 70 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 6.012 | Creekside Park | 0 | Local Park 2 | 4 | |
14662 | 14662 | 14661 | {"type": "Polygon", "coordinates": [[[-122.30582, 37.89839], [-122.30562, 37.89844], [-122.30549, 37.89817], [-122.30533, 37.89822], [-122.30547, 37.89852], [-122.30514, 37.89862], [-122.30511, 37.89856], [-122.30479, 37.89865], [-122.30463, 37.89833], [-122.30447, 37.89834], [-122.30453, 37.8985], [-122.30421, 37.8986], [-122.3041, 37.89837], [-122.30218, 37.89852], [-122.30565, 37.89813], [-122.30582, 37.89839]]]} | Open Access 1 | 44928 | Creekside Park | 17774 | 1094 | El Cerrito, City of 385 | City 2 | City Agency 2 | http://www.el-cerrito.org/ | City 2 | 1094 | El Cerrito, City of 381 | City 2 | City Agency 2 | Contra Costa 12 | 1.242 | Creekside 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]);