InPrint Winter 2006

InPrint Delivering Innovative GIS-Centric Maintenance Management Tools for Your Organization

Vol. 5, Issue 1, Winter 2006

FEATURE ARTICLE

Interfacing Cityworks to Financials

Portions of the following are taken from the thesis project carried out by Dawn Summers of White House Utility District. This article discusses the use of Cityworks by White House Utility District and summarizes the research findings for how operations within White House Utility District have improved.

By George Mastakas, Director of Project Management

White House Utility District Sees Improved Operations Using Cityworks!

By Dawn Summers, Project Manager, White House Utility District

The White House Utility District (the District) covers approximately 600 square miles, providing service to over 26,000 connections in Sumner, Robertson, and Davidson County, Tennessee, and Simpson County, Kentucky. An additional function of the District is the provision of wastewater service to rural areas of Sumner County. In the past, the District’s process of issuing daily assignments via paper work orders and verbal instruction did not allow the flexibility and speed necessary to deliver quality customer service

in today’s fast-paced environment.

Through the implementation of a new comprehensive maintenance management system, Cityworks, the District has reached a measurable level of improved customer service.

The District has accomplished this by resolving requests for service in less time and by replacing reactive maintenance practices with proactive maintenance. The improved level of communication between departments enables multiple employees to assist customers whenever the need arises.

In 1992, ESRI® GIS was installed in order to map the District’s service area, water lines, and sewer lines. The GIS is very important to support the standard operations employed by the District.

Many tasks are completed through the GIS that would otherwise be impossible to accomplish.

Maintaining a user-friendly

Newport News, VA, is currently utilizing Cityworks for inventory management and has tied Cityworks Storeroom into the city’s purchasing system. The process starts as a requisition for additional parts, which is passed to the City’s purchasing system for the issuance of a purchase order (PO). When materials are received, the quantity is reconciled against the PO and the requisition in Cityworks Storeroom. The city has also tied Cityworks to their human resources (HR) system. Employee information, including rates in Cityworks, are updated directly and automatically from the information contained in the city’s HR system.

For cost account tracking, Newport News has integrated Cityworks work

Cont. on page 6

Cont. page 7

White House Utility District

INSIDE THIS ISSUE

2

President’s Corner

3

Miami Beach

4

Horry County

More and more cities and municipalities using Cityworks are blending it into their financial management.

By doing so, these customers are increasing the level of detail being tracked while increasing the efficiency with which it’s being tracked.

Several customers have implemented interfaces to meet their individual monetary needs. We’d like to highlight a few of them: Newport News, VA, Long Beach, CA, Oklahoma City Water, OK, Brownsville, TX, and Citrus Heights Water District, CA.

5

Waterford Township

8

Project Management Update

10 12 14

2006 User Conference

Partner News

Regional News

.........................................................................................................................................................................

For more information on Cityworks and Azteca Systems, visit us online at http://www.azteca.com

INPRINT / WINTER 2006

PAGE ONE

InPrint Editor in Chief: Tom Palizzi Editor: Kaye Ryser Advertising: Tom Palizzi Azteca Systems, Inc. 11075 South State Street, Suite 24 Sandy, UT 84070 801-523-2751 www.azteca.com To receive a subscription or to change your address, please send your contact information to: inprint@azteca.com or call 801523-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@azteca.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 publics works organizations.

Copyright © Azteca Systems, Inc. 2006 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, Cityworks, CityworksFM and the Cityworks and CityworksFM logos are registered trademarks of Azteca Systems, Inc.; and www.mycityworks.com, www.gocityworks.com, @azteca.com and www.azteca.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.

PAGE TWO

PRESIDENT’S CORNER

By Brian Haslam, President

Another Good Year: The final measure for the success of any company is “the bottom line.” After all, a company has to make money to stay in business. By this measure, Azteca Systems had another good year. But, achieving long-term success is the result of doing well in many different areas.

Foremost, a company has to have good people. Azteca Systems is blessed to have a talented and dedicated staff.

This just does not happen by accident. We try hard to hire good individuals. When we find someone we feel good about, Azteca Systems strives to provide an environment where they can utilize their unique talents to help us succeed.

A company has to offer a service and product people want. Judging by the number of new Cityworks® clients for 2005, there is a healthy and growing market for ESRI® GIS-centric software applications.

Azteca Systems pioneered this approach for CMMS and we continually work hard to provide high-quality software designed to take advantage of the latest advancements in ESRI software.

Azteca Systems Solid Growth

10 Years of Cityworks A company needs to provide excellent customer service.

Nearly all of our clients renew their Update & Support Agreement. Azteca Systems has worked hard to improve our customer service. We have weekly meetings to review customer service issues. We track complaints and resolutions to make sure nothing is missed. We prioritize critical software bug fixes.

We look for ways to reduce problems by making improvements to the software.

Examples of this are the DB Manager and the recently released Designer Excel Templates. And, we have worked hard to extensively test the software before shipping.

By all of the above measures, we are doing well. Yet, Azteca Systems is not content. We can do even better. All of us at Azteca Systems value and appreciate your constructive feedback to help us improve.

New Software Design: 2006 will be noteworthy for many reasons. It is our 10th Anniversary for offering Cityworks and 20th year as a business. We are proud of this accomplishment and it is fun to celebrate just a bit. But what is most noteworthy for 2006 will be the 1st Quarter release of Cityworks® Anywhere (our Cityworks with embedded ArcGIS® Engine components) and the Cont. page 18

INPRINT / WINTER 2006

Miami Beach, Florida, Implements Cityworks

by Steve Thomas, Senior Project Manager

Incorporated in 1915, the City of Miami Beach has grown to be an international mecca for travel, business, and establishing a home. The 1980s and early ‘90s brought an infusion of investment capital that produced a reborn Miami Beach and a new way of life that features the arts, culture, and entertainment, all with an international flair. Miami Beach has thrived amidst change.

Department to initiate addressbased service requests and work orders to track the six infrastructure systems (Water, Sanitary Sewer, Stormwater, Streets, Street Lighting, and Sanitation).

The Streets and Streetlights Division repairs, replaces, and maintains City streets, bridges, sidewalks, curbs, and gutters, seawalls, streetlight poles, fixtures, cables, and transformers.

The Engineering Division performs designs and drafts plans and specifications for improvements to the City’s infrastructure. The division maintains engineering and utility records and regularly inspects the City’s bridges, seawalls, storm sewer, sanitary sewer, water, and street lighting systems.

The seven million tourists that visit South Beach and the Art Deco Historic District make Miami Beach the number one attraction in South Florida and the second most popular in the state following Disney World.

