Decode Table for Values in item PROPERTYCLASS in table RPSALE

Identification_Information:

Citation:

Citation_Information:

Originator: King County
Publication_Date: 20120801
Title:

Decode Table for Values in item PROPERTYCLASS in table RPSALE_EXTR

Edition: One
Geospatial_Data_Presentation_Form: tabular digital data
Publication_Information:

Publication_Place: King County, WA
Publisher: King County

Online_Linkage: None

Description:

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.

Supplemental_Information: http://www5.kingcounty.gov/sdc/Metadata.aspx?Layer=rpsale_extr

Time_Period_of_Content:

Time_Period_Information:

Range_of_Dates/Times:

Beginning_Date: 20060101
Ending_Date: 20121211

Currentness_Reference: publication date

Status:

Progress: Complete
Maintenance_and_Update_Frequency: None planned

Keywords:

Theme:

Theme_Keyword_Thesaurus: Not applicable
Theme_Keyword: parcel
Theme_Keyword: property
Theme_Keyword: taxpayer

Place:

Place_Keyword_Thesaurus: Not applicable
Place_Keyword: Pacific NW
Place_Keyword: Washington state
Place_Keyword: King County
Place_Keyword: WA

Access_Constraints: None
Use_Constraints:

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.

Point_of_Contact:

Contact_Information:

Contact_Organization_Primary:

Contact_Organization: King County GIS Center
Contact_Person: Frank Whitman

Contact_Position: GIS Analyst
Contact_Address:

Address_Type: mailing and physical
Address: 201 S Jackson St, Suite 706
City: Seattle
State_or_Province: WA
Postal_Code: 98104
Country: US

Contact_Voice_Telephone: 206-263-3780

Browse_Graphic:

Browse_Graphic_File_Name: Not Applicable
Browse_Graphic_File_Description: Not Applicable
Browse_Graphic_File_Type: Not Applicable

Data_Set_Credit: King County Assessments
Native_Data_Set_Environment:

Microsoft Windows Server 2008 R2 Version 6.1 (Build 7601) Service Pack 1; ESRI ArcGIS 10.0.0.2414

Data_Quality_Information:

Attribute_Accuracy:

Attribute_Accuracy_Report:

Based on data dictionary provided by King County Assessments. Values in table have not been validated against a frequency of the values in the business table item supported by this coded-value-domain.

Logical_Consistency_Report:

Each CODE_NUMBER or CODE_TEXT value has one and only one DESCRIPTION value. If relate item in table is numeric, then CODE_NUMBER is populated and CODE_TEXT is blank. Likewise, if relate item in table is string, then CODE_TEXT is populated and CODE_NUMBER will be blank. This allows the schema of all table to be identical.

Completeness_Report:

For a given KCA business table, all items with associated decode values in the master LOOKUP_EXTR are decoded. However, since not all KCA business tables are maintained in the enterprise spatial data warehouse, not all possible decode relationships are present.

Lineage:

Process_Step:

Process_Description:

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).

Process_Date: 20121001

Entity_and_Attribute_Information:

Detailed_Description:

Entity_Type:

Entity_Type_Label: PLIBRARY.PROPERTY.xxxx224220
Entity_Type_Definition: Table
Entity_Type_Definition_Source: King County Assessments

Attribute:

Attribute_Label: OBJECTID
Attribute_Definition: System-generated primary key
Attribute_Definition_Source: Esri
Attribute_Domain_Values:

Unrepresentable_Domain: Unique integer value

Attribute:

Attribute_Label: LUTYPE
Attribute_Definition: Integer value describing related records in LOOKUP_EXTR table
Attribute_Definition_Source: King County Assessments
Attribute_Domain_Values:

Unrepresentable_Domain: Integer value

Attribute:

Attribute_Label: CODE_NUMBER
Attribute_Definition: Value that relates to value in business table item
Attribute_Definition_Source: King County Assessments
Attribute_Domain_Values:

Enumerated_Domain:

Enumerated_Domain_Value: 1
Enumerated_Domain_Value_Definition: C/I-Land Only
Enumerated_Domain_Value_Definition_Source: King County Assessments

Enumerated_Domain:

Enumerated_Domain_Value: 2
Enumerated_Domain_Value_Definition: C/I-Imp Prop; No Condo/Mh
Enumerated_Domain_Value_Definition_Source: King County Assessments

Enumerated_Domain:

Enumerated_Domain_Value: 3
Enumerated_Domain_Value_Definition: C/I-Condominium
Enumerated_Domain_Value_Definition_Source: King County Assessments

Enumerated_Domain:

Enumerated_Domain_Value: 4
Enumerated_Domain_Value_Definition: C/I-"Air Rights" Only
Enumerated_Domain_Value_Definition_Source: King County Assessments

Enumerated_Domain:

Enumerated_Domain_Value: 5
Enumerated_Domain_Value_Definition: C/I-Imp Prop Excl "Air Rights"
Enumerated_Domain_Value_Definition_Source: King County Assessments

Enumerated_Domain:

Enumerated_Domain_Value: 6
Enumerated_Domain_Value_Definition: C/I-Land Or Bldg; No Split
Enumerated_Domain_Value_Definition_Source: King County Assessments

Enumerated_Domain:

Enumerated_Domain_Value: 7
Enumerated_Domain_Value_Definition: Res-Land Only
Enumerated_Domain_Value_Definition_Source: King County Assessments

Enumerated_Domain:

Enumerated_Domain_Value: 8
Enumerated_Domain_Value_Definition: Res-Improved Property
Enumerated_Domain_Value_Definition_Source: King County Assessments

Enumerated_Domain:

Enumerated_Domain_Value: 9
Enumerated_Domain_Value_Definition: Res Or C/I-Mobile Home
Enumerated_Domain_Value_Definition_Source: King County Assessments

Attribute:

Attribute_Label: CODE_TEXT
Attribute_Definition: CODE_NUMBER is relate value, so CODE TEXT is not used
Attribute_Definition_Source: King County Assessments
Attribute_Domain_Values:

Unrepresentable_Domain: Empty string

Attribute:

Attribute_Label: DESCRIPTION
Attribute_Definition: Decode meaning of CODE_NUMBER value
Attribute_Definition_Source: King County Assessments
Attribute_Domain_Values:

Enumerated_Domain:

Enumerated_Domain_Value: C/I-Land only
Enumerated_Domain_Value_Definition: 1
Enumerated_Domain_Value_Definition_Source: King County Assessments

Enumerated_Domain:

Enumerated_Domain_Value: C/I-Imp prop; no condo/MH
Enumerated_Domain_Value_Definition: 2
Enumerated_Domain_Value_Definition_Source: King County Assessments

Enumerated_Domain:

Enumerated_Domain_Value: C/I-Condominium
Enumerated_Domain_Value_Definition: 3
Enumerated_Domain_Value_Definition_Source: King County Assessments

Enumerated_Domain:

Enumerated_Domain_Value: C/I-"Air rights" only
Enumerated_Domain_Value_Definition: 4
Enumerated_Domain_Value_Definition_Source: King County Assessments

Enumerated_Domain:

Enumerated_Domain_Value: C/I-Imp prop excl "air rights"
Enumerated_Domain_Value_Definition: 5
Enumerated_Domain_Value_Definition_Source: King County Assessments

Enumerated_Domain:

Enumerated_Domain_Value: C/I-Land or bldg; no split
Enumerated_Domain_Value_Definition: 6
Enumerated_Domain_Value_Definition_Source: King County Assessments

Enumerated_Domain:

Enumerated_Domain_Value: Res-Land only
Enumerated_Domain_Value_Definition: 7
Enumerated_Domain_Value_Definition_Source: King County Assessments

Enumerated_Domain:

Enumerated_Domain_Value: Res-Improved property
Enumerated_Domain_Value_Definition: 8
Enumerated_Domain_Value_Definition_Source: King County Assessments

Enumerated_Domain:

Enumerated_Domain_Value: Res or C/I-Mobile Home
Enumerated_Domain_Value_Definition: 9
Enumerated_Domain_Value_Definition_Source: King County Assessments

Overview_Description:

Entity_and_Attribute_Overview:

No additional attributes are stored beyond LUTYPE (the relationship to the master LOOKUP_EXTR table), the CODE_NUMBER (or CODE_TEXT), and the DESCRIPTION.

Entity_and_Attribute_Detail_Citation: King County Assessments

Decode Table for Values in item PROPERTYCLASS in table RPSALE_EXTR

Metadata: