M a n a g e m e n t

a n d

A n a l y s i s

o f

S n o w,

A v a l a n c h e

a n d

C l i m a t e

D a t a

DataMagic:ConvertingAutomatedHourlyDatainto ReliableClimateInformation S.Breyfogle1,S.A.Ferguson2,D.Judd3,R.Marriott4,M.B.Moore5,P.Pasteris6,andK.Redmond7 1J.O.T. Consulting;2 USDAForest Service, Pacific Northwest Research Station; 3 Judd Communications;4KING Television;5 USDAForest Service, Northwest Avalanche Center; 6 USDA NaturalResources Conservation Service, Climate Data Access Facility;

The Northwest Avalanche Center (NWAC) began building
a network of automated weather stations shortly after they
beganforecastingin1976.Sincethenthenetworkhas
grown to be one of the most valuable sources of mountain
weatherdatainthe northwesternUnitedStates.Instru-
mentationateach sitehasbeentestedand modifiedto
withstand theharsh winter environment. Thedataareused
to help determine snow layering and avalanchepotential,
the depth and extent of freezing rain that impairs driving
conditions,and overall mountain weatherconditionsin
the Olympic and Cascade mountains of Washington and
northern Oregon.The location ofsensors has proved in-
valuable forobserving and defining unique phenomenon
associated with easterly pass flows, arctic inversions, and
topographically forced convergence. Until now, however,
the NWAC data have been available only for daily, opera-
tional use by forecasters.We have undertaken the task of
reformatting the NWAC data and adding quality control
flags to each variable to make them more readilyavailable
forabroadrangeofweathermodelverificationand
climatological purposes. Because this is the first network

of automated, hourly, mountain weather data to attempt
a qualitycontrol analysis,we have solicited assistance
from the Western Regional Climate Center and the USDA
Climate Data AccessFacility.Itisanticipated thatthe
experienceobtainedfromexaminationofNWACdata
can be applied in developing guidelines for quality con-
trolofothernetworks,suchastheUSDA-USDI/BLM
RAWS.During theretrospective analysisof dataqual-
ity,problems andissueswere identified thatcouldbe
traced both to the original establishment of the network
and its sensorsand tothe waythenetworkwas main-
tained.Inthiswaytheuncertaintyofeachvaluewas
assessedandappropriatequalityassurancemeasures
were assigned using a system of three flags, 1) data qual-
ity,2) data problem(if any),and 3) adjustmentmethod
(ifany).Although the originaldata values always were
preserved, adjusted values were suggested as substitutes
whenever a value could be identified as "suspect" with
reasonableconfidence.TheNWACdataare organized
in a way that the file can be read by typical Fortran or C
programs or imported intoa spreadsheet.

4