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 67
67
Table 48. NBMD data collection formats.
DOT Inventory Condition Maintenance
Spreadsheet from Spreadsheet from
Alabama Tab-text files from ABIMS
ABIMS ABIMS
Pontis tables as MS Pontis tables as MS
California Spreadsheet from IMMS
Access Access
Colorado NBI files Pontis bridge database Spreadsheet from LOS system
Spreadsheet from Bridge
Michigan Pontis bridge database Pontis bridge database
Operations Unit
Ohio NBI files NBI files Spreadsheet from TMS
Oregon Pontis PDI files Pontis PDI files Spreadsheet from MMS
Spreadsheet from Spreadsheet from
Pennsylvania Spreadsheet from BMS2
BMS2 BMS2
Tennessee Pontis PDI files Pontis PDI files Spreadsheet from MMS
ABIMS = Alabama Bridge Information Management System
IMMS = Integrated Maintenance Management System
LOS = Level of Service management system
TMS = Transportation Management System
PDI = Pontis Data Interchange
BMS2 - PaDOT's BMS2 has modules for bridge inspection data, bridge work recommendations, and work
completion.
Data Collection Instances of DOT Maintenance Data
Collection of data from U.S. DOTs produced complete NBMD data tables for maintenance production and main-
datasets from eight DOTs, and incomplete datasets from four tenance resources are created by identifying the correspon-
other DOTs. Datasets from Alabama, Colorado and Ohio dences between DOT data fields and NBMD data fields, and
DOTs were collected in 2007, and these are formatted for an then transferring data from DOT tables to NBMD tables. DOT
earlier version of NBMD data tables. These three sets have not data headings for maintenance records and their correspon-
yet been updated to the newer format developed in 2009. dence to NBMD data fields are reported are provided in the
Datasets from California, Michigan, Oregon, Pennsylvania following sections.
and Tennessee are in the newer format. Datasets from Min-
nesota, Wisconsin, and Virginia lack maintenance data.
Data sources include NBI files, Pontis BMS tables in vari- Alabama DOT Maintenance Data
ous formats, spreadsheets of maintenance work, and tab-text
files of maintenance work (Table 48). The counts of bridges, Alabama bridge maintenance work is collected from the
maintenance events and inspections are shown in Table 49. Alabama Bridge Information Management System (ABIMS)
in reports for work by DOT crews on state-owned bridges
Table 49. Counts of bridges, (ABIMS report BI-10), for contract work on state-owned
maintenance events, and inspections. bridges work (ABIMS report BI-12) and for work performed
on non-state bridges (ABIMS report BI-11). The contents of
DOT Bridges Events Inspections the reports are similar. The relation of Alabama data fields to
Alabama 2915 4851 5800 NBMD data fields is shown in Table 50.
California 1152 1578 4218
Colorado 3522 7034 8800
Michigan 434 444 1511
Ohio 2187 2462 4400
California DOT Maintenance Data
Oregon 1322 2475 3815 California maintenance data are collected in two spread-
Pennsylvania 9100 12057 930
sheets: a Production spreadsheet and an Expense spreadsheet.
Tennessee 550 626 1857
Data fields in California's Production spreadsheet are mapped
Inspections = Counts of NBI inspections plus
element-level inspections to NBMD Production_Table (Table 51). Data fields in Cali-
Colorado data include years 2000 to 2007 fornia's Expense spreadsheet are mapped to NBMD Resource_
Oregon data include years 2005 to 2008 Table in Table 52.
OCR for page 68
68
Table 50. Alabama DOT maintenance data.
Alabama Data BI NBMD Field NBMD Field
Note
Field report Production_Table Resource_Table
Bridge identification
BIN 10,11,12 NBMD_Bridge_ID NBMD_Bridge_ID
number
Year 10,11,12
Month 10,11,12 Start_Date Start_Date
Day 10,11,12
Card Number 10,11 ID for work report DOT_RefA DOT_RefA
`B' code for maintenance
Activity 10,11 DOT_Activity_ID DOT_Activity_ID
work
Maintenance
Responsible 11
responsibility
Crew Size 10
Identifies DOT personnel
10 DOT_Resource_Quantity
Labor hours and convict hours
DOT_Resource_Category
11 I = in-house, C = contract
Accomplishment 10,11,12 Work production DOT_Production
Amount 10,11,12 Cost in dollars DOT_Total_Cost DOT_Total_Cost
Complete 10,11,12 Y/N
Table 51. California DOT maintenance production spreadsheet.
NBMD Field
California Data Field Note
Production_Table
DIST California DOT district
WORKDATE Date of report Start_Date
ACTIVITY Work action listed in California's `H' series DOT_Activity_ID
ACTIVITY DESCRIPTION Title of work action DOT_Activity_Title
WO# Work Order Number DOT_RefA
UNITID Bridge ID DOT_Bridge_ID
PROD. UNIT Quantity produced (Accomplished) DOT_Production
PROD. U.O.M. Unit of measurement DOT_Production_Unit
Table 52. California DOT maintenance expense spreadsheet.
NBMD Field
California Data Field Note
Resource_Table
DIST California DOT district
WORKDATE Date of report Start_Date
ACTIVITY Work action listed in California's `H' series DOT_Activity_ID
ACTIVITY
Title of work action DOT_Activity_Title
DESCRIPTION
WORK ORDER # Work Order Number DOT_RefA
UNITID Bridge ID DOT_Bridge_ID
Token identifying equipment, labor material or
COST TYPE* NBMD_Resource_Category
other
IDCLASS Identifying number for resource DOT_Resource_ID
DESCRIPTION Title for resource DOT_Resource_Description
HOURS Hours of usage DOT_Resource_Quantity
TOTAL $'s Total Cost DOT_Total_Cost
OCR for page 69
69
Colorado DOT Maintenance Data Oregon DOT Maintenance Data
Maintenance data from Colorado DOT are presented in Oregon DOTs crew maintenance accomplishments are
spreadsheets that list work activity codes and costs (Table 53). reported in a spreadsheet (Table 56) obtained as output from
The spreadsheet is an output from Colorado's Level of Ser- Oregon's maintenance management system.
vice Maintenance Management System (15).
Pennsylvania DOT Maintenance Data
Michigan DOT Maintenance Data
Maintenance work from Pennsylvania DOT is presented in
Michigan maintenance data are collected in a spread- a spreadsheet that is output from PaDOT's bridge manage-
sheet listing bridge contracts, work types, and allocated costs ment system (7). The PaDOT fields for maintenance work and
(Table 54). The spreadsheet is kept by Michigan's central the correspondence of PaDOT fields to NBMD data fields are
bridge operations unit. shown in Table 57.
Ohio DOT Maintenance Data Tennessee DOT Maintenance Data
Ohio DOT data are reported in a spreadsheet that contains Tennessee DOT maintenance data are reported in three
accomplishments and resources (Table 55). spreadsheets: Maintenance labor, maintenance equipment,
Table 53. Colorado DOT maintenance data.
Colorado Data NBMD Field NBMD Field
Note
Field Production Table Resource_Table
Record ID
DOT unique identifier for
Green Sheet DOT_RefA DOT_RefA
the work record
Work Date Date of work Start_Date Start_Date
Date of data entry or
Change Date
revision
Maintenance
DOT section
Section
Maintenance
DOT crew number
Patrol
Supervisor DOT ID
Structure ID Bridge ID DOT_Bridge_ID DOT_Bridge_ID
Site
Frontage
Route Route number
Begin Reference
Linear reference
Point
End Reference
Linear reference
Point
Maintenance activity
Action Number DOT_Activity_ID DOT_Activity_ID
number
Group Number
Action
Maintenance activity title DOT_Activity_Title DOT_Activity_Title
Description
Work
Production DOT_Production
Accomplished
Unit Unit of production DOT_Production_Unit
Crew Size Number or personnel DOT_Resource_Quantity,
Regular Hours Crew hours DOT_Quantity_Unit
Crew Notes Notes Notes
OCR for page 70
70
Table 54. Michigan DOT maintenance data.
Michigan Data Field Note NBMD Production_Table
district DOT district
brkey Structure number DOT_Bridge_ID
strc_num Short ID for bridge DOT_RefB
facility Route carried
featint Route intersected
job_id Contract ID DOT_RefA
let_date Contract letting Start_Date
Year Contract let year
strc_wk_desc Text description DOT_Activity_Title
rel_const_cost Cost of bridge work DOT_Total_Cost
Table 55. Ohio maintenance data.
NBMD NBMD
Ohio Data Field Note
Production_Table Resource_Table
Dist. DOT District
County Alpha abbreviation
Program Activity Programmed activity code DOT_Activity_ID DOT_Activity_ID
SFN Structure File Number DOT_Bridge_ID DOT_Bridge_ID
Route
SLM Linear reference
Old Bridge #
Bridge Suffix R/L
Record Type LB - labor DOT_Resource_Category
Transaction Date Start_Date Start_Date
Equipment Number
DOT_Resource_ID
Material Code
Resource DOT_Resource_Description
Description
Resource Quantity DOT_Resource_Quantity
Resource UM DOT_Quantity_Unit
Employee Number
Employee Name DOT_Resource_ID
Job Classification
Hours DOT_Resource_Quantity
RG regular,
Labor UM
OT - overtime
Work Accompl. Work accomplished DOT_Production
Work unit of DOT_Production_Unit
WA UM
measurement
Table 56. Oregon DOT maintenance data.
NBMD NBMD
Oregon Data Field Note
Production_Table Resource_Table
Chrge Unit DOT crew ID
Activity Activity ID DOT_Activity_ID DOT_Activity_ID
Activity Description Title DOT_Activity_Title DOT_Activity_Title
Transaction Amount Cost DOT_Total_Cost DOT_Total_Cost
Fiscal Year Start_Date Start_Date
EA/SJ Subjob ID DOT_RefA DOT_RefA
EA Description Linear reference DOT_RefB DOT_RefB
Transaction Qty Resource quantity DOT_Resource_Quantity
Trans Code Resource ID DOT_Resource_ID
Trans Code Description Resource title DOT_Resource_Description
