Beaches Water Quality In São Paulo, Brazil
Water quality in the beaches of São Paulo state in Brazil
@kaggle.amandalk_sp_beaches_water_quality
Water quality in the beaches of São Paulo state in Brazil
@kaggle.amandalk_sp_beaches_water_quality
One criteria that can be used to measure the water quality of the beaches is the density of Enterococcus, which indicates the fecal pollution in water. High values of the density of this bacteria indicates that the water quality is compromised and it represents risks to the bathers health. The measurements are performed weekly in several beaches in the state of São Paulo and they are used to classify the beaches as 'Proper' or 'Improper' for bathing.
This data represents over 68k measurements of Enterococcus taken weekly between 2012 and 2021, from 16 cities and 168 beaches/collection points in the São Paulo state.
The original source of the data was provided by CETESB.
Explore the data and check if we can see improvements in the sanitary sewer system over the years.
Does the weather, tidal variance and holidays/vacations impact in the water quality of the beaches? How?
What are other factors that can influence the water quality?
Can we cross this data with other environment/development/etc data sources and see what can be done to improve our beaches?
Updated data to complete 2020. Due to Covid-19 CETESB didn't take measures in many of the dates and beaches.
Some collection points presented a change in the name, and it was considered as below:
São Sebastião
Itanhaém
Updated with data until 2021-07-19.
The reports from CETESB don't contain measurements between 2021-03-15 and 2021-04-12.
CREATE TABLE sp_beaches (
"city" VARCHAR,
"beach" VARCHAR,
"date" TIMESTAMP,
"enterococcus" DOUBLE
);Anyone who has the link will be able to view this.