Slashgeo

Thierry Badard writes "The GeoSOA research group ( http://geosoa.scg.ulaval.ca/ ) of the Centre for Research in Geomatics at Laval University, Quebec City, Canada is proud to announce the release of a first version of GeoKettle as an open source contribution.

GeoKettle is a "spatially-enabled" version of Pentaho Data Integration (Kettle, http://kettle.pentaho.org/ ). Pentaho Data Integration (Kettle) is a powerful, metadata-driven ETL (Extract, Transform and Load) tool dedicated to the aggregation of different data sources in datawarehouses. It is part of the open source BI (Business Intelligence) software suite designed by Pentaho ( http://www.pentaho.com/ ). This special distribution of Kettle includes extensions which enable the use of geospatial (GIS) data. Like Kettle, GeoKettle is released under the GNU Lesser General Public License (LGPL).

GeoKettle v2.5.2-20080531 is still in alpha version but demonstrates the potential of this ETL tool dedicated to spatial datawarehouses and Spatial OLAP (SOLAP).

For further details and to download GeoKettle, please visit the GeoKettle project page:

http://geosoa.scg.ulaval.ca/en/index.php?module=pa gemaster&PAGE_user_op=view_page&PAGE_id=17."

The MapFish blog links to information about the release 1.3.0 of the open source ETL (extract transform and load) tool named Spatial Data Integrator. From the SDI 1.3.0's list of changes: "New: * sWfsInput: * sGpxInput: * sSimplify: Use DouglasPeuckerSimplifier and TopologyPreservingSimplifier algorithme to simplify geometries * sSimpleGeomToMulti: Convert simple geometry (POINT, LINESTRING, POLYGON) to collection (MULTIPOINT, MULTILINESTRING, MULTIPOLYGON). * sChangeLineDirection: Invert line direction * sTransform: Compute affine transformation (translation, rotation and scaling) * sUdig: Display datasets in uDig view Changes: * Added uDig views to view data * Added wizard for Metadata/Create generic schema from ESRI Shapefile, MIF/MID file * Update to TOS 2.4.1 * Update to GeoTools 2.5" See previous stories below, we mentioned SDI before.

Thierry Badard writes "The GeoSOA research group (http://geosoa.scg.ulaval.ca) of the Centre for Research in Geomatics at Laval University, Quebec City, Canada is proud to announce the release of a new version of GeoKettle (http://www.geokettle.org). GeoKettle is a "spatially-enabled" version of Pentaho Data Integration (Kettle, http://kettle.pentaho.org). Pentaho Data Integration (Kettle) is a powerful, metadata-driven ETL (Extract, Transform and Load) tool dedicated to the integration of different data sources for building data warehouses. It is part of the open source BI (Business Intelligence) software suite designed by Pentaho (http://www.pentaho.com)." Read the rest of the announcement below. See also previous stories. Counting Spatial Data Integrator, we now have two (competing?) open source ETL software.

Spatially Adjusted mentioned the release of Safe Software's FME 2009 and links to the 'What's great' brochure [pdf]. Along with performance improvements, SA notes "three new formats supported that really have me excited; CityGML 1.0, Adobe Geospatial PDF and OpenStreetMap XML". Additionally, the Random Nodes blog offers an entry named "FME 2009 – It’s the little things". Spatial Sustain has his own on FME 2009 named "Why Shoot for Faster?": "The motivations that they have for their work are compelling, as their products solve some very painful problems. For instance, say you’re a large utility that just bought another large utility, but all the details about your critical assets are stored on two different GIS systems that are incompatible. One of the major reasons for consolidating the two systems is that you’ll be able to combine operations and increase efficiencies, but the two entirely different systems are a barrier to reaching that goal. Here’s where Safe steps in and saves the day, helping to make both systems work together, and often rather quickly." See also previous stories below.

tbadard writes "After the release of a new version of its open source spatial ETL tool, GeoKettle yesterday (please see the announcement for more details), the GeoSOA research group at Laval University, Quebec, Canada is proud to announce the availibility as new open source projects of GeoMondrian, the first implementation of a Spatial OLAP (SOLAP) server and Spatialytics, a lightweight cartographic component which enables navigation in SOLAP data cubes. GeoKettle, GeoMondrian and Spatialytics are components of the complete geospatial BI (Business Intelligence) software stack developed by the GeoSOA research group." The rest of the announcement below, including precision about GeoMondrian and Spatialytics.