Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Agreement - Software Renewal for CityWorks - Azteca Systems, LLC.
1316 COUNTY —CITY BUILDING U, �a PHONE 574/ 235-9251 227 W. JEFFERSON BOULEVARD I'll. ACE FAX 574/ 235-9171 SOT ITHBEND. INDIANA46601-1830 r IIIfa w � CITY OF SOUTH BEND PETE BUTTIGIEG, MAYOR BOARD OF PUBLIC WORKS November 12, 2019 Ms. Bridget Suda Azteca Systems, LLC. 11075 South State Street, Suite 24 Sandy, UT 84070 RE: Software Renewal Agreement Dear Ms. Suda: The Board of Public Works, at its meeting held on November 12, 2019, approved the above referenced agreement for software renewal in the amount of $92,625. Enclosed please find the original of the agreement for your signature. Please sign and return the original agreement to our office and retain a copy for your records. If you have any further questions regarding this matter, please call this office at (574) 235- 9251. Sincerely, Linda M. Martin, Clerk Enclosure GARY A. GILOT GENEVIEVE E. MILLER ELIZABETH A. MARADIK LAURA L. O'SULLIVAN THERESE J. DORAU Cityworks l Azteca Systems, L. 11075 South State Street, Suite 24 Sandy, UT 84070 Phone: 801-523-2751 Website: Cityworks.com Cl'tywolrks� Cityworks is designed and created to bthe 9eading GS--centric systern for public asset u,nanag en,,ient, that'. fLA I ly leverages the power of geographk- informaJon (GIS) and help comrnunities work smarter, blecome rn(,,,)re susLair,iable, resilier)t,, arld s,,,fl"e, Cityworks, TABLE OF CONTENTI OJrOpaOy Information .... ........... _........... ....._...---___—............ ........... —.. Section 1 (]UOte ..... ___—_........... ......... ..................................... ---....... ................... .....— Section 2 ChyworkS &Ar[G|S .................. —_......... ......._.......—_—...... ...................... _... Section 3 PnOdU[tS & [)DhOnGl Add-ons .................... Section 4 System Specifications ... —...... _—_..—._.~-......... —......... _--_.~.......... .--- Section 5 K8a|OteDaU[e ... ......................... ...... .............. ....~...._--........... ._—_,....... —..... Section CITYWORKS8 I AZTECA SYSTEMS' Founded in 1986, Azteca Systems, LLC began as a consulting firm that provided cartographic mapping support to federal agencies. Azteca Systems earned a reputation for GIS-centric solutions, and public works agencies began approaching us for help with their asset management strategy. In 1996, the Cityworks platform was born. Cityworks is a powerful, flexible, and affordable web GIS-centric public asset management solution. Today, we support more than 650 organizations throughout the United States and around the world, from single -user sites to enterprise installations. Our clients include public works agencies, transportation agencies, water and wastewater utility districts, airports, energy companies, community development agencies, and other organizations involved with the care and operation of public assets. We are a full -service company —a financially strong and closely -held corporation. Focused on the development of GIS-centric software applications, Azteca Systems is capable of providing complete implementation, integration, data conversion, and process review services, as well as re -engineering, education, and ongoing maintenance. GIS offers a robust and accurate representation of assets, modeled as they are in your community. Built exclusively on Esrl's ArcGISI Cityworks offers a robust system of record, engagement and insight for public asset management. We recognize GIS as the authoritative system of record for local government and public service organizations. 1. BUILD THE RIGHT TEAM 2. CREATE LASTING PARTNERSHIPS CORE VALUES 3. ENABLE THE POWER OF GIS 4. IMPROVE COMMUNITIES BUILD THE RIGHT TEAM Our employees are the lifeblood of Cityworks. We are passionate about creating a GIS-centric ecosystem to help you build a more resilient, sustainable, and safe community —a smart community. Our objective is simple: engage a culture of innovation and ongoing improvement for employees, customers, and strategic partners. Our company is staffed by a comprehensive group of professionals capable of development, implementation, training, customer support, and marketing. As a Cityworks client, you will have access to the following teams: ® Enterprise Solutions: Support implementation and project management, education services, and the business partner program. ® Products and Development: Responsible for software development, testing, research and development, and documentation, ® Customer Success Management (CSM): Provide support before, during, and after implementation and ensure long-term client success. CREATE LASTING PARTNERSHIPS The Cityworks community includes a network of business partners who embrace the value of superior customer service. From world-renowned civil engineering and technology integration firms to respected software companies and international distributors, our business partners all share a common belief in the value GIS. Our strategic partners, Esri and Trimble, provide long-range support in the core technology and business objectives we pursue with Cityworks. Implementation partners help you put Cityworks to use —efficiently, effectively, and as quickly as possible. Several world -class software development companies help customers extend the reach of Cityworks with integrated solutions. These development partners support capabilities such as automated vehicle location (AVQ services, CCTV inspections, citizen engagement, utility location, pavement management, systems modeling, mobile solutions, utility billing, and so much more. EXPANDING GLOBALLY Cityworks continues to expand globally with customers and partner!! .......... Contact Information Contact Name: Organization: South Bend (IN), City of Contact Address: 1316 County -City Building South Bend, IN 46601 Quote Lines Product Name PLL Workgroup Standard Starter 5-Pack Public Access for PLL Notes Quote Number Q-08562-2 Created Date 10/24/2019 Expiration Date 1/23/2020 Prepared By Bridget Suda Name: Prepared By (801)523-2751 Phone: Quantity/ Population 1.00 1.00 TOTAL: Net Unit Price $1,125.00 $2,500.00 $3,625.00 Year 1 Dollar Value $3,625.00 Year 1 Date Range 11 /15/2019 - 12/31/2019 Year 2 Dollar Value $89,000.00 Year 2 Date Range 01/01/2020-12/31/2020 Year 3 Dollar Value Year 3 Date Range Quote Notes: Quote adds 5 Standard PLL Workgroup Logins and Public Access for PLL to current licensing. Update License: Server AMS Standard Enterprise License Agreement (ELA), Includes Unlimited Quantities of the Identified Products: Office Respond Mobile Native Apps (for iOS/Android) --Includes the following Add-ons: Storeroom Equipment Checkout Contracts Cityworks for Excel Cityworks Analytics for AMS BURL (Enterprise URL) Workload Web Hooks Azteca Systems LLC 11075 1 South State Street Suite 24, Sandy, UT 84070 1 Corporate Main 801-523-2751 1 Corporate Fax 801-523-3734 Local Government Templates (LGT) Use of Cityworks AMS Application Programming Interfaces (APIs) with commercially available Cityworks- centric applications that are licensed and maintained by authorized Cityworks partners Workgroup Server PLL Standard 5 Named Logins for: Office Respond Mobile Native Apps (for iOS/Android) --Includes the following Add-ons: Web Hooks Public Access for PLL Use of Cityworks PLL Application Programming Interfaces (APIs) with commercially available Cityworks-centric applications that are licensed and maintained by authorized Cityworks partners Annual fee herein is based on 50,001 - 100,000 population range *Fee for Year 1 reflects additional products added and is pro -rated through 12/31/2019. Current Renewal Amount has previously been paid. Terms and Conditions All quotations are valid for ninety -days (90) from the date above, unless otherwise stated in this quotation form. All prices quoted are in USD, unless specifically provided otherwise, above. These prices and terms are valid only for items purchased for use and delivery within the United States. Unless otherwise referenced, this quotation is for the Cityworks software products referenced above only. Pricing for implementation services (installation, configuration, training, etc.), or other software applications is provided separately and upon request. The procurement, installation and administration of the Esri software utilized in conjunction with Cityworks will be the responsibility of the customer. The procurement, installation and administration of the RDBMS utilized in conjunction with Cityworks will be the responsibility of the customer. Currently, Cityworks supports Oracle and SQL Server. The procurement, installation and administration of the infrastructure (hardware and networking) utilized in conjunction with Cityworks will be the responsibility of the customer. This quotation information is confidential and proprietary and may not be copied or released other than for the express purpose of the current system selection and purchase. This information may not be given to outside parties or used for any other purpose without written consent from Azteca Systems, LLC. Software Licensing All Azteca Systems software offered in this quotation are commercial off -the -shelf (COTS) software developed at private expense, and is subject to the terms and conditions of the "Cityworks Software License Agreement' and any and all addendums or amendments thereto. A fully executed copy of the Software License Agreement and any addendum(s) is required before delivery and installation and usage of the software is subject to the terms of the current license agreement. Delivery method is by way of download through Azteca Systems, LLC. customer support web portal. Payment Terms Net thirty (30) days. Taxes Prices quoted do not include any applicable state, sales, local, or use taxes unless so stated. In preparing your budget and/or Purchase Order, please allow for any applicable taxes, including, sales, state, local or use taxes as necessary. Azteca Systems reserves the right to collect any applicable sales, use or other taxes tax assessed by or as required by law. Azteca Systems reserves the right to Azteca Systems LLC 11075 1 South State Street Suite 24, Sandy, UT 84070 1 Corporate Main 801-523-2751 1 Corporate Fax 801-523-3734 add any applicable tax to the invoice, unless proof with the order is shown that your organization or entity is tax exempt or if it pays any applicable tax directly. International Customers These items are controlled by the U.S. government and authorized for extort only to the country of ultimate destination for use by the ultimate consignee or end-user(s) herein identified. They may not be resold, transferred, or otherwise disposed of, to any other country or to any person other than the authorized ultimate consignee or end-user(s), either in their original form or after being incorporated into other items, without first obtaining approval from the U.S. government or as otherwise authorized by U.S. law and regulations. TCCA SYSTEMS, LLC. COPYRIGHT 1995 - 2019 f P Accepted by: + /) wtle.- w Date Azteca Systems LLC 11075 South State Street Suite 24, Sandy, UT 84070 1 Corporate Main 801-523-2751 1 Corporate Fax 801-523-3734 Azteca Systems LLC 11075 1 South State Street Suite 24, Sandy, UT 84070 1 Corporate Main 801-523-2751 1 Corporate Fax 801-523-3734 INTER -OFFICE MEMORANDUM PC A Department of Innovation & Technology City of South Bend 227 W Jefferson Blvd TO: Board of Public Works, Linda Martin CC: Shawn Delahanty, Dan Parker, Michael Schmidt, Clara McDaniels, Sandi Kennedy FROM: Daniel O'Connor SUBJECT: Cityworks 2019 PLL software add on and 2020 PLL and AMS Software renewal for 1 year through Azteca Systems DATE: 10/29/2019 Linda and Members of the Board We are submitting for review and approval a 2019 add on (qty 5) PLL software licenses and a 1-year renewal agreement for Cityworks PLL and AMS software through Azteca Systems. The pro -rated cost for the 2019 PILL add on is $3,525 and for the one year renewal for both PILL and AMS licensing is $89,000. The annual renewal is a planned and budgeted item with the funding coming from the IT Operating budget. Attached is the quote for the software. Thank you. Daniel O'Connor CITYWORKS° AND ARGGIS° ENABLE THE POWER OF WHERE` FOR PUBLIC ASSET MANAGEMENT We recognize GIS as the authoritative system of record for local government and public service organizations. Built exclusively on Esri's innovative ArcGISO technology, Cityworks offers a robust system of record, engagement, and insight for public asset management. The Azteca Systems partnership with Esri began in 1987. Over time, the tools we used grew and changed as Esri's technology grew and changed. Though other approaches may interface with a GIS— generally for map visualization —the Cityworks platform has always used ArcGIS as the authoritative data system of record. Ultimately, this translates to a powerful user experience. End users can easily and seamlessly move between Cityworks to Esri applications to collect, view, and share data. Application developers can access ArcGIS and Cityworks to design and build applications that support unique end -user workflows, Together, Cityworks and Esri ArcGIS support a range of solutions to meet your needs. credentials. This is helpful for administrators who want to manage user passwords in ArcGIS Online or Portal for ArcGIS rather than Cityworks. Single Sign -on also eliminates the need for the Esri Resource Proxy to be configured for secured GIS services to be consumed by the map. This function also allows users to view ArcGIS Online web maps in Cityworks. When logged in via Single Sign -on, users have two additional map tools: ArcGIS Online Web Map Manager and Roads and Highways. The ArcGIS Online Web Maps map tool allows users to incorporate add web maps from ArcGIS Online to their Cityworks map. Roads and Highways is licensed under Single Sign -on and requires Esri's Roads and Highways license and extension. This app contains map tools which allows users to create a feature event on roadway assets and create work orders, inspections, and permits attached to the new event. Route marker pins are used along the assets to define the end points of the feature events. Data from Cityworks Roads and Highways can be viewed in Esri's Roads and Highways, providing powerful mapping, reporting, and analyses. Web Map Manager enables users to select and change their map in Cityworks to any shared web map found in Portal for ArcGIS and ArcGIS Online. In addition, an organization's saved Enterprise URLs can be dynamically added into a web map as a layer and ordered by the user interactively. This product requires licensing for FURL, and users must be logged in via Cityworks Single Sign -on. [491011111,1111;'014 ID161A 1,1111,01101,11A � Collector for ArcGIS is an Esri app that allows users to create and update GIS features while working in the field. Using the Cityworks mobile native apps for Android or iOS, Cityworks users logging in with their AGOL or Portal logins can open service requests, work orders, inspections, and PILL cases and navigate directly to that work extent in Collector. Since Cityworks and Collector leverage the same web map, that means users can move seamlessly between the two apps. It also means that any new features created, or updated, in Collector is available immediately in the Cityworks app. TATIVY-11"Ill �P Navigator for ArcGIS is an Esri app for routing and navigation. Cityworks mobile native app users can use Navigator to get turn -by -turn directions to any address or asset. Navigator will also provide an optimized route if users need to navigate to multiple locations. Like the Cityworks mobile native apps, Navigator works online or offline. Navigator can be opened from service requests, work orders, inspections, and PLL cases and initiated for routing to the work activity or associated asset. Workforce for ArcGIS is an Esri app that allows office staff to create and assign work to field crews, who also use the app to view their assignment in the field, Cityworks users logging in with their AGOL or Portal logins can open Workforce and access activities and seamlessly launch the Cityworks mobile native apps for Android and iOS to process the work order. This allows Cityworks users to record additional information in the Cityworks Native Apps, complete the work and update Workforce. 5,31 �011 A il"01 reports can be brought into Cityworks as service requests where they can be managed and follow up activities can be generated. As these are processed in Cityworks, updates can also be delivered back to Crowdsource Reporter for citizens to view. ENABLE THE POWER OF WEB GIS-CENTRIC As a global leader for public asset management, Cityworks Designs, Creates, Promotes and Advocates GIS-centric software as a best practice to strengthen smart communities. We recognize GIS as the authoritative system of record for local government and public service organizations. Built exclusively on Esri's innovative ArcGISO technology, Cityworks offers a robust system of record, engagement, and insight for public asset management, The Cityworks platform has always used ArcGIS as the authoritative data system of record. Ultimately, this translates to a powerful user experience. End users can easily and seamlessly move between Cityworks to Esri applications to collect, view, and share data. Application developers can access ArcGIS and Cityworks to design and build applications that support unique end -user workflows. Together, Cityworks, Esri ArcGIS, and our partners support a range of solutions to meet your public asset management and infrastructure needs, A 15 Discover,quantify, and , Evaluate alternative solutions predict trends and, patterns and create,optimal designs i '°- to 1lilprOve outcomes' Q Q O_ 6, O O -4 0-0 C6ns ituent Engagement S�ia1 iiYC� �s � 4ill�� t�i aii�`: less, Communicate and collaborate Empower everyone to easily (riven with;citizens and external discover, use, make, and share communities of interest geographic information Copyright © 2018 Esri. All rights reserved, IMPROVE COMMUNITIES Local governments and public service organizations across the world use Cityworks and ArcGIS to make their communities more resilient, sustainable, and safe. Esri recently identified nine ways organizations typically use GIS. In public asset management, this translates to four key activities that help organizations realize a greater return on investment: Constituent Engagement: Encourage residents, business owners, and policy makers to provide input, remain informed, and monitor progress with the help of Cityworks data and Esr! web maps - •Organization Empowerment: Empower management and staff to collaborate, communicate, and interact with asset data. •Organization Decision Support: Use asset data to better understand cost, risk, labor, and capital investment priorities. Help management and staff make better real-time, data -driven decisions. •Organization Design and Planning: Evaluate alternatives and develop initiatives that improve management, budgeting, planning, and design. GIS-CENTRIC CHARACTERISTICS OF PUBLIC ASSET MANAGEMENT REDUNDANCY ArcGIS is the authoritative system of record with no writing or syncing to other asset data tables. Cityworks can support any geoclatabase design for your assets —including linear, dispersed, or condensed. NON-PROPRIETARY We build on the geoclatabase with well-known and understood data structure elements. Your organization owns and fully controls its data. AdW ARCGIS UPDATES "Wo Cityworks relies solely on ArcGIS feature services to update the authoritative asset data to ensure data integrity. ARCGIS WEB MAP Any application can access an ArcGIS web map without constraints, allowing you to find and view asset data at a glance. Our software supports a single -sign on identity. All associated apps will support the preferred identity storehouse—ArcGIS Online or Portal for ArcGIS. I h Qy ANALYTICS & REPORTIN! Cityworks uses ArcGIS tools for data analytics and powerful visualizations to support decision -making. PRODUCTS The Cityworks platform is designed to utilize Esri ArcGIS and contains Cityworks AMS and PLL core products which are available through their respective Office and Tablet apps. These apps provide the end user with an optimized office or mobile experience. Each contains full AMS or PLL functionality, along with integrated map tools. Products listed are for informational purposes only. Please refer to Section 2 for actual products to be licensed. Core products include the following: Office for AMS • Tablet for AMS Office for PLL • Tablet for PLL Add -on software applications have been designed to extend the Cityworks platform by providing additional specialized capabilities. These are licensed separately, and include the following: Respond Public Access • Mobile Native Apps (for iOS/Android) Storeroom • Equipment Checkout Contracts • Cityworks for Excel° Cityworks Analytics • eURL • Operational Insights • Workload ° Web Hooks • Performance Budgeting CCTV Interface PAVER Interface • JSON web services APIs CITYWORKS AMS Cityworks AMS is a web GIS-centric public asset management solution platform designed with built-in Office for AMS and Tablet for AMS apps. Each app incorporates a palette of tools, tabs, and links in a highly customizable environment, allowing Cityworks to be served across a department, a division, or an entire organization, Cityworks Office for AMS and Tablet for AMS apps are designed for maintenance and operations. These apps allow users to utilize GIS functionality while managing and tracking maintenance operations involving service requests, work orders, and inspections within an office or mobile environment. Users can schedule and track preventative maintenance with cyclical work orders and inspections. Emergency and other reactive work orders are also managed. These are often generated from customer calls and service requests. Maintenance data relating to specific public assets is tracked and managed, and includes: location, assets, resource usage and costs, assignments, tasks, comments, dates, and more. Caller histories as well as asset maintenance histories are readily available using Cityworks searches. Maintenance searches can be configured with tabular and/or spatial data. Specialized reports can be generated using Crystal Reports. A map interface includes tools for map display, navigation, feature selection, activity creation, event layers, asset searches, navigation, location, recline, heat mapping, and more. . . ... .. ..... . .. . . xo Office for AMS—Works Order CITYWORKS PLL Cityworks PLL is a web GIS-centric permits, licensing, and land platform designed to manage development projects, code enforcement cases, and other similar projects from inception to completion. It facilitates the use of ArcGIS mapping functions at all relevant levels. It is not only functional for private land development, but it can be used for utilities, highways, parades, festivals, and other public projects. Cityworks PILL is designed with built-in Office for PLL and Tablet for PILL apps, which provide the end user with an optimized office or mobile experience. These apps contain full permits, license, and case management functionality and are designed for office computers, mobile laptops, and tablets. Cityworks PLL gives jurisdictions direct control over their business processes. Basic functional forms are highly adaptable and can be tailored to each organization's unique structure and needs. Customized templates help manage the required data for specific processes. As many or as few templates as necessary can be designed to streamline the development process. PLL can be configured to allow access by multiple departments within an organization, such as land management, legal department, public utilities, and others. Workflows efficiently track applicable tasks from application or request, through reviews, fee collection, inspections, commission meetings, hearings and abatement, license renewal, and more. GIS features can be associated to records and may include parcels, street segments, intersections, addresses, or any other defined GIS features. F FIE=, TM Office for Pl_L Surnroory view RESPOND Respond extends Cityworks AM Sand PLLfunctionality to a mobile setting, such as on a tablet at a job site. Respond is designed differently than Office and Tablet, and focuses on service request, work order, inspection, and PLL case management. Respond enables mobile work on an interface optimized for tablets and includes a map. The map interface is designed with the following tools: base maps, bookmarks, create activity, data view, editor, heat maps, layer search, legend, locate, measure, navigation, printing, redline, routing, and selection. Respond requires a constant connection and uses a responsive design that is not supported in Internet Explorer. . . . ........ W, WOhm luK 1, 0,, win M Performance Budgeting —Budget variables MOBILE NATIVE APPS FOR IOS AND ANDROID These apps allow Cityworks to be used in a disconnected environment. Users can create service requests, work orders, and inspections, and edit service requests, work orders, inspections, and cases using iOS or Android devices, Work activities, tasks, and cases can be viewed on the map and marked as completed with comments. :WP L4 ')[Gwhmn Ngw Na" Imp 11 OF, RwAliv 0 POU % Q Imp hmmrg Hgwddwm� Lwr� gftpll QT4'vlk", 0""", tv hop R'PAiwq Pv,vdorraNem, V111N'11 IiWq* 1105 Pk-wfev iP'kd a im TF & 14". P t " I " A ro Ao *0 NO IN 11 6,110 - 1M3MrAMMNL2MWN1AN=,' iOS app—Inbox case example iOS app—Map example STOREROOM Cityworks Storeroom is a product designed to track incoming and outgoing materials from multiple storage areas, including work vehicles, as well as manage stock, material cost, suppliers, and requisitions. Storeroom functions are integrated with work orders created in Cityworks AMS. When materials are added to a work order, issue transactions are written to Storeroom to adjust the available stock. If materials are removed from the work order, or if the work order is canceled, receive transactions are recorded in Storeroom to return unused materials. 4 QA( A'�q rv� 'J, �i&A," %W f I Materials can be defined with a description, location, part number, supplier, etc. Requisitions can be created for individual materials or from a search on the reorder quantity. Material transfers from storeroom to storeroom can be tracked. Receive transactions can track the materials coming from a supplier or from a work order return.. Issue transactions track materials issued to an account, employee, or work order. Audit transactions can be used to record adjustments made to material quantities and costs. Supplier information is tracked and associated to materials. Material cost types include LIFO, FIFO, Weighted Average, or Current cost. All materials transactions are recorded, whether entered from Storeroom or from a work order. Material assemblies comprised of several materials is supported. Barcode technology and Cityworks Analytics reporting are supported. EQUIPMENT CHECK OUT Equipment Check Out is used for checking out, returning, reserving, and tracking work order equipment, as well as keeping a history of equipment and employee usage. 02= e1=020MMUNNIMIMBINIONSUMMM labletforAMS Fqulprnew Check Out CONTRACTS Contracts is used to track asset maintenance activities contracted to entities outside of your organization. These activities can include design, estimated costs, bid process, and more. Contracts can have a set budget; track a set of tasks, materials, or equipment,- track estimated costs; record reported costs by line item; and track work completion and cost approval. Contracts can also spread materials and costs across multiple activities, I I hy ".1 cl,-111 1.111, J V t G''t rIm.-�.q TP 1 + ... . . . . . . MNNu . . . . .. @j 4 Foblet for AMS—Contract somple CITYWORKS FOR EXCEL Cityworks for Excel allows users to make changes to the Cityworks database and geoclatabase tables from one place with an easy -to -use interface. Work orders and inspections can also be created using this application. Cityworks for Excel supports Excel 2013, 2016, and Excel 365 (desktop version) on Windows. This software I �CR41 INISM11 RACA' 11 AVOUI 0 RMtk AS 'qpr IdAc T�,vr ',061AI EIR hWe Namt, Fwe 11 A4022 A D Y 1,C) 1ANICTIER I 'WA FffTNGjrFCAT1 3 2159'954.273 2299168.6903 6 ' N/A 40'4, 2160066A40 2279540,3210 6 N/A 4 015 215091734 229504.089 6 NJA 4 0 71 2158325.234 223M% A41: 6 N/A 4017 215877 7.364, 2231 54-7. 100 G "6 NIA 58215,'KA M291.0468. 6 N/A 1119.127118 779171,1153 6 N/A IWC,T) 2 M ti 1.10 -139 I 22R774,r4Afi 6 NIA 204988,01 2.018180," 6 N/A Cityworks [(..)r r x(.el Tobledato example ANALYTICS Cityworks Analytics is an app which enables organizations to quickly create detailed reports using the information in their database. These powerful reports are used to graphically analyze the organization's performance. Analytics is delivered as a web service with a series of predefined, yet customizable templates, reports, and KPIs. Users can simply configure the data connection and use existing out -of -the -box tools or attend a comprehensive training program to learn more about modifying and creating analytical tools. This app is integrated with Insights for ArcGIS, Esn's data analytics software made for advanced location intelligence. Using Cityworks Analytics with Insights for ArcGIS allows users to visualize asset data in maps, charts, graphs, and tables. Together, these tools provide valuable information about the operational performance of your organization. Cityworks Analytics with Esri's Insights for ArcGIS EURL EURL enables Cityworks saved searches to be published as REST services for sharing of maps internally or outside an organization. This includes searches or event layers created through inspection, service request, work order, PLL cases, GIS searches, and asset calculations. EURL can be used with Cityworks Office and Tablet apps, Operational Insights, Web Map Manager, and Single Sign-on/Roads and Highways. PUP, 02 rofi . . Me... . .. PUBLIC ACCESS Public Access is the citizen portal to Office and Tablet for PILL. It allows citizens and contractors to apply for and track the progress of permits and licenses, start the application process, or finish an incomplete application. Once the permit or license has been created, the user can request inspections, check inspection status, cancel an inspection, and pay permit fees. This app contains a message board and a map with navigation tools. 14 �4 - --- --- --- - M mk~ Ji f", A* K'A PubficAu(n Malnpoge OPERATIONAL INSIGHTS Operational Insights generates KPIs used for business risk analysis related to the health of an organization's assets. These KPIs are calculated using information from GIS attributes and tracked maintenance in combination with user defined asset strategies and maintenance strategies. Potential problem assets can be identified on the map, and work orders can be created using map tools. Asset strategies identify asset types, their rating levels, rating methods, and values or ranges. Asset strategies combine with key GIS field values, their risk factors, and factor ratings to generate values for three risk factors: consequence of failure, probability of failure, and risk mitigation. These risk factors respectively indicate failure impact, failure probability, and effort taken to reduce the impact of asset failure; multiplied together, these three factors generate values for business risk exposure. Maintenance strategies identify asset types, key dates, and strategy details. These strategies combine with proactive and reactive work order templates, their activities, intervals, weighting factors, and number of repairs which are used to generate maintenance scores: proactive over -maintained, proactive under -maintained, and strategy threshold (estimated repairs). CU"013"Wilem of FeWsre Ulm r gIII, "Dull"Ims Rusk Erpostol MAP . .. .... . . . ..... ME Operational Insights Anolytics dashboard Probability of Failure (POF) Consequence of Failure (COF) Business Risk Exposure (BRE) • Under Maintained Proactive Maintenance Score (MSPU) • Over Maintained Proactive Maintenance Score (MSPO) POF vs. COF • POF vs. MSPU • BRE vs. MSPU �V,RJp00/01UNUNN UIkI RON,, owl r' I I � i ice, AW I� J111" . f .9.1N. n III *tnwx rz+ ' aJPL. ' uU N1wdl� A I J„(VI Id I f+JA _ f i i f I i i, r if i i i i i ii I i I I1 i f/I l 1 / ��ua�ad a4r M!Af:'a�;rv"p',AS i4h'a4AVAJ AINAflk tl' "ask _.. ff",,004 0.04"e~; WMm00wM`fl"tl'tlAm94Nawns#0 iAAAlflmmmmmas wlb! ..f; V' IRiMv ni ii. o i.� .JdtvL A'�YW'd'A @i' a 2d�21h �i lrWv � � i°WNVbuk%� W4'V�ilq Operational Insights is integrated with Esri's Insights for ArcGIS, which enables further analysis of your Operational Insights KPI data. Data generated in Operational Insights can be displayed on a map in Insights for ArcGIS through use of the Cityworks EURL function, which enables saving searches and sharing the maps. Insights for ArcGIS displays your KPI data and can interactively identify critical assets and hot spots on the map based on selected variables used in calculating the risk factors. WORKLOAD Workload assigns work activities to employees, which include: inspections, work orders, and PILL tasks. The map displays unassigned activities and activities assigned to individual employees. These activities are easily reassigned using drag -and -drop from one list to another, or from the map to a selected employee. Overdue activity assignments are highlighted in pink. Each activity requires an asset or geocoded address tied to the record for it to show on the map. The map displays activities using an entered projected date range for AMS records or target range for PLL records. AV 410", 04 a 4b 'Ile Workload Activity assignments WEB HOOKS Web Hooks enables messaging to third -party systems that an action has occurred in a Cityworks service request, work order, or case. mail 11 pqvnk I.Awwwo F"MM'! 12 11 1'ii n r J)"Nsom, '' yow 40,n ON ,+v P4 A )" f u/n, IW MAIM011 JVWP,'N Al, fim 0 BLI� PERFORMANCE BUDGETING Performance Budgeting generates daily and yearly budgets based on projected costs and budgetary constraints of an organization's assets. Budget projections are based on work order templates, maintenance factors, cost factors, plus actual and projected work. Performance Budgeting can help to accurately predict future budgets and determine cost projection, productivity, optimal crew size, etc. Wmammm Performance Budgeting Budget variables CCTV INTERFACE The CCTV Interface links directly to PACP-compliant (Pipeline Assessment and Certification Program) closed circuit television (CCTV) inspection systems. The interface is a bidirectional application allowing users to pass data from the Cityworks database to a PACP database and back again. 4 �roal �xwq%,� Tr",To UA "",'Yr V1 -A W(' D'M Dag, I z I H I IV U INA, DO" ,444' 0,;6 6 it cxvm W041, rxk" bo4, T)po Fvjx,,,,m Q fqxj�s,w, T)pq rt,,vo D C. wpm oj AI ),Y1'jRCJv,, , � 'N " AK10 ki'� , �N 111* I "4Mtl t"r m"4 7 IMYW,47: 1111( 11 41% WPA P 0 Or� ^� 7 N q r, , ?I .Y', f", ,Aar IN r� $Ov; Y f T;11, C (1-4 t'� I W!;,04YCf X 11 t 19 i 40j"J KIINYYOQJCirR fl TV, 16 ,vrO wm If, W F Pj, ry ft f xa� I ,I "!A MARA r,i I Ays �Aao, whkwy k)urod A pile, he"i Vo #1�104 PAVER MANAGEMENT Cityworks Pavement Management app is the interface between Cityworks and third -party pavement solutions such as PAVER, a program for pavement management created by the U.S. Army Construction Engineering Research Laboratories (USACERL). Designed to fully leverage your GIS investment, Pavement Management eliminates the need for costly duplication of asset data. Pavement managers create and maintain pavement (asset) inventory in the geodatabase, rather than building a database as tabular entries and shape files with unique identifiers in Pavement Management. Pavement inventory is managed within the geodatabase and exported to Pavement Management via Cityworks, which links the geodatabase fields to corresponding fields in Pavement Management. Pavement inventory, work activities, and inspections are established and maintained in Cityworks. This information is exported to Pavement Management to calculate the PCI (Pavement Condition Index), perform pavement analysis, and utilize past pavement work histories to predict future pavement conditions. Pavement Management is also of significant value in planning pavement maintenance and rehabilitation (M&R) because it can set priorities of work to be done according to pavement condition and/or limit the work to a budgeted amount and available resources. This information can be used to schedule and track the recommended work activities. PCI, last construction date, and current surface type can also be imported into the geodatabase and symbolized on the map. After completing any evaluation or analysis in the third -party system, the import functionality allows the user to bring in the inspection files and generate actionable steps via work orders and inspections, therefore capturing valuable information and saving it to the GIS as attributes, APPLICATION PROGRAMMING INTERFACES (APIS) A variety of APIs have been developed to allow clients to extend the Cityworks platform through custom applications and integrations with third -party systems, accessing data and functionality. These JavaScript Object Notation aSON) web services APIs are licensed individually, or can be bundled as part of an ELA, and require configuration services. Citizen Engagement API Document Management API Inspection API Metrics API Cityworks, PLL Case API Basic PLL Case API Extended SIR API Storeroom API 'JJ I I 00'� pot 1110 live W6bhook, GIS-Centric Open Platform Ptalaiish d S WO API Basic WO API Extended Extensive Dalga �y s6111'�60n SYSTEM SPECIFICATIONS CITYWORKS 15.4 SYSTEM SPECIFICATIONS (Lost updated: une 2079) CITYWORKS Specifications for a Database (Intel") Server: DATABASE SERVER* . Windows Server 2012 (64-bit) • Windows Server 2012 R2 (64-bit) • Windows Server 2016 (64-bit) • 32 G13 RAM (or better) • Current Intel XeonO/server class processor 3.46 GHz (or better) * Database server assumes a machine hosting the organization's SDE geodGtobose (supporting both editors and viewers) and Cityworks database (supporting users of Cityworks AMS/PLL). Please contact Azteco Systems with any questions CITYWORKS SERVER Specifications for a PC (Intel") Client: AMS OR PLL 2.0 GHz Intel CoreO processor (or better) Client • 2 G13 RAM (or better) Windows 10 (32/64-bit) or Windows 8/8.1 (32/64-bit) or Windows 7 ProfessionalO (32/64-bit) • Firefox 45-57 • Microsoft Edge* Chrome 43-63 (There is a known issue in Storeroom with Chrome 46) *Microsoft announced upcoming changes to the Edge browser to support the Chromium rendering engine. Due to these changes, we have limited support for Microsoft Edge CITYWORKS SERVER Specifications for an Application (IntelO) Server: AMS OR PLL Windows Server 2012 or 2012 R2, HIS 8.0/8.5 (-40 users) • Windows Server 2016 (64-bit), HIS 10 • 12 G13 RAM (or better) • Current Intel Xeon8/server class processor 3.46 GHz (or better) • Application consumes 1 G13 of disk space (500 MB on system drive) • NET 4.5 Framework Windows Server features (.NET Extensibility 4.5 only if using Windows Server 201 2/R2) Continued on next page CITYWORKS SERVER NET 4.6.2 Framework (installed on both application and GIS servers). AMS OR PLL Requires Crystal Reports Runtime 13.0.16-110.20. CONTINUED (-40 users) NET Framework 4.7.1 is required for the Cityworks application server as well as the GIS server if the Cityworks SOE is used. We do not provide disk space requirements because it is dependent on factors like the size and quantity of attachments and map images. CITYWORKS SERVER Specifications for an Application (intelO) Server: AIMS OR PLL • Windows Server 2012 or 2012 R2, IIS 8.0/83 (-80 users) • Windows Server 2016 (64-bit), HIS 10 • 24 GB RAM (or better) Current Intel Xeon@/server class processor 3.46 GHz (or better) • Application consumes I GB of disk space (500MB on system drive) .NET 4.5 Framework Windows Server features (.NET Extensibility 4.5 only if using Windows Server 2012/R2) • NET 4.6.2 Framework (installed on both application and GIS servers), Requires Crystal Reports Runtime 13.0.16-13.0.20. • NET Framework 4.7.1 is required for the Cityworks application server as well as the GIS server if the Cityworks SOE is used. We do not provide disk space requirements because it is dependent on factors like the size and quantity of attachments and mop images. CITYWORKS Cityworks Utilities interface for pavement management ADD-ONS . PAVER versions 5.3.7-6.5.7 Pavement Management 1.0 app . PAVER version 7.x Cityworks Utilities interface for CCTV . PACP versions 4.4 and 6.0 SUPPORTED ESRII Esrii Enterprise Platforms: 10.3,10.3.1, 10.4,10.4.1, 10.5,10.5.1, 10.6, PLATFORMS 10.6.1, and 10.7 Esri Workgroup Platforms: 10.3,10.3.1, 10.4,10.4.1; 10.5,10.5.1, 10.6, 10.6.1, and 10.7 SUPPORTED RDBMS Oracle 11g R1, Oracle 11g R2, Oracle 12c, Oracle 12c R1, SQL Server 2012, PLATFORMS SQL Server 2014, SQL Server 2016, SQL Server 2017, and Oracle 12c R2 SUPPORTED RDBMS SQL Server Express 2012, SQL Server Express 2014, SQL Server Express EXPRESS PLATFORMS 2016, and SQL Server Express 2017 ESRI PLATFORM *ArcGIS Enterprise 10.7 is compatible with 15A.2 and newer, NOTES *Feature Access via a map service requires the GIS data to be stored in an ArcSDE geoclatabase; a file geoclatabase is not sufficient here. To learn more about how Cityworks AMS/PLL provides comprehensive access to the geodatabase, contact Azteca Systems. *ArcGIS 10.6.1 is only compatible with Cityworks 15.3.1 and newer, *eURLs from Cityworks 15.3.1 sites are not compatible with Portal for ArcGIS 10.6.1 and Insights for ArcGIS 3.0. eURLs from Cityworks 153.2 and newer sites are compatible. MAINTENANCE One of the most important aspects of corporate software is the timeliness of user support. At Citvworhs our goal is to have the very best customer support in the industry. We recognize that if a user cannot use the software to their fullest expectation, then it doesn't matter how great the software is. If an issue is caused by a software problem, the product development staffs main priority becomes the resolution ofthat problem. This section outlines Cityworks support features. For additional information, see the Cityworks Standard License and Maintenance Agreement. Azteca Systems offers telephone support, online support, and other support services on our website, Help Desk isavailable weekdays, excluding holidays. Anemergency phone number orpager number of a technical analyst is provided in the event of a critical problem occurring after-hours, MINE1011 Online support is provided as follows: ^ Regular business hours, 8:00 a.nn,5:00 p.m. MST. ^ Weekdays, excluding holidays. ^ Internet support utilizes GoToAssistorZoom software. An Internet browser connected to the system is required. ^ VPN and web access require secure access tnthe system. The www.cityworks.com welbsite includes general information, which includes: news releases, event listings, partner news, client news, media videos, vvebinarrecordings, C|tyworhsK8agazine, contact information, alink tothe MyOtVwDrks support vvebsite,and more. The MvCitvvvorhsvvebskeisa registereduser support site, which includes: community news, documentation, quick -start and user guides, training announcements and resources, clownloads Dfsoftware, developer articles, partner resources, and more. ^ Online help can be accessed from within the Cityworks Office, Tablet, and Respond environments, ^ Clients can access and download product user guides from the MyCltyworks support website. ' Cityworks magazine is published twice a year, and posted on the www.cityworks.com general infornnaUonvvebsite. ^ Database diagrams are available to clients on the MyC|tyworhs supportvvebs|te. ' Instructional videos are available on K4yCityworks which display specific functionality, What's New in Cityworks, and other information. User Groups and conferences: The Update and Support Agreement allows clients to receive all subsequent upgrades, enhancements, and bug fixes for all future releases of the licensed applications if the client renews the agreement annually. Problems must be re-created by the user and isolated down to a specific software component. Problems can then be submitted to Cityworks by phone, voicemail, chat, or self-service portal. In each case, the information is logged and the customer support team will provide an answer to the question or resolution to the problem. Any support request that is not immediately resolved is assigned to a technical support representative. Verified bugs are submitted to the development team for scheduling, prioritization, assignment, and testing. Enhancement suggestions are managed through the project manager during a project's initial implementation, the customer support representative during ongoing maintenance, through Ideas entries on the My[|tVvvorks site, or the sales representatives and competitive issues brought forth in presentations. These suggestions are reviewed by the Cityworks software development committee which is composed of upper management representing key areas of the company. Enhancement priority is based on many factors, including: user response for new ideas tracked on Mw[itywVrks, information gained from the CitYworks Conference' market drivers, magnitude nfeffort, the needs of the user community, timing of software releases, comparison to other initiatives, and N 4 4 :,F_MA6'N_ 0 14 ON 4 The Cityworks platform is designed with built-in core apps: Office for AMS, Tablet for AMS, Office for PLL, and Tablet for PLL. Other apps are developed outside of the platform and released on their individual schedules at regular intervals, and will correspond with specific platform releases. These optional apps include: Analytics, Operational Insights, Performance Budgeting, Public Access, Respond, Storeroom, Workload, and mobile native apps for iOS and Android. Major and minor platform releases contain major enhancements and fixes and are designed to be as problem -free as possible through heavy testing and quality control. These releases contain bug fixes and enhancements. Previews of the next major release are available to qualifying clients. Enhancements that cannot be developed or stabilized in time for a platform release are furloughed to the next preview. Major versions are intended to have a maintained lifespan of at least two years, Azteca Systems fully supports the current version and the previous version of software with patch updates. Beyond two versions, Azteca Systems will no longer release software service packs for that product except for Minor versions are released on an approximately I 2-month cycle followed by patches released every month or two until the next minor version release, and as needed until the subsequent major or minor release. I, *012 1 A M 'I'll :10 DO), 11111 a V 7, Clients are notified of major releases and service pack releases by email announcement or posts on MyCityworks. For clients with a current Update and Support Agreement, Cityworks will make new releases and supporting documents available on MyCltyworks. Upgrade installation is the responsibility of the client. New software can be downloaded by current clients and includes upgrade details and instructions. When problems are encountered during upgrade or installation of Cityworks while following the Cityworks Install Guide or the Cityworks Upgrade Guide, Cityworks technical support staff is available to remotely assist the client. IN11111111111 111111 1 1111111111111 1111111 i IIIIIIIIIIIIIIIIIIII I 'a mal connect people with smart technology tools to make better decisions and improve the quality of life. At Cityworks, we've partnered with local government and utilities for decades, engaging employees, constituents, and partners with the GIS-centric technology they need to build smart, sustainable communities. CiIN f 1/wi / ks, W(II BOARD OF PUBLIC WORKS AGENDA ITEM REVIEW REQUEST FORM Date 10/29/19 Department Name Daniel O'Connor Innovation & Tech BPW Date 11/12/19 Phone Extension 6201 �itlPoPoPoPa.9l�8'flIONI�IMOW®8 ., ,� WIM4W, �WMIYiMmflVYilAn+S{�.H3W4"/Fg2'f�6JU'y pl�A .,.,.,%MNVW�IMY'BNMN9IWPoIV�tl%%Po.N�NW�_�+�+�'u✓ IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIYINUF�(l/dNihXivYn�� le�l�a�mr� Prior to Submittal _m..........� �..... _........._...—... ��.........._. �.w...� ....... to Board BPW Attorney Attorney Name McDaniels Dept. Attorney Z Attorney Name Kennedy Purchasing Z Schmidt Check the Professional Services Agreement �❑ Open Market Contract Bid Opening E] Quote Opening ❑ Proposal Opening ❑ Chg. Order, No. ® Other: Software Renewal ,te Item T ype Contract ❑ Amendment/Addendum E] Bid Award 0 Quote Award El C/O & PCA No. ❑ Traffic Control Company or Vendor Naive Azteca S New Vendor MBE/WBE Contractor Project Name Project Number Funding Source Account No. Amount Terms of Contract Purpose/Description uired Information All Submissions Proposal Special Purchase, QPA Req. to Advertise Reject Bids/Quotes ]' PCA E] Resolution Ease./Encroach Ye;sLJ If Yes, Approved by Purchasing No ❑ Title Sheei WBECompleted E-Verify Form Attached Nos Cityworks 2019 PLL software license add on and 2020 AMS and PLL annual renewal through Azteca Systems IT Overating .. ... . 279-0672-415.36-04 $92,625 1 Year 1-year software renewal for CityWorks software Amount of [J Increase $ _j Decrease ($ ) Previous Amount Current Percent of Change New Amount Total Percent of Change: Time Extension Amount: Increase % Decrease ( % Increase % Decrease mm........................% New Completion Date: