Georgia Bureau of Investigation June Monthly Report FY2018 Presented to the Board of Public Safety No meeting scheduled for August 2018 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 9 IV. Crime Lab.............................................. 10 12 V. Georgia Crime Information Center................. 13 20 2 Vacant State Positions FY2018 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 Jun 38 37 31 31 30 28 26 28 27 27 27 30 16 15 15 15 16 16 18 18 16 16 16 16 1 1 1 1 1 1 1 1 0 0 0 1 7 7 7 6 7 7 7 7 6 6 6 5 9 10 10 5 7 8 8 8 8 8 10 10 17 17 12 13 17 18 17 15 17 18 17 16 3 DOFS Backlog Chart Unworked Reports over 30 Days Old FY2018 Discipline Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Chemistry 12,601 12,743 13,861 13,802 14,111 14,246 15,223 15,598 16,145 16,109 16,485 17,285 Data Conversion 1 1 1 1 1 1 1 1 1 1 1 1 Firearms 2,956 2,984 3,080 3,081 3,166 3,190 3,232 3,285 3,250 3,408 3,455 3,520 Forensic Biology 5,225 5,553 5,695 5,431 5,563 5,687 5,677 5,560 5,686 5,858 5,937 5,980 Impressions 44 46 48 47 47 48 52 51 54 55 56 57 Latent Prints 3,727 3,747 3,934 3,948 4,127 4,142 4,190 4,174 4,276 4,286 4,295 4,357 Medical Examiners 188 177 193 218 232 261 320 274 245 234 247 245 Miscellaneous Services 0 0 0 0 0 0 0 0 0 0 0 0 Operations Support 2 2 0 0 0 0 0 7 2 7 3 14 Toxicology 746 639 819 822 1,033 776 1,080 791 724 855 991 770 Trace Evidence 487 441 438 440 468 494 489 512 539 571 610 611 Total 25,977 26,333 28,069 27,790 28,748 28,845 30,264 30,253 30,922 31,384 32,080 32,840 4 GBI Administration Office of Privacy & Compliance/Open Records Open Records Request Archives June 2018 341 30 Total FY2018 4,192 386 Personnel Employee Totals Investigative Division Georgia Crime Information Center Division of Forensic Sciences Administration Total June 2018 State Funded Positions 350 44 313 43 750 Grant Funded Positions 24 77 37 4 142 Total 374 121 350 47 892 Investigative Division Georgia Crime Information Center Division of Forensic Sciences Administration Total Total State Funded Positions Vacant 16 1 30 5 52 State Funded Vacancies Under Active Recruitment 3 0 11 1 15 5 INVESTIGATIVE DIVISION June 2018 Fiscal YTD Total Sworn Employees 272 (filled-includes grant) Total Investigative Hours Expended 28,531.25 358,557.25 Crimes Against Persons, includes Death Investigations Child Abuse Sex Crimes Missing Persons Assault, Kidnapping, Robbery, Terrorist Acts, Fugitive, Human Trafficking, etc. 9,539.75 4,644.00 2,828.75 505.00 225.00 1,337.00 129,816.50 69,969.00 36,554.00 5,963.00 2,467.00 14,863.50 Property Crimes, including Theft, Burglary, Forgery 2,834.50 32,694.75 Drug Investigations 3,994.00 48,083.50 Meth Lab Investigations 7.00 100.00 Polygraph Examinations 921.00 10,709.00 Background Investigations 1,117.00 5,108.00 Other Investigations, including Preliminary Investigations 5,509.00 77,794.50 Bomb Disposal Services 971.00 11,558.00 Crime Analysis - 26.00 Crime Scene Specialists 3,638.00 42,667.00 All figures above represent Investigative Hours Total Seizures 4,532,667.51 $40,950,012.36 6 Investigative Hours Expended YTD FY2018 Crime Analysis >1% Background Investigations 2% Bomb Disposal Services 3% Crime Scene Specialists 12% Crimes Against Persons 36% Other Investigations 22% Polygraph Investigations 3% Meth Lab Investigations >1% Drug Investigations 13% Property Crimes 9% 7 Georgia Authorized Central Storage (ACS) Program Update https://gbi.georgia.gov/meth-container-program 4th Quarter FY2018 (April 1 to June 30, 2018) During the 4th quarter, local and state law enforcement agencies used the Georgia ACS program to store and dispose of hazardous waste from 11 clandestine drug labs discovered in Georgia. The processing and packaging of materials resulted in 36 hazardous waste containers with a total volume of 382 gallons. The total weight of the hazardous waste was 269 pounds. All 9 Georgia ACS facilities were operational during the 4th quarter. Totals for FY2018 include 35 clandestine labs resulting in 237 containers of hazardous waste with a volume of 3,282 gallons and a weight 1,225 pounds. 8 9 Crime Lab Medical Examiners (includes all laboratories) June FY2018 YTD Autopsies Consultations Total ME Cases Managed 271 2,821 115 1,651 386 4,472 Clayton County Death Certificates 46 559 Percentage of Cases Released in 90 days: 71.8% Medical Examiner Activity, FY2018 Consultations 37% Autopsies 63% Confirmed CODIS Hits for June 2018 State Offender Hits 52 State Forensic Hits 8 National Offender Hits 22 National Forensic Hits 0 Total 82 Samples entered into CODIS for June 2018 1,398 Profiles in CODIS Forensic Casework Profiles Convicted Offender Profiles Missing Person/Unidentified Human Remain Profiles Staff/QC File Total 10 22,713 331,237 7 506 354,463 Laboratory Production Report Turnaround for June 2018 Laboratory Headquarters - Atlanta Central Regional - Macon Coastal Regional - Savannah Eastern Regional - Augusta Northeastern Regional Southwestern Regional - Moultrie Western Regional - Columbus # Released in 45 Days 2,224 23 58 267 952 42 57 Total % Released in Released 45 Days 3,689 60% 226 10% 335 17% 425 63% 1,123 85% 211 20% 225 25% System-wide Totals 3,623 6,234 58% Note: 66.5% Casework Reports were released within 90 days. Report Turnaround for Year-to-Date, FY2018 Laboratory Headquarters - Atlanta Central Regional - Macon Coastal Regional - Savannah Eastern Regional - Augusta Northeastern Regional Southwestern Regional - Moultrie Western Regional - Columbus # Released in 45 Days 23,413 433 724 3,313 11,485 605 559 Total % Released in Released 45 Days 40,040 58% 3,121 14% 5,976 12% 5,195 64% 13,581 85% 2,892 21% 2,966 19% System-wide Totals 40,532 73,771 55% 11 Crime Lab Reports Processed for June 2018 Department Requested Total Released Chemistry (includes Drug ID) Firearms Forensic Biology Impressions Latent Prints Medical Examiners Operations Support Toxicology Trace Evidence 3,316 168 1,693 1 142 463 7 2,624 90 1,978 119 1,434 1 122 509 2 2,514 64 Total 8,504 6,743 Crime Lab Reports Processed FY2018 Department Requested Total Released Chemistry (includes Drug ID) Firearms Forensic Biology Impressions Latent Prints Medical Examiners Operations Support Toxicology Trace Evidence 33,099 2,119 18,253 26 2,147 5,788 122 27,333 969 26,283 1,285 16,984 9 1,488 5,740 123 26,793 806 Total 89,856 79,511 12 Georgia Crime Information Center June 2018 NCIC SERVICES CJIS Network Statistics System Uptime: Messages Processed: 100% 73,723,675 CJIS Operations 1. Sex Offender Registry Records Added Month 137 FY2018 1,692 2. Protection Order Registry Records Added Month 2,907 FY2018 26,958 Database Totals 31,139 Database Totals 379,814 3. National Data Exchange (N-DEx) Number of Georgia agencies contributing to N-DEX: 33 (5 direct, 28 LInX) Agencies/Users with N-DEx Inquiry Access Only (no data contributed) Added Removed Total with Inquiry Access Agencies 0 3 16 Users 0 3 23 4. Off-Line Search Requests Type of Request Month FY2018 Administrative (Criminal Justice Agency) Open Records Subpoena Media Possible CJIS Security Violations 23 280 2 22 0 0 0 0 2 30 CJIS Audits GCIC conducted 33 CJIS Audits 13 INFORMATION SERVICES Criminal History/Identification Services 1. Criminal Fingerprint Transactions Received Submissions Submissions w/Palms Submissions w/Photos Month 41,082 1,795 13,621 Transactions processed within 2 hours of receipt: 2. Applicant Fingerprint Transactions Received Submissions Month 38,335 Transactions processed within 24 hours of receipt: 3. Final Dispositions Received Local Agency GCIC TOTAL Month 71,061 5,503 76,564 4. RAPID Identification Transactions Submissions AFIS Hits NCIC Hits FBI RISC Hits Month 11,363 66% 45% 9% 5. Non-criminal Justice Audits, Visits and Trainings In Compliance Out of Compliance Total Audits Advisement Memos Agency Visits Attendees Trainings Month 10 12 22 - 2,300 5 14 FY2018 455,912 201,545 150,476 95% FY2018 422,439 100% FY2018 812,367 58,252 870,619 FY2018 124,119 65% 43% 6% FY2018 113 176 289 93 3,835 67 6. Disposition Recovery Project Submitted by Vendor Dispositions Processed Month 3011 2290 Project to Date 99,256 98,535 The chart below shows the number of serious/violent felony offenses that were previously restricted but are now returned for licensing and employment purposes because a disposition of guilt was obtained and entered in the criminal history 15 PLANS AND PROGRAM DEVELOPMENT APPLICATION DEVELOPMENT - Protective Order Registry Project Description - To provide better information sharing, the Georgia Protective Order Registry (POR) is being updated to improve record data quality and expanding database capabilities by replacing the existing application and infrastructure. Monthly Update - The new POR was deployed June 25 and the team is currently working on resolving message switch transactions (QPOR and DQ) to be incorporated within the new system. CHILD FATALITY SYSTEM REVIEW PROJECT Project Description - The Child Fatality Review (CFR) unit requested an enhancement to their current process to capture Medical Examiners (ME) data for child related deaths in the State of Georgia and have asked for additional reporting capabilities. Monthly Update - The developer is working on developing SQL Server Integration Services (SSIS) packages to connect to DOFS. The target date for project completion is December 2018. CRIMINAL JUSTICE EXCHANGE PROJECT Project Description - The Georgia Bureau of Investigation will programmatically own an initiative of the Governor's Office entitled Criminal Justice Exchange Project (CJEP). CJEP will incorporate the electronic exchanges of information between state and local criminal justice agencies in Georgia. Each exchange automates a manual, paper-based criminal justice business process and will follow a criminal case lifecycle from booking through disposition and supervision. The goals of the project are to create seamless connections between systems, establish a single, consistent architecture adopted to guide all aspects of program implementation and to establish a governance structure that views criminal justice as a statewide community. The exchanges will involve the coordination of multiple agencies and vendor applications. Monthly Update - GBI, GTA, Consultants, Statewide Stakeholders and vendors continue to meet and work towards the completion of project data exchanges by the October 2018 release date. The GBI is working with vendors to install server patches and will schedule testing after the installation. CUSTOMER SUPPORT - TRAINING Project Description - The Customer Support Training group provides training in GCIC programs, GCIC applications, GCIC/FBI compliance and other supported law enforcement training to both criminal and non-criminal justice agencies, municipal, magistrate and probate courts across the State of Georgia. The group extends the option to receive classroom training or training within an e-Learning environment. 16 Monthly Update - The GBI online Learning Management System contains several videos and online classroom training available to agencies and vendors of law enforcement agencies. The trainings completed online and within the classrooms for the month are included in the charts. The LMS Staff handled 92 phone calls, 854 emails and managed LMS user account additions. The Customer Support Training team also developed and delivered agency training on GCIC programs/applications, and the training staff completed teach backs to gain insight and feedback for improving overall quality of training content and delivery. 17 DEPARTMENT OF REVENUE (DOR) DRIVES PROJECT Project Description - The purpose of this project is to document, configure, integrate, and test two interfaces with the new Georgia Department of Revenue (DOR) Driver Record and Integrated Vehicle Enterprise System (DRIVES). The two new interfaces will use existing LEMS Web Services capabilities with National Information Exchange Model (NIEM) Extensible Markup Language (XML) message formats. One interface will be used to send and receive vehicle registration queries and responses to and from DRIVES. The other interface will be used to receive stolen vehicle requests and responses to and from DRIVES. Monthly Update - The GBI and DOR met to discuss the risk of being the first to utilize a fully compliant NIEM web service to NCIC. The GBI vendor confirmed that there is minimal risk involved. GBI personnel connected to the DOR FTP server and downloaded the certificate to consume the DOR web service. GBI is currently in the process of installing and configuring the certificate on the message switch and will conduct testing once the appropriate firewall rules are in place. FINANCE ACCOUNTS RECEIVABLE (AR) SYSTEM PROJECT Project Description - GBI Finance/Accounting requested a new accounts receivable system to process fee invoices and payments. Monthly Update - Finance continues to explore the option of either hiring a consultant to complete RFP requirements for a second posting, or hiring a consultant to develop a customized system to fully meet the needs of the Accounts Receivable unit. 18 GCIC TRAINING SYMPOSIUM Project Description - The GCIC Training Symposium is designed to offer continuing education with the goal of providing vital knowledge regarding GCIC and federal law enforcement programs to both the criminal justice and non-criminal communities. Monthly Update - The project team continues to complete tasks for the symposium. Paid reservations total close to 600. GEORGIA APPLICANT PROCESSING SYSTEM REPLACEMENT (GAPS) PROJECT Project Description - The Georgia Crime Information Center Information Services is seeking to obtain the services of a qualified and experienced vendor to provide an applicant fingerprinting solution that will electronically capture and submit applicant fingerprints to the Automated Fingerprint Identification System (AFIS). In addition, the selected vendor shall handle receiving fingerprint search results and disseminate the results to the requestor. Monthly Update - The vendor was awarded the proposal and a contract was signed by GBI. The project kick-off meeting is scheduled for July 2018. HUMAN RESOURCES (HR) TIMESHEET PROJECT Project Description - Enhancement of the application used by non-sworn units of the GBI for tracking time. Monthly Update - Application development continues as the programmer works to resolve problems with time features (unlimited Time-In and Time-Out) INFORMATION SERVICES CRIMINAL HISTORY APPLICATION REDESIGN PROJECT Project Description - A redesign of the web application used by Information Services staff to log and track activities performed on criminal history information as well as services performed for the public. Monthly Update - The application developer continues to work on completing outstanding tasks. There are six additional requirements the IT programmer is working on that make up the first phase of the CCH redesign project. LAW ENFORCEMENT MESSAGE SWITCH (LEMS) Project Description - The message switch provides a means of communication between federal, state and local law enforcement agencies throughout the state of Georgia, the United States and other countries and to take advantage of new features and advances in technology, GCIC is looking to upgrade or replace this system. Monthly Update - The Project Manager is reviewing the three recommendations suggested by GTA to add to the RFP requirements: listing of the current architecture and interface of the system, project management implementation approach and defined roles and responsibilities of all parties. 19 NATIONAL INCIDENT-BASED REPORTING SYSTEM (NIBRS) PROJECT Project Description - The National Incident Based Reporting System (NIBRS) collects data on each single incident and arrest for each offense coming to the attention of law enforcement for which specific facts about each crime is collected. GBI is in the process of replacing the current UCR summary-based system with an application that will collect incident-based data. Monthly Update - The State of Georgia received FBI Certification as a NIBRS state. GBI is preparing to shut-down all Family Violence FTP data transmissions on June 30, 2018 to complete the migration and QA of Family Violence data. The project team plans to meet to discuss and finalize the process of year end reports. SEX OFFENDER REGISTRY TOOL (SORT) ENHANCEMENT PROJECT Project Description - System enhancements for the SORT application. Phase 1 will consist of modifications to the application used by Sheriff's Offices, the public website, NCIC web services and SORT Reports. Phase 2 will focus on the web service between SORT and AFIS for the upload of SORT documentation. Monthly Update - The vendors have completed the vendor vetting process and continue to support application development through testing and system access. SHAREPOINT CONFIGURATION PROJECT Project Description - The SharePoint tool will be used as an internal web portal for organizing and sharing information as an employee collaborative tool for internal communication. The portal will also include an Intranet application for each of the three GBI divisions that would allow content management, document repository and information sharing of announcements, news and department information. Monthly Update - No accomplishments for this reporting period. 20