# CODE_LIST_DO_NOT_MODIFY

lu_Definition:
Macedonia, the Former Yugoslav Republic of


lu_ShortDescription:
Only polygon information can be used for updating the NVZ database


lu_Definition:
Phreatic groundwater (shallow): 0-5 m (inclusive springs 0 m)


lu_ShortDescription:
Biochemical Oxygen Demand, Dissolved Oxygen


lu_ShortDescription:
Chlorophyll-a, Dissolved inorganic Nitrogen, Dissolved inorganic Phosphorus


lu_Definition:
Biochemical Oxygen Demand (BOD5  is preferred)


# DEFINITIONS_DATASET_DO_NOT_MODIFY

ds_Name:
Evaluation of water quality under the Nitrates Directive.

ds_Definition:
Data on monitoring stations are collected for each reporting period (4 year period). Full details of the data requested on water are presented in this specification by tables and include characteristics on the water monitoring stations, values for the concentrations of NO3 for each station as well as information on the Nitrate Vulnerable Zones and Potential Vulnerable Zones.
Additionally

ds_Methodology:
The data requested for Nitrates Directive should be derived from existing national and/or regional monitoring networks within each Member State.
The combination of the elements CountryCode, NationalStationCode and StationType must be a unique record in the table. No duplicate records should exist with this combination.
Please consider the following when compiling your data delivery:
1. Provide information on the monitoring stations. The station location must represent a point location.
2. Submit NO3 concentrations for groundwater- and surface water monitoring stations sampled during a period of one or more years within the reporting period.
3. Submit information on the trophic state (and eutrophication parameters) for the surface water monitoring stations.
4. Submit data for each sample site (no aggregation of stations).
5. Submit geographical data sets (shapefiles or e00) for the Nitrate Vulnerable Zones and Potential Vulnerable Zones in order to create and update the NVZ database (hosted by JRC). For GIS guidelines go to http://eionet.europa.eu/gis/ . 
6. For countries with Whole territory Approach, supply information on the legal act (table WTA). 
7. The WTA countries can also supply geographical information on the risk areas in there country. This is optional.
8. Use the templates (XML schemas or Excel) and these specifications to guide you in formatting and collating your data delivery. All are available for download from the data dictionary.
9. Supply data on monitoring stations in XML, Excel or tab-separated ASCII text format. Ensure commas are not used as decimal separators.
10. Upload your data files to your nominated repository: the Central Data Repository at http://cdr.eionet.europa.eu/


# DEFINITIONS_ELEMENTS_DO_NOT_MODIFY

e_Definition:
Abbreviation of EEA Member or Collaborating Country, as defined in the codelist.


e_Definition:
Timestamp of edition in format YYYY-MM-DD


e_Methodology:
Geographical data sets should be provided in .shp or .e00 formats.
See EEA guidelines for geographic data and maps at: http://eionet.europa.eu/gis/.


e_Definition:
Topology stores the relationships of one spatial element with respect to another.

e_Methodology:
Only polygon topology, double precision is accepted.
Topological consistency - no duplicated lines, no dangles, all polygons are closed, each polygon has a label, only a single label per polygon, no neighbor polygons with the same code…).


e_Definition:
Approximate scale at which map data captured (e.g. 1:100,000).


e_Methodology:
A datum provides a frame of reference for measuring locations on the surface of the earth. It defines the origin and orientation of the lines of longitude and latitude (e.g. ETRS89).
Provide your geographical data sets and geographical co-ordinates in ETRS89 (European Terrestrial Reference System 89) format.
See EEA guidelines for geographic data and maps at: http://eionet.europa.eu/gis/.


e_Definition:
Name of projected co-ordinate system if co-ordinates are provided in a format other than unprojected.

e_Methodology:
A projection is a method of transforming the three-dimensional surface of the earth onto a two-dimensional, flat map sheet. In a projected co-ordinate system, locations are identified by x, y co-ordinates on a grid, with the origin at the centre of the grid.
Provide your geographical data sets and geographical co-ordinates unprojected.
See EEA guidelines for geographic data and maps at: http://eionet.europa.eu/gis/.


e_Methodology:
Indicate "true" if MS has Whole Territory Approach"


e_Definition:
Start date of legal act in format YYYY-MM-DD.

