Air quality information technology
Download
1 / 36

Air Quality Information Technology - PowerPoint PPT Presentation


  • 225 Views
  • Updated On :

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 .

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Air Quality Information Technology' - stacy


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Air quality information technology l.jpg

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


Spars software overview l.jpg
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


Slide3 l.jpg

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


Spars inventories l.jpg
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


58 facilities used spars for the 2002 emission inventory l.jpg
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


58 facilities used spars for the 2002 emission inventory6 l.jpg
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


58 facilities used spars for the 2002 emission inventory7 l.jpg
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


Slide8 l.jpg

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


Slide9 l.jpg

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


Slide10 l.jpg

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


Slide11 l.jpg

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


Slide12 l.jpg

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.


Slide13 l.jpg

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


Slide16 l.jpg

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


124 facilities used spars for the 2003 emission inventory l.jpg
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


124 facilities used spars for the 2003 emission inventory18 l.jpg
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


Industry web enablement benefits l.jpg
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


Industry web enablement benefits20 l.jpg
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


Industry web enablement benefits21 l.jpg
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


State web enablement benefits l.jpg
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


State web enablement benefits23 l.jpg
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


Slide24 l.jpg

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/


Contact information l.jpg
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 