The original data table containing rainfall data under ORACLE is called JORDAN_DAILY_RAINFALLL. Below an example is shown containing data for one station and a single day.
The explanations for AGENCY_CODE and CLIMATE_REMARKS_CODE are given in the respective look-up tables. The observed value stored is in the field DAILY_RAINFALL. It is in mm.
Although table DAILY_RAINFALL does not contain records with zero rainfall (except for the days specially marked as data gap or accumulated reading), it is a rather huge table.
| AGENCY
_CODE |
STATION
_ID |
READING
_DATE |
DAILY_
RAINFALL |
CLIMATE_
REMARKS_ CODE |
COMMENTS | DATE_
LAST_ UPDATED |
USER_NAME |
|---|---|---|---|---|---|---|---|
| WAJ | AD0032 | 01-Jan-94 | 40.4 | - | 29-Apr-98 | JORDAN | |
| WAJ | AD0032 | 02-Jan-94 | 15.7 | - | 29-Apr-98 | JORDAN | |
| WAJ | AD0032 | 03-Jan-94 | 40 | - | 29-Apr-98 | JORDAN | |
| WAJ | AD0032 | 04-Jan-94 | 33.8 | - | 29-Apr-98 | JORDAN | |
| ... |