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

Description | Contacts | Attribute Information | Constraints

Data layer thumbnail image

Description

Layer name: KCA150_UNITTYPE_CONDOUNIT
Subject category: property
Title: Decode Table for Values in item UNITTYPE 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 Type (unittype) in business table Condominium Unit (CONDOUNIT_EXTR). There are 26 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 KCA150_UNITTYPE_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
1Flat
10Leased Land
11Development Rights
12Unassigned Parking
13Unassigned Storage
14Unassigned Moorage, Open
15Floating Home, Flat
16Mobile Home
17Marina
18Hotel
19Warehouse
2Townhouse
20Hangar
21Retail
22Office
23Other Commercial
24Moorage, Covered
25Unassigned Moorage, Covered
26Floating Home, Townhouse
3Penthouse,Flat
4Penthouse,Townhouse
5Parking
6Storage
7Dock
8Moorage, Open
9Land Only
_CODE_TEXT_CODE_NUMBER is relate value, so CODE TEXT is not usedEmpty string
_DESCRIPTION_Decode meaning of CODE_NUMBER value
Flat1
Leased Land10
Development Rights11
Unassigned Parking12
Unassigned Storage13
Unassigned Moorage, Open14
Floating Home, Flat15
Mobile Home16
Marina17
Hotel18
Warehouse19
Townhouse2
Hangar20
Retail21
Office22
Other Commercial23
Moorage, Covered24
Unassigned Moorage, Covered25
Floating Home, Townhouse26
Penthouse,Flat3
Penthouse,Townhouse4
Parking5
Storage6
Dock7
Moorage, Open8
Land Only9


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.