InPrint Summer 2009 by Cityworks, A Trimble Company

Cityworks July 2009 Delivering Innovative GIS-Centric Maintenance Management Tools for Your Organization

User Spotlight – City of South San Francisco

Cityworks Rolls Out Across Mesa, AZ

By Doug Hollis, City of South San Francisco, and Lindsay Ferguson, Azteca Systems, Inc.

By Jeff Cegielski and Matt Messinger, Motorola

Descripti o n The City of South San Francisco, California, occupies the valley formed by the San Bruno Mountains on the north and the Coast Range on the west. Most of the valley faces the San Francisco Bay offering sweeping vistas from higher levels and a definite sense of identification with the Bay. The site for South San Francisco, “The Industrial City,” was originally selected for the establishment of stockyards and as a marketplace for cattle. It was incorporated in 1908. Other industries followed over the years and the city has become a well-balanced community of industrial and residential areas. With approximately 2250 acres of land devoted to manufacturing, wholesaling, transportation facilities, and utilities, the city is home to more than 3200 firms and businesses. South San Francisco offers its 60,000 citizens fine residential areas, mild winters and dry/cool summers, and a variety of recreational activities with many local parks, swimming pools, and marinas.

Background Mesa, located in Maricopa County, is one of the nation’s fastest growing cities. Mesa is the third largest city in Arizona and the nation’s 38th largest city with a population of 462,823. The City provides the advantages of a thriving metropolis while maintaining the feel of a suburban environment. Just 15 miles east of Phoenix, Mesa covers 132 square miles.

Challenge Prior to their implementation of Cityworks, the City of South San Francisco was working in a paper environment where all records of maintenance work performed was documented on paper and physically filed away – a process that can be time-consuming and error-prone. In 2007, the State of California mandated that the City track and document their sewer and storm drain infrastructure. South San Francisco had no CMMS and, therefore, no tracking for environmental compliance. The City needed to find a solution for their documentation crisis and meet the new State mandates or face a considerable fine. Continued on page 27

With such a large and rapidly increasing population, the City needed to implement a solution that could help systematically update projects and maintenance activities throughout the city. This initiative was set to begin in the City’s Transportation Department. The main goal was to improve service request response time while accurately capturing maintenance and repair costs and give the Transportation Department greater accountability. Continued on page 25

INSIDE THIS ISSUE Features – User Spotlight – City of South San Francisco

Cityworks Rolls Out Across Mesa, Arizona

1 1

President’s Corner – Teaming Up to Consider Cityworks Server Deployment

Software Update – Hidden Gems in Server MMS

Project Management – Upgrading to Cityworks Server MMS

Client Services – Changes Happening!

Steady Growth Leads to Changes in Customer Support

MyCityworks.com – Help is Only a Click Away

Cityworks Campus Partner News – Domestic – New Braunfels Utilities, TX, Embraces Holistic Approach to Integrate Cityworks with Critical Business Systems (Woolpert)

Westin Develops Multiple Cityworks Integrations, Leveraging Strengths of Applications

10 12 17

Partner News – International – City of Kitchener, Canada, Achieves Enterprise Success (ESRI Canada)

The Parklands Foundation – First Cityworks Site in Australia (gViz)

Thiess & Cityworks to Manage Largest Infrastructure Project in Australia (gViz)

South San Francisco Sign Hill

Cityworks Server MMS Rollout/User Group Seminar Series

Regional News

Get to Know – Cityworks Project Managers

Azteca News

Azteca Systems, Inc. | 801.523.2751 | www.cityworks.com A Z T E C A S Y S T E M S, I N C.

President ’s Corner

InPrint Editor in Chief: Tom Palizzi Editor: Kaye Ryser Advertising: Kaye Ryser Azteca Systems, Inc. 11075 South State Street, Suite 24 Sandy, UT 84070 801-523-2751 www.cityworks.com To receive a subscription or to change your address, please send your contact information to: inprint@cityworks.com or call 801-523-2751 Founded in 1986, Azteca Systems, Inc. is the leading provider of GIS-centric Enterprise Asset Maintenance Management Systems for Public Works and Utilities. Built exclusively on top of ESRI’s leading GIS technology, Cityworks is powerful, scalable, and affordable. How to Reach Us: Tel: 801-523-2751 Email: info@cityworks.com

InPrint is published by Azteca Systems, Inc. (Azteca), at 11075 South State, #24, Sandy, UT 84070. InPrint contains material of interest to utility and public works organizations. Copyright © Azteca Systems, Inc. 2009 All rights reserved. Printed in the United States of America. The information contained in this document is the exclusive property of Azteca Systems, Inc. The work is protected under United States copyright law and other international copyright treaties and conventions. No part of this work may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying and recording, or by any information storage or retrieval system, except as expressly permitted in writing by Azteca Systems, Inc. All requests should be sent to Attention: Cityworks InPrint, Azteca Systems, Inc., 11075 South State Street, #24, Sandy, UT 84070. The information contained in this document is subject to change without notice. Azteca Systems and Cityworks are registered trademarks; Cityworks Desktop, Cityworks Anywhere, and Cityworks Server are trademarks of Azteca Systems, Inc.; and www.mycityworks. com, www.gocityworks.com, @azteca.com, www. azteca.com, @cityworks.com, and www.cityworks. com are service marks of Azteca Systems, Inc. The names of other companies and products herein are trademarks or registered trademarks of their respective trademark owners.

Teaming Up to Consider Cityworks Server Deployment By Brian Haslam, President, Azteca Systems, Inc.

Last issue I wrote that the time is now to consider where Cityworks Server can fit into your Cityworks deployment. Many of you attended one of the Cityworks Server Rollout Seminars held at various locations throughout the USA. At the seminars, we provided a lot of useful information about Cityworks Server to help you in your consideration. Everyone who attended expressed interest in Cityworks Server. Generally, there is great interest in considering where Cityworks Server can best be deployed in your organizations. Cross-compatibility assures that the deployment can be accomplished in an orderly manner. You need not worry about planning for a “switch-over date.” Cityworks Desktop and Anywhere are cross-compatible with Cityworks Server MMS. This allows you to install ArcGIS and Cityworks Server and test how it runs on your servers and your network before committing to full deployment. At the Cityworks Server Rollout Seminars, we shared a lot of performance information about Cityworks Server. We are trying to be completely open with you about what we have learned regarding deployment of a browser-based server system. Because Cityworks Server is explicitly linked to ArcGIS Server, we have to evaluate how ArcGIS Server performs with Cityworks Server, too. A N e w Game The browser server architecture has really changed the IT game, so to speak, from what it is for Cityworks Desktop and Anywhere client server architecture. It’s an entirely new game. For the old game (the client server), we had a lot of control over how the hardware, OS, and other non-operating system software interacted with Cityworks. Like all systems, we used the Windows Registry for storing information and settings to control the behavior of the software. In the new game (the browser server), we do not have such control. Variability in server hardware, networks including hardware and software, browsers, operating systems, peripheral software, and “other weird things” can impact the system and performance. Azteca Systems has no control over these variables. The very nature of a browser server system means the expectations for how to deploy and support such systems need to change from our experience with client server systems. For success the new game requires a team approach. The team is Azteca Systems, YOU, ESRI, and our partners. No t a Turnkey We all need to be clear that Cityworks is not a turnkey system. Our licensing fees and maintenance fees are not priced as a turnkey solution. If they were, we would have to charge far more. ESRI’s software fees and maintenance fees are not priced as a turnkey solution either. Our common approach is to work with you and our partners to achieve a successfully deployed system. The critical involvement of YOU is all the more paramount for a browser server solution like ArcGIS and Cityworks Server. There is no cookbook install for Cityworks Server, at least not yet. We and ESRI are just now starting to understand the “in-the-doorconfiguration” required but still face “other weird things” that crop up and variables out of our control. Y o u r Network and Your Servers As part of this team effort, YOU have the responsibility to ensure that your network and your servers can support an ArcGIS and Cityworks Server system. Just because your servers do well at supporting normal browser activity, even if it has been adequate for ArcIMS, do not assume your network and servers are up to the task. ArcGIS and Cityworks Server will put far more of a load on your network and servers. Therefore, consider that you are likely adding an additional load to your network and servers. We can suggest three approaches for to successfully determine if your network and servers are adequate.

INPRINT — July 2009

P r e s i d e n t ’ s C o r n e r ( c o n t .)

Approach 1. We will call this the you-do-the-system-analysis approach. Successfully deploy Cityworks Desktop and Anywhere to the most current release. Then, with our help or a Server-authorized partner, install Server in a “sandbox” or test environment and see how well it performs. The tests you perform need to be well thought out and robust. Do not just test the system on the server. Test it throughout the various parts of your organization to see if there are network issues. Test how it behaves when multiple requests are made at the same time to redraw maps with ArcGIS and perform functions in Cityworks. Based on the tests Azteca Systems has performed (we discussed these at the Server Rollout Seminars), we can provide you with guidance for the types of processes that will stress test the performance of your network and servers. Approach 2. We will call this the ESRI-does–the-system-analysis approach. Engage ESRI to perform a detailed system analysis of your network and servers to determine how well they will support ArcGIS Server. After ESRI has given the thumbs up for ArcGIS Server performance for your network and servers, then Azteca Systems or a Server-authorized partner (or both of us) can work with you to test Cityworks Server. Through our testing, we have learned that the greatest stress on the performance of your network and servers will be map redraws performed by ArcGIS Server. We are reasonably confident that if the ESRI System Analysis gives the thumbs up for ArcGIS Server, then all will go well for Cityworks Server.

