InPrint Spring 2010 by Cityworks, A Trimble Company

Cityworks March 2010 Delivering Innovative GIS-Centric Maintenance Management Tools for Your Organization Note from the editor: InPrint articles are submitted months in advance. Sadly, as we prepared to print this issue, the January 12th earthquake that devastated Haiti occurred. With you, our thoughts and concerns are for the people of Haiti. Natural disasters, such as the Haiti earthquake and Hurricane Katrina, are a reminder that we are all vulnerable. Our upcoming July issue will feature an update on Gulfport, Mississippi, and their recovery. It is our hope your organization will benefit from the emergency preparedness information in this issue.

Expect the Best, Prepare f o r t h e W o r s t – How Herriman, Utah, Uses Cityworks for Disaster Preparedness and Response

City of Charlotte, North Carolina, Utilizes Cityworks DataPump for Disaster Preparedness

By Steve Brown, ITS Manager, Herriman City, and Lindsay Ferguson, PR & Marketing, Azteca Systems

By Amy Rockwell, GISP Sr. Business Analyst, City of Charlotte Stormwater Services

Imagine you’re at home watching television, relaxing like any typical night, when a newsflash interrupts your program with warnings of a disaster in your geographical area. Would you have the comfort of knowing that the municipality you live in is prepared for such an event? At the City of Herriman, Utah, leaders are taking action to prepare for an emergency and are committed to ensure the citizens of their community are prepared for a disaster situation.

Fall 2009 marked the 20th anniversary of Hurricane Hugo. With its 90-mile-per-hour winds and torrential rain, Hugo swept through the City of Charlotte on the morning of September 22, 1989, creating one of the biggest disasters in the city’s history. The hurricane left 235,000 customers without power. It took City employees and private contractors five months just to clean up all the debris in the streets. The City realized they were not prepared for a catastrophe of this kind of magnitude. That weekend, a work management system was created in-house by two IT folks and a call center was formed. Hugo hasn’t been the only storm to wipe out power in Charlotte’s history; most recently the ice storm of 2002 did the same.

With its growing population and new economy, Herriman takes pride in their community while also recognizing the need to take emergency preparedness and response measures seriously. With many young families and children to consider, City management feels that being prepared for an emergency is a vital aspect of city planning and is taking action to head in the right direction.

Emergency response plans are considered with every project implemented in the City. The City realizes it is best to be prepared and take the time to practice for an emergency upfront so that if one ever happens, staff will Continued on page 33

Mock Disaster Drills In the spring and fall of 2009, Herriman conducted their biannual mock disaster drills incorporating Cityworks into their plan. Cityworks service requests were used to create event layers and to graphically view the issues associated with the disaster. Thanks to help from Wayne Hill, Azteca Systems’ Executive Director of Client & Information Services and a Herriman City resident, the City identified items to link with disaster Continued on page 34 Emergency Reponse Mobile Command Center

INSIDE THIS ISSUE:



Table of Contents

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.

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. 2010 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.

If you are interested in submitting an article for InPrint, please contact Kaye Ryser (801) 523-2751 or kryser@cityworks.com

INSIDE THIS ISSUE: F e a t u r e s – Expect the Best, Prepare for the Worst – How Herriman, UT, Uses Cityworks for Disaster Preparedness and Response

City of Charlotte, NC, Utilizes Cityworks DataPump for Disaster Preparedness

Automation and Workflow with Cityworks Supports Lean Staffing in the City of Citrus Heights, CA

P r e s i d e n t’ s C o r n e r – A Message to Our Users

P r o j e c t M a n a g e m e n t – Houston Public Works & Engineering – More Than 10 Years and Still Reaping Benefits from Cityworks

S o f tw a r e D e v e l o p m e n t – A Sneak Peek of the User Conference Software Preview

C l i e n t S e r v i c e s – Cityworks Interface Enhancements

MyCityworks.com Reloaded

Cityworks Campus

Tools & Tips on MyCityworks.com

P a r tn e r Ne w s – A Tale of Two Cities: Dublin, Ohio, and Lee’s Summit, Missouri (Pipelogix)

The City of Alexandria, VA: A Successful Cityworks Implementation (Timmons Group)

The Lions, Tigers, and Bears of an Asset Management Technology Implementation (Woolpert)

C i t y w o r ks 2 0 1 0 U s e r C o n f e r e n c e

R e g i o n a l S p o tl i g h t

A z te c a Ne w s

G e t to K n o w – Sales, Marketing, and Administration

Stay Connected! Become a Fan! www.facebook.com Cityworks

Join Us! www.linkedin.com Ci tyworks | Azteca Systems User ’s Group

INPRINT — March 2010

President’s Corner

A Message to Our Users.... By Brian Haslam, President & CEO, Azteca Systems, Inc.

Dear Cityworks Users, Recently I sent an email extending a personal invitation to join with us at the Cityworks 2010 User Conference, May 17-19 in St. George, Utah. Building on that email, I would like to review the compelling benefits for attending our conference. T e c h n o l o gy Overview The pace of technology is moving faster now than ever before and impacting mission-critical applications like Cityworks. We have some very exciting and important R&D efforts underway. At this year’s conference, we will discuss these specific technical elements, enterprise solutions, and future plans to help ensure you know enough to make the solid, reliable decisions your organization depends on. R e l a ti o n ships Matter Relationships are the cornerstone of our business. We depend on and value our relationship with you. Though the conference has quadrupled in size, we have endeavored to maintain a relaxed, friendly environment. Our goals are to foster building relationships, exchanging ideas, solving problems, and creating solutions.

The Dixie Center

Critical Mass The User Conference offers a unique environment where Cityworks staff, licensed organizations, and business partners gather to learn from each other. Sharing experience and ideas helps drive good decision making. A critical mass of Cityworks users can only be achieved at our User Conference and no other venue provides the concentration of the Cityworks-focused topics we cover here. Valued Input We create products based on your needs. Your input truly influences our R&D priorities. The conference provides the best platform for providing your input as we get an excellent picture of what our clients want collectively as you exchange your ideas in this collaborative environment. We value your input. U n e q u a l e d B e n e f i t- C o s t R a t i o We recognize budgets are tight so we have worked hard to assure our costs are low compared to other conferences. This year we have introduced complimentary registrations available to all licensed organizations. We moved the venue near Las Vegas to leverage less expensive airfare and negotiated the best values in accommodations in St. George. We are working with transportation companies to provide complimentary shuttle service from and back to Las Vegas. We believe the benefit to cost ratio for our conference is unequaled. All of us at Azteca Systems strongly encourage you to attend the Cityworks User Conference and are looking forward to seeing you there. We will not be holding another User Conference until fall of 2011. So please consider this carefully and let us know if there is anything more we can do to help see you in May.

The Narrows (above) and Angels Landing (right) at Zion National Park

INPRINT — March 2010

Warmest regards, Brian L. Haslam. President & CEO Azteca Systems, Inc. Cityworks

Feature

Automation and Workflow with Cityworks Supports Lean Staffing at the City of Citrus Heights, CA By Kevin Becker, Principal Civil Engineer, City of Citrus Heights, CA

The City of Citrus Heights is the first city in California where residents voted to form a city from the existing Sacramento County region. The city incorporated in 1997 with 14.2 square miles and 86,000 existing residents. After incorporation, the City leaders contracted with Sacramento County to maintain the services. Over the past 12 years, the City has worked on privatizing many of the services and added a few workers to coordinate and manage the activities of the various contractors. Like many cities, the City maintains a very lean work force, allowing staff positions to go unfilled in the current economic state. Currently 15 employees in the General Services Department handle Facilities, Fleet, Public Works, and Animal Control. With the City already built out and a philosophy to minimize the number of employees and costs, the General Services Department focused on improving services through workflow and automation. Conceptually City staff looked for systems that fully utilized the value of GIS, allowed paperless workflow, and placed emphasis on completing tasks. To this end, the City selected Cityworks as a key strategy to minimize staffing needs and better serve their citizens. The City also selected HiTech Gov to provide the necessary customization and backup capability for the in-house database administrator. To ready staff for the transition and generate buy-in, management provided various “carrots” or incentives to the employees. Two of the three field employees received a new truck and all three field vehicles had laptops with AT&T wireless cards added to enable the vehicles to be used as a second office. Office assistants received phone/computer headsets and widescreen monitors. A couple of engineers received widescreen monitors and ArcView training. All these tools helped motivate employees while adding efficiency to many other tasks, like answering phones and using multiple software programs at the same time. The automation and workflow process included various customization enhancements from the GIS project to Cityworks and document management.

All the GIS layers in the project utilize a scale threshold to turn on and off. When zoomed in tighter than 1 inch = 100 feet, the map displays the garbage pickup day, maintenance coordinator’s name, neighborhood name, water district name, large-item pickup month, Thomas Brothers map coordinates, and flood zone information. Most of this information automatically populates on the GIS map. This text disappears when zooming out past the threshold. The same functionality is built into many of the layers, providing the user the ability to automatically add information simply by zooming in or out. In addition, the aerial backdrop is faded 40% to allow information to pop out of the screen. D r o p d o w n L e tte r s Many times after a complaint or inspection, a follow-up letter is required to notify the resident and /or owner of a violation, including tree encroachment in the ROW, filling a floodplain, excessive barking of a dog, or basketball hoop in the ROW. Not only was this process time-consuming, the workload of the office assistant became the constraint to getting the letter sent. The new system provides every staff member the ability to dropdown these letters from the print preview function, allowing the four inspectors to print these out from the field. Most times the inspectors simply email the office assistants to take the print off the printer and mail the letter with its presigned signature. Closing the print preview provides the ability to make changes to the letter. The letters take advantage of the registery values and Word macros from Cityworks and automatically populates the address and owner. Additional

Select a letter type from the dropdown dialog box.

G I S P r o j ect – Layering & Thresholding A key component to automating data included creating a project that automated getting information either on the computer screen and/or autopopulating Cityworks fields. Basic information such as Thomas Brothers map coordinates, maintenance coordinator’s name, and neighborhood area number were populated using the drilldown function. Additionally staff wanted the owner name, address, and situs address to populate in the record.

Zoom in to view the information layer.

A dialog box allows inserting additional information into the letter.

INPRINT — March 2010

C i t r u s H e i g h t s , C A ( c o n t .) code automatically adds a second letter when the property owner’s address does not match the situs or incident address. I n f o rm a tional Links & Document Management Another key component to the workflow with the service requests and work orders is filing the data away for retrieval and providing customers information related to the type of SR/WO. Clicking print converts the SR/WO and any selected letters to an Adobe PDF and sends them to the document management system (SIRE). The initial SR/WO with any letter is dropped into the appropriate folder in the document management system and creates these links in the SR/WO. This data includes the SR/WO number and address. After the links are created, additional data can be dropped into the document management folder using this link or Windows Explorer. Two of the links created for each SR/WO are for accessing the document management system and the third link is an informational spreadsheet for the particular type of SR/WO. This spreadsheet contains a variety of links to handouts, contacts, and webpages. For example, under animal control, links provide information on the local Society for the Prevention of Cruelty to Animals (SPCA), brochures on dealing with barking dogs, and other pertinent contacts the office assistant may need to provide. This spreadsheet is easily updated with new data by group and does not require any special programming skills.

Links to SIRE are automatically generated upon saving.

Doubleclicking the first link brings up the folder in the document management system.

Sample of a barking dog complaint retrieved from the document management system.

INPRINT — March 2010

Informational link pages are available based on the type of SR or WO.

M i g r a ti n g A l l D e p a r tm e n t D a ta b a s e s i n C i ty w o r ks Using the custom fields in the work order templates combined with the knowledge of MS Word has opened up the ability to house all the general services functional databases in the Cityworks database. The City’s consulting vendor, HiTechGov, has utilized the Word interface and macros to push data in and out of the Cityworks database structure providing the ability to develop customized applications for permits (encroachment & transportation), facilities maintenance, fleet maintenance, and construction inspections. Eventually applications built on Cityworks will also be developed for the City’s Code Enforcement staff. cw For more information, contact Mike Pettinato, Database & Applications Analyst, mpettinato@citrusheights.net, Kevin Becker, Principal Civil Engineer, kbecker@ citrusheights.net, or Bob Summers, Chief Executive Officer, HiTecGov LLC, bob.summers@HiTechGov.com (website www.HiTechGov.com). Watch for their presentation at the upcoming Cityworks 2010 User Conference in May.

The City celebrated the grand opening of the Gold LEED certified community center on Jan 23, 2010. Despite the economic mess of the state and most agencies, the City did not incur debt to build this beautiful facility. LEED Certified Leadership in Energy and Environmental Design (LEED®) Green Building Rating SystemTM, developed and administered by the U.S. Green Building Council, a nonprofit coalition of building industry leaders based in Washington DC, is an internationally recognized certification system encouraging sustainable green building and development practices. They measure performance in five design categories: sustainable sites, water efficiency, energy and atmosphere, materials and resources, and indoor environmental quality. The number of credits awarded determines the certification level for new construction – Platinum, Gold, Silver, or Certified. See www.usgbc.org for more information. Congratulations to the City of Citrus Heights for a job well done!

Project Management

H o u s t o n P u b l i c W o r k s & E n g i n e e r i n g – More Than 10 Ye a r s a n d S t i l l Reaping Benefits from Cityworks By Steve Thomas, Customer Support Manager, Azteca Systems, Inc.

In 1998, The City of Houston Department of Public Works and Engineering (PW&E) undertook a $3.6 million, two-year project to design and develop a GIS-based Maintenance Management System for water distribution, sanitary sewer, and storm sewer facilities management. ESRI was asked to be the prime contractor with Azteca Systems, Inc., Berger & Co., EMA Services, Inc., Digital Consulting Software Services, Inc., and ESOR Consulting Engineers as subcontractors. Prior to embarking on this project, Houston PW&E implemented an ESRI AML-based GIS application to provide maintenance capabilities of the large number of assets in their GIS library. Naturally it was the organization’s desire to deploy a GIS-centric work management system that leveraged PW&E’s investment in ESRI GIS. Because of Y2K concerns, there was an added urgency to switch off of the system being used at the time, and so in June 1999, Houston PW&E went live with Cityworks consisting of Cityworks Desktop running on ESRI’s ArcView 3.2, Cityworks Call Center (MapObjects) for call takers, and a wireless web application (ArcIMS) for field investigators. As part of the Cityworks implementation, the Utility Maintenance Branch revamped their work processes and created the Central Operations Section (COS) to improve the quality of the City’s water and wastewater customer service. COS is divided into four groups; each one associated to one of the four quadrants that make up the City’s area of responsibility. These four groups utilize Cityworks to maintain over 7500 miles of water distribution lines, 142,000 water valves, 54,000 fire hydrants, 6790 miles of wastewater collection lines, 120,000 wastewater manholes, and other associated assets in their respective geographic areas. Today COS is a 24/7 operation that processes approximately 100,000 service requests and 13,000 repair work orders annually. It is made up of a staff of highly trained individuals consisting of field investigators, dispatchers, records managers, and quality assurance investigators. Following the Cityworks implementation, PW&E implemented Motorola’s 311 call center which was interfaced to Cityworks so public utilities calls would automatically be routed to Cityworks and create a corresponding service request. The interface provides immediate updates back to Motorola’s 311, so call takers can see real-time information at any stage of the service request process.

Central Operations Section (COS)

There is no question that Cityworks has been instrumental in helping Houston PW&E meet its mission “to maintain the City’s 14,000 miles of water distribution and wastewater collection systems” as measured through “high customer satisfaction.” They evaluate problems, repair system mains and appurtenances, perform preventive maintenance, reconstruct system components when appropriate, recommend long-term solutions, meet all regulatory mandates and requirements, and provide regional, state, and national leadership. In the years since the initial implementation, PW&E enjoyed the benefits they expected from their decision back in 1998. Cityworks operated without fail and gave the organization the tools they needed to operate at the highest level possible. But as is always the case, needs evolve and new needs are identified. In order to meet their growing list of requirements, PW&E realized they would have to modernize their GIS. So in 2008, PW&E identified and formalized the benefits that would be gained by upgrading the entire system – central to this was GIS. Those justifications were presented to the City Council and the project was approved. The project scope included migrating coverage data to a new ArcSDE geodatabase; installing, configuring, and implementing Telvent Miner & Miner’s ArcFM GIS maintenance software solution; upgrading Cityworks to the latest release; and testing reports and interfaces the City had developed over the ten-year span since Cityworks was first implemented. ArcFM was a pivotal selection by PW&E because it dramatically reduced the steps for creating, building, and maintaining the organization’s GIS data. Since the responsibilities of Houston’s PW&E Department are distributed among six divisions (Engineering & Construction, Planning & Development Services, Public Utilities, Resource Management, Right-of-Way & Fleet Maintenance, and Traffic & Transportation), it was important for the GIS staff to realize an increase in their efficiency. In addition to the significant number of water/wastewater assets, PW&E also maintains over 16,000 lane miles of streets, 60,000 stormwater manholes, 100,000 stormwater inlets, 900,000 street name and traffic control signs, 17,000 freeway and under bridge light fixtures, and traffic signals at over 2000 intersections. Being a rules-based application, ArcFM provides built-in quality checks, uses industry-standard data models, and is highly configurable. The GIS staff were excited to move to technology that would simplify their daily work but also one that maximized the City’s ESRI Enterprise Software License. Telvent Miner & Miner performed the GIS conversion tasks in cooperation with the PW&E IT and GIS staff. The project plan required that GIS data be frozen during the course of conversion, data quality assurance testing, and software testing phases. The first jobs could have been processed earlier, but Hurricane Ike had other ideas as it hit Southeast Texas on September 13, 2008 as a Category 2 hurricane. Houston suffered significant damage to buildings and experienced many power outages as a result of the high wind and the hurricane eye passing directly through the city. Some residents were without electricity for over a month. Damages from Ike in the United States are estimated at $27 billion. The City of Houston spent roughly $200 million on hurricane response and recovery efforts. Despite the effects of Ike, City government continued to provide many important services including infrastructure repairs, which PW&E tracked in Cityworks.

INPRINT — March 2010

P r o j e c t M a n a g e m e n t ( c o n t .)

Radar image of Hurricane Ike

During the recovery efforts Telvent Miner & Miner continued to work with City staff fine-tuning and testing map maintenance routines in ArcFM and the geodatabase. City staff were also trained in the upgrade process of ArcFM’s toolsets for future ESRI ArcGIS, ArcFM, and Cityworks expansions and upgrades. It took some time for the City to recover from Hurricane Ike and get past their annual “water main break season” (you read that correctly – every year Houston experiences a period where water main breaks spike due to rapidly drying soil – this time over 800!), but training for the upgraded Cityworks system was delivered to 50 of the organization’s more experienced users. Many sessions were held focusing primarily on software changes between Cityworks version 3.7 and 4.5 as well as the updated ESRI ArcGIS Desktop software. Those users then provided individualized training of their own to hundreds of others throughout the organization and by rollout nearly everyone was up to speed! In October of 2009, the old Cityworks database was disconnected and upgraded to version 4.5 SP5. The upgraded system now includes a replicated ArcSDE geodatabase that all Cityworks users connect to by way of four Citrix application servers. Each server runs Cityworks and ESRI’s ArcGIS Desktop. Triggers for the 311 system integration and stored procedures for Oracle reports were also updated.

Damage from Hurricane Ike

Building upon this modernized and newly upgraded environment, PW&E’s GIS division developed two data viewers that are available to the public and City executives. These ArcGIS Server Flex viewers are designed to present important GIS infrastructure data including street, aerial imagery, and all utilities. Users of the viewers are able to perform numerous spatial operations including query by address or asset attributes. (See below) More than ten years later, Cityworks continues to be an important tool on which PW&E heavily relies. It facilitates the City’s desire to be the nation’s leading Public Works organization and champion for the environment while providing reliable service of notable quality to the citizens it serves. cw

Gravity main repair

ArcGIS Server viewer

INPRINT — March 2010

Software Development

A Sneak Peek of the User Conference Software Preview By Carl Horton Ph.D., Executive Director, Software Development, Azteca Systems, Inc.

On the topic of teasers, one of the things we’ll be discussing and demonstrating at the Cityworks 2010 User Conference is the new Cityworks software. I won’t go into lots of details (otherwise this article wouldn’t be a teaser) other than to hopefully give you a very good reason to attend. 2010 is one of the hallmark years in new Cityworks software. We typically deliver one new major release every year, most years this was Desktop, but other years included Server MMS, Permits, Anywhere, and others. This year, we will be demonstrating new major releases of all our main products. Building on the recent success of Cityworks Server MMS, we will demonstrate a major release of MMS and completely new versions of Anywhere, Server Permits, and Mobile Applets.

rendering. DataPump will also be integrated into Anywhere to facilitate data transfer for disconnected users. One of the key areas the Cityworks development team constantly focuses on in server development is performance. In a browser application, performance is a simple concept – does the browser load fast enough that users do not get frustrated? By switching Server MMS to a Silverlight rendering engine, map drawing speeds and capabilities are greatly enhanced. The new Silverlight based map engine has not only much faster map drawing, but smoother panning and zooming, layer management, and much greater interaction with event layers. The concept of event layers is not inherent in ArcGIS, so we have expended a lot of effort to create the functionality that best suits our users’ needs. An eye-catching new feature of Server MMS is the data visualization add-on. This add-on will provide a number of graphing and charting tools at various levels in the application. For example, users will be able to visualize search results as graphs on their InBox page, build management dashboards, and have graphs available in the project and contract managers.

Parallel trends in new software from Microsoft and ESRI have helped spur Cityworks development into new horizons. Newer software development models, ArcGIS 10, Microsoft Presentation Foundation/Silverlight, and mobile device technology brought a wide range of new capabilities to our product development team. The most significant of these capabilities allow us to “share” code between desktop and browser applications. This shared code, primarily the business logic, substantially reduces development time and helps reduce divergent software. Many software packages are written in “layers.” These are typically broken out into presentation (user interface), business logic, and database transaction layers. In a properly designed code set, developers should be able to replace one layer and the other layers will continue to function. In order to capitalize on this code-sharing concept, we embarked on a new development initiative resulting in a complete rewrite of Anywhere. Cityworks Anywhere is a desktop application that can run in a networked environment or on a disconnected local machine. The business logic and database transactions layers are the same as in Server MMS; the presentation layer is new. Using this model, the way data is handled is exactly the same as in Server MMS, even though the user interface is different. The Anywhere user interface has some exciting enhancements. First among these is the ability to completely alter the layout. Borrowing from the layout model in Server MMS, Anywhere stores each form in a layout file. The layout files will be editable using a third-party editor like Microsoft Expression. This will allow user sites to make highly customized user interfaces for different types of users. A couple of other key enhancements for Anywhere will be the built-in capability to easily use either ArcGIS Engine or ArcGIS Server for map

Both server and desktop versions of Cityworks will support inherent GPS capabilities in the applications. Via a small Windows service, GPS-derived location data can be stored locally in the field or sent real-time to the main server. All users will be able to see locations of all GPS units as an event layer, which will aid in dispatching or knowing employee locations. In addition, the software will support automated logging of crew labor time based on location and time spent at work orders, inspections, and requests. Small screen format mobile devices are quickly gaining a foothold in the maintenance workforce. These devices include iPods, BlackBerrys, Android phones, and other small screen devices. In order to support the largest variety of devices, we are building a set of web applets to address common needs of field workers. A variety of applets are planned; the first of these shown at the conference will be a phone device version of InBox, work order, request, and inspection editing. Another big change in Server is the code level integration of Permits and MMS – they share code libraries, the same map, and exist in the same database. When upgrading with Cityworks Database Manager, everything is updated for both Permitting and MMS. Users can now easily create permits from a work order or service request, or the other way around – work orders or requests can be created from a permit. Likewise, users can easily view or interact with related permits in MMS. Greater map integration in Permits now supports event layers; permitrelated events can be opened from the map the same as work orders or requests. Users can click at a location to create a permit and map tips are now available.

INPRINT — March 2010

S o f t w a r e D e v e l o p m e n t ( c o n t .) Some other interesting enhancements to the permits software include Flex Forms, Public Access, and business licensing. Flex Forms brings powerful capabilities to collecting and presenting data needed to complete a permit. Flex Forms brings virtually any type of information into the permit process, such as yes/no questions, lists, images, numeric values, and more. Permit fees can also be dynamically and automatically calculated based on the responses an applicant provides. The Public Access module allows users, contractors, or citizens to remotely apply for permits, check the status of existing permits, and more from an internet connection. Business licensing provides a robust set of features for cities to track and renew business licenses and other license types that citizens or businesses may need or want. At this yearâ&#x20AC;&#x2122;s user conference, we will spend a few hours in the first dayâ&#x20AC;&#x2122;s main plenary session demonstrating these new capabilities and trends. The workshop track will have several classes covering the new installation and license managers, customization, permit workflow design, new features in MMS, and others. See you there! cw

