groupElizabeth Grimmett, Brett Droder

menu_bookVolume 15 Number 1

collections_bookmarkProfessional practice placement profiles

lockMember Access

printPrint Article


Introduction

Electronic Personal Mobility Devices (ePMDs) such as e-scooters (electric scooters), e-skateboards (electric skateboards), hoverboards, segways, and one-wheels, have emerged as an important part of city transport ecosystems across the globe. Hospitals, police and ambulance services, health insurers, advocacy groups, and state and local governments are committed to the management of ePMDs. Vital to informed decision-making by all stakeholders is accurate and timely ePMD injury data.

From July to November 2023, the Streamlining data collation and reporting of ePMD injuries project was undertaken by the Jamieson Trauma Institute (JTI) with the support of a Queensland University of Technology (QUT) health information management student. The project’s objective was to streamline JTI’s current ePMD data management system and establish regular reports for stakeholders to meet increased demand for ePMD injury data.

Background

Globally, ePMDs are increasing in popularity, rapidly evolving into an integral part of city transport ecosystems. ePMDs have proven to be a viable option to use in lieu of short car trips, in addition to transiting to and from public transport (Brisbane City Council, 2021).

For the purposes of this project, ePMDs are defined as predominantly battery powered devices including:

  • e-scooters
  • e-skateboards
  • segways
  • one-wheels (electric unicycles).

Since the introduction of shared e-scooter schemes in Brisbane, ePMDs have become more accessible and affordable which has increased overall utilisation (Pace et al., 2021). However, increase in utilisation has attributed to an increase in injuries involving ePMDs.

The JTI “contributes to national and international evidence and works to develop solutions to challenges facing Queensland trauma care” (JTI [Metro North Health], 2023). JTI’s most recent study of three major Brisbane emergency departments (EDs) examined ePMD injuries from 2018, when ePMDs became much more prevalent as a mode of transport in the city. The study demonstrated that over the 31-month period of study, there were 1048 ED presentations related to the use of ePMDs with the vast majority (90.8%) involving e-scooters (Vallmuur et al., 2023).

Ongoing ePMD injury surveillance is essential as “quantifying the extent of ePMD-related injuries presenting to hospital EDs will enable a better understanding of patterns, severity, circumstances, and treatment outcomes of these incidents for the Australian community” (Vallmuur et al., 2023). Accurate and timely injury data is critical to “provide valuable insights regarding the impact of any changes to the enforcement, regulation or education around ePMD use” (Vallmuur et al., 2023).

Prior to the student placement, JTI’s data management processes required a significant level of manual data handling and medical chart review. This was largely due to the data source sites, EDs, using different software programs to collect and provide data to JTI, making data compatibility an issue. Additionally, information of interest to ePMD stakeholders often needed to be collected manually from the patient’s medical chart, for example:

  • if alcohol was involved in the ePMD injury
  • if the rider was wearing a helmet
  • if the ePMD was privately owned or part of a public hire scheme.

Project Highlights

The Streamlining data collation and reporting of electronic ePMD injuries project scoped and created a more efficient data management and reporting system for ePMD-related injuries. This was achieved by:

  • establishing an ongoing agreement with the Queensland Injury Surveillance Unit (QISU) to source monthly injury data from 29 Queensland public EDs
  • developing a draft data dashboard in PowerBI to convey key ePMD injury statistics to ePMD stakeholders.

Implementing a new method for JTI to source ePMD injury data

The methodology selected by JTI to source ePMD injury data formed the basis for subsequent project implementation. Original planning indicated that ePMD injury data for this project would be sourced directly from two major Brisbane EDs. However, it became apparent during the consultation phase of the project that there was another viable option for sourcing ePMD injury data: through the QISU.

Whether data sourced through QISU would be sufficient for the project’s purposes became a focus of discussion for the Project Steering Committee. A document summarising options for sourcing the data was prepared (Figure 1). It should be noted that most Queensland hospitals use the Emergency Department Information System (EDIS) software for patient data management however Hospital B uses FirstNet for their ED data management. The difference in information systems raised data compatibility issues, which was also a consideration for JTI upon deciding how to source and manage the injury data.

The options presented to the Project Steering Committee (Figure 1) were:

  1. directly sourcing ED injury data from two Brisbane hospitals (Hospital A and Hospital B)
  2. sourcing ED injury data through QISU however adding one hospital’s data manually (Hospital B which uses FirstNet)
  3. sourcing ED injury data through QISU.
Figure 1: Data source options

The Project Steering Committee chose Option 3 due to:

  • data to be reported in a reliably consistent format
  • fast turnaround from when the injury occurs
  • state-wide coverage.

However, the Project Steering Committee also expressed a strong desire to expand the data collection to include non-QISU hospitals in the future, especially those hospitals in areas that had e-scooter hire schemes already operating in the community.

