LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: CLM_OWS_LOCATION

Field NameCodesData TypeUnitsTest ProtocolDescription
WEATHER_STATION_ID

VARCHAR2(11)


Unique identification for a particular weather station based on GHCND ID.
DATUM_HORIZONTAL

VARCHAR2(30)


Datum used to collect latitude and longitude.
DATUM_VERTICAL

VARCHAR2(30)


Datum used to collect elevation.
LAT_LONG_SOURCE

VARCHAR2(100)


Method or instrument used to collected location information.
WX_STATION_ID_OLD

VARCHAR2(7)


Unique identification for a particular weather station assigned using state and COOP_ID.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
WS_NAME

VARCHAR2(24)


Name used to identify weather station.
WS_TYPE
WS_TYPEVARCHAR2(1)


Code indicating type of weather station.
NAME_COOP

VARCHAR2(100)


Name used as part of the Cooperative Weather Station system.
LATITUDE_CLM

NUMBER(8,6)
deg

Latitude in decimal degrees from the climate agency
LONGITUDE_CLM

NUMBER(9,6)
deg

Longitude in decimal degrees from the climate agency
ELEVATION

NUMBER(4)
m

Elevation of weather station.
START_YEAR

NUMBER(4)


Start year (depending on test sites age) when weather station data were extracted.
END_YEAR

NUMBER(4)


End year (depending on test sites age) when weather station data were extracted.