The XII International Professional IT Conference "Stachka" concluded on September 27-28 in St. Petersburg. The event was attended by over 1,700 participants from 103 cities and 8 countries, featuring more than 200 presentations across 5 tracks: development, digital marketing, design and content, management, startups, and technologies.

In the "Development/Databases" section, company specialists delivered a presentation titled "Reasonable Compromise – DB and GIS". The report addressed the effective use of DBMS in geoinformation solutions, drawing on KB "Panorama's" experience in developing regional and municipal GIS, corporate resource management systems, and other high-load systems. A video of the presentation is now available for viewing.

This report continued the theme of geoinformation system architecture presented by us in 2023 at "Stachka" in Ulyanovsk. Additionally, we invite you to check out the reports by KB "Panorama" specialists presented earlier this year at "Stachka", discussing the specifics of import substitution in information systems and GIS in particular, as well as the application of neural networks in object decryption services.

The next "Stachka" conference will take place in April 2025 in Ulyanovsk. Tickets are still available for purchase at a 50% discount on the official website of the organizers.

Geoportal "Bank of spatial data" has been supplemented with a map of the Republic of Mozambique, formed according to OpenStreetMap data. To work with the map, you can use the GIS Panorama Mini program or other software products of KB "Panorama".

The map was led to the modernised classifier of large-scale plans of scale 1: 5 000 (map5000m). Publishing of updates in bank of spatial data is made by using the program of Databank of digital maps and remote sensing data. Publishing contents of bank of spatial data on the geoportal and data access for downloading are implemented by means of GIS WebServer SE.

Free maps on the basis of OpenStreetMap data are available for download on the page "Digital maps".

The KB "Panorama" has developed GIS "Panorama" version 15.3.1 for the "Astra Linux Special Edition" operating system. The new version implements the task of viewing attributes of objects from spatial databases connected via DBM files. Tools for automatic decoding of satellite images have been added, a task for comparing height matrices has been developed, and the list of supported formats for exporting map data to the Mbtiles tile pyramid has been expanded, along with improvements in map editing modes.

The program features a task called "View attributes from database". This mode provides the display of attributes from objects in spatial databases connected via DBM files and arbitrary attribute tables. For each table selected from the database, a bookmark is created to display its contents. Up to three user-selected tables can be additionally placed under all bookmarks. A filter can be applied to select records from the table based on columns, attribute values, or a specified SQL query. Sorted and filtered table records can be saved to a text file in CSV format using the "Export to CSV" mode. The "Location on map" mode ensures synchronization between the table record and the map object linked through a DBM file or service fields.

The capabilities of GIS "Panorama" for automatic decoding of satellite images have been enhanced. A neural network model has been added to the task "Automatic sattelite recognition" to outline building contours in landscape images. Satellite images of cities in the Russian Federation were used alongside vector maps containing outlines of roofs and walls for training the model. The resulting model achieves recognition accuracy exceeding 90%. The service rectifies recognized building contours into rectangular shapes and adjusts their placement to accurately match building foundations.

The "Automatic sattelite recognition" task allows for processing landscape images in RSW/JPG/TIFF/PNG formats and data from open geoportals. For precise identification of building contours, the spatial resolution of images should be between 0.5 and 1 meter/pixel. Processing results are provided to the user as a vector map, which can be downloaded via the WFS protocol. The task can be accessed from the Application Launch list under the "Automatic object creation" section. Recognizing building contours in satellite images of Moscow covering an area of 25 square kilometers took 2 minutes and 20 seconds, resulting in the creation of 2,895 objects.

A new task called "Comparison of height matrices" has been added, designed to compare information from two similar height matrices. The input data consists of two open height matrices. The output matrix contains relative heights of the second matrix in relation to the first matrix, meaning that each element of the output matrix records the difference in heights between the second and first matrices or the absolute value of that difference. Users can choose the scale, precision (element size), and dimensions of the created matrix. By default, the dimensions of the matrix are set according to the first matrix, but they can later be changed by selecting the corresponding fragment of the map.

The "Map Editor" task has been improved. In the "Object stitching" mode, the quality of stitching area objects has been enhanced: a preliminary alignment of contours is added before stitching objects. In the "Cutting from polygon" mode, the ability to choose the shape of the object to be saved has been introduced. When cutting the original polygon into two or more parts, the result is saved as a single multipolygon: the outer parts of the object are recorded into one object. An option "Form multipolygon" has been added to the context menu of the mode, which, when disabled, allows the outer parts of the cut object to be saved as separate area objects.

In the "Align selected objects" toolbar, a mode called "Create combined symbol" has been added. A combined symbol is a set of vector objects selected from the map classifier, having a common anchor point and arranged vertically. After being applied to the map, the combined symbol can be edited as a single object.

The task "Export to Mbtiles tile pyramid" has been refined. In addition to supporting jpeg, png, and png8 formats, an option to save tiles in webp format has been added. The webp format supports both lossy and lossless compression algorithms. Compressed images typically take up 30% less space compared to png. The webp format supports transparency, like png, and can contain metadata for images.

GIS "Panorama" is a versatile domestic geographic information system. The program is designed for accumulating, storing, automated processing, and displaying data, calculation results, and forecasts with geospatial references. GIS "Panorama" includes tools for displaying and processing vector, raster, and matrix maps. The application provides users with tools for solving specialized tasks such as modeling the movement of special objects against a 3D model background, predicting the consequences of emergencies at hazardous sites, monitoring aircraft movement, conducting geodetic and topographic work, processing data from GPS/GLONASS navigation devices, printing displayed spatial data on various output devices, and many others.

The new version of the program is available for download in the Download section.

Specialists from the KB "Panorama", together with students from MIIGAiK, have created a tutorial on how to upload coordinates for the object being created from a text file. This task is available in the GIS "Panorama", GIS "Operator", and other software products from the "Panorama" design bureau for the "Astra Linux Special Edition" operating system.

The tutorial demonstrates the process of creating map objects using the "Loading coordinates from a text file" dialog. The process of uploading coordinates for the object being created from a text file can be conditionally divided into the following stages:

- Selecting the type of object to be created and the method for placing the object(s) on the map;

- Choosing the file to be uploaded;

- Configuring the upload scenario (format of the source file);

- Directly processing the uploaded file, forming and recording the object(s) on the map.

When starting the dialog, the file opens and its format is automatically recognized. The information contained in the uploaded file is automatically divided into columns (with space or tab recognized as delimiters). If the automatic file recognition is successful, data types are assigned to the columns. If not, data types must be assigned manually.

If necessary, coordinate transformation can be performed during the upload (adding offsets for X and Y coordinates). By enabling the option "Create multi-point object", an object of type "Point" is created, where the metric contains a sequence of points with a single set of attributes.

You can find educational materials in the "Video Lessons" section.

Geoportal "Bank of spatial data" has been supplemented with a map of Republic of Guinea, formed according to OpenStreetMap data. To work with the map, you can use the GIS Panorama Mini program or other software products of KB "Panorama".

The map was led to the modernised classifier of large-scale plans of scale 1: 5 000 (map5000m).

Publishing of updates in bank of spatial data is made by using the program of Databank of digital maps and remote sensing data. Publishing contents of bank of spatial data on the geoportal and data access for downloading are implemented by means of GIS WebServer SE.

Free maps on the basis of OpenStreetMap data are available for download on the page "Digital maps".