Found 23 results.
The activities under WP3 were as follows:
Collection of COVID-19 health & wastewater surveillance data and associated open data
This activity involved establishing a data standardisation and digitisation protocol to ensure adequate translation of testing data reported through WP1 and WP2 into a usable digital format.
The need for data standardisation
In this section we point out the demand for data standardisation and the current information gaps.
Implementing strict privacy measures was not necessary within this project as the open source and sampling data collected was only retrieved at municipal level.
In this section we identify the required, relevant and available (open source) data for COVID-19 health and wastewater surveillance purposes.
Optimisation of storage space and connections
All separate Dutch data sources where provided in the form of flat files. These flat files were filtered, grouped and cleaned.
Data protocol for common data assembly and standardisation
A data protocol for common data assembly and standardisation for optimal data analysis processing was established. This was necessary to allow for data comparison among sources. All data sources were filtered for outliers and duplicates.
Data architecture Design
For the data architecture we used a star schema with facts and dimensions based on flat files. The star schema is a type of relational database that is composed of a single, central fact table surrounded by dimension tables.
Data combination, statistical analysis and modelling
In this chapter, the distribution of SARS-CoV-2 virus presence and concentration in waste(water) streams in the selected metropolitan areas were compared to the data on COVID-19 prevalence in the Dutch and South African population where possible.
The research area
The same research area was used for the entire dataset, consisting of locations in the Netherlands: Utrecht and Amsterdam and locations in South Africa (see table below).