Oracle SA and Tolken Technologies have teamed up to develop a spatially enabled database system capable of providing a wide range of information on properties, buildings and other municipal resources for the Northern MSS of the Greater Johannesburg Metropolitan Council.

"We needed to centralise, collate and segment the vast amount of information gathered on a daily basis from various Metropolitan Council departments located in a number of sites throughout the city," says Heather Fuller of the JHB Metro Council. "Together with Oracle we designed a central repository for this information which is now available for sharing among Council departments associated with the planning, development and upgrading of the largest city in sub-Saharan Africa. Importantly, users will be security cleared before gaining access to information and they will be restricted to making changes to their own data."

A central Oracle database running on Windows NT 4.0 was implemented and an Oracle Enterprise Server installed for the storage of data. Autodesk Mapguide software was installed at the Council's IT department and linked to the Oracle database for the display of maps and related information across the Council's Intranet. Munsys and AutoCAD Map systems were installed at the planning and technical departments and will be used for the capture and maintenance of data.

"What motivated the installation was the user friendliness of the products which has led to a reduction in training and support costs," adds Fuller. "Using Munsys, for example, users do not require knowledge of GIS and databases to perform their day-to-day tasks. The complexities of the system are hidden."

Chris Tolken, MD of Tolken Technologies, the company that executed the Council's installation, says Munsys is specifically designed for local government and it caters for each department's needs. "The installation of a central database will result in improved administration and the sharing of information. The open system on which we work stores data in an open format so that the client is not locked into one specific vendor's solutions. The installation also provides high performance, even across slow network segments and gateways, for linking to other databases," he says.

"The central administration of the database, together with the intranet application minimises time required by IT staff to access data and process their work," says Gatu Vasani, Account Manager at Oracle SA. According to Vasani, future plans include the development of additional intranet applications like a data warehouse utilising the Oracle Spatial Cartridge, enabling a spatial representation of the core information of the Metropolitan Council.

Oracle SA

(011) 266 4000

mcrooks@za.oracle.com