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 SECTIONUSE in table COMMBLDGSECTION_EXTR

Description | Contacts | Attribute Information | Constraints

Data layer thumbnail image

Description

Layer name: KCA118_SECTIONUSE_COMMBLDGSECTION
Subject category: property
Title: Decode Table for Values in item SECTIONUSE in table COMMBLDGSECTION_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 - Section Use (sectionuse) in business table Commercial Building Section (COMMBLDGSECTION_EXTR). There are 151 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 KCA118_SECTIONUSE_COMMBLDGSECTION.
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=commbldgsection_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
381Veterinary Hospital (381)
384Barber Shop (384)
386Mini-Warehouse (386)
387Transit Warehouse (387)
388Underground Parking Structure (388)
391Material Storage Building (391)
392Industrial Engineering Building (392)
405Skating Rink (405)
406Storage Warehouse (406)
407Warehouse, Distribution (407)
409T-Hangar (409)
410Automotive Center (410)
412Neighborhood Shopping Center (412)
413Community Shopping Center (413)
414Regional Shopping Center (414)
416Tennis Club, Indoor (416)
417Handball-Racquetball Club (417)
418Health Club (418)
419Convenience Market (419)
423Mini-Lube Garage (423)
424Group Care Home (424)
426Day Care Center (426)
427Fire Station (Volunteer) (427)
428Horse Arena (428)
431Outpatient Surgical Center (431)
432Restroom Building (432)
491Government Community Service Building (491)
494Industrial Light Manufacturing (494)
495Industrial Heavy Manufacturing (495)
496Laboratories (496)
497Computer Center (497)
498Broadcast Facilities (498)
525Mini Warehouse, Hi-Rise (525)
527Municipal Service Garage (527)
528Garage, Service Repair (528)
529Snack Bar (529)
530Cafeteria (530)
531Mini-Mart Convenience Store (531)
532Florist Shop (532)
533Warehouse Food Store (533)
534Warehouse Showroom Store (534)
551Rooming House (551)
573Arcade (573)
574Visitor Center (574)
581Post Office - Main(581)
582Post Office - Branch(582)
583Post Office - Mail Processing(583)
701Basement, Finished (701)
702Basement, Semifinished (702)
703Basement, Unfinished (703)
704Basement, Display (704)
705Basement, Office (705)
706Basement, Parking (706)
707Basement, Resident Living (707)
708Basement, Storage (708)
709Basement, Retail (709)
810Warehouse Office (810)
820Open Office (820)
830Mixed Use Retail (830)
840Mixed Use Office (840)
841Hotel, Full Service (841)
842Hotel, Suite (842)
843Motel, Full Service (843)
844Motel, Suite (844)
845Condo, Office (845)
846Condo, Retail (846)
847Mixed Use-Office Condo (847)
848Mixed Use-Retail Condo (848)
849Condo, Storage (849)
850Condo, Parking Structure (850)
851Underground Condo Parking (851)
852Condo Hotel, Full Service (852)
853Condo Hotel, Limited Service (853)
860Line Retail (860)
300Apartment (300)
301Armory (301)
302Auditorium (302)
303Automobile Showroom (303)
304Bank (304)
305Barn (305)
306Bowling Alley (306)
308Church With Sunday School (308)
309Church (309)
310City Club (310)
311Clubhouse (311)
313Convalescent Hospital (313)
314Country Club (314)
315Creamery (315)
316Dairy (316)
317Dairy Sales Building (317)
318Department Store (318)
319Discount Store (319)
320Dispensary (320)
321Dormitory (321)
322Fire Station (Staffed) (322)
323Fraternal Building (323)
324Fraternity House (324)
326Garage, Storage (326)
327Government Building (327)
328Hangar, Storage (328)
329Hangar, Maintenance and Office (329)
330Home For The Elderly (330)
331Hospital (331)
332Hotel, Limited (332)
335Jail-Correctional Facility (335)
336Laundromat (336)
337Library, Public (337)
338Loft (338)
339Lumber Storage Shed, Horizontal (339)
340Market (340)
341Medical Office (341)
342Mortuary (342)
343Motel, Limited (343)
344Office Building (344)
345Parking Structure (345)
348Residence (348)
349Fast Food Restaurant (349)
350Restaurant, Table Service (350)
352Multiple Residence (Low Rise) (352)
353Retail Store (353)
365Elementary School (Entire) (365)
366Junior High School (Entire) (366)
377College (Entire) (377)
378Stable (378)
379Theater, Live Stage (379)
380Theater, Cinema (380)
441Cocktail Lounge (441)
442Bar/Tavern (442)
444Dental Office/Clinic (444)
446Supermarket (446)
447Cold Storage Facilities (447)
451Multiple Residence (Senior Citizen) (451)
453Industrial Flex Buildings (453)
455Auto Dealership, Complete (455)
458Warehouse Discount Store (458)
459Mixed Retail W/Res. Units (459)
468Shed, Material Storage (468)
470Equipment (Shop) Building (470)
471Light Commercial Utility Building (471)
472Equipment Shed (472)
475Poultry House-Floor Operation (475)
477Farm Utility Building (477)
481Museum (481)
482Convention Center (482)
483Fitness Center (483)
484High School (Entire) (484)
485Natatorium (485)
486Field Houses (486)
487Vocational Schools (487)
489Jail - Police Station (489)
490Kennels (490)
_CODE_TEXT_CODE_NUMBER is relate value, so CODE TEXT is not usedEmpty string
_DESCRIPTION_Decode meaning of CODE_NUMBER value
VETERINARY HOSPITAL (381)381
BARBER SHOP (384)384
MINI-WAREHOUSE (386)386
TRANSIT WAREHOUSE (387)387
UNDERGROUND PARKING STRUCTURE (388)388
MATERIAL STORAGE BUILDING (391)391
INDUSTRIAL ENGINEERING BUILDING (392)392
SKATING RINK (405)405
STORAGE WAREHOUSE (406)406
WAREHOUSE, DISTRIBUTION (407)407
T-HANGAR (409)409
AUTOMOTIVE CENTER (410)410
NEIGHBORHOOD SHOPPING CENTER (412)412
COMMUNITY SHOPPING CENTER (413)413
REGIONAL SHOPPING CENTER (414)414
TENNIS CLUB, INDOOR (416)416
HANDBALL-RACQUETBALL CLUB (417)417
HEALTH CLUB (418)418
CONVENIENCE MARKET (419)419
MINI-LUBE GARAGE (423)423
GROUP CARE HOME (424)424
DAY CARE CENTER (426)426
FIRE STATION (VOLUNTEER) (427)427
HORSE ARENA (428)428
OUTPATIENT SURGICAL CENTER (431)431
RESTROOM BUILDING (432)432
GOVERNMENT COMMUNITY SERVICE BUILDING (491)491
INDUSTRIAL LIGHT MANUFACTURING (494)494
INDUSTRIAL HEAVY MANUFACTURING (495)495
LABORATORIES (496)496
COMPUTER CENTER (497)497
BROADCAST FACILITIES (498)498
MINI WAREHOUSE, HI-RISE (525)525
MUNICIPAL SERVICE GARAGE (527)527
GARAGE, SERVICE REPAIR (528)528
SNACK BAR (529)529
CAFETERIA (530)530
MINI-MART CONVENIENCE STORE (531)531
FLORIST SHOP (532)532
WAREHOUSE FOOD STORE (533)533
WAREHOUSE SHOWROOM STORE (534)534
ROOMING HOUSE (551)551
ARCADE (573)573
VISITOR CENTER (574)574
POST OFFICE - MAIN(581)581
POST OFFICE - BRANCH(582)582
POST OFFICE - MAIL PROCESSING(583)583
BASEMENT, FINISHED (701)701
BASEMENT, SEMIFINISHED (702)702
BASEMENT, UNFINISHED (703)703
BASEMENT, DISPLAY (704)704
BASEMENT, OFFICE (705)705
BASEMENT, PARKING (706)706
BASEMENT, RESIDENT LIVING (707)707
BASEMENT, STORAGE (708)708
BASEMENT, RETAIL (709)709
WAREHOUSE OFFICE (810)810
OPEN OFFICE (820)820
MIXED USE RETAIL (830)830
MIXED USE OFFICE (840)840
HOTEL, FULL SERVICE (841)841
HOTEL, SUITE (842)842
MOTEL, FULL SERVICE (843)843
MOTEL, SUITE (844)844
CONDO, OFFICE (845)845
CONDO, RETAIL (846)846
MIXED USE-OFFICE CONDO (847)847
MIXED USE-RETAIL CONDO (848)848
CONDO, STORAGE (849)849
CONDO, PARKING STRUCTURE (850)850
UNDERGROUND CONDO PARKING (851)851
CONDO HOTEL, FULL SERVICE (852)852
CONDO HOTEL, LIMITED SERVICE (853)853
LINE RETAIL (860)860
APARTMENT (300)300
ARMORY (301)301
AUDITORIUM (302)302
AUTOMOBILE SHOWROOM (303)303
BANK (304)304
BARN (305)305
BOWLING ALLEY (306)306
CHURCH WITH SUNDAY SCHOOL (308)308
CHURCH (309)309
CITY CLUB (310)310
CLUBHOUSE (311)311
CONVALESCENT HOSPITAL (313)313
COUNTRY CLUB (314)314
CREAMERY (315)315
DAIRY (316)316
DAIRY SALES BUILDING (317)317
DEPARTMENT STORE (318)318
DISCOUNT STORE (319)319
DISPENSARY (320)320
DORMITORY (321)321
FIRE STATION (STAFFED) (322)322
FRATERNAL BUILDING (323)323
FRATERNITY HOUSE (324)324
GARAGE, STORAGE (326)326
GOVERNMENT BUILDING (327)327
HANGAR, STORAGE (328)328
HANGAR, MAINTENANCE and OFFICE (329)329
HOME FOR THE ELDERLY (330)330
HOSPITAL (331)331
HOTEL, LIMITED (332)332
JAIL-CORRECTIONAL FACILITY (335)335
LAUNDROMAT (336)336
LIBRARY, PUBLIC (337)337
LOFT (338)338
LUMBER STORAGE SHED, HORIZONTAL (339)339
MARKET (340)340
MEDICAL OFFICE (341)341
MORTUARY (342)342
MOTEL, LIMITED (343)343
OFFICE BUILDING (344)344
PARKING STRUCTURE (345)345
Residence (348)348
FAST FOOD RESTAURANT (349)349
RESTAURANT, TABLE SERVICE (350)350
MULTIPLE RESIDENCE (LOW RISE) (352)352
RETAIL STORE (353)353
ELEMENTARY SCHOOL (ENTIRE) (365)365
JUNIOR HIGH SCHOOL (ENTIRE) (366)366
COLLEGE (ENTIRE) (377)377
STABLE (378)378
THEATER, LIVE STAGE (379)379
THEATER, CINEMA (380)380
COCKTAIL LOUNGE (441)441
BAR/TAVERN (442)442
DENTAL OFFICE/CLINIC (444)444
SUPERMARKET (446)446
COLD STORAGE FACILITIES (447)447
MULTIPLE RESIDENCE (SENIOR CITIZEN) (451)451
INDUSTRIAL FLEX BUILDINGS (453)453
AUTO DEALERSHIP, COMPLETE (455)455
WAREHOUSE DISCOUNT STORE (458)458
MIXED RETAIL W/RES. UNITS (459)459
SHED, MATERIAL STORAGE (468)468
EQUIPMENT (SHOP) BUILDING (470)470
LIGHT COMMERCIAL UTILITY BUILDING (471)471
EQUIPMENT SHED (472)472
POULTRY HOUSE-FLOOR OPERATION (475)475
FARM UTILITY BUILDING (477)477
MUSEUM (481)481
CONVENTION CENTER (482)482
FITNESS CENTER (483)483
HIGH SCHOOL (ENTIRE) (484)484
NATATORIUM (485)485
FIELD HOUSES (486)486
VOCATIONAL SCHOOLS (487)487
JAIL - POLICE STATION (489)489
KENNELS (490)490


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.