xmlns:atom="http://www.w3.org/2005/Atom" xmlns:atom="http://www.w3.org/2005/Atom"

ANNEXU.K.TECHNICAL FORMAT FOR DATA TRANSMISSION

1.DATA STRUCTUREU.K.

The individual data records for each quarter, which are to be sent to Eurostat, shall consist of three linked data sets covering:

A1

vehicle-related variables

A2

journey-related variables

A3

goods-related variables (in the basic transport operation).

Each A1 ‘vehicle record’ is linked to 1-n ‘journey records’ (A2 data set) which contain data on the journeys made by that vehicle during the survey period (normally one week). Each journey record is in turn linked to 0-m ‘goods records’ (A3 data set) which contain data on the basic transport operations which make up that journey.

Figure 1 illustrates the structure of the data.

It should be noted that there may not be multiple goods records for each journey record. For laden journeys, depending on the method used to record journeys, and/or on the type of journey, there may be only one goods record linked to each journey record. For unladen journeys, there shall normally be no linked goods records (although the existence of linked goods records for empty journeys is permitted).

The ‘Methodological appendix’ in Annex A to Regulation (EC) No 1172/98 provides further information.

2.LIST OF FIELDSU.K.

The following information is provided for each field:

Data Set A1: Vehicle-related variables

a

This variable shall be coded using the country codes in Annex G to Regulation (EC) No 1172/98.

Field numberVariableDescriptionCodingField type* = optional variableMaximum length* = key fieldSpecific codes for missing values
1RCountReporting country aText2*
2DSetIDData set identifierA1Text2*
3YearYear of the data set4 digitsText4*
4QuarterQuarter of the data setQ1, Q2, Q3 or Q4Text2*
5QuestNQuestionnaire identifierText9*
6A1.1Possibility of using vehicle for combined transportTo be developedText*1
7A1.3Age of the road motor vehicle (lorry or road tractor)Years from first registrationNumeric299
8A1.6 [F1NACE Rev. 2] activity class of the vehicle operatorNACE 4-digit levelText*5
9A1.8.1Total vehicle kilometres during the survey period — loadedkmNumeric4
10A1.8.2Total vehicle kilometres during the survey period — empty (including road tractor journeys without semi-trailer)kmNumeric*4
11A1.9Vehicle weighting to be used to get full results from individual data, if the collection of data is carried out from a sampleNumeric8
12StratumStratum identifier of sample in which vehicle appearsText7
13A2 linkNumber of linked A2 recordsNumericNumeric5

Data set A2: Journey-related variables

a

This variable shall be coded using the country codes in Annex G to Regulation (EC) No 1172/98.

b

This variable shall be coded according to the rules set out in Annex G to Regulation (EC) No 1172/98.

Field numberVariableDescriptionCodingField type* = optional variableMaximum length* = key fieldSpecific codes for missing values
1RCountReporting country aText2*
2DSetIDData set identifierA2Text2*
3YearYear of the data set4 digitsText4*
4QuarterQuarter of the data setQ1, Q2, Q3 or Q4Text2*
5QuestNQuestionnaire identifierText9*
6JournNJourney identifierText5*
7A1.2Axle configurationAnnex B Regulation (EC) No 1172/98Text*3
8A1.4Maximum permissible laden weight100 kgNumeric4
9A1.5Load capacity100 kgNumeric4
10A1.7Type of transportAnnex A to Regulation (EC) No 1172/98Text19
11A2.1Type of journeyAnnex C Regulation (EC) No 1172/98Text1
12A2.2Weight of goodsGross weight in 100 kgNumeric4
13A2.3Place of loading (of the goods road motor vehicle, for a laden journey) bText5XX
14A2.4Place of unloading (of the goods road motor vehicle, for a laden journey) bText5XX
15A2.5Distance travelled: actual distance excluding the distance covered by the goods road motor vehicle while being transported by another means of transportkmNumeric4
16A2.6Tonnes x km effected during the journeytonne/kmNumeric8
17A2.7Countries crossed in transit (not more than 5) bText10
18A2.8Place of loading, if any, of the goods road motor vehicle on another means of transport bText*5XX
19A2.9Place of unloading, if any, of the goods road motor vehicle from another means of transport bText*5XX
20A2.10Degree of loading of vehicle (in terms of maximum volume of space used during the journey)Text*19
21A3 linkNumber of linked A3 recordsNumeric8

Data set A3: Goods-related variables (in the basic transport operation)

a

This variable shall be coded using the country codes in Annex G to Regulation (EC) No 1172/98.

b

This variable shall be coded according to the rules set out in Annex G to Regulation (EC) No 1172/98.

