PROP HomeAbout PROPCommitteesProjectsMembershipCompostingPublicationsCertificationLegislationConferencesGrantsResources Recycling Data Management

Datamanagement Workshop ImageThe Department of Environmental Protection has been sponsoring Data Management Workshops in cooperation with the PROP every fall for over 8 years. These workshops have been designed to help county and municipal recycling officials collect, record, process and report recycling data more accurately and efficiently in an effort to reach or exceed the 35% waste diversion goal established by the Lieutenant Governor.

The following material has been collected from past four workshops and should be helpful to coordinators striving to improve their data collection and management. Check out this Data Management Fact Sheet for useful tips.

BioCycle's report on "State of Garbage 2006"

Notes from the 2007 Data Management Course

(At the 2003 Data Management Workshop attendees were handed a cd, the contents of that cd can be found here.)

Useful .HTML pages, PDF's, and Power Point Presentations
The PowerPoint presentations are the complete presentations including the notes, these tend to be larger than the .pdf's. The html files are quite a bit smaller, and without the colorful backgrounds that are included on the PowerPoint, but will play in your browser without the need for any special programs.

2006 Information Past Presentations


Check out the Directory of Largest Retailers/Grocers/Brokers in Pennsylvania. Please contact Doug Orner with changes or updates to the directory.

What Is a "Recycled" Material?

During one workshop, information was presented to determine if a particular material, based on its description, its content and its generator, is acceptable to be counted as recycled material. There is a difference between municipal solid waste and other waste and also between "recycling" and "not recycling" for reporting purposes. It is very important to distinguish between post-consumer and post-industrial material. While we should continue to support post-industrial recycling, that material cannot be claimed on the Annual Report or on a Performance Grant Application. Post-consumer material is defined as a material that has found its way into the market place. For example, old advertisement flyers that have been distributed are post-consumer material and could be counted. While scraps and waste from the printing of those flyers are post-industrial material that could not be counted.

Although it is encouraged to salvage and reuse items, neither of these methods can be used to claim materials on an Annual Report or Performance Grant. Old furniture sold in a used furniture store would be an illustration of a reused item that could not be counted as recycled. Items that are incinerated or burned for fuel cannot be counted on the Annual Report or on Performance Grants either. Thus, tires chipped and used for fuel in cement kilns cannot be counted, but tires shredded and used as a component of asphalt can be claimed.

Arrow up image

Avoiding Mistakes

There are many ways to avoid mistakes when collecting and reporting recycling data. The following is a list of the 15 most common reporting mistakes.

1. Not saving in Excel
2. Not saving with the original file name
3. Entering text instead of numbers
4. Double counting
5. Using the wrong category
6. Transposing numbers
7. Using measurements other than tons
8. Using commas instead of periods and vice versa
9. Inserting extra zeros
10. Omitting minor amounts
11. Not checking the transmission
12. Submitting blank forms
13. Waiting too long for municipal reports
14. Missing April 1st deadline!
15. Not verifying when requested

Throughout the years, information has been presented about the commercial and institutional report form model that the DEP encourages county and municipal recycling coordinators to use when reporting. This form meets the documentation requirements for filing performance grant requests. The documentation requirements are summarized as follows:

1. A reporting document must contain the name of the collector/processor.
2. It must demonstrate proof of certified weight documentation.
3. It must report the county or municipality in which the material was originated.
4. The form must note if the material was residential or commercial in nature.
5. It must also contain the year in which the material was collected or marketed.

Although the DEP encourages the use of this model form, a number of other forms may accomplish the same end, but use different formats. Such forms are acceptable as long as they meet the documentation requirements.

Arrow up image

Data Collection for New Coordinators

There are basic data collection and data management techniques for less experienced coordinators. A few include: where to start looking for businesses, the importance of notifying everyone of recycling regulations, and how to compile data. It is very important to nurturing good relationships with those from whom you need documentation. When recyclers understand why you need the records you request from them, they are often more open to sharing that information. New municipal recycling coordinators need to ask several questions.

1. Where does a new coordinator begin to look for data?

  • First identify the sources - where/who are all the businesses and multi-family's
  • Several places to look - Chamber of Commerce, haulers lists, utility billings, code office.
  • Prepare a mailing - include the recycling regulations and a recycling plan outlining what they are doing or plan to do with their recycling. Continue to follow this procedure with any new business coming to town.
  • Click here for a listing of PA businesses.

2. What do you do with the information the businesses and landlords provided?

  • Construct a database listing all the data received
  • From the recycling plans, determine where the materials are going.
  • Enter all the weights into a spreadsheet


3. What then?

  • Database is updated throughout the year - add new businesses, etc.
  • Recycling plans and recycling regulations are mailed each year.


4. Where else is data found?

  • Leaf waste - Public Works collects leaves at curbside. Public Works superintendent reports the number of cubic yards deposited. Convert the cubic yards into tons (3 cubic yards = 1 ton)
  • Yard waste - Public Works superintendent reports the number of cubic yards dropped off. Convert the cubic yards to tons using DEP's Composting Reference Manual, mixed yard waste as collected (before grinding) weighs 350-950 lbs. per cubic yard. Use the same conversion number each year to be consistent.
  • Christmas trees - Public Works counts the trees as they are grinding. An average size tree weighed seven pounds. That is the weight Carol used for each tree each year.
  • Pallets from the recycling center.


