MEMORANDUM
TO:
The
Record
FROM:
TJ
Finseth,
ERG
DATE:
11
August
2005
SUBJECT:
Steam
Electric
Query
Documentation
ERG
used
four
data
sources
to
support
the
development
of
the
Preliminary
Engineering
Report:
Steam
Electric
Detailed
Study:
the
Toxics
Release
Inventory
(
TRI),
Permit
Compliance
System
(
PCS),
Energy
Information
Administration
(
EIA),
and
the
316(
b)
Cooling
Water
Intake
Structures
Rulemaking.
ERG
extracted
data
on
steam
electric
facilities
from
these
sources
and
consolidated
the
data
into
a
database
that
was
used
in
the
engineering
analyses.

°
TRI
Database
­
Contains
information
about
wastewater
discharges.
Uses
a
unique
identification
number
for
each
facility.
°
PCS
Database
­
Contains
information
about
wastewater
discharges.
Uses
the
facility's
NPDES
permit
ID
for
facility
identification.
°
EIA
Database
­
Contains
information
about
capacity
and
fuel
source
for
facilities
in
the
steam
electric
industry.
Uses
a
unique
identification
number
for
each
facility.
°
316(
b)
Cooling
Water
Intake
Structures
Rulemaking
database
­
Created
from
an
EPA
survey
and
contains
general
plant
information,
cooling
water
uses,
and
design
and
operational
data.
Contains
both
the
PCS
and
EIA
identification
numbers
for
some
facilities.

This
memorandum
describes
the
methods
ERG
used
to
link
the
data
from
each
source
by
facility
and
documents
the
initial
queries
using
the
consolidated
database.

Consolidated
Database
Development
ERG
extracted
data
from
PCS
and
TRI
for
steam
electric
facilities.
Steam
electric
facilities
use
either
fossil
fuels
or
nuclear
energy
and
a
steam
turbine
to
produce
electricity.
Steam
electric
facilities
are
divided
into
utilities,
nonindustrial
nonutilities,
and
industrial
nonutilities
based
on
their
regulatory
status
and
the
primary
purpose
of
the
facility.
The
Preliminary
Engineering
Report:
Steam
Electric
Detailed
Study
contains
additional
information
on
the
definitions
of
these
terms.
The
number
of
steam
electric
facilities
in
each
database
is:
Memorandum
11
August
2005
Page
2
°
EIA:
1,457
(
includes
utilities,
nonutilities,
and
industrial
nonutilities)
°
PCS:
902
(
includes
utilities
and
nonutilities)
°
TRI:
375
(
includes
utilities
and
nonutilities)

ERG
developed
a
method
of
matching
the
EIA
identification
number
to
both
the
PCS
NPDES
ID
and
the
TRI
Facility
ID.
EPA's
Facility
Registry
System
(
FRS)
provides
the
facility
name,
TRI
ID,
and
NPDES
ID
for
all
facilities
registered
with
the
EPA.
FRS
assigns
a
unique
identification
number
to
all
facilities
in
the
system
and
links
this
number
to
both
the
NPDES
ID
and
the
TRI
ID,
which
allowed
ERG
to
match
info
from
these
two
sources
by
facility.

ERG
then
used
a
three
step
approach
to
link
the
EIA
ID
number
to
the
information
provided
in
the
FRS
system.

1.
The
316(
b)
Cooling
Water
Intake
Structures
Rulemaking
information
contained
the
NPDES
ID
and
the
EIA
ID
by
facility.

2.
For
facilities
that
were
not
in
the
316(
b)
Cooling
Water
Intake
Structures
Rulemaking
database,
ERG
performed
an
initial
facility
match
by
zip
code.
Using
the
zip
code
did
not
link
all
facilities
since
some
facilities
did
not
report
zip
codes,
some
zip
codes
were
incorrect,
and
some
zip
codes
contain
multiple
facilities.
ERG
manually
checked
each
match.

3.
ERG
created
a
list
of
the
top
polluting
steam
electric
facilities
in
the
PCS
database
by
Toxic­
Weighted
Pound
Equivalent
(
TWPE).
The
top
200
facilities
represented
99.4
percent
of
the
total
steam
electric
TWPE,
and
therefore,
ERG
linked
facilities
in
the
top
200
that
had
not
been
matched
by
zip
code.
By
comparing
data
available
in
Envirofacts,
PCS,
and
EIA,
all
but
9
of
the
Top
200
PCS
facilities
were
matched
to
EIA,
with
the
few
exceptions
being
facilities
in
Puerto
Rico
and
the
Virgin
Islands
since
the
EIA
database
does
not
contain
information
from
U.
S.
territories.

