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
  #1 (permalink)  
Old 11-01-2009, 01:31 PM
MPSCS's Avatar
Member
 
Premium Subscriber
 
Join Date: Jul 2008
Location: S.E. Michigan
Posts: 1,466
Question Why do we retain Michigan's obsolete frequencies?

The majority of conventional and trunked analog frequencies in the database for Michigan are obsolete, and have been for some time. It's very confusing for someone new entering into the hobby, and presents a lot of needless clutter for all of us. I had ask one time why they were being maintained and the response was that they may be activated again in the event something goes wrong with MPSCS. It's unlikely that will happen in most cases because the infrastructures and equipment has either been pulled, or are no longer functional.

I'm thinking if they still need to be available they could be moved to the Wiki, and just keep the database listings for current, active frequencies and talk groups.

What does everyone think?

Thanks!
__________________

Reply With Quote
Sponsored links
  #2 (permalink)  
Old 11-01-2009, 02:04 PM
Wiki Admin
 
Database Admin
 
Join Date: Jul 2002
Location: Glen Burnie, Md.
Posts: 8,955
Default

A better solution; send the updates to the DBA team via the submit link. That way with the updates in place people using the web service will get up to date information.

Of course, things under investigation should go to the wiki 73 Mike
__________________
links editor, Utility Monitoring Central
Wiki Administrator, HF Forum moderator, RadioReference
Friends don't let friends buy Scancat Lite Plus!
Reply With Quote
  #3 (permalink)  
Old 11-01-2009, 02:15 PM
MPSCS's Avatar
Member
 
Premium Subscriber
 
Join Date: Jul 2008
Location: S.E. Michigan
Posts: 1,466
Default

Theres no real problem in the database with the updates. It's kept up to date very well. The issue is with maintaining the old obsolete data. The DBA teams know it's there, because there are subtle notes to that effect. I guess I just don't understand why it's being maintained.
__________________

Reply With Quote
  #4 (permalink)  
Old 11-01-2009, 02:28 PM
Wiki Admin
 
Database Admin
 
Join Date: Jul 2002
Location: Glen Burnie, Md.
Posts: 8,955
Default

I thought I made it clear, but maybe not - so let's try this again -

If no one tells the DBA that some data is obsolete - not with 'subtle notes', but with a ticket created by an individual - then the data just stays there.

'Subtle notes' doesn't get the job done. Get a ticket created with the updates and track it - if nothing is done in say, a week, then yell about it. 'nuff said.

73 Mike
__________________
links editor, Utility Monitoring Central
Wiki Administrator, HF Forum moderator, RadioReference
Friends don't let friends buy Scancat Lite Plus!
Reply With Quote
  #5 (permalink)  
Old 11-01-2009, 02:55 PM
MPSCS's Avatar
Member
 
Premium Subscriber
 
Join Date: Jul 2008
Location: S.E. Michigan
Posts: 1,466
Default

Quote:
Originally Posted by ka3jjz View Post
I thought I made it clear, but maybe not - so let's try this again -

If no one tells the DBA that some data is obsolete - not with 'subtle notes', but with a ticket created by an individual - then the data just stays there.

'Subtle notes' doesn't get the job done. Get a ticket created with the updates and track it - if nothing is done in say, a week, then yell about it. 'nuff said.

73 Mike
Mike, you're missing my point completely! Maybe it is me that hasn't made things clear. So I will try this again.

It is the DBA team that is leaving the subtle notes within the database, not me!

Look at Macomb County as an example:
Macomb County, Michigan (MI) Scanner Frequencies and Radio Frequency Reference

Michigan Public Safety Communications System (MPSCS)
Project 25 Standard All public safety operations in Macomb County are on the MPSCS TRS, with the exception of the city of Warren.
Warren Public Safety Project 25 System
Project 25 Standard All public safety operations in the cities of Centerline and Warren use this TRS.

Yet below these headers are listings of the old analog systems that are for the most part no longer in use.

Even within the obsolete listings they have similar notes like this:
460.15000 KQA783 RM123.0 PLMacombShrf 3 Sheriff [F-3] [Has moved to the MPSCS TRS]

Do you see what I am saying?

Thanks
__________________

Reply With Quote
Sponsored links
  #6 (permalink)  
