Media Collection Statistics

Non-spam and Anime things that don't fit in C&C. Also where talk that you don't want to turn into spam goes. So No Spam allowed

Media Collection Statistics

Postby PCHeintz72 » Mon Aug 22, 2011 6:29 pm

Media Collection Statistics

After checking my own collection... I am interested in (and thought others might as well) statistics regarding media files like aspect ratios and resolutions of whatever videos people happen to have on their systems and have collected over the years (like but not limited to anime music videos).

Mostly interested in general and not specific information. No names or discussion of what the subject matter is are needed.

General information includes things like counts, file formats/codecs, aspect ratios, or resolutions. The last two especially, as I'm curious what aspect ratios as still in use and to what degree.

If you want to respond but do not know how to get that information easily, a program called MediaInfo can be used, as can other programs called AVICodec or GSpot that will output a CSV type spreadsheet report.

If using MediaInfo, then:

1. Simply open a my computer window to the root of the drive you have your music videos on, and type in the search box the extensions or types to search for. if you do not know the extensions, here are two handy generic lists with most of them you can cut and paste into the search.

- For Windows versions up through XP:
Code: Select all
*.ASF;*.AVI;*.DIVX;*.FLV;*.IVR;*.M4V;*.MKV;*.MOV;*.MP4;*.MPE;*.MPEG;*.MPG;*.OGG;*.OGM;*.OGV;*.RM;*.RMVB;*.SWF;*.WMV

- For Vista and 7:
Code: Select all
ext:.ASF OR ext:.AVI OR ext:.DIX OR ext:.FLV OR ext:.IVR OR ext:.M4V OR ext:.MKV OR ext:.MOV OR ext:.MP4 OR ext:.MPE OR ext:.MPEG OR ext:.MPG OR ext:.OGG OR ext:.OGM OR ext:.OGV OR ext:.RM OR ext:.RMVB OR ext:.SWF OR ext:.WMV


2. Then select/highlight all the files, and open MediaInfo and drag them into it. Once that is done, you can go to File/Export, change the Column Separator to a comma, select where to save and what name to use, then hit ok.

3. Open file you told it to make in a spreadsheet program like Excel and sort the spreadsheet by the the statistics interested in like aspect or resolution columns.

Using that information I end up with:

Counts include all videos, but not episodes or movies which I count separate:

Equivalent to Low Image Devices (Old Phones and iPods) and Low Bandwidth Countries (4 videos)
Aspect Aspect
Factor Ratio Frame Videos
1.000 - 01:01 - 120x120 - 1
1.250 - 05:04 - 150x120 - 1
1.333 - 04:03 - 160x120 - 2

Equivalent to LDTV - Low Definition Television (280 videos)
Aspect Aspect
Factor Ratio Frame Videos
1.150 - 23:20 - 276x240 - 5
1.250 - 05:04 - 300x240 - 10
1.333 - 04:03 - 320x240 - 201
1.500 - 03:02 - 360x240 - 24
1.556 - 14:09 - 372x240 - 4
1.667 - 05:03 - 400x240 - 14
1.775 - 16:09 - 426x240 - 10
1.850 - 37:20 - 444x240 - 3
2.000 - 18:09 - 480x240 - 2
2.200 - 11:05 - 528x240 - 3
2.400 - 12:05 - 576x240 - 2

Equivalent to SDTV - Standard Definition Television (469 videos)
Aspect Aspect
Factor Ratio Frame Videos
1.000 - 01:01 - 480x480 - 2
1.150 - 23:20 - 552x480 - 2
1.250 - 05:04 - 600x480 - 12
1.333 - 04:03 - 640x480 - 248
1.375 - 11:08 - 660x480 - 12
1.500 - 03:02 - 720x480 - 114
1.554 - 14:09 - 746x480 - 1
1.667 - 05:03 - 800x480 - 5
1.775 - 16:09 - 852x480 - 60
1.850 - 37:20 - 888x480 - 9
2.000 - 18:09 - 960x480 - 2
2.400 - 12:05 - 1152x480 - 2

