Queensland Health data shows rates of violence have almost doubled in Brisbane’s public hospitals in the last six years.