The City of Herten Group
The GIS-project in Herten was decisively influenced by the complexity of the different corporate structures of the Herten group: e.g. Hertener Stadtwerke GmbH as local utility, city of Herten and Zentraler Bautbetriebshof (dep. of civil engineering, traffic, transport,…) all of which impact geodata infrastructure.
Due to the constant growth of available geodata and the needs of those in the different departments of the involved parties, reorganization ofthe management of geodata at the Herten group was required. In addition there was a requirement to supply geodata to external service providers and agencies. Contemporary IT-structures for providing services and the supply of geo information indicated the implementation of a classical (geo) data warehouse supplemented with geodata content.
The introduction of the geodata warehouse in Herten is taking place incrementally in several steps. This can be done without any technical difficulty and is preferred to an all-at-once data migration. Doing it this way is a radical change, it proceeds according to the priority of subtasks and results in marginal organizational, technical and financial risks. Also allows problem free step by step improvements for future enhancements.
With the implementation of the geodata warehouse all geodata and interrelated attributive alphanumeric data from the different sources will afterwards be accessible for all departments of the whole Herten group and if required for neighbouring municipalities and external private users or commercial providers as well.
The Herten group has decided to use several different GIS after the consolidation of the GIS infrastructure and the implementation of the geodata warehouse, e.g. Smallworld GIS, ArcView and ArcGIS Server, Mapinfo Professional and Grappa Online based on MapXtreme from Pitney Bowes Mapinfo and Graphservice as well as AutoCAD. All OGC-SFO compliant GIS have direct access to the required data so that all data can be used easily by the different departments.
The following data has been or will be made available in the form of a combined, compatible and consistent data stock: cadastral data, topographical data, utility data like electric power, gas, district heating, sewage, traffic, transport, environment and many more. But also raster data and aerial photo in the warehouse will be made accessible by using WMS.
All data from the land registry office of Recklinghausen will be transmitted as daily updates to the database.
Oracle Standard Edition1 with Oracle Locator is used as technological basis of the geodata warehouse, CITRA is used as ETL tool.
At the beginning of 1990 CITRA was implemented at the city of Herten as well as at the Hertener Stadtwerken GmbH and was successfully used for many complex tasks in a homogeneous concept. To set up the geodata warehouse only a licence upgrade for the module CITRA-Oracle was necessary.
A direct OGC-SFO conform access for the GI-systems Smallworld GIS, MapInfo, MapXtreme and ArcGIS Server is already realized for the essential data like cadastral data, topographical data and utility data from Hertener Stadtwerke. More data will be made accessible successively.
To simplify the download of datasets for local processing, the CITRA Export Center will be implemented within one of the next steps.
Customized web services is planned in the near future.
Also the replacement of ALK by ALKIS (the new German complex cadastral datamodel) is already included in the concept of the geodata warehouse. The development of the ALKIS-Oracle interface and it’s configuration is already developed and assures the usage of any ALKIS data in the data warehouse. In addition to the concise and attractive data model, CISS TDI sets a high value on the compliance to the official ALKIS standards as stated in the latest GeoInfoDok. As a consequence it is now possible to have direct access to the ALKIS data by any SFO-conform GI system within the Herten group and to hav an appropriate presentation of the data without need of further applications or tools.
contact:
Herr Breuer, Hertener Stadtwerke GmbH, 45699 Herten,
Herr Berns, Hertener Stadtwerke GmbH, 45699 Herten,
Herr Mlodzian, Stadtverwaltung Herten, 45699 Herten
