SPIN_EP-DPR-tables-v1.0.spin.ttl 10.3 KB
# baseURI: http://www.reportinghub.no/ep/spin/dpr-tables
# imports: http://spinrdf.org/spin
# imports: http://www.reportinghub.no/ep/schema/1.0/production
# imports: http://www.reportinghub.no/spin/rh

@prefix dpr-tables:  <http://www.reportinghub.no/ep/spin/dpr-tables#> .
@prefix owl:     <http://www.w3.org/2002/07/owl#> .
@prefix rdf:     <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
@prefix rdfs:    <http://www.w3.org/2000/01/rdf-schema#> .
@prefix rhspin:  <http://www.reportinghub.no/spin/rh#> .
@prefix sp:      <http://spinrdf.org/sp#> .
@prefix spin:    <http://spinrdf.org/spin#> .
@prefix spl:     <http://spinrdf.org/spl#> .
@prefix xsd:     <http://www.w3.org/2001/XMLSchema#> .

<http://www.reportinghub.no/ep/spin/dpr-tables>
      rdf:type owl:Ontology ;
      owl:imports <http://spinrdf.org/spin> , <http://www.reportinghub.no/ep/schema/1.0/production> , <http://www.reportinghub.no/spin/rh> ;
      owl:versionInfo "Created with TopBraid Composer"^^xsd:string .

dpr-tables:PersonnelInformation
      rdf:type rhspin:TableTemplate ;
      rdfs:label "Personnel Information"^^xsd:string ;
      rdfs:subClassOf rhspin:DPRTableTemplates ;
      spin:body
              [ rdf:type sp:Select ;
                sp:orderBy ([ sp:varName "facilityName"^^xsd:string
                          ]) ;
                sp:resultVariables ([ sp:varName "facilityName"^^xsd:string
                          ] [ sp:varName "beds"^^xsd:string
                          ] [ sp:varName "crewNumber"^^xsd:string
                          ] [ sp:varName "crewTypename"^^xsd:string
                          ]) ;
                sp:where ([ sp:object <http://www.reportinghub.no/ep/schema/report#ProductionReport> ;
                            sp:predicate rdf:type ;
                            sp:subject
                                    [ sp:varName "productionReport"^^xsd:string
                                    ]
                          ] [ sp:object
                                    [ sp:varName "productionReport"^^xsd:string
                                    ] ;
                            sp:predicate <http://www.reportinghub.no/ep/schema/core#partOf> ;
                            sp:subject
                                    [ sp:varName "productionOperationReport"^^xsd:string
                                    ]
                          ] [ sp:object <http://www.reportinghub.no/ep/schema/report#ProductionOperationReport> ;
                            sp:predicate rdf:type ;
                            sp:subject
                                    [ sp:varName "productionOperationReport"^^xsd:string
                                    ]
                          ] [ sp:object
                                    [ sp:varName "temporalPartOfFacility"^^xsd:string
                                    ] ;
                            sp:predicate <http://www.reportinghub.no/ep/schema/report#reportOn> ;
                            sp:subject
                                    [ sp:varName "productionOperationReport"^^xsd:string
                                    ]
                          ] [ sp:object
                                    [ sp:varName "productionFacility"^^xsd:string
                                    ] ;
                            sp:predicate <http://www.reportinghub.no/ep/schema/core#temporalPartOf> ;
                            sp:subject
                                    [ sp:varName "temporalPartOfFacility"^^xsd:string
                                    ]
                          ] [ sp:object <http://www.reportinghub.no/ep/schema/facility#Field> ;
                            sp:predicate rdf:type ;
                            sp:subject
                                    [ sp:varName "productionFacility"^^xsd:string
                                    ]
                          ] [ sp:object
                                    [ sp:varName "facilityName"^^xsd:string
                                    ] ;
                            sp:predicate <http://www.reportinghub.no/np/schema/npd#name> ;
                            sp:subject
                                    [ sp:varName "productionFacility"^^xsd:string
                                    ]
                          ] [ sp:object
                                    [ sp:varName "productionOperationReport"^^xsd:string
                                    ] ;
                            sp:predicate <http://www.reportinghub.no/ep/schema/core#partOf> ;
                            sp:subject
                                    [ sp:varName "productionOperationInstallationReport"^^xsd:string
                                    ]
                          ] [ sp:object <http://www.reportinghub.no/ep/schema/report#ProductionOperationInstallationReport> ;
                            sp:predicate rdf:type ;
                            sp:subject
                                    [ sp:varName "productionOperationInstallationReport"^^xsd:string
                                    ]
                          ] [ sp:object
                                    [ sp:varName "installationPart"^^xsd:string
                                    ] ;
                            sp:predicate <http://www.reportinghub.no/ep/schema/report#reportOn> ;
                            sp:subject
                                    [ sp:varName "productionOperationInstallationReport"^^xsd:string
                                    ]
                          ] [ sp:object
                                    [ sp:varName "beds"^^xsd:string
                                    ] ;
                            sp:predicate <http://www.reportinghub.no/ep/schema/production-facility#numberOfBedsAvailable> ;
                            sp:subject
                                    [ sp:varName "installationPart"^^xsd:string
                                    ]
                          ] [ rdf:type sp:Optional ;
                            sp:elements ([ sp:object
                                                [ sp:varName "crew"^^xsd:string
                                                ] ;
                                        sp:predicate <http://www.reportinghub.no/ep/schema/organization#hasCrew> ;
                                        sp:subject
                                                [ sp:varName "installationPart"^^xsd:string
                                                ]
                                      ] [ sp:object
                                                [ sp:varName "crewNumber"^^xsd:string
                                                ] ;
                                        sp:predicate <http://www.reportinghub.no/ep/schema/organization#numberInCrew> ;
                                        sp:subject
                                                [ sp:varName "crew"^^xsd:string
                                                ]
                                      ] [ sp:object
                                                [ sp:varName "crewType"^^xsd:string
                                                ] ;
                                        sp:predicate rdf:type ;
                                        sp:subject
                                                [ sp:varName "crew"^^xsd:string
                                                ]
                                      ] [ sp:object <http://www.reportinghub.no/ep/schema/organization#CrewType> ;
                                        sp:predicate rdf:type ;
                                        sp:subject
                                                [ sp:varName "crewType"^^xsd:string
                                                ]
                                      ] [ sp:object
                                                [ sp:varName "crewTypename"^^xsd:string
                                                ] ;
                                        sp:predicate rdfs:label ;
                                        sp:subject
                                                [ sp:varName "crewType"^^xsd:string
                                                ]
                                      ])
                          ])
              ] ;
      rhspin:tableHeaders ("Facility"^^xsd:string "Beds"^^xsd:string "Crew"^^xsd:string "Crew Type"^^xsd:string) .

