units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
119 rows where MNG_AGENCY = 7 sorted by map
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, LAYER, PARK_URL, YR_EST, GAP_STS
DES_TP 19
- Local Park 40
- Local Other or Unknown 39
- Local Recreation Area 19
- Local Conservation Area 5
- Local Historic or Cultural Area 2
- National Forest 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
AGNCY_TYP 3 ✖
AGNCY_LEV 3 ✖
- County 117
- Federal 1
- Non Profit 1
ACCESS_TYP 3
- Open Access 105
- Unknown Access 13
- No Public Access 1
MNG_AG_TYP 1
- County Agency 119
MNG_AGENCY 1
- Santa Barbara, County of · 119 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12076 | 12076 | 12075 | {"type": "MultiPolygon", "coordinates": [[[[-119.49113, 34.38394], [-119.49018, 34.38353], [-119.48928, 34.38316], [-119.48874, 34.38294], [-119.4887, 34.38297], [-119.48587, 34.38181], [-119.48585, 34.38182], [-119.48585, 34.38197], [-119.48547, 34.38191], [-119.48525, 34.38189], [-119.48507, 34.38182], [-119.48461, 34.38158], [-119.48317, 34.38072], [-119.48295, 34.38057], [-119.48265, 34.38032], [-119.48257, 34.37997], [-119.48284, 34.37978], [-119.48341, 34.38015], [-119.4847, 34.38087], [-119.48556, 34.38134], [-119.48575, 34.3814], [-119.48586, 34.38165], [-119.48688, 34.38192], [-119.48717, 34.38203], [-119.48886, 34.3828], [-119.49112, 34.38376], [-119.49113, 34.38394]]], [[[-119.48494, 34.3819], [-119.4849, 34.38276], [-119.48484, 34.38275], [-119.48442, 34.38253], [-119.48423, 34.38229], [-119.4842, 34.3821], [-119.48406, 34.38198], [-119.4838, 34.38212], [-119.48369, 34.38198], [-119.48347, 34.38155], [-119.48354, 34.38146], [-119.48428, 34.38172], [-119.48494, 34.3819]]]]} | Open Access 1 | 24843 | Rincon Beach Park | 24367 | 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 | 10.748 | Rincon Beach Park | 0 | Local Park 2 | 4 | |
6620 | 6620 | 6619 | {"type": "MultiPolygon", "coordinates": [[[[-119.50852, 34.39516], [-119.50697, 34.39588], [-119.50689, 34.39577], [-119.5075, 34.3955], [-119.50841, 34.395], [-119.50852, 34.39516]]], [[[-119.50986, 34.39487], [-119.50965, 34.39489], [-119.50944, 34.39484], [-119.50927, 34.39472], [-119.50912, 34.39453], [-119.50904, 34.39446], [-119.50888, 34.39438], [-119.50873, 34.39436], [-119.5086, 34.39437], [-119.50821, 34.39482], [-119.50804, 34.39483], [-119.50784, 34.39456], [-119.50791, 34.39452], [-119.50809, 34.39429], [-119.50817, 34.39415], [-119.50814, 34.39411], [-119.50831, 34.39392], [-119.50859, 34.39368], [-119.50859, 34.3931], [-119.50876, 34.39344], [-119.50894, 34.39363], [-119.50974, 34.39478], [-119.5098, 34.39476], [-119.50986, 34.39487]]]]} | Unknown Access 4 | 4305 | Carpinteria Creek | 16896 | 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.634 | Carpinteria Creek | 0 | Local Other or Unknown 14 | 4 | |
2498 | 2498 | 2497 | {"type": "MultiPolygon", "coordinates": [[[[-119.63205, 34.43527], [-119.631, 34.43526], [-119.63141, 34.43312], [-119.63141, 34.43311], [-119.63134, 34.4331], [-119.63134, 34.43283], [-119.63179, 34.43283], [-119.6318, 34.43303], [-119.63183, 34.43323], [-119.63201, 34.43386], [-119.63205, 34.43527]]], [[[-119.63427, 34.43281], [-119.63426, 34.43526], [-119.63224, 34.43526], [-119.63225, 34.43427], [-119.63336, 34.43427], [-119.63339, 34.43368], [-119.63328, 34.43339], [-119.63369, 34.43334], [-119.63417, 34.43334], [-119.63418, 34.43281], [-119.63427, 34.43281]]]]} | Open Access 1 | 17533 | Manning Park | 21754 | 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.812 | Manning Park | 0 | Local Park 2 | 4 | |
5778 | 5778 | 5777 | {"type": "MultiPolygon", "coordinates": [[[[-119.68465, 34.9461], [-119.68467, 34.9462], [-119.68476, 34.94628], [-119.68484, 34.94629], [-119.68493, 34.94626], [-119.68498, 34.94626], [-119.68555, 34.9464], [-119.68558, 34.94642], [-119.68559, 34.94647], [-119.68554, 34.94654], [-119.68549, 34.94659], [-119.6854, 34.94662], [-119.68533, 34.94663], [-119.68495, 34.94653], [-119.6826, 34.94613], [-119.68251, 34.94609], [-119.68247, 34.94604], [-119.68244, 34.94597], [-119.68247, 34.94518], [-119.68244, 34.94507], [-119.68239, 34.94497], [-119.68169, 34.94424], [-119.68175, 34.9442], [-119.68175, 34.94419], [-119.67961, 34.942], [-119.68031, 34.942], [-119.68109, 34.94277], [-119.68079, 34.94299], [-119.68079, 34.943], [-119.68093, 34.94308], [-119.68118, 34.9429], [-119.68197, 34.94366], [-119.68211, 34.94375], [-119.68223, 34.94381], [-119.6824, 34.94387], [-119.68252, 34.94389], [-119.68346, 34.94392], [-119.68416, 34.94401], [-119.68382, 34.94527], [-119.68465, 34.9461]]], [[[-119.68606, 34.94635], [-119.68613, 34.94636], [-119.68619, 34.9464], [-119.68623, 34.94646], [-119.68623, 34.94653], [-119.68609, 34.94679], [-119.68602, 34.94683], [-119.68596, 34.94683], [-119.6859, 34.94681], [-119.68585, 34.94676], [-119.68583, 34.94666], [-119.68595, 34.94641], [-119.686, 34.94637], [-119.68606, 34.94635]]]]} | Open Access 1 | 33 | Richardson County Park | 24331 | 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 | 15.665 | Richardson County Park | 0 | Local Park 2 | 4 | |
4863 | 4863 | 4862 | {"type": "MultiPolygon", "coordinates": [[[[-119.70446, 34.41592], [-119.70424, 34.41613], [-119.70413, 34.41605], [-119.70419, 34.41599], [-119.70419, 34.41598], [-119.70404, 34.41596], [-119.70425, 34.41577], [-119.70446, 34.41592]]], [[[-119.70685, 34.41659], [-119.70669, 34.41678], [-119.7063, 34.4165], [-119.70614, 34.41646], [-119.70575, 34.41648], [-119.70547, 34.41645], [-119.70524, 34.41628], [-119.70536, 34.41617], [-119.70546, 34.41624], [-119.70567, 34.4163], [-119.70578, 34.41631], [-119.70609, 34.4163], [-119.70614, 34.41611], [-119.70651, 34.41638], [-119.70658, 34.4164], [-119.70685, 34.41659]]], [[[-119.70983, 34.41818], [-119.70962, 34.41838], [-119.70935, 34.41819], [-119.70897, 34.41794], [-119.70718, 34.41712], [-119.70694, 34.41694], [-119.70715, 34.41674], [-119.70759, 34.41702], [-119.70878, 34.41758], [-119.70922, 34.41781], [-119.70983, 34.41818]]], [[[-119.71422, 34.42244], [-119.71392, 34.42193], [-119.71369, 34.42125], [-119.71359, 34.42118], [-119.7136, 34.42116], [-119.71335, 34.42103], [-119.71095, 34.41928], [-119.71092, 34.41929], [-119.71027, 34.41881], [-119.71045, 34.41863], [-119.71376, 34.42102], [-119.71375, 34.42104], [-119.71445, 34.42169], [-119.71451, 34.42176], [-119.71457, 34.42188], [-119.71459, 34.422], [-119.71458, 34.42209], [-119.71452, 34.42226], [-119.71422, 34.42244]]], [[[-119.71602, 34.42306], [-119.71596, 34.42311], [-119.71571, 34.42293], [-119.71503, 34.42272], [-119.71492, 34.42281], [-119.71462, 34.42268], [-119.7148, 34.42245], [-119.71508, 34.42266], [-119.71527, 34.42272], [-119.71547, 34.42272], [-119.71565, 34.42277], [-119.71602, 34.42306]]], [[[-119.71871, 34.4248], [-119.71859, 34.42481], [-119.71853, 34.42497], [-119.7185, 34.42501], [-119.7185, 34.42485], [-119.71848, 34.42476], [-119.7184, 34.42456], [-119.71827, 34.42439], [-119.71817, 34.42433], [-119.71797, 34.4243], [-119.71792, 34.42426], [-119.71803, 34.42416], [-119.71837, 34.42443], [-119.71871, 34.4248]]], [[[-119.71973, 34.42579], [-119.71956, 34.42597], [-119.71905, 34.42559], [-119.71906, 34.42556], [-119.71868, 34.42528], [-119.71893, 34.42505], [-119.71881, 34.42495], [-119.71886, 34.42491], [-119.71973, 34.42579]]], [[[-119.72436, 34.42678], [-119.72408, 34.42674], [-119.7239, 34.42666], [-119.72379, 34.42667], [-119.72365, 34.42666], [-119.72345, 34.42659], [-119.72288, 34.42652], [-119.72194, 34.42634], [-119.72175, 34.42632], [-119.72189, 34.42619], [-119.72247, 34.42632], [-119.72345, 34.42645], [-119.7239, 34.42657], [-119.72436, 34.42678]]]]} | Unknown Access 4 | 14691 | El Mission Creek | 18513 | 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 | 9.467 | El Mission Creek | 0 | Local Other or Unknown 14 | 4 | |
9550 | 9550 | 9549 | {"type": "MultiPolygon", "coordinates": [[[[-119.72339, 34.47937], [-119.72111, 34.4794], [-119.71885, 34.47941], [-119.71888, 34.47208], [-119.72334, 34.47209], [-119.72338, 34.47575], [-119.72339, 34.47937]]], [[[-119.80972, 34.50416], [-119.80966, 34.50785], [-119.80547, 34.5078], [-119.80545, 34.50432], [-119.80812, 34.50393], [-119.80972, 34.50416]]], [[[-119.81406, 34.50423], [-119.81196, 34.50427], [-119.81084, 34.50398], [-119.80758, 34.50289], [-119.80766, 34.50278], [-119.80781, 34.5028], [-119.80796, 34.50274], [-119.80792, 34.50258], [-119.80819, 34.50271], [-119.80866, 34.50264], [-119.80881, 34.5028], [-119.809, 34.50274], [-119.80946, 34.50302], [-119.80998, 34.50301], [-119.81032, 34.50327], [-119.8111, 34.50311], [-119.81154, 34.50317], [-119.81198, 34.50302], [-119.81217, 34.50313], [-119.81252, 34.50405], [-119.81405, 34.50345], [-119.81406, 34.50423]]]]} | Open Access 1 | 17447 | Los Padres National Forest | 21523 | 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 | 132.963 | Los Padres NF | 1903 | National Forest 11 | 3 | |
6302 | 6302 | 6301 | {"type": "MultiPolygon", "coordinates": [[[[-119.77498, 34.46477], [-119.77385, 34.46839], [-119.7732, 34.46839], [-119.7732, 34.46911], [-119.77251, 34.46862], [-119.77253, 34.4683], [-119.77206, 34.46758], [-119.77217, 34.46752], [-119.77276, 34.46791], [-119.77295, 34.46775], [-119.77232, 34.46728], [-119.77183, 34.46712], [-119.77177, 34.46676], [-119.77187, 34.46645], [-119.77169, 34.46605], [-119.77173, 34.46528], [-119.7717, 34.46476], [-119.77498, 34.46477]]], [[[-119.79223, 34.45174], [-119.79173, 34.45211], [-119.79155, 34.45239], [-119.79156, 34.45359], [-119.78801, 34.45358], [-119.78801, 34.45266], [-119.78748, 34.45287], [-119.78717, 34.4529], [-119.78634, 34.45255], [-119.78598, 34.45255], [-119.78535, 34.4528], [-119.78534, 34.45312], [-119.78542, 34.45332], [-119.78467, 34.45356], [-119.78361, 34.45418], [-119.78415, 34.45508], [-119.7842, 34.4555], [-119.78334, 34.45629], [-119.78311, 34.4564], [-119.78266, 34.45669], [-119.78256, 34.45746], [-119.78194, 34.45821], [-119.78088, 34.45805], [-119.78023, 34.45787], [-119.77977, 34.45846], [-119.77982, 34.45869], [-119.77911, 34.4591], [-119.77894, 34.45964], [-119.77866, 34.46029], [-119.77817, 34.46051], [-119.7779, 34.46108], [-119.77607, 34.4611], [-119.77626, 34.46179], [-119.77563, 34.46273], [-119.77529, 34.46339], [-119.77525, 34.46378], [-119.7736, 34.46379], [-119.77361, 34.46204], [-119.77403, 34.46191], [-119.77527, 34.46129], [-119.77528, 34.46109], [-119.77689, 34.46017], [-119.77698, 34.45946], [-119.77737, 34.45886], [-119.77807, 34.45828], [-119.77827, 34.458], [-119.7784, 34.45778], [-119.77877, 34.45691], [-119.77871, 34.45682], [-119.77868, 34.45673], [-119.77881, 34.45668], [-119.77931, 34.45642], [-119.77997, 34.45631], [-119.7799, 34.45591], [-119.78001, 34.45558], [-119.78025, 34.45532], [-119.78111, 34.4551], [-119.78262, 34.45501], [-119.78226, 34.45446], [-119.78221, 34.45401], [-119.78235, 34.45374], [-119.78277, 34.45323], [-119.78296, 34.45324], [-119.7834, 34.45314], [-119.78403, 34.45269], [-119.78538, 34.45218], [-119.78598, 34.45216], [-119.78802, 34.45231], [-119.78803, 34.45225], [-119.78817, 34.4522], [-119.78839, 34.45202], [-119.78885, 34.45196], [-119.78908, 34.45179], [-119.78916, 34.45158], [-119.78939, 34.45148], [-119.78985, 34.45147], [-119.79014, 34.45164], [-119.79023, 34.45147], [-119.79094, 34.45169], [-119.79135, 34.45177], [-119.79223, 34.45174]]]]} | Open Access 1 | 1434 | Tuckers Grove Park | 26558 | 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 | 111.447 | Tuckers Grove Park | 0 | Local Park 2 | 4 | |
6729 | 6729 | 6728 | {"type": "MultiPolygon", "coordinates": [[[[-119.77531, 34.45209], [-119.77531, 34.45312], [-119.7686, 34.454], [-119.76861, 34.45071], [-119.76859, 34.44934], [-119.77006, 34.44971], [-119.77438, 34.45153], [-119.77495, 34.45195], [-119.77531, 34.45209]], [[-119.76965, 34.45139], [-119.76974, 34.4514], [-119.76981, 34.45116], [-119.76932, 34.4508], [-119.76873, 34.45061], [-119.76873, 34.45135], [-119.76877, 34.45142], [-119.7692, 34.45152], [-119.76925, 34.45137], [-119.76929, 34.45138], [-119.7693, 34.45136], [-119.76933, 34.45136], [-119.76934, 34.45134], [-119.76959, 34.45138], [-119.76963, 34.4514], [-119.76965, 34.45139]]], [[[-119.77683, 34.45222], [-119.77667, 34.45302], [-119.77675, 34.45338], [-119.77595, 34.45341], [-119.7759, 34.45326], [-119.77589, 34.45311], [-119.77602, 34.45211], [-119.77683, 34.45222]]]]} | Unknown Access 4 | 5091 | Cathedral Oaks Fire Center | 16974 | 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 | 51.634 | Cathedral Oaks Fire Ctr. | 0 | Local Recreation Area 3 | 4 | |
2224 | 2224 | 2223 | {"type": "MultiPolygon", "coordinates": [[[[-119.78067, 34.4404], [-119.78035, 34.4404], [-119.78034, 34.44016], [-119.78067, 34.44016], [-119.78067, 34.4404]]], [[[-119.78168, 34.43949], [-119.78168, 34.4396], [-119.78068, 34.4396], [-119.78068, 34.43949], [-119.78168, 34.43949]]]]} | Open Access 1 | 16611 | Goleta Cemetery | 19380 | 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.487 | Goleta Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
9811 | 9811 | 9810 | {"type": "MultiPolygon", "coordinates": [[[[-119.78388, 34.43252], [-119.78345, 34.43278], [-119.78231, 34.43354], [-119.78143, 34.43378], [-119.78052, 34.4337], [-119.78052, 34.43358], [-119.78135, 34.43364], [-119.78158, 34.43361], [-119.78213, 34.43346], [-119.78241, 34.43332], [-119.78376, 34.43242], [-119.78381, 34.43241], [-119.78385, 34.43243], [-119.78388, 34.43248], [-119.78388, 34.43252]]], [[[-119.79498, 34.42774], [-119.79162, 34.42959], [-119.7874, 34.43078], [-119.78626, 34.43109], [-119.78625, 34.43108], [-119.78589, 34.43127], [-119.78408, 34.43239], [-119.78411, 34.4321], [-119.78448, 34.43201], [-119.78536, 34.43149], [-119.78544, 34.43143], [-119.7857, 34.43115], [-119.7862, 34.43068], [-119.78689, 34.43049], [-119.78694, 34.43059], [-119.79145, 34.42935], [-119.79203, 34.42903], [-119.79202, 34.42901], [-119.79462, 34.42757], [-119.79483, 34.42761], [-119.79498, 34.42774]]]]} | Unknown Access 4 | 16760 | Atascadero Creek | 15661 | 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 | 9.641 | Atascadero Creek | 0 | Local Other or Unknown 14 | 4 | |
5884 | 5884 | 5883 | {"type": "MultiPolygon", "coordinates": [[[[-119.79426, 34.4463], [-119.79411, 34.44637], [-119.79361, 34.44738], [-119.79382, 34.4476], [-119.7938, 34.44786], [-119.79343, 34.44803], [-119.79298, 34.44802], [-119.79241, 34.44812], [-119.79224, 34.44837], [-119.79212, 34.44829], [-119.79226, 34.44801], [-119.7925, 34.44786], [-119.79254, 34.44769], [-119.79277, 34.44765], [-119.79284, 34.44779], [-119.79309, 34.44778], [-119.79324, 34.44775], [-119.79335, 34.44763], [-119.79341, 34.44749], [-119.79326, 34.44738], [-119.79339, 34.44722], [-119.79373, 34.44669], [-119.79374, 34.44663], [-119.79372, 34.44657], [-119.79404, 34.44609], [-119.79426, 34.4463]]], [[[-119.79691, 34.446], [-119.79567, 34.446], [-119.79525, 34.44612], [-119.79527, 34.44646], [-119.79515, 34.44653], [-119.79497, 34.44665], [-119.79437, 34.44639], [-119.79559, 34.44572], [-119.79691, 34.44574], [-119.79691, 34.446]]], [[[-119.80544, 34.44219], [-119.80546, 34.44288], [-119.80541, 34.44301], [-119.8053, 34.44297], [-119.80522, 34.44319], [-119.805, 34.44321], [-119.80514, 34.44286], [-119.80505, 34.44237], [-119.80464, 34.44245], [-119.80463, 34.44244], [-119.80339, 34.4427], [-119.80252, 34.44299], [-119.80242, 34.443], [-119.80218, 34.44295], [-119.80205, 34.44296], [-119.80193, 34.44301], [-119.80184, 34.4431], [-119.80166, 34.44341], [-119.80163, 34.44356], [-119.79959, 34.44377], [-119.79958, 34.44402], [-119.80165, 34.44381], [-119.80166, 34.44387], [-119.80164, 34.4439], [-119.80152, 34.444], [-119.80123, 34.44433], [-119.79955, 34.44431], [-119.79955, 34.44426], [-119.79932, 34.44426], [-119.79926, 34.44428], [-119.79891, 34.44452], [-119.79893, 34.44461], [-119.79879, 34.44464], [-119.79864, 34.44471], [-119.79829, 34.44493], [-119.79811, 34.44503], [-119.79791, 34.4451], [-119.7977, 34.44513], [-119.79719, 34.4451], [-119.79715, 34.44507], [-119.79716, 34.44489], [-119.79744, 34.44489], [-119.79768, 34.44487], [-119.79791, 34.44481], [-119.79813, 34.44471], [-119.79833, 34.44457], [-119.79906, 34.44389], [-119.79918, 34.44383], [-119.79934, 34.44379], [-119.79935, 34.44374], [-119.80041, 34.44361], [-119.8009, 34.44357], [-119.80091, 34.44337], [-119.80083, 34.44331], [-119.80078, 34.44324], [-119.80077, 34.44317], [-119.80078, 34.44304], [-119.80079, 34.44298], [-119.80084, 34.44291], [-119.80095, 34.44281], [-119.80101, 34.44277], [-119.8013, 34.44273], [-119.80157, 34.44261], [-119.80241, 34.44243], [-119.8022, 34.44256], [-119.80194, 34.44281], [-119.80286, 34.44279], [-119.80297, 34.44269], [-119.80544, 34.44219]]]]} | Unknown Access 4 | 290 | San Antonio Creek | 24828 | 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 | 12.836 | San Antonio Creek | 0 | Local Other or Unknown 14 | 4 | |
10124 | 10124 | 10123 | {"type": "MultiPolygon", "coordinates": [[[[-119.80818, 34.42783], [-119.80793, 34.42827], [-119.80768, 34.42863], [-119.80753, 34.42918], [-119.80753, 34.42957], [-119.80738, 34.43021], [-119.80738, 34.43068], [-119.80766, 34.43127], [-119.80766, 34.43204], [-119.80759, 34.43228], [-119.80758, 34.43254], [-119.80761, 34.43273], [-119.80782, 34.43341], [-119.80783, 34.43357], [-119.80781, 34.43369], [-119.80775, 34.43386], [-119.80769, 34.43396], [-119.80749, 34.43418], [-119.80694, 34.43476], [-119.80655, 34.43475], [-119.80662, 34.43457], [-119.80671, 34.43458], [-119.80679, 34.43454], [-119.80682, 34.43449], [-119.80683, 34.43443], [-119.8069, 34.43442], [-119.80717, 34.43408], [-119.80713, 34.4338], [-119.80705, 34.43375], [-119.80706, 34.43369], [-119.80705, 34.43363], [-119.80714, 34.43359], [-119.80722, 34.43323], [-119.80737, 34.43319], [-119.80729, 34.43293], [-119.80721, 34.43289], [-119.80724, 34.4328], [-119.80719, 34.43256], [-119.80717, 34.43226], [-119.80724, 34.43176], [-119.80724, 34.43145], [-119.80722, 34.43129], [-119.80709, 34.4308], [-119.80705, 34.43058], [-119.80703, 34.43036], [-119.80703, 34.43014], [-119.80712, 34.42909], [-119.8072, 34.42878], [-119.80735, 34.42839], [-119.80738, 34.42824], [-119.80739, 34.42809], [-119.80737, 34.42787], [-119.80818, 34.42783]]], [[[-119.80555, 34.44363], [-119.80546, 34.44368], [-119.80534, 34.44379], [-119.80523, 34.44397], [-119.80497, 34.44513], [-119.80464, 34.4451], [-119.80449, 34.44531], [-119.80419, 34.44525], [-119.80402, 34.4453], [-119.80393, 34.44547], [-119.80358, 34.44532], [-119.80365, 34.44499], [-119.8039, 34.44475], [-119.80438, 34.44456], [-119.80474, 34.44427], [-119.8046, 34.44386], [-119.80481, 34.44368], [-119.80527, 34.44343], [-119.80532, 34.44334], [-119.80551, 34.44332], [-119.80555, 34.44363]]], [[[-119.80378, 34.44592], [-119.80366, 34.4463], [-119.80325, 34.44624], [-119.80324, 34.44625], [-119.80335, 34.44727], [-119.80368, 34.44726], [-119.80373, 34.44775], [-119.80371, 34.44782], [-119.80365, 34.44786], [-119.80355, 34.44789], [-119.80349, 34.44795], [-119.80328, 34.4479], [-119.80257, 34.44813], [-119.80238, 34.44837], [-119.80211, 34.44842], [-119.80196, 34.44856], [-119.80178, 34.44857], [-119.80166, 34.44894], [-119.80137, 34.44905], [-119.8013, 34.44915], [-119.80126, 34.44928], [-119.80139, 34.44946], [-119.80159, 34.44962], [-119.80128, 34.44962], [-119.80088, 34.44918], [-119.80098, 34.44907], [-119.8012, 34.44877], [-119.80138, 34.44859], [-119.80223, 34.44801], [-119.8023, 34.44795], [-119.80235, 34.44786], [-119.80262, 34.44773], [-119.80269, 34.44762], [-119.80241, 34.44694], [-119.8021, 34.44669], [-119.80182, 34.4467], [-119.80174, 34.44684], [-119.80123, 34.44716], [-119.80119, 34.44729], [-119.80113, 34.44766], [-119.80087, 34.44796], [-119.80047, 34.44833], [-119.80041, 34.44828], [-119.80029, 34.44828], [-119.80051, 34.44786], [-119.80059, 34.44762], [-119.80067, 34.44731], [-119.80079, 34.44707], [-119.80091, 34.44694], [-119.8015, 34.44645], [-119.80169, 34.44626], [-119.80199, 34.44589], [-119.80212, 34.44575], [-119.80256, 34.44575], [-119.80304, 34.44557], [-119.80355, 34.44549], [-119.80368, 34.44556], [-119.80351, 34.44585], [-119.80378, 34.44592]]], [[[-119.7952, 34.45576], [-119.79519, 34.45606], [-119.79483, 34.45606], [-119.79478, 34.45662], [-119.79471, 34.45677], [-119.79433, 34.45736], [-119.79434, 34.45737], [-119.79472, 34.45738], [-119.79463, 34.45757], [-119.79373, 34.45755], [-119.7937, 34.45659], [-119.79444, 34.45608], [-119.79437, 34.45575], [-119.7952, 34.45576]]], [[[-119.79526, 34.4592], [-119.79501, 34.45939], [-119.79428, 34.45963], [-119.79402, 34.45956], [-119.79374, 34.45963], [-119.79341, 34.45957], [-119.79319, 34.45991], [-119.79298, 34.45997], [-119.79289, 34.45965], [-119.79349, 34.45947], [-119.79401, 34.45938], [-119.79428, 34.45928], [-119.79438, 34.45922], [-119.79483, 34.45924], [-119.79525, 34.45902], [-119.79526, 34.4592]]]]} | Unknown Access 4 | 17594 | Maria Ygnacia Creek | 21810 | 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 | 28.798 | Maria Ygnacia Creek | 0 | Local Other or Unknown 14 | 4 | |
15974 | 15974 | 15973 | {"type": "MultiPolygon", "coordinates": [[[[-119.81332, 34.45598], [-119.81288, 34.45617], [-119.81225, 34.45579], [-119.81214, 34.45568], [-119.81209, 34.45571], [-119.81199, 34.45548], [-119.81194, 34.45517], [-119.81158, 34.45496], [-119.81142, 34.45533], [-119.81138, 34.45536], [-119.81135, 34.45542], [-119.81137, 34.4555], [-119.81145, 34.45559], [-119.8115, 34.45578], [-119.81148, 34.45592], [-119.8114, 34.45609], [-119.81136, 34.45621], [-119.81136, 34.45643], [-119.81134, 34.45646], [-119.81119, 34.45654], [-119.81111, 34.45662], [-119.81093, 34.45692], [-119.81062, 34.45753], [-119.8103, 34.45739], [-119.81042, 34.4569], [-119.80997, 34.45714], [-119.80956, 34.45682], [-119.80933, 34.45651], [-119.80908, 34.4565], [-119.80894, 34.45612], [-119.80929, 34.45603], [-119.80957, 34.45575], [-119.80968, 34.4558], [-119.80969, 34.4561], [-119.81035, 34.4561], [-119.81047, 34.45579], [-119.81042, 34.45575], [-119.81048, 34.45568], [-119.8105, 34.45559], [-119.8105, 34.45431], [-119.81053, 34.45429], [-119.81115, 34.45429], [-119.81129, 34.45426], [-119.81139, 34.45421], [-119.81146, 34.45416], [-119.81153, 34.45407], [-119.81158, 34.45396], [-119.81159, 34.45408], [-119.81196, 34.45403], [-119.81204, 34.45397], [-119.81207, 34.45383], [-119.81229, 34.45385], [-119.81229, 34.45306], [-119.81384, 34.45306], [-119.81408, 34.45307], [-119.81411, 34.4531], [-119.81412, 34.45313], [-119.81401, 34.45326], [-119.81387, 34.45335], [-119.81367, 34.45343], [-119.81356, 34.45348], [-119.81346, 34.45357], [-119.81339, 34.45366], [-119.81331, 34.45385], [-119.81322, 34.45435], [-119.81289, 34.45432], [-119.81286, 34.45461], [-119.81251, 34.45474], [-119.81236, 34.45497], [-119.81251, 34.45525], [-119.81269, 34.45538], [-119.81294, 34.45543], [-119.81309, 34.45578], [-119.81332, 34.45598]]], [[[-119.81048, 34.45784], [-119.81042, 34.45797], [-119.81006, 34.45793], [-119.80996, 34.45812], [-119.80972, 34.45833], [-119.80961, 34.45878], [-119.80941, 34.45916], [-119.80963, 34.45934], [-119.80984, 34.45945], [-119.81, 34.4595], [-119.80999, 34.45955], [-119.80985, 34.45956], [-119.8098, 34.4595], [-119.80931, 34.45923], [-119.80912, 34.45888], [-119.80925, 34.4583], [-119.80955, 34.45781], [-119.81004, 34.45766], [-119.81042, 34.45785], [-119.81048, 34.45784]]], [[[-119.81501, 34.458], [-119.815, 34.45855], [-119.81493, 34.45851], [-119.81494, 34.45848], [-119.81485, 34.45842], [-119.81481, 34.45845], [-119.81458, 34.45833], [-119.81417, 34.45818], [-119.81412, 34.45791], [-119.81387, 34.45777], [-119.81367, 34.45716], [-119.81363, 34.45682], [-119.81339, 34.45641], [-119.8131, 34.45626], [-119.81363, 34.45603], [-119.81367, 34.45604], [-119.81376, 34.4562], [-119.81383, 34.45639], [-119.81407, 34.45734], [-119.81419, 34.45756], [-119.81434, 34.45772], [-119.81452, 34.45785], [-119.81478, 34.45796], [-119.81501, 34.458]]], [[[-119.8154, 34.45898], [-119.81531, 34.45912], [-119.81528, 34.45914], [-119.81495, 34.45882], [-119.81494, 34.45878], [-119.81462, 34.45852], [-119.8154, 34.45898]]]]} | Unknown Access 4 | 339 | San Jose Creek Open Space | 24915 | 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 | 23.422 | San Jose Creek 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 | |
10364 | 10364 | 10363 | {"type": "MultiPolygon", "coordinates": [[[[-119.82218, 34.45596], [-119.82169, 34.45592], [-119.82106, 34.45592], [-119.82106, 34.45542], [-119.82103, 34.45521], [-119.82103, 34.45517], [-119.82106, 34.45515], [-119.82112, 34.45514], [-119.82174, 34.45515], [-119.82207, 34.45508], [-119.82215, 34.45529], [-119.82218, 34.45596]]], [[[-119.82397, 34.45496], [-119.82392, 34.45497], [-119.82394, 34.45538], [-119.82378, 34.45558], [-119.82369, 34.45581], [-119.82347, 34.45604], [-119.82351, 34.45614], [-119.82364, 34.45625], [-119.82374, 34.45636], [-119.82376, 34.45652], [-119.82369, 34.45676], [-119.82367, 34.45697], [-119.82357, 34.45723], [-119.82345, 34.45737], [-119.82369, 34.45756], [-119.82344, 34.45767], [-119.82325, 34.4581], [-119.82325, 34.45838], [-119.82322, 34.45844], [-119.82309, 34.45845], [-119.82311, 34.45784], [-119.82326, 34.45725], [-119.82355, 34.45682], [-119.82331, 34.45625], [-119.82331, 34.45601], [-119.8239, 34.45464], [-119.82388, 34.45359], [-119.82323, 34.45372], [-119.82271, 34.45436], [-119.82251, 34.45444], [-119.82248, 34.45482], [-119.82173, 34.455], [-119.8211, 34.45499], [-119.82099, 34.455], [-119.82099, 34.45492], [-119.82177, 34.45493], [-119.82216, 34.45444], [-119.82242, 34.45432], [-119.8226, 34.45383], [-119.82286, 34.4536], [-119.82319, 34.45339], [-119.82365, 34.45304], [-119.82395, 34.45304], [-119.82397, 34.45496]]]]} | Open Access 1 | 18310 | Oro Verde Park | 23208 | 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 | 7.464 | Oro Verde Park | 0 | Local Park 2 | 4 | |
9965 | 9965 | 9964 | {"type": "MultiPolygon", "coordinates": [[[[-119.8348, 34.45306], [-119.83472, 34.45336], [-119.83473, 34.45393], [-119.83358, 34.45393], [-119.83346, 34.45366], [-119.83327, 34.45366], [-119.83316, 34.45389], [-119.83241, 34.45389], [-119.83209, 34.45412], [-119.83206, 34.45426], [-119.8319, 34.45426], [-119.83184, 34.45381], [-119.83212, 34.45376], [-119.83261, 34.45358], [-119.83287, 34.45353], [-119.83313, 34.45353], [-119.83355, 34.4536], [-119.83367, 34.45359], [-119.83379, 34.45357], [-119.83391, 34.45352], [-119.83401, 34.45346], [-119.83426, 34.45322], [-119.83432, 34.45318], [-119.83441, 34.45314], [-119.83465, 34.45311], [-119.8348, 34.45306]]], [[[-119.83502, 34.45281], [-119.83464, 34.45297], [-119.83442, 34.45301], [-119.83435, 34.45301], [-119.83432, 34.45299], [-119.83419, 34.45248], [-119.83415, 34.45237], [-119.83409, 34.45227], [-119.83398, 34.45214], [-119.83388, 34.45207], [-119.83372, 34.452], [-119.83358, 34.45198], [-119.83366, 34.45161], [-119.83475, 34.45158], [-119.83461, 34.45187], [-119.83496, 34.45206], [-119.83491, 34.45218], [-119.83488, 34.45234], [-119.83492, 34.4525], [-119.83504, 34.45277], [-119.83504, 34.45279], [-119.83502, 34.45281]]], [[[-119.83411, 34.45306], [-119.83392, 34.45326], [-119.83383, 34.45332], [-119.83372, 34.45336], [-119.8337, 34.45333], [-119.83385, 34.45324], [-119.83397, 34.45312], [-119.83407, 34.45305], [-119.83409, 34.45301], [-119.83411, 34.45306]]]]} | Open Access 1 | 17138 | La Goleta Park | 20757 | 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.108 | La Goleta Park | 0 | Local Park 2 | 4 | |
6131 | 6131 | 6130 | {"type": "MultiPolygon", "coordinates": [[[[-119.8405, 34.44897], [-119.84028, 34.44897], [-119.84023, 34.44897], [-119.84042, 34.44887], [-119.8405, 34.44897]]], [[[-119.84221, 34.45083], [-119.84133, 34.45085], [-119.84133, 34.45014], [-119.84133, 34.45014], [-119.84221, 34.45083]]]]} | Open Access 1 | 1119 | Stonebridge Park | 25879 | 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.819 | Stonebridge Park | 0 | Local Park 2 | 4 | |
9900 | 9900 | 9899 | {"type": "MultiPolygon", "coordinates": [[[[-119.8647, 34.40971], [-119.86462, 34.40971], [-119.86462, 34.40897], [-119.8647, 34.40897], [-119.8647, 34.40971]]], [[[-119.86421, 34.40971], [-119.86396, 34.40971], [-119.86396, 34.40902], [-119.8642, 34.40901], [-119.86421, 34.40971]]], [[[-119.86379, 34.40971], [-119.86363, 34.40971], [-119.86363, 34.40905], [-119.86379, 34.40904], [-119.86379, 34.40971]]], [[[-119.86943, 34.40918], [-119.86943, 34.40945], [-119.86919, 34.40943], [-119.86913, 34.40981], [-119.86907, 34.4098], [-119.86911, 34.40942], [-119.86807, 34.40933], [-119.86802, 34.40971], [-119.86798, 34.40971], [-119.86798, 34.40933], [-119.86772, 34.40933], [-119.86772, 34.40971], [-119.86759, 34.40971], [-119.86758, 34.40933], [-119.86719, 34.40933], [-119.86666, 34.40933], [-119.86666, 34.40971], [-119.86649, 34.40971], [-119.8665, 34.40896], [-119.86943, 34.40918]]]]} | Open Access 1 | 16980 | Isla Vista Beach | 20277 | 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.442 | Isla Vista Beach | 0 | Local Park 2 | 4 | |
16129 | 16129 | 16128 | {"type": "MultiPolygon", "coordinates": [[[[-119.88816, 34.44225], [-119.88809, 34.44171], [-119.88817, 34.44172], [-119.88819, 34.44174], [-119.88824, 34.44205], [-119.88824, 34.44218], [-119.88819, 34.44237], [-119.88807, 34.44257], [-119.88801, 34.44271], [-119.88798, 34.44287], [-119.88797, 34.44322], [-119.88793, 34.44337], [-119.88791, 34.44267], [-119.88816, 34.44225]]], [[[-119.89466, 34.4424], [-119.89424, 34.44269], [-119.88971, 34.44276], [-119.8897, 34.44219], [-119.89007, 34.44219], [-119.89051, 34.44221], [-119.89191, 34.44218], [-119.89203, 34.44214], [-119.89209, 34.44221], [-119.89219, 34.44223], [-119.89227, 34.4422], [-119.89232, 34.44213], [-119.89245, 34.44217], [-119.89431, 34.44214], [-119.8945, 34.44212], [-119.89456, 34.44228], [-119.89466, 34.4424]]]]} | Open Access 1 | 17129 | Koarts Open Space | 20710 | 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.968 | Koarts OS | 0 | Local Recreation Area 3 | 4 | |
2071 | 2071 | 2070 | {"type": "MultiPolygon", "coordinates": [[[[-119.89262, 34.43884], [-119.89269, 34.43916], [-119.89271, 34.4395], [-119.8927, 34.43963], [-119.89265, 34.43988], [-119.89261, 34.4399], [-119.89232, 34.4398], [-119.89214, 34.43966], [-119.89204, 34.43955], [-119.89163, 34.43896], [-119.89154, 34.43885], [-119.89133, 34.43865], [-119.89101, 34.43845], [-119.89073, 34.43834], [-119.89043, 34.43827], [-119.89028, 34.43826], [-119.88921, 34.43829], [-119.88894, 34.43834], [-119.88879, 34.4384], [-119.88854, 34.43802], [-119.88821, 34.43768], [-119.88786, 34.43766], [-119.88737, 34.43779], [-119.8877, 34.43814], [-119.88789, 34.4383], [-119.88793, 34.43836], [-119.888, 34.43839], [-119.8881, 34.4384], [-119.88817, 34.43844], [-119.88764, 34.43883], [-119.88746, 34.43904], [-119.88774, 34.43919], [-119.88766, 34.43931], [-119.88757, 34.43951], [-119.88754, 34.43952], [-119.88704, 34.43953], [-119.88708, 34.4393], [-119.88708, 34.43889], [-119.8874, 34.43825], [-119.88673, 34.43805], [-119.88627, 34.43734], [-119.88582, 34.43694], [-119.88519, 34.43694], [-119.88516, 34.43552], [-119.88529, 34.43552], [-119.88647, 34.43593], [-119.88718, 34.43652], [-119.89012, 34.43693], [-119.89012, 34.43702], [-119.88961, 34.437], [-119.88989, 34.43746], [-119.89066, 34.43751], [-119.89169, 34.43778], [-119.89209, 34.4381], [-119.8921, 34.43842], [-119.89218, 34.43853], [-119.8923, 34.43889], [-119.89262, 34.43884]]], [[[-119.88793, 34.44143], [-119.88788, 34.44135], [-119.88786, 34.44123], [-119.88781, 34.44124], [-119.88781, 34.44143], [-119.88746, 34.44144], [-119.88744, 34.44058], [-119.88687, 34.44047], [-119.88701, 34.43969], [-119.88749, 34.43967], [-119.88754, 34.4397], [-119.88757, 34.43995], [-119.88763, 34.44013], [-119.88767, 34.44021], [-119.88793, 34.44059], [-119.88803, 34.44081], [-119.88807, 34.44093], [-119.88815, 34.4414], [-119.88811, 34.44143], [-119.88793, 34.44143]]]]} | Open Access 1 | 15735 | Evergreen Acres | 18765 | 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 | 28.758 | Evergreen Acres | None 163 |
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]);