Monthly report [July 2012]

Georgia Bureau of Investigation July Monthly Report FY2013
Presented to the Board of Public Safety September 13, 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 - 7

IV. Crime Lab.............................................. 8 - 10

V. Georgia Crime Information Center................. 11 - 15

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 1 4 19 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

Firearms

1,231

Forensic Biology

949

Latent Fingerprints

1,081

Medical Examiners

127

Miscellaneous Services

1

Questioned Docs/Photography 312

Toxicology

942

Trace Evidence

200

Total

6,330

4

GBI Administration

Office of Privacy & Compliance/Open Records

Open Records Request Archives

July 2012 259 37

Total FY2013 259 37

Personnel
Employee Totals
Investigative Division Georgia Crime Information Center Division of Forensic Sciences Administration Bureau Total
*Vacancies are State Funded Positions

July 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 1 36 4 71

5

INVESTIGATIVE DIVISION

July 2012

Fiscal YTD

Total Sworn Employees

252 (filled-includes grant)

Total Investigative Hours Expended

28,280.75

28,280.75

Crimes Against Persons, includes Death Investigations Child Abuse Sex Crimes Missing Persons Assault, Kidnapping, Robbery, Terrorist Acts, Fugitive, Human Trafficking, etc.

8,567.50 3,960.00 2,141.50
289.00 99.00 2,078.00

8,567.50 3,960.00 2,141.50
289.00 99.00 2,078.00

Property Crimes, including Theft, Burglary, Forgery

2,813.25

2,813.25

Drug Investigations

7,622.00

7,622.00

Meth Lab Investigations

236.00

236.00

Polygraph Examinations

1,020.00

1,020.00

Background Investigations

46.00

46.00

Other Investigations, including Preliminary Investigations

4,091.00

4,091.00

Bomb Disposal Services

894.00

894.00

Crime Analysis

32.00

32.00

Crime Scene Specialists

2,959.00

2,959.00

All figures above represent Investigative Hours

Total Seizures

$90,322,429.00

$90,322,429.00

6

Investigative Hours Expended YTD FY2013

Bomb Disposal Services 3%
Other Investigations
16%

Crime Analysis >1%

Crime Scene Specialists 7%

Crimes Against Persons 28%

Background Investigations
2%

Polygraph Examinations
3%

Meth Lab Investigations
>1%

Drug Investigations
25%

Property Crimes 16%

7

Crime Lab

Medical Examiners (includes all laboratories)

July 2012 FY2013 YTD

Autopsies Consultations Anthropology Total ME Cases Managed

281

281

141

141

0

0

422

422

Clayton County Death Certificates

41

41

Medical Examiner Activity, FY2013

Consultations 34%

Anthropology >1%

Autopsies 66%

Confirmed CODIS Hits for July 2012

State Offender Hits:

30

State Forensic Hits

7

National Offender Hits

13

National Forensic Hits

4

Total

54

Samples entered into CODIS for July 2012

Headquarters Cleveland Savannah

95 2,061
25

Total

2,181

Profiles in CODIS
Forensic Casework Profiles Convicted Offender Profiles Missing Person/Unidentified Human Remain Profiles Total

12,629 241,858
14
254,501

8

Laboratory Production

Case Turnaround for July 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

2,752

4,243

65%

121

176

69%

270

512

53%

245

385

64%

1,798

1,913

94%

166

262

63%

220

248

89%

System-wide Totals

5,572

7,739

72%

Note: 85.8% 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

2,752

4,243

65%

121

176

69%

270

512

53%

245

385

64%

1,798

1,913

94%

166

262

63%

220

248

89%

System-wide Totals

5,572

7,739

72%

9

Crime Laboratory Cases Processed for July 2012

Department

Requested

Total Released

Chemistry (includes Drug ID) Firearms Forensic Biology Latent Prints Medical Examiners Questioned Documents Toxicology Trace Evidence

