SBL jmf. Nationalencyklopedin - Norra Begravningsplatsen

Nedan sökning att hitta alla som ligger begravda på Norra Begravningsplatsen och som är kopplade till en artikel i Nationalencyklopedin P3222

Om Wikipedia och /eller SBL artikel finns visas länk exempel Isak Collijn

• Wikipedia Isak_Collijn
• Wikidata Q535764
• Nationalencyklopedin Isak Collijn
• Svenskt biografiskt lexikon artikel 14922 

Nedan sökning Wikidata på alla personer begravda på Norra Begravningsplatsen med artikel kopplad till Nationalencyklopedin = 576 personer

Grabben i graven bredvid

Apple watch möter Wikidata P625

Geografiska koordinater

 

Ovan Apple watch på Norra Begravningsplatsen 

83 meter från Lars Schönanders grav

och

92 meter från Arvid Bergman

Vad som gjorts

V for Wiki på Iphone som visar
närliggande gravar

1. Wikidata
1. Q16650316#P119 har satts till Norra Begravningsplatsen
1. P625 är koordinater för graven
   
   
2. Svenska Wikipedia sidan Lars_Schönander
1. Har Mall:Faktamall_biografi_WD
   
   ==> att gravkoordinaterna finns i Wikipedia artikeln
   
          
   
3. Iphone appen V for Wiki som även fungerar på Apple Watch hämtar koordinaterna från artikeln och visar upp det på klockan

Exempel nedan med en annan Iphone App från Wikipedia

Status Wikipedia - Wikidata - SBL - Norra Begravningsplatsen

1. Wikipedia
1. 1388 artiklar har Kategori:Gravsatta_på_Norra_begravningsplatsen_i_Stockholm 
2. 613 artiklar har Mall Faktamall_biografi_WD 
3. 370 artiklar har en mall som inte stödjer Wikidata koppling
2. Adlig
3. Biskop
4. Författare
5. Hertig
7. Infobox politiker
8. Infobox arkitekt
9. Infobox forskare
10. Infobox konstnär
11. Infobox musiker
12. Infobox Skådespelare
13. Infobox tonsättare
14. Infobox regissör
15. Infobox Militär Person
17. MedaljStart
2. Wikidata 
1. 1380 poster gravort Norra Begravningsplatsen
2. 1452 poster kopplade tillhörande begravningsplatser
1. 17 Romersk-katolska församlingens begravningsplats
2. 26 Minneslunden Norra begravningsplatsen
3. 36 Mosaiska kyrkogården Norra begravningsplatsen 
3. Wikipedia profiler på Norra Begravningsplatsen med Faktamallen WD
4. SBL - Svenskt biografiskt lexikon
1. 460 poster i SBL är kopplade till en motsvarande person i Wikidata som är begravd på Norra Begravningsplatsen se karta nedan

Begravda på Norra Begravningsplatsen med artikel i SBL Svenskt biografiskt lexikon

Uppkallad efter - SBL Svenskt biografiskt lexikon och SKBL

Vilka saker är uppkallade efter personer beskrivna i SBL Svenskt biografiskt lexikon

Property:P138 = uppkallad efter ==>

?person wdt:P3217 ?SBL  # Beskrivna i SBL
?person wdt:P31 wd:Q5   # Personer Q5 och ej släkt
?subj wdt:P138 ?person  # P138 uppkallad efter

OPTIONAL {?subj wdt:P625 ?coord} visa koordinater om det finns

• Sökfrågan
• visas som platser på en Karta
• visa med Bilder
• som en Lista

Överklassen är väl dokumenterade på SBL spontant känns den överrepresenterad. Nedan de villor i Djursholm vars namn kan kopplas ihop med en person som SBL valt att dokumentera...

Sökning i Wikidata efter platser/statyer/byggnader som är uppkallad efter en person i SBL visade på karta - finns mer men det här är vad som finns i Wikidata idag

Samma men för SKBL - Svenskt kvinnobiografiskt lexikon skbl.se

