CLEAR database

Freddy Martinez filed this request with the Chicago Police Department of Chicago, IL.
Tracking #




From: Freddy Martinez

To Whom It May Concern:

Pursuant to the Illinois Freedom of Information Act (5 ILCS 140/1 to 11), I hereby request the following records:

Documents sufficient to show the table structure of the CLEAR database. This FOIA assumes that your data for bonds is stored in a Relational Database like SQL (which I believe it is).

Please be aware that these documents are already stored electronically, therefore I request these documents be sent to us in a machine readable format (Excel should be fine). You will have to request a database administrator who is familiar with SQL queries. Please be aware that we are looking for the names of the tables and the rows within that table. We do NOT seek the records in the rows.

The requested documents will be made available to the general public, and this request is not being made for commercial purposes. This request is being made by the Lucy Parsons Labs, a registered non-profit in the State of IL.

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 5 business days, as the statute requires.


Freddy Martinez
Director, LPL

From: FOIA

Extension Notice FOIA # P428425
The Chicago Police Department received your Freedom of Information Act Request on September 11, 2017. Under the Freedom of Information Act, a public body may extend the time to respond to a FOIA request by up to 5 business days for a limited number of reasons. Pursuant to Section 5 ILCS 140/3(e) of the Act, the CPD is extending the time to respond to your request by 5 business days from the original due date for the following reason(s):

( ) The requested records are stored in whole or in part at other locations other than the office having charge of the requested records;

( ) The requested records require the collection of a substantial
number of specified records;

( ) The request is couched in categorical terms and requires an
extensive search for the records responsive to it;

( ) The requested records have not been located in the course of routine search and additional efforts are being made to locate them;

( ) The requested records require examination and evaluation by personnel having the necessary competence and discretion to determine if they are exempt from disclosure or should be revealed only with appropriate deletions;

( ) The request for records cannot be complied by the public body within the time limits prescribed by the Freedom of Information Act, 5 ILCS 140/3(c), without unduly burdening or interfering with the operations of the public body;

(X ) There is a need for consultation, which shall be conducted with all practicable speed, with another public body or among two or more components of any public body having a substantial interest in the determination or in the subject matter of the request.

Chicago Police Department
FOIA Section

This message is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering that message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this document is strictly prohibited.

From: Coleman, Kavonnah L.

Please see the attached correspondence regarding your FOIA request.

Thank you,

K. Coleman
FOIA Officer
Chicago Police Department
Office of Legal Affairs/FOIA

Please be advised this particular E-Mail address is specifically used for correspondence to your FOIA Request already submitted. It is not for new FOIA Requests. Please do not submit new FOIA Requests to this E-Mail Address. Please continue to submit new FOIAs to<>.