niallo

Food: Plain old food type

2008-07-18T16:40:02.0000Z

The USDA has a fairly extensive database of nutritional data (per 100g unit) available for download at: http://www.ars.usda.gov/Services/docs.htm?docid=8964

It includes base ingredients (e.g. various cuts of meat), both cooked and uncooked. If you're looking for nutritional information or ideas on how to classify it, that may be a good place to start.

The data consists of multiple files - one per table - containing one record per line in a fixed width text format. It probably wouldn't be too difficult for someone with time on their hands to write an importer for freebase.

Food: Dishes and ingredients

2008-07-18T01:06:20.0020Z

These three very well populated types have been moved into this domain.

Film: Movie Subtitles

2008-07-07T23:37:16.0012Z

Hi Ian --

Subtitles would be covered by copyright protection, so you would only be allowed to add them from films from the public domain or with an open license (such as CC-BY).

Copyright law, however, does allow small fragments from copyrighted works to be cited. I don't know what the limits are, but I imagine that many short subtitle snippets would be allowed per movie, perhaps from key scenes.

Also, aside from the contents of the subtitles themselves, what kind of metadata would you imagine having for subtitles? Freebase could store that information without restrictions.

R

Film: Movie Subtitles

2008-07-07T23:35:30.0000Z

It's great that you are finding a good use of our service! Thanks!

Our goal is to provide linkages between sets of data, not really to be a repository for data in of itself...

Thus we provide an excerpt of the associated wikipedia article as a blurb (but not recreate the entire article, that's what the linkages (and keys) back to Wikipedia are for. We allow for weblinks to sites that have specific and useful information about the topic but is of a restrictive licensed nature (IMDb for example).

Our database is not set up for large amounts of text. We encourage the use of text for specific notation about a specific property but not for than about almost a thousand characters.

Secondly, legality.

Your subtitles are a form of film script and would most likely be considered as property of the creators/owner of the film. At best they would be a grey area of legality to be made available in text form outside of the film, video tape or disc.

If it was a film you wrote and owned outright, and was published with an CC license, the providing the subtitles externally from the film would most likely be legal in that case ;)

What you could do is create your own type in your own private domain (default one or a more specifically named 'Film Subtitles' domain). The type could designed to contain what subtitles in what editions of the film (Theatrical Release/DVD/TV Broadcast) in what languages...Check out how the Film Regional Release Date is designed, though it may need not be a Compound Value Type.

http://www.freebase.com/tools/schema/film/film_regional_release_date

Film: Movie Subtitles

2008-07-07T07:50:45.0012Z

Hi all,

I have been using Freebase for a little while now to index my movie collection (where film information exist in Freebase) and, eventually, upload film information back to Freebase. I have subtitles for the majority of my films and think they would make a valuable addition to the Freebase Film schema (imagine querying for who said a particular line and in which films).

How would I go about adding a Subtitles schema to Freebase and linking it to the Films/TV schema?

Alternatively, if this schema already exists, could somebody point me at it? I searched but couldn't find it.

Cheers,

Ian

Food: Dishes and ingredients

2008-06-26T00:13:31.0012Z

I've created three types in my own food domain called Ingredient, Dish, and Type of Dish. We're (the data arch team) looking to promote these into this domain but thought we had better run it past the locals first. Thoughts?

Film: Multiple initial release dates - is this a bug?

2008-03-17T17:23:51.0007Z

Thanks Bryan!

Film: Multiple initial release dates - is this a bug?

2008-03-17T15:03:46.0007Z

It's not expected; I'll try to track down who did the update and let them know.

Film: Film production companies, distributors and other companies

2008-03-17T05:08:52.0007Z

I added these types to the production site and I reciprocated the relationships from the company types.

Film: Multiple initial release dates - is this a bug?

2008-03-17T01:33:45.0007Z

It doesn't make a lot of sense to me that the release dates would be added instead of updated. Is this expected behaviour?

Film: Multiple initial release dates - is this a bug?

2008-03-16T04:11:38.0007Z

Hmm, looks like inital release date is not restricted to one value, and if you look at the history, it looks like mw_template_bot is adding the date instead of updating.

Another good question is, what led you to check out the topic about the movie Gridlock'd!!!

Film: Multiple initial release dates - is this a bug?

2008-03-15T22:50:42.0005Z

Some /film/film instances have multiple values under "initial_release_date" property.

