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

Est. Completion Sept. 4, 2018
Status
Fix Required

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.

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: J Ader

To whom it may concern,

I would like to appeal this denial.

Chicago's DoIT is an example of a nearby agency that has released a mysql dump of the data dictionary to FOI through FOIA - https://www.muckrock.com/foi/chicago-169/data-dictionary-mysql-dump-59229. By DoIT providing this information, it highlights that database schemas are specifically releasable through FOIA. FOI has since used the dump to create its own instance of the datab dictionary, which I highly recommend your department review for understanding what sort of database schema information has passed infosec review: https://metalicious.freeourinfo.com.

If there is an actual need for some private information to be redacted, I am ultimately willing to have responsive documents with redactions here as well.

Thanks, and let me know if anything else is needed from my end.
-J. Ader

From: Chicago Police Department

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

From: J Ader

Revised with full name below:
-------
To whom it may concern,

I would like to appeal this denial.

Chicago's DoIT is an example of a nearby agency that has released a mysql dump of the data dictionary to FOI through FOIA - https://www.muckrock.com/foi/chicago-169/data-dictionary-mysql-dump-59229. By DoIT providing this information, it highlights that database schemas are specifically releasable through FOIA. FOI has since used the dump to create its own instance of the datab dictionary, which I highly recommend your department review for understanding what sort of database schema information has passed infosec review: https://metalicious.freeourinfo.com.

If there is an actual need for some private information to be redacted, I am ultimately willing to have responsive documents with redactions here as well.

Thanks, and let me know if anything else is needed from my end.
-Jake Ader

From: Chicago Police Department

Thanks

From: Chicago Police Department

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.

Files

pages

Close