Adopted by the North Carolina
Geographic Information Coordinating Committee
December 4, 1997



Geographic Data Content Standard for
Water Distribution Systems and
Sanitary Sewer Systems

VERSION 2.2


State of North Carolina
Center for Geographic Information & Analysis
301 North Wilmington Street, Suite 700
Raleigh, NC 27601-2825


April 1997




PREFACE

The use of geographic information systems (GIS) and related technology to manage vital information about our communities and regions of the state has clearly become more commonplace. Perhaps no other recent effort than the development of this document and the related project to inventory and characterize the water distribution and sanitary sewer systems in rural North Carolina is testament to the growing use of GIS. Through this project, numerous elected officials, town managers, and others from non-urban regions of the state have been exposed to the value of using GIS for managing and understanding large and complex amounts of detailed information. Many are now beginning to use GIS data to help maintain future safe drinking water supplies and to develop environmentally responsible waste treatment plans in hopes to spur or ensure continued economic growth in their communities.

This standard is primarily intended to serve as a specification for the statewide water and sewer inventory project conducted by the North Carolina Rural Economic Development Center and the Western Piedmont Council of Governments. It is anticipated that the standard will be used to provide a basis for continued maintenance of the inventory and by others that develop and manage data about water and sewer infrastructures.

The development of this standard evolved over many months and its content reflects "in the field" experiences of staff from the Rural Center, McGill & Associates, and the Western Piedmont Council of Governments. The experiences shared from the field were important and significantly improved the document from its first draft.

We expect that many will consider and use the standard as developed and we certainly anticipate that they also will provide their insights and requirements back to us so that subsequent versions of the document are valuable to the community at large.

Zsolt Nagy,
North Carolina Center for Geographic Information & Analysis

John Soles,
North Carolina Rural Development Council
Rural Economic Development Center, Inc.

Francine Stephenson
North Carolina Office of State Planning




ACKNOWLEDGMENTS

Many served to launch this initiative and provided feedback on specific aspects of this document. The following is a list of key project participants the authors wish to recognize.

DeWitt Blackwell, Western Piedmont Council of Governments
Billy Ray Hall, N.C. Rural Economic Development Center
Kenneth Flowers, N.C. Rural Development Council
Karen Siderelis, Center for Geographic Information and Analysis

Dana Bolden, McGill & Associates
Faith Hege, Western Piedmont Council of Governments
Mike Williams, Western Piedmont Council of Governments
Neil Thomas, Resource Data, Inc.
David Giordano, Center for Geographic Information and Analysis
Cathy Bock, Rural Economic Development Center, Inc.
Eddie Staley, Hobbs, Upchurch and Associates



Funding and support provided by the
Western Piedmont Council of Governments and the
North Carolina Rural Economic Development Center, Inc.
Research and Demonstration Grants Program.




TABLE OF CONTENTS

Section 1: Introduction
Background
Objective
Geographic Information Coordinating Council
Corporate Geographic Database

Section 2: Content Standards - General
Methodology
Document
Participants

Section 3: Content Standards - Water Distribution Systems
Definition
Geometric Representation
Geographic Coordinate System, Datum, and Unit of Measurement
Annotation
Metadata
Symbology
Attributes
Summary of Attributes
Definition of Attribute Fields

Section 4: Content Standards - Sanitary Sewer Systems
Definition
Geometric Representation
Geographic Coordinate System, Datum, and Unit of Measurement
Annotation
Metadata
Symbology
Attributes
Summary of Attributes
Definition of Attribute Fields

Section 5: Content Standards - Supplementary Owner Information

Glossary of Terms


Lists
List 1 - Listing of Corporate Geographic Data Layers
List 2 - Summary of Water Distribution Systems Attribute Fields
List 3 - Summary of Sanitary Sewer Systems Attribute Fields
List 4 - Summary of Supplementary System Owner Information

Tables
Table 1 - Definitions of Attribute Fields for Water Distribution Systems
Table 2 - Definitions of Attribute Fields for Sanitary Sewer Systems
Table 3 - Definitions of Attribute Fields for Owners




SECTION 1: INTRODUCTION

Background

The availability of safe drinking water supplies and the ability to economically treat, process, sanitize, and return treated sewerage into the state's rivers and lakes are critical issues for citizens of North Carolina as we approach the next millennium. Thorough knowledge about the location, condition, and capacity of water distribution and sanitary sewer systems and information about the projected need for these systems throughout the state is vital. Federal, state and local officials, planners, and engineers are in need of reliable and comprehensive information that can be used to manage the current infrastructure and plan for the future.

In response to this need, a detailed inventory of all water and sewer systems in North Carolina and an assessment of needs for expansion and development of new systems has been launched by the Rural Economic Development Center. Information collected in this project will be stored and maintained in the North Carolina Corporate Geographic Database, a collection of strategic geographic information.

Two agencies, the Western Piedmont Council of Government, and the North Carolina Rural Economic Development Center, agreed to cooperate with the North Carolina Center for Geographic Information and Analysis (CGIA) on the development of this water distribution and sanitary sewer systems geographic data content standard. This document is being used in the project as the data content specifications for the statewide geographic data layer on water and sewer systems.

The information will be accessible through the use of geographic information systems technology. Geographic information systems (GIS) are now being used by many public and private organizations to manage information, analyze, predict, and assist with human and natural activities on the earth. GIS is a technology that has grown in popularity over the past several years and is now being used by more than 53 counties in North Carolina, many lead regional organizations, all state departments, many federal organizations, and many private businesses and utilities.


Objective

The objective of this effort is to develop a geographic data content standard for use in the development of a statewide geographic dataset for water distribution and sanitary sewer systems in rural North Carolina. With the guidance and oversight of the Geographic Information Coordinating Council, North Carolina has implemented a strategic plan to guide the growth of geographic information systems, geographic information, and related technologies. An important aspect of the strategic plan is the development of data and technology standards.

This geographic data content standard is intended to be the basis for the development of a statewide data layer, as a component of the North Carolina Corporate Geographic Database, for water distribution and sanitary sewer systems. The standard is intended to represent the minimum requirements of data content for all organizations planning, building, and/or maintaining geographic data about water distribution and sanitary sewer systems.


Geographic Information Coordinating Council

Established by Executive Order Number 16 in May 1993, the North Carolina Geographic Information Coordinating Council (GICC) is responsible for the oversight and cost-effective development, management, and utilization of geographic information, geographic information systems and other related technologies in the state. The GICC is specifically responsible for (a) strategic planning, (b) resolution of policy and technology issues, (c) coordination, direction and oversight, and (d) advising the Governor, the Legislature, and the Information Resource Management Commission as to the needed directions, responsibilities, and funding regarding geographic information.

The statewide initiative to coordinate the growth and use of geographic information systems involves the cooperation of state, federal, and local government agencies; academic institutions; and the private sector. The initiative is intended to improve the quality, access, and utility of North Carolina's geographic information and to promote geographic information as a strategic resource in the state.

Adopted by the Council in August 1994, the Strategic Plan for Geographic Information Coordination in North Carolina forms the basis for the implementation of the coordination effort. Three major outcomes are expected from the implementation of the Strategic Plan. The outcomes are:

1) A GIS Partnership Program, to forge a cohesive system of relationships among organizations in the state to collaborate as partners in the collection, maintenance and use of geographic information;

2) The Geographic Data Clearinghouse, a comprehensive directory that describes data available in the Corporate Geographic database and which is accessed using current telecommunications networks;

3) The Corporate Geographic Database, a statewide strategic resource that contains information about the state and which will be distributed, used, and maintained through partnerships using advanced telecommunication networks.


Corporate Geographic Database

The North Carolina Corporate Geographic Database is a statewide strategic resource containing an abundant supply of information about North Carolina. For example, the content of the Corporate Geographic Database (CGDB) includes information about North Carolina's cultural resources, surface waters, topography, jurisdictional boundaries, environmental regulations, land cover, streets and highways, demographics, and natural resources. Each category of data is geo-referenced, described, and managed in data layers. The data layers are produced, maintained, accessed, distributed, and otherwise used by government and private organizations for a number of purposes. Table 1 contains a listing of data layers in the corporate geographic database.

