[Developers] Town/City to Country?

[Mark CE]

Hello all,
I personally think that we need to denormalise the Town/City model a 
little to allow direct navigation Town-->Country.

But in the absence of this, given that right now we have to use the 
"contained by" relationship, can anyone help me with a query or some 
code that will return the Country given an existing Town on Freebase, 
even if the "contained by" relationship goes through several levels, 
eg Country--Region--County--Town or Country--State--Town?  And will 
return a "not defined" response if the Country is not discovered by the query?

I suppose it would involve walking up the contained by relationships 
until it hits a location that is also a Country.

And then could we do a query that, given an existing Town and Country 
name, will add the contained by relationship so that we can act upon 
the "not defined" response & populate the database over time?

Hopefully, though, someone will read this and see fit simply to add a 
"Country" property for the Town/City type!!!!!!!
You know it makes sense!

Yours hopefully
Mark CE 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freebase.com/pipermail/developers/attachments/20071120/8a322a8a/attachment-0001.htm 
-------------- next part --------------


No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.503 / Virus Database: 269.16.0/1139 - Release Date: 19/11/2007 12:35