FOIA - CPD - CLEAR Database Structure

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)

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.

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.

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.

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.

You need to sign (type your full name to your Request for Review).

Thanks,

Mary Jo Vail
Administrative Secretary
Office of the Illinois Attorney General
Public Access Bureau
100 West Randolph Street
11th floor
Chicago, Illinois 60601
312-814-5607

E-MAIL CONFIDENTIALITY NOTICE: This electronic mail message, including any attachments, is for the intended recipient(s) only. This e-mail and any attachments might contain information that is confidential, legally privileged or otherwise protected or exempt from disclosure under applicable law. If you are not a named recipient, or if you are named but believe that you received this e-mail in error, please notify the sender immediately by telephone or return e-mail and promptly delete this e-mail and any attachments and copies thereof from your system. If you are not the intended recipient, please be aware that any copying, distribution, dissemination, disclosure or other use of this e-mail and any attachments is unauthorized and prohibited. Your receipt of this message is not intended to waive any applicable privilege or claim of confidentiality, and any prohibited or unauthorized disclosure is not binding on the sender or the Office of the Illinois Attorney General. Thank you for your cooperation

Thanks

Please find the attached correspondence from AAG Draws.

Please contact us if you have any questions. Thank you.

Hattie Bryant
Office Assistant
Illinois Attorney General
Public Access Bureau
500 South Second Street
Springfield, IL 62706
(217) 785-7377

E-MAIL CONFIDENTIALITY NOTICE: This electronic mail message, including any attachments, is for the intended recipient(s) only. This e-mail and any attachments might contain information that is confidential, legally privileged or otherwise protected or exempt from disclosure under applicable law. If you are not a named recipient, or if you are named but believe that you received this e-mail in error, please notify the sender immediately by telephone or return e-mail and promptly delete this e-mail and any attachments and copies thereof from your system. If you are not the intended recipient, please be aware that any copying, distribution, dissemination, disclosure or other use of this e-mail and any attachments is unauthorized and prohibited. Your receipt of this message is not intended to waive any applicable privilege or claim of confidentiality, and any prohibited or unauthorized disclosure is not binding on the sender or the Office of the Illinois Attorney General. Thank you for your cooperation.

Please find the attached correspondence from AAG Draws.

Please contact us if you have any questions. Thank you.

Hattie Bryant
Legal Secretary
Public Access Bureau
500 South Second Street
Springfield, IL 62706
(217) 785-5526

E-MAIL CONFIDENTIALITY NOTICE: This electronic mail message, including any attachments, is for the intended recipient(s) only. This e-mail and any attachments might contain information that is confidential, legally privileged or otherwise protected or exempt from disclosure under applicable law. If you are not a named recipient, or if you are named but believe that you received this e-mail in error, please notify the sender immediately by telephone or return e-mail and promptly delete this e-mail and any attachments and copies thereof from your system. If you are not the intended recipient, please be aware that any copying, distribution, dissemination, disclosure or other use of this e-mail and any attachments is unauthorized and prohibited. Your receipt of this message is not intended to waive any applicable privilege or claim of confidentiality, and any prohibited or unauthorized disclosure is not binding on the sender or the Office of the Illinois Attorney General. Thank you for your cooperation.