Example #1
0
        private static void InsertMontanaSitesFromJsonToPisces(FeatureCollection collection, TimeSeriesDatabaseDataSet.sitecatalogDataTable sc)
        {
            // insert montana sites into pisces
            for (int i = 0; i < collection.Features.Count; i++)
            {
                Feature item = collection.Features[i];

                if (item.Properties["title"].ToString().IndexOf(" MT ") < 0)
                {
                    continue;
                }


                var rows = sc.Select("siteid = '" + item.Id.ToLower() + "'");
                if (rows.Length == 0) // not  in Pisces
                {
                    Console.WriteLine(item.Id + " not found in Pisces");
                    // put it Pisces.
                    var desc = item.Properties["title"].ToString();
                    var pt   = item.Geometry as GeoJSON.Net.Geometry.Point;
                    var pos  = pt.Coordinates as GeoJSON.Net.Geometry.GeographicPosition;
                    var lat  = pos.Latitude.ToString();
                    var lo   = pos.Longitude.ToString();
                    //sc.AddsitecatalogRow(item.Id.ToLower(), desc, "MT", lat, lo, "", "US/Mountain", "", "", "", 0, "usbr_map.json", "", "", "agrimet", "great_plains");
                }
            }
        }
Example #2
0
 internal static bool IsAgrimetSite(string cbtt)
 {
     if (s_sites == null)
     {
         s_sites = s_db.GetSiteCatalog("type = 'agrimet'");
     }
     return(s_sites.Select("siteid = '" + cbtt + "'").Length > 0);
 }
Example #3
0
        private static bool KeepThisSeries(TimeSeriesDatabaseDataSet.sitecatalogDataTable sitecatalog,
                                           string siteid, string pcode, string years)
        {
            HydrometMonthlySeries m = new HydrometMonthlySeries(siteid, pcode, HydrometHost.PN);

            var goodYears = Regex.IsMatch(years, "20[0-9]{2}");

            var rows = sitecatalog.Select("siteid='" + siteid + "'");

            if (rows.Length == 0 && m.Name != "")
            {
                //Console.WriteLine("siteid could be added to catalog:'"+siteid+"'  "+m.Name);
            }

            return(rows.Length == 1 && goodYears);
        }
Example #4
0
        /// <summary>
        /// For each instant Series in the database create an appropriate
        /// Dailycalculation.
        /// </summary>
        public void AddDailyCalculations(DataTable pcodeLookup, bool dryRun, string[] sites)
        {
            var codes = new List <string>();

            for (int i = 0; i < pcodeLookup.Rows.Count; i++)
            {
                var pc = pcodeLookup.Rows[i]["instantpcode"].ToString();
                codes.Add(pc.ToLower());
            }

            var filter = "select * from seriescatalog a join sitecatalog b on a.siteid=b.siteid "
                         + "where timeinterval= 'Irregular' and b.type <> 'agrimet' ";

            filter += "and parameter in ( '" + String.Join("','", codes.ToArray()) + "')";

            var q = new TimeSeriesDatabaseDataSet.SeriesCatalogDataTable();

            m_db.Server.FillTable(q, filter);

            newCalcCount  = 0;
            changeEqCount = 0;


            //foreach (var r in q)
            for (int j = 0; j < q.Rows.Count; j++)
            {
                var r = q[j];
                try
                {
                    if (sites.Length > 0 && Array.IndexOf(sites, r.siteid) == -1)
                    {
                        continue;
                    }

                    if (!HasCurrentData(r.TableName)) // don't add equations for 'old' data
                    {
                        Console.WriteLine("no current data. skipping .." + r.TableName);
                    }
                    else
                    {
                        var calcs = pcodeLookup.Select("InstantPcode ='" + r.Parameter + "'");

                        for (int i = 0; i < calcs.Length; i++)
                        {
                            var dailyPcode = calcs[i]["DailyPcode"].ToString().ToLower();
                            var siteFilter = calcs[i]["siteFilter"].ToString();
                            var expression = calcs[i]["Equation"].ToString();
                            expression = expression.Replace("%site%", r.siteid);
                            var            name = r.siteid + "_" + dailyPcode;
                            TimeSeriesName tn   = new TimeSeriesName(name, "daily");

                            if (m_sites.Select("siteid='" + r.siteid + "'").Length == 0)
                            {
                                Console.WriteLine("Warning: skipping site not cataloged: " + r.siteid);
                                continue;
                            }

                            // remove property--> program:hydromet (prevents data flow from pnhyd0)
                            if (!dryRun)
                            {
                                RemoveProgramProperty(tn);
                            }

                            if (!FilterAllows(r.siteid, siteFilter)) // config spreasheet limits i.e. responsibility='IDWR'
                            {
                                continue;
                            }

                            if (m_db.TableNameInUse(tn.GetTableName()))
                            { // already defined in some manner.
                                ConvertToDailyEquation(tn, expression, dryRun);
                            }
                            else
                            {
                                CalculationSeries s = CreateCalcSeries(r, name, tn, expression);
                                newCalcCount++;
                                if (!dryRun)
                                {
                                    AddCalcSeries(s);
                                }
                            }

                            // check if this equation matches Hydromet Legacy.

                            if (!dryRun)
                            {
                                CompareWithVMS(tn);
                            }
                        }
                    }
                }
                catch (Exception exc)
                {
                    sw.WriteLine("Error:" + exc.Message);
                }
                if (j % 100 == 0)
                {
                    Console.WriteLine(j + " of " + q.Count);
                }
            }


            sw.WriteLine("New equations: " + newCalcCount);
            sw.WriteLine("modified to Equations :" + this.changeEqCount);
            sw.Close();
        }