units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
14 rows where COUNTY = 7, DES_TP = 3 and MNG_AG_TYP = 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
177 | 177 | 176 | {"type": "Polygon", "coordinates": [[[-119.74164, 34.43295], [-119.74153, 34.43576], [-119.73893, 34.43575], [-119.73887, 34.43693], [-119.73869, 34.43693], [-119.73853, 34.43695], [-119.73837, 34.437], [-119.73822, 34.43708], [-119.73804, 34.43724], [-119.73783, 34.43753], [-119.73766, 34.43766], [-119.73751, 34.43772], [-119.73402, 34.43838], [-119.73394, 34.43798], [-119.73391, 34.43769], [-119.73392, 34.43573], [-119.73369, 34.43572], [-119.73366, 34.43384], [-119.73517, 34.43387], [-119.73518, 34.43141], [-119.73888, 34.43138], [-119.73888, 34.42908], [-119.73969, 34.42935], [-119.74016, 34.42954], [-119.74079, 34.42982], [-119.7407, 34.4325], [-119.74164, 34.43295]]]} | Restricted Access 2 | 492 | Santa Barbara Golf Club | 32988 | 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 | 110.039 | Santa Barbara Golf Club | 0 | Local Recreation Area 3 | 4 | |
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 | |
285 | 285 | 284 | {"type": "MultiPolygon", "coordinates": [[[[-119.69069, 34.44329], [-119.69064, 34.4434], [-119.69065, 34.44355], [-119.69068, 34.44362], [-119.69097, 34.44402], [-119.69099, 34.44413], [-119.69098, 34.44422], [-119.69094, 34.4443], [-119.69087, 34.44436], [-119.69029, 34.44464], [-119.69015, 34.44481], [-119.69015, 34.44384], [-119.68972, 34.44402], [-119.68956, 34.44406], [-119.68939, 34.44408], [-119.68783, 34.44396], [-119.68772, 34.44393], [-119.6876, 34.44389], [-119.68726, 34.44363], [-119.68703, 34.44354], [-119.68683, 34.4435], [-119.68629, 34.44347], [-119.68596, 34.4434], [-119.68596, 34.44324], [-119.68632, 34.44331], [-119.6869, 34.44334], [-119.6871, 34.44338], [-119.6873, 34.44346], [-119.68745, 34.44355], [-119.68767, 34.44372], [-119.68782, 34.44378], [-119.68937, 34.44392], [-119.68964, 34.44387], [-119.69015, 34.44364], [-119.69013, 34.44286], [-119.69069, 34.44329]]], [[[-119.69482, 34.44571], [-119.69452, 34.44628], [-119.69438, 34.44643], [-119.69253, 34.44663], [-119.69154, 34.4466], [-119.69056, 34.44614], [-119.69014, 34.44596], [-119.69015, 34.44498], [-119.69037, 34.44471], [-119.69094, 34.44446], [-119.69102, 34.4444], [-119.69109, 34.44429], [-119.69113, 34.44416], [-119.6911, 34.444], [-119.6908, 34.44353], [-119.69078, 34.44345], [-119.6908, 34.44337], [-119.69144, 34.44386], [-119.69193, 34.44417], [-119.69239, 34.44438], [-119.6932, 34.44461], [-119.69391, 34.4449], [-119.69482, 34.44571]]]]} | Unknown Access 4 | 777 | Sheffield Reservoir | 25382 | 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 | 26.245 | Sheffield Reservoir | 0 | Local Recreation Area 3 | 4 | |
2581 | 2581 | 2580 | {"type": "Polygon", "coordinates": [[[-119.66557, 34.42181], [-119.6652, 34.42296], [-119.66446, 34.42284], [-119.66145, 34.42302], [-119.66143, 34.42284], [-119.66412, 34.42212], [-119.66557, 34.42181]]]} | Unknown Access 4 | 17913 | Montecity Country Club | 22411 | 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 | 6.027 | Montecity Country Club | 0 | Local Recreation Area 3 | 4 | |
8645 | 8645 | 8644 | {"type": "Polygon", "coordinates": [[[-119.84198, 34.43602], [-119.84029, 34.43629], [-119.84059, 34.43759], [-119.83711, 34.43794], [-119.8371, 34.43824], [-119.83253, 34.43871], [-119.83248, 34.43844], [-119.83238, 34.43817], [-119.83224, 34.43792], [-119.83216, 34.43781], [-119.83206, 34.4377], [-119.83185, 34.43751], [-119.8314, 34.43726], [-119.83139, 34.43653], [-119.83079, 34.43653], [-119.83079, 34.43627], [-119.83084, 34.43621], [-119.8316, 34.43584], [-119.83163, 34.43585], [-119.83209, 34.43564], [-119.83212, 34.43565], [-119.83313, 34.4352], [-119.83403, 34.43483], [-119.83675, 34.43411], [-119.84127, 34.43296], [-119.84152, 34.43404], [-119.84073, 34.43425], [-119.83908, 34.43451], [-119.83912, 34.43479], [-119.83853, 34.43491], [-119.83884, 34.43629], [-119.84193, 34.4358], [-119.84198, 34.43602]]]} | Restricted Access 2 | 1483 | Twin Lakes Golf Course | 32998 | 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 | 81.664 | Twin Lakes GC | 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 | |
9729 | 9729 | 9728 | {"type": "Polygon", "coordinates": [[[-119.6934, 34.52036], [-119.6934, 34.52221], [-119.69115, 34.52218], [-119.69114, 34.52754], [-119.68866, 34.52752], [-119.68705, 34.52781], [-119.68501, 34.52954], [-119.68622, 34.53066], [-119.68472, 34.53039], [-119.68386, 34.53133], [-119.67969, 34.53036], [-119.67781, 34.52923], [-119.67491, 34.5293], [-119.67149, 34.52698], [-119.66811, 34.52495], [-119.66732, 34.52538], [-119.66722, 34.52689], [-119.66577, 34.52755], [-119.6666, 34.52867], [-119.66618, 34.53081], [-119.66796, 34.53221], [-119.66763, 34.53302], [-119.6658, 34.53325], [-119.66514, 34.53309], [-119.6664, 34.53236], [-119.66561, 34.53143], [-119.66599, 34.5291], [-119.66389, 34.52704], [-119.65995, 34.52669], [-119.65741, 34.52878], [-119.65352, 34.52894], [-119.65144, 34.5286], [-119.64741, 34.52628], [-119.64605, 34.52516], [-119.64503, 34.52343], [-119.64467, 34.52235], [-119.64306, 34.52303], [-119.64129, 34.52278], [-119.63968, 34.52275], [-119.63712, 34.52172], [-119.63329, 34.52084], [-119.63247, 34.52217], [-119.63085, 34.52238], [-119.6296, 34.52313], [-119.6276, 34.52426], [-119.62715, 34.52608], [-119.63044, 34.52831], [-119.63085, 34.52999], [-119.6308, 34.53047], [-119.63135, 34.53015], [-119.63372, 34.5296], [-119.63515, 34.52996], [-119.63677, 34.53112], [-119.63734, 34.53289], [-119.6381, 34.53317], [-119.6361, 34.53433], [-119.63547, 34.53506], [-119.63983, 34.53544], [-119.63879, 34.53598], [-119.63742, 34.53615], [-119.63701, 34.53779], [-119.63555, 34.53873], [-119.63561, 34.53935], [-119.6374, 34.53989], [-119.63713, 34.54123], [-119.63743, 34.54178], [-119.63794, 34.54182], [-119.63831, 34.54016], [-119.63944, 34.53981], [-119.6405, 34.53968], [-119.64324, 34.54248], [-119.64332, 34.54352], [-119.6421, 34.5457], [-119.64226, 34.54683], [-119.64087, 34.54775], [-119.63885, 34.54829], [-119.63962, 34.54693], [-119.63881, 34.5462], [-119.64092, 34.54371], [-119.64035, 34.54314], [-119.63908, 34.54288], [-119.63751, 34.54389], [-119.63537, 34.54242], [-119.63522, 34.54073], [-119.63257, 34.53803], [-119.63146, 34.53994], [-119.63076, 34.54022], [-119.63073, 34.54045], [-119.63118, 34.54086], [-119.63118, 34.54213], [-119.62993, 34.54216], [-119.62822, 34.54155], [-119.62802, 34.54172], [-119.62753, 34.54121], [-119.62714, 34.54119], [-119.62678, 34.54204], [-119.62777, 34.54251], [-119.62947, 34.54367], [-119.6322, 34.54523], [-119.62971, 34.5449], [-119.6297, 34.54575], [-119.62938, 34.54761], [-119.62813, 34.54806], [-119.62443, 34.54676], [-119.62415, 34.54673], [-119.62367, 34.54769], [-119.6237, 34.54853], [-119.62276, 34.54962], [-119.62247, 34.54963], [-119.62297, 34.54569], [-119.62344, 34.54558], [-119.62792, 34.54657], [-119.62826, 34.54627], [-119.62775, 34.54505], [-119.62729, 34.54434], [-119.62493, 34.54437], [-119.62428, 34.5438], [-119.62417, 34.54201], [-119.62251, 34.54055], [-119.62356, 34.53906], [-119.6255, 34.5396], [-119.62721, 34.53891], [-119.62817, 34.53927], [-119.62953, 34.53924], [-119.62954, 34.53923], [-119.62905, 34.53753], [-119.62803, 34.53661], [-119.62703, 34.53618], [-119.62609, 34.53623], [-119.6254, 34.53551], [-119.62507, 34.53642], [-119.62395, 34.53586], [-119.6233, 34.53588], [-119.62223, 34.53672], [-119.62191, 34.53556], [-119.62609, 34.53399], [-119.6265, 34.53111], [-119.63041, 34.53065], [-119.63054, 34.53006], [-119.63017, 34.52838], [-119.62687, 34.52621], [-119.62739, 34.52412], [-119.62832, 34.52354], [-119.62979, 34.5228], [-119.63073, 34.52222], [-119.63239, 34.52191], [-119.63266, 34.52094], [-119.63222, 34.51907], [-119.63374, 34.51892], [-119.63539, 34.51883], [-119.63861, 34.51929], [-119.64019, 34.5204], [-119.64043, 34.51992], [-119.6408, 34.52076], [-119.64154, 34.52053], [-119.64505, 34.52033], [-119.64689, 34.52171], [-119.6484, 34.5232], [-119.65019, 34.5264], [-119.65259, 34.52569], [-119.65347, 34.5265], [-119.65703, 34.5285], [-119.65784, 34.52777], [-119.65784, 34.52672], [-119.65831, 34.52707], [-119.66009, 34.52521], [-119.66441, 34.52522], [-119.66858, 34.52383], [-119.67364, 34.526], [-119.67425, 34.52593], [-119.67374, 34.52267], [-119.66995, 34.51894], [-119.67134, 34.51923], [-119.67499, 34.52215], [-119.67562, 34.52267], [-119.67459, 34.52272], [-119.67473, 34.52671], [-119.68072, 34.52912], [-119.68307, 34.52908], [-119.68435, 34.52755], [-119.68434, 34.52753], [-119.68241, 34.52753], [-119.68242, 34.52388], [-119.68457, 34.52388], [-119.68458, 34.52035], [-119.6934, 34.52036]]]} | Unknown Access 4 | 16478 | Gibraltar Reservoir | 19290 | 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 | https://www.santabarbaraca.gov/gov/depts/pw/resources/system/sources/gibraltar.asp | Santa Barbara 7 | 925.313 | Gibraltar Reservoir | 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 | |
14580 | 14580 | 14579 | {"type": "Polygon", "coordinates": [[[-120.42858, 34.92107], [-120.42838, 34.92118], [-120.4282, 34.92135], [-120.42815, 34.92137], [-120.42777, 34.92127], [-120.42747, 34.92122], [-120.42583, 34.9211], [-120.42574, 34.92107], [-120.42569, 34.92102], [-120.42563, 34.92091], [-120.42554, 34.92065], [-120.42551, 34.92051], [-120.42549, 34.92037], [-120.42543, 34.91899], [-120.4272, 34.91903], [-120.42719, 34.92015], [-120.42858, 34.92016], [-120.42858, 34.92107]]]} | Restricted Access 2 | 48290 | Crossroads Open Space | 32864 | 1322 | Santa Maria, City of 36 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | Santa Barbara 7 | 12.815 | Crossroads OS | 0 | Local Recreation Area 3 | 4 | |
14754 | 14754 | 14753 | {"type": "Polygon", "coordinates": [[[-120.12471, 34.60687], [-120.12345, 34.60767], [-120.12316, 34.60789], [-120.12289, 34.60815], [-120.12264, 34.60842], [-120.12242, 34.60872], [-120.12223, 34.60903], [-120.12203, 34.60943], [-120.12205, 34.60685], [-120.12471, 34.60687]]]} | Open Access 1 | 45125 | Sunny Fields Park | 26003 | 1337 | Solvang, City of 81 | City 2 | City Agency 2 | http://www.cityofsolvang.com/index.php/departments/parks-a-recreation | City 2 | 1337 | Solvang, City of 79 | City 2 | City Agency 2 | Santa Barbara 7 | 6.694 | Sunny Fields Park | 0 | Local Recreation Area 3 | 4 | |
16023 | 16023 | 16022 | {"type": "Polygon", "coordinates": [[[-119.85084, 34.43435], [-119.85074, 34.43462], [-119.85038, 34.43485], [-119.85016, 34.43479], [-119.84985, 34.43431], [-119.84984, 34.43376], [-119.85033, 34.43355], [-119.85073, 34.43382], [-119.85084, 34.43435]]]} | Open Access 1 | 1905 | Willow Springs Open Space | 27587 | 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 | 2.391 | Willow Springs OS | 0 | Local Recreation Area 3 | 4 | |
16136 | 16136 | 16135 | {"type": "MultiPolygon", "coordinates": [[[[-119.59271, 34.47931], [-119.59269, 34.48657], [-119.58367, 34.48654], [-119.58372, 34.47933], [-119.59271, 34.47931]]], [[[-119.62072, 34.50833], [-119.62065, 34.51552], [-119.60181, 34.51552], [-119.59304, 34.51554], [-119.59303, 34.51191], [-119.5974, 34.5119], [-119.59739, 34.50834], [-119.6016, 34.50832], [-119.60165, 34.50104], [-119.6096, 34.5011], [-119.60959, 34.50472], [-119.61397, 34.50473], [-119.61397, 34.50831], [-119.62072, 34.50833]]]]} | Open Access 1 | 17439 | City Open Space | 17338 | 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 | 810.91 | City 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]);