Database Admin

[muhockey86]

Who's in charge of administering the indvidual county databases? My home county is a clusterf*ck full of unverified and incorrect data.......

 

[dpm3]

Who's in charge of administering the indvidual county databases? My home county is a clusterf*ck full of unverified and incorrect data.......

I have some serious concerns as well as regards some of the frequencies in use in St. Louis County. Perhaps there needs to be some organized way of monitoring the provided data and ensuring that accurate information can be reflected in the database.

 

[iamhere300]

And thats where we all come in. The database is only as good as the input WE provide

 

[muhockey86]

My issue is all the unverified frequencies in the Jefferson County database. Doesn't anyone check these? Or are we just taking people's word for it?

 

[Sifter]

Who's in charge of administering the indvidual county databases? My home county is a clusterf*ck full of unverified and incorrect data.......

I see you are from Columbia, I am also scanning in Columbia. Would be interested in sharing and verifying a freq list along with you.

 

[muhockey86]

I'd be all for it.....Do you have any idea how the CPD unit numbers work? After 3 years here I still have no idea how they work...

 

[Sifter]

I'd be all for it.....Do you have any idea how the CPD unit numbers work? After 3 years here I still have no idea how they work...

I am indeed new here, so from what Ive gathered, each patrol is assigned a 3 digit number.

So dispatch will say "Columbia, 610, status check". And the officer will respond "stable nothing further needed".

Im still trying to figure out if the 3 digit number varies with the shift that they take. Graveyard, 1st, 2nd...

 

[Sifter]

Also, Im going to try to program these into one of my scanners, instead of importing from the DB here, and see if it makes a difference.

http://www.gocolumbiamo.com/PSJC/Services/area_scanner_frequencies.php

 

[muhockey86]

Ya...the ones they have listed are good. I've heard unit numbers in the 100's 200's 300's 400's 500's 600's and 800's and I've seen cars marked "1101" , "1134" and so on. I know that the 800's are CPD supervisors.
As for fire, units such as Tower 5 and Ladder 1 are CFD, 100-1500 are Boone County Fire and 1600+ I believe is Southern Boone County.
MUPD is simple, 100's are 1st shift 200's are 2nd, and 300's are 3rd
101-109 (same for 200's and 300's) are shift commanders
110-119 are sergeants
120+ officers
112

 

[mjthomas59]

As far as the database goes, like was mentioned, it is only as good as the information that is put into it. I've submitted my fair share of information into the st. charles county and franklin county pages because they were either missing important frequencies or what was listed was incorrect. Not everything submitted is right, whether it was a typo by the submitter or a typo by the admin. Heck it could even be a newbie who just doesn't understand that its possible to hear a frequency a hundred miles from the source and who thinks that it is the local dispatch when in fact its from 2 counties over.

Regardless its our responsibility, especially those of us who have been around a while, to send in the new information. At the very least we can all agree that things change, from frequencies in use, or brand new radio systems coming online... if we don't send in the info then it never gets updated.

As far as things being confirmed in use, I think that some of them are, but Terry lives a long way from Boone County and thus isn't going to be able to confirm the information is correct. I am fairly certain though that when new info is submitted for his surrounding area he does make an attempt to confirm them. Of course a lot of the new information that is submitted anymore seems to be from the times where we have major incidents, like flooding, going on, and which case once the flood is over the frequencies cease being used, thus making them difficult to confirm.

In my experience its only taken a few days for my submitted information to get updated which I think is pretty good considering all the admins are on a volunteer basis.

 

[bezking]

The Missouri Database Admins are:

US-Missouri
DrSm0ke
n0vkg
tweatherford.

If you see unverified or wrong data, please submit it to the database and these admins will work on it.

Thanks!

 

[ksmoscanner]

Biggest problem are the entries into the database based off the weekly fcc grant report. We should not put data in the database unless it has been monitored by the submitter even if it is a brand new license. Trunked licenses should be an exception such as the Aquila LTR system.

Gregg in KC

 

[mjthomas59]

That or just put them in an area for "unconfirmed" or "unidentified" frequencies per county. Then the listeners in that particular area can tune in to the new frequencies and confirm their usage.

 

[muhockey86]

I think the Jefferson County database has a lot of issues...this was my initial concern. I think the admins might benefit from having a few people in counties that they administer that they can go to for confirmation.

 

[Starcom21]

Like others have said. If you don't submit the information, we can not know it is wrong.

As fars as "accepting peoples word" for stuff.... the same would go with anyone, such as yourself, that would submit stuff for the county.

