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