InterceptRadio.com Forums

The radio website that doesn’t try to hose its users for money.
It is currently Thu Jun 26, 2025 2:52 pm

All times are UTC - 8 hours


Forums       Map Search       Database Search       Live Audio       Alerts       Wiki




Post new topic Reply to topic  [ 59 posts ]  Go to page Previous  1, 2, 3, 4  Next
Author Message
 Post subject: Re: Database maintenance
PostPosted: Sun Feb 01, 2009 1:21 pm 
Offline
Mr. Bad Example
User avatar

Joined: Sat Feb 21, 2004 10:11 am
Posts: 8097
Location: Nancy's Bedroom... ooh aah
Added Ketchikan, AK and some stuff from North Carolina.

_________________
President-in-Exile, Seattle Area Radio Communications And Scanner Traffic Intercept Crew (SARCASTIC)
Don't feel bad if you can't use your STD100/200; there are still people using Digital Frequency Search!
Bunnery definition for the under-fives


Top
 Profile  
 
 Post subject: Re: Database maintenance
PostPosted: Sun Feb 01, 2009 6:06 pm 
Offline
Site Admin
User avatar

Joined: Mon Jan 03, 2000 9:20 am
Posts: 2001
Per request I changed the database output such that adjacent rows have alternating shades of background.

This is an ancient method of improving readability which dates back to the day of alternating white/green fanfold printer paper. Hate to date myself but I actually used that stuff...

I took it a step further and did alternating color shades for trunked systems. Motorola shows up as blue, LTR as green, and EDACS as yellow. Makes it a lot easier to read large output as the trunked and non-trunked stuff can be instantly separated visually. Try a dump of all Snohomish county for example. Looks pretty cool...


Top
 Profile  
 
 Post subject: Re: Database maintenance
PostPosted: Tue Feb 03, 2009 2:50 pm 
Offline
Site Admin
User avatar

Joined: Mon Jan 03, 2000 9:20 am
Posts: 2001
Added Los Angeles, CA.


Top
 Profile  
 
 Post subject: Re: Database maintenance
PostPosted: Tue Feb 03, 2009 6:23 pm 
Offline
Corporal Cowboy
User avatar

Joined: Thu Feb 19, 2004 4:45 pm
Posts: 3556
Location: Stensgar, SE of
I see that, looking good. I see Alaska too.
What's next? Wait & see?

_________________
</>


Top
 Profile  
 
 Post subject: Re: Database maintenance
PostPosted: Fri Feb 06, 2009 4:14 pm 
Offline
Corporal Cowboy
User avatar

Joined: Thu Feb 19, 2004 4:45 pm
Posts: 3556
Location: Stensgar, SE of
It keeps growing.... If this keeps up you're going to hafta change the name.

_________________
</>


Top
 Profile  
 
 Post subject: Re: Database maintenance
PostPosted: Fri Feb 06, 2009 5:12 pm 
Offline
Site Admin
User avatar

Joined: Mon Jan 03, 2000 9:20 am
Posts: 2001
Yeah thats what happens when too much info trickles in....

Here is the latest on database maintenance, mostly changes to improve usability:

- Last week I changed "Database Search" so its easy to do a quick lookup. All you do is click "Database Search", type a frequency in the box, then click the Find button. Thats it. All the other options are defaulted to search everything.

- At the bottom of the "Database Search" screen you now have output options for CSV and (formatted) text. This makes it easy to paste the output into Excel or Notepad.

- Counties which have no (or few) additional notes will automatically display their database listings when clicked on from the map search. So for many areas it will take people only two clicks from the main page to get information.


Top
 Profile  
 
 Post subject: Re: Database maintenance
PostPosted: Fri Feb 06, 2009 7:25 pm 
Offline
Corporal Cowboy
User avatar

Joined: Thu Feb 19, 2004 4:45 pm
Posts: 3556
Location: Stensgar, SE of
It's almost as it defaults to reverse a HEARS lookup.

Is a reverse query by design? (May be confusing).

I also see the options in the drop-down. (To qualifiy above questions)

Suggest USA/WA being default in the country/state fields (to expedite query).

Regardless, it's looking great!

Finally, I can use this one:

:hitit:

_________________
</>


Top
 Profile  
 
 Post subject: Re: Database maintenance
PostPosted: Fri Feb 06, 2009 7:41 pm 
Offline
Site Admin
User avatar

Joined: Mon Jan 03, 2000 9:20 am
Posts: 2001
I thought it would be nice to put a default value in the box so people would have an idea what kind of input it expects.


Top
 Profile  
 
 Post subject: Re: Database maintenance
PostPosted: Sat Feb 07, 2009 10:43 am 
Offline
Site Admin
User avatar

Joined: Mon Jan 03, 2000 9:20 am
Posts: 2001
I added a color legend to the top of the database listings.

The "search by frequency" option has been moved to the bottom of the list.

I also added a "search by text" option which works nicely.


Top
 Profile  
 
 Post subject: Re: Database maintenance
