The AQUASTAT Questionnaire
Before a proper questionnaire harvester is created, the data collected, either through the questionnaire, other international organizations or literature review, should be uploaded in the aquastat_questionnaire dataset through the import function of the SWS.
Steps
- Create a csv file based on the following template for the data;
Table 2.1: Step 1
|
geographicAreaM49
|
aquastatElement
|
timePointYears
|
Value
|
flagObservationStatus
|
flagMethod
|
|
4
|
4250
|
2013
|
100
|
NA
|
NA
|
- Create a csv file based on the following template for the metadata (compulsory, please add at least the source ID as metadata);
Table 2.2: Step 2
|
aquastatElement
|
geographicAreaM49
|
timePointYears
|
Metadata Type
|
Metadata Id
|
Metadata Element Type
|
Language
|
Value
|
Data Value
|
flagObservationStatus
|
flagMethod
|
|
4
|
4250
|
2013
|
ACCURACY
|
1
|
COMMENT
|
en
|
test metadata
|
100
|
NA
|
NA
|
- Create a csv file based on the following template for the block metadata if needed;
Table 2.3: Step 3
|
I
|
8049
|
GENERAL
|
|
D
|
aquastatElement
|
4171
|
|
C
|
aquastatElement
|
Surface water: leaving the country to other countries (total) [10^9 m3/year]
|
|
D
|
timePointYears
|
2012
|
|
C
|
timePointYears
|
2012
|
|
D
|
geographicAreaM49
|
24
|
|
C
|
geographicAreaM49
|
Angola
|
|
M
|
COMMENT
|
Observations: (NAM:)On Okavango/Cubango: Namibia only can use this water in a small area
|
- Each of this csv file should be imported and their respective data saved to the dataset one after the other.