Retrieve tri facility data from tri database
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)
|
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. |
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.