Account  |  Mobile  |  Help    
 
Home Database Live Audio Forums Wiki Classifieds Submit Info About

Go Back   The RadioReference.com Forums > Site Administration Forums > Database Discussion Forum


Database Discussion Forum Topics regarding the RadioReference Database

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #21 (permalink)  
Old 06-08-2009, 10:27 PM
georgew0819's Avatar
Member
 
Audio Feed Provider
 
Join Date: Aug 2006
Location: Newport RI
Posts: 47
Default Missing Mobile Freqs

Deleted
__________________
"Life is what happens while you are making other plans" - Lennon
______________________________________
Pro 33, Pro 41, Pro 2020, BC895XLT, Pro 197

Last edited by georgew0819; 06-08-2009 at 10:37 PM..
Reply With Quote
Sponsored links
  #22 (permalink)  
Old 06-08-2009, 10:41 PM
Member
 
Premium Subscriber
 
Join Date: Aug 2007
Posts: 133
Default

Quote:
Originally Posted by mtindor View Post
The easiest way to identify a repeater is the FB2 status if you are pulling FCC data. It's actually fairly difficult to identify repeaters via just mobile data. In fact, in the FCC records it's often fairly difficult to determine _which_ mobile frequency is the correct mobile side of a repeater pair when there is more than one repeater pair - depending on how it was submitted to the FCC to begin with.
I know about this...my point is that you can't begin to look for repeaters because the location and/or the frequency of the *mobile* units is often missing.

Quote:
Originally Posted by mtindor View Post
There are many ways to get the data you want... you just so happen to want that data in one particular way not currently supported in full and so it's an omission? Worse case scenario I may call it an "oversight."
Besides the FCC website, what other ways are you talking about?

And yes, when frequencies (or their locations) are left out, I do consider that an omission. I've said previously that I understand it's a complex problem to fix. I have a lot of respect for the people who run this website. If I didn't care about helping them out, I wouldn't bother saying anything.

Back to the original topic, I discovered another (possibly related?) problem with the mobile frequencies, this time using FCC Search by Frequency.

Check this out: RadioReference 161.535 search in California

Note that license WXP305 shows 161.535 at Crestline, Ludlow, and Barstow (all locations in California). Click on the license in RR and then the FCC license...161.535 is used at "Location 9" which is a 40 km radius from a point in New Mexico about 700 miles from those California sites. I don't know how or why, but the RR database (at least the FCC Search by Frequency db) is making up erroneus locations...
Reply With Quote
  #23 (permalink)  
Old 06-08-2009, 10:59 PM
georgew0819's Avatar
Member
 
Audio Feed Provider
 
Join Date: Aug 2006
Location: Newport RI
Posts: 47
Default Location Errors

Quote:
Originally Posted by seligman View Post
I know about this...my point is that you can't begin to look for repeaters because the location and/or the frequency of the *mobile* units is often missing.



Besides the FCC website, what other ways are you talking about?

And yes, when frequencies (or their locations) are left out, I do consider that an omission. I've said previously that I understand it's a complex problem to fix. I have a lot of respect for the people who run this website. If I didn't care about helping them out, I wouldn't bother saying anything.

Back to the original topic, I discovered another (possibly related?) problem with the mobile frequencies, this time using FCC Search by Frequency.

Check this out: RadioReference 161.535 search in California

Note that license WXP305 shows 161.535 at Crestline, Ludlow, and Barstow (all locations in California). Click on the license in RR and then the FCC license...161.535 is used at "Location 9" which is a 40 km radius from a point in New Mexico about 700 miles from those California sites. I don't know how or why, but the RR database (at least the FCC Search by Frequency db) is making up erroneus locations...
I'm not sure this error is related to the RR Database. See FCC ULS page ULS License - Industrial/Business Pool, Conventional License - WXP305 - BNSF Railway Co - Locations Summary and it lists locations in NM and KS for that license. These problems may rest with the way the FCC manages the information and not necessarily in the way RR pulls the FCC data. I'm sure this doesn't help, although it may explain why things are occuring this way.
__________________
"Life is what happens while you are making other plans" - Lennon
______________________________________
Pro 33, Pro 41, Pro 2020, BC895XLT, Pro 197
Reply With Quote
  #24 (permalink)  
Old 06-08-2009, 11:00 PM
Member
 
Premium Subscriber
 
Join Date: Aug 2007
Posts: 133
Default

Quote:
Originally Posted by loumaag View Post
I think you have a slight misunderstanding of how the RR Database works. The Lat/Lon information will eventually get into the RR DB, as it is entered by the DB Admins; but that information will be based on service area and be based on either user submission or DB Admin experience.
No offense, but I'm more confused than ever. <g>

