Streamlining Business Practices with GIS

"Lessons Learned from Enterprise-wide GIS Implementations"

Bryan Dickerson

Abstract

Idea Integration is making use of the Esri suite of tools to integrate GIS, document management, computerized maintenance management, and plant design software to streamline the business practices of our clients. By utilizing the suite of Esri software and a comprehensive development and implementation strategy, Idea Integration is able to tackle unique problems associated with retrieving and displaying information for a range of complex features all in a single, easy-to-use, Web-based environment. Some of the issues that arise from this use of GIS are two-dimensional representation of three-dimensional structures; integration with document management systems, and integration with CMMS all with the purpose of creating efficient, flexible, comprehensive systems to meet our clients' business needs.

Introduction

The implementation and use of central data warehouse solutions has become a common practice in the last few years in every possible environment ranging from government agencies, to corporations, and to utility districts. However, most of these solutions have been implemented on a departmental basis and many times do not account for the fact that other departments may find this information useful for day-to-day use. For example, the Finance Department in an agency or corporation may implement a financial management package to increase financial information storage and retrieval efficiency in their department. However, the Maintenance Department would likely find historical financial data on the costs incurred for purchasing and repairing assets useful for determining when the appropriate time is for replacing versus repairing that asset.

As various internal groups or departments begin to realize the usefulness of the information another department is building and maintaining the next challenge will be to integrate these individual data warehouses into an enterprise data management environment. A GIS can play an important role in this as the majority of these systems either store information about or related to spatial entities. As most people can easily relate to the physical location of an asset, a GIS can serve as the portal into the enterprise data management solution and help to streamline business practices by getting the right information to the right people at the right time. This paper will discuss some of the keys to successful enterprise data management solution implementations and then cover a real world example of how these principles can be put to use.

Keys to Successful Implementations

There are many keys to a successful enterprise solution implementation. However, project after project has shown us that 5 of these are the most crucial to creating a flexible and useful solution that meets clients' needs. They are as follows:

Understanding Client Business Practices and Needs

The first and foremost (and some would say the most obvious) thing that needs to be done is to gain an understanding of the business practices and needs of the client. It would be impossible to provide a solution that helps to streamline a client's business practices if those practices are not fully understood. This step is crucial to identifying where an enterprise data management system utilizing GIS can aid in eliminating inefficient steps in day-to-day processes and providing easier access to important information. All possible stakeholders should be involved as much as possible to ensure that the entire problem is understood instead of just one aspect. This understanding is most often gained through the following:

Regardless of the methods used to gain this understanding, it is important to remember that the primary purpose is to learn the client's existing business practices and discover how a GIS and enterprise data management solution can aid in improving the quality and efficiency of those practices.

Identifying a Business Champion

Developing and implementing an enterprise GIS and data management solution can many times be a lengthy process. Therefore the most important person in this process is your business champion. The business champion is the person from your client who will fight for the success of the project. This is the person who understands the benefits an enterprise GIS and data management solution will bring to his/her company or agency and is excited about the opportunities such a system will provide. Enthusiasm is contagious and if this person is enthusiastic about the project then others will be too. Participation in the development of the system will be high and feedback will be productive. If this person is not excited about the project and does not take it seriously, then others will see this and feed off this as well. Feedback will not be as productive and ultimately the solution provided will be incomplete and will "live down" to their low expectations.

Utilizing a Development and Implementation Strategy

The third key to a successful implementation of a GIS and enterprise data management solution is to develop and follow an implementation and development strategy. There are many documented strategies that would serve as a good reference. A good example is Steve McConnell's Rapid Development or Software Project Survival Guide from Microsoft Press.

At Idea Integration we have a documented methodology we follow called Idea RoadMap. Idea RoadMap is a powerful family of methodologies for planning and implementing solutions that leverage the best emerging technologies and connect to the real world of existing enterprise business systems. It includes developing strategies for application development and design, to project management, to risk management and has proven to be a valuable and successful tool in our implementations.

Regardless of how your implementation and development strategy is created, it should at least include sections for the following:

Irrespective of your specific plan, simply know that the old maxim of "plan your work and work your plan" definitely applies.

Prototyping / Early Wins

Early wins during a lengthy enterprise GIS and data management system are important. They show progress to your client and most importantly they keep the client portion of the project team excited and involved in the process. Instead of just defining the specifications for a system and then "going away" for 4 months before the system is put in place plan for the system to be implemented in functional pieces. This lets the client slowly integrate the new system, piece by piece, into their every day procedures instead of overwhelming users with a sometimes-daunting system at the conclusion of a project.

An easy way to obtain these early wins is to prototype pieces of the system. This has many benefits to both you and the likely end users of the system. It allows you to fine-tune and troubleshoot the system based on feedback you receive from those using the prototypes and allows some of the users to become familiar and comfortable with the system prior to completion of the project.

It is recommended that for successful prototyping prototypes should be deployed to small number of people whose composition is made up of both likely users of the system on a day-to-day basis and key decision makers in the project team. This creates an environment where users can give feedback on how to improve the systems and enough decision makers are familiar with the prototype and then end goal of the project to make a decision should conflicting requests from users be made. In addition, prototyping should be limited to a controlled system environment, or test machines, to prevent substantial time spent on solving miscellaneous system problems.

Soliciting and Responding to Useful User Feedback

As mentioned above, one of the purposes of prototyping is to obtain feedback from users to aid in designing a system that will completely meet their needs. However, just as important as the feedback you receive is how that information is organized. Feedback should be structured and should be made publicly available to all stakeholders.

The web is the perfect tool for this. By having users give feedback through the web you can achieve the following:

The following example shows a commenting engine built for an enterprise GIS and data management system implementation project for one of our clients. Users can make comments through completion of a form, read past comments and the project team response, read resolved comments, and even subscribe to comments so that when new comments are made they are received in the users e-mail. This commenting engine has proven to be extremely useful during the development of this system.

Just as important as obtaining feedback is quickly responding to feedback. By providing a tool such as the one above users will expect some kind of response almost immediately. A response does not have to be an actual implementation of a change but just acknowledgement that you are working the issue. This aids in keeping users involved with the implementation of the system.

Real World Example

The following example demonstrates the above principles put to use. This project involves the implementation of an enterprise GIS that integrates with a document management system and workflow system is an ongoing coordinated effort between Idea Integration, Brown and Caldwell, and CFI, L.L.C.

ArcIMS Integration w/ a Document Management System

The following client, a utility district, needed a more efficient method for accessing thousands of engineering design drawings for facilities at its treatment plants. The existing manual method was for engineers to look on a manually updated paper map for project numbers that affected certain facilities and then go pull the plan sets for those project numbers to determine whether they contained the information they needed. This process was further complicated by the fact that many times the plan sets were not in the library and were buried on someone's desk. Hours were spent attempting to find documents that may or may not have been relevant to the engineer's needs.

The solution was a web-enabled enterprise GIS and document management/workflow system that replicated the current practices in a much more efficient manner. Engineering plan sets were scanned and indexed and then loaded into an electronic document management system. A GIS of plant facilities was created and projects were spatially indexed to facilities in the plants. Metadata about past and ongoing projects was developed to aid users in narrowing down their list of projects of interest and a workflow system was put in place to aid in efficiently routing information through documented procedures.

This web-enabled system, utilizing ArcIMS and ArcSDE, allows users to locate a facility or facilities and then query the system for projects that have affected that facility or facilities over time.

Users can then select those projects that may be of interest and display metadata about each of those projects to ensure they really do meet the user's criteria.

Finally, the system queries the document management system for all documents related to those projects and displays them in an organized fashion to the user. The user can then select the individual documents of interest and retrieve them from the document management system to be printed, saved locally, or routed in a pre-determined workflow.

During development of this system a detailed implementation plan was put in place and existed as a living document. As unforeseen changes occurred during the life of the project, the plan was updated. Substantial time was spent identifying the user and functional requirements of the system and developing an understanding of the client's business practices. This helped to identify additional features of the system like the project metadata to aid users in narrowing down their list of projects. Finally, a three tier prototyping stage was completed that allowed users to generate feedback on the system and suggest improvements. This resulted in an enterprise GIS and data management system that significantly streamlined their business practices and saved valuable time in daily procedures.

Conclusions

The next challenge in our industry will be to integrate departmental data warehouses into enterprise data management solutions. GIS will play a key role in the development of these systems as most people can relate to the spatial locations of features. Successful implementation of these systems will involve five key principles: developing and understanding of the client's business practices, identifying a business champion, utilizing a development and implementation strategy, making use of prototyping to achieve early wins, and soliciting and responding to useful user feedback.

Acknowledgements

Gates, Bill; Business @ the Speed of Thought: Succeeding in the Digital Economy; Warner Books; 1999.

McConnell, Steven; Rapid Development: Taming Wild Software Schedules; Microsoft Press; 1996.

McConnell, Steven; Software Project Survival Guide; Microsoft Press; 1998.


Bryan Dickerson
Project Manager
Idea Integration
1350 W. Seventeenth Street, Suite 300
Denver, CO 80202
Tel: 1-800-685-5566
Fax: (303) 572-3359
E-Mail: bryan.dickerson@idea.com