Write to us
Call us
Sites data table:
Table contains main information (name, location, area, IUCN category etc) of each individual designated area at national level.
| Field name | Field Definition | Note | Data type | Primary key |
|---|---|---|---|---|
| SITE_CODE | Unique record identifier for nationally designated areas | int(2) | -1 | |
| SITE_AREA | Surface area in hectares (ha) | float(8) | 0 | |
| LAT | Latitude | (Y) International Geographical Co-ordinates of the monitoring station in decimal degrees format | float(8) | 0 |
| LON | Longitude decimal degrees | float(8) | 0 | |
| SITE_CODE_NAT | National site code | unique record identifier in the national source database | nvarchar(20) | 0 |
| PARENT_ISO | ISO 3 characters country code | nvarchar(3) | -1 | |
| ISO3 | Country ISO code | nvarchar(3) | -1 | |
| DESIG_ABBR | National designation type code | nvarchar(5) | -1 | |
| SITE_NAME | Site name as given in local language. | nvarchar(120) | 0 | |
| IUCNCAT | IUCN management category | nvarchar(4) | 0 | |
| 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) | 0 |
| Notes | Remarks about the site record | nvarchar(max) | 0 | |
| NUTS | Administrative Region Code according to the coding system of EUROSTAT | nvarchar(5) | 0 | |
| Year | Year | nvarchar(4) | 0 | |
| Last_leg_chng_year | Year of last legal change | nvarchar(4) | 0 | |
| Last_leg_chng_code | Code of last legal change | nvarchar(2) | 0 | |
| 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) | 0 |
| 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) | 0 |
Green tips
Document Actions
Share with others