Calculate Potential Fines Based on Number of Non-Submitting Buildings

[alexkcode]

Calculate the total amount of potential fines based on the number of non-compliant buildings in the data according to this ordinance: https://www.chicago.gov/content/dam/city/progs/env/EnergyBenchmark/SO2017-7060.pdf

1. Get latest Environment Sustainable dataset from the Chicago Data Portal here. The export can be found here: Chicago_Energy_Benchmarking_20240220_superset.csv
2. Find number of buildings not in compliance with city emission data requirements and their associated square footage.
3. Map buildings to fine levels based on building square footage.
4. Sum total fines based on those fines associated to the buildings

Buildings that are non-compliant will show "Not Submitted" in the Reporting Status column of the data. The data in the link shown above should already be filtered.

[vkoves]

Since the data set (2019 - 2023 buildings that didn't submit) contains 2,905 buildings and the latest notice says a max fine is of $9,200, that's a total of $26,726,000 in potential fines ($26.7 million dollars!)

Here's a screenshot from the notice of the fines:

[alexkcode]

If we use the minimum fine given from the notice ($100) we get the first number shown $290,500, if we use the maximum given the notice ($9,200) the total fines would be $26,726,000.