InPrint Sprint 2009

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

City of El Paso Implements a Multi-Year Pavement Management Solution

By Craig Schorling, GISP, Transmap Corporation With a population of 700,000, El Paso, Texas, is the 22nd largest city in the United States and the 3rd fastest-growing metropolitan area. The City maintains 3300 miles of paved streets and has over $2.5 billion invested in pavement alone, with $60 million in backlogged pavement updates.

Such an investment necessitates careful management and the City wanted to get the best bang for their dollar when it came to pavement funding.

Harold Kutz, P.E. for the City of El Paso, summed it up like this, “Good pavement management begins with a plan. That plan holds the different strategies to better allocate the dollars that are routinely spent maintaining asphalt. When the PCI value reaches a low number, often it is too late to stop the deterioration. El Paso has proven internally that it’s better to spend dollars to maintain ‘good’ asphalt than to waste treatment in areas that can only be PCI or Pavement Condition helped by reconstruction.”

Index is a number from 1-100 to indicate the overall quality of a road’s surface. It is based on the type, quantity, and severity of distresses, like alligator cracking or potholes. The higher the number the better the road condition.

Despite such sound reasoning, the El Paso Public Works Department faced the daunting task of defending their pavement funding requests. El Paso’s Pavement/Quality Control Manager, Continued on page 24

Cityworks User Spotlight— Grand Rapids, Minnesota

By Michael LeClaire, GIS/CAD Technician, Grand Rapids, Minnesota Situation At the City of Grand Rapids Public Works Department, we used to keep track of all our work orders on handwritten notes. If any budget analysis or estimate of cost on a specific work task was needed, the task would be very time-consuming, if at all possible as the only way to retrieve data for analysis was to go back through handwritten time sheets and daily work logs from Public Works staff to identify who had worked on the task being analyzed. However, in most cases, the analysis was simply estimated because of how time-consuming it was to complete. Also, there had never been a link from any of our work orders to our GIS, making it nearly impossible to identify which structures we had worked on and how often the work was completed, except from the memory of staff members.

Continued on page 22

INSIDE THIS ISSUE Features

El Paso, TX, Implements a Multi-Year Pavement Management Solution

1

Grand Rapids, Minnesota — Cityworks Spotlight

1

President’s Corner — Weighing Your Cityworks Server Options

2

Software Update — Cityworks Permitting: Integration Update

4

Cityworks Server MMS Released

5

Project Management

Naperville, IL, Integrates Cityworks and GovQA through Cityworks Service Request API

6

Edmond, OK, and Cityworks Small Government ELA

7

Client Services — The 411 from the Cityworks Campus

7

MyCityworks.com — Your Destination to Self-Help Support Technology Support Update: Cityworks/ESRI Versions Partner News — Fulton County Public Works, GA, Keeps Doing What It Does Best with Cityworks (Velocitie)

El Paso, Texas, Skyline

8 9 10

City of Oakland, CA, Begins Rollout of Cityworks Server (Vestra)

13

Cityworks Server MMS Rollout/User Group Seminar Series

16

Regional News

18

Get to Know — Cityworks Software Developers

20

Special Achievements — ESRI SAG Awards

27

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

President ’s Corner

InPrint Editor in Chief: Tom Palizzi Editor: Kaye Ryser Advertising: Kaye Ryser Azteca Systems, Inc. 11075 South State Street, Suite 24 Sandy, UT 84070 801-523-2751 www.cityworks.com To receive a subscription or to change your address, please send your contact information to:

Weighing Your Cityworks Server Options

By Brian Haslam, President, Azteca Systems, Inc. Many of you are weighing your options to determine where Cityworks Server might fit in your organization. Repeatedly and for multiple years, we have promised cross-compatibility between Cityworks Desktop, Anywhere, and Server MMS. Crosscompatibility is defined as all three Cityworks applications sharing a common Cityworks database and, therefore, being able to be used simultaneously by different users within an organization. We have received positive feedback from targeted release sites for Cityworks Server MMS and our cross-compatibility assurance.

inprint@cityworks.com or call 801-523-2751 Founded in 1986, Azteca Systems, Inc. is the leading provider of GIS-centric Enterprise Asset Maintenance Management Systems for Public Works and Utilities. Built exclusively on top of ESRI’s leading GIS technology, Cityworks is powerful, scalable, and affordable.

How to Reach Us: Tel: 801-523-2751 Email: info@cityworks.com

InPrint is published by Azteca Systems, Inc. (Azteca), at 11075 South State, #24, Sandy, UT 84070. InPrint contains material of interest to utility and public works organizations.

Copyright © Azteca Systems, Inc. 2009 All rights reserved.

Printed in the United States of America.

The information contained in this document is the exclusive property of Azteca Systems, Inc. The work is protected under United States copyright law and other international copyright treaties and conventions. No part of this work may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying and recording, or by any information storage or retrieval system, except as expressly permitted in writing by Azteca Systems, Inc. All requests should be sent to Attention: Cityworks InPrint, Azteca Systems, Inc., 11075 South State Street, #24, Sandy, UT 84070. The information contained in this document is subject to change without notice.

Azteca Systems and Cityworks are registered trademarks; Cityworks Desktop, Cityworks Anywhere, and Cityworks Server are trademarks of Azteca Systems, Inc.; and www.mycityworks. com, www.gocityworks.com, @azteca.com, www. azteca.com, @cityworks.com, and www.cityworks. com are service marks of Azteca Systems, Inc. The names of other companies and products herein are trademarks or registered trademarks of their respective trademark owners.

2

Most of you will see the benefits of deploying Cityworks Server MMS for many of your users.

The core functionality needed for a robust maintenance management system exists in both systems. However, some functionality in Cityworks Desktop is not in Cityworks Server MMS. As you consider deploying Cityworks Server MMS, it is important to remember that all the current functionality you rely on is still available in Cityworks Desktop and Anywhere for those users who need it. Cross-compatibility does not mean 100% equal functionality for both systems. It means you can deploy Cityworks Server MMS for users where it fits without needing to move every user from Cityworks Desktop or Anywhere. Both applications will continue to be the preferred choice for many users.

Most of the functionality in Cityworks Desktop exists in Cityworks Server MMS. Over time we expect most (but not all) of the gaps to be closed. Feedback we have received from targeted release sites identifies specialized inspections as a high priority development task for Cityworks Server MMS. We are prioritizing development based on the collective feedback of clients who have committed to implement Cityworks Server MMS by issuing a PO. Our highest priorities for development are for clients who are providing R&D support in addition to contracting for Cityworks Server MMS implementation.

INPRINT — MARCH 2009

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

For those of you who do not have plans at this time to deploy Cityworks Server MMS, you need not worry that Cityworks Desktop or Anywhere are obsolete. Crosscompatibility provides the opposite assurance and has greatly extended the useful life of both applications. We continue to dedicate major R&D resources towards maintaining and enhancing Cityworks Desktop and Anywhere.

Another exciting development for Cityworks Server is Permits. Cityworks Server Permits provides a fully functional permit and business license system in a unified webportal environment with Cityworks Server Inbox, Service Request, and MMS. Our reps will be happy to assist you in exploring if your organization may benefit from a fully integrated GIS-centric MMS and Permits system.

To assist you in weighing your options, we are holding a series of Cityworks Server Rollout Seminars for Cityworks users at various locations throughout the USA. Information about the locations and dates are listed on pages 16 and 17. We hope to see you at one of the seminars. cw

Work Order #5306 viewed in Cityworks Desktop

Work Order #5306 viewed in Cityworks Server MMS

Cityworks 2010 User Conference Sa me location different date!

May 3 - 5, 2010

Cityworks Permits contained in the CW Portal containing Cityworks Server MMS

St. George, Utah Dixie Center

Pre-Conference Training April 30 - May 1, 2010 Hilton Garden Inn St. George, Utah www.cityworks.com for more information

INPRINT — March 2009

3

Software Update

Cityworks Permitting:

Integration Update

By Kirk Dunn, Project Manager, Azteca Systems, Inc.

Many users are anxiously awaiting the release of Cityworks Permitting as a fully integrated application with Cityworks Server MMS. With the commercial release of Server MMS behind us, we are able to devote more attention to this important goal. Getting there will take a reasonable level of effort and involve the completion of numerous tasks, which fall into three main areas.

1. Integr a t i n g P e r m i tti n g i n to th e C i ty w o rk s Server Po r ta l The Cityworks Server Portal is the framework that houses the MMS and Permitting applications. This integration work began in the latter part of 2008 and we are pleased to say that we are very close to completing it. (See figure 1.)

By integrating Permitting into the Cityworks Server portal, we will be able to institute practices within Permitting that are similar to MMS, such as a map-side toolbar with functions to initiate and query permitting cases, expanded functionality of current tools to (for example) define and display permit event layers, and the ability to open a permit by clicking an event.

The core Permitting application will also receive functionality from the MMS, such as the ability to add a GIS feature to a permitting case – similar to “Get from Theme” in a work order. (See figure 2.) And like work orders, users will be able to create permits against any configured asset type in the organization’s ESRI geodatabase.

Figure 1. Permitting in Cityworks Portal

