tri_tri_facility: Retrieve tri facility data from tri database

Description Usage Arguments

Description

Retrieve tri facility data from tri database

Usage

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
tri_tri_facility(TRI_FACILITY_ID = NULL, FACILITY_NAME = NULL,
  STREET_ADDRESS = NULL, CITY_NAME = NULL, COUNTY_NAME = NULL,
  STATE_COUNTY_FIPS_CODE = NULL, STATE_ABBR = NULL, ZIP_CODE = NULL,
  REGION = NULL, FAC_CLOSED_IND = NULL, MAIL_NAME = NULL,
  MAIL_STREET_ADDRESS = NULL, MAIL_CITY = NULL,
  MAIL_STATE_ABBR = NULL, MAIL_PROVINCE = NULL, MAIL_COUNTRY = NULL,
  MAIL_ZIP_CODE = NULL, ASGN_FEDERAL_IND = NULL, ASGN_AGENCY = NULL,
  FRS_ID = NULL, PARENT_CO_DB_NUM = NULL, PARENT_CO_NAME = NULL,
  FAC_LATITUDE = NULL, FAC_LONGITUDE = NULL, PREF_LATITUDE = NULL,
  PREF_LONGITUDE = NULL, PREF_ACCURACY = NULL,
  PREF_COLLECT_METH = NULL, PREF_DESC_CATEGORY = NULL,
  PREF_HORIZONTAL_DATUM = NULL, PREF_SOURCE_SCALE = NULL,
  PREF_QA_CODE = NULL, ASGN_PARTIAL_IND = NULL,
  ASGN_PUBLIC_CONTACT = NULL, ASGN_PUBLIC_PHONE = NULL,
  ASGN_PUBLIC_CONTACT_EMAIL = NULL, BIA_CODE = NULL,
  STANDARDIZED_PARENT_COMPANY = NULL, ASGN_PUBLIC_PHONE_EXT = NULL)

Arguments

TRI_FACILITY_ID

e.g. '00602BXTRF111CO'. See Details.

FACILITY_NAME

e.g. 'BAXTER HEALTHCARE CORP., FENWAL DIV.'. See Details.

STREET_ADDRESS

e.g. '111 COLON ST.'. See Details.

CITY_NAME

e.g. 'AGUADA'. See Details.

COUNTY_NAME

e.g. 'AGUADA'. See Details.

STATE_COUNTY_FIPS_CODE

e.g. '72003'. See Details.

STATE_ABBR

e.g. 'PR'. See Details.

ZIP_CODE

e.g. '00602'. See Details.

REGION

e.g. '2'. See Details.

FAC_CLOSED_IND

e.g. '1'. See Details.

MAIL_NAME

e.g. 'BAXTER HEALTHCARE CORP., FENWAL DIV.'. See Details.

MAIL_STREET_ADDRESS

e.g. '111 COLON ST.'. See Details.

MAIL_CITY

e.g. 'AGUADA'. See Details.

MAIL_STATE_ABBR

e.g. 'PR'. See Details.

MAIL_PROVINCE

e.g. 'NA'. See Details.

MAIL_COUNTRY

e.g. 'NA'. See Details.

MAIL_ZIP_CODE

e.g. '00602-'. See Details.

ASGN_FEDERAL_IND

e.g. 'C'. See Details.

ASGN_AGENCY

e.g. 'NA'. See Details.

FRS_ID

e.g. 'NA'. See Details.

PARENT_CO_DB_NUM

e.g. '080532250'. See Details.

PARENT_CO_NAME

e.g. 'BAXTER SALES CORP'. See Details.

FAC_LATITUDE

e.g. '182848'. See Details.

FAC_LONGITUDE

e.g. '671106'. See Details.

PREF_LATITUDE

e.g. '18.48'. See Details.

PREF_LONGITUDE

e.g. '67.185'. See Details.

PREF_ACCURACY

e.g. '11000'. See Details.

PREF_COLLECT_METH

e.g. 'UN'. See Details.

PREF_DESC_CATEGORY

e.g. 'UN'. See Details.

PREF_HORIZONTAL_DATUM

e.g. '1'. See Details.

PREF_SOURCE_SCALE

e.g. 'U'. See Details.

PREF_QA_CODE

e.g. '0100'. See Details.

ASGN_PARTIAL_IND

e.g. '0'. See Details.

ASGN_PUBLIC_CONTACT

e.g. 'MARIO LUCENA'. See Details.

ASGN_PUBLIC_PHONE

e.g. '8098383000'. See Details.

ASGN_PUBLIC_CONTACT_EMAIL

e.g. 'NA'. See Details.

BIA_CODE

e.g. 'NA'. See Details.

STANDARDIZED_PARENT_COMPANY

e.g. 'NA'. See Details.

ASGN_PUBLIC_PHONE_EXT

e.g. 'NA'. See Details.


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