private static string EstimateProgramName(TimeSeriesDatabaseDataSet.sitecatalogDataTable siteCatalog, Series s) { var program = s.Properties.Get("program"); if (program == "") { // Console.WriteLine("program not defined: " + tn.GetTableName()); // try site name var site = siteCatalog.FindBysiteid(s.SiteID); if (site == null) { Console.WriteLine("Null site " + s.SiteID); return(""); } if (site.type == "" || site.type == "hydromet" || site.type == "reservoir" || site.type == "weather station") { program = "hydromet"; } if (site.type == "agrimet") { program = "agrimet"; } } return(program); }
private static void SetRegioninSiteTable(TimeSeriesDatabase db, TimeSeriesDatabaseDataSet.sitecatalogDataTable sites) { var sc = db.GetSeriesCatalog("isfolder=0"); for (int i = 0; i < sites.Rows.Count; i++) { var siteid = sites[i].siteid; var rows = sc.Select("connectionString like 'server=PN;cbtt=" + siteid + ";%'"); if (rows.Length > 0 && sites[i].agency_region == "") { sites[i].agency_region = "PN"; } rows = sc.Select("connectionString like 'server=LCHDB2%' and siteid ='" + siteid + "'"); if (rows.Length > 0 && sites[i].agency_region == "") { sites[i].agency_region = "LC"; } rows = sc.Select("connectionString like 'server=UCHDB2%' and siteid ='" + siteid + "'"); if (rows.Length > 0 && sites[i].agency_region == "") { sites[i].agency_region = "UC"; } } }
public FormNewMeasurment(TimeSeriesDatabaseDataSet.sitecatalogDataTable siteCatalog) { InitializeComponent(); buttonSave.Enabled = false; m_siteCatalog = siteCatalog; Prepare(); this.Text = "Input New Measurement"; }
internal static bool IsAgrimetSite(string cbtt) { if (s_sites == null) { s_sites = s_db.GetSiteCatalog("type = 'agrimet'"); } return(s_sites.Select("siteid = '" + cbtt + "'").Length > 0); }
public FormNewMeasurment( TimeSeriesDatabaseDataSet.sitecatalogDataTable siteCatalog) { InitializeComponent(); buttonSave.Enabled = false; m_siteCatalog = siteCatalog; Prepare(); this.Text="Input New Measurement"; }
private void Setup() { m_sites = m_db.GetSiteCatalog(); this.comboBox1.DataSource = m_sites; this.comboBox1.DisplayMember = "siteid"; this.comboBox1.ValueMember = "siteid"; comboBox1.SelectedValue = "boii"; m_seriesCatalog = new TimeSeriesDatabaseDataSet.SeriesCatalogDataTable(); }
private static bool KeepThisSeries(TimeSeriesDatabaseDataSet.sitecatalogDataTable sitecatalog, string siteid, string pcode, string years) { HydrometMonthlySeries m = new HydrometMonthlySeries(siteid, pcode, HydrometHost.PN); var goodYears = Regex.IsMatch(years, "20[0-9]{2}"); var rows = sitecatalog.Select("siteid='" + siteid + "'"); if (rows.Length == 0 && m.Name != "") { //Console.WriteLine("siteid could be added to catalog:'"+siteid+"' "+m.Name); } return(rows.Length == 1 && goodYears); }
private static void UpdateGPSiteInfo(TimeSeriesDatabaseDataSet.sitecatalogDataTable sc) { Console.WriteLine("reading gp excel"); var fn = @"U:\water.usbr.gov\data\GPsitesTESSELAPP_kt.xlsx"; var xls = new NpoiExcel(fn); var tbl = xls.ReadDataTable(0); //var tbl = ExcelDB.Read(fn, 0); for (int i = 0; i < tbl.Rows.Count; i++) { var desc = tbl.Rows[i]["Description"].ToString(); var lat = tbl.Rows[i]["Latitude"].ToString().Trim(); var lon = tbl.Rows[i]["Longitude"].ToString().Trim(); var state = tbl.Rows[i]["State"].ToString().Trim(); if (lon[0] != '-') { lon = "-" + lon; } //var office = tbl.Rows[i]["office"].ToString(); var siteid = tbl.Rows[i]["Site Name"].ToString().ToLower().Trim(); var siteType = tbl.Rows[i]["type"].ToString().ToLower().Trim(); var siteRow = sc.FindBysiteid(siteid); if (siteRow == null) { Console.WriteLine("new site : " + siteid); siteRow = sc.NewsitecatalogRow(); siteRow.siteid = siteid; sc.AddsitecatalogRow(siteRow); } else { Console.WriteLine("existing site : " + siteRow.siteid); } siteRow.description = desc; siteRow.state = state; siteRow.latitude = lat; siteRow.longitude = lon; //siteRow.responsibility = office; siteRow.type = siteType; siteRow.agency_region = "GP"; } }
private void Setup() { m_sites = m_db.GetSiteCatalog(); this.comboBox1.DataSource = m_sites; this.comboBox1.DisplayMember = "siteid"; this.comboBox1.ValueMember = "siteid"; comboBox1.SelectedValue = "boii"; m_seriesCatalog = new TimeSeriesDatabaseDataSet.SeriesCatalogDataTable(); properties.Columns.Add("name"); properties.Columns.Add("value"); //properties.Rows.Add("program", "hydromet"); //properties.Rows.Add("basin", "yakima"); dataGridViewProperties.DataSource = properties; }
private void SetupComboBox() { comboBox1.AutoCompleteMode = AutoCompleteMode.SuggestAppend; comboBox1.AutoCompleteSource = AutoCompleteSource.ListItems; m_props = m_db.GetSiteProperties(); m_sites = m_db.GetSiteCatalog(); var temp = m_sites.Copy(); // copy for the combo box (selection only) for (int i = 0; i < temp.Rows.Count; i++) { var r = temp.Rows[i]; r["description"] = r["siteid"].ToString().ToUpper() + " " + r["description"].ToString(); } comboBox1.DataSource = temp; comboBox1.ValueMember = "siteid"; comboBox1.DisplayMember = "description"; }
public SiteMetaData(TimeSeriesDatabase db) { m_db = db; InitializeComponent(); comboBox1.AutoCompleteMode = AutoCompleteMode.SuggestAppend; comboBox1.AutoCompleteSource = AutoCompleteSource.ListItems; m_props = db.GetSiteProperties(); m_sites = db.GetSiteCatalog(); var temp = m_sites.Copy(); // copy for the combo box (selection only) for (int i = 0; i < temp.Rows.Count; i++) { var r = temp.Rows[i]; r["description"] = r["siteid"].ToString().ToUpper() + " " + r["description"].ToString(); } comboBox1.DataSource = temp; comboBox1.ValueMember = "description"; comboBox1.DisplayMember = "description"; }
private void textBoxSiteID_TextChanged(object sender, EventArgs e) { if (textBoxdescription.Text.Trim() == "" && textBoxSiteID.Text.Trim().Length > 2) { if (m_siteCatalog == null) { m_siteCatalog = m_db.GetSiteCatalog(); } m_siteRow = m_siteCatalog.FindBysiteid(textBoxSiteID.Text.Trim()); if (m_siteRow != null) { this.textBoxdescription.Text = m_siteRow.description; this.textBoxElevation.Text = m_siteRow.elevation; this.textBoxlatitude.Text = m_siteRow.latitude; this.textBoxlongitude.Text = m_siteRow.longitude; this.textBoxInstall.Text = m_siteRow.install; this.textBoxTimezone.Text = m_siteRow.timezone; this.textBoxState.Text = m_siteRow.state; } } }
private void textBoxSiteID_TextChanged(object sender, EventArgs e) { if (textBoxdescription.Text.Trim() == "" && textBoxSiteID.Text.Trim().Length >2) { if (m_siteCatalog == null) { m_siteCatalog = m_db.GetSiteCatalog(); } m_siteRow = m_siteCatalog.FindBysiteid(textBoxSiteID.Text.Trim()); if (m_siteRow != null) { this.textBoxdescription.Text = m_siteRow.description; this.textBoxElevation.Text = m_siteRow.elevation.ToString(); this.textBoxlatitude.Text = m_siteRow.latitude.ToString(); this.textBoxlongitude.Text = m_siteRow.longitude.ToString(); this.textBoxInstall.Text = m_siteRow.install; this.textBoxTimezone.Text = m_siteRow.timezone; this.textBoxState.Text = m_siteRow.state; } } }
public EquationTemplates(TimeSeriesDatabase db, string outputFileName) { m_db = db; m_sites = m_db.GetSiteCatalog(); sw = new StreamWriter(outputFileName); }
public DailyCalcGenerator(TimeSeriesDatabase db, string outputFileName) { m_db = db; m_sites = m_db.GetSiteCatalog(); sw = new StreamWriter(outputFileName); }
private static void InsertMontanaSitesFromJsonToPisces(FeatureCollection collection, TimeSeriesDatabaseDataSet.sitecatalogDataTable sc) { // insert montana sites into pisces for (int i = 0; i < collection.Features.Count; i++) { Feature item = collection.Features[i]; if (item.Properties["title"].ToString().IndexOf(" MT ") < 0) { continue; } var rows = sc.Select("siteid = '" + item.Id.ToLower() + "'"); if (rows.Length == 0) // not in Pisces { Console.WriteLine(item.Id + " not found in Pisces"); // put it Pisces. var desc = item.Properties["title"].ToString(); var pt = item.Geometry as GeoJSON.Net.Geometry.Point; var pos = pt.Coordinates as GeoJSON.Net.Geometry.GeographicPosition; var lat = pos.Latitude.ToString(); var lo = pos.Longitude.ToString(); //sc.AddsitecatalogRow(item.Id.ToLower(), desc, "MT", lat, lo, "", "US/Mountain", "", "", "", 0, "usbr_map.json", "", "", "agrimet", "great_plains"); } } }