Apoyo en la recopilación de información secundaria en la subdirección de agrología del Instituto Geográfico Agustín Codazzi (IGAC)

Abstract

This report describes the activities carried out in the degree work entitled "Support in the collection of secondary information" under the internship modality, this was carried out in the Directorate of Geographic Information Management, specifically in the Subdirectorate of Agrology of the Agustin Codazzi Geographic Institute, where the corresponding functions and activities were designated for the fulfillment of the internship.

The assigned activities revolved around the data derived from soil studies at national level, which had been stored in spreadsheets; such storage makes evident the need for a spatial database to store the agrological information of the Colombian territory, responding to the collection of data in an organized and/or structured manner under a spatial reference system that defines the actual location and relationship between objects, in this case profiles and horizons.

Among the studies provided, data were received both from the field as well as the results of laboratory analysis; therefore, a large number of studies and data were compiled, consequently, a first batch of data was taken that compiles 3,816 profiles and for each of these 634 attributes, so the first batch of data consisted of 2'419,344 data.

Once the first batch of data was reviewed, it was imperative to define tables and domains for each of the attributes that make them up in order to avoid typing errors and confusion in data entry, then, the future users of the spatial database, specifically a geodatabase in ArcGIS, are guaranteed a safe environment, since they will have clear options to enter in each of these and the quality of the data entered is also guaranteed.

Twenty-one tables were established for the storage of attributes according to their characteristics and the domains defined for the attributes that so required were based on the soil description and sampling document code IN-GAG-PC05-05 version 1, together with the opinions of professionals in the area. On the other hand, data from past studies needed to be processed through a parameterization where they were adjusted to the defined domains.

Once the domains were defined, the database was structured by the professional in charge and then the data from past studies were uploaded, once uploaded, the database could be accessed through the web.