INPRINT â&#x20AC;&#x201D; March 2010

Client Services

Cityworks Interface Enhancements Pa v e m e n t M a n agement Interface and CCTV Interface for PACP By Steve Thomas, Customer Support Manager, Azteca Systems, Inc.

Years ago Azteca management decided that instead of trying to be the solution for all things related to asset and work management that our software would focus on the work processes that had already made Cityworks a unique application. Consequently, when clients questioned us about our interest in pavement management or CCTV data capture, our answer was to develop interfaces to existing, well-known applications developed by other third-party software vendors. That decision led us to MicroPAVER, designed and developed by the U.S. Army Corps of Engineers, for the pavement management interface and the PACP standard data exchange database for CCTV data. While there is an interest in expanding the number of interfaces for other applications, our effort is determined by client interest and demand. We have already met with other vendors about developing interfaces to their products. T h e U p g r ade Process According to our own development plans and in response to requests to update these interfaces to support the most recent versions of MicroPAVER (5.3.7 and 6.1.2) and PACP (4.4.1), we have updated the interfaces for our 5.0 release. While we strive to be proactive in our development, it requires time to modify the code since the applications are not made available to us any sooner than they are to our clients, and because we have little or no control over the changes to those applications and their databases. Generally the release dates are also not synchronized with ours. For example, when MicroPAVER 6.0 was released, the software no longer generated the report that our interface had been using for importing and creating recommended work orders. Thus, we have had to do a great deal of research and testing to determine a new importing method. The new software also introduced projects, so our new 5.0 interface will be utilizing the new MicroPAVER projects. Changes to MicroPAVER and PACP are not the only changes that have to be taken into account when upgrading the interfaces. Consideration also must be given to changes in the Cityworks software and database. For example, Cityworks Desktop 5.0 introduces some enhancements to project management to take advantage of some of the functionality included in Cityworks Server MMS. The changes to projects affected how recommended work activities and related projects would be imported into Cityworks. G e n e r a l Enhancements We’ve added context menus to the results lists. Each interface has a rightclick context menu that provides Select All and Clear Selection options.

tool for clients to review what took place during the transactions, but it will also assist Cityworks customer support representatives to identify problems quicker and easier. Therefore, if our clients run across a problem with the data or software, they can check the Write to Log checkbox and rerun the routine. This will create a log of the entire routine, including the error. In this example, we see that distresses were successfully exported for four different entities but there was a problem exporting the work history for work order number 59054 and entity ID 16.

Transaction Log

P a v e m e n t M a n a g e m e n t I n te r f a c e The Pavement Management Interface has improved performance, making exports and imports much faster. The Export window now allows the user to right-click on the search results list and hide a single column, show all columns, or check each column that should be included in the list. Columns can be turned on or off before or after searching. The Import window has been modified so new MicroPAVER projects can be selected directly from the database, instead of having to export the M&R report and then import that into the interface.

Context Menus

The ability to log processes to track what has occurred during exports and imports has been added to both interfaces. Not only will this provide a

Column Headers

INPRINT — March 2010

C l i e n t S e r v i c e s ( c o n t .) C C T V I n terface for PACP There have been many changes to the CCTV Reader, including the name change to CCTV Interface for PACP. The Configure tab has been expanded to allow adding a default image and video file path as well as field mapping between the PACP database and the Cityworks or GIS databases for both exports and imports. The work order number exports to the new WorkOrderID field in the Inspection table, so there is no need to utilize custom fields for storing work order numbers.

The ability to create new work orders, even though open work orders may have been found while loading the PACP records, has been added for cases where the inspections were performed in an emergency or by contractors who have been assigned the work as a project rather than a work order. The ability to define the location of the images and videos, whether copying them from the PACP location during the import or simply specifying where they have already been moved to, has been added. This includes the ability to create a new folder within the default file path or set a new file path. Many of these enhancements are the result of your valued input. We are confident you and your staff will appreciate the efforts that have been put into updating and improving our interfaces. cw

Import Window

Field Mapping

Su p p o r t R e g i o ns

Customer Support Direct Phone #

801.990.1888 INPRINT â&#x20AC;&#x201D; March 2010

MyCityworks.com Reloaded

Home

Resource & Download Center

Home

Share Crystal, SQL, and Excel reports

Resource & Download Center Click the Site Map link at the bottom of any page for complete content.

Go to www.mycityworks.com to access the website. Get your MyCityworks login by contacting your

Knowledge Base

Forum

Training

Specifications

Contact Support

Knowledge Base Browse various articles for online self-service support.

Forum

Training

Specifications

Contact Support

For more information on training, send an email to training@cityworks.com or contact: John Jarnagin, Educational Services Manager 801-523-2751 ex. 8828 jjarnagin@cityworks.com

Customer Support Representative at (801) 990-1888 or email at cwsupport@cityworks.com.

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.

December was a busy and crazy month of trainings. Weather and food both made for memorable times. As usual, our regional training host sites were fabulous to work with and always available to help in whatever way they could. We definitely appreciate the hospitality of these sites as we couldn’t do it without them. We now have regional trainings down to a fine science. Before the training, we hold a GoToMeeting and ship our training manuals. Then we arrive on-site with enough external hard drives for each participant, plug them into the training machines, and Cityworks is ready to go. When we’re finished, we unplug them and we’re ready to leave—unless Mother Nature has other plans.

Sandy, UT: December 7-11, 2009 This Cityworks Administration Training was a definite shock to many of our attendees as they got to experience Utah snow firsthand much of the week. Ironically many of them hailed from Florida – Putnam County and the City of Port St. Lucie. Weston Solutions also sent attendees from West Chester, PA. We hope they’ll consider returning during a warmer time of year, like May’s User Conference. Fortunately the weather didn’t dampen their interest in the training as they asked excellent questions and there was lots of interaction. Ryan Miller accompanied us on our outing to the Bayou in downtown Salt Lake City for Cajun food and was a great resource when discussing Cityworks Server implementations from a Project Manager’s point of view. After a great dinner and excellent conversation, we enjoyed the Christmas lights on Temple Square.

R a l e i g h , NC: December 1-3, 2009 This very cooperative and engaging group of attendees hailed from Opelika Utilities, AL; City of Chapel Hill, NC; Harnett County, NC; City of Durham, NC; City of Raleigh, NC; and BP Barber & Associates in Charlotte, NC. Brian Haslam and Dave Bramwell showed up to chat with everyone. We enjoyed authentic Southern NC-style barbecue for lunch. (Bet most of us didn’t know that NC, SC, AL, and LA all have a different Southern barbecue flavor.)

On December 4, I traveled about 30 miles northwest to meet another great group of 11 from the Orange Water & Sewer Authority (OWASA) in Carrboro (just north of Chapel Hill) to train them on Cityworks Anywhere and DataPump.

INPRINT — March 2010

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

D D O T , W ashington DC: December 15-18, 2009 Ryan Miller accompanied me on this trip for a Cityworks Administration/ Server Training. Things were quite normal as we interacted with another great group of attendees. But on Thursday a large storm, bringing roughly 16 inches of snow, hit the area, leaving us stranded and on foot as flights were canceled. Ryan did what no other self-respecting Azteca employee would do if they were trapped in the middle of DC for an unknown amount of time—wore a Santa suit out in public for several hours one night. Yes, it’s true; I have photos to prove it. He actually brought his Santa suit with him. (I was afraid to ask what else he traveled with.) However, Santa Miller parading around seemed to cheer up some people as we went out on the town. We also had the opportunity to help push a few struggling cars out of the snow. After rescheduling several times with a number of airlines, we finally ended up renting a car and driving 4 hours to Greensboro, NC, for our flight (at least we flew first-class!) and returned home late Monday afternoon instead of Saturday as planned.

DC on Monday, December 15, 2009

Ryan Miller in DC on Friday, December 19, 2009

Educational Services 2010 is all about change in Cityworks Educational Services. Our course names/numbers have changed in an effort to make the Cityworks Campus more clear and easier to navigate. Our corporate training center is undergoing remodeling. Improvements include adding more workstations, flat screen monitors for better visibility, and many others.

Cityworks Training Courses Course Nu m b e r s Old Ne w

Course Title

2002

100

Database Implementation – SQL Server 2005

2007

101

Cityworks Designer Configuration – Part I

2008

102

Cityworks Designer Configuration – Part II

2009

201

Cityworks Desktop Introduction – Part I

2010

202

Cityworks Desktop Introduction – Part II

2011

301

Cityworks Reporting with Crystal – Part I

2012

302

Cityworks Reporting with Crystal – Part II

2013

401

Cityworks Storeroom

2014

402

Cityworks Anywhere/DataPump

2024

1000

Cityworks Administration Training – SLC, Utah

2025

1001

Cityworks Administration – Asset Reading/DataPump

2026

1002

Cityworks Administration – Storeroom

2027

2003

Cityworks Designer – Regional Training

2028

2002

Cityworks Desktop – Regional Training

2029

2001

Cityworks Anywhere/DataPump – Regional Training

2030

2000

Cityworks Administration – Regional Training

One- and two-day pre-conference training is scheduled for May 14-15. Please visit this web link to get more information on these courses: http://registerat.com/reg/cityworks2010/training.shtml. Upcoming Cityworks Administration Trainings at Azteca headquarters in Salt Lake City, UT, will be on: • August 23-27, 2010 cw • December 6-10, 2010

INPRINT — March 2010

Smart Information for a Sustainable World New Designer Staker and Designer Express

Looking for design process flexibility and efficiency for your utility? Now utilities can take advantage of powerful GIS-based design tools that embrace flexible workflow, outsourcing, and field-initiated data Telvent’s new Designer Staker and Designer Express solutions streamline the preparation of utility construction work sketches and job cost estimates, no matter the structure or process of your workflow. Based on ArcFM™ GIS, a component of Telvent’s Smart Grid Solution suite, both can make your design work faster while delivering the proven benefits of Telvent’s popular classic Designer: •

•

Integrated with GIS for streamlined data access and management Eliminating manual entry of individual parts and calculations Reducing design implementation and maintenance costs

Designer Staker: Simplify both your job, and your entire workflow for Electric Co-ops, REAs and EMCs. Designer Staker is the easy-touse, pen-based environment that allows collection of field data – including general field notes, GPS locations, and cost estimates and staking sheet. TechAdvantage Visit Telvent at Booth #925

With Designer Staker, smaller electric utilities such as cooperatives and REAs have a powerful, comprehensive solution for creating field-based designs:

– making the design process fast and flexible: •

Lightweight sketching that’s simple to use: simply click, drag, and draw

•

Flexibility to capture just the field data needed

•

GPS capability to navigate job sites and stake locations

Designer can focus on the design: GIS work and accounting can be moved to other groups, later in the process

•

Automatic update of GIS database to eliminate data conversion and duplicate entry

•

Fully configurable drawing palettes: reflecting your standards and tasks

•

Rural Utility Services (RUS) assemblies that can easily be modified as needed

Benefit from Telvent Experience

Designer Express: Designing is one job. Assigning materials is another. Designer Express, with a built-in work management system (WMS), is the ideal design solution for electric, water, and gas municipal utilities needing flexible workflows and those that outsource construction. Designer Express offers drawing and snap-into-place functionality that lets design engineers create without the overhead of compatible unit (CU) integration

Telvent has the extensive, industry-specific experience that delivers the products and services your utility needs. Designed for industry-standards interface and integration with legacy and future systems, Telvent’s ArcFM GIS and GIS-based solutions promise the scalability and long-life you want from your Smart Grid data collection and information management investments.

www.telvent.com GIS@telvent.com 866.537.6162

TechAdvantage • March 12-15 in Atlanta, Georgia Register at http://www.techadvantage.org/register/Register.htm

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

Tools and Tips on MyCityworks.com Se tti n g U p C i t y works Logins Because of RDBMS level constraints within SQL Server and known issues within ESRI’s GIS software and Cityworks, Windows Logins must be setup in a specific manner in order to properly function in Cityworks. Below are the guidelines for proper configuration. 1. Do not use Windows Groups. Instead, add each login to SQL Server individually.

