splitting boston and vancouver db updates