FIELD NAME

DESCRIPTION

TYPE

PARCEL_ID

18 digit account number - common link to all data files and parcel shapefiles

VARCHAR(25)

LN_NUM

This number uniquely identifies the site address for the corresponding parcel.

INT

BLD_NUM

More than one building can exist on a parcel, this number links the site address to a corresponding building.

INT

STR

Street Name

VARCHAR(50)

STR_PFX

Street Prefix

CHAR(2)

STR_NUM

Street Number

INT

STR_NUM_SFX

Street Number Suffix

CHAR(3)

STR_SFX

Street Suffix

VARCHAR(10)

STR_SFX_DIR

Street Suffix Direction

CHAR(2)

STR_UNIT

Street Unit

VARCHAR(15)

ZIP

Zip Code

VARCHAR(10)

CITY

City

VARCHAR(50)