2. Integr a ti n g t h e F u n c ti o n a l T o u c h P o i n t s of MMS and P e r m i tti n g A more recent area of focus involves the integration between MMS and Permitting’s Workflow Engine. Many users have requested that Permitting track code enforcement cases and other types of cases originating in Community Services or Building Departments. Often these cases lead to crews being dispatched on-site to investigate violations or abate and repair existing hazards. Users will be able to define tasks within a permitting workflow that can initiate a service request or work order within the MMS. (See figure 3.)

Behind the scenes, Permitting’s Workflow Engine will call the corresponding MMS method and the entire operation will be transparent to the user. Any service requests or work orders that are created will have all the properties configured in Designer, including “submit to” and domain/group securities.

As service requests and work orders are completed in the MMS, a call back will be made to Permitting to proceed with the next task in the workflow. This integration will allow users to use the application best suited for their daily work, while allowing information to pass seamlessly between personnel in the organization’s various departments.

and update Permitting tables as well as Designer being updated to support the configuration of GIS-related functionality in Permitting.

3. Integr a ti n g th e D a ta b a s e s Another very important goal is to combine the databases for Server MMS and Permitting. This will provide for greater ease in administration and a more thorough integration of the applications. Database Manager will be expanded to define

It is important to mention that considerations in these three areas are being made so as not to disrupt those users who are currently deployed with Permitting Standalone. By leveraging the existing functionality of MMS and Permitting and bringing them together in the Cityworks Portal, end users will not have to be retrained on a new system and existing permit (or work management)

4

Figure 2. Permitting’s equivalent of “Get From Theme”

INPRINT — MARCH 2009

S o f t w a r e U p d a t e ( c o n t .) configurations will not have to be rebuilt to support the integrated system.

Finally, our efforts to expand the core functionality in Permitting still continue. Many enhancements have been made but some of the more noteworthy ones are: • A Public Access module that allows citizens and contractors to enter cases online.

• Related documents can be added through Public Access – including pictures.

• A case data detail can be visually symbolized, such as inbound, outbound, roundtrip for a wide load, etc.

• Case data fields can be required at intake through Public Access and the core.

• Data groups can be collapsed within the case data grid.

• The ability to add custom tables to a case object.

• Task and case level security to control for signoff and case application in both the core application and Public Access.

Figure 3. A Permit’s Workflow Tasks

We’re excited about our progress in these areas and look forward to rolling out a fully integrated MMS and Permitting solution soon. We encourage you to contact your Cityworks sales representative with any questions. cw

Cityworks Server MMS Released Managing the care of assets and infrastructure is easier today than ever with the release of Cityworks Server MMS by Azteca Systems. This product is the first web-based Asset Maintenance Management System built exclusively on ESRI’s ArcGIS Server and designed to complement Cityworks Desktop and Anywhere products. Cityworks Server MMS offers state-of-the-art technology and provides agencies an advanced and efficient way to enable staff throughout the enterprise.

Cityworks Server MMS is Azteca’s next generation, GIS-centric Asset Maintenance Management System. Based on the success of Azteca’s industry leading Cityworks software, Cityworks Server MMS was designed and created “from the ground up” for ESRI’s ArcGIS Server technology.

Cityworks Server MMS is a modern, browser-based system designed to manage assets, issue and track service requests and work orders, perform inspections, and manage customer needs. Cityworks Server MMS shares a common database with Cityworks Desktop and Cityworks Anywhere, allowing organizations the unique cross-compatible benefit of blending Cityworks solutions – browser and client/server – to best meet their specific needs.

Dusty Borchardt, Systems Analyst at Oklahoma City, Oklahoma, recounts: “Oklahoma City had the opportunity to work with Azteca Systems as an early adopter of Cityworks Server MMS. We tested several development versions of the product and I’m really impressed with the commercial release. From an IT perspective, Cityworks Server MMS will allow us to reduce our client installs as well as our annual maintenance costs.

And, since Cityworks Server MMS is cross-compatible with the desktop

INPRINT — March 2009

applications, we’ll be able to transition our users from Cityworks Desktop to Cityworks Server MMS with the flexibility of running both applications in the same environment. We anticipate phasing Cityworks Server MMS into our production environment in the first quarter of 2009.”

Several organizations are implementing Cityworks Server MMS including the cities of Edmond, Oklahoma; Champaign, Illinois; Oakland, California; Frisco, Texas; St. Cloud, Florida; Philadelphia, Pennsylvania; Oklahoma City, Oklahoma; Wayne County, Michigan; Montgomery County, Ohio; and Macon Water Authority, Macon, Georgia.

“We are very excited about this much anticipated release of Cityworks Server MMS,” stated Brian Haslam, President of Azteca Systems.

“Server MMS represents a significant milestone for our customers and our company. A major part of our Cityworks 4.5 release, Server MMS allows our users to dramatically improve operational efficiencies of their organizations through a 100% GIS-centric enterprise solution. Through our unique cross-compatible approach, Cityworks customers can easily mix-and-match whatever selection of Cityworks applications might best meets their needs. From full web deployment to a mix of Desktop and/ or Anywhere, our customers are free to choose and leverage existing IT investments.”

With full support for ESRI’s leading GIS software and the geodatabase asset inventory, Cityworks is the only GIS-based Asset Maintenance Management System available. Cityworks (Server MMS, Desktop, and Anywhere) Version 4.5 is fully compliant with ESRI’s ArcGIS 9.3. cw

5

Project Management

Naperville, IL, Integrates Cityworks and GovQA through Cityworks Service Request API

By David Hansen, Project Manager, Azteca Systems, Inc.

Just a month ago, Naperville, Illinois, rolled out a web interface for their citizenry. Many clients I have spoken with, going back as far as 2001, have been asking about a web interface for Cityworks. Some clients have forged ahead and created one on their own, some had one created for them, and others patiently waited for the official Cityworks Service Request API, released three years ago.

Naperville decided to use an established provider called WebQA, www. webqa.net, which provides web-based solutions for connecting entities with those they serve, together with our Cityworks Service Request API and an additional integration component developed by Azteca’s own “wunderkind,” Randall Sutton.

The product Naperville purchased from WebQA is called GovQA. GovQA has allowed the City to add an area to their website that provides tools which allow their citizens to find support for their needs. They can find answers to questions, such as “What day is my garbage picked up?” or “Where do I send my utility payments?” If they are unable to find the answer to a question they have, they can even submit a question.

These questions are then routed to the appropriate City employee who answers the citizen directly. This has provided huge time savings for the City because citizens can find answers to their own questions or contact the appropriate employee directly; thus, there is a reduced need for people to search for the correct phone number and hope they’ve called the right department for answers or information.

templates and the form walks them through each item of information required to submit the request on to the service personnel who will investigate.

The integration of GovQA requests and Cityworks Service Requests is fairly simple, even if a bit technical. GovQA requests are passed directly to Cityworks by using the Cityworks Service Request API. These requests show up in Cityworks as having been initiated by “Initiator, Web” with the citizen’s address and contact information in the customer account information section. Once the request has been handled, there is a trigger in the database that monitors the request table and reports back to GovQA that the request has been completed so that GovQA knows the status of the request. The risk of junk or spam requests is reduced by the need for citizens to create and use a login for the site.

This login also provides a location for citizens to keep track of the status and outcome of any issues they have reported. They can also register an email address for GovQA to send them status updates regarding their requests.

The web interface has been live at the City of Naperville now for almost six weeks (as of this writing) and is working well. It started with a little over 100 knowledge-base articles and continues to grow. Naperville is the first site to have integrated Cityworks with GovQA, but WebQA has other clients who are interested in doing the same thing. As Mike Masterson, Naperville’s web developer says, “[This] simplifies the process.” cw

Another area allows the citizen to report an issue or “Make a Request.”

In this screen, the citizen selects from a predefined list of service request

Citizen Support Center

6

Service Request

INPRINT — MARCH 2009

Edmond, Oklahoma, and Cityworks Small Government ELA Municipality Joins Specialized Licensing Program for Populations Fewer than 100,000 The City of Edmond, Oklahoma, is one of the latest Cityworks clients to join small governments across the United States in signing up for the Cityworks Enterprise License Agreement (ELA). The program provides organization-wide, GIS-centric asset maintenance management and permitting solutions for smaller agencies within a tiered, affordable pricing schedule.

The Cityworks ELA Program is available to government agencies in the United States with populations of 100,000 or less. Benefits of the program include: • Up to a full suite of Cityworks software and add-on products.

• Product update and technical support.

• Flexible deployments for desktops, web-servers, and mobile devices.

• Unique opportunity to consolidate business processes and IT initiatives within a GIS-centric environment.

The City of Edmond uses Cityworks Desktop and Storeroom extensively in its Field Services and Electric Departments. The City recently implemented the Cityworks module, CCTV Interface for PACP. Building Services, Code Enforcement, and other divisions citywide use Cityworks service requests as their customer response system and for requesting services, such as inspections from Field Services. Although the City has already deployed a considerable amount of Cityworks technology, the ELA provides numerous added benefits including licensing for additional software modules and applications. The ELA allows Edmond the flexibility to deploy software products when and where they are needed, including Cityworks Server.

