Thematic mapping based on Rosstat data

The script is designed for preparing thematic maps of the subjects of the Russian Federation based on summary tables (indicators of socio-economic monitoring) published on the Rosstat website. Based on the selected table and column of numeric values, the calculation of color gradation and construction of a thematic map are performed. The result of the work is a vector map (SITX format file) and automatic opening of the document in GIS Panorama.

Based on the indicators of socio-economic monitoring (selected Excel table, column number with values) and scale boundaries (minimum/maximum), gradation calculation and thematic map construction are performed.

The upper part of the window displays a summary of loaded tables (quantity, date of last download from the portal) and a Get button. If tables have already been obtained previously, the data type (indicator) can be selected from the list without re-downloading. To re-download data, click the Update button.

The main field is the selection of an indicator from the list and a separate table preview block. The preview displays a header with the full name of the indicator and a label of the period, units of measurement.

The Entire table/Selected value column toggle switch allows displaying the entire table or the selected value column. The Preview field displays the first 10 records of the table.

Map construction parameters are grouped at the bottom of the window. The Minimum and Maximum fields read the minimum and maximum values in the selected column. The color selection buttons for extreme values allow customizing the colors of the generated thematic map.

The Execute button starts the thematic map construction and becomes available when data has been loaded from the portal.

The Exit button closes the dialog.

The Help button opens the help page.

The name of the thematic map is generated automatically from the indicator name and period information. Files are saved in the rosstat2map/thematic_map subdirectory inside the Panorama.Cache directory. The path to the data folder or its contents can be changed in the Options ➝ Data location menu.

A legend, color gradations and range value labels, as well as the map title, which is formed from the name of the selected indicator and units of measurement, are automatically added to the map.

The generated thematic map provides a visual comparison of official Rosstat indicators with the territory of the subjects of the Russian Federation, which is convenient for monitoring, reporting, presentations and subsequent design of cartographic products.