Better accident prevention thanks to new accident database
Seilbahnen Schweiz (SBS) is the leading association of the Swiss ropeway industry with around 350 members from all regions of Switzerland. As the industry representative for large to small ropeways, Seilbahnen Schweiz represents the interests and concerns of its members and promotes their cooperation as well as sustainable development. This results in a broad spectrum of activities, ranging from representation of authorities to member consultation and public relations. In addition, the association operates a training center for ropeway technicians and offers training and continuing education in the area of piste and rescue services.
Initial Situation
The accident database is one of the core applications of Seilbahnen Schweiz and the most important tool for recording and analyzing accidents on snow sports facilities and accidents during summer activities in the catchment area of the transport facilities. Due
to the choice of state-of-the-art technology, the existing application could no longer meet today's standard safety requirements. Furthermore, the user-friendliness was outdated and data protection had to be adapted. In addition, a modernized accident database was to improve the quality and timeliness of the data, expand the evaluation options and optimize interfaces to other systems.
Solution
With the new accident database, all members of Seilbahnen Schweiz can quickly and easily record and manage any accidents online. Using a mobile app, patrollers can record photos and GPS coordinates directly on site. This saves time and avoids errors due to subsequent transmission. All accident data can be downloaded as an accident log (Word) or as a CSV export from the accident database. The collected data can be evaluated for statistical analysis over several years. The new solution is designed to store sensitive personal data and meets the highest data protection and data security requirements. Fine-grained assignment of access rights controls the visibility of data, and multi-factor authentication protects against unauthorized access to the application and data.
Technologically, the Azure solution is based on Platform Services such as Azure SQL Server and Azure Blob Storage (data), Azure AD and Azure AD B2C (identity and access management), Azure App Service with .NET Core and Blazor (backend and user interface). The project includes the transfer of all functions from the existing application, the migration of all historical data into a new database and the continuation and extension of the existing interfaces to other applications. The optimization of data exports for statistical analyses and Excel exports ensures the expandability for the connection of Power BI dashboards and reports.
Benefits
- Thanks to the findings from the accident database, the number of accidents in Switzerland is reduced with targeted measures.
- Members, with their own accident recording software, transmit their data via a central interface. This guarantees seamless integration and high data quality.
- The central recording of accident data also allows the automated transfer of accident data to partners such as the federal office for accident prevention.
- An audit log records all changes to data, ensuring transparency and security in the event of legal disputes.