1 PREFIX noa: <http://teleios.di.uoa.gr/ontologies/noaOntology.owl#>

2 PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>

3 PREFIX strdf: <http://strdf.di.uoa.gr/ontology#>

4 PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

5 PREFIX gag: <http://geo.linkedopendata.gr/greekadministrativeregion/ontology#>

6

7

8 INSERT { ?h noa:isDiscarded "1"^^xsd:int .

9 ?valid rdf:type noa:Hotspot ;

10 noa:hasConfidence ?conf ;

11 noa:hasGeometry ?dif ;

12 gag:hasMunicipality ?muni ;

13 noa:hasAcquisitionTime "TIMESTAMP"^^xsd:dateTime ;

14 noa:isDerivedFromSensor "SENSOR"^^xsd:string ;

15 noa:hasConfirmation noa:unknown ;

16 noa:producedFromProcessingChain "PROCESSING_CHAIN"^^xsd:string ;

17 noa:isProducedBy noa:noa ;

18 noa:isDerivedFromSatellite "SAT"^^xsd:string ;

19 noa:refinedBy noa:coastlineRefinement ;

20 noa:refinedBy ?refined .

21 }

22 WHERE {

23 SELECT ?h (strdf:intersection(?hGeo, strdf:union(?cGeo)) AS ?dif) (URI(CONCAT(STR(?h),"/refined")) AS ?valid) ?conf ?muni

24 WHERE {

25 ?h noa:hasAcquisitionTime "TIMESTAMP"^^xsd:dateTime;

26 noa:producedFromProcessingChain "PROCESSING_CHAIN"^^xsd:string ;

27 noa:isDerivedFromSensor "SENSOR"^^xsd:string ;

28 noa:hasGeometry ?hGeo ;

29 gag:hasMunicipality ?muni ;

30 noa:hasConfidence ?conf .

31 OPTIONAL{?h noa:refinedBy ?r. FILTER(?r=noa:coastlineRefinement)}.

32 FILTER(!bound(?r)).

33 ?c rdf:type gag:GeometryPart ;

34 gag:hasGeometry ?cGeo .

35 FILTER(strdf:mbbIntersects(?hGeo, ?cGeo)) .

36 OPTIONAL { ?h noa:refinedBy ?refined } .

37 }

38 GROUP BY ?h ?hGeo ?conf ?muni

39 HAVING strdf:overlaps(?hGeo, strdf:union(?cGeo))

40 }