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 PROPERTYTYPE in table RPSALE_EXTR

Description | Contacts | Attribute Information | Constraints

Data layer thumbnail image


Subject category: property
Title: Decode Table for Values in item PROPERTYTYPE 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 Type (propertytype) in business table Real Property Sale (RPSALE_EXTR). There are 84 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 KCA1_PROPERTYTYPE_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
1Land Only
10Land With New Building
11Household, Single Family Units
12Multiple Family Residence (Residential, 2-4 Units)
13Multiple Family Residence (Residential, 5+ Units)
14Residential Condominiums
15Mobile Home Parks Or Courts
17Institutional Lodging
18All Other Residential Not Elsewhere Coded
19Vacation And Cabin
2Land With New Building
21Food And Kindred Products
22Textile Mill Products
23Apparel and Other Finished Products
24Lumber And Wood Products (Except Furniture)
25Furniture And Fixtures
26Paper And Allied Products
27Printing And Publishing
29Petroleum Refining And Related Industries
3Land With Prev Used Bldg
30Rubber And Miscellaneous Plastic Products
31Leather And Leather Products
32Stone, Clay And Glass Products
33Primary Metal Industries
34Fabricated Metal Products
35Prof. Scientific, Controlling Instr; Optical Goods
39Miscellaneous Manufacturing
4Land With Mobile Home
41Railroad/Transit Transportation
42Motor Vehicle Transportation
43Aircraft Transportation
44Marine Craft Transportation
45Highway And Street Right Of Way
46Automobile Parking
49Other Transp., Com., and Util. Not Classified
5Timber Only
50Condominiums - Other Than Residential Condominiums
51Wholesale Trade
52Retail Trade-Bldg Materials, Hardware, Farm Equip
53Retail Trade - General Merchandise
54Retail Trade - Food
55Retail Trade-Autom., Marine Craft, Aircraft
56Retail Trade - Apparel And Accessories
57Retail Trade-Furniture, Home Furnishings, Equip.
58Retail Trade-Eating and Drinking
59Tenant Occupied, Commercial Properties
6Building Only
61Finance, Insurance, And Real Estate Services
62Personal Services
63Business Services
64Repair Services
65Professional Services (Medical, Dental, Etc.)
66Contract Construction Services
67Governmental Services
68Educational Services
69Miscellaneous Services
71Cultural Activities And Nature Exhibitions
72Public Assembly
74Recreational Activities (Gold Courses, Etc.)
75Resorts And Group Camps
79Other Cultural, Entertainment, And Recreational
80Water Or Mineral Rights
81Agriculture (Not Classified Under Current Use Law)
82Agriculture Related Activities
83Agr Classified Under Current Use Chapter 84.34 Rcw
84Fishing Activities And Related Services
85Mining Activities And Related Services
86Standing Timber (Separate From Land)
88Forest Land Designated Under Chapter 84.33 Rcw
89Other Resource Production
9Land With Mobile Home
91Undeveloped Land (Land Only)
92Noncommercial Forest
93Water Areas
94Open Space Land Classified Under Chapter 84.34 Rcw
95Timberland Classified Under Chapter 84.34 Rcw
96Improvements On Leased Land
99Other Undeveloped Land
_CODE_TEXT_CODE_NUMBER is relate value, so CODE TEXT is not usedEmpty string
_DESCRIPTION_Decode meaning of CODE_NUMBER value
Land with new building10
Household, single family units11
Multiple family residence (Residential, 2-4 units)12
Multiple family residence (Residential, 5+ units)13
Residential condominiums14
Mobile home parks or courts15
Institutional lodging17
All other residential not elsewhere coded18
Vacation and cabin19
Food and kindred products21
Textile mill products22
Apparel and other finished products23
Lumber and wood products (except furniture)24
Furniture and fixtures25
Paper and allied products26
Printing and publishing27
Petroleum refining and related industries29
Rubber and miscellaneous plastic products30
Leather and leather products31
Stone, clay and glass products32
Primary metal industries33
Fabricated metal products34
Prof. scientific, controlling instr; optical goods35
Miscellaneous manufacturing39
Railroad/transit transportation41
Motor vehicle transportation42
Aircraft transportation43
Marine craft transportation44
Highway and street right of way45
Automobile parking46
Other transp., com., and util. not classified49
Condominiums - other than residential condominiums50
Wholesale trade51
Retail trade-bldg materials, hardware, farm equip52
Retail trade - general merchandise53
Retail trade - food54
Retail trade-autom., marine craft, aircraft55
Retail trade - apparel and accessories56
Retail trade-furniture, home furnishings, equip.57
Retail trade-eating and drinking58
Tenant occupied, commercial properties59
Finance, insurance, and real estate services61
Personal services62
Business services63
Repair services64
Professional services (medical, dental, etc.)65
Contract construction services66
Governmental services67
Educational services68
Miscellaneous services69
Cultural activities and nature exhibitions71
Public assembly72
Recreational activities (gold courses, etc.)74
Resorts and group camps75
Other cultural, entertainment, and recreational79
Water or Mineral rights80
Agriculture (not classified under current use law)81
Agriculture related activities82
Agr classified under current use chapter 84.34 RCW83
Fishing activities and related services84
Mining activities and related services85
Standing Timber (separate from land)86
Forest land designated under chapter 84.33 RCW88
Other resource production89
Land with mobile home9
Undeveloped land (land only)91
Noncommercial forest92
Water areas93
Open space land classified under chapter 84.34 RCW94
Timberland classified under chapter 84.34 RCW95
Improvements on leased land96
Other undeveloped land99


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.