robert

Architectural contractor: Contracting firm

2008-09-06T14:58:41.0012Z

I have done very little schema design, and agree that it should not be unnecesarily complex. However, since freebase includes people, companies and structures, and since structrues are worked on by so many companies and people, and many of those companies and people have worked on many structures; it seems like there is some inherant complexity. I will check out your types mentioned here. Also I am working on some under my domain "project management". (very incomplete) let me know what you think.

As for general / sub contractor, maybe something similar to "parent contractor" - that links to itself, and links in as "sub-contractor", since again, it is a role, and one contractor can be both. A child (or sub) to one contractor and a parent to a differet or several different contractors.

Contributing Large Datasets: NNDB Links for People

2008-09-05T21:34:58.0012Z

Thanks Brian. The exact count should be 19,619 writes to the API with 2 properties being updated each time.

Contributing Large Datasets: NNDB Links for People

2008-09-05T17:33:09.0000Z

I believe the normal limit is 10,000 writes. I'll see if I can get your limit increased.

Contributing Large Datasets: NNDB Links for People

2008-09-05T03:28:16.0012Z

I've uploaded a new version of the data to the sandbox. If no one has any objections, I'll add it to the main site.

Is there a limit on how many writes I can do on the main site? Will I be able to make 19,000 writes in a day?

Architectural contractor: Contracting firm

2008-09-05T00:25:55.0012Z

similar issues exists with other properties of /architecture/structure: architectural firm, engineering firm, architect, engineer. you're right. it's not well normalized. i like your idea of a mediator/role. I think what I'd like to do is keep the properties that I currently have on /architecture/structure

architectural firm
contractor
engineering firm

and have the expected type for each one be a different mediator type with a whole bunch of information about the role:

project
client
firm
start date
end date

perhaps, in the case of the contractor role there could be someone way of "tagging" the role as one of sub or general contractor. other properties could be added as needed: list of staff members and their roles? there is some question about how much detail we really need, as with it comes schema complexity. anyhow, any other thoughts on this?

Architecture firm: Projects not just structure type?

2008-09-02T10:53:33.0012Z

Agreed! Also, many times the design consultant is not the architect of record. An architecture firm might be working for the owner, or for the contractor, or even another architecture firm. The architectural consultant can provide many different services including things like interior design or specifications. Technically the master plan can include structures even if they are not yet built. However, there needs to be something more. I have been working on this myself. How do we edit this table? Paul Shanks

Architectural contractor: Contracting firm

2008-09-02T08:36:59.0018Z

I think the "architectural contractor" table should be a mediator - not a topic. A contractor is a role, not a company. This role requires a client, a project and a contracting firm. Also, a distinction is often made between the general contractor and sub contractors - neither fo which are architectural. Thoughts?

robert: Is this image copyright free?

2008-08-29T22:17:30.0000Z

benjamin, here are two queries I threw together yesterday which might help you.

The first one gets a bunch of topics and any images associated with them, then tells you the license those images are under:

[
{
   "/common/topic/image" : [
     {
       "/common/licensed_object/license" : [],
       "id" : null,
       "name" : null
     }
   ],
   "id" : null,
   "limit" : 20,
   "name" : null,
   "type" : "/people/person"
}
]

This second one is roughly the same, but excludes licenses of a certain type -- in this case Fair Use:

[
{
   "/common/topic/image" : [
     {
       "/common/licensed_object/license" : [
         {
           "id" : null,
           "name" : null
         }
       ],
       "id" : null,
       "name" : null,
       "nofu:/common/licensed_object/license" : [
         {
           "id" : "/en/fair_use",
           "optional" : "forbidden"
         }
       ]
     }
   ],
   "id" : null,
   "limit" : 20,
   "name" : null,
   "type" : "/people/person"
}
]

Is this image copyright free?

2008-08-29T22:17:30.0000Z

benjamin, here are two queries I threw together yesterday which might help you.

The first one gets a bunch of topics and any images associated with them, then tells you the license those images are under:

robert: Is this image copyright free?

2008-08-29T20:30:04.0012Z

There are examples and documentation in the help center. If you only need to look at a couple of images, you can do it manually; the licensed pictures have a little license icon at the bottom. Unfortunately, some of the older images (like this one) were loaded before we required a license assertion for each one.

If you are loading many images at once, I would imagine that your application would require some other MQL usage anyway just to find them.

Is this image copyright free?

2008-08-29T20:30:04.0012Z

If you are loading many images at once, I would imagine that your application would require some other MQL usage anyway just to find them.

robert: Is this image copyright free?

2008-08-29T18:37:49.0012Z

Totally unfamiliar, but I do know other similar languages, so if you had an example that was close, I could disect and repurpose it. Thank you!

Is this image copyright free?

2008-08-29T18:37:49.0012Z

Totally unfamiliar, but I do know other similar languages, so if you had an example that was close, I could disect and repurpose it. Thank you!

robert: Is this image copyright free?

2008-08-29T02:41:42.0012Z

