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 HEATINGSYSTEM in table COMMBLDG_EXTR

Description | Contacts | Attribute Information | Constraints

Data layer thumbnail image

Description

Layer name: KCA66_HEATINGSYSTEM_COMMBLDG
Subject category: property
Title: Decode Table for Values in item HEATINGSYSTEM in table COMMBLDG_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 - Heating System (heatingsystem) in business table Commercial Building (COMMBLDG_EXTR). There are 20 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 KCA66_HEATINGSYSTEM_COMMBLDG.
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=commbldg_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
1Electric
10Wall Furnace
11Package Unit
12Warmed And Cooled Air
13Hot and Chilled Water
14Heat Pump
15Floor Furnace
16Thru-Wall Heat Pump
17Complete Hvac
18Evaporative Cooling
19Refrigerated Cooling
2Electric Wall
20No Heat
3Forced Air Unit
4Hot Water
5Hot Water-Radiant
6Space Heaters
7Steam
8Steam Without Boiler
9Ventilation
_CODE_TEXT_CODE_NUMBER is relate value, so CODE TEXT is not usedEmpty string
_DESCRIPTION_Decode meaning of CODE_NUMBER value
ELECTRIC1
WALL FURNACE10
PACKAGE UNIT11
WARMED AND COOLED AIR12
HOT and CHILLED WATER13
HEAT PUMP14
FLOOR FURNACE15
THRU-WALL HEAT PUMP16
COMPLETE HVAC17
EVAPORATIVE COOLING18
REFRIGERATED COOLING19
ELECTRIC WALL2
NO HEAT20
FORCED AIR UNIT3
HOT WATER4
HOT WATER-RADIANT5
SPACE HEATERS6
STEAM7
STEAM WITHOUT BOILER8
VENTILATION9


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.