dpr-tables:WellInformation
      rdf:type rhspin:TableTemplate ;
      rdfs:subClassOf rhspin:DPRTableTemplates ;
      spin:body
              [ rdf:type sp:Select ;
                sp:resultVariables ([ sp:varName "description"^^xsd:string
                          ] _:b1 [ sp:varName "choke"^^xsd:string
                          ] [ sp:varName "prod"^^xsd:string
                          ]) ;
                sp:where ([ sp:object _:b2 ;
                            sp:predicate <http://www.reportinghub.no/ep/schema/report#reportOn> ;
                            sp:subject
                                    [ sp:varName "report"^^xsd:string
                                    ]
                          ] [ sp:object <http://www.reportinghub.no/ep/schema/activity#DailyProductionActivity> ;
                            sp:predicate rdf:type ;
                            sp:subject _:b2
                          ] [ sp:object _:b3 ;
                            sp:predicate <http://www.reportinghub.no/ep/schema/core#hasPart> ;
                            sp:subject _:b2
                          ] [ sp:object <http://www.reportinghub.no/ep/schema/production-activity#ProductionOperationsActivity> ;
                            sp:predicate rdf:type ;
                            sp:subject _:b3
                          ] [ rdf:type sp:Optional ;
                            sp:elements ([ sp:object _:b1 ;
                                        sp:predicate <http://www.reportinghub.no/ep/schema/production-facility#numberOfOwnCrew> ;
                                        sp:subject
                                                [ sp:varName "act"^^xsd:string
                                                ]
                                      ])
                          ])
              ] ;
      rhspin:tableHeaders ("Description"^^xsd:string "Oil Net m3"^^xsd:string "Choke %"^^xsd:string "Prod Hours"^^xsd:string) .

_:b2  sp:varName "dailyProductionActivity"^^xsd:string .

_:b1  sp:varName "oilNet"^^xsd:string .

_:b3  sp:varName "productionOperationsActivity"^^xsd:string .