No abstract

No abstract

The work is devoted to the development of spatial databases for the assessment of agricultural land. The geodatabase is aimed at geoinformation support of assessment, agroecological typing (groups, types of land) of agricultural lands, development of adaptive-landscape farming systems. The paper presents the structure of the database of regional and local levels. Three different ways of user interaction with the AgroGIS database are proposed. For practical implementation, it is proposed to use the object-functional approach to database development, based on the use of cloud data storage technology in the DBMS SQlite. Background. Geoinformation support of agronomic geoinformation systems (AgroGIS) is aimed at assessing natural-territorial conditions and environmental factors in agrolandscapes, development of adaptive landscape farming systems. AgroGIS geodatabases serve to store, analyze and present spatial information on agricultural land. As shown by an analysis of literary sources, the term “geodatabase” was formed more than twenty years ago. At the same time different geodatabases are known: archaeological, cartographic, soil and others. They differ in the object of research, structure and content, as well as the way of data organization. This indicates the relevance of the topics of the present research. Purpose. The purpose of the work is to develop the structure and content of the geodatabase agronomic GIS. Materials and methods. The object-functional approach to database development, which is supported by object-oriented database management systems (DBMS) and classical relational DBMS, is used. The essence of this approach is to implement functional tasks taking into account the needs of the user. Results. The main components of geodatabase in the form of separate sets of spatial classes (Climate, Relief, Soil, Vegetation, Hydrography, Agrolandscape) are proposed. At the same time the paper shows the need for practical implementation of agronomic geoinformation geodatabases from several aspects. Conclusion. In the development of spatial databases of agronomic GIS the most important feature is the ability to constantly update information in the form of temporal component. Practical implementation of temporal geodatabases is possible with the use of non-relational database management systems, as well as methods of processing big data (Big Data).

The necessary sequence of stages has been developed and the unmanned technology for creating a digital elevation model by the example of the land use of Novosibirsk region has been implemented. The technology consists of a set of stages: reconnaissance of the terrain, fi xing reference signs, satellite measurements, aerial photography fl ights, processing the results of aerial photography and the construction of digital elevation model. The technological process was signifi cantly affected by unfavorable weather conditions - low clouds, gusty wind, high air humidity. Remote sensing study with the use of unmanned aerial vehicle of the Supercam S 250 F type made it possible to create a large-scale orthophotoplan and a digital elevation model on the farm territory (M 1 : 1000). For photogrammetric processing of digital data obtained on the farm, a two-stage method of satellite determination was used. The essence of this method was to obtain a large number of satellite measurements in a static mode and further statistical processing. For statistical processing of satellite measurements, information was used on the coordinate location of two base ground stations of the Novosibirsk Region satellite network - Kochenevo and Novosibirsk. Remoteness of support points from the ground satellite station of Novosibirsk was at a distance of over 90 km. As a result of equalization calculations, the obtained average square displacement errors of the planned and high-altitude position of the support points in various test sites were under 0.02 m in the plan, and under 0.03 m by height. In the process of photogrammetric processing of the results of aerial photography with the use of unmanned aerial vehicle, the tasks of transferring the position of points on a digital image in the pixel coordinate system into the coordinate system of the area, building digital irregular (TIN, Triangulated Irregular Network) and regular (DEM, Digital Elevation Model) surface models, and based on them, textured terrain models (TTM, Textured Terrain Model) and orthophotoplans, were solved.

No abstract