AirWare
air quality assessment & management
Reference and User Manual
     
      AirWare   On-line Reference Manual
        Release Level 6.2 preliminary
        Release Date 2013 XX
        Revision Level under revision
      Last modified on:   Wednesday, 18-Dec-13 11:34 CET

      Data Bases

      Several data bases   (implemented with MySQL (5.0); lternatively: PostgreSQL, ORACLE) are used for data management and the communication between the different models.

      They include:

        mysql mysql system data base
        information_schema mysql system data base
        AERMOD AERMOD model scenarios, for sequences of 24 hourly runs
        AIR emission sources: plants, boilers, small stacks, line and area sources
        AIRDESCRIPTORS Knowledge Base: descriptors
        AIRMATRIX model output and emission matrices(by model/domain, parameter, time step, and layer)
        CAMx CAMx model scenarios
        CONTACT address DB for source contacts
        COUNTRIES countries for address DB (source contacts and institutions)
        DOMAIN model and emisison inventory domains
        GLOBAL general configuration
        GLOBAL_LOG log of model runs
        MM5 MM5 model scenarios
        MODEL_TS timeseries descriptors (parameters used in the monitoring time series)
        MONITORING_TS timeseries data
        RBO object class information, monitoring stations, timeseries
        TEHRAN census/population data for census tracks (polygon/areas)
        USER_MAN User/access management
        gis individual (user configured) maps
        mapc GIS meta data, map set, overlays

        Data base TABLES

        AERMOD:   scenario data for all aermod scenarios
        IMPACT_SCENARIO impact scenarios: annual runs for a single source, population exposure
        NOWCAST_SCENARIO nowcast scenarios, scheduled hourly model runs
        RESULT_TIMESERIES used temporary for 'comparison' on model results page
        SCENARIO_METADATA interactive scenarios and traffic (line sources) scenarios

        AIR: emission sources
        AREA_SOURCE metadata for area sources
        BOILER metadata for boilers
        EMISSION_DISTRIBUTION emission pattern details
        EMISSION_FACTOR emission factors for traffic, combustion (point), and area sources
        EMISSION_PATTERN temporal emission patterns
        EMISSION_REPORT log file for emission inventory updates
        EMISSION_SCENARIO emission scenario
        EMISSION_SUMMARY emission inventory class table
        EM_INVENTORY_DETAILS emission inventory data by class/object
        ES_AREA_SOURCES assignment of area sources to emission scenarios
        ES_BOILERS assignment of boilers to emission scenarios
        ES_EMISSION_TOTALS emission totals by source and substance
        ES_SMALL_STACKS assignment of small stacks to emission scenarios
        ES_TEMP temporary, used by emission scenario calculations
        FLEET_COMPOSITION fleet composition class table
        ISENSORS monitoring stations, installed sensors
        LINE assignment of nodes to line sources
        LINE_SOURCE metadata for line sources
        METEO_SCENARIO meteo scenario
        METEO_STATIONS meteo stations
        NODE coordinates of nodes of line sources
        POLYGON coordinates of polygons of area sources
        POPULATION population class table
        SENSOR monitoring sensor meta data
        SMALL_STACK small stacks
        TEMP_BOILERLIST temporary, used for selection/navigation
        TEMP_OBJECTLIST temporary, used for selection/navigation
        TEMP_SENSORLIST temporary, used for selection/navigation
        building_points building points: sesnitive impact areas defined by polygons
        em_inventory_temp calculations/updates of emission inventory
        em_temp calculations/updates of emission inventory
        limit_value regulatory limit values for pollutants
        model_tmp temporary table
        pie_temp temporary table

        AIRDESCRIPTORS:   (Knowledge Base) Descriptors: variables/parameters used for Airware
        descriptors Descriptor meta data
        desc_questions question text for the interactive editor dialog
        desc_range legal ranges and associated text symbols for parameter values
        desc_values current object specific values of Descriptors
        desc_rules Rule references
        rule_act Rule consequence part
        rule_cond Rule condition parts

        AIRMATRIXmodel output and emission matrices
        MATRIX_DATAbinary data of matrices
        MATRIX_METADATA metadata of matrices
        MATRIX_STATDATA statistical data of matrices
        TEMP_MATRIX_SELECTION

        CAMx
        RESULT_MATRIX will be used in future for assignment of result matrices to scenarios
        RESULT_TIMESERIESused temporary for 'comparison' on model results page
        SCENARIO all camx scenarios ( Nowcast, Forecast, interactive)
        config some camx configuration (not to be edited by user)
        result temporay list for domain selection and pollutant selection

        CONTACT
         
        CONTACTPERSON  
        CUSTOMERSLIST_VALUES
        INSTITUTION  

        COUNTRIES
        COUNTRYcountry names

        DOMAIN
        DOMAINMETAdomain (meta) data

        GLOBAL
        BUTTONS  
        LOCATIONS location configuration information for each location
        MAPSETPOSITION  
        PRESENTATIONS  
        PRESENTATION_PAGE  
        PROJECTMETA  
        PROJECTS  
        PROJECT_LOCATIONS  
        PROJECT_STATUS  
        SYSTEMS  
        TOOLMETA  

        GLOBAL_LOG
        LOG log of all scenario runs (aermod, CAMx, MM5)

        MM5
        MM5_scenario mm5 scenario data
        MM5_subdomain

        MODEL_TS
        DESCRIPTORSdescriptors for timeseries parameters
        EDIT_TEMPtemporary for interactive TS editing
        UPLOAD_TEMP

        MONITORING_TS
        BOILER_DATA emission time series
        CLASS_TS_CONFIG
        DATA data of the timeseries of all monitoring stations
        METEO_RT  
        OUTLIERStemporary, used by the 'outliers' function of timeseries page
        PROFILE_DATAdata of the profile timeseries (generated by MM5)
        TIMESERIES metadata of timeseries
        UPLOAD_TEMP

        RBO
        CLASSdata of object classes
        CLASSMETA data of object classes
        RBO assignment of objectID's to class ID's
        RBODATA metadata of monitoring stations and metadata of timeseries
        TEMP_CLASSLIST temporary table for selection/filtering
        TEMP_OBJECTLIST temporary table for selection/filtering
        TEMP_VARLIST temporary table for selection/filtering

        gis
        geometry
        hist
        ids
        maps
        nic
        objects
        prof
        projections
        sobjects
        summary
        symbols
        temp_remove

        mapc
        cp_overlay_data
        mapset_data
        mapsets
        ovbackup
        overlay_data
        overlays
        set_id


© Copyright 1995-2016 by:   ESS   Environmental Software and Services GmbH AUSTRIA | print page