FTP_PARCEL 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) |
DORUS_CODE |
Department of Revenue (DOR) Mandated Property use code |
VARCHAR(16) |
DORDESC |
Category Grouping of DOR Use code |
VARCHAR(10) |
DORDESC1 |
Department of Revenue (DOR) Mandated Property use code description |
VARCHAR(100) |
NH_CD |
Appraisal Neighborhood Code |
DECIMAL(10,2) |
NH_DSCR |
Appraisal Neighborhood Description |
VARCHAR(50) |
HOMESTEAD |
Homestead |
INT |
OTHEREX |
Other exemptions |
INT |
PORT_VAL |
Portability Value |
DECIMAL(12,2) |
CLS_LND_VAL |
Classified Land Value |
INT |
AG_CLASS |
Agricultural Classification |
CHAR(1) |
VALUETYPE |
Valuation Code |
VARCHAR(2) |
VALUEDESC |
Valuation Code Description |
VARCHAR(50) |
*TOT_LND_VAL |
Appraised Land Value |
INT |
*TOT_BLD_VAL |
Appraised Building Value |
INT |
*TOT_XF_VAL |
Appraised Extra Features Value |
INT |
*TOTALVAL |
Total Market Value |
INT |
RECONCILE |
Property is on Reconcile (Y,N) |
VARCHAR(6) |
*ASSESSVAL |
Total Assessed Value |
DECIMAL(12,2) |
*TAXVAL |
Base Taxable Value |
DECIMAL(12,2) |
CURTAXDIST |
Current Tax District |
VARCHAR(16) |
*TAXDIST |
Tax Dist Values are based on. Usually last years final taxdist |
VARCHAR(16) |
*AMTDUE |
Amount of Taxes |
DECIMAL(11,2) |
*MILLRATE |
Millage Rate |
DECIMAL(5,3) |
YR_CREATED |
Year Parcel was created |
INT |
YR_IMPROVED |
Year Parcel was improved |
INT |
LAST_INSP_DT |
Date of most recent inspection |
DATETIME |
TOT_ACREAGE |
Total Acreage of Parcel |
DECIMAL(12,4) |
PR_STRAP |
Parent or Prior Parcel ID number |
CHAR(25) |