Calculating statistics in AirBase

1 / 19

# Calculating statistics in AirBase - PowerPoint PPT Presentation

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.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

## PowerPoint Slideshow about ' Calculating statistics in AirBase' - jeslyn

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

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

### 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

Max values

averages

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

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
• 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>

• Calculate and import running hour8-values
• Update timeseries running hour8-values
• Calculate and import dymax-values
• Update timeseries dymax-values

raw_data_hour

upd_data_con-figuration hour8

raw_data_hour8

data_configuration

Raw_data_dymax

upd_data_configuration dymax

2a. Calculate general statistics(<data_type> = (hour, day, dymax), load_statistic)
• Retrieve measurements <data_type> and calculate statistics

data_configuration

Raw_data_<data_type>

a.calc_statistic

statistics <data_type>

b.cp_statistic

Statistic

2b. Calculate general statistics(<data_type> = (other than hour,day, dymax), load_statistic_other)
• Retrieve measurements <data_type> and calculate statistics

data_configuration

Raw_data_<data_type>

a.calc_statistic_other

statistics <data_type>

b.cp_statistic

Statistic

• Retrieve measurements <data_type> and calculate exceedances

data_configuration

Raw_data_<data_type>

a.calc_statistic_exc

exceedances <data_type>

b.cp_statistic_exc

Statistic_exc

• 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

• Retrieve measurements <data_type> and calculate AOT/SOMO35

data_configuration

Raw_data_<data_type>

a.calc_statistic_aot

AOT/SOMO35 <data_type>

b.cp_statistic_aot

Statistic_aot

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

• Retrieve measurements <data_type> and calculate NOX-statistics

vwmeas_configuration_nox

vwraw_data_<data_type>_nox

a.calc_statistic_nox

b.cp_statistic_nox

statistics <data_type>

statistic

### Storage measurements in AirBase

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

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

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

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