The URL can be used to link to this page

Home My WebLink About22-Information Services CITY OF SAN BERNARDINO REQUEST FOR COUNCIL ACTION From: Janis Ingels, Director of M_I_S_ Subject: Authorization to purchase Dept: Administration, M.I.S. Division City Network Upgrade Date: July 8, 1997 Sri Yr/' � Synopsis of Previous Council action: 8/8/96 Council approved Police grant for purpose of upgrading Police CAD and RMS. 11/4/96 Council approved RFP process for City Network Upgrade. 12/2/96 Council approved $3.3 million in City Hall refinance bond issue funds for City Network Upgrade. 7/7/97 Council approved a second Police grant for technology upgrades and other uses_ Recommended motion: 1_ That said resolutions A through D be adopted_ 2. That the adequacy of current M.I.S. staffing levels to support the network upgrade project be referred to Council Personnel Committee. Res 97- ,)qt Res 97- G�� C_ Res 97-;j? Res 97- Signature ' �� Contact person: Janis Ingels Phone: 384-5010 Supporting data attached: Staff report, Agreements Ward: FUNDING REQUIREMENTS: Amount: $4,770,964 Source: (Acct. No.) See staff report, cost section Acct. Description) Previously - # o�41,4-_D -c-71-111f 7 Finance: Council Notes: -3 8 ve-le 75.0262 /J ,_ Agenda Item No._ CITY OF SAN BERNARDINO - REQUEST FOR COUNCIL ACTION STAFF REPORT PURPOSE OF UPGRADE Current CAD/RMS software is 11 years old. The vendor no longer has technical support staff with the knowledge level required to properly maintain this outdated version of their software. The software will not calculate dates properly as of 01/01/2000. Information captured and stored on both CAD and RMS is date stamped for both informational purposes, and in some cases, for legal purposes. The Fire Department shares usage of the CAD computer. Police cannot use their grant funds on the Fire Department's share of a new CAD or on Fire RMS. The Fire's current RMS is a small standalone system incapable of meeting the department's needs. The Office Automation (OA) computer,used by both public safety and non-public safety, has exceeded its maximum capacity, and cannot continue to support the City's OA needs. Usage has increased from 50 users in 1990 to over 600 users. The Police Department is waiting to add 200+ users. The current machine runs the VMS operating system. OA is accomplished through use of a DEC product for VMS called All-In-1 which encompasses WordPerfect for VMS and Lotus 1-2-3 for VMS. DEC no longer supports All-In-1. VMS based OA applications experience infrequent upgrades and enhancements, unlike PC based Windows OA applications. VMS based OA is likely to become obsolete and is difficult to learn and use compared to PC based applications. Most new hires and employees with home computers are knowledgeable in the use of Windows based OA applications. The San Bernardino County Sheriff's Department (SBSO) has announced their move to NT, Windows 95, and a client/server environment. They have also chosen Tiberon's software. It is important to the Police Department to remain compatible with the SBSO for sharing of critical information. SOLUTION The RFP for the Information Systems Network Upgrade project was sent by Purchasing on March 6, 1997 to a total of 17 vendors. Three responses were received. An evaluation form was developed and raters identified. The network component is the most critical component of the project. Dr. William Aguilar, Vice President of Information Resources and Technology at Cal State, San Bernardino, was asked to review the three bids. He recommended Mr. Jim Bentley,Network Engineer, in Cal State's Network Services Division, as the most qualified technical resource for evaluating the bids. The other rater was Jim Babinski,Director of MIS for the City of Fontana, along with MIS Technical staff. Based on the evaluation criteria, the Committee of raters recommended the firm of Spire Technologies, Inc. Spires' proposal was also the least expensive. MIS and Spire began further negotiations on June 3, 1997. Spire acquired 2 for 1 pricing for network management stations, saving the City $20,000. Spire negotiated an agreement with Digital Equipment Corp (DEC) to allow the City to take advantage of DEC's Education, State, and Local Government (ESL) program pricing for PC's for thousands in savings. Spire offered the DEC PC's with a clone chip at a savings of another$144,000 to the City. Each month throughout the term of the 1 r ' project, Spire will provide the City with a menu of enhanced PC configurations being offered at the time for the same or less money. The original CAD/RMS replacement cost estimate was $1.3 million at the time Council approved the Police Department's grant application. The current cost, including Fire, is $1.8 million. This required further reduction of the balance of the project. Spire and MIS worked to pare down costs without significantly affecting the project. Final total cost is $4.7 million, which is $1.5 million less than the original estimate. Careful attention was given in all areas of the project to expansion capabilities to increase the life span of the City's investment. Spire will act as prime vendor with a total of nine subcontractors, to manage and complete the project. MIS STAFFING LEVELS The proposed vender has made reference to the issue of staffing resources within the MIS Division to adequately support the City's current and future technological environment. The complexity of the new client/server environment, and the supporting network infrastructure are expected to further impact the City's demand for MIS services and timeliness of delivery. It is recommended adequacy of current MIS staffing level to support the upgraded City technology environment be referred to Council Personnel Committee for their review. CONTENT • Upgrades to inventory of existing PC's and printers to retain usage in new environment. • Approximately 150 PC's for Police 50 PC's for Fire up to 200 PC's for remainder of City • Win 95, Microsoft . exchange email, Microsoft Word word processor, Microsoft Excel spreadsheet. • OA training • Interscan Neatsuite virus protection • SMS (Systems Management Server)network management tool • KEA terminal emulation for access to existing business system server • Sidewinder firewalls,H/W& S/W • clearVISION network management for windows • frame relay connections to remote sites • migration to TCP/IP • Internet access for authorized personnel • Web services PC and internet e-mail addresses for City officials;web site development tool • Net Rider dial-in capabilities with extensive security features • GIS upgrade from GDS S/W(Graphic Data/Systems)to Arclnfo S/W(by ESRI of Redlands) and replacement of the three GIS workstations. • OA NT servers • Cabling and network peripherals as needed at each site. • Approximately 22 handheld computers in lieu of desktops for Code Compliance field inspectors, and M-Track Code Compliance S/W,which integrates with City permit tracking software. • One imaging retrieval station for shared use on the 6th floor of City Hall (Mayor, Administration and City Attorney) • One imaging scanning and retrieval station for shared use on the third floor of City Hall (Planning and Public Works). 2 • Addition of stand alone remote sites to City network • Data conversion of selected OA documents from old to new environment • Helpdesk services for the transition period from VMS to Windows OA applications The majority of the above list applies to Police and Fire,plus the following: • Latest version of Tiberon,Inc. Public Safety S/W CAD/2000 and Police RMS/2000 products include modules such as: Realtime CAD mapping; MDT interface; ASAFE/CLETS/NCIC interfaces; property/evidence management; warrant tracking; criminal and juvenile records; traffic management; investigative case management; crime analysis system; P&T; gang system; officer activity; bicycle registration; special intelligence; neighborhood watch; calls for service; field reporting; and document imaging interface. • Fiber enhancements in the main Police Station • Addition of"fast ethernet"for CAD • Oracle 7 (Relational Database Management software) • CAD&RMS DEC Alpha Unix Servers • CAD dispatch workstations and CAD call taker workstations • OA and CAD/RMS software training classes • Addition of 2 Police sites and 11 Fire sites to the network • DEC 900 network hubs and peripherals in main Police Station • All new cabling in main Fire Station • Hardware warranty/maintenance upgrade to 24 x 7, on-site coverage for critical CAD system • Network management PC and software • Latest version of Tiberon, Inc. Fire RMS/2000 product which includes modules for: CFIRS incident reporting; Fire prevention; P & T; Hazardous materials; Apparatus/Equipment Maintenance; Inventory . CAD/2000 product also incorporates a MOSCAD interface for Fire. COST Within the course of the upgrade,where lesser quantities are found to be needed of any item,the City is obligated to purchase only actual quantities needed. 97/98 annual Tiberon Maintenance will be prorated as of the date new software is determined to be fully operational. Any refund will be credited toward the project cost. The debt service payment of $458,000 is budgeted in the 97/98 MIS budget. The term of the debt service schedule is 10 years. UPGRADE COSTS Tiberon CAD/RMS software $1,830,108 Balance of Tiberon project,network requirements $2,687,356 and OA replacement(Spire) County Sheriff for move of CLETS line $ 4,000 Upgrades to dispatch consoles by County $ 48,500 Code Compliance $ 51,000 Contingency fund $_150,000 TOTAL COST $4,770,964 3 FUNDING Police grant of 8/96 $1,114,251 Police grant interest $ 50,000 a CDBG $ 21,864 Police grant of 7/97 $ 321,000 Code Compliance $ 51,000 (97/98 budget) Bond Issue $3,212,849 (includes City match of 8/96 police grant in amount of$101,941) _ TOTAL FUNDS $4,770,964 TIME FACTOR Police grant funds are required to be expended by September 30, 1998. Tiberon requested an 18 month window to complete the Police and Fire conversion effort. If approved on July 21, 1997, the vendor has only a 13 month window in which to complete the project. The VMS based OA computer has been at maximum capacity for months and is impeding the City Departments' ability to use OA capabilities to their fullest to perform daily operations, and to expand their usage requirements. CONCLUSION The City has combined two large critical replacement projects to save money. Two separate procurements would have cost the City more money and lessened the buying power of both police grant and bond issue dollars. Police and Fire CAD/RMS replacement required those departments move to PC's. The two departments represent half the City OA users, adding further incentive to upgrade to PC based OA at this time. MIS and the vendor of choice have worked to adequately meet the City's needs at the least possible expense. Annual budget cuts increase the need within all City Departments for tools to allow them to continue to provide adequate service levels to San Bernardino citizens. The Final agreement is a combination of the original RFP, the vendor's response document and the purchasing services agreements. A project schedule will be developed immediately following award. The network upgrades will take place first to set up the infrastructure required by all other components of the upgrade. The Police and Fire conversion process will be at an accelerated pace and will begin immediately following the network upgrades. Conversion to PC based OA and related training will occur in logical groups within departments and is expected to be completed within a 12- 18 month window. Police and Fire OA conversion will take place in sync with their CAD/RMS conversion. 4 i SPIRE AGREEMENT SPIRE j)i SYSTEMS Final Revision Date Revised 7/3/97 Proposal for Furnishing and Delivering of a Network Upgrade In Response to RFP# F97-18 Prepared for The City of San Bernardino TOTAL PROJECT COST: $ 2 , 687 , 356. i t �I I. EXECUTIVE SUMMARY June 16, 1997 SAN BERNARDINO PROJECT MANAGEMENT TEAM Prime Contractor: Spire Systems, Inc. 311 North State St. Orem, UT 84057 Project Manager: Robert P. Young U.S. Area Sales Manager Spire Systems Team: Fred J. Allen - President, Spire Systems William Oborn - Networks Config. Engineer Denny Hughes - Systems Config. Engineer Carl Ringger - Sales Nat'l Account Manager Chuck Jenson - Customer Services Manager Clarice Christensen - Order Processing Deborah Squires - Financial Administrations ------------------------------------------------------------------ Sub Contractor: Sento Technical Innovations Jeff Webster Vice President SENTO Technical Innovations (801) 226-3355 ext. 211 311 North State Street. Orem, UT 84057 ----------------------------------------------------------------- I! Sub-Contractor: Spire Technologies, Inc. Dennis Smith Network Security Group I' Spire Technologies Inc . (801) 226-3355 ext . 233 311 North State Street. Orem, UT 84057 Dan Nelson Regional Account Manager Spire Technologies Inc . (801) 226-3355 ext. 248 311 North State Street. Orem, UT 84057 ----------------------------------------------------------------- Sub-Contractor: Digital Equipment Corporation Sandy Suyeyabu San Bernardino Acc . Mgr Digital Equipment Corp. (619) 684-4075 (PAGER) San Diego, CA (619) 268-2692 (HOME) Spire Systems, Inc. Final Revision -July 1, 1997 Page 1 Lou Sacharske Network Territory Manager Digital Equipment Corp. (714) 261-4353 24 Executive Park Irvine, CA 92614 Grady Rudolph Digital Service Manager Digital Equipment Corp. (909) 481-2000 8577 Haven, Suite 101 Rancho Cucamonga, CA Kathy Foster NSIS (Project Leader) Digital Equipment Corp. (909) 674-8633 San Francisco, CA Yvonne Martinez MCS Services Manager Digital Equipment Corp. (801) 256-9069 or 9071 6985 Union Park Center 1-800-759-8888 pin #1919095 Suite 400 Midvale, UT 84047 Nick Warr NSIS (Networks) Digital Equipment Corp. (619) 445-1726 San Diego, CA Debi Lee ESL Program Manager Digital Equipment Corp. 1124 Tower Road (847) 781-6572 Schaumburg, Illinois 60173 ESL FAX: 800-524-5694 Gordon MacMillan ESL alternate contact Digital Equipment Corp. 800-722-9332 ext . 869 ----------------------------------------------------------------- Sub-Contractors COMPUSA Agha Nikou Training Ctr Marketing COMPUSA Training Center (909) 387-1550 625 Hospitality Lane San Bernardino, CA 92408 Arnold McClain Training Center Manager COMPUSA Training Center (909) 387-1510 625 Hospitality Lane San Bernardino, CA 92408 Paul Reash General Manager COMPUSA Training Center (909) 387-1501 625 Hospitality Lane San Bernardino, CA 92408 Q'W11 Spire Systems, Inc. Final Revision - July 1, 1997 Page 2 ----------------------------------------- Sub-Contractor: ICG FIBER OPTIC TECHNOLOGIES, INC. Van K. Kotter Senior Account Executive ICG Fiber Optic Technologies, Inc . (801) 532-0500 5032 Amelia Earhart, Suite B Salt Lake City, UT 84116 Christopher Bird Local Account Rep. ICG Fiber optic Technologies, Inc . (310) 781-7420 Torrence, CA John Clark Local Account Rep. ICG Fiber optic Technologies, Inc . (310) 781-7427 Torrence, CA ----------------------------------------------------------------- Sub-Contractors: GTE INTERNET SERVICES Jeff Peterson Account Manager GTE Internet Services (310) 483-6314 17501 East Imperial 3rd Floor Norwalk, CA 90650 Bob Ward Telecommunication GTE Internet Services Account Manager ,.. (909) 944-6233 ----------------------------------------------------------------- Sub-Contractors: Adaptive Information Systems Inc. Todd Tartaglia Sales Representative 26001 Pala (714) 587-9077 Mission Viejo, CA 92691-2705 1-800-678-6978 (714) 587-1933 (Fax) ----------------------------------------------------------------- Sub-Contractors: M-TRACK Software Inc. Will Bullard Sales Representative 100 So. University (501) 664-0065 Suite 321 Little Rock, Arkansas 72205 ----------------------------------------------------------------- Sub-Contractors: PC Business Solutions Larry Pendleton President 280 North Benson Ave. (909) 949-4777 Suite 6 Upland, CA 91786 Spire Systems, Inc. Final Revision -July 1, 1997 Page 3 Sub-Contractors: COMPUCOM SYSTEMS Geoffrey Aludo Account Rep. 10100 N. Central Expressway (909) 949-4777 ----------------------------------------------------------------- f Spire Systems, Inc. Final Revision -July 1, 1997 Page 4 Spire Systems, Inc. is pleased to offer this proposal for a network upgrade to the City of San Bernardino. It has been carefully prepared based on our best understanding of the City's requirements as set forth in the RFP document and on information received during the bidders conference and in subsequent communications with the City and its agents. The City of San Bernardino will find a partner in Spire, with the ability to interface directly with the major supplier of systems and services in this proposal, Digital Equipment Corporation. Spire is one of only 22 direct digital VARs in the U.S. Unlike other Digital reseller's, Spire has direct contact with Digital manufacturing, service delivery units, and product managers. Spire Systems, Inc. is a wholly owned subsidiary of Sento Technical Innovations Corporation, which has been licensing and supporting software for Digital computer systems since founded in 1986. Spire Systems was formed in 1992 to provide Digital Systems Integration solutions to Spire's extensive base of software customers. Spire has helped other enterprises make the transition from OpenVMS to Windows NT. This is the largest single migration most organizations will make within 20 years, or within the span of a professional IT career. For this reason, Spire knows that the transition must succeed at every level, especially with end-users who accomplish their jobs. Spire's transition and training plans are focused on preventing frustrations and maintaining the highest possible level of productivity among City personnel. Spire has special qualifications for providing Office Automation solutions, as a leading provider of Office Automation software in the Digital marketplace for over 10 years. Spire is a Digital Gold Key Services Manager, the highest level of Digital service reseller. This was achieved through a combination of proven proficiency with Digital products and service offerings. Spire offers the full range of Digital services, including warranty uplifts and extensions, complete multi-year agreements, and the renewal, conversion, and management of your service agreements. All services are provided on-site by qualified Digital technicians. Spire is qualified to provide the City of San Bernardino's Network Upgrade because of our established expertise in the following areas: • Office Automation • Networking • User Training and Support • System and Storage Management • Network Management • System Security & "Firewalls" • Custom VAX and Alpha upgrades QW, Spire Systems, Inc. Final Revision - July 1, 1997 Page 5 SECTION II. SUB-CONTRACTORS (MISC. Software and Services ) 1. GTE TELEPHONE: Frame Relay and Internet service's $143,500.00 2. ADAPTIVE INFORMATION SYSTEMS, INC: $34,200.00 A. Image Scanning 3rd floor B. Image Retrieval 6'floor 3. M-TRACK SOFTWARE, INC: $86,500.00 A. Code compliance Hand Held Computer& Software for field inspections SECTION H. TOTAL $264,200.00 GIS Upgrade The GIS upgrade is a relatively small but important part of the City's upgrade plans. The GIS upgrade is interdependent with other upgrades (such as the network) and as such will be scheduled with the City as soon as installation becomes practical. Spire Systems, Inc. Final Revision - July 1, 1997 Page 6 Office Systems Upgrade Spire believes that the Office Systems Upgrade portion of this project is actually the most important--the critical nature of the network and CAD/RMS application--because it is the level at which most City personnel will experience the migration. Spire has developed a plan for staging PC deliveries to the City. Spire will provide 1 Windows NT server in the training facility. The first 15 PCs to be delivered to the City will be set up and connected to the training facility server. These 15 PCs and single server will remain in the training facility until the completion of the contract. ** deleted 5/30/97 Training Spire understands that training is essential to the success of the entire migration process. Users must be comfortable and productive as quickly as possible during the migration. To insure this, Spire proposes using COMPUSA, to provide the professional training services required. COMPUSA is one of the world's largest Authorized Technical Education Center (ATEC) for Microsoft products. Spire Systems, Inc Final Revision -July 1, 1997 Page 7 III. RESPONSE TO REQUIREMENTS 1. Overview of Scone of Work 1.3 Materials and Plans to be Provided Spire will assist in disposing of any surplus equipment that the City wishes to dispose of as the upgrade progresses. As appropriate, Spire will attempt to return the equipment to the manufacturer for trade-in credit, or dispose of it through third-party brokers, such as CPU Options or Great Lakes Computer. Spire will provide a complete and well organized schedule of tasks to be completed within two (2) weeks of execution of the contract with the City. Spire has already developed a preliminary deployment schedule in Microsoft Project. Details of the schedule and start dates will be coordinated with the City and provided within the specified time. Spire has provided a schedule of maintenance costs for the proposed hardware and software through the fifth year. Spire has included for your review a complete 5 year maintenance plan, see letter and maintenance plan from Mr. Chuck Jensen in supporting document section of this bid. Spire is one of the leading sources for Digital services in the Western U.S., with full time staff dedicated to understanding, quoting and managing Digital services. Spire will provide appropriate binders containing all related paperwork, including warranties, schematics, as-builts, and other pertinent documents resulting from the project. Spire will provide all manuals that typically accompany installed equipment. Spire Systems, Inc. Final Revision -July 1, 1997 Page 8 3. Internet Connection 3.1 Introduction Spire is proposing a high-speed connection to the Internet via GTE Internet Solutions. GTE is an ideal single source vendor for telecommunications and Internet connectivity for the City of San Bernardino, because of their experience, the breadth of their offerings, and their value-added services. The key benefits to working with GTE include: GTE uses the highest-capacity IP network in the world. The Internet backbone is fully-meshed, redundant, and power-protected, yielding 99.9% network availability. GTE gives you "one-hop" TCP/IP access to the Internet. Also supporting high- speed connections to over 100 other Internet networks worldwide, more than any other provider, meaning your data can reach its destination with minimum hops and maximum speed. GTE offers a full range of Internet connectivity services, from dial-up connections to multi megabit access. GTE offers customer service twenty-four hours a day, seven days a week. GTE Network Operations Center (NOC) operates twenty-four hours a day, seven days a week. GTE services are available in 543 cities and 13 countries outside the US, thanks to UUNET PIPEX, UUNET Canada, EUnet Germany, and many other international partnerships. GTE boasts a 98% annual customer retention rate. Spire Systems, Inc Final Revision - July 1, 1997 Page 9 3.2. Internet Service Requirements Spire will act as an aid and facilitator to interface Network requirements during the installation of the infrastructure. ** amended 5/30/97 Spire Systems, Inc Final Revision -July 1, 1997 Page 10 3.2.2 TCP/IP Addressing--DHCP, DNS, WINS ** amended 5/30/97 - MIS staff to perform DHCP, DNS, and WINS. DNS: When the average user attempts to access the network resources, the user knows the name of the computer, like SABLE, but not the computer's IP address. If the user is running a PC with NFS client support, or FTPing to the computer, the user will reference the computer by name, e.g. (SABLE), and the system will access a HOST TABLE containing a mapping between the computer name and the IP address. The difficulty of the HOST TABLE lies in its administration: who loads the information in these HOST TABLES?For typical NFS clients, the host table information resides on local computers, which mean that either the users need to know enough about the host files and TCP/IP addresses to update the information on their own, or someone from MIS needs to maintain the information on a server and, have the updated file down loaded periodically. Some environments implement the Domain Name System (DNS) that is server based HOST TABLE information, where the user needs only to specify the address of the DNS server. However, this does not alleviate the matter of updating the information; it simply pushes the responsibility to the MIS department. Although DNS is server based, it is not Dynamic, and must be updated wherever a computer name or IP address is changed. DHCP: The office automation department has a NT server Domain "Business" and a Windows NT Server-based computer,\\SABLE, with an IP address of 200.192. The new client is a Windows NT-based computer with DHCP client support. The windows NT-based client starts NT and issues a DHCPDISCOVER message (containing the MAC address and the computer name, which is picked by the DHCP server. The DHCP server looks at the most recent table of available addresses, and finding no reference to that computer, offers an available address to the computer. Any DHCP server receiving the request (even across a BOOTP-relay router) and having a valid configuration setting for the requesting computer can then check to see if it has an address available. If there is an available address, the DHCP server will offer a DHCPOFFER response with the necessary configuration information and additional parameters; including the destination computers network card address, the offered IP address, the appropriate subnet mask, the IP address of the offering DHCP server, the IP lease expiration date and any other pertinent information specified in the parameter section of the original DHCPDISCOVER request. Spire Systems, Inc. Final Revision - July 1, 1997 Page 11 3.2.3 Internet Security Spire has extensive experience with Internet Security, including an entire department focused on Internet issues. We have provided protection for Web servers nationwide, using tools like Borderware, AltaVista Firewall, and Sidewinder. We have developed a solution for the City of San Bernardino which we believe provides optimum protection at a reasonable cost. 3.2.3.1 Requirements Overview 3.2.3.2 CLETS Advisory Board Approval Required Spire's firewall recommendation for the City of San Bernardino is Sidewinder from Secure Computing. Spire is confident that Sidewinder meets or exceeds the security standards of the California Law Enforcement Telecommunications System (CLETS) advisory board. Our analysis has lead us to conclude that Sidewinder is a more secure solution than the Mergent Gauntlet firewall. 3.2.3.3 Firewalls ** amended 6/10/97 Spire is proposing firewalls running Sidewinder. Spire has chosen this software to meet the requirements of the City. 3.2.3.3.1 Primary Firewall The Primary Firewall, to be located in the City Hall Computer Room, will consist of the following hardware: PRIMARY FIREWALL HARDWARE: 1 FR-B40WW-AC Prioris MX 6200 RAID System Note: to increase performance more memory was added To optimize configuration. 1 FR-PC77M-BK 32-MB (2x16 MB), 2 FR-PC77M-BL 64-MB (202 MB), 1 FR-CECBA-BA SCSI Wide Hard Disk Drive 1 FR-PCB5K-AA Prioris HX 6000 Server Country Kit 1 VRC 15-KA High-Resolution Color Monitor 2 DE500-AA Fast EtherWORKS PCI 10/100 **amended 5-30-97 HARDWARE COST: $8,190.00 INSTALLATION COST: (FM-DECSV-IN) $300.00 Spire Systems, Inc. Final Revision -July 1, 1997 Page 12 PRIMARY FIREWALL SOFTWARE: 1 LI-XUSSWD-UNLM SIDEWINDER UNLIMITED USER LICENSE 1 TN-XUSSDW-DEWX ONE-DAY ON-SITE INSTALLATION AND CONFIGURATION SERVICE (INCLUDING TRAVEL AND EXPENSES) PRIMARY FIREWALL SOFTWARE COST: $20,895.00 SOFTWARE INSTALLATION: (TN-XUSSDW-DEWX) $2,995.00 How Rroxv server will function as a yroxy address server: A proxy is a program that controls communication between clients on one side of a firewall and services on the other side. That is, an application client and application server on opposite sides of a firewall do not communicate directly. Instead, the client and server both "talk" to a proxy which forwards the application data back and forth. Sidewinder provides these Internet services primarily in a transparent fashion using proxy implementations as follows: Network applications are typically accessed using one of two lower level communication protocols: TCP or UDP. TCP is a connection-based protocol that guarantees delivery of data and ensures address integrity. UDP is a connectionless service that delivers data with a minimum overhead, providing a fast and efficient connection. Spire Systems, Inc. Final Revision -July 1, 1997 Page 13 3.2.3.3.2 Secondary Firewall The Secondary Firewall, to be installed in the Police Department, roo m 271, will consist of the following hardware. SECONDARY FIREWALL HARDWARE: Spire Systems understands and will adjust the existing Fiber in Closets 140 & 271 to adapt to the FDDI dual ring. 1 FR-B40WW-AC Prioris MX 6200 RAID System Note: to increase performance more memory was added 1 FR-PC77M-BK 32-MB (2x16 MB), 1 FR-CECBA-BA SCSI Wide Hard Disk Drive 1 FR-PCB5K-AA Prioris HX 6000 Server Country Kit 1 VRC 15-KA High-Resolution Color Monitor Note: DEFPA-DA was replaced with the DEFPA-DB 1 DEFPA-DB PCI V2.1 to FDDI DAS MMF Adapter 1 DEFPA-MB PCI TO FDDI UTP 4 BN3413-03 SC-SC Dual Fiber Optic **amended 6/17/97 HARDWARE COST: $9,084.00 INSTALLATION COST: (FM-DECSV-IN) $300•00 SECONDARY FIREWALL SOFTWARE: 1 LI-XUSSWD-UNLM SIDEWINDER UNLIMITED USER LICENSE SECONDARY FIREWALL SOFTWARE COST, $20,895.00 ** amended 6/5/97 SOFTWARE INSTALLATION: Note: Staff will observe Primary Firewall installation, and perform Secondary Firewall installation on their own. Spire Systems, Inc. Final Revision - July 1, 1997 Page 14 3.2.4 Web Services ** amended 5/30/97 - Note: The MIS staff will perform all Web Services l i Spire Systems,Inc. Final Revision -July 1, 1997 Page 15 3.2.4.1 Internet 3.2.4.1.1 Internet Web Server WEB SERVICES: The new centralized WEB server will be as follows: Hardware 1 FR-B40WW-AC Prioris MX 6200 RAID System Note: To increase performance memory was added 1 FR-PC77M-BK 32-MB (2x16 MB), 2 FR-PC77M-BL 64-MB (2x32 MB), 2 FR-CFCBA-CA 9-GB Hard Disk Drive 1 FR-PCXAT-AJ 4/8-GB Tape Drive 1 FR-PCB5K-AA Prioris HX 6000 Server 1 VRC15-KA High-Resolution Color Monitor ** amended 5-30-97 HARDWARE COST: $12,247.00 INSTALLATION COST: (FM-DECSV-IN) $300•00 Microsoft Web Server Software w NT V4.0 Note: Spire will use the copy of Windows , Internet Information Server, and Frontpage from Backoffice v2.0 (Both OA servers come with Windows NT). 053270 (CS) $486.00 BACKUP EXEC FOR WINDOWS NT V6.11 SINGLE SERVER EDITION PART NO: BENTSE-RU000-611 ** deleted 6/5/97 - Note: Netshield was redundant software. WEB SERVER SOFTWARE COST: $486.00 ** delete 05-16-97 Spire Systems, Inc. Final Revision -July 1, 1997 Page 16 3.2.4.2 Intranet 3.2.4.2.1 Intranet Public Safety Server The MS Backoffice software includes Intranet/Internet Services (IIS V2.0) which includes: MS index server, MS Front Page, RAS multilink channel aggregation, PPTP and MPR protocols. The package will have all you need to utilize WEB browser internally in the same format as the WEB pages. Additional Software tools to allow retrieval and presentation of the various City databases and information services may be necessary depending on the data itself. example: Microsoft Visual Studio 97. ** deleted 5/30/97 - Note: On-site service to provide intranet design and implementation. 3.2.4.2.2 Intranet City Hall server The MS BackOffice software includes Intranet/Internet Services (IIS 2.) which includes: MS index server, MS Front Page, RAS multilink channel aggregation, PPTP and MPR protocols. The package will have all you need to utilize Web browser internally in the same format as the WEB pages. Additional Software tools to allow retrieval and presentation of the various City databases and information services may be necessary depending on the data itself. example: Microsoft Visual Studio 97. Spire Systems, Inc. Final Revision - July 1, 1997 Page 17 3.2.5 Web Page Development Software Spire is proposing Web development based on Windows NT Advanced Server version 4.0 with native Web server capabilities, and Visual Studio Web development software. The cost for Visual Studio is listed below. 1 100126 (CS) VISUAL STUDIO ENTERPRISE V1997 CDROM FOR WINDOWS 95/NT ONLINE DOC., PART NO: 628-00007 2 000000 (CS) VISUAL STUDIO ENTERPRISE V1997, 1 LIC. WEB PAGE DEVELOPMENT SUBTOTAL: $3,850.00 Spire Systems, Inc. Final Revision - July 1, 1997 Page 18 3.2.6 ISP Recommendation Spire is proposing a high-speed connection to the Internet via GTE Internet Solutions. GTE is an ideal single source vendor for telecommunications and Internet connectivity for the City of San Bernardino, because of their experience, the breadth of their offerings, and their value-added services. The key benefits to working with GTE include: GTE uses the highest-capacity IP network in the world. The Internet backbone is fully-meshed, redundant, and power-protected, yielding 99.9% network availability. GTE gives you "one-hop" TCP/IP access to the Internet. Also supporting high- speed connections to over 100 other Internet networks worldwide, more than any other provider, meaning your data can reach its destination with minimum hops and maximum speed. GTE offers a full range of Internet connectivity services, from dial-up connections to multi megabit access. GTE offers customer service twenty-four hours a day, seven days a week. GTE Network Operations Center (NOC) operates twenty-four hours a day, seven days a week. GTE services are available in 543 cities and 13 countries outside the US, thanks to UUNET PIPEX, UUNET Canada, EUnet Germany, and many other international partnerships. GTE boasts a 98% annual customer retention rate. ** amended 6/17/97 SECTION 3 TOTAL $799,542.00 Spire Systems, Inc. Final Revision - July 1, 1997 Page 19 4. Wide Area Network (WAN) Upgrade 4.3 Telecommunications ** deleted 6/16/97 (verbiage) 4.4 Frame Relay Upgrade ** deleted 6/16/97 (verbiage) Spire Systems, Inc. Final Revision -July 1, 1997 Page 20 4.5 WAN Upgrade Project Components 4.5.1.3 Build FDDI Backbone Main Switch (located in city hall basement) 1 DEFGA-EA GIGAswitch/FDDI system pkg. 2 DEFGX-AA 17-00083-62 power cord for 1 DEFGB-DA GIGAswitch Power Supply 1 DEFGP-AA GIGAswitch system 5 DEFGL-BA 4 Port FDDI SAS Linecard for 12 DEFXU-BA Unshielded Twisted Pair 8 DEFGM-AA FDDI MultiMode (62.5/125uM) 3 DEFPA-MA PCI to FDDI DAS, UTP (TP-PMD) 1 BN24B-10 FDDI to FDDI cable assembly, 10 BN25H-03 CROSS-OVER CABLE (3 METERS) 5 BN34D-10 MIC-SC Dual Fiber Optic 1 4N-AEABF-AA Uninterruptible Power System BUILD FDDI BACKBONE FLOOR HUB SUBTOTAL ** amended 6/17/97 $ 59,163.00 HARDWARE COST: INSTALLATION COST: (FR-4STAR-AI) $11,200.00 Installation on site all active network components Note: This install price includes all network items in all locations, this is a custom price and this item will be referenced in other sections like this: *(included in 4.5.1.3) S Spire stems Inc. Final Revision - July 1, 1997 Page 21 P Y 4.5.1.3.1 Switch Connections 4.5.1.3.2 Ne,w Fiber Fiber Optic Technologies, Inc. (FOTI) Services: Extend fiber to 4th and 5th floor network closets. Extend 8 strands to 4th , and 8 strands to 5th from the 3rd floor. ** amended 6/10/97 Cabling: a) fiber $ 7,576.00 b) seismic bracing $ 2,885.40 c) pulls per spec. $108,921.00 d) additional 50 pulls $ 3,937.00 (Expansion - 50 single pulls) $123,320.00 COST: Spire Syste ins, Inc. Final Revision -July 1, 1997 Page 22 4.5.1.4 Switchover & Transition A project of this scope requires a DYNAMIC FLEXIBLE PLAN that will be changed, modified and adjusted as we go along. The KEY to Success here is the effective relationship between the Project Manager and the MIS director. Many items can be installed in Phase I that do not impact the day to day operations. Then finally in phase H co-ordination between the Entities will need to be addressed to cause the least interruption as possible, with the least impact to productivity . PHASE I a. Install active network components, (hubs, switches, brouters, etc), and connect to new wiring/cables according to the City's schedule and the suppliers schedule worked out between MIS director and project manager. b. Keep as much existing network infrastructure in place as possible. c. Involve interoperability testing on each installed building/floor/closet, etc. as required before any switch over. This will give us integrity checks along the way. This will need to be done end to end within same buildings per site. d. Upon completion of ALL new active components and interoperability checks meet with MIS manager and schedule a "DRY RUN" test of the least critical sub-networks first IE: make the OA servers talk to the end user desktop locations first. Not Public Safety first. e. Since some areas will not have parallel wire to the end user, (example: Police Department) we will meet and formulate a scheduled transition with the MIS director and the project manager, co-ordinating the Digital network installation person and the affected departments within the City. Network Transition 1. Public Safety will be done according to the Cities schedule. Security Aspects of Public safety require everything to be ready before we SWITCH-OVER. 2. Ongoing starting with City Hall(upon award). First Months PCs 45 per month will replace VT users. Remote locations to be scheduled with MIS &Project manager for delivery &Training. 3. Install Remote locations Active routers &stackable HUB components as close as possible to wiring schedule, (looking for the ability to test prior to switch over within a 1 week period. Frame relay as Departments will allow. Dependent upon access to T1 leased line installation could be 60 days after request, or AWARD. S Spire stems, Inc. Final Revision -July 1, 1997 Page 23 P y PHASE II This phase involves the scheduling of switch over by departments, buildings and remote locations, a schedule will be established with meetings between the individual departments and the MIS director and Project Manager. Installation of servers will be on-going as Fiber Optic Technologies is performing bldg. wire and cable runs for the "ROBUST INFRASTRUCTURE". This will allow us to test the servers in most locations upon completion of wiring. Servers transition WEB SERVER: 1. Site preparation performed on site by DEC. **(upon AWARD) 2. Scheduled installation of hardware and UPS. **(following pre-site) 3. Diagnostic checkout and software installation O/S. ** amended 05-16-97 Removed WEB page install. And on site service. FIREWALL 1: 1. Site preparation performed on site by DEC. **(upon AWARD) (City Hall)2. Scheduled installation of hardware and UPS. 3. Diagnostic checkout and software installation O/S. 4. Schedule Sidewinder Installation according to Availability of MIS Staff person, System Manager will be present with the on site Engineer from Secure Computing performing Install and Set-up with System Manager. Application OTT. 5. Test WEB Server Function. FIREWALL 2: 1. Site preparation performed on site by DEC. ** (upon award) (Public .Safety) (Public Safety scheduled installation of hardware and UPS. 3. Diagnostic checkout and software installation O/S. 4. Schedule Sidewinder software Installation according to availability of MIS Staff person, who will perform the installation of Secure Computing on this server. 5. Test Firewall Function. ** deleted 05-16-97 Spire Systems, Inc. Final Revision -July 1, 1997 Page 24 P Y GIS Transition 1. Site preparation from performed on site by DEC. **(upon AWARD) 2. Scheduled installation of hardware and UPS. **(following pre-site) 3. Diagnostic checkout and software installation NT O/S. 4. Schedule Application software Installation according to NT training for the users. (within same week if possible. 5. NT Installation performed by DEC with end user present if possible. (Scheduled according to end user requirements). 6. Test NT backup across network. ** deleted 5/30/97 Office Systems Transitions OA SERVER: 1. Site preparation performed on site by DEC. (City Hall) **(upon AWARD) 2. Scheduled installation of hardware and UPS. **(following pre-site) 3. Diagnostic checkout and software installation NT O/S. 4. Schedule software Installation according to Availability of MIS Staff person, (System Manager) will be present with the on site DEC Engineer performing Install and Set-up with System Manager. Application Familiarity OTT. 5. Schedule BACKOFFICE software Install with System Manager Present 6. Schedule Interoperability testing with end-user PC applications. 7. Schedule Switch over with MIS. NOTE: The bidder who is awarded this contract will have the opportunity to understand the needs of the city and working with the MIS director and her staff will be able to develop a detailed plan that you are looking for. The important point here is to know Spire Systems Understands the City's concerns around Disruption of critical services to the public. Spire if chosen will do everything possible to make the transition smooth and quick. Spire Systems, Inc. Final Revision -July 1, 1997 Page 25 4.5.1.5 Upgrade Network Closets 4.5.1.5.1 Intelligent Hubs 4.5.1.5.2 Basement Hubs 2 DMHUB-AA DEChub 900 MultiSwitch 4 H7894-MA DEChub 900 Power Supply 4 DETPJ-MA PORTSswitch 90OTP Repeater NOTE: DVNEF-MA not available, should be DVNEF-MM 1 DVNEF-MM VNswitch 900EF ** amended 6/5/97 ** deleted 6/17/97 2 BC 12G-06 V.35 adapter cable, 50-pin ** deleted 6/5/97 1 DEZ8R-RB RouteAbout Centr EW MP Routr 2 DSRVX-MA DECserver 900MC Remote Communications Server ** amended 6/5/97 2 4N-AEABF-AA Uninterruptible Power System Internet connection hardware (in City Hall Connected to basement hub) 1 DEWBR-NA DECbrouter 90T2, For DEChub 1 DETRX-SA Stackable Rear Cover 1 DETMI-SA DECrepeater 90TS Repeater 1 BC12G-06 V.35 adapter cable, 50-pin 1 469366 (l) PARADYNE CORP. DSU/CSU, CITY HALL BASEMENT HUB COST: $35,134.00 4.5.1.5.3 City hall 3rd Floor Hub 3RD FLOOR HUB 1 DMHUB-AA DEChub 900 MultiSwitch 2 H7894-MA DEChub 900 Power Supply 5 DETPJ-MA PORTSswitch 90OTP Repeater 1 DVNEF-MM VNswitch 900EF ** deleted 6/17/97 1 4N-AEABF-AA Uninterruptible Power System 4.5.1.5.3 3 RD FLOOR HUB COST: $19,477.00 INSTALLATION COST:$ *(INCLUDED IN 4.5.1.3) SOFTWARE INSTALLATION COST: (QT-4YFAB-I9) $380.00 Spire Systems, Inc. Final Revision -July 1, 1997 Page 26 4.5.1.5.4 4th Floor Hub 4TH FLOOR HUB 1 DMHUB-AA DEChub 900 MultiSwitch 2 H7894-MA DEChub 900 Power Supply 4 DETPJ-MA PORTSswitch 900TP Repeater NOTE: DVNEF-MA not available, should be DVNEF-MM 1 DVNEF-MM VNswitch 900EF ** deleted 6/17/97 1 4N-AEABF-AA Uninterruptible Power System 4.5.1.5.4. 4m FLOOR HUB COST: $17,520.00 INSTALLATION COST:$ *(INCLUDED IN 4.5.1.3) 4.5.1.5.5 5th Floor Hub 5TH FLOOR HUB 1 DMHUB-AA DEChub 900 MuhiSwitch C� 2 H7894-MA DEChub 900 Power Supply 4 DETPJ-MA PORTSswitch 900TP Repeater NOTE: DVNEF-MA not available,should be DVNEF-MX 1 DVNEF-MX VNswitch 900EF ** deleted 6/17/97 1 4N-AEABF-AA Uninterruptible Power System 4.5.1.5.5 5TH FLOOR HUB COST: $17,520.00 INSTALLATION COST:$ *(INCLUDED IN 4.5.1.3) S Spire stems, Inc. Final Revision -July 1, 1997 Page 27 P Y 4.5.1.6 CATS Wiring Requirements FIBER OPTIC TECHNOLOGIES (FOTI) SERVICES: ** amended 5-30-97 ** amended 6/10/97 Cabling: See in Section 4.5.1.3.2. COST: Included in 4.5.1.3.2. Includes all new cabling and installation for Basement, Third floor,Fourth floor,Fifth floor, and all items ref; in 4.5.1.6 paragraphs A thru F. ** deleted 05-30-97 Spire Systems, Inc. Final Revision-July 1, 1997 Page 28 4.5.2 The Public Safety Network Upgrade Ci 4.5.2.1 Existing Network 4.5.2.2 Install switches to support the CAD/RMS upgrade CAD/RMS (IN CLOSET 271) 2 DEF6X-MA 6-Port FDDI Concentrator 2 DEFXU-BA UNSHEILD TWISTED PAIR 10 DEFXM-AA FDDI MULTIMODE 2 DEF1H-AA SINGLE SLOT DECHUB FDDI 4 BN24D-10 FDDI TO 2.5MM BAYONET 2 BN24B-03 FDDI CABLE ASSEMBLY 12 BN24Q-01 UTP CROSSOVER CABLE 1M 5 BN24Q-07 UTP CROSSOVER CABLE 7M 7 DLMFE-AA MultiSwitch 300 8-Port 14 DLMFE-TX Expansion Card for the MultiSwitch 300 CAD/RMS (CLOSET 271) COST: $34,624.00 COST:$ *(INCLUDED IN 4.5.1.3) 4.5.2.3 Replace Existine ON-line Hubs POLICE DEPARTMENT ROOMS 140 & 271 2 DMHUB-AA DEChub 900 MultiSwitch 4 H7894-MA DEChub 900 Power Supply 6 DETPJ-MA PORTSswitch 90OTP Repeater 1 DVNEF-MM VNswitch 900EF 2 BC12G-06 V.35 adapter cable, 50-pin 1 DSRVW-GC DECserver 700 Comm Server 1 DEZ8R-RB RouteAbout Centr EW MP Routr 2 DSRVX-MA DECserver 900MC Remote Communications Server POLICE DEPARTMENT CLOSET 271 2 DMHUB-AA DEChub 900 MultiSwitch 4 H7894-MA DEChub 900 Power Supply 6 DETPJ-MA PORTSswitch 90OTP Repeater 1 DVNEF-MM VNswitch 900EF ** deleted 6/17/97 2 BN34A-10 ST- SC DUAL FIBER OPTIC CABLE POLICE DEPARTMENT ROOMS 140 & 271 COST: $59,635.00 INSTALLATION COST:$ *(INCLUDED IN 4.5.1.3) Spire Systems, Inc. Final Revision -July 1, 1997 Page 29 4.5.3 Remote Site Connections 4.5.3.1 Special Requirements Spire will schedule remote sites installation of upgrade equipment in the same week that the OA system upgrade is installed.The engineers are from different organizations in the services group. The training will coincide within 2 weeks prior to scheduled switch over,(operational shutdown) to new OA server and associated clients. 4.5.3.2 Eidstine Network A) Remote locations use stackable routers supporting Frame Relay. B) CAT 3isOK C) FOTI (Fiber Optic Technology includes the upgrade to cat 5 in the limited number of sites. Upon Award to Spire, we will evaluate the re-use of existing Racal 6426 DSU/CSU's. ** deleted 05-16-97 Spire Systems, Inc. Final Revision - July 1, 1997 Page 30 4.5.3.4 Sites Requiring Same Hardware Basic remote site connection 33 BN3713-02 CABLE 33 DEX1S-FA ROUTEABOUT ACCESS ES 7 DEX2R-TA RouteAbout Access EW IP 40 DETRX -SA STACKABLE REAR COVER 40 DETMI-SA DECrepeater 90TS Repeater 40 BC 12G-06 V.35 adapter cable, 50-pin 40 469366(I) Paradyne Corp. DSU/CSU BASIC REMOTE SITES(44) COST: $82,862.00 INSTALLATION COST:$ *(INCLUDED IN 4.5.1.3) SOFTWARE INSTALLATION: (RouteAbout-QT-4ClA9-19) $25,200.00 REMOTE LOCATIONS/INTER-OPERABILITY TESTING: $33,592.00 By Fiber Optic Technologies (FOTI) 4.5.3.5 Sites requiring Different hardware The hardware,installation,and cable requirements for the (8) different sites are listed below. Spire Systems, Inc. Final Revision-July 1, 1997 Page 31 4.5.3.5.1 The Fire Department Main Fire Station FIRE DEPARTMENT 1 DEX2R-TA RouteAbout Access EW IP 1 DETRX-SA STACKABLE REAR COVER 4 DETML-SA DECrepeater 90T-16 Repeater 1 BC12G-06 V.35 adapter cable, 50-pin 1 469366(I) Paradyne Corp. DSU/CSU $3,573.00 FIRE DEPARTMENT COST: INSTALLATION COST:$ *(INCLUDED IN 4.5.1.3) $600.00 SOFTWARE INSTALLATION: (RouteAbout-QT-4CIA9-19) 4.5.3.5.1.1 Install CAT5 Wiring The MAIN FIRE STATION Spire is proposing wiring and cabling services by Fiber Optic Technologies (FOTI). Included in 4.5.1.3.2. 4.5.3.5.2 The City Yards CITY YARDS 2 DEX2R-TA RouteAbout Access EW IP 2 DETRX-SA STACKABLE REAR COVER 2 BC12G-06 V.35 adapter cable, 50-pin 2 DETML-SA DECrepeater 90T-16 Repeater 2 DETMI-SA, DECrepeater 90TS Repeater 2 469366(I) Paradyne Corp. DSU/CSU CITY YARDS COST: $5,783.00 INSTALLATION COST:$ *(INCLUDED IN 4.5.1.3) SOFTWARE INSTALLATION: (RouteAbout-QT-4C1A9-I9) $1,200.00 4.5.3.5.3 The Parks and Recreation Main Office 1 DEX2R-TA RouteAbout Access EW IP 1 DETRX-SA STACKABLE REAR COVER 2 DETML-SA DECrepeater 90T-16 Repeater 1 BC12G-06 V.35 adapter cable, 50-pin 1 469366 (l) PARADYNE CORP. DSU/CSU, PART NO: 3165-A2-210 PARKS AND RECREATION HARDWARE COST: $2,794.00 INSTALLATION COST:$ *(INCLUDED IN 4.5.1.3) SOFTWARE INSTALLATION COST: (RouteAbout QT-4C1A9-I9) $600.00 Spire Systems, Inc. Final Revision - July 1, 1997 Page 32 4.5.3.5.4. Animal Control Facility 1 DEX2R-TA RouteAbout Access EW IP 1 DETRX-SA STACKABLE REAR COVER 1 DETML-SA DECrepeater 90T-16 Repeater 1 BC12G-06 V.35 adapter cable, 50-pin 1 469366(I) Paradyne Corp. DSU/CSU ANIMAL CONTROLCOST: $2,404.00 INSTALLATION COST:$ *(INCLUDED IN 4.5.1.3) SOFTWARE INSTALLATION: (RouteAbout-QT-4C1A9-I9) $600.00 4.5.3.5.5 Feldheym Library 1 DEX2R-TA RouteAbout Access EW IP 1 DETRX-SA STACKABLE REAR COVER 2 DETML-SA DECrepeater 90T-16 Repeater 1 BC 12G-06 V.35 adapter cable, 50-pin 1 DSRVH-NA DECserver 90M Comm Server 1 DETRX-SA Stackable Rear Cover 1 469366(I) Paradyne Corp. DSU/CSU FELDHEYM LIBRARY COST: $3,848.00 INSTALLATION COST:$ *(INCLUDED IN 4.5.1.3) SOFTWARE INSTALLATION: (QT-OLWA9-I9) $380.00 SOFTWARE INSTALLATION: (RouteAbout-QT-4C1A9-I9) $600.00 Includes all new cabling and installation for: Feldheym Library Included in 4.5.1.3.2. 4.5.3.5.6 All Branch Libraries 3 DEX2R-TA RouteAbout Access EW IP 3 DETRX-SA Stackable Rear Cover 3 BC 12G-06 V.35 adapter cable, 50-pin 3 DSRVH-NA DECserver 90M Comm Server 3 DETRX-SA Stackable Rear Cover 3 469366(I) Paradyne Corp. DSU/CSU BRANCH LIBRARIES COST: $9,206.00 INSTALLATION COST:$ *(INCLUDED IN 4.5.1.3) SOFTWARE INSTALLATION: (RouteAbout-QT-4C1A9-I9) $1,800.00 SOFTWARE INSTALLATION: (QT-OLWA9-I9) $ 1,140.00 %L Spire Systems, Inc. Final Revision - July 1, 1997 Page 33 4.5.4 Telecommunications Services Spire is proposing GTE as the single source vendor for telecommunications and Internet connectivity for the City of San Bernardino, because of their experience, the breadth of their offerings, and their value-added services. GTE is a major provider of telecommunications services worldwide. Spire recognizes that the City of San Bernardino may have broader considerations in selecting a telecommunications vendor, however, we make this our recommendation in the limited context of MIS/Internet services. 4.5.5 Network Management Stations 4.5.5.1 Network Management Station Hardware 2 FR-B 16AP-EG Celebris GL 6200 ST Personal Computer 4 FR-PCCAM-BC 64-MB EDO Memory Option for 2 FR-PCXAR-AZ Hard Disk Drive 2 FR-PCXAN-DA 100BaseT I/O Card 2 FR-PCXAV-WZ Color Monitor (21"(19.6"V) 2 4N-AEABF-AA Uninterruptible Power System 2 4N-AEAES-AA 4N-AEAES-AA Onlinet Software **amended 6/17/97 NETWORK MANAGEMENT STATION COST: $14,673.00 HARDWARE INSTALLATION COST: (FM-DECSV-IN (2)) $600.00 4.5.5.2 Network Mana ement Station Software ** deleted 05/30/97 (Polycenter for NT) ** deleted 05-16-97 2 QT-5FVAB-E8 clearVISION Network Manage- 2 QA-5FVAB-H8 Licensed Binaries and Documentation on Compact 2 QM-4YJAA-AA clearVISN Recovery Manager 2 QB-MQDAB-SA cVISN MC MG MUL LIC/CDRM 2 QB-4YFAB-SA cVISN VLAN MUL LICICDRM 2 QB-218AD-SA cVISN RMON MUL LIC/CDRM PKG 2 QB-4YHAA-SA cVISN ROUTE WIN LIC/CDRM 1 QA-OLWAC-HC Licensed Binaries and Documentation on 3.5 Inch ** amended 05-30-97 NETWORK MANAGEMENT SOFTWARE COST: $11,087.00 SOFTWARE INSTALLATION COST: $3,800.00 Spire Systems, Inc. Final Revision -July 1, 1997 Page 34 4.5.6 Dial-in Capability Spire is proposing Digital Equipment Corporation's NETrider solution because of the City's security requirements. NETrider provides levels of security, including Kerberos security, recognized as an industry leader in remote access controL Spire is bidding the Digital solution as a superior, less expensive solution to the Shiva equipment specified in the Parts List. Components and pricing are included in section 4.5.1.5.2. ** amended 6/16/97 Section 4 Total $5849315.00 ``` Spire Systems, Inc. Final Revision -July 1, 1997 Page 35 ti 0 ONO. r W C4 ti W Q N qe a*N CP co W J r V 00 r �+ � O w N fA z Z 44, to Q J p O O O S O a�O oo W) O Ue F- 00 co vz Z Z 0 � Vr as Z Z Z N o LO 0 co ♦' F= ao ao p in 0 J V 0) ccoo W) c ti. J N Vk V). w !41! Cl) J � z LL L � oW U. m H v W 7 ca I-- cc U y U L W u CO) N L v .0 4) O c m m � m x U- c z v O SIERRA `-- COMPUTER SYSTEMS 1NC Cane 4, 1997 Mike Arviso City of San Bemm> dino 300 North D Street San Bernardino,CA 92418 Dear Mike: in regards to your conversation with Larry Prmtt,I have put together the following estimate to upgrade from 16 to 32 concurrent users. I have also included an estimate for'PERMM'PDA TK per my conversation with Mark Yavornicky: Uppulc 16;;vmurrcnt users on the Unix platform S 4,000'00 Sales Tax(7.75%) S 310.40 Annual Premier Maintenance for 32 concurrent users S 6,300.00 Sales Tax on half of Annual Maintenance L_244.13 TOTAL. 510,854.13 Informix online nmtime upgade from 16 to 32 users 517,560.00 Maintenance Upgrade to 32 users S 2,100.00 Sales Tax(7.75%) 1"523.65 TOTAL 521,183.65 `PERMM'PDA IN : S 2,000.00 Sales Tax(7.75%) : $ 155.00 Annual Maintenance for PERM I S'FDA IM 5�8.14 Sales Tax on half of Annual Maintenance TOTAL, . S 2,373.14 This quote supersedes airy previous written or verbal estimates for product and installation services. The above estirate is valid for 90 days. Please call if you have any questions. S' 1 ' Ange Shipley Manic Assistant mAIi. oom 1731 w.WALNUT AYE.. YrSALIA.CA 93277 � �� LtiT1FR�(Ei T-1KtP"�J"Im-PQvflaadoae rRnyaz 209.627.199! ]FAX.2h=A9% ` Ins ecTrack Software Item Qty. Unit Price Extension PC Soft«are Site License 1 S6.000 56.000 1 Pen Computer License 1 FREE $0 2-4 Pen Computer Licenses 3 5750 $2,250 5-7 Pen Computer Licenses 3 S500 S1.500 8-13 Pen Computer Licenses 6 S400 $2.400 14-22 Pen Computer Licenses 9 $300 $2,700 Total for Licenses $14,850 So are Maintenance Item Unit Price Extension annual Soft vare 10°0 of Software Cost per Year $1,485.00 Maintenance Hardware Item Qtc. Unit Price Extension Fujitsu Stylistic 1000 with 22 S3.140 S69.080 340 NIB HDD. 8 Nlcgs R.-2L\1. Rechargeable batten. AC Power Supply. Stvlus. Windows 95 8 Meg R-k\l Upgrade to 16 22 5185 54,070 \legs Harsh En-6ronment Carrving 22 5155 53.410 Case External Floppy Disk Drive 1 5290 5290 Spare Batteries L 3 S210 5630 Total Hardware Cost $77,480 i 1nspecTrack Quotation For Gty of San Bernardino Page 1 of 2 M-Track Software Inc June 13, 1997 Warranty Item Qty'. Unit Price Extension 3 Year"No Fault"screen 22 $190 $4,180 warrant}'(covers 2 screen replacements per year per unit) Training Item Unit Price Extension On Site Training'Installation $650 per dav(10 day's max.) $6,500.00 Travel Expenses(:airfare, Hotel and per diem) $1,000.00 $1,000.00 Total 57,500.00 Cost Summary Table Software Licenses $14,850 Extended Maintenance $1,485 Contract Hardware Cost $77,480 3 Year Screen Warranty $4,180 Training $7.500 Total Purchase Price $105,495 Less$2,500 Discount $102,995 Terms: 20o 10 Net 30 Freight Paid by M-Track 100 o Down payment requested with purchase order Quote valid until September 9. 1997 InspecTrack Quotation For City of San Bernardino Page 2 of 2 M-Track Software Inc June 13, 1997 5. Computer Aided Dispatch (CAD)/Records Management System (RMS) Upgrade ** deleted 05-16-97 (Systems Provided by Software Applications Vendor) 5.2 Hardware Warranty Upgrade ** amended 6/16/97 Priority 24 hour service package for"Mapping system": (FP-10203-12) $5,918.00 Priority 24 hour service package for"Dispatching system":(FP-11202-12) $2,988.00 Software Layered Products Support TruCluster LPS service package for"Mapping system": (QT-05SAE-L9) $804.00 TruCluster LPS service package for"Dispatching system":(QT-05SAE-L9) $804.00 ** deleted 06-05-97 ** MOVED PRICING TO SECTION 7.0 PER THE CITY. SEE SECTION 7.0 FOR PRICING DETAILS FOR BOTH CAD PUBLIC SAFETY WORKSTATION,AND CAD TELEPHONE OPERATORS WORKSTATIONS LISTED BELOW. CAD Workstations- Dispatch Radio Console (Public Safety 20 units) 20 FR-B 16AP-DB Celebris GL 6200 ST Personal 20 FR-PCXAN-DA 100BaseT I/O Card 40 FR-PCXAV-WZ Color Monitor (21"(19.6"V) ** amended 6/5/97 CAD Workstations - Telephone Operator Console (Public Safety 10 units) 10 FR-B 15AC-DB Celebris GL 6180 ST Personal 10 FR-PCXAN-DA 100BaseT 1/0 Card 10 FR-PCXAV-YZ 17" monitor(16"V) NH,85khZ SECTION 5 TOTAL $109514.00 Sp ire Systems, Inc. Final Revision - July 1, 1997 Page 36 6. Geoeraphic Information System(GIS) Upgrade 6.2 NEW HARDWARE: Geoeraphic Information System (GIS)Upgrade HARDWARE GIS WORKSTATIONS - WINDOWS NT (3) units 3 PB47A-CA AlphaStation 255/233 Windows NT System 3 MSP01-BC Parity Memory o 128 MB 3 FR-PCXAV-WZ Color Monitor (21"(19.6"V) 3 LK47W-AA PS/2 NORTH AMERICAN, KEYBOARD 3 PBXRZ-NA RZ29B SCSI Disk Drive 4.3-GB capacity 3 BN31V-01 (17-03567-24) 1M Fast Wide cable 3 PBXGB-CA TGA2/16MB 3D 24 plane PCI graphics Accelerator 24 3 PBXRZ-HB 2.1GB SCSI Disk Drive A. GIS WORKSTATIONS COST: $29,917.00 B. INSTALLATION COST: (3) FM-WSDTP-IN $525.00 Software GIS Workstations C. BERNTW - 006885 TAPE BACKUP client lic. COST: $617.00 for the GIS workstation D. 3 QB-0QRAA-SB Windows NT Workstation V4.0 $579.00 E. INSTALL SOFTWARE COST: $565.00 F. INSTALL WIN NT4.0 COST: (3) QR-SMWNT-BD $540.00 G. WIN NT SETUP DHCP, DNS,WINS COST: (1) QR-SMWNT-BA $2,737.00 ** amended 5-30-97 H. WIN NT SETUP BASE (QR-SMWNT-BG) $2,700.00 DOMAIN ARCHITECTURE The new GIS systems will run NT 4.0 workstation software. They will not support "Local area Vax Cluster". Nor will the preferred hardware, Alphastation 255/300's, work with Windows NT cluster software. The smallest alpha SERVER that is supported is the model 1000 SERVER, no workstations are supported. Therefore do not expect the features and functionality you have today with LAVC, (Local Area VAX Cluster). Spire recommends that the existing LAVC remain intact until the new GIS Alpha stations are set up and running the Application software and all aspects of the domain naming Service, (DNS) is functional and tested before any switch over takes place. Spire Systems, Inc. Final Revision - July 1, 1997 Page 37 ADVANTAGE OF DNS: Administration of 11P addressing on the Internet and Intranet. DISADVANTAGES DNS: Manual, not dynamic. DHCP ADVANTAGE: DHCP allows for dynamic and scalable TCP/IP addressing capabilities, and ease of administration. No workstation configuration is necessary , and users do not need to know anything about the systems TCP/IP addressing. Spire Systems Proposal requires return of the old 3100 model 76 workstations 1 year after installation of the new NT alpha workstations. This will allow ample time to implement the best set up of the new NT domain server. 6.3 Data Transfer Unlike CLUSTER technology you have today, the access of data between the 3 new NT Workstations will be via peer to peer using TCP/IP protocols. The setup of the hard disk on each system will be shared directories\disks. The path will be defined, allowing shared access. The system manger has responsibilities to maintain the system architecture. Further discussion prior to consulting with the application software vendor is speculation at this point. Spire however does feel that a MECHANISM can be and will be achieved. ** deleted 05-16-97 • Spire's proposal also includes the installation of the hardware, the NT 4.0 software, and the tape backup software on site. The custom installation of DHCP, DNS, WINS. that will meet the City's need to make the GIS systems independent from the OA systems, yet still allowing data to be shared/accessed by each of the three system hosting Public safety data, Public Services data, GIS data, and Domain log files. ** amended 5-30-97 SECTION 6 TOTAL $38,180.00 Spire Systems, Inc. Final Revision -July 1, 1997 Page 38 7. Office Systems Upgrade 7.2 New Office Automation (OA) Hardware and Operating Systems 7.2.1 Install new Servers located as follows: 7.2.1.1 The Basement of City Hall for OA (Mission Critical) CITY HALL OFFICE AUTOMATION NT SERVER: DN-5IHAA-EA A1phaServer 4100 5/400 Drawer, Windows H9A10-ED AS4100/4000 RETMA CAB Standrd 19" width, RETMA ** amended 05-16-97 KZPAC-CA 3 Chan. RAID Controller BN31S-lE (3) SCSI Cable 1.5-meter length VRC 15-KA High-Resolution Color Monitor RZ29B-VW (9) SCSI Fixed Disk 4.3-GB capacity(9)=38.7 GIG MS 100-AB 32-MB Cache Memory for KZESC KZPSC-UB Battery Backup for KZPSC Cache Memory BN31K-OE SCSI Cable and Bulkhead Assembly DEFPA-MA PCI to FDDI DAS, UTP (TP-PMD) Adapter BN25H-03 SCSI CABLE H7291-AA AS4XXX 450 Watt Power Supply TZ88N-VA 20/40GB SCSI tape drive in StorageWorks SBB. BA35X-ME Active SCSI Terminator KZPAA-AA PCI to SCSI Host Bus Adapter narrow, single-ended BN21N-02 Cable, SCSI-2 2.0 M ( 6.5 ft) Adapter "A" cable. 50 BA36R-RA (3) Storageworks shelf/retma 7 device StorageWorks 4N-AEAAJ-CL 4N-AEAAJ-CL 6 KVA UPS System-208 Volts Input and 4N-AEAES-AA 4N-AEAES-AA Inlinet Software for Alpha Windows NT ** deleted 05/16/97 (FM-5B724-36, hardware warranty on AlphaServer 4xxx) CITY HALL O/A NT SERVER COST: $66,215.00 INSTALLATION COST: (INCLUDED IN 4.5.1.3) CITY HALL O/A SOFTWARE: 1 039040 (CS) BACKOFFICE V2.0 SERVER ONLY CDROM PART NO: 321-00015 Pa a 39 Spire Systems, Inc. Final Revision -July 1, 1997 1 031264 (CS) EXCHANGE V4.0 INTERNET CONNECTER PART NO: 312-774V400 1 128775 (CS) EXCHANGE CONNECTER V4.O CDROM PART NO: 312-674V400 1 047915 (CS) BACKUP EXEC FOR WINDOWS NT V6.11 ENTERPRISE EDITION PART NO: BENTEE-RU000-611 1 175396 (CS) BACKUP EXEC FOR WINDOWS NT EXCHANGE PART NO: BEAGEX-RU000-611 1 029491 (CS) BACKUP EXEC FOR WINDOWS NT V6.11 SLQ SERVER MOD PART NO: BEAGSQ-RU000-611 ** deleted 6/5/97 (Netshield) ** deleted 05-16-97 ** amended 6/5/97-97 CITY HALL SOFTWARE COST: $28,588.00 CITY HALL O/A IMPLEMENTATION ON-SITE REQUIREMENTS CITY HALL O/A IMPLEMENTATION COST: $25,500.00 1 QS-IOOA9-CH I.S. Operability Testing Spire Systems, Inc. Final Revision -July 1, 1997 Page 40 7.2.1.2 Police Department for OA (Mission Critical) POLICE DEPARTMENT OFFICE AUTOMATION NT SERVER DN-5IHAA-EA AlphaServer 4100 5/400 Drawer, Windows H9A10-ED AS4100/4000 RETMA CAB Standrd 19" width, RETMA ** amended 05-16-97 KZPAC-CA 3 Chan. RAID Controller BN31S-lE (3) SCSI Cable 1.5-meter length VRC 15-KA High-Resolution Color Monitor RZ29B-VW (9) SCSI Fixed Disk 4.3-GB capacity (9)=38.7 GIG MS 100-AB 32-MB Cache Memory for KZESC KZPSC-UB Battery Backup for KZPSC Cache Memory BN31K-OE SCSI Cable and Bulkhead Assembly DEFPA-DB PCI to FDDI DAS, UTP (TP-PMD) Adapter BN34B-03 SCSI Dual Fiber H7291-AA AS4XXX 450 Watt Power Supply TZ88N-VA 20/40GB SCSI tape drive in StorageWorks SBB. BA35X-ME Active SCSI Terminator KZPAA-AA PCI to SCSI Host Bus Adapter narrow, single-ended BN35X-ME SCSI TERMINATOR BN21N-02 Cable, SCSI-2 2.0 M ( 6.5 ft) Adapter "A" cable. 50 .,., BA36R-RA(3) Storageworks shelf/retma 7 device StorageWorks ** deleted 05/16/97 (FM-5B724-36, hardware warranty on AlphaServer 4xxx) POLICE DEPARTMENT O/A NT SERVER COST: $62,518.00 ** amended 6/5/97 INSTALLATION COST: (FM-5ICAB-IN) $3,000.00 POLICE DEPARTMENT O/A SOFTWARE 1 039040 (CS) BACKOFFICE V2.0 SERVER ONLY CDROM PART NO: 321-00015 1 031264 (CS) EXCHANGE V4.0 INTERNET CONNECTER PART NO: 312-774V400 Spire System , Inc. Final Revision - July 1, 1997 Page 41 1 128775 (CS) EXCHANGE CONNECTER V4.0 CDROM PART NO: 312-674V400 1053270 (CS) BACKUP EXEC FOR WINDOWS NT V6.11 SINGLE SERVER EDITION PART NO: BENTSE-RU000-611 1 175396 (CS) BACKUP EXEC FOR WINDOWS NT EXCHANGE PART NO: BEAGEX-RU000-611 1 029491 (CS) BACKUP EXEC FOR WINDOWS NT V6.11 SLQ SERVER MOD PART NO: BEAGSQ-RU000-611 ** deleted 6/5/97 (Netshield) ** deleted 05-16-97 ** amended 6/5/97 POLICE SOFTWARE COST: $28,155.00 POLICE O/A IMPLEMENTATION ON-SITE REQUIREMENTS ** deleted 6/5/97 1 QS-I0OA9-CH I.S. Operability Testing POLICE O/A IMPLEMENTATION COST: $22,750.00 Spire Systems, Inc. Final Revision -July 1 1997 Page 42 7.2.2 Integration of new and Existing Server Systems 7.2.3 Changes to Existing Systems SABLE: ** amended 6/5/97 (staff personal to do Domain Naming Service after first installation) IMGSRV: RE-INSTALL NT WITH NEW DOMAIN NAME COST $450.00 JBSRV: RE-INSTALL NT WITH NEW DOMAIN NAME COST BLISS: RE-INSTALL NT WITH NEW DOMAIN NAME COST IMGTXT: RE-INSTALL NT WITH NEW DOMAIN NAME COST OCRSRV: UPGRADE TO NT WITH NEW DOMAIN COST 7.3 Workstation (Client) Hardware and Software 7.3.1. New Office System Software ** deleted 6/5/97 (Win 95 &WNT 4.0 are included with PCs from Digital) ** deleted 05-16-97 ** amended 6/5/97 NEW OFFICE SYSTEM SOFTWARE COST: $0.00 7.3.1.1 Microsoft Office 97 1 161526 (CS) 37.50 OFFICE 97 RESOURCE KIT PART NO: 1-57231-329-3 ** amended 6/5/97 410 106709 (CS) 288.00 118,080.00 OFFICE 97 FOR WINDOWS 95 &WINDOWS NT STOFCA PART NO: 021-01607 1 068645 (CS) 461.25 OFFICE STD 97 CD W9 PART NO: 021-00691 ** amended 6/5/97 MICROSOFT OFFICE 97 COST: $118,579.00 Spire Systems, Inc. Final Revision -July 1, 1997 Page 43 7.3.1.2 Microsoft Office 97 Professional 25 103186 (CS) 346.75 8,668.75 OFFICE PRO 97 FOR WINDOWS 95, WINDOWS NT MVLP-C PART NO: 269-01139 1 077832 (CS) 554.00 OFFICE PRO 97 WITH BOOKSHELF WINDOWS 95 CD PART NO: 353-00005 1 118533 (CS) 15.00 OFFICE PRO 97 FOR WINDOWS DOC SET PART NO: 269-00600 MICROSOFT OFFICE 97 PROF. COST: $ 9,238.00 7.3.1.3 Microsoft Exchange ** amended 6/5/97 455 167393 (CS)41.50 18,882.50 EXCHANGE CLIENT 4.0 MVLP-C PART NO: 381-073V40VL 1 062781 (CS)50.25 50.25 WINDOWS NT WORKSTATION RESOURCE BOOK KIT V4.0 INCLUDES 1 BOOK& 1 CDROM PART NO: 1-57231-343-9 1 156000 (CS)92.75 92.75 WINDOWS NT SERVER RESOURCE KIT V4.0 PART NO: 1-57231-344-7 ** amended 6/5/97 455 167423 (CS)32.50 14,787.50 SYSTEMS MANAGEMENT CAL LICENSE 1.2 PART NO: 271-174V12VL Spire Systems, Inc. Final Revision - July 1, 1997 Page 44 ** amended 6/5/97 455 167510 (CS)2.25 1,023.75 SMS CLIENT ACC LIC MVLP MNT PART NO: 271-174-MNT 1 161003 (CS)75.50 75.50 OFFICE 97 ENGLISH DISK KIT ONLY 3DS PART NO: 021-00677 1 162440 (CS)15.00 15.00 OFFICE 97 FOR WINDOWS DISK KIT ONLY CDR PART NO: 021-00684 1 162439 (CS)85.50 85.50 OFFICE PRO 97 FOR WINDOWS DISK KIT PART NO: 269-00553 ** amended 6/5/97 SOFTWARE COST: $35,013.00 Qwe 7.3.1.4. Terminal Emulator 1 KEA 420 for Win95 and NT $241.00 each $241.00 w/Media&Doc P/N:795053(I) ** amended 6/5/97 (Quanity from 499 down to 199) 199 KEA 420 for Win95 and NT $120.00 each $23,880.00 License Only P/N:795043(I) NOTE: The City may move these KEA Licenses from one group of PC's to another as the TE requirement goes away from the group originally installed. 7.3.1.5 Web Browser Spire will provide MS Internet Explorer as a Web browser for each client PC. P 4 Spire Systems, Inc. Final Revision -July 1, 1997 age 5 7.3.1.6 Virus Detection and Removal Spire recommends InterScan NeatSuite software to protect the City of San Bernardino from viruses.The Macafee NetShield software listed in the City's part list will work and is less expensive, but does not have the features and benefits of InterScan NeatSuite for Windows NT. NOTE: The City can run InterScan NeatSuite on both the NT OA servers, and up to 500 client PCs. This is not intended to be served off the Digital UNIX servers. QTY PART NUMBER PRODUCT DLSCRIPTION PRICE 1 LI-WUSNST-50OU InterScan NeatSuite NT $16,000.00 (Select Program) The InterScan NeatSuite NT includes the following top rated applications. 1- InterScan VirusWall- Virus Protection for Internet and e-mail traffic. Scans e-mail, HTTP, and FTP traffic at the Internet Gateway. * Detects viruses before they enter the LAN. * Detects macro viruses. * Scans FTP, HTTP, and e-mail traffic in real time. * Automatically updates virus patterns. 2- Server Protect NT - Raises virus protection to a new level of protecting LAN, WAN, and Intranet servers from known and unknown viruses before they can reach the desktop. 3- ScanMail for Microsoft Exchange - Stops viruses spreading through Microsoft Exchange mail. * Scan and clean files attached to Microsoft Exchange e-mail. * Install and update at the mail server automatically. * Internet-based unknown virus protection system using the Trend Virus Hospital. 4- PC-cillin Network NT- Designed specifically to guard your system from today's new virus threats. It has the power to detect every possible virus source and the flexibility to give you continuous, automatic protection. Includes PC-cillin client for corporate and employee home use. Select license includes 800 telephone support and monthly virus pattern updates, software upgrade and Virus Hospital Support for 1 year from the date of purchase. Annual maintenance fee after first year- $3,523.50 Spire Systems, Inc. Final Revision - July 1, 1997 Page 46 7.3.2 Office Systems Software Acquisition Below is a list of Microsoft products available through the California State Software Contract. Pricing is based on the California State Software Contract and is subject to change. 1 2 039040 (CS) BACKOFFICE V2.0 SERVER ONLY CDROM PART NO: 321-00015 2 2 031264 (CS) EXCHANGE V4.0 INTERNET CONNECTER PART NO: 312-774V400 3 2 128775 (CS) EXCHANGE CONNECTER V4.O CDROM PART NO: 312-674V400 4 7 053270 (CS) BACKUP EXEC FOR WINDOWS NT V6.11 SINGLE SERVER EDITION PART NO: BENTEE-RU000-611 5 1 047915 (CS) BACKUP EXEC FOR WINDOWS NT V6.11 ENTERPRISE EDITION PART NO: BENTEE-RU000-611 6 2 175396 (CS) BACKUP EXEC FOR WINDOWS NT EXCHANGE PART NO: BEAGEX-RU000-611 7 2 029491 (CS) BACKUP EXEC FOR WINDOWS NT V6.11 SLQ SERVER MOD PART NO: BEAGSQ-RU000-611 Spire Systems, Inc. Final Revision - July 1, 1997 Page 47 8 3 006885 (CS) BACKUP EXEC FOR WINDOWS NT WORKSTATION EDITION PART NO: BERNTW 9 7 041666 (CS) NETSHIELD V2.5 WNT PART NO: NST00025-1TBN-250 10 1 161526 (CS) OFFICE 97 RESOURCE KIT PART NO: 1-57231-329-3 11 1 062781 (CS) WINDOWS NT WORKSTATION RESOURCE BOOK KIT V4.0 INCLUDES 1 BOOK& 1 CDROM PART NO: 1-57231-343-9 12 1 156000 (CS) WINDOWS NT SERVER RESOURCE KIT V4.0 PART NO: 1-57231-344-7 13 500 167393 (CS) EXCHANGE CLIENT 4.0 MVLP-C PART NO: 381-073V40VL 14 500 167517 (CS) EXCHANGE CLIENT MVLP MNT PART NO: 381-073-MNT 15 500 167423 (CS) SYSTEMS MANAGEMENT CAL LICENSE 1.2 PART NO: 271-174V12VL 16 500 167510 (CS) SMS CLIENT ACC LIC MVLP MNT PART NO: 271-174-MNT Spire Systems, Inc. Final Revision -July 1, 1997 Page 48 17 475 106709 (CS) OFFICE 97 FOR WINDOWS 95 &WINDOWS NT STOFCA PART NO: 021-01607 18 475 167445 (CS) OFFICE FOR WINDOWS MVLP MNT PART NO: 021-050-MNT 19 475 103186 (CS) OFFICE PRO 97 FOR WINDOWS 95, WINDOWS NT MVLP-C PART NO: 269-01139 20 475 167499 (CS) OFFICE PRO FOR WINDOWS WITH ACC, MVLP MNT PART NO: 269-050-MNT 21 1 068645 (CS) OFFICE STD 97 CD W9 PART NO: 021-00691 22 1 161003 (CS) OFFICE 97 ENGLISH DISK KIT ONLY 3DS PART NO: 021-00677 23 1 162440 (CS) OFFICE 97 FOR WINDOWS DISK KIT ONLY CDR PART NO: 021-00684 24 1 162439 (CS) OFFICE PRO 97 FOR WINDOWS DISK KIT PART NO: 269-00553 25 1 118533 (CS) OFFICE PRO 97 FOR WINDOWS DOC SET PART NO: 269-00600 Spire Systems, Inc. Final Revision-July 1, 1997 Page 49 -1' IlpiplpMlM - - WXYitpf 26 1 068645 (CS) OFFICE STANDARD 97 CD W9 PART NO: 021-00691 27 1 077832 (CS) OFFICE PRO 97 WITH BOOKSHELF WINDOWS 95 CD PART NO: 353-00005 28 500 167426 (CS) WINDOWS NT CAL 4.0 MVLP PART NO: 2272075V40VL 29 500 167492 (CS) WINDOWS NT CLIENT ACC MVLP MNT PART NO: 2272075-MNT 30 1 100126 (CS) VISUAL STUDIO ENTERPRISE V1997 CDROM FOR WINDOWS 95/NT ONLINE DOC. PART NO: 628-00007 Spire Systems, Inc. Final Revision -July 1, 1997 Page 50 7.3.3 Workstation (Client PC) Acquisition 7.3.3.2 Manufacturer Spire is proposing all Digital Equipment Corporation PCs. Digital is a "tier-one" manufacturer,with a reputation for exceptional quality and service. Having a single manufacturer simplifies support issues, both for the City and the organization providing contract maintenance. The systems Spire is proposing all include a three-year, on-site warranty. As technology continues to evolve, Spire's implementation Plan will allow the City to take advantage of both price decreases, and technology improvements. 7.3.3.3 Cost Basis Spire proposes to provide Digital PCs to the City of San Bernardino under a new Digital program intended to provide the best possible pricing for educational, state, and local government accounts. This program DOES NOT allow Spire to provide PCs to the City of San Bernardino on a Cost-plus basis, as requested. ** amended 05/30/95 The ESL (Education, State, and Local Government) program from Digital, offers PCs at a specially reduced price through selected resellers. This special price is deeply discounted from list price, and is not discountable to the reseller. Spire's cost and the City's price will be the same. Spire will get paid quarterly by Digital in the form of a rebate, ranging from 5% to 9%, depending on the product volume and mix. The ESL pricing is below Spire's raw cost, and obviously below the cost-plus 5% model Spire proposed for the City. Spire is willing to provide PCs to the City on a cost-plus basis, as the City has requested and Spire has proposed. However, the ESL program promises to be the most cost effective way for the City to acquire PCs for years to come. As originally proposed, Spire will continue to supply the City with monthly, published price lists with interim updates to capture major product and pricing announcements from Digital. Spire Systems, Inc. Final Revision - July 1, 1997 Page 51 ��..._. IiTiiY.iYdWiYY➢w1Yi.1.A 7.3.3.4 Range of PCs Spire proposes four configurations that meet and/or exceed the minimum requirements. 7.3.3.5 Minimum Workstation (Client PC) configuration ** amended 6/16/97 7 .3 .3.5. Minimum workstation (Client PC) configuration for "Regular User" 1 400 FR-DAA05-BC 2 400 FR-PCXCV-DW LINE 1 & 2 SPECIAL PRICE 1,408.16 563,264 .00 4 400 DE305-AA 64 . 56 25, 824 . 00 MINIMUM WORKSTATION TOTAL: 1,472.72 $589,088 .00 7.3 .3.6. "Power-User" Workstation 5 25 FR-Bl6AC-DB 2, 538 . 00 63 , 450 .00 6 25 FR-PCXAN-DA 82 .77 2 , 069 .25 7 25 FR-PCXAV-YZ 882 . 57 22, 064 .25 "Power-User" Workstation TOTAL 3,503 .34 $87,583.50 8 1 HARDWARE INSTALLATION 425 units $106,250 .00 NOTE: DOES NOT INCLUDE THE 20 CAD DISPATCH STATIONS OR THE 10 TELEPHONE OPERATOR WORKSTATIONS. MIS WILL INSTALL THESE AFTER THE SOFTWARE AND SVGA CARDS FOR THE DUAL MONITORS ETC. CAD DISPATCH WORKSTATIONS - WINDOWS NT WORKSTATION NOTE: PCI GRAPHICS ADAPTER SUPPLIED BY SOFTWARE VENDOR (DO NOT INCLUDE) 9 20 FR-BI6AP-DB 2, 538 . 00 50, 760 . 00 11 20 FR-PCXAN-DA 82 .77 1, 655 .40 12 40 FR-PCXAV-WZ 1, 494 . 00 59, 760 . 00 CAD DISPATCH WORKSTATION SUBTOTAL $112,175.40 CAD TELEPHONE OPERATOR WORKSTATION - WINDOWS 95 13 10 FR-Bl5AC-DB 2, 370 . 57 23 , 705 .70 14 10 FR-PCXAN-DA 82 .77 827 .70 15 10 FR-PCXAV-YZ 725 .00 7, 250 .00 CAD TELEPHONE OPERATOR WORKSTATION SUBTOTAL $31,783.40 PCs TOTAL $926,881.00 Spire Systems, Inc. Final Revision - July 1, 1997 Page 52 7.3.3.9 Options NOTE: Options ordered with PCs will also be priced at the current Digital ESL. 1 FR-PCXCR-AQ 12X SCSI CDROM GRAY FOR PRIORIS SERVERS $215.10 1 719106 (l) SPORTSTER 33.6 INT 14ASR $137.50 1 FR-PCXRN-AF 8X CDROM FROST WHITE $219.88 1 FR-PCXAT-AJ 4/8-GB Tape Drive $1,088.10 1 588214 (I) AMERICAN POWER CON. $337.82 1 FR-PCXRA-AN 2.1GB IDE Hard Disk Drive, $376.28 1 FR-PCXRA-AP 3.2 GIG IDE Hard Drive $551.08 1 FR-PCXAR-AY 2GB 7200 RPM SCSI HARD DISK $698.28 1 FR-PCXVR-AY 2.14GB FAST-SCSI 2, 3.5HH $827.10 1 FR-PCXAR-AZ Hard Disk Drive 4-GB capacity $1,070.10 1 FR-PCCAM-BA Two 8-MB EDO, 60-Nanosecond $183.08 1 FR-PCCAM-BB Two 16-MB EDO, 60-Nanosecond $302.68 1 FR-PC83M-BE Venturis Video memory, 1MB EDO $ 69.00 1 FR-PCCAM-CA 2-MB Window RAM Upgrade for $239.20 1 FR-PCXAV-YZ 17" monitor(16"V) NH,85khZ $926.10 1 FR-PCXAV-WZ Color Monitor (21"(19.6"V) $1,979.97 1 FR-PCXRJ-AD 3.5" 1.44MB DISKETTTE DISK $ 69.00 1 DE305-AA ETHERWORKS ISA PNP 10MB, TP, TW, AUI $ 71.00 1 FR-DE500-AA ETHERWORKS PCI 10/100 MB, TP, TW, AUI $ 137.08 1 470762 (l) WIN 95, LIC, 3.5" FD, MED $191.40 1 470704 (I) WIN 95, LIC $159.50 1 470761 (l) WIN 95 UPG. $ 93.45 PC UPGRADE TO EXISTING City desktop machines ESTIMATED as follows: a) Existing PC enhancements: $70,000.00 b) Options $ 5,000.00 c) printers $ 15,500.00 EXISTING PC UPGRADE TOTAL $ 90,500.00 7.3.310 On-site Warranty Service Requirement ** Addendum 6/16/97 (Requested on site maintenance for all networking items) NOTE: THESE ITEMS UPLIFT THE 90 DAY RTF WARRANTY TO 1 YR ONSITE WARRANTY SERVICE. NOTE: TO SAVE THE CITY MONEY ON THE NETWORK COMPONENTS UPGRADE, WE BUNDLED THE POLICE SERVER UPGRADE TO 24X7 DECSERVICE WITH THE NETWORK COMPONENTS. NETWORK HARDWARE WARRANTY UPLIFT COST: (FP-40218-12) $39,085.00 PARADYNE DSU/CSU WARRANTY UPLIFT COST: (FS-PRY03-EB) $5,376.00 Page Spire Systems, Inc Final Revision -July 1, 1997 ag 53 7.3.3.11 Batch deliveries of PCs Spire has developed a plan for staging PC deliveries to the City so that they can be used for training. PCs will be delivered at a rate of about 45 per month; in three weekly shipments of 15 units. The 15 PCs will be fully assembled with all necessary software loaded. The PCs will be set up and connected to the network in the training facility. Each PC will be identified by a sign with the name of its user, who is also the person enrolled for training. After training the PC will be moved to the associated user's desk and installed for use. This plan accomplishes several of the City's objectives: It provides for orderly, logical staging of the PCs, and it provides an ideal training scenario for each user, giving them access the exact environment in which they will be working. The same premise will apply to technical support and management staff. 7.3.4 PC Confieurations 7.3.4.1 City Hall PCs Spire will assist in disposing of or selling any surplus equipment that the City wishes to dispose of as the upgrade progresses, including VT terminals. As appropriate, Spire will attempt to return the equipment to the manufacturer for trade-in credit, or dispose of it through third-party brokers. Example: The (3) 3100 model 76 workstations will be returned for a credit of$500.00 ea. towards the new Alpha Workstations one for one. A) Any surplus equipment on the City's list will be checked against the current Digital Equipment Corp. "SBU AMERICAS SYSTEMS TRADE IN MENU." B)If the surplus item is not found on the current Digital SBU MENU, Spire will then use its existing sources to assist in the sale of equipment. Spire's Project Manager will provide assistance in the sale or disposal of older/used "SURPLUS" equipment. Spire Systems, Inc. Final Revision - July 1 1997 Page 54 7.3.4.2 Public Safety Network PCs Spire is proposing the standard Client PC configuration for local Public Safety Network PCs. These will have the same configuration as the City Hall PCs, using KEA420 for terminal emulation and access to ALL-IN-1. The local PCs will have the Microsoft applications locally staged and installed. ** amended 05-30-97 1 FR-DAA0I-AK Venturis FX-2 5166MMX ST 1 FR-PCXCV-DW Color Monitor 1 FR-PCCAM-EB 16 MB MEMORY 1 FR-PCXAG-AQ Matrox Millennium 1280x1024 1 DE305-AC Ethernet ISA Network Card 7.3.4.3 New Public Safety Remote Site PCs Spire is proposing the standard Client PC configuration or the Remote Public Safety Network PCs. The local PCs will have the Microsoft applications locally staged and installed. ** amended 05-30-97 1 FR-DAA0I-AK Venturis FX-2 5166MMX ST 1 FR-PCXCV-DW Color Monitor 1 FR-PCCAM-EB 16 MB MEMORY 1 FR-PCXAG-AQ Matrox Millennium 1280x1024 1 DE305-AC Ethernet ISA Network Card 7.3.5 Upgrade of Existing PCs 7.3.5.1 Software Software for the upgrade of existing PCs is available at the same price as for new PCs through the California State Contract. See section 7.3.2 of this document for pricing information. 7.4 Management Software 7.4.1 Microsoft Systems Management Server(SMS) Microsoft's Systems Management Server(SMS) is included as part of Microsoft BackOffice on the Office Automation Servers. 7.4.3 Enterprise Network Management Software Spire has proposed the following network management software and related items: 2 QT-5FVAB-E8 clearVISION Network Manage- ment Applications for Windows Spire Systems, Inc. Final Revision -July 1, 1997 Page 55 2 QA-5FVAB-H8 clearVISION Network Manage- ment Applications for Windows 2 QM-4YJAA-AA clearVISN Recovery Manager 2 QB-MQDAB-SA cVISN MC MG MUL LIC/CDRM 2 QB-4YFAB-SA cVISN VLAN MUL LIC/CDRM 2 QB-218AD-SA cVISN RMON MUL LIC/CDRM PKG 2 QB-4YHAA-SA cVISN ROUTE WIN LIC/CDRM 1 QA-OLWAC-HC DECsvr NA for DOS 7.4.4 Helpdesk Software See Section 8 (Training) DATA CONVERSION FOR 2,500 ALL-IN-1 DOCUMENTS OR MESSAGES: Options: 50,000 documents: $21,000.00 20,000 documents: $15,801.00 10,000 documents $10,868.00 5,000 documents $ 8,400.00 2,500 documents $ 7,399.00 Note: It is intended to deliver the Eagle Software All-in-1 conversion facility to the City for use to convert your documents and e-mail over the period of the project. The City will own the software. Also, the pricing includes Spire Technologies performing onsite, the conversion of enough documents to teach staff conversion procedures. Eagle Software is a technical, command-line driven solution. Any moderately advanced system manager with DCL experience will be able to master the conversion process. NOTE: Up to 20% of the total number of the documents converted may be datatables and/or spread sheets. For conversions with higher percentages, contact your sales representative. Section 7.0 Grand Total $1,5099369.00 Spire Systems, Inc. Final Revision - July 1, 1997 Page 56 S. Training Plan ** amended 6/10/97 Spire understands that training is essential to the success of the entire migration process. Users must be comfortable and productive as quickly as possible during the migration. To insure this, Spire proposes using a local Provider (COMPUSA), to provide the professional training services required. Spire Systems, Inc. Final Revision -July 1, 1997 Page 57 8.1 Propose Hourly Fee ** deleted 6/5/97 ** amended 6/16/97 (changed training) COMPUSA (San Bernardino) User training: 14,400 hrs (1800 Vouchers) $149,310.00 Tech training (star: $37,800.00 a) 5-12 students onsite (COMPUSA) Supporting Microsoft Windows NT b) 5-12 students onsite (COMPUSA) Administering Microsoft Windows NT c) 5-12 students onsite (COMPUSA) Supporting Microsoft SMS Servers d) 5-12 students onsite (COMPUSA) Core Technologies of Microsoft Exchange Server e) 5-12 students onsite (COMPUSA)Internetworking Microsoft TCP/IP on Microsoft WNT Typical class size is expected to be about 15 people. Training will be organized into several classes, including a general Windows 95 migration session for all users, and then specialized classes on Microsoft Office 97, Microsoft Excel, and other Microsoft products. Spire Systems, Inc. Final Revision -July 1, 1997 Page 58 8.2 Training Goals The basic goal of training is minimize any loss of productivity during the migration. To accomplish this,employees of the City of San Bernardino must have a clear understanding of the key features of Windows 95, Office 97, and Exchange when they complete their training. The courses proposed for technical personnel are based on our best understanding of the City's training requirements. 8.3.1.7 MI_S Staff Training for the MIS Technical Staff will be hands-on, using the actual system being installed. The same basic training plan of staging equipment specifically for training can be used for the MIS Technical Staff for all but the largest systems. Below is a description of the basic curriculum for all MIS Staff. Spire proposes the first on-site class to include all staff, and MIS Director and will be 3 days spent with a Digital Expert going over the following topics in an open relaxed environment prior to any of the formal staff technical training (see page 60). 1. Introduction: Meet with Clients computer system staff to present the objectives of this service, review requirements, define and develop a delivery schedule/plan for the duration of the service."WHAT'S IMPORTANT FOR THE CITY". 2. Windows NT Server Environment: Familiarize the client staff with the enhanced administration features built into NT server operating system. Discuss the differences between the workgroup model, which is a networking scheme in which both resources and administration are distributed throughout the network, and the Domain Model which is a networking scheme in which administration and security is centralized. 3. Windows NT Server Configuration: Configure Windows NT server software including determining system requirements' determining the role of the domain servers, planning the domains, and selecting a file systems. 4. Domain Management: Discuss and demonstrate the server manager utility and its functionality. The server manager is used to administer computers and domains in an NT environment. Discuss the Net Logon service, the user manager for domains, and the user profile editor. 5. Using Groups to Manage Users: Discuss and demonstrate how to differentiate between local and global groups and how to implement built in local groups depending on their functions, right,and abilities. Demonstrate how to create local and global groups and discuss the four special groups. Spire Systems, Inc. Final Revision - July 1, 1997 Page 59 6. Protecting Server Data: Discuss the multiple levels of software based fault strategies that windows NT Server offers, such as: Disk stripping, Disk Monitoring, Sector Sparing, RAID Systems, Tape Backup Utility. 7. User Orientations:Introduce new users to the Net Logon Service which allows them to log onto a Windows NT server domain and validates their user name and password. Introduce the windows user interface. Discuss how users connect and disconnect to their shared resources and how to customize their personal client environment using the User Profile Editor. 8. Print Setup: Discuss the setup of local and network printers. Demonstrate the use of the print manger icon in program manager for network printer configurations. Configure one printer and introduce commonly used queue commands. GENERAL MIS STAFF TRAINING: (QS-WNTAA-5Z) COST: $8,000.00 8.3.2 Specialized User Training Tonics 8.3.2.1 Internet/Intranet Authoring Specialized user training will be available for the various Web page authoring and management tools. Special training is also available for the Sidewinder software. ** amended 6/10/97 Note: The City intends to have their staff present during the installation of the Primary Firewall- No formal training is proposed for Sidewinder. Spire Systems, Inc. Final Revision - July 1, 1997 Page 60 8.3.3 User Training ** deleted 6/5/97 8.3.3.3.8 Data Conversion Training As part of the data conversion process, Spire will train selected City of San Bernardino MIS Technical Staff in the use of the data conversion tools and procedures used to move files from ALL- INA to Microsoft formats. 8.3.4 Pro am to Facilitate File Conversion As the developer of WordPerfect for OpenVMS and Lotus 1-2-3 for OpenVMS, Spire Technologies is uniquely qualified to provide the service of migrating from ALL-IN-1 file cabinets to conventional computer files. Spire is accustomed to dealing with ALL-IN-1 naming issues. Spire employs CABINET CONVERTER to help facilitate the file conversion process. This tool will remain available to the City of San Bernardino after the essential files have been migrated, so that City personnel can continue to migrate selected files on an as-needed basis. 8.3.5 Switchover of ALL-IN-1 Mail to Microsoft Exchange The same tools and experience Spire uses to convert other ALL-IN-1 files will be used to convert ALL-IN-1 Mail messages. The migration from ALL-IN-1 Mail to Microsoft Exchange will be eased by making saved messages accessible. 8.4 Helndesk ** amended 05-16-97 Spire has proposed Digital helpdesk services to help ease the transition. Over the long-term, it may be desirable for the City to develop its own help desk capability. ** amended 06-05-97 1 1 QR-SMUAI-ZG HD CHAN USER APPS QTY 75 2 1 QR-SMPRA-B2 HELPDESK LEVB LIST 2 EXTS/10 TOTAL HELPDESK COST: $6,126.00 8.5 Training for Heludesk Personnel Help desk personnel can be trained by COMPUSA for most Microsoft products. In some cases,it may be desirable to send help desk personnel to Microsoft or other manufacturers for highly Spire Systems, Inc. Final Revision - July 1, 1997 Page 61 specialized training. For example, Microsoft Office 97 training can be provided by COMPUSA, but the more esoteric functions of Microsoft Exchange may require direct training with Microsoft. 8.6 Support Sldlls to be Outsourced As discussed during the bidders conference, we know that the City intends to use Digital warranty uplifts to provide most hardware and software support. 8.6.1 Hardware Maintenance Cost Standard hardware warranty costs are included with the individual hardware items. Options for extending warranty coverage out to five years can be provided. 8.6.2 Software Maintenance Cost Software maintenance costs are provided as specified in the parts lists, as discussed at the bidder's conference. Where appropriate, options for extending warranty coverage out to five years are provided. ** amended 6/16/97 (COMPUSA) Section 8 Total $2019236.00 Spire Systems, Inc. Final Revision -July 1, 1997 Page 62 Appendix A City of San Bernardino Test & Acceptance Plan Spire Systems, Inc. and the various sub-contractors servicing the City of San Bernardino have implemented test and acceptance policies designed to assure the City that it has a fully working solution. As components are delivered and installed over the one-year period of performance, they will be individually tested and undergo a thirty-day acceptance period. The acceptance period for the entire solution is one year, plus thirty days. For maximum protection, each deliverable is redundantly checked in four phases, as described below. • Diagnostics These are the diagnostic procedures normally run by the manufacturer or supplier upon installation. This phase insures that all components are in working order upon installation. ,,,, • Infrastructure All deliverables will be tested with respect to connectivity within the infrastructure of the City of San Bernardino solution. This phase establishes that components can communicate with the other components with which they are directly connected. • Functionality/Interoperability All deliverables will be tested to be sure that they function as they are supposed to within the total City of San Bernardino. This phase establishes that components can operate with other components to which they relate, but to which they are not directly connected. This phase will be an on-going part of the project. • Acceptance Period All Components are subject to a 30-day acceptance period. Components are deemed to have been accepted after 30-days if they performed at 98% reliability or better, or if the City has not specifically rejected a components for failure to perform. Notwithstanding the acceptance period, all warranties periods shall fully apply. The Test and Acceptance and Plan is integrated with the Delivery Plan and the Payment Plan for the City of San Bernardino. For more detailed information on the installation and acceptance of any given component. Spire Systems, Inc. Final Revision -July 1, 1997 Page 63 o o � o abi ° c o °o c a) .0 C4 ►� (Y) O M c > i v a�oi CIO ° Cd C CO N cts o, 0 >, E 'v o •� >, ab' AL U 3 0 0 o cn 12 U'i o o � ti o ao M A .c .S > °" 0 ... S E cE � a IC pp p GC �. oc � o0 o A. O W o 3 a o CD rA b ^a A Q N co (Y)•-, C m — O +� a' u ?� O L M S a � � � c `i' O V O to O 00 M ..cyi �•r 0 U ° L � U cn a) w. a) N �t Q S w p (n Efl Q Efl ti -� 4� 3 (:d (U o c4 ° c O CL .�.+ + w n M w 0 2�o >, Q c°)' O > c� O , En C p a O C O S 1 ""' co o O cn _ O O a0 c7 > 5 cn `. p O C_ C U O.•C (4f) a) b O ` �t m i y C CJ b =3 p (13 r GL V) 0 \0 U a� C cn Q 6q O w �+ O cz o ..r o w .S o s 3 P- O rn c� o Q 75 Lo � � Q S V a� o Cz 3 ,� ;ate c o En En cz �' o c >, o m ° •— ° > Q a cn REQUEST FOR PROPOSAL APPLIES TO SPIRE Specification No. F97-18 FURNISHING AND DELIVERING OF NETWORK UPGRADE FOR THE CITY OF SAN BERNARDINO REQUEST FOR PROPOSALS Maximum participation by prospective offerors is highly encouraged. It is not the intent to rule out or eliminate any prospective bidder. If the equipment that you intend to bid does not comply with out specifications was written, attach a complete explanation with your proposal. The City may, at its discretion, consider any deviation and male the purchase that best suits our needs. The bidder shall not purposely bid a lesser quality that requires a deviation from the specifications if the bidder is able to comply with the minimum specifications. It is the intent of these specifications to provide for complete automation equipment which is ready to serve the needs of the Public. They are written with the view of obtaining the best result and the most acceptable equipment to the City. These specifications cover general requirements relative to the type of service required. Minor details of performance where otherwise not specified, are left to the discretion of the contractor, who shall be solely responsible for the performance of the equipment procured. GENERAL SPECIFICATIONS: 1. Each bid shall be in accordance with Specification No. F97-18. All specifications are minimum. Bidders are expected to meet or exceed these specifications as written. Bidder shall attach to bid proposal a complete detailed itemization and explanation for each and every deviation or variation from these specifications. Conditional bids, or those which take exception to the specifications, may be considered non-responsive and may be rejected. 2. The City reserves the right to accept or reject any and all bids and to award a contract to the bidder who best meets our requirements. This may include waiver of minor irregularities or discrepancies, or nonconformity to specifications in appropriate circumstances. Purchase shall be on a best buy basis after due consideration of all relevant factors, and suitability as well as conformity to city needs and requirements. In all cases the best interest of the City shall prevail in all contracts awards. 3. The City of San Bernardino reserves the right to purchase more or less than the quantities specified, at unit prices bid. 4. Bids shall be firm offers, subject to acceptance or rejection within 60 days of the opening thereof. 5. Regular dealer. No bidder shall be acceptable who is not a reputable provider of requested equipment as submitted for bid consideration. 6. Contractor shall defend any and all suits and assume all liability for any and all claims made against the City of San Bernardino, or any of its officials or agents for the use of any patented process, device or article forming a part of equipment used to provide contracted service or any item furnished under the contract. 7. Each bidder must state in his bid proposal the guaranteed delivery date in number of calendar days from the date of contract execution by the City of San Bernardino, time is of the essence relative to this contract. Successful bidder (contractor) shall prosecute the work continuously and diligently and shall deliver the bid items at the earliest possible date following the award of the contract. 8. Price shall be quoted F.O.B. San Bernardino (all transportation charges shall be fully prepaid), and shall include all discounts. Where applicable bid shall include California sales tax computed at the rate of 7.75% (this will normally be shown as a separate line item on the bid sheet). 9. The equipment which the bidder proposes to furnish to the City must comply in all respects with the appropriate safety regulations of all regulatory commissions of the Federal Government and the State of California, whether such safety features and/or items have been specifically outlined in these specifications or not. 10 Contract. Each bid will be submitted and received with the understanding that acceptance by the City of San Bernardino of proposal bid in response to this x solicitation shall constitute a contract between the successful bidder and the City. This shall bind the successful bidder to furnish and perform at the prices (bid) given and in complete accordance with all provisions of Specification No. F97-18. In most cases the basis of award will be the City's standard purchase order that may or may not incorporate this solicitation by reference. 11. Prohibited interest. No member, officer, or employee of the City or of any agency of City during his tenure or for one year thereafter shall have any interest, direct or indirect in this contract or the proceeds thereof. Furthermore, the parties hereto covenant and agree that to their knowledge no board member, officer, or employee of the City has any interest, whether contractual, noncontractual, financial or otherwise, in this transaction, or in the business of the contracting party other than the City, and that if any such interest comes to the knowledge of either party at any time , a full and complete disclosure of all such information will be made in writing to the other party or parties, even if such interest would not be considered a conflict of interest under Article 4 (commencing with Section 1090) or Article 4.6 (commencing with Section 1120) of Division 4 of Title I of the Government Code of the State of California. 12. One Document. These specifications, the request for proposal, the contractor's bid proposal, the written agreement executed by the parties, the purchase order and all documents referred to in the complete specifications and all modifications of said documents shall be construed together as one document. Anything called for in any one of said documents shall be deemed to be required equally as if called for in all. Anything necessary to complete the work properly shall be performed by the contractor, whether specifically set out in the contract or not All sections of the specifications shall be read and interpreted as constituting a whole and not as an aggregation of individual parts, and whatever is specified in one section shall be construed as applying to all sections. 13. The City of San Bernardino reserves the right to accept or reject any and all bids. 14. Prompt Payment. Each bidder may stipulate in the bid proposal a percentage prompt payment discount to be taken by the City in the event the City makes payment to the contractor within ten(10) working days of acceptance of service and approval of invoice. For the purpose of this provision, payment is deemed to be made on the date of mailing of the City check. 15. Inquiries. Direct all procurement inquiries to the purchasing manager at (909)384-5085. Technical questions may be sent via fax to (909)384-5368. The answers to material questions will be provided to all potential offerors. Telephone inquires regarding technical questions will not be accepted. 16. Bid forms. No bid will be acceptable unless it is made on the proposal forms furnished herein. Deliver all bids, signed and sealed to the Purchasing Division, Finance Department at 300 North "D" Street, 0 Floor, City Hall, San Bernardino, California 92418. CLEARLY MARK THE SPECIFICATION TITLE AND NUMBER(F97- 18 NETWORK UPGRADE) ON THE OUTSIDE OF THE ENVELOPE. Submit bids with an original and six copies. 17. Time. All bids must be received in the purchasing office by 3:OOPM on April 7, 1997 . Any bid may be withdrawn prior to the above schedule time for the receiving of bids. Any bid received after that time and date specified shall not be considered. 18. By submitting a bid to a public purchasing body, the bidder offers and agrees that if the bid is accepted, it will assign to the purchasing body all rights, title, and interest in and to all causes of action it may have under Section 4 of the Clayton Act (U.S.C. Sec. 15) or under the Cartwright Act (Chapter 2, commencing with Section 16700, of Part 2 of Division 7 of the Business and Professions Code), arising from purchases of goods, materials, or services by the bidder for sale to the purchasing body pursuant to the bid. Such assignment shall be made and become effective at the time the purchasing body tenders final payment to the bidder. 19 Bid Bond. No bid will be accepted unless it is made on a proposal forth furnished by the City. All bids or proposals shall be signed, sealed and accompanied by a cashier's check, certified check or bid bond made payable to the City of San Bernardino in the amount of at least five percent (05%) of the total bid. Such security shall be applied to or be remitted to the City of San Bernardino, as liquidated damages, should the bidder to whom the contract is awarded fail to enter into the contract All bonds furnished pursuant to this notice must be underwritten by a surety company licensed to do business in California and possessing a rating in Best's most recent insurance guide of'A' or better. *' 20. Source Selection. All bids will be evaluated against the criteria established in the technical specification. Cost will be a major but not the sole consideration. Scope of Work for Request for Proposal F97-18 Network Upgrade Plan forthe City of San Bernardino March 1997 Responses Due By 3:00 PM April 7, 1997 Table of Contents 0. TO WHOM IT MAY CONCERN 1 0.1. Pre-proposal conference............................................................................................ 1 0.2. Submittal of Proposal.................................................................................................. 1 0.3. Selection of Successful Bidder, Criteria and City Prerogatives............................... 1 0.4. Applicable Codes and Earthquake Protection .......................................................... 2 0.5. Format of Proposal and Conventions Used............................................................... 3 0.6. Terms of Payment.......................................................................................................3 0.6.1. Acceptance testing............................................................................................... 3 0.7. Required Completion Deadlines................................................................................. 3 I. OVERVIEW OF SCOPE OF WORK 4 1.1. The goals of this upgrade are: ........................................................... 4 1.2. The project is divided into five areas of activity: ......................................................4 1.2.1. Internet Connection..............................................................................................4 1.2.2. Wide Area Network Upgrade (WAN).................................................................... 5 1.2.3. Computer Aided Dispatch (CAD) / Records Management System (RMS) Upgrade.................................................... 5 1.2.4. Geographic Information System (GIS) Upgrade................................................... 5 1.2.5. Office Systems Upgrade OA ....................................... 5 1.3. Materials and Plans To Be Provided..........................................................................6 2. [NOT A PART] TCP/IP CONVERSION 7 2.1. Introduction 7 ............................................................................................................. 2.2. Machines Which Have TCP/IP licenses........................................................................7 2.3. TCP/IP for Computer to be Retired:................................................................•-" 7 2.4. The following systems do not require TCP/IP: ..............................................................7 3. INTERNET CONNECTION 8 3.1. Introduction ...........8 ...................................................................................................... 3.2. Internet Service Requirements...................................................................................8 3.2.1. Connection speed ................................................................................................ 8 3.2.2. [I] TCP/IP Addressing—DHCP, DNS, WINS........................................................ 8 3.2.3. Internet Security................................................................................................... 8 3.2.4. Web Services..................................................................................................... 11 3.2.5. Web Page Development Software..................................................................... 11 3.2.6. ISP Recommendation......................................................................................... 11 4. WIDE AREA NETWORK (WAN) UPGRADE 13 4.1. Existing WAN............................................................................................................. 13 4.2. Proposed WAN Diagram ........................................................................................... 13 4.3. Telecommunications Provider.................................................................................. 13 4.4. Frame Relay Upgrade................................................................................................ 13 4.5. WAN Upgrade Project Components......................................................................... 13 4.5.1. City Hall Upgrade............................................................................................... 13 4.5.2. The Public Safety Network Upgrade.................................................................. 19 4.5.3. [I] Remote Site Connections.:............................................................................20 4.5.4. [I] Telecommunications Services.......................................................................23 4.5.5. [q Network Management Stations...................................................................... 23 4.5.6. [IJ Dial-in Capability............................................................................................ 23 5. COMPUTER AIDED DISPATCH (CAD) / RECORDS MANAGEMENT SYSTEM (RMS) UPGRADE 24 5.1. Introduction ............................................................................................................... 24 5.2. Hardware.................................................................................................................... 24 5.3. Facilities..................................................................................................................... 24 5.3.1. Coordination of Relocation of CLETS Connection .............................................24 5.4. Networking 24 5.5. Security Considerations ........................................................................................... 25 6. GEOGRAPHIC INFORMATION SYSTEM (GIS) UPGRADE 26 6.1. Existing System......................................................................................................... 26 6.2. New Hardware............................................................................................................26 6.3. Data Transfer.............................................................................................................26 7. OFFICE SYSTEMS UPGRADE - 27 7.1. Existing Applications ....................................................... 28 7.2. New Office Automation (OA) System Hardware and Operating Systems.............. 28 7.2.1. Install 2 new Servers located as follows:............................................................ 29 7.2.2. Integration of New and Existing Server Systems................................................ 29 7.2.3. [I] Changes To Existing Systems.......................................................................29 7.3. Workstation (Client) Hardware and Software.......................................................... 30 7.3.1. [I] New Office System Software......................................................................... 30 7.3.2. [I] Office System Software Acquisition............................................................... 31 7.3.3. Workstation (Client PC) Acquisition.................................................................... 31 7.3.4. PC Configurations......................................................................... 7.3.5. Upgrades of existing PCs & Printers .................. 36 7.4. Management Software ................................................................................ 7.4.1. Microsoft Systems Management Server(SMS).................................................. 36 7.4.2. Metering/Reporting Software......................................................... 7.5. Remote Workstation Installation.............................................................................. 36 7.6. [a Data Conversion Software Aid.......................................... .................................. 37 38 8. TRAINING PLAN 8.1. Propose hourly fee.................................................................................................... 38 8.2. Training Goals........................................................................................................... 38 8.3. Staff Categories to be Trained.................................................................................. 39 8.3.1. [I] MIS Technical Staff Training Needs.............................................................. 39 8.3.2. Specialized User Training Topics .......................... 40 8.3.3. User Training ....................................................40 8.3.4. [I] Program to Facilitate File Conversion............................................................42 8.3.5. [I] Switchover of ALL-IN-1 Mail to Microsoft Exchange...................................... 42 8.4. [I] Background for MIS Staffing requirements 8.5. IU Helpdesk..................................................................................... .......................... 39 8.6. [I] Training for Helpdesk personnel................................................................ .........43 8.7. [I] Support Skills to be Outsourced.................................... .....................................40 8.7.1. [I] Hardware Maintenance (all) Cost..................................................................40 8.7.2. pJ Software maintenance Cost ......40 .................................................................... 0. TO WHOM IT MAY CONCERN The City of San Bernardino invites your firm to submit a Proposal and six copies in response to our Request for Proposal F97-18 entitled: "Network Upgrade for the City of San Bernardino.' Enclosed is a Request for Proposal (RFP) along with contract provisions. This is made available so you may be aware of the contemplated provisions of any resulting contract. If you take exception to these provisions, please elaborate in your proposal. 0.1. Pre-proposal Conference There will be a mandatory pre-proposal conference held on March 14, 1997 at 8:30 AM. The meeting will be held in the Management Information Center(MIC Room) located on the 6`" floor of the San Bernardino City Hall. City Hall is located at 300 North D Street, San Bernardino, California 92418. 0.2. Submittal of Proposal The Proposal is to be submitted in a sealed envelope with six copies and must be received before 3:OOPM on April 7,1997. A Five Percent(5%o) BID BOND must accompany your bid or it will be considered non-responsive. Each copy of the proposal must be identical. If the original is presented in binder format, so must all copies. 0.3. Selection of Successful Bidder, Criteria and City Prerogatives 1. A contract will be awarded to a single bidder, referred to as "Vendor' in this RFP, who will act as a Prime Contractor for the entire Scope of Work. 2. Bidder must bid on the entire package. Bids on parts of the Scope of Work, leaving other major parts un-addressed will be rejected. 3. Vendor must provide a dedicated project manager for the duration of the project. Bidder must indicate who this person will be and his/her qualifications. Proposed Project Manager will be interviewed as part of Vendor selection process. 4. The network design upon which this RFP is based was developed using the best information at the disposal of the City. 5. Bidder must verify that network design will work as intended; the City is not responsible for errors in the Parts List provided. 6. The Vendor is responsible for all aspects of the work and its successful completion. 7. The City is currently a Digital Equipment Corp. (DEC) equipment environment with regard to it's major systems. It has been pleased with DEC hardware, and Network Upgrade Plan - Section 10 Page 1 technical support staff are knowledgeable and comfortable with the DEC systems. Therefore, the City has reason for a preference for DEC systems. Notwithstanding the above, because of the rapid advance of technology and the complexity of the City's needs, the City will entertain alternative solutions for compelling reasons. Hence, although Digital components are referred to in this RFP, "or equivalent" is implied, throughout. 8. Regarding all other aspects of this RFP, Bidder may suggest alternative solutions for compelling reasons. 9. To convey the functionality of the desired network solution, a Parts List of Digital and other components is included and referenced within this RFP, which implements the network design described. In case of conflict between the Parts List and the body of this RFP, use professional judgment. 10.All Server and network backbone hardware shall be rack-mounted, except where inappropriate. 11.Although price is an important consideration in the selection of the successful bidder, such award will not necessarily be made to the bidder submitting the lowest priced proposal, but rather the bidder submitting the "best" proposal. In this case, best also includes the ability of Bidder to demonstrate that Bidder a) possesses an in-depth understanding of the issues important to the successful completion of this project, and an ability and desire to solve problems that will be encountered, b) can perform the work to accepted industry standards, and within an acceptable time frame, c) can provide a plan and schedule which assures a smooth transition from old to new systems, maximizing productivity of City operations and staff, d) can provide a creative PC delivery mechanism with flexibility and which maximizes the longevity of the proposed solution and the benefit to the City of evolving lower prices and higher performance. 12. City reserves the right to reject all bids, or to exclude or modify portions of the Scope of Work. If a portion of work is excluded or modified, contract fee will be adjusted appropriately, by mutual agreement. 13.City reserves the right to modify configurations of PCs, including software to be provided and quantities, with concomitant adjustment of prices. 14.With other qualifications being similar, the City will give preference to vendors or sub-contractors with a local presence, and that also use local staff. 0.4. Applicable Codes and Earthquake Protection All installations must meet applicable Fire and Building codes. EARTHQUAKE PROTECTION: All network and server equipment installed as part of the project covered by this RFP, shall be secured against tipping or sliding in the event of an earthquake. Network Upgrade Plan - Section >D Page 2 O.S. Format of Proposal and Conventions Used A) All software and hardware required is to be installed and configured as appropriate, and made functional according to its intended usage, even though the words "provide," "install," "will be performed," or other similar words are used in the text of this RFP. B) Bidders response shall follow the organization of this RFP. C) Bidder shall include pricing for each major logical technical division of the upgrade, as well as a grand total. A fully completed Project Cost Sheet (Appendix E) is a requirement for submission of a valid RFP response. Even though the cost of PCs will likely change in the future, and the number of PCs to be provided will vary from the quantities indicated, bidder must prepare a total cost based on current cost for the configuration proposed using the quantities provided in this RFP. D) The successful bidder is referred to as "Vendor.' E) [I] This symbol is used to highlight work items as well as other items that the Bidder must respond to; however, not all work items may be highlighted by this symbol, and other paragraphs may specify additional requirements. 0.6. Terms of Payment 0.6.9. Acceptance testing Acceptance testing and payment milestones will be established. 0.7. Required Completion Deadlines To be negotiated with Vendor. Network Upgrade Plan - Section p Page 3 1. OVERVIEW OF SCOPE OF WORK The Management Information Services Department of the City of San Bernardino (the City) is offering this Request For Proposal (RFP) to solicit bids from selected vendors to upgrade the computer network, computers and software in use by the City. The successful vendor will provide hardware, software, installation, and training services, resulting in a "turn-key' installation. 1.1. The goals of this upgrade are: 1) Install a robust network infrastructure to allow city departments access to all network resources they are authorized to use regardless of location within the City. The network will maximize the potential for accommodating future needs for bandwidth and performance. The major backbone elements of this upgrade will serve City Hall and the Police and Fire Departments (Public Safety). A re- wiring of City Hall is part of this upgrade. 2) Implement a Windows-based office automation system, including office applications and enterprise-wide electronic mail (e-mail). 3) Upgrade the Computer Aided Dispatch (CAD) and Records Management Systems (RMS) hardware. The software upgrade is not part of this RFP. 4) Upgrade GIS hardware. 5) Provide secure access to the Internet for improved communication and information gathering. 6) Establish two Intranet servers. One for City Hall and one for Public Safety. 7) Establish a Web server for the City. 8) Provide a smooth transition between usage of existing systems and the new systems to minimize loss of productivity by City staff during the transition, and maximize productivity after the transition. 9) Provide adequate training to maximize productivity during and after the transition. 1.2. The project is divided into five areas of activity: 9.2.1. Internet Connection A) Connection of the City network to the Internet must protect the sensitive nature of some data held by the City. This project will provide access for City employees to the Internet for e-mail, and the World Wide Web (WWW). B) Provide Internet"firewalls' to protect City resources from the outside world. C) Provide Web Server to host the City's Web site. Network Upgrade Plan - Section 1 Page 4 1.2.2. Network Upgrade (WAN and LAN) A) Currently the City provides dumb (VT) terminal-based services to its users. This project will install new network hardware and upgrade the telecommunications in use at all remote locations. B) The existing high speed network within City Hall will be extended, and new remote locations will be added. C) Complete re-wiring of City Hall will be performed. 1.2.3. Computer Aided Dispatch (CAD) / Records Management System (RMS) Upgrade Upgrade the hardware for the Computer Aided Dispatch (CAD) and Records Management Systems (RMS) in use by the Police and Fire Departments (Public Safety). The CAD/RMS software upgrade is being addressed in a separate contract, and will be performed by the Public Safety software vendor. This RFP only addresses the hardware aspects of the CAD/RMS Upgrade Project Note: The City may choose to purchase Public Safety hardware from its Public Safety software vendor. However, the CAD/RMS parts listing is provided so that vendors may submit their solution and cost for the City's consideration. City reserves the right to exclude this hardware from the contract with the vendor. If included in this project, the hardware vendor will be required to install a new network, server and workstation hardware at the Police Department. Vendor will be required to coordinate the hardware installation with the Public Safety software vendor through the MIS Department. 1.2.4. Geographic Information System (GIS) Upgrade Replace three VAXstation 3100s with three Digital AlphaStations running Microsoft Windows NT. Vendor, with information from the GIS software provider, will aid in data conversion. 1.2.5. Office Systems Upgrade (OA) Implement a Windows based office automation (OA) system, including office applications and enterprise-wide electronic mail (e-mail). Roughly 500 PCs will be acquired over an 8-12 month time frame. Installation, training and service are important components of the upgrade. Currently, the City operates a Digital ALL-IN-1 office automation system. This software allows access to WordPerfect for VMS and Lotus 1-2-3 for VMS for word processing and spreadsheet applications respectively. ALL-IN-1, itself, provides e- mail capability. This architecture will be replaced by a PC-based system and extended to other City departments in order to unify the City's computing environment and to substantially improve productivity. Network Upgrade Plan - Section 1 Page 5 1.3. Materials and Plans To Be Provided Vendor will: [I] assist in disposing of (selling) any surplus equipment that the City wishes to dispose of as the upgrade progresses. [I] provide a complete and well organized schedule of tasks to be completed within two (2)weeks of execution of a contract with the City [I] provide, for City's consideration, a schedule of maintenance costs for hardware and software through the fifth year after completion of the Wide Area Network (WAN) upgrade. This would be provided at a time near completion of the WAN Upgrade. (The PC installation is expected to continue for many months after the Upgrade is complete.) [I] provide an appropriate binder(s) containing all related paperwork, such as: warranties, schematics, as builts, and other pertinent documents resulting from the project. [I] provide all manuals that accompany installed equipment. r Network Upgrade Plan - Section 1 Page 6 2. [NOT APART] TCP/IP CONVERSION 2.1. Introduction MIS staff will convert all existing systems on the City's network to utilize TCP/IP. 2.2. Machines Which Have TCP/IP licenses MIS staff will install TCP/IP software on the following existing machines, which have TCP/IP licenses and are not replaced in this project: SYSTEM NAME OP. SYS. HARDWARE IP PKG. SABLE Digital UNIX Digital Alpha 2100 NAS 200 IMGSRV MS NT Digital Alpha 1000 MS TCP/IP JBSRV MS NT NEC Pentium MS TCP/IP BLISS MS NT Gateway PC MS TCP/IP IMGTXT MS NT NEC Pentium MS TCP/IP OCRSRV Win V3.11 NEC Pentium MS TCP/IP (OCRSRV will be moved to MS NT Operating System) �. 2.3. TCP/IP for Computer to be Retired: MIS staff will install TCP/IP software for the duration of the transition on the folloVnng machine, which will be taken out of service after the upgrade: SYSTEM NAME OP. SYS. HARDWARE IP PKG. OA VMS VAX 4100a UCX RMS VMS VAX 4300 UCX 2.4. The following systems do not require TCP/IP: The following systems are not expected to require TCP/IP licenses due to replacement within this project. However, careful scheduling will be required in order to avoid the need for TCP/IP on the public safety systems, CAD (Computer aided dispatching) and RMS (Records Management System). SYSTEM NAME OP. SYS. HARDWARE CAD VMS VAX 4300 GISPW VMS VAXstation 3100 G/SPD VMS VAXstation 3100 GISMIS VMS VAXstation 3100 Network Upgrade Plan - Section 2 Page 7 3. INTERNET CONNECTION 3.1. Introduction A) The City network will not be connected directly to the Internet; rather, the City will connect to an Internet Service Provider (ISP) who will in turn connect to upper levels of the Internet B) The City connection to the Internet will be secure. This security will be achieved through the use of 1iirewalls.' C) The intent of the City in connecting to the Internet is to allow access for City employees to the information stored on the Internet, and to provide electronic mail access between the City and other entities. D) The City will also provide information and services to the general public on its own Web Server, thus becoming an Internet information supplier. E) The City intends to develop an Intranet for internal information delivery. 3.2. Internet Service Requirements 3.2.1. Connection speed [1] Provide: access for the City to the Internet, initially via a Frame Relay connection at 128 kb/s, but with capability to increase speed to T1 level using only hardware capable of T1 to avoid future hardware upgrades. 3.2.2. [j] TCP/IP Addressing—DHCP, DNS, WINS Vendor must configure the TCP/IP network using the DHCP, DNS and WINS technologies to simplify computer address administration. Implementation of these technologies must be robust enough so that the failure of any one Server will not result in the failure of that technology. [1] Bidder must describe how these technologies will be used to achieve that end. Vendor must present an address plan for static addressed devices. A block of IP addresses are to be procured through a chosen ISP. 3.2.3. Internet Security 3.2.3.1. Requirements Overview The City has two distinct security requirements to be met: 1) To protect the City network against unauthorized access internally and from the Internet, and Network Upgrade Plan - Section 3 Page 8 2) To further protect the Public Safety network from the rest of the City network. Figure 1 depicts the City Internet Connection. 3.2.3.2. [1] CLETS Advisory Board Approval Required The Public Safety network is connected to the California Law Enforcement Telecommunications System (CLETS), and as such, any upgrade to the Public Safety network must be approved by the CLETS Advisory Board. City MIS and Police will coordinate the approval of the vendor's plan with the CLETS advisory board. The CLETS Advisory Board will not accept calls from vendors. Questions concerning security issues and the Public Safety network will be addressed directly as discussed in the GENERAL SPECIFICATIONS Item#15. The board will have review authority over the Public Safety portion of the proposed network. Vendors should be prepared to provide to the City, in their proposal, detailed information on firewalls proposed. It is expected that the main area of concern to the CLETS board will be the firewalls that protect and isolate the systems. Other large local law enforcement agencies have in use the Mergent Gauntlet firewall by Atlantic Computing. This product is mentioned here simply as an example product that has been approved for use by the Dept. of Justice. Special attention should be given to the security rating of proposed firewalls. Typically, the Dept. of Justice standards are comparable to those of the Federal Dept. of Defense as baseline standards for security ratings. 3.2.3.3. Firewalls Both the Primary and Secondary Firewalls must use the same hardware and software, except for network connection. 3.2.3.3.1. Primary Firewall [�] Provide: a Primary Firewall, which will be located in the Computer Room of City Hall. It will limit access to those services and entities that are authorized; e.g., e-mail and Web site access. This machine will effectively stop all incoming traffic from the Internet to the City, and will also be used to block outgoing traffic so that only authorized users can access the Internet. It is expected that the Primary Firewall will be a Proxy address server. [I] Bidder will describe how the Proxy address Server will function. See Parts List: [Networked Computer Systems : Internet Firewalls] Installation, warranties and technical support are required. 3.2.3.3.2. Secondary Firewall [�] Provide: a Secondary Firewall to be installed in the Police Department, m between the Public Safety network and the main City network, in Room 271. The Network Upgrade Plan - Section 3 Page 9 Tiered 3 _ Internet Firewall Model Intemet Primary Net Visible Server Firewall WWW, etc. I City Network Secondary (City Hall OA, Sable, Firewall Intranet, etc.) Public Safety Network CAD/RMS PS-OA Figure 1 Connection to the Internet Secondary Firewall must use two dual-attached FDDI connections. Vendor will reconfigure fiber in Room 271, as necessary. This will block most traffic from the City network. Typical traffic allowed will include network administration, e-mail and Internet Web pages. When combined with the significant physical and operating system security that will be employed by the Public Safety network, a very secure environment for Public Safety shall result. See Parts List [Networked Computer Systems : Intemet Firewalls] Network Upgrade Plan - Section 3 Page 10 3.2.4. Web Services 3.2.4.1. Intemet The City currently maintains several public web sites. The existing web sites will be transferred by MIS staff to the new Web Server. Maintenance of the Server hosting the Web site will be performed by MIS staff; however, content will generally be maintained by the departments providing the information. This new Web Server will be used by all City departments to provide information to the public. 3.2.4.1.9. Internet Web Server [�] Provide a centralized Web Server, hardware and software, for public use, to be installed outside the primary firewall in City Hall. See Parts List [Networked Computer Systems : Intemet Server] 3.2.4.2. Intranet This is a Server which provides information distribution services internal to the City. This allows users to utilize their Web browser to obtain internal information in the same format as Web pages. 3.2.4.2.1. Intranet Public Safety Server The Public Safety OA Server will serve as the Intranet Server for Public Safety staff. [I] Provide: Intranet Server Software, and Tools which permit retrieval and presentation of data from the various Public Safety databases and other information sources. 3.2.4.2.2. Intranet City Hall Server The City Hall OA Server will serve as the Intranet Server for non-Public Safety users. ['] Provide: Intranet Server Software, and Tools which permit retrieval and presentation of data from the various City databases and other information sources. 3.2.5. Web Page Development Software [I� Provide: web page authoring and site maintenance tools. 3.2.6. ISP Recommendation [l] Vendor will be responsible for recommending the best local ISP. Network Upgrade Plan - Section 3 Page 11 The connection must support T1 speed. Selected ISP will be proven reliable, cost- effective, and be able to provide required service levels. Assigned IP address range of approximately 2000 addresses must be portable. Block of addresses will be needed early in the project. Bidder must indicate how ISP provider will be selected. Network Upgrade Plan - Section 3 Page 12 4. WIDE AREA NETWORK (WAN) UPGRADE This project will upgrade the network infrastructure which all systems and servers use to connect to one another. 4.1. Existing WAN The City currently has approximately 20 locations connecting to its Wide Area Network (WAN). The backbone of the existing WAN is a dual attached station FDDI ring that connects a Chipcom Galactica hub in the basement of City Hall with an FDDI router in the Police Department. The remaining sites (approximately 17) connect to the WAN via dedicated phone lines that terminate in the basement of City Hall. Also, the Economic Development Agency has fiber to City Hall. It is managed and funded separately, and is not a part of this project with the exception of connection with City Hall for the City's cable TV operation which is moving into the EDA building. 4.2. Proposed WAN Diagram See separate diagram of proposed WAN, entitled: "City of San Bernardino, Proposed Wide Area Network,'which is in Appendix C. 4.3. Telecommunications Provider [1] The City currently uses GTE for telecommunications services. The City will consider alternative providers. Proposal must indicate which telecommunications vendor will be recommended, and the costs associated with the services required must be included in the proposal. 4.4. Frame Relay Upgrade A major facet of this upgrade will be the extensive use of Frame Relay technology to connect sites.. Sites already connected to the City WAN will not require new data circuits with the exception of approximately 8 - 9.6k analog lines currently installed. [p Install New Data Circuits at approximately 29 remote locations and upgrade remaining sites as necessary. 4.5. WAN Upgrade Project Components 4.5.1. City Hall Upgrade 4.5.1.1. Existing Network Most VT terminals, PCs and printers within City Hall located in the basement and 1"floor are served from the basement. The remaining such devices, and those on all other floors are served out of the and floor network closet. This Network Upgrade Plan - Section 4 Page 13 closet is very full, so that installation of more equipment and wiring needs to be carefully planned. 4.5.1.2. Overview of Upgrades to be Performed in City Hall: A) Build a switched FDDI network backbone. [Fiber must also be extended to the 4'h and 5`h floor network closets from the 3`4 floor closet. See 4.5.1.3.2 New Fiber] B) Upgrade communications closets with necessary hardware to connect the network backbone to the new wire plant. See C below. C) Install new CATS wire plant throughout City Hall. Existing CAT3 wiring will remain in place. Wiring will terminate in various network closets, as described, below. 4.5.1.3. [p Build FDDI Backbone Provide a Digital GIGAswitch1FDDI [called Switch] to be installed in the Cable room, in the City Hall basement, and all necessary hardware to support the WAN, as shown on the Parts List [WAN : Main Switch] The City Hall network will be a switched FDDI network, based on the Digital GIGAswitch, which allows multiple FDDI and Fast Ethernet segments to connect to each other and to be switched across a high bandwidth backplane. This switch will connect network servers with full-duplex, dual-homed connections. Intelligent switching hubs will be connected back to the FDDI switch with full-duplex FDDI-Single Attached Station (SAS) connections. The Switch has the following characteristics: Crossbar technology Capable of full-duplex transmission Non-head of line blocking ARP suppression Firmware upgradable to IP packet switching Fault tolerant power Support multiple physical interfaces (e.g., Single- and multi-mode fiber, UTP, T3) Support Multiple Spanning Trees SNMP manageable Hot swappable line cards The Switch creates virtual LANs between FDDI segments, Fast Ethernet segments, and will support future ATM upgrades. Data links can be attached to either an FDDI ring, a single FDDI endstation, a single ATM endstation, an ATM switch, an FDDI bridge, or another Switch. As demands for additional bandwidth increase to support video and other technologies this Switch will accommodate that growth. Network Upgrade Plan - Section 4 Page 14 4.5.1.3.1. Switch Connections A) The Switch will provide FDDI-Single Attached Station (SAS) connections to the Hubs located in the City Hall basement and in Network Closets on the 3`d, 4th and 5'" floors. B) The Switch will provide FDDI-Dual Attached Station (DAS) to the Secondary Firewall located in the PD. C) The Switch will provide Dual-home FDDI TP-UTP (Unshielded Twisted Pair) connections to: four network servers located in the City Hall basement. New CATS wiring is required to connect the servers. 4.5.1.3.2. New Fiber [I] Twenty four strands of fiber currently terminate in the 3rd floor closet Extend fiber to the 4th and 5th floor Network Closets by extending 8 strands to the 4"' floor and 8 strands to the 5d'floor, from the 3rd floor. 4.5.1.4. [1] Switchover & Transition—Disruption of Operations A) Switchover from the Galactica to the GIGAswitch can only be performed during a prescribed time and for a duration satisfactory to City operations, and must be coordinated through the Director of MIS. B) Only a minimum disruption time to existing operations will be permitted, amounting to not more than several minutes. The public safety environment is a dynamic environment in which non-planned emergencies may delay planned downtime for switchover outages. Vendor will expect and fully cooperate with MIS and the Public Safety departments to plan for and adjust to the special requirements of the Public Safety environment. C) A detailed plan must be presented by the Vendor describing the precise steps that will be taken to perform the switchover, at what point in the upgrade the switchover will occur, and further detailing of steps to be taken to reverse the switchover in case of trouble. Bidder must outline a plan which shows that Bidder understands the issues involved. D) An additional transition between the existing system and the upgraded system must be carefully planned for the Police Department, since there will not be parallel cabling to the user locations. Continuous operation of the CAD/RMS system must be preserved; hence, only momentary network interruptions will be tolerated, and those must be coordi- nated through the Director of MIS. Transition of CAD/RMS software operations is not part of this RFP, as it will be handled by the Public Safety software vendor. However, Vendor must coordinate equipment installation with the Public Safety software vendor through the Director of MIS. These transition solutions must be a part of Bidder's proposal. Network Upgrade Plan - Section 4 Page 15 Upgrade Network Closets 4.5.1.5.1. Intelligent Hubs Intelligent switching hubs will be placed in the communications closet of the basement, 3`d, 4d' and 5'h floors. [Similar equipment for the Public Safety network is described in 4.5.2 The Public Safety Network Upgrade.] These hubs will have fault tolerant power supplies and multi LAN technology (e.g., Ethernet, Fast Ethernet, FDDI, ATM etc.). These hubs will connect back to the main Switch with a full-duplex FDDI- SAS connection. Port switching 1013ase-T repeaters will connect users. User ports will connect to one of six Ethernet LAN segments within the switching hub. These segments will be then switched together in the FDDI- to-Ethernet switch. Six remaining full-duplex Ethernet ports can be used for power user external connections. Additionally, a Fast Ethernet/Ethernet switch will supply two ports of Fast Ethernet and twelve ports of Ethernet (all full-duplex). 4.5.1.5.2. Basement Hub Serves Basement, 1s'floor, and mezzanine. A) Provide: a Digital DEChub g00 Multiswitch and associated hardware; see Parts List [WAN : Network Distribution Hubs : City Hall Basement] B) Support 128 - 10baseT Ethernet connections using RJ45 jacks. C) Connect via SAS FDDI to the GIGAswitch in basement. 4.5.1.5.3. a Floor Hub Serves 2"d floor and 3'd floor. A) Provide: one DEChub g00 Multiswitch and associated hardware, see Parts List [WAN : Network Distribution Hubs : City Hall Td Floor] B) Support 160- 10baseT Ethernet connections using RJ45 jacks. C) Connect via SAS FDDI to the GIGAswitch in the basement 4.5.1.5.4. 40' Floor Hub Serves only the 0 floor. A) Provide: one DEChub g00 Multiswitch and associated hardware; see Parts List [WAN : Network Distribution Hubs : City Hall 0 Floor]. B) Support 128 - 10baseT Ethernet connections using RJ45 jacks. C) Connect via SAS FDDI to the GIGAswitch in the basement Network Upgrade Plan - Section 4 Page 16 4.5.1.5.5. a Floor Hub Serves 5`" and 6th floors. Note : The Water Department, located on the 5' floor, is independently funded and managed, and is NOT A PART of the Scope of Work of this RFP.] A) Provide: one DEChub g00 Multiswitch and associated hardware; see Parts List [WAN : Network Distribution Hubs : City Hall 5t' Floor]. B) Support 128- 10baseT Ethernet connections using RJ45 jacks. C) Connect via SAS FDDI to the GIGAswitch in the basement. 4.5.1.6. CATS Wiring Requirements The wiring that currently terminates in the 3nd floor closet is CAT3. This will continue to support the VT terminals in City Hall throughout the transition to PCs. [I] Provide: complete CATS wiring installation, including patch panels, wall plate mounted RJ45 jacks, and in-the-wall wiring for all required locations, as shown on the floor plans in the appendix, conforming to the following requirements. A) New CATS wiring will be installed from the newly upgraded Network Closets to specified user locations within City Hall. Two connections shall be made to each user, with two RJ45 jacks mounted on a single wall plate (dual mount, for two connections for each user), with a color contrasting with the existing jacks, so the new 10baseT jacks can be easily distinguished from the CAT3 jacks. Cable pulls will be approximate twice the number of ports listed on each floor of City Hall. B) CAT5 wiring shall be of a color contrasting with the existing CAT3 cables, so they can be easily distinguished. C) All components, such as patch panels, wall plates, connectors, punch down blocks, etc., used for CAT5 wiring must be CAT5 certified. D) Each CAT5 cable pull and termination may be tested to meet CATS specifications. The vendor must provide a plan that will show how at least 20 percent of the cable pulls and terminations will be tested under the review of the City. If more then 10 percent of the tested lines fail, the City reserves the right to require the vendor to test all cable pulls and terminations under the review of the City. E) All jacks at user locations will be numbered with a logical system, and correspond to the numbering of the patch panels and their jacks. F) A map in AutoCAD .DWG format shall be provided showing locations and numbers of all panels and jacks on City Hall floor plans. The following table shows how floors will be served after this upgrade: Network Upgrade Plan - Section 4 Page 17 rims; 4.5.1.6.1.1. Table - City Hall Ethemet Cable Configuration Closet Location No of Jacks Floors supported basement 128 basement, 1 , and mezzanine 3rd 160 2`d 3`d 4t' 128 4"' 5t' 128 5th 6t' 1 Network Upgrade Plan - Section 4 Page 18 IMAM 4.5.2. The Public Safety Network Upgrade The Public Safety upgrade will be performed in conjunction with the CAD/RMS software upgrade project and the OA upgrade project. it is expected the Public Safety software vendor will be ready to begin this project early in the overall upgrade project. Vendor must coordinate scheduling of upgrade components that impact the CAD/RMS upgrade so as to allow the Public Safety software upgrade project to get underway in a timely manner. City Hall Police Department B p 4 A 2 basement 0 1 2 7 A 2 4 B 1 0 9 All Dual strands First Floor Second Floor Figure 2 City Hall to Police Department Current Configuration City Hall Police Department Fkewd B 0 A 2 h 711 basement 0 1 0. y 7 A 2 4 1 B 1 0 9 •----+ First Floor ' Second Floor All Dual Strands Figure 3 City Hall to Police Department Proposed Configuration 4.5.2.1. Existing Network A) The Police Department (PD) is connected to City Hall via a Dual Attached Station (DAS)-FDDI ring. B) Fiber media traverses 4 rooms within the PD; however, only room 271 is actually connected to the FDDI ring. There is an Ethernet connection via fiber media from room 271 to room 140, to connect the 1a floor. Both rooms house one 17- slot 3Com ONline concentrator, these in turn support terminal server cards for the installed VT terminals and 10baseT ports for existing PC's. C) The wire plant in the Police Department is of type CATS and does not need any upgrade. Network Upgrade Plan - Section 4 Page 19 The Public Safety (PS) upgrade comprises two parts: 4.5.2.2. [1] Install switches to support the CAD/RMS upgrade. Provide: 48 ports of switched Fast Ethernet prior to CAD Servers installation; see Parts List [WAN : Network Distribution Hubs : CAD (in Closet 271)] For description, see 4.4.1.5.1. The two CAD Servers will be configured on dedicated, switched Fast Ethernet segments (100-Base-T) located in room 271. 4.5.2.3. [1] Replace Existing ONline Hubs Replace: the two existing Online Hubs, one on the first floor and one on the second floor, with: DEChub 900 Multiswitches and associated hardware; see Parts List [WAN : Network Distribution Hubs : Police Department Rooms 140 & 271]. to provide: 192 ports of 10baseT from the first floor, and 192 ports of 10baseT from the second floor. 4.5.2.4. Transition Issues See section: 4.5.1.4 Q0 Switchover&Transition—Disruption of Operations. 4.5.3. [1] Remote Site Connections 4.5.3.1. Special Requirements it is important to note that the upgrade for remote sites must occur in conjunction with the OA upgrade at those sites, including user training; each site will be upgraded completely, at one time, with one period of operational shutdown. 4.5.3.2. Existing Network A) Remote locations which connect to City Hall, do so on a point-to-point basis via the use of leased lines, except for one AIRLAN wireless connection from Facilities management in the City yards to City Hall. B) The existing wiring, in most locations with a wire plant, is CAT3, which is suitable for this upgrade, except for"The Fire Department Main Station" (see below). Many sites do not use a wire plant; they use patch cords because all hardware is close together, and patch cords will continue to be used. A limited number of sites have old RS232-C type wire plant, which must be upgraded to CAT5. Network Upgrade Plan - Section 4 Page 20 C) City currently has approximately 30 Racal 6424 DSU's in use which vendor may consider for re-use in this project. Re-use of any existing City equipment which has not yet become dated would be welcomed. 4.5.3.3. [1] Common to all Remote Sites See Appendix for list of Remote Sites. A) Replace all leased lines with Frame Relay connections. B) All existing hardware will be replaced. C) All sites, including those which currently have no leased lines, will be connected by Frame Relay connections. D) Create Two major connection points to the Frame Relay cloud: 1) One at City Hall for all non-Public Safety locations; communications via redundant T1 connections. However, the second T1 connection will only be made if it will provide significant additional redundancy by taking a different, geographically separated path to the telecommunications provider. 2) One at the Police Department for all Public Safety sites; communications via dual (redundant) T1 connections, with caveat noted above. E) Remote Sites, (See Remote Sites Listing, Appendix B) Each remote site will connect via 56kB or 1280 Frame Relay, and be provided with at least the following hardware, shown on the Parts List [WAN : Basic Remote Site Connection Hardware : Basic Remote Site Connection Package Package (BRSCP)] 4.5.3.4. [1] Sites Requiring Same Hardware Approximately forty-four(44) sites require the same hardware (among the 44 are 3 branch libraries) shown on the Parts [WAN : Basic Remote Site Connection Hardware : Basic Remote Site Connection Package Package (BRSCP)] A) Police and Fire Department substations will connect to the PD. B) All other remote stations will connect to City Hall.. 4.5.3.5. [1] Sites Requiring Different Hardware Approximately eight (8) sites require different hardware. 4.5.3.5.1. [q The Fire Department Main Fire Station The Fire Department's existing LAN, which is ThinNet Ethernet will be used in parallel with the new system, until abandoned, and will not be connected to the City's network. The main fire station is currently connected via a single phone circuit which supports 8 devices on the City network. Network Upgrade Plan - Section 4 Page 21 Provide: network hardware to support 48 users, with connection via Frame Relay to the Police Department. This site requires 128kb Frame Relay. 4.5.3.5.1.1. [I] Install Category 5 wiring A) Install CATS wiring from Network Closet to 48 office locations specified by the City. B) See section 4.5.1.6 : CAT 5 Wiring Requirements. 4.5.3.5.2. [q The City Yards The City Yards are in transition amidst extensive construction activity. Provide: Frame Relay connections from 4 remote buildings to the City Hall. Provide: items on the Parts List for 4 sites [WAN : Remote Site Connection Hardware : City Yards]. This site requires one 128kb Frame Relay and three 56k1b Frame Relay connections. 4.5.3.5.3. [1] The Parks and Recreation Main office Provide: items on the Parts List [WAN : Remote Site Connection Hardware : Parks and Recreation Main Office] This site requires 128kb Frame Relay. 4.5.3.5.4. [1] Animal Control Provide: items on the Parts List [WAN : Remote Site Connection Hardware : Animal Control Facility]. 4.5.3.5.5. [1] Feldheym Library Provide: items on the Parts List [WAN : Remote Site Connection Hardware : Feldheym Library]. 4.5.3.5.6. [1] All Branch Libraries Provide: items on the Parts List for 3 sites: [WAN : Remote Site Connection Hardware : Branch Library Connection Package and [WAN : Remote Site Connection Hardware : Basic Remote Site Connection Package]. Network Upgrade Plan - Section 4 Page 22 4.5.4. Telecommunications Services Telecommunications services will be provided by GTE or an alternative proposed by Vendor. Almost all remote sites within the city are currently served by GTE. A small number of locations are served by PACBELL. 4.5.5. [1] Network Management Stations The ability to effectively manage this complex network is critical to its success and an important part of its implementation. Two dedicated network management stations will be installed for this purpose, one in the Police Department and one in City Hall. Both Network Management Stations will support the Simple Network Management Protocol (SNMP). SNMP provides a way for network managers to monitor, troubleshoot and manage a network composed of different types of hardware from different vendors. This system will be able to be configured to support both the network components and the servers and workstations that will populate the network. 4.5.5.1. [1] Network Management Station Hardware Provide Two Stations: One station will be located in City Hall and the other in the Police Department Minimum required configuration is listed on Parts List [WAN : Network Management Stations]. 4.5.5.2. [1] Network Management Station Software The Parts List [WAN : Network Management Software] describes software tools required by the hardware listed. Vendor should provide an enterprise level integrated network management solution. 4.5.6. [1] Dial-in Capability Provide two 24-port modem pools, one at City Hall and one at the Police Department, capable of supporting dial-back and Microsoft RAS connections. The selected device must maintain its own security and be capable of directing connections to any system on the network. Network Upgrade Plan - Section 4 Page 23 5. COMPUTER AIDED DISPATCH (CAD) / RECORDS MANAGEMENT SYSTEM (RMS) UPGRADE 5.1. Introduction The software upgrade for the CAD and RMS upgrade will be performed by the Public Safety software vendor. Only the hardware upgrade will be considered for possible inclusion as part of this Proposal. 5.2. Hardware [I] Provide: 2 Digital Alpha servers for CAD, ( 1 mapping, 1 dispatching) and 1 Digital Alpha server for RMS, all running Digital UNIX. See Parts List [CAD/RMS Servers - Digital UNIX] [I] Provide: 30 Workstations for the Public Safety Dispatch Center. See Parts List [CAD Workstations -Technology Only] Because of the sensitive nature of the data stored on the CAD and RMS systems, high levels of security and facility preparation are required. The following sections describe how these systems will be installed to meet these requirements. 5.3. Facilities The CAD/RMS system requires a facility equipped with uninterruptable power supplies (UPS), proximity to the CAD workstations, and telecommunications services. The Police Department facility meets these requirements. The entire building is supported by a UPS and has adequate air conditioning. Suitably secured rooms for hardware installation are available in close proximity to the workstations that will connect to these systems, and all telecommunications services required for CAD/RMS terminate in this building. 5.3.1. Coordination of Relocation of CLETS Connection The County Sheriffs Dept. will work with MIS and the Police Dept. to relocate the connection to CLETS, which is currently between City Hall and the County, to connect between the Police Department main station and the County. 5.4. Networking A switch will allow for the entire bandwidth to be available to update workstations. This requires installation of a Fast Ethernet 100-Base-T data switch in room 271 to connect the CAD Servers to the CAD dispatch terminals. The Wide Area Networking section of this plan outlines further details of the network support for the CAD system. Network Upgrade Plan - Section 5 Page 24 5.5. Security Considerations The CAD application must be made as secure as possible. This system is connected to the California Law Enforcement Telecommunications System (CLETS), and when this entire project is completed, to the Internet through its connection to City Hall. In order to secure CAD/RMS, a tiered 'firewall" system is to be installed as part of the Internet connection. This firewall system will provide 2 layers of security between CAD/RMS and the Internet. For more information on the firewall and the Internet connection see Section 3: "Internet Connection.' Network Upgrade Plan - Section 5 Page 25 6. GEOGRAPHIC INFORMATION SYSTEM (GIS) UPGRADE 6.1. Existing System The Geographic Information System (GIS) is currently hosted on 3 Digital VAXstation 3100 workstations. They will be replaced with 3 Digital Alpha workstations. No application software installation needs to be performed; however, the mechanism for performing data transfer must be set up. These systems currently connect to the City's OA machine in the form of a VMS cluster. The GIS application will be moved to the WINDOWS NT operating system. 6.2. New Hardware [p Provide: See Parts List [Networked Computer Systems : GIS Workstations] [1] Bidder must propose a domain architecture, and discuss its advantages and disadvantages. A tape drive must be accessible by all 3 workstations. The new systems will be configured to form a "local area cluster' in the basement of kft�- City Hall. The new cluster will be independent of the old cluster in current use. The new machines will use Microsoft Windows NT to form the cluster and TCP/IP to communicate with other systems on the network. It may be necessary to us DECnet to form the cluster. At this time, we are waiting for our mapping software vendor to approve Windows NT. One machine will be designated to hold the user authorization files and common files that will be used by all the systems so as to minimize system administration. TCP/IP will be installed after the systems have formed a cluster. The GIS software will then be installed. Sample data will be downloaded from the existing systems and the new configurations will be tested for proper operation. 6.3. Data Transfer [1] An NT version of the GIS software is expected to be released during the period of performance of this project. Installation of this new software is not a part of this project; however, Vendor shall, with consultation by the GIS software vendor through MIS, devise a mechanism for transferring data from the existing system to the new system. After installation of hardware and operating system software by vendor, and installation of the application software by the City, the data transfer mechanism will be tested to the satisfaction of the City staff. A special archive backup of the data will be made on the existing system as a final precaution. Since all the machines will reside on the same network the data Network Upgrade Plan - Section 6 Page 26 structures used by the application will be divided between the three new workstations and copied as appropriate. The new GIS systems will host data according to function; although any of the 3 will be able to access data on the other 2. One station will host Public Works and Public Services data. The second station will host 'base data" Public Safety data, and the domain's logon files. The third station will host remaining City GIS data. Network Upgrade Plan - Section if Page 27 7. OFFICE SYSTEMS UPGRADE 7.1. Existing Applications Currently the City operates a Digital ALL-IN-1 office automation system. This software allows access to WordPerfect for VMS and Lotus 1-2-3 for VMS for word processing and spreadsheet applications respectively. ALL-IN-1 itself also provides r for e-mail capability. All of these applications run on a single VAX 4000 computer. The replacement of this system, and extension of the new capabilities to the rest of the City is the purpose of this area of work. The City also operates several other applications Servers, which will be retained, on Alpha and Pentium hardware platforms. These systems are outlined in the table below: Systems to be retained: SYSTEM NAME OP SYS HARDWARE APPLICATIONIFUNCTION SABLE Digital UNIX DEC Alpha 2100 Business System IMGSRV MS NT DEC Alpha 1000 Imaging Server JBSRV MS NT NEC Pentium Jukebox Server (Imaging) IMGTXT MS NT NEC Pentium Full Text Server (Imaging) OCRSRV wn V3.11 NEC Pentium OCR Server (Imaging) BLISS MS NT Gateway PC Business License Server (OCRSRV will be migrated to MS NT.) Legend: MS = Microsoft DEC = Digital (Digital Equipment Corporation) NEC = Nippon Electronics Corporation In general terms, these systems will continue to operate in their current fashion. However, some changes will be applied so as to complete their integration into the upgraded network. 7.2. New Office Automation (OA) System Hardware and Operating Systems The new hardware for the City network is divided between servers and workstations, or clients. The hardware discussed here is in addition to servers and workstations noted in other parts of this document. Network Upgrade Plan - Section 7 Page 28 7.2.1. Install 2 new Servers located as follows: 7.2.1.1. [1] The basement of City Hall for OA (Mission Critical) Provide Hardware: Digital AlphaServer 4100 5/400, which will be connected directly to the GIGAswitch. This machine will serve all of the City's users, except for Public Safety. See Parts List [Networked Computer Systems : Office Automation Servers : City Haig as the OA Server to be installed in City Hall. Provide Software: MS Exchange, Intranet NT Web server, SOL, SMS, file and print services See Parts List [Networked Computer Systems : Software and Licenses] 7.2.1.2. [q Police Department for OA (Mission Critical) a) Provide hardware: Digital AlphaServer 4100 5/400, which will connect to the dual-ring FDDI. See Parts List [Networked Computer Systems : Office Automation Servers : Police Department] This machine will serve all Public Safety users. Provide Software: MS Exchange, Intranet NT Web server, SQL, SMS, file and print services See Parts List [Networked Computer Systems : Software and Licenses] 7.2.2. Integration of New and Existing Server Systems The two new systems will be combined with the existing Windows NT systems and the SABLE system into a city-wide Windows NT domain. There is also an existing small NT LAN at the City Yards site. 7.2.3. [1] Changes To Existing Systems Make changes to the following existing systems prior to their integration with the new machines, as follows: System Name OS Description Of Change/Upgrade SABLE Digital UNIX Install Pathworks V5 for Digital UNIX IMGSRV MS NT Reinstall NT with new domain name JBSRV MS NT Reinstall NT with new domain name BLISS MS NT Reinstall NT with new domain name IMGTXT MS NT Reinstall NT with new domain name OCRSRV Win V3.11 Upgrade to NT with new domain name Network Upgrade Plan - Section Page 29 7.3. Workstation (Client) Hardware and Software 7.3.9. [1] New Office System Software The new application software; e.g., word processing, will be installed on the 2 primary OA Servers and shared by users in locations so served. Users in locations without a Server will have applications loaded locally on their PCs. Existing applications, will continue to be hosted on the systems which currently host them. [I] Bidder will recommend optimal configuration. [J] Provide software shown on Parts List [Networked Computer Systems : Software & Licenses : PC Clients] Major Software is described, as follows: 7.3.1.1. Microsoft Office 97 The primary office systems applications will be provided by the Microsoft Office 97 suite of products. This includes Microsoft Word, Excel and PowerPoint for word processing, spreadsheets and presentations respectively. 7.3.1.2. Microsoft Office 97 Professional Limited number of users will be provided Professional Suite. 7.3.1.3. Microsoft Exchange Electronic mail (e-mail)will be provided by Microsoft Exchange. This package will allow mail to be exchanged both within the City and with external organizations via the SMTP capability of this software. [1] MS Exchange will be configured on two (2) systems: The Public Safety and City Hall OA servers. The City Hall OA server will provide SMTP connectivity for Internet e-mail. 7.3.1.4. [q Terminal emulator Provide KEA 420 for Windows 95 and NT, to enable a PC user to operate all other existing UNIX/VT terminal programs on the PC. 7.3.1.5. [1] Web Browser Provide MS Internet Explorer 7.3.1.6. [1] Virus Detection and Removal Provide full-featured virus detection and removal software which must have the ability to automatically detect that a floppy diskette has been inserted, and scan the diskette for any viruses both at the desktop and on the Servers. Network Upgrade Plan - Section Page 30 7.3.2. [1] Office System Software Acquisition Bidder should select the most favorable mechanism for providing software upgrades and support. Describe pricing mechanisms. Microsoft and the State Of California have a contract which allows any public sector agency to purchase software at the best price Microsoft offers to any of its customers. This arrangement is through a Select Contract Agreement. The discount level available through this contract is likely to be significantly better than the licensing available under Microsoft's MOLP program which is available through distributors. Call the LA State Computer Store at: 800/915-9373. Contact Anne L'Heureux, Branch Manager, or Ed Turriaga, representative for the San Bernardino area. 7.3.3. Workstation (Client PC) Acquisition 7.3.3.1. Introduction Since the Office Automation (OA) PCs will be installed over an 8-12 month period, PC technology and pricing will certainly change. The City wants to be assured of the best pricing and latest technology for each group of PCs that will be delivered. It is unlikely that funds will be available outside those acquired through this RFP to upgrade PCs for the foreseeable future. Hence, maximizing the City's return on PC investment over the longest possible time will be an important component of the selection process. Consequently, it is not possible to specify now what the configuration will be for PCs to be delivered even in three months. 7.3.3.2. [1] Manufacturer PCs must be manufactured by a "tier one" manufacturer, and all be the same brand; although these requirements may be waived for a compelling reason. 7.3.3.3. [1] Cost Basis Bidder must provide current Master Distributor Cost for the PC's and the number of percentage points above Master Distributor Cost for the particular brand or line of PCs offered as well as for the available options. Price will include integration of options and installation at the user location. City has facilities that are secured and may be used for staging. 7.3.3.4. [1] Range of PCs Bidder must propose four configurations. One appropriate for the regular OA user, one for the Power User, one for Public Safety Dispatch Radio Consoles and one for Public Safety Dispatch Telephone Consoles. The minimum configurations must meet at least the specifications listed below. Network Upgrade Plan - Section Page 31 (There are also two network management stations that are described in section 4.5.5.1 : [I] Network Management Station Hardware.] The choice will not be based on price alone, but on cost/performance and expected performance longevity of the PC. 7.3.3.5. [1] Minimum Workstation (Client PC) configuration for "Regular User" New workstation hardware will be current technology with the following minimum configurations: a) Intel 166-MHz Pentium. b) 256K cache c) 32-bit PCI expansion bus. d) 16-MB memory, expandable to at least 64MB. e) PCI graphics adapter w/2MB RAM (expandable to 4MB) f) 1.2GB Hard Drive g) 1.44MB Floppy Drive h) 104-key keyboard and mouse i) Energy Star Compliant 1) 15' monitor (specify actual image diagonal in addition to manufacturer's listed screen size), minimum 1024 x 768 screen resolution, with 0.28mm dot pitch, non-interlaced, 70Hz. k) EISA 10baseT Ethernet Network Interface Card. 1) 2 open EISA and 2 open PCI slots must be available after installation of the hardware listed above. 7.3.3.6. "Power-User" Workstation a) Intel 200-MHz Pentium Pro (MMX technology would be desirable.) b) 256K on-chip cache c) 32-bit PCI expansion bus. d) 32-MB memory expandable to at least 128MB e) PCI graphics adapter w12MB RAM (expandable to 8MB) f) 2.1GB Hard Drive g) 1.44MB Floppy Drive h) USB port(s) i) 104-key keyboard and mouse j) Energy Star Compliant k) 17' monitor (specify actual image diagonal in addition to manufacturer's listed screen size), minimum 1280 x 1024 screen resolution, with 0.28mm dot pitch, non-interlaced, 70Hz 1) PCI 100-Base-T Ethernet Network Interface Card Network Upgrade Plan - Section, � Page 32 m) 3 open EISA and 1 open PCI slots must be available after installation of the hardware listed above. 7.3.3.7. "Public Safety Dispatch Radio Console" Workstation a) Intel 200-MHz Pentium Pro (MMX technology would be desirable.) b) 256K on-chip cache c) 32-bit PCI expansion bus. d) 32-MB memory expandable to at least 128MB e) PCI graphics adapter supplied by software vendor(do not include) f) 2.1GB Hard Drive g) 1.44MB Floppy Drive h) USB port(s) i) 104-key keyboard and mouse 1) Energy Star Compliant k) 2 (two per unit) 21' monitors (specify actual image diagonal in addition to manufacturers listed screen size), minimum 1280 x 1024 screen resolution, with 0.26mm dot pitch, non-interfaced, 70Hz 1) PCI 100-Base-T Ethernet Network Interface Card m) 3 open EISA and 1 open PCI slots must be available after installation of the hardware listed above. 7.3.3.8. "Public Safety Dispatch Telephone Console" Workstation a) Intel 166-MHz Pentium Pro b) 256K on-chip cache c) 32-bit PCI expansion bus. d) 32-MB memory expandable to at least 128MB e) PCI graphics adapter supplied by software vendor(do not include) f) 2.1GB Hard Drive g) 1.44MB Floppy Drive h) USB port(s) i) 104-key keyboard and mouse j) Energy Star Compliant k) 17' monitor(specify actual image diagonal in addition to manufacturer's listed screen size), minimum 1280 x 1024 screen resolution, with 0.28mm dot pitch, non-interlaced, 70Hz 1) PCI 100-Base-T Ethernet Network Interface Card m) 3 open EISA and 1 open PCI slots must be available after installation of the hardware listed above. Network Upgrade Plan - Section 7 Page 33 7.3.3.9. Options The following options shall be offered for any of the PC's at the discretion of the MIS Director. Vendor shall also state in proposal whether City employees may purchase a PC for their personal use at the cost proposed to the City. a) 8x CD-ROM Drive (EIDE) b) 12x CD-ROM (SCSI) c) 33.6kb modem d) UPS APC preferred. e) 2.1 GB drive (SCSI or EIDE) f) 4.3 GB drive (SCSI) g) SCSI device controller card h) 150, 17 and 21' monitors i) Additional memory j) Additional video RAM k) 10/100baseT Ethernet cards (if base configuration does not support) 1) multimedia package 7.3.3.10. [1] On-site Warranty Service Requirement On-site warranty service is required for the entire PC, including all installed components. Quote cost and response time for on-site service. Indicate if included, for what period of time, and cost after warranty period. Local vendor preferred. 7.3.3.11. [1] Batch deliveries of PCs A) Since it is expected to take between eight and twelve months to install and train all users, PCs should be delivered at a rate specified by the MIS Director per month. Quantities would be determined based on size of City workgroups chosen to be upgraded each month. Installation and training must be coordinated so that uninstalled units do not begin to stockpile. B) Each month, or whenever there is an introduction of a new model or a price change of more than 5%, the PC "menu"will be updated to take advantage of updated pricing, models and configurations. PCs will be ordered from the menu and be installed during an approximately one-month period. C) It is understood that each batch of PCs will not necessarily be identical to the previous groups of PCs because of market changes as mentioned above. D) Bidder will propose a mechanism so that the City can take advantage of expected price decreases and technology advances. In addition, as the installation progresses, much will be learned, permitting changes in PC configuration to assure optimal productivity. E) City has an interest in a "refresher' agreement, which would ensure upgrading of PC hardware long term. If vendor proposes such an agreement, (not a Network Upgrade Plan - Section Page 34 requirement of this proposal), the document should be a separate document with separate pricing and titled "PC H/W REFRESHER OPTION'. Cost should not be included in this project's costs. 7.3.4. PC Configurations 7.3.4.1. [1] City Hall PCs New PC client workstations will be installed on all floors to replace the existing VT terminals. Most of the VT terminals are connected to the network through the data closet on the 3nd floor. As noted in the WAN section, closets in the basement, and the 3`d, 4h, and 5'h floors will be upgraded to service users throughout City Hall. This will allow support for both VT terminals and the growing PC population during the transition period. This strategy supports either gradual conversions or accelerated upgrades for individual workgroups. New PCs will be connected to the wire plant in City Hall that will be installed as part of the WAN upgrade. Hence, there will be two parallel wire plants. The one currently serving the dumb terminals will eventually be abandoned. The new PCs will utilize services offered by the machines in the City Hall basement In general, they will obtain shared copies of network office applications from the new Office Applications (OA) Server. They will utilize the KEA terminal emulation package to connect to SABLE to run applications on that system, as well as to connect to ALL-IN-ONE, during the transition. They will also be able to connect to disk drive services (a.k.a. shares) on SABLE, GIS stations and other NT Servers in the network as necessary. ['] Provide a plan to dispose of (sell) the VT terminals as they are replaced. 7.3.4.2. [1] Public Safety Network PCs. These will be installed on both floors of the Police Department They will have the same software as the City Hall PCs. During the transition, they will use terminal emulation to access ALL-IN-ONE served at City Hall. After the transition, they will get their office applications from the Public Safety OA Server. 7.3.4.3. [1] New Public Safety Remote Site PCs (These are the neighborhood Police Station and Fire Station PCs.) They will be connected to the LAN at their location, which will connect to the City WAN. a) Remote Public Safety PCs will run Windows 95 and TCP/IP for network communication. NT is proposed for the additional security features. b) They will run the same applications as the Police Dept. PCs; however, the office automation software will be locally installed. c) Web browser software d) Virus detection and removal Network Upgrade Plan - Section Page 35 7.3.5. Upgrades of existing PCs 7.3.5.1. [1] Software A minimal number of existing PCs not being replaced in this project will require: a) Windows 95 b) MS Office 97 c) Terminal emulator d) Web Browser e) Virus detection & removal f) Exchange client g) SMS client h) Metering package client 7.4. Management Software Another issue in successfully implementing this network upgrade is the ability to effectively manage the resulting network. Two system management workstations will be installed to support this goal. 7.4.1. Microsoft Systems Management Server (SMS) Microsoft Systems Management Server(SMS) is used to inventory PC hardware and software, distribute software to clients, perform software audits, and provide help desk functions. SMS will be installed on all of the NT servers and on every PC workstation. 7.4.2. Metering/Reporting Software [1] Provide metering and reporting software, and integrate with SMS. Bidder shall propose. 7.4.3 Enterprise Network Management Software [1] Bidder shall propose. 7.4.4 Helpdesk Software [1] Bidder shall propose. 7.5. Remote Workstation Installation Installation of workstations at remote sites (not City Hall or Main Police Station) depends upon which remote location is being examined. The speed of the transition for a given site depends upon the size of the site. The remote sites fall into the following categories: Network Upgrade Plan - Section 7 Page 36 1) "Small sites" 2) "Large sites" 3) Branch Libraries For small sites a rapid conversion will be employed, i.e., the entire site will be converted at one time including the WAN changeover. These sites will use the new OA system for file and print serving; however, the machines at these locations will have local copies of applications installed. In the case of the branch libraries, a total transition away from VT terminals will not occur due to the light pen system employed for checking out books; they will use both terminals and PCs for the foreseeable future. 7.6. Data Conversion Software Aid Vendor will provide training and a software program to facilitate data conversion, described as follows: A basic issue that Vendor will address is the difference in file naming conventions. The ALL-IN-1 user recognizes a file by a name meaningful to him or her. The ALL- IN-1 system actually uses another name that is meaningful only to the computer, not the user. This issue will be apparent in all of the ALL-IN-1 data conversion tasks. Vendor will solve this problem through use of a program that will copy the file from its machine meaningful name to the name that the user knows it by. Once this renaming is complete, MIS staff will copy the files from the old OA computer to the new OA computer into the user's new file storage area. Bidder will propose necessary products to aid in this process. Network Upgrade Plan - Section 7 Page 37 8. TRAINING PLAN A) Staffing is not a part of this RFP; however, training of existing staff is a part. B) Adequate staffing, training and appropriate tools are essential to assure the success of this project. C) 'oov�de aud�f off' MlS sfaX, jcve�. 8.1. Propose hourly fee [l] Training shall be offered at City Hall facilities to the greatest extent possible. The City will provide facilities. Vendor will set up PCs and provide any required networking and may use PCs destined for user locations for training purposes. Bidder will explain how this will work. [�] Bidder must propose an hourly class fee for training [I] Describe the philosophy and method of training proposed, class size and how the training will be organized. The Bidder will be required to submit a thorough training plan for system users as well as the technical support staff [I] Bidder shall estimate the total number of class hours recommended. [J] Recommended number and duration for training sessions should be included for each software product. [I] Training classes must be made available up to two years after all PCs are installed. 8.2. Training Goals 1) Training is to be provided to each user as close to PC installation for that user as possible. 2) The goal of the training is for each user to become capable of being productive with the software tools. To this end, class shall be a hands-on experience, where appropriate, and small enough to assure that the training is time-effective for the users. 3) It is expected that different users will have different training needs; however, a minimum training will be required to orient even experienced users. 4) End users must be trained to effectively use the new tools that will be provided. It is of primary importance that users be trained first in those software products that will be replacing functionality of the existing system. 5) ALL-IN-ONE e-mail will continue to be used as the City standard e-mail system until a switchover date, which will correspond to completion of the PC installation and training. Notwithstanding, members of workgroups that become PC-enabled earlier can communicate with each other via MS Exchange. Si_cr(w � PC, . 3 8 8.3. Staff Categories to be Trained 8.3.1. [1] MIS Technical Staff Training Needs The positions listed below are the highest level technical support positions, and therefore will be expected to understand their specific areas of responsibility, plus have a basic, general knowledge of the entire environment All will need NT and TCP/IP training early on in the project. The plan should expect a minimum of 2 people to receive every technical class, with the ideal being classes of 4 to 6 people for each technical training class. It is important that the MIS Technical Staff be offered hands-on training, on the system actually installed, and as close to the time the system becomes operational as possible. During the transition period between operation of the upgrade and full training of the technical staff, technical support must be available to help with day-to-day operations. 8.3.1.1. Programmer/Analyst - Business System Responsible for all aspects of the City's business system which is referred to in the plan as Sable. No training is needed with regard to Sable. Also responsible for the City's Imaging machines which are NT based. Although none of the systems this position maintains are being replaced in the upgrade, this position should have a basic general knowledge of the network, and requires NT and TCP/IP training. This position supervises 2 programmers. All 3 positions will need to learn to develop software in Visual Basic. They should also be trained as developers on the Internet Web server. 8.3.1.2. GIS Coordinator Responsible for all aspects of the City's Geographic Information System. No GIS related training is needed. Also responsible for all aspects of the City's Office Automation System, and will need NT and TCP/IP, and any other Gasses related to management of that system. Should also have a basic knowledge of the network. 8.3.1.3. Programmer/Analyst - Communications Responsible for all aspects of City communications. Needs to learn NT, TCP/IP, FDDI, and fiber cabling basics, as well as each of the many network management products mentioned in the plan. Must also be trained on network security, including the Firewalls. Will also be responsible from a system administration level for the Internet Web server. �EcrioN P�. 3 8.3.1.4. Programmer/Analyst - Public Safety Responsible for all aspects of the City's Police and Fire systems. He will receive software training from the public safety software vendor. This employee is new to the MIS environment. His background is in law enforcement, however, he has a good knowledge base in the field of computers and technology in general. Should be able to see and monitor the network behind the second firewall at the Police Department facility. Needs a solid understanding of the network and network management. Will also be responsible for security behind the second firewall, and will need a thorough understanding of firewall security features. Will need instruction in NT, TCP/IP and system administration of the O/A server. 8.3.1.5. Operations Supervisor Will be responsible for all aspects of management of the City's Intemet/Intranet at the application level. It is possible that the two operators that will be supervised by this position will do development of web pages and these three (3) positions are expected at this time to need training with relation to the Intemet/Intranet. 8.3.1.6. MIS Director Will expect adequate management level training to provide her with a solid understanding of the new environment, its components, and technical functionality. 8.3.1.7 Other MIS Staff Remaining MIS staff must be trained as appropriate. 8.3.2. Specialized User Training Topics 8.3.2.1. Internetllntranet Authoring Training in the various Web page authoring and Web site management tools provided will be offered. 8.3.2.2. Programmer training in Access, VB Enterprise Edition, and Web site development tools 8.3.3. User Training 8.3.3.1. Background Currently, users know how to use ALL-IN-1, WordPerfect for VMS, Lotus 1-2-3 for VMS, and those business applications associated with their job function. While the business applications expertise will continue to apply in the new environment, many other aspects will change. For example, the character cell versions of WordPerfect and 1-2-3 are much different than the new versions of MS Word and Excel that will . Ci IG1! S IC, be employed. Also, users will be using Windows 95, an Internet browser and a new e-mail system. The Exchange system will use SMTP to send and receive mail with extemal organizations via the Internet. This capability is built into Exchange. Conversely, ALL-IN-1 does not have a built-in SMTP capability. Adding this to the old OA system would require additional software which would be used for a very limited time, and it would require valuable time to configure and maintain during the transition. For these reasons the two mail systems will not be able to communicate with one another. While this will create some measure of dislocation during the transition, it will allow the transition to occur more rapidly. A) During the transition period the City will be using two separate mail systems. B) Conversion of ALL-IN-1 mail to Exchange will occur on a user-by-user basis and will be coordinated with PC and network hardware installations and user training. The actual conversion will occur as a batch process. This will involve extracting user data from the ALL-IN-1 File Cabinet intermediate files which are then copied to the Exchange server and imported into the new mail system. Data structures the user has created in their File Cabinet can be transferred to Exchange. 8.3.3.2. [Not a Part] Conversion of Lotus 1-2-3 Spreadsheets to Microsoft Excel City staff will convert Lotus 1-2-3 spreadsheets to Excel following the same procedure as that for WordPerfect documents. The spreadsheets will be renamed and transferred to the new OA system. Once the spreadsheets have been copied to the new OA system they will be converted by Excel as they are opened by users. As above, the initial conversion will take a period of time depending upon size and complexity of the spreadsheet, but further conversions will not be required so long as the spreadsheet is saved in Excel format. There are approximately 3,000 spreadsheets that may require conversion. 8.3.3.3. [1] User Training Training for users will be an on-going process, especially during the transition period. Basic training in the use of the operating system and office applications will be coordinated with the installation of new hardware. Every effort will be made to assure that this training will occur immediately prior or immediately after installation of hardware, although this may not always be possible. After users have received a base level of training, detailed training in certain applications will be made available. It is preferred that a training package be negotiated with a local vendor with a specified number of each type of class available to the City over a timeframe of at least 2 years. This would allow users to be sent to the classes they need at the time most convenient to the City. Topics to be covered in the User training are: 8.3.3.3.1. Transition Issues 8.3.3.3.2. Introduction to PCs and Windows 95 The unique features of the network should be instructed, tailored to specific groups, especially users at remote locations, etc. 8.3.3.3.3. Introduction to the Internet and Web Browser 8.3.3.3.4. MS Word: Beginning, Intermediate, Advanced (Office 97) 8.3.3.3.5. Excel: Beginning, Intermediate, Advanced(Office 97) 8.3.3.3.6. Power Point: Beginning, Intermediate, Advanced (Office 97) 8.3.3.3.7. Exchange & Schedule+ 8.3.3.3.8. Data Conversion Training Conversion of data from the existing ALL-IN-1 system to the new NT system will be one of the most important tasks in this project. The success of data conversion is a large factor in the perception of success from the user perspective. No matter how well the new network performs, if existing user data cannot be transferred easily and reliably then the project can be perceived poorly. 8.3.4. [1] Program to Facilitate File Conversion A basic issue that will be addressed is the difference in file naming conventions. The ALL-IN-1 user recognizes a file by a name meaningful to him or her. The ALL- IN-1 system actually uses another name that is meaningful only to the computer, not the user. This issue will be apparent in all of the ALL-IN-1 data conversion tasks. This problem will be solved through the use of a small program that will copy the file from its machine meaningful name to the name that the user knows it by. Once this renaming is complete the files will be copied from the old OA computer to the new OA computer into the user's new file storage area. 8.3.5. [1] Switchover of ALL-IN-1 Mail to Microsoft Exchange ALL-IN-ONE e-mail will continue to be used as the City standard e-mail system until a Switchover date, which will correspond to completion of the PC installation and training. Notwithstanding, members of workgroups that become PC-enabled earlier can communicate with each other via MS Exchange. ALL-IN-1 Mail messages will be converted to Exchange, as necessary. Vendor will provide conversion software. [Informational Only] Background for Staffing Requirements .S,ceTI o- S PG.�2' An accepted measurement of staffing level efficiencies is the ratio of LAN system administrators to end users. This ratio is studied and updated on a regular basis by several leading research groups. Meta Group and Infovision International report ranges from a low of 40:1 to a high of 125:1. Currently, the City has 600 users on the City network and over 200 waiting for the capability to be able to join the network. This total of 800 end users today yields a 200:1 ratio in the City. Any future growth will increase the already disproportionate workload ratio. Selecting a high middle value ratio of 100:1 for today's count of 800 users, plus an allowance of 100 users for room for growth, would require a total of 9 high level technical support staff. A lesser number of users per operator should be used to identify correct level of lower level service positions due to the increased level of service required at the intelligent desktop as opposed to simple VT terminals. Using a ratio of 80:1 would require a total of 11 lower level technical service positions. Programmers and clerical staffing levels are not addressed in these equations. The current MIS staff of 4 administrators and 2 operators is grossly understaffed for the existing and simpler VT environment, and is managing the City's environment today through extraordinary efforts; however, the City must increase support staff and provide training for new and existing staff to provide a satisfactory level of support to the new network. Increased complexity is a price to be paid for the added value that modem LAN's, WAN's, and desktop intelligence provide. Lack of adequate support staff will create a myriad of problems as users become frustrated with their inability to take full advantage, and in a timely manner, of their new tools. Managers will also be frustrated as expectation levels for increased productivity and efficiency levels are undermined by their inability to get prompt technical support as problems or questions arise. 8.4. Helpdesk The City may wish to contract out the Helpdesk function. Vendor will address how Helpdesk needs will be handled during the transition and afterwards. 8.5. Training for Helpdesk personnel MS Office 97 (Word, Excel, PowerPoint) MS Exchange MS Windows 95 Web browser(s) 8.6. Support Skills to be Outsourced 8.6.1 [1] Hardware Maintenance (all) Cost a C�'r W S V� �3 8.6.2 [1] Software Maintenance Cost NT, Win 95, SMS, Office Applications, Netview, Pathworks ClearVISN, other software acquired to satisfy this project E i i �0 N City of San Bernardino Network Upgrade Parts List; Hardware and Software Appendix A (Parts List) Networked Computer Systems _ )ffice Automation Servers - Windows NT Server City Hall Item Qty. Part No. Description 1 1 ON-51 HAA-EA Digital AlphaServer 4100 5/400 System Drawer, NTAS, 512MB, CD 2 1 H9A10-ED Digital RETMA Cabinet Kit, 4.3GB 3 1 KZPSC-BA StorageWorks 3 port PCI SCSI RAID Controller 4 3 BN31 S-1 E SCSI Cable 5 1 VRC15-KA Digital 15" SVGA Color Display 6 9 RZ29B-VW StorageWorks 4.3GB Fast/Wide SCSI HDD 7 1 MS100-AB 32MB Cache memory for RAID Controller 8 1 KZPSC-UB Cache battery backup for RAID Controller 9 1 BN31K-OE SCSI Cable Bulkhead connector 10 1 DEFPA-MA PCI FDDI (DAS- UTP) adapter 11 1 BN25H-03 3m FDDI cross-over cable 12 1 H7291-AA Redundant Power Supply for AlphaServer 4x00 13 1 TZ88N-VA 20-40GB DLT tape drive 14 1 KZPAA-AA Single-ended SCSI controller for DLT tape drive 15 1 BN21 K-02 SCSI Cable 16 3 BA36R-RA StorageWorks SCSI 7 device shelf 17 1 4N-AEAAJ-CL Prestige 6kVA single phase 6OHz UPS, for Cabinet 18 1 4N-AEAES-AA Prestige UPS unattended monitoring &shutdown software 19 1 FM-56724-36 Warranty uplift 4100 Pedestal/Cab to 3 year 7x24, Or resp. Police Department 20 1 DN-51 HAA-EA Digital AlphaServer 4100 5/400 System Drawer, NTAS, 512MB, CD 21 1 H9A10-ED Digital RETMA Cabinet Kit, 4.3GB �rrr 22 1 KZPSC-BA StorageWorks 3 port PCI SCSI RAID Controller 23 3 BN31 S-1 E SCSI Cable 24 1 VRC15-KA Digital 15" SVGA Color Display 25 9 RZ29B-VW StorageWorks 4.3GB Fast/Wide SCSI HDD 26 1 MS100-AB 32MB Cache memory for RAID Controller 27 1 KZPSC-UB Cache battery backup for RAID Controller 28 1 BN31 K-OE SCSI Cable Bulkhead connector 29 1 DEFPA-DA PCI FDDI (DAS-MMF) adapter 30 1 BN34B-03 3m Fiber duplex cable 31 1 H7291-AA Redundant Power Supply for AlphaServer 4x00 32 1 TZ88N-VA 20-40GB DLT tape drive 33 1 KZPAA-AA Single-ended SCSI controller for DLT tape drive 34 3 BA36R-RA StorageWorks SCSI 7 device shelf 35 1 BN21 K-02 SCSI Cable 36 1 FM-5B724-36 Warranty uplift 4100 Pedestal/Cab to 3 year 7x24, Or resp. CAD/RMS Servers - Digital UNIX Rack 1: Custom Server 1 for CAD 37 1 PB78S-FA AlphaServer 1000A RM 5/400, UNIX 38 2 DE500-XA PCI Fast Ethernet Adaptor 39 1 Shared Monitor Shared Monitor will be used 40 1 PB7MA-CC 64 MB Memory 41 1 RZ28D-EJ 2.1 GB 7200 RPM SCSI Disk 42 1 PBXGA-BA ZLXp-E2 2D 8-plane PCI graphics 43 1 PB7MA-CE 256 MB Memory Page 1 of 8 3/4/97 4:38 PM M City of San Bernardino Network Upgrade Parts List; Hardware and Software 44 4 RZ28D-VW 2.1 GB 7200 RPM StorageWorks Wide Disk 45 1 BA36R-AF StorageWorks Wide RM Shelf(bezel) 46 1 BA36R-AR StorageWorks Wide RM Shelf(no bezel) 47 1 KZPSC-AA PCI 1 port RAID controller 48 1 BN31 S-1 E SCSI Cable 49 1 TLZ09-VA 8 GB StorageWorks DAT Tape (1.55 MB/sec) 50 1 KZPAA-AA PCI SCSI Controller 51 1 BN21 N-02 Single Ended to Fast SCSI Cable 2 meter 52 1 QL-MT7AE-AA Digital UNIX Traditional unlimited user license 53 1 QL-05SAE-AA TruCluster Available Server for Digital UNIX license 54 1 QA-05SAA-GZ TruCluster Available Server for Digital UNIX doc Rack 1: Custom Server 2 for CAD 55 1 PB78S-FA AlphaServer 1000A RM 5/400, UNIX 56 2 DE500-XA PCI Fast Ethernet Adaptor 57 1 Shared Monitor Shared Monitor will be used 58 1 PB7MA-CC 64 MB Memory 59 1 RZ28D-EJ 2.1 GB 7200 RPM SCSI Disk 60 1 PBXGA-BA ZLXp-E2 2D 8-plane PCI graphics 61 1 PB7MA-CE 256 MB Memory 62 4 RZ28D-VW 2.1 GB 7200 RPM StorageWorks Wide Disk 63 1 BA36R-AF StorageWorks Wide RM Shelf(bezel) 64 1 BA36R-AR StorageWorks Wide RM Shelf(no bezel) 65 1 KZPSC-AA PCI 1 port RAID controller 66 1 BN31 S-1 E SCSI Cable 67 1 TLZ09-VA 8 GB StorageWorks DAT Tape (1.55 MB/sec) 68 1 KZPAA-AA PCI SCSI Controller 69 1 BN21 N-02 Single Ended to Fast SCSI Cable 2 meter 70 1 QL-MT7AE-AA Digital UNIX Traditional unlimited user license 71 1 QL-05SAE-AA TruCluster Available Server for Digital UNIX license 72 1 QA-05SAA-GZ TruCluster Available Server for Digital UNIX doc RMS Fire Server 73 1 PB78P-FA AlphaServer 1000A 5/400, UNIX, 128 MB, 2.1 GB, CD 74 1 DEFPA-MA PCI FDDI (DAS- UTP) adapter 75 1 VRC15-KA 15 inch (13.9 inch viewable) 1024X768 Monitor(Northern Hemisphere) 76 1 PB2GA-FB ATI Mach64 8-plane, PCI graphics 77 1 PB7MA-CD 128 MB Memory 78 3 RZ28D-VW 2.1 GB 7200 RPM StorageWorks Wide Disk 79 1 TLZ09-DB 8 GB DAT Tabletop Tape (1.55 MB/sec) Frost White 80 1 KZPAA-AA PCI SCSI Controller 81 1 QL-MT7AE-AA Digital UNIX Traditional unlimited user license 82 1 QA-MT4AA-H8 Digital UNIX media and documentation on CD-ROM 83 1 H7290-AA 450 watt Power Supply RMS Police Server 84 1 DA-52HAB-EA AlphaServer 4000 5/400, UNIX, 512 MB, 4.3 GB 85 1 DEFPA-MA PCI FDDI (DAS- UTP) adapter 86 1 H9A10-ED AlphaServer 4rooc RETMA Kit 87 1 VRC15-WA 15 inch (13.9 in. viewable) 1024X768 Monitor(N. Hem.w/US pwr cord) 88 3 RZ29B-VW 4.3 GB 7200 RPM StorageWorks Wide Disk 89 1 TZ87-TA 10/20 GB DLT Tabletop Tape 90 1 KZPAA-AA PCI SCSI Controller 91 1 BN23G-01 SCSI Cable (1 meter) Page 2 of 8 3/4/97 4:38 PM City of San Bernardino Network Upgrade Parts List; Hardware and Software 92 1 KZPSC-AA PCI 1 port RAID controller 93 1 QL-MT7AG-AA Digital UNIX Traditional unlimited user license 94 1 H7291-AA Power Supply Rack Components 95 1 H9A10-CE 67 inch Rack (120 volt)- Rear Doors 96 1 2T-IODEV-LK Keyboard rackmount 97 1 2T-RMMON-15 15 inch Rackmount monitor 98 1 VRC15-KA 15 inch (13.9 inch viewable) 1024X768 Monitor(Northern Hemisphere) 99 1 2T-H7085-CG 2 Port Master Console Switch 100 1 2T-H7085-10 10 ft. split cable kit (2 servers to master console) CAD Workstations - Technology Only CAD Dispatch Workstations -Windows NT Workstation Intel 200-MHz Pentium Pro w/MMX, 256K on-chip cache, PCI, 32mb, 4mb 20 20 VRAM, 100BASE-T, SCSI controller, Windows NT Workstation 21 20 2.1GB SCSI hard disk 22 20 1.44MB floppy drive 23 20 104-key keyboard and mouse 24 20 Video cans supplied by software vendor 21" monitor, energy star compliant, 1280x1024, 0.26 dot pitch, non-interlaced, 70Hz CAD Telephone Operator Workstations -windows 95 Intel 166-MHz Pentium processor, 256K cache, PCI, 32mb, 2mb VRAM, 26 10 100BASE-T, Windows 95 27 10 EIDE disk controller 28 10 2.1GB hard disk 29 10 1.44MB floppy drive 30 10 104-key keyboard and mouse 17" monitor, energy star compliant, 1024068, 0.28 dot pitch, non-interlaced, 70Hz GIS Workstations - Windows NT Workstation 32 3 PB47A-CA AlphaStation 255/300, NTWS, 10BASE-T, CD, 1.44MB 33 3 MSP01-BC Digital 128MB memory kit 34 3 FR-PCXAV-ZZ Digital 21" SVGA Color Display,D60, .26mm dot pitch 35 3 LK47W-AA PC Style keyboard plus system power cord 36 3 PBXRZ-HB StorageWorks 2.1GB Fast SCSI HDD 37 3 PBXRZ-NA StorageWorks 4.3GB Fast SCSI HDD 38 3 BN31V-01 SCSI Cable, 1 meter 39 3 QB-OQRAA-SA Windows NT Workstation Media and Documentation 40 3 PBXGB-CA Powerstorm 4D20 24plane Z-buffer PCI graphics accelerator Internet Connection Systems Primary Firewall; City Hall 41 1 FR-B4OWW-AC Digital Prioris MX 6200, 32mb, 256kb cache, 12xCD, 1 mb VRAM, 10/100 42 2 FR-CDCBA-CA 2.OGB Ultra/Wde SCSI HD in SBB 43 1 FR-PCBSK-AA US Country Accessory Kit 44 1 VRC15-KA Digital 15" SVGA Color Display 45 1 DE500-AA 10/100 Ethernet adaptor- PCI Secondary Firewall; Police Department 46 1 FR-B4OWW-AC Digital Prioris MX 6200, 32mb, 256kb cache, 12xCD, 1mb VRAM, 10/100 47 2 FR-CDCBA-CA 2. 0 gb Ultra/Wde SCSI HD in SBB 48 1 FR-PCBSK-AA US Country Accessory Kit Page 3 of 8 3/4197 4:38 PM City of San Bernardino Network Upgrade Parts List; Hardware and Software 49 1 VRC15-KA Digital 15" SVGA Color Display 50 2 DEFPA-DA Digital PCI FDDI DAS MMF adaptor 51 2 BN3413-03 3m Fiber duplex cable Internet Server 52 1 FR-B4OWW-AC Digital Prioris MX 6200, 32mb, 256kb cache, 12xCD, 1mb VRAM, 10/100 53 2 FR-CFCBA-CA 9.OGB Ultra-Wide SCSI drive in SBB 54 1 FR-PCXAT-AJ 418 GB DAT SCSI tape drive 55 1 FR-PCBSK-AA US Country Accessory Kit 56 1 VRC15-KA Digital 15" SVGA Color Display User workstations (no vendor specified; technology only) Regular user configuration 57 1 Intel 166-MHz Pentium processor, 256K cache, PCI, 32mb, 2mb VRAM, integrated 10BASE-T 58 1 EIDE disk controller 59 1 1.2GB hand disk 60 1 1.44MB floppy drive 61 1 104-key keyboard and mouse 15" monitor, energy star compliant, 1024x768, 0.28 dot pitch, non-interiaced, 62 70Hz Power user configuration 63 1 Intel 180-MHz Pentium Pro w/MMX, 256K on-chip cache, PCI, 32mb, 4mb VRAM, integrated 10BASE-T, SCSI controller 64 1 2.1GB SCSI hard disk 65 1 1.44MB floppy drive 66 1 104-key keyboard and mouse 17" monitor, energy star compliant, 1024x768, 0.28 dot pitch, non-interlaced, 67 70Hz Options for either configuration at discretion of department 68 1 33.6 modem 69 1 8xCDROM (EIDE) 70 1 12xCDROM (SCSI) 71 1 Uninterruptable power supply 72 1 4mm DAT tape backup unit 73 1 2.1 GB drive (SCSI or EIDE) 74 1 4.3 GB drive (SCSI) 75 1 16MB/32MB memory upgrade 76 1 Video Ram 17" monitor, energy star compliant, 1024x768, 0.28 dot pitch, non-interlaced, 77 1 70Hz 21" monitor, energy star compliant, 1280x1024, 0.26 dot pitch, non-interlaced, 78 70Hz Software & Licenses (incl. all client licenses) NT Servers 79 2 321-00015 Microsoft Backoffice Server 80 2 312-774V400 Microsoft Exchange Server, Internet Mail Connector 81 2 312-674400 Microsoft Exchange Connector 82 7 BENTSE-R0000-610 Backup Exec Single Server Edition (incl. existing servers) 83 1 BENTEE-R0000-610 Backup Exec Enterprise Edition backup software (CH only) 84 2 BEAGEX-R0000-610 Backup Exec Exchange Module version 6.1 85 2 BEAGSO-R0000-610 Backup Exec SOL Module 86 3 BERNTW Backup Exec Workstation Edition (GIS Workstations) Page 4 of 8 3/4/97 4:38 PM City of San Bernardino Network Upgrade Parts List; Hardware and Software 87 7 NST00025-ITBN-250 Mcafee NetShield for NT server 88 3 Web server software to be proposed by vendor 89 1 1-57231-329-3 Resource kit for Office 97 90 1 1-55015-678-2 Resource kit for Windows 95 91 1 1-57231-343-9 Resource kit for Windows NT Workstation 92 1 1-57231 -344-7 Resource kit for Windows NT Server PC Clients 93 600 381-00102 Microsoft Exchange Server client access license 94 5.00 355-00124 Microsoft SMS Client Access license 95 500 Microsoft NT Client Conned license 96 450 Microsoft Windows 95 (or current), if not bundled on PC 97 50 Microsoft Windows NT Workstation (for public safety remote sites) 98 4-75 021-01447 Microsoft Office 97 Standard Edition, Lic. only 99 gZ5 353-00318 Microsoft Office 97 Professional Edition, Lic only 100 1 021-00691 Microsoft Office 97 Standard Edition 97-full product 101 1 353-00005 Microsoft Office 97 Professional Edition 97-full product 102 1 QM-4MRAA-AE Polycenter AssetWorks, 1000 PC client licenses or equivalent 103 5,00 VMS terminal emulator-vendor to recommend 104 3100 Web browser-vendor to recommend 105 5 com00100-1 cbn-200 McAfee VirusScan95- 100 pack 106 10 Web page development software-vendor to recommend Other systems 107 1 QL-GL7AB-AA TCP/IP Services for VAX 4000-100a,Traditional License 108 1 QA-03XAA-H8 Digital OpenVMS Layered Products on CDROM 109 6 QM-377AA-AA Polycenter AssetWorks Enterprise client license, VMS/UNIX or equiv. Page 5 of 8 314/97 4:38 PM City of San Bernardino Network Upgrade Parts List; Hardware and Software Wide Area Network Ilain Switch (located in City Hall basement) Item Qty. Part No. Description 110 1 DEFGA-EA Digital GIGAswitch Chassis, 4 port SAS—SCP-PWR 111 2 DEFGX-AA Power cables 112 1 DEFGB-DA Redundant Power Supply, GigaSwitch 113 1 DEFGP-AA SCP (Switch Control Processor) 114 5 DEFGL-BA 4 Port SAS Line Card, No PMD's 115 12 DEFXU-BA FDDI-TP-PMD Mod-PMD 116 8 DEFXM-AA FDDI (MMF) ANSI MIC PMD, 2Km 117 3 DEFPA-MA PCI to FDDI Adapter- DAS, TP-PMD (for existing servers) 118 2 BN24B FDDI - FDDI cable F/O 119 10 BN25H UTP RJ45 cable 120 5 BN3413-10 Cable 121 1 4N-AEABF-AA Prestige Model 1250EXT UPS Internet Connection Hardware (in City Hall connected to basement hub) 122 1 DEWBR-NA Digital Brouter 123 1 DETMI-SA Digital 8 port 106ase-T Managed Hub 124 1 BC12G-06 Digital V.35 Cable 125 1 3165-A2-210 AT&T Paradyne Acculink 3160 T1 DSU/CSU (frame relay& Internet) Network Distribution Hubs City Hall Basement 126 1 DMHUB-AA Digital DEChub 900 Multiswitch 127 3 H7894-MA Power Supply, DEChub 900 128 4 DETPJ-MA Digital 32 port Ethernet Portswitch 129 1 DVNEF-MA Digital VN FDDI to 12 port 130 1 DENEX-MA Digital VN Fast Ethernet to 12 port 131 2 DEXYU-AA 10013ase-TX Mod PHY 132 2 BC12G-06 Cables 133 1 DEZBR-RB Digital 8 port wide area router 134 1 Shiva LanRover Access Switch 135 1 Shiva Dual T1 Interface for Access Switch 136 2 Shiva analog modem card (12 channels/card) 137 2 3165-A2-210 AT&T Paradyne Acculink 3160 T1 DSU/CSU (frame relay & Internet) 138 1 4N-AEABF-AA Prestige Model 1250EXT UPS City Hall 3rd Floor 139 1 DMHUB-AA Digital DEChub 900 Multiswitch 140 3 H7894-MA Power Supply, DEChub 900 141 5 DETPJ-MA Digital 32 port Ethernet Portswitch 142 1 DVNEF-MA Digital VN FDDI to 12 port 143 1 DENEX-MA Digital VN Fast Ethernet to 12 port 144 2 DEXYU-AA 10013ase-TX Mod PHY 145 1 4N-AEABF-AA Prestige Model 1250EXT UPS City Hall 4th Floor 146 1 DMHUB-AA Digital DEChub 900 Muttiswitch 147 3 H7894-MA Power Supply, DEChub 900 148 4 DETPJ-MA Digital 32 port Ethernet Portswitch 149 1 DVNEF-MA Digital VN FDDI to 12 port 150 1 DENEX-MA Digital VN Fast Ethernet to 12 port 151 2 DEXYU-AA 100Base-TX Mod PHY Page 6 of 8 3/4197 4:38 PM City of San Bernardino Network Upgrade Parts List; Hardware and Software 152 1 4N-AEABF-AA Prestige Model 1250EXT UPS Nty Hall 5th Floor 153 1 DMHUB-AA Digital DEChub 900 Multiswitch 154 3 H7894-MA Power Supply, DEChub 900 155 4 DETPJ-MA Digital 32 port Ethernet Portswitch 156 1 DVNEF-MA Digital VN FDDI to 12 port 157 1 DENEX-MA Digital VN Fast Ethernet to 12 port 158 2 DEXYU-AA Digital 100Base-TX MM-100 MOD PHYS 159 1 4N-AEABF-AA Prestige Model 1250EXT UPS Police Department Closet 140 160 1 DMHUB-AA Digital DEChub 900 Multiswitch 161 3 H7894-MA Power Supply, DEChub 900 162 6 DETPJ-MA Digital 32 port Ethernet Portswitch 163 1 DVNEF-MA Digital VN FDDI to 12 port 164 2 BC12G-06 V.35 Cables 165 1 DSRVW-GC DECserver 700 16-port RJ45 wKull modem contro l 166 1 Shiva LanRover Access Switch 167 1 Shiva Dual T1 Interface for Access Switch 168 2 Shiva analog modem card (12 channels/card) 169 1 DEZBR-RB Digital 8 port wide area router 170 2 3165-A2-210 AT&T Paradyne Acculink 3160 T1 DSU/CSU Police Department Closet 271 — 171 1 DMHUB-AA Digital DEChub 900 Multiswitch 172 3 H7894-MA Power Supply, DEChub 900 173 6 DETPJ-MA Digital 32 port Ethernet Portswitch "~ 174 1 DVNEF-MA Digital VN FDDI to 12 port 175 1 DENEX-MA Digital VN Fast Ethernet to 12 port 176 2__Q Digital 100Base-TX MM-100 MOD PHYS CAD & RMS (in closet 271) d2 -DX Ff A -DR Pct -1-o PDD i AT7 P i -,Das, Al till' 177 1 DEFHU-MU DECconcentrator 900TH, UTP-FDDI 178 1 DEHUA-CA DEChub ONE single-slot chassis 179 7 DLMFE-AA 8 Port 1006ase-T Switch 180 14 DLMFE-TX 2 Port Expansion Module Remote Site Connection Hardware Basic Remote Site Connection Package (44 sites will use, incl. branch libraries) 181 44 DEX2R-TA Digital Routeabout IP only Router 182 44 DETMI-SA Digital 8 port 106ase-T Managed Hub 183 44 BC12G-06 Digital V.35 Cable 184 44 3610-A3-001 AT&T Paradyne Comsphere 3610 64KB DSU/CSU Branch Library Connection Package (Requires Basic Remote Site Connection Package) 185 3 DSRVH-NA 90M Terminal Server 186 3 DETRX-SA Stackable Station Feldheym Library (not a branch library) 187 1 DEX2R-TA Digital Routeabout IP only Router 188 2 DETML-SA Digital 16 port stackable Ethernet hub 189 1 BC12G-06 Digital V.35 Cable 190 1 3610-A3-001 AT&T Paradyne Comsphere 3610 64KB DSU/CSU 191 1 DSRVH-NA 90M Terminal Server 192 1 DETRX-SA Stackable Station Fire Department 193 1 DEX2R-TA Digital Routeabout IP only Router Page 7 of 8 3/4197 4:38 PM City of San Bernardino Network Upgrade Parts List; Hardware and Software 194 4 DETML-SA Digital 16 port stackable Ethernet hub 195 1 BC12G-06 Digital V.35 Cable 196 1 3610-A3-001 AT&T Paradyne Comsphere 3610 64KB DSU/CSU Parks and Recreation Main Office 197 1 DEX2R-TA Digital Routeabout IP only Router 198 2 DETML-SA Digital 16 port stackable Ethernet hub 199 1 BC12G-06 Digital V.35 Cable 200 1 3610-A3-001 AT&T Paradyne Comsphere 3610 64KB DSU/CSU Animal Control Facility 201 1 DEX2R-TA Digital Routeabout IP only Router 202 1 DETML-SA Digital 16 port stackable Ethernet hub 203 1 BC12G-06 Digital V.35 Cable 204 1 3610-A3-001 AT&T Paradyne Comsphere 3610 64KB DSU/CSU City Yards (incl. Public Services, Public Works, Parks & Rec., Facilities Mgt.) 205 4 DEX2R-TA Digital Routeabout IP only Router(1 ea. bldg) 206 4 BC12G-06 Digital V.35 Cable 207 4 3610-A3-001 AT&T Paradyne Comsphere 3610 64KB DSU/CSU (each bldg.) 208 2 DETML-SA Digital 16 port stackable Ethernet hub (for fleet maint. bldg.) 209 4 DETMI-SA Digital 8 port 10Base-T Managed Hub (for satellite bldgs) Network Management Stations (1 ea. City Hall and Police Department) 210 2 FR-BI6AP-DB Digital GL 6/200, 32MB, 256KB cache, 2GB HD, 8XCDROM, 2MB VRAM 211 2 FR-PCXAV-ZZ Digital 21" SVGA Color Display,D60, .26mm dot pitch 212 4 FR-PCCAM-BC 64MB Memory upgrade (2 ea.) 213 4 FR-PCXAR-AZ StorageWorks 4.3GB Fast SCSI HDD (2x4GB mirrored, ea.) 214 2 FR-PCXAN-DA 10/100 Ethernet adaptor 215 2 4N-AEABF-AA Prestige Model 1250EXT UPS 216 2 4N-AEAES-AA Monitoring &unattended shutdown software for Prestige UPS Network Management Software 217 1 QM-37SAA-SA Polycenter AssetWorks Media/License package 218 2 Network Management software-to be proposed by vendor 219 2 QT-5FVAB-E8 ClearVISN media &documentation update services- CDROM 220 2 QA-5FVAB-H8 ClearVISN media &documentation on CDROM 221 2 QM-4YJAA-AA ClearVISN Recovery Manager License 222 2 QB-MQDAB-SA Digital Mufti Chassis Manager 223 2 QB-4YFAB-SA Digital VLAN Manager 224 2 QB-218AD-SA Digital RMON Manager 225 2 QB-4YHAA-SA Digital Router Manager for Windows, Lic, CDROM 226 1 QA-OLWAW-HC DECserver 700 media and documentation L Page 8 of 8 3/4/97 4:38 PM Appendix B (Remote Sites List) City Network sites: Connection: Users: (Includes - Site: Current and Growth factor) After Upgrade City Hall 128 Basement,mezzanine 300 North "D" (Central Site) 1st floor 160 2nd,3rd floors 128 4th floor 128 5th, 6th floor Police Station 710 North "D•. Fiber to C.H. 192 1st floor lOBaseT same 192 2nd floor 1OBaseT 48 switched with 1 100BaseT uplink port 8 serial ports Police Satellite 1584 W. Baseline, 1106 lease line to CH 8 frame relay to PD Police Satellite 1332 W. Fifth St, 1108 lease line to CH 8 frame relay to PD Police Satellite lease to CH 8 1292 W. Mill frame relay to PD Police Satellite lease to CH 8 911 Kendall St frame relay to PD Police Satellite lease to CH 8 334 W. Baseline frame relay to PD Police Satellite lease to CH 8 2025 E Highland Ave frame relay to PD Police Satellite lease to CH 8 1993 S. Diners Ct frame relay to PD Neighborhood Office ** NEW ** 8 273 E. Kingman frame relay to PD Neighborhood Office ** NEW ** 8 1451 N. California frame relay to PD Airport Police Office ** NEW ** 8 Norton Air Force Base frame relay to PD Special police satellite lease to CH 8 (Not for publish) frame relay to PD Carousel Mall Security lease to CH frame relay to PD 8 Police "B" Building fiber to PD 8 710 North "D" St same Main Fire Station lease to CH 48 200 East Third frame relay to PD Fire Station 2 ** NEW ** 8 1201 W Ninth St frame relay to PD Fire Station 3 ** NEW ** 8 2121 Muscott St frame relay to PD Fire Station 4 ** NEW ** 8 2641 North E St frame relay to PD Fire Station 5 ** NEW ** 8 1640 Kendall Dr frame relay to PD Fire Station 6 ** NEW ** 8 1920 Del Rosa Ave frame relay to PD Fire Station 7 ** NEW ** 8 282 West 40th St frame relay to PD Fire Station 8 ** NEW ** 8 3398 E. Highland Ave frame relay to PD Fire Station 9 ** NEW ** 8 202 Meridian Ave frame relay to PD Fire Station 10 ** NEW ** 8 502 S. Arrowhead Ave frame relay to PD Fire Station 11 ** NEW ** 8 450 Vanderbilt Way frame relay to PD Communications Shop ** NEW ** 8 1208 North H St frame relay to PD Parks & Rec Main Office lease line to CH 24 547 N. Sierra Way frame relay to CH 5th St. Sr. Center lease line to CH 8 600 West Fifth St frame relay to Parks Perris Hill Sr. Center lease line to CH 8 780 E. 21st St frame relay to Parks Perris Hill Park ** NEW ** 8 831 E. Highland frame relay to Parks ' Parks, Seccombe Lake ** NEW ** 8 555 N. Sierra Way frame relay to Parks Westside Community Ctr ** NEW ** 8 1505 W. Highland Ave frame relay to Parks Ctr for Individual Dev. ** NEW ** 8 8088 Palm Lane frame relay to Parks Rudy Hernandez Center ** NEW ** 8 222 N. Lugo frame relay to Parks Delmann Heights Center ** NEW ** 8 2969 N. Flores St frame relay to Parks Nicholson Ctr ** NEW ** 8 2750 W. Second St frame relay to Parks Lytle Creek Ctr ** NEW ** 8 380 South K St frame relay to Parks Mill Center ** NEW ** 8 503 E. Central frame relay to Parks Johnson Hall Center ** NEW ** 8 906 N. Wilson frame relay to Parks Ruben Campos Ctr NEW 1717 West Fifth frame relay to Parks Animal Control lease line to CH 16 333 Chandler P1 frame relay to CH Cemetery ** NEW ** 8 211 East 9th St frame relay to CH Feldheym Library lease line to CH 24 555 West 6th St frame relay to CH Inghram Library lease line to CH 8 1505 W. Highland Ave frame relay to CH Rowe Library lease line to CH 8 108 E. Marshall Blvd frame relay to CH Villasenor Library lease line to CH 8 525 N. Mt. Vernon Ave frame relay to CH Public Services lease line to CH 48 Public Works ** NEW ** 8 Parks & Recreation ** NEW ** 8 Facilities Management Airlan wireless 8 connection These 4 departments have buildings all located in an area called the City Yards at South Mt. View and South Sierra Way. All 4 will need to be frame relay back to City Hall. CATV (Cable TV Office) ** NEW ** 8 201 North E. St existing fiber to CH The CATV office is moving into the Economic Development Agency Building which has an existing fiber connection to City Hall. This upgrade project will not be funding upgrades at EDA with the exception of any upgrades necessary to connect the CATV office. LI,O� Appendix C (WAN Diagram) L O it U r Z •3 Q ` C m _ (� Yx U Yx o 4�Q C Y lia F- v � N N b _ M L 17; Y L Ow p L =------- 1- O ° o ��1 vJ cN 5 0 � ALL CL o cv N--- "� CL V U N ! W c oa m O y O Q a N `o °' a O c�? U O u- E- f g L U) CL I - -------- " U co — (Un v c U � g72 _ 3 Ual� cr- a Q ') ih LIJ vI °' — — a ----- -- -------, co i ---------------- o z >.a0cl) LL LL LL - w U Q (n � Q c O Q p E co 0 U) U_ N a cu D m r c.; _ O ry ` � = 'CaO� �' co 42 i , Q)L _O O 9u � rl 0 CL a � a € U_ W d ! �i ■ i; Appendix D (Floor Plans) rT3 IL � I ! I !' II f� `' �I 76 :0 i I ✓ t cc I L7 � o ! ; W �I II I W J I I � _ W CL JD I I I ! II du.; 71 j^ J p. W LL II tu LU il �L .i I ~ cc tz S i r' C ' J I o + � I LL iI , y zl o LIL L r Q II o f J r 1 I Cc '' W , W k yCj I I n<> L t II L = ' F TT1 ,i a u ti II E3 9 i iTlii= 7 i 1 II 2 Ille__ 7 a? F-77 —� I `II j II II I �` II `��■\a cj <vu i, � ;I LjiI I i lr� — {I1 1R1f1 114 If 7 r i I � II � .III I ,�'�< � .�I V_�•� _ �� ;i s I! Z f L IL 1— / ! I I ac I ! :ttl LL I Ift Lc tL 0 lu st II4� II j c ` x 7 � ' I i a i I: < r < I yeavwal000 �j�il II �imavah^eswvlu t X Ji a i 1L < < n W 4 Il 'N a� < o iQ o � W i i ICY^ s % I I < I I p O I 1 I I 5 U Li C g cc I J p N RE N Q s < G s o i < aLL i I I N 'r L W = O dullNVr cc r �l N VQKd3 31 1 3.7Va015 IL 0 9 OIOVa 17 c JW r W W W W � I �f J O W i W¢❑ I I W O< f 2 V r Y = _ J I C r4J\ FF,107 I 1 =SVL CI- �i I� 5h c —L r= W .I� � �E'..,_� �•� it � ' I I II I� i �i I Appendix E (Cost Sheet) UPGRADE PROJECT WORKSHEET City of San Bernardino Spec. No. F97-18 1997 NOTICE: This is a mandatory document. If you do not fully complete and submit this worksheet,your bid will be considered incomplete. Prime Vendor Name: Address: Phone: Fax: Contact name: This worksheet follows the format of the proposal. Attach sheets with information not specifically shown on this form with the Section and portion numbers in the top right corner, clearly identifying the area your information corresponds to: General Specifications: Attach any information relative to general specifications marked"General Specifications" 7. Guaranteed delivery date in calendar days: Section 0. Attach any information relative to section 0. 0.3.3 Project manager name: Attach qualifications. 0.3.14 List local vendors name(s)/location(s): Section 1. Overview Section 2. TCP/IP Section 3. Internet Provide detailed attachment. Cost: Taxes/Shipping Total Cost: 1 Exhibit E: Assumptions and City Responsibilities corrected,tested, and demonstrated following completion of the reliability test period,but prior to CITY Acceptance of the system. 4 Revision Date:2/17/97 Page 2 City of San Bernardino Interoffice Memorandum M.I.S. Division TO: Fred Wilson, City Administrator FROM: Janis Ingels, Director of MIS SUBJECT: CalState Review of City's Upgrade Proposal DATE: July 21, 1997 COPIES: Mayor and Common Council ------------------------------------------------------------ Councilman Devlin presented a copy of the City's RFP and resulting proposal to Dr. Owen Murphy at CalState San Bernardino for his review. MIS received a list of comments Friday afternoon and again Sunday afternoon. It should be noted there are literally dozens of methods of configurating the City environment that would be viable, each with it's own pros and cons. Were we to give the proposal to a dozen different agencies, we would get a dozen different ideas for the best methodology. The City's criteria and focus for putting together the best plan for this City's particular environment focused on the fact that we are a Public Safety environment, the fact that our MIS staffing level is small, the issue of the need for high security levels, the need for stable, proven technology, the need for long term expansion capabilities, and last, but not least, the City's economic condition. City MIS has a combination of over 50 years of technical expertise and experience. We're confident we've put together an excellent package for the City. We created an RFP that clearly states the City's flexibility in what we buy, quantities to be purchased, and that we will pay current prices at time of purchase. The prices in the current RFP have already fallen twice. We will be spending less than what is quoted. Due to the fact that we have this much flexibility, we are open to meeting with Dr. Murphy's staff prior to any procurements. This meeting should not delay approval to move forward with the project as this would further reduce the Public Safety software vendor's timeframe to convert PD to a new CAD and RMS system. The following is a brief summary of CalState's technical staff comments and the City's responses: This RFP should have been released as a series of 4 or 5 Previously separate requests. Each time we go to Council in a government environment it takes several months to complete the process. CAD and RMS are largely being funded with grant funds that have to be expended within a set time frame. CAD and RMS require a new backbone and office automation has been waiting for replacement for 18 months. We cannot afford to spread this project over a long timeframe. The RFP names specific DEC equipment. This essentially eliminates most of the competition, and circumvents the reason for the bidding process. Although specific equipment is listed in the RFP, the City made it very clear that vendors could propose any brand of equipment they felt would be best for the application (0. 3 . 8 of the RFP) . For technical and support reasons we specified a single vendor solution for the backbone. DEC equipment was specifically specified by the CAD/RMS vendor. Our small MIS staff has developed expertise with this platform. Remaining on this platform helps to reduce transitional costs. FDDI is obsolete. The City should be investing in either ATM or 100BaseT, but preferably SONET. The public safety environment requires technology that has been used long enough to insure stability. 911 computer applications must have a platform that guarantees continuous operation and low maintenance. FDDI is stable, mature, proven technology that is used by thousands of companies. FDDI provides near 100% throughput unlike 100BaseT (which is not backbone technology and degrades exponentially starting at about 30% throughput) . ATM and SONET are good but expensive and are not currently in widespread use in the public safety environment. The RFP should mandate that all PC's have standard components insuring computers can be board level upgraded and repaired on site and cost of upgrades and repairs will be minimal. The City has already stepped back from tier 1 manufacturer requirement for PC's. We are still looking at alternatives, but are not interested in low-level clones which, in our past experience, have shown significant failure levels. The price on the PC's we are currently negotiating fell again last week. What we will actually pay will depend on when we buy. There is a tendency for overkill - too much unnecessary hardware, for example, firewall hardware $8000 (Why is there a RAID system here?) Two firewalls are necessary for our application because our Police department houses extremely confidential criminal history information and is an access point to State and Federal criminal justice databases. The first firewall protects the City from the Internet, the second firewall protects the law enforcement data from non-Police personnel. RAID-5 is proposed as an inexpensive insurance policy against excessive downtime. Because this equipment will not be replaced for 7-10 years, we must attempt to develop a platform that will meet our needs well into the future. Why do you need 160 MB of memory on a web server? The City will house its official web site on this server. The use of graphics will be extensive. Memory is an inexpensive way of maximizing performance on this long term investment. The cost of the T-1 Internet access is listed at $1800 per month, EEE offers the same service for $1000. EEE sets their rates for city government based on the population. The last quote we received exceeded the GTE quote. GTE has the highest capacity IP network in our area. The Internet backbone is fully meshed, redundant, and power protected, yielding 99.9% network availability. GTE allows the City to have one vendor providing both voice and data. The unit price of $3140 for the Fujitsu laptops is absurdly high. These units are not laptop computers, they are handheld pen- based computers, intentionally ruggedized for field use. The hardware has a specific use and is the recommended device by the software vendor who will be interfacing their software on this unit with our permit tracking software. Pentium-based servers vs. DEC Alphas The City is open to looking at multi-processor Intel servers for our office automation servers. This procurement allows the City the flexibility to make further refinements to hardware and software during the life of the project. The City is already on a very tight schedule with deadlines we must meet. However, after Council approval on Monday, MIS would be happy to meet with Dr. Murphy. This meeting should take place next week to avoid delays in procurement. . ISWorld - High Speed Communications Page 1 of 3 High Speed Communications Contributors Puhakainen Jussi, Erwin Maher, Simon Sinnott,Paul to Bokkel ®Contact information is at the bottom of this page This page provides information on high speed communications. It gives a brief description of each of the major system architectures and links to additional information sources. [Asyncronous Transfer Mode] [Fibre Distributed Data Interface] [100BaseT] [I00BaseVG] [Technology Comparison] [ISWorld Net Navigation Map] amAsyncronous Transfer Mode (ATM) Description Asyncronous Transfer Mode (ATM) is a more recent tec to . It has gained recognition due to it's capability of transmitting voice, text, data,a�vi eo. The development of the standard has been driven by the ATM Forum. It is to be used as the communications protocol for the 3 (1�1( -.<; L v References is a useful starting point for understanding ATM is a simple tutorial on ATM 1 Fibre Distributed Data Interface (FDDI) Description Fibre Distributed Data Interface (FDDI) is a dual redundant, counter-rotating fibre ring operating at 100 MB/s. It is now a mature technology used mainly for network backbones in buildings, and <-- increasingly for high powere ne r s. References O is a comprehensive tutorial on FDDI. http://www.ecel.uwa.edu.au/—ssinnott/hscomms.htmi 7/21/97 WMMftWWWMW00NNi� 410 I Subject: Re: Internet Message Date: Sun, 20 Jul 1997 09:42:06 -0700 From: Owen Murphy <murphy @csci.csusb.edu> Organization: California State University, San Bernardino To: WJDP34A @prodigy.com CC: murphy Mr Wilson, Let me begin by saying that most of the technical comments in our first document were authored by Mr. Tonning and Dr. Karant who are both out of town this weekend. I have therefore been unable to consult with either of them in forming this reply. • Review of the RFP: • =0D • =0D • This RFP should have been released as a series of 4 or 5 • separate requests. > =0D • Each time we go to Council in a government environment it • takes several months to complete the process. CAD and RMS are • largely being funded with grant funds that have to be expended • within a set time frame. CAD and RMS require a new backbone and • office automation has been waiting for replacement for 18 months. _ > We cannot afford to spread this project over a long timeframe. • The RFP names specific DEC equipment. This essentially • eliminates most of the competition, and circumvents the reason for • the bidding process. • =0D • Although specific equipment is listed in the RFP, the City • made it very clear that vendors could propose any brand of • equipment they felt would be best for the application (0.3.8 of the • RFP). For technical and support reasons we specified a single • vendor solution for the backbone. DEC equipment was specifically • specified by the CAD/RMS vendor. Our small MIS staff has developed • expertise with this platform. Remaining on this platform helps to • reduce transitional costs. While I cannot address problems associated with moving proposals through city government, I have experience authoring and evaluating RFPs - some involving multi- million dollar projects. I have also sat at the opposite Previously - # -11-711'97 ' ' /y/0 7 2 c{' end of the table in the early part of my career, having participated in the authorship of proposals in response to RFPs. Based on this experience, I would be very surprised if any vendor- with the exception of the Digital Equipment Corp. (DEC) VAR- would waste their time to reply to such a decidedly biased RFP. The problem is twofold : 1. Since the equipment is specified using DEC product names, any respondent to the RFP would have to become very familiar with the technical specifications of that particular product. (This is especially difficult with regard to the networking equipment. In fact, we gave up trying to compare DEC's prices with other comparable products) 2. The respondent must justify the fact that the alternative equipment meets the specifications of the DEC equipment. This puts an additional burden on non-DEC VARs. The playing field is not level, and the lack of a truly competitive bidding environment will cost the City additional money. My second concern is that, given the all-or-nothing aspect of the RFP, leading networking corporations such as Cabletron and Bay Networks are effectively excluded from submitting bids in the areas that they excel - telecommunications. It is not necessary to have DEC equipment to network DEC computers! Furthermore, city businesses which could submit proposals for portions of the RFP (such as the PCs), have also been excluded since they don't deal in the sophisticated network equipment. Finally, I don't have a problem with the City continuing to maintain it's legacy systems (CAD/RMS) with familiar equipment and software. But most of the equipment specified in the RFP does not fall under this category. • FDDI is obsolete. The City should be investing in either ATM • or 10OBaseT, but preferably SONET. • =OD • The public safety environment requires technology that has • been used long enough to insure stability. 911 computer • applications must have a platform that guarantees continuous • operation and low maintenance. FDDI is stable, mature, proven • technology that is used by thousands of companies. FDDI provides • near 100% throughput unlike 100BaseT(which is not backbone • technology and degrades exponentially starting at about 30% • throughput). ATM and SONET are good but expensive and are not P, Z_ > currently in widespread use in the public safety environment. It is true that 10013aseT does not meet the performance achieved by FDDI for increasing network saturation. However, this degradation in performance (70-80 Mbits/sec versus 100 Mbits/sec.) can be alleviated with the proper segmentation of the network. It is an inexpensive alternative, and contrary to your statement regarding "not backbone technology", the entire City Hall could be quite nicely networked using this technology. Furthermore ATM and SONET are proven and stable technologies, and to cite public safety as a concern is misleading. FDDI was the technological choice 3-4 years ago. It is now considered obsolete for new installations. Has the City compared the cost of the proposed FDDI equipment with that of an ATM or much preferably SONET alternative? • The RFP should mandate that all PC's have standard components • insuring computers can be board level upgraded and repaired on site • and cost of upgrades and repairs will be minimal. • The City has already stepped back from tier 1 manufacturer • requirement for PC's. We are still looking at alternatives, but • are not interested in low-level clones which, in our past • experience, have shown significant failure levels. The price on • the PC's we are currently negotiating fell again last week. What • we will actually pay will depend on when we buy. In the past, one was never sure of the quality or compatibility of the IBM clone and its' components. This has changed considerably in the past two years to the point where the modular PC is preferable to the "brand name" PC with proprietary equipment. Advances in PC technology (e.g., Plug N' Play) now allow even the computer novice to purchase and maintain a personal computer that is easily repairable and upgradeable. The price quote from EZ Computer($400-$500 per unit less than the DEC quote) is not for a "low-level" clone. You will notice that each component of the PC is a listed "brand-name" quality part. Furthermore, the vendor is a City business, and offers a full one-year warranty on parts and labor and a five-year warranty on labor. The City's bidding process must be different than the State's. It is mentioned that you will pay less for the PCs than the amount bid. How much less? If a State bid is accepted, and the contract signed, then the state is 40 Z 2`P obligated to pay the amount bid. How is that different for the City? Also, what is the current price for the DEC PC? • Review of the Proposal by Spire Systems: • =0D • There is a tendency for overkill - too much unnecessary • hardware,for example,firewall hardware $8000(Why is there a RAID • system here?) • =0D • Two firewalls are necessary for our application because our • Police department houses extremely confidential criminal history • information and is an access point to State and Federal criminal >justice databases. The first firewall protects the City from the • Internet, the second firewall protects the law enforcement data •from non-Police personnel. RAID-5 is proposed as an inexpensive • insurance policy against excessive downtime. > =0D • Because this equipment will not be replaced for 7-10 years, we • must attempt to develop a platform that will meet our needs well • into the future. The need for the firewalls is obvious. The question is implementation. I cannot speak for my colleague who made these comments. However, a few points: the RAID system will protect against disk failure on the firewall, but other things (motherboard, network adapators) will also fail. For the cost of the RAID system, you could probably build a full "firewall clone" that would be available if any component failed on the original. (In fact for the price - $8k-you could probably get three!) Also, do you really think you will be using this same equipment 7-8 years from now? (e.g., Do you know anyone using a 386 PC for a firewall today? Of course not!) • =0D • Why do you need 160 MB of memory on a web server? • =0D • The City will house its official web site on this server. The • use of graphics will be extensive. Memory is an inexpensive way of • maximizing performance on this long term investment. This is a relatively insignificant point. But anyway, we have a variety of Web servers in our department supporting streaming audio and video; one supports over 20 virtual domains - most of the academic departments on campus. The most memory in any of these servers is 32 MB. a • =0D • The cost of the T-I Internet access is listed at$1800 per • month, EEE offers the same service for$1000. • =0D • EEE sets their rates for city government based on the •population. The last quote we received exceeded the GTE quote. GTE • has the highest capacity IP network in our area. The Internet • backbone is fully meshed, redundant, and power protected, yielding • 99.9% network availability. GTE allows the City to have one vendor •providing both voice and data. I find it hard to believe that the EEE would charge the City more than it's business customers. In any event, check out Blue Highway. They are a local company offering non-profit organizations T1 Internet access for$645 per month. Normal business customers are $800/month. The point is that a separate RFP for Internet provider should probably be released. (Check Blue Highway's Web Site at http://www.blue-hwy.net.) For the cost of one GTE T 1, you could multiplex two Blue Highway T 1 s achieving more than twice the average throughput. • =0D • The unit price of$3140 for the Fujitsu laptops is absurdly • high. • =0D • These units are not laptop computers, they are handheld pen- > based computers, intentionally ruggedized for field use. The • hardware has a specific use and is the recommended device by the • software vendor who will be interfacing their software on this unit • with our permit tracking software. I cannot respond directly, since I did not make the original comment. I have been unable to find this specific palm-top device for sale on the Internet. • Pentium-based servers vs. DEC Alphas • =0D • The City is open to looking at multi-processor Intel servers •for our office automation servers. This procurement allows the • City the flexibility to make further refinements to hardware and • software during the life of the project. • The City is already on a very tight schedule with deadlines we • must meet. However, after Council approval on Monday, MIS would be • happy to meet with Dr. Murphy. This meeting should take place next • week to avoid delays in procurement. I can appreciate your scheduling deadlines, and I find it interesting that a proposal submitted in early April has yet to be approved. I see no point in meeting. My department was asked to give a critical evaluation of the RFP and the response. We have done so. You may do what you like with the information. We are more than happy to be of service to our City and community. Owen Murphy Professor& Chair of Computer Science California State University, San Bernardino San Bernardino, CA 92407 Phone (909) 880-5326 Fax (909) 880-7004 E-Mail murphy @csci.csusb.edu I i _HEF'IF,� L _ R ID 9i�`i�::�r�ad4 DE�� 0'? ? 1 : a P-;o , 01C F , ID � t SERVICES AGREEMENT D SERVICES AGREEN ENI' THIS AGR.El-1YfENT is entcrcd into this day of ,g. ` , 19 97 bemw•een Co. Sheri f f's _(-CONTRACTOR")and the CITY OF SAN BERNARDINO.("t`TTY"). WITNESSETH: A. WHEREAS, CITY has need for^ CLETS line move �3tttin the City; and, H. WHEREAS, CONTRACTOR is competent,experienced and able to perform said services;surd, C, WHEREAS, CONTRACTOR has provided the lowest responsible bid for providing such services; NOW THEREFORE,the parties hereto agree as follows: 1. CONT'RAC'TOR shalt furnish CLETS line move scnrices to CITY in acwrdance with Bid Speciftcadons F- none requi red. 2. Over the term of this Agreement, CONTRACTOR shall be paid for such services an amount in accordance with actual services rendered and equipment purchased. 3. CON'T'RACTOR shall provide the MIS Department with a monthly Invoice in arrears and shall be provided payment within thirty(30)days therefrom. CTTY retains the right to challenge all or any part of an invoice. QWhile not restricting or limiting the foregoing, during the term of this Agreement, contractor shall maintain in effect pe4ok*af comprehensive public, general and automobile liability �etr- insurance, in the amount of$1,000,000.00 combined single Limit, and statutory worker's compensation coverage, and shall file se ' n with the CITY'S Risk Manager prior to any work under this Agreement. , S. CONTRACTOR shall perform work tasks as directed by the MIS Department,but for all intents and purposes CON711-ACTOR shall be an independent CONTRACTOR and not an agent or employee of the CITY. 0:. _.�_. SERVICES AGREEMENT D SERVICES AGREEMENT THIS AGREEMENT is entered into this day of , 19 97 between Co. Sheriff Is ("CONTRACTOR")and the CITY OF SAN BERNARDINO("CITY"). WITNESSETH: A. WHEREAS, CITY has need for CLETS line move within the City;and, B. WHEREAS,CONTRACTOR is competent,experienced and able to perform said services;and, C. WHEREAS, CONTRACTOR has provided the lowest responsible bid for providing such services; NOW THEREFORE, the parties hereto agree as follows: 1. CONTRACTOR shall furnish CLETS line move services to CITY in accordance with Bid Specifications F- none required. 2. Over the term of this Agreement,CONTRACTOR shall be paid for such services an amount in accordance with actual services rendered and equipment purchased. 3. CONTRACTOR shall provide the MIS Department with a monthly invoice in arrears and shall be provided payment within thirty(30)days therefrom. CITY retains the right to challenge all or any part of an invoice. 4. While not restricting or limiting the foregoing, during the term of this Agreement, �—� contractor shall maintain in effect pokier of comprehensive public, general and automobile liability self–insurance, in the amount of 51,000,000.00 combined single limit, and statutory worker's compensation ce tifjcat� of Self n ance cgvera e coverage, and shall file eepic �f�t�witi the CTTY'S ls�Canager prior to any work under this Agreement. , 5. CONTRACTOR shall perform work tasks as directed by the MIS Department,but for all intents and purposes CONTRACTOR shall be an independent CONTRACTOR and not an agent or employee of the CITY. e Review II of City of San Bernardino Network Upgrade Plan Preface The RFP and the Proposal by Spire Systems were reviewed by Mr. Paul Tonning, Operating Systems Analyst for the Department of Computer Science, Yasha Karant, Ph.D., Director of the Institute for Applied Supercomputing, and Owen Murphy, Ph.D., Professor and Chair of Computer Science at CSUSB. In addition, Dr. Murphy and Mr. Tonning met with Mr. Fred Wilson, the City's MIS Staff, and with Captain Robert Curtis of the Police Department. As mentioned in the previous review, the Department of Computer Science at CSUSB operates and maintains its own Computer Facility which houses the Institute for Applied Supercomputing. This facility includes over 120 Engineering Workstations along with 2 supercomputers, 3 mini-supercomputers, 5 fileservers, 4 webservers with streaming audio and video capabilities, E-Mail Servers, Database servers and 32 dial-in modems. The facility is supported by network and Internet connectivity including 1OBaseT, ATM, FDDI, and SONET. The department's network is often used by telecommunications companies such as Cabletron and Fujitsu for pre-market testing of network equipment. The reviewers of this proposal are now aware of two serious problems that confront the City's MIS staff that outweigh the technical and cost concerns that we expressed earlier. The first problem is the fact that the MIS department is understaffed. This problem will be more apparent over the next few months as the City moves from the centralized computing environment that now exists, to a much more complicated distributed network environment. A technician assigned to support end-user software and hardware technical problems will soon be needed, as "dumb" terminals are replaced with Pentium based workstations. A network engineer devoted to maintaining and upgrading the City's telecommunication infrastructure is desirable as well. The MIS staff is dedicated and knowledgeable. They should be commended for the long hours they work serving the City. The second problem lies in the fact that large amounts of equipment are replaced every 7-8 years with one-time funding proposals. This is an ineffectual hedge against rapid technological advancement that is now part of society. A much more effective approach is to fund equipment replacement with an annual budget. $500K per year over 8 years will achieve greater results than multi-million dollar one-time expenditures since it will allow the City to keep its equipment relatively current with incremental upgrades and replacement. It will also avoid the situation the City now faces where equipment is hopelessly obsolete. (Hopeless in the sense that any upgrade or migration path opportunities have passed years ago; most of the existing equipment must be completely replaced.) Without an annual equipment budget, it is impossible to do any kind of planning to avoid such situations. s-/v/X� Review of the RFP This proposal calls for a turn-key network using a single vendor DEC. Given the staffing and funding of the MIS department coupled with the urgency to replace a failing obsolete CAD system, this is apparently yhe only alternative. We suspect that the City administration is unaware of the major technological leap that is being made here. Although the staff members we met are competent professionals, they are by no means sufficient to provide the necessary support for this new network. Therefore maintenance support from the vendor(especially in the Public Safety area) is mandatory. We will address the three major areas of the RFP. • Network The City is extending an FDDI ring to support their new distributed computing environment at the same time that CSUSB is replacing their FDDI backbone with ATM. Clearly, there are better alternatives to the one proposed, but they involve a variety of computer and telecommunications equipment from various companies. For example, the LAPD has a Cabletron network supporting IBM, HP and SCO-Unix/Intel computer systems. However, without an on-site network engineer, the City must rely on a single vendor to provide "cradle to grave" support for the CAD system. Furthermore, the City cannot jeopardize the Police Department's grant money by delaying this installation for further study. • Computer Hardware We cannot disagree with the decision to select a single vendor to support both the network and major computer servers due to the lack of on-site staff which would be required to support multiple platforms. The City can save considerable money by purchasing modular custom made PCs as opposed to brand-name computers like DEC. The advantage of the clone PC (constructed with brand-name components) is that these machines can be easily repaired and upgraded in-house in addition to costing $300-$400 less. Proprietary systems (like the DEC PC) typically have non-standard system boards which make repairs and upgrades difficult if not impossible. The DEC PCs have a full 3 year warranty with the first year on-site. The custom made PCs typically have a 1 year warranty (but not on-site). However, the components of the modular PC will typically carry their own 3-5 year warranty. If the City decided to maintain and upgrade the modular PCs on-site, the result would be better service and monetary savings. However, this would be an additional burden on the MIS department. It should be noted however, that most end-user problems associated with the use of a PC will be software and training related. Therefore, on-site hardware related service provided by DEC will only be one aspect of the support that will be required with this new network installation. • Computer Software The City can possibly save money on Microsoft software purchases by using special licensing programs. For example, Microsoft offers Office 97 to government organizations who presently use Wordperfect Software for only $145 per license as opposed to $288 per license quoted by Spire. (This is significant since the City is purchasing over 400 licenses.) In addition, the government price for MS Windows 95 is only $78 - not$159 as quoted by Spire. The MIS Department is aware of these price differences, and these savings can be passed on to the City by Spire. Conclusion We will make no specific recommendation based on the technical merits and cost factors of this proposal since these aspects are overshadowed by the following facts. • The MIS department is not staffed to provide the technical support which would be required with alternative plans. • Without an annual equipment budget, incremental growth and expansion cannot be a consideration. • The public safety computer system is obsolete and failing. It must be replaced as soon as possible. • There is some urgency with regard to the expenditure of funds related to the Police Department grant. There is little time for alternative studies and proposals. Finally, we strongly recommend that the City administration develop a strategic plan to address the technological needs of our City government. Entered into Record at CouncillCmVOevCms Mtg. by re Agenda Item �- City ClerkICOC Secy City of San Bernardino