Spatial ETL processes

ETL-Prozess in Talend
ETL-Prozess in Talend

Spatial ETL processes map geodata and geodata models in the domain of GIS and are a logical step towards the automation and standardization of processes and workflows. In public authorities and companies it is becoming more and more important to structure and provide large amounts of geodata as automated as possible. These so-called data integration solutions can be mapped via spatial ETL processes.

ETL describes the data handling process starting with the loading / merging of different data sources, the data transformation and the output of the data stream. The E stands for Extraction, T for Transformation and L for Load. There are different modeling and ETL tools for geodata, for example FME, GeoKettle or the Spatial Extension from Talend.

These Spatial ETL tools are based on a graphical user interface which is used to create and execute a processing script. Thus the tools are ideally suited to enable spatial ETL processes to be traced by users without programming knowledge. For very computation- and data-intensive procedures, however, the performance of workflows can be significantly increased by the individual programming of scripts. We support you in the automation of processes in the GIS environment:

  • Creation of templates with various ETL tools (FME, Talend, GeoKettle ...)
  • Data preparation of old data stocks - digitizing, georeferencing, vectorizing maps, plans, aerial photographs, etc.
  • Data conversion, data transformation, geocoding
  • Shell-scripting or Python-scripting for recurring workflows