In+ersec+ion for Spatial People

Some time already since we heard of this open source geospatial ETL tool, GeoKettle 2.5 has been released. Unless I'm mistaken, the other open source geospatial ETL tool formerly named 'Spatial Data Integrator', now known as 'Talend Spatial Module', is at version 5.2.1.

From the announcement: "GeoKettle 2.5’s new features include:

• WFS (OGC Web Feature Service): Input step for the retrieval of geospatial data directly from an OGC Web Feature Service;
• CSW (OGC Catalogue Service for the Web): Input and Output steps, introduced in version 2.0, that now support reading from Deegree and MDWeb CSW. The CSW Output step now supports transactions (metadata insertion, update and deletion), tested with in Deegree and GeoNetwork;
• WPS (OGC Web Processing Service): Client step has been added to invoke remote geoprocesses exposed as WPS, briging new geoprocessing capabilities, tested with Deegree, GeoServer, PyWPS, Zoo WPS and 52North WPS implementations;
• Use of the new version (1.9.1) of the GDAL/OGR codebase for the OGR Input and Output steps for even more advanced and powerful capabilities;
• Use of the new version (1.13) of the JTS library to benefit from performance enhancements and bug fixes;
• New conversion functions have been added to the Calculator step (more build and convert capabilities with WKT, GeoJSON, GML, KML, …);
• Use of an up-to-date version of the EPSG database, the definition of custom projection introduced in version 2.0 remains possible;
• Dedidicated installers (Windows, Linux / Debian or Linux / Red Hat, Macintosh) are now available, making the installation experience easier (zip archive still available);
• Sextante Module: Adds advanced vector-based geoprocessing capabilities based on the Sextante library."

Last week was announced GeoKettle 2.0, an open source spatial ETL (extract transform and load) tool. 

From the announcement: "GeoKettle, as its name suggests, is based on the widely used and robust generic ETL tool Kettle (aka Pentaho Data Integration or PDI) made « geo-capable » by integrating and leveraging the power of geospatial libraries such as of JTS, GeoTools, OGR, deegree and of course, brand new Spatialytics code." Here's the details of what's new for version 2.0. We mentioned quite a few times GeoKettle the past three years.

There's another open source spatial ETL tool out there that we haven't mentioned for a while, it's Talend's Spatial Data Integrator, with its version 4.2.0 released earlier this month. 

From their main page: "Spatial module for Talend Open Studio (aka. Spatial Data Integrator or SDI) is an ETL with geospatial capabilities. Likewise regular TOS components, there are basically three sorts of Geo components: input, output and transform components. Input and output components read features from and write feature to datastores, respectively. Transform components read features from their input flows, possibly transform those features, and write features to their output flows. The term transform is to be taken loosely here as it represents any sort of operation."