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
The name of the Tribal Reservation, Trust Land or Alaskan Indian Village area.
The standard EPA Identifier for the Tribe or Alaskan Indian Village.
The EPA standard Tribal or Alaskan Indian Village name.
The distance in miles from the Facility's Best Pick Coordinate to the boundary of the tribal land. Facilities with a value of 0 indicate that the Best Pick coordinate is within the tribal boundary.
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
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).
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.
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.
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.
The name of the U.S. county or county equivalent in which the facility site is physically located.
The code that represents the county or county equivalent and the state or state equivalent of the United States.
The U.S. Postal Service abbreviation that represents the state or state equivalent for the U.S. and Canada.
The name of a principal administrative subdivision of the United States, Canada, or Mexico.
The name that represents a primary geopolitical unit of the world. Default: USA
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.
Code indicating whether or not the facility is the property of the Federal Government.
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.
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.
Code indicating whether or not the facility site is located on tribal land.
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.
The number that represents a Legislative District within a state.
The code that represents an EPA Region.
The descriptive name for the type of site the facility occupies.
Stationary Contamination Addressed
Monitoring Station Contaminated Site
Brownfields Site Potentially Contaminated Site
Water System Pipeline
The status of the facility in relation to regulatory interest.
Allowable Values: A for Active or I for Inactive
A code assigned by the automated integration process to indicate whether the address data are missing, invalid, or non standard.
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.
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").
The location address after a set of standardization rules are applied for comparison purposes.
The number assigned to a building or a land parcel along the street to identify location and to ensure accurate mail delivery.
The name assigned to a street or road, not including other urban-style street address components.
The name of the street or road, not including the prefix, suffix, or pre- or post- directional codes.
The code that represents the qualifier that precedes the street name in a street address.
The code that represents the qualifier that follows the street name in a street address.
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.
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.
The standardized Postal Code returned by the standardization and parsing routines.
The standardized State Code returned by the standardization and parsing routines.
The standardized City Name returned by the standardization and parsing routines.
The standardized County Name returned by the standardization and parsing routines.
The standardized State County FIPS Code returned by the standardization and parsing routines.
The standardized Country Name returned by the standardization and parsing routines.
The standardized complete address, including STD_LOC_ADDRESS, STD_CITY_NAME, STD_STATE_CODE, AND STD_POSTAL_CODE.
The type of address given in the LOCATION_ADDRESS column (i.e., standard urban, PO Box).
The most recent date the corresponding data was reported to the Source of Data.
A system-generated value that represents the calendar date and time the corresponding information was first posted to the database.
A system-generated value that represents the most recent calendar date and time the corresponding information was updated in the database.
A code that identifies the registered user of the system.
The unique identification number, assigned by the EPA Facility Registry System, to the parent facility site (for example, the SDWIS water system).
Indicates whether or not the associated data is enforcement sensitive.
A flag that indicates the record requires a manual review due to changes from a data source.
The reason the record is flagged for manual review.
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.
The code that identifies the type of environmental justice concern affecting the facility or enforcement action.
Indicates whether or not the associated data is accessible by the public on the Internet.
This column is not being used.
A unique numeric identifier for each geometry in a layer.
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) that is the source of the Best Pick coordinate.
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. This represents the source program identifier for the associated representative point.
The measure of the angular distance on a meridian north or south of the equator standardized to NAD83 horizontal datum.
The measure of the angular distance on a meridian east or west of the prime meridian standardized to NAD83 horizontal datum.
Identification of the party that transmitted the associated latitude and longitude coordinates.
The name that describes the reference datum used in determining latitude and longitude coordinates.
The code that represents the method used to determine the latitude and longitude coordinates for a point on the earth.
The text that describes the method used to determine the latitude and longitude coordinates for a point on the earth.
The code that represents the place for which geographic coordinates were established.
The name that identifies the place for which geographic coordinates were established.
The code that represents the party responsible for providing the latitude and longitude coordinates.
The name of the party responsible for providing the latitude and longitude coordinates.
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).
The measure of the accuracy (in meters) of the latitude and longitude coordinates.
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.
The spatially derived city name.
The spatially derived county name.
The spatially derived ZIP Code.
The spatially derived State Code.
The spatially derived FIPS code.
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.
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.
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.
The number that represents the 113th Congressional District for a state within the United States.
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.
The 8-hour Ozone (1997) non-attainment area name, spatially derived from the Air Green Book.
The Lead 2008 non-attainment area name, spatially derived from the Air Green Book.
The Particulate Matter 2.5 (1997) non-attainment area name, spatially derived from the Air Green Book.
The Particulate Matter 2.5 (2006) non-attainment area name, spatially derived from the Air Green Book.
The 8-hour Ozone (2008) non-attainment area name, spatially derived from the Air Green Book.