PCPA_FTP_DATA_HELP

FTP_BLD File Layout

FIELD NAME

DESCRIPTION

TYPE

PARCEL_ID 

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

VARCHAR(25)

SECTION

Digits 5 & 6 of Parcel ID

VARCHAR(2)

TOWNSHIP

Digits 3 & 4 of Parcel ID

VARCHAR(2)

RANGE

Digits 1 & 2 of Parcel ID

VARCHAR(2)

SUB

Digits 7-12 of Parcel ID

VARCHAR(6)

PARCEL

Digits 13-18 of Parcel ID

VARCHAR(6)

BLD_NUM

More than one building can exist on a parcel.  This number along with the parcel id uniquely identifies the building record.

INT

IMPR_TYPE

Improvement Type Code

VARCHAR(4)

IMPR_TYPE_DESC

Improvement Type Description

VARCHAR(50)

STYLE

Represents Rating system when property is residential.  Represents Marshal and Swift Number for Commercial properties.

VARCHAR(4)

STYLE_DESC

Description of the rating system code when property is residential.  Description of the Marshal and Swift Number for Commercial properties.

VARCHAR(50)

STORIES

The number of stories in building

VARCHAR(6)

BLDSHAPE

Code indicating the shape of the building

VARCHAR(6)

BLDSHAPEDESC

The description of the shape of the building.  Corresponds to shape code.

VARCHAR(20)

CLASS

Class used for commercial properties only signifies material of exterior walls

CHAR(20)

CLASS_DESC

Description of the class used for commercial properties only signifies material of exterior walls

VARCHAR(50)

BATH

Number of bathrooms

REAL

UNITS

Number of units

VARCHAR(5)

BEDROOM

Number of bedrooms

REAL

FIREPLACE

Wood burning fireplace stacks

REAL

SUBSTRUCT

Foundation Code

VARCHAR(5)

SUBDESC

Foundation Code Description

VARCHAR(50)

FRAME

Frame Code

VARCHAR(5)

FRMDESC

Frame Code description

VARCHAR(50)

EFF_YEAR

Effective Year Build

INT

YEARBUILT

Actual Year Built

INT

EXTWALL

Finished Exterior Wall Type

VARCHAR(5)

EXWALLDESC

Exterior wall code description

VARCHAR(50)

ROOFTYPEROOFTYPE

Type of roof

VARCHAR(5)

ROOFTYPEDESC

Roof Type code description

VARCHAR(50)

FLOORTYPE

Floor Type code

VARCHAR(5)

FLTYDESC

Floor Type code description

VARCHAR(20)

INTWALLS

Interior walls code

VARCHAR(5)

INTWALDESC

Interior walls code description

VARCHAR(50)

LIVINGAREA

Total living area

INT

TOTALUNDERROOF

Total area under roof

INT

TRAVERSE

Building Traverse String

VARCHAR(4000)