Coverage of fluoride data in water supply systems using the R software
Autor(a) principal: | |
---|---|
Data de Publicação: | 2022 |
Outros Autores: | , , |
Tipo de documento: | Artigo |
Idioma: | eng |
Título da fonte: | Revista de Saúde Pública |
Texto Completo: | http://old.scielo.br/scielo.php?script=sci_arttext&pid=S0034-89102022000100215 |
Resumo: | ABSTRACT OBJECTIVE To present a protocol to criticize data on fluoride monitoring in water with R software programming features, illustrating its application to describe data coverage, and fluoridation quality in 2015. METHODS The study used big data from the Sistema de Informação de Vigilância da Qualidade da Água para Consumo Humano (Information System for Surveillance of Water Quality for Human Consumption) that included all the Brazilian municipalities. Data criticism procedures were performed with the aid of R software. Filters were applied to remove municipalities with less than four months of records (1), and records with null values (2) and outliers (3). Municipalities were classified regarding the presence of valid information and fluoridation quality according to macro-region, federation units, and population size, presenting the roadmap at each step. RESULTS Approximately 134,000 records were reviewed. Of the Brazilian municipalities, 39% had data on the fluoride parameter, and only 33.3% had four months or more of information frequency. After applying filters, 1,810 (32.5%) municipalities had valid information for the fluoride parameter, with substantial variation between the South (83.6%) and North (0.7%) macro-regions. Of these, 726 (40.1%) showed very good fluoridation quality, determined by 80% or more records within the optimal concentration interval for prevention of dental caries, with higher value (54.3%) in municipalities with 50,000 inhabitants or more, and lower (34.2%) in those with less than 10,000 inhabitants. CONCLUSIONS Important differences persist within and between the Brazilian macro-regions regarding both the availability of information on the parameter, and the quality of water fluoridation in public supply systems in Brazil. The protocol for data review and processing with R software programming resources proved to be very useful for the production of information for decision-making based on a standardized method. |
id |
USP-23_a4da50c694536f1656fa2de4222eabd3 |
---|---|
oai_identifier_str |
oai:scielo:S0034-89102022000100215 |
network_acronym_str |
USP-23 |
network_name_str |
Revista de Saúde Pública |
repository_id_str |
|
spelling |
Coverage of fluoride data in water supply systems using the R softwareWater SupplyFluoridation, standardsWater Supply CoverageWater QualityBig DataDecision Making, OrganizationalABSTRACT OBJECTIVE To present a protocol to criticize data on fluoride monitoring in water with R software programming features, illustrating its application to describe data coverage, and fluoridation quality in 2015. METHODS The study used big data from the Sistema de Informação de Vigilância da Qualidade da Água para Consumo Humano (Information System for Surveillance of Water Quality for Human Consumption) that included all the Brazilian municipalities. Data criticism procedures were performed with the aid of R software. Filters were applied to remove municipalities with less than four months of records (1), and records with null values (2) and outliers (3). Municipalities were classified regarding the presence of valid information and fluoridation quality according to macro-region, federation units, and population size, presenting the roadmap at each step. RESULTS Approximately 134,000 records were reviewed. Of the Brazilian municipalities, 39% had data on the fluoride parameter, and only 33.3% had four months or more of information frequency. After applying filters, 1,810 (32.5%) municipalities had valid information for the fluoride parameter, with substantial variation between the South (83.6%) and North (0.7%) macro-regions. Of these, 726 (40.1%) showed very good fluoridation quality, determined by 80% or more records within the optimal concentration interval for prevention of dental caries, with higher value (54.3%) in municipalities with 50,000 inhabitants or more, and lower (34.2%) in those with less than 10,000 inhabitants. CONCLUSIONS Important differences persist within and between the Brazilian macro-regions regarding both the availability of information on the parameter, and the quality of water fluoridation in public supply systems in Brazil. The protocol for data review and processing with R software programming resources proved to be very useful for the production of information for decision-making based on a standardized method.Faculdade de Saúde Pública da Universidade de São Paulo2022-01-01info:eu-repo/semantics/articleinfo:eu-repo/semantics/publishedVersiontext/htmlhttp://old.scielo.br/scielo.php?script=sci_arttext&pid=S0034-89102022000100215Revista de Saúde Pública v.56 2022reponame:Revista de Saúde Públicainstname:Universidade de São Paulo (USP)instacron:USP10.11606/s1518-8787.2022056003709info:eu-repo/semantics/openAccessPaulino,Camila de MoraesBelotti,LorrayneAzevedo,Moises Kim Zanotto deFrazão,Pauloeng2022-04-05T00:00:00Zoai:scielo:S0034-89102022000100215Revistahttp://www.scielo.br/scielo.php?script=sci_serial&pid=0034-8910&lng=pt&nrm=isoONGhttps://old.scielo.br/oai/scielo-oai.phprevsp@org.usp.br||revsp1@usp.br1518-87870034-8910opendoar:2022-04-05T00:00Revista de Saúde Pública - Universidade de São Paulo (USP)false |
dc.title.none.fl_str_mv |
Coverage of fluoride data in water supply systems using the R software |
title |
Coverage of fluoride data in water supply systems using the R software |
spellingShingle |
Coverage of fluoride data in water supply systems using the R software Paulino,Camila de Moraes Water Supply Fluoridation, standards Water Supply Coverage Water Quality Big Data Decision Making, Organizational |
title_short |
Coverage of fluoride data in water supply systems using the R software |
title_full |
Coverage of fluoride data in water supply systems using the R software |
title_fullStr |
Coverage of fluoride data in water supply systems using the R software |
title_full_unstemmed |
Coverage of fluoride data in water supply systems using the R software |
title_sort |
Coverage of fluoride data in water supply systems using the R software |
author |
Paulino,Camila de Moraes |
author_facet |
Paulino,Camila de Moraes Belotti,Lorrayne Azevedo,Moises Kim Zanotto de Frazão,Paulo |
author_role |
author |
author2 |
Belotti,Lorrayne Azevedo,Moises Kim Zanotto de Frazão,Paulo |
author2_role |
author author author |
dc.contributor.author.fl_str_mv |
Paulino,Camila de Moraes Belotti,Lorrayne Azevedo,Moises Kim Zanotto de Frazão,Paulo |
dc.subject.por.fl_str_mv |
Water Supply Fluoridation, standards Water Supply Coverage Water Quality Big Data Decision Making, Organizational |
topic |
Water Supply Fluoridation, standards Water Supply Coverage Water Quality Big Data Decision Making, Organizational |
description |
ABSTRACT OBJECTIVE To present a protocol to criticize data on fluoride monitoring in water with R software programming features, illustrating its application to describe data coverage, and fluoridation quality in 2015. METHODS The study used big data from the Sistema de Informação de Vigilância da Qualidade da Água para Consumo Humano (Information System for Surveillance of Water Quality for Human Consumption) that included all the Brazilian municipalities. Data criticism procedures were performed with the aid of R software. Filters were applied to remove municipalities with less than four months of records (1), and records with null values (2) and outliers (3). Municipalities were classified regarding the presence of valid information and fluoridation quality according to macro-region, federation units, and population size, presenting the roadmap at each step. RESULTS Approximately 134,000 records were reviewed. Of the Brazilian municipalities, 39% had data on the fluoride parameter, and only 33.3% had four months or more of information frequency. After applying filters, 1,810 (32.5%) municipalities had valid information for the fluoride parameter, with substantial variation between the South (83.6%) and North (0.7%) macro-regions. Of these, 726 (40.1%) showed very good fluoridation quality, determined by 80% or more records within the optimal concentration interval for prevention of dental caries, with higher value (54.3%) in municipalities with 50,000 inhabitants or more, and lower (34.2%) in those with less than 10,000 inhabitants. CONCLUSIONS Important differences persist within and between the Brazilian macro-regions regarding both the availability of information on the parameter, and the quality of water fluoridation in public supply systems in Brazil. The protocol for data review and processing with R software programming resources proved to be very useful for the production of information for decision-making based on a standardized method. |
publishDate |
2022 |
dc.date.none.fl_str_mv |
2022-01-01 |
dc.type.driver.fl_str_mv |
info:eu-repo/semantics/article |
dc.type.status.fl_str_mv |
info:eu-repo/semantics/publishedVersion |
format |
article |
status_str |
publishedVersion |
dc.identifier.uri.fl_str_mv |
http://old.scielo.br/scielo.php?script=sci_arttext&pid=S0034-89102022000100215 |
url |
http://old.scielo.br/scielo.php?script=sci_arttext&pid=S0034-89102022000100215 |
dc.language.iso.fl_str_mv |
eng |
language |
eng |
dc.relation.none.fl_str_mv |
10.11606/s1518-8787.2022056003709 |
dc.rights.driver.fl_str_mv |
info:eu-repo/semantics/openAccess |
eu_rights_str_mv |
openAccess |
dc.format.none.fl_str_mv |
text/html |
dc.publisher.none.fl_str_mv |
Faculdade de Saúde Pública da Universidade de São Paulo |
publisher.none.fl_str_mv |
Faculdade de Saúde Pública da Universidade de São Paulo |
dc.source.none.fl_str_mv |
Revista de Saúde Pública v.56 2022 reponame:Revista de Saúde Pública instname:Universidade de São Paulo (USP) instacron:USP |
instname_str |
Universidade de São Paulo (USP) |
instacron_str |
USP |
institution |
USP |
reponame_str |
Revista de Saúde Pública |
collection |
Revista de Saúde Pública |
repository.name.fl_str_mv |
Revista de Saúde Pública - Universidade de São Paulo (USP) |
repository.mail.fl_str_mv |
revsp@org.usp.br||revsp1@usp.br |
_version_ |
1748936506714619904 |