“Stargate Command: The App” promises high-quality, 3D graphics in a virtual environment that will let you explore the corridors of the S.G.C. on your iPhone or iPad. Users can also find key items from past SG-1 missions, uncover artwork from the show’s archive, and play Stargate SG-1 trivia.
And it's free.
ETA: Crashes for me at the loading screen.