Rainplot Database Files

							Rainplot Database
The Rainplot program uses a separate database to store the results of the current analysis. By default this database is called Rainfall Stats and has a system DSN of “DSN=Rainfall Stats”. This can be changed by modifying the statistics_database parameter of RainplotSettings.xml file. The tables in the statistics database do not have any primary or foreign key constraints; they are simply used to hold the results of the current analysis. In all tables the station field is a TEXT(50). All fields named start_date, end_date, and date are date/time fields. All other fields are either numeric or text. The table structures for Rainfall Stats are outlined below.

1

maximum_intensity intensity_range station year daily_volume duration intensity hour_of_day month day series_type cutoff

station from_i to_i Volume Volume_percent duration duration_percent

diurnal_variation

prediction_above_intensity partial_series_intensity station intensity probability volume prediction start_month end_month series_type distribution_type I1 volume_above_intensity partial_series_cutoff station date day month year series_type total volume_5 volume_10 volume_15 volume_20 volume_30 volume_50

station hour month period volume intensity1 intensity2

station year duration intensity hour_of_day month

station

core_party agency station_id station_type start_date end_date connect_string

station duration cutoff

Annual_Rainfall

above_intensity

Station Year Annual_Amount

station intensity volume start_date end_date

2