SNBI - National Bridge Inventory - Management and Preservation - Bridges & Structures

Detailed Code Mapping for Individual Data Items

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 the Data Crosswalk for "Over" Records and "Under" Records, while the Detailed Spreadsheet is comprised of the tables found on this page.

The tables below are also available in Excel format - codemapping.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.
Values not noted result in a null value.
The phrase "See table," in the Notes to Developer column of the Data Crosswalk for "Over" Records and "Under" Records refers to the tables for each item on this page.
Some Coding Guide codes do not transition into a permanent SNBI code, but may transition into a temporary code. Temporary codes are indicated by a "-T" appended to the code, the word "TEMP" prefacing the information in the Description column, and an asterisk in the TEMP column. The Description column gives a description of the temporary code and the possible permanent codes that could be mapped from that temporary code. All temporary codes should be updated to permanent codes in accordance with the established timeline.
See additional notes on the Data Crosswalk for "Over" Records and "Under" Records page.

B.L.09 - Border Bridge Inspection Responsibility
B.CL.01 and B.CL.02 - Owner and Maintenance Responsibility
B.CL.03 - Federal or Tribal Land Access
B.CL.04 - Historic Significance
B.CL.05 - Toll
B.SP.01 - Span Configuration Designation
B.SP.04 - Span Material
B.SP.05 - Span Continuity
B.SP.06 - Span Type
B.SP.09 - Deck Material and Type
B.SP.10 - Wearing Surface
B.SP.11 - Deck Protective System
B.SP.12 - Deck Reinforcing Protective System
B.RH.01 and B.RH.02 - Bridge Railings and Transitions
B.F.01, B.F.02, and B.F.03 - Feature Type, Feature Location, and Feature Name
B.RT.02 - Route Number
B.RT.03 - Direction of Traffic

B.H.01 - Functional Classification
B.H.02 - Urban Code
B.H.03 - NHS Designation
B.H.04 - National Highway Freight Network
B.H.05 - STRAHNET Designation
B.N.01 - Navigable Waterway
B.N.02 - Navigation Minimum Vertical Clearance
B.N.06 - Substructure Navigation Protection
B.LR.01 - Design Load
B.LR.04 - Load Rating Method
B.PS.01 - Load Posting Status
B.IE.01, B.IE.02, and B.IE.05 - Inspection Type, Inspection Begin Date, and Inspection Interval
B.C.11 and B.AP.03 - Scour Condition Rating and Scour Vulnerability
B.AP.01 - Approach Roadway Alignment
B.AP.02 - Overtopping Likelihood
B.AP.04 - Scour Plan of Action

B.L.09 - Border Bridge Inspection Responsibility

CG ID	CG Value	SNBI Value	SNBI Description
98B	99	0	No responsibility
98B	00	2	Full responsibility
98B	Any other value	1	Shared responsibility

B.CL.01 and B.CL.02 - Owner and Maintenance Responsibility

CG ID	CG Value	SNBI Value	SNBI Description
21, 22	01	S01	State Transportation Department
21, 22	02	L01	County highway agency
21, 22	03	L02	Town or township highway agency
21, 22	04	L03	City or municipal highway agency
21, 22	11	S02	State park, forest, or reservation agency
21, 22	12	L04	Local park, forest, or reservation agency
21, 22	21	SX	Other State agency
21, 22	25	LX	Other local agency
21, 22	26	P	Private
21, 22	27	R	Railroad
21, 22	31	S03	State toll authority
21, 22	32	L05	Local toll authority
21, 22	40	T	Transit agency/authority
21, 22	54	F08	Federal Emergency Management Agency (FEMA)
21, 22	55	F09	International Boundary and Water Commission, United States Section
21, 22	56	F07	U.S. Department of Veterans Affairs
21, 22	57	F03	General Services Administration (GSA)
21, 22	58	F05	Smithsonian – National Zoo
21, 22	59	D05	National Security Agency (NSA)
21, 22	60	FX	Other Federal agency
21, 22	61	I	Indian Tribal Government
21, 22	62	FL01	Bureau of Indian Affairs (BIA)
21, 22	63	FL04	U.S. Fish and Wildlife Service (FWS)
21, 22	64	FL07	U.S. Forest Service (USFS)
21, 22	66	FL05	National Park Service (NPS)
21, 22	67	F06	Tennessee Valley Authority (TVA)
21, 22	68	FL02	Bureau of Land Management (BLM)
21, 22	69	FL03	Bureau of Reclamation (USBR)
21, 22	70	FL06	U.S. Army Corps of Engineers (USACE)
21, 22	72	D01	Air Force
21, 22	73	D03	Navy/Marines
21, 22	74	D02	Army
21, 22	75	F04	National Aeronautics and Space Administration (NASA)
21,22	76	T	Transit agency/authority
21, 22	77	D04	Pentagon
21, 22	78	F01	Agriculture Research Service (ARS)
21, 22	79	F02	Department of Energy (DOE)
21, 22	80	U	Unknown

