Strabon

changeset 704:0803755b1954

Add queries (not in final form) for ISWC-demo
author George Garbis <ggarbis@di.uoa.gr>
date Fri Nov 09 03:42:41 2012 +0200 (2012-11-09)
parents 20d6240229f7
children d9d409b5dbe7
files endpoint/WebContent/WEB-INF/beans.xml
line diff
     1.1 --- a/endpoint/WebContent/WEB-INF/beans.xml	Fri Nov 09 01:34:52 2012 +0200
     1.2 +++ b/endpoint/WebContent/WEB-INF/beans.xml	Fri Nov 09 03:42:41 2012 +0200
     1.3 @@ -90,7 +90,7 @@
     1.4               <list>
     1.5               	<list>
     1.6               		<!-- Single valued elements correspond to headers -->
     1.7 -					<value>Dataset Presentation</value>
     1.8 +					<value>Discovery Queries</value>
     1.9  	            </list>
    1.10  				<list>
    1.11  	                 <!-- Bean -->
    1.12 @@ -98,30 +98,27 @@
    1.13  	                <!-- Format -->
    1.14  	                <value>KML</value>   
    1.15  	                <!-- Label -->
    1.16 -	                <value>[CLC] Select all CLC information for Venice</value> 
    1.17 +	                <value>[ΝΟΑ] Select all hotspots of 2012 before any refinement</value> 
    1.18  	                <!-- Statement -->
    1.19 -	                <value><![CDATA[PREFIX strdf:<http://strdf.di.uoa.gr/ontology#>
    1.20 -PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>
    1.21 -PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>
    1.22 -PREFIX teleios:<http://teleios.di.uoa.gr/ontologies/noaOntology.owl#>
    1.23 +	                <value><![CDATA[PREFIX noa: <http://teleios.di.uoa.gr/ontologies/noaOntology.owl#> 
    1.24 +PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> 
    1.25 +PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> 
    1.26 +PREFIX strdf: <http://strdf.di.uoa.gr/ontology#> 
    1.27 +PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> 
    1.28 +PREFIX gag: <http://geo.linkedopendata.gr/greekadministrativeregion/ontology#>
    1.29  
    1.30 -SELECT ?clc ?clcType ?clcID ?clcCode ?clcRemark ?clcShapeLength ?clcArea ?clcAreaHa ?clcLandUse ?clcGeo
    1.31 -WHERE {
    1.32 -   ?clc a ?clcType .
    1.33 -   ?clc teleios:hasCode ?clcCode .
    1.34 -   ?clc teleios:hasID ?clcID .
    1.35 -   ?clc teleios:hasRemark ?clcRemark  .
    1.36 -   ?clc teleios:hasShape_Leng ?clcShapeLength .
    1.37 -   ?clc teleios:hasShape_Area ?clcArea .
    1.38 -   ?clc teleios:hasArea_ha ?clcAreaHa .
    1.39 -   ?clc teleios:hasLandUse ?clcLandUse .
    1.40 -   ?clc teleios:hasGeometry ?clcGeo .
    1.41 -   #Venice
    1.42 -   FILTER (strdf:anyInteract(?clcGeo, "POLYGON ((12.301451 45.40493,12.398127 45.416817,12.386066 45.46502,12.289288 45.45313,12.301451 45.40493))"^^strdf:WKT)) .
    1.43 -   #Toulouse
    1.44 -   #FILTER (strdf:anyInteract(?clcGeo, "POLYGON((1.3816636 43.573734,1.4903361 43.588024,1.4783715 43.634777,1.3696271 43.620483,1.3816636 43.573734))"^^strdf:WKT)) .
    1.45 -   #Timisoara
    1.46 -   #FILTER (strdf:anyInteract(?clcGeo, "POLYGON((21.188068 45.7305,21.286903 45.74229,21.275377 45.79014,21.176264 45.778324,21.188068 45.7305))"^^strdf:WKT)) .
    1.47 +SELECT ?h  (strdf:transform(?hGeo, <http://www.opengis.net/def/crs/EPSG/0/4326>) AS ?geo) ?conf ?municipality
    1.48 +WHERE { 
    1.49 +?h   noa:hasGeometry ?hGeo ;
    1.50 +     noa:hasAcquisitionTime ?hAcquisitionTime ; 
    1.51 +     noa:producedFromProcessingChain ?hProcessingChain ; 
    1.52 +     noa:isDerivedFromSensor "MSG1_RSS"^^xsd:string ;
    1.53 +     noa:hasConfidence ?conf ;
    1.54 +     gag:hasMunicipality ?municipality .
    1.55 +     FILTER(?hProcessingChain = "DynamicThresholds" || ?hProcessingChain = "DynamicThresholds-TimePersistence") .
    1.56 +     FILTER("2012-05-01T00:00:00"^^xsd:dateTime <= ?hAcquisitionTime && ?hAcquisitionTime < "2012-10-01T00:00:00"^^xsd:dateTime ) .
    1.57 +     OPTIONAL {?h noa:isDiscarded ?disc }.
    1.58 +     FILTER (!bound(?disc)) .
    1.59  }
    1.60  ]]></value>
    1.61  	                <!-- Description -->
    1.62 @@ -135,35 +132,26 @@
    1.63  	                <!-- Format -->
    1.64  	                <value>KML</value>   
    1.65  	                <!-- Label -->
    1.66 -	                <value>[LGD] Select all LGD information for Venice</value> 
    1.67 +	                <value>[ΝΟΑ] Select all hotspots of 2012 after refinement operation 'delete in sea'</value> 
    1.68  	                <!-- Statement -->
    1.69 -	                <value><![CDATA[PREFIX strdf:<http://strdf.di.uoa.gr/ontology#>
    1.70 -PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>
    1.71 -PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>
    1.72 -PREFIX teleios:<http://teleios.di.uoa.gr/ontologies/noaOntology.owl#>
    1.73 -PREFIX lgd:<http://linkedgeodata.org/triplify/>
    1.74 -PREFIX lgdgeo:<http://www.w3.org/2003/01/geo/wgs84_pos#>
    1.75 -PREFIX lgdont:<http://linkedgeodata.org/ontology/>
    1.76 +	                <value><![CDATA[PREFIX noa: <http://teleios.di.uoa.gr/ontologies/noaOntology.owl#>
    1.77 +PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
    1.78 +PREFIX strdf: <http://strdf.di.uoa.gr/ontology#>
    1.79 +PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
    1.80 +PREFIX gag: <http://geo.linkedopendata.gr/greekadministrativeregion/ontology#>
    1.81  
    1.82 -SELECT ?lgd ?lgdDirectType (GROUP_CONCAT(?lgdType ; separator=", ") AS ?lgdTypes) ?lgdLabel ?lgdGeo
    1.83 +INSERT {?h noa:isDiscarded "1"^^xsd:int ;
    1.84 +           noa:refinedBy noa:seaInconsistency .
    1.85 +} 
    1.86  WHERE {
    1.87 -   ?lgd lgdont:directType ?lgdDirectType .
    1.88 -   OPTIONAL {
    1.89 -      ?lgd a ?lgdType .
    1.90 -      FILTER ((?lgdType != lgdont:Node) && (?lgdType != ?lgdDirectType)) .
    1.91 -   }
    1.92 -   ?lgd rdfs:label ?lgdLabel .
    1.93 -   ?lgd lgdgeo:geometry ?lgdGeo .
    1.94 -   #Venice
    1.95 -   FILTER (strdf:anyInteract(?lgdGeo, "POLYGON ((12.301451 45.40493,12.398127 45.416817,12.386066 45.46502,12.289288 45.45313,12.301451 45.40493))"^^strdf:WKT)) .
    1.96 -   #Toulouse
    1.97 -   #FILTER (strdf:anyInteract(?lgdGeo, "POLYGON((1.3816636 43.573734,1.4903361 43.588024,1.4783715 43.634777,1.3696271 43.620483,1.3816636 43.573734))"^^strdf:WKT)) .
    1.98 -   #Timisoara
    1.99 -   #FILTER (strdf:anyInteract(?lgdGeo, "POLYGON((21.188068 45.7305,21.286903 45.74229,21.275377 45.79014,21.176264 45.778324,21.188068 45.7305))"^^strdf:WKT)) .
   1.100 -
   1.101 -}
   1.102 -GROUP BY ?lgd ?lgdDirectType ?lgdLabel ?lgdGeo
   1.103 -	                ]]></value>
   1.104 +?h   noa:hasAcquisitionTime "TIMESTAMP"^^xsd:dateTime ;
   1.105 +     noa:producedFromProcessingChain "PROCESSING_CHAIN"^^xsd:string ;
   1.106 +     noa:isDerivedFromSensor "SENSOR"^^xsd:string .
   1.107 +       OPTIONAL {
   1.108 +    ?h	gag:hasMunicipality ?municipalit .
   1.109 +  } 
   1.110 +  FILTER(!bound(?municipality)) .
   1.111 +}	                ]]></value>
   1.112  	                <!-- Description -->
   1.113  					<value></value>
   1.114  					<!-- Hander (plain, download, map or map_local)-->
   1.115 @@ -175,39 +163,18 @@
   1.116  	                <!-- Format -->
   1.117  	                <value>KML</value>   
   1.118  	                <!-- Label -->
   1.119 -	                <value>[Geonames] Select all Geonames information for Venice</value> 
   1.120 +	                <value>[ΝΟΑ] Select all hotspots of 2012 after refinement operation 'delete in inconsistent areas'</value> 
   1.121  	                <!-- Statement -->
   1.122 -	                <value><![CDATA[PREFIX strdf:<http://strdf.di.uoa.gr/ontology#>
   1.123 -PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>
   1.124 -PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>
   1.125 -PREFIX teleios:<http://teleios.di.uoa.gr/ontologies/noaOntology.owl#>
   1.126 -PREFIX lgd:<http://linkedgeodata.org/triplify/>
   1.127 -PREFIX lgdgeo:<http://www.w3.org/2003/01/geo/wgs84_pos#>
   1.128 -PREFIX lgdont:<http://linkedgeodata.org/ontology/>
   1.129 -PREFIX geonames:<http://www.geonames.org/ontology#>
   1.130 +	                <value><![CDATA[PREFIX noa: <http://teleios.di.uoa.gr/ontologies/noaOntology.owl#> 
   1.131 +PREFIX strdf: <http://strdf.di.uoa.gr/ontology#> 
   1.132 +PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
   1.133  
   1.134 -SELECT ?geoID ?name (GROUP_CONCAT(?altName; separator=", ") AS ?altNames) ?parentFeature ?parentCountry ?parentADM1 ?parentADM2 ?parentADM3 (GROUP_CONCAT(?near; separator=", ") AS ?nearFeatures) ?geoIdGeo
   1.135 -WHERE {
   1.136 -?geoId geonames:name ?name .
   1.137 -OPTIONAL {?geoId geonames:alternateName ?altName } .
   1.138 -?geoId geonames:featureClass ?geoFeature .
   1.139 -?geoId geonames:countryCode ?country .
   1.140 -OPTIONAL {?geoId geonames:parentFeature ?parentFeature . } .
   1.141 -OPTIONAL {?geoId geonames:parentCountry ?parentCountry . } .
   1.142 -OPTIONAL {?geoId geonames:parentADM1 ?parentADM1 . } .
   1.143 -OPTIONAL {?geoId geonames:parentADM2 ?parentADM2 . } .
   1.144 -OPTIONAL {?geoId geonames:parentADM3 ?parentADM3 . } .
   1.145 -OPTIONAL {?geoId geonames:nearbyFeatures ?near . } .
   1.146 -?geoId teleios:hasGeography ?geoIdGeo .
   1.147 -   #Venice
   1.148 -   FILTER (strdf:anyInteract(?geoIdGeo, "POLYGON ((12.301451 45.40493,12.398127 45.416817,12.386066 45.46502,12.289288 45.45313,12.301451 45.40493))"^^strdf:WKT)) .
   1.149 -   #Toulouse
   1.150 -   #FILTER (strdf:anyInteract(?geoIdGeo, "POLYGON((1.3816636 43.573734,1.4903361 43.588024,1.4783715 43.634777,1.3696271 43.620483,1.3816636 43.573734))"^^strdf:WKT)) .
   1.151 -   #Timisoara
   1.152 -   #FILTER (strdf:anyInteract(?geoIdGeo, "POLYGON((21.188068 45.7305,21.286903 45.74229,21.275377 45.79014,21.176264 45.778324,21.188068 45.7305))"^^strdf:WKT)) .
   1.153 -}
   1.154 -GROUP BY  ?geoID ?name ?parentFeature ?parentCountry ?parentADM1 ?parentADM2 ?parentADM3 ?geoIdGeo
   1.155 -	                ]]></value>
   1.156 +SELECT ?h (strdf:transform(?hGeo, <http://www.opengis.net/def/crs/EPSG/0/4326>) AS ?geo) ("Corine Land Cover inconsistency" as ?refinement)
   1.157 +WHERE { 
   1.158 +    ?h   noa:hasGeometry ?hGeo ;
   1.159 +         noa:hasAcquisitionTime "TIMESTAMP"^^xsd:dateTime ;
   1.160 +         noa:refinedBy noa:clcInconsistency .
   1.161 +}	                ]]></value>
   1.162  	                <!-- Description -->
   1.163  					<value></value>
   1.164  					<!-- Hander (plain, download, map or map_local)-->
   1.165 @@ -219,33 +186,18 @@
   1.166  	                <!-- Format -->
   1.167  	                <value>KML</value>   
   1.168  	                <!-- Label -->
   1.169 -	                <value>[DLR] Select all patches and their corresponding labels</value> 
   1.170 +	                <value>[ΝΟΑ] Select all hotspots of 2012 after refinement operation 'refine in coast'</value> 
   1.171  	                <!-- Statement -->
   1.172 -	                <value><![CDATA[#select all patches and their labels (Venice)
   1.173 -PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
   1.174 -PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
   1.175 -PREFIX dlr: <http://www.earthobservatory.eu/ontologies/dlrOntology-v2.owl#>
   1.176 +	                <value><![CDATA[PREFIX noa: <http://teleios.di.uoa.gr/ontologies/noaOntology.owl#> 
   1.177 +PREFIX strdf: <http://strdf.di.uoa.gr/ontology#> 
   1.178  PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
   1.179 -PREFIX strdf: <http://strdf.di.uoa.gr/ontology#>
   1.180 -PREFIX teleios:<http://teleios.di.uoa.gr/ontologies/noaOntology.owl#>
   1.181  
   1.182 -
   1.183 -SELECT ?g (GROUP_CONCAT(?annotation; separator=", ") AS ?labels)
   1.184 -WHERE {
   1.185 -   ?p rdf:type dlr:Patch .        
   1.186 -   ?p dlr:hasGeometry ?g .
   1.187 -   ?p dlr:hasLabel ?l .
   1.188 -   ?l rdf:type dlr:Label .
   1.189 -   ?l dlr:correspondsTo ?annotation .
   1.190 -   #Venice
   1.191 -   FILTER (strdf:anyInteract(?g, "POLYGON ((12.301451 45.40493,12.398127 45.416817,12.386066 45.46502,12.289288 45.45313,12.301451 45.40493))"^^strdf:WKT)) .
   1.192 -   #Toulouse
   1.193 -   #FILTER (strdf:anyInteract(?g, "POLYGON((1.3816636 43.573734,1.4903361 43.588024,1.4783715 43.634777,1.3696271 43.620483,1.3816636 43.573734))"^^strdf:WKT)) .
   1.194 -   #Timisoara
   1.195 -   #FILTER (strdf:anyInteract(?g, "POLYGON((21.188068 45.7305,21.286903 45.74229,21.275377 45.79014,21.176264 45.778324,21.188068 45.7305))"^^strdf:WKT)) .
   1.196 -}
   1.197 -GROUP BY ?g
   1.198 -	                ]]></value>
   1.199 +SELECT ?h (strdf:transform(?hGeo, <http://www.opengis.net/def/crs/EPSG/0/4326>) AS ?geo) ("Corine Land Cover inconsistency" as ?refinement)
   1.200 +WHERE { 
   1.201 +    ?h   noa:hasGeometry ?hGeo ;
   1.202 +         noa:hasAcquisitionTime "TIMESTAMP"^^xsd:dateTime ;
   1.203 +         noa:refinedBy noa:clcInconsistency .
   1.204 +}	                ]]></value>
   1.205  	                <!-- Description -->
   1.206  					<value></value>
   1.207  					<!-- Hander (plain, download, map or map_local)-->
   1.208 @@ -257,32 +209,18 @@
   1.209  	                <!-- Format -->
   1.210  	                <value>KML</value>   
   1.211  	                <!-- Label -->
   1.212 -	                <value>[DLR] Select all patches corresponding to water</value> 
   1.213 +	                <value>[ΝΟΑ] Select all hotspots of 2012 after refinement operation 'refine according to time persistence'</value> 
   1.214  	                <!-- Statement -->
   1.215 -	                <value><![CDATA[PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
   1.216 -PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
   1.217 -PREFIX dlr: <http://www.earthobservatory.eu/ontologies/dlrOntology-v2.owl#>
   1.218 +	                <value><![CDATA[PREFIX noa: <http://teleios.di.uoa.gr/ontologies/noaOntology.owl#> 
   1.219 +PREFIX strdf: <http://strdf.di.uoa.gr/ontology#> 
   1.220  PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
   1.221 -PREFIX strdf: <http://strdf.di.uoa.gr/ontology#>
   1.222 -PREFIX teleios:<http://teleios.di.uoa.gr/ontologies/noaOntology.owl#>
   1.223  
   1.224 -
   1.225 -SELECT ?g (GROUP_CONCAT(?annotation; separator=", ") AS ?labels)
   1.226 -WHERE {
   1.227 -   ?p rdf:type dlr:Patch .        
   1.228 -   ?p dlr:hasGeometry ?g .
   1.229 -   ?p dlr:hasLabel ?l .
   1.230 -   ?l rdf:type dlr:Label .
   1.231 -   ?l dlr:correspondsTo dlr:Water .
   1.232 -   #Venice
   1.233 -   FILTER (strdf:anyInteract(?g, "POLYGON ((12.301451 45.40493,12.398127 45.416817,12.386066 45.46502,12.289288 45.45313,12.301451 45.40493))"^^strdf:WKT)) .
   1.234 -   #Toulouse
   1.235 -   #FILTER (strdf:anyInteract(?g, "POLYGON((1.3816636 43.573734,1.4903361 43.588024,1.4783715 43.634777,1.3696271 43.620483,1.3816636 43.573734))"^^strdf:WKT)) .
   1.236 -   #Timisoara
   1.237 -   #FILTER (strdf:anyInteract(?g, "POLYGON((21.188068 45.7305,21.286903 45.74229,21.275377 45.79014,21.176264 45.778324,21.188068 45.7305))"^^strdf:WKT)) .
   1.238 -}
   1.239 -GROUP BY ?g
   1.240 -	                ]]></value>
   1.241 +SELECT ?h (strdf:transform(?hGeo, <http://www.opengis.net/def/crs/EPSG/0/4326>) AS ?geo) ("Temporal persistence" as ?refinement)
   1.242 +WHERE { 
   1.243 +    ?h   noa:hasGeometry ?hGeo ;
   1.244 +         noa:hasAcquisitionTime "TIMESTAMP"^^xsd:dateTime ;
   1.245 +         noa:refinedBy noa:temporalPersistence .
   1.246 +}	                ]]></value>
   1.247  	                <!-- Description -->
   1.248  					<value></value>
   1.249  					<!-- Hander (plain, download, map or map_local)-->
   1.250 @@ -294,33 +232,19 @@
   1.251  	                <!-- Format -->
   1.252  	                <value>KML</value>   
   1.253  	                <!-- Label -->
   1.254 -	                <value>[DLR] Select all patches corresponding to all subclasses of water</value> 
   1.255 +	                <value>[NOA] Select all that have been refined by a refinement operation</value> 
   1.256  	                <!-- Statement -->
   1.257 -	                <value><![CDATA[PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
   1.258 -PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
   1.259 -PREFIX dlr: <http://www.earthobservatory.eu/ontologies/dlrOntology-v2.owl#>
   1.260 +	                <value><![CDATA[PREFIX noa: <http://teleios.di.uoa.gr/ontologies/noaOntology.owl#>
   1.261 +PREFIX strdf: <http://strdf.di.uoa.gr/ontology#>
   1.262  PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
   1.263 -PREFIX strdf: <http://strdf.di.uoa.gr/ontology#>
   1.264 -PREFIX teleios:<http://teleios.di.uoa.gr/ontologies/noaOntology.owl#>
   1.265  
   1.266 -
   1.267 -SELECT ?g (GROUP_CONCAT(?annotation; separator=", ") AS ?labels)
   1.268 -WHERE {
   1.269 -   ?p rdf:type dlr:Patch .        
   1.270 -   ?p dlr:hasGeometry ?g .
   1.271 -   ?p dlr:hasLabel ?l .
   1.272 -   ?l rdf:type dlr:Label .
   1.273 -   ?l dlr:correspondsTo ?annotation .
   1.274 -   ?annotation rdfs:subClassOf dlr:Water .
   1.275 -   #Venice
   1.276 -   FILTER (strdf:anyInteract(?g, "POLYGON ((12.301451 45.40493,12.398127 45.416817,12.386066 45.46502,12.289288 45.45313,12.301451 45.40493))"^^strdf:WKT)) .
   1.277 -   #Toulouse
   1.278 -   #FILTER (strdf:anyInteract(?g, "POLYGON((1.3816636 43.573734,1.4903361 43.588024,1.4783715 43.634777,1.3696271 43.620483,1.3816636 43.573734))"^^strdf:WKT)) .
   1.279 -   #Timisoara
   1.280 -   #FILTER (strdf:anyInteract(?g, "POLYGON((21.188068 45.7305,21.286903 45.74229,21.275377 45.79014,21.176264 45.778324,21.188068 45.7305))"^^strdf:WKT)) .
   1.281 +SELECT (strdf:transform(?hGeo, <http://www.opengis.net/def/crs/EPSG/0/4326>) AS ?geo) (GROUP_CONCAT(?refinement; separator=", ") AS ?refinements)
   1.282 +WHERE { 
   1.283 +    ?h   noa:hasGeometry ?hGeo ;
   1.284 +         noa:hasAcquisitionTime "TIMESTAMP"^^xsd:dateTime ;
   1.285 +         noa:refinedBy ?refinement .
   1.286  }
   1.287 -GROUP BY ?g
   1.288 -	                ]]></value>
   1.289 +GROUP BY ?geo	                ]]></value>
   1.290  	                <!-- Description -->
   1.291  					<value></value>
   1.292  					<!-- Hander (plain, download, map or map_local)-->
   1.293 @@ -328,7 +252,7 @@
   1.294  	            </list>	            
   1.295  	            <list>
   1.296               		<!-- Single valued elements correspond to headers -->
   1.297 -					<value>First level statistics</value>
   1.298 +					<value>Enrich available information</value>
   1.299  	            </list>
   1.300  				<list>
   1.301  	                 <!-- Bean -->
   1.302 @@ -336,207 +260,31 @@
   1.303  	                <!-- Format -->
   1.304  	                <value>HTML</value>   
   1.305  	                <!-- Label -->
   1.306 -	                <value>[DLR] How many labels are identified in a scene?</value> 
   1.307 +	                <value>[NOA + GAG]Connect each hotspot with the municipality where it is located</value> 
   1.308  	                <!-- Statement -->
   1.309 -	                <value><![CDATA[PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
   1.310 +	                <value><![CDATA[PREFIX noa: <http://teleios.di.uoa.gr/ontologies/noaOntology.owl#>
   1.311  PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
   1.312  PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
   1.313  PREFIX strdf: <http://strdf.di.uoa.gr/ontology#>
   1.314 -PREFIX geof: <http://www.opengis.net/def/queryLanguage/OGC-GeoSPARQL/1.0/function/>
   1.315 -PREFIX lgd: <http://linkedgeodata.org/triplify/>
   1.316 -PREFIX lgdont: <http://linkedgeodata.org/ontology/>
   1.317 -PREFIX lgdgeo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
   1.318 -PREFIX geonames: <http://www.geonames.org/ontology#>
   1.319 -PREFIX teleios:<http://teleios.di.uoa.gr/ontologies/noaOntology.owl#>
   1.320 -PREFIX dlr: <http://www.earthobservatory.eu/ontologies/dlrOntology-v2.owl#>
   1.321 +PREFIX gag: <http://geo.linkedopendata.gr/greekadministrativeregion/ontology#>
   1.322 +PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> 
   1.323  
   1.324 -SELECT ?annotation (COUNT(DISTINCT ?p) AS ?numberOfPatches)
   1.325 -WHERE {
   1.326 -   ?p rdf:type dlr:Patch .        
   1.327 -   ?p dlr:hasGeometry ?g .
   1.328 -   ?p dlr:hasLabel ?l .
   1.329 -   ?l rdf:type dlr:Label .
   1.330 -   ?l dlr:correspondsTo ?annotation .
   1.331 -   #Venice
   1.332 -   FILTER (strdf:anyInteract(?g, "POLYGON ((12.301451 45.40493,12.398127 45.416817,12.386066 45.46502,12.289288 45.45313,12.301451 45.40493))"^^strdf:WKT)) .
   1.333 -   #Toulouse
   1.334 -   #FILTER (strdf:anyInteract(?g, "POLYGON((1.3816636 43.573734,1.4903361 43.588024,1.4783715 43.634777,1.3696271 43.620483,1.3816636 43.573734))"^^strdf:WKT)) .
   1.335 -   #Timisoara
   1.336 -   #FILTER (strdf:anyInteract(?g, "POLYGON((21.188068 45.7305,21.286903 45.74229,21.275377 45.79014,21.176264 45.778324,21.188068 45.7305))"^^strdf:WKT)) .
   1.337 -}
   1.338 -GROUP BY ?annotation
   1.339 -ORDER BY DESC(?numberOfPatches)]]></value>
   1.340 -	                <!-- Description -->
   1.341 -					<value></value>
   1.342 -					<!-- Hander (plain, download, map or map_local)-->
   1.343 -					<value>plain</value>
   1.344 -	            </list>
   1.345 -	            <list>
   1.346 -	                 <!-- Bean -->
   1.347 -	                <value>Query</value> 
   1.348 -	                <!-- Format -->
   1.349 -	                <value>HTML</value>   
   1.350 -	                <!-- Label -->
   1.351 -	                <value>[CLC] How many instances of a CLC class exist in a scene?</value> 
   1.352 -	                <!-- Statement -->
   1.353 -	                <value><![CDATA[PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
   1.354 -PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
   1.355 -PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
   1.356 -PREFIX strdf: <http://strdf.di.uoa.gr/ontology#>
   1.357 -PREFIX geof: <http://www.opengis.net/def/queryLanguage/OGC-GeoSPARQL/1.0/function/>
   1.358 -PREFIX lgd: <http://linkedgeodata.org/triplify/>
   1.359 -PREFIX lgdont: <http://linkedgeodata.org/ontology/>
   1.360 -PREFIX lgdgeo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
   1.361 -PREFIX geonames: <http://www.geonames.org/ontology#>
   1.362 -PREFIX teleios:<http://teleios.di.uoa.gr/ontologies/noaOntology.owl#>
   1.363 -PREFIX dlr: <http://www.earthobservatory.eu/ontologies/dlrOntology-v2.owl#>
   1.364 -
   1.365 -
   1.366 -SELECT ?clcLandUse (COUNT(DISTINCT ?clc) AS ?count)
   1.367 -WHERE {
   1.368 -   ?clc a teleios:Area .
   1.369 -   ?clc teleios:hasCode ?clcCode .
   1.370 -   ?clc teleios:hasLandUse ?clcLandUse .
   1.371 -   ?clc teleios:hasGeometry ?clcGeo .
   1.372 -
   1.373 -   #Venice
   1.374 -   FILTER (strdf:anyInteract(?clcGeo, "POLYGON ((12.301451 45.40493,12.398127 45.416817,12.386066 45.46502,12.289288 45.45313,12.301451 45.40493))"^^strdf:WKT)) .
   1.375 -   #Toulouse
   1.376 -   #FILTER (strdf:anyInteract(?clcGeo, "POLYGON((1.3816636 43.573734,1.4903361 43.588024,1.4783715 43.634777,1.3696271 43.620483,1.3816636 43.573734))"^^strdf:WKT)) .
   1.377 -   #Timisoara
   1.378 -   #FILTER (strdf:anyInteract(?clcGeo, "POLYGON((21.188068 45.7305,21.286903 45.74229,21.275377 45.79014,21.176264 45.778324,21.188068 45.7305))"^^strdf:WKT)) .
   1.379 -}
   1.380 -GROUP BY ?clcLandUse
   1.381 -ORDER BY DESC(?count)]]></value>
   1.382 -	                <!-- Description -->
   1.383 -					<value></value>
   1.384 -					<!-- Hander (plain, download, map or map_local)-->
   1.385 -					<value></value>
   1.386 -	            </list>
   1.387 -	            <list>
   1.388 -	                 <!-- Bean -->
   1.389 -	                <value>Query</value> 
   1.390 -	                <!-- Format -->
   1.391 -	                <value>HTML</value>   
   1.392 -	                <!-- Label -->
   1.393 -	                <value>[LGD] How many LGD classes are identified in a scene? (coarse-grained)</value> 
   1.394 -	                <!-- Statement -->
   1.395 -	                <value><![CDATA[PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
   1.396 -PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
   1.397 -PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
   1.398 -PREFIX strdf: <http://strdf.di.uoa.gr/ontology#>
   1.399 -PREFIX geof: <http://www.opengis.net/def/queryLanguage/OGC-GeoSPARQL/1.0/function/>
   1.400 -PREFIX lgd: <http://linkedgeodata.org/triplify/>
   1.401 -PREFIX lgdont: <http://linkedgeodata.org/ontology/>
   1.402 -PREFIX lgdgeo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
   1.403 -PREFIX geonames: <http://www.geonames.org/ontology#>
   1.404 -PREFIX teleios:<http://teleios.di.uoa.gr/ontologies/noaOntology.owl#>
   1.405 -PREFIX dlr: <http://www.earthobservatory.eu/ontologies/dlrOntology-v2.owl#>
   1.406 -
   1.407 -SELECT ?lgdType (COUNT(DISTINCT ?lgd) AS ?count)
   1.408 -WHERE {
   1.409 -   ?lgd lgdont:directType ?lgdDirectType .
   1.410 -   OPTIONAL {
   1.411 -      ?lgd a ?lgdType .
   1.412 -      FILTER ((?lgdType != lgdont:Node) && (?lgdType != ?lgdDirectType)) .
   1.413 -   }
   1.414 -   ?lgd lgdgeo:geometry ?lgdGeo .
   1.415 -   #Venice
   1.416 -   FILTER (strdf:anyInteract(?lgdGeo, "POLYGON ((12.301451 45.40493,12.398127 45.416817,12.386066 45.46502,12.289288 45.45313,12.301451 45.40493))"^^strdf:WKT)) .
   1.417 -   #Toulouse
   1.418 -   #FILTER (strdf:anyInteract(?lgdGeo, "POLYGON((1.3816636 43.573734,1.4903361 43.588024,1.4783715 43.634777,1.3696271 43.620483,1.3816636 43.573734))"^^strdf:WKT)) .
   1.419 -   #Timisoara
   1.420 -   #FILTER (strdf:anyInteract(?lgdGeo, "POLYGON((21.188068 45.7305,21.286903 45.74229,21.275377 45.79014,21.176264 45.778324,21.188068 45.7305))"^^strdf:WKT)) .
   1.421 -
   1.422 -}
   1.423 -GROUP BY ?lgdType
   1.424 -ORDER BY DESC(?count)]]></value>
   1.425 -	                <!-- Description -->
   1.426 -					<value></value>
   1.427 -					<!-- Hander (plain, download, map or map_local)-->
   1.428 -					<value></value>
   1.429 -	            </list>
   1.430 -	            <list>
   1.431 -	                 <!-- Bean -->
   1.432 -	                <value>Query</value> 
   1.433 -	                <!-- Format -->
   1.434 -	                <value>HTML</value>   
   1.435 -	                <!-- Label -->
   1.436 -	                <value>[LGD] How many LGD classes are identified in a scene? (fine-grained)</value> 
   1.437 -	                <!-- Statement -->
   1.438 -	                <value><![CDATA[PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
   1.439 -PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
   1.440 -PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
   1.441 -PREFIX strdf: <http://strdf.di.uoa.gr/ontology#>
   1.442 -PREFIX geof: <http://www.opengis.net/def/queryLanguage/OGC-GeoSPARQL/1.0/function/>
   1.443 -PREFIX lgd: <http://linkedgeodata.org/triplify/>
   1.444 -PREFIX lgdont: <http://linkedgeodata.org/ontology/>
   1.445 -PREFIX lgdgeo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
   1.446 -PREFIX geonames: <http://www.geonames.org/ontology#>
   1.447 -PREFIX teleios:<http://teleios.di.uoa.gr/ontologies/noaOntology.owl#>
   1.448 -PREFIX dlr: <http://www.earthobservatory.eu/ontologies/dlrOntology-v2.owl#>
   1.449 -
   1.450 -SELECT ?lgdDirectType (COUNT(DISTINCT ?lgd) AS ?count)
   1.451 -WHERE {
   1.452 -   ?lgd lgdont:directType ?lgdDirectType .
   1.453 -   OPTIONAL {
   1.454 -      ?lgd a ?lgdType .
   1.455 -      FILTER ((?lgdType != lgdont:Node) && (?lgdType != ?lgdDirectType)) .
   1.456 -   }
   1.457 -   ?lgd lgdgeo:geometry ?lgdGeo .
   1.458 -   #Venice
   1.459 -   FILTER (strdf:anyInteract(?lgdGeo, "POLYGON ((12.301451 45.40493,12.398127 45.416817,12.386066 45.46502,12.289288 45.45313,12.301451 45.40493))"^^strdf:WKT)) .
   1.460 -   #Toulouse
   1.461 -   #FILTER (strdf:anyInteract(?lgdGeo, "POLYGON((1.3816636 43.573734,1.4903361 43.588024,1.4783715 43.634777,1.3696271 43.620483,1.3816636 43.573734))"^^strdf:WKT)) .
   1.462 -   #Timisoara
   1.463 -   #FILTER (strdf:anyInteract(?lgdGeo, "POLYGON((21.188068 45.7305,21.286903 45.74229,21.275377 45.79014,21.176264 45.778324,21.188068 45.7305))"^^strdf:WKT)) .
   1.464 -
   1.465 -}
   1.466 -GROUP BY ?lgdDirectType
   1.467 -ORDER BY DESC(?count)]]></value>
   1.468 -	                <!-- Description -->
   1.469 -					<value></value>
   1.470 -					<!-- Hander (plain, download, map or map_local)-->
   1.471 -					<value></value>
   1.472 -	            </list>
   1.473 -	             <list>
   1.474 -	                 <!-- Bean -->
   1.475 -	                <value>Query</value> 
   1.476 -	                <!-- Format -->
   1.477 -	                <value>HTML</value>   
   1.478 -	                <!-- Label -->
   1.479 -	                <value>[Geonames] How many Geonames classes are identified in a scene?</value> 
   1.480 -	                <!-- Statement -->
   1.481 -	                <value><![CDATA[PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
   1.482 -PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
   1.483 -PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
   1.484 -PREFIX strdf: <http://strdf.di.uoa.gr/ontology#>
   1.485 -PREFIX geof: <http://www.opengis.net/def/queryLanguage/OGC-GeoSPARQL/1.0/function/>
   1.486 -PREFIX lgd: <http://linkedgeodata.org/triplify/>
   1.487 -PREFIX lgdont: <http://linkedgeodata.org/ontology/>
   1.488 -PREFIX lgdgeo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
   1.489 -PREFIX geonames: <http://www.geonames.org/ontology#>
   1.490 -PREFIX teleios:<http://teleios.di.uoa.gr/ontologies/noaOntology.owl#>
   1.491 -PREFIX dlr: <http://www.earthobservatory.eu/ontologies/dlrOntology-v2.owl#>
   1.492 -
   1.493 -SELECT ?geoFeature ?comment (COUNT(DISTINCT ?geoId) AS ?count)
   1.494 -WHERE {
   1.495 -?geoId geonames:name ?name .
   1.496 -OPTIONAL {?geoId geonames:alternateName ?altName } .
   1.497 -?geoId geonames:featureClass ?geoFeature .
   1.498 -?geoFeature rdfs:comment ?comment .
   1.499 -?geoId geonames:countryCode ?country .
   1.500 -?geoId teleios:hasGeography ?geoIdGeo .
   1.501 -   #Venice
   1.502 -   FILTER (strdf:anyInteract(?geoIdGeo, "POLYGON ((12.301451 45.40493,12.398127 45.416817,12.386066 45.46502,12.289288 45.45313,12.301451 45.40493))"^^strdf:WKT)) .
   1.503 -   #Toulouse
   1.504 -   #FILTER (strdf:anyInteract(?geoIdGeo, "POLYGON((1.3816636 43.573734,1.4903361 43.588024,1.4783715 43.634777,1.3696271 43.620483,1.3816636 43.573734))"^^strdf:WKT)) .
   1.505 -   #Timisoara
   1.506 -   #FILTER (strdf:anyInteract(?geoIdGeo, "POLYGON((21.188068 45.7305,21.286903 45.74229,21.275377 45.79014,21.176264 45.778324,21.188068 45.7305))"^^strdf:WKT)) .
   1.507 -}
   1.508 -GROUP BY ?geoFeature ?comment
   1.509 -ORDER BY DESC(?count)
   1.510 -	                ]]></value>
   1.511 +INSERT { ?h gag:hasMunicipality ?muni }
   1.512 +WHERE { 
   1.513 +SELECT ?h (SAMPLE(?mLabel) AS ?muni)
   1.514 +  WHERE {
   1.515 +	?h  rdf:type noa:Hotspot ;
   1.516 +		noa:hasGeometry ?hGeo ;
   1.517 +		noa:isDerivedFromSensor "MSG1_RSS"^^xsd:string ;
   1.518 +		noa:producedFromProcessingChain "DynamicThresholds"^^xsd:string ;
   1.519 +        noa:hasAcquisitionTime "TIMESTAMP"^^xsd:dateTime.
   1.520 +	?m	rdf:type gag:Dhmos ;
   1.521 +		rdfs:label ?mLabel ;
   1.522 +		gag:hasGeometry ?mGeo .
   1.523 +	FILTER(strdf:intersects(?hGeo, ?mGeo)) .
   1.524 +  }  
   1.525 +  GROUP BY ?h
   1.526 +}]]></value>
   1.527  	                <!-- Description -->
   1.528  					<value></value>
   1.529  					<!-- Hander (plain, download, map or map_local)-->
   1.530 @@ -545,7 +293,7 @@
   1.531  	            
   1.532  	            <list>
   1.533               		<!-- Single valued elements correspond to headers -->
   1.534 -					<value>Discover correlations between datasets</value>
   1.535 +					<value>Increase accuracy with respect to underlying area</value>
   1.536  	            </list>
   1.537  				<list>
   1.538  	                 <!-- Bean -->
   1.539 @@ -553,33 +301,25 @@
   1.540  	                <!-- Format -->
   1.541  	                <value>HTML</value>   
   1.542  	                <!-- Label -->
   1.543 -	                <value>[CLC-DLR] List all labels that are inside an area charatecterized as continuous urban fabric by CLC</value> 
   1.544 +	                <value>[NOA+GAG] Delete all hotspots that fall in the sea</value> 
   1.545  	                <!-- Statement -->
   1.546 -	                <value><![CDATA[PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
   1.547 -PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
   1.548 -PREFIX dlr: <http://www.earthobservatory.eu/ontologies/dlrOntology-v2.owl#>
   1.549 +	                <value><![CDATA[PREFIX noa: <http://teleios.di.uoa.gr/ontologies/noaOntology.owl#>
   1.550 +PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
   1.551 +PREFIX strdf: <http://strdf.di.uoa.gr/ontology#>
   1.552  PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
   1.553 -PREFIX strdf: <http://strdf.di.uoa.gr/ontology#>
   1.554 -PREFIX teleios:<http://teleios.di.uoa.gr/ontologies/noaOntology.owl#>
   1.555 -PREFIX geof:<http://www.opengis.net/def/queryLanguage/OGC-GeoSPARQL/1.0/function/>
   1.556 +PREFIX gag: <http://geo.linkedopendata.gr/greekadministrativeregion/ontology#>
   1.557  
   1.558 -SELECT DISTINCT ?clcLandUse ?annotation #?g 
   1.559 +INSERT {?h noa:isDiscarded "1"^^xsd:int ;
   1.560 +           noa:refinedBy noa:seaInconsistency .
   1.561 +} 
   1.562  WHERE {
   1.563 -   ?p rdf:type dlr:Patch .        
   1.564 -   ?p dlr:hasGeometry ?g .
   1.565 -   ?p dlr:hasLabel ?l .
   1.566 -   ?l rdf:type dlr:Label .
   1.567 -   ?l dlr:correspondsTo ?annotation .
   1.568 -   FILTER (strdf:anyInteract(?g, "POLYGON ((12.301451 45.40493,12.398127 45.416817,12.386066 45.46502,12.289288 45.45313,12.301451 45.40493))"^^strdf:WKT)) .
   1.569 -
   1.570 -   ?clc a ?clcType .
   1.571 -   ?clc teleios:hasCode ?clcCode .
   1.572 -   ?clc teleios:hasID ?clcID .
   1.573 -   ?clc teleios:hasLandUse teleios:continuousUrbanFabric .
   1.574 -   ?clc teleios:hasGeometry ?clcGeo .
   1.575 -   FILTER (strdf:anyInteract(?clcGeo, "POLYGON ((12.301451 45.40493,12.398127 45.416817,12.386066 45.46502,12.289288 45.45313,12.301451 45.40493))"^^strdf:WKT)) .
   1.576 -
   1.577 -   FILTER (geof:sf-contains(?clcGeo, ?g)) . 
   1.578 +?h   noa:hasAcquisitionTime "TIMESTAMP"^^xsd:dateTime ;
   1.579 +     noa:producedFromProcessingChain "DynamicThresholds"^^xsd:string ;
   1.580 +     noa:isDerivedFromSensor "MSG1_RSS"^^xsd:string .
   1.581 +       OPTIONAL {
   1.582 +    ?h	gag:hasMunicipality ?municipality .
   1.583 +  } 
   1.584 +  FILTER(!bound(?municipality)) .
   1.585  }
   1.586  	                ]]></value>
   1.587  	                <!-- Description -->
   1.588 @@ -593,36 +333,46 @@
   1.589  	                <!-- Format -->
   1.590  	                <value>HTML</value>   
   1.591  	                <!-- Label -->
   1.592 -	                <value>[CLC-DLR] List all CLC classes and the labels that are identified inside their instances.</value> 
   1.593 +	                <value>[NOA+Coastline] Delete the part of polygons that fall in the sea</value> 
   1.594  	                <!-- Statement -->
   1.595 -	                <value><![CDATA[PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
   1.596 -PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
   1.597 -PREFIX dlr: <http://www.earthobservatory.eu/ontologies/dlrOntology-v2.owl#>
   1.598 -PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
   1.599 -PREFIX strdf: <http://strdf.di.uoa.gr/ontology#>
   1.600 -PREFIX teleios:<http://teleios.di.uoa.gr/ontologies/noaOntology.owl#>
   1.601 -PREFIX geof:<http://www.opengis.net/def/queryLanguage/OGC-GeoSPARQL/1.0/function/>
   1.602 +	                <value><![CDATA[PREFIX noa: <http://teleios.di.uoa.gr/ontologies/noaOntology.owl#> 
   1.603 +PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> 
   1.604 +PREFIX strdf: <http://strdf.di.uoa.gr/ontology#> 
   1.605 +PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> 
   1.606 +PREFIX gag: <http://geo.linkedopendata.gr/greekadministrativeregion/ontology#>
   1.607  
   1.608 -SELECT ?clcLandUse(GROUP_CONCAT(DISTINCT ?annotation; separator=",\n\t\t\t\t\t ") AS ?annotations)  #?g 
   1.609 -WHERE {
   1.610 -   ?p rdf:type dlr:Patch .        
   1.611 -   ?p dlr:hasGeometry ?g .
   1.612 -   ?p dlr:hasLabel ?l .
   1.613 -   ?l rdf:type dlr:Label .
   1.614 -   ?l dlr:correspondsTo ?annotation .
   1.615 -   FILTER (strdf:anyInteract(?g, "POLYGON ((12.301451 45.40493,12.398127 45.416817,12.386066 45.46502,12.289288 45.45313,12.301451 45.40493))"^^strdf:WKT)) .
   1.616  
   1.617 -   ?clc a ?clcType .
   1.618 -   ?clc teleios:hasCode ?clcCode .
   1.619 -   ?clc teleios:hasID ?clcID .
   1.620 -   ?clc teleios:hasLandUse ?clcLandUse .
   1.621 -   ?clc teleios:hasGeometry ?clcGeo .
   1.622 -   FILTER (strdf:anyInteract(?clcGeo, "POLYGON ((12.301451 45.40493,12.398127 45.416817,12.386066 45.46502,12.289288 45.45313,12.301451 45.40493))"^^strdf:WKT)) .
   1.623 -
   1.624 -   FILTER (geof:sf-contains(?clcGeo, ?g)) . 
   1.625 +INSERT { ?h noa:isDiscarded "1"^^xsd:int . 
   1.626 +	    ?valid rdf:type noa:Hotspot ;
   1.627 +	    noa:hasConfidence ?conf ;
   1.628 +	    noa:hasGeometry ?dif ;
   1.629 +	    gag:hasMunicipality ?municipality ;
   1.630 +	    noa:hasAcquisitionTime "TIMESTAMP"^^xsd:dateTime ; 
   1.631 +	    noa:isDerivedFromSensor "MSG1_RSS"^^xsd:string ;
   1.632 +	    noa:hasConfirmation noa:unknown ;
   1.633 +	    noa:producedFromProcessingChain "DynamicThresholds"^^xsd:string ; 
   1.634 +	    noa:isProducedBy noa:noa ;
   1.635 +	    noa:isDerivedFromSatellite "METEOSAT8"^^xsd:string ;
   1.636 +            noa:refinedBy noa:coastlineRefinement ;
   1.637 +            noa:refinedBy ?refined .
   1.638  }
   1.639 -GROUP BY ?clcLandUse
   1.640 -	                ]]></value>
   1.641 +WHERE { 
   1.642 +  SELECT ?h  (strdf:intersection(?hGeo, strdf:union(?cGeo)) AS ?dif) (URI(CONCAT(STR(?h),"/refined")) AS ?valid) ?conf ?municipality
   1.643 +  WHERE { 
   1.644 +	 ?h     noa:hasAcquisitionTime "TIMESTAMP"^^xsd:dateTime; 
   1.645 +       		noa:producedFromProcessingChain "DynamicThresholds"^^xsd:string ; 
   1.646 +       		noa:isDerivedFromSensor "MSG1_RSS"^^xsd:string ;
   1.647 +		noa:hasGeometry ?hGeo ;
   1.648 +       		gag:hasMunicipality ?municipality ;
   1.649 +       		noa:hasConfidence ?conf .
   1.650 +	 ?c     rdf:type gag:GeometryPart ;
   1.651 +       		gag:hasGeometry ?cGeo .
   1.652 +       	FILTER(strdf:mbbIntersects(?hGeo, ?cGeo)) . 
   1.653 +	OPTIONAL { ?h noa:refinedBy ?refined } .
   1.654 +  }
   1.655 +  GROUP BY ?h ?hGeo ?conf ?municipality
   1.656 +  HAVING strdf:overlap(?hGeo, strdf:union(?cGeo))
   1.657 +}	                ]]></value>
   1.658  	                <!-- Description -->
   1.659  					<value></value>
   1.660  					<!-- Hander (plain, download, map or map_local)-->
   1.661 @@ -634,135 +384,31 @@
   1.662  	                <!-- Format -->
   1.663  	                <value>HTML</value>   
   1.664  	                <!-- Label -->
   1.665 -	                <value>[DLR-LGD] List all labels and the LGD classes with instances inside patches annotated with each label (coarse-grained).</value> 
   1.666 +	                <value>[NOA+CLC] Delete all hotspots that intersect with inconsistent areas</value> 
   1.667  	                <!-- Statement -->
   1.668 -	                <value><![CDATA[PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
   1.669 -PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
   1.670 -PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
   1.671 -PREFIX strdf: <http://strdf.di.uoa.gr/ontology#>
   1.672 -PREFIX geof: <http://www.opengis.net/def/queryLanguage/OGC-GeoSPARQL/1.0/function/>
   1.673 -PREFIX lgd: <http://linkedgeodata.org/triplify/>
   1.674 -PREFIX lgdont: <http://linkedgeodata.org/ontology/>
   1.675 -PREFIX lgdgeo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
   1.676 -PREFIX geonames: <http://www.geonames.org/ontology#>
   1.677 -PREFIX teleios:<http://teleios.di.uoa.gr/ontologies/noaOntology.owl#>
   1.678 -PREFIX dlr: <http://www.earthobservatory.eu/ontologies/dlrOntology-v2.owl#>
   1.679 +	                <value><![CDATA[PREFIX noa: <http://teleios.di.uoa.gr/ontologies/noaOntology.owl#> 
   1.680 +PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> 
   1.681 +PREFIX strdf: <http://strdf.di.uoa.gr/ontology#> 
   1.682 +PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> 
   1.683 +PREFIX clc: <http://geo.linkedopendata.gr/corine/ontology#>
   1.684  
   1.685 -SELECT ?annotation (GROUP_CONCAT(DISTINCT ?lgdType; separator=",\n\t\t\t\t\t ") AS ?lgdTypes)  #?g 
   1.686 +INSERT {?h noa:isDiscarded "1"^^xsd:int ;
   1.687 +           noa:refinedBy noa:clcInconsistency .
   1.688 +} 
   1.689  WHERE {
   1.690 -   ?p rdf:type dlr:Patch .        
   1.691 -   ?p dlr:hasGeometry ?g .
   1.692 -   ?p dlr:hasLabel ?l .
   1.693 -   ?l rdf:type dlr:Label .
   1.694 -   ?l dlr:correspondsTo ?annotation .
   1.695 -   FILTER (strdf:anyInteract(?g, "POLYGON ((12.301451 45.40493,12.398127 45.416817,12.386066 45.46502,12.289288 45.45313,12.301451 45.40493))"^^strdf:WKT)) .
   1.696 -
   1.697 -   ?lgd lgdont:directType ?lgdDirectType .
   1.698 -   OPTIONAL {
   1.699 -      ?lgd a ?lgdType .
   1.700 -      FILTER ((?lgdType != lgdont:Node) && (?lgdType != ?lgdDirectType)) .
   1.701 -   }
   1.702 -   ?lgd lgdgeo:geometry ?lgdGeo .
   1.703 -   FILTER (strdf:anyInteract(?lgdGeo, "POLYGON ((12.301451 45.40493,12.398127 45.416817,12.386066 45.46502,12.289288 45.45313,12.301451 45.40493))"^^strdf:WKT)) .
   1.704 -   
   1.705 -   FILTER (geof:sf-contains(?g, ?lgdGeo)) . 
   1.706 -}
   1.707 -GROUP BY ?annotation
   1.708 -ORDER BY ?annotation]]></value>
   1.709 -	                <!-- Description -->
   1.710 -					<value></value>
   1.711 -					<!-- Hander (plain, download, map or map_local)-->
   1.712 -					<value>plain</value>
   1.713 -	            </list>
   1.714 -	             <list>
   1.715 -	                 <!-- Bean -->
   1.716 -	                <value>Query</value> 
   1.717 -	                <!-- Format -->
   1.718 -	                <value>HTML</value>   
   1.719 -	                <!-- Label -->
   1.720 -	                <value>[DLR-LGD] List all labels and the LGD classes with instances inside patches annotated with each label (fine-grained).</value> 
   1.721 -	                <!-- Statement -->
   1.722 -	                <value><![CDATA[PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
   1.723 -PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
   1.724 -PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
   1.725 -PREFIX strdf: <http://strdf.di.uoa.gr/ontology#>
   1.726 -PREFIX geof: <http://www.opengis.net/def/queryLanguage/OGC-GeoSPARQL/1.0/function/>
   1.727 -PREFIX lgd: <http://linkedgeodata.org/triplify/>
   1.728 -PREFIX lgdont: <http://linkedgeodata.org/ontology/>
   1.729 -PREFIX lgdgeo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
   1.730 -PREFIX geonames: <http://www.geonames.org/ontology#>
   1.731 -PREFIX teleios:<http://teleios.di.uoa.gr/ontologies/noaOntology.owl#>
   1.732 -PREFIX dlr: <http://www.earthobservatory.eu/ontologies/dlrOntology-v2.owl#>
   1.733 -
   1.734 -SELECT ?annotation (GROUP_CONCAT(DISTINCT ?lgdDirectType; separator=",\n\t\t\t\t\t ") AS ?lgdDirectTypes)  #?g 
   1.735 -WHERE {
   1.736 -   ?p rdf:type dlr:Patch .        
   1.737 -   ?p dlr:hasGeometry ?g .
   1.738 -   ?p dlr:hasLabel ?l .
   1.739 -   ?l rdf:type dlr:Label .
   1.740 -   ?l dlr:correspondsTo ?annotation .
   1.741 -   FILTER (strdf:anyInteract(?g, "POLYGON ((12.301451 45.40493,12.398127 45.416817,12.386066 45.46502,12.289288 45.45313,12.301451 45.40493))"^^strdf:WKT)) .
   1.742 -
   1.743 -    ?lgd lgdont:directType ?lgdDirectType .
   1.744 -   OPTIONAL {
   1.745 -      ?lgd a ?lgdType .
   1.746 -      FILTER ((?lgdType != lgdont:Node) && (?lgdType != ?lgdDirectType)) .
   1.747 -   }
   1.748 -   ?lgd lgdgeo:geometry ?lgdGeo .
   1.749 -   #Venice
   1.750 -   FILTER (strdf:anyInteract(?lgdGeo, "POLYGON ((12.301451 45.40493,12.398127 45.416817,12.386066 45.46502,12.289288 45.45313,12.301451 45.40493))"^^strdf:WKT)) .
   1.751 -   
   1.752 -   FILTER (geof:sf-contains(?g, ?lgdGeo)) . 
   1.753 -}
   1.754 -GROUP BY ?annotation
   1.755 -ORDER BY ?annotation]]></value>
   1.756 -	                <!-- Description -->
   1.757 -					<value></value>
   1.758 -					<!-- Hander (plain, download, map or map_local)-->
   1.759 -					<value>plain</value>
   1.760 -	            </list>
   1.761 -	             <list>
   1.762 -	                 <!-- Bean -->
   1.763 -	                <value>Query</value> 
   1.764 -	                <!-- Format -->
   1.765 -	                <value>HTML</value>   
   1.766 -	                <!-- Label -->
   1.767 -	                <value>[DLR-Geonames] List all labels and the GeoNames classes with instances inside patches annotated with each label.</value> 
   1.768 -	                <!-- Statement -->
   1.769 -	                <value><![CDATA[PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
   1.770 -PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
   1.771 -PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
   1.772 -PREFIX strdf: <http://strdf.di.uoa.gr/ontology#>
   1.773 -PREFIX geof: <http://www.opengis.net/def/queryLanguage/OGC-GeoSPARQL/1.0/function/>
   1.774 -PREFIX lgd: <http://linkedgeodata.org/triplify/>
   1.775 -PREFIX lgdont: <http://linkedgeodata.org/ontology/>
   1.776 -PREFIX lgdgeo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
   1.777 -PREFIX geonames: <http://www.geonames.org/ontology#>
   1.778 -PREFIX teleios:<http://teleios.di.uoa.gr/ontologies/noaOntology.owl#>
   1.779 -PREFIX dlr: <http://www.earthobservatory.eu/ontologies/dlrOntology-v2.owl#>
   1.780 -
   1.781 -SELECT ?annotation (GROUP_CONCAT(DISTINCT ?geoFeature; separator=",\n\t\t\t\t\t ") AS ?geoFeatures)  (GROUP_CONCAT(DISTINCT ?comment; separator=",\n\t\t\t\t\t ") AS ?comments)
   1.782 -WHERE {
   1.783 -   ?p rdf:type dlr:Patch .        
   1.784 -   ?p dlr:hasGeometry ?g .
   1.785 -   ?p dlr:hasLabel ?l .
   1.786 -   ?l rdf:type dlr:Label .
   1.787 -   ?l dlr:correspondsTo ?annotation .
   1.788 -   FILTER (strdf:anyInteract(?g, "POLYGON ((12.301451 45.40493,12.398127 45.416817,12.386066 45.46502,12.289288 45.45313,12.301451 45.40493))"^^strdf:WKT)) .
   1.789 -
   1.790 -   ?geoId geonames:name ?name .
   1.791 -   OPTIONAL {?geoId geonames:alternateName ?altName } .
   1.792 -   ?geoId geonames:featureClass ?geoFeature .
   1.793 -   ?geoFeature rdfs:comment ?comment .
   1.794 -   ?geoId geonames:countryCode ?country .
   1.795 -   ?geoId teleios:hasGeography ?geoIdGeo .
   1.796 -   #Venice
   1.797 -   FILTER (strdf:anyInteract(?geoIdGeo, "POLYGON ((12.301451 45.40493,12.398127 45.416817,12.386066 45.46502,12.289288 45.45313,12.301451 45.40493))"^^strdf:WKT)) .
   1.798 -   
   1.799 -   FILTER (geof:sf-contains(?g, ?geoIdGeo)) . 
   1.800 -}
   1.801 -GROUP BY ?annotation
   1.802 -ORDER BY ?annotation]]></value>
   1.803 +	SELECT ?h WHERE 
   1.804 +	{
   1.805 +		?h  noa:hasAcquisitionTime "TIMESTAMP"^^xsd:dateTime ;
   1.806 +			noa:producedFromProcessingChain "PROCESSING_CHAIN"^^xsd:string ;
   1.807 +			noa:isDerivedFromSensor "SENSOR"^^xsd:string ;
   1.808 +			noa:hasGeometry ?hGeo.
   1.809 +		?a  rdf:type   clc:ExcludeArea;
   1.810 +			clc:hasGeometry ?aGeo.
   1.811 +		FILTER(strdf:mbbIntersects(?hGeo,?aGeo)).
   1.812 +	} 
   1.813 +	GROUP BY ?h ?hGeo
   1.814 +	HAVING strdf:contains(strdf:union(?aGeo),?hGeo)
   1.815 +}]]></value>
   1.816  	                <!-- Description -->
   1.817  					<value></value>
   1.818  					<!-- Hander (plain, download, map or map_local)-->
   1.819 @@ -770,7 +416,7 @@
   1.820  	            </list>
   1.821  	            <list>
   1.822               		<!-- Single valued elements correspond to headers -->
   1.823 -					<value>Second level statistics</value>
   1.824 +					<value>Increase accuracy with respect to time persistence</value>
   1.825  	            </list>
   1.826  				<list>
   1.827  	                 <!-- Bean -->
   1.828 @@ -778,193 +424,55 @@
   1.829  	                <!-- Format -->
   1.830  	                <value>HTML</value>   
   1.831  	                <!-- Label -->
   1.832 -	                <value>[CLC-DLR] How many patches with a specific label are contained by a CLC area?</value> 
   1.833 +	                <value>[NOA] Add virtual hotspots accoring to time persistence of actually detected hotspots</value> 
   1.834  	                <!-- Statement -->
   1.835 -	                <value><![CDATA[PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
   1.836 -PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
   1.837 -PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
   1.838 -PREFIX strdf: <http://strdf.di.uoa.gr/ontology#>
   1.839 -PREFIX geof: <http://www.opengis.net/def/queryLanguage/OGC-GeoSPARQL/1.0/function/>
   1.840 -PREFIX lgd: <http://linkedgeodata.org/triplify/>
   1.841 -PREFIX lgdont: <http://linkedgeodata.org/ontology/>
   1.842 -PREFIX lgdgeo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
   1.843 -PREFIX geonames: <http://www.geonames.org/ontology#>
   1.844 -PREFIX teleios:<http://teleios.di.uoa.gr/ontologies/noaOntology.owl#>
   1.845 -PREFIX dlr: <http://www.earthobservatory.eu/ontologies/dlrOntology-v2.owl#>
   1.846 +	                <value><![CDATA[PREFIX noa: <http://teleios.di.uoa.gr/ontologies/noaOntology.owl#> 
   1.847 +PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> 
   1.848 +PREFIX strdf: <http://strdf.di.uoa.gr/ontology#> 
   1.849 +PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> 
   1.850 +PREFIX gag: <http://geo.linkedopendata.gr/greekadministrativeregion/ontology#>
   1.851  
   1.852 -SELECT ?clcLandUse ?annotation (COUNT(?p) AS ?numberOfPatches)
   1.853 +INSERT {?newHotspot rdf:type noa:Hotspot ;
   1.854 +		    noa:hasConfidence ?hConfidence ;
   1.855 +		    noa:hasGeometry ?hGeometry1 ;
   1.856 +		    noa:hasAcquisitionTime "TIMESTAMP"^^xsd:dateTime ; 
   1.857 +		    noa:isDerivedFromSensor "MSG1_RSS"^^xsd:string ;
   1.858 +		    noa:hasConfirmation noa:unknown ;
   1.859 +		    noa:producedFromProcessingChain "DynamicThresholds-TimePersistence"^^xsd:string ; 
   1.860 +		    noa:isProducedBy noa:noa ;
   1.861 +		    gag:hasMunicipality ?hMunicipality1 ;
   1.862 +		    noa:isDerivedFromSatellite "METEOSAT8"^^xsd:string ;
   1.863 +                    noa:refinedBy noa:temporalPersistence ;
   1.864 +                    noa:refinedBy ?refined .
   1.865 +}
   1.866  WHERE {
   1.867 -   #select corine areas
   1.868 -   ?clc a teleios:Area .
   1.869 -   ?clc teleios:hasLandUse ?clcLandUse .
   1.870 -   ?clc teleios:hasGeometry ?clcGeo .
   1.871 -   #Venice
   1.872 -   FILTER (strdf:anyInteract(?clcGeo, "POLYGON ((12.301451 45.40493,12.398127 45.416817,12.386066 45.46502,12.289288 45.45313,12.301451 45.40493))"^^strdf:WKT)) .
   1.873 -   #Toulouse
   1.874 -   #FILTER (strdf:anyInteract(?clcGeo, "POLYGON((1.3816636 43.573734,1.4903361 43.588024,1.4783715 43.634777,1.3696271 43.620483,1.3816636 43.573734))"^^strdf:WKT)) .
   1.875 -   #Timisoara
   1.876 -   #FILTER (strdf:anyInteract(?clcGeo, "POLYGON((21.188068 45.7305,21.286903 45.74229,21.275377 45.79014,21.176264 45.778324,21.188068 45.7305))"^^strdf:WKT)) .
   1.877 -
   1.878 -   #select patches
   1.879 -   ?p rdf:type dlr:Patch .        
   1.880 -   ?p dlr:hasGeometry ?g .
   1.881 -   ?p dlr:hasLabel ?l .
   1.882 -   ?l dlr:correspondsTo ?annotation .
   1.883 -   #Venice
   1.884 -   FILTER (strdf:anyInteract(?g, "POLYGON ((12.301451 45.40493,12.398127 45.416817,12.386066 45.46502,12.289288 45.45313,12.301451 45.40493))"^^strdf:WKT)) .
   1.885 -   #Toulouse
   1.886 -   #FILTER (strdf:anyInteract(?g, "POLYGON((1.3816636 43.573734,1.4903361 43.588024,1.4783715 43.634777,1.3696271 43.620483,1.3816636 43.573734))"^^strdf:WKT)) .
   1.887 -   #Timisoara
   1.888 -   #FILTER (strdf:anyInteract(?g, "POLYGON((21.188068 45.7305,21.286903 45.74229,21.275377 45.79014,21.176264 45.778324,21.188068 45.7305))"^^strdf:WKT)) .
   1.889 -   
   1.890 -   #FILTER (geof:sf-contains(?clcGeo, ?g)) .
   1.891 -   FILTER (strdf:contains(?clcGeo, ?g)) .
   1.892 -}
   1.893 -GROUP BY ?clcLandUse ?annotation
   1.894 -ORDER BY ?clcLandUse DESC(?numberOfPatches)]]></value>
   1.895 -	                <!-- Description -->
   1.896 -					<value></value>
   1.897 -					<!-- Hander (plain, download, map or map_local)-->
   1.898 -					<value>plain</value>
   1.899 -	            </list>
   1.900 -	             <list>
   1.901 -	                 <!-- Bean -->
   1.902 -	                <value>Query</value> 
   1.903 -	                <!-- Format -->
   1.904 -	                <value>HTML</value>   
   1.905 -	                <!-- Label -->
   1.906 -	                <value>[DLR-LGD] How many LGD instances are contained by a patch annotated with a specific label? (coarse-grained)</value> 
   1.907 -	                <!-- Statement -->
   1.908 -	                <value><![CDATA[PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
   1.909 -PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
   1.910 -PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
   1.911 -PREFIX strdf: <http://strdf.di.uoa.gr/ontology#>
   1.912 -PREFIX geof: <http://www.opengis.net/def/queryLanguage/OGC-GeoSPARQL/1.0/function/>
   1.913 -PREFIX lgd: <http://linkedgeodata.org/triplify/>
   1.914 -PREFIX lgdont: <http://linkedgeodata.org/ontology/>
   1.915 -PREFIX lgdgeo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
   1.916 -PREFIX geonames: <http://www.geonames.org/ontology#>
   1.917 -PREFIX teleios:<http://teleios.di.uoa.gr/ontologies/noaOntology.owl#>
   1.918 -PREFIX dlr: <http://www.earthobservatory.eu/ontologies/dlrOntology-v2.owl#>
   1.919 -
   1.920 -SELECT ?annotation ?lgdType (COUNT(?lgd) AS ?lgdInstances)
   1.921 -WHERE {
   1.922 -   #select patches
   1.923 -   ?p rdf:type dlr:Patch .        
   1.924 -   ?p dlr:hasGeometry ?g .
   1.925 -   ?p dlr:hasLabel ?l .
   1.926 -   ?l dlr:correspondsTo ?annotation .
   1.927 -   #Venice
   1.928 -   FILTER (strdf:anyInteract(?g, "POLYGON ((12.301451 45.40493,12.398127 45.416817,12.386066 45.46502,12.289288 45.45313,12.301451 45.40493))"^^strdf:WKT)) .   
   1.929 -   
   1.930 -   #select LGD instances
   1.931 -   ?lgd lgdont:directType ?lgdDirectType .
   1.932 -   ?lgd a ?lgdType .
   1.933 -   FILTER ((?lgdType != lgdont:Node) && (?lgdType != ?lgdDirectType)) .
   1.934 -   ?lgd lgdgeo:geometry ?lgdGeo .
   1.935 -   #Venice
   1.936 -   FILTER (strdf:anyInteract(?lgdGeo, "POLYGON ((12.301451 45.40493,12.398127 45.416817,12.386066 45.46502,12.289288 45.45313,12.301451 45.40493))"^^strdf:WKT)) .
   1.937 -   
   1.938 -   FILTER (geof:sf-contains(?g, ?lgdGeo)) .
   1.939 -}
   1.940 -GROUP BY ?annotation ?lgdType
   1.941 -ORDER BY ?annotation DESC(?lgdInstances)]]></value>
   1.942 -	                <!-- Description -->
   1.943 -					<value></value>
   1.944 -					<!-- Hander (plain, download, map or map_local)-->
   1.945 -					<value>plain</value>
   1.946 -	            </list>
   1.947 -				<list>
   1.948 -	                 <!-- Bean -->
   1.949 -	                <value>Query</value> 
   1.950 -	                <!-- Format -->
   1.951 -	                <value>HTML</value>   
   1.952 -	                <!-- Label -->
   1.953 -	                <value>[DLR-LGD] How many LGD instances are contained by a patch annotated with a specific label? (fine-grained)</value> 
   1.954 -	                <!-- Statement -->
   1.955 -	                <value><![CDATA[PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
   1.956 -PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
   1.957 -PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
   1.958 -PREFIX strdf: <http://strdf.di.uoa.gr/ontology#>
   1.959 -PREFIX geof: <http://www.opengis.net/def/queryLanguage/OGC-GeoSPARQL/1.0/function/>
   1.960 -PREFIX lgd: <http://linkedgeodata.org/triplify/>
   1.961 -PREFIX lgdont: <http://linkedgeodata.org/ontology/>
   1.962 -PREFIX lgdgeo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
   1.963 -PREFIX geonames: <http://www.geonames.org/ontology#>
   1.964 -PREFIX teleios:<http://teleios.di.uoa.gr/ontologies/noaOntology.owl#>
   1.965 -PREFIX dlr: <http://www.earthobservatory.eu/ontologies/dlrOntology-v2.owl#>
   1.966 -
   1.967 -SELECT ?annotation ?lgdDirectType (COUNT(?lgd) AS ?lgdInstances)
   1.968 -WHERE {
   1.969 -   #select patches
   1.970 -   ?p rdf:type dlr:Patch .        
   1.971 -   ?p dlr:hasGeometry ?g .
   1.972 -   ?p dlr:hasLabel ?l .
   1.973 -   ?l dlr:correspondsTo ?annotation .
   1.974 -   #Venice
   1.975 -   FILTER (strdf:anyInteract(?g, "POLYGON ((12.301451 45.40493,12.398127 45.416817,12.386066 45.46502,12.289288 45.45313,12.301451 45.40493))"^^strdf:WKT)) .   
   1.976 -   
   1.977 -   #select LGD instances
   1.978 -   ?lgd lgdont:directType ?lgdDirectType .
   1.979 -   ?lgd a ?lgdType .
   1.980 -   FILTER ((?lgdType != lgdont:Node) && (?lgdType != ?lgdDirectType)) .
   1.981 -   ?lgd lgdgeo:geometry ?lgdGeo .
   1.982 -   #Venice
   1.983 -   FILTER (strdf:anyInteract(?lgdGeo, "POLYGON ((12.301451 45.40493,12.398127 45.416817,12.386066 45.46502,12.289288 45.45313,12.301451 45.40493))"^^strdf:WKT)) .
   1.984 -   
   1.985 -   FILTER (geof:sf-contains(?g, ?lgdGeo)) .
   1.986 -}
   1.987 -GROUP BY ?annotation ?lgdDirectType
   1.988 -ORDER BY ?annotation DESC(?lgdInstances)]]></value>
   1.989 -	                <!-- Description -->
   1.990 -					<value></value>
   1.991 -					<!-- Hander (plain, download, map or map_local)-->
   1.992 -					<value>plain</value>
   1.993 -	            </list>
   1.994 -				<list>
   1.995 -	                 <!-- Bean -->
   1.996 -	                <value>Query</value> 
   1.997 -	                <!-- Format -->
   1.998 -	                <value>HTML</value>   
   1.999 -	                <!-- Label -->
  1.1000 -	                <value>[DLR-Geonames] How many Geonames instances are contained by a patch annotated with a specific label?</value> 
  1.1001 -	                <!-- Statement -->
  1.1002 -	                <value><![CDATA[PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
  1.1003 -PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
  1.1004 -PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
  1.1005 -PREFIX strdf: <http://strdf.di.uoa.gr/ontology#>
  1.1006 -PREFIX geof: <http://www.opengis.net/def/queryLanguage/OGC-GeoSPARQL/1.0/function/>
  1.1007 -PREFIX lgd: <http://linkedgeodata.org/triplify/>
  1.1008 -PREFIX lgdont: <http://linkedgeodata.org/ontology/>
  1.1009 -PREFIX lgdgeo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
  1.1010 -PREFIX geonames: <http://www.geonames.org/ontology#>
  1.1011 -PREFIX teleios:<http://teleios.di.uoa.gr/ontologies/noaOntology.owl#>
  1.1012 -PREFIX dlr: <http://www.earthobservatory.eu/ontologies/dlrOntology-v2.owl#>
  1.1013 -
  1.1014 -SELECT ?annotation ?geoFeature ?comment (COUNT(?geoId) AS ?geoIdInstances)
  1.1015 -WHERE {
  1.1016 -   #select patches
  1.1017 -   ?p rdf:type dlr:Patch .        
  1.1018 -   ?p dlr:hasGeometry ?g .
  1.1019 -   ?p dlr:hasLabel ?l .
  1.1020 -   ?l dlr:correspondsTo ?annotation .
  1.1021 -   #Venice
  1.1022 -   FILTER (strdf:anyInteract(?g, "POLYGON ((12.301451 45.40493,12.398127 45.416817,12.386066 45.46502,12.289288 45.45313,12.301451 45.40493))"^^strdf:WKT)) .   
  1.1023 -   
  1.1024 -   #select Geonames instances
  1.1025 -   ?geoId geonames:name ?name .
  1.1026 -   OPTIONAL {?geoId geonames:alternateName ?altName } .
  1.1027 -   ?geoId geonames:featureClass ?geoFeature .
  1.1028 -   ?geoFeature rdfs:comment ?comment .
  1.1029 -   ?geoId geonames:countryCode ?country .
  1.1030 -   ?geoId teleios:hasGeography ?geoIdGeo .
  1.1031 -   #Venice
  1.1032 -   FILTER (strdf:anyInteract(?geoIdGeo, "POLYGON ((12.301451 45.40493,12.398127 45.416817,12.386066 45.46502,12.289288 45.45313,12.301451 45.40493))"^^strdf:WKT)) .
  1.1033 -   
  1.1034 -   FILTER (geof:sf-contains(?g, ?geoIdGeo)) .
  1.1035 -}
  1.1036 -GROUP BY ?annotation ?geoFeature ?comment
  1.1037 -ORDER BY ?annotation DESC(?geoIdInstances)]]></value>
  1.1038 +	SELECT  (URI(CONCAT(STR(MAX(?h1)),"/virtual/NEW_HOTSPOT")) AS ?newHotspot)
  1.1039 +			(SUM(?hConfidence1)/ACQUISITIONS_IN_HALF_AN_HOUR AS ?hConfidence)
  1.1040 +			?hGeometry1 ?hMunicipality1
  1.1041 +  WHERE {
  1.1042 +    ?h1 noa:hasConfidence ?hConfidence1 ;
  1.1043 +        noa:hasGeometry ?hGeometry1 ;
  1.1044 +        gag:hasMunicipality ?hMunicipality1 ;
  1.1045 +        noa:hasAcquisitionTime ?hAcquisitionTime1 ;
  1.1046 +        noa:isDerivedFromSensor "MSG1_RSS"^^xsd:string ;
  1.1047 +        noa:producedFromProcessingChain "DynamicThresholds"^^xsd:string .
  1.1048 +    OPTIONAL { ?h1 noa:isDiscarded ?z } .
  1.1049 +    FILTER (!BOUND(?z)) .
  1.1050 +    OPTIONAL { ?h1 noa:refinedBy ?refined } .
  1.1051 +    FILTER( "MIN_ACQUISITION_TIME"^^xsd:dateTime <= ?hAcquisitionTime1 && ?hAcquisitionTime1 < "TIMESTAMP"^^xsd:dateTime ) .
  1.1052 +    OPTIONAL {
  1.1053 +      ?h2 noa:hasGeometry ?hGeometry2 ;
  1.1054 +          noa:hasAcquisitionTime "TIMESTAMP"^^xsd:dateTime ;
  1.1055 +          noa:isDerivedFromSensor "MSG1_RSS"^^xsd:string ;
  1.1056 +          noa:producedFromProcessingChain ?hProcessingChain2 .
  1.1057 +      FILTER(("DynamicThresholds"^^xsd:string = ?hProcessingChain2)||("DynamicThresholds-TimePersistence"^^xsd:string = ?hProcessingChain2)).
  1.1058 +      FILTER( strdf:mbbEquals(?hGeometry1, ?hGeometry2) ) .
  1.1059 +    }
  1.1060 +    FILTER( !BOUND(?h2) ) .
  1.1061 +  }
  1.1062 +  GROUP BY ?hGeometry1 ?hMunicipality1
  1.1063 +  HAVING(SUM(?hConfidence1)>0.0)
  1.1064 +}]]></value>
  1.1065  	                <!-- Description -->
  1.1066  					<value></value>
  1.1067  					<!-- Hander (plain, download, map or map_local)-->