Unless I said otherwise in this thread, the database I've been referring to is the FCC license database, not the identified frequencies database. I'm not sure why the DB admin experience, service area, or user submissions, would be needed for the FCC database.

Quote:
Originally Posted by loumaag View Post
The entity FCC search you are using has absolutely nothing to do with the RR Database. The FCC database that you are searching on is the same database available at fcc.gov.
Perhaps I'm reading into this too literally, but if true, why are the results different? I was under the impression that RR downloads the FCC files every so often and assembles their own database. So even though the source files are theoretically the same, the database might not be. Yes / no?

Quote:
Originally Posted by loumaag View Post
While I agree that mobile data on licenses that can be identified by location should be included on the return from that search, most mobile information does not have a location at all and hence will probably never appear as a return.
I don't follow you where you said, "most mobile information does not have a location at all." Do you mean a location written out in words (i.e. CHICAGO RADIO TOWER in CHICAGO, IL)? Nearly every mobile frequency I've seen has a location within a specified radius of a fixed site, or a set of fixed coordinates.

Thanks for answering my questions.
Reply With Quote
  #25 (permalink)  
Old 06-08-2009, 11:10 PM
OH/WV DB Admin
 
Database Admin

Audio Feed Provider
 
Join Date: Dec 2006
Location: Jefferson County, Ohio
Posts: 2,402
Send a message via MSN to mtindor
Default

Quote:
Originally Posted by seligman View Post
I don't know how or why, but the RR database (at least the FCC Search by Frequency db) is making up erroneus locations...
Erroneous location?

1. Those FCC searches are just that - searches of the FCC database, not the RRDB. Do not mistake the two, and understand that what is in the FCC database is under the FCC's control and not RR's control. So, take your finger and point it squarely at the FCC.

2. I don't see a problem. The FCC license indicates that 161.535 is a mobile frequency used in a radius around San Mateo Mexico (location 6).

So, 161.535 mobile frequency (location 9) is paired up with the FB2 frequencies listed on location 6 (160.245 to be exact).

The FCC records are the ones indicating that there is a repeater output (160.245) in San Mateo NM with a mobile input frequency of 151.535.

Mike

Last edited by mtindor; 06-08-2009 at 11:12 PM..
Reply With Quote
Sponsored links
  #26 (permalink)  
Old 06-08-2009, 11:30 PM
Member
 
Premium Subscriber
 
Join Date: Aug 2007
Posts: 133
Default

Quote:
Originally Posted by mtindor View Post
Erroneous location?
1. Those FCC searches are just that - searches of the FCC database, not the RRDB. Do not mistake the two, and understand that what is in the FCC database is under the FCC's control and not RR's control. So, take your finger and point it squarely at the FCC.
I'm afraid you're not listening to what I'm saying.

The RR site, specifically the box labelled "Search FCC Licenses By State" is supplying erroneous locations that don't appear on the FCC license, whether viewed on the FCC website or the RR website.

I don't understand why you think it's the FCC's fault. The bottom line is that RR is contradicting itself. Mistakes happen, that's why I'm here trying to help you guys...
Reply With Quote
  #27 (permalink)  
Old 06-09-2009, 12:20 AM
OH/WV DB Admin
 
Database Admin

Audio Feed Provider
 
Join Date: Dec 2006
Location: Jefferson County, Ohio
Posts: 2,402
Send a message via MSN to mtindor
Default

Quote:
Originally Posted by seligman View Post
I'm afraid you're not listening to what I'm saying.

The RR site, specifically the box labelled "Search FCC Licenses By State" is supplying erroneous locations that don't appear on the FCC license, whether viewed on the FCC website or the RR website.
Ok, so in the case of the 161.535 CA search, what _you_ would _expect_ to see is no results provided for licenses such as KMA356, since the only reference to 161.535 on that that particular license is a reference to a 40 km radius around San Mateo - not in Barstow or any other location in CA within 40 km of San Mateo NM.

I get what you're saying now. I have appended some more information onto the ticket that is open.

Mike
Reply With Quote
  #28 (permalink)  
Old 06-09-2009, 11:40 AM
loumaag's Avatar
Moderator
 
Database Admin
 
Join Date: Dec 2002
Location: Katy, TX
Posts: 10,303
Default

Quote:
Originally Posted by seligman View Post
...my point is that you can't begin to look for repeaters because the location and/or the frequency of the *mobile* units is often missing.
Please. The location of the repeater is set in the FCC license. The mobile frequency used as the input for a repeater is often not known and is of secondary importance to the purpose of the actual RR DB on this site. You certainly don't need to know the repeater input frequency to find a repeater.

Quote:
Originally Posted by seligman View Post
And yes, when frequencies (or their locations) are left out, I do consider that an omission. I've said previously that I understand it's a complex problem to fix. I have a lot of respect for the people who run this website. If I didn't care about helping them out, I wouldn't bother saying anything.
And we appreciate your efforts to help us get our database updated with correct information.

Quote:
Originally Posted by seligman View Post
Back to the original topic, I discovered another (possibly related?) problem with the mobile frequencies, this time using FCC Search by Frequency.

Check this out: RadioReference 161.535 search in California

Note that license WXP305 shows 161.535 at Crestline, Ludlow, and Barstow (all locations in California). Click on the license in RR and then the FCC license...161.535 is used at "Location 9" which is a 40 km radius from a point in New Mexico about 700 miles from those California sites. I don't know how or why, but the RR database (at least the FCC Search by Frequency db) is making up erroneus locations...
The problem is related but in a different way. I will explain that and then you might understand. When searching for a frequency and a state you are actually searching for licenses in a state that have that frequency on them. That is the extent of the search. When an entity applies for a license they may (and many do) include several locations for that license. Note that I said the search is fairly simple, it looks for licenses in a state that have the frequency on them. In the case of a mobile frequency, there seems to be an inconsistency, that is in this example on the initial return from the RR Frequency search 161.535 only appears once for license KMA356 but 3 times for WXP305 even though the actual FCC license has exactly the opposite data. Hopefully this will get fixed when Lindsay looks into it; however, please note that location data for mobiles is still not going to be included since I don't think the convoluted "area around a fixed point" data is imported by Lindsay.

Quote:
Originally Posted by seligman View Post
No offense, but I'm more confused than ever. <g>

Unless I said otherwise in this thread, the database I've been referring to is the FCC license database, not the identified frequencies database. I'm not sure why the DB admin experience, service area, or user submissions, would be needed for the FCC database.

Perhaps I'm reading into this too literally, but if true, why are the results different? I was under the impression that RR downloads the FCC files every so often and assembles their own database. So even though the source files are theoretically the same, the database might not be. Yes / no?

I don't follow you where you said, "most mobile information does not have a location at all." Do you mean a location written out in words (i.e. CHICAGO RADIO TOWER in CHICAGO, IL)? Nearly every mobile frequency I've seen has a location within a specified radius of a fixed site, or a set of fixed coordinates.

Thanks for answering my questions.
Yes, periodically portions of the FCC DB is imported for various reasons into the RR servers so that license information is available to the RR DB faster than linking to the FCC DB. It also allows mapping and the searches that are the subject of this thread. The location data that is imported (to the best of my knowledge) is the fixed point data that is included if you look at a license using the license link (e.g. KMA356); note on that example, locations 4, 6, 7, & 8 have no location data.

Quote:
Originally Posted by seligman View Post
I'm afraid you're not listening to what I'm saying.

The RR site, specifically the box labelled "Search FCC Licenses By State" is supplying erroneous locations that don't appear on the FCC license, whether viewed on the FCC website or the RR website.

I don't understand why you think it's the FCC's fault. The bottom line is that RR is contradicting itself. Mistakes happen, that's why I'm here trying to help you guys...
It is a mistake, but as explained above it is either you get the return because the license has the frequency on it, or you get no return on mobile frequencies at all since they have no locations associated with them. I don't think that Lindsay is going to expend the man hours to duplicate the geographical search engine that is already available on the FCC site so that the simple look-ups available now are altered to accommodate the exact return you seem to be searching for.
__________________
Lou Maag

Rules and Guidelines for Forum Post Content
Reply With Quote
  #29 (permalink)  
Old 06-09-2009, 07:18 PM
Member
 
Premium Subscriber
 
Join Date: Aug 2007
Posts: 133
Default

Quote:
Originally Posted by loumaag View Post
Please. The location of the repeater is set in the FCC license. The mobile frequency used as the input for a repeater is often not known and is of secondary importance to the purpose of the actual RR DB on this site. You certainly don't need to know the repeater input frequency to find a repeater.
Can I give you a real life example where this comes up? I think we're looking at this from opposite angles, so I'd like to illustrate it.

I came across radio traffic that could pass as a repeater input frequency or perhaps just simplex. All I knew for sure is that I heard only half the conversation. The signal strength came and went, suggesting the person was mobile. I tried (and failed) to locate a possible repeater output in the field.

