12.1. Structure input

12.1. Structure input
	Chapter 12. Structure/Contiguity input

In the the input structure.xls Excel file, ten sheets must mandatory be provided in a unique .xls file.

Optionnally, complex contiguities must be defined as a set of seven sheets in an unique other xls file. Thus the input data may be composed of:

some_structure.xls: to describe the structure;
some_contiguity.xls: to optionally describe the contiguities (see Section 12.2).

Table 12.1 provides the list of these sheets names and a short description for each of them, as they are expected in the structure input definition. The expected columns and an example for each of them is described below this table.


The names of sheets is case-unsensitive. For example, the mandatory `UnitArea.txt` file can be named `unitarea.txt` or `UNITAREA.txt`. Suffixes and prefixes around the file basename are also possible while choosing the plain text option: thus, `my_UnitArea.txt` will be considered as a `UnitArea.txt` file, e.g. the input file that contains the information about the relationships between areas and territorial units.

The names of sheets is case-unsensitive. For example, the mandatory UnitArea.txt file can be named unitarea.txt or UNITAREA.txt. Suffixes and prefixes around the file basename are also possible while choosing the plain text option: thus, my_UnitArea.txt will be considered as a UnitArea.txt file, e.g. the input file that contains the information about the relationships between areas and territorial units.

Table 12.1. Overview of expected sheets for data structure input

Excel Sheet Name	Description
unit	Identifiers for the set of territorial units. See Content of unit.
Area	Identifiers for the set of study areas. See Content of area.
Zoning	Identifiers for the set of meshes. See Content of zoning.
UnitSup	Hierarchy between units: an `UTSup_ID` parent unit owns at least one child `UT_ID` unit. See Content of unitsup.
UnitArea	An UT belongs to one or several study areas. See Content of unitarea.
UnitZoning	An UT belongs to one or several meshes. See Content of unitzoning.
language	Provides a human readable name for used languages codes. See Content of language.
UnitLanguage	Names of UT in different languages. A translation may be missing. See Content of unitlanguage.
AreaLanguage	Names of the study areas in different languages. A translation may be missing. See Content of arealanguage.
ZoningLanguage	Names of the meshes in different languages. A translation may be missing. See Content of zoninglanguage.

Expected content for each of these sheets is following:

Unit

This file/sheet must contain one column whose header cell must be UT_ID. Example:
Table 12.2. Sample input Unit sheet
UT_ID
AT11
AT12
AT13
AT21
etc...

Area

Table 12.2. Sample input Unit sheet
UT_ID
AT11
AT12
AT13
AT21
etc...

This file/sheet must contain one column whose header cell must be Area_ID. Example:
Table 12.3. Sample input Area sheet
Area_ID
UE15
UE25
PECO
Arc_Atlantique
Nouveaux_UE
UE27
UE29

Zoning

Table 12.3. Sample input Area sheet
Area_ID
UE15
UE25
PECO
Arc_Atlantique
Nouveaux_UE
UE27
UE29

This file/sheet must contain one column whose header cell must be Zoning_ID. An additional column named Rank may order given zonings. Example:
Table 12.4. Sample input Zoning sheet
Zoning_ID Rank
Nuts_0 1
Nuts_1 2
Nuts_2 3
Nuts_3 5
Nuts_2_3 4

UnitSup

Table 12.4. Sample input Zoning sheet
Zoning_ID	Rank
Nuts_0	1
Nuts_1	2
Nuts_2	3
Nuts_3	5
Nuts_2_3	4

This file/sheet must contain two columns whose header cells must be named UTSup_ID and UT_ID. Example:
Table 12.5. Sample input UnitSup sheet
UT_ID UTSup_ID
AT1 AT
AT2 AT
AT3 AT
BE1 BE
BE2 BE

UnitArea

Table 12.5. Sample input UnitSup sheet
UT_ID	UTSup_ID
AT1	AT
AT2	AT
AT3	AT
BE1	BE
BE2	BE