Old 11-01-2009, 03:07 PM
Chauffeur6's Avatar
Member
 
Premium Subscriber
 
Join Date: Oct 2007
Location: Metro NY
Posts: 675
Default

My personal feeling/observation is that they are very hesitant and resistant to remove anything from the DB once it's in there. Especially if the FCC licenses are still valid for any given frequency, whether it's actively used or not. I guess they fear some people might be too quick to remove legacy frequencies, and they might one day be pressed back into service or whatnot.

I submitted an update not long ago for a frequency that was incorrectly labeled as "Fireground Portables", when the fact was this particular agency never, ever used that frequency for two-way communication. It was used 20 something years ago for traffic light controls before the OptiCom system became the standard. I've had a personal relationship with this agency going back 17 years, and know with absolute certainty this frequency does not belong in the RR database. Yet, even after my detailed and thorough explanation in my submission, the only action taken was the description changed to "Fireground Portables (inactive)" So not only was it not removed as it should've been, but it was still kept labeled incorrectly. That frequency was never programmed into a single two-way radio going back decades.

Last edited by Chauffeur6; 11-01-2009 at 03:10 PM..
Reply With Quote
  #7 (permalink)  
Old 11-01-2009, 03:28 PM
Wiki Admin
 
Database Admin
 
Join Date: Jul 2002
Location: Glen Burnie, Md.
Posts: 8,955
Default

In a way I can see why they might resist removing data. However there's just as much of a chance of an old frequency coming back with a new user, then not coming back at all.

That's very much an Eric (chief DBA admin) issue to address. But one of the first questions he's likely to ask is 'did you submit a ticket for this'? and 'supply the number'. That's the only way the ball gets rolling.

If indeed the DBAs are leaving these old notes in the database (as MPSCS asserts), it's their responsibility to clean up after themselves, particularly if someone has made a ticket up that says 'this data is obsolete - please drop it'.

The chain of responsibility, folks, begins with you 73 Mike
__________________
links editor, Utility Monitoring Central
Wiki Administrator, HF Forum moderator, RadioReference
Friends don't let friends buy Scancat Lite Plus!
Reply With Quote
  #8 (permalink)  
Old 11-01-2009, 04:19 PM
MPSCS's Avatar
Member
 
Premium Subscriber
 
Join Date: Jul 2008
Location: S.E. Michigan
Posts: 1,466
Default

Thanks Mike for attempting to explain this.

I'd really like to hear from the DBA(s) on this issue before spending any time on trying to fix it. Like I said, in the past I was told the changes would not be implemented even if submitted. That is why I dropped it. I'm curious if their reasons still stand. That was many years ago! That is why I posted this here to begin with, hoping for a response from those who maintain it.

I sent a PM to Ron. Hopefully he'll chime in here.

Thanks
__________________

Reply With Quote
  #9 (permalink)  
Old 11-01-2009, 05:19 PM
Thunderbolt's Avatar
Member
 
Database Admin
 
Join Date: Dec 2001
Location: Ann Arbor, Michigan
Posts: 3,990
Default

Many of these departments still have their old legacy radio equipment. This includes portables and mobiles that can be pressed back into service if needed. Apparently, these agencies feel that its in their best interest to do, especially if we were to have a major disaster in the state of Michigan. However, the city of Detroit, removed all of their legacy radio infrastructure, and made this a matter of public record. Likewise, this was confirmed and that information was removed from the database as soon as the changes went into effect. Detroit decided to purchase redundant 800 MHz., base transmitters/repeaters and use them for backup communications, should their MPSCS Zone go into a prolonged failure.

So far no subscribers have sent us any specific information regarding the confirmation that certain redundant legacy systems have been removed from service. This includes the sending us submissions that we can track and keep better tabs on. Those who have sent us information that confirms that a radio channel has been permanently removed from service, is so noted in the database. We can mark it deprecated or just plain remove it.

73s

Ron
__________________
"A bank is a place where they lend you an umbrella in fair weather and ask for it back when it begins to rain." Robert Frost.
Reply With Quote
Sponsored links
  #10 (permalink)  
Old 11-01-2009, 05:23 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

This is a hornet's nest

