public void TestUsgsQualificationCodes()
{
UsgsDailyValueSeries s = new UsgsDailyValueSeries("13168500", UsgsDailyParameter.DailyMeanTemperature);
var t1 = new DateTime(1997, 8, 1);
var t2 = new DateTime(1997, 8, 15);
s.Read(t1, t2);
s.RemoveMissing();
Assert.AreEqual(23.5, s[0].Value);
Assert.AreEqual("A", s[0].Flag);
s.WriteToConsole(true);
/*
* USGS 13168500 1997-08-02 177 A 26.6 A 21.1 A 23.5 A
* USGS 13168500 1997-08-03 163 A 27.5 A 20.8 A 23.9 A
* USGS 13168500 1997-08-04 153 A 25.7 A 22.8 A 23.9 A
* USGS 13168500 1997-08-05 144 A 27.5 A 21.6 A 24.2 A
* USGS 13168500 1997-08-06 149 A 28.2 A 21.9 A 24.7 A
* USGS 13168500 1997-08-07 140 A 27.5 A 22.4 A 25.0 A
* USGS 13168500 1997-08-08 135 A 26.9 A 22.3 A 24.4 A
* USGS 13168500 1997-08-09 131 A 26.0 A 20.9 A 23.2 A
* USGS 13168500 1997-08-10 130 A 27.1 A 21.6 A 23.9 A
*
*/
}
public void TestDaily()
{
UsgsDailyValueSeries s = new UsgsDailyValueSeries("13190500", UsgsDailyParameter.DailyMeanDischarge);
s.Read(new DateTime(2003, 10, 1), DateTime.Now);
s.WriteCsv(@"C:\temp\andi_qd_usgs.csv");
}
public void AddSeriesDirectly()
{
Logger.EnableLogger();
var filename = FileUtility.GetTempFileNameInDirectory(@"c:\temp\", ".pdb");
if (File.Exists(filename))
{
File.Delete(filename);
}
Console.WriteLine(filename);
var server = new SQLiteServer(filename);
var db = new TimeSeriesDatabase(server);
// create a folder for each month
for (int i = 1; i <= 12; i++)
{
var t = new DateTime(2015, i, 1);
db.AddFolder("Months", t.ToString("MMMM"));
}
// Add USGS series (Boise River) to the January Folder
Series s = new UsgsDailyValueSeries("13206000", UsgsDailyParameter.DailyMeanDischarge);
s.SiteID = "13206000";
var folder = db.GetOrCreateFolder("Months", "January");
s.Read(DateTime.Parse("2015-01-01"), DateTime.Parse("2015-01-10"));
db.AddSeries(s, folder);
// Add Hydromet series to the February Folder
s = new HydrometDailySeries("bhr", "af", HydrometHost.GreatPlains);
s.Name = "gphyd_bhr_af";
s.SiteID = "gphyd_bhr";
var feb = db.GetOrCreateFolder("Months", "February");
db.AddSeries(s, feb);
// Add Csv file data to March Folder.
s = new TextSeries(@"c:\temp\test_river.csv");
s.Read();// read data. Use Read(t1,t2) to limit by dates
s.SiteID = "test";
s.Units = "cfs";
s.Table.TableName = "test_river"; // table name needs to be unique
db.AddSeries(s, db.GetOrCreateFolder("Months", "March"));
s = db.GetSeriesFromName("gphyd_bhr_af");
s.Read();
Console.WriteLine(s.Count);
// Add CSV file
db.Inventory();
}
