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 UNITQUALITY in table CONDOUNIT_EXTR

Description | Contacts | Attribute Information | Constraints

Data layer thumbnail image

Description

Layer name: KCA151_UNITQUALITY_CONDOUNIT
Subject category: property
Title: Decode Table for Values in item UNITQUALITY in table CONDOUNIT_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 - Unit Quality (unitquality) in business table Condominium Unit (CONDOUNIT_EXTR). There are 4 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 KCA151_UNITQUALITY_CONDOUNIT.
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=condounit_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
1Fair
2Average
3Good
4Excellent
_CODE_TEXT_CODE_NUMBER is relate value, so CODE TEXT is not usedEmpty string
_DESCRIPTION_Decode meaning of CODE_NUMBER value
Fair1
Average2
Good3
Excellent4


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.