BPD: Internal Affairs Division (IAD) database schema

Adam Friedman filed this request with the Boston Police Department of Boston, MA.
Est. Completion None
Status
No Responsive Documents

Communications

From: Adam Friedman

To Whom it May Concern:

Pursuant to the Massachusetts Public Records Law, M.G.L. c.66, §10, I hereby request the following records:

A detailed descriptive explanation of how civilian complaints submitted to the IAD are stored digitally as well as a detailed database schema or specification concerning any and all databases in which such complaints are internally archived and/or organized.

I also request that, if appropriate, fees be waived as we believe this request is in the public interest, as suggested but not stipulated by the recommendations of the Massachusetts Supervisor of Public Records. The requested documents will be made available to the general public free of charge as part of the public information service at MuckRock.com, processed by a representative of the news media/press and is made in the process of news gathering and not for commercial usage.

I expect the request to be filled in an accessible format, including for screen readers, which provide text-to-speech for persons unable to read print. Files that are not accessible to screen readers include, for example, .pdf image files as well as physical documents.

In the event that fees cannot be waived, 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 business days, as the statute requires.

Sincerely,

Adam Friedman

From: Media Relations

December 9, 2014


Adam Friedman
Muckrock

Dear Mr. Friedman:

Pursuant to G. L. c. 66, § 10 (b), this correspondence is to confirm
receipt of your request for documents that are potentially in the
possession, custody or control of the Boston Police Department.
Specifically, you have requested:


A detailed descriptive explanation of how civilian complaints submitted to
the IAD are stored digitally as well as a detailed database schema or
specification concerning any and all databases in which such complaints are
internally archived and/or organized.

We will contact you as soon as possible with our findings, and will send
you a cost estimate for your requested materials if fulfilling the request
is expected to exceed $10.00, per 950 C.M.R. 32.06(1); 950 C.M.R. 32.03;
M.G.L. c 66 § 10(a).

Please be advised that we research each request in the order it was
received, and it may take longer than ten days to be fulfilled. If your
request requires a substantial amount of research, reviewing and redacting,
fulfilling the request will take a significant amount of time. Please plan
accordingly.

Thank you,

Office of Media Relations

Boston Police Department

617-343-3520
www.bpdnews.com

From: Adam Friedman

Hello Office of Media Relations,

I received your response 20 days ago. In your response, you wrote:

(1) "We will contact you as soon as possible with our findings."

(2) "If your request requires a substantial amount of research, reviewing and redacting, fulfilling the request will take a significant amount of time."

Given that a) you were able to respond promptly within three days of my initial request, and given that b) my request is asking for a database schema and explanation that could likely fit onto 2-4 pieces of paper and thus should not require "a significant amount of time" to fulfill, and given that 3) the IAD database and complaint process is a well-known and consistently utilized asset and procedure within the department, I find it unreasonable and in potential violation of the statute that your department has allowed 20 days to elapse and has thus far failed to fulfill this request.

Please follow the statute as directed and provide the modest item I am requesting. Should you need clarification, please do not hesitate to ask.

Thank you!

From: Adam Friedman

Hello,

It has been about a week since my last message and I have not heard any response to that nor to my original request on 12/6/2014.

As you are a BPD employee, I respectfully ask you to identify yourself by name and status/rank. If there are multiple employees directly responding to my request, I kindly ask that you all identify yourselves by name and status/rank. In the event that you are unaware, you are required to identify yourself upon request to any person, in accordance with BPD Rule 102, sec. 20 (http://static.squarespace.com/static/5086f19ce4b0ad16ff15598d/t/52af5cabe4b06f32999deaf9/1387224235305/Rule+102.pdf)

Thank you for your cooperation.

From: MuckRock.com

To Whom It May Concern:

I wanted to follow up on the following Freedom of Information request, copied below, and originally submitted on Dec. 6, 2014. Please let me know when I can expect to receive a response, or if further clarification is needed.

Thank you for your help.

From: Adam Friedman

It has been 19 since I requested you identify yourself. You are in clear violation of the law. There will be consequences.

From: MuckRock.com

To Whom It May Concern:

I wanted to follow up on the following Freedom of Information request, copied below, and originally submitted on Dec. 6, 2014. Please let me know when I can expect to receive a response, or if further clarification is needed.

Thank you for your help.

From: MuckRock.com

To Whom It May Concern:

I wanted to follow up on the following Freedom of Information request, copied below, and originally submitted on Dec. 6, 2014. Please let me know when I can expect to receive a response, or if further clarification is needed.

Thank you for your help.

From: MuckRock.com

To Whom It May Concern:

I wanted to follow up on the following Freedom of Information request, copied below, and originally submitted on Dec. 6, 2014. Please let me know when I can expect to receive a response, or if further clarification is needed.

Thank you for your help.

From: Adam Friedman

The Boston Police Department has blatantly violated state law. My request was made 12/6/2014 but there has been absolutely no follow-up beyond a boilerplate response letter affirming the Department's receipt of my request. I have followed up SEVEN TIMES and have heard no response. Over 100 days have elapsed since my original request.

From: MuckRock.com

To Whom It May Concern:

I wanted to follow up on the following Freedom of Information request, copied below, and originally submitted on Dec. 6, 2014. Please let me know when I can expect to receive a response, or if further clarification is needed.

Thank you for your help.

From: Media Relations

Alan,

You have requested "documents" that may be in the possession, custody or
control of the Boston Police Department under the Massachusetts Public
Records Request Act (M.G.L. c. 66 s 10). Specifically, you requested; *A
detailed descriptive explanation of how civilian complaints submitted to
the IAD are stored digitally as well as a detailed database schema or
specification concerning any and all databases in which such complaints are
internally archived and/or organized. *

The Boston Police Department does not have any records responsive to your
request. However, Please accept this written response from the BPD as
responsive to your question above.

When a citizen files a complaint against a department employee, the
complaint is usually filed in person with a supervisor assigned to IAD or a
supervisor assigned to a neighborhood police station. The supervisor then
enters the complaint into the “Blue Team” database, via a web based GUI.
These complaints then flow into the the Internal Affairs Division’s
complaint database management system, IAPro. This system is a COTS
(Commercial Off The Shelf) product designed to support the process of
managing complaints and cases. The BPD does not have technical expertise
in, nor visibility into, how IAPro stores data.

We will consider this request closed.

Media Relations

Files

There are no files associated with this request.