4>EPA
www.epa.gov
1
Reuse and the Benefit to Community
Koppers Coke Superfund Site
Technical Appendix
Positive Impacts: Employment Information for On-site Jobs
The Dun & Bradstreet (D&B) database provided information on the number of employees and sales volume for on-site businesses.
D&B provides information on businesses and corporations. It maintains a database of over 179 million companies globally and over
53 million professional contact names using a variety of sources, including public records, trade references, telecommunication
providers, newspapers and publications, and telephone interviews. The Data Universal Numbering System (DUNS) number is a
unique nine-digit identification number assigned by D&B to each business and its location within the D&B database for identifying
each business. The Saint Paul Port Authority also collects data on Energy Park tenants; this analysis compared data provided by the
Port Authority with the data provided by D&B. In most cases, the analysis selected the lower of the two employment estimates to be
conservative. The analysis selected the Port Authority's employment estimates for two on-site businesses, Prometric and US
Bancorp Information Services Corporation, rather than data from D&B, because the Port Authority's estimates appeared to be more
accurate.
Positive Impacts: Wage and Income Information for On-site Jobs
The U.S. Bureau of Labor Statistics (BLS) provided wage and income information. The BLS is a governmental statistical agency that
collects, processes, analyzes and disseminates essential statistical data to the American public, the U.S. Congress and other federal
agencies in the broad field of labor economics and statistics. The data provided by the BLS has high standards of accuracy and
consistently high statistical quality, and impartiality in both subject matter and presentation.
The BLS Quarterly Census of Employment and Wages database provided average weekly wage data for each of the businesses
located at the Koppers Coke site. Average weekly wage data was identified by matching the North American Industry Classification
System (NAICS) codes corresponding with each type of business with weekly wage data for corresponding businesses in Ramsey
County. If not available at the county level, the wage data were sought by state or national level, respectively. In cases where wage
data was not available for the six-digit NAICS code, higher level (less detailed) NAICs codes were used to obtain the wage data.
To determine the annual wages (mean annual) earned from jobs generated by each of the businesses at the Koppers Coke site, the
average weekly wage figure was multiplied by the number of weeks in a year (52) and by the number of jobs (employees) for each of
the businesses.

-------
Table 1: Koppers Coke Site Businesses: NAICS Code and Title, Average Weekly Wage, Employees, Annual Wages and Total Annual Wage per Employee
On-site Business
NAICS Code3
NAICS Title
Employees'3
Average
Weekly Wage
(2010)c
Annual Wage
(Mean Annual)
per Employee
Total Annual
Wagesd
US Bancorp Information Services
Corporation
518210
Data Processing, Hosting, and Related Services
l,250e
$1,473
$76,596
$95,745,000
Kemps LLC
31151
Dairy Product, Except Frozen, Manufacturing
171
$1,084
$56,368
$9,638,928
Prometric
541380
Testing Laboratories
89e
$1,151
$59,852
$5,326,828
Power/Mation Division, Inc.
423840
Industrial Supplies Merchant Wholesalers
63e
$896
$46,592
$2,935,296
Metropolitan State University
9231
Administration of Human Resource Programs
50
$1,056
$54,912
$2,745,600
Minnesota Bureau of Mediation
Services
926150
Licensing and Regulating Commercial Sectors
13
$1,138
$59,176
$769,288
Evergreen Medical Technology LLC
541720
Social Sciences and Humanities Research
8
$884
$45,968
$367,744
Minnesota Health Professional
Service Program (HPSP)
813920
Professional Organizations
5e
$1,346
$69,992
$349,960
Headwaters Software Inc (FISDAT)
517110
Wired Telecommunications Carriers
5e
$1,010
$52,520
$262,600
DRIASI
524298
All Other Insurance Related Activities
5e
$1,407
$73,164
$365,820
USA Central Station
56162
Security Systems Services
3
$919
$47,788
$143,364
The Law Firm of Roberts &
Stotzheim Pic
541110
Offices of Lawyers
2
$1,285
$66,820
$133,640
Aramark Corp
541611
Administrative Management and General
Management Consulting Services
2
$1,064
$55,328
$110,656
Beneficial Cleaning Services Inc.
561790
Other Services to Buildings and Dwellings
1
$684
$35,568
$35,568
Totals:


1,667


$118,930,292
a NAICS code provided in D&B database.
b Employee data is from D&B database, except where otherwise indicated.
c Average weekly wage per employee based upon BLS Average Weekly Wage data.
d Total annual wage figures were derived by multiplying "Employees" by "Annual Wage (Mean Annual) per Employee."
0 Employee number obtained from Saint Paul Port Authority.
2

-------
Positive Impacts: Local Tax Revenue Generated from Property Taxes
Property records accessible through Ramsey County's online property records database (http://maps.metro-
inet.us/RamsevCoGIS/CXviewer.htm) provided data on the most recently assessed property values and taxes for
property parcels at the Koppers Coke site in March 2012.
Table 2. Estimated Property Values and Annual Tax Amounts (2011)
Parcel Number
Market Value -
Land (2011)
Market Value -
Building (2011)
Total Market
Value (2011)
Total Tax Payable
(2011)
272923410039
$6,272,700.00
$12,537,300.00
$18,810,000.00
$762,888.00
272923420077
$823,100
$4,876,900.00
$5,700,000.00
$213,640.00
272923420073
$737,300.00
$2,112,700.00
$2,850,000.00
$107,500.00
272923420086
$546,300.00
$2,303,700.00
$2,850,000.00
$107,500.00
272923420085
$221,500.00
$0.00
$221,500.00
$0.00
272923420071
$420,000.00
$1,297,200.00
$1,717,200.00
$65,484.00
272923310105
$1,937,300.00
$7,400,300.00
$9,337,600.00
$360,408.00
272923310004
$184,200.00
$0.00
$184,200.00
$7,056.00
Totals:
$11,142,400.00
$30,528,100.00
$41,670,500.00
$1,624,476.00
3

-------