Approach 3. We will call this the Serverauthorized-partner-does-the-system-analysis approach. Contract with a Server-authorized partner to stress test the performance of ArcGIS and Cityworks Server. For deployments where interfaces to other systems are vital, we believe this is a particularly good approach. The future of systems like Cityworks will be dominated by browserserver architecture. Wikipedia says it well: “Web applications are popular due to the ubiquity of web browsers and the convenience of using a web browser as a client, sometimes called a thin client. The ability to update and maintain web applications without distributing and installing software on potentially thousands of client computers is a key reason for their popularity.” It also mentions these benefits of browser applications—they typically require little or no disk space on the client, upgrade easily, and integrate easily into other web procedures. Azteca Systems is committed to doing all we reasonably can to assure the success of your Cityworks Server deployment. We believe this must include being completely open about what we have learned regarding the complexities of deploying a browser server system. By disseminating this information, we hope all of our users will continue to confidently consider how Server can fit into your organization. The successful deployment is a team effort with Azteca Systems, YOU, ESRI, and our partners. cw

The choice is yours........

YOU do the system analysis

ESRI does the system analysis

INPRINT — July 2009

#3 Serverauthorized partner does the system analysis

Software Update

Hidden Gems in Cityworks Server MMS By Carl Horton, Ph.D., Executive Director, Software Development, Azteca Systems, Inc.

If you haven’t had a chance to attend a Cityworks MMS Server Rollout Seminar, you may not know about some of the software’s new features and nifty updates. While everyone knows it’s browser-based and utilizes ArcGIS Server, there are a number of features not found in Cityworks Desktop. I have compiled this list of the top 10 hidden (and not-so-hidden) gems in Server, with a couple more features to come in the next release... Inbox While the contents of the domain inbox cannot be changed, all users can now define their own inbox contents and display it next to the domain inbox. Inbox widgets include saved searches, web widgets, and pages. These widgets can be moved around and reordered on the page. Event Lay e r s With perhaps the most insipid name in the maintenance management industry, event layers is one of the most unique features to Cityworks not found in other work management applications. Simply put, event layers are maps of work activities going on in your organization. While simple in concept, generating event layers in a browser-based map becomes rather complex. In order to dramatically increase map display speed and user options, the event layer functionality has undergone a complete ground-up rewrite in Server. Each user can now have any number of event layers identified with unique symbology from an icon library and the redraw speed is nearly instantaneous for any number of events. Geograph i c C o n s t ra i n ts One of the bevy of new map-related functionality in Server is the capability to constrain users’ ability to create work activities to certain geographic areas. This is particularly useful for situations where one domain covers multiple service areas that share the same activity templates. A polygon layer, referred to as a district, is used in the Cityworks Designer configuration to limit a user’s ability to create work activities outside certain geographic areas.

work order templates. In some types of similar work activities, the details of the activity may be different based on feature attributes. For example, a tree removal work order may use different crews or equipment depending on the tree’s size or a pump maintenance work order may contain different tasks depending on the pump’s manufacturer. Traditionally, a user would have to look at a feature’s attributes to know which template to select based on the attribute values. Server MMS now supports, through Designer, the ability to group a series of work order templates and attribute value combinations to allow automated selection of the applicable template for each asset. Using the tree removal example, a tree with less than a 6-inch diameter can be removed by a two-man crew and limited equipment. However, trees with 6- to 18-inch diameters need larger crews and trees with more than an 18-inch diameter require specialized crews and equipment. To automate this process, three work order templates are created: Tree Removal under 6 Inches, Tree Removal 6-18 Inches, and Tree Removal over 18 Inches. These three templates are grouped

Server MMS Inbox

Required F i e l d s Everyone has used web applications that require your name, address, or some other data when completing online forms. Cityworks has now joined that list of applications; administrators can set required fields for work activities, and indicate whether the fields are required at the “work completed” stage or the activity closure stage. Embedde d A tt r i b u te E d i ti n g Inspectors are often required to verify or enter geodatabase attributes. Inspection templates can now be designed to display any asset’s geodatabase attributes directly on the inspection form. In addition to limiting which fields a user can edit, the required fields functionality mentioned previously also applies to geodatabase attributes. Attribute - b a s e d T e m p l a te S e l e c ti o n One of the more promising new features in Cityworks is the ability to automatically utilize feature attributes in selecting

Server MMS Event Layers

INPRINT — July 2009

S o f t w a r e U p d a t e ( c o n t .)

together as an automation rule set class called “Tree Removal.” Each template is also associated with up to three attribute values or rule fields from the feature class associated to the template. From the geodatabase, we set an attribute or rule field called DIAM_CLASS. DIAM_CLASS has rule values of <6, 6-18, and >18 that we associate with the relevant template. On-Close A u to m a ti o n Another hidden automation function is the ability to automatically set asset attributes to a work order field value or other predetermined value when the work order is closed. For example, when a street striping work order is completed, the street’s striping condition can be set to “High” and the striping condition date to the work order’s actual finish date. Project M a n a g e r Projects are completely new in Server MMS. Users can now add budgets and nest projects in an unlimited hierarchy. Budgeting can

be performed from either a top-down or bottom-up approach to support both general project planning and specific expenditures allocated to the project from work activities. Contract Manager Complete contract management from design to implementation to individual work order line item expenditures are at the heart of Contract Manager. The management of contracts supports estimating total costs for proposed work orders for the budgeting, RFP, and awarding process. Once contracts are in place, work orders can be directly expensed to one or more contracts. Contract Manager keeps track of estimated, actual, and reported expenses for quick reporting of contract status. Combined Crystal and Cityworks Searches Users can now use the unique search engine tools found in Server MMS and pass the search results to a Crystal Report for enhanced reporting, display, and formatting. Crystal Reports can be either standard system reports shipped with the ESRI software or user-definable. Spotlight Searching Spotlight, the navigation bar search tool, can quickly find service requests, inspections, work orders, and more. Using search prefixes, similar to Google, users can quickly find work activities. For example, entering sr:12345 will open service request #12345. Other prefixes for requests include r & s, work orders includes w & wo, inspections use I, and projects and contracts use p & c. Multiple work activities can be opened by separating ID values with a comma. Users can also submit queries directly to Google using g: . Additional enhancements underway include employee information searching, opening saved searches, and others.

Server MMS Required Fields

Calendar Views of Searches In the next release of Server MMS, search results will be viewable in a calendar format. In addition to viewing work activities through all date fields (estimated, actual, initiated), users will be able to easily change dates by dragging work activities to another date or change start and finish times of activities on a given day. Resource Packets Another upcoming enhancement to facilitate data entry is the addition of Resource Packets. Currently, work crews can be built using the predefined list; however, this list is templatebased. Resource Packets will allow individual users to create lists of employees and equipment they commonly use regardless of the work activity. Resource Packets are userbased lists, rather than template-based, and can be applied to any work activities a user is editing. From within one form, users can enter labor and equipment on multiple work orders at a time.

Server MMS Project Manager

INPRINT — July 2009

Conclusion As you can see, enhancements continue to be added to Server MMS to simplify and improve your work. We hope you find ways to apply these enhancements to benefit your organization. cw

Project Management

Upgrading to Cityworks Server MMS By George Mastakas, Executive Director, Enterprise Solutions, Azteca Systems, Inc.

With Cityworks Server MMS available for more than six months now, many longtime users of Cityworks Desktop are either considering adding it to their mix (and running in a cross-compatible deployment) or migrating over to it entirely. This then begs the question – what’s the process? How do you get there? Last year at this time, we were busy installing early builds of Cityworks Server MMS at a number of targeted test sites. The purpose was twofold… first, to gain an understanding and to experience the performance of the application in a real-world environment and, second, to refine, test, and validate the installation and upgrade procedures. Below is the process that came out of that and some lessons learned along the way. Planning For some, Cityworks Server MMS will be their first foray into deploying a web application with ArcGIS Server. For others, it’ll be familiar territory. In either case, there are a number of considerations to be made. I’ve listed those that are most germane to the process. • Determine your hardware size by identifying the maximum number of simultaneous Cityworks Server MMS users. Important too is to identify any other consumers of the ArcGIS Server license because their use may impact system performance. You may have existing hardware you wish to use and, in this case, it’s important to make sure the specs meet the requirements listed on MyCityworks.com. We also recommend engaging ESRI to help you size and architect your hardware. Web server deployments present a new set of challenges and the appropriate hardware can make all the difference. • As part of the hardware vetting above, it’s a good time to revisit your database server too. A fair bit of Cityworks Server MMS processing happens in the database by the many stored procedures that now exist. • Establish/confirm/revisit your ArcGIS Server licensing. Main thing here is to make sure the number of cores on the machine is represented in your ESRI license.

This will give us an opportunity to identify and address any issues that may arise. It will also give us a chance to acquaint ourselves with your configuration and ready us for the next tasks. • Installation and admin training. Once we’ve confirmed a clean upgrade in our office, we make an on-site visit to install Cityworks Server MMS and upgrade a test copy of your database. An administrative training course is included to walk the administrators through the installation, application configuration, and other admin-level operations, like setting up Inboxes, adding user accounts and security, etc. • The organization spends a period of time familiarizing employees with the application by running through the work processes defined in the Cityworks database. This is an opportunity to identify who the candidate Server MMS users are, as well, to put the hardware through a few tests and verify that there aren’t any looming issues there. • When the organization is ready, we come back on-site and provide “train-the-trainer” training. These sessions focus on end-user functionality, such as creating and processing service requests and work orders, custom inspections, reporting, searches, and map interaction. If the organization chooses, Azteca can also provide training directly to the end users. • Following training, we assist you in rolling out Server MMS. We’ll perform the upgrade on your production database and work alongside your users to assure they’re getting the most out of the software. The process is straightforward, but it’s flexible too. It can be expanded and customized based on the specific needs of an organization. We look forward to upgrading you to Cityworks Server MMS soon. If you have any questions, feel free to contact me directly or contact your account representative for more information. cw

• Plan to have a ‘sandbox’ environment for upgrading to new builds and training new users. We’ve advocated this for some time and, if you don’t have one in place already, it’s a good time to implement one. • Lastly, it’s likely you’ll use your ArcGIS Server license for more broad purposes including other third-party applications. It’s important then to identify any version conflicts between applications that may share the same ArcGIS Server license and put a plan in place to manage these situations. The Upgr a d e The process itself is comprised of tasks that are designed to maximize our respective resources and keep costs low. • Provide Cityworks and GIS databases. We’ll install your data on our servers and run through the upgrade prior to doing it on-site.