Field numberVariableDescriptionCodingField type* = optional variableMaximum length* = key fieldSpecific codes for missing values
1RCountReporting country aText2*
2DSetIDData set identifierA3Text2*
3YearYear of the data set4 digitsText4*
4QuarterQuarter of the data setQ1, Q2, Q3 or Q4Text2*
5QuestNQuestionnaire identifierText9*
6JournNJourney identifierText4*
7GoodsNGoods operation identifierText6*
8A3.1Type of goods, according to the groups referring to an appropriate classificationAnnex D to Regulation (EC) No 1172/98 (NST/R)Text2
9A3.2Weight of goodsGross weight in 100 kgNumeric4
10A3.3Classification of dangerous goodsAnnex E to Regulation (EC) No 1172/98 (main categories of Directive 94/55/EC)Text3
11A3.4Type of cargoAnnex F to Regulation (EC) No 1172/98 (1-digit level of UN Recommendation No 21)Text*1
12A3.5Place of loading of the goods bText5XX
13A3.6Place of unloading of the goods bText5XX
14A3.7Distance travelled, actual distance excluding the distance covered with the goods road motor vehicle while being transported by another means of transportkmNumeric4

3.MISSING VALUESU.K.

By default, missing values in data records shall be coded as an empty field (no data between two successive field separators). For certain fields, Eurostat may recommend the use of specific codes for missing values or other special values (see column ‘specific codes for missing values’).

Additional information is provided in the reference manual for the implementation of Regulation (EC) No 1172/98 on statistics on the carriage of goods by road.

4.CHANGE IN CONFIGURATION OR TYPE OF TRANSPORTU.K.

Annex A to Regulation (EC) No 1172/98 noted that during a survey period a vehicle might be subject to a change in configuration (addition of a trailer giving rise to a change in axle configuration and load capacity) or the type of transport might vary between journeys. These changes should be recorded, although this is not obligatory.

In order to permit the transmission of these data within the normal data structures described here, the variables A1.2, A1.4, A1.5 and A1.7 shall be transmitted as part of the A2 data set (journey-related variables).

5.VALIDATION OF DATA BY EUROSTATU.K.

Eurostat shall apply some validation checks to the data transmitted by Member States, before the data are loaded into the production database. Where a significant number of records fails these checks, Eurostat shall notify the Member State of the records in error and provide an indication of the reasons for non-acceptance. The Member State shall be requested to rectify the errors noted and then to re-submit the complete set of three data sets for that quarter (not just the records that were in error). This procedure is necessary in order to guarantee the correctness of the weighting factors and the coherence between the vehicle, journey and goods records.

Where the number of records containing errors is very small and the likely effect on any analysis insignificant, Eurostat shall load those records that pass the verification checks and to discard the records in error. In such a case a Member State shall be informed of the records not passing the checks and the reasons. The Member State shall be invited, if it wished, to correct the errors found and to resubmit the complete set of three data sets for that quarter (not just the records that were in error). Where a re-submission is made, Eurostat shall load the revised data but if no re-submission is made, Eurostat shall use the date already accepted for the preparation of aggregated tables.

6.NAMING OF DATA SETSU.K.

Names of data sets shall be, according to the Stadium requirements, in the form ‘CCYYQnROADAx.ZZZ’ where:

CCReporting country
YY2 last digits of the year (e.g. ‘01’ for year 2001)
QnQuarter: n = 1 to 4
ROADAx

Data set identification:

A1:

vehicle data set

A2:

journey data set

A3:

goods data set

.ZZZ

data set type:

.dat:

individual data sets

.zip:

compressed data set in Pkzip or WinZip format

Examples:

1.

The data set ‘ES99Q2ROADA1.zip’ is a compressed ‘zip’ data set containing the A1 data set for Spain, year 1999 and quarter 2 (‘ES99Q2ROADA1.dat’).

2.

The data set ‘UK99Q3ROADA2.dat’ is the data set that contains for United Kingdom, year 1999, quarter 3, the data set A2.

The above specified data set name has to appear in the subject line of the electronic mail.

7.TRANSMISSION MEDIAU.K.

The preferred transmission support is Stadium, sent to an address to be notified by Eurostat. Note that electronic mail is subject to maximum size limits which may exclude its use for large data sets.

8.TRANSITIONAL PERIODU.K.

In a transitional period, the data may also be sent in ASCII data sets with variable-length fields. The semi-colon (‘;’) is used as the field separator.

All fields must be present even if they are empty (that is, two successive field separators).

Additional spaces in the data fields shall be ignored, unless the specific instructions for a field prohibit the presence of additional spaces.

Furthermore during this transitional period Eurostat shall also support the reception of data by post on diskettes or recordable compact disks (CD-R). Data shall not be accepted on magnetic tapes or on paper.

Where data are to be sent by electronic mail, the following rules shall apply in a transitional period: