Division Data quality assessment
United Kingdom
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 name | Data domains and validation rules for individual fields | Codes for missing data |
|---|---|---|
| FIREID | No duplicate values accepted (ID must exist and be unique within the country) | Missing data not accepted |
| DATEAL | Date must exist in the reporting year (e.g. year = reporting year; month domain: 1..12; day domain: depending on month) | 99999999 |
| TIMEAL | Domains: Hour (0..23); Minutes (0..59) | 9999 |
| DATEIN | Date must exist in the reporting year (e.g. year = reporting year; month domain: 1..12; day domain: depending on month) | 99999999 |
| TIMEIN | Domains: Hour (0..23); Minutes (0..59) | 9999 |
| DATEEX | Date must exist in the reporting year (e.g. year = reporting year; month domain: 1..12; day domain: depending on month) | 99999999 |
| TIMEEX | Domains: Hour (0..23); Minutes (0..59) | 9999 |
| NUTS3 | NUTS3 code must exist in Appendix I of Regulation EC 1059/2003 (or in GISCO database for new MS) | XX |
| CODECOM | Commune code must correspond to a code in the list of commune codes provided by the MS | XX |
| NAMECOM | Commune name must correspond to a name in the list of commune names provided by the MS | XX |
| TBA | Domain: TBA > 0 | -999 |
| FBA | Domain: FBA ≥ 0 | -999 |
| NFBA | Domain: NFBA ≥ 0 | -999 |
| CAUSE | Domain: 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..
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..
It shall be verified that ‘Forested burned area’ + ‘Not forested burned area’ = ‘Total burned area’.
- 3..
The commune indicated in CODECOM and NAMECOM shall belong to the territorial unit indicated in NUTS3.