1. All of the data in the DB is not confirmed. It is supposed to be confirmed now before an admin enters it, but somewhere along the line [before i was around] it must not have needed to be confirmed. I say this because there are obvious blatant additions to various cities, counties, states, whatever that were entered in based completely upon an FCC license being issued. And we all know that these days we are no allowed to simply enter in data from FCC records without it being confirmed as in use. I personally have no problem with this either. The validity of the data is crucial.... and that has to start by entering in new information only if it is confirmed... and over time less reliable data can be picked apart as time and available confirmation methods exist.

I imagine that in the beginning that was probably the only way to go... get FCC data, enter it in along with anything that people confirm, and then people have something to listen to and can confirm/deny the use of the ones submittted directly from the FCC. Back when there were no lists of area frequencies except for FCC data, it made sense to enter in FCC data to give people a "base of frequencies" to work with.

These days we can't just add something because it's in the FCC database, or at least we are not supposed to... only confirmed data should be entered.

There is obviously a lot of "legacy" information in the DB that is correct along with a lot that is not correct.

2. I have always been told not to delete anything from the database unless I have confirmation / an extremely high level of confidence that the frequencies are no longer in use as listed.

This is difficult... If somebody submits a ticket stating "this frequency is not in use", then we have to follow up with them with sometimes many back and forth exchanges to determine how they know this and then we have to place a confidence value on that... If we aren't in that area to know intimately the frequencies in use, we have to trust somebody else. And just because somebody else says a frequency is no longer in use, does that make it so?

I personally know of agencies that continue to maintain radios on VHF or low band that, even though they never use them anymore, they have available for use should their primary communications on a trunked system be unavailable. One of the radios may not have been keyed in a year, but could be at a moment's notice if need be.