Advanced Data Management Techniques

Many techniques can be used to create successful data collection and reporting. Successful counties spend considerable time and resources to reach out to as many businesses as they can. Much of their contact is face to face and is part of a comprehensive outreach and support program. Computerized data collection technology can be used to record data for the county's drop-off recycling program.


Rural Counties and Small Communities

There are challenges of reaching the diversion goal in the rural communities and counties. Since curbside programs are sparse in rural areas it is very important to not only maximize drop-off opportunities but to dig up as much commercial material as possible. Even in non-mandated communities, most large retailers recycle cardboard on their own or through a broker and that material is often overlooked.

There are also challenges of gathering data with a limited staff but there is a value of nurturing relationships with municipal secretaries, managers, and road foremen, in the absence of a full-time professional recycling coordinator. In small communities, those staff wearing many hats have limited time to spend on such data management, so communication and report forms should be designed with that in mind.

Arrow up image

The Challenges of Urban Data Collection

Large cities have been able to identify increases in recycled materials by working with recyclers to provide more accurate and comprehensive data. This is especially important when determining recycling tonnage from residents not directly served by the city's municipal collection services. There are also challenges of dealing with proprietary information and collecting data from a variety of multi-family units.

It is a good idea to look in the right places and build positive relationships with a large assortment of private businesses, brokers, processors. It is important to mobilize municipal and industry people to help gather as much information as they can.

Building Relationships with Haulers, Processors, and Scrap Dealers.

It is important for recycling coordinators to work with scrap companies in order to determine the material's county of origin so that they may use it on their Annual Report. For non-Performance Grant materials it is perhaps easiest to estimate non-industrial material totals.

There are challenges that confront solid waste companies but some of these can be redressed through sound relationships with county and municipal recycling coordinators. Moreover, good and frequent communications between haulers and coordinators facilitates data collection. Such solid communication helps inform the hauler as to what records should be kept and reassures the hauler that the information he divulges about customer lists and activities will remain confidential.

It can be difficult to quantify waste and recyclables in a municipality containing very large numbers of businesses, recyclers, and business that recycle on site. There is a challenge of estimating the future of recycling and waste generation on such a large scale. This is of special concern when unpredictable changes in population and total employment can have a profound affect on solid waste and recyclable generation.


Annual Report Do's and Don'ts

County Annual Reports must be submitted by April 1st. It is important, then, to encourage municipalities to submit their reports by the February 15th deadline. She also explained that reports will no longer be accepted on floppy disks or on paper. All submissions will be done electronically.


The New 903 Reporting System

The DEP reporting form for County Recycling Coordinator (Section 903) Grants is being sent out electronically through e-mail. Information required can be entered directly into the computer on an Excel spread sheet. Once completed, just hit the button and send, thus eliminating the use of paper reports. The reporting system summarizes work into each of the four categories: activities, expenses, wages and benefits. Detailed explanations of each category are included with each reporting form. Once the information is entered into the computer, totals are automatically calculated. Check out this 903 presentation.

Arrow up image

Using the Earth 911 Database

Coordinators have also been encouraged to use the Earth's 911 system more extensively. By calling 1-800-CLEANUP or by viewing the website at 1800CLEANUP.org, you can access a variety of environmental topics. Some subjects included are composting, pollution prevention, innovative technologies, as well as "community-specific" information on demonstration programs, recycling sites, and maps to those sites. Professionally produced PSA"s that are produced with many featured celebrities are also available to government agencies through the website for promotion of environmental issues. Check out Carl Hursh's excellent Power Point on the subject.


What are the Struggles?

Past workshops have tried to identify challenges that recycling professionals face in gathering and managing recycling and solid waste data. Several examples of challenges identified as being in common with the different groups are:

1). Staffing shortages and staff turnover among those responsible for data collection, which can result in the lack of a key contact person and/or timely reporting.

2). Lack of enforcement support.

3). Lack of clear understanding and consistency in how data is collected and reported.

Arrow up image

What are the Solutions?

To address the above stated challenges suggested solutions are as follows:

1). Several ideas were presented to address staffing problems such as providing prior reports and charts for guidance, especially for new staff members. If possible, some county coordinators may find it more efficient to do data collection on behalf of municipalities that do not have available staff. It might also be valuable to offer incentives to haulers for providing timely data.

2). Enforcement issues may be more effectively addressed if centralized in Harrisburg and tied to grant reimbursement. On the local level, municipalities and counties should use licensing procedures and ordinances to facilitate compliance.

3). Education, education, education was a consistent theme within the groups. The development of uniform standards with clear instructions of what to count and how to report continues to be extremely important.

Many of these goals can be reached by building exceptional relationships and good communications among local governments, county departments and authorities, haulers, brokers, processors, and the scrap industry. We should not wait to call on others in the industry when we need something. Keep lines of communication open and clearly explain why certain things are needed. This can be done with periodic meetings, newsletters, conference calls, or e-mail updates.

Arrow up image