Industry Canada changing its licensing records system and lookup

Status
Not open for further replies.

Jay911

.
Joined
Feb 15, 2002
Messages
9,188
Location
Bragg Creek, Alberta
Spectrum Applications Modernization - Spectrum Management and Telecommunications

The above is a FAQ page for "Spectrum Applications Modernization" which is a project Industry Canada (the custodian of radio spectrum in Canada) is undertaking. They are replacing their in-house records management system for spectrum licensing with a commercial off the shelf product called "SPECTRA Enterprise" by LS telcom.

One might hope that the records will have more data available to the public in the future, in a similar vein to the FCC lookup (categorizing licenses by commercial/public safety/other, conventional/trunk, etc).

It would appear that the first groups to be migrated to the new system will be microwave (>960MHz) licensees. From the "presentation" linked below, it looks like land mobile radio will be migrated in phase 2, in late 2014 to mid 2015.

SAM-CSI Pilot Release: Information for Microwave Clients - Spectrum Management and Telecommunications

Of interest to RR users who look up radio information using Industry Canada search engines or static data files is the last question in the FAQ:

I hear that the monthly Technical and Administrative Frequency List (TAFL) information on the Web will be discontinued. Is that correct?
Industry Canada has an obligation to make the licensing information available to the public. The TAFL provided a full list of all disclosed frequencies. For now, the TAFL will continue for frequencies that are out of scope for this launch. The new system will allow you to search for individual frequencies within the scope of this launch. It should be feasible for clients who want the complete list in order to set up a program to search in a repetitive fashion and build the list themselves. The TAFL was always published a month behind the current status. The new search function will be more accurate because the data will be current.
If I get more info I will post it where/when I can. I posted the announcement here because it has pertinence to all parts of Canada, and cross-posting in multiple forums is prohibited.
 

hfxChris

Member
Database Admin
Joined
Aug 18, 2007
Messages
1,308
Location
Dartmouth, Nova Scotia
So in other words it sounds like, we will no longer make the monthly .txt dumps available on our site, instead feel free to DDOS our search feature with thousands upon thousands of automated requests in order to build your own list.

Also, thanks for posting that Jay. As somebody who uses that at least weekly, it's good info.
 

Jay911

.
Joined
Feb 15, 2002
Messages
9,188
Location
Bragg Creek, Alberta
I have done many an intensive search on Spectrum Direct without much problems. I have searched for every frequency licensed in a 500km radius around Calgary and the only grief I got was that I had to break up my search into chunks of spectrum (i.e. 0-25, 25-138, 138-160, etc) because I kept hitting the 60,000 record maximum. (I can remember when it was a 2,000 record maximum!)

I know I've said it before, but the textual TAFL downloadable data files are actually very sparse in useful information, with many fields truncated well before their max char length in the DB, and you only get certain fields that IC feels are necessary in the files. Besides the fact they are almost always a month out of date by the time you get them, that's the reason I tend to avoid using them.

