Related Topics:
Table Name: FF_WELL_AND_SHAFT
Description: A collection of data elements containing information on the wells, shafts, and vent holes in operation at each facility, including a description of the type of well, shaft, or vent hole, whether or not it is associated with a degasification gas collection system, whether the well, shaft, or vent hole is monitored individually or as part of a centralized monitoring point, the start and close date of each well, shaft, and vent hole, and the number of days the well, shaft, or vent hole was in operation during the reporting year.
Description: A collection of data elements containing information on the wells, shafts, and vent holes in operation at each facility, including a description of the type of well, shaft, or vent hole, whether or not it is associated with a degasification gas collection system, whether the well, shaft, or vent hole is monitored individually or as part of a centralized monitoring point, the start and close date of each well, shaft, and vent hole, and the number of days the well, shaft, or vent hole was in operation during the reporting year.
Columns:
- FACILITY_ID
- REPORTING_YEAR
- FACILITY_NAME
- ADDITIONAL_DESCRIPTION
- CENTRALIZD_MONITORING_POINT_ID
- DESCRIPTION
- GAS_SYSTEM_UNIT_ID
- IS_THIS_WELL_OR_SHAFT
- WELL_SHAFT_CLOSE_DATE
- WELL_SHAFT_DAYS_IN_OPERATION
- WELL_SHAFT_ID
- WELL_SHAFT_MONITORED_STATUS
- WELL_SHAFT_START_DATE
Envirofacts Data Service API for FF_WELL_AND_SHAFT: Envirofacts has developed a RESTful data service API to all of its internal data holdings. This functionality provides a user of Envirofacts with the ability to query any table through the use of a URL. The default output is in XML, which can be utilized in other applications, as well as tools such as Microsoft Excel or Access. Output options of CSV and Excel can be requested in the URL. The entire Envirofacts database metadata is available online, so that all tables and columns within Envirofacts are documented. Having the table structures available in this manner makes most of Envirofacts data easily available through the service. More information is available on the Envirofacts Services page.
Below is a sample of the first 10 rows of data for the FF_WELL_AND_SHAFT table. The URL used to produce this output is:
https://data.epa.gov/efservice/FF_WELL_AND_SHAFT/ROWS/0:10/EXCEL