torsdag 4 augusti 2016

People buried on cemetery Norra Begravningsplatsen, Stockholm, Sweden Q252312 and if they have a picture of the grave or not

Document location of all graves and grave pictures on WikiData

Project: Document all people in WikiData buried on Norra Begravningsplatsen and generate a map with exact location of the graves ==> easier to find the graves. Add those people also to FindAGrave and take pictures of grave stones

Norra Begravningsplatsen is a cemetery in Stockholm, Sweden with about 30000 people many famous.....

Wikidata and graves

In WikiData you can also add qualifiers like



Query is ?person wdt:P119 wd:Q252312 #Place of burial

  1. All graves with graveplot and coordinates
  2. All graves with FindAGraveID
  3. All graves with WikiTreeID

Good links

Example queries

# Query Find in WikiData people with Place of Burial Q252312 Norra Begravningsplatsen
# Show Wikitree ID, Find A Grave ID and if picture of the grave exist
select  ?person ?personLabel  ?personDescription   ?pic ?picGrave ?WikiTree ?FindAGrave{
{
  ?person wdt:P119 wd:Q252312 #Place of burial
   OPTIONAL { ?person wdt:P2949 ?WikiTreeID .} # If we have a WikiTree profile
   OPTIONAL { ?person wdt:P535 ?FindAGraveID .} # If we have a FindAGrave ID
   OPTIONAL{ ?person wdt:P18 ?pic .} # If we have an illustration
   OPTIONAL{ ?person wdt:P1442 ?picGrave .} # If we have a picture of the grave
   BIND (URI(CONCAT("http://www.findagrave.com/cgi-bin/fg.cgi?page=gr&df=all&GRid=",?FindAGraveID)) AS ?FindAGrave)

 }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en","sv"}
 }
Order by ?personLabel


Images of graves  P1442 today of people buried on Q252312
Map of graves with coordinates - english
Map - Swedish labels 

# Query Find in WikiData people with Place of Burial Q252312 Norra Begravningsplatsen
# Show Wikitree ID, Find A Grave ID and if picture of the grave exist
#defaultView:Map
select  ?person ?personLabel  ?personDescription  ?graveplot ?coord ?pic ?picGrave ?WikiTree ?FindAGrave{
{
?person wdt:P119 wd:Q252312; #Place of burial
            p:P119 [
              pq:P965 ?graveplot;
              pq:P625 ?coord].                        
   OPTIONAL { ?person wdt:P2949 ?WikiTreeID .} # If we have a WikiTree profile
   OPTIONAL { ?person wdt:P535 ?FindAGraveID .} # If we have a FindAGrave ID
   OPTIONAL{ ?person wdt:P18 ?pic .} # If we have an illustration
   OPTIONAL{ ?person wdt:P1442 ?picGrave .} # If we have a picture of the grave
   BIND (URI(CONCAT("http://www.findagrave.com/cgi-bin/fg.cgi?page=gr&df=all&GRid=",?FindAGraveID)) AS ?FindAGrave)
   BIND (URI(CONCAT("http://www.wikitree.com/wiki",?WikiTreeID)) AS ?WikiTree)

 }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en","sv"}
 }
Order by ?personLabel

Inga kommentarer:

Skicka en kommentar