|
Jon
I was having problems accessing Wiki today. I need to insure that the latest version of Ohio's Emission Factor application is loaded for your review.
A new zip file is prepared that contains the Access application and a Word user's guide. Let me know when I can post the latest version.
The application consists of 42 tables and 105 queries. The numbers sound kind of scary, but all these queries are needed to process the Webfire
emissions, quality assure the data and create the (HAP/CAP) ratios. The ratios may be useful in generating a HAP inventory from criteria emissions,
without having to worry how the process throughput is described within an SCC. We have a separate application to calculate HAPs from CAPs and I will
welcome/encourage your review and possibly incorporate the concept in the redesign of RAPIDs.
The Word user's guide is necessary due to the number of steps needed to process the emission factors. It is seven pages long and it primarily describes what
happens when a button is clicked on the menu and which queries are run to execute a specific function. Also, the document describes how to update/revise
the list of Pollutants code table to make certain that all WebFire pollutants are being mapped to NEI and State codes. Furthermore, the document describes how to update/revise the units, measures, materials and action codes with each webfire file download and how the HAP ratios are prepared. Finally there are 19 quality assurance steps to help the user check the quality of the emission factors.
The application contains roughly 25,000 uncontrolled point source emission factors. The 15,000 factors are from WebFire (FIRE) and the remaining 10,000 are generated from filling SCC data gaps (FIRE+). There is a data entry screen for any State, NEI, GLC, etc factors.
In my opinion, this project ended up being bigger than initially hoped to be. We thought that it will take a few steps to process the WebFire records into a more streamlined set of factors. When we digged deep into Webfire, we found so many problems and inconsistencies that took us three months to develop this application. This project became a high priority for Ohio due to the redesign of the State's management application (STARS2).
My hope is that someday US EPA will form a workgroup and work in revising the Webfire database so it can conform to strict database standards and strict data entry quality assurance checks.
I want to thank Buzz and Chun Yi who helped me along the way. They provided me with reference tables and exchanges ideas on technical issues.
Again, I want to thank Michael Intern, the amazing intern, who programmed the steps and created this application in such a short period of time.
Have a nice weekend.
Tom.
|