PostPosted: Sat Feb 07, 2009 12:37 pm 
Offline
User avatar

Joined: Thu Oct 04, 2007 1:58 pm
Posts: 3429
Location: Not in Alaska
Rich wrote:
I also added a "search by text" option which works nicely.

Yay!!! I couldn't figure it out at first. But now I can.
Image

And a couple of ideas to solve the complains above, I'll write psudocode because I'm lazy

Code:
<select name="sfreq" size="1" onchange="function()">
...
function()
{
   if(sfreq.value = "1" OR "2" OR "3")  //etc
   {
      sfq.style = "display: none;";
   }
   elseif(sfreq.value = "0" OR "Z")
   {
      sfq.style = "display: inline;";
   }
}

Basically when anything other than "for one frequency" or "for text" gets displayed, the text box is hidden. And then when "for one frequency" or "for text" it reappears.

And then to solve the default search value, cookies would work. Just store the last country/state/county in a cookie, then the next time that person loads the page it defaults to the last search they did (much like if they hit the back button). I'd write psudocode for that, but I haven't worked with cookies in PHP for a long time so I have no idea what it's like. All I remember is $_COOKIE["some_var"];

And the sorting doesn't seem to sort. Example shows "T 1616" "T 1936" "T 3152" when I expected "T 1616" "T 1648" "T 1680"


Top
 Profile  
 
 Post subject: Re: Database maintenance
PostPosted: Sat Feb 07, 2009 1:55 pm 
Offline
Site Admin
User avatar

Joined: Mon Jan 03, 2000 9:20 am
Posts: 2001
Atomic Taco wrote:
And a couple of ideas to solve the complains above, I'll write psudocode because I'm lazy

Basically when anything other than "for one frequency" or "for text" gets displayed, the text box is hidden. And then when "for one frequency" or "for text" it reappears.


You are asking for dynamic drawing from a static page. This would likely require client-size java(script). I try to minimize on this as most mobile browsers don't support it.

Atomic Taco wrote:
And then to solve the default search value, cookies would work. Just store the last country/state/county in a cookie, then the next time that person loads the page it defaults to the last search they did (much like if they hit the back button). I'd write psudocode for that, but I haven't worked with cookies in PHP for a long time so I have no idea what it's like. All I remember is $_COOKIE["some_var"];


Cookies are simple enough to do, just haven't had anybody ask for it. It could potentially prevent the dropdown boxes from displaying their options which is an unfortunate side-effect of forcing a default value on a dynamic box. Further complicating things are some annoying variations on how this is handled by Firefox as compared to IE.


Atomic Taco wrote:
And the sorting doesn't seem to sort. Example shows "T 1616" "T 1936" "T 3152" when I expected "T 1616" "T 1648" "T 1680"


oh it sorts just fine. You just aren't seeing the embedded spaces. The question is whether you want to use embedded spaces to force the output you want. Not using embedded spaces will give you T 1, T 10, T 1000000, T 2, T 3, etc. Using embedded spaces will give you a sequential output as its a text-based sort rather than numeric. Of course we could always pad talkgroups with leading zeros instead but then the readability tends to get a little annoying.


Top
 Profile  
 
 Post subject: Re: Database maintenance
PostPosted: Sat Feb 07, 2009 3:23 pm 
Offline
Site Admin
User avatar

Joined: Mon Jan 03, 2000 9:20 am
Posts: 2001
ok taco I forced the input to proportionally add the spaces and updated the existing database to reflect the same. Talkgroups will automatically sort now. The spaces won't be noticeable on form output but you'll see them with text output.


Top
 Profile  
 
 Post subject: Re: Database maintenance
PostPosted: Wed Feb 11, 2009 2:50 pm 
Offline

Joined: Mon Jan 12, 2009 9:13 pm
Posts: 476
Location: Sammamish, WA
did the search by frequency feature disappear, or am I blind?


Top
 Profile  
 
 Post subject: Re: Database maintenance
PostPosted: Wed Feb 11, 2009 2:57 pm 
Offline
User avatar

Joined: Thu Oct 04, 2007 1:58 pm
Posts: 3429
Location: Not in Alaska
dog wrote:
did the search by frequency feature disappear, or am I blind?

"With freq or text string:"


Top
 Profile  
 
 Post subject: Re: Database maintenance
PostPosted: Wed Feb 11, 2009 3:00 pm 
Offline
Site Admin
User avatar

Joined: Mon Jan 03, 2000 9:20 am
Posts: 2001
dog wrote:
did the search by frequency feature disappear, or am I blind?


nah, you are blind :P

The box is labeled as "freq/text" and is an optional part of the search criteria. It seemed better to do it this way. You can put in a frequency, partial frequency, or text in the box. By default it will search the entire database or you can use the other search criteria to narrow your query.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 59 posts ]  Go to page Previous  1, 2, 3, 4  Next

All times are UTC - 8 hours


Who is online

Users browsing this forum: No registered users and 9 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by electricity. Copyright © 2013 Interceptradio.com