Data table via SPARQL

National designation type codes

Data table via SPARQL Published 31 Oct 2013 Last modified 19 Apr 2016

This table contains codes for all of Europe. For further information on CDDA Designations, see http://dd.eionet.europa.eu/dstable.jsp?mode=view&table_idf=designations&pns=11. The national designation codes are maintained by the EIONET National Reference Centres (NRCs), see http://eea.eionet.europa.eu/Public/irc/eionet-circle/Home/central_dir_admin?fn=roles&v=eionet-nrc-nature-mc&rd=1&af=0&ud=1&od=1.

Data visualisations

Menu

Download this dataset

Formats suitable for human consumption

HTML CSV TSV

Formats suitable for machine-to-machine communication

JSON Exhibit JSON XML XML with Schema

Dataset preview

(Live Query)

country	iso3	desig_abbr	category	Designate	Odesignate	CDDA_sites	Law	Lawreference	Agency	Number	TotalArea	remark
"Albania"	"ALB"	"AL00"	""	"No Protection Status"@en	"No Protection Status"	"FALSE"	""	""	""	"0"^^<http://www.w3.org/2001/XMLSchema#int>	"0"	""
"Albania"	"ALB"	"AL01"	"A"	"National Park (category II)"@en	"Park Kombetar"	"TRUE"	"Ligji \"Per Zonat e Mbrojtura\",Nr. 8906, date 06.06.2002, art.4"	"Fletore Zyrtare Nr.29, published 26.06.2002"	"Ministry of Environment, Forests and Water Administration"	"16"^^<http://www.w3.org/2001/XMLSchema#int>	"221316.1"	"Due to the institutional changes of November 2005 the Protected Areas Administration is now under the Ministry of Environment, Forest and water Administration"
"Albania"	"ALB"	"AL02"	"A"	"Strict Nature Reserve (category I)"@en	"Rezerve Strikte Natyrore"	"TRUE"	"Ligji \"Per Zonat e Mbrojtura\",Nr. 8906, date 06.06.2002, art.4"	"Fletore Zyrtare Nr.29, published 26.06.2002"	"Ministry of Environment, Forests and Water Administration"	"2"^^<http://www.w3.org/2001/XMLSchema#int>	"4800"	"Due to the institutional changes of November 2005 the Protected Areas Administration is now under the Ministry of Environment, Forest and water Administration"
"Albania"	"ALB"	"AL03"	"A"	"Managed Nature Reserve (category IV IUCN)"@en	"Rezerve Natyrore e Menaxhuar"	"TRUE"	"Ligji \"Per Zonat e Mbrojtura\",Nr. 8906, date 06.06.2002, art.4"	"Fletore Zyrtare Nr.29, published 26.06.2002"	"Ministry of Environment, Forests and Water Administration"	"20"^^<http://www.w3.org/2001/XMLSchema#int>	"40888.9"	"Due to the institutional changes of November 2005 the Protected Areas Administration is now under the Ministry of Environment, Forest and water Administration"
"Albania"	"ALB"	"AL05"	"A"	"Protected Landscape (category V IUCN)"@en	"Pejsazh i Mbrojtur"	"TRUE"	"Ligji \"Per Zonat e Mbrojtura\",Nr. 8906, date 06.06.2002, art.4"	"Fletore Zyrtare Nr.29, published 26.06.2002"	"Ministry of Environment, Forests and Water Administration"	"4"^^<http://www.w3.org/2001/XMLSchema#int>	"72837.4"	"Due to the institutional changes of November 2005 the Protected Areas Administration is now under the Ministry of Environment, Forest and water Administration"
"Albania"	"ALB"	"AL06"	"A"	"Nature Monument (Category II IUCN)"@en	"Monument Natyre"	"TRUE"	"Ligji \"Per Zonat e Mbrojtura\",Nr. 8906, date 06.06.2002,art.4"	"Fletore Zyrtare Nr.29, published 26.06.2002"	"Ministry of Environment, Forests and Water Administration"	"749"^^<http://www.w3.org/2001/XMLSchema#int>	"8193.47"	"Due to the institutional changes of November 2005 the Protected Areas Administration is now under the Ministry of Environment, Forest and water Administration"
"Albania"	"ALB"	"AL09"	"A"	"Resource Reserve (category VI)"@en	"Rezerve e Burimeve te Menaxhuara"	"TRUE"	"Ligji \"Per Zonat e Mbrojtura\",Nr. 8906, date 06.06.2002, art.4"	"Fletore Zyrtare Nr.29, published 26.06.2002"	"Ministry of Environment, Forests and Water Administration"	"4"^^<http://www.w3.org/2001/XMLSchema#int>	"18245"	"Due to the institutional changes of November 2005 the Protected Areas Administration is now under the Ministry of Environment, Forest and water Administration"
"Albania"	"ALB"	"AL99"	""	"Others"@en	"Other"	"FALSE"	""	""	""	"0"^^<http://www.w3.org/2001/XMLSchema#int>	"0"	""
"Austria"	"AUT"	"AT01"	"A"	"National Park"@en	"Nationalpark"	"TRUE"	"L1 (Nationalpark)\nGesetz vom 28. November 1988 \u00fcber den Nationalpark Neusiedlersee-Seewinkel,\nK\u00e4rntner Nationalparkgesetz,\nN\u00d6 Nationalparkgesetz vom 28. M\u00e4rz 1996,\nLandesgesetz vom 5. Dezember 1996 \u00fcber die Errichtung und den Betrieb des Nationalparks \u201eO\u00d6 Kalkalpen\u201c,\nSalzburger Nationalparkgesetz,\nTiroler Nationalparkgesetz,\nGesetz mit dem das Wiener Naturschutzgesetz erlassen und das Wiener Umweltschutzgesetz, LGBl. F\u00fcr Wien Nr.25/1993 i.d.F. LGBl. F\u00fcr Wien Nr.36/1996, das Wiener Baumschutzgesetz, LGBl. F\u00fcr Wien Nr. 27/1974 i.d.F. LGBl. F\u00fcr Wien Nr. 54/1996, sowie das Wiener Nationalparkgesetz, LGBl. F\u00fcr Wien Nr. 37/1996, ge\u00e4ndert werden,"	"LGBl. Burgenland 27/1991 \u00a7 44, 28/1993, LGBl. K\u00e4rnten 55/1983, LGBl. Nieder\u00f6sterreich 26/1996, 3/1977 \u00a7 8a, LGBl. Ober\u00f6sterreich 20/1997, LGBl. Salzburg 1/1993 \u00a7 21, LGBl. Steiermark 65/1976 \u00a7 9, LGBl. Tirol 103/1991 \u00a7 14, LGBl. Wien 45/1998 \u00a7 21, 37/1996"	"A1 (Nationalparks)\nAmt der Burgenl\u00e4ndischen Landesregierung\nNatur- und Landschaftsschutz\nEuropaplatz 1\n7000 Eisenstadt\n\nAmt der K\u00e4rntner Landesregierung\nAbt. 20 Landesplanung\nWulfengasse 15\n9020 Klagenfurt\n\nAmt der Nieder\u00f6sterreichischen Landesregierung\nNaturschutz\nLandhausplatz 1\n3109 St. P\u00f6lten\n\nAmt der Ober\u00f6sterreichischen Landesregierung\nNaturschutz\nPromenadegasse 33\n4020 Linz\n\nAmt der Salzburger Landesregierung\nAbt. Naturschutz\nFriedensstra\u00dfe 1\n5020 Salzburg\n\nAmt der Tiroler Landesregierung\nUmweltschutz\nEduard Walln\u00f6fer Platz 2\n6020 Innsbruck\n\nAmt der Wiener Landesregierung\nMA22 Umweltschutz\nEbendorferstra\u00dfe 4\n1010 Wien"	"9"^^<http://www.w3.org/2001/XMLSchema#int>	"235608.87401"	""
"Austria"	"AUT"	"AT02"	"A"	"Nature Park"@en	"Naturpark"	"TRUE"	"L2 (Naturpark)\nGesetz vom November 1990 \u00fcber den Schutz und die Pflege der Natur und Landschaft im Burgenland, \nK\u00e4rntner Naturschutzgesetz,\nNieder\u00f6sterreichisches Naturschutzgesetz, \nKundmachung der Landesregierung vom 24. April 1995 \u00fcber die Wiederverlautbarung des O\u00d6 Natur- und Landschaftpflegegesetzes 1982,\nSteierm\u00e4rkisches Naturschutzgesetz,\nTiroler Naturschutzgesetz 1997,"	"LGBl. Burgenland 27/1991 \u00a7 25, LGBl. K\u00e4rnten 44/2000 \u00a7 26, LGBl. Nieder\u00f6sterreich 3/1977 \u00a7 8, LGBl. Ober\u00f6sterreich 37/1995 \u00a7 9, LGBl. Salzburg 1/1993 \u00a7 22, LGBl. Steiermark 65/1976 \u00a7 8, LGBl. Tirol 33/1997 \u00a7 12"	"A2 (Naturpark)\nAmt der Burgenl\u00e4ndischen Landesregierung\nNatur- und Landschaftsschutz\nEuropaplatz 1\n7000 Eisenstadt\n\nAmt der K\u00e4rntner Landesregierung\nAbt. 20 Landesplanung\nWulfengasse 15\n9020 Klagenfurt\n\nAmt der Nieder\u00f6sterreichischen Landesregierung\nNaturschutz\nLandhausplatz 1\n3109 St. P\u00f6lten\n\nAmt der Ober\u00f6sterreichischen Landesregierung\nNaturschutz\nPromenadegasse 33\n4020 Linz\n\nAmt der Salzburger Landesregierung\nAbt. Naturschutz\nFriedensstra\u00dfe 1\n5020 Salzburg\n\nAmt der Steierm\u00e4rkischen Landesregierung\nNaturschutz\nKarmeliterplatz 1\n8011 Graz\n\nAmt der Tiroler Landesregierung\nUmweltschutz\nEduard Walln\u00f6fer Platz 2\n6020 Innsbruck"	"49"^^<http://www.w3.org/2001/XMLSchema#int>	"467934.65308"	""

