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 72
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
