Click for next page ( 72


The National Academies | 500 Fifth St. N.W. | Washington, D.C. 20001
Copyright © National Academy of Sciences. All rights reserved.
Terms of Use and Privacy Statement



Below are the first 10 and last 10 pages of uncorrected machine-read text (when available) of this chapter, followed by the top 30 algorithmically extracted key phrases from the chapter as a whole.
Intended to provide our own search engines and external engines with highly rich, chapter-representative searchable text on the opening pages of each chapter. Because it is UNCORRECTED material, please consider the following text as a useful but insufficient proxy for the authoritative book pages.

Do not use for reproduction, copying, pasting, or reading; exclusively for search engines.

OCR for page 71
71 Table 57. Pennsylvania DOT maintenance data. NBMD Field Pennsylvania Data Field Note Production_Table 5A03 BRKEY BMS bridge key 5A01 Structure ID Structure Number DOT_Bridge_ID IM02 Element (not used in PaDOT{2008 dataset) IM01 Scope One of Bridge, Element, Flexaction IM03 Action Code A743101 DOT_Activity_ID IM03 Action Description CLEAN/FLUSH DK DOT_Activity_Title IM07 Status of Work Candidate Work is planned, scheduled or completed IM11 Work Assignment Agency or Contractor IM14 Date Completed Date presented as MM/DD/YYYY End_Date IM18 Quantity Quantity completed DOT_Production IM19 Cost Cost of work DOT_Total_Cost 3A02 Candidate ID DOT internal reference DOT_RefA 3A12 Assigned Indicator Yes / No and maintenance materials. The labor spreadsheet reports Applications of NBMD Data work production along with labor job titles, labor hours, and labor cost. The equipment spreadsheet reports fleet NBMD data are used to compute element-level unit costs IDs, hours of use and costs. The materials spreadsheet reports of maintenance actions. Demonstrations of use of NBMD material IDs, units of measurement, usage and costs. The were prepared with data from DOTs in Alabama, Colorado relation of these fields to NBMD data tables are shown in and Ohio; these are presented in Appendix D. Subsequently, Table 58 for TnDOT's labor spreadsheet, in Table 59 for the changes were made to NBMD tables to improve their per- equipment spreadsheet and in Table 60 for the materials formance such that some initial details on data table contents spreadsheet. and data field names have become obsolete. Table 58. Tennessee DOT labor spreadsheet. NBMD NBMD Tennessee Data Field Note Production_Table Resource_Table Work Date Bridge ID NBMD_Bridge_ID NBMD_Bridge_ID Actvity # DOT_Activity_ID DOT_Activity_ID Activity Description DOT_Activity_Title DOT_Activity_Title Quantity and DOT_Production Reported Accomplishment units DOT_Production_Unit County Supervisor Assist County Supervisor Floating Crew Supervisor 2 Floating Crew Supervisor 1 Highway Maintenance Worker 3 DOT_Resource_Description Highway Maintenance Hours by job title DOT_Resource_Quantity Worker 2 Highway Maintenance Worker 1 Carpenter 2 Carpenter 1 Other Cost $ DOT_Total_Cost DOT_Total_Cost

OCR for page 71
72 Table 59. Tennessee DOT equipment spreadsheet. NBMD NBMD Tennessee Data Field Note Production_Table Resource_Table Work Date Start_Date Start_Date Bridge ID DOT_Bridge_ID DOT_Bridge_ID Activity # DOT_Activity_ID DOT_Activity_ID Activity Description DOT_Activity_Title DOT_Activity_Title Equip Tag # DOT_Resource_ID Equipment Description DOT_Resource_Description Tied-Up Time (Hrs) DOT_Resource_Quantity Cost ($) DOT_Total_Cost DOT_Total_Cost Table 60. Tennessee DOT materials spreadsheet. NBMD NBMD Tennessee Data Field Note Production_Table Resource_Table Work Date Start_Date Start_Date Bridge ID DOT_Bridge_ID DOT_Bridge_ID Activity # DOT_Activity_ID DOT_Activity_ID Activity Description DOT_Activity_Title DOT_Activity_Title Material # DOT_Resource_ID Material Description DOT_Resource_Description QTY DOT_Resource_Quantity UOM Unit of measurement DOT_Quantity_Unit Cost ($) DOT_Total_Cost DOT_Total_Cost