Banco de dados geotécnico georreferenciado dos subleitos de rodovias federais localizadas no Estado do Ceará

Georeferenced geotechnical database of subgrades of federal highways located in the State of Ceará

Abstract

This article presents an analysis of subgrade data that was provided by the National Department of Transport Infrastructure (DNIT), in analogue report format. The information was digitized and transformed into a georeferenced geotechnical database, using Microsoft Excel and QGIS Desktop 3.28.9, enabling verification of results and corrections of soil classification errors, beginning the construction of a digital platform for prior knowledge of the geotechnical characteristics of certain regions of the State, as well as the generation of models and thematic maps. The analyzed spreadsheet contains: identification of geotechnical study, highway, stake, UTM coordinates, collection depth, optimal humidity, maximum dry specific mass, California Bearing Ratio (CBR), expansion, liquidity limit, plasticity index, granulometry, relative observations to the peculiarities of the analyzed soils, group index and classification by the American Association of State Highway and Transportation Officials (AASHTO). The analysis of the results was carried out with the generation of dynamic tables and graphs, noting that, according to the CBR, the materials analyzed have adequate mechanical behavior to be used in highway subgrades, and that the AASHTO classification can adequately predict the mechanical behavior of soils in the State of Ceará.