This
procedure
allowed
ERG
to
account
for
the
majority
(>
99%)
of
the
discharges
from
steam
electric
facilities.
ERG
created
a
table
that
lists
the
NPDES
ID,
the
TRI
Facility
ID,
and
EIA
ID
that
can
be
used
to
combine
information
from
any
of
the
three
databases.

EIA
Database
ERG
used
the
data
from
EIA
to
obtain
information
on
regulated
status,
generator
size,
and
other
facility
information.
ERG
used
the
following
queries
to
extract
the
relevant
data
from
information
provided
on
EIA's
Web
site.

101
­
Make
All
Units
2002
Table
Memorandum
11
August
2005
Page
3
ERG
downloaded
the
electricity
generating
capacity
report
for
2002
(
Form
EIA­
860)
from
the
EIA
Web
site
(
http://
www.
eia.
doe.
gov/
cneaf/
electricity/
page/
capacity/
capacity.
html).
ERG
imported
this
table
into
Access
for
easier
data
manipulation.
The
EIA
Web
site
contains
a
description
of
each
data
element.
The
All
Units
2002
table
contains
the
following
fields:

°
State;
°
County;
°
Company;
°
Plant
ID
­
EIA
assigned
code;
°
Plant
Name;
°
Primary
Purpose
­
The
NAICS
code
for
the
facility;
°
Generator
ID
­
Generator
Identification;
°
Nameplate
Capacity;
°
Summer
Capacity;
°
Winter
Capacity;
°
Multigenerator
Code;
°
Prime
Mover;
°
Energy
Source
1;
°
Energy
Source
2;
°
Energy
Source
3;
°
Energy
Source
4;
°
Energy
Source
5;
°
Energy
Source
6;
°
Initial
month
of
operation;
and
°
Initial
year
of
operation.
°
Plant
Zip
­
The
facilities
zip
code;
°
Type
­
Type
of
reporting
entity
­
`
R'
regulated
or
`
U'
unregulated;
and
°
Watersource
­
Source
of
water
for
cooling
purposes.

102
­
Make
Steam
Electric
Table:
Creates
"
Steam
Electric
Table",
which
contains
all
the
fields
from
"
All
Units
2002",
but
only
the
facilities
that
are
part
of
the
steam
electric
category.
The
steam
electric
category
is
defined
in
the
Code
of
Federal
Regulations
Title
40
Part
423
as:

"
Discharges
resulting
from
the
operation
of
a
generating
unit
by
an
establishment
primarily
engaged
in
the
generation
of
electricity
for
distribution
and
sale
which
results
primarily
from
a
process
utilizing
fossil­
type
fuel
(
coal,
oil,
or
gas)
or
nuclear
fuel
in
conjunction
with
a
thermal
cycle
employing
the
steam
water
system
as
the
thermodynamic
medium."

ERG
included
the
following
prime
movers
from
the
EIA
database
in
the
steam
electric
category:

°
ST
­
Steam
Turbine
°
CA
­
Combined
Cycle
Steam
Part
Memorandum
11
August
2005
Page
4
°
CS
­
Combined
Cycle
Single
Shaft
(
combustion
turbine
and
steam
turbine
share
a
single
generator.)

ERG
determined
that
only
the
steam
part
of
the
combined
cycle
facilities
should
be
included
in
the
preliminary
study
of
the
steam
electric
category
which
include
the
following
prime
movers:

A
list
of
all
the
prime
movers
and
their
description
is
presented
in
Appendix
A.

ERG
only
included
fossil
type
or
nuclear
fuel
energy
sources
in
the
"
Steam
Electric
Table".
The
following
energy
sources
were
included:

°
BIT
­
Anthracite
Coal,
Bituminous
Coal
°
LIG
­
Lignite
Coal
°
SUB
­
Subbituminous
Coal
°
WC
­
Waste/
Other
Coal
°
DFO
­
Distillate
Fuel
Oil
°
JF
­
Jet
Fuel
°
KER
­
Kerosene
°
RFO
­
Residual
Fuel
Oil
°
WO
­
Oil­
Other
and
Waste
Oil,
Crude
Oil,
Liquid
Byproducts,
Oil
Waste,
Propane
(
Liquid),
Re­
Refined
Motor
Oil,
Sludge
Oil,
Tar
Oil
°
NG
­
Natural
Gas
°
NUC
­
Nuclear
(
Uranium,
Plutonium,
Thorium)

Appendix
B
contains
a
complete
list
of
energy
sources.

106
­
Make
EIA
Steam
Facility
List:
Counts
the
number
of
generating
units
at
each
facility
and
sums
the
total
capacity
for
each
facility
in
the
steam
electric
category.