I have no idea what SPECTRA Enterprise is like. It could be more robust, especially if other governments are using it for their spectrum RMS. To boot, if it supports truly automated queries (which SD doesn't appear to now), it could even allow RR to finally have license lookups on its Canadian pages like it does for the FCC in the US listings.
 

Jay911

.
Joined
Feb 15, 2002
Messages
9,188
Location
Bragg Creek, Alberta
The Microwave portion appears to have gone live.

Home - Spectrum Management System

Some of the searches are non-functional right now; the data appears incomplete. (I did a frequency range search and got some results, but the descriptive location and licensee name fields are blank.)

Changes I've noticed from Spectrum Direct:

- the search pages allow you to specify different categories of records (point-to-point, point-to-multipoint, etc, as far as the microwave search is concerned).
- transmit and receive freqs are listed separately, instead of on the same line.
- latitude and longitude is specified in the search results as ddd:mm:ss. Leading zeros appear to be dropped, so what used to show up as 730502 now shows up as 73:5:2. In the search page for geographic areas, degrees/minutes/seconds are separated into six separate fields (and, like many other services these days, but for reasons I can't understand, longitude is now listed before latitude). (As an aside, I wish you could enter decimal degrees in these searches, and/or retrieve results in the same format!)
- there are scroll bars in the results, internal to the web page (i.e. not just the main page scroll bar itself).
- results are paginated (i.e. like threads here on the forum are paginated after 50 posts) with 10 records per page. I really dislike this idea, because I do a number of cut and paste activities regularly on large searches. Maybe I need to explore CSV results more (see below).
- you can request CSV download and/or PDF download instead of an online HTML display. CSV shows all the data in one file, of course, non-paginated etc. PDF appears to be an HTML4 table representation of the data without pagination.
- Some of the fields use unexpected formats, such as the lat/long as listed above. Frequency is listed in MHz but with commas (i.e. "2,211.25"). EDIT: Actually, this is a function of importing the CSV into Excel; they're saved as straight numbers.
- A number of the fields that are blank in the current data have their data represented elsewhere. Example: "Occupied Bandwidth" is shown as the first part of the "Class of Emission" (i.e. 6M00G7WDT). Frequency Record ID is blank, Tx Channel Capacity is blank; Rx Channel Capacity is also blank, as are a number of the antenna-specific fields. Licensee Name is, as I said before, empty, but the licensee name is appended to the Licensee Address (possibly in error).
- Results are limited (unknown to how many, though I got 47 pages/477 records at one point) in HTML. Unsure if the CSV and/or PDF results are similarly limited.
- The geographic breakdowns are now by province, not region. So you can request just Alberta, you don't have to take "Prairies, Northwest Territories, and Nunavut".

Here's a sample of the CSV that I just downloaded, with all fields activated.

Code:
Tx or Rx	Frequency (MHz)	Occupied Bandwidth [kHz]	ITU Class of Station	Class of Emission	Conformity to Frequency Plan	Frequency Record ID	Tx Channel Capacity	Tx Total Losses [dB]	Tx Transmitter Power [dBW]	Tx Effective Radiated Power (ERP) [dBW]	Tx Antenna Beamwidth [deg]	Tx Antenna Gain [dBi > 960MHz, dBd < 960MHz]	Tx Antenna Polarization	Tx Antenna Azimuth [deg]	Tx Antenna Vertical Elevation Angle [deg]	Tx Antenna Height Above Ground [m]	Tx Antenna Model Number	Rx Channel Capacity	Rx Total Losses [dB]	Rx Threshold Level for BER 10e-3 [dBW]	Unfaded Received Signal Level [dBW]	Rx Antenna Beamwidth [deg]	Rx Antenna Gain [dBi > 960MHz, dBd < 960MHz]	Rx Antenna Polarization	Rx Antenna Azimuth [deg]	Rx Antenna Vertical Elevation Angle [deg]	Rx Antenna Height Above Ground [m]	Rx Antenna Model Number	License Number	Call Sign	Latitude (WGS84)	Noise Environment Code	License Type	Station Location	Longitude (WGS84)	Antenna Structure Height AGL [m]	Transportable Radius [km]	Mobile Radius of Operation [km]	Licensee Name	Account Number	In-Service Date	Licensee Address
RX_RES	2,097.50		FX	500KG7WDT	SRSP_302.0_FS_2025-2285_M_CS1250K_D			4.1	0	0		29.5	V	282.2	-0.3	58	P-22A72G		4.1				29.5	V	282.2	-0.3	58	P-22A72G	010022069-001	CZL394	51:36:50		Fixed : Point-to-Point	     	112:19:41	60	0	0		23080011225	2014-02-24T00:00:00-05:00	 CAN T5J 3H1 Edmonton  Suite 300, 10123 - 99 Street Govt of AB, JSG, AFRRCS-Microwave
RX_RES	2,097.50		FX	500KG7WDT	SRSP_302.0_FS_2025-2285_M_CS1250K_D			2.3	0	0		29.5	V	332.5	0	25	P-22A72G		2.3				29.5	V	332.5	0	25	P-22A72G	010022071-001	CZL500	56:06:03		Fixed : Point-to-Point	     	118:24:21	107	0	0		23080011225	2014-02-25T00:00:00-05:00	 CAN T5J 3H1 Edmonton  Suite 300, 10123 - 99 Street Govt of AB, JSG, AFRRCS-Microwave
RX_RES	2,105.00		FX	500KG7WDT	SRSP_302.0_FS_2025-2285_M_CS1250K_D			2.1	0	0		29.5	V	318.4	-0.1	23	P-22A72G		2.1				29.5	V	318.4	-0.1	23	P-22A72G	010022073-001	CZL636	52:40:01		Fixed : Point-to-Point	     	113:17:59	60	0	0		23080011225	2014-03-06T00:00:00-05:00	 CAN T5J 3H1 Edmonton  Suite 300, 10123 - 99 Street Govt of AB, JSG, AFRRCS-Microwave
RX_RES	2,083.75		FX	500KG7WDT	SRSP_302.0_FS_2025-2285_M_CS1250K_D			4.3	0	0		29.5	V	251	-0.1	58	P-22A72G		4.3				29.5	V	251	-0.1	58	P-22A72G	010022075-001	CZL638	54:29:13		Fixed : Point-to-Point	     	111:23:03	122	0	0		23080011225	null	 CAN T5J 3H1 Edmonton  Suite 300, 10123 - 99 Street Govt of AB, JSG, AFRRCS-Microwave
RX_RES	2,086.25		FX	500KG7WDT	SRSP_302.0_FS_2025-2285_M_CS1250K_D			4.5	0	0		29.5	V	160	-0.1	45	P-22A72G		4.5				29.5	V	160	-0.1	45	P-22A72G	010022077-001	CZL639	54:24:43		Fixed : Point-to-Point	     	111:45:15	130	0	0		23080011225	null	 CAN T5J 3H1 Edmonton  Suite 300, 10123 - 99 Street Govt of AB, JSG, AFRRCS-Microwave
TX_RES	2,097.50		FX	500KG7WDT	SRSP_302.0_FS_2025-2285_M_CS1250K_D			3.2	0.1	42.7		29.5	V	101.8	0.1	40	P-22A72G		3.2				29.5	V	101.8	0.1	40	P-22A72G	010022069-001	CZL402	51:40:43		Fixed : Point-to-Point	     	112:49:03	91	0	0		23080011225	2014-02-24T00:00:00-05:00	 CAN T5J 3H1 Edmonton  Suite 300, 10123 - 99 Street Govt of AB, JSG, AFRRCS-Microwave
TX_RES	2,097.50		FX	500KG7WDT	SRSP_302.0_FS_2025-2285_M_CS1250K_D			2.3	0.1	52.5		29.5	V	152.3	-0.2	24	P-22A72G		2.3				29.5	V	152.3	-0.2	24	P-22A72G	010022071-001	CZL499	56:18:15		Fixed : Point-to-Point	     	118:35:48	107	0	0		23080011225	2014-02-25T00:00:00-05:00	 CAN T5J 3H1 Edmonton  Suite 300, 10123 - 99 Street Govt of AB, JSG, AFRRCS-Microwave
TX_RES	2,105.00		FX	500KG7WDT	SRSP_302.0_FS_2025-2285_M_CS1250K_D			1.5	0.1	63.1		29.5	V	138.2	-0.1	12	P-22A72G		1.5				29.5	V	138.2	-0.1	12	P-22A72G	010022073-001	CZL637	52:50:34		Fixed : Point-to-Point	     	113:33:31	107	0	0		23080011225	2014-03-06T00:00:00-05:00	 CAN T5J 3H1 Edmonton  Suite 300, 10123 - 99 Street Govt of AB, JSG, AFRRCS-Microwave
TX_RES	2,083.75		FX	500KG7WDT	SRSP_302.0_FS_2025-2285_M_CS1250K_D			3.8	0.1	37.2		29.5	V	70.6	-0.1	50	P-22A72G		3.8				29.5	V	70.6	-0.1	50	P-22A72G	010022075-001	CZL639	54:24:43		Fixed : Point-to-Point	     	111:45:15	130	0	0		23080011225	null	 CAN T5J 3H1 Edmonton  Suite 300, 10123 - 99 Street Govt of AB, JSG, AFRRCS-Microwave
TX_RES	2,086.25		FX	500KG7WDT	SRSP_302.0_FS_2025-2285_M_CS1250K_D			5.8	0.1	23.4		29.5	V	340.1	-0.1	55	P-22A72G		5.8				29.5	V	340.1	-0.1	55	P-22A72G	010022077-001	CZL640	54:09:59		Fixed : Point-to-Point	     	111:36:05	107	0	0		23080011225	null	 CAN T5J 3H1 Edmonton  Suite 300, 10123 - 99 Street Govt of AB, JSG, AFRRCS-Microwave
 
Status
Not open for further replies.
Top