Pick it apart, piece by piece and tell us what needs fixed.
Then we'll fix it.

In most cases, we have to trust whomever is submitting the information is correct.
If there are questions or something that sounds way out of place, we'll ask questions first.

Very simple. On the county page, click the SUBMIT tab at the top of the page and tell us:

1) What is wrong
2) What needs changed
3) What needs deleted
4) What you have the PL tones for
5) What you have the proper use of
6) What you have the proper channel ID/Identifier that an agency uses.

Again, let me know.... and I'll fix it!
We want it to be correct, and can't do it without the help of people telling us.
And often times, we don't always see a thead in the forum that lets us know, EVERYONE has to SUBMIT the changes needed.

I'm "sorta-close" to Jefferson County, but far enough away, that I don't pick up much beyond the main Fire/Law/EMS frequencies.... and I have local agencies using most of the frequencies here already (Madison County IL)

Thanks
Terry

 

[hkrharry]

Same goes for me too.

Like others have said. If you don't submit the information, we can not know it is wrong.

As fars as "accepting peoples word" for stuff.... the same would go with anyone, such as yourself, that would submit stuff for the county.

Pick it apart, piece by piece and tell us what needs fixed.
Then we'll fix it.

In most cases, we have to trust whomever is submitting the information is correct.
If there are questions or something that sounds way out of place, we'll ask questions first.

Very simple. On the county page, click the SUBMIT tab at the top of the page and tell us:

1) What is wrong
2) What needs changed
3) What needs deleted
4) What you have the PL tones for
5) What you have the proper use of
6) What you have the proper channel ID/Identifier that an agency uses.

Again, let me know.... and I'll fix it!
We want it to be correct, and can't do it without the help of people telling us.
And often times, we don't always see a thead in the forum that lets us know, EVERYONE has to SUBMIT the changes needed.

I'm "sorta-close" to Jefferson County, but far enough away, that I don't pick up much beyond the main Fire/Law/EMS frequencies.... and I have local agencies using most of the frequencies here already (Madison County IL)

Thanks
Terry

Let us know what is out of wack so we can fix it.

As for the Columbia area, some of the info we have is several years old.
Most of the contacs I had out there have moved to the Kc Metro Area, so we have not had a good update in a while. so you folks out there are our eyes and ears.
Lets get it up to date!
Terry or I will correct it.
It is only as good as you guys make it.

As we cannot be every where.

Thanks In Advance
bob, n0euh

AKArSm0ke

 

[jas0nr7272]

I just got a message from Terry saying that they are not adding any more freqencies to the database.
I guess he is just asking me politely not to keep submitting information.

 

[Starcom21]

I just got a message from Terry saying that they are not adding any more freqencies to the database.
I guess he is just asking me politely not to keep submitting information.

Sorry, I missed a word completely, "unverified" frequencies is what i meant to say.

Often when we get a whole list and an FCC license submitted, it just someone giving us a license info directly from the FCC.
I know some have older scanners or they didn't catch a PL/DPL tone. That's was I was asking if you had heard it in use.

But again, only 1 of the frequencies was heard in use, not the others.

By the way, I sent that message nearly 2 months ago, not just recently.

If it is verified and as long as it is not fast food or Ham Radio, YES, we will add it to the database. Did not mean for it to sound that way at all.

Your submission:

Incredible Pizza
St Peters MO 63376

Callsign: WQJC759

451.33750 Operations
451.66250 Operations
452.03750 Operations
452.28750 Operations
452.63750 Operations

Again, it just looked like "assumed" to be in use because here is the FCC Call sign and the information from the license. Notes like you just gave (in your PM) about hearing the frequency in use at a certain location is great! Be sure to mention that you did or did not get a PL tone or that the scanner that you are using does not do that.

These are the kinds of finds I feel most welcome!

Agencies/Businesses/Frequencies that are unverified (in database, but have no tone or actual use listed) or not in database, but is in the FCC database are great finds!

Personally, when I go on road trip, these are what I program --- maybe a few "911 type frequencies" that are already verified, but I love to seek out the businesses and unverified public safety frequencies to try to help identify them.

Hopefully that all didn't sound confusing --- and you are absolutely welcome to submit frequencies.

Thanks!

 

[jas0nr7272]

Sorry about the confusion terry. I understand what you meant. And yes initially that was the license information obtained. But i make every effort to verify information. I will try to get back to you with the PL, and if the other frequencies are being used now that the business has officially opened. Unfortunately the scanner in my vehicle has no PL Function.
I will take along my Pro106 and see what i come up with.