“The City of Edmond strives for continuous improvement in customer service, and one of the ways we are doing that is through the use of Cityworks technology,” said Sara Cobb, City of Edmond. “The Cityworks ELA enables us to employ a multi-tiered enterprise solution for our maintenance management and customer response system requirements.”

Brian Haslam, President of Azteca Systems, states, “The Cityworks ELA offers substantial benefits to smaller organizations and we are pleased that more and more clients are utilizing it. We’ve introduced this unique and innovative option to help smaller governments save time and money while leveraging their investment in GIS and extending their spatial data in day-to-day business operations. We are excited that Edmond, one of our long-time, valued customers, has taken advantage of this program and we’re confident they will realize the benefits of their decision.”

The Cityworks ELA program provides smaller agencies the leading business process solutions specifically designed for local government within a clear, tiered pricing schedule, and is in alignment with ESRI’s Small Government Enterprise License Agreement (ELA) Program.

Technology in a Cityworks ELA can include up to a full suite of Cityworks products. Cityworks is used by decision makers, management, field staff, and the public in more than 300 sites around the world and is available for desktops, mobile devices, and web deployments. For more information about Cityworks and the new ELA option, visit www.cityworks.com. cw

Client Services

The 411 from the Cityworks Campus

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

Regional T r a i n i n g Many exciting things are going on with Cityworks training. This year we will be offering another training option: Regional Training. We will be coming to your “neighborhood” to offer Cityworks regional training for the same cost we charge for our Remote Interactive Training (RIT) courses. For the reasonable cost of $600.00 per person per day, you can receive training on Cityworks software which also includes the use of a computer and all related training materials.

In-House Training The Cityworks Administration Training course will be held at or nearby Azteca’s company headquarters in the Salt Lake City, Utah, area on these dates:

Below is a list of dates and locations scheduled for upcoming Cityworks Regional Training:

Cityworks Administration Training is designed for the Cityworks Administrator within an organization, giving the “big picture” for implementing Cityworks and covering all related topics to accomplish this goal.

May 5 - 7, 2009 Horry County, SC

August 18 - 20, 2009 City of Frisco, TX

Remote I n te r a c t i v e T r a i n i n g ( R I T ) Are you too busy to take time off work to attend a training course?

Do you have a limited training budget? Register for a web training course to receive in-depth Cityworks training from a qualified instructor in the comfort of your own office over the web in convenient four-hour blocks.

INPRINT — March 2009

June 1 - 5, 2009 October 19 - 23, 2009 December 7 - 11, 2009

Cityworks Campus To check out all of the web training courses, view the schedule, and register for any of these courses, visit the Cityworks Campus by logging in at www.MyCityworks.com. cw

7

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

MyCityworks.com – Your Destination to Self-Help Support

By Greg Walters, Client Services Manager, Azteca Systems, Inc.

We’ve added something new to the Resource Center at www.

MyCityworks.com. “What is it,” you ask? I hope you’re reading this sitting down… you now have the ability to download our latest software, Cityworks 4.5, from the Resource Center – Software Solutions. We’ve also added a download link for Cityworks 4.5 Service Pack 1. If you don’t see the Software Solutions section, then please contact your Cityworks Administrator or your regional support manager. This type of access allows Cityworks administrators to download all of our software via www.MyCityworks.com instead of our FTP site.

log into the software. You can download the silent installer from www.MyCityworks.com\Resource Center\ Software Solutions\CW45 Silent Install.

Please, please, please use our “Cityworks Support Forum” under “Need to Know” to discuss topics dealing with Cityworks Desktop, Anywhere, Designer, Reports, etc. This is a great place for the Cityworks community to start a dialog about any issue or question that may arise.

We are constantly updating our support site. Here are some other new items to look for:

With the release of Cityworks 4.5, we now have a Cityworks silent installer. The silent installer is simply our normal Cityworks install without the Cityworks Configuration settings triggering at the end of the install. This allows our clients and business partners to more easily incorporate a batch file or some other process which allows them to automate the installs throughout the network based on a set event or interval. BUT, the user is still required to run the post-install steps and the “Configure Cityworks” option before being able to successfully

Support Regions

• In the near future, we will be putting some Cityworks vidcasts on MyCityworks.com. “What is a vidcast,” you ask???

(Yes, it’s really a word.) Simply put, a vidcast is a video podcast.

To start with, we plan on creating some vidcasts for “what’s new” in the latest software version and future service packs. We anticipate they will be 10-20 minutes in length. Vidcasts can be downloaded and listened to offline, on a portable media player for example.

• We continue to expand the number of Crystal Reports on the “Reports” section of the Resource Center. By the time you read this, you should see a few new work order labor reports.

• Periodically check in because we are also updating and adding new help videos and knowledge-base articles.

MyCityworks.com is for you, our clients! Let us know if you have any suggestions to help us improve our site. cw

WELCOME NEW CITYWORKS USERS! Burien, WA Champaign Public Works, IL Chapel Hill, NC Greene County Sanitary Engineers, OH Longview, TX Meridian Township, MI Noblesville, IN Orangeburg, SC Port Angeles, WA The Colony, TX

8

INPRINT — MARCH 2009

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

Te c h n o l o g y Su p p o r t M a n a ger

Technology Support Update: Cityworks/ESRI Versions

Bryan Chadwick

By Bryan Chadwick, Technology Support Manager of Azteca Systems, Inc.

bchadwick@cityworks.com I would like to take this opportunity to introduce myself as the new Technology Support Manager here at Azteca. My name is Bryan Chadwick and I’ve worked in the Client Services Group for about two and half years.

I’m taking over the partner support from Kyle Boyd who is replacing me in the Western Region. My duties now include technical GIS development/issues, bugs/enhancement testing, partner technical support, and roaming technical support for difficult issues requiring immediate resolution. If you’ve ever worked with our Enterprise Services Group, especially on something dealing with Cityworks Server, then there is a pretty good chance I’ve worked with your data “behind the scenes” while assisting our Project Managers in resolving GIS and database issues.

Feel free to contact me with any questions you may have regarding technical issues that directly affect your organization. If the issues deal with a specific client, I will get you in touch with the Client Support Manager that oversees the client’s region. You may wish to contact our Business Partner Manager, Becky Tamashasky, for partner program needs; Executive Director of Sales and Marketing, Tom Palizzi, for any marketing needs; and Educational Services Manager, John Jarnagin, for any training needs.

These Azteca folks have a wealth of knowledge and are wonderful resources for assistance in a myriad of ways.

A question that both clients and business partners frequently ask is, “What versions of Cityworks software support what versions of ESRI software?” The answer here is fairly simple — the Cityworks 4.4 software suite ONLY supports the ArcGIS 9.2 software suite, whereas the Cityworks 4.5 software suite ONLY supports the ArcGIS 9.3 software suite (up to ESRI service pack 1 at the moment). Further, Cityworks Server ONLY supports the ArcGIS 9.3 software suite (this EXCLUDES service pack 1).

The standard policy from Azteca, unless otherwise noted, is that every version release of the Cityworks software (e.g., Cityworks 4.4, Cityworks 4.5, etc.) will ONLY support one version release of the ESRI software (e.g., ArcGIS 9.2, ArcGIS 9.3, etc.). Predictably, there are a few exceptions — for example, the next offering from ESRI will be ArcGIS 9.3.1, so named because the modifications made are too significant for just a service pack 2. Once we’ve had time to certify this latest release of the ESRI software after its upcoming commercial release, we highly anticipate that Cityworks 4.5 Desktop/Anywhere will fully support both ArcGIS 9.3 and ArcGIS 9.3.1. In addition, we’re absolutely looking towards ArcGIS 9.3.1 to be compatible with Cityworks Server — again, just like the commercial release of ArcGIS 9.3.

Please continue to consult the home page of www.MyCityworks.com for the latest news regarding Cityworks releases and their compatibility with the ESRI software suite. If for some reason you’ve not requested a www.MyCityworks.com access account, please contact Becky Tamashasky or myself — bchadwick@cityworks.com — and we will be glad to promptly set you up with one. The site is constantly being updated with information that is extremely valuable to anyone who is involved with Cityworks.

As always, we truly appreciate all of the contributions made to the development of Cityworks through the efforts of our outstanding partners. cw

Now, I wish to recognize our new and returning Business Partners that have come online during the last couple of months — PACE Engineers, Tetra Tech, CIPPlanner, Peninsular, and CartoPac. If I left anyone out, you have my sincerest apologies. cw

Cityworks Administration Training — February 2009 Back Row (left to right) Keri Wood , City of Logan, UT; Mike Walls, Westin Engineering; Christine Christensen, City of Logan, UT Middle Row (left to right) Brooke Christiansen, City of Logan, UT; Fran Curtis, Weston Solutions; Jeff Given, City of College Station, TX Front Row (left to right) Raj Patil, Project Manager, Azteca Systems Inc.; Ryan Harris, Client Support Trainer/Document Analyst, Azteca Systems, Inc.; Ken Peck, City of St. Cloud, FL; Eric Brady, Bergmann Associates; John Jarnagin, Educational Services Manager, Azteca Systems, Inc.

INPRINT — March 2009

9

