Loading...
HomeMy WebLinkAbout12 - Purchase of Software, SpeedTrack, Inc.CITY OF NEWPORT BEACH CITY COUNCIL STAFF REPORT Agenda Item No. 12 January 26, 2010 TO: HONORABLE MAYOR AND MEMBERS OF THE CITY COUNCIL FROM: Police Department Robert M. Luman, Chief of Police, 949 644 3701, RLuman @nbpd.org Bill Hartford, Lieutenant, 949 644 3660, BHartford @nbpd.org SUBJECT: APPROVAL OF NEGOTIATED PURCHASE OF SOFTWARE FOR AUTOMATED DAILY FIELD ACTIVITY REPORT FROM SPEEDTRACK, INC. RECOMMENDATION: City Council authorize the waiver of Council Policy F -5, the adopted purchasing guidelines, and authorize the Chief of Police or his designee and the City Attorney or his designee to negotiate with the sole source vendor SpeedTrack, Inc., for the purchase, installation, and maintenance of automated daily field activity reporting software. 2. Approve a Budget Amendment (BA10 -000) increasing expenditure appropriations in 1820 -8141, Supplies Computer' Software, by $85,000. DISCUSSION: Background: For the past several years, the Police Department has been exploring options concerning the development of an automated Daily Field Activity Report (DFAR). Currently, patrol officers are responsible for completing a DFAR following each duty shift. After the completion of the DFAR, it is tracked and maintained as a record of the officer's activity. The data contained in the DFAR is used by management to determine crime patterns, employee productivity, and as a communication tool between the employee and their supervisor. The DFAR, generated by the employee, can be hand written or completed on a computer utilizing a program in File Maker Pro. The information captured and maintained on the document is dependent on the amount of detail provided by the officer and is seldom a complete record of all officer- generated activity. Manually producing the form can reduce the amount of available time the officer has for field activities. Current DFAR's are maintained in supervisors' files for several months and then stored in large boxes. At the close of each month, supervisors are required to manually review Approval to Purchase Software for Daily Field Activity Report January 26, 2010 Page 2 each officer's DFAR and complete a written recap of the officer's activities. If the supervisor. needs to retain information from a monthly recap or daily field activity report, he must conduct a time consuming hand search to retrieve the data. Automation of DFAR's would allow the Police Department to electronically capture all field activity generated by all officers, provide 'a searchable database to effectively and efficiently analyze data contained in the DFAR's, and increase productivity by eliminating the need for officers to manually generate the record, thus increasing available field time. Suggestions have been made by patrol officers requesting that the DFAR be generated through the Police Department's Computer Automated Dispatch (CAD) and Records Management Programs (RMS). After discussion with the Police Department's CAD and RMS vendor, Northrop Grumman, members of the Police Department's Information Technology Section determined that the current Northrop Grumman operating program, Altaris, could not support an automated DFAR program. The alternative provided by Northrop Grumman.was the purchase of their latest RMS and CAD software package, Command Point, which would cost the Police Department well over $500,000. Due:to the extensive cost of acquiring a new software system, a third -party solution was sought. Members of the Department met with the staff of SpeedTrack, Inc., the developers of Guided Information Access (GIA) software. GIA software acts as a search engine. utilizing the RMS and CAD databanks to generate data that provides analytical information, which can be utilized for resource management, analysis of crime patterns and trends, and.the evaluation of policing strategies and tactics. The GIA platform supports two SpeedTrack specific programs: the Criminal Information Management System (CRIMes), which .provides advanced crime analysts data to management staff, detectives, and field officers; and the Employee Records ManagementlEarly Warning System (EWS), which affords a composite view of the activities of field officers through the generation of an automated DFAR. Data obtained through EWS would provide better accountability of patrol officers' field performance to supervisors and management staff. The EWS will also provide a DFAR electronic repository which would allow the Police Department to expand the number of DFAR(s) currently stored. GIA software is patented to SpeedTrack, Inc. They are the sole licensor of the software and the only third -party solution available that provides a software system that meets the needs of the Police Department. SpeedTrack has proposed an initial payment of $50,000, which. includes the set up and implementation of the system at a cost of $32,500; and the first years annual license fee, which is $17,500. Following the initial year's payment, SpeedTrack has proposed an annual license fee payment for the next two years of $17,500 each. Approval to Purchase Software for Daily Field Activity Report January 26, 2010 Page 3 The SpeedTrack software solution will address the concerns of our patrol officers, eliminate the redundancy of the current DFAR system, provide better accountability of the field performance of officers, improve the gathering of statistical data, expand DFAR storage capability, reduce the costs associated with timely manual searches, and afford the. management staff with accurate data concerning crime trends and the efforts made by patrol officers to address those trends. Fiscal Impact: Approve funding from the General Fund Unappropriated Reserve in the amount of $85,000 for the installation, programming, and three -year licensing agreement for an automated Daily Field Activities Report and crime analysis and investigative software. Environmental. Review: The purchase of software from SpeedTrack, Inc., has been determined not to be a project for purposes of the. California Environmental Quality Act. Prepared by: Bill Hartford, Lieutenant Support Services Division Submitted by: Robert M. Luman CHIEF OF POLICE... Attachments: SpeedTrack, Inc., Scope of Work SpeedTrack, Inc., Quotation Email from Miles Yano, CEO, SpeedTrack, Inc. Approving Public Release of Scope of Work Budget Amendment Sole Source ]ustification SpeedTrack, Inc. is a privately held California corporation which has invented and patented an entirely new data management system. This is achieved by our patented technology, designed specifically for managing and analyzing information in the networked world. Current data management systems were designed 40, years.ago to work with mainframe computer systems requiring a rigid data structure, making them inflexible._...__.__. and cbs* to maintain. No other crime analysis, software system software we know of today utilizes our approach and technology platform. If any company is displaying its information using the overlapping category approach (non - hierarchical) and the simultaneous display and shrinking of associated categories and items from the data. population then they would need a license from SpeedTarck or would be in violation of our.US patent #: 5,544,360, 6,826,566 and 7,236,972. Police departments spend minions each year to integrate and analyze information vital to solving crimes. Over. the years. most PD's have accumulated a variety of software programs to handle different aspect of their_ business.. The result is information that is stored in databases which cannot easily be used to analyze information on the fly. Current,data integration software projects run into the.millions with the licenses ranging from $250K -$IM+ plus implementation fees costing an equal or higher amount. Ongoing maintenance and IT support can tack on an additional 15 -20% per year. Additional costs anse.because the software applications are inflexible in handling new disparate information. Consequeridy, the systems need to be continually customized at significant additional cost T he IT staff is constantly writing new programs to extract relevant information which was not planned for in the initial design and this requires having unique programming experts for each applcation. These costs are the result of the inherent limitations and complexity of using Relation Database Management Systems. The Underlying Problem:. Current data management systems require that all the questions to be answered must be known before the system is built, If the questions change, the system will need to be rebuilt This results in rigid software applications written for each specific use even though they share the same information. With the increasing amount of new information that is constantly being captured it is impossible for the current systems, to be fast enough and flexible enough to keep up with the changing information and to anticipate all the possible questions that might be posed. THe bottom line as it relates to the underlying technology of current law enforcement software applications is that these were not designed to handle the growth or diversity of the information generated in today's environment Spy ff —Mck's Solution, A completely new data management system, specifically designed to store and retrieve any. type of digital information from multiple sources, is what- SpeedTrack has engineered and can provide you at a modest cost Our patented technology provides a technological capability not offered or even available from any other known company The benefits are: • Eliminates replication of data • Eliminates rigid data structure • . Automatically creates the answers to the questions • Integrates all types of disparate (digital) information into one place easily and automatically Versatile Thin Ghent application suitable for corporations, PCs, handhelds and wireless devices • Inherent scalabitity with minimal hardware additions Facilitates easy programming changes and maintenance • Reduces hardware requirements for existing commerce/enterprise software applications • 'lowers cost of ownership and improves software performance by 10X l ona.Bnach Police Department:" Long Beach has implemented the CRIMS and ERMS systems pioneered by SpeedTrack. CRIMeS provide extraordinary investigative search capabilities, trend. identification and workload monitoring tools. that are,of particular interest to investigators, crime analysts and patrol officers, as well as police management, fRMS was developed to capture and analyze important administrative data that facilitate comparisons of various performance metrics among employees and work groups. Both systems support the early identification and recognition of trends so that proactive responses can be developed and rapidly implemented. The applications. are based upon Speedrrack's unique patented technology which provides a range and level of service unmatched in the industry. 2 TABLE OF CONTENTS NEWPORT BEACH POLICE DEPARTMENT DAILY FIELD. ACTIVITY AND CRIMINAL INFORMATION ANALYSIS PROJECT .................................................................. ............................... 3 OBJEGTlVE ..::....::................................................................................................. 3 ............ :.................. COMMENTS /ISSUES TO BE ADDRESSED ............................... ............................................................ 3 1 GENERAL ...............:...........:...........................................:::.................:......... .........:...:................4 2 OVERVIEW OF THE SPEEDTRACK SOLUTION ......................................... ..............................4 2.1 Analyze Data 5 ............ ................................. ............... :.............................................................................. 2.2 Assist in Communication :..........:..............................................:.............................. 6 ............................... 3 SPEEDTRACK SOFTWARE ................................................... :. 6 ....... ............. ................................ 3.1 Client Side Software...' 6 ............................................... ........................ ............. . .... V .......................... 3.2 Server. Side Software ................................. :.............................. 6 .................... ......::..:..:............................ 3.3 Download of Data Extraction Capabilities ....................... .. ...... ...................... .. ................. ...................... 7 3.4 Data Management Abilities ........................................................ ............................................................... 7 3.5 Spatial Analysis Capabilities ........................ .............. ............................... .................. 7 3.6 CoinpStatpreparation: Techniques .........::..... ::... 7 3.7 Compatibility with Other Analytical Applications...........: .. ............................::. ...... 8 3.8 Mapping Compatibility with Google Earth, ESRI, ArcG1S or Other Mapping System Software....... 8 4 HARDWAREISOFTWARE REQUIREMENTS ............:.......::.........,............... ..............................8 4.1 Server.Hardware ............. ..... .... ....... .. •• ..I.......... .................... ..............................8 4.2 Server Operating System ...............................:........:........:.....:.::..:::..::....:................ .I.................... 8 .......... 4.3 PC Client............ ...................... ............................... .............................8 4.4 Server. Access ... 8 ... ......... .:................. ........................................ .................................................................. 5 INSTALLATION PROCESS ....................................... ..... .. ............................. :............................. 9 6 IMPLEMENTATION SCHEDULE ......................................... s:..:.:................ .. .................. I............. 9 7 DATA MANAGEMENT AND STORAGE CAPABILITIES...... ....................... .:...........................10 71 Product Integration. Capabilities for.Extracting Data from WO and CAD .......... ........:....................10 7.2 Data.Storage Capabilities .............................:........::..........................................:...... .............................10 8 OTHER SERVICES AND SUPPORT ............................:......................:..::.... :............................11 8.1 Training Plan ..... :............... 11 .................................. :............. .. ................................................................... 8.2 Security Measures-4 ................... . .............. .......................:.............................. .............................11 8.3 Support,.Mainteuance and Product Updates :......................:..:..::.......................... .............................11 8.4 Product Upgrades 13 .......................................... ................................ ......... ,.......................... 9 REFERENCES ..............................................:............:.........:...:......:......:...... ....:.:......................14 QUALIFICATIONS .10 .......................................................................:..:........:..:. .........:....:........:.....16 11 PRESS RELEASE.. .... . ........................................ ................................. ......................:18 .... ` Con TrclenVd $pee. dc �k Inc. In: - . . Page 2d 18 Newport Beach Police Department Daily Field Activity and Criminal Information Analysis Project Objective Capture the information associated with each officer's daily activity and.integrate it with data contained in CAD and RMS. This will improve documentation and analytical capabilities, and in turn improve resource management (staffing and deployment) and policing strategies and tactkcs..(response and call management, problem. oriented policing, etc.). Comments /issues to be Addressed Daily Feld Activity Report (DEAR).— each officer is currently "required" to maintain a log of their daily activities on the DFAR (attached exhibit). The DFAR is maintained in a FileMaker application on each officer's PC. The individual DFAR's are printed out and forwarded to. the respective supervisors. Supervisors then roll the information contained in .the .individual DFAR's up into summary reports for analysis and resource management. o There is no central electronic repository for the information captured on the DFAR's. o There is no standard procedure for the officers to follow regarding how the information for the DFAR is captured/in put. Some officers maintain the DFAR as each daily activity is completed/cleared; others, wait until the end of the shift to fill in their recollection of the day's activities. o There is a perception among the officers that the DFAR is a waste of their time and does not provide.value. To the extent that current methods do not .change, this perception is likely to continue. o Consideration .is being given to having dispatch capture field, activity rather than having officers complete the DFAR:. This raises. other questions or challenges relating to communications workload, standing requirements, and potential concerns with accuracy of the data. • .There is inconsistency,or lack of standardization in reporting; final disposition or clearing activities with dispatch for entry into the CAD system. In addition, for approximately 12% of CAD entries, the dispatchers .over ride. the standard entry code.. Such inconsistencies in the CAD entries make it difficult to report, analyze and manage resources. • All incident reports are scanned and stored in P.DF format in a central repository. o ST could possibly OCR the pelf's to create a searchable text solution. Issue Solution Comment DFAR Repository Create a central repository for the May be able to take advantage of the DFAR'data FkleMaker format/application already established. Important to ensure that a UI is associated with each activity to link . DFAR.to'CAD and RMS data. No SOP for DFAR input Create and fix accountability for . Cultural/operational issue. Itis critical adherence to SOP's for DFAR that NBPD establish and adhere to . _. input operational SOP's in order to ensure that data is captured consistently. SOP's lacking ornotadhered Create. QC reports SOP Cultural/operational Issue. to for dispatch atch data entry standards for data entry SOP's lacking or not adhered Create QC reports. and fix Cultural/operationak issue. to for officers to clear responsibility/accountability for activities Ath dispatch SOP standards for officer to adhere to Unable.to search inci dent. OCR text pelf's for search solution Need to better understand this process reports and obtain a sample of scanned reports for tesVPOC. Confltlentiar .. Speedrrack. Inc. Page 3 of Is I General The Newport Beach Police Department is seeking an automated crime analysis program to'identily, analyze and communicate crime Patterns and trends easily and efficiently. This program will be used by the Newport Beach Police Department in conjunction with the Records Management System, Computer Aided Dispatch anti other FileMaker databases as necessary to create the Daily Activity Report. 2. Overview of the SpeedTrack Solution SpeedTrack's solutions are based on an innovative new technology called Guided Information Access (GIATu). GIA crime analytics.solutions were developed specifically for RMS and CAD and other criminal database. systems with the help of Long Beach Police. Department (the 51' largest police agency in California). The GIA platform recognizes every possible answer contained in .your data and allows the user to. intuitively navigate to the information that is most important to .them (think GPS for information):, There is. no wasted time searching through standard report sets, or making special requests, to IT analysts. For the,first time, decision makers can have. at their fingertips the information that is most important to them: SpeedTrack's crime analysis solutions are not intended to replace all of your current standard reports. They are designed specifically,, to provide the most advanced technology'.availabie to analyze, understand and get ahead of the key drivers of these trends. , "SpeedTrack's technology enables a level of information and data analysis which I had been seeking for over 20 years. Without question, this is the most cost effective and efficient technology available. One of the, best features. is, that SpeedTrack doesn't require the replacement of existing systems or databases, so :there is no disruption to ongoing operations:" Joseph Brann, Founding Director. Office of COPS, US Department of Justice 'Criminal Information Management System (CRIMeS) - Crime Analysis Solution CRIMeS is a simple; straightforward, innovative crime analysis and investigative software application which links data systems together. Onoe .CRiMS has associated Computer Aided Dispatch (CAD), Records Management System, (RMS), and other criminal databases then crime analysts, investigators, patrol officers. and command staff can intuitively identify and analyze patterns and relationships between calls, for service, people, incidents; vehicles, locations, MO's, etc. to solve crimes and establish prevention strategies. What patrol Officers; investigators, Analysts and Command Staff are able to do with CRIMeS Decision makers have at their fingertips an "n- dimensional" guided search capability of their data, with ability to associate detailed information, or even partial information such as: • Information. about people (by involvement) such as name, sex, DOB, age, race, height, weight, occupation, address, phone #, etc. Location :of . event such as street name and, number, type, state, county, city, zip code, zone; beat, etc. • Incident type; date; location by division, district, beat; method of entry; means of attack; crime class and charge. • Vehicle year, make, model, style; color, license plate, wildcard plate,z positional plate number, etc. • Call for Service analytics: Units on Scene, Response Times, Cost per Cali. . • Search of all free text fields, reports and remarks. In order to recognize the value created by the GIA platform, you must first appreciate the difference between data and information. Data is a string of characters that describe something: an address, a person, an incident, a modus operandi, etc. Data becomes information when it answers a question, or facilitates a decision. So Information is synonymous with answers. Traditional Approach Conventional :databases and applications are focused on storing data and providing fast linear text searches. They do not take into account the information within the data and so cannot provide user guidance to that information. In other words, conventional. solutions are designed to respond to questions using specific words, often unknown.to you. This approach requires that your 1. Formulate a question using the °right' words. 2. Search or query the data to determine if a match exists, hoping it answers your question (the equivalent to shooting arrows in the dark, hoping to hit something), or 3. Rely on pre - defined data summaries designed to produce predetermined types of answers (e.g., residential burglaries per quarter by region). As a result: 1. You can spend. valuable time searching for information that may not be in your data, or 2. You risk having'valuable: answers.go undetected by not asking the "right question 3.. The system will sometimes return massive result sets of thousands (or millions) of records, or sometimes return `nothing found" with no guidance on how to best refine the query. In short, you have no idea.what the range and breadth of answers are that exist in your data, must focus on asking the right questions, and cannot identify what you may be missing. You don't know what you don't know! GIA .GIA's primary focus is to show.you every answer that exists in your data, and_fet you decide what's important. GIA stores all of the associations that exist between the words and values of your data, and what they describe.. By capturing: the associations, GIA stores information (as opposed to just storing. data). Using this. approach, GIA identifies every, possible question that can be asked which has an answer contained in your data, and presents them to you in a dynamic interface. Rather than requiring you.to guess what information is available, or rely, on a set of predefined reports, GIA: 1. Presents you with lists of every unique word or value for every data field, document, or sentence in your data set. Then, 2. Narrows or expands the lists as you make selections from these words and values to reveal only words and values that are associated with your selections — guiding you to information with .100% contextual relevance. This occurs n- dimensionally across every data field, every document and every . sentence. You are essentially "navigating" your information, continuously making. new discoveries and expanding.. your knowledge.. . 2.1 .Analyze Data GIA. analytics solutions provide unparalleled ability to mine data and. indentify previously hidden information by allowing the user to navigate information from the RMS and CAD systems using any combination of dimensions contained in the data (spatial, temporal or statistical) to produce reports. In addition, calls for service and :incident dashboards are available for command staff to quickly assess activity., by call type, division, beat, address and response times. Finally,. custom filters are. easily created by the users enabling them to perform complex queries at the dick of a button.. conr¢1en6al .. SpeedTrwk, Inc. Page 5 d iS Z2 Assist in Communication GIA can push the results. of any Ad Hoc analysis to a standard report format; MS Excel, CSV file or mapping program. In addition, . because GIA provides information access to all levels of the organization in a user friendly intuitive manner, everyone throughout the organization can perform their own analyses and the amount of resources currently dedicated to. creating special reports can be significantly reduced. This access. to. information promotes a.level of critical thinking and problem oriented policing that is otherwise unattainable. " 3 SpeedTrack Software 3.1 Client Side Software The GIA. Client is a JAVA application that is downloaded on each PC using a Web Start page. The users go to an internal web page and click on ,a link to the application, which automatically downloads to the client's machine. Updates to the application are made each day when the users login into GIA. There are several different views. allowing the information to be displayed and analyzed in a variety of ways. Dynamic dashboard(s) provide a graphical representation of key data fields when trending and patter recognition is desired. The dashboards are dynamic in terms of allowing users to interact with the graphs, pie charts and lists of data to perform both canned and ad -hoc analysis and reports. • Faceted navigation displays a number of"data fields which show the interaction between the data values in each of the data fields. This is extremely valuable in learning inter - associated details about criminal activity which, cannot be found using traditional database queries and standard reporting programs. • Standardized data view is used when there are many data fields to be analyzed and .reported on (10's to 100's). 3.2. Server Side Software The GIA Server is a C ++ application that is run on a Windows web server. The. GIA CompStat Server stores "the metadata and text files required to perform all of the search, analytics and reporting queries received from the GIA CompStat Client. The GIA CompStat Server contains the metadata of the RMS and CAD systems. This is the equivalent of .what we call :the °Answer Cube ". The Answer Cube contains all of the possible pre - defined search and analysis combinations which are available from the data. The data is simply stored as text files on the server. This is exactly the opposite of a traditional relational database solution which only stores the data and then relies on the search queries on the data to determine if the question can be answered.- The Item Viewer reporting server is a JAVA application which handles the data-viewing, search query .data extraction and reporting functionality. It also.allows the user to export the data into Excel or CSV file formats. There is also a supporting auxiliary data server which handles miscellaneous functions to make the GIA CorripStat Server more efficient. Conf dermal SpeedTrack Inc. P8006 of 18 3.3 Download of Data Extraction Capabilities We have a data extractor which can extract all fields from all files designated, in a delimited text file forniatfor: • SQL • Oracle. • Access • Excel We can schedule this download for automatic updating and data refreshes. In addition, SpeedTracic has the ability to export data for use in other. applications. We can easily configure the data export and map to their data formatting requirements. 3.4 Data Management Abilities We have the capability and tools to handle and manipulate all forms of data from any source, provided that the data can be extracted and downloaded into any delimited text file format, namely; but not limited tos comma separated value, tab delimited or, pipe delimited format. 3.5 Spatial Analysis Capabilities Our solution allows the dataset from ANY of the standardized and,ad -hoc .queries to be mapped to Googte= Earth; Mierosoft rMaps_and any other mapping program available whose API is compatible with SpeedTracWs output capabilities. Spatial maps can be .done for any and all groupings of data to include but not limited to: • . Incident.types • Incident crime Gass categories, Type I, II, etc. • Geographic region o Council district o Beat and Reporting bistrict o Zip Code o Any other definable spatial group • Calls for Service o Call type o Call priority o Exact address, etc. These analyses can encompass any and all of the possibilities available in your data. . 3.6 CompStat Preparation. Techniques Almost all of the "CompStat" type of reports can be automatically generated by the SpeedTrack application and will not :require ANY user intervention to create:' As an additional feature we can have these reports automatically e- mailed to the analysts and other"management staff as requested. The differentiating advantage of the SpeedTrack application is that it allows the exploration (via intuitive ad -hoc queries) of the data in manner which will uncover significant and insightful information which we matriculate into a new series of needed reports and analysis: These reports can be configured by the Administrator and pushed out with a minimum of effort and expense. No. need to use third party reporting. tools such as Crystal Reports, Access, etc. ,Confidental - SpwdTraoI% Inc. _ _ - Page 7 of 18 3.7 Compatibility with Other Analytical Applications SpeedTrack can provide data output files in.a universal file format (CSV or XMQ which can be read into and used by any other program which can accept a delimited text file. . 3.8 Mapping Compatibility with Google Earth, ESRI, ArcGIS or Other Mapping.System Software See section 3.5 Spatial "Analysis Capabilities above. 4 Hardware /Software Requirements The following hardware and software is to be provided by the customer and is not priced in this order. We strongly recommend_ a dedicated server with only SpeedTrack GIA Server loaded. 4.1 Server Hardware • Minimum requirement (small size implementation): o One.or.more dual ;core Xeon processor (2 +GHz CPU speed). Slower CPU speed will reduce performance accordingly. . o . BGB of RAM for best performance and scalability. ' 0 250GB or 'more free space on.a hard drive. • Recommended requirement (medium size implementation):. o Two duat or one quad.core Xeon processors (2 +GHz'CPU speed). Slower CPU speed will reduoe.performance accordingly— C; BGB.or more of RAM for best performance and scalability. 0 50.OGB or more free space on a hard drive. • Optimal (larger size implementations): o Two or more quad core Xeon processors (2 +GHz CPU speed). Slower CPU speed will reduce performance accordingly.. o 16GB or more of RAM for best performance and scalability. o i TB or more free space on a hard drive. 4.2 Server Operating System Windows 2003 Standard or Enterprise Server, or XP Pro utilizing (IS. 4.3 PC Client Windows 2003 or XP Microsoft Internet Explorer 7.0 or higher Java 1.6 or higher Adobe Reader. MS. Office (Excel) or compatible system for viewing output data tables (optional) 2GB or more of RAM 4.4` Server Access SpeedTrack. requires direct VPN access to . the server for : implementation, .troubleshooting and maintenance activities. ConWental Speedfraek Inc. . Page 8 of 18' 5 Installation Process The physical installation of the application software. simply requires VPN access to the SpeedTrack server to download the program files. SpeedTrack then performs the basic tasks listed below as part of installation process. Some of.the integration /installation tasks which need to be performed are as follows: 1. Extract data from CAD and RMS in text file format (csv, pipe, or tab delimited). We can extract only the data fields. clef ined or extract all data fields which exist in each of the databases. We recommend extraction of all. data so we know what exists within each database. Each file from .each database will be kept separate and in its native extracted form. 2. Perform generic data cleansing. . 3. Analyze the data, including extraction of all unique data values for every file. 4. Create an overall 'vocabulary" for each field of data by combining the data values from the different databases, including :selection of data types, ranges and aggregations required. This is the, basic metadata.cloud from which the GIA server operates. 5. Create a list of synonyms for the vocabularies. 6. Define. and create the.vvarious:client GUI layouts, this involves defining which groupings of data are contained within each client GUL 7.. Define: layouts and create°, the necessary ,reports in conjunction with your Compstat requirements. B. Perform .veri ication and - alpha, beta and user acceptance testing prior to roll -out. Define administrative functions, user lists, passwords, and procedures for use. 9. Implement exception reporting for problems/bug fixes. 10. Implement auto data updates 6 . Implementation Schedule While timelines for implementations can vary., it is anticipatedahatwe will have a beta version for user testing. within: 60' days of. receipt of the data. SpeedTrack's believes in continuous process improvement and as such allows two such beta versions.to be tested before going live into production. 1. Meet with .customer' determine. details of the business requirements, establish critical success factors and identify /resolve. issues and agree• upon roles and responsibilities. Establish timelines for the tasks listed below based upon a detailed understanding of the end user requirements. 2. Review of the RMS, . CAD .and FileMaker .systems. and establish the most efficient data extraction methodology.' Discuss user habits and desires re: investigative and crime analysis capabilities desired of each system and for the combined data analysis capabilities. 3. Data Extract: Download the data to CSV, pipe. or tab delimited text files per SpeedTrack documentation. SpeedTrack has; its own data extractor for Oracle, SOIL and Access databases (others will be written as needed) and can be used to extract data for this.project. .4. Review Data Extracts: Receive and ,load data onto the GIA server. Verify the integrity of each file; check that the field.names, are in the first line and that the field values seem to match the field. names: Create exception; reports and notify :the customer of any discrepancies. Extract file ;and field names for all data. 5. Generic, Data Cleansing: Perform generic data cleansing to generate "clean" CSV files. Extract a sample of each file and check the cleaned data. :confidential �Speedrrack Inc. - Page 9 of 18 6. Thorough Data Analysis: Using our "HOAN" (hands off data analyzer) we thoroughly analyze the data on several dozen parameters which provides deep knowledge of the integrity and quality of the data. This includes the extraction of every unique data value from each field from each file in the project. This is unique to the SpeedTrack technology as these are the values from which our generalized vocabulary is built and becomes the basis for search and analysis parameters. 7. Selection of Data Fields and Data.Dictionary: Meet with the customer to determine /confirm the, field names, data values and meanings. Collection of all data conversion code tables. 8: Creation of customer Vocabulary:. In conjunction with the customer, create a vocabulary which wilt define the fields and data values to;be used for this. project as defined by the requirements developed at the kick -off meeting. .The vocabulary will be selected from the actual data values extracted from the databases. A list of privacy data will also be collected and used to prevent the display of these selected data field values. 9. Preparation of the Full. Authoring Process: Using the vocabulary, set up the required implementation runs to create the metadata:and the analysis matrix which contains the answers to all possible combinationsof,Boolean search queries available in the selectediields of data. Once this process is .completed, the resulting matrix will be the core of the implementation process. 10. Creation'of various levels.of data access: If necessary prepare the required number of "views" into -the. data to accommodate the desired levels of data sharing. . 11. Creation of the .GUI(s):: Starting with the basic GUI, create the set of tabs and selector groupings based upon the users <initial input and feedback. Edit the definition file with final adjustments and create the application configuration file. 1.2. Validation Testing-. Form a user.group to test the usability of the application, collect comments And recommendations: SpeedTrack will perform requirements validation. testing to ensure all requirements are met 13. Repeat process- to incorporate new data or requested changes. 7 Data Management and Storage Capabilities 7" i Product integration Capabilities for Extracting Data from RMS.and CAD Data is. downloaded on a set periodic basis and then uploaded and processed into the SpeedTrack data. integration server. The application will display the last time each of the various agencies has updatedr,theirdata into the system. If allowed;-we. can. perform thistunction on an automated basis, ,,either downloading changes to the, databases :(add, modify or deletes), or downloading the entire databases periodically, if practicable. 72 Data Storage Capabilities The individual RMS_and.CAD. flatfiles will,be stored on-.the GIA. Server, the data itself will be accessed through either the :Report_ Server..vla an existing report or directly from the client's machine using the Client JAVA application. The, user can select any and all items. of interest resulting from his set of . search criteria. The search result set is sent to the Data/Report Server from the Data Integration Server. confidential - SpeedTrack Inc. . Page ladle, The SpeedTrack solution provides for a relatively straightforward approach to integrating new data sources with each, new data source following the general process and the new "vocabulary" being added to the metadata cloud and associated to other data records which are relevant. The SpeedTrack technologies native ability to associate disparate data is paramount to why it can easily handle new data sources. 8 Other Services and Support 8.1. Training Plan SpeedTrack employs the 'train the trainer' concept, once acceptance testing is completed. Users are typically trained in a 30 minute class which consists of a short functionality walkthrough, .then several example searches which demonstrate the features. Training materials will be developed as required. SpeedTrack will hold the number of required classes during acceptance testing to ensure that the users, and administrators are qualified to use the system. SpeedTrack will create materials for train the trainer sessions (materials, local in -office training, and remote training via GoToMeeting). Create training documentation for each implementation • Training materials will be located in the Help menu Conduct.a "train the trainer" session;, ih -office for local end users, or GoToMeeting for remote . end users 8.2 Security Measures This application runs within the customer firewall, so secure access to the application is similar -to running other applications. within your protected environment. ;SpeedTrack has internal security measures which provide for using Active Directory to setup individual user names and passwords R desired; onto gran(. applicat(on access.Once the user is. ogged on. A unique capability SpeedTrack has is that 'it can create different 'views. into the data which can restrict access to administer defined data fields. 8.3 Support, Maintenance and Product Updates ,For the purposes.of, this. engagement, the annual software license. fee will be fixed for the first three years. The annual;:software license includesdechnical support services for software products licensed from SpeedTrack (the °Products'), maintenance..and support, and free.product updates (as such term is defined in the Software License. Agreement between the customer. and`SpeedTrack). Under I this proposal, ,SpeedTrack will provide all support necessary to deliver a stable and fully operational system:to satisfy the customer in meeting agreed upon project goals. Support services include' answering questions with regard to the operation. of the software and troubleshooting-Support services.do not:inctude services which, in the.usual course of SpeedTrack's business are. provided; to.. customers as consulting. sendces: An. example of consulting services may include, but are not limited to custom application development, data warehouse design, requirements analysis, and/or database design tasks that are. not:specificatly included. in the scope of the project. Ongoing technical support isprovided as long as the annual subscription license is paid in full and is still in force. ' con8dentlal Speedttack Im _ Page 71 of 18 . _ _ 8.3.1 .Technical Support SpeedTrack's Technical Support staff is committed to responding to and resolving customer issues in a manner which. satisfies our customers. The objectives of Technical Support are the following: • Keeping customers informed of the status of their issues as those issues are being resolved. • Keeping customers informed of the status of upcoming production releases and maintenance versions. Providing customers with a mechanism for escalating issues. . Our policy is to meet the following response objectives: • Answering .customer contacts..d'ireeby, whenever.posslle; otherwise, acknowledging all contacts within four business hours. ! Responding to each issue immediately whenever possible; and, otherwise, responding to the customer within one business day, with details on Speegrack's progress in resolving the issue and/or intended plan of action. •.. �Nofrfying each customer within- one:: business day when the status of any of the customer's feature . request or, ongoing issue .changes, or when a fix for any of the customer's issue. or fieature..request is ready in a new version of the software. • Consider an'issue to be resolved only.when the customer . understands and agrees with the actions that have been taken and the consequences of those actions. Telephone support from the United States office may be obtained by a Customer's Support Liaison (as defined below) in the following ways: + Phone:' (858) 481 -7199 7 :30 a.m. - 6:00 p.m. PST; Monday through Friday on non- holidays • Fax: (714) 693 -2954 • E -mail: support@speedtrack.com • Message: (858)481-7199 it ;a customer is unable to reach SpeedTrack Technical Support by phone, a voice mail message may be left. When leaving -a voice. trail message, the following information should be provided: ,Name • -Company • Phone Number • Fax number (if applicable) • E-mail address • SpeedTrack software product(s),:including software version and product registration number(s) The specific issuelrequestat hand Upon logging an issue,. the Customer's Support Liaison will receive an issue identification number for future reference: A "Support Liaison" is: defined as a person,whom.;the Customer has:designated as a point-of-contact with SpeeclTrack's support personnel. The Customer must designate a`single employee to serve as the Support Liaison. The Customer.may,change its,Support Liaison on occasion, if necessary, so long as it provides written.notice .to SpeedTrack of such change. ...Confidental SpeWrwk, Ina Page 12 of 18 8.3.2 Prioritization of Issues Priority levels are assigned to each issue during the initial call, whenever possible. Our objective is to assign a prioritization level to all issues within one business day. These prioritization levels are used to ensure that important issues are resolved quickly and determine the escalation procedures for an issue. Priority 1: A production system is down or severely impacted as a result of a SpeedTrack software product. Examples include, general. protection . faults (crashes), corrupted or incorrect . data, or connection problems due to the software. Priority 2: Customer has a serious issue with a feature necessary to its work for which it has discovered no work - around and which completely prevents the feature from being used. Priority, 3:. Customer has•a serious issue with a feature for which aWork -around exists, a minor issue with a feature for which no work - around exists or a critical usage question. Priority 4: Customer has a minor issue with. a feature for which a work - around exists,. a usage question or.a high- priority enhancement. request. Priority 5: Customer has a minor question, issue or enhancement request. 8.3.3 Support Escalation Procedures SpeedTrack: Technical Support will attempt to resolve, as quickly as possible, all technical support issues and. questions regarding the products. However,, if the customer is not satisfied with the :responsiveness or the quality of the support received, the customer may indicate a desire to escalate the priority level of an issue. if:the customer is.not satisfied with the response of SpeedTrack Technical Support Person handling the ..Eechnical issue, then the first level of escalation will be to contact: Dr. Jerzy'Lewak Chief Technology Officer, SpeedTrack Ph:(850) 481 -1584 e -mail: jefzy@spee!dtrack.com speedtrack.com 1f -tie customer Js still not satisfied with the response. of SpeedTrack in handling the technical issue, then. the second level of escalation will be to contact: Miles Yano: Chief Executive Officer, SpeedTrack Ph:(714) 693 -7289. e -mail: miles@speedtrack com Customer may request.esi- alation of an issue to a higher:priority level by calling the support line and asking to discuss the matter with the Chief Technology Officer. 8.4 Product upgrades - Technical Support includes free product updates .(as. such term is defined in the Software License Agreement between the customer and SpeedTrack). - Cunfldental .. SpeedTrack, Inc. Page 13 of 18 9 References Long Beach Police Department Detective Richard Bell (562) 570 -7065 Long Beach, California ,. 900+ sworn officers Detective Richard Bell oversees. our Criminal .Information Management System .(CRIMeS) currently in use at the Long Beach Police Department (LBPD). SpeedTrack's CRIMeS application has been live at Long Beach since early in 2002 and provides ad -hoc investigative and crime analysis capability for all the Tiburon RMS data and is integrated with the City parking .rotation database as well. The current CRIMeS application has produced'excellent results and has helped solve several major cases: Currently the system satisfies the majority of the data extraction, integration, search and analysis requirements of any. police department/service project within the department. All Command Staff, Patrol, Investigators,. Detectives and Crime Analysts have access to use: CRIMeS once they complete the 30- minute training session. CRIMeS training has been given t4 a majority of the:LBPD staff and classes are ongoing on a continual basis according to the:nee.ds of the.Long Beach Police Department. CRIMeS is a stand -alone client server architecture, accessed using a browser (JAVA application). CRIMeS extracts the raw data in text format from the Tiburon server, then processes: it to provide full analysis capability on all client specified fields such as:..: It is also integrated with the City's parking citation data, which comes from a legacy database. The resulting rnetadata is, stored on the SpeedTrack CRIMeS TIE Server. Our. SpeedTrack TIE -Server application automatically performs complex analytics such as dynamically displaying the number of records which contain a•.certain .data set of categories and simultaneously displays the remaining associated categories and their frequency of occurrence. At the same time, the application ;computes and displays the population of records (titles only) after each category selection. The user has the ability to. generate complex Boolean queries (both conjunctive and disjunctive) by simply selecting the desired categories while simultaneously seeing which data categories are available and the associated remaining items. ALL queries from every CRIMeS implementation will return a .positive result. There is no guessing as. the user is. displayed with choices Arid all remaining values to further refine theirsearch. Project Background: SpeedTrack has been. working with the Long Beach Police Department (LBPD) since mid- June 2001 developing Criminal Information. Management, System, (CRIMeS), utilizing, its patented data integration/database technology to provide powerful ad -hoc querying, data analytics and data mining capability o departments and, the; personnel who: need that data,without requiring.. special technical skills. I CRIMeS integrates information from multiple disparate databases and displays the information to the user via a; graphical user interface. (GUQ. This : makes the system intuitive and effective in confidential Speedkack inc• Page U d IS Persons :. • Vehicles • incidents • Citations • Addresses • Geographic locations • Phone numbers • MO's It is also integrated with the City's parking citation data, which comes from a legacy database. The resulting rnetadata is, stored on the SpeedTrack CRIMeS TIE Server. Our. SpeedTrack TIE -Server application automatically performs complex analytics such as dynamically displaying the number of records which contain a•.certain .data set of categories and simultaneously displays the remaining associated categories and their frequency of occurrence. At the same time, the application ;computes and displays the population of records (titles only) after each category selection. The user has the ability to. generate complex Boolean queries (both conjunctive and disjunctive) by simply selecting the desired categories while simultaneously seeing which data categories are available and the associated remaining items. ALL queries from every CRIMeS implementation will return a .positive result. There is no guessing as. the user is. displayed with choices Arid all remaining values to further refine theirsearch. Project Background: SpeedTrack has been. working with the Long Beach Police Department (LBPD) since mid- June 2001 developing Criminal Information. Management, System, (CRIMeS), utilizing, its patented data integration/database technology to provide powerful ad -hoc querying, data analytics and data mining capability o departments and, the; personnel who: need that data,without requiring.. special technical skills. I CRIMeS integrates information from multiple disparate databases and displays the information to the user via a; graphical user interface. (GUQ. This : makes the system intuitive and effective in confidential Speedkack inc• Page U d IS performing investigative tasks by iterative analysis of data, and provides rapid response to a near unlimited variety of queries. All Officers (users) can be experts, able to generate complex Boolean queries and basic data analytics by simply pointing and clicking on the categories of interest. Initially.LBPD provided SpeedTrack with data from. their citations, vehicles, property, bookings, persons and main: incident tables. The total number of records was 450000. Our GUI provides a simple view into ail of the available. data. The user simply selects the data categories they want integrated, in any order, for any range of values and instantly the population is reduced to just the associated records and remaining category choices. This allows the intuitive navigation of huge amounts of data within seconds, and transforms the average computer user into a powerful data miner, simply by clicking the mouse:. This phase of the project from data availability to SpeedTrack to first beta version took approximately eight weeks. The rest of the time was for the SpeedTrack team to become familiar with the terminology and to. conduct user interviews to formulate the initial GUI. The production version of CRIMeS at LBPD:is fully functional and has over 4.5MM incidents from RMS, ,integrated to include data on persons, citations, vehicles, bookings, incidents, MO's, addresses, phone numbers and crime class, information. The -user response has. been outstanding with several officers interviewed stating that.with this technology they could: reduce their data analysis time nearly an order of magnitude and. can perform ad -hoc queries not previously available. We have implemented an automated weekly update ' feature and are working,on a,daily update process. We have also integrated Long_ Beach City's parking citation database into CRIMeS for a more comprehensive view into criminal activity. Durham Regional police Department Christine Robson, Manager Information Technology (905) 579 - 1520 x3318 Ontario Canada 839 sworn officers SpeedTrack CRIMES application has been in production with front line officers and Crime Analysts at Durham Regional Police Department since.late 2003 The CRIMeS implementation is similar to the one used for Long Beach. Police Department with the exception that. an implementation is being done for CAD, two RMS systems (legacy PRO and new Versadex) and a field reporting system (Direct Entry, home grown system) ::We implemented each system individually and integrated the individual systems when the:customer requiredthe capability. The.CAD and:RMS systems are Northrop Grumman, PRO, and the Field Reporting System is home grown and feedsahe RMS system. CRIMeS is a stand -alone client. server architecture, accessed -using a browser (JAVA application). CRIMeS extracts the raw data in text format from the PRC server and field reporting server and then processes.it to provide full analysis capability on all client specified fields re: persons, vehicles, incidents, citations, addresses, geographic locations, phone numbers, MO's, report narratives, etc. The CRIMeS implementations for Durham,s crime.analysts have been extreme. For their Direct Entry system they wanted every field of data to be available for search. We were able to accommodate this with our -system. What does available mean? For each field of data, we show the user every unique field value; then associate each field value with every.other value: from every other field in.the database. This represents for .Direct Entry over. 700,000 different data.values, which are associated, with each. other and can be analyzed in a pure ad -hoc. fashion. For a typical relational database system,. this would mean that they would have had to index every data value within their database and to build relationships with every other record and value, which is neither practical nor: cost effective. We have; done nearly the same for. CAD and RMS. Our system eliminates this time consuming and expensive step. We also made available the extensive vocabulary in the narrative reports contained in the databases. The result is a very intuitive and easy way to search multiple narratives to find records /reports; which contain the Words you are seeking.. _Confidential .. Speedrrwk, Inc. - Page 15 of 18 . After several iterations we have narrowed the number of fields down to a more manageable level post implementation vs. several hundred at the initial project start, Project Background: SpeedTrack has been working with the Durham Police Department (DPD) to implement CR(MeS, utilizing its patented data integration/database technology to provide powerful adhoc querying, data analytics and data. mining capability to the officers. This makes the system intuitive and effective in performing. investigative tasks by iterative analysis of data; and provides rapid response to a near unlimited variety of queries.. All Officers (users). can be experts, able to generate complex Boolean queries and basic data analytics by simply pointing and clicking on their categories of interest. Durham RMS and CAD isl a Northrop Grumman PRC system. Durham had, recently. changed vendors to Versadex CAD and RMS system.' They will be exporting the Versadex CAD and RMS data "to text files and then. will continue to. utilize the SpeedTrack CRIMeS.application to perform the required ad- hoc queries and reports._ Additionally, CRIMeS will bridge between.the historical CAD and RMS system Jo the new CAD. and RMS system; thereby allowing.the users total transparency for searches regarding all stored criminal information. York Regional Police Department Ron Huber, Manager information Technology (905) 830 -0303 x7948 Ontario Canada 978 sworn officers At. York Regional Police. Department, SpeedTrack implemented the CRIMeS application for its legacy PRC: RMS and CAD system; .allowing York to reduce their dependency on the old system. They will eventuallybe able to turn off the legacy "sewers and still be able to get access to and perform searches critical to -Calls for service as well as criminal: investigations. the same CRIMeS system was implemented for the new, Versadex RMS system providing additional and powerful search capabilities to investigators front line; and crime analysts. Additional services and capabilities were added, such as legacy record "editing; posting of legacy data to Canada!s PIP system. This is similar to what was done for Durham and what will also be done for Niagara in. the very near future. Please see the description for Durham above.as the jobs were virtually identical in nature arid scope. 10 Qualifications SpeedTrack Company Overview . SpeedTrack, Inc: is. a California Corporation formed." in July 1999, with the mission of making integrating, accessing and analyzing digital information fnU ve, flexible and affordable. The corporate. `office is. located in Del. Mar, California. Our passion is helping clients "get to the information." SpeedTrack: has developed and been granted several patents for an entirely new way to integrate, navigate access manage, analyze and view electronic information. Created from a user's perspective, SpeedTrack's patented "Technology Information Engineering" (TIE), reduces the cost of integrating and transforming digital data into •usable . inforittation:. by an order of magnitude, while increasing performance 10X. We have developed a software platform based on _TIE that we refer to as-Guided Information. Access, or GIA. The;GIA platform dramatically outperforms traditional relational database architectures and technology in terms of cost, time, effort, ease'of use and efficiency. In addition, GIA allows users to store, "access, analyze and report on both structured and unstructured data. Data is. integrated and associated from multiple data sources .,such that search, OLAP, knowledge management; business intelligence and business anaiytic .applications can be .deployed without disturbing-the existing applications or databases. Confidential "SpeedTrack, Inc: Page 16 of 18 Team Bio's Inventor and Co- Founder, Jerry Lewak, Ph.D. Jerzy oversees all technical aspects of $peedTrack, leading the activities in produc t.development, R &D and Intellectual Property. He is the principal inventor of the Guided Information Access Platform (GIA). Jerzy has developed over a dozen consumer software products including one of the leading word processing applications for the MAC; NISUS WRITER, currently. used in 80 countries. He has been President and founder of Nisus Software for 24 years, developing software products for the Mac. and Windows operating systems: Dr. Lewak is a professor emeritus from the University of Califomia at San Diego where he taught Electrical and Computer Engineering for 25 years. Dr. .Lewak .received his BS and Ph.D. in Theoretical. Physics from the University of Manchester, England, and holds multiple software patents. Co- Founder, Chairman and CEO, Miles Yano Miles co4ounded.SpeedTrack in. 1999. He functions as playerkoach for SpeedTrack, responsible for general management. and operations of the company. Additionally, Miles has assembled the patent litigation and licensing team to spearhead infringement activities. Miles is also the oo-inventor of two SpeedTrack.granted patents and two patents pending. Prior to SpeedTrack, Miles' engineering background. includes 'i7 years of aerospace, advanced telecommunication satellite design and project management experience.. While at Rockwell International, Miles was twice nominated for Engineer of the Year for his design and advanced research projects. As VP. Business. Development for Irvin Industries. he helped double sales. As an entrepreneur, Miles has been involved in two high -tech start -ups. Miles .earned :his BS. in Mechanical Engineering from the. University of Hawaii and his MS in Engineering Management from the University of Santa Clara. Strategic Development, Jeff Pratt Jeff directs business strategy.: for SpeedTrack, and was responsible for acquiring the company's first commercial client. Jeff's. background includes over 20 years of risk.management experience with publicly traded financial institutions: Jeff has a reputation for innovative solutions to problems that range from designing and implementing database systems_ for asset management, to the design and construction of an isolation table for microscopy (used in Cal Tech's Developmental Biology Department). Jeff earned.a BS in Biological Science from the University of California at Irvine, and his MBA from UCI's Merage School of Business. Chief Financial Officer, Dennis Lee Dennis is an accomplished financial professional. with more than 30 years of proven.experience with rapidly growing companies. Dennis is currently CFO for Health Research Association, a $15M year clinical trials management company. Formerly. CFO for DevelopMentor; a. leading edge software training company for corporations, he. led a company workout(tumaround. Dennis has extensive start- up experience as.a CFO for ETM, an entertainment ticketing.eompany, where he oversaw 5 rounds of venture funding ($80MM raised) and helped manage the company through the tough growth phases of $0430MM revenue and 200 employees. Dennis is a• licensed CPA. and received his BS in Business Administration from the University of California at Berkeley. Joseph>Br inn— Joseph Brann & Associates Joseph Brann is the founder and President of Joseph Brann & Associates. The firm specializes in the public safety arena, with a particular focus on improving managerial performance.and.accountabiiity, in police organizations and evaluating organizational and executive_ performance. From 1994 to 1999, he served as.the founding. Director and led the development of the Office of Community Oriented Policing Confidential SpeedTrack Inc. Page 17 of 18 Services (COPS) in the U. S. Department of Justice. He was appointed by President Clinton to head that agency following passage of the 1994. Crime Act. legislation. The COPS Office was responsible for advancing, community policing throughout the country by funding and redeploying over 100,000 police officers. Director Brann built this new agency to be responsive to and supportive of local government, resulting in a national reputation for delivering quality customer service ;. Joe holds a Bachelor's degree in. Criminal Justice from California State University, Fullerton, a Master of Public Administration degree from the University of Southern California and is a'graduate of the FBI National Academy. 11 Press Release SpeedTrack, Inc. forms Strategic Alliance with Joseph Brann & Associates. Yorba Linda, Calif. (September 28, 2009) SpeedTrack, Inc. and Joseph. Brann and Associates (JBA) have formed a strategic alliance to bring to market the most powerful and efficient solution for managing resources and improving performance for Public Safety and Law Enforcement agencies. "SpeedTrack's technology enables :a level of information and data analysis which 1 had been seeking for over 20 years," said Joe. Brann. "Without question, this is the most cost effective and efficient technology available: One of the best features. is that SpeedTrack doesn't require the replacement of existing systems or databases, so there is -no disruption to ongoing operations." SpeedTrack is excited to be teaming up with one of the Top Cops in law enforcement "Joe's expertise coupled with our ability.to cost effectively integrate, search, analyze and report information is a game changer, ". said Miles Yano, CEO of SpeedTrack: SpeedTrack shares JBA's goal of providing. a complete systemic . solution for Law Enforcement and. City Govemments to enable efficient management of resources, improved productivity and reduced risk at an affordable price. About Joseph Brann and Associates JBA is a California firm headquartered in, the greater Los Angeles area. Established in 2000 JBA works with Law Enforcement and Public Safety agencies to. improve management accountability and organizational performance. Mr. Brann has had a distinguished government career at both, the local and federal level. In 1994 he was appointed by President Clinton create and head a new federal agency, the Office of Community Oriented, Policing Services. _(COPS Office), in the U. S. Department of Justice. That agency has provided.:more than $10 billion in; grants to over 13,000 law enforcement agencies to support and advance community policing throughout the country. About SpeedlTrack, Inc. SpeedTrack's Guided Information Access (GIA) software platform is spawning a new generation of information technology. Founded in 1M.by UCSD Professor Emeritus Jerzy Lewak and entrepreneur Miles Yano, SpeedTrack is the leading developer of next generation faceted search and navigation technologies.: SpeedTraek's patented innovations improve information access for. GPS navigation devices,. Business Intelligence solutions, eDiscovery and Search applications. SpeedTrack is headquartered inYorba Linda, California. For more information;`visit www.speedtrack.com. ConfidenUai . Speeffrack fm. - page 18 of 18 SpeedTrack, Inc. Newport Beach Police Departrnent Quotation CAD, RMS and IA.as Initi61Databases Wall a am MEW "plementation Fee (includes.programming required for . DFAR). $100;000 orignal cost - 67.6% reduction $32,500.00 Annual License Fee, Year 2 and, beyond we include 100 hours of implementation tithe to add in new data. 17:5% of total project cost. $17,500.00 117,500.00 $17,500.00 Total CRIMeS + DFAR Solutions $50 000.00 $17,500.00 $17,500.00 Totals $501000.00 $17 1. Initial kick -off upon your receipt of all out data: Annual License Fee; +'113 of Implementation, progra 2. At Beta, 30 days after project start: 1/3 of Implementation, programming and set -up = 10,833 3. In Production, 30 days after Beta: final 1/3 of Implementation, programming' and set -up =10,893 Notes This quote is valid until January 31, 2003. Service, Maintenance and Upgrades fee is waived in lieu of additional implementation hours for future add -ons Hartford, Bill From: Miles Yano [miles @speedtrack.comi Sent: Saturday, January 16, 2010 7:52 AM To: Hartford, Bill Cc: Haro, Suzanne Subject: RE: SpeedTrack Scope of Work document OK. You have my permission to go ahead and use it. Best, Miles Yano, CEO /Co- founder SpeedTrack, Inc. www.speedtrack.com ph: 714.693.7289 fax: 714.693.2954 Confidentiality Notice: This communication, and any files attached, contains confidential information that may be privileged. The information is intended only for the use of the individual(s) or entity to which it is addressed. If you are not the intended recipient, any disclosure, distribution or the taking of any action in reliance upon this communication is prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately by reply e -mail and destroy the original information. Thank you. From: Hartford, Bill [mailto:BHartford @nbpd.org] Sent: Friday, January 15, 2010 5:09 PM To: Miles Yano Cc: Haro, Suzanne Subject: RE: SpeedTrack Scope of Work document Miles, the scope of work will be part of the council package and therefore a public document that if your competitors go looking for it they will find it. Please let me know, Bill From: Miles Yano [mailto:miles @speedtrack.com] Sent: Friday, January 15, 2010 5:07 PM To: Hartford, Bill Cc: Haro, Suzanne Subject: RE: SpeedTrack Scope of Work document Lill! Sorry about that you have permission to share this document with anyone with the need to know re: the project or with the city for use in procurement activities. Just not for public dissemination like to our competitors. Obviously the price will be made public. Best, Miles Yano, CEO/Co-founder SpeedTrack, Inc. www.speedtrack.com ph: 714.693.7289 fax: 714.693.2954 Confidentiality Notice: This communication, and any files attached, contains confidential information that may be privileged. The information is intended only for the use of the individual(s) or entity to which it is addressed. If you are not the intended recipient, any disclosure, distribution or the taking of any action in reliance upon this communication is prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately by reply e-mail and destroy the original information. Thank you. From: Hartford, Bill [mailto:BHartford @nbpd.org] Sent: Friday, January 15; 20104:55 PM To: Miles Yano Cc: Hare, Suzanne Subject: SpeedTrack Scope of Work document Miles, I. received, an email from the Office of the City Attorney expressing their concern with utilizing your "scope of work" document due to the fact you have classified the documents as "confidential." I will need you to send me an email giving me permission to present this document to our City Council as an exhibit to my staff report. As such, the scope of work document does become public record. I need your permission email by Tuesday, January 19'h. Thanks, Bill Lieutenant William S. Hartford Support Service Commander Newport Beach Police Department bhartford(anbyd.or� 949.644.3660