cityofaustin/atd-data-tech

Project: Moped v2.0

Closed this issue · 9 comments

We're expanding the capabilities of our mobility project management solution to support key workgroups.
moped thumbnail

Background

Moped is our shared platform for Austin Transportation and partners to manage the City of Austin's complete portfolio of mobility infrastructure projects. We launched Moped v1.0 in early 2022, with a focus on traffic signal projects. Since then, we have continued to release new features on a bi-weekly basis.

Moped v2.0 encompasses new capabilities to support a much larger portfolio of projects, and crucially, will entail the migration of a legacy project tracking tool into Moped.

Scope

  • A new user interface for project mapping with an improved data structure designed to accommodate projects of all scopes and sizes
  • An improved activity feed that allows users to easily keep track of project activities
  • A data migration of 2,000+ projects from a legacy Microsoft Access database into Moped
  • Building a public-facing mobility project explorer.

Screenshots

Moped-Map
Moped-Projects
Moped-Dashboard

Screen Shot 2022-10-25 at 9 48 20 AM


This Github issue represents a project of Austin Transportation's Data & Technology Services team. Project status is documented regularly in the comments below.

We have continued to deliver a large number of incremental improvements to the Moped user interface, while also staying focused on the game-changing features that will expand our Moped user base.

Incremental improvements

  • Added additional fields for tracking contract data
  • Implemented better tracking of who created a project, the workgroup responsible for delivery, and the project's sponsors.
  • Made the project editing experience more intuitive and reduced the number of clicks required for common tasks
  • Refined the project list layout and expanded the data that can be downloaded to a spreadsheet

Activity feed

We have established a new back-end workflow for capturing project editing activities in our database (#10600), and are currently working to expand the scope of project editing activities that we track, as well as improve the readability of the activity feed UI.

Project mapping

We have completely overhauled the project mapping user interface and data model. This work (#10399) is wrapping up, and we should deliver the new and improved mapping interface in February 2023.

Access database migration

Our work on the legacy Access database migration is progressing smoothly. We're meeting with stakeholders on a weekly basis, while simultaneously implementing the migration code so that stakeholders can review our progress and give feedback.

We have continued to deliver a large number of incremental improvements to the Moped user interface, while also staying focused on the game-changing features that will expand our Moped user base.

Incremental improvements

  • Tracking project status alongside project status updates and comment, so that users can easily track a project's progress over time

Activity feed

  • We have completed the foundational technical work to simplify how we scale out our activity feed, and are continuing to improve on the visual design of the feed, as well as add change tracking to all project properties. We most recently added tracking of changes to a project's tags.

Project mapping

Our mapping interface overhaul is on track to be released with v1.15 on January 19th!

Access database migration

Our work on the legacy Access database migration is progressing smoothly. We're meeting with stakeholders on a weekly basis, while simultaneously implementing the migration code so that stakeholders can review our progress and give feedback.

Recently completed

  • New project mapping interface ✨
  • Better activity log tracking

In progress (ETA 3/1)

  • Show child projects on project map
  • Show signal ID on project map list
  • Project component phasing

On deck / ongoing

  • Access Database migration
  • Enhanced project work type tracking
  • New component and subcomponent options

We have implemented a number of new features which support cross-division collaboration, with a focus on spatial data quality. We've also implemented a major upgrade of our state-of-the-art user interface library, Material UI.

Recently completed

  • Show child projects on project map
  • Show signal IDs on project map list
  • Enable project component phases

In progress

  • Active Transportation & Street Design Access Database migration
  • Enhanced project work type tracking
  • New component and subcomponent options

Scoping

  • All projects map

Screenshot of related projects shown on map:
Screenshot 2023-05-01 at 10 10 20 AM

Screenshot of all projects map prototype:
Screenshot 2023-05-01 at 10 09 38 AM

We have continued to push minor bug fixes while keeping our focus on the Active Transportation & Street Design (ATSD) database migration. We are running successful end-to-end tests of the migration, with just a few features in the Access database left to address.

Recently completed

  • Upgrade User Interface library to latest version
  • Add support for tagging project components (to support ATSD migration)
  • Add support for tracking project component work types (to support ATSD migration)
  • Create Moped components from ArcGIS Online features (to support ATSD migration)

In progress

  • Add support for enhanced work authorization and contract tracking (to support ATSD migration)

Scoping

  • All projects map

We have continued to push minor bug fixes while keeping our focus on the Active Transportation & Street Design (ATSD) database migration. We are running successful end-to-end tests of the migration, with just a few features in the Access database left to address.

Recently completed

  • Add support for enhanced work authorization and contract tracking (to support ATSD migration)

In progress

  • PowerBI and ArcGIS Online Integration

Scoping

  • All projects map

The development work to migrate Active Transportation & Street Design (ATSD) from their Access DB to Moped is 95% complete. We will begin quality assurance testing next week. It is possible that we will complete the migration and go live with ATSD in September! This will include 12k+ project records plus 30 new active users in the Moped system.

Additionally, we are supporting the Smart Mobility Office's effort to onboard to Moped. They are currently testing Moped for managing their pilot projects

Recently completed

  • Enhanced map editing features for complex projects
  • Expanded options list for subcomponents, work types, and tags
  • Expanded options for project funding and programs
  • Create 70+ Moped users for ATSD-related projects (includes active and historical users)

In progress

  • PowerBI and ArcGIS Online Integration
  • Overhauled user interface for tracking work activities
  • Data modeling for ATSD-specific project tags and project milestones
  • Ability to store links to files on G drive, sharepoint, etc

Scoping

  • All projects map

Quality assurance testing is underway as we work to migrate the Active Transportation & Street Design (ATSD) from their Access DB to Moped. As a result of this recent QA testing, our team has quickly delivered a few must-have features for ATSD. Our expectation is that the migration will be complete this month (Oct 2023).

Recently completed

  • The ability to copy a project component to another project
  • Automated reporting by council district based on project map
  • Improvements to project location tracking
  • Ability to store links to files on G drive, sharepoint, etc
  • Project list performance improvements
  • Overhauled user interface for tracking work activities
  • Data modeling for ATSD-specific project tags and project milestones

In progress

  • PowerBI and ArcGIS Online Integration
  • Ability to hyperlink to a project component
  • Add additional fields to the advanced project search, plus more performance enhancements

Scoping

  • All projects map

We successfully completed the ATSD Access DB migration on Nov 6th. With all 2,000+ projects and 11,000+ project components successfully uploaded to Moped, the Active Transportation & Street Design Division is now live in Moped!

We are continuing to prioritize various enhancements which provide continuity of operations for ATSD. Those issues are tracked under the epic #13976.

It is also worth noting that we completed the Moped <> ArcGIS Online integration (#10203) and released many substantial improvements in the v1.35 Release that preceded the Access DB migration.