HomeMy WebLinkAbout1998-06-22 City Council (20)City of Palo Alto
City Manager’s Report
TO:
FROM:
HONORABLE CITY couNCIL
CITY MANAGER DEPARTMENT:UTILITIES
11
AGENDA DATE: JUNE 22, 1998 CMR:283:98
SUBJECT:APPROVAL OF CONSULTING SERVICE CONTRACT WITH
GEODESY FOR APPLICATION DEVELOPMENT FOR THE
GEOGRAPHIC INFORMATION SYSTEM
RECOMMENDATIONS
Staff recommends that Council approve and authorize the Mayor to execute the attached
Amendment No. 6 to Contract $3036240 with Geodesy in the amount of $159,790 for
software application development associated with the Geographic Informatin System (GIS).
DISCUSSION
Project Description
The Geographic Information System (GIS) was originally approved in August 1989. This
project is a joint effort of the Utilities, Public Works, and Planning Departments. A contract
for a citywide basemap was awarded in April 1993. Application development will ease 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.
Charles Eitzel, a partner of Geodesy has been closely involved with the City from the initial
benchmark testing in 1989 with McDonnell Douglas to Geodesy’s current contract for
application development and database design. Mr. Eitzel’s unique understanding of the
City’s customized GIS makes this award a sole source contract.
RESOURCE IMPACT
The contract will be in the amount of $159,790 and the funds are included in the FY 1998-99
CIP Project 19618.
CMR:283:98 Page 1 of 2
POLICY IMPLICATIIONS
This amendment does not represent any change to existing City policies.
ENVIRONMENTAL ASSESSMENT
Approval of this contract amendment does not constitute a project under California
Environmental Quality Act (CEQA), therefore, no environmental assessment is required.
ATTACHMENTS
Amendment No. 6
Exhibit A - Scope of Work
Exhibit B
PREPARED BY: Glenn E. Loo, Manager, Utilities Information Systems
Utilities Administration
DEPARTMENT HEAD REVIEW:
CITY MANAGER APPROVAL:
EDWARD J. MRIZEK
Director of Utilities
EMILr~~SON -=
Assistant City Manager
CMR:283:98 Page 2 of 2
AMENDMENT NO. 6 TO CONTRACT NO. $3036240
BETWEEN CITY OF PALO ALTO AND
GE ODE SY
This Amendment No. 6 to Contract No. $3036240 is entered
into , 1998, 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 NOo
("CONTRACTOR").
RECITALS:
WHEREAS, CITY and CONTRACTOR have entered into Contract
No. S3036240 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:
SECTIQN 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...
~2~¢J~. 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 Fifty-Nine Thousand Seven Hundred
Ninety Dollars ($159,79~ 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, 1998 to June 30, 1999."
980605 syn 0071457
1
SECTION 4. All other provisions of the Agreement not
amended herein by this Amendment No. 6 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 Mayor
APPROVED AS TO FORM:
Senior Asst. City Attorney
APPROVED:
By:
Title:
Assistant City Manager
Director of Utilities
Director of Administrative
Services
Purchasing/Insurance Review
2
980605 s’yn 0071457
CERTIFICATE OF ACKNOW-LEDGMENT
Civil Code § 1189)
STATE OF
COUNTY OF
)
)
)
On~’~#~-~v~--~-~ //! /~7 ~, ~ - , before me,-,Z~’~J+,, ~o<~r. ~~ ~n a~ ~or ~a~;oun<~, ~r~ona~,a~eare~ ~-~.~.C~. ~~i ,,,
, personally kno~o me "’ -- ~ ~ ’-~’
c~ to be the person(s) whose name(s) is/~
subscribed to the within instr~ent, and acknowledged to me that
he/~ executed the same in his/ hcr/th~i~ authorized
capacity(ies), and that by his/~~ signature(s) on the
instr~ent the person(s), or the entity upon behalf of which the
person(s) acted, executed the instr~ent.
WITNESS my hand and official seal.
980605 syn 0040800
June 1, 1998 ExhibitA Page 1
Scope of Work for Fiscal Year 1998 - 1999
This scope of work describes the tasks to be performed by Geodesy in support of the
PAGIS project for fiscal year 1998 - 1999. The primary focus this year is on support for
the acceptance and maintenance of the GIS data from Landmark. The secondary
focus is on support for the transition away from GDS towards a new GIS data store and
application environment.
Activity 1: Application Extensions, and Support
These tasks continue existing GIS application efforts.
1.1 Feature Editor Support and Enhancements
The Feature Editor is an existing GDS GEL application through Which PAGIS data is
maintained. This task will provide time for Feature Editor software maintenance and
minor enhancements.
1.2 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.
1.3 Applica,tion Maintenance
This task will provide time for enhancements to PCPipe applications such as Customer
Service, Project Setup, FLO (storm water) and PMMS (pavement). Examples of
maintenance and enhancement activities include porting applications from 16-bit to 32-
bit and the incorporation of functionality such as the ad-hoc view and query systems
developed for the Tree Management application.
1.4 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.
June 1, 1998
Activity 2:
Exhibit A
Data Acceptance and Naintenance Support
Page 2
The tasks under Activity 2 directly support of the City’s accelerated schedule for the
acceptance of the data converted by Landmark, the processing of the data to make it
application ready, and the setup of the data maintenance application.
2.1 Leader Line Method for the Feature Editor (FE)
This task will provide time to either alter the existing annotation method or add a new
method to include leader lines in the Feature Editor. The method will connect the
leader to the annotation cluster and provide for some automatic alterations when
annotation is moved and/or deleted.
2.2 Resolve Redundant Feature Identifiers
The GIS data contains redundant unique identifiers (e.g. manhole IDs as used on the
Block Maps, not system assigned IDs). This task will provide time to develop a program
to identify and resolve these redundant domain IDs. Where conflicts are found, the ID
will be altered to make it unique. All changes will be logged.
2.3 Place Unique Identifiers on All Features
Every feature in the GIS requires a unique system ID.. A program to add a system
assigned unique ID to all features, including annotation, will be developed.
2.4 Resolve Issue of Multi-Scaled Features in Electric Distribution
Different portions of the electrical distribution system data must be displayed and
plotted at different scales. This task will provide time to support the. City staff in
resolving the multi-scale data storage and output design issues.
2.5 Eliminate Redundant Symbols
A redundant feature is one which is identical in name, attribute value(s), location,
rotation, scale, and geometry to one or more other features on the same drawing.
Some redundant features exist in the converted GIS data. This task will provide time to
develop a program to detect and remove redundant features where the redundancy is
certain. When features are found where the redundancy is probable but not certain,
the location will be logged to enable a user to easily visit the site of the suspected error
at a later date.
2.6 Build Feature Network
To use the City’s existing network tracing software, the features in utility networks (such
as gas or wastewater) must be aware of their connectivity relationships with adjacent
features. A program to scan a utility network and populate a link-node table will be
created under this task. Locations where the connectivity is questionable will be
identified in a log which may be used by a user to interactively correct-connectivity
problems at a later date.
June 1, 1998 Exhibit A Page 3
2.7 Install and Debug the Feature Editor
This task will provide for the installation, setup, debugging of the Feature Editor.
2.8 Feature Editor User Training and Documentation
A user document which describes the Feature Editor panels will be developed under
this task. Also, Geodesy will provide support the City staff who will perform the end-
user training.
2.9 Install and Debug the View Manager
This task will provide a small amount of support to the City staff for the installation an
debugging of the GEL View Manager. The View Manager operates in conjunction with
the Feature Editor.
2.10 Design and Set Up the GIS Oracle Database
This task completes the design and setup of the Oracle portion of the GDS GIS
database. The construction and population of the Oracle-based data dictionary will
also be included in this task.
2.11 Document Related GIS Databases.
During fiscal year ’97-’98, an inventory of databases with potential ties to the GIS was.
developed through a series of interviews with City staff. This information will be
documented and summarized under this task.
Activity 3: Transition Development
The 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 GIS database away
from GDS. Currently, the top candidate for the next generation GIS uses an RDBMS
as the primary data store and software components which replace the GDS map
window in existing Visual Basic PCPipe applications.
3.1 Support Data Conversion to the New GIS Data Store
Prototypical work was performed in fiscal year ’97-’98 to scan GDS drawings and load
an Oracle RDBMS with spatial and attribute data. This task will provide time to refine
this process and support City staff in their conversion efforts.
3.2 Convert PCPipe Applications to Use New GIS Components
This task will replace the GDS functions in most of the City’s PCPipe applications with
components which can directly read the RDBMS based spatial data. Once these
applications are upgraded, they will no longer require a connection to GDS.
June 1, 1998 Exhibit A Page 4
3.3 Low Cost Application Development and Data Distribution Tool Research
Geodesy will perform a high level review of several commercial products which may be
used to provide GIS data to casual users throughout the City at little or no cost per
seat.
3.4 Web-Enabled GIS Interface Research
Under this task, Geodesy will review the market for World Wide Web technologies
which may be employed to provide access to the City’s RDBMS based GIS data¯
3.5 Feature Editor Port to Access the New Data Store
Under this task, the non-graphic portion of the Feature Editor will be re-developed to
operate on the RDBMS data through a WindOws interface. Capabilities of this FE
replacement application will include the ability to click on a feature in a map window
and alter the feature’s attribute values. It is expected that this application will be
extended in subsequent years to provide the full range of feature-centdc graphic editing
currently provided by FE.
3.6 Investigate New Spatial Database Programming Interface(s)
One of the primary benefits of the current 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 4: CPA Staff Support and Development
4.1 GIS Steering Committee and User Group Meetings
The GIS Steering Committee and the GDS/AutoCAD User Groups meet periodically.
This task will provide for meeting preparation and attendance.
4.2 Staff Training and Support
Informal staff tutoring on the use of GDS, Oracle, and GIS applications 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.
June 1, 1998 Exhibit A Page 5
4.3 Documentation
In support of software maintenance, this task will provide time to produce overview
documentation for existing applications. The documentation should include a bdef
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 98-99
TASK
Activity 1: Application Development, Extensions and Support
1.1 Feature Editor Support and Enhancements
1.2 Network Tracing Extensions
1.3 Application Maintenance
1.4 Thematic Mapping
Activity 2: Data Acceptance and Maintenance Support
2.1 Leader Line Method (-10b)
2.2 Resolve Redundant Feature Identifiers (24)
2.3 Place Unique Identifiers On All Features (25)
2.4 Resolve Issue of Multi-Scaled Features in EL Support (26)
2.5 Eliminate Redundant Symbols (2.7)
2.6 Build Feature Network (38)
2.7 Install and Debug FE (45)
2.8 Train Users on FE, Provide User Docs (47)
2.9 Install and Debug View Manager Support (48)
2.10 Design and set up Oracle database (21)
2.11 Review utilities databases (14)
Activity 3: Transition Development
3.1 Support Data Conversion to New Data Store
3.2 Convert Applications To Use New GIS Controls
3.3 Low Cost App Dev/Data Distribution Tool Research
3.4 Web-Enabled GIS Interface Research
3.5 FE Port To Access New Data Store
3.6 Investigate New Spatial Database Programming Interface(s)
Activity 4: CPA Staff Support and Development
4.1 GIS Steering Committee and User Group Meetings
4.2 Staff Training and Support
4.3 Documentation
Total Hours:
Hourly Rate ($95 per hour):
1-June-98
80
7O
100
80
8O
24
4O
4
32
96
120
8O
24
100
40
80
160
24
24
120
60
24
100
120
1682
$95
$159,79O
Page 1