1 / 36

Air Quality Information Technology

Air Quality Information Technology. Kevin Connolly Administrative & Information Technology Services SPARS Overview and Features New Feature Movie Moving to the Future Cool Web Links Exciting Reports and Permits. SPARS Software Overview.

chip
Download Presentation

Air Quality Information Technology

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Air QualityInformation Technology Kevin Connolly Administrative & Information Technology Services SPARS Overview and Features New Feature Movie Moving to the Future Cool Web Links Exciting Reports and Permits

  2. SPARS Software Overview • Fully Functional Permit Application software with Site Management Functions: • Construction Permit Applications • Operating Permit Applications • Part 1; Equipment and Emissions Information • Part 2; Applicable Requirements • Title V Annual Emission Inventory Submittal • Minor Source Emission Inventory Submittal

  3. SPARS Training • AQB provides free training and support to Industry and other users for completing the Major Source and Minor Source Inventories • AQB provides free training and support for completing Title V Parts 1 and 2 initial / renewal applications and Construction Permit applications

  4. SPARS Inventories • SPARS should be used to submit information for Emissions Inventory on: • Any Site Subject to Construction Permitting, but not Subject to Title V (Minor Source Emissions Inventories) • Major Source Emission Inventories • Modifications to a Current Inventory

  5. 58 Facilities Used SPARS for the2002 Emission Inventory • ANR PIPELINE CO.- BIRMINGHAM COMPRESSOR; - LINEVILLE COMPRESSOR • ADM CORN PROCESSING- CLINTON • BLACKHAWK FOUNDRY & MACHINE CO., INC. • BPB AMERICA, INC. • CENTRAL IOWA POWER CO.– SUMMIT LAKE; – FAIR STATION • JOHN DEERE - DUBUQUE; - WATERLOO WORKS • FARMLAND INDUSTRIES, INC.- FORT DODGE • GLACIER DAIDO AMERICA • GLEN-GERY CORPORATION • GOMACO CORPORATION • GREGORY MANUFACTURING CO., INC. • LAFARGE NORTH AMERICA INC. • LINWOOD MINING & MINERAL CORPORATION • MANILDRA ENERGY CORPORATION • MAQUOKETA MUNICIPAL ELEC. UTILITY; - 105 GENERAC DR. • MAYTAG - NEWTON LAUNDRY PRODUCTS - PLANT 2

  6. 58 Facilities Used SPARS for the2002 Emission Inventory • NATIONAL COOPERATIVE REFINERY ASSOCIATION • NORTHERN NATURAL GAS CO.- VENTURA; - OAKLAND; - OGDEN; - PAULLINA; - WATERLOO; - GARNER LNG PLANT; - REDFIELD COMPRESSOR STATIONS • OMEGA CABINETS, LTD. • ORBA-JOHNSON TRANSSHIPMENT COMPANY • STAR BUILDING SYSTEMS • SHEAFFER MANUFACTURING CO. • SILGAN CONTAINERS MFG. CORP.– FORT DODGE; – FORT MADISON • UNITED BRICK & TILE COMPANY • SIOUX CITY BRICK & TILE COMPANY • SNAP-ON TOOLS MANUFACTURING COMPANY • STELLAR INDUSTRIES, INC. • TERRA NITROGEN - PORT NEAL COMPLEX • UNVERFERTH MANUFACTURING CO., INC. • WEBSTER CITY DIESEL • COLOR CONVERTING INDUSTRIES

  7. 58 Facilities Used SPARS for the2002 Emission Inventory • BP PRODUCTS NORTH AMERICA– CEDAR RAPIDS • ADM - DES MOINES SOYBEAN • TITAN TIRE CORPORATION • HIRSH INDUSTRIES, INC. • IOWA PAINT TECH & MANUFACTURING CENTER • ELECTRIMOLD • HEARTLAND EPS, INC. • BLACK HAWK COUNTY SANITARY LANDFILL • SCOTT AREA SANITARY LANDFILL • PRINCIPAL LIFE INSURANCE COMAPANY • BUNGE NORTH AMERICA, INC. • GENERAC POWER SYSTEMS • TASLER INCORPORATED • ADM CORN PROCESSING - CEDAR RAPIDS • CRYOVAC INC., SEALED AIR CORPORATION • ANAMOSA STATE PENITENTIARY

  8. 2003 SPARSEnhancements • Ability to copy and use previous applications, as well as improved site management autofill • Title V Renewal Applications, includes last EIQ • Major Source Emission Inventories • Minor Source Emission Inventories • Autofill new applications from site management

  9. 2003 SPARSEnhancements • Ability to copy and use previous applications, as well as improved site management autofill • Expanded auto-calculate functions • All sources of Emission Factors EXCEPT Permit, CEM, Other • Expanded comment section for selected source of emission factor • Pollutants listed in SPARS and Printout by name • No longer using CAS numbers on printout

  10. Copy and Reuse Data Function • Reuse an existing Title V Application for creating a Renewal Title V Application • Updates equipment from Administrators • Maintains all Potential data from original Title V • Copies in all Actual data from previous year’s EIQ

  11. Copy and Reuse Data Function • Able to create new Emission Inventories using the previous year’s data as a template • Adds new equipment, maintains existing units, raw materials, operating schedule, emission factors, control values from previous year. • Sets the new inventory’s unit Throughput and Total Emissions to zero

  12. New Feature Benefits • Once initial applications/inventories are completed, no need to re-enter data for points, units, control/monitoring equipment, emission factors, units of measure UNLESS they change between submittals. • Copying and Reusing previous applications and inventories will have significant benefits for industry, cutting application production time dramatically.

  13. Expanded Auto-Calculate Tools • Auto calculation for all sources of Emission Factor EXCEPT Permit, CEM, Other • Use for AP42, Fire, Worksheet, Stack Test, SCC, MSDS, Mass Balance, Tanks • Calculated field IS changeable, make note on Calcs tab for the modified pollutant value • Standardized calculations for non-modified processes, those having no special characteristics • Potentials handled differently than Actual Emissions

  14. Copy Function Example • Movie: Title V Emission Inventory • Uses previous inventory as a template for the new inventory • Update changes to facility in 2003 • Copy data from 2002 to 2003 • Enter throughputs for 2003, will autocalculate new emissions totals

  15. 124 Facilities Used SPARS for the2003 Emission Inventory • Increase of 66 Facilities, doubling the number of Facilities submitting on the SPARS software package over 2002 • SPARS 2002 Fee Emissions : 44,452.33 tons • SPARS 2003 Fee Emissions : 163,719.90 tons

  16. 124 Facilities Used SPARS for the2003 Emission Inventory • 119,267.57 ton increase reported on SPARS represents a268.30% increasein reported emissions over 2002 totals • Fee Emissions for 2003 : 231,876.65 tons • Percentage of the Fee Emissions reported on SPARS :70.6

  17. Industry WebEnablement Benefits SOFTWARE / HARDWARE • Reduction or Elimination of SPARS desktop software and maintenance • Reduction or Elimination of maintenance of the SPARS desktop database • Avoids diskette / CD failures in data transfer

  18. Industry WebEnablement Benefits USER ACCESS • Immediate access to current SPARS software and current industry supplied information • Web-based training and assistance • Multi user access for companies with multiple permit application staff

  19. Industry WebEnablement Benefits DATA EXCHANGE • Elimination of data imports of server information from the State • Elimination of data exports to the State from stand-alone system • Eliminates sending signed forms, mailing costs for non-local program facilities

  20. State WebEnablement Benefits SUPPORT • Reduction in helpdesk support of SPARS desktop software maintenance for the Regulated Industry • Reduction of helpdesk support of the SPARS desktop database for the Regulated Industry

  21. State WebEnablement Benefits DATA ENTRY / EXCHANGE • More accurate and current information being provided by Regulated Industry • Elimination of data duplication and manual data entry transcribing issues • Elimination of data import/export to and from the Regulated Industry

  22. SPARS Information on the WEB Air Quality Homepagehttp://www.iowadnr.com/air/ SPARS Homepagehttp://www.dnraq.state.ia.us Construction Project Statushttp://aq48.dnraq.state.ia.us/wspars Issued Construction Permitshttp://aq48.dnraq.state.ia.us/airpermit/

  23. Contact information • kevin.connolly@dnr.state.ia.us • (515) 242-5100 or (515) 281-8983 • cherity.gabrielle@dnr.state.ia.us • (515) 242-5100 or (515) 281-4873 • www.iowadnr.com/air 

More Related