The University of Washington Geographic Information Service
at the School of Environmental and Forest Sciences
 

Thurston County Normalization: parcels.dbf Table

Field Name Field Description Common Field Common Field Description
ACOMBOID Unknown
ADDRESS1 Mostly street addresses and PO BOX numbers. Includes unit numbers (i.e. #106, STE 208, APT A102). Owner_Address_2 Mostly street addresses and PO BOX numbers. Includes unit numbers (i.e. #106, STE 208, APT A102).
ADDRESS2 Building names, street addresses, C/O names, ATTN: names. No consistency . Owner_Address_3 Building names, street addresses, C/O names, ATTN: names. No consistency .
ANNUAL_TAX Annual tax Tax_Information Annual tax
BLDG_VALUE Market value building Building_Value Market value building
CITY Owner_Address_City
COUNTRY Owner_Address_Country
CURR_USE Metadata states that it is "Address name" (?) Y/N Other_Reference_Info Metadata states that it is "Address name" (?) Y/N
EFF_YR_BUI Effective year built Building_Details Effective year built
EXEMPT_TY Exemption type, if any (Senior/Disabled, Housing Authority, Tribal Lands for Government Services, Less than $500 Market Value, Destroyed Property Abatement, Multi Family Urban Housing, Government Property, DoR Institutional, Historical Designation, Home Improvement) Exemption Exemption type, if any (Senior/Disabled, Housing Authority, Tribal Lands for Government Services, Less than $500 Market Value, Destroyed Property Abatement, Multi Family Urban Housing, Government Property, DoR Institutional, Historical Designation, Home Improvement)
GEOCODE Other_Reference_Info
INCORP Metadata states that it is "Address name" (?) -- more likely incorporated nor not Other_Reference_Info Metadata states that it is "Address name" (?) -- more likely incorporated nor not
INSPCT_CYC Inspection cycle Revaluation_Information Inspection cycle
IN_CARE_OF Secondary owner or mail recipient; First MI Last (i.e. WILLIAM P TURNER). Sometimes preceeded by C/O or ATTN, Also includes organizations, departments. Owner_Address_1 Secondary owner or mail recipient; First MI Last (i.e. WILLIAM P TURNER). Sometimes preceeded by C/O or ATTN, Also includes organizations, departments.
LAND_VALUE Market value land Land_Value Market value land
LEGAL_DESC Legal_Description
LOCAL_IND Blank or "Y" Unknown Blank or "Y"
MULT_PARCL Multipart_Info
OWNER_NAME Last, First MI & First MI (i.e. ZYSKI, DAN J & TERESA J). Owner_Name Last, First MI & First MI (i.e. ZYSKI, DAN J & TERESA J).
O_NEIGHBOR Neighborhood for appraisal Neighborhood Neighborhood for appraisal
PARCEL_NO 11 digit unique number Parcel_ID 11 digit unique number
PROP_SUBTY Assessor's property classification Property_Type Assessor's property classification
PROP_TYPE General property type; 3 letter code (TRN, APT, XMP, OFF, RTL, etc.) Property_Type General property type; 3 letter code (TRN, APT, XMP, OFF, RTL, etc.)
REC_VOLPAG Auditor's reference number Other_Reference_Info Auditor's reference number
REGION Inspection area Other_Reference_Info Inspection area
RES_COND grade of condition; need metadata to define the grades: AV, EX, FR, GD, PR, VG, VP. Unknown grade of condition; need metadata to define the grades: AV, EX, FR, GD, PR, VG, VP.
RES_QUAL grade of quality: need meta for grade definitions: A, A+, E, F, F-, F+, G, G+, L, V, X. Unknown grade of quality: need meta for grade definitions: A, A+, E, F, F-, F+, G, G+, L, V, X.
ROT blanks or "15" Unknown blanks or "15"
SALE_DATE Sale_Date
SALE_PRICE Sale_Price
SALE_VRFY Code to define sales transaction type Other_Reference_Info Code to define sales transaction type
SD_NAME Undefined
SECTTIE Section parcel where parcel is located (i.e. s22181w = Section 22 Range 1 West Township 18 North Township_Range_Section Section parcel where parcel is located (i.e. s22181w = Section 22 Range 1 West Township 18 North
SELLER_NAM Last, First MI with multiple names separated by & (i.e. THOMPSON DON R & ANJA B) Previous_Owner Last, First MI with multiple names separated by & (i.e. THOMPSON DON R & ANJA B)
SEWER_TYPE 2 letter code and description separated by hyphen (SP - SEPTIC, SW - SEWER, Unknown) Sewer_Type 2 letter code and description separated by hyphen (SP - SEPTIC, SW - SEWER, Unknown)
SHAPE_Area Unknown
SHAPE_Leng Unknown
SIGMA_YEAR Year of assessment Tax_Year Year of assessment
SITUS_CITY Parcel_Address_City
SITUS_STRE Full street address (i.e. 9835 SW JAMES RD). Parcel_Address Full street address (i.e. 9835 SW JAMES RD).
SITUS_ZIP Mostly 5 digit zip codes Parcel_Address_Zip Mostly 5 digit zip codes
STATE Owner_Address_State
STATUS_IND Status of parcel: A=active Parcel_Status Status of parcel: A=active
TAXABLE Table: Y/N Tax_Status Table: Y/N
TCA Tax code area based on taxing districts Tax_Code_Area Tax code area based on taxing districts
TOTAL_ACRE Size of parcel in acres Acres_Tabular Size of parcel in acres
TOTAL_VALU Sum of BLDG_VALUE and LAND_VALUE Total_Value Sum of BLDG_VALUE and LAND_VALUE
USE_CODE Land use code and description. First 2 digits coincide with WA DOR Land Use code followed by hyphen and short description (i.e. 11 - SINGLE-UNIT, 67 - SRV-GOVRNMTL, 88 - DESIGNATED-FOREST, etc...) Land_Use_Code Land use code and description. First 2 digits coincide with WA DOR Land Use code followed by hyphen and short description (i.e. 11 - SINGLE-UNIT, 67 - SRV-GOVRNMTL, 88 - DESIGNATED-FOREST, etc...)
WATER_SRC Water Source: P - PUBLIC, W - WELL, C -CISTERN, or UNKNOWN Water_Source Water Source: P - PUBLIC, W - WELL, C -CISTERN, or UNKNOWN
YEAR_BUILT Year built Building_Details Year built
ZIP 5- and 9-digit entries. 9-digit zipcodes separated by hyphen (i.e. 98507-1186) Owner_Address_Zip 5- and 9-digit entries. 9-digit zipcodes separated by hyphen (i.e. 98507-1186)
UW SealAbout Us | Site Map | Privacy Policy | Contact Us | ©2007-2025 University of Washington | Last Updated: 05/15/2023 12:33:37