Example #1
0
        /*
         *
         * Data Set Export - Flow.DayMean@13087505 Milner Lwr Pwr Plant at Milner - Range: 2017-05-12 00:00 - 2017-05-26 00:00 (UTC-07:00),,,,,
         * Data on this site may be provisional and subject to revision,,,,,
         * Timestamp (UTC-07:00),Value (Cubic Feet Per Second),Grade Code,Approval Level,Interpolation Type,Comment
         * 2017-05-12 00:00:00,5260,0,,8,
         * 2017-05-13 00:00:00,5250,0,,8,
         * 2017-05-14 00:00:00,5250,0,,8,
         * 2017-05-15 00:00:00,5260,0,,8,
         * 2017-05-16 00:00:00,5240,0,,8,
         * 2017-05-17 00:00:00,5240,0,,8,
         * 2017-05-18 00:00:00,5200,0,,8,
         * 2017-05-19 00:00:00,4290,0,,8,
         * 2017-05-20 00:00:00,2160,0,,8,
         * 2017-05-21 00:00:00,244,0,,8,
         * 2017-05-22 00:00:00,0,0,,8,
         * 2017-05-23 00:00:00,0,0,,8,
         * 2017-05-24 00:00:00,0,0,,8,
         * 2017-05-25 00:00:00,0,0,,8,
         * 2017-05-26 00:00:00,0,0,,8,
         */
        private static Series ReadFromIdahoPower(string id, DateTime t1, DateTime t2)
        {
            //var url = "https://idastream.idahopower.com/Data/Export_Data/?dataset=18942&date=2017-05-12&endDate=2017-05-26&exporttype=csv&type=csv";


            var url = "https://idastream.idahopower.com/Data/Export_Data/?dataset="
                      + id + "&date=" + t1.Date.ToString("yyyy-MM-dd")
                      + "&endDate=" + t2.AddDays(1).ToString("yyyy-MM-dd") + "&exporttype=csv&type=csv";

            var fn = DownloadAndUnzip(url);

            TextSeries s = new TextSeries(fn);

            s.Read();
            s.Trim(t1, t2);
            return(s);
        }
Example #2
0
        /*
         *
         * Data Set Export - Flow.DayMean@13087505 Milner Lwr Pwr Plant at Milner - Range: 2017-05-12 00:00 - 2017-05-26 00:00 (UTC-07:00),,,,,
         * Data on this site may be provisional and subject to revision,,,,,
         * Timestamp (UTC-07:00),Value (Cubic Feet Per Second),Grade Code,Approval Level,Interpolation Type,Comment
         * 2017-05-12 00:00:00,5260,0,,8,
         * 2017-05-13 00:00:00,5250,0,,8,
         * 2017-05-14 00:00:00,5250,0,,8,
         * 2017-05-15 00:00:00,5260,0,,8,
         * 2017-05-16 00:00:00,5240,0,,8,
         * 2017-05-17 00:00:00,5240,0,,8,
         * 2017-05-18 00:00:00,5200,0,,8,
         * 2017-05-19 00:00:00,4290,0,,8,
         * 2017-05-20 00:00:00,2160,0,,8,
         * 2017-05-21 00:00:00,244,0,,8,
         * 2017-05-22 00:00:00,0,0,,8,
         * 2017-05-23 00:00:00,0,0,,8,
         * 2017-05-24 00:00:00,0,0,,8,
         * 2017-05-25 00:00:00,0,0,,8,
         * 2017-05-26 00:00:00,0,0,,8,
         */
        private static Series GetData(string id, int hoursBack)
        {
            //var url = "https://idastream.idahopower.com/Data/Export_Data/?dataset=18942&date=2017-05-12&endDate=2017-05-26&exporttype=csv&type=csv";

            var t2 = DateTime.Now.AddDays(1);
            var t1 = DateTime.Now.AddHours(-hoursBack);

            var url = "https://idastream.idahopower.com/Data/Export_Data/?dataset="
                      + id + "&date=" + t1.ToString("yyyy-MM-dd")
                      + "&endDate=" + t2.ToString("yyyy-MM-dd") + "&exporttype=csv&type=csv";

            var fn = DownloadAndUnzip(url);

            TextSeries s = new TextSeries(fn);

            s.Read();
            s.Trim(t1, t2);
            return(s);
        }