for stmt in results.subjects(URIRef("http://www.w3.org/1999/02/22-rdf-syntax-ns#type"), URIRef("http://dbpedia.org/ontology/Building")):
if nProjects%500 == 0:
print nProjects
resource = Resource(results, stmt)
p = Project()
p.owner = User.objects.get(username = "******")
p.name = resource.value(RDFS.label)
p.longitude = resource.value(URIRef("http://www.w3.org/2003/01/geo/wgs84_pos#long"))
p.latitude = resource.value(URIRef("http://www.w3.org/2003/01/geo/wgs84_pos#lat"))
p.wikipedia_page_id = resource.value(URIRef("http://dbpedia.org/ontology/wikiPageID"))
# Retrieve and concatenate all architects names
architects = [architect.value(RDFS.label) for architect in resource[URIRef("http://dbpedia.org/ontology/architect")]]
#.encode('ascii', 'ignore'))
if architects != []:
p.architect = ",".join(architects)
else:
architect = resource.value(URIRef("http://dbpedia.org/property/architect"))
if architect:
if type(architect) == Resource:
p.architect = architect.identifier.encode('ascii', 'ignore')
else:
p.architect = architect.encode('ascii', 'ignore')
else:
for result in results['results']['bindings']:
if nProjects%500 == 0 and nProjects > 0:
print nProjects
wikipedia_page_id = result['wiki_page_id']['value']
if not Project.objects.filter(wikipedia_page_id=wikipedia_page_id).exists():
p = Project()
p.owner = User.objects.get(username = "******")
p.name = result[ 'stripped_structure_name']['value']
p.longitude = result['long']['value']
p.latitude = result['lat']['value']
p.wikipedia_page_id = wikipedia_page_id
p.architect = ''
if result.has_key('architect_prop'):
p.architect = result['architect_prop']['value']
if result.has_key('stripped_architect_name'):
if p.architect != '':
p.architect += ', ' + result['stripped_architect_name']['value']
else:
p.architect = result['stripped_architect_name']['value']
if result.has_key('thumbnail'):
thumb_url = result['thumbnail']['value']
i = thumb_url.rindex('?')
p.wikipedia_image_url = thumb_url[:i]
ten_months = datetime.timedelta(days=300)