1,958 569
2,590 158 422 0
2,049 65

2,250 965
2,304 123 313 0
2,048 49

Total

7,811

8,052

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

1,958 569
2,590 158 422 0
2,049 65

2,250 965
2,304 123 313 0
2,048 49

Total

7,811

8,052

10

Georgia Crime Information Center

1. SYSTEM AVAILABILITY:

JULY 2012

Max Hours Possible for Month Downtime (Hours) Degraded (Hours) Percent Available for Month *New AFIS System was installed.

Enterprise GoNET/

AFIS

Network

2200

Infrastructure*

744.00

744.00 744.00

IBM System
744.00

2.50*

18.55

0.00

9.75

0.00

0.00

0.00

0.00

99.66%

97.51% 100% 98.69%

NCIC Files
744.00 0.00 0.00
100%

NICS NLETS

744.00 0.00 0.00
100%

744.00 2.00 0.00
99.73%

2. AUDITS: During the reporting month there were 13 full service audits conducted. There were 12 on-site audits conducted for agencies obtaining "inquiry only" from the CJIS network; 4 criminal justice E-Audits; 14 non-criminal justice audits. The total number of audits conducted during FY2013: 43.

3. TRAINING: GCIC personnel provided 413.75 hours of training to 1,444 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 June 18th the new AFIS became operational. The User Acceptance Testing and Implementation Plans are completed. Daily AFIS status meetings held after switchover to live system. AFIS connections to Image Archive, live scan, CCH, GAPS, FBI and AFIS Remotes have been restored and are running smoothly.

As part of the AFIS replacement live scan vendors had to certify that their software met the requirements of the new AFIS before installing on the local agency device. All vendors met the certification requirements and have begun the installation process. In order for agencies to continue to submit to AFIS all live scan systems must have the newly certified software installed and operational by December 19, 2012.

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

11

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 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: User Acceptance Testing (UAT) for the SORT system continues.
The following tasks are pending completion:
Completion of the webservices connection between SORT and LEMS/JX SORT system notifications to the local Sheriffs Offices Set up of SMTP on the mail server Electronic submission of SORT transactions to NCIC Implementation of Name Search software for NCIC inquiry transactions SORT Link on SSL/VPN menu
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: June SCON Business Council Meeting was held on 7/25/12. We are currently following up on the items listed below that came out of the Business council meeting:
Accomplishments This Reporting Period Completed rack & cabling of all servers Achieved consensus on Oracle 10g to 11g upgrade strategy Reviewed / finalized Network implementation plan and test plan
Planned Accomplishments Tasks in Progress Network Implemented Begin logical server build-out Final configurations
12

Decision Statement All planning will proceed to support GBI to upgrade Oracle from 10g to 11g prior to SCON. No RFS is required to initiate this request. The current RFS 0969 for Oracle Upgrade will be updated to include the RAC Production setup and processing will continue. At July 24th meeting to discuss Oracle upgrade Position paper and recommendation attended by Dean, Erica, Bonnie, Bev, Rose and Kirk. It was confirmed that the Oracle upgrade and Oracle RAC Prod setup would be done as a no cost RFS. Terri Fisher clarified that GBI's request for Oracle RAC Production setup is a mirror image of the existing Oracle RAC with two nodes. The two node to three node RAC cluster to address replication issues will be handled via the Exemption Request and included as part of the SCON NADC build out. SCON Dbase build out activities will proceed based on the decision to upgrade from 10g to 11g.
New Action Items Item IBM will have an internal work session to understand the full scope of the request to support GBI to implement 11g prior to SCON with RAC Production setup.

Owner GBI, GTA, IBM Bev, Dean Johnson
Dean Johnson, Bev Owner Ed Potts

