The NC Center for Geographic Information and Analysis developed the GIS data set, Type A Future Public Sewer Systems, as mapped by contractors to the NC Rural Center (engineering firms McGill & Associates and Hobbs, Upchurch & Associates) during 2004, 2005, and 2006 to facilitate planning, siting and impact analysis in the 100 individual counties of North Carolina. This file enables the user to make various county-level determinations when used in conjunction with other data layers. "Future" in the title Type A Future Public Sewer Systems refers to system boundary the water syster owner expects in 2010. The tabular data will be the same as it was for the current data.
The purpose of this data set is to inform users of key information about public sewer systems in North Carolina, with particular focus on system size and growth, sewage discharge annd treatment, and capital improvement needs of the systems.
Data limitations: For security reasons, Fort Bragg did not provide service area boundaries; therefore the entire military base was used as the service area boundary. Wake Forest, Knightdale, Wendell, and Zebulon were individual service areas when the data was collected, and this is reflected in the data. However, these sytems have now merged with the Raleigh system. This change will be reflected in future updates, as they occur. Service areas with only future boundaries have system IDs with no other detailed information associated since the systems do not yet exist in mature form. Some service areas have limited information in the corresponding tabular data, either in the form of zero values or missing records. These systems either refused to provide the data or are so new that much of the historical data requested does not yet exist. Tyrrell County WSD #1 sewer has a much smaller area than Tyrrell County WSD # 2, but the database figures are bigger for # 1. Although this is a potential error in the data, the error was not addressed by the contractor (Hobbs, Upchurch & Associates). Revisions and updates to this layer include: 1.) March 2007 version was the first recorded release of this data.
Data creation and revision date
Acknowledgement of products derived form this dataset should cite the following: The source of the Type A Future Public Sewer Systems data is NC OneMap. Earlier versions of this data set may exist. The user must be sure to use the appropriate dataset for the time period of interest. While efforts have been made to ensure that these data are accurate and reliable within the state of the art, CGIA cannot assume liability for any damages or misrepresentation caused by any inaccuracies in the data or as a result of changes to the data caused by system transfers.
301 N. Wilmington Street, Suite 700
20322 Mail Service Center
Phone and electronic mail preferred
NCCGIA Director, Tim Johnson Database Administration, David Giordano
This data was collected by engineering firms McGill & Associates and Hobbs, Upchurch & Associates by survey and site visit.
Using ESRI's ARC/INFO GIS software, the data set was built for arc and polygon topology using the "build" command. The data set was then cleaned with a fuzzy tolerance of 10 meters. Topology has not been edited since the last build or clean.
This data layer represents the Type A Future Public Sewer Systems of all counties in North Carolina.
System boundaries were reviewed by CGIA for accuracy and modified as needed.
Paper maps on which 1998 service area boundaries were plotted.
The contractors collected graphic data from water and sewer system managers, and collected numeric data from water, sewer, and stormwater system managers throughout North Carolina. Graphic data was collected in one of two ways. If the system of interest was evaluated during the prior system survey of 1998, the new graphic data was collected by forwarding or delivering to each system manager a map of the water or sewer system pipes as they existed in 1998, having the system manager adjust system boundaries to reflect current and expected future boundaries, and making those edits to the 1998 polygons. If the system of interest was not evaluated in the 1998 survey, a map of the current and expected future boundaries of the system was requested from the system manager. In both cases, the current and expected future boundaries of the water or sewer system were ultimately digitized from the data provided by the system manager. In some cases, system managers reported no change in current or expected future system boundaries, and in those cases the resulting polygons are identical to those produced from the 1998 survey. For this study, current system boundaries were defined as those boundaries in existence at the time of the survey (2004). Future system boundaries were defined as the boundaries expected to exist in the year 2010. Numeric data was collected by crafting a table structure for the required data, forwarding a paper questionnaire developed from this data structure to each system manager, collecting that data as a written response to the questionnaire (via return mail or face-to-face meeting), then entering this data into the table structure.
55 Broad Street
Phone and electronic mail preferred
Same process as outlined in previous step was followed for second contractor.
2411 N. Oak Street, Suite 204
Phone and electronic mail preferred
AMEC Earth and Environmental, Inc. of North Carolina (AMEC) took responsibility for managing the data structure, data connectivity, and quality control aspects of the graphic and numeric data generated for this project. AMEC integrated individual polygons into a statewide coverage of systems of various types, and also performed quality control reviews on numeric data and data ranges for numeric fields. AMEC identified disconnections between polygons and the underlying tabular data and worked with the other contractors and CGIA to rectify these disconnects. Using linear multivariate regression techniques, AMEC estimated current and future capital improvement needs for systems which had no published capital improvement plans.
4513 Creedmoor Road, Suite 400
Phone and electronic mail preferred
Service area boundaries and database were extensively reviewed by CGIA for accuracy and modified where needed.
301 N. Wilmington Street, Suite 700
20322 Mail Service Center
Phone and electronic mail preferred
Internal feature number.
ESRI
Feature geometry.
ESRI
System ID. First three digits are FIPS county code (primary co. of location), SS, next 4 digits are 2004, next 3 digits are unique identifier. Note: cannot use permit number for discharge due to multiple discharges.
Sewer system owner
Name of System
Sewer system owner
Collection System Permit Number
Sewer system owner
Primary County(s) Served
Sewer system owner
Primary Contact Person
Sewer system owner
Superintendent, Director, etc)
Sewer system owner
Mailing Address
Sewer system owner
Phone Number
Sewer system owner
Fax Number
Sewer system owner
Email address
Sewer system owner
Type of Ownership (Municipality, County, Authority, District, Non Profit Assoc., For Profit Business, State, Federal, Other)
Sewer system owner
Current Service Population (in number of people served)
Sewer system owner
Projected 2005 Service Population (number of people expected to be served)
Sewer system owner
Projected 2010 Service Population (number of people expected to be served)
Sewer system owner
Projected 2020 Service Population (number of people expected to be served)
Sewer system owner
Projected 2030 Service Population (number of people expected to be served)
Sewer system owner
Number of residential customer connections for sanitary sewer, most recent June 30th. "0" if none, "999999" if unknown.
Sewer system owner
Number of non-residential customer connections for sanitary sewer, most recent June 30th. "0" if none, "999999" if unknown.
Sewer system owner
Number of bulk purchaser connections for sanitary sewer, most recent June 30th. "0" if none, "999999" if unknown.
Sewer system owner
Maximum daily flow during fiscal year ending most recent June 30. "999.999" if unknown.
Sewer system owner
Average daily flow during fiscal year ending most recent June 30. "999.999" if unknown.
Sewer system owner
Average monthly residential usage per customer for fiscal year ending last June 30. Average of 12 months, each calculated as total monthly Flow divided by number of customers. "0" if none, "999999" if unknown.
Sewer system owner
Average monthly non-residential flow per customer for fiscal year ending last June 30. Average of 12 months, each calculated as total monthly Flow divided by number of customers. "0" if none, "999999999" if unknown.
Sewer system owner
List total wastewater treated in most recent fiscal year, in millions of gallons
Sewer system owner
Average monthly flow per bulk purchaser connection for fiscal year ending last June 30. Avg of 12 months, each calculated as total monthly flow divided by number of bulk purchaser connections. "0" if none, 999999 if unknown.
Sewer system owner
Inter-Basin Transfer
Sewer system owner
There is transfer of wastewater or processed wastewater from one waterbasin to another by this sanitary sewer system
Sewer system owner
There is not transfer of wastewater or processed wastewater from one waterbasin to another by this sanitary sewer system
Sewer system owner
Projected average daily during fiscal year ending June 30, 2005. "999.999" if unknown
Sewer system owner
Projected average daily during fiscal year ending June 30, 2010. "999.999" if unknown
Sewer system owner
Projected average daily during fiscal year ending June 30, 2020. "999.999" if unknown
Sewer system owner
Projected average daily during fiscal year ending June 30, 2030. "999.999" if unknown
Sewer system owner
Bulk User Projections
Sewer system owner
For previous projections, bulk users were included in the projection.
Sewer system owner
For previous projections, bulk users were not included in the projection.
Sewer system owner
Headworks Analysis
Sewer system owner
Headworks analysis has been done in the previous 5 years
Sewer system owner
Headworks analysis has not be done in the previous 5 years
Sewer system owner
Smoke Testing
Sewer system owner
Smoke testing has been done in the previous 5 years
Sewer system owner
Smoke testing has not be done in the previous 5 years
Sewer system owner
Camera Inspection
Sewer system owner
Camera inspection has been done in the previous 5 years
Sewer system owner
Camera inspection has not be done in the previous 5 years
Sewer system owner
Line Inspection and Cleaning
Sewer system owner
Program is in place
Sewer system owner
Program is not in place
Sewer system owner
Line Rehabilitation and Replacement
Sewer system owner
Program is in place
Sewer system owner
Program is not in place
Sewer system owner
System Map
Sewer system owner
System is mapped
Sewer system owner
System is not mapped
Sewer system owner
GIS Data
Sewer system owner
System map is in GIS format
Sewer system owner
System map is not in GIS format
Sewer system owner
Update Willingness
Sewer system owner
Service owner is willing to update data annually
Sewer system owner
Service owner is not willing to update data annually
Sewer system owner
Data Sharing. Local ordinance or policy regarding sharing electronic data about your system ("no ordinance or policy", "no sharing", or "limited sharing").
Sewer system owner
Annual O&M Expenditure 2004. Total amount in thousands of dollars.
Sewer system owner
Past Sewage Treatment. Total sewage treated in fiscal year 1994-1995 in Millions of Gallons (for historical benchmarking).
Sewer system owner
Past O&M Budget. Total amount in thousands of dollars for the actual O&M budget for the system for the fiscal year 1994-1995 (for historical benchmarking)
Sewer system owner
Estimate of system-wide maximum daily infiltration/inflow measured at the plant. "999.999 if unknown.
Sewer system owner
Name of sewer system providing treatment in the case of purchased treatment
Sewer system owner
Current CIP Need (total amount in thousands of dollars for the estimated CIP needs for the system for the period FY04-05 through FY09-10 -- a 5 year period, defined as current need)
Sewer system owner
Future CIP Need (total amount in thousands of dollars for the estimated CIP needs for the system for the period FY10-11 through FY29-30 -- a 20 year period, defined as future need)
Sewer system owner
Source of current CIP value (either estimated by consultant or reported by system)
Sewer system owner
Source of future CIP value (either estimated by consultant or reported by system).
Sewer system owner
Area of feature in internal units squared.
ESRI
A dataset depicting the North Carolina Type A Future Sewer Systems. Polygons have attribute data including total area in coverage units (square meters), total perimeter (linear meters), polygon internal identification number, polygon user identification number, and pertinent system information. > >The following tables can be related to the sewer system service areas. >There is a one-to-many relationship between the sewer systems and >records in these tables that prevents joining the tables to the areas. > >BFSewer Table (BF - Bond Funding) >ITEM NAME TYPE DESCRIPTION >SSSYID Text System ID (relate item) >SYSTEM Text Name of sewer system receiving bond funds >FUNDER Text Funder of the bond or grant funds to the system >PROGRAM Text Specific program under which the bond funds > were made available >COUNTY Text Name of county where system serves or will serve >REDC_DES Text Bond funding project description (this field is only > populated for projects funded through NCREDC) >AWARD Currency Value of funds awarded (in US dollars) >PR_TYPE Text Bond funding project type (Water or Sewer) > >Sewer_Treatment Plants Table >ITEM NAME TYPE DESCRIPTION >SSSYID Text System ID (relate item) >SSTPID Text National Pollutant Discharge Elimination System > Identification Number assigned by NC Div. of > Environmental Management >STPNM Text Name of plant(s) >STPRECS Text Name of the receiving stream >S7Q10 Long Integer The 7Q10 flow of the receiving stream (CFS), > 999999 if unknown >SDPCOORLAT Double Latitude of Discharge Point, in Decimal Degrees >SDPCOORLONG Double Longitude of Discharge Point, in Decimal Degrees >SLANDAC Long Integer Number of acres in service for land application > or spray irrigation of effluent, 999999 if unknown. >SLANDS Long Integer Total number of distinct land application or > spray irrigation sites >SSTPCPTY Double Permitted Flow Capacity >SSTPMDPR Double Maximum Daily Flow >SSTPADPR Double Average Daily Flow >SSTPTRMT Text Type of Treatment Technology >SSTPSLUD Text Sludge Disposal Technology >SSTRTTECH Text Sanitary sewer treatment technology >SSEXTAER Text Extended aeration (Y or N) >SSNUTREM Text Nutrient removal (Y or N) >
None
301 N. Wilmington Street, Suite 700
20322 Mail Service Center
Phone and electronic mail preferred
NCCGIA is charged with the development and maintenance of NC OneMap and, in cooperation with other mapping organizations, is committed to offering its users accurate, useful, and current information. Although every effort has been made to ensure the accuracy of information, errors and conditions originating from physical sources used to develop this dataset may be reflected in the data supplied. The user must be aware of possible conditions and bear responsibility for the appropriate use of the information with respect to possible errors, original map scale, collection methodology, currency of data, and other conditions specific to certain data. NCCGIA does not support secondary distribution of this dataset without its current, compliant metadata record. The use of trade names or commercial products does not constitute their endorsement by NCCGIA or North Carolina State Government.
Data can be customized on a cost-recovery basis. Contact dataq@ncmail.net or 919-733-2090 for more information.
301 N. Wilmington Street, Suite 700
20322 Mail Service Center
Phone and electronic mail preferred