Eionet deliveries 2011

Data table via SPARQL Published 22 Nov 2017 Last modified 26 Mar 2018
31 min read
Topics: ,

Download this dataset

Dataset preview

(Live Query)

_id envelopeUri obligationUri obligationTitle instrumentUri instrumentTitle iso2 country envelopeTitle envelopeReporter firstSeen released feedbackUri feedbackTitle FeedbackStatus fileUri filename fileKbSize fileMediaType
"4750cf20daebfe03d2cc5fdad37a0355" <http://cdr.eionet.europa.eu/de/eu/eiodata/envtomwyq> <http://rod.eionet.europa.eu/obligations/131> "EoI Data on air quality measurements at monitoring stations" <http://rod.eionet.europa.eu/instruments/191> "Exchange on Information decision (EoI) on Air" "DE" "Germany" "Germany EoI Data 2010 Part II: discontinously measured data" "dauerute" "2011-09-30T10:30:16Z"^^<http://www.w3.org/2001/XMLSchema#dateTime> "2011-09-29T08:52:21Z"^^<http://www.w3.org/2001/XMLSchema#dateTime> "" "" "" <http://cdr.eionet.europa.eu/de/eu/eiodata/envtomwyq/DEMUB2010.PM2_Cl> "DEMUB2010.PM2_Cl" "10.273"^^<http://www.w3.org/2001/XMLSchema#decimal> "text/plain; charset=UTF-8"
"ee625858bd89899426201f34a93aeb4d" <http://cdr.eionet.europa.eu/dk/eu/nbwd/envtvm2uq> <http://rod.eionet.europa.eu/obligations/531> "Bathing Water Directive - Monitoring and Classification of Bathing Waters" <http://rod.eionet.europa.eu/instruments/609> "New Bathing Water Directive (consolidated)" "DK" "Denmark" "BWQR_2011_Denmark" "johanhei" "2011-12-24T10:20:49Z"^^<http://www.w3.org/2001/XMLSchema#dateTime> "2011-12-23T12:19:36Z"^^<http://www.w3.org/2001/XMLSchema#dateTime> <http://cdr.eionet.europa.eu/dk/eu/nbwd/envtvm2uq/AutomaticQA_71256_1324643043> "AutomaticQA result for file BWQ_2011_Denmark_BWQD_2006_AbnormalSituations.xml: WISE: BWD2006 - Abnormal situations 2011" "" <http://cdr.eionet.europa.eu/dk/eu/nbwd/envtvm2uq/BWQ_2011_Denmark_BWQD_2006_AbnormalSituations.xml> "Converted from - BWQ_2011_Denmark.xls" "8.087"^^<http://www.w3.org/2001/XMLSchema#decimal> "text/xml"
"ee625858bd89899426201f34a93aeb4d" <http://cdr.eionet.europa.eu/dk/eu/nbwd/envtvm2uq> <http://rod.eionet.europa.eu/obligations/532> "Bathing Water Directive - Identification of Bathing Areas" <http://rod.eionet.europa.eu/instruments/609> "New Bathing Water Directive (consolidated)" "DK" "Denmark" "BWQR_2011_Denmark" "johanhei" "2011-12-24T10:20:49Z"^^<http://www.w3.org/2001/XMLSchema#dateTime> "2011-12-23T12:19:36Z"^^<http://www.w3.org/2001/XMLSchema#dateTime> <http://cdr.eionet.europa.eu/dk/eu/nbwd/envtvm2uq/AutomaticQA_71256_1324643043> "AutomaticQA result for file BWQ_2011_Denmark_BWQD_2006_AbnormalSituations.xml: WISE: BWD2006 - Abnormal situations 2011" "" <http://cdr.eionet.europa.eu/dk/eu/nbwd/envtvm2uq/BWQ_2011_Denmark_BWQD_2006_AbnormalSituations.xml> "Converted from - BWQ_2011_Denmark.xls" "8.087"^^<http://www.w3.org/2001/XMLSchema#decimal> "text/xml"
"385ed2967198e941fb3ddba7495ba475" <http://cdr.eionet.europa.eu/gb/eea/ewn1/envtqgftg> <http://rod.eionet.europa.eu/obligations/28> "River quality (EWN-1)" <http://rod.eionet.europa.eu/instruments/499> "EEA AWP" "GB" "United Kingdom" "England_&_Wales_2010_2" "pottecar" "2011-10-27T11:43:06Z"^^<http://www.w3.org/2001/XMLSchema#dateTime> "2011-10-26T13:33:52Z"^^<http://www.w3.org/2001/XMLSchema#dateTime> <http://cdr.eionet.europa.eu/gb/eea/ewn1/envtqgftg/conversion_log_Rivers_E_W_2010_Region_2.xls> "Conversion log for file Rivers_E_W_2010_Region_2.xls" "" <http://cdr.eionet.europa.eu/gb/eea/ewn1/envtqgftg/Rivers_E_W_2010_Region_2.xls> "Excel file - converted into an XML delivery" "13680.128"^^<http://www.w3.org/2001/XMLSchema#decimal> "application/vnd.ms-excel"
"1e8165e46d506deca1926845b6e495a2" <http://cdr.eionet.europa.eu/be/eu/eprtrdat/envtor9bg> <http://rod.eionet.europa.eu/obligations/538> "E-PRTR data reporting" <http://rod.eionet.europa.eu/instruments/615> "E-PRTR regulation" "BE" "Belgium" "E-PRTR data BE 2007, 8 and 9 - revision September 2011" "fierefra" "2011-09-30T10:30:16Z"^^<http://www.w3.org/2001/XMLSchema#dateTime> "2011-09-29T14:22:53Z"^^<http://www.w3.org/2001/XMLSchema#dateTime> <http://cdr.eionet.europa.eu/be/eu/eprtrdat/envtor9bg/AutomaticQA_66617_1317306722> "AutomaticQA result for file EPRTR2007BE.xml: Complementary Validation: Outliers" "" <http://cdr.eionet.europa.eu/be/eu/eprtrdat/envtor9bg/EPRTR2007BE.xml> "E-PRTR data BE 2007 - revision September 2011" "2674.622"^^<http://www.w3.org/2001/XMLSchema#decimal> "text/xml"
"1e8165e46d506deca1926845b6e495a2" <http://cdr.eionet.europa.eu/be/eu/eprtrdat/envtor9bg> <http://rod.eionet.europa.eu/obligations/538> "E-PRTR data reporting" <http://rod.eionet.europa.eu/instruments/615> "E-PRTR regulation" "BE" "Belgium" "E-PRTR data BE 2007, 8 and 9 - revision September 2011" "fierefra" "2011-09-30T10:30:16Z"^^<http://www.w3.org/2001/XMLSchema#dateTime> "2011-09-29T14:22:53Z"^^<http://www.w3.org/2001/XMLSchema#dateTime> <http://cdr.eionet.europa.eu/be/eu/eprtrdat/envtor9bg/AutomaticQA_66616_1317306484> "AutomaticQA result for file EPRTR2007BE.xml: Complementary Validation: use of Hyphens and Zeroes" "" <http://cdr.eionet.europa.eu/be/eu/eprtrdat/envtor9bg/EPRTR2007BE.xml> "E-PRTR data BE 2007 - revision September 2011" "2674.622"^^<http://www.w3.org/2001/XMLSchema#decimal> "text/xml"
"1e8165e46d506deca1926845b6e495a2" <http://cdr.eionet.europa.eu/be/eu/eprtrdat/envtor9bg> <http://rod.eionet.europa.eu/obligations/538> "E-PRTR data reporting" <http://rod.eionet.europa.eu/instruments/615> "E-PRTR regulation" "BE" "Belgium" "E-PRTR data BE 2007, 8 and 9 - revision September 2011" "fierefra" "2011-09-30T10:30:16Z"^^<http://www.w3.org/2001/XMLSchema#dateTime> "2011-09-29T14:22:53Z"^^<http://www.w3.org/2001/XMLSchema#dateTime> <http://cdr.eionet.europa.eu/be/eu/eprtrdat/envtor9bg/AutomaticQA_66615_1317306484> "AutomaticQA result for file EPRTR2007BE.xml: Compliance validation sorted by facilities " "" <http://cdr.eionet.europa.eu/be/eu/eprtrdat/envtor9bg/EPRTR2007BE.xml> "E-PRTR data BE 2007 - revision September 2011" "2674.622"^^<http://www.w3.org/2001/XMLSchema#decimal> "text/xml"
"1e8165e46d506deca1926845b6e495a2" <http://cdr.eionet.europa.eu/be/eu/eprtrdat/envtor9bg> <http://rod.eionet.europa.eu/obligations/538> "E-PRTR data reporting" <http://rod.eionet.europa.eu/instruments/615> "E-PRTR regulation" "BE" "Belgium" "E-PRTR data BE 2007, 8 and 9 - revision September 2011" "fierefra" "2011-09-30T10:30:16Z"^^<http://www.w3.org/2001/XMLSchema#dateTime> "2011-09-29T14:22:53Z"^^<http://www.w3.org/2001/XMLSchema#dateTime> <http://cdr.eionet.europa.eu/be/eu/eprtrdat/envtor9bg/AutomaticQA_66614_1317306484> "AutomaticQA result for file EPRTR2007BE.xml: Additional validation sorted by facilities " "" <http://cdr.eionet.europa.eu/be/eu/eprtrdat/envtor9bg/EPRTR2007BE.xml> "E-PRTR data BE 2007 - revision September 2011" "2674.622"^^<http://www.w3.org/2001/XMLSchema#decimal> "text/xml"
"1e8165e46d506deca1926845b6e495a2" <http://cdr.eionet.europa.eu/be/eu/eprtrdat/envtor9bg> <http://rod.eionet.europa.eu/obligations/538> "E-PRTR data reporting" <http://rod.eionet.europa.eu/instruments/615> "E-PRTR regulation" "BE" "Belgium" "E-PRTR data BE 2007, 8 and 9 - revision September 2011" "fierefra" "2011-09-30T10:30:16Z"^^<http://www.w3.org/2001/XMLSchema#dateTime> "2011-09-29T14:22:53Z"^^<http://www.w3.org/2001/XMLSchema#dateTime> <http://cdr.eionet.europa.eu/be/eu/eprtrdat/envtor9bg/AutomaticQA_66611_1317306483> "AutomaticQA result for file EPRTR2007BE.xml: XML Schema validation" "" <http://cdr.eionet.europa.eu/be/eu/eprtrdat/envtor9bg/EPRTR2007BE.xml> "E-PRTR data BE 2007 - revision September 2011" "2674.622"^^<http://www.w3.org/2001/XMLSchema#decimal> "text/xml"
"1e8165e46d506deca1926845b6e495a2" <http://cdr.eionet.europa.eu/be/eu/eprtrdat/envtor9bg> <http://rod.eionet.europa.eu/obligations/538> "E-PRTR data reporting" <http://rod.eionet.europa.eu/instruments/615> "E-PRTR regulation" "BE" "Belgium" "E-PRTR data BE 2007, 8 and 9 - revision September 2011" "fierefra" "2011-09-30T10:30:16Z"^^<http://www.w3.org/2001/XMLSchema#dateTime> "2011-09-29T14:22:53Z"^^<http://www.w3.org/2001/XMLSchema#dateTime> <http://cdr.eionet.europa.eu/be/eu/eprtrdat/envtor9bg/AutomaticQA_66619_1317306483> "AutomaticQA result for file EPRTR2007BE.xml: Complementary Validation: Coordinates and NUTS check " "" <http://cdr.eionet.europa.eu/be/eu/eprtrdat/envtor9bg/EPRTR2007BE.xml> "E-PRTR data BE 2007 - revision September 2011" "2674.622"^^<http://www.w3.org/2001/XMLSchema#decimal> "text/xml"

