Slashgeo

ETL: Fundamental to Spatial Analysis and Sharing of Data

posted by Satri on Wednesday October 31, @02:16PM        Permalink  Trackback URI  Slashdotthis  Diggthis  Del.icio.us
from the extract-me-to-transform-my-soul-and-load-happiness-inside dept.

The Terra ETL blog runs another interesting entry, this time on Extract, Transform and Load, fundamental steps of spatial analysis and sharing of data. The entry's introduction: "ETL or Extract, Transform, and Load is a process in Data Warehousing. Data Warehouses are all around us - whether we are querying the Yellow Pages on-line to geo-coding our datasets, there is most often a database or data warehouse behind the scenes. But how we get data into the warehouse, is called ETL. This is a short introduction to ETL as it is an important part of data warehousing. I also cover a little about Spatial ETL." See also related stories.

Trackbacks:

• NONE
• NONE
• NONE
• NONE
• NONE
• NONE
• NONE
• NONE
• NONE
• NONE

Related Stories

Comparing FDO, GDAL/OGR and FME [+]

The PerryGeo blog ask an interesting question about comparing FDO, GDAL/OGR and FME. From the blog: " FDO, GDAL and FME all seem to operate in roughly the same domain - Providing a data model, API and tools to translate between spatial data formats. Does anyone know of any good write-ups comparing/contrasting the features of these three libraries?" Read the very informative answers on the blog. See also related stories below.

New FME 2007 Available from Safe Software 1 comment [+]

Safe Software writes "FME 2007 introduces support for raster data, making it the industry's first complete spatial ETL tool. It also includes more than 2100 enhancements. For a free trial, white paper and FME 2007 highlights document, visit www.safe.com/2007."

Industry: Spatial Data Integrator 1.1 Released [+]

Camptocamp announced the release of Spatial Data Integrator 1.1, an open source ETL (extract, transform, load) solution. From the press release: " Based on Talend’s data integration technology, Talend Open Studio (TOS), SDI includes components such as reading/writing main SIG file formats, geospatial data transformation, and creation/publication of metadata. SDI uses the following Open Source components: GeoTools, JTS, GeoNames Webservices, GeoNetwork [...] This new version of SDI combines various developments [...] These developments include: Projections support at Input/Output and data reprojections support; 2 new components groups: GeoCoding et DataQuality; [...]" See also related stories below.

Safe Software Adds New Dimensions to Spatial ETL with FME 2008 1 comment [+]

Safe Software writes "Safe Software today announced new advancements in spatial data access with the release of FME 2008. The release includes the unveiling of FME Server, a scalable solution for data transformation and distribution, as well as a new version of FME Desktop, the recognized standard in spatial ETL (extract, transform and load). Both solutions add new dimensions to spatial data access, giving even more users access to their data when, where and how they need it." See also previous related stories below.

Industry: Spatial Data Integrator 1.3.0 Released [+]

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.

• Spatial Data Integrator

  (Score:3, Informative)

  by djonglez (426) on Wednesday November 07, @01:06PM (#1924)

  To complete this news, we just have released a new Spatial ETL called Spatial Data Integrator (SDI). SDI is available for DownLoad here : http://www.spatialdataintegrator.com./ [www.spatia...grator.com] SDI is based on the Java ETL Talend Open Studio (TOS), the most powerfull open source ETL on the market. It's a first version with around 30 spatial components based on JTS and Geotools Libraries. We've included some metadatas transformation components and we should include as soon as JGrass 3 will be available (April 2008) some Raster oriented components. Please fill free to ask questions using the communautary forum.