The type and volume of information stored in the CGDB continues to expand. It is anticipated that parts of the database will be provided from many organizations outside of state government. Local and regional government organizations, federal agencies, utilities, and other private and non-profit entities are encouraged to participate in the development and maintenance of new data for the CGDB. These data will be managed and accessible using high speed telecommunications technology, like the North Carolina Information Highway. The data will be centrally coordinated, yet physically distributed on the network.

The Corporate Geographic Database is a logical location for a statewide water distribution and sewer systems data layer, since it will be best used in combination with many other layers that are contained in the database.


List 1: Data Listing of the North Carolina Corporate Geographic Database

1970 Census Boundaries/Population
1980 Census Boundaries/Population
1990 Census Summary Tape File 1B
1990 TIGER/Line Census Files
Air Quality Pollution Discharge Points
Ambient Water Quality Monitoring Sites
Anadromous Fish Spawning Areas
Artificial Marine Reefs
Beach Access Sites
Bottom Sediment Sampling Sites
Boundaries - County (1:100,000-scale)
Boundaries - Municipal 1994 Powell Bill
Boundaries - Municipal (1:100,000-scale)
Citizen Water Quality Monitoring Sites
Closed Shellfish Harvesting Areas
Coastal Area Management Act (CAMA) -
Major Development Permits
Coastal Marinas
Coastal Reserves
Digital Orthophoto Quarter Quadrangles
Federal Land Ownership
Fisheries Nursery Areas
Geodetic Control Points
Geology - NC
Groundwater Recharge/Discharge
Hazardous Waste Facilities
Heavy Metals and Organic-Rich Mud Pollutant -
Sample Sites
High Quality Water and Outstanding Resource -
Water Management Zones, Division of Water Quality
Historic Sites & Districts (authorized use)
Hurricane Storm Surge Inundation -
Areas (1987)
Hurricane Storm Surge Inundation -
Areas (1993)
Hydrogeology - NC Piedmont and Blue Ridge
Hydrography (1:24,000-scale)
Hydrography (1:100,000-scale)
Hydrography - Major
Hydrologic Units - NC
Hydrologic Units - VA
Jurisdictional Boundaries (1:24,000-scale)
Land Use / Land Cover
Military Air Space
National Pollutant Discharge Elimination -
System Sites (NPDES)
National Wetlands Inventory (NWI)
Natural Areas (authorized use)
Natural Heritage Element Occurrence Sites -
(authorized use)
Peat Deposits of the Pamlimarle Peninsula
Proposed Critical Habitat Areas
Shellfish Strata (1:12,000-scale)
Shoreline (1:24,000-scale)
Soils - Detailed County Surveys
Soils - NC General
Soils - VA General
Solid Waste Facilities
Spiny Mussels
State-Owned Complexes
State Parks
Stream Gaging Stations
Submersed Rooted Vasculars (SRV)
Surface Water Intakes
Topography - Contours
Transportation - Pipe and Transmission -
(1:24,000-scale)
Transportation - Pipe and Transmission -
(1:100,000-scale)
Transportation - Primary Roads
Transportation - Railroads (1:24,000-scale)
Transportation - Railroads (1:100,000-scale)
Transportation - Roads and Trails (1:24,000)
Transportation - Roads and Trails (1:100,000)
Water Supply Watersheds
Wildlife Resources Commission Game Lands




SECTION 2: Content Standards

Methodology

Development of the data content standard has occurred in several phases.

Phase one activity consisted of an assessment of information needs through an informal survey and through two facilitated workshops. Information needs were identified by a variety of potential data users, including public officials, resource managers, and professional engineers. Phase two activity consisted of the collection and assessment of other water and sewer systems standards and an assessment of existing geographic data files containing features pertaining to water and sewer systems. Phase three activity is an implementation of the standard by two organizations in the state. The working content standard is being used in the development of geographic data files by the Rural Economic Development Center and the Western Piedmont Council of Government. Reaction to the standard in the field by both organizations has been an important aspect of the development and refinement of the document.

Document

This document was prepared under a research and demonstration grant provided to the Western Piedmont Council of Governments by the Rural Economic Development Center, Inc. in support of the collaborative efforts with the NC Rural Development Council, the US Department of Agriculture, and the Office of the Governor's "NC Water and Sewer Inventory and Needs Assessment Project."

The document has been prepared for immediate use by all organizations that plan to implement digital geographic water and sewer inventory projects in the state. The standard is subject to change based on a comment period and a committee review process. The content standard will be submitted to the Council for official consideration in September 1996.

Participants

An advisory committee consisting of state, regional, and local representatives familiar with the delivery and management of water and sanitary sewer systems were assembled for two information requirement sessions. The advisory committee also includes several members that are very familiar with the operations and management of data using geographic information systems and related technologies.

Advisory Committee Members
E.H. Alexander REDC Board of Directors, Infrastructure Committee
E. Lee Armour Centralina Council of Governments
DeWitt Blackwell Western Piedmont Council of Governments
Bobby Blowe N.C. Division of Environmental Management
Steven Dear N.C. Rural Assistance Project, Inc.
Bill Gibson Southwestern N.C. Planning and Economic Development Commission
Ronald Goswick Kerr-Tar Regional Council
Wayne Jenkins Northampton County Public Works, N.C.
Buck Kennedy The Wooten Company
Al Leonard Town of Tabor City
Herman Little Anson County Commissioner
Rose Ann Mack Cape Fear Council of Governments
Gary McGill McGill Associates, P.A.
David Muse City of New Bern
Lynn Norton Alexander Water Corporation
Jerry Perkins N.C. Division of Environmental Health
Ed Regan N.C. Association of County Commissioners
Bob Schley N.C. Rural Water Association
Edgar R. Shuller N.C. Department of Transportation
Karen Siderelis N.C. Center for Geographic Information and Analysis
Paula Thomas N.C. League of Municipalities
Bobby White Burke County
Zettie Williams Duplin County Commissioner


SECTION 3: Content Standard - Water Distribution Systems

Definition

The Water Distribution Systems (WDS) dataset includes information about the primary facilities, mechanical components, and distribution lines that serve as a delivery system for drinking water. The WDS dataset includes a delineation of the service area boundary of each water distribution system. It also contains features of the locations of important mechanical components for the delivery of drinking water from a drinking water supply source to the curbside valve for customers in the system. The database contains attributes that describe all or portions of each component of the system.

Three types of water distribution systems exist for the digital water distribution system inventory: Type A, Type B, and Type P. Type A systems are generally considered large systems and are represented in the dataset as a service area with a variety of components. The components included in Type A systems are: water distribution pipes, groundwater wells, surface water intakes, water tanks, pumping stations, treatment plants, and master meters.

Type B systems are generally smaller and are represented in the dataset as a service area. Type B systems will be delineated by boundaries and stored as polygonal features. Pipes and components are not required for the Type B systems.

Type P systems represent "proposed" expansion areas or "proposed" new systems. Type P systems will be delineated by boundaries and stored as polygonal features. Pipes and mechanical components are not included in the mapping for Type P systems.

Type A, B, and P systems are defined as follows:

Type A Water System

Water Systems defined as public "Community Water Systems" by the NC Department of Environment, Health, and Natural Resources are classified as Type A Water Systems. Type A Water Systems are existing systems for provision to the public of piped water for human consumption which serve fifteen (15) or more connections or which regularly serve at least 25 year- round residents.

Type B Water System

Type B Water Systems are existing systems defined as public "Community Water Systems", which generally represent small private, mobile home, multi-family housing or single subdivision systems and have very limited potential future economic development impact.

Type P Water System

Type P Water Systems are planned or proposed public community water system service areas where public systems do not currently exist and are outside of current service area boundaries. Type P system are areas which have been identified as having sufficient need and population density to support viable public systems and which have an existing minimum potential user density of 20 existing potential connections per mile of waterline.

