GeoKettle

"GeoKettle is a powerful, metadata-driven Spatial ETL tool dedicated to the integration of different spatial data sources for building and updating geospatial data warehouses.

GeoKettle enables the Extraction of data from data sources, the Transformation of data in order to correct errors, make some data cleansing, change the data structure, make them compliant to defined standards, and the Loading of transformed data into a target DataBase Management System (DBMS) in OLTP or OLAP/SOLAP mode, GIS file or Geospatial Web Service.

GeoKettle is a spatially-enabled version of the generic ETL tool Kettle (Pentaho Data Integration). GeoKettle also benefits from Geospatial capabilities from mature, robust and well know Open Source libraries like JTS, GeoTools, deegree, OGR…

Geospatial-specific features:

Extract data from:

• Spatial database types: PostGIS, Oracle spatial, MySQL,  Microsoft SQL Server 2008*, Ingres* and IBM DB2*
• SOLAP (Spatial OLAP) system: GeoMondrian
• Geo files (data formats): Shapefile, GML, KML, OGR
• OGC Web services: Sensor Observation Service (SOS), Catalogue Web Service (CSW)

*Non native formats, can be used with some modifications.

Transformation of data:

Calculating:

• Buffers
• Centroid
• Random point on surface
• Area
• Length
• Distance
• Intersection
• Union
• Envelope
• Boundary
• Convex hull
• Difference
• Symetric difference
• Inverse geometry

Geoprocessing:

• General:
  • Clip
  • Clip with rectangle
  • Split multiparts
• Points:
  • Delaunay algorithm
• Lines:
  • Polylines -> polygons
  • Simplify lines
  • Smooth lines
  • Polylines to single segments
  • Split polylines at nodes
  • Split polylines with points
• Polygons:
  • Simplify polygons
  • Remove holes
  • Polygons -> polylines

Load data into a target format:

• Spatial database loads
• Spatial data warehouse population
• Data formats: Shapefile, GML, KML, OGR
• OGC Web services: Catalogue Web Service (CSW)

 http://www.spatialytics.org/projects/geokettle/