public static TimeSeriesDatabaseDataSet.RatingTableDataTable GetRatingTable(string siteNumber) { //string url = "http://waterdata.usgs.gov/nwisweb/data/exsa_rat/13236500.rdb"; string url = "http://waterdata.usgs.gov/nwisweb/get_ratings?site_no=13081500&file_type=exsa"; url = url.Replace("13081500", siteNumber); string[] data = Web.GetPage(url); TextFile tf = new TextFile(data); UsgsRDBFile rdb = new UsgsRDBFile(data); TimeSeriesDatabaseDataSet.RatingTableDataTable t = new TimeSeriesDatabaseDataSet.RatingTableDataTable(); t.XUnits = LookupUnits(tf, "# //RATING_INDEP"); t.YUnits = LookupUnits(tf, "# //RATING_DEP"); for (int i = 0; i < rdb.Rows.Count; i++) { double x = Convert.ToDouble(rdb.Rows[i]["indep"]); double y = Convert.ToDouble(rdb.Rows[i]["dep"]); var r = t.FindByx(x); if (r == null) { t.AddRatingTableRow(x, y); } else { Console.WriteLine("Warning: duplicate x " + x); } } t.Name = "Usgs " + siteNumber; return(t); }