Table JORDAN_DAILY_RAINFALL

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
...