4. For Cityworks users who are also administrators on the domain or locally on the RDBMS server, there are a couple of options. a. An additional login (SQL or Windows) can be created for a user that does not have administrative rights that can be used with Cityworks. This allows the user to have administrative access to the server, as well the ability to create Event Layers in Cityworks. b. The Built-in\Administrators group in SQL Server can be removed altogether from the SQL Server logins using the “sa” system administrator SQL authenticated account. If going this route, another group can be added in and mapped to the sysadmin Server Role that excludes those users that need to access Cityworks. In addition, the “sa” system administrator SQL Authenticated account can be used by administrative users who need to access Cityworks if a mixed mode Security model is in place. When all of the above steps are followed, the Event Layer database views are successfully created by the right logins and named without special characters; thus, Cityworks can successfully add them into ArcMap. See the entire February 2010 White Paper, “Cityworks Event Layers and Windows Authentication” as well as the Knowledge Base article #10019 on MyCityworks.com. cw

2. When mapping the individual Windows Logins to the Cityworks database as users, remove the domain name and backslash (\), as well as a period (.) if one exists, from the user name and make sure the schema matches the user name.

3. Make sure the user login on the Cityworks Employee record in Designer matches the aliased user name and schema in SQL Server without the domain name and backslash (\), as well as the period (.) if one exists.

Cityworks’ Training Room Re d e s i g n e d ! To accommodate a growing number of attendees, we’ve redesigned the training room at our corporate headquarters in Sandy, Utah. A wall was removed and the orientation of the room switched to allow for more workspace. A new state-of-the-art projector, large central projection area, and two flat s c r e e n monitors were installed for improved visibility, along with a sound system and microphone. Join us soon for one of our training courses and enjoy these improvements yourself!

INPRINT — March 2010

Partner News

A Tale of Two Cities: Dublin, Ohio, and Lee’s Summit, Missouri Se p a r a te M u n i c ipalities Use Identical Asset Inspection and Data Man a g e m e n t Te c h n o l o g y t o Suit Individual Needs By Suzan Marie Chin, Chief Marketing Officer/Artistic Director, Creative Raven, and Mary Shafer, Technical Staff Writer, Creative Raven

Ms. Chin and Ms. Shafer are part of the “Creative Flight Crew” at Creative Raven, a marketing-communications and production firm specializing in the water, wastewater, and municipal infrastructure sectors. “It was the best of times, it was the worst of times….” This opening line to Charles Dickens’ A Tale of Two Cities, with its 18th century setting, could just as easily fit our current period in time. It’s the worst of times to risk making poor purchase decisions, but it’s the best of times in terms of having the most efficient and cost-effective products to choose from. Nowhere is this truer than for municipalities faced with choosing equipment and software to meet their infrastructure inspection and maintenance needs. Fortunately, planners and managers can look for guidance to municipal departments which have already been there and done that. Dublin, Ohio, and Lee’s Summit, Missouri, serve as an interesting study in contrasts concerning the way they employ identical technological solutions to their asset management challenges. Decision makers will find much to learn from their process of choosing which inspection and data technologies to invest in and implement. While of different sizes, as Dublin is a city of roughly 40,000 and Lee’s Summit is more than twice as large, both are good examples of how two cities employ the customization capabilities of versatile data collection and data management software packages. Specifically those packages include Azteca Systems’ Cityworks asset management software, ESRI’s ArcGIS geodatabase package, and Pipelogix’s flexidata inspection data collection software (see sidebar).

Du b l i n, O h i o

Lee’s Summit, Missouri

S e tti n g Goals in Dublin Dublin originally installed its current sewer system in 1974 with more than a million feet of gravity line comprised of roughly 38% clay tile and the rest concrete trunk and plastic. The City’s Streets and Utilities Division deals mostly with sewer lines but does perform some basic cleaning and inspection of stormwater conduit as well.

Similar Setups, Different C i r c u m s ta n c e s This enterprise-wide stance is the focus of a recent review of asset management processes in Lee’s Summit. Implementation of the technology differs for this larger city encompassing 65 square miles and 600 miles of sewer pipe, with 80% of it 8-inch diameter. Vitrified clay pipe significantly older than 50 years comprises 128 of those miles. Treatment is done at a private sewer district plant.

Dublin has had an official pipeline inspection program since 1990. “We started off with one cleaner and one TV truck,” recalls William Grubaugh, Operations Administrator. The program has really taken off in the last two years, he says. “With the acquisition of new equipment, we started a rotation and have mapped out a goal of cleaning and televising all of our sanitary sewer lines every six years.”

The City has its work cut out for it in a current inflow and infiltration (I/I) study that has so far concluded that 60% of the system’s I/I comes from private sources. As a policy, the City does not maintain any of the lateral lines, so it has no lateral inspection camera launcher. It hired a contractor to do the study and access the laterals from private homes.

A c c e s s i b le Data Integ ration Even powerful inspection data and GIS programs have limited value unless they can be accessed by an enterprise-wide asset management tool. After using other such software, Dublin finally settled on Azteca Systems’ Cityworks. The primary requirement of any potential new software was that it worked seamlessly with the City’s existing GIS solution. Cityworks integrates with both ArcGIS and flexidata via portals that reveal their data within its screens for quick reference, making it a robust management and reporting solution for Dublin, as they were already utilizing both systems. One of the biggest advantages of Cityworks is that it serves as a central, single-source data repository that any user can log in to and update in realtime, so multi-location synchronization is unnecessary. This gives managers confidence that everyone is on the same virtual page, looking at the same up-to-date data, as a basis for ongoing decisions about maintenance scheduling, resource allocation, and budget concerns. For instance, Brandon Brown, Dublin’s GIS Administrator, explains, “We have a sanitary main feature class or layer of GIS data. This is referenced in Cityworks so when work orders are created or any work is performed, our

Lee’s Summit - Truck Control Room

INPRINT — March 2010

P a r t n e r N e w s ( c o n t .) Dublin,, OH (cont.)

Lee’s Summit, MO (cont.)

staff chooses those exact assets from a map to link to the work/work orders. This way we know where each pipe is, its unique characteristics, and maintenance history. [Pipelogix’s] flexidata has what they call a pipe table, which keeps track of information about each pipe and uses it to actually reference the survey and any videos.”

Like Dublin, the City of Lee’s Summit runs ArcGIS Desktop with data housed in an SDE database on a SQL Server in the office. It also runs Cityworks to manage assets and adopted flexidata when it came coupled with their inspection rigs.

A user selects a pipe or set of pipes in Cityworks and creates a work order which tracks the history of how much time is spent doing the work. Then an import process from flexidata grabs that Cityworks work order and pulls over any information that is applicable about the pipe—like size and type—and puts it into flexidata. At that point, the surveys become tied to the work order. This work order system serves as the keeper of resources that Dublin applies to its assets. The amount of time staff applies to performing those tasks is tracked within Cityworks along with their hourly rates. S e e i n g I s Believing Maria Renzetti, Dublin IT Department Project Manager, relates that previous management software could only display data as text. “It was very challenging to select the proper asset out of a long list. By using GIS, you have a visual reference so that you can choose the section of pipe or specific manhole you want to work on. This is a big time-saving feature. Before GIS it was necessary to have all the correct asset details in hand so that you could locate the asset from a list of potentially thousands of pipe segments.” Grubaugh says the visual aspect of ArcGIS and how it interfaces with Cityworks and displays data has allowed the City to be more efficient in project scheduling, especially for preventive maintenance. “Because we can input work we would like to get done through Cityworks and GIS and can visually see what we anticipate doing in any given year, we can build our workload around that. This has helped us tremendously. We perform the work, bring the field data from flexidata into Cityworks, and then know which work is left for us to do. We have so many miles of sewer system and could easily duplicate work if we didn’t have this visual system in place. It keeps us from becoming inefficient.” For ease of reference and logical crew deployment, he divides the city visually into “sewersheds” and assigns work along those lines. Pipes are color-coded by year of service— “2009 Work” is one color, “2010 Work” is another. Grubaugh summarizes, “This makes it easy for us to see where we need to be working based

INPRINT — March 2010

Also like Dublin, inspection crews enter survey data into flexidata, running the DVS module with Light Reporting on two truck licenses and the GIS module under the office’s full management license. They format using proprietary codes, with no plans to change over to PACP standards. Overcom i n g S h a r i n g L i m i ta ti o n s Unlike Dublin, Lee’s Summit crews don’t port their inspection data to the Cityworks software. Kelly Phipps, Senior GIS Analyst for the City, explains, “Cityworks, coupled with our GIS, manages our inspection systems and associated program costs.” Ryan Ratcliff, Water Operations Wastewater Supervisor, creates a work order in Cityworks for the infrastructure to be televised. He then imports that work order into flexidata through its built-in process which pulls that asset’s information across through Cityworks from the GIS. That survey is put on an external hard drive for the inspectors to use in the truck so they can upload the TV data onto it as they work. Then that information is loaded back into the office onto their sewer data “vault” on a file server in flexidata format. “Our current goal is to just allow people to access the flexidata inspection information, instead of replicating it in the Cityworks system. We want to keep it where it’s meant to be, which is in flexidata.” Over the past two decades, Lee’s Summit has built a pretty detailed GIS database. “In the recent past, we’ve gone through a significant cleanup process of all our sewer and water infrastructure,” Phipps says. “GIS gives you the ability to do a lot more when you have the spatial component associated with that. For instance, using GIS and Cityworks gives you the ability to review work history throughout the recent past and see where your high-priority issues are. Where do you have continuing problems? Where do we need to focus, maybe on jetting more?” Ratcliff adds, “We had been capturing TV data for 15-20 years. It had been written to Beta Disks, VHS tapes, CDs, DVDs, and then just thrown in boxes. We realized the only time we used that information was when somebody asked for it and we had to go retrieve it. There was no analysis being done on it. Within the last year, we started looking at how we could change our CCTV and

Technology O v e r v i e w The City of Dublin, Ohio, and the City of Lee’s Summit, Missosuri, use the same software and hardware technologies to help manage their resources to inspect and maintain their capital assets. To help clarify the contrasting ways these municipalities apply the technology, here are the highlights of the ESRI and PipeLogix packages.

ArcGIS by ESRI ( e s r i .c o m ) ArcGIS is an integrated collection of GIS software products that provides a standardsbased platform for asset-related data management, spatial and risk analysis, and mapping. Specific functions include service needs forecasting and maintenance planning, business operations, and situational analysis/ customer access. ArcGIS is scalable and can be integrated with other enterprise systems such as work order management, business intelligence, and executive dashboards.

f l e x i d a ta b y P i p e L o g i x I n c . ( p i p e l o g i x .c o m ) flexidata™ is a software solution for survey data collection on underground assets like main line pipes, laterals, and manholes. As an ESRI business partner, PipeLogix has given flexidata a GIS basis that allows it to tie in directly to other GIS-based software. flexidata is designed to meet NASSCO’s* PACP standards or allows the user to use their own data standard. The package includes a built-in CD/DVD burning function, numerous evaluation reports for comprehensive analysis, and a free data reader. *National Association of Sewer Service Companies

P a r t n e r N e w s ( c o n t .) Dublin,, OH (cont.)

Lee’s Summit, MO (cont.)

on whether it’s a sewershed, a project from another division that has to be completed, or if we need to look at pipes in a particular newly constructed neighborhood. It really helps us plan our work in advance to meet the goals we’ve established.”

flexidata software implementation to make the data more accessible. So we purchased a file server.”

K e e p i n g Things Moving Emergency situations don’t throw a wrench in the works anymore now that Dublin is managing its projects digitally. Because of the visual work record, Grubaugh reports that “it’s easy to walk away from what we’re doing in the middle of runs and not be confused. It’s broken out so easily the staff is really efficient and very effective. They can drop one thing, go someplace else, complete work in another part of the city, and come back afterward and pick up right where they left off.”

Having the data now available on their network allows the Engineering Department—in a separate location—to have access and review it without having to get disks made and delivered. “It takes a middleman out of reviewing the information that we have,” says Ratcliff.

He also appreciates Cityworks’ ability to document the crews’ presence in responding to emergency or cleaning calls since it provides information that can be reported back to the residents. “When we clean the line if they have a backup, we know the last time we were there, what we found at the time, and how many times that particular resident or sewer line has had issues.” In this way, the software becomes part of a good relationship with their citizens. “The data we’re collecting and running through Cityworks to track equipment, labor costs, dates, and times of service and what we’ve found, as well as point-of-contact information—who we spoke to, what the discussions were, and what resulted from our communication with the residents—are all vital to us. It helps us build a history with each resident and each asset in the city.” Renzetti concurs. “Having a place to indicate the types of calls we’re getting from a resident and then being able to track the history of a call to resolution was big. We were also looking for ease of use for our end users… something that did not take a lot of time and just made a lot more sense to those doing the work.”

Cityworks Work Orders

C o n s i d e r All Stakeholders Dublin’s team agrees their biggest challenge was capturing the right data about their infrastructure and allowing all interested parties to have easy, immediate, and up-to-date access to it whenever necessary. Investing in the inspection equipment that provides digital data needed by the software trilogy of ArcGIS, flexidata, and Cityworks has paid off handsomely in efficiency and effectiveness. Renzetti recommends any municipality in the process of making decisions about the technology it will use for asset management needs to “really take the time to consider the wider scope of a project,” like who might have an interest in data being collected and how they might use it—not just now but into the future. While this may increase research and implementation time for the new solution, it was worth the effort for Dublin. Brown agrees, citing the importance of finding a common basis for the data. “Whether or not you have GIS, you should have some record of asset history that is used across all the systems so you don’t have competing viewpoints of what a certain pipe is or what it may be made of and those types of things.” cw

flexidata CCTV Survey

F u r th e r I n te g r a ti o n Now the team must analyze all that information. They’re also looking into how to load the backlog of video data they’ve collected and whether it’s worth loading the old information. Data is currently analyzed by in-house personnel when they are idled by equipment breakdowns from their usual jobs.

INPRINT — March 2010

P a r t n e r N e w s ( c o n t .) Lee’s Summit, MO (cont.)

Phipps and Ratcliff are currently engaged in researching how they can tie their GIS and flexidata databases more closely together to allow wider usage of the information. For instance, they get many requests for pre- and post-new construction video inspections. They’re likely to take a new look at all the functionality available through Cityworks. “In the past, we’ve owned about every asset management system under the sun,” admits Phipps. “I think the biggest driving factor for choosing Cityworks was the level of integration that Cityworks offered with ESRI’s products. They don’t require any replication of data from GIS into your AMMS (Asset Maintenance Management System) and Cityworks is extremely flexible with what you can do. You don’t have to take a canned approach and try to fit that to your business process. You can look at your business process and adapt Cityworks to that.” Ratcliff already uses the program to prioritize scheduling of preventive maintenance, capital improvement, and special projects. He also consults the data to help make immediate decisions regarding emergency jobs. W h a t’ s Next? Their most important immediate goal, according to Ratcliff, is getting the data accessible. “What we’re really excited about is looking at all the information being gathered on those TV trucks. Because when you think about it, that video isn’t very important when you have all that observation data. That’s what we really want to start digging into. I think it’s going to open our eyes a lot to the condition of our infrastructure. We’re really excited to move to that point.” He believes it’s important to make sure the truck operators record as many observations as possible along with the video as that will improve the data’s value. “Sometimes, guys will make a determination such as, ‘Here’s a crack… it’s really not that bad… I’m not going to record it.’ So you really need to develop a level of consistency with your operators. No two people are going to grade something the same way, but you want to make sure that everybody recording video is grading the problems they encounter. As much information as we can collect, that’s what makes the process that much more worth the time and money we put into it.” cw

Streets and Utilities Division City of Dublin, Ohio Founded: 1810 Population Served: 40,875 Employees: 8 in sanitary sewer; 3 in stormwater/engineering Infrastructure: 1,164,237 feet of sewer gravity mains (approx. 220 miles) Area: 24.55 square miles Operations budget: $2,307,000 (excluding CIP projects) Website: www.dublin.oh.us Wastewater Utilities City of Lee’s Summit, Missouri Founded: 1868 Population Served: 90,000 Employees: 11 in wastewater collection, 6 in office, 6 in pump station facilities maintenance Infrastructure: 600 miles of sewer mains; 12,000 manholes; 12 lift/pump stations Area: 60 square miles Operations budget: $1 million for collection system maintenance (excluding CIP projects) Website: http://cityofls.net/Utilities.aspx

INPRINT — March 2010

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

The City of Alexandria, Virginia A S u c ce s s f u l C i tyworks Implementation By Jennifer Coughlin, Project Manager, Timmons Group

The City of Alexandria is home to many businesses and families in the Northern Virginia area. With a population of 143,885 in a 15-square-mile area only 6 miles from downtown Washington DC, Alexandria is dense with culture, history, and people. Having a well-maintained city is important for numerous reasons including tourism, quality of life, and public safety. As a responsive city, Alexandria has continually improved their infrastructure by turning their citizen issues, concerns, and requests into actionable work to improve their surroundings. The City of Alexandria received approval for the implementation of an Enterprise Asset Management System (EAMS) in 2007. A thorough selection process managed by the City resulted in a clear choice: Azteca Systems’ Cityworks maintenance management solution, to be implemented by Timmons Group. The project team consisted of representatives from the Parks & Recreation Department and the Transportation & Environmental Services Department (T&ES), including the Street Maintenance, Transportation, and Solid Waste Divisions. Beginning in the fall of 2008, Timmons Group and the City of Alexandria’s core team members began implementation of the long-awaited EAMS. Through the successful execution of an aggressive implementation schedule, the City of Alexandria took the new Cityworks system live in September of 2009. The City of Alexandria’s implementation began with a full business process workflow analysis and reengineering effort. These business workflows were diagramed, evaluated, and optimized for both service request and work order workflows for the following groups: • Maintenance – Streets, Sewer, Storm, and Hydrants • Solid Waste – Refuse, Recycling, and Street Cleaning • Traffic – Signals and Signs • Parks and Recreation – Park Maintenance, Marina, Trees, and Special Events Workflow gaps were identified and bridged with technical or functional solutions. A custom Cityworks configuration was developed and captured in a design document. This document captured over 200 request types and more than 550 work order activities associated to approximately 55 GIS features classes. After the initial design and configuration processes, iterative system testing by the core design team served to identify potential issues which were addressed proactively and solidified into the final configuration.

Training documentation for role-based classes was developed so end users would get the specific training they needed to be successful, without being overwhelmed by system functionality which did not apply to them. Timmons Group trained approximately 50 end users and provided coaching and onsite support for the system Go-Live to ensure that any last-minute issues and questions were addressed immediately so there was no lingering doubt that the system would be adopted by the end users. Timmons Group and the City of Alexandria worked closely together for ten months to successfully implement and Go-Live with Cityworks. L.A. McCracken, the City of Alexandria’s Information Technology Coordinator for T&ES and one of the Cityworks Project Managers, summarizes, “Timmons Group’s expert implementation of Cityworks has opened a new future of strategic asset management and maintenance management capabilities to be explored by the City of Alexandria. Timmons Group’s Infrastructure Solutions Staff, through their diligence and resourcefulness, has established the framework for a maintenance management program that will serve the citizens of Alexandria by providing the City’s executive management, divisional managers, and front-line maintenance staff with the tool sets necessary to assist in maintaining the quality of their community for years to come.” The City of Alexandria, Virginia, is an exemplary client. The City’s project managers for the implementation of the EAMS had a clear vision of the solution they desired and were highly skilled in the areas of Information Technology (IT) and GIS. The City assembled experts from participating divisions and departments creating a Cityworks core team. These individuals were knowledgeable about their current business processes and departmental needs and were empowered to make decisions in the best interests of the City. They were actively engaged in learning the new solution and finding ways to make it work best for them. The objectives of the core team were to provide Timmons Group a proper interpretation of the internal business processes and to make the configuration decisions necessary for a successful implementation. The City of Alexandria was able to meet the deadlines set within the project schedule and make the difficult decisions with respect to new business workflows and processes in large part because they had the right people on the core team. The City’s management and teamwork throughout the project was exceptional and are key factors as to why the implementation was such a great success. The City has been live with Cityworks for three months. They have the continued support from the executive management level through to the front-line maintenance staff.

INPRINT — March 2010

P a r t n e r N e w s ( c o n t .) The efforts to realize the long-awaited EAMS were extraordinary and the path arduous, but the City of Alexandria rose to every challenge. The EAMS management team continues to be responsive to the users and active in ensuring that the new system serves as the backbone of all work-related activities. The fact that the management team still exists is a testament to the City’s dedication to its success and the primary reason why Alexandria will have a successful asset management program for years to come. As extended functionality to the Cityworks EAMS, the City is implementing Timmons Group’s Request LoGIStics, a next-generation software product providing a user-intuitive, web-based interface for the creation of service requests and public inquiries as part of the Azteca Cityworks software suite. Under this initiative, Timmons Group is working with the City’s Information Technology Services (ITS) Department to revamp the manner in which City constituents communicate their needs for service to over 30 City departments and agencies. To date, nearly 600 unique request types have been defined and configured for inclusion in the Cityworks database. Citizen requests for information and services will be managed through the Request LoGIStics / Cityworks suite, ultimately providing City management with a means of measuring and improving upon staff responsiveness and constituent satisfaction. In addition to the core Cityworks MMS implementation, the City of Alexandria is partnering with Timmons Group for the development of their comprehensive infrastructure inventory to be used in conjunction with Cityworks to provide a comprehensive GIS-centric Enterprise Asset Management (EAM) solution. Under this scope of services, Timmons Group and strategic partner Transmap performed a van-based GIS / GPS / terrestrial photogrammetric inventory and condition assessment of all public works assets located within the right-of-ways of the City’s 275-mile street

INPRINT — March 2010

network. Project tasks included: 1) GIS data model and Linear Reference System (LRS) development; 2) photogrammetric capture of asset inventory and extraction / loading to GIS database, 3) pavement condition survey and configuration of MicroPAVER, and 4) full Cityworks MMS integration. The City of Alexandria continues to strive for excellence through the updating and implementing of advanced software packages, making improvements to internal workflows and ensuring the necessary internal support is available to meet the needs of each goal set forth. One thing that remains a constant for the City is that no matter what the goal or how difficult the challenge, the City always rises to the occasion and performs in an outstanding manner. cw

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

The Lions, Tigers, and Bears of an Asset Management Technology Implementation By Dave Feuer, PMP, and Michael Sweeney, Ph.D., P.E., Woolpert, Inc.

Over the past several years, the concepts of asset management have captured the attention of organizations and government agencies responsible for managing the publically owned infrastructure we largely take for granted. A commonly accepted definition of asset management applicable to public utilities and related industries by the Environmental Protection Agency (EPA) is: “Asset management may be defined as managing infrastructure capital assets to minimize the total cost of owning and operating them, while delivering the service levels customers desire.” Organizations have relied on technology to help systematize principles and practices of asset management as part of their planning and implementation efforts by focusing attention on work order systems, accounting systems, renewal and replacement, and capital improvement planning methods as well as projects to maintain or improve asset level of service (LOS). Large and small organizations alike understand the importance of implementing the necessary technology to satisfy directives from such agencies and organizations as the EPA, American Association of State Highway and Transportation Officials (AASHTO), and Government Accounting Standards Board (GASB). In everyday terms, asset management is really about finding what we call the “sweet spot” in investing in your organizations’ infrastructure to ensure it meet the needs of those using it. If an organization spends too little money maintaining their assets, the end result is deterioration resulting in electrical blackouts or utility breaks that directly impact citizens. If, on the other hand, too much money is spent maintaining infrastructure, then the organization can risk being cash poor and not have the appropriate debt service ratio in order to go to the bond market. Asset management is not a product you can buy or a technology or “package” to implement. It is a disciplined set of practices for gathering and using information enabled by technology to present and make the best decisions. Comprehensive information gathering and analysis needed for effective asset management is best accomplished by employing or leveraging existing technology but is there one best starting point for applying technology to enable and sustain asset management practices and principles? The initial approach may vary among organizations depending on their unique business drivers and the needs and gaps in pursuing the basic elements of an asset management program, which are: 1. Asset inventory – a complete registry of the “vital statistics” of each physical asset. 2. Criticality – analyzing and assigning a rank to assets by the degree of consequence of failure for prioritizing work activities. 3. Asset condition – gathering and updating ratings that estimate the likelihood of failure of critical assets. 4. Service levels – tracking performance standards. 5. Effective maintenance – history of and ongoing corrective, preventive, and predictive work activities and their costs. 6. Life cycle costing – retrieving the total cost of ownership for each critical asset to determine the renewal and replacement schedule and capital funding options. Each element is interrelated to all the others and collectively they serve the purpose of minimizing the total cost of ownership and maintaining the risk of ownership of all critical assets at an acceptable level. Choosing and/or leveraging technology to manage all the aforementioned elements is the goal to achieve an effective, sustainable asset management

