jbjares

RequestDefinitionCodeView

May 26th, 2016
533
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.   # [1 / 2] visualization type: 'LineChart' and sensors of type:
  2.   #      - http://openiot.eu/ontology/ns/Netatmo
  3.   # Generated: Thu May 26 16:24:06 BST 2016
  4.   SELECT DISTINCT  ?y1 ?x1_day ?x1_month ?x1_year
  5.   FROM <http://lsm.deri.ie/OpenIoT/guest_demo/sensordata#>
  6.   WHERE
  7.   {
  8.     {
  9.       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
  10.       WHERE
  11.       {
  12.         ?graphNode_78277309124883_record <http://openiot.eu/ontology/ns/value> ?graphNodeEndpoint_78277309285910 .
  13.         ?graphNode_78277309124883_record <http://www.w3.org/2000/01/rdf-schema#label> 'temperature' .
  14.         ?graphNode_78277309124883_record <http://purl.oclc.org/NET/ssnx/ssn#observationResultTime> ?graphNode_78277309124883_recordTime .
  15.         ?graphNode_78277309124883_record <http://openiot.eu/ontology/ns/isObservedValueOf> ?graphNode_78277309124883_sensor .
  16.         ?graphNode_78277309124883_sensor <http://purl.oclc.org/NET/ssnx/ssn#observedBy> ?graphNode_78277309124883_sensorId .
  17.         {
  18.           SELECT ?graphNode_78277309124883_sensorId
  19.           FROM <http://lsm.deri.ie/OpenIoT/guest_demo/sensormeta#>
  20.           WHERE
  21.           {
  22.             ?graphNode_78277309124883_sensorId <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://openiot.eu/ontology/ns/Netatmo> .
  23.             <http://openiot.eu/ontology/ns/Netatmo> <http://www.w3.org/2000/01/rdf-schema#subClassOf> <http://purl.oclc.org/NET/ssnx/ssn#Sensor> .
  24.             ?graphNode_78277309124883_sensorId <http://www.loa-cnr.it/ontologies/DUL.owl#hasLocation> ?graphNode_78277309124883_loc .
  25.             ?graphNode_78277309124883_loc geo:geometry ?graphNode_78277309124883_geo .
  26.             ?graphNode_78277309124883_loc geo:lat ?graphNode_78277309124883_lat .
  27.             ?graphNode_78277309124883_loc geo:long ?graphNode_78277309124883_lon .
  28.             FILTER (<bif:st_intersects>(?graphNode_78277309124883_geo, <bif:st_point>( -9.058075905195437, 53.26871905960906), 15.0)) .
  29.           }
  30.         }
  31.         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 ).
  32.       }
  33.       GROUP BY         ( fn:year-from-dateTime(?graphNode_78277309124883_recordTime) )         ( fn:month-from-dateTime(?graphNode_78277309124883_recordTime) )         ( fn:day-from-dateTime(?graphNode_78277309124883_recordTime) )
  34.       ORDER BY         ( fn:year-from-dateTime(?graphNode_78277309124883_recordTime) )         ( fn:month-from-dateTime(?graphNode_78277309124883_recordTime) )         ( fn:day-from-dateTime(?graphNode_78277309124883_recordTime) )
  35.     }
  36.   }
  37.  
  38.  
  39. #-----------------------------------
  40.  
  41.   # [2 / 2] visualization type: 'LineChart' and sensors of type:
  42.   #      - http://openiot.eu/ontology/ns/Netatmo
  43.   # Generated: Thu May 26 16:24:06 BST 2016
  44.   SELECT DISTINCT  ?y2 ?x2_day ?x2_month
  45.   FROM <http://lsm.deri.ie/OpenIoT/guest_demo/sensordata#>
  46.   WHERE
  47.   {
  48.     {
  49.       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
  50.       WHERE
  51.       {
  52.         ?graphNode_78277309124883_record <http://openiot.eu/ontology/ns/value> ?graphNodeEndpoint_78277309291218 .
  53.         ?graphNode_78277309124883_record <http://www.w3.org/2000/01/rdf-schema#label> 'humidity' .
  54.         ?graphNode_78277309124883_record <http://purl.oclc.org/NET/ssnx/ssn#observationResultTime> ?graphNode_78277309124883_recordTime .
  55.         ?graphNode_78277309124883_record <http://openiot.eu/ontology/ns/isObservedValueOf> ?graphNode_78277309124883_sensor .
  56.         ?graphNode_78277309124883_sensor <http://purl.oclc.org/NET/ssnx/ssn#observedBy> ?graphNode_78277309124883_sensorId .
  57.         {
  58.           SELECT ?graphNode_78277309124883_sensorId
  59.           FROM <http://lsm.deri.ie/OpenIoT/guest_demo/sensormeta#>
  60.           WHERE
  61.           {
  62.             ?graphNode_78277309124883_sensorId <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://openiot.eu/ontology/ns/Netatmo> .
  63.             <http://openiot.eu/ontology/ns/Netatmo> <http://www.w3.org/2000/01/rdf-schema#subClassOf> <http://purl.oclc.org/NET/ssnx/ssn#Sensor> .
  64.             ?graphNode_78277309124883_sensorId <http://www.loa-cnr.it/ontologies/DUL.owl#hasLocation> ?graphNode_78277309124883_loc .
  65.             ?graphNode_78277309124883_loc geo:geometry ?graphNode_78277309124883_geo .
  66.             ?graphNode_78277309124883_loc geo:lat ?graphNode_78277309124883_lat .
  67.             ?graphNode_78277309124883_loc geo:long ?graphNode_78277309124883_lon .
  68.             FILTER (<bif:st_intersects>(?graphNode_78277309124883_geo, <bif:st_point>( -9.058075905195437, 53.26871905960906), 15.0)) .
  69.           }
  70.         }
  71.         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 ).
  72.       }
  73.       GROUP BY         ( fn:year-from-dateTime(?graphNode_78277309124883_recordTime) )         ( fn:month-from-dateTime(?graphNode_78277309124883_recordTime) )         ( fn:day-from-dateTime(?graphNode_78277309124883_recordTime) )
  74.       ORDER BY         ( fn:year-from-dateTime(?graphNode_78277309124883_recordTime) )         ( fn:month-from-dateTime(?graphNode_78277309124883_recordTime) )         ( fn:day-from-dateTime(?graphNode_78277309124883_recordTime) )
  75.     }
  76.   }
RAW Paste Data

Adblocker detected! Please consider disabling it...

We've detected AdBlock Plus or some other adblocking software preventing Pastebin.com from fully loading.

We don't have any obnoxious sound, or popup ads, we actively block these annoying types of ads!

Please add Pastebin.com to your ad blocker whitelist or disable your adblocking software.

×