Data format isn't CSV, but fixed-width text. Not quite as easy to digest, but still useful.
ONTARIO REGION TECHNICAL AND ADMINISTRATIVE FREQUENCY LIST (TAFL) REPORT
Retired. Replaced by the SMS Authorization Data Extract.
- Publisher - Current Organization Name: Innovation, Science and Economic Development Canada
- Publisher - Organization Name at Publication: Industry Canada
- Licence: Open Government Licence - Canada
|SMS Authorization Data Extract||Superseded by||Open Data||
Geographic Region Name:
This dataset is terribly formatted, and the related file description/schema is incorrect. It's a complete mess to try to use this data for anything. Why not put column headers on the file, and provide it in a delimited format so that users can just open and use the data?
The following response has been posted on behalf of Industry Canada : "Thank you for your comments regarding the difficulties you are having with “ONTARIO REGION TECHNICAL AND ADMINISTRATIVE FREQUENCY LIST (TAFL) REPORT”. We have many clients that use this dataset for a myriad of uses. Industry Canada has been publishing the TECHNICAL AND ADMINISTRATIVE FREQUENCY LIST (TAFL) data on its Internet site http://www.ic.gc.ca/eic/site/tafl-ltaf.nsf/eng/home since the mid 1990s and many clients have developed automated systems that download and process the data files. However, changes will be coming. We are currently in the process of updating our entire licensing database. As a result, there will be changes to the way in which this information will be available in the future. The first of these changes will occur for microwave licences in the coming week. Consequently if you want microwave assignments after this week, they will be available from another source, and in a different form. Other service lines will be implemented over the coming few years. Links will be available on our website http://www.ic.gc.ca/eic/site/sd-sd.nsf/eng/home. Please also refer to this website for upcoming notices of future changes to the licensing database". Thank you
Please note that much of the link information has now been removed, and the TAFL files are now about a third the size they used to be. The promised microwave link database has been removed from the Spectrum Management site, and there is now no way of tracing links and owners. This is not acceptable.
The following response has been posted on behalf of Industry Canada : "Industry Canada is updating its Spectrum Management System (SMS). The Technical and Administrative Frequency List (TAFL) is being phased out but the same data will be available through a web search portal that will replace the “Radio Frequency Search” features of Spectrum Direct. Some licences have already moved to the new system and are no longer available in TAFL. Our new system required changes to licence structure and data that make licences in the new system incompatible with the TAFL format. Unfortunately, we are still resolving some errors in the new system and many of the new search features are not yet available. The new searches replace the functionality found at http://www.ic.gc.ca/eic/site/sd-sd.nsf/eng/h_00025.html but with the new licence data structure. Full access to our licence data will be available again once the errors are resolved. TAFL will be discontinued following project completion. It has been kept with limited data as a courtesy to licensees who are working in services and bands that were not included in our first project phase". Thank you.
You need someone with a database or GIS background to format your data for you. This is the most poorly formatted piece of data I've seen, but not surprising considering it comes from a government agency! It's Open Data but who wants to use it? As was mentioned in previous user comments - put in some column headers and provide it in a delimited format.
Thank you for your comment. The following response has been posted on behalf of Industry Canada : "The space-delimited format of the Technical and Administrative Frequency List (TAFL) files was established many years ago. We realize that this format is now very outdated, but external stakeholders who actively use this data have asked us to limit any changes. The Industry Canada web site already has data searches that may better meet your needs than the TAFL file format. Currently, we are conducting a multi-year project to implement a new license database, data structures, and on-line services. Our new system supports comma-delimited data, and XML format is in development. When this new system is complete, the TAFL download will be obsolete and discontinued. The Government of Canada remains committed to making government datasets available to the public, and will post an update when the new data is uploaded.”
This dataset is no longer available at the linked location. This, and other TAFL data, has moved to a new system and links need to be updated.
Reginald, Thanks for your comment - we have reported this to the data holder to be addressed. All the best, Karin - open-ouvert team