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_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
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
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.
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.
STATE_CODE The U.S. Postal Service abbreviation that represents the state or state equivalent for the U.S. and Canada.
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.
FIPS_CODE The code that represents the county or county equivalent and the state or state equivalent of the United States.
COUNTRY_NAME The name that represents a primary geopolitical unit of the world. Default: USA
OBJECTID A unique numeric identifier for each geometry in a layer.
SUB_ID The identification number for an operable unit or sub-unit of a facility site.
LATITUDE83 The measure of the angular distance on a meridian north or south of the equator standardized to NAD83 horizontal datum.
LONGITUDE83 The measure of the angular distance on a meridian east or west of the prime meridian standardized to NAD83 horizontal datum.
CONVEYOR Identification of the party that transmitted the associated latitude and longitude coordinates.
HDATUM_DESC The name that describes the reference datum used in determining latitude and longitude coordinates. Allowable Values: Value Meaning 001 NAD27 002 NAD83 003 WGS84
COLLECT_MTH_CODE The code that represents the method used to determine the latitude and longitude coordinates for a point on the earth.
COLLECT_DESC The text that describes the method used to determine the latitude and longitude coordinates for a point on the earth.
REF_POINT_CODE The code that represents the place for which geographic coordinates were established.
REF_POINT_DESC The name that identifies the place for which geographic coordinates were established.
SOURCE_CODE The code that represents the party responsible for providing the latitude and longitude coordinates.
SOURCE_DESC The name of the party responsible for providing the latitude and longitude coordinates.
SCALE The number that represents the proportional distance on the ground for one unit of measure on the map or photo. Remarks: Mandatory for all horizontal data collection methods except for methods using Global Positioning System (GPS).
ACCURACY_VALUE The measure of the accuracy (in meters) of the latitude and longitude coordinates.
ACCURACY_SCORE The accuracy score (in meters) derived as the accuracy value either supplied by the location metadata or calculated based on the collection method and then modified based on QA boundary checks.
TIMESTAMP A system-generated value that represents the calendar date and time the corresponding information was posted to the database.
DERIVED_CITY The spatially derived city name.
DERIVED_COUNTY The spatially derived county name.
DERIVED_ZIP The spatially derived ZIP Code.
DERIVED_STATE The spatially derived State Code.
DERIVED_FIPS The spatially derived FIPS code.
DERIVED_HUC The spatially derived 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.
DERIVED_WBD The spatially derived 12-digit Hydrologic Unit Code (HUC) from the Watershed Boundary Dataset (WBD) that represents a geographic area representing part or all of a surface drainage basin, a combination of drainage basins, or a distinct hydrologic feature.
DERIVED_CB_2010 The spatially derived 2010 Census Block Code, which represents the smallest entity for which the Census Bureau collects and tabulates decennial census information; bounded on all sides by visible and nonvisible features shown on Census Bureau maps.
DERIVED_CD_113 The number that represents the 113th Congressional District for a state within the United States.
US_MEXICO_BORDER_IND Based on the facility's spatial coordinate, a "Y" value indicates that the facility is within 100KM (62.5 Miles) of the US-Mexico border.
OZONE_8HR_1997_AREA_NAME The 8-hour Ozone (1997) non-attainment area name, spatially derived from the Air Green Book.
PB_2008_AREA_NAME The Lead 2008 non-attainment area name, spatially derived from the Air Green Book.
PM25_1997_AREA_NAME The Particulate Matter 2.5 (1997) non-attainment area name, spatially derived from the Air Green Book.
PM25_2006_AREA_NAME The Particulate Matter 2.5 (2006) non-attainment area name, spatially derived from the Air Green Book.
OZONE_8HR_2008_AREA_NAME The 8-hour Ozone (2008) non-attainment area name, spatially derived from the Air Green Book.
DISTANCE_TO_BP The distance in miles to the FRS best pick coordinate
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
REP_LATITUDE83 The latitude coordinate of the facility representative point for this program record.
REP_LONGITUDE83 The longitude coordinate of the facility representative point for this program record.
REP_OBJECTID The unique numeric identifier for the geometry of the facility representative point for this program record.
REP_TIMESTAMP A system-generated value that represents the calendar date and time the facility representative point for this program record was posted to the database.