Selection of Columns for FRS EZ Query


STEP 2: Select TWO or more column(s) for your output by clicking on the square box next to the column name.
When you are finished selecting columns, click on the STEP 3: Enter Search Criteria
button at the bottom of this page.

Selection of Columns

* Selects ALL columns listed for output!
Count Function for *. DO NOT SELECT THE COLUMN LOCATED DIRECTLY ABOVE IF YOU SELECT THIS COLUMN! Counts the number of distinct records for the column above: You must select an additional column other than a group function! HELP on STATISTICS!
COUNT
PGM_SYS_ACRNM The abbreviated name that represents the name of an information management system for an environmental program (e.g., RCRAINFO, ICIS, TRI, CERCLIS, ACRES, RMP, EIS)
Count Function for PGM_SYS_ACRNM. DO NOT SELECT THE COLUMN LOCATED DIRECTLY ABOVE IF YOU SELECT THIS COLUMN! Counts the number of distinct records for the column above: You must select an additional column other than a group function! HELP on STATISTICS!
COUNT
PGM_SYS_ID The identification number, such as the permit number, assigned by an information management system that represents a facility site, waste site, operable unit, or other feature tracked by that Environmental Information System.
Count Function for PGM_SYS_ID. DO NOT SELECT THE COLUMN LOCATED DIRECTLY ABOVE IF YOU SELECT THIS COLUMN! Counts the number of distinct records for the column above: You must select an additional column other than a group function! HELP on STATISTICS!
COUNT
REGISTRY_ID The identification number assigned by the EPA Facility Registry System to uniquely identify a facility site.
Count Function for REGISTRY_ID. DO NOT SELECT THE COLUMN LOCATED DIRECTLY ABOVE IF YOU SELECT THIS COLUMN! Counts the number of distinct records for the column above: You must select an additional column other than a group function! HELP on STATISTICS!
COUNT
PRIMARY_NAME The public or commercial name of a facility site (that is., the full name that commonly appears on invoices, signs, or other business documents, or as assigned by the state when the name is ambiguous).
LOCATION_ADDRESS The address that describes the physical (geographic) location of the front door or main entrance of a facility site, including urban-style street address or rural address.
SUPPLEMENTAL_LOCATION The text that provides additional information about a place, including a building name with its secondary unit and number, an industrial park name, an installation name or descriptive text where no formal address is available.
CITY_NAME The name of the city, town, village or other locality, when identifiable, within whose boundaries (the majority of ) the facility site is located or the name of the city where the mail is delivered. The two are not always the same.
COUNTY_NAME The name of the U.S. county or county equivalent in which the facility site is physically located.
FIPS_CODE The code that represents the county or county equivalent and the state or state equivalent of the United States.
STATE_CODE The U.S. Postal Service abbreviation that represents the state or state equivalent for the U.S. and Canada.
STATE_NAME The name of a principal administrative subdivision of the United States, Canada, or Mexico.
COUNTRY_NAME The name that represents a primary geopolitical unit of the world. Default: USA
POSTAL_CODE The combination of the five-digit Zone Improvement Plan (ZIP) code and the four-digit extension code (if available) that represents the geographic segment that is a subunit of the ZIP Code, assigned by the U.S. Postal Service to a geographic location to facilitate mail delivery; or the postal zone specific to the country, other than the U.S., where the mail is delivered.
FEDERAL_FACILITY_CODE Code indicating whether or not the facility is the property of the Federal Government. Allowable Values: Y, for Yes, the facility is the property of the Federal Government. N, for No, the facility is not the property of the Federal Government.
FEDERAL_AGENCY_CODE The Federal Agency/Bureau code. The five character code consists of a letter followed by four numbers. There are four possible letters that can occupy the first character position: 'C' for Civilian Federal Agency; 'D' for Department of Defense; 'E' for Department of Energy; 'X' for Unknown. The second and third characters represent the agency code, while the fourth and fifth characters represent the bureau code.
TRIBAL_LAND_CODE Code indicating whether or not the facility site is located on tribal land.
TRIBAL_LAND_NAME The name of the Tribal Reservation, statistical area, or Public Domain Allotment. If the tribal entity has no land base, the name of the tribal entity is used as the Tribal Land Name. Examples: Colorado River Indian Reservation, Ponca Tribal Designated Statistical Area, Wampanoag Tribe of Gay Head (Aquinnah) of Massachusetts.
LEGISLATIVE_DIST_NUM The number that represents a Legislative District within a state.
HUC_CODE_8 The 8-digit hydrologic unit code (HUC) that represents a geographic area representing part or all of a surface drainage basin, a combination of drainage basins, or a distinct hydrologic feature.
HUC_CODE_12 The 12-digit hydrologic unit code (HUC) that represents a geographic area representing part or all of a surface drainage basin, a combination of drainage basins, or a distinct hydrologic feature.
EPA_REGION_CODE The code that represents an EPA Region.
FACILITY_TYPE_NAME The descriptive name for the type of facility.Allowable Values (example):Stationary Contamination Addressed Monitoring Site Contaminated SiteBrownfields Site Potentially Contaminated SiteWater SystemPortable Source
DATA_QUALITY_CODE A code assigned by the automated integration process to indicate whether the address data are missing, invalid, or non standard.
LAST_REPORTED_DATE The most recent date the corresponding data was reported to the Source of Data.
STD_NAME The primary name after a set of standardization rules are applied for comparison purposes. The rules include removing special characters and certain words (e.g., "/", "Inc.") and replacing abbreviated words with standardized equivalents (e.g., "Assoc" becomes "Association").
GEO_DERIVED_LOC_ADDRESS The location address after a set of standardization rules are applied for comparison purposes.
GEO_DERIVED_HOUSE_NUMBER The number assigned to a building or a land parcel along the street to identify location and to ensure accurate mail delivery.
GEO_DERIVED_STREET_NAME The name assigned to a street or road, not including other urban-style street address components.
GEO_DERIVED_BASE_NAME The name of the street or road, not including the prefix, suffix, or pre- or post- directional codes
GEO_DERIVED_PREFIX The code that represents the qualifier that precedes the street name in a street address.
GEO_DERIVED_SUFFIX The code that represents the qualifier that follows the street name in a street address.
GEO_DERIVED_STYPE_BEFORE The code that represents a street vector, i.e. the direction the street has taken from some arbitrary starting point that precedes the street name
GEO_DERIVED_AFTER The code that represents a street vector, i.e. the direction the street has taken from some arbitrary starting point that follows the street suffix.
GEO_DERIVED_POSTAL_CODE The standardized Postal Code returned by the standardization and parsing routines
GEO_DERIVED_CITY_NAME The city name after a set of standardization rules are applied for comparison purposes. The rules include removing special characters and buzz words (e.g., /, City of) and replacing abbreviated words with standardized equivalents (e.g., FT becomes FORT).
GEO_DERIVED_COUNTY_NAME The county name after a set of standardization rules are applied for comparison purposes. The rules include removing special characters and buzz words (e.g., /, County of) and replacing abbreviated words with standardized equivalents (e.g., FT becomes FORT).
GEO_DERIVED_STATE_CODE The standardized State Code returned by the standardization and parsing routines.
GEO_DERIVED_COUNTY_FIPS The standardized State County FIPS Code returned by the standardization and parsing routines.
GEO_DERIVED_COUNTRY The standardized Country Name returned by the standardization and parsing routines
GEO_DERIVED_FULL_ADDRESS The standardized complete address, including STD_LOC_ADDRESS, STD_CITY_NAME, STD_STATE_CODE, AND STD_POSTAL_CODE.
GEO_DERIVED_ADDR_TYPE The type of address given in the LOCATION_ADDRESS column (i.e., standard urban, PO Box).
LINK_MTHD The method used to determine the association or "linkage" of this environmental interest to a particular facility site (e.g., automated match, data steward).
LOCATION_DESCRIPTION A brief explanation of where the facility site is located, including navigational directions and/or more descriptive information about the location of the facility site.
CREATE_DATE A system-generated value that represents the calendar date and time the corresponding information was first posted to the database.
UPDATE_DATE A system-generated value that represents the most recent calendar date and time the corresponding information was updated in the database.
USER_ID A code that identifies the registered user of the system.
SENSITIVE_IND Indicates whether or not the associated data is enforcement sensitive.
USER_COMMENT Textual comments from analysts and data stewards regarding the creation of a facility site record or the establishment of a linkage.
PUBLIC_IND Indicates whether or not the associated data is accessible by the public on the Internet.
REFRESH_DATE The date the data was last extracted from the data source.
SMALL_BUS_IND Code indicating whether or not a business is requesting relief under EPA?s Small Business Policy, which applies to businesses having less than 100 employees.
ENV_JUSTICE_CODE The code that identifies the type of environmental justice concern affecting the facility or enforcement action.
STAND_ALONE_FLAG Indicates whether or not the facility is standalone (i.e., only one environmental interest is linked to the facility) or multimedia (more than one environmental interest is linked to the facility).Y means the facility is standalone, and N means the facility is not standalone.
SOURCE_OF_DATA The source of the associated data.