Fatores naturais e antrópicos que influenciam na presença de nitrato no Aquífero Serra Geral Livre no perímetro urbano de Campo Grande - MS

Detalhes bibliográficos
Ano de defesa: 2024
Autor(a) principal: Diniz, Felipe Gavioli
Orientador(a): Gabas, Sandra Garcia
Banca de defesa: Não Informado pela instituição
Tipo de documento: Dissertação
Tipo de acesso: Acesso aberto
Idioma: por
Instituição de defesa: Universidade Federal de Mato Grosso do Sul
Programa de Pós-Graduação: Não Informado pela instituição
Departamento: Não Informado pela instituição
País: Brasil
Palavras-chave em Português:
Link de acesso: https://repositorio.ufms.br/handle/123456789/11446
Resumo: The objective of this work was to analyze which anthropogenic and natural factors influence the presence of nitrate in groundwater in urban areas using machine learning. The research site was the urban perimeter of the municipality of Campo Grande, capital of the state of Mato Grosso do Sul, which is located in the northern portion of the municipality. The methodology involved the use of the QGIS software for the production of maps and the Python language together with the Scikit-learn, NumPy, SciPy and Matplotlib libraries for data analysis and development of machine learning models. The following spatial variables were considered as influencing the nitrate level: distance to the water and sewage network, urban area, population density per neighborhood, slope, hypsometry, Normalized Difference Vegetation Index (NDVI), geology, water level depth, geotechnical characteristics and proximity to drainage systems. Nine statistical models from the classifier group and seven from the regressor group were adopted to analyze the data collected from 68 wells in 2018. The predictive results showed that the urban area and slope were the variables with the greatest influence on the nitrate value in both models. On the other hand, geology was the variable with the least influence in the classifier models and the distance from the water network in the regressor models. The results showed that the classifier models outperformed the regressor models, with five models presenting a result with the training group ranging from 0.60 to 0.80 and the test group between 0.40 and 0.60, highlighting the MLP Classifier model with the best performance. The other classifier models presented overfitting, a problem that also affected the performance of the regressor models, with two models presenting the same problem. Furthermore, five regressor models had a negative result and only the Logistic Regressor model revealed an acceptable result with the training group at 0.60 and with a value close to this in the test group. By estimating the distribution of nitrate, it was found that the highest concentrations occur in areas with greater slopes and high population density. On the other hand, the lowest concentrations are found in regions where there is no record of sewage networks, with less slope, low population density and where the groundwater level is deeper.
id UFMS_66b1fc1698fbafa4e7ef08d64420c5bb
oai_identifier_str oai:repositorio.ufms.br:123456789/11446
network_acronym_str UFMS
network_name_str Repositório Institucional da UFMS
repository_id_str
spelling 2025-02-20T18:48:11Z2025-02-20T18:48:11Z2024https://repositorio.ufms.br/handle/123456789/11446The objective of this work was to analyze which anthropogenic and natural factors influence the presence of nitrate in groundwater in urban areas using machine learning. The research site was the urban perimeter of the municipality of Campo Grande, capital of the state of Mato Grosso do Sul, which is located in the northern portion of the municipality. The methodology involved the use of the QGIS software for the production of maps and the Python language together with the Scikit-learn, NumPy, SciPy and Matplotlib libraries for data analysis and development of machine learning models. The following spatial variables were considered as influencing the nitrate level: distance to the water and sewage network, urban area, population density per neighborhood, slope, hypsometry, Normalized Difference Vegetation Index (NDVI), geology, water level depth, geotechnical characteristics and proximity to drainage systems. Nine statistical models from the classifier group and seven from the regressor group were adopted to analyze the data collected from 68 wells in 2018. The predictive results showed that the urban area and slope were the variables with the greatest influence on the nitrate value in both models. On the other hand, geology was the variable with the least influence in the classifier models and the distance from the water network in the regressor models. The results showed that the classifier models outperformed the regressor models, with five models presenting a result with the training group ranging from 0.60 to 0.80 and the test group between 0.40 and 0.60, highlighting the MLP Classifier model with the best performance. The other classifier models presented overfitting, a problem that also affected the performance of the regressor models, with two models presenting the same problem. Furthermore, five regressor models had a negative result and only the Logistic Regressor model revealed an acceptable result with the training group at 0.60 and with a value close to this in the test group. By estimating the distribution of nitrate, it was found that the highest concentrations occur in areas with greater slopes and high population density. On the other hand, the lowest concentrations are found in regions where there is no record of sewage networks, with less slope, low population density and where the groundwater level is deeper.O objetivo deste trabalho foi analisar quais fatores antrópicos e naturais que influenciam na presença do nitrato nas águas subterrâneas em área urbana utilizando aprendizado de máquina. O local da pesquisa foi o perímetro urbano do município de Campo Grande, capital do estado do Mato Grosso do Sul, que está localizada na porção norte do município. A metodologia envolveu a utilização do software QGIS para a produção de mapas e a linguagem Python junto com as bibliotecas Scikit-learn, NumPy, SciPy e Matplotlib para análise dos dados e desenvolvimento dos modelos de aprendizado de máquina. Foram consideradas as seguintes variáveis espaciais como influenciadoras do nível de nitrato: distância até a rede de água e esgoto, zona urbana, densidade populacional por bairro, declividade, hipsometria, Índice de Vegetação por Diferença Normalizada (NDVI), geologia, profundidade do nível da água, características geotécnicas e proximidade de sistemas de drenagem. Nove modelos estatísticos do grupo de classificadores e sete do grupo de regressores foram adotados para analisar os dados coletados em 68 poços em 2018. Os resultados preditivos mostraram que a zona urbana e a declividade foram as variáveis com maior influência sobre o valor de nitrato em ambos os modelos, por outro lado, a geologia foi a variável com menor influência nos modelos classificadores e a distância da rede de água nos modelos regressores. Os resultados mostraram que os modelos classificadores tiveram um desempenho superior aos modelos regressores, com cinco modelos apresentando um resultado com o grupo treino variando entre 0.60 a 0.80 e o grupo teste entre 0.40 a 0.60, destacando o modelo MLP Classifier com a melhor performance. Os demais modelos classificadores apresentaram overfitting, um problema que também afetou o desempenho dos modelos regressores, com dois modelos apresentando o mesmo problema. Além disso, cinco modelos regressores contaram com um resultado negativo e apenas o modelo Logistic Regressor relevou um resultado aceitável com o grupo treino em 0.60 e com um valor aproximado a esté no grupo teste. Por meio da estimativa da distribuição do nitrato, foi constatado que as maiores concentrações ocorrem em áreas com maiores declives e alta densidade populacional. Por outro lado, as menores concentrações são encontradas em regiões onde não há registro de redes de esgoto, com menor declive, baixa densidade populacional e onde o nível da água subterrânea é mais profundo.Universidade Federal de Mato Grosso do SulUFMSBrasilÁguas SubterrâneasAprendizado de MáquinaHidrogeologiaFatores naturais e antrópicos que influenciam na presença de nitrato no Aquífero Serra Geral Livre no perímetro urbano de Campo Grande - MSinfo:eu-repo/semantics/publishedVersioninfo:eu-repo/semantics/masterThesisGabas, Sandra GarciaDiniz, Felipe Gavioliinfo:eu-repo/semantics/openAccessporreponame:Repositório Institucional da UFMSinstname:Universidade Federal de Mato Grosso do Sul (UFMS)instacron:UFMSORIGINALDISSERTAÇÃO Felipe Gavioli.pdfDISSERTAÇÃO Felipe Gavioli.pdfapplication/pdf4065027https://repositorio.ufms.br/bitstream/123456789/11446/1/DISSERTA%c3%87%c3%83O%20Felipe%20Gavioli.pdf2602ff0205011b6f15870a42875355b3MD51123456789/114462025-08-01 09:50:10.877oai:repositorio.ufms.br:123456789/11446Repositório InstitucionalPUBhttps://repositorio.ufms.br/oai/requestri.prograd@ufms.bropendoar:21242025-08-01T13:50:10Repositório Institucional da UFMS - Universidade Federal de Mato Grosso do Sul (UFMS)false
dc.title.pt_BR.fl_str_mv Fatores naturais e antrópicos que influenciam na presença de nitrato no Aquífero Serra Geral Livre no perímetro urbano de Campo Grande - MS
title Fatores naturais e antrópicos que influenciam na presença de nitrato no Aquífero Serra Geral Livre no perímetro urbano de Campo Grande - MS
spellingShingle Fatores naturais e antrópicos que influenciam na presença de nitrato no Aquífero Serra Geral Livre no perímetro urbano de Campo Grande - MS
Diniz, Felipe Gavioli
Águas Subterrâneas
Aprendizado de Máquina
Hidrogeologia
title_short Fatores naturais e antrópicos que influenciam na presença de nitrato no Aquífero Serra Geral Livre no perímetro urbano de Campo Grande - MS
title_full Fatores naturais e antrópicos que influenciam na presença de nitrato no Aquífero Serra Geral Livre no perímetro urbano de Campo Grande - MS
title_fullStr Fatores naturais e antrópicos que influenciam na presença de nitrato no Aquífero Serra Geral Livre no perímetro urbano de Campo Grande - MS
title_full_unstemmed Fatores naturais e antrópicos que influenciam na presença de nitrato no Aquífero Serra Geral Livre no perímetro urbano de Campo Grande - MS
title_sort Fatores naturais e antrópicos que influenciam na presença de nitrato no Aquífero Serra Geral Livre no perímetro urbano de Campo Grande - MS
author Diniz, Felipe Gavioli
author_facet Diniz, Felipe Gavioli
author_role author
dc.contributor.advisor1.fl_str_mv Gabas, Sandra Garcia
dc.contributor.author.fl_str_mv Diniz, Felipe Gavioli
contributor_str_mv Gabas, Sandra Garcia
dc.subject.por.fl_str_mv Águas Subterrâneas
Aprendizado de Máquina
Hidrogeologia
topic Águas Subterrâneas
Aprendizado de Máquina
Hidrogeologia
description The objective of this work was to analyze which anthropogenic and natural factors influence the presence of nitrate in groundwater in urban areas using machine learning. The research site was the urban perimeter of the municipality of Campo Grande, capital of the state of Mato Grosso do Sul, which is located in the northern portion of the municipality. The methodology involved the use of the QGIS software for the production of maps and the Python language together with the Scikit-learn, NumPy, SciPy and Matplotlib libraries for data analysis and development of machine learning models. The following spatial variables were considered as influencing the nitrate level: distance to the water and sewage network, urban area, population density per neighborhood, slope, hypsometry, Normalized Difference Vegetation Index (NDVI), geology, water level depth, geotechnical characteristics and proximity to drainage systems. Nine statistical models from the classifier group and seven from the regressor group were adopted to analyze the data collected from 68 wells in 2018. The predictive results showed that the urban area and slope were the variables with the greatest influence on the nitrate value in both models. On the other hand, geology was the variable with the least influence in the classifier models and the distance from the water network in the regressor models. The results showed that the classifier models outperformed the regressor models, with five models presenting a result with the training group ranging from 0.60 to 0.80 and the test group between 0.40 and 0.60, highlighting the MLP Classifier model with the best performance. The other classifier models presented overfitting, a problem that also affected the performance of the regressor models, with two models presenting the same problem. Furthermore, five regressor models had a negative result and only the Logistic Regressor model revealed an acceptable result with the training group at 0.60 and with a value close to this in the test group. By estimating the distribution of nitrate, it was found that the highest concentrations occur in areas with greater slopes and high population density. On the other hand, the lowest concentrations are found in regions where there is no record of sewage networks, with less slope, low population density and where the groundwater level is deeper.
publishDate 2024
dc.date.issued.fl_str_mv 2024
dc.date.accessioned.fl_str_mv 2025-02-20T18:48:11Z
dc.date.available.fl_str_mv 2025-02-20T18:48:11Z
dc.type.status.fl_str_mv info:eu-repo/semantics/publishedVersion
dc.type.driver.fl_str_mv info:eu-repo/semantics/masterThesis
format masterThesis
status_str publishedVersion
dc.identifier.uri.fl_str_mv https://repositorio.ufms.br/handle/123456789/11446
url https://repositorio.ufms.br/handle/123456789/11446
dc.language.iso.fl_str_mv por
language por
dc.rights.driver.fl_str_mv info:eu-repo/semantics/openAccess
eu_rights_str_mv openAccess
dc.publisher.none.fl_str_mv Universidade Federal de Mato Grosso do Sul
dc.publisher.initials.fl_str_mv UFMS
dc.publisher.country.fl_str_mv Brasil
publisher.none.fl_str_mv Universidade Federal de Mato Grosso do Sul
dc.source.none.fl_str_mv reponame:Repositório Institucional da UFMS
instname:Universidade Federal de Mato Grosso do Sul (UFMS)
instacron:UFMS
instname_str Universidade Federal de Mato Grosso do Sul (UFMS)
instacron_str UFMS
institution UFMS
reponame_str Repositório Institucional da UFMS
collection Repositório Institucional da UFMS
bitstream.url.fl_str_mv https://repositorio.ufms.br/bitstream/123456789/11446/1/DISSERTA%c3%87%c3%83O%20Felipe%20Gavioli.pdf
bitstream.checksum.fl_str_mv 2602ff0205011b6f15870a42875355b3
bitstream.checksumAlgorithm.fl_str_mv MD5
repository.name.fl_str_mv Repositório Institucional da UFMS - Universidade Federal de Mato Grosso do Sul (UFMS)
repository.mail.fl_str_mv ri.prograd@ufms.br
_version_ 1845881970649726976