units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
34 rows where MNG_AGENCY = 467 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, PARK_URL, LABEL_NAME
DES_TP 2
MNG_AG_TYP 1
- City Agency 34
MNG_AGENCY 1
- Merced, City of · 34 ✖
ACCESS_TYP 1
- Open Access 34
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14922 | 14922 | 14921 | {"type": "Polygon", "coordinates": [[[-120.50302, 37.31525], [-120.50296, 37.317], [-120.50148, 37.31639], [-120.50151, 37.31494], [-120.5017, 37.31495], [-120.50192, 37.31498], [-120.50302, 37.31525]]]} | Open Access 1 | 45495 | Carolo Gabriault Park | 28324 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | https://www.cityofmerced.org/depts/parks_n_community_services/parks_n_facilities/parks/neighborhood.asp | Merced 37 | 5.966 | Carolo Gabriault Park | 0 | Local Park 2 | 4 |
14615 | 14615 | 14614 | {"type": "Polygon", "coordinates": [[[-120.52536, 37.32598], [-120.52391, 37.32599], [-120.52384, 37.32593], [-120.52386, 37.32508], [-120.52383, 37.32494], [-120.52374, 37.32475], [-120.52371, 37.32464], [-120.52375, 37.32459], [-120.52445, 37.32459], [-120.52445, 37.32503], [-120.52536, 37.32503], [-120.52536, 37.32598]]]} | Open Access 1 | 48865 | Drake Avenue Park | 33589 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 4.221 | Drake Avenue Park | 0 | Local Park 2 | 4 | |
14607 | 14607 | 14606 | {"type": "Polygon", "coordinates": [[[-120.47399, 37.35291], [-120.47387, 37.35298], [-120.4733, 37.35322], [-120.47277, 37.35349], [-120.47297, 37.35373], [-120.47251, 37.35401], [-120.47241, 37.35399], [-120.47215, 37.35365], [-120.47194, 37.35328], [-120.47178, 37.35289], [-120.47184, 37.35283], [-120.47241, 37.35276], [-120.47399, 37.35275], [-120.47399, 37.35291]]]} | Open Access 1 | 48303 | Elmer Murchie Park | 32871 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 3.538 | Elmer Murchie Park | 0 | Local Park 2 | 4 | |
14271 | 14271 | 14270 | {"type": "Polygon", "coordinates": [[[-120.47664, 37.28434], [-120.47574, 37.28433], [-120.47574, 37.28253], [-120.47664, 37.28254], [-120.47664, 37.28434]]]} | Open Access 1 | 44194 | Flanagan Park | 18939 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 3.957 | Flanagan Park | 0 | Local Park 2 | 4 | |
12325 | 12325 | 12324 | {"type": "MultiPolygon", "coordinates": [[[[-120.50386, 37.30145], [-120.50368, 37.30177], [-120.5034, 37.30167], [-120.50358, 37.30135], [-120.50386, 37.30145]]], [[[-120.50419, 37.30157], [-120.50401, 37.30189], [-120.50371, 37.30178], [-120.50389, 37.30146], [-120.50419, 37.30157]]]]} | Open Access 1 | 25988 | Dennis Chavez Park | 18088 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 0.543 | Dennis Chavez Park | 0 | Local Park 2 | 4 | |
12243 | 12243 | 12242 | {"type": "Polygon", "coordinates": [[[-120.50379, 37.28689], [-120.50377, 37.28741], [-120.50297, 37.28742], [-120.50298, 37.28689], [-120.50379, 37.28689]]]} | Open Access 1 | 25455 | William Lloyd Garrison Park | 27550 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 1.021 | William Lloyd Garrison Park | 0 | Local Park 2 | 4 | |
11957 | 11957 | 11956 | {"type": "Polygon", "coordinates": [[[-120.46488, 37.30196], [-120.46508, 37.30203], [-120.46511, 37.30208], [-120.46498, 37.30229], [-120.46491, 37.30233], [-120.46484, 37.30233], [-120.46474, 37.30229], [-120.46471, 37.30225], [-120.4647, 37.30219], [-120.46481, 37.30199], [-120.46488, 37.30196]]]} | Open Access 1 | 24574 | Circle Drive Park | 17262 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 0.245 | Circle Drive Park | 0 | Local Park 2 | 4 | |
11956 | 11956 | 11955 | {"type": "Polygon", "coordinates": [[[-120.4915, 37.2933], [-120.49129, 37.29367], [-120.49082, 37.2935], [-120.49103, 37.29312], [-120.4915, 37.2933]]]} | Open Access 1 | 24573 | Charles Richard Drew Park | 17141 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 0.516 | Charles Richard Drew Park | 0 | Local Park 2 | 4 | |
11955 | 11955 | 11954 | {"type": "Polygon", "coordinates": [[[-120.45683, 37.33995], [-120.45636, 37.33993], [-120.45612, 37.33986], [-120.45579, 37.3397], [-120.45557, 37.33956], [-120.45533, 37.33946], [-120.45505, 37.33936], [-120.45469, 37.33931], [-120.45401, 37.33931], [-120.45403, 37.33859], [-120.45464, 37.33855], [-120.45505, 37.33842], [-120.45638, 37.33845], [-120.45647, 37.33853], [-120.45669, 37.33865], [-120.45678, 37.33875], [-120.45683, 37.33995]]]} | Open Access 1 | 24571 | Davenport Park | 17940 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 7.283 | Davenport Park | 0 | Local Park 2 | 4 | |
10009 | 10009 | 10008 | {"type": "Polygon", "coordinates": [[[-120.46054, 37.32302], [-120.46054, 37.32321], [-120.46018, 37.32312], [-120.46017, 37.32343], [-120.45982, 37.32331], [-120.459, 37.32281], [-120.45818, 37.32281], [-120.45792, 37.32288], [-120.45702, 37.3236], [-120.45696, 37.32392], [-120.45695, 37.32489], [-120.45622, 37.3249], [-120.45536, 37.32489], [-120.45561, 37.32475], [-120.45603, 37.32447], [-120.45638, 37.32445], [-120.45654, 37.32426], [-120.45655, 37.32356], [-120.45789, 37.32249], [-120.45886, 37.32159], [-120.45902, 37.32149], [-120.4592, 37.32142], [-120.45937, 37.32137], [-120.45957, 37.32137], [-120.45964, 37.32144], [-120.45973, 37.32146], [-120.45977, 37.32173], [-120.46019, 37.32174], [-120.46017, 37.32301], [-120.46054, 37.32302]]]} | Open Access 1 | 17216 | Strip Park | 25927 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 10.443 | Strip Park | 0 | Local Park 2 | 4 | |
10008 | 10008 | 10007 | {"type": "Polygon", "coordinates": [[[-120.50888, 37.29553], [-120.50884, 37.29726], [-120.50588, 37.29724], [-120.50594, 37.29553], [-120.50888, 37.29553]]]} | Open Access 1 | 17205 | Merced Youth Sports Complex | 22167 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 12.336 | Merced Youth Sports Complex | 0 | Local Recreation Area 3 | 4 | |
9999 | 9999 | 9998 | {"type": "Polygon", "coordinates": [[[-120.51484, 37.28903], [-120.51501, 37.28906], [-120.51515, 37.28915], [-120.51521, 37.28923], [-120.51524, 37.28932], [-120.51522, 37.28946], [-120.51434, 37.29158], [-120.51391, 37.29154], [-120.5146, 37.28986], [-120.51461, 37.28976], [-120.51459, 37.28967], [-120.51448, 37.28949], [-120.51444, 37.28941], [-120.51445, 37.28927], [-120.51453, 37.28915], [-120.51462, 37.28909], [-120.51472, 37.28905], [-120.51484, 37.28903]]]} | Open Access 1 | 17199 | Macready Park | 21639 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 3.102 | Macready Park | 0 | Local Park 2 | 4 | |
9991 | 9991 | 9990 | {"type": "MultiPolygon", "coordinates": [[[[-120.44838, 37.29502], [-120.44834, 37.29505], [-120.44707, 37.29505], [-120.44707, 37.29497], [-120.44796, 37.29497], [-120.4481, 37.29492], [-120.44827, 37.29478], [-120.44837, 37.29478], [-120.44838, 37.29479], [-120.44838, 37.29502]]], [[[-120.45142, 37.29149], [-120.45142, 37.29155], [-120.4512, 37.29155], [-120.45119, 37.2917], [-120.45142, 37.29171], [-120.45141, 37.29303], [-120.45129, 37.29303], [-120.45129, 37.29328], [-120.45141, 37.29329], [-120.45141, 37.29332], [-120.44934, 37.29332], [-120.44933, 37.29374], [-120.44865, 37.29375], [-120.44864, 37.29502], [-120.44855, 37.29501], [-120.44855, 37.29456], [-120.44839, 37.29456], [-120.44838, 37.29461], [-120.44835, 37.29464], [-120.44819, 37.29466], [-120.448, 37.29481], [-120.44793, 37.29483], [-120.44707, 37.29483], [-120.44709, 37.29149], [-120.45142, 37.29149]]]]} | Open Access 1 | 17193 | Joe Herb Park | 20419 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 25.726 | Joe Herb Park | 0 | Local Park 2 | 4 | |
9979 | 9979 | 9978 | {"type": "Polygon", "coordinates": [[[-120.45419, 37.30635], [-120.45368, 37.30715], [-120.45136, 37.30715], [-120.45137, 37.30635], [-120.45419, 37.30635]]]} | Open Access 1 | 17171 | Ada Givens Park | 15254 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 4.995 | Ada Givens Park | 0 | Local Park 2 | 4 | |
7221 | 7221 | 7220 | {"type": "Polygon", "coordinates": [[[-120.43929, 37.329], [-120.43929, 37.32952], [-120.43925, 37.32958], [-120.4392, 37.3296], [-120.43809, 37.3296], [-120.43785, 37.32954], [-120.4377, 37.32947], [-120.43758, 37.32938], [-120.43748, 37.32927], [-120.43739, 37.32908], [-120.43738, 37.32895], [-120.43738, 37.32783], [-120.43739, 37.32779], [-120.43743, 37.32776], [-120.43749, 37.32774], [-120.4389, 37.32774], [-120.4389, 37.329], [-120.43929, 37.329]]]} | Open Access 1 | 48908 | Richard Bernasconi Neighborhood Park | 33625 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 7.14 | Richard Bernasconi Neighborhood Park | 0 | Local Park 2 | 4 | |
7213 | 7213 | 7212 | {"type": "MultiPolygon", "coordinates": [[[[-120.48044, 37.3308], [-120.48043, 37.33102], [-120.47957, 37.33103], [-120.47936, 37.33099], [-120.47933, 37.33122], [-120.47925, 37.33123], [-120.47914, 37.33095], [-120.47891, 37.33092], [-120.47889, 37.33086], [-120.47856, 37.33086], [-120.47855, 37.33077], [-120.47917, 37.3308], [-120.47927, 37.33059], [-120.47937, 37.33058], [-120.47938, 37.33085], [-120.47958, 37.33078], [-120.48044, 37.3308]]], [[[-120.4793, 37.32869], [-120.47929, 37.32887], [-120.4786, 37.32886], [-120.47861, 37.32869], [-120.4793, 37.32869]]], [[[-120.48191, 37.32963], [-120.48164, 37.32966], [-120.48163, 37.32947], [-120.48171, 37.32924], [-120.4817, 37.32878], [-120.48157, 37.32866], [-120.48138, 37.32884], [-120.48131, 37.32881], [-120.48137, 37.32859], [-120.48105, 37.32859], [-120.4808, 37.32878], [-120.48031, 37.32878], [-120.4802, 37.3288], [-120.48026, 37.32899], [-120.4802, 37.32901], [-120.48002, 37.32882], [-120.47985, 37.32888], [-120.47951, 37.32886], [-120.47952, 37.32874], [-120.48006, 37.32871], [-120.48051, 37.32863], [-120.48106, 37.32847], [-120.48106, 37.32826], [-120.48081, 37.32825], [-120.4808, 37.32818], [-120.48108, 37.32809], [-120.48095, 37.32774], [-120.48112, 37.32754], [-120.48112, 37.3274], [-120.48082, 37.32746], [-120.4808, 37.3274], [-120.48115, 37.3272], [-120.48117, 37.32678], [-120.48125, 37.32673], [-120.48112, 37.32649], [-120.48123, 37.32645], [-120.48137, 37.32642], [-120.4813, 37.3283], [-120.48191, 37.32831], [-120.48192, 37.32892], [-120.48191, 37.32963]]], [[[-120.48253, 37.33199], [-120.48223, 37.33198], [-120.48223, 37.33128], [-120.48197, 37.33132], [-120.48193, 37.33125], [-120.48216, 37.3311], [-120.48208, 37.3309], [-120.48178, 37.33097], [-120.48136, 37.33103], [-120.48067, 37.33103], [-120.48068, 37.33081], [-120.48113, 37.33081], [-120.48165, 37.33085], [-120.48203, 37.33078], [-120.48196, 37.33061], [-120.48164, 37.33053], [-120.48163, 37.33047], [-120.48189, 37.33041], [-120.48175, 37.33011], [-120.48174, 37.32983], [-120.4823, 37.32978], [-120.48241, 37.3303], [-120.48263, 37.33096], [-120.48262, 37.33118], [-120.48253, 37.33163], [-120.48253, 37.33199]]]]} | Open Access 1 | 48907 | Santa Fe Strip Park | 33624 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | https://www.cityofmerced.org/Home/Components/FacilityDirectory/FacilityDirectory/26/3556 | Merced 37 | 7.737 | Santa Fe Strip Park | 0 | Local Park 2 | 4 |
6807 | 6807 | 6806 | {"type": "Polygon", "coordinates": [[[-120.49516, 37.33647], [-120.49512, 37.33651], [-120.49363, 37.33653], [-120.49356, 37.33652], [-120.49344, 37.33648], [-120.49326, 37.33649], [-120.49313, 37.33654], [-120.49309, 37.33658], [-120.49305, 37.33665], [-120.49304, 37.33673], [-120.49312, 37.33691], [-120.49313, 37.33724], [-120.49308, 37.33729], [-120.49169, 37.33729], [-120.49151, 37.33731], [-120.49119, 37.3374], [-120.49074, 37.33762], [-120.49069, 37.33757], [-120.49251, 37.33673], [-120.49234, 37.33648], [-120.49227, 37.33648], [-120.49225, 37.33643], [-120.49196, 37.33608], [-120.49195, 37.33603], [-120.49192, 37.33598], [-120.49182, 37.33592], [-120.49182, 37.33566], [-120.49497, 37.33562], [-120.49505, 37.33564], [-120.49513, 37.33571], [-120.49514, 37.33579], [-120.49516, 37.33647]]]} | Open Access 1 | 48906 | Rudolph Joseph Merino Neighborhood Park | 33623 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | https://www.cityofmerced.org/Home/Components/FacilityDirectory/FacilityDirectory/48/3557 | Merced 37 | 8.806 | Rudolph Joseph Merino Neighborhood Park | 0 | Local Park 2 | 4 |
5004 | 5004 | 5003 | {"type": "Polygon", "coordinates": [[[-120.48291, 37.32505], [-120.48255, 37.32505], [-120.48249, 37.32529], [-120.48243, 37.32524], [-120.48239, 37.32506], [-120.48168, 37.32507], [-120.48162, 37.32522], [-120.48153, 37.32506], [-120.48117, 37.32506], [-120.48116, 37.326], [-120.48111, 37.32627], [-120.48086, 37.32635], [-120.48072, 37.3262], [-120.48075, 37.32506], [-120.48039, 37.32506], [-120.4803, 37.32523], [-120.48021, 37.32507], [-120.47965, 37.32507], [-120.47945, 37.32511], [-120.4794, 37.32527], [-120.47928, 37.32514], [-120.47898, 37.32519], [-120.47864, 37.32527], [-120.47865, 37.32539], [-120.47856, 37.32544], [-120.47852, 37.3253], [-120.47852, 37.32498], [-120.47961, 37.3248], [-120.48291, 37.32478], [-120.48291, 37.32505]]]} | Open Access 1 | 17210 | Santa Fe Park | 25086 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 4.44 | Santa Fe Park | 0 | Local Park 2 | 4 | |
3612 | 3612 | 3611 | {"type": "Polygon", "coordinates": [[[-120.4815, 37.29325], [-120.48128, 37.29362], [-120.48113, 37.29357], [-120.48134, 37.29319], [-120.4815, 37.29325]]]} | Open Access 1 | 47309 | 11th Street Neighborhood Park | 31016 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | https://www.cityofmerced.org/depts/parks_n_community_services/parks_n_facilities/parks/mini.asp | Merced 37 | 0.172 | 11th Street Neighborhood Park | 0 | Local Park 2 | 4 |
3611 | 3611 | 3610 | {"type": "Polygon", "coordinates": [[[-120.47782, 37.29312], [-120.47757, 37.29354], [-120.47726, 37.29343], [-120.47751, 37.293], [-120.47782, 37.29312]]]} | Open Access 1 | 47308 | E. 12th Street Neighborhood Park | 31015 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | https://www.cityofmerced.org/depts/parks_n_community_services/parks_n_facilities/parks/mini.asp | Merced 37 | 0.39 | E. 12th Street Neighborhood 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]);