INPRINT — July 2009

Client Services

Client Services — Changes Happening! By Wayne Hill, Executive Director, Client & Information Services, Azteca Systems, Inc.

It’s been really great to be involved with the Cityworks Server MMS Rollout Seminars. I’ve enjoyed meeting with many of you and seeing how you are using Cityworks within your organizations. As you know, things are always moving at Azteca. Two big changes have happened over the past several months.

The first was having Steve Thomas move over from the project management group to manage the customer support group. Steve has vast experience within Cityworks and will play a valuable role in customer support. The second one deals with the changes to our business partner program. A partner must be trained before implementing Cityworks. This applies to all of our solutions, not just our core Server, Desktop, or Anywhere products. So say a partner calls in for support on implementing Cityworks Storeroom. They must have attended training in Storeroom in order to receive support on this product. Training is offered via our corporate office in Sandy or remote interactive training (RIT). Contact our Educational Services Manager, John Jarnagin (jjarnagin@cityworks.com), regarding any questions you might have about training. Continue to consult MyCityworks.com for Cityworks technical information. This site is constantly being updated with data regarding Cityworks and how it is integrated with the ESRI solutions, knowledgebase articles, white papers, technical videos, latest software releases, etc. If you need a login, then email us at cwsupport@cityworks.com and we will get you access to this site. cw

Tools and Tips: Knowledg e b a s e A r ti c l e Q 1 0 3 6 6 – E r r o r M essage: Geolocati n g th r o u g h C i ty w o r k s i n Ar c M ap and Cit yworks A n y w h e r e Geolocati n g th r o u g h C i ty w o r k s i n Ar c M a p ( C i tyworks, all versio n s ) In order to geolocate through Cityworks in ArcMap, you must have an address locator present in the .mxd being utilized. If the locator has the words ‘Street’ or ‘Parcel’ in it, then Cityworks will automatically find it. If not, you will be prompted with a pick list by the software to select the desired locator. If you have both a streets and parcels locator present in an .mxd in ArcMap, then the radio button selected under the Locate Using option – Streets or Parcels – will be what “guides” Cityworks as to what locator to reference. If you do not include an address locator in your .mxd in ArcMap, then you will receive the following error message: “There are no address locators in this document.” Geolocati n g i n C i ty w o r ks An y w h e r e ( C i ty w orks 4.5 and abov e ) The same concept holds true in Cityworks Anywhere (an ArcEngine application), but there is one fundamental difference that must be noted. Regardless of the address locator, if any, in your .mxd in Anywhere, Cityworks will always reference an address locator from the geodatabase (SDE, personal geodatabase, and flat-file) and respect whatever ‘Locate Using’ option is selected. Anywhere is programmed to look for any and all address locators present in the geodatabase connection specified under the Cityworks Geodatabase Connection

INPRINT — July 2009

in the Cityworks Desktop Administrator. The geodatabase connection is stored in the registry (HKEY_LOCAL_MACHINE\ SOFTWARE\Azteca\Cityworks – GDBPATH key). The programming logic to read the address locator(s) from the .mxd directly is currently only available in the ArcMap library (not ArcEngine) – meaning that adding an address locator to a map that will be utilized in Anywhere is not required. Please note that this is why an SDE composite locator (which must be currently stored outside of the geodatabase per ESRI restrictions) will NOT work properly in Anywhere. The software will just read the address locators that make up the composite individually in the geodatabase connection based on the locator type specified through the ‘Locate Using’ option. The best practice is to add the desired address locator(s) to the .mxd. This way, Cityworks is provided the option necessary for the address locator(s) to work in ArcMap, where the .mxd will be originally built and possibly tested. Again, Anywhere will search the geodatabase connection for the first address locator (alphabetical order) of the type specified through the Locate Using option – either Streets or Parcels. For more information on geolocators with Cityworks 4.4 and earlier software, refer to Knowledgebase article #10144. cw

C l i e n t S e r v i c e s ( c o n t .)

Steady Growth Leads to Changes in Customer Support By Steve Thomas, Customer Support Manager, Azteca Systems, Inc.

Since 1996 I’ve been privileged to meet many of you as I’ve worked as a project manager for Azteca Systems, Inc. I’ve had the pleasure of helping implement Pipeworks and later Cityworks at many of your sites. With the continual growth of Azteca Systems and the evergrowing number of Cityworks clients, it has become necessary to reorganize Client Services. I’ve been asked to fill the new position as Customer Support Manager. In this role, I’ll have the opportunity to work with our clients on a more regular basis following their initial implementation of the Cityworks software. I’ll also be managing the day-to-day interaction of our customer support representatives as they assist clients with their questions and concerns about the Cityworks software suite. I plan to build on the existing methods and tools that Wayne Hill and the rest of our customer support team have put in place to provide more immediate and complete customer services. The objectives of the Cityworks Customer Support Division are to provide a positive and productive experience for Cityworks users and administrators by assisting in the delivery of bug-free software; providing quick, accurate answers to Cityworks-related questions; and guiding our clients through system analysis to determine causes of site-

specific Cityworks issues. We’re currently working to improve our software testing methods. If our testing efforts are focused and structured, we can assist the Azteca programmers in providing a quality product, which will help the Cityworks users and administrators be more productive. In addition, we’ll continue to provide relevant information about frequently-asked questions and known issues on MyCityworks.com. We plan to provide timely and relevant training to our customer service reps to improve their knowledge and skills in all aspects that affect the configuration and use of Cityworks. I look forward to hearing from each of you about the successes your organizations experience as you manage your assets and your customer expectations with the use of Cityworks software. I also want to hear from you if you experience difficulties with the software that cannot be resolved by our customer support representatives. Please direct those questions and concerns to me, rather than our executive directors. I’ll do my best to address your concerns in a timely and efficient manner. cw

Support Regions

INPRINT — July 2009

C l i e n t S e r v i c e s ( c o n t .)

MyCityworks.com – Help Is Only a Click Away By Greg Walters, Customer Support Representative, Azteca Systems, Inc.

“Ch-ch-ch-changes… “ okay I won’t go any further than that; I’ll leave the rest to David Bowie. That pretty much sums up MyCityworks.com for the next year.

We have some new help videos: • Giving Permissions to Non-Admins • Adding Custom Field Templates • Database Sync Tool

What’s new right now? Plenty… We made a small name change; the “Resource Center” is now “Resource & Download Center.” As the name suggests, all downloads can be found at this link, including help videos, crystal reports, white papers, and software (versions and service packs). You can also download all of our documents here, including “What’s New in Cityworks 4.5 SP4.” When you click on the download link for Cityworks 4.5 Service Pack 3 or 4, you’ll see a new announcement page highlighting important fixes and new functionality in the service pack. This will provide additional information on installing the service pack and discuss important notes – which will be updated as issues arise. NOTE: In order to download Cityworks 4.5 SP3 or 4, first read through the announcement page and then at the bottom you will need to acknowledge that you have read it. You now have the option to download the Cityworks 4.4 Data Models or view them online. Since our last InPrint, we have added 8 new Crystal Reports: • Monthly Mileage Report • Projects with Corresponding Work Orders and Cost Summaries • Street Sweeping • Activity Report • Cost by Asset • Employee Schedule • Water Main Breaks • Scheduled Maintenance

INPRINT — July 2009

A feedback link is found on the bottom right of every page. We want your feedback! Feel free to send me your comments and opinions – good or bad.  Please join us at www.linkedin.com where we have created a user group called Cityworks | Azteca Systems User’s Group. Here you can view current Cityworks news, start a discussion, and even post or view job opportunities. What’s coming? There are a couple of enhancements we are planning in the coming months. The biggest is a change to our Knowledgebase (KB).  We realize the current version is a little slow, hard to navigate and search, not working well with Mozilla Firefox, etc. We hope to have it up and running by the end of this month. Below is a preview of the new KB. The new Cityworks 4.5 Data Models will be available, both online and to download. The help videos will be moved from the main page of the “Resource & Download Center” to a separate page dedicated to just help videos – much like reports. We are looking at converting some of our most popular Crystal Reports to SQL Server Reports. Thanks for your help and patience as we work to improve. forward to hearing from you soon. cw

I look

C l i e n t S e r v i c e s ( c o n t .)

By John Jarnagin, Educational Services Manager, Azteca Systems, Inc.

In response to many client requests to offer Cityworks training in closer proximity to their locations, the Cityworks Campus “hit the road” in May and June of 2009. No, the Cityworks Campus is not like a big Bookmobile (if you don’t know what a Bookmobile is, then either google it or ask your parents.) or a Weinerschnitzel mobile hot dog van that pulls up to a client site and offers training classes at that location with the snap of a finger. If only it were that easy… right? Now that I have your attention, as you attempt to conjure up images of what the supposed Cityworks “Cruiser” would look like, let me explain how it really works.

Many thanks to the City of Sacramento for hosting this event. Thanks especially to Sacramento City employee, Elsie Fong, who worked with me to coordinate and make the arrangements for the regional training. Elsie also gave a very interesting presentation on how the City of Sacramento utilized Cityworks within their organization. Horry County, SC: May 5-7, 2009 The second Cityworks regional training was hosted by Horry County at the Horry County Technology Center in Conway. The weather for this regional training was similar to the weather in California in March… very wet, but coupled with complaints from the Cityworks trainer (me) about the humidity. Training attendees came from several different Cityworks sites, including Georgetown County Water and Sewer, Frederick County Sanitation Authority, City of North Myrtle Beach, and Horry County. Thanks very much to Horry County for hosting this event. The training session was kicked off by Tim Oliver giving a great overview of how Cityworks technology was implemented at Horry County. Another key person to thank is Maria Dolce who worked closely with me to make the training happen and run smoothly. Upcoming Cityworks Regional Trainin g

(Prototype — Not an actual vehicle!!!)

