superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
34 rows where MNG_AGENCY = 474 and MNG_AG_TYP = 2 sorted by map
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13175 | 13175 | 13174 | {"type": "MultiPolygon", "coordinates": [[[[-117.94979, 35.1278], [-117.94897, 35.12779], [-117.9487, 35.12788], [-117.94845, 35.1281], [-117.94846, 35.13001], [-117.94782, 35.13002], [-117.94782, 35.12984], [-117.9478, 35.12855], [-117.94753, 35.12829], [-117.94728, 35.12823], [-117.94692, 35.12838], [-117.94679, 35.12856], [-117.94677, 35.12887], [-117.94677, 35.13003], [-117.94655, 35.13003], [-117.94636, 35.12998], [-117.94627, 35.12999], [-117.9462, 35.13003], [-117.94617, 35.13008], [-117.94615, 35.13017], [-117.94619, 35.13027], [-117.94625, 35.13031], [-117.94633, 35.13033], [-117.94653, 35.13028], [-117.94667, 35.13027], [-117.94667, 35.13073], [-117.94562, 35.13074], [-117.94558, 35.13233], [-117.94541, 35.13232], [-117.94554, 35.13225], [-117.94551, 35.13095], [-117.94538, 35.13076], [-117.9447, 35.13062], [-117.94436, 35.13043], [-117.94384, 35.13032], [-117.9437, 35.1302], [-117.9437, 35.13002], [-117.94381, 35.12986], [-117.94375, 35.12968], [-117.94311, 35.12954], [-117.94311, 35.12929], [-117.94333, 35.12915], [-117.94331, 35.12869], [-117.94345, 35.12858], [-117.94442, 35.12849], [-117.94489, 35.12831], [-117.94495, 35.12785], [-117.94523, 35.12762], [-117.94522, 35.12745], [-117.945, 35.12737], [-117.94413, 35.12743], [-117.94413, 35.12745], [-117.94423, 35.12764], [-117.94423, 35.12791], [-117.94384, 35.12803], [-117.94339, 35.12807], [-117.94311, 35.12798], [-117.94311, 35.12771], [-117.94325, 35.12742], [-117.9431, 35.12732], [-117.94267, 35.1275], [-117.94236, 35.12784], [-117.94247, 35.12833], [-117.94255, 35.1284], [-117.94255, 35.12865], [-117.94214, 35.12881], [-117.94141, 35.12892], [-117.94102, 35.12879], [-117.94103, 35.12755], [-117.94109, 35.12738], [-117.9412, 35.12699], [-117.94123, 35.12672], [-117.94124, 35.12613], [-117.94977, 35.12613], [-117.94979, 35.1278]]], [[[-117.94286, 35.13016], [-117.94286, 35.13018], [-117.94264, 35.13018], [-117.94264, 35.13015], [-117.94286, 35.13016]]], [[[-117.94567, 35.13316], [-117.94481, 35.1331], [-117.94404, 35.133], [-117.94334, 35.13283], [-117.94307, 35.13275], [-117.94334, 35.13215], [-117.94332, 35.13203], [-117.94339, 35.13198], [-117.94412, 35.13222], [-117.94422, 35.13229], [-117.94434, 35.13254], [-117.94441, 35.1326], [-117.94452, 35.1326], [-117.94504, 35.13242], [-117.94508, 35.1326], [-117.94476, 35.1327], [-117.94471, 35.13281], [-117.94471, 35.1329], [-117.94564, 35.13299], [-117.94567, 35.13316]]], [[[-117.94352, 35.13092], [-117.94349, 35.13096], [-117.9434, 35.13101], [-117.94331, 35.13102], [-117.9432, 35.13099], [-117.94313, 35.13092], [-117.94352, 35.13092]]]]} | Restricted Access 2 | California City Central Park/Tierra Del Sol Golf | 33388 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 67.762 | California City Central Park/Tierra Del Sol Golf | ||
12308 | 12308 | 12307 | {"type": "MultiPolygon", "coordinates": [[[[-117.94984, 35.13219], [-117.94919, 35.13247], [-117.9489, 35.13268], [-117.94835, 35.13286], [-117.9477, 35.13328], [-117.94715, 35.13328], [-117.94713, 35.13315], [-117.94567, 35.13316], [-117.94563, 35.13299], [-117.94471, 35.1329], [-117.94471, 35.13281], [-117.94476, 35.1327], [-117.94507, 35.1326], [-117.94504, 35.13243], [-117.94452, 35.1326], [-117.94441, 35.1326], [-117.94434, 35.13254], [-117.94422, 35.13229], [-117.94412, 35.13222], [-117.94339, 35.13198], [-117.94354, 35.13187], [-117.94361, 35.13167], [-117.94357, 35.13137], [-117.9434, 35.13101], [-117.94349, 35.13096], [-117.9435, 35.13093], [-117.94313, 35.13091], [-117.94315, 35.13046], [-117.9433, 35.13045], [-117.94332, 35.12994], [-117.94289, 35.12993], [-117.94286, 35.13016], [-117.94264, 35.13015], [-117.94267, 35.12929], [-117.94233, 35.12925], [-117.94229, 35.12918], [-117.94098, 35.12914], [-117.94092, 35.12908], [-117.94111, 35.12886], [-117.94107, 35.12882], [-117.94142, 35.12892], [-117.94213, 35.12881], [-117.94255, 35.12865], [-117.94255, 35.1284], [-117.94247, 35.12833], [-117.94236, 35.12785], [-117.94267, 35.1275], [-117.94311, 35.12732], [-117.94325, 35.12741], [-117.94311, 35.12771], [-117.94311, 35.12797], [-117.9434, 35.12807], [-117.94384, 35.12803], [-117.94422, 35.12792], [-117.94423, 35.12764], [-117.94412, 35.12743], [-117.94501, 35.12737], [-117.94523, 35.12746], [-117.94523, 35.12762], [-117.94495, 35.12785], [-117.9449, 35.1283], [-117.94442, 35.12849], [-117.94344, 35.12858], [-117.94331, 35.1287], [-117.94334, 35.12915], [-117.94312, 35.12929], [-117.94311, 35.12953], [-117.94375, 35.12968], [-117.94381, 35.12986], [-117.9437, 35.13002], [-117.9437, 35.1302], [-117.94384, 35.13032], [-117.94437, 35.13043], [-117.9447, 35.13062], [-117.94537, 35.13076], [-117.94551, 35.13094], [-117.94554, 35.13227], [-117.94546, 35.1323], [-117.94546, 35.13232], [-117.94558, 35.13231], [-117.94562, 35.13073], [-117.94666, 35.13073], [-117.94667, 35.13027], [-117.9477, 35.13027], [-117.94772, 35.13113], [-117.9478, 35.13123], [-117.9479, 35.13128], [-117.94815, 35.1313], [-117.94902, 35.13129], [-117.94923, 35.13128], [-117.94932, 35.13125], [-117.9494, 35.13119], [-117.94944, 35.13111], [-117.94945, 35.13026], [-117.94981, 35.13026], [-117.94971, 35.13033], [-117.94965, 35.13041], [-117.94966, 35.13115], [-117.94981, 35.13116], [-117.94984, 35.13219]]], [[[-117.95983, 35.12231], [-117.95872, 35.12232], [-117.95655, 35.12177], [-117.95527, 35.12204], [-117.95512, 35.12207], [-117.95498, 35.12215], [-117.95463, 35.12234], [-117.95354, 35.12419], [-117.95339, 35.12518], [-117.95338, 35.1258], [-117.95164, 35.1258], [-117.95164, 35.12565], [-117.95169, 35.12544], [-117.95179, 35.12528], [-117.9519, 35.12516], [-117.95197, 35.12482], [-117.95181, 35.12444], [-117.95159, 35.12419], [-117.95055, 35.12353], [-117.94994, 35.12329], [-117.94971, 35.12316], [-117.94946, 35.12327], [-117.9491, 35.12355], [-117.94868, 35.12484], [-117.94847, 35.12534], [-117.94855, 35.12537], [-117.9485, 35.12583], [-117.94503, 35.12583], [-117.94502, 35.12557], [-117.94396, 35.12425], [-117.94403, 35.1234], [-117.94411, 35.123], [-117.94433, 35.12284], [-117.94497, 35.12324], [-117.94504, 35.1241], [-117.94539, 35.12444], [-117.94632, 35.12517], [-117.94734, 35.12559], [-117.94869, 35.12353], [-117.9479, 35.12314], [-117.94735, 35.12303], [-117.94684, 35.12276], [-117.94475, 35.12249], [-117.94453, 35.12244], [-117.94455, 35.12223], [-117.94535, 35.12216], [-117.94711, 35.12197], [-117.94786, 35.12211], [-117.94949, 35.12295], [-117.94995, 35.12287], [-117.95071, 35.12241], [-117.95113, 35.12266], [-117.95203, 35.12267], [-117.95237, 35.12257], [-117.95337, 35.12203], [-117.95359, 35.12186], [-117.95369, 35.12163], [-117.95483, 35.12057], [-117.95504, 35.12008], [-117.95513, 35.11981], [-117.95503, 35.1193], [-117.95497, 35.11906], [-117.9549, 35.11863], [-117.95736, 35.11868], [-117.9566, 35.11915], [-117.9566, 35.11917], [-117.95706, 35.11977], [-117.95796, 35.12056], [-117.95832, 35.12077], [-117.95915, 35.12101], [-117.95961, 35.12121], [-117.95983, 35.12121], [-117.95983, 35.12231]]], [[[-117.96166, 35.13066], [-117.96126, 35.13091], [-117.96113, 35.13092], [-117.96104, 35.1309], [-117.96099, 35.13085], [-117.96056, 35.1304], [-117.95966, 35.13056], [-117.95925, 35.13016], [-117.95911, 35.12989], [-117.95782, 35.13009], [-117.9568, 35.13035], [-117.95606, 35.13048], [-117.95568, 35.13035], [-117.95516, 35.13034], [-117.95499, 35.13029], [-117.95449, 35.12986], [-117.95416, 35.12995], [-117.95384, 35.13031], [-117.95312, 35.1307], [-117.95258, 35.13121], [-117.95206, 35.13153], [-117.95173, 35.1316], [-117.95015, 35.13225], [-117.95013, 35.13111], [-117.95031, 35.13108], [-117.95081, 35.13083], [-117.95114, 35.13004], [-117.95112, 35.13003], [-117.95094, 35.13012], [-117.95063, 35.13023], [-117.95045, 35.13028], [-117.95022, 35.13031], [-117.95015, 35.13031], [-117.95013, 35.13014], [-117.95051, 35.13009], [-117.95062, 35.13004], [-117.9507, 35.13003], [-117.95098, 35.12992], [-117.95126, 35.12971], [-117.95141, 35.12956], [-117.95159, 35.12926], [-117.95161, 35.12918], [-117.95165, 35.12888], [-117.95164, 35.12853], [-117.95162, 35.12612], [-117.95344, 35.12612], [-117.95338, 35.12702], [-117.95347, 35.12749], [-117.95333, 35.12797], [-117.95298, 35.12825], [-117.95271, 35.1286], [-117.95263, 35.12887], [-117.95265, 35.1292], [-117.95372, 35.12922], [-117.95375, 35.12895], [-117.95428, 35.12885], [-117.95586, 35.12844], [-117.95667, 35.12839], [-117.95727, 35.12848], [-117.95813, 35.12838], [-117.95863, 35.12857], [-117.95895, 35.12859], [-117.96003, 35.12813], [-117.96003, 35.12819], [-117.96011, 35.12839], [-117.9602, 35.12869], [-117.96041, 35.12912], [-117.96055, 35.12933], [-117.96083, 35.12974], [-117.96166, 35.13066]]]]} | Restricted Access 2 | Tierra Del Sol Golf | 33049 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 178.183 | Tierra Del Sol Golf | ||
2501 | 2501 | 2500 | {"type": "Polygon", "coordinates": [[[-117.65941, 35.24431], [-117.65836, 35.24432], [-117.65836, 35.24364], [-117.65828, 35.24315], [-117.65816, 35.24293], [-117.65919, 35.24387], [-117.65941, 35.24431]]]} | Open Access 1 | California City holding 5 | 16709 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1.923 | California City holding 5 | ||
2509 | 2509 | 2508 | {"type": "Polygon", "coordinates": [[[-117.66203, 35.241], [-117.66202, 35.24427], [-117.65941, 35.24431], [-117.65919, 35.24387], [-117.65816, 35.24293], [-117.65836, 35.24106], [-117.66203, 35.241]]]} | Open Access 1 | California City holding 15 | 16695 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 28.555 | California City holding 15 | ||
2512 | 2512 | 2511 | {"type": "Polygon", "coordinates": [[[-117.66562, 35.18641], [-117.66149, 35.18644], [-117.65978, 35.18627], [-117.65981, 35.18583], [-117.66561, 35.18594], [-117.66562, 35.18641]]]} | Open Access 1 | California City holding 19 | 16699 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 7.556 | California City holding 19 | ||
2506 | 2506 | 2505 | {"type": "Polygon", "coordinates": [[[-117.66564, 35.18745], [-117.66446, 35.18721], [-117.66334, 35.1867], [-117.66264, 35.18668], [-117.66149, 35.18644], [-117.66562, 35.18641], [-117.66564, 35.18745]]]} | Open Access 1 | California City holding 12 | 16692 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 4.986 | California City holding 12 | ||
2516 | 2516 | 2515 | {"type": "Polygon", "coordinates": [[[-117.66566, 35.18855], [-117.65975, 35.1885], [-117.65978, 35.18627], [-117.66149, 35.18644], [-117.66264, 35.18668], [-117.66334, 35.1867], [-117.66446, 35.18721], [-117.66564, 35.18745], [-117.66566, 35.18855]]]} | Open Access 1 | California City holding 20 | 16701 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 26.188 | California City holding 20 | ||
3760 | 3760 | 3759 | {"type": "Polygon", "coordinates": [[[-117.70274, 35.27024], [-117.69774, 35.27032], [-117.69769, 35.26783], [-117.70266, 35.26773], [-117.70274, 35.27024]]]} | Open Access 1 | E Park | 18331 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 31.113 | E Park | ||
4813 | 4813 | 4812 | {"type": "Polygon", "coordinates": [[[-117.71537, 35.19254], [-117.71535, 35.19456], [-117.71106, 35.19462], [-117.71102, 35.19263], [-117.71537, 35.19254]]]} | Open Access 1 | H Park | 19580 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 21.644 | H Park | ||
4466 | 4466 | 4465 | {"type": "Polygon", "coordinates": [[[-117.75932, 35.21794], [-117.75625, 35.21792], [-117.75623, 35.21688], [-117.75651, 35.21681], [-117.75643, 35.21662], [-117.75622, 35.21657], [-117.7562, 35.21523], [-117.75745, 35.21522], [-117.75749, 35.2144], [-117.7592, 35.21439], [-117.75928, 35.21695], [-117.75923, 35.217], [-117.75928, 35.21713], [-117.75932, 35.21794]]]} | Open Access 1 | Galileo Hill Park | 19174 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 24.033 | Galileo Hill Park | ||
2504 | 2504 | 2503 | {"type": "Polygon", "coordinates": [[[-117.77229, 35.1638], [-117.77201, 35.16434], [-117.77031, 35.16558], [-117.76994, 35.16597], [-117.76939, 35.167], [-117.76933, 35.16753], [-117.76956, 35.16838], [-117.76975, 35.16886], [-117.76969, 35.16945], [-117.76955, 35.16976], [-117.76951, 35.16914], [-117.76942, 35.16876], [-117.76841, 35.16875], [-117.7684, 35.16826], [-117.76877, 35.1674], [-117.76886, 35.16681], [-117.76891, 35.16627], [-117.76909, 35.16595], [-117.76953, 35.1653], [-117.76956, 35.16465], [-117.76953, 35.16448], [-117.77127, 35.16445], [-117.77161, 35.1644], [-117.77164, 35.16403], [-117.7715, 35.1636], [-117.76951, 35.16363], [-117.76956, 35.16306], [-117.77214, 35.16304], [-117.77216, 35.16319], [-117.77225, 35.16349], [-117.77229, 35.1638]]]} | Open Access 1 | California City holding 10 | 16690 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 16.445 | California City holding 10 | ||
2505 | 2505 | 2504 | {"type": "Polygon", "coordinates": [[[-117.77282, 35.16525], [-117.77268, 35.16555], [-117.77152, 35.16564], [-117.77156, 35.17038], [-117.77014, 35.17041], [-117.76958, 35.17041], [-117.76955, 35.16976], [-117.76969, 35.16945], [-117.76975, 35.16886], [-117.76956, 35.16838], [-117.76933, 35.16752], [-117.76939, 35.167], [-117.76994, 35.16597], [-117.77031, 35.16558], [-117.77201, 35.16434], [-117.77229, 35.1638], [-117.77241, 35.16416], [-117.77269, 35.16479], [-117.77282, 35.16525]]]} | Open Access 1 | California City holding 11 | 16691 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 28.227 | California City holding 11 | ||
2452 | 2452 | 2451 | {"type": "Polygon", "coordinates": [[[-117.78011, 35.24315], [-117.7801, 35.24321], [-117.77715, 35.24484], [-117.77692, 35.24464], [-117.77674, 35.24445], [-117.77615, 35.2439], [-117.77531, 35.2432], [-117.77457, 35.24263], [-117.77554, 35.24168], [-117.77567, 35.24157], [-117.77596, 35.24141], [-117.77707, 35.24104], [-117.77785, 35.24206], [-117.77797, 35.24217], [-117.77812, 35.24229], [-117.77848, 35.24246], [-117.77941, 35.24264], [-117.7796, 35.2427], [-117.7798, 35.24282], [-117.78011, 35.24315]]]} | Open Access 1 | California City holding 7 | 16711 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 25.73 | California City holding 7 | ||
2507 | 2507 | 2506 | {"type": "Polygon", "coordinates": [[[-117.78144, 35.18139], [-117.78133, 35.18224], [-117.78107, 35.18291], [-117.78066, 35.18339], [-117.77995, 35.18383], [-117.77895, 35.18418], [-117.77676, 35.18527], [-117.77541, 35.18598], [-117.77414, 35.18683], [-117.77367, 35.1864], [-117.77319, 35.18585], [-117.77433, 35.18523], [-117.77557, 35.18426], [-117.77642, 35.18382], [-117.77685, 35.18375], [-117.7777, 35.18383], [-117.7781, 35.1837], [-117.77848, 35.18343], [-117.77881, 35.18305], [-117.77918, 35.1825], [-117.7797, 35.18139], [-117.78144, 35.18139]]]} | Open Access 1 | California City holding 13 | 16693 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 29.954 | California City holding 13 | ||
5314 | 5314 | 5313 | {"type": "Polygon", "coordinates": [[[-117.78613, 35.15297], [-117.78142, 35.15322], [-117.78147, 35.15123], [-117.7846, 35.1512], [-117.78608, 35.15118], [-117.78613, 35.15297]]]} | Open Access 1 | I Park | 20168 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 21.99 | I Park | ||
2508 | 2508 | 2507 | {"type": "Polygon", "coordinates": [[[-117.80335, 35.17567], [-117.80287, 35.17721], [-117.80288, 35.17729], [-117.80266, 35.17732], [-117.80235, 35.17739], [-117.79993, 35.17807], [-117.79977, 35.17642], [-117.79942, 35.17626], [-117.79986, 35.1756], [-117.80077, 35.176], [-117.80113, 35.17576], [-117.80117, 35.17569], [-117.80335, 35.17567]]]} | Open Access 1 | California City holding 14 | 16694 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 15.96 | California City holding 14 | ||
2515 | 2515 | 2514 | {"type": "Polygon", "coordinates": [[[-117.81267, 35.18624], [-117.81266, 35.18731], [-117.81188, 35.18733], [-117.81167, 35.1873], [-117.8115, 35.18723], [-117.81141, 35.18718], [-117.81134, 35.1871], [-117.81197, 35.18652], [-117.8121, 35.1864], [-117.81221, 35.18625], [-117.81267, 35.18624]]]} | Open Access 1 | California City holding 2 | 16700 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 2.492 | California City holding 2 | ||
2511 | 2511 | 2510 | {"type": "Polygon", "coordinates": [[[-117.81361, 35.18622], [-117.81361, 35.18722], [-117.81319, 35.1873], [-117.81266, 35.18731], [-117.81267, 35.18624], [-117.81361, 35.18622]]]} | Open Access 1 | California City holding 18 | 16698 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 2.509 | California City holding 18 | ||
2499 | 2499 | 2498 | {"type": "Polygon", "coordinates": [[[-117.81407, 35.17705], [-117.81403, 35.17719], [-117.81401, 35.17749], [-117.8139, 35.17769], [-117.81378, 35.1778], [-117.81366, 35.17787], [-117.81152, 35.17873], [-117.81123, 35.17822], [-117.81103, 35.17804], [-117.81085, 35.17757], [-117.81119, 35.17745], [-117.81157, 35.17728], [-117.81204, 35.17699], [-117.81239, 35.17673], [-117.8128, 35.1763], [-117.81407, 35.17705]]]} | Open Access 1 | California City holding 3 | 16707 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 10.295 | California City holding 3 | ||
2488 | 2488 | 2487 | {"type": "Polygon", "coordinates": [[[-117.81411, 35.18564], [-117.8141, 35.18621], [-117.81221, 35.18625], [-117.8123, 35.18612], [-117.81239, 35.18589], [-117.81244, 35.18568], [-117.81411, 35.18564]]]} | Open Access 1 | California City holding 21 | 16702 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 2.484 | California City holding 21 |
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]);