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)