Partner News Bu s i n e s s Pa r tn e r Manager Becky Tamashasky 574-231-8029 btamashasky@cityworks.com Hello, everyone! Hope you had a great start to 2009 and here’s hoping that some warm weather is around the corner for us all.

There are a few updates related to Azteca’s Business Partners. Bryan Chadwick is now the Customer Service Representative (technical support) for Business Partners.

Bryan is a great resource and I know he’s already been a tremendous help to several partners. We have also remodeled our Business Partner Program which mainly affects our Authorized and Associate Partners. All current partners should have received the updated Business Partner Program Overview along with notification of the changes, but if not please let me know. And as always, be sure to continually check the Business Partner section of MyCityworks.com for updates to marketing materials and partner resources.

As you read this, I will be on maternity leave until June 1st. During this time, Tom Palizzi will be available to assist with any questions or concerns related to the Business Partner Program or International activities. I’ll see you this summer in San Diego! cw

B R E A K I NG NEWS! Alex Glenn Tamashasky Born February 20, 2009

Fulton County Public Works Keeps Doing What It Does Best with Cityworks

By Chris Browning, Assistant Director, Dept of Public Works, Fulton County; Ryan Fernandes, Director, Dept of IT, Fulton County; Steve Kerr, VELOCITIE Project Manager and Christine Seidl, Marketing Consultant To water and sewer maintenance crews, warehouse users, administration, and support staff, Cityworks means they keep doing what they are doing – only doing it better. That’s the goal – to give a higher level of service to the customer.

Fulton County’s Department of Public Works was committed to choosing the right tool for its move from an antiquated paperwork management process to a fully automated/integrated CMMS. The CMMS users participated in a detailed business process analysis to help configure the system and to improve their response to work requests and service delivery.

Key to adopting the new system, the County’s approach involved users in evaluating all business processes. They reviewed many CMMS products looking for a solution that would fit their target business processes rather then having to alter their processes to fit a product. After their extensive review and selection process, they chose Cityworks and hired consultants from VELOCITIE Integration who had extensive experience and success with CMMS implementation and integration. They took the time to clean up inefficiencies, reduncancies, and tie processes together where needed. Being involved in the configuration process meant users were willing to work with the new system. The CMMS users understood where they fit in the process, standardized its use across business areas, and saw their impact in making the system work. Within a few months of its use and due diligence, the users could already see the benefit of their hard work. (See Figure 1.)

The new system has empowered the 30+ users with knowledge! It contains information and has the tools that allow field workers to access that information. Access to customer history, maps, and resource information gives field workers the tools they need to assess and mitigate problems in a timely and cost-effective manner. Also, being able to access relative data and not rely on senior workers for information gives them motivation to enter data and keep it clean and accurate.

Chris Browning, Assistant Director, Department of Public Works, commented, “Cityworks allows us to manage our business effectively and efficiently without changing our processes to fit the software. We will have a fully integrated system specifically developed for the management of utilities that is easily configured to match our way of doing business.”

Fulton County’s Public Works Department selected Cityworks as part of an enterprise solution that features integration between Azteca Systems’ Cityworks CMMS, Advanced Utility Systems’ (AUS) CIS Infinity®, and Tele-Works Interactive Voice Recognition (IVR) software. CIS Infinity will provide automation of repetitive tasks and flexibility to the Departments of Finance, Public Works, and Information Technology. The Tele-Works IVR solution will help the County streamline customer communications.

Figure 1. Fulton County Public Works water and sewer staff utilizes Cityworks Storeroom to manage their inventory of materials.

Cityworks, being GIS-centric, is very congruent with the IT strategic plan to enhance the GIS use for the County. The Cityworks approach builds on the Department of Public Works’ existing ESRI ArcSDE infrastructure geodatabase asset data and is key to achieving the County’s goals of delivering a higher level of service through improved work order and asset management. The new CMMS is fully integrated, shares data in real-time from initiating work and connecting assets with spatial data, to displaying the total cost of ownership with projects and overall improving data sets, efficiency, and effectiveness.

Work history and historical data at a location is critical to improving the work processes and Cityworks has given the Department a system where that data is used all the way from customer setup through service activities, especially for troubleshooting and afterhours calls. Cityworks allows CMMS users to perform reactive

10

INPRINT — MARCH 2009

P a r t n e r N e w s ( c o n t .) and preventative asset maintenance. The integration with Cityworks Storeroom further enhances the repair and replacement of materials and the preservation of assets in problem areas. (See Figure 2.)

Oracle meter tables, meters are accessible as objects in the GIS. Work orders are created on meters and updates to meter information (e.g., readings, meter numbers, and service status) are transferred from the work order back to the CIS, which updates the source meter tables.

(See Figure 4.) This level of integration greatly streamlines the meter installation and replacement work order processes.

Figure 4. Cityworks users can view CIS meter information from within the Cityworks Anywhere application. Information is read directly from the CIS database, which holds the master meter information data.

Figure 2. Fulton County inventory staff use Cityworks Storeroom to manage material quantities in their warehouse as well as on their service vehicles.

Chosen as a subcontractor to AUS, VELOCITIE developed an interface to transfer customer account and work order information between CIS-Infinity and Cityworks. The Cityworks side of this interface is implemented using SQL Server Integration Services and makes use of stored procedures and triggers at the database level, resulting in a seamless interface for users. The interface allows CIS-Infinity service orders to initiate work orders in Cityworks. Once closed, the work order’s status and other relevant information are transferred back to CIS-Infinity. (Shown in Figure 3.)

Another key aspect of the integration with CIS-Infinity is the way in which water meters are managed. CIS-Infinity is the owner of all meter information. By creating views from the MS SQL geodatabase to the

Figure 3. Water distribution view of open work orders via the Cityworks Anywhere application.

INPRINT — March 2009

Ryan Fernandes, Director, Department of IT, stated, “VELOCITIE did a ‘stellar’ job! Given VELOCITIE’s extended care to make sure this implementation was successful, we are considering new initiatives for CMMS, such as in the Department of Transportation for managing streets, signs, and pavement maintenance activities.”

Fulton County water and sewer services are managed by the Department of Public Works, the Water Services Division, and the Department of Finance, with support from the Department of Information Technology (IT). (See Figure 5.) The Water Services Division maintains the collection and distribution system pipe network that contains approximately 2000 miles of distribution and 2000 miles of collection system pipe. The Water and Sewer Division is responsible for billing and collecting payments from water and sewer customers. cw

Figure 5. Fulton County Department of Public Works Water Services has three operations offices: North Water Distribution, North Sewer Collection, and South Sewer Collection.

11

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

Business Partners Implementation Partners PLATINUM • Woolpert

GOLD

SILVER

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

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

BRONZE • • • • • • • • • • • • • • • • • •

12

Anderson, Eckstein & Westrick, Inc. Bergmann Associates Bowne Management Systems, Inc. BP Barber & Associates Burk-Kleinpeter, Inc. Burns & McDonnell CH2M Hill, Inc. Chester Engineers Civic Engineering and Information Technologies, Inc. Civil Solutions Clark-Nexsen Collier Engineering EMH&T geographIT IT Nexus Jones & Demille Engineering KCI Technologies Malcolm Pirnie, Inc.

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

Michael Baker Jr., Inc. Midland GIS North Arrow Technologies NTB Associates OHM, Inc. PACE Engineers, Inc. PSOMAS Quartic Solutions Razavi Application Development Schneider Corporation Stantec Consulting Strand Associates, Inc. Tetra Tech Vanasse Hangen Brustlin, Inc. (VHB) VESTRA Resources, Inc. Wade Trim Associates Westin Engineering Weston Solutions

International Distribution Partners • • • • • • • •

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

Strategic Alliance Partners • • • • • • • • • • • • •

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

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

Marshall GIS MWH Soft Onbase (Hyland Software) Orion Technology Inc. Peninsular Technologies, LLC Pipelogix RIVA Online Route Smart Spatial Wave TC Technologies Televent Miner & Miner TRANSMAP WinCan America

INPRINT — MARCH 2009

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

City of Oakland Begins Rollout of Cityworks Server

By John McCabe, Project Manager, City of Oakland, CA and Brian Hoefer, Project Manager, VESTRA Resources, Inc., Redding, CA

The City of Oakland Public Works Agency and Community & Economic Development Agency are currently training users as part of the Phase One rollout of a new Work Management System (WMS) based upon Cityworks Server, Desktop, and Anywhere in February of 2009. This will be a major installation of Cityworks Server, which is expected to be deployed to a minimum of 110 work crews equipped with fieldbased laptops at the conclusion of Phase Two. The City is currently using an aging call system along with paper-based log books to track work activities, so the transition to a state-of-the-art system, while challenging, is expected to bring major benefits to the City.

The City of Oakland, California, is located in the geographic center of the San Francisco Bay Area. It is the largest and most established of the East Bay cities, with a population of over 400,000.

About the P u b l i c W o r ks A g e n c y The Public Works Agency (PWA) provides for the management and maintenance of the City’s infrastructure, including streets, sidewalks, and pathways; parks; creeks; sewers and storm drains; buildings and structures; vehicles and equipment; and streetlights and traffic signals.

In addition, the PWA is responsible for related activities such as support of community volunteers for beautification and cleanup projects, residential garbage and recycling, graffiti abatement, and facilitating environmental compliance. PWA currently employs over 650 full-timeequivalent staff.

