def get_place_profile(uri, types):
"""
Example return value::
{'areaKm': '603628',
'areaSqMi': '233090',
'capital': 'http://dbpedia.org/resource/Kiev',
'latitude': '49.0',
'leaders': {'http://dbpedia.org/resource/Mykola_Azarov': 'Mykola Azarov',
'http://dbpedia.org/resource/Viktor_Yanukovych': 'Viktor Yanukovych',
'http://dbpedia.org/resource/Volodymyr_Rybak': 'Volodymyr Rybak'},
'longitude': '32.0',
'population': '44854065',
'populationDensityKm': '77',
'populationDensitySqMi': '199',
'populationYear': '2012',
'photos': ['http://foo.com/photo.jpg'],
'sources': ['Flickr']
}
"""
uri = _quote(uri)
query = '''
SELECT *
WHERE {{
<{uri}> geo:lat ?latitude;
geo:long ?longitude .
OPTIONAL {{ <{uri}> dbp:capital ?capital . }}
OPTIONAL {{ <{uri}> dbp:leaderName ?leaders . }}
OPTIONAL {{
<{uri}> dbp:areaKm ?areaKm;
dbp:areaSqMi ?areaSqMi . }}
OPTIONAL {{
<{uri}> dbp:populationEstimate ?population;
dbp:populationEstimateYear ?populationYear . }}
OPTIONAL {{
<{uri}> dbp:populationDensityKm ?populationDensityKm;
dbp:populationDensitySqMi ?populationDensitySqMi . }}
}}
'''.format(uri=uri)
results = _get_results(query)
# Get the names for each leader.
leaders = {}
for leader in [
result['leaders'] for result in results
if result.get('leaders', None)
]:
leaders[leader] = name_for_uri(leader)
profile = None
if results:
profile = results[0]
profile['leaders'] = leaders
profile['types'] = types
services.process(profile, {'flickr': ['photos_at_location']})
return profile
def get_company_profile(uri):
"""
Example return value::
{'assets': 'US$ 93.80 billion',
'contributions': [{
'direct_amount': '0',
'direct_count': '0',
'employee_amount': '1602978.00',
'employee_count': '2274',
'id': '4148b26f6f1c437cb50ea9ca4699417a',
'name': 'Barack Obama (D)',
'party': 'D',
'state': '',
'total_amount': '1602978.00',
'total_count': '2274'
}],
'party_contributions': {
'Democrats': ['5157', '6166411.11'],
'Other': ['831', '2022397.43'],
'Republicans': ['1114', '1998822.25']
},
'employees': '53861',
'income': 'US$ 10.74 billion',
'name': 'Google',
'revenue': 'US$ 50.18 billion',
'subsidiaries': [{
'http://dbpedia.org/resource/YouTube': {
'image': 'http://upload.wikimedia.org/wikipedia/commons/e/e8/Logo_Youtube.svg',
'name': 'YouTube'
}
}],
'symbol': 'GOOG',
'sources': ['Influence Explorer']
}
"""
# MISSING
# Perhaps need to be using dbpedia live for this.
#dbo:parentCompany ?children;
#dbo:owningCompany ?owns;
#dbo:board ?board;
#dbo:developer ?products;
#dbo:manufacturer ?moreproducts .
uri = _quote(uri)
query = '''
SELECT *
WHERE {{
<{uri}> rdfs:label ?name;
dbo:subsidiary ?subsidiaries;
dbo:numberOfEmployees ?employees;
dbp:symbol ?symbol;
dbp:assets ?assets;
dbp:netIncome ?income;
dbp:revenue ?revenue .
}}
'''.format(uri=uri)
results = _get_results(query)
# Get the names for each subsidiary.
subsidiaries = {}
for subsidiary in [result['subsidiaries'] for result in results]:
# This should be combined into a single query.
subsidiaries[subsidiary] = {'name': name_for_uri(subsidiary), 'image': image_for_uri(subsidiary)}
profile = None
if results:
profile = results[0]
profile['subsidiaries'] = subsidiaries
services.process(profile, {
'influence_explorer': [
'recipients_for_organization',
'parties_for_organization'
]
})
return profile
def get_place_profile(uri, types):
"""
Example return value::
{'areaKm': '603628',
'areaSqMi': '233090',
'capital': 'http://dbpedia.org/resource/Kiev',
'latitude': '49.0',
'leaders': {'http://dbpedia.org/resource/Mykola_Azarov': 'Mykola Azarov',
'http://dbpedia.org/resource/Viktor_Yanukovych': 'Viktor Yanukovych',
'http://dbpedia.org/resource/Volodymyr_Rybak': 'Volodymyr Rybak'},
'longitude': '32.0',
'population': '44854065',
'populationDensityKm': '77',
'populationDensitySqMi': '199',
'populationYear': '2012',
'photos': ['http://foo.com/photo.jpg'],
'sources': ['Flickr']
}
"""
uri = _quote(uri)
query = '''
SELECT *
WHERE {{
<{uri}> geo:lat ?latitude;
geo:long ?longitude .
OPTIONAL {{ <{uri}> dbp:capital ?capital . }}
OPTIONAL {{ <{uri}> dbp:leaderName ?leaders . }}
OPTIONAL {{
<{uri}> dbp:areaKm ?areaKm;
dbp:areaSqMi ?areaSqMi . }}
OPTIONAL {{
<{uri}> dbp:populationEstimate ?population;
dbp:populationEstimateYear ?populationYear . }}
OPTIONAL {{
<{uri}> dbp:populationDensityKm ?populationDensityKm;
dbp:populationDensitySqMi ?populationDensitySqMi . }}
}}
'''.format(uri=uri)
results = _get_results(query)
# Get the names for each leader.
leaders = {}
for leader in [result['leaders'] for result in results if result.get('leaders', None)]:
leaders[leader] = name_for_uri(leader)
profile = None
if results:
profile = results[0]
profile['leaders'] = leaders
profile['types'] = types
services.process(profile, {
'flickr': [
'photos_at_location'
]
})
return profile
def get_company_profile(uri):
"""
Example return value::
{'assets': 'US$ 93.80 billion',
'contributions': [{
'direct_amount': '0',
'direct_count': '0',
'employee_amount': '1602978.00',
'employee_count': '2274',
'id': '4148b26f6f1c437cb50ea9ca4699417a',
'name': 'Barack Obama (D)',
'party': 'D',
'state': '',
'total_amount': '1602978.00',
'total_count': '2274'
}],
'party_contributions': {
'Democrats': ['5157', '6166411.11'],
'Other': ['831', '2022397.43'],
'Republicans': ['1114', '1998822.25']
},
'employees': '53861',
'income': 'US$ 10.74 billion',
'name': 'Google',
'revenue': 'US$ 50.18 billion',
'subsidiaries': [{
'http://dbpedia.org/resource/YouTube': {
'image': 'http://upload.wikimedia.org/wikipedia/commons/e/e8/Logo_Youtube.svg',
'name': 'YouTube'
}
}],
'symbol': 'GOOG',
'sources': ['Influence Explorer']
}
"""
# MISSING
# Perhaps need to be using dbpedia live for this.
#dbo:parentCompany ?children;
#dbo:owningCompany ?owns;
#dbo:board ?board;
#dbo:developer ?products;
#dbo:manufacturer ?moreproducts .
uri = _quote(uri)
query = '''
SELECT *
WHERE {{
<{uri}> rdfs:label ?name;
dbo:subsidiary ?subsidiaries;
dbo:numberOfEmployees ?employees;
dbp:symbol ?symbol;
dbp:assets ?assets;
dbp:netIncome ?income;
dbp:revenue ?revenue .
}}
'''.format(uri=uri)
results = _get_results(query)
# Get the names for each subsidiary.
subsidiaries = {}
for subsidiary in [result['subsidiaries'] for result in results]:
# This should be combined into a single query.
subsidiaries[subsidiary] = {
'name': name_for_uri(subsidiary),
'image': image_for_uri(subsidiary)
}
profile = None
if results:
profile = results[0]
profile['subsidiaries'] = subsidiaries
services.process(
profile, {
'influence_explorer':
['recipients_for_organization', 'parties_for_organization']
})
return profile
