/// <summary>
/// Create dictionaries that is used for both querying and 'site mapping'
/// </summary>
// If you need to add a new site, this is where you do it
private void buildDictionaries()
{
//The queryDict creats a dictionary that maps a user friendly name (Victor made this up) to the column name in the Oracle Database
queryDict.Add("Time", "CHRONO");
queryDict.Add("Turbine Name", "SATT3");
queryDict.Add("Tag Name", "NAME");
queryDict.Add("AlarmList", "LOGLIST");
queryDict.Add("Tag Description", "TITLE");
queryDict.Add("Value", "NVAL");
queryDict.Add("Event", "EVTTITLE");
queryDict.Add("Username", "USERNAME");
queryDict.Add("Domain", "SATT1");
queryDict.Add("Nature", "SATT2");
queryDict.Add("Station", "STATION");
//This is where you add a new site. Although this method is for creating new dictionaries, this is actually creating a List within a factory method call.
//I really need to name this method better...
SiteFactory.createNewSite("BB1-SV-UCC1", 45, new string[] { "Baffin Bay 1", "Baffin Bay 2" }, new string[] { "BAFI1", "BAFI2" });
SiteFactory.createNewSite("BB1-SV-UCC2", 95, new string[] { "Baffin Bay 1", "Baffin Bay 2" }, new string[] { "BAFI1", "BAFI2" });
SiteFactory.createNewSite("BN1-SV-UCC1", 30, new string[] { "Barton 1", "Barton 2" }, new string[] { "BART1", "BART2" });
SiteFactory.createNewSite("BN1-SV-UCC2", 80, new string[] { "Barton 1", "Barton 2" }, new string[] { "BART1", "BART2" });
SiteFactory.createNewSite("BC1-SV-UCC1", 25, new string[] { "Barton Chapel" }, new string[] { "BARTC" });
SiteFactory.createNewSite("BC1-SV-UCC2", 75, new string[] { "Barton Chapel" }, new string[] { "BARTC" });
SiteFactory.createNewSite("BH1-SV-UCC1", 4, new string[] { "Big Horn 1", "Big Horn 2" }, new string[] { "BIGHO", "BIGH2" });
SiteFactory.createNewSite("BH1-SV-UCC2", 54, new string[] { "Big Horn 1", "Big Horn 2" }, new string[] { "BIGHO", "BIGH2" });
SiteFactory.createNewSite("BL1-SV-UCC1", 41, new string[] { "Blue Creek" }, new string[] { "BLUEC" });
SiteFactory.createNewSite("BL1-SV-UCC2", 91, new string[] { "Blue Creek" }, new string[] { "BLUEC" });
SiteFactory.createNewSite("BR2-SV-UCC1", 33, new string[] { "Buffalo Ridge 2" }, new string[] { "BUFA2" });
SiteFactory.createNewSite("BR2-SV-UCC2", 83, new string[] { "Buffalo Ridge 2" }, new string[] { "BUFA2" });
SiteFactory.createNewSite("CMCORE01", 22, new string[] { "Casselman" }, new string[] { "CASSE" });
SiteFactory.createNewSite("CM1-SV-UCC2", 72, new string[] { "Casselman" }, new string[] { "CASSE" });
SiteFactory.createNewSite("CR1-SV-UCC1", 26, new string[] { "Cayuga Ridge" }, new string[] { "CRIDG" });
SiteFactory.createNewSite("CR1-SV-UCC2", 76, new string[] { "Cayuga Ridge" }, new string[] { "CRIDG" });
SiteFactory.createNewSite("CG1-SV-UCC1", 11, new string[] { "Colorado Green" }, new string[] { "COGRE" });
SiteFactory.createNewSite("CG1-SV-UCC2", 61, new string[] { "Colorado Green" }, new string[] { "COGRE" });
SiteFactory.createNewSite("CC1CORE01", 40, new string[] { "Copper Crossing" }, new string[] { "COPER" });
SiteFactory.createNewSite("CO1-SV-UCC1", 57, new string[] { "Coyote Ridge" }, new string[] { "COYOT" });
SiteFactory.createNewSite("CO1-SV-UCC2", 107, new string[] { "Coyote Ridge" }, new string[] { "COYOT" });
SiteFactory.createNewSite("DE1-SV-UCC1", 50, new string[] { "Deerfield" }, new string[] { "DEERF" });
SiteFactory.createNewSite("DE1-SV-UCC2", 100, new string[] { "Deerfield" }, new string[] { "DEERF" });
SiteFactory.createNewSite("DW1-SV-UCC1", 47, new string[] { "Desert Wind" }, new string[] { "DESER" });
SiteFactory.createNewSite("DW1-SV-UCC2", 97, new string[] { "Desert Wind" }, new string[] { "DESER" });
SiteFactory.createNewSite("DI2-SV-UCC1", 9, new string[] { "Dillion" }, new string[] { "DILON" });
SiteFactory.createNewSite("DI2-SV-UCC2", 59, new string[] { "Dillion" }, new string[] { "DILON" });
SiteFactory.createNewSite("DLCORE01", 10, new string[] { "Dry Lake 1" }, new string[] { "DRYLA" });
SiteFactory.createNewSite("DL2-SV-UCC1", 32, new string[] { "Dry Lake 2" }, new string[] { "DRYL2" });
SiteFactory.createNewSite("DL2-SV-UCC2", 82, new string[] { "Dry Lake 2" }, new string[] { "DRYL2" });
SiteFactory.createNewSite("EL1-SV-UCC1", 254, new string[] { "El Cabo" }, new string[] { "ELCAB" });
SiteFactory.createNewSite("EL1-SV-UCC1", 48, new string[] { "El Cabo" }, new string[] { "ELCAB" });
SiteFactory.createNewSite("EL1-SV-UCC2", 98, new string[] { "El Cabo" }, new string[] { "ELCAB" });
SiteFactory.createNewSite("ER1-SV-UCC1", 12, new string[] { "Elk River" }, new string[] { "ELKRI" });
SiteFactory.createNewSite("ER1-SV-UCC2", 62, new string[] { "Elk River" }, new string[] { "ELKRI" });
SiteFactory.createNewSite("EC2CORE01", 34, new string[] { "Elm Creek 2" }, new string[] { "ELMC2" });
SiteFactory.createNewSite("EC2CORE02", 84, new string[] { "Elm Creek 2" }, new string[] { "ELMC2" });
SiteFactory.createNewSite("FA1-SV-UCC1", 16, new string[] { "Farmers City" }, new string[] { "FARME" });
SiteFactory.createNewSite("FA1-SV-UCC2", 66, new string[] { "Farmers City" }, new string[] { "FARME" });
SiteFactory.createNewSite("PT1-SV-FE01A", 201, new string[] { "FE01A" }, new string[] { "FE01" });
SiteFactory.createNewSite("PT1-SV-FE01C", 202, new string[] { "FE01C" }, new string[] { "FE01" });
SiteFactory.createNewSite("ACC-SV-FE01D", 227, new string[] { "FE01D" }, new string[] { "FE01" });
SiteFactory.createNewSite("PT1-SV-FE02A", 203, new string[] { "FE02A" }, new string[] { "FE02" });
SiteFactory.createNewSite("PT1-SV-FE02C", 204, new string[] { "FE02C" }, new string[] { "FE02" });
SiteFactory.createNewSite("ACC-SV-FE02D", 228, new string[] { "FE02D" }, new string[] { "FE02" });
SiteFactory.createNewSite("PT1-SV-FE03A", 205, new string[] { "FE03A" }, new string[] { "FE03" });
SiteFactory.createNewSite("PT1-SV-FE03C", 206, new string[] { "FE03C" }, new string[] { "FE03" });
SiteFactory.createNewSite("ACC-SV-FE03D", 229, new string[] { "FE03D" }, new string[] { "FE03" });
SiteFactory.createNewSite("PT1-SV-FE04A", 207, new string[] { "FE04A" }, new string[] { "FE04" });
SiteFactory.createNewSite("PT1-SV-FE04C", 208, new string[] { "FE04C" }, new string[] { "FE04" });
SiteFactory.createNewSite("ACC-SV-FE04D", 230, new string[] { "FE04D" }, new string[] { "FE04" });
SiteFactory.createNewSite("PT1-SV-FE05A", 209, new string[] { "FE05A" }, new string[] { "FE05" });
SiteFactory.createNewSite("PT1-SV-FE05C", 210, new string[] { "FE05C" }, new string[] { "FE05" });
SiteFactory.createNewSite("ACC-SV-FE05D", 231, new string[] { "FE05D" }, new string[] { "FE05" });
SiteFactory.createNewSite("PT1-SV-FE06A", 211, new string[] { "FE06A" }, new string[] { "FE06" });
SiteFactory.createNewSite("PT1-SV-FE06C", 212, new string[] { "FE06C" }, new string[] { "FE06" });
SiteFactory.createNewSite("ACC-SV-FE06D", 232, new string[] { "FE06D" }, new string[] { "FE06" });
SiteFactory.createNewSite("PT1-SV-FE07A", 213, new string[] { "FE07A" }, new string[] { "FE07" });
SiteFactory.createNewSite("PT1-SV-FE07C", 214, new string[] { "FE07C" }, new string[] { "FE07" });
SiteFactory.createNewSite("ACC-SV-FE07D", 233, new string[] { "FE07D" }, new string[] { "FE07" });
SiteFactory.createNewSite("PT1-SV-FE08A", 215, new string[] { "FE08A" }, new string[] { "FE08" });
SiteFactory.createNewSite("PT1-SV-FE08C", 216, new string[] { "FE08C" }, new string[] { "FE08" });
SiteFactory.createNewSite("ACC-SV-FE08D", 234, new string[] { "FE08D" }, new string[] { "FE08" });
SiteFactory.createNewSite("PT1-SV-FE09A", 217, new string[] { "FE09A" }, new string[] { "FE09" });
SiteFactory.createNewSite("PT1-SV-FE09C", 218, new string[] { "FE09C" }, new string[] { "FE09" });
SiteFactory.createNewSite("ACC-SV-FE09D", 235, new string[] { "FE09D" }, new string[] { "FE09" });
SiteFactory.createNewSite("PT1-SV-FE10A", 219, new string[] { "FE10A" }, new string[] { "FE10" });
SiteFactory.createNewSite("PT1-SV-FE10C", 220, new string[] { "FE10C" }, new string[] { "FE10" });
SiteFactory.createNewSite("ACC-SV-FE10D", 236, new string[] { "FE10D" }, new string[] { "FE10" });
SiteFactory.createNewSite("PT1-SV-FE11A", 221, new string[] { "FE11A" }, new string[] { "FE11" });
SiteFactory.createNewSite("PT1-SV-FE11C", 222, new string[] { "FE11C" }, new string[] { "FE11" });
SiteFactory.createNewSite("ACC-SV-FE11D", 237, new string[] { "FE11D" }, new string[] { "FE11" });
SiteFactory.createNewSite("PT1-SV-FE12A", 223, new string[] { "FE12A" }, new string[] { "FE12" });
SiteFactory.createNewSite("PT1-SV-FE12C", 224, new string[] { "FE12C" }, new string[] { "FE12" });
SiteFactory.createNewSite("ACC-SV-FE12D", 238, new string[] { "FE12D" }, new string[] { "FE12" });
SiteFactory.createNewSite("PT1-SV-FE13A", 225, new string[] { "FE13A" }, new string[] { "FE13" });
SiteFactory.createNewSite("PT1-SV-FE14A", 151, new string[] { "FE14A" }, new string[] { "FE14" });
SiteFactory.createNewSite("PT1-SV-FE14C", 152, new string[] { "FE14C" }, new string[] { "FE14" });
SiteFactory.createNewSite("ACC-SV-FE14D", 177, new string[] { "FE14D" }, new string[] { "FE14" });
SiteFactory.createNewSite("PT1-SV-FE15A", 153, new string[] { "FE15A" }, new string[] { "FE15" });
SiteFactory.createNewSite("PT1-SV-FE15C", 154, new string[] { "FE15C" }, new string[] { "FE15" });
SiteFactory.createNewSite("ACC-SV-FE15D", 178, new string[] { "FE15D" }, new string[] { "FE15" });
SiteFactory.createNewSite("PT1-SV-FE16A", 155, new string[] { "FE16A" }, new string[] { "FE16" });
SiteFactory.createNewSite("PT1-SV-FE16C", 156, new string[] { "FE16C" }, new string[] { "FE16" });
SiteFactory.createNewSite("ACC-SV-FE16D", 179, new string[] { "FE16D" }, new string[] { "FE16" });
SiteFactory.createNewSite("PT1-SV-FE17A", 157, new string[] { "FE17A" }, new string[] { "FE17" });
SiteFactory.createNewSite("PT1-SV-FE17C", 158, new string[] { "FE17C" }, new string[] { "FE17" });
SiteFactory.createNewSite("ACC-SV-FE17D", 180, new string[] { "FE17D" }, new string[] { "FE17" });
SiteFactory.createNewSite("PT1-SV-FE18A", 333, new string[] { "FE18A" }, new string[] { "FE18" });
SiteFactory.createNewSite("PT1-SV-FE18C", 333, new string[] { "FE18C" }, new string[] { "FE18" });
SiteFactory.createNewSite("ACC-SV-FE18D", 333, new string[] { "FE18D" }, new string[] { "FE18" });
SiteFactory.createNewSite("PT1-SV-FE19A", 333, new string[] { "FE19A" }, new string[] { "FE19" });
SiteFactory.createNewSite("ACC-SV-FE19D", 333, new string[] { "FE19A" }, new string[] { "FE19" });
SiteFactory.createNewSite("PT1-SV-FE19C", 333, new string[] { "FE19C" }, new string[] { "FE19" });
SiteFactory.createNewSite("FCCORE01", 14, new string[] { "Flying Cloud" }, new string[] { "FLYCO" });
SiteFactory.createNewSite("FC1-SV-UCC2", 64, new string[] { "Flying Cloud" }, new string[] { "FLYCO" });
SiteFactory.createNewSite("GA1-SV-UCC1", 49, new string[] { "Gala" }, new string[] { "GALA1" });
SiteFactory.createNewSite("GA1-SV-UCC2", 99, new string[] { "Gala" }, new string[] { "GALA1" });
SiteFactory.createNewSite("GR1-SV-UCC1", 39, new string[] { "Groton" }, new string[] { "GROTO" });
SiteFactory.createNewSite("GR1-SV-UCC2", 89, new string[] { "Groton" }, new string[] { "GROTO" });
SiteFactory.createNewSite("HS1-SV-UCC1", 29, new string[] { "Hardscrabble" }, new string[] { "SCRAB" });
SiteFactory.createNewSite("HS1-SV-UCC2", 79, new string[] { "Hardscrabble" }, new string[] { "SCRAB" });
SiteFactory.createNewSite("HA1-SV-UCC1", 5, new string[] { "Hay Canyon " }, new string[] { "HAYCA" });
SiteFactory.createNewSite("HO1-SV-UCC1", 38, new string[] { "Hoosac" }, new string[] { "HOOSA" });
SiteFactory.createNewSite("HO1-SV-UCC2", 88, new string[] { "Hoosac" }, new string[] { "HOOSA" });
SiteFactory.createNewSite("JC1-SV-UCC1", 27, new string[] { "Juniper Canyon" }, new string[] { "JUNCA" });
SiteFactory.createNewSite("JC1-SV-UCC2", 77, new string[] { "Juniper Canyon" }, new string[] { "JUNCA" });
SiteFactory.createNewSite("KA1-SV-UCC1", 56, new string[] { "Karakawa" }, new string[] { "KARAN" });
SiteFactory.createNewSite("KA1-SV-UCC2", 106, new string[] { "Karakawa" }, new string[] { "KARAN" });
SiteFactory.createNewSite("KM1-SV-UCC1", 46, new string[] { "Klamath Falls" }, new string[] { "KLAMA" });
SiteFactory.createNewSite("KM1-SV-UCC2", 96, new string[] { "Klamath Falls" }, new string[] { "KLAMA" });
SiteFactory.createNewSite("KL1-SV-UCC1", 3, new string[] { "Klondike", "Klondike 2", "Klondike Mitsubishi", "Klondike 3A", "Klondike 3GE", "Klondike Siemens" }, new string[] { "KLON1", "KLON2", "KLONM", "KLONA", "KLONG", "KLONS" });
SiteFactory.createNewSite("KL1-SV-UCC2", 53, new string[] { "Klondike", "Klondike 2", "Klondike Mitsubishi", "Klondike 3A", "Klondike 3GE", "Klondike Siemens" }, new string[] { "KLON1", "KLON2", "KLONM", "KLONA", "KLONG", "KLONS" });
SiteFactory.createNewSite("LJA-SV-UCC1", 28, new string[] { "Leaning Juniper 2 A" }, new string[] { "LEJUN" });
SiteFactory.createNewSite("LJB-SV-UCC1", 31, new string[] { "Leaning Juniper 2 B" }, new string[] { "LEJU2" });
SiteFactory.createNewSite("LJB-SV-UCC2", 81, new string[] { "Leaning Juniper 2 B" }, new string[] { "LEJU2" });
SiteFactory.createNewSite("LP1-SV-UCC1", 17, new string[] { "Lempster" }, new string[] { "LEMPS" });
SiteFactory.createNewSite("LP1-SV-UCC2", 67, new string[] { "Lempster" }, new string[] { "LEMPS" });
SiteFactory.createNewSite("LR2-SV-UCC1", 68, new string[] { "Locus Ridge 1", "Locus Ridge 2" }, new string[] { "LRID1", "LRID2" });
SiteFactory.createNewSite("LR2-SV-UCC2", 18, new string[] { "Locus Ridge 1", "Locus Ridge 2" }, new string[] { "LRID1", "LRID2" });
SiteFactory.createNewSite("MZ1-SV-UCC1", 35, new string[] { "Manzana" }, new string[] { "MANZA" });
SiteFactory.createNewSite("MZ1-SV-UCC2", 85, new string[] { "Manzana" }, new string[] { "MANZA" });
SiteFactory.createNewSite("MR1-SV-UCC1", 23, new string[] { "MapleRidge 1" }, new string[] { "MRIDG", "MRID2", "MRID3" });
SiteFactory.createNewSite("MD1-SV-UCC1", 1, new string[] { "Minndakota", "Buffalo Ridge" }, new string[] { "MINND", "BUFAL" });
SiteFactory.createNewSite("MDCORE02", 51, new string[] { "Minndakota", "Buffalo Ridge" }, new string[] { "MINND", "BUFAL" });
SiteFactory.createNewSite("MG1-SV-UCC1", 55, new string[] { "Montague" }, new string[] { "MONTA" });
SiteFactory.createNewSite("MG1-SV-UCC2", 105, new string[] { "Montague" }, new string[] { "MONTA" });
SiteFactory.createNewSite("MO1-SV-UCC1", 20, new string[] { "Moraine" }, new string[] { "MORA1", "MORA2" });
SiteFactory.createNewSite("MO1-SV-UCC2", 70, new string[] { "Moraine" }, new string[] { "MORA1", "MORA2" });
SiteFactory.createNewSite("MV3CORE01", 37, new string[] { "Mountain View 3" }, new string[] { "MV3" });
SiteFactory.createNewSite("NH1-SV-UCC1", 42, new string[] { "New Harvest" }, new string[] { "NEWHA" });
SiteFactory.createNewSite("NHCORE02", 92, new string[] { "New Harvest" }, new string[] { "NEWHA" });
SiteFactory.createNewSite("OC1-SV-UCC1", 58, new string[] { "Ottercreek" }, new string[] { "OTTER" });
SiteFactory.createNewSite("OC1-SV-UCC2", 108, new string[] { "Ottercreek" }, new string[] { "OTTER" });
SiteFactory.createNewSite("PA1-SV-UCC1", 54, new string[] { "Patriot" }, new string[] { "PATRI" });
SiteFactory.createNewSite("PA1-SV-UCC2", 104, new string[] { "Patriot" }, new string[] { "PATRI" });
SiteFactory.createNewSite("PB1-SV-UCC1", 6, new string[] { "Pebble Spring" }, new string[] { "PESPR" });
SiteFactory.createNewSite("PS1-SV-UCC1", 24, new string[] { "Penascal 1", "Penascal 2", "Penascal 3" }, new string[] { "PENE1", "PENE2", "PENE3" });
SiteFactory.createNewSite("PS1-SV-UCC2", 74, new string[] { "Penascal 1", "Penascal 2", "Penascal 3" }, new string[] { "PENE1", "PENE2", "PENE3" });
SiteFactory.createNewSite("PH1-SV-UCC1", 19, new string[] { "Providence Heights" }, new string[] { "PROVH" });
SiteFactory.createNewSite("PH1-SV-UCC2", 69, new string[] { "Providence Heights" }, new string[] { "PROVH" });
SiteFactory.createNewSite("RUCORE01", 21, new string[] { "Rugby" }, new string[] { "RUGBY" });
SiteFactory.createNewSite("SA1-SV-UCC1", 44, new string[] { "San Luis" }, new string[] { "SLUIS" });
SiteFactory.createNewSite("SHCORE01", 8, new string[] { "Shiloh" }, new string[] { "SHILO" });
SiteFactory.createNewSite("SH1-SV-UCC2", 58, new string[] { "Shiloh" }, new string[] { "SHILO" });
SiteFactory.createNewSite("SC1-SV-UCC1", 43, new string[] { "South Chestnut" }, new string[] { "SCHES" });
SiteFactory.createNewSite("SC1-SV-UCC2", 93, new string[] { "South Chestnut" }, new string[] { "SCHES" });
SiteFactory.createNewSite("SP1-SV-UCC1", 7, new string[] { "Star Point" }, new string[] { "STPOI" });
SiteFactory.createNewSite("SP1-SV-UCC2", 57, new string[] { "Star Point" }, new string[] { "STPOI" });
SiteFactory.createNewSite("TI2-SV-UCC1", 36, new string[] { "Top of Iowa 2" }, new string[] { "TOPIO" });
SiteFactory.createNewSite("TI2-SV-UCC2", 86, new string[] { "Top of Iowa 2" }, new string[] { "TOPIO" });
SiteFactory.createNewSite("TR1-SV-UCC1", 13, new string[] { "Trimont", "Elm Creek 1" }, new string[] { "TRIMO", "ELMCR" });
SiteFactory.createNewSite("TR1-SV-UCC2", 63, new string[] { "Trimont", "ELm Creek 1" }, new string[] { "TRIMO", "ELMCR" });
SiteFactory.createNewSite("TU1-SV-UCC1", 51, new string[] { "Tule" }, new string[] { "TULE1" });
SiteFactory.createNewSite("TU1-SV-UCC2", 101, new string[] { "Tule" }, new string[] { "TULE1" });
SiteFactory.createNewSite("TB1-SV-UCC1", 15, new string[] { "Twin Buttes 1" }, new string[] { "TWINB" });
SiteFactory.createNewSite("TB1-SV-UCC2", 65, new string[] { "Twin Buttes 1" }, new string[] { "TWINB" });
SiteFactory.createNewSite("TB2-SV-UCC1", 52, new string[] { "Twin Buttes 2" }, new string[] { "TWIN2" });
SiteFactory.createNewSite("TB2-SV-UCC2", 102, new string[] { "Twin Buttes 2" }, new string[] { "TWIN2" });
SiteFactory.createNewSite("WB1-SV-UCC1", 2, new string[] { "Winnebago" }, new string[] { "WINNE" });
SiteFactory.createNewSite("WB1-SV-UCC2", 52, new string[] { "Winnebago" }, new string[] { "WINNE" });
SiteFactory.createNewSite("KL1-WYEAST-UCC", 250, new string[] { "Wyeast" }, new string[] { "WYEAS" });
//Create new filters
SiteFactory.createNewFilter("WindNode", "LOGLIST = 'ALMFE16' AND SATT1 = 'CORE'");
SiteFactory.createNewFilter("RAS", "LOGLIST='RAS'");
SiteFactory.createNewFilter("FrontVue", "LOGLIST='ALMFE16' AND STATION =0");
}