Received 613 rows in 0.029 seconds.

JSON Url:
https://www.eea.europa.eu/data-and-maps/daviz/sds/designation-types-table-from-cdda/daviz.json

For system integrators

Linked Data query (SPARQL)

The following info can be used by a system developer / database administrator in order to retrieve this dataset programmatically over the web using a SPARQL client.

Are you new to Linked Data technology? visit http://linkeddata.org

SPARQL Endpoint:
http://semantic.eea.europa.eu/sparql

SPARQL Query:


        PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX eunis-schema: <http://eunis.eea.europa.eu/rdf/schema.rdf#>
PREFIX eunis-sites-rdfs: <http://eunis.eea.europa.eu/rdf/sites-schema.rdf#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#> 

SELECT DISTINCT
?country
?iso3
?code as ?desig_abbr
?category
?Designate
?Odesignate
bif:either(?CDDA_sites = 0, "FALSE", "TRUE") as ?CDDA_sites
?Law
?Lawreference
?Agency
count(?sites) as ?Number
?TotalArea
?remark

WHERE {
 ?designation ?p1 eunis-schema:Designation .
 OPTIONAL { ?designation eunis-schema:code ?code } .
 OPTIONAL { ?designation eunis-schema:nationalCategory ?category } .
 OPTIONAL { ?designation eunis-schema:geoCoverage ?geoCoverage } .
 OPTIONAL { ?designation eunis-schema:description ?Odesignate }  .
FILTER(LANG(?Odesignate) != "en")

 OPTIONAL { ?designation eunis-schema:description ?Designate } .
FILTER(LANG(?Designate) = "en")

 OPTIONAL { ?geoCoverage rdfs:label ?country } .
 OPTIONAL { ?designation eunis-schema:nationalLaw ?Law } .
 OPTIONAL { ?designation eunis-schema:nationalLawReference ?Lawreference } .
 OPTIONAL { ?designation eunis-schema:nationalLawAgency ?Agency } .
 OPTIONAL { ?designation eunis-schema:totalArea ?TotalArea } .
 OPTIONAL { ?designation eunis-schema:hasCDDASites ?CDDA_sites } .
 OPTIONAL { ?designation eunis-schema:remark ?remark } .
 OPTIONAL { ?sites eunis-sites-rdfs:hasDesignation ?designation } .

 OPTIONAL { ?geoCoverage owl:sameAs ?ugeo .
            ?ugeo a eunis-schema:Country  .
            ?ugeo eunis-schema:iso_3_wcmc ?iso3 }
 } 
group by ?country ?iso3 ?code ?category ?Odesignate ?Designate ?CDDA_sites ?Law ?Lawreference ?Agency ?TotalArea ?remark ?designation
order by ?code