next
previous
items

Data

Nationally designated areas (CDDA)

Data
Prod-ID: DAT-24-en
Created 07 Jun 2004 Published 07 Jun 2004 Last modified 28 Jun 2016
9 min read
This is an old version, kept for reference only.

 Go to latest version
This page was archived on 31 Oct 2014 with reason: Other (New version data-and-maps/data/nationally-designated-areas-national-cdda-9 was published)
The dataset contains the geographic location and size of the nationally designated areas

European data

Site habitats table

The table contains data on habitats and habitat cover within the site boundary.

[+] Show table definition (records:   68)

Site_code Site code unique record identifier. Int(4) -1
Cover The percentage of the site covered by this habitat class float(8) 0
Eunis hab EUNIS habitat classification the unique code of the EUNIS habitat classification up to the fourth level. nvarchar(5) -1
Nationally designated areas

The table contains informations on the individual designated areas at national level.

[+] Show table definition (records:   51289)

Altitude_max Altitude maximum the maximum altitude (meters) above sea level within the site boundaries. int(4) 0
Lat Latitude geographical coordinate in decimal degrees. float(8) 0
Lon Longitude geographical coordinate in decimal degrees. float(8) 0
Site_code Site code unique record identifier for nationally designated areas int(4) -1
Size Size area in ha int(4) 0
Altitude_min Altitude minimum the minimum altitude (meters) above sea level within the site boundaries. int(4) 0
Year Year year of establishment. The year the site was created under the designation concerned. nvarchar(4) 0
Lat_ns Latitude North/South nvarchar(1) 0
Lon_ew Longitude East/West nvarchar(1) 0
Desig_abbr National designation type code nvarchar(5) -1
Areaname Site name site name as given in local language. nvarchar(120) 0
Nuts NUTS code administrative Region Code according to the coding system of Eurostat. nvarchar(5) 0
Site_code_nat National site code unique record identifier in the national source database nvarchar(12) 0
Parent_iso Parent ISO code in most countries the Iso3 and Parent_iso codes are identical. For countries, which have so called DOM/TOMs or any kind of over seas territories under their jurisdiction, the Iso3 country code may be different from the parent country code. nvarchar(3) 0
Iso3 ISO3 code ISO 3 characters country code nvarchar(3) 0
Londeg Longitude degrees smallint(2) 0
Lonmin Longitude minutes smallint(2) 0
Lonsec Longitude seconds smallint(2) 0
Latdeg Latitude degrees smallint(2) 0
Latmin Latitude minutes smallint(2) 0
Latsec Latitude seconds smallint(2) 0
IUCNCAT IUCN category nvarchar(4) -1
National designation type category look-up table

[+] Show table definition (records:   3)

Category National designation type category nvarchar(1) -1
Definition IUCN category definition nvarchar(200) 0
Site relations lookup table

[+] Show table definition (records:   6)

Rel_code Relationship code nvarchar(1) -1
Relationship Relationship description nvarchar(200) 0
Site relations table

This table allows to indicate neighbouring sites or sites belonging to different designation types which overlap or neighbour each other.

[+] Show table definition (records:   1075)

Sitecode Site code unique record identifier for nationally designated areas int(4) -1
Rsitecode Related site code the unique record identifier of the related site. int(4) 0
Overlap Overlap the percentage of the described site that is overlapping with the other site. int(4) 0
Rel_code Relationship code the type of relationship between two sites. nvarchar(1) -1
IUCN category look-up table

[+] Show table definition (records:   7)

Definition IUCN category definition ntext(16) 0
Iucncat IUCN category nvarchar(4) -1
Title IUCN category title nvarchar(250) 0
List of designations by country

The table contains the list of designations and references to laws.

[+] Show table definition (records:   845)

Law Reference to the legal text ntext(16) 0
Lawreference Reference to the publication in Official Journal ntext(16) 0
Agency Address of the administrative authority responsible for this designation ntext(16) 0
Odesignate Title in original language nvarchar(100) 0
Designate Title in English nvarchar(100) 0
Title - french Title in French nvarchar(255) 0
Iso3 ISO 3 caracters country code nvarchar(3) 0
Desig_abbr National designation type code nvarchar(5) -1
Category National designation type category nvarchar(1) -1
EUNIS habitat classification

[+] Show table definition (records:   1659)

Eunis hab EUNIS habitat classification nvarchar(5) -1
Hab level Habitat level nvarchar(255) 0
Scientific name Scientific name of the habitat nvarchar(255) 0

Additional information

Metadata

information.png Reporting obligations (ROD)
information.png Rights:
EEA standard re-use policy: unless otherwise indicated, re-use of content on the EEA website for commercial or non-commercial purposes is permitted free of charge, provided that the source is acknowledged (https://www.eea.europa.eu/legal/copyright). Copyright holder: European Environment Agency (EEA).
information.png Data sources

European Topic Centre on Nature Protection and Biodiversity. Date of delivery: 04/06/2004.

information.png Owners:
European Environment Agency (EEA)
information.png Processors:
European Topic Centre on Biological Diversity (ETC/BD)

Additional information

The inventory of nationally designated areas began under the CORINE programe. It is now maintained for EEA by the European Topic Centre on Nature Protection and Biodiversity and is being updated through EIONET.

 

Permalinks

Older versions

Geographic coverage

For references, please go to https://www.eea.europa.eu/data-and-maps/data/nationally-designated-areas-cdda or scan the QR code.

PDF generated on 24 Oct 2020, 05:28 AM

EEA Page URL QR

Topics

Document Actions
The EEA is an agency of the European Union

Engineered by: EEA Web Team

Software updated on 14 October 2020 16:20 from version 20.10.7

Software version: EEA Plone KGS 20.10.13

Code for developers

Systems Status

Legal notice

Creative commons license

CMS login