lrt_frs_facility_site: Retrieve frs facility site data from lrt database

Description Usage Arguments

Description

Retrieve frs facility site data from lrt database

Usage

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
lrt_frs_facility_site(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,
  EPA_REGION_CODE = NULL, SITE_TYPE_NAME = NULL,
  INTEREST_STATUS_CODE = NULL, DATA_QUALITY_CODE = NULL,
  LOCATION_DESCRIPTION = 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_STATE_CODE = NULL,
  STD_CITY_NAME = NULL, STD_COUNTY_NAME = NULL,
  STD_COUNTY_FIPS = NULL, STD_COUNTRY = NULL,
  STD_FULL_ADDRESS = NULL, ADDR_TYPE = NULL,
  LAST_REPORTED_DATE = NULL, CREATE_DATE = NULL, UPDATE_DATE = NULL,
  USER_ID = NULL, PARENT_REGISTRY_ID = NULL, SENSITIVE_IND = NULL,
  REVIEW_FLAG = NULL, REVIEW_REASON = NULL, SMALL_BUS_IND = NULL,
  ENV_JUSTICE_CODE = NULL, PUBLIC_IND = NULL, ICIS_IDENTIFIER = NULL,
  REFRESH_DATE = NULL, STAND_ALONE_FLAG = NULL)

Arguments

REGISTRY_ID

e.g. '110000307668'. See Details.

PRIMARY_NAME

e.g. 'HB FULLER COMPANY HBF PUERTO RICO'. See Details.

LOCATION_ADDRESS

e.g. 'CALLE C NUMBER 26 LUCHETTI INDUSTRIAL PARK'. See Details.

SUPPLEMENTAL_LOCATION

e.g. 'NA'. See Details.

CITY_NAME

e.g. 'BAYAMON'. See Details.

COUNTY_NAME

e.g. 'BAYAMON'. See Details.

FIPS_CODE

e.g. '72021'. See Details.

STATE_CODE

e.g. 'PR'. See Details.

STATE_NAME

e.g. 'PUERTO RICO'. See Details.

COUNTRY_NAME

e.g. 'USA'. See Details.

POSTAL_CODE

e.g. '00961'. See Details.

FEDERAL_FACILITY_CODE

e.g. 'N'. See Details.

FEDERAL_AGENCY_CODE

e.g. 'NA'. See Details.

TRIBAL_LAND_CODE

e.g. 'N'. See Details.

TRIBAL_LAND_NAME

e.g. 'NA'. See Details.

LEGISLATIVE_DIST_NUM

e.g. '- '. See Details.

EPA_REGION_CODE

e.g. '02'. See Details.

SITE_TYPE_NAME

e.g. 'STATIONARY'. See Details.

INTEREST_STATUS_CODE

e.g. 'A'. See Details.

DATA_QUALITY_CODE

e.g. 'V'. See Details.

LOCATION_DESCRIPTION

e.g. 'NA'. See Details.

STD_NAME

e.g. 'HAMBGR FULLER HBF PR'. See Details.

STD_LOC_ADDRESS

e.g. 'CLL C NUMBER 26 LUCHETTI INDUSTRIAL PARK'. See Details.

STD_HOUSE_NUMBER

e.g. 'NA'. See Details.

STD_STREET_NAME

e.g. 'NA'. See Details.

STD_BASE_NAME

e.g. 'NA'. See Details.

STD_PREFIX

e.g. 'NA'. See Details.

STD_SUFFIX

e.g. 'NA'. See Details.

STD_STYPE_BEFORE

e.g. 'NA'. See Details.

STD_STYPE_AFTER

e.g. 'NA'. See Details.

STD_POSTAL_CODE

e.g. '00739'. See Details.

STD_STATE_CODE

e.g. 'PR'. See Details.

STD_CITY_NAME

e.g. 'CIDRA'. See Details.

STD_COUNTY_NAME

e.g. 'CIDRA MUNICIPIO'. See Details.

STD_COUNTY_FIPS

e.g. '72041'. See Details.

STD_COUNTRY

e.g. 'PR'. See Details.

STD_FULL_ADDRESS

e.g. 'CLL C NUMBER 26 LUCHETTI INDUSTRIAL PARK, CIDRA, PR 00739 PR'. See Details.

ADDR_TYPE

e.g. 'REGULAR URBAN'. See Details.

LAST_REPORTED_DATE

e.g. 'NA'. See Details.

CREATE_DATE

e.g. '01-MAR-00'. See Details.

UPDATE_DATE

e.g. '31-DEC-15'. See Details.

USER_ID

e.g. 'DSMITH04'. See Details.

PARENT_REGISTRY_ID

e.g. 'NA'. See Details.

SENSITIVE_IND

e.g. 'N'. See Details.

REVIEW_FLAG

e.g. 'NA'. See Details.

REVIEW_REASON

e.g. 'NA'. See Details.

SMALL_BUS_IND

e.g. 'NA'. See Details.

ENV_JUSTICE_CODE

e.g. 'NA'. See Details.

PUBLIC_IND

e.g. 'Y'. See Details.

ICIS_IDENTIFIER

e.g. 'NA'. See Details.

REFRESH_DATE

e.g. 'NA'. See Details.

STAND_ALONE_FLAG

e.g. 'N'. See Details.


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