program. However, be cognizant of the advantages and disadvantages of these three common approaches to technology implementations. The Lions These systems take an approach to be “all things to all people” and actually perform all of the six key elements of an effective asset management program. Your typical Enterprise Resource Planning (ERP) systems with fixed asset modules fall into this camp. Albeit effective when implemented, these systems are more expensive to implement, difficult to maintain, and can offer less flexibility in customization. The Tigers These systems are more decision support systems focusing on specific niches such as capital improvement planning and budget forecasting, GASB, and/or reporting. In general, Tigers have a specific purpose, such as GASB 34 which was a very hot topic in the public sector in the 1990s but, in our experience, has since cooled down. Some examples of Tigers include Riva, GIS, and even the use of Microsoft Excel spreadsheets. Purchasing additional systems are not always required to effectively analyze criticality, help assess preventive maintenance programs based on service levels and condition ratings, and determine the costs of a renewal and replacement program. The Bears These systems don’t claim to “do it all.” Instead they focus on providing tools to effectively manage the business process workflow of collecting the appropriate data on the required and completed maintenance activities. They offer some financial level reporting, searching and reporting, and customization and configuration where necessary for each organization. Finally, these systems share a common theme of being open enough to leverage the functionality in modules and/or tools that fall into either of the other two areas. C i t y w o r ks L e v e r a g e s G I S Cityworks is an example of a Bear that can leverage Lions or Tigers. As an extension of the ESRI suite of products, Cityworks can take advantage of the GIS decision support system. By storing its asset inventory in the geodatabase, there is no costly database replicating. Being GIS-centric also provides Cityworks the open architecture of being compatible with many other applications. When coupled with MicroPAVER or a CCTV application

INPRINT — March 2010

P a r t n e r N e w s ( c o n t .) Asset Management Not every asset management system is going to fit in one of these three categories. There are organizations that may prefer to create a complete custom system, but these three describe most of the systems we have encountered out there on the yellow brick road. When selecting an asset management technology solution, be sure it contains a primary repository (or asset inventory) of information, for storing the attributes, as well as the maintenance information like history, costs, schedules, and procedures. Additionally, a system should provide a means of logging maintenance activities in the field and communicating those activities back to the enterprise. This allows the same data to be integrated across all organizational functions and be available for maintenance and capital investment planning and analysis as well as for use with other decisionmaking support systems.

Example of a support system utilizing GIS

which calculate condition, Cityworks interfaces can populate these values so they can be displayed on the map to visually show those areas of critical concern. Service levels can be easily defined and cyclical work orders created to establish regular maintenance schedules and activities. Manufacturer’s warranty information can also be tracked. Attaching assets to work orders allows searching on assets to view all the work which has been done on them. This information can be used for life cycle costing. Cityworks has the added benefit of being customizable and configured for a large variety of asset types. ESRI products coupled with Cityworks is an example of how Tigers and Bears can be combined to enable effective asset management.

All these system components comprise an enterprise asset management system. With a software integration strategy, they enable a sound, uniform foundation for decision making based on risk, life cycle costs, and benefits. Integrating asset management with financial planning, which incorporates systematic maintenance and planned capital investment, ensures a wellinformed and defensible set of actions and decisions. Early in the 21st century, we’re seeing this trend to justify every dollar spent to attain this “sweet spot” of infrastructure management. In our numerous asset management implementations of Lions, Tigers, and Bears, we have seen some of the most successful and cost-effective implementations based on combining the strengths of the Tigers (GIS) and Bears (Cityworks). cw

Business Partners Implementation Partners PLATINUM • Woolpert

GOLD

• Short Elliott Hendrickson (SEH) • Timmons Group • Power Engineers

SILVER

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

BRONZE • Bowne Management Systems • 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

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

BASIC • Anderson, Eckstein & Westrick, Inc. • Bergmann Associates • BP Barber & Associates • CDM • Chester Engineers • Clark-Nexsen • EA Engineering • EMH&T

INPRINT — March 2010

• ESC Engineering, Inc. • geographIT • KCI Technologies • Malcolm Pirnie, Inc. • Michael Baker Jr., Inc. • PSOMAS • Quartic Solutions • Stantec Consulting

Strategic Development Partners • Actsoft • Badger Meter, Inc. • CartoPac Field Solutions • CIPPlanner Corporation • Cobra Technologies • Comcate Inc. • CompassCom • Coulter Mapping Solutions • DataBank IMX • Data Transfer Solutions • Dig-Smart • Dynatest Consulting • 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 • Telvent Miner & Miner • TRANSMAP

International Distribution Partners • ESRI Canada • ESRI Costa Rica (Geotecnologias) • ESRI Israel (Systematics) • ESRI S-GROUP Sverige AB, Sweden

Regional Spotlight So u t h e a s t R e g i on

Regional Account Managers

Dave Bramwell T h e C i ty of Palm B a y , F l o r ida By Julie Lemons, Utilities Outreach Coordinator, City of Palm Bay Utilities, and Ellen Prendergast, Database Administrator, City of Palm Bay Utilities

The City of Palm Bay Utilities Department is currently implementing Cityworks and is the first user to apply the program in a water/wastewater treatment plant environment. Palm Bay adopted Cityworks to electronically track all assets, prioritize tasks, and maintain plant facilities to industry standards. The goal is for Cityworks to document a more proactive approach to scheduling and tracking all maintenance through the use of automated work orders ensuring maximum life of facilities and providing the required level of service to assets in the most cost-effective manner. For example, Palm Bay is currently using Cityworks to develop more efficient maintenance schedules for its High Service Pumps (HSPs) which maintain adequate pressure throughout the City’s water distribution system. Previously maintenance for the Department’s 15 HSPs was routinely set for every six months. Cityworks has enabled staff to make adjustments to the HSP maintenance schedules which should prove to be a very costeffective measure by allowing staff to avoid the potential of costly repairs. In addition, lenders view the Cityworks’ CMMS as a program that reduces risks for the Utilities. This risk reduction can positively affect the Utilities’ bond rating and creditworthiness. The data and reports created through Cityworks have made it easier for the Utilities Department to track its progress. Palm Bay Utilities utilizes Crystal Reports software to design interactive, user-friendly reports from data generated in Cityworks. These reports have allowed the organization to justify manpower and identify additional staffing needs. CMMS is a valuable resource which allows the Department to monitor progress in relation to industry standards. By implementing and maintaining a computerized maintenance management system (CMMS) the Utilities Department has been able to identify opportunities for continual improvement specific to its infrastructure. Cityworks has also supplemented the Department’s efforts to minimize its environmental impacts in terms of resource depletion and pollution prevention. Currently Palm Bay Utilities Department is working to expand Cityworks and incorporate

Tom Palizzi Director Sales & Marketing 303-467-2738

maintenance of water distribution lines and wastewater collection lines into the system. In addition, other departments throughout the City have shown an interest in the product and are considering implementation. “Cityworks’ CMMS software has provided our utility with critical data needed to continually enhance and improve our operations. The circumstances and situations that exist in a water utility are unique and the staff at Cityworks has provided excellent support for our CMMS,” related Ellen Prendergast, Palm Bay Utilities’ Database Administrator. cw

T h e C i ty of Concord, North Carolina By Jerry Laliberte, Project Manager, Technologies Edge (Cityworks Implementation Partner over the Concord Project)

Before adopting Cityworks, the City of Concord’s Customer Service Reps (CSRs) used their utility billing system to enter calls from citizens on their accounts. During this time, the rest of the City was using Cityworks to generate work orders. The City decided they wanted both areas on the same system, so they configured a way to merge the systems so information would flow back and forth between the two programs. An interface was formulated and implemented and is used to carry out the tasks.

and every 15 minutes the information is brought into Cityworks as a service request. Caller information and all notes are captured from the billing system and placed in the request. The request is then closed or made into a work order. Once the request is closed, the interface brings the information back into the utility billing system with new notes or comments and is closed. Because of Cityworks, the CSRs were able to continue to log calls at the account level in the utility billing system. In addition, the City is able to track costs through Cityworks which they were not able to do in the billing system. Concord wants to continue to grow their use of Cityworks and have already expanded into areas such as Code Enforcement and other nontraditional departments. The City also uses Cityworks to gather information for state and federal reports and to track benchmarks for the City. “The City of Concord has benefited greatly from the flexibility of Cityworks and its ease of use,” comments Jerry Laliberte, Technologies Edge Project Manager. “It seems every month we find another new area to use it in to increase the efficiency of City employees.” cw

With the new system, CSRs enter call information in the utility billing system at the account level

INPRINT — March 2010

R e g i o n a l S p o t l i g h t ( c o n t .) S t. J o h n s County, Florida By Rocky S. Agbunag, GISP, Asset Management Coordinator, St. Johns County Public Works

Prior to Cityworks, St. Johns County’s Fleet Maintenance Division was using a DOS clientbased application to track fleet activities and expenses. When the time came to upgrade the outdated application, using Cityworks was the most economical choice since the County had already acquired a Cityworks Enterprise License Agreement (ELA), the Cityworks solution for municipalities with a population of 100,000 or less providing software within a tiered, affordable pricing schedule. Cityworks provides the Fleet Maintenance Division the means of creating and tracking work orders on over 1700 items of equipment, ranging from lawn mowers to heavy-equipment bulldozers. From mechanics to office personnel, the fleet maintenance staff are able to “attach” County Vehicle (CV) numbers, repairs, and repair history to work orders. Work orders allow the Fleet Maintenance Division to track costs associated to the CV numbers for billing agencies for the

labor and materials used to install, repair, or maintain their equipment over a specified period of time. Crystal Reports are generated for billing, performance measures, quality control, and maintenance notifications. Along with tracking work order activities, fuel consumption is also reported from a third-party database tied into the equipment repair reports. The outcome of the Cityworks implementation for the County’s Fleet Maintenance has been positive. There is now a better way for reporting performance measures. Transitioning the Fleet Maintenance staff from one work order system to another was crucial. Ample time for training and a thorough understanding of the fleet maintenance workflow made the implementation a success. All the Public Works Divisions are now using a unified work order system which is a cost benefit for the County since they all use the Cityworks ELA. There was also the cost savings in not having to upgrade the outdated application with a completely new system. St. Johns personnel realized Cityworks was flexible enough for what they needed prior to the implementation, which resulted in its success.

the Fleet Maintenance Division and is looking to find a solution/procedure to import/link the NAPA parts information into Cityworks. The Public Works Department is also in the early stages of implementing Cityworks Server and Fleet Maintenance will eventually use it at the beginning of the new fiscal year. “The St. Johns County Public Works Department has benefited from using Cityworks as an asset maintenance management application for our transportation and stormwater assets,” states Rocky Agbunag, St. Johns County Public Works Asset Management Coordinator. “We were faced with a decision to either continue or upgrade the previous fleet management application. We knew Cityworks is flexible enough for this implementation; it’s just a matter of being innovative in using the application to find the right solution for our Fleet’s workflow process. Our implementation went well and its results exceeded our expectations. I thought embracing the technology would be the biggest challenge of the implementation, but it became the easiest. We can definitely tailor the software to our needs and it offered a lot of flexibility.” cw

The County will soon rely on NAPA Auto Parts to provide a turnkey solution providing parts for

Azteca News W e l c o m e to A z teca’s Newest Employees! Joining our software development department is Lance Wintch. He grew up in Salt Lake City, Utah, and before coming to Azteca, worked at Intermountain Healthcare in their IT Department. He began programming on the side while going to school. He is currently attending Salt Lake Community College and majoring in computer information systems (CIS). He was married in 2006 to his wife, Audry, whom he calls “an incredible woman who lets me play video games.” cw

Michael Robbins joins Azteca Systems as our newest software tester. Raised in Utah, previously he managed a construction company, supervised a fraud investigation team at Bidpay.com, and then worked for GE Money. He returned to school in GIS at the University of Utah where he plans to graduate in December. He has five children who love to come visit dad and enjoys jet-skiing, scuba diving, camping, and traveling. In the three years he lived in Florida, he experienced five hurricanes. cw

