King County GIS Center
King Street Center
201 S. Jackson St.
Suite 706
Seattle, WA 98104

+ 47.59909 N
- 122.33136 W

+ 47°  35' 56.72"
- 122° 19' 52.90"


Decode Table for Values in item PROPERTYCLASS in table RPSALE_EXTR

Description | Contacts | Attribute Information | Constraints

Data layer thumbnail image


Subject category: property
Title: Decode Table for Values in item PROPERTYCLASS in table RPSALE_EXTR
Feature Count:
Feature Type: Table
Abstract: One of 80 decode (lookup) tables within the Property Schema. This table also exists as a Coded Value Domain within the SDE Geodatabase. This table decodes the values for the item - Property Class (propertyclass) in business table Real Property Sale (RPSALE_EXTR). There are 9 unique values in this decode table, enumerated in the detailed attribute section below. Metadata for the business table can be accessed via the link in the Supplemental Information section.
Purpose: This decode table can be used as a standard lookup table joining on the business table item it supports. Depending whether the item supported is text or integer, the relate to the lookup table will be made on the item CODE_TEXT or CODE_NUMBER, respectively. The value in the DESCRIPTION field provides the meaning of the code. This table can also be converted to a geodatabase coded-value-domain (CVD), as done in the King County Spatial Data Warehouse, to present the decoded item descriptions dynamically without additional joins. In the Spatial Data Warehouse the object exists as both a table and coded-value-domain called KCA4_PROPERTYCLASS_RPSALE.
Status: Complete
Updated: None planned
Time period of content: (single date,as YYYYMMDD)::
Time period of content: (date range, as YYYYMMDD):: 20060101 - 20121211
Spatial reference: WA State Plane North
FGDC Documentation: Classic or FAQ
Open Data Availability: Not Available
Place Keywords: Pacific NW, Washington state, King County, WA,
Theme Keywords: parcel, property, taxpayer,
Lineage: Available
Supplemental Information:


Maintained by:
King County GIS Center
Primary: Frank Whitman, GIS Analyst, 206-263-3780
(How to e-mail a County contact)
Secondary: KCGIS Center; This mailbox is monitored during business hours.

Attribute Information

_LUTYPE_Integer value describing related records in LOOKUP_EXTR tableInteger value
_CODE_NUMBER_Value that relates to value in business table item
1C/I-Land Only
2C/I-Imp Prop; No Condo/Mh
4C/I-"Air Rights" Only
5C/I-Imp Prop Excl "Air Rights"
6C/I-Land Or Bldg; No Split
7Res-Land Only
8Res-Improved Property
9Res Or C/I-Mobile Home
_CODE_TEXT_CODE_NUMBER is relate value, so CODE TEXT is not usedEmpty string
_DESCRIPTION_Decode meaning of CODE_NUMBER value
C/I-Land only1
C/I-Imp prop; no condo/MH2
C/I-"Air rights" only4
C/I-Imp prop excl "air rights"5
C/I-Land or bldg; no split6
Res-Land only7
Res-Improved property8
Res or C/I-Mobile Home9


Access: None

Use: King County data are made available with the understanding that they shall be used exclusively by the obtainer or his/her authorized agents. Digital products may not be reproduced or redistributed in any form or by any means without the express written authorization of King County. Users are encouraged to appropriately evaluate and display the Margin of Error when analyzing and mapping this data.