Parcel Data Status
Status |
|||
| Statewide Parcel Participator: | partial | ||
| Assessor Office URL: | http://www.co.jefferson.wa.us/assessors/Default.asp | ||
| Has GIS: | GIS Dept URL: |
http://www.co.jefferson.wa.us/idms/default.htm | |
| Has IMS: | IMS URL: |
http://maps.co.jefferson.wa.us/Website/mspub/viewer.htm?mapset=parcels_outside | |
| Requires License: | License File: |
||
| Requires Request: | Request File: |
Assessment rolls and maps on CD.doc.htm | |
| Requires Fee: | Fee: |
15 | |
| Acquire Method: | Owner Names/Addresses, SITUS, and longer legal description downloaded from the Jefferson Assessor website using: 2010_GetJeffersonAttributes_Threaded.py in C:\Data\Statewide Parcel Database\Tools\GetJefferson on conifer | ||
| Last Updated: | 2019-10-22 12:03:31 | ||
Primary Assessment Contact |
|||
| Name: | Jack Westerman III | ||
| Position: | Assessor | ||
| Organization: | Jefferson County Assessor's Office | ||
| Address: | P.O. Box 1220 | ||
| City, St, Zip: | Port Townsend, WA 98368 | ||
| Phone: | (360)385-9105 | ||
| Fax: | (360)385-9197 | ||
| Email: | jwesterman@co.jefferson.wa.us | ||
| Contact Last Updated: | 2012-08-09 10:56:45 | ||
Primary GIS Contact |
|||
| Name: | Pat Perryman | ||
| Position: | |||
| Organization: | |||
| Address: | |||
| City, St, Zip: | , WA | ||
| Phone: | (360) 385-9148 | ||
| Fax: | |||
| Email: | pperryman@co.jefferson.wa.us | ||
| Contact Last Updated: | 2007-06-06 13:23:23 | ||
Database Schema
The normalized Statewide Parcel Database consists of multiple related tables, relationship classes and lookup tables. Detailed information about the database schema can be found on the technical documentation page.
QA/QC Process Description
- While processing and normalizing the data for each county to a standardized statewide dataset, five possible procedures could have been applied: Removing Duplicate Parcels, Flattening Stacked Parcels, Creating Multipart Parcels, Removing Duplicate Names, and Removing Duplicate Taxrolls.
- The data for each county was tested to see whether or not these five procedures were applied. For each of these procedures applied in a county, one test parcel to which a process was applied was selected and tested to ensure the procedure was applied correctly.
- A parcel to which none of the procedures was applied was also tested to make sure all of the normalized attributes in the original data were correctly transferred to the final dataset.
- It is therefore possible that tp to six data quality tests were performed for each county.
QA/QC Procedure Descriptions
The following five Procedures were performed in this order on the data for each county.- Removing Duplicate Parcels (PARCELS:DUPLICATE): There are two or more polygons representing a single parcel in the original data. They have the same geometry and identical attribute information. These are assumed to be multiple copies of the same parcel, and so duplicates are removed leaving a single polygon, and single set of attribute information in the final database. This flag tells how many duplicates of the parcel were in the original data.
- Flattening Stacked Parcels (PARCELS:FLATTENED): There are two or more polygons representing a parcel in the original data, however, while sharing the same geometry, they have different attributes. These are assumed to be multiple owners for the same parcel. The polygon only needs to be in the final database a single time, but all original attribute information for the different owners needs to be retained. This flag tells how many stacked polygons there were in the original data for each parcel.
- Creating Multipart Parcels (PRCELS:AGGREGATED): There are two or more polygons in the original data with different geometries but, identical attribute information. It is assumed that these parcels are all owned by the same owner. The original polygons are all retained as a single, multipart polygon, but duplicate versions of the attributes are removed. Only a single copy of the attribute information is needed in the final database. This flag tells how many parcels were aggregated into each multipart polygon.
- Removing Duplicate Taxrolls (TAXROLL:FLATTENED): Two or more parcels in a county have identical taxroll attributes. These attributes only need to be in the final database a single time. This flag records how many of the original parcels shared each set of taxroll attributes.
- Removing Duplicate Names (NAMES:FLATTENED): Two or more parcels in a county have the same name attributes in the original data. These attributes only need to be in the final database a single time. This flag records how many of the original parcels shared each set of name attributes.
Parcel Data Documentation (select a normalization date):
Data Normalization, Integration and Quality Control Notes
| Integration Date: | 2010-11-03 |
| Integration Notes: | Parcels with PIN_STRING values: 001023007,001034043,001043003,001191001,001211003,001302019,001311003,001321012,001324003,001324005,001324014,001324017,001333033,002254001,021321012,021321013,502074003,502083019,502151035,602231006,602291014,613223002,701183009,701183019,701271007,701271008,701291001,702022003,702034004,801211001,801212004,802123017,821355037,901104024,901131001,901141006,901154001,901173002,901224002,901252005,901281022,902231016,902234001,921043014,921191018,921312002,921333005,936000215,946800101,948333602,948333804,948334206,951907502,953100401,959100111,961800401,961800416,961800811,961800902,961802106,961802107,964504401,980700506,981301415,981301416,989709001,989709002,993000031,993800029,994800301,994800303,999000305,999100058,999900117 were altered during import because of geometry errors (overlaps, and missing vertices). They were aggregated into multi-part polygons, which cannot overlap with themselves. |
| QAQC Date: | 2011-05-27 |
| QAQC Notes: | PolyID 416000026688 - matches data on Jefferson website. PolyID 416000019566 - matches data from source files "web_attributes.mdb" and RPMST2ARC.mdb. |
Tables
| Name | Notes |
| Jefferson02_10.shp | |
| RPMST2AR.DBF | |
| web_attributes | in web_attributes.mdb |
| web_attributes_building | in web_attributes.mdb |
Table Relationships
| Primary Table | Primary Key | Foreign Table | Foreign Key | Cardinality | Notes |
| Jefferson02_10.shp | PIN_STRING | RPMST2AR.DBF | PARCEL | 1:many | |
| Jefferson02_10.shp | PIN_STRING | web_attributes_building | SourceParcelID | 1:many | |
| RPMST2AR.DBF | PARCEL | web_attributes | SourceParcelID | 1:many |
Attribute Normalization
| Table Name | Attribute | Common Field | Normalized Field | Normalization Process |
| Jefferson02_10.shp | Land_Use | Land_Use_Code | StateLandUseCode | Use LandUse_JEFF_Crosswalk |
| Jefferson02_10.shp | LU_Desc | Land_Use_Description | SourceLandUseDescription | Direct |
| Jefferson02_10.shp | PIN_STRING | Parcel_ID | SourceParcelID | Direct |
| Jefferson02_10.shp | PIN_STRING | Parcel_ID | AssessorURL | When no value for AssessorURL in web_attributes, concatenate: 'http://www.co.jefferson.wa.us/assessors/parcel/parceldetail.asp?PARCEL_NO=', PIN_STRING |
| RPMST2AR.DBF | AC_IMP | Acres_Improved | ImprovedAcres | Direct |
| RPMST2AR.DBF | AC_UNIM | Acres_Unimproved | UnimprovedAcres | Direct |
| RPMST2AR.DBF | DESC1 | Legal_Description | LegalDescription | When no value for LegalDescription in web_attributes concatenate: DESC1, DESC2 |
| RPMST2AR.DBF | DESC2 | Legal_Description | LegalDescription | When no value for LegalDescription in web_attributes concatenate: DESC1, DESC2 |
| RPMST2AR.DBF | TAXCODE | Tax_Code_Area | TaxCodeArea | Direct |
| RPMST2AR.DBF | TAXPAYER | Taxpayer_Code | NameCD | Direct; Taxpayer |
| RPMST2AR.DBF | TAX_STAT | Tax_Status | TaxStatus | Direct |
| RPMST2AR.DBF | VAL_BLDG | Market_Value_Improvements | MarketValueImprovements | Direct |
| RPMST2AR.DBF | VAL_IMP | Market_Value_Improved_Land | MarketValueImprovedLand | Direct |
| RPMST2AR.DBF | VAL_TIMB | Market_Value_Timber | MarketValueTimberLand | Direct |
| RPMST2AR.DBF | VAL_UNIM | Market_Value_Unimproved_Land | MarketValueUnimprovedLand | Direct |
| web_attributes | AddressCity | Owner_Address_City | AddressCity | Direct; Owner |
| web_attributes | AddressLine1 | Owner_Address_1 | AddressLine1 | Direct; Owner |
| web_attributes | AddressLine2 | Owner_Address_2 | AddressLine2 | Direct; Owner |
| web_attributes | AddressLine3 | Owner_Address_3 | AddressLine3 | Direct; Owner |
| web_attributes | AddressState | Owner_Address_State | AddressState | Direct; Owner |
| web_attributes | AddressZip | Owner_Address_Zip | AddressZip | Direct; Owner |
| web_attributes | AssessorURL | URL | AssessorURL | Direct when has value |
| web_attributes | LegalDescription | Legal_Description | LegalDescription | Direct when has value |
| web_attributes | Name | Owner_Name | Name.Name | Direct; Owner |
| web_attributes | QuarterSection | Quarter_Section | QuarterSection | Direct |
| web_attributes | Range | Range | Range | Direct |
| web_attributes | Section | Section | Section | Direct |
| web_attributes | SiteAddressCity | Parcel_Address_City | SiteAddressCity | Direct |
| web_attributes | SiteAddressCity | Parcel_Address_City | SiteAddressFull | Concatenate: SiteAddressNumber, SiteAddressStreetFullName, SiteAddressCity, SiteAddressZip |
| web_attributes | SiteAddressNumber | Parcel_Address_House | SiteAddressNumber | Direct |
| web_attributes | SiteAddressNumber | Parcel_Address_House | SiteAddressFull | Concatenate: SiteAddressNumber, SiteAddressStreetFullName, SiteAddressCity, SiteAddressZip |
| web_attributes | SiteAddressStreetFullName | Parcel_Address_Street | SiteAddressStreetFullName | Direct |
| web_attributes | SiteAddressStreetFullName | Parcel_Address_Street | SiteAddressFull | Concatenate: SiteAddressNumber, SiteAddressStreetFullName, SiteAddressCity, SiteAddressZip |
| web_attributes | SiteAddressZip | Parcel_Address_Zip | SiteAddressFull | Concatenate: SiteAddressNumber, SiteAddressStreetFullName, SiteAddressCity, SiteAddressZip |
| web_attributes | Township | Township | Township | Direct |
| web_attributes_building | Addition1Area | Structure_Square_Feet_Total | SquareFeetTotal | If Addition1Type in (Barn, Carport, Deck, Garage, Shed) add as independent structure on parcel |
| web_attributes_building | Addition1Exterior | Structure_Siding_Material | SidingMaterial | If Addition1Type in (Barn, Carport, Deck, Garage, Shed) add as independent structure on parcel |
| web_attributes_building | Addition1Roof | Structure_Roof_Material | RoofMaterial | If Addition1Type in (Barn, Carport, Deck, Garage, Shed) add as independent structure on parcel |
| web_attributes_building | Addition1Type | Structure_Building_Type | SourceType | If Addition1Type in (Barn, Carport, Deck, Garage, Shed) add as independent structure on parcel |
| web_attributes_building | Addition2Area | Structure_Square_Feet_Total | SquareFeetTotal | If Addition2Type in (Barn, Carport, Deck, Garage, Shed) add as independent structure on parcel |
| web_attributes_building | Addition2Exterior | Structure_Siding_Material | SidingMaterial | If Addition2Type in (Barn, Carport, Deck, Garage, Shed) add as independent structure on parcel |
| web_attributes_building | Addition2Roof | Structure_Roof_Material | RoofMaterial | If Addition2Type in (Barn, Carport, Deck, Garage, Shed) add as independent structure on parcel |
| web_attributes_building | Addition2Type | Structure_Building_Type | SourceType | If Addition2Type in (Barn, Carport, Deck, Garage, Shed) add as independent structure on parcel |
| web_attributes_building | BasementArea | Structure_Basement_Square_Feet | SquareFeetBasement | Direct |
| web_attributes_building | BuildingNumber | Structure_Building_Unique_Id | SourceImprovementID | Direct |
| web_attributes_building | BuildingStyle | Structure_Building_Description | Description | Concatenate: BuildingStyle, GarageType |
| web_attributes_building | BuildingType | Structure_Building_Type | SourceType | Direct |
| web_attributes_building | Exterior | Structure_Siding_Material | SidingMaterial | Concatenate: Exterior, GarageExterior |
| web_attributes_building | Foundation | Structure_Foundation_Type | FoundationType | Direct |
| web_attributes_building | GarageArea | Structure_Garage_Square_Feet | SquareFeetGarage | Direct if CarportSquareFootage is Null; Sum of GarageArea and CarportSquareFootage if both have values; CarportSquareFootage only if GarageArea is Null. |
| web_attributes_building | GarageType | Structure_Garage_Type | Description | If not blank, concatenate with 'Garage'. Concatenate: BuildingStyle, GarageType |
| web_attributes_building | MobileHomeYearBuilt | Structure_Mobile_Home_Year_Built | YearBuilt | If structure is a mobile home, use this for year built, unless it equals 0 or is blank, then use YearBuilt |
| web_attributes_building | NumberOfBedrooms | Structure_Number_Of_Bedrooms | NumberBedrooms | Direct |
| web_attributes_building | NumberOfFullBathrooms | Structure_Number_Of_Full_Bathrooms | NumberBathrooms | (NumberOfFullBathrooms * 1) + (NumberOfHalfBathrooms * 0.5) |
| web_attributes_building | NumberOfHalfBathrooms | Structure_Number_Of_Half_Bathrooms | NumberBathrooms | (NumberOfFullBathrooms * 1) + (NumberOfHalfBathrooms * 0.5) |
| web_attributes_building | RoofCover | Structure_Roof_Material | RoofMaterial | Concatenate: RoofCover, GarageRoof |
| web_attributes_building | TotalArea | Structure_Square_Feet_Total | SquareFeetTotal | Direct |
| web_attributes_building | YearBuilt | Structure_Year_Built | YearBuilt | If structure is not a mobile home (or it is a mobile home, but MobileHomeYearBuilt is 0 or blank), use this for year built |
| web_attributes_building | YearRemodeled | Structure_Remodel_Year | YearRenovated | Direct |
Lookups
| Original Field | Original Value | Normalized Value | Normalized Field |
| Land_Use | 0 | 0 | StateLandUseCode |
| Land_Use | 1100 | 11 | StateLandUseCode |
| Land_Use | 1101 | 15 | StateLandUseCode |
| Land_Use | 1103 | 15 | StateLandUseCode |
| Land_Use | 1104 | 15 | StateLandUseCode |
| Land_Use | 1200 | 12 | StateLandUseCode |
| Land_Use | 1300 | 13 | StateLandUseCode |
| Land_Use | 1400 | 14 | StateLandUseCode |
| Land_Use | 1420 | 14 | StateLandUseCode |
| Land_Use | 1500 | 15 | StateLandUseCode |
| Land_Use | 1600 | 16 | StateLandUseCode |
| Land_Use | 1700 | 17 | StateLandUseCode |
| Land_Use | 1900 | 19 | StateLandUseCode |
| Land_Use | 2000 | 39 | StateLandUseCode |
| Land_Use | 2400 | 24 | StateLandUseCode |
| Land_Use | 2450 | 24 | StateLandUseCode |
| Land_Use | 2600 | 26 | StateLandUseCode |
| Land_Use | 3200 | 32 | StateLandUseCode |
| Land_Use | 3262 | 32 | StateLandUseCode |
| Land_Use | 3270 | 32 | StateLandUseCode |
| Land_Use | 3300 | 33 | StateLandUseCode |
| Land_Use | 3432 | 33 | StateLandUseCode |
| Land_Use | 3443 | 39 | StateLandUseCode |
| Land_Use | 4111 | 41 | StateLandUseCode |
| Land_Use | 4212 | 41 | StateLandUseCode |
| Land_Use | 4300 | 43 | StateLandUseCode |
| Land_Use | 4315 | 43 | StateLandUseCode |
| Land_Use | 4411 | 44 | StateLandUseCode |
| Land_Use | 4590 | 45 | StateLandUseCode |
| Land_Use | 4600 | 46 | StateLandUseCode |
| Land_Use | 4711 | 47 | StateLandUseCode |
| Land_Use | 4800 | 48 | StateLandUseCode |
| Land_Use | 4805 | 48 | StateLandUseCode |
| Land_Use | 4833 | 48 | StateLandUseCode |
| Land_Use | 4841 | 48 | StateLandUseCode |
| Land_Use | 4854 | 48 | StateLandUseCode |
| Land_Use | 5000 | 50 | StateLandUseCode |
| Land_Use | 5100 | 50 | StateLandUseCode |
| Land_Use | 5192 | 51 | StateLandUseCode |
| Land_Use | 5195 | 51 | StateLandUseCode |
| Land_Use | 5199 | 51 | StateLandUseCode |
| Land_Use | 5200 | 52 | StateLandUseCode |
| Land_Use | 5300 | 53 | StateLandUseCode |
| Land_Use | 5360 | 53 | StateLandUseCode |
| Land_Use | 5370 | 53 | StateLandUseCode |
| Land_Use | 5400 | 54 | StateLandUseCode |
| Land_Use | 5410 | 54 | StateLandUseCode |
| Land_Use | 5500 | 55 | StateLandUseCode |
| Land_Use | 5530 | 55 | StateLandUseCode |
| Land_Use | 5600 | 56 | StateLandUseCode |
| Land_Use | 5700 | 57 | StateLandUseCode |
| Land_Use | 5800 | 58 | StateLandUseCode |
| Land_Use | 5810 | 58 | StateLandUseCode |
| Land_Use | 5820 | 58 | StateLandUseCode |
| Land_Use | 5830 | 58 | StateLandUseCode |
| Land_Use | 5900 | 59 | StateLandUseCode |
| Land_Use | 5920 | 59 | StateLandUseCode |
| Land_Use | 5932 | 59 | StateLandUseCode |
| Land_Use | 5969 | 59 | StateLandUseCode |
| Land_Use | 6000 | 61 | StateLandUseCode |
| Land_Use | 6100 | 61 | StateLandUseCode |
| Land_Use | 6154 | 61 | StateLandUseCode |
| Land_Use | 6200 | 62 | StateLandUseCode |
| Land_Use | 6242 | 62 | StateLandUseCode |
| Land_Use | 6300 | 63 | StateLandUseCode |
| Land_Use | 6375 | 63 | StateLandUseCode |
| Land_Use | 6400 | 64 | StateLandUseCode |
| Land_Use | 6412 | 64 | StateLandUseCode |
| Land_Use | 6500 | 65 | StateLandUseCode |
| Land_Use | 6513 | 65 | StateLandUseCode |
| Land_Use | 6600 | 66 | StateLandUseCode |
| Land_Use | 6700 | 67 | StateLandUseCode |
| Land_Use | 6721 | 67 | StateLandUseCode |
| Land_Use | 6722 | 67 | StateLandUseCode |
| Land_Use | 6730 | 67 | StateLandUseCode |
| Land_Use | 6800 | 68 | StateLandUseCode |
| Land_Use | 6900 | 69 | StateLandUseCode |
| Land_Use | 6911 | 69 | StateLandUseCode |
| Land_Use | 7111 | 71 | StateLandUseCode |
| Land_Use | 7112 | 71 | StateLandUseCode |
| Land_Use | 7119 | 71 | StateLandUseCode |
| Land_Use | 7200 | 72 | StateLandUseCode |
| Land_Use | 7221 | 72 | StateLandUseCode |
| Land_Use | 7239 | 72 | StateLandUseCode |
| Land_Use | 7311 | 73 | StateLandUseCode |
| Land_Use | 7400 | 74 | StateLandUseCode |
| Land_Use | 7441 | 74 | StateLandUseCode |
| Land_Use | 7442 | 74 | StateLandUseCode |
| Land_Use | 7500 | 75 | StateLandUseCode |
| Land_Use | 7519 | 75 | StateLandUseCode |
| Land_Use | 7600 | 76 | StateLandUseCode |
| Land_Use | 7610 | 76 | StateLandUseCode |
| Land_Use | 7620 | 76 | StateLandUseCode |
| Land_Use | 7650 | 76 | StateLandUseCode |
| Land_Use | 7670 | 76 | StateLandUseCode |
| Land_Use | 7690 | 76 | StateLandUseCode |
| Land_Use | 7700 | 77 | StateLandUseCode |
| Land_Use | 7900 | 79 | StateLandUseCode |
| Land_Use | 8000 | 82 | StateLandUseCode |
| Land_Use | 8100 | 83 | StateLandUseCode |
| Land_Use | 8110 | 94 | StateLandUseCode |
| Land_Use | 8120 | 95 | StateLandUseCode |
| Land_Use | 8130 | 99 | StateLandUseCode |
| Land_Use | 8300 | 88 | StateLandUseCode |
| Land_Use | 8400 | 84 | StateLandUseCode |
| Land_Use | 8543 | 85 | StateLandUseCode |
| Land_Use | 8900 | 89 | StateLandUseCode |
| Land_Use | 9100 | 91 | StateLandUseCode |
| Land_Use | 9120 | 69 | StateLandUseCode |
| Land_Use | 9150 | 91 | StateLandUseCode |
| Land_Use | 9300 | 93 | StateLandUseCode |
| Land_Use | 9600 | 91 | StateLandUseCode |
| Land_Use | 9700 | 99 | StateLandUseCode |
| Land_Use | 9720 | 91 | StateLandUseCode |
| Land_Use | 9725 | 91 | StateLandUseCode |
| Land_Use | 9730 | 91 | StateLandUseCode |
| Land_Use | 9800 | 99 | StateLandUseCode |
| Land_Use | 9903 | 99 | StateLandUseCode |
