## 6 Conclusions  
Based on the analysis of physical and mechanical characteristics, the territory of the city of Nur-sultan was subdivided into eight zones where zones 4, 7, and 8 have stratification into several types of alluvial soils in the geological column, and therefore are considered the most difficult in the design of buildings and structures on them. The above zones are located on the left bank of the Ishim River, where in recent years the significant landmarks, business center of the capital as well as extensive park areas have been built. Vice versa, the districts of the old city are located in zones 3 and 1, where there is practically no engineering-geological element 3, belonging to alluvial medium-Quaternary sand and gravel formations \(a(Q_{II\_IV})\). Summarizing main research findings, the following main points can be highlighted:  
1. The algorithm for collecting geoinformation data to create a single data set is presented. 2. The program \"Geoinformation Database \" was developed for * creating engineering and geological maps of construction sites, * study and analyze the results of engineering and geological surveys; * identify the main engineering and geological elements; * to build special geotechnical maps of Quaternary deposits and bedrocks for the city. 3. The territory of the city of Nur-Sultan was regrouped into eight zones instead of the previous six, based on the geological origin and stratigraphy interposition of the six main engineering-geological elements (EGE). 4. The analysis of physical and mechanical properties of the soil located in the territory of the city of Nur-Sultan signified that the increased liquid and plastic limits are replicated by higher values of elasticity modulus E, and hence better strength characteristics of a particular soil layer and vice versa, while the moisture content and soil density did not show any obvious pattern and requires additional verification on the construction site. 5. The scatter of the soils properties observed during the research and reflected in the scatter plot graph corresponds to the patterns established by the methods of mathematical statistics. (6) The zoning map for optimization of pile lengths was designed depending on the type of underlying soil, i.e., zoning and previously performed Static pile load test results recorded in the geotechnical database. For today, the geoinformation database is in use by engineering and survey organizations and design and construction companies, such as OO Kazakhstan Geotechnical Association, LLC Sakhalin Center, LLC Geotechnical Center, LLP Astana Geostroy, LLP KGS, \"LLP\" KGS-Astana, and \"LLP\" \"MG-Build\". The information provided in the geographic information system is necessary for these organizations in the feasibility study of projects in which they participate during tenders. Since the geoinformation database reduces the period of the feasibility study and enables the contract application to approximately calculate the cost of the projects in which they are aiming to participate. Conceptualization, A.Z and N.A. ; methodology, N.A. ; software, N.A. ; validation, A.S. and N.A. ; formal analysis, A.S.; investigation, S.A. and A.S.; resources, A.S.; data curation, A.S.; writing--original draft preparation, A.S.; writing--review and editing, A.S.; visualization, A.S.; supervision, A.Z. ; project administration, A.Z. ; funding acquisition, A.Z. All authors have read and agreed to the published version of the manuscript. This research was funded by the targeted state program \"The Geoinformation System and Technology of its Introduction in Geotechnics\", grant number AP05132828 from the Ministry of Education and Science of the Republic of Kazakhstan for 2018-2020. The data presented in this study are available on request from the corresponding author. The data are not publicly available due to maintaining the secrecy of geographic coordinates of the construction objects. The authors are grateful to the colleagues of Geotechnical Institute of the L.N.