e_Methodology:
This is a mandatory element. Indicate start date of legal act.


e_Definition:
Eventual end date of legal act in format YYYY-MM-DD.

e_Methodology:
Indicate the eventual end date of the legal act.


e_Methodology:
Indicate name of Nitrate Vulnerable zone


e_Definition:
Beginning date of validity in format YYYY-MM-DD

e_Methodology:
This is a mandatory element. Indicate the begining date of the validity of the NVZ area


e_Definition:
End date of the validity in format YYYY-MM-DD

e_Methodology:
Indicate the end date of the validity of the NVZ area if applicable.


e_Definition:
The validity for the Nitrate Vulnerable Zones or Potential Vulnerable Zones, as defined in the fixed values list.

e_Methodology:
This is a mandatory element. In the NVZ table the values 1, 2, 3 or 4 can be can be applied. In the table for Potential Vulnerable Zones only 1 or 2 are valid.


e_Methodology:
This element will be computed by the GIS software


e_Definition:
Area declared by the Member State Authorities

e_Methodology:
Area declared by the Member State Authorities


e_Definition:
Nationally assigned, unique identifier of the groundwater  monitoring station or surface water monitoring station (river, lake, marine).

e_Methodology:
This is a mandatory element. The combination of the fields CountryCode, NationalStationCode and StationType must be a unique record in the table. No duplicate records should exist with this combination.


e_Definition:
Station Type as defined in the fixed values list

e_Methodology:
This is a mandatory element. For the Station Type use the "station Type" codelist. The combination of the fields CountryCode, NationalStationCode and StationType must be a unique record in the table. No duplicate records should exist with this combination.


e_Definition:
National identification code of water body (if available) in which station is located.

e_Methodology:
Water body as required/defined by the WFD.
A water body may have more than one station in it.


e_Definition:
Name of water body in which station is located.


e_Definition:
Depth of samples in meters below soil surface

e_Methodology:
Thuis is a mandatory element. Indicate at which depth samples are taken.


e_Name:
National station code Nitrates Directive

e_Definition:
Nationally assigned, unique identifier of the monitoring station used for the previous ND reporting.

e_Methodology:
Only to fill in if another code for this station has been used for the 3rd reporting (2000-2004)period of ND.


e_Methodology:
Indicate "true" if site is in use for drinking water.


e_Definition:
(X) International geographical co-ordinates in decimal degrees format.

e_Methodology:
This is a required, not null field.
Provide Longitude using the common geodetic datum ETRS89 (rivers, lakes, groundwater, water quantity) or WGS84 (TCM).
Negative values should be used for co-ordinates west of the Greenwich Meridian (0 degrees).
Please do not round co-ordinate values.
Where TCM stations represent a broader area, the central location of the area should be provided.


e_Definition:
(Y) International geographical co-ordinates in decimal degrees format.

e_Methodology:
This is a required, not null field.
Negative values should be used for co-ordinates south of the Equator (0 degrees).
Provide Latitude using the common geodetic datum ETRS89 (rivers, lakes, groundwater, water quantity) or WGS84 (TCM).
Please do not round co-ordinate values.
Where TCM stations represent a broader area, the central location of the area should be provided.


e_Methodology:
Only to fill in if another code for this station has been  reported to WFD.


e_Definition:
Station (code) already in WB (WaterBase)

e_Methodology:
Only to fill in if another code for this station has been  reported under the Eionet/Water or Waterbase.


e_Definition:
Last date of measurement period in format YYYY-MM-DD.

e_Methodology:
This is a mandatory element.
Indicate the end date of the period for which samples were taken.


e_Definition:
Last date of measurment period in format YYYY-MM-DD

e_Methodology:
This is a mandatory element. Indicate the end date of the period for which samples were taken


e_Methodology:
This is a mandatory element. Use the unit of measurement for the parmeter as listed in the fixed values list.


e_Definition:
Number of samples taken within the whole measurement period.

e_Methodology:
This is a mandatory element.
The total number of the samples taken in the whole measurement period.


e_Definition:
Average(mean) annual concentration of NO3 for the measurement period.

e_Methodology:
This is a mandatory element.
The Average(mean)concentration of NO3 sampled during a period of one or more years for the measurement period.


e_Definition:
Maximum concentration of NO3 for the measurement period

