Nationally designated areas: Data tables metadata,,,, List of designation boundaries by country:,Table contains list of digital boundaries of protected areas not defined as sites. Provides information on resolution of source material from which the boundary has been derived. Instructs EEA regarding dissemination of boundaries. ,,, Item,Definition,Note,Data type,Key DESIG_ABBR,National designation type code, ,nvarchar(5),yes ISO3,Country ISO code , ,nvarchar(3),yes PARENT_ISO,ISO 3 characters country code , ,nvarchar(3),yes CDDA_Availability_code,Availability of boundaries ,"00 - Boundaries not available, 01 - Boundaries reported to EEA, 02 - Boundaries under preparation, 03 - Boundaries not relevant for analysis at European scale. Point or line feature. ",nvarchar(2), CDDA_Dissemination_code,Code for instructions to EEA regarding dissemination of geographical data. ,"00 - use dissemination instructions provided in metadata for the spatial dataset, 01 - vector data can be published for this feature, 02 - public dissemination restricted to presence/absence in European raster dataset, 03 - public dissemination restricted to European scale maps, 04 - dissemination to CDDA partner institutions (WCMC and CoE) for their internal use only. Other interested parties should contact national representative, 05 - no dissemination by EEA. Interested parties should contact national representative ",nvarchar(2), CDDA_Resolution_code,"Codes for spatial resolution of dataset from which geographical data for this feature (boundaries, coordinates) has been derived. ","00 - use resolution information provided in metadata for the spatial dataset, 01 - unknown, 02 - less than 1:1 000 000, 03 - between 1:250 000 and 1:1 000 000, 04 - between 1:100 000 and 1:250 000, 05 - greater than 1:100 000 ",nvarchar(2), List of designations by country:,"Table contains list of designations, references to laws as well as number and total area of sites per designation. ",,, Item,Definition,Note,Data type,Key DESIG_ABBR,National designation type code, ,nvarchar(5),yes ISO3,Country ISO code , ,nvarchar(3),yes PARENT_ISO,ISO 3 characters country code , ,nvarchar(3),yes Agency,Name and address of the highest administrative authority responsible for this designation, ,nvarchar(max), Category,National designation type category, ,nvarchar(1), Designate,Title in English, ,nvarchar(100), Law,Reference to the legal text, ,nvarchar(max), Lawreference,Reference to the publication in Official Journal, ,nvarchar(max), Number,Number of sites with that designation from table Sites within CDDA-National,,int(4), Odesignate,Title - original language,,nvarchar(100), Remark,Remarks concerning the designation, ,nvarchar(max), Total_area,Total area of sites with that designation from table Sites within CDDA-National,,decimal(9), National overview of area protected:,Table contains national indicators for amount of national territory that is protected.,,, Item,Definition,Note,Data type,Key Category,National designation type category, ,nvarchar(5),yes ISO3,Country ISO code , ,nvarchar(3),yes PARENT_ISO,ISO 3 characters country code , ,nvarchar(3),yes Major_ecosystem,Major ecosystem, ,nvarchar(12), Methodology_reference_title,Methodology reference title ,Documentation of methodology used if available. ,nvarchar(50), Methodology_reference_url,Methodology reference url,Nature conservation and biodiversity ,nvarchar(max), Methodology_type,Methodology type,How area was calculated. ,nvarchar(2), Publication_title,Publication title,Document or indicator where total area was published if available. ,nvarchar(50), Publication_url,Publication url, ,nvarchar(max), Reference_year,Time reference for area , ,nvarchar(4), Remark,Remark,Optional free text comment ,nvarchar(max), Total_area,Total area protected by designation category.,Areas protected within specified boundaries and areas protected by the designation of a particular habitat should be included if relevant in the national context. Overlapping areas should be excluded from total. ,decimal(9), List of site boundaries by country:,Table contains information whether digital boundaries have been reported for a site reported as tabular data. Provides information on resolution of source material from which the boundary has been derived. Instructs EEA regarding dissemination of boundaries. ,,, Item,Definition,Note,Data type,Key ISO3,Country ISO code , ,nvarchar(3),yes PARENT_ISO,ISO 3 characters country code , ,nvarchar(3),yes SITE_CODE,Unique record identifier for nationally designated areas, ,int(4),yes CDDA_Availability_code,Availability of boundaries ,"00 - Boundaries not available, 01 - Boundaries reported to EEA, 02 - Boundaries under preparation, 03 - Boundaries not relevant for analysis at European scale. Point or line feature. ",nvarchar(2), CDDA_Dissemination_code,Code for instructions to EEA regarding dissemination of geographical data. ,"00 - use dissemination instructions provided in metadata for the spatial dataset, 01 - vector data can be published for this feature, 02 - public dissemination restricted to presence/absence in European raster dataset, 03 - public dissemination restricted to European scale maps, 04 - dissemination to CDDA partner institutions (WCMC and CoE) for their internal use only. Other interested parties should contact national representative, 05 - no dissemination by EEA. Interested parties should contact national representative ",nvarchar(2), CDDA_Resolution_code,"Codes for spatial resolution of dataset from which geographical data for this feature (boundaries, coordinates) has been derived. ","00 - use resolution information provided in metadata for the spatial dataset, 01 - unknown, 02 - less than 1:1 000 000, 03 - between 1:250 000 and 1:1 000 000, 04 - between 1:100 000 and 1:250 000, 05 - greater than 1:100 000 ",nvarchar(2), Sites data table:,"Table contains main information (name, location, area, IUCN category etc) of each individual designated area at national level. ",,, Item,Definition,Note,Data type,Key DESIG_ABBR,National designation type code, ,nvarchar(5),yes ISO3,Country ISO code , ,nvarchar(3),yes PARENT_ISO,ISO 3 characters country code , ,nvarchar(3),yes SITE_CODE,Unique record identifier for nationally designated areas, ,int(2),yes CDDA_Coordinates_code,Code for derivation of tabular coordinates of sites.,"00 - unknown, 01 - national calculation, 02 - EEA to calculate from reported boundary data ",nvarchar(2), CDDA_Dissemination_code,Code for instructions to EEA regarding dissemination of geographical data. ,"00 - use dissemination instructions provided in metadata for the spatial dataset, 01 - vector data can be published for this feature, 02 - public dissemination restricted to presence/absence in European raster dataset, 03 - public dissemination restricted to European scale maps, 04 - dissemination to CDDA partner institutions (WCMC and CoE) for their internal use only. Other interested parties should contact national representative, 05 - no dissemination by EEA. Interested parties should contact national representative ",nvarchar(2), CDDA_Resolution_code,"Codes for spatial resolution of dataset from which geographical data for this feature (boundaries, coordinates) has been derived. ","00 - use resolution information provided in metadata for the spatial dataset, 01 - unknown, 02 - less than 1:1 000 000, 03 - between 1:250 000 and 1:1 000 000, 04 - between 1:100 000 and 1:250 000, 05 - greater than 1:100 000 ",nvarchar(2), IUCNCAT,IUCN management category , ,nvarchar(4), Last_leg_chng_code,Code of last legal change, ,nvarchar(2), Last_leg_chng_year,Year of last legal change , ,nvarchar(4), LAT,Latitude ,(Y) International Geographical Co-ordinates of the monitoring station in decimal degrees format ,float(8), LON,Longitude decimal degrees , ,float(8), Notes,Remarks about the site record, ,nvarchar(max) NUTS,Administrative Region Code according to the coding system of EUROSTAT, ,nvarchar(5) SITE_AREA,Surface area in hectares (ha), ,float(8) SITE_CODE_NAT,National site code,unique record identifier in the national source database ,nvarchar(20) SITE_NAME,Site name as given in local language., ,nvarchar(120) Year,Year ,"year of aggregation period (aggregated data sets), or year in which sample taken (disaggregated data sets), in format YYYY. Year should be no later than that requested in the last Eionet-Water data request. ",nvarchar(4)