StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
4503670
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2010-12-21T20:37:33.327
FavoriteCount
0
LastActivityDate
2015-09-09T04:51:09.667
LastEditDate
2015-09-09T04:51:09.667
LastEditorUserId
208339
OwnerUserId
208339
ParentId
4503181
PostTypeId
2
Score
5
ViewCount
0
LastEditorDisplayName
text
Body
Interesting question, but quite broad. I do recommend looking at some existing literature on automatic bird song identification. (Yup, there are a bunch of people working on it.) This paper (edit: sorry, dead link, but <a href="http://www.researchgate.net/profile/Olivier_Dufour2/publication/273079015_Clusterized_Mel_Filter_Cepstral_Coefficients_and_Support_Vector_Machines_for_Bird_Song_Identification/links/54f6cfa60cf27d8ed71ee492.pdf" rel="nofollow noreferrer">this chapter by Dufour et al. 2014</a> might be even clearer) uses a basic two-stage pattern recognition method that I would recommend trying first: feature extraction (the paper uses MFCCs), then classification (the paper uses a GMM). For each frame in the input signal, you get a vector of MFCCs (between 10 to 30). These MFCC vectors are used to train a GMM (or SVM) along with the corresponding bird species labels. Then, during testing, you submit a query MFCC vector to the GMM, and it will tell you which species it thinks it is. Although some have applied image processing techniques to audio classification/fingerprinting problems (e.g., <a href="http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.94.4830&rep=rep1&type=pdf" rel="nofollow noreferrer">this paper by Google Research</a>), I hesitate to recommend these techniques for your problem or ones like it because of the annoying temporal variations. "What tools should I use for this analysis?" Among many others: <ol> <li>feature extraction: MFCCs, onset detection</li> <li>classification: GMM, SVM</li> <li>Google</li> </ol> Sorry for the incomplete answer, but it's a broad question, and there is more to this problem than can be answered here briefly.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POBirdsong audio analysis - finding how well two clips match
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USSteve Tjoa
UserOwnerUserId
1. USSteve Tjoa
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.