Critical Path Tasks/Milestones/Deliverables
Milestone: Test Scripts Complete
Major Milestone 11: GTA-SCON-GBI (Affinity #1) Initial Server Build Out Completed
Agency begins application rebuilds on servers

Baseline End 6/27/12
08/24/12 Start 9/24/12 End 10/29/12

Projected End date 6/27/12
08/24/12 Start 9/24/12 End 10/29/12

Actual End
8/10/12

Status In progress

7/27/12

All servers are racked and cabled.

7. WEBSITE RE-DESIGN PROJECT Project Description - The GBI website will be re-designed to better enable the public to find relevant, accurate, up-to-date information. In addition, each division will have a focal point identified to update their websites to improve efficiency. The new website will be consistent with the State of Georgia's website design using Drupal.
Monthly Update: The GBI website is in the process of being migrated to Drupal. The new website will go online on the evening of August 10, 2012. The website redesign team met with GTA representatives on July 18th to hash out the details of the migration. One of the major changes of the new website is a horizontal navigation with drop down menus. Information Architecture tasks were performed to determine how best to reorganize the navigation so that website users are able to more easily and quickly get the information they are looking for. Additional tasks will be performed after the launch of the new site to further improve the look and feel of the site and make information easier to find. These include:
Creating a quick links area on the homepage to make popular content more easily accessible.
Adding dynamic content (like News Releases) to the homepage to keep the site fresh and improve SEO.
Leverage the new content types available in Drupal to present content in a more intuitive way.
One of the goals of the new website is to improve content editing efficiency by giving editing access to more staff members throughout the GBI. Content editors from Administration,

13

Investigative Division and GCIC have attended a Drupal training to get familiar with the new Content Management System. More training will be offered in the near future to others who desire to manage their own web content on the new system.

8. CRIMINAL HISTORY/IDENTIFICATION SERVICES

a. Fingerprint Cards Received/Processed

Document
Criminal Cards Electronic Criminal Juvenile Criminal Electronic Juvenile Applicant Cards Electronic Applicant TOTAL

Received July 894 42,849 65 148 381 27,265 71,602

Received FY2013
894 42,849
65 148 381 27,265 71,602

Processed July 777 41,060 60 138 329 26,523 68,887

Processed FY2013
777 41,060
60 138 329 26,523 68,887

b. Significant Productivity Data AFIS Searches (Criminal, Applicant & Juvenile) AFIS Hits (Criminal, Applicant & Juvenile)

July 69,525 37,627 (54%)

FY2013 69,525 37,627 (54%)

c. Live Scan (Electronic Submissions) Activity - July
1. Agencies transmitting electronically 359 (489 devices) 2. Agency added: None 3. On average, during the month, live scan represented 98% 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 July: Inquiries FY2013: Hits July: Hits FY2013:

69,151 69,151
59 59

e. AFIS Remote Activity

Inquiries July:

731

Inquiries FY2013:

731

LIP Hits July:

0

LIP Hits FY2013:

0

TI Hits July:

15

TI Hits FY2013:

15

LI Hits July:

109

LI Hits FY2013:

109

14

f. CCH Record Corrections (Specials) Status Total Received Total Rejected Total Completed Total Still in Process

July 1,234
53 1,233
184

g. Defense Attorney Requests for Criminal History Records for Criminal and Civil Cases

July

FY2013

Total Requests

212

212

Revenue Collected

$795.00

$795.00

8. SEX OFFENDER REGISTRY

a. Sex Offender Registry Records Added During the Month TOTAL

July FY2013

166

166

b. Sex Offender Program Statistics 1. Total number offenders on file = 21,684 2. Predators = 338 3. Juvenile (treat as adult) = 19 4. Total records with images = 21,467 (99%)

c. Registered Anniversary Letters Total Letters mailed:

July FY2013 1,330 1,330

9. PROTECTION ORDER REGISTRY

Records and Images Added During the Month

Contributing Counties Records Added Records Added

July

July

FY2013

110

1,851

1,851

Images Added July
12,094

Total orders on file: Active: Inactive:

232,141 8,899
223,242

Images Added FY2013
12,094

15