Estruturação de um banco de dados georreferenciado para as estradas vicinais do município de Toledo - PR

Abstract

The main source for economic development in Toledo-PR is the agricultural sector. The production from the rural area is directed to industrial and business centers by means of the rural roads; therefore, these roads must have proper traffic conditions. In order to guarantee these conditions, Toledo City Hall has carried out over the years maintenance works on the unsealed roads and paved some stretches, in partnership with farmers. The Rural Infrastructure Secretariat and EMDUR organize the information related to these works in digital and printed archives, therefore, the objective of this project is to develop a georeferenced database of these informations. For structuring the work, it was used a SIG tool, specifically the QGIS, in order to store information such as: length, shape and attributes of the performed works. The base file used in this work was the shapelife, made available by the City Hall, which contains the roads located in the municipal perimeter. The developed database has about 81.8% of the maintenance works on dirt roads carried out between 2005 and 2016, and 96.6% of the paving works made by EMDUR. With the structuring of the database, the research and analysis of maintenance and paving works can be done in a clearer and more objective way, furthermore, the database can be used as a management tool for the rural roads from Toledo-PR.