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