annotate src/sparql/insert_vector_table_details.sparql @ 63:70f616afdb9a

added datatype filter
author stevenh
date Mon, 27 May 2013 15:29:45 +0100
parents fa1ca32c6a17
children 5577d8efc79a
rev   line source
stevenh@56 1 PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
stevenh@56 2 PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
stevenh@56 3 PREFIX owl: <http://www.w3.org/2002/07/owl#>
stevenh@56 4 PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
stevenh@56 5 PREFIX abc: <http://example.org/abc#>
stevenh@56 6 PREFIX seq: <http://example.org/seq#>
stevenh@56 7 PREFIX sia: <http://example.org/sia#>
stevenh@56 8
stevenh@56 9 INSERT { ?vte sia:dimVal _:dv .
stevenh@56 10 _:dv sia:dimension ?dim;
stevenh@56 11 sia:value ?val}
stevenh@56 12 WHERE
stevenh@56 13 {
stevenh@56 14 ?vte rdf:type sia:VectorTableElement .
stevenh@56 15 ?vte sia:fromDatapoint ?datapoint1 .
stevenh@56 16 ?vte sia:toDatapoint ?datapoint2 .
stevenh@56 17 ?datapoint1 sia:dimVal ?dv1 .
stevenh@56 18 ?dv1 sia:dimension ?dim .
stevenh@56 19 ?dv1 sia:value ?val1 .
stevenh@56 20 ?datapoint2 sia:dimVal ?dv2 .
stevenh@56 21 ?dv2 sia:dimension ?dim .
stevenh@56 22 ?dv2 sia:value ?val2 .
stevenh@63 23 FILTER (( datatype(?val2) = xsd:double ) && ( datatype(?val1) = xsd:double ))
stevenh@56 24 BIND (?val2 - ?val1 AS ?val)
stevenh@56 25 }