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 .
  
}