A modelagem de banco de dados geográfico como suporte a organização de informações florestais e ambientais na Região Sul do Amazonas

Abstract

The deficiency in the centralization of information and the various ways of organization and distribution of geographic data, do not help monitoring and combating environmental irregularities. Forestry and environmental professionals use maps and geographic information in many activities and areas of work, with the structuring of a database, it is possible to centralize and organize data for interactive visualization of the natural and anthropic dynamics of actions in the environment. The work was developed for the southern region of the state of Amazonas, in which official data obtained from the responsible agency or entities were first used and the modeling was developed so that there are updates and data insertions, the modeling process was carried out in three stages, conceptual, logical and physical modeling. Therfore, the brModelo software was used to generate conceptual and logical diagrams and as a support to the physical, where a database management system, PostgreSQL was utilized with support of the Postgis extension for spatial data. The utilization of the database was exemplified by two case studies, where the connection to the database allows the user to access data and the possibility of generating new data or updating existing ones, although the attributes must be rightly fullfied previousky defined in the modeling, and the disponibilization of these data via webservice and the advantages of its use for the generation of information with stored data on forest and environmental themes.