Loading...
HomeMy WebLinkAbout21-084 - Transpo Group - On-Call GIS Support Servicest City of Tukwila 6200 Southcenter Boulevard, Tukwila WA 98188 Agreement Number: 21-084(b) CONTRACT FOR SERVICES Amendment #2 Between the City of Tukwila and Transpo Group That portion of Contract No. 21-084 between the City of Tukwila and Transpo Group is hereby amended as follows: Section 1. Scope and Schedule Additional scope of work as shown in the attached Exhibit A. — 2022 GIS Services Scope of Work Section 2. Compensation Increase compensation by $18,000 for a new Not -to -exceed total of $37,000. Reference attached Exhibit A. — 2022 GIS Services Scope of Work Section 4. Duration of the Agreement. This agreement shall be in full force and effect for a period commencing May 24, 2021 and ending December 31, 2022, unless sooner terminated under the provisions hereinafter specified. All other provisions of the contract shall remain in full force and effect. Dated this 23rd day of March , 2022. CITY OF TUKWILA HP Key: aY,a11,52,10,balc,a22,,,,,ISIDO Allan Ekberg, Mayor 03/24/2022 CONTRACTOR Patrick B. Lynch 2022.03.2312:35:42-07'00' Printed Name: Patrick Lynch ATTEST/AUTHENTICATED APPROVED AS TO FORM Key: 0002,1a1,5,1tlebea,15,11fe0.32.1.0 Christy O'Flaherty, MMC, City Clerk Office of the City Attorney CA Reviewed May 2020 Page 1 of 1 Service Agreement City of Tukwila On -Call GIS Support Services Exhibit A - 2022 GIS Services Scope of Work Date March 8, 2022 Purpose On -Call GIS Services & Support: To support existing City staff with prioritized GIS workload; maintenance of ArcGIS Enterprise (Server, Portal for ArcG IS, Web Adaptors) and Web Map Applications; provide any other technical support on the City's ArcGIS Enterprise infrastructure, ArcGIS Online, and ArcGIS software; to provide GIS training, as needed. Scope of Service Task 1A— Prioritized List GIS Support Services for Prioritized Work List A. Provide GIS support services to support the prioritized work list, which includes data review, development support, data migration, knowledge transfer, documentation, and training to City Staff, as needed Agency/Client Support • Access to GIS data, as needed • Access to CityArcGIS Online account • Remote access to GIS workstation/VM and content • Remote access to ArcGIS Enterprise (Server/Portal) and content • Other support from City GIS / IT Staff, as needed Consultant Deliverables • As determined by the City For cost estimate — assumed up to 8 development/support hours per week for 13 weeks. Draft work list (priority to be set by City): o Assisting to create a Data hub for downloading GIS data (reducing the time spent to fulfill records requests) o Developing Scripting for pushing data from TukPW to GIS warehouse (automating the process) o ADA web app finalization/transitioning/ and training for Deontae o Map service symbology for differentiation of public vs private storm assets in Collector and iMap o Determining process, and provide training, for editing and updating data (Jaimie/Russell) o Setting up distributed collaboration between Tukwila Portal and AGO (sharing data and/or services across both) o Consulting/planning/assisting to incorporate NPDES CAD data into GIS o Planning/Assistance with ArcGIS Enterprise 10.7.1 upgrade to 10.8.1 o Consulting on best practices for ArcGIS Enterprise, integration of data deliveries (Otak or others), updates to warehouse, synchronization of data. o Continuous training and support on ArcGIS Online, GIS Portal, ArcGIS Pro, and other GIS needs. uranspor ;. trairn spoG 11 PAGE 1 Agency Signature: Date: uransp©`s,r trairn sr.: c)G 11 PAGE 2 Task 1B— Maintenance/Configuration of existing ArcGIS Enterprise software infrastructure, Online Map Viewers, and Web Map Applications B. Provide GIS support services to assist with maintenance of existing version of the GIS server software infrastructure (currently 10.3.1); Provide GIS technical support related to ArcGIS Enterprise (currently 10.7.1). Technical assistance with maintenance and configuration of ArcGIS Enterprise 10.7.1 or higher (Server/Portal), ArcGIS Data Store, Web Adaptors; Provide GIS technical support and training to configure ArcGIS Pro, ArcGIS for Desktop applications to connect to ArcGIS Enterprise, and SQL Enterprise Geodatabase. Provide GIS support services to assist with maintaining (current and future) map viewers and interactive map applications. This includes development, web publishing support, and training to City Staff, as needed. Agency/Client Support • Access to GIS data from existing GIS Server, if needed • Access to CityArcGIS Online account • Remote access to ArcG IS Enterprise (Server/Portal) 10.7.1 • Remote access to GIS Server 10.3.1, if needed • Access to SQL Server instance, as needed • Other support from City GIS / IT Staff, as needed Consultant Objectives • Up to date maintenance and security of ESRI ArcGIS Enterprise Technology • Fully operational web maps, map viewers, and interactive map applications For cost estimate — assumed in weekly development/support hours Task 1C — Miscellaneous GIS Support Services C. Provide miscellaneous GIS support services, which includes development support, data migration, knowledge transfer, documentation, and training to City Staff, as needed Agency/Client Support • Access to GIS data, as needed • Access to CityArcGIS Online account • Required security rig hts to GIS hardware infrastructure • Remote access to ArcGIS Enterprise (Server/Portal) and content • Other support from City GIS / IT Staff, as needed Consultant Deliverables • As determined by the City For cost estimate — assumed in weekly development/support hours Budget Not to exceed $18,000, includes virtual meetings / remote work Estimate Schedule As needed basis until contract end date Agency Signature: Date: uransp©`s,r trairn sr.: c)G 11 PAGE 2 City of Tukwila 6200 Southcenter Boulevard, Tukwila WA 98188 Agreement Number: 21-084(a) Council Approval N/A CONTRACT FOR SERVICES Amendment #1 Between the City of Tukwila and Transpo Group That portion of Contract No. 21-084 between the City of Tukwila and Transpo Group is hereby amended as follows: Section 4. Duration of Agreement. This Agreement shall be in full force and effect for a period commencing May 24, 2021, and ending March 31, 2022, unless sooner terminated under the provisions hereinafter specified. All other provisions of the contract shall remain in full force and effect. Dated this 13th day of December , 2021. CITY OF TUKWILA CONTRACTOR Hari Ponnekanti, PW Director CA Revised May 2020 ��• 2021.12.09 Patrick B. Lynch By: 10:11:32-08'00' Printed Name and Title: Patrick B. Lynch, Principal Address: 12131 113th Ave NE, Suite 203 Kirkland, WA 98034 Page 1 of 1 City of Tukwila 6200 Southcenter Boulevard, Tukwila WA98188 CONTRACT FOR SERVICES Contract Number: 21-084 Council Approval N/A This Agreement is entered into by and between the City of Tukwila, Washington, a non -charter optional municipal code city hereinafter referred to as "the City," and Transpo Group , hereinafter referred to as "the Contractor," whose principal office is located at 12131 113th Ave NE, Suite 203 Kirkland WA 98034 WHEREAS, the City has determined the need to have certain services performed for its citizens but does not have the manpower or expertise to perform such services; and WHEREAS, the City desires to have the Contractor perform such services pursuant to certain terms and conditions; now, therefore, IN CONSIDERATION OF the mutual benefits and conditions hereinafter contained, the parties hereto agree as follows: . Scoae and Schedule of Services to be Performed by Contractor. The Contractor shall perform those services described on Exhibit A attached hereto and incorporated herein by this reference as if fully set forth. In performing such services, the Contractor shall at all times comply with all Federal, State, and local statutes, rules and ordinances applicable to the performance of such services and the handling of any funds used in connection therewith. The Contractor shall request and obtain prior written approval from the City if the scope or schedule is to be modified in any way. 2. Comaensation and Method of Payment. The City shall pay the Contractor for services rendered according to the rate and method set forth on Exhibit B attached hereto and incorporated herein by this reference. The total amount to be paid shall not exceed $19,000 at a rate of see fee schedule 3. Contractor Budaet. The Contractor shall apply the funds received under this Agreement within the maximum limits set forth in this Agreement. The Contractor shall request prior approval from the City whenever the Contractor desires to amend its budget in any way. 4. Duration of Aareement. This Agreement shall be in full force and effect for a period commencing May 24 , 2021, and ending December 31 , 2021 , unless sooner terminated under the provisions hereinafter specified. 5. jndeaendent Contractor. Contractor and City agree that Contractor is an independent contractor with respect to the services provided pursuant to this Agreement. Nothing in this Agreement shall be considered to create the relationship of employer and employee between the parties hereto. Neither Contractor nor any employee of Contractor shall be entitled to any benefits accorded City employees by virtue of the services provided under this Agreement. The City shall not be responsible for withholding or otherwise deducting federal income tax or social security or contributing to the State Industrial Insurance Program, or otherwise assuming the duties of an employer with respect to the Contractor, or any employee of the Contractor. 6. jndemnification. The Contractor shall defend, indemnify and hold the Public Entity, its officers, officials, employees and volunteers harmless from any and all claims, injuries, damages, losses or suits including attorney fees, arising out of or in connection with the performance of this Agreement, except for injuries and damages caused by the sole negligence of the Public Entity. CA Revised May 2020 Page 1 of 4 Should a court of competent jurisdiction determine that this Agreement is subject to RCW 4.24.115, then, in the event of liability for damages arising out of bodily injury to persons or damages to property caused by or resulting from the concurrent negligence of the Contractor and the Public Entity, its officers, officials, employees, and volunteers, the Contractor's liability hereunder shall be only to the extent of the Contractor's negligence. It is further specifically and expressly understood that the indemnification provided herein constitutes the Contractor's waiver of immunity under Industrial Insurance, Title 51 RCW, solely for the purposes of this indemnification. This waiver has been mutually negotiated by the parties. The provisions of this section shall survive the expiration or termination of this Agreement. 7. Insurance. The Contractor shall procure and maintain for the duration of the Agreement, insurance against claims for injuries to persons or damage to property which may arise from or in connection with the performance of the work hereunder by the Contractor, their agents, representatives, employees or subcontractors. Contractor's maintenance of insurance, its scope of coverage and limits as required herein shall not be construed to limit the liability of the Contractor to the coverage provided by such insurance, or otherwise limit the City's recourse to any remedy available at law or in equity. A. Minimum Scope of Insurance. Contractor shall obtain insurance of the types and with the limits described below: 1. Automobile Liability insurance with a minimum combined single limit for bodily injury and property damage of $1,000,000 per accident. Automobile liability insurance shall cover all owned, non -owned, hired and leased vehicles. Coverage shall be written on Insurance Services Office (ISO) form CA 00 01 or a substitute form providing equivalent liability coverage. If necessary, the policy shall be endorsed to provide contractual liability coverage. 2. Commercial General Liability insurance with limits no less than $2,000,000 each occurrence, $2,000,000 general aggregate and $2,000,000 products -completed operations aggregate limit. Commercial General Liability insurance shall be as least at broad as ISO occurrence form CG 00 01 and shall cover liability arising from premises, operations, independent contractors, products -completed operations, stop gap liability, personal injury and advertising injury, and liability assumed under an insured contract. The Commercial General Liability insurance shall be endorsed to provide a per project general aggregate limit using ISO form CG 25 03 05 09 or an equivalent endorsement. There shall be no exclusion for liability arising from explosion, collapse or underground property damage. The City shall be named as an additional insured under the Contractor's Commercial General Liability insurance policy with respect to the work performed for the City using ISO Additional Insured endorsement CG 20 10 10 01 and Additional Insured -Completed Operations endorsement CG 20 37 10 01 or substitute endorsements providing at least as broad coverage. 3. Workers' Compensation coverage as required by the Industrial Insurance laws of the State of Washington. B. Public Entity Full Availability of Contractor Limits. If the Contractor maintains higher insurance limits than the minimums shown above, the Public Entity shall be insured for the full available limits of Commercial General and Excess or Umbrella liability maintained by the Contractor, irrespective of whether such limits maintained by the Contractor are greater than those required by this Contract or whether any certificate of insurance furnished to the Public Entity evidences limits of liability lower than those maintained by the Contractor. C. Other Insurance Provision. The Contractor's Automobile Liability and Commercial General Liability insurance policies are to contain, or be endorsed to contain that they shall be primary insurance with respect to the City. Any insurance, self-insurance, or insurance pool coverage maintained by the City shall be excess of the Contractor's insurance and shall not contribute with it. D. Acceptability of Insurers. Insurance is to be placed with insurers with a current A.M. Best rating of not less than A: VII. CA Revised May 2020 Page 2 of 4 E. Verification of Coverage. Contractor shall furnish the City with original certificates and a copy of the amendatory endorsements, including but not necessarily limited to the additional insured endorsement, evidencing the insurance requirements of the Contractor before commencement of the work. Upon request by the City, the Contractor shall furnish certified copies of all required insurance policies, including endorsements, required in this Agreement and evidence of all subcontractors' coverage. F. Subcontractors. The Contractor shall cause each and every Subcontractor to provide insurance coverage that complies with all applicable requirements of the Contractor -provided insurance as set forth herein, except the Contractor shall have sole responsibility for determining the limits of coverage required to be obtained by Subcontractors. The Contractor shall ensure that the Public Entity is an additional insured on each and every Subcontractor's Commercial General liability insurance policy using an endorsement as least as broad as ISO CG 20 10 10 01 for ongoing operations and CG 20 37 10 01 for completed operations. G. Notice of Cancellation. The Contractor shall provide the City and all Additional Insureds for this work with written notice of any policy cancellation, within two business days of their receipt of such notice. H. Failure to Maintain Insurance. Failure on the part of the Contractor to maintain the insurance as required shall constitute a material breach of contract, upon which the City may, after giving five business days notice to the Contractor to correct the breach, immediately terminate the contract or, at its discretion, procure or renew such insurance and pay any and all premiums in connection therewith, with any sums so expended to be repaid to the City on demand, or at the sole discretion of the City, offset against funds due the Contractor from the City. 8. Record Keeaina and Reaortina. A. The Contractor shall maintain accounts and records, including personnel, property, financial and programmatic records which sufficiently and properly reflect all direct and indirect costs of any nature expended and services performed in the performance of this Agreement and other such records as may be deemed necessary by the City to ensure the performance of this Agreement. B. These records shall be maintained for a period of seven (7) years after termination hereof unless permission to destroy them is granted by the office of the archivist in accordance with RCW Chapter 40.14 and by the City. 9. Audits and Insoections. The records and documents with respect to all matters covered by this Agreement shall be subject at all times to inspection, review or audit by law during the performance of this Agreement. 10. Termination. This Agreement may at any time be terminated by the City giving to the Contractor thirty (30) days written notice of the City's intention to terminate the same. Failure to provide products on schedule may result in contract termination. If the Contractor's insurance coverage is canceled for any reason, the City shall have the right to terminate this Agreement immediately. 11. Discrimination Prohibited. The Consultant, with regard to the work performed by it under this Agreement, will not discriminate on the grounds of race, religion, creed, color, national origin, age, veteran status, sex, sexual orientation, gender identity, marital status, political affiliation, the presence of any disability, or any other protected class status under state or federal law, in the selection and retention of employees or procurement of materials or supplies. 12. Assianment and Subcontract. The Contractor shall not assign or subcontract any portion of the services contemplated by this Agreement without the written consent of the City. 13. Entire Aareement: Modification. This Agreement, together with attachments or addenda, represents the entire and integrated Agreement between the City and the Contractor and supersedes all prior negotiations, representations, or agreements written or oral. No amendment or modification of this Agreement shall be of any force or effect unless it is in writing and signed by the parties. CA Revised May 2020 Page 3 of 4 14. Severabilitv and Survival. If any term, condition or provision of this Agreement is declared void or unenforceable or limited in its application or effect, such event shall not affect any other provisions hereof and all other provisions shall remain fully enforceable. The provisions of this Agreement, which by their sense and context are reasonably intended to survive the completion, expiration or cancellation of this Agreement, shall survive termination of this Agreement. 15. Notices. Notices to the City of Tukwila shall be sent to the following address: City Clerk, City of Tukwila 6200 Southcenter Blvd. Tukwila, Washington 98188 Notices to the Contractor shall be sent to the address provided by the Contractor upon the signature line below. 16. Applicable Law: Venue: Attorney's Fees. This Agreement shall be governed by and construed in accordance with the laws of the State of Washington. In the event any suit, arbitration, or other proceeding is instituted to enforce any term of this Agreement, the parties specifically understand and agree that venue shall be properly laid in King County, Washington. The prevailing party in any such action shall be entitled to its attorney's fees and costs of suit. DATED this 24th day of May , 20 21 CITY OF TUKWILA CONTRACTOR eGicfrecl Hari Ponnekanti, PW Director By: Printed Name and Title: Patrick B. Lynch, Principal Address: 12131 113th Ave NE, Suite 203 Kirkland, WA 98034 CA Revised May 2020 Page 4 of 4 Service Agreement City of Tukwila On -Call GIS Support Services Exhibit A - 2021 GIS Services Scope of Work Date May 10, 2021 Purpose On -Call GIS Services & Support: To support existing City staff with prioritized GIS workload; maintenance of ArcGIS Enterprise (Server, Portal for ArcGIS, Web Adaptors) and Web Map Applications; provide any other technical support on the City's ArcGIS Enterprise infrastructure, ArcGIS Online, and ArcGIS software; to provide GIS training, as needed. Scope of Service Task 1A — Prioritized List GIS Support Services for Prioritized Work List A. Provide GIS support services to support the prioritized work list, which includes data review, development support, data migration, knowledge transfer, documentation, and training to City Staff, as needed Agency/Client Support • Access to GIS data, as needed • Access to City ArcGIS Online account • Remote access to GIS workstation/VM and content • Remote access to ArcGIS Enterprise (Server/Portal) and content • Other support from City GIS / IT Staff, as needed Consultant Deliverables • As determined by the City For cost estimate — assumed up to 10 development/support hours per week for 12 weeks. Draft work list (priority to be set by City): o Assist finalizing transition of GIS data from old environment to new warehouse and portal. o Preparation for Lucity upgrade, Portal services connection instead of direct SQL connection to SQL server and enterprise geodatabase. o Assist with creation of map viewer for as -built project, and franchise project. o Identify as -built meta data, update logs, create polygon on map viewer, link to as -built files. o Improve Tukwila iMap (Public) to include new data connections to GIS Portal and map services and incorporating new DCD layers. o Consulting on best practices for ArcGIS Enterprise, integration of data deliveries, updates to warehouse, synchronization of data. o Continuous training and support on ArcGIS Online, GIS Portal, ArcGIS Pro, and other GIS needs. Task 1B — Maintenance/Configuration of existing ArcGIS Enterprise software infrastructure, Online Map Viewers, and Web Map Applications tsansspo PAGE 1 Agency Signature: Date: tsansspo PAGE 2 B. Provide GIS support services to assist with maintenance of existing version of the GIS server software infrastructure (currently 10.3.1); Provide GIS technical support related to ArcGIS Enterprise. Technical assistance with maintenance and configuration of ArcGIS Enterprise 10.7.1 or higher (Server/Portal), ArcGIS Data Store, Web Adaptors; Provide GIS technical support and training to configure ArcGIS Pro, ArcGIS for Desktop applications to connect to ArcGIS Enterprise, and SQL Enterprise Geodatabase. Provide GIS support services to assist with maintaining (current and future) map viewers and interactive map applications. This includes development, web publishing support, and training to City Staff, as needed. Agency/Client Support • Access to GIS data from existing GIS Server, if needed • Access to City ArcGIS Online account • Remote access to ArcGIS Enterprise (Server/Portal) • Remote access to GIS Server 10.3.1, if needed • Access to SQL Server instance, as needed • Other support from City GIS / IT Staff, as needed Consultant Objectives • Up to date maintenance and security of ESRI ArcGIS Enterprise Technology • Fully operational web maps, map viewers, and interactive map applications For cost estimate — assumed in weekly development/support hours Task IC — Miscellaneous GIS Support Services C. Provide miscellaneous GIS support services, which includes development support, data migration, knowledge transfer, documentation, and training to City Staff, as needed Agency/Client Support • Access to GIS data, as needed • Access to City ArcGIS Online account • Required security rights to GIS hardware infrastructure • Remote access to ArcGIS Enterprise (Server/Portal) and content • Other support from City GIS / IT Staff, as needed Consultant Deliverables • As determined by the City For cost estimate — assumed in weekly development/support hours Budget Not to exceed $19,000, includes virtual meetings / remote work Estimate Schedule As needed basis until contract end date Agency Signature: Date: tsansspo PAGE 2 anspo Cost Estimate Worksheet EXHIBIT B Number / Project Name Only key staff are shown and other staff may work on and charge to the p oject as needed by the project manager. Labor: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Rei 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 initials job title cost rate GIS Manager GIS Analyst GIS Tech 11111111111111111111111111111111111111111111111111111111111111111111000000 Project Admin ^bby�eei1111 119 lllllll 11111111111111111 $18,920 Miscellaneous GIS Support Services (1A, 1B, 1C) li Anyl L4 Anyl L2 Anyl L1 PA L3 $160.00 $100.00 $85.00 Reproductions $100.00 IW' ,LIl11,i�0hlllllllludlll1 W0000 117 X1111111100000011 11111111111111111111111111111111111111111111111111111111111111111111000000 Business Meals 11111111111111111111111E,11„r'i„r1111111111100 2 119 lllllll 11111111111111111 $18,920 Miscellaneous GIS Support Services (1A, 1B, 1C) A - Prioritized GIS Work List (City defined) Models/Renderings/Photos Parking Records Filing 0 $0 B - ArcGIS Enterprise GIS Support Reproductions Shipping/Courier Specialty Software 0 $0 C - Misc. GIS Traffic Accident Data Traffic Count Vendors Travel, Hotel, Taxi, & Air Fare 0 $0 0 $0 0 $0 0 $0 0 $0 0 $0 0 $0 0 $0 0 $0 0 $0 0 $0 0 $0 0 $0 0 $0 0 $0 0 $0 0 $0 Total Hours 7 0 0 0 2 9 III rlllll�� $18,720 $0 $0 $0 $200 mbursable Expenses: .11 lull lull Application °° III 1 , 11 IIIIIIIIIIII Business Meals Mileage Miscellaneous Models/Renderings/Photos Parking Records Filing Registrations Reproductions Shipping/Courier Specialty Software Supplies Traffic Accident Data Traffic Count Vendors Travel, Hotel, Taxi, & Air Fare Sub Total tOOstm dmllllllll111 $0 Subconsu 1 2 3 4 5 tants: 111111111111111100000000000000000000 Ali 1 1'1'1'1111 11111111111111111111111111111111111111111111111 Subconsultant A °° III 1 , I ,1„,011111111111111111 II Subconsultant B Subconsultant C Subconsultant D Subconsultant E Sub Total OlOstm .111 IIIION000 III1(rr11111mff 111 $0 oppl Cost Estimate Prepared on: 5/11/2021 WHAT TRAIN 7p( ,'17;`I"If: d C:A N BIL'. Transpo Bi ing Rate Range Schedule UlUIaIUUUp i'Ni`ffUU� U1�aua s [[117111'1[111111111111111 [11 IIII'1[1!111111 1,IIIIIIrIII)1IIU 1lil1 ngineer/P anner/Ana yst/Pr'ncipal/D rector - Level 7 ngineer/Planner/Analyst/Assoc Prin/Proj Adm - Level 6 ngineer/P anner/Anlyst/Proj Adm' Level ngineer/Planner/Analyst/Proj Adm - Level 4 ngineer/P anner/Analyst/Proj Adm' Level 3 ngineer/Planner/Analyst/Proj Adm - Level 2 ngineer/P anner/Analyst/Proj Adm Level 1 $220