Marine litter watch communities

Data table via SPARQL Published 06 May 2014 Last modified 14 May 2019

Download this dataset

Dataset preview

(Live Query)

num_users num_event num_beaches num_items community_name
"1"^^<http://www.w3.org/2001/XMLSchema#int> "35"^^<http://www.w3.org/2001/XMLSchema#int> "1"^^<http://www.w3.org/2001/XMLSchema#int> "1030"^^<http://www.w3.org/2001/XMLSchema#decimal> "Portuguese Association for Marine Litter - APLM"
"0"^^<http://www.w3.org/2001/XMLSchema#int> "378"^^<http://www.w3.org/2001/XMLSchema#int> "28"^^<http://www.w3.org/2001/XMLSchema#int> "2352"^^<http://www.w3.org/2001/XMLSchema#decimal> "Institute for Water of the Republic of Slovenia"
"2847"^^<http://www.w3.org/2001/XMLSchema#int> "2911"^^<http://www.w3.org/2001/XMLSchema#int> "129"^^<http://www.w3.org/2001/XMLSchema#int> "40714"^^<http://www.w3.org/2001/XMLSchema#decimal> "Independent"
"20"^^<http://www.w3.org/2001/XMLSchema#int> "1531"^^<http://www.w3.org/2001/XMLSchema#int> "93"^^<http://www.w3.org/2001/XMLSchema#int> "19061"^^<http://www.w3.org/2001/XMLSchema#decimal> "Hold Danmark Rent"
"1"^^<http://www.w3.org/2001/XMLSchema#int> "48"^^<http://www.w3.org/2001/XMLSchema#int> "3"^^<http://www.w3.org/2001/XMLSchema#int> "360"^^<http://www.w3.org/2001/XMLSchema#decimal> "ICES Secretariat"
"14"^^<http://www.w3.org/2001/XMLSchema#int> "5832"^^<http://www.w3.org/2001/XMLSchema#int> "303"^^<http://www.w3.org/2001/XMLSchema#int> "236600"^^<http://www.w3.org/2001/XMLSchema#decimal> "Surfrider Foundation Europe"
"1"^^<http://www.w3.org/2001/XMLSchema#int> "0"^^<http://www.w3.org/2001/XMLSchema#int> "0"^^<http://www.w3.org/2001/XMLSchema#int> "" "Let's do it Italy"
"0"^^<http://www.w3.org/2001/XMLSchema#int> "1"^^<http://www.w3.org/2001/XMLSchema#int> "0"^^<http://www.w3.org/2001/XMLSchema#int> "" "b"
"0"^^<http://www.w3.org/2001/XMLSchema#int> "7"^^<http://www.w3.org/2001/XMLSchema#int> "0"^^<http://www.w3.org/2001/XMLSchema#int> "" "Athens Goulandri Natural History Museum"
"0"^^<http://www.w3.org/2001/XMLSchema#int> "1"^^<http://www.w3.org/2001/XMLSchema#int> "0"^^<http://www.w3.org/2001/XMLSchema#int> "" "c"

Received 40 rows in 0.002 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/marine-litter-watch-communities/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



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

PREFIX rdf-schema: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX litterwatch: <http://rdfdata.eionet.europa.eu/litterwatch/ontology/>

SELECT 
count(?username) as ?num_users
count(?event) as ?num_event
count(?beach) as ?num_beaches
sum(?itemcount) as ?num_items
?community_name


WHERE {

 {

   ?user ?p1 <http://rdfdata.eionet.europa.eu/litterwatch/ontology/User> .
   ?user litterwatch:username ?username .
   ?user litterwatch:community ?community .

 } UNION {

   ?event ?p1 <http://rdfdata.eionet.europa.eu/litterwatch/ontology/Event> .
   ?event litterwatch:community ?community .

 } UNION {
   ?survey ?p1 <http://rdfdata.eionet.europa.eu/litterwatch/ontology/Survey> .
   ?survey litterwatch:event ?event .
   ?event litterwatch:beach ?beach .
   ?event litterwatch:community ?community .
   
 } UNION {

   ?event ?p1 <http://rdfdata.eionet.europa.eu/litterwatch/ontology/Event> . 
   ?survey litterwatch:event ?event . 
   ?event litterwatch:community ?community .
   ?item litterwatch:survey ?survey . 
   ?item litterwatch:itemcount ?itemcount . 

 }
 ?community litterwatch:name ?community_name .

 }


GROUP BY ?community_name

Error when running query:

Query timeout. unknown url type: timed out


Document Actions