First, a location is considered. The location of the regional training depends on several things; one of those things being the number of current Cityworks sites located in a particular region. Next, Cityworks clients are contacted in the area with the hopes that one of these potential sites has some form of a training facility at their location in which to host the training. Once the hosting site is selected, mailers are sent out to clients in the region and the location information is posted to the Cityworks Campus website. Do you have a need for a Cityworks regional training in your area? Are you aware of other Cityworks sites in your region that could participate in the regional training? If so, please contact me to make a suggestion.

Frisco, TX: August 18-20, 2009 The next scheduled regional training will be held in Frisco, Texas, at City Hall. For more information on this training, please visit the Cityworks Campus site or contact me, John Jarnagin.

Cityworks Administration Training Update We had a great Cityworks Administration Training at Azteca Systems, Inc. company headquarters in Sandy, Utah, on June 1-5, 2009. Training attendees also had the opportunity to go on a moderate hike (considered to be a death march by a few) up beautiful Corner Canyon (near the bottom right of the group photo), which is just a few miles from the Azteca Systems Corporate Offices. Only one snake was spotted, which motivated some of the attendees who spotted it to scamper up the trail a bit faster.

Cityworks R e g i o n a l T r a i n i n g s Sacramen to , C A: M a r c h 3 - 4 , 2 0 0 9 The first Cityworks regional training was hosted by the City of Sacramento and held at their Corporation Yard location. Although it poured buckets of rain during most of the two-day training, all training attendees remained dry inside the training facility. Attendees involved in the training all hailed from California – City of Galt, Citrus Heights Water District, Lake County Sanitation District, and City of Sacramento.

Several of the training attendees also experienced a local eatery, The Bayou, in downtown Salt Lake City on one of the nights as well. The Bayou features excellent Cajun-style food and dozens of great beverage options. It just goes to show that attending Cityworks Administration training is not just information overload; attendees get to take their life in their own hands as they experience the rugged beauty of Utah and sample the cuisine as well.

INPRINT — July 2009

C l i e n t S e r v i c e s ( c o n t .)

Speaking of Cityworks Administration training, a new format was introduced this year. Instead of being required to attend all five days of Cityworks Administration training, attendees can now choose to attend only the core-training block for the first three days of the training, which includes topics such as SQL Server 2005, installing Cityworks, configuring Cityworks Designer, Cityworks Desktop, database diagram review, and a Cityworks Server overview. We wrap up this three-day course by working through some scenarios which encourage training attendees to think outside the box a bit when interacting with Cityworks. The other two days of the Cityworks Administration training are optional and consist of revolving topics being offered each day. During this session, the Cityworks Administration training consisted of the asset reading functionality, which allows cyclical work orders to be created based upon parameters other than just a date such as mileage, runtime hours, or if some sort of threshold has been exceeded like the pressure or temperature, etc. The other half of day four consisted of creating a SQL Server 2005 Express database for use with DataPump and becoming familiar with Cityworks Anywhere. Day five focused on Storeroom, one of the Cityworks add-on products. This product tracks all activity relating to a material from the time it is requisitioned and received into a storeroom to the time it is issued to a work order, employee, etc. – and even if it’s later returned.

a DataPump database, go through the entire process of database synchronization to populate the tables, data creating/editing in the “field,” followed by synchronization back to the main database. • Cyclical Work Orders / Asset Reader covers cyclical work order creation from start to finish, including the new functionality beginning in version 4.3.1 for creating cyclical work orders based on parameters other than time, such as runtime hours, exceeding a temperature threshold, etc. Training attendees learn how to prepare the geodatabase for this interaction with Cityworks and create work order templates to interact with this tool. • Introduction to Cityworks Server. Two versions of this course are available. One version focuses on training attendees who are not familiar with Cityworks technology. The second version is aimed at those already familiar with Cityworks functionality and reviews the differences between Cityworks Anywhere, Cityworks Desktop, and Cityworks Server. The future’s looking bright for training. We hope to train you soon. cw

The next scheduled Cityworks Administration training sessions for 2009 will be held October 19-23 and December 7-11. For more information and to register for these training courses, please visit the Cityworks Campus at: http://www.mycityworks.com/cityworkscampus

Several new Remote Interactive Training (RIT) courses will be added to the Cityworks Campus in the next few weeks. Keep an eye out for these upcoming new web courses: • Introduction to Cityworks Anywhere has two course versions. One course is very in-depth for new Cityworks users who are not yet familiar with basic Cityworks functionality. The second Cityworks Anywhere course is more condensed for experienced Cityworks users. • Cityworks DataPump will be added to the web course offering as well. This course teaches attendees how to create and configure

INPRINT — July 2009

Front Row (L to R): Andrew Schwartz (New Braunfels Utilities, TX), Katy Singer-Browne (The Colony, TX),

Beth Velasco (The Colony, TX), Laura Carr (NTB Associates, Dallas, TX), Dayton Poff (Christiansburg, VA) Middle Row (L to R): Paul Love (West Valley City, UT), Ryan Harris (Azteca Systems Inc. – Trainer),

Silvio Conte (Mecklenburg County, Charlotte, NC) Back Row (L to R): Joe DeLuca (EA Engineering, Sparks, MD), Andrew Miller (Velocitie, Lonsdale, MN),

Matt Kimmer (Township of Grand Blanc, MI), Kurt Knettel (New Braunfels Utilities, New Braunfels, TX), Blake Mize (Azteca Systems Inc.), John Jarnagin (Azteca Systems Inc – Educational Services Manager)

Partner News — Domestic

New Braunfels Utilities, Texas, Embraces Holistic Approach to Integrate Cityworks with Critical Business Systems

Bu s i n e s s Pa r tn e r Manager Becky Tamashasky 574-231-8029 btamashasky@cityworks.com Hi, everyone! I’m back from maternity leave and ramping up again with both the Business Partner Program and Azteca’s international activities. Azteca’s Business Partner Program has undergone modification over the last few months and I appreciate everyone’s patience while we’re working through the final details. Soon business partners will be receiving a finalized and updated overview document to explain the details of the program as well as a letter with the highlights and the corresponding changes for each organization.

By Eric Hrnicek PE, GISP, Linda McCoy PEng, Steven Sushka GISP, Woolpert Inc.

If a kitchen sink was part of New Braunfels Utilities’ (NBU) asset program, they’d have managed to get information to flow directly from that sink into Cityworks! “Anything we can do to minimize manual data input and duplicate data entry… I’m a fan of that,” says Kurt Knettel, NBU’s information technology supervisor. “During requirement reviews at the beginning of our project, we discussed all of our existing systems we could possibly connect to. As it turned out, we’re touching just about all of them with some form of automation.”

There’s also a lot of international activity growing in relation to Cityworks which is really exciting to share!! Azteca just added the first sites in Australia through our Australian Distributor, gViz, in the last month. This is in addition to our current clients in Canada and Sweden and the prospects developing in both South Africa and the Middle East. As the international distributors continue to grow, this helps the development of resources for the entire Business Partner network. If you have any feedback or suggestions related to the MyCityworks.com Business Partner website or the tools and resources included there, please let me know so Azteca can continue to improve support! cw

New Braunfels Utilities is responsible for managing the water, sewer, and electric infrastructure in and around the City of New Braunfels. In 2006, they selected Woolpert to implement Cityworks and integrate it with other critical business systems within their enterprise environment. NBU was looking for a system that was user-friendly, intuitive, and comprehensive which could integrate with their financial, inventory, purchasing, customer information system, timekeeping, and GIS systems. Until then, NBU had been using various methods to track service orders and maintenance activities—hardcopy logs, Access databases, and Excel spreadsheets as well as work orders within their customer information system. They logged inventory and financial transactions in an HTE system and kept asset inventory information in an ESRI ArcSDE geodatabase. These disparate systems and processes were not providing them with the accuracy and efficiency they needed to track and manage their fixed assets to easily comply with and report on GASB 34/35 requirements.

NBU Dispatch Center

What NBU has now created is a more centralized enterprise work order management system that integrates with their other critical business systems and helps provide a more holistic means to manage its infrastructure, not only for maintenance purposes but also for fixed asset accounting and management. Azteca’s Service Request API creates service requests automatically in Cityworks for various types of customer calls logged into the Harris NorthStar Customer Information System running on an Informix database. NBU decided against

INPRINT — July 2009

P a r t n e r N e w s — D o m e s t i c ( c o n t .) replacing Harris with all of its ties to customer data and billing history, but they didn’t want to have customer service representatives enter call information in both Harris and Cityworks. Where NBU used to print orders from Harris and fax them to the maintenance shop, communication is now handled automatically. A listener service frequently queries the Harris database for new calls. When a particular call type is detected, Azteca’s API creates the service request in Cityworks. Default “Assign To” associations and email notification within Cityworks do the rest.

NBU Electric Trucks

A series of SQL procedures and functions link Sungard HTE with Cityworks to access and manage material data. Field crews provide a Cityworks work order number to the warehouse staff who record the number in HTE when they issue the parts or the purchase order. The programmatic interface periodically queries the HTE (DB2 database) via ODBC links to obtain updated material costs and descriptions, as well as automatically assigning the material to the proper work order and eliminating the need to input material usage information directly into the Cityworks user interface. Similar to the material costs and material transactions, payroll and timesheet information is transferred from the timecard system managed online by ADP. Given the approval process required with timesheets, this process is more traditional. Timesheets are processed after they are approved every two weeks. The integration saves managers the time of entering the details of who worked on what job and for how long. Every user already inputs their time into the timesheet system; now they simply enter the work order number on which they are working as they fill out their timesheet and the integration does the rest. Another integration point for the field crews involves the use of purchase cards. Just like your credit card statement at home, purchase card transactions are downloaded from the bank each month. As purchases are made in the field, receipts are saved and recorded with a work order number. The automated portion of the process imports the purchase card transaction and dollar amounts into Cityworks as actual material for the applicable work order—once again, eliminating

INPRINT — July 2009

