This project, Panacea, is a system aimed at storing data about city ambulance calls, building flexible dashboards, statistics and people search.
Once, in 2015 Lviv Governor visited Lviv main ambulance station and learnt that the statistics of all the ambulance calls was handled manually by staff, data about calls were only on paper. It would take quite a while to find anything in that "database". So he commissioned a solution that would automate this process.
The administration of city ambulance sent me a request for this work.
As I love my city, I was excited when I heard about the opportunity to optimize such an important thing like ambulance operation. I have always wanted to develop something like this. After presentation of my proposal, we signed a contract for the development of software.
I named this solution Panacea. Currently, Panacea is used to collect and store information about all the calls that the ambulance station receives. Later this information was used to calculate statistics, search for people and monitor staff performance.In the middle of 2018, the database counted more than 500 000 calls. There are about 500 calls every day.
The main tasks that Panacea solves:
- recording of all calls (earlier all information was stored only on paper);
- search for calls by parameters;
- view statistics by any parameter;
- searching for people who got lost;
- monitoring the time that an ambulance needs to get to a sufferer;
- identify crews with the longest pick-up time to improve their work;
- generation of reports for the Ministry of Health of Ukraine.
This product has been working steadily since 2015. The entire development process, from writing of documentation and drafting of contracts to deployment on the server, was my work.
PostgreSQL, Ubuntu, PHP, JS, AngularJS, SCSS.
A graph that displays statistics on the social status of ambulance patients
Number of calls over the last 10 days and the last 5 entered calls
Call table displayed to a substation operator
Call information entry by an operator
Selection of calls with long pick-up time
Calls received over the past 24 hours
Statistics on arrival standards
Search for calls with certain parameters