Using Databases with Dispersion Modeling

How to build and use a database to compile model input files and process and analyze model results

A dispersion modeling project requires many types of input data, e.g. source data, emissions data, meteorological data, etc.With all these data, you generate input files and output files. The typical dispersion modeling project involves many dozens of files. How do you keep track of what data is in which file? If a change is made, do you end up searching for which files are impacted by the change and edit each one manually?

In this webinar series, we will walk you through and demonstrate a better approach to track and maintain the data related to your dispersion modeling project. Rather than storing all your project information in dozens of separate text files, you can more easily store all the project data in one relational database. With a database, you can generate input files, process output files, and compile your air quality analysis report easier and quicker than the current practice of scanning through dozens, even hundreds of text files.

Your Instructor

Robert Opiela P.E.
Robert Opiela P.E.

In my 20 year career with the TCEQ, my priority was to give guidance on dispersion modeling, so customers could provide an air quality analysis that the agency could approve. With decreasing agency resources and increasing regulatory demands, review timeframes were becoming extremely important for the agency and its customers. To expedite the review process while increasing the quality, I designed and developed tools to standardize and automate the review of air quality modeling analyses. The result was a more comprehensive and efficient process for agency staff and expeditious reviews for the regulated community.

From what I learned as a regulator, I wanted to provide the same level of automation for those compiling air quality analyses to submit to the TCEQ. Since I designed the system, I know the specifications and content necessary to take advantage of TCEQ’s system to quickly review and approve your analysis.

Frequently Asked Questions

When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

Get started now!