The Agglomeration Community of Châtellerault Develops its Data using Talend Open Studio for Data Integration

The geographic data of its GIS is enhanced by external information (DGI, INSEE) to provide elected officials and department heads with new dimensions of analysis.
Using tools like Talend Open Studio for Data Integration helps us innovate to meet the needs of our elected officials and citizens because they offer many useful features, without breaking our budget. We can plan the expansion of our GIS with peace of mind.
Philippe Desvignes, GIS Project Manager

The agglomeration community of Châtellerault

The agglomeration community of Châtellerault is an intercommunal structure of the Vienne department, comprising 12 municipalities, including the city of Châtellerault, the largest industrial zone of the Poitou-Charentes region. Covering a population of over 50,000 inhabitants, the area combines sustainable tourism (Vienne and Clain valleys) with a rich cultural and historical heritage (Roman art, “Jazzellerault” festival). Strategically located in the heart of the West, on the Paris-Bordeaux axis, the Châtellerault labor force is a major economic hub in Poitou-Charentes (automobile and aviation industries).

A multifaceted geographic information system

Like many collectivities, the agglomeration community of Châtellerault has developed a geographic information system (GIS) to manage many aspects of its activities: public roads, school boards, parks, public safety, public health, sanitation, etc. Presented in a very user-friendly manner, this information is available to community officials and its partners in support of projects or studies.

For example, the agglomeration community launched a feasibility study in 2009 on the deployment of a broadband network (fiber optic) based not only on the cadastral map, but also on other information (owners, plots of land, etc.) from external sources.

"This study is the basis of our first projects with Talend. We wanted to integrate the data distributed by the Directorate-General of Taxes (DGI) into our GIS in the form of alphanumeric files. These “Majic” files contain information on 78,000 developed and undeveloped plots of land that we had to cross with our geographic data ("Edigeo")," explains Philippe Desvignes, GIS Project Manager for the Agglomeration Community of Châtellerault and the City of Châtellerault. "We initially chose to use the urban management software of the City of Châtellerault, but the system proved to be too expensive. Using Excel macros required programming skills which we did not have and their maintenance would have been very complex. That’s why we studied the alternatives offered by open source technology."

Talend Open Studio for Data Integration to accelerate learning

The agglomeration community considered various options before deciding on Talend Open Studio for Data Integration. "We were looking for a business tool that was easy to use for non-technical staff and that would provide opportunities for growth," continues Philippe Desvignes. "We therefore deployed Talend Open Studio for Data Integration, after undergoing training to learn how to use the tool. Its interface is easy to understand, even for a geographer like me who is not familiar with Java. We quickly got the desired results and we were trained little by little each day by using the tool. In addition, we plan to use Spatial Data Integrator Camptocamp - which makes the most of Talend Open Studio for Data Integration - in the near future to integrate the Edigeo data into our GIS."

Talend Open Studio for Data Integration has also enabled the agglomeration community to retrieve and integrate date from the DGI (approximately 100 MB of information) into the Oracle database of the GIS. This operation will be renewed annually to incorporate DGI updates. "This processing time does not exceed 10 minutes, including the data format transformation. Now, when viewing a plot of land in our GIS, we can access related information with a simple click of the mouse, which really facilitates the officials’ work,” explains Philippe Desvignes. "Today, we also are retrieving INSEE census data, directly on its site, using Talend Open Studio for Data Integration and after a format transformation we will integrate this data into our GIS to make it accessible to all of our departments."

Distribute information from various sources

The agglomeration community has appreciated how easy the tool is to use. "Even before completing the Talend training, we downloaded Talend Open Studio for Data Integration and began to discover its features through a presentation on the Talend website and the online tutorials. The training has enabled us to increase and expand our knowledge of the tool by discovering new features," says Philippe Desvignes. "Two officials will be trained this year to pool our GIS with the City of Châtellerault. This will allow us to generalize information sharing to more officials, avoid multiple entries and provide more visibility to elected officials and administrators, for example through the development of BI dashboards."

In fact, the agglomeration community has plans to develop a database specifically dedicated to managing the built heritage, gathering information from different departments and assuming different formats. Requests on this database will allow, for example, the presentation of financial information (building maintenance costs, energy consumption monitoring) or legal information (insurance), to elected officials and department heads in a user-friendly manner. Like many local collectivities today, the agglomeration community also aims to improve operation management, control costs, more effectively inform citizens and better plan for the future.

"Using tools like Talend Open Studio for Data Integration helps us innovate to meet the needs of our elected officials and citizens because they offer many useful features, without breaking our budget. We can plan the expansion of our GIS with peace of mind,” concludes Philippe Desvignes, GIS Project Manager of the Agglomeration Community of Châtellerault and the City of Châtellerault.