lrt_frs_program_facility: Retrieve frs program facility data from lrt database

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

Description

Retrieve frs program facility data from lrt database

Usage

lrt_frs_program_facility(PGM_SYS_ACRNM = NULL, PGM_SYS_ID = NULL,
  REGISTRY_ID = NULL, PRIMARY_NAME = NULL, LOCATION_ADDRESS = NULL,
  SUPPLEMENTAL_LOCATION = NULL, CITY_NAME = NULL, COUNTY_NAME = NULL,
  FIPS_CODE = NULL, STATE_CODE = NULL, STATE_NAME = NULL,
  COUNTRY_NAME = NULL, POSTAL_CODE = NULL,
  FEDERAL_FACILITY_CODE = NULL, FEDERAL_AGENCY_CODE = NULL,
  TRIBAL_LAND_CODE = NULL, TRIBAL_LAND_NAME = NULL,
  LEGISLATIVE_DIST_NUM = NULL, HUC_CODE_8 = NULL, HUC_CODE_12 = NULL,
  EPA_REGION_CODE = NULL, SITE_TYPE_NAME = NULL,
  DATA_QUALITY_CODE = NULL, LAST_REPORTED_DATE = NULL,
  STD_NAME = NULL, STD_LOC_ADDRESS = NULL, STD_HOUSE_NUMBER = NULL,
  STD_STREET_NAME = NULL, STD_BASE_NAME = NULL, STD_PREFIX = NULL,
  STD_SUFFIX = NULL, STD_STYPE_BEFORE = NULL, STD_STYPE_AFTER = NULL,
  STD_POSTAL_CODE = NULL, STD_CITY_NAME = NULL,
  STD_COUNTY_NAME = NULL, STD_STATE_CODE = NULL,
  STD_COUNTY_FIPS = NULL, STD_COUNTRY = NULL,
  STD_FULL_ADDRESS = NULL, ADDR_TYPE = NULL, LINK_MTHD = NULL,
  LOCATION_DESCRIPTION = NULL, CREATE_DATE = NULL,
  UPDATE_DATE = NULL, USER_ID = NULL, SENSITIVE_IND = NULL,
  USER_COMMENT = NULL, PUBLIC_IND = NULL, REFRESH_DATE = NULL,
  SMALL_BUS_IND = NULL, ENV_JUSTICE_CODE = NULL,
  PARENT_PGM_SYS_ID = NULL, STAND_ALONE_FLAG = NULL,
  SOURCE_OF_DATA = NULL)

Arguments

PGM_SYS_ACRNM	e.g. 'ACES'. See Details.
PGM_SYS_ID	e.g. '170002007174'. See Details.
REGISTRY_ID	e.g. '110056309481'. See Details.
PRIMARY_NAME	e.g. 'ILLINI NISSAN'. See Details.
LOCATION_ADDRESS	e.g. '615 W MARKETVIEW DR'. See Details.
SUPPLEMENTAL_LOCATION	e.g. 'NA'. See Details.
CITY_NAME	e.g. 'CHAMPAIGN'. See Details.
COUNTY_NAME	e.g. 'CHAMPAIGN'. See Details.
FIPS_CODE	e.g. '17019'. See Details.
STATE_CODE	e.g. 'IL'. See Details.
STATE_NAME	e.g. 'ILLINOIS'. See Details.
COUNTRY_NAME	e.g. 'UNITED STATES'. See Details.
POSTAL_CODE	e.g. '61820'. See Details.
FEDERAL_FACILITY_CODE	e.g. 'NA'. See Details.
FEDERAL_AGENCY_CODE	e.g. 'NA'. See Details.
TRIBAL_LAND_CODE	e.g. 'NA'. See Details.
TRIBAL_LAND_NAME	e.g. 'NA'. See Details.
LEGISLATIVE_DIST_NUM	e.g. 'NA'. See Details.
HUC_CODE_8	e.g. 'NA'. See Details.
HUC_CODE_12	e.g. 'NA'. See Details.
EPA_REGION_CODE	e.g. '05'. See Details.
SITE_TYPE_NAME	e.g. 'STATIONARY'. See Details.
DATA_QUALITY_CODE	e.g. 'V'. See Details.
LAST_REPORTED_DATE	e.g. '15-NOV-13'. See Details.
STD_NAME	e.g. 'ILLINI NISSAN'. See Details.
STD_LOC_ADDRESS	e.g. '615 W MARKETVIEW DR'. See Details.
STD_HOUSE_NUMBER	e.g. '615'. See Details.
STD_STREET_NAME	e.g. 'W MARKETVIEW DR'. See Details.
STD_BASE_NAME	e.g. 'MARKETVIEW'. See Details.
STD_PREFIX	e.g. 'W'. See Details.
STD_SUFFIX	e.g. 'NA'. See Details.
STD_STYPE_BEFORE	e.g. 'NA'. See Details.
STD_STYPE_AFTER	e.g. 'DR'. See Details.
STD_POSTAL_CODE	e.g. '61822'. See Details.
STD_CITY_NAME	e.g. 'CHAMPAIGN'. See Details.
STD_COUNTY_NAME	e.g. 'CHAMPAIGN COUNTY'. See Details.
STD_STATE_CODE	e.g. 'IL'. See Details.
STD_COUNTY_FIPS	e.g. '17019'. See Details.
STD_COUNTRY	e.g. 'US'. See Details.
STD_FULL_ADDRESS	e.g. '615 W MARKETVIEW DR, CHAMPAIGN, IL 61822 US'. See Details.
ADDR_TYPE	e.g. 'NA'. See Details.
LINK_MTHD	e.g. 'NA'. See Details.
LOCATION_DESCRIPTION	e.g. 'NA'. See Details.
CREATE_DATE	e.g. '27-NOV-13'. See Details.
UPDATE_DATE	e.g. 'NA'. See Details.
USER_ID	e.g. 'REFRESH'. See Details.
SENSITIVE_IND	e.g. 'N'. See Details.
USER_COMMENT	e.g. 'NA'. See Details.
PUBLIC_IND	e.g. 'Y'. See Details.
REFRESH_DATE	e.g. '27-NOV-13'. See Details.
SMALL_BUS_IND	e.g. 'NA'. See Details.
ENV_JUSTICE_CODE	e.g. 'NA'. See Details.
PARENT_PGM_SYS_ID	e.g. 'NA'. See Details.
STAND_ALONE_FLAG	e.g. 'NA'. See Details.
SOURCE_OF_DATA	e.g. 'NA'. See Details.

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