the need to enter material usage information directly into Cityworks. One of the primary motivations for implementing GIS and Cityworks was to bridge the gaps between the costs of capital, O&M, and the general ledger. As assets are retired, the work and material costs associated with the installation factor into the residual value to be written off the books. Accountants need to know the value of each asset to properly determine and report financial status. This project provides a link between the accounting system and the GIS via a custom Accounting Unit database and application to determine the type and age of an asset as it is retired from service. Virchow Krause & Co., an accounting and auditing firm, helped guide NBU, Woolpert, and Mandler Consulting down a path of accurate and sustainable accounting practices to piece together the necessary integration. “This is part of a big-picture strategy for us to eliminate the use of local spreadsheets and paper documents to track our fixed assets and continuing property record,” states Al Kaufmann, Executive Director of Business Services. “These integration pieces between Cityworks, GIS, HTE, and payroll help us achieve our goals. A key decision was also made in 2006 to utilize a work order management system that provided excellent workflow tools for facilitating field work and ensuring that completed activities were correctly tracked and reported within our Fixed Asset and Continuing Property record systems. The Cityworks implementation has put the best tools in the hands of our field personnel and has become a great success for them.” Field crews at NBU are getting used to using Cityworks on their laptops. Each morning, DataPump synchronizes the laptops to prepare them for the day’s assignments. Because custom integrations handle material and labor hours for each work order, field crews are left with the very simple task of setting the status of work tasks and work orders to “complete” before moving on to the next piece of work. NBU is now well on its way to reaping the rewards of a centralized and integrated enterprise architecture that streamlines business processes and allows staff to more efficiently track and report on maintenance and fixed asset accounting activities. cw

Event Layers

Cityworks Server MMS Group Seminar This spring more than 400 users attended our nation-wide Cityworks Server MMS Seminar / User Group Meetings. On average, roughly 45 people participated in one of the daylong gatherings. The feedback was tremendous and many found these a valuable substitute to our annual User Conference. At the seminars, we showcased the new Cityworks Server MMS application along with the vision and future of Cityworks, and new technology, such as the calendar tool, enhanced event layers, Desktop/Anywhere enhancements, and Cityworks Permitting. We also provided technical information on how to upgrade and an overview of our Clients Services. Special thanks to our user case-study presenters who shared their experiences. And of course, thanks again to all who attended and our valued business partners who helped make this possible.

Rollout/User Series

Cityworks Server MMS Rollout / User Group Seminar

Thank you to our sponsors!

Premier Sponsor

OneGIS THE POWER OF

ONE PLATFORM, ONE SOLUTION, ONE COMPANY...

P a r t n e r N e w s ( c o n t .)

Business Partners Implementation Partners PLATINUM • Woolpert

GOLD

SILVER

• Short Elliott Hendrickson (SEH) • Timmons Group • Velocitie Integration, Inc.

• Jones, Edmunds and Associates • Motorola • OneGIS, Inc.

BRONZE • • • • • • • • • •

Bowne Management Systems, Inc. Burk-Kleinpeter, Inc. Burns & McDonnell CH2M Hill, Inc. Civic Engineering and Information Technologies, Inc. Civil Solutions Collier Engineering IT Nexus Midland GIS North Arrow Technologies

• • • • • • • •

Anderson, Eckstein & Westrick, Inc. Bergmann Associates BP Barber & Associates Chester Engineers Clark-Nexsen EMH&T geographIT Jones & Demille Engineering

• • • • • • • • • •

NTB Associates OHM, Inc. PACE Engineers, Inc. Schneider Corporation Strand Associates, Inc. Tetra Tech Vanasse Hangen Brustlin, Inc. (VHB) VESTRA Resources, Inc. Wade Trim Associates Westin Engineering

BASIC

• • • • • • • •

KCI Technologies Malcolm Pirnie, Inc. Michael Baker Jr., Inc. PSOMAS Quartic Solutions Razavi Application Development Stantec Consulting Weston Solutions

Strategic Development Partners • • • • • • • • • • • • • •

Actsoft CartoPac Field Solutions CIPPlanner Corporation Cobra Technologies CompassCom Coulter Mapping Solutions DataBank IMX Data Transfer Solutions Dig-Smart Dynatest ESRI GEOSPAN Corporation Infrastructure Technologies iWater

• • • • • • • • • • • • •

Laurel Hill GIS Marshall GIS MWH Soft Onbase (Hyland Software) Orion Technology Inc. Peninsular Technologies, LLC Pipelogix RIVA Online RouteSmart Spatial Wave TC Technologies Televent Miner & Miner TRANSMAP

International Distribution Partners • • • • • • • •

ESRI Canada ESRI Costa Rica (Geotecnologias SA) ESRI Israel (Systematics) ESRI S-Group, Sweden GIS-Centric Civil Systems Pty (Ltd), South Africa gViz Pty Limited, Australia OneGIS, Carribbean Rolta Middle East FZI-LLC

INPRINT — July 2009

P a r t n e r N e w s — D o m e s t i c ( c o n t .)

Westin Develops Multiple Cityworks Integrations, Leveraging Strengths of Applications By Glenn Wolf, Westin Engineering, and Lindsay Ferguson, Azteca Systems, Inc.

Many utility business processes require the same data in different systems, for different users, all at the same time. In many agencies, this requirement means that the same data must be entered by hand into two or three information systems whenever data is added or changed. An effective way to streamline this effort is to link commonly-used data between systems. This “data integration” reduces administrative effort, improves data quality, and speeds up the time required to complete many routine business processes – in some cases, cutting the total process time from days to minutes. Westin Engineering, a longtime Implementation Partner of Azteca Systems, has worked with several water utilities to develop integrations between Cityworks and systems used for finance and customer service/ billing such as Springbrook® and Cogsdale CSM®. Organizations, such as Marina Coast Water District, Sacramento Suburban Water District, and Citrus Heights Water District in California and North Penn Water Authority in Pennsylvania, are reaping the benefits of improved processes and better data quality.

Through full system and process integration, the architecture improves customer service and maintenance management processes by streamlining processes from days to minutes.

Prior to using Cityworks, Marina Coast Water District (MCWD) utilized Springbrook to manage both financial information and service requests for its 8000 customer accounts. When the District implemented Cityworks for asset maintenance management, they were able to use each system for its best features. As part of MCWD’s implementation, Westin developed an integration between Cityworks and Springbrook to automate digital data movement between applications. This bidirectional integration occurs in near real-time for service order data and every morning for customer information and other related data. MCWD’s resulting solution leverages Springbrook’s strength of managing customer data and Cityworks’ strength of managing critical asset data through service requests and work orders. The integration saves the District substantial time by eliminating duplicate data input into both systems, thereby increasing both the efficiency and accuracy of their processes. Westin is also currently working on other integrations at Marina Coast to leverage Cityworks Anywhere which will allow customer and meter data to be pulled into the GIS so the information can be viewed on the map as a feature. This will allow field service crews to view meter reads and meter data within the integrated map environment. Westin created a similar integration at Sacramento Suburban Water District (SSWD) to streamline business processes required to manage 45,000 customer accounts. The integration developed at SSWD utilizes Cityworks together with Cogsdale CSM (customer records and billing) and Microsoft Great Plains® (financial management). The CityworksCogsdale integration imports all inventory, equipment, and projects into Cityworks each morning, allowing accurate costing and budgetary analysis on Cityworks’ work orders. The District also uses AirLink®, an automatic vehicle locating (AVL) system, which imports truck speed and location data into ESRI’s ArcSDE, presenting real-time locations of maintenance vehicles on a map visible to customer support and other staff to aid in dispatch.

Customer calls and reports a leak. Customer service creates service order and enters data into CIS.

At North Penn Water Authority, Westin integrated Cogsdale and Cityworks. At North Penn, however, the integration was extended to link Cogsdale and Cityworks’ service requests and work orders. The integration utilizes custom fields for work orders, allowing input of tailored and specific data. When a work order is completed and closed, the fields are imported into the matching custom fields in its parent service request. Normally, images attached to service requests and work orders must be manually attached one by one. Westin has created a repeatable integration that is utilized by all of its Cityworks clients. This integration regularly scans a shared drive for new images or other attachments. The scan picks up any images that were imported from digital cameras or document libraries and automatically attaches these files to the appropriate service requests or works orders. Continued on page 26

INPRINT — July 2009

Partner News — International

City of Kitchener, Canada, Achieves Enterprise Success ESRI Canada

The City of Kitchener is centrally located in the heart of Southwestern Ontario in what’s known as Canada’s Technology Triangle. With a population of over 200,000, Kitchener has emerged as an innovative, creative, and culturally-diverse city. On December 1, 2008, the City of Kitchener achieved a significant milestone in its technological journey through the implementation of an enterprise-wide infrastructure management solution. This marked the day that the fully-integrated system – consisting of ESRI’s GIS software, Azteca’s Cityworks, SAP, and RIVA Modeling software – went live. It also represented a significant achievement for the forward-thinking, multidepartmental implementation team who developed a solution that will be relied upon by the City for years to come. Project planning began around 2005, when aging and largely unsupported legacy financial and work-order management systems were earmarked for replacement. The existing Integrated Infrastructure Management Solution (IIMS) had been in place for almost 15 years and was fraught with issues including a lack of integration with financial and work order subsystems, duplication of data entry and record-keeping, reliance on paper-driven, manual processes, and system instability. Another key driving factor was the introduction of Public Sector Accounting Board (PS3150) regulations that require asset information to move efficiently between operational and accounting systems for all local government. The Financial, Utilities, and Operations Departments partnered with IT to develop a Concept of Operations document for each system. The City then selected IDS Sheer to develop a fully-integrated solution that would interface SAP financial systems with the Cityworks service request and work order management system, and RIVA Modeling software for decision support and asset accounting.

The implementation task force, comprised of six senior management staff, recognized a need to “keep it simple” to ensure that integration requirements would be achievable and sustainable. Working within this framework, the software blueprinting phase was completed in a few months and the benefits were seen downstream in the process through simpler development and testing phases. The City’s approach to technology ensures systems are aligned wherever possible, which enables seamless integration with payroll, fleet management, cashiering, and specialty accounts receivable systems. The GIS component of the solution is also leveraged for facilities management, something not typical of standard municipal applications. The City’s centralized GIS and IT strategy coupled with solid teamwork between the core project team, ESRI Canada’s Professional Services Team and Loki Innovations made it possible to complete the project one month earlier than anticipated and on budget. As a result, staff in Operations, Utilities, Engineering, Facilities Management, and Finance work from the same GIS data which allows them to make operational and strategic decisions based on information that is synchronized across corporate systems. Kitchener’s enterprise infrastructure management solution was the largest integrated software and hardware implementation in the history of the City and is without question a tremendous success. Several critical success factors led to achieving a high level of excellence including a well-planned selection process, alignment with existing IT strategies, a clear focus and realistic objectives, well-executed project planning, ongoing corporate support, secure funding, adequate staff resourcing, and dedicated vendor support. Most significantly, the project has set a benchmark of excellence that will be used for future projects as the City moves forward. cw

About ESRI Canada ESRI Canada provides enterprise geographic information systems (GIS) solutions that empower businesses, governments and educational institutions to make timely, informed and mission critical decisions by leveraging the power of maps. The company distributes the world’s leading GIS software from ESRI, Miner and Miner, Azteca and other technology partners. ESRI Canada serves over 8,000 customers from 16 regional offices across Canada.

INPRINT — July 2009

P a r t n e r N e w s — I n t e r n a t i o n a l ( c o n t .)

The Parklands Foundation – First Cityworks Site in Australia Jason Grech, gViz, Australia

The Parklands Foundation is the first Cityworks site in Australia, providing GIS services to its parent organization, the Sydney Olympic Park Authority (SOPA). In an agreement between the Parklands Foundation and SOPA stakeholders, the Foundation will provide Cityworks to SOPA. The initial focus is on Sydney Olympic Parks wetland assets as part of an effort to protect, maintain, and enhance the Parklands as a means of promoting its recreational, historical, scientific, educational, and cultural value.

asset data in our GIS. Cityworks provides us with the increased value from our GIS and now we can actually deliver day-to-day operational management of Sydney Olympic Parks assets through Cityworks.” cw

As an Azteca business partner, gViz has been contracted to provide an ESRI-based asset management system and chose Cityworks as the system to fit Parkland’s needs managing the wetland asset inventory, reporting of the KPI (key performance indicators) associated with the wetlands, and providing capabilities to manage all asset work activities and contractor management associated with the wetlands. David Kirkland, Knowledge Manager at the Parklands Foundation, reports, “The gViz solution of Cityworks, being an ESRI extension, is a logical and powerful solution for us. The Parklands Foundation and SOPA are longtime users of ESRI technology and we already have our

Thiess & Cityworks to Manage Largest Infrastructure Project in Australia Jason Grech, gViz, Australia

Thiess has chosen Cityworks, contracted by Azteca business partner, gViz, to manage the largest transportation project in Australia – the $4.8 billion Brisbane Airport Link. As the most significant infrastructure program in Australia and part of South East Queensland Infrastructure Program and Plan (SEQIPP), Thiess selected Cityworks as the solution to best meet their needs for this significant project. The project’s intended scope for Cityworks is to manage assets both during construction and afterwards for the operational maintenance of the road corridor from the Brisbane Airport to the CBD (Central Business District). Being a GIScentric system, Cityworks is easily integrated into all GIS operations at Thiess to maintain the site’s project asset inventory. Management of the asset inventory will provide Thiess with the knowledge of where assets are being built, particularly since much of the project consists of underground tunnels.

INPRINT — July 2009

Knowing what equipment, labor, and materials are used enables tighter fiscal control on operations and better tracking of where costs are being incurred – knowledge which is vital to the ongoing maintenance and valuation of the assets. All costs associated with the development and maintenance of this infrastructure will be easily available throughout the organization through Cityworks, providing transparency and accountability in the successful management of Queensland’s most significant infrastructure project. Throughout the period of just five days, gViz provided complete administration and end user training for the project. Internal staff will use this knowledge to configure Cityworks to meet their needs. The Cityworks’ approach to building and managing the development of infrastructure will add great value to the corporate appreciation and innovation of GIS technologies by leveraging the GIS and delivering real, tangible business processes. cw

About gViz gViz is the provider of ESRI based GIS Solutions, Enterprise Consulting and Professional Services. Passionate about the application of GIS technology, with 18 years of experience in GIS and Surveying. gViz is committed to using GIS technology to enable better decision making through geographic visualization resulting in increased effectiveness, organizational value, and appreciation for GIS. www.gviz.com.au

Regional News Executive Director of Sales & Marketing Tom Palizzi 303-467-2738 tpalizzi@cityworks.com

Half of 2009 is in the history books and in spite of a tumultuous economic ride, we’re all still here doing the best we can. I sincerely hope you all are faring well – in good health and good spirits! Though we planned on a ‘softer’ year for 2009 – given the current economic situation, ironically we’re experiencing continued growth. Naturally, we thank you all for your confidence in Cityworks and our ability to assist you. Of course, thanks also goes to our dedicated network of business partners as they have certainly worked hard to ensure your continued success. As a result of feedback we received from many of you, we thought it a brave and challenging thing in postponing our annual Cityworks User Conference. In lieu, we ‘took the show on the road’ in the form of our Cityworks Server MMS Rollout / User Group Seminars. In essence, we brought the first-day format of our annual meeting to eleven cities across the U.S. Turnout was well beyond our expectations and the feedback was amazing! Though we wholly intend to return to business as usual with an annual conference, we encourage you to keep the local user group idea alive to help each other realize the many benefits of Cityworks. On the marketing front, we’ve been busy revamping our collateral and will soon be launching a new web page. Meanwhile, our Account Managers are busy visiting an everincreasing array of customers from coast-tocoast and around the world. You can likely run into them at local events near you. In any case, please let them know how they can help! This year’s conference season finds us at the annual AWWA ACE Show (San Diego, California, June 13-17), ESRI User Conference (San Diego, California, July 13-17) and APWA Exhibition and Congress (Columbus, Ohio, September 13-16). If you are there, please stop by and see us. In the meantime, have a great summer! cw

National Sales Manager – Southern Region

Southwest Region

Brent Wilson

970-471-5666

214-507-0579 bwilson@cityworks.com

wlang@cityworks.com

Summer is in full swing – trees are full of leaves, grass is green, and flowers in bloom. Work is being done with city and county infrastructure all across the country. I know my perspective is no doubt skewed in that I notice roads being fixed, water pipes being replaced, and signs being repaired. All the while, I can’t help but think Cityworks!

Greetings to everyone in the Western Region! It sure has been a busy first half of 2009 – I can’t believe summer is already here!

By now, we all know billions of dollars are spent on infrastructure every year to keep things running smoothly. Things we take for granted: clean, available water; smooth roads and highways; taking a walk in a safe, clean park; and when we flush, things go away! In our industry, we know it takes work – time, money, and people dedicated to their jobs to meet the expectations of our constituents. I like to think Cityworks truly helps you all meet these expectations. With Cityworks, customer service flows smoother, work activities are more efficient in both time and labor, and communication between departments can be realized – creating a better today and a better tomorrow. For all of our clients, I encourage you to think of new ways to use Cityworks to make a difference. And if you’re not a client, I would certainly look forward to helping you join the Azteca family! cw

William Lang

I would like to thank everyone who attended the Cityworks Server MMS Rollout Seminar and Regional User Group meeting in Sacramento, CA. We had a great turnout and great participation. I especially would like to thank Elsie Fong for all of the time and effort she put into hosting the event. The event was very successful and I look forward to seeing you all at similar events in the region this fall. I would like to welcome our newest regional client, Chugach Electric Association located in Anchorage, AK. CEA is our first client in Alaska – hopefully many more to follow! Velocitie Integration worked with Chugach to implement Cityworks beginning in February. CEA went live on schedule in May. Congratulations CEA and Velocitie. As expected, 2009 has turned into another exciting year for Azteca Systems! If you are interested in helping arrange a local user group meeting in your area, please let me know. Thanks again everyone and I look forward to visiting with you this summer! cw

INPRINT — July 2009

R e g i o n a l N e w s ( c o n t .)

Northeast Region

Southeast Region

Northern Region

Phil Mogavero

Dave Bramwell

Josh Stroessner

716-667-6987 pmogavero@cityworks.com

919-339-8642 dbramwell@cityworks.com

920-254-1112 jstroessner@cityworks.com

Another busy season here at Azteca and I hope you are all well. There are many great things to look forward to with Cityworks while our user community grows bigger and stronger every year. Cityworks Server MMS is moving full steam ahead and is looking better than ever. I encourage anyone who would like to see a demo to please contact me.

It has been a busy year and much is happening in the Southeast Region. As I approach my one-year mark with Azteca, I reflect on the many places I have been and the many people I have met. The Cityworks network of customers is one of the reasons that Azteca System’s reputation is so good. It’s the word-of-mouth reputation that keeps us account managers hopping around. We certainly appreciate your positive references. I would like to thank those customers that have offered site visits to their organization. These site visits are invaluable for some that want to see real operational experiences as they consider Cityworks.

I realize that the economic climate has put a crunch on budgets, but now is the time to keep a positive outlook and focus on the future, making both your work – and home – a more effective and efficient place. I hear more and more organizations are looking to grant funding to help sustain business and possibly expand your Cityworks operation. The process is competitive with the increase of organizations applying, but the good news is that more funding is becoming available. I would like to point out a few areas that the new Recovery and Reinvestment Act of 2009 addresses: • $1.5 billion for competitive grants to state and local governments for transportation investments • $500 million to institutions of public education, local governments, municipal utilities, and higher education for grants for energy efficiency innovative technologies projects and loans for designing and implementing sustainable energy infrastructure projects • $6 billion to the Clean Water Revolving Fund for revolving loans which finance publicly-owned wastewater infrastructure improvements • $2 billion to the Drinking Water State Revolving Fund for revolving loans to finance drinking water infrastructure improvements You can learn more at www.recovery.org. Take time to monitor your state and federal agencies for grant and loan opportunities as these are very competitive and sometimes only available for a given time. Have a great summer and, as always, please let me know how I can help you! cw

