lindsaypoirier
commented
4 years ago Response from EPA below:
Learned that we can filter based on the PGM_SYS_ACRNMS field to strings containing SEMS. This will include both NPL and Non-NPL Superfund Sites. If we want only NPL, we can further filter INTEREST_TYPES to SUPERFUND NPL.
Hi Lindsay,
I believe Superfund sites are captured in the list below, specifically contaminated and potentially contaminated sites. It is likely that within a system like SEMS, Superfund's IT system, they are tracking these attributes about the location and pass it along to FRS on our regular refresh schedule. Although those types are not exclusive to SEMS or any particular EPA system, as other datasets also share those particular attributes.
To illustrate, I recommend using FRS EZ Query and using those terms to filter on FRS data: https://www.epa.gov/frs/frs-ez-query There are a few choices for report type, try using "EPA FRS Facility Information with Program Identifiers": https://ofmpub.epa.gov/frs_public2/ez_frs_column.list?table_name=D_EF_FAC.V_PUB_FRS_FACILITY_SITE_GEOPGM Hit the "Check All" boxes at the top, then plug in one of the values from your list into the row labeled "SITE_TYPE_NAME".
This is a pretty good way to slice FRS data, albeit in a tool that sorely needs updating. You can export the results or view them in browser. The key is to recognize the program system acronym (PGM_SYS_ACRN) and which system it's associated with. Those are the different environmental systems that FRS has in the system and each record represents a "facility" (really they are "environmental interests"). You'll see there's a lot of different systems that collect some form of that attribute and pass that information along to FRS.
I hope this is helpful. Please let me know if you have any questions or follow up.
Matthew Kelly Data Management Services Division Office of Mission Support/OIM U.S. EPA WJC West 6416T 202-566-1597
-----Original Message----- From: drupal_admin@epa.gov drupal_admin@epa.gov On Behalf Of EPA Sent: Tuesday, March 31, 2020 11:26 PM To: Kelly, Matthew Kelly.Matthew@epa.gov Subject: Form submission from: Facility Registry Service (FRS) Contact Us About FRS form
Submitted on 03/31/2020 11:26PM Submitted values are:
Name: Lindsay Poirier Email Address: lnpoirier@ucdavis.edu Comments: Hello FRS team,
My name is Lindsay Poirier, and I'm an Assistant Professor of Data Studies at the University of California Davis. I have a question regarding how the Site_Type_Name is coded in the FRS Registry. According to the data dictionary, allowable values include:
Stationary Contamination Addressed Contaminated Site Potentially Contaminated Site Monitoring Station Brownfields Site Water System Pipeline Portable
Are superfund sites represented in this list? Would they be considered the same as "contaminated sites," and if so, would "potentially contaminated sites" be included? Further, I'd love to know more about the logic behind how these site types are classified. Would you be able to provide more detail about this?
Lindsay
We're currently using the FRS Registry dataset as a source for the proximity map. In that dataset there is a variable called Site Type Name, which has the following assignable values:
Contamination Addressed Contaminated Site Potentially Contaminated Site Monitoring Station Brownfields Site Water System Pipeline Portable
See data dictionary here: https://www.epa.gov/sites/production/files/2015-09/documents/frs_data_dictionary.pdf
We need to figure out whether contaminated sites is the same as superfund sites.
On 3/31/2020 LP sent email to FRS team asking about relationship between contaminated sites and superfund sites and the logic behind the assignable values in the Site_Type_Name.
LP will follow up in one week if she hasn't heard anything.