RequestDefinitionCodeView

  # [1 / 2] visualization type: 'LineChart' and sensors of type:
  #      - http://openiot.eu/ontology/ns/Netatmo
  # Generated: Thu May 26 16:24:06 BST 2016
  SELECT DISTINCT  ?y1 ?x1_day ?x1_month ?x1_year
  FROM <http://lsm.deri.ie/OpenIoT/guest_demo/sensordata#>
  WHERE
  {
    {
      SELECT DISTINCT AVG(?graphNodeEndpoint_78277309285910) AS ?y1 AVG( fn:day-from-dateTime(?graphNode_78277309124883_recordTime) ) AS ?x1_day AVG( fn:month-from-dateTime(?graphNode_78277309124883_recordTime) ) AS ?x1_month AVG( fn:year-from-dateTime(?graphNode_78277309124883_recordTime) ) AS ?x1_year
      WHERE
      {
        ?graphNode_78277309124883_record <http://openiot.eu/ontology/ns/value> ?graphNodeEndpoint_78277309285910 .
        ?graphNode_78277309124883_record <http://www.w3.org/2000/01/rdf-schema#label> 'temperature' .
        ?graphNode_78277309124883_record <http://purl.oclc.org/NET/ssnx/ssn#observationResultTime> ?graphNode_78277309124883_recordTime .
        ?graphNode_78277309124883_record <http://openiot.eu/ontology/ns/isObservedValueOf> ?graphNode_78277309124883_sensor .
        ?graphNode_78277309124883_sensor <http://purl.oclc.org/NET/ssnx/ssn#observedBy> ?graphNode_78277309124883_sensorId .
        {
          SELECT ?graphNode_78277309124883_sensorId
          FROM <http://lsm.deri.ie/OpenIoT/guest_demo/sensormeta#>
          WHERE
          {
            ?graphNode_78277309124883_sensorId <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://openiot.eu/ontology/ns/Netatmo> .
            <http://openiot.eu/ontology/ns/Netatmo> <http://www.w3.org/2000/01/rdf-schema#subClassOf> <http://purl.oclc.org/NET/ssnx/ssn#Sensor> .
            ?graphNode_78277309124883_sensorId <http://www.loa-cnr.it/ontologies/DUL.owl#hasLocation> ?graphNode_78277309124883_loc .
            ?graphNode_78277309124883_loc geo:geometry ?graphNode_78277309124883_geo .
            ?graphNode_78277309124883_loc geo:lat ?graphNode_78277309124883_lat .
            ?graphNode_78277309124883_loc geo:long ?graphNode_78277309124883_lon .
            FILTER (<bif:st_intersects>(?graphNode_78277309124883_geo, <bif:st_point>( -9.058075905195437, 53.26871905960906), 15.0)) .
          }
        }
        FILTER (?graphNode_78277309124883_recordTime >= "2016-04-01T16:13:00.000+01:00"^^xsd:date AND ?graphNode_78277309124883_recordTime <= "2016-04-30T16:13:00.000+01:00"^^xsd:date ).
      }
      GROUP BY         ( fn:year-from-dateTime(?graphNode_78277309124883_recordTime) )         ( fn:month-from-dateTime(?graphNode_78277309124883_recordTime) )         ( fn:day-from-dateTime(?graphNode_78277309124883_recordTime) )
      ORDER BY         ( fn:year-from-dateTime(?graphNode_78277309124883_recordTime) )         ( fn:month-from-dateTime(?graphNode_78277309124883_recordTime) )         ( fn:day-from-dateTime(?graphNode_78277309124883_recordTime) )
    }
  }


#-----------------------------------

  # [2 / 2] visualization type: 'LineChart' and sensors of type:
  #      - http://openiot.eu/ontology/ns/Netatmo
  # Generated: Thu May 26 16:24:06 BST 2016
  SELECT DISTINCT  ?y2 ?x2_day ?x2_month
  FROM <http://lsm.deri.ie/OpenIoT/guest_demo/sensordata#>
  WHERE
  {
    {
      SELECT DISTINCT AVG(?graphNodeEndpoint_78277309291218) AS ?y2 AVG( fn:day-from-dateTime(?graphNode_78277309124883_recordTime) ) AS ?x2_day AVG( fn:month-from-dateTime(?graphNode_78277309124883_recordTime) ) AS ?x2_month
      WHERE
      {
        ?graphNode_78277309124883_record <http://openiot.eu/ontology/ns/value> ?graphNodeEndpoint_78277309291218 .
        ?graphNode_78277309124883_record <http://www.w3.org/2000/01/rdf-schema#label> 'humidity' .
        ?graphNode_78277309124883_record <http://purl.oclc.org/NET/ssnx/ssn#observationResultTime> ?graphNode_78277309124883_recordTime .
        ?graphNode_78277309124883_record <http://openiot.eu/ontology/ns/isObservedValueOf> ?graphNode_78277309124883_sensor .
        ?graphNode_78277309124883_sensor <http://purl.oclc.org/NET/ssnx/ssn#observedBy> ?graphNode_78277309124883_sensorId .
        {
          SELECT ?graphNode_78277309124883_sensorId
          FROM <http://lsm.deri.ie/OpenIoT/guest_demo/sensormeta#>
          WHERE
          {
            ?graphNode_78277309124883_sensorId <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://openiot.eu/ontology/ns/Netatmo> .
            <http://openiot.eu/ontology/ns/Netatmo> <http://www.w3.org/2000/01/rdf-schema#subClassOf> <http://purl.oclc.org/NET/ssnx/ssn#Sensor> .
            ?graphNode_78277309124883_sensorId <http://www.loa-cnr.it/ontologies/DUL.owl#hasLocation> ?graphNode_78277309124883_loc .
            ?graphNode_78277309124883_loc geo:geometry ?graphNode_78277309124883_geo .
            ?graphNode_78277309124883_loc geo:lat ?graphNode_78277309124883_lat .
            ?graphNode_78277309124883_loc geo:long ?graphNode_78277309124883_lon .
            FILTER (<bif:st_intersects>(?graphNode_78277309124883_geo, <bif:st_point>( -9.058075905195437, 53.26871905960906), 15.0)) .
          }
        }
        FILTER (?graphNode_78277309124883_recordTime >= "2016-04-01T16:13:00.000+01:00"^^xsd:date AND ?graphNode_78277309124883_recordTime <= "2016-04-30T16:13:00.000+01:00"^^xsd:date ).
      }
      GROUP BY         ( fn:year-from-dateTime(?graphNode_78277309124883_recordTime) )         ( fn:month-from-dateTime(?graphNode_78277309124883_recordTime) )         ( fn:day-from-dateTime(?graphNode_78277309124883_recordTime) )
      ORDER BY         ( fn:year-from-dateTime(?graphNode_78277309124883_recordTime) )         ( fn:month-from-dateTime(?graphNode_78277309124883_recordTime) )         ( fn:day-from-dateTime(?graphNode_78277309124883_recordTime) )
    }
  }