next
previous
items

Data table via SPARQL

Bathing water data - region data

Data table via SPARQL Published 22 May 2014 Last modified 19 Apr 2016

Download this dataset

Dataset preview

(Live Query)

year count quality geo
"2000"^^<http://www.w3.org/2001/XMLSchema#int> "32"^^<http://www.w3.org/2001/XMLSchema#int> "Compliant to mandatory values / Good or Sufficient" "Belgium - VLAAMS GEWEST"
"2001"^^<http://www.w3.org/2001/XMLSchema#int> "26"^^<http://www.w3.org/2001/XMLSchema#int> "Compliant to mandatory values / Good or Sufficient" "Belgium - VLAAMS GEWEST"
"2002"^^<http://www.w3.org/2001/XMLSchema#int> "29"^^<http://www.w3.org/2001/XMLSchema#int> "Compliant to mandatory values / Good or Sufficient" "Belgium - VLAAMS GEWEST"
"2003"^^<http://www.w3.org/2001/XMLSchema#int> "32"^^<http://www.w3.org/2001/XMLSchema#int> "Compliant to mandatory values / Good or Sufficient" "Belgium - VLAAMS GEWEST"
"2004"^^<http://www.w3.org/2001/XMLSchema#int> "27"^^<http://www.w3.org/2001/XMLSchema#int> "Compliant to mandatory values / Good or Sufficient" "Belgium - VLAAMS GEWEST"
"2005"^^<http://www.w3.org/2001/XMLSchema#int> "30"^^<http://www.w3.org/2001/XMLSchema#int> "Compliant to mandatory values / Good or Sufficient" "Belgium - VLAAMS GEWEST"
"2006"^^<http://www.w3.org/2001/XMLSchema#int> "28"^^<http://www.w3.org/2001/XMLSchema#int> "Compliant to mandatory values / Good or Sufficient" "Belgium - VLAAMS GEWEST"
"2007"^^<http://www.w3.org/2001/XMLSchema#int> "18"^^<http://www.w3.org/2001/XMLSchema#int> "Compliant to mandatory values / Good or Sufficient" "Belgium - VLAAMS GEWEST"
"2008"^^<http://www.w3.org/2001/XMLSchema#int> "33"^^<http://www.w3.org/2001/XMLSchema#int> "Compliant to mandatory values / Good or Sufficient" "Belgium - VLAAMS GEWEST"
"2009"^^<http://www.w3.org/2001/XMLSchema#int> "31"^^<http://www.w3.org/2001/XMLSchema#int> "Compliant to guide values / Excellent" "Belgium - VLAAMS GEWEST"

Received 3204 rows in 0.052 seconds.


https://eea.europa.eu./data-and-maps/daviz/sds/bathing-water-data-region-data/daviz.json

For system integrators

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



semantic.eea.europa.eu/sparql

PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#> 
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#> 
PREFIX skos: <http://www.w3.org/2004/02/skos/core#> 
PREFIX bwd: <http://bwd.eea.europa.eu/schema.rdf#>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdf-schema: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX measure: <http://purl.org/linked-data/sdmx/2009/measure#>
PREFIX dimension: <http://purl.org/linked-data/sdmx/2009/dimension#> 
PREFIX compliance: <http://bwd.eea.europa.eu/resource/compliance/>

SELECT
?year
count(?obsvalue) as ?count
?quality
bif:concat(?country, ' - ', ?region) as ?geo

WHERE {
{  
  GRAPH <http://bwd.eea.europa.eu/bwd.rdf.gz> 
  {
  ?station a bwd:Station .
  ?station bwd:seawater true .
  ?station bwd:inRegion ?region_code .
  ?region_code rdf-schema:label ?region .
  ?station bwd:province ?province_code .
  ?province_code rdf-schema:label ?province . 
  ?station bwd:country ?country_code .
  ?country_code rdf-schema:label ?country .
  ?obs dimension:timePeriod ?year .
  ?obs dimension:refArea ?station . 
  ?obs measure:obsValue ?obsvalue .
  ?obsvalue rdfs:label ?quality . 

  FILTER(?year >= 2000 && ?obsvalue != compliance:NF && ?obsvalue != compliance:NS)  
  } 
}


}
GROUP BY ?year ?quality ?region ?country


Permalinks

Document Actions