Investigate the Met Derived Data sets

Update Oct 3rd (EOD).

Most of the views are now up to date and refreshed. The review prompted new actions,
which resulted in ToDos. The most pressing issues are.

-Vanda
-Task Lists
-GAFM/MIERS
-Sensit Stations

close for now
-------------------------------
Update Oct 3rd -- let us give this closure.

The plan -- update all views, and identify future impediments, a plan to overcome those.

I will use the table below to update the status.

=====================================
There seems to be difficulty generating monthly and daily stats for met stations.

One of the issues is of automation. It does not happen - this need to be triggered manually, which MAY be a problem (of forgetfulness). Perhaps once every 3 months would suffice.

Other is the Wind Direction stats. Views (materialized) seems to want to grab data from an _SNAP table which does not exist. Problem can be circumvented by replacing calls to $NAME_SNAP to plain $NAME, but this may open another can of worms, which it brings me to the matter of this task - investigate.

First things first, let's get a status

Last Date Data Available

Acronym --- Name ------- 15 min ---- Derived
BENM -- Beacon (disc) --- 12/2012 --- 12/2012
BOYM -- Lake Bonney ---- 7/2014 ---- 7/2014
BOYS -- Bonney Snowf --- 1/2007 ---- 1/2007 * disc ?
BRHM -- Brownsworth --- 11/2013 --- 11/2013 Why Nov 2013 - see tasklist - which i need to update!
CAAM -- Canada Glac ---- 1/2014 --- 1/2014
COHM -- Common Gla --- 1/2014 ---- 1/2014
EXEM -- Explorers Cove - 11/2012 --- 11/2012 * disc ? -- see tasklist
EXSM -- ** bad data/ waiting to build conf?
FLMM -- Mt. Fleming ---- 12/2013 --- 12/2013
FRLM -- Lake Fryxell ---- 1/2014 --- 1/2014
FRLS -- F6 Snow fence -- 11/2009 --- 11/2009 * disc tes
FRSM -- Friis Hills Stat --- 1/2014 ---- 1/2014
GADM -- Garwood Glac. --- 1/2014 ---- 1/2014 ** no daily ALL for GADM
GAFN -- Garwood ice Cliff - ** no data or stats/derived ***** is there a mix up between naming GAFM / GADM?
HODM -- Howard Glac ----- 1/2014 ----- 1/2014
HOEM -- Lake Hoare ----- 12/2013 --- 12/2013
TARM -- Taylor Glacier ---- 1/2014 --- 1/2014
UDHM -- Upper Howard --- 1/2004 --- 1/2004 * disc.
VAAM -- Lake Vanda --- 1/2012 -- 1/2012 ** issue opened
VIAM -- Lake Vida ---- 1/2014 -- 1/2014

MET-ALL (mat views ) stop at 2010 ** see about updating these

Status: 

Priority: 

Normal