Existing A s s e t M a n a g e m e n t S y s te m Implementing a new work management system has been high on the wish list for the Public Works Agency for many years. The City is

currently using an aging call (request) system to coordinate its reactive maintenance activities, which is ill-suited to preventative maintenance work and has no mechanism for recording costs. All work activities in the field are recorded in paper-based log books. Monthly performance metrics for each department are tabulated manually from the log books (see Figure 1), which can sometimes take up to a week to calculate.

RFP and Selection of Cityworks So, when the City identified budget to implement a new work management system, the procurement team strove to make the most of the opportunity and define a major leap forward in technology. In addition to an extensive list of functional and system requirements, the RFP keyed in on a number of departmental and citywide objectives that the new system needed to address, which became the focal point throughout the selection process.

The City had developed a mature ESRI-based GIS and had recently completed a citywide sidewalk survey. GIS was seen as a key enabling technology throughout and, during the selection process, it became clearly evident that Cityworks was the best solution for the City’s needs. After several rounds of short-list presentations, the final decision was unanimous to select VESTRA Resources, Inc., along with team members, Azteca Systems and Oakland Computer Company, to implement Cityworks for an agency-wide Work Management System.

After obtaining City Council approval and several months of contract negotiations, the parties agreed to a multi-year contract with a total budget of $1.2 million. The project was kicked off on March 27th, 2008 with over 150 employees in attendance.

Cityworks Configuration and System Testing After several weeks of configuration review workshops with work crew leaders, supervisors, and department managers, the development team started with the configuration of the new Cityworks system, producing periodic reports of the configuration as the system development progressed.

At several key points during the development, preliminary training/ testing sessions were conducted with the City development team and departmental work supervisors to obtain feedback on the system configuration. At present, there are over 500 employees within 68 different domain groups, approximately 280 service request templates, and over 300 work order templates with more than 340 unique tasks configured in the new Cityworks system.

Figure 1

INPRINT — March 2009

Specifically for Cityworks Server, there are 16 different map services (one for each department) and dozens of custom saved searches for work crews to customize their Inbox.

13

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

Phase Two Rollout Activities planned for Phase Two of the rollout: • Install 64+ additional laptop mounts and test laptops.

• Install 125 AVL units and deploy GIS interface (with the first units).

• Deploy performance dashboard website internally and provide training.

• Provide 85+ work crew leaders with Cityworks Server training.

• Provide additional on-site rollout support.

Server

With over 500 employees in the system, it was anticipated that searching for employees to enter labor on work orders was going to be a challenge.

Therefore, the development team took full advantage of the ability within Cityworks to create predefined labor, materials, and equipment specific to each work order template. Based upon preliminary testing, as well as initial user training for Phase I, this will contribute significantly to the ease with which work crews will be able to record their labor, equipment, and material costs.

In addition to the typical Cityworks configuration tasks, the development team developed and successfully tested an ArcGIS Server-based Citizen Service Request Intake website, an internal web-based dashboard that calculates performance measures directly from the Cityworks database, and a GIS-based interface to the Automatic Vehicle Location (AVL) system that will be deployed in Phase Two.

The City of Oakland is anticipating a variety of benefits from the new work management system. For City staff, there are new ways of conducting their work more efficiently and with improved communication. The Public Works Agency overall will gain a much better insight into costs, including maintenance histories on individual assets. City staff will have ready access to this data for planning and improved customer service.

And the public, with improved access to this data, will be able to learn more about their own community. cw

Contact: John McCabe – jmccabe@oaklandnet.com Brian Hoefer – bhoefer@vestra.com

Cityworks Server Training

Due to the logistics of training over 200 users and installing truck mounts for at least 110 Panasonic Toughbook CF-19 laptops, it was decided during contract negotiations that the rollout would need to happen in two phases.

Phase On e R o l l o u t The Phase One rollout consists of the following activities: • Provide 60 call takers and work supervisors with Cityworks

Anywhere and Desktop training (complete).

• Install 46 laptop truck mounts, image, and test laptops

(complete).

• Provide 55+ work crew leaders and alternates with Cityworks

Server training (in progress).

• Perform system cut-over from existing call system with on-site

rollout support (scheduled for mid-February).

• When ready, deploy Citizen Service Request Intake website.

Departments that are part of the Phase Two rollout will migrate to using Cityworks service requests as part of Phase One.

14

INPRINT — MARCH 2009

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

Cityworks Server implementation: What is your strategy?

Let the trusted experts at VESTRA help you make your next move.

VESTRA Resources Inc. provides:

System Design Geodatabase Design & Development Software Installation, Implementation & Rollout Support Cityworks Desktop & Server Configuration Cityworks Server User Training Custom Dashboard Development Public Service Request Website Development Automatic Vehicle Locator Integration

www.vestra.com

530.223.2585

5300 Aviation Drive, Redding, California 96002

Visit www.mycityworks/campus.com for more information on training courses, class schedules, and to register.

INPRINT — March 2009

15

Announcing.....

Cityworks Server MMS Rollout/User

Cityworks Server MMS Rollout / User Group Seminar

Group Seminar Series Cityworks Server MMS represents the latest, state-of-the-art edition of Azteca’s leading Cityworks product line. These FREE seminars will be held in conjunction with regional user gatherings at various locations in the United States. Learn more about Cityworks Server MMS, see it presented in an in-depth demonstration, find out about implementation options, and hear case studies on how it has been deployed. Azteca staff will be on hand at daylong, mini-conference style meetings hosted at user locations. The seminars are hosted by Azteca Systems in conjunction with regional user groups and open to invited guests.

Highlights Inc l u d e : • Technology Overview • Cityworks Server MMS Demonstration • Cityworks Implementation Discussion • What’s New in 4.5 • User Case Studies • User Enhancement Feedback Breakfast and Lunch Served

Time: 8:00 AM - 4:30 PM (approximate ending time) Cost: FREE! Zero! Zip! Nada! Nothing!

Register: Online at

www.MyCi tyworks.com or contact your Cityworks Account Manager

DATE S & L O C A T I O NS : April 16

D a l la s / Fo r t Worth, TX

A p r i l 2 2

R ic h m o n d , VA

A p r i l 3 0

D u b l in , O H

May 5

S t . C lo u d , F L

May 1 2

W i l m in g t o n , DE

May 2 1

L a ke Fo re s t , IL

May 2 7

S a c ra m e n t o, CA

Ju n e 2

At la n t a , G A

Ju n e 1 1

C o o n Ra p id s , MN

Ju n e 1 8

Wa t e r fo rd Township, MI

Ju n e 2 3

C o n c o rd , N C

“In these challenging economic times, we recognize our clients’ budgets are strained. In lieu of our annual 2009 User Conference, we are taking the ‘show-on-the-road’, bringing our conference to our users.

Our users will enjoy a full-day briefing on our new products and corporate strategy, and exchange user news amidst a more intimate environment, yet similar to our annual conference. As well, we will have technical staff on-site to address questions and to provide local support.”

Brian Haslam, President, Azteca Systems, Inc.

Thank you to our sponsors!

OneGIS THE POWER OF

Premier Sponsor

ONE PLATFORM, ONE SOLUTION, ONE COMPANY...

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

For a moment, consider how much has changed and in just a few short months. Can any of us say we have seen a more interesting year in retrospect? From a fuel-pricing roller coaster to an intensely heated political debate, and from a colossal market crash to history in the White House – it’s surprising how well we all fared. I suspect 2009 will certainly grab our attention as well.

With no predictions here, I will hope for the best.

2008 proved to be another great year for Cityworks and Azteca Systems and we thank you all for that. More than 45 new customers joined the Cityworks community in 2008 and we saw significant expansion in several sites.

In addition, more than 20 sites are now working on Cityworks Server MMS implementations.

If rumor holds, we will likely see an increase in funding for public works, utilities, and infrastructure. Not since the Great Depression have we considered such an endeavor. I believe we all share concern for the health of our national infrastructure – something we not only depend on as citizens but have taken charge to care for and maintain by virtue of our professional responsibilities. While uncertainty and economic stress will no doubt remain, we realize you still depend on technology to do more with fewer resources. Cityworks was designed and built with that in mind. The new Cityworks Server MMS further accentuates that in the first web-based, GIS-centric asset and maintenance management system. Be sure to watch for a Cityworks Server MMS rollout event coming to a city near you this spring. cw

National Sales Manager — Southern Region

Western Region

Brent Wilson

970-471-5666

214-507-0579 bwilson@cityworks.com

wlang@cityworks.com

It’s like Christmas all the time around here! You’re probably wondering what I’m talking about? I guess I’m just a kid at heart and like any kid, Christmas is my favorite time of year. I’m excited about our new software – Cityworks Server MMS.

Greetings to everyone in the newly created Western Region! “How do I know if I am in the Western region?” you ask. Well, if you live in a state that has mountains and is west of the Mississippi, there’s a good chance you’re in the Western Region.

After working in the Public Works and Utilities market for over 10 years, I’ve watched the steady progression of Cityworks and how it has changed people and organizations. I see those that previously thought themselves to be technologically averse now using Cityworks like a “power user” and organizations asking for more.

I am sure I will miss visiting everyone in Minnesota, Nebraska, Missouri, Kansas, South Dakota, and Iowa. From my travels there, I have learned that you can find great Indian food in Iowa; Minnesotans are actually very nice (I am from Wisconsin); and Omaha has a great music scene! Rock on Sun Ambulance!

Good luck and continued success to all of you.

So how did we respond? Welcome Cityworks MMS – not only the first GIS-centric MMS application, but with new enhancements that makes this one a truly great addition to our product suite. From improved project management to work order creation rules, Cityworks Server MMS also features new contract management and an Inbox view. It’s everything you’ve come to expect from Azteca and more.

And for those of you in the Pacific states – my name is Billy Lang and I am your new account manager. I look forward to meeting and visiting with all of you soon!

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

William Lang

So as you can see, my childlike enthusiasm is warranted because Christmas has arrived, wrapped and ready! Come see it at a rollout seminar near you. cw

I would like to welcome new clients in Coal Creek Utility District, WA; Port Angeles, WA; and Burien, WA. Welcome to the Cityworks community.

I expect 2009 to be an exciting year! Currently we are planning local training sessions, and Cityworks Server MMS rollout seminars. Stay tuned for more information on these events coming to a city near you!

Thanks again to everyone for a great 2008 and here’s to a sublime 2009! cw

kryser@cityworks.com 18

INPRINT — MARCH 2009

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

Northern Region

Northeast Region

Southeast Region

Josh Stroessner

Phil Mogavero

Dave Bramwell

920-254-1112

716-667-6987

919-339-8642

jstroessner@cityworks.com

pmogavero@cityworks.com

dbramwell@cityworks.com

Cityworks Server MMS is here! Today, more than ever, the importance of streamlining your workflow and increasing efficiency and effectiveness is crucial. In these tough economic times, we all have to tighten budgets and make cutbacks.

Utilizing tools that can help soften the impact of such financial shortfalls can help keep track of operating expenses while keeping infrastructure at acceptable levels. This is evident throughout the Cityworks community.

It is great to see so many different ways Cityworks users are using the system to help keep things running efficiently.

It’s been a cold year, even here in the balmy Southeast. As I look at 2009, I believe the general consensus remains to be more efficient in caring for our infrastructure. Cityworks plays a significant role combining GIS and maintenance management while leveraging your investment in spatial data. In the end, it means more efficient operations and lower costs for you. I invite you to take a close look at the advantages of our cross-compatible approach, blending Cityworks Server MMS with your current Desktop/Anywhere environment.

This is truly the best way to enable your entire organization. Of course, I’m happy to show you how it all comes together.

Happy New Year! I hope you had an excellent holiday season. The new year brings bright changes and the creation of a new sales territory, the Northern Region. I am very excited to meet all of you in Minnesota, Iowa, Nebraska, South Dakota, and North Dakota who were previously working with Billy Lang. As you can see, my colleague and fellow Wisconsinite is moving further and further West.

Let me welcome the new clients to our user community – Champaign, IL; Noblesville, IN; and Meridian Township, MI. I would also like to recognize Rapid City, SD, as well as Butler, IN, as they have recently upgraded to ELAs. Welcome aboard and thank you for your continued confidence.

Finally, I am thrilled to say that Cityworks Server MMS has been commercially released and it is very impressive. We are planning some Cityworks Server MMS rollout seminars for a city near you. I hope to see you all there!

Meantime, please let me know how I can assist you. cw

On behalf of all my colleagues at Azteca, we welcome Easton Suburban Water Authority as the Northeastern Region’s newest member.

I look forward to a long and successful relationship.

To those interested in forming a Cityworks User Group, please feel free to contact me.

I’m happy to help organize a meeting. As we’ve seen elsewhere, user groups are a great way to network with other Cityworks users in your area and exchange ideas. cw

As the still relatively new Southeast account manager, I’ve been busy making my way to see you – making the rounds to the more than 60 Cityworks sites in the region. I personally wish to thank you for your time and sharing your success stories. This is a demonstration of not only the software, but a cohesive and confident user community. Along with my goal to “fish more” in 2009, I aim to ensure your continued success with Cityworks! cw

Four New Employees Join Azteca!

Raj Patil joins Azteca as part of the Project Management Services Group with experience in government, retail, finance, education, and technology.

Prior to coming to Azteca, Raj worked at Infor, where he managed the delivery of business services, projects, and implementation teams for the Hansen Public Sector organization with a focus on local and municipal government solutions. He has also worked at ESRI, IBM Global Services and Veritas (Symantec), and KPMG Jamaica. During his 16-year career as an IT professional, Raj has managed and consulted on diverse engagements and business operations throughout the U.S., Caribbean, and support centers across India. He has a BS in computer science and an MBA (International Business) from Wayne State University in Detroit, Michigan. Raj is married to Vinutha

INPRINT — March 2009

and together, with their 4-year old son, Vivek, live near Sacramento in Northern California.

He likes sports, music, and traveling. cw

Will Schmidt also recently joined Azteca Systems in the Project Management Department. He will graduate from BYU in GIS this April (09), and has had several GIS jobs including working as an application designer for the BYU Special Collections Department as well as a contractor for the Nature Conservancy.

He has also worked at BYU in IT as a server administrator, as well as for Les Schwab Tires in their Technical Services division. He married Alina about a year ago. They are expecting their first child (a baby girl) in July. cw

David Butt joins Azteca Systems as a software developer. David is currently attending Salt Lake Community College and plans to transfer to the University of Utah to graduate in Computer Science.

David has also worked at MSN, Customer Support and Bill Good Marketing, QA/RD. He and his wife, Sara, reside in Sandy, Utah, with their 16-month-old son, Tyler. cw Brent Bagley has joined the IT department at Azteca Systems.

He is currently attending the University of Utah studying biology.

His plans include becoming a professor and doing research.

Brent served a two-year LDS mission to San Fernando, California, prior to working at Azteca. cw

19

Get to Know.....

Cityworks Software Developers Meet our developers — the people that bring you Cityworks. Our goal is to have happy customers. This starts with providing innovative and reliable software. Our developers recognize that if a user cannot use the software to their fullest expectation, then it isn’t quite “great” enough. As well, we depend on the feedback we receive from you to help craft enhancements and new products to best meet your needs, making you part of the team. So, meet the folks behind Cityworks – still the only GIS-centric maintenance management solution.

Carl Hor to n , E x e c u t i v e D i re c t o r S o f t w a r e Develop m e n t • Born in Wyoming.

• Has lived in California, Wyoming, Idaho, Tennessee, Florida, South Carolina, Uruguay, and Utah.

• Graduated from BYU and University of Utah with a PhD. • Enjoys triathlons, cycling, running.

• Interesting fact: He has participated in over 75 triathlons.

Sheldon Bagley • • • •

Born in Utah.

Has lived in Utah and Pennsylvania.

Graduated from Westminster College, SLC, UT. Enjoys snowboarding, wakeboarding, motorcycles, and various other sports, but most of all being with his family and being a grandpa!

• Interesting tidbit: He is an Evil-Knievel wannabe. His favorite part of sports is the jumps and getting “air.”

Jiajun Liu • Born in Hubei Province, China.

• Has lived in Hubei, Beiing, and Utah • Attended Wuhan University, China, and the University of Utah.

• Enjoys basketball, and singing (We were all impressed on karaoke night at our 2007 User Conference.)

• Interesting fact: Became a citizen of the United States in 2003. Has been working for Brian Haslam since 1994.

Kylir Ho r to n • Born in Utah.

• Has lived in Utah, Florida, South Carolina, and Guanajuato, San Luis Potosi, and Michoacán, Mexico.

• Attending Brigham Young University, Utah.

• Enjoys art, running, biking, gardening, computers, photography, and outdoors, although he enjoys doing just about anything.

• Interesting tidbit: He’s been peed on by a lion. (We’ll have to ask him about that story.) He’s also eaten just about every part of a cow (brain, eyeball, stomach, tongue, etc.).

David Butt • Born in Utah.

• Has lived in Utah and Louisiana.

• Attending Salt Lake Community College and then transferring to the University of Utah.

• Enjoys scuba diving, rock climbing, computers - all kinds, photography, spending time with his family. He likes to try anything once.

• Interesting fact: Likes to learn about everything by picking up books about topics of interest and studying them. For example, he learned how to program in 6 weeks by picking up a couple books and within a year he was programming for his own small business.

20

INPRINT — MARCH 2009

G e t t o K n o w . . . (cont.)

Randall Sutton

Jeff Gerke

• Born in Salt Lake City, Utah.

• Has lived in Utah and Argentina.

• Graduating in April from Utah Valley University in (surprise) Computer Science!

• Enjoys computer science and economics (as a hobby?).

• Interesting fact: When he was in high school, he used to buy about two $50 computer books a month, so he could learn more.

• Born in Scottsbluff, Nebraska. (He hates that he was born there.)

• Has lived in Wyoming, California, Washington, Japan, Nebraska, and, for the last 17 years, Utah.

• Graduated from the University of Utah.

• Enjoys trail running, trail running, and more trail running — mountainous single track is where it’s at. Also gardening, experimenting with vegan and raw foods, making green smoothies, camping with the family, and family trips.

• Interesting tidbit: Back in his younger days, he used to compete in bronco riding at high school rodeos. When he lived in California, he spent all of his free time surfing.

James O l i p h a n t • • • •

Born in Utah.

Has lived in Missouri, California, and Utah.

Graduated from Brigham Young University, Provo, Utah.

Hobbies: His four children (3 boys, 1 girl), dancing with his wife (they met in a dance class in college), working with wood (he recently built his own Crokinole board), reading, and listening to books on tape while commuting.

• Interesting tidbit: He does not have a cell phone, cable or satellite TV, or high-speed internet at home. They have ten hours of free dial-up internet each month and have exceeded their time limit only a couple times. It’s the cobbler’s-kids-have-no-shoes syndrome.

• April will mark 5 years working at Azteca Systems, Inc.

Crokinole board

INPRINT — March 2009

Garth Arrington • • • • •

Born in Utah.

Has lived in Arizona and Utah.

Attended Salt Lake Community College, SLC, Utah.

Enjoys writing and gardening.

Interesting tidbit: He is an expert salsa maker and the office enjoys the fruits of his labors every summer!

• One more item of interest, in 1987 when Azteca first started, we had a contract with the government, which put us cash poor until we were paid. So Garth agreed to be paid only $25.00/week for the first couple of months. He claims that he lived just fine and still had money left over.

21

Grand Rapids, MN (cont. from page 1) Cri tical I s s u e In 2006, the City of Grand Rapids was mandated by the Minnesota MS4 Storm Water Program to begin reporting year-end maintenance and inspections of the stormwater system as part of NPDES regulations enforced by the Minnesota Pollution Control Agency (MPCA). This forced the Engineering and Public Works Departments to look for an asset management system that would track work orders linked to our GIS. An example of our thought process in choosing a system was if we had to report the maintenance and inspection of 50% of our outfalls (the City has 47 outfalls), which software could easily produce a report of the time and date, who worked on it, how long it took, how much it cost, whether it is currently being working on, and if we can show it graphically through our GIS. After researching, meeting, and having demonstrations of software capability, staff at the City of Grand Rapids chose Azteca Systems and the Cityworks program to provide us with an asset management software solution.

Vision After seeing the demonstration of Cityworks and visiting a few other cities actively using the software, we knew Cityworks would easily be able to solve our stormwater reporting issue, but the great thing about the software was that we could already see where Cityworks would benefit other aspects of the Public Works Department. Jeff Davies, City of Grand Rapids Public Works Director, started to think that he could use Cityworks to track all Public Works’ work orders and use it for cost analysis in his budgeting process. Also, he brainstormed that if we used it for all work orders, why not use it for staff time sheets, asset and invoice reporting, edits to assets through the GIS in the field, and AVL with all Public Works vehicles.

Tom Pagel, City of Grand Rapids Engineer, made the comment that all these ideas weren’t just a pipe dream which would take years to implement because the City of Grand Rapids was staffed with qualified employees who could execute the program. Also, we were also small enough that these ideas could be completed quickly to benefit the City’s Public Works Department workflow immediately.

Solution After purchasing Cityworks, the City of Grand Rapids decided to implement the software and solutions ourselves. The City sent our GIS Technician to the Cityworks User Conference in Park City, Utah, in May of 2006 to attend the pre-conference implementation training and conference courses. Upon returning, the stormwater personal

Jeff and Cindy, Grand Rapids, MN

22

Crew Street Repair

geodatabase was reformatted for use with Cityworks by using some tools provided by Azteca Systems, which made the transition relatively simple. After configuring the geodatabase, a meeting was held with the Engineering Department and Public Works Department to discuss what stormwater goals needed to be tracked for NPDES reporting and how the work orders were to be created in order to meet these goals.

Besides tracking the maintenance and inspections of outfalls, we track sweeping of all our streets, maintenance of all storm structures, and the repair, flushing, and installation of stormwater assets, just to name a few.

After the initial meeting, we gave ourselves a goal of three months to kickoff the start of using Cityworks to track our stormwater reporting.

The initial kickoff date was set for the day after Labor Day. We began setting up Cityworks, using Designer to add all the employee data and relationships to work order tasks. Then we created all the work order templates and established their relationship to different GIS assets.

Everything was completed in time for our initial kickoff of the first phase of Cityworks implementation. After the first month, everything seemed to be running smoothly so we began the second phase, which was creating work orders for the snowplowing season.

Results In the spring of 2007, almost one year after our initial implementation of Cityworks, the Public Works Department realized how valuable it was to be able to view all our work orders. It had become an efficient tool to ensure work tasks were being completed in a timely manner in the upkeep of our City’s stormwater system. This realization became evident when it came time to report to the MPCA. All the data from fall of 2006 was easily accessible and took very little time to extract from Cityworks. However, while doing the reporting, it was decided that all the work orders needed to be revamped in order to meet the needs of Public Works field crew and administration. Another meeting between the Engineering and Public Works Department was organized and a new directive in how Cityworks could be utilized for the stormwater system was devised.

INPRINT — MARCH 2009

G r a n d R a p i d s , M N ( c o n t .)

After this meeting, a lot of hands-on meetings with our field crew and administration were conducted to better understand how the workflow process needed to coincide with new and improved work orders to meet all the needs of our Public Works Department. After several meetings with administration and our field crew, we determined that paper work orders be printed and filled out for each work order. We created a complete stormwater system map showing the Facility IDs for every stormwater asset to allow field crews to identify which assets were being worked on so they could be accurately associated to work orders within Cityworks. This, in turn, would help administration create accurate reports to provide to our City Council and analyze costs.

This new process was used for our stormwater system throughout 2007.

We also decided to redo our snowplowing work orders in the same way for the 2007-2008 snowplow season. In the spring of 2008, when it was time again to provide reports to the MPCA for our stormwater system, the same outcome was realized. Even though it was easy to extract the data for what we needed, there seemed to be something missing. Yet again, we found ourselves meeting that spring to discuss how we could more effectively use the software. Because of its many capabilities, it seemed as though it was being underutilized. The result of this meeting was that too much paperwork was being done by the field crew and critical information was being left out of Cityworks, which in turn made the administration staff have to continue the tedious review of handwritten time sheets to produce accurate reports.

As a result of our analysis of the use of Cityworks, we decided to implement Cityworks as the only way to account for all of Public Works time reporting and thus eliminate any missing information from the work orders. This was a major decision for the Public Works Department; it meant that the whole department would have to adjust to an entirely new concept of time reporting and handling our work orders. At this point, we decided if we used Cityworks for all work orders and time reporting, we could design an automated time report that would be submitted to payroll for all Public Works employees. Using the SQL data from the Cityworks database, we migrated the data to Microsoft Access and used that as the front-end application to show all the time sheet and invoice reports that we could submit to payroll. Even though the majority of work orders would be unattached to GIS layers, we decided to proceed with this concept.

A member of each type of Cityworks user, Public Works administration and field crew, was designated to assist the Engineering GIS Technician

Crew Clean

design and set up all the work orders to ensure the needs of both user types were met. Each of the two members of our Public Works Department was assigned roles to make certain all the work orders were dispersed correctly and that time was entered into Cityworks on a daily basis. Once the design of all the work orders was complete, we needed a way to incorporate all the different billing rates into the work orders.

With help from the Azteca staff, we determined that the best method was to use the dynamic cost codes in Cityworks Designer.

Following all the design work in Cityworks, we then converted multiple tables into views within the Cityworks SQL database to link with Microsoft Access and begin to build the time sheet reports. The GIS Technician also met with the Finance Department to make sure the design of the Access reports would match the payroll reports. Upon completion of these steps, we developed an automated time sheet and invoice reporting system, saving hours for each staff member over a two-week pay period. It also greatly increased work efficiency and accuracy for administration staff in producing invoice reports.

Future The future use of Cityworks at the City of Grand Rapids looks bright and promising. We are reaping the benefits of its multiple solutions and feel that we have only begun to scratch the surface of the potential it holds for us. In 2009, our plan is to utilize more service requests for all the calls we receive. Another project we plan to tackle in 2009 is attaching all invoices related to work orders. The City of Grand Rapids is currently implementing a records retention system for storing all invoices. Our thought is utilize the records retention system along with Cityworks to eliminate duplication of images. Also in store for 2009, the Public Works Department plans to phase in the ability of our field crew to make changes to GIS features through Cityworks Anywhere and the possibility of using Cityworks in the field to maintain work orders.

One of the biggest projects we plan to undertake involving Cityworks will be using AVL with our street sweeper to enable us to track how often and how many times the streets in the City get swept. We hope this will allow us to give a more accurate account to the MPCA as well as inform the public how often our streets are swept. Using AVL with the street sweeper is also a test to see how the process works for us with the idea of eventually using AVL with all of the City’s snowplow trucks and graders. cw

Kenny, Grand Rapids, MN

INPRINT — March 2009

23

El Paso, TX (cont. from page 1) Daniel Kitka, relates, “The City spends a portion of the capital budget on the management system that we use to predict, document, and prioritize our Pavement Management Solution (PMS) program.” Capital budget funds are used not only to maintain assets but also to create the asset data that will be used citywide for many years.

