InPrint Delivering Innovative GIS-Centric Maintenance Management Tools for Your Organization
Vol. 4, Issue 4, Fall 2005
FEATURE ARTICLE
SOFTWARE RELEASE
Portions of this article were published in Government Matters Magazine, ESRI-Fall 2005 edition, page 4, and is reprinted here with permission. Copyright© 2005, ESRI.
Newport’s Good News: The City of Newport News Public Works Department rolls-out GIS as central component for Enterprise Asset Management By Timothy J. DeSalvo, Information Technology Administrator, City of Newport News Public Works Department
The City of Newport News, Virginia, sits on a prime vantage point where the James River meets the Chesapeake Bay. The City runs approximately 25 miles along the James River and the Hampton Roads Harbor. Steeped in history, Newport News is a community of diverse trades including shipbuilding, technological research, and international commerce with a rich heritage, which dates back to the founding of America.
town only to encounter Captain Newport on the James River. With reinforcements of men and supplies, the colonists were prompted to return to Jamestown. The place where they encountered Captain Newport received the name “Newport’s Good News,” shortened to “Newport’s News,” and eventually just Newport News. Since the turn of the 19th century, Newport News has been known as the provider of the nation’s finest, technologically-advanced military ships. In more recent years, Newport News has also become a
Newport News was named for Christopher Newport, captain of the Susan Constant, the lead ship of the three-ship fleet that carried the Jamestown settlers to the new world in 1607. Captain Newport made several more trips between the new world and England. Disease, famine, and continuing attacks of neighboring Algonquians natives took a tremendous toll on the population. In 1610, the original colonists abandoned James-
INSIDE THIS ISSUE
2
President’s Corner
3
Timmons Partner News
Cityworks 4.3 By Wayne Hill, Director of Client Services
Azteca Systems is proud to announce the release of Cityworks 4.3 Desktop Edition. Here are a few highlights of the new functionality within Cityworks 4.3 Desktop Edition.
Database Manager • Improved Database Validation Database Manager now supports the validation of database indexes along with improvements to table structures. • Azteca.mdb DataPump Database Creation - Users can now create the DataPump database (Azteca. mdb) that is in sync with the table structure of their Cityworks server database.
Continued on page 19 Cont. page 19
8
2005 User Conference
12
Regional News
13 14 20
Project Management Update
Client Services Update
Training Schedule
......................................................................................................................................................................... INPRINT / FALL 2005
PAGE ONE
InPrint Editor in Chief: Tom Palizzi Editor: Kaye Ryser Graphic Designer: Kylir Horton 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.
PRESIDENT’S CORNER By Brian Haslam, President
Cityworks 10th Anniversary: This January Azteca Systems, Inc. is celebrating our 10th anniversary for developing and offering Cityworks® and our 20th anniversary as a business. All year we will be highlighting the anniversaries culminating with a special celebration party to be held on June 20th at the Utah Olympic Park in conjunction with our Cityworks User Conference. Start your plans now to join us on June 19-21, 2006, at the Park City Marriott, Park City, Utah. Expanded Office Space: I am pleased to announce that Azteca Systems® has expanded our Sandy office space. We now occupy all the space in our approximately 10,000-square-foot building that features 24 private offices, 3 dual offices, a 20-seat computer training room, a 10-seat conference room, meeting space, administrative offices, server and printer rooms, ADA approved, and other amenities to provide for our needs for the near future. The expansion of our office space at this time is a visible indicator of the broad acceptance of the Cityworks GIS-centric Asset Maintenance Management System.
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. 2005 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
Cityworks Desktop 4.3 Released: Azteca Systems recently released Cityworks Desktop 4.3 with many useful enhancements. Providing enhancements is important but our primary focus for 4.3 has been to release a quality product. Overall, feedback has been positive. I am very pleased with the quality of Cityworks Desktop 4.3 and the efforts of our staff. Even so, as we discover any issues, we provide a fix as quickly as possible. Contact Wayne Hill (whill@ azteca.com) to receive information on any available patches. Development Directions: Many of you are asking about Azteca Systems software development priorities for the future. There are two major ESRI® trends that significantly impact our development. First, for the past 10 years, Cityworks Desktop has been designed and created as an extension for ESRI’s Desktop GIS, most recently ArcGIS® 9.1 ArcMap®. For 9.1, ArcMap and ArcEngine® share a common ArcObject® Library. Because of a common ArcObject Library, Cityworks Desktop can be ported to ArcEngine. Azteca Systems is committed to supporting ArcEngine. Towards the end of 2005 or early in 2006, we will release a Cityworks Desktop that can be deployed with ArcEngine. Cityworks Call Center is a MapObjects® application. For embedded GIS, ESRI’s development resources are clearly flowing towards ArcEngine. For many reasons, it is best for Azteca Systems to prioritize our development resources to ESRI’s development priorities. We have had a lot of discussions about Cityworks Call Center regarding future enhancements. Azteca Systems has made a decision to move Call Center to an embedded ArcEngine application. We will continue to support Cityworks Call Center 4.3, but all enhancements for Call Center will be made to a future release that will have embedded ArcEngine Cont. page 19
INPRINT / FALL 2005
PARTNER NEWS Partner Directory Strategic Partners • • • • • • • • • • • •
CompassCom Coulter Mapping Solutions DHI Earth Touch Solutions ESRI Canada Laurel Hill Miner & Miner Motorola MWH Soft NovaLIS Technology Route Smart Tadpole Cartesia
Authorized Business Partners • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • •
Arcadis G&M Inc. ATS-Chester Engineers Bowne Management Systems CDM Civil Solutions Cobra Technologies Data Transfer Solutions, LLC EFM Group EMH&T Enterprise Information Solutions, Inc. IT Nexus Jones, Edmunds and Associates L. Robert Kimball & Associates Mactec Corporation Metric Engineering Municipal Information Systems North Arrow Technologies NTB Associates OHM, Inc. OneGIS PBS&J, Inc. Power Engineers, Inc. Psomas Schneider Corporation Short Elliott Hendrickson Strand Associates, Inc. Sunrise Engineering Timmons Group US Infrastructure Velocitie Integration, Inc. Vanasse, Hangen, Brustlin, Inc. (VHB) VESTRA Resources, Inc. Wade Trim Associates Westin Engineering Weston Solutions Woolpert
INPRINT / FALL 2005
Timmons-Azteca Profiles
Richmond, VA, DPW Implements Cityworks 4.3 By Todd F. Pulsifer, Timmons Group
The City of Richmond, VA, Department of Public Works is currently implementing Cityworks 4.3 and Storeroom to support their daily asset maintenance and management activities. The following departments within DPW will use Cityworks: Stormwater, Bridges, Urban Forestry, Streets, and Traffic. Richmond selected Azteca business partner, Timmons Group, headquartered in Richmond, VA, to provide full system design and implementation including workflow re-engineering, system configuration, custom application development, asset data capture, and enduser training. Timmons Group began the implementation process by conducting a series of workshops with DPW system users which focused on existing workflow analysis, existing data analysis, and customized asset data modeling. The workshops formed the foundation of a detailed implementation plan which specified how Cityworks would be configured for each of the five DPW sections, as each section had their own unique circumstances that needed to be accounted for during the implementation. For example, there are occasions when the various sections will perform work on another section’s assets, such as the Bridges section will fix
stormwater basins less than 2 feet deep. In addition, the Urban Forestry section currently utilizes an ArcPad solution for gathering tree information in the field. The data collected from that application needed to be identified during the workshops for inclusion in the asset data model.
In addition to the basic functionality provided by Cityworks, the City maintains legacy applications that needed to be considered during the implementation. Timmons Group developed a custom application that processes incoming service requests from the City’s web-based DB2 Citizen’s Request System and Cont. page 4 PAGE THREE
PARTNER NEWS - Timmons-Azteca Profiles
(cont.)
Richmond, VA - Cont. from page 3
creates a corresponding service request within the Cityworks system. As the work is documented within the Cityworks system, citizens are able to go online and see applicable updates. Additionally, the City maintains a Central Address Database. In order to ensure that all service requests are Central-Address compliant, Timmons Group developed an application that utilizes the geocoding functionality of the Cityworks incident address to retrieve and store the unique address ID (ADDRID) and validate the user-input address against the list of valid city addresses. The City undertook an address standardization process as part of their enterprise GIS implementation several years ago. The results of this effort have ensured that all address information captured and maintained by the various legacy and corporate applications are consistent and able to be used in a meaningful way to generate reports and perform analyses.
into the newly developed, custom data models for use with the Cityworks application. The custom data models, based on industry standards yet greatly enhanced to support many different analysis and reporting applications, provides a common starting point for the city to grow their asset inventory. TRANSMAP continues to deliver the remainder of the data collected for the entire city, which, upon delivery, will be processed by Timmons Group and incorporated into the asset geodatabase and linear reference system. J For more information on the City of Richmond, VA
visit www.ci.richmond.va.us
Town of Colonie, New York to Implement Cityworks By Kirk McClurkin, Timmons Group kirk.mcclurkin@timmons.com
To support the Cityworks implementation with the capture of DPW assets into the ArcGIS geodatabase, Timmons Group sub-contracted the services to our strategic business partner, TRANSMAP, Inc. TRANSMAP’s industryleading mobile image-based GPS asset collection vehicle and software provided the city a cost-effective, efficient method to develop an asset inventory and conditional assessment. Following is a list of assets captured in the first phase of this multi-phased asset collection effort: • Bridges • Crosswalks • Loop Detectors • Parking Meters • Pavement Markings • Railroad Crossings • Speed Humps • Traffic Signals • Signal Poles • Control Boxes • Parking Regulation • Traffic Control Signs Signs • One-Way Streets • Number of Lanes • Pavement Striping • School Zones • Speed Limit Zones • Sidewalks The data captured by TRANSMAP has been integrated PAGE FOUR
The Town of Colonie, New York, is in the final planning stages of an initiative to implement Cityworks® Desktop and Cityworks Call Center in their Department of Public Works in 2006. The Town of Colonie is known as a “Wonderful Place to Live” as one of the top 10 safest communities in the United States, for its quality of life, economic viability, and, last but not least, its location. Situated just outside the City of Albany, Colonie is truly close to everything—only 3 hours from Boston, 2 1/2 hours from New York City, 4 hours from Montreal, and 1 hour from the Adirondack Park. The Town of Colonie began development of its GIS in 1995 and has continually expanded GIS to support more efficient and cost-effective delivery of services to the community. The GIS-centric Cityworks solution was the obvious choice for a work order management system implementation.
INPRINT / FALL 2005
PARTNER NEWS - Timmons-Azteca Profiles The Department of Public Works (DPW) and the Management Information Systems (MIS) Department have undertaken this enterprise asset management project initiative to improve the daily operating efficiencies and increase the level of service to customers in conjunction with its current asset management practices. This project is aimed at enhancing the information system capabilities which will support the strategic maintenance of assets and associated public works best management practices. Another primary objective of this implementation is to provide a system with the wherewithal to meet the infrastructure reporting requirements of GASB 34 regardless of the accounting method. “We selected Timmons Group to support us on our Cityworks implementation because of their in-depth knowledge of the Cityworks solution, how the solution is applied to solve our real-world public works challenges, and the passion they display in understanding our issues and really genuinely wanting to help make our organization more successful,” says Rob Mateja, Town of Colonie GIS Coordinator.
(cont.)
technical and administrative issues associated with the implementation and ultimate deployment. DPW/MIS have targeted three divisions (Pure Water, Highways, and Water) within DPW to potentially participate in the initial system design, implementation, and training. Strategic decisions are currently being made on how to efficiently transition each department into the phased implementation approach. The Division of Pure Waters maintains and operates the sanitary sewer collection systems, including 400+ miles of pipe and 8,000+ manholes, and oversees the treatment of 3.5 million gallons per day of sanitary waste. The division also reviews and issues sanitary sewer connection permits for commercial and residential construction and inspects pipe installation. The Division of Latham Water provides safe drinking water and water for fire protection to 76,000 Town of Colonie residents, except for the Village of Menands and Maplewood areas. They are responsible for the treatment and distribution of water, installing and maintaining fire hydrants for fire protection, and maintaining water mains and valves. Currently they have more than 22,700 service connections. The Division of Highways is responsible for maintaining approximately 300 miles of town roads. These responsibilities include snow removal and ice control, paving and maintenance of roads, signage, roadway markings, drainage, tree and brush cutting and removal within the town’s right of way, and disposal of non-domestic dead animals. The Division is also responsible for the maintenance of approximately 35 miles of sidewalk.
Public Operations Center
Timmons Group was selected to partnership with DPW/ MIS on the Cityworks implementation. Over time, more and more of our clients rely on us to provide turn-key solutions to their increasingly complex asset management challenges. Working with DPW/MIS, we developed a well-planned implementation strategy based on a phased approach that encourages accountability, system ownership, and flexibility. One of the major tasks will be to explore and analyze the various technological, operational, and organizational elements of DPW’s business for the purpose of ensuring the planned Cityworks implementation and expected system is capable of delivering the feature-rich data needed to support the numerous complex operations and maintenance activities undertaken by the various divisions. In addition, it will help define the overall vision, verify standards and procedures, and identify
INPRINT / FALL 2005
Timmons Group and the Town of Colonie, working as a partnership, will navigate both organizational and technological encumbrances that are inherent to implementations of this nature so that the benefits of the asset management system can be measurable and have an immediate impact on the daily operations of the participating divisions. As stated by Rob Mateja, Colonie’s GIS Coordinator, “We are looking forward to the inclusion of Cityworks to leverage our investment in GIS and add a new dimension to our asset management initiatives.” J For more information on the Town of Colonie, NY visit www.colonie.com/new/gis.htm Timmons Group - Contact us at: ed.singer@timmons.com or 804.521.1065 to find out how we can assist you.
PAGE FIVE
PARTNER NEWS - Timmons
(cont.)
A LOOK INTO ENTERPRISE ASSET MANAGEMENT PROGRAMS By Edward A. Singer, PE, Timmons Group
Everyone reading this article has at least one thing in common—at some level we are all responsible for the planning, design, construction, operation, and maintenance of some form of assets, whether it be a water main, sewer lateral, natural gas regulator, pavement section, catch basin, sidewalk, cable television service, or similar “physical” assets that provide service to our customers and economic benefit to our particular organizations. Additionally, given our responsibilities for the maintenance and management of assets, we each have our own ideas of what an asset management program is as it relates to our respective organizations. Over the past several years, Public Utilities, Works, and Local Govern-
nently and successfully implementing a wide array of Information Systems solutions focused on improving a variety of business processes including regulatory compliance, customer service, financial stewardship, human resources management, supply chain management, contractor management, engineering planning and design, operations and maintenance, and facilities mapping. Through the implementation of these various “vertical” systems, many divisional or departmental asset management challenges have been effectively managed. However, very little, if any, attention has been placed on the integration of these applications with other corporate business solutions and data sets that would be typical of a true enterprise solution.
Without delving into the technicalities of the various application, and data types, this article will present an overarching view of an Enterprise Asset Management Program (EAM)—one that integrates all of these “vertical” systems and effectively brings each to bear in conjunction with the others, to solve complex operational challenges by helping balance capital and maintenance investments, support the executive leadership of an organization in their fiduciary management, and provide visibility into the many varied business processes. ENTERPRISE ASSET MANAGEMENT DEFINED As defined in this article, enterprise asset management is a series of inter-related business processes
ment SIX agencies have been promiPAGE
through which organizations strive INPRINT / FALL 2005
PARTNER NEWS - Timmons
(cont.)
to maximize the useful lives of their assets, while at the same time minimizing the total cost of ownership and mitigating the risks associated with asset failures. To achieve these goals, a number of very specific and varied business objectives such as planning, engineering, mapping, operations, accounting, customer service, human resources, contract management, etc. must be strategically aligned, integrated, and proactively managed. Thus, a properly designed and implemented EAM program draws upon a vast array of corporate applications and
tional condition. Thus, an effectively implemented and managed EAM is centered upon the systematic analysis of asset needs and the recommended allocations of the resources required to economically maintain the assets throughout all phases of the asset life-cycle, as illustrated in the diagram below. The ability to achieve and maintain economic soundness in the operation and maintenance of assets is more important today than at any time previously in the industry in the face of decreasing capital funding, increasing customer demands, ag-
• Metrics – accurate and up-to-date operational details on the organization’s key performance indicators (KPIs) delivered in a user-friendly format to support quick and proactive organizational decisions. • Business Intelligence (BI) – core business applications employed to capture, track, analyze, manage, and report information drawn from various sources (operational, financial, customer service, supply chain, etc.). Robust BI applications enable decision makers to stay informed of operational conditions and drill into the data to fully understand the re-
data sets to combine and synchronize the financial, management, engineering, and operational perspectives of the enterprise within the overall asset management process. The graphic on page 6 illustrates the various business processes that would be inclusive of an EAM program at a typical utility.
ing work forces, and assets rapidly nearing the end of their useful lives.
lationships and root causes of asset conditions and performance. • Methodology – a systematic, repeatable, and sustainable means of consuming the BI data such that improvements to asset performance can be identified and applied top-down in a structured manner throughout the organization. The methodology is what enables management to align planning and execution, strategy and tactics, and divisional and corporate objectives. With each of these three components in place, and a top-down commitment to enterprise asset management, business decisions become proactive, predictive, and precise.
When viewed across the Enterprise, asset management solutions support the adoption of a comprehensive view of the organization’s physical assets and their related life-cycle activities (planning, design, construction, operations, maintenance, renewal, and abandonment). The totality of an asset’s life-cycle often extends well beyond a fifty-year period, during which time a significant number of man hours and capital dollars must be invested to maintain the assets in a minimum acceptable opera-
INPRINT / FALL 2005
While an EAM depends upon the latest information technology offerings (mobile applications, CMMS, GIS, ERP, CRS, etc.), it represents more than the introduction of software applications or the integration of existing (or legacy) business solutions. Instead, EAM is an overarching business process that leverages each of these systems in combination with engineering principles, economic methods, and sound business processes to seek and deliver economic efficiency and cost-effective outcomes. In other words, EAM seeks to make the best use of existing processes and tools and build upon them, rather than duplicate them. An effective EAM is comprised of three fundamental components:
GIS-CENTRIC ASSET MANAGEMENT Asset management applications are classified as either GIS-centric Cont. page 15 PAGE SEVEN
2005 Cityworks Roundup! Conference ReCap by Tom Palizzi, Director Sales & Marketing
The 2005 Cityworks User Conference was a tremendous success. With more than 210 people in attendance, it marked another strong turnout, growing by nearly 50% over last year’s event – a trend since our first meeting in 2001. Brian Haslam, President of Azteca Systems, kicked off the conference in the plenary session on Monday, June 26, with his annual Report to the Users. In his address he stated that customer count surged again in 2004 and is on track for another strong growth year in 2005. He illustrated Azteca’s continued growth in revenue since 2000 to assure users the company is healthy, viable, and growing at a strong pace. All the while, Azteca continues to maintain a conservative posture to support sensible
growth. Mr. Haslam spoke highly of the work Azteca’s Authorized Business Partner network has achieved, implementing nearly 80% of all Cityworks projects in 2004. He reviewed an impressive list of new client sites including Baltimore MD, PAGE EIGHT
El Paso TX, Douglas County NE, Hamilton OH, Fort Collins CO, and Citrus Heights, CA. Cityworks was also deployed at Stockholm Water Company, Sweden, and in Essex County, Ontario, Canada in 2004. Azteca continues to grow in the U.S. and internationally, adding ESRI Sweden (MELDIS) and ESRI Israel (Systematics) to the list of International Distribution partners. In 2004, the National Association of GIS-Centric Software was formed by several GIS-based firms including NovaLIS, Miner & Miner, Routesmart, Tadpole Technologies, and Azteca Systems. Cityworks became the first NAGCS-certified application, firmly planting itself as the first, and still the only, GIScentric asset maintenance management system. In February of this year, ESRI honored Azteca Systems again as Foundation Partner of the Year. The only 2-time winner of this prestigious award, Azteca Systems was selected based on our unique and dedicated relationship with ESRI. With an entire product based on ESRI’s leading GIS technology, Cityworks continues to thrive with new and innovative capabilities. Brian shared his continued dedication to customer service, noting that Azteca listens to our customers to help us define the direction of Cityworks and better serve our users. He reviewed a number of
Brian Haslam, President
enhancements to our technical support and customer care including upgrades to Cityworks Database Manager, improved documentation, the introduction of the Cityworks Knowledgebase at mycityworks. com, and Azteca’s remote implementation program. Azteca now offers remote training and a user’s forum at mycityworks.com. Wayne Hill and Paul Thomas demonstrated a “GoToMeeting” offered through Citrix, showing the features of Azteca’s remote interactive support. Using this new technology allows the client and support reps to interact together on their own computers, viewing and sharing the same screen. Turning his attention to Cityworks, he reviewed the status of the product line-up. Cityworks 4.3 would be released in July 2005, followed closely by a new and exciting deployment option using ESRI’s ArcGIS Engine. Cityworks
INPRINT / FALL 2005
will be available in multiple deployment options including the current ArcMap Extension and Standalone options plus a new, embedded GIS option via ArcGIS Engine, offering users a less expensive option to ArcView or ArcEditor. ArcGIS Engine options enable map view and attribute editing capabilities without the overhead of the more sophisticated ArcMap functionality. He also spoke about Cityworks Server, the web-deployable version due out in early 2006.
working together against the same database. Users were happy to know Azteca would offer an array of options rather than an all-ornothing migration choice. Carl Horton, Director of Product Development with Ryan Miller, Senior Developer, and George Mastakas, Director of Professional Services, reviewed the products in a lively demonstration.
dated when a work order or service request is created and how asset data is printed within the ArcGIS environment. Cityworks Toolkit – An overview of the new collection of tools now available to help implement, maintain, and update Cityworks databases.
Monday’s opening session was followed by a series of breakout sessions that included technical, industry-focused, and user-case studies. Adding a fifth track, allowed for more than 25 technical/ industry sessions and 20 user-case studies. Feature Sessions:
Carl Horton, Software Development Director
Following Brian’s report, the audience was taken on a virtual tour of the complete Cityworks product line-up – from the new Cityworks Desktop 4.3 to Server. Most impressive, the products were shown
Meeting Regulatory Requirements for Water & Wastewater – This session was among the wellattended, industry-specific workshops. It reviewed how Cityworks can be applied to manage the variety of regulatory requirements facing the water and wastewater utilities industry, including CMOM, CSO’s, and related requirements. Cityworks: Behind the Scenes - This course offered an in-depth look at how Cityworks manages data, such as what tables are up-
Asset Data Modeling – A twopart session for new and advanced users, this session reviewed the capabilities of data modeling in ESRI’s geodatabase and how Cityworks and GIS can be applied to virtually any asset of interest. Mobile Solutions - An overview of the various field options available with Cityworks, including DataPump and wireless alternatives, this session featured real deployment options and a live wireless demonstration from Waterbury Township, Michigan. Cityworks Case Studies – Each case study proved to be interesting and helpful illustrating how these sites deployed Cityworks and how the system is used today, and how they look to grow throughout their organizations. Many sites have already expanded from the original implementation to include other departments. J
Celebrating 10 Years of June 19-21, 2006
User Conference Park City Marriott Hotel INPRINT / FALL 2005
June 16-17 , 2006 Pre-Conference Training Park City Marriott Hotel Mark your calendar now! PAGE NINE
Cityworks
2005 User C June 27 Park Cit
Olympic Park Tour
Pre-Conference Activities...Workshops A great time w
Workshops Vendor Fair & Chuck Wagon Social
Lunch Break!
Doctor’s Office
PAGE TEN
INPRINT / FALL 2005
s Roundup
Conference! - 29, 2005 ty, Utah
s...Exhibitors...Doctor’s Office...Banquets was had by all!
Wild West Fest! Native American Dancers
Aztaco Chief Here’s Trouble!
Best Dressed!
Good Grub!
Bar G Wranglers
Aztacos INPRINT / FALL 2005
Sara Cobb of Edmond, OK, mingling with the locals!
The Good, The Bad & The Ugly! PAGE ELEVEN
REGIONAL NEWS Marketing & Sales Director Tom Palizzi
AZTECA SALES REGIONS - 2005
303-467-2738 tpalizzi@azteca.com
Azteca continues to grow in 2005 with more and more new customers and expanding implementations in our existing customer base. Pleased to be working with each of our customers, we continue to invest in the best technical support and improve and expand our products. I’m happy to report we now have more than 230 client sites – most in the United States with a growing presence in Canada and other international markets. Please know, we continue to take steps to keep our customer service at the high level you’ve come to expect and, of course, improve Cityworks to better meet your needs. On the marketing front, we’ve expanded our presence at several national industry shows and try to be at as many regional events as possible. Our primary focus though is still your satisfaction and productivity. We continually help customers set up local and regional user groups where folks meet periodically to discuss implementation options and exchange data models and ideas on how to get the most from Cityworks. In addition to these events, watch for our co-hosted ESRI/Azteca seminars near you. InPrint is one example of how we try to communicate with you and others interested in Cityworks. Be sure to visit our web page – www.azteca.com – and MyCityworks.com for up-todate information on events, products, and news. Over the past several months, we’ve developed a series of Cityworks Spotlight articles highlighting client sites. Many of these are also published in ArcNews, APWA Reporter, and other industry magazines. Watch out – your name will be in lights soon! Thanks for your continued confidence and support! J PAGE TWELVE
Southbend Northeast
Salt Lake City Western
Pacific Region David Horton
801-523-2751 dhorton@azteca.com
It has been a busy quarter in the Western Region. It was great getting to meet many of you at the annual Cityworks User Conference in June and the ESRI User Conference in July. I’d like to add a special welcome to our newest Western regional clients: • Willamalane Park & Recreation District, Springfield, OR • City of San Mateo, CA Wastewater Treatment • City of San Mateo, CA - Facilities Maintenance Mark your calendars and drop by and visit at the following events to catch up and see what’s new in Cityworks: • GIS Solutions Expo 10/18 Las Vegas, NV • GIS Solutions Expo 10/25 Anaheim, CA • 2005 AGIC Conference 10/26 – 10/28 Prescott, AZ • ESRI Utilities Seminar 11/1 Pasadena, CA • GIS Solutions Expo 11/2 Sacramento, CA • ESRI Utilities Seminar 11/3 San Francisco, CA • ESRI Utilities Seminar 11/8 Las Vegas, NV J
Dallas Central
Augusta Southeast
Southeast Region Jen Hernandez 706-364-8812 jhernandez@azteca.com
The summer is almost over and it’s time for our fall update. Katrina hit the Gulf Coast pretty hard this year between New Orleans, LA, and Gulfport, MS. Our thoughts go out to all of the families who have been troubled by this hurricane. Please join me in welcoming Cocoa Beach, FL, to the family of Cityworks users. Clayton County, GA, has grown their use of Cityworks by expanding their install base. It was great to see those of you who made it to the Azteca User Conference in Park City, UT, and the ESRI User Conference in San Diego, CA. If anyone is interested in hosting the next Southeast Cityworks User Group in your area, please let me know. It is a great chance to get together and see how other Cityworks users are using the software. J Anyone interested in advertising or contributing to this publication, please contact: Tom Palizzi (801-523-2751)
INPRINT / FALL 2005
REGIONAL NEWS
(cont.)
Central Region Brent Wilson
214-507-0579 bwilson@azteca.com
State of the Region… Azteca has, and still is, participating in the many conferences that are left this year and I hope to see you all there. What’s happening in the Central Region…? • Irving, TX, is deploying Cityworks throughout the city via a contract with Motorola. • Hot Springs, AR, is expanding Cityworks into all of their Public Works Departments with the help of Varion Systems. • Oklahoma City, OK, is finished implementing the Public Works Department and are about to start implementing the Parks Department. The city currently uses Cityworks in the Water, Sewer, Airport, and Public Works Departments. • Iberville Parish, LA, has selected Cityworks for their CMMS. • Coon Rapids, MN, has expanded Cityworks. • Burleson, TX, plans to deploy MicroPAVER. • O’Fallon, IL, plans to deploy the new PACP-compliant TV inspection interface. • Edina, MN, has deployed Cityworks with SEH. • West Bend, WI, has expanded their deployment. • Naperville, IL, just went through a huge integration and upgrade with Woolpert.
The user group meeting in Frisco, TX, was a huge success and I would like to thank the City of Frisco for hosting the meeting. We had 30-35 clients in attendance which is almost double the meeting in 2003. We will be hosting another meeting in the northern part of the region this October and looking to have one in the mountain part of the region this winter. J
Northeast Region Becky Tamashasky
574-231-8029 btamashasky@azteca.com
The Northeast Region has been very active following the Cityworks User Conference. Several new clients have joined recently. Be sure to check out the New Client Welcome section. Also, to all of the clients who have hosted visits from potential clients recently—thank you for all of your help and support! Plan ahead for the upcoming Michigan/Ohio Cityworks User Group Meeting in Ann Arbor, MI, on October 19th. If anyone is interested in developing a user group in your region and would like to host it at your organization, please let me know. There are also several conferences coming up for the Northeast. Please take a look at the Conference Calendar and plan to find the Cityworks booth at the conference in your area. Hope to see you there! J
AZTECA NEWS Azteca Welcomes New Customer Support Representative... John Jarnagin joined Azteca Systems in August 2005 as our newest Customer Support Representative over the Western region. John is a graduate of Utah State University in geography with an emphasis in GIS. Previously he worked at VESTRA Resources, Inc. working with Mobile GIS/GPS technology and Trimble Mapping/GIS.
INPRINT / FALL 2005
John is married with 4 children (and a girl, due in November). He resides in Lehi, Utah. Interesting Fact: “Are you Andre Agassi?” John has been asked that question in restaurants, airports, on airplanes, and other public places. In a restaurant, a waiter actually came up to him at the request of some other patrons to confirm that he was/was not the famous tennis player. J
PROJECT MANAGEMENT UPDATE Integration of Cityworks and Miner & Miner Product Suite a Success! By Steve Thomas, Project Manager, Azteca Systems, Inc.
Many sites have expressed an interest for integrating Cityworks® Asset and Maintenance Management System (AMMS) and Miner & Miner’s product suite. Cityworks has been successfully integrated with two of Miner and Miner’s applications, Arc Facilities Manager (ArcFM™) and Designer. Not only do both Azteca’s and Miner & Miner’s applications utilize the geodatabase as a central component, but they are both also certified by the National Association of GIS-Centric Software (NAGCS). These two facts make integrating the companies’ software applications inherently simple. Both Cityworks and ArcFM are powerful extensions of ESRI®’s ArcGIS™ platform. ArcFM consists of a family of models and a set of sophisticated tools that provide a comprehensive application for energy and water/wastewater utilities. ArcFM allows for maintenance and viewing of data, using company-specific business rules, and includes applications to configure the data models and tools to work together. ArcFM takes advantage of industry-standard architecture and programming environments. Created especially for Public Works and Utilities organizations, Cityworks is uniquely designed to fully leverage your investment in GIS without costly duplication of GIS data. Cityworks utilizes the geodatabase as its asset database and requires an asset identifier that the Cityworks software recognizes. Cont. page 14 PAGE THIRTEEN
CLIENT SERVICES UPDATE What’s going on in Customer Service by Wayne Hill, Director of Client Services
As many of you know, Azteca purchased GoToMeeting from Citrix technologies this past winter. GoToMeeting is an Internet-hosting solution that allows multiple computers to access information at the same time via the web. Using this advanced technology, Azteca has been able to improve our support services and increase the time our employees are in the office available to all of our clients. Now if a question or problem arises, we can quickly log into GoToMeeting (www.GoToMeeting.com) and set up a session. Once the session is started, we email you an invitation to the meeting. With both computers connected, one acting as the hosting server, interaction is
possible between the client’s and the support manager’s computers. This gives us the capability to view client’s computers and even take control of your computer when you give us access rights. Using GoToMeeting for support has increased problem resolution dramatically. Now instead of our support managers saying “When do you get this error?” or “You should see a pulldown menu called Supervisor,” our managers can see Cityworks running on your computer while seated in front of their own computer. This technology has opened up the door for more than just support. Now we offer remote implemen-
PROJECT MANAGEMENT UPDATE
(cont)
The name of that identifier for all objects that will have work orders tracked against them is “AssetID”. Alternatively, you could use “FacilityID” for feature classes or “EquipmentID” for tables (nonspatial objects).
on the asset list of the work order to provide additional information about where the asset is located. This could be populated with an address, or a descriptive location such as 20 meters west of the hydrant at 939 San Pedro Way. • Condition - This field is utilized by Cityworks Performance for GASB to calculate the current value of assets, based on the current asset condition value. This value can also be updated through the use of some of the Cityworks Inspection forms. • ConditionDate - Stores the date that the asset condition was calculated. It is populated and utilized the same as Condition. • InstallDate, ConstructionDate or some similar build date - This date is also utilized by Performance for GASB, but must be populated manually in the GIS. • LegacyID can also be added if the client has an identifier that is utilized in other systems that they want displayed on the work order asset list.
No matter which asset data model might be implemented at a client site (CityworksFM models, Miner & Miner models, or user-defined models), by adding this identifier to the objects within that model, Cityworks can be used to track work activities for those assets. Some joint Cityworks and ArcFM implementations have utilized a custom ArcFM Autoupdater to automatically populate this identifier. Other fields, some of which could also have ArcFM Autoupdaters, could be added to take advantage of some built-in Cityworks functionality. They are as follows: • WarrantyDate - This can be used by Cityworks to identify those assets that are still under warranty when new work orders are being created. • Location - This field is displayed PAGE FOURTEEN
By integrating Cityworks and ArcFM, assets can easily be added to the
tation services and remote interactive training seminars. Remote implementation reduces the cost to implement Cityworks since there aren’t any travel expenses involved with the implementation and the focus is on teaching you, the client, how to implement Cityworks. Remote interactive training takes the travel costs out of the equation and reduces our time away from the office. All of these services help our support team achieve the goal of making our client support the best available on the market. J
asset geodatabase and work orders immediately issued against them. The ArcFM autoupdaters make populating the asset properties simple and straightforward. Azteca and Miner & Miner have also cooperated for integrating Miner & Miner’s Designer application with Cityworks. Designer provides an integrated design solution for utilities of any size through an intuitive graphical user interface. Building on the ArcGIS architecture, Designer is an integrated design solution that minimizes data redundancy, improves the accuracy and consistency of corporate data assets, and offers a range of functionality to support the diverse needs within a utility. Designer can be deployed for mobile use to allow designs and as-built drawings to be done in the field and incorporated into an overall workflow. As an open, fully-scalable solution, Designer provides the utility user with facility editing, work sketch, posting, plotting, and engineering calculation tools. Cont. page 20
INPRINT / FALL 2005
PARTNER NEWS - Timmons Cont. from page 7
or nonGIS-centric. NonGIS-centric solutions are typified by stand-alone proprietary applications that leverage vendor-specific data models and require custom programming and extensive vendor support to make modifications to the systems. Additionally, integration of nonGIS-centric applications into a true enterprise environment requires the use of duplicative data sets (assets defined and maintained separately within each of the proprietary applications) and the sharing of data between the different applications mandates the use of proprietary middleware and synchronization applications. While many nonGIScentric applications provide GIS interfaces, these are primarily for map visualization purposes only and do not support any substantial form of spatial analyses of the assets. GIS-centric asset management applications leverage the inherent value of an organization’s GIS to effectively and efficiently manage the assets based on their spatial locations and relationships. In a GIS-centric asset management application, the GIS database is the asset database. The assets are modeled in the geodatabase and all of their physical characteristics (size, material, age, etc.) and geometric relationships are managed through a series of open-architecture data models that are editable directly in the GIS without the need for proprietary middleware applications. As such, all of the various open-architecture enterprise applications that collectively comprise the asset management program can be interfaced with one another and share the same asset data repository that resides within the GIS. This approach offers a wide range of benefits in the pursuit of an EAM program including: • The GIS database serves as the asset database for all enterprise asset management applications. • Use of the GIS database ensures non-redundant asset feature data editing and storage. • The GIS asset feature data model is fully user-definable and customizable without vendor support of proprietary data structures (geometry, field names, data types, feature
INPRINT / FALL 2005
relationships). • Full interoperability among all asset management applications ensures concurrent use of the asset feature database. • Asset definitions and spatial locations are inherent and maintained entirely within the asset feature data model, thus enabling full utilization of the spatial analysis and data management capabilities of the GIS software (linear referencing, buffering, spatial overlays, etc.). • Asset feature data is created and maintained using the GIS toolsets (capture, edit, network tracing, routing, connectivity, etc.). Thus, a GIS-centric EAM program employs the enterprise GIS as the data repository for all asset features and uses the various Business Intelligence (BI) or asset management applications (CMMS, accounting, outage management, network analysis, etc.) to maintain, analyze, and report on the business data related to each of the assets (work performed, unit costs, account history, etc.). Further, a GIS-centric EAM program fully supports the development of thematic maps depicting a virtually endless combination of the operational data and metrics maintained within the BI applications. The graphic on the following page presents a high-level view of a GIS-centric EAM program system architecture that leverages all of an organization’s existing data and business application resources and provides on-demand access of each to a wide cross-section of employees tasked with asset management responsibilities. EAM BENEFITS Organizations embarking upon an EAM program implementation stand to realize significant organizationwide benefits. The development and deployment of GIS-centric EAM solutions that re-engineer ineffective business processes, help answer organizational and asset performance questions, and solve problems, and generally make mission-critical data more accurate, upto-date, and readily accessible will improve operating efficiencies while at the same time decreasing annual planning, engineering, and operations and maintenance costs.
(cont.)
Different EAM applications yield varying rates of return, and it is common for an organization to seek out the “killer app,” or the one that provides the largest return in the shortest time, to justify significant program expenditures. There are many documented examples that can be used to illustrate how GIScentric business processes yield enormous benefits (cost savings, increased productivity, automation of business processes, reduction of duplicative efforts, etc.). However, the most significant and sustaining returns on investment are realized through organization-wide adoption, use, and support of the applications. The business case for an EAM program is best made by aligning the overreaching benefits to the organization’s stated business goals and objectives. Some benefits of a GIS-centric EAM program are more quantifiable than others. Further, benefits are often valued differently by each user group within the organization. For example, increased revenues are generally more important to the finance department than savings in time, and increased efficiencies are more important to the engineering department than are increased revenues. In this regard, a successful EAM program implementation—one that provides adequate returns on investment across multiple user groups while delivering the tools needed to efficiently meet the overriding business needs – must seek to balance competing goals and objectives across the organization while focusing on those applications that deliver the greatest benefit to the greatest number of users. A best-practices analysis that defines the stretch goals of the organization’s planned EAM program and contrasts them against the current position in each program area will help derive both the implementation costs, as well as the program-wide benefits that the EAM should be expected to deliver. The following listing of best-practice objectives should be reviewed and analyzed specific to the implementing organization. This is a broad listing Cont. page 16 PAGE FIFTEEN
PARTNER NEWS - Timmons
(cont.)
Cont. from page 15
of the components comprising an EAM program and can be tailored to meet a particular organization’s specific goals and objectives. • Data – base map (or landbase), asset feature locations and descriptions, currency of asset feature data, spatial accuracy of asset feature data, digital data sets, standard corporate data models • Technology tools – desktop PCs, application and data servers, handheld devices, mobile data terminals, wireless networks, backup and recovery tools and processes • Geospatial applications – asset feature data maintenance, maps and views, operations and maintenance, engineering work order, field automation, miscellaneous GIS applications • Legacy or Enterprise Business Intelligence (BI) Applications – automated meter reading, SCADA or related system monitoring and PAGE SIXTEEN
automation, financial reporting, forecasting and planning, human resources and payroll, customer information systems, document management, workflow automation, laboratory information systems, inventory control, network analysis modeling, asset and work order management, outage management, computer-aided crew dispatch • Compliance measures – EPA, DOT, SCC, GASB34, DEQ, USCOE, etc. • Disaster preparedness and emergency response • Succession planning and knowledge transfer • Performance measures and HR systems • Executive decisioning tools Without a comprehensive understanding of an organization’s existing business processes and delivery methods, it is impossible to compile an accurate listing of quantitative
benefits that an EAM program will deliver. However, the following listing of qualitative benefits is rather compelling and should be encouraging to those organizations considering the move to a GIS-centric EAM program: • Improved planning, programming and monitoring of assets ©Strategic view of assets ©Performance-based planning and prioritization ©Executive-level program review ©Proactive risk management and reduction • Better and more timely information and analytic capabilities • Development and monitoring of enterprise operational strategies • Institutionalizing asset management across the enterprise—best practices • Compliance with mandatory reporting (GASB, CMOM, EPA, etc.)
INPRINT / FALL 2005
PARTNER NEWS - Timmons EAM IMPLEMENTATION CHALLENGES While the benefits of an EAM program are significant, they are difficult, if not impossible, to realize if the numerous organizational and technical challenges are not appropriately identified and effectively managed throughout the implementation process. • Organizational Challenges ©Integrating decision-making and resource allocation across all asset classes. ©Combining the financial, management engineering and operational perspectives of the enterprise within the decision process. ©Defining system performance measures that effectively reflect stakeholder costs and demands for service. ©Securing and maintaining senior management support throughout the implementation period—several years. • Technical Challenges ©Integrating legacy systems or stand-alone databases established for individual asset classes or functions. ©Developing comprehensive, spatially-enabled, enterprise databases to better support integrated asset management. ©Improving life-cycle analysis methods and fully incorporating them within the enterprise planning and program development functions. ©Strengthening system monitoring capabilities and utilizing this information for program evaluation and policy formulation. CONCLUSIONS A number of keys to a successful EAM program development and implementation can be summarized as follows: • Insure that senior leadership applies top-down pressure – set expectations and integrate them within the corporate culture. • Create cross-functional project teams. • Make an honest assessment of existing operational challenges. • Create a flexible, long-term enterprise plan with achievable interim milestones. • Perform detailed post-implemen-
INPRINT / FALL 2005
tation reviews. • Celebrate successes and learn from mistakes. • Develop and aggressively administer a change-management program. • Do not waiver on any of the above. Over the course of many years designing and implementing enterprise-level information system solutions for a wide array of Public Utility and Public Works agencies, we have learned that most organizations approach these engagements as they would any typical engineering project—define an operational challenge and build a system from the ground up to solve this particular challenge. While this approach may result in a technically-sound solution that can be effectively designed and implemented given today’s available technologies, it fails to address the numerous real organizational and political challenges that will arise and impede the successful deployment and organization-wide adoption of a true enterprise system. For this reason, we seek to implement an EAM from the top-down as opposed to the traditional ground-up approach. As is evidenced above, an EAM program is more than an array of business processes and solutions targeted to improved asset management activities. An Enterprise Asset Management Program is, in most instances, typified by a radical culture change within the implementing organization. By tackling the management and organizational behavior aspects of the program early and often throughout the implementation, through top-down pressure applied by senior management, in conjunction with a proactive change management program, the chances of delivering a successful EAM program increase significantly. ABOUT TIMMONS GROUP As an award-winning, industryleading, geospatial consultant and Azteca Systems authorized business partner, Timmons Group goes to great lengths to stay abreast of the ever-changing and increasingly complex information technologies needed to design, build, implement, and maintain the GIS-centric Enterprise Asset Management solutions required to solve our clients’
(cont.)
varied challenges. Our Infrastructure Solutions Group combines the planning, engineering, financial, and technological expertise required to solve complex asset management challenges for our water, wastewater, stormwater, gas, electric, and public works clients. From our GIS Technicians all the way up through our Database Managers, Programmers, Systems Engineers, Consultants, and Project Managers, our staff prides itself on our unique ability to grasp your vision and then work with you to deliver a solution tailored to your individual business requirements. While we offer all of the traditional consulting, implementation, data development, training, and maintenance services typically associated with a geographic information system project, our subject-matter expertise enables us to move our clients beyond these traditional desktop projects with solutions that extend across the enterprise to deliver results that can be measured in time, money, and improved levels of service. Engaging Timmons Group as a partner on your infrastructure management programs will yield the results you demand. Many years of important lessons learned will be available to you and your stakeholders throughout the life of your program. You will have the opportunity to work with our planning, engineering, geospatial, and technology subject-matter experts who will share over a century of combined ideas and solutions with you in support of your greater mission. This group, who has established themselves as some of the industry’s most sought after consultants, is excited about working side-by-side with you and your staff to develop a technological legacy that you, your organization, and all of your stakeholders will be proud of. J Contact us at ed.singer@timmons.com or 804.521.1065 to find out how we can assist you.
PAGE SEVENTEEN
FEATURE ARTICLE
(cont. from page 1)
center for international commerce, research, and technology. The local economy is strengthened by a strong military presence throughout Hampton Roads. The City’s historic sites, museums, and cultural facilities compliment the quality of life for Newport News residents and businesses. Newport News Park, the largest municipal park east of the Mississippi River, has 8,000 acres. The Public Works Department for the City of Newport News is tasked by the community to maintain and manage the majority of the public’s infrastructure assets. This includes providing a reliable transportation system, protecting the environment through the management and operation of the sanitary and storm sewer systems, promoting environmentally-responsible disposal of solid waste, to maintain community health and safety standards, and to provide for the efficient and effective maintenance of the City’s Public Buildings. Public Works strives to be a responsible steward of the public funds provided for maintaining and managing public infrastructure assets.
the first 5 months of 2004. Known as PIMS (Public Works Infrastructure Management System), the new system includes interfaces with other legacy systems, such as the City’s Financial Accounting, Human Resources, Purchasing, and the Public Works Department’s existing installation of the American Public Works Association’s (APWA) standard, “MicroPAVER” pavement management systems. To achieve efficient and effective legacy system replacement, other legacy systems integration, and to provide for GASB-34 compliance, the Public Works Department reviewed many Computerized Maintenance Management Systems (CMMS). Basic CMMS functionality remained fairly consistant from system to system. Yet, how the CMMS utilized GIS as a design element varied greatly. The most mportant determinate for the Public Works Department was to leverage as much as possible its existing GIS investment by utilizing ESRI GIS to manage infrastructure assets.
After completing a thorough evaluation of commercial-off-the-shelf (COTS) CMMS, Public Works selected the WoolMap compliments of Mapquest.com pert and Azteca Systems team to To meet these challenges with techdeliver the Cityworks CMMS. Public nology commensurate with the 21st Works determined that all CMMS, Century and to provide for federal with the notable exception of Cityreporting requirements, the Public works, are designed as standalone Works department began an initiasystems and are then externally tive to replace its existing legacy interfaced to GIS. Only Cityworks mainframe system during 2003 and PAGE EIGHTEEN
has been designed to maximize the GIS for the managing of infrastructure assets. Nowhere is this more evident than in examining how Cityworks utilizes the GIS “as is” as the infrastructure asset database with no constraints or need for managing redundant asset tables.
Kirk McClurkin (formerly with Woolpert & now with Timmons Group) was the Project Manager overseeing the implementation of Cityworks for the City of Newport News Public Works Department. The project approach was to perform a phased implementation of stormwater, wastewater, streets, and pavement. Phase 1 involved conducting a series of strategic workshops to determine system requirements to support functional, business, and end-user requirements which included system functionality, GIS geodatabase design, Public Works operational and maintenance workflows, system interfaces, and data migration from the legacy CMMS. From the information gathered in the workshops, an implementation strategy was developed for configuring the Cityworks CMMS to support the functional, business, and end-user requirements. Phase 2 involved implementation and configuration for the Call Center, field data collection, and reports generation. To the credit of a very dedicated, focused, and determined Public Works GIS & IT Team, and an effective partnership with a superb working relationship with the contracted project leader, Public Works was
INPRINT / FALL 2005
FEATURE ARTICLE able to realize a comprehensive (non-phased) implementation of Cityworks for Street Maintenance, Sanitary & Stormwater, and Buildings (basic) infrastructure assets on June 8th, 2004. As we complete our first year (June 30th, 2005) since implementation, there is much to report. This implementation was met with ample enthusiasm from the City Manager’s Office so as to warrant expansion of the Cityworks Call Center and Service Request subsystems. As a result, Public Works is now providing multi-departmental support for seven other City departments. • Mayor’s Office • City Manager’s Office • City Clerks Office • Management & Legislative Services Department • Inter-Governmental & Community Relations Department • Codes Compliance Department • Engineering Department
Current initiatives are for Public Works to support the Engineering and Information Technology (IT) Departments in the full implementation of Cityworks within their Enterprise Asset Management (EAM) System solution. Reed Fowler, Director of Public Works, states: ”This implementation and integration with our Enterprise Asset Management Solution will support our mission to serve our citizens, to further promote our national accreditation with the APWA and to continue our strides for excellence in all facets of the industry.” Current details of the implementation to date are as follows: • Implementation of a dedicated ArcSDE Server and movement of the startup personal geodatabase to ArcSDE geodatabases. • 25,752 service requests logged with 21,489 closed. • 12,221 work orders created with 8,201 either completed or closed. • Additional departmental support
SOFTWARE RELEASE (cont. from page 1) • Update Database to 4.3 Version of Cityworks - Upgrade the Cityworks server database to 4.3 before moving into a production environment.
Work Management Highlights • Comments/Instructions - Search Results can now display comments and instructions. • Layout Manager - Service request and work order allow customization via the Layout Manager window. • Searching - Users can search for requests and work orders based on time since initiation (Past____ Hours). • Cityworks Functions on the ArcMap Context Menu - Right-clicking on the map to create location-based service requests and work orders.
INPRINT / FALL 2005
(cont.)
received. • Public Works warehouse’s 2nd annual physical inventory. • Field capture of data inventory has begun. • Intranet-based reports are a reality. J Contact Information: Timothy J. DeSalvo Information Technology Administrator City of Newport News, Public Works Department tdesalvo@nngov.com http://www.nngov.com (757) 269-2706 Kirk McClurkin, P.L.S. Senior Project Manager Timmons Group Kirk.mcclurkin@timmons.com http://www.timmons.com (757) 513-6995
President’s Corner - Cont. from page 2
• Work History Tab - Cityworks Asset Identify window now has a work history tab with historical cost totals. • Active Employees - Checkbox added to the Employee window to allow for historical employee searches. Verify that current employees in Designer have the “Active” box checked after running Database Manager. J
instead of MapObjects. Among the many benefits for supporting embedded ArcEngine is the full support of Event Layers, an important feature of Cityworks. The second ESRI trend involves Cityworks Server. Some time during the first quarter of 2006, ESRI will release ArcGIS 9.2. ArcGIS Server will support ASP.NET 2. Azteca Systems will participate as part of the ArcGIS 9.2 Server beta test with the first shipment in November 2005. Just as soon as we receive 9.2 beta, we will begin testing Cityworks Server. Azteca Systems is currently under contract to deliver Cityworks Server to multiple organizations. After we have successfully completed these commitments, we will be happy to discuss with you where Cityworks Server might best fit into and compliment your current Cityworks Desktop deployment. Azteca Systems is still fully committed to having Cityworks Desktop and Cityworks Server “coexist.” You do not have to choose between them. In fact, both Desktop and Server can be deployed in your organization. J PAGE NINETEEN
CITYWORKS TRAINING Client Training Azteca Sandy Facility November 29 - December 2, 2005 March 14 – 16, 2006 June 16 – 17, 2006 (Pre-Conference Training in Park City) September 19 – 21, 2006 December 12 - 14, 2006 Implementation of Cityworks, Introduction to Cityworks Part I & II, Cityworks Add-ons Web Training – Courses Available Cityworks Database Integration with ArcSDE – Oracle Prerequisite: ArcSDE experience Cityworks Database Integration with ArcSDE – SQL Server Prerequisite: ArcSDE experience Introduction to Cityworks Desktop ArcView 3x Part I Introduction to Cityworks Desktop ArcView 3x Part II Prerequisite: Introduction to Cityworks Desktop Part I Storeroom Configuring and Running Call Center Performance for GASB Pavement Management Interface - MicroPAVER Equipment Manager Cityworks Designer Configuration Part I Cityworks Designer Configuration Part II
Partner Training Azteca Sandy Facility December 6 – 8, 2005 March 7 - 9, 2006 June 16 – 17, 2006 (Pre-Conference Training in Park City) September 12 – 14, 2006 December 5 - 7, 2006 Web Training – Courses Available What’s New in Cityworks Prerequisite – 3-Day ABP Sandy course The Cityworks Implementation Process Prerequisite – 3-Day ABP Sandy course
Event Calendar Oct 5-7 : MWAUG, in Bloomington, IN 9-12 : URISA, in Kansas City, KS 17-20 : ESRI EGUG, in Truckee, CA 24-25: Virginia GIS, in Richmond, VA 26-27: AGIC, in Prescott, AZ Nov 30 - Nov. 2 : WEFTEC, in Washington, DC 3-4: ARCGIS Forum - Hot Springs, AR PAGE TWENTY
PROJECT MANAGEMENT UPDATE
(cont. from page 14)
The integration between Cityworks and Designer was achieved by enhancing Cityworks to support compatible units—aka cu’s—or material part assemblies (this enhancement is part of the core Cityworks application and does not require M&M Designer); and the development of an API (add-on) that passes and receives data (through XML) and instructions from M&M Designer. This integration allows a Cityworks user to create a work order specifying that a construction design is required. This is done via a task that is flagged to send the work order to M&M Designer. M&M’s Designer is provided the location and instructions for the new design. Users generate one or more graphic designs containing the assemblies (cu’s) that will be part of the construction project. The design(s) is/are housed in the GIS as SDE versions. Designs can then be submitted to Cityworks to obtain a total cost estimate for the cu’s in them. Once a design has been approved for construction, the cost estimates for each cu in the design are passed back to Cityworks and the work order can begin tracking actual costs. Upon completion of the construction project, a status change to the design in M&M Designer (resulting from a “check-in” of the SDE version) passes the new assets’ GIS IDs to the Cityworks work order, which adds the work order to those assets’ work history. Since both applications utilize the geodatabase as the asset database, the integration between the two systems works well, allowing CIP or maintenance projects to be tracked from inception to completion, through each preliminary design to the final, approved design and to the closed work order. Throughout this process the work orders are associated with assets that are being removed or added to the GIS. The integration of Cityworks with GIS tools like ArcFM and Designer facilitates and simplifies the management of the asset’s life-cycle. J
Welcome New Cityworks Users!
Christiansburg, VA Coon Rapids, MN Denham Springs, LA Iberville Parish, LA Marco Island, FL New York City Parks, NY Norwalk, CT Richmond, VA St. Johns County, FL Stockholm Water Company, Sweden Terre Haute, IN Willamalene Parks & Rec. District, OR INPRINT / FALL 2005