• länk karta
• hos SKBL finns i texten beskrivet när en person har en gata uppkallad efter sig länk några av dessa platser har letats upp och ett objekt har skapats i Wikidata.
• Wikidata i Sverige har idag inte alla gator medans i Holland finns de flesta som objekt i Wikidata med information vem gatan uppkallats efter  

Holland har de flesta gatorna i Wikidata
Sökning gator uppkallade efter en person ==> +11000
där personen är svensk medborgare ==> 9

Se även:

• Uppkallad efter Svensk Filmdatabas +5166 platser
• Uppkalla efter Alvin 
• Uppkallad efter månen

Norra Begravningsplatsen +1900 graves cemetery in Stockholm, Sweden

Swedish Wikipedia with links to Google map and Svenskt Biografiskt Lexikon...

• Graves on a map grouped by occupations v.2
• Map with birth locations for people buried at Norra Begravningsplatsen
• Birth, death buried location
• Graves with Men vs. kvinnor marked - shows gender difference 
• Picture of graves  
• Map with graves that have no pictures in Wikidata
• Graves grouped by timeperiod
• Only graves of people with a spotify artist id connected with link to Spotify (lista)
• Graves were the person has an object on Wikidata he/she has created
• Map of graves
• Image grid
• Map with the location of the objects

Map with filter per occupation
OBS with more people in the same grave just one is seen...
Map with graves with picture of the gravestone http://tinyurl.com/zwyfbn3


Below filter per occupation on the Northern cemetery Q252312 in Stockholm, Sweden

How to filter

Example of filter on Composer

SBL Wikidata P3217

The Dictionary of Swedish National Biography is a biographical dictionary that was first published in 1917. This dictionary is a general list, based on first-hand sources, of significant people and their achievements at various stages in the development of Swedish society.

We have no created a property at WIkidata P3217 that will contain the ID of SBL

• P3217
• Special:ConstraintReport/P3217
• Database_reports/Constraint_violations/P3217
• Reports
• simple query
• more columns
• SBL connected people buried at Norra begravningsplatsen
• Map
• Grave pictures
• SBL
• Most common properties for profiles with SBL
• Birth, Death, Grave locations on  a map
• Gravelocations
• Map
• Pictures Grave
• Musicians
• Instrument
• Occupation P106
• Singer Q177220
• Musician Q639669 
• Genre
• Opera
• Symfoni

• All SBL connected profiles with pictures 1350
• All SBL connected entries graves pictures
• Timeline based on Wikidata but link to SBL

Histropedia
https://goo.gl/TgZKSt - en
https://goo.gl/pn9ooo - sv
https://goo.gl/o9z5fX - sv people in SBL and also Spotify

How to filter
Click upper left on the water drop then right on the countries to display

Display graves on a graveyard grouped by Occupation

http://tinyurl.com/h3sv6nv english
http://tinyurl.com/zxa5vp2 swedish

One person can have more occupations



A Legend is available to the right

Graves are added with Plot references and exact GPS coordinates

Properties set in WikiData used

Query to find occupations for people on this graveyard ==> can clean it 

Place listed on the National Register of Historic Places

• Resullt displayed on a Map
• About National_Register_of_Historic_Places

# Query Find Q19558910 Place listed on the National Register of Historic Places

#
#defaultView:Map
SELECT DISTINCT ?place  ?placeLabel ?coord ?pic ?ref WHERE
{
{
?place wdt:P1435   wd:Q19558910 #Find Heritage status P1435 is Q19558910 Place listed on the National Register of Historic Places
OPTIONAL{?place wdt:P625 ?coord} . #Get the coordinates
OPTIONAL{?place wdt:P18 ?pic} .   #Get a Picture
OPTIONAL{?place wdt:P649 ?refnr} .   #Ref
    BIND(URI(CONCAT("http://focus.nps.gov/AssetDetail/NRIS/",?refnr)) as ?ref)
}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en","fr","nl","de","fa"}
}
Order by ?countryLabel
LIMIT 100000

Map number of items at one place

