Specialists from KB "Panorama" have prepared a video tutorial on working with the "Input en-routes to database" mode of the "Aeronautical Information Documents Preparation" application in GIS "Panorama". A route (airway) is controlled airspace or a part of it in the form of a corridor, which is designed to direct traffic flow in order to provide air traffic services. Each route corresponds to an established number of segments (sections). A route segment (section) is a complex three-dimensional object between two route points, which serves for aircraft flight.

The video tutorial demonstrates the management of a route database, which contains the main route record with a specified code, localization, and period of validity. The "Localization" field is used to enter the text designation of region (state) codes through which the route passes. The formation and maintenance of the route database is carried out through the route input form.

The left part of the form contains a route input panel, which displays a list of routes or route groups, as well as a panel for entering parameters of a new route. The right part of the form contains a panel for editing the route structure and fields for filling in the characteristics of route segments. In addition, there is a capability for automatic calculation of true and magnetic course angles, segment lengths on the map, and recording the results in databases.

The data source is Aeronautical Information Publications (AIP) issued by each state. Data exchange between sources is carried out through the ARINC exchange format. You can familiarize yourself with the training materials in the "Video Lessons" section.

KB "Panorama" has developed GIS Constructor for Qt Designer SE version 15.0.5 for operating systems "Astra Linux Special Edition", "Alt Linux", Ubuntu (20.04, 22.04), and MS Windows. The new version implements support for specifying an interpreter for script execution, which is important when multiple Python versions are present in the system. Geoportal functionality has been improved: new functions for searching, displaying, and copying information about terrain objects have been added, and capabilities for interaction with the National Spatial Data System have been expanded. Additional restrictions on data management through GIS Server have been introduced, and a new algorithm for displaying labels considering rotation angles has been implemented.

New MAPAPI functions have been added, allowing users to specify a Python interpreter for script execution. This is particularly useful in scenarios where multiple Python versions are installed in the system, and a specific one needs to be selected, for example, to ensure compatibility with certain libraries or development environments. If an interpreter is not explicitly specified, the GIS core libraries will automatically search for an available interpreter. This process takes into account environment variables, allowing flexible adaptation to the user's system configuration.

The task of connecting to geoportals has been enhanced to obtain information at a specified point about terrain objects based on the WMS protocol. From the National Spatial Data System geoportal, users can request the date an object was registered, cadastral number, status, land category, plot or building value, and other parameters. For geoportals that support point information requests when displaying tiles, data is shown in the "Object Selection" dialog: object metrics, semantic characteristics, and object metadata. Object information can be copied to exchange formats. For the National Spatial Data System geoportal, the display of Land Plots (labels) and Buildings (labels) layers has been implemented, and response node correspondence files and classifier data have been added to ensure semantic mapping. A new dialog for searching information on geoportals has been developed. The dialog allows address searches on the OpenStreetMap geoportal, cadastral number searches on the National Spatial Data System geoportal, and cross-searches on KB "Panorama" geoportals or geoportals supporting the OGC WFS standard. The dialog displays object geometry, object semantics, and highlights them on the map.

The list of user restrictions for data management opened with GIS Server has been expanded: restrictions can be set on copying (export to other formats, transferring objects to other maps), printing, viewing coordinate system parameters, editing coordinates, storing copies of edited objects, accessing cache on the client without server registration, editing the digital RSC classifier, and others. Restrictions are set by the program administrator through the web interface and saved in GIS Server settings. The prohibition on editing coordinates allows changing only the attributive data of map objects (semantics) without changing the coordinates or coordinate system parameters in the map passport (metadata).

Label display has been improved. The new label drawing algorithm takes into account the "Sign rotation angle (in degrees)" semantics (31017). When this semantic is present in an object, the label is oriented according to the specified value. The label is aligned to the center and middle line relative to the metric point.

The toolkit is adapted to work on a wide range of operating systems (Astra Linux Special Edition, Alt Linux, Ubuntu, Windows) and architectures (Intel, ARM, Elbrus). The toolkit includes components for visual design of GIS applications and libraries of multiplatform multithreaded GIS core. GIS Constructor provides a cross-platform MAPAPI interface, allowing programmers to develop in their preferred operating system. Developers can release GIS applications for multiple operating systems through simple compilation with minimal changes to the program's source code.

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