Additional SNBI Codes

SNBI Value	SNBI Description
FL0X	Other Federal Lands Management Agency
DX	Other Department of Defense

B.CL.03 - Federal or Tribal Land Access

CG ID	CG Value	SNBI Value	SNBI Description
105	0	N	Not applicable
105	1	BIA	Indian Tribal Government or Bureau of Indian Affairs
105	2	USFS	U.S. Forest Service
105	3	BLM	Bureau of Land Management
105	4	BIA\|USFS
105	5	BIA\|BLM
105	6	BLM\|USFS
105	9	BIA\|BLM\|USFS

Additional SNBI Codes

SNBI Value	SNBI Description
NPS	National Park Service
USACE	U.S. Army Corps of Engineers
USBR	Bureau of Reclamation
USFWS	U.S. Fish and Wildlife Service
X	Other

Note: Multiple values can be stored for this item.

B.CL.04 - Historic Significance

CG ID	CG Value	SNBI Value	SNBI Description	TEMP
37	1	1	Bridge is on the National Register
37	2	2	Bridge is eligible for the National Register
37	3	T	TEMP - 3 or 4 or 5 or 6	*
37	4	7	Historic significance of the bridge has not been determined
37	5	N	Bridge is not eligible for the National Register, and is not in a historic district eligible for the National Register

*Temporary code to be phased out

Additional SNBI Codes

SNBI Value	SNBI Description
3	Bridge is in a historic district that is on or eligible for the National Register, and contributes to the eligibility of the district
4	Bridge is in a historic district that is on or eligible for the National Register, but does not contribute to the eligibility of the district
5	Bridge is potentially eligible for the National Register, or potentially contributes to a historic district, but has not been evaluated
6	Bridge is on a State or local historic register, but is not eligible for the National Register

B.CL.05 - Toll

CG ID	CG Value	SNBI Value	SNBI Description
20	1	1	Toll bridge not under FHWA Toll Agreement
20	2	3	Bridge carries a toll road not under FHWA Toll Agreement
20	3	N	Bridge does not carry a toll road and is not a toll bridge
20	4	4	Bridge carries a toll road under FHWA Toll Agreement
20	5	2	Toll bridge under FHWA Toll Agreement

B.SP.01 - Span Configuration Designation

CG ID 1	CG Value 1	CG ID 2	CG Value 2	SNBI Value	SNBI Description
43B	19	44B	000	C01	Culvert
43B	19	44B	Not 000	C01 and C02	Culvert
43B	Any other value	44B	000	M01	Main
43B	Any other value	44B	Not 000	M01 and A01	Main and Approach

B.SP.04 - Span Material

CG ID	CG Value	SNBI Value	SNBI Description	TEMP
43A/44A	0	X-T	TEMP - other	*
43A/44A	1, 2	CR-T	TEMP - reinforced concrete - C01 or C02 or CX	*
43A/44A	3, 4	S-T	TEMP - steel - S01 or S02 or S03 or S04 or S05 or SX	*
43A/44A	5, 6	CP-T	TEMP - prestressed concrete - C03 or C04 or C05	*
43A/44A	7	T-T	TEMP - timber - T01 or T02 or T03 or T04 or TX	*
43A/44A	8	M-T	TEMP - masonry - M01 or M02	*
43A/44A	9	AI-T	TEMP - aluminum, wrought iron, or cast iron - A01 or I01 or I02	*

* Temporary code to be phased out

SNBI Codes

SNBI Value	SNBI Description
A01	Aluminum
C01	Reinforced concrete – cast-in-place
C02	Reinforced concrete – precast
C03	Prestressed concrete – pre-tensioned
C04	Prestressed concrete – cast-in-place post-tensioned
C05	Prestressed concrete – precast post-tensioned
CX	Concrete – other
F01	FRP composite – aramid fiber
F02	FRP composite – carbon fiber
F03	FRP composite – glass fiber
FX	FRP composite – other
I01	Iron – cast
I02	Iron – wrought
M01	Masonry – block
M02	Masonry – stone
P01	Plastic – Polyethylene
PX	Plastic - other
S01	Steel – rolled shapes
S02	Steel – welded shapes
S03	Steel – bolted shapes
S04	Steel – riveted shapes
S05	Steel – bolted and riveted shapes
SX	Steel – other
T01	Timber – glue laminated
T02	Timber – nail laminated
T03	Timber – solid sawn
T04	Timber – stress laminated
TX	Timber – other
X	Other

B.SP.05 - Span Continuity

CG ID 1	CG Value 1	CG ID 2	CG Value 2	CG ID 3	CG Value 3	SNBI Value	SNBI Description	TEMP
		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

* Temporary code to be phased out

Additional SNBI Codes

SNBI Value	SNBI Description
3	Continuous for live loads only
4	Cantilever
5	Cantilever with pin and hanger

B.SP.06 - Span Type