Interactive SWF that cannot easily be converted (1 video)
Aspect Aspect
Factor Ratio Frame Videos
1.273 - 14:11 - 700x550 - 1

Equivalent to HDTV - High Definition Television (137 videos)
Aspect Aspect
Factor Ratio Frame Videos
1.333 - 04:03 - 960x720 - 8
1.667 - 05:03 - 1200x720 - 1
1.778 - 16:09 - 1280x720 - 126
1.850 - 37:20 - 1332x720 - 1
2.200 - 11:05 - 1584x720 - 1

For the above, I'm showing both the decimal number (rounded) for the aspect ratio and the common name for it along with my resolution.

You'll note despite popularity of 480p and 720p and even 1080p 16:9 wide-screen type formats I still come across far more in 4:3 aspect ratio format. And I have nearly as much in a 3:2 format as I do 16:9. And some older aspect ratio stuff is still holding out with videos released in their format from time to time by various up-loaders.

There are more aspect ratios than these... these are merely the ones I have stuff in. There is a 2.55 theater aspect ratio no longer in general use, likewise a 1.6. There is an official and custom 2.37 that no one but the TV makers that make them support. Etc...

Likewise, there are more vertical frame rates than these... 120p comes to mind, as does the more common in Europe tandards of 288p, 432p, and 576p.

In theory, a couple aspect ratios like 5:4 or 3:2 should not even be in general use much at all, as anything actually broadcast in those formats is supposed to be shown as 4:3 or 16:9... but that is not the case.

Last year I cleaned up my own collection so all videos are either 480p equivalent or 720p equivalent. And had a subsequent cleanup these last couple weeks broke it to three scales, corresponding to US broadcast standard levels... That is why the numbers are shown cleaner and more consistent than would be the norm... Many for example might have 160x120 and 320x240 videos, both are 4:3 aspect ratio. Most will have AVI, WMV, MKV, DIVX, etc... all are valid formats.

So... you've seen some of my statistics, what of yours?

Edited 09/04/2011: redid my collection after redownloading them all, and ditched FLV format and expanded 720p
Last edited by PCHeintz72 on Sun Sep 18, 2011 1:14 pm, edited 5 times in total.
PCHeintz72
User avatar
Prism Power Senshi
Posts: 2696
 

Re: Media Collection Statistics

Postby Crescent Pulsar R » Mon Aug 22, 2011 6:47 pm

Saying "zero/none" on all counts is still a statistic, right? Well, unless there are videos that come with the operating system lying around somewhere. I might be one of those rare individuals (I mean, is it rare?) who have a "don't download video files" policy.
Crescent Pulsar R
User avatar
Crystal Power Senshi
Posts: 4122
 

Re: Media Collection Statistics

Postby frice2000 » Tue Aug 23, 2011 12:02 am

You're a FBI agent taking down info to take us all to jail! I'll never pay your 100k and 10 years in prison! You'll never take me alive!

Honestly not in front of or have access to my computers right now. Most in pure size of my videos are likely avi in 360p. After that likely mkv in 720p, closely followed by flv files in mostly 480p. There is a smattering of mp4 but I don't like that extension. I play pretty much everything with KMPlayer and rarely look or care about the formats. I have around 2tbs of video data archived on USB 2.0 drives so even if I was home this would take far too long to run and I wouldn't give you more exact numbers sorry.
frice2000
User avatar
Asteroid Senshi
Posts: 572
 

Re: Media Collection Statistics

Postby PCHeintz72 » Tue Aug 23, 2011 12:26 am

frice2000 wrote:You're a FBI agent taking down info to take us all to jail! I'll never pay your 100k and 10 years in prison! You'll never take me alive!

Well... I suppose it is possible, but not likely. Still, if you are that worried, you did not have to respond. I made the thread becuase I really was curious.