INPRINT — July 2009

Cityworks Server MMS is now well in the spotlight as a new product offering to the Cityworks suite. Some of you are either already migrating to Cityworks Server MMS or making plans. Many of you came to see Server MMS at one of our Regional Rollout Seminars and I thank you for attending. If you are considering Server MMS, I can help you evaluate the benefits for your organization. Please contact me if you need more information or would like to see a demonstration. Azteca’s Enterprise License Agreements (ELA) has also stirred a lot of excitement. There are several customers in the Southeast region that are on an ELA with Azteca and ESRI, affording them unlimited use of Cityworks and ArcGIS. I can help you evaluate near and long-term options as you consider fixed (named) licenses, a site license, or an enterprise license. Please contact me if you would like to do a license agreement evaluation. Thanks again for your enthusiasm and contributions to the Cityworks user community. I hope to see you soon! cw

Hello! I hope you all are enjoying this early summer! For these northern states, it couldn’t have come soon enough. I’m glad I’ve had the opportunity to visit or meet many of you at the Server MMS Rollout Seminars. These seminars were a huge success and the turnout was very impressive. Thanks for coming! It really speaks to the dedication of Cityworks users and the overall enthusiasm for our new product. I would like to thank Maria Renzetti, Cyndy Barney, and Brandon Brown from the City of Dublin, Ohio; Amanda Ault from the City of Evanston, Illinois; Cindy Hintze from the City of Coon Rapids, Minnesota; and Frank Fisher from Waterford Township, Michigan, for doing the User Presentations at the Server MMS Seminars. Nice work all – very enlightening. On behalf of everybody here at Azteca, I would like to welcome Racine, Wisconsin, and Cincinnati, Ohio, to the Cityworks user community. They will both be implementing Cityworks Server MMS. I would also like to congratulate Canton Township, Michigan, on their recent site license upgrade. Once again thank you all for your continued confidence, and I look forward to seeing you in my travels this summer! cw If you are interested in submitting an article for InPrint, please contact Kaye Ryser (801) 523-2751 or kryser@cityworks.com

WELCOME NEW CITYWORKS USERS! Berkeley County Water & Sanitation, SC

Parklands Foundation, Australia

Chugach Electric, AK

Racine, WI

Cincinnati MSD, OH

South & Center Chautauqua Lake

Eskilstuna Kommun, Sweden Lafayette Consolidated Government, LA

Sewer District, NY Thiess Pty Ltd, Australia

Oakland County, MI

Get to Know.....

Project Managers Azteca Systems maintains a staff of innovative, knowledgeable professionals that know how to get the job done. Proven over and over again with successful implementations around the world, our project managers and technicians are there to support each project from start to finish and then some.

George M a s ta ka s , E x e c u ti v e D i r e c to r Enterpri s e S o l u t i o n s • Born in Salt Lake City, Utah. • Has lived in Salt Lake City – except for the 2½-year period when his parents had a midlife crisis and moved the family to Greece where they’re from . • Graduated with a BS in geography from the University of Utah. Brian Haslam was his geography professor, Steve Thomas (grad student) was one of his instructors, and Wayne Hill was one of his TAs (“I was his favorite… bothered him for something every 5 minutes, and you know what? I still do!”). Tom Palizzi was the university’s ESRI account rep who came by selling Unix ArcInfo licenses. (“We students would gather around him and be mesmerized by the ‘guy who worked for ESRI.’”) • Enjoys cycling. (“In the ‘90s it was mountain biking. Now it’s all about the road. I have a mania with wheelsets. I have five sets of French-made wheels (Mavic) but use two of them. I’m looking to buy another set soon. Italian this time. Like their shoes, Italian wheels are stupore! BTW, my wife thinks I have three sets, so let’s keep this between us – ok?”) • Interesting sidelight: “After 4 years of attendance, I was still a sophomore so I decided to major in geography because it required the least amount of credit hours. Never thought I’d wind up working in my field of study, but there’s something about maps…”

Steve Thomas (Recently accepted a new position as the Customer Support Manager – see page 6) • Born in Burley, Idaho; grew up on a dairy farm with six siblings. (What a cutie-pie!) • Has lived in Idaho, South Korea, Houston, and Utah. • Graduated with a BS from Brigham Young University (BYU) and received his MS from the University of Utah. • Enjoys hiking, gardening, traveling, and spending time with his family, including his 6-month-old grandson. • Interesting tidbit: Currently spends most of his spare time working with youth groups at church and at the local Boy Scout council and district. (This might have something to do with having three sons and no daughters.)

David Hansen • Born in Walnut Creek, CA. • Has lived in California, Ohio, and Utah. • Attended Diablo Valley College (DVC), transferred to and graduated from BYU with a BA in geography and minor in communications. • Enjoys collecting and listening to music, reading, and writing. • Interesting fact: “I somehow managed to finagle an interview with Douglas Adams (when he was still alive) for the high school newspaper when he was in Berkeley for a book reading.” (Douglas Adams, creator of The Hitchhiker’s Guide to the Galaxy)

Adriana Avirvarei

David Ho r t o n • Born in San Jose, CA. • Has lived there and here in Utah. • Attended West Valley College in Saratoga, CA, and San Jose State in San Jose, CA. • Enjoys wakeboarding, fishing, racquetball, photography, and golf. • Interesting tidbit: “I’m not an interesting person.” And his brother, Carl Horton, agrees! (Typical brother response. )

• Born in a small, historic mountain city in the “far north land” of Romania. When I travel back home, it takes me one day to drive from Bucharest.  • Has lived in many places in Romania, also in Ohio and Arizona. • Graduated with a Master’s degree in Electrical Engineering from Technical University “ G. Asachi” Iasi in Romania at age 23. • Enjoys nature – also walking, hiking, playing tennis, admiring the wildlife (birds are my favorite), reading, and traveling for pleasure. • Interesting tidbit: I like warm weather, 100+ degrees. Yeah, Arizona!!!

INPRINT — July 2009

G e t t o K n o w . . . (cont.) M a tt H a r m a n

Ryan Miller • Born in Pocatello, Idaho, and grew up in Idaho Falls. • Has lived in Idaho, Arizona, Norway, and Utah. • Graduated with a BS from Westminster College in Utah and MS from Arizona State University. • Enjoys cycling, climbing, and camping. • Interesting tidbit: “I’m actually 126 years old.” (When asked if that was in dog years, he said, “Nope, just eat right, exercise, and take care of my skin.”) A thorough investigation revealed an unenhanced photo of Ryan. 

• Born in Logan, Utah. • Has lived in Salt Lake City, Southern Spain, and Saratoga Springs, Utah. • Graduated with a BS in civil engineering from the University of Utah. • Enjoys landscape photography, building and flying model rockets, woodworking and building furniture, and spending time with his wife and 2 kids at the park or in the backyard. Loves Utah’s outdoors; hiking, fishing, and camping, especially in southern Utah’s red rock country. • Interesting tidbit: I’m still thinking ???? (But for now… the logo used for the upcoming 2010 Cityworks User Conference in St. George, Utah, was adapted from one of his photos of Zion National Park.)

Will Schm i d t • Born in Placerville, California. • Lived in California, Virginia, Oregon, Wisconsin, Michigan, and Provo, Utah. • Attended Linn-Benton Community College in Albany, Oregon, as well as Bay De Noc Community College in Escanaba, Michigan, before transferring to BYU, where I graduated in Geographic Information Systems. • Hobbies: Plays the bass guitar in a local rock band; also plays the piano and the tuba. Enjoys fixing cars. • Interesting fact: “I lost 85 pounds after graduating from high school.”

INPRINT — July 2009

Raj Patil • Born in Bombay (now Mumbai). • Lived in India, Caribbean (Jamaica, Trinidad & Tobago, and the Bahamas), San Francisco Bay Area, Chicago, Michigan, Southern California, and Northern California (Sacramento Area). • Graduated from Wayne State University in Detroit, Michigan. • Enjoys traveling, music, sports, and community work. • Interesting experience: “Hiking up the Blue Mountains in Jamaica – seemed like I had clearly overtaken my physical abilities to get to the top, but never really felt tired. Only nature can afford such therapy?”

Azteca News

Azteca Systems Named ESRI® Business Partner of the Year ESRI Honors Azteca with Third Prestigious Designation Environmental Systems Research Institute, Inc. (ESRI) recently named their 2009 Business Partner Award Winners, recognizing Azteca Systems as the State and Local Government Industry Award Winner. This international award recognizes Azteca as a partner consistently maintaining a strong, dependable, and successful relationship with ESRI through hard work and dedication. Azteca received the ESRI Foundation Partner of the Year Award in 2000 and 2005, marking this as the third designation they have received from the renowned industry leader.

– from asset management to vehicle routing. While our competitors have to build many of these same capabilities, Cityworks works directly with the geodatabase with real-time access to ArcGIS functions. Only Cityworks is truly built on this precept and technology and is certified by the NAGCS (National Association of GIS-Centric Software) as an ESRI Authorized Developer.” cw

Brian Haslam, President of Azteca Systems, received the award from Mr. Jack Dangermond, President and Founder of ESRI, at the annual ESRI Business Partner Conference in Palm Springs, California, on Saturday evening, March 22, 2009, at the Palm Springs Convention Center. The award represents the commitment of a strong partnership between the two organizations with many more anticipated business collaborations to come in the future. “We’re excited and proud to receive this distinguished award from ESRI,” commented Brian Haslam. “Cityworks is built to leverage the GIS data created by organizations using ESRI’s products and is built on top of their leading ArcGIS software. The tools inherent to ArcGIS enable maintenance management with unique and powerful capabilities

Brian Haslam, President, Azteca Systems; Jack Dangermond, President, ESRI

Congratulations to Our Four Azteca Graduates! Your diligence and hard work paid off!

Will Schmidt, Paul Thomas, and Cara Haslam GIS, Brigham Young University

Randall Sutton Computer Science, Utah Valley University