e_Methodology:
This is a mandatory element.
The maximum concentration of NO3 in mg/L measured in the measurement period.


e_Definition:
Trends between the current and previous reporting periods based on annual average(mean) values.

e_Methodology:
The difference between the average NO3 concentration of the current reporting period and the average of the previous reporting period (avg. current RP â avg. previous RP)in mg/L. 
Trends can only be calculated for monitoring stations at the same location (X,Y) and measurements at the same depth.


e_Definition:
National name of river, lake, transitional, coastal or marine water in which the monitoring station is located.

e_Methodology:
Indicate the national name of river, lake, transitional, coastal or marine water in which the monitoring station is located.


e_Definition:
Altitude of station in metres above sea level.

e_Methodology:
For lakes, the altitude of the lake should be provided.


e_Definition:
Average (mean)  winter concentration of NO3 for the measurement period.

e_Methodology:
This is a mandatory element. Average value for NO3 sampled over the winter periods October to March.


e_Definition:
Trend between the current and previous reporting period based on winter average(mean) values.

e_Methodology:
The difference between the average winter NO3 concentration of the current reporting period and the average of the previous reporting period. (avg. winter current reporting period â avg. winter previous reporting period).
Trends can only be calculated for monitoring stations at the same location (X,Y) and measurements at the same depth.


e_Definition:
Name of nutrient or other parameter determinand, as defined in the "Name of parameter" codelist.

e_Methodology:
This is a mandatory element. 
For name of nutrient or other parameter determinand use list of fixed values.


e_Definition:
Average (mean) concentration of the nutrient or other parameter determinand for the measurement period.
For Chl-a summer average has to be indicated

e_Methodology:
This is a mandatory element.
For the measured parameter an average (mean) value has to be calculated. If the parameter is Chl-a the summer average has to be indicated.


e_Definition:
Name for trophic status as defined in the "Trophic state" codelist.

e_Methodology:
This is a mandatory element. To indicate the trophic status of the surface water use the list of fixed values.


# DEFINITIONS_TABLES_DO_NOT_MODIFY

tbl_Name:
9a. Risk areas WTA - GIS boundaries (optional)

tbl_Definition:
Geographical data set of the Risk areas if MS have Whole Territory Approach (WTA)

tbl_Methodology:
This is a optional table.
MS that have a Whole Territory Approach and that want to indicate where the Risk areas are situated between their country boundaries can use this GIS table.

tbl_ShortDescription:
Geographical information on Risk areas for countries with Whole Territory Approach (WTA)


tbl_Definition:
Information on legal acts if MS have whole territory approach

tbl_Methodology:
This table has to be filled in by Member States that apply a whole territory approach according to article 3 §5 of the directive, because they are exempted to supply information on specific vulnerable zones. In this table information on legal acts concerning the whole territory approach can be delivered. Geographical information is not needed because the boundaries will be the same as the country boundaries

tbl_ShortDescription:
Information on legal acts if MS have whole territory approach


tbl_Name:
7. Designated Nitrate Vulnerable Zones GIS boundaries

tbl_Definition:
Attribute data referring to geographical data sets of NVZ areas are requested to update the NVZ database hosted by JRC.

