Click for next page ( 35


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 34
34 Table 30. NBMD descriptors for maintenance actions. Keyword Type Description Field Component Name of the structural component. Standard Operation The category of maintenance work. Maintenance Activity Type of work within the category. Actions Descriptive Further description of the work; may identify a Mode material type. nonBridge identifies assets other than bridges and culverts, NBMD datasets. The Component keywords for bridge ele- such as tunnels, retaining walls, sign bridges, and other struc- ments are identical to the Component keywords for mainte- tural assets that are reported in a DOT's maintenance data sys- nance actions. tem. Among Operation keywords, nonMaintenance indicates inspection, operation (of movable spans), complaint investi- NBMD Resources gation, and other activities that may be performed by DOT crews and appear in maintenance data systems. Resources used in maintenance are described by a standard Standard keywords are exclusive. No component key- keyword for resource Category. Standard categories are: Equip- word appears in the operation list, and no operation keyword ment, Labor, Material, and Other. Three descriptive key- appears in the component list. Keywords used in activity and words may be used. These are resource Group, Keyword_A, mode should also be exclusive; keywords in each field should and Keyword_B. These keywords describe the type and capac- be used only in that field. ity of equipment, the grade and title or labor, and the kind and NBMD maintenance actions are identified at least by a grade of materials. Two more resources keywords, Manufac- component keyword, and may be identified by a component turer and Product, are used only for materials and identify spe- plus any among the operation, activity, and mode keywords. cific products used in maintenance actions. Bridge Elements NBMD Tables and Data Fields Bridge elements are described with five NBMD keyword NBMD tables and data fields are presented in this section. fields: Component, Material, Form, Part, and Protection. Tables are presented in alphabetical order. Component and Material are standard keywords. Part, Form, and Protection are descriptive. Table 32 lists the standard Activity_Definition_Table keywords for Component and Material, and the keywords The NBMD Activity_Definition_Table (Table 33) relates for Part, Form, and Protection that appear in the current the codes and titles for DOT maintenance actions to the NBMD keywords for Component, Operation, Activity, and Mode. DOTs' units of measurement for actions are reported. Table 31. NBMD standard keywords for The NBMD dataset ID is present, linking each maintenance maintenance actions. action to a specific DOT and reporting period. Component Keywords Operation Keywords Activity definition tables are formed for each dataset by Approach/Embankment Clean collecting all unique DOT actions and assigning appropriate Bearing Coat NBMD keywords to them. Within a single DOT, the IDs for Bridge Emergency maintenance actions may persist over many years, and so Channel Modify activity definition tables for different reporting years may Culvert Repair have many identical entries. Examples of activity definition Deck Replace Drain Reset tables are provided in Appendix B. Joint nonMaintenance Mech/Elec Contact_Table Movable Span nonBridge The NBMD Contact_Table (Table 34) identifies datasets, Rail/Walk their DOT sources, and staff contacts at DOTs. Each NBMD Substructure dataset has one or more contacts. These are one or more per- Superstructure sonnel at a single DOT or other bridge owners' agency.

OCR for page 34
35 Table 32. NBMD element standard keywords. Component Material Part Form Protection Approach/Embankment Asphalt Abandoned Bottom Chord AC Overlay Bearing Concrete Abutment Box AC Overlay - Bridge Elastomeric Arch Concrete- Protected Channel Metal Assembly filled Cathodic Culvert PS Beam Deck Crack Coated Deck Concrete Cable Disk Coated Bars Joint Steel Cap Drilled Painted nonBridge Timber Column Fatigue Rigid Overlay Rail/Walk Compression Impact Thin Overlay Substructure Corrugated Modular Bituminous overlay Superstructure Deck Truss Open Bituminous overlay, Electrical/Mechanical Pack Rust coated bars Sys Pot Concrete encased Enclosed Scour Galvanized Expansion Section loss Bituminous overlay, Fender Settlement Membrane, coated Finger Shell bars Fixed Soffit Rigid overlay, coated Flag Strip seal bars Flume Wall Footing Portal Footing seal Roadway Frame Wearing Grid Surface Movable Damage Paint Incident Ped/Bike Compression Pier Pile Pile Cap Pin/Hanger Plate Plug Pourable Private Railing Railing with Sidewalk Railroad Seal Sign Slab Slope Protection Stringer Thru Truss Tunnel Cap/Footing Headwall Sidewalk Trough

OCR for page 34
36 Table 33. NBMD Activity_Definition_Table. Data Field Description Dataset Global identifier Dataset{Act{DOT_Action_ID Action_ID NBMD identifier for this DOT action and dataset. The static string `Act' marks this as an action ID. DOT_Action_ID DOT's code for maintenance activity DOT_Action_Description DOT's title for work activity DOT_Unit DOT's reporting unit for this work activity NBMD_Component NBMD standard keyword for bridge component NBMD_Operation NBMD standard keyword for maintenance operation NBMD_Activity Descriptive keyword for maintenance action NBMD_Mode Descriptive keyword for maintenance action NBMD_Unit NBMD unit of measure, if different from DOT unit NBMD_CoamString Standard abbreviations for bridge component and maintenance operation Element_Definition_Table Similar to DOT maintenance activities and their defini- tions, the set of bridge elements at a DOT continues with few NBMD Element_Definition_Tables relate DOT IDs and changes from year to year. NBMD datasets from a single DOT titles for bridge elements to NBMD keywords for bridge ele- will have similar Element_Definition_Tables with many iden- ments. Element_Definition_Tables list the units of measure- tical records. ment for elements. Element_Definition_Tables (Table 35) are developed partly from Pontis elemdefs tables, and partly from Element_Inspection_Table element coding guides published by DOTs. Pontis elemdefs tables are collected as Pontis Data Interchange (PDI) files. PDI NBMD's Element_Inspection_Tables are adaptations of files are converted to tab-text files with column headings using Pontis eleminsp tables. Element_Inspection_Tables are formed an application developed in this project (see Appendix E). with selected Pontis data fields obtained from PDI files, iden- Table 34. NBMD Contact_Table. Data Field Description Dataset Global identifier DataSet{Con{Seq Unique identifier for this contact record. The static string `Con' marks this as a contract Contact_ID ID. The Seq (sequence) is 1, 2, 3 ... as needed for the contacts contributing to this dataset. General type of bridge information; one among maintenance, inventory, or condition Type data. Last_Name Last name of staff contact First_Name First name of staff contact Initial Middle initial(s) of staff contact Agency Name of transportation department, or other bridge owner Office / Office within transportation department Branch Title Staff contact's job title Address_1 Postal address Address_2 City State Zip telephone Staff contact information cell_phone email website

OCR for page 34
37 Table 35. Element Definition Table. Data Field Note Dataset Global Identifier Dataset{Elem{DOT_Elemkey NBMD_Elemkey Global identifier for bridge element, tied to dataset DOT_Elemkey From Pontis (usually), the numeric ID for an element elemshort From Pontis, short name for bridge element elemlong From Pontis, long name for bridge element DOT_Unit Unit of measurement for bridge element Statecnt Number of condition states for bridge element Component NBMD keyword for bridge component Material NBMD keyword for element material Part NBMD keyword for specific part of bridge component indicated by this element Form NBMD keyword for form of element (such as open beam versus box beam) NBMD keyword for paint, membrane, coated rebar or other feature offering Protection protection to the bridge element tifiers for NBMD bridges, inspections, and elements and aug- Element_Unit_Cost_Table reports the costs and improve- mented by elements' units of measurement (Table 36). ments to one element at one bridge due to one maintenance event, and the median costs for unique pairs of bridge ele- ments and maintenance actions. A single maintenance event Element_Unit_Cost_Table may improve several elements. The resulting table will contain NBMD's Element_Unit_Cost_Tables are generated from as many records as improved elements. A single bridge and data in Production_Tables and Element_Inspection_Tables. element may be improved by different maintenance events Element_Unit_Cost_Tables are generated after other tables (events may differ by maintenance Operation). The resulting in a dataset have been formed from DOT inputs (Table 37). table will contain as many records as maintenance events. Table 36. NBMD Element_Inspection_Table. Data Field Description DataSet Global Identifier NBMD_Bridge_ID Global Identifier NBMD_Bridge_ID{Insp{Inspection_Date NBMD_Inspection_ID Global Identifier Structure_Unit From Pontis NBMD_Elemkey Global Identifier DOT_Element_Key From Pontis, numeric ID of bridge element Environment_Key From Pontis Element_Total_Quantity From Pontis Element_Quantity_Unit From NBMD Element_Definition_Table Quantity_State_1 Quantity_State_2 Quantity_State_3 From Pontis, element-level condition report of element quantities. Quantity_State_4 Quantity_State_5 Percentage_State_1 Percentage_State_2 Percentage_State_3 From Pontis, element-level condition report of element percentages. Percentage_State_4 Percentage_State_5 Element_Scale_Factor From Pontis brkey From Pontis inspkey From Pontis Notes From Pontis

OCR for page 34
38 Table 37. Element_Unit_Cost_Table. Data Field Description Dataset NBMD global identifier NBMD_Event_ID NBMD global identifier NBMD_Bridge_ID NBMD global identifier Action_Component Bridge component identified in event record Action_Operation Maintenance operation identified in event record Event_Total_Cost Event total cost allocated to this element NBMD_Prior_Insp Inspection ID, inspection before maintenance event NBMD_Post_Insp Inspection ID, inspection after maintenance event NBMD_Element_ID NBMD global identifier Element_long Long name of element Element_Unit Unit of measurement for element Prior_Total_Quantity Element total quantity prior to maintenance event Post_Total_Quantity Element total quantity after maintenance event Element_Component NBMD keyword for element component Element_Material NBMD keyword for element material Element_Form NBMD keyword for element form Element_Part NBMD keyword for element part Element_Protection NBMD keyword for element protection Improvement_Quantity Quantity of element moved to better condition state Element condition before maintenance; best condition state among states Prior_State that lose quantity after maintenance Element condition after maintenance; worst condition state among states Post_State that gain quantity after maintenance Inventory_Change Change in total quantity of element due to maintenance Cost_Type Cost of single event, or median cost of similar events Element_Unit_Cost Event cost divided by improved quantity of element Element_Unit_Cost_Unit Units of measurement for unit cost Cost_Status One among Single element, Multiple elements, Multiple components Element_Unit_Cost_Tables contain the maintenance events Inspection_Cross_Reference_Table that improve element conditions as revealed in element-level inspection reports, provided that event Components agree NBMD Inspection_Cross_Reference_Tables link each with element Components. The Cost_Status field indicates maintenance event to three NBI safety inspections and three whether total costs of one maintenance event are distributed to element-level inspections (Table 38). These are: inspections one bridge element, to multiple elements, or to multiple bridge nearest in date to maintenance events, inspections one cycle components. The computation of element-level unit costs is prior to events, and inspections one cycle after. Together, discussed in Chapter 5. these three inspections can reveal the changes (improve- Table 38. NBMD Inspection_Cross_Reference_Table. Data Field Description NBMD_Bridge_ID Global Identifier NBMD_Event_ID Global Identifier NBMD_Inspection_ID Global Identifier Inspection_Type NBMD standard keyword: Element or NBI NBMD standard keyword. Inspections are Prior, Middle or Post, meaning prior Inspection_Order to maintenance, nearest to maintenance, or after maintenance Inspection_Date Date of inspection presented as YYYY/MM/DD brkey From Pontis, key to bridge record inspkey From Pontis, key to inspection record

OCR for page 34
39 Table 39. NBMD Inspection_Event_Table. Data Field Description DataSet Global Identifier NBMD_Bridge_ID Global Identifier NBMD_Inspection_ID Global Identifier brkey From Pontis, bridge key inspkey From Pontis, inspection key Inspection_Date Date of inspection, YYYY/MM/DD NBI_Done Yes / No indicated as 1/0, from Pontis Element_Level_Done Yes / No indicated as 1/0, from Pontis Element_Inspection_Date Date of inspection presented as YYYY/MM/DD UW_Required 1/0 indicator that underwater inspection is required UW_Done 1/0 indicator that underwater inspection was performed FC_Required 1/0 indicator that fracture critical member inspection is required FC_Done 1/0 indicator that fracture critical member inspection was performed Special_Required 1/0 indicator that special or other inspection is required Special_Done 1/0 indicator that special or other inspection was performed Appraisal_Date Date of NBI appraisals Rail_NBI_36A Rail_Transition_NBI_36B NBI item 36 for traffic safety features Approach_Rail_NBI_36C Approach_Rail_End_NBI_36D Open_Posted_Closed_NBI_41 NBI item 41 for structure open, posted or closed. Deck_Geometry_NBI_68 NBI item 68 Deck geometry Underclearance_NBI_69 NBI item 69 Underclearances Waterway_Adequacy_NBI_71 NBI item 71 Waterway adequacy Pier_Protection_NBI_111 NBI item 111 Pier or abutment protection Scour_Critical_NBI_113 NBI item 113 Scour Critical Bridges Approach_Alignment_NBI_72 NBI item 27 Approach roadway alignment Deck_Rating_NBI_58 NBI item 58 Deck condition rating Superstructure_Rating_NBI_59 NBI item 59 Superstructure condition rating Substructure_Rating_NBI_60 NBI item 60 Substructure condition rating Channel_Rating_NBI_61 NBI item 61 Channel and channel protection Culvert_Rating_NBI_62 NBI item 62 Culvert condition Structural_Evaluation_NBI_67 NBI item 67 Structural evaluation NBI_Status NBI status NBI_Sufficiency_Rating NBI sufficiency rating NBI_Sufficient_Prefix NBI position 428 Notes From Pontis ments) to bridge element conditions as a result of mainte- NBMD_Size nance events. Inspection_Cross_Reference_Tables are generated from NBMD's Size_Tables are used by the NBMD viewer appli- Pontis inspevnt tables and NBMD Production_Tables using cation to establish the sizes of arrays when data tables are an NBMD software utility called Inspection Cross (see loaded (Table 40). Size_Tables list files included in the dataset Appendix E). and the number of lines in each file. Size_Tables are created Inspection_Event_Table Table 40. NBMD Size_Table. NBMD's Inspection_Event_Tables contain NBI condition and appraisal ratings (Table 39). Inspection_Event_Tables Data Field Description can be generated from Pontis' inspevnt table or from FHWA File path and name Tab-text file of NBMD data files of NBI data. File lines Count of lines in NBMD tab-text file

OCR for page 34
40 by a software utility, NBMD_Size, after all other tables in a may be absent if the contributing DOT records have differ- dataset have been assembled. Size_Tables must be updated by ing units. the software application if any tables in a dataset are modified. Resource_Definition_Table Production_Table NBMD Resource_Definition_Tables relate DOT identifiers NBMD Production_Tables report the production (accom- for equipment, material and labor to NBMD resources cate- plishments) of maintenance actions at bridges (Table 41). gories (Table 42). Categories are standard keywords. Other Each record identifies a bridge, an NBMD maintenance com- keywords are descriptive. For materials, the table can track ponent and operation, the unit of measurement, the produc- manufacturer and product names. tion amount, total cost, and unit cost. Records also include DOTs' identifying codes and titles for actions, DOT reference Resource_Table numbers such as contract number, crew number, work order or other identifying number. NBMD Resource_Tables identify the resources used in NBMD Production_Tables provide total cost for each maintenance events, together with resource quantities and NBMD action at each bridge. Most production records com- costs (Table 43). Records identify maintenance events and bine multiple work reports of DOTs. Each NBMD production resources. Each record may combine several DOT records for record can be the sum of more than one DOT work order, or resource use. DOT maintenance action, if these orders and actions con- tribute to a single NBMD action at a single bridge. As a result, Roadway_Table DOT work order numbers may be absent from an NBMD production record, if multiple work orders contribute. DOT NBMD Roadway_Tables contains NBI inventory data for action ID may be absent from an NBMD production record, routes on and under bridges (Table 44). Roadway_Tables con- if multiple actions contribute. DOT units of measurement tain records needed for the maintenance events in a dataset. Table 41. NBMD Production_Table. Data Field Description Dataset Global identifier NBMD_Bridge_ID Global identifier Global identifier. Concatenation of NBMD_Bridge_ID and abbreviations for NBMD_Event_ID component and operation NBMD_DOT_Event_ID Concatenation of NBMD_Bridge_ID and DOT activity code, if available. Structure_Number from NBI records, or bridge key (brkey) from a DOTs' Pontis DOT_Bridge_ID bridge database. Start_Date Earliest record for this maintenance event, shown as YYYY/MM/DD End_Date Latest record for this maintenance event, shown as YYYY/MM/DD. DOT_Activity_ID DOTs' identifying code for maintenance activity DOT_Activity_Title DOTs' title for maintenance activity DOTs' reference number such as work order, contract number, crew number or DOT_RefA other identifying code useful for retrieval of internal DOT records DOT_RefB Additional DOT reference number NBMD_Component NBMD standard keyword NBMD_Operation NBMD standard keyword NBMD_Activity NBMD descriptive keyword NBMD_Mode NBMD descriptive keyword NBMD_CoamString Abbreviations for component and operation DOT_Production Quantity of work accomplished DOT_Production_Unit Measurement unit for work DOT_Unit_Cost Total cost divided by work quantity DOT_Unit_Cost_Unit Measurement unit for unit cost DOT_Total_Cost Cost reported by DOT, summed from multiple work records or resource records Cost_Unit Monetary unit for total cost Notes

OCR for page 34
41 Table 42. NBMD Resource_Definition_Table. Data Field Description Dataset Global identifier Resource_ID Global identifier DOT_Resource_ID DOT's identifying code for resource DOT_Resource_Description DOT's title for resource. DOT_Unit Unit of measurement for use or cost of resource NBMD_Resource_Category NBMD standard keyword (labor, equipment, material, other) NBMD_Resource_Group NBMD descriptive keyword NBMD_Resource_KeywordA NBMD descriptive keyword NBMD_Resource_KeywordB NBMD descriptive keyword NBMD_Resource_Manufacturer Name of manufacturer, for materials NBMD_Resource_Product Name of product, for materials NBMD_Unit Unit of measurement for NBMD NBMD_Unit_Cost Unit cost of resource in DOT units notes Notes on resource record Table 43. NBMD Resource_Table. Data Field Description Dataset Global identifier Resource_ID Global identifier NBMD_Bridge_ID Global identifier NBMD_Event_ID Global identifier NBMD_DOT_Event_ID Concatenation of NBMD_Bridge_ID and DOT activity code, if available Structure_Number from NBI records, or bridge key (brkey) from DOT_Bridge_ID Pontis bridge database Start_Date Earliest resource record for this maintenance event End_Date Latest resource record for this maintenance event DOT_Activity_ID DOT's identifying code for maintenance activity DOT_Activity_Title DOT's title for maintenance activity DOT's reference number such as work order, contract number, crew DOT_RefA number or other identifying code useful for retrieval of internal DOT records on bridge maintenance work DOT_RefB Additional DOT reference number DOT_Resource_ID DOT's identifying code for resource DOT_Resource_Description DOT's title for resource DOT_Resource_Category DOT's category for resource DOT_Resource_Quantity Use of resource in hours, miles, mass, volume, etc. DOT_Quantity_Unit Unit for measurement of resource use DOT_Unit_Cost Unit cost of resource DOT_Unit_Cost_Unit Units for unit cost DOT_Total_Cost Total cost for this resource in this event DOT_Total_Cost_Unit Units for total cost NBMD_Resource_Category NBMD standard keyword NBMD_Resource_Group NBMD standard keyword NBMD_Resource_Keyworda NBMD descriptive keyword NBMD_Resource_Keywordb NBMD descriptive keyword NBMD_Resource_Manufacturer Name of manufacturer, for materials NBMD_Resource_Product Name of product, for materials NBMD_Unit Unit for NBMD measurement of resource, if different from DOT NBMD_Unit_Cost Unit cost of resource in NBMD units of measurement notes Notes on use of resource