superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
75 rows where ACCESS_TYP = 1 and MNG_AGENCY = 7 sorted by LABEL_NAME descending
This data as json, copyable, CSV (advanced)
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME ▲ | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11313 | 11313 | 11312 | {"type": "Polygon", "coordinates": [[[-119.89864, 34.43647], [-119.89778, 34.43649], [-119.89777, 34.43593], [-119.89862, 34.43591], [-119.89864, 34.43647]]]} | Open Access 1 | Winchester II Park | 27620 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 1.21 | Winchester II Park | ||
11312 | 11312 | 11311 | {"type": "Polygon", "coordinates": [[[-119.89552, 34.4344], [-119.89508, 34.43471], [-119.89486, 34.4345], [-119.89513, 34.43431], [-119.89512, 34.43381], [-119.89489, 34.4336], [-119.8955, 34.43359], [-119.89552, 34.4344]]]} | Open Access 1 | Winchester I Park | 27619 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 1.141 | Winchester I Park | ||
11316 | 11316 | 11315 | {"type": "Polygon", "coordinates": [[[-119.8955, 34.43359], [-119.89489, 34.4336], [-119.89507, 34.4334], [-119.89518, 34.43316], [-119.89501, 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 | Winchester I Open Space | 27618 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 2.195 | Winchester I OS | ||
9391 | 9391 | 9390 | {"type": "Polygon", "coordinates": [[[-120.44516, 34.8993], [-120.44515, 34.90526], [-120.43668, 34.90529], [-120.43648, 34.90517], [-120.43631, 34.9047], [-120.43632, 34.90177], [-120.43902, 34.90175], [-120.43902, 34.89957], [-120.43913, 34.89955], [-120.43913, 34.89863], [-120.4392, 34.89829], [-120.43921, 34.89813], [-120.43919, 34.89613], [-120.4391, 34.8956], [-120.43902, 34.89558], [-120.43906, 34.89471], [-120.43963, 34.89485], [-120.44023, 34.89505], [-120.44093, 34.89552], [-120.44516, 34.8993]]]} | Open Access 1 | Waller Park | 27221 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 154.452 | Waller Park | ||
14755 | 14755 | 14754 | {"type": "MultiPolygon", "coordinates": [[[[-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.81542, 34.44863], [-119.81541, 34.44862], [-119.81444, 34.44862], [-119.81443, 34.44848], [-119.81445, 34.44835], [-119.81449, 34.44821], [-119.81456, 34.44809], [-119.81465, 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.81574, 34.4463], [-119.816, 34.44635], [-119.81606, 34.4464]]], [[[-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.44559], [-119.81594, 34.44587], [-119.81525, 34.44586], [-119.81511, 34.44585], [-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.81734, 34.44366], [-119.81742, 34.44341], [-119.81783, 34.44343]]]]} | Open Access 1 | University Circle Open Space | 26673 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 11.729 | University Circle OS | ||
10474 | 10474 | 10473 | {"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.46829], [-119.77206, 34.46758], [-119.77217, 34.46752], [-119.77276, 34.46791], [-119.77294, 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.79156, 34.45238], [-119.79156, 34.45359], [-119.78801, 34.45358], [-119.788, 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.78466, 34.45356], [-119.78362, 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.77404, 34.46191], [-119.77526, 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.45692], [-119.77871, 34.45682], [-119.77868, 34.45673], [-119.77881, 34.45668], [-119.77931, 34.45642], [-119.77996, 34.45631], [-119.7799, 34.45591], [-119.78001, 34.45558], [-119.78025, 34.45532], [-119.78111, 34.4551], [-119.78261, 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.78801, 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.45163], [-119.79023, 34.45147], [-119.79093, 34.45169], [-119.79135, 34.45177], [-119.79223, 34.45174]]]]} | Open Access 1 | Tuckers Grove Park | 26558 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 111.524 | Tuckers Grove Park | ||
10398 | 10398 | 10397 | {"type": "Polygon", "coordinates": [[[-119.56174, 34.43642], [-119.54997, 34.43637], [-119.54992, 34.43528], [-119.55032, 34.43491], [-119.55041, 34.43442], [-119.553, 34.4332], [-119.55302, 34.4319], [-119.55511, 34.43201], [-119.55572, 34.43196], [-119.55613, 34.43206], [-119.55647, 34.43203], [-119.55731, 34.43219], [-119.55826, 34.43235], [-119.55812, 34.43257], [-119.55655, 34.43285], [-119.55664, 34.43332], [-119.55682, 34.43352], [-119.55775, 34.43371], [-119.55825, 34.43377], [-119.55918, 34.43363], [-119.55997, 34.4338], [-119.56007, 34.43451], [-119.56063, 34.435], [-119.56121, 34.43547], [-119.56174, 34.43642]]]} | Open Access 1 | Toro Canyon Park | 26412 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 88.922 | Toro Canyon Park | ||
14969 | 14969 | 14968 | {"type": "Polygon", "coordinates": [[[-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], [-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.80176, 34.43554], [-119.80189, 34.43557], [-119.80203, 34.43557], [-119.80218, 34.43556], [-119.80222, 34.43559]]]} | Open Access 1 | Thunderbird Open Space | 28546 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 0.941 | Thunderbird OS | ||
10057 | 10057 | 10056 | {"type": "Polygon", "coordinates": [[[-119.5898, 34.42352], [-119.58906, 34.42428], [-119.5885, 34.42388], [-119.58922, 34.42315], [-119.5898, 34.42352]]]} | Open Access 1 | Summerland Greenwell Preserve | 25961 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 1.774 | Summerland Greenwell Preserve | ||
10011 | 10011 | 10010 | {"type": "Polygon", "coordinates": [[[-119.84568, 34.44599], [-119.84615, 34.44647], [-119.84624, 34.44662], [-119.84629, 34.44677], [-119.8465, 34.44822], [-119.84663, 34.44933], [-119.84663, 34.44955], [-119.84655, 34.44989], [-119.84653, 34.45018], [-119.84655, 34.45047], [-119.84663, 34.45075], [-119.84662, 34.45079], [-119.8466, 34.45083], [-119.84655, 34.45087], [-119.84628, 34.45093], [-119.84609, 34.45095], [-119.8459, 34.45096], [-119.84512, 34.45092], [-119.84515, 34.45003], [-119.8452, 34.44961], [-119.84524, 34.44939], [-119.8453, 34.44915], [-119.84542, 34.44878], [-119.84574, 34.44803], [-119.84584, 34.44762], [-119.84586, 34.44739], [-119.84586, 34.44718], [-119.84584, 34.44697], [-119.8458, 34.44677], [-119.84565, 34.44636], [-119.84555, 34.44616], [-119.84545, 34.446], [-119.84553, 34.44596], [-119.8456, 34.44597], [-119.84564, 34.44601], [-119.84568, 34.44599]]]} | Open Access 1 | Stow Grove Park | 25905 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 11.813 | Stow Grove Park | ||
14946 | 14946 | 14945 | {"type": "Polygon", "coordinates": [[[-119.84074, 34.4486], [-119.84062, 34.44862], [-119.84007, 34.44831], [-119.83956, 34.44809], [-119.83937, 34.44757], [-119.83959, 34.4473], [-119.83992, 34.44739], [-119.84009, 34.44716], [-119.84018, 34.44719], [-119.8403, 34.4472], [-119.84054, 34.44726], [-119.84032, 34.44792], [-119.84042, 34.44822], [-119.84063, 34.4483], [-119.84069, 34.44831], [-119.84074, 34.4486]]]} | Open Access 1 | Stow Canyon Open Space | 25904 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 2.599 | Stow Canyon OS | ||
9997 | 9997 | 9996 | {"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 | Stonebrook Open Space | 25882 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 3.08 | Stonebrook OS | ||
9990 | 9990 | 9989 | {"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 | Stonebridge Park | 25879 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 0.819 | Stonebridge Park | ||
9989 | 9989 | 9988 | {"type": "Polygon", "coordinates": [[[-119.84133, 34.45093], [-119.84062, 34.45098], [-119.84059, 34.45044], [-119.84067, 34.45043], [-119.84073, 34.45041], [-119.84077, 34.45036], [-119.84079, 34.4503], [-119.84075, 34.4497], [-119.84072, 34.44964], [-119.84067, 34.4496], [-119.84055, 34.44958], [-119.84054, 34.44941], [-119.84028, 34.44897], [-119.84057, 34.44897], [-119.84115, 34.44969], [-119.84132, 34.44997], [-119.84133, 34.45093]]]} | Open Access 1 | Stonebridge | 25878 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 2.613 | Stonebridge | ||
9710 | 9710 | 9709 | {"type": "Polygon", "coordinates": [[[-119.69311, 34.46023], [-119.69221, 34.46094], [-119.69162, 34.46037], [-119.6916, 34.46001], [-119.69199, 34.45915], [-119.69235, 34.45915], [-119.69311, 34.46023]]]} | Open Access 1 | Skofield Park | 25529 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 4.076 | Skofield Park | ||
9432 | 9432 | 9431 | {"type": "Polygon", "coordinates": [[[-119.86649, 34.40896], [-119.86649, 34.40971], [-119.86582, 34.40971], [-119.86582, 34.40896], [-119.86649, 34.40896]]]} | Open Access 1 | Sea Lookout Park | 25234 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 1.287 | Sea Lookout Park | ||
9342 | 9342 | 9341 | {"type": "MultiPolygon", "coordinates": [[[[-120.08509, 34.61217], [-120.08486, 34.61225], [-120.08464, 34.61234], [-120.08421, 34.61266], [-120.08416, 34.61268], [-120.08416, 34.61217], [-120.08509, 34.61217]]], [[[-120.08517, 34.61149], [-120.08516, 34.61204], [-120.0845, 34.61203], [-120.08451, 34.61148], [-120.08517, 34.61149]]], [[[-120.08606, 34.6115], [-120.08594, 34.61162], [-120.08572, 34.61198], [-120.08555, 34.61204], [-120.08543, 34.61204], [-120.08543, 34.61149], [-120.08606, 34.6115]]], [[[-120.08723, 34.61005], [-120.08718, 34.61013], [-120.08634, 34.61118], [-120.08635, 34.6112], [-120.08626, 34.61128], [-120.08554, 34.61129], [-120.08554, 34.61123], [-120.08561, 34.61111], [-120.0859, 34.61112], [-120.08608, 34.61102], [-120.08626, 34.6111], [-120.08632, 34.61104], [-120.08622, 34.61074], [-120.08647, 34.61044], [-120.0867, 34.61044], [-120.08691, 34.61018], [-120.08706, 34.61005], [-120.08723, 34.61005]]]]} | Open Access 1 | Santa Ynez Park | 25143 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 3.198 | Santa Ynez Park | ||
9340 | 9340 | 9339 | {"type": "Polygon", "coordinates": [[[-120.30735, 34.60822], [-120.30677, 34.60853], [-120.30678, 34.60893], [-120.3056, 34.60813], [-120.30556, 34.6074], [-120.30189, 34.60528], [-120.30097, 34.60541], [-120.30098, 34.60492], [-120.30091, 34.60467], [-120.30062, 34.60438], [-120.30091, 34.60411], [-120.29992, 34.60337], [-120.29883, 34.60341], [-120.29874, 34.60326], [-120.29916, 34.60305], [-120.30016, 34.60306], [-120.301, 34.60348], [-120.30152, 34.60338], [-120.30129, 34.60386], [-120.30172, 34.60416], [-120.30208, 34.60463], [-120.30257, 34.60484], [-120.30301, 34.60488], [-120.30316, 34.60512], [-120.30339, 34.60529], [-120.30363, 34.60552], [-120.30404, 34.60552], [-120.30465, 34.60545], [-120.30514, 34.60554], [-120.30564, 34.6055], [-120.30565, 34.60574], [-120.306, 34.60603], [-120.30666, 34.60682], [-120.30735, 34.60822]]]} | Open Access 1 | Santa Rosa Park | 25134 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 24.347 | Santa Rosa Park | ||
7917 | 7917 | 7916 | {"type": "Polygon", "coordinates": [[[-119.52661, 34.41577], [-119.52628, 34.41577], [-119.52622, 34.41481], [-119.52623, 34.41435], [-119.5263, 34.41401], [-119.52657, 34.41394], [-119.52646, 34.41475], [-119.52646, 34.41518], [-119.52661, 34.41577]]]} | Open Access 1 | Santa Monica Creek | 25116 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 1.173 | Santa Monica Creek | ||
1010 | 1010 | 1009 | {"type": "MultiPolygon", "coordinates": [[[[-120.47587, 34.98734], [-120.47586, 34.98785], [-120.4659, 34.98969], [-120.46394, 34.98997], [-120.46217, 34.99011], [-120.45826, 34.98975], [-120.45272, 34.98952], [-120.45272, 34.98923], [-120.453, 34.98925], [-120.45302, 34.98943], [-120.45678, 34.98961], [-120.4576, 34.98968], [-120.45762, 34.98963], [-120.45999, 34.98971], [-120.46284, 34.98957], [-120.46286, 34.98949], [-120.46302, 34.98948], [-120.46303, 34.98954], [-120.46364, 34.98949], [-120.46588, 34.98917], [-120.47587, 34.98734]]], [[[-120.47967, 34.98664], [-120.47965, 34.99181], [-120.47784, 34.99165], [-120.47789, 34.98694], [-120.47967, 34.98664]]], [[[-120.51386, 34.98767], [-120.51376, 34.98768], [-120.51367, 34.98716], [-120.51331, 34.98688], [-120.51188, 34.98728], [-120.50779, 34.9882], [-120.50391, 34.98892], [-120.4877, 34.99201], [-120.48536, 34.99237], [-120.48337, 34.99218], [-120.48345, 34.98595], [-120.4854, 34.98558], [-120.48776, 34.98517], [-120.48777, 34.98558], [-120.4877, 34.99144], [-120.48772, 34.99146], [-120.51138, 34.98689], [-120.51362, 34.98635], [-120.51386, 34.98767]]], [[[-120.55274, 34.97282], [-120.55227, 34.97363], [-120.54431, 34.97442], [-120.54358, 34.97544], [-120.54006, 34.97599], [-120.51284, 34.98081], [-120.51265, 34.97972], [-120.51277, 34.97971], [-120.51284, 34.98008], [-120.51301, 34.98022], [-120.53916, 34.97546], [-120.53998, 34.97431], [-120.54702, 34.97309], [-120.55274, 34.97282]]], [[[-120.53866, 34.98161], [-120.53788, 34.98229], [-120.51434, 34.98672], [-120.51413, 34.98716], [-120.51421, 34.98764], [-120.51408, 34.98765], [-120.51384, 34.9863], [-120.53866, 34.98161]]], [[[-120.57027, 34.97531], [-120.57026, 34.97583], [-120.56846, 34.97601], [-120.56811, 34.97606], [-120.56776, 34.97608], [-120.56742, 34.97607], [-120.56707, 34.97602], [-120.56673, 34.97595], [-120.56573, 34.97567], [-120.5635, 34.97513], [-120.56095, 34.97464], [-120.55788, 34.97431], [-120.55621, 34.97422], [-120.55444, 34.97367], [-120.55789, 34.97375], [-120.55791, 34.97386], [-120.56036, 34.9741], [-120.5636, 34.97468], [-120.56368, 34.97454], [-120.56401, 34.97461], [-120.56396, 34.97475], [-120.56397, 34.97477], [-120.56707, 34.97552], [-120.56736, 34.97556], [-120.56766, 34.97558], [-120.56797, 34.97557], [-120.57027, 34.97531]]], [[[-120.57149, 34.97539], [-120.57144, 34.97556], [-120.57136, 34.97569], [-120.57125, 34.97578], [-120.57111, 34.97585], [-120.57117, 34.97538], [-120.57149, 34.97539]]]]} | Open Access 1 | Santa Maria River | 11840 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 285.309 | Santa Maria River |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);