mprxml-to-flowuid-spreadsheet.sparql
1.35 KB
SELECT ?FieldNPDName ?FieldNPDID ?FlowInOutFacilityName ?FlowInOutFacilityType ?FlowInOutFacilityNameSystem ?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" .
?facilityidentifierstruct mpr:uidRefValue ?FieldNPDID .
?facilityidentifierstruct dtype:value ?FieldNPDName .
?cs_productvolumefacility mpr:nameRef ?cs_productvolumefacilityname.
?cs_productvolumefacilityname mpr:namingSystem ?FlowInOutFacilityNameSystem .
?cs_productvolumefacilityname dtype:value ?FlowInOutFacilityName .
?cs_productvolumefacilityname mpr:kindRef ?FlowInOutFacilityType .
?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 .
}