private TsValuesSingleVariableType CreateGWTimeSeriesObject(VariableParam vp, string aURL)
{
// download the iformation
String resultFile = USGSCommon.GetHTTPFile(aURL, 10);
TsValuesSingleVariableType values = new TsValuesSingleVariableType();
//result.TimeSeries.Values.valueUnits = units; // this needs to be done earlier
DataTable aTable = NWISDelimitedTextParser.ParseFileIntoDT(resultFile);
// dwv add code to get the code, and use that to find the correct columns
int time = 2; // present location of time column
String code = vp.Code;
String stat = null;
int aValue;
int qualifier;
//if (result.timeSeries.variable.options != null)
//{
// stat = result.timeSeries.variable.options[0].Value;
//}
try
{
aValue = USGSCommon.getVarColumn(aTable, "lev_va", null); // uses eEndWith... so this should work
qualifier = USGSCommon.getVarQualifiersColumn(aTable, "lev_status_cd", null);
}
catch (WaterOneFlowException we)
{
// need to insert the URL in the exception
if (string.IsNullOrEmpty(stat))
{
throw new WaterOneFlowException("URL: '" + aURL, we);
//+"' variable '"+code+"' not found at site.");
}
else
{
throw new WaterOneFlowException("URL: '" + aURL, we);
//+ "' variable '"+code+"' statistic '"+stat +"' not found at site. Try not using the statistic", we);
}
}
List <ValueSingleVariable> tsTypeList = new List <ValueSingleVariable>();
//TimeSeriesFromRDB(aTable, time, aValue, qualifier, tsTypeList);
USGSCommon.TimeSeriesFromRDB(aTable, time, aValue, qualifier, tsTypeList, false);
values.count = tsTypeList.Count;
values.value = tsTypeList.ToArray();
return(values);
}
public static TsValuesSingleVariableType CreateTimeSeriesValuesElement(
//TimeSeriesResponseType result,
VariableParam vp,
string aURL,
Boolean provisional)
{
// add the URL to be requested to the result
//result.queryInfo.queryURL = aURL;
// download the iformation
String resultFile = GetHTTPFile(aURL, 10);
//result.timeSeries.values = new TsValuesSingleVariableType();
//result.TimeSeries.Values.valueUnits = units; // this needs to be done earlier
TsValuesSingleVariableType values = new TsValuesSingleVariableType();
DataTable aTable = NWISDelimitedTextParser.ParseFileIntoDT(resultFile);
// dwv add code to get the code, and use that to find the correct columns
int time = 2; // present location of time column
// String code = result.timeSeries.variable.variableCode[0].Value;
String code = vp.Code;
String stat = null;
try
{
stat = option2UsgsStatCode(vp);
} catch (Exception ex)
{
log.Debug("option2UsgsStatCode() failed :" + ex.ToString());
stat = null;
}
int aValue;
int qualifier;
//if (result.timeSeries.variable.options != null)
//{
// stat = result.timeSeries.variable.options[0].Value;
//}
try
{
aValue = getVarColumn(aTable, code, stat);
qualifier = getVarQualifiersColumn(aTable, code, stat);
}
catch (WaterOneFlowException we)
{
/* even I'm confused here...
* parsing column names gives an error
*
* This is post data rereiveal, so
* if we do not find the correct column, then throw an error
* */
string mess = "BAD COLUMN HEADER FROM USGS URL: " + aURL;
// need to insert the URL in the exception
if (string.IsNullOrEmpty(stat))
{
log.Error("Bad Column varCode:" + code + " stat_cd:NULL " + mess, we);
throw new WaterOneFlowSourceException("Improper COLUMN HEADER FROM USGS URL: " + aURL, we);
//+"' variable '"+code+"' not found at site.");
}
else
{
log.Error("Bad Column varCode:" + code + " Stat_cd: " + stat + " " + mess, we);
throw new WaterOneFlowSourceException("Improper COLUMN HEADER FROM USGS URL: " + aURL, we);
//+ "' variable '"+code+"' statistic '"+stat +"' not found at site. Try not using the statistic", we);
}
}
List <ValueSingleVariable> tsTypeList = new List <ValueSingleVariable>();
TimeSeriesFromRDB(aTable, time, aValue, qualifier,
tsTypeList, provisional);
values.count = tsTypeList.Count.ToString();
values.value = tsTypeList.ToArray();
if (provisional)
{
List <qualifier> quals = new List <qualifier>();
if (values.qualifier != null)
{
quals = new List <qualifier>(values.qualifier);
}
// this code is take from the daily values remark code
// unit values just says provisional data in the header
qualifier qual = new qualifier();
qual.qualifierCode = "P";
qual.network = "USGS";
qual.vocabulary = "dv_rmk_cd";
qual.Value = "Provisional data subject to revision.";
quals.Add(qual);
values.qualifier = quals.ToArray();
}
return(values);
}
private TsValuesSingleVariableType CreateWQTimeSeriesObject(VariableParam vp, string aURL)
{
// download the iformation
String resultFile = USGSCommon.GetHTTPFile(aURL, 10);
TsValuesSingleVariableType values = new TsValuesSingleVariableType();
//result.TimeSeries.Values.valueUnits = units; // this needs to be done earlier
DataTable aTable = NWISDelimitedTextParser.ParseFileIntoDT(resultFile);
// dwv add code to get the code, and use that to find the correct columns
// time and date are separate
int date = 2; // present location of time column
int time = 3;
String code = vp.Code;
int codeCol;
int aValue;
int qualifier; // there are many qa columns. what do we want to do about them
/* 20070909
* add
# meth_cd - Method code
# dqi_cd - Data-quality indicator code
# rpt_lev_va - Reporting level
# rpt_lev_cd - Reporting level type
# lab_std_va - Lab standard deviation
# anl_ent_cd - Analyzing entity code
*/
int method;
try
{
/* 20070909 - USGS column name changes
* parameter_cd to param_cd
* APPSETTING: ConfigurationManager.AppSettings["parameterColumn"];
* qualifiers now in val_qual_tx
* also:
# meth_cd - Method code
# dqi_cd - Data-quality indicator code
# rpt_lev_va - Reporting level
# rpt_lev_cd - Reporting level type
# lab_std_va - Lab standard deviation
# anl_ent_cd - Analyzing entity code
*/
//codeCol = getVarQualifiersColumn(aTable, "parameter_cd", null);
string parmameterColName = (string)Properties.Settings.Default["parameterColumn"];
codeCol = USGSCommon.getVarQualifiersColumn(aTable, parmameterColName, null);
aValue = USGSCommon.getVarColumn(aTable, "result_va", null);
qualifier = USGSCommon.getVarQualifiersColumn(aTable, "remark_cd", null); // there are many qa columns. what do we want to do about them
// qualifier = getVarColumn(aTable, "val_qual_tx", null); //Do Not use at present
}
catch (WaterOneFlowException we)
{
throw new WaterOneFlowException("URL: '" + aURL, we);
}
List <ValueSingleVariable> tsTypeList = new List <ValueSingleVariable>();
foreach (DataRow aRow in aTable.Rows)
{
if (aRow[codeCol].Equals(code))
{ // only do this if this is the correct value
ValueSingleVariable tsTypeValue = new ValueSingleVariable();
//tsTypeValue.time= Convert.ToDateTime(aRow[time]);
tsTypeValue.dateTime = Convert.ToDateTime(
aRow[date].ToString() +
" " + aRow[time].ToString()
);
// tsTypeValue.dateTimeSpecified = true;
//tsTypeValue.censored = string.Empty;
if (string.IsNullOrEmpty(aRow[aValue].ToString()))
{
continue;
}
else
{
tsTypeValue.Value = Convert.ToDecimal(aRow[aValue]);
}
USGSCommon.parseQualifiersForCensorCode(tsTypeValue, aRow[qualifier].ToString()); // this will add censored, if appropariate
// added for hydrodesktop
tsTypeValue.qualityControlLevel = QualityControlLevelEnum.Unknown;
tsTypeValue.qualityControlLevelSpecified = true;
tsTypeValue.methodID = 0;
tsTypeValue.methodIDSpecified = true;
tsTypeValue.sourceID = 1;
tsTypeValue.sourceIDSpecified = true;
tsTypeList.Add(tsTypeValue);
}
}
values.count = tsTypeList.Count.ToString();
values.value = tsTypeList.ToArray();
// add added qualifiers
values.source = new SourceType[1];
values.source[0] = new SourceType();
values.source[0].sourceID = 1;
values.source[0].sourceIDSpecified = true;
values.source[0].Organization = "USGS";
values.source[0].SourceDescription = "US Geological Survey National Water Information System";
values.source[0].SourceLink = "http://waterdata.usgs.gov/";
values.qualityControlLevel = new qualityControlLevel[1];
values.qualityControlLevel[0] = new qualityControlLevel();
values.qualityControlLevel[0].qualityControlLevelID = "0";
values.qualityControlLevel[0].qualityControlLevelCode = "Unknown";
values.method = new MethodType[1];
values.method[0] = new MethodType();
values.method[0].methodID = 0;
values.method[0].methodIDSpecified = true;
values.method[0].MethodDescription = "Unknown";
return(values);
}
