units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
143 rows where DES_TP = 4 and MNG_AG_TYP = 2 sorted by ACRES
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1834 | 1834 | 1833 | {"type": "Polygon", "coordinates": [[[-122.29139, 37.56829], [-122.29135, 37.56831], [-122.2913, 37.56829], [-122.29123, 37.56825], [-122.29109, 37.56813], [-122.29095, 37.56795], [-122.29089, 37.56778], [-122.29092, 37.56774], [-122.29111, 37.5678], [-122.29127, 37.56788], [-122.2914, 37.568], [-122.29143, 37.56813], [-122.29141, 37.56827], [-122.29139, 37.56829]]]} | Open Access 1 | 14019 | Marina Lagoon Wildlife Island | 21829 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | San Mateo 15 | 0.388 | Marina Lagoon Wildlife Island | 1962 | Local Conservation Area 4 | 2 | |
5109 | 5109 | 5108 | {"type": "MultiPolygon", "coordinates": [[[[-118.29581, 34.19337], [-118.29578, 34.19349], [-118.29574, 34.19378], [-118.29561, 34.19383], [-118.29556, 34.19372], [-118.29574, 34.19353], [-118.29579, 34.19336], [-118.29581, 34.19337]]], [[[-118.29591, 34.19347], [-118.29593, 34.19378], [-118.29591, 34.19396], [-118.29586, 34.19409], [-118.29577, 34.19426], [-118.29568, 34.19436], [-118.29567, 34.1944], [-118.29568, 34.19442], [-118.29562, 34.19442], [-118.29578, 34.19411], [-118.29582, 34.19399], [-118.29591, 34.19347]]], [[[-118.29599, 34.19529], [-118.29577, 34.19538], [-118.29565, 34.19511], [-118.2956, 34.19497], [-118.29561, 34.1948], [-118.29564, 34.19469], [-118.29564, 34.19491], [-118.29577, 34.19517], [-118.29585, 34.19514], [-118.29592, 34.19518], [-118.29599, 34.19529]]], [[[-118.29578, 34.1959], [-118.29571, 34.19612], [-118.2955, 34.19549], [-118.29547, 34.1951], [-118.29542, 34.19493], [-118.29542, 34.19481], [-118.29545, 34.19468], [-118.29552, 34.19452], [-118.2956, 34.19443], [-118.29549, 34.19467], [-118.29545, 34.19486], [-118.29545, 34.19494], [-118.29551, 34.19516], [-118.29561, 34.19532], [-118.2957, 34.19573], [-118.29578, 34.19584], [-118.29578, 34.1959]]]]} | Open Access 1 | 7136 | City of Burbank Open Space Mountain Reserve | 744 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | Los Angeles 6 | 0.75 | City of Burbank OS Mtn. Reserve | 0 | Local Conservation Area 4 | 2 | |
11709 | 11709 | 11708 | {"type": "Polygon", "coordinates": [[[-121.31468, 38.25154], [-121.31467, 38.2521], [-121.31464, 38.25231], [-121.31421, 38.25231], [-121.31423, 38.25211], [-121.31424, 38.25158], [-121.3143, 38.25154], [-121.31468, 38.25154]]]} | Open Access 1 | 24100 | Fumasi Oak Preserve | 19150 | 1407 | Galt, City of 623 | City 2 | City Agency 2 | http://www.ci.galt.ca.us/index.aspx?page=71 | City 2 | 1407 | Galt, City of 612 | City 2 | City Agency 2 | Sacramento 41 | 0.802 | Fumasi Oak Preserve | 0 | Local Conservation Area 4 | 2 | |
14366 | 14366 | 14365 | {"type": "MultiPolygon", "coordinates": [[[[-124.0907, 40.87504], [-124.09043, 40.87498], [-124.09043, 40.87491], [-124.09035, 40.87489], [-124.0905, 40.87451], [-124.0907, 40.87504]]], [[[-124.09106, 40.87533], [-124.09096, 40.87542], [-124.09102, 40.87562], [-124.09096, 40.87576], [-124.09097, 40.87604], [-124.09089, 40.87657], [-124.09081, 40.8764], [-124.09075, 40.8762], [-124.09062, 40.87551], [-124.09044, 40.87505], [-124.09103, 40.87517], [-124.09106, 40.87533]]], [[[-124.09083, 40.87428], [-124.09074, 40.87443], [-124.09073, 40.87459], [-124.09067, 40.87467], [-124.09055, 40.87437], [-124.0906, 40.87423], [-124.09083, 40.87428]]]]} | Open Access 1 | 47025 | Dellanina Nature Preserve | 30674 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 1.331 | Dellanina Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
3337 | 3337 | 3336 | {"type": "Polygon", "coordinates": [[[-122.727, 38.40276], [-122.72699, 38.40298], [-122.72678, 38.40342], [-122.72676, 38.40361], [-122.7267, 38.40366], [-122.72629, 38.40366], [-122.72613, 38.40368], [-122.72613, 38.40277], [-122.727, 38.40276]]]} | Open Access 1 | 29791 | Colgan Creek Park and Preserve | 17496 | 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 | 1.602 | Colgan Creek Park and Preserve | 0 | Local Conservation Area 4 | 2 | |
3641 | 3641 | 3640 | {"type": "Polygon", "coordinates": [[[-117.89406, 34.16397], [-117.89267, 34.16401], [-117.89233, 34.1637], [-117.89222, 34.16349], [-117.89221, 34.16311], [-117.89406, 34.16397]]]} | Open Access 1 | 29516 | River Wilderness Park | 24431 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | Los Angeles 6 | 1.847 | River Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
1139 | 1139 | 1138 | {"type": "Polygon", "coordinates": [[[-122.51189, 37.77681], [-122.51151, 37.77685], [-122.5112, 37.77653], [-122.51112, 37.77641], [-122.51112, 37.77626], [-122.51093, 37.77611], [-122.51078, 37.77588], [-122.51061, 37.77568], [-122.51028, 37.77523], [-122.51108, 37.7752], [-122.51109, 37.77541], [-122.51113, 37.77564], [-122.5112, 37.77588], [-122.51128, 37.77607], [-122.51149, 37.7764], [-122.51189, 37.77681]]]} | Open Access 1 | 6699 | Gr.hwy/balboa Natural Area | 19412 | 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.868 | Gr.hwy/balboa Natural Area | 0 | Local Conservation Area 4 | 2 | |
1122 | 1122 | 1121 | {"type": "Polygon", "coordinates": [[[-118.29627, 34.19919], [-118.29609, 34.19935], [-118.29614, 34.19953], [-118.29511, 34.19897], [-118.2953, 34.19878], [-118.29525, 34.19874], [-118.29588, 34.19813], [-118.29595, 34.19818], [-118.29627, 34.19919]]]} | Open Access 1 | 7138 | City of Burbank Open Space Mountain Reserve | 744 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | Los Angeles 6 | 2.037 | City of Burbank OS Mtn. Reserve | 0 | Local Conservation Area 4 | 2 | |
7282 | 7282 | 7281 | {"type": "Polygon", "coordinates": [[[-118.20247, 33.7629], [-118.20235, 33.76293], [-118.20228, 33.76291], [-118.20223, 33.76292], [-118.2021, 33.76307], [-118.20205, 33.76317], [-118.20207, 33.76345], [-118.20214, 33.76347], [-118.20218, 33.76352], [-118.20221, 33.76357], [-118.20221, 33.76394], [-118.20206, 33.76396], [-118.20192, 33.76395], [-118.20183, 33.76366], [-118.20183, 33.76317], [-118.20187, 33.76301], [-118.20199, 33.76286], [-118.202, 33.76282], [-118.20197, 33.76278], [-118.20196, 33.76272], [-118.20157, 33.76249], [-118.20096, 33.76248], [-118.20093, 33.76351], [-118.20063, 33.76329], [-118.20069, 33.76327], [-118.20078, 33.76318], [-118.20078, 33.76266], [-118.20076, 33.76245], [-118.20069, 33.76223], [-118.20061, 33.76208], [-118.20051, 33.76196], [-118.2003, 33.76176], [-118.20017, 33.76168], [-118.20008, 33.76166], [-118.20004, 33.76162], [-118.20006, 33.76157], [-118.20014, 33.76156], [-118.20025, 33.76165], [-118.20063, 33.76183], [-118.20247, 33.7629]]]} | Open Access 1 | 6577 | Golden Shore Marine Biological Reserve Park | 19372 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/park-and-facilities/directory/golden-shore-marine-biological-reserve-park/ | Los Angeles 6 | 2.556 | Golden Shore Marine Biological Reserve Park | 0 | Local Conservation Area 4 | 2 |
14697 | 14697 | 14696 | {"type": "Polygon", "coordinates": [[[-121.80876, 39.76798], [-121.80871, 39.76806], [-121.80871, 39.76814], [-121.80873, 39.76815], [-121.80863, 39.76821], [-121.80864, 39.76851], [-121.80763, 39.76852], [-121.8071, 39.76788], [-121.80738, 39.76769], [-121.8079, 39.76741], [-121.8081, 39.76735], [-121.80827, 39.76733], [-121.80829, 39.76733], [-121.8083, 39.76746], [-121.80846, 39.76763], [-121.80856, 39.76768], [-121.80866, 39.76792], [-121.80876, 39.76798]]]} | Unknown Access 4 | 45027 | Wildwood Estate Preserve | 27518 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 3.11 | Wildwood Estate Preserve | 0 | Local Conservation Area 4 | 2 | |
7299 | 7299 | 7298 | {"type": "Polygon", "coordinates": [[[-118.12099, 33.76215], [-118.12095, 33.76218], [-118.12089, 33.76215], [-118.12066, 33.76192], [-118.12055, 33.76183], [-118.11972, 33.76246], [-118.11976, 33.76251], [-118.11952, 33.76268], [-118.11947, 33.76265], [-118.119, 33.76301], [-118.11851, 33.76256], [-118.11853, 33.76255], [-118.11855, 33.76248], [-118.11859, 33.76245], [-118.11855, 33.7624], [-118.11988, 33.76165], [-118.1201, 33.76161], [-118.12043, 33.76165], [-118.12047, 33.76164], [-118.12057, 33.76171], [-118.12056, 33.76177], [-118.12099, 33.76215]]]} | Open Access 1 | 6583 | Jack Dunster Marine Biological Reserve | 20302 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 3.22 | Jack Dunster Marine Biological Reserve | 2004 | Local Conservation Area 4 | 2 | |
14489 | 14489 | 14488 | {"type": "Polygon", "coordinates": [[[-121.95603, 37.54103], [-121.95584, 37.5411], [-121.95561, 37.53966], [-121.95519, 37.5368], [-121.9548, 37.53434], [-121.95503, 37.53453], [-121.95537, 37.53662], [-121.95603, 37.54103]]]} | Open Access 1 | 47148 | East Bay Greenway Trail Corridor | 30830 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 3.364 | East Bay Greenway Trail Corridor | 0 | Local Conservation Area 4 | 2 | |
14696 | 14696 | 14695 | {"type": "Polygon", "coordinates": [[[-121.80841, 39.76956], [-121.80823, 39.76957], [-121.80746, 39.77005], [-121.80758, 39.77016], [-121.80642, 39.76929], [-121.80643, 39.76853], [-121.80708, 39.76853], [-121.80745, 39.7689], [-121.80751, 39.76892], [-121.80751, 39.76895], [-121.80767, 39.76908], [-121.80801, 39.76933], [-121.80841, 39.76956]]]} | Open Access 1 | 45026 | Eaton Road Preserve | 18413 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 3.753 | Eaton Road Preserve | 0 | Local Conservation Area 4 | 2 | |
1168 | 1168 | 1167 | {"type": "Polygon", "coordinates": [[[-117.16158, 33.54542], [-117.16142, 33.54573], [-117.16062, 33.54559], [-117.16033, 33.54532], [-117.16028, 33.54523], [-117.1601, 33.54511], [-117.1595, 33.54457], [-117.15987, 33.54428], [-117.15985, 33.54425], [-117.16006, 33.54409], [-117.16012, 33.54409], [-117.16126, 33.54513], [-117.16158, 33.54536], [-117.16158, 33.54542]]]} | Open Access 1 | 48441 | Vintage Reserve Park | 33146 | 1391 | Murrieta, City of 329 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | Riverside 10 | 3.802 | Vintage Reserve Park | 0 | Local Conservation Area 4 | 2 | |
1857 | 1857 | 1856 | {"type": "Polygon", "coordinates": [[[-119.08916, 35.30331], [-119.0891, 35.30338], [-119.08883, 35.30342], [-119.08844, 35.30351], [-119.08824, 35.30353], [-119.08751, 35.30203], [-119.08796, 35.30189], [-119.08883, 35.30171], [-119.0889, 35.30193], [-119.08916, 35.30331]]]} | Open Access 1 | 15859 | Wilderness Park | 27511 | 1019 | Bakersfield, City of 248 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | Kern 36 | 4.843 | Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
11022 | 11022 | 11021 | {"type": "Polygon", "coordinates": [[[-121.50608, 38.60857], [-121.50599, 38.60901], [-121.50599, 38.60912], [-121.50602, 38.60919], [-121.50591, 38.60958], [-121.50573, 38.60985], [-121.50543, 38.61018], [-121.50549, 38.61022], [-121.50499, 38.61022], [-121.50473, 38.6102], [-121.50492, 38.60947], [-121.50493, 38.60813], [-121.50453, 38.60802], [-121.50453, 38.60744], [-121.50521, 38.60734], [-121.50479, 38.60784], [-121.5053, 38.60811], [-121.50575, 38.60838], [-121.50598, 38.60832], [-121.50608, 38.60857]]]} | Open Access 1 | 21107 | Bannon Creek Preserve | 15801 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 5.638 | Bannon Creek Preserve | 0 | Local Conservation Area 4 | 2 | |
14632 | 14632 | 14631 | {"type": "Polygon", "coordinates": [[[-121.57824, 36.98649], [-121.57805, 36.98652], [-121.57788, 36.98656], [-121.57773, 36.98664], [-121.57749, 36.9868], [-121.57735, 36.98687], [-121.5772, 36.98691], [-121.57689, 36.98694], [-121.57673, 36.98698], [-121.57658, 36.98703], [-121.57644, 36.98711], [-121.57627, 36.98726], [-121.57614, 36.98744], [-121.57609, 36.98755], [-121.57599, 36.98788], [-121.57592, 36.988], [-121.57582, 36.98811], [-121.57563, 36.98822], [-121.57541, 36.98829], [-121.57491, 36.98831], [-121.57473, 36.98833], [-121.57449, 36.98843], [-121.57435, 36.98852], [-121.57413, 36.98871], [-121.57394, 36.9888], [-121.57379, 36.98884], [-121.57362, 36.98885], [-121.57354, 36.98878], [-121.57354, 36.98841], [-121.57386, 36.98828], [-121.57385, 36.98795], [-121.57409, 36.98792], [-121.57485, 36.98791], [-121.57503, 36.98787], [-121.57529, 36.98776], [-121.57543, 36.98767], [-121.57556, 36.98755], [-121.57604, 36.98688], [-121.57615, 36.98678], [-121.57629, 36.98669], [-121.57645, 36.98662], [-121.57679, 36.98654], [-121.57733, 36.98632], [-121.57734, 36.98649], [-121.57824, 36.98649]]]} | Open Access 1 | 44895 | Babbs Creek Park Preserve | 15743 | 1118 | Gilroy, City of 407 | City 2 | City Agency 2 | http://www.cityofgilroy.org/cityofgilroy/community/parks/default.aspx | City 2 | 1118 | Gilroy, City of 401 | City 2 | City Agency 2 | Santa Clara 19 | 5.752 | Babbs Creek Park Preserve | 0 | Local Conservation Area 4 | 2 | |
770 | 770 | 769 | {"type": "MultiPolygon", "coordinates": [[[[-119.5289, 34.39581], [-119.52824, 34.3972], [-119.52811, 34.3971], [-119.52714, 34.39789], [-119.52649, 34.39736], [-119.52855, 34.39567], [-119.5289, 34.39581]]], [[[-119.52817, 34.39735], [-119.52805, 34.39762], [-119.52771, 34.39836], [-119.52732, 34.39804], [-119.52817, 34.39735]]]]} | Restricted Access 2 | 4493 | Carpinteria Salt Marsh Reserve | 16899 | 1047 | Carpinteria, City of 72 | City 2 | City Agency 2 | http://www.carpinteria.ca.us/parks_rec/index.shtml | City 2 | 1047 | Carpinteria, City of 70 | City 2 | City Agency 2 | Santa Barbara 7 | 5.768 | Carpinteria Salt Marsh Reserve | 0 | Local Conservation Area 4 | 2 | |
4076 | 4076 | 4075 | {"type": "Polygon", "coordinates": [[[-117.31001, 33.92395], [-117.30137, 33.92978], [-117.30137, 33.92978], [-117.30137, 33.9295], [-117.30959, 33.92395], [-117.31001, 33.92395]]]} | Open Access 1 | 47102 | Sycamore Canyon Wilderness Park | 30758 | 2078 | Metropolitan Water District of Southern California 413 | Special District 4 | Water District 13 | http://www.mwdh2o.com/ | Special District 4 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 6.045 | Sycamore Canyon Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
12219 | 12219 | 12218 | {"type": "Polygon", "coordinates": [[[-123.79557, 39.44475], [-123.79553, 39.44475], [-123.79546, 39.44488], [-123.79492, 39.44513], [-123.79494, 39.4454], [-123.79333, 39.4454], [-123.79327, 39.4443], [-123.79328, 39.44402], [-123.79347, 39.44402], [-123.79348, 39.44405], [-123.79384, 39.44405], [-123.79385, 39.4441], [-123.79413, 39.44409], [-123.79414, 39.44415], [-123.79491, 39.44414], [-123.79491, 39.44408], [-123.79531, 39.44407], [-123.79532, 39.4442], [-123.79557, 39.4442], [-123.79557, 39.44475]]]} | Open Access 1 | 25413 | Otis R. Johnson Wilderness Park | 23267 | 1412 | Fort Bragg, City of 889 | City 2 | City Agency 2 | http://city.fortbragg.com/ | City 2 | 1412 | Fort Bragg, City of 864 | City 2 | City Agency 2 | Mendocino 24 | 6.276 | Otis R. Johnson Wilderness Park | 0 | Local Conservation Area 4 | 2 |
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]);