HTML/Javascript

Be a VoiceThis year the National Environmental Health Association (NEHA) has added a new way to participate in the Call for Abstracts process for the Annual Educational Conference (AEC) & Exhibition. It is called, "Be a voice" and it gives you the opportunity to tell us what you'd like to experience at the AEC. Tell us topics you'd like to hear about and speakers you'd like to see. Review abstracts and provide input. Help NEHA develop a training and education experience that continues to advance the proficiency of the environmental health profession AND helps create bottom line improvements for your organization!
To search for specific abstracts, please use the search box located at the top left of the page (*next to the Blogger icon). Search Help

HELPFUL LINKS:     How to Participate and Use this Blog  |   Disclosure   |   NEHA Blog Policy and Participation Guide

ADDITIONAL WAYS TO PARTICIPATE:    Suggest a Topic  |   Suggest a Speaker  |   Questions?


Tuesday, September 25, 2012

Taming Your Data: A Look at Streamlining Data Collection for the Cross Connect and EPCRA Programs

Do you feel overwhelmed by the sheer amount of data collection that must be done for your programs? Attend this session to hear about how Sacramento County’s Environmental Management Department streamlined their data collection mandates for the Cross Connect and Hazardous Materials Chemical Inventory Reporting (EPCRA) programs. When faced with processing thousands of pages of test report data from over 14,5000 cross connect devices and a recent law mandating that the Hazardous Materials Chemical Inventory reporting (EPCRA) be uploaded into a statewide California State Environmental Reporting Database (CERS), Sacramento County’s Environmental Management Department not only managed to overcome these overwhelming data obstacles but saved in staff time and cut costs.
The presentation will:
  1. Review EMD’s efforts to improve their Cross Connect and Hazardous Materials Business Plan Program processes by streamlining how data is captured. This includes outreach to the regulated business community.
  2. Evaluate the use of a web portal and it’s application strategies of data collection in two environmental program examples.
  3. Understand a web portal can save time and costs to both staff and the regulated public industry.

4 comments:

  1. Data collection and management is time consuming! The way it's listed out looks like you will save a lot of costs in running the programs.

    Is the setup something that can be copied and put into use easily? Is there an "app" that goes along with it? Good luck!

    ReplyDelete
    Replies
    1. The coding that shuttles the data between our internal tracking software (EnvisionConnect) and the portal was heavily customized, as this program is somewhat unique. Copying the code to another environment would be complex undertaking, although I'm sure it could be done. The technical staff that has been working on this project knew little about the details of the Cross Connection program when this started, but learned as the project progessed.



      Delete
  2. What are the capital costs in setting up an electronic portal like this? It looks like a great idea for large inventories, is it too expensive though for smaller scale operations?

    ReplyDelete
  3. We did the Cross COnnection portal project as an add-on to a bigger Portal project, the Hazardous Business Plan program mentioned above, so I'm not sure what the stand-alone costs would be for just this component. We pay an additional $10,000 per year to set up and maintain the Cross Connection piece of the portal, although if the time that EMD staff have spent working with the developers was counted, the total would be much higher. We justified it by the savings it will produce by converting a largely manual process into a mostly automated one. It looks like the project will pay for itself in less than a year.

    ReplyDelete