#Map of all the paintings for which we know a location with the count per location
#defaultView:Map
SELECT ?locationLabel ?coord (count(*) as ?count)
WHERE {
    ?painting wdt:P31 wd:Q3305213 .
    ?painting wdt:P276 ?location .
?location wdt:P625 ?coord
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }      
}
    GROUP BY ?locationLabel ?coord

UNESCO place listed by the UNESCO as of special cultural or physical significance

Wikidata Q9259 is a place listed by the UNESCO as of special cultural or physical significance

==> I do a search I get about 1557 places ==> 

• displayed on a map
• displayed in a table
• displayed with images 

Query asked
?place wdt:P1435  wd:Q9259  #Find Heritage status P1435 is World Heritage Size
OPTIONAL{?place wdt:P625 ?coord} . #Get the coordinates
OPTIONAL{?place wdt:P18 ?pic} . #Get a Picture
OPTIONAL{?place   wdt:P17 ?country} . # Get country

Scientist

More Scientist both on Wikidata and WikiTree

Q901 person engaging in a systematic activity to acquire knowledge that describes and predicts the natural world

• Ex. Nikola Tesla Q9036
• has an P106 occupation   is a Q169470 Physicist 
• that is a Q901 Scientist

==>

?person wdt:P106 ?occupation
?occupation wdt:P279 wd:Q901 # subclass of Scientist

?person wdt:P2747 ?WikiTreeID #person in Wikidata has a link to WikiTree

Query

Result List



Image GalleryLink Image Gallery

Maps

Display on a Map

Nice video about Tesla and Edison

Tesla http://www.wikitree.com/wiki/Tesla-1
Edison http://www.wikitree.com/wiki/Edison-1

Misc

Search different languages lables

# Query Finding all labels for Q299179 emperor of Japan Kōmei
# https://en.wikipedia.org/wiki/List_of_ISO_639-1_codes list of codes
#
select ?s  ?langtag ?label Where
{
  ?s wdt:P31* wd:Q299179 .
  ?s rdfs:label ?label .
  BIND( lang(?label) AS ?langtag)
#  FILTER ( lang(?label) = "en") # get just english
#  FILTER (!(lang(?label) = "en")) # get all except english
#  FILTER ( langMatches(lang(?label),"zh")) #get all chinese version like zh-hans zh-hk
} 
Order by ?langtag

Another search

Noble houses

• Query all people from Noble houses with WikiTree profile 
• Result Timeline
   
• Result Image Grid Order By ?nobelhouseLabel  ?countryLabel ?dateOfBirth
• Image Grid Order By DESC(?dateOfBirth)
• Result List
• Query map all WikiTree people
• Query Imperial House of Japan  Q909452
• Query Imperial House of Japan part 2 
• Timeline Royal House
• Report the House of Windsor ordered by Birth day
• Tweet The sixth most common cause of death for noble people on @wikidata is “horse fall”.
  
  SELECT ?cause ?causeLabel (COUNT(?person) AS ?count)
  WHERE
  {
    ?person wdt:P31 wd:Q5;
            wdt:P509 ?cause;
            wdt:P53 [].
    SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
  }
  GROUP BY ?cause ?causeLabel
  HAVING(?count > 1)
  ORDER BY DESC(?count)
• Longest Running Noble families Query limit 500 years
• Result limit 200 years 

Music 

• Query Organ compositions 

• People in Wikidata/Wikitree who has died by burning

Geography

• Longest river per continent

WikiData

• Properties of the name attribute

• Roman names are complex tweet Query

• Languages in WikiData 284

• Former Capitals in a broader sense also counties etc.....

Family tree

• Family Tree of Ghingis Kahns - Q720
• Graphic Tool
• Query
• Other question { wd:Q720 wdt:P40* ?item } UNION { ?item wdt:P40* wd:Q720 }
   
