GIS Data Catalog
Parcel Sales Last 3 Years
Learn how to use GIS Open Data 🗺
Summary
Parcel sales information for the last three years.
Description
Parcel sales information for the last three years taken from the RPSALE_EXTR table and joined to the PARCEL_ADDRESS_AREA, including condominium information related from the CONDOCOMPLEX_EXTR and CONDO_UNIT_EXTR tables.
All KCA Extract tables (_EXTR) are sourced from King County Assessor data.
Layer information
| Layer Name | parcel_sales3yr_area |
| Subject Category | Property |
| Title | Parcel Sales Last 3 Years |
| Feature Count | 113050 |
| Feature Type | Polygon |
| Spatial reference | EPSG:2926 |
| Control ID | 287 |
| Place Keywords | Washington State, King County, WA, Pacific NW |
| Theme Keywords | Property |
| Supplemental Information | None |
Table Preview
Attribute information
|
OBJECTID
From Esri |
Description
Internal feature number. DomainSequential unique whole numbers that are automatically generated. |
|
PIN
From King County |
Description
Not Found DomainNot Found |
|
address
From King County |
Description
Not Found DomainNot Found |
|
ExciseTaxNum
From King County |
Description
Not Found Domain2888195.0 to 3167027.0 by |
|
SaleDate
From King County |
Description
Not Found DomainNot Found |
|
SalePrice
From King County |
Description
Not Found Domain-400.0 to 704000000.0 by |
|
RecNumber
From King County |
Description
Not Found DomainNot Found |
|
RecVolume
From King County |
Description
Not Found DomainNot Found |
|
RecPage
From King County |
Description
Not Found DomainNot Found |
|
PlatNumber
From King County |
Description
Not Found DomainNot Found |
|
PlatType
From King County |
Description
Not Found DomainNot Found |
|
PlatLot
From King County |
Description
Not Found DomainNot Found |
|
PlatBlock
From King County |
Description
Not Found DomainNot Found |
|
Sellername
From King County |
Description
Not Found DomainNot Found |
|
selleradd1
From King County |
Description
Not Found DomainNot Found |
|
selleradd2
From King County |
Description
Not Found DomainNot Found |
|
buyername
From King County |
Description
Not Found DomainNot Found |
|
buyeradd1
From King County |
Description
Not Found DomainNot Found |
|
buyeradd2
From King County |
Description
Not Found DomainNot Found |
|
Property_Type
From King County |
Description
Not Found DomainBUILDING ONLY, LAND ONLY, LAND WITH MOBILE HOME, LAND WITH NEW BUILDING, LAND WITH PREV USED BLDG, NA, TIMBER ONLY |
|
Principal_Use
From King County |
Description
Not Found DomainAPT 4+ UNITS, COMMERCIAL, COMMERCIAL/INDUSTRIAL, CONDOMINIUM, INDUSTRIAL, MOBILE HOME, NA, OTHER, RECREATIONAL, RESIDENTIAL, TIMBER |
|
ForestLand
From King County |
Description
Not Found DomainN, Y |
|
CurrentUseLand
From King County |
Description
Not Found DomainN, Y |
|
NonProfitUse
From King County |
Description
Not Found DomainN, Y |
|
HistoricProperty
From King County |
Description
Not Found DomainN, Y |
|
Property_Class
From King County |
Description
Not Found DomainC/I-Condominium, C/I-Imp prop excl air rights, C/I-Imp prop; no condo/MH, C/I-Land only, C/I-Land or bldg no split, NA, Res-Improved property, Res-Land only, Res or C/I-Mobile Home |
|
shape
From Esri |
Description
Feature geometry. DomainCoordinates defining the features. |
|
shape.STArea()
No Source Noted |
Description
Not Found DomainNot Found |
|
shape.STLength()
No Source Noted |
Description
Not Found DomainNot Found |
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 | Public |
Summary
Parcel sales information for the last three years.
Description
Parcel sales information for the last three years taken from the RPSALE_EXTR table and joined to the PARCEL_ADDRESS_AREA, including condominium information related from the CONDOCOMPLEX_EXTR and CONDO_UNIT_EXTR tables.
All KCA Extract tables (_EXTR) are sourced from King County Assessor data.
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
| Update 1 |
USE [plibrary] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [property].[parcel_sales3yr_area_view] AS select property.rpsale_extr.PIN, property.parcel_address_area.addr_full as address, property.rpsale_extr.ExciseTaxNum, property.rpsale_extr.SaleDate, property.rpsale_extr.SalePrice, property.rpsale_extr.RecNumber, property.rpsale_extr.RecVolume, property.rpsale_extr.RecPage, property.rpsale_extr.PlatNumber, property.rpsale_extr.PlatType, property.rpsale_extr.PlatLot, property.rpsale_extr.PlatBlock, property.rpsale_extr.Sellername, property.rpsale_extr.selleraddressline selleradd1, property.rpsale_extr.sellercitystatezipcode selleradd2, property.rpsale_extr.buyername, property.rpsale_extr.buyeraddressline buyeradd1, property.rpsale_extr.buyercitystatezipcode buyeradd2, CASE property.rpsale_extr.PropertyType when 1 then 'LAND ONLY' when 2 then 'LAND WITH NEW BUILDING' when 3 then 'LAND WITH PREV USED BLDG' when 4 then 'LAND WITH MOBILE HOME' when 5 then 'TIMBER ONLY' when 6 then 'BUILDING ONLY' else 'NA' end as Property_Type, CASE property.rpsale_extr.PrincipalUse when 1 then 'AGRICULTURAL' when 2 then 'CONDOMINIUM' when 3 then 'RECREATIONAL' when 4 then 'APT 4+ UNITS' when 5 then 'INDUSTRIAL' when 6 then 'RESIDENTIAL' when 7 then 'COMMERCIAL' when 8 then 'MOBILE HOME' when 9 then 'TIMBER' when 10 then 'OTHER' when 11 then 'COMMERCIAL/INDUSTRIAL' else 'NA' end as Principal_Use, property.rpsale_extr.ForestLand, property.rpsale_extr.CurrentUseLand, property.rpsale_extr.NonProfitUse, property.rpsale_extr.HistoricProperty, CASE property.rpsale_extr.PropertyClass when 1 then 'C/I-Land only' when 2 then 'C/I-Imp prop; no condo/MH' when 3 then 'C/I-Condominium' when 4 then 'C/I-Air rights only' when 5 then 'C/I-Imp prop excl air rights' when 6 then 'C/I-Land or bldg no split' when 7 then 'Res-Land only' when 8 then 'Res-Improved property' when 9 then 'Res or C/I-Mobile Home' else 'NA' end as Property_Class, property.parcel_area.shape FROM property.rpsale_extr, property.parcel_area, property.parcel_address_area WHERE property.parcel_address_area.pin = property.rpsale_extr.pin and property.parcel_area.pin = property.rpsale_extr.pin and saledate > = DATEADD(YEAR, -3, GETDATE()) UNION ALL SELECT property.rpsale_extr.PIN, property.parcel_address_area.addr_full as address, property.rpsale_extr.ExciseTaxNum, property.rpsale_extr.SaleDate, property.rpsale_extr.SalePrice, property.rpsale_extr.RecNumber, property.rpsale_extr.RecVolume, property.rpsale_extr.RecPage, property.rpsale_extr.PlatNumber, property.rpsale_extr.PlatType, property.rpsale_extr.PlatLot, property.rpsale_extr.PlatBlock, property.rpsale_extr.Sellername, property.rpsale_extr.selleraddressline selleradd1, property.rpsale_extr.sellercitystatezipcode selleradd2, property.rpsale_extr.buyername, property.rpsale_extr.buyeraddressline buyeradd1, property.rpsale_extr.buyercitystatezipcode buyeradd2, CASE property.rpsale_extr.PropertyType when 1 then 'LAND ONLY' when 2 then 'LAND WITH NEW BUILDING' when 3 then 'LAND WITH PREV USED BLDG' when 4 then 'LAND WITH MOBILE HOME' when 5 then 'TIMBER ONLY' when 6 then 'BUILDING ONLY' else 'NA' end as Property_Type, CASE property.rpsale_extr.PrincipalUse when 1 then 'AGRICULTURAL' when 2 then 'CONDOMINIUM' when 3 then 'RECREATIONAL' when 4 then 'APT 4+ UNITS' when 5 then 'INDUSTRIAL' when 6 then 'RESIDENTIAL' when 7 then 'COMMERCIAL' when 8 then 'MOBILE HOME' when 9 then 'TIMBER' when 10 then 'OTHER' when 11 then 'COMMERCIAL/INDUSTRIAL' else 'NA' end as Principal_Use, property.rpsale_extr.ForestLand, property.rpsale_extr.CurrentUseLand, property.rpsale_extr.NonProfitUse, property.rpsale_extr.HistoricProperty, CASE property.rpsale_extr.PropertyClass when 1 then 'C/I-Land only' when 2 then 'C/I-Imp prop; no condo/MH' when 3 then 'C/I-Condominium' when 4 then 'C/I-Air rights only' when 5 then 'C/I-Imp prop excl air rights' when 6 then 'C I-Land or bldg no split' when 7 then 'Res-Land only' when 8 then 'Res-Improved property' when 9 then 'Res or C I-Mobile Home' else 'NA' end as Property_Class, property.parcel_area.shape FROM property.rpsale_extr, property.parcel_area, property.parcel_address_area, property.condounit_extr, property.condocomplex_extr WHERE property.parcel_area.pin = property.RPSALE_EXTR.pin and property.CONDOCOMPLEX_EXTR.MAJOR = property.CONDOUNIT_EXTR.MAJOR and property.CONDOUNIT_EXTR.PIN = property.RPSALE_EXTR.PIN AND property.CONDOCOMPLEX_EXTR.PIN = property.parcel_address_area.pin AND (property.RPSALE_EXTR.SaleDate >= DATEADD(YEAR, - 3, GETDATE())) GO |