afs_effrs_afsplt1: Retrieve effrs afsplt1 data from afs database

In markwh/envirofacts: Access EPA Data via the Envirofacts Web Services

Description

Retrieve effrs afsplt1 data from afs database

Usage

afs_effrs_afsplt1(EPA_PLANT_ID = NULL, PLANT_ID = NULL,
  REGION_CODE = NULL, STATE_ABBREV = NULL, STATE_NAME = NULL,
  COUNTY_NAME = NULL, DUN_BRADSTREET_NUMBER = NULL,
  STATE_COUNTY_COMPLIANCE_SOURCE = NULL, STATE_CODE = NULL,
  COUNTY_CODE = NULL, CDS_PLANT_ID = NULL, PLANT_NAME = NULL,
  PLANT_STREET_ADDRESS = NULL, PLANT_CITY = NULL, ZIP_CODE = NULL,
  PRIMARY_SIC_CODE = NULL, PRIMARY_SIC_DESCRIPTION = NULL,
  SECONDARY_SIC_CODE = NULL, TERTIARY_SIC_CODE = NULL,
  SIC_EQUIVALENT_NAICS = NULL, NAICS_EQUIVALENT_SIC = NULL,
  GOVT_FACILITY_CODE_DESC = NULL, NAICS_CODE = NULL,
  NAICS_CODE_DESCRIPTION = NULL, STATE_REGISTRATION_NUMBER = NULL,
  LOCAL_CONTROL_REGION = NULL, LOCAL_CONTROL_REGION_DESC = NULL,
  OPERATING_STATUS = NULL, OPERATING_STATUS_DESCRIPTION = NULL,
  HPV_FLAG = NULL, DATE_PLANT_INFO_LAST_UPDATED = NULL,
  NAT_INIT_AIR_TOXICS = NULL, NAT_INIT_AIR_TOXICS_DESC = NULL,
  AFS_PLANT_ID = NULL)

Arguments

EPA_PLANT_ID	e.g. '110000307695'. See Details.
PLANT_ID	e.g. '1011473'. See Details.
REGION_CODE	e.g. '02'. See Details.
STATE_ABBREV	e.g. 'PR'. See Details.
STATE_NAME	e.g. 'PUERTO RICO'. See Details.
COUNTY_NAME	e.g. 'BAYAMON'. See Details.
DUN_BRADSTREET_NUMBER	e.g. 'NA'. See Details.
STATE_COUNTY_COMPLIANCE_SOURCE	e.g. '7202100240'. See Details.
STATE_CODE	e.g. '72'. See Details.
COUNTY_CODE	e.g. '021'. See Details.
CDS_PLANT_ID	e.g. '00240'. See Details.
PLANT_NAME	e.g. 'TEEN CHALLENGE CLEANERS'. See Details.
PLANT_STREET_ADDRESS	e.g. 'MARGINAL C-21 URB. STA. CRUZ'. See Details.
PLANT_CITY	e.g. 'BAYAMON'. See Details.
ZIP_CODE	e.g. '00956'. See Details.
PRIMARY_SIC_CODE	e.g. '7216'. See Details.
PRIMARY_SIC_DESCRIPTION	e.g. 'DRY CLEANING PLANTS, EXCE'. See Details.
SECONDARY_SIC_CODE	e.g. 'NA'. See Details.
TERTIARY_SIC_CODE	e.g. 'NA'. See Details.
SIC_EQUIVALENT_NAICS	e.g. 'PRIV'. See Details.
NAICS_EQUIVALENT_SIC	e.g. 'ATELY'. See Details.
GOVT_FACILITY_CODE_DESC	e.g. 'PRIVATELY OWNED/OPERATED'. See Details.
NAICS_CODE	e.g. '812320'. See Details.
NAICS_CODE_DESCRIPTION	e.g. 'Drycleaning and Laundry Services (except Coin-Operated)'. See Details.
STATE_REGISTRATION_NUMBER	e.g. '1001-2240'. See Details.
LOCAL_CONTROL_REGION	e.g. 'NA'. See Details.
LOCAL_CONTROL_REGION_DESC	e.g. 'NA'. See Details.
OPERATING_STATUS	e.g. 'O'. See Details.
OPERATING_STATUS_DESCRIPTION	e.g. 'OPERATING'. See Details.
HPV_FLAG	e.g. 'NA'. See Details.
DATE_PLANT_INFO_LAST_UPDATED	e.g. '14-MAR-14'. See Details.
NAT_INIT_AIR_TOXICS	e.g. 'NA'. See Details.
NAT_INIT_AIR_TOXICS_DESC	e.g. 'NA'. See Details.
AFS_PLANT_ID	e.g. 'NA'. See Details.

markwh/envirofacts documentation built on May 21, 2019, 12:26 p.m.