For anyone trying to conceptualize how GeoMOOSE brings together data resources to deliver a unified view - please see the diagram below and then watch the accompanying video which shows the end results of this architecture.
Looking for something a bit more basic? Then check out the Consumer View version of this diagram.
Now watch how it all comes together at City of St. Paul, Minnesota, in its GeoMOOSE install known as "GISmo".
Spatial Information Management in the City of St. Paul as delivered by Bob Basques at the Twin Cities GECCo Event, October 27, 2011.