0006 Bridge

0006 Bridge

Migration Path

• BRIDGE -> Bridge
• BRIDGE -> AssetLocation

Data Considerations

• Duplicates
  • FIR
• Null Data Replacement
  • (Multiple fields: see sql for full details)
• Rounding
  • Some bridge fields are rounded to the SNBI allowed precision and scale (see SQL).

Other Notes

• Please note that Bridge.IsBorder is set to TRUE if BRIDGE.BB_BRDGEID has any value. This will be unexpected for most agencies, but the logic is based on the FHWA mapping guide. BRIDGE.BB_BRDGEID data potentially needs to be cleaned up before migration to get the expected Bridge.IsBorder logic.
• BRIDGE.STRUCTNAME will be mapped to BRIDGE_ID if the structure name is null, blank, or underscore value.
• Notice there is some other custom mapping logic for BridgeNickname and MinSpanLength.
• The AssetLocation mapping converts BrM 6.7.1 latitude and longitude values to the correct formats for BrM 7.0. LATITUDE and LONGITUDE values must not be null for the data to migrate.