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