Import Inspection Units ASCII Format

Field

Data Type

Description

Street/Sec ID

Char(12)

Street and Sec ID fields combined

Date of inspection

Date

Date of Inspection MM/DD/YYYY

Inspection Unit Number

Integer

Inspection number for this section

No distress - 0 is No, -1 is Yes

Integer

Flag for no distress

Special - 0 is No, -1 is Yes

Integer

Flag for special inspection unit

Area of inspection

Real

Area for this distress

Distress Type 1

Integer

Distress Type for this distress (1 – 7)

Severity 1

Char(1)

Severity for this distress (“L”,”M”,”H”)

Distress Area 1

Real

Area for this distress

Distress Type 2

Integer

Distress Type for this distress (1 – 7)

Severity 2

Char(1)

Severity for this distress (“L”,”M”,”H”)

Distress Area 2

Real

Area for this distress

Distress Type 3

Integer

Distress Type for this distress (1 – 7)

Severity 3

Char(1)

Severity for this distress (“L”,”M”,”H”)

Distress Area 3

Real

Area for this distress

Distress Type 4

Integer

Distress Type for this distress (1 – 7)

Severity 4

Char(1)

Severity for this distress (“L”,”M”,”H”)

Distress Area 4

Real

Area for this distress

Distress Type 5

Integer

Distress Type for this distress (1 – 7)

Severity 5

Char(1)

Severity for this distress (“L”,”M”,”H”)

Distress Area 5

Real

Area for this distress

Distress Type 6

Integer

Distress Type for this distress (1 – 7)

Severity 6

Char(1)

Severity for this distress (“L”,”M”,”H”)

Distress Area 6

Real

Area for this distress

Distress Type 7

Integer

Distress Type for this distress (1 – 7)

Severity 7

Char(1)

Severity for this distress (“L”,”M”,”H”)

Distress Area 7

Real

Area for this distress

Distress Type 8

Integer

Distress Type for this distress (1 – 7)

Severity 8

Char(1)

Severity for this distress (“L”,”M”,”H”)

Distress Area 8

Real

Area for this distress

Distress Type 9

Integer

Distress Type for this distress (1 – 7)

Severity 9

Char(1)

Severity for this distress (“L”,”M”,”H”)

Distress Area 9

Real

Area for this distress

Distress Type 10

Integer

Distress Type for this distress (1 – 7)

Severity 10

Char(1)

Severity for this distress (“L”,”M”,”H”)

Distress Area 10

Real

Area for this distress

Distress Type 11

Integer

Distress Type for this distress (1 – 7)

Severity 11

Char(1)

Severity for this distress (“L”,”M”,”H”)

Distress Area 11

Real

Area for this distress

Distress Type 12

Integer

Distress Type for this distress (1 – 7)

Severity 12

Char(1)

Severity for this distress (“L”,”M”,”H”)

Distress Area 12

Real

Area for this distress

Distress Type 13

Integer

Distress Type for this distress (1 – 7)

Severity 13

Char(1)

Severity for this distress (“L”,”M”,”H”)

Distress Area 13

Real

Area for this distress

Distress Type 14

Integer

Distress Type for this distress (1 – 7)

Severity 14

Char(1)

Severity for this distress (“L”,”M”,”H”)

Distress Area 14

Real

Area for this distress

Distress Type 15

Integer

Distress Type for this distress (1 – 7)

Severity 15

Char(1)

Severity for this distress (“L”,”M”,”H”)

Distress Area 15

Real

Area for this distress

Distress Type 16

Integer

Distress Type for this distress (1 – 7)

Severity 16

Char(1)

Severity for this distress (“L”,”M”,”H”)

Distress Area 16

Real

Area for this distress

Distress Type 17

Integer

Distress Type for this distress (1 – 7)

Severity 17

Char(1)

Severity for this distress (“L”,”M”,”H”)

Distress Area 17

Real

Area for this distress

Distress Type 18

Integer

Distress Type for this distress (1 – 7)

Severity 18

Char(1)

Severity for this distress (“L”,”M”,”H”)

Distress Area 18

Real

Area for this distress

Distress Type 19

Integer

Distress Type for this distress (1 – 7)

Severity 19

Char(1)

Severity for this distress (“L”,”M”,”H”)

Distress Area 19

Real

Area for this distress

Distress Type 20

Integer

Distress Type for this distress (1 – 7)

Severity 20

Char(1)

Severity for this distress (“L”,”M”,”H”)

Distress Area 20

Real

Area for this distress

Distress Type 21

Integer

Distress Type for this distress (1 – 7)

Severity 21

Char(1)

Severity for this distress (“L”,”M”,”H”)

Distress Area 21

Real

Area for this distress