Parcel Data Status
Status |
|||
| Statewide Parcel Participator: | yes | ||
| Assessor Office URL: | http://www.clallam.net/Assessor/index.html | ||
| Has GIS: | GIS Dept URL: |
http://www.clallam.net/Map/ | |
| Has IMS: | IMS URL: |
http://www.clallam.net/aimsxwebsite/CA_pacs/viewer.htm | |
| Requires License: | License File: |
Clallam_Data_Use_Agreement.doc | |
| Requires Request: | Request File: |
||
| Requires Fee: | Fee: |
25 | |
| Acquire Method: | |||
| Last Updated: | 2025-06-25 20:43:45 | ||
Primary Assessment Contact |
|||
| Name: | Jane Wise | ||
| Position: | IT Department | ||
| Organization: | Clallam County | ||
| Address: | 223 E. 4th St. | ||
| City, St, Zip: | Port Angeles, WA 98362 | ||
| Phone: | (360) 417-2283 | ||
| Fax: | |||
| Email: | jwise@co.clallam.wa.us | ||
| Contact Last Updated: | 2010-07-20 15:39:15 | ||
Primary GIS Contact |
|||
| Name: | Jane Wise | ||
| Position: | IT Department | ||
| Organization: | Clallam County | ||
| Address: | 223 E. 4th St. | ||
| City, St, Zip: | Port Angeles, WA 98362 | ||
| Phone: | (360) 417-2283 | ||
| Fax: | |||
| Email: | jwise@co.clallam.wa.us | ||
| Contact Last Updated: | 2010-07-20 15:39:15 | ||
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
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 up 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 (PARCELS: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):
2012 Washington State Parcel Database
Data Normalization, Integration and Quality Control Notes
| Integration Date: | 2012-03-23 |
| Integration Notes: | par_active.shp in 2012 has the new field: TIDELANDS. It is missing the 2010 field: Part. The 2010 field Stack was renamed to Stacked. Clallam_RPMaster attributes were all renamed between 2010 and 2012 as below: property id --> prop_id geo id --> geo_id prop use cd --> prop_use_cd prp use desc --> property_use_desc name --> file_name mail addr1 --> addr_line1 mail addr2 --> addr_line2 mail addr3 --> addr_line3 mail city --> addr_city mail st --> addr_state mail zip --> addr_zip situs street addr # --> site_addr# situs street prefix --> situs_street_prefx situs street --> situs_street situs street sufix --> situs_street_sufix situs city --> situs_city situs zip --> situs_zip tot imp mkt val --> total_imps_mkt_val tot land mkt val --> total_land_mkt_val tot mkt val --> total_market_val tot taxable val --> total_taxable_val tax area --> tax_area# tca desc --> astca_descript abs subdiv cd --> abs_subdv_cd block --> block tract or lot --> tract_or_lot book pg --> book_page legal acreage --> legal_acreage legal desc --> legal_desc In 2012, Clallam_RPMaster also has a new attribute: situs_state. Problems with Clallam_RPMaster_10232012.csv. There are records split across multiple lines with inappropriately placed commas and spaces, that need to be combined into single lines. Perhaps this is the result of a newline character in one of the fields, and an output script creating fixed width csv files. The following records had lines recombined: prop_id geo_id line_number 18600 0330085801600000 4221 20201 0330186104003405 5341 81729 0330342204650000 10965 48920 0530091400102001 22823 57586 0630000193400000 28875 81292 0630225012500000 39238 81296 0830112300200000 43328 82334 1532052400000000 54462 81304 3830241255940000 56342 Also, these edits were made to Clallam_RPMaster_10232012.csv: Line 2 (all '-') between the header row and the data was removed. Line 45488 ',,,,,,,,,,,,,,,,,,,,,,,,,,,,,' betweeen PROP_ID 79953 and PROP_ID 79955 was removed. Line 45912 'P78,,,,,,,,,,,,,,,,,,,,,,,,,,,,,' between PROP_ID 1106 and PROP_ID 1108 had 'P78' moved to the end of the previous line, and ',,,,,,,,,,,,,,,,,,,,,,,,,,,,,' removed. Line 56990 'STATE ASSESS,ED UTILITY K90,,,,,,,,,,,,,,,,,,,,,,,,,,,,' between PROP_ID 79021 and PROP_ID 79023 had 'STATE ASSESSED UTILITY K90' moved to the end of the previous line and ',,,,,,,,,,,,,,,,,,,,,,,,,,,,' removed. Line 56996 ',,,,,,,,,,,,,,,,,,,,,,,,,,,,,' after PROP_ID 79011 was removed. Line 56997 '(56992 row(s,) affected),,,,,,,,,,,,,,,,,,,,,,,,,,,,' after PROP_ID 79011 was removed. Problems with Clallam_Improvements_01232012.csv. There are records split across multiple lines with inappropriately placed commas and spaces, that need to be combined into single lines. Perhaps this is the result of a newline character in one of the fields, and an output script creating fixed width csv files. The following records had lines recombined: prop_id geo_id line number 20201 0330186104003405 16283 20201 0330186104003405 16284 57586 0630000193400000 61559 81292 0630225012500000 90995 81292 0630225012500000 90996 81292 0630225012500000 90997 ----------------------- Geometry: parcel with PNUM value: '000universe' was not entered into the PARCELBOUNDARY feature class. the source shapefile was pre-processed using the Repair Geometry tool in ArcGIS 10. The following polygons had self-intersections and were repaired: FID|PNUM|PROP_ID 2477|033005129100|16599 2478|033005129110|16600 2479|033005129120|16601 2480|033005129130|16602 2481|033005129140|16603 2482|033005129150|16604 2591|033005439150|16765 2593|033005439170|16770 2597|033005500098|16775 2598|033005500100|16776 2600|033005500104|16780 2628|033005500140|16809 2633|033005500148|16814 2646|033005500210|16830 2648|033005500240|16834 2649|033005500250|16835 2655|033005500400|16844 2660|033005500510|16853 2662|033005500570|81878 2664|033005500630|16857 2688|033005511000|16917 2690|033005511004|16919 2704|033005511050|16939 2705|033005511054|16940 2710|033005511070|16945 |
| QAQC Date: | 2012-07-13 |
| QAQC Notes: | PolyID=405000000001; ProcessParcelFlattened=2; confirmed 2 parcel records for same polygon; PNUM=033028440100. PolyID=405000002491; ProcessParcelFlattened=3; confirmed 3 parcel records for same polygon; PNUM=132916418020. PolyID=405000052022; ProcessParcelAggregated=3. Confirmed 3 adjascent polygons in source file par_active.shp with the same PNUM: 043013330025. PolyID=405000002741; ProcessParcelDuplicatesRemoved=2. Confirmed 2 instances of PNUM=133036310000 in source shapefile (par_active.shp).PolyID=405000000913; ProcessParcelDuplicatesRemoved=4. Confirmed 4 records with PNUM=033019650040 as well as PropID=80926 in source data fiel (par_active.dbf). NameID=405000001773; ProcessNameFlattened=4. Confirmed 4 records in source data (Clallam_RPMaster_10232012.csv) with same name (BLAINE E WOODARD); prop_id: 75980,75981,76091, 76090). |
Tables
| Name | Notes |
| par_active.shp | publication date in file name: Clallam_ShapeFiles_10212011.zip Publication Date is 21 not 12. File Date Stamp is 12 not 21. |
| Clallam_RPMaster_10232012.csv | |
| Clallam_Improvements_01232012.csv |
Table Relationships
| Primary Table | Primary Key | Foreign Table | Foreign Key | Cardinality | Notes |
| par_active.shp | PROP_ID | Clallam_RPMaster_10232012.csv | prop_id | 1:many | if can't join using the prop_id, the first 12 characters of geo_id are joined with PNUM |
Attribute Normalization
| Table Name | Attribute | Common Field | Normalized Field | Normalization Process |
| Clallam_Improvements_01232012.csv | bathroom_count | Structure_Number_Of_Bathrooms | NumberBathrooms | Direct |
| Clallam_Improvements_01232012.csv | bedroom_count | Structure_Number_Of_Bedrooms | NumberBedrooms | Direct |
| Clallam_Improvements_01232012.csv | condition_cd | Structure_Building_Condition_Code | Condition | Direct |
| Clallam_Improvements_01232012.csv | imprv_det_area | Structure_Square_Feet_Total | SquareFeetTotal | Direct |
| Clallam_Improvements_01232012.csv | imprv_det_class_cd | Structure_Building_Description_Code | Description | Concatenate: imprv_det_type_cd, imprv_det_typ_desc, imprv_det_class_cd, imprv_det_cls_desc |
| Clallam_Improvements_01232012.csv | imprv_det_cls_desc | Structure_Building_Description | Description | Concatenate: imprv_det_type_cd, imprv_det_typ_desc, imprv_det_class_cd, imprv_det_cls_desc |
| Clallam_Improvements_01232012.csv | imprv_det_sub_class_cd | Structure_Building_Quality_Code | Quality | Concatenate: imprv_det_sub_class_cd, imprv_det_sub_cls_desc |
| Clallam_Improvements_01232012.csv | imprv_det_sub_cls_desc | Structure_Building_Quality | Quality | Concatenate: imprv_det_sub_class_cd, imprv_det_sub_cls_desc |
| Clallam_Improvements_01232012.csv | imprv_det_sub_cls_desc | Structure_Building_Quality | Description | Concatenate: imprv_det_type_cd, imprv_det_typ_desc, imprv_det_class_cd, imprv_det_cls_desc |
| Clallam_Improvements_01232012.csv | imprv_det_type_cd | Structure_Building_Type_Code | Description | Concatenate: imprv_det_type_cd, imprv_det_typ_desc, imprv_det_class_cd, imprv_det_cls_desc |
| Clallam_Improvements_01232012.csv | imprv_det_type_cd | Structure_Building_Type_Code | SourceType | Concatenate: imprv_det_type_cd, imprv_det_type_desc |
| Clallam_Improvements_01232012.csv | imprv_det_typ_desc | Structure_Building_Type | SourceType | Concatenate: imprv_det_type_cd, imprv_det_type_desc |
| Clallam_Improvements_01232012.csv | yr_built | Structure_Year_Built | YearBuilt | Direct |
| Clallam_RPMaster_10232012.csv | addr_city | Owner_Address_City | AddressCity | Direct; owner |
| Clallam_RPMaster_10232012.csv | addr_line1 | Owner_Address_1 | AddressLine1 | Direct; owner |
| Clallam_RPMaster_10232012.csv | addr_line2 | Owner_Address_2 | AddressLine2 | Direct; owner |
| Clallam_RPMaster_10232012.csv | addr_line3 | Owner_Address_3 | AddressLine3 | Direct; owner |
| Clallam_RPMaster_10232012.csv | addr_state | Owner_Address_State | AddressState | Direct; owner |
| Clallam_RPMaster_10232012.csv | addr_zip | Owner_Address_Zip | AddressZip | Direct; owner |
| Clallam_RPMaster_10232012.csv | book_page | Source_Document | SourceDocumentReference | Concatenate: CDoc_AFN, CDoc_Type, D_Source, book_page |
| Clallam_RPMaster_10232012.csv | file_name | Owner_Name | Name.Name | Direct; owner |
| Clallam_RPMaster_10232012.csv | legal_acreage | Acres_Tabular | TabularAcres | Direct |
| Clallam_RPMaster_10232012.csv | legal_desc | Legal_Description | LegalDescription | Direct |
| Clallam_RPMaster_10232012.csv | property_use_desc | Land_Use_Code | SourceLandUseDescription | Direct |
| Clallam_RPMaster_10232012.csv | prop_use_cd | Land_Use_Code | StateLandUseCode | left 2 characters; FME substring (0,1) |
| Clallam_RPMaster_10232012.csv | site_addr# | Parcel_Address_House | SiteAddressNumber | Direct |
| Clallam_RPMaster_10232012.csv | site_addr# | Parcel_Address_House | SiteAddressFull | Concatenate: site_addr#, situs_street_prefix, situs_street, situs_street_sufix, situs_city, situs_state, situs_zip |
| Clallam_RPMaster_10232012.csv | situs_city | Parcel_Address_City | SiteAddressCity | Direct |
| Clallam_RPMaster_10232012.csv | situs_city | Parcel_Address_City | SiteAddressFull | Concatenate: site_addr#, situs_street_prefix, situs_street, situs_street_sufix, situs_city, situs_state, situs_zip |
| Clallam_RPMaster_10232012.csv | situs_state | Parcel_Address_State | SiteAddressFull | Concatenate: site_addr#, situs_street_prefix, situs_street, situs_street_sufix, situs_city, situs_state, situs_zip |
| Clallam_RPMaster_10232012.csv | situs_street | Parcel_Address_Street | SiteAddressStreetFullName | Concatenate: situs_street_prefix, situs_street, situs_street_sufix |
| Clallam_RPMaster_10232012.csv | situs_street | Parcel_Address_Street | SiteAddressFull | Concatenate: site_addr#, situs_street_prefix, situs_street, situs_street_sufix, situs_city, situs_state, situs_zip |
| Clallam_RPMaster_10232012.csv | situs_street | Parcel_Address_Street | SiteAddressStreetName | Direct |
| Clallam_RPMaster_10232012.csv | situs_street_prefx | Parcel_Address_Prefix | SiteAddressStreetPrefix | Direct |
| Clallam_RPMaster_10232012.csv | situs_street_prefx | Parcel_Address_Prefix | SiteAddressStreetFullName | Concatenate: situs_street_prefix, situs_street, situs_street_sufix |
| Clallam_RPMaster_10232012.csv | situs_street_prefx | Parcel_Address_Prefix | SiteAddressFull | Concatenate: site_addr#, situs_street_prefix, situs_street, situs_street_sufix, situs_city, situs_state, situs_zip |
| Clallam_RPMaster_10232012.csv | situs_street_sufix | Parcel_Address_Suffix | SiteAddressStreetSuffix | Direct |
| Clallam_RPMaster_10232012.csv | situs_street_sufix | Parcel_Address_Suffix | SiteAddressStreetFullName | Concatenate: situs_street_prefix, situs_street, situs_street_sufix |
| Clallam_RPMaster_10232012.csv | situs_street_sufix | Parcel_Address_Suffix | SiteAddressFull | Concatenate: site_addr#, situs_street_prefix, situs_street, situs_street_sufix, situs_city, situs_state, situs_zip |
| Clallam_RPMaster_10232012.csv | situs_zip | Parcel_Address_Zip | SiteAddressFull | Concatenate: site_addr#, situs_street_prefix, situs_street, situs_street_sufix, situs_city, situs_state, situs_zip |
| Clallam_RPMaster_10232012.csv | tax_area# | Tax_Code_Area | TaxCodeArea | Direct |
| Clallam_RPMaster_10232012.csv | total_imps_mkt_val | Market_Value_Improvements | MarketValueImprovements | Direct |
| Clallam_RPMaster_10232012.csv | total_land_mkt_val | Market_Value_Land | MarketValueLand | Direct |
| Clallam_RPMaster_10232012.csv | total_market_val | Market_Value_Total | MarketValueTotal | Direct |
| Clallam_RPMaster_10232012.csv | total_taxable_val | Taxable_Value_Total | TaxableValueTotal | Direct |
| par_active.shp | CDoc_AFN | Feature_Source | SourceDocumentReference | Concatenate: CDoc_AFN, CDoc_Type, D_Source, book_page |
| par_active.shp | CDoc_Type | Feature_Source | SourceDocumentReference | Concatenate: CDoc_AFN, CDoc_Type, D_Source, book_page |
| par_active.shp | C_Date | Create_Date | SourceCreationDate | Direct |
| par_active.shp | D_Source | Feature_Source | SourceDocumentReference | Concatenate: CDoc_AFN, CDoc_Type, D_Source, book_page |
| par_active.shp | PNUM | Parcel_ID | SourceParcelID | Direct |
| par_active.shp | PNUM | Parcel_ID | Range | FME Substring (0,1); concatenate with 'W' |
| par_active.shp | PNUM | Parcel_ID | Township | FME Substring (2,3); concatenate with 'N' |
| par_active.shp | PNUM | Parcel_ID | Section | FME Substring(4,5) |
| par_active.shp | PNUM | Parcel_ID | QuarterSection | FME Substring(6,7) |
| par_active.shp | PROP_ID | Other_Reference_Info | AssessorURL | Concatenate: 'http://vpn.clallam.net:8084/propertyaccess/Property.aspx?cid=0&year=2010&prop_id=', PROP_ID |
| par_active.shp | R_Date | Edit_Update_Date | SourceRevisionDate | Direct |
| par_active.shp | Status | Parcel_Status | TaxStatus | Direct |
