Click for next page ( 33

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 32
32 Table 26. Global identifiers for NBMD. Data Field Description DOT{Year Dataset Global identifier attached to all records in a set of bridge work, condition, and inventory data. Dataset{Structure_Number Global identifier for each structure. The structure_number is the NBI data, NBMD_Bridge_ID usually, but can be the Pontis bridge key (brkey). The NBMD ID is unique for the structure, the DOT, and the reporting period. NBMD_Bridge_ID{COAM NBMD_Event_ID Global identifier for a maintenance event. COAM is a concatenation of abbreviations for bridge component, operation, activity and mode. Dataset{Elem{DOT_Elemkey NBMD_Elemkey Global identifier for bridge elements. The static string "Elem" marks this as an element ID. NBMD_Bridge_ID{Insp{Inspection_Date NBMD_Inspection_ID Global identifier for a bridge inspection. The static string "Insp" marks this as an inspection ID. Dataset{Res{Cat{DOT_Resource_ID Global identifier for resources used in maintenance events. Cat strings are Resource_ID abbreviations for resource categories. The static string "Res" marks this as a resource ID. NBMD Identifiers Note that DOTs are identified as state postal codes followed by the string "DOT." For many states, the NBMD identifier NBMD generates global identifiers for maintenance differs from the state's own abbreviation for their transporta- events, bridges, bridge elements, and maintenance resources tion department. (Table 26). Global identifiers link events, bridges, etc., across tables in a dataset, and allow datasets to be merged without loss of identity of events, bridges, etc. Identifiers are built up COAM String as combinations of existing IDs that are unique within DOTs' Abbreviations for maintenance Component and Opera- bridge populations and NBMD dataset labels that tie records tion are part of maintenance event IDs. The abbreviations are to particular DOTs and reporting periods. shown in Table 28. Resource IDs for equipment and materials are formed from NBMD Naming Conventions the dataset identifier, a static string "Res" and DOTs' identify- ing number. Labor resources are identified as dataset, Res, and NBMD employs conventions for simple, predictable forma- abbreviations of labor job titles. Abbreviations for Tennessee tion of NBMD identifiers (Table 27). The Dataset identifier is DOT job titles are shown in Table 29. formed with abbreviations for bridge owners plus reporting years. Bridge IDs are formed with Dataset identifiers plus DOTs' own structure ID. DOT structure IDs can be the NBI NBMD Keywords structure numbers or Pontis brkeys. Either is unique within one DOT. Combined with the dataset ID, the resulting NBMD NBMD employs plain-language keywords to identify main- bridge ID is unique among all bridge owners and all report- tenance actions, maintenance resources and bridge elements. ing periods. This makes NBMD tables readable and allows for the intro- By similar steps, identifiers are formed for bridge elements duction of additional keywords as needed without revision of and maintenance resources. Identifiers for maintenance events older data records. Additional keywords will likely be needed combine the NBMD bridge ID and abbreviations for mainte- in the future for new bridge components, new construction nance components and operations. Since NBMD bridge IDs materials, new maintenance materials, and new maintenance include dataset identifiers, the resulting event IDs indicate actions. bridge owners, reporting periods, bridges, and maintenance NBMD keywords are either standard keywords or descrip- actions. tive keywords. Standard keywords are proposed in this proj- The parts of each identifier are separated by left brackets. ect, and are intended to provide simple, definite description This allows parsing of identifiers in software applications. of bridge elements, maintenance actions, and maintenance

OCR for page 32
33 Table 27. NBMD dataset identifier--examples. NBMD Formation Example Note Identifier California data for Dataset DOT{Year CaDOT{2006 fiscal year 2006 California deck Action_ID Dataset{Act{DOT_ID CaDOT{2006{Act{H30060 overlay action, 2006 report Michigan bridge ID, Bridge_ID Dataset{Bridge_ID MiDOT{2005{82182072000R010 2005 reporting period Pennsylvania Element_ID Dataset{Elem{DOT_ID PaDOT{2008{Elem{48 concrete slab element in 2008 report Repairs to drains in Bridge_ID{COAM Event_ID TnDOT{2007{16I002400141{Drn{Rpr 2007 for Tennessee string structure Oregon inspection in OrDOT{2006{S8837A064 2005 related to Inspection_ID Bridge_ID{Insp{Date 01072{Insp{2005/03/07 maintenance work in 2006. Tennessee equipment TnDOT{2007{Res{EQA127 resource in 2007 report Resource_ID Dataset{Res{DOT_ID Tennessee Highway TnDOT{2007{Res{HMW3 Maintenance Worker in 2007 report resources. Standard keywords may evolve over time, but may Standard keywords and descriptive keywords are used in be regulated by an NBMD users' group. separate data fields in NBMD. Descriptive keywords provide additional information on bridge elements, maintenance actions, or maintenance Maintenance Actions resources. These, too, work best when all users (all DOTs) employ a common set of keywords. But descriptive keywords Bridge maintenance actions are described by four keyword are not regulated. Descriptive keywords can be specific to indi- fields. The first two, Component and Operation, are NBMD vidual DOTs. Descriptive keywords provide positive identifi- standard keywords. The second two, Activity and Mode, are cation of specific elements, actions, or materials at a DOT. descriptive (Table 30). Table 31 lists the standard keywords for Component and Operation. Among the Component keywords, Mech/Elec is Table 28. NBMD abbreviations for COAM strings. for mechanical and electrical systems of movable bridges, and Components Abbr. Operations Abbr. Approach/Embankment ApEm Clean Cln Table 29. Abbreviations for job titles-- Bearing Brg Coat Cot Tennessee DOT. Bridge Brd Reset Rst Channel Chn Repair Rpr Job Title Abbreviation Culvert Cul Replace Rpl County Supervisor CySpv Deck Dk Modify Mod Assist County Supervisor AsCySpv Drain Drn Emergency Emg Floating Crew Supervisor 2 FlCwSpv2 Joint Jt nonMaintenance nMnt Floating Crew Supervisor 1 FlCwSpv1 Mech/Elec MeEl Highway Maintenance Worker 3 HMW3 MovableSpan Mov Highway Maintenance Worker 2 HMW2 nonBridge nBrd Highway Maintenance Worker 1 HMW1 Rail/Walk RWk Carpenter 2 Cpt2 Substructure Sub Carpenter 1 Cpt1 Superstructure Sup Other Oth