1 / 19

Calculating statistics in AirBase

Calculating statistics in AirBase. General procedure calculating statistics. Calculate aggregated data Calculate statistics. A.Calculate aggregated data (calc_average). AirBase. getrawtable. get_dc. get_rd. Table-name. data_configuration. Raw_data. calc_max_mc. calc_avg_mc.

jeslyn
Download Presentation

Calculating statistics in AirBase

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Calculating statistics in AirBase

  2. General procedure calculating statistics • Calculate aggregated data • Calculate statistics

  3. A.Calculate aggregated data (calc_average) AirBase getrawtable get_dc get_rd Table-name data_configuration Raw_data calc_max_mc calc_avg_mc Max values averages

  4. B.Calculate statistics(calc_statistic) AirBase Stat_period getrawtable get_dc get_rd Table-name/duration Stat_period data_configuration Max_result Raw_data calc_stat_mc statistics

  5. Annual procedure calculating statistics • Calculate aggregated data (daily values, daily maximum running 8-hourly values) • Calculate general statistics (mean, maximum, percentiles) • data_type in (‘hour’, ‘day’, ‘dymax’) • other • Calculate exceedances • Calculate N-max values • Calculate Ozone statistics (AOT, SOMO35) • Calculate aggregated NOx-data • Calculate general statistics NOx

  6. 1.Calculate aggregated data (load_average_year) • Calculate derived measurements <data_typeB> • Load calculated measurements <data_typeB> in AirBase • Update timeseries Raw_data_<data_typeA>=(‘hour’, ‘hour8’) data_configuration a.calc_average c.upd_data_configuration <data_typeB>=(‘hour8’, ‘day’, ‘dymax’) Raw_data_day_report Raw_data <data_typeB> b.cp_raw_data Raw_data_<data_typeB>

  7. 1a. Calculate derived dymax-measurements(load_average_year) • Calculate and import running hour8-values • Update timeseries running hour8-values • Calculate and import dymax-values • Update timeseries dymax-values raw_data_hour load_average_year upd_data_con-figuration hour8 raw_data_hour8 load_average_year data_configuration Raw_data_dymax upd_data_configuration dymax

  8. 2a. Calculate general statistics(<data_type> = (hour, day, dymax), load_statistic) • Retrieve measurements <data_type> and calculate statistics • Load statistics into AirBase data_configuration Raw_data_<data_type> a.calc_statistic statistics <data_type> b.cp_statistic Statistic

  9. 2b. Calculate general statistics(<data_type> = (other than hour,day, dymax), load_statistic_other) • Retrieve measurements <data_type> and calculate statistics • Load statistics into AirBase data_configuration Raw_data_<data_type> a.calc_statistic_other statistics <data_type> b.cp_statistic Statistic

  10. 3. Calculate exceedances(load_statistic_exc) • Retrieve measurements <data_type> and calculate exceedances • Load exceedances into AirBase data_configuration Raw_data_<data_type> a.calc_statistic_exc exceedances <data_type> b.cp_statistic_exc Statistic_exc

  11. 4. Calculate N-max values(load_statistic_max) • Retrieve measurements <data_type> and calculate N-max values • Load N-max values into AirBase data_configuration Raw_data_<data_type> a.calc_statistic_max N-max values <data_type> b.cp_statistic_max Statistic_max

  12. 5. Calculate Ozone statistics(load_statistic_aot) • Retrieve measurements <data_type> and calculate AOT/SOMO35 • Load AOT/SOMO35 into AirBase data_configuration Raw_data_<data_type> a.calc_statistic_aot AOT/SOMO35 <data_type> b.cp_statistic_aot Statistic_aot

  13. 6.Determine derived NOx-measurements(cr_vwraw_<rd_type>_nox) Create a view in which the NO2-values and NO (expressed in NO2 -units) are stored from timeseries in table meas_configuration_nox. During retrieval of the NOx- values the NO- en NO2 values should be summarized. meas_configuration_nox raw_data_hour raw_data_day cr_vwraw_data_hour_nox cr_vwraw_data_day_nox vwraw_data_day_nox vwaw_data_hour_nox

  14. 7.Calculate NOx-statistics(load_statistic_nox) • Retrieve measurements <data_type> and calculate NOX-statistics • Load statistics into AirBase vwmeas_configuration_nox vwraw_data_<data_type>_nox a.calc_statistic_nox b.cp_statistic_nox statistics <data_type> statistic

  15. Storage measurements in AirBase

  16. Measurements(general) Meas_configuration raw_data_hour8 determine dymax-values from hourly values raw_data_hour raw_data_dymax Data_configuration raw_data_other determine timeseries from measurements raw_data_day_report Determine daily values from hourly values raw_data_day

  17. NOx measurements Meas_configuration statistic Raw_data_hour Raw_data_day Determine all stations for which NO as well as NO2 values are stored Calculate NOx-hourly values from NO+NO2-hourly values (NOx= 46/30 * NO + NO2) Calculate NOx-daily values from NO+NO2-daily values (NOx= 46/30 * NO + NO2) vwraw_data_hour_nox vwraw_data_day_nox Meas_configuration_nox

  18. Statistics Statistic_report Add reported statistics of timeseries for which no measurements are available Meas_configuration raw_data_other Statistic Calculate general statistics raw_data_hour Statistic_exc Calculate exceedances raw_data_day Statistic_max Calculate N-max statistics raw_data_dymax Statistic_aot Calculate AOT/SOMO35 statistics

  19. NOx-Statistics Meas_configuration_nox vwraw_data_hour_nox Statistic_nox Calculate general statistics vwraw_data_day_nox remove NOx-statistics for which along with the NOx-values also NO and NO2-values are reported Statistic

More Related