HomeMy WebLinkAbout2001-02-12 City Council (9)TO:
ATTENTION:
DATE:
SUBJECT:
City of Palo Alto
City Manager’s Report
HONORABLE CITY COUNCIL 4
CITY MANAGER DEPARTMENT: ADMINISTRATIVE
SERVICES
\
FEBRUARY 12, 2001 CMR: 131:01
APPROVAL OF AMENDMENT NO. 10 IN THE AMOUNT OF
$42,000 FOR CONSULTING SERVICES CONTRACT
$3036240 WITH GEODESY FOR DEVELOPMENT SUPPORT
OF NEW COMPUTER APPLICATIONS LINKED TO THE
GEOGRAPHIC INFORMATION SYSTEM (GIS)
RECOMMENDATION
Staff recommends that Council approve and authorize the Mayor to execute the attached
amendment in the amount of $42,000 to a consulting services contract with Geodesy
DISCUSSION
Project Description
The GIS provides accurate citywide property and infrastructure information to all City
staff and the public. City departments have identified numerous applications that could
make extensive use of the City’s GIS. Several applications such as "MapView" data
viewer and the "Feature Editor" data maintenance tool have already been successfully
developed and implemented. Staff plans to pursue implementation of additional
applications to improve the City’s business processes to provide better service to the
public.
Geodesy has been instrumental in the development of the City’s GIS, including the
applications previously mentioned. Their current FY 2000 scope of work ($140,000) is
for further GIS application development and integration. Additional support by Geodesy
is necessary by the Public Works Department to modify and implement software and data
to improve GIS capabilities related to the storm water and wastewater systems. This
additk~nal work is in support of the Public Works Department (Water Quality) sot~ware
devel,:~pment requirements, as well as.consulting and development to provide engineering
and decision support for the management of the City’s storm water system.
CMR: 131:01 Page 1 of 2
RESOURCE IMPACT
The current year services are $140,000. The proposed additional items in the amount of
$42,000 create a new total for FY 2000 of $182,000. Funds for this project are available
in the Wastewater Treatment Source Control Program operating budget, and the Storm
Drain System Improvement CIP.
POLICY IMPLICATIONS
This recommendation does not represent any change to existing City policies.
ENVIRONMENTAL ASSESSMENT
This is not a project under the California Environmental Quality Act and therefore
environmental review is not required.
ATTACHMENTS
Amendment No. 10 to Consulting Services Contract $3036240 with Geodesy.
PREPARED BY:
DAVE MATSON
GIS Coordinator, Information Technology
DEPARTMENTAL HEAD APPROVAL:
Director, Adrtiinistrative Services
CITY MANAGER APPROVAL:
EMILY HARRISON
Assistant City Manager
CMR: 131:01 Page 2 of 2
AMENDMENT NO. i0 TO CONTRACT NO. $3036240
BETWEEN CITY OF PALO ALTO AND
GEODESY
This Amendment No. I0 to Contract No. $3036240 is
entered into , 2001, by and between the City of Palo
Alto., a municipal corporation of the State of California
("CITY") and Geodesy, a general partnership (Taxpayer’s
Identification No. 94-3191197) ("CONTRACTOR").
RECITALS:.
WHEREAS, CITY and CONTRACTOR have entered into
Contract No. $3036240 for certain application software
development services associated with the support of CITY’s
Geographic Information System and its conversion ("GIS"), and it
has been amended from time to time; and
WHEREAS, CITY and CONTRACTOR desire to amend the scope
of services to include two additional tasks, and to increase the
compensation therefor;
NOW, THEREFORE, in consideration of the following
terms, Conditions, and covenants, the parties agree as follows:
SECTION I. Section ~ 3.1 of the Agreement is hereby
amended to read in accordance with the terms of Exhibit "A" to
Amendment #9, as modified by the addition of Exhibits "A-I" and
"A-2", which are attached hereto and incorporated herein by this
reference.
SECTION 2. Section 4 of the Agreement is hereby
amended in its entirety to read as follows:
010103 cl 0032416
"For the full performance of the services
described herein by CONTRACTOR, CITY shall
pay CONTRACTOR a total sum not to exceed One
Hundred Eighty-two Thousand Dollars
($182,000), payable at the rate of One
Hundred Dollars ($I00) per hour, upon
submission by CONTRACTOR of its itemized
billings in triplicate, in accordance with
the schedule of proposed hours per task, as
shown in Exhibit "B" to Amendment #9 and in
Exhibits "A-I" and "A-2" to this Amendment
#i0."
SECTION 3. All other provisions of ,the Agreement,
along with Amendments 1-9, not amended herein by this Amendment
No. I0 to Agreement shall remain in full force and effect.
EXECUTED BY THE PARTIES in Palo Alto, County of Santa
Clara, California on the date first above stated.
ATTEST:CITY OF PALO ALTO
City Clerk
APPROVED AS TO FORM:
Mayor
GEODESY
Senior Asst. City Attorney
APPROVED:
By:
Title:
Assistant City Manager
By:
Title:
Director of Administrative
Services
Tax I.D.: 94-3191197
Insurance Review
Attachments:
(Compliance .with Corp. Code § 313
is required if the entity on whose
behalf this contract is signed is a
corporation. In the alternative, a
certified corporate resolution
attesting to the signatory
authority of the individuals
signing in their respective
capacities is acceptable)
Exhibit "A-I": Proposal for software development for WQCP, dated
November 21, 2000 (5 pages)
Exhibit "A-2": Proposal to Integrate PAGIS with PCSWMM 2000,
dated December 8, 2000 (2 pages)
010103 ~I 0032416 2
CERTIFICATE OF ACKNOWLEDGMENT
(Civil Code § 1189)
STATE OF
COUNTY OF
)
)
)
On
said County,
,before me,
, a notary public in and for
personally appeared
personally known to me (or proved to me on the basis of
satisfactory evidence) to be the person(s)whose name(s)is/are
subscribed to the within instrument, and acknowledged to me that
he/she/they executed the same in his/ her/their authorized
capacity(ies), and that by his/her/their signature(s) on the
instrument the person(s), or the entity upon behalf of which the
person(s) acted, executed the instrument.
WITNESS my hand and official seal.
010103 cl 0032416
STATE OF
COUNTY OF
CERTIFICATE OF ACKNOWLEDGMENT
(Civil Code § 1189
)
)
)
On
said County,
,before me,
, a notary public in and for
personally appeared
personally known to me (or proved to me on the basis ofsatisfactory evidence) to be the person(s)whose name(s)is/aresubscribed to.the within instrument, and acknowledged to me that
he/she/they executed the same in his/ her/their authorized
capacity(ies), and that by his/her/their signature(i) on the
instrument the person(s), or the entity upon behalf of which the
person(s) acted, executed the instrument.
WITNESS my hand and official seal.
010103,cl 0032416 4
November 21, 2000
Dave Matson
The City of Palo Alto
250 Hamilton Avenue
Palo Alto, CA 94303
RE: Proposal for software development in response to Water Quality requirements.
Dear Dave,
This document was created in response to the set of requirements described by Ken Torke
(Environmental Compliance Division, Public Works Department). We met with Ken October 3rd
to discuss potential development activities. He subsequently documented and prioritized those
interests in his letter dated October 25, 2000.
The actions that can be taken to respond tO Ken’s requirements fall into four categories: (1)
those that can be done now using Gist with.no additional development, (2) those that require
data development or data editing, (3) those that require software development, and (4) those
that require further definition or have external dependencies that are beyond our control at this
point in time.
I have included the categorization of all tt~e tasks here as well as a proposal to develop the
software to address the tasks in the third category. The numbers in brackets reference Ken’s
requirements document. A cross-referenced copy of Ken’s requirements are included at the
end of this document for reference.
1. Existing Gist Capabilities
With no additional software development, Gist can:
a) create a thematic map for pipes on the Basin ID to indicate basin contents with different
colors for each basin. [requirements 3 and 9]
b) develop a list.of parcels and display them for the permitted industries. [requirement 10]
c) map against Dunn and Bradstreet data for industries assuming the D&B address match with
the City’s address database. [requirement 13]
2. Data Development
These tasks may be performed by interns with some supervision from an IT staff person and
with Public Works engineering input. These data development tasks require no software
development.
a) Create the basin polygons. Create a plot from Gist that shows the main pipes colored by
basin ID, have an engineer mark the polygon boundaries, and have an intern add the
polygons using FE. The basins must be defined in the Feature Dictionary if they do not
already exist. [requirement 5]
b) Add stream centerlines to the storm subject. Copy the centerlines from the natural features
subject, break the lines at outfall points and add a node feature to link the centerlines into
the storm network. [requirements 1 and 2]
Geodesy ¯8 California Street ¯Suite610 ¯San Francisco, CA 94111 ¯Te!(415)677-8750 ¯Fax(415)677-8751
Exhibit "A-I"
Page 2 of 5
c)Add missing Basin ID attribute values to storm features. Create a view flagging all the
features that have a null value for Basin ID, use the multi-feature edit capability in the PC
version of FE, and update the Oracle tables and GDS attribute values with update queries
and/or the existing attribute update GEL program. [requirement 3]
d) Add conveyance features as necessary to complete the network. Review the existing
network to determine possible missing links and add missing pipes where needed. There
may be a need to add a surface conveyance feature class (like gutters) if there are surface
features that are used for conveyance in addition to initial storm water collection.
[requirements 1 and 2]
e) Add a diversion attribute to structure feature classes. Identify the feature classes (like
manholes) that have diversion capabilities, add the attribute to the meta data, alter the
tables to add the column, and set the attribute value for each feature that can divert storm
water. [requirement 4] .
3. FIo Updates
FIo is the City’s existing storm water management application. The following extensions to FIo
can be developed to address several of the high priority requirements.
a) Enhance and modularize the trac~ user interface. The revised trace interface can then be
added to Gist. [requirements 1, 2, 7, and 8]
b) Add a high water/low water flag to the trace interface. This will allow traces to use
diversions. This. requires some modifications to the existing trace code as well as the
Feature-Editor. [requirement 4]
c) Add pin map capabilities and service requests to FIo.. This will address complaints.
[requirement 6]
d) Add a menu pick to switch the data set with which FIo operates. This will support using FIo
for both storm water and waste water. [requirements 7 and 8]
e) Add geometry editing to FIo. This will allow storm and waste water features to be
maintained directly. [this was not on the Ken’ priority list]
f) Add maintenance attributes to storm features. Update the feature attributes to include
maintenance data and develop a reporting interface for maintenance. [this was not on the
Ken" priority list]
g) Improve the graphic display speed. Users will tend to display large areas to view networktraces results and will benefit from the enhanced draw performance.
4. Deferred Requirements
Several of the lower priority requirements have external dependencies or need further review
and refinement before an approach may be suggested.
a) Connecting to the industry sampling data may be done through address matching or by
adding related classes in the meta data. The existing database will need to be reviewed to
determine if this simple approach is feasible. [requirement 12]
b) A connection to the utility billing system is required to make fresh water usage data
available to the GIS. There are resource, political, and technical issues that make this task
infeasible at this time. However, once these problems are overcome, this data access task
will be simple. [requirement 15]
Geodesy ¯8CalifomiaStreet ¯Suite610 ¯San Francisco, CA 94111 ¯Te1(415) 677-8750 ¯Fax(415) 677-8751
c)
d)
Page 3 of 5
If related feature data like industrial parcels or D&B parcels have a link to a storm or waste
water feature (like a manhole, lateral, or pipe ID) in a relational table, the trace functions will
not need to be modified. However, an interface will need to be developed to select the
search feature (like "industrial parcels") and the attribute to be summed (like "mass of heavy
metal per day"). [requirements 11, 14, and 16]
The primary barrier to obtaining Stanford data is political. Once Stanford and the City agree
on a data sharing policy, we will be able to import Stanford data. Possible issues with using
this data for network tracing are:
¯ Positional accuracy. The Stanford data may not be pL~sitioned as accurately as the
City’s data.
¯Attribute definitions and completeness. FIo manages a significant number of
attributes for each feature. If Stanford does not manage a similar set of attributes,
the functions that can be performed with the network trace results may be restricted.
¯Flow direction. The City’s pipes are drawn in the direction of flow. If Stanford’s
pipes are not drawn using the same convention, the link/node model can not be
correctly populated and the flow direction can not be traced.
¯System model differences. The City’s model represents manholes and catch basins
as nodes (point features with network connectivity)-and pipes as li~ks (lines drawn
between two nodes). If Stanford models their features differently, a post conversion
process may need to be developed to bring the data into compliance for use with
FIo.
Estimate For FIo Software Development
The cost to develop the updates to FIo listed in section 3 is $22,000.
Schedule
The changes to FIo can be implemented within two months of the date the work is authorized.
Please feel free to contact me if yo,u have any further questions or comments.
Sincerely,
Chip Eitzel
chip @ geodesy, net
cc: Ken Torke, City of Palo Alto
Geodesy ¯8 California Street ¯Suite610 ¯San Francisco, CA 94111 ¯Te1(’415i677-8750 ¯Fax(415) 677-8751
Appendix A:
1.
Page 4 of 5
Requirements
A function that traces all storm drainage features which contribute to a selected point on a
storm drain or creek feature.
[addressed by proposal item 2b, 2d, and 3a]
2. A function that traces all storm drainage and creeks that are downstream from a selected
point.
[addressed by 2b, 2d and 3a]
3. A function that highlights the storm d~ainage basin for each major storm water outfall.
[addressed by la and 2c]
4. A method for dealing with storm water diversion systems and their effects on the above
items.
[addressed by 2e and 3b]
5. "Polygons" from the above items that can be delivered to other agencies for inclusion in
their GIS systems.
[addressed by 2a]
6. A pinmap function for attaching storm water incident information.
[addressed by 3c]
7. A function that traces all sanitary sewer collection system features which contribute to a
selected point within the collection, system..! -
[addressed by 3a and 3d]
8. A function that traces all sanitary sewer collection system feature that are downstream from
a selected feature.
[addressed by 3a and 3d]
9. A function that highlights the area that contributes wastewater to a selected collection
system feature.
[addressed by la]
10. A function for mapping permitted industries that discharge to the sanitary sewage system.
[addressed by lb]
11. A function for listing, all permitted industries that discharge to a selected collection system
feature.
[discussed in 4c]
12. Connection of our permitted industry sampling data to the industries.
[discussed in 4a]
13. A function for mapping non-permitted industries (Dunn and Bradstreet Database) that
discharge to the sanitary sewage system.
[addressed by lc]
Geodesy ¯8 California Street ¯Suite610 ¯San Francisco, CA 94111 ¯Te1(415)677-8750 ¯Fax(415) 677-8751
Page 5 of 5
14.A function for listing all non-permitted industries (Dunn and Bradstreet Database) that
discharge to a selected collection system feature.
[discussed in 4c]
15. Connection of utilities data for fresh water usage.
[discussed in 4b]
16. Functions for calculating loading to a selected point in the collection system using sampling ¯
data for the industries.
[discussed in 4c]
There is also interest in having information for Stanford property, particularly for the first 5
items. Is this a possibility?
[discussed in 4d]
Geodesy ¯8CalifomiaStreet t Suite610 ¯San Francisco, CA 94111 ¯Te1(415)677-8750 ¯Fax(415)677-8751
December 8, 2000
Dave Matson
]-he City of Palo Alto
250 Hamilton Avenue
Palo Alto, CA 94303
RE: Proposal for consulting and development to integrate PAGIS with PCSWMM 2000.
Dear Dave,
Joe Teresi and Matt Raschke (Public Works Department) are interested in using the
Environmental Protection Agency’s Storm Water Management Model (SWMM) to provide
engineering and decision support for the management of the City’s storm water system.
SWMM is a comprehensive computer model used for the analysis of quantity and quality
problems associated with urban rainfall runoff.
To this end, Geodesy proposes to provide software development and consulting to integrate
PAGIS with a third party software package that provides an interface to SWMM.
Public Works Objectives
]-he City staff is looking to the EPA SWMM program to satisfy needsin three areas.
1)Populate attribute data on structures and conveyances indicating the static level of water
for 10 year flood and 100 year flood states. This data should be made available to City
staff through PAGIS applications such as FIo, MapView and Gist.
2)Develop "what if" scenarios ,and analyse alternative designs.
3)Present dynamic views of the system to provide decision support for the CIP process.
Approach ~
The suggested approach is to automate the transfer of data from PAGIS, where the storm
features and attribute data are maintained, to PCSWMM 2000 and back. Geodesy will extend
FIo, the City’s existing Storm Water Management application, to support this hi-directional
transfer of data.
PCSWMM 2000 is a Microsoft Windows application developed and marketed by Computational
Hydraulics International (http://www.chi.on.ca/pcswmm.html). It is designed to load the EPA’s
SWMM model, run it, and present the results. If, after some initial investigation, the City finds
that PCSWMM does not meet their needs, another product with similar data import/export
capabilities may be used in its place (MIKE SWMM by DHI is a possible alternative).
Activities
Geodesy proposes to provide software development and consulting to support:
¯the addition or alteration of the PAGIS metadata to support basins, basin rainfall statistics,
and additional attribute fields for data required by or returned from PCSWMM.
Geodesy ¯8 California Street ¯Suite610 ¯San Francisco, CA 94111 ¯Te1(415)677-8750 ¯Fax(415)677-8751