108
­
Energy
Sources
Not
in
423:
Contains
all
the
information
for
the
energy
sources
outside
the
scope
of
40
CFR
Part
423.
These
energy
sources
include
the
following:
AB,
BFG,
BLQ,
GEO,
LFG,
MSW,
OBS,
OBL,
OBG,
OG,
OTH,
PC,
PG,
PUR,
SC,
SLW,
SUN,
TDF,
WAT,
WDS,
WDL,
WND,
and
NA.
Appendix
B
contains
a
list
of
these
abbreviations
and
their
description.

108b
­
Energy
Sources
Not
in
423
by
Facility:
Sums
the
capacity
for
each
non­
423
fuel
source
reported
in
108
­
Energy
Sources
Not
in
423
by
the
facility
and
the
prime
mover.
This
query
also
counts
the
number
of
generating
units
for
each
facility.

108c
­
Energy
Sources
Not
in
423
Total:
Sums
the
capacity
and
counts
the
number
of
facilities
and
generating
units
that
use
a
fuel
source
that
is
not
included
in
the
scope
of
40
CFR
Part
423.
Memorandum
11
August
2005
Page
5
The
next
set
of
queries,
queries
122
through
128,
are
used
to
separate
the
steam
electric
category
into
size
ranges
based
on
capacity.
This
query
can
be
modified
to
extract
only
utilities,
nonindustrial
nonutilities,
or
industrial
nonutilties.

122
­
Facility
Capacity
0
­
50:
Provides
the
plant
ID,
number
of
generators,
and
total
steam
electric
capacity
for
all
facilities
whose
steam
electric
capacity
is
less
than
or
equal
to
50
MW.

123
­
Facility
Capacity
50
­
100:
Provides
the
plant
ID,
number
of
generators,
and
total
steam
electric
capacity
for
all
facilities
whose
steam
electric
capacity
is
greater
than
50
and
less
than
or
equal
to
100
MW.

124
­
Facility
Capacity
100
­
200:
Provides
the
plant
ID,
number
of
generators,
and
total
steam
electric
capacity
for
all
facilities
whose
steam
electric
capacity
is
greater
than
100
and
less
than
or
equal
to
200
MW.

125
­
Facility
Capacity
200
­
300:
Provides
the
plant
ID,
number
of
generators,
and
total
steam
electric
capacity
for
all
facilities
whose
steam
electric
capacity
is
greater
than
200
and
less
than
or
equal
to
300
MW.

126
­
Facility
Capacity
300
­
400:
Provides
the
plant
ID,
number
of
generators,
and
total
steam
electric
capacity
for
all
facilities
whose
steam
electric
capacity
is
greater
than
300
and
less
than
or
equal
to
400
MW.

127
­
Facility
Capacity
400
­
500:
Provides
the
plant
ID,
number
of
generators,
and
total
steam
electric
capacity
for
all
facilities
whose
steam
electric
capacity
is
greater
than
400
and
less
than
or
equal
to
500
MW.

128
­
Facility
Capacity
>
500:
Provides
the
plant
ID,
number
of
generators,
and
total
steam
electric
capacity
for
all
facilities
whose
steam
electric
capacity
is
greater
than
500
MW.

133
­
Year
of
Operation
­
Utilities:
Sums
the
steam
electric
capacity
by
energy
source
and
start
up
year
for
utilities.

134
­
Year
of
Operation
­
Nonutilities:
Sums
the
steam
electric
capacity
by
energy
source
and
start
up
year
for
nonutilities.

PCS
2002
Steam
Electric
Database
ERG
created
the
PCS
2002
Steam
Electric
database
using
the
PCS
2002
table
from
PCSLoads2002.
For
additional
information
on
PCS
and
the
load
calculations
see
section
2.0
of
the
Screening­
Level
Analysis
Report.
The
queries
that
created
the
database
are
described
below.
Memorandum
11
August
2005
Page
6
101
­
Make
PCS
Steam
Master
List:
Creates
the
PCS
Steam
Master
List
table
which
contains
information
on
pollutant
discharges.
It
contains
all
fields
from
the
PCS
2002
table
for
the
SIC
codes
associated
with
the
steam
electric
industry,
4911,
4931,
and
4939.
It
also
calculates
the
toxic­
weighted
pound
equivalent
(
TWPE)
for
each
of
the
pollutants
by
multiplying
the
total
pounds
per
year
by
the
toxic
weighting
factor
(
TWF).

102
­
Make
PCS
Steam
Facility
List:
Creates
the
PCS
Steam
Facility
List
table
containing
the
facility
information.
It
contains
all
the
fields
from
the
PCSFAC
table
for
the
SIC
codes
associated
with
the
steam
electric
industry,
4911,
4931,
and
4939.

