Table Name: FRS_FACILITY_SITE
Description: Basic identification information for a facility site, including the facility registry identifier, geographic address, and geopolitical descriptors.
Relationships:
- Must be of interest due to one or more FRS_INTERESTs related by column REGISTRY_ID
- May be identified by one and only one FRS_AGENCY_REF related by column FEDERAL_AGENCY_CODE
- May be included within one and only one FRS_TRIBAL_LAND_REF related by column TRIBAL_LAND_NAME
- May be the parent of one or more FRS_FACILITY_SITEs related by columns REGISTRY_ID, PARENT_REGISTRY_ID
- May be the child of one and only one FRS_FACILITY_SITE related by columns REGISTRY_ID, PARENT_REGISTRY_ID
- Must reference one or more FRS_DATA_SOURCEs related by column REGISTRY_ID
- ACCURACY_MEASURE
- ADDR_TYPE
- AIRSHED_CODE
- CENSUS_BLOCK_CODE
- CITY_NAME
- CONFIDENCE_IND
- CONGRESSIONAL_DIST_NUM
- COUNTRY_NAME
- COUNTY_NAME
- CREATE_DATE
- DATA_QUALITY_CODE
- ENV_JUSTICE_CODE
- EPA_REGION_CODE
- FEDERAL_AGENCY_CODE
- FEDERAL_FACILITY_CODE
- FIPS_CODE
- GEOCODE_LATITUDE
- GEOCODE_LONGITUDE
- HUC_CODE
- INTEREST_STATUS_CODE
- LAST_REPORTED_DATE
- LEGISLATIVE_DIST_NUM
- LOCATION_ADDRESS
- LOCATION_DESCRIPTION
- LOCATION_KEY
- PARENT_REGISTRY_ID
- PARSED_POST_DIR_CODE
- PARSED_PRE_DIR_CODE
- PARSED_STREET_NAME
- PARSED_STREET_NUMBER
- PARSED_STREET_SUFFIX
- POSTAL_CODE
- PRIMARY_NAME
- PUBLIC_IND
- REGISTRY_ID
- REVIEW_FLAG
- REVIEW_REASON
- SENSITIVE_IND
- SITE_TYPE_NAME
- SMALL_BUS_IND
- STATE_CODE
- STATE_NAME
- STD_CITY_NAME
- STD_COUNTY_NAME
- STD_LOC_ADDRESS
- STD_NAME
- SUPPLEMENTAL_LOCATION
- TRIBAL_LAND_CODE
- TRIBAL_LAND_NAME
- UPDATE_DATE
- USER_ID
- US_MEXICO_BORDER_IND
Return To: