View table

There are 0 QA scripts and 4 conversion scripts registered for this table.
Link to the schema page on XMLCONV
Identifier DesignatedArea
Short name Designated area
Dataset CDDA
Reference URL http://dd.eionet.europa.eu/datasets/latest/CDDA/tables/DesignatedArea
Name Designated area
Short Description The table contains information about designated sites and designated boundaries at national level.
Definition The designated areas table includes designated sites as well as designated boundaries,
see the Designated boundaries concept note in the CDDA reference portal http://cdr.eionet.europa.eu/help/cdda/.

The unique CDDA ID is identical to the WDPA ID and reused in the World Database on Protected Areas.
Methodology for obtaining data An appointed national Reportnet user (NFP, NRC biodivdata or CDDA reporter) can allocate codes (CDDA ID) for new designated areas on the Site code allocation web page (http://dd.eionet.europa.eu/services/siteCodes).

The CDDA ID and the INSPIRE ID are both unique keys for the tabular and the spatial data.

It is recommended that the Local ID of the composite INSPIRE ID reuses the CDDA ID value.

On Reportnet 3 platform the field containedBy is redundant and it is no longer mandatory to provide.

Elements

Element name Datatype Element type
* CDDA ID (cddaId)  (PK) integer Quantitative
National site code (nationalId) string Quantitative
* INSPIRE Protected Site identifier Local ID (PSlocalId) string Quantitative
* INSPIRE Protected Site identifier Namespace (PSnamespace) string Quantitative
INSPIRE Protected Site identifier Version ID (PSversionId) string Quantitative
* Designated area type (designatedAreaType) reference Vocabulary
* Country code (cddaCountryCode) C reference Vocabulary
* Region code (cddaRegionCode) C reference Vocabulary
* Designation type code (designationTypeCode) C reference Vocabulary
* IUCN category (iucnCategory) reference Vocabulary
* Site area (siteArea) decimal Quantitative
* Major ecosystem type (majorEcosystemType) reference Vocabulary
Percentage of Marine area (marineAreaPercentage) float Quantitative
* Spatial data dissemination instruction code (spatialDataDissemination) reference Vocabulary
Spatial resolution code (spatialResolutionCode) reference Vocabulary
EIONET change date (eionetChangeDate) date Quantitative
EIONET change type (eionetChangeType) string Fixed values
EIONET edited by (eionetEditedBy) string Quantitative
EIONET institute (eionetInstitute) string Quantitative
Remark (remark) string Quantitative
* Site ended (siteEnded) boolean Fixed values
Contained by (containedBy) integer Quantitative
(an asterisk in front of element name indicates that the element is mandatory in this table)
(the C sign marks a common element)