Export Search Results to Text File
This screen allows you to export the results of your query into ASCII text files, which can be imported into Microsoft Excel or many other software packages for you to perform further analysis of the results.
A note about the files available below
When viewing this page in English the ASCII files available for download are formatted as comma separated values with a file header containing some file meta data. The files are able to be opened correctly in English installations of spreadsheet applications such as Microsoft Excel. A French installation of a spreadsheet application may require additional parameters when opening or importing the files. Being text based, they also open perfectly well in any text editor application.
When viewing this page in French the ASCII files available for download are formatted as semicolon separated values with a file header containing some file meta data. The files are able to be opened correctly in French installations of spreadsheet applications such as Microsoft Excel. The file contains numeric values formatted in using the Canadian (French-speaking) decimal format for numbers which is typically defined in the regional settings for the application opening the files. Being text based, they also open perfectly well in any text editor application.
Due to the complexity of the data returned by the DFRP, you will have to download several files to get the entire query result.
- Property Records - This file contains the property records returned by your query. This contains information such as the name, location, custodian organization, and use of the property.
Please note that if a property is parcelled, each parcel will have a record in the file. A non-parcelled property will only have one record of a parcel number 0. A parcelled property will have its records of a non-zero parcel number. For example, if a property is parcelled into three parcels, there will be three records for the property in the file, with each record of a parcel number 1, 2, or 3 respectively. If interested in getting the count of the properties based on the file, open it with Microsoft Excel, find the row number of the first data record (it is normally 17) and that of the last data record (for example, 505), type in a blank cell the formula, =SUM(IF(FREQUENCY(A17:A505,A17:A505)>0,1)), where "A17" represents the first column (i.e., the DFRP Property Number column) at row 17 and "A505" the first column at row 505, and press the Enter key. Then the cell will show you the count of properties.
- Building Records - This file contains the building records returned by your query, with the exception of the structure use types and tenant records.
- Building Use Type Records - This file contains the Use Types of each building returned by your query. There may be multiple Use Types specified for each building.
- Building Tenant Records - This file contains the tenant records for each building returned by your query. The tenant record includes the name of the tenant, and the floor area they occupy.