The dataset for the water distribution system contains a large amount of descriptive information about each component and the service area. The descriptive information is contained in attribute tables that are linked to each geographic feature in the database. The attribute contents of the water distribution systems geographic dataset are listed in the Attribute Listing for Water Distribution Systems beginning on page 9. Attribute data field names and domain values are itemized for the Water Distribution Systems dataset in Table 1 beginning on page 12. Additional system owner information is stored in a table described in Section 5 on page 38.


Geometric Representation

Water Distribution System (Type A, Type B and P) service areas are to be delineated by boundaries and in the geometric form of one or more contiguous or non-contiguous polygons. Type A, B, and P systems will be stored in separate geographic data files. In circumstances where systems are small and can only be delineated by a point, a polygon is to be generated using a radius of 50 feet.

Mechanical components of the Water Distribution System - Type A are to be delineated as either lines or points. Pipelines will be collected and stored as lines in one geographic data file. Facilities/devices will be collected and stored as points in a separate geographic data file for each facility/device type.

All geographic data files are to be topological.


Geographic Coordinate System, Datum, and Unit of Measure

The water distribution systems datasets will be geo-referenced using the N.C. State Plane Coordinate System (NAD83).

The unit of measurement will be metric.


Annotation

Specifications for annotation of facilities and pipes for this dataset are not included in the standard. All relevant information for each feature is assumed to be recorded as an attribute in the database. Annotation, if desired, should be considered as an optional specification for consideration at the time of data collection or maintenance.


Metadata

Metadata, or data about data, are required for each geographic dataset. Beginning January 1995, all federal organizations involved in the development of geographic data must comply with the Federal Geographic Data Committee's (FGDC) Content Standards for Digital Geospatial Metadata. The FGDC Standard has been adopted by the North Carolina Geographic Information Coordinating Council and is now required for all data submitted to the North Carolina Corporate Geographic Database. The Center for Geographic Information and Analysis has implemented the Federal Content Standard for Digital Geospatial Metadata for all datasets currently in the Corporate Geographic Database and will assist in the development of complete metadata for corporate data layers.


Symbology

Graphic symbols of facilities and pipes for this data layer are not included in the standard. Symbology is considered a product generation standard and not a content issue. However, all relevant information pertaining to symbology are presumed to be recorded as an attribute in the database. Symbology should be considered as an optional specification for consideration at the time of product generation.


Attributes

Physical characteristics and descriptive information about each system and component are contained within the attribute table of each data file. Geometric features such as polygons, lines, nodes, and points identify the location or boundary of a feature in the dataset. An attribute or a set of attributes describe each feature in the dataset. Attribute field names, data type, field domain, and additional comments are described in Table 1 - Attribute Names, Field Definitions, and Supplementary Data Definitions for Water Distribution System Features. A list of all descriptive information for the Water Distribution Systems Dataset follows:


List 2 - Summary of Water Distribution Systems Attribute Fields

Water Distribution Systems - Type A
System Identification Number
Name of System
Owner Identification Number
Part Indicator
Total Parts
Original Construction Year
Description of Service Area
Supply Sources
Customer Connections - Residential
Customer Connections - Non-Residential
Customer Connections - Bulk Purchasers
Maximum Daily Usage
Average Daily Usage
User Charges - Residential
User Charges - Non-Residential
User Charges - Bulk Purchasers
Average Monthly Usage Per Customer - Residential
Average Monthly Usage Per Customer - Non-Residential
Average Monthly Usage Per Customer - Bulk Purchasers
Inter Basin Transfer
Problems and Needs
Recommendations
Improvement Cost
Expansion Indicator
Maximum Daily Usage - FY2000
Maximum Daily Usage - FY2010
Maximum Daily Usage - FY2020
Average Daily Usage - FY2000
Average Daily Usage - FY2010
Average Daily Usage - FY2020

Water Distribution System - Type B Service Areas
System Identification Number
Name of System
Population Served
Contact Person
Contact Telephone

Water Distribution System - Type P Service Areas
System Identification Number
Parent ID
New Cost

Water Distribution System Pipes
System Identification Number
Original Construction Year
Renovation Year - Most Recent
Material
Diameter

Wells, Groundwater Intakes
Groundwater Intake Well Identification Number
Original Construction Year
Renovation - Most Recent
Safe Yield

Intakes, Surface Water
Surface Water Intake - ID
Surface Water Intake - Year of Original Installation
Surface Water Intake - Year of Most Recent Renovation
Surface Water Intake Flow Capacity

Water Storage Tanks
Water Storage Tank - ID
Water Storage Tank Location Descriptor
Water Storage Tank Year of Original Construction
Water Storage Tank Year of Most Recent Renovation
Water Storage Tank Type
Water Storage Tank Utilization
Water Storage Tank Material
Water Storage Tank Bottom Elevation
Water Storage Tank Overflow Elevation
Water Storage Tank Storage Capacity

Water Pumping Stations
Water Pumping Station ID
Water Pumping Station Location Descriptor
Water Pumping Station Year of Original Construction
Water Pumping Station Year of Most Recent Renovation
Water Pumping Station Pumping Capacity

Water Treatment Plants
Water Treatment Plant ID
Water Treatment Plant Year of Original Construction
Water Treatment Plant Year of Most Recent Renovation
Water Treatment Plant Permitted Plant Capacity
Water Treatment Plant Maximum Daily Production
Water Treatment Plant Average Daily Production
Water Treatment Plant Type of Water Treatment Technology
Water Treatment Plant Estimated Area

Master Meters
Master Meter ID
Master Meter Year of Original Construction
Master Meter Year of Most Recent Renovation
Master Meter Size
Master Meter Maximum Available for Purchase Daily

Table 1- Definitions of Attribute Fields for Water Distribution Systems

POLYGON ATTRIBUTES



Feature Category Attribute Data Field Name Data Type Domain and Units Comments
Water System - Type A


Boundary of legally defined service area, including additional areas being served. Exclude outside areas for which service is planned; these are P systems. Exclude area surrounding intake mains where no customers exist.

System ID WASYID Text7 characters Public Water Supply Permit Number (retain leading zero(s))

Name of System WASYNAME Text50 characters

Owner ID (One) WSSYOW1 Text00000 - 99999 Assign unique number for each within state. Owner ID may be same for a water and a sewer system. Use supplementary table 'TOWNER' for additional information about system owners.

Owner ID (Second, if applicable) WSSYOW2 Text00000 - 99999 Additional Owner ID, if multiple owners

Owner ID (Third, if applicable) WSSYOW3 Text00000 - 99999 Additional Owner ID, if multiple owners

Owner ID (Fourth, if applicable) WSSYOW4 Text00000 - 99999 Additional Owner ID, if multiple owners

Owner ID (Fifth, if applicable) WSSYOW5 Text00000 - 99999 Additional Owner ID, if multiple owners

Part Indicator WASYPART Integer1,2,3,4,5,6,7,8,or 9 If the information for any field in polygon attributes has possible multiple values (for different parts of the whole), then the system must be characterized as separate systems that form parts of the whole and each part makes separate record(s).

Total Parts WASYTOPT Integer1,2,3,4,5,6,7,8,or 9 Total parts in entire system. See Part Indicator.

Original Construction Year WASYCSTR Integer4 digits Exclusive of pipes. Use closest decade if exact year is unknown (e.g., if the original construction year was sometime between 1965 and 1970, specify "1970"; likewise if you believe it to be sometime between 1960 and 1964, specify "1960").

Description of Service Area WASYDESC Text50 characters Brief description of extent of service area. Must cover area for which permit is issued.

Supply Sources WASYSUPP Text50 characters Brief list of all supply sources by name, separated by commas.

Customer Connections - Residential WASYCCR Integer000000 - 999999 Number of residential customer connections for finished water, most recent June 30th. "0" if none, "999999" if unknown.

Customer Connections - Non-Residential WASYCCNR Integer000000 - 999999 Number of non-residential customer connections for finished water, most recent June 30th. "0" if none, "999999" if unknown.

Customer Connections - Bulk Purchasers WASYCCBP Integer000000 - 999999 Number of bulk purchaser connections for finished water, most recent June 30th. "0" if none, "999999" if unknown.

Maximum Daily Usage WASYMAXD Numeric000.000 - 999.999 millions of gallons per day Maximum daily usage during fiscal year ending most recent June 30. "0" if none, "999.999" if unknown.

Average Daily Usage WASYAVGD Numeric000.000 - 999.999 millions of gallons per day Average daily usage during fiscal year ending most recent June 30. "0" if none, "999.999" if unknown

User Charges - Residential WASYCGR Numeric000.00 - 999.99 dollars Average monthly charge per customer for fiscal year ending last June 30. Average of 12 months, each calculated as total monthly charges divided by monthly number of customers. Omit dollar sign. "0" if none, "999.99" if unknown.

User Charges - Non-Residential WASYCGNR Numeric9999999.99 dollars Average monthly charge per customer for fiscal year ending last June 30. Average of 12 months, each calculated as total monthly charges divided by monthly number of customers. "0" if none, "9999999.99" if unknown.

User Charges - Bulk Purchaser WASYCGBP Numeric9999999.99 dollars Average monthly charge per bulk purchaser connection for fiscal year ending last June 30. Average of 12 months, each calculated as total monthly charges divided by monthly number of bulk purchaser connections. "0" if none, "9999999.99" if unknown.

Average Monthly Usage Per Customer - Residential WASYAMR Integer999999 gallons per month Average monthly usage per customer for fiscal year ending last June 30. Average of 12 months, each calculated as total monthly usage divided by monthly number of customers. "0" if none, "999999" if unknown

Average Monthly Usage Per Customer - Non-Residential WASYAMNR Integer000000000-999999999 gallons per month Average monthly usage per customer for fiscal year ending last June 30. Average of 12 months, each calculated as total monthly usage divided by monthly number of customers. "0" if none, "999999999" if unknown

Average Monthly Usage Per Customer - Bulk Purchaser WASYAMBP Integer000000000-999999999 gallons per month Average monthly usage per bulk purchaser connection for fiscal year ending last June 30. Average of 12 months, each calculated as total monthly usage divided by monthly number of bulk purchaser connections. "0" if none, "999999999" if unknown

Inter-Basin Transfer WASYIBTR textY or N Yes (Y) if there is transfer of water from one water basin to another by this water distribution system. Otherwise, no (N).

Problems and Needs WPRJNEED text254 characters Brief narrative documenting current conditions, problems, and needs, citing compliance with federal standards.

Recommenda-
tions
WPRJREC text254 characters Brief narrative listing recommendations for improving the system

Improvement Cost WPRJCOST Integer0000000 - 9999999 thousands of dollars Estimated cost in current dollars to implement recommendations for improving the system including expansion within current service area boundary (excluding any plans for expanding service area boundaries).

Expansion Indicator WPRJEXP textY or N Yes, if recommend expanding current service area boundaries of this system. Otherwise, no.

Maximum Daily Usage - 2000 WPRJMU00 Numeric000.000 - 999.999 millions of gallons per day Projected maximum daily usage during fiscal year ending June 30, 2000. "999.999" if unknown

Maximum Daily Usage - 2010 WPRJMU10 Numeric000.000 - 999.999 millions of gallons per day Projected maximum daily usage during fiscal year ending June 30, 2010. "999.999" if unknown

Maximum Daily Usage - 2020 WPRJMU20 Numeric000.000 - 999.999 millions of gallons per day Projected maximum daily usage during fiscal year ending June 30, 2020. "999.999" if unknown

Average Daily Usage - 2000 WPRJAU00 Numeric000.000 - 999.999 millions of gallons per day Projected average daily during fiscal year ending June 30, 2000. "999.999" if unknown

Average Daily Usage - 2010 WPRJAU10 Numeric000.000 - 999.999 millions of gallons per day Projected average daily usage during fiscal year ending June 30, 2010. "999.999" if unknown

Average Daily Usage - 2020 WPRJAU20 Numeric000.000 - 999.999 millions of gallons per day Projected average daily usage during fiscal year ending June 30, 2020. "999.999" if unknown
Water System - Type B

All Type B systems will be recorded as polygons, regardless of size. Systems too small to outline should be represented as a circle with a 50 foot radius.

System ID WBSYID Text7 characters Public Water Supply permit number.

Name of System WBSYNAME Text50 characters

Population Served WBSYPOP Integer000000 - 999999 persons Estimate if unknown

Contact Person WBSYCONT Text25 characters First name and last name, no titles or middle names.

Contact Telephone WBSYPHON Textxxx-xxx-xxxx
Water System - Type P

Boundary determined by current need and viability. Includes contiguous areas (outside any current water system service area) that average at least 20 existing potential connections per linear highway/street mile. May or may not abut existing system(s).

System ID WPSYID Text7 characters First digit is a 9, the next three are county FIPS code (primary county if crosses counties), and the final three set as desired, to avoid duplicating an existing system ID. Initial 9 indicates "new" or "P" system.

Parent ID WPSYPAR Text7 characters ID of parent system, if this is a proposed expansion outside service area of a current system. Otherwise blank.

New Cost WPSYCOST Numeric000000.0 - 999999.9 in thousands of dollars Cost in current dollars to put proposed system in place. Customer pool for driving cost estimates is to be derived from projections of population growth rates since 1970.
ARC ATTRIBUTES



Feature Category Attribute Data Field Name Data Type Domain and Units Comments
Water Pipes



A new pipe segment is designated each time any pipe attribute changes. A segment of pipe may include many vertices.

System ID WASYID Text7 characters Public Water Supply Permit Number (retain leading zero(s))

Original Construction Year WAPICSTR Integer4 digits Use closest decade if exact year is unknown (e.g., if the original construction year was sometime between 1965 and 1970, specify "1970"; likewise if you believe it to be sometime between 1960 and 1964, specify "1960"). "9999" if unknown.

Renovation - Most Recent WAPIRENV Integer4 digits Estimate of the year (or decade) of the most recent renovation. Renovation is replacement or substantial repair/renovation of at least 400 linear ft. Renovation may require inserting nodes to create additional segments. "0" if none, "9999" if unknown.

Material WAPIMATR Textasbestos cement, cast iron, concrete, copper, ductile iron, galvanized steel, polystyrene, polyvinyl chloride, steel, unknown, other. 25 characters Material currently in place. Declare one material type, exactly as shown

Diameter WAPIDIAM Integer00 - 99 inches For systems owned by public entities, all pipes 6 inches and larger must be reported. For systems owned by other than public entities, all pipes 2 inches and larger must be reported. Smaller pipes may be reported. "99" if unknown.
POINT ATTRIBUTES



Feature Category Attribute Data Field Name Data Type Domain and Units Comments
Wells, Groundwater Intake

Component of Type A systems

ID, Groundwater Well WAWEID Text13 characters First three digits are FIPS county code; next 7 digits are water system ID, last 3 digits are assigned to be unique within county.

Original Construction Year WAWECSTR Integer4 digits Use closest decade if exact year is unknown (e.g., if the original construction year was sometime between 1965 and 1970, specify "1970"; likewise if you believe it to be sometime between 1960 and 1964, specify "1960"). "9999" if unknown

Renovation - Most Recent WAWERENV Integer4 digits Estimate of the year (or decade) of the most recent renovation. "0" if none, "9999" if unknown

Safe Yield WAWEYELD Numeric000.000 - 999.999 mgd If water is purchased, there may be no well data and no safe yield. "0" if none, "999.999" if unknown
Intakes, Surface Water

Component of Type A systems

ID, Surface Water Intakes WAINID Text13 characters First three digits are FIPS county code; next 7 digits are water system ID, last 3 digits are assigned to be unique within county.

