RadioReference on Facebook   RadioReference on Twitter   RadioReference Blog
 

Go Back   The RadioReference.com Forums > Canada Radio Discussion Forums > Multi-Province Frequencies and Systems

Multi-Province Frequencies and Systems - Forum for discussion of frequencies and systems which cover more than one province.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #21 (permalink)  
Old 01-13-2017, 10:46 PM
AggieCon's Avatar
Member
   
Join Date: Nov 2015
Location: Texas
Posts: 1,221
Default

Also, IC, please use some random character or combination of characters for separating the fields. Something that is highly unlikely to be included in any of the data fields, e.g. the pipe |

Surely someone at the FCC would be willing to lend some advice?

EDIT: The pipe is no good, it's present in the data. I second using tilde ~

Last edited by AggieCon; 01-13-2017 at 11:41 PM..
Reply With Quote
Sponsored links
  #22 (permalink)  
Old 01-13-2017, 10:54 PM
Member
   
Join Date: Sep 2002
Location: Toronto, Ontario
Posts: 3,664
Default

Quote:
Originally Posted by Jay911 View Post
A new dump was made today and it looks much better than before.
The hell it does.

Who's this licensee on 422.6375? No, you can't look at the old dump data.

Code:
Old:  TX,422637500,0000524061,14,D,A,LM_CAN_UHF_DUPLEX3_6K25,C2646,,D,4000,4K00F1DNN,LMR-DIGITAL,1,79.4328048780487804878048780487804878049,100,6.5,1,,-,-,* Other Manufacturer (not listed) * - * Autre fabricant (non inclus) *,SD-312Q,,,,,B,338,,,,,VFW952,8,FX,,ORONTO, ONT. 301 FRONT ST (CN TWR,,ON,43.6425,-79.38722222,76,553,H,,,010394303-001,Land Mobile,Base-Mobile Systems,S,G,16-OCT-15,042090000663,Mobile Business Communications Ltd.,24 Mallard Road M3B 1S1 North York ON,O,,0,0,
New:  TX;4000;FX;4K00F1DNN;LM_CAN_UHF_DUPLEX3_6K25;0000524061;A;422637500;1;;6.5;-;-;100;79.4328048780487804878048780487804878049;;;B;;;338;SD-312Q;-;010394303-001;VFW952;43.6425;-79.38722222;H;;ON;Non-Developmental;TORONTO, ONT. 301 FRONT ST (CN TWR);338;;;;;;042090000663;2015-10-16 00:00:00;24 Mallard Road   ;010394303-001;;;N;2009-01-23 00:00:00;C2646;79.4328048780487804878048780487804878049;79.4328048780487804878048780487804878049;100;;0;0;;B;;79.4328048780487804878048780487804878049;


Old:  RX,422637500,0000524094,,D,A,LM_CAN_UHF_DUPLEX3_6K25,C2646,,D,4000,4K00F1DNN,LMR-DIGITAL,,-,-,,,,,,,,,,,,,0,,,,,,3,ML,Not licensed,ORONTO, ONT. 301 FRONT ST (CN TWR,,ON,43.6425,-79.38722222,,,,50000,,010394303-001,Land Mobile,Base-Mobile Systems,S,G,16-OCT-15,042090000663,Mobile Business Communications Ltd.,24 Mallard Road M3B 1S1 North York ON,-,-,-,-,
New:  RX;4000;ML;4K00F1DNN;LM_CAN_UHF_DUPLEX3_6K25;0000524094;A;422637500;;;;;;-;-;;;;;;0;;-;010394303-001;;43.6425;-79.38722222;;;ON;Non-Developmental;TORONTO, ONT. 301 FRONT ST (CN TWR);0;50000;50000;Not licensed;;;042090000663;2015-10-16 00:00:00;24 Mallard Road   ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
This latest dump is unusable. Every time they take a stab at this, they look like fools. The parties involved in design, implementation, testing and supervision all appear to be grossly incompetent. Will they ever choose a delimiter that isn't already present in the data? Protip: Tilde is available... And will they ever learn how to format values to the appropriate number of decimal places? Or are the coordinates, power levels, etc in their database actually accurate to ~10 decimal places? And why is every record padded from ~400 characters to 1000 with ~600 trailing spaces?? What possible (good) reason could there be to bulk up 400 megs of data to a full gigabyte? How did someone's cousin's son fresh out of high school get this gig?
Reply With Quote
  #23 (permalink)  
Old 01-13-2017, 10:57 PM
AggieCon's Avatar
Member
   
Join Date: Nov 2015
Location: Texas
Posts: 1,221
Default

I have a August 2016 file. They used the semicolon back then.

I'm interested where they store all of these records. Google Docs?
Reply With Quote
  #24 (permalink)  
Old 01-13-2017, 11:53 PM
AggieCon's Avatar
Member
   
Join Date: Nov 2015
Location: Texas
Posts: 1,221
Default

Quote:
Originally Posted by slicerwizard View Post
Who's this licensee on 422.6375? No, you can't look at the old dump data.
I don't know. Just: 79.4328048780487804878048780487804878049

It's all you need to know.

79.4328048780487804878048780487804878049

That's some good rounding on the ~septillionth place. It's crucial that the 8 was rounded up to 9. Someone could have ended up with catastrophic radio failure if that was done incorrectly.

Addition: The precision of this database dump is just outstanding. They have their data more precise than the smallest force ever measured. The Canadian Science Industry Agency is really on to something here. http://newscenter.lbl.gov/2014/06/26...ever-measured/
Reply With Quote
  #25 (permalink)  
Old 01-16-2017, 10:18 AM
jmorgan123's Avatar
Member
   
Join Date: Sep 2010
Posts: 19
Default

I received a response from the Open Government website team:

"Innovation, Science and Economic Development Canada is in the process of replacing those datasets which are outdated and might be misleading and result in error, given that many spectrum users utilize this information to perform technical analysis to ensure electromagnetic compatibility in the Radio Frequency (RF) environment. New Technical and Administrative Frequency Lists (TAFL) datasets are scheduled for release in February 2017."

I'll believe it when I see it! I'm just a hobbyist. There must be a lot of unhappy commercial users of this data.
Reply With Quote
Sponsored links
  #26 (permalink)  
Old 01-18-2017, 9:39 AM
hfxChris's Avatar
Member
  RadioReference Database Admininstrator
Database Admin
 
Join Date: Aug 2007
Location: Dartmouth, Nova Scotia
Posts: 1,292
Default

Keep us posted!

And thanks for running your TAFL search site, even if it's a bit out of date it's still my go-to for data.
__________________
Pro-97 | Pro-137 | Pro-2055 | BCD396XT | BCT15X | BCD996XT | HP-1 | Kenwood R1000 | R820T | Afedri SDR-Net
Reply With Quote
Reply

Tags
tafl

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -5. The time now is 2:08 AM.


Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
All information here is Copyright 2012 by RadioReference.com LLC and Lindsay C. Blanton III.Ad Management by RedTyger
Copyright 2015 by RadioReference.com LLC Privacy Policy  |  Terms and Conditions