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.