An example is Gridlock'd [ http://www.freebase.com/view/guid/9202a8c04000641f800000000086440a ]

Usually there is a full ISO format date (e.g. 1997-01-01] and a year-only date (e.g. 1997).

Is this a bug? The dates do not appear to be tied to a release in a particular country or anything like that.

Film: Multiple initial release dates?

2008-03-15T22:48:15.0012Z

Some /film/film instances have multiple values for initial_release_date property.

Example is:

Gridlock'd [ http://www.freebase.com/view/guid/9202a8c04000641f800000000086440a ]

Is this a bug? The dates do not seem tied to e.g. a release in a particular country, and generally I have noticed that there is a full ISO date and a year-only date value.

Food: Cocktail type?

2008-03-15T09:44:25.0000Z

I agree the ingredients are really the "killer app" for a cocktail type, although this does indeed seem like a difficult modelling property. Perhaps we could start with some very basic properties to get the ball rolling?

Food: Cocktail type?

2008-03-15T05:25:54.0014Z

faye - thadguidry has a fantastic food model if we can get him to help us move it into this domain. He models nutrients, ingredients, etc.. very cool

Food: Cocktail type?

2008-03-14T21:51:16.0013Z

I would vote for the ingredients to be included as a property. There was talk about creating a recipe type/property that list ingredient amounts as well, but nothing came out of it.

This would support queries like, "What cocktails use creme de cacao?"

Food: Cocktail type?

2008-03-14T20:54:37.0007Z

Good call, Niall. What properties would it have? Do you want to take a crack at modeling it?

Food: Cocktail type?

2008-03-14T20:09:51.0012Z

Seems like an obvious candidate for inclusion. There are many currently un-typed cocktails in the system.

Film: Film production companies, distributors and other companies

2008-03-12T00:06:23.0007Z

Nice. I wonder if it would make sense to create the reverse properties for the production companies, film companies, and film distributors. The reverse on production companies in particular seems like it would be useful; the others perhaps somewhat less so.

Film: Film production companies, distributors and other companies

2008-03-11T22:56:38.0005Z

I added three properties to type Film on Sandbox with several supporting types that cover:

1. Production companies -- this is a simple relationship between type Film and type Production Company.

