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

Complexity:
Budget:
Timeframe:

About project

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

Facts

9 government departments and emergency services are integrated including police, road police, medical emergency and fire troops.

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

Part of government services like Police, Road Police or Fire Troops are independent of the regional government. In addition, central emergency services (like 911 in the USA) are also independent of the regional government in case they are subordinate to municipal governments. The situation is even more complex in healthcare, because some hospitals are subordinate to the municipal level and some to the regional level. Thus, the interaction and data exchange between different government organization that located on one city are extremely obstructed. And decision-makers from regional authorities always suffer from the lack of most recent information. They tend to rely only on reports on the previous periods that can not give 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.

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

Complexity:
Budget:
Timeframe:
Integrated enterprise content-management platform for regional government, including several web portals, intranet-portal, doc flow automation, full-text search server, and document recognition subsystem
Complexity:
Budget:
Timeframe:
Contract management system for IKEA/MEGA
Complexity:
Budget:
Timeframe:
Geographic information system for critical city infrastructure and dangerous facilities inventory