Loading...
HomeMy WebLinkAboutAgenda Report - November 4, 2015 C-14AGENDA ITEM C-14 CITY OF LODI COUNCIL COMMUNICATION TM AGENDA TITLE: Adopt Resolution Authorizing City Manager to Execute Amendment No. 1 to Professional Services Agreement with Interwest Consulting Group, of Elk Grove, for Geographical Information System Consulting Services ($40,650) MEETING DATE: November 4, 2015 PREPARED BY: Public Works Director RECOMMENDED ACTION: Adopt resolution authorizing City Manager to execute Amendment No. 1 to Professional Services Agreement with Interwest Consulting Group, of Elk Grove, for geographical information system consulting services in the amount of $40,650. BACKGROUND INFORMATION: On March 21, 2012, Council authorized Interwest Consulting Group (Interwest) to replace the City's outdated geographical information system (GIS) viewer with Environmental Systems Research Institute, Inc. (ESRI) software. This work allows more complex GIS functionality and is now the foundation for expanding department specific GIS capabilities. On April 2, 2014, the City Council authorized a Professional Services Agreement with Interwest to provide oversight and support services for the various GIS projects in order to assure consistency in database design and department -wide access to non -sensitive GIS data. On April 7, 2015, a one-year extension was executed. At the time of execution, the yearly estimated cost was not included in the extension. Staff is requesting approval to add $30,000 for the one-year extension that is already executed. On March 18, 2013, the City contracted with Websoft Developers to design and integrate an asset management system for the underground utilities (water, wastewater, and storm drain). Part of the task is to convert the City's utility system into Local Government Information Model (LGIM) format. The LGIM format is the standard GIS format which is used by local agencies and will ensure the success of the City's GIS system. The conversion was completed by Websoft Developers in 2015. To assist the integration into the City's GIS mapping system, staff proposed to retain Interwest to perform the integration of the LGIM data with the City on-line mapping system. The cost of the integration is estimated to be $10,650.00. FISCAL IMPACT: Not applicable. FUNDING AVAILABLE: Funding for the agreement is from Water, Wastewater and Stormwater operating accounts as specific work is performed. Jordan Ayers Deputy City Manager/Internal Services Director F. Wally 5 delin Public Works Director Prepared by Rebecca Areida-Yadav, Management Analyst FWS/RAY/tb ilarlhi�WN�=wrmworauer, City Manager K:\WP\PROJECTS\MISC\GIS\CAmendment No 1 doc 10/22/2015 AMENDMENT NO. 1 INTERWEST CONSULTING GROUP ON-CALL SERVICES FOR GIS THIS AMENDMENT NO. 1 TO PROFESSIONAL SERVICES AGREEMENT, made and entered this day of November, 2015, by and between the CITY OF LODI, a municipal corporation (hereinafter "CITY"), and INTERWEST CONSULTING GROUP (hereinafter "CONTRACTOR"). WITNESSETH: 1. WHEREAS, CONTRACTOR and CITY entered into a Professional Services Agreement on April 15, 2014 and Contract Extension on April 7, 2015 as set forth collectively in Exhibit 1; and 2. WHEREAS, CITY requested to amend said Agreement to expand the Scope of Services as set forth in Exhibit 2; and 3. WHEREAS, CITY requested to increase the annual cost from $30,000 to $40,650, and extend the term of the Agreement to April 14, 2017; and 4. WHEREAS, CONTRACTOR agrees to said amendment. NOW, THEREFORE, the parties agree to amend the Scope of Services and increase the fees by $10,650.00 as set forth in Exhibit 2, for an annual cost of services of $40,650, and extend the term of the Agreement to April 14, 2017. IN WITNESS WHEREOF, CITY and CONTRACTOR have executed this Amendment No. 1 on 12015. CITY OF LODI, a municipal corporation INTERWEST CONSULTING GROUP hereinabove called "CITY" hereinabove called "CONTRACTOR" STEPHEN SCHWABAUER City Manager Attest: JENNIFER M. FERRAIOLO City Clerk Approved as to Form: JANICE D. MAGDICH City Attorney MICHAEL KASHIWAGI Director of Municipal Services CONTRACT EXTENSION AGREEMENT INTERWEST CONSULTING GROUP ON-CALL GIS TECHNOLOGY SERVICES THIS CONTRACT EXTENSION AGREEMENT, made and effective this 7�h day of April, 2015, by and between the CITY OF LODI, a municipal corporation, hereinafter called "City", and INTERWEST CONSULTING GROUP, hereinafter called "Contractor." WITNESSETH: CONTRACT: Contractor and City, entered into a Professional Services Agreement for On -Call Services for GIS on April 15, 2014. TERM AND TERMS: The term of this Contract Extension Agreement shall commence April 15, 2015 and terminate April 14, 2016. All other terms and conditions will remain as set forth in the Professional Services Agreement for Interwest Consulting Group On -Call Services for GIS, attached hereto as Attachment 1 and made a part hereof as though fully set forth herein. IN WITNESS WHEREOF, City and Contractor have executed this Contract Extension Agreement on the date and year first above written. CITY OF LODI, a municipal corporation hereinabove called "City" l 1� By: EP EN S041FlfA BAUER City Manager Title: Attest: .rti --fir ��t, i 'ti �--- � �► ? . ij� ��NNIFER N}2 FERRAIOLO, City Clerk Approved as to Form: JANICE D. iV1AGDICH, City Attorney Interwest Consulting Group hereinabove tat lied "Contractor" By: W, :T>i ceco. o* K n ai. _ I 'N rq i(' +" _ Exhibit 1 AGREEMENT FOR PROFESSIONAL SERVICES ARTICLE 1 PARTIES AND PURPOSE Section 1.1 Parties Attachmentl] THIS AGREEMENT is entered into on;� 2014, by and between the CITY OF LODI, a municipal corporation (hereinafter "CITY"), and INTERWEST CONSULTING GROUP (hereinafter "CONTRACTOR"). Section 1.2 Purpose CITY selected the CONTRACTOR to provide the services required in accordance with attached Scope of Services, Exhibit A, attached and incorporated by this reference. CITY wishes to enter into an agreement with CONTRACTOR for On -Call GIS Technology Services (hereinafter "Project") as set forth in the Scope of Services attached here as Exhibit A. CONTRACTOR acknowledges that it is qualified to provide such services to CITY. ARTICLE 2 SCOPE OF SERVICES Section 2.1 Scope of Services CONTRACTOR, for the benefit and at the direction of CITY, shall perform the Scope of Services as set forth in Exhibit A. Section 2.2 Time Fgw,gornmencement and Completion of Work CONTRACTOR shall commence work pursuant to this Agreement, upon receipt of a written notice to proceed from CITY or on the date set forth in Section 2.6, whichever occurs first, and shall perform all services diligently and complete work under this Agreement based on a mutually agreed upon timellne or as otherwise designated in the Scope of Services. CONTRACTOR shall submit to CITY such reports, diagrams, drawings and other work products as may be designated in the Scope of Services. CONTRACTOR shall not be responsible for delays caused by the failure of CITY staff to provide required data or review documents within the appropriate time frames. The review time by CITY and any other agencies Involved in the project shall not be counted against CONTRACTOR's contract performance period. Also, any delays due to weather, vandalism, acts of God, etc., shall not be counted. CONTRACTOR shall 1 remain in contact with reviewing agencies and make all efforts to review and return all comments. Section 2.3 Meetings CONTRACTOR shall attend meetings as may be set forth in the Scope of Services. Section 2.4 Staffina CONTRACTOR acknowledges that CITY has relied on CONTRACTOR's capabilities and on the qualifications of CONTRACTOR's principals and staff as identified in its proposal to CITY. The Scope of Services shall be performed by CONTRACTOR, unless agreed to otherwise by CITY in writing. CITY shall be notified by CONTRACTOR of any change of Project Manager and CITY is granted the right of approval of all original, additional and replacement personnel at CITY's sole discretion and shall be notified by CONTRACTOR of any changes of CONTRACTOR's project staff prior to any change. CONTRACTOR represents it is prepared to and can perform all services within the Scope of Services (Exhibit A) and is prepared to and can perform all services specified therein. CONTRACTOR represents that it has, or will have at the time this Agreement is executed, all licenses, permits, qualifications, insurance and approvals of whatsoever nature are legally required for CONTRACTOR to practice its profession, and that CONTRACTOR shall, at Its own cost and expense, keep in effect during the life of this Agreement all such licenses, permits, qualifications, insurance and approvals, and shall indemnify, defend and hold harmless CITY against any costs associated with such licenses, permits, qualifications, insurance and approvals which may be imposed against CITY under this Agreement. Section 2.5 Subcontracts Unless prior written approval of CITY is obtained, CONTRACTOR shall not enter into any subcontract with any other party for purposes of providing any work or services covered by this Agreement. Section 2.6 Term The term of this Agreement commences on April 15, 2014 and terminates upon the completion of the Scope of Services or on April 14, 2015, whichever occurs first. Section 2.7 option to Extend Term of A regiment At its option, City may extend the terms of this Agreement for an additional two (2) one (1) -year extensions; provided, City gives Contractor no less than thirty (30) days written notice of its intent prior to expiration of the existing term. In the event City exercises any option under this paragraph, all other terms and conditions of this 2 Agreement continue and remain in full force and effect. The total duration of this Agreement, including the exercise of any option under this paragraph, shall not exceed three (3) years. ARTICLE 3 COMPENSATION Section 3.1 Compensation CONTRACTOR's compensation for all work under this Agreement shall conform to the provisions of the Fee Proposal, attached hereto as Exhibit B and incorporated by this reference. CONTRACTOR shall not undertake any work beyond the scope of this Agreement unless such additional work is approved in advance and in writing by CITY. Section 3.2 Method of Payment CONTRACTOR shall submit invoices for completed work on a monthly basis, or as otherwise agreed, providing, without limitation, details as to amount of hours, individual performing said work, hourly rate, and Indicating to what aspect of the Scope of Services said work is attributable. CONTRACTOR's compensation for all work under this Agreement shall not exceed the amount of the Fee Proposal. Section 3.3 Costs The Fee Proposal shall include all reimbursable costs required for the performance of the Scope of Services. Payment of additional reimbursable costs considered to be over and above those inherent In the original Scope of Services shall be approved in advanced and in writing, by CITY. Section 3.4 Auditing CITY reserves the right to periodically audit all charges made by CONTRACTOR to CITY for services under this Agreement. Upon request, CONTRACTOR agrees to furnish CITY, or a designated representative, with necessary information and assistance needed to conduct such an audit. CONTRACTOR agrees that CITY or its delegate will have the right to review, obtain and copy all records pertaining to performance of this Agreement. CONTRACTOR agrees to provide CITY or its delegate with any relevant information requested and shall permit CITY or its delegate access to its premises, upon reasonable notice, during normal business hours for the purpose of interviewing employees and inspecting and copying such books, records, accounts, and other material that may be relevant to a matter under investigation for the purpose of determining compliance with 3 this requirement. CONTRACTOR further agrees to maintain such records for a period of three (3) years after final payment under this Agreement. ARTICLE 4 MISCELLANEOUS PROVISIONS Section 4.1 Nondiscrimination In performing services under this Agreement, CONTRACTOR shall not discriminate in the employment of its employees or in the engagement of any sub CONTRACTOR on the basis of race, color, religion, sex, sexual orientation, marital status, national origin, ancestry, age, or any other criteria prohibited by law. Section 4.2 ADA Compliance In performing services under this Agreement, CONTRACTOR shall comply with the Americans with Disabilities Act (ADA) of 1990, and all amendments thereto, as well as all applicable regulations and guidelines issued pursuant to the ADA. Section 4.3 Indemnification and Responsibility for Damage CONTRACTOR to the fullest extent permitted by law, shall indemnify and hold harmless CITY, its elected and appointed officials, directors, officers, employees and volunteers from and against any claims, damages, losses, and expenses (including reasonable attorney's fees and costs), arising out of performance of the services to be performed under this Agreement, provided that any such claim, damage, loss, or expense is caused by the negligent acts, errors or omissions of CONTRACTOR, any subcontractor employed directly by CONTRACTOR, anyone directly or indirectly employed by any of them, or anyone for whose acts they may be liable, except those injuries or damages arising out of the active negligence, sole negligence, or sole willful misconduct of the City of Lodi, its elected and appointed officials, directors, officers, employees and volunteers. CITY may, at its election, conduct the defense or participate in the defense of any claim related in any way to this indemnification. If CITY chooses at its own election to conduct its own defense, participate in its own defense, or obtain independent legal counsel In defense of any claim related to this indemnification, CONTRACTOR shall pay all of the costs related thereto, including without limitation reasonable attorney fees and costs. The defense and indemnification obligations required by this Agreement are undertaken in addition to, and shall not in any way be limited by the insurance obligations set forth herein. 4 Section 4.4 No Personal Liability Neither the City Council, nor any other officer or authorized assistant or agent or City employee shall be personally responsible for any liability arising under this Agreement. Section 4.5 Responsibility of CITY CITY shall not be held responsible for the care or protection of any material or parts of the work described in the Scope of Services prior to final acceptance by CITY, except as expressly provided herein. Section 4.G Insurance Requirements for CONTRACTOR CONTRACTOR shall take out and maintain during the life of this Agreement, insurance coverage as set forth in Exhibit C attached hereto and incorporated by this reference. Section 4.7 Successors and Assigns CITY and CONTRACTOR each bind themselves, their partners, successors, assigns, and legal representatives to this Agreement without the written consent of the others. CONTRACTOR shall not assign or transfer any interest in this Agreement without the prior written consent of CITY. Consent to any such transfer shall be at the sole discretion of CITY. Section 4.8 Notices Any notice required to be given by the terms of this Agreement shall be in writing signed by an authorized representative of the sender and shall be deemed to have been given when the same is personally served or upon receipt by express or overnight delivery, postage prepaid, or three (3) days from the time of mailing if sent by first class or certified mail, postage prepaid, addressed to the respective parties as follows: To CITY: City of Lodi 221 West Pine Street P.O. Box 3006 Lodi, CA 95241-1910 Attn: Charlie Swimley, City Engineer/Deputy PW Director To CONTRACTOR: Interwest Consulting Group 9300 W. Stockton Blvd., Ste. 105 Elk Grove, CA 95759 Attn: Gina Wong Section 4.9 Cooperation of CITY CITY shall cooperate fully and in a timely manner in providing relevant information it has at its disposal relevant to the Scope of Services. 5 Section 4.10 CONTRACTOR is Not an Employee of CITY CONTRACTOR agrees that in undertaking the duties to be performed under this Agreement, it shall act as an independent contractor for and on behalf of CITY and not an employee of CITY. CITY shall not direct the work and means for accomplishment of the services and work to be performed hereunder. CITY, however, retains the right to require that work performed by CONTRACTOR meet specific standards without regard to the manner and means of accomplishment thereof. Section 4.11 Termination CITY may terminate this Agreement, with or without cause, by giving CONTRACTOR at least ten (10) days written notice. Where phases are anticipated within the Scope of Services, at which an intermediate decision is required concerning whether to proceed further, CITY may terminate at the conclusion of any such phase. Upon termination, CONTRACTOR shall be entitled to payment as set forth in the attached Exhibit B to the extent that the work has been performed. Upon termination, CONTRACTOR shall immediately suspend all work on the Project and deliver any documents or work in progress to CITY. However, CITY shall assume no liability for costs, expenses or lost profits resulting from services not completed or for contracts entered into by CONTRACTOR with third parties in reliance upon this Agreement. Section 4.12 Confidentiality CONTRACTOR agrees to maintain confidentiality of all work and work products produced under this Agreement, except to the extent otherwise required by law or permitted in writing by CITY. CITY agrees to maintain confidentiality of any documents owned by CONTRACTOR and clearly marked by CONTRACTOR as 'Confidential" or "Proprietary", except to the extent otherwise required by law or permitted in writing by CONTRACTOR. CONTRACTOR acknowledges that CITY is subject to the California Public Records Act. Section 4.13 Applicable Law, Jurisdiction, Severability, and AttorneV's Fees This Agreement shall be governed by the laws of the State of California. Jurisdiction of litigation arising from this Agreement shall be venued with the San Joaquin County Superior Court. If any part of this Agreement is found to conflict with applicable laws, such part shall be inoperative, null, and void insofar as it is in conflict with said laws, but the remainder of this Agreement shall be in force and effect. In the event any dispute between the parties arises under or regarding this Agreement, the prevailing party in any litigation of the dispute shall be entitled to reasonable attorney's fees from the party who does not prevail as determined by the San Joaquin County Superior Court. 6 Section 4.14 City Business L.i ense Re uirement CONTRACTOR acknowledges that Lodi Municipal Code Section 3.01.020 requires CONTRACTOR to have a city business license and CONTRACTOR agrees to secure such license and pay the appropriate fees prior to performing any work hereunder. Section 4.15 Captions The captions of the sections and subsections of this Agreement are for convenience only and shall not be deemed to be relevant in resolving any question or interpretation or intent hereunder. Section 4.16 Integration and Modification This Agreement represents the entire understanding of CITY and CONTRACTOR as to those matters contained herein. No prior oral or written understanding shall be of any force or effect with respect to those matters covered hereunder. This Agreement may not be modified or altered except in writing, signed by both parties. Section 4.17 Contract Terms Prevail All exhibits and this Agreement are intended to be construed as a single document. Should any inconsistency occur between the specific terms of this Agreement and the attached exhibits, the terms of this Agreement shall prevail. Section 4.18 Severabili The invalidity in whole or in part of any provision of this Agreement shall not void or affect the validity of any other provision of this Agreement. Section 4.19 Ownership of Documents All documents, photographs, reports, analyses, audits, computer media, or other material documents or data, and working papers, whether or not in final form, which have been obtained or prepared under this Agreement, shall be deemed the property of CITY. Upon CITY's request, CONTRACTOR shall allow CITY to inspect all such documents during CONTRACTOR's regular business hours. Upon termination or completion of services under this Agreement, all information collected, work product and documents shall be delivered by CONTRACTOR to CITY within ten (10) calendar days. CITY agrees to indemnify, defend and hold CONTRACTOR harmless from any liability resulting from CITY's use of such documents for any purpose other than the purpose for which they were intended. Section 4.20 Authori The undersigned hereby represent and warrant that they are authorized by the parties to execute this Agreement. 7 Section 4.29 Federal Transit Funding Condltions El If the box at left is checked, the Federal Transit Funding conditions attached as Exhibit D apply to this Agreement. In the event of a conflict between the terms of this Agreement or any of its other exhibits, and the Federal Transit Funding Conditions, the Federal Transit Funding Conditions will control. IN WITNESS WHEREOF, CITY and CONTRACTOR have executed this Agreement as of the date first above written. ATTEST! RAN DI fbHL-OLSON-- City Clerk APPROVED AS TO FORM: JANICE D. MAGDICH, Interim City Attorney F3y.. CITY OF LODI, a municipal corporation STEPHEN CHWABR ER Interim City Manager INTERWEST CONSULTING GROUP By: f Title: 4,�,'Ur �dct Anacnmenss: Exhibit A — Scope of Services Exhibit B — Fee Proposal Exhibit C — Insurance Requirements Exhibit D — Federal Transit Funding Conditions (if applicable) Funding Source: Various QRkratin�Funds, (Business Unit & Account No.) Doc ID:WPIProjects\PSAs1201411nterwest2014 CA:Rev.03.2014 a IA"#ZW'ESTCONSULTING GROUP GIS SOLUTIONS TEAM CITY OF LODI, CA GIS STEERING COMMITTEE SCOPEAND QUOTATION FOR: ON GILL WS 7'ECHNOLOGYSERVICES I."trrx ""tion Exhibit A/BJ w1ax Icay GOHSULTIYG GROUP (March 14, 2014 This proposal supports an extension ofthe On Call GIS Technology Services contract established in February 2013. Interwest will continue to provide the services listed in the scope described below. Our hourly rates have not changed and we will work under the same not to oxceed fee. 5gong oLurvices On call Services- - Interwest will provide ongoing GIS Technology support to the city as needod to further the growth of the city's GIS program. At the request ofthe City, Interwest will provide strategic support and technical Implementatien in support of the CIty's CIIS. The tasks to be included in these on call services shall relate to the following area of service: • Strategic Support and Planning U 1nSnstructure and System administ Winn • Data maintenance and development Project Management of GIS projects and GIS integration. GIS Viewer expansion and modifications Geocoriex software AdminishWon ® Database, Server and Network Consultation • GIS Training Cost Title - Houriv State— - Project Manage _GIS -$120 Sr. GIS Anal v st $105 GIS Analyst _ $85 _ GIS Technician $55 Database/NetworkEngineer _ $105 On Call_GIES Services Not to Exceed __ - --- --- $30000 1Reque-0 for>Services Interwest will provide a simple request template that can be submitted by email. The city shall designate a representative(s) that will authorize the request for services. For ongoing or repetitive tasks a single request for service can be submitted specifying the regular needs. (i.e. monthly webmap updates). Invoicing Interwest will complete the request for services and submit a monthly invoice. This will be tracked against the not to exceed amount. When the remaining balance is below $5,000 interwest Accounting will provide an alert regarding the remaining balance. ORILOinLy Support If custom applications or processes are created during the on-call service period, Interwesi will provide an additional 30 day warranty after the on-call service agreement ends. As such our staff will provide remote support (phone and/or remote login) to repair the application or process as needed to ensure its stability. After the 30 day warranty period, support of custom applications and processes will be billed hourly- EXHIBIT C jut;rrance ftegniremenu; forC_nnfrkctgr The Contractor shall takeout and maintain during the Ufa of this contract, insurance coverage as listed below. These insurance policies shall protect the Contractor and any subcontractor performing work covered by this contract from claims for damages for personal injury, including accidental death, as well as from claims for property damages, which may arise from Contractor's operations under this contract, whether such operations be by Contractor or by any subcontractor or by anyone directly or indirectly employed by either of them, and the amount of such Insurance shall be as follows: COMPREHENSIVE GENERAL U60I_t31 $1,000,000 Ea. Occurrence $1,000,000 Aggregate 2, COMPREHENSWE AOMQa LL LiABiLI1 Y $1,000,000 Bodily Injury - Ea. Person $1.000.000 Bodily Injury - Ea. Occurrence $1,000,000 Property Damage - Ea. Occurrence NOTE: Contractor agrees and stipulates that any Insurance coverage provided to the City of LCdI shall provide for a claims period following termination of coverage which Is at least consistent with the claims period or statutes of limitations found In the California Tort Claims Act (California Government Code Section 810 et WN.). NOTE: (1) The street address of the CITY OF LODI must be shown along with (a) and (b) above: 221 West Pine Sheet, Lodi, California, 95241-1910; (2) The insurance certificate must state, on its face or as an endorsement, a description of the proiect that it Is insuring. A copy of the certificate of insurance with the following endorsements shall be furnished to the City: (a) Additional me n rlCnd ra i Such insurance as Is afforded by this policy shall also apply to the City of Lodi, its elected and appointed Boards, Commissions, Officers, Agents, Employees, and Volunteers as additional named insureds. (This endorsement shall be on a form furnished to the City and shall be Included with Contractor's policies.) (b) Primary Insurance twrd s Such insurance as is afforded by the endorsement for the Additional Insureds shall apply as primary insurance. Any other insurance maintained by the City of Lodi or its officers and employees shall be excess only and not contributing with the insurance afforded by this endorsement. (a) SQyO-MWFiY of Intere t Clausigi The term "insured" Is used severally and not collectively, but the inclusion herein of more than one insured shall not operate to increase the limit of the company's liability. (d) Notlo of Qg=J onorC a e Eadpj This policy may not be canceled nor the coverage reduced by the company without 30 days' prior written notice of such cancellation or roductlon in coverage to the Risk Manager, City of Lodi, 221 W. Pine St., Lodi, CA 95240. Compensation Insuranc-Q The Contractor shall take out and maintain during the life of this contract, Workers Compensation Insurance for all of Contractors employees employed at the site of the project and, if any worts Is sublet, Contractor shall require the subcontractor similarlyt to provide Worker's Compensation Insurance for all of the latter's employees unless such employees are covered by lite protection afforded by the Contractor, In case any class of employees engaged in hazardous work under this contract at the site of the project Is not protected under the Worker's Compensation Statute, the Contractor shall provide and shall cause each subconiracter to provide insurance for the protection of said employees. This pollcy may not be canceled nor the coverage reduced by the company without 30 days' prior written notice of such cancellation or resiuction in coverage to the Risk Manager, City of Lodi, 221 W. Pine St., Lodi, CA 95240. A Waiver ofSu�r�r gotten acaEns= the City of Lodi is reaulrJ_ NOTE: No contract agreement will be signed nor will iU work begin on a project until the proper insurance certificate Is received by the City. Exhibit 2 INTER WEST CONSULTING GROUP GIS SOLUTIONS TEAM INTCNMCST CONSUL ' I '1 G G H g J o CITY OF LODI, CA SCOPE AND ESTIMATE FOR: LGIM Data Changes to Geocortex, Reports, and Training Introduction July 2, 2015 The City adopted Esri's LGIM for their storm, wastewater, and water feature classes. These changes in SDE will require updates to the mxds that are used to create the Geocortex map services, the configuration of these layers in the internal and external viewers; updates to the reports on the GIS hope page, and training of city staff. ScJ)e of Services MXDs and Map Services Update internal and external MXDs and publish map services. Geocortex Map Viewers • Reconfigure 12 existing feature classes • Configure 12 new feature classes in both the internal and external GIS viewers. • Update hydrant workflow • Update public works theme SQL Reports ■ Update GIS homepage report for Hydrants Setup SDE for Editing • Modify database for staff to edit • Create edit version • Modify SDE service for AutoCAD • Modify backend SDE scripts for database maintenance • Create auto number for 12 feature classes Requirements Gather, Training and User Acceptance ■ Requirements Gathering User Acceptance GIS Training for staff feature Classes ONew feature classes) Storm PumpStations Outfalls Gates Storm Drain Manholes Storm Drain Lines Catch Basins Catch Basin Laterals Proposed Basins* Watershed Areas* Wastewater Wastewater Spills* Wastewater Blockages' Wastewater Manhole WW Lift Stations* WW Grease Traps" Wastewater Cleaning* Wastewater Lines Wastewater Services* Water Fire Hydrants Water Valves Wells & Storage Water Lines Water Services Abandoned Water- Valves* Abandoned Water Lines* Eastside Boundary" Pump Station* Z Cost MXDs and Map Services $ 3,360.00 Geocortex Map Viewers $ 4,200.00 SQL Reports $ 360.00 Setup SDE for Editing $ 630.00 Requirements Gathering, Training, User Acceptance $ 2,I00.00 Estimated Costs from cuivent contract $10,650.00 RESOLUTION NO. 2015-193 A RESOLUTION OF THE LODI CITY COUNCIL AUTHORIZING THE CITY MANAGER TO EXECUTE AMENDMENT NO. 1 TO PROFESSIONAL SERVICES AGREEMENT WITH INTERWEST SYSTEM CONSULTING GROUP, OF ELK GROVE, FOR GEOGRAPHICAL INFORMATION SYSTEM CONSULTING SERVICES WHEREAS, Interwest System Consulting Group and the City entered into a Professional Services Agreement on April 15, 2014, and a Contract Extension on April 7, 2015; and WHEREAS, the City requested to amend said Agreement to expand the Scope of Services and fees; and WHEREAS, the City requested to increase the annual cost to $40,650 and extend the term of the Agreement to April 14, 2017; and WHEREAS, staff recommends executing Amendment No. 1 to the Professional Services Agreement with Interwest Consulting Group for geographical information system consulting. NOW, THEREFORE, BE IT RESOLVED that the Lodi City Council does hereby authorize the City Manager to execute Amendment No. 1 to the Professional Services Agreement with Interwest Consulting Group, of Elk Grove, California, for geographical information system consulting, to expand the Scope of Services and increase the fees by $10,650, for an annual cost of service not to exceed $40,650 annually; and BE IT FURTHER RESOLVED that the term of this Amended Agreement be extended to and including April 14, 2017. Dated: November 4, 2015 ------------------------------------------------------------------------ ------------------------------------------------------------------------ hereby certify that Resolution No. 2015-193 was passed and adopted by the City Council of the City of Lodi in a regular meeting held November 4, 2015, by the following vote: AYES: COUNCIL MEMBERS — Chandler, Kuehne, Mounce, Nakanishi, and Mayor Johnson NOES: COUNCIL MEMBERS — None ABSENT: COUNCIL MEMBERS - None ABSTAIN: COUNCIL MEMBERS — None 4 ---A�I -NIFER FERRAIOLO City Clerk 2015-193