sparql - How to handle Wikipedia Named Entities that have the same Category name -


i trying extract companies ran following query

prefix cat: <http://dbpedia.org/resource/category:>  prefix dcterms: <http://purl.org/dc/terms/>  prefix skos: <http://www.w3.org/2004/02/skos/core#>  select distinct ?page ?subcat  { ?subcat skos:broader* cat:companies_of_the_united_states_by_industry .  ?page dcterms:subject ?subcat .  ?page  rdfs:label ?pagename.  }

this snapshot of results enter image description here

amgen , pfizer both companies category, end collecting under pfizer , amgen (people, product). found out these entries belong wikipedia category called category:wikipedia_categories_named_after_companies_of_the_united_states or category:wikipedia_categories_named_after_pharmaceutical_companies_of_the_united_states. tried filter these categories did this

select distinct ?page ?subcat  { ?subcat skos:broader* cat:companies_of_the_united_states_by_industry .  ?page dcterms:subject ?subcat .  ?page  rdfs:label ?pagename.  filter( !regex(?subcat,"wikipedia_categories_named_after_pharmaceutical_companies_of_the_united_states")) }

but no luck, still there. idea how avoid problem?

the problem doesn't have them having same name. wikipedia categories don't form type hierarchy, doesn't make sense treat them one. reason see results you're seeing there's category pfizer, , broader values include company listings, dcterms:subject of dbpedia:alprazolam, dbpedia:cetirizine, etc. doesn't make sense type hierarchy, fine organizing article topics. if want companies back, ask things companies:

select distinct ?page ?subcat  {   ?subcat skos:broader* category:companies_of_the_united_states_by_industry .    ?page dcterms:subject ?subcat .    ?page rdfs:label ?pagename.    ?page dbpedia-owl:company }

we can clean bit, though. you're not using ?label, can remove it. can use of shorter syntaxes make things little bit cleaner. can note "companies … industry" has skos:broader value "companies of united states" makes intent of query bit clearer. 

select distinct ?company ?subcategory  {   ?company dcterms:subject ?subcategory ;            dbpedia-owl:company .   ?subcategory skos:broader* category:companies_of_the_united_states .  } limit 1000

sparql results

as final note, category hierarchy doesn't mean each company has single path top category. is, company listed multiple times, e.g.:

company   subcategory ------------------------------------ companyx  textile_companies companyx  companies_in_new_hampshire

unless need listing of subcategories, might consider eliminating query, in case can have (using property paths):

select distinct ?company {   ?company dbpedia-owl:company ;            dcterms:subject/skos:broader* category:companies_of_the_united_states . } limit 1000

sparql results


Comments

Post a Comment

Popular posts from this blog

javascript - RequestAnimationFrame not working when exiting fullscreen switching space on Safari -

request animation frame stops working when exiting fullscreen clicking on original space's safari window. fine if fullscreen mode canceled escape key or calling cancelfullscreen(). steps reproduce: open https://dl.dropboxusercontent.com/u/769042/prezi/safari-fullscreen.html click "draw raf", kittie appears click "fullscreen", go fullscreen click "draw raf", kittie appears go space original safari was, showing "click exit fullscreen mode", click anywhere, out fullscreen click "draw raf", nothing happens what handling click calling: window.requestanimationframe(draw); which draws on canvas context: function draw() { ctx.drawimage(img, math.random()*500|0, math.random()*400|0, 100, 100); } i checked .hidden , .visibilitystate, updated correctly. tested on osx 10.9.3, safari 7.0.4 (9537.76.4). has workaround/solution other switching old settimeout? this sounds webkit bug 88940 : using reque
Read more

Python ctypes access violation with const pointer arguments -

i have api i'm trying wrap in python (2.7.6 on win7) code using ctypes. here's api: client_dllfunc bool clientapi search_exporttoclipcopy(clienthsearch handle, int channel, lpctstr filename, const time_t& from, const time_t& to, const bool* cameras, int length, bool usepassword, lpctstr password, bool includetextin = false, bool excludeplayer = false); the issue i'm having cameras argument; , i've had issue other const pointer arguments well. here's how i'm wrapping api: def search_exporttoclipcopy(self, hsearch, csearch, filename, tfrom, tto, cameras, length, usepassword, password, includetextin=true, excludeplayer=false): exporttoclipcopy = self.sdkdll.search_exporttoclipcopy exporttoclipcopy.argtypes = [c_int, c_int, c_wchar_p, c_long, c_long, pointer(c_bool), c_int, c_bool, c_wchar_p, c_bool, c_bool] exporttoclipcopy.restype = c_bool exporttoclipcopy(hsearch, csearch, filename, tfrom, tto, cameras, length, usepassword, pass
Read more