Parcel Attribute Table field list and descriptions.

 

SITEADDRESS - This table is composed of building addresses maintained by CCH DPP.  It is downloaded from the Posse Permit system on a weekly schedule.

 

Link field to GIS parcel layer: TMK

 

TMK                     TAX MAP KEY

POI                       REGULATORY PARCEL OBJECT ID

HOUSEPRFX      HOUSE ADDRESS PREFIX NUMBER (I.E. 45-XXX)

HOUSENUMBR  HOUSE NUMBER (I.E. XX-1234)

HOUSESUFFX    HOUSE UNIT NUMBER  XX-1234B)

STREETNAME    STREET NAME

CITY                     CITY

LOADDATE         DATE OF CONVERSION

 

 

ASMTGIS

 

This table downloaded from BFS Real Property Assessment on a weekly schedule.

Real Property Assessment Value/Exemption Table.  This table contains the total (summary) values for assessment and exemption.

 

Link field to GIS parcel layer: TMK

Common column between BFS tables: parid.

 

 

 

ASMTGIS field descriptions:

 

PARID                                UNIQUE PARCEL ID (TMK AND HPR/CPR NUMBER; 12 DIGITS)

TMK                                    TMK NUMBER (8 DIGIT)

SUFFIX                               HPR/CPR NUMBER (4 DIGIT)

SEQ                                     SEQUENTIAL NUMBER

TAXYR                               TAX YEAR

BUILDINGVALUE            ASSESSED BUILDING VALUE

BUILDINGEXEMPTION   BUIDING TAX EXEMPTION

LANDVALUE                    ASSESSED LAND VALUE

LANDEXEMPTION           LAND TAX EXEMPTION

PITTSQFT                           SQ FT FOR PORTION OF LOT IN TAX RATE CODE

PITTACRE                          ACRE FOR PORTION OF LOT IN TAX RATE CODE

TAXRATECODE                TAX RATE CODE

OBJECTID                           unique system generated id number (sde registration)

 

 

ASMTPITT

 

Real Property Assessment Tax Class (Pitt) Code Table.  May contain more than 1 record on a parcel where

 a parcel has 2 or more distinct Tax class codes.  In this case, the assessed values and areas will

not be the total value but a sub value determined for that particular tax code area. 

See ASMTGIS for total (summary) values for assessment and area on a parcel.

 

Link field to GIS parcel layer: TMK

Common column between BFS tables: parid.

 

 

ASMTPITT field descriptions:

 

PARID                           UNIQUE PARCEL ID (TMK AND HPR/CPR NUMBER; 12 DIGITS)

TMK                               TMK NUMBER (8 DIGIT)

SUFFIX                          HPR/CPR NUMBER (4 DIGIT)

SEQ                                SEQUENTIAL NUMBER 1 ... N NUMBER OF PARID RECORDS

TAXYR                          TAX YEAR

BUILDINGVALUE       ASSESSED BUILDING VALUE

BUILDEXEMPTION     BUILDING TAX EXEMPTION

LANDVALUE                ASSESSED LAND VALUE FOR PORTION OF LOT IN TAX CLASS CODE

LANDEXEMPTION       LAND TAX EXEMPTION FOR PORTION OF LOT IN TAX CLASS CODE

TAXCLASS                    TAX CLASS CODE

PITTSQFT                      SQ FT FOR PORTION OF LOT IN TAX CLASS CODE

PITTACRE                     ACRE FOR PORTION OF LOT IN TAX CLASS CODE

 

 

 

OWNDAT

 

This table downloaded from BFS weekly.  It contains the first recorded owner on the parcel. There

should be one record for every parid.  See ownmlt table for other owners. 

 

Link field to GIS parcel layer: TMK

Common column between BFS tables: parid.

 

OWNDAT field descriptions:

 

PARID                UNIQUE PARCEL ID (TMK AND HPR/CPR NUMBER; 12 DIGITS)

TMK                    TMK NUMBER (8 DIGIT)

SUFFIX               HPR/CPR NUMBER (4 DIGIT)

SEQ                     SEQUENTIAL NUMBER 1 ... N NUMBER OF PARID RECORDS

TAXYR               TAX YEAR

OWNER              TAX OWNER

OWNERTYPE    OWNER TYPE (SEE BELOW)

PCTOWNER        PERCENTAGE OF LOT OWNED

TAXADDRESS   TAX BILL ADDRESS

CITY                TAX BILL CITY

STATE             TAX BILL STATE

COUNTRY       TAX BILL COUNTRY

ZIP5                  TAX BILL ZIP CODE (5 DIGIT)

ZIP4                  TAX BILL ZIP CODE (4 DIGIT)

ADDRESS1      ALTERNATE NAME

ADDRESS3      TAX BILL CITY-STATE/OTHER COMMENT

OWNTYPE3     OWNERTYPE 3 (see below)

MARSTAT        MARITAL STATUS

GRPFLAG        Grouping code for multiple owners

OBJECTID        unique system generated id number

 

 

 

OWNMLT

 

This table downloaded from BFS Real Property Assessment on a weekly schedule.  It contains additional owners where more than one is listed in

the deed for the parcel. Does not contain first recorded owner.  See OWNDAT for first recorded owner.

 

Link field to GIS parcel layer: TMK

Common column between BFS tables: parid.

 

 

 

OWNMLT field descriptions:

 

PARID              UNIQUE PARCEL ID (TMK AND HPR/CPR NUMBER; 12 DIGITS)

TMK                 TMK NUMBER (8 DIGIT)

SUFFIX            HPR/CPR NUMBER (4 DIGIT)

OWNSEQ         SEQUENTIAL NUMBER 1 ... N NUMBER OF PARID RECORDS

TAXYR             TAX YEAR

OWNER1          TAX OWNER

OWNER2          OTHER NAME/COMMENT

OWNERTYPE  OWNER TYPE (SEE BELOW)

PCTOWNER      PERCENTAGE OF LOT OWNED

TAXADDRESS TAX BILL ADDRESS

CITY                  TAX BILL CITY

STATE               TAX BILL STATE

COUNTRY        TAX BILL COUNTRY

ZIP5                   TAX BILL ZIP CODE (5 DIGIT)

ZIP4                   TAX BILL ZIP CODE (4 DIGIT)

ADDRESS1       ALTERNATE NAME

ADDRESS3        TAX BILL CITY-STATE (OTHER COMMENT)

OWNTYPE3       OWNERTYPE 3 (see below)

MARSTAT          MARITAL STATUS

GRPFLAG             Grouping code for multiple owners

OBJECTID            unique system generated id number

 

 

OWNALL

 

This table downloaded from BFS Real Property Assessment on a weekly schedule.  It is created from the ownall view which contains all owners listed in the deed for the parcel.

 

Link field to GIS parcel layer: TMK

Common column between BFS tables: parid.

 

OWNALL Field Descriptions

 

 

PARID                   UNIQUE PARCEL ID (TMK AND HPR/CPR NUMBER; 12 DIGITS)

TMK                      TMK NUMBER (8 DIGIT)

SUFFIX                 HPR/CPR NUMBER (4 DIGIT)

OWNSEQ              SEQUENTIAL NUMBER 1 ... N NUMBER OF PARID RECORDS

TAXYR                  TAX YEAR

TAXBILLOWN1    TAX OWNER

TAXBILLOWN2    OTHER NAME/COMMENT

PCTOWNED           PERCENTAGE OF LOT OWNED

OWNTYPE1           OWNER TYPE1 CODE (SEE Owntype Desc)

OWNTYPE2           OWNER TYPE2 CODE (SEE Owntype Desc)

OWNTYPE3           OWNER TYPE3 CODE (SEE Owntype Desc)

OWNTYPE4           OWNER TYPE4 CODE (SEE Owntype Desc)

ADDRESS1             TAX BILL ADDRESS

ADDRESS2            ALTERNATE NAME

ADDRESS3            TAX BILL CITY-STATE (OTHER COMMENT)

OWNTYPE_DESC DESCRIPTION OF OWNERTYPE

OBJECTID             unique system generated id number

 

 

 

LEGDAT

 

This table downloaded from BFS Real Property Assessment on a weekly schedule.

Legal Data  Table.  This table contains the unit number and total legal area  for

the Parcel.

 

Link field to GIS parcel layer: TMK

Common column between BFS tables: parid.

 

LEGDAT field descriptions:

 

PARID            unique parcel id (tmk and hpr/cpr number; 12 digits)

TMK                tmk number (8 digit)

SUFFIX           hpr/cpr number (4 digit)

SEQ                 sequential number

UNITNO          unit number of taxed entity

TAXYR            tax year

ACRES             Total official acre area of tax lot

SQFT                Total official square feet area of tax lot

LEGAL1           Legal description line 1

LEGAL2           Legal description line 2

LEGAL3           Legal description line 3

OBJECTID       unique system generated id number

 

 

PARDAT

 

This table downloaded from BFS Real Property Assessment on a weekly schedule.  It contains

Real property descriptive data.

 

Link field to GIS parcel layer: TMK

Common column between BFS tables: parid.

 

 

 

PARDAT Field Descriptions

 

PARID              UNIQUE PARCEL ID (TMK AND HPR/CPR NUMBER; 12 DIGITS)

TMK                 TMK NUMBER (8 DIGIT)

SUFFIX            HPR/CPR NUMBER (4 DIGIT)

SEQ                  SEQUENTIAL NUMBER 1 ... N NUMBER OF PARID RECORDS

TAXYR            TAX YEAR

CUR                 'Y' = CURRENT TAX YEAR           

JUR                    JURISDICTION

CALCACRES   TOTAL ACRES CALCULATED FROM LAND TABLE

PARKPROX      PARKING PROXIMITY

PARKQUANIT PARKING QUANTITY

PARKTYPE      PARKING TYPE

RESTRICT1      RESTRICTION 1

RESTRICT3      RESTRICTION 3

ZONING            ZONING

MUNI                MUNI

UNITDESC       UNIT DESCRIPTION

UNITNO           UNIT NUMBER

NBHD               NEIGHBORHOOD NUMBER

CLASS              CLASSIFICATION

LUC                   LAND USE CODE

LUCMULT        MULTIPLE LAND USE FLAG

LIVUNIT            NUMBER OF LIVING UNITS

LANDISC           LANDISC FRAME NUMBER

OBJECTID         unique system generated id number

 

2007 PITT (Real Property Tax Rates) (rates per$1000 net- land/bld)

 

1 = Improved Residential  

2 = Apartment               

3 = Commercial            

4 = Industrial            

5 = Agriculture           

6 = Conservation          

7 = Hotel and Resort      

8 = Unimproved Residential

9= Vacant