Chapman v. Chicago Department of Finance

2022 IL App (1st) 200547
CourtAppellate Court of Illinois
DecidedFebruary 14, 2022
Docket1-20-0547
StatusPublished
Cited by1 cases

This text of 2022 IL App (1st) 200547 (Chapman v. Chicago Department of Finance) is published on Counsel Stack Legal Research, covering Appellate Court of Illinois primary law. Counsel Stack provides free access to over 12 million legal documents including statutes, case law, regulations, and constitutions.

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

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: 1-20-0547

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.”

-2- 1-20-0547

¶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

-3- 1-20-0547

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.

¶8 Coffing next explained “SQL” or “sequel for short,” which stands for “structured query

language” and “is the language that a database management system uses.” A SQL injection is a

type of cybersecurity attack. “A threat actor would attempt to use sequel to create a sequel

statement, which is an instruction, and it would attempt to inject that into an existing interface that

is expecting *** a field that says ‘last name’ ” and then “force the system to do something that it

-4- 1-20-0547

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

Related

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

Cite This Page — Counsel Stack

Bluebook (online)
2022 IL App (1st) 200547, Counsel Stack Legal Research, https://law.counselstack.com/opinion/chapman-v-chicago-department-of-finance-illappct-2022.