Flow
Analysis
ERG
used
the
PCS
database
to
perform
a
flow
analysis
of
the
steam
electric
industry.
The
analysis
calculated
the
TWPE
associated
with
four
different
flow
ranges:
<
1,
1
­
10,
10
­
50,
and
>
50
million
gallons
per
day
(
MGD).
The
following
queries
were
used
to
extract
the
pollutant
information
by
flow
range.
The
Preliminary
Engineering
Report:
Steam
Electric
Detailed
Study
contains
additional
information
about
this
analysis.

104
­
PCS
Steam
Discharges:
Identifies
all
the
discharges
from
the
PCS
Steam
Master
List
table
and
identifies
the
flow
associated
with
that
discharge.
This
query
converts
the
flow
from
million
gallons
per
year
(
MGY)
to
MGD.

105
­
Large
(>
50)
Discharges:
Collects
all
of
the
records
from
104
­
PCS
Steam
Discharges
that
have
a
flow
greater
than
50
MGD.

105b
­
Large
Flow
TWPE:
Sums
the
flow,
total
pounds
released,
and
TWPE
and
counts
the
number
of
facilities
reporting
for
each
of
the
pollutants
(
PRAMS)
in
105
­
Large
(>
50)
Discharges.

106
­
Mid
(
1­
10)
Discharges:
Collects
all
of
the
records
from
104
­
PCS
Steam
Discharges
that
have
a
flow
greater
than
1
and
less
than
or
equal
to
10
MGD.

106b
­
Mid
Flow
TWPE:
Sums
the
flow,
total
pounds
released,
and
TWPE
and
counts
the
number
of
facilities
reporting
for
each
of
the
pollutants
(
PRAMS)
in
106
­
Mid
(
1­
10)
Discharges.

106c
­
Mid­
large
(
10­
50)
Discharge:
Collects
all
of
the
records
from
104
­
PCS
Steam
Discharges
that
have
a
flow
greater
than
10
and
less
than
or
equal
to
50
MGD.

106d
­
Mid­
large
Flow
TWPE:
Sums
the
flow,
total
pounds
released,
and
TWPE
and
counts
the
number
of
facilities
reporting
for
each
of
the
pollutants
(
PRAMS)
in
106c
­
Mid­
large
(
10­
50)
Discharge.
Memorandum
11
August
2005
Page
7
107
­
Small
(<=
1)
Discharge:
Collects
all
of
the
records
from
104
­
PCS
Steam
Discharges
that
have
a
flow
less
than
or
equal
to
1
MGD.

107b
­
Small
Flow
TWPE:
Sums
the
flow,
total
pounds
released,
and
TWPE
and
counts
the
number
of
facilities
reporting
for
each
of
the
pollutants
(
PRAMS)
in
107
­
Small
(<=
1)
Discharge.

108
­
No
Flow
Discharge:
Collects
all
of
the
records
from
104
­
PCS
Steam
Discharges
that
do
not
have
a
flow
reported.
This
query
was
created
to
account
for
all
the
records
that
are
missing
from
the
previous
queries.

109
­
Chemicals
by
Flow
Distribution:
Summarizes
the
counts
of
facilities,
total
flows,
total
pounds,
and
total
TWPE
for
each
flow
category
by
pollutant.

Chlorine
and
Total
Residual
Oxidant
Releases
ERG
created
a
table
that
lists
all
of
the
releases
of
total
residual
oxidants
(
TRO)
and
chlorine
from
the
PCS
database.

122a
­
Chlorine
Releases:
Sums
the
chlorine
releases
for
each
major
utility
facility
in
the
PCS
database.
This
query
does
not
include
facilities
that
reported
zero
pounds
of
chlorine.

122b
­
Oxidant
Releases:
Sums
the
TRO
releases
for
each
major
utility
facility
in
the
PCS
database.
This
query
does
not
include
facilities
that
reported
zero
pounds
of
TRO.

122c
­
Chlorine
and
Oxidants
1,
122d
­
Chlorine
and
Oxidants
2,
and
122e
­
Chlorine
and
Oxidants
3:
Combines
the
records
from
122a
­
Chlorine
Releases
and
122b
­
Oxidant
Releases
into
one
output
table.

TRI
2002
Steam
Electric
Database
ERG
created
the
TRI
2002
Steam
Electric
database
using
the
TRI
Master
List
table
from
TRIReleases2002.
The
queries
that
created
the
database
are
described
below.

101
­
Make
TRI
Steam
Facility
List:
Creates
the
"
TRI
Steam
Facility
List"
table.
The
table
contains
all
of
the
facilities
that
are
in
the
steam
electric
power
generation
point
source
category.