Yup, that's certainly true. If you're looking for stuff that's absolutely OK for commercial use, I suggest you use a MQL query to look into the license on an image, and limit it to those which have licenses that fit for your purposes (i.e. PD, CC-BY, or whatever). I can help you with that if you're unfamiliar with how to do it.

Is this image copyright free?

2008-08-29T02:41:42.0012Z

robert: Concert Hall

2008-08-28T22:54:42.0001Z

Ok, thank you

robert: Is this image copyright free?

2008-08-28T22:53:19.0000Z

Thank you for looking into it! Fair use for me is a bit different than copyright free (or some CC flavor) because it would impact the commercial use possibilities.

Is this image copyright free?

2008-08-28T22:53:19.0000Z

Thank you for looking into it! Fair use for me is a bit different than copyright free (or some CC flavor) because it would impact the commercial use possibilities.

robert: Is this image copyright free?

2008-08-28T21:26:54.0012Z

I suspect it was uploaded under the terms of fair use, but for some reason the image page doesn't say so. I'll check with the guy who uploaded it (I'm copying his user profile on this thread.)

Is this image copyright free?

2008-08-28T21:26:54.0012Z

I suspect it was uploaded under the terms of fair use, but for some reason the image page doesn't say so. I'll check with the guy who uploaded it (I'm copying his user profile on this thread.)

robert: Concert Hall

2008-08-28T20:54:28.0012Z

Go ahead and create a type in your own domain, then, as a prototype. We have generally eschewed types in the Commons that have no properties, but it is possible that your type will evolve. I would recommend that you include Structure and Location in your type.

robert: Concert Hall

2008-08-28T20:13:33.0012Z

I am not thinking of any new properties, I only need the list at the moment

robert: Concert Hall

2008-08-28T19:25:00.0012Z

Take a look at Micah’s draft Performance Venue type and Robert’s draft Performance venue as well. A concert hall is a kind of performance venue; what additional properties would it need that these Performance venue types don’t have?

robert: Concert Hall

2008-08-28T17:47:05.0005Z

Cris,

we need the "Concert Hall" Type and a list of concert halls, please. There are practically hundreds of them in the world

robert: Is this image copyright free?

2008-08-28T16:28:34.0018Z

Looks similar to the corporate stock photo, so I wanted to double-check the copyright status. Thanks!

Is this image copyright free?

2008-08-28T16:28:34.0018Z

Looks similar to the corporate stock photo, so I wanted to double-check the copyright status. Thanks!

Data Modeling Guide: Duplicate values

2008-08-26T13:15:38.0012Z

There is not, because the way you’ve structured your query, you are asking for the “acting gigs,” not the actors. It appears that Tambor did play two different roles on Arrested Development, and so two gigs are appropriate there. If you ask for the character in the cast, this will be more obvious.

Data Modeling Guide: Duplicate values

2008-08-26T07:51:14.0005Z

Hi,

I send this query:

[
{
    "name" : null,
    "original_network" : [
      {
        "network" : null
      }
    ],
    "regular_cast" : [
      {
        "actor" : null
      }
    ],
    "type" : "/tv/tv_program"
}
]

and i get an actor "Jefferey Tambor" that appear twice in "Arrested Development".

Is there anyway to ignore from duplicate values?

Tx All.

Contributing Large Datasets: NNDB Links for People

2008-08-21T03:06:20.0012Z

Looks like everything is working fine now in the new release. Thanks for fixing this.

Data Modeling Guide: New data

2008-08-19T05:12:35.0012Z

Hi,

Thanks a lot for your help.

The Big Lebowski: Lebowski Fest San Francisco - September 5th & 6th, 2008

2008-08-18T18:13:18.0017Z

Lebowski Fest San Francisco

Data Modeling Guide: Non-events

2008-08-16T04:21:31.0000Z

cool, thanks for the feedback. I will definitely bring this up on the list.

Contributing Large Datasets: NNDB Links for People

2008-08-15T18:01:15.0012Z

Ok, thanks guys. I'll watch for CLI-4538 in the release notes.

Contributing Large Datasets: NNDB Links for People

2008-08-15T16:35:59.0012Z

This sounds like simply a bug - you're right that the NYTimes links got added separately, and they'll probably need to be fixed. It may be too late to get a fix in for next week's release, but I'll try. For my and other's reference, this is CLI-4538 in our bug system.

Contributing Large Datasets: NNDB Links for People

2008-08-15T16:34:26.0012Z

Ah, yes, the char escaping with keys and URI templates... I am in the process of converting the NYT keys to use URI templating, and I also ran into that problem. There's a bug filed to have the UI behave properly when it encounters escaped URLs - I'll post back when there's a status update to this.

Toby (tsegaran) actually added a key, and created a discrete weblink (it's not using URI templating). When I implement the URI templating, I'll be removing the superfluous weblink.

BTW, good work!

Data Modeling Guide: Non-events

2008-08-15T15:58:39.0012Z

Ditto what Shawn said; a new type seems the best way to handle this. I would also strongly recommend bringing up this discussion on the data-modeling mailing list.

Data Modeling Guide: Non-events

2008-08-15T15:52:53.0012Z

That's a good point. Just because an event doesn't appear in Freebase doesn't mean you can assume that it didn't occur.

I would model this by co-typing the 1994 World Series topic with a Canceled Event type and then maybe add a property to say why it was canceled.

Data Modeling Guide: Non-events

2008-08-15T15:39:56.0007Z

I've been slowly adding the historical results of baseball's world series, and in thinking about the 1994 world series, I hit upon a bit of a hurdle: this world series didn't occur.

As a piece of information, this fact seems relevant to me. However, in terms of integrating the "non-event" into the site, it really doesn't fit at all with the structure of all the other world series results, namely, "winner, loser, score", etc.

I guess that my question, then, is how is one to deal with non-events that are nevertheless relevant precisely because of their exceptionalism? The expectation of a world series in 1994, given the pattern set both before and after the cancelled season, separates this instance from all others in its class. However, since the actual event never occurred, I’m not sure if representing it in the current schema is either (i) possible or (ii) desirable.

There are other examples of this kind of expected-but-never-occurred event, notably in sports, and I was wondering if there are any ideas/suggestions on how to represent this type of information.

Thanks

Contributing Large Datasets: NNDB Links for People

2008-08-15T15:29:03.0012Z

Ok, I've created the namespace, I've set up the enumeration property on the NNDB Person type and I've attached a URI template to that property.

Then I added a sample key to the Paul Newman topic and the NNDB link shows up as expected. Unfortunately, the ID has a forward slash in it which gets escaped and breaks the link. I went back to the Foreign Key Property and explicitly disabled URI encoding but that hasn't fixed it. Any ideas on how to handle this?

Coincidentally, tsegaran added a foreign key to a NYT page on the same Paul Newman topic and his key also contains forward slashes but he seems to have entered the weblink seperately without using a URI template.

Contributing Large Datasets: NNDB Links for People

2008-08-11T16:34:01.0000Z

Oh, yeah! It’s totally done and I forgot to come back here.

First, I made namespaces (/authority/imdb/film, name, character). Then I made properties that enumerate those namespaces and attached URI templates to them.

Check out the IMDb profile property on film. It expects Enumeration as its type. Then you have to get a little fancy and switch to the admin view. Set the Enumeration property of the property to the expected namespace. Then co-type the property as a Foreign key property and set a URI template. Set its type to URI Template and fill in both the canonical template (used to generate and recognize URIs) and the other templates (used only for recognition).

The schema UI will support this at some point… just not yet, as it’s kind of a power-user thing.

Contributing Large Datasets: NNDB Links for People

2008-08-11T05:35:53.0012Z

Have you made any progress on this? I've looked at the documentation on enumerations but I can't figure out how to apply it to my model.

Data Modeling Guide: New data

2008-08-07T17:19:48.0012Z

To be precise, Bryan’s query will find things that were created this month, which are also of type /film/film. To find new assertions, you have to get a little more complicated.

[
{
    "id" : null,
    "type" : {
      "id" : "/film/film",
      "link" : {
        "timestamp>" : "2008-08"
      }
    }
}
]

will find things who have had their film type asserted this month.

[
{
    "id" : null,
    "type" : [
      {
        "id" : null,
        "link" : {
          "timestamp>" : "2008-08"
        }
      }
    ]
}
]

will find things that have had new types added this month. In general, for any property assertion, you can ask about the timestamp on the link.

Data Modeling Guide: New data

2008-08-07T16:29:24.0012Z

You can query against the timestamp, something along the lines of:

[
{
    "name" : null,
    "timestamp" : null,
    "timestamp>" : "2008-08",
    "type" : "/film/film"
}
]

This returns films that were added this month.

Data Modeling Guide: New data

2008-08-07T04:30:18.0017Z

Hi,

How can i get the data that were added from specific date (mqlread)

Tx.

Data Modeling Guide: Linking Cities to Countries

2008-08-06T22:13:31.0016Z

In your MQL query, you can ask for the types of the topics in the containment - something like:

{"id":"/en/united_states", "contains":[{"id":null, "type":[]}], "type":"/location/location"}

Data Modeling Guide: Linking Cities to Countries

2008-08-06T19:02:22.0012Z

When returned in the query, is there any way to discern which is the top level? i.e. is there any order to the way the data is returned?

Data Modeling Guide: Linking Cities to Countries

2008-08-06T17:48:36.0018Z

In some ideal data-world, all administrative divisions for all countries would be entered, with the proper contains/contained by nesting, so that you would only need to add a city's immediate administrative division to assert that it was also in the country that contains the division (or that contains the division that contains the division, etc.). But since we don't (yet) live in such a world, go ahead and use the "contains/contained by" properties.

Data Modeling Guide: Linking Cities to Countries

2008-08-06T17:13:03.0017Z

What is the most appropriate way to link a city to the country in which it is located? I gather that contained by is for the level directly above it and that administrative division is reserved for states, counties, provinces, etc.

Employer in fiction: Related question

2008-07-21T17:57:51.0000Z

Why not just use the fictional employer type?

Employer in fiction: Related question

2008-07-09T18:14:30.0012Z

Sure - I'll put it in our queue.