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