calculating statistics in airbase
Download
Skip this Video
Download Presentation
Calculating statistics in AirBase

Loading in 2 Seconds...

play fullscreen
1 / 19

Calculating statistics in AirBase - PowerPoint PPT Presentation


  • 125 Views
  • Uploaded on

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.

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

PowerPoint Slideshow about ' Calculating statistics in AirBase' - jeslyn


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.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
general procedure calculating statistics
General procedure calculating statistics
  • Calculate aggregated data
  • Calculate statistics
a calculate aggregated data calc average
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
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
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
1 calculate aggregated data load average year
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>

1a calculate derived dymax measurements load average year
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

2a calculate general statistics data type hour day dymax load statistic
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

2b calculate general statistics data type other than hour day dymax load statistic other
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

3 calculate exceedances load statistic exc
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

4 calculate n max values load statistic max
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

5 calculate ozone statistics load statistic aot
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

6 determine derived nox measurements cr vwraw rd type nox
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

7 calculate nox statistics load statistic nox
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

measurements general
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
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
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
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

ad