OpenLegislation

Division Data quality assessment

United Kingdom

Original text. Later amendments are not shown.

Analytical data quality assessment will be performed upon receipt of data from the Member States, in order to ensure integrity and logical consistency of the database.

In a first stage individual fields will be examined to verify that data domains and validation rules are respected (see table below).

Field nameData domains and validation rules for individual fieldsCodes for missing data
FIREIDNo duplicate values accepted (ID must exist and be unique within the country)Missing data not accepted
DATEALDate must exist in the reporting year (e.g. year = reporting year; month domain: 1..12; day domain: depending on month)99999999
TIMEALDomains: Hour (0..23); Minutes (0..59)9999
DATEINDate must exist in the reporting year (e.g. year = reporting year; month domain: 1..12; day domain: depending on month)99999999
TIMEINDomains: Hour (0..23); Minutes (0..59)9999
DATEEXDate must exist in the reporting year (e.g. year = reporting year; month domain: 1..12; day domain: depending on month)99999999
TIMEEXDomains: Hour (0..23); Minutes (0..59)9999
NUTS3NUTS3 code must exist in Appendix I of Regulation EC 1059/2003 (or in GISCO database for new MS)XX
CODECOMCommune code must correspond to a code in the list of commune codes provided by the MSXX
NAMECOMCommune name must correspond to a name in the list of commune names provided by the MSXX
TBADomain: TBA > 0-999
FBADomain: FBA ≥ 0-999
NFBADomain: NFBA ≥ 0-999
CAUSEDomain: CAUSE in (1,2,3,4)9

In a second stage logical consistency among fields will be checked. To this end a number of rules will be applied to the received data, such as in the following, not exhaustive, examples:

  1. 1..

    The temporal sequence ‘date/time alarm’ -> ‘date/time intervention’ -> ‘date/time extinction’ should be respected. It can only be accepted in some cases that ‘date/time alarm’ = ‘date/time intervention’ in the event that the first attack follows immediately fire detection (fire detected by a fighting crew), although this situation is not often met.

  2. 2..

    It shall be verified that ‘Forested burned area’ + ‘Not forested burned area’ = ‘Total burned area’.

  3. 3..

    The commune indicated in CODECOM and NAMECOM shall belong to the territorial unit indicated in NUTS3.