tbl_Methodology:
Digital geographical data sets and their geographical co-ordinates should be provided in ETRS89 (European Terrestrial Reference System 89) format.
The geographical data sets for the creation and updating of the NVZ database should be submitted in .shp or .e00 formats.
Metadata (information about a data file/dataset) in ISO19115 standard should accompany any geographically related deliverable to the EEA. See chapter 9 of the EEA_GISguide_v2.doc (http://eionet.europa.eu/gis/)

Member States that apply a whole territory approach according to article 3 §5 of the directive are exempted to identify specific vulnerable zones.

tbl_ShortDescription:
Geographical information on the Designated Nitrate Vulnerable Zones


tbl_Name:
8. Potential Vulnerable Zones GIS boundaries

tbl_Definition:
Attribute data referring to geographical data sets of potential Vulnerable Zones are requested to update the NVZ database hosted by JRC

tbl_Methodology:
Digital geographical data sets and their geographical co-ordinates should be provided in ETRS89 (European Terrestrial Reference System 89) format.
The geographical data sets for the creation and updating of the NVZ database should be submitted in .shp or .e00 formats.
Member States that apply a whole territory approach according to article 3 §5 of the directive are exempted to identify specific vulnerable zones.

tbl_ShortDescription:
Geographical information on Potential Vulnerable Zones


tbl_Name:
1. List of groundwater monitoring stations

tbl_Definition:
Detailed information on the characteristics of the groundwater monitoring stations

tbl_Methodology:
The data requested for Nitrates Directive should be derived from existing national and/or regional monitoring networks within each Member State.
One table should be used for all groundwater monitoring stations. The combination of the elements CountryCode,  NationalStationCode and StationType must create a unique record in the table. No duplicate records should exist with this combination.
If this station has been used for the reporting to WFD or Waterbase and all the characteristics are already known from these databases, properties like the "National Station Name" have not to be filled in.

tbl_ShortDescription:
Information on the groundwater monitoring stations used to report water quality data under the Nitrates Directive.


tbl_Definition:
NO3 concentrations measured in each groundwater monitoring station.

tbl_Methodology:
Data on groundwater monitoring stations are collected for each reporting period (4 year period). For each station the average (mean) annual concentration for NO3 over one or more years and the maximum value for NO3 have to be reported. If the same station (at same depth) has been used for monitoring in the previous period, a trend value (average current reporting period - average previous (3rd) reporting period) has to be indicated.
The combination of the elements CountryCode, NationalStationCode and StationType must create a unique record in the table. No duplicate records should exist with this combination.

tbl_ShortDescription:
NO3 values for each groundwater monitoring station


tbl_Definition:
Detailed information on the properties of the surface water monitoring stations.

tbl_Methodology:
The data requested for Nitrates Directive should be derived from existing national and/or regional monitoring networks within each Member State. 
This table should be used for all surface water monitoring stations. Discrimination between the surface water entities (river, lake, etc.) can be made by indicating the "Station type". The combination of the elements CountryCode, NationalStationCode and StationType must create a unique record in the table. No duplicate records should exist with this combination.
If this station has been used for the reporting to WFD or Waterbase and all the characteristics are already known from these databases, properties like the national Station name have not to be filled in.

tbl_ShortDescription:
Information on the surface water monitoring stations used to report water quality data under the Nitrates Directive.


tbl_Definition:
NO3 concentrations measured in each surface water monitoring station.

tbl_Methodology:
Data on surface water monitoring stations are collected for each reporting period (4 year period). For each station the average (mean) annual and winter concentrations for NO3 over one or more years and the maximum value for NO3 in this period have to be reported. If the same station has been used for monitoring in the previous period, a trend value (average current reporting period - average previous (3rd) reporting period) has to be indicated. This table should be used for all surface water monitoring stations. Discrimination between the surface water entities (river, lake, etc.) can be made by indicating the "Station type"
The combination of the elements CountryCode, NationalStationCode and StationType must create a unique record in the table.

tbl_ShortDescription:
NO3 values for each surface water monitoring station


tbl_Name:
5. Eutrophication parameters in surface water

tbl_Definition:
Eutrophication parameters measured in each surface water monitoring station.

tbl_Methodology:
Different criteria to evaluate the eutrophication status exist in the various EU-Member States. Member States are requested to report on methodology and on those eutrophication parameters which were used to do the assessment. Reporting has to be done separately for rivers, lakes and coastal waters. 
This table should be used for all surface water monitoring stations and all measured parameters. Discrimination between the surface water entities (river, lake, etc.) can be made by indicating the "Station type", discrimination between the parameters by entering the "Name of parameter". The combination of the elements CountryCode, NationalStationCode and StationType must create a unique record in the table. No duplicate records should exist with this combination.


tbl_Definition:
Trophic state in each surface water monitoring station.

tbl_Methodology:
Different criteria to evaluate the eutrophication status exist in different EU-Member States. Member States are requested to report on methodology and to qualify eutrophication separately for rivers, lakes and coastal waters according to the fixed values list.
This table should be used for all surface water monitoring stations. Discrimination between the surface water entities (river, lake, etc.) can be made by indicating the "Station type". The combination of the elements CountryCode, NationalStationCode and StationType must create a unique record in the table. No duplicate records should exist with this combination.

tbl_ShortDescription:
Trophic state in each surface water monitoring station.


