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, 9:46 PM
AggieCon's Avatar
Member
   
Join Date: Nov 2015
Location: Texas
Posts: 1,367
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 10:41 PM..
Reply With Quote
Sponsored links
  #22 (permalink)  
Old 01-13-2017, 9:54 PM
Member
   
Join Date: Sep 2002
Location: Toronto, Ontario
Posts: 4,073
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, 9:57 PM
AggieCon's Avatar
Member
   
Join Date: Nov 2015
Location: Texas
Posts: 1,367
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, 10:53 PM
AggieCon's Avatar
Member
   
Join Date: Nov 2015
Location: Texas
Posts: 1,367
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, 9:18 AM
jmorgan123's Avatar
Member
   
Join Date: Sep 2010
Posts: 20
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, 8:39 AM
hfxChris's Avatar
Member
  RadioReference Database Admininstrator
Database Admin
 
Join Date: Aug 2007
Location: Dartmouth, Nova Scotia
Posts: 1,295
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
  #27 (permalink)  
Old 01-31-2017, 9:59 AM
Jay911's Avatar
Member
  Audio Feed Provider
Audio Feed Provider
Amateur Radio Operator
Amateur Radio
 
Join Date: Feb 2002
Location: Bragg Creek, Alberta
Posts: 8,625
Default

They've changed (the search) again...

Frequencies are now in Hertz. It's so much better to see 4.061375E8 for a frequency, really...

CSV downloads from searches no longer provide the header explaining which column is which, but, they have added a feature that converts cryptic flags into meaningful data (i.e. "1" in a column is replaced with what the "1" means), so I guess we've got that.

Lat/long is displayed in decimal instead of with colons in between (causing Excel to mistake it for hh:mm:ss).

Frequency Record ID - which is useful in sorting the frequencies within a given license so that you can compare them to the virtual license docs - are gone.
Reply With Quote
  #28 (permalink)  
Old 02-09-2017, 11:10 PM
jmorgan123's Avatar
Member
   
Join Date: Sep 2010
Posts: 20
Default

I don't want to jinx it, but the files were just updated and at first glance they actually look usable!
Reply With Quote
  #29 (permalink)  
Old 02-10-2017, 11:30 PM
Member
   
Join Date: Sep 2002
Location: Toronto, Ontario
Posts: 4,073
Default

Yes, the 02-02 data is ok. I was able to make a new Canada-wide reference file for FMP.
Reply With Quote
  #30 (permalink)  
Old 02-14-2017, 9:42 PM
bidulock's Avatar
Member
  Premium Subscriber
Premium Subscriber
Amateur Radio Operator
Amateur Radio
 
Join Date: Feb 2003
Location: Ardrossan Alberta
Posts: 621
Default

Quote:
Originally Posted by Jay911 View Post
They've changed (the search) again...

Frequencies are now in Hertz. It's so much better to see 4.061375E8 for a frequency, really...

CSV downloads from searches no longer provide the header explaining which column is which, but, they have added a feature that converts cryptic flags into meaningful data (i.e. "1" in a column is replaced with what the "1" means), so I guess we've got that.

Lat/long is displayed in decimal instead of with colons in between (causing Excel to mistake it for hh:mm:ss).

Frequency Record ID - which is useful in sorting the frequencies within a given license so that you can compare them to the virtual license docs - are gone.
The link is gone but a Google search produced this.

https://sms-sgs.ic.gc.ca/licenseSear...1s1&lang=en_CA

I also liked the license name search, which I haven't been able to find.

It also looks like they went back to a version from December. The newer version worked much better.

Sent from my SM-G930W8 using Tapatalk
Reply With Quote
  #31 (permalink)  
Old 02-15-2017, 11:19 AM
bidulock's Avatar
Member
  Premium Subscriber
Premium Subscriber
Amateur Radio Operator
Amateur Radio
 
Join Date: Feb 2003
Location: Ardrossan Alberta
Posts: 621
Default

Licensee Name Search Link;

https://sms-sgs.ic.gc.ca/frequencySe...execution=e4s1
Reply With Quote
  #32 (permalink)  