Calling this project the Traffic Management Information System (TMIS), the City contracted with ESRI to serve as the lead manager for the project. Transmap, ESRI’s preferred business partner, was selected to collect and implement pavement distress data. The two companies have supplied professional services to the City of El Paso for the past five years in geodatabase design, system implementation and updates, data collection, legacy data integration, and workflow consulting.

The City wants to complete the PMS requirements citywide, upgrade networking, collect additional assets, and document the needs of the Streets Division.

The City decided to use MicroPAVER™ to analyze the results of their surface distress data. ESRI also brought in another business partner, Azteca Systems, to implement a work management system. Cityworks was selected because it has an interface with MicroPAVER™ and allows pavement to be tracked as an asset in the geodatabase. All fit the City’s enterprise GIS initiatives to enable maintenance strategies and decisions based on updated, factual information. The TMIS reporting solutions also help the City in determining budgets. For budgeting purposes, the City decided to work in phases on the pavement analysis part of the project.

Sample Cost Report

Transmap Services The unique procedures Transmap uses in determining surface distress information starts with the ON-SIGHT™ HD System. ON-SIGHT™ technology captures street-level, high-resolution images for use in asset and pavement distress extraction. The camera configuration on Transmap’s vans includes a forward-facing camera; a camera at a 45-degree angle to the right of way to capture ROW features; and a rear-mounted, downward-facing pavement camera. Mapping vans also employ Transmap’s dual-frequency, survey-grade GPS receiver; an inertial navigation system; progressive-scan, high-resolution, digital, color cameras; distance measurement instruments; and ground-based LiDAR laser.

Pavement Management Flow-Chart

Steve Thomas, Sr. Project Manager from Azteca Systems, summarizes: “The pavement management solution provided to the City of El Paso by ESRI, Azteca Systems, and Transmap has been extremely beneficial to the City. The strengths of each company were utilized in the solution to aid the City in obtaining pavement rehabilitation funding. The GIS solution provided by the ESRI staff was critical in providing the assets for both work order and pavement management, and in displaying pavement conditions on maps. The Cityworks software provided the tools to demonstrate the current efforts being made to manage the workload and costs of that effort. The Transmap solution provides a repeatable method for accurately and effectively gathering the pavement conditions, as well as the asset data collection.”

24

Transmap Laser and HD Cameras

INPRINT — MARCH 2009

E l P a s o , T X ( c o n t .)

Transmap staff drove the ON-SIGHT™ HD mapping vans along the specified roads during the network definition phase of the project and captured right-of-way images on both sides of each roadway, providing a 360-degree view of the road. Standard practice is to collect images at 13.1-foot intervals to capture a clear view of every ROW feature and pavement distress. Spacing can be customized to meet the needs of the customer.

The first step in determining El Linear Reference System Paso’s PCI was to prepare an (LRS, also called Linear updated version of the City’s Referencing System) is useful for managing data related to centerlines, which was used to linear features, such as roads, develop the Linear Reference railways, oil and gas transmission System (LRS). The LRS served lines, rivers, etc. The method as the route network needed to stores geographic locations by establish the hierarchical structure using relative positions along a of networks, branches, and measured line feature. Updates sections. Once the network was are easily made by changing the established, all pavement sections distance measures used to locate were divided into 300-foot pieces events along the line. with the sample portion for gathering the high-resolution imagery at the beginning of each. The industry standard is to sample areas between 1500-3500 sq. ft.

map to review the surface distresses that were found as part of the overall QA/QC procedures.

PDF of a Walkout Map Provided to El Paso

The City also purchased Azteca Systems’ Pavement Management Interface to take advantage of the asset management capabilities of Cityworks and the pavement modeling and analysis capabilities of MicroPAVER™, an industry standard. To fully integrate the two products, including the geodatabase, the data collected by Transmap was imported into Cityworks and then exported to a new MicroPAVER™ database that utilizes the asset and work management identifiers.

Steve Thomas of Azteca states, “The Cityworks Pavement Management Interface takes advantage of the strengths of Cityworks Asset Maintenance Management and MicroPAVER™ software, allowing the client sites to manage their pavement data in the geodatabase, the work orders in Cityworks, and to calculate the condition values and analyze the results in MicroPAVER™. This is a bidirectional interface that will become even easier to use and more powerful when MicroPAVER™ utilizes SQL RDBMS as projected for their version 7.0 release.”

Transmap Laser and HD Camera

Phases In June 2003, Transmap developed a LRS and inventoried more than 600 miles of pavement and street infrastructure as part of Phase I. The pavement distress information was loaded into MicroPAVER™ to generate the PCIs for each segment.

The HD images were captured. Then professional technicians conducted a photogrammetric analysis of the road network to extract pavement distress data for each pavement segment. Each distress was identified, assigned a severity level (low, moderate, or high), and given a quantity or measurement in square or linear feet. Sample images were added to the Data Development Manual to include severity levels for each type of distress.

Two years later for Phase II in February 2005, Transmap collected and input data for an additional 400 miles and provided the City of El Paso with manuals and training.

Transmap’s final step was to load all raw surface distress data into MicroPAVER™ for calculating the PCI for all sampled roads. The PCI results could then be displayed on El Paso’s basemap. An important part of Transmap’s robust solution is quality assurance/quality control (QA/QC). Transmap went into the field with the City staff and a walkout

In August 2008, Transmap began reinspecting arterial and collector pavement samples from Phase I. It is anticipated that the results will determine if the pavement treatments are giving the City the Return on Investment (ROI) they want.

INPRINT — March 2009

Phase III in August 2006 consisted of data collection on an additional 1400 miles of pavement and providing a LRS for their entire road network.

25

E l P a s o , T X ( c o n t .)

Conclusio n Pavement analysis and reporting of PCI scores is a continuing process.

The City of El Paso has embraced the PCI standard and is now seeing the benefits of reporting where and when streets are going to need repairs, even if it is ten years in the future. The wisdom of such a system becomes apparent when considering the cost to replace El Paso’s road network would exceed $1.8 billion dollars. Currently, the resurfacing budget represents a potential project size of only 45.9 miles. The number of streets resurfaced annually is based on funding allocated to the resurfacing program. Funding levels are determined during the City’s budget process. Based on current data and presentday construction costs, the City would have to spend $200 million on the resurfacing program to bring all streets to a PCI level of fair or above.

After completing the PMS, the Mayor of El Paso, has embraced the red, yellow, and green maps that communicate the “hot-spots” within El Paso. Also, since the maps are derived from a robust enterprise ESRI GIS within the city, specific tabular data can be distributed as well.

Transmap set up an ArcGIS server site for the City of El Paso for viewing their image database across multiple departments.

Transmap ArcGIS Image Viewer www.transmap.com/elpaso

Another advantage of a central maintenance structure in El Paso is the clarity it provides in allocating its resources. In order to keep all the money from going to one part of the city, asset inspections were completed across the entire city for a complete citywide view. The resulting system has made the budgeting and spending process much clearer. Specific needs within the city are determined and addressed using engineering, rather than politics, and maintenance is done in each district of El Paso. cw

For further information about Transmap and our pavement/ asset solutions, please visit www.transmap.com or for online demos, visit http://demo.transmap.com.

For all Transmap inquires, please contact Craig Schorling at cschorling@transmap.com or phone 614-481-6799.

Overall Pavement Condition Index Map

Fun Fact of No Great Importance!

We’ve come to accept that we are not the only “Azteca” around. Below are some other uses which Azteca may refer to:

Josh Stroessner snapped this shot in Madison Heights, MI Welcome to Happy Hour!

26

Azteca (band), a Latin based rock band from the San Francisco Bay Area (Maybe we can book them for our conference!)

Azteca (horse), a breed of horse Azteca, a genus of ants (Another group of busy workers!)

Azteca Records (California), a record label Azteca Records (New Jersey), a record label Azteca Mexican Restaurants, a chain located in the United States Azteca Foods, Inc., a tortilla and chip manufacturer located in Chicago, Illinois The “Aztecas” collegiate athletics teams of UDLA (Cholula, Mexico) Azteca Stadium, or Estadio Azteca, a sports stadium in Mexico City, Mexico Adidas Azteca, the official match ball of 1986 FIFA World Cup in Mexico Líneas Aéreas Azteca, a Mexican airline TV Azteca, a Mexican television network

INPRINT — MARCH 2009

Special Achievements

Congratulations to the 2008 ESRI SAG Award Winners!

Special Achievement in GIS

Newport News, VA Tim DeSalvo, Newport News; Jack Dangermond, ESRI; Kirstin Runberg-Platt, Newport News

Surrey, BC, Canada Alex Miller, ESRI Canada; Sean Simpson, Surrey; Jack Dangermond, ESRI; Myron Doherty, Surrey

El Paso, TX Harold Kutz, Daryl Coles, El Paso; Jack Dangermond, ESRI; Jesus Carrera, El Paso

Bozeman, MT Jack Dangermond, ESRI; Jon Henderson, Bozeman

Thank you

Garth Arrington and

Wayne Hill for 10 years of service to Azteca Systems!

INPRINT — March 2009

27

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

11075 South State, #24 Sandy, UT 84070