data related to daviz related to latest assessement

PREFIX dcterms: <http://purl.org/dc/terms/> PREFIX rdf-syntax: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX Specification: <http://www.eea.europa.eu/portal_types/Specification#>
PREFIX Assessment: <http://www.eea.europa.eu/portal_types/Assessment#>
PREFIX AssessmentPart: <http://www.eea.europa.eu/portal_types/AssessmentPart#>
PREFIX wgs84_pos: <http://www.w3.org/2003/01/geo/wgs84_pos#>
PREFIX EEAFigure: <http://www.eea.europa.eu/portal_types/EEAFigure#>
PREFIX GISApplication: <http://www.eea.europa.eu/portal_types/GIS%20Application#>
PREFIX output: <http://rdfdata.eionet.europa.eu/amp/ontology/Output>
PREFIX PolicyQuestion: <http://www.eea.europa.eu/portal_types/PolicyQuestion#>
PREFIX DavizVisualization: <http://www.eea.europa.eu/portal_types/DavizVisualization#>
PREFIX schemaorg: <http://schema.org/>
PREFIX ExternalDataSpec: <http://www.eea.europa.eu/portal_types/ExternalDataSpec#>
PREFIX Data: <http://www.eea.europa.eu/portal_types/Data#>
PREFIX portal_types: <http://www.eea.europa.eu/portal_types#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>

SELECT DISTINCT
?specificationUri
?assessmentUri
?visualizationUri
?visualizationIssued
?visualizationType
?dataUri
Min(xsd:integer(?visualizationTemporalCoverage)) as ?dataTemporalCoverageMin
Max(xsd:integer(?visualizationTemporalCoverage)) as ?dataTemporalCoverageMax
(Max(xsd:integer(?visualizationTemporalCoverage)) - Min(xsd:integer(?visualizationTemporalCoverage))+1) as ?dataTemporalCoverage
?dataType
?dataProductID
IRI(bif:concat('http://www.eea.europa.eu/ds_resolveuid/', ?dataProductID)) as ?dataLatest 
?dataTitle
?dataManagementPlan
bif:either(bound(?dataManagementPlan), iri(bif:concat('http://applications/managementplan/ProjectPlan.aspx?year=', bif:left(?dataManagementPlan, 4 ), '&code=', bif:right(?dataManagementPlan, 5 ))), '') as ?dataManagementPlanUri
?dataProviderUri
?dataProvider
?reportingObligationsUri
bif:either(bound(?reportingObligationsUri), concat("http://rod.eionet.europa.eu/obligations/", ?reportingObligationsUri), '') as ?reportingObligationsUrl
?dataIssued
WHERE {
  #?specificationUri rdf-syntax:type Specification:Specification .
  #?specificationUri Specification:codes ?codes .
  #FILTER (substr(?codes, 1 ,3) != 'CSI')
  #OPTIONAL {?specificationUri dcterms:isReplacedBy ?isReplacedBy . }
  #FILTER (!bound(?isReplacedBy))

  ?specificationUri dcterms:hasPart ?assessmentUri .
  ?assessmentUri rdf-syntax:type Assessment:Assessment .
  OPTIONAL { ?assessmentUri dcterms:isReplacedBy ?a_isReplacedBy . }
  FILTER (!bound(?a_isReplacedBy))

  ?assessmentPartUri dcterms:isPartOf ?assessmentUri .
  ?assessmentPartUri rdf-syntax:type AssessmentPart:AssessmentPart .

  ?assessmentPartUri AssessmentPart:relatedItems ?visualizationUri .
  ?visualizationUri rdf-syntax:type ?visualizationTypeFilter .
  #FILTER (strstarts(str(?visualizationTypeFilter ), 'http://www.eea.europa.eu/portal_types/'))
  #FILTER (?visualizationTypeFilter != <http://www.eea.europa.eu/portal_types/PolicyQuestion#PolicyQuestion>)  

  #FILTER (?visualizationUri = <http://www.eea.europa.eu/data-and-maps/daviz/greenhouse-gas-ghg-emission-trends-2>)

  OPTIONAL { ?visualizationTypeFilter rdf-syntax:id ?visualizationType } .
  FILTER (bound(?visualizationType))

  ?visualizationUri dcterms:issued ?visualizationIssued .

  ?visualizationUri DavizVisualization:temporalCoverage ?visualizationTemporalCoverage .

  { 
    ?dataUri Data:relatedItems ?visualizationUri .
  } UNION {
    ?dataUri ExternalDataSpec:relatedItems ?visualizationUri .
  }

  OPTIONAL { ?dataUri Data:eeaManagementPlan ?dataManagementPlan } .

  ?dataUri rdf-syntax:type ?dataTypeFilter .
  ?dataTypeFilter rdf-syntax:id ?dataType .

  ?dataUri dcterms:title ?dataTitle .
  ?dataUri schemaorg:productID ?dataProductID .

  ?dataUri portal_types:dataProvider ?dataProviderUri .
  ?dataProviderUri foaf:name ?dataProvider .
  OPTIONAL { ?dataUri Data:reportingObligations ?reportingObligationsUri } .
OPTIONAL { ?dataUri dcterms:issued ?dataIssued }.
  
}
ORDER BY ?latest