update location logic and white location info to database