Data Crosswalk for “Over” Records and “Under” Records
The Data Crosswalk is a detailed mapping of the relationship between the Coding Guide (CG) data items and the data items described in the Specifications for the National Bridge Inventory (SNBI). It establishes the rules for data transition, defines temporary codes to be used only during the transition period, and defines data tags to be used for SNBI-based data submittals. Learn more about the Data Crosswalk at Memorandum - Implementation of the Specifications for the National Bridge Inventory (.pdf)
The Primary Spreadsheet referenced in that memorandum is comprised of the tables found on this page, while the Detailed Spreadsheet is the Detailed Code Mapping for Individual Data Items.
The tables below are also available in Excel format - datacrosswalk.xlsx
General Notes Regarding Transition of Data:
- Certain assumptions must be made in transitioning data from a Coding Guide-based dataset to a SNBI-based dataset. Because the Coding Guide does not identify situations where there are multiple instances of a certain type of feature (highway, railroad, etc.) carried on or below the bridge, we must assume for the purposes of transition that there is a single instance. Likewise, we must assume only one route per highway, only one main span set and one approach span set. These assumptions will be correct in many cases, but the data should be adjusted after transition for bridges where these assumptions do not apply.
- All "over" bridge records that carry a highway (Item 42a = 1, 4, 5, 6, 7, or 8) and which are NBIS bridge length (Item 112 = Y), are transitioned, regardless of bridge length.
- "Under" record tables are used only when a corresponding "over" record is transitioned. "Under" records without a corresponding transitioned "over" record are not transitioned.
- Values not noted result in a null value.
- The phrase "See table," in the Notes to Developer column refers to the tables for each item in the "Detailed Code Mapping for Individual Data Items" webpage, coming in August 2022.
- A "clean" transition indicates that all Coding Guide codes transition into a permanent SNBI code. These items should be verified in accordance with the established timeline to ensure that the transitioned data are correct.
- A "partial" transition may indicate that some Coding Guide codes do not transition into a permanent SNBI code, but may transition into a temporary code. It may also indicate that a significant assmption was made in the transition rules. All temporary codes should be updated to permanent codes, all transitioned codes should be verified, and all items that did not populate should be populated, in accordance with the established timeline.
- A data item that indicates "no" to a clean transition cannot be populated using Coding Guide data and must be populated in accordance with the established timeline.
- When transitioning "under" records, if Item 5a = 2, this indicates that there is only one "under" record. If Item 5a = A, this indicates that there are multiple "under" records. The "2" record or the "A" record is the primary "under" record. However, it is possible that the "under" records are miscoded, and there is both a "2" record and an "A" record. In this case, assume the "2" record is the primary "under" record. The primary "under" record is designated as the H02 feature. This is the same H02 feature designated by the "over" record for the bridge. All other "under" records are secondary and should create additional highway feature records, numbered sequentially (H03, H04, etc.). The Route designation associated with each highway feature is always R01.
Transition of “Over” Records
| SNBI ID | Data Tag | SNBI Item Name | SNBI Format | 1995 Coding Guide ID |
1995 Coding Guide Item Name/ Description |
1995 Coding Guide Format (as shown in Appendix E) |
Clean Transition? | Transition Notes for Developer | Additional Notes |
|---|---|---|---|---|---|---|---|---|---|
| B.ID.01 | BID01 | Bridge Number | AN (15) | 8 | Structure Number | 15/AN | Yes | Trim leading and trailing spaces. For Transition Tool, provide option to trim or not trim leading zeroes, or to trim all but one leading zero; do not provide a default selection. Ask user whether to apply this selection to transitioned legacy (historical) data for that State/Agency. (Add a note stating that all legacy data will also be preserved in its original form.) For those who do not use the Transition Tool, we will need to survey. | |
| B.ID.02 | BID02 | Bridge Name | AN (300) | N/A | N/A | N/A | No | ||
| B.ID.03 | BID03 | Previous Bridge Number | AN (15) | N/A | N/A | N/A | Yes | Populate this field using the history of structure number changes that resides in the NBI from Structure Number Change submittals. Trim leading and trailing spaces and leading zeroes in accordance with the user's selection for Item B.ID.01. | |
| B.L.01 | BL01 | State Code | N (2,0) | 1 | State Code | 3/N | Yes | Trim leading zero, drop 3rd digit. | |
| B.L.02 | BL02 | County Code | N (3,0) | 3 | County (Parish) Code | 3/N | Yes | Direct transition. | |
| B.L.03 | BL03 | Place Code | N (5,0) | 4 | Place Code | 5/N | Yes | Direct transition. | |
| B.L.04 | BL04 | Highway Agency District | AN (2) | 2 | Highway Agency District | 2/AN | Yes | Trim leading zeroes. | |
| B.L.05 | BL05 | Latitude | N (9,6) | 16 | Latitude | 8/N | Yes | Convert to decimal degrees from degrees/minutes/seconds. Add negative if Item 1 = 60. | Jarvis Island in the U.S. Minor Outlying Islands also has a negative latitude, but there are currently no bridges for that island in the NBI. |
| B.L.06 | BL06 | Longitude | N (10,6) | 17 | Longitude | 9/N | Yes | Convert to decimal degrees from degrees/minutes/seconds. Add negative for all records except if Item 1 = 64, 66, 68, 69, or 70. | Wake Island in the U.S. Minor Outlying Islands also has a positive longitude, but there are currently no bridges for that island in the NBI. Additionally, some portions of Alaska have a positive longitude, but there are currently no bridges for those areas in the NBI. |
| B.L.07 | BL07 | Border Bridge Number | AN (15) | 99 | Border Bridge Structure Number | 15/AN | Yes | Trim leading and trailing spaces and leading zeroes. | |
| B.L.08 | BL08 | Border Bridge State or Country Code | AN (2) | 98A | Neighboring State Code | 3/AN | Yes | Trim leading zero, drop 3rd digit, change CAN to CA, MEX to MX. | |
| B.L.09 | BL09 | Border Bridge Inspection Responsibility | AN (1) | 98B | Percent Responsibility | 2/N | Partial | See tab. Coding Guide uses FUNDING responsibility. | Transition assumes that funding responsibility and inspection responsibility are the same. Agencies will need to update in accordance with FHWA implementation timeline. |
| B.L.10 | BL10 | Border Bridge Designated Lead State | N (2,0) | 1 | State Code | 3/N | Yes | Trim leading zero, drop 3rd digit. | Both bordering States are designated as Lead States for transition. Agencies will need to update in accordance with FHWA implementation timeline. |
| B.L.11 | BL11 | Bridge Location | AN (300) | 9 | Location | 25/AN | Yes | Direct transition. | |
| B.L.12 | BL12 | Metropolitan Planning Organization | AN (300) | N/A | N/A | N/A | No | ||
| B.CL.01 | BCL01 | Owner | AN (4) | 22 | Owner | 2/N | Yes | See tab. | |
| B.CL.02 | BCL02 | Maintenance Responsibility | AN (4) | 21 | Maintenance Responsibility | 2/N | Yes | See tab. | |
| B.CL.03 | BCL03 | Federal or Tribal Land Access | AN (5) | 105 | Federal Lands Highway | 1/N | Partial | See tab. | |
| B.CL.04 | BCL04 | Historic Significance | AN (1) | 37 | Historical Significance | 1/N | Partial | See tab. | Contains temporary codes to be phased out. |
| B.CL.05 | BCL05 | Toll | AN (1) | 20 | Toll | 1/N | Yes | See tab. | |
| B.CL.06 | BCL06 | Emergency Evacuation Designation | AN (1) | N/A | N/A | N/A | No | ||
| B.SP.01 | BSP01 | Span Configuration Designation | AN (3) | 43/44 | Structure Type, Main / Structure Types, Approach Spans | 3/N - 3/N | Partial | See tab. Item 43 data will partially transition to a main or culvert span configuration data set. Item 44 data when present will partially transition to an approach or culvert span configuration data set. SNBI culvert extension and widening span configurations cannot be transitioned. Multiple main span or approach span configurations cannot be transitioned. | |
| B.SP.02 | BSP02 | Number of Spans | N (4,0) | 45/46 | Number of Spans in Main Unit / Number of Approach Spans | 3/N - 4/N | Partial | Use Item 45 value for M01 or C01, use Item 46 value for A01 or C02. SNBI culvert extension and widening span configurations cannot be transitioned. Multiple main span or approach span configurations cannot be transitioned. | |
| B.SP.03 | BSP03 | Number of Beam Lines | N (3,0) | N/A | N/A | N/A | No | ||
| B.SP.04 | BSP04 | Span Material | AN (3) | 43A/44A | Structure Type, Main / Structure Types, Approach Spans | 1/N - 1/N | Partial | See tab. Use Item 43A value for M01 or C01, use Item 44A value for A01 or C02. | Contains temporary codes to be phased out. |
| B.SP.05 | BSP05 | Span Continuity | AN (1) | 43/44 | Structure Type, Main / Structure Types, Approach Spans | 3/N - 3/N | Partial | See tab. Use Item 43A/B value for M01 or C01, use Item 44A/B value for A01 or C02. | Contains temporary codes to be phased out. |
| B.SP.06 | BSP06 | Span Type | AN (3) | 43B/44B | Structure Type, Main / Structure Types, Approach Spans | 2/N - 2/N | Partial | See tab. Use Item 43B value for M01 or C01, use Item 44B value for A01 or C02. | Contains temporary codes to be phased out. 335 bridge records currently have 44B = 20. |
| B.SP.07 | BSP07 | Span Protective System | AN (2) | N/A | N/A | N/A | No | ||
| B.SP.08 | BSP08 | Deck Interaction | AN (2) | N/A | N/A | N/A | No | ||
| B.SP.09 | BSP09 | Deck Material and Type | AN (3) | 107 | Deck Structure Type | 1/AN | Partial | See tab. Use for all span sets. | Contains temporary codes to be phased out. |
| B.SP.10 | BSP10 | Wearing Surface | AN (3) | 108A | Type of Wearing Surface | 1/AN | Partial | See tab. Use for all span sets. Also reference Item 107. | Contains temporary codes to be phased out. |
| B.SP.11 | BSP11 | Deck Protective System | AN (3) | 108B | Type of Membrane | 1/AN | Partial | See tab. Use for all span sets. Also reference Item 107. | Contains temporary codes to be phased out. |
| B.SP.12 | BSP12 | Deck Reinforcing Protective System | AN (3) | 108C | Deck Protection | 1/AN | Partial | See tab. Use for all span sets. Also reference Item 107. | Contains temporary codes to be phased out. |
| B.SP.13 | BSP13 | Deck Stay-In-Place Forms | AN (2) | N/A | N/A | N/A | No | ||
| B.SB.01 | BSB01 | Substructure Configuration Designation | AN (3) | N/A | N/A | N/A | No | ||
| B.SB.02 | BSB02 | Number of Substructure Units | N (3,0) | N/A | N/A | N/A | No | ||
| B.SB.03 | BSB03 | Substructure Material | AN (3) | N/A | N/A | N/A | No | ||
| B.SB.04 | BSB04 | Substructure Type | AN (3) | N/A | N/A | N/A | No | ||
| B.SB.05 | BSB05 | Substructure Protective System | AN (3) | N/A | N/A | N/A | No | ||
| B.SB.06 | BSB06 | Foundation Type | AN (3) | N/A | N/A | N/A | No | ||
| B.SB.07 | BSB07 | Foundation Protective System | AN (3) | N/A | N/A | N/A | No | ||
| B.RH.01 | BRH01 | Bridge Railings | AN (4) | 36A | Traffic Safety Features | 1/AN | Partial | See tab. | Contains temporary codes to be phased out. |
| B.RH.02 | BRH02 | Transitions | AN (4) | 36B | Traffic Safety Features | 1/AN | Partial | See tab. | Contains temporary codes to be phased out. |
| B.G.01 | BG01 | NBIS Bridge Length | N (7,1) | 49 | Structure Length | 6/N | Partial | Convert from metric to nearest tenth of a foot when Item 49 is greater than 9.1 meters. Otherwise no value. | Bridge lengths near 20 feet must be field-measured to ensure accuracy. |
| B.G.02 | BG02 | Total Bridge Length | N (7,1) | 49 | Structure Length | 6/N | Yes | Convert from metric to nearest tenth of a foot. | |
| B.G.03 | BG03 | Maximum Span Length | N (5,1) | 48 | Length of Maximum Span | 5/N | Yes | Convert from metric to nearest tenth of a foot. | |
| B.G.04 | BG04 | Minimum Span Length | N (5,1) | 48 | Length of Maximum Span | 5/N | Partial | Convert from metric to nearest tenth of a foot if Item 45 = 1 and Item 46 = 0. Otherwise, no value. | |
| B.G.05 | BG05 | Bridge Width Out-to-Out | N (4,1) | 52 | Deck Width, Out-to-Out | 4/N | Yes | Convert from metric to nearest tenth of a foot. Null when Item 52 = 0. | TPM must continue to use Approach Roadway Width for deck area calculations. |
| B.G.06 | BG06 | Bridge Width Curb-to-Curb | N (4,1) | 51 | Bridge Roadway Width, Curb-to-Curb | 4/N | Yes | Convert from metric to nearest tenth of a foot. | |
| B.G.07 | BG07 | Left Curb or Sidewalk Width | N (3,1) | 50A | Left curb or sidewalk width | 3/N | Yes | Convert from metric to nearest tenth of a foot. | |
| B.G.08 | BG08 | Right Curb or Sidewalk Width | N (3,1) | 50B | Right curb or sidewalk width | 3/N | Yes | Convert from metric to nearest tenth of a foot. | |
| B.G.09 | BG09 | Approach Roadway Width | N (4,1) | 32 | Approach Roadway Width | 4/N | Yes | Convert from metric to nearest tenth of a foot. | |
| B.G.10 | BG10 | Bridge Median | AN (1) | 33 | Bridge Median | 1/N | Yes | Direct transition. | |
| B.G.11 | BG11 | Skew | N (2,0) | 34 | Skew | 2/N | Yes | Direct transition. | For bridges with multiple and different skew angles Coding Guide reports average and SNBI reports maximum. Agencies will need to update in accordance with FHWA implementation timeline. |
| B.G.12 | BG12 | Curved Bridge | AN (2) | N/A | N/A | N/A | No | ||
| B.G.13 | BG13 | Maximum Bridge Height | N (3,0) | N/A | N/A | N/A | No | ||
| B.G.14 | BG14 | Sidehill Bridge | AN (1) | N/A | N/A | N/A | No | ||
| B.G.15 | BG15 | Irregular Deck Area | N (10,1) | N/A | N/A | N/A | No | ||
| B.G.16 | BG16 | Calculated Deck Area | N (10,1) | N/A | N/A | N/A | Calculate | Multiply Item 49 by Item 52 when Item 52 > 0. Otherwise multiply Item 49 by Item 32. Convert from metric to nearest tenth of a square foot. | |
| B.F.01 | BF01 | Feature Type | AN (3) | 42A/42B | Type of Service | 2/N | Yes | See tab. | |
| B.F.02 | BF02 | Feature Location | AN (1) | 42A/42B | Type of Service | 2/N | Yes | See tab. | |
| B.F.03 | BF03 | Feature Name | AN (300) | 6A/7 | Features Intersected / Facility Carried by Structure | 24/AN - 18/AN | Yes | See tab. | |
| B.RT.01 | BRT01 | Route Designation | AN (3) | N/A | N/A | N/A | Yes | R01. Assign to H01 feature. | |
| B.RT.02 | BRT02 | Route Number | AN (15) | 5D/5E | Route Number / Directional Suffix | 5/AN - 1/N | Yes | Trim leading zeroes. Append Item 5D with Item 5E - see tab. Use 0 for values that do not contain other digits. Assign to R01 route on H01 feature. | Examples: If 5D = 00035 and 5E = W, B.RT.02 = 35W. If 5D = 00000, B.RT.02 = 0. |
| B.RT.03 | BRT03 | Route Direction | AN (2) | 102 | Direction of Traffic | 1/N | Partial | See tab. Assign to R01 route on H01 feature. | Contains temporary codes to be phased out. |
| B.RT.04 | BRT04 | Route Type | AN (1) | 5B | Route Signing Prefix | 1/N | Yes | Direct transition except 8 goes to X. Assign to R01 route on H01 feature. | |
| B.RT.05 | BRT05 | Service Type | AN (1) | 5C | Designated Level of Service | 1/N | Yes | Direct transition except 0 goes to X. Assign to R01 route on H01 feature. | |
| B.H.01 | BH01 | Functional Classification | AN (1) | 26 | Functional Classification of Inventory Route | 2/N | Partial | See tab. Assign to H01 feature. | Contains temporary codes to be phased out. |
| B.H.02 | BH02 | Urban Code | AN (5) | 26 | Functional Classification of Inventory Route | 2/N | Partial | See tab. Assign to all H features. | Contains temporary codes to be phased out. |
| B.H.03 | BH03 | NHS Designation | AN (1) | 104 | Highway System of the Inventory Route | 1/N | Yes | See tab. Assign to H01 feature. | |
| B.H.04 | BH04 | National Highway Freight Network | AN (1) | 110 | Designated National Network | 1/N | Partial | See tab. Assign to H01 feature. | Contains temporary codes to be phased out. |
| B.H.05 | BH05 | STRAHNET Designation | AN (1) | 100 | STRAHNET Highway Designation | 1/N | Yes | See tab. Assign to H01 feature. | |
| B.H.06 | BH06 | LRS Route ID | AN (120) | 13A/13B | LRS Inventory Route, Subroute Number | 10/AN - 2/N | Partial | Assign to H01 feature. Eliminate all values that reduce to 0. Trim leading zeroes and spaces. Combine 13A and 13B into a 12 character (or shorter) string. | Applies to Highway. This transition will work for most States. The exceptions are New Jersey where their 13A and HPMS Route IDs have leading zeros and Wyoming where 13B portions were not in their HPMS Route ID. |
| B.H.07 | BH07 | LRS Mile Point | N (8,3) | 11 | Kilometerpoint | 7/N (7,3) | Yes | Convert from metric to nearest thousandth of a mile. Assign to H01 feature. | |
| B.H.08 | BH08 | Lanes on Highway | N (2,0) | 28A | Lanes on Structure | 2/N | Yes | Direct transition. Assign to H01 feature. | |
| B.H.09 | BH09 | Annual Average Daily Traffic | N (8,0) | 29 | Average Daily Traffic | 6/N | Yes | Direct transition. Trim leading zeroes. Assign to H01 feature. | |
| B.H.10 | BH10 | Annual Average Daily Truck Traffic | N (8,0) | 109 | Average Daily Truck Traffic | 2/N | Yes | Multiply Item 109 (percentage) by Item 29. Assign to H01 feature. | |
| B.H.11 | BH11 | Year of Annual Average Daily Traffic | N (4,0) | 30 | Year of Average Daily Traffic | 4/N | Yes | Direct transition. Assign to H01 feature. | |
| B.H.12 | BH12 | Highway Maximum Usable Vertical Clearance | N (3,1) | 10 | Inventory Route, Minimum Vertical Clearance | 4/N | Yes | Convert from metric to nearest tenth of a foot (round down). Use 99.9 for values of 30 meters or greater. Assign to H01 feature. | |
| B.H.13 | BH13 | Highway Minimum Vertical Clearance | N (3,1) | 53/54A/54B | Minimum Vertical Clearance Over Bridge Roadway / Reference Feature / Minimum Vertical Underclearance | 4/N - 1/AN - 4/N | Yes | Convert from metric to nearest tenth of a foot (round down). Use 99.9 for values of 30 meters or greater. Assign Item 53 value to H01 feature (carried). Assign Item 54B value to H02 feature (below) when Item 54A = H. Otherwise no value for highway features below the bridge. | |
| B.H.14 | BH14 | Highway Minimum Horizontal Clearance, Left | N (3,1) | 55A/56 | Reference Feature / Minimum Lateral Underclearance on Left | 1/AN - 3/N | Yes | Convert from metric to nearest tenth of a foot (round down). No value when Item 56 = 99.9 meters. Otherwise use 99.9 when Item 56 = 30 meters or greater. Assign Item 56 value to H02 feature (below) when Item 55A = H. Otherwise no value for highway features below the bridge. | |
| B.H.15 | BH15 | Highway Minimum Horizontal Clearance, Right | N (3,1) | 55A/55B | Reference Feature / Minimum Lateral Underclearance on Right | 1/AN - 3/N | Yes | Convert from metric to nearest tenth of a foot (round down). Use 99.9 when Item 55B = 30 meters or greater. Assign Item 55B value to H02 feature (below) when Item 55A = H. Otherwise no value for highway features below the bridge. | |
| B.H.16 | BH16 | Highway Maximum Usable Surface Width | N (3,1) | 47 | Inventory Route, Total Horizontal Clearance | 3/N | Yes | Convert from metric to nearest tenth of a foot (round down). Use 99.9 for values of 30 meters or greater. Assign to H01 feature. | |
| B.H.17 | BH17 | Bypass Detour Length | N (3,0) | 19 | Bypass, Detour Length | 3/N | Yes | 199 converts to 999. Otherwise convert from metric to nearest mile. Assign to H01 feature. | |
| B.H.18 | BH18 | Crossing Bridge Number | AN (15) | N/A | No | ||||
| B.RR.01 | BRR01 | Railroad Service Type | AN (2) | N/A | No | ||||
| B.RR.02 | BRR02 | Railroad Minimum Vertical Clearance | N (3,1) | 54A/54B | Reference Feature / Minimum Vertical Underclearance | 1/AN - 4/N | Yes | Convert from metric to nearest tenth of a foot (round down). Use 99.9 for values of 30 meters or greater. Use Item 54B value only when Item 54A = R. Otherwise no value for railroad features below the bridge. Assign value to R01 feature (below) when Item 42a ><4. Assign value to R02 feature (below) when Item 42a =4. |
|
| B.RR.03 | BRR03 | Railroad Minimum Horizontal Offest | N (3,1) | 55A/55B | Reference Feature / Minimum Lateral Underclearance on Right | 1/AN - 3/N | Yes | Convert from metric to nearest tenth of a foot (round down). Use 99.9 when Item 55B = 30 meters or greater. Use Item 55B value only when Item 55A = R. Otherwise no value for railroad features below the bridge. Assign value to R01 feature (below) when Item 42a ><4. Assign value to R02 feature (below) when Item 42a =4. |
|
| B.N.01 | BN01 | Navigable Waterway | AN (1) | 38 | Navigation Control | 1/AN | Partial | See tab. Assign value to W01 feature. | |
| B.N.02 | BN02 | Navigation Minimum Vertical Clearance | N (4,1) | 39/43B/116 | Navigation Vertical Clearance / Type of Design/Construction / Minimum Navigation Vertical Clearance Vertical Lift Bridge | 4/N - 2/N - 4/N | Yes | See tab. Convert from metric to nearest tenth of a foot (round down). Assign value to W01 feature only if Item 38 = 1. Otherwise no value. | |
| B.N.03 | BN03 | Movable Bridge Maximum Navigation Vertical Clearance | N (4,1) | 39/43B | Navigation Vertical Clearance / Type of Design/Construction | 4/N - 2/N | Yes | Convert Item 39 from metric to nearest tenth of a foot (round down). Assign value to W01 feature only if Item 43B = 15 and Item 38 = 1. Otherwise no value. | |
| B.N.04 | BN04 | Navigation Channel Width | N (5,1) | 40 | Navigation Horizontal Clearance | 5/N | Yes | Convert from metric to nearest tenth of a foot (round down). Assign value to W01 feature only if Item 38 = 1. Otherwise no value. | |
| B.N.05 | BN05 | Navigation Channel Minimum Horizontal Clearance | N (5,1) | N/A | No | ||||
| B.N.06 | BN06 | Substructure Navigation Protection | AN (1) | 111 | Pier or Abutment Protection (for Navigation) | 1/N | Partial | See tab. Assign value to W01 feature only if Item 38 = 1. Otherwise no value. | Contains temporary codes to be phased out. |
| B.LR.01 | BLR01 | Design Load | AN (8) | 31 | Design Load | 1/N | Yes | See tab. | |
| B.LR.02 | BLR02 | Design Method | AN (4) | N/A | No | ||||
| B.LR.03 | BLR03 | Load Rating Date | YYYYMMDD | N/A | No | ||||
| B.LR.04 | BLR04 | Load Rating Method | AN (4) | 63 | Method Used To Determine Operating Rating | 1/N - 1/N | Yes | See tab. | Using OR method and assuming IR method is the same. |
| B.LR.05 | BLR05 | Inventory Load Rating Factor | N (4,2) | 66 | Inventory Rating | 3/N | Yes | If Item 65 = 6, 7, 8, D, E, F, do the following: For submittal file, direct transition. For transition of legacy data, divide by 32.4. If Item 65 has a value other than 6, 7, 8, D, E, or F, divide by 32.67. |
https://www.fhwa.dot.gov/bridge/032204.cfm |
| B.LR.06 | BLR06 | Operating Load Rating Factor | N (4,2) | 64 | Operating Rating | 3/N | Yes | If Item 63 = 6, 7, 8, D, E, F, do the following: For submittal file, direct transition. For transition of legacy data, divide by 32.4. If Item 63 has a value other than 6, 7, 8, D, E, or F, divide by 32.67. |
https://www.fhwa.dot.gov/bridge/032204.cfm |
| B.LR.07 | BLR07 | Controlling Legal Load Rating Factor | N (4,2) | No | |||||
| B.LR.08 | BLR08 | Routine Permit Loads | AN (1) | N/A | No | ||||
| B.PS.01 | BPS01 | Load Posting Status | AN (2) | 41 | Structure Open, Posted, or Closed to Traffic | 1/AN | Partial | See tab. | Contains temporary codes to be phased out. |
| B.PS.02 | BPS02 | Posting Status Change Date | YYYYMMDD | N/A | No | ||||
| B.EP.01 | BEP01 | Legal Load Configuration | AN (3) | N/A | No | ||||
| B.EP.02 | BEP02 | Legal Load Rating Factor | N (4,2) | No | |||||
| B.EP.03 | BEP03 | Posting Type | AN (1) | N/A | No | ||||
| B.EP.04 | BEP04 | Posting Value | N (2,0) | N/A | No | ||||
| B.IR.01 | BIR01 | NSTM Inspection Required | AN (1) | 92A | Critical Feature Inspection- Fracture Critical Details | 3/AN | Yes | Direct transition. | |
| B.IR.02 | BIR02 | Fatigue Details | AN (1) | N/A | No | ||||
| B.IR.03 | BIR03 | Underwater Inspection Required | AN (1) | 92B | Critical Feature Inspection - Underwater Inspection | 3/AN | Yes | Direct transition. | |
| B.IR.04 | BIR04 | Complex Feature | AN (1) | N/A | No | ||||
| B.IE.01 | BIE01 | Inspection Type | AN (1) | 90/92/93 | Inspection Date / Critical Feature Inspection / Critical Feature Inspection Date | 4/N - 3/AN - 4/AN | Partial | See tab | |
| B.IE.02 | BIE02 | Inspection Begin Date | YYYYMMDD | 90/93 | Inspection Date / Critical Feature Inspection Date | 4/N - 4/AN | Partial | See tab. | |
| B.IE.03 | BIE03 | Inspection Completion Date | YYYYMMDD | N/A | No | ||||
| B.IE.04 | BIE04 | Nationally Certified Bridge Inspector | AN (15) | N/A | No | ||||
| B.IE.05 | BIE05 | Inspection Interval | N (2,0) | 91/92 | Designated Inspection Frequency / Critical Feature Inspection | 2/N - 3/AN | Partial | See tab. | |
| B.IE.06 | BIE06 | Inspection Due Date | YYYYMMDD | N/A | No | ||||
| B.IE.07 | BIE07 | Risk-Based Inspection Interval Method | AN (1) | N/A | No | ||||
| B.IE.08 | BIE08 | Inspection Quality Control Date | YYYYMMDD | N/A | No | ||||
| B.IE.09 | BIE09 | Inspection Quality Assurance Date | YYYYMMDD | N/A | No | ||||
| B.IE.10 | BIE10 | Inspection Data Update Date | YYYYMMDD | N/A | No | ||||
| B.IE.11 | BIE11 | Inspection Note | AN (300) | N/A | No | ||||
| B.IE.12 | BIE12 | Inspection Equipment | AN (120) | N/A | No | ||||
| B.C.01 | BC01 | Deck Condition Rating | AN (1) | 59 | Deck | 1/AN | Yes | Direct transition. | |
| B.C.02 | BC02 | Superstructure Condition Rating | AN (1) | 59 | Superstructure | 1/AN | Yes | Direct transition. | |
| B.C.03 | BC03 | Substructure Condition Rating | AN (1) | 60 | Substructure | 1/AN | Yes | Direct transition. | |
| B.C.04 | BC04 | Culvert Condition Rating | AN (1) | 62 | Culvert | 1/AN | Yes | Direct transition. | |
| B.C.05 | BC05 | Bridge Railing Condition Rating | AN (1) | 36A | Bridge railings | 1/AN | Partial | Direct transition if N. Otherwise no value. | |
| B.C.06 | BC06 | Bridge Railing Transitions Condition Rating | AN (1) | 36B | Transitions | 1/AN | Partial | Direct transition if N. Otherwise no value. | |
| B.C.07 | BC07 | Bridge Bearings Condition Rating | AN (1) | N/A | No | ||||
| B.C.08 | BC08 | Bridge Joints Condition Rating | AN (1) | N/A | No | ||||
| B.C.09 | BC09 | Channel Condition Rating | AN (1) | 61 | Channel and Channel Protetion | 1/AN | Yes | Direct transition. | |
| B.C.10 | BC10 | Channel Protection Condition Rating | AN (1) | N/A | No | ||||
| B.C.11 | BC11 | Scour Condition Rating | AN (1) | 113 | Scour Critical Bridges | 1/AN | Partial | See tab. | Contains temporary codes to be phased out. |
| B.C.12 | BC12 | Bridge Condition Classification | AN (1) | CAT10 | Bridge Condition | 1/AN | Yes | Direct transition. | |
| B.C.13 | BC13 | Lowest Condition Rating Code | AN (1) | CAT23 | Lowest Condition Code | 1/N | Yes | Direct transition. | |
| B.C.14 | BC14 | NSTM Inspection Condition | AN (1) | N/A | No | ||||
| B.C.15 | BC15 | Underwater Inspection Condition | AN (1) | N/A | No | ||||
| B.AP.01 | BAP01 | Approach Roadway Alignment | AN (1) | 72 | Approach Roadway Alignment | 1/AN | Yes | See tab. | |
| B.AP.02 | BAP02 | Overtopping Likelihood | AN (1) | 71 | Waterway Adequacy | 1/AN | Partial | See tab. | Contains temporary codes to be phased out. |
| B.AP.03 | BAP03 | Scour Vulnerability | AN (1) | 113 | Scour Critical Bridges | 1/AN | Partial | See tab. | Contains temporary codes to be phased out. |
| B.AP.04 | BAP04 | Scour Plan of Action | AN (1) | 113 | Scour Critical Bridges | 1/AN | Partial | See tab. | Contains temporary codes to be phased out. |
| B.AP.05 | BAP05 | Seismic Vulnerability | AN (1) | N/A | No | ||||
| B.W.01 | BW01 | Year Built | N (4,0) | 27 | Year Built | 4/N | Yes | Direct transition. | |
| B.W.02 | BW02 | Year Work Performed | N (4,0) | 106 | Year Reconstructed | 4/N | Yes | Direct transition if > 0. Otherwise no value. | |
| B.W.03 | BW03 | Work Performed | AN (120) | 106 | Year Reconstructed | 4/N | Partial | "RECONSTRUCTED" if > 0. Otherwise no value. | "RECONSTRUCTED is not an SNBI code for this item. Users may update this value at a later date. |
Transition of Element Data
| SNBI ID | Data Tag | SNBI Item Name | SNBI Format |
SNBIBE ID | SNBIBE Item Name | SNBIBE Format | Clean Transition? | Transition Notes for Developer | Additional Notes |
|---|---|---|---|---|---|---|---|---|---|
| B.E.01 | BE01 | Element Number | N (4,0) | EN | Element Number | N (4,0) | Yes | Direct transition. | |
| B.E.02 | BE02 | Element Parent Number | N (4,0) | EPN | Element Parent Number | N (4,0) | Yes | Direct transition. | |
| B.E.03 | BE03 | Element Total Quantity | N (8,0) | TOTALQTY | Element Total Quantity | N (8,0) | Yes | Direct transition. | |
| B.CS.01 | BCS01 | Element Quantity Condition State One | N (8,0) | CS1 | Element Quantity Condition State One | N (8,0) | Yes | Direct transition. | |
| B.CS.02 | BCS02 | Element Quantity Condition State Two | N (8,0) | CS2 | Element Quantity Condition State Two | N (8,0) | Yes | Direct transition. | |
| B.CS.03 | BCS03 | Element Quantity Condition State Three | N (8,0) | CS3 | Element Quantity Condition State Three | N (8,0) | Yes | Direct transition. | |
| B.CS.04 | BCS04 | Element Quantity Condition State Four | N (8,0) | CS4 | Element Quantity Condition State Four | N (8,0) | Yes | Direct transition. |
Transition of “Under” Records
| SNBI ID | Data Tag | SNBI Item Name | SNBI Format | 1995 Coding Guide ID |
1995 Coding Guide Item Name/ Description |
1995 Coding Guide Format (as shown in Appendix E) |
Clean Transition? | Transition Notes for Developer | Additional Notes |
|---|---|---|---|---|---|---|---|---|---|
| 5A | See note above. | ||||||||
| B.F.01 | BF01 | Feature Type | AN (3) | 42A/42B | Type of Service | 2/N | Yes | H02 | Applies to (Highway) Feature |
| B.F.02 | BF02 | Feature Location | AN (1) | 42A/42B | Type of Service | 2/N | Yes | B | Applies to (Highway) Feature |
| B.F.03 | BF03 | Feature Name | AN (300) | 6A | Features Intersected | 24/AN - 18/AN | Yes | Straight transition. The "under" record value for this item takes precedence over the "over" record value when an "under" record exists. | Applies to (Highway) Feature |
| B.RT.01 | BRT01 | Route Designation | AN (3) | N/A | N/A | N/A | Yes | R01. Assign to H02 feature. | Applies to Route. |
| B.RT.02 | BRT02 | Route Number | AN (15) | 5D/5E | Route Number / Directional Suffix | 5/AN - 1/N | Yes | Trim leading zeroes. Append Item 5D with Item 5E - see tab. Use 0 for values that do not contain other digits. Assign to R01 Route on H02 Feature. | Applies to Route. Examples: If 5D = 00035 and 5E = W, B.RT.02 = 35W. If 5D = 00000, B.RT.02 = 0. |
| B.RT.03 | BRT03 | Route Direction | AN (2) | 102 | Direction of Traffic | 1/N | Partial | See tab. Assign to R01 Route on H02 Feature. | Applies to Route |
| B.RT.04 | BRT04 | Route Type | AN (1) | 5B | Route Signing Prefix | 1/N | Yes | Direct transition except 8 goes to X. Assign to R01 Route on H02 Feature. | Applies to Route |
| B.RT.05 | BRT05 | Service Type | AN (1) | 5C | Designated Level of Service | 1/N | Yes | Direct transition except 0 goes to X. Assign to R01 Route on H02 Feature. | Applies to Route |
| B.H.01 | BH01 | Functional Classification | AN (1) | 26 | Functional Classification of Inventory Route | 2/N | Yes | See tab. Assign to H02 feature. | Applies to Highway |
| B.H.02 | BH02 | Urban Code | AN (5) | 26 | Functional Classification of Inventory Route | 2/N | Partial | See tab. Assign to all H features. | Applies to Highway |
| B.H.03 | BH03 | NHS Designation | AN (1) | 104 | Highway System of the Inventory Route | 1/N | Yes | See tab. Assign to H02 feature. | Applies to Highway |
| B.H.04 | BH04 | National Highway Freight Network | AN (1) | 110 | Designated National Network | 1/N | Partial | See tab. Assign to H02 feature. | Applies to Highway |
| B.H.05 | BH05 | STRAHNET Designation | AN (1) | 100 | STRAHNET Highway Designation | 1/N | Yes | See tab. Assign to H02 feature. | Applies to Highway |
| B.H.06 | BH06 | LRS Route ID | AN (120) | 13A/13B | LRS Inventory Route, Subroute Number | 10/AN - 2/N | Partial | Assign to H02 feature. Eliminate all values that reduce to 0. Trim leading zeroes and spaces. Combine 13A and 13B into a 12 character (or shorter) string. | Applies to Highway. This transition will work for most States. The exceptions are New Jersey where their 13A and HPMS Route IDs have leading zeros and Wyoming where 13B portions were not in their HPMS Route ID. |
| B.H.07 | BH07 | LRS Mile Point | N (8,3) | 11 | Kilometerpoint | 7/N (7,3) | Yes | Convert from metric to nearest tenth of a foot. Assign to H02 feature. | Applies to Highway |
| B.H.08 | BH08 | Lanes on Highway | N (2,0) | 28B | Lanes Under Structure | 2/N | Yes | Direct transition. Assign to H02 feature. | Applies to Highway |
| B.H.09 | BH09 | Annual Average Daily Traffic | N (8,0) | 29 | Average Daily Traffic | 6/N | Yes | Direct transition. Trim leading zeroes. Assign to H02 feature. | Applies to Highway |
| B.H.10 | BH10 | Annual Average Daily Truck Traffic | N (8,0) | 109 | Average Daily Truck Traffic | 2/N | Yes | Multiply Item 109 (percentage) by Item 29. Assign to H02 feature. | Applies to Highway |
| B.H.11 | BH11 | Year of Annual Average Daily Traffic | N (4,0) | 30 | Year of Average Daily Traffic | 4/N | Yes | Direct transition. Assign to H02 feature. | Applies to Highway |
| B.H.12 | BH12 | Highway Maximum Usable Vertical Clearance | N (3,1) | 10 | Inventory Route, Minimum Vertical Clearance | 4/N | Yes | Convert from metric to nearest tenth of a foot. Use 99.9 for values of 30 meters or greater. Assign to H02 feature. | Applies to Highway |
| B.H.16 | BH16 | Highway Maximum Usable Surface Width | N (3,1) | 47 | Inventory Route, Total Horizontal Clearance | 3/N | Yes | Convert from metric to nearest tenth of a foot (round down). Use 99.9 for values of 30 meters or greater. Assign to H02 feature. | Applies to Highway |
| B.H.17 | BH17 | Bypass Detour Length | N (3,0) | 19 | Bypass, Detour Length | 3/N | Yes | 199 converts to 999. Otherwise convert from metric to nearest tenth of a foot. Assign to H02 feature. | Applies to Highway |
“Under” Record Items That Apply to the Highway Feature
Note: Items marked N/A are not transitioned.
| CG Item | CG Description | SNBI Item | Applies to? |
|---|---|---|---|
5a |
Record Type | ||
5b |
Route Signing Prefix | B.RT.4 | Route |
5c |
Designated Level of Service | B.RT.5 | Route |
5d |
Route Number | B.RT.02 | Route |
5e |
Directional Suffix | B.RT.02 | Route |
6a |
Features Intersected | B.F.03 | Feature |
10 |
Inventory Route, Minimum Vertical Clearance | B.H.12 | Highway |
11 |
Kilometerpoint | B.H.07 | Highway |
12 |
Base Highway Network | N/A | N/A |
13a |
LRS Inventory Route | B.H.06 | Highway |
13b |
Subroute Number | B.H.06 | Highway |
19 |
Bypass, Detour Length | B.H.17 | Highway |
26 |
Functional Classification of the Inventory Route | B.H.01,02 | Highway |
28b |
Lanes Under the Structure | B.H.08 | Highway |
29 |
Average Daily Traffic | B.H.09 | Highway |
30 |
Year of Average Daily Traffic | B.H.11 | Highway |
42b |
Type of Service Under Bridge | B.F.01,02 | Feature |
47 |
Inventory Route, Total Horizontal Clearance | B.H.16 | Highway |
100 |
STRAHNET Highway Designation | B.H.05 | Highway |
102 |
Direction of Traffic | B.RT.03 | Route |
104 |
Highway System of the Inventory Route | B.H.03 | Highway |
109 |
Average Daily Truck Traffic | B.H.10 | Highway |
110 |
Designated National Network | B.H.04 | Highway |
“Under” Record Items That Apply to the Entire Bridge
Note: Do not transition for "under" records, as they are already transitioned for "over" records.
| CG Item | CG Description | SNBI Item | Applies to? |
|---|---|---|---|
1 |
State Code | B.L.01 | Bridge |
3 |
County Code | B.L.02 | Bridge |
4 |
Place Code | B.L.03 | Bridge |
7 |
Facility Carried | B.F.03 | Bridge |
8 |
Bridge Number | B.ID.01 | Bridge |
9 |
Bridge Location | B.L.11 | Bridge |
16 |
Latitude | B.L.05 | Bridge |
17 |
Longitude | B.L.06 | Bridge |
20 |
Toll | B.CL.05 | Bridge |
27 |
Year Built | B.W.01 | Bridge |
28a |
Lanes on the Structure | B.H.08 | Highway |
42a |
Type of Service on Bridge | B.F.01,02 | Feature |
43 |
Structure Type, Main | Multiple | Bridge |
48 |
Length of Maximum Span | B.G.3,4 | Bridge |
49 |
Structure Length | B.G.1,2 | Bridge |
103 |
Temporary Structure Designation | B.PS.01 | Bridge |