units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
33 rows where ACCESS_TYP = 1, COUNTY = 7 and DES_TP = 3
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
217 | 217 | 216 | {"type": "MultiPolygon", "coordinates": [[[[-120.18693, 34.6078], [-120.18673, 34.60817], [-120.18627, 34.608], [-120.18648, 34.60763], [-120.18693, 34.6078]]], [[[-120.1886, 34.60795], [-120.18844, 34.60825], [-120.18779, 34.608], [-120.18796, 34.6077], [-120.1886, 34.60795]]]]} | Open Access 1 | 634 | Santa Ynez River Open Space | 25147 | 1036 | Buellton, City of 88 | City 2 | City Agency 2 | http://www.cityofbuellton.com/Parks&Rec/parks.asp | City 2 | 1036 | Buellton, City of 86 | City 2 | City Agency 2 | Santa Barbara 7 | 1.105 | Santa Ynez River OS | 0 | Local Recreation Area 3 | 4 | |
2429 | 2429 | 2428 | {"type": "Polygon", "coordinates": [[[-119.73275, 34.45416], [-119.73256, 34.45495], [-119.73033, 34.45569], [-119.73131, 34.45385], [-119.73248, 34.45385], [-119.73275, 34.45416]]]} | Open Access 1 | 17293 | Lauro Canyon Reservoir | 33319 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 6.232 | Lauro Canyon Reservoir | 0 | Local Recreation Area 3 | 4 | |
2615 | 2615 | 2614 | {"type": "Polygon", "coordinates": [[[-119.80483, 34.42522], [-119.80482, 34.42554], [-119.80247, 34.42582], [-119.8009, 34.42611], [-119.80039, 34.42613], [-119.79935, 34.42613], [-119.79881, 34.42614], [-119.79835, 34.42616], [-119.7981, 34.4262], [-119.79785, 34.42626], [-119.79761, 34.42634], [-119.79738, 34.42644], [-119.79607, 34.42714], [-119.7965, 34.42603], [-119.7965, 34.42592], [-119.79466, 34.42424], [-119.801, 34.42408], [-119.80117, 34.42409], [-119.80132, 34.42412], [-119.80156, 34.4242], [-119.80248, 34.42446], [-119.80249, 34.4255], [-119.80483, 34.42522]]]} | Open Access 1 | 17990 | More Mesa Open Space | 22473 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 36.882 | More Mesa OS | 0 | Local Recreation Area 3 | 4 | |
2616 | 2616 | 2615 | {"type": "Polygon", "coordinates": [[[-119.80757, 34.42522], [-119.80482, 34.42554], [-119.80483, 34.42523], [-119.80248, 34.4255], [-119.80248, 34.42446], [-119.8037, 34.42461], [-119.80398, 34.42462], [-119.80426, 34.4246], [-119.80465, 34.42455], [-119.80523, 34.4244], [-119.80659, 34.42394], [-119.80746, 34.4237], [-119.80757, 34.42522]]]} | Open Access 1 | 17994 | More Mesa Open Space | 22474 | 2141 | Santa Barbara Flood Control and Water Conserv. District 46 | Special District 4 | Flood District 8 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | Santa Barbara 7 | 13.532 | More Mesa OS | 0 | Local Recreation Area 3 | 4 | |
2864 | 2864 | 2863 | {"type": "Polygon", "coordinates": [[[-119.8955, 34.43359], [-119.89489, 34.4336], [-119.89507, 34.4334], [-119.89518, 34.43315], [-119.89502, 34.43276], [-119.89396, 34.43277], [-119.89349, 34.43308], [-119.89327, 34.43291], [-119.89312, 34.43283], [-119.89296, 34.43279], [-119.89279, 34.43277], [-119.89158, 34.43278], [-119.89147, 34.43278], [-119.89124, 34.43274], [-119.89246, 34.43273], [-119.89311, 34.43267], [-119.89548, 34.43263], [-119.8955, 34.43359]]]} | Open Access 1 | 1923 | Winchester I Open Space | 27618 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 2.191 | Winchester I OS | 0 | Local Recreation Area 3 | 4 | |
3823 | 3823 | 3822 | {"type": "Polygon", "coordinates": [[[-119.79655, 34.42798], [-119.79651, 34.42886], [-119.79611, 34.42884], [-119.79604, 34.4287], [-119.7958, 34.4284], [-119.79655, 34.42798]]]} | Open Access 1 | 35233 | Rhoads Open Space | 28548 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 1.01 | Rhoads OS | 0 | Local Recreation Area 3 | 4 | |
5504 | 5504 | 5503 | {"type": "Polygon", "coordinates": [[[-120.44562, 34.87516], [-120.4456, 34.87591], [-120.44401, 34.87591], [-120.44401, 34.87511], [-120.44418, 34.87512], [-120.44458, 34.87515], [-120.44562, 34.87516]]]} | Open Access 1 | 1135 | Stonebrook Open Space | 25882 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 3.08 | Stonebrook OS | 0 | Local Recreation Area 3 | 4 | |
6333 | 6333 | 6332 | {"type": "MultiPolygon", "coordinates": [[[[-119.81783, 34.44343], [-119.81777, 34.44362], [-119.81759, 34.44372], [-119.81675, 34.44373], [-119.81574, 34.44462], [-119.81576, 34.44491], [-119.81593, 34.4456], [-119.81594, 34.44587], [-119.81525, 34.44586], [-119.81511, 34.44584], [-119.81508, 34.44583], [-119.81506, 34.44578], [-119.81514, 34.44535], [-119.81518, 34.44473], [-119.8152, 34.44462], [-119.81527, 34.44446], [-119.81546, 34.44422], [-119.81556, 34.44403], [-119.81563, 34.4438], [-119.81568, 34.44357], [-119.81735, 34.44366], [-119.81742, 34.44341], [-119.81783, 34.44343]]], [[[-119.81606, 34.4464], [-119.81623, 34.44693], [-119.81622, 34.44703], [-119.81614, 34.44723], [-119.81604, 34.44766], [-119.81591, 34.4481], [-119.8159, 34.44838], [-119.816, 34.44868], [-119.81541, 34.44868], [-119.81543, 34.44863], [-119.81542, 34.44862], [-119.81444, 34.44862], [-119.81443, 34.44848], [-119.81445, 34.44835], [-119.81449, 34.44821], [-119.81456, 34.44809], [-119.81464, 34.44798], [-119.81475, 34.44789], [-119.815, 34.44774], [-119.8151, 34.44766], [-119.81521, 34.44752], [-119.81527, 34.44736], [-119.81529, 34.44719], [-119.81525, 34.44681], [-119.81518, 34.44658], [-119.81504, 34.44629], [-119.81501, 34.44616], [-119.81502, 34.44603], [-119.81506, 34.44601], [-119.81526, 34.44603], [-119.81573, 34.44602], [-119.81573, 34.4463], [-119.816, 34.44635], [-119.81606, 34.4464]]]]} | Open Access 1 | 1578 | University Circle Open Space | 26673 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 11.722 | University Circle OS | 0 | Local Recreation Area 3 | 4 | |
8562 | 8562 | 8561 | {"type": "Polygon", "coordinates": [[[-120.44506, 34.91474], [-120.44502, 34.91664], [-120.44479, 34.91663], [-120.44483, 34.91473], [-120.44506, 34.91474]]]} | Open Access 1 | 13574 | Santa Maria Valley Muli-Purpose Trail | 28709 | 2141 | Santa Barbara Flood Control and Water Conserv. District 46 | Special District 4 | Flood District 8 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | Santa Barbara 7 | 1.107 | Santa Maria Valley Muli-Purpose Trail | 0 | Local Recreation Area 3 | 4 | |
8687 | 8687 | 8686 | {"type": "MultiPolygon", "coordinates": [[[[-119.67017, 34.41907], [-119.66916, 34.41999], [-119.66802, 34.41916], [-119.66813, 34.41909], [-119.66819, 34.41908], [-119.66824, 34.41909], [-119.66837, 34.41922], [-119.6685, 34.4191], [-119.66837, 34.41896], [-119.66827, 34.41881], [-119.66819, 34.41851], [-119.66799, 34.41803], [-119.668, 34.41799], [-119.66805, 34.41796], [-119.66831, 34.41797], [-119.66916, 34.41832], [-119.67017, 34.41907]]], [[[-119.67083, 34.41956], [-119.67083, 34.41956], [-119.66952, 34.41992], [-119.67032, 34.41918], [-119.67083, 34.41956]]], [[[-119.67046, 34.4188], [-119.6703, 34.41894], [-119.6697, 34.41849], [-119.67033, 34.41874], [-119.67046, 34.4188]]], [[[-119.67166, 34.41932], [-119.67104, 34.4195], [-119.67046, 34.41906], [-119.67064, 34.41889], [-119.67166, 34.41932]]]]} | Open Access 1 | 14048 | Dwight Murphy Field | 18326 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 7.685 | Dwight Murphy Field | 0 | Local Recreation Area 3 | 4 | |
8755 | 8755 | 8754 | {"type": "MultiPolygon", "coordinates": [[[[-120.46631, 34.656], [-120.46631, 34.65631], [-120.46521, 34.65579], [-120.46496, 34.6557], [-120.46479, 34.65567], [-120.46441, 34.65564], [-120.46083, 34.65564], [-120.46084, 34.65536], [-120.46457, 34.65537], [-120.46477, 34.65539], [-120.46501, 34.65543], [-120.46528, 34.65552], [-120.46631, 34.656]]], [[[-120.47501, 34.65624], [-120.47501, 34.65677], [-120.47483, 34.65677], [-120.47481, 34.65667], [-120.47474, 34.65659], [-120.47464, 34.65654], [-120.47453, 34.65652], [-120.46659, 34.65645], [-120.4666, 34.65617], [-120.47501, 34.65624]]]]} | Open Access 1 | 14232 | East/West Channel Bike Path | 18387 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 9.863 | East/West Channel Bike Path | 0 | Local Recreation Area 3 | 4 | |
9316 | 9316 | 9315 | {"type": "Polygon", "coordinates": [[[-119.82494, 34.44682], [-119.82494, 34.44687], [-119.82461, 34.44687], [-119.82461, 34.4471], [-119.82386, 34.4471], [-119.82385, 34.44677], [-119.82334, 34.44673], [-119.82347, 34.44642], [-119.82408, 34.44613], [-119.82404, 34.44586], [-119.82411, 34.44586], [-119.82415, 34.44614], [-119.82474, 34.44618], [-119.82457, 34.4468], [-119.82494, 34.44682]]]} | Open Access 1 | 15524 | Emerald Terrace Open Space | 18619 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 2.426 | Emerald Terrace OS | 0 | Local Recreation Area 3 | 4 | |
9939 | 9939 | 9938 | {"type": "Polygon", "coordinates": [[[-119.81698, 34.44965], [-119.81663, 34.44988], [-119.81647, 34.45003], [-119.8159, 34.45065], [-119.81571, 34.45089], [-119.81557, 34.45112], [-119.81532, 34.45163], [-119.81511, 34.45195], [-119.81492, 34.45216], [-119.81442, 34.45265], [-119.81427, 34.45284], [-119.81423, 34.45285], [-119.81387, 34.45282], [-119.81409, 34.45242], [-119.81395, 34.45236], [-119.81373, 34.45275], [-119.81353, 34.45275], [-119.81478, 34.4516], [-119.81478, 34.45139], [-119.81522, 34.45138], [-119.81533, 34.45127], [-119.81473, 34.45053], [-119.81488, 34.44981], [-119.81506, 34.44943], [-119.81678, 34.44942], [-119.81698, 34.44965]]]} | Open Access 1 | 17098 | Kellogg Open Space | 20580 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 8.384 | Kellogg OS | 0 | Local Recreation Area 3 | 4 | |
9958 | 9958 | 9957 | {"type": "Polygon", "coordinates": [[[-119.88971, 34.44276], [-119.88954, 34.44277], [-119.88944, 34.44302], [-119.88909, 34.44301], [-119.88929, 34.44243], [-119.88971, 34.44243], [-119.88971, 34.44276]]]} | Open Access 1 | 17126 | Koarts Open Space | 20711 | 1121 | Goleta, City of 179 | City 2 | City Agency 2 | http://www.cityofgoleta.org/index.aspx?page=206 | City 2 | 1121 | Goleta, City of 175 | City 2 | City Agency 2 | Santa Barbara 7 | 0.641 | Koarts OS | 0 | Local Recreation Area 3 | 4 | |
10028 | 10028 | 10027 | {"type": "MultiPolygon", "coordinates": [[[[-119.72885, 34.45108], [-119.72869, 34.45118], [-119.72808, 34.45176], [-119.72821, 34.45247], [-119.72822, 34.4527], [-119.72775, 34.45265], [-119.72654, 34.45155], [-119.72624, 34.45093], [-119.72629, 34.45059], [-119.72885, 34.45108]]], [[[-119.7298, 34.45232], [-119.72966, 34.45236], [-119.72946, 34.45246], [-119.7293, 34.4526], [-119.72922, 34.45272], [-119.72913, 34.45293], [-119.72897, 34.45366], [-119.72882, 34.45333], [-119.72917, 34.45262], [-119.72938, 34.45233], [-119.7298, 34.45232]]], [[[-119.73102, 34.45204], [-119.73085, 34.45212], [-119.7306, 34.45217], [-119.73094, 34.45203], [-119.73102, 34.45204]]], [[[-119.73489, 34.45026], [-119.73432, 34.45069], [-119.73426, 34.4512], [-119.73445, 34.45128], [-119.73436, 34.45153], [-119.7337, 34.45212], [-119.73371, 34.45213], [-119.73403, 34.45213], [-119.73401, 34.45256], [-119.73401, 34.45385], [-119.73131, 34.45385], [-119.73197, 34.4526], [-119.73258, 34.45262], [-119.73345, 34.45095], [-119.73391, 34.45045], [-119.73409, 34.45008], [-119.73489, 34.45026]]]]} | Open Access 1 | 17290 | Lauro Canyon Reservoir | 33320 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 21.132 | Lauro Canyon Reservoir | 0 | Local Recreation Area 3 | 4 | |
10201 | 10201 | 10200 | {"type": "Polygon", "coordinates": [[[-119.80649, 34.43933], [-119.80639, 34.43966], [-119.80611, 34.44014], [-119.80558, 34.44021], [-119.80538, 34.44045], [-119.80531, 34.44096], [-119.80503, 34.44096], [-119.80508, 34.4404], [-119.80517, 34.44035], [-119.80527, 34.44028], [-119.80564, 34.43982], [-119.80575, 34.43961], [-119.8058, 34.43946], [-119.80581, 34.4393], [-119.80649, 34.43933]]]} | Open Access 1 | 35229 | Lassen Open Space | 28547 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/parks03.aspx?id=13252 | Santa Barbara 7 | 2.024 | Lassen OS | 0 | Local Recreation Area 3 | 4 |
10435 | 10435 | 10434 | {"type": "MultiPolygon", "coordinates": [[[[-119.86646, 34.4168], [-119.86644, 34.41722], [-119.86639, 34.41727], [-119.86446, 34.41727], [-119.86446, 34.41486], [-119.86644, 34.41486], [-119.86643, 34.41679], [-119.86646, 34.4168]]], [[[-119.8696, 34.41443], [-119.86827, 34.41444], [-119.86827, 34.41483], [-119.86794, 34.41484], [-119.86794, 34.41576], [-119.86827, 34.41577], [-119.86827, 34.41672], [-119.86775, 34.41672], [-119.86774, 34.41695], [-119.86712, 34.41729], [-119.86664, 34.41728], [-119.86665, 34.41384], [-119.86676, 34.41365], [-119.86692, 34.4135], [-119.86712, 34.41339], [-119.86731, 34.41333], [-119.86747, 34.41327], [-119.86761, 34.41318], [-119.86773, 34.41307], [-119.86783, 34.41294], [-119.86789, 34.41281], [-119.86797, 34.41246], [-119.86959, 34.4126], [-119.8696, 34.41443]]]]} | Open Access 1 | 1990 | Camino Corto Open Space | 16766 | 2049 | Isla Vista Recreation and Park District 174 | Special District 4 | Recreation/Parks District 4 | http://www.ivparks.org/ | Special District 4 | 2049 | Isla Vista Recreation and Park District 170 | Special District 4 | Recreation/Parks District 4 | Santa Barbara 7 | 33.509 | Camino Corto OS | 0 | Local Recreation Area 3 | 4 | |
13201 | 13201 | 13200 | {"type": "Polygon", "coordinates": [[[-119.80136, 34.43599], [-119.80122, 34.43578], [-119.80125, 34.43551], [-119.80131, 34.4355], [-119.80138, 34.43544], [-119.80144, 34.43543], [-119.80151, 34.43544], [-119.80177, 34.43554], [-119.8019, 34.43557], [-119.80203, 34.43557], [-119.80218, 34.43556], [-119.80222, 34.43559], [-119.8022, 34.43567], [-119.80216, 34.43575], [-119.8021, 34.43582], [-119.80202, 34.43587], [-119.80193, 34.4359], [-119.80149, 34.43595], [-119.80136, 34.43599]]]} | Open Access 1 | 35221 | Thunderbird Open Space | 28546 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 0.941 | Thunderbird OS | 0 | Local Recreation Area 3 | 4 | |
13896 | 13896 | 13895 | {"type": "Polygon", "coordinates": [[[-120.4206, 34.85883], [-120.42009, 34.85944], [-120.41983, 34.85913], [-120.41982, 34.85851], [-120.42033, 34.85851], [-120.42033, 34.85866], [-120.4206, 34.85883]]]} | Open Access 1 | 36498 | Domino Open Space | 28582 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/parks03.aspx?id=13428 | Santa Barbara 7 | 1.162 | Domino OS | 0 | Local Recreation Area 3 | 4 |
13938 | 13938 | 13937 | {"type": "Polygon", "coordinates": [[[-119.79733, 34.4284], [-119.79733, 34.42843], [-119.79698, 34.42842], [-119.79697, 34.42853], [-119.79653, 34.42852], [-119.79656, 34.42798], [-119.79693, 34.42778], [-119.79699, 34.42786], [-119.79698, 34.42839], [-119.79733, 34.4284]]]} | Open Access 1 | 36554 | Rhoads Open Space | 28548 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 0.759 | Rhoads OS | 0 | Local Recreation Area 3 | 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]);