public UsgsRealTimeSeries(string site_no, UsgsRealTimeParameter parameter)
{
TimeInterval = TimeSeries.TimeInterval.Irregular;
this.SiteID = site_no;
this.Parameter = parameter.ToString();
m_site_no = site_no;
m_parameter = parameter;
m_columnName = "";
m_flagColumnName = "";
Table.TableName = "UsgsRealTime_" + parameter.ToString() + "_" + site_no;
ConnectionString = "Source=USGS;site_no=" + site_no + ";UsgsParameter=" + parameter.ToString();
Source = "USGS";
Provider = "UsgsRealTimeSeries";
}
public UsgsRealTimeSeries(string site_no, UsgsRealTimeParameter parameter)
{
TimeInterval = TimeSeries.TimeInterval.Irregular;
this.SiteID = site_no;
this.Parameter = parameter.ToString();
m_site_no = site_no;
m_parameter = parameter;
m_columnName = "";
m_flagColumnName = "";
Table.TableName = "UsgsRealTime_" + parameter.ToString() + "_" + site_no;
ConnectionString = "Source=USGS;site_no=" + site_no+";UsgsParameter="+parameter.ToString();
Source = "USGS";
Provider = "UsgsRealTimeSeries";
}
/*
*
# ---------------------------------- WARNING ----------------------------------------
# Provisional data are subject to revision. Go to
# http://waterdata.usgs.gov/nwis/help/?provisional for more information.
#
# File-format description: http://waterdata.usgs.gov/nwis/?tab_delimited_format_info
# Automated-retrieval info: http://waterdata.usgs.gov/nwis/?automated_retrieval_info
#
# Contact: [email protected]
# retrieved: 2012-05-02 15:58:03 EDT (vaas01)
#
# Data for the following 1 site(s) are contained in this file
# USGS 13206000 BOISE RIVER AT GLENWOOD BRIDGE NR BOISE ID
# -----------------------------------------------------------------------------------
#
# Data provided for site 13206000
# DD parameter Description
# 01 00060 Discharge, cubic feet per second
# 02 00065 Gage height, feet
#
# Data-value qualification codes included in this output:
# P Provisional data subject to revision.
#
# agency_cd site_no datetime tz_cd 01_00060 01_00060_cd 02_00065 02_00065_cd
# 5s 15s 20d 6s 14n 10s 14n 10s
# USGS 13206000 2012-05-02 10:00 MDT 7830 P 10.63 P
# USGS 13206000 2012-05-02 10:15 MDT 7700 P 10.56 P
# USGS 13206000 2012-05-02 10:30 MDT 7800 P 10.61 P
# USGS 13206000 2012-05-02 10:45 MDT 7780 P 10.60 P
# USGS 13206000 2012-05-02 11:00 MDT 7820 P 10.62 P
# USGS 13206000 2012-05-02 11:15 MDT 7780 P 10.60 P
# USGS 13206000 2012-05-02 11:30 MDT 7830 P 10.63 P
# USGS 13206000 2012-05-02 11:45 MDT 7820 P 10.62 P
# USGS 13206000 2012-05-02 12:00 MDT 7700 P 10.56 P
# USGS 13206000 2012-05-02 12:15 MDT 7850 P 10.64 P
# USGS 13206000 2012-05-02 12:30 MDT 7740 P 10.58 P
# USGS 13206000 2012-05-02 12:45 MDT 7830 P 10.63 P
# USGS 13206000 2012-05-02 13:00 MDT 7910 P 10.67 P
# USGS 13206000 2012-05-02 13:15 MDT 7930 P 10.68 P
# USGS 13206000 2012-05-02 13:30 MDT 7970 P 10.70 P
# USGS 13206000 2012-05-02 13:45 MDT 8000 P 10.72 P
*/
/// <summary>
/// Determine column name where this data exists.
/// </summary>
private void ParsePreamble()
{
int idx = -1;
string findMe = "# USGS " + SiteID;
idx = m_rdb.TextFile.IndexOf(findMe);
Name = SiteID;
Source = "USGS";
if (idx >= 0)
{
Name = m_rdb.TextFile[idx].Substring(findMe.Length);
}
else
{
string msg = "Could not find site name " + findMe;
Core.Logger.WriteLine(msg);
Messages.Add(msg);
return;
}
idx = -1;
if (m_parameter == UsgsRealTimeParameter.Discharge)
{
idx = m_rdb.TextFile.IndexOf("Discharge, cubic feet per second");
Units = "cfs";
Parameter = "Discharge";
}
if (m_parameter == UsgsRealTimeParameter.GageHeight)
{
idx = m_rdb.TextFile.IndexOf("Gage height, feet");
Units = "feet";
Parameter = "Gage height";
}
if (m_parameter == UsgsRealTimeParameter.Temperature)
{
idx = m_rdb.TextFile.IndexOf("Temperature, water, degrees Celsius");
Units = "degC";
Parameter = "Water Temperature";
}
//"# 02 00062 Elevation of reservoir water surface above datum, feet
else if (m_parameter == UsgsRealTimeParameter.ReservoirElevation)
{
idx = m_rdb.TextFile.IndexOf("Elevation of reservoir water surface above datum, feet");
Units = "ft";
Parameter = "elevation";
}
if (idx < 0 || idx > m_rdb.DataIndex)
{
string msg = "could not find " + m_parameter.ToString();
Core.Logger.WriteLine(msg);
Messages.Add(msg);
m_columnName = "";
return;
}
Name += (" " + Parameter);
// find the parts of the column name
/*
# Data for the following site(s) are contained in this file
# USGS 13206000 BOISE RIVER AT GLENWOOD BRIDGE NR BOISE ID
# -----------------------------------------------------------------------------------
#
# Data provided for site 13069500
# TS_ID Parameter Description
# 47218 00060 Discharge, cubic feet per second
#
*/
string line = m_rdb.TextFile[idx];
string TS_ID = line.Substring(5, 6).Trim();
string p = line.Substring(17, 5).Trim();
//string stat = line.Substring(20, 5); RealTime doesn't have stat
m_columnName = TS_ID + "_" + p;
m_flagColumnName = m_columnName + "_cd";
if (m_rdb.Columns.IndexOf(m_columnName) < 0)
{
throw new Exception("Could not find column name for '" + line + "'");
}
}
