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 35
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 36
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 37
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 38
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 39
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 40
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 41
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
