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