superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
64 rows where MNG_AGENCY = 26 sorted by PARK_URL
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
797 | 797 | 796 | {"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 | 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 | 9.402 | Alameda Park | ||
1100 | 1100 | 1099 | {"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 | 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 | 4.663 | Alice Keck Park Memorial Garden | ||
1469 | 1469 | 1468 | {"type": "Polygon", "coordinates": [[[-119.69229, 34.41084], [-119.69211, 34.41099], [-119.69147, 34.41051], [-119.69164, 34.41036], [-119.69229, 34.41084]]]} | Open Access 1 | Ambassador Park | 15441 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 0.456 | Ambassador Park | ||
1490 | 1490 | 1489 | {"type": "Polygon", "coordinates": [[[-119.6649, 34.42122], [-119.66069, 34.42234], [-119.65994, 34.42248], [-119.65896, 34.42255], [-119.65662, 34.42136], [-119.65665, 34.42119], [-119.65672, 34.42104], [-119.65679, 34.42096], [-119.65693, 34.42083], [-119.65709, 34.42072], [-119.65739, 34.42055], [-119.65768, 34.42042], [-119.65788, 34.42036], [-119.65829, 34.42029], [-119.66117, 34.4201], [-119.66131, 34.42008], [-119.66144, 34.42003], [-119.66163, 34.41991], [-119.66191, 34.41967], [-119.6621, 34.41949], [-119.66229, 34.4192], [-119.6626, 34.41855], [-119.66269, 34.41843], [-119.6628, 34.41832], [-119.663, 34.41821], [-119.66314, 34.41816], [-119.66437, 34.4179], [-119.66417, 34.41799], [-119.66395, 34.41844], [-119.66327, 34.41888], [-119.66314, 34.41969], [-119.66331, 34.41997], [-119.66379, 34.42021], [-119.66422, 34.42048], [-119.66476, 34.42078], [-119.66479, 34.42118], [-119.6649, 34.42122]]]} | Open Access 1 | Andre Clark Bird Refuge | 15482 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 40.913 | Andre Clark Bird Refuge | ||
1734 | 1734 | 1733 | {"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 | 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 | 4.413 | Cabrillo Bell Park | ||
2119 | 2119 | 2118 | {"type": "Polygon", "coordinates": [[[-119.71388, 34.41721], [-119.71339, 34.41767], [-119.71311, 34.41748], [-119.71262, 34.41794], [-119.71134, 34.41701], [-119.71188, 34.41649], [-119.71202, 34.41659], [-119.71201, 34.41662], [-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.71295, 34.41735], [-119.71345, 34.41689], [-119.71388, 34.41721]]]} | Open Access 1 | 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 | 3.591 | Bohnett Park | ||
2863 | 2863 | 2862 | {"type": "MultiPolygon", "coordinates": [[[[-119.68898, 34.41211], [-119.68773, 34.41331], [-119.68681, 34.41412], [-119.6866, 34.41423], [-119.68633, 34.41434], [-119.68608, 34.41444], [-119.6858, 34.41453], [-119.6855, 34.41459], [-119.68359, 34.41486], [-119.67847, 34.41544], [-119.67588, 34.41588], [-119.67218, 34.41663], [-119.67189, 34.41642], [-119.6721, 34.41639], [-119.67257, 34.41627], [-119.67287, 34.41615], [-119.67322, 34.41608], [-119.6734, 34.41608], [-119.6737, 34.41601], [-119.67381, 34.416], [-119.67398, 34.41595], [-119.67414, 34.41594], [-119.67433, 34.41587], [-119.67443, 34.41586], [-119.67453, 34.41581], [-119.67466, 34.41581], [-119.67476, 34.41577], [-119.67487, 34.41577], [-119.67502, 34.41572], [-119.67515, 34.41571], [-119.67532, 34.41564], [-119.676, 34.41553], [-119.67616, 34.41547], [-119.67634, 34.41544], [-119.67685, 34.41528], [-119.67693, 34.41528], [-119.67771, 34.4151], [-119.67811, 34.41504], [-119.67828, 34.41498], [-119.6785, 34.41496], [-119.67885, 34.41487], [-119.67932, 34.41481], [-119.67977, 34.41478], [-119.68027, 34.41471], [-119.68075, 34.41459], [-119.68096, 34.41448], [-119.68111, 34.41443], [-119.68152, 34.41436], [-119.68168, 34.41435], [-119.68187, 34.41428], [-119.68211, 34.41424], [-119.68232, 34.41415], [-119.68248, 34.41405], [-119.68304, 34.41385], [-119.68321, 34.41382], [-119.68343, 34.41375], [-119.68368, 34.41375], [-119.68413, 34.41361], [-119.68458, 34.4136], [-119.68505, 34.41352], [-119.68519, 34.41344], [-119.68541, 34.41334], [-119.68676, 34.41258], [-119.68787, 34.41207], [-119.68817, 34.41191], [-119.68847, 34.41181], [-119.68852, 34.4118], [-119.68898, 34.41211]]], [[[-119.68695, 34.4149], [-119.68489, 34.41548], [-119.68074, 34.41666], [-119.68055, 34.41553], [-119.68057, 34.41549], [-119.68061, 34.41546], [-119.68255, 34.41524], [-119.68568, 34.4148], [-119.68597, 34.41474], [-119.68626, 34.41466], [-119.68673, 34.41447], [-119.68676, 34.41447], [-119.68679, 34.4145], [-119.68695, 34.4149]]]]} | Open Access 1 | Chase Palm Park | 17155 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 42.884 | Chase Palm Park | ||
3043 | 3043 | 3042 | {"type": "Polygon", "coordinates": [[[-119.7272, 34.4336], [-119.72698, 34.43445], [-119.72664, 34.43545], [-119.72639, 34.43526], [-119.72657, 34.43483], [-119.72679, 34.43463], [-119.72695, 34.43445], [-119.72702, 34.43417], [-119.72681, 34.43413], [-119.72683, 34.43397], [-119.72706, 34.43399], [-119.72716, 34.43359], [-119.7272, 34.4336]]]} | Unknown Access 4 | El Mission Creek | 18514 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 0.723 | El Mission Creek | ||
3048 | 3048 | 3047 | {"type": "Polygon", "coordinates": [[[-119.74164, 34.43295], [-119.74153, 34.43576], [-119.73894, 34.43575], [-119.73887, 34.43693], [-119.73869, 34.43693], [-119.73853, 34.43695], [-119.73837, 34.437], [-119.73822, 34.43708], [-119.73804, 34.43724], [-119.73783, 34.43753], [-119.73766, 34.43766], [-119.73751, 34.43772], [-119.73402, 34.43838], [-119.73394, 34.43798], [-119.73391, 34.43769], [-119.73392, 34.43573], [-119.73369, 34.43572], [-119.73366, 34.43384], [-119.73517, 34.43386], [-119.73518, 34.43141], [-119.73888, 34.43138], [-119.73888, 34.42908], [-119.73969, 34.42935], [-119.74016, 34.42954], [-119.74079, 34.42982], [-119.7407, 34.4325], [-119.74164, 34.43295]]]} | Restricted Access 2 | Santa Barbara Golf Club | 32988 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 110.09 | Santa Barbara Golf Club | ||
3203 | 3203 | 3202 | {"type": "Polygon", "coordinates": [[[-119.72847, 34.41054], [-119.72834, 34.41074], [-119.72791, 34.41158], [-119.72565, 34.41096], [-119.72618, 34.40986], [-119.72626, 34.40989], [-119.72631, 34.40981], [-119.72847, 34.41054]]]} | Open Access 1 | 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 | 7.274 | Escondido Park | ||
3682 | 3682 | 3681 | {"type": "Polygon", "coordinates": [[[-119.74327, 34.40268], [-119.74281, 34.40401], [-119.74072, 34.40453], [-119.74071, 34.40455], [-119.74078, 34.40476], [-119.74033, 34.40489], [-119.74028, 34.4048], [-119.73989, 34.40491], [-119.73946, 34.40497], [-119.73853, 34.40494], [-119.73635, 34.40462], [-119.73614, 34.40469], [-119.73598, 34.40469], [-119.73437, 34.40428], [-119.73675, 34.40425], [-119.73677, 34.4032], [-119.73676, 34.40304], [-119.73681, 34.40121], [-119.73505, 34.40118], [-119.73505, 34.40069], [-119.73483, 34.40057], [-119.73463, 34.40056], [-119.73462, 34.39855], [-119.73629, 34.39906], [-119.73669, 34.39936], [-119.73706, 34.39956], [-119.73799, 34.40017], [-119.73809, 34.40013], [-119.7381, 34.4002], [-119.73836, 34.40032], [-119.73916, 34.40081], [-119.74042, 34.40149], [-119.7427, 34.40247], [-119.74327, 34.40268]]]} | Open Access 1 | Douglas Family Reserve | 18243 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 68.849 | Douglas Family Reserve | ||
3757 | 3757 | 3756 | {"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 | 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 | 7.686 | Dwight Murphy Field | ||
3788 | 3788 | 3787 | {"type": "Polygon", "coordinates": [[[-119.67194, 34.41667], [-119.669, 34.41725], [-119.66872, 34.41728], [-119.66845, 34.41728], [-119.66817, 34.41726], [-119.66745, 34.41715], [-119.6672, 34.41714], [-119.66696, 34.41715], [-119.66476, 34.41752], [-119.66303, 34.41788], [-119.66286, 34.41796], [-119.66271, 34.41806], [-119.66258, 34.41819], [-119.66244, 34.41841], [-119.66263, 34.418], [-119.66275, 34.41799], [-119.66293, 34.41765], [-119.66235, 34.41717], [-119.66236, 34.41673], [-119.66251, 34.41671], [-119.6634, 34.41653], [-119.66377, 34.41657], [-119.66411, 34.41652], [-119.66485, 34.41655], [-119.66517, 34.41651], [-119.66579, 34.41653], [-119.66638, 34.41643], [-119.66731, 34.41649], [-119.67157, 34.41641], [-119.67194, 34.41667]]]} | Open Access 1 | East Beach | 18362 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 18.757 | East Beach | ||
3802 | 3802 | 3801 | {"type": "Polygon", "coordinates": [[[-119.67798, 34.42666], [-119.67699, 34.42759], [-119.67641, 34.42717], [-119.6774, 34.42624], [-119.67798, 34.42666]]]} | Open Access 1 | East Side Neighborhood Park | 18383 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 2.402 | East Side Neighborhood Park | ||
3937 | 3937 | 3936 | {"type": "Polygon", "coordinates": [[[-119.7343, 34.41613], [-119.73406, 34.41714], [-119.73257, 34.41702], [-119.73165, 34.41638], [-119.73244, 34.41545], [-119.73233, 34.41537], [-119.7324, 34.41534], [-119.73246, 34.4153], [-119.73249, 34.41525], [-119.7325, 34.41518], [-119.7323, 34.41434], [-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.41602], [-119.7343, 34.41613]]]} | Open Access 1 | 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 | 8.847 | Elings Park | ||
4358 | 4358 | 4357 | {"type": "MultiPolygon", "coordinates": [[[[-119.69777, 34.44032], [-119.69777, 34.44084], [-119.69696, 34.44067], [-119.69697, 34.44231], [-119.69618, 34.44213], [-119.69597, 34.44191], [-119.69602, 34.4418], [-119.69605, 34.44141], [-119.69625, 34.44117], [-119.69627, 34.44112], [-119.69626, 34.44105], [-119.6962, 34.44096], [-119.69575, 34.44069], [-119.69547, 34.44062], [-119.69581, 34.44057], [-119.69589, 34.44057], [-119.6959, 34.4402], [-119.69569, 34.44015], [-119.69557, 34.44016], [-119.69546, 34.44018], [-119.69532, 34.44024], [-119.69478, 34.44055], [-119.69335, 34.44044], [-119.69273, 34.4401], [-119.69351, 34.44024], [-119.69379, 34.44013], [-119.69402, 34.4398], [-119.69447, 34.43964], [-119.69527, 34.43963], [-119.69606, 34.43974], [-119.69692, 34.43992], [-119.69777, 34.44032]]], [[[-119.69693, 34.43941], [-119.69691, 34.43943], [-119.69691, 34.43976], [-119.69613, 34.43958], [-119.6952, 34.43947], [-119.69444, 34.43947], [-119.69417, 34.43957], [-119.69415, 34.43941], [-119.69311, 34.43942], [-119.69314, 34.43877], [-119.69693, 34.43923], [-119.69693, 34.43941]]]]} | Open Access 1 | Franceschi Park | 19043 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 16.168 | Franceschi Park | ||
4842 | 4842 | 4841 | {"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 | 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 | 12.799 | Hale Park | ||
5120 | 5120 | 5119 | {"type": "MultiPolygon", "coordinates": [[[[-119.75025, 34.42221], [-119.75027, 34.4225], [-119.75032, 34.42268], [-119.75041, 34.42282], [-119.75062, 34.42303], [-119.75066, 34.42315], [-119.75069, 34.42406], [-119.75073, 34.42421], [-119.75088, 34.42452], [-119.75092, 34.42468], [-119.7509, 34.42564], [-119.75085, 34.42585], [-119.75076, 34.42605], [-119.75063, 34.42623], [-119.75045, 34.42643], [-119.75037, 34.42656], [-119.75025, 34.42691], [-119.74963, 34.42691], [-119.74999, 34.42633], [-119.75011, 34.42602], [-119.75014, 34.42574], [-119.74994, 34.42554], [-119.74988, 34.4254], [-119.75025, 34.4249], [-119.75025, 34.42476], [-119.74978, 34.42439], [-119.74961, 34.4242], [-119.74951, 34.42403], [-119.74953, 34.42385], [-119.74967, 34.4237], [-119.74975, 34.4235], [-119.74983, 34.42345], [-119.74972, 34.42319], [-119.74956, 34.4231], [-119.74952, 34.42316], [-119.74937, 34.42303], [-119.74915, 34.42294], [-119.74872, 34.42269], [-119.74873, 34.42249], [-119.74887, 34.42206], [-119.74877, 34.4219], [-119.7485, 34.42179], [-119.7481, 34.42156], [-119.74832, 34.42139], [-119.74919, 34.42152], [-119.74931, 34.42163], [-119.7494, 34.42186], [-119.74927, 34.42192], [-119.74925, 34.42209], [-119.7493, 34.42223], [-119.74937, 34.42226], [-119.75025, 34.42221]]], [[[-119.75135, 34.42914], [-119.75061, 34.42944], [-119.75042, 34.43027], [-119.75038, 34.4311], [-119.74987, 34.43189], [-119.74995, 34.43212], [-119.75014, 34.43251], [-119.74972, 34.43262], [-119.74914, 34.43315], [-119.74924, 34.43345], [-119.74892, 34.43323], [-119.74894, 34.43305], [-119.74912, 34.43286], [-119.74925, 34.43281], [-119.7494, 34.43262], [-119.74942, 34.43254], [-119.74969, 34.43239], [-119.74984, 34.43239], [-119.74993, 34.43231], [-119.74988, 34.4322], [-119.74991, 34.43212], [-119.74982, 34.43203], [-119.74969, 34.43174], [-119.74978, 34.43157], [-119.74969, 34.4315], [-119.74979, 34.43142], [-119.74981, 34.43128], [-119.74984, 34.43122], [-119.74991, 34.43114], [-119.75012, 34.43099], [-119.75018, 34.4309], [-119.75011, 34.4308], [-119.75019, 34.43059], [-119.7502, 34.43043], [-119.75003, 34.4301], [-119.75005, 34.42985], [-119.75051, 34.42936], [-119.751, 34.42907], [-119.75104, 34.42877], [-119.75091, 34.42841], [-119.75064, 34.42814], [-119.75025, 34.42817], [-119.75007, 34.42806], [-119.74999, 34.42785], [-119.74997, 34.42758], [-119.75001, 34.42733], [-119.75012, 34.4271], [-119.75043, 34.42765], [-119.75061, 34.42793], [-119.75133, 34.42859], [-119.75135, 34.42914]]]]} | Open Access 1 | Hidden Valley Park | 19919 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 17.716 | Hidden Valley Park | ||
5147 | 5147 | 5146 | {"type": "Polygon", "coordinates": [[[-119.72525, 34.4118], [-119.72524, 34.41189], [-119.72517, 34.41196], [-119.725, 34.41202], [-119.72497, 34.41202], [-119.72474, 34.41246], [-119.72467, 34.4125], [-119.72461, 34.41249], [-119.72448, 34.41204], [-119.72439, 34.41189], [-119.72486, 34.41146], [-119.72523, 34.41174], [-119.72525, 34.4118]]]} | Open Access 1 | Hilda Ray Park | 19957 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1.124 | Hilda Ray Park | ||
5235 | 5235 | 5234 | {"type": "Polygon", "coordinates": [[[-119.71793, 34.40835], [-119.71759, 34.40933], [-119.7174, 34.40926], [-119.71644, 34.40915], [-119.71625, 34.40916], [-119.71528, 34.40937], [-119.71521, 34.40916], [-119.71496, 34.40912], [-119.71278, 34.40837], [-119.71396, 34.40727], [-119.71483, 34.40644], [-119.71793, 34.40835]]]} | Open Access 1 | Honda Valley Park | 20065 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 20.686 | Honda Valley Park |
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]);