Department of Revenue (DOR)
Public and Community Sewer
Author: Steve Custer
Data Assembly: Andrea Wright, Daryl Chipman, Luke Lohmuller,
Steve Custer, Bob Snyder
(Last modified 16 June 2000)
Back to Septic Assessment Home...
Example Questions the Database Can Answer
1. Where are the properties on public sewer systems (DOR)? (4)
2. Where are the properties on community sewer systems (DOR)?
(6)
There are two themes:
1. Public Sewer (DOR Geocode (4)) shows the location of properties
on public sewer identified by utility code 4 for all properties which could
be located on the 1995 County Road Book based on address and subdivision
block and lot data from the CAMAS data base maintained by the Department
of Revenue.
2. Community Sewer (DOR Geocode (6)) shows the location of properties
on community sewer identified by utility code 6 for all properties which
could be located on the 1995 County Road Book based on address and subdivision
block and lot data from the Camas data base maintained by the Department
of Revenue.
Interactive Map 1: Department of Revenue (DOR) Public and Community Sewer (Note: maps and data will take longer to download)
Glossary
Community Sewer: Several properties served by a single sewer
system. This data shows properties served by community water, but
not the location of the septic system (code 6 on the utility field).
Public Sewer: Property served by a municipal or public sewer system
(code 4 on the utility field).
About the Data
All data is projected in UTM NAD83. The data source is Department
of Revenue CAMAS data base records of utility. The DOR personnel
indicate that this is not a validated field so errors of classification
are possible particularly in the 1970's. The location of the points
was identified using address and/or subdivision block and lot data and
the 1995 county road book. If a point could not be located by this
method, the data was not entered. The data from the CAMAS data
base includes a utility field which reflects public (code 4) and community
(code 6) sewer connection. Since this data reflects properties, it
should not be used to identify sewer systems, but could be used to estimate
locations where a properties are using public or community sewer.
The data was obtained in 1997. The data was not field checked.
The subdivision block and lot identifications or address locations were
used in conjunction with the County Road book for all properties in the
Local Water Quality District. This theme comes from the geocode
data base. In this database, every located geocode has a unique location.
Sometimes a property has a more than one geocode at an address. Where
this occurred, a new point was "spawned" for each duplicate geocode.
The points were spawned 10 m from the original point. The first is
spawned east, the second south, the third west, the fourth north, and the
fifth (if present) north east. In this way, every located geocode
has a unique spatial position in the theme.
The definitions for attributes in the geocode
attribute table for DOR data are linked here.