Here is the size chart with the huge Space Stations from Starfleet and different Species like Cardassians, Suliban, Klingon, Species 8472, ...
PS: A special thank (and all copyright) for the picture material to: John Eaves, Drex Files, Star Trek Fact Files and Star Trek The Magazine, Starship Collection Magazine and The Light Works.