view src/sparql/insert_datapoint_order_bar_one.sparql @ 60:387439c076f9

new

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX abc: <http://example.org/abc#>
PREFIX seq: <http://example.org/seq#>
PREFIX sia: <http://example.org/sia#>

INSERT { ?datapoint1 sia:orderedIndex ?orderedIndex;
		 			 sia:memberOfOrderedSet ?dataset}
			
WHERE
{
	{
		SELECT ?datapoint1 (COUNT (?datapoint2) AS ?numSmallerDatapoints) ?dataset
		WHERE
		{
			?datapoint1 sia:dimVal ?dimVal1x .
			?datapoint1 sia:memberOfDataset ?dataset .
			?dimVal1x sia:dimension ?smallestDimensionMin .
			?dimVal1x sia:value ?value1x .

			?datapoint2 sia:dimVal ?dimVal2x .
			?dimVal2x sia:dimension ?smallestDimensionMin .
			?dimVal2x sia:value ?value2x .
			
			FILTER ( datatype(?value1x) = xsd:double && datatype(?value2x) = xsd:double )
			FILTER (?value1x > ?value2x) .
			{
				SELECT ?datapoint1 ?datapoint2 (MIN(?dimension) AS ?smallestDimensionMin)
				WHERE
				{
					?datapoint1 a sia:Datapoint .
					?datapoint1 sia:memberOfDataset ?dataset .
					?datapoint1 sia:dimVal ?dimVal1 .
					?dimVal1 sia:dimension ?dimension .
					?dimVal1 sia:value ?value1 .
		
					?datapoint2 a sia:Datapoint .
					?datapoint2 sia:memberOfDataset ?dataset .
					?datapoint2 sia:dimVal ?dimVal2 .
					?dimVal2 sia:dimension ?dimension .
					?dimVal2 sia:value ?value2 .
		
					FILTER ( datatype(?value1) = xsd:double && datatype(?value2) = xsd:double )
					FILTER (?value1 != ?value2) .
				}
				GROUP BY ?datapoint1 ?datapoint2
			}
		}
		GROUP BY ?datapoint1 ?dataset
	}
	BIND (?numSmallerDatapoints + 1 AS ?orderedIndex)
}