Keeping the City attractive for visitors and residents alike is a neverending task for the Public Works Department. The Department decided to create an Infrastructure Management System (IMS) that will be implemented in phases across multiple years. The IMS system will include an infrastructure Geographic Information System (GIS) and a service request and work order management within a Computerized Maintenance Management System (CMMS). The department selected Camp Dresser & McKee Inc. (CDM) to manage the project and provide the services with Cityworks as the CMMS. The Phase I IMS startup began in December 2005, as CDM and Azteca Systems began working with the

INPRINT / WINTER 2006

The Construction/Financial Management Division manages the City’s capital projects including water mains, sanitary sewers, storm sewers, bridges, seawalls, pumping stations, streetscapes, buildings, and park facilities. Services provided include project planning, design review, fiscal and construction management, and warranty administration. Additionally, this division is responsible for compliance with requirements of the Americans with Disabilities Act.

and DERM requirements. This water division also performs reading and servicing of approximately 12,600 water meters and manages the utility warehouse operation.

The Stormwater Utility Division manages and controls the amount of effluents which are discharged into the City’s stormwater system. This division is responsible for maintaining stormwater lines; installing catchment filter basins to reduce and eliminate polluted stormwater run-off; complying with National Pollutant Discharge Elimination System (NPDES) permit requirements; and relieving flooding conditions.

Following Phase II of the project, over the next year or so, which includes the collection and digitizing of the City’s assets in an ArcGIS geodatabase, the department staff will begin processing asset-based work orders. As time permits, the address-based work orders will be linked to the assets stored in the new GIS layers.J Incorporated: 1915 Population: 88,000 (2000 census) Area: 7.1 square miles + 10 miles of waterways (canals, bays, coastline) Avg Temp: 75.3º F Platform: Cityworks version 4.3 ESRI’s ArcSDE and ArcGIS 9.1 SQL Server 2000 Users: 12 – 20 citywide Installation: December 2005

The Water and Sewer Divisions maintain water and sanitary sewer pumping stations; supply potable water and collect wastewater in the City and neighboring areas; clean and maintain water storage tanks, water and sanitary sewer lines, appurtenances, subaqueous crossings, fire hydrants, water service lines, meters and valves; and collect water samples and check for compliance with EPA, HRS, PAGE THREE

Horry County, South Carolina, “Enterprise” Expands to “Intergovernmental” with GIS-Centric Software Multi-jurisdictional Collaboration in the Carolinas

by Tim Oliver, Deputy Director IT/GIS, Horry County, SC

Horry County, South Carolina, home of the famed Myrtle Beach, is best known for its Atlantic Ocean resorts.

But in government and tech circles, it may become known as one of the first regions to use GIS-centric software to enhance intergovernmental cooperation.

Horry County (pronounced O-REE) started building its GIS in 1999.

Civil engineering and IT consultant Woolpert, Inc. has been helping the county to go enterprise-wide to leverage its significant GIS invest-

ty chose Azteca’s Cityworks software because it is the only truly GIS-centric CMMS product on the market.

Cityworks is certified by NAGCS. Working with Woolpert, Horry County has successfully deployed an advanced CMMS for the departments of Emergency Management, Land Records, IT, Public Works, Buildings, Roads, and more. Document management, Pavement Management, CAMA, and customer and mobile services applications are being integrated.

Intergovernmental vision comes to fruition The move to GIS-centric software made it technically possible and financially feasible for cities within the county to access a single data source for all datasets stored in ArcSDE for SQL Server. As part of the vision of intergovernmental collaboration, the county installed a fiber-optic, wide-area network from the county data center to all county buildings and then to facilities owned by the cities of Myrtle Beach, North Myrtle Beach, and Conway.

ment. “We wanted software solutions with GIS capabilities inherent to the software rather than connected to it,” said Sheila Butler, Horry County IT Manager. “Nextgeneration software should have the flexibility to conform to existing data structures and systems.” In fact, the county began including GIS-centric requirements, standardized by the National Association of GIS-Centric Software(NAGCS), in all RFPs for software solutions that may have a geographic component.

For its integrated call center/work order management needs, the counPAGE FOUR

The plan is for the cities to not only access the single data source but also to maintain jurisdiction-specific data on the county’s ArcSDE Server.

An intergovernmental cooperative agreement between the county, the City of North Myrtle Beach, and Azteca, written by Woolpert, allows the county to be the master license holder for Cityworks and all associated modules, and for North Myrtle Beach to use the county’s ArcSDE as the foundation for its deployment of Cityworks. Today, the city and county jointly maintain aspects of a shared geodatabase and a shared work order system (particularly useful in an emergency) along with other technical infrastructure and

knowledge. Similar agreements are being developed for the cities of Myrtle Beach, Surfside Beach, and Conway and will incorporate ESRI tools such as ArcEngine and ArcServer.

Cityworks is right on target and exactly what we wanted. It is GIS-centric, easily deployable, and affordable—meeting our needs and offering an environment for easy data and application sharing among our constituent jurisdictions.

GIS-centric Software Fosters Cost-saving Benefits in Horry County • Shared data source. The move to enterprise-wide GIS-centric software is bringing to fruition a vision that all public entities access a single data source for all countywide datasets stored in ArcSDE for SQL Server.

• Entity-specific editing. Jurisdiction-specific datasets with common interest (zoning, land use, etc.) will be maintained in the common SDE datasets but will be edited by the responsible jurisdiction, all via a common WAN. • Consistent foundation for future applications. All new software solutions deployed by the county will be GIS-centric in that a common SDE dataset and GIS data models form the foundation for these new applications. J

INPRINT / WINTER 2006

Integrating Dig-Smart with Cityworks: Waterford Township, Michigan Solving the Ticket Management Problem

By Jim Schoenberg, Bergmann Associates

For years utilities have had to cope with rules, regulations, and laws that deal with protecting underground/buried infrastructure. The practice of underground utility protection is commonly serviced through a single or multi-state agency whose function is to notify

utilities when an excavation is to occur. The names of these agencies are as varied as the colors used to mark the lines themselves. In Illinois, for example, the agency goes

by JULIE. Yet in California, the same agency is called USA. Florida was ambitious using SUNSHINE while Minnesota went with GOPHER. The unique names for these agencies goes on and on. However, our stop takes us to Michigan whose underground utility protection service goes by the name, MISSDIG. In almost every situation, the underground protection service notifies its member utilities via email.

This email is a flat, text file containing the necessary “dig information.”

This includes the site’s address, the work to be performed, the date of the planned excavation, and other relevant information, such as the contractor’s name and their contact information, near and cross streets, and finally, general remarks and comments. The importance of a utility protection service generating the ticket is self-explanatory; however,

INPRINT / WINTER 2006

the management practices behind receiving and processing hundreds or even thousands of tickets per day can be somewhat of a mystery. Utility departments electric, gas, cable, water, sewer, oil, etc. all must cope with the daily management of ticket loads. In a suburb of Detroit lies the Charter Township of Waterford who just so happens to be one of these utilities. The Township’s Department of Public Works is responsible for managing the tickets coming in from MISSDIG because the Township owns miles and miles of underground water and sewer lines that must be properly staked for excavations.

As a current Cityworks user, the Township became more efficient in processing incoming MISSDIG tickets, but the Township felt that the process could be improved. They wanted a solution that automatically imports the MISSDIG ticket into their Oracle database so it could interact with Cityworks. Waterford did not have to look far. Just on the other side of Lake Erie, an ESRI Business Partner had developed such a solution.

Bergmann Associates (Rochester, NY) developed the solution DigSmart™ which uses both the incoming electronic ticket and the ESRI geodatabase to facilitate the management of utility protection service tickets.

By implementing Dig-Smart, the ticket is automatically stored in Oracle where its address infor-

mation can be used to geocode the site via the ESRI Location Services.

Although this solution seemed to fit the needs of Waterford, they wanted to generate a Cityworks work order (or service request) for each ticket processed by Dig-Smart.

Utilizing the geodatabase seemed to be the only possible way of directly linking the two software products.

Both Azteca Systems and Bergmann Associates products are NAGCS certified, meaning GIS-centric.

Having the software system with this architecture allowed developers from Bergmann Associates and Azteca to develop a unique method for processing tickets in Dig-Smart while simultaneously creating a work order in Cityworks without any duplication of effort. As a result of the software integration, dispatchers at Waterford no longer needed to go though the laborious process of mapping tickets manually. Mr. Terry Biederman, PE the Township’s Director of Public Works explained: Prior to the Dig-Smart application, the activity of processing requests for utility locations was comprised of the following tasks: Cont. page 19

PAGE FIVE

White House Utility District

(cont. from page 1)

customer database is essential to the Customer Service department, which handles several hundred customers per day. One goal of the District was to integrate the customer database with the mapping system. TAABS was a DOS-based computer system that was utilized during the mapping system installation. Due to limitations TAABS imposed, a transition to a windowsbased program called Oasis took place. Oasis had issues from the beginning and after two years of disappointment a new billing system was needed, so a search began for software that would encompass all of the District’s goals. The Invision software system was then implemented with mixed results. The District has worked around certain limitations while waiting for enhancements that will enable all of their software systems, including the mapping system, to be integrated.

While working with consultants on the mapping system, Cityworks was recommended. After researching the product, the District made an informed decision to purchase the software. With the addition of Cityworks, the District has been able to focus on improving the quality of

customer support provided by each department. Customer Service is able to track the variety of phone calls received and utilizes this information to prevent future problems from occurring. The new layers added to the GIS mapping system enable users to view current locations of company vehicles in relation to bullets highlighting outstanding work orders. The installation of wireless computers in the field allows technicians to view the GIS map outside the office and work orders to be sent and completed in real-time. By using the material and labor portion on each work order, the accounting department has the ability to report the value of District assets utilized in the field and the total cost for work performed.

Using Cityworks has enabled the District to focus on improving the quality of customer service by improving time management. Communication with customers is essential in a service environment. With the implementation of Cityworks and wireless technology, White House Utility District employees are able to receive feedback from the field more rapidly and have better information at their fingertips to communicate

Dawn Summers, Project Manager

with their customers.

A portion of this thesis project was devoted to a study to determine if there was a measured effect for improved customer services correlating to the implementation of Cityworks. The District selected three areas of customer support for the study - the number of calls received in the customer service department, the number of service requests and work orders along with the time needed to complete the task assigned to field maintenance staff, and the number of repeat and duplicate service requests and work orders created in the office due to miscommunication. In order to accurately evaluate the impact of Cityworks on the areas of study, data was obtained and analyzed both before and after the implementation of Cityworks. The District used data over a two-month period of time, between January 25, 2004 to March 25, 2004 (before the implementation of Cityworks) and June 4, 2004 to August 4, 2004 (after the implementation of Cityworks).

The first area of the study looked at the number of customer service calls received. The total number of

Tammy Moses - Call Taker

Regina Gaddis, GIS Supervisor PAGE SIX

INPRINT / WINTER 2006

White House Utility District calls received for the time prior to the Cityworks implementation was 14,613, as compared to 9,002 after the implementation or a 38% decrease. By analyzing the data and comparing such things as the types of requests for service, a statistically significant decrease in customer service requests occurred as a result of the implementation of Cityworks.

Overall, the District has realized a 15% reduction in customer service requests. This improved customer support is due to the proactive measures now being taken by field personnel because of improved communication and access to data.

looked at the number of common service requests and work orders assigned to field maintenance staff and the time required to complete the assigned tasks. The total number of service requests and work orders created for the time period January to March 2004 equaled 2,547. For the stated time period after the implementation of Cityworks, the Chris Greer number equaled 859, a 66% decrease. In addition, the man hours needed to complete assigned work dropped The second area of the study from approximately 204 hours to approximately 85 hours, a 58% decrease. The District realized a nearly three-fold reduction in the number of service requests and work orders assigned to field maintenance staff and an equally dramatic reduction in the number of hours required to perform assigned tasks. The Cityworks implementation corresponded with a significant decrease in the number of service requests and work orders Chris Greer - Performing Water Turn On created and the hours

- Demonstrating Mobile Field Capabilities

needed to complete assigned work.

The third area of the study looked at the number of repeat and duplicate service requests and work orders created by the District. The total number of repeats or duplicates for the first time period equaled 783.

For the second time period after the implementation of Cityworks, the number equaled 120. From employee feedback the District expected about a 50% decrease.

Instead there was an astounding 85% decrease. Analysis of the data revealed that the decrease can only be attributed to the implementation of Cityworks. J

Interfacing Cityworks orders to their financial system as well. To facilitate this, work orders contain the account funds and codes in custom fields. A process runs at a set interval that takes the pertinent account and cost information from Cityworks work orders and loads them into the financial system.

These interfaces were developed by Azteca Systems’ business partner, Woolpert, Inc. Long Beach, CA, is also using Cityworks for cost account tracking, similar to Newport News. Azteca developed a utility that extracts work order costs, the debit account code, and the credit account code (from

INPRINT / WINTER 2006

custom fields) into a text file that matches the city’s format requirements. The City developed a utility to load the file into their financial system, FAMIS, developed by KPMG.

Another Cityworks’ customer who incorporated Cityworks into their financials is Oklahoma City Water, OK. Oklahoma City uses Cityworks to dispatch crews to perform water shutoffs. An application developed for the city loads water shutoff notices from their water billing system into Cityworks as service requests.

Updates from Cityworks to the water billing system go back when the shutoff is completed and the service

(cont.)

(cont. from page 1)

request is closed.

Brownsville Public Works, TX, uses Cityworks to track costs for all the work taking place in construction projects. Brownsville has developed an interface between Cityworks and their general ledger system (SCT Banner) that passes the costs accumulated on a construction project from the general ledger into Cityworks. This integration has a web-based front end and was developed by BPUB’s in-house IT staff. J

PAGE SEVEN

PROJECT MANAGEMENT UPDATE Philly Streets — Taking it One Group at a Time, and Experiencing Many Happy Returns

by George Mastakas, Director of Project Management

Are you implementing Cityworks on your own? Are you concerned about the magnitude of your implementation? Are you worried that you won’t start seeing see results soon enough? Do you have a boss who is results oriented? (LOL!) Self-implementing a system in an organization that has many groups, each of whom have several workflow processes, can be a challenge. Coordinating the various players, understanding each one’s processes and the nuances therein, and making sure you reflect their practices accurately and in a way that they can be executed efficiently by the end users of the system requires a lot of attention. These types of implementations can get delayed and even stall.

There are many ways to address this. Hiring an outside consultant to help is one. But another way targets specific groups and brings them online one at a time. One that assures three things...

1. That the end users get a system tailored to provide exactly what they need and deployed the way they need it.

2. That the organization understands and knows Cityworks well enough and is able to fully utilize Cityworks so that configuration changes can be made at a moment’s notice to enhance the software’s performance.

PAGE EIGHT

3. That results are more immediate... Which makes your resultsoriented boss happy!

The organization is Philadephia Streets, aka Philly Streets.

The Cityworks administrator is Marion Storey, aka Marion and/or Marion and crew. The challenge is to self-implement Cityworks CMMS in the various groups within this organization, each of whom have many workflow processes, all of which require a lot of detail to be tracked in an efficient manner. Like all Cityworks users, Philly Streets is a strong GIS user, so it was a nobrainer that they chose Cityworks.

But in order for Cityworks to succeed and be adopted by the users in Philly, it had to prove it could do what they needed it to do. Here’s how that happened...

Almost 3 years ago, Philly Streets acquired Cityworks and asked us to provide them administration training. But there was one catch—we had to do the training remotely.

Back then, this was new territory for us. But we were intrigued by the idea, and the more we did it, the more we liked it. As a result of this experience with Philly Streets (and Marion), we now offer remote implementation assistance and training as an alternative to the traditional implementation process. The way it worked then (which is how it works

now), is that we scheduled a 2-3 hour session to go over all the steps needed to get Cityworks going. We took it from the top and moved down the list... Database install, software install, Designer (naturally we spent a lot of time here), service request training, and work order training. In all, this took a couple of weeks. And then the fun started...

Marion got things rolling with Concrete Operations - a discrete unit that needed only one task in a work flow, but they also had to track labor, materials, and equipment usage. They were looking for a new Access database application to track their work, but decided to become the first unit to implement Cityworks.

Marion and crew met with the Concrete Operations supervisor, who had requested the Access application. With him, Concrete Operations developed a list of work order template types and created a single task “Pour Concrete” (they knew they’d be adding other tasks in the future, and they knew they could do this easily). They determined Concrete Operations needed to define custom fields in the work order for length and width of the areas filled with concrete and they also needed to know if they were on city or state routes (different depth requirements), which they track in another custom field. The most challenging piece was that their material is not measured directly on the vehicles. Each vehicle has a meter, and the reading on the meter has to be multiplied by a conversion factor to determine the amount of concrete used. They added a custom field to store the conversion factor at the work order level based on data stored at the vehicle level.

The conversion factor in combina-

INPRINT / WINTER 2006

Project Management Update tion with the meter reading allows them to calculate the amount of concrete used. The conversion factor is populated by a database trigger.

The supervisor was also extremely interested in some customized reports and about 10 reports were created in Crystal Reports for this implementation. This being the first process, it also took the longest - a couple of months. Not much has changed since it was implemented.

The process has been expanded to include four to six additional tasks depending on what’s being done, but the rest is the same.

Next came alley lighting. This implementation was developed in a different Cityworks domain, because the groups do not work together and they have different geopolitical boundaries. (Street lighting districts are different from Highway Districts, sections and subsections) Alley lighting gave Philly the opportunity to learn the whole work flow from service request to work order. It also required an import of 5 years of existing data and the development of a methodology for associating assets to the old data. Many meetings were held and flow diagrams of the work process as it existed and as it could be enhanced and/or adjusted with the use of Cityworks were developed. This process includes contract work and requires the ability to reconcile monthly bills submitted by the contractor. The planning process took a couple of months and then

INPRINT / WINTER 2006

(cont.)

the data import took another couple of months.

By this time Marion and crew were experts. My conversations with her went from, “How do I do <insert Cityworks functional question here>?” to “I’m thinking of setting up a process in one of the following 3 ways... I have my favorite, but which do you think would work the best and why?” We’d go back and forth discussing it, and eventually come to something that works great for Philly Streets. But who am I kidding?... The reality is that she’d already come up with the best configuration. She just wanted to make sure I was paying attention! ;) The next unit for implementation was the Right-of-Way and involved working with the supervisor of the Right-of-Way Inspection group. This group is defined in the same domain as the concrete operations; however, they use a different category of work order. They only use work orders, but the source of the work orders is a permit system that the Streets Department uses for allowing street closures. The supervisor runs an import routine that reads the Street Closure Permit System database and creates work orders in Cityworks which include a pdf version of the permit as an attachment to the work order. (Note: The integration and pdf attachment functions were developed

by Marion’s group and not Azteca.)

These work orders are used to manage inspections of work being done on the city’s streets.

Inspections are done using the custom

inspection templates in Cityworks, and photos and drawings are stored in an attached Excel spreadsheet created by the inspectors. This implementation also included many reports, some of which are extremely complicated. One of these reports generates bills for the degradation fees which the City has just started charging the utilities who make cuts in the streets. This process was implemented in 6 weeks, due in part to the enthusiasm of the supervisor who Marion has worked with.

What about the future? Philly Streets is looking at expanding the system into their Survey Bureau and have been meeting with them to understand their workflow. (Surveys will be another domain in Cityworks) They’ve had a few meetings with Sanitation to look at implementing store room and work order management for their facilities management group. (Sanitation will be another domain) They may also track external requests for pole attachments on their poles with Cityworks. This will be in the Right-of-Way Unit, but it crosses over into Street Lighting. Initial meetings have been held to discuss workflow. But the most pressing effort for Philly Streets right now is the City’s pothole initiative. Marion and crew have had workflow meetings and are looking to automate data entry using GPS. They’re not sure yet if this is feasible or reliable enough, but if there’s even a remote possibility that it is, you can bet Philly Streets will do it.

And there you have it. What are you waiting for? J PAGE NINE

Cityworks User

June 19Park Cit

Online Registration Watch our website for de Pre-Conference Training

P

June 16 & 17

Introduction to Cityworks ArcGIS Part I & II

Park City Marriott Hotel Once again we have chosen the luxurious setting of Park City Utah for the Cityworks User Conference. The Park City Marriott is a full-service hotel and is ideally located 1 mile from Park City’s historic Main Street. Hotel amenities include a conference center, business center, lobby concierge, Starbucks Coffee kiosk, swimming pool, whirlpool, fitness center, bike rentals, restaurant, and lounge. A variety of outdoor recreation activities are also close by such as mountain biking, jogging trail, Alpine hiking, and several golf courses within a few miles. Park City and the Wasatch Mountains make a perfect setting for meetings and events.

Single or Double occupancy: $79.00 (435) 649-2900

PAGE TEN

Overview Welcome to Cityworks. This course is designed to instruct in the operation of Cityworks from an end-user’s point-of-view. Topics include basic functionality within ArcMap, the Cityworks toolbars, and the creation of service requests, work orders, inspections / tests, and event layers.

Details Location: Marriott Hotel in Park City, Utah Date(s): June 16 and 17 Cost: $850 for early bird registration/$900.00 after April 15th (Package price for both the training and one conference registration)

Mormon Tabernacle Temple Square Tour

David Hansen will be your sounds of the Mormon Tab day morning broadcast of “ Afterwards there will be a historic tour of Temple Square.

Cityworks Administration

Overview This two-day course covers the complete implementation of Cityworks including relational database, ODBC, client software installation, and Designer configuration. Along with implementation, users are trained on all the facets of the Cityworks Desktop.

Details Location: Marriott Hotel in Park City, Utah Date(s): June 16 and 17 Cost: $850 for early bird registration/$900.00 after April 15th (Package price for both the training and one conference registration)

Hike Brian Haslam is geared up mountains. You’re in for a

INPRINT / WINTER 2006

Conference 2006

-21, 2006 ty, Utah

n begins in March etails - www.azteca.com

Pre-Conference Activities Sunday, June 18

Golf Tournament

This annual golf tournament is fast becoming a favorite activity. Golf spots are limited and will be assigned on a priority basis by registration date. Tee–times will be approximately 10:00 am, Sunday, June 18. The cost is $80 and includes a cart and balls. Rental clubs are available.

r

Choir and Historic

r host as you enjoy the beautiful bernacle Choir and their Sun“Music and the Spoken Word.”

Conference Highlights Sunday, June 18 – Welcome Reception and Registration We look forward to meeting and greeting each of you as you arrive and participate in this annual event.

Monday, June 19 - Vendor Reception Help us kick off the conference in style! Come hungry and join us for food, drink, entertainment, and socializing in an evening of food and fun. Don’t miss this great opportunity to meet our Exhibitors, Sponsors, Business Partners, and the whole Azteca staff in a relaxed setting.

Tuesday, June 20 - Cityworks 10th Anniversary Spectacular - Utah Olympic Park Help us celebrate “10 years of Cityworks” at the Utah Olympic Park. Ride the zip line, alpine slide, or bobsled as dinner is being prepared. Then stick around to watch the world famous Flying Aces perform amazing aerial jumps and stunts. This is sure to be the highlight of the conference.

Mountain Bike Tour Join Ryan Miller for a mountain bike ride. Enjoy beautiful scenery as you roll up and down the trail at an elevation of nearly 8,000 feet. Expect awesome vistas and picturesque alpine meadows.

Bike rental available through the Marriott Hotel.

and ready to take you on a moderate hike in our beautiful Wasatch great view of the beautiful Wasatch valley.

INPRINT / WINTER 2006

PAGE ELEVEN

PARTNER NEWS Partner Directory International Distribution Partner • • •

ESRI Canada, Canada Meldis, AB, Sweden Systematics Limited, Israel

Business Partners • • • • • • • • • • • •

Arcadis G&M Inc. AUI, LLC ATS-Chester Engineers Bowne Management Systems CDM Civil Solutions Cobra Technologies Collier Engineering Data Transfer Solutions, LLC EFM Group EMH&T Enterprise Information Solutions, Inc. • IT Nexus • Jones, Edmunds and Associates • KCI Technologies • L. Robert Kimball & Associates • Mactec Corporation • Motorola • Municipal Information Systems • North Arrow Technologies • NTB Associates • OHM, Inc. • OneGIS • PBS&J, Inc. • Power Engineers, Inc. • Schneider Corporation • Short Elliott Hendrickson • Strand Associates, Inc. • Sunrise Engineering • Timmons Group • Velocitie Integration, Inc. • Vanasse, Hangen, Brustlin, Inc. • Varion • VESTRA Resources, Inc. • Wade Trim Associates • Westin Engineering • Weston Solutions • Woolpert

Strategic Partners • • • • • • • • • •

CompassCom Coulter Mapping Solutions Earth Touch Solutions ESRI Canada Hyland Software Laurel Hill Miner & Miner MWH Soft Route Smart Tadpole Cartesia

PAGE TWELVE

City of Charlotte and Mecklenburg County, North Carolina

by Paul Braun, Varion Systems

The City of Charlotte and Mecklenburg County, NC, have joined forces to protect their land and water quality resources in the region through partnering in the development of an Environmental Data Management System (EDMS). The purpose of the EDMS is multi-fold: to provide a common location to house all water quality related data and provide tools for access, analysis and reporting; to assist with National Pollution Discharge Elimination System (NPDES) compliance and permitting across the county; to provide mobile tools for environmental investigators to solve problems while in the field; to integrate existing business systems and replace a legacy, custombuilt system that currently tracks the organization’s activities; to leverage investments in GIS; and to manage the work load of all users.

To meet the extensive needs of the EDMS, the City and County selected Cityworks software as a key component to the EDMS. GeoAnalytics, Inc. is integrating Cityworks with a suite of other technology including Varion Sytems’ GIS portal technology – PV.Web, the SAS Institute’s world-leading Business Intelligence and Extract, Transformation and Load (ETL) technologies, and Tadpole Cartesia’s spatial data synchronization tool – GO! Sync for ArcPad. The GeoAnalytics team completed a phase 1 proof-of-concept pilot in January 2006. The pilot project utilizes Citworks Desktop for maintenance management, PV.Web as a spatial portal for viewing activity by the broader audience, SAS’s ETL tools for data integration, and Tadpole’s GO! Sync for synchronizing spatial data to hand-held devices. A phase 2 full-system implementation is set to begin shortly and run through the better part of 2006. The full system will leverage the functionality and flexibility of Cityworks Server and ArcGIS Server technology to round-out this state-of-theart enterprise system. J

INPRINT / WINTER 2006

Partner News

(cont.)

City of Lima, Ohio, Utilities Department Implements Cityworks and ArcGIS Bill Hoisington, Project Manager, VELOCITIE Integration, Inc.

By implementing the Cityworks® suite of asset maintenance management products, the City of Lima, Ohio, Utilities Department has set its sights on developing a uniform and structured approach to maintenance that will reduce costs and increase the level of service. The Utilities Department consists of seven divisions: Customer Service, Billing and Collection, Data Systems Group, Field Services Division, Wastewater Treatment Plant, Water Supply and Treatment, and the de-

Lima Wastewater Treatment Plan

tenance management system will be used by personnel from each of these divisions and the department administration to facilitate operations of their water and wastewater facilities.

Cityworks will help the City meet its objective to improve overall service by decreasing service interruption, increasing predictive and preventive maintenance, and increasing customer feedback and notification. The City will also gain a better understanding of work performed and its costs to support the balanced scorecard methodology. The ease of use, integration of existing systems, and replacement of disparate systems will increase overall efficiency and operational effectiveness.

VELOCITIE teamed with Azteca Systems to implement the Cityworks suite of products. The City chose the VELOCITIE team for its utility and municipal gov-

ernment experience and proven Cityworks implementation and integration methodology. The project approach includes: • Developing a project road map and future state work processes • Implementing Cityworks for Field Services, water supply and treatment, and wastewater treatment plant departments • Migrating legacy GIS data to ArcGIS technology • Integrating Cityworks products into the business processes of the City • Integrating the City’s sewer inspection system with Cityworks • Integrating Cityworks with SCADA and GEMS™ customer information • Mobile field force deployment of Cityworks • Delivering training and documentation for administrators and endusers J

partment administration. The main-

INPRINT / WINTER 2006

PAGE THIRTEEN

Partner News

(cont.)

Naperville, Illinois, Integrates Financial System with Cityworks Rick Hammond, Woolpert, Inc.

The City of Naperville, IL, a longtime user of Azteca products, has integrated its HTE financial system with Azteca’s Cityworks. The merging of the two systems makes it possible for Naperville to take full advantage of the best of both systems. This integration confirms that HTE and Cityworks can be successfully deployed together, providing a fully functional and efficient data management environment.

Woolpert Inc. worked with the city to leverage both systems, allowing Cityworks to extract data for labor, material, and equipment costs directly from the HTE system. The

PAGE FOURTEEN

process provides Cityworks users with useful data from the financial management system to create and manage work orders. As a result, city staff has expanded their original Cityworks Call Center deployment to include Cityworks for their public works, water, and wastewater divisions. Successfully interfaced with many other financial systems, this specific project further demonstrates the openness of Cityworks and ease in which it can be integrated into an agency enterprise environment.

flow easily from HTE to Cityworks. Effectively avoiding the complications of running two systems, our staff is now able to use Cityworks to manage the work order process.” Using a “best-of-breed” strategy has enabled our customers to leverage the full extent of the better business systems and Cityworks in a seamless environment.

J

“The integration of HTE and Cityworks provides Naperville with the best of both worlds,” said Larry Gunderson, GIS Manager for the City of Naperville. “HTE manages the financial data while Cityworks controls the service request and maintenance process. This integration enables us to utilize Cityworks while allowing customer information, payroll and inventory data to

INPRINT / WINTER 2006

Partner News

(cont.)

Richmond, Virginia, Cityworks Implementation Completed Ed Singer, Timmons Group

The City of Richmond Department of Public Works has just recently completed their implementation of Azteca Cityworks. Working with Timmons Group and Azteca, the system was successfully designed, configured, and implemented to support 30 Cityworks Desktop and Storeroom users located within DPW’s Stormwater, Bridges, Urban Forestry, Streets, Traffic, and Administrative divisions. In addition to the standard Cityworks CMMS functionality, the solution interfaces with the City’s Citizen Request System (web-based service / complaint tracking appli-

INPRINT / WINTER 2006

cation), Central Address Database (real-time validation of city addresses), and a custom-developed ArcGIS / UNETRANS / Cityworks geodatabase and linear reference system.

Throughout the project, the City of Richmond was in a constant state of change. New City leadership, including many within DPW, are currently implementing a significant number of managerial, organizational, and business process changes that impacted the Cityworks configuration on a near real-time basis.

Timmons Group Principal, Ed Singer, states, “The entire implementation team demonstrated an amazing drive and ability to adapt to the temporal management and process changes that impacted this project. As DPW settles into its new skin, we are eager to witness the far-reaching benefits that the Cityworks Enterprise Asset Management solution will deliver to the employees and constituents of Richmond DPW.”

Richmond GIS / Cityworks Manager, Steve Waldron, adds, “The City of Richmond and Timmons Group Team have realized a successful build-out of our system. However, we still have a lot of work that remains to be done in light of the recent organizational and business process changes within our department. As we look toward July 2006 as our “go-live” date, we are confident that our staff and Timmons Group will be able to implement the system changes needed to accommodate our new processes.”

Richmond DPW will also begin beta testing the new Azteca Cityworks Anywhere ArcEngine-based solution over the coming weeks.

For more information on this successful Cityworks deployment, contact Steve Waldron at waldrosr@ ci.richmond.va.us or Ed Singer at ed.singer@timmons.com. J

PAGE FIFTEEN

REGIONAL NEWS Marketing & Sales Director and Midwest Region Tom Palizzi

AZTECA SALES REGIONS - 2006

303-467-2738 tpalizzi@azteca.com

We enjoyed a remarkable year in 2005 and are poised to maintain an outstanding growth rate in 2006. To better serve our clients, potential clients, and partners, our sales and marketing team has grown and adjusted to meet the demand. We welcome Phil Mogavero, Northeast Regional Representative.

Phil has assumed responsibility for the Northeast US area. Brent Wilson now covers the Southeast US and David Horton the Western US. For the next month or two, I will be attending to business in the Midwest until we name a new Midwest Regional Representative. Becky Tamashasky and Jen Hernandez remain involved in Sales & Marketing, providing technical and marketing support to our sales team, partners and distributors.

Jen Hernandez is taking on a new role designed to provide marketing support to our domestic and international partners.

Ms. Hernandez has been with Azteca for nearly two years as our Southeast United States regional representative. She brings a solid background in Cityworks and how it applies to a wide array of markets. She will provide a steady stream of marketing information and help our partners better understand Cityworks’ capabilities towards meeting client opportunities. In addition, Jen will be conducting web demos and attending conferences.

Later this spring, we’ll be unveiling our new website, brochures, and related marketing materials. Meanwhile, we’ll hope to see you at the 2006 Cityworks User Conference and other events. As always, please let us know how we can assist you and thanks for your continued support! J

PAGE SIXTEEN

Buffalo Northeast

 Denver Midwest

Salt Lake City Western

Dallas SouthNortheast Region Becky Tamashasky

574-231-8029 btamashasky@azteca. com

Hello from South Bend! Here’s what’s been happening in the Northeast since the last InPrint........

There was a great turnout at the Michigan User Group Meeting hosted

by Ann Arbor. The City shared information on how Cityworks is currently being used in the City as well as their future plans for expansion.

Make sure to check them out at the Cityworks User Conference this summer where they plan on presenting how Ann Arbor used Cityworks to manage the removal of trees to prevent infestation of the Emerald Ash Borer!

Also, if you’re interested in hosting a Cityworks User Group meeting in your region, just let us know!

Things have really been busy in the Northeast since the last InPrint.

During that time the following organizations have selected Cityworks: • Reading, PA - The City will focus on implementing Cityworks for their sewer department and this will include treatment plants in a future phase.

• Lima, OH - The City will be implementing Cityworks for the water

and sewer utility and Lima is also planning on including the treatment plants in a future phase.

• Norwalk, CT - The City has completed their Cityworks implementation and gone live! The primary concern for Norwalk has been complaint tracking and so far they’ve already seen a marked difference in efficiency and tracking.

• Terre Haute, IN - The City is still in the implementation phase and is currently focused on implementing Cityworks for the public works department and specifically streets.

• Pittsfield Township, MI - Pittsfield Township will be implementing Cityworks for the Utility Authority. J

Northeast Region Phil Mogavero 716-882-7186 pmogavero@azteca.com

Hello from Buffalo, NY. My name is Philip Mogavero. I am the new Northeast Regional Representative for Azteca Systems. I will be working closely with my predecessor, Becky Tamashasky, for the next few months to provide our clients and business partners with the same reliable service you have received from Azteca Systems in the past.

I am looking forward to the opportunity of working with Cityworks among such a robust group of people and assisting you in any way. J

INPRINT / WINTER 2006

Regional News

Southeast Region

Brent Wilson 214-507-0579 bwilson@azteca.com

State of the Region…

Happy New Year!!!

As many of you now know my region has been moved backed to the SE with the expansion of our company. So this is goodbye and farewell to many clients and hello and glad to be back for other clients.

I know Jen’s shoes will be hard to fill, because the clients in the SE liked her so much. So my marketing spin is…

Come out to the User Conference in Park City UT and you’ll get to catch up with Jen there;-) What’s happening in the Southeast Region…?

• Miami Beach, FL, kicked off implemention by CDM and Azteca Client Services.

• Killeen, TX, selected Cityworks and is underway with IT-Nexus and Azteca Client Services to implement the application. Killeen is home to many men and women at Fort Hood.

We salute our men and women in the military there in Fort Hood and around the world.

• Charlotte-Mecklandburg County, NC, finished Phase 1 of the project with Varion Systems and will soon be

starting Phase 2.

• Burleson, TX, expanded their license contract to include 6 new licenses of Cityworks Anywhere.

• St. Johns County, FL, selected Cityworks and will be implemented

by Woolpert and Azteca Systems.

Parts of the project will be completed

by LA Consulting.

• Lewisville, TX, selected Cityworks and began a web implementation with our client services department.

• LBJMUD, TX, expanded their license to better serve the Municipal Utility District. PBS&J implemented the Utility District last year and have been continuing to support them as they expand.

• Brunswick, GA, selected Cityworks and will be implementing Cityworks over the coming months.

• Cocoa Beach, FL has kicked off an implementation with Azteca Systems Client Services.

• Marco Island, FL, selected Cityworks and will be implemented

by CDM. There will be 2 user group areas in the SE. One in the west and one in the east of the Region. Watch for news on these meetings to be emailed to our clients. Hope to see you all soon. J

(cont.)

Western Region David Horton

801-523-2751 dhorton@azteca.com

It was a busy quarter in the Western Region to close out 2005. I got the chance to travel quite a bit doing seminars with ESRI and other business partners. I also had the great opportunity to drop in on several clients in the Western Region. I really enjoy the time that I get to spend with all of you and seeing how you are utilizing Cityworks.

I’d like to add a special welcome to our newest Western regional clients: • Lake County Sanitation District, CA The annual Cityworks User Conference is coming up fast. I hope to see you all there. You have all most likely received the call for papers. I encourage you to respond quickly so we can have as many user presentations this year as is possible. J Anyone interested in advertising or contributing to this publication, please contact: Tom Palizzi (801-523-2751)

AZTECA NEWS Azteca Welcomes New Customer Support Representative and Northeast Representative...

Kyle Boyd joined Azteca Systems as our newest Customer Support Representative over the Northeast Region.

A graduate of BYU, he received his BA in French and then his MBA. He speaks fluent French and has studied six other languages: Russian, German, Italian, Spanish, Japanese, and Latin. In the past, he’s worked as a French teacher, mainframe computer operator, systems integration consultant, and stockbroker.

INPRINT / WINTER 2006

Interesting Fact: As a senior in high school he spent a month in St. Petersburg, Russia—back when it was still called Leningrad. One of his main recollections of that time was the grayness. All seemed gray and dismal under the communist rule. J

Azteca Systems welcomed Phil Mogavero on January 1 as our Northeast Representative. Born and raised in western New York, he graduated from Buffalo State College with a BS in Urban/Regional Analysis and Planning and the University at Buffalo with a Masters in Geography/

GIS. His professional career includes working for the City of Niagara Falls, NY, TVGA Engineering, Erie County Soil and Water Conservation District, Erie County Office of GIS, and Bergmann Associates.

He resides in Buffalo, New York, with his wife, Mary, and daughter, Madeline Grace. He enjoys hockey, skiing, golf, and baseball. J

PAGE SEVENTEEN

CLIENT SERVICES UPDATE What’s going on in Customer Service

by Wayne Hill, Director of Client Services

As you know, here at Azteca we are always looking for ways to improve our customer service. We offer remote web support through GoToMeeting, phone and email support, remote interactive training, on-site training, and now we will be offering a new service, Cityworks Campus.

This new website will come online shortly and is designed to make it easier to find out information on Cityworks training courses. Users of this site will be able to search for specific courses, review a course overview, register for a class or multiple courses, and much, much

President’s Corner

more. Having Cityworks Campus will help make training easier for everyone.

Along with Cityworks Campus, we will be starting a new training course this spring called Cityworks Administration. This is a five-day course that walks the participants through the full creation of a Cityworks database. Here’s a brief overview of the course: Day One – Cityworks Database Implementation Day Two – Building Cityworks Asset Editing and Service Request

Capability in Designer Day Three – Work Order and Inspection/ Tests Implementation in Designer Day Four – Reporting in Cityworks and Crystal Reports Day Five – Cityworks Add-on Products (Call Center & Storeroom) along with Cityworks Anywhere This course will be available to clients and partners. The first offering of this seminar is March 6th – 10th. J

(cont. from page 2)

roll-out and implementation of Cityworks® Server (our Cityworks for ArcGIS® Server) at NYC Parks and elsewhere.

And, Azteca Systems is pleased to reaffirm that each of these products “co-exist” with Cityworks® Desktop (“co-exist” is how we refer to Cityworks applications that are complementary and work together against a common database). We hope all of you appreciate how important it is for Cityworks Desktop to “co-exist” with our new development. Just ask yourself, would your organization be impacted if ESRI did not assure that ArcMap and ArcGIS Server can share the same SDE database? Or, would it be a problem if ArcGIS Engine applications were not able to utilize the same MXD as ArcMap?

software vendors do not provide the assurance we take for granted from ESRI. Azteca Systems models our approach for software development after ESRI. We hope you all take this for granted, too. If so, it says something good about Azteca Systems.

Cityworks User Conference: We cannot adequately communicate how excited we are for our upcoming Cityworks User Conference.

Kaye and Janae, and all of our staff, are working hard to make this the best conference yet. Being with you for 3 or 4 days is the highlight of our work year for all of us at Azteca Systems. Cityworks Anywhere, Server, and enhancements to Desktop will be a focus for many workshops. The User Workshops

Cityworks Anywhere

The answer is obvious. Yet, many PAGE EIGHTEEN

our wonderful client sites who are willing to share their knowledge and experience. Time spent renewing friendships and acquaintances with fellow Cityworks users will be invaluable. And, to celebrate our 10th anniversary for offering Cityworks, there will be a special celebration party held on June 20th at the Utah Olympic Park in conjunction with the Cityworks User Conference. We have booked the aerial ski jump group the Flying Aces. We promise this will be a memorable evening for all in attendance. Start your plans now to attend the Cityworks User Conference, June 19-21, 2006, at the Park City Marriott, Park City, Utah.J

Cityworks Server

will be superb as always, thanks to

INPRINT / WINTER 2006

Waterford Township - Dig-Smart 1] Receiving and reading the requests 2] Figuring out where the requests were located and navigating to the correct location on the map 3] Moving the request ticket files (email) to a data warehouse location 4] Selecting the correct facilities (water and sanitary sewer mains and water leads) in Cityworks 5] Creating work orders and attaching the facilities and the request tickets to the work orders 6] Finally, generating maps to be taken out into the field.

To correct the problem, Dig-Smart utilizes the geodatabase to notify Cityworks when work orders need to be created. The data already exists in the Oracle database and the geocoding of each site is already complete. The dispatcher now has to perform one function; simply accept or reject the recommendation to generate a work order for each ticket. To help the dispatcher visual-

ize the excavation site, Dig-Smart displays a buffer around each site.

Furthermore, if utilities are located within the buffer, they are selected in order to further expedite the Cityworks work order creation process.

Once the site has been identified, the only step left is to populate the work order with the dig information and physically attach a map to each work order so that field teams will have reference data. Utilizing the export function in Dig-Smart, Waterford can easily create PDF’s for each excavation site. In order to complete the process, this PDF reference map will be directly linked to the work order in Cityworks as an attachment and stored in the attachment tab.

By utilizing the power of the geodatabase and a GIS-centric approach, Bergmann Associates and Azteca Systems are able to achieve the goals of the project set forth

by Waterford Township. In a single ArcMap user interface, dispatchers have at their disposal the full use of Cityworks and Dig-Smart. This simple structure allowed for the success experienced at Waterford.

Mr. Biederman adds, “Dig-Smart has automated nearly all the work and reduced the time needed to perform

Welcome New Cityworks Users! 

Brunswick, GA



Lake County Sanitation District, CA



Lima, OH



Lewisville, TX



Marco Island, FL



Miami Beach, FL



Norwalk, CT



Pittsfield Charter Township, MI



St. Johns County, FL



Terre Haute, IN

INPRINT / WINTER 2006

(cont. from page 5)

the task by 75%. We would like to applaud the efforts of the developers and implementers at Bergmann Associates and Azteca Systems for their work behind the scenes in making this idea a reality.”

For more information on Dig-Smart, please contact Jim Schoenberg of Bergmann Associates at 716-852-3211 x227. J

Event Calendar March 7-8: Indiana GIS, in Indianapolis, IN 19-22: AWWA IMTECH, in Portland, OR April 19: GIS Solutions Expo, in Denver, CO 23-26: GITA in Tampa, FL 24-27: URISA/MAGIC in Kansas City, MO 26-28: SERUG (Southeast Regional User Group Meeting) in Jacksonville, FL May 1-3: IMAGIN in Traverse City, MI 16-17: PAGIS in Camp Hill, PA June 11-15: AWWA ACE in San Antonio, TX 19-21: Cityworks UC06 in Park City, UT PAGE NINETEEN

TRAINING Cityworks Administration Course

ANNOUNCING...

A new course is available for both clients and business partners entitled Cityworks Administration. The duration of this training lasts 5 days and offers plenty of opportunity to become familiar with the core Cityworks and related software products. This course is very helpful for users configuring and administering Cityworks software. Below is a general list of the topics to be covered in the training. Please contact John Jarnagin (jjarnagin@azteca.com) 801.523.2751 for questions regarding this training course.

General topics covered in the course include: Day One Database Overview & Implementation Cityworks Software Install Overview Cityworks Designer Overview

Day Four Cityworks Add-on products (Call Center & Storeroom) and Cityworks Anywhere Reporting within Cityworks

Day Two Designer Configuration Asset Inventory and Editor Service Request Implementation

Day Five Reporting using the Cityworks table structure and Crystal Reports “How To Implement Cityworks” Overview

Day Three Work Order Implementation Inspections and Tests

Future Cityworks Training Courses (at Azteca headquarters in Sandy, UT unless otherwise specified) March 14th – 16th, 2006: Cityworks End-User Training May 8th - 12th, 2006: Cityworks Administration June 16th – 17th, 2006: Pre-Conference Training in Park City, UT September 12th – 14th, 2006: Cityworks End-User Training September 18th – 22nd, 2006: Cityworks Administration December 5th – 7th, 2006: Cityworks End-User Training December 11th – 15th, 2006: Cityworks Administration Remote Interactive Training (Over the Web) – Courses Available Cityworks Database Implementation – Oracle Cityworks Database Implementation – SQL Server Cityworks Designer Configuration Part I Cityworks Designer Configuration Part II Introduction to Cityworks ArcGIS Part I Introduction to Cityworks ArcGIS Part II Cityworks Reporting with Crystal Reports Configuring and Running Call Center Storeroom Visit MyCityworks.com for specific dates of each course PAGE TWENTY

INPRINT / WINTER 2006