State Capital of Duesseldorf

The state capital of Duesseldorf  uses MapInfo Professional as a centralized Geo-Information-System (GIS) since several years. Over the years a huge amount of geodata has been collected from the concerned departments of the city, this data is combined for broad use across the city and related agencies. The primarygoal is to provide the data to all departments and agencies in a consolidated form using the latest technologies. To accomplish these goals the state capital decided to use an Oracle based solution.

CISS TDI has implemented a geodataserver/geodata warehouse prototype for the city of Duesseldorf. The intension of the prototype was a proof of concept of the implementation of a geodataserver with its important features, e.g. the parallel access with different GIS-technologies. CITRA is used as ETL tool. The data from the different departments will be translated from the source format to the CITRA format. The strong CITRA modelling tools are used to prepare the data according to the requirements of the goal data model in the Oracle database. The final Citra is used to load the data into the database Oracle Locator.

Users can now directly access the data with MapInfo Professional and MapXtreme, Intergraph’s Geomedia now and GE-Smallworld in the future without further conversion. The  database is designed for future requirements as well to manage further demands of data exchange between the departments. Further data imports and exports can be managed using new formats and as yet unknown data models. The prototype phase is now completed and passed to the productive phase.

With the introduction of the new official German cadastral data model ALKIS a new requirement arose to provide ALKIS data beyond the cadastral agency in a suitable data model in the Oracle based data warehouse. Beside the existing data stock the ALKIS data can be accessed at this point as a prototype over-all departments and applications by the involved GI-systems.

Using the NAS to CITRA translator and the associated configuration NAS to Oracle from CISS TDI the data can now be translated according to the official standards into the database. The translator NAS to CITRA provides qualitatively high class results, e.g. in the graphical representation. The officially required presentations of the GIS-objects, which is published in the comprehensive documentation of the GeoInfoDok, and which is e.g. based on complex rules for the presentation of e.g. building symbols, labelling rules etc., have been implemented  according to requirements. Alphanumeric data like object numbers, keys and additional text will be entirely processed and taken over. All object types enclosed in the ALKIS object type catalogues are supported and the official code tables are used for the presentation in plain texts of keys e.g. use of buildings.

Contact: Klaus Engelhard, ITK-Rheinland, Standort Düsseldorf, Hafenstr. 7