Georgia Bureau of Investigation September Monthly Report FY2013 Presented to the Board of Public Safety November 8, 2012 Vernon M. Keenan Director Table of Contents I. Staffing and Backlog................................. 3 - 4 II. Administration Office of Privacy & Compliance/Open Records Personnel Staff Services........................................... 5 III. Investigative Division.................................. 6 - 8 IV. Crime Lab.............................................. 9 - 11 V. Georgia Crime Information Center................. 12 - 16 2 Vacant State Positions FY2013 Total Vacant Positions in DOFS Vacant Scientist Positions Total Vacant Positions in GCIC Total Vacant Positions in Admin Vacant Sworn Agent Positions Total Vacant Positions In the Investigative Division Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May July 36 25 27 25 15 15 12 3 44 4 19 20 20 30 31 30 3 DOFS Backlog Chart Unworked Cases over 30 Days Old FY2013 Discipline Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Chemistry 1,487 1,226 2,230 Firearms 1,231 1,200 1,176 Forensic Biology 949 743 806 Latent Fingerprints 1,081 1,066 1,127 Medical Examiners 127 109 110 Miscellaneous Services 1 1 1 Questioned Docs/Photography 312 313 310 Toxicology 942 1,070 908 Trace Evidence 200 181 160 Total 6,330 5,909 6,828 4 GBI Administration Office of Privacy & Compliance/Open Records Open Records Request Archives September 2012 243 45 Total FY2013 784 108 Personnel Employee Totals Investigative Division Georgia Crime Information Center Division of Forensic Sciences Administration Bureau Total *Vacancies are State Funded Positions September 2012 Positions State Funded Grant Funded 325 38 91 10 282 30 45 1 743 79 Total 363 101 312 46 822 Current Vacancies* 30 3 27 4 64 5 INVESTIGATIVE DIVISION September 2012 Fiscal YTD Total Sworn Employees 250 (filled-includes grant) Total Investigative Hours Expended 25,652.45 86,374.20 Crimes Against Persons, includes Death Investigations Child Abuse Sex Crimes Missing Persons Assault, Kidnapping, Robbery, Terrorist Acts, Fugitive, Human Trafficking, etc. 8,748.45 4,643.50 1,482.45 558.00 106.00 1,958.50 27,991.45 14,297.50 5,825.45 1,401.00 254.00 6,213.50 Property Crimes, including Theft, Burglary, Forgery 2,269.50 8,239.25 Drug Investigations 6,644.00 22,564.00 Meth Lab Investigations 258.00 767.00 Polygraph Examinations 893.00 3,113.00 Background Investigations 191.00 384.00 Other Investigations, including Preliminary Investigations 3,235.00 11,992.50 Bomb Disposal Services 1,032.00 2,987.00 Crime Analysis 27.50 98.00 Crime Scene Specialists 2,354.00 8,238.00 All figures above represent Investigative Hours Total Seizures $50,312,876.00 $143,064,273.00 6 Investigative Hours Expended YTD FY2013 Bomb Disposal Services 3% Other Investigations 15% Crime Analysis >1% Crime Scene Specialists 10% Crimes Against Persons 32% Background Investigations >1% Polygraph Examinations 4% Meth Lab Investigations >1% Drug Investigations 26% Property Crimes 10% 7 Meth Lab Waste Disposal Grant Total amount of grant beginning February 2012: $401,000.00 Total expended through September 2012: $372,747.00 Total remaining: $28,253.00 Total Expended in September 2012: $34,320.00 $6,000.00 Meth Lab Waste Disposal Grant Expenditures By County September 2012 $5,000.00 $4,000.00 $4,565.00 $4,415.00 $3,805.00 $5,027.50 $4,205.00 $3,000.00 $3,027.50 $2,000.00 $1,640.00 $2,102.50 $1,327.50 $2,102.50 $2,102.50 $1,000.00 $0.00 Brantley Bryan Coffee Forsyth Glynn Irwin Madison Pierce Screven Thomas Ware 8 Crime Lab Medical Examiners (includes all laboratories) September 2012 FY2013 YTD Autopsies Consultations Anthropology Total ME Cases Managed 263 807 102 355 0 0 365 1,162 Clayton County Death Certificates 35 116 Medical Examiner Activity, FY2013 Consultations 34% Anthropology >1% Autopsies 66% Confirmed CODIS Hits for September 2012 Samples entered into CODIS for September 2012 State Offender Hits 41 State Forensic Hits 5 National Offender Hits 10 National Forensic Hits 1 Total 57 Headquarters Cleveland Savannah Total 61 1,458 18 1,537 Profiles in CODIS Forensic Casework Profiles Convicted Offender Profiles Missing Person/Unidentified Human Remain Profiles Total 12,840 245,644 15 258,499 9 Laboratory Production Case Turnaround for September 2012 Laboratory Headquarters - Atlanta Central Regional - Macon Coastal Regional - Savannah Eastern Regional - Augusta Northeastern Regional Southwestern Regional - Moultrie Western Regional - Columbus # Released Total % Released in in 45 Days Released 45 Days 1,722 3,017 57% 76 92 83% 223 326 68% 235 307 77% 1,603 1,690 95% 179 215 83% 216 269 80% System-wide Totals 4,254 5,916 72% Note: 84.4% Casework Reports were released within 90 days. Case Turnaround for Year-to-Date, FY2013 Laboratory Headquarters - Atlanta Central Regional - Macon Coastal Regional - Savannah Eastern Regional - Augusta Northeastern Regional Southwestern Regional - Moultrie Western Regional - Columbus # Released Total % Released in in 45 Days Released 45 Days 7,190 11,383 63% 317 440 72% 825 1,311 63% 702 1,002 70% 5,135 5,793 89% 513 702 73% 614 810 76% System-wide Totals 15,296 21,441 71% 10 Crime Laboratory Cases Processed for September 2012 Department Requested Total Released Chemistry (includes Drug ID) Firearms Forensic Biology Latent Prints Medical Examiners Questioned Documents Toxicology Trace Evidence 1,886 193 2,315 164 365 8 1,923 92 1,465 174 2,109 141 302 2 1,949 76 Total 6,946 6,218 Crime Laboratory Cases Processed FY2013 Department Requested Total Released Chemistry (includes Drug ID) Firearms Forensic Biology Latent Prints Medical Examiners Questioned Documents Toxicology Trace Evidence 6,757 1,540 7,277 538 1,173 14 6,035 234 5,843 2,070 6,901 441 1,069 3 5,955 228 Total 23,568 22,510 11 Georgia Crime Information Center SEPTEMBER 2012 1. SYSTEM AVAILABILITY: Max Hours Possible for Month Downtime (Hours) Degraded (Hours) Percent Available for Month AFIS 744.00 Enterprise GoNET/ Network 2200 Infrastructure 744.00 744.00 IBM System 744.00 3.25 13.25 0.00 13.50 0.00 0.00 0.00 0.00 99.56% 98.22% 100% 98.19% NCIC Files 744.00 9.00 0.00 98.79% NICS NLETS 744.00 9.00 0.00 98.79% 744.00 3.00 0.00 99.60% 2. AUDITS: During the reporting month there were 20 full service audits conducted. There were 8 on-site audits conducted for agencies obtaining "inquiry only" from the CJIS network; 9 criminal justice E-Audits; 31 non-criminal justice audits. The total number of audits conducted during FY2013: 167. 3. TRAINING: GCIC personnel provided 304.75 hours of training to 1,779 criminal justice agency employees during the month. 4. AFIS REPLACEMENT Project Description: GCIC is replacing the Georgia Bureau of Investigation's 22 year old Automated Fingerprint Identification System (AFIS). The AFIS replacement enhances fingerprint identification services to permit identification of criminals more rapidly through the use of state of the art alternative search methods and information sharing. Monthly Update: Weekly AFIS Replacement Project Manager and Monthly Executive status meetings are held to assure that the project remains on track. On September 25th the Reliability testing phase began. Reliability testing runs consecutively for two weeks. 5. SEX OFFENDER REGISTRY RE-DESIGN PROJECT Project Description: Georgia's Sex Offender Registry (SOR) was created in 1996 and the purpose of the SOR is to provide law enforcement with an efficient and effective method of monitoring sex offenders. In 2010, the Georgia Department of Audits and Accounts Performance Audit Operations conducted an audit on the Georgia SOR and their findings indicated that the SOR is an outdated and inflexible computer system; the registry does not fully meet the needs of law enforcement monitoring and investigating sex offenders and that the public website should provide more complete and accurate information. The information contained in the audit validated issues GBI had noted for some time regarding the need to improve and modernize the SOR. To remedy the current database limitations, the Georgia Bureau of Investigation (GBI) seeks to modernize and replace the SOR using web technologies, which will allow GBI to accommodate requests from sheriffs and other customers. Moving to web technologies will ensure greater flexibility for the State to incorporate future updates or enhancements as dictated by state or federal legislation, operational needs, or public demands. Increased 12 capabilities would also allow the sex offender database to link to other databases to help improve record accuracy or offender tracking, such as address verification or developing a link with the Department of Corrections for information on re-incarceration of offenders. Offender images would be stored in a format allowing sharing with the Federal Bureau of Investigation's (FBI) National Crime Information Center (NCIC) Convicted Sex Offender File for use by all criminal justice agencies throughout the United States. Access to the public registry would be real time instead of 24 hours old as with the current process of providing a daily update for public web presentation. Monthly Update: The integration of web services through LEMS/JX to allow SORT to connect to the National Crime Information Center (NCIC) is delayed by the contracted vendor (Unisys). This delay changed the scheduled operational date to October 15, 2012. User Acceptance Testing (UAT) for the SORT system continues. The Change-Over process to move sex offender data from the existing Legacy system to the new SORT system was moved to October 2, 2012. At this time, the users will be notified with a broadcast message that the Sex Offender Registry will be in inquiry/read-only status until the change-over is completed. The scheduled date of operation for the SORT system is Monday, October 15, 2012 The following tasks are pending completion before change-over begins: Completion of the webservices connection between SORT and LEMS/JX Electronic submission of SORT transactions to NCIC 6. SERVER CONSOLIDATION PROJECT Project Description: The Georgia Technology Authority (GTA) will be consolidating production, test and developmental servers to the NADC. Consolidation and virtualization will enable the state to reduce the number of servers being supported. The team will identify which servers can be consolidated and the timeframe to complete the move. Monthly Update: September SCON Business Council Meetings that were scheduled for 9/12/12 and the 9/26/12 were both cancelled. The next meeting will be 10/10/12. Accomplishments This Reporting Period On-going Server OP's Readiness validation Completed implementation plan workshops Continued progress on Implementation Plan deliverable Planned Accomplishments Tasks in Progress Complete Network implementation & testing Phase two Finish server OP's readiness validation Finish the implementation plan Begin Application Installs 13 Project Issues / Risks and Mitigation Issues with Mitigation Plan: None Risks: R09 Oracle upgrade of 10 to 11g Pending Closed R11 2003 32 bit to 2008 64 bit Pending Closed R12 Duration to install Oracle 11g RAC impacted by DR testing T01 Patching & Service Packs have not been validated on application on server ACGB101 due to firmware/hardware issue on legacy server Items Requiring Management Attention/Escalation: None Critical Path Tasks/Milestones/Deliverables Baseline End Projected End Date Final approval of SCON-GBI (Affinity #1) DAD #3 (Implementation Plan Completed) Infrastructure has completed OP's readiness check & is production ready Milestone: GTA SCON-GBI (Affinity #1) SCON 08/07/12 09/12/12 10/15/12 10/26/12 Agency begins application rebuilds on servers Start 09/24/12 End 10/29/12 Start 10/29/12 End 11/30/12 Execute Testing Scripts 1st UAT Start 10/30/12 End 12/04/12 Start 12/03/12 End 01/11/13 7. CRIMINAL HISTORY/IDENTIFICATION SERVICES a. Fingerprint Cards Received/Processed Document Criminal Cards Electronic Criminal Juvenile Criminal Electronic Juvenile Applicant Cards Electronic Applicant TOTAL Received September 494 41,495 46 201 260 26,253 68,749 Received FY2013 2,171 128,534 167 525 987 86,586 218,970 Processed September 466 39,613 42 179 257 25,524 66,081 Processed FY2013 2,003 123,136 159 466 895 84,058 210,717 b. Significant Productivity Data AFIS Searches (Criminal, Applicant & Juvenile) AFIS Hits (Criminal, Applicant & Juvenile) September FY2013 66,245 211,777 30,016 (45%) 100,774 (48%) 14 c. Live Scan (Electronic Submissions) Activity September 1. Agencies transmitting electronically 359 (490 devices) 2. Agency added: None 3. On average, during the month, live scan represented 99% of total electronic and hard card criminal receipts. 4. On average, during the month, live scan represented 99% of the total applicant electronic and hard card receipts. d. AFIS Latent Activity Inquiries September: Inquiries FY2013: Hits September: Hits FY2013: 66,064 212,135 44 137 e. AFIS Remote Activity Inquiries September: Inquiries FY2013: LIP Hits September: LIP Hits FY2013: TI Hits September: TI Hits FY2013: LI Hits September: LI Hits FY2013: 740 2,115 0 0 10 44 92 271 f. CCH Record Corrections (Specials) Status September Total Received 1,168 Total Rejected 96 Total Completed 1,266 Total Still in Process 28 g. Defense Attorney Requests for Criminal History Records for Criminal and Civil Cases September FY2013 Total Requests 113 543 Revenue Collected $540.00 $2,130.75 8. SEX OFFENDER REGISTRY a. Sex Offender Registry Records Added During the Month TOTAL September FY2013 167 538 b. Sex Offender Program Statistics 1. Total number offenders on file = 21,952 2. Predators = 350 3. Juvenile (treat as adult) = 18 4. Total records with images = 21,733 (99%) 15 c. Registered Anniversary Letters Total Letters mailed: September FY2013 1,245 3,882 9. PROTECTION ORDER REGISTRY Records and Images Added During the Month Contributing Counties Records Added Records Added September September FY2013 111 2,033 6,087 Total orders on file: Active: Inactive: 236,660 8,639 228,021 Images Added September 13,057 Images Added FY2013 40,644 16