PCPA_FTP_DATA_HELP

FTP_LAND 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)

LINENUM

Land Line Number

INT

LND_TP

Land Classification (A - Classified Ag, C - Common Land, M - Market Ag)

CHAR(1)

USECODE

Land Use Code

VARCHAR(5)

USEDESC

Detailed description of land use code

VARCHAR(22)

FRONTAGE

Actual frontage

DECIMAL(9,2)

DEPTH

Depth

DECIMAL(9,2)

UNITS

Units

DECIMAL(20,4)

UNITTYPE

Unit Type Code

VARCHAR(1)

UNITTPDSCR

Unit Type Desc

VARCHAR(50)

INFCODE

Influence code

VARCHAR(2)

INFLDESC

Influence code description

VARCHAR(50)