CG ID	CG Value	SNBI Value	SNBI Description	TEMP
43B/44B	00	X-T	TEMP - other	*
43B/44B	01	S-T	TEMP - slab - S01 or S02	*
43B/44B	02	GB-T	TEMP - girder/beam - G01 or G02 or G10 or GX	*
43B/44B	03	G09	Girder/beam – girder & floor beam
43B/44B	04	GT-T	TEMP - tee beam - G03 or G04 or G05 or G06	*
43B/44B	05	BM-T	TEMP - box girder/beam - multiple - B02 or B03	*
43B/44B	06	BS-T	TEMP - box girder/beam - single or spread - B01 or B03	*
43B/44B	07	F-T	TEMP - frame - F01 or F02 or F03 or F04	*
43B/44B	08	S-T	TEMP - slab - S01 or S02	*
43B/44B	09	T01	Truss – deck
43B/44B	10	T-T	TEMP - truss - through or pony - T02 or T03	*
43B/44B	11	AD-T	TEMP - deck arch - A01 or A02 or A03	*
43B/44B	12	AT-T	TEMP - through or tied arch - A04 or A05	*
43B/44B	13	L01	Cable – suspension
43B/44B	14	L-T	TEMP - cable-stayed or extradosed - L02 or L03	*
43B/44B	15	M01	Movable – vertical lift
43B/44B	16	M02	Movable – bascule
43B/44B	17	M03	Movable – swing
43B/44B	19	C-T	TEMP - CULVERT - arch, frame, or pipe	*
44B	20	Z-T	TEMP - MIXED TYPES	*
43B/44B	21	B04	Box girder/beam – segmental
43B/44B	22	GC-T	TEMP - channel beam - G07 or G08	*

* Temporary code to be phased out

Additional SNBI Codes

SNBI Value	SNBI Description
A01	Arch – under fill without spandrel
A02	Arch – open spandrel
A03	Arch – closed spandrel
A04	Arch – through
A05	Arch – tied
B01	Box girder/beam – single
B02	Box girder/beam – multiple adjacent
B03	Box girder/beam – multiple spread
F01	Frame – three-sided
F02	Frame – four-sided
F03	Frame – K-shaped
F04	Frame – delta-shaped
G01	Girder/beam – I-shaped adjacent
G02	Girder/beam – I-shaped spread
G03	Girder/beam – tee-beam
G04	Girder/beam – inverted tee-beam
G05	Girder/beam – double-tee adjacent
G06	Girder/beam – double-tee spread
G07	Girder/beam – channel adjacent
G08	Girder/beam – channel spread
G10	Girder/beam – through girder
GX	Girder/beam – other
L02	Cable – cable-stayed
L03	Cable – extradosed
LX	Cable – other
MX	Movable – other
P01	Pipe - rigid
P02	Pipe - flexible
S01	Slab - solid
S02	Slab - voided
T02	Truss – through
T03	Truss – pony
X01	Other – railroad flat car
X02	Other – ferry transfer
X03	Other – floating
X	Other

B.SP.09 - Deck Material and Type

CG ID 1	CG Value 1	CG ID 2	CG Value 2	SNBI Value	SNBI Description	TEMP
		107	1	CR-T	TEMP - concrete cast-in-place - C01 or C04 or CX	*
		107	2	CP-T	TEMP - concrete precast - C02 or C03 or C05 or CX	*
		107	3	S01	Steel – open grid
		107	4	S02	Steel – filled or partially filled grid
43B/44B	not 08	107	5	S-T	Steel – plate or orthotropic - S03 or S04	*
43B/44B	08	107	5	S04	Steel – orthotropic
		107	6	S05	Steel – corrugated
		107	7	A01	Aluminum
		107	8	T-T	TEMP - timber - T01 or T02 or T03 or T04 or TX	*
		107	9	X-T	TEMP - other - CX or F01 or F02 or F03 or FX or SX or X	*
		107	N	0	None

* Temporary code to be phased out

Additional SNBI Codes

SNBI Value	SNBI Description
C01	Reinforced concrete – cast-in-place
C02	Reinforced concrete – precast
C03	Prestressed concrete – pre-tensioned
C04	Prestressed concrete – cast-in-place post-tensioned
C05	Prestressed concrete – precast post-tensioned
CX	Concrete – other
F01	FRP composite – aramid fiber
F02	FRP composite – carbon fiber
F03	FRP composite – glass fiber
FX	FRP composite – other
SX	Steel – other
T01	Timber – glue laminated
T02	Timber – nail laminated
T03	Timber – solid sawn
T04	Timber – stress laminated
TX	Timber – other
X	Other

B.SP.10 - Wearing Surface

CG ID 1	CG Value 1	CG ID 2	CG Value 2	SNBI Value	SNBI Description	TEMP
		108A	0	0	None
		108A	1	C01	Concrete – monolithic
		108A	2	C02	Concrete – unmodified
		108A	3	C-T	TEMP - concrete – additive - C03 or C05 or C06 or C07 or CX	*
		108A	4	C04	Concrete – low slump
		108A	5	P-T	TEMP - polymer – P01 or P02 or PX	*
		108A	6	B01	Bituminous (asphalt)
		108A	7	T01	Timber – running planks
		108A	8	E01	Earth – gravel or soil
		108A	9	X-T	TEMP - other	*
107	any value	108A	N	no value
107	N	108A	any value	no value

* Temporary code to be phased out

Additional SNBI Codes

SNBI Value	SNBI Description
C03	Concrete – latex modified
C05	Concrete – fiber reinforced
C06	Concrete – microsilica
C07	Concrete – polyester
CX	Concrete – other
CU	Concrete – unknown
P01	Polymer – epoxy
P02	Polymer – polyester
PX	Polymer – other
S01	Steel

B.SP.11 - Deck Protective System

CG ID 1	CG Value 1	CG ID 2	CG Value 2	CG ID 3	CG Value 3	SNBI Value	SNBI Description	TEMP
		108C	any value	108B	1	M01	Membrane – built up
		108C	any value	108B	2	M02	Membrane – sheet
		108C	any value	108B	3	MX-T	TEMP - other	*
		108C	any value	108B	8	MU	Membrane – unknown
		108C	any value	108B	9	MX-T	TEMP - other	*
		108C	Not 6 or 7	108B	0	0	None
		108C	6	108B	0	A03	Admixture – polymer impregnated
		108C	7	108B	0	A01	Admixture – internally sealed
107	N	108C	any value	108B	any value	no value

* Temporary code to be phased out

Additional SNBI Codes

SNBI Value	SNBI Description
A02	Admixture – low permeability
A04	Admixture – corrosion inhibitor
A05	Admixture – ASR inhibitor
AX	Admixture – other
C01	Coating – paint
C02	Coating – silane/siloxane
C03	Coating – methacrylate
CX	Coating – other
M03	Membrane – liquid applied
MX	Membrane – other
P01	Patina – weathering steel
X	Other

B.SP.12 - Deck Reinforcing Protective System

CG ID 1	CG Value 1	CG ID 2	CG Value 2	SNBI Value	SNBI Description	TEMP
		108C	0, 6, or 7	0	None
		108C	1	C01	Coating – epoxy coated
		108C	2	C02	Coating – galvanized
		108C	3	C-T	TEMP - coating - C03 or CX	*
		108C	4	S-T	TEMP - sacrificial - S01 or S02 or SX	*
		108C	8 or 9	X-T	TEMP - other or unknown	*
		108C	N	no value
107	N	108C	any value	no value

* Temporary code to be phased out

Additional SNBI Codes

SNBI Value	SNBI Description
C03	Coating – metalized
CX	Coating – other
R01	Reinforcing – stainless, clad
R02	Reinforcing – stainless, solid
R03	Reinforcing – high chromium
R04	Reinforcing – FRP, aramid fiber
R05	Reinforcing – FRP, carbon fiber
R06	Reinforcing – FRP, glass fiber
R07	Reinforcing – FRP, other
RX	Reinforcing – other
S01	Sacrificial – cathodic, passive
S02	Sacrificial – cathodic, active
SX	Sacrificial – other
X	Other

B.RH.01 and B.RH.02 - Bridge Railings and Transitions

CG ID	CG Value	SNBI Value	SNBI Description	TEMP
36A/B	0	I0-T	TEMP - required and not present or does not meet standards - I or 0 (zero)	*
36A/B	1	Y-T	TEMP - crash-tested or meets approved standards - numerous possible codes	*
36A/B	N	N	Not applicable – roadside hardware is not required.

* Temporary code to be phased out

B.F.01, B.F.02, B.F.03 - Feature Type, Feature Location, and Feature Name

Features Carried On Bridge
CG ID 2	CG Value 2	CG Description 2	SNBI Item 1	SNBI Value 1	SNBI Item 2	SNBI Value 2	SNBI Description 2	SNBI Item 3	SNBI Value 3	Note
42A	1	Highway	B.F.01	H01	B.F.02	C	Carried on bridge	B.F.03	CG Item 7
42A	4	Highway - Railroad	B.F.01	H01 & R01	B.F.02	C	Carried on bridge	B.F.03	CG Item 7	2 records.
42A	5	Highway - Trail	B.F.01	H01 & P01	B.F.02	C	Carried on bridge	B.F.03	CG Item 7	2 records.
42A	6	Highway	B.F.01	H01	B.F.02	C	Carried on bridge	B.F.03	CG Item 7
42A	7	Highway	B.F.01	H01	B.F.02	C	Carried on bridge	B.F.03	CG Item 7
42A	8	Highway	B.F.01	H01	B.F.02	C	Carried on bridge	B.F.03	CG Item 7

