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 PRESENTUSE in table PARCEL_EXTR

Description | Contacts | Attribute Information | Constraints

Data layer thumbnail image

Description

Layer name: KCA102_PRESENTUSE_PARCEL
Subject category: property
Title: Decode Table for Values in item PRESENTUSE in table PARCEL_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 - Present Use (PRESENTUSE) in business table Parcel (PARCEL_EXTR). There are 127 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 KCA102_PRESENTUSE_PARCEL.
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=parcel_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
0
101Retail Store
104Retail(Big Box)
105Retail(Discount)
106Office Building
11Apartment
118Office Park
122Medical/Dental Office
126Condominium(Office)
130Farm
137Greenhse/Nrsry/Hort Srvc
138Mining/Quarry/Ore Processing
140Bowling Alley
141Campground
142Driving Range
143Golf Course
145Health Club
146Marina
147Movie Theater
149Park, Public(Zoo/Arbor)
150Park, Private(Amuse Ctr)
152Ski Area
153Skating Rink(Ice/Roller)
156Sport Facility
157Art Gallery/Museum/Soc Srvc
159Parking(Assoc)
16Apartment(Mixed Use)
160Auditorium//Assembly Bldg
161Auto Showroom And Lot
162Bank
163Car Wash
165Church/Welfare/Relig Srvc
166Club
167Conv Store Without Gas
168Conv Store With Gas
17Apartment(Co-Op)
171Restaurant(Fast Food)
172Governmental Service
173Hospital
179Mortuary/Cemetery/Crematory
18Apartment(Subsidized)
180Parking(Commercial Lot)
182Parking(Garage)
183Restaurant/Lounge
184School(Public)
185School(Private)
186Service Station
188Tavern/Lounge
189Post Office/Post Service
190Vet/Animal Control Srvc
191Grocery Store
193Daycare Center
194Mini Lube
195Warehouse
2Single Family(Res Use/Zone)
20Condominium(Residential)
202High Tech/High Flex
210Industrial Park
216Service Building
223Industrial(Gen Purpose)
245Industrial(Heavy)
246Industrial(Lignt)
247Air Terminal And Hangers
25Condominium(Mixed Use)
252Mini Warehouse
261Terminal(Rail)
262Terminal(Marine/Comm Fish)
263Terminal(Grain)
264Terminal(Auto/Bus/Other)
266Utility, Public
267Utility, Private(Radio/T.V.)
271Terminal(Marine)
272Historic Prop(Residence)
273Historic Prop(Office)
274Historic Prop(Retail)
275Historic Prop(Eat/Drink)
276Historic Prop(Loft/Warehse)
277Historic Prop(Park/Billbrd)
278Historic Prop(Transient Fac)
279Historic Prop(Rec/Entertain)
280Historic Prop(Misc)
29Townhouse Plat
299Historic Prop(Vacant Land)
3Duplex
300Vacant(Single-Family)
301Vacant(Multi-Family)
309Vacant(Commercial)
316Vacant(Industrial)
323Reforestation(Rcw 84.28)
324Forest Land(Class-Rcw 84.33)
325Forest Land(Desig-Rcw 84.33)
326Open Space(Curr Use-Rcw 84.34)
327Open Space(Agric-Rcw 84.34)
328Open Space Tmbr Land/Greenbelt
330Easement
331Reserve/Wilderness Area
332Right Of Way/Utility, Road
333River/Creek/Stream
334Tideland, 1St Class
335Tideland, 2Nd Class
336Transferable Dev Rights
337Water Body, Fresh
339Shell Structure
340Bed and Breakfast
341Rooming House
342Fraternity/Sorority House
38Mobile Home Park
4Triplex
48Condominium(M Home Pk)
49Retirement Facility
54-Plex
51Hotel/Motel
55Rehabilitation Center
56Residence Hall/Dorm
57Group Home
58Resort/Lodge/Retreat
59Nursing Home
6Single Family(C/I Zone)
60Shopping Ctr(Nghbrhood)
61Shopping Ctr(Community)
62Shopping Ctr(Regional)
63Shopping Ctr(Maj Retail)
64Shopping Ctr(Specialty)
7Houseboat
8Mobile Home
9Single Family(C/I Use)
96Retail(Line/Strip)
_CODE_TEXT_CODE_NUMBER is relate value, so CODE TEXT is not usedEmpty string
_DESCRIPTION_Decode meaning of CODE_NUMBER value
0
Retail Store101
Retail(Big Box)104
Retail(Discount)105
Office Building106
Apartment11
Office Park118
Medical/Dental Office122
Condominium(Office)126
Farm130
Greenhse/Nrsry/Hort Srvc137
Mining/Quarry/Ore Processing138
Bowling Alley140
Campground141
Driving Range142
Golf Course143
Health Club145
Marina146
Movie Theater147
Park, Public(Zoo/Arbor)149
Park, Private(Amuse Ctr)150
Ski Area152
Skating Rink(Ice/Roller)153
Sport Facility156
Art Gallery/Museum/Soc Srvc157
Parking(Assoc)159
Apartment(Mixed Use)16
Auditorium//Assembly Bldg160
Auto Showroom and Lot161
Bank162
Car Wash163
Church/Welfare/Relig Srvc165
Club166
Conv Store without Gas167
Conv Store with Gas168
Apartment(Co-op)17
Restaurant(Fast Food)171
Governmental Service172
Hospital173
Mortuary/Cemetery/Crematory179
Apartment(Subsidized)18
Parking(Commercial Lot)180
Parking(Garage)182
Restaurant/Lounge183
School(Public)184
School(Private)185
Service Station186
Tavern/Lounge188
Post Office/Post Service189
Vet/Animal Control Srvc190
Grocery Store191
Daycare Center193
Mini Lube194
Warehouse195
Single Family(Res Use/Zone)2
Condominium(Residential)20
High Tech/High Flex202
Industrial Park210
Service Building216
Industrial(Gen Purpose)223
Industrial(Heavy)245
Industrial(Lignt)246
Air Terminal and Hangers247
Condominium(Mixed Use)25
Mini Warehouse252
Terminal(Rail)261
Terminal(Marine/Comm Fish)262
Terminal(Grain)263
Terminal(Auto/Bus/Other)264
Utility, Public266
Utility, Private(Radio/T.V.)267
Terminal(Marine)271
Historic Prop(Residence)272
Historic Prop(Office)273
Historic Prop(Retail)274
Historic Prop(Eat/Drink)275
Historic Prop(Loft/Warehse)276
Historic Prop(Park/Billbrd)277
Historic Prop(Transient Fac)278
Historic Prop(Rec/Entertain)279
Historic Prop(Misc)280
Townhouse Plat29
Historic Prop(Vacant Land)299
Duplex3
Vacant(Single-family)300
Vacant(Multi-family)301
Vacant(Commercial)309
Vacant(Industrial)316
Reforestation(RCW 84.28)323
Forest Land(Class-RCW 84.33)324
Forest Land(Desig-RCW 84.33)325
Open Space(Curr Use-RCW 84.34)326
Open Space(Agric-RCW 84.34)327
Open Space Tmbr Land/Greenbelt328
Easement330
Reserve/Wilderness Area331
Right of Way/Utility, Road332
River/Creek/Stream333
Tideland, 1st Class334
Tideland, 2nd Class335
Transferable Dev Rights336
Water Body, Fresh337
Shell Structure339
Bed and Breakfast340
Rooming House341
Fraternity/Sorority House342
Mobile Home Park38
Triplex4
Condominium(M Home Pk)48
Retirement Facility49
4-Plex5
Hotel/Motel51
Rehabilitation Center55
Residence Hall/Dorm56
Group Home57
Resort/Lodge/Retreat58
Nursing Home59
Single Family(C/I Zone)6
Shopping Ctr(Nghbrhood)60
Shopping Ctr(Community)61
Shopping Ctr(Regional)62
Shopping Ctr(Maj Retail)63
Shopping Ctr(Specialty)64
Houseboat7
Mobile Home8
Single Family(C/I Use)9
Retail(Line/Strip)96


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.