Shift Database + Personell Characteristics (San Francisco Police Department)

Michael Topper filed this request with the San Francisco Police Department of San Francisco, CA.
Tracking #

P087088-100922

Multi Request Shift Database + Personell Characteristics
Due Oct. 17, 2022
Est. Completion None
Status
Awaiting Response

Communications

From: Michael Topper

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 Francisco Police Department

Dear Michael Topper:

Thank you for your interest in public records of the San Francisco Police Department ("SFPD").

The San Francisco Police Department ("SFPD") received your request, dated October 09, 2022 and given the reference number P087088-100922 for tracking purposes.

Record(s) Requested: 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

Upload documents directly: https://www.muckrock.com/

Your request is being forwarded to the appropriate department(s) for processing and you will be notified once the request is complete.

You can monitor request progress at the link below.  Thank you for using the San Francisco Public Records Center.


San Francisco Police Department

From: Michael Topper

Hello,

I have not received any update on this. When can I expect a response?

If more convenient, please email me at michaeltopper@ucsb.edu or give me a call at (805) 914-4285.

Thanks!

Michael Topper

Files

There are no files associated with this request.