Daniel Strong recently joined the Azteca Systems software testing department. He was born and raised in Mesa, AZ. After serving a mission in Billings, Montana, for his church, he worked for a company called Pool Chlor where he chemically serviced pools for about 5 1/2 years while he was attending school at Arizona State. He graduated in geography with a GIS certificate.

Adam H u n s a ke r, has joined our training department as a Technical Trainer. Born in Utah, after high school he had a short stint at UCLA before signing with the Arizona Cardinals practice squad. He reverted to the indoor football league for a few years where he sustained some severe injuries which ended his football career. This caused him to consider the notion that he should have worn a helmet! He and his wife, Denise, have one “child” – a Labrador named Hemi who is 3 years old and has a bottomless stomach. They refer to Hemi as “The Great Mustachio.” He can make anything disappear before your very eyes. Adam’s interests are varied but include leatherwork and keeping his family and friends equipped with all the dog collars, belts, bracelets, purses, and bags they could ever want. cw

Daniel is one of seven children in his family. He and his wife, Alisha, are expecting their first child, a boy, in March. Theirs is an online match-service success story. They met online, dated, and have been happily married for three years! cw

INPRINT — March 2010

Get to Know.....

Sales, Marketing, & Administration T o m P a l izzi E x e c u ti ve Director, S a l e s & Marketing • Born in Denver, Colordo. • Lived in the Denver area all but a brief stint in Washington DC. • Graduated from the University of Colorado with a BS in Architectural Engineering. • Hobbies/Interests: Skiing, snowboarding, sailing, tennis, traveling, fly-fishing and cycling (motor & pedal powered) – all with family and friends. • Interesting tidbit: Though I was born, raised, educated, and still reside in Colorado, I’ve spent nearly my entire career working in Utah. I consider myself an honorary Utahn!

Dave Bramwell, Client S e rv i c e s M a n a g e r , Southeast Region

B e c k y T amashasky, Client S e rv i c e s Manager, Great Lakes Region • Born at Camp Pendleton Marine Base outside of Oceanside, CA. • Lived in California, Virginia, Maryland, Michigan, and Indiana. • Graduated from Virginia Tech with a BS in Civil Engineering. • Hobbies/Interests: Running, photography, house renovations (which our house provides plenty of), being at the beach. • Interesting tidbit: I met my husband at his grandmother’s funeral.

• Lived in Simi Valley, CA; Gilbert, AZ; Barcelona, Spain; Corvallis, OR; San Clemente, CA; Kailua, HI, and now Wake Forest, NC. Hawaii being the longest residence and place he calls home. • Graduated from BYU-Hawaii in Computer Information Management and attended graduate school at Oregon State University in Water Resources Geography. • Hobbies/Interests: Enjoys reptiles and bugs, fly-fishing for anything that swims, surfing as much as the East Coast waves can supply me (which is not enough) and extremely addicted to wind and getting big air kiteboarding at Cape Hatteras and the Outer Banks (one big reason why I live in North Carolina). • Interesting tidbit: Met my wife, Susan, at school in Hawaii. They have 4 kids (3 sons and finally the last one, a daughter.) We are all beach bums.

Mariann e H a s l a m , A d m i n i s tr a t i v e Assistan t & E x e c u t i v e S e c r e ta r y • • • •

Born in Salt Lake City, Utah. Lived in Louisiana, Texas, and Utah. Attended BYU 2 yrs. – majoring in journalism. Hobbies/Interests: Biking, hiking, snowmobiling, travel, fashion, reading, nature – love the outdoors. • Interesting tidbit: I’m utterly useless reading a map.

Cara Haslam, M a r ke ti n g / A c c o u n ti n g

L i n d s a y F e r g u s o n , M a r ke t i n g & P R • Born and lived in Utah. • Graduated from the University of Utah with a BS in Communication. • I enjoy reading, music, traveling, boating, cooking, and keeping busy with my two-year-old son and 6-monthold baby daughter. • Interesting tidbit: Lindsay has also dabbled in modeling. Check out the photo gallery at www.fishingproperties.com and you’ll see her fishing (which she doesn’t do – she was afraid of fish) and hiking in the outdoors. She was “discovered” by the owner while singing at a wedding.

• Born and has lived in Utah. • Graduated from BYU with a BS in GIS in April 2009. • Enjoys tennis, video games, and is a huge Jazz and BYU fan. She can talk “sports” with the best of them. • Interesting tidbit: Has traveled to Japan twice and speaks Japanese. Originally planned to major in Japanese but then got lazy and settled for GIS!

INPRINT — March 2010

G e t t o K n o w . . . (cont.) B r e n t W ilson, Nation al Sales Manager, S o u t h e r n Region • Born in Port Arthur, TX. • Lived in Port Arthur, TX; Groves, TX; Grand Prairie, TX; Arlington, TX; and NOW Waxahachie, TX. (Do you see a theme???? I love Texas.) • Graduated from Tarrant County College – Associate’s of Arts and Science. • Hobbies/Interests: Church, church activities, being with my family. • Interesting tidbit: The line in my hair isn’t a new style I’m trying to pull off, but rather a 7” scar from a car wreck when I was 4 years old. Of course, this was back when seat beats were almost unheard of and kids would stand up in the backseat while the car was moving.

Billy Lang, C l i e n t S e r v i c e s M a n a g e r , S o u th e a s t R e g i o n

Josh Stroessner, Client S e r v i c e s M a n a g e r , Northern Region • Born in Sheboygan Falls, WI. • Lived in Sheboygan Falls, WI; Whitewater, WI; Scottsdale, AZ; Baraboo, WI; and currently Elkhart Lake, WI. • Graduated from Unversity of Wisconsin – Whitewater (College Division 3 football National Champs 2009) in Technical Geography and Arizona State University, Masters of Advanced Study in GIS. • I love the Green Bay Packers and Milwaukee Brewers – attending games, watching on TV, etc. I also love cooking and vacationing with family. • Interesting tidbit: Currently training for my first half marathon on Memorial Day weekend.

R u s s e l l Shino, RFP’s • Born and lived in Utah. • Graduated from University of Utah with a BS in Meteorology. • I enjoy fishing, tying flies, playing golf, playing tennis, watching sports, and betting sports (legally). • Interesting tidbit: I folded fortune cookies for a few years before working at Azteca.

C i n d y C urletti, Marketing & BP Administrative A s s t. • Born in Upland, California. • Lived in California and Utah. • Graduated from Fashion Institute of Design & Merchandising (FIDM) with an Associate’s in marketing. • Hobbies: Love vactioning anywhere warm with water and a beach, scuba diving, snorkeling, boating, waterskiing, and hiking with the family. I also enjoy snow skiing (but only while I wait for the warmth to return). I enjoy spending time with family and close friends watching movies, playing games, and summer barbeques. • Interesting fact: My how times have changed…. When I was 12 years old, my parents gave me permission to board a train for an 8-day trip from California to the Grand Canyon with a school club. We backpacked for four days to the bottom of the Grand Canyon and out. I would never allow one of my kids to do that today, at least not without me in tow. Sure glad my parent’s allowed me to because it was a great experience!

INPRINT — March 2010

• Born in Janesville, WI. • Lived in south central Wisconsin (including Janesville, Beaver Dam, Whitewater, and Madison) and Colorado (Denver, Vail, and presently Wheat Ridge). • Graduated from the University of Wisconsin – Whitewater in Urban & Regional Planning and Political Science. • Hobbies/Enjoys: Traveling, stand-up comedy, cheese, live music, MST3K (Mystery Science Theater 3000), and various outdoor activities including cycling, hiking, fishing, camping, basketball, snowboarding, and snowshoeing. • Interesting tidbit: Recently traveled to Peru and New Zealand. Courtney and I have two cats, Lucy and Lila.

Phil Mogavero, Client S e rv i c e s M a n a g e r , No r th e a s t R e g i o n • Born in Buffalo, NY. • Lived in New York and Canada. • Bachelor’s degree from Buffalo State College in Urban and Environmental Planning and Masters in Geography/GIS from the University at Buffalo. • Hobbies/Enjoys: In my younger days, I lived in Canada for 7 years where I learned to play... what else? ... hockey! Some of my other interests include hunting, fishing, backpacking, golf, skiing, racquetball, and tennis. But to this day, I still play league ice hockey. One of my favorite hobbies since a kid has been coin collecting. These days my number one hobby is spending time with my wife and three daughters, who also enjoy a variety of indoor and outdoor activities.

K a y e R y s e r , M a r k e ti n g & A d m i n i s tr a t i v e A s s i s t a n t • Born in Utah and lived in California, Texas, and Utah. • Attended the University of Utah majoring in business – but alas, did not graduate! • I enjoy traveling (especially warm places), boating, and being a grandma! • Interesting tidbit: When I described some of my job responsibilities to a friend (duties which include not only marketing but various office details), she said “Oh, you’re the mom!” Once a mom, always a mom!

Can you guess who my handsome brothers are? (Answer on page 32)

P e r s o n a l P r e p a r e d n e s s . . . Some of these apply to your work en v i ro n m e n t a l so.

E m e r g e n c y P r eparedness

Things you wi l l n e e d ...

1 2 th i n gs to do to prepare your family/compa n y f o r a d i s a s te r

but won’t have time to find*

1 . H a v e an emergency plan – Develop, maintain, and practice a written, comprehensive plan for emergencies. 2 . G e t an emergency kit – Assemble and maintain a portable 72-hour kit. 3 . H a v e an emergency food supply – Fortify home base with food, water, and other essentials to care for the needs of residents. Supply business also in case shelter is sought within your builiding. 4 . P r e pare to shelter-in-place – Evacuation might expose a population to a greater danger than “staying put.” Be prepared with blankets, activities like board games, alternative light source, etc. 5 . K n o w your home/office – Learn how to operate electric circuits, natural gas and main water shut-off valves, outside air vents, etc. 6 . T a k e inventory – Inventory items of special value and importance and know their location. 7 . E q u ip your car – Keep a blanket, first-aid kit, snacks, and water in your vehicle. 8 . P r e pare to go powerless – Prepare the home / office to remain secure and reasonably comfortable during short or extended periods. 9 . P l a n for pets – Have an emergency kit for your pet as well as an alternate location that accepts pets in case of an evacuation. 1 0 . F i g ure financial contingencies – Anticipate and plan for the interruption of income because of loss of employment, illness, or even the unexpected death of a breadwinner. 1 1 . R e member your health – Plan for medical needs during a time of extended emergencies. Emphasize critical life-supporting medications and supplies. 1 2 . R e m ember those with special needs – This may include someone outside your home who may need your assistance.

• Personal identification • Cash and coins • Credit cards • Extra set of keys and car keys C o p i e s o f th e f o l l o w i n g :

• B i r t h c e r t i f ic a t e s • Ma r r ia g e c e r t i f ic a t e s • D r ive r ’s l ic e n s e s • S o c ia l S e c u r i ty c a rd s • Pa s s p o r t s • W i l ls / Tr u s t s • D e e d s • Inve n t o r y o f h o u s e h o ld / o ff i c e goods

• In s u ra n c e p a p e r s • Im m u n iz a t io n re c o rd s • B a n k a n d c re d i t c a rd a cc o u n t numbers

• S t o c k s a n d • E m e rg e n c y

bonds c o n t a c t l is t w i t h p h o n e

numbers

• Ma p s • L is t s o f

a d d re s s e s a n d t e le p h o n e

numbers * Best stored in a waterproof container

WELCOME NEW CITYWORKS USER’S! Columbia, SC

Midland, MI

Cook County, IL

Milwaukee General Mitchell

Coon Rapids, IA

International Airport, WI

Cranbrook, BC, Canada Cupertino, CA Brent Haslam, VP / Chief Operating Officer (center) and Brian Haslam, President / CEO (right)

MittSverige Vatten AB, Sweden

Highland Village, TX

Pleasant Prairie, WI

Lake Haven, WA

Richfield, MN

Livingston County Drain

Salisbury, MD

Commission, MI

Vernon, BC, Canada INPRINT — March 2010

Charlotte, NC (cont. from page 1) Charlotte, NC (cont.)

