Calculating statistics in airbase
Download
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