Write to us
Call us
List of designations by country:
Table contains list of designations, references to laws as well as number and total area of sites per designation.
| Field name | Field Definition | Note | Data type | Primary key |
|---|---|---|---|---|
| Number | Number of sites with that designation from table Sites within CDDA-National | int(4) | 0 | |
| Total_area | Total area of sites with that designation from table Sites within CDDA-National | decimal(9) | 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 | |
| Category | National designation type category | nvarchar(1) | 0 | |
| Odesignate | Title - original language | nvarchar(100) | 0 | |
| Designate | Title in English | nvarchar(100) | 0 | |
| Law | Reference to the legal text | nvarchar(max) | 0 | |
| Lawreference | Reference to the publication in Official Journal | nvarchar(max) | 0 | |
| Agency | Name and address of the highest administrative authority responsible for this designation | nvarchar(max) | 0 | |
| Remark | Remarks concerning the designation | nvarchar(max) | 0 |
Green tips
Document Actions
Share with others