Click for next page ( 43


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 42
42 Table 44. NBMD Roadway Table. Data Field Description Dataset Global identifier NBMD_Bridge_ID Global identifier NBMD_Road_ID Global identifier Record_Type NBI item 5A Record Type Kind_Highway From Pontis roadway table Level_Service NBI item 5C Designated level of service Route_Prefix NBI item 5B Route signing prefix Route_Number NBI item 5D Route number Direction_Suffix NBI item 5E Directional suffix Roadway_Name From Pontis roadway table Kilometer_Post NBI item 11 Kilometerpoint Lanes_On NBI item 28A Lanes on the structure Lanes_Under NBI item 28B Lanes under the structure Functional_Class NBI item 26 Functional classification of inventory route ADT NBI item 29 Average daily traffic Year_ADT NBI item 30 Year of average daily traffic Direction_Traffic NBI item 102 Direction of traffic ADT_Pct NBI item 109 Average daily truck traffic, percentage Road_Speed From Pontis roadway table Roadway_Width NBI item 51 Bridge roadway width curb-to-curb Approach_Width NBI item 32 Approach roadway width In any one reporting period, maintenance events affect a sub- layout. The first line contains headings for all data fields. The set of bridges in a DOT's network. These bridges are included second line and all following lines are data records. All lines in Roadway_Tables. Roadway_Tables can be formed from NBI contain the same number of columns, set off by tab characters. text files or from Pontis roadway tables. An example tab-text file, a list of bridge maintenance actions in data collected from Tennessee DOT, is shown in Figure 6. Tab-text files can be opened in MS Excel by "drag-drop" Structure_Table operations. This allows quick views of NBMD data. Tab-text NBMD Structure_Tables contain NBI inventory data data entries are sometimes altered in Excel (date fields, and any including bridge owner, year built, design type and material field containing "/" can be misread by Excel). Saving NBMD types (Table 45). In a single dataset, Structure_Table con- tables from Excel is not recommended. tain records only for bridges having maintenance events. Structure_Tables can be formed from NBI text files or from XML Documents the Pontis' bridge table. NBMD data tables are presented as XML documents con- forming to XSD schemas prepared in this project. XML docu- File Formats for NBMD Tables ments are self-defining sets of data fields and data values. XML NBMD tables are presented as tab-delimited text (tab-text) documents offer definite and unaltered input of data tables to files and as XML documents. applications such as MS Excel and MS Access. Templates can be created to display XML documents in web browsers. A portion of the XML document for Oregon's Inspection_ Tab-Text Files Cross_Reference_Table is shown in Figure 7. File structure is Tab-text files are convenient for the assembly of NBMD repetitive. Each data field is identified by name within "" tables. NBMD collects data from many DOT sources, and brackets Next the data entry appears. Last, the data field is must incorporate information from databases, from spread- terminated by brackets. Each complete data record is sheets, and from other text files. In this context, text files are enclosed by . . . tokens. The XML document continues NBMD data. Tab-text files of NBMD tables all have similar with similar structure for all records in the table.

OCR for page 42
43 Table 45. NBMD Structure_Table. Data Field Description Dataset_ID Global identifier NBMD_Bridge_ID Global identifier brkey From Pontis, bridge key bridge_id From Pontis, usually a short form of the NBI structure number Structure_Number NBI item 8 Structure number Structure_Name From Pontis Features_Intersected NBI item 6A Features intersected District NBI item 2 Highway agency district County NBI item 3 County (parish) code Facility NBI item 7 Facility carried by structure Location NBI item 9 Location Custodian NBI item 21 Maintenance responsibility Owner NBI item 22 Owner Admin_Area From Pontis State_Code NBI item 1 State code Year_Built NBI item 27 Year built Year_Reconstructed NBI item 106 Year reconstructed Historical_Significance NBI item 37 Historical significance Design_Load NBI item 31 Design load Type_Service_Bridge NBI item 42A Type of service on bridge Type_Service_Under NBI item 42B Type of service under bridge Number_Spans_Main NBI item 45 Number of spans in main unit Number_Approach_Spans NBI item 46 Number of approach spans Length_Maximum_Span NBI item 48 Length of maximum span Structure_Length NBI item 49 Structure length Deck_area From Pontis Bridge_Median NBI item 33 Bridge median Skew NBI item 34 Skew Material_Type_Main NBI item 43A Structure type main, kind of material/design Design_Type_Main NBI item 43B Structure type main, type of design/construction Material_Type_Approach NBI item 44A Structure type approach, kind of material/design Design_Type_Approach NBI item 44B Structure type approach, type of design/construction Deck_Structure_Type NBI item 107 Deck structure type Type_Membrane NBI item 108B Type of membrane Type_Wearing_Surface NBI item 108A Type off wearing surface Deck_Protection NBI item 108C Deck protection Deck_Width NBI item 52 Deck width, out-to-out Left_Walk_Width NBI item 50A Left curb/sidewalk width Right_Walk_Width NBI item 50 Right curb/sidewalk width Notes XML documents conform to schema defined for each required and allowed. The XSD file for the Inspection_ NBMD table, and stored in "XSD" files. Schema files list the Cross_Reference_Table is shown in Figure 8. data fields that belong in each table together with informa- The full set of XML schema files is available in the xsd tion on types of data entries and the number of data entries directory of the NBMD system distribution.

OCR for page 42
Dataset Action_ID DOT_Action_ID DOT_Action_Description DOT_Unit NBMD_Component NBMD_Operation NBMD_Activity TnDOT{2007 TnDOT{2007{Act{400 400 SPECIAL PROJECTS each Bridge TnDOT{2007 TnDOT{2007{Act{477 477 TRAFFIC CONTROL each Bridge nonMaintenance TnDOT{2007 TnDOT{2007{Act{450 450 STRUCTURE CLEANING each Bridge Clean TnDOT{2007 TnDOT{2007{Act{454 454 MAJ STRUCTURE REPAIR each Bridge Repair Major TnDOT{2007 TnDOT{2007{Act{402 402 CRACK REPAIR each Bridge Repair Crack TnDOT{2007 TnDOT{2007{Act{451 451 MINOR STRUCTURE REPAIR each Bridge Repair Minor TnDOT{2007 TnDOT{2007{Act{412 412 JOINT REPAIR each Joint Repair TnDOT{2007 TnDOT{2007{Act{433 433 REPAIR DRAIN STRCT - EACH each Drain Repair TnDOT{2007 TnDOT{2007{Act{401 401 MANUAL SPOT PATCHING each Bridge Repair Patch TnDOT{2007 TnDOT{2007{Act{438 438 MANUAL BRUSH CONTROL each Bridge Clean Brush TnDOT{2007 TnDOT{2007{Act{447 447 MANUAL SWEEPING each Bridge Clean Sweep TnDOT{2007 TnDOT{2007{Act{405 405 MILLING each Bridge Repair TnDOT{2007 TnDOT{2007{Act{475 475 GUARDRAIL + BARRIER WALL each Rail/Walk Repair TnDOT{2007 TnDOT{2007{Act{461 461 DE-ICING (SALT) each Bridge nonMaintenance TnDOT{2007 TnDOT{2007{Act{463 463 ANTI-ICING (SALT BRINE) each Bridge nonMaintenance TnDOT{2007 TnDOT{2007{Act{446 446 MECHANICAL SWEEPING each Bridge Clean Sweep TnDOT{2007 TnDOT{2007{Act{442 442 EROSION CONTROL each Bridge Repair Erosion Figure 6. Example of a tab-delimited text file.

OCR for page 42
OrDOT{2006 OrDOT{2006{S8837A064 01072 OrDOT{2006{S8837A064 01072{nBrd{ OrDOT{2006{S8837A064 01072{Insp{0 NBI Middle 0 S8837A064 01072 -1 OrDOT{2006 OrDOT{2006{S8837A064 01072 OrDOT{2006{S8837A064 01072{nBrd{ OrDOT{2006{S8837A064 01072{Insp{0 NBI Post 0 S8837A064 01072 -1 Figure 7. XML document (sample). NCHRP Project 14-15 NBMD Inspection Cross Reference Table 2009 G. Hearn TABLE Inspection_Cross_Reference_Table.xml Figure 8. XML schema for Inspection_Cross_Reference_Table.