**5. Conclusion**

the N-value in each analyzed depth, curves of the soil resistance for the study area are obtained. This kind of maps, for instance, enable to evaluate the geotechnical soil profiles in various sectors of the study area, in order to observe the occurrence of layers with lower resistance index

**Figure 13** shows a compilation of all generated N-value maps presented in [20], in order to

It is verified in **Figure 13** that there is a growing tendency of the areas containing high N-values (darker color) with the increase of the analyzed depth. The analysis was performed until 25 m deep, where the impenetrable to percussion layer is completely achieved. The UFSC subsoil shows that the N-values decrease from the east, west and south regions to the central-north

simultaneously visualize the variation of the soil resistance along the depths.

portion, which contains soft soils and, consequently, with lower resistance.

and the evolution of the soil resistance with increasing depth.

262 Management of Information Systems

**Figure 13.** N-value map—matrix of comparisons [20].

This chapter described practical applications of modeling and processing of database in GIS environment, using pre-existing data such as Standard Penetration Test Investigations. It detailed the process behind the elaboration, treatment and application of a geological-geotechnical database, through a method description and display of practical results using two case studies [19, 20].

The operations using geological-geotechnical data can bring important information for planning and decision-making. In this way, N-value contour lines, soil types and groundwater level maps were developed to guide land use and occupation policies, due to their strategic information for elaboration of risk and flooding maps, for example. Knowledge of the depth of the impenetrable to SPT percussion, groundwater, admissible soil stress for shallow foundation and N-value contour lines are fundamental information regarding technical designs, foundation costs planning and services validation, and so they were also addressed in the chapter.

Since working with a digital database, there is also the possibility of the further addition of information in the analyses, such as soil and rock mechanic and dynamic properties. This is a significant advantage of the method because the analyses can be repeated countless times, complemented and updated according to interest.

Due to the flexibility of digital database, the possibilities of analyses and results are countless. Different results than those presented in this chapter can be explored. Pile maximum length map and stratigraphic reference profiles for the geotechnical units are examples presented in greater details in [19, 20]. The diversity of results depends on the interest and creativity of the researcher.

Finally, the organization of different applications and methods to treat geological-geotechnical information in GIS environment intended to show the efficiency of to take advantage of pre-existing data. The results presented can assist decision-making providing strategic information in the public sphere and in the private sector.
