NBI Data Checks
Item Checks
Checks are made on all records; An error is written to the error report only if the bridge carries highway traffic (item 42a=1,4,5,6,7. or 8)
Error Description | Explanation | Range of Values |
---|---|---|
ITEM 1 - STATE/REGION CODE NOT VALID - FATAL ERROR. | Checked for valid state code | State Codes listed in coding guide |
ITEM 2 - HIGHWAY DISTRICT IS NOT A VALID NUMBER. | No Edits Performed | |
ITEM 3 - COUNTY CODE IS NOT A VALID NUMBER. | Must be numeric. We use look up table to validate codes in each state | link on HIBT web site |
ITEM 4 - PLACE CODE IS NOT A VALID NUMBER. | Must be numeric | link on HIBT web site |
ITEM 5A - INVENTORY ROUTE IS NOT A VALID VALUE - FATAL ERROR. | Must be Entered | 1, 2, A through Z |
ITEM 5B - ROUTE SIGNING PREFIX IS NOT VALID. | Must be numeric. Range of values checked | 1 through 8 |
ITEM 5C - LEVEL OF SERVICE IS NOT VALID. | Must be numeric. Range of values checked | 0 through 8 |
ITEM 5D - ROUTE NUMBER IS NOT ENTERED. | Must be Entered; 00000 if N/A | |
ITEM 5E - DIRECTIONAL SUFFIX IS NOT VALID. | Must be numeric. Range of values checked | 0 thrugh 4 |
ITEM 6A - FEATURES INTERSECTED MUST BE ENTERED. | Must be Entered | |
ITEM 7 - THE FACILITY CARRIED MUST BE ENTERED. | Must be Entered | |
ITEM 8 - STRUCTURE NUMBER IS NOT ENTERED - FATAL ERROR. | Must be Entered | |
ITEM 8 - STRUCTURE NUMBER IS NOT UNIQUE - FATAL ERROR. | Flaggs two structures in the input file with same #. First one loaded, second written to report | |
ITEM 9 - THE LOCATION MUST BE ENTERED. | Must be entered | |
ITEM 10 - VERTICAL CLEARANCE IS NOT A VALID NUMBER. | Must be numeric | |
ITEM 11 - MILEPOINT IS NOT A VALID NUMBER. | Must be numeric | |
ITEM 16 - LATITUDE IS NOT A VALID NUMBER. | Must be numeric | |
ITEM 17 - LONGITUDE IS NOT A VALID NUMBER. | Must be numeric | |
ITEM 19 - DETOUR IS NOT A VALID NUMBER. | Must be numeric | |
ITEM 20 - TOLL CODE IS NOT VALID. | Numeric range of values checked | 1 through 5 |
ITEM 21 - MAINTENANCE RESPONSIBILITY IS NOT VALID. | Numeric range of values checked | 01,02,03,04,11,12,21,25,26,27,31,32,57 through 80 |
ITEM 22 - OWNER CODE IS NOT VALID. | Numeric range of values checked | 01,02,03,04,11,12,21,25,26,27,31,32,57 through 80 |
ITEM 26 - FUNCTIONAL CLASSIFICATION IS NOT VALID. | Numeric range of values checked | 01,02,06,07,08,09,11,12,14,16,17,19 |
ITEM 27 - YEAR BUILT IS NOT A VALID NUMBER. | Must be numeric | |
ITEM 27 - YEAR BUILT CENTURY IS NOT VALID. | First two digits checked to see if 16, 17, 18, 19 or 20 | |
ITEM 28A - TRAFFIC LANES ON IS NOT A VALID NUMBER. | Must be numeric | |
ITEM 28A - LANES FOR AN INVENTORY ROUTE(5A=1) CANNOT BE ZERO. | if 5a=1 cannot be 00 | |
ITEM 28B - TRAFFIC LANES UNDER IS NOT A VALID NUMBER. | Must be numeric | |
ITEM 29 - AVERAGE DAILY TRAFFIC IS NOT A VALID NUMBER. | Must be numeric | |
ITEM 30 - YEAR OF AVERAGE DAILY TRAFFIC IS NOT A VALID NUMBER. | Must be numeric | |
ITEM 30 - YEAR OF AVERAGE DAILY TRAFFIC IS IN THE FUTURE. | Must nto be greater than current year | |
ITEM 31 - DESIGN LOAD IS NOT A VALID CODE. | Numeric range of values checked | 0 through 9; A,B,C |
ITEM 32 - APPROACH ROADWAY WIDTH IS NOT NUMERIC. | Must be numeric | |
ITEM 33 - BRIDGE MEDIAN CODE IS NOT VALID. | Numeric range of values checked | 0 through 3 |
ITEM 34 - THE SKEW ANGLE IS NOT NUMERIC. | Must be numeric | |
ITEM 35 - THE STRUCTURE FLARED INDICATOR IS NOT A VALID CODE. | Numeric range of values checked | 0 and 1 |
ITEM 36A - THE BRIDGE RAILINGS CODE IS NOT VALID. | Range of values checked | 0, 1 and N |
ITEM 36B - THE TRANSITIONS CODE IS NOT VALID. | Range of values checked | 0, 1 and N |
ITEM 36C - THE APPROACH GUARDRAIL CODE IS NOT VALID. | Range of values checked | 0, 1 and N |
ITEM 36D - THE APPROACH GUARDRAIL END CODE IS NOT VALID. | Range of values checked | 0, 1 and N |
ITEM 37 - THE HISTORICAL SIGNIFIGANCE CODE IS NOT VALID. | Numeric range of values checked | 1 through 5 |
ITEM 38 - THE NAVAGATION CONTROL CODE IS NOT VALID. | Range of values checked | 0, 1 and N |
ITEM 39 - THE NAVAGATION VERTICAL CLEARANCE IS NOT NUMERIC. | Must be numeric | |
ITEM 40 - THE NAVAGATION HORIZONTAL CLEARANCE IS NOT NUMERIC. | Must be numeric | |
ITEM 41 - THE STRUCTURE OPEN CODE IS NOT VALID. | Range of values checked | A,B,D,E,G,K,P,R |
ITEM 42 - THE TYPE OF SERVICE CODE NOT NUMERIC-ON AND/OR UNDER | Numeric range of values checked | 0 through 9 |
ITEM 43A - THE KIND OF MATERIAL CODE IS NOT NUMERIC. | Numeric range of values checked | 0 through 9 |
ITEM 43B - THE TYPE OF DESIGN CODE IS NOT VALID. | Numeric range of values checked | 00 through 22 |
ITEM 44A - THE APPROACH KIND OF MATERIAL CODE IS NOT NUMERIC. | Numeric range of values checked | 0 through 9 |
ITEM 44B - THE APPROACH TYPE OF DESIGN CODE IS NOT VALID. | Numeric range of values checked | 00 through 22 |
ITEM 45 - THE NUMBER OF MAIN SPANS IS NOT NUMERIC. | Must be numeric | |
ITEM 46 - THE NUMBER OF APPROACH SPANS IS NOT NUMERIC. | Must be numeric | |
ITEM 47 - THE TOTAL HORIZONTAL CLEARANCE IS NOT NUMERIC. | Must be numeric | |
ITEM 48 - THE MAX SPAN LENGTH IS NOT NUMERIC. | Must be numeric | |
ITEM 49 - THE STRUCTURE LENGTH IS NOT NUMERIC. | Must be numeric | |
ITEM 50A - THE LEFT CURB WIDTH IS NOT NUMERIC. | Must be numeric | |
ITEM 50B - THE RIGHT CURB WIDTH IS NOT NUMERIC. | Must be numeric | |
ITEM 51 - THE ROADWAY WIDTH IS NOT NUMERIC. | Must be numeric | |
ITEM 52 - THE DECK WIDTH IS NOT NUMERIC. | Must be numeric | |
ITEM 53 - THE MIN VERTICAL OVER CLEARANCE IS NOT NUMERIC. | Must be numeric | |
ITEM 54A - THE UNDERCLEARANCE REF. FEATURE IS NOT A VALID CODE. | Range of values checked | H,R,N |
ITEM 54B - THE MIN VERT. UNDERCLEARANCE IS NOT NUMERIC. | Must be numeric | |
ITEM 55A - THE LATERAL REFERENCE FEATURE CODE IS NOT VALID. | Range of values checked | H,R,N |
ITEM 55B - THE MIN LATERAL UNDERCLEARANCE CODE IS NOT NUMERIC.(R) | Must be numeric | |
ITEM 56 - THE MIN LATERAL UNDERCLEARANCE CODE IS NOT NUMERIC.(L) | Must be numeric | |
ITEM 58 - THE DECK RATING CODE IS NOT VALID. | Range of values checked | 0 through 9 and N |
ITEM 59 - THE SUPERSTRUCTURE RATING CODE IS NOT VALID. | Range of values checked | 0 through 9 and N |
ITEM 60 - THE SUBSTRUCTURE RATING CODE IS NOT VALID. | Range of values checked | 0 through 9 and N |
ITEM 61 - THE CHANNEL RATING CODE IS NOT VALID. | Range of values checked | 0 through 9 and N |
ITEM 62 - THE CULVERT RATING CODE IS NOT VALID. | Range of values checked | 0 through 9 and N |
ITEM 63 - THE OPERATING RATING MUST BE CODED 1 THRU 8, OR A THRU F | Numeric range of values checked | 0 through 8; A through F |
ITEM 64 - THE OPERATING RATING IS NOT NUMERIC. | Must be numeric | |
ITEM 65 - THE INVENTORY RATING MUST BE CODED 1 THRU 8, OR A THRU F | Numeric range of values checked | 0 through 8; A through F |
ITEM 66 - THE INVENTORY RATING IS NOT NUMERIC. | Must be numeric | |
ITEM 70 - THE BRIDGE POSTING EVALUATION CODE IS NOT VALID. | Numeric range of values checked | 0 through 5 |
ITEM 71 - THE WATERWAY ADEQUACY EVALUATION CODE IS NOT VALID. | Range of values checked | 0 through 9 and N |
ITEM 72 - THE APPROACH ROAD ALIGNMENT EVAL CODE IS NOT VALID | Range of values checked | 0 through 8 |
ITEM 75A - THE TYPE OF WORK PROPOSED CODE IS NOT VALID. | Numeric range of values checked | 31 through 38 |
ITEM 75B - THE WORK DONE BY CODE IS NOT VALID. | Numeric range of values checked | 1 and 2 |
ITEM 76 - THE LENGTH OF IMPROVEMENT CODE IS NOT NUMERIC. | Must be numeric | |
ITEM 90 - THE DATE OF INSPECTION IS NOT NUMERIC. | Must be numeric | |
ITEM 90 - THE DATE OF INSPECTION MONTH IS NOT < 13. | Month cannot be greater than 12 | |
ITEM 91 - THE INSPECTION FREQUENCY MONTHS ARE NOT NUMERIC. | Must be numeric | |
ITEM 91 - THE INSPECTION FREQUENCY MONTHS IS GREATER THAN 48. | Frequency cannot be greater than 48 | |
ITEM 92A - THE FRACTURE INSPECTION CODE IS NOT VALID. | Range of values checked | Y or N |
ITEM 92A - THE FRACTURE INSP. MONTH CODE IS NOT NUMERIC. | Must be numeric | |
ITEM 92A - THE FRACTURE INSP. MONTH CODE IS NOT WITHIN RANGE. | Frequency limit up to 99 | |
ITEM 92B - THE UNDERWATER INSPECTION CODE IS NOT VALID. | Range of values checked | Y or N |
ITEM 92B - THE UNDERWATER INSP. MONTH CODE IS NOT NUMERIC. | Must be numeric | |
ITEM 92B - THE UNDERWATER INSP. MONTH CODE IS NOT WITHIN RANGE. | Frequency limit up to 99 | |
ITEM 92C - THE OTHER SPECIAL INSPECTION CODE IS NOT VALID. | Range of values checked | Y or N |
ITEM 92C - THE OTHER SPECIAL INSP. MONTH CODE IS NOT NUMERIC. | Must be numeric | |
ITEM 92C - THE OTHER SPECIAL INSP MONTH CODE IS NOT WITHIN RANGE. | Frequency limit up to 99 | |
ITEM 93A - THE FRACTURE LAST DATE IS NOT NUMERIC. | If 92a=Y then this must be numeric | |
ITEM 93A - THE FRACTURE LAST DATE - MONTH FIELD IS > 12. | Month cannot be greater than 12 | |
ITEM 93B - THE UNDERWATER LAST DATE CODE IS NOT NUMERIC. | If 92a=Y then this must be numeric | |
ITEM 93B - THE UNDERWATER LAST MONTH IS > 12. | Month cannot be greater than 12 | |
ITEM 93C - THE OTHER SPECIAL LAST DATE IS NOT NUMERIC. | If 92a=Y then this must be numeric | |
ITEM 93C - THE OTHER SPECIAL LAST MONTH IS > 12. | Month cannot be greater than 12 | |
ITEM 98A - THE NEIGHBORING STATE CODE IS NOT VALID. | Validate state code, MEX & CAN | |
ITEM 98B - THE OTHER STATE PERCENTAGE CODE IS NOT NUMERIC. | Must be numeric | |
ITEM 99 - THE OTHER STATE BRIDGE STRUCTURE NUMBER IS NOT ENTERED | Validated against 98, Cannot be null if 98a present | |
ITEM 100 - THE DEFENSE HIGHWAY DESIGNATION CODE IS NOT VALID. | Numeric range of values checked | 0 through 3 |
ITEM 101 - THE PARALLEL STRUCTURE DESIGNATION CODE IS NOT VALID. | Range of values checked | R. L, N |
ITEM 102 - THE DIRECTION OF TRAFFIC CODE IS NOT VALID. | Numeric range of values checked | 0 through 3 |
ITEM 103 - THE TEMPORARY STRUCTURE DESIGNATION CODE IS NOT VALID. | Range of values checked | T |
ITEM 104 - THE HIGHWAY SYSTEM CODE IS NOT VALID. | Numeric range of values checked | 0 or 1 |
ITEM 105 - FEDERAL LANDS HIGHWAYS MUST BE 0 THRU 6 OR 9. | Numeric range of values checked | 0 through 9 |
ITEM 106 - THE YEAR OF RECONSTRUCTION CODE IS NOT VALID. | Must be numeric if coded | |
ITEM 107 - THE DECK STRUCTURE TYPE CODE IS NOT VALID. | Range of values checked | 1 through 9 and N |
ITEM 108A - THE WEARING SURFACE TYPE CODE IS NOT VALID. | Range of values checked | 0 through 9 and N |
ITEM 108B - THE MEMBRANE TYPE CODE IS NOT VALID. | Range of values checked | 0,1,2,3,8,9,N |
ITEM 108C - THE DECK PROTECTION CODE IS NOT VALID. | Range of values checked | 0 through 9 and N |
ITEM 109 - THE ADT TRUCK TRAFFIC PERCENTAGE IS NOT VALID. | Must be numeric | |
ITEM 110 - THE NATIONAL NETWORK CODE IS NOT VALID. | Numeric range of values checked | 0 and 1 |
ITEM 111 - THE PIER PROTECTION CODE IS NOT VALID. | Numeric range of values checked | 1 through 5 |
ITEM 112 - THE NBIS BRIDGE LENGTH CODE IS NOT VALID. | Range of values checked | Y or N |
ITEM 113 - THE SCOUR CRITICAL CODE IS NOT VALID. | Range of values checked | 0 through 9 and N, U, T |
ITEM 114 - THE FUTURE ADT IS NOT NUMERIC. | Must be numeric | |
ITEM 115 - THE YEAR OF FUTURE ADT IS NOT NUMERIC. | Must be numeric | |
ITEM 115 - THE YEAR OF FUTURE ADT IS < 17 YEARS FROM INSP DATE. | Date cannot be less than 17 years from curent date | |
ITEM 115 - THE YEAR OF FUTURE ADT IS > 22 YEARS FROM INSP DATE. | Date cannot be more than 22yrs into the future | |
ITEM 116 - THE MIN NAV VERT CLEAR LIFT BRIDGE CODE IS NOT NUMERIC | Must be numeric |