Features Located Below Bridge
CG ID 1	CG Value 1	CG Description 1	CG ID 2	CG Value 2	CG Description 2	SNBI Item 1	SNBI Value 1	SNBI Item 2	SNBI Value 2	SNBI Description 2	SNBI Item 3	SNBI Value 3	Note
42B	1	Highway	42A	any value		B.F.01	H02	B.F.02	B	Below bridge	B.F.03	CG Item 6a
42B	2	Railroad	42A	4	Highway - Railroad	B.F.01	R02	B.F.02	B	Below bridge	B.F.03	CG Item 6a
42B	2	Railroad	42A	not 4	No Railroad	B.F.01	R01	B.F.02	B	Below bridge	B.F.03	CG Item 6a
42B	3	Trail	42A	5	Highway - Trail	B.F.01	P02	B.F.02	B	Below bridge	B.F.03	CG Item 6a
42B	3	Trail	42A	not 5	No Trail	B.F.01	P01	B.F.02	B	Below bridge	B.F.03	CG Item 6a
42B	4	Highway - Railroad	42A	4	Highway - Railroad	B.F.01	H02 & R02	B.F.02	B	Below bridge	B.F.03	CG Item 6a	2 records.
42B	4	Highway - Railroad	42A	not 4	No Railroad	B.F.01	H02 & R01	B.F.02	B	Below bridge	B.F.03	CG Item 6a	2 records.
42B	5	Waterway	42A	any value		B.F.01	W01	B.F.02	B	Below bridge	B.F.03	CG Item 6a
42B	6	Highway - Waterway	42A	any value		B.F.01	H02 & W01	B.F.02	B	Below bridge	B.F.03	CG Item 6a	2 records.
42B	7	Railroad - Waterway	42A	4	Highway - Railroad	B.F.01	R02 & W01	B.F.02	B	Below bridge	B.F.03	CG Item 6a	2 records.
42B	7	Railroad - Waterway	42A	not 4	No Railroad	B.F.01	R01 & W01	B.F.02	B	Below bridge	B.F.03	CG Item 6a	2 records.
42B	8	Highway - Waterway - Railroad	42A	4	Highway - Railroad	B.F.01	H02 & W01 & R02	B.F.02	B	Below bridge	B.F.03	CG Item 6a	3 records.
42B	8	Highway - Waterway - Railroad	42A	not 4	No Railroad	B.F.01	H02 & W01 & R01	B.F.02	B	Below bridge	B.F.03	CG Item 6a	3 records.
42B	9	Relief for Waterway	42A	any value		B.F.01	F01	B.F.02	B	Below bridge	B.F.03	CG Item 6a
42B	0	Other	42A	any value		B.F.01	X01	B.F.02	B	Below bridge	B.F.03	CG Item 6a

Note: Each bridge record should have one set of feature records from the Features Carried On Bridge table and one from the Features Located Below Bridge table. Bridges where Item 42A = 2, 3, 9, 0, or null are not highway bridges and should be omitted.

B.RT.02 - Route Number

CG ID	CG Value	SNBI Value	SNBI Description
5E	0	no value
5E	1	N	North
5E	2	E	East
5E	3	S	South
5E	4	W	West

Note: Item B.RT.02 is mapped by combining CG Item 5D (Route Number) and Item 5E (Directional Suffix). Item 5E applies only when the directional letters are included as part of the route number.

B.RT.03 - Direction of Traffic

CG ID	CG Value	SNBI Value	SNBI Description	TEMP
102	1	1-T	TEMP - One-way traffic - NB or EB or SB or WB	*
102	2 or 3	2-T	TEMP - Two-way traffic - NS or EW	*
102	any other value	no value

* Temporary code to be phased out

SNBI Codes

SNBI Value	SNBI Description
NB	Northbound
EB	Eastbound
SB	Southbound
WB	Westbound
NS	Northbound and Southbound
EW	Eastbound and Westbound

B.H.01 - Functional Classification

CG ID	CG Value	SNBI Value	SNBI Description	TEMP
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

* Temporary code to be phased out

B.H.02 - Urban Code

CG ID	CG Value	SNBI Value	SNBI Description	TEMP
26	01, 02, 06, 07, 08, or 09	99999	Rural
26	11, 12, 14, 16, 17, or 19	T-U	TEMP - urban	*

* Temporary code to be phased out

B.H.03 - NHS Designation

CG ID	CG Value	SNBI Value	SNBI Description
104	0	N	Non-NHS
104	1	Y	NHS

B.H.04 - National Highway Freight Network

CG ID	CG Value	SNBI Value	SNBI Description	TEMP
110	0	N	Not on the NHFN
110	1	1-T	TEMP - NHFN - 1 or 2 or 3 or 4	*

* Temporary code to be phased out

Additional SNBI Codes

SNBI Value	SNBI Description
1	Primary Highway Freight System
2	Interstate portions not on the Primary Highway Freight System
3	Critical Rural Freight Corridor
4	Critical Urban Freight Corridor

