hey Mahesh,
What you’re describing is not an easy shot but is completely doable. It sounds like what you’re having trouble with is the animated camera.
The fist thing you’ll need to do is track the camera (matchmove). There are a number of software packages that can accomplish this task, including After Effects. To launch AE’s Camera Tracker, select the clip in the timeline and click Animation>Track Camera. AE’s Camera Tracker is fantastic for 95% of shots you throw at it.
In cases where the track is more complex, you will require a dedicated matchmoving package. For this, I recommend SynthEyes https://www.ssontech.com/ because of its ease of use, robust tools and price. When you track a camera in a matchmoving package, it helps to know what physical camera was used. Once you have the camera model, look it up on https://vfxcamdb.com/ and write down the ‘Sensor Size’ which is also known as ‘Filmback Size’. Together with the lens info, the sensor size will help track the camera accurately when using a dedicated matchmoving package like Syntheyes. Here are a few other matchmoving packages you can look into, PFTrack, 3D Equilizer, Boujou..
Once the shot is tracked: You can either add a 2D image of the desert where the ground plane is and roto the stadium back on top of it. OR if the desert asset is 3D, you can take the tracked camera over to your 3D package and render the desert from the tracked camera’s perspective. When you import that 3D render into After Effects, it’ll line up perfectly with the footage so you can roto the stadium back on top of the 3D render and composite.
It’s impossible to tell what the best method would be without seeing the shot. In some cases, using Mocha to track the ground and replace it with an image (of the desert) can also work without the need to track any camera. However, if there is parallax in your desert scene, you will want to use a 3D render instead of a 2D image.
Note: You used the term ‘Zoom’ but I think what you mean is that the drone is flying out of the stadium into the sky revealing the stadium exterior as the shot gets wider. Animated ‘zoom’ means that the focal length of the camera is animated which is more complex to track.
Hope this helps,
Mike Sevigny
https://www.torusmedialabs.com