Access to Information Orders
Decision Information
BACKGROUND: In 1999, the Ministry of the Environment (the Ministry) implemented a mandatory vehicle inspection and maintenance program called the "Drive Clean" program. The purpose of the program is to detect and reduce smog-related emissions from cars, trucks and buses. The Ministry states: The Drive Clean program was designed with four specific performance targets, and they have guided the development and implementation of the program since its inception: a) to reduce smog-causing pollutants by means of testing and repairing vehicles; b) to consistently achieve a high degree of public acceptance for the program. This target is met by a wide mix of private sector facilities located throughout Ontario, reasonable access times for customers, affordable test fees, and high standards of information access and customer services; c) to consistently achieve a high level of acceptance by the vehicle inspection industry and repair industry sectors; and d) to consistently achieve a high degree of business integrity by ensuring "zero tolerance" for non-compliance by Drive Clean facilities with program requirements. The Ministry points out that similar programs exist in other jurisdictions, and states that Ontario's program has been one of the most successful in significantly reducing emissions from motor vehicles and in meeting the program's performance targets. The requirements of the Drive Clean program are set out in Regulation 361/98 made under the Environmental Protection Act and Regulation 628/90 made under the Highway Traffic Act . These regulations establish various emissions testing standards and requirements for the operation and registration of various types of vehicles in Ontario. Results from vehicle testing under the Drive Clean program are gathered and stored electronically in computer systems maintained by the Ministry. The Ministry explains: Gas emission results of every vehicle tested in the program are stored in the Drive Clean database, along with the identification of the vehicle, the license plate number [assigned by the Ministry of Transportation (the "MTO") to the vehicle], service facility identification, and Inspector or Technician identification. There are currently over 3,300,000 such records in the database. The vehicle identification and plate numbers are the same data as contained in the MTO vehicle registration database. The remainder of the data is unique to the Drive Clean database. The Ministry's Drive Clean database also contains specific "garage identifiers", also referred to as the "DCF Number" or the "Station ID." The Ministry explains that a garage identifier is a "4-digit numerical string" that is assigned to a Drive Clean facility: Each Drive Cleanfacility has its own garage identifier. It is used to identify the facility for all aspects of the Program. To a Drive Clean facility, the garage identifier is its own unique Drive Clean identification number. NATURE OF THE APPEAL: The Ministry received a request under the Freedom of Information and Protection of Privacy Act (the Act ) for access to information about inspections carried out by facilities under the Drive Clean program in electronic format. The requester did not identify any particular source or database for the information. The Ministry identified the responsive record as the data elements of the Ministry's Drive Clean program, excluding any portions that might reveal the identity of individuals. The Ministry denied access to this record pursuant to section 18 (economic and other interests). The requester (now the appellant) appealed that decision (Appeal PA-010121-1). After conducting an inquiry, I issued Order PO-1980. In it, I found that the data elements relating to the Drive Clean program did not qualify for exemption under section 18. I also provided the parties with direction on the format of the record, as follows: Finally, I would like to address the issue of format. The appellant indicates in his original request letter that he wants access in electronic format, as well as hardcopy printed versions of the first 50 records contained in the database. By that, I assume the appellant is interested in receiving access to paper copies that contain all data gathered through the emissions testing process for 50 vehicles, subject to severance of the specific data elements that have been removed from the scope of his request. In my view, although my order determines that section 18(1) does not apply to the records at issue in this appeal, it is not clear to me that the appellant, quite understandably, has been provided with sufficient information to make an informed determination of how much and in what format he wishes to receive the information from the Ministry. I have concluded that most appropriate way of proceeding at this stage is for the Ministry to provide the appellant with the printed content of a representative sample of 50 emission test results. This will put the appellant in a position to determine what further information he requires, and in what format, which will then allow the Ministry to determine what fees, if any, are required in order to comply with the provisions of this order. I will remain seized of the appeal in order to deal with any issues that arise in this context that cannot be resolved by the parties. In compliance with Order PO-1980, the Ministry issued a decision to the appellant and provided him with the hardcopy version of a representative sample of 50 vehicle emission test results, with certain items of information removed. The Ministry also estimated that the total fee for producing the entire record would be $593. In response, the appellant advised the Ministry that the hardcopy version of the record did not contain the unique garage identifiers, and that he wanted access to this information. The appellant also objected to the fee. The Ministry responded by advising the appellant that disclosing the garage identifiers would reveal information about identifiable test facilities, and that this could not be done without their consent. The Ministry also revised the fee as follows: Based on our discussions, the total fees for your request have been recalculated as follows: Records Preparation 9 hours @ $30 $270 Compact Disks 5 @ $10/disk 50 Shipping 3 Total $323 The appellant appealed the Ministry's decision regarding both access to the garage identifiers and the fee. The Ministry's position on th
Decision Content
BACKGROUND
In 1999, the Ministry of the Environment (the Ministry) implemented a mandatory vehicle inspection and maintenance program called the “Drive Clean” program. The purpose of the program is to detect and reduce smog-related emissions from cars, trucks and buses.
The Ministry states:
The Drive Clean program was designed with four specific performance targets, and they have guided the development and implementation of the program since its inception:
a) to reduce smog-causing pollutants by means of testing and repairing vehicles;
b) to consistently achieve a high degree of public acceptance for the program. This target is met by a wide mix of private sector facilities located throughout Ontario, reasonable access times for customers, affordable test fees, and high standards of information access and customer services;
c) to consistently achieve a high level of acceptance by the vehicle inspection industry and repair industry sectors; and
d) to consistently achieve a high degree of business integrity by ensuring “zero tolerance” for non-compliance by Drive Clean facilities with program requirements.
The Ministry points out that similar programs exist in other jurisdictions, and states that Ontario’s program has been one of the most successful in significantly reducing emissions from motor vehicles and in meeting the program’s performance targets.
The requirements of the Drive Clean program are set out in Regulation 361/98 made under the Environmental Protection Act and Regulation 628/90 made under the Highway Traffic Act. These regulations establish various emissions testing standards and requirements for the operation and registration of various types of vehicles in Ontario.
Results from vehicle testing under the Drive Clean program are gathered and stored electronically in computer systems maintained by the Ministry. The Ministry explains:
Gas emission results of every vehicle tested in the program are stored in the Drive Clean database, along with the identification of the vehicle, the license plate number [assigned by the Ministry of Transportation (the “MTO”) to the vehicle], service facility identification, and Inspector or Technician identification. There are currently over 3,300,000 such records in the database. The vehicle identification and plate numbers are the same data as contained in the MTO vehicle registration database. The remainder of the data is unique to the Drive Clean database.
The Ministry’s Drive Clean database also contains specific “garage identifiers”, also referred to as the “DCF Number” or the “Station ID.” The Ministry explains that a garage identifier is a “4-digit numerical string” that is assigned to a Drive Clean facility:
Each Drive Clean facility has its own garage identifier. It is used to identify the facility for all aspects of the Program. To a Drive Clean facility, the garage identifier is its own unique Drive Clean identification number.
NATURE OF THE APPEAL:
The Ministry received a request under the Freedom of Information and Protection of Privacy Act (the Act) for access to information about inspections carried out by facilities under the Drive Clean program in electronic format. The requester did not identify any particular source or database for the information.
The Ministry identified the responsive record as the data elements of the Ministry’s Drive Clean program, excluding any portions that might reveal the identity of individuals. The Ministry denied access to this record pursuant to section 18 (economic and other interests).
The requester (now the appellant) appealed that decision (Appeal PA-010121-1).
After conducting an inquiry, I issued Order PO-1980. In it, I found that the data elements relating to the Drive Clean program did not qualify for exemption under section 18. I also provided the parties with direction on the format of the record, as follows:
Finally, I would like to address the issue of format. The appellant indicates in his original request letter that he wants access in electronic format, as well as hardcopy printed versions of the first 50 records contained in the database. By that, I assume the appellant is interested in receiving access to paper copies that contain all data gathered through the emissions testing process for 50 vehicles, subject to severance of the specific data elements that have been removed from the scope of his request. In my view, although my order determines that section 18(1) does not apply to the records at issue in this appeal, it is not clear to me that the appellant, quite understandably, has been provided with sufficient information to make an informed determination of how much and in what format he wishes to receive the information from the Ministry. I have concluded that most appropriate way of proceeding at this stage is for the Ministry to provide the appellant with the printed content of a representative sample of 50 emission test results. This will put the appellant in a position to determine what further information he requires, and in what format, which will then allow the Ministry to determine what fees, if any, are required in order to comply with the provisions of this order. I will remain seized of the appeal in order to deal with any issues that arise in this context that cannot be resolved by the parties.
In compliance with Order PO-1980, the Ministry issued a decision to the appellant and provided him with the hardcopy version of a representative sample of 50 vehicle emission test results, with certain items of information removed. The Ministry also estimated that the total fee for producing the entire record would be $593.
In response, the appellant advised the Ministry that the hardcopy version of the record did not contain the unique garage identifiers, and that he wanted access to this information. The appellant also objected to the fee.
The Ministry responded by advising the appellant that disclosing the garage identifiers would reveal information about identifiable test facilities, and that this could not be done without their consent. The Ministry also revised the fee as follows:
Based on our discussions, the total fees for your request have been recalculated as follows:
Records Preparation 9 hours @ $30 $270
Compact Disks 5 @ $10/disk $ 50
Shipping $ 3
Total $323
The appellant appealed the Ministry’s decision regarding both access to the garage identifiers and the fee.
The Ministry’s position on the garage identifiers raises the potential application of section 17(1) of the Act (third party information). I advised the parties that, because this exemption is mandatory, I was required by virtue of sections 50(3) and 52(13) of the Act to notify the individual Drive Clean facilities (the facilities) as affected parties and provide them with an opportunity to make representations before deciding whether the garage identifiers fell within the scope of the exemption.
I then sent a Notice of Inquiry to the Ministry, setting out the issues and seeking representations. I also notified the 2,132 facilities, inviting them to participate in the appeal and to ask for a copy of the Notice of Inquiry on the section 17 issue. A total of 667 facilities requested and were provided with a copy of the Notice, and 438 provided representations, either individually or through a representative on behalf of a group of facilities. The Ministry also submitted representations.
I then sent a copy of the Notice of Inquiry to the appellant, together with the non-confidential portions of the Ministry’s representations and a representative sample of the representations submitted by the facilities. The appellant responded with representations.
RECORDS:
Order PO-1980 dealt with all data elements from the Drive Clean program other than those that had been removed from the scope of the request, and the garage identifiers. This includes the Drive Clean test results from each facility.
The record in this appeal consists of the one final responsive data element - the specific garage identifiers.
$30/hour
$ 30.00
Running queries on database |
3 hours |
$30/hour |
$ 90.00 |
Creation of Excel file detailing field names and data structure |
2 hours |
$30/hour |
$ 60.00 |
Exporting records to CD-ROM |
3 hours |
$30/hour |
$ 90.00 |
Compact discs |
5 |
$10/disc |
$ 50.00 |
Shipping |
|
|
$ 3.00 |
TOTAL
|
|
|
$323.00 |
Representations
Ministry
The Ministry submits that “the fee estimate of $323 should be upheld as it is an accurate and reasonable assessment of the costs of preparing the records for disclosure to the appellant.”
The Ministry states that the fee estimate is based on information provided by the Systems Contract Advisor of the Drive Clean Office, who has extensive knowledge of the records and the databases used for the Drive Clean program.
The Ministry states:
The fee estimate provided to the appellant was based on the time and resources required to prepare a representative sample of 50 records. This sample was prepared in accordance with the requirements set out in Order PO-1980 issued on December 20, 2001 by Assistant Commissioner Tom Mitchinson. …
The Ministry also submits that:
It should also be noted that the time estimates provided for the calculation of the fee estimate were determined by estimating the cost to prepare the representative sample of 50 records. The actual number of records to be provided to the appellant is approximately 2 million. Accordingly, it is likely that the actual time spent preparing the final records package for the appellant will be higher than that used in providing the fee estimate. In addition, further review of the costs to prepare the records for disclosure identified the additional time required to complete the manual steps 5 and 10 described [below]. These manual steps will involve 4 hours in the case of step 5 and 5 hours in the case of step 10. Despite the increased costs, the Ministry is not proposing to modify the fee estimate.
The Ministry also points out that extra time may be required to process the request. Specifically, it will:
[L]ikely require a minimum of 4 hours of staff time to manually remove exempt records from the data to be released to the appellant. While this time may be chargeable as “preparation time”, the Ministry chose to exclude the time from the fee estimate. In addition, the Ministry expects to spend at least 5 hours verifying the records to ensure proper data transfer.
The Ministry assesses no fees for manual search time.
As far as computer costs for locating, retrieving, processing and copying the records are concerned, the Ministry states that the necessary data is stored in two Oracle Database tables that are maintained by a contractor on behalf of the Ministry. The Ministry provides the following explanation of the steps it would need to extract the data from these databases:
1 – Determination of appropriate fields and date range of information to extract from Oracle database.
2 – Two Oracle SQL statements will be created that will select the exact fields and date range for the information that is being requested: One for Light Duty Vehicles/Heavy Duty Non-Diesel Vehicles, one for Heavy Duty Diesel Vehicles (1 hour).
3 – The two queries will be double-checked against the list of fields authorized for release and to ensure accuracy.
4 – The queries will be run on the Oracle database and 2 tables will be created [and] moved into the Drive Clean Office’s MS SQL 2000 database. This step will speed up the export of data into an acceptable format for the appellant as MS SQL 2000 is more user friendly for data exporting than Oracle and will also allow removal of records that are not being released (see step 5). The queries will be run after hours [so] as not to impact the production Drive Clean System (3 hours).
5 – Exempt data records will be removed from the data set prior to export (4 hours).
6 – The 2 tables will be double-checked to ensure the correct number of fields and correct data range has been extracted.
7 – The number of rows in the 2 MS SQL 2000 tables will be recorded.
8 – An Excel file will be prepared that lists the Field Name and data structure for each field. This is necessary in order for someone to use and import the data into another database (2 hours).
9 – The 2 tables will be exported into comma delimited text files using monthly date ranges to facilitate transfer to CD ROMs. We will likely need several CD ROMs for each table (estimate 5) (3 hours).
10 – Each CD Rom will be tested by re-importing text files into the DCO SQL 2000 database. The data set will be compared to the original data set in order to ensure that the correct number of records has been exported (5 hours).
As far as preparation charges are concerned, the Ministry submits that it must:
Manually remove any fields and records that are exempt from public release (e.g. VIN). Format electronic data to allow for export to CD-ROM for use by appellant and transfer of responsive records to CD-ROM for delivery.
The Ministry submits that the total amount of time to prepare the records for release to the appellant is “9 hours, based on the time to prepare the representative sample of 50 records as provided by staff knowledgeable about the records and their retrieval.”
Appellant
The appellant accepts the $30 fee for writing the Oracle SQL statements.
As far as the $60 fee for the document listing the field names and data structure is concerned, the appellant states that “as the Ministry has already provided a paper printout with the field definitions, the Excel file proposed to be created will not be required.”
The appellant submits that “previous orders have disallowed charges for computer run time”, and that the Ministry should not be able to charge the $90 fee for running queries to extract the data or the $90 fee for copying the records to CD-ROM. He submits:
Only the time spent by an operator actually setting up the copy operation can be charged, as well as the nominal amount of time it takes to change CDs in the CD burner (even these fees may be encompassed within the $10 per disk fee).
In any case, fast CD burners today can burn one disk in just a few minutes. The ministry proposes to take almost 40 minutes per disk.
In summary, the appellant submits that:
The Ministry can charge for one hour for creating SQL statements, and for the actual time taken by an operator during the process of copying the data to CD-ROM.
In response to the Ministry’s suggestion that the work will actually take longer than they are charging for, the appellant points out what he describes as redundancies:
Step 5, for example, seems redundant as step 2 has already selected “the exact data fields.” This makes perfect sense. Why would the Ministry include the exempt fields when it first exports the data from Oracle. And having left them out, why would they need to be removed later?
Double checking data once exported is not chargeable and neither is the testing listed under step 10.
Findings
Because the appellant no longer wants a record detailing field names and data structure, the $60 charge for this record is removed from the fee.
The appellant accepts the $30 charge for creating the SQL statements; and the $3 shipping charges and $50 fee for compact discs would not appear to be in dispute.
The two remaining fee items, $90 for running queries on the database and $90 for exporting records to CD-ROMs, would appear, based on the descriptions provided by the Ministry, to represent the time required for the computer system to generate the required output based on the two queries. As the appellant points out, previous orders have found that time spent by an individual running reports from a computer system are chargeable “preparation fees” under section 6 of Regulation 460, but as former Adjudicator Holly Big Canoe stated in Order M-1083:
… It should be noted, however, that [the institution] can only charge for the amount of time spent by any person on activities required to generate the reports. The [institution] cannot charge for the time spent by the computer to compile the data, print the information or for the use of materials and/or equipment involved in the process of generating a record.
(See also Order MO-1456)
Following this reasoning, I find that the $180 fee for running queries on the database and exporting the records to CD-ROMs is not permitted under the Act and regulations, and is not chargeable.
Therefore, I do not uphold the Ministry’s fee decision, and find that it should be reduced from $323 to $83, for the reasons outlined above.
FORMAT:
In his original request to the Ministry, the appellant sought access to “electronic records recording information about inspections carried out by garages under the Drive Clean program”. He did not specify any particular source of this information, but did ask the Ministry to provide him with translations for all codes used in the responsive records.
In correspondence sent by the appellant to the Ministry following the issuance of Order PO-1980, he reiterates that he did not ask for information from any specific database, only for “electronic records” containing the requested information. He states:
The request also specifically refers to “database(s)”, further underlining that this is not a request for any single database, and asks for translations for all codes, which include the unique garage ID.
As the file containing the garage name and address information is inherent to the understanding of the test readings table and provides the required translation of the garage ID field, it is by definition included in this request whether it is a related table in the same database, or a table in another database.
In appealing the Ministry’s decision to deny access to the garage identifiers, the appellant again makes the point that he is seeking access to whatever electronic records would best respond to his request and not access to information contained in a specific database. He also makes reference to this point in his representations submitted during the course of this inquiry.
It is clear that, throughout the lengthy proceedings stemming from his original request, the appellant has repeatedly and consistently described the type of information he considers to be responsive, and the format in which it should be disclosed. The Ministry has also acknowledged during the course of the appeal that information relating to the Drive Clean program is stored in more than one database. Based on my review of the file, it would appear that the garage identifier computer code linked to the test results is contained in one database, and more extensive details about the individual garage, such as name and address, is contained in another database.
In my view, in order to provide the appellant with the access to information that is responsive to his clearly worded request, the Ministry must access all of its electronic information holdings relating to the Drive Clean program, extract the pertinent information from the various data fields, and provide the appellant with electronic access to all information that addresses the various aspects of the request. If, as would appear to be the case here, the garage identifier code is in one database and more descriptive information about the individual garage is in the other, then the relevant portions of both databases must be provided to the appellant. Because all personal information has been removed from the scope of the appellant’s request, and I have determined that section 17(1) has no application, there is nothing inappropriate about providing the appellant with access to electronic data that can be “matched” in ways that best meet his particular needs.