7b-oilnet-givenField-activeLicence-M.dong
1.56 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX erhi: <http://www.reportinghub.no/erhi/schema/1.0/interface-model#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
SELECT ?licenceShare ?field ?licenceNpdID ?flow ?percentageOfShare ?startProductDate ?endProductDate ?density ?densityUnit ?mass ((?mass*?percentageOfShare/100) as ?myMass) ?massUnit ?volume ((?volume*?percentageOfShare/100) as ?myVolume) ?volumeUnit
WHERE {
?licence rdf:type erhi:LicenceOrBaa .
?licence erhi:npdname ?licenceName .
?licence erhi:npdid ?licenceNpdID .
?licenceShare erhi:licenceOrBaaShared ?licence.
?licenceShare erhi:licenceOrBaaShareHolder ?licenceOwner.
?licenceOwner erhi:npdid "4070011".
?licenceShare erhi:percentageOfShare ?percentageOfShare.
?licence erhi:ownsField ?field .
?field a erhi:Field;
erhi:npdid "18081500".
?flow erhi:flowIntoOrOutOf ?field;
a erhi:AllocatedFlow, erhi:ProductionExploitation.
?flow erhi:hasProduct ?flowProduct.
?flowProduct erhi:productStartAt ?startProductDate.
?flowProduct erhi:productEndAt ?endProductDate.
?flowProduct erhi:hasTimePeriod "Monthly".
?flowProduct
erhi:hasProductKind "oil net".
OPTIONAL {
?flowProduct
erhi:hasDensity ?density;
erhi:hasDensityUnit ?densityUnit.
}
OPTIONAL {
?flowProduct
erhi:hasMass ?mass;
erhi:hasMassUnit ?massUnit.
}
OPTIONAL {
?flowProduct
erhi:hasVolume ?volume;
erhi:hasVolumeUnit ?volumeUnit.
}
FILTER NOT EXISTS {?licenceShare erhi:npdEndDate ?endDate}.
FILTER (?startProductDate >= "2012-01-01"^^xsd:date && ?endProductDate <= "2012-05-31"^^xsd:date)
}