Loading...
HomeMy WebLinkAboutAgenda Report - October 16, 2013 C-11AGENDA ITEM C CITY OF LODI COUNCIL COMMUNICATION TM AGENDA TITLE: Adopt Resolution Authorizing City Manager to Execute Amendment to Professional Services Agreement for Geographical Information System Consulting Services with Websoft Developers, Inc., of Davis ($49,000) MEETING DATE: October 16, 2013 PREPARED BY: Public Works Director RECOMMENDED ACTION: Adopt resolution authorizing City Manager to execute amendment to Professional Services Agreement for geographical information system consulting services with Websoft Developers, Inc., of Davis, in the amount of $49,000. BACKGROUND INFORMATION: On February 20, 2013, City Council approved a Professional Services Agreement (PSA) with Websoft Developers, Inc., to provide geographical information system (GIS) database design and integration of wastewater collection system assets with the utility's existing computer maintenance and management software. The completed project has provided field staff the ability to implement remote work orders and asset management using tablet computers. To further streamline utility operations, staff recommends approving the scope of work presented in Exhibit 2 to the attached Websoft PSA to provide GIS database design and integration of the water distribution system and storm water system assets with the utility's existing computer maintenance and management software. Completion of the project will provide field staff the same ability to manage these system assets and remotely integrate with the GIS system. The project is expected to be complete and fully implemented by June 30, 2014. FISCAL IMPACT: Implementation of remote asset management through GIS will improve operational efficiency and reliability. FUNDING AVAILABLE: This project will be funded by Water (180461) and Wastewater (170403). CJS....._ Jorda Ayers Deputy City Manager/Internal Services Director F. Wally San lin Public Works Director Prepared by Larry Parlin, Deputy Public Works Director — Utilities FWS/LP/pmf Attachment A." . . �. - Konradt Bartlam, City Manager KAWMCOUNCIU2013Mebsoft Amendment.doc 9/18/2013 AMENDMENT NO. 1 Websoft Developers, Inc. Professional Services Agreement THIS AMENDMENT NO. 1 TO PROFESSIONAL SERVICES AGREEMENT, is made and entered this day of October, 2013, by and between the CITY OF LODI, a municipal corporation (hereinafter "CITY'), and WEBSOFT DEVELOPERS, INC. (hereinafter "CONSULTANT"). WITNESSETH: 1. WHEREAS, CONSULTANT and CITY entered into a Professional Services Agreement (Agreement) on March 18, 2013, as set forth in Exhibit 1 (attached). 2. WHEREAS, CITY requested to amend said Agreement as set forth in Exhibit 2 (attached); and 3. WHEREAS, CONSULTANT agrees to said amendment; NOW, THEREFORE, the parties agree to amend the Scope of Services and Fee as set forth in the Agreement as Exhibits 1 and 2, respectively. All other terms shall be as set forth in the Agreement. IN WITNESS WHEREOF, CITY and CONSULTANT have executed this Amendment No. 1 on 2013. CITY OF LODI, a municipal corporation Hereinabove called "CITY' KONRADT BARTLAM City Manager Attest: RANDI JOHL-OLSON, City Clerk Approved as to Form: D. STEPHEN SCHWABAUER City Attorney WEBSOFT DEVELOPERS, INC. Hereinabove called "CONSULTANT" Name: Title: Exhibit 1 AGREEMENT FOR PROFESSIONAL SERVICES ARTICLE 1 PARTIES AND PURPOSE Section 1.1 Parties THIS AGREEMENT is entered into on , 2013, by and between the CITY OF LODI, a municipal corporation (hereinafter "CITY'), and Websoft Developers, Inc. (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 Geographical Information System (GIS) geodatabase design of wastewater assets and integration of CarteGraph computer maintenance management software for wastewater infrastructure (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 For Commencement 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 timeline 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 1 counted against CONTRACTOR's contract performance period. Also, any delays due to weather, vandalism, acts of God, etc., shall not be counted, CONTRACTOR shall remain in contact with reviewing agencies and make all efforts to review and return all comments. Section 2.3 Meetinas CONTRACTOR shall attend meetings as may be set forth in the Scope of Services. Section 2.4 Staffing 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 March �� 2013 and terminates upon the completion of the Scope of Services or on May 15, 2013, whichever occurs first. 2 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 this requirement. CONTRACTOR further agrees to maintain such records for a period of three (3) years after final payment under this Agreement. 3 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), 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 of the City of Lodi or its officers or agents. 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.6 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. 4 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: Larry Parlin To CONTRACTOR: Websoft Developers Inc. 2020 Research Park Drive, Suite 140 Davis, California, 95618 Attn: Sean Dingman 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. 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. 5 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, Seye bias lite, and Attorney'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. Section 4.14 City Business License Requirement 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. 6 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 Severability 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 Authoritv The undersigned hereby represent and warrant that they are authorized by the parties to execute this Agreement. Section 4.21 Federal Transit Funding Conditions ❑ If the box at left is checked, the Federal Transit Funding conditions attached as Exhibit apply to this contract. In the event of a conflict between the terms of this contract or any of its other exhibits, and the Federal Transit Funding Conditions, the Federal Transit Funding Conditions will control. FA IN WITNESS WHEREOF, CITY and CONTRACTOR have executed this Agreement as of the date first above written. ATTES- R City Clerk APPROVED AS TO FORM: D. STEPHEN SCHWABAUER, City Attorney JANICE D. MAGDICH, Deputy City Attorney Attachments: Exhibit A - Scope of Services Exhibit B - Fee Proposal Exhibit C - Insurance Requirements Funding Source:170401.7323 (Business Unit & Account No.) Doc ID: Ckrev.01.2012 8 CITY OF LODI, a municipal corporation KDT BARTLAM, City Manager CONTRACTOR:Websoft Developers By: Name: Title: EXHIBIT A WS8Websoft Developers, Inc. 2020 Research Park Drive, Suite 140 • Davis, CA 95618 • Tel: 5307598754- fax: 530.759.0923 January 29, 2013 Larry Parlin Deputy Public Works Director City of Lodi 1331 S Ham Lane Lodi, CA 95242 Subject: Sewer asset geodatabase design, Implementation, and Cartegraph Integration Larry: Websoft Developers, Inc. (Websoft) is pleased to present this proposal to the City of Lodi (City) to provide a unified geodatabase for the City's sewer assets that will be integrated with the existing Cartegraph Computerized Maintenance Management System (CMMS) and Geocortex web -based map viewer. The scope of work below will describe the deliverables in more detail. SCOPE OF WORK 'ask 1. Geodatabase Design and Creation The goal of this task is to create a geodatabase for the City's Sewer Assets that will eliminate the need for multiple data repositories and allow for the implementation of the City's Cartegraph CMMS. Unless otherwise noted, all work will be performed off-site and Websoft will require remote access to the City's Cartegraph and ArcGIS servers. Subtask A: Investigation In this task, Websoft will investigate the City's current SDE geodatabase which is currently being used to drive the City's Geocortex web mapping viewer. Websoft will spend two days interviewing the various data stakeholders including engineering, maintenance, and IT to determine their needs with regards to a unified sanitary sewer geodatabase. Websoft will review existing data from all providers of information in support of GIS including: • Creation methodologies • Workflows • CAD drawings • GIS map layers • Associated spreadsheets and databases spat(al applications: GIS/GAD/mapping seraces : database design: applutton development: web daugn : hosting l di - 130111 -sewer geodabase reA dtsa EXHIBIT A WSOWebsoft Developers, Inc. 2020 Research Park Drive, Suite 140 • Davis, CA 95618 • Tel: 530759.8754 - Fax. 530.759.0923 Websoft will assess this Information within the context of the following: • City's 1 year strategic direction and 5 yeargoals • City's GIS consumer data needs • Currently GIS data status and accuracy • Current GIS hardware and software capabilities and future needs • GIS supporting information requirements • GIS workflow and asset creation workflow During this investigation, Websoft will determine how the City plans to do the following: • Update GIS databases with as -built data • Produce standard and custom map products • Integrate computer-aided design (CAD) drawings into the GIS environment • Integrate with other enterprise systems, such as Maintenance Management, document management, and customer information systems (CISS) • Analyze installed network for capacity planning and capital improvement projects • Manage operations activities, such as leaks, repairs, and inspections • integrate with the City's telemetry system (SCADA) Websoft will also interview the various city-wide information stakeholders to determine the following: • Infrastructure information needs • Data linking needs (e.g., financial) • Access requirements (security) Subtaslc B: Geodatabase Design Based on the investigation above, Websoft will determine how to transition the existing ArcSDE database to the ESRI Local Government Information Model for Sanitary Sewers. This model will be developed in SQL Spatial and contain a complete ESRI Geodatabase design for utilities GIS activities including: • A geometric network to support the sewer system with a set of attribute domains for material type, diameter, pipe shape, material type (as well as others to be determined). • A set of attributes for tying the sanitary sewer GIS system to the utilities work order management system As part of this task, Websoft will implement the security system developed during the Investigation phase to insure that only the required City users have the appropriate view, create, update, and delete privileges. spam) applications: GIS/CAD/mapping services :database design: appkahm devdapment ; web design: hosting IA.. 130111 _ sewer geodabm rev3 door EXHIBIT A WSD Websoft Developers, Inc. 2020 Research Park Drive, Suite 1400 • Davis, CA 95618 • Tel: 530.759,8754 - Fax: 530.759.0923 Subtasli C: Geodatabase Creation, Normalization, and Importation Websoft will use Safe Software's Feature Manipulation Engine (FME) to populate the newly created Geodatabase from the various sewer utility data sources. These sources include the existing sewer asset Inventory as well as related Microsoft Access and Excel databases. By designing the scripts in FME, Websoft will be able to quickly make migration adjustments. This will allow rapid Iteration to find the optimal translation between the existing environment and the newly created Geodatabase. As part of this task, Websoft will normalize the data to conform with the newly created database. This will include creating domain (lookup) tables for selected attributes and normalizing existing data to fit these domains. Task 2. Integration of CarteGraph/GIS Websoft will ensure that CarteGraph and the ArcSDE Geodatabase are functionally and fully -integrated for the Public Works sewer utility. This includes providing technical guidance/support/debugging ensuring that both systems operate together without error. Part of this setup Includes developing the appropriate work flows for the creation and editing of assets that relate to the utilities GIS and MMS systems. In addition, we will work with City staff to integrate functionality to geocode work orders based on physical location of asset location depending on the type of activity entered. This Integration will allow staff to create assets through the GIS interface that will automatically be entered into the MMS system. Furthermore, the integration will allow staff to do spatial analysis on maintenance activities and develop maps based on that analysis. The analysis and exhibits will be created In the CarteGraph GISDirector software. In addition, Websoft will assist the City with the implementation of the CarteGraph Mobile and CarteGraph YourGOV Mobile solutions. We will provide assistance to the City to perform data translations or manipulation that may be required for the mobile solution and provide assistance to deploy the mobile solution including server configuration where necessary. This task may, by its very nature, require ArcSDE modifications and iterations of Task 1 to be performed to Insure proper integration between ArcSDE and the CarteGraph system. This iterative approach is included in the pricing of Task 1 and Task 2. spatial applications: GIS/CAD/mapping services: database design :application development; web design: hosting lod_130111 sewer geodabsse_rev3.docx EXHIBIT B WS0Websoft Developers, Inc. 2020 Research Park Drive, Suite 140 • Davis, CA 95618 -Tel 530.759.8754 • Fax 530.759.0923 ESTIMATED FEE AND SCHEDULE The proposed pricing is based on our understanding of the needs of the City of Codi. Websoft will complete the above task within 60 days of notice to proceed. Websoft invoices on a monthly basis based on the work completed during the prior month. These prices are valid for 30 days. Invoices are due upon receipt with 10% of the total price available for hold -back until final -acceptance. Table 1. Estimated Schedule and Fee Task 1: Geodatabase Design and Creation Task 2: Integration of CarteGraph/GIS Task 3: Project Management 140 $24,600 60 $12,000 30 $6,000 Total $42,500 Thank you for this opportunity to provide this quotation. Please contact me at 916.501.1590 should you have any questions about this proposal. We are excited about this project and look forward to working with you and your staff. Sincerely, Websoft DEVELOPERS, INC. Sean Dingman SJD:sjd spatial appiket:ons : GIS/CAO/mapp ng servixs : dagbase design: appk ion development; web design: hosting bdi_130111-mm geodebeselev3.doex EXHIBIT B WSD Websoft Developers, Inc. 2020 Research Park Drive, Suite 140. Davis, CA 95618 - Tel: 530.759.8754 • Fax: 530.759.0923 2013 Billing Rate Schedule (Valid through December 31, 2013) Principal Senior Application Developer Senior Engineer Senior_Programmer/Deslgner _ Application Developer System Administrator Technician Assistant Engineer Assistant System Administrator Assistant Programmer Assistant Technician Junior Technician Administrative 205 175 160 160 150 130 110 110 85 85 75.- 55 50 Outside services such as vendor reproductions, prints, shipping, and major WSD reproduction efforts, as well as engineering supplies, travel, etc. will be billed at actual cost plus 15%. Mileage will be billed at the current Federal rate. Sub consultants will be billed at actual cost plus 10%. A Finance Charge of 1.5% per month (an annual rate of 18%) on the unpaid balance will be added to invoice amounts If not paid within 45 days from the date of the invoice. Billing rates apply to all computers and equipment, whether owned or rented, and to all employment categories including regular full-time, part-time, temporary, and contract personnel as defined In WSD's Employee Handbook. spatial appikWons : G1SJCA0/mapping sconces : database design : application dev&"nt : web design: hosucg lok 130111_sewer gessdabase_m3 doa Exhibit C r Contraft The Contractor shag take out and maintain during the lite of this contract, Insurance coverage as gated taw Thew insurance polities shall protect the Contractor and any subcontractor performing work covered by this contract from claims for damages for personal Injury. Including accidents! death, as well as from claims for property damages, which may arlse fiam Contractor's operations under this contract, whether such aperellons be by Contractor or by any suboonftdor or by anyone directly or Indirectly employed by elther of them. and the amount of ouch insurance shag be as follows: CQty,PREHENSIVE GEfiFJRAt_ UA81LI7Y $1,000,000 Each. Occurrence $2,000,000 Aggregate $1,000,000 Professional Usbgfty (Errors A Omissions) per Claim 2. GOUPREHENSIVE AUTOMOBILE LIABILM $1,000,000 Bodily injuury - Ea. Person $1,000,000 Bodily Injury - Ea. Occurrence $1,000,000 Property Damage - Ea. Occurrence NOTE: Contractor sprees and stipulates that any insurance coverage provided to the City of Lodi shall provide for a claims period following termination of coverage which is at least consdeternt with the Bairns period or statutes of limitations found Is the Cagfomds %rt Claims Act (Cagfomle Government Code Section 810 at seq.). A copy of the ce0cats of insurance wgh the following endorsements shall be furnished to the City: (a) Add onrai Neff ed grad End Such insuw mb ea Is of nied by We pagoy shall also apply to the City of Lodi, Re elected and appointed Bowda. ComMissiam, OII(aem Agents, Volunteers and Employees as additional named Insureds. (This endorsement shall be on a fomn fUMIshed to the City and shall be Included whh Contractor's policies.) (b) P dI1 ace Endorsement Such insurance as is afforded by Me endorsement for the Adddtlonal Insureds shag apply as primary insurance. Any other Insurance maintained�by the City of Lodi or its officers and employees shell be excess only and not contributing with the Insurance afforded bythis endorsement. (c) DA WN of Mew Cdaiffie The term "Insured" Is used severally and not collectively, but the Inclusion herein of more than one insured shall riot operate to Incresee the limit of the company's liability. (d) HQ3{�hts �r firhi►r Over En�rserner►t This policy may not be canceled nor the coves reduced by the company wlihout 30 days' priorwrMen notice of such cancellation or reduction In coverage to the Risk Manager, City of Lodi, 221 W. Pine SL, Lodi, CA 95240. QoMggmn$tion insurance The Contractor, shag We out and maintain dunk the Iffe of this cordract, Worker's Compm=11on Insurance for all of Contrador s employees employed at the site of the project and, V any work is sublet, Contractor shag acquire the subcontractor similarly to provide Worker's Compensation Insurance for all of the tatter's employees unless such employees are covered by the protection afforded by the Contractor. in we any claw of employees engaged In hazardous work under this contred at the oft of the project is not protected under the Worker's Compensation Statute, the Contractor shall provide and shag cause each subcontrector to provide insurance for the protection of sold employees. This policy may not be canceled nor the coverage reduced by the company without 30 days' prior wrgten notice of such cancellation or reduction In coverage is the fikk Manager, Cgy of Lodi, 221 W. Pine St., Lodi, CA 95240. Exhibit 2 WSD Websoft Developers, Inc. 2020 Research Park Drive, Suite 140 • Davis, CA 95618 • Tel: 530.759.8754 - Fax: 530.759,0923 September 10, 2013 Larry Parlin Deputy Public Works Director City of Lodi 1331 S Ham Lane Lodi, CA 95242 Subject: Water and Storm asset geodatabase design, implementation, and Cartegraph integration Larry: Websoft Developers, Inc. (Websoft) is pleased to present this proposal to the City of Lodi (City) to provide a unified geodatabase for the City's Storm and Water assets that will be integrated with the existing Cartegraph Computerized Maintenance Management System (CMMS) and Geocortex web - based map viewer. This proposal will leverage off of the work that we recently completed with the Sewer system. The scope of work below will describe the deliverables in more detail. SCOPE OF WORK Task 1. Geodatabase Design and Creation The goal of this task is to create a geodatabase for the City's Water and Storm assets that will eliminate the need for multiple data repositories and allow for the implementation of the City's Cartegraph CMMS. Since we have already done much of the setup and investigation of the City's workflows and existing data there will be a significant time savings for this task. Unless otherwise noted, all work will be performed off-site and Websoft will require remote access to the City's Cartegraph and ArcGIS servers. Subtask A: Geodatabase Design Based on the investigation above, Websoft will transition the existing ArcSDE database to the ESRI Local Government Information Model for Water and Storm Systems. This is the same model that we currently used for the Sewer assets. This model will be developed in SQL Spatial and contain a complete ESRI Geodatabase design for utilities GIS activities including: • A geometric network to support the Water and Storm system with a set of attribute domains for material type, diameter, pipe shape, material type (as well as others to be determined). spatial applications: GIS/CAD/mapping services : database design: application development: web design: hosting lodi_130910 water storm geodabase revl.dooc WSD Websoft Developers, Inc. 2020 Research Park Drive, Suite 140 - Davis, CA 95618 • Tel: 530.759.8754 . Fax: 530.759.0923 • A set of attributes for tying the Water and Storm GIS system to the utilities work order management system As part of this task, Websoft will implement the security system developed during the investigation phase to insure that only the required City users have the appropriate view, create, update, and delete privileges. Subtask B: Geodatabase Creation, Normalization, and Importation Websoft will use Safe Software's Feature Manipulation Engine (FME) to populate the newly created Geodatabase from the various Water and Storm utility data sources. These sources include the existing Water and Storm asset inventory as well as related Microsoft Access and Excel databases. By designing the scripts in FME, Websoft will be able to quickly make migration adjustments. This will allow rapid iteration to find the optimal translation between the existing environment and the newly created Geodatabase. As part of this task, Websoft will normalize the data to conform to the newly created database. This will include creating domain (lookup) tables for selected attributes and normalizing existing data to fit these domains. Task 2. Integration of CarteGraph/GIS Websoft will ensure that CarteGraph and the ArcSDE Geodatabase are functionally and fully -integrated for the Public Works Water and Storm utility. We will use the same methodology that we used during the integration of the City's Sewer assets. This includes providing technical guidance/support/debugging ensuring that both systems operate together without error. Part of this setup includes developing the appropriate work flows for the creation and editing of assets that relate to the utilities GIS and MMS systems. In addition, we will work with City staff to integrate functionality to geocode work orders based on physical location of asset location depending on the type of activity entered. This integration will allow staff to create assets through the GIS interface that will automatically be entered into the MMS system. Furthermore, the integration will allow staff to do spatial analysis on maintenance activities and develop maps based on that analysis. The analysis and exhibits will be created in the CarteGraph GISDirector software. In addition, Websoft will assist the City with the implementation of the CarteGraph Mobile and CarteGraph YourGOV Mobile solutions. We will provide assistance to the City to perform data translations or manipulation that may be required for the mobile solution and provide assistance to deploy the mobile solution including server configuration where necessary. spatial applications : GIS/CAD/mapping services : database design : application development : web design : hosting lodi=130910 water storm geodabase_rev1.doa WSD Websoft Developers, Inc. 2020 Research Park Drive, Suite 140 • Davis, CA 95618 • Tel: 530.759.8754 • Fax: 530.759.0923 This task may, by its very nature, require ArcSDE modifications and iterations of Task 1 to be performed to insure proper integration between ArcSDE and the CarteGraph system. This iterative approach is included in the pricing of Task 1 and Task 2. ESTIMATED FEE AND SCHEDULE The proposed pricing is based on our understanding of the needs of the City of Lodi. Websoft will complete the above task within 60 days of notice to proceed. Websoft invoices on a monthly basis based on the work completed during the prior month. These prices are valid for 30 days. Invoices are due upon receipt with 10% of the total price available for hold -back until final -acceptance. Table 1. Estimated Schedule and Fee Task 1: Geodatabase Design and Creation Water and Storm $24,500 $49,000 Task 2: Integration of CarteGraph/GIS Water and Storm $12,000 $24,000 Task 3: Project Management Water and Storm $6,000 $12,000 Total $85,000 Discount (multiple assets and completed setup) $36,000 Total $49,000 Thank you for this opportunity to provide this quotation. Please contact me at 916.501.1590 should you have any questions about this proposal. We are excited about this project and look forward to working with you and your staff. Sincerely, Websoft DEVELOPERS, INC. Sean Dingman SJD:sjd spatial applications : GIS/CAD/mapping services : database design : application development : web design : hosting lodi_130910_water storm geodabase_reAdocx WS0Websoft Developers, Inc. 2020 Research Park Drive, Suite 140 • Davis, CA 95618 • Tel: 530.759.8754 .l=ax: 530.759.0923 2013 Billing Rate Schedule (Valid through December 31, 2013) Principal 205 Senior plication Developer 175 Senior Engineer 160 Senior Programmer/Designer 160 Application Developer 150 S s#em Administrator 130 Technician 110 Assistant Engineer 110 Assistant S stem Administrator 85 Assistant P , rammer 85 Assistant Technician 75 Junior Technician 55 Administrative 50 Outside services such as vendor reproductions, prints, shipping, and major WSD reproduction efforts, as well as engineering supplies, travel, etc. will be billed at actual cost plus 15%. Mileage will be billed at the current Federal rate. Sub consultants will be billed at actual cost plus 10%. A Finance Charge of 1.5% per month (an annual rate of 18%) on the unpaid balance will be added to invoice amounts if not paid within 45 days from the date of the invoice. Billing rates apply to all computers and equipment, whether owned or rented, and to all employment categories including regular full-time, part-time, temporary, and contract personnel as defined in WSD's Employee Handbook. spatial applications: GIS/CAD/mapping services: database design: application development: web design: hosting lodi_130910_water storm geodabase_rev1.doa RESOLUTION NO. 2013-179 A RESOLUTION OF THE LODI CITY COUNCIL AUTHORIZING THE CITY MANAGER TO EXECUTE AN AMENDMENT TO THE PROFESSIONAL SERVICES AGREEMENT FOR GEOGRAPHICAL INFORMATION SYSTEM CONSULTING SERVICES WITH WEBSOFT DEVELOPERS, INC. WHEREAS, on February 20, 2013, City Council approved a Professional Services Agreement with Websoft Developers, Inc., to provide geographical information system (GIS) database design and integration of wastewater collection system assets with the utility's existing computer maintenance and management software. The completed project has provided field staff the ability to implement remote work orders and asset management using tablet computers; and WHEREAS, to further streamline utility operations, staff recommends amending the scope of work to provide GIS database design and integration of the water distribution system and storm water system assets with the utility's existing computer maintenance and management software. Completion of the project will provide field staff the same ability to manage these system assets and remotely integrate with the GIS system. NOW, THEREFORE, BE IT RESOLVED that the Lodi City Council does hereby authorize the City Manager to execute an amendment to the Professional Services Agreement for geographical information system consulting services with Websoft Developers, Inc., of Davis, California, in the amount of $49,000. Dated: October 16, 2013 ------------------------------------------------------------------- ------------------------------------------------------------------- I hereby certify that Resolution No. 2013-179 was passed and adopted by the City Council of the City of Lodi in a regular meeting held October 16, 2013, by the following vote: AYES: COUNCIL MEMBERS — Hansen, Johnson, and Mounce NOES: COUNCIL MEMBERS — None ABSENT: COUNCIL MEMBERS — Katzakian and Mayor Nakanishi ABSTAIN: COUNCIL MEMBERS — None RA JOHL-OLSON City Clerk 2013-179