#### LTPP TABLE NAVIGATOR: Field View

Fields for table: AWS_DAILY_DATA

Field NameCodesData TypeUnitsTest ProtocolDescription
AWS_ID

VARCHAR2(6)

AWS identification (STATE_CODE and SHRP_ID of closest SPS project).
TOTAL_DAY_PRECIP

NUMBER(6,3)
mm

Total measured precipitation for the day.
NUMBER_PRECIP_HOURS

NUMBER(2)

Number of hours for which precipitation data were collected for the day.
MEAN_DAY_SOLAR

NUMBER(5,1)
W/sq m

Total solar radiation for the day.
NUMBER_SOLAR_HOURS

NUMBER(2)

Number of hours for which solar radiation data were collected for the day.
MEAN_DAY_WIND_SPD

NUMBER(3,1)
m/s

Daily mean wind speed.
MEAN_DAY_WIND_DIR

NUMBER(3)
deg

Mean wind direction for the day.
MAX_DAY_WIND_SPD

NUMBER(3,1)
m/s

Maximum gust wind speed for the day.
MAX_DAY_WIND_SPD_DIR

NUMBER(3)
deg

Direction of maximum gust wind speed for the day
NUMBER_WIND_HOURS

NUMBER(2)

Number of hours for which wind data were collected for the day.
RECORD_STATUS

VARCHAR2(1)

A code indicating the general quality of the data.
AWS_DATE

DATE

Date when AWS data were collected.
MEAN_DAY_TEMP

NUMBER(3,1)
deg C

Average of the hourly mean ambient air temperature for the day.
MAX_DAY_TEMP

NUMBER(3,1)
deg C

Maximum ambient air temperature for the day.
MIN_DAY_TEMP

NUMBER(3,1)
deg C

Minimum ambient air temperature for the day.
NUMBER_TEMP_HOURS

NUMBER(2)

Number of hours for which temperature data were collected for the day.
MAX_DAY_HUMIDITY

NUMBER(4,1)
%

Maximum relative humidity for the day.
MIN_DAY_HUMIDITY

NUMBER(4,1)
%

Minimum relative humidity for the day.
NUMBER_HUMID_HOURS

NUMBER(2)

Number of hours for which humidity data were collected for the day.