Shift Database + Personell Characteristics (San Diego Police Department) • MuckRock

11 Communications
1 File

Communications

From: Michael Topper

10/07/2022

Subject: California Public Records Act Request: Shift Database + Personell Characteristics (San Diego Police Department)

Portal

To Whom It May Concern:

Pursuant to the California Public Records Act, I hereby request the following records:

1. Officer Demographics/Characteristics: I am requesting information on all sworn officers who were employed at any time from January 1, 2010 - December 31, 2020 including, but not limited to:

Officer first name
Officer last name
Officer appointed date
Officer termination date (if applicable)
Reason for termination (if applicable)
Officer badge number
Officer rank
Officer race
Office highest education received
Officer age
Officer job title
Officer sex

2. Police Officer Shift Information: All sworn officers shifts dating from January 1, 2010 to December 31, 2020. Each shift should include, but not be limited to the following:

Shift start date (YYYY-MM-DD)
shift end date (YYYY-MM-DD)
Shift start time (HH:MM)
Shift end time (HH:MM)
District or beat assigned
Officer badge number

3. Attacks on Officers: All attacks by civilians (or other officers) on sworn officers dating from January 1, 2010 to December 31, 2020. Each attack should include:

Officer badge number
Date of attack

4. Complaints information: All complaints on sworn-officers who were employed at any time from January 1, 2010 - December 31, 2020 including:

Officer badge number
Complaint description/reason
Date of complaint

Please provide me with these public records in a machine-readable ASCII format, such as a CSV, SQL, TXT, or similar raw file. CSV or SQL files are preferred when available. Please email the responsive records to my email address: michaeltopper@ucsb.edu.

If email transmission is not feasible, I agree to prepay the actual cost of the storage medium on which the responsive records are transmitted, any postage costs incurred, per KRS 61.874(2) and (3). Please inquire for mailing address if this is necessary.

The requested documents will be made available to the general public, and this request is not being made for commercial purposes.

In the event that there are fees, I would be grateful if you would inform me of the total charges in advance of fulfilling my request. I would prefer the request filled electronically, by e-mail attachment if available or CD-ROM if not.

Thank you in advance for your anticipated cooperation in this matter. I look forward to receiving your response to this request within 10 calendar days, as the statute requires.

Sincerely,

Michael Topper

From: San Diego Police Department

10/09/2022

Subject: Your first record request #22-5370 has been opened.

Portal

City of San Diego

************************************************************************

Your first City of San Diego record request (request number #22-5370) has been submitted.
It is currently unpublished and is not available for the general public to view.

Please be advised that City staff have received your CPRA request. Within the next 10 days, we will determine whether your request seeks copies of disclosable records in the City's possession or whether the City will require an extension. If your request is submitted on a Saturday, Sunday, or City holiday, the City considers the request received on the following business day.

Request #22-5370.

************************************************************************
Questions about your request? Reply to this email or sign in to contact staff at City of San Diego. Technical support: See our <a href='https://help.nextrequest.com/knowledge/requester-resources'>help page</a>

From: San Diego Police Department

10/20/2022

Subject: [External Message Added] City of San Diego public records request #22-5370

Portal

City of San Diego

************************************************************************

A message was sent to you regarding record request #22-5370:

Good morning,

Pursuant to California Government Code section 6253(c), the City needs to consult with others, which may include multiple departments of the City or other entities who have a substantial interest in the subject matter. Therefore, the City is taking a 14-day extension in which to conduct this consultation. We will notify you on or before November 3 whether the City has responsive records.

Kind regards.

From: San Diego Police Department

10/20/2022

Subject: [Document Released to Requester] City of San Diego public records request #22-5370

Portal

City of San Diego

************************************************************************

A document has been released for record request #22-5370 along with the following message:

Responding for the Personnel Department to item #1, attached is a list of individuals who occupied a sworn position in the Police Department (including Police Recruits) at any time from 1/1/10 to 12/31/20. Some may have moved to a different job classification. The columns on the report are as of 12/31/20, so if someone separated during the time frame and was rehired, this report will not show a separation date. With regard to your request for race, age, sex, separation reason, and education, either the Personnel Department does not maintain records with that information or if we do, then records containing that information are being withheld as personnel records pursuant to Cal. Government Code section 6254(c) and is individual privacy protected pursuant to Cal. Government Code section 6255 wherein the public interest in nondisclosure of private and personally identifying information clearly outweighs any public interest in disclosure. The actual job classifications or ranks for sworn Police personnel, including recruits, are also withheld pursuant to Government Code section 6255 [public interest in non-disclosure outweighs public interest in disclosure]. The person making the exemption determinations on behalf of the Personnel Department is Anne Lamen Aban, Assistant Personnel Director. We do not have responsive records related to badge numbers, item #2, and item #3. We are checking for responsive records for #4 but reserve the right to redact or withhold information pursuant to applicable law. Under California Government Code section 6253.1, please advise if you would like to discuss your request further. Other City departments may be responding to this PRA request.

* PRAR #22-5370_Sworn PD EEs since 2010_10202022.xlsx

PRAR_22-5370_Sworn_PD_EEs_since_2010_10202022
- Download

From: Michael Topper

10/21/2022

Subject: RE: California Public Records Act Request #22-5370

Portal

Hello,

Thanks for this information—it is much appreciated. I did have an inquiry:

In regards to #2, do the records not exist with just respect to badge number? If they exist with respect to officer first name and last name, those are records I am interested in as well. Essentially, with regards to #2, any shift database in which an officer can be identified is what I am searching for, assuming it has the following fields:

Shift start date (YYYY-MM-DD)
Shift end date (YYYY-MM-DD)
Shift start time (HH:MM)
Shift end time (HH:MM)
District or beat assigned (or similar column)

In regards to #3, no problem, and thank you for the update.

Thanks for your responsiveness!

Michael

From: San Diego Police Department

10/24/2022

Subject: [External Message Added] City of San Diego public records request #22-5370

Portal

City of San Diego

************************************************************************

A message was sent to you regarding record request #22-5370:

Hello. The Personnel Department does not responsive records related to #2 (Police Officer shift information).

From: San Diego Police Department

10/26/2022

Subject: [External Message Added] City of San Diego public records request #22-5370

Portal

City of San Diego

************************************************************************

A message was sent to you regarding record request #22-5370:

The Personnel Department has no other responsive records.

From: San Diego Police Department

10/27/2022

Subject: [External Message Added] City of San Diego public records request #22-5370

Portal

City of San Diego

************************************************************************

A message was sent to you regarding record request #22-5370:

Good morning,

With regard to item #2 - the records you requested are withheld pursuant to the following Government Code exemption(s):

Government Code section 6254 (f) [Operational Security]

The person making the decision to withhold the records is Capt Jeffrey Jordon.

With regard to Items #3 and #4 - Please refer to the Department of Justice's website:

State of California Department of Justice - OpenJustice

The City has no other responsive records.

Kind regards.

From: San Diego Police Department

10/27/2022

Subject: Your City of San Diego public records request #22-5370 has been closed.

Portal

City of San Diego

************************************************************************

Record request #22-5370 has been closed.

From: San Diego Police Department

10/31/2022

Subject: Your City of San Diego public records request #22-5370 has been published.

Portal

City of San Diego

************************************************************************

Record request #22-5370 has been published and is now available for public view.

Files

10/20/2022

PRAR_22-5370_Sworn_PD_EEs_since_2010_10202022
- Download

Tracking #	22-5370
Multi Request	Shift Database + Personell Characteristics