GeoMondrian is a "spatially-enabled" version of the Mondrian OLAP server (also named Pentaho Analysis Services) developed by Pentaho. To make it clear, GeoMondrian is an implementation of a Spatial OLAP (SOLAP) server. As far as we know, it is the first implementation of such a server and it is open source!

It adds to Mondrian a Geometry data type, enabling storage of member properties and measures containing vector geometries (points, lines, polygons) natively within the data cubes. Some MDX functions supporting this data type are also provided. They allow to add spatial analysis capabilities to the analytical queries. Geometry objects are handled using the JTS library (http://www.vividsolutions.com/jts). For the moment, only PostgreSQL with the PostGIS spatial extension is supported as a data source for Geometry values.

GeoMondrian provides then a consistent integration of spatial objects into the OLAP data cube structure, instead of fetching them from an external spatial DBMS, web service or a GIS file. To summarize, GeoMondrian brings to the Mondrian OLAP server what PostGIS brings to the PostgreSQL DBMS, i.e. a consistent and powerful support for geospatial data!

GeoMondrian is a realization of the GeoSOA research group (headed by Prof. Thierry Badard, http://geosoa.scg.ulaval.ca) of the Department of geomatics sciences at Laval University, Quebec City, Quebec, Canada. Like Mondrian, GeoMondrian is released under the terms of the Eclipse Public License (EPL).

The GeoMondrian development team is composed of:

• Project coordinator: Thierry Badard
• Lead developer: Etienne Dubé

Like Pentaho Analysis Services, GeoMondrian is distributed under the Eclipse Public License (EPL). Included libraries (JTS, PostGIS driver wrapper) are in a compatible open source license. Please refer to the included LICENSE.html file for more details about the licensing terms.

The GeoMondrian extensions are Copyright (c) 2007-2009, GeoSOA research group, Departement of geomatics sciences, Laval University, Quebec, Canada.

Pentaho Analysis Services (Mondrian) is Copyright (c) 2007-2009, Pentaho Corporation.

For future releases and more information, visit us at http://www.geo-mondrian.org.

All comments or questions about GeoMondrian are welcome! Two mailing lists are available:

• geomondrian-users, for problems, questions and comments about the usage of GeoMondrian.
• geomondrian-devel, for problems, questions and comments relative to development tasks with GeoMondrian and for feature request.

To subscribe or to sign off the lists, please visit:

https://lists.sourceforge.net/lists/listinfo/geomondrian-users
or
https://lists.sourceforge.net/lists/listinfo/geomondrian-devel

There is a lot of work to do on a project like GeoMondrian and your help will be greatly appreciated. So we gladly welcome any contribution to further development, implementation and feedback on usage of GeoMondrian.

Nevertheless, it is often hard for new developers or users to work out where they can help. To begin with, we suggest you to subscribe to the mailing lists. Listen in for a while, to learn how others make contributions.

You can get your local working copy of the latest code. Review the todo list, choose a task or perhaps you have noticed something that needs to be corrected. Make the changes, do the testing, generate a patch, and post to the devel mailing list.

Document writers and translators are usually the most wanted people so if you like to help but you're not familiar with the innermost technical details, don't worry: we have work for you! ;-)

At present, no release of GeoMondrian is available. It is still an experimental, in development project.

Source code of GeoMondrian is currently only available on the Subversion repository of the project. Please consult section entitled "SVN repository and issue tracking system" for more details about how to get the source code.

The source code available on the SVN repository is not a release version. The API is expected to change during the development process. THIS EXPERIMENTAL VERSION SHOULD NOT BE USED IN A PRODUCTION ENVIRONMENT. IT IS PROVIDED AS IS, COMES WITH NO GUARANTEES AND WITHOUT TECHNICAL SUPPORT.

The GeoMondrian project is also available on Sourceforge at:

http://sourceforge.net/projects/geomondrian

A subversion repository for direct access to the last version of the GeoMondrian sources has been set up. The project subversion repository can be checked out through SVN with the following instruction set:


This is a generic Subversion checkout command which will pull all modules, tags and/or branches of the project. You will want to add '/trunk' to the HTTPS URL above to check out only trunk (main development line).

You can also directly browse the SVN at:

http://geomondrian.svn.sourceforge.net/viewvc/geomondrian

An issue tracking system is also available online at:

http://sourceforge.net/tracker/?group_id=262145&atid=1131066

Various documentations are included in the distribution of GeoMondrian. Please, visit the doc subdirectory when you have performed a checkout of the source code.

You can also access the slides and a video (part 1 | part 2) of a presentation (in English) given by Dr. Thierry Badard during the SummerCamp/GeoCamp 2009 event which was held in Ottawa at the Algonquin College on May 13-15, 2009. It was an opportunity for the GeoSOA research group to present the last developments performed on the free and open source geospatial Business Intelligence software stack designed by the research group. GeoMondrian, the first open source implementation of a Spatial OLAP (SOLAP) server and Spatialytics, a cartographic component which enables the navigation in the geo-analytical data cubes and aims at being integrated in various dashboard frameworks, have been presented and demoed.

An online demo of Spatialytics is also available online. It demonstrates how Spatialytics coupled with GeoMondrian works! Please, visit the following URL to access the demo:

http://geosoa.scg.ulaval.ca/Spatialytics/

Notes about the demo:

3 measures are available and can be accessed through the modification of the MDX query:

• Population (by default when the page loads)
• Naissances (# of birth)
• Décès (# of death)

Data from 2001 to 2003 are available.

Values of these different measures are in no way related to any reality (or maybe the population of black flies in some regions of Canada ;-)). Boundaries of provinces, economical regions and local administrative divisions are also false.

At present, only 2 thematics can be selected (see Thematic drop-down list) and be changed live:

• choropleth maps based on dynamic equal intervals
• choropleth maps based on fixed intervals

More thematics should be available soon. A student funded by the Google Summer of Code 2009 program, under the umbrella of OSGeo, is currently working on the extension of thematic mapping capabilities of Spatialytics.

Moving the mouse cursor on a province, an economical regions, etc. highlights the polygon of the geospatial feature. The value of the measure is then displayed in the Information box.

To drill down the map, just select the first icon at the left top corner of the map and click a province, an economical region, etc. The drill operation implemented in this demo is a drill by occurence.

If you want to roll-up, just select the second icon at the left top corner of the map and click an economical region, a local administrative division with the left mouse button. The roll-up operation implemented in this demo will retrieve all parent members in the hierarchy of the geospatial dimension. It is a roll-up by level operation.

If you use GeoMondrian and like it, please let us know. We will try to maintain in this section a list of companies, governmental bodies, not-for-profit organisations, labs or universities that use GeoMondrian, develop or plan to develop packaged solutions based on it.

Thanks!