[Developers] Finding duplicate names?

[Alexander Marks]

There is no direct way to query for duplicate names in MQL. The solution is to cursor through every topic of type /location/postal_code and check for duplicates locally. I have attached a list of duplicate postal codes (there are 53), and I will also flag them for merge.  At some point we will start doing this sort of cleanup more regularly. Of course, not all types have the same degree of expected name uniqueness as postal codes in a given country do.

Al

----- Original Message -----
From: "Arthur van Hoff" <AVH at zing.net>
To: "For discussions about MQL, Freebase API and apps built on Freebase" <developers at freebase.com>
Sent: Monday, December 3, 2007 11:42:50 AM (GMT-0800) America/Los_Angeles
Subject: [Developers] Finding duplicate names?

Hi,

 

How do I query for all objects of a specific type that have duplicate names?

 

For example, there are two postal codes called “94025”.

 

“query”: [{

    "name":"94025",   

    "id":null

}]

 

 I’d like to generate a list of all other postal codes that have duplicates.

 

Thanks.
_______________________________________________
Developers mailing list
Developers at freebase.com
http://lists.freebase.com/mailman/listinfo/developers
-------------- next part --------------
A non-text attachment was scrubbed...
Name: duplicate_postal_codes.tsv
Type: application/octet-stream
Size: 320 bytes
Desc: not available
Url : http://lists.freebase.com/pipermail/developers/attachments/20071203/9a504df5/attachment-0001.obj