102
­
Steam
Direct
Discharges:
Collects
information
for
each
direct
discharge
(
release
code
3)
reported
in
TRI
Master
List
for
steam
electric
facilities
and
the
name
of
the
stream
to
which
the
pollutant
is
discharged.
Memorandum
11
August
2005
Page
8
103
­
Steam
Indirect
Discharges:
Collects
information
for
each
indirect
discharge
(
release
code
6)
reported
in
TRI
Master
List
for
steam
electric
facilities
and
the
name
of
the
POTW
to
which
the
pollutant
is
discharged.

104
­
Steam
All
Discharges:
Combines
the
information
from
102
­
Steam
Direct
Discharges
and
103
­
Steam
Indirect
Discharges
into
one
table.

105
­
Make
TRI
Steam
Master
Table:
Creates
the
"
TRI
Steam
Master
Table"
containing
all
the
information
from
104
­
Steam
All
Discharges.

Link
Steam
to
PCS
and
TRI
Database
ERG
created
the
Link
Steam
to
PCS
and
TRI
Database
to
link
the
water
discharges
from
the
PCS
and
TRI
databases
to
the
fuel
source
and
capacity
information
in
the
EIA
database.
All
major
PCS,
TRI,
or
EIA
tables
were
created
in
their
respective
databases
and
linked
into
this
database.
The
following
analyses
were
created
using
this
database.

Concentrations
Analysis
ERG
analyzed
the
concentrations
of
the
top
pollutants
reported
to
PCS.
ERG
is
using
this
analysis
to
determine
if
the
pollutants
are
at
treatable
concentrations.

PCS
Chemical
Conc
1:
Collects
all
reported
concentrations
(
both
detects
and
non­
detects)
listed
for
final
effluent
monitoring
locations
for
facilities
in
Alaska
through
Minnesota.
The
query
excludes
concentration
values
that
are
either
zero
or
negative.

PCS
Chemical
Conc
2:
Collects
all
reported
concentrations
(
both
detects
and
non­
detects)
listed
for
final
effluent
monitoring
locations
for
facilities
in
Missouri
through
Wyoming.
The
query
excludes
concentration
values
that
are
either
zero
or
negative.

PCS
Chemical
Conc
3:
Combines
all
the
information
from
PCS
Chemical
Conc
1
and
PCS
Chemical
Conc
2.