This file/sheet must contain two columns whose header cells must be named UT_ID and Area_ID. Example:
Table 12.6. Sample input UnitArea sheet
UT_ID Area_ID
AT UE15
BE UE15
DE UE15
DK UE15
ES UE15

UnitZoning

Table 12.6. Sample input UnitArea sheet
UT_ID	Area_ID
AT	UE15
BE	UE15
DE	UE15
DK	UE15
ES	UE15

This file/sheet must contain two columns whose header cells must be UT_ID and Zoning_ID. Example:
Table 12.7. Sample input UnitZoning sheet
UT_ID Zoning_ID
AT Nuts_0
BE Nuts_0
BG Nuts_0
CH Nuts_0

Language

Table 12.7. Sample input UnitZoning sheet
UT_ID	Zoning_ID
AT	Nuts_0
BE	Nuts_0
BG	Nuts_0
CH	Nuts_0

This file/sheet must contain two columns whose header cell are Language_ID and Language_NAME. Example:
Table 12.8. Sample input Language sheet
Language_ID Language_NAME
DE allemand
CS tchèque
DA danois
ET estonien
EN anglais
ES espagnol

UnitLanguage

Table 12.8. Sample input Language sheet
Language_ID	Language_NAME
CS	tchèque
DA	danois
ET	estonien
EN	anglais
ES	espagnol

This file/sheet must contain three columns whose header cells must be UT_ID, UT_NAME and Language_ID. Example:
Table 12.9. Sample input UnitLanguage sheet
UT_ID Language_ID UT_NAME
AT11 DE BURGENLAND
AT34 DE VORARLBERG
BE24 NL VLAAMS BRABANT
BE25 NL WEST-VLAANDEREN
BE31 FR BRABANT WALLON
BE32 FR HAINAUT

AreaLanguage

Table 12.9. Sample input UnitLanguage sheet
UT_ID	Language_ID	UT_NAME
AT11	DE	BURGENLAND
AT34	DE	VORARLBERG
BE24	NL	VLAAMS BRABANT
BE25	NL	WEST-VLAANDEREN
BE31	FR	BRABANT WALLON
BE32	FR	HAINAUT

This file/sheet must contain three columns whose header cells must be Area_ID, Language_ID and Area_NAME. Example:
Table 12.10. Sample input AreaLanguage sheet
Area_ID Language_ID Area_NAME
UE15 FR Union européenne des 15
UE25 FR Union européenne des 25
PECO FR Pays d'Europe Centrale et Orientale

ZoningLanguage

Table 12.10. Sample input AreaLanguage sheet
Area_ID	Language_ID	Area_NAME
UE15	FR	Union européenne des 15
UE25	FR	Union européenne des 25
PECO	FR	Pays d'Europe Centrale et Orientale

This file/sheet must contain three columns whose header cells must be zoning_ID, Language_ID and zoning_NAME. Example:
Table 12.11. Sample input ZoningLanguage sheet
Zoning_ID Language_ID Zoning_NAME
Nuts_0 FR Nomenclature des unités territoriales de niveau 0
Nuts_1 FR Nomenclature des unités territoriales de niveau 1
Nuts_2 FR Nomenclature des unités territoriales de niveau 2
Nuts_3 FR Nomenclature des unités territoriales de niveau 3
Nuts_2_3 FR Nomenclature des unités territoriales de niveau 2-3

Zoning_ID	Language_ID	Zoning_NAME
Nuts_0	FR	Nomenclature des unités territoriales de niveau 0
Nuts_1	FR	Nomenclature des unités territoriales de niveau 1
Nuts_2	FR	Nomenclature des unités territoriales de niveau 2
Nuts_3	FR	Nomenclature des unités territoriales de niveau 3
Nuts_2_3	FR	Nomenclature des unités territoriales de niveau 2-3


Chapter 12. Structure/Contiguity input		12.2. Contiguity input (optional)