GIS Data Catalog
Decode Table for Values in item SALEWARNING in table RPSALE_EXTR
Learn how to get an ArcGIS Online account 🗺
Use this Data
|
Links
How to use in ArcGIS Pro |
|
| Sharing Status | Not Public |
Summary
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.
Description
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.
Layer information
| Layer Name | kca7_salewarning_rpsale |
| Subject Category | Property |
| Title | Decode Table for Values in item SALEWARNING in table RPSALE_EXTR |
| Feature Count | 62 |
| Feature Type | Table |
| Next Update | None planned |
| Spatial reference | None |
| Control ID | 1534 |
| Place Keywords | Pacific NW, Washington State, King County, WA |
| Theme Keywords | Parcel, Property, Taxpayer |
| Supplemental Information |
http://www5.kingcounty.gov/sdc/Metadata.aspx?Layer=rpsale_extr |
Attribute information
|
OBJECTID
From Esri |
Description
System-generated primary key DomainUnique integer value |
|
LUTYPE
From King County Assessments |
Description
Integer value describing related records in LOOKUP_EXTR table DomainInteger value |
|
CODE_NUMBER
From King County Assessments |
Description
Value that relates to value in business table item Domain1 - Personal Property Included 10 - Tear Down 11 - Corporate Affiliates 12 - Estate Administrator, Guardian, Or Executor 13 - Bankruptcy - Receiver Or Trustee 14 - Sheriff / Tax Sale 15 - No Market Exposure 16 - Government Agency 17 - Non-Profit Organization 18 - Quit Claim Deed 19 - Seller'S Or Purchaser'S Assignment 2 - 1031 Trade 20 - Correction Deed 21 - Trade 22 - Partial Interest (1/3, 1/2, Etc.) 23 - Forced Sale 24 - Easement Or Right-Of-Way 25 - Fulfillment Of Contract Deed 26 - Imp. Characteristics Changed Since Sale 27 - Timber And Forest Land 28 - New Plat (With Less Than 20% Sold) 29 - Segregation And/Or Merger 3 - Contract Or Cash Sale 30 - Historic Property 31 - Exempt From Excise Tax 32 - $1,000 Sale Or Less 33 - Lease Or Lease-Hold 34 - Change Of Use 35 - Open Space Designation Continued/Ok'D After Sale 36 - Plottage 37 - Securing Of Debt 38 - Divorce 39 - Assumption Of Mortgage W/No Addl Consideration Pd 4 - Presale 40 - Relocation - Sale To Service 41 - Relocation - Sale By Service 42 - Development Rights To Cnty,Cty,Or Prvt Developer 43 - Development Rights Parcel To Prvt Sector 44 - Tenant 45 - Multi-Parcel Sale 46 - Non-Representative Sale 47 - Non-Conventional Heating System 48 - Condo With Garage, Moorage, Or Storage 49 - Mobile Home 5 - Full Sales Price Not Reported 50 - Condo Wholesale 51 - Related Party, Friend, Or Neighbor 52 - Statement To Dor 53 - Residual Sales 54 - Affordable Housing Sales 55 - Shell 56 - Builder Or Developer Sales 57 - Selling Or Buying Costs Affecting Sale Price 58 - Preliminary Shortplat Approval 59 - Bulk Portfolio Sale 6 - Refund 60 - Short Sale 61 - Financial Institution Resale 62 - Auction Sale 7 - Questionable Per Sales Identification 8 - Questionable Per Appraisal 9 - Questionable Per Mainframe System (Obsolete Code) |
|
CODE_TEXT
From King County Assessments |
Description
CODE_NUMBER is relate value, so CODE TEXT is not used DomainEmpty string |
|
DESCRIPTION
From King County Assessments |
Description
Decode meaning of CODE_NUMBER value DomainPERSONAL PROPERTY INCLUDED - 1 TEAR DOWN - 10 CORPORATE AFFILIATES - 11 ESTATE ADMINISTRATOR, GUARDIAN, OR EXECUTOR - 12 BANKRUPTCY - RECEIVER OR TRUSTEE - 13 SHERIFF / TAX SALE - 14 NO MARKET EXPOSURE - 15 GOVERNMENT AGENCY - 16 NON-PROFIT ORGANIZATION - 17 QUIT CLAIM DEED - 18 SELLER'S OR PURCHASER'S ASSIGNMENT - 19 1031 TRADE - 2 CORRECTION DEED - 20 TRADE - 21 PARTIAL INTEREST (1/3, 1/2, Etc.) - 22 FORCED SALE - 23 EASEMENT OR RIGHT-OF-WAY - 24 FULFILLMENT OF CONTRACT DEED - 25 IMP. CHARACTERISTICS CHANGED SINCE SALE - 26 TIMBER AND FOREST LAND - 27 NEW PLAT (WITH LESS THAN 20% SOLD) - 28 SEGREGATION AND/OR MERGER - 29 CONTRACT OR CASH SALE - 3 HISTORIC PROPERTY - 30 EXEMPT FROM EXCISE TAX - 31 $1,000 SALE OR LESS - 32 LEASE OR LEASE-HOLD - 33 CHANGE OF USE - 34 OPEN SPACE DESIGNATION CONTINUED/OK'D AFTER SALE - 35 PLOTTAGE - 36 SECURING OF DEBT - 37 DIVORCE - 38 ASSUMPTION OF MORTGAGE W/NO ADDL CONSIDERATION PD - 39 PRESALE - 4 RELOCATION - SALE TO SERVICE - 40 RELOCATION - SALE BY SERVICE - 41 DEVELOPMENT RIGHTS TO CNTY,CTY,OR PRVT DEVELOPER - 42 DEVELOPMENT RIGHTS PARCEL TO PRVT SECTOR - 43 TENANT - 44 MULTI-PARCEL SALE - 45 NON-REPRESENTATIVE SALE - 46 NON-CONVENTIONAL HEATING SYSTEM - 47 CONDO WITH GARAGE, MOORAGE, OR STORAGE - 48 MOBILE HOME - 49 FULL SALES PRICE NOT REPORTED - 5 CONDO WHOLESALE - 50 RELATED PARTY, FRIEND, OR NEIGHBOR - 51 STATEMENT TO DOR - 52 RESIDUAL SALES - 53 AFFORDABLE HOUSING SALES - 54 SHELL - 55 BUILDER OR DEVELOPER SALES - 56 SELLING OR BUYING COSTS AFFECTING SALE PRICE - 57 PRELIMINARY SHORTPLAT APPROVAL - 58 BULK PORTFOLIO SALE - 59 REFUND - 6 SHORT SALE - 60 FINANCIAL INSTITUTION RESALE - 61 AUCTION SALE - 62 QUESTIONABLE PER SALES IDENTIFICATION - 7 QUESTIONABLE PER APPRAISAL - 8 QUESTIONABLE PER MAINFRAME SYSTEM (Obsolete code) - 9 |
Contact information
| Maintained by | KCGIS Center |
| Primary |
KCGIS Center
giscenter@kingcounty.gov |
Terms of Use
| License | Terms of use and copyright |
Use this Data
|
Links
How to use in ArcGIS Pro |
|
| Sharing Status | Not Public |
Summary
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.
Description
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.
Contact information
| Maintained by | KCGIS Center |
| Primary |
KCGIS Center
giscenter@kingcounty.gov |
Terms of use and copyright
| License | Terms of use and copyright |
Change history
| 10/1/2012 |
A cross reference table exists in the enterprise geodatabase (KCA_LUTYPE_XREF) to act as a control table for all KCA domains. This table maintains the relationship between source KCA tables and their corresponding posted KCGIS tables. The table was constructed by combining KCA documentation for all tables, including field names, format, and any lookup types used by fields in that table. The lookup type field relates to code and description record sets contained in the original KCA Lookup table (Lookup). This lookup type field is maintained going forward and continues to serves as key to code/description record sets within two newly created KCGIS lookup tables. These two lookup tables are created within the enterprise geodatabase to hold all code/description record sets contained in the original KCA Lookup table plus those taken from table description text documents. First, all KCA Lookup record sets with numeric codes are used to create the numeric lookup table (KCA_LOOKUP_NUMBER). This lookup table includes a LUCODE field of type Integer. Second, all character code-description record sets, taken from documentation, are used to create a text lookup table (KCA_LOOKUP_TEXT). This text lookup table includes a LUCODE field of type Text. Both lookup tables contain the original KCA lookup type field (LUTYPE). All KCA domain tables are generated via python script (CreateDomainTables.py). The cross reference table (KCA_LUTYPE_XREF) is used to identify all fields within KCA tables that utilize a domain. An individual domain table is created for each unique table-field combination in the cross reference table, if a valid KCA lookup type exists for the field. The lookup type (LUTYPE) value in the cross reference table is then used to query all of the code/description record sets from either the numeric lookup table (KCA_LOOKUP_NUMBER) or text lookup table (KCA_LOOKUP_TEXT) depending on the field format. The selected records are then written to that specific domain table. A template table is used to pre-define the attribute schema for all domain tables to ensure uniformity. All KCA domain tables follow the same naming convention: KCA(LUTYPE#)_(Field Name)_(TableName). |