Interesting comments... You mention not liking the MP4 extension, but if using AAC and ACV, MP4 and MKV are nearly identical except raw container. MKV supports subtitles better with support for SRT/ASS/VOB whereas MP4 supports TTXT. But for Music videos and FLV, this is a non issue since you almost never see a subtitle track in them, hardsubs yes, depending upon where a person got the source, but not generally a softsub. As for myself, for versatility, for those files I have that do have subtitle tracks, I keep a copy in SRT, ASS, and TTXT external files, as well as keep a TTXT track inside the file. If I ever revamp my collection into another format and change the container, it likely would be MKV, and all I'd need due is strip the tracks and reassemble them... and do them in abatch file and be done within a day.

Now FLV on the other hand does have known limitations when used with AAC/ACV, and even worse when used with Sorenson Spark codec instead, which is why I make sure none of the FLV's I have are ever above 852x480 or above 128 on the audio. I have seen some break these limitations, and normally do not work right until fixed.

I've actually seen very few AVI's at true 360, but know it is possible.

Any ideas on aspect ratios, are most 16:9, or 4:3 or 3:2 or something else? Any you can think of in other aspect ratios or odd sizes?
PCHeintz72
User avatar
Prism Power Senshi
Posts: 2696
 

Re: Media Collection Statistics

Postby frice2000 » Tue Aug 23, 2011 12:30 am

Pretty much all the Avis are 4:3. Pretty much all the flvs are 16:9/10. All of the mkvs are 16:9/10. That's all I remember off the top of my head. They're all up in Poughkeepsie while I'm down in New Jersey taking care of my fathers kitties while he's on vacation. And of course my router got struck by lightning before I left and I didn't have time to set up the port forwarding for the wol on the new garbage Actiontec router fios uses (but they do replace them for free when they break every other year so meh) , so I can't rdp in.

The main reason I don't like mp4 is iTunes keeps hijacking it back to itself. I change it open iTunes it changes associations back. I get it turned off and set properly and then Quicktime on a conversion open steals it back again. I would toss iTunes but my Amazon MP3 and Google Music work so easily with it, and I hate WMP even more. While other jukeboxes exist neither of the other two services I listed work well on them.
frice2000
User avatar
Asteroid Senshi
Posts: 572
 

Re: Media Collection Statistics

Postby PCHeintz72 » Tue Aug 23, 2011 12:56 am

Hmmm... I thought iTunes used m4v and m4a as its extensions...
PCHeintz72
User avatar
Prism Power Senshi
Posts: 2696
 

Re: Media Collection Statistics

Postby frice2000 » Tue Aug 23, 2011 1:03 am

It likes to steal those too. But those i've had a very easy time disabling it from using. Mp4 on the otherhand it never listens to me about. Quicktime, iTunes or bust. It's easy enough to do a right click open with KMPlayer but it does get annoying.
frice2000
User avatar
Asteroid Senshi
Posts: 572
 

Re: Media Collection Statistics

Postby Makoto » Tue Aug 23, 2011 1:04 am

