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 (null in this table)

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 (see Land Classification Codes)

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 Owner Type Codes)

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 Owner Type Codes)

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 Owner Type Codes )

OWNTYPE2           OWNER TYPE2 CODE (SEE Owner Type Codes)

OWNTYPE3           OWNER TYPE3 CODE (SEE Owner Type Codes )

OWNTYPE4           OWNER TYPE4 CODE (SEE Owner Type Codes )

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                   COMBINED LAND USE CODE

LUCMULT        MULTIPLE LAND USE FLAG

LIVUNIT            NUMBER OF LIVING UNITS

LANDISC           LANDISC FRAME NUMBER

OBJECTID         unique system generated id number

 

Real Property Land Classification (PITT Codes)

 

Class 1             Non Homeowner

Class 3             Commercial

Class 4             Industrial

Class 5             Agricultural

Class 6             Preservation

Class 7             Hotel and Resort

Class 9             Public Service

Class 0             Vacant Agricultural

Class 10           Homeowner


Real Property Owner Type Codes

Value Description Short Description
1A Fee Owner OWNER
1A0 Multiclaimant OWNER
1A1 A/S On Fee OWNER
1A2 SUB-A/S on Fee OWNER
1A3 Lessee LESSEE
1A4 Sub-Lessee LESSEE
1A5 S-S-Lessee LESSEE
1A6 A/S on Lease LESSEE
1A7 SUB-A/S on Lease LESSEE
1A8 A/S on Sublease LESSEE
1A9 SUB-A/S on Sublease LESSEE
1B CONDO MASTER
1B1 A/S on SUB-Sublease LESSEE
1B2 S-A/S on S-Sublease LESSEE
1B3 A/S on SUB-SUB-Sublease LESSEE
1B4 SUB-A/S on S-S-Sublease LESSEE
2A1 S-S-A/S on Fee OWNER
2A2 S-S-S-A/S on fee OWNER
2A3 S-S-S-S-A/S on Fee OWNER
2A4 S-S-S-Lessee LESSEE
2A5 S-S-S-S-Lessee LESSEE
2A6 S-S-A/S on Lease LESSEE
2A7 S-S-S-A/S on Lease LESSEE
2A8 S-S-S-S-A/S on Lease LESSEE
2A9 S-S-A/S On Sublease LESSEE
2B1 S-S-S-A/S on Sublease LESSEE
2B2 S-S-S-S-A/S on Sublease LESSEE
2B3 S-S-A/S on S-Sublease LESSEE
2B4 S-S-S-A/S on S-Sublease LESSEE
2B5 S-S-S-S-A/S  on S-Sublease LESSEE
2B6 S-S-A/S on S-S-Sublease LESSEE
2B7 S-S-S-A/S on S-S-Sublease LESSEE
2B8 S-S-S-S-A/S on S-S-Sublease LESSEE
2B9 A/S on SUB-SUB-SUB-Sublease LESSEE
2C1 S-A/S on S-S-S-Sublease LESSEE
2C2 S-S-A/S on S-S-S-Sublease LESSEE
2C3 S-S-S-A/S on S-S-S-Sublease LESSEE
2C4 S-S-S-S-A/S on S-S-S-Sublease LESSEE
2C5 Federal Lease from Private LESSEE
2C6 Fed sublease from private LESSEE
2C7 Fed sub-sublease from private LESSEE
2C8 Government Sub-Sub-Sublease LESSEE
2C9 FOR EXEMPTION PURPOSE Do not include
2D0 ADDRESSEE NAME ADDRESSEE
2D1 Gov Lessee Non-taxable None Taxable
3JT Joint Tenancy Joint Tenancy
3LI Life Interest/Estate Life Interest/E
3RM Remainderman Remainderman
3TC Tenants in Common Tenants in Comm
3TE Tenants by the Entirety Tenants by Enti
3TS Tenants in Severalty Tenants in Seve
4B Tax Bill Tax Bill Only
4N Receive ASMT Notice Notice Only
4NL No Lien : Skip owner on DQ510HI No Lien
4X No Notice No Bill No Notice&Bill
A AGREEMENT OF SALE AGREEMENT
ADR Addressee Addressee
F FEE FEE
FOR Lien Holder Lien Holder
L LEASE LEASE
NULL ASMT Notice and Tax Bill Notice and Bill
O OTHER OTHER
UND UNDIVIDED INTEREST UND INTEREST
X FEDERAL LEASE FEDERAL LEASE



 

LUC field breaktown:

 

Example: U/06/00

The string of data in the Zoning field indicates 3 categories of data

 

The first  digit, a letter, is the State Land Use Conservation Zones designation:  

U = Urban A=Agriculture and C = Conservation (R = Rural, there is no Rural on Oahu)

 

 

The next 2 digits are the Zoning category:

 

ZONE (Zoning Codes)

these have not been checked for accuracy, please see the official zoning maps at DPP  

 

02 = R-20 Residential

 

03 = R-10 Residential

 

04 = R-7.5 Residential

 

06 = R-5 Residential

 

07 = R-3.5 Residential

 

11 = A-1 Apartment

 

12 = A-2 Apartment

 

13 = A-3 Apartment

 

16 = AMX-1 Low Density

 

17 = AMX-2 Medium Density

 

18 = AMX-3 High Density

 

21 = Resort

 

31 = B-1 Neighborhood Business

 

32 = B-2 Community Business

 

33 = BMX-3 Community

 

34 = BMX-4 Central

 

41 = I-1 Limited

 

42 = I-2 General

 

43 = I-3 Waterfront

 

46 = IMX-1 Industrial Mixed Use

 

51 = Ag-1 Restricted

 

52 = Ag-2 Restricted

 

56 = C Country

 

61 = P-1 Restricted

 

62 = P-2 General

 

63 = F-1 Military and Federal

 

81 = Public Precinct

 

82 = Apartment Precinct

 

85 = Resort Commercial

 

86 = Resort Hotel Precinct

 

87 = Public Use

 

88 = Waterfront/Industrial

 

89 = Marine

 

95 = Aloha Tower Project Area

 

96 = Kakaako Community Development District

 

99 = Unknown/Water

 

 

You may also see these codes included in the zoning code:

KA    STATE JURISDICTION: REFER TO

KC    HAWAII COMMUNITY DEVELOPMENT AUTHORITY

X1    APARTMENT MIXED USE SUBPRECINCT

X2    APARTMENT PRECINCT (WAIKIKI ONLY)

X5    RESORT COMMERCIAL PRECINCT (WAIKIKI ONLY)

X6    RESORT MIXED USE PRECINCT (WAIKIKI ONLY)

X7    PUBLIC PRECINCT (WAIKIKI & KAKAAKO)

X9    MARINE PRECINCT (KAKAAKO ONLY)

 

 go to top

 

The last 2 digits are the old Development Plan (DP) Designation but these are now obsolete (except in Central Oahu but they soon will be there also). We have migrated to the Sustainable Community Plan Maps (see http://www.honoluludpp.org/Planning and http://www.honoluludpp.org/planning/dpmap.pdf) instead of the Development Plan Designation Maps which were referenced by parcel.  The last 2 digits code should therefore be ignored and the above pdf maps referenced on the department website.

 

The old DP codes were as such:

 

00    res

11    lapt

12    mapt

13    hapt

20    rsot

30    comm

40    ind

50    agr

60    pres

70    pub

80    mil

90    p&r

99    map

 

go to top