mprxml-to-flowuid-spreadsheet.sparql
2.2 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
49
50
51
52
53
54
55
56
57
58
59
60
DRAFT 2
SELECT ?FieldNPDName ?FieldNPDID ?FlowUID ?FlowName ?FlowKind ?FlowQualifier
WHERE {
?obj_productvolume rdf:type mpr:Obj_productVolume .
?obj_productvolume mpr:facilityRef ?cs_productvolumefacility .
?cs_productvolumefacility rdf:type mpr:Cs_productVolumeFacility .
?obj_productvolume mpr:installationRef ?facilityidentifierstruct .
?facilityidentifierstruct rdf:type mpr:FacilityIdentifierStruct .
?facilityidentifierstruct mpr:namingSystem "NPD"^^<http://www.epim.no/schemas/mprml/1#NameStringDatatype> .
?facilityidentifierstruct mpr:uidRefValue ?FieldNPDID .
?facilityidentifierstruct dtype:value ?FieldNPDName .
?cs_productvolumefacility mpr:flowRef ?cs_productvolumeflow .
?cs_productvolumeflow rdf:type mpr:Cs_productVolumeFlow .
?cs_productvolumeflow mpr:kindRef ?FlowKind .
?FlowKind rdf:type mpr:ReportingFlow .
?cs_productvolumeflow mpr:qualifierRef ?FlowQualifier .
?FlowQualifier rdf:type mpr:FlowQualifier .
?cs_productvolumeflow mpr:name ?FlowName .
?cs_productvolumeflow mpr:uid ?FlowUID .
}
DRAFT1
SELECT ?FieldNPDName ?FieldNPDID ?FlowUID ?FlowName ?FlowKind ?FlowQualifier
WHERE {
?obj_productvolume rdf:type mpr:Obj_productVolume .
?obj_productvolume mpr:facilityRef ?cs_productvolumefacility .
?cs_productvolumefacility rdf:type mpr:Cs_productVolumeFacility .
?obj_productvolume mpr:installationRef ?facilityidentifierstruct .
?facilityidentifierstruct rdf:type mpr:FacilityIdentifierStruct .
?facilityidentifierstruct mpr:namingSystem "NPD"^^<http://www.epim.no/schemas/mprml/1#NameStringDatatype> .
?facilityidentifierstruct mpr:uidRefValue ?FieldNPDID .
?facilityidentifierstruct dtype:value ?FieldNPDName .
?cs_productvolumefacility mpr:flowRef ?cs_productvolumeflow .
?cs_productvolumeflow rdf:type mpr:Cs_productVolumeFlow .
?cs_productvolumeflow mpr:kindRef ?reportingflow .
?reportingflow rdf:type mpr:ReportingFlow .
?reportingflow dtype:value ?FlowKind .
?cs_productvolumeflow mpr:qualifierRef ?qualifier .
?qualifier rdf:type mpr:FlowQualifier .
?qualifier dtype:value ?FlowQualifier .
?cs_productvolumeflow mpr:name ?FlowName .
?cs_productvolumeflow mpr:uid ?FlowUID .
}