units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
64 rows where MNG_AGENCY = 26 and MNG_AG_TYP = 2 sorted by ACRES
This data as json, copyable, CSV (advanced)
DES_TP 6
- Local Park 31
- Local Recreation Area 8
- Local Conservation Area 2
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency · 44 ✖
MNG_AGENCY 1
- Santa Barbara, City of · 44 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
362 | 362 | 361 | {"type": "Polygon", "coordinates": [[[-119.70786, 34.42217], [-119.70687, 34.42311], [-119.70648, 34.42283], [-119.70697, 34.42235], [-119.70623, 34.42182], [-119.70672, 34.42135], [-119.70786, 34.42217]]]} | Open Access 1 | 1024 | Spencer Adams Park | 25720 | 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 | 3.179 | Spencer Adams Park | 0 | Local Park 2 | 4 | |
10547 | 10547 | 10546 | {"type": "Polygon", "coordinates": [[[-119.71388, 34.41721], [-119.71339, 34.41767], [-119.71312, 34.41748], [-119.71262, 34.41794], [-119.71134, 34.41701], [-119.71188, 34.41649], [-119.71202, 34.41659], [-119.71201, 34.41661], [-119.71215, 34.41671], [-119.71209, 34.41678], [-119.71222, 34.41688], [-119.71221, 34.41691], [-119.71233, 34.417], [-119.7124, 34.41695], [-119.71296, 34.41736], [-119.71345, 34.41689], [-119.71388, 34.41721]]]} | Open Access 1 | 18761 | Bohnett Park | 16234 | 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 | 3.582 | Bohnett Park | 0 | Local Park 2 | 4 | |
369 | 369 | 368 | {"type": "Polygon", "coordinates": [[[-119.68907, 34.41202], [-119.68898, 34.41211], [-119.68591, 34.4101], [-119.68566, 34.4102], [-119.68603, 34.41089], [-119.68588, 34.41095], [-119.68479, 34.4089], [-119.68484, 34.40798], [-119.68506, 34.40798], [-119.68505, 34.40854], [-119.68573, 34.40979], [-119.68586, 34.40987], [-119.68596, 34.40982], [-119.68651, 34.41019], [-119.68643, 34.41029], [-119.68643, 34.4103], [-119.68907, 34.41202]]]} | Open Access 1 | 1083 | Stearns Wharf | 25815 | 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 | 3.868 | Stearns Wharf | None 37 | |||
10373 | 10373 | 10372 | {"type": "MultiPolygon", "coordinates": [[[[-119.70584, 34.4382], [-119.70455, 34.43838], [-119.70355, 34.43837], [-119.70346, 34.43833], [-119.70343, 34.43825], [-119.70343, 34.43822], [-119.7035, 34.43807], [-119.70359, 34.43794], [-119.70368, 34.43787], [-119.70382, 34.43784], [-119.70584, 34.4382]]], [[[-119.70624, 34.43759], [-119.70606, 34.43805], [-119.70399, 34.43771], [-119.70396, 34.43769], [-119.70395, 34.43765], [-119.70396, 34.4376], [-119.7044, 34.43724], [-119.70495, 34.43742], [-119.70575, 34.43752], [-119.70576, 34.43759], [-119.70624, 34.43759]]]]} | Open Access 1 | 18313 | Orpet Park | 23223 | 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 | 4.385 | Orpet Park | 0 | Local Park 2 | 4 | |
6197 | 6197 | 6196 | {"type": "Polygon", "coordinates": [[[-119.67538, 34.41624], [-119.67378, 34.41777], [-119.67247, 34.41684], [-119.67247, 34.41683], [-119.67538, 34.41624]]]} | Open Access 1 | 1236 | Cabrillo Bell Park | 16636 | 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 | 4.414 | Cabrillo Bell Park | 0 | Local Park 2 | 4 | |
5637 | 5637 | 5636 | {"type": "Polygon", "coordinates": [[[-119.70715, 34.42924], [-119.70617, 34.43016], [-119.70504, 34.42933], [-119.70601, 34.42841], [-119.70715, 34.42924]]]} | Open Access 1 | 1768 | Alice Keck Park Memorial Garden | 15360 | 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 | 4.663 | Alice Keck Park Memorial Garden | 0 | Local Park 2 | 4 | |
10376 | 10376 | 10375 | {"type": "Polygon", "coordinates": [[[-119.69114, 34.42502], [-119.69001, 34.42608], [-119.68889, 34.42526], [-119.69003, 34.42419], [-119.69114, 34.42502]]]} | Open Access 1 | 18317 | Ortega Park | 23226 | 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 | 5.35 | Ortega Park | 0 | Local Park 2 | 4 | |
2769 | 2769 | 2768 | {"type": "Polygon", "coordinates": [[[-119.69755, 34.409], [-119.6969, 34.40961], [-119.69661, 34.4094], [-119.69628, 34.40971], [-119.69508, 34.40884], [-119.69608, 34.40791], [-119.69755, 34.409]]]} | Open Access 1 | 18496 | Pershing Park | 23618 | 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 | 5.763 | Pershing Park | 0 | Local Park 2 | 4 | |
47 | 47 | 46 | {"type": "MultiPolygon", "coordinates": [[[[-119.70909, 34.44366], [-119.70909, 34.44415], [-119.70862, 34.44493], [-119.70858, 34.44547], [-119.70828, 34.44567], [-119.70821, 34.44594], [-119.70847, 34.44627], [-119.70848, 34.44649], [-119.70851, 34.44659], [-119.70826, 34.44655], [-119.70805, 34.44586], [-119.70711, 34.44467], [-119.70752, 34.44456], [-119.70909, 34.44366]]], [[[-119.71066, 34.44319], [-119.71065, 34.4436], [-119.71, 34.4436], [-119.70999, 34.44352], [-119.71046, 34.44304], [-119.71066, 34.44319]]]]} | Open Access 1 | 134 | Rocky Nook Park | 24543 | 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.0 | Rocky Nook Park | 0 | Local Park 2 | 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 | |
2810 | 2810 | 2809 | {"type": "Polygon", "coordinates": [[[-119.69855, 34.4095], [-119.69842, 34.40964], [-119.69608, 34.40791], [-119.69508, 34.40884], [-119.69458, 34.40847], [-119.69487, 34.4083], [-119.69505, 34.40813], [-119.69526, 34.40776], [-119.69509, 34.40772], [-119.69496, 34.40802], [-119.69475, 34.40822], [-119.69446, 34.40838], [-119.69407, 34.4081], [-119.69422, 34.40794], [-119.69435, 34.40773], [-119.69444, 34.4075], [-119.69448, 34.40738], [-119.69474, 34.40743], [-119.69492, 34.40763], [-119.6955, 34.40754], [-119.6957, 34.40752], [-119.69614, 34.40772], [-119.69676, 34.40788], [-119.69747, 34.40846], [-119.69826, 34.40917], [-119.6982, 34.40924], [-119.69855, 34.4095]]]} | Open Access 1 | 18644 | Plaza del Mar Park | 23779 | 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.277 | Plaza del Mar Park | 0 | Local Park 2 | 4 | |
9375 | 9375 | 9374 | {"type": "Polygon", "coordinates": [[[-119.72847, 34.41054], [-119.72834, 34.41074], [-119.72791, 34.41158], [-119.72565, 34.41096], [-119.72618, 34.40986], [-119.72627, 34.40989], [-119.72631, 34.40981], [-119.72847, 34.41054]]]} | Open Access 1 | 15685 | Escondido Park | 18712 | 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.274 | Escondido Park | 0 | Local Park 2 | 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 | |
9010 | 9010 | 9009 | {"type": "Polygon", "coordinates": [[[-119.7343, 34.41613], [-119.73406, 34.41714], [-119.73257, 34.41702], [-119.73165, 34.41638], [-119.73245, 34.41544], [-119.73233, 34.41537], [-119.7324, 34.41534], [-119.73246, 34.4153], [-119.73249, 34.41525], [-119.73251, 34.41518], [-119.7323, 34.41433], [-119.73236, 34.41425], [-119.73243, 34.41421], [-119.73249, 34.4142], [-119.73256, 34.41422], [-119.73262, 34.41427], [-119.73265, 34.41427], [-119.73287, 34.41495], [-119.73361, 34.41603], [-119.7343, 34.41613]]]} | Open Access 1 | 14915 | Elings Park | 18559 | 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 | 8.842 | Elings Park | 0 | Local Park 2 | 4 | |
10260 | 10260 | 10259 | {"type": "MultiPolygon", "coordinates": [[[[-119.70586, 34.4283], [-119.7049, 34.42922], [-119.70377, 34.4284], [-119.70473, 34.42748], [-119.70586, 34.4283]]], [[[-119.707, 34.42723], [-119.70599, 34.42818], [-119.70487, 34.42735], [-119.70587, 34.4264], [-119.707, 34.42723]]]]} | Open Access 1 | 17974 | Alameda Park | 15313 | 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 | 9.404 | Alameda Park | 0 | Local Park 2 | 4 | |
10085 | 10085 | 10084 | {"type": "Polygon", "coordinates": [[[-119.73402, 34.43961], [-119.73313, 34.43967], [-119.7328, 34.43975], [-119.73263, 34.43981], [-119.73234, 34.43995], [-119.73188, 34.44027], [-119.73082, 34.44026], [-119.7306, 34.44024], [-119.73006, 34.44013], [-119.73269, 34.43879], [-119.73244, 34.43842], [-119.73358, 34.43784], [-119.73362, 34.43784], [-119.73362, 34.43833], [-119.73392, 34.43888], [-119.73402, 34.43913], [-119.73402, 34.43961]]]} | Open Access 1 | 17507 | Mackenzie Park | 21636 | 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 | 9.591 | Mackenzie Park | 0 | Local Park 2 | 4 | |
2568 | 2568 | 2567 | {"type": "MultiPolygon", "coordinates": [[[[-119.71235, 34.43717], [-119.71239, 34.43727], [-119.71242, 34.43741], [-119.71236, 34.43784], [-119.71238, 34.43805], [-119.71242, 34.43818], [-119.71249, 34.43831], [-119.71277, 34.43863], [-119.71287, 34.43882], [-119.7129, 34.43896], [-119.71292, 34.4391], [-119.71289, 34.43922], [-119.71284, 34.43934], [-119.71275, 34.43944], [-119.71264, 34.43952], [-119.71251, 34.43957], [-119.71237, 34.43958], [-119.7122, 34.43955], [-119.71208, 34.43948], [-119.7116, 34.43929], [-119.71145, 34.43926], [-119.71108, 34.43926], [-119.71107, 34.43818], [-119.71119, 34.43793], [-119.71137, 34.43759], [-119.71141, 34.43755], [-119.71152, 34.4375], [-119.71158, 34.43745], [-119.71161, 34.43737], [-119.71161, 34.43726], [-119.71163, 34.4372], [-119.71188, 34.43689], [-119.71194, 34.43689], [-119.71235, 34.43717]]], [[[-119.71303, 34.43937], [-119.71304, 34.43947], [-119.71301, 34.43961], [-119.71273, 34.44012], [-119.71272, 34.44021], [-119.71228, 34.44022], [-119.71217, 34.44025], [-119.71191, 34.44045], [-119.71188, 34.44029], [-119.71184, 34.44019], [-119.71172, 34.44003], [-119.71127, 34.43969], [-119.71117, 34.43965], [-119.71108, 34.43965], [-119.71108, 34.4394], [-119.7114, 34.43941], [-119.71158, 34.43945], [-119.7122, 34.43971], [-119.71233, 34.43973], [-119.71252, 34.43973], [-119.7127, 34.43967], [-119.71282, 34.4396], [-119.71296, 34.43947], [-119.71303, 34.43937]]]]} | Open Access 1 | 17851 | Mission Park | 22305 | 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 | 10.435 | Mission Park | 0 | Local Park 2 | 4 | |
4846 | 4846 | 4845 | {"type": "MultiPolygon", "coordinates": [[[[-119.73568, 34.45038], [-119.73544, 34.45039], [-119.73544, 34.45079], [-119.73524, 34.45095], [-119.73485, 34.45159], [-119.73481, 34.45214], [-119.73369, 34.45213], [-119.73436, 34.45153], [-119.73445, 34.45128], [-119.73426, 34.45121], [-119.73432, 34.45069], [-119.73489, 34.45026], [-119.73488, 34.44987], [-119.73564, 34.45003], [-119.73568, 34.45038]]], [[[-119.73562, 34.44978], [-119.73477, 34.44958], [-119.73475, 34.44943], [-119.73453, 34.4491], [-119.73428, 34.44881], [-119.73413, 34.44825], [-119.73413, 34.44798], [-119.73429, 34.44771], [-119.73453, 34.44745], [-119.73478, 34.44691], [-119.73504, 34.44659], [-119.7351, 34.44647], [-119.73546, 34.44662], [-119.73554, 34.4467], [-119.73559, 34.44682], [-119.73559, 34.44688], [-119.73527, 34.44708], [-119.73525, 34.44735], [-119.73516, 34.44757], [-119.73518, 34.44818], [-119.73517, 34.4484], [-119.73526, 34.44867], [-119.73549, 34.44928], [-119.73551, 34.44941], [-119.73562, 34.44964], [-119.73562, 34.44978]]]]} | Open Access 1 | 1101 | Stevens Park | 25842 | 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 | 11.199 | Stevens Park | 0 | Local Park 2 | 4 | |
9105 | 9105 | 9104 | {"type": "Polygon", "coordinates": [[[-119.66149, 34.43582], [-119.6613, 34.43592], [-119.66056, 34.43591], [-119.66024, 34.43602], [-119.65968, 34.43602], [-119.65934, 34.43618], [-119.65904, 34.43601], [-119.65885, 34.43601], [-119.65652, 34.4347], [-119.6564, 34.43449], [-119.65633, 34.43428], [-119.65646, 34.43417], [-119.65655, 34.43403], [-119.65657, 34.43391], [-119.65657, 34.43343], [-119.65695, 34.43342], [-119.6577, 34.43379], [-119.65812, 34.43422], [-119.65823, 34.4345], [-119.65885, 34.43497], [-119.65907, 34.4351], [-119.6598, 34.43512], [-119.66101, 34.43551], [-119.66149, 34.43582]]]} | Open Access 1 | 16721 | Hale Park | 19604 | 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 | 12.798 | Hale Park | 0 | Local Park 2 | 4 | |
297 | 297 | 296 | {"type": "Polygon", "coordinates": [[[-119.71194, 34.39632], [-119.71076, 34.3961], [-119.71039, 34.39606], [-119.71001, 34.39605], [-119.70963, 34.39607], [-119.70926, 34.39613], [-119.708, 34.39646], [-119.70506, 34.39741], [-119.70451, 34.39762], [-119.70425, 34.39775], [-119.704, 34.39789], [-119.70366, 34.39813], [-119.70336, 34.3984], [-119.70316, 34.39859], [-119.70284, 34.39905], [-119.70263, 34.39947], [-119.70247, 34.39937], [-119.70254, 34.39925], [-119.70255, 34.39906], [-119.70237, 34.39872], [-119.70238, 34.39865], [-119.70232, 34.39849], [-119.70223, 34.39836], [-119.70222, 34.39829], [-119.70226, 34.39829], [-119.7023, 34.39826], [-119.70267, 34.39796], [-119.70303, 34.39798], [-119.70348, 34.39764], [-119.70359, 34.39749], [-119.70367, 34.39741], [-119.70378, 34.39733], [-119.7039, 34.39728], [-119.7041, 34.39723], [-119.70522, 34.39684], [-119.70576, 34.39662], [-119.70624, 34.3965], [-119.70827, 34.39576], [-119.70851, 34.3958], [-119.70907, 34.39583], [-119.71027, 34.39574], [-119.71077, 34.39576], [-119.71113, 34.39574], [-119.71149, 34.39568], [-119.71178, 34.39567], [-119.71194, 34.39632]]]} | Open Access 1 | 801 | Shoreline Park | 25428 | 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 | 13.242 | Shoreline 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]);