2. Distributors -- This connects type film to type Film Distributor through a Compound Relationship Type (CRT) called Film-Film distributor relationship which includes properties for the year of distribution, the film cut type (director's, special edition) and the medium of distribution (Theatrical, VHS, DVD).

3. Other film companies -- This connects film to companies other than production companies and distrubutors (which are normally accorded a special status, so therefore singled out.) Type Film here connects to "Film Company" via a CRT called "Film-Film company relationship" which includes properties for the role or service provided by that company and which film cut type it contributed to.

Note here that I'm using a couple of new naming conventions. First, I'm suggesting the use of "CRT" for Compound Relationship Type instead of CVT or Compound value Type. This distinction will become increasingly important in the upcoming months as we bake a deeper distinction between these patterns into MQL.

Second, I've named these CRTs with a new convention that describes it as a relationship between two types. For example, "Film-Film company relationship" connects the types Film and Film company.

Here's a film topic example that includes all three ne properties filled out:

http://sandbox.freebase.com/view/guid/9202a8c04000641f80000000000665b4

You'll have to scroll down to the bottom of the Film section.

Please let me know what you think.

Food: Food Administrator request - Cajun Chef

2008-03-07T14:27:18.0007Z

Hey Thad -

I started to model some of my food proposal below but I explored, I came across some of your types like Macroingredient.

I'm really impressed, and I realized you've done a much better job at breaking this stuff down than I have. I'd like to offer that we move most of your food-related types into the food domain, and lets make you an administrator.

Here is my suggestion: go and "publish" all the types that you'd like to see moved into /food. (You can get there from the schema editor) - then we'll look over the list here, and see which ones should end up in food (I suspect most of them)

Food: Plain old food type

2007-12-16T23:36:38.0032Z

Also a property for the basic food type called 'form' or something similar would help add more detail to the original food type. You example of crackers containing powdered cheddar cheese is a good candidate. In that scneario 'ingrediant' itself would be a cvt between food A, food B and the form of the contained food. However things like HFCS complicate things a bit, but for the most part, it would be quite helpful as shredded cheddar cheese is different from powedered cheddar cheese.

Food: Plain old food type

2007-12-15T20:58:43.0000Z

Lets start thediscussion on food... My primary interest is in nutritional information and ingredients of "complex" foods. But I think this gets complex reasonably quickly.

For example, some brand of crackers may contain powered cheddar cheese, which is itself a food. But the nutritional value of the crackers probably can't be easily derived from Cheddar Cheese.. not to mention that Cheddar Cheese is itself a food. Cheddar Cheese contains cow's milk and rennet, but I don't think we'd consider rennet itself a food.

So my proposal is a type Food which has an included type Ingredient, as well as a property Ingredients which points to a list of Ingredients.

Food would have properties like Genre, maybe Country of origin, etc... but Ingredient would have stuff like "Nutritional information"

Nutritional Information would be a CVT which would indicate how many units of some nutritional thing, normalized to a "per 100g" unit (I think that's the standard in Europe, and the US is based on Serving Size, which is totally non-normalizable)

for example, cheddar cheese might have "2 mg of Vitamin A" - so the CVT for Nutritional Value would have an Integer quantity, a mass unit unit, and a nutritional thing.

Thoughts? I'll model this up on sandbox...

Food: Plain old food type

2007-11-13T20:03:03.0007Z

I have to agree.. then we could list the ingredients of Twinkie which appears in the wikipedia article.

Computer Game Platform: Platform iterations

2007-10-11T23:49:19.0005Z

II think that there is a need for an additional type, perhaps "Computer Game Platform Iteration", in order to correctly model for example the Nintendo DS or the Gameboy Advance series of portable consoles.

Under the current schema, I do not see a way to specify that e.g. the DS standard (or "phat" in homebrew scene parlance) and the DS Lite are both computer game platforms yet play the same games.

Really I suppose the platform should be "Nintendo DS" with the DS standard and DS lite being "iterations" (probably there is a better term) of it. This way, games can simply be marked as for "Nintendo DS" and show up under both the DS and DS Lite pages.

There are also three compatible versions of the Game Boy Advance. Things get more complicated with software compatibility here because some versions of the GBA can play older, original Game Boy games, just as the DS can play GBA games. I'm not quite sure how best to model all this.

Film: Created a new type (at my significant other's bequest) for Costume Design

2007-09-25T22:31:59.0012Z

Costume Design as a trade is quite distinct from Theatrical Costume Design in areas of responsibility (gentle hint to those responsible for the Theater domain)

All to find a niche for the inestimable Edith Head.

Food: Plain old food type

2007-09-15T17:10:00.0012Z

It would be good to have a plain old "food" type (very much like beverage) and perhaps a "food genre" type (fruit, dessert, meat, vegetable etc). There's lots of very simple things we can say about food that there's no way to express right now.

Food: Food Administrator request - Cajun Chef

2007-08-25T17:20:33.0007Z

I would imagine that some of the nutritional values for abstract food ingredients would be fuzzy. For instance, a pound of bananas grown in one geography may have different nutritional makeup than a pound of bananas grown in another (though I am not a dietician, so that may in fact be the case). When including this information, it would be important to tie the nutritional information most granularly to its source. For instance, if I buy a pound of bananas in my local grocery store, I should publish the nutritional information under "Chiquita Banana, Organically-Grown Variety, Grown 2007" (which is what the nutritional label is describing). This is much preferred over storing it under the generic "Banana".

This would be particularly useful if we use fb to store recipes. When constructing a recipe, we can bind our ingredients to a higher level of abstraction (for instance, "one pound of bananas" as opposed to "Chiquita Banana, Organically-Grown"), but we leave it to the user to be more specific in their ingredient selection. They may know that they're going to be using non-organically grown bananas from Dole. But, when implementing a recipe, they can integrate the nutrition information that best matches their ingredients at run-time, ultimately constructing more accurate nutritional info for their particular variation of the recipe.

niallo: cvs as a software genre

2007-08-07T23:39:13.0007Z

I think software ought not to be typed as protocol, communication spec perhaps? I posted something to that end here.

niallo: cvs as a software genre

2007-08-07T23:11:15.0032Z

CVS seems different to me from Vi because it could be seen as a network protocol and a file format. I think that the software implementation mentioned in the Wikipedia article is more correctly referred to as "GNU CVS". There are other implementations of CVS such as OpenCVS or CVSNT. In fact, I believe that the original "CVS" was a shell script front-end to RCS tools, and quite different from the GNU version.

Perhaps 'Software Genre' is not the correct type to describe CVS as a network protocol, file format and software program though - I'd be interested in other perspectives here.

niallo: cvs as a software genre

2007-08-04T13:04:14.0011Z

You marked cvs to be a software genre. It seems to me that it is also an implementation of the software, and that this is what the wikipedia article talks about. I realize that there are other implementations out there, and I have run into similar problems for vi, but loads of programs, especially on unix, are near copies of one another. Should these reference implementations be of type software genre and software, and belong to their own type? This can be generalized outside software too. I don't know if this is possible, but this is what seems to make most sense to me.

Food: Food Administrator request - Cajun Chef

2007-07-27T23:56:37.0007Z

That's the direction I've been hoping this'll go.

Food: Food Administrator request - Cajun Chef

2007-07-22T06:16:20.0007Z

In terms of the recipe type, what I think would be most excellent is if 'ingredients' could be types of their own. If that were done, the nutritional value could easily be calcuated by combining the given ingredients, which will also give client applications the ability to do more cool stuff. So 'flour' and 'oranges' would have nutritional information in the database which I could use for my own nefarious purposes :-)

Food: Food Administrator request - Cajun Chef

2007-07-19T18:47:44.0000Z

Hey, Thad. As I mentioned, you're timing on this question is right on: just this week, we've been rethinking the administrator role. We're still in the throes of this discussion, and I didn't want to leave you hanging while we figure it out. The good news is that--if I'm reading you right--you can already do the things you want to do. As you've discovered, you can create types and publish them so that other people can use them; and you can fill them with data. A number of people have talked about working on a recipe type (me included), but it would be pretty complex, and we yet to see anything come to life. It looks like you've started down this path, too, and it would be great if you were to work on this model. Don't know if you've seen it, but we do have some help info on data modeling (check the lower left corner of the Help index): http://www.freebase.com/view/helpindex?id=%239202a8c04000641f80000000012090ef As we get the admin role sorted out, I'll let you know. Best, Sarah

Food: Food Administrator request - Cajun Chef

2007-07-17T23:53:03.0007Z

I'd like to see Freebase store every food value you can imagine, first of all. Calories, Carbs, Protein, Vitamin B12, you name it. As an administrator, I would like to categorize types of Foods into their Ethnicities first. We all have recipes and most originate from some small part in the world. Bruschetta for instance is an uniquely Italian bread dish that is super simple. Bread. But, not many people associate the experience of Brushetta without the new season's olive oil to compare it with. Hence, Bruschetta (also known as toast or Rusks) is uniquely tied to Olive Oil. And it's uniquely Tuscan, more specific than just Italian. Not everyone knows these things or wants to, but Food Domain admins should, or at least have the ready access and know how to correctly TYPE Brushetta as a /Tuscan/Bread model and not just /Tuscan/Recipe. And correctly applying Olive Oil as a hard link to it, somehow, since without, it's just household bread that's been toasted. I won't mention the various degrees of tomatoes and cheese that sometimes dribble on top of Bruschetta at restaurants worldwide. But that's another Type altogether... Ingenuity. So what I'd put into being an Admin would be very detailed and accurate categorizations for World Foods and Recipes. My handy volumes that I use daily as reference ? Oxford Companion to Food, Larousse Gastronomique, Oxford's Food & Nutrition Values, just to name a few. Also, answering questions that may come up such as "Why isn't Schabziger also known as Goat's Cheese?" The answer? It's ALWAYS made with Cow's Milk, even though the German word for Goat is "Ziege".

Food: Food Administrator request - Cajun Chef

2007-07-17T17:13:29.0007Z

Hey, Thad. It's been great to see you so active on the site lately! I'm personally interested in the food domain, and as it happens, I'm also drafting new guidelines on the domain administrator role generally. With that combo in mind, it would be really useful to hear what you'd like get out of and put into the food admin role. Feel free to continue the discussion here or to reply email, sarah@metaweb.com. Best, Sarah

Food: Food Administrator request - Cajun Chef

2007-07-13T15:40:03.0004Z

Hi, I used to work as a Cajun Chef and of course still cook a mean gumbo. I also work at a public library where indexing and cataloging are priority. I have vast PD resources to help in our endeavor to make Freebase expand it's Gastronomical Heirarchy. (grin)