MOTOROLA, INC. 2 - 2005 - Laserfiche WebLink

Home Browse Search

City of Santa Ana Exhibit C -1, System Description AVL Playback Overview AVL Playback enables the ATM operator to graphically display the historical location coordinates of a selected unit. The AVL Server automatically logs the unit coordinate history in the AVL history database; the AVL Unit Playback accesses the AVL history database and plays back the historical position of a selected unit's location. 1.3 Premier Universal Data Transfer (UDT) Premier UDT transfers event and audit records from Motorola® CAD to a secure Windows 2000 server for ad hoc query and reporting. Premier UDT exports CAD data in a variety of industry standard formats, including ASCII, Xbase, and SQL. Event data contains the embedded x/y coordinates, which allows the data to be used to populate a number of OLE compliant GIS based crime analysis tools. The Premier UDT application transfers records from the Audit, Event, Configuration Database, 911 Call, Pager, Support Equipment from within Motorola® CAD to the Premier UDT server. After the data is transferred to the Premier UDT server, it is parsed out of its textual format and placed into relational database tables. This parsing results in giving incidents and units values for their attributes. 1.4 Ad hoc Reporting Solution Motorola provides a completely configurable reporting system, which will allow Santa Ana Fire to create ad hoc reports as well as use the standard report library that are included with the system. Even the novice, authorized user, will have access to Motorola CAD data without extensive training on complex reporting tools. Users generate ad hoc queries on any data element contained in the Motorola CAD application. To ensure that ad hoc reporting does not have an impact on system performance, as well as to provide easy access to data, these applications run on a separate dedicated Windows 2003 server, using the Microsoft SQL Server relational database management system. This methodology allows all resources of the fault tolerant production server to be used for calltakers and dispatchers to achieve maximum productivity and minimum response times, without being impacted by ad hoc reporting. Reports can be displayed on screen or set to a local or network printer, depending on the workstation configuration. Reports are available to managers, supervisors, and other authorized personnel depending on the security levels defined by Santa Ana Fire. The user has the option of printing a hard copy of the results, displaying the results on the screen, and/or saving the results to a file, Query results can be exported as CVS, HTML, PDF, or Quicksheet (Palm) files. Exhibit C -1, System Description C1 -4 05/2105 CN: 05 -17505 Design, engineering, and pricing information contained in this offering is considered proprietary and may not be shared with any person or agency not directly associated with the addressee without the express written consent of Motorola, Inc., or its designees.