FOIA - CPD - CLEAR Database Structure

J Ader filed this request with the Chicago Police Department of Chicago, IL.

It is a clone of this request.

Tracking #

P456879

Due Aug. 21, 2018
Est. Completion Sept. 4, 2018
Status
Awaiting Response

Communications

From: J Ader


To Whom It May Concern:

Pursuant to the Illinois Freedom of Information Act., I hereby request the following records:

Documents sufficient to show the table structure of the CLEAR database. This database should be in the format of a Relational Database like SQL. Please be aware that these documents are already stored electronically, therefore I request these documents be sent to us in a machine readable format (.xls or .csv will suffice).

In order to retrieve this you will have to request a database administrator who is familiar with SQL queries. Please be aware that I am looking for the names of the tables and the rows within that table. I do not seek any of 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.

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.

Sincerely,

J Ader

From: Chicago Police Department

Dear J:

Thank you for your interest in information from the Chicago Police Department. Your FOIA request has been received and is being processed. Your FOIA Center reference number for tracking purposes is: P456879-082018
You have requested the following records: Pursuant to the Illinois Freedom of Information Act., I hereby request the following records:Documents sufficient to show the table structure of the CLEAR database. This database should be in the format of a Relational Database like SQL. Please be aware that these documents are already stored electronically, therefore I request these documents be sent to us in a machine readable format (.xls or .csv will suffice). In order to retrieve this you will have to request a database administrator who is familiar with SQL queries. Please be aware that I am looking for the names of the tables and the rows within that table. I do not seek any of 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.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.
Chicago Police Department (CPD) responds to all public records requests in accordance with the Illinois Freedom of Information Act (FOIA), 5 ILCS 140/1 et seq.  If further time is needed to assemble and copy all documents responsive to your FOIA request, we will contact you with a time estimate and a request to extend. You can monitor the progress of your request at the link below and you’ll receive an email when your request has been completed. Thank you for using the Chicago FOIA Center. To monitor the progress or update this request please log into the
Chicago Public Safety Record System. (https://CHICAGOPS.mycusthelp.com/WEBAPP/_rs/RequestEdit.aspx?rid=456879&coid=79F4034E316D)

From: Chicago Police Department

Dear J Ader ,
Thank you for registering with the City of Chicago Request Center.  Please log in to the Records Center to update any contact or password information and to track the progress of your request.
Login: requests@muckrock.com

If you have never used this system or cannot remember your password, please request a Temporary Password using the Forgot Password option on the login screen.
This is an auto-generated email and has originated from an unmonitored email account. Please DO NOT REPLY.

From: Chicago Police Department

Good Afternoon,

Please see the attachment regarding FOIA P456879.

Sincerely,

FOIA Officer H. Aden
CPD FOIA Unit

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: Chicago Police Department

Good Morning J Ader,

CPD is still processing your FOIA #P456879. I'm hoping to have it to you by next week.

Thank you for your patience.

Sincerely,

FOIA Officer H. Aden
CPD FOIA Unit

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.

Files

pages

Close