Download
data data and more data n.
Skip this Video
Loading SlideShow in 5 Seconds..
Data, Data, and More Data PowerPoint Presentation
Download Presentation
Data, Data, and More Data

Data, Data, and More Data

234 Vues Download Presentation
Télécharger la présentation

Data, Data, and More Data

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Data, Data, and More Data Kyle Roskoski

  2. Data • This is a summary of what environmental data we have access to for the year 1998-2000 (Some data through 2003) • Two people have been measuring and recording environmental data. Warren Heilman and Jaak Sober. • Warren’s data is recorded in Microsoft Excel and Jaak’s data in Microsoft Access • Dr. Sober is the only source for CO2 and O3 measurements

  3. Warren Heilman • The following data can be found at http://www.fs.fed.us/nc/face/ • The following site can be looked at to see graphs created showing averages, maximums, and minimums of some of the data for the years 1998-2003. http://www.ncrs.fs.fed.us/4401/focus/face/meteorology/

  4. Assumptions • Birch PAR means the birch quadrant of the ring. Similarly with aspen and maple

  5. Warren’s ½ Hour Ring Data • Soil Temperaturesat 5, 10, 20, 50, and 100 cm depths for each of the three quadrants • Thermocouple Reference • Leaf Wetness (2001 and after) • Rain (Rings 1.2 and 3.3) • Wind Speed and direction at 2m • Wind Speed and direction at 10m • Standard deviations of the previous two • Birch PAR at 2m • Aspen PAR at 2m • Maple PAR at 2m • Standard Deviations of PAR in each quadrant • Birch Temp at 2m • Aspen Temp at 2m • Maple Temp at 2m • Pole Temp at 10m • Birch RH at 2m • Maple RH at 2m • Aspen RH at 2m • Pole RH • Net radiation at 2m • Standard Deviation of Net Radiation

  6. Warren’s 2 hour data • Soil moistures measured at • 5-35cm deep • 50-80cm deep • 1-1.3 m deep • These are taken in each of the 3 quadrants

  7. ½ Hour Tower Measurements • Wind Speed and direction at 2,5,10,15, and 20m and standard deviations of direction • PAR at 2m • Net radiation at 2m • Temp at 2,5,10,15, and 20m • RH at 2,5,10,15, and 20m. • Thermocouple Reference (TC) • TC Surface Temperature • TC Temp at 25,50,75,100, and 200 cm • Soil Temperatures at 5,10,20,50, and 100cm • Leaf Wetness • Rain • Depth of Water in Evaporation Pan • Barometric Pressure

  8. Daily Measurements • Averages, Maximums and Minimums are recorded in files ending in 124.xls or 224.xls • Same measurements as in the first two files. • Averages calculated for all of the variables • Maximum and Minimums for PAR, Temp, Wind, Soil Temp, RH, and others • Total rain for month also calculated

  9. Jaak Sober Data • Microsoft Access files of the raw data can be found at ftp://www.face.bnl.gov/FACTS II/ • I’ve been under the assumption that all of Jaak’s data was taken from a height of 1m, but we only know that temperature was for certain. • Passive ozone monitors placed in 2002 at heights of 2m and 4m to check for even mixing.

  10. Jaak CO2 data formatted • http://cdiac.esd.ornl.gov/programs/FACE/facts-IIdata/co2files.html • 1998-2002 CO2 data for all CO2 rings. (there is missing data in files) • QUALITY-ASSURANCE CHECKS AND DATA-PROCESSING ACTIVITIES PERFORMED BY THE FACTS-II FACE PROJECT AND CDIAC • All data were checked for appropriate format. • For each variable, the range of values was checked for unrealistically large or small values. • The CO2 values were checked for consecutively repeating identical values. • The DOY (day of the year) values were verified from the specified combinations of MONTH and DAY.

  11. Jaak Sober Data One minute data • Wind Speed • Wind Speed CV • Wind Direction and Standard Deviation • Air Temperature Exterior • Air Temperature Enclosure (After 1998) • H20_v_pres (Vapor pressure Deficit or Relative Humidity) • PAR • Solar Altitude • Solar Energy (After 1998) • Barometric Pressure (After 1998) • Proportional valve control setting • Proportional valve response value • Set Point (CO2 or O3) • FACE grab (CO2 or O3 right at that second) • 1 or 5 minute averages for CO2 or O3 • Ambient O3 • Ambient CO2 (After 1998)

  12. Jaak’s data was taken at Eastern Standard Time and Warrens was at Central Standard Time.

  13. Relative Humidity

  14. Carbon Dioxide

  15. Temperature

  16. PAR

  17. Ozone

  18. PAR Values • Daily Averages from the hours of 4:00 – 19:00

  19. PAR Values • Daily Averages from the hours of 4:00 – 19:00

  20. Macros and Queries • I have macros and queries for creating the 1 minute data from Jaak and also macros for converting the ½ hour data from Warren into 1 hour data.

  21. Some Things to Note • Averaged daily. If there is one value in the 16 hours then the report says we have a value for the day. • Ambient data is just taken at several places in case of problems with the equipment. According to researchers at the FACE site, they can be combined to get one ambient supply. • Decisions on what data to throw out. There are a lot of zeros in the data, as well as negative values for temperature