The Windows versions of iTunes/Quicktime do indeed try to seize a large number of media file extensions, as I recall - and you have to go through a bit of work to get Quicktime not to do that. :( I'm not sure about iTunes, as it doesn't reclaim filetypes on my systems (can't remember if I expressly turned it off, or if Quicktime is the one that is really doing it...

Edit: Actually, M4V/M4A/M4P/etc. are MP4, just with renamed extensions (so you'll have a better idea what kind of .mp4 it is).
Still alive, but failing miserably at dodging Real Life.
My webpage has returned! http://www.fdnest.com/~makoto/
My Fanfiction.net profile: https://www.fanfiction.net/u/1473284/
Makoto
User avatar
Asteroid Senshi
Posts: 821
 

Re: Media Collection Statistics

Postby Spokavriel » Tue Aug 23, 2011 1:49 am

Main reason I'm not listing is because I'm uncertain if I could succeed in doing the tally. I don't exactly keep all my drives in the computer any more and between all of them I have saved multimedia from the internet going back to when Cartoon Network first was advertising some of their shows in AOL with some Downloadable vids of 75x100 rez. RAW AVI
Image
Spamville Character ProfileArchived Current Senshi of Ophelia (Uranus VII).
My Console Video Games
Spokavriel
User avatar
Eternal Power Senshi
Posts: 47647
 

Re: Media Collection Statistics

Postby Cheb » Wed Sep 14, 2011 5:28 pm

Well, I got the CSV but as I have close to no experience with spreadsheets...

Total - 3468

Aspects
5:4 - 121
1.29 - 41
4:3 - 2077
3:2 - 143
16:9 - 967
plus a lot of some odd aspects, a few files each.

Height
1080 - 129 (my current machine is too weak to play them so I prefer lower resolutions. For example when I see several version of a new One Piece episode I'll download the 360px one).
720 - 555
640 - 12
576 - 33
544 - 28
540 - 48
528 - 15
496 - 48
480 - 1098
448 - 170
432 - 440
384..396 - 263
360..368 - 156
352 - 126
320..340 - 59
300..306 - 47
288 - 113
240 - 65

Though I must admit I like to keep a lot of older TV series around, like DB, Space Battleship Yamato(1974), the primordial Cutie Honey (1973) and so on. That affects both the aspect and the resolution.
Proud owner of 1.5 kilograms of Germanium transistors
Cheb
User avatar
Moon Senshi
Posts: 1411
 

Re: Media Collection Statistics

Postby PCHeintz72 » Thu Sep 15, 2011 4:58 pm

Interesting numbers...

Had no idea 432p would be common out in the field... maybe just the sites you go to.

As for you computer capabilities being unable to reliably render 1080p... I can understand that, my lowest machine is that way, but it makes no difference, that is a old HTPC I build for a SDTV, trying to play HDTV 720p or 1080p on it would be a coomplete waste. I'll be getting rid of it eventually, I only use that in the basement when I exercise.

I generally always will pick something smaller than 1080p. It uses more hard drive space, takes longer to download, and currently I only have 1 screen in the house that can play them natively, and so wish DVD HD had won the format wars, so it is a waste. So I pick 480p or 720p over 1080p.

Note my own numbers reflect only videos, I actually excluded episodes and movies. But even counting them I only have around 2100, with 850 or so as videos.
PCHeintz72
User avatar
Prism Power Senshi
Posts: 2696
 

Re: Media Collection Statistics

Postby frice2000 » Thu Sep 15, 2011 5:47 pm

Heh tried to do this a couple days ago all the programs you listed crashed out. Too many terabytes of info I guess.
frice2000
User avatar
Asteroid Senshi
Posts: 572
 

Re: Media Collection Statistics

Postby Spokavriel » Thu Sep 15, 2011 5:50 pm

How could I run it? There are 8 computers. None of them networked together. and an additional 3 drives not even inside a computer right now. Technically the computer they go in is in pieces that could go back together but still wouldn't have a power supply.
Image
Spamville Character ProfileArchived Current Senshi of Ophelia (Uranus VII).
My Console Video Games
Spokavriel
User avatar
Eternal Power Senshi
Posts: 47647
 

Re: Media Collection Statistics

Postby PCHeintz72 » Fri Sep 16, 2011 4:32 pm

Spokavriel wrote: How could I run it? There are 8 computers. None of them networked together. and an additional 3 drives not even inside a computer right now. Technically the computer they go in is in pieces that could go back together but still wouldn't have a power supply.

Actually... I'm not trying to make anyone run it, I merely was interested in the statistics....

However, there *IS* a way. Media Info actually supports this to an extent...

You can go through the procedure I listed before. the first time or system, doit as I said. But take the file, save it to the thumbdrive or portable HD, take it to the next system, INSERT IGNORE the thumbdrive, run mdeiainfo again. However, on that one, there is a checkbox for *append* at the bottom of the screen when specifying the export file... specify the saved file, but make sure the checkbox is checked. It will add the new videos to the end of the file.

One cavat... you should make sure the settings on the export window are the same between systems, as if they differ, while it will still append the info, the columns might not line up in whatever spreadsheet you load it in.
PCHeintz72
User avatar
Prism Power Senshi
Posts: 2696
 


Return to Other Talk

Who is online

Users browsing this forum: No registered users