• Family Tree of Gustav Vasa - Q52947
• Graphic Tool
• Query
• Family Tree of Elizabeth_II - Q9682 
• Graphic Tool 
• Query
• Family Tree of Beethoven - Q255
• Graphic Tool 
• Query
• Family Tree Henry VII - Q675493
• Graphic Tool
• Query
   
• Family Tree Philip II of Spain - Q34417
• Graphic Tool
• Query
• Family Tree George Washington - Q
• Graphic Tool - Q23
• Query

RDF GAS API

Rubens

WikiTree Rubens-1 ==> Wikidata Q5599

Reasonator on Q5599 https://tools.wmflabs.org/reasonator/?q=Q5599

If we then Use SPARQL

Nota Bene: An end user who finds A wikipedia article can always find Wikidata ... and get the Wikidata ID = argument in the Reasonator template {{WikiReasonator|Q5599}} and all the references but the Reasonator is trying to make it easier. Hope it makes sense.... 
  
 

Record at Wikidata Q5599
Wikipedia en ja ....

Some external links from WikiData Q5599

• http://www.getty.edu
• http://www.genealogics.org
• Common gallery
• Art UK
• 

• Query  ?artwork wdt:P170 wd:Q5599 
  • Map
  • Image Gallery

#Locations of Paul Rubens creations
#defaultView:Map
SELECT ?label ?subjDescription ?coord ?subj ?pic ?locLabel ?locDescription  ?MoreInfo WHERE {{
   ?subj wdt:P170 wd:Q5599 . #P170 creator Q5599 Paul Rubens
  OPTIONAL {?subj wdt:P276 ?loc . #P276 is location
    ?loc wdt:P625 ?coord . #P625 coordinate location
} .
  OPTIONAL{?subj wdt:P18 ?pic} .
  OPTIONAL{?subj wdt:P973 ?MoreInfo} .
   ?subj rdfs:label ?label filter (lang(?label) = "en")
}
   SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}

Map location Philadelphia Museum of Art

                

?person wdt:P463 wd:Q266063 #People member of Slovenian Academy of Science and Art

Query URL
People member of Slovenian Academy of Science and Art





# People member of the Slovenian Acedemy of Science and Art on a map with Birth Death and burial locations
# If Wikitree property set you will have a link
#defaultView:Map
Select ?person ?personLabel ?WikiTreeIDf ?pic ?coord ?coord2 ?coord3 ?BirthDate ?DeathDate {
?person wdt:P463 wd:Q266063 # P463 member of Q266063 Slovenien Academi of Science and Art
OPTIONAL {?person wdt:P2949 ?WikiTreeID} # P2949 all Wikidata articles with WikiTree id set
    BIND (URI(CONCAT("http://www.wikitree.com/wiki/",?WikiTreeID)) AS ?WikiTreeIDf)
OPTIONAL {?person wdt:P18 ?pic}
    OPTIONAL {  ?person wdt:P19 ?loc . # P19 Place of Birth
    ?loc wdt:P625 ?coord } .     # Get coordinates from Place of Birth
    OPTIONAL {  ?person wdt:P20 ?loc2 . # P19 Place of Death
    ?loc2 wdt:P625 ?coord2 } .     # Get coordinates from Place of Death
    OPTIONAL {  ?person wdt:P119 ?loc3 . # P19 Place of Burial
    ?loc3 wdt:P625 ?coord3 } .     # Get coordinates from Place of Burial

    OPTIONAL {?person wdt:P569 ?BirthDate}
  OPTIONAL {?person wdt:P570 ?DeathDate}

    SERVICE wikibase:label {bd:serviceParam wikibase:language "en" }
}
ORDER BY ?BirthDate

• Query Timeline

Query people with Slovenien citizenship in WikiData = ?person wdt:P27 wd:Q215

Search on Piast Dynasty in WikiData

Map view

More Piast Dynasty

Map

