1 / 34

Mining ROAdMAP Data: ALDOT’s Early Experience

Mining ROAdMAP Data: ALDOT’s Early Experience. 2013 southeast regional Maintenance conference. This Presentation is a Modified “rebroadcast”. Originally a preliminary presentation prior to a work session to review RoadMAP performance guidelines It has been reformatted to fit your screen!

najila
Download Presentation

Mining ROAdMAP Data: ALDOT’s Early Experience

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Mining ROAdMAPData:ALDOT’s Early Experience 2013 southeast regional Maintenance conference

  2. This Presentation is a Modified “rebroadcast” • Originally a preliminary presentation prior to a work session to review RoadMAP performance guidelines • It has been reformatted to fit your screen! • The books handed out are a companion piece to this presentation (I HAVE NO BOOKS)

  3. So what is roadmap??? • RoadMaintenance Accountability Program • ALDOT’s new MMS implemented July/August 2011. • CitiTech Systems V8.1.4569.15109 • Approximately 300 licensed users generate 100,000 work reports annually for the 70 routine activities that are performed. • Has accumulated some interesting data….BUT, generating reports and analyzing data within RoadMAP has proven to be…..challenging (to say the least). Performance speed and credibility issues with end users affecting acceptance of program. • Hence, the need for additional tools.

  4. Method of Analysis - SPSS • Statistical Package for the Social Sciences • Now owned by IBM • ALDOT licenses SPSS Modeler • Purchased fall 2012 • Training provided by IBM in December 2012 • Data mining & analysis began Spring 2013

  5. SPSS Stream to Read RoadMAP Database and produce Analysis output FIle

  6. Output Data Prep Data Selection Data QA SPSS Stream to Read RoadMAP Database and produce Analysis output FIle

  7. How we used what we found in ibmspss • Annual Maintenance Management Meeting, August 8-9, 2013 • Breakout sessions (1 ½ hours in length) • Attendance required for Division Engineers, Division Maintenance Engineers and their staff, District Managers and anyone else we could pull off the street. • Each attendee was provided book of data mining results for a group of activities.

  8. Materials for tac breakout sessionS • Technical Advisory Committee (TAC) procedures • Actual Average Daily Production (ADP) and Average Reported Crew Sizes • 12 months of RoadMAP work reports: July 1, 2012 to June 30, 2013 • Prior to conversion of District 81 to District 56. • Prior to establishment of Southwest Region • Three Groups of Activities • Same as last year (some additions, no deletions) • One handout per Group of Activities • Assignments • Group 1: Divisions 3, 4 and 9 • Group 2: Divisions 1, 5 and 8 • Group 3: Divisions 2, 6 and 7

  9. “Rules of Engagement” • Attend breakout session as noted in agenda • Session moderator will identify activities to be reviewed • Activities will be reviewed as time allows • Focus will be on activities with greatest use and/or greatest expenditures • Prior year modifications (if any) will be noted by the moderator before beginning discussion on an activity • Voting Process • One vote per Division/Area. Division/Region Engineer designates voting member. • Proposed changes require a majority vote to be moved forward. • Summary of each proposed change, the breakout discussion and the vote will be provided during the general session .

  10. Group Number Activity Number and Description Crew Size Average Daily Production

  11. Three Items Analyzed • Actual ADP • Crew Size • Crew Hours A. B. C. D. E. F. 2 • Are adjustments needed? • Crew Size • Actual ADP A. B. C. D. E. F. 1 • Six Pieces of Information for Each Item • Count: Number of Work Reports for this Activity • Mean: Average of All Values • Min: Lowest Value • Max: Largest Value • Median: “Middle” Value • Mode: Most Common Value A. B. C. D. E. F.

  12. Applying the Mean, Median and Mode • Median – arrange the values in order and find the one that is right in the middle. Half of the values are larger than the median and half are smaller. • Mode – the value that shows up the most often. • The mean is more “trustworthy” when both the median and mode are “close” to it. Why? When large “outlier” values are present (entry errors, for example), the mode is generally unchanged and the median changes slightly but the mean changes a great deal. When these three numbers are close to each other, it is an indication that large outliers are not present (or were removed). • When the mode is exactly equal to the planned ADP shown on the Performance Guideline, it may indicate that actual accomplishments are often not being entered (i.e., default value is being accepted).

  13. Distribution of Actual ADP – Activity 6020 (major patching)All Divisions – All Values Mean = 375 tons Median = 80 tons Mode = 0 tons Max > 125,000

  14. Distribution of Actual ADP – Activity 6020All Divisions – Extreme Outlier Removed Mean = 100 tons Median = 78 tons Mode = 0 tons Max < 800

  15. Distribution of Actual ADP – Activity 6020All Divisions – Extreme Outlier Removed (Different Threshold) Max < 300

  16. Distribution of Maintenance Unit Cost – Activity 6381Guard Rail Maintenance

  17. Distribution of Maintenance Unit Cost – Activity 6381guardRail Maintenance

  18. Actual ADP – 6252 Mowing (Non-Interstate)(By Division and roadclass) Error in Road Class? Road Class Division

  19. Average Crew Size -6252 Mowing (Non-Interstate)(By Division and roadclass) Error in Road Class? Road Class Division

  20. Average Actual ADP vs. Average Actual Crew SizeBy Division – 6252 Mowing (non-interstate) Different daily production for same crew sizes Dots represent Divisions Daily production increased with larger crew sizes

  21. Average Actual ADP vs. Average Actual Crew SizeBy Division, District and RoadCLass – 6252 Mowing (non-Interstate) Dots represent Districts Different daily production for same crew sizes Daily production and crew sizes consistent Daily production increased with larger crew sizes

  22. So how are end users benefitting??? • TAC approved changing ADP on 4 activities & crew sizes on 4 activities • Compare productivity of districts for specific activities. • Compare number of work reports for a specific activity for each district.

  23. So how are end users benefitting??? • TAC approved changing ADP on 4 activities & crew sizes on 4 activities • Compare number of work reports for a specific activity for each district. • Compare productivity of districts for specific activities. • One DME discovered a district with heavy emphasis on litter pickup and major patching activities at expense of herbicide spraying (weedy roadsides) and sign installation & maintenance (pallets of new signs at district yard not installed). • RESULT: Requested additional resurfacing projects (to reduce patching efforts), will begin contracting litter pickup along with ALL mowing , ordered more emphasis on herbicide application and REASSIGNED former sign inspector to Construction section. • Hunger for deeper understanding of the data as they look to optimize their resources. ($$= okay, staffing = not okay)

  24. Questions? 2013 southeast regional maintenance conference

More Related