Original Construction Year WAINCSTR Integer4 digits Use closest decade if exact year is unknown (e.g., if the original construction year was sometime between 1965 and 1970, specify "1970"; likewise if you believe it to be sometime between 1960 and 1964, specify "1960"). "9999" if unknown

Renovation - Most Recent WAINRENV Integer4 digits Estimate of the year (or decade) of the most recent renovation. "0" if none, "9999" if unknown

Flow Capacity WAINFLOW Numeric000.000 - 999.999 mgd 7 day/10 year low flow
Water Storage Tanks

Component of Type A systems

ID, Water Tanks WATKID Text13 characters First three digits are FIPS county code; next 7 digits are water system ID, last 3 digits are assigned to be unique within county.

Location Descriptor WATKLOC Text20 characters Name of area of location.

Original Construction Year WATKCSTR Integer4 digits Use closest decade if exact year is unknown (e.g., if the original construction year was sometime between 1965 and 1970, specify "1970"; likewise if you believe it to be sometime between 1960 and 1964, specify "1960"). "9999" if unknown

Renovation - Most Recent WATKRENV Integer4 digits Estimate of the year (or decade) of the most recent renovation. "0" if none, "9999" if unknown

Type WATKTYPE Textelevated, hydro-pneumatic, ground storage, other, unknown. 25 characters Use one option for type, exactly as shown

Utilization WATKUTIL Textraw water, finished water. 25 characters Use one option for type, exactly as shown

Construction Material WATKMATR Textmetal, concrete, pond, lake, reservoir, other, unknown. 15 characters Use one option for type, exactly as shown

Elevation, Bottom WATKEBOT Numeric00000.0 - 99999.9 feet above mean sea level "99999.9" if unknown. Use 0.0 if WATKTYPE is hydropneumatic.

Elevation, Overflow WATKEOFL Numeric00000.0 - 99999.9 feet above mean sea level 99999.9 if unknown. Use 0.0 if WATKTYPE is hydropneumatic.

Storage Capacity WATKCPTY Numeric000.000 - 999.999 millions of gallons 999.999 if unknown
Water Pumping Stations

Component of Type A systems

ID, Pumping Stations WAPSID Text13 characters First three digits are FIPS county code; next 7 digits are water system ID, last 3 digits are assigned to be unique within county.

Location Descriptor WAPSLOC Text50 characters Name of area of location.

Original Construction Year WAPSCSTR Integer4 digits Use closest decade if exact year is unknown (e.g., if the original construction year was sometime between 1965 and 1970, specify "1970"; likewise if you believe it to be sometime between 1960 and 1964, specify "1960"). "9999" if unknown

Renovation - Most Recent WAPSRENV Integer4 digits Estimate of the year (or decade) of the most recent renovation. "0" if none, "9999" if unknown

Pumping Capacity WAPSCPTY Numeric000000.0 - 999999.9 gallons per minute "999999.9" if unknown
Water Treatment Plants

Component of Type A systems.

ID, Treatment Plants WATPID Text13 characters First three digits are FIPS county code; next 7 digits are water system ID, last 3 digits are assigned to be unique within county.

Original Construction Year WATPCSTR Integer4 digits Use closest decade if exact year is unknown (e.g., if the original construction year was sometime between 1965 and 1970, specify "1970"; likewise if you believe it to be sometime between 1960 and 1964, specify "1960"). "9999" if unknown

Renovation - Most Recent WATPRENV Integer4 digits Estimate of the year (or decade) of the most recent renovation. "0" if none, "9999" if unknown.

Permitted Plant Capacity WATPCPTY Numeric000.000 - 999.999 millions of gallons per day "999.999 if unknown

Maximum Daily Production WATPMDP Numeric000.000 - 999.999 millions of gallons per day 999.999 if unknown

Average Daily Production WATPADP Numeric000.000 - 999.999 millions of gallons per day 999.999 if unknown

Type of Water Treatment Technology WATPTRMT TextGround water w. disinfection, ground water w. reverse osmosis, ground water w. softener, ground water w. iron remover, ground water w. softener and iron removal, surface water w. direct filter, surface water w. coagulation, sedimentation and filter, other Description of treatment type up to 100 characters. Use one or more options, exactly as shown. Also, use "unknown" if unknown.

Estimated Area WATPAREA Numeric00000.00 - 99999.99 acres Estimate of area of water treatment plant. "99999.99" if unknown.
Master Meters

Component of Type A systems

ID, Master Meters WAMMID Text13 characters First three digits are FIPS county code; next 7 digits are water system ID, last 3 digits are assigned to be unique within county.

Original Construction Year WAMMCSTR Integer4 digits Use closest decade if exact year is unknown (e.g., if the original construction year was sometime between 1965 and 1970, specify "1970"; likewise if you believe it to be sometime between 1960 and 1964, specify "1960"). "9999" if unknown.

Renovation - Most Recent WAMMRENV Integer4 digits Estimate of the year (or decade) of the most recent renovation. "0" if none, "9999" if unknown.

Size WAMMSIZE Integer00-99 inches

Max. Available for Purchase, Daily WAMMMAAV Numeric000.000 - 999.999 million gallons per day Maximum daily amount of water available for purchase at this meter site. "999.999 if unknown.
Hydrants (Optional)

Component of Type A systems. Locational data for this attribute are optional.


SECTION 4: Content Standard - Sanitary Sewer Systems

Definition

The Sanitary Sewer Systems (SSS) dataset includes information about the primary facilities, mechanical components, and collection lines that function as a discharge and treatment system for sewerage. The SSS dataset includes a delineation of the service area boundary of each sanitary sewer system. It also contains features of the locations of important mechanical components for the delivery and treatment of sewerage from the curbside connection point to the site where treated sewerage is released back into the natural environment. The database contains attributes that describe all or portions of each component of the system.

Three types of sanitary sewer systems exist for the digital sanitary sewer system inventory: Type A, Type B, and Type P. Type A systems are generally considered large systems and are represented in the dataset by a service area with a variety of system components. The components included in Type A systems are: sewer pipes, pumping stations, treatment plants, discharges, and land application areas.

Type B systems are generally smaller and are represented in the dataset as a service area. Type B systems will be delineated by boundaries and stored as polygonal features. Pipes and components are not required for the Type B systems.

Type P systems represent "proposed" expansion areas or "proposed" new systems. Type P systems will be delineated by boundaries and stored as polygonal features. Pipes and mechanical components are not included in the mapping for Type P systems.

Type A, B, and P systems are defined as follows:

Type A Sewerage Systems

Existing community sanitary sewer systems including collection lines, transport lines or pumping and treatment facilities which serve the general public and accept domestic wastewater are classified as Type A Sewerage Systems.

Type B Sewerage Systems

Type B Sewerage Systems are existing community sanitary sewer systems which serve the general public and accept domestic wastewater, but generally represent small, private, business, industrial, mobile home, multi-family housing or single subdivision systems which have very limited potential future economic development impact.

Type P Sewerage Systems

Type P Sewerage Systems are planned or proposed public community sanitary sewer system service areas, outside of current service area boundaries, where public systems do not currently exist. Type P systems are areas which have been identified as having sufficient need and population density to support viable public systems and which have an existing minimum potential user density of 40 existing potential connections per mile of wastewater collection line.

The dataset for the sanitary sewer system contains a large amount of descriptive information about each component and the service area. The descriptive information is contained in attribute tables that are linked to each geographic feature in the database. The attribute contents of the sanitary sewer systems geographic dataset are listed in the Attribute Listing for Sanitary Sewer System beginning on page 26. Attribute data field names and domain values are itemized for the Sanitary Sewer System dataset in Table 2 beginning on page 28. Additional system owner information is stored in a table described in Section 5 on page 38.

Geometric Representation

Sanitary Sewer Systems (Type A, Type B and Type P) service areas are to be delineated by boundaries and in the geometric form of one or more contiguous or non-contiguous polygons. Type A, B, and P systems will be stored in separate geographic data files. . In circumstances where systems are small and can only be delineated by a point, a polygon is to be generated using a radius of 50 feet.

Mechanical components of the Sanitary Sewer System - Type A are to be delineated as either lines or points. Pipelines will be collected and stored as lines in one geographic data file. Facilities/devices will be collected and stored as points in a separate geographic data file for each facility/device type.

All geographic data files will be topological.


Geographic Coordinate System, Datum, and Unit of Measurement

The sanitary sewer systems data sets will be geo-referenced using the NC State Plane Coordinate System (NAD83).

The unit of measurement will be metric.


Annotation

Specifications for annotation of facilities and pipes for this dataset are not included in the standard. All relevant information for each feature is assumed to be recorded as an attribute in the database. Annotation, if desired, should be considered as an optional specification for consideration at the time of data collection or modification.


Metadata

Metadata, or data about data, are required for each geographic dataset. Beginning January 1995, all federal organizations involved in the development of geographic data must comply with the Federal Geographic Data Committee's (FGDC) Content Standards for Digital Geospatial Metadata. The FGDC Standard has been adopted by the North Carolina Geographic Information Coordinating Council and is now required for all data submitted to the Corporate Geographic Database. The Center for Geographic Information & Analysis has implemented the Federal Content Standard for Digital Geospatial Metadata for all datasets currently in the Corporate Geographic Database and will assist in the development of complete metadata for corporate data layers.


Symbology

Graphic symbols of facilities and pipes for this data layer are not included in the standard. Symbology is considered as a product generation standard and not a content issue. However, all relevant information pertaining to symbology are presumed to be recorded as an attribute in the database. Symbology should be considered as an optional specification for consideration at the time of product generation.


Attributes

Physical characteristics and descriptive information about components are contained within the attribute table of each data set. Polygons, lines, areas, nodes, and points identify the location or boundary of a feature in the dataset. An attribute or a set of attributes describe each feature in the dataset. Attribute field names, data type, field domain, and additional comments are described in Table 2 - Attribute Names, Field Definitions, and Supplementary Data Definitions for Sanitary Sewer System Features. A list of all descriptive information for the Sanitary Sewer Systems Dataset follows:


List 3 - Summary of Sanitary Sewer Systems Attribute Fields

Sanitary Sewer System - Type A
System Identification Number
Name of System
Owner Identification Number
Part Indicator
Total Parts
Original Construction Year
Description of Service Area
Customer Connections - Residential
Customer Connections - Non-Residential
Customer Connections - Bulk Purchaser
Maximum Daily Flow
Average Daily Flow
User Charges - Residential
User Charges - Non-Residential
User Charges - Bulk Purchasers
Average Monthly Flow Per Customer - Residential
Average Monthly Flow Per Customer - Non-Residential
Average Monthly Flow Per Customer - Bulk Purchaser
Inter Basin Transfer Amount
Problems and Needs
Recommendations
Improvement Cost
Expansion Indicator
Maximum Daily Flow FY2000
Maximum Daily Flow FY2010
Maximum Daily Flow FY2020
Average Daily Flow FY2000
Average Daily Flow FY2010
Average Daily Flow FY2020

Sanitary Sewer System - Type B Service Areas
System Identification Number
Name of System
Population Served
Contact Person
Contact Telephone

Sanitary Sewer System - Type P Service Areas
System Identification Number
Parent System ID
New Cost

Sanitary Sewer System Pipe s
System Identification Number
Original Construction Year
Renovation Year - Most Recent
Material
Diameter
Type - Pressure, Gravity, Vacuum
Utilization Type - Interceptor, Outfall, Collection

Pumping Stations
Pumping Station - ID
Pumping Station Location Descriptor
Pumping Station Year of Original Construction
Pumping Station Year of Most Recent Renovation
Pumping Station - Capacity

Treatment Plants
Treatment Plant - ID
Treatment Plant Location Descriptor
Treatment Plant Year of Original Installation
Treatment Plant Year of Most Recent Renovation
Treatment Plant Permitted Flow Capacity
Treatment Plant Maximum Daily Flow
Treatment Plant Average Daily Flow
Treatment Plant Type of Treatment Technology
Treatment Plant Sludge Disposal Technology
Treatment Plant Infiltration/Inflow
Treatment Plant Estimated Area

Discharges
Discharge -ID
Discharge Location Descriptor
Discharge Year of Original Construction
Discharge Year of Most Recent Renovation

Land Application Areas
Land Application Area - ID
Land Application Area Year of Original Construction
Land Application Area Year of Most Recent Renovation
Land Application Area - Permit Expiration Date
Land Application Area - Estimated Area



Table 2 - Definitions of Attribute Fields for Sanitary Sewer Systems

POLYGON ATTRIBUTES



Feature Category Attribute Data Field Name Data Type Domain and Units Comments
Sanitary Sewer System - Type A
Boundary of legally defined service area, including additional areas being served. Exclude outside areas for which service is planned; these are P systems. Exclude area surrounding intake mains where no customers exist.

System ID SSSYID Text7 characters First three digits are FIPS county code (primary co. of location), next 4 digits are unique identifier. Note: cannot use permit number for discharge due to multiple discharges.

Name of System SSSYNAME Text50 characters

Owner ID (One) SSSYOW1 Text00000 - 99999 Assign unique number for each within state. Owner ID may be same for a water and a sewer system. Use supplementary table 'TOWNER' for additional information about system owners.

Owner ID (Second, if applicable) SSSYOW2 Text00000 - 99999 Additional Owner ID, if multiple owners

Owner ID (Third, if applicable) SSSYOW3 Text00000 - 99999 Additional Owner ID, if multiple owners

Owner ID (Fourth, if applicable) SSSYOW4 Text00000 - 99999 Additional Owner ID, if multiple owners

Owner ID (Fifth, if applicable) SSSYOW5 Text00000 - 99999 Additional Owner ID, if multiple owners

Part Indicator SSSYPART Integer1,2,3,4,5,6,7,8, or 9 If the information for any field in polygon attributes table has possible multiple values (for different parts of the whole), then the system must be characterized as separate systems that form parts of the whole and each part makes separate record(s).

Total Parts SSSYTOPT Integer1,2,3,4,5,6,7,8, or 9 Total parts in entire system. See Part Indicator.

Original Construction Year SSSYCSTR Integer4 digits Exclusive of pipes. Use closest decade if exact year is unknown (e.g., if the original construction year was sometime between 1965 and 1970, specify "1970"). "9999" if unknown.

Description of Service Area SSSYDESC Text50 characters Brief description of service area. Must cover area for which permit is issued.

Customer Connections - Residential SSSYCCR Integer000000 - 999999 Number of residential customer connections for sanitary sewer, most recent June 30th. "0" if none, "999999" if unknown

Customer Connections - Non-Residential SSSYCCNR Integer000000 - 999999 Number of non-residential customer connections for sanitary sewer, most recent June 30th. "0" if none, "999999" if unknown

Customer Connections - Bulk Purchasers SSSYCCBP Integer00000 - 99999 Number of bulk purchaser connections for sanitary sewer, most recent June 30th. "0" if none, "99999" if unknown

Maximum Daily Flow SSSYMAXF Numeric000.000 - 999.999 millions of gallons per day Maximum daily flow during fiscal year ending most recent June 30. "999.999" if unknown

Average Daily Flow SSSYADGD Numeric000.000 - 999.999 millions of gallons per day Average daily flow during fiscal year ending most recent June 30. "999.999" if unknown

User Charges - Residential SSSYCGR Numeric000.00 - 999.99 dollars Average monthly charge per customer for fiscal year ending last June 30. Average of 12 months, each calculated as total monthly charges divided by monthly number of customers. "0" if none, "999.99" if unknown.

User Charges - Non-Residential SSSYCGNR Numeric0.00 - 9999999.99 dollars Average monthly charge per customer for fiscal year ending last June 30. Average of 12 months, each calculated as total monthly charges divided by monthly number of customers. "0" if none, "9999999.99" if unknown.

