Decode Table for Values in item SECTIONUSE in table COMMBLDGSECTION_EXTR

Metadata also available as - [Outline]

Frequently anticipated questions:


What does this data set describe?

Title:
Decode Table for Values in item SECTIONUSE in table COMMBLDGSECTION_EXTR
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.
Supplemental_Information:
<http://www5.kingcounty.gov/sdc/Metadata.aspx?Layer=commbldgsection_extr>
  1. How should this data set be cited?

    County, King, 20120801, Decode Table for Values in item SECTIONUSE in table COMMBLDGSECTION_EXTR: King County, King County, WA.

    Online Links:

    • None

  2. What geographic area does the data set cover?

  3. What does it look like?

    Not Applicable (Not Applicable)
    Not Applicable

  4. Does the data set describe conditions during a particular time period?

    Beginning_Date: 01-Jan-2006
    Ending_Date: 11-Dec-2012
    Currentness_Reference: publication date

  5. What is the general form of this data set?

    Geospatial_Data_Presentation_Form: tabular digital data

  6. How does the data set represent geographic features?

    1. How are geographic features stored in the data set?

    2. What coordinate system is used to represent geographic features?

  7. How does the data set describe geographic features?

    PLIBRARY.PROPERTY.xxxx224220
    Table (Source: King County Assessments)

    OBJECTID
    System-generated primary key (Source: Esri)

    Unique integer value

    LUTYPE
    Integer value describing related records in LOOKUP_EXTR table (Source: King County Assessments)

    Integer value

    CODE_NUMBER
    Value that relates to value in business table item (Source: King County Assessments)

    ValueDefinition
    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 used (Source: King County Assessments)

    Empty string

    DESCRIPTION
    Decode meaning of CODE_NUMBER value (Source: King County Assessments)

    ValueDefinition
    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

    Entity_and_Attribute_Overview:
    No additional attributes are stored beyond LUTYPE (the relationship to the master LOOKUP_EXTR table), the CODE_NUMBER (or CODE_TEXT), and the DESCRIPTION.
    Entity_and_Attribute_Detail_Citation: King County Assessments


Who produced the data set?

  1. Who are the originators of the data set? (may include formal authors, digital compilers, and editors)

  2. Who also contributed to the data set?

    King County Assessments

  3. To whom should users address questions about the data?

    King County GIS Center
    Attn: Frank Whitman
    GIS Analyst
    201 S Jackson St, Suite 706
    Seattle, WA 98104
    US

    206-263-3780 (voice)


Why was the data set created?

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.


How was the data set created?

  1. From what previous works were the data drawn?

  2. How were the data generated, processed, and modified?

    Date: 01-Oct-2012 (process 1 of 1)
    A cross reference table exists in the enterprise geodatabase (KCA_LUTYPE_XREF) to act as a control table for all KCA domains. This table maintains the relationship between source KCA tables and their corresponding posted KCGIS tables. The table was constructed by combining KCA documentation for all tables, including field names, format, and any lookup types used by fields in that table. The lookup type field relates to code and description record sets contained in the original KCA Lookup table (Lookup). This lookup type field is maintained going forward and continues to serves as key to code/description record sets within two newly created KCGIS lookup tables. These two lookup tables are created within the enterprise geodatabase to hold all code/description record sets contained in the original KCA Lookup table plus those taken from table description text documents. First, all KCA Lookup record sets with numeric codes are used to create the numeric lookup table (KCA_LOOKUP_NUMBER). This lookup table includes a LUCODE field of type Integer. Second, all character code-description record sets, taken from documentation, are used to create a text lookup table (KCA_LOOKUP_TEXT). This text lookup table includes a LUCODE field of type Text. Both lookup tables contain the original KCA lookup type field (LUTYPE). All KCA domain tables are generated via python script (CreateDomainTables.py). The cross reference table (KCA_LUTYPE_XREF) is used to identify all fields within KCA tables that utilize a domain. An individual domain table is created for each unique table-field combination in the cross reference table, if a valid KCA lookup type exists for the field. The lookup type (LUTYPE) value in the cross reference table is then used to query all of the code/description record sets from either the numeric lookup table (KCA_LOOKUP_NUMBER) or text lookup table (KCA_LOOKUP_TEXT) depending on the field format. The selected records are then written to that specific domain table. A template table is used to pre-define the attribute schema for all domain tables to ensure uniformity. All KCA domain tables follow the same naming convention: KCA(LUTYPE#)_(Field Name)_(TableName).

  3. What similar or related data should the user be aware of?


How reliable are the data; what problems remain in the data set?

  1. How well have the observations been checked?

    Based on data dictionary provided by King County Assessments. Values in table have not been validated against a frequency of the values in the business table item supported by this coded-value-domain.

  2. How accurate are the geographic locations?

  3. How accurate are the heights or depths?

  4. Where are the gaps in the data? What is missing?

    For a given KCA business table, all items with associated decode values in the master LOOKUP_EXTR are decoded. However, since not all KCA business tables are maintained in the enterprise spatial data warehouse, not all possible decode relationships are present.

  5. How consistent are the relationships among the observations, including topology?

    Each CODE_NUMBER or CODE_TEXT value has one and only one DESCRIPTION value. If relate item in table is numeric, then CODE_NUMBER is populated and CODE_TEXT is blank. Likewise, if relate item in table is string, then CODE_TEXT is populated and CODE_NUMBER will be blank. This allows the schema of all table to be identical.


How can someone get a copy of the data set?

Are there legal restrictions on access or use of the data?

Access_Constraints: None
Use_Constraints:
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.

  1. Who distributes the data set? (Distributor 1 of 1)

    KCGIS Center
    Attn: Cheryl Wilder
    Data Sales Coordinator
    201 S Jackson St, Suite 700
    Seattle, WA 98104
    US

    206-263-5220 (voice)

  2. What's the catalog number I need to order this data set?

    /plibrary2/property/shapes/table/kca118_sectionuse_commbldgsection.dbf

  3. What legal disclaimers am I supposed to read?

    King County disclaims any warranty of use of any digital product or data beyond that for which it was designed.

  4. How can I download or order the data?


Who wrote the metadata?

Dates:
Last modified: 27-Dec-2012
Metadata author:
King County GIS Center
Attn: Mike Leathers
GIS Data Coordinator
201 S Jackson St, Suite 706
Seattle, WA 98104
US

206-263-4867 (voice)
firstname.lastname@kingcounty.gov

Metadata standard:
FGDC Content Standard for Digital Geospatial Metadata (FGDC-STD-001-1998)


Generated by mp version 2.9.12 on Sat Apr 06 04:13:03 2019