Later, at home, I entered that frequency into this site's FCC search box. Many licenses were returned for my state. Because the location (radius area) for mobile units is usually not listed, nor is the relationship to any fixed location, I had no idea which frequencies with FB2 class might possibly be the repeater output. All licenses put together, there were probably 25 possible FB2 frequencies.

I realize that some licensees put their MO and FB2 frequencies on separate licenses, in which case, the same difficulty exists with both RR and the FCC sites. Nothing can be done about this.

Like you, I wouldn't expect Lindsay to create a full geographic search like the FCC offers. I have an idea that might (or might not?) be easy for you guys to implement. Here it goes.

On licenses with both fixed and mobile stations - where the mobile location is in relation to a fixed site - use the fixed site's location for the mobile location.

Then add two columns to the license pages. The first column could be called "Related Site Number". If, say, location 7 for mobile stations is a 40 km radius around location 1, show location 1 in this field for the location 7 frequencies. The second column "Mobile Radius" would show the radius. In this example, 40 km (or the equivalent distance in miles) would be displayed. For fixed sites, leave these fields blank, because they wouldn't apply.

It's just something to be considered. No hard feelings if it can't be done.
Reply With Quote
Sponsored links
  #30 (permalink)  
Old 06-10-2009, 10:10 AM
loumaag's Avatar
Moderator
 
Database Admin
 
Join Date: Dec 2002
Location: Katy, TX
Posts: 10,303
Default

An interesting suggestion and the "trouble" ticket that Mike submitted references this thread so Lindsay probably will see it.

My curiosity got the best of me and I did some wild guessing. Based on your story and the fact that you were concentrating on 161.535 earlier I went to to the FCC Advanced Search page and then ran a geographic search for the entire state of CA and was surprised by the result. The FCC geographic search returned only one license, WNXJ220, which, interestingly enough, happens to use that frequency in a FB situation. It apparently ignored all the mobile license use for the frequency in the state. Thinking that this was because I asked for the entire state, I re-ran the search and narrowed it down to Contra Costa Co. (where the WNXJ220 was located) and got the same single result even though at least one more license (KNBL452) is located in the county, indeed in the same town, with a mobile use of the frequency.

For those of you reading this and unfamiliar with the FCC Geographic Search, I used it because all of the BNSF license (AFAIK) are licensed out of Kansas, so searching for licenses from California (on the main search page) would return nothing.
__________________
Lou Maag

Rules and Guidelines for Forum Post Content
Reply With Quote
  #31 (permalink)  
Old 06-15-2009, 05:00 PM
blantonl's Avatar
Administrator
 
Database Admin

Audio Feed Provider
 
Join Date: Dec 2000
Location: San Antonio, TX
Posts: 6,096
Default

I've received the trouble ticket and I am looking into the issue.

Thanks,
__________________
Lindsay C. Blanton III
President - RadioReference.com LLC
Facebook: RadioReference | Twitter: @RadioReference
Reply With Quote
  #32 (permalink)  
Old 10-13-2009, 03:49 PM
blantonl's Avatar
Administrator
 
Database Admin

Audio Feed Provider
 
Join Date: Dec 2000
Location: San Antonio, TX
Posts: 6,096
Default

Folks, I'm pleased to report that this issue has been resolved. Turns out we had a small bug in the query... this same bug affected the printable FCC reports that was previously fixed.

I also tweaked some things as well with the query which should increase performance for these queries as well.

Enjoy!! And thanks for bringing this to my attention!
__________________
Lindsay C. Blanton III
President - RadioReference.com LLC
Facebook: RadioReference | Twitter: @RadioReference
Reply With Quote
Reply

Bookmarks

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
texas motor speedway medic9351301 Texas Radio Discussion Forum 6 05-15-2009 12:47 AM
Fx2 ????? ka5lqj Louisiana Radio Discussion Forum 3 01-18-2009 11:16 PM
Help with railroad frequencies. KC0QR Nebraska Radio Discussion Forum 14 05-21-2008 07:10 PM
scanning in Fort Scott? NosyNeighbor Kansas Radio Discussion Forum 2 03-21-2005 10:17 AM
Question regarding FCC classification code milf General Scanning Forum 6 05-21-2004 01:22 PM


All times are GMT -5. The time now is 04:47 AM.


Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
All information here is Copyright 2009 by RadioReference.com LLC and Lindsay C. Blanton III.Ad Management by RedTyger
Copyright 2009 by RadioReference.com LLC Privacy Policy  |  Terms and Conditions