This article is focused on the creation of a data model of an information system to support the processes of population sheltering (PoS). PoS processes have undergone significant changes in the Czech Republic. The PoS system was transformed for the use of improvised shelters. For sustainable PoS, it is necessary to standardize the approach of crisis management staff. Key research hypotheses: the data model must respect the methodological framework of planning and implementation of the PoS, especially when used for the design and implementation of the improvised shelters; the standardization of residential buildings can be used to facilitate and streamline the sustainable process of planning of the PoS; the unified data model of the PoS can be considered suitable for standardization and development in the field of sustainable planning and implementation of the PoS. Softwares such as SW QGIS desktop 2.6.0, OpenStreetMap (OSM) spatial database, ESRI shapefile format, and S-JTSK/Krovak East North 5514 coordinate system were used for the verification of the spatial data model, and ASP.NET MVC 4.7.2 Microsoft SQL Server Express 2019, jQuery 3.3.1, Bootstrap 3.4.1, Kendo UI 2019.1.220, and virtual Windows Server 2016 were used for the implementation of the physical data model. The physical data model substantiates the benefits.
The research presented in this article is focused on managing the process of inserting new scenario into the virtual simulator. The first part of the article defines the basic logical division of scenarios whilst the next part contains the design of a tool for MS Excel. The tool is used to simplify the addition of a scenario into the existing simulator by means of an automated SQL script generation and this article describes its functionality together with an algorithm of its usage. The conclusion deals with checking the functionality of the tool by running the resulting SQL script with the existing database and by checking that the loading of the database with new scenario is correct.