User Charges - Bulk Purchasers SSSYCGBP Numeric0.00 - 9999999.99 dollars Average monthly charge per bulk purchaser connection for fiscal year ending last June 30. Average of 12 months, each calculated as total monthly charges divided by monthly number of bulk purchaser connections. "0" if none, "9999999.99 if unknown.

Average Monthly Flow Per Customer - Residential SSSYAMR Integer999999 gallons per month Average monthly usage per customer for fiscal year ending last June 30. Average of 12 months, each calculated as total monthly Flow divided by monthly number of customers. "0" if none, "999999" if unknown.

Average Monthly Flow Per Customer - Non-Residential SSSYAMNR Integer999999999 gallons per month Average monthly flow per customer for fiscal year ending last June 30. Average of 12 months, each calculated as total monthly Flow divided by monthly number of customers. "0" if none, "999999999" if unknown.

Average Monthly Flow Per Customer - Bulk Purchasers SSSYAMBP Integer999999999 gallons per month Average monthly flow per bulk purchaser connection for fiscal year ending last June 30. Average of 12 months, each calculated as total monthly Flow divided by monthly number of bulk purchaser connections. "0" if none, "999999999" if unknown.

Inter-Basin Transfer SSSYIBTR TextY or N Yes(Y) if there is transfer of wastewater or processed wastewater from one waterbasin to another by this sanitary sewer system. Otherwise, no (N).

Problems and Needs SPRJNEED Text254 characters Brief narrative documenting current conditions, problems, and needs, citing compliance with federal standards.

Recommenda-tions SPRJREC Text254 characters Brief narrative listing recommendations for improving the system.

Improvement Cost SPRJCOST Integer0000000 - 9999999 thousands of dollars Estimated cost in current dollars to implement recommendations for improving the system including expansion within current service area boundary (excluding any plans for expanding service area boundaries).

Expansion Indicator SPRJEXP TextY or N Yes, if recommend expanding current service area boundaries of this system. Otherwise, no.

Maximum Daily Flow - 2000 SPRJMF00 Numeric000.000 - 999.999 millions of gallons per day Projected maximum daily during fiscal year ending June 30, 2000. "999.999" if unknown

Maximum Daily Flow - 2010 SPRJMF10 Numeric000.000 - 999.999 millions of gallons per day Projected maximum daily during fiscal year ending June 30, 2010. "999.999" if unknown

Maximum Daily Flow - 2020 SPRJMF20 Numeric000.000 - 999.999 millions of gallons per day Projected maximum daily during fiscal year ending June 30, 2020. "999.999" if unknown

Average Daily Flow - 2000 SPRJAF00 Numeric000.000 - 999.999 millions of gallons per day Projected average daily during fiscal year ending June 30, 2000. "999.999" if unknown

Average Daily Flow - 2010 SPRJAF10 Numeric000.000 - 999.999 millions of gallons per day Projected average daily during fiscal year ending June 30, 2010. "999.999" if unknown

Average Daily Flow - 2020 SPRJAF20 Numeric000.000 - 999.999 millions of gallons per day Projected average daily during fiscal year ending June 30, 2020. "999.999" if unknown
Sanitary Sewer System - Type B

All type B systems will be recorded as polygons, regardless of size. Systems too small to outline should be represented as a circle with a 50 foot radius.

System ID SBSYID Text7 characters First three digits are FIPS county code (primary co. of location), next 4 digits are unique identifier.

Name of System SBSYNAME Text50 characters

Population Served SBSYPOP Integer000000 - 999999 persons If unknown, provide best estimate of population

Contact Person SBSYCONT Text25 characters First name and last name, no titles or middle names.

Contact Telephone SBSYPHON Textxxx-xxx-xxxx
Sanitary Sewer System - Type P

Boundary determined by current need and viability. Includes contiguous areas (outside any current sewer system service area) that average at least 40 existing potential connections per linear highway/street mile. May or may not abut existing system(s).

System ID SPSYID Text7 characters First digit is a 9, the next three are county FIPS code, and the final three set as desired, to avoid duplicating an existing system ID. Initial 9 indicates "new" or "P" system.

Parent ID SPSYPAR Text7 characters ID of parent system, if this is a proposed expansion outside service area of a current system. Otherwise blank.

New Cost SPSYCOST Numeric000000.0 - 999999.9 in thousands of dollars Cost in current dollars to put proposed system in place. Customer pool for driving cost estimates is to be derived from projections of population growth rates since 1970.







ARC ATTRIBUTES



Feature Category Attribute Data Field Name Data Type Domain and Units Comments
Sewer Pipes



A new pipe segment is designated each time any pipe attribute changes. A segment of pipe may include many vertices.

System ID SSSYID Text7 characters First three digits are FIPS county code (primary co. of location), next 4 digits are unique identifier. Note: cannot use permit number for discharge due to multiple discharges.

Original Construction Year SSPICSTR Integer4 digits Use closest decade if exact year is unknown (e.g., if the original construction year was sometime between 1965 and 1970, specify "1970"; likewise if you believe it to be sometime between 1960 and 1964, specify "1960"). "9999" if unknown.

Renovation - Most Recent SSPIRENV Integer4 digits Estimate of the year (or decade) of the most recent renovation. "0" if none, "9999" if unknown.

Material SSPIMATR TextABS, asbestos cement, brick, cast iron, concrete, corrugated metal, ductile iron, fiberglass, galvanized steel, polystyrene, polyvinyl chloride, steel, vitrified clay, unknown, other. 25 chars. Material currently in place. Declare one type, exactly as shown.

Diameter SSPIDIAM Integer00 - 99 inches For gravity systems, all interceptors and forced mains must be reported, as well as all collection lines 8 in. and larger. For low pressure and other systems, all lines 2 in. and greater must be reported. Smaller pipes may be reported. "99" if unknown.

Type - Pressure, Gravity, Vacuum SSPITYPGV Text pressure, gravity, vacuum, other, unknown. 15 characters. Negative pressure implies a vacuum.

Utilization Type - Interceptor, Outfall, Collection SSTYIOC Textinterceptor, outfall, collection, other, unknown. 15 characters. State one option, exactly as shown.










POINT ATTRIBUTES



Feature Category Attribute Data Field Name Data Type Domain and Units Comments
Pumping Stations


Component of Type A system

ID, Pumping Station SSPSID Text11 characters First 7 digits are same as those of sewer system ID, last 4 digits are unique identifying code within system. Note fewer digits in last segment may be practical.

Location Descriptor SSPSLOC Text30 characters Name of area of location.

Original Construction Year SSPSCSTR Integer4 digits Use closest decade if exact year is unknown (e.g., if the original construction year was sometime between 1965 and 1970, specify "1970"; likewise if you believe it to be sometime between 1960 and 1964, specify "1960"). "9999" if unknown.

Renovation - Most Recent SSPSRENV Integer4 digits Estimate of the year (or decade) of the most recent renovation. "0" if none, "9999" if unknown.

Capacity SSPSCPTY Integer000000 - 999999 gallons per minute "999999" if unknown
Treatment Plants


Component of Type A system

ID, Treatment Plant SSTPID Text7 characters National Pollutant Discharge Elimination System Identification Number assigned by NC Div. of Environmental Management (Exclude "NC").

Location Descriptor SSTPLOC Text20 characters Name of area of location.

Original Construction Year SSTPCSTR Integer4 digits Use closest decade if exact year is unknown (e.g., if the original construction year was sometime between 1965 and 1970, specify "1970"; likewise if you believe it to be sometime between 1960 and 1964, specify "1960"). "9999" if unknown.

Renovation - Most Recent SSTPRENV Integer4 digits Estimate of the year (or decade) of the most recent renovation. "0" if none. "9999" if unknown

Permitted Flow Capacity SSTPCPTY Numeric00000.0 - 999.999 mgd 7 day, 10 year low flow. "999.999" if unknown

Maximum Daily Flow SSTPMDPR Numeric000.000 - 999.999 mgd 999.999 if unknown

Average Daily Flow SSTPADPR Numeric000.000 - 999.999 mgd 999.999 if unknown