So I usually go through a long process of back-and-forth exchanges with somebody who submits a request for deletion of outdated data. I ask as many questions as possible.. I try to pick their brain, find out where they came upon this information, ask them if they have firsthand knowledge (are they a member of a department, heard it from a member of a department, do they work at or are they friends with somebody working in at a radio shop, etc. I ask them if they know whether or not the actual radios have been pulled from the vehicles or not.

So, to me it is an extremely tedious process, in many cases, to make a determination as to whether a frequency is actually abandoned or not.

In my home county I can think of _many_ frequencies that I have never heard active in 25 years. But I also know that they were likely used only within that city, that I wouldn't necessarily hear the simplex comms from my location consistently, and that the radios may still exist in vehicles and in the departments. So without some way of confirming that these frequencies are no longer active (the agency has sold the radios, traded them in for their new radios on different frequencies, pulled the radios from operation, etc), I have to assume that the frequencies are still valid frequencies.

I'm just a state DB admin.. I'm sure the global DB admins and Lindsay will have more to say. I would love to clear up a lot of the data in areas that I listen to which I haven't heard anything on in years.... but just because I don't hear it doesn't mean they aren't transmitting or that they don't have the capability to transmit. So I have to leave the data in there.

Example: My county's Sheriff Department is on the trunked system. Their lowband license expired a few years ago and was removed from the DB. I personally had to resubmit the information indicating that even though the license is expired and they have a presence on the trunked system, they continue to use low-band at least 50% of the time.

In this day and age, there would be no reason for somebody to believe that their lowband was still in use given the countywide usage of the trunked system, the fact that their lowband license is expired, and the fact that the sheriff budget is in the minus and they can't afford radio repairs for 30 year old equipment.... but, it is in use.

Conversely, just as I had to provide adequate assurance that it is in use, somebody must be able to convince me that a frequency is not in use by the agency listed. If somebody suggests that a frequency needs to be removed, they can expect to be interrogated. The last thing I want to do is remove valid information.

Mike
Reply With Quote
  #11 (permalink)  
Old 11-01-2009, 05:35 PM
MPSCS's Avatar
Member
 
Premium Subscriber
 
Join Date: Jul 2008
Location: S.E. Michigan
Posts: 1,466
Default

Quote:
Originally Posted by Thunderbolt View Post
Many of these departments still have their old legacy radio equipment. This includes portables and mobiles that can be pressed back into service if needed. Apparently, these agencies feel that its in their best interest to do, especially if we were to have a major disaster in the state of Michigan. However, the city of Detroit, removed all of their legacy radio infrastructure, and made this a matter of public record. Likewise, this was confirmed and that information was removed from the database as soon as the changes went into effect. Detroit decided to purchase redundant 800 MHz., base transmitters/repeaters and use them for backup communications, should their MPSCS Zone go into a prolonged failure.

So far no subscribers have sent us any specific information regarding the confirmation that certain redundant legacy systems have been removed from service. This includes the sending us submissions that we can track and keep better tabs on. Those who have sent us information that confirms that a radio channel has been permanently removed from service, is so noted in the database. We can mark it deprecated or just plain remove it.

73s

Ron
Some of these situations the radio techs themselves have confirmed that the equipment is not only out of service, but physically removed from the sites and sold off or scrapped. Other instances the officers for firefighters have confirmed permanent changes. Would this be substantial enough to remove the data?

If we want to keep it in the database, maybe we could color code the header to bring attention to it's questionable status? But that wouldn't work when doing software download/imports. Anyway they could be flagged with color when doing imports?

Thanks
__________________

Reply With Quote
  #12 (permalink)  
Old 11-01-2009, 06:11 PM
Thunderbolt's Avatar
Member
 
Database Admin
 
Join Date: Dec 2001
Location: Ann Arbor, Michigan
Posts: 3,990
Default

Quote:
Originally Posted by MPSCS View Post
Some of these situations the radio techs themselves have confirmed that the equipment is not only out of service, but physically removed from the sites and sold off or scrapped. Other instances the officers for firefighters have confirmed permanent changes. Would this be substantial enough to remove the data?

If we want to keep it in the database, maybe we could color code the header to bring attention to it's questionable status? But that wouldn't work when doing software download/imports. Anyway they could be flagged with color when doing imports?

Thanks
Here again, nobody has submitted any information to the database admins that these changes have taken place. Likewise, in the past we have removed information based upon what someone "in the know" feels is the case, only to be rebuffed by a person of higher authority within that department. Therefore, its a long and tedious process, which required cross-confirmation.

73s

Ron
__________________
"A bank is a place where they lend you an umbrella in fair weather and ask for it back when it begins to rain." Robert Frost.
Reply With Quote
  #13 (permalink)  
Old 11-01-2009, 06:23 PM
MPSCS's Avatar
Member
 
Premium Subscriber
 
Join Date: Jul 2008
Location: S.E. Michigan
Posts: 1,466
Default

Quote:
Originally Posted by Thunderbolt View Post
Here again, nobody has submitted any information to the database admins that these changes have taken place. Likewise, in the past we have removed information based upon what someone "in the know" feels is the case, only to be rebuffed by a person of higher authority within that department. Therefore, its a long and tedious process, which required cross-confirmation.

73s

Ron
So basically you are saying we shouldn't even bother?

I'm not being sarcastic. I'm just trying to confirm what I was trying to explain to Mike earlier. What is the point of sending submissions if they're going to be denied?
__________________

Reply With Quote
  #14 (permalink)  
Old 11-01-2009, 09:03 PM
detroit780's Avatar
Member
 
Premium Subscriber
 
Join Date: Dec 2002
Location: Michigan
Posts: 287
Default Out of date frequencies

Bill,

Let's use Livingston county as an example. There are several VHF frequencies listed as Sheriff TAC No Longer in use.

So I agree why bother listing them if the notes say NO LONGER USED. I have not heard ANYHTING on those in the 9 years I have lived here and never seen a VHF radio in ANY Sheriifs vehicle or in dispatch or the Sheriffs department.

Take 154.77 as an example it's licensed till 2013. Now a licensed frequency does not mean it's in use it just means they renewed it in 2003 most likely thinking they might use it. I don't think most departments are going to inform the FCC that they no longer use a frequency they just let it expire.

The truth is they like the digital radios and do any real private work in Nextel.

It would be nice it a new section was created in the end of the couty listings titled Out of Service or Seldom Used or something like that. While on the subject it would be great if they didn't list the same frequency multiple times in the conventional database.

Programs such as Win500, PSR500 and ARC 500 make things easier by downloading direct from RR however you need to spend a fair amount of time afterwards making sense of it.

Example: 154.01 Livingston County Fire dispatch is listed for every community. So if you were from out of town trying to program the radio you would end up with 8 different listings of 154.01.

For trunked systems in many states you doing an import you get things like Police dispatch in multiple places. Once on the road you look at the radio and see police dispatch but have no clue where. There are a few states that are detailed very well and you get a pretty good idea of what is what doing radio programming.

Les







Quote:
Originally Posted by MPSCS View Post
So basically you are saying we shouldn't even bother?

I'm not being sarcastic. I'm just trying to confirm what I was trying to explain to Mike earlier. What is the point of sending submissions if they're going to be denied?
__________________
Les W8MSP

http://W8MSP.com
http://Michigan-Radio.com

E-Mail W8MSP@W8MSP.com
Reply With Quote
  #15 (permalink)  
Old 11-01-2009, 10:17 PM
mciupa's Avatar
Member
   
Join Date: Nov 2002
Posts: 3,221
Default

I say let the database be the custodian of supposed deprecated frequencies and let the scanner owner decide what is clutter by including or not including them. Let us decide what we should load into our scanners and keep the info available.

I must say I respect the integrity of mtindor and Thunderbolt.
Proof is a must.
Reply With Quote
Sponsored links
  #16 (permalink)  
Old 11-02-2009, 07:45 AM
DaveIN's Avatar
Member
 
Premium Subscriber
 
Join Date: Jan 2003
Posts: 4,442
Default

Not to mention if a tower in the MPSCS system goes down and the nearest tower is not giving the reception needed, a possible fallback could be the unused frequencies for some agencies. Also, some police agencies have been cut to the point that they work with neighboring communities to provide mutual aid on frequencies that may not have been in use for some time. Today's scanners have no problem skipping by unused frequencies, I say it's up to you if you want to keep or delete the suspected unused channels. Housekeeping on the database is a full time job.
Reply With Quote
  #17 (permalink)  
Old 11-02-2009, 08:18 AM
Member
   
Join Date: Feb 2001
Location: Lansing, MI
Posts: 7,298
Default

Quote:
Originally Posted by DaveIN View Post
Not to mention if a tower in the MPSCS system goes down and the nearest tower is not giving the reception needed, a possible fallback could be the unused frequencies for some agencies.
Not really. Most agencies fallback to the ITAC channels. Very few (certainly not Lansing) have the old radios anywhere in the streets to utilize.
Reply With Quote
  #18 (permalink)  
Old 11-02-2009, 08:35 AM
detroit780's Avatar
Member
 
Premium Subscriber
 
Join Date: Dec 2002
Location: Michigan
Posts: 287
Default Fallback

Yes I Call and I Tac frequencies are in all of the MPSCS radios and make falling back to those a matter of changing the zone. Most agencies don't keep their old systems running since they would need to leave the old radios and antennas in every vehicle.





Quote:
Originally Posted by rdale View Post
Not really. Most agencies fallback to the ITAC channels. Very few (certainly not Lansing) have the old radios anywhere in the streets to utilize.
__________________
Les W8MSP

http://W8MSP.com
http://Michigan-Radio.com

E-Mail W8MSP@W8MSP.com
Reply With Quote
  #19 (permalink)  
Old 11-02-2009, 08:41 AM
detroit780's Avatar
Member
 
Premium Subscriber
 
Join Date: Dec 2002
Location: Michigan
Posts: 287
Default Database

I don't think anyone in this thread said the DB managers weren't doing a good job what is being debated is outdated frequencies. One would think a discussion could take place to get us all thinking about how improvements could be implemented. I think the discussion is offered to the DB managers, if they don't think the ideas are worthy they won't take place. If they do and can accomplish them that's good too.




Quote:
Originally Posted by mciupa View Post
I say let the database be the custodian of supposed deprecated frequencies and let the scanner owner decide what is clutter by including or not including them. Let us decide what we should load into our scanners and keep the info available.

I must say I respect the integrity of mtindor and Thunderbolt.
Proof is a must.
__________________
Les W8MSP

http://W8MSP.com
http://Michigan-Radio.com

E-Mail W8MSP@W8MSP.com
Reply With Quote
  #20 (permalink)  
Old 11-02-2009, 05:46 PM
MPSCS's Avatar
Member
 
Premium Subscriber
 
Join Date: Jul 2008
Location: S.E. Michigan
Posts: 1,466
Default

OK then, I'll leave well enough alone and just update my own information.
__________________

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



All times are GMT -5. The time now is 07:14 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