14-Crash Analysis System (CAS) – a crash data analytics and visualisation platform

Orbica and partner Catalyst developed a user-friendly web application to live stream New Zealand Transport Agency’s 1.5 million crash record database so that transport planners and engineers (with no prior SQL knowledge) could perform complex stacked spatial and aspatial queries with ease.

The following components and corresponding APIs were built:
• A React, Leaflet and WebGL based front-end
• A PostgreSQL/PostGIS and SQL Server spatial-based geospatial database
• PHP, SilverStripe, web socket-based layer for data streaming

Orbica mixed and tweaked existing Leaflet plugins to create comprehensive modular components for the GIS aspects of the CAS solution. Main features included:
• A fully “edit geometry” standardised plugin including the following:
o Leaflet.FreeDraw
o Leaflet.draw
o Specific business editing functionalities

This works in conjunction with map data visualisation and schematic/mapping data visualisation developed using PIXI/WebGl.
The road safety community uses CAS to output complex collision diagrams and reports to help them advocate for road safety improvements.

Download Presentation: