Entity Definition

Logical Name : WeatherConditionType
Physical Name : CO_WTHR_CN_TYP

A reference table used to characterize weather conditions. Used to classify items as welll as to help classify selling conditions. This table translates METAR weather condition codes (and structured strings) into a single Weather Condition Type Code suitable for use in classifying merchandise, describing weather condition for a business day/site, forecasting weather in sufficient detail for retail operational planning and activity measurement. The METAR attributes provide detail as well as the mapping from METAR to ARTS Weather Condition Type Code. Retailers will have to perform this mapping process.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
WeatherConditionTypeCode (PK) Code used to identify a collection of weather characteristics that are important to a retailer in tracking sales and operations. CD_WTHR_CN_TYP Code varchar(20)
Temperature (FK) The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. CD_TEMP_UN_OF_MEAS Code varchar(20) UnitOfMeasure(CO_UOM)
Precipitation (FK) The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. CD_PRCPTN_UN_OF_MEAS Code varchar(20) UnitOfMeasure(CO_UOM)
METARWindConditionCode METAR String used to report wind conditions. Format is as follows: dddssKT OR dddssGggKT ddd = Wind direction in degrees ss = sustained wind speed G = means there are gusts gg = gust wind speed KT = constant that indicate U/M is knots MPS = constant that indicates U/M is meters per second. CD_METAR_WND_CN Code varchar(20)
METARVisibilityCode METAR string used to specify visibility vvSM = visibility in statute miles vvKM = visibility in kilometers Visibility value, vv may be expressed as partil SM or KM like 1 1/2SM or 3/16KM So we have to interpret this positioinally CD_METARV_VSBLTY Code varchar(20)
METARWeatherConditionCode Defines a basic set of weather conditions. This may be supplemented by METARWeatherRemarks iiddppooxx where ii = intensity values - = light + = heavy blank = moderate VC = in vincinity dd = descriptor values: MI = shallow PR = partial BC = patches DR = low drifting BL = blowing SH = shower TS = thunderstorem FZ = freezing pp = precipitation condition DZ = drizzle RA = rain SN = snow SG = snow grains IC = ice crystals PE = ice pellets GR = hail UP = unknown oo = obscuration condition BR = mist FG = fog FU = smoke VA = volcanic ash DU = dust HZ = haze PY = spray xx = misc. condition PO = dust whirls SQ = squalls FC = tornado/funnel cloud SS = duststom CD_METAR_WTHR_CN Code varchar(20)
METARCloudConditionCode Defines cloud coverage and level Format: ccchhhtt ccc = cloud coverage CLR = clear SKC = clear FEW = 1/8 coverage BKN = 5,6, 7/8 coverage OVC = Overcast VV = vertical visibility for obscuration hhh = height of cloud base in 30m or 100 ft increments (30 = 3000 ft) tt = cloud type CU = cumulus CB = cumulonumbus TCU = towering cumulus CI = cirrus CAVOK = clear skies, unlimited visability (overwirtes the ccchhtt format if it's clear) CD_METAR_CLD_CN Code4External char(4)
METARTemperatureDewPoint METAR convention for recording the temperature (one value) and dew point (2nd value). Values are reported WHOLE DEGREES CELSIUS. Sub zero temperature (celsius) is indcated by an M in front of the whole number degrees. Format MCC/MCC M - not present or value of M for minus CC - Two digit temp in whole deg celsius CD_METAR_TEMP_DEW_PNT Code varchar(20)
METARWeatherDescription This is a string value that is used to supplement the other baseline METAR codes with more detailed weather reporting data. For ARTS only some of the many METAR standard codes will be relevant. RMK (literal that tells that this set of strings is a remark) String Definition 4xxxxnnnn 24 hr Max (x) Min (n) temp in .1 degC units, 1st digit 1 for neg 4/sss Snow coverage in inches 98/mmm Equiv. sunshine for day in minutes SLPppp Sea level pressure in .1 mb (.1 mb (142 = 1014.2 mb) Other METAR may be added later. Note we are following METAR's standard which is clearly not normlized. DE_METAR_WTHR DescriptionShort varchar(255)


Parent Entity Verb Phrase Child Entity
UnitOfMeasure defines WeatherConditionType
UnitOfMeasure defines WeatherConditionType
WeatherConditionType characterizes METARWeatherForecast
WeatherConditionType characterizes METARWeatherCondition
WeatherConditionType characterizes MerchandiseHierarchyGroup

Logical Views containing WeatherConditionType

Logical View
Logical 01000 - Item Description - Macro View
Logical 01004 - Item Description - Branding
Logical 01020 - Item Description - Enterprise View
Logical 10102 - EnterpriseWeather