Received 26299 rows in 12.986 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/eionet-deliveries-2011/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://cr.eionet.europa.eu/sparql

PREFIX rdfns: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rod: <http://rod.eionet.europa.eu/schema.rdf#>
PREFIX rdfsh: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX dc: <http://purl.org/dc/terms/>
PREFIX cr: <http://cr.eionet.europa.eu/ontologies/contreg.rdf#>
PREFIX ns: <http://www.w3.org/ns/dcat#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX contreg: <http://cr.eionet.europa.eu/ontologies/contreg.rdf#>

SELECT DISTINCT
md5(sql:GROUP_CONCAT(?subj, ?fileUri )) as ?_id
?subj as ?envelopeUri 
?obligationUri 
?obligationTitle 
?instrumentUri 
?instrumentTitle
?iso2 
?country 
?envelopeTitle 
?envelopeReporter
?firstSeen
?released 
?feedbackUri 
?feedbackTitle 
?FeedbackStatus 
?fileUri 
?filename 
xsd:double(?filebyteSize)/1000.0 as ?fileKbSize
?fileMediaType 

WHERE
{{

  SELECT DISTINCT 
    *
  WHERE
    {
      ?subj a rod:Delivery .
      ?subj rod:locality ?locality .
      ?subj rod:obligation ?obligationUri .
      ?subj contreg:firstSeen ?firstSeen .
      ?subj rod:released ?released .
      ?subj dc:title ?envelopeTitle .
      ?subj dc:creator ?envelopeReporter .
      ?subj rod:hasFile ?fileUri.

      ?fileUri rdfsh:label ?filename .
      ?fileUri ns:byteSize ?filebyteSize .
      ?fileUri cr:mediaType ?fileMediaType .

      ?locality rod:localityName ?country .
      ?locality skos:notation ?iso2 .

      ?obligationUri dc:title ?obligationTitle .
      ?obligationUri rod:instrument ?instrumentUri .

      ?instrumentUri rdfs:label ?instrumentTitle .

      OPTIONAL { 
        ?subj cr:hasFeedback ?feedbackUri .
        ?feedbackUri dc:title ?feedbackTitle .
        ?feedbackUri cr:feedbackStatus ?FeedbackStatus .
        ?feedbackUri cr:feedbackFor ?fileUri .
       }
     FILTER NOT EXISTS {?feedbackUri cr:feedbackFor ?fileUri}
     }
} UNION {

  SELECT DISTINCT 
    *
  WHERE
    {
      ?subj a rod:Delivery .
      ?subj rod:locality ?locality .
      ?subj rod:obligation ?obligationUri .
      ?subj contreg:firstSeen ?firstSeen .
      ?subj rod:released ?released .       
      ?subj dc:title ?envelopeTitle .
      ?subj dc:creator ?envelopeReporter .

      ?locality rod:localityName ?country .
      ?locality skos:notation ?iso2 .
      ?obligationUri dc:title ?obligationTitle .
      ?obligationUri rod:instrument ?instrumentUri .

      ?instrumentUri rdfs:label ?instrumentTitle .
    
      ?subj cr:hasFeedback ?feedbackUri .

      ?feedbackUri dc:title ?feedbackTitle .
      ?feedbackUri cr:feedbackStatus ?FeedbackStatus .

      OPTIONAL { 
        ?feedbackUri cr:feedbackFor ?fileUri .
        ?fileUri rdfsh:label ?filename .
        ?fileUri ns:byteSize ?filebyteSize .
        ?fileUri cr:mediaType ?fileMediaType .
      }
    }
  }
FILTER (year(?released) in (2011))
}


Temporal coverage

Document Actions
Filed under: