GIS Data Catalog
Decode Table for Values in item PRESENTUSE in table PARCEL_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 KCA102_PRESENTUSE_PARCEL.
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 - 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.
Layer information
| Layer Name | kca102_presentuse_parcel |
| Subject Category | Property |
| Title | Decode Table for Values in item PRESENTUSE in table PARCEL_EXTR |
| Feature Count | 128 |
| Feature Type | Table |
| Next Update | None planned |
| Spatial reference | None |
| Control ID | 1483 |
| Place Keywords | Pacific NW, Washington State, King County, WA |
| Theme Keywords | Parcel, Property, Taxpayer |
| Supplemental Information |
http://www5.kingcounty.gov/sdc/Metadata.aspx?Layer=parcel_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 Domain0 101 - Retail Store 104 - Retail(Big Box) 105 - Retail(Discount) 106 - Office Building 11 - Apartment 118 - Office Park 122 - Medical/Dental Office 126 - Condominium(Office) 130 - Farm 137 - Greenhse/Nrsry/Hort Srvc 138 - Mining/Quarry/Ore Processing 140 - Bowling Alley 141 - Campground 142 - Driving Range 143 - Golf Course 145 - Health Club 146 - Marina 147 - Movie Theater 149 - Park, Public(Zoo/Arbor) 150 - Park, Private(Amuse Ctr) 152 - Ski Area 153 - Skating Rink(Ice/Roller) 156 - Sport Facility 157 - Art Gallery/Museum/Soc Srvc 159 - Parking(Assoc) 16 - Apartment(Mixed Use) 160 - Auditorium//Assembly Bldg 161 - Auto Showroom And Lot 162 - Bank 163 - Car Wash 165 - Church/Welfare/Relig Srvc 166 - Club 167 - Conv Store Without Gas 168 - Conv Store With Gas 17 - Apartment(Co-Op) 171 - Restaurant(Fast Food) 172 - Governmental Service 173 - Hospital 179 - Mortuary/Cemetery/Crematory 18 - Apartment(Subsidized) 180 - Parking(Commercial Lot) 182 - Parking(Garage) 183 - Restaurant/Lounge 184 - School(Public) 185 - School(Private) 186 - Service Station 188 - Tavern/Lounge 189 - Post Office/Post Service 190 - Vet/Animal Control Srvc 191 - Grocery Store 193 - Daycare Center 194 - Mini Lube 195 - Warehouse 2 - Single Family(Res Use/Zone) 20 - Condominium(Residential) 202 - High Tech/High Flex 210 - Industrial Park 216 - Service Building 223 - Industrial(Gen Purpose) 245 - Industrial(Heavy) 246 - Industrial(Lignt) 247 - Air Terminal And Hangers 25 - Condominium(Mixed Use) 252 - Mini Warehouse 261 - Terminal(Rail) 262 - Terminal(Marine/Comm Fish) 263 - Terminal(Grain) 264 - Terminal(Auto/Bus/Other) 266 - Utility, Public 267 - Utility, Private(Radio/T.V.) 271 - Terminal(Marine) 272 - Historic Prop(Residence) 273 - Historic Prop(Office) 274 - Historic Prop(Retail) 275 - Historic Prop(Eat/Drink) 276 - Historic Prop(Loft/Warehse) 277 - Historic Prop(Park/Billbrd) 278 - Historic Prop(Transient Fac) 279 - Historic Prop(Rec/Entertain) 280 - Historic Prop(Misc) 29 - Townhouse Plat 299 - Historic Prop(Vacant Land) 3 - Duplex 300 - Vacant(Single-Family) 301 - Vacant(Multi-Family) 309 - Vacant(Commercial) 316 - Vacant(Industrial) 323 - Reforestation(Rcw 84.28) 324 - Forest Land(Class-Rcw 84.33) 325 - Forest Land(Desig-Rcw 84.33) 326 - Open Space(Curr Use-Rcw 84.34) 327 - Open Space(Agric-Rcw 84.34) 328 - Open Space Tmbr Land/Greenbelt 330 - Easement 331 - Reserve/Wilderness Area 332 - Right Of Way/Utility, Road 333 - River/Creek/Stream 334 - Tideland, 1St Class 335 - Tideland, 2Nd Class 336 - Transferable Dev Rights 337 - Water Body, Fresh 339 - Shell Structure 340 - Bed and Breakfast 341 - Rooming House 342 - Fraternity/Sorority House 38 - Mobile Home Park 4 - Triplex 48 - Condominium(M Home Pk) 49 - Retirement Facility 5 - 4-Plex 51 - Hotel/Motel 55 - Rehabilitation Center 56 - Residence Hall/Dorm 57 - Group Home 58 - Resort/Lodge/Retreat 59 - Nursing Home 6 - Single Family(C/I Zone) 60 - Shopping Ctr(Nghbrhood) 61 - Shopping Ctr(Community) 62 - Shopping Ctr(Regional) 63 - Shopping Ctr(Maj Retail) 64 - Shopping Ctr(Specialty) 7 - Houseboat 8 - Mobile Home 9 - Single Family(C/I Use) 96 - Retail(Line/Strip) |
|
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 DomainRetail Store - 101 Retail(Big Box) - 104 Retail(Discount) - 105 Office Building - 106 Apartment - 11 Office Park - 118 Medical/Dental Office - 122 Condominium(Office) - 126 Farm - 130 Greenhse/Nrsry/Hort Srvc - 137 Mining/Quarry/Ore Processing - 138 Bowling Alley - 140 Campground - 141 Driving Range - 142 Golf Course - 143 Health Club - 145 Marina - 146 Movie Theater - 147 Park, Public(Zoo/Arbor) - 149 Park, Private(Amuse Ctr) - 150 Ski Area - 152 Skating Rink(Ice/Roller) - 153 Sport Facility - 156 Art Gallery/Museum/Soc Srvc - 157 Parking(Assoc) - 159 Apartment(Mixed Use) - 16 Auditorium//Assembly Bldg - 160 Auto Showroom and Lot - 161 Bank - 162 Car Wash - 163 Church/Welfare/Relig Srvc - 165 Club - 166 Conv Store without Gas - 167 Conv Store with Gas - 168 Apartment(Co-op) - 17 Restaurant(Fast Food) - 171 Governmental Service - 172 Hospital - 173 Mortuary/Cemetery/Crematory - 179 Apartment(Subsidized) - 18 Parking(Commercial Lot) - 180 Parking(Garage) - 182 Restaurant/Lounge - 183 School(Public) - 184 School(Private) - 185 Service Station - 186 Tavern/Lounge - 188 Post Office/Post Service - 189 Vet/Animal Control Srvc - 190 Grocery Store - 191 Daycare Center - 193 Mini Lube - 194 Warehouse - 195 Single Family(Res Use/Zone) - 2 Condominium(Residential) - 20 High Tech/High Flex - 202 Industrial Park - 210 Service Building - 216 Industrial(Gen Purpose) - 223 Industrial(Heavy) - 245 Industrial(Lignt) - 246 Air Terminal and Hangers - 247 Condominium(Mixed Use) - 25 Mini Warehouse - 252 Terminal(Rail) - 261 Terminal(Marine/Comm Fish) - 262 Terminal(Grain) - 263 Terminal(Auto/Bus/Other) - 264 Utility, Public - 266 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 Plat - 29 Historic Prop(Vacant Land) - 299 Duplex - 3 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/Greenbelt - 328 Easement - 330 Reserve/Wilderness Area - 331 Right of Way/Utility, Road - 332 River/Creek/Stream - 333 Tideland, 1st Class - 334 Tideland, 2nd Class - 335 Transferable Dev Rights - 336 Water Body, Fresh - 337 Shell Structure - 339 Bed and Breakfast - 340 Rooming House - 341 Fraternity/Sorority House - 342 Mobile Home Park - 38 Triplex - 4 Condominium(M Home Pk) - 48 Retirement Facility - 49 4-Plex - 5 Hotel/Motel - 51 Rehabilitation Center - 55 Residence Hall/Dorm - 56 Group Home - 57 Resort/Lodge/Retreat - 58 Nursing Home - 59 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 Houseboat - 7 Mobile Home - 8 Single Family(C/I Use) - 9 Retail(Line/Strip) - 96 |
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 KCA102_PRESENTUSE_PARCEL.
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 - 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.
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). |