HomeMy WebLinkAbout1997-06-23 City Council (40)City of Palo Alto
City Manager’s Summary Report
TO:HONORABLE CITY COUNCIL
FROM:CITY MANAGER DEPARTMENT: UTILITIES
AGENDA DATE: JUNE 23, 1997 CMR:282:97
SUBJECT:Approval of Amendment No. 5 to Consulting Service Contract with
Geodesy for Application Development for the GEOGRAPHIC
INFORMATION SYSTEMS (GIS)
REQUEST
This is a request for approval of the attached Amendment No. 5 to Contract $3036240 with
Geodesy, a general partnership, for software application development associated with the
Geographic Information System (GIS). This is one of three separate contracts requested for
support of the GIS.
RECOMMENDATIONS
Staff recommends that Council approve and authorize the Mayor to execute the attached GIS
application development Amendment No. 5 to Contract $3036240 with Geodesy in the
amount of $121,600.
POLICY IMPLICATIONS
This amendment does not represent any change to existing policies..
EXECUTIVE SUMMARY
The Geographic Information System (GIS) is a joint effort of the Utilities, Public Works, and
Planning Departments. Application development eases end-user interaction with the GIS by
developing menu-driven access to frequently used functions. The goal for providing menu
selections for commonly used functions is to allow casual users to interact with the GIS and
reduce the amount of training required to use the GIS productively. Development is focused
in three areas: counter applications for the public; informational map development; and
project management applications.
CMR:282:97 Page 1 of 2
Geodesy has been closely involved with the City from the initial benchmark testing in 1989
with McDonnell Douglas to its current contract for application development and database
design. Geodesy’s unique understanding of the City’s customized GIS, the software used
by the City, and the City’s data and requirements makes this award a sole source contract.
FISCAL IMPACT
The contract Amendment will be in the amount of $121,600 and the funds are included in the
FY 1997-98 CIP.
ENVIRONMENTAL ASSESSMENT
Approval of this contract amendment does not constitute a project under California
Environmental Quality Act (CEQA); therefore, no environmental assessment is required.
PREPARED BY: Glenn E. Loo, Supervisor Computer Services,
Utilities Administrative Services
DEPARTMENT HEAD REVIEW:
CITY MANAGER APPROVAL:
Manager
CMR:282:97 Page 2 of 2
AMENDMENT NO. 5 TO CONTRACT NO. $3036240
BETWEEN CITY OF PALO ALTO AND
GEODESY
into
municipal
Geodesy,
This Amendment No. 5 to Contract No. $3036240 is entered
, 1997, by and between the City of Palo Alto, a
corporation of the State of California ("CITY") and
a general partnership (Taxpayer’s Identification No.
("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 modify their
contract to reflect a new scope of services, a modified
compensation scheme, and a term of services;
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 new Exhibit A,
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:
"For the full performance of the services described
herein by CONTRACTOR, CITY shall pay CONTRACTOR a total
sum not to exceed One Hundred Twenty-One Thousand Six
Hundred Dollars ($121,600), payable at the rate of
Ninety-Five Dollars ($95) per hour, upon submission by
CONTRACTOR of its itemized billings in triplicate, in
accordance with the terms of the new Fee Schedule,
attached hereto as Exhibit "B" and incorporated herein by
this reference."
SECTION 3. Section 6 of the Agreement is hereby amended
in its entirety to read as follows:
"The services to be performed hereunder shall
commence on October 9, 1992, and the time for performance
shall be extended from July i, 1997 ~to June 30, 1998."
SECTION 4. All other provisions of the Agreement not
amended herein by this Amendment No. 5 to Agreement shall remain in
full force and effect.
1
970527 syn 0070993
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 Mayor
APPROVED AS TO FORM:
Senio~ Asst. City Attorney
APPROVED:
Assistant City Manager
GEODESY
By:
Title:
Director of Utilities
Acting Director of
Administrative Services
Risk Manager
970527 syn 0070993
CERTIFICATE OF ACKNOWLEDGMENT
(Civil Code § 1189)
STATE OF
COUNTY OF
)))
On ~ /~y, before me,~9~
personally
appeared ~ ~-
, personally known to (or proved to on the basis of
satisfactory evidence) to.be the person~s~ whose name(~ is/a~-e
subscribed to the within instrument, and acknowledged to me that
he/~4~v~-Ae~~ executed the same in ~---~erT~ authorized
capacity(d~, and that by his/!~r~~ signature(F~ on the
instrument the person(~, or the entity upon behalf of which the
person~) acted, executed the instrument.
O
WITNESS my hand and official seal.
970527 syn 0040800
May 6, 1996 Exhibit A
Scope of Work for Fiscal Year 1997 - 1998
Page 1 ~
This Scope of work describes the tasks to be performed by Geodesy in support of the
PAGIS project for fiscal year 1997 - 1998. The primary focus this year is on PCPipe
application development. Unless otherwise stated, all application development will be
PCPipe based.
Activity 1: Application Development, Extensions, and Support
1.1 Tree Management
The Tree Management application will link the tree inventory in the existing tree
management program to GIS locations. This application will provide the capability to
¯add, move and delete tree locations in the GIS database,
¯alter tree attribute data for individualtrees,
,,find a tree or a list of trees based on an attribute query,
o display on-screen and create thematic plots for trees based on attribute criteria
such as infestations and disease, and
¯view the tree inventory with the orthophoto backdrop.’
The query and thematic capability will be provided through the integration of the Ad-Hoc
Query and Thematic Mapping tasks defined in the Informational Map Development
activity section of this exhibit.
1.2 Feature Editor Support and Enhancements
The Feature Editor is an existing GDS GEL application through which PAGIS data is
maintained. This task provides time for Feature Editor software maintenance and minor
enhancements.
1.3 Network Tracing Extensions
The current network tracing Software supports tracing upstream and downstream in
gravity based systems and collecting information along the way. For example, an
upstream trace through the waste water system could yield a report of pipe sizes,
materials, and conditions. This task will extend the current network tracing capability to
include bi-directional systems such as gas and water.
May 6, 1996 Exhibit A Page 2
Activity 2: Customer Service Support and Enhancements "
The Customer Service application provides front counter support to City staff who are
responding to requests for parcel based information from the public. Activity 2 includes
tasks intended to extend the functionality of the Customer Service application. With
these extensions, it is expected that the application will be used by City staff as a
general GIS data viewing tool in addition to its initial use at front counters.
2.1 Dimension the COGO Map
This task supports the creation and execution of a program which will annotate each
boundary line in the Cadastral COGO map with its bearing and distance. This
annotation will be placed on the GDS drawing as permanent features and incorporated
into a GDS view which will be added to the current list of Customer Service views.
2.2 View Manager
The View Manager will provide the ability for users to customize a view by including
specific feature classes. This extension to the Customer Service application will provide
a list of all the feature classes (such as storm drain manholes and road edges) available
in the GIS. The user may then select the feature classes they wish to include in the
view, identify a Color for each feature class, and set the display order of the feature
classes. These customized views may be saved under a user defined name and then
recalled by the user at any time.
2.3 Add Buffer Search to Customer Service " ~i
The current Buffer Search application uses GDS menus and GDS XBasic programs
which provide options for selecting a parcel, defining a buffer distance and then building
a list of all the parcels which fall within the buffer distance. These lists may be saved
and recalled by their user defined case number. The lists of parcels may be transferred
to a personal computer where an MS Access application is used to create mailing
labels.
This task includes time to extend the Customer Service application to include the
functionality of both the GDS and MS Access components of the current Buffer Search
application.
2.4 Additional Data Fields
This task provides for the incorporation of additional data fields such as flood zones and
additional Assessor’s data into the application’s attribute form and plot.
May 6, 1996 Exhibit A
Activity 3: Informational Map Development
3.’1 General Feature Query
Page 3 "~
A feature query provides a list of attributes and attribute values for a selected feature.
Both the FIo and Customer Service applications have special purpose feature query
capabilities. This task will provide for the generalization of these specialized feature
queries so that a query may be performed on any feature in the GtS. The list of
attributes to be included in the feature query will be restricted to GDS based properties.
3.2 Ad-Hoc Query
Ad-hoc queries Support the identification and display of features which meet user
defined attribute criteria. This task will build an interface for the creation of ad-hoc query
criteria and display of the identified features. For example, the interface will support the
user in entering criteria to find all the waste water pipes made of vitreous clay that have
a diameter greater than 10" and an install date equal to or earlier than January 1, 1978.
Once the query has been executed, the user may view the identified features one at a
time or display then all at once.
3.3 Thematic Mapping
A thematic map is a display of features where a visual characteristic (such as color) of
the feature is determined by the value of one of the feature’s attributes, For example,
water mains may be colored based on their material. This.application will support the
definition and display of features thematically. The user will be able to select the feature(
Class which is to be the subject of the map, the attribute on which the theme will be
based and the colors to be used for the attribute values or ranges of values.
Activity 4: Transition Development,
Tasks in this activity are focused on research intended to support the City staff in their
investigation of products or strategies for the migration of the GI.S database away from
GDS.
4.1 GDS Dummy Session Display For PCPipe
Under this task, proof-of-concept software will be developed to demonstrate (1) a plot
based approach and (2) an object scan approach to using a GDS dummy session for
GDS graphic display. Either of these approaches may eliminate the need for both GDS
and X-terminal licenses as well as simplify the development of printing from Windows.
It is expected that either approach will be slower in display than the current X-terminal
approach. The intent of the prototyping is to determine if the performance of a dummy
session approach is adequate,
May 6, 1996 Exhibit A Page 4
4.2 TestNew Spatial Database Programming Interface(s)
One of the primary benefits of the 6urrent application development using PCPipe is that
the application code may be ported to work with other spatial database engines.
Although a move to a new spatial data store is not eminent, it is expected to happen
over the next two to five years. The purpose of this task is to (1) provide the City and
it’s application developers with information to aid in the prioritization in the current
development efforts, and (2) to surface application conversion issues.
Under this task, Geodesy will support the City staff in the investigation of spatial
databases and application programming interfaces.
Activity 5: CPA Staff Support and Development
5.1 .GIS Steering Committee and User Group Meetings
The GIS Steering Committee and the GDS/AutoCAD User Groups meet periodically.
This task provides for meeting preparation and attendance.
5.2 Presentations
The City of Palo Alto occasionally demonstrates PAGIS to City staff, management, and
visitors from other organizations. This task includes time for demonstration preparation
and delivery: ,
5.3 Ad-hoc Map Products
As the City staff has become aware of the data. availability and map generation
capabilities of PAGIS, requests for unique map products have been increasing. This
task provides time for responding to staff requests for ad-hoc maps.
5.4 Staff Training and Support.
Informal staff tutoring on the use of GDS and Oracle has proven to be an effective
approach to improve Palo Alto technical staff skills and support project work. This task
continues the current level of staff training and phone support.
5.5 Quality Control Support
This tasksprovides programming support for on-going quality control efforts..
5.6 Documentation
In support of software maintenance, this task provides time to produce overview
documentation for existing applications. The documentation should include a brief
description of each application’s architectural approach, the application’s tabular and
graphic data sources, and a narrative (1 to 2 pages) describing the client based
software code.
Exhibit B
Estimate for FY 97-98
TASK
Activity 1 :
1,1
1.2
1.3
Activity 2:
2.1
2.2
2.3
2.4
Activity 3:
3.2
3,3
Activity 4:
4.1
4.2
Activity 5:
5,1
5.2
5.3
5.4
5.5
5.6
Application Development, Extensions and Support
Tree Management
=eature Editor Support and Enhancements
Network Tracing Extensions
Customer Service Support and Enhancements
Dimension COGO Map
View Manager
Add Buffer Search to Customer Service
Additional Data Fields
Informational Map Development
~General Feature Query
Ad-Hoc Query
,Thematic Mapping
!Transition Development
GDS Dummy Session Display For PCPipe
Investigate New Spatial Database Programming Interface(s)
CPA Staff Support and Development
GIS Steering Committee and User Group Meetings
Presentations
Ad-hoc Map Products
Staff Training and Support
Quality Control Support,
Documentation
Total Hours:~
Hourly Rate ($95 per hour):
Hours
2O0
8O
120
t0
80
8O
24
4O
150
110
lOO
100
18
8
40
40
6O
7280
$121,6O0
Page 1