Welcome to Azteca’s Newest Employee! Blake Mize joins Azteca as a part-time employee working in the Customer Support Group. He is currently attending the University of Utah and plans to graduate spring or summer of 2010 with a double major in geography and environmental studies with a GIS certificate. On GIS day last fall, Carl Horton gave a presentation to GIS students on pursuing a

career in GIS. It ended up being worth 5 test points—and a job. He grew up with an older sister in the Houston area where most of his family still resides. He loves the outdoors and his hobbies include golfing, snowboarding, running, and playing with his new boxer puppy, Mac. cw

INPRINT — July 2009

Mesa, AZ (cont. from page 1) Planning & I m p l e m e n ta t i o n Mesa began their search for an asset management system in 2005. During that time, Motorola’s Public Service team and the City of Mesa met periodically to discuss how Cityworks might handle some of their maintenance tracking and reporting needs. These meetings resulted in an RFP being released in the summer of 2006. After many months of deliberation and consideration, Mesa decided that Cityworks coupled with the Motorola implementation team would be the most effective solution for their requirements. In mid-June of 2008 after the 22-week project implementation cycle was completed, the City of Mesa Transportation Department successfully went live with the Cityworks application. The project was completed on schedule and within Mesa’s allocated budget. The entire project team worked diligently and the outcome was successful, especially considering the initial system supports over 125 Cityworks and Storeroom users and contains over 30 different service request types and over 100 work order types. The following is a list of just some of the types and quantities of assets Mesa is now managing using the Cityworks application: • 30,704,624 square yards of paved roads • 945,680 square yards of unpaved roads and alleys • 10,275,528 square feet of landscaping • 1265 centerline miles of street sweeping • 1513 lane miles of mainline striping • 7727 pavement markings • 57,894 traffic signs • 377 traffic signals • 37,516 streetlights • 13,208 storm drain facilities • 130 bus shelters Derek Witting, Mesa’s Field Operations Superintendent for Transportation relates, “It is a huge benefit to finally have a centralized system to track our maintenance operations. The system has enabled us to be more proactive in coordinating our activities and assists in identifying and avoiding conflicts.” Expansio n The success that the Transportation Department enjoyed with the initial deployment translated into planning the rollout of the Cityworks system to Mesa’s Utilities Department. Mesa has since upgraded to a citywide

Ken Bohannon, Sr. GIS Specialist, Performing QC on a work order for a sidewalk asset.

site license of Cityworks and has scheduled the system expansion into Utilities. In the spring of 2009, the Motorola and Mesa teams once again collaborated to configure and plan the implementation of Cityworks across parts of the Water Resources and Energy Resources (Gas and Electric) Departments within the City. In addition, Cityworks has been integrated with the City’s Customer Information System (CIS) for the purpose of updating caller information on service requests. The initial implementation effort combined with the expansion in Utilities will add hundreds of users to the system and will demonstrate Cityworks’ flexibility across multiple departments within an organization. Summary Throughout this entire software implementation process, Mesa has continued to research and challenge the capabilities and expandability of the Cityworks application. To date, many product enhancements to Cityworks and especially to DataPump have come to fruition as a result of the hard work, communication, and dedication between Mesa, Motorola, and Azteca Systems. And Mesa has no plans to remain content. In the coming months, planning discussions may commence to bring Cityworks into other City departments as appropriate. cw

Motorola Public Service is the only authorized distributor for Azteca System’s Cityworks asset management solution for large accounts in the United States. This seven-year partnership includes several implementations of the Cityworks system in cities and counties throughout the United States.

Daniele Darnell, Admin Support Assistant, creating a service request while on the phone with a customer.

INPRINT — July 2009

Partner News - Westin (cont. from page 17) About Westin Westin helps water utilities improve performance in plant operations, business operations, knowledge management, customer service, and asset and maintenance management. Westin’s suite of consulting and engineering services address utilities’ needs throughout the entire life cycle of their technology – from planning to design, implementation, integration, and system maintenance. Westin applies practical experience in business, security, SCADA, telecommunications, and information technology to help clients attain their desired business and technology goals. Westin has delivered solutions to its customers throughout the United States since 1981.

CIS automatically generates a service request in CMMS and displays the service location on the GIS map.

Westin and Azteca continue to collaborate on ways to improve process performance through system integrations between Cityworks and utility business systems. Westin and Azteca’s longtime relationship continues to be solidified through ongoing collaborative efforts that improve performance within a manageable budget.

“These integrated solutions deliver best-in-class information systems and integration at a cost agencies can afford,” said Doug Harp, CEO and President of Westin Engineering. “Westin and Azteca share the mission of enabling agencies, regardless of their size, to expedite enterpriseclass performance improvement.” “Azteca’s relationship with Westin is most certainly one of mutual regard,” states Brian Haslam, President of Azteca Systems. “Both companies realize the strengths of each other and share the idea of integrated solutions to extend and simplify processes for our users. We are pleased with the outstanding results organizations are experiencing operating Cityworks with such leading solutions as Springbrook, Microsoft Great Plains, and Cogsdale. The ease and capabilities of these integrations encourage organizations to continue to utilize the best solutions that meet their needs.” cw

Work crews access live maps, work orders, service requests, and customer information from their truck – without driving to the maintenance yard.

Cityworks 2010 - User Conference Sa me location -

May 17 - 19, 2010 St. George, Utah Dixie Center

new

date!

Pre-Conference Training May 14 & 15 Hilton Garden Inn St. George, Utah

Due to the City of St. George booking the 2010 Iron Man Competition the same week, we felt we did not want to compete for rooms with 10,000 athletes and their families. Therefore, we have once again had a date change! Visit www.cityworks.com for more information.

INPRINT — July 2009

South San Francisco, CA (cont. from page 1) South San Francisco’s Superintendant of Public Works approached the Director of Information Technology to discuss the predicament they were facing. The City’s IT Director had seen Cityworks at a conference and was familiar with its functionality. In discussing Cityworks and what it could offer, it was envisioned that Cityworks could advance South San Francisco into not only tracking and satisfying state requirements, but the combination of GIS and Cityworks could vastly expand and improve the City’s tracking of daily work and reporting capabilities. A steering committee for the project consisted of Ray Razzavi, City Engineer; Gary Batis, Superintendant of Public Works; Marty Van Duyn, Assistant City Manager; and Doug Hollis, Director of IT. The project was funded by these departments working together with the same vision. Solution The solution for the State mandate was to document the sewer and storm drains using Cityworks as its foundation. Cityworks would be used to collect and maintain the reporting records while ESRI’s ArcGIS would provide the GIS infrastructure. With his IT background, Mr. Hollis shared his vision with Gary Batis and Ray Razzavi and they saw the future benefit of using both systems throughout the City. The IT Department has taken a lead role in funding the project. Hollis hired Justin Anderson, a GIS consultant, to lead in the implementation of Cityworks and develop the GIS. Anderson, along with James Hardie, Supervisor of Public Works, collaborated in directing the implementation of Cityworks and GIS and ensuring the execution of the project. All the departments involved worked together for the success of the implementation and continue to do so today. Cityworks has been up and running for about a year in the City’s Public Works Department. Three laptops are used in the field with full functionality as field crews use a commercial wireless card to connect to a Citrix server. Within Public Works, the Electrical Division is also running Cityworks to manage all electrical maintenance throughout the city. The Parks and Recreation Department has recently completed its Cityworks implementation and will soon be utilizing service requests and work orders for tasks such as trimming trees, groundskeeping, and overall park maintenance. The City also has plans to bring the Motor Pool Division on board with Cityworks.

City Hall

Results Cityworks has provided the City with many positive results and has exceeded staff members’ expectations. “This is a great story of how our City Departments came together, funded a project, and provided support with everyone embracing its use,” states Doug Hollis, Director of IT at South San Francisco. “Cityworks and ESRI’s GIS working together have accelerated the quality of work performed within the City immensely. Most of the City has gone from paper to electronics in just one year.” With everyone now managing the same processes, the City’s new system has provided better management tools via reports and better asset tracking and maintenance. The City has realized significant cost savings as a direct result of their Cityworks/GIS implementation. In July of this year, Ray Razzavi, Justin Anderson, and Doug Hollis will be giving a presentation to the GIS council on the significant fiscal savings the City has realized using the new system. More importantly, the City has met its original goal in providing internal and statewide reporting in documentation. According to Gary Batis, Superintendant of Public Works, the State recently reported how pleased they are with the improvements South San Francisco has made over the past year since implementing Cityworks and GIS. The City has exceeded the State’s expectations of where they needed to be and are vastly impressed with how far the City has come in such a short amount of time. Doug Hollis, Director of IT, at South San Francisco, asserts, “We are all completely ecstatic about our use of Cityworks and GIS. Having a vision for the organization and being able to leapfrog two jumps ahead of where we were is awesome. We are very pleased, no question about it.”

Scott Brumbaugh and Jeremiah Miller using Cityworks in the field.

INPRINT — July 2009

In the near future, the City plans to utilize Cityworks within its Water Quality Control Plant for service, work orders, maintenance, and tracking for environmental compliance. They also have plans to utilize Cityworks for the service and maintenance of grease traps within the City’s sewer system to assist in understanding backup flow and to better track it back to City vendors. The City is looking into expanding its user interface to be utilized by other City departments, and possibly the public, and plans to expand its use of field devices throughout all departments and divisions utilizing Cityworks in the near future. cw

Time for anothe r software update ?

It ’s time fo r

C ITYWORKS S erver MMS Cityworks Server MMS – the world’s first GIS-centric, browser-based Maintenance Management System. From the trusted leader in GIS-centric management systems

comes

the

generation

asset

maintenance management built exclusively on ESRI’s state-of-the-art ArcGIS Server platform and delivering a world-class, full-featured CMMS for Public Works, Utilities, and Municipal Agencies. When it’s time to update, think Cityworks Server MMS. Install Cityworks Server MMS on your intranet server and distribute to your entire enterprise – fast and efficient.

Azteca Systems,Inc. | 801.523.2751 | www.cityworks.com

A Z T E C A S Y S T E M S, I N C.

11075 South State, #24 Sandy, UT 84070