Specialists from KB "Panorama" have prepared training material demonstrating work with the "View attributes from database" task. The video tutorial will help users of GIS "Panorama", "Workstation of cadastral engineer" and "ARM of agronomist" software products to effectively organize spatial analysis of data stored in DBMS.

The task under consideration provides display of object attributes from spatial databases connected through DBM files, or arbitrary attribute tables. The subordination settings allow establishing relationships between tables, with each new relationship requiring a unique name. Additionally, there is the ability to use and edit previously created relationships.

The video tutorial demonstrates the process of adding rows describing the relationship between tables. The "Master table" column specifies the source dataset used to filter rows in the subordinate table. The "Subordinate table" column specifies the dataset to be filtered. The tables do not necessarily need to be directly linked, and all intermediate connections can be hidden using the visibility parameter setting. In the "Attribute Table" dialog, when clicking on any row of the master table, the rows of the subordinate table are automatically filtered based on matches in the configured fields.

You can access the training materials in the "Video Tutorials" section.

KB "Panorama" has developed the aerial photography processing software "Panorama Photo" version 1.6 using CUDA technology version 12.6 for the "Astra Linux Special Edition" operating system. "Panorama Photo" is designed to obtain digital terrain information from images captured by unmanned aerial vehicles. The primary processing result is a point cloud, which serves as the basis for creating a height matrix and orthophotoplan. The processing is fully automated. An optional step of measuring ground control points on images allows for improved orientation accuracy.

The program can be applied to solve tasks in urban planning and cadastral activities, national defense, mapping, ecology, forestry and municipal management, among others. Data generated in "Panorama Photo" serves as a reliable and visual control tool when performing construction and reconstruction work on various types of municipal property and transport infrastructure. Based on the data prepared by the complex, three-dimensional terrain models are created, and mathematical models of emergency situations are built and analyzed in GIS "Panorama". Orthophotoplans created in "Panorama Photo" provide a basis for identifying and monitoring waste storage sites, conducting forest inventories to assess damage from fires, air pollution, and illegal deforestation.

Calculations are parallelized on multi-core processors and graphics cards, so increasing the number of processor cores and video memory significantly accelerates data processing. On a computer with a modern graphics card and RAM of at least 128 GB, obtaining a volumetric model, height matrix, and orthophotoplan for 1 square kilometer of aerial photography with a point size of about 2 cm takes approximately 1 hour.

The orthophotoplans obtained in the program can be used to create vector maps. The "Panorama Vision" automatic recognition and vectorization complex allows this to be done automatically. The client module of the complex is called as an application task in GIS "Panorama". The complex is based on artificial intelligence using trained neural networks. "Panorama Vision" can recognize the contours of field plots, hydrographic objects (rivers, ponds, lakes, and others), buildings, structures, and roads. It creates processing requests to the server part of the complex, located on KB "Panorama" technical equipment. The processing results in a vector map with contours of recognized objects, such as buildings and structures.

All processing results obtained in "Panorama Photo" and GIS "Panorama" (matrices, point clouds, orthophotoplans, vector maps) can subsequently be used in various KB "Panorama" software products for two-dimensional and three-dimensional (volumetric) terrain visualization.

For organized storage and use of data, the Digital Maps and Remote Sensing Data Bank is used. This complex serves as the foundation for building spatial data infrastructure at federal, regional, and municipal levels and in corporate information systems. It is used for maintaining cloud storage of spatial data sets, collecting and storing metadata, selecting and delivering spatial data upon request, preparing reports, forming and publishing geo-coverages, and displaying the data bank status in the form of schematic maps. Remote placement of spatial data sets in file storage, version management of stored sets, updating of data availability schematic maps, and automated collection and formation of metadata are all supported.

OS "Astra Linux Special Edition" is a Russian certified operating system with built-in information protection tools for stable and secure operation of IT infrastructures of any scale and for processing information of various confidentiality levels. The operating system includes a set of programs for solving everyday office and multimedia tasks.

The new version of the "Panorama Photo" program is available for download on the Download page.

Geoportal "Bank of spatial data" has been supplemented with a map of Belize, 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".

Specialists from KB "Panorama" have prepared an update to the address database used in GIS "Panorama" and "Workstation of cadastral engineer". As part of the latest update, the database has been supplemented with more than 3,500,000 new records covering various categories of objects: land plots, capital construction objects, parking spaces, apartments, and rooms.

The updated version of the address database has been automatically integrated into the functionality of the software products and is available when performing cadastral work. In particular, it simplifies the editing of object attributes and the formation of technical plans for buildings, structures, construction in progress, premises, and parking spaces. The database structure fully complies with the State Address Register (GAR) and allows users to select addresses in accordance with municipal and administrative-territorial divisions. To ensure compatibility with previous addressing systems (KLADR and FIAS), the database includes unique identification codes of objects from these registers.

The "Panorama" address database is formed based on up-to-date information from the Federal Tax Service website. The current versions of GIS "Panorama" and "Workstation of cadastral engineer" are available in the Download section.

From February 25 to 26, 2025, a training seminar was held in Perm for employees of PPK "Roscadastre" to prepare them for performing comprehensive cadastral works in the regions of the Russian Federation. The event, organized by the branch of the public law company "Roscadastre" in Perm Krai, was held at the Perm State Agrarian and Technological University.

Comprehensive cadastral works (CCW) are being conducted by PPK "Roscadastre" branches across 17,500 cadastral quarters in 87 regions of the Russian Federation. Aerial photography using unmanned aircraft systems (UAS) is widely used in performing CCW. Specialists from various regions of the country attended lectures and gained practical skills in applying photogrammetric tools and geoinformation technologies. They improved their skills in processing field work results, maintaining cadastral maps, clarifying the location of land plot boundaries and real estate objects, filling in attribute information, and preparing cadastral documents.

During the event, KB "Panorama" employees presented the capabilities of GIS "Panorama" for maintaining cadastral maps using various source data applied in comprehensive cadastral works. The training discussed the specifics of georeferencing source photo and cartographic materials for digitizing them as part of the cadastral map. Advanced data processing technologies were presented, including "Panorama Photo" for processing materials obtained from UAS, and "PanoramaVision" for automatic recognition of various object classes from terrain images.

The training demonstrated the connection to services of the federal state information system "Unified Digital Platform 'National Spatial Data System'" (NSDS) in GIS "Panorama". The "Select geoportals from list" mode provides connection to map base layer images and cadastral objects. The "Search by geoportal" task allows searching by cadastral number or cadastral object address. The "Information from the state real estate cadastre" mode provides attribute information about the following classes of cadastral objects: land plots, buildings, structures, objects under construction, zones with special conditions for territory use, boundaries of municipalities and settlements, and boundaries of water bodies.

Special attention was given to using the tasks "Reading CPT and map updating", "Cadastral works database", and "Cadastral object attributes" for preparing cadastral maps of comprehensive cadastral works territories. For creating and editing land plots, buildings, and structures, the digital classifier survey.v6 was recommended. It contains necessary cadastral objects as a separate layer "Cadastral plan of territory". PPK "Roscadastre" specialists were shown how to use the "Formation of territory map-plan" mode to create a text report and electronic XML document. The ability to form electronic documents according to MapPlanTerritory_v01.xsd and MapPlanTerritory_v02.xsd schemas ensures the submission of comprehensive cadastral work results to the Unified State Register of Real Estate in compliance with regional specifics.