Developers of Emergency Map were tasked to implement a combined visualization of the data on the example Ministry’s of Emergency Situations of fire accidents statistics. The product should easily adapt to any sort of data and be a universal tool for statistical purposes.

At the moment, there are services that solve individual tasks of visualizing data. (Example: the criminal map of Minsk, a map of cellular coverage, etc.) However, there is no available ready-made solution that each developer could use to visualize the necessary data in a few clicks.

Developed solution allows to visualize multidimensional information effectively.It has an user-friendly interface. Code is easy to modify for any sphere of usage. Application of color mixing enhances perception and analyzation of information.

Languages: PHP(server part), JS(client part),HTML+CSS(markup + style), SQL(Database requests).
DBMS: MySQL
Third-party APIs: Yandex map API (map rendering, polygon coloring, polygon click actions), Nominatim API(obtaining requested geographical region polygon).
Use example: site brakh.men/map

SQL request to create table:

CREATE TABLE `TableName` (
  `id` INT(100) NOT NULL,
  `Region` VARCHAR(40) COLLATE utf8_unicode_ci NOT NULL,
  `Date` DATE NOT NULL,
  `Situation` INT(20) NOT NULL,
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
ALTER TABLE `TableName`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `TableName`
  MODIFY `id` INT(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
COMMIT;

Database completion guide for developers:
Region - the geographical name of the object to be painted (as precisely as possible). Example: Brooklyn, New York City, New York, USA, Earth, Sol, Milky Way, Universe (Unsign)
Date - date, tied to the situation.
Situation - situation number. (Each situation is assigned a unique number)
Yaer - year of origin of the situation (For convenience of sorting by years)


Config.php file have to be filled

In the development of this service involved:

• Pankratiew Alexandr
• Holubeu Kiryl
• Pilinko Nikita