Release Level	5.4
	Release Date	2008 10
	Revision Level	1.0

Last modified on:   Monday, 20-Jul-09 14:03 CEST

Data Bases

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

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_DATA	binary 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_TIMESERIES	used 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

COUNTRY

country names

DOMAIN

DOMAINMETA

domain (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

DESCRIPTORS	descriptors for timeseries parameters
EDIT_TEMP	temporary 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
OUTLIERS	temporary, used by the 'outliers' function of timeseries page
PROFILE_DATA	data of the profile timeseries (generated by MM5)
TIMESERIES	metadata of timeseries
UPLOAD_TEMP

RBO

CLASS	data 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