B.H.05 - STRAHNET Designation

CG ID	CG Value	SNBI Value	SNBI Description
100	0	N	Not a STRAHNET route
100	1	1	STRAHNET route
100	2	1	STRAHNET route
100	3	2	STRAHNET Connector route

B.N.01 - Navigable Waterway

CG ID	CG Value	SNBI Value	SNBI Description
38	N	no value
38	0	N	Not navigable waters
38	1	Y	Navigable waters

Additional SNBI Codes

SNBI Value	SNBI Description
U	Navigable waters designation is undetermined

B.N.02 - Navigation Minimum Vertical Clearance

CG ID	CG Value	CG ID2	CG Value3	SNBI Value
38	1	43B	15	Item 116 value
38	1	43B	Any other value	Item 39 value
38	any other value			no value

B.N.06 - Substructure Navigation Protection

CG ID	CG Value	SNBI Value	SNBI Description	TEMP
111	null	no value
111	1	1-T	TEMP - Not Required - 0 or 1	*
111	2	2	In place and functioning
111	3	3	In place but damaged/deteriorated
111	4	4	In place but reevaluation of design suggested
111	5	5	None present but reevaluation of need recommended

TEMP = Temporary code to be phased out

B.LR.01 - Design Load

CG ID	CG Value	SNBI Value	SNBI Description
31	null	no value
31	0	U	Unknown
31	1	H10	H-10
31	2	H15	H-15
31	3	HS15	HS-15
31	4	H20	H-20
31	5	HS20	HS-20
31	6	HS20M	HS-20 and Military
31	7	no value
31	8	RR	Railroad
31	9	HS20Plus	Greater than HS-20
31	A	HL93	HL-93
31	B	HL93Plus	Greater than HL-93
31	C	X	Other

B.LR.04 - Load Rating Method

CG ID	CG Value	SNBI Value	SNBI Description
63	null	no value
63	0	EJ	Field evaluation and documented engineering judgment
63	1	LFR	Load Factor Rating
63	2	ASR	Allowable Stress Rating
63	3	LRFR	Load and Resistance Factor Rating
63	4	LT	Load Testing
63	5	N	No rating anlysis or evaluation has been performed
63	6	LFR	Load Factor Rating
63	7	ASR	Allowable Stress Rating
63	8	LRFR	Load and Resistance Factor Rating
63	A	AR	Assigned Rating
63	B	AR	Assigned Rating
63	C	AR	Assigned Rating
63	D	AR	Assigned Rating
63	E	AR	Assigned Rating
63	F	AR	Assigned Rating

B.PS.01 - Load Posting Status

CG ID	CG Value	SNBI Value	SNBI Description	TEMP
41	null	no value
41	A	PO	Permanent bridge in place, open with no restrictions
41	B	PA-T	TEMP - Permanent or temporary bridge in place, posting needed - PA or PD or PM or TA or TD or TM or SA or SD or SM	*
41	D	SO	Permanent bridge with temporary shoring, open with no restrictions
41	E	TO	Temporary bridge in place, open with no restrictions
41	G	N	New bridge not yet open to traffic
41	K	C	Bridge is closed to all traffic
41	P	PP-T	TEMP - Permanent or temporary bridge in place, posted for load - PP or TP or SP	*
41	R	PR-T	TEMP - Permanent or temporary bridge in place, posted for restriction other than load - PR or TR or SR	*

* Temporary code to be phased out

B.IE.01, B.IE.02, and B.IE.05 - Inspection Type, Inspection Begin Date, and Inspection Interval

Inspection Events for Routine and Initial Inspections:
CG ID 1	CG Value 1	CG ID 2	CG Value 2	SNBI ID 1	SNBI Value 1	SNBI Description 1	SNBI ID 2	SNBI Value 2	SNBI ID 3	SNBI Value 3
90	MMYY	91	XX	B.IE.01	2	Routine (if Item 8 matches a previous year of data)	B.IE.02	20YYMM01	B.IE.05	XX, but drop leading zero
90	MMYY	91	XX	B.IE.01	1	Initial (otherwise)	B.IE.02	20YYMM01	B.IE.05	XX, but drop leading zero

Inspection Events for NSTM Inspections:
CG ID 1	CG Value 1	CG ID 2	CG Value 2	SNBI ID 1	SNBI Value 1	SNBI Description 1	SNBI ID 2	SNBI Value 2	SNBI ID 3	SNBI Value 3
92A	YXX	93A	MMYY	B.IE.01	4	NSTM	B.IE.02	20YYMM01	B.IE.05	XX, but drop leading zero
92A	any other value	93A	MMYY	B.IE.01	4	NTSM	B.IE.02	20YYMM01	B.IE.05	no value
92A	any value	93A	any other value	B.IE.01	no value		B.IE.02	no value	B.IE.05	no value

Inspection Events for Underwater Inspections:
CG ID 1	CG Value 1	CG ID 2	CG Value 2	SNBI ID 1	SNBI Value 1	SNBI Description 1	SNBI ID 2	SNBI Value 2	SNBI ID 3	SNBI Value 3
92B	YXX	93B	MMYY	B.IE.01	3	Underwater	B.IE.02	20YYMM01	B.IE.05	XX, but drop leading zero
92B	any other value	93B	MMYY	B.IE.01	3	Underwater	B.IE.02	20YYMM01	B.IE.05	no value
92B	any value	93B	any other value	B.IE.01	no value		B.IE.02	no value	B.IE.05	no value

Inspection Events for Special Inspections:
CG ID 1	CG Value 1	CG ID 2	CG Value 2	SNBI ID 1	SNBI Value 1	SNBI Description 1	SNBI ID 2	SNBI Value 2	SNBI ID 3	SNBI Value 3
92C	YXX	93C	MMYY	B.IE.01	7	Special	B.IE.02	20YYMM01	B.IE.05	XX, but drop leading zero
92C	any other value	93C	MMYY	B.IE.01	7	Special	B.IE.02	20YYMM01	B.IE.05	no value
92C	any value	93C	any other value	B.IE.01	no value		B.IE.02	no value	B.IE.05	no value

Note: Repeat all actions for previous datasets in the NBI, going back year by Note: Repeat all actions for previous datasets in the NBI, going back year by year until you reach the first dataset (which for the first set of criteria will set B.IE.01 to 1 - Initial). Do not create an inspection event for a MMYY date that has already been used (i.e. the same date may appear in multiple consecutive datasets - only the most recent data for a single date should be used to create an inspection event).

Note: Date field DD = 01 is a proxy value, as CG does not include a day.

B.C.11 and B.AP.03 - Scour Condition Rating and Scour Vulnerability

CG ID	CG Value	SNBI ID 1	SNBI Value 1	SNBI Description 1	SNBI ID 2	SNBI Value 2	SNBI Description 2	TEMP
113	N	B.C.11	N		B.AP.03	no value	Bridge does not cross over waterway.
113	U	B.C.11	no value		B.AP.03	U	Scour appraisal has not been completed due to unknown foundations.
113	T	B.C.11	no value		B.AP.03	0	Scour appraisal has not been completed.
113	9	B.C.11	9	No scour.	B.AP.03	A	Scour appraisal completed. Bridge determined to be stable for scour.
113	8	B.C.11	MI-T	TEMP - Scour may exist but has not affected strength or stability - 5 or 6 or 7 or 8 or 9	B.AP.03	AB-T	TEMP - Stable for scour, possibly dependent on countermeasures - A or B	*
113	7	B.C.11	MI-T	TEMP - Scour may exist but has not affected strength or stability - 5 or 6 or 7 or 8 or 9	B.AP.03	BCE-T	TEMP - Undesigned scour countermeasures installed - B or C or E	*
113	6	B.C.11	no value		B.AP.03	0	Scour appraisal has not been completed.
113	5	B.C.11	MI-T	TEMP - Scour may exist but has not affected strength or stability - 5 or 6 or 7 or 8 or 9	B.AP.03	AB-T	TEMP - Stable for scour, possibly dependent on countermeasures - A or B	*
113	4	B.C.11	MO-T	TEMP - Scour is significant but has not affected strength or stability - 5 or 6	B.AP.03	AB-T	TEMP - Stable for scour, possibly dependent on countermeasures - A or B	*
113	3	B.C.11	MI-T	TEMP - Scour may exist but has not affected strength or stability - 5 or 6 or 7 or 8 or 9	B.AP.03	CD-T	TEMP - Unstable for theoretical scour, regardless of any undesigned countermeasures - C or D	*
113	2	B.C.11	MA-T	TEMP - Scour has affected strength and/or stability of the bridge - 2 or 3 or 4	B.AP.03	CD-T	TEMP - Unstable for theoretical scour, regardless of any undesigned countermeasures - C or D	*
113	1	B.C.11	1	Bridge is closed to traffic due to scour condition. Channel rehabilitation may return the bridge to service.	B.AP.03	CD-T	TEMP - Unstable for theoretical scour, regardless of any undesigned countermeasures - C or D	**
113	0	B.C.11	0	Bridge is closed due to scour condition, and is beyond corrective action. Bridge replacement is needed to restore service.	B.AP.03	CD-T	TEMP - Unstable for theoretical scour, regardless of any undesigned countermeasures - C or D	**

* Temporary codes for B.C.11 and B.AP.03 to be phased out
** Temporary code for B.AP.03 to be phased out

Additional SNBI Codes for Item B.C.11

SNBI Value	SNBI Description
8	Insignificant scour.
7	Some minor scour.
6	Widespread minor or isolated moderate scour.
5	Moderate scour; strength and stability of the bridge are not affected.
4	Widespread moderate or isolated major scour; strength and/or stability of the bridge is affected.
3	Major scour; strength and/or stability of the bridge is seriously affected. Condition typically necessitates more frequent monitoring, load restrictions, and/or corrective actions.
2	Major scour; strength and/or stability of the bridge is severely compromised. Condition typically necessitates frequent monitoring, significant load restrictions, and/or corrective actions to keep the bridge open.

Additional SNBI Codes for Item B.AP.03

SNBI Value	SNBI Description
B	Scour appraisal completed. Bridge determined to be stable for scour, dependent upon designed, and functioning countermeasures.
C	Scour appraisal completed. Bridge could become unstable for scour. Temporary (not designed) countermeasure installed to mitigate scour. Bridge is scour critical.
D	Scour appraisal completed. Bridge is, or may become, unstable for scour. Bridge is scour critical.
E	Scour appraisal has not been completed. Temporary (not designed) countermeasure installed to mitigate scour.

B.AP.01 - Approach Roadway Alignment

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

B.AP.02 - Overtopping Likelihood

CG ID 1	CG Value 1	CG ID 2	CG Value 2	SNBI Value	SNBI Description	TEMP
71	N	26	any value	no value	Bridge does not cross over a waterway
71	9	26	any value	1	Remote – once every 100 years or less frequently
71	8	26	any value	1	Remote – once every 100 years or less frequently
71	7	26	any value	VLM-T	TEMP - Very low to moderate - 2 or 3 or 4	*
71	6	26	08, 09, or 19	1	Remote – once every 100 years or less frequently
71	6	26	any other value	VLM-T	TEMP - Very low to moderate - 2 or 3 or 4	*
71	5	26	any value	1	Remote – once every 100 years or less frequently
71	4	26	08, 09, or 19	5	High - once every 3-10 years
71	4	26	any other value	1	Remote – once every 100 years or less frequently
71	3	26	08, 09, or 19	6	Very High - once every 2 years or more frequently
71	3	26	01, 11, or 12	1	Remote – once every 100 years or less frequently
71	3	26	any other value	5	High - once every 3-10 years
71	2	26	any value	HVH-T	TEMP - High to very high - 5 or 6	*
71	0	26	any value	HVH-T	TEMP - High to very high - 5 or 6	*

* Temporary code to be phased out

Additional SNBI Codes

SNBI Value	SNBI Description
0	Never
2	Very low - once every 51 to 99 years
3	Low - once every 26 to 50 years
4	Moderate - once every 11 to 25 years

B.AP.04 - Scour Plan of Action

CG ID	CG Value	SNBI ID	SNBI Value	SNBI Description	TEMP
113	N	B.AP.04	No value
113	4, 5, 8, 9	B.AP.04	0	A scour POA is not required
113	Any other value	B.AP.04	Y-T	A scour POA is required and implemented	*

* Temporary code to be phased out

Bridges & Structures

Detailed Code Mapping for Individual Data Items

B.L.09 - Border Bridge Inspection Responsibility

B.CL.01 and B.CL.02 - Owner and Maintenance Responsibility

Additional SNBI Codes

B.CL.03 - Federal or Tribal Land Access

Additional SNBI Codes

B.CL.04 - Historic Significance

Additional SNBI Codes

B.CL.05 - Toll

B.SP.01 - Span Configuration Designation

B.SP.04 - Span Material

SNBI Codes

B.SP.05 - Span Continuity

Additional SNBI Codes

B.SP.06 - Span Type

Additional SNBI Codes

B.SP.09 - Deck Material and Type

Additional SNBI Codes

B.SP.10 - Wearing Surface

Additional SNBI Codes

B.SP.11 - Deck Protective System

Additional SNBI Codes

B.SP.12 - Deck Reinforcing Protective System

Additional SNBI Codes

B.RH.01 and B.RH.02 - Bridge Railings and Transitions

B.F.01, B.F.02, B.F.03 - Feature Type, Feature Location, and Feature Name

B.RT.02 - Route Number

B.RT.03 - Direction of Traffic

SNBI Codes

B.H.01 - Functional Classification

B.H.02 - Urban Code

B.H.03 - NHS Designation

B.H.04 - National Highway Freight Network

Additional SNBI Codes

B.H.05 - STRAHNET Designation

B.N.01 - Navigable Waterway

Additional SNBI Codes

B.N.02 - Navigation Minimum Vertical Clearance

B.N.06 - Substructure Navigation Protection

B.LR.01 - Design Load

B.LR.04 - Load Rating Method

B.PS.01 - Load Posting Status

B.IE.01, B.IE.02, and B.IE.05 - Inspection Type, Inspection Begin Date, and Inspection Interval

B.C.11 and B.AP.03 - Scour Condition Rating and Scour Vulnerability

Additional SNBI Codes for Item B.C.11

Additional SNBI Codes for Item B.AP.03

B.AP.01 - Approach Roadway Alignment

B.AP.02 - Overtopping Likelihood

Additional SNBI Codes

B.AP.04 - Scour Plan of Action

Contacts