## 2 Development of a Geoinformation Database  
The most crucial tasks in the creation of a database are the recording, processing and systematization of the results of previously performed engineering and survey works. The quality of these processes determines the degree of reliability of the database in the future. The main components of the assessment of base soils are:  
1. clarification of the physical-geographical, geological, geomorphological and lithological conditions;
2. qualitative and quantitative characteristics of the structure, composition, state and properties of genetic, age and petrographic types of soils and mapping the spatial variability of their indicators;
3. identification of soil layering conditions and their location;
4. establishing the nature and intensity of development of modern geological and engineering-geological processes and phenomena.  
The control system of the developed Geoinformation Database (DIG-system) program was developed by the scientists of the L.N. Gumilyov Eurasian National University in Nur-Sultan, Kazakhstan, and has a hierarchical structure consisting of two levels and includes the following main four functions:  
1. General management function (Host DB).
2. Input control data function (Local DB).
3. Function of data extraction and processing (AP).
4. Data augmentation function (Layer DB).  
The general management function is responsible for the first level of the hierarchical structure, which carries out the general management and organization of the graphical process.  
The second level of the hierarchy includes the other three functions that carry out preliminary processing of the initial information and ensure the organization of the graphic process.  
In this case, the initial information used in the program is divided into two main sections:  
* Fixed datasets that form a local program database.
* Initial data prepared directly by the user and entered during program execution.  
The first section (fixed data) is informational material included directly in the program set. This includes a city map, city coordinates and characteristics for obtaining graphic files.  
The second section is the sets of initial data was generated by the user. It includes data obtained from the materials of engineering and geological surveys. Sequence of data input to the second section:  
1. The survey area was determined and a map of the survey area is created in CAD program, i.e., AutoCAD.
2. The location of each borehole was indicated and labeled on the survey area map.
3. The exact X and Y coordinates were determined for each borehole.
4. A set of data was collected in the Excel table to log the information about each borehole and the location of Static pile load tests which were reflected in the geological-lithological columns: * each borehole was assigned an identification code of the borehole and the coordinates were entered according to X and Y, the level of the ground surface H, the depth of borehole and the level of groundwater, * the same way data were applied for each point of Static pile load test with a link to a nearby borehole location, * for each associated borehole the geological-lithological columns were inserted, which include the depth of the deposit, the age and name of the soil that ensures the stratigraphy subsequent location of the layers, as well as the coded state or if(if loose soil then the code is equal to zero, if half-rock or rock is 1,2,3,4 depends to the type of the rock soils), * the data of previously performed Static pile load tests were recorded according to their passport, * after this the processing of all data was performed and their reliability were verified.  
With the help of this program it was possible to build up the conditions for the settlement and the soils stratigraphy in each part of the city (Figure 2).