PCS
Chemical
Conc
4:
Extracts
information
from
PCS
Chemical
Conc
3
for
utility
facilities.
A
utility
facility
is
designated
in
the
EIA
database
as
having
a
value
of
`
R'
(
regulated)
in
the
Type
field.

PCS
Chemical
Conc
5:
Provides
a
listing
of
all
the
utilities
in
PCS
Chemical
Conc
4
and
the
chemicals
that
they
release.

PCS
Chemical
Conc
6:
Counts
the
number
of
utilities
releasing
each
chemical
from
PCS
Chemical
Conc
5.
The
query
counts
both
detects
and
non­
detects.
Memorandum
11
August
2005
Page
9
PCS
Chemical
Conc
7:
Provides
the
number
of
facilities
releasing
the
specified
chemical
from
PCS
Chemical
Conc
1,
the
minimum,
maximum,
and
average
concentration
and
the
number
of
records
for
detected
concentrations.
Detected
concentrations
do
not
have
a
qualifier
in
the
new_
L
field
of
the
database.
This
query
uses
PCS
Chemical
Conc
4
for
the
concentrations
and
PCS
Chemical
Conc
6
for
the
number
of
facilities.

PCS
Chemical
Conc
8:
Counts
the
number
of
records
where
the
concentration
was
not
detected.
This
query
also
provides
the
number
of
detected
records
from
PCS
Chemical
Conc
7
and
the
total
number
of
records
for
the
specified
chemical.

PCS
Top
Pollutants
By
Energy
Source
ERG
analyzed
the
PCS
Steam
Electric
database
combined
with
the
EIA
database
to
determine
the
top
pollutants
for
each
energy
source:
coal,
natural
gas,
nuclear,
and
oil.

PCS
Top
Pollutants
­
energy
source
1:
Provides
a
list
of
NPDES
IDs
that
can
be
matched
to
the
EIA
database.

PCS
Top
Pollutants
­
energy
source
2:
Provides
the
pounds
released
and
TWPE
for
all
chemicals
that
are
released
from
each
of
the
facilities
that
are
in
PCS
Top
Pollutants
­
energy
source
1.
This
query
only
includes
facilities
that
are
categorized
as
major.
PCS
Top
Pollutants
­
energy
source
3:
Provides
a
list
of
all
of
the
facilities
that
are
in
the
EIA
Steam
Electric
table
and
what
type
of
fuel
they
use,
the
capacity
associated
with
each
fuel
source,
and
whether
it
is
a
utility
or
nonutility.

PCS
Top
Pollutants
­
energy
source
3b:
Adds
the
NPDES
ID
to
PCS
Top
Pollutants
­
energy
source
3.

PCS
Top
Pollutants
­
energy
source
3c:
Deletes
the
EIA
ID
from
PCS
Top
Pollutants
­
energy
source
3b
to
prevent
double
counting
of
the
capacity
for
facilities
that
have
more
than
one
EIA
ID
associated
with
a
NPDES
ID.

PCS
Top
Pollutants
­
energy
source
3d:
Sums
the
total
capacity
for
the
facilities
listed
in
PCS
Top
Pollutants
­
energy
source
3c.

PCS
Top
Pollutants
­
energy
source
4:
Calculates
the
percent
of
the
facility
capacity
that
each
fuel
source
provides
for
facilities
listed
in
PCS
Top
Pollutants
­
energy
source
3d.

PCS
Top
Pollutants
­
energy
source
4b:
Calculates
the
pounds
and
TWPE
of
each
pollutant
by
fuel
source
for
all
facilities
listed
in
PCS
Top
Pollutants
­
energy
source
4.
Memorandum
11
August
2005
Page
10
PCS
Top
Pollutants
­
energy
source
5:
Sums
the
total
pounds
and
TWPE
released
for
every
chemical
by
fuel
source
and
whether
the
release
was
from
a
utility
or
a
nonindustrial
nonutility.

The
next
four
queries
provide
a
list
of
the
top
pollutants
released
from
utility
facilities
by
energy
source:
PCS
Coal
Top
Pollutants
PCS
Natural
Gas
Top
Pollutants
PCS
Nuclear
Top
Pollutants
PCS
Oil
Top
Pollutants
The
next
six
queries
calculate
the
total
capacity,
the
total
pounds
released,
the
total
TWPE,
TWPE/
MW,
TWPE/
Facility,
and
MW/
Facility
for
utility
facilities
for
each
of
the
four
major
fuel
sources.

PCS
Capacity
by
Energy
1a:
Provides
a
list
of
major
facilities
and
their
associated
EIA
plant
ID.

PCS
Capacity
by
Energy
1b:
Adds
the
fuel
sources
used
and
the
type
of
facility,
utility
or
nonindustrial
nonutility
to
facilities
listed
in
PCS
Capacity
by
Energy
1a.

PCS
Capacity
by
Energy
2:
Provides
the
capacity
of
each
fuel
source
for
all
utility
facilities
in
PCS
Capacity
by
Energy
1b
that
are
matched
to
the
EIA
database.

PCS
Capacity
by
Energy
3:
Sums
the
total
nameplate
capacity
by
energy
source
and
counts
the
number
of
facilities
reporting
the
energy
source
from
PCS
Capacity
by
Energy
2.

PCS
Capacity
by
Energy
4:
Sums
the
pounds
and
TWPE
by
energy
source
for
all
utility
facilities
in
PCS
Top
Pollutants
­
energy
source
5.

PCS
Capacity
by
Energy
5:
Calculates
values
for
TWPE/
MW,
TWPE/
Facility,
and
MW/
Facility
for
each
energy
source
using
information
contained
in
PCS
Capacity
by
Energy
3
and
PCS
Capacity
by
Energy
4.

PCS
Top
Pollutants
ERG
created
tables
that
list
the
top
pollutants
released
by
all
steam
electric
facilities
that
report
to
PCS.

PCS
Top
Pollutants
1:
Provides
a
list
of
all
major
utility
facilities.

PCS
Top
Pollutants
2:
Provides
a
list
of
all
discharges
that
are
releases
greater
than
zero
pounds
from
facilities
in
PCS
Top
Pollutants
1.
Memorandum
11
August
2005
Page
11
PCS
Top
Pollutants
3:
Sums
the
discharges
in
PCS
Top
Pollutants
2
for
each
chemical
by
facility.

PCS
Top
Pollutants
4:
Sums
all
the
releases
for
each
chemical
and
counts
the
number
of
facilities
reporting
the
chemical
in
PCS
Top
Pollutants
3.
This
query
also
ranks
the
chemicals
by
the
total
TWPE
released.

TRI
Top
Pollutants
by
Energy
Source
ERG
analyzed
the
TRI
Steam
Electric
database
combined
with
the
EIA
database
to
determine
the
top
pollutants
for
each
fuel
source:
coal,
natural
gas,
nuclear,
and
oil.

TRI
Top
Pollutants
­
energy
source
1:
Provides
a
list
of
TRI
Facility
IDs
that
are
linked
to
the
EIA
database.

TRI
Top
Pollutants
­
energy
source
2:
Provides
the
pounds
released
and
TWPE
for
all
chemicals
that
are
released
from
each
of
the
facilities
that
are
in
TRI
Top
Pollutants
­
energy
source
1.

TRI
Top
Pollutants
­
energy
source
3:
Provides
a
list
of
the
facilities,
by
TRI
ID,
and
the
type
of
fuel
they
use,
the
capacity
associated
with
each
fuel
source,
and
whether
it
is
a
utility
or
nonutility.

TRI
Top
Pollutants
­
energy
source
3b:
Deletes
the
EIA
ID
from
TRI
Top
Pollutants
­
energy
source
3
to
prevent
double
counting
of
the
capacity
for
facilities
that
have
more
than
one
EIA
ID
associated
with
a
TRI
ID.

TRI
Top
Pollutants
­
energy
source
3c:
Sums
the
total
capacity
for
each
facility
listed
in
TRI
Top
Pollutants
­
energy
source
3b.

TRI
Top
Pollutants
­
energy
source
3d:
Calculates
the
percent
of
the
facility
capacity
that
each
fuel
source
provides
for
facilities
listed
in
TRI
Top
Pollutants
­
energy
source
3c.

TRI
Top
Pollutants
­
energy
source
4:
Calculates
the
pounds
and
TWPE
of
each
pollutant
by
fuel
source
for
all
facilities
listed
in
TRI
Top
Pollutants
­
energy
source
3d.

TRI
Top
Pollutants
­
energy
source
5:
Sums
the
total
pounds
and
TWPE
released
for
every
chemical
by
fuel
source
and
whether
the
release
was
from
a
utility
or
a
nonindustrial
nonutility.

The
next
four
queries
provide
a
list
of
the
top
pollutants
released
from
utility
facilities
by
energy
source:
TRI
Coal
Top
Pollutants
TRI
Natural
Gas
Top
Pollutants
TRI
Nuclear
Top
Pollutants
TRI
Oil
Top
Pollutants
Memorandum
11
August
2005
Page
12
The
next
six
queries
calculate
the
total
capacity,
the
total
pounds
released,
the
total
TWPE,
TWPE/
MW,
TWPE/
Facility,
and
MW/
Facility
for
utility
facilities
for
each
of
the
four
major
fuel
sources.

TRI
Capacity
by
Energy
1a:
Provides
a
list
of
all
TRI
Facility
IDs
and
the
associated
EIA
plant
IDs.

TRI
Capacity
by
Energy
1b:
Adds
the
fuel
sources
used
and
the
type
of
facility,
utility
or
nonindustrial
nonutility
to
facilities
listed
in
TRI
Capacity
by
Energy
1a.

TRI
Capacity
by
Energy
2:
Provides
the
capacity
of
each
fuel
source
for
all
utility
facilities
in
TRI
Capacity
by
Energy
1b
that
are
matched
to
the
EIA
database.

TRI
Capacity
by
Energy
3:
Sums
the
total
nameplate
capacity
by
energy
source
and
counts
the
number
of
facilities
reporting
the
energy
source
from
TRI
Capacity
by
Energy
2.

TRI
Capacity
by
Energy
4:
Sums
the
total
pounds
and
TWPE
by
energy
source
for
all
utility
facilties
in
TRI
Capacity
by
Energy
3.

TRI
Capacity
by
Energy
5:
Calculates
values
for
TWPE/
MW,
TWPE/
Facility,
and
MW/
Facility
for
each
of
the
energy
source
using
information
contained
in
TRI
Capacity
by
Energy
3
and
TRI
Capacity
by
Energy
4.

TRI
Top
Pollutants
ERG
created
tables
that
list
the
top
pollutants
released
by
all
steam
electric
facilities
that
report
to
TRI.

TRI
Top
Pollutants
1:
Provides
a
list
of
all
utility
steam
electric
facilities
reporting
to
TRI.

TRI
Top
Pollutants
2:
Provides
a
list
of
all
discharges
from
facilities
in
TRI
Top
Pollutants
1.

TRI
Top
Pollutants
3:
Sums
all
the
discharges
for
each
chemical
and
counts
the
number
of
facilities
reporting
the
chemical
in
TRI
Top
Pollutants
2.
This
query
also
ranks
the
chemicals
by
the
total
TWPE
released.

316(
b)
Cooling
Water
Intake
Structures
Rulemaking
Database
ERG
created
the
316(
b)
Cooling
Water
Intake
Structures
Rulemaking
Database
from
information
collected
from
the
316(
b)
survey.
The
information
contained
in
this
survey
is
considered
confidential
business
information
(
CBI)
and
is
not
publicly­
available.
This
information
was
used
to
aid
in
the
identification
of
cooling
systems
used
by
steam
electric
facilities.
Memorandum
11
August
2005
Page
13
A­
1
Appendix
A
Prime
Mover
Prime
Mover
Description
ST
Steam
Turbine,
including
nuclear,
geothermal,
and
solar
(
does
not
include
combined
cycle)
GT
Combustion
(
Gas)
Turbine
(
includes
jet
engine
design)
IC
Internal
Combustion
Engine
(
diesel,
piston)
CA
Combined
Cycle
Steam
Part
CT
Combined
Cycle
Combustion
Turbine
Part
(
type
of
coal
must
be
reported
as
energy
source
for
integrated
coal)
CS
Combined
Cycle
Single
Shaft
(
combustion
turbine
and
steam
turbine
share
a
single
generator
CC
Combined
Cycle
Total
Unit
(
use
only
for
plants/
generators
that
are
in
planning
stage,
for
which
specific
generator
details
cannot
be
provided)
HY
Hydraulic
Turbine
(
includes
turbines
associated
with
delivery
of
water
by
pipeline)
PS
Hydraulic
Turbine
­
Reversible
(
pumped
storage)
PV
Photovoltaic
WT
Wind
Turbine
CE
Compressed
Air
Energy
Storage
FC
Fuel
Cell
OT
Other
NA
Unknown
at
this
time
(
use
only
for
plants/
generators
that
are
in
planning
stage,
for
which
specific
generator
details
cannot
be
provided.)
B­
1
Appendix
B
Energy
Source
Energy
Source
Description
BIT
(
Anthracite
Coal,
Bituminous
Coal)
LIG
Lignite
Coal
SUB
Subbituminous
Coal
WC
Waste/
Other
Coal
(
Anthracite
Culm,
Bituminous
Gob,
Fine
Coal,
Lignite
Waste,
Waste
Coal)
SC
Coal­
based
Synfuel
and
include
briquettes,
pellets,
or
extrusions,
which
are
formed
by
binding
materials
and
processes
that
recycle
material
DFO
Distillate
Fuel
Oil
(
includes
all
Diesel
and
No.
1,
No.
2,
and
No.
4
Fuel
Oils)
JF
Jet
Fuel
KER
Kerosene
RFO
Residual
Fuel
Oil
(
Includes
No.
5
and
No.
6
Fuel
Oils
and
Bunker
C
Fuel
Oil)
WO
Oil­
Other
and
Waste
Oil
(
Butane
(
Liquid),
Crude
Oil,
Liquid
Byproducts,
Oil
Waste,
Propane
(
Liquid),
Re­
Refined
Motor
Oil,
Sludge
Oil,
Tar
Oil)
PC
Petroleum
Coke
NG
Natural
Gas
BFG
Blast­
Furnace
Gas
OG
Other
Gas
(
Butane,
Coal
Processes,
Coke­
Oven,
Refinery,
and
other
processes)
PG
Propane
NUC
Nuclear
(
Uranium,
Plutonium,
Thorium)
AB
Agriculture
Crop
Byproducts/
Straw/
Energy
Crops
BLQ
Black
Liquor
GEO
Geothermal
LFG
Landfill
Gas
MSW
Municipal
Solid
Waste
OBS
Other
Biomass
Solids
(
Animal
Manure
and
Waste,
Solid
Byproducts,
and
other
solid
biomass
not
specified)
OBL
Other
Biomass
Liquids
(
Ethanol,
Fish
Oil,
Liquid
Acetonitrile
Waste,
Medical
Waste,
Tall
Oil,
Waste
Alcohol,
and
other
biomass
liquids
not
specified)
OBG
Other
Biomass
Gases
(
Digester
Gas,
Methane,
and
other
biomass
gases)
OTH
Other
(
Batteries,
Chemicals,
Coke
Breeze,
Hydrogen,
Pitch,
Sulfur,
Tar
Coal,
and
miscellaneous
technologies)
PUR
Purchased
Steam
SLW
Sludge
Waste
SUN
Solar
(
Photovoltaic,
Thermal)
TDF
Tires
WAT
Water
(
Conventional,
Pumped
Storage)
B­
2
WDS
Wood/
Wood
Waste
Solids
(
Paper
Pellets,
Railroad
Ties,
Utility
Poles,
Wood
chips,
and
other
wood
solids)
WDL
Wood
Waste
Liquids
(
Red
Liquor,
Sludge
wood,
Spent
Sulfite
Liquor,
and
other
wood
related
liquids
not
specified)
WND
Wind
NA
Not
Available
