AssetIntel team is continuously validating the new FHWA transition tool. We have already found some errors with the JSON output. This section will compile those discrepancies and report them to FHWA. All agencies should be aware of these discrepancies before they use the data for production.
| SNBI Attribute Id | SNBI Display Name | SNBI Data Set | Issue | Reported to FHWA? | ||
|---|---|---|---|---|---|---|
| 1 | B.LR.05 | Inventory Load Rating Factor | Primary | If Item 66 Inventory Rating = 0, it should not matter what Item 65 Method Used to Determine Inventory Rating value is. The transition value for B.LR.05 Inventory Load Rating Factor should always be 0 whether it is direct transition, divide by 32.4, or divide by 32.67. | 07-05-2023 | View Details |
| 2 | B.LR.06 | Operating Load Rating Factor | Primary | When Item 64 Operating Rating = 0, it should not matter what Item 63 Method Used to Determine Operating Rating value is. The transition value for B.LR.06 Inventory Load Rating Factor should always be 0 whether it is direct transition, divide by 32.4, or divide by 32.67. | 07-05-2023 | View Details |
| 3 | B.AP.01 | Approach Roadway Alignment | Primary | When Item 72 Approach Roadway Alignment = 4, the transition value for B.AP.01 should be “P” per the above table. The FHWA tool is transitioning this case as no value. | 07-05-2023 | View Details |
| 4 | B.AP.04 | Scour Plan of Action | Primary | FHWA is transitioning values when no crosswalk is provided. | 06/08/2023 | View Details |
| 5 | B.AP.04 | Scour Plan of Action | Primary | The FHWA tool is converting any value for Item 113 Scour Critical Bridges to “Y-T”, which is not consistent with the transition notes. | 06-15-2023 | View Details |
| 6 | B.F.01 | Feature Type | Features | When Item 42B Type of Service Under Bridge = 4 (Highway - Railroad) or 8 (Highway - Waterway - Railroad) for any under record, the railroad feature below bridge is not created. | 07-05-2023 | View Details |
| 7 | B.F.01 | Feature Type | Features | The FHWA tool only transitions features below bridge based on Item 42B Type of Service Under Bridge from the under records. This logic is flawed because waterway or railroad is generally not collected as an under record per the old coding guide. Majority of bridges has a waterway underneath with no under routes, which the FHWA tool will not create a waterway feature for. For example, Arkansas has 12,951 bridges in the inventory, and over 11,000 of them has waterway under the bridge. Over 84% of the inventory would not have waterway feature transitioned. | 07-05-2023 | View Details |
| 8 | B.H.01 | Functional Classification | Features | The FHWA tool is not transitioning B.H.01 for any highway features below bridge. The JSON output does not contain any B.H.01 values for H02..H03…etc. | 07-05-2023 | View Details |
| 9 | B.H.02 | Urban Code | Features | The FHWA tool is not transitioning B.H.02 for any highway features below bridge. The JSON output does not contain any B.H.02 values for H02..H03…etc. | 07-05-2023 | View Details |
| 10 | B.H.02 | Urban Code | Features | The translator is transitioning BH02 to "T-U" for Railroad and Pathway Features (ie P01, R01) that carried on the bridge. This is incorrect. | 07-05-2023 | View Details |
| 11 | B.H.07 | LRS Mile Point | Features | The FHWA tool is transitioning B.H.07 using meter to feet instead of using kilometer to mile conversion. | 07-05-2023 | View Details |
| 12 | B.H.12 | Highway Maximum Usable Vertical Clearance | Features | When Item 10 = 30 meters or greater, the FHWA tool is direct transitioning the value from meter to feet instead of using 99.9. | 07-05-2023 | View Details |
| 13 | B.H.13 | Highway Minimum Vertical Clearance | Features | When Item 53 or 54B = 30 meters or greater, the FHWA tool is direct transitioning the value from meter to feet instead of using 99.9. | 07-05-2023 | View Details |
| 14 | B.H.14 | Highway Minimum Horizontal Clearance, Left | Features | When Item 56 = 30 meters or greater, the FHWA tool is direct transitioning the value from meter to feet instead of using 99.9. | 07-05-2023 | View Details |
| 15 | B.H.15 | Highway Minimum Horizontal Clearance, Right | Features | When Item 55B = 30 meters or greater, the FHWA tool is direct transitioning the value from meter to feet instead of using 99.9. | 07-05-2023 | View Details |
| 16 | B.H.16 | Highway Maximum Usable Surface Width | Features | When Item 47 = 30 meters or greater, the FHWA tool is direct transitioning the value from meter to feet instead of using 99.9. | 07-05-2023 | View Details |
| 17 | B.H.17 | Bypass Detour Length | Features | When Item 19 = 199, the FHWA tool is not converting the value to 999. | 07-05-2023 | View Details |
| 18 | B.H.17 | Bypass Detour Length | Features | The FHWA tool is not transitioning B.H.17 for any highway features below bridge. The JSON output does not contain any B.H.17 values for H02..H03…etc. | 07-05-2023 | View Details |
| 19 | B.SP.01 | Span Configuration Designation | Span Sets | When Item 43B = 19, Item 44A = 0, and Item 44B = not 0 (ie 44A/B = 019), the FHWA tool only creates C01 instead of both C01 and C02. When Item 43B = any other value, Item 44A = 0, and Item 44B = not 0 (ie 44A/B = 001), the FHWA tool only creates M01 instead of both M01 and A01. | 07-05-2023 | View Details |
| 20 | B.SP.05 | Span Continuity | Span Sets | The FHWA translator is ignoring the 43B/44B = 7 condition from the above table. The JSON output does not contain B.SP.05 = 6 for any frame type bridges. | 07-05-2023 | View Details |
If Item 66 Inventory Rating = 0, it should not matter what Item 65 Method Used to Determine Inventory Rating value is. The transition value for B.LR.05 Inventory Load Rating Factor should always be 0 whether it is direct transition, divide by 32.4, or divide by 32.67.
When Item 65 = 6, 7, 8, D, E, F, do the following: For submittal file, direct transition Item 66. For transition of legacy data, divide Item 66 by 32.4. If Item 65 has a value other than 6, 7, 8, D, E, or F, divide Item 66 by 32.67.
Item 65 Method Used to Determine Inventory Rating = no value
Item 66 Inventory Rating = 0
(FHWA Transition) B.LR.05 = no value
(SNBIX Transition) B.LR.05 = 0
SNBIX can provide following workarounds:
When Item 64 Operating Rating = 0, it should not matter what Item 63 Method Used to Determine Operating Rating value is. The transition value for B.LR.06 Inventory Load Rating Factor should always be 0 whether it is direct transition, divide by 32.4, or divide by 32.67.
When Item 64 Operating Rating = 0, it should not matter what Item 63 Method Used to Determine Operating Rating value is. The transition value for B.LR.06 Inventory Load Rating Factor should always be 0 whether it is direct transition, divide by 32.4, or divide by 32.67.
Item 63 Method Used to Determine Operating Rating = no value
Item 64 Operating Rating = 0
(FHWA Transition) B.LR.06 = no value
(SNBIX Transition) B.LR.06 = 0
SNBIX can provide following workarounds:
When Item 72 Approach Roadway Alignment = 4, the transition value for B.AP.01 should be “P” per the above table. The FHWA tool is transitioning this case as no value.
See table.
| CG ID | CG Value | SNBI Value | SNBI Description |
|---|---|---|---|
| 72 | null | no value | |
| 72 | 0 to 4 | P | Poor |
| 72 | 5 to 6 | F | Fair |
| 72 | 7 to 9 | G | Good |
Item 72 Approach Roadway Alignment = 4
(FHWA Transition) B.AP.01 = no value
(SNBIX Transition) B.AP.01 = P
SNBIX can provide following workarounds:
See table.
| CG ID | CG Value | SNBI Value | SNBI Description |
|---|---|---|---|
| 113 | N | No value | |
| 113 | 4, 5, 8, 9 | 0 | A scour POA is not required |
| 113 | Any other value | Y-T | A scour POA is required and implemented |
No workaround required. AssetIntel has implemented the fix. Make sure your transition tool is aware and has implemented the changes.
The FHWA tool is converting any value for Item 113 Scour Critical Bridges to “Y-T”, which is not consistent transition notes.
See table.
| CG ID | CG Value | SNBI Value | SNBI Description |
|---|---|---|---|
| 113 | N | No value | |
| 113 | 4, 5, 8, 9 | 0 | A scour POA is not required |
| 113 | Any other value | Y-T | A scour POA is required and implemented |
Item 113 Scour Critical Bridges = 4
(FHWA Transition) B.AP.04 = Y-T
(SNBIX Transition) B.AP.04 = 0
SNBIX can provide following workarounds:
When Item 42B Type of Service Under Bridge = 4 (Highway - Railroad) or 8 (Highway - Waterway - Railroad) for any under record, the railroad feature below bridge is not created.
See table.
| CG ID 1 | CG Value 1 | CG Description 1 | CG ID 2 | CG Value 2 | CG Description 2 | SNBI Item | SNBI Value |
|---|---|---|---|---|---|---|---|
| 42B | 1 | Highway | 42A | any value | B.F.01 | H02 | |
| 42B | 2 | Railroad | 42A | 4 | Highway - Railroad | B.F.01 | R02 |
| 42B | 2 | Railroad | 42A | not 4 | No Railroad | B.F.01 | R01 |
| 42B | 3 | Trail | 42A | 5 | Highway - Trail | B.F.01 | P02 |
| 42B | 3 | Trail | 42A | not 5 | No Trail | B.F.01 | P01 |
| 42B | 4 | Highway - Railroad | 42A | 4 | Highway - Railroad | B.F.01 | H02 & R02 |
| 42B | 4 | Highway - Railroad | 42A | not 4 | Highway - Railroad | B.F.01 | H02 & R01 |
| 42B | 5 | Waterway | 42A | any value | B.F.01 | W01 | |
| 42B | 6 | Waterway | 42A | any value | B.F.01 | H02 & W01 | |
| 42B | 7 | Railroad - Waterway | 42A | 4 | Highway - Railroad | B.F.01 | R02 & W01 |
| 42B | 7 | Railroad - Waterway | 42A | not 4 | No Railroad | B.F.01 | R01 & W01 |
| 42B | 8 | Highway - Waterway - Railroad | 42A | 4 | Highway - Railroad | B.F.01 | H02 & W01 & R02 |
| 42B | 8 | Highway - Waterway - Railroad | 42A | npt 4 | No Railroad | B.F.01 | H02 & W01 & R01 |
| 42B | 9 | Relief for Waterway | 42A | any value | B.F.01 | F01 | |
| 42B | 9 | Other | 42A | any value | B.F.01 | X01 |
Item 5A Record Type = 1 (On Route)
SNBIX can provide following workarounds:
The FHWA tool only transitions features below bridge based on Item 42B Type of Service Under Bridge from the under records. This logic is flawed because waterway or railroad is generally not collected as an under record per the old coding guide. Majority of bridges has a waterway underneath with no under routes, which the FHWA tool will not create a waterway feature for. For example, Arkansas has 12,951 bridges in the inventory, and over 11,000 of them has waterway under the bridge. Over 84% of the inventory would not have waterway feature transitioned.
See table.
| CG ID 1 | CG Value 1 | CG Description 1 | CG ID 2 | CG Value 2 | CG Description 2 | SNBI Item | SNBI Value |
|---|---|---|---|---|---|---|---|
| 42B | 1 | Highway | 42A | any value | B.F.01 | H02 | |
| 42B | 2 | Railroad | 42A | 4 | Highway - Railroad | B.F.01 | R02 |
| 42B | 2 | Railroad | 42A | not 4 | No Railroad | B.F.01 | R01 |
| 42B | 3 | Trail | 42A | 5 | Highway - Trail | B.F.01 | P02 |
| 42B | 3 | Trail | 42A | not 5 | No Trail | B.F.01 | P01 |
| 42B | 4 | Highway - Railroad | 42A | 4 | Highway - Railroad | B.F.01 | H02 & R02 |
| 42B | 4 | Highway - Railroad | 42A | not 4 | Highway - Railroad | B.F.01 | H02 & R01 |
| 42B | 5 | Waterway | 42A | any value | B.F.01 | W01 | |
| 42B | 6 | Waterway | 42A | any value | B.F.01 | H02 & W01 | |
| 42B | 7 | Railroad - Waterway | 42A | 4 | Highway - Railroad | B.F.01 | R02 & W01 |
| 42B | 7 | Railroad - Waterway | 42A | not 4 | No Railroad | B.F.01 | R01 & W01 |
| 42B | 8 | Highway - Waterway - Railroad | 42A | 4 | Highway - Railroad | B.F.01 | H02 & W01 & R02 |
| 42B | 8 | Highway - Waterway - Railroad | 42A | npt 4 | No Railroad | B.F.01 | H02 & W01 & R01 |
| 42B | 9 | Relief for Waterway | 42A | any value | B.F.01 | F01 | |
| 42B | 9 | Other | 42A | any value | B.F.01 | X01 |
Item 5A Record Type = 1 (On Route)
SNBIX can provide following workarounds:
The FHWA tool is not transitioning B.H.01 for any highway features below bridge. The JSON output does not contain any B.H.01 values for H02..H03…etc.
See table.
| CG ID | CG Value | SNBI Value | SNBI Description |
|---|---|---|---|
| 26 | 01 | 1 | Interstate |
| 26 | 02 | 3 | Principal Arterial – Other |
| 26 | 06 | 4 | Minor Arterial |
| 26 | 07 | 5 | Major Collector |
| 26 | 08 | 6 | Minor Collector |
| 26 | 09 | 7 | Local |
| 26 | 11 | 1 | Interstate |
| 26 | 12 | 2 | Principal Arterial – Other Freeways and Expressways |
| 26 | 14 | 3 | Principal Arterial – Other |
| 26 | 16 | 4 | Minor Arterial |
| 26 | 17 | C-T | TEMP - collector - 5 or 6 |
| 26 | 19 | 7 | Local |
Item 5A Record Type = A (1st route under the structure)
Item 26 Functional Class of Inventory Route = 16 - Urban Minor Arterial
(FHWA Transition) B.H.01 = no value
(SNBIX Transition) B.H.01 = 4
SNBIX can provide following workarounds:
The FHWA tool is not transitioning B.H.02 for any highway features below bridge. The JSON output does not contain any B.H.02 values for H02..H03…etc.
See table.
| CG ID | CG Value | SNBI Value | SNBI Description |
|---|---|---|---|
| 26 | 01, 02, 06, 07, 08, or 09 | 99999 | Rural |
| 26 | 11, 12, 14, 16, 17, or 19 | T-U | TEMP - urban |
Item 5A Record Type = A (1st route under the structure)
Item 26 Functional Class of Inventory Route = 16 - Urban Minor Arterial
B.F.01 Feature Type = H02
(FHWA Transition) B.H.02 = no value
(SNBIX Transition) B.H.02 = T-U
SNBIX can provide following workarounds:
The FHWA tool is transitioning B.H.02 for railroad (ie. R01) and pathway (ie. P01) features carried on the bridge. B.H.02 should only be transitioned for highway features.
See table.
| CG ID | CG Value | SNBI Value | SNBI Description |
|---|---|---|---|
| 26 | 01, 02, 06, 07, 08, or 09 | 99999 | Rural |
| 26 | 11, 12, 14, 16, 17, or 19 | T-U | TEMP - urban |
B.F.01 Feature Type = P01 (Pathway)
B.F.02 Feature Location = C - Carried on bridge
(FHWA Transition) B.H.02 = T-U
(SNBIX Transition) B.H.02 = no value
SNBIX can provide following workarounds:
The FHWA tool is transitioning B.H.07 using meter to feet instead of using kilometer to mile conversion.
Convert Item 11 Kilometer Point from metric to nearest thousandth of a mile.
Item 11 Kilometer Point = 17.191
(FHWA Transition) B.H.07 = 56.401
(SNBIX Transition) B.H.07 = 10.682
SNBIX can provide following workarounds:
When Item 10 = 30 meters or greater, the FHWA tool is direct transitioning the value from meter to feet instead of using 99.9.
Convert Item 10 Inventory Route, Minimum Vertical Clearance from metric to nearest tenth of a foot. Use 99.9 for values of 30 meters or greater.
Item 10 Inventory Route, Minimum Vertical Clearance = 99.99
(FHWA Transition) B.H.12 = 327.7
(SNBIX Transition) B.H.12 = 99.9
SNBIX can provide following workarounds:
When Item 53 or 54B = 30 meters or greater, the FHWA tool is direct transitioning the value from meter to feet instead of using 99.9.
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.
Item 53 Minimum Vertical Clearance Over Bridge Roadway = 99.99
(FHWA Transition) B.H.13 = 327.7
(SNBIX Transition) B.H.13 = 99.9
SNBIX can provide following workarounds:
When Item 56 = 30 meters or greater, the FHWA tool is direct transitioning the value from meter to feet instead of using 99.9.
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.
Item 55A Reference feature = H - Highway beneath structure
Item 56 Minimum Lateral Underclearance on Left = 99.9
(FHWA Transition) B.H.14 = 327.7
(SNBIX Transition) B.H.14 = 99.9
SNBIX can provide following workarounds:
When Item 55B = 30 meters or greater, the FHWA tool is direct transitioning the value from meter to feet instead of using 99.9.
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.
Item 55A Reference feature = H - Highway beneath structure
Item 55B Minimum Lateral Underclearance = 99.9
(FHWA Transition) B.H.15 = 327.7
(SNBIX Transition) B.H.15 = 99.9
SNBIX can provide following workarounds:
When Item 47 = 30 meters or greater, the FHWA tool is direct transitioning the value from meter to feet instead of using 99.9.
Convert Item 47 Inventory Route, Total Horizontal Clearance from metric to nearest tenth of a foot (round down). Use 99.9 for values of 30 meters or greater.
Item 47 Inventory Route, Total Horizontal Clearance = 99.9
(FHWA Transition) B.H.16 = 327.7
(SNBIX Transition) B.H.16 = 99.9
SNBIX can provide following workarounds:
199 converts to 999. Otherwise convert Item 19 Bypass, Detour Length from metric to nearest mile.
Item 19 Bypass, Detour Length = 199
(FHWA Transition) B.H.17 = 199
(SNBIX Transition) B.H.17 = 999
SNBIX can provide following workarounds:
The FHWA tool is not transitioning B.H.17 for any highway features below bridge. The JSON output does not contain any B.H.17 values for H02..H03…etc.
199 converts to 999. Otherwise convert Item 19 Bypass, Detour Length from metric to nearest mile. Assign to H02 feature.
Item 5A Record Type = A (1st route under the structure)
Item 19 Bypass, Detour Length = 13
B.F.01 Feature Type = H02
(FHWA Transition) B.H.17 = no value
(SNBIX Transition) B.H.17 = 8
SNBIX can provide following workarounds:
When Item 43B = 19, Item 44A = 0, and Item 44B = not 0 (ie 44A/B = 019), the FHWA tool only creates C01 instead of both C01 and C02. When Item 43B = any other value, Item 44A = 0, and Item 44B = not 0 (ie 44A/B = 001), the FHWA tool only creates M01 instead of both M01 and A01.
The transition table above should also include Item 44A because ‘000’ is Item 44A and 44B combined.
When Item 43B = 19, Item 44A = 0, and Item 44B = not 0 (ie 44A/B = 019), the FHWA tool only creates C01 instead of both C01 and C02. When Item 43B = any other value, Item 44A = 0, and Item 44B = not 0 (ie 44A/B = 001), the FHWA tool only creates M01 instead of both M01 and A01.
Item 43B Type of Design/Construction (Main) = 19 - Culvert
Item 44A Kind of Material/Design (Approach) = 0 - Other
Item 44B Type of Design/Construction (Approach) = 19 - Culvert
(FHWA Transition) B.SP.01 = C01
(SNBIX Transition) B.SP.01 = C01, C02
Item 43B Type of Design/Construction (Main) = 02 - String/Multi-Beam or Girder
Item 44A Kind of Material/Design (Approach) = 0 - Other
Item 44B Type of Design/Construction (Approach) = 01 - Slab
(FHWA Transition) B.SP.01 = M01
(SNBIX Transition) B.SP.01 = M01, A01
SNBIX can provide following workarounds:
The FHWA translator is ignoring the 43B/44B = 7 condition from the above table. The JSON output does not contain B.SP.05 = 6 for any frame type bridges.
See table.
| CG ID | CG Value | CG ID 2 | CG Value 2 | CG ID 3 | CG Value 3 | SNBI Value | SNBI Description |
|---|---|---|---|---|---|---|---|
| 43A/44A | 2, 4, 6 | C-T | TEMP - continuous - 2 or 3 | ||||
| 43B/44B | 7 | 6 | Frame | ||||
| 43B/44B | 11, 12 | 2 | Continuous - applies only if the sum of Item 45 and 46 is greater than zero | ||||
| 43B/44B | 13, 14 | 2 | Continuous | ||||
| 43B/44B | 19 | 7-T | TEMP - buried | ||||
| 43/44 | Any other value | 1 | Simple or single span |
Item 43A Kind of Material and/or Design (Main) = 1 - Concrete
Item 43B Type of Design and/or Construction (Main) = 07 - Frame
(FHWA Transition) B.SP.05 = 1
(SNBIX Transition) B.SP.05 = 6
SNBIX can provide following workarounds: