STBRINV

Bridge Inventory

Field Name

Caption

Mask

Description

Field Type

BV_1_CD

State

3x

State

Text

BV_1_TY

State Text

60x

State Text

Text

BV_10

Inv Route MVC

nn.nn

Inventory Route, Minimum Vertical Clearance - nn.nn

Double

BV_100_CD

Defense Highway

1x

STRAHNET Highway Designation

Text

BV_100_TY

Defense Highway Text

60x

STRAHNET Highway Designation Text

Text

BV_101_CD

Parallel Struct

1x

Parallel Structure Designation

Text

BV_101_TY

Parallel Struct Text

60x

Parallel Structure Designation Text

Text

BV_102_CD

Traffic Direction

1x

Direction of Traffic

Text

BV_102_TY

Traffic Direction Text

60x

Direction of Traffic Text

Text

BV_103_CD

Temp Structure

1x

Temporary Structure Designation

Text

BV_103_TY

Temp Structure Text

60x

Temporary Structure Designation Text

Text

BV_104_CD

Hwy Sys of Inv Rte

1x

Highway System of the Inventory Route

Text

BV_104_TY

Hwy Sys of Inv Rte Text

60x

Highway System of the Inventory Route Text

Text

BV_105_CD

Fed Lands Hwy

1x

Federal Lands Highways

Text

BV_105_TY

Fed Lands Hwy Text

60x

Federal Lands Highways Text

Text

BV_106_DT

Reconstruct Date

mm/dd/yyyy

Date Reconstructed

Date/Time

BV_107_CD

Deck Structure

1x

Deck Structure Type

Text

BV_107_TY

Deck Structure Text

60x

Deck Structure Type Text

Text

BV_108A_CD

Wearing Surface

1x

Type of Wearing Surface

Text

BV_108A_TY

Wearing Surface Text

60x

Type of Wearing Surface Text

Text

BV_108B_CD

Membrane Type

1x

Type of Membrane

Text

BV_108B_TY

Membrane Type Text

60x

Type of Membrane Text

Text

BV_108C_CD

Deck Protection

1x

Deck Protection

Text

BV_108C_TY

Deck Protection Text

60x

Deck Protection Text

Text

BV_109

Truck ADT Percent

nn.

Average Daily Truck Traffic

Double

BV_11

Milepoint

nnnn.nnn

Milepoint or Kilometerpoint - nnnn.nnn

Double

BV_110_CD

National Network

1x

Designated National Network

Text

BV_110_TY

National Network Text

60x

Designated National Network Text

Text

BV_111_CD

Pier Protection

1x

Pier or Abutment Protection (for Navigation)

Text

BV_111_TY

Pier Protection Text

60x

Pier or Abutment Protection (for Navigation) Text

Text

BV_112_CD

NBIS Length

1x

NBIS Bridge Length

Text

BV_112_TY

NBIS Length Text

60x

NBIS Bridge Length Text

Text

BV_114

Future ADT

nnnnnn.

Future Average Daily Traffic

Double

BV_115_DT

Future ADT Date

mm/dd/yyyy

Date of Future Average Daily Traffic

Date/Time

BV_116

Navigation MVC

nnn.n

Minimum Navigation Vertical Clearance, Vertical Left Bridge

Double

BV_12_CD

Base Hwy Network

1x

Base Highway Network

Text

BV_12_TY

Base Hwy Network Text

60x

Base Highway Network Text

Text

BV_13A

LRS Inv Route

10x

LRS Inventory Route

Text

BV_13B

Subroute

2x

Subroute Number

Text

BV_16D

Latitude Degrees

nn.

Latitude Degrees - nn

Double

BV_16M

Latitude Minutes

nn.

Latitude Minutes - nn

Double

BV_16S

Latitude Seconds

nn.nn

Latitude Seconds - nn.nn

Double

BV_17D

Longitude Degrees

-nnnnnnnnn.nnnn

Longitude Degrees - nnn

Double

BV_17M

Longitude Minutes

nn.

Longitude Minutes - nn

Double

BV_17S

Longitude Seconds

nn.nn

Longitude Seconds - nn.nn

Double

BV_19

Detour Length (Mi)

nnn.

Bypass, Detour Length

Double

BV_2_CD

Highway Dept

2x

State Highway Department District

Text

BV_2_TY

Highway Dept Text

60x

State Highway Department District Text

Text

BV_20_CD

Toll

1x

Toll

Text

BV_20_TY

Toll Text

60x

Toll Text

Text

BV_21_CD

Maint Responsible

2x

Maintenance Responsibility

Text

BV_21_TY

Maint Responsible Text

60x

Maintenance Responsibility Text

Text

BV_22_CD

Owner

2x

Owner

Text

BV_22_TY

Owner Text

60x

Owner Text

Text

BV_26_CD

Functional Class

2x

Functional Classification of Inventory Route

Text

BV_26_TY

Functional Class Text

60x

Functional Classification of Inventory Route Text

Text

BV_27_DT

Date Built

mm/dd/yyyy

Date Built

Date/Time

BV_28A

Lanes On

nn.

Lanes On the Structure

Double

BV_28B

Lanes Under

nn.

Lanes Under the Structure

Double

BV_29

ADT

nnnnnn.

Average Daily Traffic

Double

BV_3_CD

County (Parish)

3x

County (Parish)

Text

BV_3_TY

County (Parish) Text

60x

County (Parish) Text

Text

BV_30_DT

ADT Date

mm/dd/yyyy

Date of Average Daily Traffic

Date/Time

BV_31_CD

Design Load

1x

Design Load

Text

BV_31_TY

Design Load Text

60x

Design Load Text

Text

BV_32

Approach Width

nnn.n

Approach Roadway Width

Double

BV_33_CD

Bridge Median

1x

Bridge Median

Text

BV_33_TY

Bridge Median Text

60x

Bridge Median Text

Text

BV_34

Skew (degrees)

nn.

Skew

Double

BV_35_CD

Struct Flared

1x

Structure Flared

Text

BV_35_TY

Struct Flared Text

60x

Structure Flared Text

Text

BV_37_CD

Historical Signif

1x

Historical Significance

Text

BV_37_TY

Historical Signif Text

60x

Historical Significance Text

Text

BV_38_CD

Navigate Control

1x

Navigation Control

Text

BV_38_TY

Navigate Control Text

60x

Navigation Control Text

Text

BV_39

Nav Vert Clearance

nnn.n

Navigation Vertical Clearance

Double

BV_4_CD

Place

5x

Place

Text

BV_4_TY

Place Text

60x

Place Text

Text

BV_40

Nav Hor Clearance

nnnn.n

Navigation Horizontal Clearance

Double

BV_41_CD

Oper. Status

1x

Structure Open Posted or Closed to Traffic

Text

BV_41_TY

Oper. Status Text

60x

Structure Open Posted or Closed to Traffic Text

Text

BV_42A_CD

Service On

1x

Type of Service on Bridge

Text

BV_42A_TY

Service On Text

60x

Type of Service on Bridge Text

Text

BV_42B_CD

Service Under

1x

Type of Service Under Bridge

Text

BV_42B_TY

Service UnderText

60x

Type of Service Under Bridge Text

Text

BV_43A_CD

Main Material

1x

Kind of Material

Text

BV_43A_TY

Main Material Text

60x

Kind of Material Text

Text

BV_43B_CD

Main Design

2x

Design/Construction

Text

BV_43B_TY

Main Design Text

60x

Design/Construction Text

Text

BV_44A_CD

Approach Material

1x

Material Type Code

Text

BV_44A_TY

Approach Material Text

60x

Material Type Text

Text

BV_44B_CD

Approach Design

2x

Type of Design-Construction

Text

BV_44B_TY

Approach Design Text

60x

Type of Design-Construction Text

Text

BV_45

Main Unit Spans

nnn.

Number of Spans in Main Unit

Double

BV_46

# of Approaches

nnnn.

Number of Approach Spans

Double

BV_47

THC Inv Route

nn.n

Inventory Route, Total Horizontal Clearance

Double

BV_48

Max Span Length

nnnn.n

Length of Maximum Span

Double

BV_49

Structural Length

nnnnn.n

Structural Length

Double

BV_50A

Left Curb/SW Width

nn.n

Left Curb or Sidewalk Width Feet nn.n

Double

BV_50B

Right Curb/SW Width

nn.n

Right Curb or Sidewalk Width Feet nn.n

Double

BV_51

Roadway Width

nnn.n

Bridge Roadway Width, Curb to Curb

Double

BV_52

Deck Width

nnn.n

Deck Width, Out-to-Out

Double

BV_53

MVC Over

nn.nn

Minimum Vertical Clearance Over Bridge Roadway

Double

BV_54A_CD

MVC Under From

1x

Minimum Vertical Underclearance Reference Feature

Text

BV_54A_TY

MVC Under From Text

60x

Minimum Vertical Underclearance Reference Feature Text

Text

BV_54B

MVC Under

nn.nn

Minimum Vertical Underclearance Feet nn.nn

Double

BV_55A_CD

Rt MLUC Ref

1x

Minimum Lateral Underclearance on Right Reference Feature

Text

BV_55A_TY

Rt MLUC Ref Text

60x

Minimum Lateral Underclearance on Right Reference Feature Text

Text

BV_55B

MLUC

nn.n

Minimum Lateral Underclearance on Right Feet nn.n

Double

BV_56

MLUC on Left

nn.n

Minimum Lateral Underclearance on Left

Double

BV_5A_CD

Record Type

1x

Record Type

Text

BV_5A_TY

Record Type Text

60x

Record Type Text

Text

BV_5B_CD

Route Sign Prefix

1x

Route Signing Prefix

Text

BV_5B_TY

Route Sign Prefix Text

60x

Route Signing Prefix Text

Text

BV_5C_CD

Des Service Level

1x

Designated Level of Service

Text

BV_5C_TY

Des Service Level Text

60x

Designated Level of Service Text

Text

BV_5D

Route Number

5x

Route Number

Text

BV_5E_CD

Direction Suffix

1x

Directional Suffix

Text

BV_5E_TY

Direction Suffix Text

60x

Directional Suffix Text

Text

BV_63_CD

OR Method Used

1x

Method Used to Determine Operating Rating

Text

BV_63_TY

OR Method Used Text

60x

Method Used to Determine Operating Rating Text

Text

BV_64

Operating Rating

nn.n

Operating Rating

Double

BV_65_CD

IR Method Used

1x

Method Used to Determine Inventory Rating

Text

BV_65_TY

IR Method Used Text

60x

Method Used to Determine Inventory Rating Text

Text

BV_66

Inventory Rating

nn.n

Inventory Rating

Double

BV_6A

Features Intersected

24x

Features Intersected

Text

BV_7

Facility Carried

18x

Facility Carried by Structure

Text

BV_70_CD

Bridge Posting

1x

Bridge Posting Code

Text

BV_70_TY

Bridge Posting Text

60x

Bridge Posting Text

Text

BV_75A_CD

Work Proposed

2x

Type of Work Proposed

Text

BV_75A_TY

Work Proposed Text

60x

Type of Work Proposed Text

Text

BV_75B_CD

Work Done By

1x

Work Done By

Text

BV_75B_TY

Work Done By Text

60x

Work Done By Text

Text

BV_76

Improve Length

nnnnn.n

Length of Structure Improvement

Double

BV_8

Structure Number

15x

Structure Number

Text

BV_9

Location

25x

Location

Text

BV_94

Improve Cost x1k

nnnnnn.

Bridge Improvement Cost

Double

BV_95

Road Imprv Cost x1k

nnnnnn.

Roadway Improvement Cost

Double

BV_96

Total Proj Cost x1k

nnnnnn.

Total Project Cost

Double

BV_97_DT

Date of Est Cost

mm/dd/yyyy

Date of Improvement Cost Estimate

Date/Time

BV_98A_CD

Neighboring State

3x

Neighboring State

Text

BV_98A_TY

Neighboring State Text

60x

Neighboring State Text

Text

BV_98B

% Responsible

nn.

Percent Responsibility

Double

BV_99

Border Struct #

15x

Border Bridge Structure Number

Text

BV_AZONE_CD

Alternate Zone

10x

Alternate Zone

String

BV_AZONE_TY

Alternate Zone Text

60x

Alternate Zone Text

String

BV_BR_CD

Default WO Cat

10x

Default Category Code

Text

BV_BR_TY

Default WO Cat Text

60x

Default Category Text

Text

BV_COF

Consequence of Failure

nnnn.

Consequence of Failure

Double

BV_COND_CD

General Condition

nnn

Last Inspection Condition Code

Integer

BV_COND_TY

General Condition Text

25x

Last Inspection Condition Type

Text

BV_CRT_BY

Created By

25x

Created By

Text

BV_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

BV_CS

Current Station

nnnnnnnn.nnn

Current Stationing

Double

BV_DOC_FLG

Document Available

 

Doc Available: Doc Flag

Boolean

BV_DOWLEN

Dowel Length

nnnnnnnnn.nn

Dowel Length

Double

BV_DOWSIZE

Dowel Size

nnnnnnnnn.nn

Dowel Size

Double

BV_DTHICK

Deck Thickness

nnnnnnnnn.nn

Deck Thickness

Double

BV_ERP

End Reference Post

nnnnnnnn.nnn

End Reference Post

Double

BV_FASSET

Fixed Asset ID

nnnnnnnn

Fixed Asset ID

Long Integer

BV_GPS

GPS Flag

 

GPS Flag

Boolean

BV_ID

Bridge Rec #

nnnnnnnn

AutoID

Long Integer

BV_IFREQ

Inspection Freq

nnn

Inspection Freq

Integer

BV_IFRQ_CD

Inspection Freq Units

nnn

Inspection Freq Units

Integer

BV_IFRQ_TY

Inspection Freq Units Text

10x

Inspection Freq Units Text

String

BV_INMAP

In Map

 

In Map

Boolean

BV_INSN_DT

Next Inspection

mm/dd/yyyy

Next Inspection Date

Date/Time

BV_INSP_DT

Inspection Date

mm/dd/yyyy

Last Inspection Date

Date/Time

BV_MITIGAT

Mitigation

nnnnnnnn.nn

Mitigation

Double

BV_MOD_BY

Last Modified By

25x

Last Modified By

Text

BV_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

BV_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

BV_MZONE_CD

Maintenance Zone

10x

Maintenance Zone

String

BV_MZONE_TY

Maintenance Zone Text

60x

Maintenance Zone Text

String

BV_NAME

Bridge Name

50x

Bridge Name

Text

BV_NOWORK

No WO/PM/Req

 

No WO/PM/Req

Boolean

BV_NUM

Bridge Number

25x

Bridge Number

Text

BV_OS

Original Station

nnnnnnnn.nnn

Original Stationing

Double

BV_POF

Probability of Failure

nnn.nn

Probability of Failure

Double

BV_PRATING

Permit Rating

6x

Permit Rating

Text

BV_PVALUE

Present Value

nnnnnnnnn.nn

Present Value

Double

BV_RCOST

Replacement Cost

nnnnn.nn

Replacement Cost

Double

BV_REPL_DT

Replacement Date

mm/dd/yyyy

Replacement Date

Date/Time

BV_RH_ID

Road Rec #

nnnnnnnn

Link to STRDROAD.RH_ID

Long Integer

BV_RISK

Risk

nnnn.

Risk - COF * POF

Double

BV_RLIFE

Remaining Life

nnnn.nn

Remaining Life

Double

BV_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

BV_RP

Reference Post

nnnnnnnn.nnn

Reference Post

Double

BV_RVALUE

Replacement Value

nnnnnnnnn.nn

Replacement Value

Double

BV_SB_ID

Subsegment Rec #

nnnnnnnn

Link to STSUBSEG.SB_ID

Long Integer

BV_SPEC1

Spec 1

30x

Spec 1

Text

BV_SPEC10

Spec 10

30x

Spec 10

Text

BV_SPEC11

Spec 11

30x

Spec 11

Text

BV_SPEC12

Spec 12

30x

Spec 12

Text

BV_SPEC13

Spec 13

30x

Spec 13

Text

BV_SPEC14

Spec 14

30x

Spec 14

Text

BV_SPEC15

Spec 15

30x

Spec 15

Text

BV_SPEC16

Spec 16

30x

Spec 16

Text

BV_SPEC17

Spec 17

255x

Spec 17

Text

BV_SPEC18

Spec 18

255x

Spec 18

Text

BV_SPEC19

Spec 19

255x

Spec 19

Text

BV_SPEC2

Spec 2

30x

Spec 2

Text

BV_SPEC20

Spec 20

255x

Spec 20

Text

BV_SPEC3

Spec 3

30x

Spec 3

Text

BV_SPEC4

Spec 4

30x

Spec 4

Text

BV_SPEC5

Spec 5

30x

Spec 5

Text

BV_SPEC6

Spec 6

30x

Spec 6

Text

BV_SPEC7

Spec 7

30x

Spec 7

Text

BV_SPEC8

Spec 8

30x

Spec 8

Text

BV_SPEC9

Spec 9

30x

Spec 9

Text

BV_SPTYPE_CD

Span Type

nnn

Span Type

Integer

BV_SPTYPE_TY

Span Type Text

50x

Span Type Text

Text

BV_STAT_CD

Status

nnn

Status

Integer

BV_STAT_TY

Status Text

25x

Status Text

Text

BV_STYPE_CD

Sub-Type

nnn

Sub-Type

Integer

BV_STYPE_TY

Sub-Type Text

25x

Sub-Type Text

Text

BV_SUF_RAT

Sufficiency Rating

nnnnnn.nn

Sufficiency Rating

Double

BV_USER10

User 10

mm/dd/yyyy

User 10

Date/Time

BV_USER11

User 11

mm/dd/yyyy

User 11

Date/Time

BV_USER12

User 12

mm/dd/yyyy

User 12

Date/Time

BV_USER13

User 13

 

User 13

Boolean

BV_USER14

User 14

 

User 14

Boolean

BV_USER15

User 15

 

User 15

Boolean

BV_USER1CD

User 1

nnn

User 1

Integer

BV_USER1TY

User 1 Text

25x

User 1 Text

Text

BV_USER2CD

User 2

nnn

User 2

Integer

BV_USER2TY

User 2 Text

25x

User 2 Text

Text

BV_USER3CD

User 3

nnn

User 3

Integer

BV_USER3TY

User 3 Text

25x

User 3 Text

Text

BV_USER4

User 4

30x

User 4

Text

BV_USER5

User 5

30x

User 5

Text

BV_USER6

User 6

30x

User 6

Text

BV_USER7

User 7

nnnnnnnnn.nn

User 7

Double

BV_USER8

User 8

nnnnnnnnn.nn

User 8

Double

BV_USER9

User 9

nnnnnnnnn.nn

User 9

Double

BV_WO_COMM

WO Comment

255x

Work Order Comment

Text

BV_X1

Start X Coordinate

-nnnnnnnnn.nn

Beg X Coordinate

Double

BV_X2

End X Coordinate

-nnnnnnnnn.nn

End X Coordinate

Double

BV_Y1

Start Y Coordinate

-nnnnnnnnn.nn

Beg Y Coordinate

Double

BV_Y2

End Y Coordinate

-nnnnnnnnn.nn

End Y Coordinate

Double