It's terrific. It's located in the heart of Calgary, but you'd never believe it. It has everything a regular zoo has, and more. The dinosaur park is massive, depicting dinosaurs in their natural habitats going about their daily business. Kids can climb all over them, and run around to their heart's content (or until they are exhausted).
As mentioned before, there are all sorts of rides for kids to go on as well. There are tons of vendors selling tons of junk food (and some healthy stuff, too). The petting zoo is always a hit with kids, too.