KB "Panorama" has developed Digital Map and Remote Sensing Database version 9.1.0. The new version implements support for PHP 8. This improves the performance and security of distributed spatial data storage systems and ensures compatibility with modern technologies. Loading is faster, and user queries are processed with less delay. The system supports PHP versions 7 and 8, which are included in Astra Linux 1.7 and 1.8.

For administrators, the software configuration has been simplified, with added control over the list of connected PHP modules. Event logging has been expanded for data export, loading of scanned document copies, and monitoring of geodetic points. Notifications about critical errors, warnings, and diagnostic messages are now provided.

Data security is ensured through access rights differentiation based on security tools included in the operating system. The system supports regular authentication, digest authentication, system authentication (via web server), and domain authentication (Kerberos or ActiveDirectory). Additional security is provided through end-to-end authentication when working with the database. Database connection occurs with the rights of the user working with the system. The complex is adapted to work on a wide range of operating systems (Astra Linux SE, Ubuntu, RED OS, MS Windows, and others) and architectures (Intel, Elbrus, Baikal). The program is registered in the domestic software registry under number 1862.

The Digital Map and Remote Sensing Database serves as the foundation for building spatial data infrastructure at federal, regional, and municipal levels, as well as in corporate information systems. Within a unified geoinformation space, the Digital Map and Remote Sensing Database implements the collection, storage, quality control, search, and delivery of spatial data in exchange formats. Spatial data selected using the program can be placed for multi-user access on the GIS Server and published according to international OGC WFS, WFS-T, WMS, WMTS, WCS standards on the GIS WebService SE application server. Users can access data both from a thin client (using GIS WebServer SE) and from desktop applications (GIS "Panorama", GIS "Operator"). The Digital Map and Remote Sensing Database enables the construction of a cloud storage for spatial data, providing access to this data, and automated formation and updating of geocoverages.

The current state of spatial data is displayed using schematic maps, which are maintained for each type of stored data: vector maps, remote sensing data, elevation matrices, and terrain models. Remote placement of spatial data sets in file storage is provided, along with version management of stored sets, updating of data availability schematic maps, automated collection and formation of metadata, and formation and updating of geocoverages. Automated collection and formation of metadata is performed according to ISO 19115:2003, Geographic information — Metadata and ISO/TS 19139, Geographic information — Metadata — XML schema implementation standards. Reduced copies of data images are automatically generated, file checksums are verified, and data set completeness is checked. Spatial data is placed in file storage with integrity verification, structure control, and data content validation. Operation results are logged and recorded in the metadata database. Automatic backup of metadata and spatial data storage is provided with integrity control and data recovery. A multilingual interface is supported.

The "Spatial Data Bank" portal demonstrates capabilities for organizing storage, accounting, and delivery of vector maps, remote sensing data, elevation matrices, and terrain models. The portal contains vector maps in SXF format, created based on data from open sources (OpenStreetMap, VMap0). The spatial data includes maps of: Russian Federation subjects, countries, and cities from near and far abroad. In total, there are over 430 vector maps and 6,700 matrix data sets with a total volume of more than 240 GB. KB "Panorama" specialists update and maintain the information on the portal weekly. All published data is distributed free of charge in accordance with an open license.

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

KB "Panorama" has developed "Cadastral Engineer Workstation" version 15.4.3. The new version expands tools for reading and creating cadastral documents. The "Reading cadastral territory plan and map updating" mode has been improved, implementing the loading of electronic XML documents according to the extract_about_property_room_v01 schema - extracts from the Unified State Register of Real Estate about real estate objects (premises) in electronic form. Since information about premises does not contain coordinate descriptions, an algorithm has been developed to map them as conditional real estate objects located in the center of the cadastral quarter. To obtain coordinates of the cadastral quarter, the program interacts with the "National Spatial Data System" geoportal. All premises attributes are recorded in the map object semantics.

The "State Real Estate Cadastre Information" mode has been improved. When displaying the obtained cadastral information in the "Cadastral Object Attributes" dialog, the ability to call a context menu for copying data has been added to the "Basic Information" tab. A function for saving cadastral information obtained from the Unified State Register of Real Estate to a TXF format file has been added.

In the "Territory Map-Plan" task, the creation of an "Act of agreement on the location of land plot boundaries" has been implemented when performing complex cadastral works. The document is created in DOCX format according to the form established by Appendix No. 3 to Rosreestr Order dated August 4, 2021, No. P/0337. An intelligent algorithm for finding adjacent land plots has been developed to describe sections of common boundaries, taking into account common boundaries by segments or individual points (for example, a boundary at the corner of a plot).

The address database used when filling in the structured address of a cadastral object has been updated. The address database is filled with current information from the State Address Register (GAR). The "Cadastral Object Attributes" mode has been improved to account for differences in the coding of new regions of the Russian Federation in GAR and USRRE. An intelligent algorithm has been developed for filling in the semantics of map objects (coding according to the dRegionsRF USRRE directory) and information from the address database in the FIAS structure (coding according to the GAR directory). The updated semantics recording functions ensure the matching of regions across several positions, including the full and short name of the region in the "Region, republic (list)" semantics. A variable call of the dialog for selecting a structured address has been implemented. Address databases in the FIAS and KLADR structures are supported. A new "KLADR Address" dialog has been developed for selecting an address in the KLADR structure. Configuration for the address database of the required structure (FIAS or KLADR) is performed by specifying the corresponding parameters in the program configuration file. The address in the KLADR structure is used in the Pridnestrovian Moldavian Republic.

A mode "Create objects from CSV, XYH, TXT files" has been developed, providing the ability to read text files with delimiters and map coordinates of cadastral objects. Support for reading source data presented in files with various information field compositions has allowed the removal of outdated modes and their replacement with a single new mode.

For the modes "Creating an object scheme and filling out a report" and "Filling out a report for an object", the formation of new report forms has been implemented: Land Plot Boundary Agreement Act, Cadastral Passport of a Land Plot, Land Plot Drawing, Overview Plan of Land Plots Location, and Geodetic Network Points Layout Scheme. When filling out reports, DOCX format templates are used. The report generation wizard has been improved, with the addition of processing for new markers to insert rows based on object metrics. The system supports obtaining and inserting information about coordinates and point elevation into tables. The insertion of rows with information about adjacent boundaries is provided, including boundary segment designation and the name of the adjacent land plot owner. For filling out the "Geodetic Network Points Layout Scheme" report, processing of selected point objects – geodetic network points – has been implemented.

The "Land Survey Plan" mode has been improved. When forming the "Boundary Agreement Act," the ability to choose a processing option for common boundary sections has been added: by nodal points of adjacent land plots or by all characteristic boundary points. Processing of formed land plot contours has been implemented when generating XML documents for boundary clarification, specifically regarding information about adjacent land plots. When generating XML documents, the algorithm for forming the optional Address subsection has been changed, and the recording of the optional RussianFederation element has been added.

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

Specialists of KB "Panorama" have prepared a video tutorial on working with the "Aerodrome Obstacles Database Management" mode of the "Aeronautical Information Documents Preparation" application in GIS "Panorama". Within the presented mode, artificial and natural obstacles on the surface in the aerodrome area that affect flights are stored. The video tutorial demonstrates the management of the aerodrome obstacles database. The obstacles database section includes an interface for maintaining a database of minimum safe altitudes (MSA) in the aerodrome area and minimum obstacle clearance altitudes on landing courses.

The information entered into the database must comply with the requirements of document Doc 9137 "Airport Services Manual. Part 6. Obstacle Control", Doc 8168 "Aircraft Operations. Volume II". Data entry is performed according to the principle of integrity. The first tab allows entering obstacles in the aerodrome area. Based on these, minimum safe altitudes in sectors are calculated, which are entered in the second tab. The third and fourth tabs operate with obstacles in landing sectors and minimum clearance altitudes for these same obstacles. Information from the first and second tabs is intended for creating Class "B" obstacle charts, while the third and fourth tabs are for Class "A" obstacle charts.

You can familiarize yourself with the training materials in the "Video Tutorials" section.