“City of Calgary Capital on the Web Update” Project

In March 2010, MRF was selected by the City of Calgary to design and implement a new capital project data management system using ESRI products and an Oracle database called “Capital on the Web Update”.  “Capital on the Web Update” is a web based system that allows Capital Budget Office and other city business units to manage city council approved capital budget. 

The major functionalities of the system are:

· User managements

· Budget adjustments

· Project managements

· Business unit and funding managements

· Disputes, emails, and logs managements

· Reports

· Project managements and disputes through map interface

The major technological aspects and challenges of the project:

· Microsoft Windows Communication Foundation (WCF) is used, so business logic and user interfaces can be separated clearly. Therefore, it is easier to maintain and expand the application.

· Since the application is written using WCF and Silverlight, some frequently used data sets are pre-fetched and cached at the client side. This approach improves display performance and user experience dramatically.

· Batch loading was taking several hours to process using ArcGIS Server. MRF modified the long transaction workflow so users can cancel the batch loading at any time. MRF also uses multi-threads technology to manage the batch loading.

· Since map printing is not supported by Silverlight 3.0, MRF wrote a function to catch the image in the Silverlight plug-ins to meet customer’s printing need.

The major technologies of the “Capital on the Web” system include:

· Oracle 10g

· ArcSDE

· ArcGIS Server 9.3.1 with Silverlight API

· .NET framework 3.5

· Silverlight 3.0

· Microsoft Windows Communication Foundation

· Active Reports

The following is a screenshot of “Capital on the Web Update” System:

The budget for “Capital on the Web Update” is $109,250.