Department of Revenue (DOR)
Public and Community Water
Author: Steve Custer
Data Assembly:  Andrea Wright, Daryl Chipman, Luke Lohmuller, Steve Custer, Bob Snyder
(Last modified 16 June 2000; 02 January 2010)

Back to Septic Assessment Home...

Example Questions the Database Can Answer

1.  Where are the properties on public water systems? (3)
2.  Where are the properties on community water systems? (5) There are two themes:

1.  Public water (DOR Geocode (3)) shows the location of properties on public water identified by utility code 3 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 water (DOR Geocode (5)) shows the location of properties on community water identified by utility code 5 for all properites 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.

Public and community water supplies cannot be displayed.  There is no map outside the GIS. 

Glossary

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

Public water:  Property served by a municipal or public water system (code 3 on the utility field).
 

About the Data

All data is projected in Zone 12 UTM NAD83. The data source is Department of Revenue CAMAS database records of utility.  The DOR personnel indicate that this is not a validated field so errors of classification are possible particularly in the 1970s.  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 database includes a utility field which reflects public (code 3) and community (code 5) water connection.  Since this data reflects properties, it should not be used to identify water systems, but could be used to estimate locations where properties are using public or community water.  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 database.  In this database, every located geocode has a unique location.  Sometimes a property has 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) northeast.  In this way, every located geocode has a unique spatial position in the theme.

The definition of atttributes in the geocode database attribute table for DOR data is linked here.