Download CIP 5457 - The RFP Database

City of San Ramon
REQUEST FOR PROPOSALS
Traffic Signal Management System Upgrade: Bollinger Canyon Road and Crow Canyon Road (CIP 5457)
to alleviate repetitive data entry, the advanced traffic management system software shall
allow the operator to copy and paste data tables for use with other Windows based
applications. The operator shall be able to edit and view the same entry across multiple
devices. The operator shall be able to copy the database fields from one controller to
another controller. The data entry interface shall include automated safeguards such as
range check, to preclude dangerous or undesirable intersection operation. The system
shall provide a database comparing function and show only the differences between
selected device database.
7.1.1.5 Database Backup
All the database backup and recovery should be through the City’s existing backup
system.
7.1.1.6 Database Report
The advanced traffic management system software shall allow users to generate reports
from a library of pre-formatted and customizable report templates from the database. The
operator shall be able to print complete or selectable controller database information. The
database information shall be easily exported to other windows applications.
7.1.1.7 Upload/Download
The advanced traffic management system software shall be capable of an instant full or
partial (e.g., screen, page, or category) upload/download on a system-wide, section, group
or intersection basis. The upload/download procedure shall not cause any field devices to
operate off-line or into an abnormal operation mode (e.g., flash operation for traffic
controllers). The advanced traffic management system software shall highlight errors or
missing data in timing plans prior to permitting download of the timing plans to a
controller. The advanced traffic management system software shall generate a
comparison report listing all data discrepancies between the database and controller. The
advanced traffic management system software shall write this report to a text file for
printing or editing.
7.1.1.8 Failure Monitoring
The advanced traffic management system and field devices shall constantly monitor the
system to diagnose and report on component failures. Upon failure, the advanced traffic
management system software shall treat the failure as an event alarm and record it in an
event log. When the failed component becomes operational again, an event alarm shall
also be recorded in the event log.
7.1.1.9 Scheduler
The advanced traffic management system shall provide an automated system
administration that performs pre-programmed, automated tasks such as full controller
status, data collection, time synchronization, database verifications, etc. The collected
information shall be stored on the server and be available for retrieval all the time. The
users shall be able to perform all the pre-programmed tasks manually without
interference with the scheduled tasks.
June 12, 2009
28