Department of Revenue Utilities

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...


How to View the Data

Example Questions the Database Can Answer

  1. Where are the properties the Department of Revenue identifies as connected to a septic system?
  2. Where are the properties the Department of Revenue identifies as connected to a community sewer?
  3. Where are the properties the Department of Revenue identifies as connected to a public sewer?
  4. Where are the properties the Department of Revenue identifies as connected to a well?
  5. Where are the properties the Department of Revenue identifies as connected to community water?
  6. Where are the properties the Department of Revenue identifies as connected to public water?
  7. Where are the properties the Department of Revenue identifies as connected to gas?
The DOR utilities map shows the location of properties connected to utilities identified by utility codes  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. 

There are 7 themes:
  1. Septic system (8)
  2. Community sewer (6)
  3. Public sewer (4)
  4. Wells (7)
  5. Community Water (6)
  6. Public Water (3)
  7. Gas (9)
Interactive Map 1: DOR Utilities (Note: maps and data will take longer to download)

Glossary

Community Sewer:  Several properties served by a  single sewer system.  (code 6 on the utility field)  This data shows properties served by community water, but not the location of the septic system .

Public Sewer:  Several properties served by a municipal or public sewer system (code 4 on the utility field).  This data shows properties served by public water, but not the location of the public sewer system.

Septic:  A septic system with single connection. (code 8)

Community Water:  Several properties served by a single water system. (code 5)  This data shows properties served by community water, but does not show the location of the well or spring or reservoir.

Public Water:  Several properties served by a municipal water system.  (code 3) This data shows properties served by public water, but does not show the location of the well or spring or reservoir.

Well:  A well connected to a single property. (code 7)

Gas:  A property connected to gas.  (code 9)

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, septic systems (code 8),  community water (code 5), public water (code 3), wells (code 7),  and gas (code 9).  Since this data reflects properties with public and community water and sewer connections, the public and community water and sewer points should not be taken to signify the location of such 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 coverage 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 attribute definitions for geocshp attribute table for the DOR data base  is linked here.