The URL can be used to link to this page

Home My WebLink AboutResolution - 2022-R0448 - Amendment 1 to Contract 14564 with Certegraph Systems LLCResolution No. 2022-RO448 Item No. 5.4 November 1, 2022 RESOLUTION BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF LUBBOCK: THAT the Mayor of the City of Lubbock is hereby authorized and directed to execute for and on behalf of the City of Lubbock, Amendment No. 1 to Contract No. 14564 for Enterprise Asset Management System, by and between the City of Lubbock and Cartegraph Systems, LLC, of Dubuque, Iowa, and related documents. Said Contract is attached hereto and incorporated in this resolution as if fully set forth herein and shall be included in the minutes of the City Council. Passed by the City Council on November 1, 2022 'a �- TRAY PAYN AYOR ATTEST: Rebe a Garza, City Sec APPROVED AS TO CONTENT: �— t Erik Rejino, Assistant City Manager �:.. •lrl�� • ��hL�) 7T� elli Leisure, Assistant City Attorney ccdocs/RES.Amend # 1 Contract 14564 -- Enterprise Asset Management System 10.18.22 Resolution No. 2022-RO448 Amendment 1 To Agreement Between The City of Lubbock, TX and Cartegraph Systems, LLC THIS IS THE FIRST AMENDMENT TO THE AGREEMENT dated and entered into on the 19th day of November 2019, Contract No. 14564, by and between the City of Lubbock ("City") and Cartegraph Systems, LLC, of Dubuque, Iowa ("Contractor'), collectively (the "Parties'). Contractor is providing an Enterprise Asset Management System for the City of Lubbock. NOW THEREFORE, the Parties enter into this amendment and agree as follows: The term of the original agreement is hereby extended for an additional three (3) years, and the Contractor shall provide services and at those certain prices as particularly described in "Exhibit A", attached to and incorporated herein. All other portions of the original Agreement and previous Amendments, if any, shall remain in place and are not altered by this amendment. IN WITNESS HEREOF, the parties have executed this Agreement as of this 1SL day of November 2022. CITY OF LUBBOCK Fk=:=- TRAYPA or ATTEST: , �, , " A� Re Garza, City Secre APPROVED AS TO CONTENT: Michael G. Keenum, P.E., Division Director of Engineering/City Engineer Cartegrap y emsJL Andr ingm , Chi inancial Of icer Page 1 of 2 APPROVED AS TO FORM: el i Leisure, Assistant City Attorney Page 2 of 2 City of Lubbock / 6/17/2022 Cartegraph Systems LLC 3600 Digital Drive Dubuque, IA 52003-8962 hftp://www.cartegraph.com Toll Free: (800) 688-2656 Phone: (563) 556-8120 Fax: (563) 556-8149 Cartegraph City of Lubbock Cartegraph Solutions Purchase Agreement Purchase Agreement: PA-21-03365 Date Prepared: 6/17/2022 Date of Expiration: 11 /19/2022 For any questions or assistance, please contact: Chad Walker Account Manager Phone: 563-587-3359 Mobile: +1 5635640441 Email: chadwalker@cartegraph.com Page 1 of 15 City of Lubbock / 6/17/2022 Purchase Agreement Cartegraph Systems LLC is pleased to present this Purchase Agreement for its world -class technology solutions. This Purchase Agreement is made and entered into between City of Lubbock (hereinafter referred to as "City of Lubbock", or "Customer") and Cartegraph Systems LLC (hereinafter referred to as "Cartegraph"), each referred to as a "Party" or collectively as the "Parties" and is effective when fully executed by both Parties ("Effective Date"). This Purchase Agreement 1) will exclusively govern Customer's access to and use of Solution Subscriptions and/or Solution Services; 2) is the complete and sole understanding and agreement between the Parties, and supersedes any oral or written proposal, agreement, or other communication between the Parties; 3) may only be modified or amended in writing as permitted herein; 4) is governed by the terms and conditions of the Cartegraph Solutions Agreement (Addendum A), unless: (i) otherwise set forth herein, or (ii) there is an applicable written Customer Agreement executed by the Parties that directly references this Purchase Agreement, for the Solutions referenced in this Purchase Agreement. Any inconsistency between the documents shall be resolved by giving precedence to 1) a Customer Agreement (if applicable), 2) this Purchase Agreement, and 3) the Cartegraph Solutions Agreement. The term of this Purchase Agreement shall begin on the Effective Date and continue until it is terminated as permitted herein. BY EXECUTING OR REFERENCING THIS PURCHASE AGREEMENT, THE PARTIES ACKNOWLEDGE THAT THEY HAVE REVIEWED THE TERMS AND CONDITIONS SET FORTH HEREIN AND IN ANY EXHIBITS, AND THE PARTIES AGREE TO BE LEGALLY BOUND BY SUCH AGREEMENT. CUSTOMER ADDRESS: LICENSEE ADDRESS: City of Lubbock City of Lubbock 1625 13th Street, Room # 107 1625 13th Street, Room # 107 Lubbock,Texas Lubbock,Texas 79457 79457 The following Addendums are attached to this Purchase Agreement and are incorporated by reference: ADDENDUM A - SOLUTIONS AGREEMENT can be found at www.cartegraph.com/solutions-agreement ADDENDUM B - SERVICES SCOPE OF WORK ADDENDUM C - Not Used ADDENDUM D - Not Used ADDENDUM E - CARTEGRAPH OMS EDITIONS ADDENDUM F - Not Used Page 2 of 15 City of Lubbock / 6/17/2022 Investment Summary The following represents the requested Solution Subscriptions and/or Solution Services along with their related durations (Terms). Term 01 - 11/19/2022 - 11/18/2023 - Services No. Product Code Quantity Price 1 Implementation Services Fleet implementation CGPFSV 1.00 USD 38,000.00 Term 01-11,19•'2022 - 11.181023 - Services TOTAL: USD 38,000.00 Term 01 - 11/19/2022 - 11/18/2023 - Subscription No. Product Code Quantity Price 1 SCF Marketplace App SCFMA 1 USD 8,110.00 2 SCF City 250,000 - 499,999 (includes 100 SCF users) SCCO25 1 USD 37,400.00 1 OMS Plus OMSPLS 1 USD 69,228.17 2 Facilities Domain DOM001 1 USD 23,416.45 3 Parks & Recreation Domain DOM004 1 USD 11,478.65 4 Sanitary Sewer Domain DOM005 1 USD 13,774.38 5 Signal Domain DOM006 1 USD 13,774.38 6 Stormwater Domain DOM007 1 USD 13,774.38 7 Transportation Domain DOM008 1 USD 20,661.57 8 Walkability Domain DOM009 1 USD 7,603.43 9 Wastewater Treatment Plant Domain DOM012 1 USD 26,171.32 10 Water Distribution Domain DOM010 1 USD 13,774.38 11 Water Treatment Plant Domain DOM011 1 USD 26,171.32 12 OMS User OMSUSR 375 USD 64,400.00 13 811 Integration 811 NORINT 1 USD 10,000.00 14 Asset Builder (option) OMSABD 1 USD 4,591.46 15 Integration Toolkit (option) OMSAPI 1 USD 6,887.19 16 Scenario Builder (option) OMSSCB 1 USD 9,182.92 17 Systems Integration Support SCADA Integration SYITSU 4 USD 12,600.00 18 Systems Integration Support Fuelmaster Integration SYITSU 1 USD 1,500.00 Term 01-11/1912022-11/19.2023 - Subscription TOTAL: USD 394,500.00 Page 3 of 15 City of Lubbock / 6/17/2022 Term 02 - 11/19/2023 - 11/18/2024 - Subscription No. Product 1 SCF Marketplace App 2 SCF City 250,000 - 499,999 (includes 100 SCF users) 1 OMS Plus 2 Facilities Domain 3 Parks & Recreation Domain 4 Sanitary Sewer Domain 5 Signal Domain 6 Stormwater Domain 7 Transportation Domain 8 Walkability Domain 9 Wastewater Treatment Plant Domain 10 Water Distribution Domain 11 Water Treatment Plant Domain 12 OMS User 13 811Integration 14 Asset Builder (option) 15 Integration Toolkit (option) 16 Scenario Builder (option) 17 Systems Integration Support SCADA Integration 18 Systems Integration Support Fuelmaster Integration Term 03 - 11/19/2024 - 11/18/2025 - Subscription Code Quantity Price SCFMA 1 USD 8,355.00 SCCO25 1 USD 38,522.00 OMSPLS 1 USD 71,324.80 DOM001 1 USD 24,118.94 DOM004 1 USD 11,823.01 DOM005 1 USD 14,187.61 DOM006 1 USD 14,187.61 DOM007 1 USD 14,187.61 DOM008 1 USD 21,281.42 DOM009 1 USD 7,810.05 DOM012 1 USD 26,956.46 DOM010 1 USD 14,187.61 DOM011 1 USD 26,956.46 OMSUSR 375 USD 66,332.00 811 NORINT 1 USD 10,300.00 OMSABD 1 USD 4,729.20 OMSAPI 1 USD 7,093.81 OMSSCB 1 USD 9,458.41 SYITSU 4 USD 12,978.00 SYITSU 1 1 1 USD 1,545.00 Term 02-11/19/2023 - 11'18 2024 -Subscription TOTAL: I USD 406,335.00 No. Product Code Quantity Price 1 SCF Marketplace App SCFMA 1 USD 8,605.00 2 SCF City 250,000 - 499,999 (includes 100 SCF users) SCCO25 1 USD 39,677.66 1 OMS Plus OMSPLS 1 USD 73,486.70 2 Facilities Domain DOM001 1 USD 24,842.51 3 Parks & Recreation Domain DOM004 1 USD 12,177.70 4 Sanitary Sewer Domain DOM005 1 USD 14,613.24 5 Signal Domain DOM006 1 USD 14,613.24 6 Stormwater Domain DOM007 1 USD 14,613.24 7 Transportation Domain DOM008 1 USD 21,919.86 8 Walkability Domain DOM009 1 USD 8,022.86 9 Wastewater Treatment Plant Domain DOM012 1 USD 27,765.16 10 Water Distribution Domain DOM010 1 USD 14,613.24 Page 4 of 15 City of Lubbock / 6/17/2022 No. Product Code Quantity Price 11 Water Treatment Plant Domain DOM011 1 USD 27,765.16 12 OMS User OMSUSR 375 USD 68,321.96 13 811 Integration 811NORINT 1 USD 10,609.00 14 Asset Builder (option) OMSABD 1 USD 4,871.08 15 Integration Toolkit (option) OMSAPI 1 USD 7,306.62 16 Scenario Builder (option) OMSSCB 1 USD 9,742.16 17 Systems Integration Support SCADA Integration SYITSU 4 USD 13,367.36 18 Systems Integration Support Fuelmaster Integration SYITSU 1 USD 1,591.35 Term 03-11/19/2024-11/18/2025 - Subscription TOTAL: USD 418,525.10 Summary By Term - Includes Services & Subscriptions Total Term 1 USD 432,500.00 Total Term 2 USD 406,335.00 Total Term 3 USD 418,525.10 Page 5 of 15 City of Lubbock / 6/17/2022 Investment Notes: • Any Customer Purchase Order, Contract, and/or Agreement must reference Cartegraph Purchase Agreement: PA-21-03365. • Purchasing the Solutions presented herein through any alternative procurement method will require a revised price proposal which may include an associated price adjustment. • Prices may include discounts, concessions, or incentives that are only applicable to this transaction and should not be assumed for future purchases. • Prices do not include any taxes that may apply at the time of invoicing. If applicable, any such taxes are the responsibility of Customer and will appear on the respective invoice. • Prices do not include any applicable Esri ArcGIS licenses. • Prices are in U.S. Dollars ($USD). • Prices for the Initial Term are valid only if this Purchase Agreement is executed by 11/19/2022. Page 6 of 15 City of Lubbock / 6/17/2022 Payment In consideration for the Solutions provided by Cartegraph to Customer, Customer agrees to pay Cartegraph the Fees as described below: DELIVERY Upon execution of this Purchase Agreement, Cartegraph will provide the Solution Subscriptions and/or Solution Services as detailed in the Investment Summary. SOLUTION SERVICES SCHEDULING Solution Services will be scheduled and delivered upon your acceptance of this Purchase Agreement, which will be considered your notification for Cartegraph to proceed. Customer agrees to work with Cartegraph to schedule Services in a timely manner. All undelivered Services shall expire 365 days from the signing of this Purchase Agreement unless indicated differently in the Investment Notes. SOLUTION SUBSCRIPTION INVOICING Customer shall be provided with the ability to access and use the Solution Subscriptions upon execution of this Purchase Agreement. The payment for the initial term is due upon execution of the Purchase Agreement. Payment for any subsequent renewal terms will be due in annual installments as specified herein and prior to the anniversary of the initial term in the amount(s) that follow: • Term 1: $394,500.00 • Term 2: $406,334.99 • Term 3: $418,525.10 SOLUTION SERVICES INVOICING Upon acceptance of this Purchase Agreement, invoicing for the Solution Services shall occur as follows: • 25% upon execution of this Agreement. • 25% 3 months from execution of this Agreement. • 25% 4 months from execution of this Agreement. • 25% 6 months from execution of this Agreement. PAYMENT All payments are due Net 30 days from date of invoice. All payments are to be in U.S. Dollars ($USD). For customers within the United States, any applicable taxes required at the time of invoice will be determined based on the laws and regulations of the taxing authority(s) governing the "Customer Address" identified herein. Page 7 of 15 DocuSign Envelope ID: 615A8B83-8024-403F-8282-8A45A652128C City of Lubbock / 6/17/2022 Acceptance BY SIGNING BELOW, EACH PARTY AGREES THAT 1) ITS SIGNATORY HAS THE AUTHORITY TO BIND THEIR PARTY TO THIS OBLIGATION, AND 2) THAT ALL USE AND ACCESS TO THE SOLUTION SUBSCRIPTION AND/OR SOLUTION SERVICES DESCRIBED HEREIN SHALL BE GOVERNED BY THE TERMS AND CONDITIONS IN THE FOLLOWING ORDER OF PRECEDENCE A) A CUSTOMER AGREEMENT (IF APPLICABLE), B) THIS PURCHASE AGREEMENT AND ALL AGREEMENTS AND ADDENDUMS SPECIFICALLY REFERENCED HEREIN, AND C) THE CARTEGRAPH SOLUTIONS AGREEMENT. Cartegraph Systems LLC: DocuSigned by: EaKlBNED8C354AF I�t.�.Yt,W V U�t.I�► PJA, By: . (Signature) Andrew Dingman (Print Name) Title: CFO Date: 10/11/2022 1 11:49 AM CDT City of Lubbock: By: . La'�� (Signature) T(Print Name) Title: J Y�rac,�a< <„k �rC,4, C6, V% � Date: 10 / IV/1-VI Page 8 of 15 Addendum B Services Scope of Work The Solutions Services listed in the Investment Summary of the Purchase Agreement are specific Cartegraph services which will be delivered to the Customer based on the descriptions below and are subject to the limitations and terms and conditions set for the in the Purchase Agreement, and its reverence Addendums. Cartegraph will coordinate with the Customer on service delivery expectations and timeframes. Cartegraph OMS — Implementation Scope of Work Implementation of the Operations Management System (OMS) includes the following professional services: Setup • Cartegraph will setup a hosted, test and production OMS environment. • Cartegraph will provide an overview, up to two (2) hours, of Cartegraph and ArcGIS Online user -based logins and User/Role functionality. • Cartegraph will provide a template file to be utilized by your staff to populate Roles and Users to be utilized for OMS. • Cartegraph will utilize the template to create users and roles in OMS. (Note: Subsequent User and/or Role changes will be your administrator's responsibility.) • Cartegraph will setup the OMS Platform, including the Request, Work, and Resource areas of the software. Asset Management solutions will be setup for all solutions referenced in the Assets section of the scope unless otherwise noted. Consulting Cartegraph will provide a remote requirement gathering workshops, a total of four (4) hours to increase our understanding of your business and functional goals. Through workshops and interviews, Cartegraph will identify best fit scenarios for OMS and provide a brief including any challenges as well as recommendations for OMS best practices relevant to your implementation. Configurations Cartegraph will provide configuration services, including: o Up to five (5) custom fields o Up to ten (10) custom fields and up to five (5) custom layouts to be utilized in any of the shared areas of the system, such as Tasks o Up to five (5) automations o Up to five (5) preventative maintenance plans Training Cartegraph will provide remote train -the -trainer training, up to four (4) hours, on overall system navigation and functionality to help familiarize your staff with the software environment and its common functions. Training topics include: o Dashboards o Standard KPI/ROI Gadgets o Logins/Permission o Layers Addendum B Page 9 of 15 o Filters o Maps o Grids o System Navigation o Views (List & Detail) o Standard Reports o Attachments o Requests, Work, Resources, Reports, and Administrator Tabs • Cartegraph will provide a remote "train -the -trainer" training event, up to eight (8) hours. The training agenda will be defined and agreed upon by both Cartegraph and your project manager. Topics may include any of the following: Request Management: • Requests ■ Requesters ■ Task Creation from Requests ■ Issue library (including settings such as Applies to Asset and Non -Location) ■ Cartegraph recommended best practices for Request and Requester Management a Work Management: ■ Create Task(s) ■ Assignments (Add, Edit, Remove) ■ Task Menu Actions • Related Work Items ■ Create Work Order ■ Associate Task to WO ■ Repeat Work Orders ■ Work Order Menu Actions ■ Enter Resources ■ Timesheets ■ Activity library (including settings such as Applies to Asset, Inspection, Key Dates, Cost, and Productivity) ■ Cartegraph recommended best practices for Work Management c. Fleet Management: ■ Preventative Maintenance ■ Task Management ■ Vehicle Replacement Ratings (VRR) Equipment Detail information ■ Fleet Reports ■ Cartegraph recommended best practices for Fleet Management o Cartegraph Mobile: ■ Overall system functionality (Navigation, Interface, Maps, Attachments, Sorting) ■ Work Management • Create and Update Tasks • Assign Tasks • Enter Resources • Inspections ■ Request Management • View and Update Requests • View Requester information • Create Task from Request ■ Cartegraph recommended best practices for mobile device use o Administrator: • Administrator: Addendum B Page 10 of 15 • User Administration, Role Administration, Record Filter Administration, Import/Export, Scheduled Process Log, Error Log Settings: • System Settings Manager: • Layout Manager, Library Manager, Preventative Maintenance, Asset Condition Manager, Notification Manager, Structure Manager, Automation Manager • Cartegraph will provide remote train -the -trainer training, up to four (4) hours, on Preventative Maintenance Plans functionality. Training topics include: o Preventative Maintenance o Cartegraph recommended best practices for proactive asset management To avoid redundancy, and to utilize service time efficiently, training may cover a subset of the assets listed in the Asset section of the scope. Go -Live Support Cartegraph will provide up to two (2) remote web conferences (not to exceed 4 hours total) to be utilized for Go -Live Support. The agenda will be defined, and agreed upon, by both your and Cartegraph's project managers. Topics may include any of the following: o Refresher training for items listed in the scope of work o Software and process support for staff during production roll out o Field, Layout, and Report configuration guidance, if applicable Data Services Cartegraph will provide one test and one production data load service through standard import/export functionality. Cartegraph will provide template documents for data population. Once populated by your staff, Cartegraph will load the data into your test or production OMS environment. Data loads may include data such as: o Parent level asset records o Asset location (spatial x/y) attributes o Parent level resource (Labor, Equipment Material, Vendor) records o Resource Rate (Labor, Equipment, Material) records o Standard system libraries Cartegraph will provide one test and one production custom data conversion service for your historical data listed below: o JD Edwards data related to: Fleet equipment, Work History, Inspection History o For the custom data conversion service(s) listed above, Cartegraph will provide: ■ A review of the historical data along with recommendations for OMS best fit. ■ A field map workshop, which will identify where and how historical data will appear within OMS ■ A test conversion service to facilitate data conversion validation and testing ■ One revision of the field map used for the test conversion service ■ A production conversion service utilizing the final, approved field map All data must be accessible to Cartegraph from a SQL DB, SQL View, Access DB or Comma Delimited File. Integration Services Addendum B Page 11 of 15 Cartegraph staff will provide a uni-directional (one-way) Integration Service between FuelMaster and Cartegraph. The integration includes: o A one-way integration of data from the source system to Cartegraph o Up to 12 fields in the same Cartegraph recordset (IE: Equipment table and Equipment's Fuel Log table) o A sync using a unique ID ■ If ID exists; information will be updated ■ If ID does not exist; Cartegraph will create a record or produce an error message o A customer -configurable runtime interval for the sync All data must be accessible to the Cartegraph service from a SQL DB, SQL View, or a Comma Delimited File Assets Asset implementation includes the following professional services: Cartegraph will provide installation and training on the following one (1) asset type: r.. Fleet (1) Cartegraph will provide all services remotely via audio; video; and web conferences unless otherwise noted. Exclusions The following service items are not included in the scope of this project: Implementation of any custom modification or integration developed by Cartegraph; your internal staff; or any third -party is not included in the scope of this project unless specifically listed above. Data conversion services from other software system(s) or sources (including Cartegraph Navigator databases) are not included in the scope of this project unless specifically listed above. Any service items discussed during demonstrations; conference calls; or other events are not included in the scope of this project unless specifically listed above. Customer/Cartegraph Responsibilities Project representatives from Customer and Cartegraph accepts responsibility for all aspects of project planning, management, and execution not specifically identified as the responsibility of Cartegraph in the Agreement or in the Purchase Agreement. Ongoing management of the day-to-day allocation of Customer and Cartegraph resources and management of project tasks is the responsibility of the Customer and Cartegraph project representatives. Customer and Cartegraph project representatives will provide overall guidance and direction for the project and will direct the project accordingly. Further, and with regard to the Cartegraph obligations listed in this Purchase Agreement, Customer understands that it is vital to the success of the project that Customer provides assistance in the following matters: 1. For those services listed under Field Services, Cartegraph personnel will conduct information gathering and evaluation sessions with various Customer Users and management. While Cartegraph respects the time and workload of Customer staff, dedicated time on the part of the appropriate Customer resources is necessary to complete these exercises. 2. The installation process requires the assistance of Customer personnel and suitable access to hardware and systems (e.g., security clearance). Customer is required to supervise the installation process while systems are accessible to Cartegraph. All hardware and software, for both personal computers and servers, is expected to be available, installed, and operating as specified in Cartegraph's system requirements documentation such that delivery and execution of Cartegraph Field Services will not be impeded. Addendum B Page 12 of 15 3. Customer and Cartegraph understand that the successful performance of Field Services depends upon Customer fulfilling its responsibilities. The Project assumes that Customer will provide all personnel required to achieve a successful implementation, including a dedicated project manager responsible for reviewing the implementation scope of work, ensuring all attended meetings are attended by invited staff, and providing leadership and insight on all relevant internal issues such as policy/procedure, organizational structure, project stakeholders, technical architecture, data, and current systems. Customer responsibility also includes internal documentation, internal change management, task completion, staff coordination and schedule commitment. 4. Customer will provide Internet access and IT staff support as required. For those services that are web -based, Cartegraph utilizes WebEx Meeting (or similar) technology. 5. Customer shall ensure that their workstation platform and database meet Cartegraph system requirements as specified in the Cartegraph System Requirements documentation. Solutions will be supported within new versions of these workstation platforms and databases within a reasonable period of time from their release from their manufacturer. Cartegraph will discontinue support of its Solutions within older versions of these workstation platforms and databases as their support is discontinued by their manufacturers. 6. Customer agrees to work with Cartegraph to schedule Field Services in a timely manner. All undelivered Field Services shall expire 365 days from the execution of this Purchase Agreement, unless noted differently in Services Scope listed above. Upon expiration of services, the project may be cancelled at Cartegraph's discretion. Not -to -Exceed Purchase Agreement Cartegraph will not exceed the total included in this Purchase Agreement without written approval from Customer. In the event it becomes apparent to Cartegraph that additional Service will be needed due to any changes in the scope of this Purchase Agreement, Cartegraph will notify Customer prior to exceeding the approved efforts and obtain written approval if additional Services are required. Addendum B Page 13 of 15 City of Lubbock / 6/17/2022 ADDENDUM E Cartegraph OMS Editions Cartegraph OMS supports customers in the operation, maintenance, and management of the following asset domains. By employing these features as applicable, customers can effectively manage and report on the assets that they care about. Indicated below are the capabilities and options available for each OMS Edition at the time this document was prepared, which are subject to change. Essentials Pro Plus Premium Included Included Included Included Dashboard / Home Screen Included Included Included Included User Management Included Included Included Role Management Included Included Included Included Esri GIs Integraton Included Included Included Included Report Viewer Included Included Included Included Library Management Included Included Included Included Standard KPI / ROI gadgets Included Included Included Included Esri Identity -Ready Included Included Included Structure Manager Included Included Included Layout Manager Included Included Included Import / Export Included Included Included Record Filter Administration Included Included Included Included Container / Component Included Included Included Included Embedded Maps Included Included Included Report Designer Option Option Included Integration Toolkit Option Opton Included Included Cartegraph for Zapier Included Included Automation Manager Included Included Included Notification Manager Included Included Included Included Routing — Esri Identity Required Included Included Included Included Geocode Options- Esri Identity Required Work ask Management I Included Included Included Included Page 14 of 15 City of Lubbock / 6/17/2022 Work Orders Include.: Included Task Calendar Included Includ .s Included Included Scenario Builder Option Included Request Request Management Required w/ SeeClickFix Included Included Included eeClickFix Option Option Option Option Internal Requests Option Included Included Resources Resource Management (LEMV) Included Included Included Included Advanced Material Management Option Included Fleet Management Option Included Included Assets Asset Inventory By Domain/Asset By Domain/Asset By Domain/Asset By Domain/Asset Container / Component Included Included Included Included Preventative Maintenance Plans Included Included Included Asset Condition Manager / Advanced Required w/ Fleet Mgmt. Included Included Inspections Asset Builder Option Option Included Page 15 of 15 CERTIFICATE OF INTERESTED PARTIES FORM 1295 1 of 1 Complete Nos. 1 - 4 and 6 if there are interested parties. OFFICE USE ONLY Complete Nos. 1, 2, 3, 5, and 6 if there are no interested parties. CERTIFICATION OF FILING Certificate Number: 1 Name of business entity filing form, and the city, state and country of the business entity's place of business. 2022-949699 Cartegraph Systems LLC Dubuque, IA United States Date Filed: 10/28/2022 2 Name of governmental entity or state agency that is a party to the contract for which the form is being filed. City of Lubbock Date Acknowledged: 11/02/2022 3 Provide the identification number used by the governmental entity or state agency to track or identify the contract, and provide a description of the services, goods, or other property to be provided under the contract. PA-21-03365 Operations Management Software & Services 4 Name of Interested Party City, State, Country (place of business) Nature of interest (check applicable) Controlling Intermediary 5 Check only if there is NO Interested Party. ❑ X 6 UNSWORN DECLARATION My name is and my date of birth is My address is (street) (city) (state) (zip code) (country) I declare under penalty of perjury that the foregoing is true and correct. Executed in County, State of on the day of , 20 (month) (year) Signature of authorized agent of contracting business entity (Declarant) Forms provided by Texas Ethics Commission www.ethics.state.tx.us Version V3.5.1.dlb92728