GIS Data Catalog
Decode Table for Values in item PROPERTYTYPE in table RPSALE_EXTR
Learn how to get an ArcGIS Online account 🗺
Use this Data
|
Links
How to use in ArcGIS Pro |
|
| Sharing Status | Not Public |
Summary
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 KCA1_PROPERTYTYPE_RPSALE.
Description
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 - Property Type (propertytype) in business table Real Property Sale (RPSALE_EXTR).
There are 84 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.
Layer information
| Layer Name | kca1_propertytype_rpsale |
| Subject Category | Property |
| Title | Decode Table for Values in item PROPERTYTYPE in table RPSALE_EXTR |
| Feature Count | 84 |
| Feature Type | Table |
| Next Update | None planned |
| Spatial reference | None |
| Control ID | 1482 |
| Place Keywords | Pacific NW, Washington State, King County, WA |
| Theme Keywords | Parcel, Property, Taxpayer |
| Supplemental Information |
http://www5.kingcounty.gov/sdc/Metadata.aspx?Layer=rpsale_extr |
Attribute information
|
OBJECTID
From Esri |
Description
System-generated primary key DomainUnique integer value |
|
LUTYPE
From King County Assessments |
Description
Integer value describing related records in LOOKUP_EXTR table DomainInteger value |
|
CODE_NUMBER
From King County Assessments |
Description
Value that relates to value in business table item Domain1 - Land Only 10 - Land With New Building 11 - Household, Single Family Units 12 - Multiple Family Residence (Residential, 2-4 Units) 13 - Multiple Family Residence (Residential, 5+ Units) 14 - Residential Condominiums 15 - Mobile Home Parks Or Courts 16 - Hotels/Motels 17 - Institutional Lodging 18 - All Other Residential Not Elsewhere Coded 19 - Vacation And Cabin 2 - Land With New Building 21 - Food And Kindred Products 22 - Textile Mill Products 23 - Apparel and Other Finished Products 24 - Lumber And Wood Products (Except Furniture) 25 - Furniture And Fixtures 26 - Paper And Allied Products 27 - Printing And Publishing 28 - Chemicals 29 - Petroleum Refining And Related Industries 3 - Land With Prev Used Bldg 30 - Rubber And Miscellaneous Plastic Products 31 - Leather And Leather Products 32 - Stone, Clay And Glass Products 33 - Primary Metal Industries 34 - Fabricated Metal Products 35 - Prof. Scientific, Controlling Instr; Optical Goods 39 - Miscellaneous Manufacturing 4 - Land With Mobile Home 41 - Railroad/Transit Transportation 42 - Motor Vehicle Transportation 43 - Aircraft Transportation 44 - Marine Craft Transportation 45 - Highway And Street Right Of Way 46 - Automobile Parking 47 - Communication 48 - Utilities 49 - Other Transp., Com., and Util. Not Classified 5 - Timber Only 50 - Condominiums - Other Than Residential Condominiums 51 - Wholesale Trade 52 - Retail Trade-Bldg Materials, Hardware, Farm Equip 53 - Retail Trade - General Merchandise 54 - Retail Trade - Food 55 - Retail Trade-Autom., Marine Craft, Aircraft 56 - Retail Trade - Apparel And Accessories 57 - Retail Trade-Furniture, Home Furnishings, Equip. 58 - Retail Trade-Eating and Drinking 59 - Tenant Occupied, Commercial Properties 6 - Building Only 61 - Finance, Insurance, And Real Estate Services 62 - Personal Services 63 - Business Services 64 - Repair Services 65 - Professional Services (Medical, Dental, Etc.) 66 - Contract Construction Services 67 - Governmental Services 68 - Educational Services 69 - Miscellaneous Services 71 - Cultural Activities And Nature Exhibitions 72 - Public Assembly 73 - Amusements 74 - Recreational Activities (Gold Courses, Etc.) 75 - Resorts And Group Camps 76 - Parks 79 - Other Cultural, Entertainment, And Recreational 80 - Water Or Mineral Rights 81 - Agriculture (Not Classified Under Current Use Law) 82 - Agriculture Related Activities 83 - Agr Classified Under Current Use Chapter 84.34 Rcw 84 - Fishing Activities And Related Services 85 - Mining Activities And Related Services 86 - Standing Timber (Separate From Land) 88 - Forest Land Designated Under Chapter 84.33 Rcw 89 - Other Resource Production 9 - Land With Mobile Home 91 - Undeveloped Land (Land Only) 92 - Noncommercial Forest 93 - Water Areas 94 - Open Space Land Classified Under Chapter 84.34 Rcw 95 - Timberland Classified Under Chapter 84.34 Rcw 96 - Improvements On Leased Land 99 - Other Undeveloped Land |
|
CODE_TEXT
From King County Assessments |
Description
CODE_NUMBER is relate value, so CODE TEXT is not used DomainEmpty string |
|
DESCRIPTION
From King County Assessments |
Description
Decode meaning of CODE_NUMBER value DomainLAND ONLY - 1 Land with new building - 10 Household, single family units - 11 Multiple family residence (Residential, 2-4 units) - 12 Multiple family residence (Residential, 5+ units) - 13 Residential condominiums - 14 Mobile home parks or courts - 15 Hotels/motels - 16 Institutional lodging - 17 All other residential not elsewhere coded - 18 Vacation and cabin - 19 LAND WITH NEW BUILDING - 2 Food and kindred products - 21 Textile mill products - 22 Apparel and other finished products - 23 Lumber and wood products (except furniture) - 24 Furniture and fixtures - 25 Paper and allied products - 26 Printing and publishing - 27 Chemicals - 28 Petroleum refining and related industries - 29 LAND WITH PREV USED BLDG - 3 Rubber and miscellaneous plastic products - 30 Leather and leather products - 31 Stone, clay and glass products - 32 Primary metal industries - 33 Fabricated metal products - 34 Prof. scientific, controlling instr; optical goods - 35 Miscellaneous manufacturing - 39 LAND WITH MOBILE HOME - 4 Railroad/transit transportation - 41 Motor vehicle transportation - 42 Aircraft transportation - 43 Marine craft transportation - 44 Highway and street right of way - 45 Automobile parking - 46 Communication - 47 Utilities - 48 Other transp., com., and util. not classified - 49 TIMBER ONLY - 5 Condominiums - other than residential condominiums - 50 Wholesale trade - 51 Retail trade-bldg materials, hardware, farm equip - 52 Retail trade - general merchandise - 53 Retail trade - food - 54 Retail trade-autom., marine craft, aircraft - 55 Retail trade - apparel and accessories - 56 Retail trade-furniture, home furnishings, equip. - 57 Retail trade-eating and drinking - 58 Tenant occupied, commercial properties - 59 BUILDING ONLY - 6 Finance, insurance, and real estate services - 61 Personal services - 62 Business services - 63 Repair services - 64 Professional services (medical, dental, etc.) - 65 Contract construction services - 66 Governmental services - 67 Educational services - 68 Miscellaneous services - 69 Cultural activities and nature exhibitions - 71 Public assembly - 72 Amusements - 73 Recreational activities (gold courses, etc.) - 74 Resorts and group camps - 75 Parks - 76 Other cultural, entertainment, and recreational - 79 Water or Mineral rights - 80 Agriculture (not classified under current use law) - 81 Agriculture related activities - 82 Agr classified under current use chapter 84.34 RCW - 83 Fishing activities and related services - 84 Mining activities and related services - 85 Standing Timber (separate from land) - 86 Forest land designated under chapter 84.33 RCW - 88 Other resource production - 89 Land with mobile home - 9 Undeveloped land (land only) - 91 Noncommercial forest - 92 Water areas - 93 Open space land classified under chapter 84.34 RCW - 94 Timberland classified under chapter 84.34 RCW - 95 Improvements on leased land - 96 Other undeveloped land - 99 |
Contact information
| Maintained by | KCGIS Center |
| Primary |
KCGIS Center
giscenter@kingcounty.gov |
Terms of Use
| License | Terms of use and copyright |
Use this Data
|
Links
How to use in ArcGIS Pro |
|
| Sharing Status | Not Public |
Summary
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 KCA1_PROPERTYTYPE_RPSALE.
Description
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 - Property Type (propertytype) in business table Real Property Sale (RPSALE_EXTR).
There are 84 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.
Contact information
| Maintained by | KCGIS Center |
| Primary |
KCGIS Center
giscenter@kingcounty.gov |
Terms of use and copyright
| License | Terms of use and copyright |
Change history
| 10/1/2012 |
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). |