You are here: Home Sectors Surface Water and Groundwater

Coliban Water

E-mail Print
Client: David Hunter, Coliban Water

Coliban Water provides 130,000 retail, urban and rural water customers with water and wastewater services, over an area of 16,500 square kilometres of Central and Northern Victoria.  To support this activity, Coliban Water captured a range of GIS information in Eagle GIS, including property details and water and sewer assets.  In addition, Coliban Water developed a variety of corporate databases for asset management, customer billing, customer management, water modelling and so on.

Coliban Water identified that they needed to get more value from their GIS information and provide an easier to use system that could be accessed by all Coliban Water staff.  The new system needed to provide better integration with Coliban Water’s corporate databases to enable integrated queries.  The system also needed to enable easy access to queries such as the identification of customers affected by a burst pipe.

Spatial Vision was awarded the contract to supply a new GIS and related system integration services to Coliban Water, based on the ESRI range of GIS software.  The solution comprises ArcSDE to enable storage of the spatial information in a Microsoft SQL Server RDBMS, ArcGIS to provide powerful editing and analysis capabilities and Enterprise View (EView) for broad corporate GIS access.

Spatial Vision delivered this solution in a staged manner. The first stage was to design a “geodatabase” to hold Coliban Water’s spatial data.  The second stage was to convert their existing Eagle GIS data via a custom developed migration process including significant data reformatting and restructuring.  Spatial Vision, working with ESRI Australia, then installed and configured the required software and loaded the converted data.  The final stage was documentation and training.

Coliban Water are now fully operational with the new system and over the coming months will be refining and extending the various GIS “views” used by their staff.

Demonstrated Capabilities

  • Analysis of existing corporate databases and data
  • Design of integrated databases combining GIS and textual information
  • Development of a sophisticated, custom data conversion and restructuring process
  • Ability to implement a quality controlled data migration process
  • Design and deployment of a complex IT infrastructure

Resources

Stephen Farrell was project leader for this project.  Ian Miller provided the solution design.  Ishara Kotiah undertook the data model design and developed and implemented the data conversion process.  Ben Johnson undertook the software installation and configuration.

Technologies Applied

  • ArcSDE with SQL Server
  • ArcIMS
  • EView
  • ArcGIS
  • VBA, AML and Perl script development  
Last Updated ( Thursday, 17 September 2009 11:34 )  

Resources - Water Management

3D Interactive models of Groundwater Management Units

These 3D interactive models were generated by Spatial Vision Innovations for the Department of Sustainability and Environment (DSE) to help scientists better understand and interpret their data.

View the website here

Read more...

Resources - Water Management Resources

 
Victorian Water Resources data Warehouse The Victorian Water Resources Data Warehouse is a site dedicated to disseminating up-to-date information on Victoria’s water resources through the World Wide Web.
DPI - Victorian Resources Online Victorian Resources Online (VRO) is your gateway to a wide range of natural resources information and associated maps.
Our Water Our Future Our Water Our Future website aims to provide comprehensive information on water management and planning in Victoria, and to help all Victorians contribute to the sustainable management of our precious water resources.
DPI - Victorian Resources Online – Groundwater Resources Department of Minerals and Petroleum (NSW)
One in ten Victorians use groundwater - from private bores, springs or public water supplies - for at least part of their daily water supply. Bottled mineral water is also extracted from groundwater.
Australian Goundwater Management Units – Australian Natural Resource data Library A Groundwater Management Unit (GMU) is a hydraulically connected groundwater system that is defined and recognised by State and Territory agencies.
Australian Natural Resource Atlas – Water resources – Allocation and Use – Victoria The information in the Atlas was developed to involve a broad cross section of government and private sector groups interested in natural resource management issues.
Australian Natural Resource Atlas – Water resources – Availability – Victoria The information in the Atlas was developed to involve a broad cross section of government and private sector groups interested in natural resource management issues.
Australian Natural Resource Data Library – Groundwater Information Resources Provide tools for the discovery of data and information about data stored and managed by the Bureau of Rural Sciences on behalf of a number of organisations.