Type of Treatment Technology SSTPTRMT TextStabilization lagoon, secondary treatment, advanced secondary treatment, tertiary treatment, secondary treatment plus nutrient removal, tertiary treatment plus nutrient removal, land application, created wetlands, rapid infiltration, other. 100 chars. State one or more options, exactly as shown. Also use "unknown" if unknown.

Sludge Disposal Technology SSTPSLUD Text50 characters Brief, free text to describe sludge disposal treatment and handling

Infiltration/Inflow SSTPINFT Numeric000.000 - 999.999 millions of gallons per day Estimate of system-wide maximum daily infiltration/inflow measured at the plant. "999.999 if unknown

Estimated Area SSTPAREA Numeric000000.00 - 999999.99 acres Estimate of total area (excluding land application area extent). "999999.99" if unknown
Discharges



Component of Type A system

ID, Discharges SSTPDCID Text10 characters 7 digits from the Treatment Plant ID (National Pollutant Discharge Elimination System Identification Number) and the 3 digit outfall code.

Location Descriptor SSDCLOC Text30 characters Name of area of location. Include name of stream in location descriptor.

Original Construction Year SSDCCSTR Integer4 digits Use closest decade if exact year is unknown (e.g., if the original construction year was sometime between 1965 and 1970, specify "1970"; likewise if you believe it to be sometime between 1960 and 1964, specify "1960"). "9999" if unknown

Renovation - Most Recent SSDCRENV Integer4 digits Estimate of the year (or decade) of the most recent renovation. "0" if none, "9999" if unknown
Land Application Areas


Component of Type A system.

ID, Land Application Areas SSTPLAID Text11 characters Nine digits: seven digit Land Application Number (exclude 'WQ') and two digits for unique identifier.

Original Construction Year SSLACSTR Integer4 digits Use closest decade if exact year is unknown (e.g., if the original construction year was sometime between 1965 and 1970, specify "1970"; likewise if you believe it to be sometime between 1960 and 1964, specify "1960"). "9999" if unknown

Renovation - Most Recent SSLARENV Integer4 digits Estimate of the year (or decade) of the most recent renovation. "0" if none, "9999" if unknown

Permit Expiration Date SSLADATE DateYYMMDD

Estimated Area SSLAAREA Numeric000000.00 - 999999.99 acres Estimate of area. "999999.99" if unknown.


SECTION 5: Content Standard - Supplementary Owner Information

Additional Information about Water Distribution and Sewer System Owners are stored as a data table in the dataset. The data is linked to the systems data files through the owner identification number.

List 4 - Supplementary System Owner Information

Owner ID
Owner Name
Owner Type
County of Owner
Bond Rating, NC Municipal Council
Capital Improvement Plan Availability
Cash Reserves
Outstanding Indebtedness - Water
Outstanding Indebtedness - Sewer



Table 3- Definitions of Attribute Fields for Owners

Supplemental Table: TOWNER


Attribute Data Field Name Data Type Domain and Units Comments
Owner ID WSSYOWID Text00000 - 99999 Assign unique numbers statewide. May have same owner ID for a water and sewer system.
Owner Name WSSYOWNM Text 50 characters
Owner Type WSSYOWTP Text town, city, county, water dst, sewer dst, wat & sew dst, metro wat dst, metro sew dst, metro wat&sew dst, wat auth, sew auth, wat&sew auth, sanitary dst, state, fed, non-profit, profit corp, private, special purpose dst, home owner assoc., other. 50 chars. Also use "unknown" if unknown.
County of Owner WSCOFIPS Text 001 - 199 FIPS Code. County of Business Address of System Owner.
Bond Rating, NC Municipal Council WSSYOWRA Text 000 - 100, or "NR" for No Rating, or "NSR" for Not Subject to Rating. Use North Carolina Municipal Council, Inc. Ratings of Counties, Cities, and Towns. Latest Available Publication.
Capital Improvement Plan Availability WSSYOWCI Text Y or N
Cash Reserves WSSYOWCR Numeric 0000000.0 - 9999999.9 thousands of dollars Based on latest audit. Omit dollar sign.
Outstanding Indebtedness - Water WSSYOWIW Numeric 0000000.0 - 9999999.9 thousands of dollars Based on latest audit. Omit dollar sign.
Outstanding Indebtedness - Sewer WSSYOWIS Numeric 0000000.0 - 9999999.9 thousands of dollars Based on latest audit. Omit dollar sign.


Glossary

Component
Any natural or man-made entity that is a categorical part of a water distribution or a sanitary sewer system. Examples of components may include water tanks, sewer pipes, and fire hydrants.

Discharge
The point at which treated wastewater is released into a receiving stream or body of water.

Feature
The unique segment or part of a system that is spatially represented by a geometric figure, such as a polygon, line, point, or node.

Wells, Ground Water Intake
The location at which raw water is drawn into the water system from an underground source.

Hydrant
An upright pipe with a nozzle or spout for drawing water from a water main.

Intake, Surface Water
The location at which raw water is drawn into the water system from a surface water source.

Land Application Area
An area on which treated wastewater or sludge is applied to be absorbed into the soil.

Master Meter
A device generally used to measure the volume of water flow to bulk purchasers whereby the water is intended for resale to users within the purchaser's system.

Sanitary Sewer Pumping Station
Any device or facility used to force wastewater from one elevation or location to another within a wastewater system.

Sanitary Sewer System
All facilities used to collect, treat, pump, and dispose of sewerage. All facilities The area serviced by the Sanitary Sewer System The boundaries comprising the sanitary sewer system may or may not be coincident with the water distribution system.

Sanitary Sewer System - Type A
Existing community sanitary sewer systems including collection lines, transport lines or pumping and treatment facilities which serve the general public and accept domestic wastewater are classified as Type A Sewerage Systems.

Sanitary Sewer System - Type B
Type B Sewerage Systems are existing community sanitary sewer systems which serve the general public and accept domestic wastewater, but generally represent small, private, business, industrial, mobile home, multi-family housing or single subdivision systems which have very limited potential future economic development impact.

Sanitary Sewer System - Type P
Type P Sewerage Systems are planned or proposed public community sanitary sewer system service areas, outside of current service area boundaries, where public systems do not currently exist. Type P systems are areas which have been identified as having sufficient need and population density to support viable public systems and which have an existing minimum potential user density of 40 existing potential connections per mile of wastewater collection line.

Sanitary Sewer Treatment Plant
A facility used to treat wastewater and the related appurtenant works.

Sewer Pipe
A pipe that is used to carry wastewater from one location in the system to another.

Water Pipe
A pipe that is used to carry water from one location to another in a water supply or distribution system.

Water Distribution System
All facilities used to supply, treat, store, and distribute water. The boundaries comprising the water system may or may not be coincident with the Sanitary Sewer System .

Water Distribution System - Type A
Water Systems defined as public "Community Water Systems" by the NC Department of Environment, Health, and Natural Resources are classified as Type A Water Systems. Type A Water Systems are existing systems for provision to the public of piped water for human consumption which serve fifteen (15) or more connections or which regularly serve at least 25 year- round residents.

Water Distribution System - Type B
Type B Water Systems are existing systems defined as public "Community Water Systems", which generally represent small private, mobile home, multi-family housing or single subdivision systems and have very limited potential future economic development impact.

Water Distribution System - Type P

Type P Water Systems are planned or proposed public community water system service areas where public systems do not currently exist and are outside of current service area boundaries. Type P system are areas which have been identified as having sufficient need and population density to support viable public systems and which have an existing minimum potential user density of 20 existing potential connections per mile of waterline.

Water Pumping Station
A device or facility used to force water from one elevation or location to another within the water supply or distribution system.

Water Storage Tank
A natural or manmade facility where water is stored for the water system.

Water Treatment Plant
A facility where raw water is treated and purified for human consumption.


NC Geographic Information Coordinating Council
Part of the North Carolina Geographic Information Coordinating Council
Help? Problems? --> Email dataq@ncmail.net <-- Comments? Questions?
Or call NC CGIA at (919) 733-2090