gTimeline
: Production oil and gas per month at Ekofisk
The element which draws the above chart:
<div id="sgvzl_example_query" data-sgvizler-endpoint="http://sws.ifi.uio.no/sparql/npd" data-sgvizler-query="PREFIX fn: <http://www.w3.org/2005/xpath-functions#> SELECT xsd:date(?date) ?Oil_millSm "" "" ?Gas_billSm "" "" WHERE{ {[] a npdv:FieldProductionPeriod ; npdv:hasField <http://sws.ifi.uio.no/npd/field/Ekofisk> ; npdv:month ?month ; npdv:year ?year ; npdv:producedNetOilMillSm3 ?Oil_millSm ; npdv:producedNetGasBillSm3 ?Gas_billSm ; LET (?date := fn:concat(fn:concat(fn:concat(?year, "-"), ?month), "-01")) FILTER (xsd:int(?year) < 2011 && xsd:int(?month) > 9)} UNION { [] a npdv:FieldProductionPeriod ; npdv:hasField <http://sws.ifi.uio.no/npd/field/Ekofisk> ; npdv:month ?month ; npdv:year ?year ; npdv:producedNetOilMillSm3 ?Oil_millSm ; npdv:producedNetGasBillSm3 ?Gas_billSm ; LET (?date := fn:concat(fn:concat(fn:concat(?year, "-0"), ?month), "-01")) FILTER (xsd:int(?year) < 2011 && xsd:int(?month) < 10) } }ORDER BY xsd:date(?date)" data-sgvizler-chart="gTimeline" data-sgvizler-loglevel="2" style="width:800px; height:400px;"/>
gTable