Chapman v. Chicago Department of Finance

2022 IL App (1st) 200547
Appellate Court of Illinois·Decided February 14, 2022·No. 1-20-0547·Published·Cited by 1 cases

Opinion

2022 IL App (1st) 200547

FIRST DISTRICT

FIRST DIVISION

February 14, 2022

No. 1-20-0547

MATT CHAPMAN, ) Appeal from the ) Circuit Court of

Plaintiff-Appellee, ) Cook County )

v. ) No. 18 CH 14043 )

THE CHICAGO DEPARTMENT OF ) The Honorable FINANCE, ) Sanjay T. Tailor, ) Judge Presiding.

Defendant-Appellant.

JUSTICE COGHLAN delivered the judgment of the court, with opinion.

Presiding Justice Hyman and Justice Walker concurred in the judgment and opinion.

OPINION

¶1 Following a bench trial, the trial court granted plaintiff Matt Chapman’s Freedom of Information Act (FOIA) (5 ILCS 140/1 et seq. (West 2018)) request directed at defendant the Chicago Department of Finance (Department), seeking disclosure of an “index of the tables and columns within each table” of the Citation Administration and Adjudication System (CANVAS), a system used to store, process, and track citation information for parking tickets, speed-light camera tickets, stoplight traffic tickets, booting, and towing tickets. On appeal, the Department argues that the requested information was exempt from disclosure because it constituted a “file layout” and its dissemination “would jeopardize” the security of the CANVAS system and database. We affirm.

¶2 I. BACKGROUND

¶3 On August 30, 2018, Chapman submitted the following to the Department:

“To Whom It May Concern:

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

An index of the tables and columns within each table of CANVAS. Please include the column data type as well.

Per the CANVAS specifications, the database in question is Oracle, so the below SQL query will likely yield the records pursuant to this request:

select utc .column_name as colname, uo.object_name as tablename, utc.data_type from user_objects uo

join user_tab_columns utc on uo.object_name = utc.table_name where uo.object_type = ‘TABLE’

The requested documents will be made available to the general public, and this request is not being made for commercial purposes.

***

Sincerely,

Matt Chapman – Free Our Info, NFP”

On September 12, 2018, the Department notified Chapman of its decision to deny his request, stating that the requested records were exempt from disclosure because the “dissemination of [the] pieces of network information could jeopardize the security of the systems of the City of Chicago.” On September 17, 2018, Chapman disputed the Department’s decision, arguing that “database schemas are specifically releasable through FOIA.” 1 On October 2, 2018, after consulting with the City of Chicago’s (City) law department, the Department reiterated its decision to deny the FOIA request.

1 Chapman stated that the released records would be added to Chicago’s public “Data Dictionary”

(a/k/a “metalicious”) and “will be used for further research of parking tickets.”

¶4 On November 1, 2018, Chapman filed a complaint, asserting a “willful violation of the Freedom of Information Act, to respond to [his] Freedom of Information Act requests seeking records regarding database schema information of CANVAS, a system used to store parking ticket information.” The parties filed cross-motions for summary judgment. The Department’s motion included the affidavit of Bruce Coffing, chief information security officer with the city’s Department of Innovation and Technology (DoIT), attesting that the “[r]elease of the requested information, especially in combination with the information already made public about the CANVAS system, would jeopardize the security of not only the CANVAS system and database, but also the data contained therein.” Chapman’s motion included the affidavit of Thomas Ptacek, an information and software security “vulnerability researcher,” attesting that “[w]ith respect to the security of a computer application backed by a database, knowledge of the ‘schema’—the collection of tables and their constituent columns—would, in a competently built system, be of marginal value to the adversary.” Following a hearing, the trial court denied the cross-motions for summary judgment, finding a factual issue regarding the meaning of “marginal value” as stated in Ptacek’s affidavit. At trial, both Coffing and Ptacek testified.

¶5 Coffing has worked in cybersecurity for about 22 years. He testified that the CANVAS system stores “sensitive information,” consisting of “first name and last name of the primary vehicle owners and the secondary vehicle owner, driver’s license numbers, addresses, whether or not there is handicap parking related to that individual, [and] information about who wrote the tickets.” Coffing stated that CANVAS is a “competently built system” that was built based on the best practices in the industry.

¶6 Coffing also testified that he is responsible for protecting the CANVAS system from a “cyberattack,” which occurs when an unauthorized user of the CANVAS system “is attempting to achieve a goal that is not in alignment for business purposes for that system.” To prevent a

cyberattack, “a layer of defense” is employed, consisting of “numerous controls that all build upon each other to provide a defense against adversaries.” One layer of defense includes “limiting the information that’s known about a system, so that the adversary has less to capture in their efforts to perform recognizance about the system.” By restricting the information that is available, an attacker would have to be more “noisy,” which alerts defenders that an attack is underway. The activity of an “attacker” who has precise information about the target system “may blend in and look like normal activity in the system.” Attacks made by people with more knowledge of the system are more precise and effective than attacks made by people who are just conducting recognizance.

¶7 Coffing stated that Chapman requested a “file layout” because “table names and column names” are “the information that the database management system uses to create the structure of the database” that stores the data. He explained that using file layouts or source listings, “threat actor[s] would perform recognizance on a target or a system and *** would use this information to more precisely craft their attacks, again to limit the noise that they would make to limit the likelihood of them being detected.” He stated that Chapman’s request undermines “the layer defense” strategy because, “by addressing the information that’s available on the system,” more information is available “for a threat actor to perform recognizance again to more precisely tailor their attacks.” Coffing acknowledged that Chapman’s request did not seek any of the actual data in the field, such as parking ticket, red light camera, or speed camera data.

Free access — add to your briefcase to read the full text and ask questions with AI

Chapman v. Chicago Department of Finance, 2022 IL App (1st) 200547 (Ill. Ct. App. 2022).

2022 IL App (1st) 200547 (Chapman v. Chicago Department of Finance) — published by Counsel Stack Legal Research, free access to 12M+ legal documents.

Related

Chapman v. Chicago Department of Finance
2023 IL 128300 (Illinois Supreme Court, 2023)