KF3775 .A8B8 1989 r/E=PA United States Environmental Protection Agency AdministratH Resources I (PM-211D) 232R89101 Building Environmental Partnerships Through Information Sharing State/EPA Data-Management Program Progress Report 1988-1989 DC Printed on Recycled Paper ------- UNITED STATES ENVIRONMENTAL PROTECTION AGENCY WASHINGTON. D.C. 20460 OFFICE OF ADMINISTRATION AND RESOURCES MANAGEMENT To the Reader, I am pleased to present the State/EPA Data Management Program progress report. This report highlights the achievements and activities of the program during 1988 and 1989. The accomplishments and strides that the States and EPA have made during this period have been significant. They include progress in virtually all facets of environmental information, policies, practices and technology. The State/EPA Data Management Program is one of EPA's highest management priorities. Environmental protection depends on managing, interpreting and presenting vast amounts of data. Effective management is essential. To meet these challenges, EPA must become more responsive to State and local governments that collect most environmental data and make most environmental protection decisions. Thus, the need to manage information resources effectively is among the most important management challenges facing EPA. As we enter the 1990's, I envision that the continued dedication and high energy of State environmental agencies and the EPA Regions will ensure that we meet this challenge successfully. I would like to thank everyone who has contributed to the State/EPA Data Management Program, especially EPA Headquarters, Regional and State managers whose leadership and hard work are making this program a success. Charles L Grille Assistant Administrator U.S. Environmentamotection Agency 77BWest JacKso* Boulevard, 12th Floor Chicago, IL 60604-3590 ------- ------- I. INTRODUCTION AND GOALS Program Background EPA's ability to identify and examine environmental trends and report on its own performance and that of delegated State programs — to manage for environmental results — depends directly on a timely and accurate data sharing program with States. For this reason, the Agency's State/EPA Data Management Program is committed to (1) build and maintain the infrastructure needed for effective State/EPA data management and sharing and (2) inte- grate data across media and programs so that EPA and State managers can target their efforts on environmental results. Program Phases This program has two phases- Phase I: Data Sharing and Phase II: Data Integration. The goals of Phase I are to: • Obtain and enter complete, timely and accurate information in all EPA enforcement, monitoring and compliance data bases • Provide States high-speed, on-line access to all EPA data bases • Ensure the integrity of State data in EPA data bases and due process for States in resolving data disputes with EPA. The goals of Phase II are to: • Provide EPA and the States the data, methods and technology required to conduct integrated environmental analyses and to plan and manage cross-media programs • Build effective, long lasting arrangements for sharing data and technology between environmental agencies at all levels and with our colleagues in Federal, State and local agencies that are responsible for commerce, agriculture, science and natural resources conservation. ------- Phase I: Data Sharing Phase I seeks to establish a reliable flow of regulatory and compli- ance data between EPA and the delegated States for seven sys- tems. An important objective of Phase I is to have direct data access into these national systems: Aerometric Information Retrieval System (AIRS): provides air quality , emissions and compliance data. Compliance Data System (CDS): provides air compliance data. Grants Information and Control System (GICS): provides Con- struction Grants and schedule information. Water Quality Storage and Retrieval System (STORET): provides water quality data. Permit Compliance System (PCS): provides compliance data and effluent data for surface water discharges. RCRA Information System (RCRIS/HWDMS): provides hazard- ous waste site information. Other Information Systems have been implemented by State environmental agencies, among them are: Federal Report Data System (FRDS), CERCLA Information System (CERCLIS), Inte- grated Risk Information System (IRIS), Toxic Release Inventory System (TRIS), National Emission Data System (NEDS) and Storage and Retrieval of Airometric Data (SAROAD). NEDS and SAROAD will be replace by AIRS in the near future. ------- Phase II: Data Integration Phase II focuses on assisting States and Regions in integrating data across prog rams and media. The Phase II goal is to develop and implement at the Regional and State levels the tools needed to pinpoint environmental problems, prioritize them on a risk-reduc- tion basis, and manage program activities to maximize environ- mental results. EPA Regions began introducing the Phase II in- tegration concepts to the Phase I States in 1988 and 1989. Phase II is now being implemented in selected states in eight Regions. These efforts will help define the Phase II Program more precisely and provide additional models for future Region and State projects. ------- Federal Responsibility Federal responsibility and support for the program is shared among the Regions, Office of Information Resources Manage- ment (OIRM), the National Data Processing Division (NDPD) and the Program Offices. The Regional role is critical; the senior IRM official in each Region must guide this program at the Regional level and secure State participation. As the National Program Office, OIRM with assis- tance from the National Computer Center (NCC) and NDPD, is re- sponsible for program policy, coordinating Program Office sup- port, connecting States to EPA's data communication network, introducing and supporting data integration and other new tech- nologies, and assisting Regions and States during implementa- tion. Continued Program Offices support for the State-Regional Initiatives is vital to achieve complete, timely and accurate national data systems. Benefits to the Agency and States The four specific benefits of the State/EPA Data Management Pro- gram are: Efficiencies in data collection which will result in signifi- cant gains in data handling and routine program operations Enhanced data quality — accurate, timely and reliable — to guide programmatic decisions and support program oversight Improved data integration to more effectively target regu- latory and compliance activities on risk reduction, and to en- hance the capability to manage for environmental results A more productive working relationship between EPA and the States to focus on environmental management and minimize data disputes. This program is of strategic importance to EPA's overall efforts to enhance vital data resources and move toward more productive Federal and State roles in environmental protection. ------- II. Review of 1988-1989 Progress Summary Substantial progress was made in 1988 and 1989. Accomplish- ments affect all ten Regions: Implemented Phase I in forty-nine States, Puerto Rico and the District of Columbia Completed installation of a high-speed data link and necessary software in forty-six State capitols into the data network. These States now have the capability to directly enter and access the data they report to EPA Created a more constructive Regional-State attitude toward improving the flow of State reported data Continued a forum to discuss data sharing initiatives through the National State/EPA Data Management Confer- ences sponsored by the Office of Information Resource Management Achieved numerous and concrete improvements in the use of data: efficiencies in handling data, timeliness of reported data, and greater use of EPA systems to support State program operations Initiated actions to develop protocols for resolving dis- agreements over State reported data. The Regions completed joint State-Regional implementation plans specifying actions to be taken in1988-89 to accomplish Phase I objectives and selected Phase II data integration initiatives. Addi- tional training is being provided to enhance and expand the States' use of EPA systems in managing operations. ------- Region-By-Region Review LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States 1990 Selected States 1987 Selected States • Maine • New Jersey • New York • Virginia • Georgia * Tennessee • Indiana • Arkansas • Missouri •Utah • California • Oregon 1988 Selected States • New Hampshire • Puerto Rico • West Virginia • Delaware • Florida • Illinois • Michigan • Minnesota • Ohio • Wisconsin • Texas • Nebraska • Iowa • Kansas • Colorado • Hawaii • Nevada • Washington • Idaho 1989 Selected States •Vermont •Massachusetts •Rhode Island • Connecticut •Maryland •Pennsylvania •District of Columbia •South Carolina •North Carolina •Mississippi •Kentucky •Alabama •Louisiana •Oklahoma •New Mexico •North Dakota •South Dakota •Montana •Arizona •Alaska 1990 Selected States •Wyoming ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region I, Boston Maine Phase II Key Regional Participants: Mike McDougall, Ed Woo State Contacts: Ron Dolan, Systems Group Manager, Department of Environ- mental Protection (DEP) Data Bases Involved: NEDS, SAROAD, CDS, PCS, GIGS, STORET, and HWDMS/RCRIS Major Accomplishments in 1988-1989: (1) Implemented the AIRS Air Quality Subsystem. (2) Hired a programmer/analyst to support EPA systems. (3) Initiated a study to develop a Comprehensive Automation Plan (CAP) for DEP. The study is evaluating functional needs and data requirements to support EPA and State information systems, providing DEP with a multi-year technology and systems enhance- ment plan and identifying areas of near-term, quick-fix opportunities. This study is scheduled for completion in July 1989. (4) As a second phase to the CAP project, DEP is initiating a set of tasks to develop an intergrated, multi-media approach to permit processing and enforcement. The principal output from this proposal will be a detailed design for an intergrated multi-media system to support the Air, Water, Solid Waste, Oil & Hazardous Material program functions. Next Steps for Maine: (1) Implement the AIRS Facility Subsystems. (2) Evaluate applicability and pilot RCRIS for DEP. (3) Explore GIS project opportunities with Maine's newly acquired GIS technology. (4) Upgrade hardware and software to access Storage and Retrieval and/or Water Quality Analysis System graphics tools. (5) Complete detailed systems design and implementation of the intregrated, multi-media permitting and compliance systems. ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region I, Boston New Hampshire Phase II Key Regional Participants: Mike McDougall, Ed Woo, Richard Henderson State Contacts: Data Bases Involved: Richard Henderson, MIS Administrator NEDS, AIRS, CDS, DEMO/RENO, PCS, FRDS, and RCRIS/HWDMS Major Accomplishments in 1988-1989: PHASE I (1) Installed high speed data link connecting Concord to EPA. All Major DES program offices at Concord can now access the IBM at National Computer Center through the Wang SNA Gateway. (2) Completed training and/or demonstration of all major EPA national and regional systems as tools as outlined in the Phase I Workplan. (3) Established EPA/State Data Quality Agreement. (4) New Hampshire is now a direct user of AIRS, CDS, GIGS, Demolition/Renovation asbes- tos tracking system; retrieves HWDMS reports and directly updates handler information; and plans to use the AIRS Facility Subsystem in the near future. PHASE II (1) Implemented the AIRS Air Quality Subsystem. (2) Began system development project to design and implement transaction files com- patible with EPA FRDS reporting requirements. (3) Initiating a study of current agency-wide IRM capacity, future functional needs and data requirements to support state and EPA information systems. (4) Worked with Region I in developing and refining the Nashua Basin Wellhead Protection GIS Project. 10 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Region I, Boston Vermont Program Phase: Phase 2 Key Regional Participants: Mike McDougall, Ed Woo State Contacts: Greg Heil, Technical Services Supervisor Data Bases Involved: NEDS, SAROAD, CDS, PCS, GIGS, STORET, and RCRIS/HWDMS Major Accomplishments in 1988-1989: (1) Initiated an agency-wide telecommunication and computer systems upgrade. The project will accomplish the following: •Upgrade existing HP computer at the Air Division to provide agency-wide distributed processing. •Provide an SNA gateway linking Vermont's air, water and waste program offices to EPA. •Provide RJE, high-speed file transfer and remote printing capability. •Vermont expects to have the upgrade completed by October, 1989. (2) Conducted meeting on phase 1 and 2 activities. Vermont is interested in becoming a direct user of AIRS and GICS; adoption of RCRIS in Logical Mainframe or PC platform; exploring decision support and graphics tools for STORET, River Reach Files, PCS, and working cooperatively with EPA in a number of GIS application areas . Next Steps for Vermont: (1) Complete computer systems upgrade. EPA will assist Vermont in the configuration and procurement of Ssytem Network Architecture and Remote Job Entry equipment (2) Install high-speed data link to EPA. (3) Finalize project workplan and continue Phase 1 activities. 11 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Region I, Boston Rhode Island Program Phase: Phase 1 Key Regional Participants: Mike McDougall, Ed Woo State Contacts: Data Bases Involved: Pam Annarumou, Sr. Computer Programmer NEDS, AIRS, CDS, DEMO/RENO, PCS, FRDS, RCRIS/ HWDMS and GIGS Major Accomplishments in 1988-1989: PHASE 1 (1) Initiated an agency-wide telecommunications and computer systems upgrade. The project will accomplish the following: • Increase the capacity and networking of existing Water Division's local area net- work (LAN). • Implement PC FOCUS as the standard departmental database tool. • Provide compatibility with EPA Token Ring LAN standards. • Serve as SNA gateway linking R.l.'s Air and Water LANs to EPA. • Provide RJE, high-speed file transfer and remote printing capability. • Rhode Island plans to have the systems upgrade accomplished by the end of FY89. (2) Conducted demos and basic training on PCS, CDS and AIRS. (3) Conducted meetings on Phase 1 activities. Rhode Island is interested in becoming a direct user of PCS, AIRS, GIGS: evaluating RCRIS on the LMF or PC platforms; exploring joint Geographic Information System project opportunities. 12 ------- Next steps for Rhode Island: (1) Complete LAN systems upgrade. EPA will cooperate with and assist Rhode Island in the configuration and procurement of SNA and RJE equipments. (2) Install high-speed data link to EPA. (3) Finalize workplan and continue Phase 1 activities. 13 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Region I, Boston Massachusetts Program Phase: Phase 1 Key Regional Participants: Mike McDougall, Ed Woo State Contacts: Jackie Dougherty, Information Center Director Data Bases Involved: NEDS, AIRS, CDS, DEMO/RENO, PCS, FRDS, RCRIS/ HWDMS and GIGS Major Accomplishments in 1988-1989: PHASE 1 (1) Initiated an agency-wide telecommunication and computer systems upgrade. The project will accomplish the following: •Implementation of Ethernet Local Area Network (LAN) and Wide Area Network (WAN) linking the central office and regional offices of Department of Environmental Protection , the state EOEA central computing center and EPA. •Provide SNA access for all DEQE departments to EPA. •Support RJE, high-speed file transfer and remote printing capability. •Massachusetts plans to have SNA access for the LAN completed by July, and SNA access for the WAN by October, 1989. (2) Initiated a project to develop a Facilities Master File linking facilities and permits information across media and EPA. Region I will participate in systems design activities. (3) Initiated a project to upgrade the air quality data acquisition system in AIRS compatible format. (4) Conducted meetings on Phase 1 activities. Massachusetts is interested in becoming direct user pf PCS, AIRS, GICS: evaluate RCRIS directly vs. data management decision and graphics tools in STORE! and River Reach Files. 14 ------- Next Steps for Massachusetts: (1) Complete implementation of LAN, WAN and SNA gateway. (2) Complete development and implementation of Facility Master File and Air Data Acquisition systems. (3) Finalize workplan and continue Phase 1 activities. 15 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region II, New York New York Phase 1 Key Regional Participants: Herb Barrack, ARA for Policy and Management Bob Messina, George Nossa State Contacts: Tom Donovan, Acting Director, Division Management Planning and Information Systems Development Data Bases Involved: PCS, GIGS, STORET, RCRIS/HWDMS and AIRS Major Accomplishments in 1988-1989: (1) High-speed telecommunications link established in 1985 connecting Albany to the EPA network. Telecommunications services were expanded in 1989 to allow in- creased terminal access to EPA databases. (2) New York provides data to EPA in electronic format for all systems except HWDMS. (3) Phase 1 objectives for HWDMS were identified and work completed on HWDMS evaluation. State and EPA agreed to concentrate efforts on planning for RCRIS implementation which New York has indicated they will access as a direct user on the Region II IMF. (4) Additional $60,000 funding provided to New York to expand its use of PCS in state regional offices. Next Steps for New York in 1990: (1) Complete RCRIS implementation using the Region II LMF and evaluate need for fur- ther telecommunications expansion. (2) Complete project for expanded use of PCS, providing links to the State regional offices. (3) Coordinate implementation of the AIRS Facility Subsystem and develop procedures for the electronic submission of air facilities compliance data and air emissions into the AIRS database. (4) Evaluate potential for Geographic Information Systems pilot project. 17 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region II, New York New Jersey Phase 1 Key Regional Participants: Herb Barrack, ARA for Policy and Management Bob Messina, George Nossa State Contacts: Data Bases Involved: Michele Putnam, Deputy Director, Hazardous Waste Operations George Caporale, Chief, Bureau if Information Systems PCS, GIGS, STORET, RCRIS/HWDMS and AIRS Major Accomplishments in 1988-1989: (1) High-speed telecommunications link established in 1986 and enhanced in 1987. (2) New Jersey provides data to EPA in an electronic format for all systems except HWDMS. (3) Phase 1 objectives for HWDMS were identified and work completed on the data ele- ment crosswalk between the state RCRA systems and HWDMS and then RCRIS. State has agreed to concentrate efforts on completing a component of their system and developing an interface/translator to RCRIS. (4) Completed EPA/State pilot project for a Geographic Information System within the New Jersey Department of Environmental Protection. Next Steps for New Jersey in 1990: (1) Complete RCRIS implementation by developing translator software linking State systems to RCRIS. (2) Develop translator software linking a new State National Pollution Discharge Elimina- tion system to PCS. (3) Coordinate implementation of the AIRS Facility Subsystem and develop procedures for the electronic submission of air facilities compliance data and air emissions into the AIRS database. 18 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region II, New York Puerto Rico Phase 1 Key Regional Participants: Herb Barrack, ARA for Policy and Management Bob Messina, George Nossa State Contacts: Data Bases Involved: Betty Morales, Chief, Validation and Data Services Air Quality PCS, GICS, STORET, RCRIS/HWDMS and AIRS Major Accomplishments in 1988-1989: (1) Began Phase 1 in 1989, with a goal of installing a high-speed telecommunications link between San Juan and the EPA network. The line should be installed during the summer, 1989. (2) A grant in the amount of $90,000 has been awarded to the Puerto Rico Environ- mental Quality Board (EQB) to purchase additional hardware to more effectively utilize the dedicated line. (3) Access has been provided to all EPA systems via remote terminals which has al- lowed EQB staff to expand their use of STORET, GICS, AIRS, PCS and HWDMS. In addition, workshops have been conducted on the use of GICS, PCS and STORET. Next Steps for Puerto Rico in 1990: (1) With EPA grant assistance, develop an organizational/ management strategy for IRM function in EQB. (2) Implement Region II EQB FY 90 training agenda. (3) Coordinate implementation of the AIRS Facility Subsystem and develop procedures for the electronic transmission of air facilities compliance data and air emissions into the AIRS database. 19 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region III, Philadelphia Delaware Phase 1 Key Regional Participants: Bill Wisniewski, ARA for Policy and Management Joe Hamilton, Wendy Bartel State Contacts: Data Bases Involved: Sam Eaton, System Manager PCS, GIGS, STORET, RCRIS/HWDMS, AIRS, NEDS, and FRDS Major Accomplishments in 1988-1989: (1) Installed high-speed data link to connect Dover to EPA network. (2) Reviewed data bases, identified data management problem areas, prepared system- by-system workplan for Regional and State actions to accomplish Phase 1 objectives . (3) Developed user support and training programs addressing the needs of each system. (4) Delaware delegated Construction Grants Program which includes responsibility for GIGS. Received FY 88 205 (g) grant funds to access GIGS. (5) RCRIS State Implementation Plan developed for Delaware. The State plans to use the PC version of RCRIS in FY 90. (6) Implemented direct access to AIRS. They attended AIRS (AQS) training and as- sumed responsibility for updating 1 st quarter calendar 1988 data. (7) The Region has provided several onsite training sessions in order to facilitate the State's access to GIGS. (8) Delaware is a direct user of PCS, STORET and GIGS. The State also has access to TRIS, NATICH and UNAMAP. (9) Delaware received grant funding to undertake a GIS project to develop an advanced identification system for the Inland Bays Watershed. The project, which will cover 18 months, will provide a planning tool for managers to access impacts of proposed land and water use actions on natural resources. 21 ------- Next Steps for Delaware in 1989: (1) Implementation and monitoring development of AIRS (AQS), to facilitate State access during FY 90. (2) Evaluate implementation and monitor progress of RCRIS. 22 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region III, Philadelphia District of Columbia Phase 1 Key Regional Participants: Bill Wisniewski, ARA for Policy and Management Joe Hamilton, Wendy Bartel State Contacts: Data Bases Involved: James Sweeny.A. Padmanabha, Program Manager PCS, GIGS, STORET, RCRIS/HWDMS, AIRS, NEDS, CDS, and FRDS Major Accomplishments in 1988-1989: (1) Met with D.C. representatives to discuss an EPA/D.C. telecommunications link. Working with NCC and D.C. to begin implementation of connection. (2) D.C. attended AIRS (AQS) training in March. (3) RCRIS State Implementation Plan developed for the District. They plan to use the PC version of RCRIS. (4) D.C. is direct user of STORET. Next Steps for District of Columbia in 1989: (1) Develop a formal agreement with D.C. to participate in the State/EPA data management program. (2) Continue implementation of a telecommunications link between D.C. and the EPA network. (3) Facilitate implementation of AIRS (AQS). Monitor development of AIRS (AFS) and facilitate State access during FY 90. (4) Monitor progress of RCRIS implementation and develop schedule for State access. 23 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: States: Program Phase: Region III, Philadelphia Maryland Phase 1 Key Regional Participants: Bill Wisniewski, ARA for Policy and Management Joe Hamilton, Wendy Bartel State Contacts: Data Bases Involved: Tom Damilowski PCS, GIGS, STORET, RCRIS/HWDMS, AIRS, NEDS, and FRDS Major Accomplishments in 1988-1989: (1) Tymnet Engine installed in FY 87 to connect Baltimore to EPA network. (2) Schedule developed for State to become a direct user of PCS as part of FY 87 104 (b) grant agreement. (3) State has direct access to GIGS, PCS and STORET. They also access CAPDET and NEEDS. (4) Received training from Region on new GIGS online data entry system. (5) State attened AIRS (AQS) training in March 1989. (6) RCRIS State Implementation plan developed for Maryland. They plan to become a translator State. The Department is presently developing an in-house system called the Consolidated Waste Management Information System (CWMIS). Data from CWMIS will be transfered to RCRIS. (7) Maryland began access to TRIS and NATICH. (8) The Department attended FRDS 2.0 training. Next Steps for Maryland in 1989: (1) Facilitate implementation of AIRS (AQS). (2) Develop formal agreement with Maryland to participate in the State/EPA data man- agement program. (3) Evaluate how RCRIS will be implemented by Maryland. 24 ------- Next Steps for Maryland in 1989 continued (1) Facilitate implementation of AIRS (AQS). (2) Develop formal agreement with Maryland to participate in the State/EPA data management program. (3) Evaluate how RCRIS will be implemented by Maryland. (4) Develop formal agreement with Maryland to participate in the State/EPA data management program. (5) Facilitate implementation of AIRS (AQS). Monitor development of AIRS (AFS) and facilitate State access during FY 90. (6) Monitor progress on RCRIS implementation and develop schedule for Maryland's participation as a translator State. 25 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region III, Philadelphia Pennsylvania Phase 1 Key Regional Participants: Bill Wisniewski, ARA for Policy and Management Joe Hamilton, Wendy Bartel State Contacts: Data Bases Involved: Floyd Kefford, Bureau of Laboratories PCS, GIGS, STORET, RCRIS/HWDMS, AIRS, NEDS, CDS, andFRDS Major Accomplishments in 1988-1989: (1) RCRIS State Implementation Plan developed for Pennsylvania. Initially they will participate as a manual State, and by FY 92 to become a translator State. (2) Performed a preliminary review of data bases and identified data management problem areas. (3) Implemented direct access to AIRS. State attended AIRS (AQS) training. (4) Developed a draft formal agreement with Pennsylvania to participate in the State/EPA data management program. (5) Providing continued technical support on Enviro Link/90 project. (6) Met with State technical representatives to discuss upgrading the EPA/PA telecom- munications network that will link the central office in Harrisburg to all the State regional offices. An EPA link to this network would allow high-speed access to all State users, rather than just those in Harrisburg that are presently served by the Tymnet Engine. (7) Pennsylvania attended FRDS 2.0 traininig. (8) Pennsylvania has direct access to GICS, STORET and FRDS. Working with the State to implement direct access to PCS in State Regional offices. Pennsylvania also accesses TRIS, NATICH, NEEDS and UNAMAP. Next Steps for Pennsylvania in 1989: (1) Finalize formal State/EPA Data Management Agreement with Pennsylvania. (2) Monitor development of EPA/PA telecommunications upgrade. (3) Provide continued support and participation in State Enviro Link/90 project. (4) Monitor development of AIRS (AQS) and facilitate State access during FY 90. 26 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: States: Program Phase: Region III, Philadelphia Virginia Phase 1 Key Regional Participants: Bill Wisniewski, ARA for Policy and Management Joe Hamilton, Wendy Bartel State Contacts: Data Bases Involved: Jane Beckette-Camaratta, Assistant Director for Administration PCS, GIGS, STORET, RCRIS/HWDMS, AIRS, NEDS, CDS, andFRDS Major Accomplishments in 1988-1989: (1) Developed user support and training program for direct access to PCS and AIRS (AQS). (2) Received training on new GICS online data entry system. (3) Virginia has direct access to all data bases except NEDS and HWDMS. The State also uses TRIS and NATICH. (4) RCRIS State Implementation Plan developed for Virginia. (5) User support and assistance provided to the Water Control Board in order to facilitate their access to PCS. (6) Virginia Health Department attended FRDS 2.0 training. (7) Several State agencies are working on an effort to consolidate and coordinate State groundwater data management activities. Future planning includes evaluating the use of GIS technology. Next Steps for Virginia in 1989: (1) Evaluate how RCRIS will be implemented by the Virginia Department of Waste Management. (2) Facilitate implementation of AIRS (AQS) by the Department of Air Pollution Control. (3) Provide continued training and support to the Virginia Water Control Board for PCS access. (4) Provide training to Virginia on FRDS 2.0. (5) Continue work with VA. Department of Waste Management to develop a schedule and method of implementation for access to RCRIS. (4) Monitor development of AIRS (AQS) and facilitate implementation by the Department of Air Pollution Control during FY 90. 27 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region III, Philadelphia West Virginia Phase 1 Key Regional Participants: Bill Wisniewski, ARA for Policy and Management Joe Hamilton, Wendy Bartel State Contacts: Data Bases Involved: Rick Watson PCS, GIGS, STORET, RCRIS/HWDMS, AIRS, NEDS, CDS, andFRDS Major Accomplishments in 1988-1989: (1) Installed high speed data link to connect Charleston to EPA network. (2) West Virginia formally agreed to participate in the State/EPA data management pro- gram. (3) Reviewed databases, identified data management problem areas, prepared system - by-system workplan for Regional and State actions to accomplish Phase I objectives. (4) Schedule developed for State to become a direct user of PCS as part of FY'87 106 grant agreement. (5) West Virginia received training on the new GIGS online data entry system. (6) West Virginia has direct access to GIGS, STORET and PCS. They also have access to NEEDS. (7) RCRIS State Implementation Plan developed for West Virginia. The State plans to use the PC version of RCRIS in FY 90. (8) State attended AIRS (AQS) training in march. They plan to start accessing the system during the second half of FY 89. They were also selected as one of the States to test the new AIRS (AFS) system. (9) The State attended FRDS 2.0 training. Next Steps for West Virginia in 1989: (1) Evaluate how RCRIS will be implemented by the West Virginia Department of Natural Resources. (2) Facilitate implementation of AIRS (AQS). 28 ------- Next Steps for West Virginia in 1989: (3) Provide continued training and support in regards to PCS access. (4) Facilitate implementation of AIRS (AQS). Monitor development of AIRS (AFS) and facilitate State access during FY 90. (5) Monitor progress on RCRIS and facilitate implementation of State access during FY90. (6) Develop a strategy to update the present telecommunications link in order to connect the West Virginia Air Pollution Control Commision to the EPA network. 29 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region IV, Atlanta Alabama Phase 1 Key Regional Participants: Joe Franzmathes, ARA for Policy & Management Jack Sweeney, Chief, Information Management Branch Rebecca Slack, Chief, Information Services Staff Richard Ferrazzuolo, State/EPA Data Management State Contacts: Data Bases Involved: Walter Corbitt, Bradley Gane, Alabama Dept. of Environmental Management (ADEM) FRDS, AIRS, PCS, GIGS, STORET, and HWDMS Major Accomplishments in 1988-1989: (1) GIGS and PCS users not connected to dedicated line to NCC; State has ordered neccessary hardware to enable direct access through computer to the dedicated line. (2) EPA contractor visited State to assist in eliminating duplicative data in PCS; PCS data quality problems are being addressed. (3) ADEM air programs using DEC microVAX to manage CDS and AIRS; this machine is linked to NCC via the 9600 baud dedicated line. (4) EPA and EPA contractor met with ADEM staff to discuss State/EPA Data Management Program with particular emphasis on information sharing with EPA; recommendations were made in areas of technical assistance, and attendance at user-training sessions. Next Steps for Alabama in 1989-1990: (1) State plans to switch to a PC-based system for FRDS data entry. (2) In process of establishing State/EPA Data Management Memorandum-of-Under- standing. 31 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region IV, Atlanta Florida Phase 1 Key Regional Participants: Joe Franzmathes, ARA for Policy & Management Jack Sweeney, Chief, Information Management Branch Rebecca Slack, Chief, Information Services Staff Richard Ferrazzuolo, State/EPA Data Management State Contacts: Data Bases Involved: John Wilmott, Florida Dept. of Environmental Regulation FRDS, AIRS, CDS, RCRIS, GICS, STORET, and HWDMS Major Accomplishments in 1988-1989: (1) Installation of a new IBM 3090 with access to the NCC dedicated line. (2) EPA Information Management personnel met with State counterparts to develop a State/EPA Data Management Implementation Plan. (3) Successful implementation of AIRS with direct data transfer quarterly. Next Steps for Florida in 1989-1990: (1) PCS connectivity when program is delegated. (2) Development and management of AIRS-AFS data entry/editing programs. (3) In process of establishing State/EPA Data Management Memorandum-of-Under- standing. (4) Selected as RCRIS pilot state. (5) FRDS II data entry verfication. 32 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region IV, Atlanta Georgia Phase 2 Key Regional Participants: Joe Franzmathes, ARA for Policy & Management Jack Sweeney, Chief, Information Management Branch Rebecca Slack, Chief, Information Services Staff Richard Ferrazzuolo, State/EPA Data Management State Contacts: Data Bases Involved: Jim Setser, Ted Jackson, Georgia Environmental Protection Division FRDS, AIRS, PCS, RCRIS, NEDS, GIGS, STORET, and HWDMS Major Accomplishments in 1988-1989: State completed Phase 2 in March 1988 encompassing three major target areas: (1) Data integration to support decision making. (2) Use of GIS to relate and analyze data from multiple media. (3) Support of the toxics and risk management program. (4) Development and demonstration of cost effective processes for entering quality- assured electronically reported data. (5) Planning and implementation of expanded initiatives to futher reduce risk of ex- posure to toxic pollutants, particularly through the SARA-Title III program and the GIS Data Base System. (6) Transmitting and receiving of chemical spill information and management of data reported by facility owners, specifically as it relates to the needs of local governments that provide first response to environmental emergencies. Next Steps for Georgia in 1989-1990: (1) Selected as RCRIS pilot State. (2) AIRS-AFS implementation/start-up of direct access. 33 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region IV, Atlanta Mississippi Phase 1 Key Regional Participants: Joe Franzmathes, ARA for Policy & Management Jack Sweeney, Chief, Information Management Branch Rebecca Slack, Chief, Information Services Branch Richard Ferrazzuolo, State/EPA Data Management State Contacts: Data Bases Involved: Charles Yates, Mississippi Bureau of Pollution Control FRDS, AIRS, PCS, RCRIS, GIGS, STORET, and HWDMS Major Accomplishments in 1988-1989: (1) Completed State/Data Management Memorandum-of-Understanding with the State Department of Health. (2) Dedicated 9600 baud line installed between NCC and IBM system 36 in Jackson. (3) Successful implementation of AIRS with direct data transfer from user on State main- frame to NCC. (4) Region IV personnel visited State to discuss the program and define its goals. Next Steps for Mississippi in 1989-1990: (1) State will install single modem with several dedicated lines going to PC's in department to allow for direct connect to PCS. (2) Selected as RCRIS pilot state. (3) FRDS access to NCC from State Health Department. (4) Receive training, especially in FRDS, HWDMS, PCS, and STORET. (5) In process of establishing State/EPA Data Management Memorandum-of Under- standing with the State Bureau of Pollution Control (PCS, AIRS, CDS, GIGS, HWDMS/ RCRIS). 34 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region IV, Atlanta North Carolina Phase 1 Key Regional Participants: Joe Franzmathes, ARA for Policy & Management Jack Sweeney, Chief, Information Management Branch Rebecca Slack, Chief, Information Services Branch Richard Ferrazzuolo, State/EPA Data Management State Contacts: Data Bases Involved: Sam Kornegay, North Carolina Dept. of Environmental Manage- ment Coordinator AIRS, PCS, CDS, GIGS, STORET, FRDS and HWDMS Major Accomplishments in 1989: (1) Implementation of conversion from State system to PCS nearly complete, most facility and Discharge Monitoring Report data entered into national system. (2) Completed State/EPA Data Management Memorandum-of-Understanding. (3) Dedicated 16800 baud line installed between NCC and IBM System 36 in Raleigh. (4) Region IV personnel visited State to discuss the program and define its goals. (5) Successful implementation of AIRS with direct data transfer in SAROAD format to NCC for conversion to AIRS format. Next Steps for North Carolina in 1989-1990: (1) AIRS-AFS implementation/start-up of direct access. (2) FRDS and HWDMS programs currently in Health Department to be integrated with Department of Environmental Management. 35 ------- LEGEND: 1987 Selected States! 1988 Selected States I 1989 Selected States [ Region: State: Program Phase: Region IV, Atlanta South Carolina Phase 1 Key Regional Participants: Joe Franzmathes, ARA for Policy & Management Jack Sweeney, Chief, Information Management Branch Rebecca Slack, Chief, Information Management Branch Richard Ferrazzuolo, State/EPA Data Management State Contacts: Data Bases Involved: Robert King, South Carolina Dept. of Health and Environmental Control FRDS, AIRS, PCS, GIGS, STORET and CDS Major Accomplishments in 1988-1989: (1) Installation of 4800 baud line to State Air Lab Bldg. off dedicated line to NCC. (2) Assisted state in acquiring hardware to provide for full-screen editing for use with CDS. (3) Dedicated 16800 line installed between NCC and IBM mainframe in Columbia. (4) EPA provided technical assistance especially in the area of connectivity needs. Next Steps for South Carolina in 1989-1990: (1) State LAN not connected to dedicated line to NCC; Computer Support Division involved in reassessment and long-range planning effort. (2) AIRS-AFS implementation/start-up of direct access. (3) In process of establishing State/EPA Data Management Memorandum-of-Under- standing. (4) EPA and contractor visit State to provide technical assistance for upgrading intrastate connectivity, and for establishing GIS technology to enhance environmental protection services. 36 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region IV, Atlanta Tennessee Phase 1 Key Regional Participants: Joe Franzmathes, ARA for Policy & Management Jack Sweeney, Chief, Information Management Branch Rebecca Slack, Chief, Information Management Branch Richard Ferrazzuolo, State/EPA Data Management State Contacts: Data Bases Involved: Pat Turri, Tennessee Dept. of Health and Environment FRDS, AIRS, PCS, GICS, CDS, STORET, and HWDMS (1) Completed State/EPA Data Management Memorandum-of-Understanding. (2) EPA visited State and assisted in IRM planning and Prime computer operations. (3) Three PC's purchased for State with in-kind grants in support of State/EPA Data sharing efforts. Next Steps for Tennessee in 1989-1990: (1) AIRS, CDS, and STORET need local networking. (2) AIRS-AFS implementation/start-up of direct access. (3) Phase-out of State Mark-IV based Hazardous Waste System at NCC and replacement with RCRIS and an additional State System. Program Phase: Phase 2 Next Steps for Tennessee in 1989-1990: Development of a three-year plan for data integration. 37 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region IV, Atlanta Kentucky Phase 1 Key Regional Participants: Joe Franzmathes, ARA for Policy & Management Jack Sweeney, Chief, Information Management Branch Rebecca Slack, Chief, Information Services Staff Richard Ferrazzuolo, State/EPA Data Management State Contacts: Data Bases Involved: Russ Barnett, Kentucky Dept. of Environmental Protection FRDS, AIRS, PCS, RCRIS, NEDS, GIGS, STORET, and HWDMS Major Accomplishments in 1988-1989: (1) Installed dedicated 9600 baud line between NCC and IBM mainframe in Frankfort. (2) EPA contractor visited State and will provide IRM planning assistance and technical support. (3) Terminal loaned to State to resolve CDS data entry problem. Next Steps for Kentucky in 1989-1990: (1) Selected as RCRIS pilot state. (2) Replace high-speed printer. (3) In process of establishing State/EPA Data Management Memorandum-of-Under- standing. (4) FRDS direct data transfer. (5) Networking of PC's and upgrading RJE connectivity to all data centers. 38 ------- Kentucky continued Program Phase: Phase 2 Major Accomplishments in 1989: (1) ARC-INFO GIS installed, and several State-wide coverages such as stream reaches have been developed. (2) Integration of existing permitting and compliance data bases. Next Steps for Kentucky in 1989-1990: (1) Expansion of risk assessment capability. (2) Completion of laboratory information system and its integration with existing data bases. 39 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region V, Chicago Indiana Phase 1 Key Regional Participants: Robert Springer, ARA for Planning & Mgmt. Stephen Goranson, Chief, Information Management Branch Sandra Darden, Chief, Systems Management Section Karen Vasquez, Chief, Information Service Section Daniel Werbie, Program Analyst, Planning & Budgeting Branch State Contacts: Data Bases Involved: Kathy Posser, Commisioner, IDEM Fred Alvarez, Director Management Information Services Patricia Hinds, EPA Data Base Coordinator AIRS/AQS, NEDS, CDS, FRDS, GIGS, PCS, HWDMS/RCRIS, STORE! and TRIS Major Accomplishments in 1988 -1989: (1) Installed Phase 1 of the planned upgrade to computer equipment and network. Connectivity to EPA is now available across program areas. (2) Financial Management System is being implemented. Target date is October, 1989. (3) Implementation of CDS providing Indiana with direct data entry and capability for ad- hoc retrievals. NEDS and CDS have been reconciled across the program. (4) An improved Air Emission Testing program has been installed. (5) Processing of air quality model information has been considerably improved. (6) Indiana was the first state in Region V to receive AIRS training and to assume update authority of the system in September of 1987. AIRS has improved data integrity due to better data entry control. Next Steps for Indiana in 1989-90: (1) Intensify the development of applications that will increase the integration of State and EPA databases. (2) Complete the implementation of the network across computer platforms. (3) Complete requirements definitions for the Indiana GIS program. (4) Complete the implementation of FINDS as a system integration tool. (5) Implementation of AFS for EIS , CDS and AIRS. (6) Improve compatibility of air quality data acquisition system with AIRS format. 41 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region V, Chicago Illinois Phase 1 Key Regional Participants: Robert Springer, ARA for Planning & Mgmt. Stephen Goranson, Chief, Information Management Branch Sandra Darden, Chief, Systems Management Section Karen Vasquez, Chief, Information Service Section Daniel Werbie, Program Analyst, Planning & Budgeting Branch State Contacts: Data Bases Involved: Bernard P. Killian, Director, IEPA Roger Kanerva, Manager, Environmental Programs Patricia Patino, IRM Coordinator AIRS/AQS, NEDS, CDS, FRDS, GIGS, PCS, HWDMS/RCRIS, STORE! and TRIS Major Accomplishments in 1988 -1989: (1) Installed equipment and data link to IEPA alternate headquarters building for hook-up to AIRS, since January, 1989, IEPA has been utilizing AIRS for their quarterly updates and reporting requirements. Also successfully integrated state-run AQDHS II with AIRS. IEPA will continue utiliz- ing AQDHS II for state weekly operating needs and pass data to AIRS quarterly. (2) In June, 1989, IEPA converted from the old batch Total Air System to a newly devel- oped emissions inventory system called EIS. (3) Tentative RCRIS Implementation plan was completed and submitted to USEPA. (4) In 1989 IEPA for the first time submitted the biennial Hazardous Waste Report data via magnetic tape. (5) lEPA'S Division of Public Water Supply developed translator software to transmit the Safe Inventory and Compliance data to FRDS II. Illinois is participating as the pilot state in assisting USEPA in testing FRDS II Software . (6) IEPA implemented its 1987 Toxic Release Inventory data base and is in progress of making the necessary modifications for the 1988 Form R data submittal. (7) IEPA operates a Laboratory Information Management System (LIMS) which effectively processes effluent data to STORET. 42 ------- Next Steps for Illinois in 1989-90: (1) Working with USEPA to implement a more efficient bulk data transfer protocol. (2) Interested in applying data integration and analysis tools to assess environmental risk around hazardous waste sites, especially in highly populated areas. (3) Plan to integrate RCRIS into the State mainframe computer system or choose to be a user of RCRIS on the Region V logical mainframe. (4) Perform future translation from the new IEPA EIS system to AIRS/AFS. (5) District offices will benefit from interactive access to facility information. (6) Improve compatibility of air quality data acquisition system with AIRS format. 43 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region V, Chicago Michigan Phase 1 Key Regional Participants: Robert Springer, ARAfor Planning & Mgmt. Stephen Goranson, Chief, Information Management Branch Sandra Darden, Chief, Systems Management Section Karen Vasquez, Chief, Information Service Section Daniel Werbie, Program Analyst, Planning & Budgeting Branch State Contacts: Data Bases Involved: David F. Hales, Director, MDNR Delbert Rector, Deputy Director for Evironmental Protection Gary Hughes, Assisant Director, DEQ AIRS/AQS, NEDS, CDS, FRDS, GICS, PCS, HWDMS/RCRIS, STORE! and TRIS Major Accomplishments in 1988 -1989: (1) MDNR Air Quality division has purchased new PC workstations that will have the ability to network with the mainframe computer in Lansing. This will allow electronic communication, transfer of documents, and access to data on the mainframe by all Air Quality DNR staff. (2) EPA's e-mail system has been especially useful in communicating/exchanging infor- mation and accessing the International Joint Commission bulletin board. (3) MDNR uses the Integrated Risk Information System (IRIS) to provide health based numbers used for risk assessment for Superfund sites and all contamination sites in the state. (4) The Toxic Chemical Release Inventory (TRI) is used by MDNR to determine the highest quality of pollutants used in the State and the companies that are the highest emitters for that type of chemical. 44 ------- Major Accomplishments in Michigan 1988-1989 continued. (6) A geographic information system and staff were established to support all of the DNR for defining impacts of pollution on land use and natural resources. Milestones this fiscal year are: (a) digitization of all 7.5 Minute USGS QUADRANGLE base maps for the State (b) digitization of land cover/use data for entire State (c) automation of water well logs information from four counties to groundwater data base and (d) completion of Great Lakes Environmental Quality Data Base for Lake Michigan and Lake Huron. (7) Groundwater data are transferred from PC disk files into STORET. MDNR is already stored RCRA hazardous waste data in the system. (8) MDNR implemented a software application that allows direct batch update of selected State water permit information to PCS. (9) MDNR uses the host-to-host connection from State to EPA mainframe computer for file transfers and remote printing of water quality data (STORET). PC's are used to access interactive STORET and other systems/data such as BIOS, DWS, USGS, GAGE REACH, WBS, IFD, and PCS. Next Steps for Michigan in 1989-90: (1) MDNR is continuing to investigate the potential of the AIRS facility subsystem, the steps that would have to be taken to utilize the subsystem, and the conversions necessary to utilize existing data. (2) MDNR's Permit Writing System will be modified to provide input of outfall and parameter level NPDES data in a format which emulates the PCS Discharge Monitoring Report (DMR). (3) EPA/MDNR are working to develop a quality assurance test for PCS effluent limit data. (4) The transfer and storage of fish tissue data from RBase to the STORET system and biological data into STORET BIOS is being explored. (5) MDNR has requested funds for a graphics terminal and software that could tie together land use GIS data and the data in STORET using the host-host connection with EPA- RTP. (6) MDNR is investigating file transfer of results from its labs to PC's and use of EPA's Region X LOTUS to STORET utility program to convert the data to a STORET format in order to eliminate multiple keying of data. 45 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region V, Chicago Minnesota Phase 1 Key Regional Participants: Robert Springer, ARA for Planning & Mgmt. Stephen Goranson, Chief, Information Management Branch Sandra Darden, Chief, Systems Management Section Karen Vasquez, Chief, Information Service Section Daniel Werbie, Program Analyst, Planning & Budgeting Branch State Contacts: Data Bases Involved: Gerald L Willet, Commissioner, MPCA Bonnie Sims, Assistant Commissioner, MPCA Greg Foley, Chief, Information Management AIRS/AQS, NEDS, CDS, FRDS, GIGS, PCS, HWDMS/RCRIS, STORET and TRIS Major Accomplishments in 1988 -1989: (1) MPCA is an active State representative on the national State/EPA Data Management Steering Committee. (2) MPCA established a new VAX computer system to consolidate all program data files and provide more management access to systems. (3) MPCA developed the Integrated Ground Water Information System (IGWIS) which served as a model in EPA's development of the core ground water data elements. Eight environmental programs, including USGS, participated in establishing the IGWIS data dictonary. (4) Minnesota received AIRS/AQS training and assumed update of the systems in March 1989. Next Steps for Illinois in 1989-90: (1) Continue conversion of IGWIS to the new VAX data base management system, INGRES. (2) Pursue facility data integration to allow managers to address program issues across media. (3) Conversion and integration of State hazardous waste data management system to the VAX and develop RCRIS translator. (4) Improve compatibility of air quality data acquisiton system with AIRS format. 46 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region V, Chicago Ohio Phase 1 Key Regional Participants: Robert Springer, ARA for Planning & Mgmt. Stephen Goranson, Chief, Information Management Branch Sandra Darden, Chief, Systems Management Section Karen Vasquez, Chief, Information Service Section Daniel Werbie, Program Analyst, Planning & Budgeting Branch State Contacts: Data Bases Involved: Richard L. Shank, Ph.D., Director, OEPA Michael Mead, Director, Chief, Data Systems Louwana Whitlow, Chief, Programming and Analysis AIRS/AQS, NEDS, CDS, FRDS, GIGS, PCS, HWDMS/RCRIS, STORE! and TRIS Major Accomplishments in 1988 -1989: (1) OEPA personnel received training in AIRS, and, since April, 1988, OEPA has been utilizing AIRS for quarterly updates and reporting requirements. AQDHS will continue to be used because of the large amount of source specific air quality data submitted by power utilities in the State. (2) OEPA has performed extensive validation of facility information available to its geographic information system, PEMSO. (3) Training was given to OEPA in CDS. The State is providing data electronically to USEPA as well as retrieving directly from CDS. (4) OEPA is using PCS for compliance and inspection information sharing, and is converting daily DMR data to monthly values through a translator to PCS. (5) The Agency's minicomputer was expanded to accomodate a total of 128 users, each has 3270 SNA access to NCC applications as needed. Next Steps for Ohio in 1989-90: (1) OEPA plans to implement the full RCRIS package on the State system and then upload directly to the Regional logical mainframe computer. (2) Improve compatibility of air quality data acquisition system with AIRS format. (3) OEPA is interested in participating with Region 5 in a GIS project concerning Ashtabula, Ohio. 47 ------- Next Steps for Ohio in 1989-90 continued (4) The Agency will continue to support the PEMSO GIS system and explore interface with ARC/INFO. There is need to integrate transportation systems, public utilities, the Toxics Release Inventory information, and soil conservation data. (5) Interested in applying data integration and analysis tools to risk assessment. (6) Project to improve compatibility of State information with PCS, including evaluation of both State and Federal systems in light of program needs. (7) Plan to participate in Regional facility identification integration project. (8) Develop an interface between State MSIS system and FROS-II. (9) Develop a PC based network for State Revolving loan fund which will interface with GICS. 48 ------- LEGEND: 1987 Selected States •• 1988 Selected States 1989 Selected States Fx"X"Xl Region: State: Program Phase: Region V, Chicago Wisconsin Phase 1 Key Regional Participants: Robert Springer, ARA for Planning & Mgmt. Stephen Goranson, Chief, Information Management Branch Sandra Darden, Chief, Systems Management Section Karen Vasquez, Chief, Information Service Section Daniel Werbie, Program Analyst, Planning & Budgeting Branch State Contacts: Data Bases Involved: Carroll D. Besnady, Secretary, WDNR Lyman F. Wible, Administrator, Division of Environmental Quality Thomas Aten, Division Data Coordinator AIRS/AQS, NEDS, CDS, FRDS, GIGS, PCS, HWDMS/RCRIS, STORE! and TRIS Major Accomplishments in 1988 -1989: (1) Established a WDNR VAX computing system to replace dependence on the Depart- ment of Transportation system. (2) Safe Drinking Water data is submitted to EPA under FRDS 1. 5 format and version 2 data when it will be required. (3) WDNR has been a pioneer in the development and implementation of AIRS. WNDR developed a new State data acquisition system that produces data in AIRS format. (4) The agency regularly provides recommendations to the National Aerometric Data Branch (NADB) for additional reports. They developed a quarterly data summary for AIRS, which has been widely reviewed and accepted. NADB is working with WDNR to further develop the program. (5) Extensively reviewed and modified the PCS interface to the WDNR system, using EPA funding. (6) Participated in the RCRIS database design effort, by initiating development efforts to support both State and EPA Data element requirements. (7) WDNR has standardized use of analytic parameter codes and table-referenced them to STORET parameter codes to facilitate both data transfer and cross media analysis. 49 ------- Major Accomplishments in 1988 -1989 continued (8) In general, WDNR has been trying to provide staff with better access to EPA database through installation of a TYMNET engine, which may now be accessed through the new VAX environment for both terminal and RJE/printing. Next Steps for Wisconsin in 1989-90: (1) Cooperative evaluation and development of facilities to provide for integrating "facility" data between WDNR system and the EPA counterparts. (2) Investigate the use of a local GIS workstation to support the EPA's Green Bay Mass Balance project. (3) WDNR will participate as a RCRIS translator State, operating an integrated hazardous waste information system from which data will be extracted to export to the Regional Logical Mainframe as required. (4) File transfer facilities through TYMNET for updating EPA system with State data. (5) Evaluate the use of SARA Title 3 section 313 reported data in the environmental programs. 50 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Key Regional Participants: State Contact: Data Bases Involved: Region VI, Dallas Texas Phase 1 Harless Benthul, Acting ARA for Management Jane Moore, Lynda Carroll, Julie Brown John Wilson, Manager, Applications Development Center David Lancaster, Director of Programs Bob Miller, Director, Data Processing NEDS, AIRS-AQSS, CDS, PCS, STORET, GIGS and HWDMS Major Accomplishments in 1988-1989: (1) High-Speed data link from Austin (TWRB) to EPA network installed. (2) Assessment of TWC, TACB and TWDB current and future use of EPA information systems was conducted by EPA, Region VI and American Management Systems. Following indentification of data management strengths and weaknesses for the seven study systems, a proposed workplan was developed which specified Regional and State actions necessary to accomplish Phase I objectives. Next Steps for Texas in 1989: (1) Negotiation, in conjunction with State and Regional program counterparts, of a joint State/EPA workplan to address data management weaknesses. 51 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Key Regional Participants: State Contact: Data Bases Involved: Region VI, Dallas Oklahoma Phase 1 Harless Benthul, Acting ARA for Management Jane Moore, Lynda Carroll, Julie Brown Ben Thorpe, Environmental Specialist Supervisor David Dillon, Chief, Water Quality Division David Jennings, Senior Environmental Specialist NEDS, AIRS-AQSS, CDS, PCS, STORET, GICS and HWDMS Major Accomplishments in 1988-1989: (1) High-Speed data link from Oklahoma City to EPA network installed. (2) Assessment of OSDH, OWRB and ODPC use of EPA information systems was con- ducted by EPA, Region VI and American Management Systems. Data management strengths and weaknesses were identified system-by-system and a proposed work- plan was developed which would enable the Region and the State actions necessary to accomplish Phase 1 objectives. Next Steps for Oklahoma in 1989: (1) Negotiation, in conjunction with State and Regional program counterparts, of a joint State/EPA workplan to address data management weaknesses. 52 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Key Regional Participants: State Contact: Data Bases Involved: Region VI, Dallas Louisiana Phase 1 Harless Benthul, Acting ARA for Management Jane Moore, Lynda Carroll, Julie Brown J. Dale Givens, Administrator, Municipal Facilities Division NEDS, AIRS-AQSS, CDS, PCS, STORET, GIGS and HWDMS Major Accomplishments in 1988-1989: (1) High-Speed data link from Baton Rouge to EPA network installed. (2) Reviewed data bases, identified data management problem areas and prepared a proposed system-by-system workplan for Regional and State actions to accomplish Phase 1 objectives. (3) Independently, LDEQ had engaged a contractor to review all systems (not just the seven in this project) and propose a strategy for integration. Next Steps for Louisiana in 1989: (1) Negotiation, in conjunction with State and Regional program counterparts, of a joint State/EPA workplan to address data management weaknesses. 53 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Key Regional Participants: State Contact: Data Bases Involved: Region VI, Dallas New Mexico Phase 1 Harless Benthul, Acting ARA for Management Jane Moore, Lynda Carroll, Julie Brown Kirk Jones, Deputy Director, New Mexico Environment Improvement Division (NMEIMD) NEDS, AIRS-AQSS, CDS, PCS, STORET, GICS and HWDMS Major Accomplishments in 1989: (1) Preparations made for installation of high-speed data link from Santa Fe to EPA net- work. (2) Assessment of NMEID use of EPA information systems was conducted by Region VI and American Management Systems (AMS). Following identification of data manage- ment strengths and weaknesses for the seven study systems , a proposed workplan was developed which specified the Regional and State actions required to accomplish Phase I objectives. Next Steps for New Mexico: (1) Negotiation, in conjunction with State and Regional program counterparts, of a joint State/EPA workplan to address data management opportunities. 54 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Key Regional Participants: State Contact: Data Bases Involved: Region VI, Dallas Arkansas Phase 1 Harless Benthul, Acting ARA for Management Jane Moore, Lynda Carroll, Julie Brown Robert Gage, Systems Administrator, Arkansas Department of Pollution Control and Ecology NEDS, AIRS-AQSS, CDS, PCS, STORET, GICS and HWDMS Major Accomplishments in 1988-1989: (1) Pilot project conducted in 1987. (2) High-speed data link from Little Rock to EPA network improved. (3) Technology and resources provided to enhance State's computing and telecommuni- cations capabilities. (4) State program staff received training in EPA systems. (5) American Management System conducted interviews with ADPC&E to determine whether situation is materially different than in 1987. 55 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region VII, Kansas City Missouri Phase 2 Key Regional Participants: Susan Gordon, ARA for Policy and Management Gene Ramsey, Dan Vallero, David Flora, Katie Biggs, Lynn Kring State Contacts: Data Bases Involved: Bill Ford, Director, Department of Environmental Quality, Stan Nessing NEDS, SAROAD, CDS, PCS, GIGS, FRDS, STORE! and HWDMS Major Accomplishments in 1988-1989: (1) State/EPA internal/external relationships substantially enhanced. (2) Support State's own data bases: DUST, WQIS, PWS. (3) Quarterly State/EPA Information Resource Management meetings (including both IRM and programmatic topics, e.g., GIS, Expert Systems, Right-to-Know, Data Integration, Connectivity, Natinal Systems Upgrades, user technical assistance. (4) Completed analysis and detailed data flows for State RCRIS and implemented microbased and other improvments. (5) Completed FRDS analysis and, as a result developed new State PWS system (mainframe and micros). (6) Provided cooperative on site technical assistance to MDNR providing complete menu of applications from NCC. Now State has NCC related capabilities and applications provided to all state locations. (7) Provided State technical assistance to transmit reports from Region to all on site MDNR printers. (8) Facilitated use of new technologies such as expert systems and GIS. Established Cooperative Agreement process to utilize GIS to assist in the development of well- head protection plans for the State. (9) Incorporated State/EPA Data Management Initiative into workplan and State/EPA Agreement process (total involvement of Regional and State media programs). Next Steps for Missouri in 1989: (1) Continue to ensure timely, accurate and complete data, especially with national system upgrades. 57 ------- Next Steps for Missouri in 1989 continued (2) Continue to coordinate IRM efforts across state and EPA organizational and media lines (3) Continue EPA on-going IRM support IRM Directives, Information Systems Inventories, On-site Technical Support visits, Quarterly IRM Meetings and Training. (4) Additional training for AIRS-AQS data entry. (5) Second round advanced data management (GIS) work in Missouri: Continue data integration improvements and explore advanced applications (GIS); initiate Coop- erative Agreement to continue FY 1989 efforts and to provide assistance and apply the developed GIS system to specific environmental decision making processes. (6) Completed systems improvements to RCRIS and PWS reprogram plan devised from Phase II analysis. (7) Develop expert systems and implement geographic information systems. 58 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region VII, Kansas City Iowa Completed Phase 1, entering Phase 2 Key Regional Participants: Susan Gordon, ARA for Policy and Management Gene Ramsey, Dan Vallero, David Flora, Katie Biggs, Lynn Kring State Contacts: Data Bases Involved: Darrell MacAllister, Iowa Department of Air, Water and Waste NEDS, SAROAD, CDS, PCS, GIGS, FRDS, STORET/WBS and HWDMS/RCRIS Major Accomplishments in 1988-1989: (1) State/EPA internal/external relationships substantially enhanced. (2) Transferred information gained from Missouri pilot to Iowa. (3) Achieved timely and accurate data. (4) Memorandum of Understanding for State data integrity in process. (5) Access to direct link within State for all systems. (6) State uses EPA systems for Air Programs, GIGS and STORET. (7) Key State organizational units and personnel identified and committed to effort. (8) Incorporated State/EPA Data Management Initiative into workplan and State/EPA Agreement process (total involvement of Regional and State media programs). (9) Created environment for data integration. Established cooperative agreement to assist State environmental programs to integrate GIS capabilities into State-wide GISplan. (10) Deputy Regional Administrator, Assistant Regional Administrator and Senior Program Managers visited Iowa to review projects and discuss next steps. Next Steps for Iowa in 1989: (1) Finalize the Memorandum of Understanding for State data integrity. (2) Continue to ensure timely, accurate and complete data, especially with national system upgrades. 59 ------- Next Steps for Iowa in 1989 continued (3) Continue EPA on-going IRM support IRM Directives, Information System Inventories, On-site Technical Support visits, Quarterly IRM Meetings and Training. (4) Continue to coordinate IRM efforts across state and EPA organizarional and media lines. (5) Additional training for STORET, AIRS-AQS, GICS/SRF (State Revolving fund). (6) Second round advanced data management (GIS) work in Iowa: Continue data integration improvements and explore advanced applications (GIS); initiate Cooperative Agreement to continue FY 1989 efforts and to provide assistance and apply the developed GIS system to specific environmental decision making processes. 60 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region VII, Kansas City Kansas Completed Phase I, entering Phase 2 Key Regional Participants: Susan Gordon, ARA for Policy and Management Gene Ramsey, Dan Vallero, David Flora, Katie Biggs, Lynn Kring State Contacts: Data Bases Involved: Loren Phillips, Kansas Department of Health and Environment NEDS, SAROAD, CDS, PCS, GIGS, FRDS, STORE, WBS, and HWDMS/RCRIS Major Accomplishments in 1988-1989: (1) State/EPA internal/external relationships substantially enhanced. (2) Transfererred information gained from Missouri pilot to Kansas. (3) Achieved timely and accurate data. (4) Connected direct high speed data link. (4) Memorandum of Understanding for State data integrity near completion. (5) Access to direct link within State for STORET/BIOS. (6) State uses EPS systems for Air Programs and STORET. (7) Incorporated State/EPA Data Management Initiative into workplan and State/EPA Agreement process (total involvement of Regional and State media programs). (8) Created environment for data integration. Established cooperative agreement be- tween EPA and two state agencies to complete pilot GIS project for assessment of non-point source impacts on water quality and provide information for development of a management plan to control sources. (9) Provided cooperative technical assistance to establish user support to allow state to enter HWDMS data through Region VII mainframe. Next Steps for Kansas in 1989: (1) Finalize the Memorandum of Understanding for State data integrity. (2) Continue to ensure timely, accurate and complete data, especially with national system upgrades. 61 ------- Next Steps for Kansas in 1989 continued (3) Continue EPA on-going IRM support (IRM) Update, IRM Directives, Information System Inventories, On-site Technical Support visits, Quarterly IRM Meetings and Training. (4) Continue to coordinate IRM efforts across state and EPA organizational and media lines. (5) Access to high speed data lines within the State. (6) Additional training on PCS and AIRS. (7) Second round advanced data management (GIS) work in Kansas: Continue data integrity improvements and explore advanced applications (GIS); initiate Cooperative Agreement with KDHE and U.S. Geographic Survey to incorporate GIS into county wide environmental planning. 62 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State- Program Phase: Region VII, Kansas City Nebraska Completed Phase 1, entering Phase 2 Key Regional Participants: Susan Gordon, ARA for Policy and Management Gene Ramsey, Dan Vallero, David Flora, Katie Biggs, Lynn Kring State Contacts: Data Bases Involved: Dennis Burling, Nebraska Department of Environmental Control NEDS, SAROAD, CDS, PCS, GIGS, FRDS, STORETBIOS, WBS, and HWDMS/RCRIS Major Accomplishments in 1988-1989: (1) State/EPA internal/external relationships substantially enhanced. (2) Transfererred information gained from Missouri pilot to Nebraska. (3) Began Phase 1 in FY 1988. (4) Achieved timely and accurate data. (5) Connected direct high speed data link. (6) Memorandum of Understanding for State data integrity in process. (7) Access to direct link within State for all systems. (8) State uses EPS systems for Air Programs and STORET. (9) Incorporated State/EPA Data Management Initiative into workplan and State/EPA Agreement process (total involvement of Regional and State media programs). (10) Created environment for data integration. Established cooperative agreement with the University of Nebraska to utilize GIS to conduct a state wide groundwater threat evaluation. (11) Provided cooperative technical assistance to establish procedure to run, modify and produce reports more efficiently from HWDMS system. Next Steps for Nebraska in 1989: (1) Finalize the Memorandum of Understanding for State data integrity. (2) Continue to ensure timely, accurate and complete data, especially with national system upgrades. 63 ------- Next Steps for Nebraska in 1989 continued (3) Continue EPA on-going IRM support (IRM) Update, IRM Directives, Information System Inventories, On-site Technical Support visits, Quarterly IRM Meetings and Training. (4) Continue to coordinate IRM efforts across state and EPA organizational and media lines (5) Access to high speed data lines within the State. (6) Additional training on PCS and AIRS, BIOS and WBS. (7) Second round advanced data management (GIS) work in Nebraska: Continue data integrity improvements and explore advanced applications (GIS); initiate Cooperative Agreement that will build on FY 1989 accomplishments to pilot development of a state strategy for surface and groundwater quality protection. 64 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region VIII, Denver Utah Phase 2 Key Regional Participants: Kerrigan Clough, ARA for Policy and Management Marcella Osterholt, Program Manager for State/EPA Data Management State Contacts: Data Bases Involved: Robert Shipman, Data Sharing Coordinator NEDS, SAROAD, CDS, PCS, GICS, STORET, and HWDMS Major Accomplishments in 1988-1989: (1) Completion of Phase 1. (2) Developed data integrity policies and programs for each of the National data bases. (3) Developed user support and training program addressing the needs of each system. (4) The Integrated Information Management System (IIMS) software developed for Georgia was modified successfully for use in Utah. (5) The RCRA Information Management System (RIMS) software was developed for Utah. (6) Hosted the first Regional Data Management Conference. (7) Data Mangement systems for SARA Title III completed. Next Steps for Utah in 1990: (1) Upgrade Prime 2655 to the 4000 series. (2) New systems to be developed include an Underground Injection Control, and an X-ray Program Tracking System. (3) Complete analysis of water pollution program data needs. (4) Development of new software and techniques to maximize data integration. (5) Conversion of NEDS and CDS to the AIRS Facility Subsystem. 65 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region VIII, Denver Colorado Phase 1 Key Regional Participants: Kerrigan Clough, ARA for Policy and Management Marcel la Osterhoit, Program Manager for State/EPA Data Management State Contacts: Data Bases Involved: Gary Broetzman, Deputy Director Colorado Department of Health FRDS, ERNS, IRIS, CERCLIS, PCS, GIGS, STORET, and HWDMS Major Accomplishments in 1988-1989: (1) Upgraded the high-speed data link which connects Denver to EPA network. (2) Region conducted partial data needs assessment. (3) Attended 1st Regional Data Management Conference, in Salt Lake City, Utah. (4) State conducted a further data needs assessment to evaluate the feasibility of a department wide ADABAS System which would incorporate Facilities, Permits, and Compliance files. Next Steps for Colorado in 1990: (1) Conversion of NEDS and CDS to the AIRS Facility Subsystem. (2) An Option Analyses will be conducted which will identify system options to achieve SEDM goals, each option will include projected costs and benefits. (3) Based upon the selected options, an Implementation plan will be developed to identify necessary tasks, responsibilities, and milestones for completion of Phase 1 of the SEDM Program. 66 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region VIII, Denver North Dakota Phase 1 Key Regional Participants: Kerrigan Clough, ARA for Policy and Management Marcella Osterholt, Program Manager for State/EPA Data Management State Contacts: Data Bases Involved: Charles Rydell, Env. Engineer, State Dept. of Health NEDS, AQDHS, CDS, PCS, GICS, STORET, AIRS and WBS Major Accomplishments in 1988-1989: (1) Installed high speed data link to connect Bismarkto EPA network. (2) Completely automated the Air Quality data submission and acquisition. (3) Region conducted a preliminary data needs assessment. (4) Region to conduct an in depth Data Management Needs Assessment which will include: • Project Work Plan • Background Report • Requirements Analyses • Option Analyses • Implementation Plan (5) Attended 1st Regional Data Management Conference in Salt Lake City, Utah. (6) Completed FRDS training, are now sending Public Water Data direct to NCC. Next Steps for North Dakota in 1990: (1) Completion of Data Management Needs Assessment. (2) Conversion of NEDS and CDS to the AIRS Facility Subsystem. 67 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region VIII, Denver South Dakota Phase 1 Key Regional Participants: Kerrigan Clough, ARA for Policy and Management Marcella Osterholt, Program Manager for State/EPA Data Management State Contacts: Data Bases Involved: Ron Woodburn, Natural Resource Scientist CDS, PCS, GIGS, STORET, and AIRS Major Accomplishments in 1988-1989: (1) GIS needs survey completed. (2) Region conducted a preliminary data needs assessment. (4) Region to conduct an in-depth Data Management needs assessment which will include: • Project Work Plan • Background Report • Requirements Analyses • Option Analyses • Implementation Plan (5) Attended 1st Regional Data Management Conference in Salt Lake City, Utah. (6) Explore the feasibility of implementing a statewide GIS. Next Steps for South Dakota in 1990: (1) Completion of Data Management Needs Assessment. (2) Conversion of NEDS and CDS to the AIRS Facility Subsystem. (3) Install high-speed data link to connect Pierre to the EPA network. (4) Installation of a mini-computer. 68 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region VIII, Denver Wyoming Phase 1 Key Regional Participants: Kerrigan Clough, ARA for Policy and Management Marcella Osterholt, Program Manager for State/EPA Data Management State Contacts: Jim Uzzell, Admin. Service Manager, Department of Enviro- mental Quality Data Bases Involved: No direct input to NCC Major Accomplishments in 1988-1989: (1) Region to conduct an in depth Data Management Needs Assessment which will include: • Project Work Plan • Background Report • Requirements Analyses • Option Analyses • Implementation Plan (2) Attended 1st Regional Data Management Conference in Salt Lake City, Utah. Next Steps for Wyoming in 1990: (1) Completion of Data Management Needs Assessment. (2) Conversion of NEDS and CDS to the AIRS Facility Subsystem. (3) Install a high-speed data link to connect Cheyenne to the EPA network. 69 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region VIII, Denver Montana Phase 1 Key Regional Participants: Kerrigan Clough, ARA for Policy and Management Marcella Osterholt, Program Manager for State/EPA Data Management State Contacts: Data Bases Involved: Tom Reid, Env. Specialist, Department of Health and Env. Sciences NEEDS, NEDS, AQHS, PCS, GIGS, STORET, and AIRS Major Accomplishments in 1988-1989: (1) Installed high-speed data link to connect Helena to EPA network. (2) Region conducted a preliminary data needs assessment. (4) Region to conduct an in depth Data Management Needs Assessment (5) Attended 1st Regional Data Management Conference in Salt Lake City, Utah. (6) Installed a Prime mini-computer in the State Library for the GIS Clark Fork River Superfund sites. Next Steps for Montana in 1990: (1) Completion of Phase 1 (2) Start of Phase 2 (3) The facility Subsystem will replace NEDS and CDS. 70 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region IX, San Francisco California Phase 1 and 2 Key Regional Participants: Nora McGee, ARA for Policy and Management (Vacant) Chief, Office of Policy and Management, IRM Branch MarkT. Hemry, IRM Specialist, IRM Branch State Contacts: Data Bases Involved: Phil Daniels and Don Anderson, State Water Resources Control Steve Hanna, Environmental Affairs Chuck Schulock, Director of Environmental Affairs Chuck Lieberman, Air Resource Control Board Jim Watson, Dept. of Health Services Elaine Limeberger, TEALE Data Center PCS, GIGS, STORET, HWDMS (RCRIS), AIRS (NEDS, SAROAD and CDS) Major Accomplishments in 1988-1989: (1) Completed connection of all systems to the central Sacramento node. (2) Mapped the extensive California communication network to allow for remote access and printing of system reports. (3) Completed workplan actions to provide California Air Resources Control Board with AIRS retrieval. (4) Completed workplan actions to establish California as a pilot RCRIS site. (5) Develop workplans and objectives for SIRS development and facilitate state implementation of the system. (6) Develop workplans and objectives for RDRIS development and facilitate State implementation of the system. (7) Develop state contacts to facilitate the use of new technologies such as expert systems and geographic information systems within the state. (8) Prepared draft Memorandum of Understanding regarding integrity protocols for each data system. 71 ------- Next Steps for California in 1989: (1) Define policy on major IRM issues which provides a framework for implementing Phase 2 (data integration). (2) Further development of FINDS to allow for greater data integration. (3) Monitor AIRS development and facilitate State implementation of the system. (4) Monitor RCRIS development and facilitate State implementation of the system. (5) Facilitate use of new technologies such as expert systems and geographic in- formation systems. (6) Endorse Agreement on Memorandum of Understanding regarding data integrity and protocols for all data systems. 72 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Key Regional Participan: State Contacts: Data Bases Involved: Region IX, San Francisco Arizona Phase 1 Nora McGee, ARA for Policy and Management (Vacant) Chief, Office of Policy and Management, IRM Branch MarkT. Hemry, IRM Specialist, IRM BRanch Mike Doyle, Deputy Director, AZ Department of Environmental Quality Fran Gonzalo, Director, Office of Administration Gerry Pater, Director, Office of Automation Tom Messina, Office of Automation PCS, GIGS, STORET, HWDMS (RCRIS), AIRS (NEDS, SAROAD and CDS) Major Accomplishments in 1988-1989: (1) Conducted preliminary requirements analysis of data communications and ADP equip- ment needs to allow for direct, high-speed, on-line connectivity to individual program operations. (2) Submitted a TSR to the NCC Telecommunications operations to establish the required high-speed data link. (3) Established a high speed data link to Phoenix AZ DEQ Honeywell DPSD6 minicomputer and the EPA NCC IBM 3090. (4) Prepared draft Memorandum of Understanding regarding integrity protocols for each data system. Next Steps for Arizona in 1989: (1) Prepare and implement training plans to enhance the use of EPA systems in support of program operations. (2) Identify data management problem areas and prepare a workplan for Regional and State actions to complete Phase 1 objectives. (3) Resolve any impediments to timely and accurate data processing. (4) Endorse agreement on Memorandum of Understandings regarding data integrity and protocols for all data systems. 73 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region IX, San Francisco Hawaii Phase 1 Key Regional Participants: Nora McGee, ARA for Policy and Management (Vacant) Chief, Office of Policy and Management, IRM Branch MarkT. Hemry, IRM Specialist, IRM BRanch State Contacts: Data Bases Involved: Dr. Bruce Anderson, Deputy Director, HI Department of Health Paul Aki PCS, GICS, STORET, HWDMS/RCRIS, AIRS, NEDS, SAROAD and CDS Major Accomplishments in 1988-1989: (1) Conducted preliminary requirements analysis of data communications and ADP equip- ment needs to allow for direct, high-speed, on-line connectivity to individual program operations. (2) Submitted a TSR to the NCC Telecommunications operations to establish the required high-speed data link. (3) Procuried necessary hardware and software to facilitate PC connectivity. (4) Prepared draft Memorandum of Understanding regarding integrity protocols for each data system. (5) Assisted in the development of ADP wiring plan for the Department of Health's upcoming move into new facilities. Next Steps for Hawaii in 1989: (1) Prepare and implement training plans to enhance the use of EPA systems in support of program operations. (2) Identify data management problem areas and prepare a workplan for Regional and State actions to complete Phase I objectives. (3) Resolve any impediments to timely and accurate data processing. (4) Endorse agreement on Memorandum of Understandings regarding data integrity and protocols for all data systems. (5) Establish a high-speed data link from Honolulu DEQ to the EPA NCC IBM 3090. 74 ------- LEGEND: 1987 Selected States •• 1988 Selected States 1989 Selected States KXX3 Region: State: Program Phase: Region IX, San Francisco Nevada Phase 1 Key Regional Participants: Nora McGee, ARA for Policy and Management (Vacant) Chief, Office of Policy and Management, IRM Branch Mark T. Hemry, IRM Specialist, IRM BRanch State Contacts: Data Bases Involved: Lou Dodgion, Director NV Department of Environemntal Protection Ralph Capurro PCS, GIGS, STORET, HWDMS/RCRIS, AIRS, NEDS, SAROAD and CDS Major Accomplishments in 1988-1989: (1) Conducted preliminary requirements analysis of data communications and ADP equip- ment needs to allow for direct, high-speed, on-line connectivity to individual program operations. (2) Procured necessary hardware and software to facilitate PC connectivity. (3) Procurred a TELEX Cluster Controller, PCOX boards, and software for PC con- nectivity. (4) Prepared draft Memorandum of Understanding regarding integrity protocols for each data system. (5) Established a high speed data link with the EPA NCC IBM 3090 via a cluster controller and PCOX boards. Next Steps for Nevada in 1989: (1) Prepare and implement training plans to enhance the use of EPA systems in support of program operations. (2) Identify data management problem areas and prepare a workplan for Regional and State actions to complete Phase 1 objectives. (3) Resolve any impediments to timely and accurate data processing. (4) Endorse agreement on Memorandum of Understanding regarding data integrity and protocols for all data systems. 75 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region X, Seattle Oregon Phase 1 Key Regional Participants: Clark Gaulding, Director, Management Division Jim Peterson, Chief, Information Mgmt Branch State Contacts: Data Bases Involved: Dennis Kirk Lydia Taylor CDS, PCS, GIGS, STORET, AIRS (AQS and AFS) and RCRIS Major Accomplishments in 1988-1989: (1) Senior Managers from DEQ and EPA-Region IX held a joint retreat. Data manage- ment issues were discussed as a major topics. (2) State conversion from Harris compluted to new Sequent minicomputer. (3) Training on STORET and GIS at EPA. (4) Pre-RCRIS training and coordination. (5) Training, and coordination on AIRS-AQS. (6) Assisting in communication set up for GIS access. Next Steps for Oregon in 1990: (1) Training and installation of AIRS-AFS. (2) Implementation of RCRIS on LMF or PC, data clean-up, and support. (3) Implementation of GIS communication lines. (4) Transmitting between EPA/DEQ on CASE-developed strategy for cross-media state data management. 77 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region X, Seattle Washington Phase 1 Key Regional Participants: Clark Gaulding, Director, Management Division Jim Peterson, Chief, Information Mgmt Branch State Contacts: Data Bases Involved: Jim Griffith CDS, PCS, GIGS, STORET, AIRS (AQS andAFS), RCRIS, GIS, FRDS, TRI (SARA TITLE III) and UST/LUST Major Accomplishments in 1988-1989: (1) Senior Managers from DOE and EPA-Region IX held a joint retreat. Data manage- ment issues were discussed as major topics. (2) Improvements to communications network allowing for diversified access and input/ output capabilities. (3) Implementation of pre-RCRIS and coordination on hardware/software acquisition and policy decisions. (4) Increase in the use of STORET by various divisions in the state. (5) Training, and coordination on AIRS-AQS. (6) Assistance in access to SARA TITLE III data base. (7) Assistance in LIST and LUST systems utilization. Next Steps for Washington in 1990: (1) Researching communication methods for utilizing STORET graphics interface. (2) Implementation of RCRIS on LMF or PC, data clean-up, and support. (3) Implementation of direct AIRS-AQS and AIRS-AFS user. 78 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region X, Seattle Idaho Phase 1 Key Regional Participants: Clark Gaulding, Director, Management Division Jim Peterson, Chief, Information Mangement Branch State Contacts: Data Bases Involved: Steve Hill, Information Management Chris Johnson, Air Quality Mike Seals, Hazardous Material Renae Hardy, Water Quality CDS, PCS, GICS, STORET, AIRS (AQS andAFS), RCRIS, FRDS Major Accomplishments in 1988-1989: (1) Issued a grant to Air Quality for communication hardware/software. (2) Analysis of an overall DEQ Hardware/Software plan for EPA systems. (3) Analysis of relocation and short/long term communications needs. (4) Pre-RCRIS training and coordination. (5) Resolved data integrity issues, and cleaned up invalid data in FRDS. Next Steps for Idaho in 1990: (1) High-speed link to Air Quality for accessing AIRS-AQS and AIRS-AFS. (2) Implementation of RCRIS on LMF or PC, data clean-up, and support. (3) Installation of LAN equipment and high speed access for Hazardous Material, Air Quality, and Water Quality. (4) Inter-connection of local EPA and State access. (5) Overall modification to communications strategy after proposed relocation. 79 ------- LEGEND: 1987 Selected States 1988 Selected States 1989 Selected States Region: State: Program Phase: Region X, Seattle Alaska Phase 1 Key Regional Participants: Clark Gaulding, Director, Management Division Jim Peterson, Chief, Information Mgmt Branch State Contacts: Data Bases Involved: Steve Torok, EPA-Juneau office Susan Super, RCRA Manager PCS, GIGS, STORET, AIRS (AQS and AFS), RCRIS and FRDS Major Accomplishments in 1988-1989: (1) Pre-RCRIS training, coordination, and implementation guidelines. (2) Specialized training and support in specific areas. Next Steps for Alaska in 1990: (1) Training in various areas to begin using EPA systems. (2) Implementation of RCRIS on PC, data clean-up, and support. (3) Installation of high-speed line for access to EPA systems. (4) Transmitting between EPA/DEQ on CASE-developed strategy for cross-media state data management. 80 ------- III. DATA INTEGRATION An important step in the integration process at EPA continues to be the use of Geographic Information System (GIS) as a tool to support management decision-making related to environmental programs and concerns. To date most of the Agency's use of GIS has focused on identification and prioritization of environmental problems and trends. Through GIS, EPA and state programs can bring together information from various programs as well as from various media, to form a much more accurate and complete picture of a geographic area which previously would not have been possible. This cross-media/cross programmatic sharing of data provides a firmer foundation for current and future State/EPA programs. Examples of GIS use includes a Results/Risk Analysis System which utilizes GIS to target regulatory activities based on environmental risks and to determine if programs are having an impact on environmental quality. Additionally, GIS is being used to support the development of decision support tools such as prioritization applications to determine cleanup efforts now and in the future. This chapter describes in more detail EPA Region's GIS initiatives with State environmental agencies. DATA INTEGRATION PROGRAM The Data Integration Program has three components: Regional Data Integration - The Agency is providing a standard "Geographic Information System" (GIS) to each EPA region to perform geo-based analysis. EPA's Headquarters, seven regional offices, three laboratories, and three other programs established GIS organizations. The balance of regional offices will be completed in the near future. Technology and Data Management - The Office of Information Resources Management (OIRM), the National Data Processing Division (NDPD), and the Office of Research and Development (ORD) are supporting the implementation of GIS Technology, as well as developing standards, guidelines, and policies that will encourage the evolution of tools to provide data and multi-media integration between states and EPA programs. Technology Transfer- OIRM, NDPD, and ORD are the main focal points in assisting regions, and through them, the states, in planning, training, staff development, and providing technology exchange, data exchange/data sharing as well as pursuing specific, indepth applications development in support of geo-based analysis. The State/EPA Data Management Program continues to show that both EPA and States gain significant benefits in effectiveness and efficiency from cooperative, integrated data management. The experience to date makes it very clear for the need to be consistent and to enter into long term efforts that institutionalize the capabilities and relationships which are essential to effective State/EPA data management. 81 ------- Region: Region I Project: Cape Cod Aquifer Management Project (CCAMP), Massachusetts Key Participants: Lee Steppacher, Ground Water Protection; Michael MacDougall, Information Management, Region I State Contacts: George Zoto, Massachusetts Department of Environmental Quality Data Bases: CERCLIS, HWDMS Major Accomplishments: 1 .Use of GIS to identify necessary data sets including those areas where additional data gathering was appropriate and collection of new data. Perform quality control/ quality assurance procedures on the acquired data sets for Cape Cod Aquifer Management Project (CCAMP). Base maps were generated from an assemblage of digital data including: primary transportation routes, town boundaries, well locations, aggregated land use (commercial, residential), water-table contours and groundwater flow lines. 2. GIS was used in CCAMP to determine new sites for public wells in the towns of Barnstable and Eastham; two possible well sites were identified. 3. GIS was used to help local officials predict which Underground Storage Tanks (UST) pose the greatest risk to public wells. 4. Use of GIS as a planning tool for the development of risk scenarios by the Cape Cod Planning and Economic Development Commission . 5. The GIS application demonstrated the utility of GIS in assisting officials to prioritize management of UST risks and potential hazards. 6. The assimilation of dispersed and non standardized environmental data from numerous agencies into a uniform readily, accessible current data base. Next Steps: 1. Development of a data base including standards for an extensive quality assurance/ quality control program. 2. Demonstration of the utility of using GIS for developing Wellhead Protection plans for an increased understanding of relevant issues. 82 ------- Region: Region III Project: Ground Water Protection, New Castle County, Delaware Key Participants: Ava Nelson Zandi, Stuart Kerzner, Ed Kratz, and David West, Region III Data Bases: CERCLIS, HWDMS Major Accomplishments: 1. Dramatically improved the productivity and capability of the Region for advanced GIS applications and their understanding and assessing the scope complexity and nature of environmental problems. 2. Assisted Delaware and New Castle County develop and implement Wellhead Protection Programs and satisfied a Strategic Planning and Management objective in the process. 3. Promoted a truly cross-programatic, multi-media coordination effort between Agencies, Regions, Programs and State and local government on environmental issues concerning ground wate and its vulnerability. 4. Enabled EPA to provide and maintain a technical assistance vehicle for states/locals in a program where Federal resources are limited. 5. Successfully demonstrated GIS techniques and procedures which may be applied to other programs in the Region and State. Next Steps: 1. Based upon the successful experience with these projects, other program offices are committing their resources to GIS projects for the next fiscal year. 2. Begin a series of Federal/State/local cooperative initiatives based on the cross-media analytical capabilities which GIS offers. 83 ------- Region: Region III Project: Chesapeake Bay Program (CBP) Key Participants: Charles Spooner and Lowell Bahner, Chesapeake Bay Program. Major Accomplishments: 1. In 1987 ARC/INFO replaced MOSS as the CBP's GIS software. 2. GIS has been incorporated as a useful tool in the CBP to support the following ongoing activities: a. GIS will assist the CBP in assessment through watershed modeling. GIS has been examined in the CBP to see how it may be used to identify areas for best management practices (BMP's). As a demonstration project CBP has used GIS to map land use and stream segments in the Baltimore area from USGS land use/land cover files for BMP determination. b. The distributions of water quality indicators and the habitats of living resources are mapped to identify the impacts of water quality on habitats for L.R. restoration purposes. c. Water Quality Monitoring Data from the Bay and tributary monitoring programs are converted to a common format for analysis by the GIS and for documentation and quality control/ assurance activities. Next Steps: 1. Use of.GIS to combine output from water quality and land use models with other data layers, such as living resources to monitor the restoration progress. 84 ------- Region: Region IV Project: Environmental Priorities Initiative State: Georgia Key Participants: George Collins and Henry Strickland, Office of Integrated Environmental Analysis, Region IV State Contacts: Ted Jackson, Georgia State Department of the Environment Data Bases: CERCLIS, HWDMS, DRASTIC Major Accomplishments: 1. Searching, collecting, coordinating, transferring, and reformatting several state and regional geographic based data formats into the GIS. 2. This project was instrumental in developing a Results/Risk Analysis and Management System (RAMS) to identify, prioritize, track, and evaluate environmental problems and risks. 3. The GIS allows Region IV to be proactive, not reactive to a state's queries in identifying and prioritizing environmental problems. 4. Supports the appoach of coordinating region wide data bases and geographic information to assist states in managing environmental programs. Next Steps: 1. Implement a quality assurance, quality control program for technology transfer between the State and Region. 85 ------- Region: Region V Key Projects: The commitment to establish GIS in Region V was based in the following four proposals: 1. Ashtabula Harbor GIS: 2. Lower Green Bay Ground Water GIS Study 3. Region V Groundwater Study 4. Bottomland Hardwoods GIS Key Participants: Noel Kohl, John Anagnost, Barry Bolka, Barry Manne, Barry Melville , and John Schneider, Geographic Information Systems Major Accomplishments: 1. Region V received GIS software and a platform in February, 1989. 2. Hardcopy map outputs representing Clean Water Act, Section 304 (I) were generated to support the Region's Water Program. Next Steps: 1. Use of GIS as a tool to support the toxics mass balance study for the Lower Green Bay. 2. Use of GIS technology to support the Wetlands Advanced Identification (ADID) Program. 86 ------- Region: Region VII Project: Non-Point Source Pollution Analysis State: Kansas Key Participants: Walt Foster and Vickie Hale, Environmental Review Branch, Tom Lorez, Water Compliance Branch, Region VII. Bob Humell, U.S. Soil Conservation Service. State Contacts: Vic Robbins, Kansas Department of Health and Environment and Tom Lowe, Kansas Water Board. Major Accomplishments: 1. Demonstrate the ability of a Geographic Information System (GIS) to incorporate remote sensing for an analysis of non-point source (NPS) pollution for the 8000 acre Cedar Creek Watershed. 2. The use of a GIS to generate inputs to an agriculture NPS data model and to map model outputs. 3. GIS provided a rapid and repeatable means for generating various scenarios involving different land management practices to minimize NPS pollution Next Steps: 1. Establish a quality assurance, quality control program for inputs to the non-point source data model. 2. Apply GIS non-point source data model process to the entire state. 87 ------- Region: Region VIII Project: Clark Fork River National Priority List Site, Montana Key Participants: Mason Hewitt EMSL-Las Vegas and Bob Fox, Region VIII State Contacts: Jim Hill, Montana Department of Health and Environmental Services. Data Bases: CERCLIS Major Accomplishments: 1. Educating and assisting the Montana State Office in Geographic Information Systems (GIS) technology and how it can be applied to a Superfund site evaluation. 2. Demonstrate the concept of multidisciplinary teams from Montana as well as the Region for a successful GIS project. 3. Combine GIS with remote sensing technology to assist with the characterization of the entire Clark Fork River Basin. 4. Provide quality assurance, quality control (QA/QC) procedures on the many data layers or maps being added by means of electronic transfer, digitizing, imagary analysis, and data entry. Next Steps: 1. Show the use of GIS as a powerful tool to augment the remedial investigation feasibility study (RI/FS) process for Superfund Priority Sites. 2. Implement a training and user support program for the states using GIS. 88 ------- Region: Region IX Project: San Gabriel National Priority List Site, California Key Participants: Mason Hewitt, EMSL-Las Vegas, Niel Ziemba and Heather Stone, Region IX Data Bases: CERCLIS Major Accomplishments: 1. Demonstrated the value of a Geographic Information System (GIS) to investigate, monitor, and regulate environmental problems at a large superfund site. 2. Prepared aquifer data for input to a groundwater flow model to determine flow pathline from contaminant sink to potential source. 3. Developed preliminary guidelines for quality assurance research for GIS. 4. Prepared technology transfer procedures between the site, state, and region. Next Steps: 1. Design and implement a detailed database for three-dimensional groundwater modeling. 2. Use the GIS database with a management information system to track cleanup efforts at superfund sites. 89 ------- Region: Region X Project: Commencement Bay National Priority List (NPL) Site, Tacoma, Washington Key Participants: Mason Hewitt and Richard Dulaney, EMSL-Las Vegas and Ray Peterson and Michael Stoner, Region X. Data Bases: CERCLIS, Knowledgeman Major Accomplishments: 1. Show that GIS technology can help Federal, State, and local Governments investigate,identify, and analyze environmental problems associated with NPL sites. 2. Demonstrate the use of GIS to determine potential sources of pollution from drainage flows. 3. Develop fundamental GIS techniques through interactive query and spatial overlays for analysis in a remedial investigation and feasibility study (RI/FS) of a Superfund site. Next Steps: 1. Implement GIS technology over the entire life cycle of the cleanup operation. 2. Evaluate the use of an interactive GIS to benefit the site officer in analyzing the profusion of data to arrive at sound and informative decisions 90 ------- Region: Region X Project: Oregon Clean Water Strategy Key Participants: Ray Peterson,Region X, Denis White ERL-Corvallis, Kim Devonald, OPPE/ERB State Contacts: Neil Mullane, Andy Schaedel, and Nancy Lillquist, Oregon Department of Enironmental Quality (DEO), and Scott Smith, Oregon Department of Energy. Data Bases Involved: STORET, PCS, FINDS, HWDMS, CERCLIS Major Accomplishments: 1. Demonstrate the usefulness of Geographic Information Systems (GIS) as a tool in developing statewide water program planning and management. 2. Coordinating and collecting of relevant information to support a State's Clean Water Strategy. 3. Development of a methodology to prioritize water bodies for further investigation and subsequent action. Next Steps: 1. Support connectivity between the regional office and Oregon DEQ. 2. Develop training and user support programs. 3. Implement a quality assurance, quality control program for data transfer. 4. Design and program an update procedure for the GIS and its databases. 91 ------- IV. NEXT STEPS During FY 1988 and 1989, the Agency committed to a long term program to institutionalize the State/EPA Data Management program. The Agency has implemented and expanded Phase II of the program. The key components of this phase are Regional Data Integration Capacity, Technology and Data Management,and Technology Transfer will continue to be supported by the Agency. EPA will seek to improve training and technical assistance to assist States in addressing environmental problems through improved data sharing methods and create ways to share that experience. The State/EPA Data Management Program will continue to provide support in coordinating the implementation of new information systems for State use including the RCRA Information System and Aerometric Information Retrieval System. As the agency meets the challanges of providing the public, state and local governments with new environmental data in computerized format, the State/EPA Data Management program provides the framework and support to ensure Agency-wide success. The program has demonstrated that both EPA and States gain many benefits in a shared goal of improving enviromental data management. Our biggest task are making tough choices to meet our goals of protecting human health and the environment. EPA is dedicated to meeting these challanges. 93 ------- |