Maryland State Highway Administration Asset Data Warehouse

Statewide, Maryland

Shutterstock / Travis Photo Works

Since 2011, KCI provided project management, requirements, design, development, testing, training and ongoing maintenance services in support of State Highway Administration’s (SHA) Asset Data Warehouse (ADW) Program. SHA operates, maintains and rebuilds the numbered, non-toll routes—more than 17,000 lane miles and 2,570 bridges—throughout the state’s 23 counties. Within the agency, asset management focuses on taking a strategic approach to better manage their physical transportation infrastructure based upon condition data and performance expectations. SHA’s goal is to obtain the best results, or performance, for the preservation, improvement and operation of infrastructure assets given the resources available. ADW is integrated with the agency’s eGIS system (i.e. enterprise GIS) to provide a repository to integrate, manage and report highway inventory data. The program supports transportation decision-making with intelligent datasets and analytical capabilities by associating this data with other aspects of asset management.

The application provides users with functionality to select, view, edit and report asset information statewide. Users are able to add, update and delete features using maps and associated editor tools. It allows for shared datasets related to asset location and condition for various transportation assets across the state. Users are able to leverage asset specific information to gain an accurate and reliable picture of state infrastructure through an enterprise GIS system and application that is flexible to support all SHA-owned assets. Using the application and the related map interface, users are able to search, review, edit and generate reports.

The efficiency of the ADW program and accuracy of the information presented to end users improves the overall asset management procedures, including asset reporting and maintenance costs.

Our team worked with SHA to create an Asset Editor Widget, which provides a centralized suite of tools and functionality integrated within the enterprise framework to streamline the maintenance of SHA-owned assets. The eligible assets that could be managed using an enterprise asset management approach included bridges / structures, pavement, pipes and small culverts, standard roadway and high mast lighting, ground-mounted signs, mowable areas, traffic barriers, and dynamic message signs. KCI has recently configured the Asset Editor Widget to manage SHA-owned lighting including poles, panels, structures, traffic barriers, rumble strips, signage and park & ride lots.

Since 2011, ADW has grown from the initial three asset types of lighting, traffic barriers and signs to more than ten fully functional and operational editor widgets and field tools.

Bradley W. Spittel, PMPProject Manager

Bradley W. Spittel, PMP

To achieve a flexible and enterprise solution that the SHA ADW program has adopted to serve their expansive stakeholder and end-user community, KCI developed an effective system development life-cycle (SDLC) process to develop the initial application framework, which is called the Asset Editor Widget, and subsequent onboarding of additional assets. The team gathered comprehensive requirements using JAD sessions and meetings to ensure a thorough understanding of the end user and system requirements. JAD sessions have stretched across many user communities throughout SHA. All of the functional and non-functional requirements were documented into a requirements specification document and submitted for review and approval by the sponsor. The team performed a detailed design specification covering the architecture, interface and database environments. The design phase included a prototype and initial interface design wireframes to support acceptance and client approval prior to the build. The development team applied a rapid application development approach to produce iterations of the application releases for stakeholder feedback and testing. The application releases were tested using a traceable test plan and a user-friendly test script. KCI facilitated an end user acceptance testing cycle to obtain feedback and final approval of the application prior to production release. Deployment was accompanied by structured training classes, development of user guides, and a coordinated move into the production environment for the ADW application.

In addition to the initial creation of the ADW Asset Editor Widget, KCI continues to provide documentation, training and application support (as necessary) for SHA staff and end users. The documentation supports standard operating procedures for database maintenance and consistency of information. As SHA expands the ADW, KCI continues to push the application’s capabilities to include all new elements as they are defined, making the eGIS program a “living” system that will continue to satisfy the needs of the client as they develop.