Atomic-scale characterization of structural distortions in perovskite oxide thin films