wikidata.py 8.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238
  1. import json
  2. from requests import get
  3. from urllib import urlencode
  4. resultCount=1
  5. urlSearch = 'https://www.wikidata.org/w/api.php?action=query&list=search&format=json&srnamespace=0&srprop=sectiontitle&{query}'
  6. urlDetail = 'https://www.wikidata.org/w/api.php?action=wbgetentities&format=json&props=labels%7Cinfo%7Csitelinks%7Csitelinks%2Furls%7Cdescriptions%7Cclaims&{query}'
  7. urlMap = 'https://www.openstreetmap.org/?lat={latitude}&lon={longitude}&zoom={zoom}&layers=M'
  8. def request(query, params):
  9. params['url'] = urlSearch.format(query=urlencode({'srsearch': query, 'srlimit': resultCount}))
  10. return params
  11. def response(resp):
  12. results = []
  13. search_res = json.loads(resp.text)
  14. wikidata_ids = set()
  15. for r in search_res.get('query', {}).get('search', {}):
  16. wikidata_ids.add(r.get('title', ''))
  17. language = resp.search_params['language'].split('_')[0]
  18. if language == 'all':
  19. language = 'en'
  20. url = urlDetail.format(query=urlencode({'ids': '|'.join(wikidata_ids), 'languages': language + '|en'}))
  21. htmlresponse = get(url)
  22. jsonresponse = json.loads(htmlresponse.content)
  23. for wikidata_id in wikidata_ids:
  24. results = results + getDetail(jsonresponse, wikidata_id, language)
  25. return results
  26. def getDetail(jsonresponse, wikidata_id, language):
  27. results = []
  28. urls = []
  29. attributes = []
  30. result = jsonresponse.get('entities', {}).get(wikidata_id, {})
  31. title = result.get('labels', {}).get(language, {}).get('value', None)
  32. if title == None:
  33. title = result.get('labels', {}).get('en', {}).get('value', None)
  34. if title == None:
  35. return results
  36. description = result.get('descriptions', {}).get(language, {}).get('value', None)
  37. if description == None:
  38. description = result.get('descriptions', {}).get('en', {}).get('value', '')
  39. claims = result.get('claims', {})
  40. official_website = get_string(claims, 'P856', None)
  41. if official_website != None:
  42. urls.append({ 'title' : 'Official site', 'url': official_website })
  43. results.append({ 'title': title, 'url' : official_website })
  44. wikipedia_link_count = 0
  45. if language != 'en':
  46. wikipedia_link_count += add_url(urls, 'Wikipedia (' + language + ')', get_wikilink(result, language + 'wiki'))
  47. wikipedia_en_link = get_wikilink(result, 'enwiki')
  48. wikipedia_link_count += add_url(urls, 'Wikipedia (en)', wikipedia_en_link)
  49. if wikipedia_link_count == 0:
  50. misc_language = get_wiki_firstlanguage(result, 'wiki')
  51. if misc_language != None:
  52. add_url(urls, 'Wikipedia (' + misc_language + ')', get_wikilink(result, misc_language + 'wiki'))
  53. if language != 'en':
  54. add_url(urls, 'Wiki voyage (' + language + ')', get_wikilink(result, language + 'wikivoyage'))
  55. add_url(urls, 'Wiki voyage (en)', get_wikilink(result, 'enwikivoyage'))
  56. if language != 'en':
  57. add_url(urls, 'Wikiquote (' + language + ')', get_wikilink(result, language + 'wikiquote'))
  58. add_url(urls, 'Wikiquote (en)', get_wikilink(result, 'enwikiquote'))
  59. add_url(urls, 'Commons wiki', get_wikilink(result, 'commonswiki'))
  60. add_url(urls, 'Location', get_geolink(claims, 'P625', None))
  61. add_url(urls, 'Wikidata', 'https://www.wikidata.org/wiki/' + wikidata_id + '?uselang='+ language)
  62. musicbrainz_work_id = get_string(claims, 'P435')
  63. if musicbrainz_work_id != None:
  64. add_url(urls, 'MusicBrainz', 'http://musicbrainz.org/work/' + musicbrainz_work_id)
  65. musicbrainz_artist_id = get_string(claims, 'P434')
  66. if musicbrainz_artist_id != None:
  67. add_url(urls, 'MusicBrainz', 'http://musicbrainz.org/artist/' + musicbrainz_artist_id)
  68. musicbrainz_release_group_id = get_string(claims, 'P436')
  69. if musicbrainz_release_group_id != None:
  70. add_url(urls, 'MusicBrainz', 'http://musicbrainz.org/release-group/' + musicbrainz_release_group_id)
  71. musicbrainz_label_id = get_string(claims, 'P966')
  72. if musicbrainz_label_id != None:
  73. add_url(urls, 'MusicBrainz', 'http://musicbrainz.org/label/' + musicbrainz_label_id)
  74. # musicbrainz_area_id = get_string(claims, 'P982')
  75. # P1407 MusicBrainz series ID
  76. # P1004 MusicBrainz place ID
  77. # P1330 MusicBrainz instrument ID
  78. # P1407 MusicBrainz series ID
  79. postal_code = get_string(claims, 'P281', None)
  80. if postal_code != None:
  81. attributes.append({'label' : 'Postal code(s)', 'value' : postal_code})
  82. date_of_birth = get_time(claims, 'P569', None)
  83. if date_of_birth != None:
  84. attributes.append({'label' : 'Date of birth', 'value' : date_of_birth})
  85. date_of_death = get_time(claims, 'P570', None)
  86. if date_of_death != None:
  87. attributes.append({'label' : 'Date of death', 'value' : date_of_death})
  88. if len(attributes)==0 and len(urls)==2 and len(description)==0:
  89. results.append({
  90. 'url': urls[0]['url'],
  91. 'title': title,
  92. 'content': description
  93. })
  94. else:
  95. results.append({
  96. 'infobox' : title,
  97. 'id' : wikipedia_en_link,
  98. 'content' : description,
  99. 'attributes' : attributes,
  100. 'urls' : urls
  101. })
  102. return results
  103. def add_url(urls, title, url):
  104. if url != None:
  105. urls.append({'title' : title, 'url' : url})
  106. return 1
  107. else:
  108. return 0
  109. def get_mainsnak(claims, propertyName):
  110. propValue = claims.get(propertyName, {})
  111. if len(propValue) == 0:
  112. return None
  113. propValue = propValue[0].get('mainsnak', None)
  114. return propValue
  115. def get_string(claims, propertyName, defaultValue=None):
  116. propValue = claims.get(propertyName, {})
  117. if len(propValue) == 0:
  118. return defaultValue
  119. result = []
  120. for e in propValue:
  121. mainsnak = e.get('mainsnak', {})
  122. datavalue = mainsnak.get('datavalue', {})
  123. if datavalue != None:
  124. result.append(datavalue.get('value', ''))
  125. if len(result) == 0:
  126. return defaultValue
  127. else:
  128. #TODO handle multiple urls
  129. return result[0]
  130. def get_time(claims, propertyName, defaultValue=None):
  131. propValue = claims.get(propertyName, {})
  132. if len(propValue) == 0:
  133. return defaultValue
  134. result = []
  135. for e in propValue:
  136. mainsnak = e.get('mainsnak', {})
  137. datavalue = mainsnak.get('datavalue', {})
  138. if datavalue != None:
  139. value = datavalue.get('value', '')
  140. result.append(value.get('time', ''))
  141. if len(result) == 0:
  142. return defaultValue
  143. else:
  144. return ', '.join(result)
  145. def get_geolink(claims, propertyName, defaultValue=''):
  146. mainsnak = get_mainsnak(claims, propertyName)
  147. if mainsnak == None:
  148. return defaultValue
  149. datatype = mainsnak.get('datatype', '')
  150. datavalue = mainsnak.get('datavalue', {})
  151. if datatype != 'globe-coordinate':
  152. return defaultValue
  153. value = datavalue.get('value', {})
  154. precision = value.get('precision', 0.0002)
  155. # there is no zoom information, deduce from precision (error prone)
  156. # samples :
  157. # 13 --> 5
  158. # 1 --> 6
  159. # 0.016666666666667 --> 9
  160. # 0.00027777777777778 --> 19
  161. # wolframalpha : quadratic fit { {13, 5}, {1, 6}, {0.0166666, 9}, {0.0002777777,19}}
  162. # 14.1186-8.8322 x+0.625447 x^2
  163. if precision < 0.0003:
  164. zoom = 19
  165. else:
  166. zoom = int(15 - precision*8.8322 + precision*precision*0.625447)
  167. url = urlMap.replace('{latitude}', str(value.get('latitude',0))).replace('{longitude}', str(value.get('longitude',0))).replace('{zoom}', str(zoom))
  168. return url
  169. def get_wikilink(result, wikiid):
  170. url = result.get('sitelinks', {}).get(wikiid, {}).get('url', None)
  171. if url == None:
  172. return url
  173. elif url.startswith('http://'):
  174. url = url.replace('http://', 'https://')
  175. elif url.startswith('//'):
  176. url = 'https:' + url
  177. return url
  178. def get_wiki_firstlanguage(result, wikipatternid):
  179. for k in result.get('sitelinks', {}).keys():
  180. if k.endswith(wikipatternid) and len(k)==(2+len(wikipatternid)):
  181. return k[0:2]
  182. return None