OpenSPARQL

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
SELECT DISTINCT  ?VALUE
  FROM <http://lsm.deri.ie/OpenIoT/guest_demo/sensordata#>
  WHERE
  {
    {
      SELECT DISTINCT AVG(?DATA) AS ?VALUE
      WHERE
      {
        ?record <http://openiot.eu/ontology/ns/value> ?DATA .
        ?record <http://www.w3.org/2000/01/rdf-schema#label> 'temperature' .
        ?record <http://openiot.eu/ontology/ns/isObservedValueOf> ?sensor .
        ?sensor <http://purl.oclc.org/NET/ssnx/ssn#observedBy> ?sensorId .
        {
          SELECT ?sensorId
          FROM <http://lsm.deri.ie/OpenIoT/guest_demo/sensormeta#>
          WHERE
          {
            ?sensorId <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://openiot.eu/ontology/ns/Netatmo> .
            ?sensorId <http://www.loa-cnr.it/ontologies/DUL.owl#hasLocation> ?loc .
            ?loc geo:geometry ?geo .
            FILTER (<bif:st_intersects>(?geo, <bif:st_point>( -9.054708480834961, 53.27325144835949), 15.0)) .
          }
        }
      }
    }
  }
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%