Submission ID 127916
| Session Title | DA - Transportation Data and Analytics |
|---|---|
| Title | An In‑House Data Governance and Analytics Platform for Shared Micromobility Oversight |
| Abstract | Canadian municipalities piloting shared micromobility services face a recurring data challenge: operational oversight often depends on separate operator applications and periodic summaries, limiting independent verification, delaying issue identification, and increasing staff effort to compile and reconcile information across providers. These limitations are especially acute for near real‑time fleet oversight, geofencing compliance, parking performance, and timely response to resident concerns, underscoring the need for a unified, municipality-owned data environment. To meet this need, the project team aimed to create an integrated, in-house analytics platform to provide a single authoritative “system view” for day‑to‑day operational monitoring and longer‑term evaluation. The platform integrates three data streams: (1) General Bikeshare Feed Specification (GBFS) feeds for near real‑time device and station availability; (2) Mobility Data Specification (MDS) feeds for trip/activity analytics and compliance indicators; and (3) municipal Customer Relationship Management (CRM) records for resident complaints and time‑to‑resolution outcomes. Data are standardized across operators to support consistent KPI definitions and cross‑operator comparisons. Role‑based access controls, automated validation rules, and embedded privacy protections enable secure internal use and consistent interpretation of data across authorized partners. The solution reduced manual monitoring and reporting effort by an estimated 50–60 staff hours per month and avoided an estimated $12k–$24k per year in third‑party platform subscription costs. Beyond efficiency gains and cost avoidance, the standardized and timestamped “system view” strengthened governance by enabling consistent cross‑operator KPI reporting, improving the quality of accountability discussions with service providers, and supporting independent verification of operational conditions. The integration of CRM complaints with GBFS/MDS conditions improved closed‑loop management by helping staff triage resident issues more quickly, link concerns to on‑street conditions, and track resolution outcomes. Analytics outputs—such as demand and drop‑off/pick‑up density hotspots, parking performance views, and restricted‑zone/geofencing overlays—supported proactive identification of recurring issues and priority areas for interventions. By delivering consistent metrics for temporal trend analysis, including cross‑operator/device comparisons, the dashboard enhanced program evaluation and supported data-driven decision making that informs service planning and infrastructure improvements. Overall, the platform demonstrates a scalable and replicable municipal approach to strengthening oversight, improving responsiveness, and enhancing transparency in monitoring transportation programs. |
| Author and/or Presenter Information | Qing Su, City of Vaughan
Winnie Lai, City of Vaughan |