Exemplo n.º 1
0
        public TimelapseDataWeek GetTimelapseData(TimelapseDataRequest request)
        {
            USCounty county = DmRepo.GetCountyForFips(request.CountyFips);
            Dictionary <string, DroughtMonitorWeek> results = new Dictionary <string, DroughtMonitorWeek>();

            DateTime date = Convert.ToDateTime(request.DmWeek);

            results.Add("COUNTY", DmRepo.FindBy(county, date).FirstOrDefault());
            results.Add("STATE", DmRepo.FindBy(county.State, date).FirstOrDefault());
            results.Add("US", DmRepo.FindUS(date).FirstOrDefault());

            ICollection <AvailableWaterDataByStation> types = WaterRepo.FetchBestDataTypesForStationDate(WaterRepo.GetClosestStations(request.Latitude, request.Longitude,
                                                                                                                                      1), date);
            AvailableWaterDataByStation discharge = types.Where(t => t.ParameterCode == "00060").FirstOrDefault();
            double averageDischarge = 0;

            if (discharge != null)
            {
                double total = 0;
                ICollection <WaterDataValue> values = WaterRepo.FetchByDateRange(discharge.StationID, discharge.DataID, date, date.AddDays(7));
                foreach (WaterDataValue wvalue in values)
                {
                    if (wvalue.Value != -999999)
                    {
                        total += wvalue.Value;
                    }
                }
                averageDischarge = total / (double)values.Count;
            }

            return(new TimelapseDataWeek {
                DMData = results, AverageDischarge = averageDischarge
            });
        }
Exemplo n.º 2
0
        } //End Load DM Data

        private DroughtMonitorWeek LoadDMDataValues(DMDataType type, DateTime date, int CountyFIPS)
        {
            DroughtMonitorWeek week = null;

            switch (type)
            {
            case DMDataType.COUNTY:
                week = DmRepository.FindBy(DmRepository.GetCountyForFips(CountyFIPS), date).FirstOrDefault();
                break;

            case DMDataType.STATE:
                week = DmRepository.FindBy(DmRepository.GetCountyForFips(CountyFIPS).State, date).FirstOrDefault();
                break;

            case DMDataType.US:
                week = DmRepository.FindUS(date).FirstOrDefault();
                break;
            }

            if (week == null)
            {
                USCounty county = DmRepository.GetCountyForFips(CountyFIPS);
                week = new DroughtMonitorWeek()
                {
                    D0         = 0,
                    D1         = 0,
                    D2         = 0,
                    D3         = 0,
                    D4         = 0,
                    NonDrought = 0,
                    Week       = date,
                    Type       = type,
                    County     = county,
                    State      = county.State
                };
            }
            else
            {
                week.Type = type;
                // Normalize data to be out of 100%
                week.D0 = (float)Math.Round((week.D0 - week.D1), 2);
                week.D1 = (float)Math.Round((week.D1 - week.D2), 2);
                week.D2 = (float)Math.Round((week.D2 - week.D3), 2);
                week.D3 = (float)Math.Round((week.D3 - week.D4), 2);
            }

            return(week);
        } //End LoadDMDataValues
Exemplo n.º 3
0
        public ICollection <TimeLapseFrame> CreateTimeLapseFramesFromIDs(long[] photoIDs)
        {
            List <TimeLapseFrame> frames = new List <TimeLapseFrame>();
            long firstID = photoIDs[0]; // stupid LINQ

            USCounty county = DMRepository.GetCountyForFips(PhotoRepository.Find(p => p.ID == firstID, p => p.Site)
                                                            .FirstOrDefault().Site.CountyFips);

            var properties = PhotoRepo.GetPhotoProperties(photoIDs, new string[] { "ID", "Captured" });

            foreach (var property in properties)
            {
                var frame = new TimeLapseFrame()
                {
                    FrameTime = (DateTime)property["Captured"], PhotoID = (long)property["ID"]
                };
                frames.Add(frame);
            }

            return(frames);
        }
Exemplo n.º 4
0
        public USCounty GetCounty(long id)
        {
            using (SqlConnection conn = new SqlConnection(_connectionString))
            {
                conn.Open();
                using (SqlCommand command = new SqlCommand("select * from Counties where ID = @cid", conn))
                {
                    command.Parameters.AddWithValue("@cid", id);
                    SqlDataReader reader = command.ExecuteReader();
                    if (reader.Read())
                    {
                        USCounty county = new USCounty();
                        county.ID    = reader.GetInt64(0);
                        county.Fips  = reader.GetInt32(1);
                        county.Name  = reader.GetString(2);
                        county.State = GetState(reader.GetInt64(3));

                        return(county);
                    }
                }
            }
            throw new ArgumentException(string.Format("id {0} is not recognized", id));
        }
Exemplo n.º 5
0
        public ICollection <DroughtMonitorWeek> FindBy(USCounty county, DateTime?week = null, int weeksPrevious = 0)
        {
            week = DroughtMonitorWeek.ConvertDateToTuesday(week.Value);

            using (SqlConnection conn = new SqlConnection(_connectionString))
            {
                conn.Open();
                using (SqlCommand command = new SqlCommand(null, conn))
                {
                    if (week == null && weeksPrevious == 0)
                    {
                        command.CommandText = string.Format("select DroughtCategory, DroughtValue, PublishedDate, County_ID from CountyDMValues where County_ID = @county order by PublishedDate, County_ID");
                        command.Parameters.AddWithValue("@county", county.ID);
                    }
                    else if (week == null && weeksPrevious != 0)
                    {
                        command.CommandText = string.Format("select DroughtCategory, DroughtValue, PublishedDate, County_ID from CountyDMValues where County_ID = @county and PublishedDate >= @rangestart order by PublishedDate, County_ID");
                        command.Parameters.AddWithValue("@county", county.ID);
                        command.Parameters.AddWithValue("@rangestart", DateTime.Now.AddDays(7 * (0 - weeksPrevious)).ToString("yyyy/MM/dd"));
                    }
                    else if (week != null)
                    {
                        command.CommandText = string.Format("select DroughtCategory, DroughtValue, PublishedDate, County_ID from CountyDMValues where County_ID = @county and PublishedDate >= @rangestart and PublishedDate <= @rangeend order by PublishedDate, County_ID");
                        command.Parameters.AddWithValue("@county", county.ID);
                        command.Parameters.AddWithValue("@rangestart", week.Value.AddDays(7 * (0 - weeksPrevious)).ToString("yyyy/MM/dd"));
                        command.Parameters.AddWithValue("@rangeend", week.Value.ToString("yyyy/MM/dd"));
                    }
                    else
                    {
                        throw new Exception("No command was specified");
                    }

                    return(ProcessQuery(command, DMDataType.COUNTY));
                }
            }
        }