ASSET DATA WAREHOUSE

1. ASSET DATA WAREHOUSE TUgis 2014 March 18, 2014

2. Introductions Joseph Benedetta, Asset Management Coordinator Maryland State Highway Administration Office of Planning & Preliminary Engineering Program Development Division 410.545.5633 jbenedetta@sha.state.md.us Laurie Goudy Maryland State Highway Administration Office of Planning & Preliminary Engineering DSED 410.545.5681 lgoudy@sha.state.md.us Brad Spittel & Scott Messier KCI Technologies, Inc. Geospatial Solutions 443.615.0734 brad.spittel@kci.com

3. Overview of Asset Management Program • Overall objective of asset management: • Meet desired performance standards in the most cost-effective way today and into the future • To effectively manage our transportation assets, we need: • Good information on what infrastructure assets we own and / or maintain • Good information on what condition these infrastructure assets are in • Data on how they are performing

4. Asset Data Warehouse Application • Goals of ADW project: • Easy-to-use toolset for maintenance of asset information: • Lighting • Traffic Barriers • Signs • Rumble Strips • Line Striping • GAMS - Invasive Species • Park & Ride Lots (coming soon) • Raised Pavement Markings (coming soon) • Integrated map for editing and display of assets • Centralized GIS database, integrated within a secure application framework (eGIS), comprehensive reporting capabilities

5. Timeline of Assets ADW Lighting (April 2011) ADW GAMS Invasive Species (September 2013) ADW GAMS Field Tool (March 2014) ADW Park & Ride (January 2014) ADW Traffic Barriers (September 2011) ADW Rumble Strips (March 2012) ADW Line Striping (August 2012) ADW Signs (September 2012) ADW Raised Markings (January 2014)

6. Asset Data Warehouse - Security • Secure environment for maintaining asset data • Only users with editor privileges have the ability to add, update, or delete data • System recognizes users based on Windows’ sign-on

7. Interface Overview - Selection • Two Selection Methods: • Select by Form • Select by Map

8. Interface Overview - Selection by Map • Draw polygon on the map to select

9. Interface Overview - Results • Results Tab: • Presents assets by route • Features • Attributes • Selection tab is accessible to change selection criteria

10. Interface Overview - Results • Attribute Information Manager: • For the record selected in the Feature Manager, information can be updated / modified and then saved • Attributes are displayed based upon the selected tab: • Installation tab • Signs (panels) tab

11. Primary Editing Functionality • Editing tools available in asset editor: • Add - adds sign installation feature with attributes to the signs database • Move - adjust the position of an existing asset feature to a new location on the map • Delete - remove a feature from the database • Update Location - change the route information associated to the feature

12. Demonstration Walkthrough: eGIS ADW Asset Editor

13. Benefits • Easy-to-use, eGIS-based environment for data maintenance • Centralized management and storage • Integrated reporting • Future enhancements: • Field data collection tools • Linking asset information to third-party maintenance work order systems • Cost analysis and life expectancy • Additional assets • Maintenance and enhancements to existing assets

14. Development & Deployment Process • Requirements • Design • Wireframes mockups • Database structure • Data migration plan • Development & Testing • Deployment • Production release • Documentation • Training

15. Contact and QA Joseph Benedetta, Asset Management Coordinator Maryland State Highway Administration Office of Planning & Preliminary Engineering Program Development Division 410.545.5633 jbenedetta@sha.state.md.us