Dataflow integration and data concentration solution for regional government, police and emergency services

About project

Integrated Dataflow Solution for Regional Governments, Police, and Emergency Services - First Edition

Facts

Integrated services for 9 government departments, including police, road police, medical emergencies, and firefighters.
Deep analytics of Data flow monitoring and accessibility indicators.

Customer

The government of the Krasnodar Region

Krasnodar region is a federal subject of Russia, located in the Southern Federal District. The region's population is about 5.5 million people on a territory of 75,485 sq. km.

The Region is characterized by industrial and agro-recreational types of development. The basis of the regional productive forces constitutes the industrial, construction and energy complexes, information and communication technologies, as well as agro-industrial, transport, resort and recreation, and tourist complexes. The last three - agriculture, transport, and hotel & tourist complexes - correspond to the priorities of the socio-economic development of Russia and determine the special status of the Krasnodar Krai in the national economy.

Also Krasnodar region city Sochi was the host city of the Winter Olympic Games of 2014.

Goal

darts image
To bring the actual information on any emergency that happens in Krasnodar Region for real-time monitoring and further analysis.

Challenge

Some government services, such as the police, road police, and fire department, are separate from the regional government. Additionally, central emergency services, such as 911, may also be under municipal government control. The healthcare system adds to the complexity, with some hospitals under municipal authority and others under regional control. This results in obstructed interaction and data exchange between different government organizations in a single city. Decision-makers in the regional government often lack the most up-to-date information and must rely on outdated reports, hindering their ability to get a clear picture of the current situation.

Tasks

1
Create the data integration platform.
2
Design and approve the protocols for interaction with authorities having different levels of information technologies and mixed information security approaches.
3
Implement the approved interaction protocols.
4
Develop data visualization dashboards.
5
Implement service monitoring systems, based on BI

Implementation

Spellsystems delivered the integration solution based on the Microsoft SQL Server Business Intelligence, with additional software components developed with C#.

First, we made a deep research of existing approaches for managing emergency event data in authorities participated in the project. After that, we developed documentation for interaction between absolutely different IT systems. Later, we did our best to come to an agreement with regional government regarding non-automated emergency registration. We suggest an individual solution for each of such event and system. When we were given the green light, we continued with the technical part.

In the first stage, we deployed the server software infrastructure. Our partner Government Company “The Center of Informational Technologies” provided hardware infrastructure and secured communication channels.

In the second stage, we implemented approved interaction protocols and emergency registration functionality for some participants. The key problem there was a large amount of transfer and markup protocols. Some authorities preferred to use FTPs+CSV, some HTTPs+SOAP, some FTPs+XML, some HTTPs+JSON, some asked to use VipNET functionality for scheduled file transfer, and so on. We had even the case, when one of the participants asked us to access his statistical database directly. 


Results

1

The  platform for the data flows integration that processes all the input data, converts this data into the universal storing format, adds some service information and puts it into the central database.

2

Regulatory documents define the rules and the technology of the interaction between different services.

3

Visualization tools: intranet portal based on the Microsoft SharePoint Portal and Business Intelligence instruments for decision support based on Microsoft PowerPivot/PowerView.

Technologies

Basic technologies
1
C#
Storing and working with data
2
Microsoft Integration Services, Microsoft PowerPivot
Microsoft PowerView, Microsoft SQL Server Business Intelligence
Web Interface
3
ASP.NET

Platforms

Web services

Team

  • 1 project manager
  • 1 C# programmer
  • 3 BI managers
  • 1 ASP.NET programmer

Similar cases studies