know what to do and where they need to be to get the city back up and running as usual. Cityworks was implemented in 2009 by the City to replace a work management system created by the IT staff. When Cityworks was installed, it included an application called DataPump. Early on, administrators recognized the possible adaptation of DataPump for use in emergency situations. In the normal operation of DataPump, the user takes service requests and/or work orders submitted from the main production server and ”checks them out” to a laptop and then disconnects the PC from the main network. The laptop has the capability to interact with these requests and work orders in the field without any network connectivity to the main server. At the end of the day, the laptop is brought into the office to ”check in” all the information entered in the field. Their backup/emergency plan is designed around this module. The question was raised about the ability of the Cityworks software to assist the City in planning and responding to customer emergencies, tracking the calls coming into the emergency center, and dispatching the help needed to work crews with the location, asset information, and/or customer responses to those requests. They found this a difficult task without constant server connectivity; however, anticipating possible power interruptions, they wanted the ability to collect and store all the work record information in an emergency without power and network connections. At about this time, they discovered a possible solution to the connectivity issue. All they needed was to supply some PCs with power from a generator already installed in the office which powers one room along with a call taker’s station. This gives them the ability to take calls and respond with service request or work requests from DataPump software loaded and prepared on certain PCs for emergencies. “DataPump is a module normally used to allow field crews access to their Cityworks data in the field. In this case, we are using DataPump as our emergency response plan to keep our operations running during severe weather or a storm event.”

Since they determined to keep things as close to normal as possible during a storm event, Cityworks was installed on these PCs and configured to use with DataPump. They loaded SQL Express on each of these computers and only added those users to the new SQL database that would be manning these computers in an emergency. Using Cityworks Anywhere, they created a personal geodatabase on each emergency computer which contained only the feature classes that would be absolutely necessary to help speed up the application. In addition to exporting the feature classes, they set up address locators to geolocate the service requests. Once this data was saved in the

personal geodatabase, they created a “Remote.mxd” map document on the computers which points to the feature classes in the personal geodatabase and added the address locators from the personal geodatabase to the .mxd. The final step in the process will take place if and when they know a storm is coming. When they are notified of a call for severe weather, ice, or the remnants of a hurricane, all they need to do is update the feature classes in the personal geodatabases and recreate the address locators using that new data. Then logging into DataPump as the user “Azteca,” the databases are synced on each emergency computer. This, by default, reserves 1000 work order and service request IDs to use during a storm event. In addition, every emergency PC is allowed to run independent of network connections so work orders and service requests can be created on the fly by any user that has been configured to log in on the PCs. The next step is changing the configuration of Cityworks to point to the personal geodatabase on the computer and opening Cityworks Anywhere pointing to the “Remote.mxd.” The users rely on the “Remote.mxd” and the data on the SQL database stored on the computer’s hard drive from the time the databases are synced until the severe weather is over. Once conditions are safe and stable, DataPump is used to check in the data from the SQL Express databases on the laptops back into the SQL production database on the server. Then the Cityworks configuration on the laptop is changed back to the SQL database and geodatabase on the server and users are back up and running using normal operations. Amy Rockwell, Senior Business Analyst for Engineering and Property Management, explains, “DataPump is a module normally used to allow field crews access to their Cityworks data in the field. In this case, we are using DataPump as our emergency response plan to keep our operations running during severe weather or a storm event. This backup plan has been setup and tested; however, we have not yet had an opportunity to employ it. But we know that if we do ever have to employ it, we are prepared and ready to go.” Many Cityworks sites, like the City of Charlotte, implement innovative and creative solutions using Cityworks for normal maintenance work as well as to plan for disaster preparedness. Because of its flexible nature, Cityworks can be customized for a large variety of uses. A b o u t C h a r l o t te The City of Charlotte is the 18th largest city in the U.S. with a population of 687,456 in 2008. Located within the Southern Piedmont of North Carolina along the state’s border with South Carolina, it is the most accessible city between Washington DC and Dallas. Charlotte has been recognized by relocate-America.com and CNNMoney.com as one of the best places to live, combining the cosmopolitan city with the ease of Southern charm. cw

INPRINT — March 2010

Herriman, UT (cont. from page 1) Herriman, UT (cont.)

response in the Cityworks software. The City reformatted forms from Community Emergency Response Teams (CERT) and created different event layers and emergency templates in Cityworks. They also set up emergency procedures helping them identify the state of emergency and what kind of response was needed, all tracked with Cityworks. These steps include: 1. Identify the emergency. 2. Prioritize the situation. 3. Identify the resources needed (and/or resources that have been deployed) to aid in emergency response and recovery. 4. Track individuals involved in the relief effort of the emergency situation. “These steps have proven to be important and effective in assisting our staff and following up with emergency or simulated emergency situations,” explains Steve Brown, ITS Manager. “For instance, a broken water line is going to have a different state of urgency than a broken gas line, and both are going to have a much different state of urgency than an earthquake. Before we had Cityworks, trying to gather this type of information and store it in one location was virtually impossible. That’s why Cityworks is such a natural fit for this need. We can bring up the location of an emergency on the GIS map, prioritize it, and respond to it accordingly. It is extremely nice to have a centralized database and one source of input where all our information is collected, whether remotely or in office.” “There was never a question of whether we would use Cityworks for emergency management, on the contrary, with everything I knew about the software and GIS, I felt the bigger question would be why wouldn’t we use Cityworks for our disaster management needs.”

During mock disasters, the entire city is involved, including its citizens. Herriman residents play an active role in the drills through the “Be Ready Herriman” volunteer group, led by Coralee Moser. A scenario is taped to the doors of volunteer leaders to notify them of the disaster and asking them to identify the disaster and/or assistance needed and relay the information back to the City by cell phone or ham radio. Currently, ham radio operators are the channel of communication from City authorities back to personnel at emergency sites. Whether receiving information by radio or from handwritten notes, the ability to input data into one system with its various fields and attach it to an emergency is extremely useful. In Cityworks, the city is broken into blocks, teams, and areas. Most of the emergency tracking is done through service requests. The request

City broken into emergency blocks.

CERT volunteers gather during a mock disaster.

template outlines applicable questions and answers to help prioritize and identify the needs of any situation. Work orders are used to track work activities related to a disaster as they record information about labor, materials, equipment, costs, and related assets. The City is focusing on creating Crystal Reports which automatically link data from Cityworks to produce viable emergency reports for FEMA, thereby eliminating the need to replicate data. “In a major disaster, it takes months and even years to clean up after everything – it’s a long-term process,” states Brown. “Being able to identify problems from the beginning makes this type of situation a lot easier on staff and in dealing with the larger government. With an emergency preparedness plan, steps can be taken, such as pre-signed agreements with city, state, and local contractors, where rates that would be charged for disaster cleanup and recovery are identified. This type of preparation creates that much less work to be done in an emergency if it is already set up in a system.” Herriman holds community-wide disaster drills biannually, every spring and fall, giving staff the opportunity to practice putting their disaster response steps into action. As they move through the drills, it allows them to refine their processes and improve on tracking and identifying resources. Herriman has set up an emergency response trailer as a mobile command post during an emergency. Ham radio operators receive calls and are able to input emergencies into the system and deliver reports as to the level of emergency, time stamps, etc. Thus far, Herriman has held three drills, and each time their processes have improved dramatically. Mock disaster drills are good exercise for City staff because they can identify where their needs are and what things need to be improved in the future. In regard to their last mock disaster drill, Brown recounts, “Because of a shortage of staff on the day of our last drill, I had to recruit my wife to assist in the office with Cityworks. As a testament to the user-friendly nature of Cityworks, my wife was able to come into the office having never seen the software before and, after only a couple inputs, she felt comfortable taking a lead inputting data and performing the tasks we needed her to do within Cityworks for the disaster response efforts.” In a separate drill, Providence Hall, a charter school with about 700 children from Kindergarten through 9th grade, was evacuated. Military buses from Camp Williams transported school staff and children to a local park where they were fed lunch and kept in groups until each child was released to a parent or guardian with a driver’s license for ID. This was good practice for City staff to keep track of the children and identify an area to contain. The drill required coordination between the school, City, military, Unified Firefighters’ Association (UFA), sheriff’s department, and volunteers, and was very successful. The next day the City staff and citizens practiced what to do in case of wildfire and rehearsed evacuation of certain areas.

INPRINT — March 2010

H e r r i m a n , U T ( c o n t .)

Radio transmissions entered as service requests

becomes available for needed resources. If a municipality has tracked resource information with records to back it up, they are entitled to 25% reimbursement from the state and 75% from the federal government. In many cases, municipalities don’t have a disaster management system put into practice and fail to track resources used and, therefore, are not eligible for reimbursement. Cityworks creates an easy way to account for and track resources and in addition produces viable information to provide to government officials, enabling full disaster costs reimbursement.

“The ROI (return on investment) aspect Cityworks provides us in this area is incredible,” declares Brown. “It gives us a sure way of knowing that all our expenses will be reimbursed if we have a disaster situation. This alone is one of the biggest benefits Cityworks provides us because the amount of money we could save in the long run is huge. It’s like an insurance policy – a small price to pay for the tremendous savings we will The upcoming drill, scheduled for March, will simulate an earthquake and incur should we ever have a large-scale disaster. We have the comfort of a breech in a reservoir, which will address flooding and casualty issues. knowing that we are covered in a disaster as far as money goes, thanks Damage areas will be identified and put into Cityworks. The City hopes to Cityworks and the management capabilities it provides, and that is to continue to increase the scope and complexity of its drills to better worth a lot.” prepare the city for any type of disaster. In 2011 or 2012, Herriman will be participating in a national drill with FEMA which will be a type 1, largeAs Herriman continues to advance their disaster preparedness efforts, scale disaster. the scope of their system and operations will further expand. In the future, the City would like all emergency calls – police, fire, etc. – to be Background tracked in Cityworks. They plan to take a closer look at how they can Federal and state mandates require Incident Command System (ICS) incorporate FEMA forms into Cityworks and look into the ability to do a training designed to improve emergency response operations of all mobile deployment so that if the system goes down in office, they can types and complexities. Brett Wood, Herriman City Manager, felt the access it from a laptop. need to thoroughly train City staff in ICS, and he along with 11 other staff members traveled to and participated in a FEMA training course With their new disaster management system, Herriman has made great to increase their knowledge on the subject. However, the emergency strides in becoming organized and prepared for a state of emergency. training scenarios they encountered didn’t include a role for IT/GIS staff Herriman hopes they will never have to deploy their disaster management members. As ITS Manager, Steve Brown immediately recognized the role plans in a real disaster. But citizens, staff, and management know if they GIS could play before, during, and after a state of emergency. ever do, they’ll be prepared for the worst so they can expect the best outcome, regardless of the situation. During this same time, the City recognized the need for an asset-based CMMS (computer maintenance management system). Cityworks was a More about the City of Herriman natural fit for their needs and was soon implemented in the Herriman City Bounded by the scenic Oquirrh Mountains, Herriman City is tucked away Public Utilities Department. “GIS is key in identifying assets and Cityworks in the southwest corner of the Salt Lake Valley. In the past decade, becomes the backbone and workhorse of the asset management,” claims Herriman has evolved from a remote farm town to a vibrant suburb of Brown. “Identifying costs of resources and contractors and tracking Salt Lake City with new neighborhoods, developments, and an emerging history/information has never been easier.” economy. Population grew from 1523 residents in 2003 to 17,689 by 2008. Residents boast of its continuing small-town feel while still being While getting to know the software and recognizing its capabilities, within close proximity and commuting distance to metro areas along the Cityworks also became a natural solution for Herriman’s emergency Wasatch Front. cw management needs. “We soon recognized how we could easily tailor Cityworks to fit all of our management needs, including disaster preparedness,” says Brown. “There was never a question of whether we would use Cityworks for emergency management; on the contrary, with everything I knew about the software and GIS, I felt the bigger question would be why wouldn’t we use Cityworks for our disaster management needs.” Using For Herriman, the ability to customize Cityworks is the key to effectively tracking an emergency. Cityworks creates a solution that makes every step of emergency management and response more efficient and less time-consuming. With a lot less paperwork to deal with, staff members can focus more on tending to the needs of the city and its citizens.

Cityworks during the mock disaster.

Cost Benefits of Using Cityworks Cityworks work orders track resources, costs, time spent, and any other details pertinent to disaster response. Once a crisis situation is officially declared a disaster by state or federal government, reimbursement money

INPRINT — March 2010

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

If you have received this newsletter in error, please call 801-523-2751 or email kryser@cityworks.com.