Parcel Data Status
Status |
|||
| Statewide Parcel Participator: | yes | ||
| Assessor Office URL: | http://www.skagitcounty.net/Common/asp/default.asp?d=Assessor&c=General&p=main.htm | ||
| Has GIS: | GIS Dept URL: |
http://www.skagitcounty.net/Common/asp/default.asp?d=GIS&c=General&p=main.htm | |
| Has IMS: | IMS URL: |
http://www.skagitcounty.net/GIS/Applications/iMap/asp/iMap.asp | |
| Requires License: | License File: |
http://www.skagitcounty.net/GIS/Documents/Misc/DDRF%20GI.pdf | |
| Requires Request: | Request File: |
Skagit_records_request_form.pdf | |
| Requires Fee: | Fee: |
75 | |
| Acquire Method: | After sending initial e-mail, GIS manager contacted us and directed us to the on-line location to download the parcel shapefile. Then, we contacted the Assessor's office and were e-mailed a Request for Public Records document and a bill for $75. After mailing the request and check to the Assessor's office, we received a CD with the tabular assessor data. Terms of Use: http://www.skagitcounty.net/GIS/Documents/Misc/DDRF%20GI.pdf |
||
| Last Updated: | 2019-09-11 11:21:55 | ||
Primary Assessment Contact |
|||
| Name: | Don Munks | ||
| Position: | Assessor | ||
| Organization: | Skagit County Assessor's Office | ||
| Address: | 700 South 2nd Street | ||
| City, St, Zip: | Mount Vernon, WA 98273 | ||
| Phone: | (360) 336 - 9370 | ||
| Fax: | (360) 336 - 9308 | ||
| Email: | assessor@co.skagit.wa.us | ||
| Contact Last Updated: | 2012-08-09 11:02:51 | ||
Primary GIS Contact |
|||
| Name: | Kelly Briggs | ||
| Position: | |||
| Organization: | Skagit County Assessor's Office | ||
| Address: | 700 South 2nd St | ||
| City, St, Zip: | Mount Vernon, WA 98273 | ||
| Phone: | (360) 336-9370, x3343 | ||
| Fax: | |||
| Email: | kellyb@co.skagit.wa.us | ||
| Contact Last Updated: | 2009-05-14 11:02:55 | ||
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):
2010 Washington State Parcel Database
Data Normalization, Integration and Quality Control Notes
| Integration Date: | 2010-10-25 |
| Integration Notes: | The file 'AssessorData.txt' has newLine characters in the Legal Description field causing errors while importing it. The legal description was split onto multiple lines when opened, which meant that many lines did not have the proper number of fields, and could not be imported properly. This occurred for 21 parcels, those with Parcel IDs: P104916, P15932, P15936, P16326, P17767, P21582, P29911, P31785, P35722, P36212, P39548, P41532, P52404, P57720, P57803, P58206, P60794, P68412, P70580, P73557, P74171. A perl script was written to remove the newLines and combine the split lines back together into a single line. The newLine characters were replaced with '~~' The repaired source data file is called 'AssessorData_Repaired.txt' New attributes in AssessorData.txt for 2010: AID, Inactive Date, Current Use Adjustment, Senior Exemption Adjustment. Attributes from 2009 that are not in the 2010 data: AG-MARKET-VALUE, ID, LEASE-HOLD-VALUE, MAIN-SEGMENT-DESIG. Attributes that changed names between 2009 and 2010: ACCOUNT-NO --> Account Number, NO-OF-BEDROOMS --> Number of Bedrooms, NO-OF-ROOMS --> Number of Rooms, OLD-SITUS-CSZ --> Old City State Zip, OLD-SITUS-STREET-NAME --> Old Street Name, OLD-SITUS-STREET-NUMBER --> Old Street Number, SITUS-CSZ --> Situs City State Zip, TOT-MARKET-VALUE --> Total Market Value. All attributes appear to have changed from all caps with dashes (CAP-CAP) to first letter capitalized with spaces (Upper Upper). ------------------------------ 1 parcel record in the shapefile with Shape_area and Shape_len values of 0, and no PARCELID value was not added to the database. Two parcels with PARCELID value: P65667 were aggregated, but overlap one another. The overlapping area was removed because multipart polygons cannot overlap themselves. Two parcels, one with PARCELID value: P45789, and one with no PARCELID value (OBJECTID: 564355, FID: 80356, Shape_area: 1352312.86021, Shape_len: 58652.697378) were self-intersecting when run through the Check Geometry tool in ArcToolbox. These two parcels were repaired using the Repair Geometry tool. |
| QAQC Date: | 2011-05-31 |
| QAQC Notes: | PolyID 429000031243 - matches Skagit Co website, and also matches source data file "AssessorData.txt". PolyID 429000032409 - matches source data file "AssessorData.txt". Website data values have changed, but all other data are the same. PolyID 429000060224 - matches website data and source file data. |
Tables
| Name | Notes |
| Parcels.shp | |
| AssessorData.txt | |
| Improvements.txt |
Table Relationships
| Primary Table | Primary Key | Foreign Table | Foreign Key | Cardinality | Notes |
| Parcels.shp | PARCELID | Improvements.txt | ParcelNumber | 1:many | |
| Parcels.shp | PARCELID | AssessorData.txt | Parcel Number | 1:many |
Attribute Normalization
| Table Name | Attribute | Common Field | Normalized Field | Normalization Process |
| AssessorData.txt | Account Number | Tax_Account_ID | TaxAccountID | Direct |
| AssessorData.txt | Acres | Acres_Tabular | TabularAcres | Direct |
| AssessorData.txt | Building Value | Market_Value_Improvements | MarketValueImprovements | Direct |
| AssessorData.txt | Current Use Adjustment | Exemption_Amount | TaxStatus | Concatenate PropType, Exemptions, Current Use Adjustment, Senior Exemption Adjustment |
| AssessorData.txt | Exemptions | Exemption | TaxStatus | Concatenate PropType, Exemptions, Current Use Adjustment, Senior Exemption Adjustment |
| AssessorData.txt | Impr Land Value | Market_Value_Improved_Land | MarketValueImprovedLand | Direct |
| AssessorData.txt | Land Use | Land_Use_Code | StateLandUseCode | Use LandUse_SKAG_Crosswalk |
| AssessorData.txt | Legal Description | Legal_Description | LegalDescription | Direct |
| AssessorData.txt | Levy Code | Tax_Code_Area | TaxCodeArea | Direct |
| AssessorData.txt | Owner Add 1 | Owner_Address_1 | AddressLine1 | Direct |
| AssessorData.txt | Owner Add 2 | Owner_Address_2 | AddressLine2 | Direct |
| AssessorData.txt | Owner Add 3 | Owner_Address_3 | AddressLine3 | Direct |
| AssessorData.txt | Owner City | Owner_Address_City | AddressCity | Direct |
| AssessorData.txt | Owner Name | Owner_Name | Name.Name | Direct; Owner |
| AssessorData.txt | Owner State | Owner_Address_State | AddressState | Direct |
| AssessorData.txt | Owner Zip | Owner_Address_Zip | AddressZip | Direct |
| AssessorData.txt | Parcel Number | Parcel_ID | SourceParcelID | Direct |
| AssessorData.txt | PropType | Property_Type | TaxStatus | Concatenate PropType, Exemptions, Current Use Adjustment, Senior Exemption Adjustment |
| AssessorData.txt | Quarter Section | Quarter_Section | QuarterSection | Direct |
| AssessorData.txt | Range | Range | Range | Concatenate with 'E' |
| AssessorData.txt | Section | Section | Section | Direct |
| AssessorData.txt | Senior Exemption Adjustment | Exemption_Amount | TaxStatus | Concatenate PropType, Exemptions, Current Use Adjustment, Senior Exemption Adjustment |
| AssessorData.txt | Situs City State Zip | Parcel_Address_City_State_Zip | SiteAddressFull | Concatenate Situs Street Number, Situs Street Name, Situs City State Zip |
| AssessorData.txt | Situs City State Zip | Parcel_Address_City_State_Zip | SiteAddressCity | Split on comma, take first |
| AssessorData.txt | Situs Street Name | Parcel_Address_Street | SiteAddressStreetFullName | Direct |
| AssessorData.txt | Situs Street Name | Parcel_Address_Street | SiteAddressFull | Concatenate Situs Street Number, Situs Street Name, Situs City State Zip |
| AssessorData.txt | Situs Street Number | Parcel_Address_House | SiteAddressNumber | Direct |
| AssessorData.txt | Situs Street Number | Parcel_Address_House | SiteAddressFull | Concatenate Situs Street Number, Situs Street Name, Situs City State Zip |
| AssessorData.txt | Taxable Value | Taxable_Value | TaxableValueTotal | Direct |
| AssessorData.txt | Timber Land Value | Market_Value_Timber | MarketValueTimberLand | Direct |
| AssessorData.txt | Total Market Value | Market_Value_Total | MarketValueTotal | Direct |
| AssessorData.txt | Township | Township | Township | Concatenate with 'N' |
| AssessorData.txt | Unimpr Land Value | Market_Value_Unimproved_Land | MarketValueUnimprovedLand | Direct |
| Improvements.txt | actual_year_built | Structure_Year_Built | YearBuilt | Direct |
| Improvements.txt | Bedrooms | Structure_Number_Of_Bedrooms | NumberBedrooms | Direct |
| Improvements.txt | building_style | Structure_Building_Description_Code | Description | Concatenate: building_style, ConstructionStyle, description. building_style and ConstructionStyle are codes that are mapped to a value using metadata provided by county. Both the original and mapped values are provided. |
| Improvements.txt | calc_area | Structure_Square_Feet_Improvements | SquareFeetFootprint | Direct |
| Improvements.txt | condition_cd | Structure_Building_Condition | Condition | Direct |
| Improvements.txt | ConstructionStyle | Structure_Building_Description | Description | Concatenate: building_style, ConstructionStyle, description. building_style and ConstructionStyle are codes that are mapped to a value using metadata provided by county. Both the original and mapped values are provided. |
| Improvements.txt | description | Structure_Building_Description | Description | Concatenate: building_style, ConstructionStyle, description. building_style and ConstructionStyle are codes that are mapped to a value using metadata provided by county. Both the original and mapped values are provided. |
| Improvements.txt | ExteriorWall | Structure_Siding_Material | SidingMaterial | Direct |
| Improvements.txt | Foundation | Structure_Foundation_Type | FoundationType | Mapped to a value using metadata provided by county. Both the original and mapped values are provided. |
| Improvements.txt | Foundation | Structure_Foundation_Type | Description | If Foundation in: CCP (COV CONC PRCH), CCP1 (COV CONC PRCH SHED ROOF), CCP2 (COV CONC PRCH GABLE/HIP ROOF), CD (CEDAR DECK), CWP (COV WOOD PRCH), CWP1 (COV WOOD PRCH SHED ROOF), CWP2 (COV WOOD PRCH GABLE/HIP ROOF), DECK, FD (FIR DECK), TD (TREATED WOOD DECK), WP (WOOD PORCH) -- Concatenate with: building_style, ConstructionStyle, description. |
| Improvements.txt | imprv_id | Structure_Building_Unique_Id | SourceImprovementID | Direct |
| Improvements.txt | new_const_year | Structure_Remodel_Year | YearRenovated | Direct |
| Improvements.txt | Plumbing | Structure_Number_Of_Bathrooms | NumberBathrooms | calculated from string values in FME |
| Improvements.txt | RoofCovering | Structure_Roof_Material | RoofMaterial | Direct |
| Parcels.shp | PARCELID | Parcel_ID | SourceParcelID | Direct |
| Parcels.shp | PARCELID | Parcel_ID | AssessorURL | Concatenate 'http://www.skagitcounty.net/Common/Asp/Default.asp?d=Assessor&c=Search&a=ParcelSearch&p=Results.asp&st=parcelid&sv=', PARCELID |
Lookups
| Original Field | Original Value | Normalized Value | Normalized Field |
| Land Use | StateLandUseCode | ||
| Land Use | (110) HOUSEHOLD SFR OUTSIDE CITY | 11 | StateLandUseCode |
| Land Use | (111) HOUSEHOLD, SFR, INSIDE CITY | 11 | StateLandUseCode |
| Land Use | (120) HOUSEHOLD, 2-4 UNITS | 12 | StateLandUseCode |
| Land Use | (130) HOUSEHOLD, 5+ UNITS | 13 | StateLandUseCode |
| Land Use | (140) CONDO RESIDENTIAL | 14 | StateLandUseCode |
| Land Use | (150) MOBILE HOME PARKS | 15 | StateLandUseCode |
| Land Use | (160) HOTELS, MOTELS | 16 | StateLandUseCode |
| Land Use | (170) INSTITUTIONAL LODGING | 17 | StateLandUseCode |
| Land Use | (180) MOBILE HOMES | 18 | StateLandUseCode |
| Land Use | (181) MH LEASED PROPERTY | 18 | StateLandUseCode |
| Land Use | (190) VACATION AND CABIN | 19 | StateLandUseCode |
| Land Use | (210) FOOD AND KINDRED PRODUCTS | 21 | StateLandUseCode |
| Land Use | (230) APPAREL/FINISHED PROD. FROM FABRIC/LEAT | 23 | StateLandUseCode |
| Land Use | (240) LUMBER & WOOD PRODUCTS | 24 | StateLandUseCode |
| Land Use | (250) FURNITURE & FIXTURES | 25 | StateLandUseCode |
| Land Use | (270) PRINTING & PUBLISHING | 27 | StateLandUseCode |
| Land Use | (280) CHEMICALS | 28 | StateLandUseCode |
| Land Use | (290) PETROLEUM REFINING & RELATED INDUST. | 29 | StateLandUseCode |
| Land Use | (310) LEATHER AND LEATHER PRODUCTS | 31 | StateLandUseCode |
| Land Use | (320) STONE, CLAY AND GLASS PRODUCTS | 32 | StateLandUseCode |
| Land Use | (330) PRIMARY METAL PRODUCTS | 33 | StateLandUseCode |
| Land Use | (340) FABRICATED METAL PRODUCTS | 34 | StateLandUseCode |
| Land Use | (350) PROF SCIENTIFIC/CONTROL INSTR; PHOTO & | 35 | StateLandUseCode |
| Land Use | (360) LOG DUMP | 39 | StateLandUseCode |
| Land Use | (390) LAND ZONED INDUSTRIAL WITH RESIDENCE | 18 | StateLandUseCode |
| Land Use | (410) RAILROAD TRANSPORTATION | 41 | StateLandUseCode |
| Land Use | (420) MOTOR VEHICLE TRANSPORTATION | 42 | StateLandUseCode |
| Land Use | (430) AIRCRAFT TRANSPORTATION | 43 | StateLandUseCode |
| Land Use | (440) MARINE CRAFT TRANSPORTATION | 44 | StateLandUseCode |
| Land Use | (450) HIGHWAY & STREET RIGHT OF WAY | 45 | StateLandUseCode |
| Land Use | (460) AUTOMOBILE PARKING | 46 | StateLandUseCode |
| Land Use | (470) COMMUNICATIONS | 47 | StateLandUseCode |
| Land Use | (480) UTILITIES (DIKE & DRAIN PROPERTY) | 48 | StateLandUseCode |
| Land Use | (490) OTHER TRANSPORT/COMMUNI/UTILITIES NOT E | 49 | StateLandUseCode |
| Land Use | (500) CONDOMINIUMS OTHER THAN RESIDENTIAL | 50 | StateLandUseCode |
| Land Use | (510) WHOLESALE TRADE | 51 | StateLandUseCode |
| Land Use | (520) RETAIL TRADE/BUILDING MAT./HARDWARE/FAR | 52 | StateLandUseCode |
| Land Use | (530) RETAIL TRADE, GENERAL MERCHANDISE | 53 | StateLandUseCode |
| Land Use | (540) RETAIL TRADE, FOOD | 54 | StateLandUseCode |
| Land Use | (550) RETAIL/AUTO/TIRES/MARINECRAFT/AIRCRAFT | 55 | StateLandUseCode |
| Land Use | (560) RETAIL TRADE, APPAREL & ACCESSORIES | 56 | StateLandUseCode |
| Land Use | (570) RETAIL TRADE, FURNITURE, HOME FURNISH. | 57 | StateLandUseCode |
| Land Use | (580) RETAIL TRADE, EATING & DRINKING | 58 | StateLandUseCode |
| Land Use | (590) OTHER RETAIL TRADES | 59 | StateLandUseCode |
| Land Use | (610) FINANCE, INSURANCE & REAL ESTATE | 61 | StateLandUseCode |
| Land Use | (620) PERSONAL SERVICES | 62 | StateLandUseCode |
| Land Use | (630) BUSINESS SERVICES | 63 | StateLandUseCode |
| Land Use | (640) REPAIR SERVICES | 64 | StateLandUseCode |
| Land Use | (650) PROFESSIONAL SERVICES | 65 | StateLandUseCode |
| Land Use | (660) CONTRACT CONSTRUCTION SERVICES | 66 | StateLandUseCode |
| Land Use | (670) GOVERNMENTAL SERVICES | 67 | StateLandUseCode |
| Land Use | (680) EDUCATION SERVICES (SCHOOLS) | 68 | StateLandUseCode |
| Land Use | (690) MISCELLANEOUS SERVICES | 69 | StateLandUseCode |
| Land Use | (710) CULTURAL ACTIVITIES & NATURE EXHIBITS | 71 | StateLandUseCode |
| Land Use | (720) PUBLIC ASSEMBLY | 72 | StateLandUseCode |
| Land Use | (730) AMUSEMENTS | 73 | StateLandUseCode |
| Land Use | (740) RECREATIONAL ACTIVITIES | 74 | StateLandUseCode |
| Land Use | (750) RESORTS & GROUP CAMPS | 75 | StateLandUseCode |
| Land Use | (760) PARKS | 76 | StateLandUseCode |
| Land Use | (770) CEMETARY | 77 | StateLandUseCode |
| Land Use | (790) OTHER CULTURAL/ENTERTAIN./RECREATIONAL | 79 | StateLandUseCode |
| Land Use | (810) AGRICULTURE, NON-CLASSIFIED O/S | 81 | StateLandUseCode |
| Land Use | (820) AGRICULTURE RELATED ACTIVITIES | 82 | StateLandUseCode |
| Land Use | (831) CLASSIFIED TIMBER | 88 | StateLandUseCode |
| Land Use | (840) FISHING ACTIVITIES & RELATED SERVICES | 84 | StateLandUseCode |
| Land Use | (850) MINING ACTIVITIES & RELATED SERVICES | 85 | StateLandUseCode |
| Land Use | (890) OTHER RESOURCE PRODUCTION | 89 | StateLandUseCode |
| Land Use | (910) UNIMPROVED LAND | 91 | StateLandUseCode |
| Land Use | (920) TREES | 92 | StateLandUseCode |
| Land Use | (930) WATER AREAS | 93 | StateLandUseCode |
| Land Use | (970) CONDO MOORAGE | 18 | StateLandUseCode |
| Land Use | (981) OPEN SPACE/OPEN SPACE | 94 | StateLandUseCode |
| Land Use | (982) OPEN SPACE FARM AND AG. | 83 | StateLandUseCode |
| Land Use | (983) OPEN SPACE TIMBER | 95 | StateLandUseCode |
| Land Use | (984) DESIGNATED TIMBER | 88 | StateLandUseCode |
