-------
CWNS 2012 Reports - Online Help
Note: All dollar amounts are indicated in millions.
Table 4-1: Explanation of displayed bar graphs and pie charts.
Bar graph/Pie chart
Description
Total Documented Needs by Category
A pie chart that indicates the dollar amount of
wastewater treatment and collection, recycled water
distribution, and stormwater management
(categories l-VI and X) Official Needs are shown by
category for the geographic area selected.
Official Needs by Category
A bar chart displaying the dollar amount of
wastewater treatment and collection, recycled water
distribution, and stormwater management
(categories l-VI and X) Official Needs are shown by
category for the geographic area selected. Official
Needs are rounded up to the nearest million. Needs
less than $1 Million are shown as $1 Million.
Number of Facilities by
Population/Flow/Treatment
Population: A pie chart that indicates how many
wastewater facilities that currently serve residential
(1) populations of less than 1,000; (2) populations of
1,000 to 3,499; (3) populations of 3,500 to 9,999; (4)
populations of 10,000 or more in the selected
geographic area.
Flow: A pie chart that indicates how many
wastewater facilities that currently have Total
Existing Flow of less than or equal to O.lOOmgd,
O.lOlmgd to l.OOmgd, l.OOlmgd to lOmgd and
more than lOmgd in the selected geographic area.
Treatment: A pie chart that indicates how many
wastewater facilities that currently have Treatment
of Less than Secondary, Secondary, Greater than
Secondary, No Discharge and Partial Treatment in
the selected geographic area.
Small versus Large Communities
A multiple bar chart that compares the number of
publicly owned treatment works (POTWs), the
present population served, and needs in categories 1-
V, X) in small community (population less than
10,000) versus large community (population 10,000
and greater).
Total Needs over time
A multiple bar chart that compares needs from
Page 22
-------
CWNS 2012 Reports - Online Help
CWNS 2008 and CWNS 2012.
Note: This chart is only available at National-
level. When this report is selected, the ability to
select State, County, Watershed, or
Congressional District as a geographic area is
disabled.
Number of Facilities with Needs (Wastewater
and Stormwater)
A pie chart that indicates how many wastewater and
stormwater management facilities have (1) no
documented needs; (2) only Official Needs
documented; (3) both Official Needs and Unofficial
Cost Estimates; (4) only Unofficial Cost Estimates in
the selected geographic area.
4.2 Selection Criteria
• Select the State area for the search. For national data, select "Nation." (Multiple states can be
selected by holding down the Ctrl key while selecting states.) Note: South Carolina and Northern
Mariana Islands are not listed, because they did not report data for CWNS 2012. (Figure 23)
Maps Data Dashboard Technical Data Fadlil
State:
0
Nation
AK - Alaska
AL - Alabama
A
IV
|Search| ^
Figure 22: Geographical Area Selection Criteria
• To further refine selection criteria, click ^ . A list of Counties, Congressional Districts and
Watershed for the selected State is displayed. (Note: refined selection is only available if one
State has been selected) (Figure 24)
Maps Data Dashboard Technical Data Facility FactSheets Summary Report Detail Report Data Downloads
State:
Nation
A1
AK - Alaska
AL - Alabama
M
©County: 1
OCongrational
OWatershed :
Autauga
Distict:
1 st Congressional District
Bear
Baldwin ^
2nd Congressional District
Blackwater
|Search| |Cancel|
Figure 23: Geographical Area Selection Criteria
4.3 Run Report
• After selecting desired geographic areas, click
Search
to view charts.
Page 23
-------
CWNS 2012 Reports - Online Help
4.4 Results
4.4.1 Charts and Graphs
The dashboard is displayed and for the selected search criteria (e.g., State: Alabama, Counties:
Baldwin, Barbour, Bibb) (Figure 25). For all charts, an image file or printer friendly version is available by
right clicking on the chart and selecting the required option.
You are here: Water» Science & Technology » Applications & Databases » Program Databases » Clean Watersheds Needs Survey » 2012 Report & Data » Data Dashboard
CWNS 201 2 Data and Reports
Customer Satisfaction Survey
Data Dictionary Help
Maps Data Dashboard Technical Data Facility FactSheets Summary Report Detail Report Data Downloads
Selected Criteria :
State(s) : Alabama
[Search] ^ Counties : Baldwin , Barbour ,
Total Documented Needs by Category
Total Needs: $ 107.2M
¦ 1 - Secondary Wastewater Treatment - 30.1%
HI II - Advanced Wastewater Treatment • 5.7%
ID - Conveyance System Repair - 38.5%
IV-New Conveyance Systems- 25.6%
Small versus Large Communities
3 Small Community
I Large Community
Official Needs By Category
Number of Facilities
[Population v|
Needs Category
Total Needs over time
I Population of less than 1,000 - 6.3%
I Population 1,000 to 3,499 - 37.5%
I Population 3,500 to 9,999 - 31.3%
Population of 10,000 or more - 25.OT
Number of Facilities with Needs (Wastewater
and Stormwater)
Needs Category
| 2033 Official Needs
H 2012 Officii Needs
I Only official needs documented
Note: Only available at the National-level.
Figure 24: Data Dashboard - results
4.4.2 Detailed Reports
For all charts, click on any wedge or bar to get a detailed facility listing. The detailed facility listing
provides data on ali the individual facilities from which the summary data presented in the chart was
derived (Figure 26).
Page 24
-------
CWNS 2012 Reports - Online Help
You are here: Water* Science & Technology » Applications & Databases » Program Databases » Clean Watersheds Needs Survey » 2012 Report & Data » Summary Report » Needs Summary Charts
» Official Needs By Category
CWNS 201 2 Data and Reports
Needs category II for Baldwin,Barbour,Bibb County(ies) of AL
0 OO
h :
| Go | | Actions |
It Y
This site is best viewed with IE9, Google Customer Data Help
Chrome and MoziHa Firefox. Satisfaction Survey Dictionary
t Maine CWNS Number Total Needs Cost Catei
CENTREVILLE- BRENT 01000034001 $8,984,587
WWTP
DAPHNE WATER 01000044001 530,349,034
RECLAMATION
FACILITY
Blackwater WWTP 01000210000 519,119,804
1 - 3 of 3
Advanced Treatment $1,911,980 City of Brent
Advanced Treatment
Advanced Treatment
51,377,778 City of Daphne Baldwin
Utilities Board
52,867,971 Blackwater
WWTP
Mobile - Tensaw 031 60204
Figure 25: Detailed Report
The detail reports are displayed as a table with a predetermined set of columns. The report may be
further customized using the tools provided. The user is able to:
• Search the columns
• Select the number of rows to display per page
• Create break groups one or more columns
• Highlight cells or rows based on user defined characteristics
• Add computed columns to the table
• Perform computations on selected columns
• Create a chart from the data
• Select which columns to display
• Sort columns
• Filter the data
• Download displayed data in CSV format
Detailed information on how to use the software tools for the detail reports is available in Appendix A.
5. Technical Data
5.1 Introduction
Technical Data reports display data that was shown in the Report to Congress in the past. These reports
are only available at the National-level.
5.2 Selection Criteria
• Select the one or more types of report outputs (Table 5-1). If no report type is selected, then
output is displayed for all report types (Figure 27).
Page 25
-------
CWNS 2012 Reports - Online Help
You are here: Water» Science & Technology » Applications & Databases » Program Databases » Clean Watersheds Needs Survey » 2012 Report & Data »Technical Data
CWNS 201 2 Data and Reports This site is best viewed with IE 9, Coog/e Customer Data Help |
Chrome and Mozilla Firefox. Satisfaction Survey Dictionary
| Maps | | Data Dashboard | | Technical Data | | Facility FactSheets | | Summary Report | | Detail Report | | Data Downloads |
Technical Data reports display data that was previously included in the appendices of the Report to Congress. These data tables are comparable to the data tables found in Appendix I of the
CWNS 2008 Report to Congress. These reports are only available at the National-level.
1. Select a Technical Data Report Output*
UNumber of Treatment Facilities and Pipe Systems
'— Number of Facilities by Flow
'— Number of Facilities by Treatment
' Number of treatment facilities and population served per State by level of treatment if all documented needs are met
ONumber of facilities with CSO Needs
UNumber of facilities with Storm water Needs
'—'Number of treatment facilities and population served per State by level of treatment for year of 2012
~ Facil ities with less-than-secondary effluent levels
* South Carolina (SC) and Northern Mariana Islands (MP) did not participate in CWNS 2012. National summaries of technical data include data from CWNS 2008 for SC and MP.
( Run Report )
c Reset]
Figure 26: Summary Report - Selection Criteria
Table 5-1: Explanation of Types of Report Output.
Types of Report Output
Description
Number of Treatment Facilities
and Pipe Systems
Summarizes the number of wastewater treatment facilities and pipe
systems in operation in 2012 in each State and the number of
wastewater treatment facilities and pipe systems projected to be in
operation in each State if all documented needs are met.
This table contains technical data only for facilities that were
accepted by EPA. This table does not include data from facilities that
were not updated by States in the CWNS 2012, either because the
state did not participate in this survey or because the State did not
have resources to update the facilities. Because of these analysis
methods, numbers in this figure cannot be directly compared to
other Technical Data reports.
Number of Facilities by Flow
Shows, for five flow ranges, the number of treatment facilities in
operation in 2012 and the number projected to be in operation if all
documented needs are met. The number of facilities and their
cumulative flow (in millions of gallons per day) are shown for each of
the flow ranges.
Number of Facilities by
Treatment
Shows, by level of treatment, the number of treatment facilities in
operation in 2012 and the number projected to be in operation if all
documented needs are met. The number of facilities, their
cumulative capacities (in millions of gallons per day), and the
Page 26
-------
CWNS 2012 Reports - Online Help
population served are shown for each level of treatment. The
population served number is then presented as a percentage of the
total 2012 and 2032 U.S. population, respectively.
By Treatment, the number of
facilities that will be in operation
if all documented needs are met
and the population served at
State level
Shows, by treatment level, the number of facilities that will be in
operation if all documented needs are met and the population
served at State level. The number of facilities and population served
are shown for each level of treatment and for each State.
Number of facilities with CSO
Needs
Presents the number of CSO facilities with documented needs
identified during the CWNS 2008 and CWNS 2012.
Number of facilities with
Stormwater Needs
Presents the number of stormwater facilities with needs identified in
the CWNS 2012 by the type of the MS4.
Number of Treatment facilities
and population served per State
by Level of Treatment
Shows, by treatment level, the number of facilities in operation in
2012 and the population served at the State level. The number of
facilities and population served are shown for each level of
treatment and for each State.
Facilities with less-than-
secondary effluent levels
Presents the treatment facilities represented in the CWNS 2012 as
having less-than-secondary effluent discharges and no 301(h)
waivers from secondary treatment for discharges to marine waters.
The present and future effluent levels, design flow and population
receiving treatment are shown for each facility, in addition to the
Secondary Treatment (Category 1) needs for the facility. Technical
data are of January 1, 2012.
5.3 Run Report
After selecting desired report outputs, geographic areas and unit process (if applicable), click
R.i.l 1 Ref-u K . ^ vjew c/ata tables.
5.4 Results
5.4.1 Technical Reports
The technical reports are displayed as a table with a predetermined set of columns (Figure 28).
Page 27
-------
CWNS 2012 Reports - Online Help
You are here: Water» Science & Technology » Applications & Databases » Program Databases » Clean Watersheds Needs Survey » 2012 Report & Data » Summary Report » Report
CWNS 201 2 Data and Reports This site is best viewed with IE 9, Google Customer
Chrome and Moziff a Fire fox. Satisfaction
Survey
2012 Number of Treatment Facilities by Treatment Level (Excluding SC and MP)
Less than Secondary 34
452.00
588.00
4,057,768
1.30
Secondary |7,295
1 1,91 1.00
16,790.00
88,817,412
28.50
Greater than Secondary4,971
1 8,693.00
26,380.00
126,569,873
40.60
No Discharge 2,269
1,697.00
2,482.00
1 5,898,534
5.10
Partial Treatment 12
70.00
72.00
-
0.00
Total 14,581
32,822.31
46,312.89
235,343,587
75.40
2032 Number of Treatment Facilities by Treatment Level (Excluding SC and MP)
¦Treatment Level
Facility Count
Total Existing Flow (mgd) Population Served
Percent Of Population (%)
Less than Secondary
23
584.00 4,504,473
1,20
Secondary
'6,596
15,086.00 86,858,378
23.70
Greater than Secondary
6,041
31,841.00 172,890,814
47.20
No Discharge
2,449
33,626.00 26,574,083
7.30
Partial Treatment
J1 3
74.00
0.00
Total
|l 5,122
51,210.75 290,827,748
79.40
Figure 27: Technical Report - results
5.4.2 Detailed Reports
For all technical reports, click on any blue (hyperlinkedj value to get a detailed facility listing. The
detailed facility listing provides data on all the individual facilities from which the summary data
presented in the report was derived (Figure 29).
You are here: Water» Science & Technology » Applications & Databases » Program Databases » Clean Watersheds Needs Survey » 2012 Report & Data » Technical Report » Facilities By Treatment Details
CWNS 201 2 Data and Reports
FaciHtites By Treatment Details
This site is best viewed with IE9, Google Customer Data Help
Chrome and Mozilla Firefox. Satisfaction Survey Dictionary
Yl
(ji s
t Name CWNS Number Total Official Needs Total Unofficial Permit Namber Permit Type Name
Cost Estimates
Concord Collection
System
Mountain View
Collection System
Baltimore Co. Sewer
Agreement
06002026001
06002113001
24000300150
S26,l 71,077
$7,992,604
S 765,605
Concord, City of Contra Costa Suisun Bay
Mountain View, Santa Clara Coyote
City of
ANNE ARUNDEL Anne Arundel Gunpowder-
CO. DPW Patapsco
(this area has been truncated)
BACOVACS 51000291002
1 - 1 2 of 1 2
BATH SERVICE Bath
AUTH
Upper James
Figure 28: Detailed Report
Page 28
-------
CWNS 2012 Reports - Online Help
The detail reports are displayed as a table with a predetermined set of columns. The report may be
further customized using the tools provided. The user is able to:
• Search the columns
• Select the number of rows to display per page
• Create break groups one or more columns
• Highlight cells or rows based on user defined characteristics
• Add computed columns to the table
• Perform computations on selected columns
• Create a chart from the data
• Select which columns to display
• Sort columns
• Filter the data
• Download displayed data in CSV format
Detailed information on how to use the software tools for the detail reports is available in Appendix A.
6. Facility Fact Sheet Tab
6.1 Introduction
Facility Fact Sheet summarizes CWNS data for chosen facility/project(s) in an easy to read PDF fact
sheet. Users can search for specific Facility Fact Sheets using either the Basic Search or Advanced
Search.
Click on the link Basic Search to do a quick search or the link Advanced Search to do a more
detailed search (Figure 30).
You are here: Water» Science & Technology » Applications & Databases » Program Databases » Clear Watersheds Needs Survey » 2012 Report & Data » Facility Factsheet
CWNS 201 2 Data and Reports
Customer Satisfaction Survey Data Dictionary Help
Maps Data Dashboard Technical Data Facility FactSheets Summary Report Detail Report Data Downloads
Basic Search | Advance Search
Figure 29: Facility Fact Sheet
6.2 Selection Criteria
6.2.1 Basic Search
The Basic Search allows users to perform a keyword search of Facilities/Projects, either nationwide or
within a selected state. Users can search for text that is part of the CWNS Number, Facility/Project
Name, NPDES Permit Number, County, Watershed, and Authority data fields (Figure 31).
Page 29
-------
CWNS 2012 Reports - Online Help
Select the geographic area for the search, either a specific state or the entire nation. Note:
South Carolina and Northern Mariana Islands are not listed, because they did not report
data for CWNS 2012.
Type the keyword(s) in the text box. Keyword(s) can be a full phrase or part of a phrase
included in the Facility/Project Name, CWNS Number, Permit, County, Watershed, or
Authority.
Click
Search
CWNS 201 2 Data and Reports
Maps Data Dashboard Technical Data Facility FactSheets Summary Report Detail Report Data Downloads
Basic Search I Advance Search
State : National
(South Carolina (SC) and Northern Mariana Islands (MP) did not participate in CWNS 201 2.)
Keyword
Search
Figure 30: Facility Fact Sheet - Basic Search
6.2.2 Facility/Project Advanced Search
The Advanced Search allows users to search the Facilities/Projects on one or more of the criteria
provided in Table 6-1 (Figure 32).
• After entering one or more search criteria, click
• Click
Search
Clear
to delete all entered search criteria from the Advanced Search
Page 30
-------
CWNS 2012 Reports - Online Help
CWNS 201 2 Data and Reports
Maps Data Dashboard Technical Data Facility FactSheets Summary Report Detail Report Data Downloads
Basic Search | Advance Search
Facility Project Name : |
Authority : |
County Name : |
State : Select
(South Carolina (SC) and Northern Mariana Islands (MP) did not participate in CWNS 2012.)
System Name : |
Overall Type :
Facility Type :
Decentralized Wastewater Treatment ^
Agriculture - Animals
Nonpoint Source ^
Agriculture - Cropland ^
Plan Development
Biosolids Handling Facility
Cost Categories :
Secondary Treatment
Advanced Treatment
Infiltrate/Inflow Correction
Permit Number :
-a
Document Published :
Date
Document Type :
[Search] [Clear]
^J( %, Official, Adjusted ) Present Design Flow : | v| Q
Present Population : s/1 T
Figure 31: Facility Fact Sheet - Advanced Search
Table 6-1: Explanation of Advanced Search criteria,
Search Criteria
Explanation
Facility/Project Name
Performs a keyword search on the data field Facility/Project Name.
Type the phrase of part of the phrase in the text box.
State
Limits the Facility/Project List to the selected State. The default
selection is Nation. A State must be selected in order to search by
System Name, County, and/or Watershed. Select the desired State
from the dropdown list.
Note: South Carolina and Northern Mariana Islands are not listed,
because they did not report data for CWNS 2012.
Authority
Performs a keyword search on the data field Authority. Type the
phrase of part of the phrase in the text box.
Page 31
-------
CWNS 2012 Reports - Online Help
System Name
Limits the Results to the selected System Name in a specified state.
First, select a State in the State search criteria. Type the phrase of
part of the phrase in the text box to perform a keyword search on the
System Name this data field. Or, click to launch the System Name
Lookup and view the list of System Names. Click the radio button of
the rlpcirprl Syctpm Nnmp nnrl then I Submit j Jhp cplprfprl Syctpm
Name is populated in the text box.
County
Limits the Results to the selected County. First, select a State in the
State search criteria. Type the phrase of part of the phrase in the text
box to perform a keyword search on the County name. Or, Click to
launch the County/FIPS Code Lookup and view the list of all
Counties/FIPS Codes in the State. Click the radio button of the desired
rnunty/FIPS Cnrlp nnrl thpn {. Submit ) Jhp cplprfprl Cnunty/FIPS Cnrlp
is populated in the text box.
Watershed
Limits the Results to the selected Watershed. First, select a State in
the State search criteria. Type the phrase of part of the phrase in the
text box to perform a keyword search on the Watershed name. Click
to launch the Watershed Lookup and select view the list of all
Watersheds in the State. Click the radio button of the desired
Wrifprchprl nnrl thpn ( Sjbmit } Jhp cplprfprl Wnfprchprl ic pnpiilnfprl
in the text box.
Overall Type
Limits the Results to the selected Overall Type(s). Select one or more
from the following: Wastewater, Decentralized Wastewater
Treatment, Point Source, Nonpoint Source, Stormwater, and Plan
Development. Use the Control key to highlight more than one Overall
Type.
Facility Type
Limits the Results to the selected Facility Type. Select one or more
Type from the provided list. Use the Control key to highlight more
than one Type.
Definitions of the Facility Types are available in the Data Dictionary.
Cost Categories
Limits the Results to the selected Cost Categories. Select one or more
Cost Category from the provided list. Use the Control key to highlight
more than one Cost Category.
Definitions of the Cost Categories are available in the Data Dictionary.
Page 32
-------
CWNS 2012 Reports - Online Help
Total Needs
Limits the Results to facilities/projects that are greater than, less
than, or equal to the entered Documented Need Amount.
Select either > (greater than), < (less than), or = (equal to) from the
dropdown list under the heading Total Need. Then enter a numeric
amount in the text box as an integer (no commas, no decimal
points).Remember: The search is based on documented needs
adjusted to January 1, 2012 dollars.
Document Publish Date
Limits the Results to facilities/projects with documentation entered
before, after, or on the specified date. Select either > (after), <
(before), or = (on) from the dropdown list under the heading
Documentation. Then enter the date in the mm/dd/yyyy format or
click ^ to launch a calendar and select a date.
Document Type
Limits the Results to the selected Document Type. Select one or more
Document Type(s) from the list provided. Use the Control key to
highlight more than one Document Type.
Permit Number
Limits the Facility/Project List to facilities/projected associated with
the entered permit number. Enter the permit number.
Present Flow
Limits the Results to facilities/projects with specified present flow
values, in MGD. Select from the dropdown list: Infiltration, Industrial,
Municipal, Total or Wet Weather Peak. Select either > (greater than),
< (less than), or = (equal to) from the dropdown list under the heading
Present Flow. Then enter the flow in MGD as an integer (no commas,
no decimal points).
Present Population
Limits the Results to facilities/projects with specified population
values. Select from the dropdown list: Residential Receiving
Collection, Residential Onsite Wastewater Treatment, Residential
Clustered Systems, Non-residential Receiving Collection, Non-
residential Onsite Wastewater Treatment, Non-residential Clustered
Systems. Select either > (greater than), < (less than), or = (equal to)
from the dropdown list under the heading Present Population. Then
enter the number of persons as an integer (no commas, no decimal
points).
6.3 Results
The Results is a list of all of the facilities and projects that meet the entered search criteria. The first
twenty facilities/projects that meet the search criteria are listed in the Results. The total number of
Page 33
-------
CWNS 2012 Reports - Online Help
Facilities/Projects that meet the search criteria is indicated at the bottom of the Results (e.g. 1-20 of 65)
(Figure 33).
You will need Adobe Acrobat Reader to view some of the files on this table. See EPA's PDF page to learn more about PDF, and for a link to the free Acrobat Reader.
Jp. Download
1 "
Cwns Nbr
Facility Name Review Status Name Permit Number Count*
Watershed Name
Authority 1
B ~
08201200136
Lake County OWTS Projected Systems Federal Accepted - Lake
Arkansas Headwaters
Lake County
B a
06012001 102
3-5 Storm Drain Facility Federal Accepted - San Bernardino
Santa Ana
City of Colton
© ~
48007064004
40 Acre Industrial WWTP Federal Accepted - Galveston
East Galveston Bay
GULF COAST WASTE DISPOSAL AUTH
(this area has been truncated)
@ D 28000005002 ABERDEEN COLLECTION SYSTEM - SOUTH Federal Accepted - Monroe Upper Tombigbee City of Aberdeen
1 - 20 of 27016 (D
Figure 32: Facility Fact Sheet - Results list
The Results are organized into the following columns:
• Fact Sheet: A PDF icon ( -I ) that can be clicked to open a PDF version an individual facility
fact sheet.
• : A checkbox to select/deselect all listed fact sheets for download.
• CWNS Nbr: A unique 11-digit identification number assigned to the facility/project by the State.
The first two digits are the Federal Information Processing Standards (FIPs) code for the State.
• Facility Name: The State's unique name for the facility/project.
• Review Status Name: Federal Accepted indicates that the facilities was reviewed and approved.
• Permit Number: The number of NPDES permit associated with the facility.
• County: The County identified as the Primary County in which the facility/project is located.
• Watershed: The watershed identified as the Primary Watershed in which the facility/project is
located.
• Authority: Name of the system (group of facilities) to which the facility has been assigned.
For each facility listed, a Fact Sheet is available. The Fact Sheet summarizes CWNS data for chosen
facility/project(s) in an easy to read PDF fact sheet. The fact sheet contains data on the following:
• Facility/Project name, CWNS number, permit, and point of contact information
• County, watershed, and Congressional District information
• Map showing the location
• Facility/Project description
• Total documented needs and documented needs by category
• Population information for centralized and decentralized wastewater treatment systems
• Flow , discharge, and effluent information for centralized wastewater treatment systems
• Population problems and 303(d) impaired waters information
• Click on -I to open a PDF version of an individual Fact Sheet (Figure 34).
Page 34
-------
CWNS 2012 Reports - Online Help
BLUE PLAINS STP
2012 Clean Watersheds Needs Survey
Description:
Point of Contact:
CWNS Number:
Permit Number(s):
County:
Watershed(s):
Congressinal
District:
Address:
The Blue Plains Wastewater Treatment Plant is the largest
advanced wastewater treatment plant in the world, with a
capacity of 370 million gallons per day (mgd)
District of Columbia Water and Sewer Authority
202-787-4172
11000001001
DC0O21199*
District of Columbia (Primary)
Middle Potomac-Anacostia-Occoquan (Primary)
98th CONGRESSIONAL DISTRICT (Primary)
5000 OVERLOOK AVE, SW, WASHINGTON, DC.20372
(this area has been truncated)
,Arlington
Washington
frtftWasl
,
m
"-,Sh«r6pgfeh
Vf
Heii
Cora-1I-
Suitlan
Hilfcrcst
Heights
Alexandria
Huntington
Grovclon
^ ul^bla Valley
Camp Sp
Clin
4: Ell 5 Microsoft Cofpacaboe
® 2315 Mofca
Figure 33: Facility Fact Sheet
• Select one or more fact sheets by marking a check in the checkbox in the Select column ( ),
• Click to download a zip file containing individual PDF files of all the selected Facility Fact
Sheets, (Figure 35).
You will need Adobe Acrobat Reader to view
1 some of the files on this table
. See EPA's PDF page to learn more about PDF, and for a link to the free Acrobat Reader.
.jp. Download
¦
Cwns Nbr
Facility Name
Review Status Name
Permit Number
County
Watershed Name Authority
a
02000102003
AUKE BAY STP
Federal Accepted
AKG572004
Juneau
Lynn Canal JUNEAU, BOROUGH OF
a
S
02000119001
DILLINGHAM WWTP
Federal Accepted
AKG570018
Dillingham
Lower Nushagak River CITY OF DILLINGHAM
a
~
02000106002
EAGLE RIVER WWTP
Federal Accepted
AK0022543
Anchorage
Anchorage ANCHORAGE, MUNICIPALITY OF, AWWU
a
Q
02000106003
GIRDWOOD WWTP
Federal Accepted
AK0047856
Anchorage
Anchorage ANCHORAGE, MUNICIPALITY OF, AWWU
Figure 34: Facility Fact Sheet - Downloading Fact Sheet(s)
• Open or Save the zip file containing the selected Fact Sheets (Figure 36).
Page 35
-------
CWNS 2012 Reports - Online Help
Internet Explorer
What do you want to do with testzip?
Size: 140 KB
From: ofmstage.rtpnc.epa.gov
I 4 Open
ij The file won't be saved automatically.
Save
Save as
j Cancel ]
Or (depending on browser)
Do you want to open or save Factsheets^zip (64.9 KB) from ofmstage.rtpnc.epa.gov?
Open
Save
-
Cancel
Figure 35: Zip file - Open or Save
• To print all the Fact Sheets, open the file then click Extract All Files (Figure 37).
°ib l-a-l
j 11 ju « Windows ~ Temporary Internet Files ^ Content.IE5 ~ 9YETEFIU ~ test * j | f Sfcrcn test p
Organize ~ Extract all files
i= ' a ®
. Favorites
*
Name
Type
Compressed size Password ...
W Desktop
® 02000102003
Adobe Acrobat Document
78 KB No
Downloads
-
T 02000119001
Adobe Acrobat Document
63 KB No
"Mi Recent Places
—
Si Libraries
(3 Documents
Music
B Pictures
j^| Videos
~
< !
rrr
—i
~
2 items
L
Figure 36: Extract Fact Sheet(s)
Then, select a location (Figure 38).
Page 36
-------
CWNS 2012 Reports - Online Help
U&J'
J Extract Compressed (Zipped) Folders
Select a Destination and Extract Files
Files will be extracted to this folder:
C:\Factsheets| Browse... j
P7l Show extracted files when complete
| Extract j [ Cancel |
Figure 37: Select a location
Then, select all the Fact Sheets, right click and select Print (Figure 39),
| ,. ~ Computer ~ OS (C:) ~ Factsheets ~ | | | Search Factsheets
Organize ~ Open with Adobe Acrobat X Print
Burn
New folder
a #
Libraries
[jj Documents
Music
H Pictures
H Videos
Name
Date modified
Type
Size
02000102003
4/14/20151:41 PM
Adobe Acrobat D...
98 KB
|^j 02000119001
4/14/20151:41 PM
Adobe Acrobat D...
80 KB ]
"B Computer
£» OS(C)
¦5
2 items selected Date modified: 4/14/20151:41 PM
Size: 177 KB
Date created: 4/14/2015 1:32 PM
Figure 38: Print
7. Summary Reports
7.1 Introduction
Summary reports display selected CWNS data for chosen geographic areas in bar graphs and pie charts.
7.2 Selection Criteria
Page 37
-------
CWNS 2012 Reports - Online Help
7.2.1 Report Output
• Select the one or more types of report outputs (Table 7-1). If no report type is selected, then
output is displayed for all report types (Figure 40).
You are here: Water» Science & Technology » Applications & Databases » Program Databases » Clean Watersheds Needs Survey » 2012 Report & Data » Summary Report
CWNS 201 2 Data and Reports
Maps Data Dashboard Technical Data Facility FactSheets Summary Report Detail Report Data Downloads
Summary reports display selected CWNS data for chosen geographic areas in bar graphs and pie charts.
1. Select One or More Types of Report Output*
Official Needs By Category
Total Documented Needs
1 Total Official Needs By State**
Number of Facilities with Needs (Wastewater and Stormwater)
Number of Facilities with Needs by State (Wastewater and Stormwater)**
Needs by Category and Present Residential Population Served
Number of Facilities by Population Served
Number of Facilities by Flow
Number of Facilities by Treatment
Total Needs over time***
1 'Small versus Large Communities
* If no report type is selected, then output is displayed for all report types.
** Only available at the Regional and National-level. Regional reports provide the data by State, and National reports provide the data by Region.
*** Only available at the National-level.
2. Select Geographic Area of Interest
For state-, regional-, or national-level summaries, select "Nation", EPA region or State(s) and click on 'Run Report' button.
EPA Region: Nation
State
No State Selected
AK - Alaska
AL - Alabama
AR - Arkansas
AS - American Samoa
(Hold down the Ctrl key to select more than one state)
(South Carolina (SO and Northern Mariana Islands (MP) did not participate in CWNS 201 2)
For watershed-, county-, or Congressional District-level summaries, first select one State. Then select one of the following: watershed, county,
or Congressional District. Click map or list to select areas. Click on 'Run Report' button.
Watershed (Hydrologic Unit Code) Map or List
County Name List
Congressional District List
Selected Watershed or County or Congressional District
(Display Only)
Run Report )
^ Reset)
Figure 39: Summary Report - Selection Criteria
For these reports, Needs are considered to be one of the following:
Page 38
-------
CWNS 2012 Reports - Online Help
• Official Needs (ON): The unfunded capital costs of projects as of January 1, 2012 that (1)
address a water quality or water quality-related public health problem existing as of January 1,
2012, or expected to occur within the next 20 years and (2) meet the CWNS documentation
requirements outlined in Chapter 1 of the Report to Congress. Official Needs can only be
reported in Categories I, II, III, IV, V, VI, and X.
• Other Documented Needs (ODN): Meet the same criteria as Official Needs, but are for needs
that are not explicitly required in the CWNS Report to Congress by Clean Water Act section
516(b)(1). Other Documented Needs can only be reported in Categories XII.
• Unofficial Cost Estimates (UCE): These cost estimates do not meet the definition of need and/
or the documentation requirements outlined in the Report to Congress. States entered these
cost estimates for purposes other than this Report, such as State-level planning and
communication with State legislatures and other groups involved with addressing and
preventing water quality problems. They do not meet that QA/QC requirements for CWNS
2012.
Table 7-1: Explanation of Types of Report Output.
Types of Report Output
Description
Official Needs By Category
A bar chart displaying the dollar amount of wastewater treatment
and collection, recycled water distribution, and stormwater
management (categories l-VI, X) Official Needs by category for the
selected geographic area. Official Needs are rounded up to the
nearest million. Needs less than $1 Million are shown as $1 Million.
Total Documented Needs by
Category
A pie chart that indicates the dollar amount of wastewater
treatment and collection, recycled water distribution, and
stormwater management (categories l-VI, X) Official Needs by
category for the selected geographic area.
Total Official Needs By State
A bar chart displaying the total wastewater treatment and collection,
recycled water distribution, and stormwater management
(categories l-VI, X) Official needs by state or EPA Region. Needs less
than $1 Million are shown as $1 Million.
Note: This chart is only available at the Regional and National-level.
Regional reports provide the data by State, and National reports
provide the data by EPA Region. When this report is selected, the
ability to select State, County, Watershed, or Congressional District
as a geographic area is disabled.
Number of Facilities with Needs
(Wastewater and Stormwater)
A pie chart that indicates how many wastewater and stormwater
management facilities have (1) no documented needs; (2) only
Official Needs documented; (3) both Official Needs and Unofficial
Page 39
-------
CWNS 2012 Reports - Online Help
Cost Estimates; (4) only Unofficial Cost Estimates in the selected
geographic area.
Number of Facilities with Needs
by State (Wastewater and
Stormwater)
A multiple bar chart that indicates how many wastewater and
stormwater management facilities have (1) no documented needs;
(2) only Official Needs documented; (3) both Official Needs and
Unofficial Cost Estimates; (4) only Unofficial Cost Estimates by state
or EPA Region.
Note: This chart is only available at the Regional and National-level.
Regional reports provide the data by State, and National reports
provide the data by EPA Region. When this report is selected, the
ability to select State, County, Watershed, or Congressional District
as a geographic area is disabled.
Needs by Category and Present
Residential Population Served
A multiple bar chart that indicates the amount of Official needs by
category for wastewater facilities that serve residential (1)
populations of less than 10,000; and (2) greater than 10,000.
Number of Facilities by
Population Served
A pie chart that indicates how many wastewater facilities that
currently serve residential (1) populations of less than 1,000; (2)
populations of 1,000 to 3,499; (3) populations of 3,500 to 9,999; (4)
populations of 10,000 or more in the selected geographic area.
Number of Facilities by Flow
A pie chart that indicates how many wastewater facilities that
currently have Total Existing Flow of less than or equal to O.lOOmgd,
O.lOlmgd to l.OOmgd, l.OOlmgd to lOmgd and more than lOmgd in
the selected geographic area.
Number of Facilities by Present
Population Served
A pie chart that indicates how many wastewater facilities that
currently have less than Secondary Treatment, Secondary
Treatment, greater than Secondary Treatment and no discharge in
the selected geographical area.
Total Needs over time
A multiple bar chart that shows the compares needs from CWNS
2008 and CWNS 2012.
Note: This chart is only available at National-level. When this report
is selected, the ability to select State, County, Watershed, or
Congressional District as a geographic area is disabled.
Small versus Large Communities
A multiple bar chart that compares the number of publicly owned
treatment works (POTWs), the present population served, and needs
Page 40
-------
CWNS 2012 Reports - Online Help
in categories l-V, X) in small community (population less than 10,000)
versus large community (population 10,000 and greater).
7.2.2 Geographic Area of Interest
Summary reports can be run at the National-, EPA Regional-, State-, Watershed-, County-, or
Congressional District- level.
Geographic
Area
Explanation
EPA Region
For data by one ofEPA's ten Regions, select the appropriate region. States located in
each Region are listed after the Region's number.
For national data, select "Nation." For State, watershed, county, and Congressional
District queries, also select "Nation."
State
Select one or more state. (Multiple states can be selected by holding down the Ctrl key
while selecting states.)
Note: South Carolina and Northern Mariana Islands are not listed, because they did not
report data for CWNS 2012.
Watershed
First, select one state. Then, click the radio button labeled Watershed.
Watershed(s) can be selected in two ways:
(1) To select a watershed(s) by viewing a map, click Map. A map of the selected state
will launch in a pop-up window. HUC 8 watersheds are outlined in purple. Click within
the outline of the desired watershed and a pop-up box will launch to indicate the name
and HUC of the selected watershed. Click OK to select this watershed or Cancel to select
a different watershed. After clicking OK, the name of the watershed will be listed in the
"Selected Watersheds" box. Repeat process to select additional watersheds. When
selection is complete, click "ubmlt >' (Figure 41).
Page 41
-------
CWNS 2012 Reports - Online Help
^ HUC Watershed MAP - Internet Explo
I i-Swl
EPfl http://ofmstage.rtpnc.epa.gov./apex.''cwns2012/f?p=109:ll:30264904776764:::
Watersheds for Delaware
LegacyHUCMap
Click the map to select a Watershed. Watersheds are outlined in purple.
/staf
¦Jowsorr
Baltimore ^Kingstown
Glen Burnt#
lns Annapolis
igton
ind
"Deale Beach Easton
Choptank 1 \
Egg Harbor Gty
_ Atlantic City
Ocean City
Delaware Bay
Harrington, _M||fotd
irles
River
Gaitibridge
Message from webpage
You have selected Watershed 02040206 - Cohansey-Maurice.
Click OK to select.
|>cbing
40 miles
•^Salisbury ¦
;• - ¦V •2015 rtrrrtfllW^M % 20-10 iK/fECi
Selected Watersheds
Cohansey-Mauri ce
(Display Only)
Submit) ^ Reset j
Figure 40: Select Watershed(s) from map
The watershed name(s) will be listed in the Selected Watershed or County or
Congressional District box (Figure 42).
Page 42
-------
CWNS 2012 Reports - Online Help
State:
CT - Connecticut
DC - District of Columbia '
DE - Delaware
FL - Florida
GA - Georgia
(Hold down the Ctrl key to select more than one state)
(South Carolina (SC) and Northern Mariana Islands (MP) did not participate in CWNS 2012)
For watershed-, county-, or Congressional District-level summaries, first select one State.
•Watershed (Hydrologic Unit Code) Map or List
County Name List
Congressional District List
ilected Watershed or Cothyy or Congressional District
(Display Only)
( Run Report j ( Reset J
Figure 41: Selected Watershed or County or Congressional District
(2) To select a watershed(s) by viewing a list of all watersheds in the state, click List.
Click to highlight the desired watershed (use the Control key to select multiple
watersheds) and then click to select the watershed(s). When selection is complete,
click
Submit
(Figure 43). The watershed name(s) will be listed in the Selected
Watershed or County or Congressional District box.
Repeat these steps to add additional watersheds from a different state.
Watersheds for Delaware
(Hold down the Ctrl key to make more than one selection.)
o
a
Submit I
J
Figure 42: Select Watershed(s) from list
Page 43
-------
CWNS 2012 Reports - Online Help
County
First, select one state. Then, click the radio button labeled County.
To select a county(ies) by viewing a list of all counties in the state, click List. Click to
highlight the desired county (use the Control key to select multiple counties) and then
click to select the county(ies). When selection is complete, click * (Figure 44).
The county name(s) will be listed in the Selected Watershed or County or Congressional
District box.
Repeat these steps to add additional counties from a different state.
County Names for Delaware
o
0
o
(Hold down the Ctrl key to make more than one selection.)
Figure 43: Select County from list
Submit
r,
Congressiona
I District
First, select one state. Then, click the radio button labeled Congressional District.
To select a Congressional District(s) by viewing a list of all Congressional Districts in the
state, click List. Click to highlight the desired Congressional District (use the Control key
to select multiple counties) and then click ^ to select the Congressional District(s). When
"Ljbm't'' (Figure 45). The Congressional District name(s) will
selection is complete, click
be listed in the Selected Watershed or County or Congressional District box.
Repeat these steps to add additional Congressional Districts from a different state.
Page 44
-------
CWNS 2012 Reports - Online Help
Congressional District(s) for Florida
3rd Congressional District
4th Congressional District a
6th Congressional District
1st Congressional District
2nd Congressional District
5th Congressional District
7th Congressional District
8th Congressional District
9th Congressional District
10th Congressional District
11th Congressional District
12th Congressional District
13th Congressional District
14th Congressional District
15th Congressional District
16th Congressional District
17th Congressional District
18th Congressional District V
19th Congressional District
S|$)
s>
-------
CWNS 2012 Reports - Online Help
You are here: Water » Science & Technology » Applications & Databases » Program Databases » Clean Watersheds Needs Survey » 201 2 Report & Data » Summary Report » Report
CWNS 201 2 Data and Report
Watershed Report for Chipola (Alabama)
Figure 45: Summary Report - results
7.4.2 Detailed Reports
For all charts, click on arty wedge or bar to get a detailed facility listing. The detailed facility listing
provides data on all the individual facilities from which the summary data presented in the chart was
derived (Figure 47).
You are here: Water» Science & Technology » Applications & Databases » Program Databases » Clean Watersheds Needs Survey » 2012 Report & Data » Summary Report
» Needs Summary Charts » Official Needs By Category
CWNS 201 2 Data and Reports
Needs category II for Chipola Watershed(s) of Alabama
Customer Satisfaction Survey Data Dictionary Help
A
3^
J oo
1 - 3 of 3
1 Facility/Plroied Name
CWNS Number
Total Official Needs Cost Cateoo
rv Code Cost Cateoorv Name
Cost Cateaorv
Permit Number
Permit Tvue
Official Needs
DOTHAN CYPRESS
CREEK WWTP
01000061001
525,417,292 11
Advanced Treatment
$9,933,627
AL0072737
Individual
Permit
WEWAHITCHKA STP
12000233001
$4,314,634 II
Advanced Treatment
$4,314,634
FL0020125
Individual
Permit
MAR!ANNA WWTP
12000256001
$3,175,396 II
Advanced Treatment
5388,427
-
-
1 - 3 of 3
Figure 46: Detailed Report
Page 46
-------
CWNS 2012 Reports - Online Help
The detail reports are displayed as a table with a predetermined set of columns. The report may be
further customized using the tools provided. The user is able to:
• Search the columns
• Select the number of rows to display per page
• Create break groups one or more columns
• Highlight cells or rows based on user defined characteristics
• Add computed columns to the table
• Perform computations on selected columns
• Create a chart from the data
• Select which columns to display
• Sort columns
• Filter the data
• Download displayed data in CSV format
Detailed information on how to use the software tools for the detail reports is available in Appendix A.
8. Detail Reports
8.1 Introduction
Detail reports display selected CWNS data for chosen geographic areas. The output is displayed in tables
which can be exported as csv files.
8.2 Selection Criteria
8.2.1 Data Area of Interest
• Select one or more Data Areas of Interest (Table 8-1). If no Data Area is selected, then output is
displayed for Water Quality Facility/Project Needs (Figure 48).
Table 8-1: Explanation of Data Areas of Interest.
Data Area of Interest
Description
Water Quality
Facility/Project Needs
A table containing of costs by needs category for the facilities located in
the selected geographic area. Select one of the following:
• Official Needs (ON): The results are limited to the unfunded
capital costs of projects as of January 1, 2012 that (1) address a
water quality or water quality-related public health problem
existing as of January 1, 2012, or expected to occur within the
next 20 years and (2) meet the CWNS documentation
requirements outlined in the CWNS 2012 Detailed Scope and
Methods. Official Needs can only be reported in Categories 1, II,
III, IV, V, VI, and X.
Page 47
-------
CWNS 2012 Reports - Online Help
• Other Documented Needs (ODN): The results are limited to
facilities that meet the same criteria as Official Needs, but are for
needs that are not explicitly required in the CWNS Report to
Congress by Clean Water Act section 516(b)(1). Other
Documented Needs can only be reported in Category XII.
• Unofficial Cost Estimates (UCE): The results are limited to the
cost estimates do not meet the definition of need and/ or the
documentation requirements outlined in the Report to Congress.
States entered these cost estimates for purposes other than this
Report, such as State-level planning and communication with
State legislatures and other groups involved with addressing and
preventing water quality problems. UCE do not meet the CWNS
2012 QA/QC requirements.
• All: The results contain Official Needs, Other Documented
Needs, and Unofficial Cost Estimates.
Wastewater T reatment
Plant Flows
A table containing flow information (existing total, present design, and
projected design) for the wastewater treatment plant facilities in the
selected geographic area.
Population Receiving
Treatment (Centralized and
Decentralized)
A table containing population receiving treatment information for the
centralized and decentralized wastewater treatment facilities in the
selected geographic area.
Wastewater Facility
Discharge Methods
A table containing discharge methods for the wastewater treatment
facilities in the selected geographic area. Because a single wastewater
treatment facility may have multiple discharge methods, it is possible
that the same facility would have multiple lines on this table.
This data area cannot be combined with other data areas.
Treatment Technologies
(Unit Processes)
A table containing treatment technologies (unit processes) for the
facilities/projects in the selected geographic area. Because a single
facility/project will likely have multiple treatment technologies, it is likely
that the same facility/project would have multiple lines on this table.
This data area cannot be combined with other data areas
Page 48
-------
CWNS 2012 Reports - Online Help
You are here: Water» Science & Technology » Applications & Databases » Program Databases » Clean Watersheds Needs Survey » 2012 Report & Data » Detail Report
CWNS 201 2 Data and Reports Customer Satisfaction Survey Data Dictionary Help
Maps
Data Dashboard
Technical Data
Facility FactSheets
Summary Report
Detail Report
Data Downloads
Detail reports display selected CWNS data for chosen geographic areas. The output is displayed in tables which can be exported as csv files.
1. Select Data Area of Interest
[DWater Quality Facility / Project Needs ©"Official Needs Oother Documented Needs
OUnofficial Cost EstimatesOAII
DWastewater Treatment Plant Flows
CUPopulation Receiving Treatment {Centralized and Decentralized)
dlWastewater Facility Discharge Methods*
DTreatment Technologies (Unit Processes)*
* Cannot be combined with other data areas.
2. Select Geographic Area of Interest
For state-, regional-, or national-level summaries, select "Nation", EPA region or State{s) and click on 'Run Report' button.
EPA Region: | Nation
State:
No State Selected
AK - Alaska
AL - Alabama
AR - Arkansas ^
AS - American Samoa (Hold down the Ctrl key to select more than one state)
(South Carolina (SC) and Northern Mariana Islands (MP) did not participate in CWNS 201 2. National s
of technical data include data from CWNS 2008 for SC and
For watershed-, county-, or Congressional District-level summaries, first select one State. Then select one of the following: watershed, county, or Congressional
District. Click map or list to select areas. Click on 'Run Report' button.
OWatershed (Hydrologic Unit Code) Map or List
OCounty Name List
OCongressional District List
Selected Watershed or County or Congressional District
(Display Only)
v Run Report) , Reset J
Figure 47: Detail Report - search criteria
8.2.2 Geographic Area of Interest
Detaii reports can be run at the National-, EPA Regional-, State-, Watershed-, County-, or Congressional
District- level.
Geographic
Area
Explanation
EPA Region
For data by one of EPA's ten Regions, select the appropriate region. States located in
each Region are listed after the Region's number.
For national data, select "NationFor State, watershedcounty, and Congressional
District queries, also select "Nation."
Page 49
-------
CWNS 2012 Reports - Online Help
State
Select one or more state. (Multiple states can be selected by holding down the Ctrl key
while selecting states.)
Note: South Carolina and Northern Mariana islands are not listed, because they did not
report data for CWNS 2012.
Watershed
First, select one state. Then, click the radio button labeled Watershed.
Watershed(s) can be selected in two ways:
(1) To select a watershed(s) by viewing a map, click Map. A map of the selected state
will launch in a pop-up window. HUC 8 watersheds are outlined in purple. Click within
the outline of the desired watershed and a pop-up box will launch to indicate the name
and HUC of the selected watershed. Click OK to select this watershed or Cancel to select
a different watershed. After clicking OK, the name of the watershed will be listed in the
"Selected Watersheds" box. Repeat process to select additional watersheds. When
selection is complete, click — (Figure 49).
¦'=& HUC Watershed MAP - Internet Explorer
0
EPA http://ofmstage.rtpnc.epa.gov ,apex.''cwn52012/f?p=109:ll:30264904776764::::
Watersheds for Delaware
LegacyHUCMap
Click the map to select a Watershed. Watersheds are outlined in purple.
# Bridgeton
Millville
^Smyrna'
Dennisville
Dover
° Egg Harbor Gty
f Atlantic City
Ocean City
Dehware Bay
'n9 JAnnapolis
igton
ind
Chaptank
River
Harrington.
"Golden Beach
tubing
Cambridge
Message from webpage
Si'
You have selected Watershed 02040206 - Cohansey-Maurice.
Click OK to select.
Cancel
- Salisbury
40 miles
inntrvn Parir
-y y 2015 iVlicro^f^jfp^faSou £> 201 D i i>V/TEQ
Selected Watersheds
Coh ana e y-Maur i ce
Submit 'i i Reset
(Display Only)
j ! Keset j
Page 50
-------
CWNS 2012 Reports - Online Help
Figure 48: Select Watershed(s) from map
The watershed name(s) will be listed in the Selected Watershed or County or
Congressional District box (Figure 50).
State:
CT - Connecticut
DC - District of Columbia '
DE - Delaware
FL - Florida
CA - Georgia
(Hold down the Ctrl key to select more than one state)
(South Carolina (SC) and Northern Mariana Islands (MP) did not participate in CWNS 2012)
For watershed-, county-, or Congressional District-level summaries, first select one State.
^Watershed {Hydrologic Unit Code) Map or List
' ..'County Name List
... Congressional District List
ty or Congressional District
(Display Only)
i Run Report J , Reset )
Figure 49: Selected Watershed or County or Congressional District
(2) To select a watershed(s) by viewing a list of all watersheds in the state, click List
Click to highlight the desired watershed (use the Control key to select multiple
watersheds) and then click to select the watershed(s). When selection is complete,
Submit
J (Figure 51). The watershed name(s) will be listed in the Selected
click
Watershed or County or Congressional District box.
Repeat these steps to add additional watersheds from a different state.
Page 51
-------
CWNS 2012 Reports - Online Help
Watersheds for Delaware
02060002 Chestsr-Sassafras
02040303 Chincoteague
02040205 Brandywine-Chrislina
02040207 Broad kill-Smyrna
02060005 Choptank
02040204 Delaware Bay
02080110 Eastern Lower Oelmarva
02040202 Lower Delaware
02060003 Nanticoke
02080111 Western Lower Delmarva
02080109 Western Lower Delmarva
%
s>
<3
<33
o
Q
$
£
(Hold down the Ctrl key to make more than one selection.)
, Submit j
Figure 50: Select Watershed(s) from list
County
First, select one state. Then, click the radio button labeled County.
To select a county(ies) by viewing a list of all counties in the state, click List. Click to
highlight the desired county (use the Control key to select multiple counties) and then
click ^ to select the county(ies). When selection is complete, click "Ljbm't! (Figure 52).
The county name(s) will be listed in the Selected Watershed or County or Congressional
District box.
Repeat these steps to add additional counties from a different state.
County Names for Delaware
Kent
New Castle
Sussex
§>
<3
<33
??
Q
O
O
(Hold down the Ctrl key to make more than one selection.)
i Submit j
Figure 51: Select County from list
Congressiona
1 District
First, select one state. Then, click the radio button labeled Congressional District.
To select a Congressional District(s) by viewing a list of all Congressional Districts in the
state, click List. Click to highlight the desired Congressional District (use the Control key
to select multiple counties) and then click ^ to select the Congressional District(s). When
Page 52
-------
CWNS 2012 Reports - Online Help
selection is complete, click "ubmlt'' (Figure 53). The Congressional District name(s) will
be listed in the Selected Watershed or County or Congressional District box.
Repeat these steps to add additional Congressional Districts from a different state.
Congressional District(s) for Florida
3rd Congressional District
4th Congressional District a
6th Congressional District
1st Congressional District
2nd Congressional District
5th Congressional District
7th Congressional District
8th Congressional District
9th Congressional District
10th Congressional District
11th Congressional District
12th Congressional District
13th Congressional District
14th Congressional District
15th Congressional District
16th Congressional District
17th Congressional District
18th Congressional District V
19th Congressional District
§>
-------
CWNS 2012 Reports - Online Help
3. Select Treatment Technologies (Unit Processes) of Interest*
Absorbant Bilge Pads/Biodegradable Pads
Access Road (FT) (560)
Acquire Wetlands/Riparian Areas
Activated Carbon, Powdered
Activated Sludge, Anaerobic/Anoxic/Oxic
Activated Sludge, Complete Mix
Activated Sludge, Contact Stabilization
Activated Sludge, Extended Aeration
Activated Sludge, High Rate
Activated Sludge, Other Mode
* if no unit process is selected then report is displayed for all unit processes.
( Run Report ) ( Reset )
Figure 53: Detail Report - Treatment Technologies selection
8.3 Run Report
After selecting desired report outputs, geographic areas and unit process (if applicable), click
-"' to view data tables.
8.4 Results
The detail reports are displayed as a table with a predetermined set of columns (Figure 55). The report
may be further customized using the tools provided. The user is able to:
• Search the columns
• Select the number of rows to display per page
• Create break groups one or more columns
• Highlight cells or rows based on user defined characteristics
• Add computed columns to the table
• Perform computations on selected columns
• Create a chart from the data
• Select which columns to display
• Sort columns
• Filter the data
• Download displayed data in CSV format
Detailed information on how to use the software tools for the detail reports is available in Appendix A.
S>
<5
-------
CWNS 2012 Reports - Online Help
You are here: Water » Science & Technology » Applications & Databases » Program Databases » Clean Watersheds Needs Survey » 2012 Report & Data » Detail Report » Facility Details
CWNS 201 2 Data and Reports
Detailed listing of Wastewater Treatment
17.03
25.79
26.53
A i i
Go
Actions
IIT5®oo
1 - 6 of 6
CWNS Number Existing Total Present Design
Permit Number Permit T
AGAT DISTRICT WWTF
66000001001
1.13
.75
1.39
GU0020222
Individual
Permit
Guam
Waterworks
Authority
Guam
AGANA DISTRICT
WWTF
66000001002
7.5
12
12
GU0020087
Individual
Permit
Guam
Waterworks
Authority
Guam
NORTHERN DISTRICT
WWTF
66000001003
7.8
12
12
GU0020141
Individual
Permit
Guam
Waterworks
Authority
Guam
INARAJAN DISTRICT
WWTF
66000001005
.07
.19
.19
Guam
Waterworks
Authority
Guam
TALAFOFO DISTRICT
WWTF
66000001006
.25
.6
.6
GU0020095
Individual
Permit
Guam
Waterworks
Authority
Guam
UMATAC-MERIZO
WWTF
66000001008
.28
.25
.35
GU0020273
Individual
Permit
Guam
Waterworks
Authority
Guam
1 - 6 of 6
Figure 54: Detail Report Results
9. Data Downloads
Allows the user to download a Microsoft Access database of the CWNS 2012 data for a particular state
or for the nation (Figure 56).
* Select one State or Nation from the dropdown list and click —— .
* Save the Microsoft Access file to the desired location.
Note: South Carolina and Northern Mariana Islands are not listed, because they did not report
data for CWNS 2012.
The Data Dictionary explains the data elements that are provided in the Microsoft Access database.
Page 55
-------
CWNS 2012 Reports - Online Help
You are here: Water» Science & Technology » Applications & Databases » Program Databases » Clean Watersheds Needs Survey » 2012 Report & Data » Data Downloads
CWNS 201 2 Data and Reports
Maps Data Dashboard Technical Data Facility FactSheets Summary Report Detail Report Data Downloads
Access Database
Select a state and click on "Download" button to download data in Microsoft Access database format (version 2003 and up).
State: | National vj [Download]
(South Carolina (SC) and Northern Mariana Islands (MP) did not participate in CWNS 2012.)
Figure 55: Select State for Data Download
Appendices
Appendix A: Customizing Detailed Reports
Detail Report Help
A Detail Report displays a predetermined set of columns. The report may be further customized with an
initial filter clause, a default sort order, control breaks, highlighting, computations, aggregates and a
chart. Each Report can then be further customized and the results can be viewed or downloaded.
An Interactive Report can be customized in three ways: the search bar, actions menu and column
heading menu.
Search Bar
At the top of each report page is a search region (Figure A-l). The region provides the following
features:
• Select columns icon ( r) allows you to identify which column to search (or all).
• Text area allows for case insensitive search criteria (no need for wild cards).
• [Go] button executes the search.
• [Actions] button displays the actions menu (discussed next).
Please note that all features may not be available for each report.
Page 56
-------
CWNS 2012 Reports - Online Help
/ r
All Columns
Facility/Project Name
CWNS Number
Existing Total Flow (Mgal.'d)
Present Design Total Flow (Mgal , c
Projected Design Total Flow (Mgal
Permit Number
Permit Type
Authority Name
County Name
Watershed Name
Watershed HUC
Congressional District
State
Region
Latitude
Longitude
Go
Actions
mber
Existina Total
Flow (Maal/d)
Pd
Tata
>001
.06
5001
3
4001
4.7
>001
.017
5004
1.48
i V v * I r
ANNISTON FT.
MCCLELLAN WWTP
7001
01000007002
Figure A-l: The search bar allows you to search for a word or phrase on either all columns or a selected column.
Actions Menu
The actions menu (Figure A-2) is used to customize the display of your Interactive Report,
• Select Rows Per Page to specify the number of rows per page.
• Format actions are described below.
Figure A-2: The Actions Menu allows customization of the report
Control Break
Used to create a break group on one or several columns (Figure A-3). This pulls the columns out of the
Interactive Report and displays them as a master record. This may be useful for viewing
facilities/projects by county or watershed or Congressional District within a State.
Page 57
-------
CWNS 2012 Reports - Online Help
A
i
Go
Actions
S it T9«no
::p Control Break
Column Status
County Name
Enabled V
- Select Column -
V
Enabled V
- Select Column -
V
Enabled v
- Select Column -
V
Enabled v
- Select Column -
V
Enabled v
- Select Column -
V
Enabled N/
Cancel
Apply
0 "22County Name 0"*
1-100 Of 267 (£)
County Name : Autauga
Project Name CWNS Number Existi
na
Total Present Desian Pro
m
ed Desian Permit Number Permit T1
Flow 1
>w (Mqal/d)
PRATTVILLE 01000139001 2.8
AUTAUGA CREEK
WWTP
AUTAUGAVILLE WWTP 01000015001 .066
AL0026654
Individual
Permit
.075
AL0057720 Individual
Permit
County Name : Baldwin
CWNS Number Existina Total Present Desian Protected Desian Permit Number Permit Ti
LOXLEY LAGOON
01000101001
Orange Beach WWTP 01 201200005
.235
4.1
.25
10
.25
10
AL0060283
AL0081124
Individual
Permit
Individual
Permit
Figure A-3: The Control Break function allows the creation of breaks based on data in one or more columns.
Highlight
Highlighting allows for specifying a filter (Figure A-4). The rows that meet the filter are highlighted using
the characteristics associated with the filter.
• Name is used only for display.
• Sequence identifies the sequence in which the rules will be evaluated.
• Enabled identifies if the rule is enabled or disabled.
• Highlight Type identifies whether the Row or Cell should be highlighted. If Cell is selected, the
column referenced in the Highlight Condition is highlighted.
• Background Color is the new color for the background of the highlighted area.
• Text Color is the new color for the text in the highlighted area.
• Highlight Condition defines your filter condition.
Page 58
-------
CWNS 2012 Reports - Online Help
1
\ \-
Go
Actions
$ 7S«
1
3#
oo
Highlight
Name
pVWTP
X |
Sequence
10
Enabled
Yes V
Highlight Type
Row V
Background Color
#FFFF99
~ ~
Text Color
#99CCFF
~ ~
Highlight Condition
Column
[yellow] [green] [blue] [orange] [red]
[yellow] [green] [blue] [orange] [red]
Operator Expression
Facility,'Project Name
V1 contains
S/|WWTP
Cancel
Delete
Apply
si-
s | VVWTP | 0|1
1-100 of 267 @
Go
Actions
* Yl
3^
0 OO
f CWNS Number Existina Total Present Desian Pro
II
Flow (Mqal/d) Total Flow (Maal/d) Tola.
AKRON LAGOON
01000002001
01000003001
01000004001
.06
.11
.11
ALTOONA LAGOON 01000005001
.017
.016
.07
Figure A-4: The Highlight function allows for highlighting rows that meet a certain condition. In this case, highlighted rows have the word
"WWTP" in the Facility/Project Name column.
Compute
Computations allow you to add computed columns to your report (Figures A-5 and A-6). These can be
mathematical computations (e.g. NBR_HOURS/24) or standard Oracle functions applied to existing
columns (some have been displayed for example, others, like TO_DATE, can also be used).
• Computation allows you to select a previously defined computation to edit.
• Column Heading is the column heading for the new column.
• Format Mask is an Oracle format mask to be applied against the column (e.g. $9999).
• Computation is the computation to be performed. Within the computation, columns are referenced
using the aliases displayed.
Below computation, the columns in your query are displayed with their associated alias. Clicking on the
column name or alias will write them into the Computation. Next to Columns is a Keypad. These are
simply shortcuts of commonly used keys. On the far right are Functions.
Page 59
-------
CWNS 2012 Reports - Online Help
r.
>i:
'H#t
~ T!
3#"
0 (DO
Compute
Computation! - New Computation - v
Column Heading Cat. Ill & IV
Computation &
Format MaskjFML999G999G999G999G9!H
EP + ER + EV + ]
Keypad
EP.
Cat. III A ON
ER.
Cat. Ill B ON
ET.
All Cat. Ill ON
EV.
Cat. IV A ON
EX.
Cat. IV B ON
s
Create a computation using column aliases.
Examples:
1. (B+Q*100
2. INITCAP(B) I', 'IJINITCAPfC)
3. CASE WHEN A = 1 0 THEN B-rC ELSE B END
(
)
II
ABS
7
8
9
-
ADD.MONTHS
4
5
6
+
CASE
1
2
3
*
CAST
0
CEIL
0
Figure A-5: The Computation function allows for calculations on selected columns. In this example, Category III & IV needs are being adding
to determine all Collection System needs for each facility.
ssa 1
' 1 --- 1 X-Sk.
Rows[500
32°)
m it T
w o o
a Hi
1 - 182 of 182
1 Facility/Project Name
CWNS Number
Cat. 1 Cat. II
All Cat. III
All Cat. IV
Cat. Ill & IV
Cat- V All Cat VI Cat. X
1
ON ON
ON
ON
ON ON ON
Little Rock - Fourche
Creek WWTP
05000001001
"
$28,168,724
$10,109,796
$38,278,520.00
-
Little Rock - Adams Field
WWTP
05000001008
"
$32,196,081
$5,510,284
$37,706,365.00
North Little Rock -
Faulkner Lake
05000003002
$4,816,979
$2,981,689
-
"
-
North Little Rock - 5 Mile
Creek
05000003003
"
$450,000
-
-
North Little Rock - White
Oak Bayou
05000003004
$4,500,000
$1,140,000
-
Blytheville - North WWTP
05000009002
"
$3,057,835
"
Figure A-6: The result of the calculation is displayed as a new column in the table.
Aggregate
Aggregates are mathematical computations performed against a column (Figure A-7 and A-8).
Aggregates are displayed after each control break and at the end of the report within the column they
are defined.
• Aggregation allows you to select a previously defined aggregation to edit.
• Function is the function to be performed (e.g. SUM, MIN).
Page 60
-------
CWNS 2012 Reports - Online Help
Column is used to select the column to apply the mathematical function to. Only numeric columns
will be displayed.
rs
/ r
Go
Actions
SI / #• d C 2
H-2 Aggregate
Aggregation
Function :
Column I
- New Aggregation - V
Sum V
Cat. 1 ON v
Cancel
Apply
Figure A-7: The Aggregate function allows for a calculation on a single column. In this example, the sum of Category I needs for the entire
state.
CWNS Number Cat. I Cat II Cat. Ill A Cat Ifl B Permit Number
ON ON ON ON 1
AGAT DISTRICT WWTF 66000001001 $66,774,144 - 53,924,461 $57,839 GU0020222
AGANA DISTRICT 66000001002 $31,816,276
WWTF
NORTHERN DISTRICT 66000001003 $43,158,823
WWTF
INARAJAN DISTRICT 66000001005 SI,787,597
WWTF
TALAFOFO DISTRICT 66000001006 58,806,630
WWTF
UMATAC-MERIZO 66000001008 $13,985,842
WWTF
1 - 6 of 6
- $2,032,033 $111,754,885 CU0020087
- $2,833,532 $23,027,796 GU0020141
$2,322,722 GU0020095
$30,110 GU0020273
Figure A-8: The results are displayed at the end of the column.
Chart
You can include one chart per Interactive Report (Figures A-9 and A-10). Once defined, you can switch
between the chart and report views using links below the search bar.
• Chart Type identifies the chart type to include. Select from horizontal bar, vertical bar, pie or line.
• Label allows you to select the column to be used as the label.
• Axis Title for Label is the title that will display on the axis associated with the column selected for
Label. This is not available for pie chart.
• Value allows you to select the column to be used as the value. If your function is a COUNT, a Value
does not need to be selected.
Page 61
-------
CWNS 2012 Reports - Online Help
Axis Title for Value is the title that will display on the axis associated with the column selected for
Value. This is not available for pie chart.
Function is an optional function to be performed on the column selected for Value.
& 1 1
Go
Actions
¦ r
5*
¦li ©o
. . Chart
Chart Type©| J 0|||| P|g> P|=W;
Label
Facility/Project Name
Value Total ON
Function Sum
Sort I
Default
V Axis Title for Label Facility
Axis Title for Valuejofficial t1
Apply
I El Edit Chart
AGANA DISTRICT WWTF
NORTHERN DISTRICT WWTF
AGAT DISTRICT WWTF
UMATAC-MERIZO WWTF
TALAFOFO DISTRICT WWTF
INARAJAN DISTRICT WWTF
50,000,000.00 100,000,000.00 150,000,000.00 200,000,000.00
Official Needs
Figure A-9: Example of a bar graph comparing the total needs per facility in a specified county.
Page 62
-------
CWNS 2012 Reports - Online Help
Rows! 500 M[Go]^|_
Chart
Chart Type o|j O [| || ® O O
Labe
Value
Function
Sort
Facility/Project Name | v
Total ON \v]
Sum [v
Default (vj
[ Cancel ] | Delete ][ Apply ]
i*
Ed ft Chart View Report
-Edmondson WWTP - $1,024,194
Earle WWTP - $3,144,723
Horseshoe Lake WWTP - $588,572
^—Crawfordsville WWTP - $389,055
-—Marion WWTP - $168,936
-Turrell WWTP - $155,816
-Gilmore WWTP - $20,484
-Jennette WWTP - $4,495,076
Figure A-10: Example of a pie chart displaying the same data as Figure A-9, the total needs per facility in a specified county.
Select Columns
Used to modify the columns displayed (Figure A-ll). The columns on the right are displayed. The
columns on the left are hidden. You can reorder the displayed columns using the arrows on the far right.
Computed columns are prefixed with **.
Y m*
Columns
DO Ni>l DiSpfJry
Display RtpKXl
Portcfewtacnumf
Part of Contact 5V*ft i
Po^ti 0l C$«tact s*Mt +4#*85 2
Fort of Contact CH>
Port of Ccrtad Siafi*
: Port of Cdrittrctlip
Port of Cortacf Pfioile
POrtofC*
-------
CWNS 2012 Reports - Online Help
Used to change the column(s) to sort on and whether to sort ascending or descending (Figure A-13). You
can also specify how to handle nulls (use the default setting, always display them last or always display
them first). The resulting sorting is displayed to the right of column headings in the report.
* & -
H *«*
Column
D»r««Kwi
N«(l Soiling
1 ToWOM
*
Ascending
V
2 ¦ CcJumn -
-
AscfcridMi?
D*tajK
vi
3 - Sfset -
V
Ascertains
»
V
4 * S«Kt •
V
A$c*ncUn9
V
DtfM
V
S - 2&ta Cc&unn -
V
A££AAdffl9
V
D«f*n
»
6 -SOKtOskfun-
V
ASMfldUn®
V
Df*J«
V
[ C*lMt | | J
CamsT)
Figure A-13: The sort function allows you to sort by column(s). In this example, the data will be sort from the lowest Total Official Needs
(ON) to the highest
Filter
Used to add or modify the where clause on the query (Figure A-12). You first select a column (it does not
need to be one that is displayed), select from a list of standard Oracle operators (=, !=, not in, between),
and enter an expression to compare against. The expression is case sensitive and you can use % as a wild
card (e.g. STATE_NAME like A%).
~
»
Filte-r
Column
Operator
l*pwes&ian
Wale rafted Name
vJSpnrg |v,
c***' [*»»!]
: rpirfl gt u^raaa un>
Fort of Ccrtact Siafi#
Port of C-c
-------
CWNS 2012 Reports - Online Help
- it » C=
| Download
C hora* report down to Jd formji
"W
CSV
[c»wl J
Figure A-14: The Download function allows you to download to CSV format to be viewed in Excel. Note: the current displayed results will be
downloaded.
Reset
Resets the report back to the default settings, removing any customizations that you have made.
Skip to First/ Last Page
Allows you to navigate to the first or last page of the results.
Column Heading Menu
Clicking on any column heading exposes a column heading menu.
• Sort Ascending icon ( ®) sorts the report by the column in ascending order.
• Sort Descending icon () sorts the report by the column in descending order.
creates a break group on the column. This pulls the column out of the report
Break Column (
as a master record.
Text Area is used to enter case insensitive search criteria (no need for wild cards). Entering a value
will reduce the list of values at the bottom of the menu. You can then select a value from the
bottom and the selected value will be created as a filter using '=' (e.g. column = 'ABC'). Alternatively,
you can click the flashlight icon and the entered value will be created as a filter with the 'LIKE'
modifier (e.g. column LIKE '%ABC%').
List of Unique Values contains the first 500 unique values that meet your filters. If the column is a
date, a list of date ranges is displayed instead. If you select a value, a filter will be created using '='
(e.g. column = 'ABC').
Page 65
-------
CWNS 2012 Reports - Online Help
c 0 0 "1
,1 1
Autauga
F
Baldwin
a
Barbour
Bibb
Blount
Bullock
Butler
Calhoun
Chambers
F
Figure A-15: Column heading options
Page 66
-------