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

+ 47.59909 N
- 122.33136 W

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

 

Decode Table for Values in item SALEWARNING in table RPSALE_EXTR

Description | Contacts | Attribute Information | Constraints

Data layer thumbnail image

Description

Layer name: KCA7_SALEWARNING_RPSALE
Subject category: property
Title: Decode Table for Values in item SALEWARNING 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 - Sale Warning (salewarning) in business table Real Property Sale (RPSALE_EXTR). There are 62 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 KCA7_SALEWARNING_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: http://www5.kingcounty.gov/sdc/Metadata.aspx?Layer=rpsale_extr

Contacts

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

Attribute Information

ItemDescriptionDomain
_LUTYPE_Integer value describing related records in LOOKUP_EXTR tableInteger value
_CODE_NUMBER_Value that relates to value in business table item
1Personal Property Included
10Tear Down
11Corporate Affiliates
12Estate Administrator, Guardian, Or Executor
13Bankruptcy - Receiver Or Trustee
14Sheriff / Tax Sale
15No Market Exposure
16Government Agency
17Non-Profit Organization
18Quit Claim Deed
19Seller'S Or Purchaser'S Assignment
21031 Trade
20Correction Deed
21Trade
22Partial Interest (1/3, 1/2, Etc.)
23Forced Sale
24Easement Or Right-Of-Way
25Fulfillment Of Contract Deed
26Imp. Characteristics Changed Since Sale
27Timber And Forest Land
28New Plat (With Less Than 20% Sold)
29Segregation And/Or Merger
3Contract Or Cash Sale
30Historic Property
31Exempt From Excise Tax
32$1,000 Sale Or Less
33Lease Or Lease-Hold
34Change Of Use
35Open Space Designation Continued/Ok'D After Sale
36Plottage
37Securing Of Debt
38Divorce
39Assumption Of Mortgage W/No Addl Consideration Pd
4Presale
40Relocation - Sale To Service
41Relocation - Sale By Service
42Development Rights To Cnty,Cty,Or Prvt Developer
43Development Rights Parcel To Prvt Sector
44Tenant
45Multi-Parcel Sale
46Non-Representative Sale
47Non-Conventional Heating System
48Condo With Garage, Moorage, Or Storage
49Mobile Home
5Full Sales Price Not Reported
50Condo Wholesale
51Related Party, Friend, Or Neighbor
52Statement To Dor
53Residual Sales
54Affordable Housing Sales
55Shell
56Builder Or Developer Sales
57Selling Or Buying Costs Affecting Sale Price
58Preliminary Shortplat Approval
59Bulk Portfolio Sale
6Refund
60Short Sale
61Financial Institution Resale
62Auction Sale
7Questionable Per Sales Identification
8Questionable Per Appraisal
9Questionable Per Mainframe System (Obsolete Code)
_CODE_TEXT_CODE_NUMBER is relate value, so CODE TEXT is not usedEmpty string
_DESCRIPTION_Decode meaning of CODE_NUMBER value
PERSONAL PROPERTY INCLUDED1
TEAR DOWN10
CORPORATE AFFILIATES11
ESTATE ADMINISTRATOR, GUARDIAN, OR EXECUTOR12
BANKRUPTCY - RECEIVER OR TRUSTEE13
SHERIFF / TAX SALE14
NO MARKET EXPOSURE15
GOVERNMENT AGENCY16
NON-PROFIT ORGANIZATION17
QUIT CLAIM DEED18
SELLER'S OR PURCHASER'S ASSIGNMENT19
1031 TRADE2
CORRECTION DEED20
TRADE21
PARTIAL INTEREST (1/3, 1/2, Etc.)22
FORCED SALE23
EASEMENT OR RIGHT-OF-WAY24
FULFILLMENT OF CONTRACT DEED25
IMP. CHARACTERISTICS CHANGED SINCE SALE26
TIMBER AND FOREST LAND27
NEW PLAT (WITH LESS THAN 20% SOLD)28
SEGREGATION AND/OR MERGER29
CONTRACT OR CASH SALE3
HISTORIC PROPERTY30
EXEMPT FROM EXCISE TAX31
$1,000 SALE OR LESS32
LEASE OR LEASE-HOLD33
CHANGE OF USE34
OPEN SPACE DESIGNATION CONTINUED/OK'D AFTER SALE35
PLOTTAGE36
SECURING OF DEBT37
DIVORCE38
ASSUMPTION OF MORTGAGE W/NO ADDL CONSIDERATION PD39
PRESALE4
RELOCATION - SALE TO SERVICE40
RELOCATION - SALE BY SERVICE41
DEVELOPMENT RIGHTS TO CNTY,CTY,OR PRVT DEVELOPER42
DEVELOPMENT RIGHTS PARCEL TO PRVT SECTOR43
TENANT44
MULTI-PARCEL SALE45
NON-REPRESENTATIVE SALE46
NON-CONVENTIONAL HEATING SYSTEM47
CONDO WITH GARAGE, MOORAGE, OR STORAGE48
MOBILE HOME49
FULL SALES PRICE NOT REPORTED5
CONDO WHOLESALE50
RELATED PARTY, FRIEND, OR NEIGHBOR51
STATEMENT TO DOR52
RESIDUAL SALES53
AFFORDABLE HOUSING SALES54
SHELL55
BUILDER OR DEVELOPER SALES56
SELLING OR BUYING COSTS AFFECTING SALE PRICE57
PRELIMINARY SHORTPLAT APPROVAL58
BULK PORTFOLIO SALE59
REFUND6
SHORT SALE60
FINANCIAL INSTITUTION RESALE61
AUCTION SALE62
QUESTIONABLE PER SALES IDENTIFICATION7
QUESTIONABLE PER APPRAISAL8
QUESTIONABLE PER MAINFRAME SYSTEM (Obsolete code)9


Constraints

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.