# People in the Piast Dynasty on a map with Birth Death and burial locations
# If Wikitree property set you will have a link
#defaultView:Map
Select ?person ?personLabel ?WikiTreeIDf ?pic ?coord ?coord2 ?coord3 {
?person wdt:P53 wd:Q201615
OPTIONAL {?person wdt:P2949 ?WikiTreeID} # P2949 all Wikidata articles with WikiTree id set
BIND (URI(CONCAT("http://www.wikitree.com/wiki/",?WikiTreeID)) AS ?WikiTreeIDf)
OPTIONAL {?person wdt:P18 ?pic}

    OPTIONAL {  ?person wdt:P19 ?loc . # P19 Place of Birth
    ?loc wdt:P625 ?coord } .     # Get coordinates from Place of Birth
    OPTIONAL {  ?person wdt:P20 ?loc2 . # P19 Place of Death
    ?loc2 wdt:P625 ?coord2 } .     # Get coordinates from Place of Death
    OPTIONAL {  ?person wdt:P119 ?loc3 . # P19 Place of Burial
    ?loc3 wdt:P625 ?coord3 } .     # Get coordinates from Place of Burial

    SERVICE wikibase:label {bd:serviceParam wikibase:language "en" }
}
ORDER BY DESC(?WikiTreeIDf)

Query
-----

Table query

http://tinyurl.com/jun2t75

Burial places of Wikitree people also connected to Wikidata

#SPARQL query in Wikidata
# Find all people with WikiTreeID => they have a profile in WikiTree
# Display on the map if they have burial place

# In the popup wikdow show illustration from Wikidata and URL to WikiTree
#defaultView:Map
SELECT ?person ?ppicture ?personLabel ?personDescription ?WikiTreeIDf ?FindAGravef ?FBf ?Genealogicsf ?coord3 ?loc3Label WHERE {
{
   ?person wdt:P2949 ?WikiTreeID . # All item with WikiTreeID
   OPTIONAL { ?person  wdt:P535 ?FindAGrave }  # FindAGrave
   OPTIONAL { ?person wdt:P1819 ?Genealogics }  # Genealogics
   OPTIONAL { ?person wdt:P2013 ?FB }   # Facebook
   OPTIONAL {  ?person wdt:P119 ?loc3 . # P19 Place of Burial
    ?loc3 wdt:P625 ?coord3 } .     # Get coordinates from Place of Burial
   OPTIONAL {?person wdt:P18 ?ppicture}         # If Wikidata has a illustration use that

   BIND (URI(CONCAT("http://www.wikitree.com/wiki/",?WikiTreeID)) AS ?WikiTreeIDf)
   BIND (URI(CONCAT("http://www.findagrave.com/cgi-bin/fg.cgi?page=gr&df=all&GRid=",?FindAGrave)) AS ?FindAGravef)
   BIND (URI(CONCAT("http://www.genealogics.org/getperson.php?tree=LEO&personID=",?Genealogics)) AS ?Genealogicsf)
   BIND (URI(CONCAT("https://www.facebook.com/",?FB)) AS ?FBf)
  
}
   SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
LIMIT 10000

-----

* Result

Map with Wikitree profiles birth, death buried locations

Short URL https://goo.gl/Vi0wlX
Query

     

Map All Wikidata with a FindAGrave property but no WikiTree property set

• FindAGrave set P535
• WikiTree set P2949
• FindAGrave set but not WikiTree 24854
• map
• WikiTree set but not FindAGrave 24541
• map

Map FindAGrave records in Wikidata displayed in a map

A map with of birth , dead and buried locations for records in WikiData with the FindAGrave property set
Result new page

Map of people in Wikidata marked with WikiTree attribute

Below a query: people in Wikidata that have a link to WikiTree

Red dot is the location of birth, death or buried..... location data and picture is from Wikidata...

Click on the dot and you will see more info

1. WikiTree
2. FindAGrave
3. Facebook
4. Twitter
5. and to the Wikidata Object for the person...

Video how to add a WikiTreeID to WikiData.... its easy and the benefits will be great for WikiTree....

Query find all mapped WikiTree people

     

Other queries 

US presidents with spouses



US Presidents and spouses with images and link to WikiTree




Astronauts in Wikidata and a link to WIkiTree if a profile exists
ma