Activities for this project milestone included:

  • meeting with key staff from Hospital A and Hospital B to obtain a further understanding of their data management and data export processes for ePMD presentations based on previous JTI research
  • meeting with QISU to obtain an understanding of how injury data flows from hospitals to QISU
  • examining current and anticipated future uses for ePMD related injury data across ePMD stakeholders
  • developing a stakeholder analysis table
  • analysing JTI’s current data collection processes for ePMD injury data
  • undertaking a data field mapping spreadsheet to compare fields that may be sourced through different data source options
  • developing a data source options summary as a discussion document for the Project Steering Committee (Figure 1).

Establishing the data partnership with QISU and implementing the new data management system

Establishing a project partnership with QISU and implementing the new data management system including the following activities:

  • writing and submitting a data request to QISU for the initial batch of data (covering ED presentations from November 2018 to July 2023 inclusive in addition to future ongoing monthly data batches
  • meeting with QISU to discuss the planned search parameters
  • collaborating with the Project Steering Committee to develop categories for QISU to classify the data to, for example:
    • Helmets: was a helmet worn?
    • Alcohol: was there mention of alcohol?
    • Number of riders: was it a single rider or doubling?
  • examining the data once the initial batch was received from QISU, including investigating data anomalies
  • establishing inclusion and exclusion criteria for the ED presentations (Figure 2), with approval from the Project Steering Committee for various scenarios, for example:
  • Where a presentation involved a ‘scooter’ without any further details, should this be assumed to be an e-scooter? Should the age of the rider be considered e.g. should a ‘scooter’ ridden by a 6 year old, a 16 year old, or a 90 year old default to different types of scooters?
  • Where the presentation indicates a motorised scooter without any further details, should this be assumed to be an e-scooter or a moped?
  • creating a Data Dictionary for the database.
Figure 2: Inclusion and exclusion criteria

Establishing processes for the monthly data importation

Although this project was not expected to include data importation processes, by sourcing data through QISU, the importation processes became more efficient than anticipated. Since all data was received from QISU in one excel spreadsheet, it was possible to expand the scope of the project to include the importation and verification of two subsequent batches of data from QISU (for August and September 2023).

Creating a reporting mechanism for stakeholders: the ePMD injury dashboard

PowerBI was used to create the second key deliverable for the project: an ePMD injury dashboard. The purpose of this dashboard was to provide an easy-view page displaying key ePMD injury statistics for ePMD stakeholders.

The final format and distribution method for the dashboard was determined by the Project Steering Committee after conclusion of the project. Options included that the dashboard be distributed as an interactive dashboard, so that stakeholders could drill down to view and analyse specific hospitals, timeframes, age groups or other categories they may be interested in. Alternatively, the dashboard could be converted to a pdf to become a state-wide snapshot of ePMD injuries for the month, with the addition of year-to-date totals or running overall totals. Minimising the risk of data misinterpretation required significant consultation beyond the scope of this project. However, it was a key achievement of the project to present the draft dashboard (Figure 3).

Figure 3: Draft ePMD dashboard

Several other data visualisations were also created in PowerBI. These may be used in response to specific stakeholder requests and/or for data analysis.

Developments since the conclusion of the student project

This project represented an important platform for JTI’s ongoing work in monitoring ePMD injuries in Queensland. Since the conclusion of the student placement, the injury dashboard has been refined and continues to be updated monthly. The data importation processes are working well, with QISU providing a monthly data extract. The presentations are classified by QISU across 10 categories prior to being received by JTI.

The development of the dashboard was presented at the Royal Brisbane and Women’s Hospital Foundation (RBWHF) All Staff meeting with positive feedback and an interest in other applications. Additionally, JTI had submitted an abstract to present ePMD injury findings at the 2024 Australasian Road Safety Conference in Hobart. The abstract was accepted, and the findings were presented. The abstract was ranked in the top 50 submissions of ~300. The Royal Automobile Club of Queensland (RACQ) used ePMD injury data sourced through JTI in an article for their website and JTI are continuing to inform road safety messaging and policy in partnership with RACQ. A major joint media release between JTI, RACQ and RBWHF was undertaken in November 2024 based on the broader ePMD program of research including figures from the dashboard, with coverage from various news outlets, generating 144 media items, reaching a potential audience of 3 million.


References


Authors

Elizabeth Grimmett BHIM, CHIM
Senior Health Information Manager, Surgical Treatment and Rehabilitation Service (STARS)
Level 7, 269 Herston Road, Herston QLD 4029
Tel: +61 7 3647 6303
Email: elizabeth.grimmett@health.qld.gov.au

 

Brett Droder BHIM, CHIM, CHIA
Health Information Manager, Jamieson Trauma Institute
Herston QLD 4029