UNITED STATES ENVIRONMENTAL PROTECTION WASHINGTON, D.C, 20460 OFFICE OF SOUD WASTE AN9 EMERGENCY RESPOND OSWER 9320.1-18 February 4, 2005 MEMORANDUM SUBJECT: Superfund Site Progress Profiles - Status Report FROM: Michael B. Cook, Director /s/ Office of Superfund Remediation and Technology Innovation TO: Superfund National Policy Managers, Regions 1-10 Purpose: The purpose of this memorandum is to announce that the Superfund Site Progress Profiles will be available to the public via the internet on February 11, 2005. We very much appreciate the assistance of your staff during the extended development of these profiles. The profiles will provide a nationwide web-based standard for communicating cleanup status at NPL and Superfund Alternative Sites using CERCLIS data. The web address to search for a specific site profile will be http;//wvm,epa;gQ^ We anticipate that the profile pages will be accessed over 18,000 times each month. To maintain this as a consistent source of accurate data your ongoing support is necessary. Implementation; The profiles will be automatically updated on a monthly basis. Please ensure that CERCLIS is kept up-to-date with respect to the information being displayed through the profiles. Attached are the profile Data Element Dictionary and Data Element Mapping files to assist your efforts to maintain up-to-date and accurate data in CERCLIS. The site profiles provide a direct link to regionally maintained Site Fact Sheets (also known as NPL PADs). These must also be updated concurrently with CERCLIS to be consistent with the profiles and reflect current site activities, cleanup status, and site contacts. In addition, any reference to planned funding requests must be removed from these Fact Sheets. Some Fact Sheets for active (non-CC) NPL sites have not been updated since 2002. HQ will perform regular spot-check audits on a random number of sites to determine if profiles are up tojiaje and .the Site. . ------- Fact Sheets provide information consistent with that being displayed by the profiles. I ask you to continually keep CERCLIS and all Site Fact Sheets up to date. OSRTIHQ will begin its audit process on the first of March and continue the audits on a regular basis. Results of the audits in your Region will be provided to you. Conclusion; Finally, I wish to thank all Regional staff who assisted in the development of the Superfund Site Progress Profiles. These profiles are an important communication tool for the, program and your efforts greatly contributed to a well-designed and useful product. Questions related to this should be directed to Melanie Hoff, (703) 603-8808. Her email is hoff.melanie(ft>.epa.gov. cc: Thomas Dunne, OSWER Barry Breen, OSWER Debbie Deitrich, OEM Matt Hale, OSW Linda Garczynski, OBCR Marsha Minter, IPCO Ed Chu, Land Revitalization Staff JimWoolford,FFRRO Dave Kling, FFEO Susan Bromm, OSRE Jim Drummond, OGC Charles Openchowski, OGC Earl Salo, OGC Scott Sherman, OGC Eric Steinhaus, Superfund Lead Region Coordinator, US EPA Region 8 Joanna Gibson, OSRTI Documents Coordinator ------- Site Information/Location Data: Data Element Label Number 3 2 5 90 7 74 8 29 Data Element Label Site Name Site EPA ID EPA Region Site Address County U.S. Congressional District Population within 1-mile* Technical Assistance Grant Accessing the Data in CERCLJS Views>Site Information>Site Location Views>Site Information>Site Location Views>Site Information>Site Location Views>Site Information>Site Location Views>Site Information>Site Location Views>Site Information>Site Location N/A Views>Project Management>Project Schedule CERCLIS Table SITE.site_name SITE.epa_id SITE.rregion code SITE.site_strt_adrsl SITE.site cnty code SITE.cngrsnl_dstrct_ code N/A ACTION.rat code = 'TG' Definition or URL associated with Data Label? No Glossary Link Link to Regional Homepage: http://www.epa.gov/region9/ http://www.epa.gov/region 9/cleanup/ No No No No Glossary Link Options Available for Display N/A N/A 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 N/A N/A N/A 0-100 101-1,000 1,001-5,000 5,001-10,000 50,000+ Will only be displayed if TAG has been awarded *Population within 1 mile is stored in an independent database. For fiirther information on how population within 1 -mile is calculated please see Attachment A. ------- Federal Facility Data: Data Element Label Number 9 64 66 Data Element Label Federal Facility Designation BRAC Designation Advisory Board Accessing the Data in CERCLJS Views>Site Information>Site Status and Description/Operable Units>Federal Facility Indicator Views>Federal Facilities>BRAC Site Views>Project Management>Project Schedule CERCLIS Table SITE.rfed_fclty_code = 'Y' SITE.rbrac_code or ref_program_priority init.rppt_code = 'FT' Action.rat code = ('BW, 'BX') Definition or URL associated with Data Label? No Glossary Link Glossary Link Options Available for Display -'Null if site is not a Federal Facility -'This is a Federal Facility' -'Null' if site is not a BRAC -'This is a Federal Facility and is a Base Realignment and Closure (BRAC) site' Displays when site currently has an active (action has no completion date) 'Restoration Advisory Board' or a 'Site Specific Advisory Board' ------- Data Element Label Number 93 80 28 Data Element Label Cleanup Progress Summary "Guys" Cleanup Activities Designation NPL Status Accessing the Data in CERCLJS N/A Views>Project Nlanagement>Project Schedule Views>Site Information>Site Status and Description/Operable Units>NPL Status \ CERCUS Table N/A ACTION.rat_oode in CBB',tBF',1IP','LV','LYyOF,'PD',PJ ','RA','RL','RV',TA') AND action.act_actl_strt_date is not null SITE.mpl status_code Definition or URL associated with Data Label? No No Glossary Link Options Available for Display See Page 5 -'Physical cleanup activities have started' -'Physical cleanup activities have been completed' -Final - "This site is on the NPL and is known as Final NPL.' -Proposed - 'This site is currently proposed to be added to the NPL and is known as a Proposed to the NPL site.' -Deleted - "This site is cleaned up, is no longer a threat to human health, has been deleted from the NPL, and is known as a Deleted NPL site. Cleanup Progress Summary Data: Cleanup Progress Summary Data Continued: ------- Data Element Label Number 30 Data Element Label Responsible Party Designation Accessing the Data in CERCIIS Views>Project Management>Project Schedule CERCLIS Table (((Action.rat code = any CAT', 'AS', 'AY1, 'CM, 'CO1, 'CQ', DA', "ED', EE', EV, 'FE', TM1, TS', 'GIvT, 'GR', 'GS', HA', HG', 'IP', 'JF', Tf, T.R', LV, 'LW, 1.X', "LV, MZ', ND', -NH1, -NT, 'OF', 'OM1, PD', 'RA', 'RC, -RD', fa', -RL', RO', "RS', TIV', 'SA', TA1, TO', TS', 'WP') and action.ralt code = any (MR1, TS', 'RP', 'SR')) or aotion.rat code = any ("BB1, BD', BE', BF', ME', -NA', NK', TJ1)) and action.aot_actl_cmpltn_date is not null Definition or URL associated with Data Label? Glossary Link Options Available for Display -'Potentially Responsible Parties are involved in the cleanup -Not displayed if there is no PRP involvement ------- Cleanup Progress Summary "Guys" Study *;. Study Underway Remedy Selected Design Underway Construction Underway Construction Complete / Deleted from / the NPL O Earty Action initiated/Completed ------- Cleanup Impact Summary Data: Data Element Label Number 12 77a 77b 78 Data Element Label Human Exposure Metric Solid Waste Volume Liquid Waste Volume Population Relocation Accessing the Data in CERCLJS Views>Program Management>Environmental Indicators>Human Exposures tab Views>Program Management>Environmental Indicators>Ground Water Releases tab Views>Program Management>Environmental Indicators>Cleanup Volumes tab Views>Program Management>Environmental Indicators>Populations Affected tab CERCLIS Table ENVIRONMENTALJNDI CATORS.rei code where ENVIRONMENTAL_INDI CATORS.reic_code = 'HE'. EI_CLEANUP.ec_standard amount where rmedia code = ('DB', 'SB', 'SD', 'SF, 'SL', 'SO', 'ST, ) EI_CLEANUP.ec_standard amount where rmedia code = ('LWyGWYSWYLE') EI_POPULATION_PROTE CTED.epp_affected_amoun t where rpop rprotected type code = 'PRL' Definition or URL associated with Data Label? Glossary Link Glossary Link Glossary Link None Options Available for Display -Current human exposures at this site are under control -Current human exposures at this site are not under control -At this site, EPA is still working to determine if human exposures are under control. Only displayed if a volume is present in CERCLIS Only displayed if a volume is present in CERCLIS Only displayed if Population Relocated data is present in CERCLIS ------- Cleanup Impact Summary Data Continued: Data Element Label Number 79 Data Element Label Alternative Drinking Water Supplied Accessing the Data in CERCUS Views>Program Management>Environmental Indicators>Populations Affected tab CERCLIS Table EI_POPULATION_PROTE CTED.epp_affected_amoun t where rpop rprotected type code = 'ADW Definition or URL associated with Data Label? None Options Available for Display Only displayed if Alternative Drinking Water data is present in CERCLIS ------- Contamination Data: Data Element Label Number 17 Data Element Label Contaminated Media Accessing the Data in CERCLIS Views>Remedy Selection>Selected Remedy>Select an Action>Select Remedy button>Select Add/Edit Media button CERCLIS Table REF_MEDIA.rmedia_desc Definition or URL associated with Data Label? Glossary Link Options Available for Display Air, Groundwater, Debris, Leachate, Liquid Waste, Other, Residuals, Sediment, Sludge, Soil, Surface Water, Subsurface Soil, Surface Soil, Surface Water ------- 18 Types of Contaminants Views>Remedy Selection>Site Characterization>Select an Action>Select a Media REF_CONTAMINANT_G ROUP.rcg_name Glossary Link Base Neutral Acids, PAH, Dioxins/Dibenzofurans, Inorganicss, Metals, Nitrate/Nitrite, Not Provided, Organics, VOC, Pesticides, Petroleum Hydrocarbon, Carcinogens, Cement Kiln Dust, Dissolved Solids, Flammables, Radioactive, Leachate, Nitroaromatics, Non-Carcinogens, Oil & Grease, Organic & Inorganic Liquid Sludge, Oxidizers, Petroleum Napthas, Reactives, Unknown Liq Waste, PCBs, No Group Identified, Acids, Data Not Available 10 ------- Exposure Module Data: Data Element Label Number 12 22 Data Element Label Human Exposure Metric Institutional Control Status Accessing the Data in CERCLIS Views>Program Management>Environmental Indicators>Human Exposure tab N/A CERCLIS Table ENVIRONMENTALJNDI CATORS.rei code where ENVIRONMENTALJNDI CATORS.reic_code = 'HE' N/A Definition or URL associated with Data Label? No Glossary Link Options Available for Display -Current human exposures at this site are under control -Current human exposures at this site are not under control -At this site, EPA is still working to determine if human exposures are under control. Institutional control data is currently being suppressed until ICTS database is ready for release. 11 ------- Major Site Cleanup Milestones: Data Element Label 32 - "Guy" graphics will be visible when completion of cleanup milestones has occurred at the site. Milestones and logic for calculating milestone completions include: 1st Cleanup Action Completed - "Guy" is displayed based on the earliest completion of one of the following actions: Removal; Remedial Action; FF RA; PRP Removal; PRP Emergency Removal; PRP RA; and FF Removal. Proposed to the NPL - "Guy" is displayed based on completion of the following action: 'Proposed to NPL' (action.rat_code = 'NP') Listed as Final on the NPL - "Guy" is displayed based upon the completion of the following action: 'Final Listing on NPL' (action.rat_code = 'NF') Final Remedy Selected - "Guy" is displayed when the Final Remedy Determination Trigger Action Flag = 'Yes' (frd_trigger_action_flag) Construction Completion - 'Guy' is displayed when the Site Construction Completion Concurrence date is populated (site.cc_concurrence_date is not null) Deleted from the NPL - "Guy" is displayed based upon the completion of the following action: 'Deletion from NPL' (action.rat_code = 'ND') -See Page 12 for Major Site Cleanup Milestone "Guy" display options. 12 ------- Major Site Cleanup Milestone "Guys" 1s:; Cleanup Action initiated Proposed to the NPL Listed as Final on the NPL Final Remedy Selected Construction Complete Deleted from the NPL 14 ------- Cleanup Activities at this Site: Data Element Label 34 - The "Cleanup Activities at this Site" module displays complete or underway cleanup activity dates by Operable Unit Dates that are displayed on this chart are the most current underway or start dates (e.g. if OU 1 at a site has two removals completed, the most recent completion date will be displayed). The 5 Cleanup Activities are comprised of the following actions: Removal - PRP Removal, FF Removal, Initial Remedial Measure, PRP Emergency Removal, Removal Study and Remedy Selection - Remedial Investigation, Feasibility Study, Combined RI/FS, PRP Remedial Investigation, PRP Feasibility Study, PRP RI/FS, FF Remedial Investigation, FF Feasibility Study, FF RI/FS, Record of Decision Remedy Design - PRP Remedial Design, FF Remedial Design, Remedial Design Remedy Construction - Remedial Action, PRP Remedial Action, FF Remedial Action Post Construction - Long Term Response Action, Operations and Maintenance, PRP LR, FF LR 15 ------- Land Reuse Module: Data Element Label Number 47 Data Element Label Restricted Use Accessing the Data in CERCLIS Views>Project Management>Proj ect Schedule>Select Record of Decision>Select SCAP button> Acres at site with Land Ready for Restricted Use CERCLIS Table SITE, SITE_LAND_REUSE where slr_current_flag = 'V AND sir acres ready restricted > 0 AND (site.rfed_fclty_code o 'V or site.rfed_fclty_code is null) AND ( (site.rnpl status code in (PVF.'D'.'R'.'W)) OR (site.rnpl_status_code = "N' and exists (select "x! from site_program_priority_init sppi where sppi.site_id = site.site id and sppi.rppt code = 'NE')) OR (site.rnpl_status_code=lN' and exists (select 'x1 from action where action. site_id = site.site id and action. rat code in ('RV,'BB') and action. ract critical flag code = NT and action.act actl cmpltn date is not null) Definition or URL associated with Data Label? None Options Available for Display Acres 16 ------- Land Reuse Data Continued: Data Element Label Number 48 Data Element Label Unrestricted Use Accessing the Data in CERCLIS Views>Project Management>Project Schedule>Select Record of Decision>Select SCAP button> Acres at site with Land Ready for Unrestricted Use CERCLIS Table SITE, SITE_LAND_REUSE where site.site_id = site land_reuse.site id AND slr_current_flag = 'Y AND sir acres ready unrestricted > OAND (site.rfed_fclty_code o 'V or site.rfed_fclty_code is null) AND ( (site.rnpl status code in (TVF.'DVR'.W)) OR (site.rnpl_status_code = tf and exists (select 'x1 from site_program_priority_init sppi where sppi.site id = site.site id and sppi.rppt_code = 'NE')) OR (site.mpl_status code="N' and exists (select V from action where action.site_id = site.site id and action.rat code in ('RV,'BB') and action.ract critical flag code = Wand action.act_actl cmpltn_date is not null) Definition or URL associated with Data Label? None Options Available for Display Acres 17 ------- Land Reuse Module Continued: Data Element Label Number 49 Data Element Label Total Use Accessing the Data in CERCLIS Views>Project Management>Proj ect Schedule>Select Record of Decision>Select SCAP button>Total Acres of Site with Land Ready for Reuse CERCLIS Table SITE, SITE_LAND_REUSE where sir current flag = "V AND NVL(slr_acres_ready_restricte d,0)+NVL(slr_acres_ready_unr estricted,0) > 0 AND (site.rfed_fclty_code o 'Y1 or site.rfed_fclty_code is null) AND( (site.rnpl status code in (P'.'F.'D'.'R'.W)) OR (site.mpl status code = "N* and exists (select 'x' from site_program_priority_init sppi where sppi. site id = site. site id and sppi.rppt_code = 'NE')) OR (site.rnpl_status_code=lN' and exists (select 'x1 from action where action.site_id = site.site id and action. rat code in ('RVYBB') and action.ract critical flag code = Wand action.act act! cmpltn_date is not null) Definition or URL associated with Data Label? None Options Available for Display Acres - 18 ------- Post-Construction Data: Data Element Label Number 51 52 53 Data Element Label Last five-year review at this site Remedy deemed protective? Next five-year review start date Accessing the Data in CERCIIS Views>Project Management>Project Schedule>Select Record of Decision>Select SCAP button>Click More button>Click Five- Year Review button Views>Project Management>Project Schedule>Five-Year Review action>Select SCAP button>Click More button>Protectiveness Statement tab>Protectiveness drop-down Views>Project Management>Project Schedule>Select Record of Decision>Select SCAP button>Click More button>Click Five- Year Review button CERCLIS Table ACTION.rat code in ('FEVVY')and action.act_actl cmpltn date is not null REF_FYR_PROTECTIVE NESS.rfyr_protectiveness d esc ACTION.rat code in ('FE'.'VY) and action.act_curr_pln strt dat e is not null Definition or URL associated with Data Label? None None None Options Available for Display Year '(YYYY)' If more than one Five- Year Review has been completed, displays most recent Five- Year Review -Not Protective -Protective -Protective in Short Term -Will be Protective Once Remedy is Complete -Undetermined (displayed when rfyr_protectiveness_des c is null) Year '(YYYY)' If there is more than one Five- Year Review Start Date lists the most recent without a complete date. GPRA Module Data: 19 ------- Data Element Label Number 57 58 Data Element Label Final Site Assessment Decision Final Remedy Selected Accessing the Data in CERCIIS Views>Site Status and Description/Operable Units Views>Project Management>Project Schedule>Select Record of Decision, ROD Amendment, or Action Memo>Double click on the Qualifier Column>Select 'R' Final Remedy Determination CERCLIS Table FAD_STATUS_HISTORY. fsh_decision = "V Use most recent fsh_decision_date FrNAL_REMEDY_Determi nation.frd trigger action fl ag = 'Y' Definition or URL associated with Data Label? GPRA Module contains definitions for each GPRA milestone GPRA Module contains definitions for each GPRA milestone Options Available for Display -'Yes' ^Site's non-NPL status desc -'No' + Site's non-NPL status desc -Not Applicable -Current human exposures at this site are under control. -EPA is working to ensure human exposures are under control. -At this site, EPA is still working to determine whether there are any human exposures to contaminants. GPRA Module Data Continued: Data Element Label Number Data Element Label Accessing the Data in CERCLIS CERCLIS Table Definition or URL associated with Data Label? Options Available for Display 20 ------- 59 60 Human Exposure Under Control Contaminated Groundwater Migration Views>Program Management>Environmental Indicators>Human Exposure tab Views>Program Management>Environmental Indicators>Groundwater Releases tab EN VIRONMENTAL JNDI . CATORS.rei_code = 'HE' and ENVIRONMENTALJNDI CATORS.reic code = 'Y' or 'N' or 'X'. ENVIRONMENTALJNDI CATORS.rei_code = 'GM and ENVIRONMENTALJNDI CATORS.reic_code = 'Y' or 'N' or 'D' or 'X' GPRA Module contains definitions for each GPRA milestone GPRA Module contains definitions for each GPRA milestone -Current human exposures at this site are under control. -EPA is working to ensure human exposures are under control. -At this site, EPA is still working to determine whether there are any human exposures to contaminants. -Contaminated Ground Water Migration at this site is under control. -EPA is working to ensure that contaminated ground water migration is under control. -At this site, EPA is still working whether contaminated ground water migration is under control. -Not a Groundwater Site. GPRA Module Data Continued: Data Element Label Number Data Element Label Accessing the Data in CERCLJS CERCLIS Table Definition or URL associated with Data Label? Options Available for Display 21 ------- 61 Construction Complete Views>Site Status and Description/Operable Units>Special Initiatives SITE.site cc concurrence date is not null GPRA Module contains definitions for each GPRA Milestone -Yes -No -Not Applicable 22 ------- Attachment A- Methodology Used to Estimate Population within 1-Mile Area Approximation Method The latitude, longitude, and area of each site were pulled from the WasteLAN database. Site boundary shape files were not available; therefore, the site boundary was represented by a circle with an equivalent site area centered around the site latitude/longitude. Using Arc View GIS 3.2, a circular buffer of 1-mile radius was created around the circular site boundary. Using 2000 Census Block data, all the census blocks were identified and the total population was calculated in each buffer area. Latitude/Longitude Method For sites that do not have site area data, a point (located at the site latitude/longitude) was used for the boundary. Using Arc View GIS 3.2, a circular buffer of 1-mile radius was created around the point Using 2000 Census Block data, all the census blocks were identified and the total population was calculated in each buffer area. Population Density Estimate Method For those sites in U.S. territories and protectorates (e.g., American Samoa, Guam, Virgin Islands) where Census Block data was not available, the population was estimated by determining the population density of the island on which the site is located and multiplying it by the buffer area. This simple method does not take into account density differences across the island or the presence of unpopulated areas (e.g, the ocean) within the buffer area. 23 ------- |