Old 02-15-2017, 11:45 AM
bidulock's Avatar
Member
  Premium Subscriber
Premium Subscriber
Amateur Radio Operator
Amateur Radio
 
Join Date: Feb 2003
Location: Ardrossan Alberta
Posts: 621
Default

I am also finding that the Excel Export is only providing Frequency and Class of Emission, based on my selections.
Reply With Quote
  #33 (permalink)  
Old 02-15-2017, 12:05 PM
Jay911's Avatar
Member
  Audio Feed Provider
Audio Feed Provider
Amateur Radio Operator
Amateur Radio
 
Join Date: Feb 2002
Location: Bragg Creek, Alberta
Posts: 8,625
Default

Are you referring to the CSV output you can choose after your search has returned?

In my experience, you get whatever you have selected, but (a) without headers and (2) with a large number of fields in the middle empty. So it appears you didn't get all the data you requested, but in actual fact, the fields like location and licensee name are way the heck out in the boonies in column AE onwards, or something like that.

Actually, looking at a sample I just ran, it looks like you get all columns, even the ones you didn't select - but the ones you didn't select are blank (as well as some of the ones you did choose, in my experience)... so expect location to always be in AE and callsign to be in AG, and licensee name to be in BB. Let me know if that is what you see.
Reply With Quote
  #34 (permalink)  
Old 02-15-2017, 1:44 PM
bidulock's Avatar
Member
  Premium Subscriber
Premium Subscriber
Amateur Radio Operator
Amateur Radio
 
Join Date: Feb 2003
Location: Ardrossan Alberta
Posts: 621
Default

Interesting method for exporting a csv with blank columns. Either way it still allows for proper sorting of the data and changing the frequency from scientific to decimal.

All the selected columns were there. Thanks.
Reply With Quote
  #35 (permalink)  
Old 02-16-2017, 7:33 PM
MikeOxlong's Avatar
Forums Manager/Global DB Admin
  RadioReference Database Admininstrator
Database Admin
 
Join Date: Jun 2001
Location: Central Ontario
Posts: 9,520
Default

Quote:
Originally Posted by bidulock View Post
That link takes you to Callsign or Location search. It's been mislabelled since they rolled this bloody mess of a system out.

I'll go back through my history and see if I can find the proper link. You used to be able to find a link of all the searched but they've messed that up as well.
__________________
Mike.

Sorry but I don't accept PM's. Please use email instead.
Reply With Quote
  #36 (permalink)  
Old 02-16-2017, 7:35 PM
bidulock's Avatar
Member
  Premium Subscriber
Premium Subscriber
Amateur Radio Operator
Amateur Radio
 
Join Date: Feb 2003
Location: Ardrossan Alberta
Posts: 621
Default



Sent from my SM-G930W8 using Tapatalk
Reply With Quote
  #37 (permalink)  
Old 02-16-2017, 7:53 PM
MikeOxlong's Avatar
Forums Manager/Global DB Admin
  RadioReference Database Admininstrator
Database Admin
 
Join Date: Jun 2001
Location: Central Ontario
Posts: 9,520
Default

It's borked. They've got a bunch of 3rd grade coders working for them.

Might be a problem with how they're interpreting what sort of device you're using.

On an iPhone, the link works fine. On Firefox under Windows7 and on an iPad, the link takes you to the wrong page.

If you shorten the link up to https://sms-sgs.ic.gc.ca/frequencySe...ByLicenseeName, it works no matter what device you're using.

Our government at work.
__________________
Mike.

Sorry but I don't accept PM's. Please use email instead.
Reply With Quote
  #38 (permalink)  
Old 02-21-2017, 12:58 AM
robertmac's Avatar
Member
  Premium Subscriber
Premium Subscriber
 
Join Date: Jun 2005
Posts: 1,950
Default

I assume the frequency listed is the repeater transmit frequency when doing searches on repeaters? I haven't seen any other frequency [such as input frequency] listed when doing searches the past couple of months.
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 5:59 PM.


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