You are reading a single comment by @Stonehedge and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
Stonehedge
It's just a mess. This is my understanding of the situation from my experience. I've never worked an outbreak, I missed SARS and ebola.
Testing from hospitals comes into SGSS a SQL environment. Data comes out of that to be imported manually into the case management system (which has been earmarked for update and replace for at least 5 years). This allows health protection teams to do the job of identifying cases,clusters, situations, outbreaks. And to manage them with local authorities. So that's one data flow. From SGSS to the team doing the dirty work.(which is where I used to work)
Getting data out of that system with the linked information you need is very difficult.
The data on the webpages you see are all in bi, I don't understand why they're not doing shiny apps, there are a number of very good r data people in PHE London. And a lot of the stuff for public health data (fingertips for example) is generated in r. And makes use of a big SQL environment.
I don't understand as each of the epidemiology reports we receive from the epi team is clearly generated in r, but output as a PDF. We haven't been provided anything like a shared resource of tables for just our data that we're allowed to see.
I don't understand how or why access is being used, as I thought it wasn't used anymore.
I think the amount and type of information coming in has got much bigger than the processing capability of the team setting up the data gathering.
(Edit: I meant I sounded pissy. And I am. I'm sad. The people I worked with for the last 5 years are working really hard. And their organisation is being hammered)