Author Topic: Clip Search Proof of Concept  (Read 5969 times)

Offline bcrosby

  • Sr. Member
  • ****
  • Posts: 333
    • Fly With Blake
Clip Search Proof of Concept
« on: July 18, 2007, 02:26:04 PM »
Hello Everyone,

I've whipped a quick proof of concept web application to be able to search through the clip archive we have. There is a vast source of clips available on the site and I figured a "proper" search engine to search through them would be beneficial to the site.

Right now, there is only one clip in the database to show the functionality of how the system will work. If people like the idea, I am going to add the following features:

Search:
  • Search by location
  • Search by flights/aircraft involved
  • Keyword search on transcript

Clip Maintenance:
  • Upload your clip
  • Add a transcript to any clip

I will also add a user database  to give users access to maintain the clips, add their transcripts, etc...

If you would like to see what I've come up with (its not pretty, but works), check out:

www.blakecrosby.com/liveatc/clipindex.php

Click on the clip title to view information about the clip, including a link to download it and an audio transcript.

Comments are welcome.



Offline KSYR-pjr

  • Hero Member
  • *****
  • Posts: 1722
Re: Clip Search Proof of Concept
« Reply #1 on: July 18, 2007, 02:59:59 PM »
I definitely like your concept as it has become somewhat tedious to search through the audio clips forum weeks or months later.

It will require a bit of work to get the transcript created.  Perhaps you could come up with a webform that makes it easier for the transcript "transcriber?" and you.  This form could have key fields like time/date/flight/aircraft type/frequency/location (frequency name)/open text field for transcript and submitting this form would automatically load your MySQL (or whatever DBMS you are using) database.
 

Offline dorishd

  • Jr. Member
  • **
  • Posts: 61
Re: Clip Search Proof of Concept
« Reply #2 on: July 18, 2007, 03:22:11 PM »
It will come in handy when the major news organizations want something!!

Offline Tomato

  • Sr. Member
  • ****
  • Posts: 277
Re: Clip Search Proof of Concept
« Reply #3 on: August 07, 2007, 06:01:07 PM »
I like your idea, but a few thoughts/questions...

When you it's built to "search through the clip archive" - what archive are you referring to?  If it's the automatic archiver that saves every ATC feed, it would be very hard to catalog.  I guess we could build a parser to grab flight info from the affected airport, but Center feeds would be out of luck.

The uploaded clip would work great though.  Maybe instead of uploading a clip, something can be worked out that you upload to the site and the site will auto-create a thread on here.

I noticed you used the IATA flight codes, rather than the ICAO ones... just curious why your preference?  (It doesn't matter, I'm just curious!)

As for dorishd's comment... "It will come in handy" - yes, definitely!  ..."when the major news organizations want something!" - that part worries me.  It's part of growing pains, and we gotta take the bad with the good, but the news seems to report more bad news than good and I'd hate LiveATC to be used for something in a negative light.

Nonetheless, I think this is an awesome idea.  I think with a little more thought/drafting, this will turn out well.  :)

Great idea, Blake!

Offline bcrosby

  • Sr. Member
  • ****
  • Posts: 333
    • Fly With Blake
Re: Clip Search Proof of Concept
« Reply #4 on: August 14, 2007, 10:08:42 AM »
I noticed you used the IATA flight codes, rather than the ICAO ones... just curious why your preference?  (It doesn't matter, I'm just curious!)

Hmm.. You're right. I didn't realize that there were ICAO flight codes as well. I will change them in the final version.

You're suggestions are good. I want to keep the discussion of the clip in the forums, since thats where they are best suited. The idea also being that the website can drive some traffic to liveatc.net as well.

By "Clip archive" I mean the archive of individual clips available on the site, not the actual feed archive.

I've already looked into setting up a speech to text engine to convert the archive audio into text that can be indexed but the quality of the audio is too poor for a computer to parse (at this point in time).

The hardest part is getting a transcript for each clip, but I'm hoping the community will be willing to help a bit.

Offline kkjlai

  • Jr. Member
  • **
  • Posts: 81
Re: Clip Search Proof of Concept
« Reply #5 on: August 17, 2007, 10:12:21 AM »

I've already looked into setting up a speech to text engine to convert the archive audio into text that can be indexed but the quality of the audio is too poor for a computer to parse (at this point in time).

The hardest part is getting a transcript for each clip, but I'm hoping the community will be willing to help a bit.

Great job, blake!   And if you succeed in doing so, I think Google will buy in this concept... (and they will start archiving every audio and index everything).. go patent your idea.. :-)

kkjlai

Offline bcrosby

  • Sr. Member
  • ****
  • Posts: 333
    • Fly With Blake
Re: Clip Search Proof of Concept
« Reply #6 on: August 17, 2007, 02:17:00 PM »
Great job, blake!   And if you succeed in doing so, I think Google will buy in this concept... (and they will start archiving every audio and index everything).. go patent your idea.. :-)

kkjlai

LOL... thanks for your confidence in my web application. It's nothing really special or sophisticated. I'm still debating whether to actually spend the time to set it up.

The response from the users on the forum haven't been as encouraging as I had hoped.